protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string code = "";
string companyID = "";
if (Request.QueryString["code"] != null && Request.QueryString["code"] != "")
{
code = Request.QueryString["code"].ToString();
string str = Request.QueryString["req"].ToString();
string req = PwdHelper.DecodeDES(str, "bingoseller");
companyID = req.Split('&')[2].Split('=')[1];
string sql2 = "select * from asm_company where id=" + companyID;
DataTable d1 = DbHelperSQL.Query(sql2).Tables[0];
if (d1.Rows.Count > 0)
{
appid = d1.Rows[0]["appId"].ToString();
appsecret = d1.Rows[0]["wx_appsecret"].ToString();
}
OAuth_Token Model = Get_token(code, companyID);
OAuthUser OAuthUser_Model = Get_UserInfo(Model.access_token, Model.openid);
if (OAuthUser_Model.openid != null && OAuthUser_Model.openid != "") //已获取得openid及其他信息
{
tupian = OAuthUser_Model.headimgurl.ToString(); //头像图片
name = OAuthUser_Model.nickname; //昵称
id = OAuthUser_Model.openid; //opendid
string unionID = OAuthUser_Model.unionid;
string country = OAuthUser_Model.country;
string province = OAuthUser_Model.province;
string city = OAuthUser_Model.city;
OperUtil.setCooki("vshop_openID", id);
string sql = "select * from asm_member where openID='" + id + "' and companyID=" + companyID;
DataTable dt = DbHelperSQL.Query(sql).Tables[0];
if (dt.Rows.Count <= 0)
{
//添加会员 会员不一定必须绑定机器 只有会员有订购产品的时候才必须绑定机器
string sql1 = "INSERT INTO [dbo].[asm_member]"
+ " ([name],[phone],[QQ],[province],[city],[country],[addres],[AvailableMoney],[sumConsume],[sumRecharge],[createDate],[mechineID],[companyID],[age],[LastTime],[memberBH],[consumeCount],[openID],[brithday],[headurl],[nickname],unionID)"
+ " VALUES('" + name + "','','','" + province + "','" + city + "','','',0,0,0,'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','','" + companyID + "','0','','',0,'" + id + "','','" + tupian + "','" + name + "','" + unionID + "')";
DbHelperSQL.ExecuteSql(sql1);
wxHelper wx = new wxHelper(companyID);
string data = TemplateMessage.Member_ZC(id, OperUtil.getMessageID(companyID, "OPENTM203347141"), "恭喜您注册成为会员！", name, "恭喜您注册成为会员，您将享受到会员所有权利！");
TemplateMessage.SendTemplateMsg(wx.IsExistAccess_Token(companyID), data);
}
else
{
string update = "update asm_member set unionID='" + unionID + "',name='" + name + "',nickname='" + name + "',headurl='" + tupian + "' where openID='" + id + "'";
Util.Debuglog("Update=" + update, "更新会员信息.txt");
}
Response.Redirect("paypage.aspx?req=" + str);
}
}
}
}
public static string yzPwd(string openID, string pwd, string money, string trxid, string companyID)
{
Util.Debuglog("openID=" + openID + ";pwd=" + pwd + ";money=" + money + ";trxid=" + trxid + ";companyID=" + companyID, "_余额支付.txt");
//验证密码是否正确
string sql = "select * from asm_member where openID='" + openID + "' and pwd='" + pwd + "'";
DataTable dd = DbHelperSQL.Query(sql).Tables[0];
if (dd.Rows.Count <= 0)
{
return("1");//支付密码不正确
}
//判断该订单支付状态
string sql1 = "select * from asm_pay_info where trxid='" + trxid + "'";
DataTable d1 = DbHelperSQL.Query(sql1).Tables[0];
if (d1.Rows.Count > 0 && d1.Rows[0]["statu"].ToString() == "1")
{
return("4");//已经支付完成无需重复支付
}
//判断余额
if (double.Parse(dd.Rows[0]["AvailableMoney"].ToString()) < double.Parse(money))
{
return("2");//余额不足
}
//更新余额
string update = "update asm_member set AvailableMoney=AvailableMoney-" + money + ",sumConsume=sumConsume+" + money + ",LastTime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' where openID='" + openID + "'";
DbHelperSQL.ExecuteSql(update);
string sqlM = "select addres from asm_mechine where id in(select mechineID from asm_member where openID='" + openID + "')";
DataTable dM = DbHelperSQL.Query(sqlM).Tables[0];
string address = "";
if (dM.Rows.Count > 0)
{
address = dM.Rows[0]["addres"].ToString();
}
//发送消息模板
wxHelper wx = new wxHelper(companyID);
string data = TemplateMessage.money_bd(openID, OperUtil.getMessageID(companyID, "OPENTM403148135"), "余额变动提醒", "购买产品", money, (double.Parse(dd.Rows[0]["AvailableMoney"].ToString()) - double.Parse(money)).ToString(), address, "支付时间:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
TemplateMessage.SendTemplateMsg(wx.IsExistAccess_Token(companyID), data);
//插入记录
Util.insertNotice(dd.Rows[0]["id"].ToString(), "余额变动提醒", "您于" + DateTime.Now.ToString("yyyy/MM/dd HH:mm") + "购物消费：" + money + "元；余额：" + (double.Parse(dd.Rows[0]["AvailableMoney"].ToString()) - double.Parse(money)), "");
Util.moneyChange(dd.Rows[0]["id"].ToString(), money, (double.Parse(dd.Rows[0]["AvailableMoney"].ToString()) - double.Parse(money)).ToString(), "会员消费", "2", "");
//接着更新订单的状态
string update1 = "update asm_pay_info set statu=1,paytime='" + DateTime.Now.ToString("yyyyMMddHHmmss") + "',acct='" + openID + "' where trxid='" + trxid + "'";
DbHelperSQL.ExecuteSql(update1);
return("3");
}
public static string yzPwd(string memberID, string money, string pwd, string companyID, string trxid)
{
//验证密码是否正确
string sql = "select * from asm_member where id='" + memberID + "' and pwd='" + pwd + "'";
DataTable dd = DbHelperSQL.Query(sql).Tables[0];
if (dd.Rows.Count <= 0)
{
return("1");//支付密码不正确
}
//判断余额
if (double.Parse(dd.Rows[0]["AvailableMoney"].ToString()) < double.Parse(money))
{
return("2");//余额不足
}
//更新余额
string update = "update asm_member set AvailableMoney=AvailableMoney-" + money + " where id='" + memberID + "'";
DbHelperSQL.ExecuteSql(update);
string sqlM = "select addres from asm_mechine where id in(select mechineID from asm_member where id=" + memberID + ")";
DataTable dM = DbHelperSQL.Query(sqlM).Tables[0];
string address = "";
if (dM.Rows.Count > 0)
{
address = dM.Rows[0]["addres"].ToString();
}
//发送消息模板
wxHelper wx = new wxHelper(companyID);
string data = TemplateMessage.money_bd(dd.Rows[0]["openID"].ToString(), OperUtil.getMessageID(companyID, "OPENTM403148135"), "余额变动提醒", "购买产品", money, (double.Parse(dd.Rows[0]["AvailableMoney"].ToString()) - double.Parse(money)).ToString(), address, "支付时间:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
TemplateMessage.SendTemplateMsg(wx.IsExistAccess_Token(companyID), data);
//插入记录
Util.insertNotice(dd.Rows[0]["id"].ToString(), "余额变动提醒", "您于" + DateTime.Now.ToString("yyyy/MM/dd HH:mm") + "购物消费：" + money + "元；余额：" + (double.Parse(dd.Rows[0]["AvailableMoney"].ToString()) - double.Parse(money)), "");
Util.moneyChange(dd.Rows[0]["id"].ToString(), money, dd.Rows[0]["AvailableMoney"].ToString(), "会员消费", "2", "");
string insertSQL = @"insert into asm_pay_info(trxid,acct,statu,type,payType,trxamt,paytime)
values('" + trxid + "','" + memberID + "',1,2,4," + (double.Parse(money) * 100) + ",'" + DateTime.Now.ToString("yyyyMMddHHmmss") + "')";
DbHelperSQL.ExecuteSql(insertSQL);
return("3");
}
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);
}
}
}
}
}
public static string yzPwd(string unionID, string money, string companyID, string productID, string mechineID, string type, string dgOrderDetailID, string sftj, string reqsn)
{
string ldno = Util.getLDNO(mechineID, productID);
if (string.IsNullOrEmpty(ldno))
{
return("5");//当前机器库存不足，请等待配送员上货
}
Random rd = new Random();
int rand = rd.Next(10000, 99999);
string sql2 = "select * from asm_company where id='" + companyID + "'";
DataTable d2 = DbHelperSQL.Query(sql2).Tables[0];
string trxid = ConvertDateTimeToInt(DateTime.Now).ToString() + rand;
string insertSQL = "insert into asm_pay_info(reqsn,trxid,statu,type,payType,trxamt,createTime,appid,unionID,mechineID,productID,companyID,orderType,dgOrderDetailID,sftj) values('" + reqsn + ",'" + trxid + "',0,2,4," + double.Parse(money) * 100 + ",'" + DateTime.Now + "','" + d2.Rows[0]["tl_APPID"].ToString() + "','" + unionID + "','" + mechineID + "','" + productID + "','" + companyID + "','" + type + "','" + dgOrderDetailID + "','" + sftj + "')";
Util.Debuglog("insertSQL=" + insertSQL, "余额支付.txt");
int a = DbHelperSQL.ExecuteSql(insertSQL);
//验证密码是否正确
string sql = "select * from asm_member where unionID='" + unionID + "'";
Util.Debuglog("sql=" + sql, "余额支付.txt");
DataTable dd = DbHelperSQL.Query(sql).Tables[0];
string openID = dd.Rows[0]["openID"].ToString();
//判断该订单支付状态
string sql1 = "select * from asm_pay_info where trxid='" + trxid + "'";
Util.Debuglog("sql1=" + sql1, "余额支付.txt");
DataTable d1 = DbHelperSQL.Query(sql1).Tables[0];
if (d1.Rows.Count > 0 && d1.Rows[0]["statu"].ToString() == "1")
{
return("4");//已经支付完成无需重复支付
}
//判断余额
if (double.Parse(dd.Rows[0]["AvailableMoney"].ToString()) - double.Parse(money) < 0)
{
return("2");//余额不足
}
//更新余额
string update = "update asm_member set AvailableMoney=AvailableMoney-" + money + ",consumeCount=consumeCount+1,sumConsume=sumConsume+" + money + ",LastTime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' where openID='" + openID + "'";
Util.Debuglog("update=" + update, "余额支付.txt");
DbHelperSQL.ExecuteSql(update);
string sqlM = "select addres,id,mechineName from asm_mechine where id in(" + mechineID + ")";
Util.Debuglog("sqlM=" + sqlM, "余额支付.txt");
DataTable dM = DbHelperSQL.Query(sqlM).Tables[0];
string address = "";
if (dM.Rows.Count > 0)
{
address = dM.Rows[0]["addres"].ToString();
}
//发送消息模板
////插入记录
//Util.insertNotice(dd.Rows[0]["id"].ToString(),"余额变动提醒", "您于"+DateTime.Now.ToString("yyyy/MM/dd HH:mm")+"购物消费："+money+"元；余额："+ (double.Parse(dd.Rows[0]["AvailableMoney"].ToString())-double.Parse(money)));
//Util.moneyChange(dd.Rows[0]["id"].ToString(),money,(double.Parse(dd.Rows[0]["AvailableMoney"].ToString()) - double.Parse(money)).ToString(), "会员消费", "2", "");
//接着更新订单的状态
string update1 = "update asm_pay_info set chLdNo='" + ldno + "', trxdate='" + DateTime.Now.ToString("yyyyMMdd") + "',statu=1,paytime='" + DateTime.Now.ToString("yyyyMMddHHmmss") + "',acct='" + openID + "',afterMoney=" + (double.Parse(dd.Rows[0]["AvailableMoney"].ToString()) - double.Parse(money)) + " where trxid='" + trxid + "' and unionID='" + unionID + "'";
Util.Debuglog("update1=" + update1 + ";料道编号=" + ldno, "余额支付.txt");
DbHelperSQL.ExecuteSql(update1);
Util.ch(ldno, dM.Rows[0]["id"].ToString(), trxid, "3", productID, money);
string sqlP = "SELECT * FROM asm_product where productID=" + productID;
Util.Debuglog("sqlP=" + sqlP + ";料道编号=" + ldno, "余额支付.txt");
DataTable dp = DbHelperSQL.Query(sqlP).Tables[0];
string updateM = "update asm_member set mechineID=" + dM.Rows[0]["id"].ToString() + " where id=" + dd.Rows[0]["id"].ToString();
DbHelperSQL.ExecuteSql(updateM);
Util.chgMoney(dd.Rows[0]["id"].ToString(), money, "会员消费", "购买" + dp.Rows[0]["proName"].ToString(), "2");
Util.Debuglog("111111", "余额支付.txt");
wxHelper wx = new wxHelper(companyID);
string data = TemplateMessage.comsume(openID, OperUtil.getMessageID(companyID, "OPENTM401313503"), "亲，你的购买的商品信息如下",
"" + dp.Rows[0]["proName"].ToString() + "", money, trxid, dM.Rows[0]["mechineName"].ToString(), "“机器已出货，请尽快推开机器左下方推板取出奶品，超过1分钟未取视为丢弃奶品，推板将关闭");
TemplateMessage.SendTemplateMsg(wx.IsExistAccess_Token(companyID), data);
return("3");
}
public static async System.Threading.Tasks.Task paycall(Dictionary <String, String> reqParams)
{
string json = (new JavaScriptSerializer()).Serialize(reqParams);
JObject jo = (JObject)JsonConvert.DeserializeObject(json);
string sql = "select * from asm_pay_info where statu=0 and trxid='" + jo["trxid"].ToString() + "'";
Util.Debuglog("sql=" + sql, "出货信息.txt");
DataTable dt = DbHelperSQL.Query(sql).Tables[0];
if (dt.Rows.Count > 0)
{
//获取appid查询这个appid的 的appkey
string sql2 = "select * from asm_company where tl_APPID='" + dt.Rows[0]["appid"].ToString() + "'";
Util.Debuglog("sql2=" + sql2, "出货信息.txt");
DataTable d2 = DbHelperSQL.Query(sql2).Tables[0];
//AppUtil.validSign(reqParams, d2.Rows[0]["tl_APPKEY"].ToString(), d2.Rows[0]["id"].ToString())
if (dt.Rows[0]["statu"].ToString() == "0")//验签成功
{
//验签成功后,进行业务处理,处理完毕返回成功
string trxdate = jo["trxdate"].ToString();
string paytime = jo["paytime"].ToString();
string acct = jo["acct"].ToString();
string chnltrxid = jo["chnltrxid"].ToString();
double trxamtY = double.Parse(jo["trxamt"].ToString()) / 100;
//发送出货指令
string ldno = "";
//继续查找
bool b = true;
int num = 3;
while (b && num > 0)
{
num--;
ldno = Util.getLDNO(dt.Rows[0]["mechineID"].ToString(), dt.Rows[0]["productID"].ToString());
if (!string.IsNullOrEmpty(ldno))
{
b = false;
}
else
{
Thread.Sleep(1000);
}
}
Util.Debuglog("mechineID=" + dt.Rows[0]["mechineID"].ToString() + ";productID=" + dt.Rows[0]["productID"].ToString() + ";LDNO=" + ldno, "出货信息.txt");
if (!string.IsNullOrEmpty(ldno))
{
Util.ch(ldno, dt.Rows[0]["mechineID"].ToString(), jo["trxid"].ToString(), dt.Rows[0]["payType"].ToString(), dt.Rows[0]["productID"].ToString(), trxamtY.ToString());
}
Util.Debuglog("出货指令发送完成mechineID=" + dt.Rows[0]["mechineID"].ToString() + ";productID=" + dt.Rows[0]["productID"].ToString() + ";LDNO=" + ldno, "出货信息.txt");
//支付成功向asm_pay 表 更新记录
if (dt.Rows[0]["payType"].ToString() == "2")
{
string updateSQL = "update asm_pay_info set chLdNo='" + ldno + "', acct='" + acct + "', paytime='" + paytime + "',statu='1',trxdate='" + trxdate + "',chnltrxid='" + chnltrxid + "' where trxid='" + jo["trxid"].ToString() + "'";
Util.Debuglog("updateSQL=" + updateSQL, "出货信息.txt");
DbHelperSQL.ExecuteSql(updateSQL);
}
else
{
string updateSQL = "update asm_pay_info set chLdNo='" + ldno + "', paytime='" + paytime + "',statu='1',trxdate='" + trxdate + "',chnltrxid='" + chnltrxid + "' where trxid='" + jo["trxid"].ToString() + "'";
Util.Debuglog("updateSQL=" + updateSQL, "出货信息.txt");
DbHelperSQL.ExecuteSql(updateSQL);
}
//需要更新会员的消费信息 此处如果是支付宝扫码的话没法更新
if (!string.IsNullOrEmpty(dt.Rows[0]["unionID"].ToString()))
{
string update = "update asm_member set sumConsume=sumConsume+" + trxamtY + ",consumeCount=consumeCount+1,LastTime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',point=point+" + trxamtY + ",mechineID='" + dt.Rows[0]["mechineID"].ToString() + "' where unionID='" + dt.Rows[0]["unionID"].ToString() + "'";
Util.Debuglog("update=" + update, "更新会员余额消费信息.txt");
DbHelperSQL.ExecuteSql(update);
}
string sqlM = "select * from asm_member where unionID='" + dt.Rows[0]["unionID"].ToString() + "'";
DataTable dtM = DbHelperSQL.Query(sqlM).Tables[0];
//此处判断如果orderType=3是半价的需要根据dgOrderDetailID修改zt为售卖完成 并且给出售人加余额
if (dt.Rows[0]["orderType"].ToString() == "3" && dt.Rows[0]["dgOrderDetailID"].ToString() != "0" && !string.IsNullOrEmpty(dt.Rows[0]["dgOrderDetailID"].ToString()))
{
string sqlDetail = "select * from asm_orderlistDetail where id=" + dt.Rows[0]["dgOrderDetailID"].ToString();
DataTable dtDetail = DbHelperSQL.Query(sqlDetail).Tables[0];
if (dtDetail.Rows.Count > 0 && dtM.Rows.Count > 0)
{
string id = dt.Rows[0]["dgOrderDetailID"].ToString();
string memberID = dtM.Rows[0]["id"].ToString();
string productID = dt.Rows[0]["productID"].ToString();
string updateSql = "update asm_orderlistDetail set zt=6 where id=" + id;
int a = DbHelperSQL.ExecuteSql(updateSql);
if (a > 0)
{
RedisHelper.Remove(dt.Rows[0]["mechineID"].ToString() + "_SellOrderInfo");
//更新余额
string sqlPro = "select * from asm_product where productID=" + productID;
DataTable dpro = DbHelperSQL.Query(sqlPro).Tables[0];
double price = double.Parse(dpro.Rows[0]["price0"].ToString()) / 2;
string updateMember = "update asm_member set AvailableMoney=AvailableMoney+" + price + " where id=" + memberID;
DbHelperSQL.ExecuteSql(updateMember);
Util.chgMoney(memberID, price.ToString(), "售卖", "出售" + dtDetail.Rows[0]["createTime"].ToString() + "日产品", "5");
}
}
}
//给会员升级
Util.growUpMember(dt.Rows[0]["unionID"].ToString(), "");
if (dtM.Rows.Count > 0)
{
if (!string.IsNullOrEmpty(dtM.Rows[0]["openID"].ToString()))
{
string companyID = dtM.Rows[0]["companyID"].ToString();
string openID = dtM.Rows[0]["openID"].ToString();
string sqlp = "select * from asm_product where productID=" + dt.Rows[0]["productID"].ToString();
DataTable dp = DbHelperSQL.Query(sqlp).Tables[0];
string sqlMechine = "select * from asm_mechine where id=" + dt.Rows[0]["mechineID"].ToString();
DataTable dMechine = DbHelperSQL.Query(sqlMechine).Tables[0];
wxHelper wx = new wxHelper(companyID);
string data = TemplateMessage.comsume(openID, OperUtil.getMessageID(companyID, "OPENTM401313503"), "亲，你的购买的商品信息如下",
"" + dp.Rows[0]["proName"].ToString() + "", trxamtY.ToString(), jo["trxid"].ToString(), dMechine.Rows[0]["mechineName"].ToString(), "“机器已出货，请尽快推开机器左下方推板取出奶品，超过1分钟未取视为丢弃奶品，推板将关闭");
TemplateMessage.SendTemplateMsg(wx.IsExistAccess_Token(companyID), data);
}
}
}
}
Util.Debuglog("keyif=回调结束", "_聚合支付回调参数.txt");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string code = "";
if (Request.QueryString["code"] != null && Request.QueryString["code"] != "")
{
code = Request.QueryString["code"].ToString();
Util.Debuglog("code=" + code, "_获取会员信息.txt");
string companyID = Request.QueryString["companyID"].ToString();
string sql2 = "select * from asm_company where id=" + companyID;
DataTable d1 = DbHelperSQL.Query(sql2).Tables[0];
if (d1.Rows.Count > 0)
{
appid = d1.Rows[0]["appId"].ToString();
appsecret = d1.Rows[0]["wx_appsecret"].ToString();
}
OAuth_Token Model = Get_token(code, companyID);
OAuthUser OAuthUser_Model = Get_UserInfo(Model.access_token, Model.openid);
//OAuthUser OAuthUser_Model = Get_UserInfo(Model.access_token, Model.openid);
if (OAuthUser_Model.openid != null && OAuthUser_Model.openid != "") //已获取得openid及其他信息
{
tupian = OAuthUser_Model.headimgurl.ToString(); //头像图片
name = OAuthUser_Model.nickname; //昵称
id = OAuthUser_Model.openid; //opendid
unionID = OAuthUser_Model.unionid;
string country = OAuthUser_Model.country;
string province = OAuthUser_Model.province;
string city = OAuthUser_Model.city;
Util.Debuglog("unionid=" + OAuthUser_Model.unionid, "_获取会员信息.txt");
OperUtil.setCooki("vshop_openID", id);
string sql = "select * from asm_member where openID='" + id + "'or unionID='" + unionID + "' and companyID=" + companyID;
DataTable dt = DbHelperSQL.Query(sql).Tables[0];
wxHelper wx = new wxHelper(companyID);
wx.Get_UserInfo(id);
if (dt.Rows.Count <= 0)
{
//name= System.Web.HttpUtility.UrlEncode(name, System.Text.Encoding.UTF8);
//添加会员 会员不一定必须绑定机器 只有会员有订购产品的时候才必须绑定机器
string sql1 = "INSERT INTO [dbo].[asm_member]"
+ " ([name],[phone],[QQ],[province],[city],[country],[addres],[AvailableMoney],[sumConsume],[sumRecharge],[createDate],[mechineID],[companyID],[age],[LastTime],[memberBH],[consumeCount],[openID],[brithday],[headurl],[nickname],[pwd],[utfName],unionID)"
+ " VALUES(N'" + name + "','','','" + province + "','" + city + "','','',0,0,0,'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','','" + companyID + "','0','','',0,'" + id + "','','" + tupian + "',N'" + name + "','000000','" + System.Web.HttpUtility.UrlEncode(name, System.Text.Encoding.UTF8) + "','" + unionID + "')";
DbHelperSQL.ExecuteSql(sql1);
Util.Debuglog("sql1=" + sql1 + ";会员注册", "首页_.txt");
string data = TemplateMessage.Member_ZC(id, OperUtil.getMessageID(companyID, "OPENTM203347141"), "恭喜您注册成为会员！", name, "恭喜您注册成为会员，您将享受到会员所有权利！交易密码默认为000000，请前往会员中心修改");
TemplateMessage.SendTemplateMsg(wx.IsExistAccess_Token(companyID), data);
//跳转领取红包判断系统是否开启
if (d1.Rows[0]["p4"].ToString() != "" && d1.Rows[0]["p4"].ToString() != null && d1.Rows[0]["p4"].ToString() != "0")
{
Response.Write("<script>top.location.href='accethb.aspx?companyID=" + companyID + "&openID=" + id + "';</script>");
}
else
{
Response.Write("<script>top.location.href='homeIndex.aspx?companyID=" + companyID + "';</script>");
}
}
else
{
//更新会员信息
string sqlupdate = string.Format("update asm_member set name=N'{0}',headurl='{1}',utfName='{3}',unionID='" + unionID + "' where openID='{2}'", name, tupian, id, System.Web.HttpUtility.UrlEncode(name, System.Text.Encoding.UTF8));
DbHelperSQL.ExecuteSql(sqlupdate);
Response.Write("<script>top.location.href='homeIndex.aspx?companyID=" + companyID + "';</script>");
}
}
}
}
}
public static async System.Threading.Tasks.Task paycall(Dictionary <String, String> reqParams)
{
string json = (new JavaScriptSerializer()).Serialize(reqParams);
JObject jo = (JObject)JsonConvert.DeserializeObject(json);
string sql = "select * from asm_pay_info where statu=0 and trxid='" + jo["trxid"].ToString() + "'";
Util.Debuglog("sql=" + sql, "出货信息.txt");
DataTable dt = DbHelperSQL.Query(sql).Tables[0];
if (dt.Rows.Count > 0)
{
string pickupdate = "update asm_product_pick set payStatus=3,payTime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' where reqsnNo='" + dt.Rows[0]["reqsn"].ToString() + "' ";
Util.Debuglog("sqlInsert=" + pickupdate, "获取预生成订单号.txt");
DbHelperSQL.ExecuteSql(pickupdate);
//获取appid查询这个appid的 的appkey
string sql2 = "select * from asm_company where tl_APPID='" + dt.Rows[0]["appid"].ToString() + "'";
Util.Debuglog("sql2=" + sql2, "出货信息.txt");
DataTable d2 = DbHelperSQL.Query(sql2).Tables[0];
//AppUtil.validSign(reqParams, d2.Rows[0]["tl_APPKEY"].ToString(), d2.Rows[0]["id"].ToString())
if (dt.Rows[0]["statu"].ToString() == "0")//验签成功
{
string trxidInfo = RedisHelper.GetRedisModel <string>(jo["trxid"].ToString());
if (string.IsNullOrEmpty(trxidInfo))
{
//退到1微信或者2支付宝
SybWxPayService sybService = new SybWxPayService(dt.Rows[0]["mechineID"].ToString());
long fen = long.Parse(dt.Rows[0]["trxamt"].ToString());
Random rd = new Random();
int rand = rd.Next(10000, 99999);
string reqsn = Util.ConvertDateTimeToInt(DateTime.Now).ToString() + rand;
string oldtrxid = dt.Rows[0]["trxid"].ToString();
string oldreqsn = dt.Rows[0]["reqsn"].ToString();
Dictionary <String, String> rsp = sybService.cancel(fen, reqsn, oldtrxid, oldreqsn);
string data = OperUtil.SerializeDictionaryToJsonString(rsp);
Util.Debuglog("微信支付链接data=" + data, "_退款.txt");
//插入预处理订单信息
string returnJson = (new JavaScriptSerializer()).Serialize(rsp);
JObject returnjo = (JObject)JsonConvert.DeserializeObject(returnJson);
if (returnjo["retcode"].ToString() == "SUCCESS")
{
string cusid = returnjo["cusid"].ToString(); //商户号
string trxid = returnjo["trxid"].ToString(); //交易单号
string fintime = returnjo["fintime"].ToString(); //交易完成时间
string reqsn1 = returnjo["reqsn"].ToString(); //商户订单号
string trxstatus = returnjo["trxstatus"].ToString(); //交易状态
if (trxstatus == "0000")
{
//更新asm_pay_info
string update = "update asm_pay_info set statu=2,tkreqsn='" + reqsn1 + "',fintime='" + fintime + "',trxstatus='" + trxstatus + "' where trxid='" + oldtrxid + "'";
DbHelperSQL.ExecuteSql(update);
string sqlm = "select * from asm_member where openID='" + dt.Rows[0]["acct"].ToString() + "'";
DataTable sqlmdt = DbHelperSQL.Query(sqlm).Tables[0];
if (sqlmdt.Rows.Count > 0)
{
Util.insertNotice(sqlmdt.Rows[0]["id"].ToString(), "出货异常退款", "您于" + dt.Rows[0]["createTime"].ToString() + "购买商品出货异常退还金额:" + double.Parse(dt.Rows[0]["trxamt"].ToString()) / 100 + ";请查收微信或支付宝", dt.Rows[0]["mechineID"].ToString());
Util.moneyChange(sqlmdt.Rows[0]["id"].ToString(), (double.Parse(fen.ToString()) / 100).ToString("0.00"), sqlmdt.Rows[0]["AvailableMoney"].ToString(), "退款通知", "7", "");
try
{
string company = Util.getCompany(sqlmdt.Rows[0]["companyID"].ToString());
wxHelper wx = new wxHelper(sqlmdt.Rows[0]["companyID"].ToString());
data = TemplateMessage.tk(sqlmdt.Rows[0]["openID"].ToString(), OperUtil.getMessageID(sqlmdt.Rows[0]["companyID"].ToString(), "OPENTM410089600"), "退款通知", (double.Parse(dt.Rows[0]["trxamt"].ToString()) / 100).ToString("f2"), "您购买的商品没有出货成功，钱已退还到账户");
TemplateMessage.SendTemplateMsg(wx.IsExistAccess_Token(sqlmdt.Rows[0]["companyID"].ToString()), data);
}
catch (Exception e)
{
Util.Debuglog("e=" + e.Message, "会员等级消息模板.txt");
}
}
}
else
{
string errmsg = jo["errmsg"].ToString();//交易失败信息
string update = "update asm_pay_info set tkreqsn='" + reqsn1 + "',fintime='" + fintime + "',trxstatus='" + trxstatus + "',errmsg='" + errmsg + "' where trxid='" + oldtrxid + "'";
DbHelperSQL.ExecuteSql(update);
}
}
return;
}
//验签成功后,进行业务处理,处理完毕返回成功
string trxdate = jo["trxdate"].ToString();
string paytime = jo["paytime"].ToString();
string acct = jo["acct"].ToString();
string chnltrxid = jo["chnltrxid"].ToString();
double trxamtY = double.Parse(jo["trxamt"].ToString()) / 100;
//发送出货指令
string ldno = "";
//继续查找
bool b = true;
int num = 3;
while (b && num > 0)
{
num--;
ldno = Util.getLDNO(dt.Rows[0]["mechineID"].ToString(), dt.Rows[0]["productID"].ToString());
if (!string.IsNullOrEmpty(ldno))
{
b = false;
}
else
{
Thread.Sleep(1000);
}
}
Util.Debuglog("mechineID=" + dt.Rows[0]["mechineID"].ToString() + ";productID=" + dt.Rows[0]["productID"].ToString() + ";LDNO=" + ldno, "出货信息.txt");
if (!string.IsNullOrEmpty(ldno))
{
Util.chNew(ldno, dt.Rows[0]["mechineID"].ToString(), jo["trxid"].ToString(), dt.Rows[0]["payType"].ToString(), dt.Rows[0]["productID"].ToString(), trxamtY.ToString());
}
Util.Debuglog("出货指令发送完成mechineID=" + dt.Rows[0]["mechineID"].ToString() + ";productID=" + dt.Rows[0]["productID"].ToString() + ";LDNO=" + ldno, "出货信息.txt");
//支付成功向asm_pay 表 更新记录
if (dt.Rows[0]["payType"].ToString() == "2")
{
string updateSQL = "update asm_pay_info set chLdNo='" + ldno + "', acct='" + acct + "', paytime='" + paytime + "',statu='1',trxdate='" + trxdate + "',chnltrxid='" + chnltrxid + "' where trxid='" + jo["trxid"].ToString() + "'";
Util.Debuglog("updateSQL=" + updateSQL, "出货信息.txt");
DbHelperSQL.ExecuteSql(updateSQL);
}
else
{
string updateSQL = "update asm_pay_info set chLdNo='" + ldno + "', paytime='" + paytime + "',statu='1',trxdate='" + trxdate + "',chnltrxid='" + chnltrxid + "' where trxid='" + jo["trxid"].ToString() + "'";
Util.Debuglog("updateSQL=" + updateSQL, "出货信息.txt");
DbHelperSQL.ExecuteSql(updateSQL);
}
//需要更新会员的消费信息 此处如果是支付宝扫码的话没法更新
if (!string.IsNullOrEmpty(dt.Rows[0]["unionID"].ToString()))
{
string update = "update asm_member set sumConsume=sumConsume+" + trxamtY + ",consumeCount=consumeCount+1,LastTime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',point=point+" + trxamtY + ",mechineID='" + dt.Rows[0]["mechineID"].ToString() + "' where unionID='" + dt.Rows[0]["unionID"].ToString() + "'";
Util.Debuglog("update=" + update, "更新会员余额消费信息.txt");
DbHelperSQL.ExecuteSql(update);
}
string sqlM = "select * from asm_member where unionID='" + dt.Rows[0]["unionID"].ToString() + "'";
DataTable dtM = DbHelperSQL.Query(sqlM).Tables[0];
string searchSql = "select 1 from asm_firstPayRecord where mechineID=" + dt.Rows[0]["mechineID"].ToString() + " AND memberID='" + dtM.Rows[0]["id"].ToString() + "'";
DataTable searchSqldt = DbHelperSQL.Query(searchSql).Tables[0];
if (searchSqldt.Rows.Count > 0)
{
}
else
{
string insertsql = "insert into asm_firstPayRecord(mechineID,memberID,firstinfo,firstbuyTime,type) values (" + dt.Rows[0]["mechineID"].ToString() + "," + dtM.Rows[0]["id"].ToString() + ",'" + jo["trxid"].ToString() + "','" + DateTime.Now.ToString("yyyy-MM-dd") + "','" + 2 + "') ";
Util.Debuglog("sqlInsert=" + insertsql, "获取预生成订单号.txt");
DbHelperSQL.ExecuteSql(insertsql);
}
//此处判断如果orderType=3是半价的需要根据dgOrderDetailID修改zt为售卖完成 并且给出售人加余额
if (dt.Rows[0]["orderType"].ToString() == "3" && dt.Rows[0]["dgOrderDetailID"].ToString() != "0" && !string.IsNullOrEmpty(dt.Rows[0]["dgOrderDetailID"].ToString()))
{
string sqlDetail = "select * from asm_orderlistDetail where id=" + dt.Rows[0]["dgOrderDetailID"].ToString();
DataTable dtDetail = DbHelperSQL.Query(sqlDetail).Tables[0];
if (dtDetail.Rows.Count > 0)
{
string id = dt.Rows[0]["dgOrderDetailID"].ToString();
string memberID = dtDetail.Rows[0]["memberID"].ToString();
string productID = dt.Rows[0]["productID"].ToString();
string updateSql = "update asm_orderlistDetail set zt=6 where id=" + id;
int a = DbHelperSQL.ExecuteSql(updateSql);
if (a > 0)
{
RedisHelper.Remove(dt.Rows[0]["mechineID"].ToString() + "_SellOrderInfo");
//更新余额
string sqlPro = "select * from asm_product where productID=" + productID;
DataTable dpro = DbHelperSQL.Query(sqlPro).Tables[0];
string updateMember = "update asm_member set AvailableMoney=AvailableMoney+" + dtDetail.Rows[0]["sellPrice"].ToString() + " where id=" + memberID;
DbHelperSQL.ExecuteSql(updateMember);
Util.chgMoney(memberID, dtDetail.Rows[0]["sellPrice"].ToString(), "售卖", "出售" + dtDetail.Rows[0]["createTime"].ToString() + "日产品", "5");
}
}
}
//给会员升级
Util.growUpMember(dt.Rows[0]["unionID"].ToString(), "");
if (dtM.Rows.Count > 0)
{
if (!string.IsNullOrEmpty(dtM.Rows[0]["openID"].ToString()))
{
string companyID = dtM.Rows[0]["companyID"].ToString();
string openID = dtM.Rows[0]["openID"].ToString();
string sqlp = "select * from asm_product where productID=" + dt.Rows[0]["productID"].ToString();
DataTable dp = DbHelperSQL.Query(sqlp).Tables[0];
string sqlMechine = "select * from asm_mechine where id=" + dt.Rows[0]["mechineID"].ToString();
DataTable dMechine = DbHelperSQL.Query(sqlMechine).Tables[0];
wxHelper wx = new wxHelper(companyID);
string data = TemplateMessage.comsume(openID, OperUtil.getMessageID(companyID, "OPENTM401313503"), "亲，你的购买的商品信息如下",
"" + dp.Rows[0]["proName"].ToString() + "", trxamtY.ToString(), jo["trxid"].ToString(), dMechine.Rows[0]["mechineName"].ToString(), "“机器已出货，请尽快推开机器左下方推板取出奶品，超过1分钟未取视为丢弃奶品，推板将关闭");
TemplateMessage.SendTemplateMsg(wx.IsExistAccess_Token(companyID), data);
}
}
}
}
Util.Debuglog("keyif=回调结束", "_聚合支付回调参数.txt");
}
public static Object ok(string billno, string pwd, string companyID)
{
//首先验证二级退款密码是否正确
string sql12 = "select * from asm_company where id=" + companyID;
DataTable dd1 = DbHelperSQL.Query(sql12).Tables[0];
if (dd1.Rows.Count > 0)
{
if (pwd == dd1.Rows[0]["pwd2"].ToString())
{
//查询该笔订单信息
string sql1 = "select * from asm_pay_info where trxid='" + billno + "'";
DataTable dt1 = DbHelperSQL.Query(sql1).Tables[0];
if (dt1.Rows.Count > 0)
{
//查询订单信息
string sqlOrder = "select * from asm_sellDetail where billno='" + billno + "'";
DataTable Dorder = DbHelperSQL.Query(sqlOrder).Tables[0];
if (Dorder.Rows.Count <= 0)
{
return(new { result = 0, msg = "该笔订单查询失败" });
}
//判断出货状态如果是料道错误或者是交易序列号相同给退款 零售的怎么来怎么退 订购的退到钱包
if (!string.IsNullOrEmpty(Dorder.Rows[0]["code"].ToString()))
{
//订购的
if (Dorder.Rows[0]["bz"].ToString() == "料道错误" || Dorder.Rows[0]["bz"].ToString() == "交易序列号相同" || Dorder.Rows[0]["bz"].ToString() == "料道故障" || Dorder.Rows[0]["bz"].ToString() == "校验错误" || Dorder.Rows[0]["bz"].ToString() == "出货失败")
{
string sql = "select * from asm_sellDetail where billno='" + billno + "'";
DataTable dd = DbHelperSQL.Query(sql).Tables[0];
if (dd.Rows.Count > 0)
{
//更新会员钱包 并插入资金变动记录
string update = "update asm_member set AvailableMoney=AvailableMoney+" + dd.Rows[0]["totalMoney"].ToString() + ",sumConsume=sumConsume-" + dd.Rows[0]["totalMoney"].ToString() + " where id=" + dd.Rows[0]["memberID"].ToString();
int a = DbHelperSQL.ExecuteSql(update);
string sqlm = "select * from asm_member where id=" + dd.Rows[0]["memberID"].ToString();
DataTable dt = DbHelperSQL.Query(sqlm).Tables[0];
if (a > 0)
{
string sqlu = "update asm_sellDetail set bz='退款成功' where billno='" + billno + "'";
DbHelperSQL.ExecuteSql(sqlu);
Util.insertNotice(dt.Rows[0]["id"].ToString(), "出货异常退款", "您于" + Dorder.Rows[0]["orderTime"].ToString() + "取货异常退还金额:" + dd.Rows[0]["totalMoney"].ToString() + ";请查收钱包");
Util.moneyChange(dt.Rows[0]["id"].ToString(), dd.Rows[0]["totalMoney"].ToString(), dt.Rows[0]["AvailableMoney"].ToString(), "退款通知", "7", "", dd.Rows[0]["totalMoney"].ToString());
if (!string.IsNullOrEmpty(dt.Rows[0]["openID"].ToString()))
{
try
{
string company = Util.getCompany(dt.Rows[0]["companyID"].ToString());
wxHelper wx = new wxHelper(dt.Rows[0]["companyID"].ToString());
string data = TemplateMessage.tk(dt.Rows[0]["openID"].ToString(), OperUtil.getMessageID(dt.Rows[0]["companyID"].ToString(), "OPENTM410089600"), "退款通知", dd.Rows[0]["totalMoney"].ToString(), "您购买的商品没有出货成功，钱已退还到账户");
TemplateMessage.SendTemplateMsg(wx.IsExistAccess_Token(dt.Rows[0]["companyID"].ToString()), data);
}
catch (Exception e)
{
Util.Debuglog("e=" + e.Message, "会员等级消息模板.txt");
}
}
return(new { result = 0, msg = "退款成功，成功到会员钱包中" });
}
}
}
}
else
{
//零售的
if (Dorder.Rows[0]["bz"].ToString() == "料道错误" || Dorder.Rows[0]["bz"].ToString() == "交易序列号相同" || Dorder.Rows[0]["bz"].ToString() == "料道故障" || Dorder.Rows[0]["bz"].ToString() == "校验错误" || Dorder.Rows[0]["bz"].ToString() == "出货失败")
{
Util.Debuglog("billno=" + billno, "_手动退款.txt");
if (Dorder.Rows[0]["payType"].ToString() == "3")
{
//退到钱包
string sql = "select * from asm_sellDetail where billno='" + billno + "'";
DataTable dd = DbHelperSQL.Query(sql).Tables[0];
if (dd.Rows.Count > 0)
{
//更新会员钱包 并插入资金变动记录
string update = "update asm_member set AvailableMoney=AvailableMoney+" + dd.Rows[0]["totalMoney"].ToString() + ",sumConsume=sumConsume-" + dd.Rows[0]["totalMoney"].ToString() + " where id=" + dd.Rows[0]["memberID"].ToString();
int a = DbHelperSQL.ExecuteSql(update);
string sqlm = "select * from asm_member where id=" + dd.Rows[0]["memberID"].ToString();
DataTable dt = DbHelperSQL.Query(sqlm).Tables[0];
if (a > 0)
{
string update1 = "update asm_pay_info set statu=2,fintime='" + DateTime.Now.ToString("yyyyMMddHHmmss") + "' where trxid='" + billno + "'";
DbHelperSQL.ExecuteSql(update1);
string sqlu = "update asm_sellDetail set bz='退款成功' where billno='" + billno + "'";
DbHelperSQL.ExecuteSql(sqlu);
Util.insertNotice(dt.Rows[0]["id"].ToString(), "出货异常退款", "您于" + Dorder.Rows[0]["orderTime"].ToString() + "购买商品出货异常退还金额:" + dd.Rows[0]["totalMoney"].ToString() + ";请查收钱包");
Util.moneyChange(dt.Rows[0]["id"].ToString(), dd.Rows[0]["totalMoney"].ToString(), dt.Rows[0]["AvailableMoney"].ToString(), "退款通知", "7", "", "取货异常退还金额:" + dd.Rows[0]["totalMoney"].ToString());
return(new { result = 0, msg = "退款成功，成功到会员钱包中" });
}
}
}
else if (Dorder.Rows[0]["payType"].ToString() == "1" || Dorder.Rows[0]["payType"].ToString() == "2")
{
//退到1微信或者2支付宝
string sql = "select * from asm_pay_info where trxid='" + billno + "'";
DataTable dd = DbHelperSQL.Query(sql).Tables[0];
if (dd.Rows.Count > 0 && dd.Rows[0]["statu"].ToString() == "1")
{
SybWxPayService sybService = new SybWxPayService(Dorder.Rows[0]["mechineID"].ToString());
long fen = long.Parse(dd.Rows[0]["trxamt"].ToString());
Random rd = new Random();
int rand = rd.Next(10000, 99999);
string reqsn = ConvertDateTimeToInt(DateTime.Now).ToString() + rand;
string oldtrxid = dd.Rows[0]["trxid"].ToString();
string oldreqsn = dd.Rows[0]["reqsn"].ToString();
Dictionary <String, String> rsp = sybService.cancel(fen, reqsn, oldtrxid, oldreqsn);
string data = OperUtil.SerializeDictionaryToJsonString(rsp);
Util.Debuglog("oldtrxid=" + oldtrxid + ";微信支付链接data=" + data, "_手动退款.txt");
//插入预处理订单信息
string json = (new JavaScriptSerializer()).Serialize(rsp);
Util.Debuglog("微信支付链接json=" + json, "_手动退款.txt");
JObject jo = (JObject)JsonConvert.DeserializeObject(json);
if (jo["retcode"].ToString() == "SUCCESS")
{
try
{
string msg = jo["errmsg"].ToString();
return(new { result = 0, msg = msg });
}
catch
{
}
string cusid = jo["cusid"].ToString(); //商户号
string trxid = jo["trxid"].ToString(); //交易单号
string fintime = jo["fintime"].ToString(); //交易完成时间
string reqsn1 = jo["reqsn"].ToString(); //商户订单号
string trxstatus = jo["trxstatus"].ToString(); //交易状态
//更新asm_pay_info
if (trxstatus == "0000")
{
string update = "update asm_pay_info set statu=2,tkreqsn='" + reqsn1 + "',fintime='" + fintime + "',trxstatus='" + trxstatus + "',errmsg='' where trxid='" + oldtrxid + "'";
DbHelperSQL.ExecuteSql(update);
string sqlu = "update asm_sellDetail set bz='退款成功' where billno='" + billno + "'";
DbHelperSQL.ExecuteSql(sqlu);
string update1 = "update asm_member set sumConsume=sumConsume-" + (double.Parse(dd.Rows[0]["trxamt"].ToString()) / 100) + " where openID='" + dd.Rows[0]["acct"].ToString() + "'";
int a = DbHelperSQL.ExecuteSql(update1);
string sqlm = "select * from asm_member where openID='" + dd.Rows[0]["acct"].ToString() + "'";
DataTable dt = DbHelperSQL.Query(sqlm).Tables[0];
if (!string.IsNullOrEmpty(dt.Rows[0]["openID"].ToString()))
{
try
{
string sqlPayInfo = "select * from asm_pay_info where trxid='" + billno + "'";
DataTable ddpayInfo = DbHelperSQL.Query(sqlPayInfo).Tables[0];
string company = Util.getCompany(dt.Rows[0]["companyID"].ToString());
wxHelper wx = new wxHelper(dt.Rows[0]["companyID"].ToString());
data = TemplateMessage.tk(dt.Rows[0]["openID"].ToString(), OperUtil.getMessageID(dt.Rows[0]["companyID"].ToString(), "OPENTM410089600"), "退款通知", (double.Parse(ddpayInfo.Rows[0]["trxamt"].ToString()) / 100).ToString("f2"), "您购买的商品没有出货成功，钱已退还到账户");
TemplateMessage.SendTemplateMsg(wx.IsExistAccess_Token(dt.Rows[0]["companyID"].ToString()), data);
}
catch (Exception e)
{
Util.Debuglog("e=" + e.Message, "会员等级消息模板.txt");
}
}
return(new { result = 0, msg = "退款成功，已经退到会员的微信或支付宝" });
}
else
{
string errmsg = jo["errmsg"].ToString();//交易失败信息
string update = "update asm_pay_info set tkreqsn='" + reqsn1 + "',fintime='" + fintime + "',trxstatus='" + trxstatus + "',errmsg='" + errmsg + "' where trxid='" + oldtrxid + "'";
DbHelperSQL.ExecuteSql(update);
if (trxstatus == "3008")
{
return(new { result = 0, msg = errmsg });
}
else
{
return(new { result = 0, msg = "退款失败" });
}
}
}
else
{
return(new { result = 0, msg = "退款失败" });
}
}
}
}
}
}
else
{
return(new { result = 0, msg = "该笔订单查询失败" });
}
}
else
{
return(new { result = 0, msg = "退款密码错误" });//密码错误
}
}
return(new { result = 0, msg = "退款失败" });
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string code = "";
if (Request.QueryString["code"] != null && Request.QueryString["code"] != "")
{
code = Request.QueryString["code"].ToString();
Util.Debuglog("code=" + code + ";state=" + Request.QueryString["state"], "获取参数.txt");
string[] param = Request.QueryString["state"].ToString().Split('|');
if (param.Length != 4)
{
//Response.Write("<span style='color:#FF0000;font-size:20px'>" + "参数不全请重试" + "</span>");
}
//9|14|43|334|0|1
string money = param[0]; //9
string companyID = param[1]; //14
string mechineID = param[2]; //43
string productID = param[3]; //334
string dgOrderDetailID = param[4]; //0
string type = param[5]; //1
string sftj = param[6]; //1 是特价
string sql2 = "select * from asm_company where id=" + companyID;
DataTable d1 = DbHelperSQL.Query(sql2).Tables[0];
if (d1.Rows.Count > 0)
{
appid = d1.Rows[0]["appId"].ToString();
appsecret = d1.Rows[0]["wx_appsecret"].ToString();
}
OAuth_Token Model = Get_token(code, companyID);
OAuthUser OAuthUser_Model = Get_UserInfo(Model.access_token, Model.openid);
if (OAuthUser_Model.openid != null && OAuthUser_Model.openid != "") //已获取得openid及其他信息
{
headImg = OAuthUser_Model.headimgurl.ToString(); //头像图片
name = OAuthUser_Model.nickname; //昵称
id = OAuthUser_Model.openid; //opendid
unionID = OAuthUser_Model.unionid;
string province = OAuthUser_Model.province;
string city = OAuthUser_Model.city;
string country = OAuthUser_Model.city;
string gender = OAuthUser_Model.sex == "1" ? "男" : "女";
// Util.SetSession("_openID", id);
Util.Debuglog("id=" + id, "获取token.txt");//o1_mf1aL2bduKZnTzG1irrfvN0x8
string sql = "select * from asm_member where unionID='" + unionID + "'";
Util.Debuglog("sql=" + sql, "零售支付用户注册.txt");
DataTable dt = DbHelperSQL.Query(sql).Tables[0];
string sql3 = "select * from asm_tqlist where companyID=" + companyID;
Util.Debuglog("sql3=" + sql3, "零售支付用户注册.txt");
DataTable d3 = DbHelperSQL.Query(sql3).Tables[0];
if (d3.Rows.Count > 0 && d3.Rows[0]["memberprice"].ToString() == "1" && dt.Rows.Count > 0)
{
//查询该产品是否限时特价
money = Util.getNewProductPrice(productID, mechineID, dt.Rows[0]["dj"].ToString());
}
else
{
string sql1 = "select * from asm_product where productID=" + productID;
DataTable dt1 = DbHelperSQL.Query(sql1).Tables[0];
money = dt1.Rows[0]["price0"].ToString();
}
//判断限购次数
if (dt.Rows.Count <= 0)
{
string insert = "insert into asm_member(name,phone,province,city,country,AvailableMoney,sumConsume,sumRecharge,createDate,companyID,headurl,nickname,sex,unionID,openID,consumeCount)"
+ " values(N'" + name + "','','" + province + "','" + city + "','" + country + "',0,0,0,'" + DateTime.Now + "','" + companyID + "','" + headImg + "',N'" + name + "','" + gender + "','" + unionID + "','" + id + "',0)";
Util.Debuglog(insert, "零售支付用户注册.txt");
DbHelperSQL.ExecuteSql(insert);
//发送注册成为会员模板消息
wxHelper wx = new wxHelper(companyID);
string data = TemplateMessage.Member_ZC(id, OperUtil.getMessageID(companyID, "OPENTM203347141"), "恭喜您注册成为会员！", name, "恭喜您注册成为会员，您将享受到会员所有权利！");
TemplateMessage.SendTemplateMsg(wx.IsExistAccess_Token(companyID), data);
}
else
{
//更新
string update = "update asm_member set openID='" + id + "' where unionID='" + unionID + "'";
Util.Debuglog("更新" + update, "是否限购.txt");
DbHelperSQL.ExecuteSql(update);
//限购判断
if (!Util.xgCount(productID, dt.Rows[0]["id"].ToString(), mechineID))
{
Util.Debuglog("限购" + unionID, "是否限购.txt");
string url13 = "https://wx.bingoseller.com/main/xg.aspx";
//限购不让购买
Response.Write("<script>window.location.href='" + url13 + "';</script>");
return;
}
if (unionID == "owhCR0esai2hPXH4lYkeLMAcccuE" || unionID == "owhCR0XLU0NM_GauIWydxGogmHfk")
{
string url1 = "https://wx.bingoseller.com/main/wxorbalanceceshi.aspx?companyID=" + companyID + "&mechineID=" + mechineID + "&money=" + money + "&unionID=" + unionID + "&openID=" + id + "&productID=" + productID + "&dgOrderDetailID=" + dgOrderDetailID + "&type=" + type + "&sftj=" + sftj;
Util.Debuglog("url1=" + url1, "微信+余额.txt");
Response.Write("<script>window.location.href='" + url1 + "';</script>");
return;
}
if (dt.Rows.Count > 0 && double.Parse(dt.Rows[0]["AvailableMoney"].ToString()) >= double.Parse(money))
{
string url1 = "https://wx.bingoseller.com/main/wxorbalance.aspx?companyID=" + companyID + "&mechineID=" + mechineID + "&money=" + money + "&unionID=" + unionID + "&openID=" + id + "&productID=" + productID + "&dgOrderDetailID=" + dgOrderDetailID + "&type=" + type + "&sftj=" + sftj;
Util.Debuglog("url1=" + url1, "微信+余额.txt");
Response.Write("<script>window.location.href='" + url1 + "';</script>");
return;
}
}
string url12 = "https://wx.bingoseller.com/main/wxorbalance.aspx?companyID=" + companyID + "&mechineID=" + mechineID + "&money=" + money + "&unionID=" + unionID + "&openID=" + id + "&productID=" + productID + "&dgOrderDetailID=" + dgOrderDetailID + "&type=" + type + "&sftj=" + sftj;
Util.Debuglog("url12=" + url12, "微信+余额.txt");
Response.Write("<script>window.location.href='" + url12 + "';</script>");
return;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string code = "";
if (Request.QueryString["code"] != null && Request.QueryString["code"] != "")
{
code = Request.QueryString["code"].ToString();
Util.Debuglog("code=" + code + ";state=" + Request.QueryString["state"], "获取参数.txt");
string[] param = Request.QueryString["state"].ToString().Split('|');
if (param.Length != 4)
{
//Response.Write("<span style='color:#FF0000;font-size:20px'>" + "参数不全请重试" + "</span>");
}
//9|14|43|334|0|1
//string money = param[0];//9
string companyID = param[0];//14
//string mechineID = param[2];//43
// string productID = param[3];//334
// string dgOrderDetailID = param[4];//0
// string type = param[5];//1
//string sftj = param[6];//1 是特价
string reqsn = param[1];
//reqsn= reqsn.Replace("reqsn", "");
string productID = ""; //334
string mechineID = ""; //334
string dgOrderDetailID = "0"; //0
string type = "2"; //1
string sftj = "0"; //1 是特价
string asm_product_picksql = "select * from asm_product_pick where reqsnNo='" + reqsn + "' ";
DataTable asm_product_pickdt = DbHelperSQL.Query(asm_product_picksql).Tables[0];
if (asm_product_pickdt.Rows.Count > 0)
{
productID = asm_product_pickdt.Rows[0]["productID"].ToString();
mechineID = asm_product_pickdt.Rows[0]["mechineID"].ToString();
dgOrderDetailID = asm_product_pickdt.Rows[0]["dgOrderDetailID"].ToString();
type = asm_product_pickdt.Rows[0]["type"].ToString();
sftj = asm_product_pickdt.Rows[0]["sftj"].ToString();
}
else
{
return;
}
string sql2 = "select * from asm_company where id=" + companyID;
DataTable d1 = DbHelperSQL.Query(sql2).Tables[0];
if (d1.Rows.Count > 0)
{
appid = d1.Rows[0]["appId"].ToString();
appsecret = d1.Rows[0]["wx_appsecret"].ToString();
}
OAuth_Token Model = Get_token(code, companyID);
OAuthUser OAuthUser_Model = Get_UserInfo(Model.access_token, Model.openid);
if (OAuthUser_Model.openid != null && OAuthUser_Model.openid != "") //已获取得openid及其他信息
{
headImg = OAuthUser_Model.headimgurl.ToString(); //头像图片
name = OAuthUser_Model.nickname; //昵称
id = OAuthUser_Model.openid; //opendid
unionID = OAuthUser_Model.unionid;
string province = OAuthUser_Model.province;
string city = OAuthUser_Model.city;
string country = OAuthUser_Model.city;
string gender = OAuthUser_Model.sex == "1" ? "男" : "女";
// Util.SetSession("_openID", id);
Util.Debuglog("id=" + id, "获取token.txt");//o1_mf1aL2bduKZnTzG1irrfvN0x8
string sql = "select * from asm_member where unionID='" + unionID + "'";
Util.Debuglog("sql=" + sql, "零售支付用户注册.txt");
DataTable dt = DbHelperSQL.Query(sql).Tables[0];
//判断限购次数
if (dt.Rows.Count <= 0)
{
string insert = "insert into asm_member(name,phone,province,city,country,AvailableMoney,sumConsume,sumRecharge,createDate,companyID,headurl,nickname,sex,unionID,openID,consumeCount)"
+ " values(N'" + name + "','','" + province + "','" + city + "','" + country + "',0,0,0,'" + DateTime.Now + "','" + companyID + "','" + headImg + "',N'" + name + "','" + gender + "','" + unionID + "','" + id + "',0);select @@IDENTITY";
Util.Debuglog(insert, "零售支付用户注册.txt");
object obj = DbHelperSQL.GetSingle(insert);
if (obj == null)
{
}
else
{
string pickupdate = "update asm_product_pick set memberID=" + Convert.ToInt32(obj).ToString() + " where reqsnNo='" + reqsn + "' ";
Util.Debuglog("sqlInsert=" + pickupdate, "获取预生成订单号.txt");
DbHelperSQL.ExecuteSql(pickupdate);
}
//发送注册成为会员模板消息
wxHelper wx = new wxHelper(companyID);
string data = TemplateMessage.Member_ZC(id, OperUtil.getMessageID(companyID, "OPENTM203347141"), "恭喜您注册成为会员！", name, "恭喜您注册成为会员，您将享受到会员所有权利！");
TemplateMessage.SendTemplateMsg(wx.IsExistAccess_Token(companyID), data);
}
else
{
string pickupdate = "update asm_product_pick set memberID=" + dt.Rows[0]["id"].ToString() + " where reqsnNo='" + reqsn + "' ";
Util.Debuglog("sqlInsert=" + pickupdate, "获取预生成订单号.txt");
DbHelperSQL.ExecuteSql(pickupdate);
//更新
string update = "update asm_member set openID='" + id + "' where unionID='" + unionID + "'";
Util.Debuglog("更新" + update, "是否限购.txt");
DbHelperSQL.ExecuteSql(update);
//限购判断
if (!Util.xgCount(productID, dt.Rows[0]["id"].ToString(), mechineID))
{
Util.Debuglog("限购" + unionID, "是否限购.txt");
string url13 = "https://wx.bingoseller.com/main/xg.aspx";
//限购不让购买
Response.Write("<script>window.location.href='" + url13 + "';</script>");
return;
}
if (unionID == "owhCR0esai2hPXH4lYkeLMAcccuE" || unionID == "owhCR0XLU0NM_GauIWydxGogmHfk" || unionID == "owhCR0bslgzXtWBLHv-ll7W1Me4c" || unionID == "owhCR0UPVXSCxYyPhkNy3wejNjNs" || unionID == "owhCR0dm8yPqHIYZhMnjti_PvA3U")
{
string url1 = "https://wx.bingoseller.com/main/wxorbalanceNew.aspx?companyID=" + companyID + "&mechineID=" + mechineID + "&unionID=" + unionID + "&openID=" + id + "&productID=" + productID + "&dgOrderDetailID=" + dgOrderDetailID + "&type=" + type + "&sftj=" + sftj + "&reqsn=" + reqsn;
Util.Debuglog("url1=" + url1, "微信+余额.txt");
Response.Write("<script>window.location.href='" + url1 + "';</script>");
return;
}
}
string url12 = "https://wx.bingoseller.com/main/wxorbalance.aspx?companyID=" + companyID + "&mechineID=" + mechineID + "&unionID=" + unionID + "&openID=" + id + "&productID=" + productID + "&dgOrderDetailID=" + dgOrderDetailID + "&type=" + type + "&sftj=" + sftj;
Util.Debuglog("url12=" + url12, "微信+余额.txt");
Response.Write("<script>window.location.href='" + url12 + "';</script>");
return;
}
}
}
}
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());
Util.Debuglog("key=" + Request.Form.Keys[i] + ";param=" + Request.Form[i].ToString(), "_充值日志.txt");
}
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 * from asm_pay_info where trxid='" + jo["trxid"].ToString() + "'";
Util.Debuglog("支付信息sql=" + sql, "_充值日志.txt");
DataTable dt = DbHelperSQL.Query(sql).Tables[0];
if (dt.Rows.Count > 0)
{
//获取openid查询这个openid的companyID 的appkey
string sql12 = "select * from asm_member where openID='" + dt.Rows[0]["acct"].ToString() + "'";
DataTable d1 = DbHelperSQL.Query(sql12).Tables[0];
string sql2 = "select * from asm_company where id=" + d1.Rows[0]["companyID"].ToString();
DataTable d2 = DbHelperSQL.Query(sql2).Tables[0];
//AppUtil.validSign(reqParams, d2.Rows[0]["tl_APPKEY"].ToString(),d1.Rows[0]["companyID"].ToString())
Util.Debuglog("支付信息状态=" + dt.Rows[0]["statu"].ToString(), "_充值日志.txt");
if (1 == 1 && dt.Rows[0]["statu"].ToString() == "0")//验签成功
{
//验签成功后,进行业务处理,处理完毕返回成功
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;
trxamtY = double.Parse(dt.Rows[0]["trxamt"].ToString()) / 100;
//支付成功向asm_pay 表 更新记录
string updateSQL = "update asm_pay_info set paytime='" + paytime + "',statu='1',trxdate='" + trxdate + "',chnltrxid='" + chnltrxid + "' where trxid='" + jo["trxid"].ToString() + "'";
int a = DbHelperSQL.ExecuteSql(updateSQL);
if (a > 0)
{
////更新会员余额
//string update = "update asm_member set AvailableMoney=AvailableMoney+" + dt.Rows[0]["dzMoney"].ToString() + ",sumRecharge=sumRecharge+" + dt.Rows[0]["dzMoney"].ToString() + ",point=point+" + trxamtY + " where openID='" + dt.Rows[0]["acct"].ToString() + "'";
//Util.Debuglog("充值更新sql" + update, "_充值日志.txt");
//DbHelperSQL.ExecuteSql(update);
//string sql12 = "select * from asm_member where openID='" + dt.Rows[0]["acct"].ToString() + "'";
//DataTable dd = DbHelperSQL.Query(sql12).Tables[0];
//wxHelper wx = new wxHelper(d1.Rows[0]["companyID"].ToString());
//string data = TemplateMessage.success_cz(dt.Rows[0]["acct"].ToString(), OperUtil.getMessageID(d1.Rows[0]["companyID"].ToString(), "OPENTM410481462"), "充值成功通知", dt.Rows[0]["dzMoney"].ToString(), dd.Rows[0]["AvailableMoney"].ToString(), "充值时间:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
//TemplateMessage.SendTemplateMsg(wx.IsExistAccess_Token(d1.Rows[0]["companyID"].ToString()), data);
////插入记录
//Util.insertNotice(dd.Rows[0]["id"].ToString(), "充值成功通知", "您于" + DateTime.Now.ToString("yyyy/MM/dd HH:mm") + "充值金额:" + trxamtY + ";到账金额:" + dt.Rows[0]["dzMoney"].ToString());
//Util.moneyChange(dd.Rows[0]["id"].ToString(), trxamtY.ToString(), dd.Rows[0]["AvailableMoney"].ToString(), "会员充值", "1", "");
//Util.moneyChange(dd.Rows[0]["id"].ToString(), trxamtY.ToString(), dd.Rows[0]["point"].ToString(), "积分变动", "5", "");
//更新会员余额
string update = "update asm_member set AvailableMoney=AvailableMoney+" + dt.Rows[0]["dzMoney"].ToString() + ",sumRecharge=sumRecharge+" + dt.Rows[0]["dzMoney"].ToString() + ",point=point+" + trxamtY + " where openID='" + dt.Rows[0]["acct"].ToString() + "'";
Util.Debuglog("充值更新update1" + update, "_充值日志.txt");
DbHelperSQL.ExecuteSql(update);
string sql1 = "select * from asm_member where openID='" + dt.Rows[0]["acct"].ToString() + "'";
string shouchongMoney = "0";
Util.Debuglog("充值更新sql1" + sql1, "_充值日志.txt");
DataTable dd = DbHelperSQL.Query(sql1).Tables[0];
shouchongMoney = dd.Rows[0]["hongbaoF"].ToString();
//判断系统是否开启首次充值赠送金额活动0不开启
string sqlC = "select * from asm_company where id=" + d1.Rows[0]["companyID"].ToString();
Util.Debuglog("充值更新sqlC" + sqlC + ";shouchongMoney=" + shouchongMoney, "_充值日志.txt");
DataTable dc = DbHelperSQL.Query(sqlC).Tables[0];
if (dc.Rows.Count > 0)
{
if (dc.Rows[0]["p4"].ToString() != "" && dc.Rows[0]["p4"].ToString() != null && dc.Rows[0]["p4"].ToString() != "0")
{
//判断是否是在时间段内
DateTime ze = Convert.ToDateTime(dd.Rows[0]["createDate"].ToString());
if (ze.AddDays(int.Parse(dc.Rows[0]["p12"].ToString())) > DateTime.Now)
{
Util.Debuglog("p11" + dc.Rows[0]["p11"].ToString() + ";trxamtY" + trxamtY, "_充值日志.txt");
//并且大于激活下限
if (double.Parse(shouchongMoney) > 0 && double.Parse(dc.Rows[0]["p11"].ToString()) <= trxamtY)
{
//给发红包
string update1 = "update asm_member set AvailableMoney=AvailableMoney+" + shouchongMoney + ",hongbaoF=0 where openID='" + dt.Rows[0]["acct"].ToString() + "'";
Util.Debuglog("充值更新update" + update1, "_充值日志.txt");
DbHelperSQL.ExecuteSql(update1);
dd = DbHelperSQL.Query(sql1).Tables[0];
Util.moneyChange(dd.Rows[0]["id"].ToString(), shouchongMoney, dd.Rows[0]["AvailableMoney"].ToString(), "首冲红包", "7", "");
}
}
}
}
wxHelper wx = new wxHelper(d1.Rows[0]["companyID"].ToString());
string data = TemplateMessage.success_cz(dt.Rows[0]["acct"].ToString(), OperUtil.getMessageID(d1.Rows[0]["companyID"].ToString(), "OPENTM410481462"), "充值成功通知", trxamtY.ToString(), dd.Rows[0]["AvailableMoney"].ToString(), "充值时间:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
TemplateMessage.SendTemplateMsg(wx.IsExistAccess_Token(d1.Rows[0]["companyID"].ToString()), data);
//插入记录
Util.insertNotice(dd.Rows[0]["id"].ToString(), "充值成功通知", "您于" + DateTime.Now.ToString("yyyy/MM/dd HH:mm") + "充值金额:" + trxamtY + ";到账金额:" + dt.Rows[0]["dzMoney"].ToString(), "");
Util.moneyChange(dd.Rows[0]["id"].ToString(), trxamtY.ToString(), dd.Rows[0]["AvailableMoney"].ToString(), "会员充值", "1", "");
Util.moneyChange(dd.Rows[0]["id"].ToString(), trxamtY.ToString(), dd.Rows[0]["point"].ToString(), "积分变动", "5", "");
}
}
}
else
{
Response.Write("error");
return;
}
}
else
{
Response.Write("error");
return;
}
}
public static string save(string memberID, string yzm, string newpwd, string companyID)
{
string sql = "select * from asm_member where id=" + memberID + "";
DataTable dt = DbHelperSQL.Query(sql).Tables[0];
if (dt.Rows.Count <= 0)
{
return("2");
}
string update = "update asm_member set pwd='" + newpwd + "' where id=" + memberID;
int a = DbHelperSQL.ExecuteSql(update);
if (a > 0)
{
try
{
wxHelper wx = new wxHelper(companyID);
string data = TemplateMessage.modify_pwd(dt.Rows[0]["openID"].ToString(), OperUtil.getMessageID(dt.Rows[0]["companyID"].ToString(), "OPENTM406259604"), " 尊敬的会员，您通过手机端修改了【交易密码】", "会员昵称：" + dt.Rows[0]["nickname"].ToString(), "会员姓名：" + dt.Rows[0]["name"].ToString(), "重置密码：1006201");
TemplateMessage.SendTemplateMsg(wx.IsExistAccess_Token(companyID), data);
}
catch {
}
return("1");
}
else
{
return("4");
}
}