首页 > 其他 > 详细

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

时间:2019-08-01 17:03:46      阅读:97      评论:0      收藏:0      [点我收藏+]

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

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

原文:https://www.cnblogs.com/passerlee/p/11283575.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!