SysRevelanceApp.cs
7.29 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
using System;
using System.Collections.Generic;
using System.Linq;
using WebRepository;
namespace WebApp
{
public class SysRevelanceApp : WebApp<SysRelevance>
{
public SysRevelanceApp(IUnitWork unitWork, IRepository<SysRelevance> repository) : base(unitWork, repository)
{
}
public SysRevelanceApp SetLoginInfo(LoginInfo loginInfo)
{
Repository._loginInfo = loginInfo;
return this;
}
/// <summary>
/// 添加关联
/// <para>比如给用户分配资源，那么firstId就是用户ID，secIds就是资源ID列表</para>
/// </summary>
/// <param name="type">关联的类型，如Define.XXX</param>
public void Assign(string type, int firstId, int[] secIds)
{
Assign(type, secIds.ToLookup(u => firstId));
if (type == "RoleModule")
{
SysRole sysRole = UnitWork.FindSingle<SysRole>(u => u.Id.Equals(firstId));
sysRole.IsAssignModule = true;
UnitWork.Update(sysRole);
//UnitWork.Update<SysRole>(u => u.Id.Equals(firstId), u => new SysRole { IsAssignModule = true });
}
else if (type == "UserRole")
{
SysUser sysUser = UnitWork.FindSingle<SysUser>(u => u.Id.Equals(firstId));
sysUser.IsAssignRole = true;
UnitWork.Update(sysUser);
//UnitWork.Update<SysUser>(u => u.Id.Equals(firstId), u => new SysUser { IsAssignRole = true });
}
else if (type == "UserModule")
{
SysUser sysUser = UnitWork.FindSingle<SysUser>(u => u.Id.Equals(firstId));
sysUser.IsAssignModule = true;
UnitWork.Update(sysUser);
//UnitWork.Update<SysUser>(u => u.Id.Equals(firstId), u => new SysUser { IsAssignModule = true });
}
}
public void Assign(string key, ILookup<int, int> idMaps)
{
DeleteBy(key, idMaps);
UnitWork.BatchAdd((from sameVals in idMaps
from value in sameVals
select new SysRelevance
{
RelKey = key,
FirstId = sameVals.Key,
SecondId = value,
CreateBy = Repository._loginInfo.Account,
CreateTime = DateTime.Now
}).ToArray());
UnitWork.Save();
}
/// <summary>
/// 删除关联
/// </summary>
/// <param name="key">关联标识</param>
/// <param name="idMaps">关联的<firstId, secondId>数组</param>
public void DeleteBy(string key, ILookup<int, int> idMaps)
{
foreach (var sameVals in idMaps)
{
foreach (var value in sameVals)
{
Repository.Delete(u => u.RelKey == key && u.FirstId == sameVals.Key && u.SecondId == value);
}
}
}
/// <summary>
/// 取消关联
/// </summary>
/// <param name="type">关联的类型，如Define.XXX</param>
/// <param name="firstId">The first identifier.</param>
/// <param name="secIds">The sec ids.</param>
public void UnAssign(string type, int firstId, int[] secIds)
{
DeleteBy(type, secIds.ToLookup(u => firstId));
if (type == "RoleModule")
{
if (!UnitWork.IsExist<SysRelevance>(u => u.RelKey.Equals(type) && u.FirstId.Equals(firstId)))
{
SysRole sysRole = UnitWork.FindSingle<SysRole>(u => u.Id.Equals(firstId));
sysRole.IsAssignModule = false;
UnitWork.Update(sysRole);
//UnitWork.Update<SysRole>(u => u.Id.Equals(firstId), u => new SysRole { IsAssignModule = false });
}
}
else if (type == "UserRole")
{
if (!UnitWork.IsExist<SysRelevance>(u => u.RelKey.Equals(type) && u.FirstId.Equals(firstId)))
{
SysUser sysUser = UnitWork.FindSingle<SysUser>(u => u.Id.Equals(firstId));
sysUser.IsAssignRole = false;
UnitWork.Update(sysUser);
//UnitWork.Update<SysUser>(u => u.Id.Equals(firstId), u => new SysUser { IsAssignRole = false });
}
}
else if (type == "UserModule")
{
if (!UnitWork.IsExist<SysRelevance>(u => u.RelKey.Equals(type) && u.FirstId.Equals(firstId)))
{
SysUser sysUser = UnitWork.FindSingle<SysUser>(u => u.Id.Equals(firstId));
sysUser.IsAssignModule = false;
UnitWork.Update(sysUser);
//UnitWork.Update<SysUser>(u => u.Id.Equals(firstId), u => new SysUser { IsAssignModule = false });
}
}
}
public void DeleteBy(string key, params int[] firstIds)
{
List<int> firstIdslist = firstIds.ToList();
Repository.Delete(u => firstIdslist.Contains(u.FirstId.Value) && u.RelKey == key);
}
/// <summary>
/// 添加新的关联
/// </summary>
/// <param name="key">关联标识</param>
/// <param name="idMaps">关联的<firstId, secondId>数组</param>
public void AddRelevance(string key, ILookup<int, int> idMaps)
{
DeleteBy(key, idMaps);
UnitWork.BatchAdd<SysRelevance>((from sameVals in idMaps
from value in sameVals
select new SysRelevance
{
RelKey = key,
FirstId = sameVals.Key,
SecondId = value,
CreateBy = Repository._loginInfo.Account,
CreateTime = DateTime.Now
}).ToArray());
UnitWork.Save();
}
/// <summary>
/// 根据关联表的一个键获取另外键的值
/// </summary>
/// <param name="key">映射标识</param>
/// <param name="returnSecondIds">返回的是否为映射表的第二列，如果不是则返回第一列</param>
/// <param name="ids">已知的ID列表</param>
/// <returns>List<System.String>.</returns>
public List<int> Get(string key, bool returnSecondIds, params int[] ids)
{
List<int> idlist = ids.ToList();
if (returnSecondIds)
{
return Repository.Find(u => u.RelKey == key
&& idlist.Contains(u.FirstId.Value)).Select(u => u.SecondId.Value).ToList();
}
else
{
return Repository.Find(u => u.RelKey == key
&& idlist.Contains(u.SecondId.Value)).Select(u => u.FirstId.Value).ToList();
}
}
}
}