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