多条件组合查询+分页
作者:admin 日期:2008-06-04
比较麻烦,把他记录下来。
前台UI:
实现的类代码:
/// <summary>
/// 多条件组合查询
/// </summary>
/// <param name="suppliercode">供应商代码</param>
/// <param name="materialcode">物料代码</param>
/// <param name="beginDate">合同有效日期搜索开始日期</param>
/// <param name="endDate">合同有效日期搜索结束日期</param>
/// <param name="companyType">厂别</param>
/// <param name="formState">状态</param>
/// <param name="POCT">POCT</param>
/// <param name="orderField">排序字段</param>
/// <returns></returns>
public IList<Entity.CAS.PriceFormInfo> MultiSearch(string suppliercode, string materialcode, string beginDate, string endDate, string companyType, string formState, string POCT, string orderField, int pagesize, int pageindex)
{
SqlParameter[] Parms =
{
new SqlParameter("@tblName",SqlDbType.VarChar,255),
new SqlParameter("@strGetFields",SqlDbType.VarChar,1000),
new SqlParameter("@fldName",SqlDbType.VarChar,255),
&...
前台UI:
实现的类代码:
复制内容到剪贴板 程序代码
/// <summary>
/// 多条件组合查询
/// </summary>
/// <param name="suppliercode">供应商代码</param>
/// <param name="materialcode">物料代码</param>
/// <param name="beginDate">合同有效日期搜索开始日期</param>
/// <param name="endDate">合同有效日期搜索结束日期</param>
/// <param name="companyType">厂别</param>
/// <param name="formState">状态</param>
/// <param name="POCT">POCT</param>
/// <param name="orderField">排序字段</param>
/// <returns></returns>
public IList<Entity.CAS.PriceFormInfo> MultiSearch(string suppliercode, string materialcode, string beginDate, string endDate, string companyType, string formState, string POCT, string orderField, int pagesize, int pageindex)
{
SqlParameter[] Parms =
{
new SqlParameter("@tblName",SqlDbType.VarChar,255),
new SqlParameter("@strGetFields",SqlDbType.VarChar,1000),
new SqlParameter("@fldName",SqlDbType.VarChar,255),
&...