当前文件： MagRole/App_Code/USER.cs[4K，2009-6-12 11:47:15]，打开代码结构图

		            
  1using System;
  2using System.Data;
  3using System.Text;
  4using System.Data.SqlClient;
  5
  6/**//// <summary>
  7/// USER 的摘要说明
  8/// </summary>
  9public class USER
 10...{
 11    public USER()
 12        ...{}
 13        Model#region Model
 14        private int _userid;
 15        private string _username;
 16        private string _password;
 17        private int _roleid;
 18        /**//// <summary>
 19        /// 
 20        /// </summary>
 21        public int USERID
 22        ...{
 23            set...{ _userid=value;}
 24            get...{return _userid;}
 25        }
 26        /**//// <summary>
 27        /// 
 28        /// </summary>
 29        public string USERNAME
 30        ...{
 31            set...{ _username=value;}
 32            get...{return _username;}
 33        }
 34        /**//// <summary>
 35        /// 
 36        /// </summary>
 37        public string PASSWORD
 38        ...{
 39            set...{ _password=value;}
 40            get...{return _password;}
 41        }
 42        /**//// <summary>
 43        /// 
 44        /// </summary>
 45        public int ROLEID
 46        ...{
 47            set...{ _roleid=value;}
 48            get...{return _roleid;}
 49        }
 50        #endregion Model
 51
 52
 53        成员方法#region  成员方法
 54
 55        /**//// <summary>
 56        /// 是否存在该记录
 57        /// </summary>
 58        public bool Exists(int USERID)
 59        ...{
 60            StringBuilder strSql=new StringBuilder();
 61            strSql.Append("select count(1) from [USER] where USERID="+USERID+" " );
 62            return DbHelperSQL.Exists(strSql.ToString());
 63        }
 64    /**//// <summary>
 65    /// 自己添加 根据姓名判断是否存在记录
 66    /// </summary>
 67    /// <param name="USERNAME"></param>
 68    /// <returns></returns>
 69    public bool Exists(String USERNAME)
 70    ...{
 71        StringBuilder strSql = new StringBuilder();
 72        strSql.Append("select count(1) from [USER] where USERNAME='"+USERNAME +"'");
 73        return DbHelperSQL.Exists(strSql.ToString());
 74    }
 75
 76        /**//// <summary>
 77        /// 增加一条数据
 78        /// </summary>
 79        public int Add()
 80        ...{
 81            StringBuilder strSql=new StringBuilder();
 82            strSql.Append("insert into [USER](");
 83            strSql.Append("USERNAME,PASSWORD,ROLEID");
 84            strSql.Append(")");
 85            strSql.Append(" values (");
 86            strSql.Append("'"+USERNAME+"',");
 87            strSql.Append("'"+PASSWORD+"',");
 88            strSql.Append(""+ROLEID+"");
 89            strSql.Append(")");
 90            strSql.Append(";select @@IDENTITY");
 91            object obj = DbHelperSQL.GetSingle(strSql.ToString());
 92            if (obj == null)
 93            ...{
 94                return 1;
 95            }
 96            else
 97            ...{
 98                return Convert.ToInt32(obj);
 99            }
100        }
101
102        /**//// <summary>
103        /// 更新一条数据
104        /// </summary>
105        public void Update()
106        ...{
107            StringBuilder strSql=new StringBuilder();
108            strSql.Append("update [USER] set ");
109            strSql.Append("USERNAME='"+USERNAME+"',");
110            strSql.Append("PASSWORD='"+PASSWORD+"',");
111            strSql.Append("ROLEID="+ROLEID+"");
112            strSql.Append(" where USERID="+USERID+" ");
113            DbHelperSQL.ExecuteSql(strSql.ToString());
114        }
115
116        /**//// <summary>
117        /// 删除一条数据
118        /// </summary>
119        public void Delete(int USERID)
120        ...{
121            StringBuilder strSql=new StringBuilder();
122            strSql.Append("delete [USER] ");
123            strSql.Append(" where USERID="+USERID+"" );
124                DbHelperSQL.ExecuteSql(strSql.ToString());
125        }
126
127        /**//// <summary>
128        /// 得到一个对象实体
129        /// </summary>
130        public void GetModel(int USERID)
131        ...{
132            StringBuilder strSql=new StringBuilder();
133            strSql.Append("select  ");
134            strSql.Append("USERID,USERNAME,PASSWORD,ROLEID ");
135            strSql.Append(" from [USER] ");
136            strSql.Append(" where USERID="+USERID+"" );
137            DataSet ds=DbHelperSQL.Query(strSql.ToString());
138            if(ds.Tables[0].Rows.Count>0)
139            ...{
140                if(ds.Tables[0].Rows[0]["USERID"].ToString()!="")
141                ...{
142                    USERID=int.Parse(ds.Tables[0].Rows[0]["USERID"].ToString());
143                }
144                USERNAME=ds.Tables[0].Rows[0]["USERNAME"].ToString();
145                PASSWORD=ds.Tables[0].Rows[0]["PASSWORD"].ToString();
146                if(ds.Tables[0].Rows[0]["ROLEID"].ToString()!="")
147                ...{
148                    ROLEID=int.Parse(ds.Tables[0].Rows[0]["ROLEID"].ToString());
149                }
150            }
151        }
152        /**//// <summary>
153        /// 获得数据列表
154        /// </summary>
155        public DataSet GetList(string strWhere)
156        ...{
157            StringBuilder strSql=new StringBuilder();
158            strSql.Append("select [USERID],[USERNAME],[PASSWORD],[ROLEID] ");
159            strSql.Append(" FROM [USER] ");
160            if(strWhere.Trim()!="")
161            ...{
162
163                strSql.Append(" where "+strWhere);
164            }
165            return DbHelperSQL.Query(strSql.ToString());
166        }
167
168        #endregion  成员方法
169}
170