将逗号分割的内容转换为list;
举例:a="1,2,4,45" 分割为1,2,4,45
List<string> list = new List<string>(roleDate.menuid.Split(','));
批量新增
//将角色与菜单绑定
for (var i = 0; i < list.Count(); i++) {
var systemroleclaimsItem = new systemroleclaims()
{
roleid = id,
menuid = list[i]
};
_context.systemroleclaims.Add(systemroleclaimsItem);
}
await _context.SaveChangesAsync();
批量删除
List<systemroleclaims> oldMenu = _context.systemroleclaims.Where(n=>n.roleid == roleDate.Roleid).ToList();
foreach (var item in oldMenu)
{
_context.systemroleclaims.Remove(item);
}
_context.SaveChanges();
list转数组
var roles = _context.systemuserroles.Where(P => P.userid == LoginUser.Id).ToList(); //查询出登陆用户下的角色id
List<System.Int32> listS = new List<System.Int32>();
for (var i =0;i<roles.Count();i++) {
listS.Add(int.Parse(roles[i].roleid));
}
int[] str = listS.ToArray(); //list转数组
Linq中实现select * from A where id in(1,2,3,4);重点str.Contains(P.roleid)
int[] str = listS.ToArray(); //list转数组
var menus = _context.systemroleclaims.Where(P=>str.Contains(P.roleid)).ToList(); //查询出角色对应的菜单权限
拼接以逗号分割的字符串,并移除最后一个逗号
string UseridList = "";
for (int i = 0; i < datas.Count(); i++)
{
string userid = datas[i]["mainTable"]["xm"].ToString(); //获取学员id
// string phone = datas[i]["mainTable"]["sjhm"].ToString(); //获取学员id
getUserInfor(userid, roomid, deviceIndexCode); //根据学员id获取学员信息
UseridList += datas[i]["mainTable"]["xm"].ToString() + ','; //拼接学员id
}
UseridList = UseridList.Substring(0, UseridList.Length - 1); //去除字符串的最后一个","