public static object createOr(string id, string trxID)
{
string sql = "select * from asm_order where id in (" + id + ") and fkzt=0";
DataTable ds = DbHelperSQL.Query(sql).Tables[0];
if (ds.Rows.Count > 0)
{
if (ds.Rows[0]["yhfs"].ToString().Contains("赠送"))
{
string num = ds.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 in(" + id + ")";
DbHelperSQL.ExecuteSql(update);
}
else
{
string update = "update asm_order set fkzt=1,trxID='" + trxID + "' where id in(" + id + ")";
DbHelperSQL.ExecuteSql(update);
}
ds = DbHelperSQL.Query(sql).Tables[0];
for (int j = 0; j < ds.Rows.Count; j++)
{
string[] selDate = insertIntoOrderDetail(ds.Rows[j]["psfs"].ToString(), ds.Rows[j]["psStr"].ToString(), ds.Rows[j]["totalNum"].ToString(), ds.Rows[j]["qsDate"].ToString()).Split(',');
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"] = ds.Rows[j]["mechineID"].ToString(); //通过索引赋值
dr["productID"] = ds.Rows[j]["productID"].ToString();
dr["createTime"] = delTime(selDate[i]); //
dr["code"] = code; //
dr["memberID"] = ds.Rows[j]["memberID"].ToString(); //通过索引赋值
dr["zt"] = "5";
dr["ldNO"] = ""; //
dr["orderNO"] = ds.Rows[j]["orderNO"].ToString(); //
dr["statu"] = "0"; //通过索引赋值
dr["sellPrice"] = 0.0;
dr["sellTime"] = "";
dr["bz"] = "";
dtNew.Rows.Add(dr);
}
DbHelperSQL.BatchInsertBySqlBulkCopy(dtNew, "[dbo].[asm_orderDetail]");
}
}
}
return(new { code = 0, msg = "订单支付完成" });
}
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 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());
}
}
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 * from asm_pay_info where trxid='" + jo["trxid"].ToString() + "'";
DataTable dt = DbHelperSQL.Query(sql).Tables[0];
if (dt.Rows.Count > 0)
{
//获取openid查询这个openid的companyID 的appkey
string sql1 = "select * from asm_member where openID='" + dt.Rows[0]["acct"].ToString() + "'";
DataTable d1 = DbHelperSQL.Query(sql1).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())
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;
//支付成功向asm_pay 表 更新记录
string updateSQL = "update asm_pay_info set paytime='" + paytime + "',statu='1',trxdate='" + trxdate + "',chnltrxid='" + chnltrxid + "' where trxid='" + jo["trxid"].ToString() + "'";
DbHelperSQL.ExecuteSql(updateSQL);
//需要更新会员的消费信息
string update = "update asm_member set sumConsume=sumConsume+" + trxamtY + ",LastTime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' where openID='" + acct + "'";
DbHelperSQL.ExecuteSql(update);
// 插入订单明细 根据trxid查询
string sqlO = "select * from asm_order where trxID='" + jo["trxid"].ToString() + "'";
Util.Debuglog("sqlO=" + sqlO, "_11.txt");
DataTable d12 = DbHelperSQL.Query(sqlO).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 update1 = "update asm_order set fkzt=1,trxID='" + jo["trxid"].ToString() + "',totalNum=totalNum+" + num + ",syNum=syNum+" + num + " where id=" + d12.Rows[0]["id"].ToString();
DbHelperSQL.ExecuteSql(update1);
}
else
{
string update1 = "update asm_order set fkzt=1,trxID='" + jo["trxid"].ToString() + "' where id=" + d12.Rows[0]["id"].ToString();
DbHelperSQL.ExecuteSql(update1);
}
//更新状态
}
if (1 == 1)
{
d12 = DbHelperSQL.Query(sqlO).Tables[0];
//更新商品销售数量
string ss = "update asm_product set ljxs=CONVERT(float,ISNULL(ljxs,0))+1 where productID=" + d12.Rows[0]["productID"].ToString();
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"] = d12.Rows[0]["mechineID"].ToString(); //通过索引赋值
dr["productID"] = d12.Rows[0]["productID"].ToString();
dr["createTime"] = delTime(selDate[i]); //
dr["code"] = code; //
dr["memberID"] = d12.Rows[0]["memberID"].ToString(); //通过索引赋值
dr["zt"] = "5";
dr["ldNO"] = ""; //
dr["orderNO"] = d12.Rows[0]["orderNO"].ToString(); //
dr["statu"] = "0"; //通过索引赋值
dr["sellPrice"] = 0.0;
dr["sellTime"] = "";
dr["bz"] = "";
dtNew.Rows.Add(dr);
}
DbHelperSQL.BatchInsertBySqlBulkCopy(dtNew, "[dbo].[asm_orderDetail]");
}
}
}
else
{
Response.Write("error");
return;
}
}
else
{
Response.Write("error");
return;
}
}
}
