public ADR_Member_Country GetCopy()
{
ADR_Member_Country newEntity = new ADR_Member_Country();
if (!this.TaskOwner_SID.IsNull_flag)
{
newEntity.TaskOwner_SID.Value = this.TaskOwner_SID.Value;
}
if (!this.ISO2CntryCode.IsNull_flag)
{
newEntity.ISO2CntryCode.Value = this.ISO2CntryCode.Value;
}
return(newEntity);
}
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);
}
