/// <summary>
/// 撤销字段权限
/// </summary>
/// <returns></returns>
public string cancelFiled()
{
string roleId = Request.Form["roleId"];
int menuId = helpcommon.ParmPerportys.GetNumParms(Request.Form["menuId"]);
int funId = helpcommon.ParmPerportys.GetNumParms(Request.Form["funId"]);
string filedId = Request.Form["filedId"];
if (filedId == null)
{
return("请选择需分配字段");
}
string[] filedIds = helpcommon.StrSplit.StrSplitData(filedId, ',');
string s = string.Empty;
List <model.personapermisson> list = new List <model.personapermisson>();
bll.personapermissonbll personapermissonBll = new bll.personapermissonbll();
for (int i = 0; i < filedIds.Length; i++)
{
if (!string.IsNullOrWhiteSpace(filedIds[i]))
{
var p = personapermissonBll.selectFiledIsExists1(helpcommon.ParmPerportys.GetNumParms(roleId), menuId, funId, helpcommon.ParmPerportys.GetNumParms(filedIds[i]));
if (p != null)
{
list.Add(p);
}
}
}
s = personapermissonBll.DelRolePersonapermisson(list);
personapermissonBll = null;
return(s);
}
/// <summary>
/// 分配功能权限
/// </summary>
/// <returns></returns>
public string allotFun()
{
string roleId = Request.Form["roleId"];
int menuId = helpcommon.ParmPerportys.GetNumParms(Request.Form["menuId"]);
string funId = Request.Form["funId"];
if (funId == null)
{
return("请选择需分配功能");
}
string[] funIds = helpcommon.StrSplit.StrSplitData(funId, ',');
string s = string.Empty;
List <model.personapermisson> list = new List <model.personapermisson>();
bll.personapermissonbll personapermissonBll = new bll.personapermissonbll();
for (int i = 0; i < funIds.Length; i++)
{
if (!string.IsNullOrWhiteSpace(funIds[i]))
{
model.personapermisson mdPersonapermisson = new model.personapermisson();
mdPersonapermisson.personaId = helpcommon.ParmPerportys.GetNumParms(roleId);
mdPersonapermisson.MemuId = menuId;
mdPersonapermisson.FunId = helpcommon.ParmPerportys.GetNumParms(funIds[i]);
if (!personapermissonBll.selectFunIsExists(helpcommon.ParmPerportys.GetNumParms(roleId), menuId, helpcommon.ParmPerportys.GetNumParms(funIds[i])))
{
list.Add(mdPersonapermisson);
}
}
}
s = personapermissonBll.AddRolePersonapermisson(list);
personapermissonBll = null;
return(s);
}
/// <summary>
/// 获取有权限的字段
/// </summary>
/// <param name="roleid">角色ID</param>
/// <param name="menuid">菜单ID</param>
/// <param name="funid">功能ID</param>
/// <returns>返回有权限的字段集合</returns>
public string[] getFiledPermisson(int roleid, int menuid, string funName)
{
bll.funPermissonbll funPermissonBll = new bll.funPermissonbll();
bll.personapermissonbll personapermissonBll = new bll.personapermissonbll();
int[] funIds = personapermissonBll.selectFunPersonaPermisson(roleid, menuid);
int funid = 0;
if (funIds.Length > 0)
{
for (int i = 0; i < funIds.Length; i++)
{
int myFunId = funPermissonBll.getFunName(helpcommon.ParmPerportys.GetNumParms(funIds[i])).Id;
string myFunName = funPermissonBll.getFunName(helpcommon.ParmPerportys.GetNumParms(funIds[i])).FunName;
if (!string.IsNullOrWhiteSpace(myFunName))
{
if (myFunName.Contains(funName))
{
funid = myFunId;
}
}
}
}
string[] filed = new string[] { };
int[] temp = personapermissonBll.selectFiledPersonaPermisson(roleid, menuid, funid);
bll.tableFiledPerssionbll tableFiledPerssionBll = new bll.tableFiledPerssionbll();
filed = tableFiledPerssionBll.getFiledName(temp);
personapermissonBll = null;
tableFiledPerssionBll = null;
return(filed);
}
/// <summary>
/// 获取有权限的字段
/// </summary>
/// <param name="roleId">角色ID</param>
/// <param name="menuId">菜单ID</param>
/// <param name="funName">功能操作</param>
/// <returns>返回sql语句（包含有权限的字段）</returns>
public string getFiledPermissonSQL(int roleId, int menuId, string funName, string tableName)
{
string sql = string.Empty;
PublicHelpController pub = new PublicHelpController();
bll.funPermissonbll funPermissonBll = new bll.funPermissonbll();
bll.personapermissonbll personapermissonBll = new bll.personapermissonbll();
int[] funIds = personapermissonBll.selectFunPersonaPermisson(roleId, menuId);
int funId = 0;
if (funIds.Length > 0)
{
for (int i = 0; i < funIds.Length; i++)
{
int myFunId = funPermissonBll.getFunName(helpcommon.ParmPerportys.GetNumParms(funIds[i])).Id;
string myFunName = funPermissonBll.getFunName(helpcommon.ParmPerportys.GetNumParms(funIds[i])).FunName;
if (!string.IsNullOrWhiteSpace(myFunName))
{
if (myFunName.Contains(funName))
{
funId = myFunId;
}
}
}
}
sql = pub.getFiledPermissonSQL(roleId, menuId, funId, tableName);
funPermissonBll = null;
personapermissonBll = null;
return(sql);
}
/// <summary>
/// 是否存在功能管理权限
/// </summary>
/// <param name="menuId">菜单ID</param>
/// <param name="permissonName">权限-功能名称</param>
/// <returns></returns>
public bool isFunPermisson(int roleId, int menuId, string permissonName)
{
bool flag = false;
string s = string.Empty;
List <int> list1 = new List <int>();
list1.Add(menuId);
bll.personapermissonbll personapermissonBll = new bll.personapermissonbll();
List <int> list = getUserFun1(list1, roleId);
foreach (int item in list)
{
string funName = getFunName(item);
if (!string.IsNullOrWhiteSpace(funName))
{
bool flg1 = funName.Contains(permissonName.Trim());
if (funName.Contains(permissonName))
{
flag = true;
}
}
}
personapermissonBll = null;
return(flag);
}
//public void AddLog(errorlog log)
//{
// string s = string.Empty;
// bll.Errorlogbll errorBll = new bll.Errorlogbll(out s);
// log.ErrorMsg = s;
// errorBll.InsertErrorlog(log);
// errorBll = null;
//}
#endregion
#region 返回有权限的字段(sql语句或字段集合)
/// <summary>
/// 获取有权限的字段
/// </summary>
/// <param name="roleid">角色ID</param>
/// <param name="menuid">菜单ID</param>
/// <param name="funid">功能ID</param>
/// <returns>返回sql语句（包含有权限的字段）</returns>
public string getFiledPermissonSQL(int roleid, int menuid, int funid, string tableName)
{
string sql = string.Empty;
bll.personapermissonbll personapermissonBll = new bll.personapermissonbll();
int[] temp = personapermissonBll.selectFiledPersonaPermisson(roleid, menuid, funid);
bll.tableFiledPerssionbll tableFiledPerssionBll = new bll.tableFiledPerssionbll();
sql = tableFiledPerssionBll.getFiledPermissionSQL(temp, tableName);
personapermissonBll = null;
tableFiledPerssionBll = null;
return(sql);
}
