protected void Page_Load(object sender, EventArgs e) { if (this.IsPostBack == false) { #region 加载Service Type Filter ServiceTypes ServiceTypeManager = new ServiceTypes(); DataTable ServiceTypeList = ServiceTypeManager.GetServiceTypeList(" and (Enabled=1)"); DataRow NewServiceTypeRow = ServiceTypeList.NewRow(); NewServiceTypeRow["ServiceTypeId"] = DBNull.Value; NewServiceTypeRow["Name"] = "-- select --"; ServiceTypeList.Rows.InsertAt(NewServiceTypeRow, 0); ServiceTypeList.AcceptChanges(); this.ddlServiceType.DataSource = ServiceTypeList; this.ddlServiceType.DataBind(); #endregion } }
protected void Page_Load(object sender, EventArgs e) { if (CurrUser.userRole.ContactBranch.ToString().IndexOf('1') == -1) { Response.Redirect("../Unauthorize.aspx"); // have not View Power return; } sHasCreate = CurrUser.userRole.ContactBranch.ToString().IndexOf('2') > -1 ? "1" : "0"; sHasModify = CurrUser.userRole.ContactBranch.ToString().IndexOf('3') > -1 ? "1" : "0"; sHasDelete = CurrUser.userRole.ContactBranch.ToString().IndexOf('4') > -1 ? "1" : "0"; sHasDisable = CurrUser.userRole.ContactBranch.ToString().IndexOf('5') > -1 ? "1" : "0"; sHasAddBranch = CurrUser.userRole.ContactBranch.ToString().IndexOf('6') > -1 ? "1" : "0"; sHasRemoveBranch = CurrUser.userRole.ContactBranch.ToString().IndexOf('7') > -1 ? "1" : "0"; sHasModifyCompany = CurrUser.userRole.ContactCompany.ToString().IndexOf('3') > -1 ? "1" : "0"; //Company Modify sHasModifyServiceType = CurrUser.userRole.ServiceType.ToString().IndexOf('1') > -1 ? "1" : "0"; //Service Type View if (sHasDelete == "0") { btnDelete.Enabled = false; } if (sHasDisable == "0") { btnDisable.Enabled = false; } #region 加载Service Type Filter ServiceTypes ServiceTypeManager = new ServiceTypes(); DataTable ServiceTypeList = ServiceTypeManager.GetServiceTypeList(" and (Enabled=1)"); DataRow NewServiceTypeRow = ServiceTypeList.NewRow(); NewServiceTypeRow["ServiceTypeId"] = "0"; NewServiceTypeRow["Name"] = "All Service Types"; ServiceTypeList.Rows.InsertAt(NewServiceTypeRow, 0); ServiceTypeList.AcceptChanges(); this.ddlServiceType.DataSource = ServiceTypeList; this.ddlServiceType.DataBind(); #endregion #region 加载Company Filter ContactCompanies ContactCompaniesManager = new ContactCompanies(); DataSet ContactCompaniesList = ContactCompaniesManager.GetList("(Enabled=1) order by Name"); //if (ContactCompaniesList != null && ContactCompaniesList.Tables[0].Rows.Count > 0) //{ DataRow NewContactCompaniesRow = ContactCompaniesList.Tables[0].NewRow(); NewContactCompaniesRow["ContactCompanyId"] = "0"; NewContactCompaniesRow["Name"] = "All Companies"; ContactCompaniesList.Tables[0].Rows.InsertAt(NewContactCompaniesRow, 0); ContactCompaniesList.Tables[0].AcceptChanges(); this.ddlCompany.DataSource = ContactCompaniesList.Tables[0]; this.ddlCompany.DataBind(); //} #endregion #region 加载States Filter LPWeb.Layouts.LPWeb.Common.USStates.Init(this.ddlStates); #endregion #region 加载Company列表 this.BranchSqlDataSource.ConnectionString = LPWeb.DAL.DbHelperSQL.connectionString; string sWhere = string.Empty; bool bSetCondition = false; // Alphabet if (this.Request.QueryString["Alphabet"] != null) { string sAlphabet = this.Request.QueryString["Alphabet"].ToString(); sWhere += " and (Branch like '" + sAlphabet + "%')"; bSetCondition = true; } // Service Type if (this.Request.QueryString["ServiceType"] != null) { string sServiceType = this.Request.QueryString["ServiceType"].ToString(); if (PageCommon.IsID(sServiceType) == true) { sWhere += " and (ServiceTypeId =" + SqlTextBuilder.ConvertQueryValue(sServiceType) + ")"; } else { sWhere += " and (ServiceTypeId =0)"; } bSetCondition = true; } // Company if (this.Request.QueryString["Company"] != null) { string sCompany = this.Request.QueryString["Company"].ToString(); if (PageCommon.IsID(sCompany) == true) { sWhere += " and (ContactCompanyId =" + SqlTextBuilder.ConvertQueryValue(sCompany) + ")"; } else { sWhere += " and (ContactCompanyId =0)"; } bSetCondition = true; } // State if (this.Request.QueryString["State"] != null) { string sState = this.Request.QueryString["State"].ToString(); if (sState != "") { sWhere += " and ([State] ='" + SqlTextBuilder.ConvertQueryValue(sState) + "')"; bSetCondition = true; } } int iRowCount = LPWeb.DAL.DbHelperSQL.Count(this.BranchSqlDataSource.SelectParameters["DbTable"].DefaultValue, sWhere); // empty data text if (iRowCount == 0 && bSetCondition == true) { this.gridBranchList.EmptyDataText = "There is no partner branch by search criteria,please search again."; } else { this.gridBranchList.EmptyDataText = "There is no partner branch."; } this.AspNetPager1.RecordCount = iRowCount; this.BranchSqlDataSource.SelectParameters["Where"].DefaultValue = sWhere; this.gridBranchList.DataBind(); #endregion }
protected void Page_Load(object sender, EventArgs e) { string sReturnJs = "window.location.href='PartnerCompanyList.aspx';"; #region 权限控制 sHasCreate = CurrUser.userRole.ContactBranch.ToString().IndexOf('2') > -1 ? "1" : "0"; sHasModify = CurrUser.userRole.ContactBranch.ToString().IndexOf('3') > -1 ? "1" : "0"; sHasDelete = CurrUser.userRole.ContactBranch.ToString().IndexOf('4') > -1 ? "1" : "0"; sHasDisable = CurrUser.userRole.ContactBranch.ToString().IndexOf('5') > -1 ? "1" : "0"; sHasAddBranch = CurrUser.userRole.ContactBranch.ToString().IndexOf('6') > -1 ? "1" : "0"; sHasRemoveBranch = CurrUser.userRole.ContactBranch.ToString().IndexOf('7') > -1 ? "1" : "0"; if (sHasDisable == "0") { lnkDisableBranch.Enabled = false; } if (sHasDelete == "0") { lnkDeleteBranch.Enabled = false; } #endregion #region 检查页面参数 bool bIsValid = PageCommon.ValidateQueryString(this, "CompanyID", QueryStringType.ID); if (bIsValid == false) { PageCommon.WriteJsEnd(this, "Missing required query string.", sReturnJs); } this.iCompanyID = Convert.ToInt32(this.Request.QueryString["CompanyID"]); #endregion #region 加载Company信息 ContactCompanies ContactCompanyManager = new ContactCompanies(); DataTable CompanyInfo = ContactCompanyManager.GetContactCompanyInfo(this.iCompanyID); if (CompanyInfo.Rows.Count == 0) { PageCommon.WriteJsEnd(this, "Invalid query string.", sReturnJs); } #endregion #region 加载Branch列表 this.BranchSqlDataSource.ConnectionString = LPWeb.DAL.DbHelperSQL.connectionString; string sWhere = " and (ContactCompanyId=" + this.iCompanyID + ")"; bool bSetCondition = false; // Alphabet if (this.Request.QueryString["Alphabet"] != null) { string sAlphabet = this.Request.QueryString["Alphabet"].ToString(); sWhere += " and (Name like '" + sAlphabet + "%')"; bSetCondition = true; } int iRowCount = LPWeb.DAL.DbHelperSQL.Count(this.BranchSqlDataSource.SelectParameters["DbTable"].DefaultValue, sWhere); // empty data text if (iRowCount == 0 && bSetCondition == true) { this.gridBranchList.EmptyDataText = "There is no Partner Branch by search criteria,please search again."; } else { this.gridBranchList.EmptyDataText = "There is no Partner Branch."; } this.AspNetPager1.RecordCount = iRowCount; this.BranchSqlDataSource.SelectParameters["Where"].DefaultValue = sWhere; this.gridBranchList.DataBind(); #endregion if (this.IsPostBack == false) { #region 加载Service Type Filter ServiceTypes ServiceTypeManager = new ServiceTypes(); DataTable ServiceTypeList = ServiceTypeManager.GetServiceTypeList(" and (Enabled=1)"); DataRow NewServiceTypeRow = ServiceTypeList.NewRow(); NewServiceTypeRow["ServiceTypeId"] = DBNull.Value; NewServiceTypeRow["Name"] = "-- select --"; ServiceTypeList.Rows.InsertAt(NewServiceTypeRow, 0); ServiceTypeList.AcceptChanges(); this.ddlServiceType.DataSource = ServiceTypeList; this.ddlServiceType.DataBind(); #endregion #region 绑定Company数据 this.txtCompanyName.Text = CompanyInfo.Rows[0]["Name"].ToString(); this.ddlServiceType.SelectedValue = CompanyInfo.Rows[0]["ServiceTypeId"].ToString(); if (CompanyInfo.Rows[0]["Enabled"] == DBNull.Value) { this.chkEnabled.Checked = true; } else { this.chkEnabled.Checked = Convert.ToBoolean(CompanyInfo.Rows[0]["Enabled"]); } this.txtAddress.Text = CompanyInfo.Rows[0]["Address"].ToString(); this.txtCity.Text = CompanyInfo.Rows[0]["City"].ToString(); this.ddlState.SelectedValue = CompanyInfo.Rows[0]["State"].ToString(); this.txtZip.Text = CompanyInfo.Rows[0]["Zip"].ToString(); this.tbWebsite.Text = string.Format("{0}", CompanyInfo.Rows[0]["Website"].ToString()); #endregion } }
protected void Page_Load(object sender, EventArgs e) { #region 校验页面参数 bool bIsValid = PageCommon.ValidateQueryString(this, "DelContactID", QueryStringType.ID); if (bIsValid == false) { PageCommon.WriteJsEnd(this, "Messing required query string.", PageCommon.Js_RefreshParent); } this.iDelContactID = Convert.ToInt32(this.Request.QueryString["DelContactID"]); // 检查Contact是否存在 string sSql = "select * from Contacts where ContactID=" + iDelContactID; DataTable DelContactInfo = LPWeb.DAL.DbHelperSQL.ExecuteDataTable(sSql); if (DelContactInfo.Rows.Count == 0) { PageCommon.WriteJsEnd(this, "Invalid contact id.", PageCommon.Js_RefreshParent); } #endregion if (this.IsPostBack == false) { #region 加载Service Type Filter ServiceTypes ServiceTypeManager = new ServiceTypes(); DataTable ServiceTypeList = ServiceTypeManager.GetServiceTypeList(" and (Enabled=1)"); DataRow NewServiceTypeRow = ServiceTypeList.NewRow(); NewServiceTypeRow["ServiceTypeId"] = DBNull.Value; NewServiceTypeRow["Name"] = "All"; ServiceTypeList.Rows.InsertAt(NewServiceTypeRow, 0); ServiceTypeList.AcceptChanges(); this.ddlServiceType.DataSource = ServiceTypeList; this.ddlServiceType.DataBind(); #endregion if (this.Request.QueryString["DoSearch"] == null) { //this.divSearchCriteria.Visible = true; this.divSearchResult.Visible = false; } else { //this.divSearchCriteria.Visible = false; this.divSearchResult.Visible = true; #region 加载Contact List string sDbTable = "(select a.*, a.LastName +', '+ a.FirstName + case when ISNULL(a.MiddleName, '') != '' then ' '+ a.MiddleName else '' end as FullName, " + "'Partner' as ContactType, c.ServiceTypeID, e.Name as ServiceType, d.Name as BranchName, c.Name as CompanyName " + "from Contacts as a left outer join LoanContacts as b on a.ContactId = b.ContactId " + "left outer join ContactCompanies as c on a.ContactCompanyId = c.ContactCompanyId " + "left outer join ContactBranches as d on a.ContactBranchId=d.ContactBranchId " + "left outer join ServiceTypes as e on c.ServiceTypeId=e.ServiceTypeId " + "where b.ContactRoleId!=1 and b.ContactRoleId!=2 and a.ContactCompanyId is not null " + "union " + "select a.*, a.LastName +', '+ a.FirstName + case when ISNULL(a.MiddleName, '') != '' then ' '+ a.MiddleName else '' end as FullName, " + "'Client' as ContactType, null as ServiceTypeID, null as ServiceType, null as BranchName, null as CompanyName " + "from Contacts as a left outer join LoanContacts as b on a.ContactId = b.ContactId " + "where (b.ContactRoleId=1 or b.ContactRoleId=2)) as t"; #region Build Where string sWhere = ""; // ContactType if (this.Request.QueryString["ContactType"] != null) { string sContactType = this.Request.QueryString["ContactType"].ToString(); if (sContactType == "Partner" || sContactType == "Client") { sWhere += " and ContactType='" + sContactType + "'"; } } // ServiceType if (this.Request.QueryString["ServiceType"] != null) { string sServiceType = this.Request.QueryString["ServiceType"].ToString(); sWhere += " and ServiceTypeID=" + sServiceType; } // Company if (this.Request.QueryString["Company"] != null) { string sCompany = this.Request.QueryString["Company"].ToString(); sWhere += " and CompanyName like '%" + sCompany + "%'"; } // Branch if (this.Request.QueryString["Branch"] != null) { string sBranch = this.Request.QueryString["Branch"].ToString(); sWhere += " and BranchName like '%" + sBranch + "%'"; } // LastName if (this.Request.QueryString["LastName"] != null) { string sLastName = this.Request.QueryString["LastName"].ToString(); sWhere += " and LastName like '" + sLastName + "%'"; } // Address if (this.Request.QueryString["Address"] != null) { string sAddress = this.Request.QueryString["Address"].ToString(); sWhere += " and MailingAddr like '" + sAddress + "%'"; } // City if (this.Request.QueryString["City"] != null) { string sCity = this.Request.QueryString["City"].ToString(); sWhere += " and MailingCity like '" + sCity + "%'"; } // State if (this.Request.QueryString["State"] != null) { string sState = this.Request.QueryString["State"].ToString(); sWhere += " and MailingState='" + sState + "'"; } #endregion this.ContactSqlDataSource.ConnectionString = LPWeb.DAL.DbHelperSQL.connectionString; this.ContactSqlDataSource.SelectParameters["DbTable"].DefaultValue = sDbTable; int iRowCount = LPWeb.DAL.DbHelperSQL.Count(this.ContactSqlDataSource.SelectParameters["DbTable"].DefaultValue, sWhere); this.AspNetPager1.RecordCount = iRowCount; this.ContactSqlDataSource.SelectParameters["Where"].DefaultValue = sWhere; this.gridContactList.DataBind(); #endregion } } }