/*********************************************************************** * Project: baifenBinfa * ProjectName: 百分兵法管理系统 * Web: http://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 CoreCmsSmsController : ControllerBase { private readonly ICoreCmsSmsServices _coreCmsSmsServices; private readonly IWebHostEnvironment _webHostEnvironment; /// /// 构造函数 /// /// /// public CoreCmsSmsController(IWebHostEnvironment webHostEnvironment, ICoreCmsSmsServices coreCmsSmsServices) { _webHostEnvironment = webHostEnvironment; _coreCmsSmsServices = coreCmsSmsServices; } #region 获取列表============================================================ // POST: Api/CoreCmsSms/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 "mobile": orderEx = p => p.mobile; break; case "code": orderEx = p => p.code; break; case "parameters": orderEx = p => p.parameters; break; case "contentBody": orderEx = p => p.contentBody; break; case "ip": orderEx = p => p.ip; break; case "isUsed": orderEx = p => p.isUsed; break; case "createTime": orderEx = p => p.createTime; 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 mobile = Request.Form["mobile"].FirstOrDefault(); if (!string.IsNullOrEmpty(mobile)) @where = @where.And(p => p.mobile.Contains(mobile)); //发送编码 nvarchar var code = Request.Form["code"].FirstOrDefault(); if (!string.IsNullOrEmpty(code)) @where = @where.And(p => p.code.Contains(code)); //参数 nvarchar var parameters = Request.Form["parameters"].FirstOrDefault(); if (!string.IsNullOrEmpty(parameters)) @where = @where.And(p => p.parameters.Contains(parameters)); //内容 nvarchar var contentBody = Request.Form["contentBody"].FirstOrDefault(); if (!string.IsNullOrEmpty(contentBody)) @where = @where.And(p => p.contentBody.Contains(contentBody)); //ip nvarchar var ip = Request.Form["ip"].FirstOrDefault(); if (!string.IsNullOrEmpty(ip)) @where = @where.And(p => p.ip.Contains(ip)); //是否使用 bit var isUsed = Request.Form["isUsed"].FirstOrDefault(); if (!string.IsNullOrEmpty(isUsed) && isUsed.ToLowerInvariant() == "true") @where = @where.And(p => p.isUsed); else if (!string.IsNullOrEmpty(isUsed) && isUsed.ToLowerInvariant() == "false") @where = @where.And(p => p.isUsed == false); //创建时间 datetime var createTime = Request.Form["createTime"].FirstOrDefault(); if (!string.IsNullOrEmpty(createTime)) { if (createTime.Contains("到")) { var dts = createTime.Split("到"); var dtStart = dts[0].Trim().ObjectToDate(); where = where.And(p => p.createTime > dtStart); var dtEnd = dts[1].Trim().ObjectToDate(); where = where.And(p => p.createTime < dtEnd); } else { var dt = createTime.ObjectToDate(); where = where.And(p => p.createTime > dt); } } //获取数据 var list = await _coreCmsSmsServices.QueryPageAsync(where, orderEx, orderBy, pageCurrent, pageSize); //返回数据 jm.data = list; jm.code = 0; jm.count = list.TotalCount; jm.msg = "数据调用成功!"; return jm; } #endregion #region 首页数据============================================================ // POST: Api/CoreCmsSms/GetIndex /// /// 首页数据 /// /// [HttpPost] [Description("首页数据")] public AdminUiCallBack GetIndex() { //返回数据 var jm = new AdminUiCallBack { code = 0 }; var smsMessageTypes = EnumHelper.EnumToList(); var platformMessageTypes = EnumHelper.EnumToList(); jm.data = new { smsMessageTypes, platformMessageTypes }; return jm; } #endregion #region 删除数据============================================================ // POST: Api/CoreCmsSms/DoDelete/10 /// /// 单选删除 /// /// /// [HttpPost] [Description("单选删除")] public async Task DoDelete([FromBody] FMIntId entity) { var jm = new AdminUiCallBack(); var model = await _coreCmsSmsServices.QueryByIdAsync(entity.id); if (model == null) { jm.msg = GlobalConstVars.DataisNo; return jm; } var bl = await _coreCmsSmsServices.DeleteByIdAsync(entity.id); jm.code = bl ? 0 : 1; jm.msg = bl ? GlobalConstVars.DeleteSuccess : GlobalConstVars.DeleteFailure; return jm; } #endregion #region 批量删除============================================================ // POST: Api/CoreCmsSms/DoBatchDelete/10,11,20 /// /// 批量删除 /// /// /// [HttpPost] [Description("批量删除")] public async Task DoBatchDelete([FromBody] FMArrayIntIds entity) { var jm = new AdminUiCallBack(); var bl = await _coreCmsSmsServices.DeleteByIdsAsync(entity.id); jm.code = bl ? 0 : 1; jm.msg = bl ? GlobalConstVars.DeleteSuccess : GlobalConstVars.DeleteFailure; return jm; } #endregion } }