protected void Page_Load(object sender, EventArgs e)
{
base.Page_Load(sender, e);
if (!this.IsPostBack)
{
PageUtility.SetContentTitle(this.Page, "方案申请审批");
this.Page.Title = "方案申请审批";
int formID = int.Parse(Request["ObjectId"]);
this.ViewState["ObjectId"] = formID;
FormDS.FormRow rowForm = this.SalesApplyBLL.GetFormByID(formID)[0];
FormDS.FormApplyRow rowFormApply = this.SalesApplyBLL.GetFormApplyByID(formID)[0];
if (rowForm.IsProcIDNull())
{
ViewState["ProcID"] = "";
}
else
{
ViewState["ProcID"] = rowForm.ProcID;
}
ViewState["OrganizationUnitID"] = rowForm.OrganizationUnitID;
this.FormNoCtl.Text = rowForm.FormNo;
this.ApplyDateCtl.Text = rowForm.SubmitDate.ToShortDateString();
AuthorizationDS.StuffUserRow applicant = new AuthorizationBLL().GetStuffUserById(rowForm.UserID);
this.StuffNameCtl.Text = applicant.StuffName;
this.PositionNameCtl.Text = new OUTreeBLL().GetPositionById(rowForm.PositionID).PositionName;
if (new OUTreeBLL().GetOrganizationUnitById(rowForm.OrganizationUnitID) != null)
{
this.DepartmentNameCtl.Text = new OUTreeBLL().GetOrganizationUnitById(rowForm.OrganizationUnitID).OrganizationUnitName;
}
this.AttendDateCtl.Text = applicant.AttendDate.ToShortDateString();
this.BeginPeriodCtl.Text = rowFormApply.BeginPeriod.ToString("yyyy-MM");
this.EndPeriodCtl.Text = rowFormApply.EndPeriod.ToString("yyyy-MM");
MasterDataBLL masterBll = new MasterDataBLL();
this.ExpenseSubCategoryCtl.Text = masterBll.GetExpenseSubCateNameById(rowFormApply.ExpenseSubCategoryID);
ERS.CustomerRow customer = masterBll.GetCustomerById(rowFormApply.CustomerID);
this.CustomerNameCtl.Text = customer.CustomerName;
//this.CustomerTypeCtl.Text = masterBll.GetCustomerTypeById(customer.CustomerTypeID).CustomerTypeName;
this.ShopNameCtl.Text = masterBll.GetShopByID(rowFormApply.ShopID).ShopName;
this.PaymentTypeCtl.Text = masterBll.GetPaymentTypeById(rowFormApply.PaymentTypeID).PaymentTypeName;
if (!rowFormApply.IsContractNoNull())
{
this.ContractNoCtl.Text = rowFormApply.ContractNo;
}
this.AmountCtl.Text = rowFormApply.Amount.ToString("N");
if (!rowFormApply.IsRemarkNull())
{
this.RemarkCtl.Text = rowFormApply.Remark;
}
if (!rowFormApply.IsAttachedFileNameNull())
{
this.UCFileUpload.AttachmentFileName = rowFormApply.AttachedFileName;
}
if (!rowFormApply.IsRealAttachedFileNameNull())
{
this.UCFileUpload.RealAttachmentFileName = rowFormApply.RealAttachedFileName;
}
if (!rowFormApply.IsPromotionBeginDateNull())
{
this.PromotionBeginCtl.Text = rowFormApply.PromotionBeginDate.ToString("yyyy-MM-dd");
}
if (!rowFormApply.IsPromotionEndDateNull())
{
this.PromotionEndCtl.Text = rowFormApply.PromotionEndDate.ToString("yyyy-MM-dd");
}
if (!rowFormApply.IsDeliveryBeginDateNull())
{
this.DeliveryBeginCtl.Text = rowFormApply.DeliveryBeginDate.ToString("yyyy-MM-dd");
}
if (!rowFormApply.IsDeliveryEndDateNull())
{
this.DeliveryEndCtl.Text = rowFormApply.DeliveryEndDate.ToString("yyyy-MM-dd");
}
if (!rowFormApply.IsFormApplyNameNull())
{
this.txtFormApplyName.Text = rowFormApply.FormApplyName;
}
this.PromotionScopeCtl.Text = masterBll.GetPromotionScopeById(rowFormApply.PromotionScopeID).PromotionScopeName;
this.PromotionTypeCtl.Text = masterBll.GetPromotionTypeById(rowFormApply.PromotionTypeID).PromotionTypeName;
if (!rowFormApply.IsPromotionDescNull())
{
this.PromotionDescCtl.Text = rowFormApply.PromotionDesc;
}
this.ShelfTypeCtl.Text = masterBll.GetShelfTypeById(rowFormApply.ShelfTypeID).ShelfTypeName;
if (!rowFormApply.IsFirstVolumeNull())
{
this.FirstVolumeCtl.Text = rowFormApply.FirstVolume.ToString();
}
if (!rowFormApply.IsSecondVolumeNull())
{
this.SecondVolumeCtl.Text = rowFormApply.SecondVolume.ToString();
}
if (!rowFormApply.IsThirdVolumeNull())
{
this.ThirdVolumeCtl.Text = rowFormApply.ThirdVolume.ToString();
}
if (!rowFormApply.IsAverageVolumeNull())
{
this.AverageVolumeCtl.Text = rowFormApply.AverageVolume.ToString();
}
if (!rowFormApply.IsReimburseRequirementsNull())
{
int ReimburseRequirement = rowFormApply.ReimburseRequirements;
if ((ReimburseRequirement & (int)SystemEnums.ReimburseRequirements.Picture) == (int)SystemEnums.ReimburseRequirements.Picture)
{
chkListReimburseRequirements.Items[0].Selected = true;
}
if ((ReimburseRequirement & (int)SystemEnums.ReimburseRequirements.Agreement) == (int)SystemEnums.ReimburseRequirements.Agreement)
{
chkListReimburseRequirements.Items[1].Selected = true;
}
if ((ReimburseRequirement & (int)SystemEnums.ReimburseRequirements.DeliveryOrder) == (int)SystemEnums.ReimburseRequirements.DeliveryOrder)
{
chkListReimburseRequirements.Items[2].Selected = true;
}
if ((ReimburseRequirement & (int)SystemEnums.ReimburseRequirements.Contract) == (int)SystemEnums.ReimburseRequirements.Contract)
{
chkListReimburseRequirements.Items[3].Selected = true;
}
if ((ReimburseRequirement & (int)SystemEnums.ReimburseRequirements.DM) == (int)SystemEnums.ReimburseRequirements.DM)
{
chkListReimburseRequirements.Items[4].Selected = true;
}
if ((ReimburseRequirement & (int)SystemEnums.ReimburseRequirements.Other) == (int)SystemEnums.ReimburseRequirements.Other)
{
chkListReimburseRequirements.Items[5].Selected = true;
}
}
//历史单据
if (rowForm.IsRejectedFormIDNull())
{
lblRejectFormNo.Text = "无";
}
else
{
FormDS.FormRow rejectedForm = new SalesApplyBLL().GetFormByID(rowForm.RejectedFormID)[0];
this.lblRejectFormNo.Text = rejectedForm.FormNo;
this.lblRejectFormNo.NavigateUrl = "javascript:window.showModalDialog('" + System.Configuration.ConfigurationManager.AppSettings["WebSiteUrl"] + "/SalesForm/SalesGeneralApproval.aspx?ShowDialog=1&ObjectId=" + rejectedForm.FormID + "','', 'dialogWidth:1000px;dialogHeight:750px;resizable:yes;')";
}
//查看预算信息按钮
this.btnViewBudget.NavigateUrl = "javascript:window.showModalDialog('" + System.Configuration.ConfigurationManager.AppSettings["WebSiteUrl"] + "/ReportManage/SalesBudgetByPosition.aspx?ShowDialog=1','', 'dialogWidth:918px;dialogHeight:660px;resizable:yes;')";
//预算信息
this.CustomerBudgetCtl.Text = rowFormApply.CustomerBudget.ToString("N");
this.CustomerBudgetRemainCtl.Text = rowFormApply.CustomerBudgetRemain.ToString("N");
this.OUBudgetCtl.Text = rowFormApply.OUBudget.ToString("N");
this.OUApprovedAmountCtl.Text = rowFormApply.OUAppovedAmount.ToString("N");
this.OUApprovingAmountCtl.Text = rowFormApply.OUApprovingAmount.ToString("N");
this.OUCompletedAmountCtl.Text = rowFormApply.OUCompletedAmount.ToString("N");
this.OUReimbursedAmountCtl.Text = rowFormApply.OUReimbursedAmount.ToString("N");
this.OUBudgetRemainCtl.Text = rowFormApply.OUBudgetRemain.ToString("N");
this.OUBudgetRateCtl.Text = ((decimal)(rowFormApply.OUBudgetRate * 100)).ToString("N") + "%";
this.odsSKU.SelectParameters["FormApplyID"].DefaultValue = rowFormApply.FormApplyID.ToString();
//审批页面处理&按钮处理
AuthorizationDS.StuffUserRow stuffUser = (AuthorizationDS.StuffUserRow)Session["StuffUser"];
this.ViewState["StuffUserID"] = stuffUser.StuffUserId;
if (rowForm.InTurnUserIds.Contains("P" + stuffUser.StuffUserId + "P"))
{
this.SubmitBtn.Visible = true;
this.cwfAppCheck.IsView = false;
this.ViewState["IsView"] = false;
}
else
{
this.SubmitBtn.Visible = false;
this.cwfAppCheck.IsView = true;
this.ViewState["IsView"] = true;
}
if (rowForm.StatusID == (int)SystemEnums.FormStatus.Rejected && stuffUser.StuffUserId == rowForm.UserID)
{
this.EditBtn.Visible = true;
this.ScrapBtn.Visible = true;
}
else
{
this.EditBtn.Visible = false;
this.ScrapBtn.Visible = false;
}
//是否显示复制按钮
if (rowForm.StatusID == (int)SystemEnums.FormStatus.ApproveCompleted && stuffUser.StuffUserId == rowForm.UserID)
{
this.UCBeginPeriod.Visible = true;
this.UCEndPeriod.Visible = true;
this.lblSignal.Visible = true;
this.CopyBtn.Visible = true;
}
else
{
this.UCBeginPeriod.Visible = false;
this.UCEndPeriod.Visible = false;
this.lblSignal.Visible = false;
this.CopyBtn.Visible = false;
}
//是否显示打印信息
if (((stuffUser.StuffUserId == rowForm.UserID || base.IsBusinessProxy(rowForm.UserID, rowForm.SubmitDate) && (rowForm.StatusID == (int)SystemEnums.FormStatus.ApproveCompleted) || rowForm.StatusID == (int)SystemEnums.FormStatus.Scrap && rowFormApply.IsAutoSplit)))
{
this.PrintBtn.Visible = true;
}
else
{
this.PrintBtn.Visible = false;
}
if (rowForm.StatusID == (int)SystemEnums.FormStatus.ApproveCompleted || (rowForm.StatusID == (int)SystemEnums.FormStatus.Scrap && rowFormApply.IsAutoSplit))
{
this.PrintInfor.Visible = true;
int printCount = rowFormApply.IsPrintCountNull() ? 0 : rowFormApply.PrintCount;
this.PrintInfor.Text = "该方案已经被打印" + printCount + "次";
}
else
{
this.PrintInfor.Visible = false;
}
//如果是弹出,取消按钮不可见
if (this.Request["ShowDialog"] != null)
{
if (this.Request["ShowDialog"].ToString() == "1")
{
this.upButton.Visible = false;
this.Master.FindControl("divMenu").Visible = false;
this.Master.FindControl("tbCurrentPage").Visible = false;
this.PrintInfor.Visible = false;
this.PrintBtn.Visible = false;
}
}
//如果是申请人则隐藏预算信息
if (stuffUser.StuffUserId == rowForm.UserID)
{
this.OUBudgetCtl.Text = "";
this.OUApprovedAmountCtl.Text = "";
this.OUApprovingAmountCtl.Text = "";
this.OUCompletedAmountCtl.Text = "";
this.OUReimbursedAmountCtl.Text = "";
this.OUBudgetRemainCtl.Text = "";
this.OUBudgetRateCtl.Text = "";
this.btnViewBudget.Visible = false;
}
//分摊比例
new FormApplySplitRateTableAdapter().FillByApplyID(InnerDS.FormApplySplitRate, formID);
if (InnerDS.FormApplySplitRate != null && InnerDS.FormApplySplitRate.Count > 0)
{
this.divSplitRate.Visible = true;
this.gvSplitRate.Visible = true;
this.gvSplitRate.DataSource = InnerDS.FormApplySplitRate;
this.gvSplitRate.DataBind();
}
}
this.cwfAppCheck.FormID = (int)this.ViewState["ObjectId"];
this.cwfAppCheck.ProcID = this.ViewState["ProcID"].ToString();
this.cwfAppCheck.IsView = (bool)this.ViewState["IsView"];
}
protected void Page_Load(object sender, EventArgs e)
{
base.Page_Load(sender, e);
if (!this.IsPostBack)
{
PageUtility.SetContentTitle(this.Page, "方案报销审批");
this.Page.Title = "方案报销审批";
int formID = int.Parse(Request["ObjectId"]);
this.ViewState["ObjectId"] = formID;
FormDS.FormRow rowForm = this.SalesReimburseBLL.GetFormByID(formID)[0];
FormDS.FormReimburseRow rowFormReimburse = this.SalesReimburseBLL.GetFormReimburseByID(formID)[0];
if (rowForm.IsProcIDNull())
{
ViewState["ProcID"] = "";
}
else
{
ViewState["ProcID"] = rowForm.ProcID;
}
ViewState["OrganizationUnitID"] = rowForm.OrganizationUnitID;
this.FormNoCtl.Text = rowForm.FormNo;
this.ApplyDateCtl.Text = rowForm.SubmitDate.ToShortDateString();
AuthorizationDS.StuffUserRow applicant = new AuthorizationBLL().GetStuffUserById(rowForm.UserID);
this.StuffNameCtl.Text = applicant.StuffName;
this.PositionNameCtl.Text = new OUTreeBLL().GetPositionById(rowForm.PositionID).PositionName;
if (new OUTreeBLL().GetOrganizationUnitById(rowForm.OrganizationUnitID) != null)
{
this.DepartmentNameCtl.Text = new OUTreeBLL().GetOrganizationUnitById(rowForm.OrganizationUnitID).OrganizationUnitName;
}
this.AttendDateCtl.Text = applicant.AttendDate.ToShortDateString();
MasterDataBLL masterBll = new MasterDataBLL();
ERS.CustomerRow customer = masterBll.GetCustomerById(rowFormReimburse.CustomerID);
this.CustomerNameCtl.Text = customer.CustomerName;
this.CustomerTypeCtl.Text = masterBll.GetCustomerTypeById(customer.CustomerTypeID).CustomerTypeName;
this.PaymentTypeCtl.Text = masterBll.GetPaymentTypeById(rowFormReimburse.PaymentTypeID).PaymentTypeName;
if (!rowFormReimburse.IsRemarkNull())
{
this.RemarkCtl.Text = rowFormReimburse.Remark;
}
if (!rowFormReimburse.IsAttachedFileNameNull())
{
this.UCFileUpload.AttachmentFileName = rowFormReimburse.AttachedFileName;
}
if (!rowFormReimburse.IsRealAttachedFileNameNull())
{
this.UCFileUpload.RealAttachmentFileName = rowFormReimburse.RealAttachedFileName;
}
this.odsInvoice.SelectParameters["FormReimburseID"].DefaultValue = rowFormReimburse.FormReimburseID.ToString();
this.odsReimburseDetails.SelectParameters["FormReimburseID"].DefaultValue = rowFormReimburse.FormReimburseID.ToString();
//审批页面处理&按钮处理
AuthorizationDS.StuffUserRow stuffUser = (AuthorizationDS.StuffUserRow)Session["StuffUser"];
this.ViewState["StuffUserID"] = stuffUser.StuffUserId;
if (rowForm.InTurnUserIds.Contains("P" + stuffUser.StuffUserId + "P"))
{
this.SubmitBtn.Visible = true;
this.cwfAppCheck.IsView = false;
this.ViewState["IsView"] = false;
}
else
{
this.SubmitBtn.Visible = false;
this.cwfAppCheck.IsView = true;
this.ViewState["IsView"] = true;
}
if (rowForm.StatusID == (int)SystemEnums.FormStatus.Rejected && stuffUser.StuffUserId == rowForm.UserID)
{
this.EditBtn.Visible = true;
this.ScrapBtn.Visible = true;
}
else
{
this.EditBtn.Visible = false;
this.ScrapBtn.Visible = false;
}
if (!rowFormReimburse.IsPaymentDateNull())
{
this.txtPaymentDate.Text = rowFormReimburse.PaymentDate.ToString("yyyy-MM-dd");
this.ucPaymentDate.SelectedDate = rowFormReimburse.PaymentDate.ToString("yyyy-MM-dd");
}
AuthorizationDS.PositionRow position = (AuthorizationDS.PositionRow) this.Session["Position"];
PositionRightBLL positionRightBLL = new PositionRightBLL();
if (rowForm.StatusID == (int)SystemEnums.FormStatus.ApproveCompleted && positionRightBLL.CheckPositionRight(position.PositionId, (int)SystemEnums.OperateEnum.Other + (int)SystemEnums.BusinessUseCase.FormReimburse))
{
this.txtPaymentDate.Visible = false;
this.ucPaymentDate.Visible = true;
this.btnSavePaymentInfo.Visible = true;
}
//历史单据
if (rowForm.IsRejectedFormIDNull())
{
lblRejectFormNo.Text = "无";
}
else
{
FormDS.FormRow rejectedForm = this.SalesReimburseBLL.GetFormByID(rowForm.RejectedFormID)[0];
this.lblRejectFormNo.Text = rejectedForm.FormNo;
this.lblRejectFormNo.NavigateUrl = "javascript:window.showModalDialog('" + System.Configuration.ConfigurationManager.AppSettings["WebSiteUrl"] + "/SalesForm/ReimburseMoneyApproval.aspx?ShowDialog=1&ObjectId=" + rejectedForm.FormID + "','', 'dialogWidth:1000px;dialogHeight:750px;resizable:yes;')";
}
//如果是弹出,取消按钮不可见
if (this.Request["ShowDialog"] != null)
{
if (this.Request["ShowDialog"].ToString() == "1")
{
this.upButton.Visible = false;
this.Master.FindControl("divMenu").Visible = false;
this.Master.FindControl("tbCurrentPage").Visible = false;
}
}
}
this.cwfAppCheck.FormID = (int)this.ViewState["ObjectId"];
this.cwfAppCheck.ProcID = this.ViewState["ProcID"].ToString();
this.cwfAppCheck.IsView = (bool)this.ViewState["IsView"];
}
protected void Page_Load(object sender, EventArgs e)
{
base.Page_Load(sender, e);
if (!this.IsPostBack)
{
PageUtility.SetContentTitle(this.Page, "方案执行确认");
this.Page.Title = "方案执行确认";
int formID = int.Parse(Request["ObjectId"]);
this.ViewState["ObjectId"] = formID;
FormDS.FormRow rowForm = this.SalesApplyBLL.GetFormByID(formID)[0];
FormDS.FormApplyRow rowFormApply = this.SalesApplyBLL.GetFormApplyByID(formID)[0];
if (rowForm.IsProcIDNull())
{
ViewState["ProcID"] = "";
}
else
{
ViewState["ProcID"] = rowForm.ProcID;
}
ViewState["OrganizationUnitID"] = rowForm.OrganizationUnitID;
this.FormNoCtl.Text = rowForm.FormNo;
this.ApplyDateCtl.Text = rowForm.SubmitDate.ToShortDateString();
AuthorizationDS.StuffUserRow applicant = new AuthorizationBLL().GetStuffUserById(rowForm.UserID);
this.StuffNameCtl.Text = applicant.StuffName;
this.PositionNameCtl.Text = new OUTreeBLL().GetPositionById(rowForm.PositionID).PositionName;
if (new OUTreeBLL().GetOrganizationUnitById(rowForm.OrganizationUnitID) != null)
{
this.DepartmentNameCtl.Text = new OUTreeBLL().GetOrganizationUnitById(rowForm.OrganizationUnitID).OrganizationUnitName;
}
this.AttendDateCtl.Text = applicant.AttendDate.ToShortDateString();
this.BeginPeriodCtl.Text = rowFormApply.BeginPeriod.ToString("yyyy-MM");
this.EndPeriodCtl.Text = rowFormApply.EndPeriod.ToString("yyyy-MM");
MasterDataBLL masterBll = new MasterDataBLL();
this.ExpenseSubCategoryCtl.Text = masterBll.GetExpenseSubCateNameById(rowFormApply.ExpenseSubCategoryID);
ERS.CustomerRow customer = masterBll.GetCustomerById(rowFormApply.CustomerID);
this.CustomerNameCtl.Text = customer.CustomerName;
//this.CustomerTypeCtl.Text = masterBll.GetCustomerTypeById(customer.CustomerTypeID).CustomerTypeName;
this.ShopNameCtl.Text = masterBll.GetShopByID(rowFormApply.ShopID).ShopName;
this.PaymentTypeCtl.Text = masterBll.GetPaymentTypeById(rowFormApply.PaymentTypeID).PaymentTypeName;
if (!rowFormApply.IsContractNoNull())
{
this.ContractNoCtl.Text = rowFormApply.ContractNo;
}
this.AmountCtl.Text = rowFormApply.Amount.ToString("N");
if (!rowFormApply.IsRemarkNull())
{
this.RemarkCtl.Text = rowFormApply.Remark;
}
if (!rowFormApply.IsAttachedFileNameNull())
{
this.UCFileUpload.AttachmentFileName = rowFormApply.AttachedFileName;
}
if (!rowFormApply.IsRealAttachedFileNameNull())
{
this.UCFileUpload.RealAttachmentFileName = rowFormApply.RealAttachedFileName;
}
if (!rowFormApply.IsPromotionBeginDateNull())
{
this.PromotionBeginCtl.Text = rowFormApply.PromotionBeginDate.ToString("yyyy-MM-dd");
}
if (!rowFormApply.IsPromotionEndDateNull())
{
this.PromotionEndCtl.Text = rowFormApply.PromotionEndDate.ToString("yyyy-MM-dd");
}
this.PromotionScopeCtl.Text = masterBll.GetPromotionScopeById(rowFormApply.PromotionScopeID).PromotionScopeName;
this.PromotionTypeCtl.Text = masterBll.GetPromotionTypeById(rowFormApply.PromotionTypeID).PromotionTypeName;
if (!rowFormApply.IsPromotionDescNull())
{
this.PromotionDescCtl.Text = rowFormApply.PromotionDesc;
}
this.ShelfTypeCtl.Text = masterBll.GetShelfTypeById(rowFormApply.ShelfTypeID).ShelfTypeName;
if (!rowFormApply.IsFirstVolumeNull())
{
this.FirstVolumeCtl.Text = rowFormApply.FirstVolume.ToString();
}
if (!rowFormApply.IsSecondVolumeNull())
{
this.SecondVolumeCtl.Text = rowFormApply.SecondVolume.ToString();
}
if (!rowFormApply.IsThirdVolumeNull())
{
this.ThirdVolumeCtl.Text = rowFormApply.ThirdVolume.ToString();
}
if (!rowFormApply.IsAverageVolumeNull())
{
this.AverageVolumeCtl.Text = rowFormApply.AverageVolume.ToString();
}
if (!rowFormApply.IsEstimatedSaleVolumeNull())
{
this.txtEstimatedSaleVolume.Text = rowFormApply.EstimatedSaleVolume.ToString();
}
if (!rowFormApply.IsPackageUnitPriceNull())
{
this.txtPackageUnitPrice.Text = rowFormApply.PackageUnitPrice.ToString("N");
}
if (!rowFormApply.IsFormApplyNameNull())
{
this.txtFormApplyName.Text = rowFormApply.FormApplyName;
}
//查看预算信息按钮
this.btnViewBudget.NavigateUrl = "javascript:window.showModalDialog('" + System.Configuration.ConfigurationManager.AppSettings["WebSiteUrl"] + "/ReportManage/SalesBudgetByPosition.aspx?ShowDialog=1','', 'dialogWidth:1035px;dialogHeight:660px;resizable:yes;')";
//预算信息
this.CustomerBudgetCtl.Text = rowFormApply.CustomerBudget.ToString("N");
this.CustomerBudgetRemainCtl.Text = rowFormApply.CustomerBudgetRemain.ToString("N");
this.OUBudgetCtl.Text = rowFormApply.OUBudget.ToString("N");
this.OUApprovedAmountCtl.Text = rowFormApply.OUAppovedAmount.ToString("N");
this.OUApprovingAmountCtl.Text = rowFormApply.OUApprovingAmount.ToString("N");
this.OUCompletedAmountCtl.Text = rowFormApply.OUCompletedAmount.ToString("N");
this.OUReimbursedAmountCtl.Text = rowFormApply.OUReimbursedAmount.ToString("N");
this.OUBudgetRemainCtl.Text = rowFormApply.OUBudgetRemain.ToString("N");
this.OUBudgetRateCtl.Text = ((decimal)(rowFormApply.OUBudgetRate * 100)).ToString("N") + "%";
AuthorizationDS.StuffUserRow stuffUser = (AuthorizationDS.StuffUserRow)Session["StuffUser"];
this.ViewState["StuffUserID"] = stuffUser.StuffUserId;
//是否显示关闭按钮,如果没有执行完成的话那么不能关闭
this.CloseBtn.Visible = false;
if ((!rowFormApply.IsClose) && rowForm.StatusID == (int)SystemEnums.FormStatus.ApproveCompleted)
{
if (stuffUser.StuffUserId == rowForm.UserID || new MasterDataBLL().GetProxyReimburseByParameter(rowForm.UserID, stuffUser.StuffUserId, rowForm.SubmitDate).Count > 0)
{
if (!rowFormApply.IsIsCompleteNull())
{
if (rowFormApply.IsComplete)
{
this.CloseBtn.Visible = true;
}
}
}
}
//是否显示复制按钮
if (rowForm.StatusID == (int)SystemEnums.FormStatus.ApproveCompleted && stuffUser.StuffUserId == rowForm.UserID)
{
this.UCBeginPeriod.Visible = true;
this.UCEndPeriod.Visible = true;
this.lblSignal.Visible = true;
this.CopyBtn.Visible = true;
}
else
{
this.UCBeginPeriod.Visible = false;
this.UCEndPeriod.Visible = false;
this.lblSignal.Visible = false;
this.CopyBtn.Visible = false;
}
//是否显示打印信息
if (((stuffUser.StuffUserId == rowForm.UserID || base.IsBusinessProxy(rowForm.UserID, rowForm.SubmitDate) && rowForm.StatusID == (int)SystemEnums.FormStatus.ApproveCompleted) || (rowForm.StatusID == (int)SystemEnums.FormStatus.Scrap && rowFormApply.IsAutoSplit)))
{
this.PrintBtn.Visible = true;
}
else
{
this.PrintBtn.Visible = false;
}
if (rowForm.StatusID == (int)SystemEnums.FormStatus.ApproveCompleted || (rowForm.StatusID == (int)SystemEnums.FormStatus.Scrap && rowFormApply.IsAutoSplit))
{
this.PrintInfor.Visible = true;
int printCount = rowFormApply.IsPrintCountNull() ? 0 : rowFormApply.PrintCount;
this.PrintInfor.Text = "该方案已经被打印" + printCount + "次";
}
else
{
this.PrintInfor.Visible = false;
}
//如果是弹出,取消按钮不可见
if (this.Request["ShowDialog"] != null)
{
if (this.Request["ShowDialog"].ToString() == "1")
{
this.upButton.Visible = false;
this.PrintInfor.Visible = false;
this.PrintBtn.Visible = false;
this.Master.FindControl("divMenu").Visible = false;
this.Master.FindControl("tbCurrentPage").Visible = false;
}
}
//如果是申请人则隐藏预算信息
if (stuffUser.StuffUserId == rowForm.UserID)
{
this.OUBudgetCtl.Text = "";
this.OUApprovedAmountCtl.Text = "";
this.OUApprovingAmountCtl.Text = "";
this.OUCompletedAmountCtl.Text = "";
this.OUReimbursedAmountCtl.Text = "";
this.OUBudgetRemainCtl.Text = "";
this.OUBudgetRateCtl.Text = "";
this.btnViewBudget.Visible = false;
}
//处理执行确认内容
if (!rowFormApply.IsConfirmCompleteDateNull())
{
ConfirmCompleteDateCtl.Text = rowFormApply.ConfirmCompleteDate.ToString("yyyy-MM-dd");
}
if (!rowFormApply.IsAccruedPeriodNull())
{
AccruedPeriodCtl.Text = rowFormApply.AccruedPeriod.ToString("yyyy-MM");
}
//如果是申请人并且没有执行确认，实际费用才可以编辑
this.ViewState["ExecuteReadOnly"] = true;
if (!rowFormApply.IsIsCompleteNull())
{
if (!rowFormApply.IsComplete && rowForm.StatusID == (int)SystemEnums.FormStatus.ApproveCompleted)
{
if (rowForm.UserID == stuffUser.StuffUserId || new MasterDataBLL().GetProxyReimburseByParameter(rowForm.UserID, stuffUser.StuffUserId, rowForm.SubmitDate).Count > 0)
{
this.ViewState["ExecuteReadOnly"] = false;
this.AccrudePeriodSignal.Visible = true;
this.PeriodDDL.Visible = true;
this.ExecuteConfirmBtn.Visible = true;
this.ExecuteCancelBtn.Visible = true;
}
}
}
//分摊比例
new FormApplySplitRateTableAdapter().FillByApplyID(InnerDS.FormApplySplitRate, formID);
if (InnerDS.FormApplySplitRate != null && InnerDS.FormApplySplitRate.Count > 0)
{
this.divSplitRate.Visible = true;
this.gvSplitRate.Visible = true;
this.gvSplitRate.DataSource = InnerDS.FormApplySplitRate;
this.gvSplitRate.DataBind();
}
}
//明细信息
FormApplyDetailViewTableAdapter taDetail = new FormApplyDetailViewTableAdapter();
taDetail.FillByFormID(this.InnerDS.FormApplyDetailView, (int)this.ViewState["ObjectId"]);
FormApplyExpenseDetailTableAdapter taExpense = new FormApplyExpenseDetailTableAdapter();
taExpense.FillByFormApplyID(this.InnerDS.FormApplyExpenseDetail, (int)this.ViewState["ObjectId"]);
this.cwfAppCheck.FormID = (int)this.ViewState["ObjectId"];
this.cwfAppCheck.ProcID = this.ViewState["ProcID"].ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
base.Page_Load(sender, e);
if (!this.IsPostBack)
{
PageUtility.SetContentTitle(this.Page, "方案申请审批");
this.Page.Title = "方案申请审批";
int formID = int.Parse(Request["ObjectId"]);
this.ViewState["ObjectId"] = formID;
FormDS.FormRow rowForm = this.SalesApplyBLL.GetFormByID(formID)[0];
FormDS.FormApplyRow rowFormApply = this.SalesApplyBLL.GetFormApplyByID(formID)[0];
if (rowForm.IsProcIDNull())
{
ViewState["ProcID"] = "";
}
else
{
ViewState["ProcID"] = rowForm.ProcID;
}
ViewState["OrganizationUnitID"] = rowForm.OrganizationUnitID;
this.FormNoCtl.Text = rowForm.FormNo;
this.ApplyDateCtl.Text = rowForm.SubmitDate.ToShortDateString();
AuthorizationDS.StuffUserRow applicant = new AuthorizationBLL().GetStuffUserById(rowForm.UserID);
this.StuffNameCtl.Text = applicant.StuffName;
this.PositionNameCtl.Text = new OUTreeBLL().GetPositionById(rowForm.PositionID).PositionName;
if (new OUTreeBLL().GetOrganizationUnitById(rowForm.OrganizationUnitID) != null)
{
this.DepartmentNameCtl.Text = new OUTreeBLL().GetOrganizationUnitById(rowForm.OrganizationUnitID).OrganizationUnitName;
}
this.AttendDateCtl.Text = applicant.AttendDate.ToShortDateString();
this.BeginPeriodCtl.Text = rowFormApply.BeginPeriod.ToShortDateString();
this.EndPeriodCtl.Text = rowFormApply.EndPeriod.ToShortDateString();
MasterDataBLL masterBll = new MasterDataBLL();
this.ExpenseSubCategoryCtl.Text = masterBll.GetExpenseSubCateNameById(rowFormApply.ExpenseSubCategoryID);
ERS.CustomerRow customer = masterBll.GetCustomerById(rowFormApply.CustomerID);
this.CustomerNameCtl.Text = customer.CustomerName;
this.CustomerTypeCtl.Text = masterBll.GetCustomerTypeById(customer.CustomerTypeID).CustomerTypeName;
this.ShopNameCtl.Text = masterBll.GetShopByID(rowFormApply.ShopID).ShopName;
this.PaymentTypeCtl.Text = masterBll.GetPaymentTypeById(rowFormApply.PaymentTypeID).PaymentTypeName;
if (!rowFormApply.IsContractNoNull())
{
this.ContractNoCtl.Text = rowFormApply.ContractNo;
}
this.AmountCtl.Text = rowFormApply.Amount.ToString("N");
if (!rowFormApply.IsRemarkNull())
{
this.RemarkCtl.Text = rowFormApply.Remark;
}
if (!rowFormApply.IsAttachedFileNameNull())
{
this.UCFileUpload.AttachmentFileName = rowFormApply.AttachedFileName;
}
if (!rowFormApply.IsRealAttachedFileNameNull())
{
this.UCFileUpload.RealAttachmentFileName = rowFormApply.RealAttachedFileName;
}
//历史单据
if (rowForm.IsRejectedFormIDNull())
{
lblRejectFormNo.Text = "无";
}
else
{
FormDS.FormRow rejectedForm = new SalesApplyBLL().GetFormByID(rowForm.RejectedFormID)[0];
this.lblRejectFormNo.Text = rejectedForm.FormNo;
this.lblRejectFormNo.NavigateUrl = "javascript:window.showModalDialog('" + System.Configuration.ConfigurationManager.AppSettings["WebSiteUrl"] + "/SalesForm/SalesRebateApproval.aspx?ShowDialog=1&ObjectId=" + rejectedForm.FormID + "','', 'dialogWidth:1000px;dialogHeight:750px;resizable:yes;')";
}
//查看预算信息按钮
this.btnViewBudget.NavigateUrl = "javascript:window.showModalDialog('" + System.Configuration.ConfigurationManager.AppSettings["WebSiteUrl"] + "/ReportManage/SalesFeeByPosition.aspx?ShowDialog=1','', 'dialogWidth:918px;dialogHeight:660px;resizable:yes;')";
//预算信息
this.CustomerBudgetCtl.Text = rowFormApply.CustomerBudget.ToString("N");
this.CustomerBudgetRemainCtl.Text = rowFormApply.CustomerBudgetRemain.ToString("N");
this.OUBudgetCtl.Text = rowFormApply.OUBudget.ToString("N");
this.OUApprovedAmountCtl.Text = rowFormApply.OUAppovedAmount.ToString("N");
this.OUApprovingAmountCtl.Text = rowFormApply.OUApprovingAmount.ToString("N");
this.OUCompletedAmountCtl.Text = rowFormApply.OUCompletedAmount.ToString("N");
this.OUReimbursedAmountCtl.Text = rowFormApply.OUReimbursedAmount.ToString("N");
this.OUBudgetRemainCtl.Text = rowFormApply.OUBudgetRemain.ToString("N");
this.OUBudgetRateCtl.Text = ((decimal)(rowFormApply.OUBudgetRate * 100)).ToString("N") + "%";
this.odsApplyDetails.SelectParameters["FormID"].DefaultValue = rowFormApply.FormApplyID.ToString();
//审批页面处理&按钮处理
AuthorizationDS.StuffUserRow stuffUser = (AuthorizationDS.StuffUserRow)Session["StuffUser"];
this.ViewState["StuffUserID"] = stuffUser.StuffUserId;
if (rowForm.InTurnUserIds.Contains("P" + stuffUser.StuffUserId + "P"))
{
this.SubmitBtn.Visible = true;
this.cwfAppCheck.IsView = false;
this.ViewState["IsView"] = false;
}
else
{
this.SubmitBtn.Visible = false;
this.cwfAppCheck.IsView = true;
this.ViewState["IsView"] = true;
}
if (rowForm.StatusID == (int)SystemEnums.FormStatus.Rejected && stuffUser.StuffUserId == rowForm.UserID)
{
this.EditBtn.Visible = true;
this.ScrapBtn.Visible = true;
}
else
{
this.EditBtn.Visible = false;
this.ScrapBtn.Visible = false;
}
//关闭按钮
if ((!rowFormApply.IsClose) && rowForm.StatusID == (int)SystemEnums.FormStatus.ApproveCompleted)
{
if (stuffUser.StuffUserId == rowForm.UserID || new MasterDataBLL().GetProxyReimburseByParameter(rowForm.UserID, stuffUser.StuffUserId, rowForm.SubmitDate).Count > 0)
{
this.CloseBtn.Visible = true;
}
else
{
this.CloseBtn.Visible = false;
}
}
else
{
this.CloseBtn.Visible = false;
}
//如果是弹出,取消按钮不可见
if (this.Request["ShowDialog"] != null)
{
if (this.Request["ShowDialog"].ToString() == "1")
{
this.upButton.Visible = false;
this.Master.FindControl("divMenu").Visible = false;
this.Master.FindControl("tbCurrentPage").Visible = false;
}
}
//如果是申请人则隐藏预算信息
if (stuffUser.StuffUserId == rowForm.UserID)
{
this.OUBudgetCtl.Text = "";
this.OUApprovedAmountCtl.Text = "";
this.OUApprovingAmountCtl.Text = "";
this.OUCompletedAmountCtl.Text = "";
this.OUReimbursedAmountCtl.Text = "";
this.OUBudgetRemainCtl.Text = "";
this.OUBudgetRateCtl.Text = "";
this.btnViewBudget.Visible = false;
}
}
this.cwfAppCheck.FormID = (int)this.ViewState["ObjectId"];
this.cwfAppCheck.ProcID = this.ViewState["ProcID"].ToString();
this.cwfAppCheck.IsView = (bool)this.ViewState["IsView"];
}
protected void Page_Load(object sender, EventArgs e)
{
base.Page_Load(sender, e);
if (!this.IsPostBack)
{
PageUtility.SetContentTitle(this.Page, "方案报销审批");
this.Page.Title = "方案报销审批";
int formID = int.Parse(Request["ObjectId"]);
this.ViewState["ObjectId"] = formID;
FormDS.FormRow rowForm = this.SalesReimburseBLL.GetFormByID(formID)[0];
FormDS.FormReimburseRow rowFormReimburse = this.SalesReimburseBLL.GetFormReimburseByID(formID)[0];
//如果单据没有审批完成的话，是不能录入或者查看发货信息的
if (rowForm.StatusID != (int)SystemEnums.FormStatus.ApproveCompleted)
{
this.gvSKUDetails.Columns[6].Visible = false;
this.gvSKUDetails.Columns[5].HeaderStyle.Width = 400;
this.DeliveryDIV.Visible = false;
this.upDelivery.Visible = false;
}
if (this.gvSKUDetails.SelectedIndex < 0)
{
this.fvDelievery.Visible = false;
}
//如果没有修改权限的话那么不能新增和删除
int opManageId = BusinessUtility.GetBusinessOperateId(SystemEnums.BusinessUseCase.DeliveryInfo, SystemEnums.OperateEnum.Manage);
AuthorizationDS.PositionRow position = (AuthorizationDS.PositionRow) this.Session["Position"];
PositionRightBLL positionRightBLL = new PositionRightBLL();
this.HasManageRight = positionRightBLL.CheckPositionRight(position.PositionId, opManageId);
//流程ID
if (rowForm.IsProcIDNull())
{
ViewState["ProcID"] = "";
}
else
{
ViewState["ProcID"] = rowForm.ProcID;
}
ViewState["OrganizationUnitID"] = rowForm.OrganizationUnitID;
this.FormNoCtl.Text = rowForm.FormNo;
this.ApplyDateCtl.Text = rowForm.SubmitDate.ToShortDateString();
AuthorizationDS.StuffUserRow applicant = new AuthorizationBLL().GetStuffUserById(rowForm.UserID);
this.StuffNameCtl.Text = applicant.StuffName;
this.PositionNameCtl.Text = new OUTreeBLL().GetPositionById(rowForm.PositionID).PositionName;
if (new OUTreeBLL().GetOrganizationUnitById(rowForm.OrganizationUnitID) != null)
{
this.DepartmentNameCtl.Text = new OUTreeBLL().GetOrganizationUnitById(rowForm.OrganizationUnitID).OrganizationUnitName;
}
this.AttendDateCtl.Text = applicant.AttendDate.ToShortDateString();
MasterDataBLL masterBll = new MasterDataBLL();
ERS.CustomerRow customer = masterBll.GetCustomerById(rowFormReimburse.CustomerID);
this.CustomerNameCtl.Text = customer.CustomerName;
this.CustomerTypeCtl.Text = masterBll.GetCustomerTypeById(customer.CustomerTypeID).CustomerTypeName;
this.PaymentTypeCtl.Text = masterBll.GetPaymentTypeById(rowFormReimburse.PaymentTypeID).PaymentTypeName;
if (!rowFormReimburse.IsRemarkNull())
{
this.RemarkCtl.Text = rowFormReimburse.Remark;
}
if (!rowFormReimburse.IsAttachedFileNameNull())
{
this.UCFileUpload.AttachmentFileName = rowFormReimburse.AttachedFileName;
}
if (!rowFormReimburse.IsRealAttachedFileNameNull())
{
this.UCFileUpload.RealAttachmentFileName = rowFormReimburse.RealAttachedFileName;
}
this.odsSKUDetails.SelectParameters["FormReimburseID"].DefaultValue = rowFormReimburse.FormReimburseID.ToString();
this.odsReimburseDetails.SelectParameters["FormReimburseID"].DefaultValue = rowFormReimburse.FormReimburseID.ToString();
//审批页面处理&按钮处理
AuthorizationDS.StuffUserRow stuffUser = (AuthorizationDS.StuffUserRow)Session["StuffUser"];
this.ViewState["StuffUserID"] = stuffUser.StuffUserId;
if (rowForm.InTurnUserIds.Contains("P" + stuffUser.StuffUserId + "P"))
{
this.SubmitBtn.Visible = true;
this.cwfAppCheck.IsView = false;
this.ViewState["IsView"] = false;
}
else
{
this.SubmitBtn.Visible = false;
this.cwfAppCheck.IsView = true;
this.ViewState["IsView"] = true;
}
if (rowForm.StatusID == (int)SystemEnums.FormStatus.Rejected && stuffUser.StuffUserId == rowForm.UserID)
{
this.EditBtn.Visible = true;
this.ScrapBtn.Visible = true;
}
else
{
this.EditBtn.Visible = false;
this.ScrapBtn.Visible = false;
}
//历史单据
if (rowForm.IsRejectedFormIDNull())
{
lblRejectFormNo.Text = "无";
}
else
{
FormDS.FormRow rejectedForm = this.SalesReimburseBLL.GetFormByID(rowForm.RejectedFormID)[0];
this.lblRejectFormNo.Text = rejectedForm.FormNo;
this.lblRejectFormNo.NavigateUrl = "javascript:window.showModalDialog('" + System.Configuration.ConfigurationManager.AppSettings["WebSiteUrl"] + "/OtherForm/ReimburseGoodsApproval.aspx?ShowDialog=1&ObjectId=" + rejectedForm.FormID + "','', 'dialogWidth:1000px;dialogHeight:750px;resizable:yes;')";
}
//如果是弹出,按钮不可见
if (this.Request["ShowDialog"] != null)
{
if (this.Request["ShowDialog"].ToString() == "1")
{
this.upButton.Visible = false;
this.gvSKUDetails.Columns[6].Visible = false;
this.gvSKUDetails.Columns[5].HeaderStyle.Width = 400;
this.Master.FindControl("divMenu").Visible = false;
this.Master.FindControl("tbCurrentPage").Visible = false;
}
}
//发货完成按钮权限
opManageId = BusinessUtility.GetBusinessOperateId(SystemEnums.BusinessUseCase.DeliveryComplete, SystemEnums.OperateEnum.Other);
position = (AuthorizationDS.PositionRow) this.Session["Position"];
if (positionRightBLL.CheckPositionRight(position.PositionId, opManageId) && (rowFormReimburse.IsIsDeliveryCompleteNull() || rowFormReimburse.IsDeliveryComplete == false))
{
this.btnDeliveryComplete.Visible = true;
}
else
{
this.btnDeliveryComplete.Visible = false;
//this.gvDelivery.Visible = false;
//this.gvSKUDetails.Columns[6].Visible=false;
//this.gvSKUDetails.Columns[5].ItemStyle.Width = 400;
}
}
this.cwfAppCheck.FormID = (int)this.ViewState["ObjectId"];
this.cwfAppCheck.ProcID = this.ViewState["ProcID"].ToString();
this.cwfAppCheck.IsView = (bool)this.ViewState["IsView"];
}
public void SaveDataToDB(string FullPath, string FileName, string excelFileExtension)
{
SqlTransaction transaction = null;
try {
DataTable dt = null;
dt = this.GetDataSet(FullPath, excelFileExtension).Tables[0];
if (dt.Rows.Count <= 1)
{
PageUtility.ShowModelDlg(this.Page, "文件中没有任何记录，请重新选择");
return;
}
CustomerTableAdapter TACustomer = new CustomerTableAdapter();
ImportLogTableAdapter TAImportLog = new ImportLogTableAdapter();
ImportLogDetailTableAdapter TAImportLogDetail = new ImportLogDetailTableAdapter();
MasterDataBLL mdBLL = new MasterDataBLL();
transaction = TableAdapterHelper.BeginTransaction(TACustomer);
TableAdapterHelper.SetTransaction(TAImportLog, transaction);
TableAdapterHelper.SetTransaction(TAImportLogDetail, transaction);
//存储log信息
ImportDS.ImportLogDataTable logTable = new ImportDS.ImportLogDataTable();
ImportDS.ImportLogRow logRow = logTable.NewImportLogRow();
int stuffUserID = ((AuthorizationDS.StuffUserRow)Session["StuffUser"]).StuffUserId;
string fullname = this.fileUpLoad.PostedFile.FileName.ToString();
string tmpFile = fullname.Remove(0, fullname.LastIndexOf("\\") + 1);
logRow.FileName = tmpFile;
logRow.ImportDate = DateTime.Now;
logRow.ImportUserID = stuffUserID;
logRow.ImportType = 3;
logRow.TotalCount = dt.Rows.Count - 1;
logRow.SuccessCount = dt.Rows.Count - 1;
logRow.FailCount = 0;
logTable.AddImportLogRow(logRow);
TAImportLog.Update(logTable);
//处理每条明细
ERS.CustomerDataTable tbCustomer = new ERS.CustomerDataTable();
ImportDS.ImportLogDetailDataTable ImportLogDetailTable = new ImportDS.ImportLogDetailDataTable();
int row_count = dt.Rows.Count;
string errorInfor = string.Empty;
// int expenseTypeID = int.Parse(ExpenseTypeDDL.SelectedValue);
//开始处理每条明细
for (int i = 1; i <= row_count - 1; i++)
{
if (CheckData(dt.Rows[i]) != null)
{
errorInfor = "第" + (i + 1) + "行有错：" + CheckData(dt.Rows[i]);
ImportDS.ImportLogDetailRow ImportDetailRow = ImportLogDetailTable.NewImportLogDetailRow();
ImportDetailRow.LogID = logRow.LogID;
ImportDetailRow.Line = i + 1;
ImportDetailRow.Error = errorInfor;
ImportLogDetailTable.AddImportLogDetailRow(ImportDetailRow);
logRow.FailCount = logRow.FailCount + 1;
logRow.SuccessCount = logRow.SuccessCount - 1;
TAImportLog.Update(logRow);
continue;
}
else
{
DataRow row = dt.Rows[i];
string CustomerNo = row[0].ToString().Trim();
string CustomerName = row[1].ToString().Trim();
string ProvinceName = row[2].ToString().Trim();
string CityName = row[3].ToString().Trim();
string CustomerTypeName = row[4].ToString().Trim();
string ChannelTypeName = row[5].ToString().Trim();
string OUName = row[6].ToString().Trim();
string BudgetOUName = row[7].ToString().Trim();
ERS.CustomerDataTable tbCustomerTemp = mdBLL.GetCustomerByCustomerName(CustomerName);
if (tbCustomerTemp != null && tbCustomerTemp.Count > 0)
{
errorInfor = "第" + (i + 1) + "行有错：已存在客户《" + CustomerName + "》";
ImportDS.ImportLogDetailRow ImportDetailRow = ImportLogDetailTable.NewImportLogDetailRow();
ImportDetailRow.LogID = logRow.LogID;
ImportDetailRow.Line = i + 1;
ImportDetailRow.Error = errorInfor;
ImportLogDetailTable.AddImportLogDetailRow(ImportDetailRow);
logRow.FailCount = logRow.FailCount + 1;
logRow.SuccessCount = logRow.SuccessCount - 1;
TAImportLog.Update(logRow);
continue;
}
//ERS.ProvinceDataTable tbProvince = mdBLL.GetProvinceByProvinceName(ProvinceName);
//if (tbProvince == null || tbProvince.Count == 0) {
// errorInfor = "第" + (i + 1) + "行有错：找不到省份《" + ProvinceName + "》";
// ImportDS.ImportLogDetailRow ImportDetailRow = ImportLogDetailTable.NewImportLogDetailRow();
// ImportDetailRow.LogID = logRow.LogID;
// ImportDetailRow.Line = i + 1;
// ImportDetailRow.Error = errorInfor;
// ImportLogDetailTable.AddImportLogDetailRow(ImportDetailRow);
// logRow.FailCount = logRow.FailCount + 1;
// logRow.SuccessCount = logRow.SuccessCount - 1;
// TAImportLog.Update(logRow);
// continue;
//}
ERS.CityDataTable tbCity = mdBLL.GetCityByCityName(CityName);
if (tbCity == null || tbCity.Count == 0)
{
errorInfor = "第" + (i + 1) + "行有错：找不到城市《" + CityName + "》";
ImportDS.ImportLogDetailRow ImportDetailRow = ImportLogDetailTable.NewImportLogDetailRow();
ImportDetailRow.LogID = logRow.LogID;
ImportDetailRow.Line = i + 1;
ImportDetailRow.Error = errorInfor;
ImportLogDetailTable.AddImportLogDetailRow(ImportDetailRow);
logRow.FailCount = logRow.FailCount + 1;
logRow.SuccessCount = logRow.SuccessCount - 1;
TAImportLog.Update(logRow);
continue;
}
ERS.CustomerTypeDataTable tbCustomerType = mdBLL.GetCustomerTypeByCustomerTypeName(CustomerTypeName);
if (tbCustomerType == null || tbCustomerType.Count == 0)
{
errorInfor = "第" + (i + 1) + "行有错：找不到客户类型《" + CustomerTypeName + "》";
ImportDS.ImportLogDetailRow ImportDetailRow = ImportLogDetailTable.NewImportLogDetailRow();
ImportDetailRow.LogID = logRow.LogID;
ImportDetailRow.Line = i + 1;
ImportDetailRow.Error = errorInfor;
ImportLogDetailTable.AddImportLogDetailRow(ImportDetailRow);
logRow.FailCount = logRow.FailCount + 1;
logRow.SuccessCount = logRow.SuccessCount - 1;
TAImportLog.Update(logRow);
continue;
}
ERS.ChannelTypeDataTable tbChannelType = mdBLL.GetChannelTypeByChannelTypeName(ChannelTypeName);
if (tbChannelType == null || tbChannelType.Count == 0)
{
errorInfor = "第" + (i + 1) + "行有错：找不到客户渠道《" + ChannelTypeName + "》";
ImportDS.ImportLogDetailRow ImportDetailRow = ImportLogDetailTable.NewImportLogDetailRow();
ImportDetailRow.LogID = logRow.LogID;
ImportDetailRow.Line = i + 1;
ImportDetailRow.Error = errorInfor;
ImportLogDetailTable.AddImportLogDetailRow(ImportDetailRow);
logRow.FailCount = logRow.FailCount + 1;
logRow.SuccessCount = logRow.SuccessCount - 1;
TAImportLog.Update(logRow);
continue;
}
AuthorizationDS.OrganizationUnitDataTable ouTable = new OUTreeBLL().GetDataByOrganizationUnitName(OUName);
if (ouTable == null || ouTable.Count == 0)
{
errorInfor = "第" + (i + 1) + "行有错：系统中找不到此部门《" + OUName + "》";
ImportDS.ImportLogDetailRow ImportDetailRow = ImportLogDetailTable.NewImportLogDetailRow();
ImportDetailRow.LogID = logRow.LogID;
ImportDetailRow.Line = i + 1;
ImportDetailRow.Error = errorInfor;
ImportLogDetailTable.AddImportLogDetailRow(ImportDetailRow);
logRow.FailCount = logRow.FailCount + 1;
logRow.SuccessCount = logRow.SuccessCount - 1;
TAImportLog.Update(logRow);
continue;
}
if (ouTable.Count > 1)
{
errorInfor = "第" + (i + 1) + "行有错：系统中找到多个此名称的部门《" + OUName + "》";
ImportDS.ImportLogDetailRow ImportDetailRow = ImportLogDetailTable.NewImportLogDetailRow();
ImportDetailRow.LogID = logRow.LogID;
ImportDetailRow.Line = i + 1;
ImportDetailRow.Error = errorInfor;
ImportLogDetailTable.AddImportLogDetailRow(ImportDetailRow);
logRow.FailCount = logRow.FailCount + 1;
logRow.SuccessCount = logRow.SuccessCount - 1;
TAImportLog.Update(logRow);
continue;
}
AuthorizationDS.OrganizationUnitDataTable BudgetOUTable = new OUTreeBLL().GetDataByOrganizationUnitName(BudgetOUName);
if (BudgetOUTable == null || BudgetOUTable.Count == 0)
{
errorInfor = "第" + (i + 1) + "行有错：系统中找不到此部门《" + BudgetOUName + "》";
ImportDS.ImportLogDetailRow ImportDetailRow = ImportLogDetailTable.NewImportLogDetailRow();
ImportDetailRow.LogID = logRow.LogID;
ImportDetailRow.Line = i + 1;
ImportDetailRow.Error = errorInfor;
ImportLogDetailTable.AddImportLogDetailRow(ImportDetailRow);
logRow.FailCount = logRow.FailCount + 1;
logRow.SuccessCount = logRow.SuccessCount - 1;
TAImportLog.Update(logRow);
continue;
}
if (BudgetOUTable.Count > 1)
{
errorInfor = "第" + (i + 1) + "行有错：系统中找到多个此名称的部门《" + BudgetOUName + "》";
ImportDS.ImportLogDetailRow ImportDetailRow = ImportLogDetailTable.NewImportLogDetailRow();
ImportDetailRow.LogID = logRow.LogID;
ImportDetailRow.Line = i + 1;
ImportDetailRow.Error = errorInfor;
ImportLogDetailTable.AddImportLogDetailRow(ImportDetailRow);
logRow.FailCount = logRow.FailCount + 1;
logRow.SuccessCount = logRow.SuccessCount - 1;
TAImportLog.Update(logRow);
continue;
}
ERS.CustomerRow rowCustomer = tbCustomer.NewCustomerRow();
rowCustomer.CustomerNo = CustomerNo;
rowCustomer.CustomerName = CustomerName;
rowCustomer.CityID = tbCity[0].CityID;
rowCustomer.CustomerTypeID = tbCustomerType[0].CustomerTypeID;
rowCustomer.ChannelTypeID = tbChannelType[0].ChannelTypeID;
rowCustomer.OrganizationUnitID = ouTable[0].OrganizationUnitId;
rowCustomer.ApplyOrganizationUnitID = BudgetOUTable[0].OrganizationUnitId;
rowCustomer.IsActive = true;
tbCustomer.AddCustomerRow(rowCustomer);
TACustomer.Update(rowCustomer);
}
}
TAImportLog.Update(logRow);
TAImportLogDetail.Update(ImportLogDetailTable);
transaction.Commit();
string returnString = "成功导入" + logRow.SuccessCount.ToString() + "条信息";
PageUtility.ShowModelDlg(this.Page, returnString);
} catch (Exception ex) {
if (transaction != null)
{
transaction.Rollback();
}
PageUtility.ShowModelDlg(this.Page, "Save Fail!" + ex.ToString());
} finally {
if (transaction != null)
{
transaction.Dispose();
}
}
}
