public JsonResult SetRoleUser(string mpid, string relationData)
{
string[] arrRelateID = GetValues(relationData, "ID").Distinct().Where(c => !string.IsNullOrEmpty(c)).ToArray();
var originalList = entities.Set <MpAccountUserRelation>().Where(c => c.MpID == mpid).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 <MpAccountUserRelation>().Remove(item);
}
foreach (var id in addlist)
{
var model = new MpAccountUserRelation();
model.ID = FormulaHelper.CreateGuid();
model.MpID = mpid;
model.UserID = id;
model.IsUsed = SysBool.F.ToString();
model.IsDefault = SysBool.F.ToString();
entities.Set <MpAccountUserRelation>().Add(model);
}
entities.SaveChanges();
return(Json(""));
}
/// <summary>
/// 设置用户默认公众号
/// </summary>
/// <param name="userID">用户ID</param>
/// <param name="projectInfoID">公众号ID</param>
public void SetDefaultMp(string userID, string mpID)
{
var t = SysBool.T.ToString();
var f = SysBool.F.ToString();
var defaultMp = entities.MpAccountUserRelation.Where(d => d.UserID == userID && d.MpID == mpID).OrderByDescending(d => d.ID).FirstOrDefault();
if (defaultMp != null)
{
defaultMp.IsDefault = t;
defaultMp.IsUsed = t;
}
else
{
var dm = new MpAccountUserRelation();
dm.ID = FormulaHelper.CreateGuid();
dm.UserID = userID;
dm.MpID = mpID;
dm.IsDefault = t;
dm.IsUsed = t;
entities.MpAccountUserRelation.Add(dm);
}
var notdefault = entities.MpAccountUserRelation.Where(d => d.UserID == userID && d.MpID != mpID).ToList();
for (int i = 0; i < notdefault.Count(); i++)
{
notdefault[i].IsDefault = f;
}
entities.SaveChanges();
}
/// <summary>
/// 设置常用公众号
/// </summary>
/// <param name="userID">用户ID</param>
/// <param name="mpID">公众号ID</param>
public void SetFocusMp(string userID, string mpID)
{
var mprelation = entities.Set <MpAccountUserRelation>().Where(c => c.MpID == mpID && c.UserID == userID).FirstOrDefault();
if (mprelation == null)
{
mprelation = new MpAccountUserRelation();
mprelation.ID = FormulaHelper.CreateGuid();
mprelation.MpID = mpID;
mprelation.UserID = userID;
mprelation.IsUsed = SysBool.T.ToString();
entities.Set <MpAccountUserRelation>().Add(mprelation);
}
else
{
mprelation.IsUsed = SysBool.T.ToString();
}
entities.SaveChanges();
}
