private static void Init_country_dic() { DB_select selt = new DB_select(ADR_Member_Country.Get_cmdTP()); DB_reader reader = new DB_reader(selt, Utility.Get_DRWIN_hDB()); while (reader.Read()) { ADR_Member_Country amc = new ADR_Member_Country(); amc.Init_from_reader(reader); if (!TaskMemberMaster.country_dic.ContainsKey(amc.TaskOwner_SID.Value)) { List <ADR_Member_Country> list = new List <ADR_Member_Country>(); TaskMemberMaster.country_dic[amc.TaskOwner_SID.Value] = list; } TaskMemberMaster.country_dic[amc.TaskOwner_SID.Value].Add(amc); } reader.Close(); }
internal HssUtility.SQLserver.DB_update Get_DBupdate() { if (!this.CheckValueChanges()) { return(null); } HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(ADR_Member_Country.Get_cmdTP()); if (this.TaskOwner_SID.ValueChanged) { upd.AddValue("TaskOwner_SID", this.TaskOwner_SID); } if (this.ISO2CntryCode.ValueChanged) { upd.AddValue("ISO2CntryCode", this.ISO2CntryCode); } 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(ADR_Member_Country.Get_cmdTP()); db_sel.tableName = "ADR_Member_Country"; 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(ADR_Member_Country.Get_cmdTP()); dbIns.AddValue("TaskOwner_SID", this.TaskOwner_SID.Value); dbIns.AddValue("ISO2CntryCode", this.ISO2CntryCode.Value); return(dbIns); }