/*********************************************************************** * Project: baifenBinfa * ProjectName: 百分兵法管理系统 * Web: http://chuanyin.com * Author: * Email: * CreateTime: 202403/02 * Description: 暂无 ***********************************************************************/ using System; using System.ComponentModel; using System.IO; 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.Web.Admin.Infrastructure; using Microsoft.AspNetCore.Authorization; using Microsoft.AspNetCore.Hosting; using Microsoft.AspNetCore.Mvc; using NPOI.HSSF.UserModel; using SqlSugar; namespace CoreCms.Net.Web.Admin.Controllers { /// /// 地区表 /// [Description("地区表")] [Route("api/[controller]/[action]")] [ApiController] [RequiredErrorForAdmin] [Authorize(Permissions.Name)] public class CoreCmsAreaController : ControllerBase { private readonly ICoreCmsAreaServices _coreCmsAreaServices; private readonly IWebHostEnvironment _webHostEnvironment; /// /// 构造函数 /// /// /// public CoreCmsAreaController(IWebHostEnvironment webHostEnvironment, ICoreCmsAreaServices coreCmsAreaServices) { _webHostEnvironment = webHostEnvironment; _coreCmsAreaServices = coreCmsAreaServices; } #region 获取列表============================================================ // POST: Api/CoreCmsArea/GetAllList /// /// 获取列表 /// /// [HttpPost] [Description("获取列表")] public async Task GetAllList() { var jm = new AdminUiCallBack(); //获取数据 var list = await _coreCmsAreaServices.QueryListByClauseAsync(p => p.depth < 3); //返回数据 jm.data = list; jm.code = 0; jm.msg = "数据调用成功!"; return jm; } #endregion #region 获取列表============================================================ // POST: Api/CoreCmsArea/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 "parentId": orderEx = p => p.parentId; break; case "depth": orderEx = p => p.depth; break; case "name": orderEx = p => p.name; break; case "sort": orderEx = p => p.sort; 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 }; //查询筛选 //地区ID int var id = Request.Form["id"].FirstOrDefault().ObjectToInt(0); if (id > 0) @where = @where.And(p => p.id == id); //父级ID int var parentId = Request.Form["parentId"].FirstOrDefault().ObjectToInt(0); if (parentId > 0) @where = @where.And(p => p.parentId == parentId); //地区深度 int var depth = Request.Form["depth"].FirstOrDefault().ObjectToInt(0); if (depth > 0) @where = @where.And(p => p.depth == depth); //地区名称 nvarchar var name = Request.Form["name"].FirstOrDefault(); if (!string.IsNullOrEmpty(name)) @where = @where.And(p => p.name.Contains(name)); //地区排序 int var sort = Request.Form["sort"].FirstOrDefault().ObjectToInt(0); if (sort > 0) @where = @where.And(p => p.sort == sort); //获取数据 var list = await _coreCmsAreaServices.QueryPageAsync(where, orderEx, orderBy, pageCurrent, pageSize); //返回数据 jm.data = list; jm.code = 0; jm.count = list.TotalCount; jm.msg = "数据调用成功!"; return jm; } #endregion #region 首页数据============================================================ // POST: Api/CoreCmsArea/GetIndex /// /// 首页数据 /// /// [HttpPost] [Description("首页数据")] public AdminUiCallBack GetIndex() { //返回数据 var jm = new AdminUiCallBack { code = 0 }; return jm; } #endregion #region 创建数据============================================================ // POST: Api/CoreCmsArea/GetCreate /// /// 创建数据 /// /// [HttpPost] [Description("创建数据")] public async Task GetCreate([FromBody] FMIntId entity) { //返回数据 var jm = new AdminUiCallBack { code = 0 }; var parentModel = await _coreCmsAreaServices.QueryByClauseAsync(p => p.id == entity.id); jm.data = parentModel; return jm; } #endregion #region 创建提交============================================================ // POST: Api/CoreCmsArea/DoCreate /// /// 创建提交 /// /// /// [HttpPost] [Description("创建提交")] public async Task DoCreate([FromBody] CoreCmsArea entity) { var jm = await _coreCmsAreaServices.InsertAsync(entity); return jm; } #endregion #region 编辑数据============================================================ // POST: Api/CoreCmsArea/GetEdit /// /// 编辑数据 /// /// /// [HttpPost] [Description("编辑数据")] public async Task GetEdit([FromBody] FMIntId entity) { var jm = new AdminUiCallBack(); var model = await _coreCmsAreaServices.QueryByIdAsync(entity.id); if (model == null) { jm.msg = "不存在此信息"; return jm; } jm.code = 0; jm.data = model; return jm; } #endregion #region 编辑提交============================================================ // POST: Admins/CoreCmsArea/Edit /// /// 编辑提交 /// /// /// [HttpPost] [Description("编辑提交")] public async Task DoEdit([FromBody] CoreCmsArea entity) { var jm = await _coreCmsAreaServices.UpdateAsync(entity); return jm; } #endregion #region 删除数据============================================================ // POST: Api/CoreCmsArea/DoDelete/10 /// /// 单选删除 /// /// /// [HttpPost] [Description("单选删除")] public async Task DoDelete([FromBody] FMIntId entity) { var jm = new AdminUiCallBack(); var bl = await _coreCmsAreaServices.ExistsAsync(p => p.parentId == entity.id); if (bl) { jm.msg = GlobalConstVars.DeleteIsHaveChildren; return jm; } jm = await _coreCmsAreaServices.DeleteByIdAsync(entity.id); return jm; } #endregion } }