提交 | 用户 | 时间
|
e46d3b
|
1 |
using System; |
懒 |
2 |
using System.Collections.Generic; |
|
3 |
using System.Linq; |
|
4 |
using System.Text; |
|
5 |
using System.Data; |
|
6 |
using System.Data.SqlClient; |
|
7 |
using YX.Entity; |
|
8 |
using System.Data.Entity; |
|
9 |
using System.Linq.Expressions; |
|
10 |
namespace YX.DAL |
|
11 |
{ |
|
12 |
public class SystemMenu_Dal |
|
13 |
{ |
|
14 |
|
|
15 |
///// <summary> |
|
16 |
///// 获取子节点 |
|
17 |
///// </summary> |
|
18 |
///// <returns></returns> |
|
19 |
//public DataTable GetSysMenuChilds(string ParentId) |
|
20 |
//{ |
|
21 |
// DataTable dt = null; |
|
22 |
// try |
|
23 |
// { |
|
24 |
// using (Sam_DBEntities db=new Sam_DBEntities()) |
|
25 |
// { |
|
26 |
// string sql = @"SELECT |
|
27 |
// Menu_Id |
|
28 |
// ,[Menu_Name] as '菜单名称' |
|
29 |
// ,[Menu_Tag] as '菜单标记' |
|
30 |
// ,[Menu_Img] as '菜单图标' |
|
31 |
// ,case[ParentId] when '0'then '父节' else '子节'end as '节点位置' |
|
32 |
// ,[SortCode] as '菜单排序' |
|
33 |
// ,[CreateDate] as'创建时间' |
|
34 |
// ,[CreateUserName] as'创建人' |
|
35 |
// ,[ModifyDate] as '修改时间' |
|
36 |
// ,[ModifyUserName] as'修改人' |
|
37 |
// FROM [Base_SysMenu]WHERE ParentId=@ParentId |
|
38 |
// order by sortcode asc"; |
|
39 |
// SqlParameter[] par = new SqlParameter[] |
|
40 |
// { |
|
41 |
// new SqlParameter("@ParentId", ParentId) |
|
42 |
// }; |
|
43 |
// dt = SqlHelper.ExecuteDataset(db.Database.Connection.ConnectionString, CommandType.Text, sql, par).Tables[0]; |
|
44 |
// } |
|
45 |
|
|
46 |
// } |
|
47 |
// catch (Exception ex) |
|
48 |
// { |
|
49 |
|
|
50 |
// throw ex; |
|
51 |
// } |
|
52 |
// return dt; |
|
53 |
//} |
|
54 |
public List<Base_SysMenu> GetMenusByCondition(Expression<Func<Base_SysMenu, bool>> lambda) |
|
55 |
{ |
|
56 |
List<Base_SysMenu> list = new List<Base_SysMenu>(); |
|
57 |
using (Sam_DBEntities db = new Sam_DBEntities()) |
|
58 |
{ |
|
59 |
list = db.Base_SysMenu.Where(lambda).ToList(); |
|
60 |
} |
|
61 |
return list; |
|
62 |
} |
|
63 |
/// <summary> |
|
64 |
/// 用户权限查询 |
|
65 |
/// </summary> |
|
66 |
/// <param name="lambda"></param> |
|
67 |
/// <returns></returns> |
|
68 |
public List<Base_UserRight> GetUserRightByCondition(Expression<Func<Base_UserRight, bool>> lambda) |
|
69 |
{ |
|
70 |
try |
|
71 |
{ |
|
72 |
using (Sam_DBEntities db = new Sam_DBEntities()) |
|
73 |
{ |
|
74 |
return db.Base_UserRight.Where(lambda).ToList(); ; |
|
75 |
} |
|
76 |
|
|
77 |
} |
|
78 |
catch (Exception EX) |
|
79 |
{ |
|
80 |
|
|
81 |
throw EX; |
|
82 |
} |
|
83 |
} |
|
84 |
/// <summary> |
|
85 |
/// 角色权限查询 |
|
86 |
/// </summary> |
|
87 |
/// <param name="lambda"></param> |
|
88 |
/// <returns></returns> |
|
89 |
public List<Base_RoleRight> GetRoleRightByCondition(Expression<Func<Base_RoleRight, bool>> lambda) |
|
90 |
{ |
|
91 |
try |
|
92 |
{ |
|
93 |
using (Sam_DBEntities db = new Sam_DBEntities()) |
|
94 |
{ |
|
95 |
return db.Base_RoleRight.Where(lambda).ToList(); ; |
|
96 |
} |
|
97 |
|
|
98 |
} |
|
99 |
catch (Exception EX) |
|
100 |
{ |
|
101 |
|
|
102 |
throw EX; |
|
103 |
} |
|
104 |
} |
|
105 |
/// <summary> |
|
106 |
/// 获取全部菜单 |
|
107 |
/// </summary> |
|
108 |
/// <returns></returns> |
|
109 |
public List<Base_SysMenu> GetSysMenus() |
|
110 |
{ |
|
111 |
|
|
112 |
try |
|
113 |
{ |
|
114 |
//DataTable dt = dal.GetParent(); |
|
115 |
//list = DataTableToModel.GetEntities<Base_SysMenu>(dt).ToList(); |
|
116 |
using (Sam_DBEntities db = new Sam_DBEntities()) |
|
117 |
{ |
|
118 |
return db.Base_SysMenu.ToList(); |
|
119 |
} |
|
120 |
|
|
121 |
} |
|
122 |
catch (Exception ex) |
|
123 |
{ |
|
124 |
|
|
125 |
throw ex; |
|
126 |
} |
|
127 |
|
|
128 |
} |
|
129 |
/// <summary> |
|
130 |
/// 获取菜单根节点 |
|
131 |
/// </summary> |
|
132 |
/// <returns></returns> |
|
133 |
public List<Base_SysMenu> GetSysMenusParent(string UserID) |
|
134 |
{ |
|
135 |
try |
|
136 |
{ |
|
137 |
using (Sam_DBEntities db = new Sam_DBEntities()) |
|
138 |
{ |
|
139 |
var query = (from menuinfo in db.Base_SysMenu |
|
140 |
join userright in db.Base_UserRight |
|
141 |
on menuinfo.Menu_Id equals userright.Menu_Id |
|
142 |
where menuinfo.ParentId == "0" && userright.Base_UserInfo.User_ID == UserID |
|
143 |
orderby menuinfo.SortCode ascending |
|
144 |
select menuinfo).Union(from M in db.Base_SysMenu |
|
145 |
join R_R in db.Base_RoleRight on M.Menu_Id equals R_R.Menu_Id |
|
146 |
join U_R in db.Base_UserRole on R_R.Base_Roles.Roles_ID equals U_R.Roles_ID |
|
147 |
where M.ParentId == "0" && U_R.Base_UserInfo.User_ID == UserID |
|
148 |
orderby M.SortCode ascending |
|
149 |
select M); |
|
150 |
//var sql = query.ToString(); |
|
151 |
return query.ToList(); ; |
|
152 |
} |
|
153 |
|
|
154 |
} |
|
155 |
catch (Exception ex) |
|
156 |
{ |
|
157 |
|
|
158 |
throw ex; |
|
159 |
} |
|
160 |
} |
|
161 |
/// <summary> |
|
162 |
/// 获取菜单子节点 |
|
163 |
/// </summary> |
|
164 |
/// <param name="ParentId"></param> |
|
165 |
/// <returns></returns> |
|
166 |
public List<Base_SysMenu> GetSysMenuChilds(string ParentId, string UserID) |
|
167 |
{ |
|
168 |
try |
|
169 |
{ |
|
170 |
using (Sam_DBEntities db = new Sam_DBEntities()) |
|
171 |
{ |
|
172 |
var query = (from menuinfo in db.Base_SysMenu |
|
173 |
join userright in db.Base_UserRight |
|
174 |
on menuinfo.Menu_Id equals userright.Menu_Id |
|
175 |
where menuinfo.ParentId == ParentId && userright.Base_UserInfo.User_ID == UserID |
|
176 |
|
|
177 |
select menuinfo).Union(from M in db.Base_SysMenu |
|
178 |
join R_R in db.Base_RoleRight on M.Menu_Id equals R_R.Menu_Id |
|
179 |
join U_R in db.Base_UserRole on R_R.Base_Roles.Roles_ID equals U_R.Roles_ID |
|
180 |
where M.ParentId==ParentId && U_R.Base_UserInfo.User_ID==UserID |
|
181 |
|
|
182 |
select M).OrderBy(o=>o.SortCode); |
|
183 |
return query.ToList(); ; |
|
184 |
// return db.Base_SysMenu.Where(o=>o.ParentId==ParentId).ToList(); |
|
185 |
} |
|
186 |
} |
|
187 |
catch (Exception ex) |
|
188 |
{ |
|
189 |
|
|
190 |
throw ex; |
|
191 |
} |
|
192 |
|
|
193 |
} |
|
194 |
/// <summary> |
|
195 |
/// 获取菜单子节点 |
|
196 |
/// </summary> |
|
197 |
/// <param name="ParentId"></param> |
|
198 |
/// <returns></returns> |
|
199 |
public List<Base_SysMenu> GetSysMenuChilds(string ParentId) |
|
200 |
{ |
|
201 |
try |
|
202 |
{ |
|
203 |
using (Sam_DBEntities db = new Sam_DBEntities()) |
|
204 |
{ |
|
205 |
var query = (from menuinfo in db.Base_SysMenu |
|
206 |
where menuinfo.ParentId == ParentId |
|
207 |
select menuinfo).OrderBy(o => o.SortCode); |
|
208 |
return query.ToList(); ; |
|
209 |
// return db.Base_SysMenu.Where(o=>o.ParentId==ParentId).ToList(); |
|
210 |
} |
|
211 |
} |
|
212 |
catch (Exception ex) |
|
213 |
{ |
|
214 |
|
|
215 |
throw ex; |
|
216 |
} |
|
217 |
|
|
218 |
} |
|
219 |
/// <summary> |
|
220 |
/// 添加菜单 |
|
221 |
/// </summary> |
|
222 |
/// <param name="info"></param> |
|
223 |
public int AddSysMenu(Base_SysMenu info) |
|
224 |
{ |
|
225 |
try |
|
226 |
{ |
|
227 |
using (Sam_DBEntities db = new Sam_DBEntities()) |
|
228 |
{ |
|
229 |
db.Base_SysMenu.Add(info); |
|
230 |
return db.SaveChanges(); |
|
231 |
} |
|
232 |
} |
|
233 |
catch (Exception) |
|
234 |
{ |
|
235 |
|
|
236 |
throw; |
|
237 |
} |
|
238 |
} |
|
239 |
/// <summary> |
|
240 |
/// 修改菜单 |
|
241 |
/// </summary> |
|
242 |
/// <param name="info"></param> |
|
243 |
/// <returns></returns> |
|
244 |
public int UpdateSysMenu(Base_SysMenu info) |
|
245 |
{ |
|
246 |
try |
|
247 |
{ |
|
248 |
using (Sam_DBEntities db = new Sam_DBEntities()) |
|
249 |
{ |
|
250 |
db.Base_SysMenu.Attach(info); |
|
251 |
//把当前实体的状态改为Modified |
|
252 |
db.Entry(info).State = EntityState.Modified; |
|
253 |
return db.SaveChanges(); |
|
254 |
} |
|
255 |
} |
|
256 |
catch (Exception) |
|
257 |
{ |
|
258 |
|
|
259 |
throw; |
|
260 |
} |
|
261 |
} |
|
262 |
/// <summary> |
|
263 |
/// 删除菜单 |
|
264 |
/// </summary> |
|
265 |
/// <param name="key"></param> |
|
266 |
/// <returns></returns> |
|
267 |
public int DeleteSysMenu(string key) |
|
268 |
{ |
|
269 |
try |
|
270 |
{ |
|
271 |
using (Sam_DBEntities db = new Sam_DBEntities()) |
|
272 |
{ |
|
273 |
var obj = new Base_SysMenu { Menu_Id = key }; |
|
274 |
db.Base_SysMenu.Attach(obj); |
|
275 |
db.Base_SysMenu.Remove(obj); |
|
276 |
return db.SaveChanges(); |
|
277 |
} |
|
278 |
} |
|
279 |
catch (Exception) |
|
280 |
{ |
|
281 |
|
|
282 |
throw; |
|
283 |
} |
|
284 |
} |
|
285 |
//获取按钮 |
|
286 |
public List<Base_SysMenu> GetButtonList(string ParentId, string UserID) |
|
287 |
{ |
|
288 |
try |
|
289 |
{ |
|
290 |
using (Sam_DBEntities db = new Sam_DBEntities()) |
|
291 |
{ |
|
292 |
var query = (from a in db.Base_SysMenu |
|
293 |
join b in db.Base_UserRight |
|
294 |
on a.Menu_Id equals b.Menu_Id |
|
295 |
where a.ParentId == ParentId &&b.Base_UserInfo.User_ID==UserID |
|
296 |
select a).Union(from M in db.Base_SysMenu |
|
297 |
join R_R in db.Base_RoleRight on M.Menu_Id equals R_R.Menu_Id |
|
298 |
join U_R in db.Base_UserRole on R_R.Base_Roles.Roles_ID equals U_R.Roles_ID |
|
299 |
where M.ParentId == ParentId && U_R.Base_UserInfo.User_ID == UserID |
|
300 |
orderby M.SortCode ascending |
|
301 |
select M); |
|
302 |
return query.ToList(); |
|
303 |
//return db.Base_SysMenu.Where(o => o.ParentId == MenuID && o.Menu_Type == 3).ToList() ; |
|
304 |
} |
|
305 |
} |
|
306 |
catch (Exception) |
|
307 |
{ |
|
308 |
|
|
309 |
throw; |
|
310 |
} |
|
311 |
} |
|
312 |
} |
|
313 |
} |