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