public string ycICQuery(string khbh, int sl) { Dictionary <string, string> result = new Dictionary <string, string>(); try { sara.dd.ldsw.idal.Itbl_ld_ickss _idal_tbl_ld_ickss = new sara.dd.ldsw.dal.tbl_ld_ickss(); sara.dd.ldsw.idal.Itbl_ld_khb _idal_tbl_ld_khb = new sara.dd.ldsw.dal.tbl_ld_khb(); List <sara.dd.ldsw.model.tbl_ld_ickss> modellist = _idal_tbl_ld_ickss.GetList(" f_khbh='" + khbh + "' and f_lyid='05930001' and f_ztid='1' and f_xkrq=(select max(f_xkrq) from tbl_ld_ickss where f_khbh='" + khbh + "' and f_lyid='05930001' and f_ztid='1' )", "false", "", "*", "", "", null); List <sara.dd.ldsw.model.tbl_ld_khb> khmodellist = _idal_tbl_ld_khb.GetList(" f_khbh='" + khbh + "'", "", "*", "", "", null); if (modellist.Count > 0 && khmodellist.Count > 0) { sara.dd.ldsw.model.tbl_ld_khb khmodel = khmodellist[0]; sara.dd.ldsw.model.tbl_ld_ickss model = modellist[0]; //判断购水量 if (sl == Eva.Library.Text.NumberTool.Parse(model.f_sl)) { //客户存在并包含购水记录 result.Add("custname", khmodel.f_yhm); //用户名 result.Add("custaddr", khmodel.f_dz); //地址 double sf = Eva.Library.Text.NumberTool.Parse(model.f_sf); double pwf = Eva.Library.Text.NumberTool.Parse(model.f_pwf); result.Add("waterfee", Eva.Library.Text.NumberTool.GetNumberByLength(sf / sl, 2)); //水费单价 result.Add("wpafee", Eva.Library.Text.NumberTool.GetNumberByLength(pwf / sl, 2)); //污水处理费单价 result.Add("watertype", khmodel.f_yslx); //用水类型 result.Add("lastcode", model.f_dkljgl); //读卡累积购量 result.Add("currcode", model.f_xkljgl); //写卡累积购量 result.Add("shouldAmt", model.f_shys); //总应收费用 result.Add("ret", "49"); //应答码 } else { //水量信息不正确 result.Add("ret", "54");//应答码 } } else { //客户不存在 result.Add("ret", "54");//应答码 } return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(result)); } catch (Exception ex) { //程序异常 result.Add("ret", "54");//应答码 return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(result)); } }
public string Update(string json, string columns, string type, string clientInf) { Dictionary <string, string> resultDic = new Dictionary <string, string>(); resultDic["result"] = ""; resultDic["message"] = ""; try { _iAccessDataTrans = sara.dd.ldsw.commonclass.commonclass.CreateIAccessDataTrans(); _iAccessDataTrans.getTrans().begin(); sara.dd.ldsw.model.tbl_ld_ickxj model = Eva.Library.Format.FormatEntityTool.FormatJsonToModel <sara.dd.ldsw.model.tbl_ld_ickxj>(json); columns = FormatColumns(columns).Replace("^", ","); switch (type) { case "xk": { resultDic["result"] = "true"; resultDic["message"] = _idal_tbl_ld_ickxj.Update(model, columns, _iAccessDataTrans); IList <sara.dd.ldsw.model.tbl_ld_khb> model_khb_list = _idal_tbl_ld_khb.GetList(" sys_id='" + model.f_khbhid.ToString() + "'", "", "*", "", "", _iAccessDataTrans); if (model_khb_list.Count > 0) { sara.dd.ldsw.model.tbl_ld_khb model_khb = model_khb_list[0]; //判断操作类型属于新建还是补卡 if (model.f_czlxid == "08150001") { //新建,客户表的IC卡累积购量清0 List <IDictionary <string, string> > array = new List <IDictionary <string, string> >(); IDictionary <string, string> temp = new Dictionary <string, string>(); temp.Add("key", "f_ickljgl"); temp.Add("oldvalue", model_khb.f_ickljgl); temp.Add("newvalue", "0"); temp.Add("name", "IC卡累积购量"); array.Add(temp); sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_khb", model.f_khbhid.ToString(), "tbl_ld_ickxj_detail", "IC卡新建补卡", array, clientInf, _iAccessDataTrans); model_khb.f_ickljgl = "0"; model_khb.f_value9 = "1"; } else { //补卡,不需要清0IC卡累积购量 model_khb.f_value9 = "2"; } //更新客户表 _idal_tbl_ld_khb.Update(model_khb, "f_ickljgl,f_value9", _iAccessDataTrans); _iAccessDataTrans.getTrans().commit(); } else { string errormessage = ""; if (model_khb_list.Count <= 0) { errormessage += "没有查询到客户信息;"; } resultDic["result"] = "false"; resultDic["message"] = errormessage; _iAccessDataTrans.getTrans().rollback(); } } break; case "pt": default: { resultDic["result"] = "true"; resultDic["message"] = _idal_tbl_ld_ickxj.Update(model, columns, null); _iAccessDataTrans.getTrans().commit(); } break; } NewLog("数据更新成功,更新的数据为:json:" + json + ",columns:" + columns, "sql_update", clientInf); } catch (Exception ex) { resultDic["result"] = "false"; resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace); NewLog("数据更新失败,更新的数据为:json:" + json + ",columns:" + columns + ",异常信息:" + Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace), "sql_update", clientInf); } return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic)); }
public void ProcessRequest(HttpContext context) { try { Stream s = System.Web.HttpContext.Current.Request.InputStream; byte[] b = new byte[s.Length]; s.Read(b, 0, (int)s.Length); //string xmlstr = UTF8Encoding.UTF8.GetString(b); string xmlstr = System.Text.Encoding.GetEncoding("gbk").GetString(b); if (xmlstr != null && xmlstr != "") { xmlstr = xmlstr.TrimEnd('0'); XmlDocument document = new XmlDocument(); document.LoadXml(xmlstr); //交易码 string FTranCode = ""; //公缴单位分配机构号 string InstID = ""; //交易日期时间 string TranDateTime = ""; //银行端系统流水号 string BankNum = ""; //缴费交易日期 string payDate = ""; //缴费交易流水 string bankBillNo = ""; //客户编号 string billKey = ""; //客户姓名 string customerName = ""; //缴费金额 string payAmount = ""; ////起始笔数 //string beginNum = ""; ////查询笔数 //string queryNum = ""; FTranCode = document.GetElementsByTagName("FTranCode")[0].InnerText; InstID = document.GetElementsByTagName("InstID")[0].InnerText; TranDateTime = document.GetElementsByTagName("TranDateTime")[0].InnerText; BankNum = document.GetElementsByTagName("BankNum")[0].InnerText; payDate = document.GetElementsByTagName("payDate")[0].InnerText; bankBillNo = document.GetElementsByTagName("bankBillNo")[0].InnerText; billKey = document.GetElementsByTagName("billKey")[0].InnerText; customerName = document.GetElementsByTagName("customerName")[0].InnerText; payAmount = document.GetElementsByTagName("payAmount")[0].InnerText; //beginNum = document.GetElementsByTagName("beginNum")[0].InnerText; //queryNum = document.GetElementsByTagName("queryNum")[0].InnerText; _iAccessData = commonclass.commonclass.CreateIAccessData(); if (billKey.Length == 10) { //查询该用户未缴费的抄表记录 string add_sqlStr = "sum(f_dyjtsl) as f_dyjtsl ,sum(f_dyjtsf) as f_dyjtsf ,sum(f_dejtsl) as f_dejtsl ,sum(f_dejtsf) as f_dejtsf ,sum(f_dsjtsl) as f_dsjtsl ,sum(f_dsjtsf) as f_dsjtsf "; DataTable dt = _iAccessData.Query("select wm_concat(sys_id) as sys_id,wm_concat(f_cb_cbbh) as f_cbbh,sum(f_bqje) as f_bqje,sum(f_bqsl) as f_bqsl,sum(f_sf) as f_sf,sum(f_pwf) as f_pwf,f_yhm,REPLACE(wm_concat(f_sfjl),',','|') as f_sfjl , " + add_sqlStr + " from TBL_LD_CBIAO where f_khbh='" + billKey + "' and f_ztid='2' and f_cbbh not like 'PZ%' and f_cbbh not like 'YC%' group by f_yhm").Tables[0]; DataTable ye_dt = _iAccessData.Query("select NVL(f_ye,0) as f_ye from TBL_LD_KHB where f_khbh='" + billKey + "'").Tables[0]; double ye = Eva.Library.Text.NumberTool.Parse(ye_dt.Rows[0]["f_ye"].ToString()); double bqje = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_bqje"].ToString()); double bqsl = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_bqsl"].ToString()); double sf = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_sf"].ToString()); double pwf = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_pwf"].ToString()); double f_dyjtsl = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_dyjtsl"].ToString()); double f_dyjtsf = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_dyjtsf"].ToString()); double f_dejtsl = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_dejtsl"].ToString()); double f_dejtsf = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_dejtsf"].ToString()); double f_dsjtsl = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_dsjtsl"].ToString()); double f_dsjtsf = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_dsjtsf"].ToString()); //核实缴费信息正确性 if (customerName.Trim() == dt.Rows[0]["f_yhm"].ToString() && (Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_bqje"].ToString()) - ye) == Eva.Library.Text.NumberTool.Parse(payAmount)) { //客户信息 sara.dd.ldsw.idal.Itbl_ld_khb idal_tbl_ld_khb = new sara.dd.ldsw.dal.tbl_ld_khb(); sara.dd.ldsw.idal.Itbl_ld_jfb idal_tbl_ld_jfb = new sara.dd.ldsw.dal.tbl_ld_jfb(); sara.dd.ldsw.model.tbl_ld_khb model_tbl_ld_khb = idal_tbl_ld_khb.GetList("f_khbh='" + billKey + "'", "", "*", "", "", null)[0]; #region 创建缴费记录 sara.dd.ldsw.model.tbl_ld_jfb jfmodel = new model.tbl_ld_jfb(); DateTime currentTime = System.DateTime.Now; jfmodel.sys_creatuserid = "1565"; jfmodel.sys_creatusername = "******"; jfmodel.sys_creatdate = currentTime; jfmodel.sys_lastedituserid = "1565"; jfmodel.sys_lasteditusername = "******"; jfmodel.sys_lasteditdate = currentTime; jfmodel.sys_deldate = DateTime.Parse("1900-01-01"); jfmodel.sys_delflag = "0"; jfmodel.f_jfbh = commonclass.commonclass.getBusinessNum("JF", "", null); jfmodel.f_jfrq = currentTime; jfmodel.f_jffs = "光大银行网上缴费"; jfmodel.f_jffsid = "05740010"; jfmodel.f_jcfs = "全额找零"; jfmodel.f_jcfsid = "05750001"; jfmodel.f_yyy = "光大"; jfmodel.f_yyyid = "1565"; jfmodel.f_czsj = currentTime; jfmodel.f_sfykfp = "false"; jfmodel.f_zt = "已提交"; jfmodel.f_ztid = "2"; jfmodel.f_khbh = model_tbl_ld_khb.f_khbh; jfmodel.f_khbhid = model_tbl_ld_khb.sys_id.ToString(); jfmodel.f_yhbh = model_tbl_ld_khb.f_yhbh; jfmodel.f_yhbhid = model_tbl_ld_khb.f_yhbhid; jfmodel.f_yhm = model_tbl_ld_khb.f_yhm; jfmodel.f_jfm = model_tbl_ld_khb.f_jfm; jfmodel.f_dh = model_tbl_ld_khb.f_dh; jfmodel.f_dz = model_tbl_ld_khb.f_dz; jfmodel.f_dy = model_tbl_ld_khb.f_dy; jfmodel.f_dyid = model_tbl_ld_khb.f_dyid; jfmodel.f_sc = model_tbl_ld_khb.f_sc; jfmodel.f_scid = model_tbl_ld_khb.f_scid; jfmodel.f_qy = model_tbl_ld_khb.f_qy; jfmodel.f_qyid = model_tbl_ld_khb.f_qyid; jfmodel.f_pq = model_tbl_ld_khb.f_pq; jfmodel.f_pqid = model_tbl_ld_khb.f_pqid; jfmodel.f_sbbh = model_tbl_ld_khb.f_sbbh; jfmodel.f_sbbhid = model_tbl_ld_khb.f_sbbhid; jfmodel.f_sblx = model_tbl_ld_khb.f_sblx; jfmodel.f_sblxid = model_tbl_ld_khb.f_sblxid; jfmodel.f_yslx = model_tbl_ld_khb.f_yslx; jfmodel.f_yslxid = model_tbl_ld_khb.f_yslxid; jfmodel.f_lxtkhh = model_tbl_ld_khb.f_lxth; jfmodel.f_rs = model_tbl_ld_khb.f_rs; jfmodel.f_cbbh = dt.Rows[0]["f_cbbh"].ToString(); jfmodel.f_cbbhid = dt.Rows[0]["sys_id"].ToString(); jfmodel.f_cbyslj = Eva.Library.Text.NumberTool.GetNumberByLength(bqje, 2); jfmodel.f_sllj = Eva.Library.Text.NumberTool.GetNumberByLength(bqsl, 0); jfmodel.f_sflj = Eva.Library.Text.NumberTool.GetNumberByLength(sf, 2); jfmodel.f_pwflj = Eva.Library.Text.NumberTool.GetNumberByLength(pwf, 2); jfmodel.f_dj = Eva.Library.Text.NumberTool.GetNumberByLength(Eva.Library.Text.NumberTool.Parse(jfmodel.f_cbyslj) / Eva.Library.Text.NumberTool.Parse(jfmodel.f_sllj), 2); jfmodel.f_jmhyslj = Eva.Library.Text.NumberTool.GetNumberByLength(bqje, 2); jfmodel.f_khytjjzsf = model_tbl_ld_khb.f_tjjzsf; jfmodel.f_khytjjzpwf = model_tbl_ld_khb.f_tjjzpwf; jfmodel.f_sfsytjjz = "false"; jfmodel.f_sytjjzsf = "0"; jfmodel.f_sytjjzpwf = "0"; jfmodel.f_syhtjjzsf = model_tbl_ld_khb.f_tjjzsf; jfmodel.f_syhtjjzpwf = model_tbl_ld_khb.f_tjjzpwf; jfmodel.f_khyye = model_tbl_ld_khb.f_ycje; jfmodel.f_sfsyye = "false"; jfmodel.f_syye = "0"; jfmodel.f_yhye = model_tbl_ld_khb.f_ycje; jfmodel.f_shys = payAmount; jfmodel.f_shss = payAmount; jfmodel.f_hszl = "0"; jfmodel.f_shssdx = sara.dd.ldsw.commonclass.commonclass.num2String((Eva.Library.Text.NumberTool.Parse(payAmount))); jfmodel.f_khfz = model_tbl_ld_khb.f_khfz; jfmodel.f_khfzid = model_tbl_ld_khb.f_khfzid; jfmodel.f_cbenbh = model_tbl_ld_khb.f_cbbh; jfmodel.f_cbenbhid = model_tbl_ld_khb.f_cbbhid; jfmodel.f_ljqf = model_tbl_ld_khb.f_ljqf; jfmodel.f_jmjelj = "0"; jfmodel.f_ly = "光大自助缴费"; jfmodel.f_lyid = "08080006"; jfmodel.f_bz = xmlstr; jfmodel.f_sfjl = dt.Rows[0]["f_sfjl"].ToString(); jfmodel.f_dyjtsl = Eva.Library.Text.NumberTool.GetNumberByLength(f_dyjtsl, 2); jfmodel.f_dyjtsf = Eva.Library.Text.NumberTool.GetNumberByLength(f_dyjtsf, 2); jfmodel.f_dejtsl = Eva.Library.Text.NumberTool.GetNumberByLength(f_dejtsl, 2); jfmodel.f_dejtsf = Eva.Library.Text.NumberTool.GetNumberByLength(f_dejtsf, 2); jfmodel.f_dsjtsl = Eva.Library.Text.NumberTool.GetNumberByLength(f_dsjtsl, 2); jfmodel.f_dsjtsf = Eva.Library.Text.NumberTool.GetNumberByLength(f_dsjtsf, 2); jfmodel.f_khyycje = model_tbl_ld_khb.f_ye; if (ye > 0) { jfmodel.f_sfsyycje = "true"; jfmodel.f_syycje = model_tbl_ld_khb.f_ye; } else { jfmodel.f_sfsyycje = "false"; jfmodel.f_syycje = "0"; } jfmodel.f_yhycje = "0"; jfmodel.f_dszycje = "0"; string jfbhid = idal_tbl_ld_jfb.Add(jfmodel, null); #endregion //更新抄表表 string updatecb = "update TBL_LD_CBIAO set F_ZT='已缴费',F_ZTID='3',F_JFBH='" + jfmodel.f_jfbh + "',F_JFBHID='" + jfbhid + "',F_JFSJ=to_date('" + jfmodel.f_jfrq + "','yyyy-MM-dd hh24:mi:ss') where SYS_ID in (" + dt.Rows[0]["sys_id"].ToString() + ")"; //更新客户表 string updatekh = "update TBL_LD_KHB set F_YCJE='" + jfmodel.f_yhye + "',F_TJJZSF='" + jfmodel.f_syhtjjzsf + "',F_TJJZPWF='" + jfmodel.f_syhtjjzpwf + "',F_LJQF= '0' ,f_ye = '" + jfmodel.f_yhycje + "' where sys_id='" + jfmodel.f_khbhid + "'"; int flag_cb = _iAccessData.ExecuteSql(updatecb); int flag_kh = _iAccessData.ExecuteSql(updatekh); //写入客户表日志 #region 写入日志 List <IDictionary <string, string> > array = new List <IDictionary <string, string> >(); IDictionary <string, string> temp = null; #region 对比各个业务子段,将不同的写入array if (jfmodel.f_yhye != jfmodel.f_khyye) { temp = new Dictionary <string, string>(); temp.Add("key", "f_ycje"); temp.Add("oldvalue", jfmodel.f_khyye); temp.Add("newvalue", jfmodel.f_yhye); temp.Add("name", "绿化表押金"); array.Add(temp); } if (jfmodel.f_yhycje != jfmodel.f_khyycje) { temp = new Dictionary <string, string>(); temp.Add("key", "f_ye"); temp.Add("oldvalue", jfmodel.f_khyycje); temp.Add("newvalue", jfmodel.f_yhycje); temp.Add("name", "余额"); array.Add(temp); } if (jfmodel.f_syhtjjzsf != jfmodel.f_khytjjzsf) { temp = new Dictionary <string, string>(); temp.Add("key", "f_tjjzsf"); temp.Add("oldvalue", jfmodel.f_khytjjzsf); temp.Add("newvalue", jfmodel.f_syhtjjzsf); temp.Add("name", "调价结转水费"); array.Add(temp); } if (jfmodel.f_syhtjjzpwf != jfmodel.f_khytjjzpwf) { temp = new Dictionary <string, string>(); temp.Add("key", "f_tjjzpwf"); temp.Add("oldvalue", jfmodel.f_khytjjzpwf); temp.Add("newvalue", jfmodel.f_syhtjjzpwf); temp.Add("name", "调价结转污水处理费"); array.Add(temp); } if (jfmodel.f_cbyslj == null || jfmodel.f_cbyslj == "") { jfmodel.f_cbyslj = "0"; } if (model_tbl_ld_khb.f_ljqf == null || model_tbl_ld_khb.f_ljqf == "") { model_tbl_ld_khb.f_ljqf = "0"; } if (double.Parse(jfmodel.f_cbyslj) > 0) { temp = new Dictionary <string, string>(); temp.Add("key", "f_ljqf"); temp.Add("oldvalue", model_tbl_ld_khb.f_ljqf); temp.Add("newvalue", (double.Parse(model_tbl_ld_khb.f_ljqf) - double.Parse(jfmodel.f_cbyslj)).ToString()); temp.Add("name", "累计欠费"); array.Add(temp); } #endregion sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_khb", jfmodel.f_khbhid.ToString(), "tbl_ld_jfb_detail", "缴费表", array, "", null); #endregion #region 应答报文 string resultxml = "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>"; resultxml += "<Out>"; resultxml += "<Head>"; resultxml += "<FTranCode>" + FTranCode + "</FTranCode>"; resultxml += "<InstID>" + InstID + "</InstID>"; resultxml += "<TranDateTime>" + TranDateTime + "</TranDateTime>"; resultxml += "<BankNum>" + BankNum + "</BankNum>"; resultxml += "<AnsCode>AAAAAAA</AnsCode>"; resultxml += "</Head>"; resultxml += "<Body>"; resultxml += "<companyNo>" + jfmodel.f_jfbh + "</companyNo>"; resultxml += "<billKey>" + billKey + "</billKey>"; resultxml += "<payAmount>" + payAmount + "</payAmount>"; resultxml += "<receiptNo></receiptNo>"; resultxml += "<reserve1></reserve1>"; resultxml += "<reserve2></reserve2>"; resultxml += "<reserve3></reserve3>"; resultxml += "<reserve4></reserve4>"; resultxml += "<reserve5></reserve5>"; resultxml += "<reserve6></reserve6>"; resultxml += "<reserve7></reserve7>"; resultxml += "<reserve8></reserve8>"; resultxml += "<reserve9></reserve9>"; resultxml += "<reserve10></reserve10>"; resultxml += "<reserve11></reserve11>"; resultxml += "<reserve12></reserve12>"; resultxml += "<reserve13></reserve13>"; resultxml += "<reserve14></reserve14>"; resultxml += "<reserve15></reserve15>"; resultxml += "<reserve16></reserve16>"; resultxml += "<reserve17></reserve17>"; resultxml += "<reserve18></reserve18>"; resultxml += "</Body>"; resultxml += "</Out>"; context.Response.ContentType = "text/plain"; context.Response.Charset = "gbk"; context.Response.ContentEncoding = System.Text.Encoding.GetEncoding("gbk"); context.Response.Write(resultxml); #endregion } else { //错误报文,缴费信息不一致 string errxml = "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>"; errxml += "<Out>"; errxml += "<Head>"; errxml += "<FTranCode>" + FTranCode + "</FTranCode>"; errxml += "<InstID>" + InstID + "</InstID>"; errxml += "<TranDateTime>" + TranDateTime + "</TranDateTime>"; errxml += "<BankNum>" + BankNum + "</BankNum>"; errxml += "<AnsCode>ERR000</AnsCode>"; errxml += "</Head>"; errxml += "<Body>"; errxml += "<ErrorCode>DEF0013</ErrorCode>"; errxml += "<ErrorInfo>错误的缴费信息</ErrorInfo>"; errxml += "</Body>"; errxml += "</Out>"; context.Response.ContentType = "text/plain"; context.Response.Charset = "gbk"; context.Response.ContentEncoding = System.Text.Encoding.GetEncoding("gbk"); context.Response.Write(errxml); } } else { //错误报文 错误的客户编号 string errxml = "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>"; errxml += "<Out>"; errxml += "<Head>"; errxml += "<FTranCode>" + FTranCode + "</FTranCode>"; errxml += "<InstID>" + InstID + "</InstID>"; errxml += "<TranDateTime>" + TranDateTime + "</TranDateTime>"; errxml += "<BankNum>" + BankNum + "</BankNum>"; errxml += "<AnsCode>ERR000</AnsCode>"; errxml += "</Head>"; errxml += "<Body>"; errxml += "<ErrorCode>DEF0013</ErrorCode>"; errxml += "<ErrorInfo>错误的客户编号</ErrorInfo>"; errxml += "</Body>"; errxml += "</Out>"; context.Response.ContentType = "text/plain"; context.Response.Charset = "gbk"; context.Response.ContentEncoding = System.Text.Encoding.GetEncoding("gbk"); context.Response.Write(errxml); } } } catch (System.Exception ex) { //错误报文 错误的客户编号 string errxml = "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>"; errxml += "<Out>"; errxml += "<Head>"; errxml += "<FTranCode></FTranCode>"; errxml += "<InstID></InstID>"; errxml += "<TranDateTime></TranDateTime>"; errxml += "<BankNum></BankNum>"; errxml += "<AnsCode>ERR000</AnsCode>"; errxml += "</Head>"; errxml += "<Body>"; errxml += "<ErrorCode>DEF0006</ErrorCode>"; errxml += "<ErrorInfo>" + ex.ToString() + "</ErrorInfo>"; errxml += "</Body>"; errxml += "</Out>"; context.Response.ContentType = "text/plain"; context.Response.Charset = "gbk"; context.Response.ContentEncoding = System.Text.Encoding.GetEncoding("gbk"); context.Response.Write(errxml); } }
/// <summary> /// //projclass = 3时进行的归档操作,执行落数程序 /// </summary> /// <param name="sys_ids"></param> /// <param name="str_facterid"></param> /// <param name="ds_facter"></param> /// <param name="str_txt_bak_message"></param> /// <param name="clientInf"></param> /// <returns></returns> public string set_complete(string sys_ids, string str_facterid, DataSet ds_facter, string str_txt_bak_message, string clientInf) { /* * all_result返回参数的整理: * 1、"{\"result\":\"true\",\"message\":\"\"}"----》第二次点击落地按钮,(理论上不应该出现这个情况,有可能是第一次操作时整个操作流程没有完成,所以造成用户可以点击这个按钮,所以此处的操作仅实现状态修改,返回值为true) * 2、"{\"result\":\"submit\",\"message\":\"" + messageString + "\"}";----》此时message是一个字符串,shpid|path * 3、"{\"result\":\"false\",\"message\":\"" + messageString + "\"}";----》此时message是一个字符串,异常信息。 * 4、"{\"result\":\"submitqueue\",\"message\":\"\"}"----》成功加入队列 * */ IDictionary <string, string> clientInfoDic = Eva.Library.Format.FormatEntityTool.FormatJsonToDic(clientInf); string userid = clientInfoDic["userid"]; string username = clientInfoDic["username"]; string all_result = ""; string[] sys_idss = sys_ids.Split(','); for (int i = 0; i < sys_idss.Length; i++) { try { _model_tbl_maintable = _idal_itbl_maintable.GetList(" sys_id='" + sys_idss[i].ToString() + "'", "", "*", "", "", null)[0]; if (all_result == "") { string result = ""; _t = commonclass.CreateIAccessDataTrans(); _t.getTrans().begin(); #region businesscode //businesscode //businesscode //注意此处时多个客户 //更新水表表,客户表的本期止码 //把客户表的f_value1,f_value2置空 //更新修改水表底数表的状态,操作人,操作时间等字段 //增加日志 string sql = ""; sql = "select f_khbh,f_sbbh,f_xsbds,f_ysbds from tbl_ld_xgsbdszb where fk_tbl_ld_xgsbds_sys_id= (select sys_id from tbl_ld_xgsbds where fk_tbl_maintable_sys_id='" + sys_idss[i].ToString() + "') "; DataTable dt = _t.Query(sql).Tables[0]; for (int j = 0; j < dt.Rows.Count; j++) { DataRow dr = dt.Rows[j]; model_tbl_ld_khb = idal_tbl_ld_khb.GetList("f_khbh='" + dr["f_khbh"].ToString() + "'", "", "*", "", "", null)[0]; sql = "update tbl_ld_khb set f_bqzm='" + dr["f_xsbds"].ToString() + "',f_value1='',f_value2='' where f_khbh='" + dr["f_khbh"].ToString() + "' "; _t.ExecuteSql(sql); List <IDictionary <string, string> > array = new List <IDictionary <string, string> >(); IDictionary <string, string> temp = new Dictionary <string, string>(); temp.Add("key", "f_bqzm"); temp.Add("oldvalue", dr["f_ysbds"].ToString()); temp.Add("newvalue", dr["f_xsbds"].ToString()); temp.Add("name", "本期止码"); array.Add(temp); sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_khb", model_tbl_ld_khb.sys_id.ToString(), "tbl_ld_xgsbds_detail", "修改水表底数", array, clientInf, _t); sql = "update tbl_ld_sbb set f_bqzm='" + dr["f_xsbds"].ToString() + "' where f_khbh='" + dr["f_khbh"].ToString() + "' "; _t.ExecuteSql(sql); List <IDictionary <string, string> > array1 = new List <IDictionary <string, string> >(); IDictionary <string, string> temp1 = new Dictionary <string, string>(); temp1.Add("key", "f_bqzm"); temp1.Add("oldvalue", dr["f_ysbds"].ToString()); temp1.Add("newvalue", dr["f_xsbds"].ToString()); temp1.Add("name", "本期止码"); array1.Add(temp1); sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_sbb", model_tbl_ld_khb.f_sbbhid.ToString(), "tbl_ld_xgsbds_detail", "修改水表底数", array1, clientInf, _t); } sql = " update tbl_ld_xgsbds set f_zt = '归档' , f_ztid ='2',f_czr='" + username + "',f_czrid='" + userid + "',f_czsj=to_date('" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd hh24:mi:ss') "; sql += ",f_drr='" + username + "',f_drrid='" + userid + "',f_drsj=to_date('" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd hh24:mi:ss') "; sql += " where fk_tbl_maintable_sys_id ='" + sys_idss[i].ToString() + "'"; _t.ExecuteSql(sql); #endregion //调整数据状态 NameValueCollection nvc_maintableparameters = new NameValueCollection(); nvc_maintableparameters.Add("sys_processnextuser", "^nextuser"); nvc_maintableparameters.Add("fk_tbl_maintable_sys_id", "^null"); nvc_maintableparameters.Add("fk_workflow_sys_id", "^null"); result = _hic.NextStateItemNew(sys_idss[i].ToString(), nvc_maintableparameters, str_facterid, ds_facter, str_txt_bak_message, "", "", clientInf, _t); if (result == "") { _t.getTrans().commit(); } else { _t.getTrans().rollback(); all_result = "{\"result\":\"false\",\"message\":\"" + result + "\"}"; } } } catch (Exception ex) { all_result = "{\"result\":\"false\",\"message\":\"" + ex.Message + "\"}"; } } if (all_result == "") { // all_result = "{\"result\":\"true\",\"message\":\"\"}"; } return(all_result); }
/// <summary> /// //projclass = 3时进行的归档操作,执行落数程序 /// </summary> /// <param name="sys_ids"></param> /// <param name="str_facterid"></param> /// <param name="ds_facter"></param> /// <param name="str_txt_bak_message"></param> /// <param name="clientInf"></param> /// <returns></returns> public string set_complete(string sys_ids, string str_facterid, DataSet ds_facter, string str_txt_bak_message, string clientInf) { /* * all_result返回参数的整理: * 1、"{\"result\":\"true\",\"message\":\"\"}"----》第二次点击落地按钮,(理论上不应该出现这个情况,有可能是第一次操作时整个操作流程没有完成,所以造成用户可以点击这个按钮,所以此处的操作仅实现状态修改,返回值为true) * 2、"{\"result\":\"submit\",\"message\":\"" + messageString + "\"}";----》此时message是一个字符串,shpid|path * 3、"{\"result\":\"false\",\"message\":\"" + messageString + "\"}";----》此时message是一个字符串,异常信息。 * 4、"{\"result\":\"submitqueue\",\"message\":\"\"}"----》成功加入队列 * */ IDictionary <string, string> clientInfoDic = Eva.Library.Format.FormatEntityTool.FormatJsonToDic(clientInf); string userid = clientInfoDic["userid"]; string username = clientInfoDic["username"]; string all_result = ""; string[] sys_idss = sys_ids.Split(','); for (int i = 0; i < sys_idss.Length; i++) { try { _model_tbl_maintable = _idal_itbl_maintable.GetList(" sys_id='" + sys_idss[i].ToString() + "'", "", "*", "", "", null)[0]; if (all_result == "") { string result = ""; _t = commonclass.CreateIAccessDataTrans(); _t.getTrans().begin(); #region businesscode //businesscode //在此处添加针对projclassid = 3的业务代码 //在水表表,用户表,客户表新增一条数据 //更新本表的状态,操作时间,操作人 //置空客户表的f_value状态 model_tbl_ld_xzsb = idal_tbl_ld_xzsb.GetList(" fk_tbl_maintable_sys_id = '" + sys_idss[i].ToString() + "' ", "", "*", "", "", null)[0]; _model_tbl_ld_khb = idal_tbl_ld_khb.GetList(" sys_id = '" + model_tbl_ld_xzsb.f_khbhid + "' ", "", "*", "", "", null)[0]; _model_tbl_ld_yhb = idal_tbl_ld_yhb.GetList(" sys_id = '" + _model_tbl_ld_khb.f_yhbhid + "' ", "", "*", "", "", null)[0]; sara.dd.ldsw.model.tbl_ld_khb model_tbl_ld_khb = new sara.dd.ldsw.model.tbl_ld_khb(); model_tbl_ld_khb.f_khbh = sara.dd.ldsw.commonclass.commonclass.getBusinessNum("kh", model_tbl_ld_xzsb.f_sblxid, null); #region 用户表 sara.dd.ldsw.model.tbl_ld_yhb model_tbl_ld_yhb = new sara.dd.ldsw.model.tbl_ld_yhb(); model_tbl_ld_yhb.sys_id = 0; model_tbl_ld_yhb.sys_orderid = ""; model_tbl_ld_yhb.sys_creatuserid = userid; model_tbl_ld_yhb.sys_creatusername = username; model_tbl_ld_yhb.sys_creatdate = DateTime.Now; model_tbl_ld_yhb.sys_lastedituserid = userid; model_tbl_ld_yhb.sys_lasteditusername = username; model_tbl_ld_yhb.sys_lasteditdate = DateTime.Now; model_tbl_ld_yhb.sys_deluserid = ""; model_tbl_ld_yhb.sys_delusername = ""; model_tbl_ld_yhb.sys_deldate = DateTime.Parse("1900-1-1"); model_tbl_ld_yhb.sys_delflag = "0"; model_tbl_ld_yhb.f_value1 = ""; model_tbl_ld_yhb.f_value2 = ""; model_tbl_ld_yhb.f_value3 = ""; model_tbl_ld_yhb.f_value4 = ""; model_tbl_ld_yhb.f_value5 = ""; model_tbl_ld_yhb.f_value6 = ""; model_tbl_ld_yhb.f_value7 = ""; model_tbl_ld_yhb.f_value8 = ""; model_tbl_ld_yhb.f_value9 = ""; model_tbl_ld_yhb.f_value10 = ""; model_tbl_ld_yhb.f_yhbh = sara.dd.ldsw.commonclass.commonclass.getBusinessNum("yh", model_tbl_ld_xzsb.f_sblxid, null); model_tbl_ld_yhb.f_ztyhh = ""; model_tbl_ld_yhb.f_yhm = _model_tbl_ld_yhb.f_yhm; model_tbl_ld_yhb.f_jfm = _model_tbl_ld_yhb.f_jfm; model_tbl_ld_yhb.f_dz = _model_tbl_ld_yhb.f_dz; model_tbl_ld_yhb.f_yhfz = _model_tbl_ld_yhb.f_yhfz; model_tbl_ld_yhb.f_yhfzid = _model_tbl_ld_yhb.f_yhfzid; model_tbl_ld_yhb.f_dh = _model_tbl_ld_yhb.f_dh; model_tbl_ld_yhb.f_dy = _model_tbl_ld_yhb.f_dy; model_tbl_ld_yhb.f_dyid = _model_tbl_ld_yhb.f_dyid; model_tbl_ld_yhb.f_sc = _model_tbl_ld_yhb.f_sc; model_tbl_ld_yhb.f_scid = _model_tbl_ld_yhb.f_scid; model_tbl_ld_yhb.f_qy = _model_tbl_ld_yhb.f_qy; model_tbl_ld_yhb.f_qyid = _model_tbl_ld_yhb.f_qyid; model_tbl_ld_yhb.f_pq = _model_tbl_ld_yhb.f_pq; model_tbl_ld_yhb.f_pqid = _model_tbl_ld_yhb.f_pqid; model_tbl_ld_yhb.f_khrq = DateTime.Now; model_tbl_ld_yhb.f_sfts = _model_tbl_ld_yhb.f_sfts; model_tbl_ld_yhb.f_tsyx = _model_tbl_ld_yhb.f_tsyx; model_tbl_ld_yhb.f_tsyxzh = _model_tbl_ld_yhb.f_tsyxzh; model_tbl_ld_yhb.f_htbh = _model_tbl_ld_yhb.f_htbh; model_tbl_ld_yhb.f_htfj = sara.dd.ldsw.commonclass.filecontrol.GetNewFileId(null);; model_tbl_ld_yhb.f_sfzh = _model_tbl_ld_yhb.f_sfzh; model_tbl_ld_yhb.f_sfzfj = sara.dd.ldsw.commonclass.filecontrol.GetNewFileId(null);; model_tbl_ld_yhb.f_sfzzs = _model_tbl_ld_yhb.f_sfzzs; model_tbl_ld_yhb.f_zt = _model_tbl_ld_yhb.f_zt; model_tbl_ld_yhb.f_ztid = _model_tbl_ld_yhb.f_ztid; model_tbl_ld_yhb.f_bz = _model_tbl_ld_yhb.f_bz; model_tbl_ld_yhb.f_khbh = model_tbl_ld_khb.f_khbh; model_tbl_ld_yhb.f_wxwybz = _model_tbl_ld_yhb.f_wxwybz; model_tbl_ld_yhb.f_zfbwybz = _model_tbl_ld_yhb.f_zfbwybz; model_tbl_ld_yhb.f_gdyxwybz = _model_tbl_ld_yhb.f_gdyxwybz; model_tbl_ld_yhb.f_tsyxid = _model_tbl_ld_yhb.f_tsyxid; model_tbl_ld_yhb.f_qtfj = sara.dd.ldsw.commonclass.filecontrol.GetNewFileId(null);; model_tbl_ld_yhb.f_htqdrq = DateTime.Now; string yhbhid = idal_tbl_ld_yhb.Add(model_tbl_ld_yhb, null); #endregion #region 水表表 model_tbl_ld_sbb.sys_id = 0; model_tbl_ld_sbb.sys_orderid = ""; model_tbl_ld_sbb.sys_creatuserid = userid; model_tbl_ld_sbb.sys_creatusername = username; model_tbl_ld_sbb.sys_creatdate = DateTime.Now; model_tbl_ld_sbb.sys_lastedituserid = userid; model_tbl_ld_sbb.sys_lasteditusername = username; model_tbl_ld_sbb.sys_lasteditdate = DateTime.Now; model_tbl_ld_sbb.sys_deluserid = ""; model_tbl_ld_sbb.sys_delusername = ""; model_tbl_ld_sbb.sys_deldate = DateTime.Parse("1900-1-1"); model_tbl_ld_sbb.sys_delflag = "0"; model_tbl_ld_sbb.f_value1 = ""; model_tbl_ld_sbb.f_value2 = ""; model_tbl_ld_sbb.f_value3 = ""; model_tbl_ld_sbb.f_value4 = ""; model_tbl_ld_sbb.f_value5 = ""; model_tbl_ld_sbb.f_value6 = ""; model_tbl_ld_sbb.f_value7 = ""; model_tbl_ld_sbb.f_value8 = ""; model_tbl_ld_sbb.f_value9 = ""; model_tbl_ld_sbb.f_value10 = ""; model_tbl_ld_sbb.f_sbbh = sara.dd.ldsw.commonclass.commonclass.getBusinessNum("sb", model_tbl_ld_xzsb.f_sblxid, null); model_tbl_ld_sbb.f_ztsbh = ""; model_tbl_ld_sbb.f_lxth = ""; model_tbl_ld_sbb.f_sbfz = model_tbl_ld_xzsb.f_sbfz; model_tbl_ld_sbb.f_sbfzid = model_tbl_ld_xzsb.f_sbfzid; model_tbl_ld_sbb.f_sbpp = model_tbl_ld_xzsb.f_sbpp; model_tbl_ld_sbb.f_mph = model_tbl_ld_xzsb.f_mph; model_tbl_ld_sbb.f_sbdz = model_tbl_ld_xzsb.f_sbdz; model_tbl_ld_sbb.f_khbh = model_tbl_ld_khb.f_khbh; model_tbl_ld_sbb.f_rs = model_tbl_ld_xzsb.f_rs; model_tbl_ld_sbb.f_sbkj = model_tbl_ld_xzsb.f_sbkj; model_tbl_ld_sbb.f_sbkjid = model_tbl_ld_xzsb.f_sbkjid; model_tbl_ld_sbb.f_sblx = model_tbl_ld_xzsb.f_sblx; model_tbl_ld_sbb.f_sblxid = model_tbl_ld_xzsb.f_sblxid; model_tbl_ld_sbb.f_jllx = model_tbl_ld_xzsb.f_jllx; model_tbl_ld_sbb.f_jllxid = model_tbl_ld_xzsb.f_jllxid; model_tbl_ld_sbb.f_cszm = model_tbl_ld_xzsb.f_cszm; model_tbl_ld_sbb.f_bqzm = "0"; model_tbl_ld_sbb.f_sqzm = "0"; model_tbl_ld_sbb.f_sqsl = "0"; model_tbl_ld_sbb.f_ljgl = "0"; model_tbl_ld_sbb.f_qsqpjsl = "0"; model_tbl_ld_sbb.f_qlqpjsl = "0"; model_tbl_ld_sbb.f_zt = "0"; model_tbl_ld_sbb.f_ztid = "启用"; model_tbl_ld_sbb.f_bz = ""; model_tbl_ld_sbb.f_bqsl = "0"; model_tbl_ld_sbb.f_nljgl = "0"; model_tbl_ld_sbb.f_azrq = model_tbl_ld_xzsb.f_azrq; model_tbl_ld_sbb.f_qfzt = model_tbl_ld_xzsb.f_qfzt; model_tbl_ld_sbb.f_fj = model_tbl_ld_xzsb.f_sbfj; model_tbl_ld_sbb.f_synx = model_tbl_ld_xzsb.f_synx; string sbbhid = idal_tbl_ld_sbb.Add(model_tbl_ld_sbb, null); #endregion #region 客户 model_tbl_ld_khb.sys_id = 0; model_tbl_ld_khb.sys_orderid = ""; model_tbl_ld_khb.sys_creatuserid = ""; model_tbl_ld_khb.sys_creatusername = ""; model_tbl_ld_khb.sys_creatdate = DateTime.Now; model_tbl_ld_khb.sys_lastedituserid = ""; model_tbl_ld_khb.sys_lasteditusername = ""; model_tbl_ld_khb.sys_lasteditdate = DateTime.Now; model_tbl_ld_khb.sys_deluserid = ""; model_tbl_ld_khb.sys_delusername = ""; model_tbl_ld_khb.sys_deldate = DateTime.Parse("1900-1-1"); model_tbl_ld_khb.sys_delflag = "0"; model_tbl_ld_khb.f_value1 = ""; model_tbl_ld_khb.f_value2 = ""; model_tbl_ld_khb.f_value3 = ""; model_tbl_ld_khb.f_value4 = ""; model_tbl_ld_khb.f_value5 = ""; model_tbl_ld_khb.f_value6 = ""; model_tbl_ld_khb.f_value7 = ""; model_tbl_ld_khb.f_value8 = ""; model_tbl_ld_khb.f_value9 = ""; model_tbl_ld_khb.f_value10 = ""; model_tbl_ld_khb.f_ztkhh = ""; model_tbl_ld_khb.f_khfz = _model_tbl_ld_khb.f_khfz; model_tbl_ld_khb.f_khfzid = _model_tbl_ld_khb.f_khfzid; model_tbl_ld_khb.f_ycje = ""; model_tbl_ld_khb.f_yslx = _model_tbl_ld_khb.f_yslx; model_tbl_ld_khb.f_yslxid = _model_tbl_ld_khb.f_yslxid; model_tbl_ld_khb.f_tbbh = _model_tbl_ld_khb.f_tbbh; model_tbl_ld_khb.f_sfjlbjf = _model_tbl_ld_khb.f_sfjlbjf; model_tbl_ld_khb.f_zt = _model_tbl_ld_khb.f_zt; model_tbl_ld_khb.f_ztid = _model_tbl_ld_khb.f_ztid; model_tbl_ld_khb.f_bz = _model_tbl_ld_khb.f_bz; model_tbl_ld_khb.f_cbbh = _model_tbl_ld_khb.f_cbbh; model_tbl_ld_khb.f_cbbhid = _model_tbl_ld_khb.f_cbbhid; model_tbl_ld_khb.f_cbxh = _model_tbl_ld_khb.f_cbxh + ".5"; model_tbl_ld_khb.f_cbyxm = _model_tbl_ld_khb.f_cbyxm; model_tbl_ld_khb.f_cbyid = _model_tbl_ld_khb.f_cbyid; model_tbl_ld_khb.f_cbzq = _model_tbl_ld_khb.f_cbzq; model_tbl_ld_khb.f_cbmc = _model_tbl_ld_khb.f_cbmc; model_tbl_ld_khb.f_yhbh = model_tbl_ld_yhb.f_yhbh; model_tbl_ld_khb.f_yhbhid = yhbhid; model_tbl_ld_khb.f_jfm = model_tbl_ld_yhb.f_jfm; model_tbl_ld_khb.f_yhfz = model_tbl_ld_yhb.f_yhfz; model_tbl_ld_khb.f_yhfzid = model_tbl_ld_yhb.f_yhfzid; model_tbl_ld_khb.f_dz = model_tbl_ld_yhb.f_dz; model_tbl_ld_khb.f_dh = model_tbl_ld_yhb.f_dh; model_tbl_ld_khb.f_dy = model_tbl_ld_yhb.f_dy; model_tbl_ld_khb.f_dyid = model_tbl_ld_yhb.f_dyid; model_tbl_ld_khb.f_sc = model_tbl_ld_yhb.f_sc; model_tbl_ld_khb.f_scid = model_tbl_ld_yhb.f_scid; model_tbl_ld_khb.f_qy = model_tbl_ld_yhb.f_qy; model_tbl_ld_khb.f_qyid = model_tbl_ld_yhb.f_qyid; model_tbl_ld_khb.f_pq = model_tbl_ld_yhb.f_pq; model_tbl_ld_khb.f_pqid = model_tbl_ld_yhb.f_pqid; model_tbl_ld_khb.f_tsyxzh = model_tbl_ld_yhb.f_tsyxzh; model_tbl_ld_khb.f_hth = model_tbl_ld_yhb.f_htbh; model_tbl_ld_khb.f_sfzh = model_tbl_ld_yhb.f_sfzh; model_tbl_ld_khb.f_khrq = model_tbl_ld_yhb.f_khrq; model_tbl_ld_khb.f_sbbh = model_tbl_ld_sbb.f_sbbh; model_tbl_ld_khb.f_sbbhid = sbbhid; model_tbl_ld_khb.f_bqzm = model_tbl_ld_sbb.f_bqzm; model_tbl_ld_khb.f_sqzm = model_tbl_ld_sbb.f_sqzm; model_tbl_ld_khb.f_bqsl = model_tbl_ld_sbb.f_bqsl; model_tbl_ld_khb.f_sqsl = model_tbl_ld_sbb.f_sqsl; model_tbl_ld_khb.f_qsqpjsl = model_tbl_ld_sbb.f_qsqpjsl; model_tbl_ld_khb.f_qlqpjsl = model_tbl_ld_sbb.f_qlqpjsl; model_tbl_ld_khb.f_ljgl = model_tbl_ld_sbb.f_ljgl; model_tbl_ld_khb.f_lxth = ""; model_tbl_ld_khb.f_sblx = model_tbl_ld_sbb.f_sblx; model_tbl_ld_khb.f_sblxid = model_tbl_ld_sbb.f_sblxid; model_tbl_ld_khb.f_jllx = model_tbl_ld_sbb.f_jllx; model_tbl_ld_khb.f_jllxid = model_tbl_ld_sbb.f_jllxid; model_tbl_ld_khb.f_tssbbh = _model_tbl_ld_khb.f_tssbbh; model_tbl_ld_khb.f_ztsbh = model_tbl_ld_sbb.f_ztsbh; model_tbl_ld_khb.f_rs = model_tbl_ld_sbb.f_rs; model_tbl_ld_khb.f_sbkj = model_tbl_ld_sbb.f_sbkj; model_tbl_ld_khb.f_sbkjid = model_tbl_ld_sbb.f_sbkjid; model_tbl_ld_khb.f_sbfz = model_tbl_ld_sbb.f_sbfz; model_tbl_ld_khb.f_sbfzid = model_tbl_ld_sbb.f_sbfzid; model_tbl_ld_khb.f_ztyhh = model_tbl_ld_yhb.f_ztyhh; model_tbl_ld_khb.f_wxwybz = _model_tbl_ld_khb.f_wxwybz; model_tbl_ld_khb.f_zfbwybz = _model_tbl_ld_khb.f_zfbwybz; model_tbl_ld_khb.f_gdyhwybz = _model_tbl_ld_khb.f_gdyhwybz; model_tbl_ld_khb.f_yhm = model_tbl_ld_yhb.f_yhm; DateTime DateNow = DateTime.Now.AddMonths(-1); DateTime DateBegin = new DateTime(DateNow.Year, DateNow.Month, 1); DateTime DateEnd = DateBegin.AddMonths(1).AddDays(-1); model_tbl_ld_khb.f_zhcbrq = DateEnd; model_tbl_ld_khb.f_ljqf = "0"; model_tbl_ld_khb.f_tjjzpwf = ""; model_tbl_ld_khb.f_tjjzsf = ""; model_tbl_ld_khb.f_tssbbhid = _model_tbl_ld_khb.f_tssbbhid; model_tbl_ld_khb.f_nljgl = model_tbl_ld_sbb.f_nljgl; model_tbl_ld_khb.f_sqysl = "0"; model_tbl_ld_khb.f_jhysl = "0"; model_tbl_ld_khb.f_ickljgl = "0"; model_tbl_ld_khb.f_sbdz = _model_tbl_ld_khb.f_sbdz; idal_tbl_ld_khb.Add(model_tbl_ld_khb, null); #endregion model_tbl_ld_xzsb.f_zt = "归档"; model_tbl_ld_xzsb.f_ztid = "2"; model_tbl_ld_xzsb.f_czr = username; model_tbl_ld_xzsb.f_czrid = userid; model_tbl_ld_xzsb.f_czsj = DateTime.Now; idal_tbl_ld_xzsb.Update(model_tbl_ld_xzsb, "f_zt,f_ztid,f_czr,f_czrid,f_czsj", null); _model_tbl_ld_khb.f_value1 = ""; _model_tbl_ld_khb.f_value2 = ""; idal_tbl_ld_khb.Update(_model_tbl_ld_khb, "f_value1,f_value2", null); #endregion //调整数据状态 NameValueCollection nvc_maintableparameters = new NameValueCollection(); nvc_maintableparameters.Add("sys_processnextuser", "^nextuser"); nvc_maintableparameters.Add("fk_tbl_maintable_sys_id", "^null"); nvc_maintableparameters.Add("fk_workflow_sys_id", "^null"); result = _hic.NextStateItemNew(sys_idss[i].ToString(), nvc_maintableparameters, str_facterid, ds_facter, str_txt_bak_message, "", "", clientInf, _t); if (result == "") { _t.getTrans().commit(); } else { _t.getTrans().rollback(); all_result = "{\"result\":\"false\",\"message\":\"" + result + "\"}"; } } } catch (Exception ex) { all_result = "{\"result\":\"false\",\"message\":\"" + ex.Message + "\"}"; } } if (all_result == "") { // all_result = "{\"result\":\"true\",\"message\":\"\"}"; } return(all_result); }
public void ProcessRequest(HttpContext context) { try { Stream s = System.Web.HttpContext.Current.Request.InputStream; byte[] b = new byte[s.Length]; s.Read(b, 0, (int)s.Length); string message = UTF8Encoding.UTF8.GetString(b); message = message.Replace(" ", "").Replace("\n", "").Replace("\r", "").Replace(" ", ""); message = System.Web.HttpUtility.UrlDecode(message, System.Text.Encoding.UTF8); message = message.Replace("RSASignData=", ""); com.bocom.pay.BocomClient client = new com.bocom.pay.BocomClient(); client.initialize(Eva.Library.Global.AppRootPath + "bocommjava/ini/BocompayMerchant.xml"); string xmlstr = client.AttachedVerify(message); string MerTranNo = ""; string khbh = ""; string amount = ""; string result = ""; if (xmlstr != null && xmlstr != "") { xmlstr = xmlstr.TrimEnd('0'); XmlDocument document = new XmlDocument(); document.LoadXml(xmlstr); khbh = document.GetElementsByTagName("TranContent")[0].InnerText; MerTranNo = document.GetElementsByTagName("MerTranNo")[0].InnerText; amount = document.GetElementsByTagName("Amount")[0].InnerText; result = document.GetElementsByTagName("TranState")[0].InnerText; if (result == "SUCCESS") { sara.dd.ldsw.idal.Itbl_ld_khb idal_tbl_ld_khb = new sara.dd.ldsw.dal.tbl_ld_khb(); sara.dd.ldsw.idal.Itbl_ld_jfb idal_tbl_ld_jfb = new sara.dd.ldsw.dal.tbl_ld_jfb(); _iAccessDataTrans = sara.dd.ldsw.commonclass.commonclass.CreateIAccessDataTrans(); _iAccessDataTrans.getTrans().begin(); //获取客户model List <sara.dd.ldsw.model.tbl_ld_khb> khmodellist = idal_tbl_ld_khb.GetList(" f_khbh='" + khbh + "'", " sys_id desc", "*", "", "", _iAccessDataTrans); if (khmodellist.Count == 1) { sara.dd.ldsw.model.tbl_ld_khb model_tbl_ld_khb = khmodellist[0]; //累计欠费 double ljqf = 0; if (model_tbl_ld_khb.f_ljqf != null && model_tbl_ld_khb.f_ljqf != "") { ljqf = Eva.Library.Text.NumberTool.Parse(model_tbl_ld_khb.f_ljqf); } else { ljqf = 0; } //判断客户是否存在欠费 if (ljqf > 0) { //存在欠费 //查询该用户未缴费的抄表记录 string add_sqlStr = "sum(f_dyjtsl) as f_dyjtsl ,sum(f_dyjtsf) as f_dyjtsf ,sum(f_dejtsl) as f_dejtsl ,sum(f_dejtsf) as f_dejtsf ,sum(f_dsjtsl) as f_dsjtsl ,sum(f_dsjtsf) as f_dsjtsf "; DataTable dt = _iAccessDataTrans.Query("select wm_concat(sys_id) as sys_id,wm_concat(f_cb_cbbh) as f_cbbh,sum(f_bqje) as f_bqje,sum(f_bqsl) as f_bqsl,sum(f_sf) as f_sf,sum(f_pwf) as f_pwf,f_yhm,REPLACE(wm_concat(f_sfjl),',','|') as f_sfjl ," + add_sqlStr + " from TBL_LD_CBIAO where f_khbh='" + khbh + "' and f_ztid='2' group by f_yhm").Tables[0]; //DataTable ye_dt = _iAccessDataTrans.Query("select NVL(f_ye,0) as f_ye from TBL_LD_KHB where f_khbh='" + khbh + "'").Tables[0]; //double ye = Eva.Library.Text.NumberTool.Parse(ye_dt.Rows[0]["f_ye"].ToString()); double bqje = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_bqje"].ToString()); double bqsl = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_bqsl"].ToString()); double sf = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_sf"].ToString()); double pwf = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_pwf"].ToString()); double f_dyjtsl = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_dyjtsl"].ToString()); double f_dyjtsf = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_dyjtsf"].ToString()); double f_dejtsl = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_dejtsl"].ToString()); double f_dejtsf = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_dejtsf"].ToString()); double f_dsjtsl = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_dsjtsl"].ToString()); double f_dsjtsf = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_dsjtsf"].ToString()); if (bqje == Eva.Library.Text.NumberTool.Parse(model_tbl_ld_khb.f_ljqf)) { #region 创建缴费记录 sara.dd.ldsw.model.tbl_ld_jfb jfmodel = new model.tbl_ld_jfb(); DateTime currentTime = System.DateTime.Now; jfmodel.sys_creatuserid = "1571"; jfmodel.sys_creatusername = "******"; jfmodel.sys_creatdate = currentTime; jfmodel.sys_lastedituserid = "1571"; jfmodel.sys_lasteditusername = "******"; jfmodel.sys_lasteditdate = currentTime; jfmodel.sys_deldate = DateTime.Parse("1900-01-01"); jfmodel.sys_delflag = "0"; jfmodel.f_jfbh = commonclass.commonclass.getBusinessNum("JF", "", null); jfmodel.f_jfrq = currentTime; jfmodel.f_jffs = "缴费机自助缴费"; jfmodel.f_jffsid = "05740017"; jfmodel.f_jcfs = "全额找零"; jfmodel.f_jcfsid = "05750001"; jfmodel.f_yyy = "营业厅缴费机"; jfmodel.f_yyyid = "1571"; jfmodel.f_czsj = currentTime; jfmodel.f_sfykfp = "false"; jfmodel.f_zt = "已提交"; jfmodel.f_ztid = "2"; jfmodel.f_khbh = model_tbl_ld_khb.f_khbh; jfmodel.f_khbhid = model_tbl_ld_khb.sys_id.ToString(); jfmodel.f_yhbh = model_tbl_ld_khb.f_yhbh; jfmodel.f_yhbhid = model_tbl_ld_khb.f_yhbhid; jfmodel.f_yhm = model_tbl_ld_khb.f_yhm; jfmodel.f_jfm = model_tbl_ld_khb.f_jfm; jfmodel.f_dh = model_tbl_ld_khb.f_dh; jfmodel.f_dz = model_tbl_ld_khb.f_dz; jfmodel.f_dy = model_tbl_ld_khb.f_dy; jfmodel.f_dyid = model_tbl_ld_khb.f_dyid; jfmodel.f_sc = model_tbl_ld_khb.f_sc; jfmodel.f_scid = model_tbl_ld_khb.f_scid; jfmodel.f_qy = model_tbl_ld_khb.f_qy; jfmodel.f_qyid = model_tbl_ld_khb.f_qyid; jfmodel.f_pq = model_tbl_ld_khb.f_pq; jfmodel.f_pqid = model_tbl_ld_khb.f_pqid; jfmodel.f_sbbh = model_tbl_ld_khb.f_sbbh; jfmodel.f_sbbhid = model_tbl_ld_khb.f_sbbhid; jfmodel.f_sblx = model_tbl_ld_khb.f_sblx; jfmodel.f_sblxid = model_tbl_ld_khb.f_sblxid; jfmodel.f_yslx = model_tbl_ld_khb.f_yslx; jfmodel.f_yslxid = model_tbl_ld_khb.f_yslxid; jfmodel.f_lxtkhh = model_tbl_ld_khb.f_lxth; jfmodel.f_rs = model_tbl_ld_khb.f_rs; //增加交行待对账标志 jfmodel.f_value1 = "1"; //增加交行商户订单号 jfmodel.f_value2 = MerTranNo; jfmodel.f_cbbh = dt.Rows[0]["f_cbbh"].ToString(); jfmodel.f_cbbhid = dt.Rows[0]["sys_id"].ToString(); jfmodel.f_cbyslj = Eva.Library.Text.NumberTool.GetNumberByLength(bqje, 2); jfmodel.f_sllj = Eva.Library.Text.NumberTool.GetNumberByLength(bqsl, 0); jfmodel.f_sflj = Eva.Library.Text.NumberTool.GetNumberByLength(sf, 2); jfmodel.f_pwflj = Eva.Library.Text.NumberTool.GetNumberByLength(pwf, 2); jfmodel.f_dj = Eva.Library.Text.NumberTool.GetNumberByLength(Eva.Library.Text.NumberTool.Parse(jfmodel.f_cbyslj) / Eva.Library.Text.NumberTool.Parse(jfmodel.f_sllj), 2); jfmodel.f_jmhyslj = Eva.Library.Text.NumberTool.GetNumberByLength(bqje, 2); jfmodel.f_khytjjzsf = model_tbl_ld_khb.f_tjjzsf; jfmodel.f_khytjjzpwf = model_tbl_ld_khb.f_tjjzpwf; jfmodel.f_sfsytjjz = "false"; jfmodel.f_sytjjzsf = "0"; jfmodel.f_sytjjzpwf = "0"; jfmodel.f_syhtjjzsf = model_tbl_ld_khb.f_tjjzsf; jfmodel.f_syhtjjzpwf = model_tbl_ld_khb.f_tjjzpwf; jfmodel.f_khyye = model_tbl_ld_khb.f_ycje; jfmodel.f_sfsyye = "false"; jfmodel.f_syye = "0"; jfmodel.f_yhye = model_tbl_ld_khb.f_ycje; //余额部分 jfmodel.f_khyycje = model_tbl_ld_khb.f_ye; if (Eva.Library.Text.NumberTool.Parse(jfmodel.f_khyycje) >= Eva.Library.Text.NumberTool.Parse(jfmodel.f_cbyslj)) { jfmodel.f_syycje = jfmodel.f_cbyslj; } else { jfmodel.f_syycje = jfmodel.f_khyycje; } //是否使用预存金额 if (Eva.Library.Text.NumberTool.Parse(jfmodel.f_syycje) > 0) { jfmodel.f_sfsyycje = "true"; } else { jfmodel.f_sfsyycje = "false"; } jfmodel.f_shys = Eva.Library.Text.NumberTool.GetNumberByLength((Eva.Library.Text.NumberTool.Parse(jfmodel.f_cbyslj) - Eva.Library.Text.NumberTool.Parse(jfmodel.f_syycje)), 2); jfmodel.f_shss = Eva.Library.Text.NumberTool.GetNumberByLength(amount, 2); //多收转预存金额 jfmodel.f_dszycje = Eva.Library.Text.NumberTool.GetNumberByLength((Eva.Library.Text.NumberTool.Parse(jfmodel.f_shss) - Eva.Library.Text.NumberTool.Parse(jfmodel.f_shys)), 2); //用后预存金额 jfmodel.f_yhycje = Eva.Library.Text.NumberTool.GetNumberByLength((Eva.Library.Text.NumberTool.Parse(jfmodel.f_khyycje) - Eva.Library.Text.NumberTool.Parse(jfmodel.f_syycje) + Eva.Library.Text.NumberTool.Parse(jfmodel.f_dszycje)), 2); jfmodel.f_hszl = "0"; jfmodel.f_shssdx = sara.dd.ldsw.commonclass.commonclass.num2String((Eva.Library.Text.NumberTool.Parse(jfmodel.f_shss))); jfmodel.f_khfz = model_tbl_ld_khb.f_khfz; jfmodel.f_khfzid = model_tbl_ld_khb.f_khfzid; jfmodel.f_cbenbh = model_tbl_ld_khb.f_cbbh; jfmodel.f_cbenbhid = model_tbl_ld_khb.f_cbbhid; jfmodel.f_ljqf = model_tbl_ld_khb.f_ljqf; jfmodel.f_jmjelj = "0"; jfmodel.f_ly = "缴费机"; jfmodel.f_lyid = "08080010"; jfmodel.f_sfjl = dt.Rows[0]["f_sfjl"].ToString(); jfmodel.f_dyjtsl = Eva.Library.Text.NumberTool.GetNumberByLength(f_dyjtsl, 2); jfmodel.f_dyjtsf = Eva.Library.Text.NumberTool.GetNumberByLength(f_dyjtsf, 2); jfmodel.f_dejtsl = Eva.Library.Text.NumberTool.GetNumberByLength(f_dejtsl, 2); jfmodel.f_dejtsf = Eva.Library.Text.NumberTool.GetNumberByLength(f_dejtsf, 2); jfmodel.f_dsjtsl = Eva.Library.Text.NumberTool.GetNumberByLength(f_dsjtsl, 2); jfmodel.f_dsjtsf = Eva.Library.Text.NumberTool.GetNumberByLength(f_dsjtsf, 2); string jfbhid = idal_tbl_ld_jfb.Add(jfmodel, _iAccessDataTrans); #endregion //更新抄表表 string updatecb = "update TBL_LD_CBIAO set F_ZT='已缴费',F_ZTID='3',F_JFBH='" + jfmodel.f_jfbh + "',F_JFBHID='" + jfbhid + "',F_JFSJ=to_date('" + jfmodel.f_jfrq + "','yyyy-MM-dd hh24:mi:ss') where SYS_ID in (" + dt.Rows[0]["sys_id"].ToString() + ")"; //更新客户表 string updatekh = "update TBL_LD_KHB set F_YCJE='" + jfmodel.f_yhye + "',F_TJJZSF='" + jfmodel.f_syhtjjzsf + "',F_TJJZPWF='" + jfmodel.f_syhtjjzpwf + "',F_LJQF=nvl(F_LJQF,'0')-" + jfmodel.f_cbyslj + ",f_ye = '" + jfmodel.f_yhycje + "' where sys_id='" + jfmodel.f_khbhid + "'"; int flag_cb = _iAccessDataTrans.ExecuteSql(updatecb); int flag_kh = _iAccessDataTrans.ExecuteSql(updatekh); //写入客户表日志 #region 写入日志 List <IDictionary <string, string> > array = new List <IDictionary <string, string> >(); IDictionary <string, string> temp = null; #region 对比各个业务子段,将不同的写入array if (jfmodel.f_yhye != jfmodel.f_khyye) { temp = new Dictionary <string, string>(); temp.Add("key", "f_ycje"); temp.Add("oldvalue", jfmodel.f_khyye); temp.Add("newvalue", jfmodel.f_yhye); temp.Add("name", "绿化表押金"); array.Add(temp); } if (jfmodel.f_yhycje != jfmodel.f_khyycje) { temp = new Dictionary <string, string>(); temp.Add("key", "f_ye"); temp.Add("oldvalue", jfmodel.f_khyycje); temp.Add("newvalue", jfmodel.f_yhycje); temp.Add("name", "余额"); array.Add(temp); } if (jfmodel.f_syhtjjzsf != jfmodel.f_khytjjzsf) { temp = new Dictionary <string, string>(); temp.Add("key", "f_tjjzsf"); temp.Add("oldvalue", jfmodel.f_khytjjzsf); temp.Add("newvalue", jfmodel.f_syhtjjzsf); temp.Add("name", "调价结转水费"); array.Add(temp); } if (jfmodel.f_syhtjjzpwf != jfmodel.f_khytjjzpwf) { temp = new Dictionary <string, string>(); temp.Add("key", "f_tjjzpwf"); temp.Add("oldvalue", jfmodel.f_khytjjzpwf); temp.Add("newvalue", jfmodel.f_syhtjjzpwf); temp.Add("name", "调价结转污水处理费"); array.Add(temp); } if (jfmodel.f_cbyslj == null || jfmodel.f_cbyslj == "") { jfmodel.f_cbyslj = "0"; } if (model_tbl_ld_khb.f_ljqf == null || model_tbl_ld_khb.f_ljqf == "") { model_tbl_ld_khb.f_ljqf = "0"; } if (double.Parse(jfmodel.f_cbyslj) > 0) { temp = new Dictionary <string, string>(); temp.Add("key", "f_ljqf"); temp.Add("oldvalue", model_tbl_ld_khb.f_ljqf); temp.Add("newvalue", (double.Parse(model_tbl_ld_khb.f_ljqf) - double.Parse(jfmodel.f_cbyslj)).ToString()); temp.Add("name", "累计欠费"); array.Add(temp); } #endregion sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_khb", jfmodel.f_khbhid.ToString(), "tbl_ld_jfb_detail", "缴费表", array, "", _iAccessDataTrans); #endregion _iAccessDataTrans.getTrans().commit(); } else { _iAccessDataTrans.getTrans().rollback(); } } else { //不存在欠费 #region 创建缴费记录 sara.dd.ldsw.model.tbl_ld_jfb jfmodel = new model.tbl_ld_jfb(); DateTime currentTime = System.DateTime.Now; jfmodel.sys_creatuserid = "1571"; jfmodel.sys_creatusername = "******"; jfmodel.sys_creatdate = currentTime; jfmodel.sys_lastedituserid = "1571"; jfmodel.sys_lasteditusername = "******"; jfmodel.sys_lasteditdate = currentTime; jfmodel.sys_deldate = DateTime.Parse("1900-01-01"); jfmodel.sys_delflag = "0"; jfmodel.f_jfbh = commonclass.commonclass.getBusinessNum("JF", "", null); jfmodel.f_jfrq = currentTime; jfmodel.f_jffs = "缴费机自助缴费"; jfmodel.f_jffsid = "05740017"; jfmodel.f_jcfs = "全额找零"; jfmodel.f_jcfsid = "05750001"; jfmodel.f_yyy = "营业厅缴费机"; jfmodel.f_yyyid = "1571"; jfmodel.f_czsj = currentTime; jfmodel.f_sfykfp = "false"; jfmodel.f_zt = "已提交"; jfmodel.f_ztid = "2"; jfmodel.f_khbh = model_tbl_ld_khb.f_khbh; jfmodel.f_khbhid = model_tbl_ld_khb.sys_id.ToString(); jfmodel.f_yhbh = model_tbl_ld_khb.f_yhbh; jfmodel.f_yhbhid = model_tbl_ld_khb.f_yhbhid; jfmodel.f_yhm = model_tbl_ld_khb.f_yhm; jfmodel.f_jfm = model_tbl_ld_khb.f_jfm; jfmodel.f_dh = model_tbl_ld_khb.f_dh; jfmodel.f_dz = model_tbl_ld_khb.f_dz; jfmodel.f_dy = model_tbl_ld_khb.f_dy; jfmodel.f_dyid = model_tbl_ld_khb.f_dyid; jfmodel.f_sc = model_tbl_ld_khb.f_sc; jfmodel.f_scid = model_tbl_ld_khb.f_scid; jfmodel.f_qy = model_tbl_ld_khb.f_qy; jfmodel.f_qyid = model_tbl_ld_khb.f_qyid; jfmodel.f_pq = model_tbl_ld_khb.f_pq; jfmodel.f_pqid = model_tbl_ld_khb.f_pqid; jfmodel.f_sbbh = model_tbl_ld_khb.f_sbbh; jfmodel.f_sbbhid = model_tbl_ld_khb.f_sbbhid; jfmodel.f_sblx = model_tbl_ld_khb.f_sblx; jfmodel.f_sblxid = model_tbl_ld_khb.f_sblxid; jfmodel.f_yslx = model_tbl_ld_khb.f_yslx; jfmodel.f_yslxid = model_tbl_ld_khb.f_yslxid; jfmodel.f_lxtkhh = model_tbl_ld_khb.f_lxth; jfmodel.f_rs = model_tbl_ld_khb.f_rs; //增加交行待对账标志 jfmodel.f_value1 = "1"; //增加交行商户订单号 jfmodel.f_value2 = MerTranNo; jfmodel.f_cbbh = ""; jfmodel.f_cbbhid = ""; jfmodel.f_cbyslj = "0"; jfmodel.f_sllj = "0"; jfmodel.f_sflj = "0"; jfmodel.f_pwflj = "0"; jfmodel.f_dj = "0"; jfmodel.f_jmhyslj = "0"; jfmodel.f_khytjjzsf = model_tbl_ld_khb.f_tjjzsf; jfmodel.f_khytjjzpwf = model_tbl_ld_khb.f_tjjzpwf; jfmodel.f_sfsytjjz = "false"; jfmodel.f_sytjjzsf = "0"; jfmodel.f_sytjjzpwf = "0"; jfmodel.f_syhtjjzsf = model_tbl_ld_khb.f_tjjzsf; jfmodel.f_syhtjjzpwf = model_tbl_ld_khb.f_tjjzpwf; jfmodel.f_khyye = model_tbl_ld_khb.f_ycje; jfmodel.f_sfsyye = "false"; jfmodel.f_syye = "0"; jfmodel.f_yhye = model_tbl_ld_khb.f_ycje; //余额部分 jfmodel.f_khyycje = model_tbl_ld_khb.f_ye; if (Eva.Library.Text.NumberTool.Parse(jfmodel.f_khyycje) >= Eva.Library.Text.NumberTool.Parse(jfmodel.f_cbyslj)) { jfmodel.f_syycje = jfmodel.f_cbyslj; } else { jfmodel.f_syycje = jfmodel.f_khyycje; } //是否使用预存金额 if (Eva.Library.Text.NumberTool.Parse(jfmodel.f_syycje) > 0) { jfmodel.f_sfsyycje = "true"; } else { jfmodel.f_sfsyycje = "false"; } jfmodel.f_shys = Eva.Library.Text.NumberTool.GetNumberByLength((Eva.Library.Text.NumberTool.Parse(jfmodel.f_cbyslj) - Eva.Library.Text.NumberTool.Parse(jfmodel.f_syycje)), 2); jfmodel.f_shss = Eva.Library.Text.NumberTool.GetNumberByLength(amount, 2); //多收转预存金额 jfmodel.f_dszycje = Eva.Library.Text.NumberTool.GetNumberByLength((Eva.Library.Text.NumberTool.Parse(jfmodel.f_shss) - Eva.Library.Text.NumberTool.Parse(jfmodel.f_shys)), 2); //用后预存金额 jfmodel.f_yhycje = Eva.Library.Text.NumberTool.GetNumberByLength((Eva.Library.Text.NumberTool.Parse(jfmodel.f_khyycje) - Eva.Library.Text.NumberTool.Parse(jfmodel.f_syycje) + Eva.Library.Text.NumberTool.Parse(jfmodel.f_dszycje)), 2); jfmodel.f_hszl = "0"; jfmodel.f_shssdx = sara.dd.ldsw.commonclass.commonclass.num2String((Eva.Library.Text.NumberTool.Parse(jfmodel.f_shss))); jfmodel.f_khfz = model_tbl_ld_khb.f_khfz; jfmodel.f_khfzid = model_tbl_ld_khb.f_khfzid; jfmodel.f_cbenbh = model_tbl_ld_khb.f_cbbh; jfmodel.f_cbenbhid = model_tbl_ld_khb.f_cbbhid; jfmodel.f_ljqf = model_tbl_ld_khb.f_ljqf; jfmodel.f_jmjelj = "0"; jfmodel.f_ly = "缴费机"; jfmodel.f_lyid = "08080010"; jfmodel.f_sfjl = ""; jfmodel.f_dyjtsl = Eva.Library.Text.NumberTool.GetNumberByLength("0", 2); jfmodel.f_dyjtsf = Eva.Library.Text.NumberTool.GetNumberByLength("0", 2); jfmodel.f_dejtsl = Eva.Library.Text.NumberTool.GetNumberByLength("0", 2); jfmodel.f_dejtsf = Eva.Library.Text.NumberTool.GetNumberByLength("0", 2); jfmodel.f_dsjtsl = Eva.Library.Text.NumberTool.GetNumberByLength("0", 2); jfmodel.f_dsjtsf = Eva.Library.Text.NumberTool.GetNumberByLength("0", 2); string jfbhid = idal_tbl_ld_jfb.Add(jfmodel, _iAccessDataTrans); #endregion //更新客户表 string updatekh = "update TBL_LD_KHB set F_YCJE='" + jfmodel.f_yhye + "',F_TJJZSF='" + jfmodel.f_syhtjjzsf + "',F_TJJZPWF='" + jfmodel.f_syhtjjzpwf + "',F_LJQF=nvl(F_LJQF,'0')-" + jfmodel.f_cbyslj + ",f_ye = '" + jfmodel.f_yhycje + "' where sys_id='" + jfmodel.f_khbhid + "'"; int flag_kh = _iAccessDataTrans.ExecuteSql(updatekh); //写入客户表日志 #region 写入日志 List <IDictionary <string, string> > array = new List <IDictionary <string, string> >(); IDictionary <string, string> temp = null; #region 对比各个业务子段,将不同的写入array if (jfmodel.f_yhye != jfmodel.f_khyye) { temp = new Dictionary <string, string>(); temp.Add("key", "f_ycje"); temp.Add("oldvalue", jfmodel.f_khyye); temp.Add("newvalue", jfmodel.f_yhye); temp.Add("name", "绿化表押金"); array.Add(temp); } if (jfmodel.f_yhycje != jfmodel.f_khyycje) { temp = new Dictionary <string, string>(); temp.Add("key", "f_ye"); temp.Add("oldvalue", jfmodel.f_khyycje); temp.Add("newvalue", jfmodel.f_yhycje); temp.Add("name", "余额"); array.Add(temp); } if (jfmodel.f_syhtjjzsf != jfmodel.f_khytjjzsf) { temp = new Dictionary <string, string>(); temp.Add("key", "f_tjjzsf"); temp.Add("oldvalue", jfmodel.f_khytjjzsf); temp.Add("newvalue", jfmodel.f_syhtjjzsf); temp.Add("name", "调价结转水费"); array.Add(temp); } if (jfmodel.f_syhtjjzpwf != jfmodel.f_khytjjzpwf) { temp = new Dictionary <string, string>(); temp.Add("key", "f_tjjzpwf"); temp.Add("oldvalue", jfmodel.f_khytjjzpwf); temp.Add("newvalue", jfmodel.f_syhtjjzpwf); temp.Add("name", "调价结转污水处理费"); array.Add(temp); } if (jfmodel.f_cbyslj == null || jfmodel.f_cbyslj == "") { jfmodel.f_cbyslj = "0"; } if (model_tbl_ld_khb.f_ljqf == null || model_tbl_ld_khb.f_ljqf == "") { model_tbl_ld_khb.f_ljqf = "0"; } if (double.Parse(jfmodel.f_cbyslj) > 0) { temp = new Dictionary <string, string>(); temp.Add("key", "f_ljqf"); temp.Add("oldvalue", model_tbl_ld_khb.f_ljqf); temp.Add("newvalue", (double.Parse(model_tbl_ld_khb.f_ljqf) - double.Parse(jfmodel.f_cbyslj)).ToString()); temp.Add("name", "累计欠费"); array.Add(temp); } #endregion sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_khb", jfmodel.f_khbhid.ToString(), "tbl_ld_jfb_detail", "缴费表", array, "", _iAccessDataTrans); #endregion //缴费成功 _iAccessDataTrans.getTrans().commit(); } } } } DateTime now = DateTime.Now; //证书号 string certid = Eva.Library.Configuration.ConfigurationManager.AppSettings["certid"].ToString(); string rsptime = now.ToString("yyyyMMddHHmmss"); string responsestr = "<?xml version='1.0' encoding='UTF-8'?><Document><Head><RspType>NORMAL</RspType><RspCode>MAPIPY0000</RspCode><RspMsg>交易成功</RspMsg><RspTime>" + rsptime + "</RspTime></Head><Body><MerTranNo>" + MerTranNo + "</MerTranNo></Body></Document>"; string rsasign = client.AttachedSign(certid, responsestr); //rsasign = System.Web.HttpUtility.UrlEncode(rsasign, System.Text.Encoding.UTF8); //StringBuilder builder = new StringBuilder(); //builder.AppendFormat("{0}={1}", "RSASignData", rsasign.Replace("\n", "").Replace("\r", "")); context.Response.ContentType = "text/plain"; //context.Response.ContentType = "text/xml"; context.Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8"); context.Response.Charset = "UTF-8"; context.Response.Write(rsasign); } catch (System.Exception ex) { if (_iAccessDataTrans != null) { _iAccessDataTrans.getTrans().rollback(); } } }
/// <summary> /// //projclass = 3时进行的归档操作,执行落数程序 /// </summary> /// <param name="sys_ids"></param> /// <param name="str_facterid"></param> /// <param name="ds_facter"></param> /// <param name="str_txt_bak_message"></param> /// <param name="clientInf"></param> /// <returns></returns> public string set_complete(string sys_ids, string str_facterid, DataSet ds_facter, string str_txt_bak_message, string clientInf) { /* * all_result返回参数的整理: * 1、"{\"result\":\"true\",\"message\":\"\"}"----》第二次点击落地按钮,(理论上不应该出现这个情况,有可能是第一次操作时整个操作流程没有完成,所以造成用户可以点击这个按钮,所以此处的操作仅实现状态修改,返回值为true) * 2、"{\"result\":\"submit\",\"message\":\"" + messageString + "\"}";----》此时message是一个字符串,shpid|path * 3、"{\"result\":\"false\",\"message\":\"" + messageString + "\"}";----》此时message是一个字符串,异常信息。 * 4、"{\"result\":\"submitqueue\",\"message\":\"\"}"----》成功加入队列 * */ IDictionary <string, string> clientInfoDic = Eva.Library.Format.FormatEntityTool.FormatJsonToDic(clientInf); string userid = clientInfoDic["userid"]; string username = clientInfoDic["username"]; string all_result = ""; string[] sys_idss = sys_ids.Split(','); for (int i = 0; i < sys_idss.Length; i++) { try { _model_tbl_maintable = _idal_itbl_maintable.GetList(" sys_id='" + sys_idss[i].ToString() + "'", "", "*", "", "", null)[0]; if (all_result == "") { string result = ""; string sql = ""; _t = commonclass.CreateIAccessDataTrans(); _t.getTrans().begin(); #region businesscode //businesscode //在此处添加针对projclassid = 3的业务代码 //更改水表表,客户表的状态 (多个客户) //置空客户表的f_value1,f_value2状态 //更新本表的状态 model_tbl_ld_xhhbt = idal_tbl_ld_xhhbt.GetList(" fk_tbl_maintable_sys_id='" + sys_idss[i].ToString() + "'", "", "*", "", "", null)[0]; IList <sara.dd.ldsw.model.tbl_ld_xhhbtzb> model_tbl_ld_xhhbtzb = idal_tbl_ld_xhhbtzb.GetList(" fk_tbl_ld_xhhbt_sys_id='" + model_tbl_ld_xhhbt.sys_id + "'", "", "*", "", "", null); foreach (sara.dd.ldsw.model.tbl_ld_xhhbtzb model in model_tbl_ld_xhhbtzb) { sql = " update tbl_ld_khb set f_zt = '停用' , f_ztid ='9',f_value1='',f_value2='' where sys_id ='" + model.f_khbhid + "'"; _t.ExecuteSql(sql); //在客户表中加日志 model_tbl_ld_khb = idal_tbl_ld_khb.GetList(" f_khbh='" + model.f_khbh + "'", "", "*", "", "", null)[0]; List <IDictionary <string, string> > array = new List <IDictionary <string, string> >(); if (model_tbl_ld_khb.f_zt != "停用") { IDictionary <string, string> temp = new Dictionary <string, string>(); temp.Add("key", "f_zt"); temp.Add("oldvalue", model_tbl_ld_khb.f_zt); temp.Add("newvalue", "停用"); temp.Add("name", "状态"); array.Add(temp); } sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_khb", model_tbl_ld_khb.sys_id.ToString(), "tbl_ld_xhhbt_detail", "用户报停", array, clientInf, _t); sql = " update tbl_ld_sbb set f_zt = '停用' , f_ztid ='9' where f_khbh ='" + model.f_khbh + "'"; _t.ExecuteSql(sql); //在水表表中加日志 model_tbl_ld_sbb = idal_tbl_ld_sbb.GetList(" f_khbh='" + model.f_khbh + "'", "", "*", "", "", null)[0]; List <IDictionary <string, string> > array1 = new List <IDictionary <string, string> >(); if (model_tbl_ld_sbb.f_zt != "停用") { IDictionary <string, string> temp = new Dictionary <string, string>(); temp.Add("key", "f_zt"); temp.Add("oldvalue", model_tbl_ld_sbb.f_zt); temp.Add("newvalue", "停用"); temp.Add("name", "状态"); array1.Add(temp); } sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_sbb", model_tbl_ld_sbb.sys_id.ToString(), "tbl_ld_xhhbt_detail", "用户报停", array1, clientInf, _t); //更新用户表的状态为停用 sql = " update tbl_ld_yhb set f_zt = '停用' , f_ztid ='9' where f_khbh ='" + model.f_khbh + "'"; _t.ExecuteSql(sql); //在用户表中加日志 model_tbl_ld_yhb = idal_tbl_ld_yhb.GetList(" f_khbh='" + model.f_khbh + "'", "", "*", "", "", null)[0]; List <IDictionary <string, string> > array2 = new List <IDictionary <string, string> >(); if (model_tbl_ld_yhb.f_zt != "停用") { IDictionary <string, string> temp = new Dictionary <string, string>(); temp.Add("key", "f_zt"); temp.Add("oldvalue", model_tbl_ld_yhb.f_zt); temp.Add("newvalue", "停用"); temp.Add("name", "状态"); array2.Add(temp); } sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_yhb", model_tbl_ld_yhb.sys_id.ToString(), "tbl_ld_xhhbt_detail", "用户报停", array2, clientInf, _t); sql = " update tbl_ld_xhhbt set f_zt = '归档' , f_ztid ='2',f_czr='" + username + "',f_czrid='" + userid + "',f_czsj=to_date('" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd hh24:mi:ss') where sys_id ='" + model_tbl_ld_xhhbt.sys_id + "'"; _t.ExecuteSql(sql); } #endregion //调整数据状态 NameValueCollection nvc_maintableparameters = new NameValueCollection(); nvc_maintableparameters.Add("sys_processnextuser", "^nextuser"); nvc_maintableparameters.Add("fk_tbl_maintable_sys_id", "^null"); nvc_maintableparameters.Add("fk_workflow_sys_id", "^null"); result = _hic.NextStateItemNew(sys_idss[i].ToString(), nvc_maintableparameters, str_facterid, ds_facter, str_txt_bak_message, "", "", clientInf, _t); if (result == "") { _t.getTrans().commit(); } else { _t.getTrans().rollback(); all_result = "{\"result\":\"false\",\"message\":\"" + result + "\"}"; } } } catch (Exception ex) { all_result = "{\"result\":\"false\",\"message\":\"" + ex.Message + "\"}"; } } if (all_result == "") { // all_result = "{\"result\":\"true\",\"message\":\"\"}"; } return(all_result); }
/// <summary> /// 算费回滚方法 /// </summary> /// <param name="pgid"></param> /// <param name="clientInf"></param> /// <param name="t"></param> private void CountRollBackJS(string pgid, string clientInf, Eva.Library.Data.AccessDataTrans.IAccessDataTrans t) { sara.dd.ldsw.idal.Itbl_ld_khb idal_tbl_ld_khb = new sara.dd.ldsw.dal.tbl_ld_khb(); //查询评估下的全部客户,并修改客户的累积欠费字段 string querycbsql = "select F_KHBHID,F_BQJE from TBL_LD_CBIAO where F_PGBHID='" + pgid + "' and F_ZTID='2'"; DataTable dt = t.Query(querycbsql).Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { //获取客户信息,并修改客户的累积欠费字段 IList <sara.dd.ldsw.model.tbl_ld_khb> ml = idal_tbl_ld_khb.GetList("sys_id = ('" + dt.Rows[i]["f_khbhid"] + "') ", "", "*", "", "", t); if (ml.Count > 0) { sara.dd.ldsw.model.tbl_ld_khb model_tbl_ld_khb = ml[0]; string f_ljqf_old = model_tbl_ld_khb.f_ljqf; double ljqf = Eva.Library.Text.NumberTool.Parse(model_tbl_ld_khb.f_ljqf); ljqf -= Eva.Library.Text.NumberTool.Parse(dt.Rows[i]["f_bqje"].ToString()); model_tbl_ld_khb.f_ljqf = Eva.Library.Text.NumberTool.GetNumberByLength(ljqf.ToString(), 2); #region 客户表写日志 List <IDictionary <string, string> > array = new List <IDictionary <string, string> >(); IDictionary <string, string> f_ljqf = new Dictionary <string, string>(); f_ljqf.Add("key", "f_ljqf"); f_ljqf.Add("oldvalue", f_ljqf_old); f_ljqf.Add("newvalue", model_tbl_ld_khb.f_ljqf); f_ljqf.Add("name", "累计欠费"); array.Add(f_ljqf); sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_khb", model_tbl_ld_khb.sys_id.ToString(), "tbl_ld_cben_cbiao_treelist", "算费", array, clientInf, t); #endregion idal_tbl_ld_khb.Update(model_tbl_ld_khb, "f_ljqf", t); IList <sara.dd.ldsw.model.tbl_ld_pgb> pgb = _idal_tbl_ld_pgb.GetList("sys_id = '" + pgid + "' ", "", "*", "", "", t); sara.dd.ldsw.model.tbl_ld_pgb model = pgb[0]; #region 算费回滚写日志 List <IDictionary <string, string> > arr = new List <IDictionary <string, string> >(); IDictionary <string, string> temp = new Dictionary <string, string>(); temp.Add("key", "rollback"); temp.Add("oldvalue", "算费编号:" + model.f_pgbh + " 算费批次名称:" + model.f_pgpcmc); temp.Add("newvalue", ""); temp.Add("name", "算费回滚"); arr.Add(temp); sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_pgb", model.sys_id.ToString(), "tbl_ld_pgb_detail", "算费回滚", arr, clientInf, t); #endregion } } //处理减免信息 int flag = 0; string queryjmsql = "select SYS_ID,F_CB_CBBH FROM TBL_LD_CBIAO where F_PGBHID='" + pgid + "' and F_ZTID='2' and F_JMBHID is not null"; dt = t.Query(queryjmsql).Tables[0]; string jmids = ""; for (int i = 0; i < dt.Rows.Count; i++) { jmids += dt.Rows[i]["sys_id"] + ","; } jmids = jmids.TrimEnd(','); if (jmids != "") { //更新抄表记录中的减免数据 string updatecbsql = "update TBL_LD_CBIAO set F_JMBH='',F_JMBHID='',F_JMJE='0' where SYS_ID in(" + jmids + ")"; flag = t.ExecuteSql(updatecbsql); //更新减免表的数据 string updatejmsql = "update TBL_LD_JMB set F_CBBH='',F_CBBHID='',F_ZTID='0',F_ZT='新建' where F_CBBHID in(" + jmids + ")"; flag = t.ExecuteSql(updatejmsql); } //更新评估表的数据 string updatepgsql = "update TBL_LD_PGB set F_ZTID='2',F_ZT='已回滚' where SYS_ID='" + pgid + "'"; flag = t.ExecuteSql(updatepgsql); //更新抄表表的数据 string updatesql = "update TBL_LD_CBIAO set F_ZT='已抄表',F_ZTID='1',F_SF='0',F_PWF='0',F_BQJE='0',F_SFJL='' where F_PGBHID='" + pgid + "' and F_ZTID='2'"; flag = t.ExecuteSql(updatesql); }
/// <summary> /// //projclass = 3时进行的归档操作,执行落数程序 /// </summary> /// <param name="sys_ids"></param> /// <param name="str_facterid"></param> /// <param name="ds_facter"></param> /// <param name="str_txt_bak_message"></param> /// <param name="clientInf"></param> /// <returns></returns> public string set_complete(string sys_ids, string str_facterid, DataSet ds_facter, string str_txt_bak_message, string clientInf) { /* * all_result返回参数的整理: * 1、"{\"result\":\"true\",\"message\":\"\"}"----》第二次点击落地按钮,(理论上不应该出现这个情况,有可能是第一次操作时整个操作流程没有完成,所以造成用户可以点击这个按钮,所以此处的操作仅实现状态修改,返回值为true) * 2、"{\"result\":\"submit\",\"message\":\"" + messageString + "\"}";----》此时message是一个字符串,shpid|path * 3、"{\"result\":\"false\",\"message\":\"" + messageString + "\"}";----》此时message是一个字符串,异常信息。 * 4、"{\"result\":\"submitqueue\",\"message\":\"\"}"----》成功加入队列 * */ IDictionary <string, string> clientInfoDic = Eva.Library.Format.FormatEntityTool.FormatJsonToDic(clientInf); string userid = clientInfoDic["userid"]; string username = clientInfoDic["username"]; string all_result = ""; string[] sys_idss = sys_ids.Split(','); for (int i = 0; i < sys_idss.Length; i++) { try { _model_tbl_maintable = _idal_itbl_maintable.GetList(" sys_id='" + sys_idss[i].ToString() + "'", "", "*", "", "", null)[0]; if (all_result == "") { string result = ""; _t = commonclass.CreateIAccessDataTrans(); _t.getTrans().begin(); #region businesscode //businesscode //在此处添加针对projclassid = 3的业务代码 //更新旧水表的状态为停用 //更新客户表冗余水表信息的字段,判断停用水表编号是否有值,有用“^”分割保存。把f_value1,f_value2置为空 //更新更换水表表的状态为归档 model_tbl_ld_ghsb = idal_tbl_ld_ghsb.GetList(" fk_tbl_maintable_sys_id = '" + sys_idss[i].ToString() + "' ", "", "*", "", "", null)[0]; model_tbl_ld_khb = idal_tbl_ld_khb.GetList(" sys_id = '" + model_tbl_ld_ghsb.f_khbhid + "' ", "", "*", "", "", null)[0]; _model_tbl_ld_sbb = idal_tbl_ld_sbb.GetList(" sys_id = '" + model_tbl_ld_khb.f_sbbhid + "' ", "", "*", "", "", null)[0]; #region 在水表表中新增一条数据 sara.dd.ldsw.model.tbl_ld_sbb model_tbl_ld_sbb = new sara.dd.ldsw.model.tbl_ld_sbb(); model_tbl_ld_sbb.sys_id = 0; model_tbl_ld_sbb.sys_orderid = ""; model_tbl_ld_sbb.sys_creatuserid = userid; model_tbl_ld_sbb.sys_creatusername = username; model_tbl_ld_sbb.sys_creatdate = DateTime.Now; model_tbl_ld_sbb.sys_lastedituserid = userid; model_tbl_ld_sbb.sys_lasteditusername = username; model_tbl_ld_sbb.sys_lasteditdate = DateTime.Now; model_tbl_ld_sbb.sys_deluserid = ""; model_tbl_ld_sbb.sys_delusername = ""; model_tbl_ld_sbb.sys_deldate = DateTime.Parse("1900-1-1"); model_tbl_ld_sbb.sys_delflag = "0"; model_tbl_ld_sbb.f_value1 = ""; model_tbl_ld_sbb.f_value2 = ""; model_tbl_ld_sbb.f_value3 = ""; model_tbl_ld_sbb.f_value4 = ""; model_tbl_ld_sbb.f_value5 = ""; model_tbl_ld_sbb.f_value6 = ""; model_tbl_ld_sbb.f_value7 = ""; model_tbl_ld_sbb.f_value8 = ""; model_tbl_ld_sbb.f_value9 = ""; model_tbl_ld_sbb.f_value10 = ""; model_tbl_ld_sbb.f_sbbh = sara.dd.ldsw.commonclass.commonclass.getBusinessNum("sb", model_tbl_ld_ghsb.f_newsblxid, null); model_tbl_ld_sbb.f_ztsbh = ""; model_tbl_ld_sbb.f_lxth = ""; model_tbl_ld_sbb.f_sbfz = model_tbl_ld_ghsb.f_newsbfz; model_tbl_ld_sbb.f_sbfzid = model_tbl_ld_ghsb.f_newsbfzid; model_tbl_ld_sbb.f_sbpp = model_tbl_ld_ghsb.f_newsbpp; model_tbl_ld_sbb.f_mph = model_tbl_ld_ghsb.f_newmph; model_tbl_ld_sbb.f_sbdz = model_tbl_ld_ghsb.f_newsbdz; model_tbl_ld_sbb.f_khbh = model_tbl_ld_ghsb.f_khbh; model_tbl_ld_sbb.f_rs = model_tbl_ld_ghsb.f_newrs; model_tbl_ld_sbb.f_sbkj = model_tbl_ld_ghsb.f_newsbkj; model_tbl_ld_sbb.f_sbkjid = model_tbl_ld_ghsb.f_newsbkjid; model_tbl_ld_sbb.f_sblx = model_tbl_ld_ghsb.f_newsblx; model_tbl_ld_sbb.f_sblxid = model_tbl_ld_ghsb.f_newsblxid; model_tbl_ld_sbb.f_jllx = model_tbl_ld_ghsb.f_newjllx; model_tbl_ld_sbb.f_jllxid = model_tbl_ld_ghsb.f_newjllxid; model_tbl_ld_sbb.f_cszm = model_tbl_ld_ghsb.f_newcszm; model_tbl_ld_sbb.f_bqzm = model_tbl_ld_ghsb.f_newbqzm; model_tbl_ld_sbb.f_sqzm = model_tbl_ld_ghsb.f_newsqzm; model_tbl_ld_sbb.f_sqsl = model_tbl_ld_ghsb.f_newsqsl; model_tbl_ld_sbb.f_ljgl = model_tbl_ld_ghsb.f_newljgl; model_tbl_ld_sbb.f_qsqpjsl = model_tbl_ld_ghsb.f_newqsqpjsl; model_tbl_ld_sbb.f_qlqpjsl = model_tbl_ld_ghsb.f_newqlqpjsl; model_tbl_ld_sbb.f_zt = model_tbl_ld_ghsb.f_newzt; model_tbl_ld_sbb.f_ztid = model_tbl_ld_ghsb.f_newztid; model_tbl_ld_sbb.f_bz = model_tbl_ld_ghsb.f_bz; model_tbl_ld_sbb.f_bqsl = model_tbl_ld_ghsb.f_newdysl; model_tbl_ld_sbb.f_nljgl = model_tbl_ld_ghsb.f_newnysl; model_tbl_ld_sbb.f_azrq = model_tbl_ld_ghsb.f_newazrq; model_tbl_ld_sbb.f_qfzt = model_tbl_ld_ghsb.f_newqfzt; model_tbl_ld_sbb.f_fj = model_tbl_ld_ghsb.f_xsbfj; model_tbl_ld_sbb.f_synx = model_tbl_ld_ghsb.f_newsynx; string sbbhid = idal_tbl_ld_sbb.Add(model_tbl_ld_sbb, null); #endregion #region 更新客户表冗余水表信息的字段,判断停用水表编号是否有值,有用“^”分割保存。把f_value1,f_value2置为空 model_tbl_ld_khb.f_sbbh = model_tbl_ld_sbb.f_sbbh; model_tbl_ld_khb.f_sbbhid = sbbhid; model_tbl_ld_khb.f_bqzm = model_tbl_ld_sbb.f_bqzm; model_tbl_ld_khb.f_sqzm = model_tbl_ld_sbb.f_sqzm; model_tbl_ld_khb.f_bqsl = model_tbl_ld_sbb.f_bqsl; model_tbl_ld_khb.f_sqsl = model_tbl_ld_sbb.f_sqsl; model_tbl_ld_khb.f_qsqpjsl = model_tbl_ld_sbb.f_qsqpjsl; model_tbl_ld_khb.f_qlqpjsl = model_tbl_ld_sbb.f_qlqpjsl; //model_tbl_ld_khb.f_ljgl = model_tbl_ld_sbb.f_ljgl; model_tbl_ld_khb.f_lxth = model_tbl_ld_sbb.f_lxth; model_tbl_ld_khb.f_sblx = model_tbl_ld_sbb.f_sblx; model_tbl_ld_khb.f_sblxid = model_tbl_ld_sbb.f_sblxid; model_tbl_ld_khb.f_jllx = model_tbl_ld_sbb.f_jllx; model_tbl_ld_khb.f_jllxid = model_tbl_ld_sbb.f_jllxid; if (model_tbl_ld_khb.f_tssbbh != "") { model_tbl_ld_khb.f_tssbbh = model_tbl_ld_khb.f_tssbbh + "^" + _model_tbl_ld_sbb.f_sbbh; model_tbl_ld_khb.f_tssbbhid = model_tbl_ld_khb.f_tssbbhid + "^" + _model_tbl_ld_sbb.sys_id; } else { model_tbl_ld_khb.f_tssbbh = _model_tbl_ld_sbb.f_sbbh; model_tbl_ld_khb.f_tssbbhid = _model_tbl_ld_sbb.sys_id.ToString(); } model_tbl_ld_khb.f_ztsbh = model_tbl_ld_sbb.f_ztsbh; model_tbl_ld_khb.f_rs = model_tbl_ld_sbb.f_rs; model_tbl_ld_khb.f_sbkj = model_tbl_ld_sbb.f_sbkj; model_tbl_ld_khb.f_sbkjid = model_tbl_ld_sbb.f_sbkjid; model_tbl_ld_khb.f_sbfz = model_tbl_ld_sbb.f_sbfz; model_tbl_ld_khb.f_sbfzid = model_tbl_ld_sbb.f_sbfzid; //model_tbl_ld_khb.f_nljgl = model_tbl_ld_sbb.f_nljgl; model_tbl_ld_khb.f_value1 = ""; model_tbl_ld_khb.f_value2 = ""; idal_tbl_ld_khb.Update(model_tbl_ld_khb, "f_sbbh,f_sbbhid,f_bqzm,f_sqzm,f_bqsl,f_sqsl,f_qsqpjsl,f_qlqpjsl,f_ljgl,f_lxth,f_sblx,f_sblxid,f_jllx,f_jllxid,f_tssbbh,f_tssbbhid,f_ztsbh,f_rs ,f_sbkj,f_sbkjid,f_sbfz,f_sbfzid,f_nljg,f_value1,f_value2", null); #endregion #region 更新旧水表的状态为停用 _model_tbl_ld_sbb.f_zt = "停用"; _model_tbl_ld_sbb.f_ztid = "9"; idal_tbl_ld_sbb.Update(_model_tbl_ld_sbb, "f_zt,f_ztid", null); #endregion #region 更新更换水表表的状态为归档,操作人,操作时间 model_tbl_ld_ghsb.f_zt = "归档"; model_tbl_ld_ghsb.f_ztid = "2"; model_tbl_ld_ghsb.f_czr = username; model_tbl_ld_ghsb.f_czrid = userid; model_tbl_ld_ghsb.f_czsj = DateTime.Now; model_tbl_ld_ghsb.f_newsbbh = model_tbl_ld_sbb.f_sbbh; idal_tbl_ld_ghsb.Update(model_tbl_ld_ghsb, "f_zt,f_ztid,f_czr,f_czrid,f_czsj,f_newsbbh", null); #endregion #endregion //调整数据状态 NameValueCollection nvc_maintableparameters = new NameValueCollection(); nvc_maintableparameters.Add("sys_processnextuser", "^nextuser"); nvc_maintableparameters.Add("fk_tbl_maintable_sys_id", "^null"); nvc_maintableparameters.Add("fk_workflow_sys_id", "^null"); result = _hic.NextStateItemNew(sys_idss[i].ToString(), nvc_maintableparameters, str_facterid, ds_facter, str_txt_bak_message, "", "", clientInf, _t); if (result == "") { _t.getTrans().commit(); } else { _t.getTrans().rollback(); all_result = "{\"result\":\"false\",\"message\":\"" + result + "\"}"; } } } catch (Exception ex) { all_result = "{\"result\":\"false\",\"message\":\"" + ex.Message + "\"}"; } } if (all_result == "") { // all_result = "{\"result\":\"true\",\"message\":\"\"}"; } return(all_result); }
public string Analysis(string json, string columns, string clientInf, string czlx) { //首先保存数据 Dictionary <string, string> resultDic = new Dictionary <string, string>(); resultDic["result"] = ""; resultDic["message"] = ""; try { _t = sara.dd.ldsw.commonclass.commonclass.CreateIAccessDataTrans(); _t.getTrans().begin(); sara.dd.ldsw.model.tbl_ld_xgsbds model = Eva.Library.Format.FormatEntityTool.FormatJsonToModel <sara.dd.ldsw.model.tbl_ld_xgsbds>(json); //获取附件根路径 string FileUpLoadRootPath = Eva.Library.Configuration.ConfigurationManager.AppSettings["FileUpLoadRootPath"].ToString() + "fileuploadpath/"; FileUpLoadRootPath = Eva.Library.Format.FormatTextTool.GetMapPath(FileUpLoadRootPath, HttpContext.Current.Server); //获取附件名称 //_iAccessData = sara.dd.ldsw.commonclass.commonclass.CreateIAccessData(); string sqlString = ""; string sql = ""; sqlString = "SELECT fileuploadname FROM tbl_file_content WHERE menuid='" + model.f_drwj + "'"; DataTable dt = _t.Query(sqlString).Tables[0]; //判断是否上传附件 if (dt.Rows.Count > 0 && dt.Rows[0]["fileuploadname"] != null && dt.Rows[0]["fileuploadname"].ToString().Length > 0) { DataTable importfile = commonclass.commonclass.ReadExcel(FileUpLoadRootPath + dt.Rows[0]["fileuploadname"].ToString()).Tables[0]; //判断是否为正确的导入模板 if (importfile.Columns[0].ColumnName == "客户编号" && importfile.Columns[1].ColumnName == "新水表底数") { sqlString = "DELETE FROM tbl_ld_xgsbdszb WHERE fk_tbl_ld_xgsbds_sys_id='" + model.sys_id + "'"; string aa = _t.ExecuteSql(sqlString).ToString(); //创建子表对象list DateTimeFormatInfo dtFormat = new DateTimeFormatInfo(); dtFormat.ShortDatePattern = "yyyy/MM/dd"; IDictionary <String, String> userInfDic = Eva.Library.Format.FormatEntityTool.FormatJsonToDic(clientInf); System.DateTime currentTime = new System.DateTime(); currentTime = System.DateTime.Now; DateTime blankTime = Convert.ToDateTime("1900/01/01", dtFormat); #region 循环Excel实例化子表对象 for (int i = 0; i < importfile.Rows.Count; i++) { DataRow dr = importfile.Rows[i]; if (dr[0].ToString() == "" || dr[1].ToString() == "") { resultDic["result"] = "false"; resultDic["message"] = "客户编号或新水表底数未填写,请重新确认!"; } else { sara.dd.ldsw.model.tbl_ld_khb model_tbl_ld_khb = new sara.dd.ldsw.model.tbl_ld_khb(); string khbh = dr[0].ToString().PadLeft(10, '0'); IList <sara.dd.ldsw.model.tbl_ld_khb> ml = _idal_tbl_ld_khb.GetList(" f_khbh = '" + khbh + "'and f_value1 is null and f_value2 is null and f_ztid='0' ", "", "*", "", "", _t); if (ml.Count > 0) { sara.dd.ldsw.model.tbl_ld_khb khmodel = ml[0]; //创建子表实例化对象 sara.dd.ldsw.model.tbl_ld_xgsbdszb tempmodel = new sara.dd.ldsw.model.tbl_ld_xgsbdszb(); tempmodel.sys_id = 0; tempmodel.fk_tbl_ld_xgsbds_sys_id = model.sys_id.ToString(); tempmodel.sys_creatuserid = userInfDic["userid"].ToString(); tempmodel.sys_creatusername = userInfDic["username"].ToString(); tempmodel.sys_lastedituserid = userInfDic["userid"].ToString(); tempmodel.sys_lasteditusername = userInfDic["username"].ToString(); tempmodel.sys_creatdate = currentTime; tempmodel.sys_lasteditdate = currentTime; tempmodel.sys_deldate = blankTime; tempmodel.sys_delflag = "0"; #region 对象赋值 tempmodel.f_khbh = khbh; tempmodel.f_xsbds = dr[1].ToString(); tempmodel.f_dh = khmodel.f_dh; tempmodel.f_dz = khmodel.f_dz; tempmodel.f_yhm = khmodel.f_yhm; tempmodel.f_sbbh = khmodel.f_sbbh; tempmodel.f_ysbds = khmodel.f_bqzm; string sys_id = _idal_tbl_ld_xgsbdszb.Add(tempmodel, _t); #endregion sql = "update tbl_ld_khb set f_value1='" + czlx + "',f_value2 = '" + model.sys_id + "' where sys_id = '" + model_tbl_ld_khb.sys_id + "'"; _t.ExecuteSql(sql); } #endregion } } _t.getTrans().commit(); string result1 = this.Update(json, columns, clientInf); resultDic["result"] = "true"; resultDic["message"] = result1; } else { resultDic["result"] = "false"; resultDic["message"] = "导入模板错误,请下载正确的导入模板进行导入!"; } } else { resultDic["result"] = "false"; resultDic["message"] = "请先上传导入文件再进行分析!"; } NewLog("数据更新成功,更新的数据为:json:" + json + ",columns:" + columns, "sql_update", clientInf); } catch (Exception ex) { if (_t != null) { _t.getTrans().rollback(); } resultDic["result"] = "false"; resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace); NewLog("数据更新失败,更新的数据为:json:" + json + ",columns:" + columns + ",异常信息:" + Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace), "sql_update", clientInf); } return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic)); }
public string ycDHPay(string paynostr, string wdstr, string sfystr, string gmrq, string khbh, decimal je) { try { sara.dd.ldsw.idal.Itbl_ld_cbiao _idal_tbl_ld_cbiao = new sara.dd.ldsw.dal.tbl_ld_cbiao(); sara.dd.ldsw.idal.Itbl_ld_khb _idal_tbl_ld_khb = new sara.dd.ldsw.dal.tbl_ld_khb(); sara.dd.ldsw.idal.Itbl_ld_jfb idal_tbl_ld_jfb = new sara.dd.ldsw.dal.tbl_ld_jfb(); List <sara.dd.ldsw.model.tbl_ld_cbiao> modellist = _idal_tbl_ld_cbiao.GetList(" f_khbh='" + khbh + "' and f_ztid='2' and (f_cbbh like 'DH%' or f_cbbh like 'ZB%')", "false", "", "*", "", "", null); List <sara.dd.ldsw.model.tbl_ld_khb> khmodellist = _idal_tbl_ld_khb.GetList(" f_khbh='" + khbh + "'", "", "*", "", "", null); if (modellist.Count == 1 && Eva.Library.Text.NumberTool.Parse(modellist[0].f_bqje) == (double)je) { sara.dd.ldsw.model.tbl_ld_cbiao model = modellist[0]; sara.dd.ldsw.model.tbl_ld_khb khmodel = khmodellist[0]; #region 创建缴费记录 //时间信息 DateTimeFormatInfo dtFormat = new DateTimeFormatInfo(); dtFormat.ShortDatePattern = "yyyy/MM/dd"; System.DateTime currentTime = new System.DateTime(); currentTime = System.DateTime.Now; DateTime blankTime = DateTime.Parse("1900-01-01"); sara.dd.ldsw.model.tbl_ld_jfb jfmodel = new model.tbl_ld_jfb(); //jfmodel.sys_id = int.Parse(idal_tbl_ld_jfb.GetMaxId(null)); jfmodel.sys_creatuserid = "1564"; jfmodel.sys_creatusername = "******"; jfmodel.sys_creatdate = currentTime; jfmodel.sys_lastedituserid = "1564"; jfmodel.sys_lasteditusername = "******"; jfmodel.sys_lasteditdate = currentTime; jfmodel.sys_deldate = blankTime; jfmodel.sys_delflag = "0"; jfmodel.f_jfbh = commonclass.commonclass.getBusinessNum("JF", "", null); jfmodel.f_jfrq = currentTime; jfmodel.f_jffs = "邮储代缴大用户"; jfmodel.f_jffsid = "05740014"; jfmodel.f_jcfs = "全额找零"; jfmodel.f_jcfsid = "05750001"; jfmodel.f_yyy = "PBT"; jfmodel.f_yyyid = "1564"; jfmodel.f_czsj = currentTime; jfmodel.f_sfykfp = "false"; jfmodel.f_zt = "已提交"; jfmodel.f_ztid = "2"; jfmodel.f_khbh = khmodel.f_khbh; jfmodel.f_khbhid = khmodel.sys_id.ToString(); jfmodel.f_yhbh = khmodel.f_yhbh; jfmodel.f_yhbhid = khmodel.f_yhbhid; jfmodel.f_yhm = khmodel.f_yhm; jfmodel.f_jfm = khmodel.f_jfm; jfmodel.f_dh = khmodel.f_dh; jfmodel.f_dz = khmodel.f_dz; jfmodel.f_dy = khmodel.f_dy; jfmodel.f_dyid = khmodel.f_dyid; jfmodel.f_sc = khmodel.f_sc; jfmodel.f_scid = khmodel.f_scid; jfmodel.f_qy = khmodel.f_qy; jfmodel.f_qyid = khmodel.f_qyid; jfmodel.f_pq = khmodel.f_pq; jfmodel.f_pqid = khmodel.f_pqid; jfmodel.f_sbbh = khmodel.f_sbbh; jfmodel.f_sbbhid = khmodel.f_sbbhid; jfmodel.f_sblx = khmodel.f_sblx; jfmodel.f_sblxid = khmodel.f_sblxid; jfmodel.f_yslx = khmodel.f_yslx; jfmodel.f_yslxid = khmodel.f_yslxid; jfmodel.f_lxtkhh = khmodel.f_lxth; jfmodel.f_rs = khmodel.f_rs; jfmodel.f_cbbh = model.f_cb_cbbh; jfmodel.f_cbbhid = model.sys_id.ToString(); jfmodel.f_cbyslj = model.f_bqje; jfmodel.f_sllj = model.f_bqsl; jfmodel.f_sflj = model.f_sf; jfmodel.f_pwflj = model.f_pwf; jfmodel.f_dj = Eva.Library.Text.NumberTool.GetNumberByLength(Eva.Library.Text.NumberTool.Parse(jfmodel.f_cbyslj) / Eva.Library.Text.NumberTool.Parse(jfmodel.f_sllj), 2); jfmodel.f_jmhyslj = model.f_bqje; jfmodel.f_khytjjzsf = khmodel.f_tjjzsf; jfmodel.f_khytjjzpwf = khmodel.f_tjjzpwf; jfmodel.f_sfsytjjz = "false"; jfmodel.f_sytjjzsf = "0"; jfmodel.f_sytjjzpwf = "0"; jfmodel.f_syhtjjzsf = khmodel.f_tjjzsf; jfmodel.f_syhtjjzpwf = khmodel.f_tjjzpwf; jfmodel.f_khyye = khmodel.f_ycje; jfmodel.f_sfsyye = "false"; jfmodel.f_syye = "0"; jfmodel.f_yhye = khmodel.f_ycje; jfmodel.f_shys = model.f_bqje; jfmodel.f_shss = model.f_bqje; jfmodel.f_hszl = "0"; jfmodel.f_shssdx = sara.dd.ldsw.commonclass.commonclass.num2String((Eva.Library.Text.NumberTool.Parse(jfmodel.f_cbyslj))); jfmodel.f_khfz = khmodel.f_khfz; jfmodel.f_khfzid = khmodel.f_khfzid; jfmodel.f_cbenbh = khmodel.f_cbbh; jfmodel.f_cbenbhid = khmodel.f_cbbhid; jfmodel.f_ljqf = khmodel.f_ljqf; jfmodel.f_jmjelj = "0"; jfmodel.f_ly = "邮储银行缴费"; jfmodel.f_lyid = "08080008"; jfmodel.f_sfjl = model.f_sfjl; //插入缴费表 string jfsysid = idal_tbl_ld_jfb.Add(jfmodel, null); #endregion #region 更新抄表表 model.f_zt = "已缴费"; model.f_ztid = "3"; model.f_jfbh = jfmodel.f_jfbh; model.f_jfbhid = jfsysid; model.f_jfsj = jfmodel.f_jfrq; _idal_tbl_ld_cbiao.Update(model, "f_zt,f_ztid,f_jfbh,f_jfbhid,f_jfsj", null); #endregion #region 更新客户表 khmodel.f_ljqf = "0"; _idal_tbl_ld_khb.Update(khmodel, "f_ljqf", null); List <IDictionary <string, string> > array = new List <IDictionary <string, string> >(); IDictionary <string, string> temp = null; temp = new Dictionary <string, string>(); temp.Add("key", "f_ljqf"); temp.Add("oldvalue", khmodel.f_ljqf); temp.Add("newvalue", "0"); temp.Add("name", "累计欠费"); array.Add(temp); sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_khb", model.f_khbhid.ToString(), "tbl_ld_jfb_detail", "邮储代缴大用户", array, "", null); #endregion #region 增加对账记录 _iAccessData = sara.dd.ldsw.commonclass.commonclass.CreateIAccessData(); string sql = "insert into TBL_LD_YCXZJL (f_lsh,f_wd,f_sfy,f_gmrq,f_khbh,f_gmsl,f_sfje,f_lx,sys_id) VALUES ('" + paynostr + "','" + wdstr + "','" + sfystr + "','" + gmrq + "','" + khbh + "','" + model.f_bqsl + "','" + je + "','DH',SEQ_TBL_LD_YCXZJL.nextval)"; int ins = _iAccessData.ExecuteSql(sql); if (ins > 0) { return("true"); } else { return("false"); } #endregion } else { //销账状态 return("false"); } } catch (Exception ex) { //程序异常 return("error"); } }
public string dojf(string khbh, string payAmount, string czje, string shddh) { sara.dd.ldsw.idal.Itbl_ld_khb idal_tbl_ld_khb = new sara.dd.ldsw.dal.tbl_ld_khb(); sara.dd.ldsw.idal.Itbl_ld_jfb idal_tbl_ld_jfb = new sara.dd.ldsw.dal.tbl_ld_jfb(); Dictionary <string, string> resultDic = new Dictionary <string, string>(); resultDic["result"] = ""; resultDic["message"] = ""; try { _iAccessDataTrans = sara.dd.ldsw.commonclass.commonclass.CreateIAccessDataTrans(); _iAccessDataTrans.getTrans().begin(); if (khbh.Length == 10) { //判断是否已经存在缴费记录 string count = idal_tbl_ld_jfb.GetCount("f_value2='" + shddh + "'", "false", _iAccessDataTrans); if (Eva.Library.Text.NumberTool.Parse(count) > 0) { resultDic["result"] = "false"; resultDic["message"] = "该条缴费记录" + shddh + "重复付款"; _iAccessDataTrans.getTrans().rollback(); } else { //无欠费充值情况 if (Eva.Library.Text.NumberTool.Parse(payAmount) == 0) { //客户信息 sara.dd.ldsw.model.tbl_ld_khb model_tbl_ld_khb = idal_tbl_ld_khb.GetList("f_khbh='" + khbh + "'", "", "*", "", "", _iAccessDataTrans)[0]; #region 创建缴费记录 sara.dd.ldsw.model.tbl_ld_jfb jfmodel = new model.tbl_ld_jfb(); DateTime currentTime = System.DateTime.Now; jfmodel.sys_creatuserid = "1563"; jfmodel.sys_creatusername = "******"; jfmodel.sys_creatdate = currentTime; jfmodel.sys_lastedituserid = "1563"; jfmodel.sys_lasteditusername = "******"; jfmodel.sys_lasteditdate = currentTime; jfmodel.sys_deldate = DateTime.Parse("1900-01-01"); jfmodel.sys_delflag = "0"; jfmodel.f_jfbh = commonclass.commonclass.getBusinessNum("JF", "", null); jfmodel.f_jfrq = currentTime; jfmodel.f_jffs = "e水生活缴费"; jfmodel.f_jffsid = "05740015"; jfmodel.f_jcfs = "全额找零"; jfmodel.f_jcfsid = "05750001"; jfmodel.f_yyy = "e水生活自助缴费"; jfmodel.f_yyyid = "1563"; jfmodel.f_czsj = currentTime; jfmodel.f_sfykfp = "false"; jfmodel.f_zt = "已提交"; jfmodel.f_ztid = "2"; jfmodel.f_khbh = model_tbl_ld_khb.f_khbh; jfmodel.f_khbhid = model_tbl_ld_khb.sys_id.ToString(); jfmodel.f_yhbh = model_tbl_ld_khb.f_yhbh; jfmodel.f_yhbhid = model_tbl_ld_khb.f_yhbhid; jfmodel.f_yhm = model_tbl_ld_khb.f_yhm; jfmodel.f_jfm = model_tbl_ld_khb.f_jfm; jfmodel.f_dh = model_tbl_ld_khb.f_dh; jfmodel.f_dz = model_tbl_ld_khb.f_dz; jfmodel.f_dy = model_tbl_ld_khb.f_dy; jfmodel.f_dyid = model_tbl_ld_khb.f_dyid; jfmodel.f_sc = model_tbl_ld_khb.f_sc; jfmodel.f_scid = model_tbl_ld_khb.f_scid; jfmodel.f_qy = model_tbl_ld_khb.f_qy; jfmodel.f_qyid = model_tbl_ld_khb.f_qyid; jfmodel.f_pq = model_tbl_ld_khb.f_pq; jfmodel.f_pqid = model_tbl_ld_khb.f_pqid; jfmodel.f_sbbh = model_tbl_ld_khb.f_sbbh; jfmodel.f_sbbhid = model_tbl_ld_khb.f_sbbhid; jfmodel.f_sblx = model_tbl_ld_khb.f_sblx; jfmodel.f_sblxid = model_tbl_ld_khb.f_sblxid; jfmodel.f_yslx = model_tbl_ld_khb.f_yslx; jfmodel.f_yslxid = model_tbl_ld_khb.f_yslxid; jfmodel.f_lxtkhh = model_tbl_ld_khb.f_lxth; jfmodel.f_rs = model_tbl_ld_khb.f_rs; //增加交行待对账标志 jfmodel.f_value1 = "1"; //增加交行商户订单号 jfmodel.f_value2 = shddh; jfmodel.f_cbbh = ""; jfmodel.f_cbbhid = ""; jfmodel.f_cbyslj = "0"; jfmodel.f_sllj = "0"; jfmodel.f_sflj = "0"; jfmodel.f_pwflj = "0"; jfmodel.f_dj = "0"; jfmodel.f_jmhyslj = "0"; jfmodel.f_khytjjzsf = model_tbl_ld_khb.f_tjjzsf; jfmodel.f_khytjjzpwf = model_tbl_ld_khb.f_tjjzpwf; jfmodel.f_sfsytjjz = "false"; jfmodel.f_sytjjzsf = "0"; jfmodel.f_sytjjzpwf = "0"; jfmodel.f_syhtjjzsf = model_tbl_ld_khb.f_tjjzsf; jfmodel.f_syhtjjzpwf = model_tbl_ld_khb.f_tjjzpwf; jfmodel.f_khyye = model_tbl_ld_khb.f_ycje; jfmodel.f_sfsyye = "false"; jfmodel.f_syye = "0"; jfmodel.f_yhye = model_tbl_ld_khb.f_ycje; //余额部分 jfmodel.f_khyycje = model_tbl_ld_khb.f_ye; if (Eva.Library.Text.NumberTool.Parse(jfmodel.f_khyycje) >= Eva.Library.Text.NumberTool.Parse(jfmodel.f_cbyslj)) { jfmodel.f_syycje = jfmodel.f_cbyslj; } else { jfmodel.f_syycje = jfmodel.f_khyycje; } //是否使用预存金额 if (Eva.Library.Text.NumberTool.Parse(jfmodel.f_syycje) > 0) { jfmodel.f_sfsyycje = "true"; } else { jfmodel.f_sfsyycje = "false"; } jfmodel.f_shys = Eva.Library.Text.NumberTool.GetNumberByLength((Eva.Library.Text.NumberTool.Parse(jfmodel.f_cbyslj) - Eva.Library.Text.NumberTool.Parse(jfmodel.f_syycje)), 2); jfmodel.f_shss = Eva.Library.Text.NumberTool.GetNumberByLength(czje, 2); //多收转预存金额 jfmodel.f_dszycje = Eva.Library.Text.NumberTool.GetNumberByLength((Eva.Library.Text.NumberTool.Parse(jfmodel.f_shss) - Eva.Library.Text.NumberTool.Parse(jfmodel.f_shys)), 2); //用后预存金额 jfmodel.f_yhycje = Eva.Library.Text.NumberTool.GetNumberByLength((Eva.Library.Text.NumberTool.Parse(jfmodel.f_khyycje) - Eva.Library.Text.NumberTool.Parse(jfmodel.f_syycje) + Eva.Library.Text.NumberTool.Parse(jfmodel.f_dszycje)), 2); jfmodel.f_hszl = "0"; jfmodel.f_shssdx = sara.dd.ldsw.commonclass.commonclass.num2String((Eva.Library.Text.NumberTool.Parse(jfmodel.f_shss))); jfmodel.f_khfz = model_tbl_ld_khb.f_khfz; jfmodel.f_khfzid = model_tbl_ld_khb.f_khfzid; jfmodel.f_cbenbh = model_tbl_ld_khb.f_cbbh; jfmodel.f_cbenbhid = model_tbl_ld_khb.f_cbbhid; jfmodel.f_ljqf = model_tbl_ld_khb.f_ljqf; jfmodel.f_jmjelj = "0"; jfmodel.f_ly = "e水生活"; jfmodel.f_lyid = "08080007"; jfmodel.f_sfjl = ""; jfmodel.f_dyjtsl = Eva.Library.Text.NumberTool.GetNumberByLength("0", 2); jfmodel.f_dyjtsf = Eva.Library.Text.NumberTool.GetNumberByLength("0", 2); jfmodel.f_dejtsl = Eva.Library.Text.NumberTool.GetNumberByLength("0", 2); jfmodel.f_dejtsf = Eva.Library.Text.NumberTool.GetNumberByLength("0", 2); jfmodel.f_dsjtsl = Eva.Library.Text.NumberTool.GetNumberByLength("0", 2); jfmodel.f_dsjtsf = Eva.Library.Text.NumberTool.GetNumberByLength("0", 2); string jfbhid = idal_tbl_ld_jfb.Add(jfmodel, _iAccessDataTrans); #endregion //更新客户表 string updatekh = "update TBL_LD_KHB set F_YCJE='" + jfmodel.f_yhye + "',F_TJJZSF='" + jfmodel.f_syhtjjzsf + "',F_TJJZPWF='" + jfmodel.f_syhtjjzpwf + "',F_LJQF=nvl(F_LJQF,'0')-" + jfmodel.f_cbyslj + ",f_ye = '" + jfmodel.f_yhycje + "' where sys_id='" + jfmodel.f_khbhid + "'"; int flag_kh = _iAccessDataTrans.ExecuteSql(updatekh); //写入客户表日志 #region 写入日志 List <IDictionary <string, string> > array = new List <IDictionary <string, string> >(); IDictionary <string, string> temp = null; #region 对比各个业务子段,将不同的写入array if (jfmodel.f_yhye != jfmodel.f_khyye) { temp = new Dictionary <string, string>(); temp.Add("key", "f_ycje"); temp.Add("oldvalue", jfmodel.f_khyye); temp.Add("newvalue", jfmodel.f_yhye); temp.Add("name", "绿化表押金"); array.Add(temp); } if (jfmodel.f_yhycje != jfmodel.f_khyycje) { temp = new Dictionary <string, string>(); temp.Add("key", "f_ye"); temp.Add("oldvalue", jfmodel.f_khyycje); temp.Add("newvalue", jfmodel.f_yhycje); temp.Add("name", "余额"); array.Add(temp); } if (jfmodel.f_syhtjjzsf != jfmodel.f_khytjjzsf) { temp = new Dictionary <string, string>(); temp.Add("key", "f_tjjzsf"); temp.Add("oldvalue", jfmodel.f_khytjjzsf); temp.Add("newvalue", jfmodel.f_syhtjjzsf); temp.Add("name", "调价结转水费"); array.Add(temp); } if (jfmodel.f_syhtjjzpwf != jfmodel.f_khytjjzpwf) { temp = new Dictionary <string, string>(); temp.Add("key", "f_tjjzpwf"); temp.Add("oldvalue", jfmodel.f_khytjjzpwf); temp.Add("newvalue", jfmodel.f_syhtjjzpwf); temp.Add("name", "调价结转污水处理费"); array.Add(temp); } if (jfmodel.f_cbyslj == null || jfmodel.f_cbyslj == "") { jfmodel.f_cbyslj = "0"; } if (model_tbl_ld_khb.f_ljqf == null || model_tbl_ld_khb.f_ljqf == "") { model_tbl_ld_khb.f_ljqf = "0"; } if (double.Parse(jfmodel.f_cbyslj) > 0) { temp = new Dictionary <string, string>(); temp.Add("key", "f_ljqf"); temp.Add("oldvalue", model_tbl_ld_khb.f_ljqf); temp.Add("newvalue", (double.Parse(model_tbl_ld_khb.f_ljqf) - double.Parse(jfmodel.f_cbyslj)).ToString()); temp.Add("name", "累计欠费"); array.Add(temp); } #endregion sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_khb", jfmodel.f_khbhid.ToString(), "tbl_ld_jfb_detail", "缴费表", array, "", _iAccessDataTrans); #endregion //缴费成功 resultDic["result"] = "true"; //resultDic["message"] = jfbhid; resultDic["message"] = jfmodel.f_yhycje; resultDic["jfbh"] = jfmodel.f_jfbh; _iAccessDataTrans.getTrans().commit(); } //核实缴费信息正确性 else if (Eva.Library.Text.NumberTool.Parse(payAmount) > 0) { //查询该用户未缴费的抄表记录 string add_sqlStr = "sum(f_dyjtsl) as f_dyjtsl ,sum(f_dyjtsf) as f_dyjtsf ,sum(f_dejtsl) as f_dejtsl ,sum(f_dejtsf) as f_dejtsf ,sum(f_dsjtsl) as f_dsjtsl ,sum(f_dsjtsf) as f_dsjtsf "; DataTable dt = _iAccessDataTrans.Query("select wm_concat(sys_id) as sys_id,wm_concat(f_cb_cbbh) as f_cbbh,sum(f_bqje) as f_bqje,sum(f_bqsl) as f_bqsl,sum(f_sf) as f_sf,sum(f_pwf) as f_pwf,f_yhm,REPLACE(wm_concat(f_sfjl),',','|') as f_sfjl ," + add_sqlStr + " from TBL_LD_CBIAO where f_khbh='" + khbh + "' and f_ztid='2' group by f_yhm").Tables[0]; //DataTable ye_dt = _iAccessDataTrans.Query("select NVL(f_ye,0) as f_ye from TBL_LD_KHB where f_khbh='" + khbh + "'").Tables[0]; //double ye = Eva.Library.Text.NumberTool.Parse(ye_dt.Rows[0]["f_ye"].ToString()); double bqje = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_bqje"].ToString()); double bqsl = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_bqsl"].ToString()); double sf = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_sf"].ToString()); double pwf = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_pwf"].ToString()); double f_dyjtsl = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_dyjtsl"].ToString()); double f_dyjtsf = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_dyjtsf"].ToString()); double f_dejtsl = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_dejtsl"].ToString()); double f_dejtsf = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_dejtsf"].ToString()); double f_dsjtsl = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_dsjtsl"].ToString()); double f_dsjtsf = Eva.Library.Text.NumberTool.Parse(dt.Rows[0]["f_dsjtsf"].ToString()); if (bqje == Eva.Library.Text.NumberTool.Parse(payAmount)) { //客户信息 sara.dd.ldsw.model.tbl_ld_khb model_tbl_ld_khb = idal_tbl_ld_khb.GetList("f_khbh='" + khbh + "'", "", "*", "", "", _iAccessDataTrans)[0]; #region 创建缴费记录 sara.dd.ldsw.model.tbl_ld_jfb jfmodel = new model.tbl_ld_jfb(); DateTime currentTime = System.DateTime.Now; jfmodel.sys_creatuserid = "1563"; jfmodel.sys_creatusername = "******"; jfmodel.sys_creatdate = currentTime; jfmodel.sys_lastedituserid = "1563"; jfmodel.sys_lasteditusername = "******"; jfmodel.sys_lasteditdate = currentTime; jfmodel.sys_deldate = DateTime.Parse("1900-01-01"); jfmodel.sys_delflag = "0"; jfmodel.f_jfbh = commonclass.commonclass.getBusinessNum("JF", "", null); jfmodel.f_jfrq = currentTime; jfmodel.f_jffs = "e水生活缴费"; jfmodel.f_jffsid = "05740015"; jfmodel.f_jcfs = "全额找零"; jfmodel.f_jcfsid = "05750001"; jfmodel.f_yyy = "e水生活自助缴费"; jfmodel.f_yyyid = "1563"; jfmodel.f_czsj = currentTime; jfmodel.f_sfykfp = "false"; jfmodel.f_zt = "已提交"; jfmodel.f_ztid = "2"; jfmodel.f_khbh = model_tbl_ld_khb.f_khbh; jfmodel.f_khbhid = model_tbl_ld_khb.sys_id.ToString(); jfmodel.f_yhbh = model_tbl_ld_khb.f_yhbh; jfmodel.f_yhbhid = model_tbl_ld_khb.f_yhbhid; jfmodel.f_yhm = model_tbl_ld_khb.f_yhm; jfmodel.f_jfm = model_tbl_ld_khb.f_jfm; jfmodel.f_dh = model_tbl_ld_khb.f_dh; jfmodel.f_dz = model_tbl_ld_khb.f_dz; jfmodel.f_dy = model_tbl_ld_khb.f_dy; jfmodel.f_dyid = model_tbl_ld_khb.f_dyid; jfmodel.f_sc = model_tbl_ld_khb.f_sc; jfmodel.f_scid = model_tbl_ld_khb.f_scid; jfmodel.f_qy = model_tbl_ld_khb.f_qy; jfmodel.f_qyid = model_tbl_ld_khb.f_qyid; jfmodel.f_pq = model_tbl_ld_khb.f_pq; jfmodel.f_pqid = model_tbl_ld_khb.f_pqid; jfmodel.f_sbbh = model_tbl_ld_khb.f_sbbh; jfmodel.f_sbbhid = model_tbl_ld_khb.f_sbbhid; jfmodel.f_sblx = model_tbl_ld_khb.f_sblx; jfmodel.f_sblxid = model_tbl_ld_khb.f_sblxid; jfmodel.f_yslx = model_tbl_ld_khb.f_yslx; jfmodel.f_yslxid = model_tbl_ld_khb.f_yslxid; jfmodel.f_lxtkhh = model_tbl_ld_khb.f_lxth; jfmodel.f_rs = model_tbl_ld_khb.f_rs; //增加交行待对账标志 jfmodel.f_value1 = "1"; //增加交行商户订单号 jfmodel.f_value2 = shddh; jfmodel.f_cbbh = dt.Rows[0]["f_cbbh"].ToString(); jfmodel.f_cbbhid = dt.Rows[0]["sys_id"].ToString(); jfmodel.f_cbyslj = Eva.Library.Text.NumberTool.GetNumberByLength(bqje, 2); jfmodel.f_sllj = Eva.Library.Text.NumberTool.GetNumberByLength(bqsl, 0); jfmodel.f_sflj = Eva.Library.Text.NumberTool.GetNumberByLength(sf, 2); jfmodel.f_pwflj = Eva.Library.Text.NumberTool.GetNumberByLength(pwf, 2); jfmodel.f_dj = Eva.Library.Text.NumberTool.GetNumberByLength(Eva.Library.Text.NumberTool.Parse(jfmodel.f_cbyslj) / Eva.Library.Text.NumberTool.Parse(jfmodel.f_sllj), 2); jfmodel.f_jmhyslj = Eva.Library.Text.NumberTool.GetNumberByLength(bqje, 2); jfmodel.f_khytjjzsf = model_tbl_ld_khb.f_tjjzsf; jfmodel.f_khytjjzpwf = model_tbl_ld_khb.f_tjjzpwf; jfmodel.f_sfsytjjz = "false"; jfmodel.f_sytjjzsf = "0"; jfmodel.f_sytjjzpwf = "0"; jfmodel.f_syhtjjzsf = model_tbl_ld_khb.f_tjjzsf; jfmodel.f_syhtjjzpwf = model_tbl_ld_khb.f_tjjzpwf; jfmodel.f_khyye = model_tbl_ld_khb.f_ycje; jfmodel.f_sfsyye = "false"; jfmodel.f_syye = "0"; jfmodel.f_yhye = model_tbl_ld_khb.f_ycje; //余额部分 jfmodel.f_khyycje = model_tbl_ld_khb.f_ye; if (Eva.Library.Text.NumberTool.Parse(jfmodel.f_khyycje) >= Eva.Library.Text.NumberTool.Parse(jfmodel.f_cbyslj)) { jfmodel.f_syycje = jfmodel.f_cbyslj; } else { jfmodel.f_syycje = jfmodel.f_khyycje; } //是否使用预存金额 if (Eva.Library.Text.NumberTool.Parse(jfmodel.f_syycje) > 0) { jfmodel.f_sfsyycje = "true"; } else { jfmodel.f_sfsyycje = "false"; } jfmodel.f_shys = Eva.Library.Text.NumberTool.GetNumberByLength((Eva.Library.Text.NumberTool.Parse(jfmodel.f_cbyslj) - Eva.Library.Text.NumberTool.Parse(jfmodel.f_syycje)), 2); jfmodel.f_shss = Eva.Library.Text.NumberTool.GetNumberByLength(czje, 2); //多收转预存金额 jfmodel.f_dszycje = Eva.Library.Text.NumberTool.GetNumberByLength((Eva.Library.Text.NumberTool.Parse(jfmodel.f_shss) - Eva.Library.Text.NumberTool.Parse(jfmodel.f_shys)), 2); //用后预存金额 jfmodel.f_yhycje = Eva.Library.Text.NumberTool.GetNumberByLength((Eva.Library.Text.NumberTool.Parse(jfmodel.f_khyycje) - Eva.Library.Text.NumberTool.Parse(jfmodel.f_syycje) + Eva.Library.Text.NumberTool.Parse(jfmodel.f_dszycje)), 2); jfmodel.f_hszl = "0"; jfmodel.f_shssdx = sara.dd.ldsw.commonclass.commonclass.num2String((Eva.Library.Text.NumberTool.Parse(jfmodel.f_shss))); jfmodel.f_khfz = model_tbl_ld_khb.f_khfz; jfmodel.f_khfzid = model_tbl_ld_khb.f_khfzid; jfmodel.f_cbenbh = model_tbl_ld_khb.f_cbbh; jfmodel.f_cbenbhid = model_tbl_ld_khb.f_cbbhid; jfmodel.f_ljqf = model_tbl_ld_khb.f_ljqf; jfmodel.f_jmjelj = "0"; jfmodel.f_ly = "e水生活"; jfmodel.f_lyid = "08080007"; jfmodel.f_sfjl = dt.Rows[0]["f_sfjl"].ToString(); jfmodel.f_dyjtsl = Eva.Library.Text.NumberTool.GetNumberByLength(f_dyjtsl, 2); jfmodel.f_dyjtsf = Eva.Library.Text.NumberTool.GetNumberByLength(f_dyjtsf, 2); jfmodel.f_dejtsl = Eva.Library.Text.NumberTool.GetNumberByLength(f_dejtsl, 2); jfmodel.f_dejtsf = Eva.Library.Text.NumberTool.GetNumberByLength(f_dejtsf, 2); jfmodel.f_dsjtsl = Eva.Library.Text.NumberTool.GetNumberByLength(f_dsjtsl, 2); jfmodel.f_dsjtsf = Eva.Library.Text.NumberTool.GetNumberByLength(f_dsjtsf, 2); string jfbhid = idal_tbl_ld_jfb.Add(jfmodel, _iAccessDataTrans); #endregion //更新抄表表 string updatecb = "update TBL_LD_CBIAO set F_ZT='已缴费',F_ZTID='3',F_JFBH='" + jfmodel.f_jfbh + "',F_JFBHID='" + jfbhid + "',F_JFSJ=to_date('" + jfmodel.f_jfrq + "','yyyy-MM-dd hh24:mi:ss') where SYS_ID in (" + dt.Rows[0]["sys_id"].ToString() + ")"; //更新客户表 string updatekh = "update TBL_LD_KHB set F_YCJE='" + jfmodel.f_yhye + "',F_TJJZSF='" + jfmodel.f_syhtjjzsf + "',F_TJJZPWF='" + jfmodel.f_syhtjjzpwf + "',F_LJQF=nvl(F_LJQF,'0')-" + jfmodel.f_cbyslj + ",f_ye = '" + jfmodel.f_yhycje + "' where sys_id='" + jfmodel.f_khbhid + "'"; int flag_cb = _iAccessDataTrans.ExecuteSql(updatecb); int flag_kh = _iAccessDataTrans.ExecuteSql(updatekh); //写入客户表日志 #region 写入日志 List <IDictionary <string, string> > array = new List <IDictionary <string, string> >(); IDictionary <string, string> temp = null; #region 对比各个业务子段,将不同的写入array if (jfmodel.f_yhye != jfmodel.f_khyye) { temp = new Dictionary <string, string>(); temp.Add("key", "f_ycje"); temp.Add("oldvalue", jfmodel.f_khyye); temp.Add("newvalue", jfmodel.f_yhye); temp.Add("name", "绿化表押金"); array.Add(temp); } if (jfmodel.f_yhycje != jfmodel.f_khyycje) { temp = new Dictionary <string, string>(); temp.Add("key", "f_ye"); temp.Add("oldvalue", jfmodel.f_khyycje); temp.Add("newvalue", jfmodel.f_yhycje); temp.Add("name", "余额"); array.Add(temp); } if (jfmodel.f_syhtjjzsf != jfmodel.f_khytjjzsf) { temp = new Dictionary <string, string>(); temp.Add("key", "f_tjjzsf"); temp.Add("oldvalue", jfmodel.f_khytjjzsf); temp.Add("newvalue", jfmodel.f_syhtjjzsf); temp.Add("name", "调价结转水费"); array.Add(temp); } if (jfmodel.f_syhtjjzpwf != jfmodel.f_khytjjzpwf) { temp = new Dictionary <string, string>(); temp.Add("key", "f_tjjzpwf"); temp.Add("oldvalue", jfmodel.f_khytjjzpwf); temp.Add("newvalue", jfmodel.f_syhtjjzpwf); temp.Add("name", "调价结转污水处理费"); array.Add(temp); } if (jfmodel.f_cbyslj == null || jfmodel.f_cbyslj == "") { jfmodel.f_cbyslj = "0"; } if (model_tbl_ld_khb.f_ljqf == null || model_tbl_ld_khb.f_ljqf == "") { model_tbl_ld_khb.f_ljqf = "0"; } if (double.Parse(jfmodel.f_cbyslj) > 0) { temp = new Dictionary <string, string>(); temp.Add("key", "f_ljqf"); temp.Add("oldvalue", model_tbl_ld_khb.f_ljqf); temp.Add("newvalue", (double.Parse(model_tbl_ld_khb.f_ljqf) - double.Parse(jfmodel.f_cbyslj)).ToString()); temp.Add("name", "累计欠费"); array.Add(temp); } #endregion sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_khb", jfmodel.f_khbhid.ToString(), "tbl_ld_jfb_detail", "缴费表", array, "", _iAccessDataTrans); #endregion //缴费成功 resultDic["result"] = "true"; //resultDic["message"] = jfbhid; resultDic["message"] = jfmodel.f_yhycje; resultDic["jfbh"] = jfmodel.f_jfbh; _iAccessDataTrans.getTrans().commit(); } else { _iAccessDataTrans.getTrans().rollback(); resultDic["result"] = "false"; resultDic["message"] = "传入缴费金额" + payAmount + "与该用户实际欠费金额" + bqje + "不符"; } } } } else { _iAccessDataTrans.getTrans().rollback(); resultDic["result"] = "false"; resultDic["message"] = "传入错误的客户编号" + khbh; } } catch (System.Exception ex) { if (_iAccessDataTrans != null) { _iAccessDataTrans.getTrans().rollback(); } resultDic["result"] = "false"; resultDic["message"] = "程序异常" + ex.ToString(); } return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic)); }
/// <summary> /// //projclass = 3时进行的归档操作,执行落数程序 /// </summary> /// <param name="sys_ids"></param> /// <param name="str_facterid"></param> /// <param name="ds_facter"></param> /// <param name="str_txt_bak_message"></param> /// <param name="clientInf"></param> /// <returns></returns> public string set_complete(string sys_ids, string str_facterid, DataSet ds_facter, string str_txt_bak_message, string clientInf) { /* * all_result返回参数的整理: * 1、"{\"result\":\"true\",\"message\":\"\"}"----》第二次点击落地按钮,(理论上不应该出现这个情况,有可能是第一次操作时整个操作流程没有完成,所以造成用户可以点击这个按钮,所以此处的操作仅实现状态修改,返回值为true) * 2、"{\"result\":\"submit\",\"message\":\"" + messageString + "\"}";----》此时message是一个字符串,shpid|path * 3、"{\"result\":\"false\",\"message\":\"" + messageString + "\"}";----》此时message是一个字符串,异常信息。 * 4、"{\"result\":\"submitqueue\",\"message\":\"\"}"----》成功加入队列 * */ IDictionary <string, string> clientInfoDic = Eva.Library.Format.FormatEntityTool.FormatJsonToDic(clientInf); string userid = clientInfoDic["userid"]; string username = clientInfoDic["username"]; string all_result = ""; string[] sys_idss = sys_ids.Split(','); for (int i = 0; i < sys_idss.Length; i++) { try { _model_tbl_maintable = _idal_itbl_maintable.GetList(" sys_id='" + sys_idss[i].ToString() + "'", "", "*", "", "", null)[0]; if (all_result == "") { string result = ""; string sql = ""; _t = commonclass.CreateIAccessDataTrans(); _t.getTrans().begin(); #region businesscode //businesscode //在此处添加针对projclassid = 3的业务代码 //更改水表表,用户表,客户表的状态,抄本信息(多个客户) //置空客户表f_value1,f_value2的状态 //更新本表的状态 model_tbl_ld_xhhbt = idal_tbl_ld_xhhbt.GetList(" fk_tbl_maintable_sys_id='" + sys_idss[i].ToString() + "'", "", "*", "", "", null)[0]; model_tbl_ld_cben = idal_tbl_ld_cben.GetList("f_cbmc ='QH023'", "", "*", "", "", null)[0]; IList <sara.dd.ldsw.model.tbl_ld_xhhbtzb> model_tbl_ld_xhhbtzb = idal_tbl_ld_xhhbtzb.GetList(" fk_tbl_ld_xhhbt_sys_id='" + model_tbl_ld_xhhbt.sys_id + "'", "", "*", "", "", null); foreach (sara.dd.ldsw.model.tbl_ld_xhhbtzb model in model_tbl_ld_xhhbtzb) { model_tbl_ld_khb = idal_tbl_ld_khb.GetList(" f_khbh='" + model.f_khbh + "'", "", "*", "", "", null)[0]; string khfz = model_tbl_ld_khb.f_khfz; string khfzid = model_tbl_ld_khb.f_khfzid; string[] khfzarr = khfz.Split(','); string[] khfzidarr = khfzid.Split(','); string newkhfz = ""; string newkhfzid = ""; if (khfz == "") { newkhfz = "龙达水务清户表"; newkhfzid = "4059"; } else { for (int a = 0; a < khfzarr.Length; a++) { if (khfzarr[a] == "龙达水务新立户表" || khfzarr[a] == "客服中心总表" || khfzarr[a] == "客服中心大用户表" || khfzarr[a] == "经营中心考核表" || khfzarr[a] == "经营中心排子表" || khfzarr[a] == "经营中心远传表" || khfzarr[a] == "经营中心居民表") { } else { newkhfz += khfzarr[a] + ','; newkhfzid += khfzidarr[a] + ','; } } newkhfz = newkhfz.TrimEnd(',') + "," + "龙达水务清户表"; newkhfzid = newkhfzid.TrimEnd(',') + "," + "4059"; } sql = " update tbl_ld_khb set f_zt = '销户' , f_ztid ='1',f_value1='',f_value2='',"; sql += "f_cbbh='" + model_tbl_ld_cben.f_cbbh + "',f_cbbhid='" + model_tbl_ld_cben.sys_id + "',"; sql += "f_cbyxm='" + model_tbl_ld_cben.f_cbymc + "',f_cbyid='" + model_tbl_ld_cben.f_cbyid + "',"; sql += "f_khfz='" + newkhfz + "',f_khfzid='" + newkhfzid + "',"; sql += "f_cbzq='" + model_tbl_ld_cben.f_cbzq + "',f_cbmc='" + model_tbl_ld_cben.f_cbmc + "' where sys_id ='" + model.f_khbhid + "'"; _t.ExecuteSql(sql); //在客户表中加日志 List <IDictionary <string, string> > array = new List <IDictionary <string, string> >(); if (model_tbl_ld_khb.f_zt != "销户") { IDictionary <string, string> temp = new Dictionary <string, string>(); temp.Add("key", "f_zt"); temp.Add("oldvalue", model_tbl_ld_khb.f_zt); temp.Add("newvalue", "销户"); temp.Add("name", "状态"); array.Add(temp); } if (model_tbl_ld_khb.f_khfz != newkhfz) { IDictionary <string, string> temp = new Dictionary <string, string>(); temp.Add("key", "f_khfz"); temp.Add("oldvalue", model_tbl_ld_khb.f_khfz); temp.Add("newvalue", newkhfz); temp.Add("name", "客户分组"); array.Add(temp); } if (model_tbl_ld_cben.f_cbbh != model_tbl_ld_khb.f_cbbh) { IDictionary <string, string> temp = new Dictionary <string, string>(); temp.Add("key", "f_cbbh"); temp.Add("oldvalue", model_tbl_ld_khb.f_cbbh); temp.Add("newvalue", model_tbl_ld_cben.f_cbbh); temp.Add("name", "抄本编号"); array.Add(temp); } sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_khb", model_tbl_ld_khb.sys_id.ToString(), "tbl_ld_xhhbt_detail", "用户销户", array, clientInf, _t); model_tbl_ld_sbb = idal_tbl_ld_sbb.GetList(" f_khbh='" + model.f_khbh + "'", "", "*", "", "", null)[0]; string sbfz = model_tbl_ld_sbb.f_sbfz; string sbfzid = model_tbl_ld_khb.f_sbfzid; string[] sbfzarr = sbfz.Split(','); string[] sbfzidarr = sbfzid.Split(','); string newsbfz = ""; string newsbfzid = ""; if (sbfz == "") { newsbfz = "龙达水务清户表"; newsbfzid = "4100"; } else { for (int a = 0; a < sbfzarr.Length; a++) { if (sbfzarr[a] == "龙达水务新立户表" || sbfzarr[a] == "客服中心总表" || sbfzarr[a] == "客服中心大用户表" || sbfzarr[a] == "经营中心考核表" || sbfzarr[a] == "经营中心排子表" || sbfzarr[a] == "经营中心远传表" || sbfzarr[a] == "经营中心居民表") { } else { newsbfz += sbfzarr[a] + ','; newsbfzid += sbfzidarr[a] + ','; } } newsbfz = newsbfz.TrimEnd(',') + "," + "龙达水务清户表"; newsbfzid = newsbfzid.TrimEnd(',') + "," + "4100"; } sql = " update tbl_ld_sbb set f_zt = '销户' , f_ztid ='1',f_sbfz='" + newsbfz + "',f_sbfzid='" + newsbfzid + "' where f_khbh ='" + model.f_khbh + "'"; _t.ExecuteSql(sql); //在水表表中加日志 List <IDictionary <string, string> > array1 = new List <IDictionary <string, string> >(); if (model_tbl_ld_sbb.f_zt != "销户") { IDictionary <string, string> temp = new Dictionary <string, string>(); temp.Add("key", "f_zt"); temp.Add("oldvalue", model_tbl_ld_sbb.f_zt); temp.Add("newvalue", "销户"); temp.Add("name", "状态"); array1.Add(temp); } if (model_tbl_ld_sbb.f_sbfz != newsbfz) { IDictionary <string, string> temp = new Dictionary <string, string>(); temp.Add("key", "f_khfz"); temp.Add("oldvalue", model_tbl_ld_sbb.f_sbfz); temp.Add("newvalue", newsbfz); temp.Add("name", "水表分组"); array1.Add(temp); } sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_sbb", model_tbl_ld_sbb.sys_id.ToString(), "tbl_ld_xhhbt_detail", "用户销户", array1, clientInf, _t); model_tbl_ld_yhb = idal_tbl_ld_yhb.GetList(" f_khbh='" + model.f_khbh + "'", "", "*", "", "", null)[0]; string yhfz = model_tbl_ld_yhb.f_yhfz; string yhfzid = model_tbl_ld_khb.f_yhfzid; string[] yhfzarr = yhfz.Split(','); string[] yhfzidarr = yhfzid.Split(','); string newyhfz = ""; string newyhfzid = ""; if (yhfz == "") { newyhfz = "龙达水务清户表"; newyhfzid = "4138"; } else { for (int a = 0; a < sbfzarr.Length; a++) { if (yhfzarr[a] == "龙达水务新立户表" || yhfzarr[a] == "客服中心总表" || yhfzarr[a] == "客服中心大用户表" || yhfzarr[a] == "经营中心考核表" || yhfzarr[a] == "经营中心排子表" || yhfzarr[a] == "经营中心远传表" || yhfzarr[a] == "经营中心居民表") { } else { newyhfz += yhfzarr[a] + ','; newyhfzid += yhfzidarr[a] + ','; } } newyhfz = newyhfz.TrimEnd(',') + "," + "龙达水务清户表"; newyhfzid = newyhfzid.TrimEnd(',') + "," + "4138"; } sql = " update tbl_ld_yhb set f_zt = '销户' , f_ztid ='3',f_yhfz='" + newyhfz + "',f_yhfzid='" + newyhfzid + "' where f_khbh ='" + model.f_khbh + "'"; _t.ExecuteSql(sql); //在用户表中加日志 List <IDictionary <string, string> > array2 = new List <IDictionary <string, string> >(); if (model_tbl_ld_yhb.f_zt != "销户") { IDictionary <string, string> temp = new Dictionary <string, string>(); temp.Add("key", "f_zt"); temp.Add("oldvalue", model_tbl_ld_yhb.f_zt); temp.Add("newvalue", "销户"); temp.Add("name", "状态"); array2.Add(temp); } if (model_tbl_ld_yhb.f_yhfz != newsbfz) { IDictionary <string, string> temp = new Dictionary <string, string>(); temp.Add("key", "f_khfz"); temp.Add("oldvalue", model_tbl_ld_yhb.f_yhfz); temp.Add("newvalue", newyhfz); temp.Add("name", "用户分组"); array2.Add(temp); } sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_yhb", model_tbl_ld_yhb.sys_id.ToString(), "tbl_ld_xhhbt_detail", "用户销户", array2, clientInf, _t); sql = " update tbl_ld_xhhbt set f_zt = '归档' , f_ztid ='2',f_czr='" + username + "',f_czrid='" + userid + "',f_czsj=to_date('" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd hh24:mi:ss') where sys_id ='" + model_tbl_ld_xhhbt.sys_id + "'"; _t.ExecuteSql(sql); } #endregion //调整数据状态 NameValueCollection nvc_maintableparameters = new NameValueCollection(); nvc_maintableparameters.Add("sys_processnextuser", "^nextuser"); nvc_maintableparameters.Add("fk_tbl_maintable_sys_id", "^null"); nvc_maintableparameters.Add("fk_workflow_sys_id", "^null"); result = _hic.NextStateItemNew(sys_idss[i].ToString(), nvc_maintableparameters, str_facterid, ds_facter, str_txt_bak_message, "", "", clientInf, _t); if (result == "") { _t.getTrans().commit(); } else { _t.getTrans().rollback(); all_result = "{\"result\":\"false\",\"message\":\"" + result + "\"}"; } } } catch (Exception ex) { all_result = "{\"result\":\"false\",\"message\":\"" + ex.Message + "\"}"; } } if (all_result == "") { // all_result = "{\"result\":\"true\",\"message\":\"\"}"; } return(all_result); }