public int Delete_CustodianID_dvdDetail(string reclaimFeeType) { DB_update upd = new DB_update(Dividend_Detail_full.Get_cmdTP()); upd.AddNull("CustodianID"); SQL_relation rela0 = new SQL_relation("DividendIndex", RelationalOperator.Equals, this.DividendIndex); if (string.IsNullOrEmpty(reclaimFeeType)) { upd.SetCondition(rela0); } else { SQL_relation rela1 = new SQL_relation("ReclaimFeesType", RelationalOperator.Equals, reclaimFeeType); SQL_condition cond = new SQL_condition(rela0, ConditionalOperator.And, rela1); upd.SetCondition(cond); } Helper_SQLserver.AllTrigers("Dividend_Detail", false, Utility.Get_DRWIN_hDB()); int count = upd.SaveToDB(Utility.Get_DRWIN_hDB()); Helper_SQLserver.AllTrigers("Dividend_Detail", true, Utility.Get_DRWIN_hDB()); return(count); }
public int Update_to_DB() { int count = 0; if (Utility.Is_DWRIN_admin()) { Helper_SQLserver.AllTrigers("Dividend_Detail", false, Utility.Get_DRWIN_hDB()); } foreach (DvdCustodian_AP_count dcAP in this.APcount_dic.Values) { count += dcAP.Update_to_DB(); } if (Utility.Is_DWRIN_admin()) { Helper_SQLserver.AllTrigers("Dividend_Detail", true, Utility.Get_DRWIN_hDB()); } return(count); }
public static int UpdateDetail_singleValue(int detailID, string colName, DateTime dt) { if (string.IsNullOrEmpty(colName)) { return(-5); } if (dt < Utility.MinDate) { return(-6); } CmdTemplate cmdTp = new CmdTemplate();//create template for DB cmdTp.tableName = DividendDetail_master.Detail_tableName; cmdTp.AddColumn(DividendDetail_master.Detail_PK_colName); cmdTp.AddColumn(colName); DB_update upd = new DB_update(cmdTp); upd.AddValue(colName, dt); SQL_relation rela = new SQL_relation(DividendDetail_master.Detail_PK_colName, RelationalOperator.Equals, detailID); upd.SetCondition(rela); if (colName.Contains(" ") || colName.Contains("-")) { Helper_SQLserver.SetTriger(DividendDetail_master.Detail_tableName, "TR_Dividend_Detail_Audit_History", false, Utility.Get_DRWIN_hDB()); int count = upd.SaveToDB(Utility.Get_DRWIN_hDB()); Helper_SQLserver.SetTriger(DividendDetail_master.Detail_tableName, "TR_Dividend_Detail_Audit_History", true, Utility.Get_DRWIN_hDB()); return(count); } else { int count = upd.SaveToDB(Utility.Get_DRWIN_hDB()); return(count); } }