/// <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);
}
