/// <summary>
/// 页面加载
/// </summary>
protected override void PageLoad()
{
base.PageLoad();
var queryClass = RequestHelper.GetQueryString <string>("cat").Split(',');
int classLevel1 = 0, classLevel2 = 0, classLevel3 = 0;
if (queryClass.Length > 0)
{
classLevel1 = ShopCommon.ConvertToT <int>(queryClass[0]);
}
if (queryClass.Length > 1)
{
classLevel2 = ShopCommon.ConvertToT <int>(queryClass[1]);
}
if (queryClass.Length > 2)
{
classLevel3 = ShopCommon.ConvertToT <int>(queryClass[2]);
}
int currentClassId = classLevel3 > 0 ? classLevel3 : classLevel2 > 0 ? classLevel2 : classLevel1;
//商品列表
currentPage = RequestHelper.GetQueryString <int>("Page");
if (currentPage < 1)
{
currentPage = 1;
}
int pageSize = 6; int count = 0;
string brandIds = RequestHelper.GetQueryString <string>("brand");
string attributeIds = RequestHelper.GetQueryString <string>("at");
string attributeValues = RequestHelper.GetQueryString <string>("ex");
string orderField = RequestHelper.GetQueryString <string>("sort");
string orderType = "";
var orderParams = orderField.Split('_');
if (orderParams.Length > 1)
{
orderField = orderParams[0];
orderType = orderParams[1];
}
int minPrice = RequestHelper.GetQueryString <int>("min");
int maxPrice = RequestHelper.GetQueryString <int>("max");
string keywords = RequestHelper.GetQueryString <string>("kw");
int isNew = RequestHelper.GetQueryString <int>("isNew");
int isHot = RequestHelper.GetQueryString <int>("isHot");
int isSpecial = RequestHelper.GetQueryString <int>("isSpecial");
int isTop = RequestHelper.GetQueryString <int>("isTop");
productList = ProductBLL.SearchList(currentPage, pageSize, currentClassId, brandIds, attributeIds, attributeValues, orderField, orderType, minPrice, maxPrice, keywords, "", isNew, isHot, isSpecial, isTop, ref count, ref showAttributeList, ref showBrandList);
}
/// <summary>
/// 根据regionId获取省市名称
/// </summary>
/// <param name="regionId"></param>
/// <returns></returns>
public static string ReadCityName(string regionId)
{
string result = string.Empty;
if (!string.IsNullOrEmpty(regionId))
{
foreach (string rid in regionId.Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries))
{
int _rid = ShopCommon.ConvertToT <Int32>(rid);
if (_rid > 0)
{
result += RegionBLL.ReadRegionCache(_rid).RegionName;
}
}
}
return(result);
}
protected void ExportButton_Click(object sender, EventArgs e)
{
ProductSearchInfo productSearch = new ProductSearchInfo();
OrderSearchInfo orderSearch = new OrderSearchInfo();
productSearch.IsSale = (int)BoolType.True;
productSearch.Name = ShopCommon.ConvertToT <string>(Name.Text);
productSearch.ClassId = ShopCommon.ConvertToT <string>(ClassID.Text);
productSearch.BrandId = ShopCommon.ConvertToT <int>(BrandID.Text);
orderSearch.StartAddDate = ShopCommon.ConvertToT <DateTime>(StartAddDate.Text);
orderSearch.EndAddDate = ShopCommon.SearchEndDate(ShopCommon.ConvertToT <DateTime>(EndAddDate.Text));
orderSearch.UserName = ShopCommon.ConvertToT <string>(UserName.Text);
orderSearch.OrderNumber = ShopCommon.ConvertToT <string>(OrderNumber.Text);
var data = OrderDetailBLL.StatisticsSaleDetail(1, 1000, orderSearch, productSearch, ref Count);
NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook();
NPOI.SS.UserModel.ISheet sheet = book.CreateSheet("Sheet1");
sheet.DefaultColumnWidth = 18;
sheet.CreateFreezePane(0, 1, 0, 1);
NPOI.SS.UserModel.IRow row = sheet.CreateRow(0);
row.Height = 20 * 20;
row.CreateCell(0).SetCellValue("时间");
row.CreateCell(1).SetCellValue("单号");
row.CreateCell(2).SetCellValue("商品名称");
row.CreateCell(3).SetCellValue("数量");
row.CreateCell(4).SetCellValue("金额");
row.CreateCell(5).SetCellValue("用户名");
//设置表头格式
var headFont = book.CreateFont();
headFont.Boldweight = (short)NPOI.SS.UserModel.FontBoldWeight.Bold;
headFont.FontHeightInPoints = 10;
var headStyle = book.CreateCellStyle();
headStyle.SetFont(headFont);
headStyle.VerticalAlignment = NPOI.SS.UserModel.VerticalAlignment.Center;
headStyle.BorderBottom = NPOI.SS.UserModel.BorderStyle.Thin;
headStyle.BorderLeft = NPOI.SS.UserModel.BorderStyle.Thin;
headStyle.BorderRight = NPOI.SS.UserModel.BorderStyle.Thin;
headStyle.BorderTop = NPOI.SS.UserModel.BorderStyle.Thin;
foreach (var cell in row.Cells)
{
cell.CellStyle = headStyle;
}
foreach (DataRow dr in data.Rows)
{
NPOI.SS.UserModel.IRow dataRow = sheet.CreateRow(data.Rows.IndexOf(dr) + 1);
dataRow.CreateCell(0).SetCellValue(Convert.ToString(dr["AddDate"]));
dataRow.CreateCell(1).SetCellValue(Convert.ToString(dr["OrderNumber"]));
dataRow.CreateCell(2).SetCellValue(Convert.ToString(dr["Name"]));
dataRow.CreateCell(3).SetCellValue(Convert.ToString(dr["BuyCount"]));
dataRow.CreateCell(4).SetCellValue(Convert.ToString(dr["Money"]));
dataRow.CreateCell(5).SetCellValue(Convert.ToString(dr["UserName"]));
var style = book.CreateCellStyle();
style.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Left;
foreach (var cell in dataRow.Cells)
{
cell.CellStyle = style;
}
}
System.IO.MemoryStream ms = new System.IO.MemoryStream();
book.Write(ms);
Response.AddHeader("Content-Disposition", string.Format("attachment; filename={0}.xls", DateTime.Now.ToString("yyyyMMddHHmmssfff")));
Response.BinaryWrite(ms.ToArray());
book = null;
ms.Close();
ms.Dispose();
Response.End();
}
protected override void PageLoad()
{
base.PageLoad();
var queryClass = RequestHelper.GetQueryString <string>("cat").Split(',');
int classLevel1 = 0, classLevel2 = 0, classLevel3 = 0;
if (queryClass.Length > 0)
{
classLevel1 = ShopCommon.ConvertToT <int>(queryClass[0]);
}
if (queryClass.Length > 1)
{
classLevel2 = ShopCommon.ConvertToT <int>(queryClass[1]);
}
if (queryClass.Length > 2)
{
classLevel3 = ShopCommon.ConvertToT <int>(queryClass[2]);
}
int currentClassId = classLevel3 > 0 ? classLevel3 : classLevel2 > 0 ? classLevel2 : classLevel1;
if (currentClassId < 1)
{
ResponseHelper.Redirect("/");
}
if (classLevel1 > 0)
{
switch (classLevel1)
{
case 1:
topNav = 2;
break;
case 2:
topNav = 3;
break;
case 4:
topNav = 4;
break;
case 6:
topNav = 5;
break;
}
}
//面包屑区域--分类
showClassList = ProductClassBLL.ReadList();
currentClass = showClassList.FirstOrDefault(k => k.Id == currentClassId) ?? new ProductClassInfo();
levelClass.Add("level1", showClassList.FirstOrDefault(k => k.Id == classLevel1) ?? new ProductClassInfo());
levelClass.Add("level2", showClassList.FirstOrDefault(k => k.Id == classLevel2) ?? new ProductClassInfo());
levelClass.Add("level3", showClassList.FirstOrDefault(k => k.Id == classLevel3) ?? new ProductClassInfo());
//热门商品
int hotCount = 0;
hotProductList = ProductBLL.SearchList(1, 7, new ProductSearchInfo {
IsHot = (int)BoolType.True, IsSale = (int)BoolType.True
}, ref hotCount);
//商品列表
currentPage = RequestHelper.GetQueryString <int>("Page");
if (currentPage < 1)
{
currentPage = 1;
}
int pageSize = 15; int count = 0;
string brandIds = RequestHelper.GetQueryString <string>("brand");
string attributeIds = RequestHelper.GetQueryString <string>("at");
string attributeValues = RequestHelper.GetQueryString <string>("ex");
string orderField = RequestHelper.GetQueryString <string>("sort");
string orderType = "";
var orderParams = orderField.Split('_');
if (orderParams.Length > 1)
{
orderField = orderParams[0];
orderType = orderParams[1];
}
int minPrice = RequestHelper.GetQueryString <int>("min");
int maxPrice = RequestHelper.GetQueryString <int>("max");
string keywords = RequestHelper.GetQueryString <string>("kw");
int isNew = RequestHelper.GetQueryString <int>("isNew");
int isHot = RequestHelper.GetQueryString <int>("isHot");
int isSpecial = RequestHelper.GetQueryString <int>("isSpecial");
int isTop = RequestHelper.GetQueryString <int>("isTop");
productList = ProductBLL.SearchList(currentPage, pageSize, currentClassId, brandIds, attributeIds, attributeValues, orderField, orderType, minPrice, maxPrice, keywords, "", isNew, isHot, isSpecial, isTop, ref count, ref showAttributeList, ref showBrandList);
pager.Init(currentPage, pageSize, count, !string.IsNullOrEmpty(isMobile));
//pager.CurrentPage = currentPage;
//pager.PageSize = pageSize;
//pager.Count = count;
//pager.FirstPage = "<<首页";
//pager.PreviewPage = "<<上一页";
//pager.NextPage = "下一页>>";
//pager.LastPage = "末页>>";
//pager.ListType = false;
//pager.DisCount = false;
//pager.PrenextType = true;
ProductClassInfo thisProductClass = new ProductClassInfo();
if (classLevel3 > 0)
{
thisProductClass = ProductClassBLL.Read(classLevel3);
}
else if (classLevel2 > 0)
{
thisProductClass = ProductClassBLL.Read(classLevel2);
}
else
{
thisProductClass = ProductClassBLL.Read(classLevel1);
}
Title = thisProductClass.PageTitle.Trim() == "" ? thisProductClass.Name : thisProductClass.PageTitle;
Keywords = thisProductClass.PageKeyWord.Trim() == "" ? thisProductClass.Name : thisProductClass.PageKeyWord;
Description = thisProductClass.PageSummary.Trim() == "" ? thisProductClass.Remark : thisProductClass.PageSummary;
}
protected override void PageLoad()
{
base.PageLoad();
var queryClass = StringHelper.AddSafe(HttpUtility.UrlDecode(RequestHelper.GetQueryString <string>("cat"))).Split(',');
int classLevel1 = 0, classLevel2 = 0, classLevel3 = 0;
if (queryClass.Length > 0)
{
classLevel1 = ShopCommon.ConvertToT <int>(queryClass[0]);
}
if (queryClass.Length > 1)
{
classLevel2 = ShopCommon.ConvertToT <int>(queryClass[1]);
}
if (queryClass.Length > 2)
{
classLevel3 = ShopCommon.ConvertToT <int>(queryClass[2]);
}
int currentClassId = classLevel3 > 0 ? classLevel3 : classLevel2 > 0 ? classLevel2 : classLevel1;
if (currentClassId < 0)
{
currentClassId = 0;
}
//if (currentClassId < 1) ResponseHelper.Redirect("/");
//面包屑区域--分类
showClassList = ProductClassBLL.ReadList();
currentClass = showClassList.FirstOrDefault(k => k.Id == currentClassId) ?? new ProductClassInfo();
levelClass.Add("level1", showClassList.FirstOrDefault(k => k.Id == classLevel1) ?? new ProductClassInfo());
levelClass.Add("level2", showClassList.FirstOrDefault(k => k.Id == classLevel2) ?? new ProductClassInfo());
levelClass.Add("level3", showClassList.FirstOrDefault(k => k.Id == classLevel3) ?? new ProductClassInfo());
//热门商品
int hotCount = 0;
hotProductList = ProductBLL.SearchList(1, 7, new ProductSearchInfo {
IsHot = (int)BoolType.True, IsSale = (int)BoolType.True
}, ref hotCount);
//商品列表
currentPage = RequestHelper.GetQueryString <int>("Page");
if (currentPage < 1)
{
currentPage = 1;
}
int pageSize = 6; int count = 0;
string brandIds = StringHelper.AddSafe(HttpUtility.UrlDecode(RequestHelper.GetQueryString <string>("brand")));
string attributeIds = StringHelper.AddSafe(HttpUtility.UrlDecode(RequestHelper.GetQueryString <string>("at")));
string attributeValues = StringHelper.AddSafe(HttpUtility.UrlDecode(RequestHelper.GetQueryString <string>("ex").Trim()));
string orderField = StringHelper.AddSafe(HttpUtility.UrlDecode(RequestHelper.GetQueryString <string>("sort")));
string orderType = "";
var orderParams = orderField.Split('_');
if (orderParams.Length > 1)
{
orderField = orderParams[0];
orderType = orderParams[1];
}
int minPrice = RequestHelper.GetQueryString <int>("min");
int maxPrice = RequestHelper.GetQueryString <int>("max");
string keywords = StringHelper.AddSafe(HttpUtility.UrlDecode(RequestHelper.GetQueryString <string>("kw")));
#region 添加到搜索记录
if (keywords != string.Empty)
{
var historySearch = Server.UrlDecode(CookiesHelper.ReadCookieValue("HistorySearch"));
if (("," + historySearch + ",").IndexOf("," + Server.UrlDecode(keywords) + ",") == -1)
{
if (historySearch == "")
{
historySearch = Server.UrlDecode(keywords);
}
else
{
historySearch = Server.UrlDecode(keywords) + "," + historySearch;
}
if (historySearch.ToString().IndexOf(",") > -1)
{
if (historySearch.Split(',').Length > 8)
{
historySearch = historySearch.Substring(0, historySearch.LastIndexOf(","));
}
}
CookiesHelper.AddCookie("HistorySearch", Server.UrlEncode(historySearch));
}
}
#endregion
int isNew = RequestHelper.GetQueryString <int>("isNew");
int isHot = RequestHelper.GetQueryString <int>("isHot");
int isSpecial = RequestHelper.GetQueryString <int>("isSpecial");
int isTop = RequestHelper.GetQueryString <int>("isTop");
productList = ProductBLL.SearchList(currentPage, pageSize, currentClassId, brandIds, attributeIds, attributeValues, orderField, orderType, minPrice, maxPrice, keywords, "", isNew, isHot, isSpecial, isTop, ref count, ref showAttributeList, ref showBrandList);
//手机端特殊，显示所有当前产品类型下的品牌和属性，不会判断有无产品
if (currentClassId > 0)
{
//取得当前分类所属类型
ProductTypeInfo productType = ProductTypeBLL.Read(ProductClassBLL.Read(currentClassId).ProductTypeId);
showBrandList = ProductBrandBLL.ReadList(Array.ConvertAll <string, int>(productType.BrandIds.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries), k => Convert.ToInt32(k)));
showAttributeList = ProductTypeAttributeBLL.ReadList(productType.Id);
}
#region 添加热门关键词
//如果有搜索结果且关键词不为空
if (productList.Count > 0 && !string.IsNullOrEmpty(keywords))
{
var theSearchKey = HotSearchKeyBLL.Read(keywords);
//之前没有则增加
if (theSearchKey.Id <= 0)
{
theSearchKey.Name = keywords;
theSearchKey.SearchTimes = 1;
HotSearchKeyBLL.Add(theSearchKey);
}
else
{ //有则修改更新搜索次数
theSearchKey.SearchTimes += 1;
HotSearchKeyBLL.Update(theSearchKey);
}
}
#endregion
ProductClassInfo thisProductClass = new ProductClassInfo();
if (classLevel3 > 0)
{
thisProductClass = ProductClassBLL.Read(classLevel3);
}
else if (classLevel2 > 0)
{
thisProductClass = ProductClassBLL.Read(classLevel2);
}
else
{
thisProductClass = ProductClassBLL.Read(classLevel1);
}
Title = thisProductClass.PageTitle.Trim() == "" ? thisProductClass.Name : thisProductClass.PageTitle;
Keywords = thisProductClass.PageKeyWord.Trim() == "" ? thisProductClass.Name : thisProductClass.PageKeyWord;
//Description = thisProductClass.PageSummary.Trim() == "" ? thisProductClass.Remark : thisProductClass.PageSummary;
Description = thisProductClass.PageSummary;
}
protected override void PageLoad()
{
base.PageLoad();
var queryClass = RequestHelper.GetQueryString <string>("cat").Split(',');
int classLevel1 = 0, classLevel2 = 0, classLevel3 = 0;
if (queryClass.Length > 0)
{
classLevel1 = ShopCommon.ConvertToT <int>(queryClass[0]);
}
if (queryClass.Length > 1)
{
classLevel2 = ShopCommon.ConvertToT <int>(queryClass[1]);
}
if (queryClass.Length > 2)
{
classLevel3 = ShopCommon.ConvertToT <int>(queryClass[2]);
}
int currentClassId = classLevel3 > 0 ? classLevel3 : classLevel2 > 0 ? classLevel2 : classLevel1;
if (currentClassId < 1)
{
ResponseHelper.Redirect("/");
}
//面包屑区域--分类
showClassList = ProductClassBLL.ReadList();
currentClass = showClassList.FirstOrDefault(k => k.Id == currentClassId) ?? new ProductClassInfo();
levelClass.Add("level1", showClassList.FirstOrDefault(k => k.Id == classLevel1) ?? new ProductClassInfo());
levelClass.Add("level2", showClassList.FirstOrDefault(k => k.Id == classLevel2) ?? new ProductClassInfo());
levelClass.Add("level3", showClassList.FirstOrDefault(k => k.Id == classLevel3) ?? new ProductClassInfo());
//热门商品
int hotCount = 0;
hotProductList = ProductBLL.SearchList(1, 7, new ProductSearchInfo {
IsHot = (int)BoolType.True, IsSale = (int)BoolType.True
}, ref hotCount);
//商品列表
currentPage = RequestHelper.GetQueryString <int>("Page");
if (currentPage < 1)
{
currentPage = 1;
}
int pageSize = 24; int count = 0;
string brandIds = RequestHelper.GetQueryString <string>("brand");
string attributeIds = RequestHelper.GetQueryString <string>("at");
string attributeValues = RequestHelper.GetQueryString <string>("ex");
string orderField = RequestHelper.GetQueryString <string>("sort");
string orderType = "";
var orderParams = orderField.Split('_');
if (orderParams.Length > 1)
{
orderField = orderParams[0];
orderType = orderParams[1];
}
int minPrice = RequestHelper.GetQueryString <int>("min");
int maxPrice = RequestHelper.GetQueryString <int>("max");
string keywords = RequestHelper.GetQueryString <string>("kw");
string isNew = RequestHelper.GetQueryString <string>("isNew");
string isHot = RequestHelper.GetQueryString <string>("isHot");
string isSpecial = RequestHelper.GetQueryString <string>("isSpecial");
string isTop = RequestHelper.GetQueryString <string>("isTop");
//productList = ProductBLL.SearchList(currentPage, pageSize, 0, "", "", "", orderField, orderType, minPrice, maxPrice, keywords, isNew,isHot,isSpecial,isTop, ref count, ref showAttributeList, ref showBrandList);
pager.Init(currentPage, pageSize, count, !string.IsNullOrEmpty(isMobile));
}
protected override void PageLoad()
{
base.PageLoad();
var queryClass = StringHelper.AddSafe(HttpUtility.UrlDecode(RequestHelper.GetQueryString <string>("cat"))).Split(',');
int classLevel1 = 0, classLevel2 = 0, classLevel3 = 0;
if (queryClass.Length > 0)
{
classLevel1 = ShopCommon.ConvertToT <int>(queryClass[0]);
}
if (queryClass.Length > 1)
{
classLevel2 = ShopCommon.ConvertToT <int>(queryClass[1]);
}
if (queryClass.Length > 2)
{
classLevel3 = ShopCommon.ConvertToT <int>(queryClass[2]);
}
int currentClassId = classLevel3 > 0 ? classLevel3 : classLevel2 > 0 ? classLevel2 : classLevel1;
//if (currentClassId < 1) ResponseHelper.Redirect("/");
if (currentClassId < 1)
{
currentClassId = 0;
}
if (classLevel1 > 0)
{
switch (classLevel1)
{
case 1:
topNav = 2;
break;
case 2:
topNav = 3;
break;
case 4:
topNav = 4;
break;
case 6:
topNav = 5;
break;
}
}
//面包屑区域--分类
showClassList = ProductClassBLL.ReadList();
currentClass = showClassList.FirstOrDefault(k => k.Id == currentClassId) ?? new ProductClassInfo();
levelClass.Add("level1", showClassList.FirstOrDefault(k => k.Id == classLevel1) ?? new ProductClassInfo());
levelClass.Add("level2", showClassList.FirstOrDefault(k => k.Id == classLevel2) ?? new ProductClassInfo());
levelClass.Add("level3", showClassList.FirstOrDefault(k => k.Id == classLevel3) ?? new ProductClassInfo());
if (currentClassId < 1)
{
currentClassId = 0;
}
//热门商品
int hotCount = 0;
if (currentClassId > 0)
{
hotProductList = ProductBLL.SearchList(1, 5, new ProductSearchInfo {
IsHot = (int)BoolType.True, IsSale = (int)BoolType.True, IsDelete = (int)BoolType.False, ClassId = "|" + currentClassId + "|"
}, ref hotCount);
}
else
{
hotProductList = ProductBLL.SearchList(1, 5, new ProductSearchInfo {
IsHot = (int)BoolType.True, IsSale = (int)BoolType.True, IsDelete = (int)BoolType.False
}, ref hotCount);
}
//商品列表
currentPage = RequestHelper.GetQueryString <int>("Page");
if (currentPage < 1)
{
currentPage = 1;
}
int pageSize = 20; int count = 0;
string brandIds = StringHelper.AddSafe(HttpUtility.UrlDecode(RequestHelper.GetQueryString <string>("brand")));
string attributeIds = StringHelper.AddSafe(HttpUtility.UrlDecode(RequestHelper.GetQueryString <string>("at")));
string attributeValues = StringHelper.AddSafe(HttpUtility.UrlDecode(RequestHelper.GetQueryString <string>("ex")));
string orderField = StringHelper.AddSafe(HttpUtility.UrlDecode(RequestHelper.GetQueryString <string>("sort")));
string orderType = "";
var orderParams = orderField.Split('_');
if (orderParams.Length > 1)
{
orderField = orderParams[0];
orderType = orderParams[1];
}
int minPrice = RequestHelper.GetQueryString <int>("min");
int maxPrice = RequestHelper.GetQueryString <int>("max");
keywords = StringHelper.AddSafe(HttpUtility.UrlDecode(RequestHelper.GetQueryString <string>("kw")));
string stf_Keyword = StringHelper.AddSafe(HttpUtility.UrlDecode(RequestHelper.GetQueryString <string>("stf_Keyword")));
if (!string.IsNullOrEmpty(stf_Keyword))
{
if (string.IsNullOrEmpty(keywords))
{
keywords = stf_Keyword;
}
}
int isNew = RequestHelper.GetQueryString <int>("isNew");
int isHot = RequestHelper.GetQueryString <int>("isHot");
int isSpecial = RequestHelper.GetQueryString <int>("isSpecial");
int isTop = RequestHelper.GetQueryString <int>("isTop");
productList = ProductBLL.SearchList(currentPage, pageSize, currentClassId, brandIds, attributeIds, attributeValues, orderField, orderType, minPrice, maxPrice, keywords, stf_Keyword, isNew, isHot, isSpecial, isTop, ref count, ref showAttributeList, ref showBrandList);
pagecount = (int)Math.Round((double)(count + 0.1) / pageSize, 0);
if (pagecount <= 0)
{
pagecount = 1;
}
pager.Init(currentPage, pageSize, count, !string.IsNullOrEmpty(isMobile));
pager.ShowType = 3;
#region 如果没有查找到商品则显示RequestHelper.GetQueryString<string>("brand")获取的所有品牌
if (count <= 0)
{
string[] _brandids = brandIds.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
int[] _showbrandids = Array.ConvertAll <string, int>(_brandids, s => Convert.ToInt32(s));
showBrandList = ProductBrandBLL.ReadList(_showbrandids);
}
#endregion
#region 添加热门关键词
//如果有搜索结果且关键词不为空
if (productList.Count > 0 && !string.IsNullOrEmpty(keywords))
{
var theSearchKey = HotSearchKeyBLL.Read(keywords);
//之前没有则增加
if (theSearchKey.Id <= 0)
{
theSearchKey.Name = StringHelper.AddSafe(HttpUtility.HtmlEncode(keywords));
theSearchKey.SearchTimes = 1;
HotSearchKeyBLL.Add(theSearchKey);
}
else
{ //有则修改更新搜索次数
theSearchKey.SearchTimes += 1;
HotSearchKeyBLL.Update(theSearchKey);
}
}
#endregion
if (classLevel3 > 0)
{
thisProductClass = ProductClassBLL.Read(classLevel3);
}
else if (classLevel2 > 0)
{
thisProductClass = ProductClassBLL.Read(classLevel2);
}
else
{
thisProductClass = ProductClassBLL.Read(classLevel1);
}
//浏览过的商品
strHistoryProduct = Server.UrlDecode(CookiesHelper.ReadCookieValue("HistoryProduct"));
if (strHistoryProduct.StartsWith(","))
{
strHistoryProduct = strHistoryProduct.Substring(1);
}
if (strHistoryProduct.EndsWith(","))
{
strHistoryProduct = strHistoryProduct.Substring(0, strHistoryProduct.Length - 1);
}
ProductSearchInfo productSearch = new ProductSearchInfo();
productSearch.InProductId = strHistoryProduct;
productSearch.IsSale = 1;
productSearch.IsDelete = 0;
tempProductList = ProductBLL.SearchList(productSearch);
Title = thisProductClass.PageTitle.Trim() == "" ? thisProductClass.Name : thisProductClass.PageTitle;
Keywords = thisProductClass.PageKeyWord.Trim() == "" ? thisProductClass.Name : thisProductClass.PageKeyWord;
//Description = thisProductClass.PageSummary.Trim() == "" ? thisProductClass.Remark : thisProductClass.PageSummary;
Description = thisProductClass.PageSummary;
}
protected void ExportButton_Click(object sender, EventArgs e)
{
ProductSearchInfo productSearch = new ProductSearchInfo();
productSearch.IsSale = (int)BoolType.True;
productSearch.Name = ShopCommon.ConvertToT <string>(Name.Text);
productSearch.ClassId = ShopCommon.ConvertToT <string>(ClassID.Text);
productSearch.BrandId = ShopCommon.ConvertToT <int>(BrandID.Text);
productSearch.StorageAnalyse = ShopCommon.ConvertToT <int>(StorageAnalyse.Text);
var data = ProductBLL.SearchList(1, 1000, productSearch, ref Count);
NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook();
NPOI.SS.UserModel.ISheet sheet = book.CreateSheet("Sheet1");
sheet.DefaultColumnWidth = 18;
sheet.CreateFreezePane(0, 1, 0, 1);
NPOI.SS.UserModel.IRow row = sheet.CreateRow(0);
row.Height = 20 * 20;
row.CreateCell(0).SetCellValue("商品名称");
row.CreateCell(1).SetCellValue("剩余库存量");
row.CreateCell(2).SetCellValue("库存下限");
row.CreateCell(3).SetCellValue("库存上限");
//设置表头格式
var headFont = book.CreateFont();
headFont.Boldweight = (short)NPOI.SS.UserModel.FontBoldWeight.Bold;
headFont.FontHeightInPoints = 10;
var headStyle = book.CreateCellStyle();
headStyle.SetFont(headFont);
headStyle.VerticalAlignment = NPOI.SS.UserModel.VerticalAlignment.Center;
headStyle.BorderBottom = NPOI.SS.UserModel.BorderStyle.Thin;
headStyle.BorderLeft = NPOI.SS.UserModel.BorderStyle.Thin;
headStyle.BorderRight = NPOI.SS.UserModel.BorderStyle.Thin;
headStyle.BorderTop = NPOI.SS.UserModel.BorderStyle.Thin;
foreach (var cell in row.Cells)
{
cell.CellStyle = headStyle;
}
foreach (var entity in data)
{
NPOI.SS.UserModel.IRow dataRow = sheet.CreateRow(data.IndexOf(entity) + 1);
dataRow.CreateCell(0).SetCellValue(entity.Name);
dataRow.CreateCell(1).SetCellValue(ShowStorageCount(entity.TotalStorageCount - entity.SendCount, entity.ImportActualStorageCount));
dataRow.CreateCell(2).SetCellValue(Convert.ToString(entity.LowerCount));
dataRow.CreateCell(3).SetCellValue(Convert.ToString(entity.UpperCount));
var style = book.CreateCellStyle();
style.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Left;
foreach (var cell in dataRow.Cells)
{
cell.CellStyle = style;
}
}
System.IO.MemoryStream ms = new System.IO.MemoryStream();
book.Write(ms);
Response.AddHeader("Content-Disposition", string.Format("attachment; filename={0}.xls", DateTime.Now.ToString("yyyyMMddHHmmssfff")));
Response.BinaryWrite(ms.ToArray());
book = null;
ms.Close();
ms.Dispose();
Response.End();
}
protected void ExportButton_Click(object sender, EventArgs e)
{
UserSearchInfo userSearch = new UserSearchInfo();
userSearch.UserName = ShopCommon.ConvertToT <string>(UserName.Text);
userSearch.Sex = ShopCommon.ConvertToT <int>(Sex.Text);
DateTime startDate = ShopCommon.ConvertToT <DateTime>(StartDate.Text);
DateTime endDate = ShopCommon.SearchEndDate(ShopCommon.ConvertToT <DateTime>(EndDate.Text));
string userConsumeType = ShopCommon.ConvertToT <string>(UserConsumeType.Text);
userConsumeType = (userConsumeType == string.Empty) ? "OrderCount" : userConsumeType;
var data = UserBLL.StatisticsUserConsume(1, 1000, userSearch, ref Count, userConsumeType, startDate, endDate);
NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook();
NPOI.SS.UserModel.ISheet sheet = book.CreateSheet("Sheet1");
sheet.DefaultColumnWidth = 18;
sheet.CreateFreezePane(0, 1, 0, 1);
NPOI.SS.UserModel.IRow row = sheet.CreateRow(0);
row.Height = 20 * 20;
row.CreateCell(0).SetCellValue("用户");
row.CreateCell(1).SetCellValue("性别");
row.CreateCell(2).SetCellValue("订单次数");
row.CreateCell(3).SetCellValue("订单金额");
//设置表头格式
var headFont = book.CreateFont();
headFont.Boldweight = (short)NPOI.SS.UserModel.FontBoldWeight.Bold;
headFont.FontHeightInPoints = 10;
var headStyle = book.CreateCellStyle();
headStyle.SetFont(headFont);
headStyle.VerticalAlignment = NPOI.SS.UserModel.VerticalAlignment.Center;
headStyle.BorderBottom = NPOI.SS.UserModel.BorderStyle.Thin;
headStyle.BorderLeft = NPOI.SS.UserModel.BorderStyle.Thin;
headStyle.BorderRight = NPOI.SS.UserModel.BorderStyle.Thin;
headStyle.BorderTop = NPOI.SS.UserModel.BorderStyle.Thin;
foreach (var cell in row.Cells)
{
cell.CellStyle = headStyle;
}
foreach (DataRow dr in data.Rows)
{
NPOI.SS.UserModel.IRow dataRow = sheet.CreateRow(data.Rows.IndexOf(dr) + 1);
dataRow.CreateCell(0).SetCellValue(Convert.ToString(dr["UserName"]));
dataRow.CreateCell(1).SetCellValue(EnumHelper.ReadEnumChineseName <SexType>(Convert.ToInt32(dr["Sex"])));
dataRow.CreateCell(2).SetCellValue(Convert.ToString(dr["OrderCount"]));
dataRow.CreateCell(3).SetCellValue(Convert.ToString(dr["OrderMoney"]));
var style = book.CreateCellStyle();
style.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Left;
foreach (var cell in dataRow.Cells)
{
cell.CellStyle = style;
}
}
System.IO.MemoryStream ms = new System.IO.MemoryStream();
book.Write(ms);
Response.AddHeader("Content-Disposition", string.Format("attachment; filename={0}.xls", DateTime.Now.ToString("yyyyMMddHHmmssfff")));
Response.BinaryWrite(ms.ToArray());
book = null;
ms.Close();
ms.Dispose();
Response.End();
}
protected void ExportButton_Click(object sender, EventArgs e)
{
OrderSearchInfo orderSearch = new OrderSearchInfo();
orderSearch.OrderNumber = ShopCommon.ConvertToT <string>(OrderNumber.Text);
orderSearch.OrderStatus = ShopCommon.ConvertToT <int>(OrderStatus.Text);
orderSearch.Consignee = ShopCommon.ConvertToT <string>(Consignee.Text);
orderSearch.StartAddDate = ShopCommon.ConvertToT <DateTime>(StartAddDate.Text);
orderSearch.EndAddDate = ShopCommon.SearchEndDate(ShopCommon.ConvertToT <DateTime>(EndAddDate.Text));
var data = OrderBLL.SearchList(1, 1000, orderSearch, ref Count);
NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook();
NPOI.SS.UserModel.ISheet sheet = book.CreateSheet("Sheet1");
sheet.DefaultColumnWidth = 18;
sheet.CreateFreezePane(0, 1, 0, 1);
NPOI.SS.UserModel.IRow row = sheet.CreateRow(0);
row.Height = 20 * 20;
row.CreateCell(0).SetCellValue("订单号");
row.CreateCell(1).SetCellValue("订单金额");
row.CreateCell(2).SetCellValue("类型");
row.CreateCell(3).SetCellValue("收货方式");
row.CreateCell(4).SetCellValue("收货人");
//row.CreateCell(3).SetCellValue("收货地址");
row.CreateCell(5).SetCellValue("订单状态");
row.CreateCell(6).SetCellValue("下单时间");
row.CreateCell(7).SetCellValue("最近操作时间");
//设置表头格式
var headFont = book.CreateFont();
headFont.Boldweight = (short)NPOI.SS.UserModel.FontBoldWeight.Bold;
headFont.FontHeightInPoints = 10;
var headStyle = book.CreateCellStyle();
headStyle.SetFont(headFont);
headStyle.VerticalAlignment = NPOI.SS.UserModel.VerticalAlignment.Center;
headStyle.BorderBottom = NPOI.SS.UserModel.BorderStyle.Thin;
headStyle.BorderLeft = NPOI.SS.UserModel.BorderStyle.Thin;
headStyle.BorderRight = NPOI.SS.UserModel.BorderStyle.Thin;
headStyle.BorderTop = NPOI.SS.UserModel.BorderStyle.Thin;
foreach (var cell in row.Cells)
{
cell.CellStyle = headStyle;
}
//取得订单最后一次操作的时间
var orderActinList = OrderActionBLL.ReadListLastDate(data.Select(k => k.Id).ToArray());
foreach (var entity in data)
{
NPOI.SS.UserModel.IRow dataRow = sheet.CreateRow(data.IndexOf(entity) + 1);
dataRow.CreateCell(0).SetCellValue(entity.OrderNumber);
dataRow.CreateCell(1).SetCellValue((entity.ProductMoney + entity.ShippingMoney + entity.OtherMoney).ToString());
dataRow.CreateCell(2).SetCellValue(EnumHelper.ReadEnumChineseName <OrderKind>(entity.IsActivity));
dataRow.CreateCell(3).SetCellValue(entity.SelfPick == 1 ? "自提" : "配送");
dataRow.CreateCell(4).SetCellValue(entity.Consignee);
//dataRow.CreateCell(3).SetCellValue(entity.Address);
dataRow.CreateCell(5).SetCellValue(OrderBLL.ReadOrderStatus(entity.OrderStatus, entity.IsDelete));
dataRow.CreateCell(6).SetCellValue(entity.AddDate.ToString());
var orderAction = orderActinList.FirstOrDefault(k => k.OrderId == entity.Id) ?? new OrderActionInfo();
dataRow.CreateCell(7).SetCellValue(orderAction.OrderId > 0 ? orderAction.Date.ToString() : "");
var style = book.CreateCellStyle();
style.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Left;
foreach (var cell in dataRow.Cells)
{
cell.CellStyle = style;
}
}
System.IO.MemoryStream ms = new System.IO.MemoryStream();
book.Write(ms);
Response.AddHeader("Content-Disposition", string.Format("attachment; filename={0}.xls", DateTime.Now.ToString("yyyyMMddHHmmssfff")));
Response.BinaryWrite(ms.ToArray());
book = null;
ms.Close();
ms.Dispose();
Response.End();
}
protected void ExportButton_Click(object sender, EventArgs e)
{
ProductSearchInfo productSearch = new ProductSearchInfo();
productSearch.IsSale = (int)BoolType.True;
productSearch.Name = ShopCommon.ConvertToT <string>(Name.Text);
productSearch.ClassId = ShopCommon.ConvertToT <string>(ClassID.Text);
productSearch.BrandId = ShopCommon.ConvertToT <int>(BrandID.Text);
var dataProduct = ProductBLL.SearchList(1, 1000, productSearch, ref Count);
var dataStatis = StatisticsSaleStop(dataProduct);
NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook();
NPOI.SS.UserModel.ISheet sheet = book.CreateSheet("Sheet1");
sheet.DefaultColumnWidth = 18;
sheet.CreateFreezePane(0, 2, 0, 2);
NPOI.SS.UserModel.IRow row = sheet.CreateRow(0);
row.Height = 20 * 20;
row.CreateCell(0).SetCellValue("商品名称");
row.CreateCell(1).SetCellValue("最近一次销售");
row.CreateCell(2).SetCellValue("");
row.CreateCell(3).SetCellValue("");
row.CreateCell(4).SetCellValue("滞销天数");
NPOI.SS.UserModel.IRow row2 = sheet.CreateRow(1);
row2.Height = 20 * 20;
row2.CreateCell(0).SetCellValue("");
row2.CreateCell(1).SetCellValue("订单号");
row2.CreateCell(2).SetCellValue("销售数量");
row2.CreateCell(3).SetCellValue("日期");
row2.CreateCell(4).SetCellValue("");
sheet.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(0, 1, 0, 0));
sheet.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(0, 1, 4, 4));
sheet.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(0, 0, 1, 3));
//设置表头格式
var headFont = book.CreateFont();
headFont.Boldweight = (short)NPOI.SS.UserModel.FontBoldWeight.Bold;
headFont.FontHeightInPoints = 10;
var headStyle = book.CreateCellStyle();
headStyle.SetFont(headFont);
headStyle.VerticalAlignment = NPOI.SS.UserModel.VerticalAlignment.Center;
headStyle.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Center;
headStyle.BorderBottom = NPOI.SS.UserModel.BorderStyle.Thin;
headStyle.BorderLeft = NPOI.SS.UserModel.BorderStyle.Thin;
headStyle.BorderRight = NPOI.SS.UserModel.BorderStyle.Thin;
headStyle.BorderTop = NPOI.SS.UserModel.BorderStyle.Thin;
foreach (var cell in row.Cells)
{
cell.CellStyle = headStyle;
}
foreach (var cell in row2.Cells)
{
cell.CellStyle = headStyle;
}
foreach (var product in dataProduct)
{
DataRow dr = ReadSaleStop(product.Id, dataStatis);
NPOI.SS.UserModel.IRow dataRow = sheet.CreateRow(dataProduct.IndexOf(product) + 2);
dataRow.CreateCell(0).SetCellValue(product.Name);
if (dr != null)
{
dataRow.CreateCell(1).SetCellValue(Convert.ToString(dr["OrderNumber"]));
dataRow.CreateCell(2).SetCellValue(Convert.ToString(dr["BuyCount"]));
dataRow.CreateCell(3).SetCellValue(Convert.ToString(dr["AddDate"]));
dataRow.CreateCell(4).SetCellValue(Convert.ToString((DateTime.Now.Date - Convert.ToDateTime(dr["AddDate"]).Date).Days));
}
else
{
dataRow.CreateCell(1).SetCellValue("");
dataRow.CreateCell(2).SetCellValue("");
dataRow.CreateCell(3).SetCellValue("");
dataRow.CreateCell(4).SetCellValue("");
}
var style = book.CreateCellStyle();
style.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Left;
foreach (var cell in dataRow.Cells)
{
cell.CellStyle = style;
}
}
System.IO.MemoryStream ms = new System.IO.MemoryStream();
book.Write(ms);
Response.AddHeader("Content-Disposition", string.Format("attachment; filename={0}.xls", DateTime.Now.ToString("yyyyMMddHHmmssfff")));
Response.BinaryWrite(ms.ToArray());
book = null;
ms.Close();
ms.Dispose();
Response.End();
}
