internal HssUtility.SQLserver.DB_update Get_DBupdate()
{
if (!this.CheckValueChanges())
{
return(null);
}
else
{
this.LastModifyAt.Value = DateTime.Now;
}
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(Hss_UserConfig.Get_cmdTP());
if (this.UserName.ValueChanged)
{
upd.AddValue("UserName", this.UserName); /*Optional 2*/
}
if (this.ConfigXML.ValueChanged)
{
upd.AddValue("ConfigXML", this.ConfigXML); /*Optional 3*/
}
if (this.LastModifyAt.ValueChanged)
{
upd.AddValue("LastModifyAt", this.LastModifyAt); /*Optional 4*/
}
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()
{
HssUtility.SQLserver.SQL_relation rela = null;
if (this.pk_ID > 0)
{
rela = new HssUtility.SQLserver.SQL_relation("ID", HssUtility.General.RelationalOperator.Equals, this.ID);
}
else
{
if (UserName.IsValueEmpty)
{
return(false);
}
else
{
rela = new HssUtility.SQLserver.SQL_relation("UserName", HssUtility.General.RelationalOperator.Equals, this.UserName.Value);
}
}
HssUtility.SQLserver.DB_select db_sel = new HssUtility.SQLserver.DB_select(Hss_UserConfig.Get_cmdTP());
db_sel.tableName = "Hss_UserConfig";
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()
{
this.LastModifyAt.Value = DateTime.Now;
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Hss_UserConfig.Get_cmdTP());
dbIns.AddValue("UserName", this.UserName); /*Optional 2*/
dbIns.AddValue("ConfigXML", this.ConfigXML); /*Optional 3*/
dbIns.AddValue("LastModifyAt", this.LastModifyAt); /*Optional 4*/
return(dbIns);
}