protected void Page_Load(object sender, EventArgs e) { #region 检查必要参数 bool bIsValid = PageCommon.ValidateQueryString(this, "LoanID", QueryStringType.ID); if (bIsValid == false) { this.ClientScript.RegisterClientScriptBlock(this.GetType(), "_Missing", "$('#divContainer').hide();alert('Missing required query string.');window.parent.CloseDialog_AddRule();", true); return; } this.iLoanID = Convert.ToInt32(this.Request.QueryString["LoanID"]); //Get rule num by loan id LPWeb.BLL.LoanRules loanRulesMgr = new LPWeb.BLL.LoanRules(); System.Data.DataSet ds = loanRulesMgr.GetList(" Fileid=" + this.iLoanID.ToString()); int iRuleCount = ds.Tables[0].Rows.Count; this.hdnAddRuleNum.Value = (20 - iRuleCount).ToString(); #endregion #region 初始化Rule列表 this.RuleSqlDataSource.ConnectionString = LPWeb.DAL.DbHelperSQL.connectionString; string sSql = "select * from Template_Rules where Enabled=1 and RuleId not in (select RuleId from LoanRules where Fileid=" + this.iLoanID.ToString() + " and RuleId is not null)" + " AND RuleScope = 0 AND (LoanTarget = 0 OR LoanTarget = 2)"; // //Check prospect loan if (iLoanID != 0) { LPWeb.BLL.Loans loanMgr = new LPWeb.BLL.Loans(); LPWeb.Model.Loans loanModel = loanMgr.GetModel(iLoanID); if (loanModel.Status.Trim().ToLower() == "prospect") { this.hdnProspectLoan.Value = "true"; sSql = "SELECT * FROM Template_Rules WHERE Enabled=1 AND RuleId NOT IN (SELECT RuleId FROM LoanRules WHERE Fileid=" + this.iLoanID.ToString() + " AND RuleId IS NOT NULL)" + " AND RuleScope = 0 AND (LoanTarget = 1 OR LoanTarget = 2)"; } } this.RuleSqlDataSource.SelectCommand = sSql; this.gridRuleList.DataBind(); #endregion }
public void BindData() { LPWeb.BLL.Loans bllLoans = new LPWeb.BLL.Loans(); LPWeb.BLL.LoanTeam bllLoanTeam = new LPWeb.BLL.LoanTeam(); LPWeb.BLL.Users bllUsers = new LPWeb.BLL.Users(); LPWeb.Model.Loans loanInfo = bllLoans.GetModel(LoanID); DataTable LoanInfo_datatable = bllLoans.GetLoanInfo(LoanID); decimal loanAmount = 0; LoanPointFields LoanPointFieldsMgr = new LoanPointFields(); //LPWeb.Model.LoanPointFields PointFieldInfo = LoanPointFieldsMgr.GetPointFieldInfo(LoanID, 21017); LPWeb.Model.LoanPointFields PointFieldInfo = LoanPointFieldsMgr.GetModel(LoanID, 21017); if (PointFieldInfo != null && !string.IsNullOrEmpty(PointFieldInfo.CurrentValue)) { decimal.TryParse(PointFieldInfo.CurrentValue, out loanAmount); } if (loanAmount <= 0 && LoanInfo_datatable != null && LoanInfo_datatable.Rows.Count > 0) { loanAmount = LoanInfo_datatable.Rows[0]["LoanAmount"] == DBNull.Value ? 0 : (decimal)LoanInfo_datatable.Rows[0]["LoanAmount"]; } this.labLoanamount.Text = loanAmount.ToString("n2"); var list = new List <ViewCompDetail>(); var Lo = new ViewCompDetail(); Lo.Type = "Loan Officer"; var LOUserId = bllLoanTeam.GetLoanOfficerID(LoanID); Lo.Name = bllLoanTeam.GetLoanOfficer(LoanID); Lo.Rate = GetUserCompRate(LOUserId); Lo.Amount = Lo.Rate * loanAmount / 100.00M; list.Add(Lo); loanInfo.BranchID = loanInfo.BranchID != null ? loanInfo.BranchID : 0; var branchM = new ViewCompDetail(); branchM.Type = "Branch Manager"; LPWeb.BLL.BranchManagers bllbranM = new LPWeb.BLL.BranchManagers(); var branchUserId = 0; var branchObj = bllbranM.GetModelList("BranchId =" + loanInfo.BranchID).FirstOrDefault(); if (branchObj != null) { branchUserId = branchObj.BranchMgrId; } LPWeb.Model.Users userBrM = bllUsers.GetModel(branchUserId); if (userBrM != null && userBrM.UserId == branchUserId) { branchM.Name = userBrM.LastName + "," + userBrM.FirstName; branchM.Rate = GetBranchMgrCompRate(LOUserId); branchM.Amount = branchM.Rate * loanAmount / 100.00M; } list.Add(branchM); loanInfo.DivisionID = loanInfo.DivisionID != null ? loanInfo.DivisionID : 0; var divisionM = new ViewCompDetail(); divisionM.Type = "Division Manager"; LPWeb.BLL.DivisionExecutives bllDivM = new LPWeb.BLL.DivisionExecutives(); var DivMUserId = 0; var divobj = bllDivM.GetModelList("DivisionId =" + loanInfo.DivisionID).FirstOrDefault(); if (divobj != null) { DivMUserId = divobj.ExecutiveId; } LPWeb.Model.Users userDivM = bllUsers.GetModel(DivMUserId); if (userDivM != null && userDivM.UserId == DivMUserId) { divisionM.Name = userDivM.LastName + "," + userDivM.FirstName; divisionM.Rate = GetDivisionMgrCompRate(LOUserId); divisionM.Amount = divisionM.Rate * loanAmount / 100.00M; } list.Add(divisionM); loanInfo.RegionID = loanInfo.RegionID != null ? loanInfo.RegionID : 0; var RegionM = new ViewCompDetail(); RegionM.Type = "Region Manager"; LPWeb.BLL.RegionExecutives bllRegionM = new LPWeb.BLL.RegionExecutives(); var RegionMUserId = 0; var regionObj = bllRegionM.GetModelList("RegionId =" + loanInfo.RegionID).FirstOrDefault(); if (regionObj != null) { RegionMUserId = regionObj.ExecutiveId; } LPWeb.Model.Users userRegionM = bllUsers.GetModel(RegionMUserId); if (userRegionM != null && userRegionM.UserId == RegionMUserId) { RegionM.Name = userRegionM.LastName + "," + userRegionM.FirstName; RegionM.Rate = GetRegionMgrCompRate(LOUserId); RegionM.Amount = RegionM.Rate * loanAmount / 100.00M; } list.Add(RegionM); gvCompDetail.DataSource = list; gvCompDetail.DataBind(); }