public static void Init_from_DB() { if ((DateTime.Now - DTCpositionHeader_master.lastUpdateTime).TotalHours < Utility.RefreshInterval) { return; } DTCpositionHeader_master.Reset(); DB_select selt = new DB_select(DTC_Position_Headers.Get_cmdTP()); DB_reader reader = new DB_reader(selt, Utility.Get_DRWIN_hDB()); while (reader.Read()) { DTC_Position_Headers dph = new DTC_Position_Headers(); dph.Init_from_reader(reader); if (!DTCpositionHeader_master.modelNum_dic.ContainsKey(dph.ModelNumber.Value)) { List <DTC_Position_Headers> list = new List <DTC_Position_Headers>(); DTCpositionHeader_master.modelNum_dic[dph.ModelNumber.Value] = list; } DTCpositionHeader_master.modelNum_dic[dph.ModelNumber.Value].Add(dph); } reader.Close(); DTCpositionHeader_master.lastUpdateTime = DateTime.Now; }
public DTC_Position_Headers GetCopy() { DTC_Position_Headers newEntity = new DTC_Position_Headers(); if (!this.ModelNumber.IsNull_flag) { newEntity.ModelNumber.Value = this.ModelNumber.Value; } if (!this.Country.IsNull_flag) { newEntity.Country.Value = this.Country.Value; } if (!this.Column_Header_Name.IsNull_flag) { newEntity.Column_Header_Name.Value = this.Column_Header_Name.Value; } if (!this.Table_Column.IsNull_flag) { newEntity.Table_Column.Value = this.Table_Column.Value; } if (!this.Rate_Desc.IsNull_flag) { newEntity.Rate_Desc.Value = this.Rate_Desc.Value; } if (!this.WHRate.IsNull_flag) { newEntity.WHRate.Value = this.WHRate.Value; } if (!this.ArmorColumn.IsNull_flag) { newEntity.ArmorColumn.Value = this.ArmorColumn.Value; } if (!this.Category.IsNull_flag) { newEntity.Category.Value = this.Category.Value; } if (!this.DiscloseType.IsNull_flag) { newEntity.DiscloseType.Value = this.DiscloseType.Value; } if (!this.SortOrder.IsNull_flag) { newEntity.SortOrder.Value = this.SortOrder.Value; } if (!this.ChargeBackFrom.IsNull_flag) { newEntity.ChargeBackFrom.Value = this.ChargeBackFrom.Value; } if (!this.LastModifiedBy.IsNull_flag) { newEntity.LastModifiedBy.Value = this.LastModifiedBy.Value; } if (!this.ModifiedDateTime.IsNull_flag) { newEntity.ModifiedDateTime.Value = this.ModifiedDateTime.Value; } return(newEntity); }
internal HssUtility.SQLserver.DB_update Get_DBupdate() { if (!this.CheckValueChanges()) { return(null); } HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(DTC_Position_Headers.Get_cmdTP()); if (this.ModelNumber.ValueChanged) { upd.AddValue("ModelNumber", this.ModelNumber); } if (this.Country.ValueChanged) { upd.AddValue("Country", this.Country); } if (this.Column_Header_Name.ValueChanged) { upd.AddValue("Column_Header_Name", this.Column_Header_Name); } if (this.Table_Column.ValueChanged) { upd.AddValue("Table_Column", this.Table_Column); } if (this.Rate_Desc.ValueChanged) { upd.AddValue("Rate_Desc", this.Rate_Desc); } if (this.WHRate.ValueChanged) { upd.AddValue("WHRate", this.WHRate); } if (this.ArmorColumn.ValueChanged) { upd.AddValue("ArmorColumn", this.ArmorColumn); } if (this.Category.ValueChanged) { upd.AddValue("Category", this.Category); } if (this.DiscloseType.ValueChanged) { upd.AddValue("DiscloseType", this.DiscloseType); } if (this.SortOrder.ValueChanged) { upd.AddValue("SortOrder", this.SortOrder); } if (this.ChargeBackFrom.ValueChanged) { upd.AddValue("ChargeBackFrom", this.ChargeBackFrom); } if (this.LastModifiedBy.ValueChanged) { upd.AddValue("LastModifiedBy", this.LastModifiedBy); } if (this.ModifiedDateTime.ValueChanged) { upd.AddValue("ModifiedDateTime", this.ModifiedDateTime); } HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("ID", HssUtility.General.RelationalOperator.Equals, this.pk_ID); upd.SetCondition(rela); return(upd); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(DTC_Position_Headers.Get_cmdTP()); dbIns.AddValue("ModelNumber", this.ModelNumber.Value); dbIns.AddValue("Country", this.Country.Value); dbIns.AddValue("Column_Header_Name", this.Column_Header_Name.Value); dbIns.AddValue("Table_Column", this.Table_Column.Value); dbIns.AddValue("Rate_Desc", this.Rate_Desc); /*Optional 6*/ dbIns.AddValue("WHRate", this.WHRate); /*Optional 7*/ dbIns.AddValue("ArmorColumn", this.ArmorColumn); /*Optional 8*/ dbIns.AddValue("Category", this.Category.Value); dbIns.AddValue("DiscloseType", this.DiscloseType.Value); dbIns.AddValue("SortOrder", this.SortOrder.Value); dbIns.AddValue("ChargeBackFrom", this.ChargeBackFrom); /*Optional 12*/ dbIns.AddValue("LastModifiedBy", this.LastModifiedBy); /*Optional 13*/ dbIns.AddValue("ModifiedDateTime", this.ModifiedDateTime); /*Optional 14*/ return(dbIns); }
/// <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(DTC_Position_Headers.Get_cmdTP()); db_sel.tableName = "DTC_Position_Headers"; 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); }