public ResultModel Acceptan(UserModel user, int documentId, DateTime acceptanceDate)
{
ResultModel result = new ResultModel();
try
{
DAL.DocumentStockDAL docStockDAL = new DocumentStockDAL();
DAL.DocumentInvoiceDAL docInvoiceDAL = new DocumentInvoiceDAL();
//承兑
using (System.Transactions.TransactionScope scope = new TransactionScope())
{
//校验制单
result = this.documentDAL.Get(user, documentId);
if (result.ResultStatus != 0)
return result;
Model.Document doc = result.ReturnValue as Model.Document;
if (doc == null || doc.DocumentId <= 0)
{
result.ResultStatus = -1;
result.Message = "制单不存在";
return result;
}
//更新制单
doc.AcceptanceDate = acceptanceDate;
doc.Acceptancer = user.EmpId;
result = this.documentDAL.Update(user, doc);
if (result.ResultStatus != 0)
return result;
result = this.documentDAL.Acceptan(user, doc);
if (result.ResultStatus != 0)
return result;
//获取库存与发票明细，并设置状态完成
result = docStockDAL.Load(user, doc.DocumentId);
if (result.ResultStatus != 0)
return result;
List<Model.DocumentStock> docStocks = result.ReturnValue as List<Model.DocumentStock>;
if (docStocks != null)
{
foreach (Model.DocumentStock docStock in docStocks)
{
result = docStockDAL.Complete(user, docStock);
if (result.ResultStatus != 0)
return result;
}
}
result = docInvoiceDAL.Load(user, doc.DocumentId);
if (result.ResultStatus != 0)
return result;
List<Model.DocumentInvoice> docInvoices = result.ReturnValue as List<Model.DocumentInvoice>;
if (docInvoices != null)
{
foreach (Model.DocumentInvoice docInvoice in docInvoices)
{
result = docInvoiceDAL.Complete(user, docInvoice);
if (result.ResultStatus != 0)
return result;
}
}
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
public ResultModel Invalid(UserModel user, int documentId)
{
ResultModel result = new ResultModel();
try
{
//作废制单主表
//作废制单库存明细
//作废制单发票明细
//作废出库执行
//作废发票
DAL.DocumentInvoiceDAL docInvoiceDAL = new DocumentInvoiceDAL();
DAL.DocumentStockDAL docStockDAL = new DocumentStockDAL();
using (System.Transactions.TransactionScope scope = new TransactionScope())
{
//校验制单
result = this.documentDAL.Get(user, documentId);
if (result.ResultStatus != 0)
return result;
Model.Document doc = result.ReturnValue as Model.Document;
if (doc == null || doc.DocumentId <= 0)
{
result.ResultStatus = -1;
result.Message = "制单不存在";
return result;
}
//作废制单主表
result = this.documentDAL.Invalid(user, doc);
if (result.ResultStatus != 0)
return result;
//获取所有库存明细
result = docStockDAL.Load(user, doc.DocumentId);
if (result.ResultStatus != 0)
return result;
List<Model.DocumentStock> docStocks = result.ReturnValue as List<Model.DocumentStock>;
if (docStocks == null)
{
result.ResultStatus = -1;
result.Message = "制单的库存明细获取失败";
return result;
}
foreach (Model.DocumentStock docStock in docStocks)
{
result = docStockDAL.Invalid(user, docStock);
if (result.ResultStatus != 0)
return result;
}
//获取所有发票明细并作废
result = docInvoiceDAL.Load(user, doc.DocumentId);
if (result.ResultStatus != 0)
return result;
List<Model.DocumentInvoice> docInvoices = result.ReturnValue as List<Model.DocumentInvoice>;
if (docInvoices == null)
{
result.ResultStatus = -1;
result.Message = "制单的发票明细获取失败";
return result;
}
foreach (Model.DocumentInvoice docInvoice in docInvoices)
{
result = docInvoiceDAL.Invalid(user, docInvoice);
if (result.ResultStatus != 0)
return result;
}
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
public ResultModel Update(UserModel user, Model.Document doc, List<Model.DocumentStock> docStocks)
{
ResultModel result = new ResultModel();
try
{
DAL.DocumentOrderDAL orderDAL = new DocumentOrderDAL();
DAL.DocumentOrderStockDAL orderStockDAL = new DocumentOrderStockDAL();
DAL.DocumentOrderInvoiceDAL orderInvoiceDAL = new DocumentOrderInvoiceDAL();
DAL.DocumentStockDAL docStockDAL = new DocumentStockDAL();
DAL.DocumentInvoiceDAL docInvoiceDAL = new DocumentInvoiceDAL();
Invoice.DAL.BusinessInvoiceDAL invoiceDAL = new Invoice.DAL.BusinessInvoiceDAL();
using (System.Transactions.TransactionScope scope = new TransactionScope())
{
if (doc == null || doc.DocumentId <= 0)
{
result.ResultStatus = -1;
result.Message = "制单信息错误";
return result;
}
if (docStocks == null || docStocks.Count == 0)
{
result.ResultStatus = -1;
result.Message = "未选择任何制单库存";
return result;
}
//获取制单
result = this.documentDAL.Get(user, doc.DocumentId);
if (result.ResultStatus != 0)
return result;
Model.Document resultDoc = result.ReturnValue as Model.Document;
if (resultDoc == null || resultDoc.DocumentId <= 0)
{
result.ResultStatus = -1;
result.Message = "制单不存在";
return result;
}
//获取指令
result = orderDAL.Get(user, resultDoc.OrderId);
if (result.ResultStatus != 0)
return result;
Model.DocumentOrder order = result.ReturnValue as Model.DocumentOrder;
if (order == null || order.OrderId <= 0)
{
result.ResultStatus = -1;
result.Message = "制单指令不存在";
return result;
}
//判断指令状态
if (order.OrderStatus != StatusEnum.已生效)
{
result.ResultStatus = -1;
result.Message = "制单指令非已生效状态，不能进行制单";
return result;
}
//新增制单
resultDoc.DocEmpId = user.EmpId;
resultDoc.DocumentDate = doc.DocumentDate;
resultDoc.Meno = doc.Meno;
result = this.documentDAL.Update(user, resultDoc);
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 || orderStocks.Count == 0)
{
result.ResultStatus = -1;
result.Message = "制单指令库存明细获取失败";
return result;
}
//获取当前制单所有库存明细与发票明细并作废
result = docStockDAL.Load(user, resultDoc.DocumentId);
if (result.ResultStatus != 0)
return result;
List<Model.DocumentStock> resultDocStocks = result.ReturnValue as List<Model.DocumentStock>;
if (resultDocStocks == null)
{
result.ResultStatus = -1;
result.Message = "制单库存明细获取失败";
return result;
}
foreach (Model.DocumentStock docStock in resultDocStocks)
{
result = docStockDAL.Invalid(user, docStock);
if (result.ResultStatus != 0)
return result;
}
result = docInvoiceDAL.Load(user,resultDoc.DocumentId);
if(result.ResultStatus!=0)
return result;
List<Model.DocumentInvoice> resultDocInvoices = result.ReturnValue as List<Model.DocumentInvoice>;
if (resultDocInvoices == null)
{
result.ResultStatus = -1;
result.Message = "制单发票明细获取失败";
return result;
}
foreach (Model.DocumentInvoice docInvoice in resultDocInvoices)
{
result = docInvoiceDAL.Invalid(user, docInvoice);
if (result.ResultStatus != 0)
return result;
}
//明细新增
foreach (Model.DocumentStock docStock in docStocks)
{
//验证选择明细是否在指令中
Model.DocumentOrderStock orderStock = orderStocks.FirstOrDefault(temp => temp.DetailId == docStock.DetailId);
if (orderStock == null || orderStock.DetailId <= 0)
{
result.ResultStatus = -1;
result.Message = "制单指令库存不存在";
return result;
}
//新增制单库存明细
Model.DocumentStock addDocStock = new DocumentStock();
addDocStock.DetailStatus = StatusEnum.已生效;
addDocStock.OrderId = resultDoc.OrderId;
addDocStock.OrderStockDetailId = orderStock.DetailId;
addDocStock.RefNo = orderStock.RefNo;
addDocStock.StockId = orderStock.StockId;
addDocStock.StockNameId = orderStock.StockNameId;
addDocStock.DocumentId = resultDoc.DocumentId;
result = docStockDAL.Insert(user, addDocStock);
if (result.ResultStatus != 0)
return result;
int docStockDetailId = 0;
if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out docStockDetailId) || docStockDetailId <= 0)
{
result.ResultStatus = -1;
result.Message = "制单库存明细新增失败";
return result;
}
addDocStock.DetailId = docStockDetailId;
//获取指令发票明细
result = orderInvoiceDAL.GetByStockDetailId(user, orderStock.DetailId);
if (result.ResultStatus != 0)
return result;
Model.DocumentOrderInvoice orderInvoice = result.ReturnValue as Model.DocumentOrderInvoice;
if (orderInvoice == null || orderInvoice.DetailId <= 0)
{
result.ResultStatus = -1;
result.Message = "制单指令发票明细不存在";
return result;
}
Model.DocumentInvoice docInvoice = new DocumentInvoice();
docInvoice.DetailStatus = StatusEnum.已生效;
docInvoice.DocumentId = resultDoc.DocumentId;
docInvoice.InvoiceNo = orderInvoice.InvoiceNo;
docInvoice.InvoiceBala = orderInvoice.InvoiceBala;
docInvoice.OrderId = resultDoc.OrderId;
docInvoice.OrderInvoiceDetailId = orderInvoice.DetailId;
docInvoice.StockDetailId = addDocStock.DetailId;
result = docInvoiceDAL.Insert(user, docInvoice);
if (result.ResultStatus != 0)
return result;
}
if (result.ResultStatus == 0)
result.ReturnValue = resultDoc;
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
public ResultModel Create(UserModel user, Model.Document doc, List<Model.DocumentStock> docStocks, bool isSubmitAudit)
{
ResultModel result = new ResultModel();
try
{
//新增制单主表
//新增制单库存明细表
//新增制单发票明细表
//新增发票
//提交审核
DAL.DocumentOrderDAL orderDAL = new DocumentOrderDAL();
DAL.DocumentOrderStockDAL orderStockDAL = new DocumentOrderStockDAL();
DAL.DocumentOrderInvoiceDAL orderInvoiceDAL = new DocumentOrderInvoiceDAL();
DAL.DocumentStockDAL docStockDAL = new DocumentStockDAL();
DAL.DocumentInvoiceDAL docInvoiceDAL = new DocumentInvoiceDAL();
Invoice.DAL.BusinessInvoiceDAL invoiceDAL = new Invoice.DAL.BusinessInvoiceDAL();
using (System.Transactions.TransactionScope scope = new TransactionScope())
{
if (doc == null || doc.OrderId <= 0)
{
result.ResultStatus = -1;
result.Message = "制单信息错误";
return result;
}
if (docStocks == null || docStocks.Count == 0)
{
result.ResultStatus = -1;
result.Message = "未选择任何制单库存";
return result;
}
//获取指令
result = orderDAL.Get(user, doc.OrderId);
if (result.ResultStatus != 0)
return result;
Model.DocumentOrder order = result.ReturnValue as Model.DocumentOrder;
if (order == null || order.OrderId <= 0)
{
result.ResultStatus = -1;
result.Message = "制单指令不存在";
return result;
}
//判断指令状态
if (order.OrderStatus != StatusEnum.已生效)
{
result.ResultStatus = -1;
result.Message = "制单指令非已生效状态，不能进行制单";
return result;
}
//新增制单
//doc.AcceptanceDate = DefaultValue.DefaultTime;
//doc.PresentDate = DefaultValue.DefaultTime;
doc.DocEmpId = user.EmpId;
doc.DocumentStatus = DocumentStatusEnum.已录入;
result = this.documentDAL.Insert(user, doc);
if (result.ResultStatus != 0)
return result;
int documentId = 0;
if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out documentId) || documentId <= 0)
{
result.ResultStatus = -1;
result.Message = "制单新增失败";
return result;
}
doc.DocumentId = documentId;
//获取当前指令所有库存明细
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 || orderStocks.Count == 0)
{
result.ResultStatus = -1;
result.Message = "制单指令库存明细获取失败";
return result;
}
//明细新增
foreach (Model.DocumentStock docStock in docStocks)
{
//验证选择明细是否在指令中
Model.DocumentOrderStock orderStock = orderStocks.FirstOrDefault(temp => temp.DetailId == docStock.DetailId);
if (orderStock == null || orderStock.DetailId<=0)
{
result.ResultStatus = -1;
result.Message = "制单指令库存不存在";
return result;
}
//新增制单库存明细
Model.DocumentStock addDocStock = new DocumentStock();
addDocStock.DetailStatus = StatusEnum.已生效;
addDocStock.DocumentId = documentId;
addDocStock.OrderId = order.OrderId;
addDocStock.OrderStockDetailId = orderStock.DetailId;
addDocStock.RefNo = orderStock.RefNo;
addDocStock.StockId = orderStock.StockId;
addDocStock.StockNameId = orderStock.StockNameId;
result = docStockDAL.Insert(user, addDocStock);
if (result.ResultStatus != 0)
return result;
int docStockDetailId = 0;
if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out docStockDetailId) || docStockDetailId <= 0)
{
result.ResultStatus = -1;
result.Message = "制单库存明细新增失败";
return result;
}
addDocStock.DetailId = docStockDetailId;
//获取指令发票明细
result = orderInvoiceDAL.GetByStockDetailId(user,orderStock.DetailId);
if (result.ResultStatus != 0)
return result;
Model.DocumentOrderInvoice orderInvoice = result.ReturnValue as Model.DocumentOrderInvoice;
if (orderInvoice == null || orderInvoice.DetailId <= 0)
{
result.ResultStatus = -1;
result.Message = "制单指令发票明细不存在";
return result;
}
Model.DocumentInvoice docInvoice = new DocumentInvoice();
docInvoice.DetailStatus = StatusEnum.已生效;
docInvoice.DocumentId = doc.DocumentId;
docInvoice.InvoiceNo = orderInvoice.InvoiceNo;
docInvoice.InvoiceBala =orderInvoice.InvoiceBala;
docInvoice.OrderId = order.OrderId;
docInvoice.OrderInvoiceDetailId = orderInvoice.DetailId;
docInvoice.StockDetailId = addDocStock.DetailId;
result = docInvoiceDAL.Insert(user, docInvoice);
if (result.ResultStatus != 0)
return result;
}
if (isSubmitAudit)
{
NFMT.WorkFlow.AutoSubmit submit = new WorkFlow.AutoSubmit();
NFMT.WorkFlow.ITaskProvider taskProvider = new TaskProvider.DocumentTaskProvider();
result = submit.Submit(user, doc, taskProvider, WorkFlow.MasterEnum.制单审核);
if (result.ResultStatus != 0)
return result;
}
if (result.ResultStatus == 0)
result.ReturnValue = doc;
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}