public ResModel UpdatePartsBuy(PartsBuyDto partsBuyDto, UserDto operationUser) { using (var db = new ModelContext()) { var partsBuy = db.PartsBuy.FirstOrDefault(i => i.Id == partsBuyDto.Id); if (partsBuy == null) { return(new ResModel() { Msg = "更新采购入库失败,未找到该采购入库", Success = false }); } partsBuy.SupplierId = partsBuyDto.SupplierId; partsBuy.WarehouseId = partsBuyDto.WarehouseId; partsBuy.ApplyUser = operationUser.Name; partsBuy.OperationTime = DateTime.Now; partsBuy.TotalMoney = partsBuyDto.TotalMoney; partsBuy.ReadyToPay = partsBuyDto.TotalMoney; partsBuy.Description = partsBuyDto.Description; var partsIns = partsBuyDto.PartsIns.Select(i => new PartsIn() { Id = Guid.NewGuid(), PartsBuyId = partsBuy.Id, PartsDictionaryId = i.PartsDictionaryId, SupplierPrice = i.SupplierPrice, Count = i.Count, }); using (var scope = new TransactionScope()) { try { db.PartsIn.RemoveRange(partsBuy.PartsIns); db.SaveChanges(); db.PartsIn.AddRange(partsIns); db.SaveChanges(); scope.Complete(); } catch (Exception e) { return(new ResModel() { Msg = "更新失败", Success = false }); } return(new ResModel() { Msg = "更新成功", Success = true }); } } }
public ActionResult Update(PartsBuyDto partsBuyDto) { var currentUser = Session["LogUser"] as UserDto; return(Json(_partsBuyService.UpdatePartsBuy(partsBuyDto, currentUser))); }
public ResModel AddPartsBuy(PartsBuyDto partsBuyDto, UserDto operationUser) { using (var db = new ModelContext()) { var billNo = ""; var lastPartsBuyIndex = 0; var dateFormat = ""; var index = 0; var indexStr = ""; var partsBuyBill = db.BillNoSetting.FirstOrDefault(i => i.Name == BillTypeName.采购入库.ToString()); if (partsBuyBill.DailyReset) { var lastPartsBuy = db.PartsBuy.Where(i => i.CreateTime.Value.Day == DateTime.Now.Day).OrderByDescending(i => i.CreateTime).FirstOrDefault(); lastPartsBuyIndex = lastPartsBuy?.BillNoIndex ?? 0; } else { var lastPartsBuy = db.PartsBuy.OrderByDescending(i => i.CreateTime).FirstOrDefault(); lastPartsBuyIndex = lastPartsBuy?.BillNoIndex ?? 0; } index = lastPartsBuyIndex + 1; indexStr = index.ToString(); switch (partsBuyBill.SerNoLength) { case BillSerNoLength.两位: indexStr = indexStr.PadLeft(2, '0'); break; case BillSerNoLength.位: indexStr = indexStr.PadLeft(3, '0'); break; case BillSerNoLength.四位: indexStr = indexStr.PadLeft(4, '0'); break; case BillSerNoLength.五位: indexStr = indexStr.PadLeft(5, '0'); break; case BillSerNoLength.六位: indexStr = indexStr.PadLeft(6, '0'); break; } switch (partsBuyBill.DateFormat) { case BillDateFormat.简洁年月日: dateFormat = DateTime.Now.ToString("yyMMdd"); break; case BillDateFormat.完整年月日: dateFormat = DateTime.Now.ToString("yyyyMMdd"); break; case BillDateFormat.无: dateFormat = ""; break; } billNo = partsBuyBill.Prefix + dateFormat + indexStr; var partsBuy = new PartsBuy() { Id = Guid.NewGuid(), SupplierId = partsBuyDto.SupplierId, BillNo = billNo, BillNoIndex = index, State = PartsBuyState.未审核, ApplyUser = operationUser.Name, OperationTime = DateTime.Now, TotalMoney = partsBuyDto.TotalMoney, ReadyToPay = partsBuyDto.TotalMoney, WarehouseId = partsBuyDto.WarehouseId, Description = partsBuyDto.Description, CreateTime = DateTime.Now, }; var partsIns = partsBuyDto.PartsIns.Select(i => new PartsIn() { Id = Guid.NewGuid(), PartsBuyId = partsBuy.Id, PartsDictionaryId = i.PartsDictionaryId, SupplierPrice = i.SupplierPrice, Count = i.Count, }); using (var scope = new TransactionScope()) { try { db.PartsBuy.Add(partsBuy); db.PartsIn.AddRange(partsIns); db.SaveChanges(); scope.Complete();; } catch (Exception e) { return(new ResModel() { Msg = "添加采购入库失败", Success = false }); } return(new ResModel() { Msg = "添加采购入库成功", Success = true }); } } }
public ResModel UpdatePartsBuy(PartsBuyDto partsBuyDto, UserDto operationUser) { return(_partsBuyRepository.UpdatePartsBuy(partsBuyDto, operationUser)); }