public void ExportExcel([FromUri] Entity.MonitorLog.QueryModel queryModel)
{
HttpContext curContext = System.Web.HttpContext.Current;
var datatable = new Business.BN.MonitorLog().GetExcelList(queryModel);
if (datatable.Rows.Count <= 0)
{
curContext.Response.Write("<script>alert(\"没有找到匹配的记录!\");</script>");
curContext.Response.End();
return;
}
datatable.Columns["devicename"].Caption = "invisible";
var strFileName = "监控历史数据.xls";
var strHeaderText = string.Format("{0} {1} 至 {2} 的监控历史数据", datatable.Rows[0]["devicename"], queryModel.beginTime, queryModel.endTime);
curContext.Response.ContentType = "application/vnd.ms-excel";
curContext.Response.ContentEncoding = Encoding.UTF8;
curContext.Response.Charset = "";
curContext.Response.AppendHeader("Content-Disposition",
"attachment;filename=" + HttpUtility.UrlEncode(strFileName, Encoding.UTF8));
curContext.Response.BinaryWrite(Business.NpoiHelper.Export(datatable, strHeaderText).GetBuffer());
curContext.Response.End();
}
public string GetShuizhiList([FromUri] Entity.MonitorLog.QueryModel queryModel)
{
var mlbn = new Business.BN.MonitorLog();
var rows = JsonConvert.SerializeObject(mlbn.GetShuizhiList(queryModel));
var rst = new Entity.MonitorLog.BootstrapTableDataModel
{
rows = rows,
total = 0
};
return(JsonConvert.SerializeObject(rst));
}
public Entity.MonitorLog.BootstrapTableDataModel GetList([FromUri] Entity.MonitorLog.QueryModel queryModel)
{
var mlbn = new Business.BN.MonitorLog();
var rows = mlbn.GetList(queryModel);
var rst = new Entity.MonitorLog.BootstrapTableDataModel
{
rows = rows,
total = rows.Rows.Count > 0 ? Convert.ToInt32(rows.Rows[0]["RESULT_COUNT"]) : 0
};
return(rst);
}
/// <summary>
/// 监控历史记录 - 水质 - 浮标
/// </summary>
/// <param name="queryModel">查询条件</param>
/// <returns></returns>
public DataTable GetShuizhiList1(Entity.MonitorLog.QueryModel queryModel)
{
return(GetList("TABBUOYECOLOGY", queryModel.beginTime, queryModel.endTime, null, queryModel.offset / queryModel.limit + 1, queryModel.limit));
}
