/*^^^^^^^^^^^^^^^^^^^^^^^^^^^^^Hss Entity Framework Auto Generated Code^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^*/ /// <summary> /// Lock or Unlock an record /// </summary> /// <param name="lock_flag">lock or unlock flag</param> /// <param name="success_flag">when unlock, indicate if it's successful</param> public bool UpdateRecordLock(bool lock_flag, bool success_flag = false) { HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(Hss_DailyJobs.Get_cmdTP()); if (lock_flag) { upd.AddValue("LastLockAt", DateTime.Now); upd.AddValue("LastLockBy", Utility.CurrentUser); } else { if (success_flag) { upd.AddValue("LastRunAt", DateTime.Now); upd.AddValue("LastRunBy", Utility.CurrentUser); } } upd.AddValue("Locked", lock_flag);//set lock value HssUtility.SQLserver.SQL_relation rela0 = new HssUtility.SQLserver.SQL_relation("ID", HssUtility.General.RelationalOperator.Equals, this.pk_ID); HssUtility.SQLserver.SQL_relation rela1 = new HssUtility.SQLserver.SQL_relation("Locked", HssUtility.General.RelationalOperator.Equals, !lock_flag); HssUtility.SQLserver.SQL_condition cond = new HssUtility.SQLserver.SQL_condition(rela0, HssUtility.General.ConditionalOperator.And, rela1); upd.SetCondition(cond); int count = upd.SaveToDB(Utility.Get_DRWIN_hDB()); bool flag = count > 0; return(flag); }
public static Hss_DailyJobs GetJob_class_id(string jobClass, int jobID) { if (string.IsNullOrEmpty(jobClass)) { return(null); } DB_select selt = new DB_select(Hss_DailyJobs.Get_cmdTP()); SQL_relation rela0 = new SQL_relation("Job_Class", RelationalOperator.Equals, jobClass); SQL_relation rela1 = new SQL_relation("Job_ID", RelationalOperator.Equals, jobID); selt.SetCondition(new SQL_condition(rela0, ConditionalOperator.And, rela1)); Hss_DailyJobs hdj = null; DB_reader reader = new DB_reader(selt, Utility.Get_DRWIN_hDB()); if (reader.Read()) { hdj = new Hss_DailyJobs(); hdj.Init_from_reader(reader); } reader.Close(); return(hdj); }
public static List <Hss_DailyJobs> GetAllJobs() { List <Hss_DailyJobs> list = new List <Hss_DailyJobs>(); DB_select selt = new DB_select(Hss_DailyJobs.Get_cmdTP()); DB_reader reader = new DB_reader(selt, Utility.Get_DRWIN_hDB()); while (reader.Read()) { Hss_DailyJobs hdj = new Hss_DailyJobs(); hdj.Init_from_reader(reader); list.Add(hdj); } reader.Close(); return(list); }
internal HssUtility.SQLserver.DB_update Get_DBupdate() { if (!this.CheckValueChanges()) { return(null); } HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(Hss_DailyJobs.Get_cmdTP()); if (this.Job_Class.ValueChanged) { upd.AddValue("Job_Class", this.Job_Class); /*Optional 2*/ } if (this.Job_ID.ValueChanged) { upd.AddValue("Job_ID", this.Job_ID); /*Optional 3*/ } if (this.LastRunAt.ValueChanged) { upd.AddValue("LastRunAt", this.LastRunAt); /*Optional 4*/ } if (this.LastRunBy.ValueChanged) { upd.AddValue("LastRunBy", this.LastRunBy); /*Optional 5*/ } if (this.Locked.ValueChanged) { upd.AddValue("Locked", this.Locked); /*Optional 6*/ } if (this.Notes.ValueChanged) { upd.AddValue("Notes", this.Notes); /*Optional 7*/ } if (this.LastLockAt.ValueChanged) { upd.AddValue("LastLockAt", this.LastLockAt); /*Optional 8*/ } if (this.LastLockBy.ValueChanged) { upd.AddValue("LastLockBy", this.LastLockBy); /*Optional 9*/ } HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("ID", HssUtility.General.RelationalOperator.Equals, this.pk_ID); upd.SetCondition(rela); return(upd); }
/// <summary> /// Initialize object from DB /// </summary> public bool Init_from_DB() { if (this.ID < 0) { return(false); } HssUtility.SQLserver.DB_select db_sel = new HssUtility.SQLserver.DB_select(Hss_DailyJobs.Get_cmdTP()); db_sel.tableName = "Hss_DailyJobs"; HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("ID", HssUtility.General.RelationalOperator.Equals, this.ID); db_sel.SetCondition(rela); bool res_flag = false; HssUtility.SQLserver.DB_reader reader = new HssUtility.SQLserver.DB_reader(db_sel, Utility.Get_DRWIN_hDB()); if (reader.Read()) { this.Init_from_reader(reader); res_flag = true; } reader.Close(); return(res_flag); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Hss_DailyJobs.Get_cmdTP()); dbIns.AddValue("Job_Class", this.Job_Class); /*Optional 2*/ dbIns.AddValue("Job_ID", this.Job_ID); /*Optional 3*/ dbIns.AddValue("LastRunAt", this.LastRunAt); /*Optional 4*/ dbIns.AddValue("LastRunBy", this.LastRunBy); /*Optional 5*/ dbIns.AddValue("Locked", this.Locked); /*Optional 6*/ dbIns.AddValue("Notes", this.Notes); /*Optional 7*/ dbIns.AddValue("LastLockAt", this.LastLockAt); /*Optional 8*/ dbIns.AddValue("LastLockBy", this.LastLockBy); /*Optional 9*/ return(dbIns); }