下面是获取用户的权限列表根据权限列表生产XML文件
下面代码如何改造成一个存储过程接受一个Psn_ID参数 生成xml文件 返回
- C# code
XmlDocument xmldoc = new XmlDocument();
StringBuilder sb = new StringBuilder();
var query = upl.OrderBy(o => o.Rig_RR_ID).ToList();
var query1 = (from o in kp.V_UserRight.Where(o => o.Psn_ID == wp[0].Psn_ID && o.RR_Flag == "启用" && o.UR_State == "启用")
group o by o.Rig_RR_ID into p
select new
{
p.Key,
RitList = (from q in query
where q.Rig_RR_ID == p.Key
group q by q.Group_ID into a
select new
{
a.Key,
RitList = query.Where(r => r.Group_ID == a.Key).ToList()
}).ToList()
}).ToList();
sb.Append(" <Ribbon>");
for (int i = 0; i < query1.Count; i++)