using Rhea.Common;
|
using Tiger.Model;
|
using Newtonsoft.Json;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Net;
|
using System.Text;
|
using System.Threading.Tasks;
|
using Tiger.IBusiness;
|
|
namespace Tiger.Business
|
{
|
public partial class Biz : ISystem
|
{
|
/// <summary>
|
/// 保存用户组中的用户列表
|
/// </summary>
|
/// <param name="userIdNotIn"></param>
|
/// <param name="userIdIn"></param>
|
/// <param name="userGroupId"></param>
|
/// <returns></returns>
|
public async Task<ApiAction> SetSysUserToGroupAsync(string userIdNotIn, string userIdIn,string userGroupId)
|
{
|
var action = new ApiAction();
|
try
|
{
|
var userIds = userIdIn.Split(',').ToList();
|
List<SYS_USER> list = await Biz.Db.Queryable<SYS_USER>().Where(x=> userIds.Contains(x.USER_ID)).ToListAsync();
|
|
//保存到数据库
|
var db = Business.Biz.Db;
|
var dbTran = db.UseTran(() =>
|
{
|
List<SYS_USERINGROUP> useringroupList = new();
|
db.Deleteable<SYS_USERINGROUP>().Where(x=>x.USERGROUP_CODE == userGroupId).ExecuteCommand();
|
if (list != null && list.Count > 0)
|
{
|
foreach (var item in list)
|
{
|
SYS_USERINGROUP g = new SYS_USERINGROUP();
|
g.USER_ID = item.ID;
|
g.USERGROUP_CODE = userGroupId;
|
useringroupList.Add(g);
|
}
|
db.Insertable(useringroupList, "admin").ExecuteCommand();
|
}
|
});
|
if (!dbTran.IsSuccess)
|
{
|
throw dbTran.ErrorException;
|
}
|
action.IsSuccessed = true;
|
action.Message = $"保存用户组中的用户列表成功。";
|
}
|
catch (Exception ex)
|
{
|
action.CatchExceptionWithLog(ex, $"保存用户组中的用户列表异常");
|
}
|
return action;
|
}
|
}
|
}
|
