General

/// <summary>        

/// 分页查询客户资料(公用)        

/// </summary>        

/// <returns></returns>        

public static DataTable QueryClientPb(SortPage sortPage, string QueryWhere, int EId, int CId)        

{            

//增加传值参数            

　　SqlParameter[] Params = SqlHelper.SqlHelper.GetSqlParams("EId,CId,QueryWhere", false, EId, CId, QueryWhere);             　　　　　　   SqlHelper.SqlHelper.AddSortPageParam(ref Params, sortPage, "rowcount");            

　　DataTable dt = SqlHelper.SqlHelper.ExecuteDataSet("CL_GetClientPb", Params);            

　　sortPage.recordCount = (int)Params[Params.Length - 1].Value;            

 　　return dt;        

}