//产品信息
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("请选择微信或者支付宝打开");
}
}
}
