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(); }