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);
}
}
