public ActionResult ModifyContractGoods(ContractDeliverPlanViewModel model) { if (ModelState.IsValid) { //创建数据 ContractDeliverPlan data = new ContractDeliverPlan(); data.Id = model.Id; data.ContractId = model.ContractId; data.DispatchBillId = model.DispatchBillId; data.PlanId = model.PlanId; data.Packages = model.Packages; data.Tunnages = model.Tunnages; data.Piles = model.Piles; data.TenThousands = model.TenThousands; data.TransportChargeExpression = model.TransportChargeExpression; data.TransportPriceExpression = model.TransportPriceExpression; data.KM = model.KM; data.TransportPrice = model.TransportPrice; data.TransportCharges = model.TransportCharges; data.Remark = model.Remark; List<ContractGoods> listGoods = new List<ContractGoods>(); if (model.Goods != null) { foreach (ContractGoodsViewModel m in model.Goods) { ContractGoods g = new ContractGoods(); g.DispatchBillId = model.DispatchBillId; g.PlanId = model.PlanId; g.GoodsId = m.GoodsId; g.GoodsNo = m.GoodsNo; 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 = m.Piles; g.TenThousands = m.TenThousands; g.ProductionDate = m.ProductionDate; g.EnterWarehouseBillId = m.EnterWarehouseBillId; g.EnterWarehouseBillNo = m.EnterWarehouseBillNo; listGoods.Add(g); } } //保存数据 string strErrText; ContractSystem contract = new ContractSystem(); if (contract.UpdateContractDeliverPlan(data, listGoods, LoginAccountId, LoginStaffName, out strErrText)) { return Json(string.Empty); } else { return Json(strErrText); } } return View(model); }
/// <summary> /// 修改合同货物数据 /// </summary> /// <param name="data"></param> /// <param name="nOpStaffId"></param> /// <param name="strOpStaffName"></param> /// <param name="strErrText"></param> /// <returns></returns> public bool UpdateContractGoods(ContractGoods data, long nOpStaffId, string strOpStaffName, out string strErrText) { //创建存储过程参数 SqlParameter[] Params = { MakeParam(DISPATCHBILLID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)data.DispatchBillId), MakeParam(PLANID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)data.PlanId), MakeParam(GOODSID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)data.GoodsId), MakeParam(GOODSNO_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.GoodsNo), MakeParam(BATCHNO_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.BatchNo??string.Empty), MakeParam(PACKING_PARAM, SqlDbType.NVarChar, 10, ParameterDirection.Input, (object)data.Packing??string.Empty), MakeParam(LOCATION_PARAM, SqlDbType.NVarChar, 10, ParameterDirection.Input, (object)data.Location??string.Empty), MakeParam(PACKAGES_PARAM, SqlDbType.Int, 4, ParameterDirection.Input, (object)data.Packages), MakeParam(PIECEWEIGHT_PARAM, SqlDbType.Decimal, 13, ParameterDirection.Input, (object)data.PieceWeight), MakeParam(TUNNAGES_PARAM, SqlDbType.Decimal, 13, ParameterDirection.Input, (object)data.Tunnages), MakeParam(PILES_PARAM, SqlDbType.Decimal, 13, ParameterDirection.Input, (object)data.Piles), MakeParam(TENTHOUSANDS_PARAM, SqlDbType.Decimal, 13, ParameterDirection.Input, (object)data.TenThousands), MakeParam(PRODUCTIONDATE_PARAM, SqlDbType.NVarChar, 10, ParameterDirection.Input, (object)data.ProductionDate??string.Empty), MakeParam(ENTERWAREHOUSEBILLID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)data.EnterWarehouseBillId), MakeParam(OPSTAFFID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)nOpStaffId), MakeParam(OPSTAFFNAME_PARAM, SqlDbType.NVarChar, 50, ParameterDirection.Input, (object)strOpStaffName), }; if (Execute("UpdateContractGoods", Params, out strErrText) >= 0) return true; else return false; }