/// <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>
public string DeletetableFiled()
{
string Id = Request.QueryString["Id"].ToString();
bll.tableFiledPerssionbll bll = new bll.tableFiledPerssionbll();
return(bll.DeletetableFiled(Id, userInfo.User.Id));;
}
/// <summary>
/// 功能权限控制
/// </summary>
/// <param name="listMenuIdC"></param>
/// <param name="roleId"></param>
/// <returns></returns>
public List <int> getUserFiled(int roleId, int menuId, int funId)
{
string s = string.Empty;
IDataParameter[] iparaFiled = new IDataParameter[] {
new SqlParameter("roleId", SqlDbType.Int, 4),
new SqlParameter("menuId", SqlDbType.Int, 4),
new SqlParameter("funId", SqlDbType.Int, 4)
};
iparaFiled[0].Value = roleId;
iparaFiled[1].Value = menuId;
iparaFiled[2].Value = funId;
bll.tableFiledPerssionbll tableFiledPerssionBll = new bll.tableFiledPerssionbll();
List <model.tableFiledPerssion> list = tableFiledPerssionBll.getTable(iparaFiled, "tableFiledSelect");
List <int> listFiledId = new List <int>(); //功能ID
foreach (var item in list)
{
listFiledId.Add(item.Id);
}
if (listFiledId.Count == 0)
{
listFiledId.Add(9999);
}
return(listFiledId);
}
/// <summary>
/// 修改表名,列名
/// </summary>
public string UpdateTabName()
{
string Id = Request.QueryString["Id"].ToString();
string Descript = Request.QueryString["Descript"].ToString();
bll.tableFiledPerssionbll bll = new bll.tableFiledPerssionbll();
return(bll.UpdateTabName(Id, Descript));;
}
/// <summary>
/// 添加字段描述,添加表描述tableFiledPerssion表
/// </summary>
public string AddDescript()
{
string Id = Request.QueryString["Id"].ToString();
string Descript = Request.QueryString["Descript"].ToString();
bll.tableFiledPerssionbll bll = new bll.tableFiledPerssionbll();
return(bll.AddDescript(Id, Descript));
}
/// <summary>
/// 添加表格列表
/// </summary>
public string AddTable()
{
string TabName = Request.QueryString["TabName"].ToString();
bll.tableFiledPerssionbll tableFiledPerssionBll = new bll.tableFiledPerssionbll();
//return Content("123");
return(tableFiledPerssionBll.AddTabName(TabName, userInfo.User.Id));
}
/// <summary>
/// 添加列
/// </summary>
public string AddFiled()
{
string tableName = Request.QueryString["tableName"].ToString();
string tableLevel = Request.QueryString["tableLevel"].ToString();
bll.tableFiledPerssionbll tableFiledPerssionBll = new bll.tableFiledPerssionbll();
//return Content("123");
return(tableFiledPerssionBll.AddFiledName(tableName, tableLevel, userInfo.User.Id));
}
/// <summary>
/// 获取表格信息
/// </summary>
/// <returns></returns>
public ActionResult getTable()
{
bll.tableFiledPerssionbll tableFiledPerssionBll = new bll.tableFiledPerssionbll();
IDataParameter[] ipara = new IDataParameter[] {
//new SqlParameter("menuName",SqlDbType.NVarChar,20)
};
//ipara[0].Value = "张三";
List <model.tableFiledPerssion> list = tableFiledPerssionBll.getTable(ipara, "tableSelect");
return(View(list));
}
/// <summary>
/// 获取字段列表
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult allotFiledPermisson(int id, int roleId, int menuId, int funId)
{
ViewData["id"] = id;
ViewData["roleId"] = roleId;
ViewData["menuId"] = menuId;
ViewData["funId"] = funId;
PublicHelpController ph = new PublicHelpController();
if (userInfo.User.userName == "sa")
{
funName f = new funName();
System.Reflection.MemberInfo[] properties = f.GetType().GetMembers();
foreach (System.Reflection.MemberInfo item in properties)
{
string value = item.Name;
ViewData[value] = 1;
}
}
else
{
#region 分配权限
if (!ph.isFunPermisson(int.Parse(userInfo.User.personaId.ToString()), menuId, funName.fieldFPQX))
{
ViewData["fieldFPQX"] = 0;//无分配权限
}
else
{
ViewData["fieldFPQX"] = 1;//有分配权限
}
#endregion
#region 查询
if (!ph.isFunPermisson(int.Parse(userInfo.User.personaId.ToString()), menuId, funName.fieldCKQX))
{
List <model.persona> myList = new List <model.persona>();
return(View("../NoPermisson/Index"));
}
#endregion
}
string filed = getFiledId(roleId, menuId, funId);
ViewData["filedIds"] = filed;
bll.tableFiledPerssionbll tableFiledPerssionBll = new bll.tableFiledPerssionbll();
IDataParameter[] ipara = new IDataParameter[] {
new SqlParameter("tableLevel", SqlDbType.NVarChar, 20)
};
ipara[0].Value = id;
List <model.tableFiledPerssion> list = tableFiledPerssionBll.getTable(ipara, "filedSelect");
return(View(list));
}
/// <summary>
/// 获取表格字段信息
/// </summary>
/// <returns></returns>
public ActionResult getFiled(int id)
{
bll.tableFiledPerssionbll tableFiledPerssionBll = new bll.tableFiledPerssionbll();
IDataParameter[] ipara = new IDataParameter[] {
new SqlParameter("tableLevel", SqlDbType.NVarChar, 20)
};
ipara[0].Value = id;
List <model.tableFiledPerssion> list = tableFiledPerssionBll.getTable(ipara, "filedSelect");
return(View(list));
}
/// <summary>
/// 获取表格列表
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult allotTablePermisson(int id, int roleId, int menuId)
{
ViewData["roleId"] = roleId;
ViewData["menuId"] = menuId;
ViewData["funId"] = id;
bll.tableFiledPerssionbll tableFiledPerssionBll = new bll.tableFiledPerssionbll();
IDataParameter[] ipara = new IDataParameter[] {
//new SqlParameter("menuName",SqlDbType.NVarChar,20)
};
//ipara[0].Value = "张三";
List <model.tableFiledPerssion> list = tableFiledPerssionBll.getTable(ipara, "tableSelect");
return(View(list));
}
//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);
}
public void getUserFiled(List <int> listMenuIdC, List <int> listFunId)
{
string s = string.Empty;
foreach (int item in listMenuIdC)
{
s += item + ",";
}
s = s.Length > 0 ? s.Remove(s.Length - 1, 1) : s;
string s1 = string.Empty;
foreach (int item in listFunId)
{
s1 += item + ",";
}
s1 = s1.Length > 0 ? s1.Remove(s1.Length - 1, 1) : s1;
IDataParameter[] iparaFiled = new IDataParameter[] {
new SqlParameter("roleId", SqlDbType.Int, 4),
new SqlParameter("menuId", SqlDbType.NVarChar, 5000),
new SqlParameter("funId", SqlDbType.NVarChar, 5000),
};
iparaFiled[0].Value = us.User.personaId;
iparaFiled[1].Value = s;
iparaFiled[2].Value = s1;
List <int> listFiledId = new List <int>();
model.tableFiledPerssion filedMd = new model.tableFiledPerssion();
bll.tableFiledPerssionbll filedBll = new bll.tableFiledPerssionbll();
List <model.tableFiledPerssion> listFiled = filedBll.getTable(iparaFiled, "tableFiledSelect");
foreach (var item in listFiled)
{
listFiledId.Add(item.Id);
}
if (listFiled.Count == 0)
{
listFiledId.Add(9999);
}
us.FiledId = listFiledId;
}
/// <summary>
/// 显示字段
/// </summary>
/// <returns></returns>
public string filedShow()
{
string filedId = Request.Form["filedId"].ToString();
filedId = filedId.Length > 0 ? filedId.Remove(filedId.Length - 1, 1) : filedId;
if (string.IsNullOrWhiteSpace(filedId))
{
return("请选择");
}
string s = string.Empty;
bll.tableFiledPerssionbll tableFiledPerssionBll = new bll.tableFiledPerssionbll();
IDataParameter[] ipara = new IDataParameter[] {
new SqlParameter("tableNameState", SqlDbType.NVarChar, 200)
};
ipara[0].Value = filedId;
s = tableFiledPerssionBll.Update(ipara, "filedShow");
return(s);
}
