protected void Page_Load(object sender, EventArgs e)
{
if (OperUtil.getCooki("vshop_openID") != "0")
{
this.member_ID.Value = Util.getMemberID();
}
else
{
string userAgent = Request.UserAgent;
if (userAgent.ToLower().Contains("micromessenger"))
{
Response.Redirect("WXCallback.aspx?companyID=" + OperUtil.getCooki("companyID"));
return;
}
}
string sql1 = "select * from asm_member where id='" + this.member_ID.Value + "'";
DataTable dt = DbHelperSQL.Query(sql1).Tables[0];
if (dt.Rows.Count > 0)
{
this.nickname.Value = dt.Rows[0]["nickname"].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (OperUtil.getCooki("vshop_openID") != "0")
{
this._companyID.Value = OperUtil.getCooki("companyID");
this._openID.Value = OperUtil.getCooki("vshop_openID");
this.memberID.Value = Util.getMemberID();
string sql = "select * from asm_member where id=" + this.memberID.Value;
DataTable dd = DbHelperSQL.Query(sql).Tables[0];
yue = dd.Rows[0]["AvailableMoney"].ToString();
if (dd.Rows[0]["pwd"].ToString() == "000000")
{
Response.Write("<script>alert('您当前交易密码为初始密码，请前往个人中心修改!');</script>");
}
}
else
{
this._companyID.Value = OperUtil.getCooki("companyID");
string userAgent = Request.UserAgent;
if (userAgent.ToLower().Contains("micromessenger"))
{
Response.Redirect("WXCallback.aspx?companyID=" + OperUtil.getCooki("companyID"));
return;
}
}
if (!IsPostBack)
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
//查询该会员是否设置支付密码没有的话弹出提示框设置
string str = Request.QueryString["req"].ToString();//trxid=111111&money=2222;
req = PwdHelper.DecodeDES(str, "bingoseller");
trxid = req.Split('&')[0].Split('=')[1];
money = req.Split('&')[1].Split('=')[1];
companyID = req.Split('&')[2].Split('=')[1];
this._money.Value = money;
this._trxid.Value = trxid;
this._companyID.Value = companyID;
if (OperUtil.getCooki("vshop_openID") != "0")
{
string sql = "select * from asm_member where openID='" + OperUtil.getCooki("vshop_openID") + "' and companyID=" + companyID;
DataTable dd = DbHelperSQL.Query(sql).Tables[0];
if (dd.Rows.Count <= 0)
{
//判断是否关注
wxHelper wx = new wxHelper(companyID);
if (wx.Get_UserInfo(OperUtil.getCooki("vshop_openID")).subscribe == "1")
{
Response.Redirect("WXCallback.aspx?companyID=" + this._companyID.Value);
}
else
{
//没关注
string sql12 = "select * from asm_company where id=" + companyID;
DataTable dt = DbHelperSQL.Query(sql12).Tables[0];
url = @"https://mp.weixin.qq.com/mp/profile_ext?action=home&__biz=" + dt.Rows[0]["biz"].ToString() + "#wechat_redirect";
Util.Debuglog("关注链接=" + url, "微信回调_.txt");
Response.Redirect(url);
}
}
else
{
//正常已经关注的
}
headURL = dd.Rows[0]["headurl"].ToString();
ye = dd.Rows[0]["AvailableMoney"].ToString();
string sql1 = "select * from asm_company where id=" + companyID;
DataTable d1 = DbHelperSQL.Query(sql1).Tables[0];
this._openID.Value = OperUtil.getCooki("vshop_openID");
companyName = d1.Rows[0]["name"].ToString();
}
else
{
Response.Redirect("weixincallback.aspx?companyID=" + companyID + "&req=" + str);
}
}
catch
{
Response.Write("<span style='color:#FF0000;font-size:20px'>" + "参数有误，请重试" + "</span>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (OperUtil.getCooki("vshop_openID") != "0")
{
company_ID = OperUtil.getCooki("companyID");
this.companyID.Value = company_ID;
this.member_ID.Value = Util.getMemberID();
initData();
}
else
{
string userAgent = Request.UserAgent;
if (userAgent.ToLower().Contains("micromessenger"))
{
Response.Redirect("WXCallback.aspx?companyID=" + this.companyID.Value);
return;
}
}
if (!IsPostBack)
{
Response.Cache.SetNoStore();
wxHelper wx = new wxHelper(this.companyID.Value);
string[] str = wx.GetWXInfo(this.Request.Url.ToString(), this.companyID.Value).Split(',');
time = str[0];
randstr = str[1];
signstr = str[2];
this.member_ID.Value = Util.getMemberID();
}
try
{
if (OperUtil.getCooki("vshop_openID") != "0")
{
//获取公众号的appid
string sql = "select * from asm_company where id=" + this.companyID.Value;
DataTable dt = DbHelperSQL.Query(sql).Tables[0];
if (dt.Rows.Count > 0 && !string.IsNullOrEmpty(dt.Rows[0]["appId"].ToString()))
{
this.appID.Value = dt.Rows[0]["appId"].ToString();
app_id = dt.Rows[0]["appId"].ToString();
}
this.member_ID.Value = Util.getMemberID();
}
else
{
string userAgent = Request.UserAgent;
if (userAgent.ToLower().Contains("micromessenger"))
{
Response.Redirect("WXCallback.aspx?companyID=" + this.companyID.Value);
return;
}
}
}
catch
{
this.member_ID.Value = Util.getMemberID();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (OperUtil.getCooki("vshop_openID") != "0")
{
this.memberID.Value = Util.getMemberID();
}
else
{
Response.Write("<script>window.location.href=homeIndex.aspx</script>");
}
this.companyID.Value = OperUtil.getCooki("companyID");
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
//查询该会员是否设置支付密码没有的话弹出提示框设置
//companyID = Request.QueryString["companyID"].ToString();
mechineID = Request.QueryString["mechineID"].ToString();
string sqlCC = "select companyID from asm_mechine where id='" + mechineID + "'";
DataTable dcc = DbHelperSQL.Query(sqlCC).Tables[0];
companyID = dcc.Rows[0]["companyID"].ToString();
this._companyID.Value = companyID;
this._mechineID.Value = mechineID;
this._memberID.Value = Util.getMemberID();
if (OperUtil.getCooki("vshop_openID") != "0")
{
string sql = "select * from asm_member where openID='" + OperUtil.getCooki("vshop_openID") + "' and companyID=" + companyID;
DataTable dd = DbHelperSQL.Query(sql).Tables[0];
if (dd.Rows.Count <= 0)
{
//判断是否关注
wxHelper wx = new wxHelper(companyID);
if (wx.Get_UserInfo(OperUtil.getCooki("vshop_openID")).subscribe == "1")
{
Response.Redirect("WXCallback.aspx?companyID=" + this._companyID.Value);
}
else
{
//没关注
string sql1 = "select * from asm_company where id=" + companyID;
DataTable dt = DbHelperSQL.Query(sql1).Tables[0];
url = @"https://mp.weixin.qq.com/mp/profile_ext?action=home&__biz=" + dt.Rows[0]["biz"].ToString() + "#wechat_redirect";
Response.Redirect(url);
}
}
else
{
//正常已经关注的
}
}
else
{
Response.Redirect("WXCallback.aspx?companyID=" + this._companyID.Value);
}
}
catch
{
Response.Write("<span style='color:#FF0000;font-size:20px'>" + "参数有误，请重试" + "</span>");
}
//this._mechineID.Value = "25";
//this._memberID.Value = "37";
}
protected void Page_Load(object sender, EventArgs e)
{
if (OperUtil.getCooki("vshop_openID") != "0")
{
this.memberID.Value = Util.getMemberID();
}
else
{
string userAgent = Request.UserAgent;
if (userAgent.ToLower().Contains("micromessenger"))
{
Response.Redirect("WXCallback.aspx?companyID=" + OperUtil.getCooki("companyID"));
return;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (OperUtil.getCooki("vshop_openID") != "0")
{
memberID = Util.getMemberID();
}
else
{
string userAgent = Request.UserAgent;
if (userAgent.ToLower().Contains("micromessenger"))
{
Response.Redirect("WXCallback.aspx?companyID=" + OperUtil.getCooki("companyID"));
return;
}
}
this._companyID.Value = OperUtil.getCooki("companyID");
this.member_ID.Value = memberID;
try
{
//获取会员信息
string sqlM = "select * from asm_member where id=" + memberID;
DataTable dm = DbHelperSQL.Query(sqlM).Tables[0];
headURL = dm.Rows[0]["headurl"].ToString();
ye = dm.Rows[0]["AvailableMoney"].ToString();
string sql1 = "select * from asm_company where id=" + this._companyID.Value;
DataTable d1 = DbHelperSQL.Query(sql1).Tables[0];
companyName = d1.Rows[0]["name"].ToString();
//订单生成
pszq = Request.QueryString["pszq"].ToString();
qsDate = Request.QueryString["qsDate"].ToString().Replace("/", "-");
zdDate = Request.QueryString["zdDate"].ToString();
psStr = Request.QueryString["psStr"].ToString();
psfs = Request.QueryString["psfs"].ToString();
selDate = Request.QueryString["selDate"].ToString();
orderNO = Request.QueryString["orderNO"].ToString();
productID = Request.QueryString["productID"].ToString();
mechineID = Request.QueryString["mechineID"].ToString();
createTime = Request.QueryString["createTime"].ToString();
yhfs = Request.QueryString["yhfs"].ToString();
this.mechine_id.Value = mechineID;
this.product_id.Value = productID;
this._pszq.Value = pszq;
this._qsDate.Value = qsDate;
this._zdDate.Value = zdDate;
this._psStr.Value = psStr;
this._psfs.Value = psfs;
this._selDate.Value = selDate;
this._orderNO.Value = orderNO;
this._createTime.Value = createTime;
this._fkzt.Value = fkzt;
this._yhfs.Value = yhfs;
syNum = pszq;
string trxid = ConvertDateTimeToInt(DateTime.Now).ToString() + mechineID;
this._trxid.Value = trxid;
string sql = "select * from asm_mechine where id=" + mechineID;
DataTable dt = DbHelperSQL.Query(sql).Tables[0];
if (dt.Rows.Count > 0)
{
qhAddress = dt.Rows[0]["addres"].ToString();
}
string sqlkf = "select * from asm_opera where id=" + dt.Rows[0]["operaID"].ToString();
phone = DbHelperSQL.Query(sqlkf).Tables[0].Rows[0]["linkphone"].ToString();
//初始化商品
string sql11 = "select * from asm_product where productID=" + productID;
DataTable dd = DbHelperSQL.Query(sql11).Tables[0];
if (dd.Rows.Count > 0)
{
productName = dd.Rows[0]["proName"].ToString();
this._proName.Value = productName;
description = dd.Rows[0]["description"].ToString();
half_price = double.Parse(dd.Rows[0]["price2"].ToString()) / 2;
this.halfPrice.Value = half_price.ToString();
totalMoney = (double.Parse(dd.Rows[0]["price2"].ToString()) * double.Parse(pszq)).ToString("f2");
if (yhfs.IndexOf('折') > -1)
{
string zk = yhfs.Replace("打", "").Replace("折", "");
totalMoney = (double.Parse(totalMoney) * double.Parse(zk) / 10).ToString("f2");
}
httpImgUrl = dd.Rows[0]["httpImageUrl"].ToString();
this._totalMoney.Value = totalMoney;
}
initData();
}
catch {
if (OperUtil.getCooki("vshop_openID") != "0")
{
this.member_ID.Value = Util.getMemberID();
memberID = Util.getMemberID();
}
else
{
string userAgent = Request.UserAgent;
if (userAgent.ToLower().Contains("micromessenger"))
{
Response.Redirect("WXCallback.aspx?companyID=" + OperUtil.getCooki("companyID"));
return;
}
}
orderNO = Request.QueryString["orderNO"].ToString();
string sql2 = "select * from asm_order where memberID=" + memberID + " and orderNO='" + orderNO + "'";
DataTable dt2 = DbHelperSQL.Query(sql2).Tables[0];
if (dt2.Rows.Count > 0)
{
syNum = dt2.Rows[0]["syNum"].ToString();
pszq = dt2.Rows[0]["zq"].ToString();
qsDate = dt2.Rows[0]["qsDate"].ToString();
zdDate = dt2.Rows[0]["zdDate"].ToString();
psStr = dt2.Rows[0]["psStr"].ToString();
psfs = dt2.Rows[0]["psfs"].ToString();
orderNO = dt2.Rows[0]["orderNO"].ToString();
productID = dt2.Rows[0]["productID"].ToString();
mechineID = dt2.Rows[0]["mechineID"].ToString();
createTime = dt2.Rows[0]["createTime"].ToString();
this.mechine_id.Value = dt2.Rows[0]["mechineID"].ToString();
this.product_id.Value = dt2.Rows[0]["productID"].ToString();
this._pszq.Value = dt2.Rows[0]["zq"].ToString();
this._qsDate.Value = dt2.Rows[0]["qsDate"].ToString();
this._zdDate.Value = dt2.Rows[0]["zdDate"].ToString();
this._psStr.Value = dt2.Rows[0]["psStr"].ToString();
this._psfs.Value = dt2.Rows[0]["psfs"].ToString();
this._orderNO.Value = dt2.Rows[0]["orderNO"].ToString();
this._createTime.Value = dt2.Rows[0]["createTime"].ToString();
this._fkzt.Value = dt2.Rows[0]["fkzt"].ToString();
qhAddress = dt2.Rows[0]["qhAddress"].ToString();
string sql12 = "select * from asm_mechine where id=" + mechineID;
DataTable dt = DbHelperSQL.Query(sql12).Tables[0];
if (dt.Rows.Count > 0)
{
string sqlkf = "select * from asm_opera where id=" + dt.Rows[0]["operaID"].ToString();
phone = DbHelperSQL.Query(sqlkf).Tables[0].Rows[0]["linkphone"].ToString();
}
//初始化商品
string sql1 = "select * from asm_product where productID=" + productID;
DataTable dd = DbHelperSQL.Query(sql1).Tables[0];
if (dd.Rows.Count > 0)
{
productName = dd.Rows[0]["proName"].ToString();
this._proName.Value = productName;
description = dd.Rows[0]["description"].ToString();
half_price = double.Parse(dd.Rows[0]["price2"].ToString()) / 2;
httpImgUrl = dd.Rows[0]["httpImageUrl"].ToString();
this.halfPrice.Value = half_price.ToString();
totalMoney = dt2.Rows[0]["totalMoney"].ToString();
this._totalMoney.Value = dt2.Rows[0]["totalMoney"].ToString();
}
//查询该订单的详细
string sql = "select * from asm_orderDetail where orderNO='" + orderNO + "' and memberID=" + dt2.Rows[0]["memberID"].ToString();
DataTable ds = DbHelperSQL.Query(sql).Tables[0];
if (ds.Rows.Count > 0)
{
string time = "";
for (int i = 0; i < ds.Rows.Count; i++)
{
time += ds.Rows[i]["createTime"].ToString() + ",";
}
time = time.Substring(0, time.Length - 1);
this._selDate.Value = time;
selDate = time;
}
string sql3 = "select * from asm_orderDetail where zt=3 and orderNO='" + orderNO + "' and memberID=" + dt2.Rows[0]["memberID"].ToString();
DataTable ds3 = DbHelperSQL.Query(sql3).Tables[0];
if (ds3.Rows.Count > 0)
{
string time = "";
for (int i = 0; i < ds3.Rows.Count; i++)
{
time += ds3.Rows[i]["createTime"].ToString() + ",";
}
time = time.Substring(0, time.Length - 1);
this._selDate.Value = time;
yzsDate = time;
}
string sql4 = "select * from asm_orderDetail where zt=2 and orderNO='" + orderNO + "' and memberID=" + dt2.Rows[0]["memberID"].ToString();
DataTable ds4 = DbHelperSQL.Query(sql4).Tables[0];
if (ds4.Rows.Count > 0)
{
string time = "";
for (int i = 0; i < ds4.Rows.Count; i++)
{
time += ds4.Rows[i]["createTime"].ToString() + ",";
}
time = time.Substring(0, time.Length - 1);
this._sxDate.Value = time;
sxDate = time;
}
string sql5 = "select * from asm_orderDetail where zt=1 and orderNO='" + orderNO + "' and memberID=" + dt2.Rows[0]["memberID"].ToString();
DataTable ds5 = DbHelperSQL.Query(sql5).Tables[0];
if (ds5.Rows.Count > 0)
{
string time = "";
for (int i = 0; i < ds5.Rows.Count; i++)
{
time += ds5.Rows[i]["createTime"].ToString() + ",";
}
time = time.Substring(0, time.Length - 1);
this._wcDate.Value = time;
wcDate = time;
}
string sql6 = "select * from asm_orderDetail where zt=4 and orderNO='" + orderNO + "' and memberID=" + dt2.Rows[0]["memberID"].ToString();
DataTable ds6 = DbHelperSQL.Query(sql6).Tables[0];
if (ds6.Rows.Count > 0)
{
string time = "";
for (int i = 0; i < ds6.Rows.Count; i++)
{
time += ds6.Rows[i]["createTime"].ToString() + ",";
}
time = time.Substring(0, time.Length - 1);
this._dqhDate.Value = time;
dqhDate = time;
}
initData();
}
}
}
public static string setupOk(string phone, string memberID)
{
string sql1 = "select * from asm_member where id!='" + memberID + "' and phone='" + phone + "' and companyID='" + OperUtil.getCooki("companyID") + "'";
Util.Debuglog("sql1=" + sql1, "_修改手机号.txt");
DataTable dt = DbHelperSQL.Query(sql1).Tables[0];
if (dt.Rows.Count > 0)
{
return("3");
}
string sql = "update asm_member set phone='" + phone + "' where id='" + memberID + "'";
Util.Debuglog("update=" + sql, "_修改手机号.txt");
int a = DbHelperSQL.ExecuteSql(sql);
if (a > 0)
{
string sql3 = "select * from asm_member where id='" + memberID + "'";
DataTable dd = DbHelperSQL.Query(sql3).Tables[0];
if (dd.Rows.Count > 0)
{
if (!dd.Rows[0]["certF"].ToString().Contains("phone"))
{
string sql2 = "update asm_member set certF=isnull(certF,'')+',phone' where id='" + memberID + "'";
DbHelperSQL.ExecuteSql(sql2);
}
}
return("1");
}
else
{
return("2");
}
}
protected void Page_Load(object sender, EventArgs e)
{
Dictionary <String, String> reqParams = new Dictionary <String, String>();
/**
* 此处注意,因为通联收银宝以后可能增加字段,所以,这里一定要动态遍历获取所有的请求参数
*
* */
for (int i = 0; i < Request.Form.Count; i++)
{
reqParams.Add(Request.Form.Keys[i], Request.Form[i].ToString());
}
if (!reqParams.ContainsKey("sign"))//如果不包含sign,则不进行处理
{
Response.Write("error");
return;
}
if (reqParams.ContainsKey("trxid"))
{
string json = (new JavaScriptSerializer()).Serialize(reqParams);
JObject jo = (JObject)JsonConvert.DeserializeObject(json);
string sql = "select p.trxid,p.activityID,o.productID,p.unionID,p.companyID,o.activityID acID,o.psMode,o.startTime,o.mechineID,o.memberID,o.orderNO,o.companyID,o.totalNum,o.source from asm_pay_info p left join asm_orderlist o on p.trxid=o.trxid"
+ " where p.trxid = '" + jo["trxid"] + "' and o.trxid = '" + jo["trxid"] + "' and statu = 0";
DataTable dtInfo = DbHelperSQL.Query(sql).Tables[0];
if (dtInfo.Rows.Count > 0)
{
string sql111 = "select top 1 * from asm_duihuan where newOrderNo='" + dtInfo.Rows[0]["orderNO"].ToString() + "' order by dhTime desc ";
DataTable asm_duihuanInfo = DbHelperSQL.Query(sql111).Tables[0];
if (asm_duihuanInfo.Rows.Count > 0 && (!string.IsNullOrEmpty(asm_duihuanInfo.Rows[0]["oldOrderNo"].ToString())))
{
Util.Debuglog("sql111=" + sql111, "dhProduct.txt");
List <string> list = new List <string>();
string sql2 = "update asm_orderlist set orderZT=4 where orderNO='" + asm_duihuanInfo.Rows[0]["oldOrderNo"].ToString() + "'";
string sql3 = "update asm_orderlistDetail set zt=7 where zt=5 and orderNO='" + asm_duihuanInfo.Rows[0]["oldOrderNo"].ToString() + "'";
list.Add(sql2);
list.Add(sql3);
Util.Debuglog("list=" + sql2 + sql3, "dhProduct.txt");
int a = DbHelperSQL.ExecuteSqlTran(list);
}
string trxdate = Request.Form["trxdate"];
string paytime = Request.Form["paytime"];
string acct = Request.Form["acct"];
string chnltrxid = Request.Form["chnltrxid"];
double trxamtY = double.Parse(Request.Form["trxamt"]) / 100;
//更新asm_pay_info asm_orderlist支付状态
string update1 = "update asm_pay_info set statu=1,paytime='" + paytime + "',productID='" + dtInfo.Rows[0]["productID"].ToString() + "',mechineID='" + dtInfo.Rows[0]["mechineID"].ToString() + "' where trxid='" + jo["trxid"].ToString() + "'";
DbHelperSQL.ExecuteSql(update1);
string update2 = "update asm_orderlist set fkzt=1 where trxid='" + jo["trxid"].ToString() + "'";
DbHelperSQL.ExecuteSql(update2);
//需要更新会员的消费信息
string update = "update asm_member set sumConsume=sumConsume+" + trxamtY + ",LastTime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',mechineID='" + dtInfo.Rows[0]["mechineID"].ToString() + "' where minOpenID='" + acct + "'";
DbHelperSQL.ExecuteSql(update);
string sqlActivity = "select * from asm_activity where status=1 and id=" + dtInfo.Rows[0]["activityID"].ToString();
//DataTable dactivity = DbHelperSQL.Query(sqlActivity).Tables[0];
string[] selDate = OperUtil.getSelDate(dtInfo.Rows[0]["totalNum"].ToString(), dtInfo.Rows[0]["psMode"].ToString(), dtInfo.Rows[0]["startTime"].ToString()).Split(',');
if (selDate.Length > 0)
{
DataTable dtNew;
for (int j = 0; j < dtInfo.Rows.Count; j++)
{
string sql14 = "select * from asm_orderlistDetail where id=0";
dtNew = DbHelperSQL.Query(sql14).Tables[0];
for (int i = 0; i < selDate.Length; i++)
{
int code = new Random(Guid.NewGuid().GetHashCode()).Next(100000, 999999);
//zt 1-已完成；2-已失效；3-已转售；4-待取货；5-待配送
DataRow dr = dtNew.NewRow();
dr["mechineID"] = dtInfo.Rows[j]["mechineID"].ToString(); //通过索引赋值
dr["productID"] = dtInfo.Rows[j]["productID"].ToString();
dr["createTime"] = delTime(selDate[i]); //
//dr["code"] = code;//
dr["memberID"] = dtInfo.Rows[j]["memberID"].ToString(); //通过索引赋值
if (delTime(selDate[i]) == DateTime.Now.ToString("yyyy-MM-dd"))
{
dr["zt"] = "4";
dr["code"] = code;//
}
else
{
dr["zt"] = "5";
}
dr["ldNO"] = ""; //
dr["orderNO"] = dtInfo.Rows[j]["orderNO"].ToString(); //
dr["statu"] = "0"; //通过索引赋值
dr["sellPrice"] = 0.0;
dr["sellTime"] = "";
dr["bz"] = "";
dr["companyID"] = dtInfo.Rows[j]["companyID"].ToString();
dtNew.Rows.Add(dr);
}
DbHelperSQL.BatchInsertBySqlBulkCopy(dtNew, "[dbo].[asm_orderlistDetail]");
string sql1 = "select * from asm_orderlistDetail where orderNO in ('" + dtInfo.Rows[j]["orderNO"].ToString() + "') ORDER BY createTime DESC ";
DataTable d1 = DbHelperSQL.Query(sql1).Tables[0];
if (d1.Rows.Count > 0)
{
string update12 = "UPDATE asm_orderlist set endTime='" + d1.Rows[0]["createTime"].ToString() + "' WHERE orderNO in ('" + dtInfo.Rows[j]["orderNO"].ToString() + "')";
DbHelperSQL.ExecuteSql(update12);
}
if (dtInfo.Rows[j]["startTime"].ToString() == DateTime.Now.ToString("yyyy-MM-dd"))
{
string updagte = "UPDATE asm_orderlist set orderzt=1 where orderno='" + dtInfo.Rows[j]["orderNO"].ToString() + "'";
DbHelperSQL.ExecuteSql(updagte);
}
}
}
if (dtInfo.Rows[0]["source"].ToString() != "1")
{
Util.growUpMemberBYDG(acct, int.Parse(dtInfo.Rows[0]["totalNum"].ToString()) * dtInfo.Rows.Count, dtInfo.Rows[0]["companyID"].ToString());
}
//发送模板消息
string sqlM = "select * from asm_member where minOpenID='" + acct + "'";
DataTable dM = DbHelperSQL.Query(sqlM).Tables[0];
//插入参加的活动记录
string activityID = dtInfo.Rows[0]["activityID"].ToString();
//兑换的产品不在继续参加活动source!=1
if (!string.IsNullOrEmpty(activityID) && dtInfo.Rows[0]["source"].ToString() != "1")
{
string sqlAc = "select * from asm_activity where statu=1 and id='" + activityID + "'";
DataTable dac = DbHelperSQL.Query(sqlAc).Tables[0];
if (dac.Rows.Count > 0)
{
string status = "1";
if (dac.Rows[0]["type"].ToString() == "3")
{
status = "0";
}
else
{
try
{
//发通知
if (!string.IsNullOrEmpty(dM.Rows[0]["openID"].ToString()))
{
string companyID = dM.Rows[0]["companyID"].ToString();
string openID = dM.Rows[0]["openID"].ToString();
wxHelper wx = new wxHelper(companyID);
string data = TemplateMessage.getPrize(openID, "hPFDCcfuANnDAGaIaAjsAnDKfgFXK-Y0SYGK12iIsAM", "活动奖励通知", dac.Rows[0]["payName"].ToString(), dac.Rows[0]["tag"].ToString(), "请尽快到小程序查看奖励");
TemplateMessage.SendTemplateMsg(wx.IsExistAccess_Token(dM.Rows[0]["companyID"].ToString()), data);
}
}
catch { }
}
string zsType = dac.Rows[0]["type"].ToString();
string sqlActivityIn = "insert into asm_partActivity(memberID,partTime,type,activityContent,companyID,zsType,status,activityName,totalMoney) values('" + dtInfo.Rows[0]["memberID"].ToString() + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',1,'" + dac.Rows[0]["activitytag"].ToString() + "','" + dac.Rows[0]["companyID"].ToString() + "'," + zsType + "," + status + ",'" + dac.Rows[0]["activityname"].ToString() + "'," + trxamtY + ")";
DbHelperSQL.ExecuteSql(sqlActivityIn);
}
}
if (dM.Rows.Count > 0)
{
if (!string.IsNullOrEmpty(dM.Rows[0]["openID"].ToString()))
{
string openID = dM.Rows[0]["openID"].ToString();
string companyID = dM.Rows[0]["companyID"].ToString();
string sqlp = "select o.*,p.proName from asm_orderlist o left join asm_product p on o.productID=p.productID where trxid='" + jo["trxid"].ToString() + "'";
DataTable dp = DbHelperSQL.Query(sqlp).Tables[0];
wxHelper wx = new wxHelper(companyID);
string data = TemplateMessage.comsume(openID, OperUtil.getMessageID(companyID, "OPENTM401313503"), "亲，你的购买的商品信息如下",
"" + dp.Rows[0]["proName"].ToString() + "", dp.Rows[0]["totalMoney"].ToString(), dp.Rows[0]["orderNO"].ToString(), dp.Rows[0]["mechineName"].ToString(), "“生鲜时逐”订奶订单已生成，鲜活即将配送到家");
TemplateMessage.SendTemplateMsg(wx.IsExistAccess_Token(OperUtil.getCooki("companyID")), data);
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
openID = Request.QueryString["openID"].ToString();
companyID = Request.QueryString["companyID"].ToString();
money = Request.QueryString["money"].ToString();
dzMoney = Request.QueryString["dzMoney"].ToString();
this._money.Value = money;
this._dzMOney.Value = dzMoney;
JsApiPay jsApiPayGet = new JsApiPay(this);
try
{
if (OperUtil.getCooki("vshop_openID") != "0")
{
this._companyID.Value = Request.QueryString["companyID"].ToString();
this._openID.Value = OperUtil.getCooki("vshop_openID");
openID = OperUtil.getCooki("vshop_openID");
}
else
{
string userAgent = Request.UserAgent;
if (userAgent.ToLower().Contains("micromessenger"))
{
Response.Redirect("WXCallback.aspx?companyID=" + OperUtil.getCooki("companyID"));
return;
}
}
int fen = 0;
try
{
fen = int.Parse(money) * 100;
//获取收货地址js函数入口参数
this._openID.Value = openID;
string url = "https://wx.bingoseller.com/pay/Notify.aspx";
SybWxPayService sybService = new SybWxPayService(companyID);
Dictionary <String, String> rsp = sybService.pay(fen, DateTime.Now.ToFileTime().ToString(), "W02", "会员充值", "备注", openID, "", url, "");
string json = (new JavaScriptSerializer()).Serialize(rsp);
Util.Debuglog("json=" + json, "_充值日志.txt");
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();
//插入预订单信息 为了避免插入失败循环插入5次
for (int i = 0; i < 10; i++)
{
string sql = "select * from asm_pay_info where trxid='" + trxid + "'";
DataTable ds = DbHelperSQL.Query(sql).Tables[0];
if (ds.Rows.Count <= 0)
{
string insertSQL = @"insert into asm_pay_info(appid,cusid,trxid,acct,statu,reqsn,[type],payType,trxamt,dzMoney)
values('" + appid + "','" + cusid + "','" + trxid + "','" + openID + "','0','" + reqsn + "',1,3," + fen + "," + dzMoney + ")";
Util.Debuglog("insertSQL=" + insertSQL, "_充值日志.txt");
DbHelperSQL.ExecuteSql(insertSQL);
}
else
{
break;
}
Thread.Sleep(300);
}
}
foreach (var item in rsp)
{
if (item.Key == "payinfo")
{
wxJsApiParam = item.Value;
}
}
}
catch {
Response.Write("<span style='color:#FF0000;font-size:20px'>" + "金额有误，请重试" + "</span>");
}
}
catch (Exception ex)
{
Response.Write("<span style='color:#FF0000;font-size:20px'>" + "页面加载出错，请重试" + "</span>");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (OperUtil.getCooki("vshop_openID") != "0")
{
memberID = Util.getMemberID();
}
else
{
string userAgent = Request.UserAgent;
if (userAgent.ToLower().Contains("micromessenger"))
{
Response.Redirect("WXCallback.aspx?companyID=" + OperUtil.getCooki("companyID"));
return;
}
}
pszq = Request.QueryString["pszq"].ToString();
qsDate = Request.QueryString["qsDate"].ToString().Replace("/", "-");
zdDate = Request.QueryString["zdDate"].ToString();
psStr = Request.QueryString["psStr"].ToString();
psfs = Request.QueryString["psfs"].ToString();
selDate = Request.QueryString["selDate"].ToString();
orderNO = Request.QueryString["orderNO"].ToString();;
productID = Request.QueryString["productID"].ToString();
mechineID = Request.QueryString["mechineID"].ToString();
createTime = Request.QueryString["createTime"].ToString();
yhfs = Request.QueryString["yhfs"].ToString();
//验证单号是否存在没有添加
if (!IsPostBack)
{
string sql = "select * from asm_order where orderNO='" + orderNO + "'";
DataTable dt = DbHelperSQL.Query(sql).Tables[0];
if (dt.Rows.Count <= 0)
{
string sqlMechine = "select * from asm_mechine where id='" + mechineID + "'";
DataTable dm = DbHelperSQL.Query(sqlMechine).Tables[0];
if (dm.Rows.Count > 0)
{
//计算总金额
string sql11 = "select * from asm_product where productID=" + productID;
DataTable dd = DbHelperSQL.Query(sql11).Tables[0];
if (dd.Rows.Count > 0)
{
totalMoney = (double.Parse(dd.Rows[0]["price2"].ToString()) * double.Parse(pszq)).ToString("f2");
if (yhfs.IndexOf('折') > -1)
{
string zk = yhfs.Replace("打", "").Replace("折", "");
totalMoney = (double.Parse(totalMoney) * double.Parse(zk) / 10).ToString("f2");
}
}
//添加订单
string sql1 = "insert into asm_order(mechineID,productID,memberID,totalNum,consumeNum,syNum,createTime,zq,qsDate,zdDate,psStr,psfs,orderNO,fkzt,zt,qhAddress,totalMoney,yhfs)"
+ "values('" + mechineID + "','" + productID + "','" + memberID + "'," + pszq + ",0," + pszq + ",'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "'," + pszq + ",'" + qsDate + "','" + zdDate + "','" + psStr + "','" + psfs + "','" + orderNO + "',0,0,'" + dm.Rows[0]["addres"].ToString() + "'," + totalMoney + ",'" + yhfs + "')";
int a = DbHelperSQL.ExecuteSql(sql1);
if (a > 0)
{
//订单添加成功 此处没有往订单明细表生成记录
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//支付信息
this._orderNO.Value = Request.QueryString["orderNO"].ToString();
this._syMoney.Value = Request.QueryString["syMoney"].ToString();
this._need_money.Value = Request.QueryString["need_money"].ToString();//实际花费
this._zq.Value = Request.QueryString["zq"].ToString();
this._productID.Value = Request.QueryString["productID"].ToString();
this._yhfs.Value = Request.QueryString["yhfs"].ToString();
this._mechineID.Value = Request.QueryString["mechineID"].ToString();
string sql = "select * from asm_mechine where id=" + this._mechineID.Value;
DataTable dt = DbHelperSQL.Query(sql).Tables[0];
companyID = dt.Rows[0]["companyID"].ToString();
money = this._need_money.Value;
string sqlpro = "select * from asm_product where productID=" + this._productID.Value;
proname = DbHelperSQL.Query(sqlpro).Tables[0].Rows[0]["proName"].ToString();
JsApiPay jsApiPayGet = new JsApiPay(this);
try
{
if (OperUtil.getCooki("vshop_openID") != "0")
{
this._companyID.Value = OperUtil.getCooki("companyID");
this._openID.Value = OperUtil.getCooki("vshop_openID");
openID = OperUtil.getCooki("vshop_openID");
}
else
{
string userAgent = Request.UserAgent;
if (userAgent.ToLower().Contains("micromessenger"))
{
Response.Redirect("WXCallback.aspx?companyID=" + OperUtil.getCooki("companyID"));
return;
}
}
double fen = 0;
try
{
fen = (double.Parse(money) - double.Parse(this._syMoney.Value)) * 100;
//获取收货地址js函数入口参数
this._openID.Value = openID;
string url = "https://wx.bingoseller.com/pay/dhpayNotify.aspx";
SybWxPayService sybService = new SybWxPayService(companyID);
Dictionary <String, String> rsp = sybService.pay((int)fen, DateTime.Now.ToFileTime().ToString(), "W02", "会员商品兑换", proname, openID, "", url, "");
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();
this._trxid.Value = trxid;
// //插入预订单信息
string insertSQL = @"insert into asm_pay_info(appid,cusid,trxid,acct,statu,reqsn,[type],payType,trxamt)
values('" + appid + "','" + cusid + "','" + trxid + "','" + openID + "','0','" + reqsn + "',2,3," + fen + ")";
DbHelperSQL.ExecuteSql(insertSQL);
}
foreach (var item in rsp)
{
if (item.Key == "payinfo")
{
wxJsApiParam = item.Value;
}
}
}
catch
{
Response.Write("<span style='color:#FF0000;font-size:20px'>" + "金额有误，请重试" + "</span>");
}
}
catch (Exception ex)
{
Response.Write("<span style='color:#FF0000;font-size:20px'>" + "页面加载出错，请重试" + "</span>");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//支付信息
this.mechine_id.Value = Request.QueryString["mechine_id"].ToString();
this.product_id.Value = Request.QueryString["product_id"].ToString();
Util.Debuglog("机器id=" + this.mechine_id.Value + ";产品id=" + this.product_id.Value + ";", "会员下订单.txt");
this._pszq.Value = Request.QueryString["_pszq"].ToString();
Util.Debuglog("配送周期=" + this._pszq.Value, "会员下订单.txt");
this._qsDate.Value = Request.QueryString["_qsDate"].ToString();
Util.Debuglog("起送周期=" + this._qsDate.Value, "会员下订单.txt");
this._zdDate.Value = Request.QueryString["_zdDate"].ToString();
Util.Debuglog("止订周期=" + this._zdDate.Value, "会员下订单.txt");
this._psStr.Value = Request.QueryString["_psStr"].ToString();
Util.Debuglog("配送方式_psStr=" + this._psStr.Value, "会员下订单.txt");
this._psfs.Value = Request.QueryString["_psfs"].ToString();
Util.Debuglog("_psfs=" + this._psfs.Value, "会员下订单.txt");
//this._selDate.Value = Request.QueryString["_selDate"].ToString();
//Util.Debuglog("_selDate=" + this._selDate.Value, "会员下订单.txt");
this._orderNO.Value = Request.QueryString["_orderNO"].ToString();
Util.Debuglog("_orderNO=" + this._orderNO.Value, "会员下订单.txt");
this._createTime.Value = Request.QueryString["_createTime"].ToString();
Util.Debuglog("_createTime=" + this._createTime.Value, "会员下订单.txt");
this._fkzt.Value = Request.QueryString["_fkzt"].ToString();
Util.Debuglog("_fkzt=" + this._fkzt.Value, "会员下订单.txt");
this._totalMoney.Value = Request.QueryString["_totalMoney"].ToString();
Util.Debuglog("_totalMoney=" + this._totalMoney.Value, "会员下订单.txt");
this._yhfs.Value = Request.QueryString["_yhfs"].ToString();
Util.Debuglog("_yhfs=" + this._yhfs.Value, "会员下订单.txt");
string sql = "select * from asm_mechine where id=" + this.mechine_id.Value;
DataTable dt = DbHelperSQL.Query(sql).Tables[0];
companyID = dt.Rows[0]["companyID"].ToString();
money = Request.QueryString["money"].ToString();
proname = Request.QueryString["proname"].ToString();
JsApiPay jsApiPayGet = new JsApiPay(this);
try
{
if (OperUtil.getCooki("vshop_openID") != "0")
{
this._companyID.Value = Request.QueryString["companyID"].ToString();
this._openID.Value = OperUtil.getCooki("vshop_openID");
openID = OperUtil.getCooki("vshop_openID");
}
else
{
string userAgent = Request.UserAgent;
if (userAgent.ToLower().Contains("micromessenger"))
{
Response.Redirect("WXCallback.aspx?companyID=" + OperUtil.getCooki("companyID"));
return;
}
}
double fen = 0;
try
{
fen = double.Parse(money) * 100;
//获取收货地址js函数入口参数
this._openID.Value = openID;
Util.Debuglog("openID=" + openID + ":companyID=" + companyID + "fen=" + fen, "微信支付.txt");
string url = "https://wx.bingoseller.com/pay/OrderNotify.aspx";
SybWxPayService sybService = new SybWxPayService(companyID);
Util.Debuglog("111=", "微信支付.txt");
Dictionary <String, String> rsp = sybService.pay((int)fen, DateTime.Now.ToFileTime().ToString(), "W02", "会员购物", proname, openID, "", url, "");
Util.Debuglog("rsp=" + rsp, "微信支付.txt");
string json = (new JavaScriptSerializer()).Serialize(rsp);
Util.Debuglog("json=" + json, "微信支付.txt");
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();
this._trxid.Value = trxid;
//插入预订单信息
string insertSQL = @"insert into asm_pay_info(appid,cusid,trxid,acct,statu,reqsn,type,payType,trxamt)
values('" + appid + "','" + cusid + "','" + trxid + "','" + openID + "','0','" + reqsn + "',2,3," + fen + ")";
Util.Debuglog("insertSQL=" + insertSQL, "微信支付.txt");
//根据订单编号更新 订单表 在回调方法里添加订单明细记录
string update = "update asm_order set trxID='" + trxid + "' where orderNO='" + this._orderNO.Value + "'";
Util.Debuglog("update11111=" + update, "_11.txt");
DbHelperSQL.ExecuteSql(insertSQL);
DbHelperSQL.ExecuteSql(update);
}
foreach (var item in rsp)
{
if (item.Key == "payinfo")
{
wxJsApiParam = item.Value;
Util.Debuglog("wxJsApiParam=" + wxJsApiParam, "微信下单支付_.txt");
}
}
}
catch (Exception ex)
{
Util.Debuglog("ex错误=" + ex.Message, "微信支付.txt");
Response.Write("<span style='color:#FF0000;font-size:20px'>" + "金额有误，请重试" + "</span>");
}
}
catch (Exception ex)
{
Response.Write("<span style='color:#FF0000;font-size:20px'>" + "页面加载出错，请重试" + "</span>");
}
}
}
public void createOrder(HttpContext context)
{
string mechine_id = context.Request["mechine_id"].ToString();
Util.Debuglog("mechine_id=" + mechine_id, "_.参数.txt");
string product_id = context.Request["product_id"].ToString();
Util.Debuglog("product_id=" + product_id, "_.参数.txt");
string _orderNO = context.Request["_orderNO"].ToString();
Util.Debuglog("_orderNO=" + _orderNO, "_.参数.txt");
string _totalMoney = context.Request["_totalMoney"].ToString();
Util.Debuglog("_totalMoney=" + _totalMoney, "_.参数.txt");
string _trxID = context.Request["_trxID"].ToString();
Util.Debuglog("_trxID=" + _trxID, "_.参数.txt");
string memberID = Util.getMemberID();
if (memberID == "0")
{
System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder();
stringBuilder.Append("{");
stringBuilder.Append("\"result\":\"3\""); //当前没有登录
stringBuilder.Append("}");
context.Response.Write(stringBuilder.ToString());
return;
}
//根据机器id获取机器地址
string sql1 = "select * from asm_mechine where id=" + mechine_id;
DataTable dt = DbHelperSQL.Query(sql1).Tables[0];
string sql12 = "select * from asm_order where orderNO='" + _orderNO + "'";
DataTable d12 = DbHelperSQL.Query(sql12).Tables[0];
if (d12.Rows.Count <= 0)
{
}
else
{
//判断当前的优惠方式如果是赠送天数的话需要更新totalNum
if (d12.Rows[0]["yhfs"].ToString().Contains("赠送"))
{
string num = d12.Rows[0]["yhfs"].ToString();
num = num.Replace("赠送", "").Replace("天", "");
string update = "update asm_order set fkzt=1,trxID='" + _trxID + "',totalNum=totalNum+" + num + ",syNum=syNum+" + num + " where id=" + d12.Rows[0]["id"].ToString();
DbHelperSQL.ExecuteSql(update);
}
else
{
string update = "update asm_order set fkzt=1,trxID='" + _trxID + "' where id=" + d12.Rows[0]["id"].ToString();
DbHelperSQL.ExecuteSql(update);
}
//更新状态
}
if (1 == 1)
{
d12 = DbHelperSQL.Query(sql12).Tables[0];
//更新商品销售数量
string ss = "update asm_product set ljxs=CONVERT(float,ISNULL(ljxs,0))+1 where productID=" + product_id;
DbHelperSQL.ExecuteSql(ss);
//string[] selDate = _selDate.Split(',');
string[] selDate = insertIntoOrderDetail(d12.Rows[0]["psfs"].ToString(), d12.Rows[0]["psStr"].ToString(), d12.Rows[0]["totalNum"].ToString(), d12.Rows[0]["qsDate"].ToString()).Split(',');
Util.Debuglog(insertIntoOrderDetail(d12.Rows[0]["psfs"].ToString(), d12.Rows[0]["psStr"].ToString(), d12.Rows[0]["totalNum"].ToString(), d12.Rows[0]["qsDate"].ToString()), "时间格式.txt");
if (selDate.Length > 0)
{
string sql14 = "select * from asm_orderDetail where id=0";
DataTable dtNew = DbHelperSQL.Query(sql14).Tables[0];
for (int i = 0; i < selDate.Length; i++)
{
int code = new Random(Guid.NewGuid().GetHashCode()).Next(100000, 999999);
//zt 1-已完成；2-已失效；3-已转售；4-待取货；5-待配送
DataRow dr = dtNew.NewRow();
dr["mechineID"] = mechine_id; //通过索引赋值
dr["productID"] = product_id;
dr["createTime"] = delTime(selDate[i]); //
dr["code"] = code; //
dr["memberID"] = memberID; //通过索引赋值
dr["zt"] = "5";
dr["ldNO"] = ""; //
dr["orderNO"] = _orderNO; //
dr["statu"] = "0"; //通过索引赋值
dr["sellPrice"] = 0.0;
dr["sellTime"] = "";
dr["bz"] = "";
dtNew.Rows.Add(dr);
}
DbHelperSQL.BatchInsertBySqlBulkCopy(dtNew, "[dbo].[asm_orderDetail]");
}
//给会员绑定机器
string sql4 = "update asm_member set mechineID=" + mechine_id + ",LastTime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',consumeCount=consumeCount+1,sumConsume=sumConsume+" + _totalMoney + " where id=" + memberID;
Util.Debuglog("会员绑定机器=" + sql4, "_.插入订购订单.txt");
DbHelperSQL.ExecuteSql(sql4);
string sql5 = "select * from asm_product where productID=" + product_id;
DataTable dd5 = DbHelperSQL.Query(sql5).Tables[0];
Thread threadB = new Thread(
() =>
{
wxHelper wx = new wxHelper(OperUtil.getCooki("companyID"));
string data = TemplateMessage.comsume(OperUtil.getCooki("vshop_openID"), "ti4Dkcm1ELNqaskSYsCYMzqL87nPqapNeOgwhvSci_Q", "亲，你的购买的商品信息如下", "" + dd5.Rows[0]["proName"].ToString() + "", _totalMoney, _orderNO, dt.Rows[0]["bh"].ToString(), "欢迎惠顾");
TemplateMessage.SendTemplateMsg(wx.IsExistAccess_Token(OperUtil.getCooki("companyID")), data);
});
threadB.Start();
System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder();
stringBuilder.Append("{");
stringBuilder.Append("\"result\":\"4\""); //订单提交成功
stringBuilder.Append("}");
context.Response.Write(stringBuilder.ToString());
}
else
{
System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder();
stringBuilder.Append("{");
stringBuilder.Append("\"result\":\"2\""); //订单提交失败
stringBuilder.Append("}");
context.Response.Write(stringBuilder.ToString());
}
}
public static string dh(string orderNO, string syMoney, string need_money, string zq, string productID, string yhfs)
{
//1需要先把旧的的订单的状态更改为已兑换
//2按照旧的订单的配送方式重新生成新的订单 2 天之后配送
//3钱款多退少补
//先判断当前状态不是完成的才可以兑换
string sql1 = "select * from asm_order where orderNO='" + orderNO + "' and zt in (0,1)";
DataTable dt = DbHelperSQL.Query(sql1).Tables[0];
if (dt.Rows.Count <= 0)
{
return("2");
}
string sql22 = "update asm_order set zt=4 where orderNO='" + orderNO + "'";
DbHelperSQL.ExecuteSql(sql22);
string sql = "update asm_orderDetail set zt=7 where orderNO='" + orderNO + "' and zt=5";
DbHelperSQL.ExecuteSql(sql);
if (dt.Rows.Count > 0)
{
string sellDate = insertIntoOrderDetail(dt.Rows[0]["psfs"].ToString(), dt.Rows[0]["psStr"].ToString(), zq);
string[] sellArr = sellDate.Split(',');
string order_NO = ((DateTime.Now.ToUniversalTime().Ticks - 621355968000000000) / 10000).ToString();
string fkzt = "1";
//创建订单
string sqlInsert = @"INSERT INTO [dbo].[asm_order](
[mechineID],
[productID],
[memberID],
[totalNum],
[consumeNum],
[syNum],
[createTime],
[zq],
[qsDate],
[zdDate],
[psStr],
[psfs],
[orderNO],
[fkzt],
[zt],
[qhAddress],
[totalMoney],
[yhfs])
VALUES(" + dt.Rows[0]["mechineID"].ToString() + "," + productID + "," + dt.Rows[0]["memberID"].ToString() + "," + zq + ",0," + zq + ",'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "'," + zq + ",'" + DateTime.Now.ToString("yyyy-MM-dd") + "','" + sellArr[sellArr.Length - 1] + "','" + dt.Rows[0]["psStr"].ToString() + "'," + dt.Rows[0]["psfs"].ToString() + ",'" + order_NO + "'," + fkzt + ",0,'" + dt.Rows[0]["qhAddress"].ToString() + "'," + need_money + ",'" + yhfs + "')";
int a = DbHelperSQL.ExecuteSql(sqlInsert);
if (a > 0)
{
//更新商品销售数量
string ss = "update asm_product set ljxs=CONVERT(float,ISNULL(ljxs,0))+1 where productID=" + productID;
DbHelperSQL.ExecuteSql(ss);
string[] selDate = sellArr;
if (selDate.Length > 0)
{
for (int i = 0; i < selDate.Length; i++)
{
int code = new Random(Guid.NewGuid().GetHashCode()).Next(100000, 999999);
//zt 1-已完成；2-已失效；3-已转售；4-待取货；5-待配送
string sql2 = @"INSERT INTO [dbo].[asm_orderDetail](
[mechineID],
[productID],
[createTime],
[code],
[memberID],
[zt],
[ldNO],
[orderNO],
[statu],
[sellPrice])
VALUES('" + dt.Rows[0]["mechineID"].ToString() + "','" + productID + "','" + selDate[i] + "','" + code + "'," + dt.Rows[0]["memberID"].ToString() + ",5,'','" + order_NO + "',0,0)";
DbHelperSQL.ExecuteSql(sql2);
}
}
//给会员绑定机器
string sql4 = "update asm_member set mechineID=" + dt.Rows[0]["mechineID"].ToString() + ",LastTime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',consumeCount=consumeCount+1,sumConsume=sumConsume+" + need_money + " where id=" + dt.Rows[0]["memberID"].ToString();
DbHelperSQL.ExecuteSql(sql4);
string sql5 = "select * from asm_product where productID=" + productID;
DataTable dd5 = DbHelperSQL.Query(sql5).Tables[0];
string sql6 = "select * from asm_mechine where id=" + dt.Rows[0]["mechineID"].ToString();
DataTable dd6 = DbHelperSQL.Query(sql6).Tables[0];
wxHelper wx = new wxHelper(OperUtil.getCooki("companyID"));
string data = TemplateMessage.comsume(OperUtil.getCooki("vshop_openID"), "ti4Dkcm1ELNqaskSYsCYMzqL87nPqapNeOgwhvSci_Q", "亲，你的购买的商品信息如下", "" + dd5.Rows[0]["proName"].ToString() + "", need_money, order_NO, dd6.Rows[0]["bh"].ToString(), "欢迎惠顾");
TemplateMessage.SendTemplateMsg(wx.IsExistAccess_Token(OperUtil.getCooki("companyID")), data);
//多退少补
if (double.Parse(need_money) < double.Parse(syMoney))
{
//退给会员钱包
string sqlUpdate = "update asm_member set AvailableMoney=AvailableMoney+" + (double.Parse(need_money) - double.Parse(syMoney)) + " where id=" + dt.Rows[0]["memberID"].ToString();
DbHelperSQL.ExecuteSql(sqlUpdate);
}
}
}
return("1");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
idArr = Request.QueryString["idArr"].ToString();
if (string.IsNullOrEmpty(idArr))
{
Response.Write("<span style='color:#FF0000;font-size:20px'>" + "参数不全" + "</span>");
return;
}
this._id.Value = idArr;
Util.Debuglog("_id=" + idArr, "联合支付.txt");
//根据idArr循环订单列表
string sql = "select sum(totalMoney) totalMoney from asm_order where id in (" + idArr + ") and fkzt=0";
DataTable ds = DbHelperSQL.Query(sql).Tables[0];
if (ds.Rows.Count > 0)
{
money = ds.Rows[0]["totalMoney"].ToString();
}
JsApiPay jsApiPayGet = new JsApiPay(this);
try
{
if (OperUtil.getCooki("vshop_openID") != "0")
{
this._companyID.Value = Request.QueryString["companyID"].ToString();
companyID = this._companyID.Value;
this._openID.Value = OperUtil.getCooki("vshop_openID");
openID = OperUtil.getCooki("vshop_openID");
}
else
{
string userAgent = Request.UserAgent;
if (userAgent.ToLower().Contains("micromessenger"))
{
Response.Redirect("WXCallback.aspx?companyID=" + OperUtil.getCooki("companyID"));
return;
}
}
double fen = 0;
try
{
fen = double.Parse(money) * 100;
//获取收货地址js函数入口参数
this._openID.Value = openID;
Util.Debuglog("openID=" + openID + ":companyID=" + companyID + "fen=" + fen, "联合支付.txt");
string url = "https://wx.bingoseller.com/pay/OrderNotify.aspx";
SybWxPayService sybService = new SybWxPayService(companyID);
Dictionary <String, String> rsp = sybService.pay((int)fen, DateTime.Now.ToFileTime().ToString(), "W02", "会员购物", "订单合并付款", openID, "", url, "");
Util.Debuglog("rsp=" + rsp, "联合支付.txt");
string json = (new JavaScriptSerializer()).Serialize(rsp);
Util.Debuglog("json=" + json, "联合支付.txt");
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();
this._trxid.Value = trxid;
// //插入预订单信息
string insertSQL = @"insert into asm_pay_info(appid,cusid,trxid,acct,statu,reqsn,[type],payType,trxamt)
values('" + appid + "','" + cusid + "','" + trxid + "','" + openID + "','0','" + reqsn + "',2,3," + fen + ")";
Util.Debuglog("insertSQL=" + insertSQL, "联合支付.txt");
DbHelperSQL.ExecuteSql(insertSQL);
}
foreach (var item in rsp)
{
if (item.Key == "payinfo")
{
wxJsApiParam = item.Value;
Util.Debuglog("wxJsApiParam=" + wxJsApiParam, "联合支付.txt");
}
}
}
catch (Exception ex)
{
Util.Debuglog("ex错误=" + ex.Message, "微信支付.txt");
Response.Write("<span style='color:#FF0000;font-size:20px'>" + "金额有误，请重试" + "</span>");
}
}
catch (Exception ex)
{
Response.Write("<span style='color:#FF0000;font-size:20px'>" + "页面加载出错，请重试" + "</span>");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
comid = Request.QueryString["companyID"].ToString();
//comid = "13";
OperUtil.setCooki("companyID", comid);
this.companyID.Value = comid;
Response.Cache.SetNoStore();
if (OperUtil.getCooki("vshop_openID") != "0")
{
string sql3 = "select * from asm_member where openID='" + OperUtil.getCooki("vshop_openID") + "' and companyID=" + companyID.Value;
DataTable dd = DbHelperSQL.Query(sql3).Tables[0];
if (dd.Rows.Count <= 0)
{
Response.Redirect("WXCallback.aspx?companyID=" + this.companyID.Value);
return;
}
else
{
string sql4 = "update asm_member set LastTime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' where id=" + dd.Rows[0]["id"].ToString();
DbHelperSQL.ExecuteSql(sql4);
}
//获取公众号的appid
string sql = "select * from asm_company where id=" + comid;
DataTable dt = DbHelperSQL.Query(sql).Tables[0];
if (dt.Rows.Count > 0 && !string.IsNullOrEmpty(dt.Rows[0]["appId"].ToString()))
{
this._jlc.Value = dt.Rows[0]["jlc"].ToString();
this.appID.Value = dt.Rows[0]["appId"].ToString();
app_id = dt.Rows[0]["appId"].ToString();
//app_id = OpenPFConfig.Appid;
if (dt.Rows[0]["p8"].ToString() != "")
{
this._url1.Value = "1";
this.url1.Src = dt.Rows[0]["p8"].ToString();
}
if (dt.Rows[0]["p9"].ToString() != "")
{
this._url2.Value = "1";
this.url2.Src = dt.Rows[0]["p9"].ToString();
}
if (dt.Rows[0]["p10"].ToString() != "")
{
this._url3.Value = "1";
this.url3.Src = dt.Rows[0]["p10"].ToString();
}
}
this.memberID.Value = Util.getMemberID();
this._openID.Value = OperUtil.getCooki("vshop_openID");
}
else
{
Response.Redirect("WXCallback.aspx?companyID=" + this.companyID.Value);
}
wxHelper wx = new wxHelper(comid);
string[] str = wx.GetWXInfo(this.Request.Url.ToString(), comid).Split(',');
//this.ur.Value = this.Request.Url.ToString();
//this.ticket.Value = wx.GetTicketPlat(comid);
//this.te.Value = wx.IsExistAccess_Token(comid);
time = str[0];
randstr = str[1];
signstr = str[2];
Util.Debuglog("time=" + time + ";randstr=" + randstr + ";signstr=" + signstr + ";url=" + this.Request.Url.ToString(), "微信参数.txt");
}
catch
{
comid = OperUtil.getCooki("companyID");
this.companyID.Value = comid;
Response.Cache.SetNoStore();
if (OperUtil.getCooki("vshop_openID") != "0")
{
string sql3 = "select * from asm_member where openID='" + OperUtil.getCooki("vshop_openID") + "' and companyID=" + companyID.Value;
DataTable dd = DbHelperSQL.Query(sql3).Tables[0];
if (dd.Rows.Count <= 0)
{
Response.Redirect("WXCallback.aspx?companyID=" + this.companyID.Value);
return;
}
//获取公众号的appid
string sql = "select * from asm_company where id=" + OperUtil.getCooki("companyID");
DataTable dt = DbHelperSQL.Query(sql).Tables[0];
if (dt.Rows.Count > 0 && !string.IsNullOrEmpty(dt.Rows[0]["appId"].ToString()))
{
this.appID.Value = dt.Rows[0]["appId"].ToString();
app_id = dt.Rows[0]["appId"].ToString();
//p_id = OpenPFConfig.Appid;
if (dt.Rows[0]["p8"].ToString() != "")
{
this._url1.Value = "1";
this.url1.Src = dt.Rows[0]["p8"].ToString();
}
if (dt.Rows[0]["p9"].ToString() != "")
{
this._url2.Value = "1";
this.url2.Src = dt.Rows[0]["p9"].ToString();
}
if (dt.Rows[0]["p10"].ToString() != "")
{
this._url3.Value = "1";
this.url3.Src = dt.Rows[0]["p10"].ToString();
}
}
this.memberID.Value = Util.getMemberID();
this._openID.Value = OperUtil.getCooki("vshop_openID");
}
else
{
Response.Redirect("WXCallback.aspx?companyID=" + this.companyID.Value);
}
Response.Cache.SetNoStore();
wxHelper wx = new wxHelper(OperUtil.getCooki("companyID"));
this.companyID.Value = OperUtil.getCooki("companyID");;
string[] str = wx.GetWXInfo(this.Request.Url.ToString(), OperUtil.getCooki("companyID")).Split(',');
//this.ur.Value = this.Request.Url.ToString();
//this.ticket.Value = wx.GetTicketPlat(OperUtil.getCooki("companyID"));
//this.te.Value = wx.IsExistAccess_Token(OperUtil.getCooki("companyID"));
time = str[0];
randstr = str[1];
signstr = str[2];
Util.Debuglog("2time=" + time + ";randstr=" + randstr + ";signstr=" + signstr + ";url=" + this.Request.Url.ToString(), "微信参数.txt");
}
}