public ResultModel Complete(UserModel user, int sIId)
{
ResultModel result = new ResultModel();
try
{
DAL.SIDAL sIDAL = new SIDAL();
NFMT.Operate.DAL.InvoiceDAL invoiceDAL = new Operate.DAL.InvoiceDAL();
DAL.SIDetailDAL detailDAL = new SIDetailDAL();
using (System.Transactions.TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
//获取财务票
result = sIDAL.Get(user, sIId);
if (result.ResultStatus != 0)
return result;
NFMT.Invoice.Model.SI sI = result.ReturnValue as NFMT.Invoice.Model.SI;
if (sI == null || sI.SIId <= 0)
{
result.ResultStatus = -1;
result.Message = "发票验证失败";
return result;
}
//获取发票
result = invoiceDAL.Get(user, sI.InvoiceId);
if (result.ResultStatus != 0)
return result;
NFMT.Operate.Model.Invoice invoice = result.ReturnValue as NFMT.Operate.Model.Invoice;
if (invoice == null || invoice.InvoiceId <= 0)
{
result.ResultStatus = -1;
result.Message = "发票获取失败";
return result;
}
//发票完成
result = invoiceDAL.Complete(user, invoice);
if (result.ResultStatus != 0)
return result;
//获取明细
result = detailDAL.Load(user, sI.SIId);
if (result.ResultStatus != 0)
return result;
List<Model.SIDetail> details = result.ReturnValue as List<Model.SIDetail>;
if (details == null)
{
result.ResultStatus = -1;
result.Message = "发票明细获取失败";
return result;
}
foreach (Model.SIDetail detail in details)
{
result = detailDAL.Complete(user, detail);
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, NFMT.Operate.Model.Invoice invoice, Model.SI si, List<Model.SIDetail> siDetails)
{
ResultModel result = new ResultModel();
NFMT.Operate.DAL.InvoiceDAL invoiceDAL = new Operate.DAL.InvoiceDAL();
DAL.SIDAL sIDAL = new SIDAL();
DAL.SIDetailDAL sIDetailDAL = new SIDetailDAL();
NFMT.User.DAL.CorporationDAL corporationDAL = new User.DAL.CorporationDAL();
try
{
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
//获取发票信息
result = invoiceDAL.Get(user, invoice.InvoiceId);
if (result.ResultStatus != 0)
return result;
NFMT.Operate.Model.Invoice resultObj = result.ReturnValue as NFMT.Operate.Model.Invoice;
if (resultObj == null || resultObj.InvoiceId <= 0)
{
result.Message = "获取发票信息失败";
result.ResultStatus = -1;
return result;
}
//获取公司信息
result = corporationDAL.Get(user, invoice.InCorpId);
if (result.ResultStatus != 0)
return result;
NFMT.User.Model.Corporation corp = result.ReturnValue as NFMT.User.Model.Corporation;
if (corp == null)
{
result.ResultStatus = -1;
result.Message = "公司信息不存在";
return result;
}
resultObj.InCorpName = corp.CorpName;
result = corporationDAL.Get(user, invoice.OutCorpId);
if (result.ResultStatus != 0)
return result;
corp = result.ReturnValue as NFMT.User.Model.Corporation;
if (corp == null)
{
result.ResultStatus = -1;
result.Message = "公司信息不存在";
return result;
}
resultObj.OutCorpName = corp.CorpName;
resultObj.InvoiceDate = invoice.InvoiceDate;
resultObj.InvoiceName = invoice.InvoiceName;
resultObj.InvoiceType = invoice.InvoiceType;
resultObj.InvoiceBala = invoice.InvoiceBala;
resultObj.CurrencyId = invoice.CurrencyId;
resultObj.InvoiceDirection = invoice.InvoiceDirection;
resultObj.OutCorpId = invoice.OutCorpId;
resultObj.InCorpId = invoice.InCorpId;
resultObj.Memo = invoice.Memo;
//更新发票信息
result = invoiceDAL.Update(user, resultObj);
if (result.ResultStatus != 0)
return result;
//更新价外票信息
result = sIDAL.Update(user, si);
if (result.ResultStatus != 0)
return result;
//作废价外票
result = sIDetailDAL.InvalidAll(user, si.SIId);
if (result.ResultStatus != 0)
return result;
foreach (Model.SIDetail detail in siDetails)
{
detail.SIId = si.SIId;
result = sIDetailDAL.Insert(user, detail);
if (result.ResultStatus != 0)
return result;
}
scope.Complete();
}
}
catch (Exception e)
{
result.ResultStatus = -1;
result.Message = e.Message;
}
return result;
}
public ResultModel Goback(UserModel user, int sIId)
{
ResultModel result = new ResultModel();
try
{
DAL.SIDAL sIDAL = new SIDAL();
NFMT.Operate.DAL.InvoiceDAL invoiceDAL = new Operate.DAL.InvoiceDAL();
using (System.Transactions.TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
//获取价外票
result = sIDAL.Get(user, sIId);
if (result.ResultStatus != 0)
return result;
NFMT.Invoice.Model.SI sI = result.ReturnValue as NFMT.Invoice.Model.SI;
if (sI == null || sI.SIId <= 0)
{
result.ResultStatus = -1;
result.Message = "发票验证失败";
return result;
}
//获取发票
result = invoiceDAL.Get(user, sI.InvoiceId);
if (result.ResultStatus != 0)
return result;
NFMT.Operate.Model.Invoice invoice = result.ReturnValue as NFMT.Operate.Model.Invoice;
if (invoice == null || invoice.InvoiceId <= 0)
{
result.ResultStatus = -1;
result.Message = "发票获取失败";
return result;
}
//撤返发票
result = invoiceDAL.Goback(user, invoice);
if (result.ResultStatus != 0)
return result;
//工作流任务关闭
WorkFlow.DAL.DataSourceDAL sourceDAL = new WorkFlow.DAL.DataSourceDAL();
result = sourceDAL.SynchronousStatus(user, invoice);
if (result.ResultStatus != 0)
return result;
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
public ResultModel Create(UserModel user, NFMT.Operate.Model.Invoice invoice, Model.SI si, List<Model.SIDetail> siDetails)
{
ResultModel result = new ResultModel();
NFMT.Operate.DAL.InvoiceDAL invoiceDAL = new Operate.DAL.InvoiceDAL();
DAL.SIDAL sIDAL = new SIDAL();
DAL.SIDetailDAL sIDetailDAL = new SIDetailDAL();
NFMT.User.DAL.CorporationDAL corporationDAL = new User.DAL.CorporationDAL();
try
{
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
result = corporationDAL.Get(user, invoice.InCorpId);
if (result.ResultStatus != 0)
return result;
NFMT.User.Model.Corporation corp = result.ReturnValue as NFMT.User.Model.Corporation;
if (corp == null)
{
result.ResultStatus = -1;
result.Message = "公司信息不存在";
return result;
}
invoice.InCorpName = corp.CorpName;
result = corporationDAL.Get(user, invoice.OutCorpId);
if (result.ResultStatus != 0)
return result;
corp = result.ReturnValue as NFMT.User.Model.Corporation;
if (corp == null)
{
result.ResultStatus = -1;
result.Message = "公司信息不存在";
return result;
}
invoice.OutCorpName = corp.CorpName;
result = invoiceDAL.Insert(user, invoice);
if (result.ResultStatus != 0)
return result;
int invoiceId = (int)result.ReturnValue;
si.InvoiceId = invoiceId;
result = sIDAL.Insert(user, si);
if (result.ResultStatus != 0)
return result;
int sIId = (int)result.ReturnValue;
foreach (Model.SIDetail detail in siDetails)
{
detail.SIId = sIId;
result = sIDetailDAL.Insert(user, detail);
if (result.ResultStatus != 0)
return result;
}
invoice.InvoiceId = invoiceId;
if (result.ResultStatus == 0) result.ReturnValue = invoice;
scope.Complete();
}
}
catch (Exception e)
{
result.ResultStatus = -1;
result.Message = e.Message;
}
return result;
}
public ResultModel PayApplyInvoiceUpdate(UserModel user, Apply apply, PayApply payApply, List<InvoicePayApply> details)
{
ResultModel result = new ResultModel();
try
{
InvoicePayApplyDAL invoicePayApplyDAL = new InvoicePayApplyDAL();
ApplyDAL applyDAL = new ApplyDAL();
PayApplyDAL payApplyDAL = new PayApplyDAL();
InvoiceDAL invoiceDAL = new InvoiceDAL();
SIDAL sIDAL = new SIDAL();
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
if (details == null || details.Count == 0)
{
result.ResultStatus = -1;
result.Message = "未选中任务发票";
return result;
}
//验证总额
decimal sumApplyBala = details.Sum(temp => temp.ApplyBala);
if (sumApplyBala != payApply.ApplyBala)
{
result.ResultStatus = -1;
result.Message = "申请总额与分项总额不相等";
return result;
}
//获取付款申请
result = this.payapplyDAL.Get(user, payApply.PayApplyId);
if (result.ResultStatus != 0)
return result;
PayApply resultPayApply = result.ReturnValue as PayApply;
if (resultPayApply == null || resultPayApply.PayApplyId <= 0)
{
result.ResultStatus = -1;
result.Message = "付款申请不存在";
return result;
}
//获取发票申请列表
result = invoicePayApplyDAL.Load(user, resultPayApply.PayApplyId);
if (result.ResultStatus != 0)
return result;
List<InvoicePayApply> resultDetails = result.ReturnValue as List<InvoicePayApply>;
if (resultDetails == null)
{
result.ResultStatus = -1;
result.Message = "付款申请发票明细列表获取失败";
return result;
}
//作废原有发票申请明细
foreach (InvoicePayApply detail in resultDetails)
{
detail.DetailStatus = StatusEnum.已录入;
result = invoicePayApplyDAL.Invalid(user, detail);
if (result.ResultStatus != 0)
return result;
}
//验证发票
int payDept = 0;
int outCorpId = 0;
foreach (InvoicePayApply detail in details)
{
//获取价外票
result = sIDAL.Get(user, detail.SIId);
if (result.ResultStatus != 0)
return result;
SI sI = result.ReturnValue as SI;
if (sI == null || sI.SIId <= 0)
{
result.ResultStatus = -1;
result.Message = "价外票不存在";
return result;
}
//获取发票
result = invoiceDAL.Get(user, detail.InvoiceId);
if (result.ResultStatus != 0)
return result;
Operate.Model.Invoice invoice = result.ReturnValue as Operate.Model.Invoice;
if (invoice == null || invoice.InvoiceId <= 0)
{
result.ResultStatus = -1;
result.Message = "发票不存在";
return result;
}
//验证币种
if (payApply.CurrencyId != invoice.CurrencyId)
{
result.ResultStatus = -1;
result.Message = "发票币种不一致";
return result;
}
//验证开票抬头
if (outCorpId == 0) { outCorpId = invoice.OutCorpId; }
if (outCorpId != invoice.OutCorpId)
{
result.ResultStatus = -1;
result.Message = "发票开票公司不一致";
return result;
}
//验证成本部门
if (payDept == 0) { payDept = sI.PayDept; }
if (payDept != sI.PayDept)
{
result.ResultStatus = -1;
result.Message = "发票成本部门不一致";
return result;
}
//验证可申请余额
result = invoicePayApplyDAL.LoadByInvoice(user, detail.InvoiceId);
if (result.ResultStatus != 0)
return result;
resultDetails = result.ReturnValue as List<InvoicePayApply>;
if (resultDetails == null)
{
result.ResultStatus = -1;
result.Message = "获取发票已申请列表失败";
return result;
}
decimal applyBala = resultDetails.Sum(temp => temp.ApplyBala);
if (applyBala >= invoice.InvoiceBala)
{
result.ResultStatus = -1;
result.Message = string.Format("发票{0}款项已全部申请", invoice.InvoiceNo);
return result;
}
if (invoice.InvoiceBala - applyBala < detail.ApplyBala)
{
result.ResultStatus = -1;
result.Message = string.Format("发票{0}申请金额超过可申请余额，申请失败", invoice.InvoiceNo);
return result;
}
}
//更新申请主表
Department dept = UserProvider.Departments.FirstOrDefault(temp => temp.DeptId == apply.ApplyDept);
if (dept == null || dept.DeptId < 0)
{
result.ResultStatus = -1;
result.Message = "申请部门不存在";
return result;
}
//获取主申请
result = applyDAL.Get(user, resultPayApply.ApplyId);
if (result.ResultStatus != 0)
return result;
Apply resultApply = result.ReturnValue as Apply;
if (resultApply == null || resultApply.ApplyId <= 0)
{
result.ResultStatus = -1;
result.Message = "主申请获取失败";
return result;
}
resultApply.ApplyDept = dept.DeptId;
resultApply.ApplyCorp = apply.ApplyCorp;
resultApply.ApplyDesc = apply.ApplyDesc;
resultApply.ApplyTime = apply.ApplyTime;
resultApply.EmpId = user.EmpId;
result = applyDAL.Update(user, resultApply);
if (result.ResultStatus != 0)
return result;
//更新付款申请表
resultPayApply.RecCorpId = payApply.RecCorpId;
resultPayApply.RecBankId = payApply.RecBankId;
resultPayApply.RecBankAccountId = payApply.RecBankAccountId;
resultPayApply.RecBankAccount = payApply.RecBankAccount;
resultPayApply.CurrencyId = payApply.CurrencyId;
resultPayApply.ApplyBala = sumApplyBala;
resultPayApply.PayMode = payApply.PayMode;
resultPayApply.PayDeadline = payApply.PayDeadline;
resultPayApply.PayMatter = payApply.PayMatter;
resultPayApply.SpecialDesc = payApply.SpecialDesc;
result = payapplyDAL.Update(user, resultPayApply);
if (result.ResultStatus != 0)
return result;
//新增发票付款申请关联表
foreach (InvoicePayApply detail in details)
{
detail.DetailStatus = StatusEnum.已生效;
detail.PayApplyId = resultPayApply.PayApplyId;
result = invoicePayApplyDAL.Insert(user, detail);
if (result.ResultStatus != 0)
return result;
}
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
public ResultModel PayApplyInvoiceCreate(UserModel user, Apply apply, PayApply payApply, List<InvoicePayApply> details)
{
ResultModel result = new ResultModel();
try
{
InvoicePayApplyDAL invoicePayApplyDAL = new InvoicePayApplyDAL();
ApplyDAL applyDAL = new ApplyDAL();
PayApplyDAL payApplyDAL = new PayApplyDAL();
InvoiceDAL invoiceDAL = new InvoiceDAL();
SIDAL sIDAL = new SIDAL();
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
if (details == null || details.Count == 0)
{
result.ResultStatus = -1;
result.Message = "未选中任务发票";
return result;
}
//验证总额
decimal sumApplyBala = details.Sum(temp => temp.ApplyBala);
if (sumApplyBala != payApply.ApplyBala)
{
result.ResultStatus = -1;
result.Message = "申请总额与分项总额不相等";
return result;
}
//验证发票
int payDept = 0;
int outCorpId = 0;
foreach (InvoicePayApply detail in details)
{
//获取价外票
result = sIDAL.Get(user, detail.SIId);
if (result.ResultStatus != 0)
return result;
SI sI = result.ReturnValue as SI;
if (sI == null || sI.SIId <= 0)
{
result.ResultStatus = -1;
result.Message = "价外票不存在";
return result;
}
//获取发票
result = invoiceDAL.Get(user, detail.InvoiceId);
if (result.ResultStatus != 0)
return result;
Operate.Model.Invoice invoice = result.ReturnValue as Operate.Model.Invoice;
if (invoice == null || invoice.InvoiceId <= 0)
{
result.ResultStatus = -1;
result.Message = "发票不存在";
return result;
}
//验证币种
if (payApply.CurrencyId != invoice.CurrencyId)
{
result.ResultStatus = -1;
result.Message = "发票币种不一致";
return result;
}
//验证开票抬头
if (outCorpId == 0) { outCorpId = invoice.OutCorpId; }
if (outCorpId != invoice.OutCorpId)
{
result.ResultStatus = -1;
result.Message = "发票开票公司不一致";
return result;
}
//验证成本部门
if (payDept == 0) { payDept = sI.PayDept; }
if (payDept != sI.PayDept)
{
result.ResultStatus = -1;
result.Message = "发票成本部门不一致";
return result;
}
//验证可申请余额
result = invoicePayApplyDAL.LoadByInvoice(user, detail.InvoiceId);
if (result.ResultStatus != 0)
return result;
List<InvoicePayApply> resultDetails = result.ReturnValue as List<InvoicePayApply>;
if (resultDetails == null)
{
result.ResultStatus = -1;
result.Message = "获取发票已申请列表失败";
return result;
}
decimal applyBala = resultDetails.Sum(temp => temp.ApplyBala);
if (applyBala >= invoice.InvoiceBala)
{
result.ResultStatus = -1;
result.Message = string.Format("发票{0}款项已全部申请", invoice.InvoiceNo);
return result;
}
if (invoice.InvoiceBala - applyBala < detail.ApplyBala)
{
result.ResultStatus = -1;
result.Message = string.Format("发票{0}申请金额超过可申请余额，申请失败", invoice.InvoiceNo);
return result;
}
}
//新增申请主表
Department dept = UserProvider.Departments.FirstOrDefault(temp => temp.DeptId == apply.ApplyDept);
if (dept == null || dept.DeptId < 0)
{
result.ResultStatus = -1;
result.Message = "申请部门不存在";
return result;
}
int applyId = 0;
apply.ApplyDept = dept.DeptId;
apply.ApplyType = ApplyType.付款申请;
apply.EmpId = user.EmpId;
apply.ApplyStatus = StatusEnum.已录入;
result = applyDAL.Insert(user, apply);
if (result.ResultStatus != 0)
return result;
if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out applyId))
{
result.ResultStatus = -1;
result.Message = "申请主表新增失败";
return result;
}
//新增付款申请表
payApply.ApplyId = applyId;
payApply.PayApplySource = (int)FundsStyleEnum.InvoicePayApply;
payApply.ApplyBala = sumApplyBala;
result = payapplyDAL.Insert(user, payApply);
if (result.ResultStatus != 0)
return result;
int payApplyId = 0;
if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out payApplyId))
{
result.ResultStatus = -1;
result.Message = "付款申请新增失败";
return result;
}
//新增发票付款申请关联表
foreach (InvoicePayApply detail in details)
{
detail.DetailStatus = StatusEnum.已生效;
detail.PayApplyId = payApplyId;
result = invoicePayApplyDAL.Insert(user, detail);
if (result.ResultStatus != 0)
return result;
}
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
