/// <summary> /// 删除(转库单) /// </summary> /// <returns></returns> public ActionResult DeleteChanger(int changeID) { string strMsg = "fail"; try { B_ChangeList conver = (from tbWarHouser in myModels.B_ChangeList where tbWarHouser.ChangeID == changeID select tbWarHouser).Single(); myModels.B_ChangeList.Remove(conver); int waDetialid = (int)conver.ChangeID; //查询对应对应明细(总数量) var converDetial = (from tbWarHouserDetial in myModels.B_ChangeDetailList where tbWarHouserDetial.ChangeID == changeID select tbWarHouserDetial).ToList(); int thyCount = converDetial.Count(); if (thyCount > 0) { for (int i = 0; i < thyCount; i++) { myModels.B_ChangeDetailList.Remove(converDetial[i]); myModels.SaveChanges(); strMsg = "success"; } } } catch (Exception e) { Console.WriteLine(e); } return(Json(strMsg, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 记录编号 /// </summary> /// <returns></returns> public ActionResult getEmpCode() { string Std = ""; var listy = (from tbem in myModels.B_ChangeList orderby tbem.Remember select tbem).ToList(); if (listy.Count > 0) { int intcoun = listy.Count; B_ChangeList 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 ShenheaiDan(B_ChangeList OK, bool state) { ReturnJsonVo returnJson = new ReturnJsonVo(); string strMag = "fali"; try { B_ChangeList MyB_ConverList = new B_ChangeList(); MyB_ConverList.ChangeID = OK.ChangeID; MyB_ConverList.WareHouseID = OK.WareHouseID; MyB_ConverList.Remember = OK.Remember; MyB_ConverList.SpouseBRanchID = OK.SpouseBRanchID; MyB_ConverList.StockPlaceID = OK.StockPlaceID; MyB_ConverList.StockPlaceIDtwo = OK.StockPlaceIDtwo; MyB_ConverList.payName = OK.payName; MyB_ConverList.furlName = OK.furlName; MyB_ConverList.RegisterName = OK.RegisterName; MyB_ConverList.RegisterTime = OK.RegisterTime; MyB_ConverList.ShiFouGou = OK.ShiFouGou; MyB_ConverList.ExamineName = OK.ExamineName; MyB_ConverList.ExamineTime = OK.ExamineTime; myModels.Entry(MyB_ConverList).State = System.Data.Entity.EntityState.Modified; myModels.SaveChanges(); B_ChangeList wafrtbool = (from tbbool in myModels.B_ChangeList where tbbool.ChangeID == MyB_ConverList.ChangeID 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 UptoctPeiZaiDan(B_ChangeList OK, Array JiShangPiID, Array JiRuJianShu, Array JiRuXiShu, Array JiZhuanidShu) { 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(','); //四id string idc = ((string[])JiZhuanidShu)[0]; string[] intsidcXiShu = idc.Split(','); B_ChangeList MyB_ConverList = new B_ChangeList(); MyB_ConverList.ChangeID = OK.ChangeID; MyB_ConverList.WareHouseID = OK.WareHouseID; MyB_ConverList.Remember = OK.Remember; MyB_ConverList.SpouseBRanchID = OK.SpouseBRanchID; MyB_ConverList.StockPlaceID = OK.StockPlaceID; MyB_ConverList.StockPlaceIDtwo = OK.StockPlaceIDtwo; MyB_ConverList.payName = OK.payName; MyB_ConverList.furlName = OK.furlName; MyB_ConverList.RegisterName = OK.RegisterName; MyB_ConverList.RegisterTime = OK.RegisterTime; MyB_ConverList.ShiFouGou = OK.ShiFouGou; myModels.Entry(MyB_ConverList).State = System.Data.Entity.EntityState.Modified; if (myModels.SaveChanges() > 0) { strMag = "succsee"; B_ChangeDetailList ConverDeTailList = new B_ChangeDetailList(); for (int H = 0; H < intsNXiShu.Length;) { for (int E = 0; E < intsRuJian.Length;) { for (int d = 0; d < intsid.Length;) { for (int idx = 0; idx < intsidcXiShu.Length; idx++) { ConverDeTailList.ChangeDetailID = Convert.ToInt32(intsidcXiShu[idx]); //转库ID ConverDeTailList.ChangeID = MyB_ConverList.ChangeID; //返仓ID ConverDeTailList.WareHouseDetiailID = 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(); //保存 d++; H++; E++; } } } } } } catch (Exception e) { Console.WriteLine(e); } return(Json(strMag, JsonRequestBehavior.AllowGet)); }
public ActionResult InsectPeiZaiDan(B_ChangeList 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_ChangeList where tb.Remember == OK.Remember select tb).Count(); if (oldWareHouseRows == 0) { B_ChangeList MyB_ConverList = new B_ChangeList(); MyB_ConverList.WareHouseID = OK.WareHouseID; MyB_ConverList.Remember = OK.Remember; MyB_ConverList.SpouseBRanchID = OK.SpouseBRanchID; MyB_ConverList.StockPlaceID = OK.StockPlaceID; MyB_ConverList.StockPlaceIDtwo = OK.StockPlaceIDtwo; MyB_ConverList.payName = OK.payName; MyB_ConverList.furlName = OK.furlName; MyB_ConverList.RegisterName = OK.RegisterName; MyB_ConverList.RegisterTime = OK.RegisterTime; MyB_ConverList.ShiFouGou = OK.ShiFouGou; myModels.B_ChangeList.Add(MyB_ConverList); if (myModels.SaveChanges() > 0) { strMag = "succsee"; B_ChangeDetailList ConverDeTailList = new B_ChangeDetailList(); for (int H = 0; H < intsNXiShu.Length;) { for (int E = 0; E < intsRuJian.Length;) { for (int d = 0; d < intsid.Length; d++) { ConverDeTailList.ChangeID = MyB_ConverList.ChangeID; //返仓ID ConverDeTailList.WareHouseDetiailID = Convert.ToInt32(intsid[d]);; //进仓明细ID ConverDeTailList.Subdivision = Convert.ToDecimal(intsNXiShu[H]); //入库细数 ConverDeTailList.MumberOfPackages = Convert.ToDecimal(intsRuJian[E]); //入库件数 myModels.B_ChangeDetailList.Add(ConverDeTailList); myModels.SaveChanges();//保存 H++; E++; } } } } } } catch (Exception e) { Console.WriteLine(e); } return(Json(strMag, JsonRequestBehavior.AllowGet)); }