//查询明细 public ActionResult QueryMinXi(int id) { Expression <Func <MoveReport, bool> > where = i => i.Id == id; var s = moveReport.GetByWhere(where).SingleOrDefault(); var d = moveReportDetail.GetByWhere(i => i.MoveId == s.MoveNum); var t = moveReportType.GetByWhere(i => i.Id == s.MoveTypeId).SingleOrDefault(); //主表显示 var info = new { id = s.Id, MoveNum = s.MoveNum, MoveTypeId = t.MoveTypeName, Status = s.Status, Num = s.Num, AuditUser = s.AuditUser, AuditTime = s.AuditTime.ToString("yyyy-MM-dd"), Remark = s.Remark }; //明细 var dd = d.Select(i => new { Id = i.Id, DetailNum = i.DetailNum, MoveId = i.MoveId, ProductNum = i.ProductNum, ProductName = i.ProductName, Size = i.Size, Quantity = i.Quantity, TheCurrentLocation = i.TheCurrentLocation, MovingLocation = i.MovingLocation }); var result = new { MoveReportInfo = info, XiangXiInfo = dd }; return(Json(result, JsonRequestBehavior.AllowGet)); }
//修改移库单 public ActionResult UpdtInfo(List <MoveReportDetail> detail, int MoveTypeId, string Remark, string movSNum) { //先删除明细 bool val_1 = true; var moveReportDetails = new MoveReportDetailManager(); var mx = moveReportDetails.GetByWhere(i => i.MoveId == movSNum); foreach (var item in mx) { val_1 = moveReportDetails.Delete(item); } //获取明细表最大编号 string detailNumBig = moveReportDetail.GetByWhere(item => true).OrderByDescending(item => item.DetailNum).Take(1).Select(item => item.DetailNum).FirstOrDefault(); string detailNum = ""; if (detailNumBig == null) { detailNumBig = "000001"; } else { detailNum = "00000" + (int.Parse(detailNumBig) + 1); int num1 = int.Parse(detailNumBig); if (num1 >= 9) { detailNumBig = "0000" + (int.Parse(detailNumBig) + 1); } else if (num1 >= 99) { detailNumBig = "000" + (int.Parse(detailNumBig) + 1); } } string msg = ""; bool val = true; foreach (var item in detail) { item.DetailNum = detailNum; item.CreateTime = DateTime.Now; item.MoveId = movSNum; val = moveReportDetail.Add(item); } if (val) { var num = moveReportDetail.GetByWhere(item => item.MoveId == movSNum).Sum(item => item.Quantity); var moveReport_1 = new MoveReportManager(); var s = moveReport_1.GetByWhere(i => i.MoveNum == movSNum).SingleOrDefault(); s.DetailNum = detailNum; s.MoveTypeId = MoveTypeId; s.Remark = Remark; s.Num = Convert.ToInt32(num); bool vall = moveReport.Update(s); if (vall) { msg = "修改成功"; } else { msg = "修改失败"; } msg = "修改成功"; } else { msg = "修改失败"; } return(Json(msg, JsonRequestBehavior.AllowGet)); }