当前文件： XinYuCompanyManageSystem/DAL/AdminSQL.cs[6K，2009-6-12 11:59:35]，打开代码结构图

		            
  1using System;
  2using System.Data;
  3using System.Configuration;
  4using System.Web;
  5using System.Text;
  6using System.Collections.Generic;
  7using System.Data.SqlClient;
  8using SQLHelper;
  9using Model;
 10/**//// <summary>
 11/// AdminSQL 的摘要说明
 12/// </summary>
 13namespace DAL
 14...{
 15    public class AdminSQL
 16    ...{
 17        /**//// <summary>
 18        /// 添加
 19        /// </summary>
 20        /// <param name="admin"></param>
 21        /// <returns></returns>
 22        public int Add_Admin(Admin admin)
 23        ...{
 24             SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();
 25             SqlParameter[] ParamList =...{ 
 26                 sqlHelper.CreateInParam("@UserName",SqlDbType.NVarChar,50,admin.UserName),
 27                 sqlHelper.CreateInParam("@Password",SqlDbType.NVarChar,50,admin.Password),
 28                 sqlHelper.CreateInParam("@LastLoginIP",SqlDbType.NVarChar,50,admin.LastLoginIP),
 29                 sqlHelper.CreateInParam("@LastLoginTime",SqlDbType.DateTime,8,admin.LastLoginTime)
 30             };
 31             try
 32             ...{
 33                 return(sqlHelper.RunProc("Add_Admin", ParamList));
 34             }
 35             catch (Exception ex)
 36             ...{
 37                 SystemError.CreateErrorLog(ex.Message);
 38                 throw new Exception(ex.Message, ex);
 39             }
 40        }
 41        /**//// <summary>
 42        /// 修改
 43        /// </summary>
 44        /// <param name="admin"></param>
 45        public void Update_Admin(Admin admin)
 46        ...{
 47            SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();
 48            SqlParameter[] ParamList =...{ 
 49                 sqlHelper.CreateInParam("@ID",SqlDbType.Int,4,admin.ID),
 50                 sqlHelper.CreateInParam("@UserName",SqlDbType.NVarChar,50,admin.UserName),
 51                 sqlHelper.CreateInParam("@Password",SqlDbType.NVarChar,50,admin.Password),
 52                 sqlHelper.CreateInParam("@LastLoginIP",SqlDbType.NVarChar,50,admin.LastLoginIP),
 53                 sqlHelper.CreateInParam("@LastLoginTime",SqlDbType.DateTime,8,admin.LastLoginTime)
 54             };
 55            try
 56            ...{
 57                sqlHelper.RunProc("Update_Admin", ParamList);
 58            }
 59            catch (Exception ex)
 60            ...{
 61                SystemError.CreateErrorLog(ex.Message);
 62                throw new Exception(ex.Message, ex);
 63            }
 64        }
 65        /**//// <summary>
 66        /// 删除
 67        /// </summary>
 68        /// <param name="nID"></param>
 69        public void Delete_Admin(int nID)
 70        ...{
 71             SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();
 72             SqlParameter[] ParamList =...{ sqlHelper.CreateInParam("@ID",SqlDbType.Int,4,nID)};
 73             try
 74             ...{
 75                 sqlHelper.RunProc("Delete_Admin", ParamList);
 76             }
 77             catch (Exception ex)
 78             ...{
 79                 SystemError.CreateErrorLog(ex.Message);
 80                 throw new Exception(ex.Message, ex);
 81             }
 82        }
 83        /**//// <summary>
 84        /// 查看全部
 85        /// </summary>
 86        /// <returns></returns>
 87        public List<Admin> Get_Admin()
 88        ...{
 89            SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();
 90            SqlDataReader rec = null;
 91            try
 92            ...{
 93                sqlHelper.RunProc("Get_Admin", out rec);
 94            }
 95            catch (Exception ex)
 96            ...{
 97                SystemError.CreateErrorLog(ex.Message);
 98                throw new Exception(ex.Message, ex);
 99            }
100            List<Admin> List_Admin = new List<Admin>();
101            while (rec.Read())
102            ...{
103                Admin admin = new Admin();
104                admin.ID = Int32.Parse(rec["ID"].ToString());
105                admin.UserName = rec["UserName"].ToString();
106                admin.Password = rec["Password"].ToString();
107                admin.LastLoginIP = rec["LastLoginIP"].ToString();
108                admin.LastLoginTime = DateTime.Parse(rec["LastLoginTime"].ToString());
109                List_Admin.Add(admin);
110                admin = null;
111            }
112            return List_Admin;
113        }
114        /**//// <summary>
115        /// 查看单个
116        /// </summary>
117        /// <param name="nID"></param>
118        /// <returns></returns>
119        public Admin Get_SingAdmin(string sUserName)
120        ...{
121            SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();
122            SqlParameter[] ParamList =...{ sqlHelper.CreateInParam("@UserName", SqlDbType.NVarChar,50,sUserName) };
123            SqlDataReader rec = null;
124            try
125            ...{
126                sqlHelper.RunProc("Get_SingAdmin", ParamList, out rec);
127            }
128            catch (Exception ex)
129            ...{
130                SystemError.CreateErrorLog(ex.Message);
131                throw new Exception(ex.Message, ex);
132            }
133            Admin admin = new Admin();
134            while (rec.Read())
135            ...{
136                admin.ID = Int32.Parse(rec["ID"].ToString());
137                admin.UserName = rec["UserName"].ToString();
138                admin.Password = rec["Password"].ToString();
139                admin.LastLoginIP = rec["LastLoginIP"].ToString();
140                admin.LastLoginTime = DateTime.Parse(rec["LastLoginTime"].ToString());
141            }
142            return admin;
143        }
144        /**//// <summary>
145        /// 用户是否存在
146        /// </summary>
147        /// <param name="sUserName"></param>
148        /// <returns></returns>
149        public bool Login_Admin(string sUserName)
150        ...{
151            SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();
152            SqlParameter[] ParamList =...{ sqlHelper.CreateInParam("@UserName", SqlDbType.NVarChar, 50, sUserName) };
153            SqlDataReader rec = null;
154            try
155            ...{
156                sqlHelper.RunProc("Login_Admin", ParamList, out rec);
157            }
158            catch (Exception ex)
159            ...{
160                SystemError.CreateErrorLog(ex.Message);
161                throw new Exception(ex.Message, ex);
162            }
163            bool Bool = false;
164            while (rec.Read())
165            ...{
166                if (sUserName == rec["UserName"].ToString())
167                ...{
168                    Bool = true;
169                }
170            }
171            return Bool;
172        }
173    }
174}
175