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