public static List <DividendXBRL> GetList_refNo(string refNo)
{
List <DividendXBRL> dxList = new List <DividendXBRL>();
if (string.IsNullOrEmpty(refNo))
{
return(dxList);
}
DB_select selt = new DB_select(DividendXBRL.Get_cmdTP());
SQL_relation rela = new SQL_relation("XBRL_ReferenceNumber", RelationalOperator.Equals, refNo);
selt.SetCondition(rela);
DB_reader reader = new DB_reader(selt, Utility.Get_DRWIN_hDB());
while (reader.Read())
{
DividendXBRL dx = new DividendXBRL();
dx.Init_from_reader(reader);
dxList.Add(dx);
}
reader.Close();
return(dxList);
}
internal HssUtility.SQLserver.DB_update Get_DBupdate()
{
if (!this.CheckValueChanges())
{
return(null);
}
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(DividendXBRL.Get_cmdTP());
if (this.DividendIndex.ValueChanged)
{
upd.AddValue("DividendIndex", this.DividendIndex);
}
if (this.Depositary.ValueChanged)
{
upd.AddValue("Depositary", this.Depositary); /*Optional 3*/
}
if (this.XBRL_ReferenceNumber.ValueChanged)
{
upd.AddValue("XBRL_ReferenceNumber", this.XBRL_ReferenceNumber);
}
if (this.PSAFE.ValueChanged)
{
upd.AddValue("PSAFE", this.PSAFE); /*Optional 5*/
}
if (this.LastModifiedDate.ValueChanged)
{
upd.AddValue("LastModifiedDate", this.LastModifiedDate); /*Optional 6*/
}
if (this.SourceType.ValueChanged)
{
upd.AddValue("SourceType", this.SourceType); /*Optional 7*/
}
if (this.LastModifiedBy.ValueChanged)
{
upd.AddValue("LastModifiedBy", this.LastModifiedBy); /*Optional 8*/
}
if (this.Announcement_Identifier.ValueChanged)
{
upd.AddValue("Announcement Identifier", this.Announcement_Identifier); /*Optional 9*/
}
if (this.Event_Completeness.ValueChanged)
{
upd.AddValue("Event Completeness", this.Event_Completeness); /*Optional 10*/
}
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("XBRL_ID", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
upd.SetCondition(rela);
return(upd);
}
public DividendXBRL GetCopy()
{
DividendXBRL newEntity = new DividendXBRL();
if (!this.DividendIndex.IsNull_flag)
{
newEntity.DividendIndex.Value = this.DividendIndex.Value;
}
if (!this.Depositary.IsNull_flag)
{
newEntity.Depositary.Value = this.Depositary.Value;
}
if (!this.XBRL_ReferenceNumber.IsNull_flag)
{
newEntity.XBRL_ReferenceNumber.Value = this.XBRL_ReferenceNumber.Value;
}
if (!this.PSAFE.IsNull_flag)
{
newEntity.PSAFE.Value = this.PSAFE.Value;
}
if (!this.LastModifiedDate.IsNull_flag)
{
newEntity.LastModifiedDate.Value = this.LastModifiedDate.Value;
}
if (!this.SourceType.IsNull_flag)
{
newEntity.SourceType.Value = this.SourceType.Value;
}
if (!this.LastModifiedBy.IsNull_flag)
{
newEntity.LastModifiedBy.Value = this.LastModifiedBy.Value;
}
if (!this.Announcement_Identifier.IsNull_flag)
{
newEntity.Announcement_Identifier.Value = this.Announcement_Identifier.Value;
}
if (!this.Event_Completeness.IsNull_flag)
{
newEntity.Event_Completeness.Value = this.Event_Completeness.Value;
}
return(newEntity);
}
public static DividendXBRL Get_dvdXBRL(string refNo, int dvdIndex)
{
DB_select selt = new DB_select(DividendXBRL.Get_cmdTP());
SQL_relation rela0 = new SQL_relation("XBRL_ReferenceNumber", RelationalOperator.Equals, refNo);
SQL_relation rela1 = new SQL_relation("DividendIndex", RelationalOperator.Equals, dvdIndex);
selt.SetCondition(new SQL_condition(rela0, ConditionalOperator.And, rela1));
DividendXBRL dx = null;
DB_reader reader = new DB_reader(selt, Utility.Get_DRWIN_hDB());
if (reader.Read())
{
dx = new DividendXBRL();
dx.Init_from_reader(reader);
}
reader.Close();
return(dx);
}
public static List <DividendXBRL> GetList_dvdIndex(int dvdIndex)
{
List <DividendXBRL> dxList = new List <DividendXBRL>();
DB_select selt = new DB_select(DividendXBRL.Get_cmdTP());
SQL_relation rela = new SQL_relation("DividendIndex", RelationalOperator.Equals, dvdIndex);
selt.SetCondition(rela);
DB_reader reader = new DB_reader(selt, Utility.Get_DRWIN_hDB());
while (reader.Read())
{
DividendXBRL dx = new DividendXBRL();
dx.Init_from_reader(reader);
dxList.Add(dx);
}
reader.Close();
return(dxList);
}
/// <summary>
/// Initialize object from DB
/// </summary>
public bool Init_from_DB()
{
if (this.XBRL_ID < 0)
{
return(false);
}
HssUtility.SQLserver.DB_select db_sel = new HssUtility.SQLserver.DB_select(DividendXBRL.Get_cmdTP());
db_sel.tableName = "Dividend_XBRL";
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("XBRL_ID", HssUtility.General.RelationalOperator.Equals, this.XBRL_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(DividendXBRL.Get_cmdTP());
dbIns.AddValue("DividendIndex", this.DividendIndex);
dbIns.AddValue("Depositary", this.Depositary); /*Optional 3*/
dbIns.AddValue("XBRL_ReferenceNumber", this.XBRL_ReferenceNumber);
dbIns.AddValue("PSAFE", this.PSAFE); /*Optional 5*/
dbIns.AddValue("LastModifiedDate", this.LastModifiedDate); /*Optional 6*/
dbIns.AddValue("SourceType", this.SourceType); /*Optional 7*/
dbIns.AddValue("LastModifiedBy", this.LastModifiedBy); /*Optional 8*/
dbIns.AddValue("Announcement Identifier", this.Announcement_Identifier); /*Optional 9*/
dbIns.AddValue("Event Completeness", this.Event_Completeness); /*Optional 10*/
return(dbIns);
}