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