public ResultModel CreateStock(UserModel user, Model.CashInAllot allot, List<Model.CashInStcok> details, int stockLogId) { ResultModel result = new ResultModel(); try { NFMT.Contract.DAL.ContractCorporationDetailDAL corpDetailDAL = new Contract.DAL.ContractCorporationDetailDAL(); NFMT.Contract.DAL.ContractSubDAL subDAL = new Contract.DAL.ContractSubDAL(); DAL.CashInContractDAL cashInContractDAL = new CashInContractDAL(); DAL.CashInCorpDAL cashInCorpDAL = new CashInCorpDAL(); DAL.CashInDAL cashInDAL = new CashInDAL(); NFMT.WareHouse.DAL.StockLogDAL stockLogDAL = new WareHouse.DAL.StockLogDAL(); NFMT.WareHouse.DAL.StockDAL stockDAL = new WareHouse.DAL.StockDAL(); using (System.Transactions.TransactionScope scope = new TransactionScope()) { //获取库存流水 result = stockLogDAL.Get(user, stockLogId); if (result.ResultStatus != 0) return result; NFMT.WareHouse.Model.StockLog stockLog = result.ReturnValue as NFMT.WareHouse.Model.StockLog; if (stockLog == null || stockLog.StockLogId <= 0) { result.ResultStatus = -1; result.Message = "库存流水不存在"; return result; } //获取库存 result = stockDAL.Get(user, stockLog.StockId); if (result.ResultStatus != 0) return result; NFMT.WareHouse.Model.Stock stock = result.ReturnValue as NFMT.WareHouse.Model.Stock; if (stock == null || stock.StockId <= 0) { result.Message = "库存不存在"; result.ResultStatus = -1; return result; } //获取合约 result = subDAL.Get(user, stockLog.SubContractId); if (result.ResultStatus != 0) return result; NFMT.Contract.Model.ContractSub sub = result.ReturnValue as NFMT.Contract.Model.ContractSub; if (sub == null || sub.SubId <= 0) { result.ResultStatus = -1; result.Message = "合约不存在"; return result; } if (sub.SubStatus != StatusEnum.已生效) { result.ResultStatus = -1; result.Message = "合约状态不允许分配收款"; return result; } //获取外部公司 result = corpDetailDAL.LoadCorpListByContractId(user, sub.ContractId, false); if (result.ResultStatus != 0) return result; List<NFMT.Contract.Model.ContractCorporationDetail> outCorps = result.ReturnValue as List<NFMT.Contract.Model.ContractCorporationDetail>; if (outCorps == null) { result.Message = "合约对方抬头获取失败"; result.ResultStatus = -1; return result; } foreach (Model.CashInStcok detail in details) { //收款登记验证 result = cashInDAL.Get(user, detail.CashInId); if (result.ResultStatus != 0) return result; Model.CashIn cashIn = result.ReturnValue as Model.CashIn; if (cashIn == null || cashIn.CashInId <= 0) { result.Message = "收款登记不存在"; result.ResultStatus = -1; return result; } //收款登记与合约币种验证 if (cashIn.CurrencyId != sub.SettleCurrency) { result.Message = "收款登记币种与合约币种不相同"; result.ResultStatus = -1; return result; } //获取合约收款分配 result = cashInContractDAL.Get(user, detail.ContractRefId); if (result.ResultStatus != 0) return result; Model.CashInContract cashInContract = result.ReturnValue as Model.CashInContract; if (cashInContract == null || cashInContract.RefId <= 0) { result.Message = "收款分配失败"; result.ResultStatus = -1; return result; } if (cashInContract.DetailStatus != StatusEnum.已生效) { result.Message = "收款分配失败"; result.ResultStatus = -1; return result; } //获取公司收款分配 result = cashInCorpDAL.Get(user, cashInContract.CorpRefId); if (result.ResultStatus != 0) return result; Model.CashInCorp cashInCorp = result.ReturnValue as Model.CashInCorp; if (cashInCorp == null || cashInCorp.RefId <= 0 || cashInCorp.DetailStatus != StatusEnum.已生效) { result.Message = "收款分配失败"; result.ResultStatus = -1; return result; } //验证公司抬头 if (!outCorps.Any(temp => temp.CorpId == cashInCorp.CorpId)) { result.Message = "收款分配公司不在合约对方抬头,收款分配失败"; result.ResultStatus = -1; return result; } //新增库存收款分配 detail.AllotId = cashInContract.AllotId; detail.CashInId = cashInContract.CashInId; detail.ContractRefId = cashInContract.RefId; detail.CorpRefId = cashInContract.CorpRefId; detail.DetailStatus = StatusEnum.已生效; detail.StockId = stock.StockId; detail.StockLogId = stockLog.StockLogId; detail.StockNameId = stock.StockNameId; result = this.cashinstcokDAL.Insert(user, detail); if (result.ResultStatus != 0) return result; } scope.Complete(); } } catch (Exception ex) { result.Message = ex.Message; result.ResultStatus = -1; } return result; }
public ResultModel CreateDirectStock(UserModel user, Model.CashInAllot allot, List<Model.CashInCorp> details, int stockLogId) { ResultModel result = new ResultModel(); try { NFMT.WareHouse.DAL.StockLogDAL stockLogDAL = new WareHouse.DAL.StockLogDAL(); NFMT.WareHouse.DAL.StockDAL stockDAL = new WareHouse.DAL.StockDAL(); NFMT.Contract.DAL.ContractSubDAL subDAL = new Contract.DAL.ContractSubDAL(); DAL.CashInAllotDAL allotDAL = new CashInAllotDAL(); DAL.CashInDAL cashInDAL = new CashInDAL(); DAL.CashInCorpDAL cashInCorpDAL = new CashInCorpDAL(); DAL.CashInContractDAL cashInContractDAL = new CashInContractDAL(); using (System.Transactions.TransactionScope scope = new TransactionScope()) { //获取库存流水 result = stockLogDAL.Get(user, stockLogId); if (result.ResultStatus != 0) return result; NFMT.WareHouse.Model.StockLog stockLog = result.ReturnValue as NFMT.WareHouse.Model.StockLog; if (stockLog == null || stockLog.StockLogId <= 0) { result.Message = "库存流水不存在"; result.ResultStatus = -1; return result; } //获取库存 result = stockDAL.Get(user, stockLog.StockId); if (result.ResultStatus != 0) return result; NFMT.WareHouse.Model.Stock stock = result.ReturnValue as NFMT.WareHouse.Model.Stock; if (stock == null || stock.StockId <= 0) { result.Message = "库存不存在"; result.ResultStatus = -1; return result; } //获取子合约 result = subDAL.Get(user, stockLog.SubContractId); if (result.ResultStatus != 0) return result; NFMT.Contract.Model.ContractSub sub = result.ReturnValue as NFMT.Contract.Model.ContractSub; if (sub == null || sub.SubId <= 0) { result.Message = "子合约不存在"; result.ResultStatus = -1; return result; } allot.AllotBala = details.Sum(temp => temp.AllotBala); allot.Alloter = user.EmpId; allot.AllotStatus = StatusEnum.已录入; allot.AllotTime = DateTime.Now; allot.AllotType = (int)NFMT.Funds.CashInAllotTypeEnum.Stock; allot.CurrencyId = sub.SettleCurrency; result = allotDAL.Insert(user, allot); if (result.ResultStatus != 0) return result; int allotId = 0; if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out allotId) || allotId <= 0) { result.Message = "收款分配新增失败"; result.ResultStatus = -1; return result; } //获取外部公司 NFMT.Contract.DAL.ContractCorporationDetailDAL corpDAL = new Contract.DAL.ContractCorporationDetailDAL(); result = corpDAL.LoadCorpListByContractId(user, sub.ContractId, false); if (result.ResultStatus != 0) return result; List<NFMT.Contract.Model.ContractCorporationDetail> outCorps = result.ReturnValue as List<NFMT.Contract.Model.ContractCorporationDetail>; if (outCorps == null) { result.Message = "合约对方抬头获取失败"; result.ResultStatus = -1; return result; } foreach (Model.CashInCorp corpDetail in details) { NFMT.User.Model.Corporation corp = NFMT.User.UserProvider.Corporations.FirstOrDefault(temp => temp.CorpId == corpDetail.CorpId); if (corp == null || corp.CorpId <= 0) { result.Message = "收款分配公司不存在"; result.ResultStatus = -1; return result; } if (!outCorps.Any(temp => temp.CorpId == corp.CorpId)) { result.Message = "收款分配公司不在合约对方抬头,收款分配失败"; result.ResultStatus = -1; return result; } result = cashInDAL.Get(user, corpDetail.CashInId); if (result.ResultStatus != 0) return result; Model.CashIn cashIn = result.ReturnValue as Model.CashIn; if (cashIn == null || cashIn.CashInId <= 0) { result.Message = "收款登记不存在"; result.ResultStatus = -1; return result; } if (cashIn.CurrencyId != sub.SettleCurrency) { result.Message = "收款登记币种与合约币种不相同"; result.ResultStatus = -1; return result; } corpDetail.AllotId = allotId; corpDetail.BlocId = corp.ParentId; corpDetail.CashInId = cashIn.CashInId; corpDetail.CorpId = corp.CorpId; corpDetail.DetailStatus = StatusEnum.已生效; corpDetail.IsShare = false; result = cashInCorpDAL.Insert(user, corpDetail); if (result.ResultStatus != 0) return result; int corpRefId = 0; if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out corpRefId) || corpRefId <= 0) { result.Message = "收款分配新增失败"; result.ResultStatus = -1; return result; } Model.CashInContract cashInContract = new CashInContract(); cashInContract.AllotBala = corpDetail.AllotBala; cashInContract.AllotId = corpDetail.AllotId; cashInContract.CashInId = corpDetail.CashInId; cashInContract.ContractId = sub.ContractId; cashInContract.CorpRefId = corpRefId; cashInContract.DetailStatus = StatusEnum.已生效; cashInContract.SubContractId = sub.SubId; result = cashInContractDAL.Insert(user, cashInContract); if (result.ResultStatus != 0) return result; int contractRefId = 0; if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out contractRefId) || contractRefId <= 0) { result.Message = "收款分配新增失败"; result.ResultStatus = -1; return result; } Model.CashInStcok cashInStock = new CashInStcok(); cashInStock.AllotBala = cashInContract.AllotBala; cashInStock.AllotId = cashInContract.AllotId; cashInStock.CashInId = cashInContract.CashInId; cashInStock.ContractRefId = contractRefId; cashInStock.CorpRefId = cashInContract.CorpRefId; cashInStock.DetailStatus = StatusEnum.已生效; cashInStock.StockId = stockLog.StockId; cashInStock.StockLogId = stockLog.StockLogId; cashInStock.StockNameId = stockLog.StockNameId; result = this.cashinstcokDAL.Insert(user, cashInStock); if (result.ResultStatus != 0) return result; } scope.Complete(); } } catch (Exception ex) { result.ResultStatus = -1; result.Message = ex.Message; } return result; }
public ResultModel UpdateReplaceOrder(UserModel user, Model.DocumentOrder order, List<NFMT.Document.Model.OrderReplaceStock> stockInvoices, NFMT.Document.Model.DocumentOrderDetail detail) { ResultModel result = new ResultModel(); try { DAL.DocumentOrderDetailDAL orderDetailDAL = new DocumentOrderDetailDAL(); DAL.DocumentOrderStockDAL orderStockDAL = new DocumentOrderStockDAL(); DAL.DocumentOrderInvoiceDAL orderInvoiceDAL = new DocumentOrderInvoiceDAL(); NFMT.WareHouse.DAL.StockDAL stockDAL = new WareHouse.DAL.StockDAL(); NFMT.WareHouse.DAL.StockNameDAL stockNameDAL = new WareHouse.DAL.StockNameDAL(); NFMT.Contract.DAL.ContractSubDAL subDAL = new Contract.DAL.ContractSubDAL(); NFMT.Contract.DAL.ContractDAL contractDAL = new Contract.DAL.ContractDAL(); NFMT.Contract.DAL.ContractCorporationDetailDAL corpDetailDAL = new Contract.DAL.ContractCorporationDetailDAL(); using (System.Transactions.TransactionScope scope = new TransactionScope()) { if (order == null) { result.Message = "制单指令不包含任何数据"; result.ResultStatus = -1; return result; } //验证制单指令 result = this.documentorderDAL.Get(user, order.OrderId); if (result.ResultStatus != 0) return result; Model.DocumentOrder resultOrder = result.ReturnValue as Model.DocumentOrder; if (resultOrder == null || resultOrder.OrderId <= 0) { result.Message = "制单指令不存在"; result.ResultStatus = -1; return result; } resultOrder.OrderDate = order.OrderDate; resultOrder.BankCode = order.BankCode; resultOrder.GrossAmount = order.GrossAmount; resultOrder.NetAmount = order.NetAmount; resultOrder.Bundles = order.Bundles; resultOrder.UnitPrice = order.UnitPrice; resultOrder.InvBala = order.InvBala; resultOrder.InvGap = order.InvGap; resultOrder.Meno = order.Meno; //更新主表 result = this.documentorderDAL.Update(user, resultOrder); if (result.ResultStatus != 0) return result; //获取明细表 result = orderDetailDAL.GetByOrderId(user, resultOrder.OrderId); if (result.ResultStatus != 0) return result; Model.DocumentOrderDetail resultDetail = result.ReturnValue as Model.DocumentOrderDetail; if (resultDetail == null || resultDetail.DetailId <= 0) { result.Message = "制单指令明细获取失败"; result.ResultStatus = -1; return result; } resultDetail.InvoiceCopies = detail.InvoiceCopies; resultDetail.InvoiceSpecific = detail.InvoiceSpecific; resultDetail.QualityCopies = detail.QualityCopies; resultDetail.QualitySpecific = detail.QualitySpecific; resultDetail.WeightCopies = detail.WeightCopies; resultDetail.WeightSpecific = detail.WeightSpecific; resultDetail.TexCopies = detail.TexCopies; resultDetail.TexSpecific = detail.TexSpecific; resultDetail.DeliverCopies = detail.DeliverCopies; resultDetail.DeliverSpecific = detail.DeliverSpecific; resultDetail.TotalInvCopies = detail.TotalInvCopies; resultDetail.TotalInvSpecific = detail.TotalInvSpecific; result = orderDetailDAL.Update(user, resultDetail); if (result.ResultStatus != 0) return result; //作废库存明细与发票明细 result = orderInvoiceDAL.Load(user, resultOrder.OrderId); if (result.ResultStatus != 0) return result; List<Model.DocumentOrderInvoice> orderInvoices = result.ReturnValue as List<Model.DocumentOrderInvoice>; if (orderInvoices == null) { result.Message = "制单指令发票明细获取失败"; result.ResultStatus = -1; return result; } foreach (Model.DocumentOrderInvoice orderInvoice in orderInvoices) { result = orderInvoiceDAL.Invalid(user, orderInvoice); if (result.ResultStatus != 0) return result; } result = orderStockDAL.Load(user, resultOrder.OrderId); if (result.ResultStatus != 0) return result; List<Model.DocumentOrderStock> orderStocks = result.ReturnValue as List<Model.DocumentOrderStock>; if (orderStocks == null) { result.Message = "制单指令库存明细获取失败"; result.ResultStatus = -1; return result; } foreach (Model.DocumentOrderStock orderStock in orderStocks) { result = orderStockDAL.Invalid(user, orderStock); if (result.ResultStatus != 0) return result; } OrderTypeEnum orderType = (OrderTypeEnum)resultOrder.OrderType; //新增库存明细与发票明细 foreach (Model.OrderReplaceStock stockInvoice in stockInvoices) { //验证临票库存明细 result = orderStockDAL.Get(user, stockInvoice.DetailId); if (result.ResultStatus != 0) return result; Model.DocumentOrderStock commercialOrderStock = result.ReturnValue as Model.DocumentOrderStock; if (commercialOrderStock == null || commercialOrderStock.OrderId <= 0) { result.Message = "制单指令替临库存不存在"; result.ResultStatus = -1; return result; } if (commercialOrderStock.DetailStatus != StatusEnum.已生效) { result.Message = "制单指令替临库存状态不正确"; result.ResultStatus = -1; return result; } if (commercialOrderStock.OrderId != resultOrder.CommercialId) { result.Message = "制单指令替临库存不存在"; result.ResultStatus = -1; return result; } Model.DocumentOrderStock orderStock = new DocumentOrderStock(); orderStock.DetailStatus = StatusEnum.已生效; orderStock.OrderId = resultOrder.OrderId; orderStock.ApplyAmount = stockInvoice.ApplyWeight; orderStock.StockId = commercialOrderStock.StockId; orderStock.StockNameId = commercialOrderStock.StockNameId; orderStock.RefNo = commercialOrderStock.RefNo; orderStock.ComDetailId = commercialOrderStock.DetailId; //添加库存明细 int orderStockId = 0; result = orderStockDAL.Insert(user, orderStock); if (result.ResultStatus != 0) return result; if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out orderStockId) || orderStockId <= 0) { result.Message = "制单指令库存明细新增失败"; result.ResultStatus = -1; return result; } //添加发票明细 Model.DocumentOrderInvoice orderInvoice = new DocumentOrderInvoice(); orderInvoice.DetailStatus = StatusEnum.已生效; orderInvoice.InvoiceBala = stockInvoice.InvoiceBala; orderInvoice.InvoiceNo = stockInvoice.InvoiceNo; orderInvoice.OrderId = resultOrder.OrderId; orderInvoice.StockDetailId = orderStockId; result = orderInvoiceDAL.Insert(user, orderInvoice); if (result.ResultStatus != 0) return result; } if (result.ResultStatus == 0) result.ReturnValue = resultOrder; scope.Complete(); } } catch (Exception ex) { result.ResultStatus = -1; result.Message = ex.Message; } return result; }
public ResultModel CreateReplaceOrder(UserModel user, Model.DocumentOrder order, List<NFMT.Document.Model.OrderReplaceStock> stockInvoices, NFMT.Document.Model.DocumentOrderDetail detail, bool isSubmitAudit) { ResultModel result = new ResultModel(); try { DAL.DocumentOrderDetailDAL orderDetailDAL = new DocumentOrderDetailDAL(); DAL.DocumentOrderStockDAL orderStockDAL = new DocumentOrderStockDAL(); DAL.DocumentOrderInvoiceDAL orderInvoiceDAL = new DocumentOrderInvoiceDAL(); NFMT.WareHouse.DAL.StockDAL stockDAL = new WareHouse.DAL.StockDAL(); NFMT.WareHouse.DAL.StockNameDAL stockNameDAL = new WareHouse.DAL.StockNameDAL(); NFMT.Contract.DAL.ContractSubDAL subDAL = new Contract.DAL.ContractSubDAL(); NFMT.Contract.DAL.ContractDAL contractDAL = new Contract.DAL.ContractDAL(); NFMT.Contract.DAL.ContractCorporationDetailDAL corpDetailDAL = new Contract.DAL.ContractCorporationDetailDAL(); using (System.Transactions.TransactionScope scope = new TransactionScope()) { if (order == null) { result.Message = "制单指令不包含任何数据"; result.ResultStatus = -1; return result; } //验证临票指令 result = this.documentorderDAL.Get(user, order.CommercialId); if (result.ResultStatus != 0) return result; Model.DocumentOrder commercialOrder = result.ReturnValue as Model.DocumentOrder; if (commercialOrder == null || commercialOrder.OrderId <= 0) { result.Message = "临票制单指令不存在"; result.ResultStatus = -1; return result; } if (commercialOrder.OrderStatus != StatusEnum.已生效) { result.Message = "临票制单指令状态不正确,不能替临"; result.ResultStatus = -1; return result; } //验证合约 result = contractDAL.Get(user, order.ContractId); if (result.ResultStatus != 0) return result; NFMT.Contract.Model.Contract contract = result.ReturnValue as NFMT.Contract.Model.Contract; if (contract == null || contract.ContractId <= 0) { result.Message = "合约不存在"; result.ResultStatus = -1; return result; } //验证子合约 result = subDAL.Get(user, order.SubId); if (result.ResultStatus != 0) return result; NFMT.Contract.Model.ContractSub sub = result.ReturnValue as NFMT.Contract.Model.ContractSub; if (sub == null || sub.SubId <= 0) { result.Message = "子合约不存在"; result.ResultStatus = -1; return result; } if (sub.SubStatus != StatusEnum.已生效) { result.Message = "子合约非已生效状态,不能进行制单指令新增"; result.ResultStatus = -1; return result; } if (sub.ContractId != order.ContractId) { result.Message = "子合约归属主合约与制单指令主合约不一致"; result.ResultStatus = -1; return result; } result = corpDetailDAL.LoadCorpListByContractId(user, sub.ContractId, true); if (result.ResultStatus != 0) return result; List<NFMT.Contract.Model.ContractCorporationDetail> corps = result.ReturnValue as List<NFMT.Contract.Model.ContractCorporationDetail>; if (corps == null || corps.Count == 0) { result.Message = "合约我方抬头获取失败"; result.ResultStatus = -1; return result; } int orderId = 0; //制单指令主表数据初始化 //付款方式默认为LC order.PaymentStyle = 19; //卖方默认为合约我方抬头默认公司 order.SellerCorp = corps[0].CorpId; ////临票制单或直接终票制单,临终发票差额为0 //order.InvGap = 0; //LC未加入时LC序号为0 order.LCId = 0; order.ApplyEmpId = user.EmpId; //新增主表 order.OrderStatus = StatusEnum.已录入; result = this.documentorderDAL.Insert(user, order); if (result.ResultStatus != 0) return result; if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out orderId) || orderId <= 0) { result.Message = "制单指令新增失败"; result.ResultStatus = -1; return result; } order.OrderId = orderId; //新增明细表 detail.OrderId = orderId; detail.DetailStatus = StatusEnum.已生效; result = orderDetailDAL.Insert(user, detail); if (result.ResultStatus != 0) return result; //临票指令类型,区分是否分配库存 OrderTypeEnum orderType = (OrderTypeEnum)commercialOrder.OrderType; //新增库存明细与发票明细 foreach (Model.OrderReplaceStock stockInvoice in stockInvoices) { //添加库存明细 Model.DocumentOrderStock orderStock = new DocumentOrderStock(); orderStock.DetailStatus = StatusEnum.已生效; orderStock.OrderId = orderId; orderStock.ApplyAmount = stockInvoice.ApplyWeight; orderStock.ComDetailId = stockInvoice.DetailId; //验证临票库存明细是否存在 result = orderStockDAL.Get(user,stockInvoice.DetailId); if (result.ResultStatus != 0) return result; Model.DocumentOrderStock commercialOrderStock = result.ReturnValue as Model.DocumentOrderStock; if (commercialOrderStock == null || commercialOrderStock.DetailId <= 0) { result.Message = "替换的库存明细不存在"; result.ResultStatus = -1; return result; } if (commercialOrderStock.DetailStatus != StatusEnum.已生效) { result.Message = "替换的库存状态不正确"; result.ResultStatus = -1; return result; } int orderStockId = 0; orderStock.StockId = commercialOrderStock.StockId; orderStock.StockNameId = commercialOrderStock.StockNameId; orderStock.RefNo = commercialOrderStock.RefNo; result = orderStockDAL.Insert(user, orderStock); if (result.ResultStatus != 0) return result; if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out orderStockId) || orderStockId <= 0) { result.Message = "制单指令库存明细新增失败"; result.ResultStatus = -1; return result; } //添加发票明细 Model.DocumentOrderInvoice orderInvoice = new DocumentOrderInvoice(); orderInvoice.DetailStatus = StatusEnum.已生效; orderInvoice.InvoiceBala = stockInvoice.InvoiceBala; orderInvoice.InvoiceNo = stockInvoice.InvoiceNo; orderInvoice.OrderId = orderId; orderInvoice.StockDetailId = orderStockId; result = orderInvoiceDAL.Insert(user, orderInvoice); if (result.ResultStatus != 0) return result; } if (isSubmitAudit) { NFMT.WorkFlow.AutoSubmit submit = new WorkFlow.AutoSubmit(); NFMT.WorkFlow.ITaskProvider taskProvider = new TaskProvider.OrderTaskProvider(); result = submit.Submit(user, order, taskProvider, WorkFlow.MasterEnum.制单指令审核); if (result.ResultStatus != 0) return result; } if (result.ResultStatus == 0) result.ReturnValue = order; scope.Complete(); } } catch (Exception ex) { result.ResultStatus = -1; result.Message = ex.Message; } return result; }
public ResultModel Update(UserModel user, Model.DocumentOrder order, List<NFMT.Document.Model.OrderStockInvoice> stockInvoices, NFMT.Document.Model.DocumentOrderDetail detail) { ResultModel result = new ResultModel(); try { DAL.DocumentOrderDetailDAL orderDetailDAL = new DocumentOrderDetailDAL(); DAL.DocumentOrderStockDAL orderStockDAL = new DocumentOrderStockDAL(); DAL.DocumentOrderInvoiceDAL orderInvoiceDAL = new DocumentOrderInvoiceDAL(); NFMT.WareHouse.DAL.StockDAL stockDAL = new WareHouse.DAL.StockDAL(); NFMT.WareHouse.DAL.StockNameDAL stockNameDAL = new WareHouse.DAL.StockNameDAL(); NFMT.Contract.DAL.ContractSubDAL subDAL = new Contract.DAL.ContractSubDAL(); NFMT.Contract.DAL.ContractDAL contractDAL = new Contract.DAL.ContractDAL(); NFMT.Contract.DAL.ContractCorporationDetailDAL corpDetailDAL = new Contract.DAL.ContractCorporationDetailDAL(); using (System.Transactions.TransactionScope scope = new TransactionScope()) { if (order == null) { result.Message = "制单指令不包含任何数据"; result.ResultStatus = -1; return result; } //验证制单指令 result = this.documentorderDAL.Get(user, order.OrderId); if (result.ResultStatus != 0) return result; Model.DocumentOrder resultOrder = result.ReturnValue as Model.DocumentOrder; if (resultOrder == null || resultOrder.OrderId <= 0) { result.Message = "制单指令不存在"; result.ResultStatus = -1; return result; } resultOrder.ContractNo = order.ContractNo; resultOrder.LCNo = order.LCNo; resultOrder.LCDay = order.LCDay; resultOrder.OrderType = order.OrderType; resultOrder.OrderDate = order.OrderDate; resultOrder.ApplyCorp = order.ApplyCorp; resultOrder.ApplyDept = order.ApplyDept; resultOrder.BuyerCorp = order.BuyerCorp; resultOrder.BuyerCorpName = order.BuyerCorpName; resultOrder.BuyerAddress = order.BuyerAddress; resultOrder.RecBankId = order.RecBankId; resultOrder.DiscountBase = order.DiscountBase; resultOrder.AssetId = order.AssetId; resultOrder.BrandId = order.BrandId; resultOrder.AreaName = order.AreaName; resultOrder.BankCode = order.BankCode; resultOrder.GrossAmount = order.GrossAmount; resultOrder.NetAmount = order.NetAmount; resultOrder.UnitId = order.UnitId; resultOrder.Bundles = order.Bundles; resultOrder.Currency = order.Currency; resultOrder.UnitPrice = order.UnitPrice; resultOrder.InvBala = order.InvBala; resultOrder.Meno = order.Meno; //更新主表 result = this.documentorderDAL.Update(user, resultOrder); if (result.ResultStatus != 0) return result; //获取明细表 result = orderDetailDAL.GetByOrderId(user, order.OrderId); if (result.ResultStatus != 0) return result; Model.DocumentOrderDetail resultDetail = result.ReturnValue as Model.DocumentOrderDetail; if (resultDetail == null || resultDetail.DetailId <= 0) { result.Message = "制单指令明细获取失败"; result.ResultStatus = -1; return result; } resultDetail.InvoiceCopies = detail.InvoiceCopies; resultDetail.InvoiceSpecific = detail.InvoiceSpecific; resultDetail.QualityCopies = detail.QualityCopies; resultDetail.QualitySpecific = detail.QualitySpecific; resultDetail.WeightCopies = detail.WeightCopies; resultDetail.WeightSpecific = detail.WeightSpecific; resultDetail.TexCopies = detail.TexCopies; resultDetail.TexSpecific = detail.TexSpecific; resultDetail.DeliverCopies = detail.DeliverCopies; resultDetail.DeliverSpecific = detail.DeliverSpecific; resultDetail.TotalInvCopies = detail.TotalInvCopies; resultDetail.TotalInvSpecific = detail.TotalInvSpecific; result = orderDetailDAL.Update(user, resultDetail); if (result.ResultStatus != 0) return result; //作废库存明细与发票明细 result = orderInvoiceDAL.Load(user, order.OrderId); if (result.ResultStatus != 0) return result; List<Model.DocumentOrderInvoice> orderInvoices = result.ReturnValue as List<Model.DocumentOrderInvoice>; if (orderInvoices == null) { result.Message = "制单指令发票明细获取失败"; result.ResultStatus = -1; return result; } foreach (Model.DocumentOrderInvoice orderInvoice in orderInvoices) { result = orderInvoiceDAL.Invalid(user, orderInvoice); if (result.ResultStatus != 0) return result; } result = orderStockDAL.Load(user,order.OrderId); if(result.ResultStatus!=0) return result; List<Model.DocumentOrderStock> orderStocks = result.ReturnValue as List<Model.DocumentOrderStock>; if (orderStocks == null) { result.Message = "制单指令库存明细获取失败"; result.ResultStatus = -1; return result; } foreach (Model.DocumentOrderStock orderStock in orderStocks) { result = orderStockDAL.Invalid(user, orderStock); if (result.ResultStatus != 0) return result; } OrderTypeEnum orderType = (OrderTypeEnum)order.OrderType; //新增库存明细与发票明细 foreach (Model.OrderStockInvoice stockInvoice in stockInvoices) { Model.DocumentOrderStock orderStock = new DocumentOrderStock(); orderStock.DetailStatus = StatusEnum.已生效; orderStock.OrderId = order.OrderId; orderStock.ApplyAmount = stockInvoice.ApplyWeight; //库存分配制单指令校验库存信息 if (orderType == OrderTypeEnum.临票制单指令 || orderType == OrderTypeEnum.替临制单指令) { //验证库存 result = stockDAL.Get(user, stockInvoice.StockId); if (result.ResultStatus != 0) return result; NFMT.WareHouse.Model.Stock stock = result.ReturnValue as NFMT.WareHouse.Model.Stock; if (stock == null || stock.StockId <= 0) { result.Message = "制单指令分配库存不存在"; result.ResultStatus = -1; return result; } if (stock.AssetId != order.AssetId) { result.Message = "库存品种不匹配"; result.ResultStatus = -1; return result; } if (stock.CurNetAmount < stockInvoice.ApplyWeight) { result.Message = "申请重量不能大于库存剩余净重"; result.ResultStatus = -1; return result; } //获取业务单号 result = stockNameDAL.Get(user, stock.StockNameId); if (result.ResultStatus != 0) return result; NFMT.WareHouse.Model.StockName stockName = result.ReturnValue as NFMT.WareHouse.Model.StockName; if (stockName == null || stockName.StockNameId <= 0) { result.Message = "业务单号不存在"; result.ResultStatus = -1; return result; } orderStock.StockId = stock.StockId; orderStock.StockNameId = stock.StockNameId; orderStock.RefNo = stockName.RefNo; } else { //无库存配货权录入业务单号 orderStock.RefNo = stockInvoice.RefNo; } //添加库存明细 int orderStockId = 0; result = orderStockDAL.Insert(user, orderStock); if (result.ResultStatus != 0) return result; if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out orderStockId) || orderStockId <= 0) { result.Message = "制单指令库存明细新增失败"; result.ResultStatus = -1; return result; } //添加发票明细 Model.DocumentOrderInvoice orderInvoice = new DocumentOrderInvoice(); orderInvoice.DetailStatus = StatusEnum.已生效; orderInvoice.InvoiceBala = stockInvoice.InvoiceBala; orderInvoice.InvoiceNo = stockInvoice.InvoiceNo; orderInvoice.OrderId = order.OrderId; orderInvoice.StockDetailId = orderStockId; result = orderInvoiceDAL.Insert(user, orderInvoice); if (result.ResultStatus != 0) return result; } if (result.ResultStatus == 0) result.ReturnValue = order; scope.Complete(); } } catch (Exception ex) { result.ResultStatus = -1; result.Message = ex.Message; } return result; }