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)); }