//修改审核状态 public ActionResult UpdtStatus(OutStorage i, string status) { var ss = outStorage.GetByWhere(item => item.Id == i.Id).SingleOrDefault(); i.OutSNum = ss.OutSNum; i.OutSTypeId = ss.OutSTypeId; i.CustomerId = ss.CustomerId; i.DetailNum = ss.DetailNum; i.Num = ss.Num; i.SumMoney = ss.SumMoney; i.Status = status; i.Contacts = ss.Contacts; i.SendDate = ss.SendDate; i.AuditUser = ss.AuditUser; i.AuditTime = ss.AuditTime; i.IsDelete = ss.IsDelete; i.Remark = ss.Remark; var outStorages = new OutStorageManager(); var s = outStorages.Update(i); if (status.Equals("审核通过")) { var d = outStorageDetail.GetByWhere(item => item.OutStorageId == ss.OutSNum); foreach (var item in d) { var pd = new ProductManager(); Expression <Func <Product, bool> > where = iss => iss.ProductNum == item.ProductNum; var pdu1 = pd.GetByWhere(where).SingleOrDefault(); pdu1.StockNum = Convert.ToInt32(pdu1.StockNum - item.Quantity); var pdu = productManager.Update(pdu1); } } var result = new { ActionResult = s }; return(Json(result, JsonRequestBehavior.AllowGet)); }
//修改出库单 public ActionResult UpdtInfo(List <OutStorageDetail> detail, int outSTypeId, int customerId, string Remark, string OutSNum) { //先删除明细 bool val_1 = true; var outStorageDetails = new OutStorageDetailManager(); var mx = outStorageDetails.GetByWhere(i => i.OutStorageId == OutSNum); foreach (var item in mx) { val_1 = outStorageDetails.Delete(item); } //获取明细表最大编号 string detailNumBig = outStorageDetail.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.OutStorageId = OutSNum; item.CreateTime = DateTime.Now; val = outStorageDetail.Add(item); } if (val) { var num = outStorageDetail.GetByWhere(item => item.OutStorageId == OutSNum).Sum(item => item.Quantity); var sumMoney = outStorageDetail.GetByWhere(item => item.OutStorageId == OutSNum).Sum(item => item.SumMoney); var outStorage_1 = new OutStorageManager(); var s = outStorage_1.GetByWhere(i => i.OutSNum == OutSNum).SingleOrDefault(); s.DetailNum = detailNum; s.OutSTypeId = outSTypeId; s.CustomerId = customerId; s.Remark = Remark; s.Num = Convert.ToInt32(num); s.SumMoney = Convert.ToDouble(sumMoney); bool vall = outStorage.Update(s); if (vall) { msg = "修改成功"; } else { msg = "修改失败"; } msg = "修改成功"; } else { msg = "修改失败"; } return(Json(msg, JsonRequestBehavior.AllowGet)); }