list model DAL

来源：互联网发布：淘宝登录优酷会员编辑：程序博客网时间：2024/05/27 16:40

   public List<sys_User> GetUserList(int pageIndex, int pageSize, ref int recordCount)        {            Database db = DatabaseFactory.CreateDatabase();            DbCommand dbCommand = db.GetStoredProcCommand("dbo.[GetUserList]");            db.AddInParameter(dbCommand, "@PageIndex", DbType.Int32, pageIndex);            db.AddInParameter(dbCommand, "@PageSize", DbType.Int32, pageSize);            db.AddOutParameter(dbCommand, "@RecordCount", DbType.Int32, recordCount);            List<sys_User> list = new List<sys_User>();            using (IDataReader dataReader = db.ExecuteReader(dbCommand))            {                while (dataReader.Read())                {                    list.Add(ReaderBind(dataReader));                }            }            recordCount = (int)dbCommand.Parameters["@RecordCount"].Value;            return list;        } private sys_User ReaderBind(IDataReader dataReader)        {            sys_User u = new sys_User();            u.UserID = Convert.ToInt32(dataReader["UserID"]);            u.UserName = dataReader["UserName"].ToString();            u.LoginName = dataReader["LoginName"].ToString();            u.Gender = Convert.ToInt32(dataReader["Gender"]);            u.MobelTel = dataReader["MobelTel"].ToString();            u.InterTel = dataReader["InterTel"].ToString();            u.OfficeTel = dataReader["OfficeTel"].ToString();            u.EmailAddress = dataReader["EmailAddress"].ToString();            object ojb;            ojb = dataReader["SoldToUser"];            if (ojb != null && ojb != DBNull.Value)            {                u.IsSoldToUser = Convert.ToBoolean(ojb);            }            u.CustomerCode = dataReader["CustomerCode"].ToString();            u.ReceiverCode = dataReader["ReceiverCode"].ToString();            return u;        }

*****************************************************************************

  public List<sys_User> GetUserListByRoleAllocation(int roleID)        {            Database db = DatabaseFactory.CreateDatabase();            DbCommand dbCommand = db.GetStoredProcCommand("dbo.[GetUserListByRoleAllocation]");            db.AddInParameter(dbCommand, "@RoleID", DbType.Int32, roleID);            List<sys_User> list = new List<sys_User>();            using (IDataReader dataReader = db.ExecuteReader(dbCommand))            {                while (dataReader.Read())                {                    sys_User u = new sys_User();                    u.UserID = Convert.ToInt32(dataReader["UserID"]);                    u.UserName = dataReader["UserName"].ToString();                    list.Add(u);                }            }            return list;        }

********************************************************************************

        public DataTable GetOrderProductList(int orderID)        {            Database db = DatabaseFactory.CreateDatabase();            DbCommand dbCommand = db.GetStoredProcCommand("dbo.[GetOrderProductList]");            db.AddInParameter(dbCommand, "@OrderID", DbType.Int32, orderID);            DataSet ds = db.ExecuteDataSet(dbCommand);            DataTable dt = ds.Tables[0];            return dt;        }