public int Update_to_DB()
{
if (dvdCust == null)
{
return(-1);
}
int count = 0, oneTimeAmount = Bulk_DBcmd.BatchAmount;
DB_update upd = new DB_update(Dividend_Detail_simpleAP.Get_cmdTP());
upd.AddValue("CustodianID", this.dvdCust.CustodianID);
List <int> detailID_list = new List <int>(oneTimeAmount);
foreach (Dividend_Detail_simpleAP dd in this.dd_list)
{
detailID_list.Add(dd.DetailID);
if (detailID_list.Count >= oneTimeAmount)
{
upd.SetCondition(new SQL_relation("DetailID", true, detailID_list));
count += upd.SaveToDB(Utility.Get_DRWIN_hDB());
detailID_list.Clear();
}
}
if (detailID_list.Count > 0)
{
upd.SetCondition(new SQL_relation("DetailID", true, detailID_list));
count += upd.SaveToDB(Utility.Get_DRWIN_hDB());
}
return(count);
}
public List <Dividend_Detail_simpleAP> Get_dvdDetailAP_list(string reclaimFeeType)
{
List <Dividend_Detail_simpleAP> list = new List <Dividend_Detail_simpleAP>();
DB_select selt = new DB_select(Dividend_Detail_simpleAP.Get_cmdTP());
SQL_relation rela0 = new SQL_relation("DividendIndex", RelationalOperator.Equals, this.DividendIndex);
if (string.IsNullOrEmpty(reclaimFeeType))
{
selt.SetCondition(rela0);
}
else
{
SQL_relation rela1 = new SQL_relation("ReclaimFeesType", RelationalOperator.Equals, reclaimFeeType);
SQL_condition cond = new SQL_condition(rela0, ConditionalOperator.And, rela1);
selt.SetCondition(cond);
}
DB_reader reader = new DB_reader(selt, Utility.Get_DRWIN_hDB());
while (reader.Read())
{
Dividend_Detail_simpleAP dd = new Dividend_Detail_simpleAP();
dd.Init_from_reader(reader);
list.Add(dd);
}
reader.Close();
return(list);
}
