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