//产品信息 public static JArray getSellOrderInfo(string mechineID) { string mechineSellOrderInfo = null; try { mechineSellOrderInfo = RedisHelper.GetRedisModel <string>(mechineID + "_SellOrderInfo"); } catch { } if (string.IsNullOrEmpty(mechineSellOrderInfo)) { string sql = "select * from asm_orderlistDetail where zt = 3 AND mechineID ='" + mechineID + "'"; DataTable dt = DbHelperSQL.Query(sql).Tables[0]; if (dt.Rows.Count > 0) { RedisHelper.SetRedisModel <string>(mechineID + "_SellOrderInfo", OperUtil.DataTableToJsonWithJsonNet(dt)); mechineSellOrderInfo = OperUtil.DataTableToJsonWithJsonNet(dt); } } return(mechineSellOrderInfo == null ? new JArray() : (JArray)JsonConvert.DeserializeObject(mechineSellOrderInfo)); }
public void sendKongyLDMsg() { string sql1 = "SELECT o.mechineID,o.productID,COUNT(*) as needNum,(SELECT proName from asm_product p WHERE p.productID=o.productID) proName" + " FROM asm_orderlistDetail o" + " where o.createTime = '" + DateTime.Now.AddDays(1).ToString("yyyy-MM-dd") + "' and o.zt = 5 GROUP BY mechineID,productID"; DataTable dt = DbHelperSQL.Query(sql1).Tables[0]; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { string sql2 = "SELECT isnull(SUM((ldNum - csldNum)),0) as tgNum FROM asm_ldInfo WHERE mechineID =" + dt.Rows[i]["mechineID"].ToString() + " AND productID =" + dt.Rows[i]["productID"].ToString(); DataTable d2 = DbHelperSQL.Query(sql2).Tables[0]; double num = double.Parse(dt.Rows[i]["needNum"].ToString()); double sy = double.Parse(d2.Rows[0]["tgNum"].ToString()); if (num > sy) { string sql3 = "SELECT m.bh,m.mechineName,o.linkphone FROM asm_mechine m left JOIN asm_opera o ON m.dls = o.id where m.id =" + dt.Rows[i]["mechineID"].ToString(); DataTable d3 = DbHelperSQL.Query(sql3).Tables[0]; //发送短信 OperUtil.sendMessage6(d3.Rows[0]["linkphone"].ToString(), dt.Rows[i]["proName"].ToString(), d3.Rows[0]["bh"].ToString()); } } } }
//限时特价信息 public static JArray getXSTJList(string mechineID) { string mechineXSTJList = null; try { mechineXSTJList = RedisHelper.GetRedisModel <string>(mechineID + "_XSTJList"); } catch { } if (string.IsNullOrEmpty(mechineXSTJList)) { string sql = @"select * from asm_xstj where mechineID=@mechineID order by timeSpan desc"; sql = sql.Replace("@mechineID", mechineID); DataTable dt = DbHelperSQL.Query(sql).Tables[0]; if (dt.Rows.Count > 0) { RedisHelper.SetRedisModel <string>(mechineID + "_XSTJList", OperUtil.DataTableToJsonWithJsonNet(dt)); mechineXSTJList = OperUtil.DataTableToJsonWithJsonNet(dt); } } return(mechineXSTJList == null ? new JArray() : (JArray)JsonConvert.DeserializeObject(mechineXSTJList)); }
//产品信息 public static JArray getCompanyProductList(string companyID) { string companyProductList = null; try { companyProductList = RedisHelper.GetRedisModel <string>(companyID + "_ProductListSet"); } catch { } if (string.IsNullOrEmpty(companyProductList)) { string sql = @"select * from asm_product where is_del = 0 AND companyID = @companyID"; sql = sql.Replace("@companyID", companyID); DataTable dt = DbHelperSQL.Query(sql).Tables[0]; if (dt.Rows.Count > 0) { RedisHelper.SetRedisModel <string>(companyID + "_ProductListSet", OperUtil.DataTableToJsonWithJsonNet(dt)); companyProductList = OperUtil.DataTableToJsonWithJsonNet(dt); } } return(companyProductList == null ? new JArray() : (JArray)JsonConvert.DeserializeObject(companyProductList)); }
//可用料道信息 public static JArray getMechineLDList(string mechineID) { string mechineLDList = null; try { mechineLDList = RedisHelper.GetRedisModel <string>(mechineID + "_LDList"); } catch { } if (string.IsNullOrEmpty(mechineLDList)) { //string sql = @"SELECT distinct productID FROM asm_ldInfo WHERE mechineID =@mechineID AND zt != 1 AND productID != '' "; string sql = @"SELECT productID, sum(case when zt = 0 then 0 else ld_productNum end) errorld_productNum FROM asm_ldInfo WHERE mechineID = @mechineID AND productID != '' GROUP BY productID"; sql = sql.Replace("@mechineID", mechineID); DataTable dt = DbHelperSQL.Query(sql).Tables[0]; if (dt.Rows.Count > 0) { RedisHelper.SetRedisModel <string>(mechineID + "_LDList", OperUtil.DataTableToJsonWithJsonNet(dt)); mechineLDList = OperUtil.DataTableToJsonWithJsonNet(dt); } } return(mechineLDList == null ? new JArray() : (JArray)JsonConvert.DeserializeObject(mechineLDList)); }
//产品信息 public static JArray getVideoInfoList() { string mechineVideoInfoList = null; try { mechineVideoInfoList = RedisHelper.GetRedisModel <string>("_VideoInfoList"); } catch { } if (string.IsNullOrEmpty(mechineVideoInfoList)) { string sql = "select * from asm_video where shType=1"; DataTable dt = DbHelperSQL.Query(sql).Tables[0]; if (dt.Rows.Count > 0) { RedisHelper.SetRedisModel <string>("_VideoInfoList", OperUtil.DataTableToJsonWithJsonNet(dt)); mechineVideoInfoList = OperUtil.DataTableToJsonWithJsonNet(dt); } } return(mechineVideoInfoList == null ? new JArray() : (JArray)JsonConvert.DeserializeObject(mechineVideoInfoList)); }
//产品信息 public static JArray getVideoAddMechine(string mechineID) { string mechineVideoAddMechine = null; try { mechineVideoAddMechine = RedisHelper.GetRedisModel <string>(mechineID + "_VideoAddMechine"); } catch { } if (string.IsNullOrEmpty(mechineVideoAddMechine)) { string sql = "select * from asm_videoAddMechine where mechineID='" + mechineID + "' and zt=0 and tfType!=0 and ((tfType=1 and times<tfcs) or (tfType=2 and GETDATE()<valiDate)) and is_open=0 and (GETDATE()>startTime or startTime is null)"; DataTable dt = DbHelperSQL.Query(sql).Tables[0]; if (dt.Rows.Count > 0) { RedisHelper.SetRedisModel <string>(mechineID + "_VideoAddMechine", OperUtil.DataTableToJsonWithJsonNet(dt)); mechineVideoAddMechine = OperUtil.DataTableToJsonWithJsonNet(dt); } } return(mechineVideoAddMechine == null ? new JArray() : (JArray)JsonConvert.DeserializeObject(mechineVideoAddMechine)); }
public void myTimer_ElapsedT(object source, ElapsedEventArgs e) { //发送温度异常短信 // string sqlT3 = "select * from asm_mechine where sendT=1 and lastReqTime is not null and id not in (68,69)"; DataTable dt3 = DbHelperSQL.Query(sqlT3).Tables[0]; if (dt3.Rows.Count > 0) { for (int i = 0; i < dt3.Rows.Count; i++) { try { string sql21 = "select linkphone from asm_opera where id='" + dt3.Rows[i]["operaID"].ToString() + "'"; string sql22 = "select linkphone from asm_company where id='" + dt3.Rows[i]["companyID"].ToString() + "'"; DataTable d21 = DbHelperSQL.Query(sql21).Tables[0]; DataTable d22 = DbHelperSQL.Query(sql22).Tables[0]; if (d21.Rows.Count > 0 && d21.Rows[0]["linkphone"].ToString() != "") { OperUtil.sendMessage3(d21.Rows[0]["linkphone"].ToString(), dt3.Rows[i]["mechineName"].ToString(), dt3.Rows[i]["lastReqTime"].ToString().Substring(11, 5), dt3.Rows[i]["temperture"].ToString()); } if (d22.Rows.Count > 0 && d22.Rows[0]["linkphone"].ToString() != "") { OperUtil.sendMessage3(d22.Rows[0]["linkphone"].ToString(), dt3.Rows[i]["mechineName"].ToString(), dt3.Rows[i]["lastReqTime"].ToString().Substring(11, 5), dt3.Rows[i]["temperture"].ToString()); } string sqlupdate = "update asm_mechine set sendT=0 where id=" + dt3.Rows[i]["id"].ToString(); DbHelperSQL.ExecuteSql(sqlupdate); } catch (Exception ex) { OperUtil.Debuglog("cuowu=" + ex.Message, "短信_.txt"); } } } //更新活动有效期 是否启用 string update1 = "update asm_activity set statu=0 where startTime is not null and endTime is not null and endTime<GETDATE()"; string update2 = "update asm_activity set statu=1 where startTime is not null and endTime is not null and GETDATE()>startTime and GETDATE()<endTime"; string update3 = "update asm_pay_activity set statu=0 where startTime is not null and endTime is not null and endTime<GETDATE()"; string update4 = "update asm_pay_activity set statu=1 where startTime is not null and endTime is not null and GETDATE()>startTime and GETDATE()<endTime"; string update5 = "update asm_zfbhb set status=0 where startTime is not null and endTime is not null and endTime<GETDATE()"; string update6 = "update asm_zfbhb set status=1 where startTime is not null and endTime is not null and GETDATE()>startTime and GETDATE()<endTime"; List <string> list = new List <string>(); list.Add(update1); list.Add(update2); list.Add(update3); list.Add(update4); list.Add(update5); list.Add(update6); DbHelperSQL.ExecuteSqlTran(list); string start = DateTime.Now.ToString("yyyy-MM-dd 00:00:00"); string end = DateTime.Now.ToString("yyyy-MM-dd 23:59:59"); calInComeTJ(start, end); }
//安卓屏幕的产品类别 public static void getProductTypeInfo() { string sql = "select * from asm_protype"; DataTable dt = DbHelperSQL.Query(sql).Tables[0]; if (dt.Rows.Count > 0) { Util.log("dt=" + OperUtil.DataTableToJsonWithJsonNet(dt), "updateProductType.txt"); SetNewRedisInfo("_productTypeInfoSet", OperUtil.DataTableToJsonWithJsonNet(dt)); } }
public void myTimer_Elapsed(object source, ElapsedEventArgs e) { checkSellDetail(); checkOrderDetail(); //发送离线短信 string sql2 = "select *,DATEDIFF(MI,convert(datetime,lastReqTime),getdate()) last from asm_mechine where DATEDIFF(MI,convert(datetime,lastReqTime),getdate())>5 and statu=0 and sendF!=1"; DataTable d2 = DbHelperSQL.Query(sql2).Tables[0]; string sql1 = "update asm_mechine set statu=1,brokenTime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' where DATEDIFF(MI,convert(datetime,lastReqTime),getdate())>5 and statu=0"; DbHelperSQL.ExecuteSql(sql1); if (d2.Rows.Count > 0) { for (int i = 0; i < d2.Rows.Count; i++) { string sql3 = "insert into asm_mechine_statu (mechineID,breakID,time,statu) values(" + d2.Rows[i]["id"].ToString() + ",2,'" + DateTime.Now + "',0)"; DbHelperSQL.ExecuteSql(sql3); //发短信 try { string sql21 = "select linkphone from asm_opera where id='" + d2.Rows[i]["dls"].ToString() + "'"; string sql22 = "select linkphone from asm_company where id='" + d2.Rows[i]["companyID"].ToString() + "'"; DataTable d21 = DbHelperSQL.Query(sql21).Tables[0]; DataTable d22 = DbHelperSQL.Query(sql22).Tables[0]; if (d21.Rows.Count > 0 && d21.Rows[0]["linkphone"].ToString() != "") { OperUtil.Debuglog("d21.Rows.Count=" + d21.Rows.Count + ";phone=" + d21.Rows[0]["linkphone"].ToString(), "短信_.txt"); OperUtil.sendMessage1(d21.Rows[0]["linkphone"].ToString(), d2.Rows[i]["mechineName"].ToString(), d2.Rows[i]["last"].ToString()); } if (d22.Rows.Count > 0 && d22.Rows[0]["linkphone"].ToString() != "") { OperUtil.sendMessage1(d22.Rows[0]["linkphone"].ToString(), d2.Rows[i]["mechineName"].ToString(), d2.Rows[i]["last"].ToString()); } string sqlupdate = "update asm_mechine set sendF=1 where id=" + d2.Rows[i]["id"].ToString(); DbHelperSQL.ExecuteSql(sqlupdate); } catch (Exception ex) { OperUtil.Debuglog("cuowu=" + ex.Message, "短信_.txt"); } } } }
/// <summary> /// 2019-09-04发送会员公众号通知 /// </summary> public void getProductbg() { string sqlc = "select * from asm_company"; DataTable dc1 = DbHelperSQL.Query(sqlc).Tables[0]; if (dc1.Rows.Count > 0) { String time1 = DateTime.Now.ToString("HH:mm"); for (int k = 0; k < dc1.Rows.Count; k++) { if (time1 == dc1.Rows[k]["p3"].ToString()) { string sql6 = "select b.mechineName,a.* from asm_orderlistDetail a left join asm_mechine b on a.mechineid = b.id where a.createTime = '" + DateTime.Now.ToString("yyyy-MM-dd") + "' and a.zt = 4 and a.companyID = " + dc1.Rows[k]["id"].ToString(); OperUtil.Debuglog("定时执行正在执行" + sql6, "_tongzhi.txt"); DataTable dd6 = DbHelperSQL.Query(sql6).Tables[0]; if (dd6.Rows.Count > 0) { for (int i = 0; i < dd6.Rows.Count; i++) { string sqlM = "select * from asm_member where id=" + dd6.Rows[i]["memberID"].ToString(); OperUtil.Debuglog("定时执行正在执行" + sqlM, "_tongzhi.txt"); DataTable dm = DbHelperSQL.Query(sqlM).Tables[0]; if (dm.Rows.Count > 0) { wxHelper wx = new wxHelper(dd6.Rows[i]["companyID"].ToString()); string data = TemplateMessage.getProduct(dm.Rows[0]["openID"].ToString(), OperUtil.getMessageID(dd6.Rows[i]["companyID"].ToString(), "OPENTM407685552"), "亲爱的会员,您今日订购的商品还未取货", "" + dd6.Rows[i]["code"].ToString() + "", "" + dd6.Rows[i]["mechineName"].ToString() + "", "请及时取件,否则第二天会自动失效处理"); TemplateMessage.SendTemplateMsg(wx.IsExistAccess_Token(dd6.Rows[i]["companyID"].ToString()), data); OperUtil.insertNotice(dm.Rows[0]["id"].ToString(), "待取货通知", "您今日订购的商品还未取货,请您及时取货否则第二天作失效处理,请前往指定的售卖机取货,取货码:" + dd6.Rows[i]["code"].ToString()); } } } } //定时检测限时特价 // clearXSTJ(dc1.Rows[k]["id"].ToString()); } } }
public static string getMechine(string mechineID) { string mechineInfo = null; try { mechineInfo = RedisHelper.GetRedisModel <string>(mechineID + "_mechineInfoSet"); } catch { } if (string.IsNullOrEmpty(mechineInfo)) { string sql = "select am.*,ac.p1,ac.p2,ac.p3,ac.p4,ac.p5,ac.p6,ac.p7,ac.p8,ac.p9,ac.p10,am.setTem,'' videoListNo,'' productTypeNo,'' androidProductNo,'' priceSwitch from asm_mechine am left join asm_company ac on am.companyID=ac.id where am.id='" + mechineID + "'"; DataTable dt = DbHelperSQL.Query(sql).Tables[0]; if (dt.Rows.Count > 0) { RedisHelper.SetRedisModel <string>(mechineID + "_mechineInfoSet", OperUtil.DataTableToJsonWithJsonNet(dt)); mechineInfo = OperUtil.DataTableToJsonWithJsonNet(dt); } } return(mechineInfo); }
//机器库存中去重后的产品列表 public static JArray getMechineKcProduct(string mechineID) { string kcProduct = null; try { kcProduct = RedisHelper.GetRedisModel <string>(mechineID + "_KcProduct"); } catch { } if (string.IsNullOrEmpty(kcProduct)) { string sql = @"select t.* from (select asm_kcDetail.*, row_number() over(partition by productID order by id desc) rn from asm_kcDetail where mechineID =@mechineID) t where rn = 1"; sql = sql.Replace("@mechineID", mechineID); DataTable dt = DbHelperSQL.Query(sql).Tables[0]; if (dt.Rows.Count > 0) { RedisHelper.SetRedisModel <string>(mechineID + "_KcProduct", OperUtil.DataTableToJsonWithJsonNet(dt)); kcProduct = OperUtil.DataTableToJsonWithJsonNet(dt); } } return(kcProduct == null ? new JArray() : (JArray)JsonConvert.DeserializeObject(kcProduct)); }
public static string login(string name, string pwd, string qx) { if (qx == "1") { string sql = "select * from [dbo].[asm_manager] where bh='" + name + "' and pwd='" + pwd + "'"; DataTable dt = DbHelperSQL.Query(sql).Tables[0]; if (dt.Rows.Count > 0) { OperUtil.Add("operaID", "0"); OperUtil.Add("AdminOperaID", "0"); OperUtil.setCooki("operaName", dt.Rows[0]["bh"].ToString()); return("1"); } else { return("2"); } } else if (qx == "2") { string sql = "select * from asm_opera where name='" + name + "' and pwd='" + pwd + "' and companyID=0"; DataTable dd = DbHelperSQL.Query(sql).Tables[0]; if (dd.Rows.Count > 0) { OperUtil.Add("operaID", dd.Rows[0]["id"].ToString()); OperUtil.Add("AdminOperaID", dd.Rows[0]["id"].ToString()); OperUtil.setCooki("operaName", dd.Rows[0]["bh"].ToString()); return("1"); } else { return("2"); } } return("2"); }
public void growUpMember() { //降级 string sql1 = "select * from asm_company"; DataTable dt1 = DbHelperSQL.Query(sql1).Tables[0]; if (dt1.Rows.Count > 0) { for (int i = 0; i < dt1.Rows.Count; i++) { string companyID = dt1.Rows[i]["id"].ToString(); string sql2 = "select * from asm_dj where companyID=" + dt1.Rows[i]["id"].ToString() + " order by djID"; DataTable dt2 = DbHelperSQL.Query(sql2).Tables[0]; if (dt2.Rows.Count > 0) { string day1 = dt2.Rows[0]["consumeDay"].ToString(); string day2 = dt2.Rows[1]["consumeDay"].ToString(); string day3 = dt2.Rows[2]["consumeDay"].ToString(); string sql = "select * from [dbo].[View_member_consumeCount30] where companyID=" + companyID + " and num>=" + day1 + " and num<" + day2 + " and phone!='' and phone is not null and hjhyDays=0"; DataTable dt = DbHelperSQL.Query(sql).Tables[0]; List <string> list = new List <string>(); for (int a = 0; a < dt.Rows.Count; a++) { if (dt.Rows[a]["dj"].ToString() != "1") { if (!string.IsNullOrEmpty(dt.Rows[a]["openID"].ToString())) { try { wxHelper wx = new wxHelper(dt1.Rows[0]["id"].ToString()); string data = TemplateMessage.getDJChange(dt.Rows[a]["openID"].ToString(), OperUtil.getMessageID(dt1.Rows[0]["id"].ToString(), "OPENTM406811407"), "尊敬的会员,您的会员等级发生变更", "" + dt.Rows[a]["dj"].ToString() + "", "1", "如有疑问,请拨打会员服务热线" + dt1.Rows[i]["customerPhone"].ToString()); string result = TemplateMessage.SendTemplateMsg(wx.IsExistAccess_Token(dt1.Rows[i]["id"].ToString()), data); Util.Debuglog("发送消息模板=" + dt.Rows[a]["openID"].ToString() + ";result=" + result, "会员等级消息模板.txt"); } catch (Exception e) { Util.Debuglog("e=" + e.Message, "会员等级消息模板.txt"); } } } list.Add("update asm_member set dj=1 where id=" + dt.Rows[a]["id"].ToString()); } DbHelperSQL.ExecuteSqlTran(list); sql = "select * from [dbo].[View_member_consumeCount30] where companyID=" + companyID + " and num>=" + day2 + " and num<" + day3 + " and phone!='' and phone is not null and hjhyDays=0"; DataTable d2 = DbHelperSQL.Query(sql).Tables[0]; List <string> list2 = new List <string>(); for (int b = 0; b < d2.Rows.Count; b++) { if (d2.Rows[b]["dj"].ToString() != "2") { if (!string.IsNullOrEmpty(d2.Rows[b]["openID"].ToString())) { try { wxHelper wx = new wxHelper(dt1.Rows[0]["id"].ToString()); string data = TemplateMessage.getDJChange(d2.Rows[b]["openID"].ToString(), OperUtil.getMessageID(dt1.Rows[0]["id"].ToString(), "OPENTM406811407"), "尊敬的会员,您的会员等级发生变更", "" + d2.Rows[b]["dj"].ToString() + "", "2", "如有疑问,请拨打会员服务热线" + dt1.Rows[i]["customerPhone"].ToString()); string result = TemplateMessage.SendTemplateMsg(wx.IsExistAccess_Token(dt1.Rows[i]["id"].ToString()), data); Util.Debuglog("发送消息模板=" + d2.Rows[b]["openID"].ToString() + ";result=" + result, "会员等级消息模板.txt"); } catch (Exception e) { Util.Debuglog("e=" + e.Message, "会员等级消息模板.txt"); } } } list2.Add("update asm_member set dj=2 where id=" + d2.Rows[b]["id"].ToString()); } DbHelperSQL.ExecuteSqlTran(list2); sql = "select * from [dbo].[View_member_consumeCount30] where companyID=" + companyID + " and num>=" + day3 + " and phone!='' and phone is not null and hjhyDays=0"; DataTable d3 = DbHelperSQL.Query(sql).Tables[0]; List <string> list3 = new List <string>(); string aaa = ""; for (int c = 0; c < d3.Rows.Count; c++) { if (d3.Rows[c]["dj"].ToString() != "3" && !string.IsNullOrEmpty(d3.Rows[c]["openID"].ToString())) { try { wxHelper wx = new wxHelper(dt1.Rows[0]["id"].ToString()); string data = TemplateMessage.getDJChange(d3.Rows[c]["openID"].ToString(), OperUtil.getMessageID(dt1.Rows[0]["id"].ToString(), "OPENTM406811407"), "尊敬的会员,您的会员等级发生变更", "" + d3.Rows[c]["dj"].ToString() + "", "3", "如有疑问,请拨打会员服务热线" + dt1.Rows[i]["customerPhone"].ToString()); string result = TemplateMessage.SendTemplateMsg(wx.IsExistAccess_Token(dt1.Rows[i]["id"].ToString()), data); Util.Debuglog("发送消息模板=" + d3.Rows[c]["openID"].ToString() + ";result=" + result, "会员等级消息模板.txt"); } catch (Exception e) { Util.Debuglog("e=" + e.Message, "会员等级消息模板.txt"); } } list3.Add("update asm_member set dj=3 where id=" + d3.Rows[c]["id"].ToString()); aaa = aaa + "update asm_member set dj=3 where id=" + d3.Rows[c]["id"].ToString(); } Util.Debuglog("list3=" + aaa, "会员等级消息模板.txt"); DbHelperSQL.ExecuteSqlTran(list3); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string userAgent = Request.UserAgent; if (userAgent.ToLower().Contains("micromessenger")) { this.type.Value = "wx"; } else if (userAgent.ToLower().Contains("alipayclient")) { this.type.Value = "zfb"; } mechineID = Request.QueryString["mechineID"].ToString(); payMoney = Request.QueryString["payMoney"].ToString(); asmpayid = Request.QueryString["asmpayid"].ToString(); SybWxPayService sybService = new SybWxPayService(mechineID); string url = "http://nq.bingoseller.com/pay/Notify.aspx"; string data = ""; if (this.type.Value == "wx") { long f = long.Parse((double.Parse(payMoney) * 100).ToString()); Dictionary <String, String> rsp = sybService.pay(f, DateTime.Now.ToFileTime().ToString(), "W01", "", "", "", "", url, ""); data = OperUtil.SerializeDictionaryToJsonString(rsp); //插入预处理订单信息 string json = (new JavaScriptSerializer()).Serialize(rsp); JObject jo = (JObject)JsonConvert.DeserializeObject(json); if (jo["retcode"].ToString() == "SUCCESS") { string appid = jo["appid"].ToString(); string cusid = jo["cusid"].ToString(); string trxid = jo["trxid"].ToString(); string reqsn = jo["reqsn"].ToString(); string payinfo = jo["payinfo"].ToString(); string update = "update asm_pay_info set appid='" + appid + "',cusid='" + cusid + "',trxid='" + trxid + "',statu='0',reqsn='" + reqsn + "',type='2',payType='1',trxamt=" + (double.Parse(payMoney) * 100) + " where asmpayid='" + asmpayid + "'"; url = payinfo; DbHelperSQL.ExecuteSql(update); Response.Write("<script>top.location.href='" + payinfo + "';</script>"); } } else if (this.type.Value == "zfb") { Dictionary <String, String> rsp = sybService.pay(long.Parse((double.Parse(payMoney) * 100).ToString()), DateTime.Now.ToFileTime().ToString(), "A01", "", "", "", "", url, ""); data = OperUtil.SerializeDictionaryToJsonString(rsp); string json = (new JavaScriptSerializer()).Serialize(rsp); JObject jo = (JObject)JsonConvert.DeserializeObject(json); if (jo["retcode"].ToString() == "SUCCESS") { string appid = jo["appid"].ToString(); string cusid = jo["cusid"].ToString(); string trxid = jo["trxid"].ToString(); string reqsn = jo["reqsn"].ToString(); string payinfo = jo["payinfo"].ToString(); string update = "update asm_pay_info set appid='" + appid + "',cusid='" + cusid + "',trxid='" + trxid + "',statu='0',reqsn='" + reqsn + "',type='2',payType='2',trxamt=" + (double.Parse(payMoney) * 100) + " where asmpayid='" + asmpayid + "'"; DbHelperSQL.ExecuteSql(update); Response.Redirect(payinfo); } } else { Response.Write("请选择微信或者支付宝打开"); } } }