protected void Page_Load(object sender, EventArgs e)
{
base.Page_Load(sender, e);
if (!this.IsPostBack) {
String title = this.GetLocalResourceObject("titleLabel.Text").ToString();
PageUtility.SetContentTitle(this.Page, title);
// 用户信息，职位信息
AuthorizationDS.StuffUserRow stuffUser = (AuthorizationDS.StuffUserRow)Session["StuffUser"];
AuthorizationDS.PositionRow rowUserPosition = (AuthorizationDS.PositionRow)Session["Position"];
this.ViewState["StuffUserID"] = stuffUser.StuffUserId;
this.ViewState["PositionID"] = rowUserPosition.PositionId;
this.StuffNameCtl.Text = CommonUtility.GetStaffFullName(stuffUser);
this.PositionNameCtl.Text = rowUserPosition.PositionName;
this.DepartmentNameCtl.Text = new OUTreeBLL().GetOrganizationUnitById(rowUserPosition.OrganizationUnitId).OrganizationUnitName;
this.ViewState["DepartmentID"] = rowUserPosition.OrganizationUnitId;
this.StuffNoCtl.Text = stuffUser.IsStuffNoNull() ? "" : stuffUser.StuffNo;
this.AttendDateCtl.Text = stuffUser.AttendDate.ToShortDateString();
if (this.Request["RejectObjectID"] != null) {
this.ViewState["RejectedObjectID"] = int.Parse(this.Request["RejectObjectID"].ToString());
}
//如果是草稿进行赋值
if (Request["ObjectId"] != null) {
this.ViewState["ObjectId"] = int.Parse(Request["ObjectId"]);
if (this.Request["RejectObjectID"] == null) {
this.DeleteBtn.Visible = true;
} else {
this.DeleteBtn.Visible = false;
}
OpenForm(int.Parse(this.ViewState["ObjectId"].ToString()));
} else {
this.DeleteBtn.Visible = false;
if (Request["PeriodSaleID"] != null) {
DateTime FPeriod = new MasterDataBLL().GetPeriodSaleById(int.Parse(Request["PeriodSaleID"].ToString())).PeriodSale;
this.ViewState["FPeriod"] = new MasterDataBLL().GetPeriodSaleById(int.Parse(Request["PeriodSaleID"].ToString())).PeriodSale.ToShortDateString();
} else {
this.Session["ErrorInfor"] = "没有费用期间，请联系管理员";
Response.Redirect("~/ErrorPage/SystemErrorPage.aspx");
}
if (Request["BrandID"] != null) {
this.ViewState["BrandID"] = Request["BrandID"];
} else {
this.Session["ErrorInfor"] = "未找到Brand，请联系管理员";
Response.Redirect("~/ErrorPage/SystemErrorPage.aspx");
}
if (Request["CustomerChannelID"] != null) {
this.ViewState["CustomerChannelID"] = Request["CustomerChannelID"];
} else {
this.Session["ErrorInfor"] = "未找到Brand，请联系管理员";
Response.Redirect("~/ErrorPage/SystemErrorPage.aspx");
}
if (Request["CurrencyID"] != null) {
this.ViewState["CurrencyID"] = Request["CurrencyID"];
} else {
this.Session["ErrorInfor"] = "未找到币种，请联系管理员";
Response.Redirect("~/ErrorPage/SystemErrorPage.aspx");
}
if (Request["ExpenseSubCategoryID"] != null) {
this.ViewState["ExpenseSubCategoryID"] = Request["ExpenseSubCategoryID"];
} else {
this.Session["ErrorInfor"] = "未找到费用大类，请联系管理员";
Response.Redirect("~/ErrorPage/SystemErrorPage.aspx");
}
this.PeriodCtl.Text = DateTime.Parse(this.ViewState["FPeriod"].ToString()).ToString("yyyy-MM");
this.CustomerChannelCtl.Text = new CustomerChannelTableAdapter().GetDataByID(int.Parse(ViewState["CustomerChannelID"].ToString()))[0].CustomerChannelName;
this.BrandCtl.Text = new BrandTableAdapter().GetDataByID(int.Parse(this.ViewState["BrandID"].ToString()))[0].BrandName;
this.CurrencyCtl.Text = new CurrencyTableAdapter().GetDataByID(int.Parse(this.ViewState["CurrencyID"].ToString()))[0].CurrencyShortName;
this.ExpenseSubCategoryCtl.Text = new MasterDataBLL().GetExpenseSubCategoryById(int.Parse(this.ViewState["ExpenseSubCategoryID"].ToString())).ExpenseSubCategoryName;
}
this.hdnBrandID.Value = this.ViewState["BrandID"].ToString();
this.ExpenseSubCategoryID.Value = this.ViewState["ExpenseSubCategoryID"].ToString();
this.ViewState["ExchangeRate"] = new MasterDataBLL().GetExchangeRateByPeriod(int.Parse(ViewState["CurrencyID"].ToString()), DateTime.Parse(ViewState["FPeriod"].ToString()));
if (decimal.Parse(this.ViewState["ExchangeRate"].ToString()) == 0) {
this.Session["ErrorInfor"] = "未找到汇率，请联系管理员";
Response.Redirect("~/ErrorPage/SystemErrorPage.aspx");
}
this.ExchangeRateCtl.Text = this.ViewState["ExchangeRate"].ToString();
//判断费用期间是否正确
MasterDataBLL bll = new MasterDataBLL();
if (!new MasterDataBLL().IsValidPeriodSale(DateTime.Parse(this.ViewState["FPeriod"].ToString()))) {
this.SubmitBtn.Visible = false;
PageUtility.ShowModelDlg(this, "不允许申请本月项目，请删除草稿并联系财务部!");
return;
}
//预算信息
decimal[] calculateAssistant = new decimal[6];
calculateAssistant = new BudgetBLL().GetRDBudgetByParameter(rowUserPosition.PositionId, DateTime.Parse(ViewState["FPeriod"].ToString()), int.Parse(ViewState["CustomerChannelID"].ToString()), int.Parse(this.ViewState["BrandID"].ToString()), int.Parse(this.ViewState["ExpenseSubCategoryID"].ToString()));
this.TotalBudgetCtl.Text = calculateAssistant[0].ToString("N");
this.ApprovedAmountCtl.Text = calculateAssistant[1].ToString("N");
this.ApprovingAmountCtl.Text = calculateAssistant[2].ToString("N");
this.ReimbursedAmountCtl.Text = calculateAssistant[3].ToString("N");
this.RemainBudgetCtl.Text = calculateAssistant[4].ToString("N");
}
//隐藏预算信息,若需要则隐藏
}
protected void SaveFormApply(SystemEnums.FormStatus StatusID)
{
decimal TotalBudget = 0;
decimal ApprovedAmount = 0;
decimal ApprovingAmount = 0;
decimal ReimbursedAmount = 0;
decimal RemainBudget = 0;
if (StatusID == SystemEnums.FormStatus.Awaiting) {//提交时检查，保存草稿不检查
decimal[] calculateAssistant = new decimal[5];
calculateAssistant = new BudgetBLL().GetRDBudgetByParameter((int)this.ViewState["PositionID"], DateTime.Parse(ViewState["FPeriod"].ToString()), int.Parse(ViewState["CustomerChannelID"].ToString()), int.Parse(this.ViewState["BrandID"].ToString()), int.Parse(this.ViewState["ExpenseSubCategoryID"].ToString()));
if (calculateAssistant[4] < decimal.Parse(this.ViewState["TotalApplyAmount"].ToString())) {
PageUtility.ShowModelDlg(this.Page, "本次申请金额超过可用预算，不能提交", "the amount of this application is more than remain budget");
return;
} else {
TotalBudget = calculateAssistant[0];
ApprovedAmount = calculateAssistant[1];
ApprovingAmount = calculateAssistant[2];
ReimbursedAmount = calculateAssistant[3];
RemainBudget = calculateAssistant[4];
}
}
this.FormRDApplyBLL.FormDataSet = this.InnerDS;
int? RejectedFormID = null;
if (this.ViewState["RejectedObjectID"] != null) {
RejectedFormID = (int)this.ViewState["RejectedObjectID"];
}
int UserID = (int)this.ViewState["StuffUserID"];
int? ProxyStuffUserId = null;
if (Session["ProxyStuffUserId"] != null) {
ProxyStuffUserId = int.Parse(Session["ProxyStuffUserId"].ToString());
}
int OrganizationUnitID = (int)this.ViewState["DepartmentID"];
int PositionID = (int)this.ViewState["PositionID"];
DateTime FPeriod = DateTime.Parse(this.ViewState["FPeriod"].ToString());
int CurrencyID = int.Parse(this.ViewState["CurrencyID"].ToString());
string ProjectName = this.txtProjectName.Text;
string ProjectDesc = this.ProjectDescCtl.Text;
string ApplyFileName = this.UCFileUpload.AttachmentFileName;
string ApplyRealFileName = this.UCFileUpload.RealAttachmentFileName;
DateTime? ActivityBeginDate = null;
DateTime? ActivityEndDate = null;
if (this.UCActivityBegin.SelectedDate != string.Empty) {
ActivityBeginDate = DateTime.Parse(this.UCActivityBegin.SelectedDate);
}
if (this.UCActivityEnd.SelectedDate != string.Empty) {
ActivityEndDate = DateTime.Parse(this.UCActivityEnd.SelectedDate);
}
int? CostCenterID = null;
if (this.CostCenterDDL.SelectedValue != "0") {
CostCenterID = int.Parse(CostCenterDDL.SelectedValue);
}
try {
if (this.ViewState["ObjectId"] == null || RejectedFormID != null) {
this.FormRDApplyBLL.AddRDApply(RejectedFormID, UserID, ProxyStuffUserId, null, OrganizationUnitID, PositionID, SystemEnums.FormType.RDApply, StatusID, FPeriod,
int.Parse(ViewState["BrandID"].ToString()), int.Parse(ViewState["CustomerChannelID"].ToString()), CurrencyID, decimal.Parse(this.ViewState["ExchangeRate"].ToString()), ProjectName, ProjectDesc,
ApplyFileName, ApplyRealFileName, ActivityBeginDate, ActivityEndDate, CostCenterID, int.Parse(ViewState["ExpenseSubCategoryID"].ToString()), TotalBudget, ApprovedAmount, ApprovingAmount, ReimbursedAmount, RemainBudget);
} else {
int FormID = (int)this.ViewState["ObjectId"];
this.FormRDApplyBLL.UpdateRDApply(FormID, SystemEnums.FormType.RDApply, StatusID, decimal.Parse(this.ViewState["ExchangeRate"].ToString()), ProjectName, ProjectDesc,
ApplyFileName, ApplyRealFileName, ActivityBeginDate, ActivityEndDate, CostCenterID, TotalBudget, ApprovedAmount, ApprovingAmount, ReimbursedAmount, RemainBudget);
}
this.Page.Response.Redirect("~/Home.aspx");
} catch (Exception ex) {
PageUtility.DealWithException(this.Page, ex);
}
}
protected void SaveFormInvitationReimburseBLL(SystemEnums.FormStatus StatusID)
{
decimal TotalBudget = 0;
decimal ApprovedAmount = 0;
decimal ApprovingAmount = 0;
decimal RemainBudget = 0;
int? RejectedFormID = null;
if (this.ViewState["RejectedObjectID"] != null) {
RejectedFormID = (int)this.ViewState["RejectedObjectID"];
}
int UserID = (int)this.ViewState["StuffUserID"];
int? ProxyStuffUserId = null;
if (Session["ProxyStuffUserId"] != null) {
ProxyStuffUserId = int.Parse(Session["ProxyStuffUserId"].ToString());
}
int OrganizationUnitID = (int)this.ViewState["DepartmentID"];
int PositionID = (int)this.ViewState["PositionID"];
string Remark = this.RemarkCtl.Text;
DateTime? Period = null;
if (dplPeriod.SelectedValue != null && dplPeriod.SelectedValue != "0") {
Period = DateTime.Parse(this.dplPeriod.SelectedItem.Text.ToString() + "-1");
}
String CustomerName = this.txtCustomerName.Text;
String AttenderNames = this.txtAttenderNames.Text;
int AttenderCount = this.txtAttenderCount.Text == "" ? 0 : int.Parse(this.txtAttenderCount.Text);
String BusinessRelation = this.txtBusinessRelation.Text;
String Place = this.txtPlace.Text;
DateTime? OccuredDate = null;
if (this.UCOccuredDate.SelectedDate != null && this.UCOccuredDate.SelectedDate != "") {
OccuredDate = DateTime.Parse(this.UCOccuredDate.SelectedDate);
}
String BusinessPurpose = this.txtBusinessPurpose.Text;
int CurrencyID = int.Parse(this.dplCurrency.SelectedValue);
string InvitationType = this.txtInvitationType.Text;
Decimal ExchangeRate = this.txtExchageRate.Text == "" ? 1 : Decimal.Parse(this.txtExchageRate.Text);
Decimal Amount = this.txtAmount.Text == "" ? 0 : Decimal.Parse(this.txtAmount.Text);
if (StatusID == SystemEnums.FormStatus.Awaiting) {
if (ExchangeRate == 0) {
PageUtility.ShowModelDlg(this, "汇率不能为0!", "exchange rate should not equal zero");
return;
}
if (Amount == 0) {
PageUtility.ShowModelDlg(this, "申请金额不能为0!", "amount should not equal zero");
return;
}
decimal[] budgetInfo = new BudgetBLL().GetPersonalBudgetByParameter(PositionID, Period.GetValueOrDefault().Year);
TotalBudget = budgetInfo[0];
ApprovedAmount = budgetInfo[1];
ApprovingAmount = budgetInfo[2];
RemainBudget = budgetInfo[3];
if (Amount * ExchangeRate > budgetInfo[3]) {
PageUtility.ShowModelDlg(this, "超出预算，不能提交!", "Over budget, Can't submit!");
return;
}
}
int FormInvitationApplyID = this.ViewState["FormInvitationApplyID"] == null ? 0 : (int)this.ViewState["FormInvitationApplyID"];
try {
if (this.ViewState["ObjectId"] == null || RejectedFormID != null) {
this.FormTEBLL.AddFormInvitationReimburseApply(FormInvitationApplyID, RejectedFormID, UserID, ProxyStuffUserId, null, OrganizationUnitID, PositionID,SystemEnums.FormType.FormInvitationReimburse, StatusID,
Period, Remark, CustomerName, AttenderNames, AttenderCount, BusinessRelation, Place, OccuredDate, BusinessPurpose, InvitationType, CurrencyID, ExchangeRate, Amount, TotalBudget, ApprovingAmount, ApprovedAmount, RemainBudget,int.Parse(this.ddlManageExpenseItem.SelectedValue));
} else {
this.FormTEBLL.UpdateFormInvitationReimburseApply(RejectedFormID.GetValueOrDefault(), (int)this.ViewState["ObjectId"], (int)SystemEnums.FormType.FormInvitationReimburse, StatusID, Period, Remark,
CustomerName, AttenderNames, AttenderCount, BusinessRelation, Place, OccuredDate, BusinessPurpose, InvitationType, CurrencyID, ExchangeRate, Amount, TotalBudget, ApprovingAmount, ApprovedAmount, RemainBudget,int.Parse(this.ddlManageExpenseItem.SelectedValue));
}
this.Page.Response.Redirect("~/Home.aspx");
} catch (Exception ex) {
PageUtility.DealWithException(this.Page, ex);
}
}
protected void Page_Load(object sender, EventArgs e)
{
base.Page_Load(sender, e);
if (!this.IsPostBack) {
String title = this.GetLocalResourceObject("titleLabel.Text").ToString();
PageUtility.SetContentTitle(this.Page, title);
// 用户信息，职位信息
AuthorizationDS.StuffUserRow stuffUser = (AuthorizationDS.StuffUserRow)Session["StuffUser"];
AuthorizationDS.PositionRow rowUserPosition = (AuthorizationDS.PositionRow)Session["Position"];
this.ViewState["StuffUserID"] = stuffUser.StuffUserId;
this.ViewState["PositionID"] = rowUserPosition.PositionId;
this.StuffNameCtl.Text = CommonUtility.GetStaffFullName(stuffUser);
this.PositionNameCtl.Text = rowUserPosition.PositionName;
this.DepartmentNameCtl.Text = new OUTreeBLL().GetOrganizationUnitById(rowUserPosition.OrganizationUnitId).OrganizationUnitName;
this.ViewState["DepartmentID"] = rowUserPosition.OrganizationUnitId;
this.StuffNoCtl.Text = stuffUser.IsStuffNoNull() ? "" : stuffUser.StuffNo;
this.AttendDateCtl.Text = stuffUser.AttendDate.ToShortDateString();
if (this.Request["RejectObjectID"] != null) {
this.ViewState["RejectedObjectID"] = int.Parse(this.Request["RejectObjectID"].ToString());
}
//如果是草稿进行赋值
MasterDataBLL MasterDataBLL = new MasterDataBLL();
if (Request["ObjectId"] != null) {
this.ViewState["ObjectId"] = int.Parse(Request["ObjectId"]);
if (this.Request["RejectObjectID"] == null) {
this.DeleteBtn.Visible = true;
} else {
this.DeleteBtn.Visible = false;
}
OpenForm(int.Parse(this.ViewState["ObjectId"].ToString()));
} else {
this.DeleteBtn.Visible = false;
if (Request["PeriodSaleID"] != null) {
DateTime FPeriod = MasterDataBLL.GetPeriodSaleById(int.Parse(Request["PeriodSaleID"].ToString())).PeriodSale;
this.ViewState["FPeriod"] = new MasterDataBLL().GetPeriodSaleById(int.Parse(Request["PeriodSaleID"].ToString())).PeriodSale.ToShortDateString();
} else {
this.Session["ErrorInfor"] = "没有费用期间，请联系管理员";
Response.Redirect("~/ErrorPage/SystemErrorPage.aspx");
}
if (Request["CustomerID"] != null) {
this.ViewState["CustomerID"] = Request["CustomerID"];
} else {
this.Session["ErrorInfor"] = "未找到客户，请联系管理员";
Response.Redirect("~/ErrorPage/SystemErrorPage.aspx");
}
if (Request["BrandID"] != null) {
this.ViewState["BrandID"] = Request["BrandID"];
} else {
this.Session["ErrorInfor"] = "未找到Brand，请联系管理员";
Response.Redirect("~/ErrorPage/SystemErrorPage.aspx");
}
if (Request["ExpenseSubCategoryID"] != null) {
this.ViewState["ExpenseSubCategoryID"] = Request["ExpenseSubCategoryID"];
} else {
this.Session["ErrorInfor"] = "未找到费用小类，请联系管理员";
Response.Redirect("~/ErrorPage/SystemErrorPage.aspx");
}
if (Request["CurrencyID"] != null) {
this.ViewState["CurrencyID"] = Request["CurrencyID"];
} else {
this.Session["ErrorInfor"] = "未找到币种，请联系管理员";
Response.Redirect("~/ErrorPage/SystemErrorPage.aspx");
}
this.PeriodCtl.Text = DateTime.Parse(this.ViewState["FPeriod"].ToString()).ToString("yyyy-MM");
MasterData.CustomerRow customer = MasterDataBLL.GetCustomerById(int.Parse(this.ViewState["CustomerID"].ToString()))[0];
this.txtCustomerCode.Text = customer.CustomerNo;
this.CustomerNameCtl.Text = customer.CustomerName;
ViewState["CustomerChannelID"] = customer.CustomerChannelID.ToString();
this.CustomerChannelCtl.Text = MasterDataBLL.GetCustomerChannelById(customer.CustomerChannelID)[0].CustomerChannelName;
this.KATypeCtl.Text = customer.IsKaTypeNull() ? "" : customer.KaType;
this.CustomerRegionCtl.Text = MasterDataBLL.GetCustomerRegionById(customer.CustomerRegionID).CustomerRegionName;
this.CityCtl.Text = customer.City;
this.BrandCtl.Text = MasterDataBLL.GetBrandById(int.Parse(this.ViewState["BrandID"].ToString()))[0].BrandName;
MasterData.ExpenseSubCategoryRow rowExpenseSubCategory = MasterDataBLL.GetExpenseSubCategoryById(int.Parse(this.ViewState["ExpenseSubCategoryID"].ToString()));
this.ExpenseCategoryCtl.Text = MasterDataBLL.GetExpenseCategoryById(rowExpenseSubCategory.ExpenseCategoryID).ExpenseCategoryName;
this.ExpenseSubCategoryCtl.Text = rowExpenseSubCategory.ExpenseSubCategoryName;
this.CurrencyCtl.Text = new CurrencyTableAdapter().GetDataByID(int.Parse(this.ViewState["CurrencyID"].ToString()))[0].CurrencyShortName;
}
this.ExpenseSubCategoryID.Value = this.ViewState["ExpenseSubCategoryID"].ToString();
this.BrandID.Value = this.ViewState["BrandID"].ToString();
this.ViewState["ExchangeRate"] = new MasterDataBLL().GetExchangeRateByPeriod(int.Parse(ViewState["CurrencyID"].ToString()), DateTime.Parse(ViewState["FPeriod"].ToString()));
if (decimal.Parse(this.ViewState["ExchangeRate"].ToString()) == 0) {
this.Session["ErrorInfor"] = "未找到汇率，请联系管理员";
Response.Redirect("~/ErrorPage/SystemErrorPage.aspx");
}
this.ExchangeRateCtl.Text = this.ViewState["ExchangeRate"].ToString();
//判断费用期间是否正确
MasterDataBLL bll = new MasterDataBLL();
if (!new MasterDataBLL().IsValidPeriodSale(DateTime.Parse(this.ViewState["FPeriod"].ToString()))) {
this.SubmitBtn.Visible = false;
PageUtility.ShowModelDlg(this, "不允许申请本月项目，请删除草稿并联系财务部!");
return;
}
//预算信息
this.ViewState["ExpenseCategoryID"] = new MasterDataBLL().GetExpenseSubCategoryById(int.Parse(this.ViewState["ExpenseSubCategoryID"].ToString())).ExpenseCategoryID.ToString();
decimal[] calculateAssistant = new decimal[6];
calculateAssistant = new BudgetBLL().GetSalesBudgetByParameter(rowUserPosition.PositionId, DateTime.Parse(ViewState["FPeriod"].ToString()), int.Parse(this.ViewState["ExpenseCategoryID"].ToString()), int.Parse(ViewState["CustomerChannelID"].ToString()), int.Parse(this.ViewState["BrandID"].ToString()));
this.TotalBudgetCtl.Text = calculateAssistant[0].ToString("N");
this.ApprovedAmountCtl.Text = calculateAssistant[1].ToString("N");
this.ApprovingAmountCtl.Text = calculateAssistant[2].ToString("N");
this.CompletedAmountCtl.Text = calculateAssistant[3].ToString("N");
this.ReimbursedAmountCtl.Text = calculateAssistant[4].ToString("N");
this.RemainBudgetCtl.Text = calculateAssistant[5].ToString("N");
}
//查看预算权限
int opViewId = BusinessUtility.GetBusinessOperateId(SystemEnums.BusinessUseCase.ViewBudget, SystemEnums.OperateEnum.Manage);
AuthorizationDS.PositionRow position = (AuthorizationDS.PositionRow)this.Session["Position"];
bool HasManageRight = new PositionRightBLL().CheckPositionRight(position.PositionId, opViewId);
this.divBudgetInfo.Visible = HasManageRight;
this.divBudgetInfoTitle.Visible = HasManageRight;
}
protected void Page_Load(object sender, EventArgs e)
{
base.Page_Load(sender, e);
if (!this.IsPostBack) {
PageUtility.SetContentTitle(this.Page, "��������");
this.Page.Title = "��������";
// �û���Ϣ��ְλ��Ϣ
AuthorizationDS.StuffUserRow stuffUser = (AuthorizationDS.StuffUserRow)Session["StuffUser"];
AuthorizationDS.PositionRow rowUserPosition = (AuthorizationDS.PositionRow)Session["Position"];
this.ViewState["StuffUserID"] = stuffUser.StuffUserId;
this.ViewState["PositionID"] = rowUserPosition.PositionId;
this.ViewState["FlowTemplate"] = new AuthorizationBLL().GetFlowTemplate((int)SystemEnums.BusinessUseCase.FormApply, stuffUser.StuffUserId);
this.StuffNameCtl.Text = stuffUser.StuffName;
this.PositionNameCtl.Text = rowUserPosition.PositionName;
this.DepartmentNameCtl.Text = new OUTreeBLL().GetOrganizationUnitById(rowUserPosition.OrganizationUnitId).OrganizationUnitName;
this.ViewState["DepartmentID"] = rowUserPosition.OrganizationUnitId;
this.AttendDateCtl.Text = stuffUser.AttendDate.ToShortDateString();
if (this.Request["RejectObjectID"] != null) {
this.ViewState["RejectedObjectID"] = int.Parse(this.Request["RejectObjectID"].ToString());
}
//����Dzݸ���и�ֵ
if (Request["ObjectId"] != null) {
this.ViewState["ObjectId"] = int.Parse(Request["ObjectId"]);
if (this.Request["RejectObjectID"] == null) {
this.DeleteBtn.Visible = true;
} else {
this.DeleteBtn.Visible = false;
}
OpenForm(int.Parse(this.ViewState["ObjectId"].ToString()));
} else {
this.DeleteBtn.Visible = false;
if (Request["CustomerID"] != null) {
this.ViewState["CustomerID"] = Request["CustomerID"];
} else {
this.Session["ErrorInfor"] = "δ�ҵ��ͻ�������ϵ����Ա";
Response.Redirect("~/ErrorPage/SystemErrorPage.aspx");
}
if (Request["BeginPeriod"] != null && Request["EndPeriod"] != null) {
this.ViewState["BeginPeriod"] = Request["BeginPeriod"];
this.ViewState["EndPeriod"] = Request["EndPeriod"];
} else {
this.Session["ErrorInfor"] = "û�з����ڼ䣬����ϵ����Ա";
Response.Redirect("~/ErrorPage/SystemErrorPage.aspx");
}
if (Request["ExpenseSubCategoryID"] != null) {
this.ViewState["ExpenseSubCategoryID"] = Request["ExpenseSubCategoryID"];
} else {
this.Session["ErrorInfor"] = "δ�ҵ�����С�࣬����ϵ����Ա";
Response.Redirect("~/ErrorPage/SystemErrorPage.aspx");
}
this.BeginPeriodCtl.Text = DateTime.Parse(this.ViewState["BeginPeriod"].ToString()).ToString("yyyy-MM");
this.EndPeriodCtl.Text = DateTime.Parse(this.ViewState["EndPeriod"].ToString()).ToString("yyyy-MM");
this.ExpenseSubCategoryCtl.Text = new MasterDataBLL().GetExpenseSubCateNameById(int.Parse(this.ViewState["ExpenseSubCategoryID"].ToString()));
ERS.CustomerRow customer = new MasterDataBLL().GetCustomerById(int.Parse(this.ViewState["CustomerID"].ToString()));
this.CustomerNameCtl.Text = customer.CustomerName;
//this.CustomerTypeCtl.Text = new MasterDataBLL().GetCustomerTypeById(customer.CustomerTypeID).CustomerTypeName;
this.odsShop.SelectParameters["CustomerID"].DefaultValue = customer.CustomerID.ToString();
}
//�жϷ����ڼ��Ƿ���ȷ
MasterDataBLL bll = new MasterDataBLL();
if (!bll.IsValidApplyYear(DateTime.Parse(this.ViewState["BeginPeriod"].ToString()).AddMonths(-3).Year)) {
this.SubmitBtn.Visible = false;
PageUtility.ShowModelDlg(this, "���������뱾������Ŀ������ϵ����!");
return;
}
//Ԥ����Ϣ
decimal[] calculateAssistant = new decimal[14];
calculateAssistant = new BudgetBLL().GetSalesBudgetByParameter(int.Parse(this.ViewState["CustomerID"].ToString()), DateTime.Parse(this.ViewState["BeginPeriod"].ToString()), int.Parse(this.ViewState["ExpenseSubCategoryID"].ToString()));
this.CustomerBudgetCtl.Text = calculateAssistant[0].ToString("N");
this.CustomerBudgetRemainCtl.Text = calculateAssistant[5].ToString("N");
this.OUBudgetCtl.Text = calculateAssistant[7].ToString("N");
this.OUApprovedAmountCtl.Text = calculateAssistant[8].ToString("N");
this.OUApprovingAmountCtl.Text = calculateAssistant[9].ToString("N");
this.OUCompletedAmountCtl.Text = calculateAssistant[10].ToString("N");
this.OUReimbursedAmountCtl.Text = calculateAssistant[11].ToString("N");
this.OUBudgetRemainCtl.Text = calculateAssistant[12].ToString("N");
this.OUBudgetRateCtl.Text = ((decimal)(calculateAssistant[13] * 100)).ToString("N") + "%";
if (Session["ProxyStuffUserId"] != null) {
this.SubmitBtn.Visible = false;
}
}
// ����ϸ��
FormApplyDetailViewTableAdapter taDetail = new FormApplyDetailViewTableAdapter();
int customerID = int.Parse(this.ViewState["CustomerID"].ToString());
DateTime period = DateTime.Parse(this.ViewState["BeginPeriod"].ToString());
taDetail.FillDataFromRebate(this.InnerDS.FormApplyDetailView, customerID, period.Year, period.Month);
//����Ԥ����Ϣ
this.OUBudgetCtl.Text = "";
this.OUApprovedAmountCtl.Text = "";
this.OUApprovingAmountCtl.Text = "";
this.OUCompletedAmountCtl.Text = "";
this.OUReimbursedAmountCtl.Text = "";
this.OUBudgetRemainCtl.Text = "";
this.OUBudgetRateCtl.Text = "";
}
protected void SaveFormApply(SystemEnums.FormStatus StatusID)
{
decimal? CustomerBudget = null;
decimal? CustomerBudgetRemain = null;
decimal? OUBudget = null;
decimal? OUAppovedAmount = null;
decimal? OUApprovingAmount = null;
decimal? OUCompletedAmount = null;
decimal? OUReimbursedAmount = null;
decimal? OUBudgetRemain = null;
decimal? OUBudgetRate = null;
if (StatusID == SystemEnums.FormStatus.Awaiting) {//�ύʱ��飬����ݸ岻���
decimal[] calculateAssistant = new decimal[14];
calculateAssistant = new BudgetBLL().GetSalesBudgetByParameter(int.Parse(this.ViewState["CustomerID"].ToString()), DateTime.Parse(this.ViewState["BeginPeriod"].ToString()), int.Parse(this.ViewState["ExpenseSubCategoryID"].ToString()));
if (calculateAssistant[12] < decimal.Parse(this.ViewState["ManualApplyFeeTotal"].ToString())) {
PageUtility.ShowModelDlg(this.Page, "���������������Ԥ�㣬�����ύ");
return;
} else {
CustomerBudget = calculateAssistant[0];
CustomerBudgetRemain = calculateAssistant[5];
OUBudget = calculateAssistant[7];
OUAppovedAmount = calculateAssistant[8];
OUApprovingAmount = calculateAssistant[9];
OUCompletedAmount = calculateAssistant[10];
OUReimbursedAmount = calculateAssistant[11];
OUBudgetRemain = calculateAssistant[12];
OUBudgetRate = calculateAssistant[13];
}
}
this.SalesApplyBLL.FormDataSet = this.InnerDS;
int? RejectedFormID = null;
if (this.ViewState["RejectedObjectID"] != null) {
RejectedFormID = (int)this.ViewState["RejectedObjectID"];
}
int UserID = (int)this.ViewState["StuffUserID"];
int? ProxyStuffUserId = null;
if (Session["ProxyStuffUserId"] != null) {
ProxyStuffUserId = int.Parse(Session["ProxyStuffUserId"].ToString());
}
int OrganizationUnitID = (int)this.ViewState["DepartmentID"];
int PositionID = (int)this.ViewState["PositionID"];
DateTime BeginPeriod = DateTime.Parse(this.ViewState["BeginPeriod"].ToString());
DateTime EndPeriod = DateTime.Parse(this.ViewState["EndPeriod"].ToString());
int CustomerID = int.Parse(this.ViewState["CustomerID"].ToString());
int ShopID = int.Parse(this.ShopDDL.SelectedValue);
int PaymentTypeID = int.Parse(this.PaymentTypeDDL.SelectedValue);
int ExpenseSubCategoryID = int.Parse(this.ViewState["ExpenseSubCategoryID"].ToString());
string ContractNo = this.ContractNoCtl.Text;
string AttachedFileName = this.UCFileUpload.AttachmentFileName;
string RealAttachedFileName = this.UCFileUpload.RealAttachmentFileName;
string Remark = this.RemarkCtl.Text;
string FormApplyName = this.txtFormApplyName.Text;
if (this.SalesApplyBLL.GetRebateApplyCountByParameter(CustomerID, BeginPeriod.Year, BeginPeriod.Month, ExpenseSubCategoryID) > 0) {
PageUtility.ShowModelDlg(this, "ϵͳ���Ѿ����ڸÿͻ��ķ������룬��������ÿ��ֻ������һ�Σ�");
return;
}
try {
if (this.ViewState["ObjectId"] == null || RejectedFormID != null) {
this.SalesApplyBLL.AddFormApplyRebate(RejectedFormID, UserID, ProxyStuffUserId, null, OrganizationUnitID, PositionID, SystemEnums.FormType.SalesApply, StatusID, BeginPeriod,
EndPeriod, CustomerID, ShopID, PaymentTypeID, ExpenseSubCategoryID, ContractNo, CustomerBudget, CustomerBudgetRemain, OUBudget, OUAppovedAmount, OUApprovingAmount, OUCompletedAmount,
OUReimbursedAmount, OUBudgetRemain, OUBudgetRate, AttachedFileName, RealAttachedFileName, Remark, this.ViewState["FlowTemplate"].ToString(), FormApplyName);
} else {
int FormID = (int)this.ViewState["ObjectId"];
this.SalesApplyBLL.UpdateFormApplyRebate(FormID, StatusID, SystemEnums.FormType.SalesApply, ShopID, PaymentTypeID, ContractNo, CustomerBudget, CustomerBudgetRemain,
OUBudget, OUAppovedAmount, OUApprovingAmount,OUCompletedAmount, OUReimbursedAmount, OUBudgetRemain, OUBudgetRate, AttachedFileName, RealAttachedFileName, Remark, this.ViewState["FlowTemplate"].ToString(), FormApplyName);
}
this.Page.Response.Redirect("~/SalesForm/SalesApplySelect.aspx");
} catch (Exception ex) {
PageUtility.DealWithException(this.Page, ex);
}
}
protected void SaveFormPV(SystemEnums.FormStatus StatusID)
{
decimal TotalBudget = 0;
decimal ApprovedAmount = 0;
decimal ApprovingAmount = 0;
decimal ReimbursedAmount = 0;
decimal NonReimbursedAmount = 0;
decimal RemainBudget = 0;
if (StatusID == SystemEnums.FormStatus.Awaiting) {//提交时检查，保存草稿不检查
decimal[] calculateAssistant = new decimal[6];
calculateAssistant = new BudgetBLL().GetManagingBudgetByParameter((int)this.ViewState["PositionID"], DateTime.Parse(ViewState["Period"].ToString()), int.Parse(this.ViewState["PurchaseBudgetTypeID"].ToString()));
if (calculateAssistant[5] < decimal.Parse(this.ViewState["TotalApplyAmount"].ToString())) {
PageUtility.ShowModelDlg(this.Page, "本次申请金额超过可用预算，不能提交","the amount of this application is more than remain budget");
return;
} else {
TotalBudget = calculateAssistant[0];
ApprovedAmount = calculateAssistant[1];
ApprovingAmount = calculateAssistant[2];
ReimbursedAmount = calculateAssistant[3];
NonReimbursedAmount = calculateAssistant[4];
RemainBudget = calculateAssistant[5];
}
}
this.FormPurchaseBLL.PurchaseDataSet = this.InnerDS;
int? RejectedFormID = null;
if (this.ViewState["RejectedObjectID"] != null) {
RejectedFormID = (int)this.ViewState["RejectedObjectID"];
}
int UserID = (int)this.ViewState["StuffUserID"];
int? ProxyStuffUserId = null;
if (Session["ProxyStuffUserId"] != null) {
ProxyStuffUserId = int.Parse(Session["ProxyStuffUserId"].ToString());
}
int OrganizationUnitID = (int)this.ViewState["DepartmentID"];
int PositionID = (int)this.ViewState["PositionID"];
DateTime Period = DateTime.Parse(this.ViewState["Period"].ToString());
int VendorID = int.Parse(this.ViewState["VendorID"].ToString());
int ItemCategoryID = int.Parse(this.ViewState["ItemCategoryID"].ToString());
int CurrencyID = int.Parse(this.ViewState["CurrencyID"].ToString());
decimal ExchangeRate = decimal.Parse(this.ViewState["ExchangeRate"].ToString());
int PurchaseBudgetTypeID = int.Parse(this.ViewState["PurchaseBudgetTypeID"].ToString());
int PurchaseTypeID = int.Parse(this.PurchaseTypeDDL.SelectedValue);
int MethodPaymentID = int.Parse(this.MethodPaymentDDL.SelectedValue);
DateTime? ExpectPaymentDate = null;
if (UCExpectPaymentDateCtl.SelectedDate != string.Empty) {
ExpectPaymentDate = DateTime.Parse(UCExpectPaymentDateCtl.SelectedDate);
}
bool IsUrgent = false;
if (this.IsUrgentDDL.SelectedValue == "1") {
IsUrgent = true;
}
bool IsPublic = false;
if (this.IsPublicDDL.SelectedValue == "1") {
IsPublic = true;
}
int InvoiceStatusID = int.Parse(this.InvoiceStatusDDL.SelectedValue);
string Remark = this.RemarkCtl.Text;
string AttachedFileName = this.UCFileUpload.AttachmentFileName;
string RealAttachedFileName = this.UCFileUpload.RealAttachmentFileName;
int PVType = (int)SystemEnums.PVType.None;
decimal AMTTax;
if (this.AMTTaxCtl.Text == string.Empty) {
AMTTax = 0;
} else {
AMTTax = decimal.Parse(this.AMTTaxCtl.Text);
}
int? VATRateID = null;
if (this.VATRateDDL.SelectedValue != "0") {
VATRateID = int.Parse(this.VATRateDDL.SelectedValue);
}
string PaymentTerms = this.PaymentTermCtl.Text;
bool IsPTChanged = false;
if (StatusID == SystemEnums.FormStatus.Awaiting) {//提交时判断即可
string defaultPT = new MasterDataBLL().GetPaymentTermById(new VendorTableAdapter().GetDataByID(VendorID)[0].PaymentTermID)[0].PaymentTermName;
if (defaultPT != PaymentTerms) {
IsPTChanged = true;
} else {
IsPTChanged = false;
}
}
try {
if (this.ViewState["ObjectId"] == null || RejectedFormID != null) {
this.FormPurchaseBLL.AddPVSpecialApply(RejectedFormID, UserID, ProxyStuffUserId, null, OrganizationUnitID, PositionID, SystemEnums.FormType.PVApply, StatusID, Period,
VendorID, ItemCategoryID, CurrencyID, ExchangeRate, PurchaseBudgetTypeID, PurchaseTypeID, Remark, AttachedFileName, RealAttachedFileName, MethodPaymentID, ExpectPaymentDate,
TotalBudget, ApprovedAmount, ApprovingAmount, ReimbursedAmount, NonReimbursedAmount, RemainBudget, IsUrgent, IsPublic, InvoiceStatusID, PVType, VATRateID, AMTTax,PaymentTerms,IsPTChanged);
} else {
int FormID = (int)this.ViewState["ObjectId"];
this.FormPurchaseBLL.UpdatePVSpecialApply(FormID, StatusID, ExchangeRate, PurchaseTypeID, Remark, AttachedFileName, RealAttachedFileName, MethodPaymentID,
ExpectPaymentDate, TotalBudget, ApprovedAmount, ApprovingAmount, ReimbursedAmount, NonReimbursedAmount, RemainBudget, IsUrgent, IsPublic, InvoiceStatusID, VATRateID, AMTTax, PaymentTerms, IsPTChanged);
}
this.Page.Response.Redirect("~/Home.aspx");
} catch (Exception ex) {
PageUtility.DealWithException(this.Page, ex);
}
}
protected void Page_Load(object sender, EventArgs e)
{
base.Page_Load(sender, e);
if (!this.IsPostBack) {
String title = this.GetLocalResourceObject("titleLabel.Text").ToString();
PageUtility.SetContentTitle(this.Page, title);
// 用户信息，职位信息
AuthorizationDS.StuffUserRow stuffUser = (AuthorizationDS.StuffUserRow)Session["StuffUser"];
AuthorizationDS.PositionRow rowUserPosition = (AuthorizationDS.PositionRow)Session["Position"];
if (new StuffUserBLL().GetCostCenterIDByPositionID(rowUserPosition.PositionId) == 0) {
this.Session["ErrorInfor"] = "未找到成本中心，请联系管理员";
Response.Redirect("~/ErrorPage/SystemErrorPage.aspx");
}
this.ViewState["StuffUserID"] = stuffUser.StuffUserId;
this.ViewState["PositionID"] = rowUserPosition.PositionId;
this.StuffNameCtl.Text = CommonUtility.GetStaffFullName(stuffUser);
this.PositionNameCtl.Text = rowUserPosition.PositionName;
this.DepartmentNameCtl.Text = new OUTreeBLL().GetOrganizationUnitById(rowUserPosition.OrganizationUnitId).OrganizationUnitName;
this.ViewState["DepartmentID"] = rowUserPosition.OrganizationUnitId;
this.StuffNoCtl.Text = stuffUser.IsStuffNoNull() ? "" : stuffUser.StuffNo;
this.AttendDateCtl.Text = stuffUser.AttendDate.ToShortDateString();
if (this.Request["RejectObjectID"] != null) {
this.ViewState["RejectedObjectID"] = int.Parse(this.Request["RejectObjectID"].ToString());
}
VATRateDDL.DataBind();
//如果是草稿进行赋值
if (Request["ObjectId"] != null) {
this.ViewState["ObjectId"] = int.Parse(Request["ObjectId"]);
if (this.Request["RejectObjectID"] == null) {
this.DeleteBtn.Visible = true;
} else {
this.DeleteBtn.Visible = false;
}
OpenForm(int.Parse(this.ViewState["ObjectId"].ToString()));
} else {
this.DeleteBtn.Visible = false;
if (Request["PeriodPurchaseID"] != null) {
DateTime Period = new MasterDataBLL().GetPeriodPurchaseById(int.Parse(Request["PeriodPurchaseID"].ToString())).PeriodPurchase;
this.ViewState["Period"] = Period.ToShortDateString();
} else {
this.Session["ErrorInfor"] = "没有费用期间，请联系管理员";
Response.Redirect("~/ErrorPage/SystemErrorPage.aspx");
}
if (Request["VendorID"] != null) {
this.ViewState["VendorID"] = Request["VendorID"];
} else {
this.Session["ErrorInfor"] = "未找到Vendor，请联系管理员";
Response.Redirect("~/ErrorPage/SystemErrorPage.aspx");
}
if (Request["ItemCategoryID"] != null) {
this.ViewState["ItemCategoryID"] = Request["ItemCategoryID"];
} else {
this.Session["ErrorInfor"] = "未找到Item Category，请联系管理员";
Response.Redirect("~/ErrorPage/SystemErrorPage.aspx");
}
if (Request["PurchaseBudgetTypeID"] != null) {
this.ViewState["PurchaseBudgetTypeID"] = Request["PurchaseBudgetTypeID"];
} else {
this.Session["ErrorInfor"] = "未找到预算类型，请联系管理员";
Response.Redirect("~/ErrorPage/SystemErrorPage.aspx");
}
if (Request["CurrencyID"] != null) {
this.ViewState["CurrencyID"] = Request["CurrencyID"];
} else {
this.Session["ErrorInfor"] = "未找到币种，请联系管理员";
Response.Redirect("~/ErrorPage/SystemErrorPage.aspx");
}
this.PeriodCtl.Text = DateTime.Parse(this.ViewState["Period"].ToString()).ToString("yyyy-MM");
this.PaymentTermCtl.Text = new MasterDataBLL().GetPaymentTermById(new VendorTableAdapter().GetDataByID(int.Parse(this.ViewState["VendorID"].ToString()))[0].PaymentTermID)[0].PaymentTermName;
}
MasterData.VendorRow vendor = new VendorTableAdapter().GetDataByID(int.Parse(this.ViewState["VendorID"].ToString()))[0];
this.VendorCodeCtl.Text = vendor.VendorCode;
this.VendorNameCtl.Text = vendor.VendorName;
this.VendorAddressCtl.Text = vendor.VendorAddress;
this.ItemCategoryCtl.Text = new ItemCategoryTableAdapter().GetDataByID(int.Parse(this.ViewState["ItemCategoryID"].ToString()))[0].ItemCategoryName;
this.CurrencyCtl.Text = new CurrencyTableAdapter().GetDataByID(int.Parse(this.ViewState["CurrencyID"].ToString()))[0].CurrencyShortName;
this.PurchaseBudgetTypeCtl.Text = new PurchaseBudgetTypeTableAdapter().GetDataByID(int.Parse(this.ViewState["PurchaseBudgetTypeID"].ToString()))[0].PurchaseBudgetTypeName;
this.ViewState["ExchangeRate"] = new MasterDataBLL().GetExchangeRateByPeriod(int.Parse(ViewState["CurrencyID"].ToString()), DateTime.Parse(ViewState["Period"].ToString()));
if (decimal.Parse( this.ViewState["ExchangeRate"].ToString()) == 0) {
this.Session["ErrorInfor"] = "未找到汇率，请联系管理员";
Response.Redirect("~/ErrorPage/SystemErrorPage.aspx");
}
this.ExchangeRateCtl.Text = this.ViewState["ExchangeRate"].ToString();
//判断费用期间是否正确
MasterDataBLL bll = new MasterDataBLL();
if (!new MasterDataBLL().IsValidPeriodPurchase(DateTime.Parse(this.ViewState["Period"].ToString()))) {
this.SubmitBtn.Visible = false;
PageUtility.ShowModelDlg(this, "不允许申请本月的PV，请删除草稿并联系财务部!");
return;
}
//预算信息
decimal[] calculateAssistant = new decimal[6];
calculateAssistant = new BudgetBLL().GetManagingBudgetByParameter(rowUserPosition.PositionId, DateTime.Parse(ViewState["Period"].ToString()), int.Parse(this.ViewState["PurchaseBudgetTypeID"].ToString()));
this.TotalBudgetCtl.Text = calculateAssistant[0].ToString("N");
this.ApprovedAmountCtl.Text = calculateAssistant[1].ToString("N");
this.ApprovingAmountCtl.Text = calculateAssistant[2].ToString("N");
this.ReimbursedAmountCtl.Text = calculateAssistant[3].ToString("N");
this.NonReimbursedAmountCtl.Text = calculateAssistant[4].ToString("N");
this.RemainBudgetCtl.Text = calculateAssistant[5].ToString("N");
}
VATRateDDL_SelectedIndexChanged(null, null);
//隐藏预算信息,若需要则隐藏
}
protected void SaveFormApply(SystemEnums.FormStatus StatusID)
{
decimal? CustomerBudget = null;
decimal? CustomerBudgetRemain = null;
decimal? OUBudget = null;
decimal? OUAppovedAmount = null;
decimal? OUApprovingAmount = null;
decimal? OUCompletedAmount = null;
decimal? OUReimbursedAmount = null;
decimal? OUBudgetRemain = null;
decimal? OUBudgetRate = null;
if (StatusID == SystemEnums.FormStatus.Awaiting) {//�ύʱ��飬����ݸ岻���
//���ȼ���ͬ�ڽ���Ƿ���
object[] amountLimit = this.SalesApplyBLL.GetCustomerAmountLimitByParameter(int.Parse(this.ViewState["CustomerID"].ToString()), DateTime.Parse(this.ViewState["BeginPeriod"].ToString()).Year, decimal.Parse(this.ViewState["InContractAmount"].ToString()));
if (amountLimit != null) {
if (!(bool)amountLimit[0]) {
PageUtility.ShowModelDlg(this.Page, string.Format("����ǰѡ��Ŀͻ��ĺ�ͬ�ڽ������ƣ�ʣ����{0}��", amountLimit[3].ToString()));
return;
}
}
decimal[] calculateAssistant = new decimal[14];
calculateAssistant = new BudgetBLL().GetSalesBudgetByParameter(int.Parse(this.ViewState["CustomerID"].ToString()), DateTime.Parse(this.ViewState["BeginPeriod"].ToString()), int.Parse(this.ViewState["ExpenseSubCategoryID"].ToString()));
if (calculateAssistant[12] < decimal.Parse(this.ViewState["ManualApplyFeeTotal"].ToString())) {
PageUtility.ShowModelDlg(this.Page, "���������������Ԥ�㣬�����ύ");
return;
} else {
CustomerBudget = calculateAssistant[0];
CustomerBudgetRemain = calculateAssistant[5];
OUBudget = calculateAssistant[7];
OUAppovedAmount = calculateAssistant[8];
OUApprovingAmount = calculateAssistant[9];
OUCompletedAmount = calculateAssistant[10];
OUReimbursedAmount = calculateAssistant[11];
OUBudgetRemain = calculateAssistant[12];
OUBudgetRate = calculateAssistant[13];
}
}
this.SalesApplyBLL.FormDataSet = this.InnerDS;
int? RejectedFormID = null;
if (this.ViewState["RejectedObjectID"] != null) {
RejectedFormID = (int)this.ViewState["RejectedObjectID"];
}
int UserID = (int)this.ViewState["StuffUserID"];
int? ProxyStuffUserId = null;
if (Session["ProxyStuffUserId"] != null) {
ProxyStuffUserId = int.Parse(Session["ProxyStuffUserId"].ToString());
}
int OrganizationUnitID = (int)this.ViewState["DepartmentID"];
int PositionID = (int)this.ViewState["PositionID"];
DateTime BeginPeriod = DateTime.Parse(this.ViewState["BeginPeriod"].ToString());
DateTime EndPeriod = DateTime.Parse(this.ViewState["EndPeriod"].ToString());
int CustomerID = int.Parse(this.ViewState["CustomerID"].ToString());
int ShopID = int.Parse(this.ShopDDL.SelectedValue);
int PaymentTypeID = int.Parse(this.PaymentTypeDDL.SelectedValue);
int ExpenseSubCategoryID = int.Parse(this.ViewState["ExpenseSubCategoryID"].ToString());
string ContractNo = this.ContractNoCtl.Text;
DateTime PromotionBeginDate = DateTime.Parse(this.UCPromotionBegin.SelectedDate);
DateTime PromotionEndDate = DateTime.Parse(this.UCPromotionEnd.SelectedDate);
int PromotionScopeID = int.Parse(this.PromotionScopeDDL.SelectedValue);
int PromotionTypeID = int.Parse(this.PromotionTypeDDL.SelectedValue);
string PromotionDesc = this.PromotionDescCtl.Text;
int ShelfTypeID = int.Parse(this.ShelfTypeDDL.SelectedValue);
int? FirstVolume = null;
if (this.FirstVolumeCtl.Text != string.Empty) {
FirstVolume = int.Parse(this.FirstVolumeCtl.Text);
}
int? SecondVolume = null;
if (this.SecondVolumeCtl.Text != string.Empty) {
SecondVolume = int.Parse(this.SecondVolumeCtl.Text);
}
int? ThirdVolume = null;
if (this.ThirdVolumeCtl.Text != string.Empty) {
ThirdVolume = int.Parse(this.ThirdVolumeCtl.Text);
}
int? EstimatedSaleVolume = null;
if (this.txtEstimatedSaleVolume.Text != string.Empty) {
EstimatedSaleVolume = int.Parse(this.txtEstimatedSaleVolume.Text);
}
string AttachedFileName = this.UCFileUpload.AttachmentFileName;
string RealAttachedFileName = this.UCFileUpload.RealAttachmentFileName;
string Remark = this.RemarkCtl.Text;
string FormApplyName = this.txtFormApplyName.Text;
//�ύʱ�жϿ��·�����̯�����Ƿ�����
if (StatusID == SystemEnums.FormStatus.Awaiting && EndPeriod.Month != BeginPeriod.Month) {
if (InnerDS.FormApplySplitRate == null || InnerDS.FormApplySplitRate.Count == 0) {
PageUtility.ShowModelDlg(this, "������̯�����쳣����������д��");
return;
} else {
int sum = 0;
foreach (FormDS.FormApplySplitRateRow item in InnerDS.FormApplySplitRate) {
sum += item.Rate;
}
if (sum != 100) {
PageUtility.ShowModelDlg(this, "������̯�����ܺ��쳣����������д��");
return;
}
}
}
//Ԥ����Ϣ
try {
if (this.ViewState["ObjectId"] == null || RejectedFormID != null) {
this.SalesApplyBLL.AddFormApplyGeneral(RejectedFormID, UserID, ProxyStuffUserId, null, OrganizationUnitID, PositionID, SystemEnums.FormType.SalesApply, StatusID, BeginPeriod,
EndPeriod, CustomerID, ShopID, PaymentTypeID, ExpenseSubCategoryID, ContractNo, PromotionBeginDate, PromotionEndDate,
PromotionScopeID, PromotionTypeID, PromotionDesc, ShelfTypeID, FirstVolume, SecondVolume, ThirdVolume, EstimatedSaleVolume, CustomerBudget, CustomerBudgetRemain, OUBudget, OUAppovedAmount, OUApprovingAmount, OUCompletedAmount,
OUReimbursedAmount, OUBudgetRemain, OUBudgetRate, AttachedFileName, RealAttachedFileName, Remark, int.Parse(ViewState["ReimburseRequirements"].ToString()), this.ViewState["FlowTemplate"].ToString(), FormApplyName);
} else {
int FormID = (int)this.ViewState["ObjectId"];
this.SalesApplyBLL.UpdateFormApplyGeneral(FormID, StatusID, SystemEnums.FormType.SalesApply, ShopID, PaymentTypeID, ContractNo, PromotionBeginDate,
PromotionEndDate, PromotionScopeID, PromotionTypeID, PromotionDesc, ShelfTypeID, FirstVolume, SecondVolume, ThirdVolume, EstimatedSaleVolume, CustomerBudget, CustomerBudgetRemain,
OUBudget, OUAppovedAmount, OUApprovingAmount, OUCompletedAmount, OUReimbursedAmount, OUBudgetRemain, OUBudgetRate, AttachedFileName, RealAttachedFileName, Remark, int.Parse(ViewState["ReimburseRequirements"].ToString()), this.ViewState["FlowTemplate"].ToString(), FormApplyName);
}
this.Page.Response.Redirect("~/SalesForm/SalesApplySelect.aspx");
} catch (Exception ex) {
PageUtility.DealWithException(this.Page, ex);
}
}
protected void SaveFormTravel(SystemEnums.FormStatus StatusID)
{
if (this.PeriodDDL.SelectedValue == "0") {
PageUtility.ShowModelDlg(this.Page, "请选择费用期间!");
return;
}
decimal TotalBudget = 0;
decimal ApprovedAmount = 0;
decimal ApprovingAmount = 0;
decimal RemainAmount = 0;
DateTime Period = DateTime.Parse(this.PeriodDDL.SelectedItem.Text.ToString() + "-1");
if (StatusID == SystemEnums.FormStatus.Awaiting) {
decimal[] budgetInfo = new BudgetBLL().GetManagingBudgetByParameter((int)this.ViewState["PositionID"], Period, (int)SystemEnums.PurchaseBudgetType.Non_Capital);
TotalBudget = budgetInfo[0];
ApprovedAmount = budgetInfo[1];
ApprovingAmount = budgetInfo[2];
RemainAmount = budgetInfo[5];
if (decimal.Parse(this.ViewState["TotalApplyAmount"].ToString()) > budgetInfo[5]) {
PageUtility.ShowModelDlg(this.Page, "本次申请金额超过可用预算，不能提交", "the amount of this application is more than remain budget");
return;
}
}
this.FormTEBLL.FormDataSet = this.InnerDS;
int? RejectedFormID = null;
if (this.ViewState["RejectedObjectID"] != null) {
RejectedFormID = (int)this.ViewState["RejectedObjectID"];
}
int UserID = (int)this.ViewState["StuffUserID"];
int? ProxyStuffUserId = null;
if (Session["ProxyStuffUserId"] != null) {
ProxyStuffUserId = int.Parse(Session["ProxyStuffUserId"].ToString());
}
int OrganizationUnitID = (int)this.ViewState["DepartmentID"];
int PositionID = (int)this.ViewState["PositionID"];
string Remark = this.RemarkCtl.Text;
string AttachedFileName = this.UCFileUpload.AttachmentFileName;
string RealAttachedFileName = this.UCFileUpload.RealAttachmentFileName;
try {
if (this.ViewState["ObjectId"] == null || RejectedFormID != null) {
this.FormTEBLL.AddFormTravelReimburse(RejectedFormID, UserID, ProxyStuffUserId, null, OrganizationUnitID, PositionID,
SystemEnums.FormType.TravelReimburseApply, StatusID, Period, Remark, TotalBudget, ApprovedAmount, ApprovingAmount, RemainAmount, AttachedFileName, RealAttachedFileName);
} else {
int FormID = (int)this.ViewState["ObjectId"];
this.FormTEBLL.UpdateFormTravelReimburse(FormID, StatusID, SystemEnums.FormType.TravelReimburseApply, Period, Remark, TotalBudget, ApprovedAmount, ApprovingAmount, RemainAmount, AttachedFileName, RealAttachedFileName);
}
this.Page.Response.Redirect("~/Home.aspx");
} catch (Exception ex) {
PageUtility.DealWithException(this.Page, ex);
}
}
protected void Page_Load(object sender, EventArgs e)
{
base.Page_Load(sender, e);
if (!this.IsPostBack) {
PageUtility.SetContentTitle(this.Page, "��������");
this.Page.Title = "��������";
// �û���Ϣ��ְλ��Ϣ
AuthorizationDS.StuffUserRow stuffUser = (AuthorizationDS.StuffUserRow)Session["StuffUser"];
AuthorizationDS.PositionRow rowUserPosition = (AuthorizationDS.PositionRow)Session["Position"];
this.ViewState["StuffUserID"] = stuffUser.StuffUserId;
this.ViewState["PositionID"] = rowUserPosition.PositionId;
this.ViewState["FlowTemplate"] = new AuthorizationBLL().GetFlowTemplate((int)SystemEnums.BusinessUseCase.FormApply, stuffUser.StuffUserId);
this.StuffNameCtl.Text = stuffUser.StuffName;
this.PositionNameCtl.Text = rowUserPosition.PositionName;
this.DepartmentNameCtl.Text = new OUTreeBLL().GetOrganizationUnitById(rowUserPosition.OrganizationUnitId).OrganizationUnitName;
this.ViewState["DepartmentID"] = rowUserPosition.OrganizationUnitId;
this.AttendDateCtl.Text = stuffUser.AttendDate.ToShortDateString();
if (this.Request["RejectObjectID"] != null) {
this.ViewState["RejectedObjectID"] = int.Parse(this.Request["RejectObjectID"].ToString());
}
//����Dzݸ���и�ֵ
if (Request["ObjectId"] != null) {
this.ViewState["ObjectId"] = int.Parse(Request["ObjectId"]);
if (this.Request["RejectObjectID"] == null) {
this.DeleteBtn.Visible = true;
} else {
this.DeleteBtn.Visible = false;
}
OpenForm(int.Parse(this.ViewState["ObjectId"].ToString()));
} else {
this.DeleteBtn.Visible = false;
if (Request["CustomerID"] != null) {
this.ViewState["CustomerID"] = Request["CustomerID"];
} else {
this.Session["ErrorInfor"] = "δ�ҵ��ͻ�������ϵ����Ա";
Response.Redirect("~/ErrorPage/SystemErrorPage.aspx");
}
if (Request["BeginPeriod"] != null && Request["EndPeriod"] != null) {
this.ViewState["BeginPeriod"] = Request["BeginPeriod"];
this.ViewState["EndPeriod"] = Request["EndPeriod"];
} else {
this.Session["ErrorInfor"] = "û�з����ڼ䣬����ϵ����Ա";
Response.Redirect("~/ErrorPage/SystemErrorPage.aspx");
}
if (Request["ExpenseSubCategoryID"] != null) {
this.ViewState["ExpenseSubCategoryID"] = Request["ExpenseSubCategoryID"];
} else {
this.Session["ErrorInfor"] = "δ�ҵ�����С�࣬����ϵ����Ա";
Response.Redirect("~/ErrorPage/SystemErrorPage.aspx");
}
if (Request["PromotionPriceType"] != null) {
this.ViewState["PromotionPriceType"] = Request["PromotionPriceType"];
} else {
this.Session["ErrorInfor"] = "δ�ҵ���Ʒ�������ͣ�����ϵ����Ա";
Response.Redirect("~/ErrorPage/SystemErrorPage.aspx");
}
this.BeginPeriodCtl.Text = DateTime.Parse(this.ViewState["BeginPeriod"].ToString()).ToString("yyyy-MM");
this.EndPeriodCtl.Text = DateTime.Parse(this.ViewState["EndPeriod"].ToString()).ToString("yyyy-MM");
this.ExpenseSubCategoryCtl.Text = new MasterDataBLL().GetExpenseSubCateNameById(int.Parse(this.ViewState["ExpenseSubCategoryID"].ToString()));
ERS.CustomerRow customer = new MasterDataBLL().GetCustomerById(int.Parse(this.ViewState["CustomerID"].ToString()));
this.CustomerNameCtl.Text = customer.CustomerName;
//this.CustomerTypeCtl.Text = new MasterDataBLL().GetCustomerTypeById(customer.CustomerTypeID).CustomerTypeName;
this.odsShop.SelectParameters["CustomerID"].DefaultValue = customer.CustomerID.ToString();
CommonUtility.InitSplitRate(InnerDS.FormApplySplitRate, DateTime.Parse(this.ViewState["BeginPeriod"].ToString()), DateTime.Parse(this.ViewState["EndPeriod"].ToString()));
}
//�жϷ����ڼ��Ƿ���ȷ
MasterDataBLL bll = new MasterDataBLL();
if (!bll.IsValidApplyYear(DateTime.Parse(this.ViewState["BeginPeriod"].ToString()).AddMonths(-3).Year)) {
this.SubmitBtn.Visible = false;
PageUtility.ShowModelDlg(this, "���������뱾������Ŀ������ϵ����!");
return;
}
//������������ۺ������ĸ�������д
if (this.ViewState["PromotionPriceType"].ToString() == ((int)SystemEnums.PromotionPriceType.Promotion).ToString()) {
this.IsPromotionReadOnly = false;
this.IsGiveReadOnly = true;
} else {
this.IsPromotionReadOnly = true;
this.IsGiveReadOnly = false;
}
this.ExpenseSubCategoryID.Value = this.ViewState["ExpenseSubCategoryID"].ToString();
if (InnerDS.FormApplySplitRate != null && InnerDS.FormApplySplitRate.Count > 0) {
this.divSplitRate.Visible = true;
this.gvSplitRate.Visible = true;
this.gvSplitRate.DataSource = InnerDS.FormApplySplitRate;
this.gvSplitRate.DataBind();
}
//Ԥ����Ϣ
decimal[] calculateAssistant = new decimal[14];
calculateAssistant = new BudgetBLL().GetSalesBudgetByParameter(int.Parse(this.ViewState["CustomerID"].ToString()), DateTime.Parse(this.ViewState["BeginPeriod"].ToString()), int.Parse(this.ViewState["ExpenseSubCategoryID"].ToString()));
this.CustomerBudgetCtl.Text = calculateAssistant[0].ToString("N");
this.CustomerBudgetRemainCtl.Text = calculateAssistant[5].ToString("N");
this.OUBudgetCtl.Text = calculateAssistant[7].ToString("N");
this.OUApprovedAmountCtl.Text = calculateAssistant[8].ToString("N");
this.OUApprovingAmountCtl.Text = calculateAssistant[9].ToString("N");
this.OUCompletedAmountCtl.Text = calculateAssistant[10].ToString("N");
this.OUReimbursedAmountCtl.Text = calculateAssistant[11].ToString("N");
this.OUBudgetRemainCtl.Text = calculateAssistant[12].ToString("N");
this.OUBudgetRateCtl.Text = ((decimal)(calculateAssistant[13] * 100)).ToString("N") + "%";
InitCustomerTimesLimit();
if (Session["ProxyStuffUserId"] != null) {
this.SubmitBtn.Visible = false;
}
} else {
this.ExpenseItemRemainTimes = (Dictionary<int, object[]>)this.ViewState["ExpenseItemRemainTimes"];
}
//����Ԥ����Ϣ
this.OUBudgetCtl.Text = "";
this.OUApprovedAmountCtl.Text = "";
this.OUApprovingAmountCtl.Text = "";
this.OUCompletedAmountCtl.Text = "";
this.OUReimbursedAmountCtl.Text = "";
this.OUBudgetRemainCtl.Text = "";
this.OUBudgetRateCtl.Text = "";
if (setEditRowIndex) {
this.SKUListView.EditIndex = this.SKUListView.DataKeys.Count - 1;
setEditRowIndex = false;
}
}
