public JsonResult SetRoleUser(string qyid, string relationData)
{
string[] arrRelateID = GetValues(relationData, "ID").Distinct().Where(c => !string.IsNullOrEmpty(c)).ToArray();
var originalList = entities.Set <QyAccountUserRelation>().Where(c => c.QyID == qyid).ToArray();
//新增的用户
var addlist = arrRelateID.Where(c => !originalList.Select(d => d.UserID).Contains(c));
//需要删除的用户
var dellist = originalList.Where(c => !arrRelateID.Contains(c.UserID));
foreach (var item in dellist)
{
entities.Set <QyAccountUserRelation>().Remove(item);
}
foreach (var id in addlist)
{
var model = new QyAccountUserRelation();
model.ID = FormulaHelper.CreateGuid();
model.QyID = qyid;
model.UserID = id;
model.IsUsed = SysBool.F.ToString();
model.IsDefault = SysBool.F.ToString();
entities.Set <QyAccountUserRelation>().Add(model);
}
entities.SaveChanges();
return(Json(""));
}
/// <summary>
/// 设置用户默认公众号
/// </summary>
/// <param name="userID">用户ID</param>
/// <param name="qyID">企业号ID</param>
public void SetDefaultQy(string userID, string qyID)
{
var t = SysBool.T.ToString();
var f = SysBool.F.ToString();
var defaultMp = entities.QyAccountUserRelation.Where(d => d.UserID == userID && d.QyID == qyID).OrderByDescending(d => d.ID).FirstOrDefault();
if (defaultMp != null)
{
defaultMp.IsDefault = t;
defaultMp.IsUsed = t;
}
else
{
var dm = new QyAccountUserRelation();
dm.ID = FormulaHelper.CreateGuid();
dm.UserID = userID;
dm.QyID = qyID;
dm.IsDefault = t;
dm.IsUsed = t;
entities.QyAccountUserRelation.Add(dm);
}
var notdefault = entities.QyAccountUserRelation.Where(d => d.UserID == userID && d.QyID != qyID).ToList();
for (int i = 0; i < notdefault.Count(); i++)
{
notdefault[i].IsDefault = f;
}
entities.SaveChanges();
}
/// <summary>
/// 设置常用公众号
/// </summary>
/// <param name="userID">用户ID</param>
/// <param name="qyID">企业号ID</param>
public void SetFocusQy(string userID, string qyID)
{
var mprelation = entities.Set <QyAccountUserRelation>().Where(c => c.QyID == qyID && c.UserID == userID).FirstOrDefault();
if (mprelation == null)
{
mprelation = new QyAccountUserRelation();
mprelation.ID = FormulaHelper.CreateGuid();
mprelation.QyID = qyID;
mprelation.UserID = userID;
mprelation.IsUsed = SysBool.T.ToString();
entities.Set <QyAccountUserRelation>().Add(mprelation);
}
else
{
mprelation.IsUsed = SysBool.T.ToString();
}
entities.SaveChanges();
}
