// 删除订单
public JsonResult DelOrder(string db, string ccode, string flag)
{
var jsonResult = new JsonResult();
jsonResult.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
jsonResult.Data = 6;
using (kw_m01Context kw_m01 = new kw_m01Context())
{
if (flag == "1")
{
var erp_corder = kw_m01.v_corder.Find(db, ccode);
if (erp_corder.CMTFLAG == "0")
{
try
{
int rs = kw_m01.sp_erp_corder(1, db, ccode, "clear", o, o, o, o, o, o, o);
jsonResult.Data = "success";
}
catch (Exception ex)
{
new SaveError(ex, o, o, o, o, o, o, o);
}
}
}
else
{
var cordercs = from c in kw_m01.M_CORDERC
where (c.cquotid == db) && (c.CCODE == ccode)
select c;
var tempOrder = kw_m01.M_CORDER.Find(ccode, db);
var customer = kw_m01.M_CUSTOMER.Find(tempOrder.CCUSTID, db);
if (tempOrder.CMTFLAG == "0")
{
kw_m01.M_CORDER.Remove(tempOrder);
kw_m01.M_CORDERC.RemoveRange(cordercs);
kw_m01.M_CUSTOMER.Remove(customer);
kw_m01.SaveChanges();
jsonResult.Data = "success";
}
}
}
return(jsonResult);
}
// 保存订单
public JsonResult SaveOrder(string customerJson, string corderJson, string cordercsJson, string flag)
{
var jsonResult = new JsonResult();
jsonResult.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
// 反序列化 单头单身
JavaScriptSerializer js = new JavaScriptSerializer();
var customer = js.Deserialize <M_CUSTOMER>(customerJson);
var corder = js.Deserialize <M_CORDER>(corderJson);
var cordercs = js.Deserialize <List <M_CORDERC> >(cordercsJson);
Debug.Assert(customer != null, "customer 为null！");
Debug.Assert(corder != null, "corder 为null！");
// 访问数据库
//TransactionScope scope = new TransactionScope()
using (kw_m01Context kw_m01 = new kw_m01Context())
{
var dels = from s in kw_m01.M_CORDERC
where s.CCODE == corder.CCODE &&
s.cquotid == corder.cpathid
select s;
// 操作数据库
kw_m01.M_CORDER.AddOrUpdate(corder);
kw_m01.M_CUSTOMER.AddOrUpdate(customer);
kw_m01.M_CORDERC.RemoveRange(dels);
if (cordercs.Count != 0)
{
kw_m01.M_CORDERC.AddRange(cordercs);
}
if (flag == "1")
{
var erp_order = kw_m01.v_corder.Find(corder.cpathid, corder.CCODE);
if (erp_order.CMTFLAG == "0")
{
try
{
kw_m01.SaveChanges();
kw_m01.sp_erp_corder(1, corder.cpathid, corder.CCODE, o, o, o, o, o, o, o, o);
kw_m01.p_ins_custid_no(customer.cdeareaid, customer.CCUSTID);
kw_m01.sp_ins_erp_corder(corder.cpathid, corder.CCODE);
jsonResult.Data = "success";
}
catch (Exception ex)
{
new SaveError(ex, o, o, o, o, o, "db:" + corder.cpathid, "客户订单号:" + corder.CCODE);
}
}
}
else
{
var tempOrder = kw_m01.M_CORDER.Find(corder.CCODE, corder.cpathid);
if (tempOrder.CMTFLAG == "0")
{
kw_m01.SaveChanges();
jsonResult.Data = "success";
}
}
}
return(jsonResult);
}
