/*********************************************************************** * 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.Model.Entities; using CoreCms.Net.Model.Entities.Expression; 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 CoreCmsPinTuanRecordController : ControllerBase { private readonly ICoreCmsPinTuanRecordServices _coreCmsPinTuanRecordServices; private readonly IWebHostEnvironment _webHostEnvironment; /// /// 构造函数 /// /// /// public CoreCmsPinTuanRecordController(IWebHostEnvironment webHostEnvironment, ICoreCmsPinTuanRecordServices coreCmsPinTuanRecordServices) { _webHostEnvironment = webHostEnvironment; _coreCmsPinTuanRecordServices = coreCmsPinTuanRecordServices; } #region 获取列表============================================================ // POST: Api/CoreCmsPinTuanRecord/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(); where = where.And(p => p.id == p.teamId); //获取排序字段 var orderField = Request.Form["orderField"].FirstOrDefault(); Expression> orderEx; switch (orderField) { case "id": orderEx = p => p.id; break; case "teamId": orderEx = p => p.teamId; break; case "userId": orderEx = p => p.userId; break; case "ruleId": orderEx = p => p.ruleId; break; case "goodsId": orderEx = p => p.goodsId; break; case "status": orderEx = p => p.status; break; case "orderId": orderEx = p => p.orderId; break; case "parameters": orderEx = p => p.parameters; break; case "closeTime": orderEx = p => p.closeTime; break; case "createTime": orderEx = p => p.createTime; break; case "updateTime": orderEx = p => p.updateTime; 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); //团序列 int var teamId = Request.Form["teamId"].FirstOrDefault().ObjectToInt(0); if (teamId > 0) @where = @where.And(p => p.teamId == teamId); //用户序列 int var userId = Request.Form["userId"].FirstOrDefault().ObjectToInt(0); if (userId > 0) @where = @where.And(p => p.userId == userId); //规则表序列 int var ruleId = Request.Form["ruleId"].FirstOrDefault().ObjectToInt(0); if (ruleId > 0) @where = @where.And(p => p.ruleId == ruleId); //商品序列 int var goodsId = Request.Form["goodsId"].FirstOrDefault().ObjectToInt(0); if (goodsId > 0) @where = @where.And(p => p.goodsId == goodsId); //状态 int var status = Request.Form["status"].FirstOrDefault().ObjectToInt(0); if (status > 0) @where = @where.And(p => p.status == status); //订单序列 nvarchar var orderId = Request.Form["orderId"].FirstOrDefault(); if (!string.IsNullOrEmpty(orderId)) @where = @where.And(p => p.orderId.Contains(orderId)); //拼团人数Json nvarchar var parameters = Request.Form["parameters"].FirstOrDefault(); if (!string.IsNullOrEmpty(parameters)) @where = @where.And(p => p.parameters.Contains(parameters)); //关闭时间 datetime var closeTime = Request.Form["closeTime"].FirstOrDefault(); if (!string.IsNullOrEmpty(closeTime)) { if (closeTime.Contains("到")) { var dts = closeTime.Split("到"); var dtStart = dts[0].Trim().ObjectToDate(); where = where.And(p => p.closeTime > dtStart); var dtEnd = dts[1].Trim().ObjectToDate(); where = where.And(p => p.closeTime < dtEnd); } else { var dt = closeTime.ObjectToDate(); where = where.And(p => p.closeTime > dt); } } //创建时间 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); } } //更新时间 datetime var updateTime = Request.Form["updateTime"].FirstOrDefault(); if (!string.IsNullOrEmpty(updateTime)) { if (updateTime.Contains("到")) { var dts = updateTime.Split("到"); var dtStart = dts[0].Trim().ObjectToDate(); where = where.And(p => p.updateTime > dtStart); var dtEnd = dts[1].Trim().ObjectToDate(); where = where.And(p => p.updateTime < dtEnd); } else { var dt = updateTime.ObjectToDate(); where = where.And(p => p.updateTime > dt); } } //获取数据 var list = await _coreCmsPinTuanRecordServices.QueryPageAsync(where, orderEx, orderBy, pageCurrent, pageSize); //返回数据 jm.data = list; jm.code = 0; jm.count = list.TotalCount; jm.msg = "数据调用成功!"; return jm; } #endregion #region 首页数据============================================================ // POST: Api/CoreCmsPinTuanRecord/GetIndex /// /// 首页数据 /// /// [HttpPost] [Description("首页数据")] public AdminUiCallBack GetIndex() { //返回数据 var jm = new AdminUiCallBack { code = 0 }; var status = EnumHelper.EnumToList(); jm.data = new { status }; return jm; } #endregion } }