当前文件路径：mvcMemberShip/member/DalMember.cs

		            
  1using System;
  2using System.Data;
  3using System.Data.SqlClient;
  4using System.Collections.Generic;
  5using System.Text;
  6using System.Collections;
  7using Tmw.DBUtility;
  8/**//// Download from www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)
  9
 10namespace Tmw.Member
 11...{
 12    用户类#region 用户类
 13    public class DalUser
 14    ...{
 15        
 16        /**//// <summary>
 17        /// 检查是否存在相同用户
 18        /// </summary>
 19        /// <param name="userid">注册用户名</param>
 20        /// <returns></returns>
 21        public bool IsExitUser(string userid)
 22        ...{
 23            string query = "select userid from "+tables.table_membership+" where userid='"+userid+"'";
 24            //return (DbHelperSQL.RunSql(query) == "" || DbHelperSQL.RunSql(query) == null) ? false : true;
 25            return DbHelperSQL.Exists(query);
 26        }
 27        /**//// <summary>
 28        /// 检查是否存在相同电子邮件地址
 29        /// </summary>
 30        /// <param name="email"></param>
 31        /// <returns></returns>
 32        public bool IsExitEmail(string email)
 33        ...{
 34            string query = "select email from " + tables.table_membership + " where email='" + email + "'";
 35            //return (DbHelperSQL.RunSql(query) == "" || DbHelperSQL.RunSql(query) == null) ? false : true;
 36            return DbHelperSQL.Exists(query);
 37        }
 38        /**//// <summary>
 39        /// 添加用户
 40        /// </summary>
 41        /// <param name="ms"></param>
 42        public void AddUser(Memberships model)
 43        ...{
 44            string islock = (model.IsLock) ? "1" : "0";
 45            StringBuilder strSql = new StringBuilder();
 46            strSql.Append("insert into Star_MemberShip(");
 47            strSql.Append("UserId,UserName,Password,Email,PswQuestion,PswAnswer,CreateDate,IsLock");
 48            strSql.Append(")");
 49            strSql.Append(" values (");
 50            strSql.Append("'" + model.UserId + "',");
 51            strSql.Append("'" + model.UserName + "',");
 52            strSql.Append("'" + Code.encode(model.PassWord) + "',");
 53            strSql.Append("'" + model.Email + "',");
 54            strSql.Append("'" + model.PswQuestion + "',");
 55            strSql.Append("'" + model.PswAnswer + "',");
 56            strSql.Append("'" + model.CreateDate + "',");
 57            strSql.Append("" + islock + "");
 58            strSql.Append(")");
 59            string query = "insert into "+tables.table_userbase+"(UserId,RoleId) values('"+model.UserId+"','"+model.RoleId+"')";
 60            ArrayList mylist = new ArrayList();
 61            mylist.Add(query);
 62            mylist.Add(strSql.ToString());          
 63            DbHelperSQL.ExecuteSqlTran(mylist);
 64            //DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
 65        }
 66        /**//// <summary>
 67        /// 更新一条数据
 68        /// </summary>
 69        public void Update(Memberships model)
 70        ...{
 71            string query = "update " + tables.table_membership + " set UserName='" + model.UserName + "' where UserId='"+model.UserId+"'";
 72            ArrayList al = new ArrayList();
 73            al.Add("update " + tables.table_membership + " set UserName='" + model.UserName + "' where UserId='" + model.UserId + "' ");
 74            al.Add("update "+tables.table_userbase+" set roleid='"+model.RoleId+"' where userid='"+model.UserId+"'");
 75            DbHelperSQL.ExecuteSqlTran(al);
 76            //DbHelperSQL.ExecuteSql(query);
 77        }
 78        /**//// <summary>
 79        /// 修改用户密码
 80        /// </summary>
 81        /// <param name="newpsw">新密码</param>
 82        /// <param name="userid">用户ID</param>
 83        public void ChangePsw(string newpsw,string userid)
 84        ...{
 85            string query = "Update "+tables.table_membership+" Set Password = '"+newpsw+"' where UserId='"+userid+"'";
 86            DbHelperSQL.ExecuteSql(query);
 87        }
 88        /**//// <summary>
 89        /// 删除用户数据
 90        /// </summary>
 91        /// <param name="userid"></param>
 92        public void DelUser(string userid)
 93        ...{
 94            ArrayList mylist = new ArrayList();
 95            mylist.Add("Delete From "+tables.table_membership+" Where UserId='"+userid+"'");
 96            mylist.Add("Delete From "+tables.table_userbase+" Where UserId='"+userid+"'");
 97            DbHelperSQL.ExecuteSqlTran(mylist);
 98        }
 99        /**//// <summary>
100        /// 验证用户
101        /// </summary>
102        /// <param name="userid">用户ID</param>
103        /// <param name="psw">密码</param>
104        /// <returns></returns>
105        public DataTable ValidUser(string userid, string psw)
106        ...{
107            string psw1 = Code.encode(psw);
108            StringBuilder sb = new StringBuilder();
109            sb.Append("Select a.UserId,a.UserName,b.RoleId");
110            sb.Append(" From Star_MemberShip a");
111            sb.Append(" left join Star_UserBase b");
112            sb.Append(" on a.UserId=b.UserId");
113            sb.Append(" where a.UserId='"+userid+"' and a.Password='"+psw1+"'");
114            return DbHelperSQL.Query(sb.ToString()).Tables[0];
115        }
116        /**//// <summary>
117        /// 获取所有用户信息
118        /// </summary>
119        /// <returns></returns>
120        public DataTable GetAllUser()
121        ...{
122            StringBuilder sb = new StringBuilder();
123            sb.Append(" Select a.UserId,a.UserName,a.Email,c.rolename,c.roleid");
124            sb.Append(" from " + tables.table_membership + " a");
125            sb.Append(" left join " + tables.table_userbase + " b on a.userid=b.userid");
126            sb.Append(" left join  " + tables.table_role + " c on b.roleid=c.roleid");
127            return DbHelperSQL.Query(sb.ToString()).Tables[0];
128        }
129        /**//// <summary>
130        /// 获取指定用户信息
131        /// </summary>
132        /// <param name="UserId"></param>
133        /// <returns></returns>
134        public Memberships GetModel(string UserId)
135        ...{
136            StringBuilder strSql = new StringBuilder();
137            strSql.Append("Select a.UserId,a.UserName,a.Email,c.rolename,c.roleid ");
138            strSql.Append(" from " + tables.table_membership + " a");
139            strSql.Append(" left join " + tables.table_userbase + " b on a.userid=b.userid");
140            strSql.Append(" left join  " + tables.table_role + " c on b.roleid=c.roleid");
141            strSql.Append(" where a.UserId='" + UserId + "'");
142            Memberships model = new Memberships();
143            DataSet ds = DbHelperSQL.Query(strSql.ToString());
144            model.UserId = UserId;
145            if (ds.Tables[0].Rows.Count > 0)
146            ...{
147                model.UserId = ds.Tables[0].Rows[0]["UserId"].ToString();
148                model.UserName = ds.Tables[0].Rows[0]["UserName"].ToString();
149                model.RoleId = ds.Tables[0].Rows[0]["RoleId"].ToString();
150                return model;
151            }
152            else
153            ...{
154                return null;
155            }
156        }
157    }
158    #endregion
159
160    角色类#region 角色类
161    public class DalRole
162    ...{
163        /**//// <summary>
164        /// 是否存在相同角色
165        /// </summary>
166        /// <param name="RoleId"></param>
167        /// <returns></returns>
168        public bool IsExitRole(string RoleId)
169        ...{
170            StringBuilder strSql = new StringBuilder();
171            strSql.Append("select count(1) from "+tables.table_role);
172            strSql.Append(" where RoleId= @RoleId");
173            SqlParameter[] parameters = ...{
174                    new SqlParameter("@RoleId", SqlDbType.VarChar)
175                };
176            parameters[0].Value = RoleId;
177            return DbHelperSQL.Exists(strSql.ToString(), parameters);
178        }
179        /**//// <summary>
180        /// 增加一条角色数据
181        /// 同时要生成角色目录信息和角色权限信息
182        /// </summary>
183        public void AddRole(Model_Role model)
184        ...{
185            
186            StringBuilder strSql = new StringBuilder();
187            strSql.Append("insert into "+tables.table_role+"(");
188            strSql.Append("RoleId,RoleName,CreateDate,ReMark)");
189            strSql.Append(" values (");
190            strSql.Append("'"+model.RoleId+"','"+model.RoleName+"','"+model.CreateDate.ToString()+"','"+model.ReMark+"')");
191            string query1 = "insert into " + tables.table_menu + "(RoleId,MenuId,MenuName,MenuUrl,ParentId,MenuBj,Px,Display) select '"+model.RoleId+"',MenuId,MenuName,MenuUrl,ParentId,MenuBj,Px,Display from "+tables.table_menu+" where roleid='admins'";
192            string query2 = "Insert Into Star_RolePower(RoleId,ControlId,ControlName,IsView,IsAdd,IsEdit,IsDel,IsCheck,IsUnCheck) select '"+model.RoleId+"',ControlId,ControlName,IsView,IsAdd,IsEdit,IsDel,IsCheck,IsUnCheck From "+tables.table_rolepower+" where roleid='admins'";
193            ArrayList al = new ArrayList();
194            al.Add(strSql.ToString());
195            al.Add(query1);
196            al.Add(query2);
197            DbHelperSQL.ExecuteSqlTran(al);
198        }
199        /**//// <summary>
200        /// 修改角色信息
201        /// </summary>
202        /// <param name="model"></param>
203        public void EditRole(Model_Role model)
204        ...{
205            StringBuilder strSql = new StringBuilder();
206            strSql.Append("update "+tables.table_role+" set ");
207            strSql.Append("RoleName=@RoleName,");
208            strSql.Append("ReMark=@ReMark");
209            strSql.Append(" where RoleId=@RoleId");
210            SqlParameter[] parameters = ...{
211                    new SqlParameter("@RoleName", SqlDbType.VarChar,20),
212                    new SqlParameter("@ReMark", SqlDbType.VarChar,200)};
213            parameters[0].Value = model.RoleName;
214            parameters[1].Value = model.ReMark;
215            DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
216        }
217        public void EditRole(string rolename,string remark,string roleid)
218        ...{
219            StringBuilder strSql = new StringBuilder();
220            strSql.Append("update " + tables.table_role + " set ");
221            strSql.Append("RoleName='"+rolename+"',");
222            strSql.Append("ReMark='"+remark+"'");
223            strSql.Append(" where RoleId='"+roleid+"'");
224
225            DbHelperSQL.ExecuteSql(strSql.ToString());
226        }
227        /**//// <summary>
228        /// 删除角色信息
229        /// </summary>
230        /// <param name="RoleId">角色ID</param>
231        public void DelRole(string RoleId)
232        ...{
233            ArrayList rolelist = new ArrayList();
234            
235            rolelist.Add("delete " + tables.table_menu + " where RoleId='" + RoleId + "'");
236            rolelist.Add("delete " + tables.table_rolepower + " where RoleId='" + RoleId + "'");
237            rolelist.Add("delete " + tables.table_role + " where RoleId='" + RoleId + "'");
238