/*********************************************************************** * Project: CoreCms * ProjectName: 百分兵法管理系统 * Web: hhtp://chuanyin.com * Author: * Email: * CreateTime: 202403/02 * Description: 暂无 ***********************************************************************/ using System; using System.ComponentModel; using System.Linq; using System.Linq.Expressions; using System.Threading.Tasks; using CoreCms.Net.Configuration; using CoreCms.Net.Filter; using CoreCms.Net.IServices; using CoreCms.Net.Loging; using CoreCms.Net.Model.Entities; using CoreCms.Net.Model.Entities.Expression; using CoreCms.Net.Model.FromBody; using CoreCms.Net.Model.ViewModels.UI; using CoreCms.Net.Utility.Extensions; using CoreCms.Net.Utility.Helper; using CoreCms.Net.Web.Admin.Infrastructure; using Microsoft.AspNetCore.Authorization; using Microsoft.AspNetCore.Hosting; using Microsoft.AspNetCore.Mvc; using SqlSugar; namespace CoreCms.Net.Web.Admin.Controllers { /// /// 经销商等级设置表 /// [Description("经销商等级设置表")] [Route("api/[controller]/[action]")] [ApiController] [RequiredErrorForAdmin] [Authorize(Permissions.Name)] public class CoreCmsDistributionGradeController : ControllerBase { private readonly ICoreCmsDistributionConditionServices _coreCmsDistributionConditionServices; private readonly ICoreCmsDistributionGradeServices _coreCmsDistributionGradeServices; private readonly ICoreCmsDistributionResultServices _coreCmsDistributionResultServices; private readonly ICoreCmsUserGradeServices _coreCmsUserGradeServices; private readonly IWebHostEnvironment _webHostEnvironment; /// /// 构造函数 /// public CoreCmsDistributionGradeController(IWebHostEnvironment webHostEnvironment , ICoreCmsDistributionGradeServices coreCmsDistributionGradeServices , ICoreCmsUserGradeServices coreCmsUserGradeServices , ICoreCmsDistributionConditionServices coreCmsDistributionConditionServices , ICoreCmsDistributionResultServices coreCmsDistributionResultServices) { _webHostEnvironment = webHostEnvironment; _coreCmsDistributionGradeServices = coreCmsDistributionGradeServices; _coreCmsUserGradeServices = coreCmsUserGradeServices; _coreCmsDistributionConditionServices = coreCmsDistributionConditionServices; _coreCmsDistributionResultServices = coreCmsDistributionResultServices; } #region 获取列表============================================================ // POST: Api/CoreCmsDistributionGrade/GetPageList /// /// 获取列表 /// /// [HttpPost] [Description("获取列表")] public async Task GetPageList() { var jm = new AdminUiCallBack(); var pageCurrent = Request.Form["page"].FirstOrDefault().ObjectToInt(1); var pageSize = Request.Form["limit"].FirstOrDefault().ObjectToInt(30); var where = PredicateBuilder.True(); //获取排序字段 var orderField = Request.Form["orderField"].FirstOrDefault(); Expression> orderEx; switch (orderField) { case "id": orderEx = p => p.id; break; case "name": orderEx = p => p.name; break; case "isDefault": orderEx = p => p.isDefault; break; case "isAutoUpGrade": orderEx = p => p.isAutoUpGrade; break; case "sortId": orderEx = p => p.sortId; break; case "description": orderEx = p => p.description; break; default: orderEx = p => p.id; break; } //设置排序方式 var orderDirection = Request.Form["orderDirection"].FirstOrDefault(); var orderBy = orderDirection switch { "asc" => OrderByType.Asc, "desc" => OrderByType.Desc, _ => OrderByType.Desc }; //查询筛选 //等级序列 int var id = Request.Form["id"].FirstOrDefault().ObjectToInt(0); if (id > 0) { where = where.And(p => p.id == id); } //等级名称 nvarchar var name = Request.Form["name"].FirstOrDefault(); if (!string.IsNullOrEmpty(name)) { where = where.And(p => p.name.Contains(name)); } //是否默认等级 bit var isDefault = Request.Form["isDefault"].FirstOrDefault(); if (!string.IsNullOrEmpty(isDefault) && isDefault.ToLowerInvariant() == "true") { where = where.And(p => p.isDefault == true); } else if (!string.IsNullOrEmpty(isDefault) && isDefault.ToLowerInvariant() == "false") { where = where.And(p => p.isDefault == false); } //是否自动升级 bit var isAutoUpGrade = Request.Form["isAutoUpGrade"].FirstOrDefault(); if (!string.IsNullOrEmpty(isAutoUpGrade) && isAutoUpGrade.ToLowerInvariant() == "true") { where = where.And(p => p.isAutoUpGrade == true); } else if (!string.IsNullOrEmpty(isAutoUpGrade) && isAutoUpGrade.ToLowerInvariant() == "false") { where = where.And(p => p.isAutoUpGrade == false); } //等级排序 int var sortId = Request.Form["sortId"].FirstOrDefault().ObjectToInt(0); if (sortId > 0) { where = where.And(p => p.sortId == sortId); } //等级说明 nvarchar var description = Request.Form["description"].FirstOrDefault(); if (!string.IsNullOrEmpty(description)) { where = where.And(p => p.description.Contains(description)); } //获取数据 var list = await _coreCmsDistributionGradeServices.QueryPageAsync(where, orderEx, orderBy, pageCurrent, pageSize, true); //返回数据 jm.data = list; jm.code = 0; jm.count = list.TotalCount; jm.msg = "数据调用成功!"; return jm; } #endregion #region 首页数据============================================================ // POST: Api/CoreCmsDistributionGrade/GetIndex /// /// 首页数据 /// /// [HttpPost] [Description("首页数据")] public AdminUiCallBack GetIndex() { //返回数据 var jm = new AdminUiCallBack { code = 0 }; return jm; } #endregion #region 创建数据============================================================ // POST: Api/CoreCmsDistributionGrade/GetCreate /// /// 创建数据 /// /// [HttpPost] [Description("创建数据")] public AdminUiCallBack GetCreate() { //返回数据 var jm = new AdminUiCallBack { code = 0 }; return jm; } #endregion #region 创建提交============================================================ // POST: Api/CoreCmsDistributionGrade/DoCreate /// /// 创建提交 /// /// /// [HttpPost] [Description("创建提交")] public async Task DoCreate([FromBody] CoreCmsDistributionGrade entity) { var jm = await _coreCmsDistributionGradeServices.InsertAsync(entity); return jm; } #endregion #region 编辑数据============================================================ // POST: Api/CoreCmsUserGrade/GetEdit /// /// 编辑数据 /// /// /// [HttpPost] [Description("编辑数据")] public async Task GetEdit([FromBody] FMIntId entity) { var jm = new AdminUiCallBack(); var model = await _coreCmsDistributionGradeServices.QueryByClauseAsync(p => p.id == entity.id); if (model == null) { jm.msg = "不存在此信息"; return jm; } var distributionConditions = await _coreCmsDistributionConditionServices.QueryListByClauseAsync(p => p.gradeId == model.id); var distributionResults = await _coreCmsDistributionResultServices.QueryListByClauseAsync(p => p.gradeId == model.id); jm.code = 0; jm.data = new { model, distributionConditions, distributionResults }; return jm; } #endregion #region 编辑提交============================================================ // POST: Admins/CoreCmsUserGrade/Edit /// /// 编辑提交 /// /// /// [HttpPost] [Description("编辑提交")] public async Task DoEdit([FromBody] CoreCmsDistributionGrade entity) { var jm = await _coreCmsDistributionGradeServices.UpdateAsync(entity); return jm; } #endregion #region 设置是否默认等级============================================================ // POST: Api/CoreCmsDistributionGrade/DoSetisDefault/10 /// /// 设置是否默认等级 /// /// /// [HttpPost] [Description("设置是否默认等级")] public async Task DoSetisDefault([FromBody] FMUpdateBoolDataByIntId entity) { var jm = new AdminUiCallBack(); var oldModel = await _coreCmsDistributionGradeServices.QueryByIdAsync(entity.id, false); if (oldModel == null) { jm.msg = "不存在此信息"; return jm; } oldModel.isDefault = (bool)entity.data; jm = await _coreCmsDistributionGradeServices.UpdateAsync(oldModel); return jm; } #endregion #region 设置是否自动升级============================================================ // POST: Api/CoreCmsDistributionGrade/DoSetisAutoUpGrade/10 /// /// 设置是否自动升级 /// /// /// [HttpPost] [Description("设置是否自动升级")] public async Task DoSetisAutoUpGrade([FromBody] FMUpdateBoolDataByIntId entity) { var jm = new AdminUiCallBack(); var oldModel = await _coreCmsDistributionGradeServices.QueryByIdAsync(entity.id, false); if (oldModel == null) { jm.msg = "不存在此信息"; return jm; } oldModel.isAutoUpGrade = (bool)entity.data; jm = await _coreCmsDistributionGradeServices.UpdateAsync(oldModel); return jm; } #endregion #region 删除数据============================================================ // POST: Api/CoreCmsDistributionGrade/DoDelete/10 /// /// 单选删除 /// /// /// [HttpPost] [Description("单选删除")] public async Task DoDelete([FromBody] FMIntId entity) { var jm = await _coreCmsDistributionGradeServices.DeleteByIdAsync(entity.id); return jm; } #endregion //升级条件 #region 获取列表============================================================ // POST: Api/CoreCmsDistributionGrade/GetDistributionConditionPageList /// /// 获取列表 /// /// [HttpPost] [Description("获取列表")] public async Task GetDistributionConditionPageList() { var jm = new AdminUiCallBack(); var pageCurrent = Request.Form["page"].FirstOrDefault().ObjectToInt(1); var pageSize = Request.Form["limit"].FirstOrDefault().ObjectToInt(30); var where = PredicateBuilder.True(); //查询筛选 //会员等级Id int var gradeId = Request.Form["gradeId"].FirstOrDefault().ObjectToInt(0); if (gradeId > 0) { @where = @where.And(p => p.gradeId == gradeId); } //获取数据 var list = await _coreCmsDistributionConditionServices.QueryPageAsync(where, p => p.id, OrderByType.Asc, pageCurrent, pageSize); if (list.Any()) { var distributionConditions = EnumHelper.EnumToList(); foreach (var condition in list) { var cd = distributionConditions.Find(p => p.title == condition.code); condition.name = cd?.description; } } //返回数据 jm.data = list; jm.code = 0; jm.count = list.TotalCount; jm.msg = "数据调用成功!"; return jm; } #endregion #region 创建数据============================================================ // POST: Api/CoreCmsDistributionGrade/GetDistributionConditionCreate /// /// 创建数据 /// /// [HttpPost] [Description("创建数据")] public AdminUiCallBack GetDistributionConditionCreate() { //返回数据 var jm = new AdminUiCallBack { code = 0 }; var distributionConditionsCode = EnumHelper.EnumToList(); jm.data = new { distributionConditionsCode, }; return jm; } #endregion #region 创建提交============================================================ // POST: Api/CoreCmsDistributionGrade/DoDistributionConditionCreate /// /// 创建提交 /// /// /// [HttpPost] [Description("创建提交")] public async Task DoDistributionConditionCreate([FromBody] CoreCmsDistributionCondition entity) { var jm = await _coreCmsDistributionConditionServices.InsertAsync(entity); return jm; } #endregion #region 编辑数据============================================================ // POST: Api/CoreCmsDistributionGrade/GetDistributionConditionEdit /// /// 编辑数据 /// /// /// [HttpPost] [Description("编辑数据")] public async Task GetDistributionConditionEdit([FromBody] FMIntId entity) { var jm = new AdminUiCallBack(); var model = await _coreCmsDistributionConditionServices.QueryByIdAsync(entity.id); if (model == null) { jm.msg = "不存在此信息"; return jm; } var distributionConditionsCode = EnumHelper.EnumToList(); jm.code = 0; jm.data = new { model, distributionConditionsCode, }; return jm; } #endregion #region 编辑提交============================================================ // POST: Api/CoreCmsDistributionGrade/DoDistributionConditionEdit /// /// 编辑提交 /// /// /// [HttpPost] [Description("编辑提交")] public async Task DoDistributionConditionEdit([FromBody] CoreCmsDistributionCondition entity) { var jm = await _coreCmsDistributionConditionServices.UpdateAsync(entity); return jm; } #endregion #region 删除数据============================================================ // POST: Api/CoreCmsDistributionGrade/DoDistributionConditionDelete/10 /// /// 单选删除 /// /// /// [HttpPost] [Description("单选删除")] public async Task DoDistributionConditionDelete([FromBody] FMIntId entity) { var jm = await _coreCmsDistributionConditionServices.DeleteByIdAsync(entity.id); return jm; } #endregion //升级结果 #region 获取列表============================================================ // POST: Api/CoreCmsDistributionGrade/GetDistributionResultPageList /// /// 获取列表 /// /// [HttpPost] [Description("获取列表")] public async Task GetDistributionResultPageList() { var jm = new AdminUiCallBack(); var pageCurrent = Request.Form["page"].FirstOrDefault().ObjectToInt(1); var pageSize = Request.Form["limit"].FirstOrDefault().ObjectToInt(30); var where = PredicateBuilder.True(); //查询筛选 //会员等级Id int var gradeId = Request.Form["gradeId"].FirstOrDefault().ObjectToInt(0); if (gradeId > 0) { @where = @where.And(p => p.gradeId == gradeId); } //获取数据 var list = await _coreCmsDistributionResultServices.QueryPageAsync(where, p => p.code, OrderByType.Asc, pageCurrent, pageSize); //返回数据 jm.data = list; jm.code = 0; jm.count = list.TotalCount; jm.msg = "数据调用成功!"; return jm; } #endregion #region 创建数据============================================================ // POST: Api/CoreCmsDistributionGrade/GetDistributionResultCreate /// /// 创建数据 /// /// [HttpPost] [Description("创建数据")] public AdminUiCallBack GetDistributionResultCreate() { //返回数据 var jm = new AdminUiCallBack { code = 0 }; return jm; } #endregion #region 创建提交============================================================ // POST: Api/CoreCmsDistributionGrade/DoDistributionResultCreate /// /// 创建提交 /// /// /// [HttpPost] [Description("创建提交")] public async Task DoDistributionResultCreate([FromBody] CoreCmsDistributionResult entity) { var jm = await _coreCmsDistributionResultServices.InsertAsync(entity); return jm; } #endregion #region 编辑数据============================================================ // POST: Api/CoreCmsDistributionGrade/GetDistributionResultEdit /// /// 编辑数据 /// /// /// [HttpPost] [Description("编辑数据")] public async Task GetDistributionResultEdit([FromBody] FMIntId entity) { var jm = new AdminUiCallBack(); var model = await _coreCmsDistributionResultServices.QueryByIdAsync(entity.id); if (model == null) { jm.msg = "不存在此信息"; return jm; } jm.code = 0; jm.data = model; return jm; } #endregion #region 编辑提交============================================================ // POST: Api/CoreCmsDistributionGrade/DoDistributionResultEdit /// /// 编辑提交 /// /// /// [HttpPost] [Description("编辑提交")] public async Task DoDistributionResultEdit([FromBody] CoreCmsDistributionResult entity) { var jm = await _coreCmsDistributionResultServices.UpdateAsync(entity); return jm; } #endregion #region 删除数据============================================================ // POST: Api/CoreCmsDistributionGrade/DoDistributionResultDelete/10 /// /// 单选删除 /// /// /// [HttpPost] [Description("单选删除")] public async Task DoDistributionResultDelete([FromBody] FMIntId entity) { var jm = await _coreCmsDistributionResultServices.DeleteByIdAsync(entity.id); ; return jm; } #endregion } }