/// <summary> /// 删除(反厂单) /// </summary> /// <returns></returns> public ActionResult DeleteWareHert(int retureFactoryID) { string strMsg = "fail"; try { B_RetureFactoryList conver = (from tbWarHouser in MyModels.B_RetureFactoryList where tbWarHouser.RetureFactoryID == retureFactoryID select tbWarHouser).Single(); MyModels.B_RetureFactoryList.Remove(conver); int waDetialid = (int)conver.RetureFactoryID; //查询对应对应明细(总数量) var converDetial = (from tbWarHouserDetial in MyModels.B_RetureFactoryDeTailList where tbWarHouserDetial.RetureFactoryID == waDetialid select tbWarHouserDetial).ToList(); int thyCount = converDetial.Count(); if (thyCount > 0) { for (int i = 0; i < thyCount; i++) { MyModels.B_RetureFactoryDeTailList.Remove(converDetial[i]); MyModels.SaveChanges(); strMsg = "success"; } } } catch (Exception e) { Console.WriteLine(e); } return(Json(strMsg, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 记录编号 /// </summary> /// <returns></returns> public ActionResult getEmpCodef() { string Std = ""; var listy = (from tbem in MyModels.B_RetureFactoryList orderby tbem.Remember select tbem).ToList(); if (listy.Count > 0) { int intcoun = listy.Count; B_RetureFactoryList 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)); }
public ActionResult ShenHePeiZaiDan(B_RetureFactoryList OK, bool state) { ReturnJsonVo returnJson = new ReturnJsonVo(); string strMag = "fali"; try { B_RetureFactoryList MyB_ConverList = new B_RetureFactoryList(); MyB_ConverList.RetureFactoryID = OK.RetureFactoryID; MyB_ConverList.ConverID = OK.ConverID; MyB_ConverList.Remember = OK.Remember; MyB_ConverList.SpouseBRanchID = OK.SpouseBRanchID; MyB_ConverList.StockPlaceID = OK.StockPlaceID; MyB_ConverList.ReturnofID = OK.ReturnofID; MyB_ConverList.Settlement = OK.Settlement; MyB_ConverList.Appendix = OK.Appendix; MyB_ConverList.Evidences = OK.Evidences; MyB_ConverList.RegisterName = OK.RegisterName; MyB_ConverList.RegisterTime = OK.RegisterTime; MyB_ConverList.ExamineName = OK.ExamineName; MyB_ConverList.ExamineTime = OK.ExamineTime; MyB_ConverList.MumberOfPackages = OK.MumberOfPackages; MyB_ConverList.Number = OK.Number; MyModels.Entry(MyB_ConverList).State = System.Data.Entity.EntityState.Modified; if (MyModels.SaveChanges() > 0) { strMag = "succsee"; B_RetureFactoryList wafrtbool = (from tbbool in MyModels.B_RetureFactoryList where tbbool.RetureFactoryID == MyB_ConverList.RetureFactoryID select tbbool).Single(); //查询原状态 wafrtbool.ExamineNot = 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); } return(Json(new { strMag, returnJson }, JsonRequestBehavior.AllowGet)); }
public ActionResult UptuarPeiZaiDan(B_RetureFactoryList OK, Array JiShangPiID, Array JiRuJianShu, Array FanChangJieID) { string strMag = "fali"; try { //一 string Z = ((string[])JiShangPiID)[0]; string[] intsid = Z.Split(','); //二 string M = ((string[])JiRuJianShu)[0]; string[] intsRuJian = M.Split(','); //二 string X = ((string[])FanChangJieID)[0]; string[] intsFanChangMingXiID = X.Split(','); B_RetureFactoryList MyB_ConverList = new B_RetureFactoryList(); MyB_ConverList.RetureFactoryID = OK.RetureFactoryID; MyB_ConverList.ConverID = OK.ConverID; MyB_ConverList.Remember = OK.Remember; MyB_ConverList.SpouseBRanchID = OK.SpouseBRanchID; MyB_ConverList.StockPlaceID = OK.StockPlaceID; MyB_ConverList.ReturnofID = OK.ReturnofID; MyB_ConverList.Settlement = OK.Settlement; MyB_ConverList.Appendix = OK.Appendix; MyB_ConverList.Evidences = OK.Evidences; MyB_ConverList.RegisterName = OK.RegisterName; MyB_ConverList.RegisterTime = OK.RegisterTime; MyB_ConverList.MumberOfPackages = OK.MumberOfPackages; MyB_ConverList.Number = OK.Number; MyModels.Entry(MyB_ConverList).State = System.Data.Entity.EntityState.Modified; if (MyModels.SaveChanges() > 0) { strMag = "succsee"; B_RetureFactoryDeTailList ConverDeTailList = new B_RetureFactoryDeTailList(); for (int E = 0; E < intsRuJian.Length;) { for (int d = 0; d < intsid.Length; d++) { for (int Mf = 0; Mf < intsFanChangMingXiID.Length; Mf++) { ConverDeTailList.RetureFactoryID = MyB_ConverList.RetureFactoryID; //返厂单ID ConverDeTailList.RetureFactoryDeTailID = Convert.ToInt32(intsFanChangMingXiID[Mf]);; //返厂明细ID ConverDeTailList.GoodsID = Convert.ToInt32(intsid[d]);; //商品ID ConverDeTailList.ReMumberOfPackages = Convert.ToDecimal(intsRuJian[E]); //入库件数 MyModels.Entry(ConverDeTailList).State = System.Data.Entity.EntityState.Modified; MyModels.SaveChanges(); //保存 d++; E++; } } } } } catch (Exception e) { Console.WriteLine(e); } return(Json(strMag, JsonRequestBehavior.AllowGet)); }
public ActionResult InsectPeiZaiDan(B_RetureFactoryList OK, Array JiShangPiID, Array JiRuJianShu) { string strMag = "fali"; try { //一 string Z = ((string[])JiShangPiID)[0]; string[] intsid = Z.Split(','); //二 string M = ((string[])JiRuJianShu)[0]; string[] intsRuJian = M.Split(','); //判断记录编号是否存在 int oldWareHouseRows = (from tb in MyModels.B_RetureFactoryList where tb.Remember == OK.Remember select tb).Count(); if (oldWareHouseRows == 0) { B_RetureFactoryList MyB_ConverList = new B_RetureFactoryList(); MyB_ConverList.ConverID = OK.ConverID; MyB_ConverList.Remember = OK.Remember; MyB_ConverList.SpouseBRanchID = OK.SpouseBRanchID; MyB_ConverList.StockPlaceID = OK.StockPlaceID; MyB_ConverList.ReturnofID = OK.ReturnofID; MyB_ConverList.Settlement = OK.Settlement; MyB_ConverList.Appendix = OK.Appendix; MyB_ConverList.Evidences = OK.Evidences; MyB_ConverList.RegisterName = OK.RegisterName; MyB_ConverList.RegisterTime = OK.RegisterTime; MyB_ConverList.MumberOfPackages = OK.MumberOfPackages; MyB_ConverList.Number = OK.Number; MyModels.B_RetureFactoryList.Add(MyB_ConverList); if (MyModels.SaveChanges() > 0) { strMag = "succsee"; B_RetureFactoryDeTailList ConverDeTailList = new B_RetureFactoryDeTailList(); for (int E = 0; E < intsRuJian.Length;) { for (int d = 0; d < intsid.Length; d++) { ConverDeTailList.RetureFactoryID = MyB_ConverList.RetureFactoryID; //进货单ID ConverDeTailList.GoodsID = Convert.ToInt32(intsid[d]);; //商品ID ConverDeTailList.ReMumberOfPackages = Convert.ToDecimal(intsRuJian[E]); //入库件数 MyModels.B_RetureFactoryDeTailList.Add(ConverDeTailList); MyModels.SaveChanges();//保存 E++; } } } } } catch (Exception e) { Console.WriteLine(e); } return(Json(strMag, JsonRequestBehavior.AllowGet)); }