public string GetCompanyID()
{
MasterDataBLL mdBLL = new MasterDataBLL();
OUTreeBLL otBLL = new OUTreeBLL();
AuthorizationDS.PositionRow rowPosition = (AuthorizationDS.PositionRow)Session["Position"];
AuthorizationDS.OrganizationUnitRow rowOU = GetNearestCostCenter(rowPosition.OrganizationUnitId);
MasterData.CostCenterRow rowCostCenter = mdBLL.GetCostCenterById(rowOU.CostCenterID);
return rowCostCenter.CompanyID.ToString();
}
/// <summary>
/// 销售
/// </summary>
/// <param name="FormID"></param>
/// <returns></returns>
private bool ExportSaleDataByFormID(int FormID, int logId)
{
ExportDataDS.ExportDataDataTable l_dtExportData = new ExportDataDS.ExportDataDataTable();
FormDS.FormSalePaymentRow l_drFormSalePayment = new FormDS.FormSalePaymentDataTable().NewFormSalePaymentRow();
FormMarketingBLL formmarkbll = new FormMarketingBLL();
FormTEBLL formtebll = new FormTEBLL();
FormSaleBLL formsalebll = new FormSaleBLL();
MasterDataBLL masterdatabll = new MasterDataBLL();
FormPurchaseBLL formPurchaseBLL = new FormPurchaseBLL();
int Count = 0;
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_drFormSalePayment = formsalebll.GetFormSalePaymentByID(l_drform.FormID);
//if (l_drFormSalePayment.PaymentTypeID == (int)SystemEnums.PaymentType.FreeGoods)
//{
// logbll.InsertExportLogDetail(logId, "单据编号：" + l_drform.FormNo + ",提交人：" + new StuffUserBLL().GetStuffUserById(l_drform.UserID)[0].StuffName + ",错误信息：货补的数据不导出！");
// return false;
//}
//if (l_drFormSalePayment.PaymentTypeID == (int)SystemEnums.PaymentType.Transfer)
//{
// logbll.InsertExportLogDetail(logId, "单据编号：" + l_drform.FormNo + ",提交人：" + new StuffUserBLL().GetStuffUserById(l_drform.UserID)[0].StuffName + ",错误信息：帐扣的数据不导入！");
// return false;
//}
//if (l_drFormSalePayment.PaymentTypeID == (int)SystemEnums.PaymentType.PiaoKou)
//{
// logbll.InsertExportLogDetail(logId, "单据编号：" + l_drform.FormNo + ",提交人：" + new StuffUserBLL().GetStuffUserById(l_drform.UserID)[0].StuffName + ",错误信息：票扣的数据不导入！");
// return false;
//}
//if (l_drFormSalePayment.PaymentTypeID == 5)
//{
// logbll.InsertExportLogDetail(logId, "单据编号：" + l_drform.FormNo + ",提交人：" + new StuffUserBLL().GetStuffUserById(l_drform.UserID)[0].StuffName + ",错误信息：调整因子的数据不导入！");
// return false;
//}
FormDS.FormSalePaymentDetailDataTable l_dtFormSalePaymentDetail = formsalebll.GetFormSalePaymentDetailByPaymentID(FormID);
for (int i = 0; i < l_dtFormSalePaymentDetail.Rows.Count; i++) {
if (l_dtFormSalePaymentDetail[i].AmountRMB == Decimal.Zero) {
Count++;
continue;
}
//PurchaseDS.FormInvoiceDataTable l_dtFormInvoice = formPurchaseBLL.GetFormInvoiceByFormID(FormID);
ExportDataDS.ExportDataRow l_drExportData = l_dtExportData.NewExportDataRow();
l_drExportData.FormID = FormID;
l_drExportData.CompanyCode = l_drExportData.CompanyCode = masterdatabll.GetCompanyById(masterdatabll.GetVendorTypeById(masterdatabll.GetVendorByID(l_drFormSalePayment.VendorID).VendorTypeID).CompanyID).CompanyCode;
l_drExportData.VendorCode = masterdatabll.GetVendorByID(l_drFormSalePayment.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");
//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_drFormSalePayment.AmountBeforeTax;
//l_drExportData.Currency = masterdatabll.GetCurrencyByID(formsalebll.GetFormSaleApplyByID(l_dtFormSalePaymentDetail[i].FormSaleApplyID)[0].CurrencyID).CurrencyShortName;
//l_drExportData.ExchangeRate = formsalebll.GetFormSaleApplyByID(l_dtFormSalePaymentDetail[i].FormSaleApplyID)[0].ExchangeRate;
l_drExportData.ManageExpenseItem = masterdatabll.GetExpenseItemById(l_dtFormSalePaymentDetail[i].ExpenseItemID).ExpenseItemName;
//profit center取AccrualCode，如果没有报错
if (masterdatabll.GetCostCenterById(l_drform.CostCenterID).IsAccrualCodeNull()) {
logbll.InsertExportLogDetail(logId, "单据编号：" + l_drform.FormNo + ",提交人：" + new StuffUserBLL().GetStuffUserById(l_drform.UserID)[0].StuffName + ",错误信息：Profit Center Accrual Code为空，无法导出！");
return false;
} else {
l_drExportData.CostCenter = masterdatabll.GetCostCenterById(l_drform.CostCenterID).AccrualCode;
}
if (l_dtFormSalePaymentDetail[i].ApplyPeriod.AddMonths(5).Year == l_drform.SubmitDate.AddMonths(5).Year)
l_drExportData.AccountCode = masterdatabll.GetExpenseItemById(l_dtFormSalePaymentDetail[i].ExpenseItemID).AccrualAccountingCode;
else
l_drExportData.AccountCode = masterdatabll.GetExpenseItemById(l_dtFormSalePaymentDetail[i].ExpenseItemID).LastAccountingCode;
l_drExportData.DetailMoney = l_dtFormSalePaymentDetail[i].AmountBeforeTax;
//PO No 变为取报销单的PO的No
if (l_drFormSalePayment.IsFormPOIDNull()) {
//PurchaseDS.FormPODataTable formPO = formPurchaseBLL.GetFormPOByParentFormID(l_dtFormSalePaymentDetail[i].FormSaleApplyID);
//if (formPO.Rows.Count > 0) {
// l_drExportData.PONumber = formPO[0].BPCSPONo;
// PurchaseDS.FormPODetailDataTable formPODetail = formPurchaseBLL.GetPODetailByFormPOID(formPO[0].FormPOID);
// l_drExportData.POLineNumber = formPODetail.Rows.Count.ToString();
//} else {
l_drExportData.PONumber = 0;
l_drExportData.POLineNumber = "0";
//}
} else {
//若已选PO，取所选PO信息
PurchaseDS.FormPORow formPO = formPurchaseBLL.GetFormPOByID(l_drFormSalePayment.FormPOID);
PurchaseDS.FormPODetailDataTable formPODetail = formPurchaseBLL.GetPODetailByFormPOID(l_drFormSalePayment.FormPOID);
l_drExportData.PONumber = formPO.BPCSPONo;
l_drExportData.POLineNumber = formPODetail.Count.ToString();
}
l_drExportData.FormNo = l_drform.FormNo;
l_drExportData.FinanceRemark = l_drform.FinanceRemark;
l_drExportData.TaxRateCode = masterdatabll.GetVatTypeById(l_drFormSalePayment.VatTypeID)[0].VatTypeName;
l_drExportData.TaxAmt = l_dtFormSalePaymentDetail[i].TaxAmount;
l_dtExportData.AddExportDataRow(l_drExportData);
Count++;
}
if (l_dtExportData.Rows.Count == 0) {
logbll.InsertExportLogDetail(logId, "单据编号：" + l_drform.FormNo + ",提交人：" + new StuffUserBLL().GetStuffUserById(l_drform.UserID)[0].StuffName + ",错误信息：无明细数据，无法导出！");
return false;
}
if (l_dtFormSalePaymentDetail.Rows.Count == Count)
ExportByFormView(l_dtExportData);
else {
logbll.InsertExportLogDetail(logId, "单据编号：" + l_drform.FormNo + ",提交人：" + new StuffUserBLL().GetStuffUserById(l_drform.UserID)[0].StuffName + ",错误信息：明细数据数量不一致，无法导出！");
return false;
}
}
} catch (Exception e) {
logbll.InsertExportLogDetail(logId, "单据编号：" + l_drform.FormNo + ",提交人：" + new StuffUserBLL().GetStuffUserById(l_drform.UserID)[0].StuffName + ",错误信息：" + e.Message);
return false;
}
return true;
}
/// <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;
}
private bool ExportPO(int formid, int logId)
{
string BakPath = ConfigurationManager.AppSettings["ExportService.BakPath"];
AuthorizationBLL authorizationbll = new AuthorizationBLL();
MasterDataBLL masterdatabll = new MasterDataBLL();
FormQueryBLL formQueryBLL = new FormQueryBLL();
FormPurchaseBLL formPurchaseBLL = new FormPurchaseBLL();
OUTreeBLL outreebll = new OUTreeBLL();
PurchaseDS.FormDataTable l_dtform = new PurchaseDS.FormDataTable();
PurchaseDS.FormRow form = l_dtform.NewFormRow();
try {
PurchaseDS.FormPORow formPO = formPurchaseBLL.GetFormPOByID(formid);
PurchaseDS.FormPODetailDataTable formPODetail = formPurchaseBLL.GetPODetailByFormPOID(formPO.FormPOID);
form = formPurchaseBLL.GetFormByID(formPO.FormPOID)[0];
string POFileName = ConfigurationManager.AppSettings["ExportService.POFileName"];
string POLineFileName = ConfigurationManager.AppSettings["ExportService.POLineFileName"];
string spit = "\t";
string CompanyCode = masterdatabll.GetCompanyById(masterdatabll.GetVendorTypeById(masterdatabll.GetVendorByID(formPO.VendorID).VendorTypeID).CompanyID).CompanyCode;
string VendorCode = masterdatabll.GetVendorByID(formPO.VendorID).VendorCode;
string POcontent = (
"PH" + spit +
"" + spit +
formPO.BPCSPONo + spit +
"0" + spit +
"" + spit +
"0" + spit +
CompanyCode + spit +
"" + spit +
CompanyCode + spit +
VendorCode + spit +
"0" + spit +
"4" + spit +
"" + spit +
masterdatabll.GetCompanyById(formPO.CompanyID).CompanyName + spit +
authorizationbll.GetStuffUserById(form.UserID).UserName.ToUpper() + spit +
bSubstring(formPO.DeliveryAddress, 30) + spit +
SpitAddress(formPO.DeliveryAddress, 60) + spit +
SpitAddress(formPO.DeliveryAddress, 90) + spit +
"" + spit +
"" + spit +
"" + spit +
form.SubmitDate.ToString("yyyyMMdd") + spit +
"0" + spit +
"0" + spit +
"0" + spit +
formPODetail[0].DeliveryDate.ToString("yyyyMMdd") + spit +
"0" + spit +
"0" + spit +
bSubstring(formPO.Remark, 30) + spit +
masterdatabll.GetPaymentTermById(masterdatabll.GetVendorByID(formPO.VendorID).PaymentTermID)[0].PaymentTermName + spit +
"1" + spit +
"" + spit +
outreebll.GetOrganizationUnitById(form.OrganizationUnitID).OrganizationUnitCode + spit +
masterdatabll.GetShippingTermById(formPO.ShippingTermID).ShippingTermCode + spit +
"" + spit +
masterdatabll.GetCurrencyByID(formPO.CurrencyID).CurrencyShortName + spit +
formPO.ExchangeRate + spit +
formPO.ExchangeRate + spit +
formPODetail.Rows.Count + spit +
formPO.ExchangeRate + spit +
authorizationbll.GetStuffUserById(form.UserID).UserName.ToUpper() + spit +
"" + spit +
authorizationbll.GetStuffUserById(form.UserID).UserName.ToUpper() + spit +
form.ApprovedDate.ToString("yyyyMMdd") + spit +
"" + spit +
"0" + spit +
"" + spit +
"0" + spit +
"" + spit +
"" + spit +
"" + spit +
"" + spit +
"").Replace("\r", "").Replace("\n", "");
int order = 0;
string[] PODetailcontent = new string[formPODetail.Rows.Count];
foreach (PurchaseDS.FormPODetailRow l_drformPODetail in formPODetail) {
order++;
PODetailcontent[order - 1] = (
"PO" + spit +
formPO.BPCSPONo + spit +
order + spit +
l_drformPODetail.ItemCode.ToUpper() + spit +
VendorCode + spit +
l_drformPODetail.Quantity + spit +
l_drformPODetail.Quantity + spit +
l_drformPODetail.DeliveryDate.ToString("yyyyMMdd") + spit +
"" + spit +
"0" + spit +
l_drformPODetail.AmountRMB.ToString() + spit +
"0" + spit +
"0" + spit +
"EA" + spit +
"0" + spit +
"" + spit +
"0" + spit +
"0" + spit +
"" + spit +
"" + spit +
"" + spit +
DateTime.Now.ToString("yyyyMMdd") + spit +
masterdatabll.GetPaymentTermById(masterdatabll.GetVendorByID(formPO.VendorID).PaymentTermID)[0].PaymentTermName + spit +
"" + spit +
"0" + spit +
"1" + spit +
"1" + spit +
"" + spit +
CompanyCode + spit +
"0" + spit +
"0" + spit +
"0" + spit +
"0" + spit +
l_drformPODetail.DeliveryDate.ToString("yyyyMMdd") + spit +
"" + spit +
"0" + spit +
"0" + spit +
"" + spit +
masterdatabll.GetCurrencyByID(formPO.CurrencyID).CurrencyShortName + spit +
formPO.ExchangeRate + spit +
formPO.ExchangeRate + spit +
"0" + spit +
l_drformPODetail.AmountRMB.ToString() + spit +
"0" + spit +
"1" + spit +
"" + spit +
"0" + spit +
"0" + spit +
"0" + spit +
"" + spit +
"" + spit +
"" + spit +
"01" + spit +
"4" + spit +
masterdatabll.GetCompanyById(formPO.CompanyID).CompanyName + spit +//Ship To Company
authorizationbll.GetStuffUserById(form.UserID).UserName.ToUpper() + spit +
bSubstring(formPO.DeliveryAddress, 30) + spit +
SpitAddress(formPO.DeliveryAddress, 60) + spit +
SpitAddress(formPO.DeliveryAddress, 90) + spit +
"" + spit +
"" + spit +
"" + spit +
"0" + spit +
"0" + spit +
l_drformPODetail.DeliveryDate.ToString("yyyyMMdd") + spit +
"0" + spit +
l_drformPODetail.DeliveryDate.ToString("yyyyMMdd") + spit +
l_drformPODetail.DeliveryDate.ToString("yyyyMMdd") + spit +
"" + spit +
outreebll.GetOrganizationUnitById(form.OrganizationUnitID).OrganizationUnitCode + spit +
"" + spit +
"" + spit +
masterdatabll.GetCostCenterById(form.CostCenterID).CostCenterCode + spit +
l_drformPODetail.ItemCode.ToUpper() + spit +
l_drformPODetail.ItemDescription + spit +
"1" + spit +
"0" + spit +
"0" + spit +
"3" + spit +
"0" + spit +
"0" + spit +
"" + spit +
"" + spit +
"" + spit +
"" + spit +
"" + spit +
"" + spit +
"" + spit +
l_drformPODetail.Quantity).Replace("\r", "").Replace("\n", ""); ;
}
File.AppendAllLines(path + POLineFileName, PODetailcontent, Encoding.Default);
File.AppendAllLines(BakPath + DateTime.Now.ToString("yyyyMMddhhmmss") + POLineFileName, PODetailcontent, Encoding.Default);
File.AppendAllText(path + POFileName, POcontent + "\r\n", Encoding.Default);
File.AppendAllText(BakPath + DateTime.Now.ToString("yyyyMMddhhmmss") + POFileName, POcontent, Encoding.Default);
} catch (Exception e) {
logbll.InsertExportLogDetail(logId, "单据编号：" + form.FormNo + "，提交人：" + new StuffUserBLL().GetStuffUserById(form.UserID)[0].StuffName + "，错误信息：" + e.Message);
return false;
}
return true;
}
/// <summary>
/// 个人费用报销
/// </summary>
/// <param name="FormID"></param>
/// <returns></returns>
private bool ExportPersonalReimburseDataByFormID(int FormID, int logId)
{
ExportDataDS.ExportDataDataTable l_dtExportData = new ExportDataDS.ExportDataDataTable();
FormDS.FormPersonalReimburseDetailDataTable l_dtPersonalReimburseDetail = new FormDS.FormPersonalReimburseDetailDataTable();
FormMarketingBLL formmarkbll = new FormMarketingBLL();
FormTEBLL formtebll = new FormTEBLL();
StuffUserBLL stuffuserdll = new StuffUserBLL();
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_dtPersonalReimburseDetail = formtebll.GetFormPersonalReimburseDetailByFormPersonalReimburseID(l_drform.FormID);
int i = 0;
FormDS.FormPersonalReimburseDataTable l_dtPersonalReimburse = formtebll.GetFormPersonalReimburseByID(l_drform.FormID);
foreach (FormDS.FormPersonalReimburseDetailRow l_drtemp in l_dtPersonalReimburseDetail) {
ExportDataDS.ExportDataRow l_drExportData = l_dtExportData.NewExportDataRow();
l_drExportData.FormID = FormID;
l_drExportData.VendorCode = stuffuserdll.GetStuffUserById(l_drform.UserID)[0].VendorCode;
l_drExportData.CompanyCode = masterdatabll.GetCompanyById(masterdatabll.GetCostCenterById(l_drform.CostCenterID).CompanyID).CompanyCode;
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;
}
//如果Vendor Code的公司和成本中心的公司不一致，则报错
MasterData.VendorDataTable tbVendor = new BusinessObjects.MasterDataTableAdapters.VendorTableAdapter().GetDataByVendorCode(l_drExportData.VendorCode);
if (tbVendor.Rows.Count > 0) {
string vendorCompanyCode = masterdatabll.GetCompanyById(tbVendor[0].CompanyID).CompanyCode;
if (l_drExportData.CompanyCode != vendorCompanyCode) {
logbll.InsertExportLogDetail(logId, "单据编号：" + l_drform.FormNo + ",提交人：" + new StuffUserBLL().GetStuffUserById(l_drform.UserID)[0].StuffName + ",错误信息：Company Code不符，请检查！");
return false;
}
}
l_drExportData.Reference = "";
l_drExportData.Invoice = l_drform.FormNo;
l_drExportData.Invoicedate = l_drform.SubmitDate.ToString("yyyyMMdd");
l_drExportData.TotalMoney = l_dtPersonalReimburse[0].Amount;
//l_drExportData.Currency = masterdatabll.GetCurrencyByID(l_drtemp.CurrencyID).CurrencyShortName;
//l_drExportData.ExchangeRate = l_drtemp.ExchangeRate;
l_drExportData.ManageExpenseItem = masterdatabll.GetManageExpenseItemById(l_drtemp.ManageExpenseItemID).ManageExpenseItemName;
l_drExportData.CostCenter = masterdatabll.GetCostCenterById(l_drform.CostCenterID).CostCenterCode;
l_drExportData.AccountCode = masterdatabll.GetAccountingCodeByExpenseItemAndCostCenter(l_drtemp.ManageExpenseItemID, l_drform.CostCenterID);
l_drExportData.DetailMoney = l_drtemp.RMB;
l_drExportData.PONumber = 0;
l_drExportData.POLineNumber = "0";
l_drExportData.FinanceRemark = l_drform.FinanceRemark;
l_drExportData.FormNo = l_drform.FormNo;
l_drExportData.TaxRateCode = masterdatabll.GetVatTypeById(1)[0].VatTypeName;
l_drExportData.TaxAmt = 0;
l_dtExportData.AddExportDataRow(l_drExportData);
i++;
}
if (l_dtExportData.Rows.Count == 0) {
logbll.InsertExportLogDetail(logId, "单据编号：" + l_drform.FormNo + ",提交人：" + new StuffUserBLL().GetStuffUserById(l_drform.UserID)[0].StuffName + ",错误信息：无明细数据，无法导出！");
return false;
}
if (l_dtExportData.Rows.Count == l_dtPersonalReimburseDetail.Rows.Count) {
ExportByFormView(l_dtExportData);
} else {
logbll.InsertExportLogDetail(logId, "单据编号：" + l_drform.FormNo + ",提交人：" + new StuffUserBLL().GetStuffUserById(l_drform.UserID)[0].StuffName + ",错误信息：导出数据与明细数据数量不一致！");
return false;
}
}
} catch (Exception e) {
logbll.InsertExportLogDetail(logId, "单据编号：" + l_drform.FormNo + ",提交人：" + new StuffUserBLL().GetStuffUserById(l_drform.UserID)[0].StuffName + ",错误信息：" + e.Message);
return false;
}
return true;
}