private static void Init_groupMember_dic()
{
DB_select selt = new DB_select(ADR_Group_Member.Get_cmdTP());
DB_reader reader = new DB_reader(selt, Utility.Get_DRWIN_hDB());
while (reader.Read())
{
ADR_Group_Member agm = new ADR_Group_Member();
agm.Init_from_reader(reader);
TaskMemberMaster.groupMember_dic[agm.OwnerSID.Value] = agm;
}
reader.Close();
}
public ADR_Group_Member GetCopy()
{
ADR_Group_Member newEntity = new ADR_Group_Member();
if (!this.GroupID.IsNull_flag)
{
newEntity.GroupID.Value = this.GroupID.Value;
}
if (!this.OwnerSID.IsNull_flag)
{
newEntity.OwnerSID.Value = this.OwnerSID.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(ADR_Group_Member.Get_cmdTP());
if (this.GroupID.ValueChanged)
{
upd.AddValue("GroupID", this.GroupID);
}
if (this.OwnerSID.ValueChanged)
{
upd.AddValue("OwnerSID", this.OwnerSID);
}
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_Group_Member.Get_cmdTP());
db_sel.tableName = "ADR_Group_Member";
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_Group_Member.Get_cmdTP());
dbIns.AddValue("GroupID", this.GroupID.Value);
dbIns.AddValue("OwnerSID", this.OwnerSID.Value);
return(dbIns);
}