/// <summary> /// 分页获取指定公司下的所有角色列表 /// </summary> /// <param name="companyId">公司编号</param> /// <param name="pageSize">每页显示条数</param> /// <param name="pageIndex">当期页码</param> /// <param name="recordCount">总记录</param> /// <returns></returns> public virtual IList <EyouSoft.Model.CompanyStructure.CompanyUserRoles> GetList(string companyId, int pageSize, int pageIndex, ref int recordCount) { IList <EyouSoft.Model.CompanyStructure.CompanyUserRoles> list = new List <EyouSoft.Model.CompanyStructure.CompanyUserRoles>(); EyouSoft.Model.CompanyStructure.CompanyUserRoles model = null; string tableName = "tbl_CompanyRoles"; string fields = "[id],[RoleName],[IsAdminRole],[IssueTime]"; string primaryKey = "id"; string orderByString = "IssueTime DESC"; string strWhere = "IsDeleted=0"; if (!string.IsNullOrEmpty(companyId)) { strWhere = " companyId='" + companyId + "' "; } using (IDataReader dr = DbHelper.ExecuteReader(this._database, pageSize, pageIndex, ref recordCount, tableName, primaryKey, fields, strWhere, orderByString)) { while (dr.Read()) { model = new EyouSoft.Model.CompanyStructure.CompanyUserRoles(); model.ID = dr.GetString(0); model.RoleName = dr.GetString(1); model.IsAdminRole = dr.GetString(2) == "1"?true:false; model.IssueTime = dr.GetDateTime(3); list.Add(model); model = null; } } return(list); }
/// <summary> /// 修改一条公司角色 /// </summary> /// <param name="model">公司角色实体</param> /// <returns>false:失败 true:成功</returns> public bool Update(EyouSoft.Model.CompanyStructure.CompanyUserRoles model) { if (model == null) { return(false); } return(dal.Update(model)); }
protected void Page_Load(object sender, EventArgs e) { //是否登录 if (!IsLogin) { EyouSoft.Security.Membership.UserProvider.RedirectLoginOpenTopPage("/Default.aspx"); return; } if (!CheckGrant(TravelPermission.系统设置_权限管理)) { Utils.ResponseNoPermit(); return; } string roleid = Utils.GetQueryStringValue("roleid"); roleBll = EyouSoft.BLL.CompanyStructure.CompanyUserRoles.CreateInstance(); if (!Page.IsPostBack) { if (roleid != "") { roleModle = roleBll.GetModel(roleid); rs_txtRoleName.Value = roleModle.RoleName; perList = roleModle.PermissionList.Split(',').ToList <string>(); } BindPermit(); } else { bool isSuccess = true; if (!IsCompanyCheck) { MessageBox.Show(this, "对不起,你尚未审核通过!"); return; } if (roleid == "")//添加角色 { if (!AddPermit()) { isSuccess = false; } } else//修改角色 { if (!UpdatePermit(roleid)) { isSuccess = false; } } if (isSuccess) { Page.ClientScript.RegisterClientScriptBlock(this.GetType(), Guid.NewGuid().ToString(), "<script>;alert('操作完成!');window.parent.Boxy.getIframeDialog('" + Request.QueryString["iframeId"] + "').hide();window.parent.PermitManage.refresh();</script>"); } else { MessageBox.Show(this, "操作失败!"); } } }
protected bool AddPermit() { roleModle = new EyouSoft.Model.CompanyStructure.CompanyUserRoles(); roleModle.CompanyID = SiteUserInfo.CompanyID; roleModle.RoleName = Utils.InputText(Utils.GetFormValue(rs_txtRoleName.UniqueID), 20); roleModle.OperatorID = SiteUserInfo.ID; roleModle.PermissionList = Utils.GetFormValue("checkper"); return(roleBll.Add(roleModle)); }
protected bool UpdatePermit(string roleid) { roleModle = roleBll.GetModel(roleid); roleModle.RoleName = Utils.InputText(Utils.GetFormValue(rs_txtRoleName.UniqueID), 20); roleModle.OperatorID = SiteUserInfo.ID; roleModle.PermissionList = Utils.GetFormValue("checkper"); return(roleBll.Update(roleModle)); }
/// <summary> /// 修改一条公司角色 /// </summary> /// <param name="model">公司角色实体</param> /// <returns>false:失败 true:成功</returns> public virtual bool Update(EyouSoft.Model.CompanyStructure.CompanyUserRoles model) { DbCommand dc = this._database.GetSqlStringCommand(SQL_CompanyRoles_UPDATE); this._database.AddInParameter(dc, "RoleName", DbType.String, model.RoleName); this._database.AddInParameter(dc, "PermissionList", DbType.String, model.PermissionList); this._database.AddInParameter(dc, "OperatorID", DbType.String, model.OperatorID); this._database.AddInParameter(dc, "ID", DbType.AnsiStringFixedLength, model.ID); //this._database.AddInParameter(dc, "AreaList", DbType.String, model.AreaList); return(DbHelper.ExecuteSql(dc, this._database) > 0?true:false); //需要更新该角色下的所有用户权限列表 }
/// <summary> /// 添加一条公司角色 /// </summary> /// <param name="model">公司角色实体</param> /// <returns>false:失败 true:成功</returns> public virtual bool Add(EyouSoft.Model.CompanyStructure.CompanyUserRoles model) { DbCommand dc = this._database.GetSqlStringCommand(SQL_CompanyRoles_ADD); this._database.AddInParameter(dc, "id", DbType.AnsiStringFixedLength, Guid.NewGuid().ToString()); this._database.AddInParameter(dc, "RoleName", DbType.String, model.RoleName); this._database.AddInParameter(dc, "PermissionList", DbType.String, model.PermissionList); this._database.AddInParameter(dc, "IsAdminRole", DbType.String, model.IsAdminRole ? "1" : "0"); this._database.AddInParameter(dc, "CompanyID", DbType.String, model.CompanyID); this._database.AddInParameter(dc, "OperatorID", DbType.String, model.OperatorID); //this._database.AddInParameter(dc, "AreaList", DbType.String, model.AreaList); return(DbHelper.ExecuteSql(dc, this._database) > 0?true:false); }
/// <summary> /// 获取角色信息实体 /// </summary> /// <param name="id"></param> /// <returns></returns> public virtual EyouSoft.Model.CompanyStructure.CompanyUserRoles GetModel(string id) { EyouSoft.Model.CompanyStructure.CompanyUserRoles model = null; string sqlStr = SQL_CompanyRoles_SELECT + " where Id=@Id "; DbCommand dc = this._database.GetSqlStringCommand(sqlStr); this._database.AddInParameter(dc, "Id", DbType.AnsiStringFixedLength, id); using (IDataReader dr = DbHelper.ExecuteReader(dc, this._database)) { if (dr.Read()) { model = new EyouSoft.Model.CompanyStructure.CompanyUserRoles(); model.CompanyID = dr.GetString(dr.GetOrdinal("companyID")); model.ID = dr.GetString(dr.GetOrdinal("ID")); model.IsAdminRole = dr.GetString(dr.GetOrdinal("isAdminRole")) == "1" ? true : false; model.IssueTime = dr.GetDateTime(dr.GetOrdinal("issueTime")); model.OperatorID = dr.GetString(dr.GetOrdinal("operatorID")); model.PermissionList = dr.IsDBNull(dr.GetOrdinal("permissionList")) ? "" : dr.GetString(dr.GetOrdinal("permissionList")); model.RoleName = dr.IsDBNull(dr.GetOrdinal("roleName")) ? "" : dr.GetString(dr.GetOrdinal("roleName")); //model.AreaList = dr.GetString(dr.GetOrdinal("AreaList")); } } return(model); }