public ActionResult OrderDetail(string ordernum)
{
VIEW_TG_order order = new VIEW_TG_order()
{
orderNum = CommonMethod.GetOrderNum(), trade_type = "ONLINE", orderTime = DateTime.Now, ThingNum = CommonMethod.GetCode(18)
};
ViewBag.ReturnUrl = Request["returnurl"];
ViewBag.TYPE = "Update";
if (string.IsNullOrEmpty(ordernum))
{
ViewBag.TYPE = "Add";
var list = sys_userlogin.LoadListBy(su => su.LOGIN_ID == OperateContext.Current.UsrId).Select(su => su.SLSORG_CD);
ViewBag.MEMBERS = DataSelect.ToListViewModel(VIEW_YX_weiUser.ToListViewModel(userB.GetListBy(u => list.Contains(u.TREE_NODE_ID) && u.isfenxiao != 0, u => u.userRelname)));
ViewBag.COMPANYS = DataSelect.ToListViewModel(VIEW_MST_SUPPLIER.ToListViewModel(supplierB.GetListBy(u => list.Contains(u.TREE_NODE_ID) && u.SYNCOPERATION != "D", u => u.SUPPLIER_ID)));
}
var model = orderB.Get(o => o.orderNum == ordernum);
if (model != null)
{
order = VIEW_TG_order.ToViewModel(model);
ViewBag.Things = VIEW_TG_Thing.ToListViewModel(thingB.GetListBy(t => t.orderNum == ordernum, t => t.createTim, false));
}
return(View(order));
}
public ActionResult ROrderDetail(string orderid)
{
//-----
noncestr = CommonMethod.GetCode(16);
string jsapi_ticket = Js_sdk_Signature.IsExistjsapi_ticket(WeChatConfig.IsExistAccess_Token2());
timestamp = DateTime.Now.Ticks.ToString().Substring(0, 10);;
string url = Request.Url.ToString().Replace("#", "");
JssdkSignature = Js_sdk_Signature.GetjsSDK_Signature(noncestr, jsapi_ticket, timestamp, url);
ViewBag.Appid = WeChatConfig.GetKeyValue("appid");
ViewBag.Uri = WeChatConfig.GetKeyValue("shareurl");
ViewBag.noncestr = noncestr;
ViewBag.jsapi_ticket = jsapi_ticket;
ViewBag.timestamp = timestamp;
ViewBag.PageFlag = "PayOrder";
if (string.IsNullOrEmpty(CommonMethod.getCookie("userid")) || string.IsNullOrEmpty(CommonMethod.getCookie("openid")))
{
return(Content("对不起，请登陆系统！"));
}
var order = orderB.Get(o => o.orderNum == orderid);
if (order == null)
{
return(Content("对不起，这个订单是错误的！"));
}
return(View(VIEW_TG_order.ToViewModel(order)));
}
public MODEL.DataTableModel.DataTableGrid GetOrderForGrid(MODEL.DataTableModel.DataTableRequest request)
{
try
{
var predicate = PredicateBuilder.True <TG_order>();
DateTime time = TypeParser.ToDateTime("1975-1-1");
int total = 0;
var list = IDBSession.ISYS_USERLOGIN_REPOSITORY.LoadListBy(su => su.LOGIN_ID == OperateContext.Current.UsrId).Select(su => su.SLSORG_CD);
var userlist = IDBSession.IYX_weiUser_REPOSITORY.LoadListBy(wu => list.Contains(wu.TREE_NODE_ID)).Select(su => su.userNum);
predicate = predicate.And(o => o.SYNCOPERATION != "D" && userlist.Contains(o.UserId));
var data = base.LoadPagedList(request.PageNumber, request.PageSize, ref total, predicate, request.Model, p => true, request.SortOrder, request.SortName).ToList();//Select(p => VIEW_TG_order.ToViewModel(p));
//var list = ViewModelProduct.ToListViewModel(data);
return(new MODEL.DataTableModel.DataTableGrid()
{
draw = request.Draw,
data = VIEW_TG_order.ToListViewModel(data),
total = total
});
}
catch (Exception)
{
throw;
}
}
public ActionResult ReservationList()
{
ViewBag.PageFlag = "ReservationList";
var status = false;
var userid = CommonMethod.getCookie("userid");
var openid = CommonMethod.getCookie("openid");
if (string.IsNullOrEmpty(userid) || string.IsNullOrEmpty(openid))
{
return(Content("对不起，请登陆系统！"));
}
ViewBag.OrderList = VIEW_TG_order.ToListViewModel(orderB.GetListBy(s => s.UserId == userid && s.userOpenId == openid && s.trade_type == "JSAPI" && s.SYNCOPERATION != "D", o => o.orderTime, false));
return(View());
}
public ActionResult ReservationOrderDetail(string ordernum)
{
VIEW_TG_order order = new VIEW_TG_order();
ViewBag.ReturnUrl = Request["returnurl"];
ViewBag.TYPE = "Update";
if (string.IsNullOrEmpty(ordernum))
{
ViewBag.TYPE = "Add";
}
var model = orderB.Get(o => o.orderNum == ordernum);
if (model != null)
{
order = VIEW_TG_order.ToViewModel(model);
}
return(View(order));
}
public ActionResult PayOrder(string orderid)
{
ViewBag.PageFlag = "PayOrder";
var openid = CommonMethod.getCookie("openid");
var userid = CommonMethod.getCookie("userid");
var user = weiUserM.GetModelWithOutTrace(u => u.userNum == userid && u.openid == openid);
if (user == null)
{
return(Content("对不起，请登陆系统！"));
}
ViewBag.UserType = user.isfenxiao;
ViewBag.userYongJin = user.userYongJin;
ViewBag.Userid = userid;
ViewBag.Openid = openid;
var order = orderB.Get(o => o.orderNum == orderid);
if (order == null)
{
return(Content("对不起，这个订单是错误的！"));
}
//-----
noncestr = CommonMethod.GetCode(16);
string jsapi_ticket = Js_sdk_Signature.IsExistjsapi_ticket(WeChatConfig.IsExistAccess_Token2());
timestamp = DateTime.Now.Ticks.ToString().Substring(0, 10);;
string url = Request.Url.ToString().Replace("#", "");
JssdkSignature = Js_sdk_Signature.GetjsSDK_Signature(noncestr, jsapi_ticket, timestamp, url);
ViewBag.Appid = WeChatConfig.GetKeyValue("appid");
ViewBag.Uri = WeChatConfig.GetKeyValue("shareurl");
ViewBag.noncestr = noncestr;
ViewBag.jsapi_ticket = jsapi_ticket;
ViewBag.timestamp = timestamp;
//微信支付代码
//
//httpContext
var packageReqHandler = new RequestHandler(HttpContext);
packageReqHandler.Init();
//时间戳
payTimeSamp = Senparc.Weixin.MP.TenPayLibV3.TenPayV3Util.GetTimestamp();
//随机字符串
sj = CommonMethod.GetCode(16) + "_" + userid;
//设置参数
packageReqHandler.SetParameter("body", "商城-购买支付"); //商品信息 127字符
packageReqHandler.SetParameter("appid", PayConfig.AppId);
packageReqHandler.SetParameter("mch_id", PayConfig.MchId);
packageReqHandler.SetParameter("nonce_str", sj);
packageReqHandler.SetParameter("notify_url", PayConfig.NotifyUrl);
packageReqHandler.SetParameter("openid", openid);
packageReqHandler.SetParameter("out_trade_no", orderid + "_" + CommonMethod.GetCode(4)); //商家订单号
packageReqHandler.SetParameter("spbill_create_ip", Request.UserHostAddress); //用户的公网ip，不是商户服务器IP
packageReqHandler.SetParameter("total_fee", (Convert.ToDouble(order.yunPrice) * 100).ToString()); //商品金额,以分为单位(money * 100).ToString()
packageReqHandler.SetParameter("trade_type", "JSAPI");
packageReqHandler.SetParameter("attach", CommonMethod.GetCode(28)); //自定义参数 127字符
string sign = packageReqHandler.CreateMd5Sign("key", PayConfig.AppKey); //第一次签名结果
#region 获取package包======================
packageReqHandler.SetParameter("sign", sign);
string data = packageReqHandler.ParseXML();//支付发送的数据 XML格式
string prepayXml = Senparc.Weixin.MP.AdvancedAPIs.TenPayV3.Unifiedorder(data);
//string prepayXml = WeiXin.GetPage("https://api.mch.weixin.qq.com/pay/unifiedorder", data);
var xdoc = new XmlDocument();
xdoc.LoadXml(prepayXml);
XmlNode xn = xdoc.SelectSingleNode("xml");
LogHelper.WriteLog(prepayXml);
try
{
string PrepayId = WeChatConfig.GetXMLstrByKey("prepay_id", xdoc);
Package = string.Format("prepay_id={0}", PrepayId);
LogHelper.WriteLog(Package);
}
catch (Exception ex)
{
LogHelper.WriteLog(ex.ToString());
Package = string.Format("prepay_id={0}", "");
}
#endregion
#region 设置支付参数 输出页面 该部分参数请勿随意修改 ==============
var paySignReqHandler = new RequestHandler(HttpContext);
paySignReqHandler.SetParameter("appId", PayConfig.AppId);
paySignReqHandler.SetParameter("timeStamp", payTimeSamp);
paySignReqHandler.SetParameter("nonceStr", sj);
paySignReqHandler.SetParameter("package", Package);
paySignReqHandler.SetParameter("signType", "MD5");
PaySign = paySignReqHandler.CreateMd5Sign("key", PayConfig.AppKey);
#endregion
//--------END
ViewBag.payTimeSamp = payTimeSamp;
ViewBag.sj = sj;
ViewBag.Package = Package;
ViewBag.PaySign = PaySign;
return(View(VIEW_TG_order.ToViewModel(order)));
}
public ActionResult SubmitOrder()
{
var status = false;
var openid = CommonMethod.getCookie("openid");
var userid = CommonMethod.getCookie("userid");
if (string.IsNullOrEmpty(userid) || string.IsNullOrEmpty(openid))
{
return(this.JsonFormat(status, status, "对不起，请登陆系统！"));
}
string orderNum = CommonMethod.GetOrderNum(); //订单号
string ThingNum = Request.Form["thingNum"]; //CommonMethod.GetCode(18);//流水号;
string thingName = Request.Form["thingName"];
string sid = Request.Form["sid"];
string suppliername = Request.Form["suppliername"];
string uname = Request.Form["uname"];
string mobile = Request.Form["mobile"];
string currentselectdate = Request.Form["selectdate"];
string currentselecttime = Request.Form["selecttime"];
string thingPrice = Request.Form["thingPrice"]; //总金额
string thingFrontPrice = Request.Form["thingFrontPrice"]; //预付
string supplieraddress = Request.Form["supplieraddress"]; //地址Id
string trade_type = "JSAPI";
var order = new VIEW_TG_order();
order.orderNum = orderNum;
order.ThingNum = ThingNum;
order.remark1 = thingName;
order.userOpenId = openid;
order.UserId = userid;
order.userName = uname;
order.UserTel = mobile;
order.UserAddress = supplieraddress;
order.remark2 = suppliername;
order.remark3 = sid;
order.total_fee = TypeParser.ToDecimal(thingPrice);
order.yunPrice = TypeParser.ToDecimal(thingFrontPrice);
order.remark4 = currentselectdate;
order.remark5 = currentselecttime;
order.trade_type = trade_type;
order.years = DateTime.Now.Year;
order.months = DateTime.Now.Month;
order.ispay = 0;
order.ssh_status = 0;
order.orderTime = DateTime.Now;
order.SYNCFLAG = "N";
order.SYNCOPERATION = "A";
order.SYNCVERSION = DateTime.Now;
order.VERSION = 1;
orderB.Add(VIEW_TG_order.ToEntity(order));
status = true;
var user = weiUserM.GetModelWithOutTrace(u => u.openid == openid);
if (user != null)
{
user.RelName = uname;
user.userTel = mobile;
weiUserM.Modify(user, "RelName", "userTel");
}
// string order_sql = "insert into TG_order(flat2,trade_type,orderNum,ThingNum,total_fee,yunPrice,fenxiaoId,UserId,userOpenId,userName,UserTel,UserAddress,UserPostNum,orderTime,remark4,ispay,years,months) values(" + zengsongJifen + ",'" + trade_type + "','" + orderNum + "','" + ThingNum + "'," + total_fee + "," + YunFei + "," + fenxiaoId + "," + userid + ",'" + openid + "','" + userName + "','" + UserTel + "','" + UserAddress + "','" + UserPostNum + "','" + DateTime.Now + "','" + remark4 + "',0," + DateTime.Now.Year + "," + DateTime.Now.Month + ")";
//string thing_sql = "insert into TG_Thing(UserId,openId,ThingNum,orderNum,productId,productCount,productPrice,productMoney,createTim,ispay,remark4) values(" + userid + ",'" + openid + "','" + ThingNum + "','" + orderNum + "'," + pid + "," + productCount + "," + proprice + "," + (productCount * proprice) + ",'" + DateTime.Now + "',0,'" + proColor + "')";
//string car_sql = "delete from TG_car where Pid=" + pid + " and (UserOpenId='" + openid + "' or UserId=" + userid + ")";
return(this.JsonFormat(status, status, "/aoshacar/payorder.aspx?orderid=" + orderNum));
}
public ActionResult Add(VIEW_TG_order model)
{
bool status = false;
if (!ModelState.IsValid)
{
return(this.JsonFormat(ModelState, status, "ERROR"));
}
if (model.total_fee <= 0)
{
return(this.JsonFormat("SYSERROR", status, "订单的金额不正确"));
}
try
{
var user = userB.Get(u => u.userNum == model.UserId);
if (user != null)
{
model.userName = user.userRelname;
model.userOpenId = user.openid;
model.UserTel = user.userTel;
}
var supplierid = TypeParser.ToInt32(model.remark3);
var company = supplierB.Get(u => u.SUPPLIER_ID == supplierid);
if (company != null)
{
model.remark2 = company.SUPPLIER_NAME;
model.UserAddress = company.ADDRESS;
}
List <VIEW_TG_Thing> things = new List <VIEW_TG_Thing>();
string[] productID = Request.Form.GetValues("productID");
string[] productName = Request.Form.GetValues("productName");
string[] productCount = Request.Form.GetValues("productCount");
string[] productPrice = Request.Form.GetValues("productPrice");
string[] productMoney = Request.Form.GetValues("productMoney");
if (productID != null)
{
for (int i = 0; i < productID.Length; i++)
{
VIEW_TG_Thing item = new VIEW_TG_Thing();
item.orderNum = model.orderNum;
item.ispay = model.ispay;
item.ThingNum = model.ThingNum;
item.UserId = model.UserId;
item.openId = model.userOpenId;
item.productId = productID[i];
item.remark1 = productName[i];
item.productCount = TypeParser.ToInt32(productCount[i]);
item.productPrice = TypeParser.ToDecimal(productPrice[i]);
item.productMoney = TypeParser.ToDecimal(productMoney[i]);
item.createTim = DateTime.Now;
things.Add(item);
}
}
model.ispay = 0;
model.ssh_status = 0;
model.orderTime = DateTime.Now;
model.SYNCFLAG = "N";
model.SYNCOPERATION = "A";
model.SYNCVERSION = DateTime.Now;
model.VERSION = 1;
orderB.Add(VIEW_TG_order.ToEntity(model));
foreach (var item in things)
{
thingB.Add(VIEW_TG_Thing.ToEntity(item));
}
status = true;
}
catch (Exception e)
{
return(this.JsonFormat(status, status, SysOperate.Add));
}
return(this.JsonFormat("/Admin/Order/OrderDetail?ordernum=" + model.orderNum, status, SysOperate.Add.ToMessage(status), status));
}
public ActionResult FinishOrder(VIEW_TG_order model)
{
var order = orderB.GetModelWithOutTrace(o => o.orderNum == model.orderNum);
bool status = false;
try
{
var user = userB.GetModelWithOutTrace(u => u.userNum == order.UserId);
if (Request["ONLINE"] != null && order != null && user != null)
{
if (model.total_fee <= 0)
{
return(this.JsonFormat("SYSERROR", status, "订单的金额不正确"));
}
if (user.userYongJin < model.total_fee)
{
return(this.JsonFormat("SYSERROR", status, "用户的余额不足"));
}
else if (order.ispay < 3)
{
order.total_fee = model.total_fee;
order.yunPrice = model.yunPrice;
order.ispay = 3;
order.ssh_status = 3;
order.payTime = DateTime.Now;
order.remark5 = model.remark5;
order.remark6 = model.remark6;
orderB.Modify(order, "total_fee", "yunPrice", "ispay", "ssh_status", "payTime", "remark5", "remark6");
user.userYongJin = user.userYongJin - order.total_fee;
userB.Modify(user, "userYongJin");
//添加交易记录
TG_transactionLog transactionlog = new TG_transactionLog();
transactionlog.userId = user.userNum;
transactionlog.openid = user.openid;
transactionlog.tranCate = 0;
transactionlog.CateName = "到店消费";
transactionlog.tranMoney = order.total_fee;
transactionlog.tranContent = "到店消费(订单号:" + order.orderNum + ")消费:" + order.total_fee + " 元";
transactionlog.orderNum = order.orderNum;
transactionlog.remark4 = "1003";
transactionlog.AddTime = DateTime.Now;
transactionlogB.Add(transactionlog);
if (model.IsNotice)
{
Common.Tools.GetPage("https://api.weixin.qq.com/cgi-bin/message/custom/send?access_token=" + WeChatConfig.IsExistAccess_Token2(), WeChatConfig.GetSubcribePostData(user.openid, transactionlog.tranContent));
}
status = true;
}
else
{
status = true;
return(this.JsonFormat("/Admin/Order/OrderDetail?ordernum=" + model.orderNum, status, "该订单已经支付了！", true, "SYSSUCCESS"));
}
}
}
catch (Exception ex)
{
return(this.JsonFormat(status, !status, ex.Message + ex.StackTrace));
}
return(this.JsonFormat("/Admin/Order/OrderDetail?ordernum=" + model.orderNum, status, "支付成功！", true, "SYSSUCCESS"));
}
public bool DownOrder(VIEW_TG_order order)
{
throw new NotImplementedException();
}
