Project.Dal/UserInfoDal.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Text;
using System.Collections.Generic;
using System.Data;
using System.Data.Common;
using System.Data.SqlClient;
using Project.Model;
using System.Data;
using Project.Common;


///========================================================================
/// Project: 权限系统	
/// Copyright: Copyright (c) 2007
/// Company: 
///========================================================================

namespace Project.Dal
{

	/// <summary>
	///Title: UserInfo类
	///Description: UserInfo表SQLServer数据库操作实现代码
	///@author xu
	///@version 1.0.0.0
	///@date 2012-9-21
	///@modify 
	///@date 
	/// </summary>
	public class UserInfoDal
	{		
		#region 数据库基本操作方法

        /// <summary>
        /// 根据条件分页查询信息
        /// </summary>
        /// <param name="pageIndex">当前页码</param>
        /// <param name="pageSize">每页大小</param>
        /// <param name="whereSql">分页查询条件</param>
        /// <param name="recordCount">out参数，当前条件下的总记录数</param>
        /// <returns>分页查询后的信息</returns>
        public DataTable GetList(int pageIndex, int pageSize, string whereSql, out int recordCount)
        {
            DataTable dt = null;
            int startIndex = pageIndex <= 1 ? 1 : ((pageIndex - 1) * pageSize + 1);
            int endIndex = startIndex + pageSize - 1;
            SqlParameter[] parms = { 
                                       new SqlParameter("@StartIndex",SqlDbType.Int),
                                       new SqlParameter("@EndIndex",SqlDbType.Int),
                                       new SqlParameter("@WhereSql",SqlDbType.NVarChar,2000),
                                       new SqlParameter("@RecordCount",SqlDbType.Int)
                                   };
            parms[0].Value = startIndex;
            parms[1].Value = endIndex;
            parms[2].Value = whereSql;
            parms[3].Direction = ParameterDirection.Output;
            dt = SQLHelper.GetDataTable(CommandType.StoredProcedure, "UP_UserInfo_List_select", parms);
            recordCount = Convert.ToInt32(parms[3].Value);
            return dt;