ZLJ_API_V6.0/代码/TVShoppingCa.../Controllers/System/SeatGroupCon...

using System;
using System.Collections.Generic;
using System.Common;
using System.IRepositories;
using System.Linq;
using System.Linq.Expressions;
using System.Model;
using System.Security.Claims;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Authorization;
using Microsoft.AspNetCore.Mvc;
using SqlSugar;

namespace TVShoppingCallCenter_ZLJ.Controllers.System
{
    [Authorize]
    [Produces("application/json")]
    [Route("api/[controller]")]
    public class SeatGroupController : BaseController
    {
        private readonly ISys_SeatGroupRepository _sys_seatgroupRepository;
        public SeatGroupController(ISys_SeatGroupRepository sys_seatgroupRepository)
        {
            _sys_seatgroupRepository = sys_seatgroupRepository;
        }
        /// <summary>
        /// 获取坐席组列表
        /// </summary>
        /// <param name="filter"></param>
        /// <returns></returns>
        [Authorize]
        [HttpGet("getlistbypage")]
        public async Task<IActionResult> GetListsByPage(string key, int pageindex = 1, int pagesize = 10)
        {
            List<IConditionalModel> conModels = new List<IConditionalModel>();
            #region 条件筛选
            conModels.Add(new ConditionalModel() { FieldName = "F_State", ConditionalType = ConditionalType.Equal, FieldValue = ((int)EnumDelState.Enabled).ToString() });

            List<IConditionalModel> conModels1 = new List<IConditionalModel>();
            if (!string.IsNullOrEmpty(key))
            {
                conModels.Add(new ConditionalCollections()
                {
                    ConditionalList = new List<KeyValuePair<WhereType, ConditionalModel>>()
                    {
                        new  KeyValuePair<WhereType, ConditionalModel>(WhereType.And, new ConditionalModel() { FieldName = "F_ZXZName", ConditionalType = ConditionalType.Like, FieldValue = key }),
                        new  KeyValuePair<WhereType, ConditionalModel>( WhereType.Or , new ConditionalModel() { FieldName = "F_ZXZCode", ConditionalType = ConditionalType.Like, FieldValue = key }),
                        new  KeyValuePair<WhereType, ConditionalModel>( WhereType.Or, new ConditionalModel() { FieldName = "F_ZXAtt", ConditionalType = ConditionalType.Like, FieldValue = key })
                    }
                });
            }
            #endregion
            int recordCount = 0;
            var list = await _sys_seatgroupRepository.GetListByPage(conModels, new PageModel() { PageIndex = pageindex, PageSize = pagesize, PageCount = recordCount }, "F_CreateOn desc");

            return Success("成功", list);
        }

        [Authorize]
        [HttpGet("getlist")]
        public async Task<IActionResult> GetList(string key)
        {
            List<IConditionalModel> conModels = new List<IConditionalModel>();
            #region 条件筛选
            conModels.Add(new ConditionalModel() { FieldName = "F_State", ConditionalType = ConditionalType.Equal, FieldValue = ((int)EnumDelState.Enabled).ToString() });

            if (!string.IsNullOrEmpty(key))
            {
                conModels.Add(new ConditionalCollections()
                {
                    ConditionalList = new List<KeyValuePair<WhereType, ConditionalModel>>()
                    {
                        new  KeyValuePair<WhereType, ConditionalModel>( WhereType.Or , new ConditionalModel() { FieldName = "F_ZXZCode", ConditionalType = ConditionalType.Like, FieldValue = key }),
                        new  KeyValuePair<WhereType, ConditionalModel>(WhereType.Or, new ConditionalModel() { FieldName = "F_ZXZName", ConditionalType = ConditionalType.Like, FieldValue = key }),
                        new  KeyValuePair<WhereType, ConditionalModel>( WhereType.Or, new ConditionalModel() { FieldName = "F_ZXAtt", ConditionalType = ConditionalType.Like, FieldValue = key })
                    }
                });

            }
            #endregion
            var list = await _sys_seatgroupRepository.GetListALL(conModels, "F_CreateOn desc");

            return Success("根据条件获取数据成功", list);
        }

        /// <summary>
        /// 获取实体
        /// </summary>
        [Authorize]
        [HttpGet("getsingle")]
        public async Task<IActionResult> GetSingle(int id)
        {
            if (id > 0)
            {
                var dModel = await _sys_seatgroupRepository.GetSingle(x => x.F_ZXZID == id);

                if (dModel != null)
                {
                    return Success("获取坐席组成功", dModel);
                }
                else
                {
                    return Error("获取坐席组失败");
                }
            }
            else
            {
                return Error("获取参数失败");
            }
        }

        /// <summary>
        /// 添加坐席组
        /// </summary>
        [Authorize]
        [HttpPost("add")]
        public async Task<IActionResult> Add(string zxzcode, string zxzname, string zxatt,
            string whwdkey, string whbdkey, int ivrkey, string outcallnum, string des)
        {
            T_Sys_SeatGroup clmodel = new T_Sys_SeatGroup();
            if (await GetExistByCodeAsync(zxzcode, 0) || await GetExistByNameAsync(zxzname, 0))
            {
                return Error("坐席组编号和名称必须唯一，请重新输入！");
            }
            if (!string.IsNullOrWhiteSpace(zxzcode))
                clmodel.F_ZXZCode = zxzcode.Trim();
            else
            {
                return Error("编号不能为空");
            }
            if (!string.IsNullOrWhiteSpace(zxzname))
                clmodel.F_ZXZName = zxzname.Trim();
            else
            {
                return Error("名称不能为空");
            }
            if (!string.IsNullOrWhiteSpace(zxatt))
                clmodel.F_ZXAtt = zxatt.Trim();
            else
            {
                return Error("坐席地区号不能为空");
            }
            if (!string.IsNullOrWhiteSpace(whwdkey))
                clmodel.F_WHWDKey = whwdkey.Trim();
            else
            {
                return Error("外呼外地前缀不能为空");
            }
            if (!string.IsNullOrWhiteSpace(whbdkey))
                clmodel.F_WHBDKey = whbdkey.Trim();
            else
            {
                return Error("外呼本地前缀不能为空");
            }
            if (!ValidateString.IsNumberStr(whwdkey.Trim().ToString()))
            {
                return Error("外呼外地前缀必须为数字");
            }
            if (!ValidateString.IsNumberStr(whbdkey.Trim().ToString()))
            {
                return Error("外呼本地前缀必须为数字");
            }

            clmodel.F_IVRKey = ivrkey;
            clmodel.F_Des = des;
            clmodel.F_CreateBy = User.Claims.FirstOrDefault(c => c.Type == ClaimTypes.Sid).Value; //"8000";
            clmodel.F_CreateOn = DateTime.Now;
            clmodel.F_State = (int)EnumDelState.Enabled;

            var res = await _sys_seatgroupRepository.Add(clmodel);
            if (res > 0)
                return Success("坐席组保存成功");
            else
            {
                return Error("坐席组保存失败");
            }
        }

        /// <summary>
        /// 修改坐席组
        /// </summary>
        [Authorize]
        [HttpPost("update")]
        public async Task<IActionResult> Edit(int id, string zxzcode, string zxzname, string zxatt,
            string whwdkey, string whbdkey, int ivrkey, string outcallnum, string des)
        {
            if (id > 0)
            {
                if (await GetExistByCodeAsync(zxzcode, id) || await GetExistByNameAsync(zxzname, id))
                {
                    return Error("坐席组编号和名称必须唯一，请重新输入！");
                }
                if (string.IsNullOrWhiteSpace(whwdkey))
                    return Error("外呼外地前缀不能为空");
                if (string.IsNullOrWhiteSpace(whbdkey))
                    return Error("外呼本地前缀不能为空");

                if (!ValidateString.IsNumberStr(whwdkey.Trim().ToString()))
                {
                    return Error("外呼外地前缀必须为数字");
                }
                if (!ValidateString.IsNumberStr(whbdkey.Trim().ToString()))
                {
                    return Error("外呼本地前缀必须为数字");
                }

                var res = false;
                var clmodel = await _sys_seatgroupRepository.GetSingle(x => x.F_ZXZID == id);
                if (clmodel != null)
                {
                    if (!string.IsNullOrWhiteSpace(zxzcode))
                        clmodel.F_ZXZCode = zxzcode.Trim();
                    if (!string.IsNullOrWhiteSpace(zxzname))
                        clmodel.F_ZXZName = zxzname.Trim();
                    if (!string.IsNullOrWhiteSpace(zxatt))
                        clmodel.F_ZXAtt = zxatt.Trim();
                    if (!string.IsNullOrWhiteSpace(whwdkey))
                        clmodel.F_WHWDKey = whwdkey.Trim();
                    if (!string.IsNullOrWhiteSpace(whbdkey))
                        clmodel.F_WHBDKey = whbdkey.Trim();

                    clmodel.F_IVRKey = ivrkey;
                    if (!string.IsNullOrWhiteSpace(des))
                        clmodel.F_Des = des;

                    clmodel.F_LastModifyBy = User.Claims.FirstOrDefault(c => c.Type == ClaimTypes.Sid).Value; //"8000";
                    clmodel.F_LastModifyOn = DateTime.Now;

                    res = await _sys_seatgroupRepository.Update(clmodel);
                }
                if (res)
                    return Success("坐席组保存成功");
                else
                {
                    return Error("坐席组保存失败");
                }
            }
            else
                return Error("请选择要编辑的坐席组");
        }

        [Authorize]
        [HttpPost("delete")]
        public async Task<IActionResult> Remove(int[] ids)
        {
            //使用逻辑删除
            //物理删除的数据无法恢复
            var res = 0;
            if (ids != null && ids.Length > 0)
            {
                foreach (var item in ids)
                {
                    var ml = await _sys_seatgroupRepository.GetSingle(x => x.F_ZXZID == item);
                    ml.F_State = (int)EnumDelState.Delete;
                    if (await _sys_seatgroupRepository.Update(ml))
                        res += 1;
                }
                if (res == ids.Length)
                    return Success("删除成功");
                else if (res > 0 && res < ids.Length)
                    return Error("部分删除失败，请查看后重新操作");
                else
                    return Error("删除失败，请查看后重新操作");
            }
            else
                return Error("请选择要删除的记录");
        }

        #region 私有方法
        /// <summary>
        /// 根据坐席组编号查询是否存在此坐席组编号
        /// </summary>
        /// <param name="code"></param>
        /// <returns></returns>
        private async Task<bool> GetExistByCodeAsync(string code, int id)
        {
            long c = 0;
            if (id > 0)
                c = await _sys_seatgroupRepository.GetCount(x => x.F_ZXZCode.Equals(code) && x.F_ZXZID != id);
            else
                c = await _sys_seatgroupRepository.GetCount(x => x.F_ZXZCode.Equals(code));

            return c > 0;
        }
        /// <summary>
        /// 根据坐席组名称查询是否存在此坐席组编号
        /// </summary>
        /// <param name="code"></param>
        /// <returns></returns>
        private async Task<bool> GetExistByNameAsync(string name, int id)
        {
            long c = 0;
            if (id > 0)
                c = await _sys_seatgroupRepository.GetCount(x => x.F_ZXZName.Equals(name) && x.F_ZXZID != id);
            else
                c = await _sys_seatgroupRepository.GetCount(x => x.F_ZXZName.Equals(name));
            
            return c > 0;
        }
        #endregion
    }
}