我用到的三种SQLHelper(二)详细用法

using System;

using System.Data;

using System.Configuration;

using System.Web;

using System.Text;

using System.Collections.Generic;

using System.Data.SqlClient;

using SQLHelper;

using Model;

/// <summary>

/// AdminSQL 的摘要说明

/// </summary>

namespace DAL

{

    public class AdminSQL

    {

        /// <summary>

        /// 添加

        /// </summary>

        /// <param name="admin"></param>

        /// <returns></returns>

        public int Add_Admin(Admin admin)

        {

             SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

             SqlParameter[] ParamList ={ 

                 sqlHelper.CreateInParam("@UserName",SqlDbType.NVarChar,50,admin.UserName),

                 sqlHelper.CreateInParam("@Password",SqlDbType.NVarChar,50,admin.Password),

                 sqlHelper.CreateInParam("@LastLoginIP",SqlDbType.NVarChar,50,admin.LastLoginIP),

                 sqlHelper.CreateInParam("@LastLoginTime",SqlDbType.DateTime,8,admin.LastLoginTime)

             };

             try

             {

                 return(sqlHelper.RunProc("Add_Admin", ParamList));

             }

             catch (Exception ex)

             {

                 SystemError.CreateErrorLog(ex.Message);

                 throw new Exception(ex.Message, ex);

             }

        }

        /// <summary>

        /// 修改

        /// </summary>

        /// <param name="admin"></param>

        public void Update_Admin(Admin admin)

        {

            SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

            SqlParameter[] ParamList ={ 

                 sqlHelper.CreateInParam("@ID",SqlDbType.Int,4,admin.ID),

                 sqlHelper.CreateInParam("@UserName",SqlDbType.NVarChar,50,admin.UserName),

                 sqlHelper.CreateInParam("@Password",SqlDbType.NVarChar,50,admin.Password),

                 sqlHelper.CreateInParam("@LastLoginIP",SqlDbType.NVarChar,50,admin.LastLoginIP),

                 sqlHelper.CreateInParam("@LastLoginTime",SqlDbType.DateTime,8,admin.LastLoginTime)

             };

            try

            {

                sqlHelper.RunProc("Update_Admin", ParamList);

            }

            catch (Exception ex)

            {

                SystemError.CreateErrorLog(ex.Message);

                throw new Exception(ex.Message, ex);

            }

        }

        /// <summary>

        /// 删除

        /// </summary>

        /// <param name="nID"></param>

        public void Delete_Admin(int nID)

        {

             SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

             SqlParameter[] ParamList ={ sqlHelper.CreateInParam("@ID",SqlDbType.Int,4,nID)};

             try

             {

                 sqlHelper.RunProc("Delete_Admin", ParamList);

             }

             catch (Exception ex)

             {

                 SystemError.CreateErrorLog(ex.Message);

                 throw new Exception(ex.Message, ex);

             }

        }

        /// <summary>

        /// 查看全部,返回包含所有记录.

        /// </summary>

        /// <returns></returns>

        public List<Admin> Get_Admin()

        {

            SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

            SqlDataReader rec = null;

            try

            {

                sqlHelper.RunProc("Get_Admin", out rec);

            }

            catch (Exception ex)

            {

                SystemError.CreateErrorLog(ex.Message);

                throw new Exception(ex.Message, ex);

            }

            List<Admin> List_Admin = new List<Admin>();

            while (rec.Read())

            {

                Admin admin = new Admin();

                admin.ID = Int32.Parse(rec["ID"].ToString());

                admin.UserName = rec["UserName"].ToString();

                admin.Password = rec["Password"].ToString();

                admin.LastLoginIP = rec["LastLoginIP"].ToString();

                admin.LastLoginTime = DateTime.Parse(rec["LastLoginTime"].ToString());

                List_Admin.Add(admin);

                admin = null;

            }

            rec.Close();

            return List_Admin;

        }

        /// <summary>

        /// 查看单个,输入一个用户名,返回一个包含全部信息的类.

        /// </summary>

        /// <param name="nID"></param>

        /// <returns></returns>

        public Admin Get_SingAdmin(string sUserName)

        {

            SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

            //参数列表                  //SqlHelper的创建参数方法(参数名,对应字段;参数类型;参数值)

            SqlParameter[] ParamList ={ sqlHelper.CreateInParam("@UserName", SqlDbType.NVarChar,50,sUserName) };

            SqlDataReader rec = null;

            try

            {

                //执行存储过程(存储过程名,参数列表,输出参数)

                sqlHelper.RunProc("Get_SingAdmin", ParamList, out rec);

            }

            catch (Exception ex)

            {

                SystemError.CreateErrorLog(ex.Message);

                throw new Exception(ex.Message, ex);

            }

            //Model,一个类对应数据库中一个表

            Admin admin = new Admin();

            while (rec.Read())

            {

                admin.ID = Int32.Parse(rec["ID"].ToString());//int类型转换

                admin.UserName = rec["UserName"].ToString();

                admin.Password = rec["Password"].ToString();

                admin.LastLoginIP = rec["LastLoginIP"].ToString();

                admin.LastLoginTime = DateTime.Parse(rec["LastLoginTime"].ToString());

            }

            rec.Close();

            return admin;

        }

        /// <summary>

        /// 用户是否存在

        /// </summary>

        /// <param name="sUserName"></param>

        /// <returns></returns>

        public bool Login_Admin(string sUserName)

        {

            SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

            SqlParameter[] ParamList ={ sqlHelper.CreateInParam("@UserName", SqlDbType.NVarChar, 50, sUserName) };

            SqlDataReader rec = null;

            try

            {

                sqlHelper.RunProc("Login_Admin", ParamList, out rec);

            }

            catch (Exception ex)

            {

                SystemError.CreateErrorLog(ex.Message);

                throw new Exception(ex.Message, ex);

            }

            bool Bool = false;

            while (rec.Read())

            {

                if (sUserName == rec["UserName"].ToString())

                {

                    Bool = true;

                }

            }

            rec.Close();

            return Bool;

        }

    }

}