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);
}
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);
}