/***********************************************************************
|
* Project: baifenBinfa
|
* ProjectName: 百分兵法管理系统
|
* Web: http://chuanyin.com
|
* Author:
|
* Email:
|
* CreateTime: 2024/7/31 14:49:41
|
* 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 Microsoft.AspNetCore.Authorization;
|
using Microsoft.AspNetCore.Hosting;
|
using Microsoft.AspNetCore.Mvc;
|
using NPOI.HSSF.UserModel;
|
using SqlSugar;
|
using CoreCms.Net.Web.Admin.Infrastructure;
|
using CoreCms.Net.Services;
|
|
namespace CoreCms.Net.Web.Admin.Controllers
|
{
|
/// <summary>
|
/// 商品表
|
///</summary>
|
[Description("商品表")]
|
[Route("api/[controller]/[action]")]
|
[ApiController]
|
[RequiredErrorForAdmin]
|
[Authorize(Permissions.Name)]
|
public class DistributionGoodsController : ControllerBase
|
{
|
private readonly IWebHostEnvironment _webHostEnvironment;
|
private readonly IDistributionGoodsServices _DistributionGoodsServices;
|
private readonly ICoreCmsGoodsCategoryServices _coreCmsGoodsCategoryServices;
|
private readonly ICoreCmsSettingServices _settingServices;
|
private readonly ICoreCmsBrandServices _brandServices;
|
|
/// <summary>
|
/// 构造函数
|
///</summary>
|
public DistributionGoodsController(IWebHostEnvironment webHostEnvironment
|
, IDistributionGoodsServices CoreCmsGoodsServices
|
,ICoreCmsGoodsCategoryServices CoreCmsGoodsCategoryServices
|
,ICoreCmsSettingServices CoreCmsSettingServices,
|
ICoreCmsBrandServices CoreCmsBrandServices
|
)
|
{
|
_webHostEnvironment = webHostEnvironment;
|
_DistributionGoodsServices = CoreCmsGoodsServices;
|
_coreCmsGoodsCategoryServices = CoreCmsGoodsCategoryServices;
|
_settingServices = CoreCmsSettingServices;
|
_brandServices=CoreCmsBrandServices;
|
|
}
|
|
#region 获取列表============================================================
|
// POST: Api/CoreCmsGoods/GetPageList
|
/// <summary>
|
/// 获取列表
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost]
|
[Description("获取列表")]
|
public async Task<AdminUiCallBack> 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<CoreCmsGoods>();
|
//获取排序字段
|
var orderField = Request.Form["orderField"].FirstOrDefault();
|
|
Expression<Func<CoreCmsGoods, object>> orderEx = orderField switch
|
{
|
"id" => p => p.id,"bn" => p => p.bn,"name" => p => p.name,"brief" => p => p.brief,"image" => p => p.image,"images" => p => p.images,"video" => p => p.video,"productsDistributionType" => p => p.productsDistributionType,"goodsCategoryId" => p => p.goodsCategoryId,"goodsTypeId" => p => p.goodsTypeId,"goodsSkuIds" => p => p.goodsSkuIds,"goodsParamsIds" => p => p.goodsParamsIds,"brandId" => p => p.brandId,"isNomalVirtual" => p => p.isNomalVirtual,"isMarketable" => p => p.isMarketable,"unit" => p => p.unit,"intro" => p => p.intro,"spesDesc" => p => p.spesDesc,"parameters" => p => p.parameters,"commentsCount" => p => p.commentsCount,"viewCount" => p => p.viewCount,"buyCount" => p => p.buyCount,"uptime" => p => p.uptime,"downtime" => p => p.downtime,"sort" => p => p.sort,"labelIds" => p => p.labelIds,"newSpec" => p => p.newSpec,"openSpec" => p => p.openSpec,"createTime" => p => p.createTime,"updateTime" => p => p.updateTime,"isRecommend" => p => p.isRecommend,"isHot" => p => p.isHot,"isDel" => p => p.isDel,"initialSales" => p => p.initialSales,"areaCode" => p => p.areaCode,"publisherId" => p => p.publisherId,"approverId" => p => p.approverId,"auditStatus" => p => p.auditStatus,"auditTime" => p => p.auditTime,
|
_ => p => p.id
|
};
|
|
//设置排序方式
|
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);
|
}
|
//商品条码 nvarchar
|
var bn = Request.Form["bn"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(bn))
|
{
|
where = where.And(p => p.bn.Contains(bn));
|
}
|
//商品名称 nvarchar
|
var name = Request.Form["name"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(name))
|
{
|
where = where.And(p => p.name.Contains(name));
|
}
|
//商品简介 nvarchar
|
var brief = Request.Form["brief"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(brief))
|
{
|
where = where.And(p => p.brief.Contains(brief));
|
}
|
//缩略图 nvarchar
|
var image = Request.Form["image"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(image))
|
{
|
where = where.And(p => p.image.Contains(image));
|
}
|
//图集 nvarchar
|
var images = Request.Form["images"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(images))
|
{
|
where = where.And(p => p.images.Contains(images));
|
}
|
//视频 nvarchar
|
var video = Request.Form["video"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(video))
|
{
|
where = where.And(p => p.video.Contains(video));
|
}
|
//佣金分配方式 int
|
var productsDistributionType = Request.Form["productsDistributionType"].FirstOrDefault().ObjectToInt(0);
|
if (productsDistributionType > 0)
|
{
|
where = where.And(p => p.productsDistributionType == productsDistributionType);
|
}
|
//商品分类 int
|
var goodsCategoryId = Request.Form["goodsCategoryId"].FirstOrDefault().ObjectToInt(0);
|
if (goodsCategoryId > 0)
|
{
|
where = where.And(p => p.goodsCategoryId == goodsCategoryId);
|
}
|
//商品类别 int
|
var goodsTypeId = Request.Form["goodsTypeId"].FirstOrDefault().ObjectToInt(0);
|
if (goodsTypeId > 0)
|
{
|
where = where.And(p => p.goodsTypeId == goodsTypeId);
|
}
|
//sku序列 nvarchar
|
var goodsSkuIds = Request.Form["goodsSkuIds"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(goodsSkuIds))
|
{
|
where = where.And(p => p.goodsSkuIds.Contains(goodsSkuIds));
|
}
|
//参数序列 nvarchar
|
var goodsParamsIds = Request.Form["goodsParamsIds"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(goodsParamsIds))
|
{
|
where = where.And(p => p.goodsParamsIds.Contains(goodsParamsIds));
|
}
|
//品牌 int
|
var brandId = Request.Form["brandId"].FirstOrDefault().ObjectToInt(0);
|
if (brandId > 0)
|
{
|
where = where.And(p => p.brandId == brandId);
|
}
|
//是否虚拟商品 bit
|
var isNomalVirtual = Request.Form["isNomalVirtual"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(isNomalVirtual) && isNomalVirtual.ToLowerInvariant() == "true")
|
{
|
where = where.And(p => p.isNomalVirtual == true);
|
}
|
else if (!string.IsNullOrEmpty(isNomalVirtual) && isNomalVirtual.ToLowerInvariant() == "false")
|
{
|
where = where.And(p => p.isNomalVirtual == false);
|
}
|
//是否上架 bit
|
var isMarketable = Request.Form["isMarketable"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(isMarketable) && isMarketable.ToLowerInvariant() == "true")
|
{
|
where = where.And(p => p.isMarketable == true);
|
}
|
else if (!string.IsNullOrEmpty(isMarketable) && isMarketable.ToLowerInvariant() == "false")
|
{
|
where = where.And(p => p.isMarketable == false);
|
}
|
//商品单位 nvarchar
|
var unit = Request.Form["unit"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(unit))
|
{
|
where = where.And(p => p.unit.Contains(unit));
|
}
|
//商品详情 nvarchar
|
var intro = Request.Form["intro"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(intro))
|
{
|
where = where.And(p => p.intro.Contains(intro));
|
}
|
//商品规格序列号存储 nvarchar
|
var spesDesc = Request.Form["spesDesc"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(spesDesc))
|
{
|
where = where.And(p => p.spesDesc.Contains(spesDesc));
|
}
|
//参数序列化 nvarchar
|
var parameters = Request.Form["parameters"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(parameters))
|
{
|
where = where.And(p => p.parameters.Contains(parameters));
|
}
|
//评论次数 int
|
var commentsCount = Request.Form["commentsCount"].FirstOrDefault().ObjectToInt(0);
|
if (commentsCount > 0)
|
{
|
where = where.And(p => p.commentsCount == commentsCount);
|
}
|
//浏览次数 int
|
var viewCount = Request.Form["viewCount"].FirstOrDefault().ObjectToInt(0);
|
if (viewCount > 0)
|
{
|
where = where.And(p => p.viewCount == viewCount);
|
}
|
//购买次数 int
|
var buyCount = Request.Form["buyCount"].FirstOrDefault().ObjectToInt(0);
|
if (buyCount > 0)
|
{
|
where = where.And(p => p.buyCount == buyCount);
|
}
|
//上架时间 datetime
|
var uptime = Request.Form["uptime"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(uptime))
|
{
|
if (uptime.Contains("到"))
|
{
|
var dts = uptime.Split("到");
|
var dtStart = dts[0].Trim().ObjectToDate();
|
where = where.And(p => p.uptime > dtStart);
|
var dtEnd = dts[1].Trim().ObjectToDate();
|
where = where.And(p => p.uptime < dtEnd);
|
}
|
else
|
{
|
var dt = uptime.ObjectToDate();
|
where = where.And(p => p.uptime > dt);
|
}
|
}
|
//下架时间 datetime
|
var downtime = Request.Form["downtime"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(downtime))
|
{
|
if (downtime.Contains("到"))
|
{
|
var dts = downtime.Split("到");
|
var dtStart = dts[0].Trim().ObjectToDate();
|
where = where.And(p => p.downtime > dtStart);
|
var dtEnd = dts[1].Trim().ObjectToDate();
|
where = where.And(p => p.downtime < dtEnd);
|
}
|
else
|
{
|
var dt = downtime.ObjectToDate();
|
where = where.And(p => p.downtime > dt);
|
}
|
}
|
//商品排序 int
|
var sort = Request.Form["sort"].FirstOrDefault().ObjectToInt(0);
|
if (sort > 0)
|
{
|
where = where.And(p => p.sort == sort);
|
}
|
//标签id逗号分隔 nvarchar
|
var labelIds = Request.Form["labelIds"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(labelIds))
|
{
|
where = where.And(p => p.labelIds.Contains(labelIds));
|
}
|
//自定义规格名称 nvarchar
|
var newSpec = Request.Form["newSpec"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(newSpec))
|
{
|
where = where.And(p => p.newSpec.Contains(newSpec));
|
}
|
//开启规则 int
|
var openSpec = Request.Form["openSpec"].FirstOrDefault().ObjectToInt(0);
|
if (openSpec > 0)
|
{
|
where = where.And(p => p.openSpec == openSpec);
|
}
|
//创建时间 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);
|
}
|
}
|
//是否推荐 bit
|
var isRecommend = Request.Form["isRecommend"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(isRecommend) && isRecommend.ToLowerInvariant() == "true")
|
{
|
where = where.And(p => p.isRecommend == true);
|
}
|
else if (!string.IsNullOrEmpty(isRecommend) && isRecommend.ToLowerInvariant() == "false")
|
{
|
where = where.And(p => p.isRecommend == false);
|
}
|
//是否热门 bit
|
var isHot = Request.Form["isHot"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(isHot) && isHot.ToLowerInvariant() == "true")
|
{
|
where = where.And(p => p.isHot == true);
|
}
|
else if (!string.IsNullOrEmpty(isHot) && isHot.ToLowerInvariant() == "false")
|
{
|
where = where.And(p => p.isHot == false);
|
}
|
//是否删除 bit
|
var isDel = Request.Form["isDel"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(isDel) && isDel.ToLowerInvariant() == "true")
|
{
|
where = where.And(p => p.isDel == true);
|
}
|
else if (!string.IsNullOrEmpty(isDel) && isDel.ToLowerInvariant() == "false")
|
{
|
where = where.And(p => p.isDel == false);
|
}
|
//初始销量 int
|
var initialSales = Request.Form["initialSales"].FirstOrDefault().ObjectToInt(0);
|
if (initialSales > 0)
|
{
|
where = where.And(p => p.initialSales == initialSales);
|
}
|
// nvarchar
|
var areaCode = Request.Form["areaCode"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(areaCode))
|
{
|
where = where.And(p => p.areaCode.Contains(areaCode));
|
}
|
// int
|
var publisherId = Request.Form["publisherId"].FirstOrDefault().ObjectToInt(0);
|
if (publisherId > 0)
|
{
|
where = where.And(p => p.publisherId == publisherId);
|
}
|
// int
|
var approverId = Request.Form["approverId"].FirstOrDefault().ObjectToInt(0);
|
if (approverId > 0)
|
{
|
where = where.And(p => p.approverId == approverId);
|
}
|
// int
|
var auditStatus = Request.Form["auditStatus"].FirstOrDefault().ObjectToInt(0);
|
if (auditStatus > 0)
|
{
|
where = where.And(p => p.auditStatus ==(AuditStatusType) auditStatus);
|
}
|
// datetime
|
var auditTime = Request.Form["auditTime"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(auditTime))
|
{
|
if (auditTime.Contains("到"))
|
{
|
var dts = auditTime.Split("到");
|
var dtStart = dts[0].Trim().ObjectToDate();
|
where = where.And(p => p.auditTime > dtStart);
|
var dtEnd = dts[1].Trim().ObjectToDate();
|
where = where.And(p => p.auditTime < dtEnd);
|
}
|
else
|
{
|
var dt = auditTime.ObjectToDate();
|
where = where.And(p => p.auditTime > dt);
|
}
|
}
|
//where = where.And(p => p.publisherId != null);
|
//获取数据
|
var list = await _DistributionGoodsServices.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/CoreCmsGoods/GetIndex
|
/// <summary>
|
/// 首页数据
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost]
|
[Description("首页数据")]
|
public async Task< AdminUiCallBack> GetIndex()
|
{
|
//返回数据
|
var jm = new AdminUiCallBack { code = 0 };
|
//获取商品分类
|
var categories = await _coreCmsGoodsCategoryServices.QueryListByClauseAsync(p => p.isShow, p => p.sort, OrderByType.Asc, true, true);
|
//获取品牌
|
var brands = await _brandServices.QueryAsync(true, true);
|
|
var auditStatusType = EnumHelper.EnumToList<AuditStatusType>();
|
jm.data = new
|
{
|
|
categories = GoodsHelper.GetTree(categories),
|
categoriesAll = categories,
|
brands,
|
auditStatusType
|
|
};
|
return jm;
|
}
|
#endregion
|
|
#region 创建数据============================================================
|
// POST: Api/CoreCmsGoods/GetCreate
|
/// <summary>
|
/// 创建数据
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost]
|
[Description("创建数据")]
|
public AdminUiCallBack GetCreate()
|
{
|
//返回数据
|
var jm = new AdminUiCallBack { code = 0 };
|
return jm;
|
}
|
#endregion
|
|
#region 创建提交============================================================
|
// POST: Api/CoreCmsGoods/DoCreate
|
/// <summary>
|
/// 创建提交
|
/// </summary>
|
/// <param name="entity"></param>
|
/// <returns></returns>
|
[HttpPost]
|
[Description("创建提交")]
|
public async Task<AdminUiCallBack> DoCreate([FromBody]CoreCmsGoods entity)
|
{
|
var jm = await _DistributionGoodsServices.InsertAsync(entity);
|
return jm;
|
}
|
#endregion
|
|
#region 编辑数据============================================================
|
// POST: Api/CoreCmsGoods/GetEdit
|
/// <summary>
|
/// 编辑数据
|
/// </summary>
|
/// <param name="entity"></param>
|
/// <returns></returns>
|
[HttpPost]
|
[Description("编辑数据")]
|
public async Task<AdminUiCallBack> GetEdit([FromBody]FMIntId entity)
|
{
|
|
|
var jm = await _DistributionGoodsServices.QueryID(entity.id);
|
|
return jm;
|
}
|
#endregion
|
|
#region 编辑提交============================================================
|
// POST: Api/CoreCmsGoods/Edit
|
/// <summary>
|
/// 编辑提交
|
/// </summary>
|
/// <param name="entity"></param>
|
/// <returns></returns>
|
[HttpPost]
|
[Description("编辑提交")]
|
public async Task<AdminUiCallBack> DoEdit([FromBody]CoreCmsGoods entity)
|
{
|
var jm = await _DistributionGoodsServices.UpdateAsync(entity);
|
return jm;
|
}
|
#endregion
|
|
#region 删除数据============================================================
|
// POST: Api/CoreCmsGoods/DoDelete/10
|
/// <summary>
|
/// 单选删除
|
/// </summary>
|
/// <param name="entity"></param>
|
/// <returns></returns>
|
[HttpPost]
|
[Description("单选删除")]
|
public async Task<AdminUiCallBack> DoDelete([FromBody]FMIntId entity)
|
{
|
var jm = new AdminUiCallBack();
|
|
var model = await _DistributionGoodsServices.ExistsAsync(p => p.id == entity.id, true);
|
if (!model)
|
{
|
jm.msg = GlobalConstVars.DataisNo;
|
return jm;
|
}
|
jm = await _DistributionGoodsServices.DeleteByIdAsync(entity.id);
|
|
return jm;
|
}
|
#endregion
|
|
#region 批量删除============================================================
|
// POST: Api/CoreCmsGoods/DoBatchDelete/10,11,20
|
/// <summary>
|
/// 批量删除
|
/// </summary>
|
/// <param name="entity"></param>
|
/// <returns></returns>
|
[HttpPost]
|
[Description("批量删除")]
|
public async Task<AdminUiCallBack> DoBatchDelete([FromBody]FMArrayIntIds entity)
|
{
|
var jm = await _DistributionGoodsServices.DeleteByIdsAsync(entity.id);
|
return jm;
|
}
|
|
#endregion
|
|
#region 预览数据============================================================
|
// POST: Api/CoreCmsGoods/GetDetails/10
|
/// <summary>
|
/// 预览数据
|
/// </summary>
|
/// <param name="entity"></param>
|
/// <returns></returns>
|
[HttpPost]
|
[Description("预览数据")]
|
public async Task<AdminUiCallBack> GetDetails([FromBody]FMIntId entity)
|
{
|
var jm = new AdminUiCallBack();
|
|
var model = await _DistributionGoodsServices.QueryByIdAsync(entity.id, false);
|
if (model == null)
|
{
|
jm.msg = "不存在此信息";
|
return jm;
|
}
|
jm.code = 0;
|
jm.data = model;
|
|
return jm;
|
}
|
#endregion
|
|
#region 选择导出============================================================
|
// POST: Api/CoreCmsGoods/SelectExportExcel/10
|
/// <summary>
|
/// 选择导出
|
/// </summary>
|
/// <param name="entity"></param>
|
/// <returns></returns>
|
[HttpPost]
|
[Description("选择导出")]
|
public async Task<AdminUiCallBack> SelectExportExcel([FromBody]FMArrayIntIds entity)
|
{
|
var jm = new AdminUiCallBack();
|
|
//创建Excel文件的对象
|
var book = new HSSFWorkbook();
|
//添加一个sheet
|
var mySheet = book.CreateSheet("Sheet1");
|
//获取list数据
|
var listModel = await _DistributionGoodsServices.QueryListByClauseAsync(p => entity.id.Contains(p.id), p => p.id, OrderByType.Asc, true);
|
//给sheet1添加第一行的头部标题
|
var headerRow = mySheet.CreateRow(0);
|
var headerStyle = ExcelHelper.GetHeaderStyle(book);
|
var cellNum = 0;
|
|
var cell0 = headerRow.CreateCell(cellNum);
|
cell0.SetCellValue("商品ID");
|
cell0.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell1 = headerRow.CreateCell(cellNum);
|
cell1.SetCellValue("商品条码");
|
cell1.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell2 = headerRow.CreateCell(cellNum);
|
cell2.SetCellValue("商品名称");
|
cell2.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell3 = headerRow.CreateCell(cellNum);
|
cell3.SetCellValue("商品简介");
|
cell3.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell4 = headerRow.CreateCell(cellNum);
|
cell4.SetCellValue("缩略图");
|
cell4.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell5 = headerRow.CreateCell(cellNum);
|
cell5.SetCellValue("图集");
|
cell5.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell6 = headerRow.CreateCell(cellNum);
|
cell6.SetCellValue("视频");
|
cell6.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell7 = headerRow.CreateCell(cellNum);
|
cell7.SetCellValue("佣金分配方式");
|
cell7.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell8 = headerRow.CreateCell(cellNum);
|
cell8.SetCellValue("商品分类");
|
cell8.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell9 = headerRow.CreateCell(cellNum);
|
cell9.SetCellValue("商品类别");
|
cell9.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell10 = headerRow.CreateCell(cellNum);
|
cell10.SetCellValue("sku序列");
|
cell10.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell11 = headerRow.CreateCell(cellNum);
|
cell11.SetCellValue("参数序列");
|
cell11.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell12 = headerRow.CreateCell(cellNum);
|
cell12.SetCellValue("品牌");
|
cell12.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell13 = headerRow.CreateCell(cellNum);
|
cell13.SetCellValue("是否虚拟商品");
|
cell13.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell14 = headerRow.CreateCell(cellNum);
|
cell14.SetCellValue("是否上架");
|
cell14.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell15 = headerRow.CreateCell(cellNum);
|
cell15.SetCellValue("商品单位");
|
cell15.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell16 = headerRow.CreateCell(cellNum);
|
cell16.SetCellValue("商品详情");
|
cell16.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell17 = headerRow.CreateCell(cellNum);
|
cell17.SetCellValue("商品规格序列号存储");
|
cell17.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell18 = headerRow.CreateCell(cellNum);
|
cell18.SetCellValue("参数序列化");
|
cell18.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell19 = headerRow.CreateCell(cellNum);
|
cell19.SetCellValue("评论次数");
|
cell19.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell20 = headerRow.CreateCell(cellNum);
|
cell20.SetCellValue("浏览次数");
|
cell20.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell21 = headerRow.CreateCell(cellNum);
|
cell21.SetCellValue("购买次数");
|
cell21.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell22 = headerRow.CreateCell(cellNum);
|
cell22.SetCellValue("上架时间");
|
cell22.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell23 = headerRow.CreateCell(cellNum);
|
cell23.SetCellValue("下架时间");
|
cell23.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell24 = headerRow.CreateCell(cellNum);
|
cell24.SetCellValue("商品排序");
|
cell24.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell25 = headerRow.CreateCell(cellNum);
|
cell25.SetCellValue("标签id逗号分隔");
|
cell25.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell26 = headerRow.CreateCell(cellNum);
|
cell26.SetCellValue("自定义规格名称");
|
cell26.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell27 = headerRow.CreateCell(cellNum);
|
cell27.SetCellValue("开启规则");
|
cell27.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell28 = headerRow.CreateCell(cellNum);
|
cell28.SetCellValue("创建时间");
|
cell28.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell29 = headerRow.CreateCell(cellNum);
|
cell29.SetCellValue("更新时间");
|
cell29.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell30 = headerRow.CreateCell(cellNum);
|
cell30.SetCellValue("是否推荐");
|
cell30.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell31 = headerRow.CreateCell(cellNum);
|
cell31.SetCellValue("是否热门");
|
cell31.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell32 = headerRow.CreateCell(cellNum);
|
cell32.SetCellValue("是否删除");
|
cell32.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell33 = headerRow.CreateCell(cellNum);
|
cell33.SetCellValue("初始销量");
|
cell33.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell34 = headerRow.CreateCell(cellNum);
|
cell34.SetCellValue("");
|
cell34.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell35 = headerRow.CreateCell(cellNum);
|
cell35.SetCellValue("");
|
cell35.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell36 = headerRow.CreateCell(cellNum);
|
cell36.SetCellValue("");
|
cell36.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell37 = headerRow.CreateCell(cellNum);
|
cell37.SetCellValue("");
|
cell37.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell38 = headerRow.CreateCell(cellNum);
|
cell38.SetCellValue("");
|
cell38.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
headerRow.Height = 30 * 20;
|
var commonCellStyle = ExcelHelper.GetCommonStyle(book);
|
|
//将数据逐步写入sheet1各个行
|
for (var i = 0; i < listModel.Count; i++)
|
{
|
var rowTemp = mySheet.CreateRow(i + 1);
|
var cellNumTemp = 0;
|
|
var rowTemp0 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp0.SetCellValue(listModel[i].id.ToString());
|
rowTemp0.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp1 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp1.SetCellValue(listModel[i].bn.ToString());
|
rowTemp1.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp2 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp2.SetCellValue(listModel[i].name.ToString());
|
rowTemp2.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp3 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp3.SetCellValue(listModel[i].brief.ToString());
|
rowTemp3.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp4 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp4.SetCellValue(listModel[i].image.ToString());
|
rowTemp4.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp5 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp5.SetCellValue(listModel[i].images.ToString());
|
rowTemp5.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp6 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp6.SetCellValue(listModel[i].video.ToString());
|
rowTemp6.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp7 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp7.SetCellValue(listModel[i].productsDistributionType.ToString());
|
rowTemp7.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp8 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp8.SetCellValue(listModel[i].goodsCategoryId.ToString());
|
rowTemp8.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp9 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp9.SetCellValue(listModel[i].goodsTypeId.ToString());
|
rowTemp9.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp10 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp10.SetCellValue(listModel[i].goodsSkuIds.ToString());
|
rowTemp10.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp11 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp11.SetCellValue(listModel[i].goodsParamsIds.ToString());
|
rowTemp11.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp12 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp12.SetCellValue(listModel[i].brandId.ToString());
|
rowTemp12.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp13 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp13.SetCellValue(listModel[i].isNomalVirtual.ToString());
|
rowTemp13.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp14 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp14.SetCellValue(listModel[i].isMarketable.ToString());
|
rowTemp14.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp15 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp15.SetCellValue(listModel[i].unit.ToString());
|
rowTemp15.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp16 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp16.SetCellValue(listModel[i].intro.ToString());
|
rowTemp16.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp17 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp17.SetCellValue(listModel[i].spesDesc.ToString());
|
rowTemp17.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp18 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp18.SetCellValue(listModel[i].parameters.ToString());
|
rowTemp18.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp19 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp19.SetCellValue(listModel[i].commentsCount.ToString());
|
rowTemp19.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp20 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp20.SetCellValue(listModel[i].viewCount.ToString());
|
rowTemp20.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp21 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp21.SetCellValue(listModel[i].buyCount.ToString());
|
rowTemp21.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp22 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp22.SetCellValue(listModel[i].uptime.ToString());
|
rowTemp22.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp23 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp23.SetCellValue(listModel[i].downtime.ToString());
|
rowTemp23.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp24 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp24.SetCellValue(listModel[i].sort.ToString());
|
rowTemp24.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp25 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp25.SetCellValue(listModel[i].labelIds.ToString());
|
rowTemp25.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp26 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp26.SetCellValue(listModel[i].newSpec.ToString());
|
rowTemp26.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp27 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp27.SetCellValue(listModel[i].openSpec.ToString());
|
rowTemp27.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp28 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp28.SetCellValue(listModel[i].createTime.ToString());
|
rowTemp28.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp29 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp29.SetCellValue(listModel[i].updateTime.ToString());
|
rowTemp29.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp30 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp30.SetCellValue(listModel[i].isRecommend.ToString());
|
rowTemp30.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp31 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp31.SetCellValue(listModel[i].isHot.ToString());
|
rowTemp31.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp32 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp32.SetCellValue(listModel[i].isDel.ToString());
|
rowTemp32.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp33 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp33.SetCellValue(listModel[i].initialSales.ToString());
|
rowTemp33.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp34 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp34.SetCellValue(listModel[i].areaCode.ToString());
|
rowTemp34.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp35 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp35.SetCellValue(listModel[i].publisherId.ToString());
|
rowTemp35.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp36 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp36.SetCellValue(listModel[i].approverId.ToString());
|
rowTemp36.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp37 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp37.SetCellValue(listModel[i].auditStatus.ToString());
|
rowTemp37.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp38 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp38.SetCellValue(listModel[i].auditTime.ToString());
|
rowTemp38.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
}
|
// 导出excel
|
string webRootPath = _webHostEnvironment.WebRootPath;
|
string tpath = "/files/" + DateTime.Now.ToString("yyyy-MM-dd") + "/";
|
string fileName = DateTime.Now.ToString("yyyyMMddHHmmssfff") + "-CoreCmsGoods导出(选择结果).xls";
|
string filePath = webRootPath + tpath;
|
DirectoryInfo di = new DirectoryInfo(filePath);
|
if (!di.Exists)
|
{
|
di.Create();
|
}
|
FileStream fileHssf = new FileStream(filePath + fileName, FileMode.Create);
|
book.Write(fileHssf);
|
fileHssf.Close();
|
|
jm.code = 0;
|
jm.msg = GlobalConstVars.ExcelExportSuccess;
|
jm.data = tpath + fileName;
|
|
return jm;
|
}
|
#endregion
|
|
#region 查询导出============================================================
|
// POST: Api/CoreCmsGoods/QueryExportExcel/10
|
/// <summary>
|
/// 查询导出
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost]
|
[Description("查询导出")]
|
public async Task<AdminUiCallBack> QueryExportExcel()
|
{
|
var jm = new AdminUiCallBack();
|
|
var where = PredicateBuilder.True<CoreCmsGoods>();
|
//查询筛选
|
|
//商品ID int
|
var id = Request.Form["id"].FirstOrDefault().ObjectToInt(0);
|
if (id > 0)
|
{
|
where = where.And(p => p.id == id);
|
}
|
//商品条码 nvarchar
|
var bn = Request.Form["bn"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(bn))
|
{
|
where = where.And(p => p.bn.Contains(bn));
|
}
|
//商品名称 nvarchar
|
var name = Request.Form["name"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(name))
|
{
|
where = where.And(p => p.name.Contains(name));
|
}
|
//商品简介 nvarchar
|
var brief = Request.Form["brief"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(brief))
|
{
|
where = where.And(p => p.brief.Contains(brief));
|
}
|
//缩略图 nvarchar
|
var image = Request.Form["image"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(image))
|
{
|
where = where.And(p => p.image.Contains(image));
|
}
|
//图集 nvarchar
|
var images = Request.Form["images"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(images))
|
{
|
where = where.And(p => p.images.Contains(images));
|
}
|
//视频 nvarchar
|
var video = Request.Form["video"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(video))
|
{
|
where = where.And(p => p.video.Contains(video));
|
}
|
//佣金分配方式 int
|
var productsDistributionType = Request.Form["productsDistributionType"].FirstOrDefault().ObjectToInt(0);
|
if (productsDistributionType > 0)
|
{
|
where = where.And(p => p.productsDistributionType == productsDistributionType);
|
}
|
//商品分类 int
|
var goodsCategoryId = Request.Form["goodsCategoryId"].FirstOrDefault().ObjectToInt(0);
|
if (goodsCategoryId > 0)
|
{
|
where = where.And(p => p.goodsCategoryId == goodsCategoryId);
|
}
|
//商品类别 int
|
var goodsTypeId = Request.Form["goodsTypeId"].FirstOrDefault().ObjectToInt(0);
|
if (goodsTypeId > 0)
|
{
|
where = where.And(p => p.goodsTypeId == goodsTypeId);
|
}
|
//sku序列 nvarchar
|
var goodsSkuIds = Request.Form["goodsSkuIds"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(goodsSkuIds))
|
{
|
where = where.And(p => p.goodsSkuIds.Contains(goodsSkuIds));
|
}
|
//参数序列 nvarchar
|
var goodsParamsIds = Request.Form["goodsParamsIds"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(goodsParamsIds))
|
{
|
where = where.And(p => p.goodsParamsIds.Contains(goodsParamsIds));
|
}
|
//品牌 int
|
var brandId = Request.Form["brandId"].FirstOrDefault().ObjectToInt(0);
|
if (brandId > 0)
|
{
|
where = where.And(p => p.brandId == brandId);
|
}
|
//是否虚拟商品 bit
|
var isNomalVirtual = Request.Form["isNomalVirtual"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(isNomalVirtual) && isNomalVirtual.ToLowerInvariant() == "true")
|
{
|
where = where.And(p => p.isNomalVirtual == true);
|
}
|
else if (!string.IsNullOrEmpty(isNomalVirtual) && isNomalVirtual.ToLowerInvariant() == "false")
|
{
|
where = where.And(p => p.isNomalVirtual == false);
|
}
|
//是否上架 bit
|
var isMarketable = Request.Form["isMarketable"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(isMarketable) && isMarketable.ToLowerInvariant() == "true")
|
{
|
where = where.And(p => p.isMarketable == true);
|
}
|
else if (!string.IsNullOrEmpty(isMarketable) && isMarketable.ToLowerInvariant() == "false")
|
{
|
where = where.And(p => p.isMarketable == false);
|
}
|
//商品单位 nvarchar
|
var unit = Request.Form["unit"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(unit))
|
{
|
where = where.And(p => p.unit.Contains(unit));
|
}
|
//商品详情 nvarchar
|
var intro = Request.Form["intro"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(intro))
|
{
|
where = where.And(p => p.intro.Contains(intro));
|
}
|
//商品规格序列号存储 nvarchar
|
var spesDesc = Request.Form["spesDesc"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(spesDesc))
|
{
|
where = where.And(p => p.spesDesc.Contains(spesDesc));
|
}
|
//参数序列化 nvarchar
|
var parameters = Request.Form["parameters"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(parameters))
|
{
|
where = where.And(p => p.parameters.Contains(parameters));
|
}
|
//评论次数 int
|
var commentsCount = Request.Form["commentsCount"].FirstOrDefault().ObjectToInt(0);
|
if (commentsCount > 0)
|
{
|
where = where.And(p => p.commentsCount == commentsCount);
|
}
|
//浏览次数 int
|
var viewCount = Request.Form["viewCount"].FirstOrDefault().ObjectToInt(0);
|
if (viewCount > 0)
|
{
|
where = where.And(p => p.viewCount == viewCount);
|
}
|
//购买次数 int
|
var buyCount = Request.Form["buyCount"].FirstOrDefault().ObjectToInt(0);
|
if (buyCount > 0)
|
{
|
where = where.And(p => p.buyCount == buyCount);
|
}
|
//上架时间 datetime
|
var uptime = Request.Form["uptime"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(uptime))
|
{
|
if (uptime.Contains("到"))
|
{
|
var dts = uptime.Split("到");
|
var dtStart = dts[0].Trim().ObjectToDate();
|
where = where.And(p => p.uptime > dtStart);
|
var dtEnd = dts[1].Trim().ObjectToDate();
|
where = where.And(p => p.uptime < dtEnd);
|
}
|
else
|
{
|
var dt = uptime.ObjectToDate();
|
where = where.And(p => p.uptime > dt);
|
}
|
}
|
//下架时间 datetime
|
var downtime = Request.Form["downtime"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(downtime))
|
{
|
if (downtime.Contains("到"))
|
{
|
var dts = downtime.Split("到");
|
var dtStart = dts[0].Trim().ObjectToDate();
|
where = where.And(p => p.downtime > dtStart);
|
var dtEnd = dts[1].Trim().ObjectToDate();
|
where = where.And(p => p.downtime < dtEnd);
|
}
|
else
|
{
|
var dt = downtime.ObjectToDate();
|
where = where.And(p => p.downtime > dt);
|
}
|
}
|
//商品排序 int
|
var sort = Request.Form["sort"].FirstOrDefault().ObjectToInt(0);
|
if (sort > 0)
|
{
|
where = where.And(p => p.sort == sort);
|
}
|
//标签id逗号分隔 nvarchar
|
var labelIds = Request.Form["labelIds"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(labelIds))
|
{
|
where = where.And(p => p.labelIds.Contains(labelIds));
|
}
|
//自定义规格名称 nvarchar
|
var newSpec = Request.Form["newSpec"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(newSpec))
|
{
|
where = where.And(p => p.newSpec.Contains(newSpec));
|
}
|
//开启规则 int
|
var openSpec = Request.Form["openSpec"].FirstOrDefault().ObjectToInt(0);
|
if (openSpec > 0)
|
{
|
where = where.And(p => p.openSpec == openSpec);
|
}
|
//创建时间 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);
|
}
|
}
|
//是否推荐 bit
|
var isRecommend = Request.Form["isRecommend"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(isRecommend) && isRecommend.ToLowerInvariant() == "true")
|
{
|
where = where.And(p => p.isRecommend == true);
|
}
|
else if (!string.IsNullOrEmpty(isRecommend) && isRecommend.ToLowerInvariant() == "false")
|
{
|
where = where.And(p => p.isRecommend == false);
|
}
|
//是否热门 bit
|
var isHot = Request.Form["isHot"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(isHot) && isHot.ToLowerInvariant() == "true")
|
{
|
where = where.And(p => p.isHot == true);
|
}
|
else if (!string.IsNullOrEmpty(isHot) && isHot.ToLowerInvariant() == "false")
|
{
|
where = where.And(p => p.isHot == false);
|
}
|
//是否删除 bit
|
var isDel = Request.Form["isDel"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(isDel) && isDel.ToLowerInvariant() == "true")
|
{
|
where = where.And(p => p.isDel == true);
|
}
|
else if (!string.IsNullOrEmpty(isDel) && isDel.ToLowerInvariant() == "false")
|
{
|
where = where.And(p => p.isDel == false);
|
}
|
//初始销量 int
|
var initialSales = Request.Form["initialSales"].FirstOrDefault().ObjectToInt(0);
|
if (initialSales > 0)
|
{
|
where = where.And(p => p.initialSales == initialSales);
|
}
|
// nvarchar
|
var areaCode = Request.Form["areaCode"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(areaCode))
|
{
|
where = where.And(p => p.areaCode.Contains(areaCode));
|
}
|
// int
|
var publisherId = Request.Form["publisherId"].FirstOrDefault().ObjectToInt(0);
|
if (publisherId > 0)
|
{
|
where = where.And(p => p.publisherId == publisherId);
|
}
|
// int
|
var approverId = Request.Form["approverId"].FirstOrDefault().ObjectToInt(0);
|
if (approverId > 0)
|
{
|
where = where.And(p => p.approverId == approverId);
|
}
|
// int
|
var auditStatus = Request.Form["auditStatus"].FirstOrDefault().ObjectToInt(0);
|
if (auditStatus > 0)
|
{
|
where = where.And(p => p.auditStatus == (AuditStatusType)auditStatus);
|
}
|
// datetime
|
var auditTime = Request.Form["auditTime"].FirstOrDefault();
|
if (!string.IsNullOrEmpty(auditTime))
|
{
|
if (auditTime.Contains("到"))
|
{
|
var dts = auditTime.Split("到");
|
var dtStart = dts[0].Trim().ObjectToDate();
|
where = where.And(p => p.auditTime > dtStart);
|
var dtEnd = dts[1].Trim().ObjectToDate();
|
where = where.And(p => p.auditTime < dtEnd);
|
}
|
else
|
{
|
var dt = auditTime.ObjectToDate();
|
where = where.And(p => p.auditTime > dt);
|
}
|
}
|
//获取数据
|
//创建Excel文件的对象
|
var book = new HSSFWorkbook();
|
//添加一个sheet
|
var mySheet = book.CreateSheet("Sheet1");
|
//获取list数据
|
var listModel = await _DistributionGoodsServices.QueryListByClauseAsync(where, p => p.id, OrderByType.Asc, true);
|
//给sheet1添加第一行的头部标题
|
var headerRow = mySheet.CreateRow(0);
|
var headerStyle = ExcelHelper.GetHeaderStyle(book);
|
var cellNum = 0;
|
|
var cell0 = headerRow.CreateCell(cellNum);
|
cell0.SetCellValue("商品ID");
|
cell0.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell1 = headerRow.CreateCell(cellNum);
|
cell1.SetCellValue("商品条码");
|
cell1.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell2 = headerRow.CreateCell(cellNum);
|
cell2.SetCellValue("商品名称");
|
cell2.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell3 = headerRow.CreateCell(cellNum);
|
cell3.SetCellValue("商品简介");
|
cell3.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell4 = headerRow.CreateCell(cellNum);
|
cell4.SetCellValue("缩略图");
|
cell4.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell5 = headerRow.CreateCell(cellNum);
|
cell5.SetCellValue("图集");
|
cell5.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell6 = headerRow.CreateCell(cellNum);
|
cell6.SetCellValue("视频");
|
cell6.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell7 = headerRow.CreateCell(cellNum);
|
cell7.SetCellValue("佣金分配方式");
|
cell7.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell8 = headerRow.CreateCell(cellNum);
|
cell8.SetCellValue("商品分类");
|
cell8.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell9 = headerRow.CreateCell(cellNum);
|
cell9.SetCellValue("商品类别");
|
cell9.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell10 = headerRow.CreateCell(cellNum);
|
cell10.SetCellValue("sku序列");
|
cell10.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell11 = headerRow.CreateCell(cellNum);
|
cell11.SetCellValue("参数序列");
|
cell11.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell12 = headerRow.CreateCell(cellNum);
|
cell12.SetCellValue("品牌");
|
cell12.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell13 = headerRow.CreateCell(cellNum);
|
cell13.SetCellValue("是否虚拟商品");
|
cell13.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell14 = headerRow.CreateCell(cellNum);
|
cell14.SetCellValue("是否上架");
|
cell14.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell15 = headerRow.CreateCell(cellNum);
|
cell15.SetCellValue("商品单位");
|
cell15.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell16 = headerRow.CreateCell(cellNum);
|
cell16.SetCellValue("商品详情");
|
cell16.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell17 = headerRow.CreateCell(cellNum);
|
cell17.SetCellValue("商品规格序列号存储");
|
cell17.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell18 = headerRow.CreateCell(cellNum);
|
cell18.SetCellValue("参数序列化");
|
cell18.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell19 = headerRow.CreateCell(cellNum);
|
cell19.SetCellValue("评论次数");
|
cell19.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell20 = headerRow.CreateCell(cellNum);
|
cell20.SetCellValue("浏览次数");
|
cell20.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell21 = headerRow.CreateCell(cellNum);
|
cell21.SetCellValue("购买次数");
|
cell21.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell22 = headerRow.CreateCell(cellNum);
|
cell22.SetCellValue("上架时间");
|
cell22.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell23 = headerRow.CreateCell(cellNum);
|
cell23.SetCellValue("下架时间");
|
cell23.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell24 = headerRow.CreateCell(cellNum);
|
cell24.SetCellValue("商品排序");
|
cell24.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell25 = headerRow.CreateCell(cellNum);
|
cell25.SetCellValue("标签id逗号分隔");
|
cell25.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell26 = headerRow.CreateCell(cellNum);
|
cell26.SetCellValue("自定义规格名称");
|
cell26.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell27 = headerRow.CreateCell(cellNum);
|
cell27.SetCellValue("开启规则");
|
cell27.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell28 = headerRow.CreateCell(cellNum);
|
cell28.SetCellValue("创建时间");
|
cell28.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell29 = headerRow.CreateCell(cellNum);
|
cell29.SetCellValue("更新时间");
|
cell29.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell30 = headerRow.CreateCell(cellNum);
|
cell30.SetCellValue("是否推荐");
|
cell30.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell31 = headerRow.CreateCell(cellNum);
|
cell31.SetCellValue("是否热门");
|
cell31.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell32 = headerRow.CreateCell(cellNum);
|
cell32.SetCellValue("是否删除");
|
cell32.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell33 = headerRow.CreateCell(cellNum);
|
cell33.SetCellValue("初始销量");
|
cell33.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell34 = headerRow.CreateCell(cellNum);
|
cell34.SetCellValue("");
|
cell34.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell35 = headerRow.CreateCell(cellNum);
|
cell35.SetCellValue("");
|
cell35.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell36 = headerRow.CreateCell(cellNum);
|
cell36.SetCellValue("");
|
cell36.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell37 = headerRow.CreateCell(cellNum);
|
cell37.SetCellValue("");
|
cell37.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
var cell38 = headerRow.CreateCell(cellNum);
|
cell38.SetCellValue("");
|
cell38.CellStyle = headerStyle;
|
mySheet.SetColumnWidth(cellNum, 10 * 256);
|
cellNum++;
|
|
|
headerRow.Height = 30 * 20;
|
var commonCellStyle = ExcelHelper.GetCommonStyle(book);
|
|
//将数据逐步写入sheet1各个行
|
for (var i = 0; i < listModel.Count; i++)
|
{
|
var rowTemp = mySheet.CreateRow(i + 1);
|
var cellNumTemp = 0;
|
|
var rowTemp0 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp0.SetCellValue(listModel[i].id.ToString());
|
rowTemp0.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp1 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp1.SetCellValue(listModel[i].bn.ToString());
|
rowTemp1.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp2 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp2.SetCellValue(listModel[i].name.ToString());
|
rowTemp2.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp3 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp3.SetCellValue(listModel[i].brief.ToString());
|
rowTemp3.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp4 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp4.SetCellValue(listModel[i].image.ToString());
|
rowTemp4.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp5 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp5.SetCellValue(listModel[i].images.ToString());
|
rowTemp5.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp6 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp6.SetCellValue(listModel[i].video.ToString());
|
rowTemp6.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp7 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp7.SetCellValue(listModel[i].productsDistributionType.ToString());
|
rowTemp7.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp8 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp8.SetCellValue(listModel[i].goodsCategoryId.ToString());
|
rowTemp8.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp9 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp9.SetCellValue(listModel[i].goodsTypeId.ToString());
|
rowTemp9.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp10 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp10.SetCellValue(listModel[i].goodsSkuIds.ToString());
|
rowTemp10.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp11 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp11.SetCellValue(listModel[i].goodsParamsIds.ToString());
|
rowTemp11.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp12 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp12.SetCellValue(listModel[i].brandId.ToString());
|
rowTemp12.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp13 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp13.SetCellValue(listModel[i].isNomalVirtual.ToString());
|
rowTemp13.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp14 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp14.SetCellValue(listModel[i].isMarketable.ToString());
|
rowTemp14.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp15 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp15.SetCellValue(listModel[i].unit.ToString());
|
rowTemp15.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp16 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp16.SetCellValue(listModel[i].intro.ToString());
|
rowTemp16.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp17 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp17.SetCellValue(listModel[i].spesDesc.ToString());
|
rowTemp17.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp18 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp18.SetCellValue(listModel[i].parameters.ToString());
|
rowTemp18.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp19 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp19.SetCellValue(listModel[i].commentsCount.ToString());
|
rowTemp19.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp20 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp20.SetCellValue(listModel[i].viewCount.ToString());
|
rowTemp20.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp21 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp21.SetCellValue(listModel[i].buyCount.ToString());
|
rowTemp21.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp22 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp22.SetCellValue(listModel[i].uptime.ToString());
|
rowTemp22.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp23 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp23.SetCellValue(listModel[i].downtime.ToString());
|
rowTemp23.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp24 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp24.SetCellValue(listModel[i].sort.ToString());
|
rowTemp24.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp25 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp25.SetCellValue(listModel[i].labelIds.ToString());
|
rowTemp25.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp26 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp26.SetCellValue(listModel[i].newSpec.ToString());
|
rowTemp26.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp27 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp27.SetCellValue(listModel[i].openSpec.ToString());
|
rowTemp27.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp28 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp28.SetCellValue(listModel[i].createTime.ToString());
|
rowTemp28.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp29 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp29.SetCellValue(listModel[i].updateTime.ToString());
|
rowTemp29.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp30 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp30.SetCellValue(listModel[i].isRecommend.ToString());
|
rowTemp30.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp31 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp31.SetCellValue(listModel[i].isHot.ToString());
|
rowTemp31.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp32 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp32.SetCellValue(listModel[i].isDel.ToString());
|
rowTemp32.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp33 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp33.SetCellValue(listModel[i].initialSales.ToString());
|
rowTemp33.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp34 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp34.SetCellValue(listModel[i].areaCode.ToString());
|
rowTemp34.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp35 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp35.SetCellValue(listModel[i].publisherId.ToString());
|
rowTemp35.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp36 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp36.SetCellValue(listModel[i].approverId.ToString());
|
rowTemp36.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp37 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp37.SetCellValue(listModel[i].auditStatus.ToString());
|
rowTemp37.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
var rowTemp38 = rowTemp.CreateCell(cellNumTemp);
|
rowTemp38.SetCellValue(listModel[i].auditTime.ToString());
|
rowTemp38.CellStyle = commonCellStyle;
|
cellNumTemp++;
|
|
}
|
// 写入到excel
|
string webRootPath = _webHostEnvironment.WebRootPath;
|
string tpath = "/files/" + DateTime.Now.ToString("yyyy-MM-dd") + "/";
|
string fileName = DateTime.Now.ToString("yyyyMMddHHmmssfff") + "-CoreCmsGoods导出(查询结果).xls";
|
string filePath = webRootPath + tpath;
|
DirectoryInfo di = new DirectoryInfo(filePath);
|
if (!di.Exists)
|
{
|
di.Create();
|
}
|
FileStream fileHssf = new FileStream(filePath + fileName, FileMode.Create);
|
book.Write(fileHssf);
|
fileHssf.Close();
|
|
jm.code = 0;
|
jm.msg = GlobalConstVars.ExcelExportSuccess;
|
jm.data = tpath + fileName;
|
|
return jm;
|
}
|
#endregion
|
|
|
#region 设置是否虚拟商品============================================================
|
// POST: Api/CoreCmsGoods/DoSetisNomalVirtual/10
|
/// <summary>
|
/// 设置是否虚拟商品
|
/// </summary>
|
/// <param name="entity"></param>
|
/// <returns></returns>
|
[HttpPost]
|
[Description("设置是否虚拟商品")]
|
public async Task<AdminUiCallBack> DoSetisNomalVirtual([FromBody]FMUpdateBoolDataByIntId entity)
|
{
|
var jm = new AdminUiCallBack();
|
|
var oldModel = await _DistributionGoodsServices.QueryByIdAsync(entity.id, false);
|
if (oldModel == null)
|
{
|
jm.msg = "不存在此信息";
|
return jm;
|
}
|
oldModel.isNomalVirtual = (bool)entity.data;
|
|
var bl = await _DistributionGoodsServices.UpdateAsync(p => new CoreCmsGoods() { isNomalVirtual = oldModel.isNomalVirtual }, p => p.id == oldModel.id);
|
jm.code = bl ? 0 : 1;
|
jm.msg = bl ? GlobalConstVars.EditSuccess : GlobalConstVars.EditFailure;
|
|
return jm;
|
}
|
#endregion
|
|
#region 设置是否上架============================================================
|
// POST: Api/CoreCmsGoods/DoSetisMarketable/10
|
/// <summary>
|
/// 设置是否上架
|
/// </summary>
|
/// <param name="entity"></param>
|
/// <returns></returns>
|
[HttpPost]
|
[Description("设置是否上架")]
|
public async Task<AdminUiCallBack> DoSetisMarketable([FromBody]FMUpdateBoolDataByIntId entity)
|
{
|
var jm = new AdminUiCallBack();
|
|
var oldModel = await _DistributionGoodsServices.QueryByIdAsync(entity.id, false);
|
if (oldModel == null)
|
{
|
jm.msg = "不存在此信息";
|
return jm;
|
}
|
oldModel.isMarketable = (bool)entity.data;
|
|
var bl = await _DistributionGoodsServices.UpdateAsync(p => new CoreCmsGoods() { isMarketable = oldModel.isMarketable }, p => p.id == oldModel.id);
|
jm.code = bl ? 0 : 1;
|
jm.msg = bl ? GlobalConstVars.EditSuccess : GlobalConstVars.EditFailure;
|
|
return jm;
|
}
|
#endregion
|
|
#region 设置是否推荐============================================================
|
// POST: Api/CoreCmsGoods/DoSetisRecommend/10
|
/// <summary>
|
/// 设置是否推荐
|
/// </summary>
|
/// <param name="entity"></param>
|
/// <returns></returns>
|
[HttpPost]
|
[Description("设置是否推荐")]
|
public async Task<AdminUiCallBack> DoSetisRecommend([FromBody]FMUpdateBoolDataByIntId entity)
|
{
|
var jm = new AdminUiCallBack();
|
|
var oldModel = await _DistributionGoodsServices.QueryByIdAsync(entity.id, false);
|
if (oldModel == null)
|
{
|
jm.msg = "不存在此信息";
|
return jm;
|
}
|
oldModel.isRecommend = (bool)entity.data;
|
|
var bl = await _DistributionGoodsServices.UpdateAsync(p => new CoreCmsGoods() { isRecommend = oldModel.isRecommend }, p => p.id == oldModel.id);
|
jm.code = bl ? 0 : 1;
|
jm.msg = bl ? GlobalConstVars.EditSuccess : GlobalConstVars.EditFailure;
|
|
return jm;
|
}
|
#endregion
|
|
#region 设置是否热门============================================================
|
// POST: Api/CoreCmsGoods/DoSetisHot/10
|
/// <summary>
|
/// 设置是否热门
|
/// </summary>
|
/// <param name="entity"></param>
|
/// <returns></returns>
|
[HttpPost]
|
[Description("设置是否热门")]
|
public async Task<AdminUiCallBack> DoSetisHot([FromBody]FMUpdateBoolDataByIntId entity)
|
{
|
var jm = new AdminUiCallBack();
|
|
var oldModel = await _DistributionGoodsServices.QueryByIdAsync(entity.id, false);
|
if (oldModel == null)
|
{
|
jm.msg = "不存在此信息";
|
return jm;
|
}
|
oldModel.isHot = (bool)entity.data;
|
|
var bl = await _DistributionGoodsServices.UpdateAsync(p => new CoreCmsGoods() { isHot = oldModel.isHot }, p => p.id == oldModel.id);
|
jm.code = bl ? 0 : 1;
|
jm.msg = bl ? GlobalConstVars.EditSuccess : GlobalConstVars.EditFailure;
|
|
return jm;
|
}
|
#endregion
|
|
#region 设置是否删除============================================================
|
// POST: Api/CoreCmsGoods/DoSetisDel/10
|
/// <summary>
|
/// 设置是否删除
|
/// </summary>
|
/// <param name="entity"></param>
|
/// <returns></returns>
|
[HttpPost]
|
[Description("设置是否删除")]
|
public async Task<AdminUiCallBack> DoSetisDel([FromBody]FMUpdateBoolDataByIntId entity)
|
{
|
var jm = new AdminUiCallBack();
|
|
var oldModel = await _DistributionGoodsServices.QueryByIdAsync(entity.id, false);
|
if (oldModel == null)
|
{
|
jm.msg = "不存在此信息";
|
return jm;
|
}
|
oldModel.isDel = (bool)entity.data;
|
|
var bl = await _DistributionGoodsServices.UpdateAsync(p => new CoreCmsGoods() { isDel = oldModel.isDel }, p => p.id == oldModel.id);
|
jm.code = bl ? 0 : 1;
|
jm.msg = bl ? GlobalConstVars.EditSuccess : GlobalConstVars.EditFailure;
|
|
return jm;
|
}
|
#endregion
|
|
|
}
|
}
|
