private void SaveAdmin() { Response.Clear(); if (Request.Form["adminId"] != null && Request.Form["groupId"] != null && Request.Form["adminEmail"] != null && Request.Form["adminName"] != null && Request.Form["adminPass"] != null && Request.Form["adminPass2"] != null) { try { int id = Convert.ToInt32(Request.Form["adminId"]); int gid = Convert.ToInt32(Request.Form["groupId"]); string name = Request.Form["adminName"].Trim(); string email = Request.Form["adminEmail"].Trim(); string pass = Request.Form["adminPass"].Trim(); string pass2 = Request.Form["adminPass2"].Trim(); if (pass == pass2) { SysAdmin admin = new SysAdmin(gid); admin.Email = email; admin.Name = name; admin.Password = pass; if (admin.Save(id)) { Response.Write(id); } } } catch { // } } Response.End(); }
protected override void OnLoad(EventArgs e) { base.OnLoad(e); if (Request["id"] != null) { CurrentAdmin = SysAdmin.Get(Convert.ToInt32(Request["id"])); } if (CurrentAdmin == null) { CurrentAdmin = new SysAdmin(0); } if (IsPost) { switch (AjaxAction) { case "SysAdminPage.save": SaveAdmin(); break; } } }
/// <summary> /// ��ȡ�û��б� /// </summary> /// <param name="grpId">ָ����ID</param> /// <returns></returns> public static ArrayList List(int grpId) { /* SysAdminList @gpId int=0 */ //[Id], GroupId,GroupName,[Name], Email,LastLoginInfo ArrayList list = new ArrayList(); SqlParameter[] prams ={ Database.MakeInParam("@gpId",SqlDbType.Int,grpId) }; SqlDataReader reader = null; try { reader = Database.ExecuteReader(CommandType.StoredProcedure, "SysAdminList", prams); while (reader.Read()) { SysAdmin admin = new SysAdmin(); admin.id = reader.GetInt32(0); admin.groupId = reader.GetInt32(1); admin.groupName = reader.GetString(2); admin.name = reader.GetString(3); admin.email = reader.GetString(4); admin.lastLoginInfo = reader.GetString(5); list.Add(admin); } reader.Close(); } catch { // } finally { if (reader != null) { reader.Close(); } } return list; }
/// <summary> /// /// </summary> /// <param name="email">�ʼ���ַ</param> /// <param name="pass">����</param> /// <param name="vcode">��֤��</param> /// <returns>True/False,ͬ������Session</returns> public static bool Login(string email, string pass) { /* IsSysAdmin @email varchar(50), @pass char(32), @info varchar(100)='' */ if (String.IsNullOrEmpty(email) || String.IsNullOrEmpty(pass)) { return false; } bool bln = false; string info=Util.GetIP()+"\\n"+DateTime.Now.ToString(); SqlParameter[] prams ={ Database.MakeInParam("@email",SqlDbType.VarChar,50,email), Database.MakeInParam("@pass",SqlDbType.VarChar,50,Util.MD5(pass)), Database.MakeInParam("@info",SqlDbType.VarChar,100,info) }; SqlDataReader reader = null; try { /*[Id], GroupId, [Name], LastLoginInfo,GroupName,GroupRights*/ reader = Database.ExecuteReader(CommandType.StoredProcedure, "IsSysAdmin", prams); if (reader.Read()) { SysAdmin admin = new SysAdmin(); admin.id = reader.GetInt32(0); admin.groupId = reader.GetInt32(1); admin.name = reader.GetString(2); admin.email = email; admin.lastLoginInfo = reader.GetString(3); admin.groupName = reader.IsDBNull(4) ? "" : reader.GetString(4); admin.rights = reader.IsDBNull(5) ? SysAdminRights.Default : SysAdminRights.ConvertFromString(reader.GetString(5)) as SysAdminRights; Cookies.WriteCookie(_COOKIE_NAME, new string[] { "ID", "GROUPID", "NAME", "EMAIL", "LASTLOGININFO", "GROUPNAME", "RIGHTS" }, new string[] { admin.id.ToString(), admin.groupId.ToString(), admin.name, admin.email, admin.lastLoginInfo, admin.groupName, admin.rights.ConvertToString() }); bln = true; } reader.Close(); } catch { //throw; } finally { if (reader != null) { reader.Close(); } } return bln; }
/// <summary> /// ��ȡ�û� /// </summary> /// <param name="email">�û��ʼ�</param> /// <returns></returns> public static SysAdmin Get(string email) { /* SysAdminGet @id varchar(50) */ //[Id], GroupId, [Name], Email, LastLoginInfo,GroupName,GroupRights SysAdmin admin = null; SqlParameter[] prams ={ Database.MakeInParam("@id",SqlDbType.VarChar,50,email) }; SqlDataReader reader = null; try { reader = Database.ExecuteReader(CommandType.StoredProcedure, "SysAdminGet", prams); if (reader.Read()) { admin = new SysAdmin(); admin.id = reader.GetInt32(0); admin.groupId = reader.GetInt32(1); admin.name = reader.GetString(2); admin.email = reader.GetString(3); admin.lastLoginInfo = reader.GetString(4); admin.groupName = reader.IsDBNull(5) ? "" : reader.GetString(5); admin.rights = reader.IsDBNull(6) ? SysAdminRights.Default : SysAdminRights.ConvertFromString(reader.GetString(6)) as SysAdminRights; } reader.Close(); } catch (Exception e) { throw e; } finally { if (reader != null) { reader.Close(); } } return admin; }