/*********************************************************************** * 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 Newtonsoft.Json; using Newtonsoft.Json.Linq; using SqlSugar; namespace CoreCms.Net.Web.Admin.Controllers { /// /// 配送方式表 /// [Description("配送方式表")] [Route("api/[controller]/[action]")] [ApiController] [RequiredErrorForAdmin] [Authorize(Permissions.Name)] public class CoreCmsShipController : ControllerBase { private readonly ICoreCmsShipServices _coreCmsShipServices; private readonly IWebHostEnvironment _webHostEnvironment; private readonly ICoreCmsLogisticsServices _logisticsServices; private readonly ICoreCmsAreaServices _areaServices; /// /// 构造函数 /// public CoreCmsShipController(IWebHostEnvironment webHostEnvironment , ICoreCmsShipServices coreCmsShipServices , ICoreCmsLogisticsServices logisticsServices, ICoreCmsAreaServices areaServices) { _webHostEnvironment = webHostEnvironment; _coreCmsShipServices = coreCmsShipServices; _logisticsServices = logisticsServices; _areaServices = areaServices; } #region 获取列表============================================================ // POST: Api/CoreCmsShip/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 "isCashOnDelivery": orderEx = p => p.isCashOnDelivery; break; case "firstUnit": orderEx = p => p.firstUnit; break; case "continueUnit": orderEx = p => p.continueUnit; break; case "isdefaultAreaFee": orderEx = p => p.isdefaultAreaFee; break; case "areaType": orderEx = p => p.areaType; break; case "firstunitPrice": orderEx = p => p.firstunitPrice; break; case "continueunitPrice": orderEx = p => p.continueunitPrice; break; case "exp": orderEx = p => p.exp; break; case "logiName": orderEx = p => p.logiName; break; case "logiCode": orderEx = p => p.logiCode; break; case "isDefault": orderEx = p => p.isDefault; break; case "sort": orderEx = p => p.sort; break; case "status": orderEx = p => p.status; break; case "isfreePostage": orderEx = p => p.isfreePostage; break; case "areaFee": orderEx = p => p.areaFee; break; case "goodsMoney": orderEx = p => p.goodsMoney; 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 isCashOnDelivery = Request.Form["isCashOnDelivery"].FirstOrDefault(); if (!string.IsNullOrEmpty(isCashOnDelivery) && isCashOnDelivery.ToLowerInvariant() == "true") @where = @where.And(p => p.isCashOnDelivery); else if (!string.IsNullOrEmpty(isCashOnDelivery) && isCashOnDelivery.ToLowerInvariant() == "false") @where = @where.And(p => p.isCashOnDelivery == false); //首重 int var firstUnit = Request.Form["firstUnit"].FirstOrDefault().ObjectToInt(0); if (firstUnit > 0) @where = @where.And(p => p.firstUnit == firstUnit); //续重 int var continueUnit = Request.Form["continueUnit"].FirstOrDefault().ObjectToInt(0); if (continueUnit > 0) @where = @where.And(p => p.continueUnit == continueUnit); //是否按地区设置配送费用是否启用默认配送费用 bit var isdefaultAreaFee = Request.Form["isdefaultAreaFee"].FirstOrDefault(); if (!string.IsNullOrEmpty(isdefaultAreaFee) && isdefaultAreaFee.ToLowerInvariant() == "true") @where = @where.And(p => p.isdefaultAreaFee); else if (!string.IsNullOrEmpty(isdefaultAreaFee) && isdefaultAreaFee.ToLowerInvariant() == "false") @where = @where.And(p => p.isdefaultAreaFee == false); //地区类型 int var areaType = Request.Form["areaType"].FirstOrDefault().ObjectToInt(0); if (areaType > 0) @where = @where.And(p => p.areaType == areaType); //配送费用计算表达式 nvarchar var exp = Request.Form["exp"].FirstOrDefault(); if (!string.IsNullOrEmpty(exp)) @where = @where.And(p => p.exp.Contains(exp)); //物流公司名称 nvarchar var logiName = Request.Form["logiName"].FirstOrDefault(); if (!string.IsNullOrEmpty(logiName)) @where = @where.And(p => p.logiName.Contains(logiName)); //物流公司编码 nvarchar var logiCode = Request.Form["logiCode"].FirstOrDefault(); if (!string.IsNullOrEmpty(logiCode)) @where = @where.And(p => p.logiCode.Contains(logiCode)); //是否默认 bit var isDefault = Request.Form["isDefault"].FirstOrDefault(); if (!string.IsNullOrEmpty(isDefault) && isDefault.ToLowerInvariant() == "true") @where = @where.And(p => p.isDefault); else if (!string.IsNullOrEmpty(isDefault) && isDefault.ToLowerInvariant() == "false") @where = @where.And(p => p.isDefault == false); //配送方式排序 越小越靠前 int var sort = Request.Form["sort"].FirstOrDefault().ObjectToInt(0); if (sort > 0) @where = @where.And(p => p.sort == sort); //状态 1=正常 2=停用 int var status = Request.Form["status"].FirstOrDefault().ObjectToInt(0); if (status > 0) @where = @where.And(p => p.status == status); //是否包邮 bit var isfreePostage = Request.Form["isfreePostage"].FirstOrDefault(); if (!string.IsNullOrEmpty(isfreePostage) && isfreePostage.ToLowerInvariant() == "true") @where = @where.And(p => p.isfreePostage); else if (!string.IsNullOrEmpty(isfreePostage) && isfreePostage.ToLowerInvariant() == "false") @where = @where.And(p => p.isfreePostage == false); //地区配送费用 nvarchar var areaFee = Request.Form["areaFee"].FirstOrDefault(); if (!string.IsNullOrEmpty(areaFee)) @where = @where.And(p => p.areaFee.Contains(areaFee)); //获取数据 var list = await _coreCmsShipServices.QueryPageAsync(where, orderEx, orderBy, pageCurrent, pageSize); //返回数据 jm.data = list; jm.code = 0; jm.count = list.TotalCount; jm.msg = "数据调用成功!"; return jm; } #endregion #region 首页数据============================================================ // POST: Api/CoreCmsShip/GetIndex /// /// 首页数据 /// /// [HttpPost] [Description("首页数据")] public AdminUiCallBack GetIndex() { //返回数据 var jm = new AdminUiCallBack { code = 0 }; return jm; } #endregion #region 创建数据============================================================ // POST: Api/CoreCmsShip/GetCreate /// /// 创建数据 /// /// [HttpPost] [Description("创建数据")] public async Task GetCreate() { //返回数据 var jm = new AdminUiCallBack { code = 0 }; var shipUnit = EnumHelper.EnumToList(); var logistics = await _logisticsServices.QueryListByClauseAsync(p => 1 == 1, p => p.sort, OrderByType.Asc); jm.data = new { shipUnit, logistics, }; return jm; } #endregion #region 创建提交============================================================ // POST: Api/CoreCmsShip/DoCreate /// /// 创建提交 /// /// /// [HttpPost] [Description("创建提交")] public async Task DoCreate([FromBody] CoreCmsShip entity) { var jm = await _coreCmsShipServices.InsertAsync(entity); return jm; } #endregion #region 编辑数据============================================================ // POST: Api/CoreCmsShip/GetEdit /// /// 编辑数据 /// /// /// [HttpPost] [Description("编辑数据")] public async Task GetEdit([FromBody] FMIntId entity) { var jm = new AdminUiCallBack(); var model = await _coreCmsShipServices.QueryByIdAsync(entity.id); if (model == null) { jm.msg = "不存在此信息"; return jm; } jm.code = 0; var shipUnit = EnumHelper.EnumToList(); var logistics = await _logisticsServices.QueryListByClauseAsync(p => true, p => p.sort, OrderByType.Asc); if (!string.IsNullOrEmpty(model.areaFee)) { model.areaFeeObj = JsonConvert.DeserializeObject(model.areaFee); } jm.data = new { shipUnit, logistics, model }; return jm; } #endregion #region 编辑提交============================================================ // POST: Api/CoreCmsShip/Edit /// /// 编辑提交 /// /// /// [HttpPost] [Description("编辑提交")] public async Task DoEdit([FromBody] CoreCmsShip entity) { var jm = await _coreCmsShipServices.UpdateAsync(entity); return jm; } #endregion #region 删除数据============================================================ // POST: Api/CoreCmsShip/DoDelete/10 /// /// 单选删除 /// /// /// [HttpPost] [Description("单选删除")] public async Task DoDelete([FromBody] FMIntId entity) { var jm = new AdminUiCallBack(); var model = await _coreCmsShipServices.ExistsAsync(p => p.id == entity.id, true); if (!model) { jm.msg = GlobalConstVars.DataisNo; return jm; } jm = await _coreCmsShipServices.DeleteByIdAsync(entity.id); return jm; } #endregion #region 设置是否货到付款============================================================ // POST: Api/CoreCmsShip/DoSetisCashOnDelivery/10 /// /// 设置是否货到付款 /// /// /// [HttpPost] [Description("设置是否货到付款")] public async Task DoSetisCashOnDelivery([FromBody] FMUpdateBoolDataByIntId entity) { var jm = new AdminUiCallBack(); var oldModel = await _coreCmsShipServices.QueryByIdAsync(entity.id, false); if (oldModel == null) { jm.msg = "不存在此信息"; return jm; } oldModel.isCashOnDelivery = (bool)entity.data; jm = await _coreCmsShipServices.UpdateAsync(oldModel); return jm; } #endregion #region 设置是否按地区设置配送费用============================================================ // POST: Api/CoreCmsShip/DoSetisdefaultAreaFee/10 /// /// 设置是否按地区设置配送费用 /// /// /// [HttpPost] [Description("设置是否按地区设置配送费用")] public async Task DoSetisdefaultAreaFee([FromBody] FMUpdateBoolDataByIntId entity) { var jm = new AdminUiCallBack(); var oldModel = await _coreCmsShipServices.QueryByIdAsync(entity.id, false); if (oldModel == null) { jm.msg = "不存在此信息"; return jm; } oldModel.isdefaultAreaFee = (bool)entity.data; jm = await _coreCmsShipServices.UpdateAsync(oldModel); return jm; } #endregion #region 设置是否默认============================================================ // POST: Api/CoreCmsShip/DoSetisDefault/10 /// /// 设置是否默认 /// /// /// [HttpPost] [Description("设置是否默认")] public async Task DoSetisDefault([FromBody] FMUpdateBoolDataByIntId entity) { var jm = new AdminUiCallBack(); var oldModel = await _coreCmsShipServices.QueryByIdAsync(entity.id, false); if (oldModel == null) { jm.msg = "不存在此信息"; return jm; } oldModel.isDefault = (bool)entity.data; jm = await _coreCmsShipServices.UpdateAsync(oldModel); return jm; } #endregion #region 设置是否包邮============================================================ // POST: Api/CoreCmsShip/DoSetisfreePostage/10 /// /// 设置是否包邮 /// /// /// [HttpPost] [Description("设置是否包邮")] public async Task DoSetisfreePostage([FromBody] FMUpdateBoolDataByIntId entity) { var jm = new AdminUiCallBack(); var oldModel = await _coreCmsShipServices.QueryByIdAsync(entity.id, false); if (oldModel == null) { jm.msg = "不存在此信息"; return jm; } oldModel.isfreePostage = (bool)entity.data; jm = await _coreCmsShipServices.UpdateAsync(oldModel); return jm; } #endregion } }