public IActionResult Delete([FromRoute] int Id) { int count = 0; using (DBTransactionController trans = dbCollection.Current.BeginTrans()) { GroupDataService groupService = DataService.Get <GroupDataService>(dbCollection.Current); TestDataItemService itemService = DataService.Get <TestDataItemService>(dbCollection.Current); itemService.Delete(itemService.ItemsTable, new object[] { td.Field("GroupId") == Id }, trans); count = groupService.Delete(groupService.tableName, new object[] { td.Field("GroupId") == Id }, trans); if (count > 0) { trans.Commit(); } } if (count < 1) { return(Json(new WebApiResult <object> { code = ResultCode.STATE_FAIL, message = "删除信息删除失败!" })); } return(Json(new WebApiResult <object> { code = ResultCode.STATE_OK, message = string.Empty })); }
public bool DeleteData(object[] filters) { int result = -1; using (DBTransactionController Trans = DataEngine.CurrentEngine.BeginTrans()) { DbCommandBuilder Command = new DbCommandBuilder(); Command.Delete(fm.Table(TABLE_NAME)).Where(td.Field("TestId").In(filters)); result = Trans.DBA.ExecuteNoneQuery(Command); Trans.Commit(); } return(result > 0); }
public bool SaveData(Dictionary <string, object> data) { bool ok = false; using (DBTransactionController trans = DataEngine.CurrentEngine.BeginTrans()) { if (data.ContainsKey("TestId")) { ok = UpdateData(data, trans); } else { ok = AddData(data, trans); } trans.Commit(); } return(ok); }
public void SQLite3() { Debug.WriteLine(""); Debug.WriteLine("SQLite3 -----------------"); DataEngine db = GetDbContext("sqlite3", useConnectionPool: false); using (DBTransactionController trans = db.BeginTrans()) { bool success = ExecuteCreateTable(TestExecutePattern.InTransaction, db, table_categories, trans); if (success) { success = ExecuteCreateTable(TestExecutePattern.InTransaction, db, table_products, trans); } if (success) { trans.Commit(); } } }
public void PostgreSQL() { Debug.WriteLine(""); Debug.WriteLine("PostgreSQL -----------------"); DataEngine db = GetDbContext("npgsql"); using (DBTransactionController trans = db.BeginTrans()) { bool success = ExecuteCreateTable(TestExecutePattern.InTransaction, db, table_categories, trans); if (success) { success = ExecuteCreateTable(TestExecutePattern.InTransaction, db, table_products, trans); } if (success) { trans.Commit(); } } ReleaseDb(db); }