private string GetWhereStr(QueryCustBasicInfo query)
{
string where = "";
if (!string.IsNullOrEmpty(query.CustName))
{
where += " AND cb.CustName LIKE '" + SqlFilter(query.CustName) + "%'";
}
if (!string.IsNullOrEmpty(query.Sexs))
{
where += " AND cb.Sex IN (" + Dal.Util.SqlFilterByInCondition(query.Sexs) + ")";
}
if (!string.IsNullOrEmpty(query.CustTel))
{
where += " AND cb.CustID IN (SELECT CustID FROM dbo.CustTel WHERE Tel='" + SqlFilter(query.CustTel) + "')";
}
if (query.ProvinceID > 0)
{
where += " AND cb.ProvinceID=" + query.ProvinceID;
}
if (query.CityID > 0)
{
where += " AND cb.CityID=" + query.CityID;
}
if (query.CountyID > 0)
{
where += " AND cb.CountyID=" + query.CountyID;
}
return(where);
}
private void CustBaseInfoDataBind()
{
QueryCustBasicInfo query = new QueryCustBasicInfo();
query.CustName = RequestCustName;
query.Sexs = RequestSexs;
query.CustTel = RequestCustTel;
query.ProvinceID = CommonFunction.ObjectToInteger(RequestProvinceID, -1);
query.CityID = CommonFunction.ObjectToInteger(RequestCityID, -1);
query.CountyID = CommonFunction.ObjectToInteger(RequestCountyID, -1);
repeaterTableList.DataSource = BLL.CustBasicInfo.Instance.GetCustBasicInfo(query, "cb.CreateTime Desc", BLL.PageCommon.Instance.PageIndex, pageSize, out RecordCount);
repeaterTableList.DataBind();
AjaxPager_Custs.PageSize = 20;
AjaxPager_Custs.InitPager(RecordCount);
}
/// 查询个人用户信息
/// <summary>
/// 查询个人用户信息
/// </summary>
/// <param name="query"></param>
/// <param name="queryCallInfo"></param>
/// <param name="queryDealerInfo"></param>
/// <param name="queryCustHistoryInfo"></param>
/// <param name="outField"></param>
/// <param name="order"></param>
/// <param name="currentPage"></param>
/// <param name="pageSize"></param>
/// <param name="tableEndName"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public DataTable GetCustBasicInfo(QueryCustBasicInfo query, string order, int currentPage, int pageSize, out int totalCount)
{
string where = GetWhereStr(query);
DataSet ds;
SqlParameter[] parameters =
{
new SqlParameter("@where", SqlDbType.NVarChar, 40000),
new SqlParameter("@order", SqlDbType.NVarChar, 200),
new SqlParameter("@pagesize", SqlDbType.Int, 4),
new SqlParameter("@indexpage", SqlDbType.Int, 4),
new SqlParameter("@totalRecorder", SqlDbType.Int, 4)
};
parameters[0].Value = where;
parameters[1].Value = order;
parameters[2].Value = pageSize;
parameters[3].Value = currentPage;
parameters[4].Direction = ParameterDirection.Output;
ds = SqlHelper.ExecuteDataset(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_CUSTBASICINFO_SELECT, parameters);
totalCount = (int)(parameters[4].Value);
return(ds.Tables[0]);
}
/// 查询个人用户信息
/// <summary>
/// 查询个人用户信息
/// </summary>
/// <param name="query"></param>
/// <param name="queryCallInfo"></param>
/// <param name="queryDealerInfo"></param>
/// <param name="queryCustHistoryInfo"></param>
/// <param name="outField"></param>
/// <param name="order"></param>
/// <param name="currentPage"></param>
/// <param name="pageSize"></param>
/// <param name="tableEndName"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public DataTable GetCustBasicInfo(QueryCustBasicInfo query, string order, int currentPage, int pageSize, out int totalCount)
{
return(Dal.CustBasicInfo.Instance.GetCustBasicInfo(query, order, currentPage, pageSize, out totalCount));
}
