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;

namespace Hh.Mes.Service.Configure
{
    public class BaseClientInfoService : RepositorySqlSugar<base_client_info>
    {
        public dynamic Load(PageReq pageReq, base_client_info entity)
        {
            return ExceptionsHelp.Instance.ExecuteT(() =>
            {
                var result = new Response<List<base_client_info>>();
                var expression = LinqWhere(entity);
                //先组合查询表达式
                var query = Context.Queryable<base_client_info>().Where(expression);
                //Exel为ture就不分页，因为导出的话是全部导出
                if (pageReq != null)
                {
                    int total = 0;
                    result.Result = query.ToOffsetPage(pageReq.page, pageReq.limit, ref total);
                    result.Count = total;
                }
                else
                {
                    result.Result = query.ToList();
                    result.Count = result.Result.Count();
                }
                return result;
            }, catchRetrunValue: "list");
        }

        public dynamic Ins(base_client_info entity)
        {
            return ExceptionsHelp.Instance.ExecuteT(() =>
            {

                var response = new Response(); 
                entity.keys = Guid.NewGuid();

                entity.setupDate = DateTime.Now;

                entity.createBy = sysWebUser?.Account;
                entity.createTime = DateTime.Now;

                response.Status = Add(entity);
                if (!response.Status)response.Message = SystemVariable.dataActionError;
                return response;
            });
        }

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

                //客户绑定项目，不允许删除
                foreach (var i in keys)
                {
                    var isBindProject = Context.Queryable<base_project_client_rel>().Any(x => x.clientKeys == i);
                    if (isBindProject)
                    {

                        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(x => x.clientName.Contains(model.clientName));
                }
                if (!string.IsNullOrWhiteSpace(model.legalRepresentative))
                {
                    exp.And(x => x.legalRepresentative.Contains(model.legalRepresentative));
                }
                if (!string.IsNullOrWhiteSpace(model.unifiedSocialCreditCode))
                {
                    exp.And(x => x.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;
            });
        }

    }
}