/*********************************************************************** * Project: baifenBinfa * ProjectName: 百分兵法管理系统 * Web: http://chuanyin.com * Author: * Email: * CreateTime: 2022/1/21 2:34:32 * 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.Model.Entities; using CoreCms.Net.Model.Entities.Expression; using CoreCms.Net.Model.FromBody; using CoreCms.Net.Model.ViewModels.UI; using CoreCms.Net.Filter; using CoreCms.Net.Loging; using CoreCms.Net.IServices; using CoreCms.Net.Utility.Helper; 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 CoreCmsOrderDistributionModelController : ControllerBase { private readonly IWebHostEnvironment _webHostEnvironment; private readonly ICoreCmsOrderDistributionModelServices _coreCmsOrderDistributionModelServices; /// /// 构造函数 /// public CoreCmsOrderDistributionModelController(IWebHostEnvironment webHostEnvironment , ICoreCmsOrderDistributionModelServices coreCmsOrderDistributionModelServices ) { _webHostEnvironment = webHostEnvironment; _coreCmsOrderDistributionModelServices = coreCmsOrderDistributionModelServices; } #region 获取列表============================================================ // POST: Api/CoreCmsOrderDistributionModel/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 = orderField switch { "id" => p => p.id, "orderType" => p => p.orderType, "description" => p => p.description, "isOpenMailing" => p => p.isOpenMailing, "isOpenHomeDelivery" => p => p.isOpenHomeDelivery, "isOpenSelfDelivery" => p => p.isOpenSelfDelivery, _ => p => p.id }; //设置排序方式 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 orderType = Request.Form["orderType"].FirstOrDefault().ObjectToInt(0); if (orderType > 0) { where = where.And(p => p.orderType == orderType); } //描述 nvarchar var description = Request.Form["description"].FirstOrDefault(); if (!string.IsNullOrEmpty(description)) { where = where.And(p => p.description.Contains(description)); } //物流快递 bit var isOpenMailing = Request.Form["isOpenMailing"].FirstOrDefault(); if (!string.IsNullOrEmpty(isOpenMailing) && isOpenMailing.ToLowerInvariant() == "true") { where = where.And(p => p.isOpenMailing == true); } else if (!string.IsNullOrEmpty(isOpenMailing) && isOpenMailing.ToLowerInvariant() == "false") { where = where.And(p => p.isOpenMailing == false); } //同城配送 bit var isOpenHomeDelivery = Request.Form["isOpenHomeDelivery"].FirstOrDefault(); if (!string.IsNullOrEmpty(isOpenHomeDelivery) && isOpenHomeDelivery.ToLowerInvariant() == "true") { where = where.And(p => p.isOpenHomeDelivery == true); } else if (!string.IsNullOrEmpty(isOpenHomeDelivery) && isOpenHomeDelivery.ToLowerInvariant() == "false") { where = where.And(p => p.isOpenHomeDelivery == false); } //上门自提 bit var isOpenSelfDelivery = Request.Form["isOpenSelfDelivery"].FirstOrDefault(); if (!string.IsNullOrEmpty(isOpenSelfDelivery) && isOpenSelfDelivery.ToLowerInvariant() == "true") { where = where.And(p => p.isOpenSelfDelivery == true); } else if (!string.IsNullOrEmpty(isOpenSelfDelivery) && isOpenSelfDelivery.ToLowerInvariant() == "false") { where = where.And(p => p.isOpenSelfDelivery == false); } //获取数据 var list = await _coreCmsOrderDistributionModelServices.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/CoreCmsOrderDistributionModel/GetIndex /// /// 首页数据 /// /// [HttpPost] [Description("首页数据")] public AdminUiCallBack GetIndex() { //返回数据 var jm = new AdminUiCallBack { code = 0 }; var orderTypes = EnumHelper.EnumToList(); jm.data = new { orderTypes }; return jm; } #endregion #region 创建数据============================================================ // POST: Api/CoreCmsOrderDistributionModel/GetCreate /// /// 创建数据 /// /// [HttpPost] [Description("创建数据")] public AdminUiCallBack GetCreate() { //返回数据 var jm = new AdminUiCallBack { code = 0 }; var orderTypes = EnumHelper.EnumToList(); jm.data = new { orderTypes }; return jm; } #endregion #region 创建提交============================================================ // POST: Api/CoreCmsOrderDistributionModel/DoCreate /// /// 创建提交 /// /// /// [HttpPost] [Description("创建提交")] public async Task DoCreate([FromBody] CoreCmsOrderDistributionModel entity) { var jm = new AdminUiCallBack(); var isHava = await _coreCmsOrderDistributionModelServices.ExistsAsync(p => p.orderType == entity.orderType); if (isHava) { jm.msg = "请勿录入重复类型数据"; return jm; } jm = await _coreCmsOrderDistributionModelServices.InsertAsync(entity); return jm; } #endregion #region 编辑数据============================================================ // POST: Api/CoreCmsOrderDistributionModel/GetEdit /// /// 编辑数据 /// /// /// [HttpPost] [Description("编辑数据")] public async Task GetEdit([FromBody] FMIntId entity) { var jm = new AdminUiCallBack(); var model = await _coreCmsOrderDistributionModelServices.QueryByIdAsync(entity.id, false); if (model == null) { jm.msg = "不存在此信息"; return jm; } jm.code = 0; var orderTypes = EnumHelper.EnumToList(); jm.data = new { orderTypes, model }; return jm; } #endregion #region 编辑提交============================================================ // POST: Api/CoreCmsOrderDistributionModel/Edit /// /// 编辑提交 /// /// /// [HttpPost] [Description("编辑提交")] public async Task DoEdit([FromBody] CoreCmsOrderDistributionModel entity) { var jm = await _coreCmsOrderDistributionModelServices.UpdateAsync(entity); return jm; } #endregion #region 删除数据============================================================ // POST: Api/CoreCmsOrderDistributionModel/DoDelete/10 /// /// 单选删除 /// /// /// [HttpPost] [Description("单选删除")] public async Task DoDelete([FromBody] FMIntId entity) { var jm = new AdminUiCallBack(); var model = await _coreCmsOrderDistributionModelServices.ExistsAsync(p => p.id == entity.id, true); if (!model) { jm.msg = GlobalConstVars.DataisNo; return jm; } jm = await _coreCmsOrderDistributionModelServices.DeleteByIdAsync(entity.id); return jm; } #endregion #region 设置物流快递============================================================ // POST: Api/CoreCmsOrderDistributionModel/DoSetisOpenMailing/10 /// /// 设置物流快递 /// /// /// [HttpPost] [Description("设置物流快递")] public async Task DoSetisOpenMailing([FromBody] FMUpdateBoolDataByIntId entity) { var jm = new AdminUiCallBack(); var oldModel = await _coreCmsOrderDistributionModelServices.QueryByIdAsync(entity.id, false); if (oldModel == null) { jm.msg = "不存在此信息"; return jm; } oldModel.isOpenMailing = (bool)entity.data; jm = await _coreCmsOrderDistributionModelServices.UpdateAsync(oldModel); return jm; } #endregion #region 设置同城配送============================================================ // POST: Api/CoreCmsOrderDistributionModel/DoSetisOpenHomeDelivery/10 /// /// 设置同城配送 /// /// /// [HttpPost] [Description("设置同城配送")] public async Task DoSetisOpenHomeDelivery([FromBody] FMUpdateBoolDataByIntId entity) { var jm = new AdminUiCallBack(); var oldModel = await _coreCmsOrderDistributionModelServices.QueryByIdAsync(entity.id, false); if (oldModel == null) { jm.msg = "不存在此信息"; return jm; } oldModel.isOpenHomeDelivery = (bool)entity.data; jm = await _coreCmsOrderDistributionModelServices.UpdateAsync(oldModel); return jm; } #endregion #region 设置上门自提============================================================ // POST: Api/CoreCmsOrderDistributionModel/DoSetisOpenSelfDelivery/10 /// /// 设置上门自提 /// /// /// [HttpPost] [Description("设置上门自提")] public async Task DoSetisOpenSelfDelivery([FromBody] FMUpdateBoolDataByIntId entity) { var jm = new AdminUiCallBack(); var oldModel = await _coreCmsOrderDistributionModelServices.QueryByIdAsync(entity.id, false); if (oldModel == null) { jm.msg = "不存在此信息"; return jm; } oldModel.isOpenSelfDelivery = (bool)entity.data; jm = await _coreCmsOrderDistributionModelServices.UpdateAsync(oldModel); return jm; } #endregion } }