Asp.net 中通用分页解决办法

最新推荐文章于 2019-01-09 15:39:41 发布

dhz123

最新推荐文章于 2019-01-09 15:39:41 发布

阅读量931

点赞数

文章标签： asp.net string class constructor null system

本文链接：https://blog.csdn.net/dhz123/article/details/1804066

版权

在www.studyez.com网站的开发中,经常涉及到数据的分页.搞得人是不胜其烦.因此就想尽量想把分页相关统一起来.

因此,就把分页的统一了一下.暂时记录一下.

------------------------------------CSer.cs源码-----------------------------

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections.Generic;
/// <summary>
/// Summary description for BaseSplitPage
/// </summary>
public abstract class BaseSplitPage<T, U> : IDisposable where U : List<T>, new()
{
private SqlConnection _cnn;

private SqlCommand _cproc;
private SqlCommand _lproc;

    protected BaseSplitPage(string countProc, string listProc)
    {
        //
        // TODO: Add constructor logic here
        //
        _cnn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[0].ConnectionString);
        _cproc = new SqlCommand(countProc, _cnn);
        _cproc.CommandType = CommandType.StoredProcedure;
        _cproc.Parameters.Add("@strFilter", SqlDbType.NVarChar, 200);
        _lproc = new SqlCommand(listProc, _cnn);
        _lproc.CommandType = CommandType.StoredProcedure;
        _lproc.Parameters.Add("@startRecord", SqlDbType.Int);
        _lproc.Parameters.Add("@maxRecord", SqlDbType.Int);
        _lproc.Parameters.Add("@strFilter", SqlDbType.NVarChar, 200);
        _lproc.Parameters.Add("@strOrder", SqlDbType.NVarChar, 200);

    }
    public int RecordCount(string strFilter)
    {
        int res = 0;
        try
        {
            _cnn.Open();
            _cproc.Parameters[0].Value = strFilter;
            res = (int)_cproc.ExecuteScalar();

        }
        finally
        {
            _cnn.Close();
        }
        return res;

    }
    public U List(int startRecord, int maxRecord, string strFilter, string strOrderExpress)
    {
        U u = new U();
        try
        {
            _cnn.Open();
            _lproc.Parameters[0].Value = startRecord;
            _lproc.Parameters[1].Value = maxRecord;
            _lproc.Parameters[2].Value = strFilter;
            _lproc.Parameters[3].Value = strOrderExpress;
            SqlDataReader dr = _lproc.ExecuteReader(CommandBehavior.CloseConnection);
            if (dr != null)
            {
                if (dr.HasRows)
                {
                    while (dr.Read())
                    {
                        u.Add(CreateFormDB(dr));
                    }
                }
                dr.Close();
            }

        }
        finally
        {
            _cnn.Close();
        }
        return u;
    }

protected abstract T CreateFormDB(IDataRecord dr);

    #region IDisposable Members
    protected virtual void Dispose(bool disposing)
    {
        if (disposing)
        {
            if (_cnn != null)
                _cnn.Dispose();
            if (_cproc != null)
                _cproc.Dispose();
            if (_lproc != null)
                _lproc.Dispose();
        }
    }

    public void Dispose()
    {
        Dispose(true);
        GC.SuppressFinalize(this);
    }

    #endregion
}
public enum Sex
{
    /// <summary>
    /// 公的
    /// </summary>
    Gong,
    /// <summary>
    /// 母的
    /// </summary>
    Mu,
    /// <summary>
    /// 太监
    /// </summary>
    TaiJian

}
[Serializable]
public class Cser
{
    private int _age;
    private Sex _sex;
    public Cser()
    {
    }
    public Cser(int age, Sex sex)
    {
        _age = age;
        _sex = sex;

    }
    public int Age
    {
        get { return _age; }
        set { _age = value; }
    }
    public Sex GorM
    {
        get { return _sex; }
        set { _sex = value; }
    }
}
public class CserCollection:List<Cser>
{
}
public class CserSplitPage:BaseSplitPage<Cser ,CserCollection>
{
   public CserSplitPage():base("cs_userCount","cs_userList")
   {
   }

   protected override Cser CreateFormDB(IDataRecord dr)
   {
         int age=(int)dr["Age"];
         Sex sex=(Sex)Enum.Parse(typeof(Sex),(string)dr["Sex"]);
         return new Cser(age,sex );
   }
}

public class   UserPage
{
         public void Run()
         {
             using(CserSplitPage sp=new CserSplitPage())
             {
                sp.RecordCount(" Age=10");
             }
         }
}

这个东西支持单表还行,多表联合就不怎么好用.看过也用过一些ORM产品,可是老是找不到一个省心省事.

----------------------------------End--------------------------------------