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));
}
}
