/// <summary>
/// 執行 SQL Insert, Update, Delete 指令
/// </summary>
public string NonQuery(string sqlcmd)
{
try
{
db.BeginTrans();
//db.Execute(sqlcmd, DAO.RecordsetOptionEnum.dbDenyWrite);
db.Execute(sqlcmd);
db.CommitTrans();
return("Succeed");
}
catch (Exception e)
{
db.Rollback();
Debug.WriteLine(e.Message);
FileRW.Write(true, Environment.CurrentDirectory + @"\NxESL_Log.txt", $"\r\n{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")} : NonQuery Error : {sqlcmd}");
return("Failed");
}
}
/// <summary>
/// 執行 SQL Insert, Update, Delete 指令
/// </summary>
public string NonQueryDAO(string dbName, string[] sqlcmds)
{
DAO.DBEngine dbe = new DAO.DBEngine();
DAO.Database db = dbe.OpenDatabase(dbName);
try
{
db.BeginTrans();
foreach (string sql in sqlcmds)
{
if (!string.IsNullOrWhiteSpace(sql))
{
db.Execute(sql);
}
}
db.CommitTrans();
}
catch
{
db.Rollback();
return("FAIL");
}
return("OK");
}
