public void AddPVSpecialApply(int? RejectedFormID, int UserID, int? ProxyUserID, int? ProxyPositionID, int OrganizationUnitID, int PositionID, SystemEnums.FormType FormTypeID, SystemEnums.FormStatus StatusID,
DateTime FPeriod, int VendorID, int ItemCategoryID, int CurrencyID, decimal ExchangeRate, int PurchaseBudgetTypeID, int PurchaseTypeID, string Remark,
string AttachedFileName, string RealAttachedFileName, int MethodPaymentID, DateTime? ExpectPaymentDate, decimal TotalBudget, decimal ApprovedAmount, decimal ApprovingAmount,
decimal ReimbursedAmount, decimal NonReimbursedAmount, decimal RemainBudget, bool IsUrgent, bool IsPublic, int InvoiceStatusID, int PVType, int? VATRateID, decimal AMTTax, string PaymentTerms, bool IsPTChanged)
{
SqlTransaction transaction = null;
try {
//事务开始
transaction = TableAdapterHelper.BeginTransaction(this.TAForm);
TableAdapterHelper.SetTransaction(this.TAFormPV, transaction);
TableAdapterHelper.SetTransaction(this.TAFormInvoice, transaction);
TableAdapterHelper.SetTransaction(this.TAFormPVDetail, transaction);
//处理单据的内容
PurchaseDS.FormRow formRow = this.PurchaseDataSet.Form.NewFormRow();
if (RejectedFormID != null) {
formRow.RejectedFormID = RejectedFormID.GetValueOrDefault();
}
formRow.UserID = UserID;
UtilityBLL utility = new UtilityBLL();
if (StatusID == SystemEnums.FormStatus.Awaiting) {
string formTypeString = utility.GetFormTypeString((int)FormTypeID);
formRow.FormNo = utility.GetFormNo(formTypeString);
} else {
formRow.SetFormNoNull();
}
if (ProxyUserID != null) {
formRow.ProxyUserID = ProxyUserID.GetValueOrDefault();
}
if (ProxyPositionID != null) {
formRow.ProxyPositionID = ProxyPositionID.GetValueOrDefault();
}
formRow.OrganizationUnitID = OrganizationUnitID;
formRow.PositionID = PositionID;
formRow.FormTypeID = (int)FormTypeID;
formRow.StatusID = (int)StatusID;
formRow.SubmitDate = DateTime.Now;
formRow.LastModified = DateTime.Now;
formRow.InTurnUserIds = "P";//待改动
formRow.InTurnPositionIds = "P";//待改动
formRow.PageType = (int)SystemEnums.PageType.SpecialPV;
formRow.CostCenterID = new StuffUserBLL().GetCostCenterIDByPositionID(PositionID);
formRow.IsCreateVoucher = false;
formRow.IsExportLock = false;
formRow.IsCompletePayment = false;
this.PurchaseDataSet.Form.AddFormRow(formRow);
this.TAForm.Update(formRow);
//处理申请表的内容
PurchaseDS.FormPVRow formPVRow = this.PurchaseDataSet.FormPV.NewFormPVRow();
formPVRow.FormPVID = formRow.FormID;
formPVRow.FPeriod = FPeriod;
formPVRow.VendorID = VendorID;
formPVRow.ItemCategoryID = ItemCategoryID;
formPVRow.CurrencyID = CurrencyID;
formPVRow.ExchangeRate = ExchangeRate;
formPVRow.PurchaseBudgetTypeID = PurchaseBudgetTypeID;
formPVRow.PurchaseTypeID = PurchaseTypeID;
formPVRow.Remark = Remark;
if (AttachedFileName != null && AttachedFileName != string.Empty) {
formPVRow.AttachedFileName = AttachedFileName;
}
if (RealAttachedFileName != null && RealAttachedFileName != string.Empty) {
formPVRow.RealAttachedFileName = RealAttachedFileName;
}
formPVRow.MethodPaymentID = MethodPaymentID;
if (ExpectPaymentDate != null) {
formPVRow.ExpectPaymentDate = ExpectPaymentDate.GetValueOrDefault();
}
formPVRow.ApplyAmount = 0;
formPVRow.PayedAmount = 0;
formPVRow.Amount = 0;
formPVRow.AmountRMB = 0;
formPVRow.AMTBeforeTax = 0;
formPVRow.AMTTax = AMTTax;
formPVRow.TotalBudget = TotalBudget;
formPVRow.ApprovedAmount = ApprovedAmount;
formPVRow.ApprovingAmount = ApprovingAmount;
formPVRow.ReimbursedAmount = ReimbursedAmount;
formPVRow.NonReimbursedAmount = NonReimbursedAmount;
formPVRow.RemainBudget = RemainBudget;
formPVRow.IsUrgent = IsUrgent;
formPVRow.IsPublic = IsPublic;
formPVRow.InvoiceStatusID = InvoiceStatusID;
formPVRow.PVType = PVType;
if (VATRateID != null) {
formPVRow.VatRateID = VATRateID.GetValueOrDefault();
}
formPVRow.PaymentTerms = PaymentTerms;
formPVRow.IsPTChanged = IsPTChanged;
formPVRow.FinalItemCategoryID = ItemCategoryID;
this.PurchaseDataSet.FormPV.AddFormPVRow(formPVRow);
this.TAFormPV.Update(formPVRow);
//发票
if (RejectedFormID != null) {
PurchaseDS.FormInvoiceDataTable newInvoiceTable = new PurchaseDS.FormInvoiceDataTable();
foreach (PurchaseDS.FormInvoiceRow invoiceRow in this.PurchaseDataSet.FormInvoice) {
if (invoiceRow.RowState != DataRowState.Deleted) {
PurchaseDS.FormInvoiceRow newInvoiceRow = newInvoiceTable.NewFormInvoiceRow();
newInvoiceRow.FormID = formRow.FormID;
newInvoiceRow.InvoiceNo = invoiceRow.InvoiceNo;
newInvoiceRow.InvoiceDate = invoiceRow.InvoiceDate;
newInvoiceRow.InvoiceAmount = invoiceRow.InvoiceAmount;
newInvoiceRow.Remark = invoiceRow.IsRemarkNull() ? "" : invoiceRow.Remark;
newInvoiceRow.SystemInfo = invoiceRow.IsSystemInfoNull() ? "" : invoiceRow.SystemInfo;
newInvoiceTable.AddFormInvoiceRow(newInvoiceRow);
}
this.TAFormInvoice.Update(newInvoiceTable);
}
} else {
foreach (PurchaseDS.FormInvoiceRow invoiceRow in this.PurchaseDataSet.FormInvoice) {
// 与父表绑定
if (invoiceRow.RowState != DataRowState.Deleted) {
invoiceRow.FormID = formRow.FormID;
}
}
}
this.TAFormInvoice.Update(this.PurchaseDataSet.FormInvoice);
//处理明细
decimal totalAmount = 0;
decimal totalAmountRMB = 0;
if (RejectedFormID != null) {
PurchaseDS.FormPVDetailDataTable newPVDetailTable = new PurchaseDS.FormPVDetailDataTable();
foreach (PurchaseDS.FormPVDetailRow detailRow in this.PurchaseDataSet.FormPVDetail) {
if (detailRow.RowState != DataRowState.Deleted) {
PurchaseDS.FormPVDetailRow newPVDetailRow = newPVDetailTable.NewFormPVDetailRow();
newPVDetailRow.FormPVID = formRow.FormID;
newPVDetailRow.ItemID = detailRow.ItemID;
newPVDetailRow.ItemCode = detailRow.ItemCode;
newPVDetailRow.ItemName = detailRow.ItemName;
if (!detailRow.IsItemDescriptionNull()) {
newPVDetailRow.ItemDescription = detailRow.ItemDescription;
}
if (!detailRow.IsPackageNull()) {
newPVDetailRow.Package = detailRow.Package;
}
newPVDetailRow.UnitPrice = detailRow.UnitPrice;
newPVDetailRow.FinalPrice = detailRow.FinalPrice;
newPVDetailRow.Quantity = detailRow.Quantity;
newPVDetailRow.Amount = detailRow.Amount;
newPVDetailRow.AmountRMB = decimal.Round(detailRow.Amount * ExchangeRate, 2);
newPVDetailRow.DeliveryDate = detailRow.DeliveryDate;
newPVDetailTable.AddFormPVDetailRow(newPVDetailRow);
totalAmount = totalAmountRMB + newPVDetailRow.Amount;
totalAmountRMB = totalAmountRMB + newPVDetailRow.AmountRMB;
}
}
this.TAFormPVDetail.Update(newPVDetailTable);
} else {
foreach (PurchaseDS.FormPVDetailRow detailRow in this.PurchaseDataSet.FormPVDetail) {
if (detailRow.RowState != DataRowState.Deleted) {
detailRow.FormPVID = formRow.FormID;
detailRow.AmountRMB = decimal.Round(detailRow.Amount * ExchangeRate, 2);
totalAmountRMB = totalAmountRMB + detailRow.AmountRMB;
totalAmount = totalAmount + detailRow.Amount;
}
}
this.TAFormPVDetail.Update(this.PurchaseDataSet.FormPVDetail);
}
formPVRow.AmountRMB = totalAmountRMB;
formPVRow.Amount = totalAmount;
formPVRow.AMTBeforeTax = totalAmount - AMTTax;
this.TAFormPV.Update(formPVRow);
//作废之前的单据
if (RejectedFormID != null) {
PurchaseDS.FormRow oldRow = this.TAForm.GetDataByID(RejectedFormID.GetValueOrDefault())[0];
if (oldRow.StatusID == (int)SystemEnums.FormStatus.Rejected) {
oldRow.StatusID = (int)SystemEnums.FormStatus.Scrap;
this.TAForm.Update(oldRow);
}
}
// 正式提交
if (StatusID == SystemEnums.FormStatus.Awaiting) {
Dictionary<string, object> dic = new Dictionary<string, object>();
dic["TotalAmount"] = totalAmountRMB;
dic["InvoiceStatus"] = formPVRow.InvoiceStatusID;
dic["IsUrgent"] = formPVRow.IsUrgent;
APResult result = new APFlowBLL().CreateProcess(new APParameter(formRow.FormID, formRow.FormNo, formRow.OrganizationUnitID, formRow.UserID, (int)StatusID, formRow.FormTypeID, formRow.PositionID, dic));
if (result != null) {
formRow.InTurnPositionIds = result.InTurnPositionIds;
formRow.InTurnUserIds = result.InTurnUserIds;
formRow.SubmitDate = result.ApprovedDate.GetValueOrDefault();
formRow.StatusID = result.StatusID;
formRow.ProcID = result.ProcID;
formRow.FinanceRemark = formPVRow.Remark;
this.TAForm.Update(formRow);
}
}
transaction.Commit();
} catch (ApplicationException ex) {
transaction.Rollback();
throw ex;
} catch (Exception ex) {
transaction.Rollback();
throw new ApplicationException("Save Fail!" + ex.ToString());
} finally {
transaction.Dispose();
}
}
/// <summary>
/// PV
/// </summary>
/// <param name="FormID"></param>
/// <returns></returns>
private bool ExportPVDataByFormID(int FormID, int logId)
{
ExportDataDS.ExportDataDataTable l_dtExportData = new ExportDataDS.ExportDataDataTable();
PurchaseDS.FormPVDetailDataTable l_dtFormPVDetail = new PurchaseDS.FormPVDetailDataTable();
PurchaseDS.FormPVRow l_drFormPV = new PurchaseDS.FormPVDataTable().NewFormPVRow();
FormMarketingBLL formmarkbll = new FormMarketingBLL();
FormPurchaseBLL formPurchaseBLL = new FormPurchaseBLL();
MasterDataBLL masterdatabll = new MasterDataBLL();
FormDS.FormDataTable l_dtform = formmarkbll.GetFormByID(FormID);
FormDS.FormRow l_drform = l_dtform.NewFormRow();
try {
if (l_dtform.Rows.Count > 0) {
l_drform = l_dtform[0];
if (l_drform.IsFinanceRemarkNull()) {
logbll.InsertExportLogDetail(logId, "单据编号：" + l_drform.FormNo + ",提交人：" + new StuffUserBLL().GetStuffUserById(l_drform.UserID)[0].StuffName + ",错误信息：财务摘要为空，导出失败！");
return false;
}
l_drFormPV = formPurchaseBLL.GetFormPVByID(FormID);
//PurchaseDS.FormInvoiceDataTable l_dtFormInvoice = formPurchaseBLL.GetFormInvoiceByFormID(FormID);
ExportDataDS.ExportDataRow l_drExportData = l_dtExportData.NewExportDataRow();
l_drExportData.FormID = FormID;
l_drExportData.CompanyCode = masterdatabll.GetCompanyById(masterdatabll.GetVendorTypeById(masterdatabll.GetVendorByID(l_drFormPV.VendorID).VendorTypeID).CompanyID).CompanyCode;
//验证公司是否和成本中心对应的一致
string CCCompanyCode = masterdatabll.GetCompanyById(masterdatabll.GetCostCenterById(l_drform.CostCenterID).CompanyID).CompanyCode;
if (l_drExportData.CompanyCode != CCCompanyCode) {
logbll.InsertExportLogDetail(logId, "单据编号：" + l_drform.FormNo + ",提交人：" + new StuffUserBLL().GetStuffUserById(l_drform.UserID)[0].StuffName + ",错误信息：Company Code不一致，无法导出！");
return false;
}
l_drExportData.VendorCode = masterdatabll.GetVendorByID(l_drFormPV.VendorID).VendorCode;
if (l_drExportData.IsVendorCodeNull() || string.IsNullOrEmpty(l_drExportData.VendorCode)) {
logbll.InsertExportLogDetail(logId, "单据编号：" + l_drform.FormNo + ",提交人：" + new StuffUserBLL().GetStuffUserById(l_drform.UserID)[0].StuffName + ",错误信息：Vendor Code为空，无法导出！");
return false;
}
//发票号码改为单据编号，单据编号变为10位
l_drExportData.Invoice = l_drform.FormNo;
//l_drExportData.Invoicedate = l_drform.SubmitDate.ToString("yyyyMMdd");
l_drExportData.Invoicedate = getInvoiceDate(l_drform.FormID, l_drform.SubmitDate);
//if (l_dtFormInvoice.Rows.Count > 1)
// l_drExportData.Reference = l_dtFormInvoice[1].InvoiceNo;
//if (l_dtFormInvoice.Rows.Count > 0) {
// l_drExportData.Invoice = l_dtFormInvoice[0].InvoiceNo;
// l_drExportData.Invoicedate = l_dtFormInvoice[0].InvoiceDate.ToString("yyyyMMdd");
//} else {
// l_drExportData.Invoice = l_drform.FormNo;
// l_drExportData.Invoicedate = l_drform.SubmitDate.ToString("yyyyMMdd");
//}
l_drExportData.TotalMoney = l_drFormPV.AMTBeforeTax;
//l_drExportData.Currency = masterdatabll.GetCurrencyByID(l_drFormPV.CurrencyID).CurrencyShortName;
//l_drExportData.ExchangeRate = l_drFormPV.ExchangeRate;
l_drExportData.ManageExpenseItem = masterdatabll.GetItemCategoryById(l_drFormPV.FinalItemCategoryID).AccountingName;
l_drExportData.CostCenter = masterdatabll.GetCostCenterById(l_drform.CostCenterID).CostCenterCode;
l_drExportData.AccountCode = masterdatabll.GetItemCategoryById(l_drFormPV.FinalItemCategoryID).AccountingCode;
l_drExportData.DetailMoney = l_drFormPV.AMTBeforeTax;
if (!l_drFormPV.IsFormPOIDNull()) {
PurchaseDS.FormPORow formPO = formPurchaseBLL.GetFormPOByID(l_drFormPV.FormPOID);
l_drExportData.PONumber = formPO.BPCSPONo;
PurchaseDS.FormPODetailDataTable formPODetail = formPurchaseBLL.GetPODetailByFormPOID(l_drFormPV.FormPOID);
l_drExportData.POLineNumber = formPODetail.Rows.Count.ToString();
} else {
l_drExportData.PONumber = 0;
l_drExportData.POLineNumber = "0";
}
l_drExportData.FinanceRemark = l_drform.FinanceRemark;
l_drExportData.FormNo = l_drform.FormNo;
l_drExportData.TaxAmt = l_drFormPV.AMTTax;
l_drExportData.TaxRateCode = masterdatabll.GetVatTypeById(l_drFormPV.VatRateID)[0].VatTypeName;
l_dtExportData.AddExportDataRow(l_drExportData);
if (l_dtExportData.Rows.Count == 0) {
logbll.InsertExportLogDetail(logId, "单据编号：" + l_drform.FormNo + ",提交人：" + new StuffUserBLL().GetStuffUserById(l_drform.UserID)[0].StuffName + ",错误信息：无明细数据，无法导出！");
return false;
}
ExportByFormView(l_dtExportData);
}
} catch (Exception e) {
logbll.InsertExportLogDetail(logId, "单据编号：" + l_drform.FormNo + ",提交人：" + new StuffUserBLL().GetStuffUserById(l_drform.UserID)[0].StuffName + ",错误信息：" + e.Message);
return false;
}
return true;
}
