/// <summary> /// 新增入库货物数据 /// </summary> /// <param name="data"></param> /// <param name="nOpStaffId"></param> /// <param name="strOpStaffName"></param> /// <param name="strErrText"></param> /// <returns></returns> public bool InsertEnterWarehouseBillGoods(EnterWarehouseBillGoods data, long nOpStaffId, string strOpStaffName, out string strErrText) { //创建存储过程参数 SqlParameter[] Params = { MakeParam(ID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)data.Id), MakeParam(CUSTOMERID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)data.CustomerId), MakeParam(CUSTOMERNAME_PARAM, SqlDbType.NVarChar, 50, ParameterDirection.Input, (object)data.CustomerName), MakeParam(GOODSID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)data.GoodsId), MakeParam(GOODSNO_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.GoodsNo), MakeParam(GOODSNAME_PARAM, SqlDbType.NVarChar, 50, ParameterDirection.Input, (object)data.GoodsName), MakeParam(BRAND_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.Brand??string.Empty), MakeParam(SPECMODEL_PARAM, SqlDbType.NVarChar, 50, ParameterDirection.Input, (object)data.SpecModel), MakeParam(GWEIGHT_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.GWeight??string.Empty), MakeParam(GRADE_PARAM, SqlDbType.NVarChar, 10, ParameterDirection.Input, (object)data.Grade??string.Empty), MakeParam(BATCHNO_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.BatchNo), MakeParam(PACKING_PARAM, SqlDbType.NVarChar, 10, ParameterDirection.Input, (object)data.Packing??string.Empty), MakeParam(WAREHOUSE_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.Warehouse), 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), MakeParam(SHIPMENTBILLGOODSIDS_PARAM, SqlDbType.NVarChar, 500, ParameterDirection.Input, (object)data.ShipmentBillGoodsIds??string.Empty), MakeParam(ENTERWAREHOUSEBILLID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)data.EnterWarehouseBillId), MakeParam(DELIVERYNO_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.DeliveryNo??string.Empty), 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("InsertEnterWarehouseBillGoods", Params, out strErrText) >= 0) return true; else return false; }
public ActionResult EnterWarehouse(EnterWarehouseBillViewModel model) { if (ModelState.IsValid) { //创建数据 EnterWarehouseBill bill = new EnterWarehouseBill(); bill.Id = model.Id; bill.BillNo = model.BillNo; bill.PlanId = model.PlanId; bill.CustomerId = model.CustomerId; bill.CustomerName = model.CustomerName; bill.DeliveryNo = model.DeliveryNo; bill.EnterType = model.EnterType; bill.IsConsigning = model.IsConsigning; bill.Warehouse = model.Warehouse; bill.UnloadingForceFeePrice = model.UnloadingForceFeePrice; bill.ForceFee = model.ForceFee; bill.StorageFeePrice = model.StorageFeePrice; bill.HasDrayage = model.HasDrayage; bill.Remark = model.Remark; bill.CreateTime = DateTime.Parse(model.CreateTime); List<EnterWarehouseBillGoods> listGoods = new List<EnterWarehouseBillGoods>(); foreach (EnterWarehouseBillGoodsViewModel m in model.Goods) { EnterWarehouseBillGoods g = new EnterWarehouseBillGoods(); g.Id = m.Id; g.CustomerId = model.CustomerId; g.CustomerName = model.CustomerName; g.GoodsId = m.GoodsId; g.GoodsNo = m.GoodsNo; g.GoodsName = m.GoodsName; g.Brand = m.Brand; g.SpecModel = m.SpecModel; g.GWeight = m.GWeight; g.Grade = m.Grade; g.BatchNo = m.BatchNo; g.Packing = m.Packing; g.Warehouse = model.Warehouse; 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.ShipmentBillGoodsIds = m.ShipmentBillGoodsIds; g.EnterWarehouseBillId = m.EnterWarehouseBillId; g.DeliveryNo = model.DeliveryNo; g.CreateTime = DateTime.Parse(model.CreateTime); listGoods.Add(g); } //保存数据 string strErrText; StockSystem stock = new StockSystem(); if (bill.Id == 0) { long nEnterWarehouseBillId = stock.InsertEnterWarehouseBill(bill, listGoods, LoginAccountId, LoginStaffName, out strErrText); if (nEnterWarehouseBillId > 0) { //读取入库单号 bill = stock.LoadEnterWarehouseBill(nEnterWarehouseBillId, LoginAccountId, LoginStaffName, out strErrText); if (bill == null) { var ret = new { EnterWarehouseBillNo = string.Empty, ErrorText = strErrText }; return Json(ret); } else { var ret = new { EnterWarehouseBillNo = bill.BillNo, ErrorText = string.Empty }; return Json(ret); } } else { var ret = new { EnterWarehouseBillNo = string.Empty, ErrorText = strErrText }; return Json(ret); } } else { if (stock.UpdateEnterWarehouseBill(bill, listGoods, LoginAccountId, LoginStaffName, out strErrText)) { var ret = new { EnterWarehouseBillNo = bill.BillNo, ErrorText = string.Empty }; return Json(ret); } else { var ret = new { EnterWarehouseBillNo = string.Empty, ErrorText = strErrText }; return Json(ret); } } } return View(model); }