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