/// <summary> /// 删除(返仓单) /// </summary> /// <returns></returns> public ActionResult DeleteWareHert(int sellRetuerID) { string strMsg = "fail"; try { B_SellRetuerList conver = (from tbWarHouser in MyModels.B_SellRetuerList where tbWarHouser.SellRetuerID == sellRetuerID select tbWarHouser).Single(); MyModels.B_SellRetuerList.Remove(conver); int waDetialid = (int)conver.SellRetuerID; //查询对应对应明细(总数量) var converDetial = (from tbWarHouserDetial in MyModels.B_SellRetuerDateiList where tbWarHouserDetial.SellRetuerID == waDetialid select tbWarHouserDetial).ToList(); int thyCount = converDetial.Count(); if (thyCount > 0) { for (int i = 0; i < thyCount; i++) { MyModels.B_SellRetuerDateiList.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_SellRetuerList orderby tbem.Remember select tbem).ToList(); if (listy.Count > 0) { int intcoun = listy.Count; B_SellRetuerList 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 ShneheanDan(B_SellRetuerList OK, bool state) { ReturnJsonVo returnJson = new ReturnJsonVo(); string strMag = "fali"; try { B_SellRetuerList MyB_ConverList = new B_SellRetuerList(); MyB_ConverList.SellRetuerID = OK.SellRetuerID; MyB_ConverList.SellID = OK.SellID; MyB_ConverList.Remember = OK.Remember; MyB_ConverList.payName = OK.payName; MyB_ConverList.furlName = OK.furlName; MyB_ConverList.SpouseBRanchID = OK.SpouseBRanchID; MyB_ConverList.StockPlaceID = OK.StockPlaceID; MyB_ConverList.RegisterName = OK.RegisterName; MyB_ConverList.RegisterTime = OK.RegisterTime; MyB_ConverList.ExamineName = OK.ExamineName; MyB_ConverList.ExamineTime = OK.ExamineTime; MyB_ConverList.Remarks = OK.Remarks; MyModels.Entry(MyB_ConverList).State = System.Data.Entity.EntityState.Modified; if (MyModels.SaveChanges() > 0) { strMag = "succsee"; B_SellRetuerList wafrtbool = (from tbbool in MyModels.B_SellRetuerList where tbbool.SellRetuerID == MyB_ConverList.SellRetuerID 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_SellRetuerList OK, Array JiShangPiID, Array JiRuJianShu, Array JiRuXiShu, Array JieMingXiId, Array MinfXiPiHao) { 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(','); //四 string PiH = ((string[])MinfXiPiHao)[0]; string[] insPiHaoind = PiH.Split(','); B_SellRetuerList MyB_ConverList = new B_SellRetuerList(); MyB_ConverList.SellRetuerID = OK.SellRetuerID; MyB_ConverList.SellID = OK.SellID; MyB_ConverList.Remember = OK.Remember; MyB_ConverList.payName = OK.payName; MyB_ConverList.furlName = OK.furlName; MyB_ConverList.SpouseBRanchID = OK.SpouseBRanchID; MyB_ConverList.StockPlaceID = OK.StockPlaceID; MyB_ConverList.RegisterName = OK.RegisterName; MyB_ConverList.RegisterTime = OK.RegisterTime; MyB_ConverList.Remarks = OK.Remarks; MyModels.Entry(MyB_ConverList).State = System.Data.Entity.EntityState.Modified; if (MyModels.SaveChanges() > 0) { strMag = "succsee"; B_SellRetuerDateiList ConverDeTailList = new B_SellRetuerDateiList(); for (int H = 0; H < intsNXiShu.Length;) { for (int E = 0; E < intsRuJian.Length;) { for (int d = 0; d < intsid.Length;) { for (int i = 0; i < intsNXiShuid.Length;) { for (int Pi = 0; Pi < insPiHaoind.Length; Pi++) { ConverDeTailList.SellRetuerDateilID = Convert.ToInt32(intsNXiShuid[i]); //返仓明细ID ConverDeTailList.SellRetuerID = MyB_ConverList.SellRetuerID; //返仓ID ConverDeTailList.SellDeTaliID = Convert.ToInt32(intsid[d]); //商品ID ConverDeTailList.Subdivision = Convert.ToDecimal(intsNXiShu[H]); //入库细数 ConverDeTailList.MumberOfPackages = Convert.ToDecimal(intsRuJian[E]); //入库件数 ConverDeTailList.Number = Convert.ToDecimal(insPiHaoind[Pi]); //批号 MyModels.Entry(ConverDeTailList).State = System.Data.Entity.EntityState.Modified; MyModels.SaveChanges(); //保存 H++; E++; d++; i++; } } } } } } } catch (Exception e) { Console.WriteLine(e); } return(Json(strMag, JsonRequestBehavior.AllowGet)); }
public ActionResult InsectPeiZaiDan(B_SellRetuerList OK, Array JiShangPiID, Array JiRuJianShu, Array JiRuXiShu, Array PiHaoShuZu) { 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 C = ((string[])PiHaoShuZu)[0]; string[] intsNPiHao = C.Split(','); int oldWareHouseRows = (from tb in MyModels.B_SellRetuerList where tb.Remember == OK.Remember select tb).Count(); if (oldWareHouseRows == 0) { B_SellRetuerList MyB_ConverList = new B_SellRetuerList(); MyB_ConverList.SellID = OK.SellID; MyB_ConverList.Remember = OK.Remember; MyB_ConverList.payName = OK.payName; MyB_ConverList.furlName = OK.furlName; MyB_ConverList.SpouseBRanchID = OK.SpouseBRanchID; MyB_ConverList.StockPlaceID = OK.StockPlaceID; MyB_ConverList.RegisterName = OK.RegisterName; MyB_ConverList.RegisterTime = OK.RegisterTime; MyB_ConverList.Remarks = OK.Remarks; MyModels.B_SellRetuerList.Add(MyB_ConverList); if (MyModels.SaveChanges() > 0) { strMag = "succsee"; B_SellRetuerDateiList ConverDeTailList = new B_SellRetuerDateiList(); for (int H = 0; H < intsNXiShu.Length;) { for (int E = 0; E < intsRuJian.Length;) { for (int d = 0; d < intsid.Length;) { for (int Pi = 0; Pi < intsNPiHao.Length; Pi++) { ConverDeTailList.SellRetuerID = MyB_ConverList.SellRetuerID; //返仓ID ConverDeTailList.SellDeTaliID = Convert.ToInt32(intsid[d]);; //商品ID ConverDeTailList.Subdivision = Convert.ToDecimal(intsNXiShu[H]); //入库细数 ConverDeTailList.MumberOfPackages = Convert.ToDecimal(intsRuJian[E]); //入库件数 ConverDeTailList.Number = Convert.ToDecimal(intsNPiHao[Pi]); //批号 MyModels.B_SellRetuerDateiList.Add(ConverDeTailList); MyModels.SaveChanges(); //保存 H++; E++; d++; } } } } } } //return Json(strMag, JsonRequestBehavior.AllowGet); } catch (Exception e) { Console.WriteLine(e); } return(Json(strMag, JsonRequestBehavior.AllowGet)); }