public static List <SPR_file> Get_SRP_fileList(HssStatus status, bool all_flag = false)
{
List <SPR_file> list = new List <SPR_file>();
DB_select selt = new DB_select(SPR_file.Get_cmdTP());
selt.IgnoreColumn("FileBinary");
if (!all_flag)
{
SQL_relation rela = new SQL_relation("Status", RelationalOperator.Equals, (int)status);
selt.SetCondition(rela);
}
DB_reader reader = new DB_reader(selt, Utility.Get_DRWIN_hDB());
while (reader.Read())
{
SPR_file sf = new SPR_file();
sf.Init_from_reader(reader);
list.Add(sf);
}
reader.Close();
return(list);
}
internal HssUtility.SQLserver.DB_update Get_DBupdate()
{
if (!this.CheckValueChanges())
{
return(null);
}
else
{
this.LastModifyAt.Value = DateTime.Now;
this.LastModifyBy.Value = Utility.CurrentUser;
}
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(SPR_file.Get_cmdTP());
if (this.FileName.ValueChanged)
{
upd.AddValue("FileName", this.FileName); /*Optional 2*/
}
if (this.CreateTime.ValueChanged)
{
upd.AddValue("CreateTime", this.CreateTime); /*Optional 3*/
}
if (this.CreateBy.ValueChanged)
{
upd.AddValue("CreateBy", this.CreateBy); /*Optional 5*/
}
if (this.Status.ValueChanged)
{
upd.AddValue("Status", this.Status); /*Optional 6*/
}
if (this.CUSIP.ValueChanged)
{
upd.AddValue("CUSIP", this.CUSIP); /*Optional 7*/
}
if (this.RecordDate.ValueChanged)
{
upd.AddValue("RecordDate", this.RecordDate); /*Optional 8*/
}
if (this.SecurityName.ValueChanged)
{
upd.AddValue("SecurityName", this.SecurityName); /*Optional 9*/
}
if (this.LastModifyAt.ValueChanged)
{
upd.AddValue("LastModifyAt", this.LastModifyAt); /*Optional 10*/
}
if (this.LastModifyBy.ValueChanged)
{
upd.AddValue("LastModifyBy", this.LastModifyBy); /*Optional 11*/
}
if (this.LastModifyAction.ValueChanged)
{
upd.AddValue("LastModifyAction", this.LastModifyAction); /*Optional 12*/
}
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(SPR_file.Get_cmdTP());
db_sel.tableName = "DTCC_FTP_files";
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(SPR_file.Get_cmdTP());
dbIns.AddValue("FileName", this.FileName); /*Optional 2*/
dbIns.AddValue("CreateTime", this.CreateTime); /*Optional 3*/
dbIns.AddValue("FileBinary", this.FileBinary); /*Optional 4*/
dbIns.AddValue("CreateBy", this.CreateBy); /*Optional 5*/
dbIns.AddValue("Status", this.Status); /*Optional 6*/
dbIns.AddValue("CUSIP", this.CUSIP); /*Optional 7*/
dbIns.AddValue("RecordDate", this.RecordDate); /*Optional 8*/
dbIns.AddValue("SecurityName", this.SecurityName); /*Optional 9*/
dbIns.AddValue("LastModifyAt", this.LastModifyAt); /*Optional 10*/
dbIns.AddValue("LastModifyBy", this.LastModifyBy); /*Optional 11*/
dbIns.AddValue("LastModifyAction", this.LastModifyAction); /*Optional 12*/
return(dbIns);
}