/// <summary> /// 删除(返仓单) /// </summary> /// <returns></returns> public ActionResult DeleteWareHert(int sellRetuerID) { string strMsg = "fail"; try { B_WanManifestList conver = (from tbWarHouser in MyModels.B_WanManifestList where tbWarHouser.WanManifestID == sellRetuerID select tbWarHouser).Single(); MyModels.B_WanManifestList.Remove(conver); int waDetialid = (int)conver.WanManifestID; //查询对应对应明细(总数量) var converDetial = (from tbWarHouserDetial in MyModels.B_WanManifestDetailList where tbWarHouserDetial.WanManifestID == waDetialid select tbWarHouserDetial).ToList(); int thyCount = converDetial.Count(); if (thyCount > 0) { for (int i = 0; i < thyCount; i++) { MyModels.B_WanManifestDetailList.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_WanManifestList orderby tbem.Remember select tbem).ToList(); if (listy.Count > 0) { int intcoun = listy.Count; B_WanManifestList mymodell = listy[intcoun - 1]; int inemp = Convert.ToInt32(mymodell.Remember.Substring(1, 8)); inemp++; Std = inemp.ToString(); for (int i = 0; i < 6; i++) { Std = Std.Length < 6 ? "0" + Std : Std; } } else { Std = "000001"; } return(Json(Std, JsonRequestBehavior.AllowGet)); }
public ActionResult ShneheanDan(B_WanManifestList OK, bool state) { ReturnJsonVo returnJson = new ReturnJsonVo(); string strMag = "fali"; try { B_WanManifestList MyB_ConverList = new B_WanManifestList(); MyB_ConverList.WanManifestID = OK.WanManifestID; MyB_ConverList.SellID = OK.SellID; MyB_ConverList.Remember = OK.Remember; MyB_ConverList.PurchaseSectionID = OK.PurchaseSectionID; MyB_ConverList.RegisterName = OK.RegisterName; MyB_ConverList.RegisterTime = OK.RegisterTime; MyB_ConverList.ExamineName = OK.ExamineName; MyB_ConverList.ExamineTime = OK.ExamineTime; MyModels.Entry(MyB_ConverList).State = System.Data.Entity.EntityState.Modified; if (MyModels.SaveChanges() > 0) { strMag = "succsee"; B_WanManifestList wafrtbool = (from tbbool in MyModels.B_WanManifestList where tbbool.WanManifestID == MyB_ConverList.WanManifestID 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 UptoctuFanDan(B_WanManifestList OK, Array JiShangPiID, Array JiRuJianShu, Array JiRuXiShu, Array JieMingXiId) { string strMag = "fali"; try { //一 string Z = ((string[])JiShangPiID)[0]; string[] intsid = Z.Split(','); //二 string M = ((string[])JiRuJianShu)[0]; string[] intsRuJian = M.Split(','); //三 string N = ((string[])JiRuXiShu)[0]; string[] intsNXiShu = N.Split(','); //四 string idd = ((string[])JieMingXiId)[0]; string[] intsNXiShuid = idd.Split(','); B_WanManifestList MyB_ConverList = new B_WanManifestList(); MyB_ConverList.WanManifestID = OK.WanManifestID; MyB_ConverList.SellID = OK.SellID; MyB_ConverList.Remember = OK.Remember; MyB_ConverList.PurchaseSectionID = OK.PurchaseSectionID; MyB_ConverList.RegisterName = OK.RegisterName; MyB_ConverList.RegisterTime = OK.RegisterTime; MyModels.Entry(MyB_ConverList).State = System.Data.Entity.EntityState.Modified; if (MyModels.SaveChanges() > 0) { B_WanManifestDetailList ConverDeTailList = new B_WanManifestDetailList(); for (int H = 0; H < intsNXiShu.Length;) { for (int E = 0; E < intsRuJian.Length;) { for (int d = 0; d < intsid.Length;) { for (int id = 0; id < intsNXiShuid.Length; id++) { ConverDeTailList.WanManifestID = MyB_ConverList.WanManifestID; //要货ID ConverDeTailList.WanManifestDetailID = Convert.ToInt32(intsNXiShuid[id]);; //要货明细ID ConverDeTailList.GoodsID = Convert.ToInt32(intsid[d]);; //商品ID ConverDeTailList.Subdivision = Convert.ToDecimal(intsNXiShu[H]); //入库细数 ConverDeTailList.MumberOfPackages = Convert.ToDecimal(intsRuJian[E]); //入库件数 MyModels.Entry(ConverDeTailList).State = System.Data.Entity.EntityState.Modified; MyModels.SaveChanges(); //保存 strMag = "succsee"; d++; E++; H++; } } } } } } catch (Exception e) { Console.WriteLine(e); } return(Json(strMag, JsonRequestBehavior.AllowGet)); }
public ActionResult InsectPeiZaiDan(B_WanManifestList OK, Array JiShangPiID, Array JiRuJianShu, Array JiRuXiShu) { string strMag = "fali"; try { //一 string Z = ((string[])JiShangPiID)[0]; string[] intsid = Z.Split(','); //二 string M = ((string[])JiRuJianShu)[0]; string[] intsRuJian = M.Split(','); //三 string N = ((string[])JiRuXiShu)[0]; string[] intsNXiShu = N.Split(','); int oldWareHouseRows = (from tb in MyModels.B_WanManifestList where tb.Remember == OK.Remember select tb).Count(); if (oldWareHouseRows == 0) { B_WanManifestList MyB_ConverList = new B_WanManifestList(); MyB_ConverList.SellID = OK.SellID; MyB_ConverList.Remember = OK.Remember; MyB_ConverList.PurchaseSectionID = OK.PurchaseSectionID; MyB_ConverList.RegisterName = OK.RegisterName; MyB_ConverList.RegisterTime = OK.RegisterTime; MyModels.B_WanManifestList.Add(MyB_ConverList); if (MyModels.SaveChanges() > 0) { B_WanManifestDetailList ConverDeTailList = new B_WanManifestDetailList(); for (int H = 0; H < intsNXiShu.Length;) { for (int E = 0; E < intsRuJian.Length;) { for (int d = 0; d < intsid.Length; d++) { ConverDeTailList.WanManifestID = MyB_ConverList.WanManifestID; //要货ID ConverDeTailList.GoodsID = Convert.ToInt32(intsid[d]);; //商品ID ConverDeTailList.Subdivision = Convert.ToDecimal(intsNXiShu[H]); //入库细数 ConverDeTailList.MumberOfPackages = Convert.ToDecimal(intsRuJian[E]); //入库件数 MyModels.B_WanManifestDetailList.Add(ConverDeTailList); MyModels.SaveChanges(); //保存 strMag = "succsee"; E++; H++; } } } } } } catch (Exception e) { Console.WriteLine(e); } return(Json(strMag, JsonRequestBehavior.AllowGet)); }