public JsonResult ViewListJPWDelete(int id = 0) { using (TransactionScope sc = new TransactionScope()) { try { T_ManualOrder model = db.T_ManualOrder.Find(id); db.T_ManualOrder.Remove(model); db.SaveChanges(); List <T_ManualorderDetail> list = db.T_ManualorderDetail.Where(a => a.OrderCode.Equals(model.platform_code)).ToList(); foreach (var deleteItem in list) { db.T_ManualorderDetail.Remove(deleteItem); } db.SaveChanges(); sc.Complete(); return(Json(new { State = "Success" }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { State = "Faile", Message = ex.Message }, JsonRequestBehavior.AllowGet)); } } }
public JsonResult Approve(int id) { T_ManualOrder order = new T_ManualOrder(); order = db.T_ManualOrder.Find(id); if (order != null) { try { using (TransactionScope sc = new TransactionScope()) { order.orderstatus = 1; db.SaveChanges(); //详情 IQueryable <T_ManualorderDetail> details = null; details = db.T_ManualorderDetail.Where(a => a.OrderCode.Equals(order.platform_code)); //构造商品明细 string detail = ""; foreach (var item in details) { detail += "{\"qty\":" + item.qty + ",\"price\":\"" + item.price + "\",\"note\":\"\",\"refund\":0,\"item_code\":\"" + System.Web.HttpContext.Current.Server.UrlEncode(item.item_code) + "\"}"; } //构造付款信息 必须要付款信息 否则全让利了 应收成0 string payment = ""; //discount_fee 让利直接给出 无效 此字段改成实收金额 payment += "{\"pay_type_code\":\"wangyin\",\"payment\":\"" + order.payment + "\"}"; GY gy = new GY(); string cmd = ""; cmd = "{" + "\"appkey\":\"171736\"," + "\"method\":\"gy.erp.trade.add\"," + "\"sessionkey\":\"f5885504d9c84d1d8146200a4841f4b7\"," + "\"order_type_code\":\"" + order.order_type_code + "\"," + "\"platform_code\":\"" + order.platform_code + "\"," + "\"shop_code\":\"" + order.shop_code + "\"," + "\"express_code\":\"" + order.express_code + "\"," + "\"receiver_province\":\"" + order.receiver_province + "\"," + "\"receiver_city\":\"" + order.receiver_city + "\"," + "\"receiver_district\":\"" + order.receiver_district + "\"," + "\"warehouse_code\":\"" + order.warehouse_code + "\"," + "\"vip_code\":\"" + order.vip_code + "\"," + "\"vip_name\":\"" + order.vip_name + "\"," + "\"receiver_name\":\"" + order.receiver_name + "\"," + "\"receiver_address\":\"" + order.receiver_address + "\"," + "\"receiver_mobile\":\"" + order.receiver_mobile + "\"," + "\"receiver_phone\":\"" + order.receiver_phone + "\"," + "\"deal_datetime\":\"" + order.deal_datetime.ToString() + "\"," + "\"pay_datetime\":\"" + order.deal_datetime.ToString() + "\"," + "\"buyer_memo\":\"" + order.buyer_memo + "\"," + "\"seller_memo\":\"" + order.seller_memo + "\"," + "\"business_man_code\":\"" + order.business_man_code + "\"," + "\"payments\":[" + payment + "]," + //payment 支付金额 设置了也无效 应该是根据明细里面的单价 自动算出来的 "\"details\":[" + detail + "]" + "}"; string sign = gy.Sign(cmd); string comcode = "{" + "\"appkey\":\"171736\"," + "\"method\":\"gy.erp.trade.add\"," + "\"sessionkey\":\"f5885504d9c84d1d8146200a4841f4b7\"," + "\"order_type_code\":\"" + order.order_type_code + "\"," + "\"platform_code\":\"" + order.platform_code + "\"," + "\"shop_code\":\"" + order.shop_code + "\"," + "\"express_code\":\"" + order.express_code + "\"," + "\"receiver_province\":\"" + order.receiver_province + "\"," + "\"receiver_city\":\"" + order.receiver_city + "\"," + "\"receiver_district\":\"" + order.receiver_district + "\"," + "\"warehouse_code\":\"" + order.warehouse_code + "\"," + "\"vip_code\":\"" + order.vip_code + "\"," + "\"vip_name\":\"" + order.vip_name + "\"," + "\"receiver_name\":\"" + order.receiver_name + "\"," + "\"receiver_address\":\"" + order.receiver_address + "\"," + "\"receiver_mobile\":\"" + order.receiver_mobile + "\"," + "\"receiver_phone\":\"" + order.receiver_phone + "\"," + "\"deal_datetime\":\"" + order.deal_datetime.ToString() + "\"," + "\"pay_datetime\":\"" + order.deal_datetime.ToString() + "\"," + "\"sign\":\"" + sign + "\"," + "\"buyer_memo\":\"" + order.buyer_memo + "\"," + "\"seller_memo\":\"" + order.seller_memo + "\"," + "\"business_man_code\":\"" + order.business_man_code + "\"," + "\"payments\":[" + payment + "]," + "\"details\":[" + detail + "]" + "}"; string ret = gy.DoPost("http://api.guanyierp.com/rest/erp_open", comcode); JsonData jsonData = null; jsonData = JsonMapper.ToObject(ret); string result = jsonData[0].ToString(); if (result == "True") { sc.Complete(); return(Json(new { State = "Success" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { State = "Faile", Message = "数据有误,请联系管理员" }, JsonRequestBehavior.AllowGet)); } } } catch (Exception ex) { return(Json(new { State = "Faile", Message = ex.Message }, JsonRequestBehavior.AllowGet)); } } else { return(Json(new { State = "Faile", Message = "数据出错,请联系技术人员" }, JsonRequestBehavior.AllowGet)); } }