private void tsmiExportGuest_Click(object sender, EventArgs e) { var sfd = new SaveFileDialog { Filter = "(Excel文件)|*.xls;", FileName = "E&E宾客名单" }; if (sfd.ShowDialog() == DialogResult.OK) { // ID 姓名 相片 性别 宾客类型 标签 随行人员 桌号 礼金 List <string> headers = new List <string> { "Id", "姓名", "相片", "性别", "宾客类型", "标签", "随行人员", "桌号", "礼金" }; List <string> arries = new List <string> { "Id", "Name", "Image", "Gender", "GuestTypeStr", "Labels", "Entourage", "TableNo", "CashGift" }; var data = GlobalConfigs.Guests; NpoiHelper.ToExcel(data, sfd.FileName, arries, headers); MessageBox.Show("导出完成"); } }
/// <summary> /// 导出遥测跳变历史记录 /// </summary> /// <param name="httpRequest"></param> /// <param name="httpResponse"></param> private void ExpYctbls(HttpRequest httpRequest, HttpResponse httpResponse) { try { string tmp = httpRequest["dateBegin"] ?? ""; DateTime dateBegin = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")).AddDays(-1); DateTime dateEnd = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")).AddDays(1); if (!string.IsNullOrEmpty(tmp)) { dateBegin = DateTime.Parse(tmp); } tmp = httpRequest["dateEnd"] ?? ""; if (!string.IsNullOrEmpty(tmp)) { dateEnd = DateTime.Parse(tmp).AddDays(1); } DataTable dt = _wrBll.Query(Constant.YclxYctb, dateBegin, dateEnd); string[] title = new string[] { "充电站", "桩类型", "桩型号", "装编号", "数据项", "阈值最小值", "阈值最大值", "告警值", "出错原因", "是否处理", "灭警方式", "灭警时间", "灭警人" }; dt.Columns.Remove("yxstates"); dt.Columns.Remove("yxwarn"); dt.Columns.Remove("eff_min"); dt.Columns.Remove("eff_max"); //dt.Columns.Remove("mvalue"); dt.Columns.Remove("yxeff"); foreach (DataRow dr in dt.Rows) { if (dr["processflag"].ToString() == "0") { dr["isproc"] = "未处理"; dr["procm"] = "未处理"; } else if (dr["processflag"].ToString() == "1") { dr["isproc"] = "已处理"; dr["procm"] = "自动灭警"; } else { dr["isproc"] = "已处理"; dr["procm"] = "手动灭警"; } } dt.Columns.Remove("processflag"); NpoiHelper nh = new NpoiHelper(title, dt); Stream ms = nh.ToExcel(); if (null == ms) { return; } byte[] exp = new byte[ms.Length]; ms.Read(exp, 0, (int)ms.Length); httpResponse.ContentType = "application/x-zip-compressed"; httpResponse.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode("遥测跳变历史.xls", System.Text.Encoding.UTF8)); httpResponse.BinaryWrite(exp); } catch (Exception ex) { Log.Error(ex); httpResponse.Write(ErrorJson); } }