ZLJ_API_V6.0/代码/TVShoppingCa.../Controllers/Customer/VIPInfoContr...

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

namespace TVShoppingCallCenter_ZLJ.Controllers.Customer
{
    //[Authorize]
    [Produces("application/json")]
    [Route("api/[controller]")]
    public class VipInfoController : BaseController
    {
        private readonly ICus_VipInfoRepository _cus_vip_infoRepository;
        private readonly ISys_UserAccountRepository _sys_user_accountRepository;

        public VipInfoController(ICus_VipInfoRepository cus_vip_infoRepository, ISys_UserAccountRepository sys_user_accountRepository)
        {
            _cus_vip_infoRepository = cus_vip_infoRepository;
            _sys_user_accountRepository = sys_user_accountRepository;
        }

        [HttpGet]
        public IActionResult Index()
        {
            return  Success("成功");
        }

        /// <summary>
        /// 获取会员列表分页
        /// </summary>
        /// <param name="keyword"></param>
        /// <param name="pageindex"></param>
        /// <param name="pagesize"></param>
        /// <returns></returns>
        [HttpGet("getlistbypage")]
        public async Task<IActionResult> GetListsByPageAsync(string keyword,string name,string phone,string type, string province,string city,string area,string town,string address,string birthday,string recommender,string saleperson,string contact, int pageindex = 1, int pagesize = 20)
        {
            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(phone))
                conModels.Add(new ConditionalCollections()
                {
                    ConditionalList = new List<KeyValuePair<WhereType, ConditionalModel>>()
                    {
                        new  KeyValuePair<WhereType, ConditionalModel>(WhereType.And, new ConditionalModel() { FieldName = "F_Phone", ConditionalType = ConditionalType.Like, FieldValue = phone }),
                        new  KeyValuePair<WhereType, ConditionalModel>( WhereType.Or , new ConditionalModel() { FieldName = "F_Mobile", ConditionalType = ConditionalType.Like, FieldValue = phone }),
                        new  KeyValuePair<WhereType, ConditionalModel>( WhereType.Or, new ConditionalModel() { FieldName = "F_Mobile1", ConditionalType = ConditionalType.Like, FieldValue = phone })
                       
                    }
                });
            if (!string.IsNullOrEmpty(name))
            {
                conModels.Add(new ConditionalModel() { FieldName = "F_Name", ConditionalType = ConditionalType.Like, FieldValue = name });
            }
            if (!string.IsNullOrEmpty(type))
            {
                conModels.Add(new ConditionalModel() { FieldName = "F_Type", ConditionalType = ConditionalType.Like, FieldValue = type });
            }
            if (!string.IsNullOrEmpty(province))
            {
                conModels.Add(new ConditionalModel() { FieldName = "F_Province", ConditionalType = ConditionalType.Like, FieldValue = province });
            }

            if (!string.IsNullOrEmpty(city))
            {
                conModels.Add(new ConditionalModel() { FieldName = "F_City", ConditionalType = ConditionalType.Like, FieldValue = city });
            }
            if (!string.IsNullOrEmpty(area))
            {
                conModels.Add(new ConditionalModel() { FieldName = "F_Area", ConditionalType = ConditionalType.Like, FieldValue = area });
            }
            if (!string.IsNullOrEmpty(town))
            {
                conModels.Add(new ConditionalModel() { FieldName = "F_Town", ConditionalType = ConditionalType.Like, FieldValue = town });
            }
            if (!string.IsNullOrEmpty(address))
            {
                conModels.Add(new ConditionalModel() { FieldName = "F_Address", ConditionalType = ConditionalType.Like, FieldValue = address });
            }
            if (!string.IsNullOrEmpty(birthday))
            {
                conModels.Add(new ConditionalModel() { FieldName = "F_Birthday", ConditionalType = ConditionalType.Like, FieldValue = birthday });
            }
            if (!string.IsNullOrEmpty(recommender))
            {
                conModels.Add(new ConditionalModel() { FieldName = "F_Recommender", ConditionalType = ConditionalType.Like, FieldValue = recommender });
            }
            if (!string.IsNullOrEmpty(saleperson))
            {
                conModels.Add(new ConditionalModel() { FieldName = "F_Saleperson", ConditionalType = ConditionalType.Like, FieldValue = saleperson });
            }
            if (!string.IsNullOrEmpty(contact))
            {
                conModels.Add(new ConditionalModel() { FieldName = "F_Contact", ConditionalType = ConditionalType.Like, FieldValue = contact });
            }
            #endregion
            int recordCount = 0;
            var list = await _cus_vip_infoRepository.GetListByPage(conModels, new MyPageModel() { PageIndex = pageindex, PageSize = pagesize, PageCount = recordCount });
            var obj = new
            {
                state = "success",
                message = "成功",
                rows = list,
                total = recordCount,
            };
            return Content(obj.ToJson());
        }

        /// <summary>
        /// 获取会员信息详情
        /// </summary>
        /// <param name="id">id</param>
        /// <returns></returns>
        [HttpGet("getdetails")]
        public async Task<IActionResult> GetDetailsAsync(int id)
        {
            if (id <= 0)
                return Error("参数错误");

            var model = await _cus_vip_infoRepository.GetSingle(x => x.F_ID == id);
            if (model == null)
            {
                return Error("获取失败");
            }
            return Success("获取成功！", model);
        }

        /// <summary>
        /// 添加会员
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpPost("add")]
        public async Task<IActionResult> AddAsync(VipInfoInput input)
        {
            if (string.IsNullOrEmpty(input.name ))
                return Error("请输入名字");
            if (string.IsNullOrEmpty(input.phone ))
                return Error("请输入手机号");

            var model = new T_Cus_VipInfo();
            model.F_VIPCode = input .vipcode ;//会员卡号
            model.F_Name = input.name;
            model.F_Birthday  = input.birthday ;
            model.F_Phone = input.phone;
            model.F_Recommender = input.recommender;
            model.F_Sex = input.sex;
            model.F_Label = input.label;
            model.F_State = input.state;
            model.F_Note = input.note;
            model.F_City = input.city;
            model.F_Nickname = input.nickname;
            model.F_Address = input.address;
            model.F_Address1 = input.address1;
            model.F_RegTime = DateTime.Now;
            model.F_CreateBy = User.Claims.FirstOrDefault(c => c.Type == ClaimTypes.Sid).Value;
            model.F_CreateOn = DateTime.Now;
            model.F_Age = input.age;
            model.F_Mobile = input.mobile;
            model.F_Mobile1 = input.mobile1;
            model.F_Province = input.province;
            model.F_Area = input.area;
            model.F_Town = input.town;
            model.F_Postcode = input.postcode;
            model.F_ShoeSize = input.shoesize;
            model.F_Score = input.score;
            model.F_Money = input.money;
            model.F_TotalScore = input.totalscore;
            model.F_Saleperson = input.saleperson;
            model.F_Contact = input.contact;
            model.F_Type = input.type;

            if (await _cus_vip_infoRepository.GetCount(x => x.F_VIPCode == model.F_VIPCode && x.F_Name == input.name) > 0)
            {
                return Error("添加失败，存在相同会员信息");
            }
            var res = await _cus_vip_infoRepository.Add(model);
            if (res > 0)
            {
                return Success("添加成功");
            }
            else
            {
                return Error("添加失败");
            }
        }

        /// <summary>
        /// 修改会员信息
        /// </summary>
        [HttpPost("update")]
        public async Task<IActionResult> UpdateAsync(VipInfoInput input)
        {
            if (string.IsNullOrEmpty(input.name))
                return Error("请输入名字");
            if (string.IsNullOrEmpty(input.phone))
                return Error("请输入手机号");

            var model = await _cus_vip_infoRepository.GetSingle(x => x.F_ID == input.id);
            if (model == null)
                return Error("操作失败");
            //model.F_VIPCode = input.vipcode;//会员卡号
            model.F_Name = input.name;
            model.F_Birthday = input.birthday;
            model.F_Phone = input.phone;
            model.F_Recommender = input.recommender;
            model.F_Sex = input.sex;
            model.F_Label = input.label;
            model.F_State = input.state;
            model.F_Note = input.note;
            model.F_City = input.city;
            model.F_Nickname = input.nickname;
            model.F_Address = input.address;
            model.F_Address1 = input.address1;
            model.F_RegTime = DateTime.Now;
            model.F_LastModifyOn = DateTime.Now.ToLocalTime();
            model.F_LastModifyBy = User.Claims.FirstOrDefault(c => c.Type == ClaimTypes.Sid).Value;
            model.F_Age = input.age;
            model.F_Mobile = input.mobile;
            model.F_Mobile1 = input.mobile1;
            model.F_Province = input.province;
            model.F_Area = input.area;
            model.F_Town = input.town;
            model.F_Postcode = input.postcode;
            model.F_ShoeSize = input.shoesize;
            model.F_Score = input.score;
            model.F_Money = input.money;
            model.F_TotalScore = input.totalscore;
            model.F_Saleperson = input.saleperson;
            model.F_Contact = input.contact;
            model.F_Type = input.type;
            bool b = await _cus_vip_infoRepository.Update(model);
            if (b)
                return Success("修改成功");
            return Error("修改失败");
        }

        /// <summary>
        /// 删除会员信息 by ids
        /// </summary>
        /// <param name="ids"></param>
        /// <returns></returns>
        [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 _cus_vip_infoRepository.GetSingle(x => x.F_ID == item);
                    ml.F_State = (int)EnumDelState.Delete;
                    ml.F_DeleteOn = DateTime.Now.ToLocalTime();
                    ml.F_DeleteBy = User.Claims.FirstOrDefault(c => c.Type == ClaimTypes.Sid).Value;
                    if (_cus_vip_infoRepository.Update(ml).Result)
                        res += 1;
                }
                if (res == ids.Length)
                    return Success("删除成功");
                else if (res > 0 && res < ids.Length)
                    return Error("部分删除失败，请查看后重新操作");
                else
                    return Error("删除失败，请查看后重新操作");
            }
            else
                return Error("请选择要删除的记录");
        }


    }
}