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);
}
