添加2个接口

13693261870

2024-09-03 3cfb6aa02516135fb174ab1b30620f2007924663

 JiangSu/cs/GridDAL.cs

@@ -51,9 +51,14 @@
            return SQLiteHelper.ExecuteNonQuery(sql);
        }

        public static int DelAll()
        {
            return SQLiteHelper.ExecuteNonQuery("delete from grid");
        }

        public static int Insert(Grid grid)
        {
            string sql = "insert into grid (json) values (@json);select last_insert_rowid();";
            string sql = "insert into grid (json) values (@json); select last_insert_rowid();";
            SQLiteParameter[] sqlParams = Tools.GetSQLiteParams<Grid>(sql, grid);

            object obj = SQLiteHelper.ExecuteScalar(sql, sqlParams);