internal HssUtility.SQLserver.DB_update Get_DBupdate() { if (!this.CheckValueChanges()) { return(null); } HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(EDI_country.Get_cmdTP()); if (this.name.ValueChanged) { upd.AddValue("name", this.name); } if (this.currency_id.ValueChanged) { upd.AddValue("currency_id", this.currency_id); } if (this.iso2_cd.ValueChanged) { upd.AddValue("iso2_cd", this.iso2_cd); } if (this.iso3_cd.ValueChanged) { upd.AddValue("iso3_cd", this.iso3_cd); } HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("cntry_cd", HssUtility.General.RelationalOperator.Equals, this.pk_ID); upd.SetCondition(rela); return(upd); }
public static void Init_from_DB() { if ((DateTime.Now - EDIcountryMaster.lastUpdateTime).TotalHours < Utility.RefreshInterval) { return; } EDIcountryMaster.Reset(); DB_select selt = new DB_select(EDI_country.Get_cmdTP()); DB_reader reader = new DB_reader(selt, Utility.Get_DRWIN_hDB()); while (reader.Read()) { EDI_country cty = new EDI_country(); cty.Init_from_reader(reader); EDIcountryMaster.name_dic[cty.name.Value] = cty; EDIcountryMaster.iso2_dic[cty.iso2_cd.Value] = cty; EDIcountryMaster.iso3_dic[cty.iso3_cd.Value] = cty; } reader.Close(); EDIcountryMaster.lastUpdateTime = DateTime.Now; }
public static StatutoryRate_edi GetRate_from_country(string countryName, DateTime curr_dt) { EDI_country cty = EDIcountryMaster.Get_EDI_country(countryName); if (cty == null) { return(null); } else { return(RateMaster_edi.GetRate_from_coi(cty.cntry_cd, curr_dt)); } }
public static EDI_times GetRate_from_country(string countryName, DateTime curr_dt) { EDI_country cty = EDIcountryMaster.Get_EDI_country(countryName); if (cty == null) { return(null); } else { return(EDItime_master.GetTimes_from_ccd(cty.cntry_cd, curr_dt)); } }
public EDI_country GetCopy() { EDI_country newEntity = new EDI_country(); if (!this.name.IsNull_flag) { newEntity.name.Value = this.name.Value; } if (!this.currency_id.IsNull_flag) { newEntity.currency_id.Value = this.currency_id.Value; } if (!this.iso2_cd.IsNull_flag) { newEntity.iso2_cd.Value = this.iso2_cd.Value; } if (!this.iso3_cd.IsNull_flag) { newEntity.iso3_cd.Value = this.iso3_cd.Value; } return(newEntity); }
/// <summary> /// Initialize object from DB /// </summary> public bool Init_from_DB() { if (string.IsNullOrEmpty(this.cntry_cd)) { return(false); } HssUtility.SQLserver.DB_select db_sel = new HssUtility.SQLserver.DB_select(EDI_country.Get_cmdTP()); db_sel.tableName = "edi_cntrytable"; HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("cntry_cd", HssUtility.General.RelationalOperator.Equals, this.cntry_cd); 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(EDI_country.Get_cmdTP()); dbIns.AddValue("name", this.name); /*Optional 2*/ dbIns.AddValue("currency_id", this.currency_id); /*Optional 3*/ dbIns.AddValue("iso2_cd", this.iso2_cd); /*Optional 4*/ dbIns.AddValue("iso3_cd", this.iso3_cd); /*Optional 5*/ return(dbIns); }