public bool ConfirmCargoOutOrder(int cargoOutOrderId, string userId) { var shipmentView = _dbd.pihao.FirstOrDefault(a => a.ID == cargoOutOrderId); var shipment = _db.ShipmentInfoes.FirstOrDefault(a => a.ShipmentNo == shipmentView.PH_NO); var cargo = _db.CargoInfoes.Find(shipment.CargoId); var shipmentHuot = _db.ShipmentHuotInfoes.First(a => a.HuotId == (int)shipmentView.HuotId && a.ShipmentId == shipment.Id); var cargoHuot = _db.CargoHuotInfoes.First(a => a.HuotId == shipmentView.HuotId && a.CargoId == cargo.Id); shipmentView.InspectId = userId; shipmentView.InspectTime = DateTime.Now; shipmentView.IsChecked = true; _dbd.Entry(shipmentView).Property(c => c.IsChecked).IsModified = true; _dbd.Entry(shipmentView).Property(c => c.InspectTime).IsModified = true; _dbd.Entry(shipmentView).Property(c => c.InspectId).IsModified = true; cargo.Weight -= (decimal)shipmentView.PH_ZL; shipment.Weight -= (decimal)shipmentView.PH_ZL; shipmentHuot.Weight -= (decimal)shipmentView.PH_ZL; cargoHuot.Weight -= (decimal)shipmentView.PH_ZL; if (cargo.Weight < 0 || shipment.Weight < 0 || shipmentHuot.Weight < 0 || cargoHuot.Weight < 0) { return(false); } _db.Entry(cargo).Property(c => c.Weight).IsModified = true; _db.Entry(shipment).Property(c => c.Weight).IsModified = true; _db.Entry(shipmentHuot).Property(c => c.Weight).IsModified = true; _db.Entry(cargoHuot).Property(c => c.Weight).IsModified = true; var cargoLog = new CargoLogInfoes() { IsIncome = false, InspectTime = DateTime.Now, StateId = 2, CargoId = cargo.Id, ChangeWeight = (decimal)shipmentView.PH_ZL, ShipmentId = shipment.Id, ShipmentNo = shipment.ShipmentNo, CargoInId = 2, HuotId = shipmentHuot.HuotId, InspectName = shipmentView.qianfa, Desc = "汽车出库", }; _db.CargoLogInfoes.Add(cargoLog); return(_db.SaveChanges() == 5 && _dbd.SaveChanges() == 1); }
public bool AddCargoShipLog(int huom2Id, int huotId, int shipmentId, decimal changeWeight, int cargoInId, string inspectName) { //CheckCargo(huom2Id); //var cargo = _db.CargoInfoes.First(c => c.Huom2Id == huom2Id); //CheckShipment(shipmentNo, cargo.Id); //var shipment = _db.ShipmentInfoes.First(a => a.ShipmentNo == shipmentNo); var cargo = _db.CargoInfoes.First(a => a.Huom2Id == huom2Id); var shipment = _db.ShipmentInfoes.First(a => a.Id == shipmentId); var shipmentHuotInfoes = _db.ShipmentHuotInfoes.First(a => a.ShipmentId == shipment.Id && a.HuotId == huotId); var cargoHuot = _db.CargoHuotInfoes.First(a => a.CargoId == cargo.Id && a.HuotId == huotId); cargo.Weight -= changeWeight; _db.Entry(cargo).Property(c => c.Weight).IsModified = true; shipment.Weight -= changeWeight; _db.Entry(shipment).Property(c => c.Weight).IsModified = true; shipmentHuotInfoes.Weight -= changeWeight; _db.Entry(shipmentHuotInfoes).Property(c => c.Weight).IsModified = true; cargoHuot.Weight -= changeWeight; _db.Entry(cargoHuot).Property(c => c.Weight).IsModified = true; if (cargo.Weight < 0 || shipment.Weight < 0 || shipmentHuotInfoes.Weight < 0 || cargoHuot.Weight < 0) { return(false); } if (shipment.CargoId != cargo.Id) { return(false); // return Json(new { success = "fail", message = "当前批号不对应该产品" }); } var cargoLog = new CargoLogInfoes() { IsIncome = false, InspectTime = DateTime.Now, StateId = 2, CargoId = cargo.Id, ChangeWeight = changeWeight, ShipmentId = shipment.Id, ShipmentNo = shipment.ShipmentNo, CargoInId = cargoInId, HuotId = huotId, InspectName = inspectName, Desc = "火车出库" }; _db.CargoLogInfoes.Add(cargoLog); return(_db.SaveChanges() > 0); }
public bool SelfSellOut(int id, string userId) { var user = _db.sys_ry.Find(userId); var pihao = _dbd.pihao.Find(id); var shipment = _db.ShipmentInfoes.FirstOrDefault(a => a.ShipmentNo == pihao.PH_NO); var cargoLog = new CargoLogInfoes() { ChangeWeight = (decimal)pihao.PH_ZL, IsIncome = true, InspectTime = DateTime.Now, InspectName = user.name, StateId = 3, Desc = "入库自提", CargoId = shipment.CargoId, ShipmentId = shipment.Id, ShipmentNo = shipment.ShipmentNo, HuotId = (int)pihao.HuotId, Count = 0, WeightType = "" }; var cargoLog2 = new CargoLogInfoes() { ChangeWeight = (decimal)pihao.PH_ZL, IsIncome = false, InspectTime = DateTime.Now, InspectName = user.name, StateId = 3, Desc = "出库自提", CargoId = shipment.CargoId, ShipmentNo = shipment.ShipmentNo, ShipmentId = shipment.Id, HuotId = (int)pihao.HuotId, Count = 0, WeightType = "" }; _db.CargoLogInfoes.Add(cargoLog); _db.CargoLogInfoes.Add(cargoLog2); pihao.IsChecked = true; pihao.InspectId = userId; pihao.InspectTime = DateTime.Now; return(_db.SaveChanges() == 2 && _dbd.SaveChanges() == 1); }
public bool AddCargoComeLog(int huom2Id, int huotId, string shipmentNo, decimal changeWeight, string inspectName, int count, decimal weightType) { CheckCargo(huom2Id); var cargo = _db.CargoInfoes.FirstOrDefault(c => c.Huom2Id == huom2Id); CheckShipment(shipmentNo, cargo.Id); var shipment = _db.ShipmentInfoes.FirstOrDefault(a => a.ShipmentNo == shipmentNo && a.CargoId == cargo.Id); CheckShipmentHuot(shipment.Id, huotId); var shipmentHuot = _db.ShipmentHuotInfoes.FirstOrDefault(a => a.ShipmentId == shipment.Id && a.HuotId == huotId); CheckCargoHuot(cargo.Id, huotId); var cargoHuot = _db.CargoHuotInfoes.FirstOrDefault(a => a.CargoId == cargo.Id && a.HuotId == huotId); var cargoLog = new CargoLogInfoes() { ChangeWeight = changeWeight, IsIncome = true, InspectTime = DateTime.Now, InspectName = inspectName, StateId = (int)StateEnum.正在审核, Desc = StateEnum.正在审核.ToString(),//"等待审核", CargoId = cargo.Id, ShipmentId = shipment.Id, ShipmentNo = shipment.ShipmentNo, HuotId = huotId, Count = count, WeightType = weightType == 0 ? "" : "每袋" + weightType, }; _db.CargoLogInfoes.Add(cargoLog); cargo.Weight += changeWeight; shipment.Weight += changeWeight; shipmentHuot.Weight += changeWeight; cargoHuot.Weight += changeWeight; return(_db.SaveChanges() > 0); }
public bool ExchangeShipment(string shipmentNo, int huotId, int newHuotId, decimal weight, string userId) { var shipment = _db.ShipmentInfoes.First(a => a.ShipmentNo == shipmentNo); var cargoId = shipment.CargoId; var user = _db.sys_ry.Find(userId); var cargoAreaCargo = _db.ShipmentHuotInfoes.First(a => a.HuotId == huotId && a.ShipmentId == shipment.Id); cargoAreaCargo.Weight -= weight; if (cargoAreaCargo.Weight < 0) { return(false); } var cargoHuot = _db.CargoHuotInfoes.FirstOrDefault(a => a.CargoId == shipment.CargoId && a.HuotId == huotId); cargoHuot.Weight -= weight; if (cargoHuot.Weight < 0) { return(false); } CheckCargoHuot(cargoId, newHuotId); var newCargoHuot = _db.CargoHuotInfoes.First(a => a.CargoId == cargoId && a.HuotId == newHuotId); newCargoHuot.Weight += weight; CheckShipmentHuot(shipment.Id, newHuotId); var newShipmentHuo = _db.ShipmentHuotInfoes.FirstOrDefault(a => a.HuotId == newHuotId && a.ShipmentId == shipment.Id); var huot = _db.huot.Find(newHuotId); newShipmentHuo.Weight += weight; //var cargoLogList = new List<CargoLogInfo>(); var cargoLog = new CargoLogInfoes(); cargoLog.IsIncome = false; cargoLog.ChangeWeight = weight; cargoLog.CargoId = cargoId; cargoLog.HuotId = huotId; cargoLog.ShipmentId = shipment.Id; cargoLog.ShipmentNo = shipment.ShipmentNo; cargoLog.StateId = 3; cargoLog.InspectName = user.name; cargoLog.InspectTime = DateTime.Now; cargoLog.Desc = "转库"; _db.CargoLogInfoes.Add(cargoLog); var cargoLog2 = new CargoLogInfoes(); cargoLog2.IsIncome = true; cargoLog2.ChangeWeight = weight; cargoLog2.CargoId = cargoId; cargoLog2.HuotId = newHuotId; cargoLog2.ShipmentId = shipment.Id; cargoLog.ShipmentNo = shipment.ShipmentNo; cargoLog2.StateId = 3; cargoLog2.InspectName = user.name; cargoLog2.InspectTime = DateTime.Now; cargoLog2.Desc = "转库"; _db.CargoLogInfoes.Add(cargoLog2); return(_db.SaveChanges() >= 2); }
public bool ChangeQuality(string shipmentNo, int huotId, int newHuom2Id, string userId) { var user = _db.sys_ry.Find(userId); var shipment = _db.ShipmentInfoes.FirstOrDefault(a => a.ShipmentNo == shipmentNo); var cargo = _db.CargoInfoes.Find(shipment.CargoId); var cargoHuot = _db.CargoHuotInfoes.FirstOrDefault(a => a.CargoId == cargo.Id && a.HuotId == huotId); var shipmentHuot = _db.ShipmentHuotInfoes.FirstOrDefault(a => a.ShipmentId == shipment.Id && a.HuotId == huotId); var weight = shipment.Weight; // cargo 减库存 加库存 cargo.Weight -= weight; _cargoService.CheckCargo(newHuom2Id); var newCargo = _db.CargoInfoes.First(a => a.Huom2Id == newHuom2Id); newCargo.Weight += weight; // shipment 减库存 加库存 shipment.Weight -= weight; _db.ShipmentInfoes.Remove(shipment); _cargoService.CheckShipment(shipmentNo, cargo.Huom2Id); var newShipment = _db.ShipmentInfoes.First(a => a.ShipmentNo == shipmentNo && a.CargoId == newCargo.Id); newShipment.Weight += weight; // cargoHuot 减库存 加库存 cargoHuot.Weight -= weight; _cargoService.CheckCargoHuot(newCargo.Id, huotId); var newCargoHuot = _db.CargoHuotInfoes.First(a => a.CargoId == newCargo.Id && a.HuotId == huotId); newCargoHuot.Weight += weight; // ShipmentHuot 减库存 加库存 shipmentHuot.Weight -= weight; _cargoService.CheckShipmentHuot(newShipment.Id, huotId); var newShipmentHuot = _db.ShipmentHuotInfoes.First(a => a.ShipmentId == newShipment.Id && a.HuotId == huotId); newShipmentHuot.Weight += weight; // CargoLog 加 var cargoLog = new CargoLogInfoes() { ChangeWeight = weight, IsIncome = false, InspectTime = DateTime.Now, InspectName = user.name, StateId = 2, Desc = "调整品质出库", CargoId = shipment.CargoId, ShipmentId = shipment.Id, ShipmentNo = shipment.ShipmentNo, HuotId = huotId, Count = 0, WeightType = "" }; var cargoLog2 = new CargoLogInfoes() { ChangeWeight = weight, IsIncome = true, InspectTime = DateTime.Now, InspectName = user.name, StateId = 2, Desc = "调整品质入库", CargoId = newCargo.Id, ShipmentId = newShipment.Id, ShipmentNo = shipment.ShipmentNo, HuotId = huotId, Count = 0, WeightType = "" }; _db.CargoLogInfoes.Add(cargoLog); _db.CargoLogInfoes.Add(cargoLog2); return(_db.SaveChanges() > 0 && _dbd.SaveChanges() == 1); }