public static int Add(List <string> userCodes, string relationsTable, string relationsKey)
{
using (pm2Entities entities = new pm2Entities())
{
foreach (Basic_Privilege privilege in (from m in entities.Basic_Privilege
where (m.RelationsTable == relationsTable) && (m.RelationsKey == relationsKey)
select m).ToList <Basic_Privilege>())
{
entities.DeleteObject(privilege);
}
if (userCodes != null)
{
foreach (string str in userCodes)
{
string str2 = Guid.NewGuid().ToString();
Basic_Privilege privilege2 = new Basic_Privilege {
PrivilegeId = str2,
RelationsTable = relationsTable,
RelationsKey = relationsKey,
UserCode = str
};
entities.AddToBasic_Privilege(privilege2);
}
}
return(entities.SaveChanges());
}
}
public void Add(string table, string key, IList <string> userCodes)
{
using (pm2Entities entities = new pm2Entities())
{
using (IEnumerator <string> enumerator = userCodes.GetEnumerator())
{
string code;
while (enumerator.MoveNext())
{
code = enumerator.Current;
if ((from p in entities.Basic_Privilege
where ((p.RelationsTable == table) && (p.RelationsKey == key)) && (p.UserCode == code)
select p).Count <Basic_Privilege>() == 0)
{
Basic_Privilege entity = new Basic_Privilege {
PrivilegeId = Guid.NewGuid().ToString(),
RelationsTable = table,
RelationsKey = key,
UserCode = code
};
entities.Basic_Privilege.AddObject(entity);
}
}
}
entities.SaveChanges();
}
}
