/// <summary> /// 登录 /// </summary> /// <param name="account">帐号</param> /// <param name="password">密码</param> /// <returns>用户</returns> public User Login(string account, string password) { User result = null; UserHibernate hibernate = new UserHibernate(); User user = hibernate.SelectByAccount(account); if (user != null) { if ((user.Password == password) && (user.Validity)) { result = user; user.Authentication = true; } } else { int count = hibernate.Count(); if (count == 0) { result = new User(); result.Guid = "Prerogative"; result.Prerogative = true; result.Authentication = true; } } if ((result != null) && (result.Authentication)) { this.Refresh(result); } return result; }
public bool Delete(User value) { bool result = false; string sql = string.Format("delete from m_user_module as t where [t].[user_id] = '{0}'", value.Guid); List<Parameter> parameters = new List<Parameter>(); DatabaseHibernate hibernate = new DatabaseHibernate(); result = hibernate.Write(Variable.Link, sql, parameters); if (result) { sql = string.Format("delete from e_user_room as t where [t].[user_id] = '{0}'", value.Guid); parameters.Clear(); result = hibernate.Write(Variable.Link, sql, parameters); } if (result) { sql = string.Format("delete from m_user as t where [t].[guid] = '{0}'", value.Guid); parameters.Clear(); result = hibernate.Write(Variable.Link, sql, parameters); } return result; }
/// <summary> /// 增加 /// </summary> /// <param name="value">值</param> /// <returns>结果</returns> public bool Insert(User value) { bool result = false; UserHibernate hibernate = new UserHibernate(); result = hibernate.Insert(value); return result; }
public bool Delete(User value) { bool result = false; UserHibernate hibernate = new UserHibernate(); result = hibernate.Delete(value); return result; }
protected void ButtonOK_Click(object sender, EventArgs e) { bool done = false; StringBuilder stringBuilder = new StringBuilder(); UserBusiness business = new UserBusiness(); if (this.CheckBoxListUsers.Items != null) { List<User> users = new List<User>(); for (int i = 0; i < this.CheckBoxListUsers.Items.Count; i++) { if (this.CheckBoxListUsers.Items[i].Selected) { User user = new User(); user.Guid = this.CheckBoxListUsers.Items[i].Value; users.Add(user); } } if ((users != null) && (users.Count > 0)) { int success = 0; int fail = 0; for (int i = 0; i < users.Count; i++) { done = business.Delete(users[i]); if (done) { success++; } else { fail++; } } stringBuilder.Append(string.Format("删除{0}个用户成功!", success)); stringBuilder.Append(string.Format("删除{0}个用户失败!", fail)); } } this.LabelMessage.Text = stringBuilder.ToString(); this.InitializeBind(); }
protected void Session_Start(object sender, EventArgs e) { EnvironmentalMonitor.Support.Module.Manage.User user = new EnvironmentalMonitor.Support.Module.Manage.User(); user.Prerogative = false; this.Session.Add(Constant.SESSION_KEY_USER, user); }
/// <summary> /// 更新 /// </summary> /// <param name="value">值</param> /// <returns>结果</returns> public bool Update(User value) { bool result = false; string sql = string.Format("update m_user as t set [t].[update_user_id] = :update_user_id, [t].[update_time] = :update_time, [t].[remark] = :remark, [t].[validity] = :validity, [t].[name] = :name, [t].[account] = :account, [t].[password] = :password, [t].[prerogative] = :prerogative where [t].[guid] = '{0}'", value.Guid); List<Parameter> parameters = new List<Parameter>(); parameters.Add(new Parameter("update_user_id", DatabaseHibernate.Parameter(value.UpdateUserId))); parameters.Add(new Parameter("update_time", DatabaseHibernate.Parameter(value.UpdateTime))); parameters.Add(new Parameter("remark", DatabaseHibernate.Parameter(value.Remark))); parameters.Add(new Parameter("validity", DatabaseHibernate.Parameter(value.Validity))); parameters.Add(new Parameter("name", DatabaseHibernate.Parameter(value.Name))); parameters.Add(new Parameter("account", DatabaseHibernate.Parameter(value.Account.ToUpper()))); parameters.Add(new Parameter("password", DatabaseHibernate.Parameter(value.Password))); parameters.Add(new Parameter("prerogative", DatabaseHibernate.Parameter(value.Prerogative))); DatabaseHibernate hibernate = new DatabaseHibernate(); result = hibernate.Write(Variable.Link, sql, parameters); return result; }
/// <summary> /// 通过帐户查询 /// </summary> /// <param name="account">帐号</param> /// <returns>用户</returns> public User SelectByAccount(string account) { User result = null; string sql = string.Format("select {0} from m_user as t where ucase([t].[account]) = ucase(:account)", this.Asterisk("[t].")); List<Parameter> parameters = new List<Parameter>(); parameters.Add(new Parameter("account", DatabaseHibernate.Parameter(account))); DatabaseHibernate hibernate = new DatabaseHibernate(); List<object[]> values = hibernate.Read(Variable.Link, sql, parameters); if ((values != null) && (values.Count == 1)) { result = new User(); object[] moduleValues = values[0]; result = this.Parse(moduleValues); } return result; }
/// <summary> /// 通过主键查询 /// </summary> /// <param name="guid">主键</param> /// <returns>用户</returns> public User QueryByGuid(string guid) { User result = null; string sql = string.Format("select {0} from m_user as t where [t].[guid] = :guid", this.Asterisk("[t].")); List<Parameter> parameters = new List<Parameter>(); parameters.Add(new Parameter("guid", DatabaseHibernate.Parameter(guid))); DatabaseHibernate hibernate = new DatabaseHibernate(); List<object[]> values = hibernate.Read(Variable.Link, sql, parameters); if ((values != null) && (values.Count == 1)) { result = new User(); object[] moduleValues = values[0]; result = this.Parse(moduleValues); } return result; }
/// <summary> /// 解析数据 /// </summary> /// <param name="values">数据</param> /// <returns>用户</returns> public User Parse(object[] values) { User result = new User(); try { result = DatabaseHibernate.ParseModule(result, values) as User; result.Name = DatabaseHibernate.ParseString(values[7]); result.Account = DatabaseHibernate.ParseString(values[8]); result.Password = DatabaseHibernate.ParseString(values[9]); result.Prerogative = DatabaseHibernate.ParseBoolean(values[10]); } catch (Exception exception) { result = null; EnvironmentalMonitor.Support.Resource.Variable.Logger.Log(exception); } return result; }
/// <summary> /// 增加 /// </summary> /// <param name="value">值</param> /// <returns>结果</returns> public bool Insert(User value) { bool result = false; string sql = string.Format("insert into m_user ({0}) values (:guid, :insert_user_id, :insert_time, :update_user_id, :update_time, :remark, :validity, :name, :account, :password, :prerogative)", this.Asterisk("")); List<Parameter> parameters = new List<Parameter>(); parameters.Add(new Parameter("guid", DatabaseHibernate.Parameter(DatabaseHibernate.GUID()))); parameters.Add(new Parameter("insert_user_id", DatabaseHibernate.Parameter(value.InsertUserId))); parameters.Add(new Parameter("insert_time", DatabaseHibernate.Parameter(value.InsertTime))); parameters.Add(new Parameter("update_user_id", DatabaseHibernate.Parameter(value.UpdateUserId))); parameters.Add(new Parameter("update_time", DatabaseHibernate.Parameter(value.UpdateTime))); parameters.Add(new Parameter("remark", DatabaseHibernate.Parameter(value.Remark))); parameters.Add(new Parameter("validity", DatabaseHibernate.Parameter(value.Validity))); parameters.Add(new Parameter("name", DatabaseHibernate.Parameter(value.Name))); parameters.Add(new Parameter("account", DatabaseHibernate.Parameter(value.Account.ToUpper()))); parameters.Add(new Parameter("password", DatabaseHibernate.Parameter(value.Password))); parameters.Add(new Parameter("prerogative", DatabaseHibernate.Parameter(value.Prerogative))); DatabaseHibernate hibernate = new DatabaseHibernate(); result = hibernate.Write(Variable.Link, sql, parameters); return result; }
private void InitializeBind() { this.RefreshUser(); this.TextBoxName.Text = string.Empty; this.TextBoxAccount.Text = string.Empty; this.TextBoxPassword.Attributes["value"] = string.Empty; this.TextBoxRepassword.Attributes["value"] = string.Empty; User sessionUser = this.Session[Constant.SESSION_KEY_USER] as User; this.CheckBoxListRooms.DataSource = sessionUser.Rooms; this.CheckBoxListRooms.DataTextField = "Name"; this.CheckBoxListRooms.DataValueField = "Guid"; this.CheckBoxListRooms.DataBind(); this.CheckBoxListModules.DataSource = sessionUser.Catalogs; this.CheckBoxListModules.DataTextField = "Name"; this.CheckBoxListModules.DataValueField = "Code"; this.CheckBoxListModules.DataBind(); List<User> users = new List<User>(); User emptyUser = new User(); emptyUser.Guid = string.Empty; emptyUser.Name = string.Empty; emptyUser.Account = string.Empty; users.Add(emptyUser); users.AddRange(sessionUser.Users); this.DropDownListUsers.DataSource = users; this.DropDownListUsers.DataTextField = "AccountName"; this.DropDownListUsers.DataValueField = "Guid"; this.DropDownListUsers.DataBind(); }
public List<User> QueryByInsertUser(User value) { List<User> results = null; UserHibernate hibernate = new UserHibernate(); results = hibernate.QueryByInsertUser(value.Guid); return results; }
protected void ButtonOK_Click(object sender, EventArgs e) { bool done = false; StringBuilder stringBuilder = new StringBuilder(); UserBusiness business = new UserBusiness(); User module = new User(); this.InitializeInsertModule(module); module.Name = this.TextBoxName.Text; module.Account = this.TextBoxAccount.Text; module.Password = this.TextBoxPassword.Text; module.Prerogative = false; User user = business.QueryByAccount(module.Account); if (user == null) { done = business.Insert(module); if (done) { stringBuilder.Append("新增用户成功!"); } else { stringBuilder.Append("新增用户失败!"); } } else { stringBuilder.Append("用户已经存在(账户相同)!"); } if (done) { user = business.QueryByAccount(module.Account); if ((user != null) && (user.Guid != null)) { if (this.CheckBoxListRooms.Items != null) { List<UserRoom> userRooms = new List<UserRoom>(); for (int i = 0; i < this.CheckBoxListRooms.Items.Count; i++) { if (this.CheckBoxListRooms.Items[i].Selected) { UserRoom userRoom = new UserRoom(); this.InitializeInsertModule(userRoom); userRoom.UserId = user.Guid; userRoom.RoomId = this.CheckBoxListRooms.Items[i].Value; userRooms.Add(userRoom); } } UserRoomBusiness userRoomBusiness = new UserRoomBusiness(); done = userRoomBusiness.Refresh(user.Guid, userRooms); if (done) { stringBuilder.Append("更新机房成功!"); } else { stringBuilder.Append("更新机房失败!"); } } } if ((user != null) && (user.Guid != null)) { if (this.CheckBoxListModules.Items != null) { List<UserModule> userModules = new List<UserModule>(); for (int i = 0; i < this.CheckBoxListModules.Items.Count; i++) { if (this.CheckBoxListModules.Items[i].Selected) { UserModule userModule = new UserModule(); this.InitializeInsertModule(userModule); userModule.UserId = user.Guid; userModule.ModuleCode = this.CheckBoxListModules.Items[i].Value; userModules.Add(userModule); } } UserModuleBusiness userModuleBusiness = new UserModuleBusiness(); done = userModuleBusiness.Refresh(user.Guid, userModules); if (done) { stringBuilder.Append("更新权限成功!"); } else { stringBuilder.Append("更新权限失败!"); } } } } this.LabelMessage.Text = stringBuilder.ToString(); this.InitializeBind(); }
/// <summary> /// 验证页面 /// </summary> /// <param name="user">用户</param> /// <param name="pageName">页面类型</param> /// <returns>结果</returns> public bool VerifyPage(User user, Type pageType) { bool result = false; if (!result) { if (user.Prerogative) { result = user.Prerogative; } } if (!result) { object page = pageType.Assembly.CreateInstance(pageType.FullName); if (page != null) { PropertyInfo propertyInfo = pageType.GetProperty("Code"); if (propertyInfo != null) { object codeValue = propertyInfo.GetValue(page, null); if (codeValue != null) { string code = codeValue as string; if (code != null) { if (string.Equals(code, UserModule.DEFAULT_MODULE, StringComparison.CurrentCulture)) { result = true; } else { for (int i = 0; i < user.UserModules.Count; i++) { if (string.Equals(code, user.UserModules[i].ModuleCode, StringComparison.CurrentCulture)) { result = true; break; } } } } } } } } return result; }
public List<User> RefreshUsers(User value) { List<User> results = null; int total = 0; if (value.Prerogative) { results = this.Query(1, int.MaxValue, ref total); } else { results = this.QueryByInsertUser(value); } for (int i = results.Count - 1; i >= 0; i--) { if (string.Equals(value.Guid, results[i].Guid, StringComparison.CurrentCulture)) { results.RemoveAt(i); } } return results; }
public List<UserModule> RefreshUserModules(User value) { List<UserModule> results = null; if (value.Prerogative) { results = new List<UserModule>(); for (int i = 0; i < UserModule.Modules.Length; i++) { UserModule userModule = new UserModule(); userModule.ModuleCode = UserModule.Modules[i]; results.Add(userModule); } } else { UserModuleBusiness business = new UserModuleBusiness(); int total = 0; results = business.QueryByUser(1, int.MaxValue, ref total, value.Guid); } return results; }
public List<Room> RefreshRooms(User value) { List<Room> results = null; RoomHibernate roomHibernate = new RoomHibernate(); int total = 0; List<Room> rooms = roomHibernate.Query(1, int.MaxValue, ref total); if (value.Prerogative) { results = rooms; } else { UserRoomHiberante userRoomHiberante = new UserRoomHiberante(); List<UserRoom> userRooms = userRoomHiberante.QueryByUser(1, int.MaxValue, ref total, value.Guid); if ((userRooms != null) && (userRooms.Count > 0)) { if ((rooms != null) && (rooms.Count > 0)) { results = new List<Room>(); for (int i = 0; i < userRooms.Count; i++) { for (int j = 0; j < rooms.Count; j++) { if (string.Equals(userRooms[i].RoomId, rooms[j].Guid, StringComparison.CurrentCulture)) { results.Add(rooms[j]); break; } } } } } } return results; }
public void Refresh(User value) { value.Rooms = this.RefreshRooms(value); value.Users = this.RefreshUsers(value); value.UserModules = this.RefreshUserModules(value); if (value.UserModules != null) { value.Catalogs = new List<Catalog>(); List<UserModule> userModules = value.UserModules; for (int i = 0; i < userModules.Count; i++) { Catalog catalog = null; switch (userModules[i].ModuleCode) { case UserModule.MANAGE_MODULE: catalog = new Catalog(UserModule.MANAGE_MODULE, "用户管理", "#"); catalog.Catalogs = new List<Catalog>(); catalog.Catalogs.Add(new Catalog(UserModule.MANAGE_MODULE, "新增用户", string.Format("{0}Manages/Users/Insert.aspx", EnvironmentalMonitor.Support.Resource.Variable.VirtualRootPath))); catalog.Catalogs.Add(new Catalog(UserModule.MANAGE_MODULE, "修改用户", string.Format("{0}Manages/Users/Update.aspx", EnvironmentalMonitor.Support.Resource.Variable.VirtualRootPath))); catalog.Catalogs.Add(new Catalog(UserModule.MANAGE_MODULE, "删除用户", string.Format("{0}Manages/Users/Delete.aspx", EnvironmentalMonitor.Support.Resource.Variable.VirtualRootPath))); break; case UserModule.ROOM_MODULE: catalog = new Catalog(UserModule.ROOM_MODULE, "机房配置", "#"); catalog.Catalogs = new List<Catalog>(); catalog.Catalogs.Add(new Catalog(UserModule.ROOM_MODULE, "新增机房", string.Format("{0}Environmentals/Rooms/Insert.aspx", EnvironmentalMonitor.Support.Resource.Variable.VirtualRootPath))); catalog.Catalogs.Add(new Catalog(UserModule.ROOM_MODULE, "修改机房", string.Format("{0}Environmentals/Rooms/Update.aspx", EnvironmentalMonitor.Support.Resource.Variable.VirtualRootPath))); catalog.Catalogs.Add(new Catalog(UserModule.ROOM_MODULE, "删除机房", string.Format("{0}Environmentals/Rooms/Delete.aspx", EnvironmentalMonitor.Support.Resource.Variable.VirtualRootPath))); break; case UserModule.MACHINE_MODULE: catalog = new Catalog(UserModule.MACHINE_MODULE, "检测仪配置", "#"); catalog.Catalogs = new List<Catalog>(); catalog.Catalogs.Add(new Catalog(UserModule.MACHINE_MODULE, "新增检测仪", string.Format("{0}Environmentals/Machines/Insert.aspx", EnvironmentalMonitor.Support.Resource.Variable.VirtualRootPath))); catalog.Catalogs.Add(new Catalog(UserModule.MACHINE_MODULE, "修改检测仪", string.Format("{0}Environmentals/Machines/Update.aspx", EnvironmentalMonitor.Support.Resource.Variable.VirtualRootPath))); catalog.Catalogs.Add(new Catalog(UserModule.MACHINE_MODULE, "删除检测仪", string.Format("{0}Environmentals/Machines/Delete.aspx", EnvironmentalMonitor.Support.Resource.Variable.VirtualRootPath))); break; case UserModule.MACHINE_ADVANCED_MODULE: catalog = new Catalog(UserModule.MACHINE_ADVANCED_MODULE, "检测仪高级配置", "#"); catalog.Catalogs = new List<Catalog>(); catalog.Catalogs.Add(new Catalog(UserModule.MACHINE_ADVANCED_MODULE, "检测仪IP设置", string.Format("{0}Environmentals/Machines/SetupIp.aspx", EnvironmentalMonitor.Support.Resource.Variable.VirtualRootPath))); catalog.Catalogs.Add(new Catalog(UserModule.MACHINE_ADVANCED_MODULE, "检测仪物理地址设置", string.Format("{0}Environmentals/Machines/SetupMac.aspx", EnvironmentalMonitor.Support.Resource.Variable.VirtualRootPath))); break; case UserModule.DETECTOR_TYPE_MODULE: catalog = new Catalog(UserModule.DETECTOR_TYPE_MODULE, "探头类型配置", "#"); catalog.Catalogs = new List<Catalog>(); catalog.Catalogs.Add(new Catalog(UserModule.DETECTOR_TYPE_MODULE, "新增探头类型", string.Format("{0}Environmentals/DetectorTypes/Insert.aspx", EnvironmentalMonitor.Support.Resource.Variable.VirtualRootPath))); catalog.Catalogs.Add(new Catalog(UserModule.DETECTOR_TYPE_MODULE, "修改探头类型", string.Format("{0}Environmentals/DetectorTypes/Update.aspx", EnvironmentalMonitor.Support.Resource.Variable.VirtualRootPath))); catalog.Catalogs.Add(new Catalog(UserModule.DETECTOR_TYPE_MODULE, "删除探头类型", string.Format("{0}Environmentals/DetectorTypes/Delete.aspx", EnvironmentalMonitor.Support.Resource.Variable.VirtualRootPath))); break; case UserModule.DETECTOR_MODULE: catalog = new Catalog(UserModule.DETECTOR_MODULE, "探头配置", "#"); catalog.Catalogs = new List<Catalog>(); catalog.Catalogs.Add(new Catalog(UserModule.DETECTOR_MODULE, "新增探头", string.Format("{0}Environmentals/Detectors/Insert.aspx", EnvironmentalMonitor.Support.Resource.Variable.VirtualRootPath))); catalog.Catalogs.Add(new Catalog(UserModule.DETECTOR_MODULE, "修改探头", string.Format("{0}Environmentals/Detectors/Update.aspx", EnvironmentalMonitor.Support.Resource.Variable.VirtualRootPath))); catalog.Catalogs.Add(new Catalog(UserModule.DETECTOR_MODULE, "删除探头", string.Format("{0}Environmentals/Detectors/Delete.aspx", EnvironmentalMonitor.Support.Resource.Variable.VirtualRootPath))); break; case UserModule.ALARM_MODULE: catalog = new Catalog(UserModule.ALARM_MODULE, "报警设置", string.Format("{0}Environmentals/Machines/SetupAlarm.aspx", EnvironmentalMonitor.Support.Resource.Variable.VirtualRootPath)); break; case UserModule.MONITOR_MODULE: catalog = new Catalog(UserModule.MONITOR_MODULE, "监控模式", "#"); catalog.Catalogs = new List<Catalog>(); catalog.Catalogs.Add(new Catalog(UserModule.MONITOR_MODULE, "平面图配置", string.Format("{0}Environmentals/Monitors/FloorPlan.aspx", EnvironmentalMonitor.Support.Resource.Variable.VirtualRootPath))); catalog.Catalogs.Add(new Catalog(UserModule.MONITOR_MODULE, "实时监控", string.Format("{0}Environmentals/Monitors/Realtime.aspx", EnvironmentalMonitor.Support.Resource.Variable.VirtualRootPath))); break; case UserModule.QUERY_MODULE: catalog = new Catalog(UserModule.QUERY_MODULE, "查询模式", string.Format("{0}Environmentals/Querys/Default.aspx", EnvironmentalMonitor.Support.Resource.Variable.VirtualRootPath)); break; } if (catalog != null) { value.Catalogs.Add(catalog); } } } }