private void LoadList()
{
GoodsCatsSearchCondition condition = this.GetSearchCondition();
this.BindSearchCondition(condition);
this.AllCates = GoodsCatsBLL.Instance.GetSortedList(condition.PlatType);
HQSearchContext <GoodsCatsSearchCondition> .SetCondtion(condition);
}
private void Export()
{
GoodsCatsSearchCondition condition = HQSearchContext <GoodsCatsSearchCondition> .GetCondtion();
if (condition == null)
{
this.SetJsSegmentOut("showError('查询条件丢失');");
return;
}
List <GoodsCatsModel> data = GoodsCatsBLL.Instance.GetSortedList(condition.PlatType);
DataTable dt = this.Convert(data);
if (dt.Rows.Count == 0)
{
this.SetJsSegmentOut("showError('没有找到一行数据');");
return;
}
//导出字段准备
List <ExportFieldApplyModel> lstMappings = new List <ExportFieldApplyModel>();
lstMappings.Add(ExportFieldApplyModel.Build("Id", "id"));
lstMappings.Add(ExportFieldApplyModel.Build("Name", "分类名"));
lstMappings.Add(ExportFieldApplyModel.Build("LevelNo", "层级"));
lstMappings.Add(ExportFieldApplyModel.Build("SortNum", "排序号"));
lstMappings.Add(ExportFieldApplyModel.Build("Status", "状态"));
lstMappings.Add(ExportFieldApplyModel.Build("Icon", "图片"));
//内存中，直接下载
string fileName = string.Format("goodscat-{0}({1}).xls", DateTime.Now.ToString("yyyyMMddHHmmss"), dt.Rows.Count);
using (MemoryStream ms = HQExcelExporter.ExportToMemoryStream(dt, lstMappings, out string errmsg))
{
Response.ClearContent();
Response.ContentType = "application/ms-excel";
Response.AppendHeader("Content-Disposition", "attachment;filename=" + fileName);
Response.BinaryWrite(ms.ToArray());
}
}
