private void BindGrid(int pageIndex)
{
//if (CurrentFileId < 1)
//{
// PageCommon.WriteJsEnd(this, sErrorMsg, "window.location.href='" + sReturnPage + "'");
// return;
//}
int pageSize = AspNetPager1.PageSize;
int recordCount = 0;
string strWhere = string.Empty;
//string strWhere = " (FileId <> '" + CurrentFileId.ToString() + "' OR FileId IS NULL )";
strWhere = " (1=1) ";
if (ddlServiceTypes.SelectedIndex > 0)
{
strWhere += " AND ServiceTypes = '" + ddlServiceTypes.SelectedItem.Text + "'";
}
DataSet ds = contacts.GetDistinctLoanContactsForReassign(pageSize, pageIndex, strWhere, out recordCount, OrderName, OrderType);
//DataSet ds = contacts.GetLoanContactsReassign(pageSize, pageIndex, "", out recordCount, OrderName, OrderType);
AspNetPager1.RecordCount = recordCount;
AspNetPager1.CurrentPageIndex = pageIndex;
AspNetPager1.PageSize = pageSize;
gvContacts.DataSource = ds;
gvContacts.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
#region 校验页面参数
if (this.Request.QueryString["CloseDialogCodes"] == null)
{
PageCommon.WriteJsEnd(this, "Missing required query string.", "try{window.parent.location.href=window.parent.location.href}catch{}");
}
string sCloseDialogCodes = this.Request.QueryString["CloseDialogCodes"].ToString() + ";";
bool bIsValid = PageCommon.ValidateQueryString(this, "FileID", QueryStringType.ID);
if (bIsValid == false)
{
PageCommon.WriteJsEnd(this, "Missing required query string.", sCloseDialogCodes);
}
string sFileID = this.Request.QueryString["FileID"].ToString();
this.iFileID = Convert.ToInt32(sFileID);
#endregion
#region 获取Borrower和Property信息
#region Property
LPWeb.BLL.Loans LoanManager = new LPWeb.BLL.Loans();
DataTable LoanInfo = LoanManager.GetLoanInfo(this.iFileID);
if (LoanInfo.Rows.Count == 0)
{
PageCommon.WriteJsEnd(this, "Invalid query string.", sCloseDialogCodes);
}
string sPropertyAddress = LoanInfo.Rows[0]["PropertyAddr"].ToString();
string sPropertyCity = LoanInfo.Rows[0]["PropertyCity"].ToString();
string sPropertyState = LoanInfo.Rows[0]["PropertyState"].ToString();
string sPropertyZip = LoanInfo.Rows[0]["PropertyZip"].ToString();
string sProperty = sPropertyAddress + ", " + sPropertyCity + ", " + sPropertyState + " " + sPropertyZip;
#endregion
#region Borrower
DataTable BorrowerInfo = LoanManager.GetBorrowerInfo(this.iFileID);
if (BorrowerInfo.Rows.Count == 0)
{
PageCommon.WriteJsEnd(this, "There is no Borrower in this loan.", sCloseDialogCodes);
}
string sFirstName = BorrowerInfo.Rows[0]["FirstName"].ToString();
string sMiddleName = BorrowerInfo.Rows[0]["MiddleName"].ToString();
string sLastName = BorrowerInfo.Rows[0]["LastName"].ToString();
string sBorrower = sLastName + ", " + sFirstName;
if (sMiddleName != string.Empty)
{
sBorrower += " " + sMiddleName;
}
this.lbBorrower.Text = sBorrower;
this.lbProperty.Text = sProperty;
#endregion
#endregion
#region 查询条件
string sWhere = string.Empty;
if (this.Request.QueryString["search"] == null) // 未设置查询条件
{
sWhere = " (1=0)";
}
else
{
//sWhere = " (FileId <> " + this.iFileID + ")";
sWhere = " (1=1) ";
// Service Type
if (this.Request.QueryString["ServiceType"] != null)
{
string sServiceType = this.Request.QueryString["ServiceType"];
sWhere += " and ServiceTypes='" + sServiceType + "'";
}
// Company
if (this.Request.QueryString["Company"] != null)
{
string sCompany = this.Request.QueryString["Company"];
sWhere += " and CompanyName like '" + sCompany + "%'";
}
// Zip
if (this.Request.QueryString["Zip"] != null)
{
string sZip = this.Request.QueryString["Zip"];
sWhere += " and MailingZip like '" + sZip + "%'";
}
}
#endregion
#region 排序
string sOrderByField = "ContactsName";
if (this.Request.QueryString["OrderByField"] != null)
{
sOrderByField = this.Request.QueryString["OrderByField"];
}
int iOrderByType = 0; // default asc
if (this.Request.QueryString["OrderByType"] != null)
{
string sOrderByType = this.Request.QueryString["OrderByType"];
if (sOrderByType != "0")
{
sOrderByType = "1";
}
iOrderByType = Convert.ToInt32(sOrderByType);
}
#endregion
if (this.IsPostBack == false)
{
#region 加载Service Type Filter
string sSql2 = "select * from ServiceTypes where Enabled=1 order by Name";
DataTable ServiceTypeList = LPWeb.DAL.DbHelperSQL.ExecuteDataTable(sSql2);
DataRow AllRow = ServiceTypeList.NewRow();
AllRow["ServiceTypeId"] = 0;
AllRow["Name"] = "All";
AllRow["Enabled"] = true;
ServiceTypeList.Rows.InsertAt(AllRow, 0);
this.ddlServiceType.DataSource = ServiceTypeList;
this.ddlServiceType.DataBind();
#endregion
#region 加载Contact Role Filter
string sSql3 = "select * from ContactRoles where Enabled=1 and Name <> 'Borrower' and Name <> 'CoBorrower' order by Name";
DataTable ContactRoleList = LPWeb.DAL.DbHelperSQL.ExecuteDataTable(sSql3);
DataRow EmptyRow = ContactRoleList.NewRow();
EmptyRow["ContactRoleId"] = 0;
EmptyRow["Name"] = "-- select --";
EmptyRow["Enabled"] = true;
ContactRoleList.Rows.InsertAt(EmptyRow, 0);
this.ddlContactRole.DataSource = ContactRoleList;
this.ddlContactRole.DataBind();
#endregion
#region 加载Contact List
int iPageSize = this.AspNetPager1.PageSize;
int iPageIndex = 1;
if (this.Request.QueryString["PageIndex"] != null)
{
iPageIndex = Convert.ToInt32(this.Request.QueryString["PageIndex"]);
}
int iRowCount = 0;
LPWeb.BLL.LoanContacts contacts = new LPWeb.BLL.LoanContacts();
DataSet ds = contacts.GetDistinctLoanContactsForReassign(iPageSize, iPageIndex, sWhere, out iRowCount, sOrderByField, iOrderByType);
this.AspNetPager1.RecordCount = iRowCount;
#region set EmptyDataText
if (this.Request.QueryString["search"] == null)
{
this.gridLoanContactList.EmptyDataText = "Please enter conditions and click Display.";
}
else
{
if (iRowCount == 0)
{
this.gridLoanContactList.EmptyDataText = "There is no loan contact by the conditions.";
}
}
#endregion
this.gridLoanContactList.DataSource = ds;
this.gridLoanContactList.DataBind();
#endregion
}
}