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