private static void Init_owner_dic()
{
DB_select selt = new DB_select(ADR_TaskOwner.Get_cmdTP());
DB_reader reader = new DB_reader(selt, Utility.Get_DRWIN_hDB());
while (reader.Read())
{
ADR_TaskOwner ato = new ADR_TaskOwner();
ato.Init_from_reader(reader);
string ownerSID = ato.OwnerSID.Value;
TaskMemberMaster.owner_dic[ownerSID] = ato;
if (!TaskMemberMaster.groupMember_dic.ContainsKey(ownerSID))
{
continue;
}
int groupID = TaskMemberMaster.groupMember_dic[ownerSID].GroupID.Value;
if (!TaskMemberMaster.ownerList_dic.ContainsKey(groupID))
{
Dictionary <string, ADR_TaskOwner> dic = new Dictionary <string, ADR_TaskOwner>(StringComparer.OrdinalIgnoreCase);
TaskMemberMaster.ownerList_dic[groupID] = dic;
}
TaskMemberMaster.ownerList_dic[groupID][ato.OwnerSID.Value] = ato;
}
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_TaskOwner.Get_cmdTP());
if (this.OwnerSID.ValueChanged)
{
upd.AddValue("OwnerSID", this.OwnerSID);
}
if (this.OwnerName.ValueChanged)
{
upd.AddValue("OwnerName", this.OwnerName);
}
if (this.Owner_LastName.ValueChanged)
{
upd.AddValue("Owner_LastName", this.Owner_LastName);
}
if (this.Owner_FirstName.ValueChanged)
{
upd.AddValue("Owner_FirstName", this.Owner_FirstName);
}
//if (this.AllProperties.ValueChanged) upd.AddValue("AllProperties", this.AllProperties);
if (this.Telephone.ValueChanged)
{
upd.AddValue("Telephone", this.Telephone);
}
if (this.Email.ValueChanged)
{
upd.AddValue("Email", this.Email);
}
if (this.Department.ValueChanged)
{
upd.AddValue("Department", this.Department);
}
if (this.Title.ValueChanged)
{
upd.AddValue("Title", this.Title);
}
//if (this.Signature.ValueChanged) upd.AddValue("Signature", this.Signature);
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("OwnerID", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
upd.SetCondition(rela);
return(upd);
}
public ADR_TaskOwner GetCopy()
{
ADR_TaskOwner newEntity = new ADR_TaskOwner();
if (!this.OwnerSID.IsNull_flag)
{
newEntity.OwnerSID.Value = this.OwnerSID.Value;
}
if (!this.OwnerName.IsNull_flag)
{
newEntity.OwnerName.Value = this.OwnerName.Value;
}
if (!this.Owner_LastName.IsNull_flag)
{
newEntity.Owner_LastName.Value = this.Owner_LastName.Value;
}
if (!this.Owner_FirstName.IsNull_flag)
{
newEntity.Owner_FirstName.Value = this.Owner_FirstName.Value;
}
//if (!this.AllProperties.IsNull_flag) newEntity.AllProperties.Value = this.AllProperties.Value;
if (!this.Telephone.IsNull_flag)
{
newEntity.Telephone.Value = this.Telephone.Value;
}
if (!this.Email.IsNull_flag)
{
newEntity.Email.Value = this.Email.Value;
}
if (!this.Department.IsNull_flag)
{
newEntity.Department.Value = this.Department.Value;
}
if (!this.Title.IsNull_flag)
{
newEntity.Title.Value = this.Title.Value;
}
//if (!this.Signature.IsNull_flag) newEntity.Signature.Value = this.Signature.Value;
return(newEntity);
}
/// <summary>
/// Initialize object from DB
/// </summary>
public bool Init_from_DB()
{
if (this.OwnerID < 0)
{
return(false);
}
HssUtility.SQLserver.DB_select db_sel = new HssUtility.SQLserver.DB_select(ADR_TaskOwner.Get_cmdTP());
db_sel.tableName = "ADR_TaskOwner";
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("OwnerID", HssUtility.General.RelationalOperator.Equals, this.OwnerID);
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_TaskOwner.Get_cmdTP());
dbIns.AddValue("OwnerSID", this.OwnerSID.Value);
dbIns.AddValue("OwnerName", this.OwnerName.Value);
dbIns.AddValue("Owner_LastName", this.Owner_LastName); /*Optional 4*/
dbIns.AddValue("Owner_FirstName", this.Owner_FirstName); /*Optional 5*/
//dbIns.AddValue("AllProperties", this.AllProperties);/*Optional 6*/
dbIns.AddValue("Telephone", this.Telephone); /*Optional 7*/
dbIns.AddValue("Email", this.Email); /*Optional 8*/
dbIns.AddValue("Department", this.Department); /*Optional 9*/
dbIns.AddValue("Title", this.Title); /*Optional 10*/
//dbIns.AddValue("Signature", this.Signature);/*Optional 11*/
return(dbIns);
}