public static string Getsys_subnavlistbyvirtualurl(string virtualurl, int viewcode, int groupid, string parastr)
{
IList <Sys_subnav> list = new Sys_subnavData().Getsys_subnavlistbyvirtualurl(virtualurl, viewcode, groupid, parastr);
if (list.Count == 0)
{
return(JsonConvert.SerializeObject(new { type = 1, msg = "" }));
}
else
{
return(JsonConvert.SerializeObject(new { type = 100, msg = list }));
}
}
public static string Upsubnavviewcode(int subnavid, int viewcode, int actionid, string groupids)
{
int r = new Sys_subnavData().Upsubnavviewcode(subnavid, viewcode, actionid, groupids);
if (r > 0)
{
return(JsonConvert.SerializeObject(new { type = 100, msg = "" }));
}
else
{
return(JsonConvert.SerializeObject(new { type = 1, msg = "" }));
}
}
public static string Getsys_subnav(string vurl, string parastr)
{
Sys_subnav r = new Sys_subnavData().Getsys_subnav(vurl, parastr);
if (r == null)
{
return(JsonConvert.SerializeObject(new { type = 1, msg = "" }));
}
else
{
return(JsonConvert.SerializeObject(new { type = 100, msg = r }));
}
}
public static string Upsubnavdatabase(int subnavid, int oldviewcode, int oldcolumnid, int oldactionid, string oldgroupids, int newviewcode, int newcolumnid, int newactionid)
{
int r = new Sys_subnavData().Upsubnavdatabase(subnavid, oldviewcode, oldcolumnid, oldactionid, oldgroupids, newviewcode, newcolumnid, newactionid);
if (r == 0)
{
return(JsonConvert.SerializeObject(new { type = 1, msg = "" }));
}
else
{
return(JsonConvert.SerializeObject(new { type = 100, msg = "" }));
}
}
public static string Getsyssubnav(int subnavid)
{
try
{
var m = new Sys_subnavData().Getsyssubnav(subnavid);
return(JsonConvert.SerializeObject(new { type = 100, msg = m }));
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(new { type = 1, msg = ex.Message }));
throw;
}
}
public static string Getallsys_subnavpagelist(int pageindex, int pagesize, int seled_columnid, int seled_actionid)
{
int totalcount = 0;
IList <Sys_subnav> list = new Sys_subnavData().Getallsys_subnavpagelist(pageindex, pagesize, out totalcount);
if (list != null)
{
if (list.Count == 0)
{
return(JsonConvert.SerializeObject(new { type = 1, msg = "" }));
}
else
{
IEnumerable r = "";
r = from m in list
select new
{
m.id,
m.subnav_name,
m.subnav_url,
m.actioncolumnid,
actioncolumnname = Getactioncolumnname(m.actioncolumnid),
m.actionid,
actionname = GetActionname(m.actionid),
m.viewcode,
//子导航在当前权限下面
isunderaction = GetIsunderaction(m.actioncolumnid, m.actionid, seled_columnid, seled_actionid),
m.sortid,
//子导航所在的管理组 的连接字符串
groupids = new Sys_groupactionsubnavData().GetGroupsByactionsubnavid(m.actionid, m.id)
};
return(JsonConvert.SerializeObject(new { type = 100, msg = r, totalcount = totalcount }));
}
}
else
{
return(JsonConvert.SerializeObject(new { type = 1, msg = "" }));
}
}
public static string Editsys_subnav(int id, int actionid, int columnid, string subnavurl, string subnavname)
{
//插入操作需要判断是否有重复的子导航(名字 或者 相对路径 相同)
if (id == 0)
{
int num = new Sys_subnavData().GetsubnavNum(subnavname, subnavurl);
if (num > 0)
{
return(JsonConvert.SerializeObject(new { type = 1, msg = "子导航在库中已经含有" }));
}
}
int r = new Sys_subnavData().Editsys_subnav(id, actionid, columnid, subnavurl, subnavname);
if (r == 0)
{
return(JsonConvert.SerializeObject(new { type = 1, msg = r }));
}
else
{
return(JsonConvert.SerializeObject(new { type = 100, msg = "" }));
}
}
public string groupname = ""; //管理组名称
protected void Page_Load(object sender, EventArgs e)
{
groupid = Request["groupid"].ConvertTo <string>("0");
Sys_Group group = new Sys_GroupData().GetGroupById(groupid.ConvertTo <int>(0));
groupname = group.Groupname;
//根据groupid得到管理组所拥有的权限
int listcount = 0;
IList <Sys_Action> actionlist = new Sys_ActionData().GetActionsByGroupdId(groupid, out listcount);
var ListSelectedActionId = new List <int>();
foreach (Sys_Action a in actionlist)
{
ListSelectedActionId.Add(a.Actionid);
}
treestr += "[";
//得到权限分栏表
int columncount = 0;
IList <Sys_ActionColumn> columns = new Sys_ActionColumnData().GetColumns(out columncount);
foreach (Sys_ActionColumn column in columns)
{
//判断权限分栏下如果没有权限，则不显示
int actionnum = new Sys_ActionData().GetActionNumByColumn(column.Actioncolumnid);
if (actionnum > 0)
{
int columnid = column.Actioncolumnid;
string columnname = column.Actioncolumnname;
treestr += "{id:" + columnid + ",pId:0,name:\"" + columnname + "\",open:true,nocheck:true},";
//得到权限分栏表下的权限列表
int actioncount = 0;
IList <Sys_Action> actions = new Sys_ActionData().GetActionsByColumnId(columnid, out actioncount);
foreach (Sys_Action action in actions)
{
int actionid = action.Actionid;
string actionname = action.Actionname;
string actionurl = action.Actionurl;
if (ListSelectedActionId.Contains(actionid))
{
treestr += "{id:" + actionid + ",pId:" + columnid + ",name:\"" + actionname + "\", checked: true},";
}
else
{
treestr += "{id:" + actionid + ",pId:" + columnid + ",name:\"" + actionname + "\"},";
}
//根据管理组、权限 得到右侧子导航(显示)--选中项
var ListSelectedsubnavId = new List <int>();
IList <Sys_groupactionsubnav> checked_slist = new Sys_groupactionsubnavData().GetSys_groupactionsubnav(action.Actionid, groupid);
if (checked_slist.Count > 0)
{
foreach (Sys_groupactionsubnav a in checked_slist)
{
ListSelectedsubnavId.Add(a.subnavid);
}
}
//根据权限 得到右侧子导航(显示)
int viewcode = 1;
IList <Sys_subnav> slist = new Sys_subnavData().GetSys_subnavbyactionid(action.Actionid, viewcode);
if (slist.Count > 0)
{
foreach (Sys_subnav m in slist)
{
int subnavid = m.id;
string subnavname = m.subnav_name;
if (ListSelectedsubnavId.Count > 0)
{
if (ListSelectedsubnavId.Contains(m.id))
{
treestr += "{id:" + subnavid + ",pId:" + action.Actionid + ",name:\"" + subnavname + "\", checked: true},";
}
else
{
treestr += "{id:" + subnavid + ",pId:" + action.Actionid + ",name:\"" + subnavname + "\"},";
}
}
else
{
treestr += "{id:" + subnavid + ",pId:" + action.Actionid + ",name:\"" + subnavname + "\"},";
}
}
}
}
}
}
treestr = treestr.Substring(0, treestr.Length - 1);
treestr += "]";
// treestr = @"[
// { id: 1, pId: 0, name: '随意勾选 1', open: true, nocheck:true },
// { id: 11, pId: 1, name: '随意勾选 1-1', open: true },
// { id: 111, pId: 11, name: '随意勾选 1-1-1' },
// { id: 112, pId: 11, name: '随意勾选 1-1-2' },
// { id: 12, pId: 1, name: '随意勾选 1-2', open: true },
// { id: 121, pId: 12, name: '随意勾选 1-2-1' },
// { id: 122, pId: 12, name: '随意勾选 1-2-2' },
// { id: 2, pId: 0, name: '随意勾选 2', checked: true, open: true },
// { id: 21, pId: 2, name: '随意勾选 2-1' },
// { id: 22, pId: 2, name: '随意勾选 2-2', open: true },
// { id: 221, pId: 22, name: '随意勾选 2-2-1', checked: true },
// { id: 222, pId: 22, name: '随意勾选 2-2-2' },
// { id: 23, pId: 2, name: '随意勾选 2-3' }
// ]";
}
