/// <summary> /// 删除未审核订单 /// </summary> /// <param name="orderFormId"></param> /// <returns></returns> public ActionResult DeleteOrderForm(int orderFormId) { //定义返回 string strMsg = "fail"; try { B_OrderFormList dbGoods = (from tbOrderForm in MyModels.B_OrderFormList where tbOrderForm.OrderFormID == orderFormId where tbOrderForm.ConsigneeNot == false select tbOrderForm).Single(); MyModels.B_OrderFormList.Remove(dbGoods); if (MyModels.SaveChanges() > 0) { B_OrderFormDetailList dbGoodsDetail = (from tbOrderFormDetail in MyModels.B_OrderFormDetailList where tbOrderFormDetail.OrderFormID == orderFormId select tbOrderFormDetail).Single(); MyModels.B_OrderFormDetailList.Remove(dbGoodsDetail); if (MyModels.SaveChanges() > 0) { strMsg = "success"; } } } catch (Exception e) { Console.WriteLine(e); } return(Json(strMsg, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 修改保存 /// </summary> /// <returns></returns> public ActionResult DingDanXiuGaiBaoCun() { string styMy = "fail"; try { B_OrderFormList KK = new B_OrderFormList(); KK.OrderFormID = Convert.ToInt32(Request.Form["OrderFormID"]); KK.OrderNumber = Request.Form["OrderNumber"]; KK.OrderFormPactID = Convert.ToInt32(Request.Form["OrderFormPactID"]); KK.SpouseBRanchID = Convert.ToInt32(Request.Form["SpouseBRanchID"]); KK.OrderGoodsData = Convert.ToDateTime(Request.Form["OrderGoodsData"]); KK.Place = Request.Form["Place"]; KK.DeliveryFashion = Request.Form["DeliveryFashion"]; KK.Value = Convert.ToDecimal(Request.Form["Value"]); KK.ExpensesOTtaxation = Convert.ToDecimal(Request.Form["ExpensesOTtaxation"]); KK.ValueTotal = Convert.ToDecimal(Request.Form["ValueTotal"]); KK.OrderFormTypeID = Convert.ToInt32(Request.Form["OrderFormTypeID"]); KK.Register = Request.Form["Register"]; KK.RegisterTime = Convert.ToDateTime(Request.Form["RegisterTime"]); KK.CheckRen = Request.Form["CheckRen"]; KK.Checktime = Convert.ToDateTime(Request.Form["Checktime"]); KK.ConsigneeNot = Convert.ToBoolean(Request.Form["ConsigneeNot"]); MyModels.Entry(KK).State = System.Data.Entity.EntityState.Modified; MyModels.SaveChanges(); B_OrderFormDetailList JJ = new B_OrderFormDetailList(); JJ.OrderFormID = KK.OrderFormID; JJ.OrderFormDetailID = Convert.ToInt32(Request.Form["OrderFormDetailID"]); JJ.GoodsID = Convert.ToInt32(Request.Form["GoodsID"]); JJ.MumberOfPackages = Convert.ToDecimal(Request.Form["MumberOfPackages"]); JJ.Subdivision = Convert.ToDecimal(Request.Form["Subdivision"]); JJ.Quantity = Request.Form["Quantity"]; JJ.Remarks = Request.Form["Remarks"]; MyModels.Entry(JJ).State = System.Data.Entity.EntityState.Modified; MyModels.SaveChanges(); styMy = "success"; } catch (Exception e) { Console.WriteLine(e); } return(Json(styMy, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 新增保存 /// </summary> /// <param name="pwOrderForm"></param> /// <returns></returns> public ActionResult XinZengDingDanXinXi(B_OrderFormList pwOrderForm) { string strMsg = "fali"; try { //判断数据是否已经存在 int oldOrderFormRows = (from tbGoodsMoneyRule in MyModels.B_OrderFormList where tbGoodsMoneyRule.OrderNumber == pwOrderForm.OrderNumber select tbGoodsMoneyRule).Count(); if (oldOrderFormRows == 0) { try { B_OrderFormList Dep = new B_OrderFormList(); Dep.OrderNumber = Request.Form["OrderNumber"]; Dep.OrderFormPactID = Convert.ToInt32(Request.Form["OrderFormPactID"]); Dep.SpouseBRanchID = Convert.ToInt32(Request.Form["SpouseBRanchID"]); Dep.OrderGoodsData = Convert.ToDateTime(Request.Form["OrderGoodsData"]); Dep.Place = Request.Form["Place"]; Dep.DeliveryFashion = Request.Form["DeliveryFashion"]; Dep.Value = Convert.ToDecimal(Request.Form["Value"]); Dep.ExpensesOTtaxation = Convert.ToDecimal(Request.Form["ExpensesOTtaxation"]); Dep.ValueTotal = Convert.ToDecimal(Request.Form["ValueTotal"]); Dep.OrderFormTypeID = Convert.ToInt32(Request.Form["OrderFormTypeID"]); Dep.Register = Request.Form["Register"]; Dep.RegisterTime = Convert.ToDateTime(Request.Form["RegisterTime"]); Dep.CheckRen = Request.Form["CheckRen"]; Dep.Checktime = Convert.ToDateTime(Request.Form["Checktime"]); Dep.ConsigneeNot = Convert.ToBoolean(Request.Form["ConsigneeNot"]); if (Dep.OrderNumber != null && Dep.SpouseBRanchID != null && Dep.OrderGoodsData != null && Dep.OrderFormPactID != null && Dep.Place != null && Dep.DeliveryFashion != null && Dep.Value != null && Dep.ExpensesOTtaxation != null && Dep.ValueTotal != null && Dep.OrderFormTypeID != null && Dep.Register != null && Dep.RegisterTime != null && Dep.CheckRen != null && Dep.Checktime != null) { MyModels.B_OrderFormList.Add(Dep); MyModels.SaveChanges(); B_OrderFormDetailList KK = new B_OrderFormDetailList(); KK.OrderFormID = Dep.OrderFormID; KK.GoodsID = Convert.ToInt32(Request.Form["GoodsID"]); KK.MumberOfPackages = Convert.ToDecimal(Request.Form["MumberOfPackages"]); KK.Subdivision = Convert.ToDecimal(Request.Form["Subdivision"]); KK.Quantity = Request.Form["Quantity"]; KK.Remarks = Request.Form["Remarks"]; if (KK.OrderFormID != null && KK.GoodsID != null && KK.MumberOfPackages != null && KK.Subdivision != null && KK.Quantity != null && KK.Remarks != null) { MyModels.B_OrderFormDetailList.Add(KK); MyModels.SaveChanges(); strMsg = "success"; } } } catch (Exception) { return(Json(strMsg, JsonRequestBehavior.AllowGet)); } } else { strMsg = "exsit"; } } catch (Exception e) { Console.WriteLine(e); } return(Json(strMsg, JsonRequestBehavior.AllowGet)); }