C#通用DAO实现(二)

二、实现类(这里只编写了SqlServer版本的)没有加以整理，纯粹按需编写

 

为了方便移动拷贝，所有代码全部编写在一个文件里面(3000多行),我只有分块粘贴出来了

 using System; using System.Collections; using System.Collections.Generic; using System.Text; using System.Reflection; using System.Data.Common; using System.Data; using System.Data.SqlClient; using System.Configuration; using System.Data.OleDb; namespace AccpORM { /// <summary> /// 该类用于描述非范型分页Bean的条件和结果 /// </summary> /// <typeparam name="T"></typeparam> public class PaginationInfo { /* 分页条件部分 */ //表示要参与分页的类 private Type _classType = null; public Type ClassType { get { return _classType; } set { _classType = value; } } private String tableName = null; public String TableName { get { return tableName; } set { tableName = value; } } private int pageSize = 1000; public int PageSize { get { return pageSize; } set { pageSize = value; } } private int curPageNum = 1; public int CurPageNum { get { return curPageNum; } set { curPageNum = value; } } private Connditon[] condictions = null;//条件分页 public Connditon[] Conditions { get { return condictions; } set { condictions = value; } } private String orderPlace;//分页排序 public String OrderPlace { get { return orderPlace; } set { orderPlace = value; } } /* 分页结果部分 */ private int maxRows = 0;//总条数 public int MaxRows { get { return maxRows; } set { maxRows = value; } } private int maxPage = 0;//总页数 public int MaxPage { get { return maxPage; } set { maxPage = value; } } private List<Object> list = null;//分页结果 public List<Object> List { get { return list == null ? new List<Object>() : list; } set { list = value; } } public void Reset() { this._classType = null; this.tableName = ""; this.condictions = null; this.curPageNum = 1; this.List = null; this.maxPage = 0; this.maxRows = 0; this.orderPlace = null; this.pageSize = 1000; } } /// <summary> /// 该类用于描述范型分页Bean的条件和结果 /// </summary> /// <typeparam name="T"></typeparam> public class PageInfo<T> { /* 分页条件部分 */ private String tableName = null; public String TableName { get { return tableName; } se