/// <summary> /// 记录编号 /// </summary> /// <returns></returns> public ActionResult getEmpCode() { string Std = ""; var listy = (from tbem in myModels.B_WareHouseList orderby tbem.Remember select tbem).ToList(); if (listy.Count > 0) { int intcoun = listy.Count; B_WareHouseList mymodell = listy[intcoun - 1]; int inemp = Convert.ToInt32(mymodell.Remember.Substring(1, 8)); inemp++; Std = inemp.ToString(); for (int i = 0; i < 8; i++) { Std = Std.Length < 8 ? "0" + Std : Std; } } else { Std = "00000001"; } return(Json(Std, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 删除进仓单 /// </summary> /// <returns></returns> public ActionResult DeleteWareHert(int WarHouserid) { string strMsg = "fail"; try { B_WareHouseList WarHouser = (from tbWarHouser in myModels.B_WareHouseList where tbWarHouser.WareHouseID == WarHouserid select tbWarHouser).Single(); myModels.B_WareHouseList.Remove(WarHouser); int waDetialid = (int)WarHouser.WareHouseID; //查询对应对应明细(总数量) var WarHouserDetial = (from tbWarHouserDetial in myModels.B_WareHouseDetiailList where tbWarHouserDetial.WareHouseID == waDetialid select tbWarHouserDetial).ToList(); int thyCount = WarHouserDetial.Count(); if (thyCount > 0) { for (int i = 0; i < thyCount; i++) { myModels.B_WareHouseDetiailList.Remove(WarHouserDetial[i]); myModels.SaveChanges(); strMsg = "success"; } } } catch (Exception e) { Console.WriteLine(e); } return(Json(strMsg, JsonRequestBehavior.AllowGet)); }
/// <summary> ///冲红状态(bit)(二)原来的 单号 /// </summary> public ActionResult UpdateExamineNot(int WarHouserid, bool state) { //添加(这个类(bit 类型类)) ReturnJsonVo returnJson = new ReturnJsonVo(); try { B_WareHouseList wafrtbool = (from tbbool in myModels.B_WareHouseList where tbbool.WareHouseID == WarHouserid select tbbool).Single(); //查询原状态 wafrtbool.CrushRedNot = state; //改变是否为冲红单状态 myModels.Entry(wafrtbool).State = EntityState.Modified; if (myModels.SaveChanges() > 0)//保存 { returnJson.State = true; returnJson.Text = "修改成功"; } else { returnJson.State = false; returnJson.Text = "修改失败"; } } catch (Exception e) { Console.WriteLine(e); returnJson.State = false; returnJson.Text = "数据异常"; } return(Json(returnJson, JsonRequestBehavior.AllowGet)); }
public ActionResult ShenHeWareHouss(bool state) { string strMag = "fali"; ReturnJsonVo returnJson = new ReturnJsonVo(); try { B_WareHouseList WareHouse = new B_WareHouseList(); WareHouse.WareHouseID = Convert.ToInt32(Request.Form["WareHouseID"]); //进仓单ID WareHouse.QuFenLeiXingID = Convert.ToInt32(Request.Form["QuFenLeiXingID"]); //进仓类型ID WareHouse.Remember = Request.Form["Remember"]; //记录编号 WareHouse.SpouseBRanchID = Convert.ToInt32(Request.Form["SpouseBRanchID"]); //进货部门 WareHouse.OrderFormPactID = Convert.ToInt32(Request.Form["OrderFormPactID"]); //合同ID WareHouse.StockPlaceID = Convert.ToInt32(Request.Form["StockPlaceID"]); //库存地点 WareHouse.Appendix = Request.Form["Appendix"]; //附件张数 WareHouse.StaffID = Convert.ToInt32(Request.Form["StaffID"]); //收货人 WareHouse.RegisterName = Request.Form["RegisterName"]; //登记人 WareHouse.RegisterTime = Convert.ToDateTime(Request.Form["RegisterTime"]); //登记时间 WareHouse.ExamineName = Request.Form["ExamineName"]; //审核人 WareHouse.ExamineTime = Convert.ToDateTime(Request.Form["ExamineTime"]); //审核时间 myModels.Entry(WareHouse).State = System.Data.Entity.EntityState.Modified; myModels.SaveChanges(); if (WareHouse.WareHouseID > 0) { B_WareHouseList wafrtbool = (from tbbool in myModels.B_WareHouseList where tbbool.WareHouseID == WareHouse.WareHouseID select tbbool).Single(); //查询原状态 wafrtbool.ExamineNot = state; //改变审核 myModels.Entry(wafrtbool).State = EntityState.Modified; B_WareHouseList wafrtboodl = (from tbbool in myModels.B_WareHouseList where tbbool.WareHouseID == WareHouse.WareHouseID select tbbool).Single(); //查询原状态 wafrtboodl.Status = state; //改变生效 myModels.Entry(wafrtboodl).State = EntityState.Modified; if (myModels.SaveChanges() > 0)//保存 { returnJson.State = true; returnJson.Text = "修改成功"; } else { returnJson.State = false; returnJson.Text = "修改失败"; } } return(Json("success", JsonRequestBehavior.AllowGet)); } catch (Exception e) { Console.WriteLine(e); } return(Json(new { strMag, returnJson }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 点击填写审核信息(一) /// </summary> /// <param name="WareHouse"></param> /// <param name="WarHouserid"></param> /// <param name="state"></param> /// <returns></returns> public ActionResult ShenHeCiDan(B_WareHouseList WareHouse, bool state) { ReturnJsonVo returnJson = new ReturnJsonVo(); string strMag = "fali"; try { WareHouse.QuFenLeiXingID = Convert.ToInt32(Request.Form["QuFenLeiXingID"]); //进仓类型ID WareHouse.WareHouseID = Convert.ToInt32(Request.Form["WareHouseID"]); //进仓单ID WareHouse.Remember = Request.Form["Remember"]; //记录编号 WareHouse.SpouseBRanchID = Convert.ToInt32(Request.Form["SpouseBRanchID"]); //进货部门 WareHouse.OrderFormID = Convert.ToInt32(Request.Form["OrdernFromIDs"]); //订单ID WareHouse.OrderFormPactID = Convert.ToInt32(Request.Form["OrderFormPactID"]); //合同ID WareHouse.StockPlaceID = Convert.ToInt32(Request.Form["StockPlaceID"]); //库存地点 WareHouse.StaffID = Convert.ToInt32(Request.Form["StaffID"]); //收货人 WareHouse.RegisterTime = Convert.ToDateTime(Request.Form["RegisterTime"]); //登记时间 WareHouse.RegisterName = Request.Form["RegisterName"]; //登记人 WareHouse.ExamineName = Request.Form["ExamineName"]; //审核人 WareHouse.ExamineTime = Convert.ToDateTime(Request.Form["ExamineTime"]); //审核时间 myModels.Entry(WareHouse).State = System.Data.Entity.EntityState.Modified; myModels.SaveChanges(); if (WareHouse.WareHouseID > 0) { B_WareHouseList wafrtbool = (from tbbool in myModels.B_WareHouseList where tbbool.WareHouseID == WareHouse.WareHouseID select tbbool).Single(); //查询原状态 wafrtbool.HoveNot = state; //改变是否为有订单 myModels.Entry(wafrtbool).State = EntityState.Modified; //EntityState (生成 using) 这句代码意思把它进行修改 if (myModels.SaveChanges() > 0) //保存 { returnJson.State = true; returnJson.Text = "修改成功"; } else { returnJson.State = false; returnJson.Text = "修改失败"; } } } catch (Exception e) { Console.WriteLine(e); } return(Json(new { strMag, returnJson }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 删除进仓单 /// </summary> /// <returns></returns> public ActionResult DeleteWareHert(int WarHouserid, bool state) { ReturnJsonVo returnJson = new ReturnJsonVo(); string strMsg = "fail"; try { var linq = (from tbWarHouser in myModels.B_WareHouseList where tbWarHouser.WareHouseID == WarHouserid select new LY.WareHouseDeitaLL { OrdernFromIDs = tbWarHouser.OrderFormID }).ToList(); Session["OrdernFromIDsgh"] = linq[0].OrdernFromIDs;//订单ID int OrdernFromIDid = Convert.ToInt32(Session["OrdernFromIDsgh"]); B_WareHouseList WarHouser = (from tbWarHouser in myModels.B_WareHouseList where tbWarHouser.WareHouseID == WarHouserid select tbWarHouser).Single(); myModels.B_WareHouseList.Remove(WarHouser); int waDetialid = (int)WarHouser.WareHouseID; //查询对应对应明细(总数量) var WarHouserDetial = (from tbWarHouserDetial in myModels.B_WareHouseDetiailList where tbWarHouserDetial.WareHouseID == waDetialid select tbWarHouserDetial).ToList(); int thyCount = WarHouserDetial.Count(); if (thyCount > 0) { for (int i = 0; i < thyCount; i++) { myModels.B_WareHouseDetiailList.Remove(WarHouserDetial[i]); myModels.SaveChanges(); strMsg = "success"; B_OrderFormList wafrtbool = (from tbbool in myModels.B_OrderFormList where tbbool.OrderFormID == OrdernFromIDid select tbbool).Single(); //查询原状态 wafrtbool.ShiFouShouHuo = state; //改变是否为收货状态 myModels.Entry(wafrtbool).State = EntityState.Modified; if (myModels.SaveChanges() > 0)//保存 { returnJson.State = false; returnJson.Text = "修改成功"; } else { returnJson.State = true; returnJson.Text = "修改失败"; } } } } catch (Exception e) { Console.WriteLine(e); } return(Json(new { strMsg, returnJson }, JsonRequestBehavior.AllowGet)); }
public ActionResult UptaleJingCangDan(Array JieShouMingXiID, Array JieShouID, Array JieShouJianShu, Array JieShouRuKuXiShu, bool state) { string strMag = "fali"; ReturnJsonVo returnJson = new ReturnJsonVo(); //声明字符串接收“数组的信息” //一(订单明细ID) string Z = ((string[])JieShouID)[0]; string[] intsZ = Z.Split(',');//剪切出来 //二(入库件数) string M = ((string[])JieShouJianShu)[0]; string[] intsM = M.Split(','); //三(入库细数) string N = ((string[])JieShouRuKuXiShu)[0]; string[] intsN = N.Split(','); //四(进仓明细ID) string V = ((string[])JieShouMingXiID)[0]; string[] intsV = V.Split(',');//剪切出来 try { B_WareHouseList WareHouse = new B_WareHouseList(); WareHouse.QuFenLeiXingID = Convert.ToInt32(Request.Form["QuFenLeiXingID"]); //进仓类型ID WareHouse.WareHouseID = Convert.ToInt32(Request.Form["WareHouseID"]); //进仓单ID WareHouse.Remember = Request.Form["Remember"]; //记录编号 WareHouse.SpouseBRanchID = Convert.ToInt32(Request.Form["SpouseBRanchID"]); //进货部门 WareHouse.OrderFormID = Convert.ToInt32(Request.Form["OrdernFromIDs"]); //订单ID WareHouse.OrderFormPactID = Convert.ToInt32(Request.Form["OrderFormPactID"]); //合同ID WareHouse.StockPlaceID = Convert.ToInt32(Request.Form["StockPlaceID"]); //库存地点 WareHouse.StaffID = Convert.ToInt32(Request.Form["StaffID"]); //收货人 WareHouse.RegisterTime = Convert.ToDateTime(Request.Form["RegisterTime"]); //登记时间 WareHouse.RegisterName = Request.Form["RegisterName"]; //登记人 myModels.Entry(WareHouse).State = System.Data.Entity.EntityState.Modified; myModels.SaveChanges(); if (WareHouse.WareHouseID > 0) { var ling = (from tbWarHreDiell in myModels.B_WareHouseDetiailList where tbWarHreDiell.WareHouseID == WareHouse.WareHouseID select tbWarHreDiell).Count(); if (ling > 0) { if (V.Length > 0) { for (int H = 0; H < intsN.Length;) { for (int E = 0; E < intsM.Length;) { for (int d = 0; d < intsZ.Length; d++) { for (int m = 0; m < intsV.Length; m++) { B_WareHouseDetiailList WareHouseDetial = new B_WareHouseDetiailList(); WareHouseDetial.WareHouseDetiailID = Convert.ToInt32(intsV[m]); //进仓单明细ID WareHouseDetial.WareHouseID = Convert.ToInt32(Request.Form["WareHouseID"]); //进仓单ID WareHouseDetial.OrderFormDetailID = Convert.ToInt32(intsZ[d]); //订单明细ID WareHouseDetial.Subdivision = Convert.ToDecimal(intsN[H]); //入库细数 WareHouseDetial.MumberOfPackages = Convert.ToDecimal(intsM[E]); //入库件数 WareHouseDetial.YuanMumberOfPack = Convert.ToDecimal(intsN[H]); //入库细数 WareHouseDetial.YuanSubdivision = Convert.ToDecimal(intsM[E]); //入库件数 myModels.Entry(WareHouseDetial).State = System.Data.Entity.EntityState.Modified; myModels.SaveChanges();//保存 strMag = "succsse"; H++; E++; d++; } } } } } B_WareHouseList wafrtbool = (from tbbool in myModels.B_WareHouseList where tbbool.WareHouseID == WareHouse.WareHouseID select tbbool).Single(); //查询原状态 wafrtbool.HoveNot = state; //改变是否为冲红单状态 myModels.Entry(wafrtbool).State = EntityState.Modified; //EntityState (生成 using) 这句代码意思把它进行修改 if (myModels.SaveChanges() > 0) //保存 { returnJson.State = true; returnJson.Text = "修改成功"; } else { returnJson.State = false; returnJson.Text = "修改失败"; } } else { } } } catch (Exception e) { Console.WriteLine(e); } return(Json(new { strMag, returnJson }, JsonRequestBehavior.AllowGet)); }
public ActionResult InsectJingCangDan(B_WareHouseList WareHouse, Array JieShouID, Array JieShouJianShu, Array JieShouRuKuXiShu, bool state) { string strMag = "fali"; ReturnJsonVo returnJson = new ReturnJsonVo(); try { //一 string Z = ((string[])JieShouID)[0]; string[] intsZ = Z.Split(','); //二 string M = ((string[])JieShouJianShu)[0]; string[] intsM = M.Split(','); //三 string N = ((string[])JieShouRuKuXiShu)[0]; string[] intsN = N.Split(','); //判断记录编号是否存在 int oldWareHouseRows = (from tbWareHouse in myModels.B_WareHouseList where tbWareHouse.Remember == WareHouse.Remember select tbWareHouse).Count(); if (oldWareHouseRows == 0) { WareHouse.QuFenLeiXingID = Convert.ToInt32(Request.Form["QuFenLeiXingID"]); //进仓类型ID WareHouse.Remember = Request.Form["Remember"]; //记录编号 WareHouse.SpouseBRanchID = Convert.ToInt32(Request.Form["SpouseBRanchID"]); //进货部门 WareHouse.OrderFormID = Convert.ToInt32(Request.Form["OrdernFromIDs"]); //订单ID WareHouse.OrderFormPactID = Convert.ToInt32(Request.Form["OrderFormPactID"]); //合同ID WareHouse.StockPlaceID = Convert.ToInt32(Request.Form["StockPlaceID"]); //库存地点 WareHouse.StaffID = Convert.ToInt32(Request.Form["StaffID"]); //收货人 WareHouse.RegisterTime = Convert.ToDateTime(Request.Form["RegisterTime"]); //登记时间 WareHouse.RegisterName = Request.Form["RegisterName"]; //登记人 if (WareHouse.OrderFormID > 0 && WareHouse.SpouseBRanchID > 0 && WareHouse.StockPlaceID > 0 && WareHouse.StaffID > 0 && WareHouse.RegisterName != null && WareHouse.RegisterTime != null) { myModels.B_WareHouseList.Add(WareHouse); myModels.SaveChanges(); B_OrderFormList wafrtbool = (from tbbool in myModels.B_OrderFormList where tbbool.OrderFormID == WareHouse.OrderFormID select tbbool).Single(); //查询原状态 wafrtbool.ShiFouShouHuo = state; //改变是否为收货状态 myModels.Entry(wafrtbool).State = EntityState.Modified; myModels.SaveChanges(); B_WareHouseList wafrtboolWa = (from tbbool in myModels.B_WareHouseList where tbbool.WareHouseID == WareHouse.WareHouseID select tbbool).Single(); //查询原状态 wafrtboolWa.HoveNot = state; //有无订单 myModels.Entry(wafrtboolWa).State = EntityState.Modified; //EntityState (生成 using) 这句代码意思把它进行修改 if (myModels.SaveChanges() > 0) //保存 { returnJson.State = true; returnJson.Text = "修改成功"; } else { returnJson.State = false; returnJson.Text = "修改失败"; } B_WareHouseDetiailList WareHouseDetiail = new B_WareHouseDetiailList(); for (int H = 0; H < intsN.Length;) { for (int E = 0; E < intsM.Length;) { for (int d = 0; d < intsZ.Length; d++) { WareHouseDetiail.WareHouseID = WareHouse.WareHouseID; //进货单ID WareHouseDetiail.OrderFormDetailID = Convert.ToInt32(intsZ[d]);; //订单明细ID WareHouseDetiail.Subdivision = Convert.ToDecimal(intsN[H]); //入库细数 WareHouseDetiail.MumberOfPackages = Convert.ToDecimal(intsM[E]); //入库件数 WareHouseDetiail.YuanMumberOfPack = Convert.ToDecimal(intsN[H]); //原入库细数 WareHouseDetiail.YuanSubdivision = Convert.ToDecimal(intsM[E]); //原入库件数 myModels.B_WareHouseDetiailList.Add(WareHouseDetiail); myModels.SaveChanges();//保存 E++; H++; strMag = "succsse"; } } } } else { return(Json(strMag, JsonRequestBehavior.AllowGet)); } } } catch (Exception e) { Console.WriteLine(e); } return(Json(new { strMag, returnJson }, JsonRequestBehavior.AllowGet)); }
public ActionResult ChongHongWareHouss(Array JieShouID, Array JieShouJianShu, Array JieShouRuKuXiShu, bool state) { //一 string Z = ((string[])JieShouID)[0]; string[] intsZ = Z.Split(','); //二 string M = ((string[])JieShouJianShu)[0]; string[] intsM = M.Split(','); //三 string N = ((string[])JieShouRuKuXiShu)[0]; string[] intsN = N.Split(','); string strMag = "fali"; ReturnJsonVo returnJson = new ReturnJsonVo(); try { B_WareHouseList WareHouse = new B_WareHouseList(); WareHouse.QuFenLeiXingID = Convert.ToInt32(Request.Form["QuFenLeiXingID"]); //进仓类型ID WareHouse.Remember = Request.Form["Remember"]; //记录编号 WareHouse.SpouseBRanchID = Convert.ToInt32(Request.Form["SpouseBRanchID"]); //进货部门 WareHouse.OrderFormPactID = Convert.ToInt32(Request.Form["OrderFormPactID"]); //合同ID WareHouse.StockPlaceID = Convert.ToInt32(Request.Form["StockPlaceID"]); //库存地点 WareHouse.Appendix = Request.Form["Appendix"]; //附件张数 WareHouse.Evidences = Request.Form["Evidences"]; //原始单号 WareHouse.StaffID = Convert.ToInt32(Request.Form["StaffID"]); //收货人ID WareHouse.RegisterName = Request.Form["RegisterName"]; //登记人 WareHouse.RegisterTime = Convert.ToDateTime(Request.Form["RegisterTime"]); //登记时间 WareHouse.ExamineName = Request.Form["ExamineName"]; //审核人 WareHouse.ExamineTime = Convert.ToDateTime(Request.Form["ExamineTime"]); //审核时间 myModels.B_WareHouseList.Add(WareHouse); myModels.SaveChanges(); if (WareHouse.WareHouseID > 0) { B_WareHouseDetiailList WareHouseDetiail = new B_WareHouseDetiailList(); for (int H = 0; H < intsN.Length;) { for (int E = 0; E < intsM.Length;) { for (int d = 0; d < intsZ.Length; d++) { WareHouseDetiail.WareHouseID = WareHouse.WareHouseID; //进货单ID WareHouseDetiail.OrderFormDetailID = Convert.ToInt32(intsZ[d]);; //商品ID WareHouseDetiail.Subdivision = Convert.ToDecimal(intsN[H]); //入库细数 WareHouseDetiail.MumberOfPackages = Convert.ToDecimal(intsM[E]); //入库件数 myModels.B_WareHouseDetiailList.Add(WareHouseDetiail); myModels.SaveChanges(); //保存 H++; E++; } } } B_WareHouseList wafrtbool = (from tbbool in myModels.B_WareHouseList where tbbool.WareHouseID == WareHouse.WareHouseID select tbbool).Single(); //查询原状态 wafrtbool.ExamineNot = state; //改变审核 myModels.Entry(wafrtbool).State = EntityState.Modified; B_WareHouseList wafrtboodl = (from tbbool in myModels.B_WareHouseList where tbbool.WareHouseID == WareHouse.WareHouseID select tbbool).Single(); //查询原状态 wafrtboodl.Status = state; //改变生效 myModels.Entry(wafrtboodl).State = EntityState.Modified; B_WareHouseList wafrtboosdl = (from tbbool in myModels.B_WareHouseList where tbbool.WareHouseID == WareHouse.WareHouseID select tbbool).Single(); //查询原状态 wafrtboosdl.CrushRedNot = state; //改变冲红 myModels.Entry(wafrtboosdl).State = EntityState.Modified; if (myModels.SaveChanges() > 0)//保存 { returnJson.State = true; returnJson.Text = "修改成功"; } else { returnJson.State = false; returnJson.Text = "修改失败"; } strMag = "success"; } //return Json("success", JsonRequestBehavior.AllowGet); } catch (Exception e) { Console.WriteLine(e); } return(Json(new { strMag, returnJson }, JsonRequestBehavior.AllowGet)); }
public ActionResult UptaleJingCangDan(Array JieShouMingXiID, Array JieShouID, Array JieShouJianShu, Array JieShouRuKuXiShu) { string strMag = "fali"; //一(订单明细ID) string Z = ((string[])JieShouID)[0]; string[] intsZ = Z.Split(','); //二(入库件数) string M = ((string[])JieShouJianShu)[0]; string[] intsM = M.Split(','); //三(入库细数) string N = ((string[])JieShouRuKuXiShu)[0]; string[] intsN = N.Split(','); //四(进仓明细ID) string V = ((string[])JieShouMingXiID)[0]; string[] intsV = V.Split(','); try { B_WareHouseList WareHouse = new B_WareHouseList(); WareHouse.WareHouseID = Convert.ToInt32(Request.Form["WareHouseID"]); //进仓单ID WareHouse.QuFenLeiXingID = Convert.ToInt32(Request.Form["QuFenLeiXingID"]); //进仓类型ID WareHouse.Remember = Request.Form["Remember"]; //记录编号 WareHouse.SpouseBRanchID = Convert.ToInt32(Request.Form["SpouseBRanchID"]); //进货部门 WareHouse.OrderFormPactID = Convert.ToInt32(Request.Form["OrderFormPactID"]); //合同ID WareHouse.StockPlaceID = Convert.ToInt32(Request.Form["StockPlaceID"]); //库存地点 WareHouse.Appendix = Request.Form["Appendix"]; //附件张数 WareHouse.StaffID = Convert.ToInt32(Request.Form["StaffID"]); //收货人 WareHouse.RegisterName = Request.Form["RegisterName"]; //登记人 WareHouse.RegisterTime = Convert.ToDateTime(Request.Form["RegisterTime"]); //登记时间 myModels.Entry(WareHouse).State = System.Data.Entity.EntityState.Modified; myModels.SaveChanges(); if (WareHouse.WareHouseID > 0) { var ling = (from tbWarHreDiell in myModels.B_WareHouseDetiailList where tbWarHreDiell.WareHouseID == WareHouse.WareHouseID select tbWarHreDiell).Count(); if (ling > 0) { if (V.Length > 0) { for (int H = 0; H < intsN.Length;) { for (int E = 0; E < intsM.Length;) { for (int d = 0; d < intsZ.Length; d++) { for (int m = 0; m < intsV.Length; m++) { B_WareHouseDetiailList WareHouseDetial = new B_WareHouseDetiailList(); WareHouseDetial.WareHouseDetiailID = Convert.ToInt32(intsV[m]); //进仓单明细ID WareHouseDetial.WareHouseID = Convert.ToInt32(Request.Form["WareHouseID"]); //进仓单ID WareHouseDetial.OrderFormDetailID = Convert.ToInt32(intsZ[d]); //商品ID WareHouseDetial.Subdivision = Convert.ToDecimal(intsN[H]); //入库细数 WareHouseDetial.MumberOfPackages = Convert.ToDecimal(intsM[E]); //入库件数 myModels.Entry(WareHouseDetial).State = System.Data.Entity.EntityState.Modified; myModels.SaveChanges();//保存 H++; E++; d++; } } } } } return(Json("sussec", JsonRequestBehavior.AllowGet)); } else { } } } catch (Exception e) { Console.WriteLine(e); } return(Json(strMag, JsonRequestBehavior.AllowGet)); }
public ActionResult InsectJingCangDan(B_WareHouseList WareHouse, Array JieShouID, Array JieShouJianShu, Array JieShouRuKuXiShu) { string strMag = "fali"; //添加(这个类(bit 类型类)) ReturnJsonVo returnJson = new ReturnJsonVo(); try { //一 string Z = ((string[])JieShouID)[0]; string[] intsZ = Z.Split(','); //二 string M = ((string[])JieShouJianShu)[0]; string[] intsM = M.Split(','); //三 string N = ((string[])JieShouRuKuXiShu)[0]; string[] intsN = N.Split(','); //判断记录编号是否存在 int oldWareHouseRows = (from tbWareHouse in myModels.B_WareHouseList where tbWareHouse.Remember == WareHouse.Remember select tbWareHouse).Count(); if (oldWareHouseRows == 0) { WareHouse.QuFenLeiXingID = Convert.ToInt32(Request.Form["QuFenLeiXingID"]); //进仓类型ID WareHouse.Remember = Request.Form["Remember"]; //记录编号 WareHouse.SpouseBRanchID = Convert.ToInt32(Request.Form["SpouseBRanchID"]); //进货部门(采购) WareHouse.OrderFormPactID = Convert.ToInt32(Request.Form["OrderFormPactID"]); //合同ID WareHouse.StockPlaceID = Convert.ToInt32(Request.Form["StockPlaceID"]); //库存地点(销售部门) WareHouse.Appendix = Request.Form["Appendix"]; //附件张数 WareHouse.StaffID = Convert.ToInt32(Request.Form["StaffID"]); //收货人 WareHouse.RegisterName = Request.Form["RegisterName"]; //登记人 WareHouse.RegisterTime = Convert.ToDateTime(Request.Form["RegisterTime"]); //登记时间 if (WareHouse.QuFenLeiXingID > 0 && WareHouse.SpouseBRanchID > 0 && WareHouse.StockPlaceID > 0 && WareHouse.StaffID > 0 && WareHouse.RegisterName != null && WareHouse.RegisterTime != null && WareHouse.OrderFormPactID > 0) { myModels.B_WareHouseList.Add(WareHouse); myModels.SaveChanges(); B_WareHouseDetiailList WareHouseDetiail = new B_WareHouseDetiailList(); for (int H = 0; H < intsN.Length;) { for (int E = 0; E < intsM.Length;) { for (int d = 0; d < intsZ.Length; d++) { WareHouseDetiail.WareHouseID = WareHouse.WareHouseID; //进货单ID WareHouseDetiail.OrderFormDetailID = Convert.ToInt32(intsZ[d]);; //订单明细ID WareHouseDetiail.Subdivision = Convert.ToDecimal(intsN[H]); //入库细数 WareHouseDetiail.MumberOfPackages = Convert.ToDecimal(intsM[E]); //入库件数 myModels.B_WareHouseDetiailList.Add(WareHouseDetiail); myModels.SaveChanges(); //保存 E++; H++; } } } } else { return(Json("fali", JsonRequestBehavior.AllowGet)); } } } catch (Exception e) { Console.WriteLine(e); } return(Json(strMag, JsonRequestBehavior.AllowGet)); }
public ActionResult InsectJingCangDan(B_WareHouseList WareHouse, Array JieShouID, Array JieShouJianShu, Array JieShouRuKuXiShu, bool state) { string strMag = "fali"; //添加(这个类(bit 类型类)) ReturnJsonVo returnJson = new ReturnJsonVo(); try { //声明字符串接收“数组的信息” //一 string Z = ((string[])JieShouID)[0]; string[] intsZ = Z.Split(',');//剪切出来 //二 string M = ((string[])JieShouJianShu)[0]; string[] intsM = M.Split(','); //三 string N = ((string[])JieShouRuKuXiShu)[0]; string[] intsN = N.Split(','); //判断记录编号是否存在 int oldWareHouseRows = (from tbWareHouse in myModels.B_WareHouseList where tbWareHouse.Remember == WareHouse.Remember select tbWareHouse).Count(); if (oldWareHouseRows == 0) { WareHouse.QuFenLeiXingID = Convert.ToInt32(Request.Form["QuFenLeiXingID"]); //进仓类型ID WareHouse.Remember = Request.Form["CrRemember"]; //记录编号 WareHouse.SpouseBRanchID = Convert.ToInt32(Request.Form["SpouseBRanchID"]); //进货部门 WareHouse.OrderFormID = Convert.ToInt32(Request.Form["OrdernFromIDs"]); //订单ID WareHouse.OrderFormPactID = Convert.ToInt32(Request.Form["OrderFormPactID"]); //合同ID WareHouse.StockPlaceID = Convert.ToInt32(Request.Form["StockPlaceID"]); //库存地点 WareHouse.StaffID = Convert.ToInt32(Request.Form["StaffID"]); //收货人 WareHouse.RegisterTime = Convert.ToDateTime(Request.Form["RegisterTime"]); //登记时间 WareHouse.RegisterName = Request.Form["RegisterName"]; //登记人 WareHouse.ExamineName = Request.Form["ExamineName"]; //审核人 WareHouse.ExamineTime = Convert.ToDateTime(Request.Form["ExamineTime"]); //审核时间 WareHouse.Appendix = Request.Form["Appendix"]; //附件 WareHouse.Evidences = Request.Form["Evidences"]; //原始单号 if (WareHouse.OrderFormID > 0 && WareHouse.SpouseBRanchID > 0 && WareHouse.StockPlaceID > 0 && WareHouse.StaffID > 0 && WareHouse.RegisterName != null && WareHouse.RegisterTime != null && WareHouse.ExamineName != null && WareHouse.ExamineTime != null) { myModels.B_WareHouseList.Add(WareHouse); myModels.SaveChanges(); if (WareHouse.WareHouseID > 0) { B_WareHouseDetiailList WareHouseDetiail = new B_WareHouseDetiailList(); for (int H = 0; H < intsN.Length;) { for (int E = 0; E < intsM.Length;) { for (int d = 0; d < intsZ.Length; d++) { WareHouseDetiail.WareHouseID = WareHouse.WareHouseID; //进货单ID WareHouseDetiail.OrderFormDetailID = Convert.ToInt32(intsZ[d]);; //订单明细ID WareHouseDetiail.Subdivision = Convert.ToDecimal(intsN[H]); //入库细数 WareHouseDetiail.MumberOfPackages = Convert.ToDecimal(intsM[E]); //入库件数 myModels.B_WareHouseDetiailList.Add(WareHouseDetiail); myModels.SaveChanges(); //保存 H++; E++; } } } B_WareHouseList wafrtbool = (from tbbool in myModels.B_WareHouseList where tbbool.WareHouseID == WareHouse.WareHouseID select tbbool).Single(); //查询原状态 wafrtbool.CrushRedNot = state; //改变是否为冲红单状态 myModels.Entry(wafrtbool).State = EntityState.Modified; B_WareHouseList wafrtboodl = (from tbbool in myModels.B_WareHouseList where tbbool.WareHouseID == WareHouse.WareHouseID select tbbool).Single(); //查询原状态 wafrtboodl.ExamineNot = state; //改变审核状态 myModels.Entry(wafrtboodl).State = EntityState.Modified; B_WareHouseList wafrtboole = (from tbbool in myModels.B_WareHouseList where tbbool.WareHouseID == WareHouse.WareHouseID select tbbool).Single(); //查询原状态 wafrtboole.Status = state; //改变生效状态 myModels.Entry(wafrtboole).State = EntityState.Modified; B_WareHouseList wafrtboojgfle = (from tbbool in myModels.B_WareHouseList where tbbool.WareHouseID == WareHouse.WareHouseID select tbbool).Single(); //查询原状态 wafrtboojgfle.HoveNot = state; //改变是否订单 myModels.Entry(wafrtboojgfle).State = EntityState.Modified; if (myModels.SaveChanges() > 0)//保存 { returnJson.State = true; returnJson.Text = "修改成功"; } else { returnJson.State = false; returnJson.Text = "修改失败"; } } } else { return(Json("fail", JsonRequestBehavior.AllowGet)); } } } catch (Exception e) { Console.WriteLine(e); } return(Json(new { strMag, returnJson }, JsonRequestBehavior.AllowGet)); }