public void Export(QueryBfCodeDto queryParams)
{
try
{
var bfCodeList = (new BfCodeInfoManager()).GetItems(queryParams);
var bfCodeDtlList = (new BfCodeDetailInfoManager()).SelectBfCodeDetailByBfCodeIds(bfCodeList);
var dataTable = new DataTable();
string fileName = "系统参数.xls";
LogHelper.Info(this.GetType(), "生成Excel，请稍后...");
#region 添加列
dataTable.Columns.Add("CODE");
dataTable.Columns.Add("DESCRIPTION");
dataTable.Columns.Add("DETAILCODE");
dataTable.Columns.Add("DETAILNAME");
dataTable.Columns.Add("SEQ_NUM");
#endregion
#region 添加行
foreach (var dtl in bfCodeDtlList)
{
var bfCode = bfCodeList.Find(a => a.ID == dtl.BF_CODE_ID);
DataRow dataRow = dataTable.NewRow();
dataRow["CODE"] = bfCode.CODE;
dataRow["DESCRIPTION"] = bfCode.DESCRIPTION;
dataRow["DETAILCODE"] = dtl.CODE;
dataRow["DETAILNAME"] = dtl.NAME;
dataRow["SEQ_NUM"] = dtl.SEQ_NUM;
dataTable.Rows.Add(dataRow);
}
#endregion
#region 设置列名
dataTable.Columns["CODE"].ColumnName = "编码";
dataTable.Columns["DESCRIPTION"].ColumnName = "描述";
dataTable.Columns["DETAILCODE"].ColumnName = "明细编码";
dataTable.Columns["DETAILNAME"].ColumnName = "明细名称";
dataTable.Columns["SEQ_NUM"].ColumnName = "明细排序号";
#endregion
System.Web.HttpContext.Current.Response.Charset = "utf-8";
System.Web.HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
if (System.Web.HttpContext.Current.Request.Browser.Browser != "Firefox")
{
fileName = System.Web.HttpUtility.UrlEncode(fileName, Encoding.UTF8);
}
FileNPOI.Export(System.Web.HttpContext.Current, fileName, dataTable);
}
catch (Exception ex)
{
LogHelper.Error(this.GetType(), "", ex);
}
}
public ActionResult QueryBfCode(JQueryDataTablesModel jQueryDataTablesModel, QueryBfCodeDto query)
{
var queryParam = new QueryBfCodeDto
{
PageIndex = jQueryDataTablesModel.PageIndex,
PageSize = jQueryDataTablesModel.PageSize,
CODE = query.CODE,
DESCRIPTION = query.DESCRIPTION,
SortField = jQueryDataTablesModel.SortField,
SortDirection = jQueryDataTablesModel.Direction
};
var pageList = (new BfCodeInfoManager()).GetPagedList(queryParam);
return(DataTablesJson(pageList, jQueryDataTablesModel.GridKey));
}
