MES / IOT · Files

using Hh.Mes.Common.Infrastructure;
using Hh.Mes.Common.log;
using Hh.Mes.Common.Request;
using Hh.Mes.POJO.Entity;
using Hh.Mes.POJO.Response;
using Hh.Mes.Service.Repository;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Linq.Expressions;
using Hh.Mes.Pojo.System;
using Hh.Mes.Common;
using Hh.Mes.POJO.EnumEntitys;
using Hh.Mes.Service.SystemAuth;
using System.Data;
using Hh.Mes.Common.config;

namespace Hh.Mes.Service.Configure
{
    public class BaseClientInfoService : RepositorySqlSugar<base_client_info>
    {
        private readonly IAuth _auth;

        public BaseClientInfoService(IAuth auth)
        {
            _auth = auth;
        }

        #region 列表
        public dynamic Load(PageReq pageReq, base_client_info entity)
        {
            return ExceptionsHelp.Instance.ExecuteT(() =>
            {
                var result = new Response();
                var expression = LinqWhere(entity);

                //先组合查询表达式
                var query = Context.Queryable<base_client_info>()
                                    .Where(expression);

                //Exel为ture就不分页，因为导出的话是全部导出
                if (pageReq != null)
                {
                    int total = 0;
                    var list = query.ToOffsetPage(pageReq.page, pageReq.limit, ref total);
                    result.Result = DataHandle(list);
                    result.Count = total;
                }
                else
                {
                    result.Result = DataHandle(query.ToList()) ;
                    result.Count = result.Result.Count();
                }
                return result;
            }, catchRetrunValue: "list");
        }


        private List<base_client_info> DataHandle(List<base_client_info> data)
        {
            var clientKeys = data.Select(item => item.keys).ToList();
            var projectQuery = Context.Queryable<base_client_info, base_project_client_rel, sys_user_client_rel, base_project>((client,  proClient, uClient, pro) =>
                                                new JoinQueryInfos(
                                                    JoinType.Left, proClient.clientKeys == client.keys,
                                                    JoinType.Left, uClient.clientKeys == client.keys,
                                                    JoinType.Left, pro.keys == proClient.projectKeys))
                                                .Where((client, proClient, uClient, pro) => clientKeys.Contains(client.keys))
                                                .Select((client, proClient, uClient, pro) => new
                                                {
                                                    client.keys,
                                                    pro.projectName,

                                                    uClient.userAccount,
                                                })
                                                .ToList();
            //给项目 赋值 登入用户、项目关联绑定客户信息
            foreach (var item in data)
            {
                var projectUsers = projectQuery.Where(x => x.keys == item.keys)
                                               .Select(x => x.userAccount)
                                               .ToArray();
                item.projectUsers = string.Join(",", projectUsers);

                var projectNames = projectQuery.Where(x => x.keys == item.keys)
                                                 .Select(x => x.projectName)
                                                 .Distinct()
                                                 .ToArray();
                item.projectNames = string.Join(",", projectNames);
            }

            return data;
        } 
        #endregion



        public dynamic Ins(base_client_info entity)
        {
            return ExceptionsHelp.Instance.ExecuteT(() =>
            {
                Context.Ado.BeginTran();
                try
                {
                    var response = new Response();
                    entity.keys = Guid.NewGuid();
                    entity.setupDate = DateTime.Now;
                    entity.createBy = sysWebUser?.Account;
                    entity.createTime = DateTime.Now;

                    Context.Insertable(entity).ExecuteCommand();

                    var account = entity.userAccount?.Trim();
                    //用户输入了账号，需要校验
                    if (!string.IsNullOrWhiteSpace(account) && Context.Queryable<sys_user>().Where(x => x.account == account).Any())
                    {
                        response.Status = false;
                        response.Message = $"账号“{account}”在系统中已存在，请修改后重试！";
                        return response;
                    }

                    //用户未输入账号，系统自动生成
                    if (string.IsNullOrWhiteSpace(account))
                    {
                        //当前已存在的账户
                        var allUserAccount = Context.Queryable<sys_user>().Select(x => x.account).ToList();
                        var temps = Enumerable.Range(1, 999999).Select(x => $"iot{x.ToString().PadLeft(6, '0')}").ToList();
                        account = temps.Except(allUserAccount).FirstOrDefault();
                        if (string.IsNullOrWhiteSpace(account))
                        {
                            response.Status = false;
                            response.Message = "自动生成用户账号失败，请输入自定义账号，或联系系统管理员处理！";
                            return response;
                        }
                    }

                    var user = new sys_user
                    {
                        account = account,
                        password = Encryption.Encrypt("123456"),
                        name = entity.clientName,
                        status = 1,
                        createBy = sysWebUser?.Account,
                        createTime = DateTime.Now,
                    };
                    var userId = Context.Insertable(user).ExecuteReturnIdentity();

                    var rel = new sys_user_client_rel
                    {
                        clientKeys = entity.keys,
                        userAccount = user.account,
                    };
                    Context.Insertable(rel).ExecuteCommand();

                    int.TryParse($"{ConfigRead.GetInstance.GetAppsetConnection().AppCustomExtend5}", out var userRoleId);
                    var relevances = new List<SysRelevance>
                    {
                        new SysRelevance
                        {
                            RelKey = Define.USERORG,
                            FirstId = userId,
                            SecondId = _auth.GetCurrentUser().Orgs.Min(x => x.Id),
                            CreateBy = sysWebUser?.Account,
                            CreateTime = DateTime.Now
                        },
                        new SysRelevance
                        {
                            RelKey = Define.USERROLE,
                            FirstId = userId,
                            SecondId = userRoleId,
                            CreateBy = sysWebUser?.Account,
                            CreateTime = DateTime.Now
                        }
                    };
                    
                    Context.Insertable(relevances).ExecuteCommand();

                    Context.Ado.CommitTran();
                    return response;
                }
                catch (Exception ex)
                {
                    Context.Ado.RollbackTran();
                    throw ex;
                }
            });
        }

        public dynamic Upd(base_client_info entity)
        {
            return ExceptionsHelp.Instance.ExecuteT(() =>
            {
                var response = new Response();
                entity.setupDate = DateTime.Now;
                //entity.updateBy = sysWebUser?.Account;
                //entity.updateTime = DateTime.Now;
                response.Status = Update(entity);
                if (!response.Status) response.Message = SystemVariable.dataActionError;
                return response;
            });
        }

        public dynamic DelByIds(Guid[] keys)
        {
            return ExceptionsHelp.Instance.ExecuteT(() =>
            {
                var response = new Response();

                //客户绑定项目，不允许删除
                if (Context.Queryable<base_project_client_rel>().Any(x => keys.Contains(x.clientKeys)))
                {
                    return response.ResponseError("客户绑定了项目，不能直接删除，请先删除项目！");
                }

                //客户绑定用户，不允许删除
                if (Context.Queryable<sys_user_client_rel>().Any(x => keys.Contains(x.clientKeys)))
                {
                    return response.ResponseError("客户绑定了用户账号，不能直接删除，请在[系统管理]目录下的[用户管理]页面解除绑定后再试！");
                }

                Context.Deleteable<base_client_info>(t => keys.Contains(t.keys)).ExecuteCommand();
                Context.Deleteable<sys_user_client_rel>(t => keys.Contains(t.clientKeys)).ExecuteCommand();//删除客户时删除与用户的绑定关系；
                return response;
            });
        }

        public Response ExportData(base_client_info entity)
        {
            return Load(null, entity);
        }

        public Expression<Func<base_client_info, bool>> LinqWhere(base_client_info model)
        {
            try
            {
                var exp = Expressionable.Create<base_client_info>();
                //数据过滤条件
                //if (!string.IsNullOrWhiteSpace(model.XXX)) exp.And(x => x.XXX.Contains(model.XXX));
                if (!string.IsNullOrWhiteSpace(model.clientName))
                {
                    exp.And((c) => c.clientName.Contains(model.clientName));
                }
                if (!string.IsNullOrWhiteSpace(model.legalRepresentative))
                {
                    exp.And((c) => c.legalRepresentative.Contains(model.legalRepresentative));
                }
                if (!string.IsNullOrWhiteSpace(model.unifiedSocialCreditCode))
                {
                    exp.And((c) => c.unifiedSocialCreditCode.Contains(model.unifiedSocialCreditCode));
                }
                return exp.ToExpression();//拼接表达式
            }
            catch (Exception ex)
            {
                throw new Exception($"{ex.Message}");
            }
        }

        /// <summary>
        /// 客户管理项目功能
        /// </summary>
        /// <param name="clientKeys"></param>
        /// <param name="checkeds"></param>
        /// <param name="projectKeys"></param>
        /// <returns></returns>
        public dynamic BindClientProject(Guid clientKeys, bool checkeds, Guid projectKeys)
        {
            return ExceptionsHelp.Instance.ExecuteT(() =>
            {
                var response = new Response();
                if (checkeds)
                {
                    Context.Deleteable<base_project_client_rel>().Where(x => x.clientKeys == clientKeys && x.projectKeys == projectKeys).ExecuteCommand();
                    base_project_client_rel bpcr = new base_project_client_rel() { clientKeys = clientKeys, projectKeys = projectKeys };
                    Context.Insertable(bpcr).AddQueue();
                    response.Status = Context.SaveQueues() > 0;
                    if (!response.Status) response.Message = "添加客户项目关系表数据失败！";
                }
                else
                {
                    Context.Deleteable<base_project_client_rel>().Where(x => x.clientKeys == clientKeys && x.projectKeys == projectKeys).AddQueue();
                    response.Status = Context.SaveQueues() > 0;
                    if (!response.Status) response.Message = $"取消客户绑定项目:{projectKeys}失败";
                }
                return response;
            });
        }

        public dynamic GetClientBindProjects(Guid clientKeys)
        {
            return ExceptionsHelp.Instance.ExecuteT(() =>
            {
                var response = new Response();
                response.Result = Context.Queryable<base_project_client_rel>().Where(x => x.clientKeys == clientKeys).ToList();
                return response;
            });
        }

        public string GetUserConfigDefault(SysUser sysWebUser)
        {
            try
            {
                var orgId = _auth.GetCurrentUser().Orgs.Min(x => x.Id);
                int.TryParse($"{ConfigRead.GetInstance.GetAppsetConnection().AppCustomExtend5}", out var userRoleId);
                var orgName = Context.Queryable<sys_dept>().Where(x => x.id == orgId).Select(x => x.Name).First();
                var roleName = Context.Queryable<sys_role>().Where(x => x.id == userRoleId).Select(x => x.name).First();
                return $"默认角色：{roleName}，默认部门：{orgName}";
            }
            catch (Exception ex)
            {
                return $"获取默认配置信息失败：{ex.Message}";
            }
        }
    }
}