BPM保存提交审核时后台校验数据

string Businessdate= Convert.ToString(Context.Current.FormDataSet["Dailyfundreport.Businessdate"]);
string Unit= Convert.ToString(Context.Current.FormDataSet["Dailyfundreport.Unit"]);
string Totalbankpay= Convert.ToString(Context.Current.FormDataSet["Dailyfundreport.Totalbankpay"]);
string Totalbillpay= Convert.ToString(Context.Current.FormDataSet["Dailyfundreport.Totalbillpay"]);
string Totalcashpay= Convert.ToString(Context.Current.FormDataSet["Dailyfundreport.Totalcashpay"]);

string sql3="select b.rmb1 from (select case  when  c.rmb1 is null  then '0.00' else c.rmb1 end  rmb1 from (select sum(RMB) rmb1 from Expenditure where Verifydate='"+Businessdate+"' and Expendunit='"+Unit+"' and Settletype = 3) c) b where b. rmb1='"+Totalcashpay+"' ";


    IDataReader reader3=DataSourceManager.ExecuteReader("BPMJB",sql3);
 
                 if(!reader3.Read()){
                       throw new Exception("现金支出金额合计与支出审批单合计不符!");

                  }
reader3.Close();

posted @ 2019-08-01 16:41  一锤定音  阅读(392)  评论(0编辑  收藏  举报