/// <summary> /// 修改发货计划 /// </summary> /// <param name="data"></param> /// <param name="listGoods"></param> /// <param name="nOpStaffId"></param> /// <param name="strOpStaffName"></param> /// <param name="strErrText"></param> /// <returns></returns> public bool UpdateDeliverPlan(DeliverPlan data, List<DeliverPlanGoods> listGoods, long nOpStaffId, string strOpStaffName, out string strErrText) { try { using (TransactionScope transScope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(2, 0, 0))) { using (PlanDAO dao = new PlanDAO()) { //修改计划数据 if (!dao.UpdateDeliverPlan(data, nOpStaffId, strOpStaffName, out strErrText)) return false; //修改货物数据 if (!dao.DeleteDeliverPlanAllGoods(data.Id, nOpStaffId, strOpStaffName, out strErrText)) { return false; } foreach (DeliverPlanGoods goods in listGoods) { goods.PlanId = data.Id; if (!dao.InsertDeliverPlanGoods(goods, nOpStaffId, strOpStaffName, out strErrText)) { return false; } } } transScope.Complete(); } return true; } catch (Exception e) { strErrText = e.Message; return false; } }
/// <summary> /// 新增发货计划 /// </summary> /// <param name="data"></param> /// <param name="listGoods"></param> /// <param name="nOpStaffId"></param> /// <param name="strOpStaffName"></param> /// <param name="strErrText"></param> /// <returns></returns> public long InsertDeliverPlan(DeliverPlan data, List<DeliverPlanGoods> listGoods, long nOpStaffId, string strOpStaffName, out string strErrText) { long nPlanId = 0; try { using (TransactionScope transScope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(2, 0, 0))) { using (PlanDAO dao = new PlanDAO()) { //新增计划数据 nPlanId = dao.InsertDeliverPlan(data, nOpStaffId, strOpStaffName, out strErrText); if (nPlanId <= 0) return 0; //新增货物数据 foreach (DeliverPlanGoods goods in listGoods) { goods.PlanId = nPlanId; if (!dao.InsertDeliverPlanGoods(goods, nOpStaffId, strOpStaffName, out strErrText)) { return 0; } } } transScope.Complete(); } return nPlanId; } catch (Exception e) { strErrText = e.Message; return 0; } }
/// <summary> /// 修改计划 /// </summary> /// <param name="data"></param> /// <param name="nOpStaffId">操作员工编码</param> /// <param name="strOpStaffName">操作员工姓名</param> /// <param name="strErrText">出错信息</param> /// <returns>成功返回True,否则返回False</returns> public bool UpdateDeliverPlan(DeliverPlan data, long nOpStaffId, string strOpStaffName, out string strErrText) { //创建存储过程参数 SqlParameter[] Params = { MakeParam(ID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)data.Id), MakeParam(PLANTYPE_PARAM, SqlDbType.NVarChar, 10, ParameterDirection.Input, (object)data.PlanType), MakeParam(CUSTOMERID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)data.CustomerId), MakeParam(SHIPMENTNO_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.ShipmentNo??System.DBNull.Value), MakeParam(DELIVERYNO_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.DeliveryNo??System.DBNull.Value), MakeParam(DELIVERTYPE_PARAM, SqlDbType.NVarChar, 10, ParameterDirection.Input, (object)data.DeliverType), MakeParam(RECEIVERNAME_PARAM, SqlDbType.NVarChar, 50, ParameterDirection.Input, (object)data.ReceiverName), MakeParam(RECEIVERCOUNTRY_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.ReceiverCountry), MakeParam(RECEIVERPROVINCE_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.ReceiverProvince), MakeParam(RECEIVERCITY_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.ReceiverCity), MakeParam(RECEIVERADDRESS_PARAM, SqlDbType.NVarChar, 50, ParameterDirection.Input, (object)data.ReceiverAddress), MakeParam(RECEIVERCONTACT_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.ReceiverContact??System.DBNull.Value), MakeParam(RECEIVERCONTACTTEL_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.ReceiverContactTel??System.DBNull.Value), MakeParam(ORDERNO_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.OrderNo??System.DBNull.Value), MakeParam(RECEIVETYPE_PARAM, SqlDbType.NVarChar, 10, ParameterDirection.Input, (object)data.ReceiveType), MakeParam(CARNO_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.CarNo??System.DBNull.Value), MakeParam(TRAILERNO_PARAM, SqlDbType.NVarChar, 10, ParameterDirection.Input, (object)data.TrailerNo??System.DBNull.Value), MakeParam(DRIVERNAME_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.DriverName??System.DBNull.Value), MakeParam(DRIVERLICENSENO_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.DriverLicenseNo??System.DBNull.Value), MakeParam(DRIVERMOBILETEL_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.DriverMobileTel??System.DBNull.Value), MakeParam(DRIVERHOMETEL_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.DriverHomeTel??System.DBNull.Value), MakeParam(WAREHOUSE_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.Warehouse??string.Empty), MakeParam(ARRIVALTIME_PARAM, SqlDbType.NVarChar, 10, ParameterDirection.Input, (object)data.ArrivalTime??System.DBNull.Value), MakeParam(PAYERID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)data.PayerId), MakeParam(PAYERNAME_PARAM, SqlDbType.NVarChar, 50, ParameterDirection.Input, (object)data.PayerName), MakeParam(ISCONSIGNING_PARAM, SqlDbType.Bit, 1, ParameterDirection.Input, (object)data.IsConsigning??System.DBNull.Value), MakeParam(CONSIGNEDDELIVERYNO_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.ConsignedDeliveryNo??System.DBNull.Value), MakeParam(ISINSTALMENT_PARAM, SqlDbType.Bit, 1, ParameterDirection.Input, (object)data.IsInstalment??System.DBNull.Value), MakeParam(STARTCOUNTRY_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.StartCountry), MakeParam(STARTPROVINCE_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.StartProvince), MakeParam(STARTCITY_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.StartCity), MakeParam(REMARK_PARAM, SqlDbType.NVarChar, 500, ParameterDirection.Input, (object)data.Remark??System.DBNull.Value), MakeParam(CREATETIME_PARAM, SqlDbType.DateTime, 8, ParameterDirection.Input, (object)data.CreateTime), MakeParam(OPSTAFFID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)nOpStaffId), MakeParam(OPSTAFFNAME_PARAM, SqlDbType.NVarChar, 50, ParameterDirection.Input, (object)strOpStaffName), }; if (Execute("UpdateDeliverPlan", Params, out strErrText) >= 0) return true; else return false; }
/// <summary> /// 修改发货计划 /// </summary> /// <param name="data"></param> /// <param name="listGoods"></param> /// <param name="nOpStaffId"></param> /// <param name="strOpStaffName"></param> /// <param name="strErrText"></param> /// <returns></returns> public bool UpdateDeliverPlan(DeliverPlan data, List<DeliverPlanGoods> listGoods, long nOpStaffId, string strOpStaffName, out string strErrText) { PlanRule rule = new PlanRule(); return rule.UpdateDeliverPlan(data, listGoods, nOpStaffId, strOpStaffName, out strErrText); }
public ActionResult NewPaperPlan(PaperPlanViewModel model) { if (ModelState.IsValid) { //检查数据 if (model.ReceiveType == InnoSoft.LS.Resources.Options.PickUpSelf) { //自提必须输入车号 if (model.CarNo == null || model.CarNo == string.Empty) { return Json(InnoSoft.LS.Resources.Strings.NotEnterCarrierInfoWhenPickUpSelf); } if (model.DriverName != null && model.DriverName != string.Empty) { if (model.DriverLicenseNo == null || model.DriverLicenseNo == string.Empty) { return Json(InnoSoft.LS.Resources.Strings.NotEnterDriverLicenseNo); } if (model.DriverMobileTel == null || model.DriverMobileTel == string.Empty) { return Json(InnoSoft.LS.Resources.Strings.NotEnterDriverMobileTel); } } } else { if (model.DeliveryNo == null || model.DeliveryNo == string.Empty) { return Json(InnoSoft.LS.Resources.Strings.NotEnterDeliveryNo); } } if (model.Goods == null || model.Goods.Count == 0) { return Json(InnoSoft.LS.Resources.Strings.NotEnterGoods); } //创建数据 DeliverPlan data = new DeliverPlan(); data.PlanType = InnoSoft.LS.Resources.Options.PaperPlan; data.CustomerId = model.CustomerId; data.CustomerName = model.CustomerName; data.ShipmentNo = model.ShipmentNo; data.DeliveryNo = model.DeliveryNo; data.DeliverType = model.DeliverType; data.ReceiverName = model.ReceiverName; data.ReceiverCountry = model.ReceiverCountry; data.ReceiverProvince = model.ReceiverProvince; data.ReceiverCity = model.ReceiverCity; data.ReceiverAddress = model.ReceiverAddress; data.ReceiverContact = model.ReceiverContact; data.ReceiverContactTel = model.ReceiverContactTel; data.OrderNo = model.OrderNo; data.ReceiveType = model.ReceiveType; data.CarNo = model.CarNo; data.TrailerNo = model.TrailerNo; data.DriverName = model.DriverName; data.DriverLicenseNo = model.DriverLicenseNo; data.DriverMobileTel = model.DriverMobileTel; data.DriverHomeTel = model.DriverHomeTel; data.Warehouse = model.Warehouse; data.ArrivalTime = model.ArrivalTime; data.PayerId = model.PayerId; data.PayerName = model.PayerName; data.IsConsigning = model.IsConsigning; data.ConsignedDeliveryNo = model.ConsignedDeliveryNo; data.IsInstalment = model.IsInstalment; data.StartCountry = model.StartCountry; data.StartProvince = model.StartProvince; data.StartCity = model.StartCity; data.Remark = model.Remark; data.CreateTime = DateTime.Parse(model.CreateTime); List<DeliverPlanGoods> listGoods = new List<DeliverPlanGoods>(); if (model.Goods != null) { foreach (PaperPlanGoodsViewModel m in model.Goods) { DeliverPlanGoods g = new DeliverPlanGoods(); g.GoodsId = m.GoodsId; g.BatchNo = m.BatchNo; g.Packing = m.Packing; g.Location = m.Location; g.Packages = m.Packages; g.PieceWeight = m.PieceWeight; g.Tunnages = m.Tunnages; g.Piles = 0; g.TenThousands = 0; g.ProductionDate = m.ProductionDate; g.EnterWarehouseBillId = m.EnterWarehouseBillId; listGoods.Add(g); } } //保存数据 string strErrText; PlanSystem plan = new PlanSystem(); if (plan.InsertDeliverPlan(data, listGoods, LoginAccountId, LoginStaffName, out strErrText) > 0) { return Json(string.Empty); } else { return Json(strErrText); } } return View(model); }
public ActionResult NewOtherPlan(OtherPlanViewModel model) { if (ModelState.IsValid) { //检查数据 if (model.Goods == null || model.Goods.Count == 0) { return Json(InnoSoft.LS.Resources.Strings.NotEnterGoods); } //创建数据 DeliverPlan data = new DeliverPlan(); data.PlanType = InnoSoft.LS.Resources.Options.OtherPlan; data.CustomerId = model.CustomerId; data.CustomerName = model.CustomerName; data.DeliveryNo = model.DeliveryNo; data.DeliverType = InnoSoft.LS.Resources.Options.DeliverGoods; data.ReceiverName = model.ReceiverName; data.ReceiverCountry = model.ReceiverCountry; data.ReceiverProvince = model.ReceiverProvince; data.ReceiverCity = model.ReceiverCity; data.ReceiverAddress = model.ReceiverAddress; data.ReceiverContact = model.ReceiverContact; data.ReceiverContactTel = model.ReceiverContactTel; data.ReceiveType = InnoSoft.LS.Resources.Options.PickUpDelivery; data.Warehouse = model.Warehouse; data.ArrivalTime = model.ArrivalTime; data.PayerId = model.CustomerId; data.PayerName = model.CustomerName; data.StartCountry = model.StartCountry; data.StartProvince = model.StartProvince; data.StartCity = model.StartCity; data.Remark = model.Remark; data.CreateTime = DateTime.Parse(model.CreateTime); List<DeliverPlanGoods> listGoods = new List<DeliverPlanGoods>(); if (model.Goods != null) { foreach (OtherPlanGoodsViewModel m in model.Goods) { DeliverPlanGoods g = new DeliverPlanGoods(); g.GoodsId = m.GoodsId; g.Packages = m.Packages; g.Tunnages = m.Tunnages; g.Piles = 0; listGoods.Add(g); } } //保存数据 string strErrText; PlanSystem plan = new PlanSystem(); if (plan.InsertDeliverPlan(data, listGoods, LoginAccountId, LoginStaffName, out strErrText) > 0) { return Json(string.Empty); } else { return Json(strErrText); } } return View(model); }
public ActionResult NewNotDeliverCanPlan(CanPlanViewModel model) { if (ModelState.IsValid) { //检查数据 if (model.Goods == null || model.Goods.Count == 0) { return Json(InnoSoft.LS.Resources.Strings.NotEnterGoods); } //创建数据 DeliverPlan data = new DeliverPlan(); data.PlanType = InnoSoft.LS.Resources.Options.NotDeliverCanPlan; data.CustomerId = model.CustomerId; data.CustomerName = model.CustomerName; data.DeliveryNo = model.DeliveryNo; data.DeliverType = InnoSoft.LS.Resources.Options.DeliverGoods; data.ReceiverName = model.ReceiverName; data.ReceiverCountry = model.ReceiverCountry; data.ReceiverProvince = model.ReceiverProvince; data.ReceiverCity = model.ReceiverCity; data.ReceiverAddress = model.ReceiverAddress; data.ReceiverContact = model.ReceiverContact; data.ReceiverContactTel = model.ReceiverContactTel; data.ReceiveType = model.ReceiveType; data.CarNo = model.CarNo; data.TrailerNo = model.TrailerNo; data.DriverName = model.DriverName; data.DriverLicenseNo = model.DriverLicenseNo; data.DriverMobileTel = model.DriverMobileTel; data.DriverHomeTel = model.DriverHomeTel; data.Warehouse = model.Warehouse; data.ArrivalTime = model.ArrivalTime; data.PayerId = model.PayerId; data.PayerName = model.PayerName; data.StartCountry = model.StartCountry; data.StartProvince = model.StartProvince; data.StartCity = model.StartCity; data.Remark = model.Remark; data.CreateTime = DateTime.Parse(model.CreateTime); List<DeliverPlanGoods> listGoods = new List<DeliverPlanGoods>(); if (model.Goods != null) { foreach (CanPlanGoodsViewModel m in model.Goods) { DeliverPlanGoods g = new DeliverPlanGoods(); g.GoodsId = m.GoodsId; g.GoodsNo = m.GoodsNo; g.GoodsName = m.GoodsName; g.SpecModel = m.SpecModel; g.BatchNo = m.BatchNo; g.Warehouse = m.Warehouse; g.Location = m.Location; g.Piles = m.Piles; g.TenThousands = m.TenThousands; g.ProductionDate = m.ProductionDate; g.EnterWarehouseBillId = m.EnterWarehouseBillId; g.EnterWarehouseBillNo = m.EnterWarehouseBillNo; listGoods.Add(g); } } //保存数据 string strErrText; PlanSystem plan = new PlanSystem(); if (plan.InsertDeliverPlan(data, listGoods, LoginAccountId, LoginStaffName, out strErrText) > 0) { return Json(string.Empty); } else { return Json(strErrText); } } return View(model); }