protected void OnStoreSubmit(object sender, StoreSubmitDataEventArgs e)
{
try {
var userData = UserData;
var cacheKey = WebUtility.GetCacheKeyName(userData, "energy-detail-data");
var details = HttpRuntime.Cache[cacheKey] as List <EnergyDetailInfo>;
if (details == null)
{
details = AddDataToCache();
}
if (details == null)
{
WebUtility.ShowMessage(EnmErrType.Warning, "获取数据时发生错误，导出失败！");
return;
}
var colNames = e.Parameters["ColumnNames"];
var names = new XmlDocument();
names.LoadXml(colNames);
var datas = new XmlDocument();
var root = datas.CreateElement("records");
datas.AppendChild(root);
for (int i = 0; i < details.Count; i++)
{
var parent_Node = datas.CreateElement("record");
root.AppendChild(parent_Node);
var Name_Node = datas.CreateElement("Name");
Name_Node.InnerText = details[i].Name;
parent_Node.AppendChild(Name_Node);
var Start_Node = datas.CreateElement("Start");
Start_Node.InnerText = details[i].Start;
parent_Node.AppendChild(Start_Node);
var End_Node = datas.CreateElement("End");
End_Node.InnerText = details[i].End;
parent_Node.AppendChild(End_Node);
var Value_Node = datas.CreateElement("Value");
Value_Node.InnerText = details[i].Value.ToString();
parent_Node.AppendChild(Value_Node);
}
var fileName = "EnergyDetails.xls";
var sheetName = "EnergyDetails";
var title = String.Format("动力环境监控中心系统 {0}", Page.Header.Title);
var subTitle = String.Format("值班员:{0} 日期:{1}", Page.User.Identity.Name, WebUtility.GetDateString(DateTime.Now));
var xls = WebUtility.ExportAlarmsToExcel(fileName, sheetName, title, subTitle, names, datas, true);
if (xls != null)
{
xls.Send();
}
} catch (Exception err) {
WebUtility.WriteLog(EnmSysLogLevel.Error, EnmSysLogType.Exception, err.ToString(), Page.User.Identity.Name);
WebUtility.ShowMessage(EnmErrType.Error, err.Message);
}
}
/// <summary>
/// Station Window Submit
/// </summary>
protected void OnStaWnd_Submit(object sender, StoreSubmitDataEventArgs e)
{
try {
var userData = UserData;
var cacheKey = WebUtility.GetCacheKeyName(userData, "station-wnd-data");
var stations = HttpRuntime.Cache[cacheKey] as List <StationInfo>;
if (stations == null)
{
stations = AddDataToCache();
}
if (stations == null)
{
WebUtility.ShowMessage(EnmErrType.Warning, "获取数据时发生错误，导出失败！");
return;
}
var colNames = e.Parameters["ColumnNames"];
var names = new XmlDocument();
names.LoadXml(colNames);
var datas = new XmlDocument();
var root = datas.CreateElement("records");
datas.AppendChild(root);
for (int i = 0; i < stations.Count; i++)
{
var parent_Node = datas.CreateElement("record");
root.AppendChild(parent_Node);
var ID_Node = datas.CreateElement("ID");
ID_Node.InnerText = (i + 1).ToString();
parent_Node.AppendChild(ID_Node);
var LscName_Node = datas.CreateElement("LscName");
LscName_Node.InnerText = stations[i].LscName;
parent_Node.AppendChild(LscName_Node);
var Area1Name_Node = datas.CreateElement("Area1Name");
Area1Name_Node.InnerText = stations[i].Area1Name;
parent_Node.AppendChild(Area1Name_Node);
var Area2Name_Node = datas.CreateElement("Area2Name");
Area2Name_Node.InnerText = stations[i].Area2Name;
parent_Node.AppendChild(Area2Name_Node);
var Area3Name_Node = datas.CreateElement("Area3Name");
Area3Name_Node.InnerText = stations[i].Area3Name;
parent_Node.AppendChild(Area3Name_Node);
var StaID_Node = datas.CreateElement("StaID");
StaID_Node.InnerText = stations[i].StaID.ToString();
parent_Node.AppendChild(StaID_Node);
var StaName_Node = datas.CreateElement("StaName");
StaName_Node.InnerText = stations[i].StaName;
parent_Node.AppendChild(StaName_Node);
var StaTypeName_Node = datas.CreateElement("StaTypeName");
StaTypeName_Node.InnerText = stations[i].StaTypeName;
parent_Node.AppendChild(StaTypeName_Node);
var StaFeatureName_Node = datas.CreateElement("StaFeatureName");
StaFeatureName_Node.InnerText = stations[i].StaFeatureName;
parent_Node.AppendChild(StaFeatureName_Node);
var MID_Node = datas.CreateElement("MID");
MID_Node.InnerText = stations[i].MID;
parent_Node.AppendChild(MID_Node);
}
var fileName = "StationDetails.xls";
var sheetName = "StationDetails";
var title = String.Format("动力环境监控中心系统 {0}", Page.Header.Title);
var subTitle = String.Format("值班员:{0} 日期:{1}", Page.User.Identity.Name, WebUtility.GetDateString(DateTime.Now));
var xls = WebUtility.ExportAlarmsToExcel(fileName, sheetName, title, subTitle, names, datas, true);
if (xls != null)
{
xls.Send();
}
} catch (Exception err) {
WebUtility.WriteLog(EnmSysLogLevel.Error, EnmSysLogType.Exception, err.ToString(), Page.User.Identity.Name);
WebUtility.ShowMessage(EnmErrType.Error, err.Message);
}
}
/// <summary>
/// Save Button Click
/// </summary>
protected void SaveBtn_Click(object sender, DirectEventArgs e)
{
try {
var cacheKey = WebUtility.GetCacheKeyName(UserData, "bat-count-report");
var records = HttpRuntime.Cache[cacheKey] as List <IDValuePair <BatStaticInfo, List <BatStaticInfo> > >;
if (records == null)
{
records = AddDataToCache();
}
if (records == null)
{
WebUtility.ShowMessage(EnmErrType.Warning, "获取数据时发生错误，导出失败！");
return;
}
var colNames = e.ExtraParams["ColumnNames"];
var names = new XmlDocument();
names.LoadXml(colNames);
var datas = new XmlDocument();
var root = datas.CreateElement("records");
datas.AppendChild(root);
for (int i = 0; i < records.Count; i++)
{
if (records[i].ID == null)
{
continue;
}
var parent_Node = datas.CreateElement("record");
root.AppendChild(parent_Node);
var ID_Node = datas.CreateElement("ID");
ID_Node.InnerText = (i + 1).ToString();
parent_Node.AppendChild(ID_Node);
var LscID_Node = datas.CreateElement("LscID");
LscID_Node.InnerText = records[i].ID.LscID.ToString();
parent_Node.AppendChild(LscID_Node);
var LscName_Node = datas.CreateElement("LscName");
LscName_Node.InnerText = records[i].ID.LscName;
parent_Node.AppendChild(LscName_Node);
var Area1Name_Node = datas.CreateElement("Area1Name");
Area1Name_Node.InnerText = records[i].ID.Area1Name;
parent_Node.AppendChild(Area1Name_Node);
var Area2Name_Node = datas.CreateElement("Area2Name");
Area2Name_Node.InnerText = records[i].ID.Area2Name;
parent_Node.AppendChild(Area2Name_Node);
var Area3Name_Node = datas.CreateElement("Area3Name");
Area3Name_Node.InnerText = records[i].ID.Area3Name;
parent_Node.AppendChild(Area3Name_Node);
var StaName_Node = datas.CreateElement("StaName");
StaName_Node.InnerText = records[i].ID.StaName;
parent_Node.AppendChild(StaName_Node);
var DevID_Node = datas.CreateElement("DevID");
DevID_Node.InnerText = records[i].ID.DevID.ToString();
parent_Node.AppendChild(DevID_Node);
var DevName_Node = datas.CreateElement("DevName");
DevName_Node.InnerText = records[i].ID.DevName;
parent_Node.AppendChild(DevName_Node);
var DevIndex_Node = datas.CreateElement("DevIndex");
DevIndex_Node.InnerText = records[i].ID.DevIndex.ToString();
parent_Node.AppendChild(DevIndex_Node);
var FDCount_Node = datas.CreateElement("FDCount");
FDCount_Node.InnerText = records[i].Value.Count.ToString();
parent_Node.AppendChild(FDCount_Node);
}
var fileName = "BatCountReport.xls";
var sheetName = "BatCountReport";
var title = "动力环境监控中心系统 电池放电统计报表";
var subTitle = String.Format("值班员:{0} 日期:{1}", Page.User.Identity.Name, WebUtility.GetDateString(DateTime.Now));
var xls = WebUtility.ExportAlarmsToExcel(fileName, sheetName, title, subTitle, names, datas, true);
if (xls != null)
{
xls.Send();
}
} catch (Exception err) {
WebUtility.WriteLog(EnmSysLogLevel.Error, EnmSysLogType.Exception, err.ToString(), Page.User.Identity.Name);
WebUtility.ShowMessage(EnmErrType.Error, err.Message);
}
}