/// <summary>
/// 输出csv文件
/// </summary>
/// <param name="allmts"></param>
/// <param name="timemtMap"></param>
/// <param name="filename"></param>
/// <returns></returns>
public ActionResult DownLoadCsvRunData(IList <string> allmts, IDictionary <string, IDictionary <string, string> > timemtMap, string filename)
{
CsvStreamWriter scvWriter = new CsvStreamWriter();
//输入出到csv文件中的数据列表
IList <string> dataList = new List <string>();
//设置抬头行
dataList.Add(" " + filename + " ");
//循环设置数据行
//设置标题行
allmts.Insert(0, Resources.SunResource.REPORT_TIME);
dataList.Add(scvWriter.ConvertToSaveLine(allmts));
//数据行临时list
IList <string> tempList = new List <string>();
foreach (string key in timemtMap.Keys)
{
dataList.Add(scvWriter.ConvertToSaveCell(key) + "," + scvWriter.ConvertToSaveLine(timemtMap[key].Values));
}
scvWriter.AddStrDataList(dataList);
scvWriter.Save(Server.MapPath("/") + "tempexportfile/" + filename + ".csv");
return(File(Server.MapPath("/") + "tempexportfile/" + filename + ".csv", "text/csv; charset=UTF-8", urlcode(filename) + ".csv"));
}
public ActionResult DownLoadDayReport(string id, string reportId, string cTime)
{
DefineReport report = reportService.GetRunReportById(reportId);
int tId = report.ReportType;
IList <string> dataList = new List <string>();
IList <object> obj = reportService.getDatabyItemCodes(report, cTime);
IList <int> itemCode = addIntNumtoList(obj[0] as List <int>);
Hashtable plantDataHash = obj[1] as Hashtable;
Hashtable deviceDataHash = obj[2] as Hashtable;
CsvStreamWriter csv = new CsvStreamWriter();
dataList.Add(" " + report.ReportName + " ");
ArrayList list2 = new ArrayList();
list2.Add(" " + Resources.SunResource.REPORT_VIEW_TIME);
list2.Add(cTime);
dataList.Add(csv.ConvertToSaveLine(list2));
dataList.Add(Resources.SunResource.REPORT_PLANT_COUNT_DATA);
ArrayList list3 = new ArrayList();
ArrayList list4 = new ArrayList();
int i = 1;
foreach (int code in itemCode)
{
int tmpcode = code;
string keystr = " ", keyvalue = " ";
if (i == 5)
{
i = 1;
}
else
{
i++;
}
if (tmpcode != 0)
{
keystr = DataItem.getNameByCode(tmpcode);
keyvalue = plantDataHash[tmpcode].ToString();
list3.Add(keystr);
list3.Add(keyvalue);
}
}
dataList.Add(csv.ConvertToSaveLine(list3));
dataList.Add(Resources.SunResource.REPORT_DEVICE_COUNT_DATA);
list4.Add(Resources.SunResource.REPORT_COUNT_ITEM);
list4.Add(Resources.SunResource.REPORT_COUNT_DEVICE);
list4.Add("7:00");
list4.Add("8:00");
list4.Add("9:00");
list4.Add("10:00");
list4.Add("11:00");
list4.Add("12:00");
list4.Add("13:00");
list4.Add("14:00");
list4.Add("15:00");
list4.Add("16:00");
list4.Add("17:00");
list4.Add("18:00");
list4.Add("19:00");
list4.Add(Resources.SunResource.REPORT_COUNT_TODAYSUN);
dataList.Add(csv.ConvertToSaveLine(list4));
foreach (DictionaryEntry de in deviceDataHash)
{
i = 1;
string tmpcode = de.Key.ToString();
string keystr = "", unit = "";
if (!tmpcode.StartsWith(" "))
{
keystr = DataItem.getNameByCode(int.Parse(tmpcode));
unit = MonitorType.getMonitorTypeByCode(int.Parse(tmpcode)).unit;
}
IList <string[]> dataArrList = (IList <string[]>)de.Value;
for (int k = 1; k < dataArrList.Count; k++)
{
ArrayList list5 = new ArrayList();
string[] dataArr = dataArrList[k];
if (i == 1)
{
i++;
list5.Add(keystr + " " + unit);
list5.Add(dataArr[1]);
list5.Add(dataArr[2]);
list5.Add(dataArr[3]);
list5.Add(dataArr[4]);
list5.Add(dataArr[5]);
list5.Add(dataArr[6]);
list5.Add(dataArr[7]);
list5.Add(dataArr[8]);
list5.Add(dataArr[9]);
list5.Add(dataArr[10]);
list5.Add(dataArr[11]);
list5.Add(dataArr[12]);
list5.Add(dataArr[13]);
list5.Add(dataArr[14]);
list5.Add(dataArr[15]);
}
else
{
list5.Add(" ");
list5.Add(dataArr[1]);
list5.Add(dataArr[2]);
list5.Add(dataArr[3]);
list5.Add(dataArr[4]);
list5.Add(dataArr[5]);
list5.Add(dataArr[6]);
list5.Add(dataArr[7]);
list5.Add(dataArr[8]);
list5.Add(dataArr[9]);
list5.Add(dataArr[10]);
list5.Add(dataArr[11]);
list5.Add(dataArr[12]);
list5.Add(dataArr[13]);
list5.Add(dataArr[14]);
list5.Add(dataArr[15]);
}
dataList.Add(csv.ConvertToSaveLine(list5));
}
}
CsvStreamWriter scvWriter = new CsvStreamWriter();
scvWriter.AddStrDataList(dataList);
scvWriter.Save(Server.MapPath("/") + "tempexportfile/" + (report.ReportName + "-" + cTime) + ".csv");
//转化为csv格式的字符串
//string res="dsfdsf";
//byte[] bytes = Encoding.Default.GetBytes(res);
return(File(Server.MapPath("/") + "tempexportfile/" + (report.ReportName + "-" + cTime) + ".csv", "text/csv; charset=UTF-8", urlcode(report.ReportName.Replace(" ", "") + "-" + cTime) + ".csv"));
}
public ActionResult DownLoadNotDayReport(string id, string reportId, string cTime)
{
DefineReport report = reportService.GetRunReportById(reportId);
int tId = report.ReportType;
string weekTime = string.Empty;
if (tId == DataReportType.TOTAL_REPORT_CODE)
{
IList <int> workYears = null;
if (!(string.IsNullOrEmpty(id)))
{
workYears = collectorYearDataService.GetWorkYears(report.plant);
}
else
{
workYears = collectorYearDataService.GetWorkYears(report.user.plants);
}
if (workYears.Count > 0)
{
cTime = workYears[0] + "-" + workYears[workYears.Count - 1];
}
}
else if (tId == DataReportType.WEEK_REPORT_CODE)
{
string[] wTime = reportService.convertToDateArr(tId, cTime);
int year1 = int.Parse(wTime[0].Substring(0, 4));
int mm1 = int.Parse(wTime[0].Substring(4, 2));
int dd1 = int.Parse(wTime[0].Substring(6, 2));
int year2 = int.Parse(wTime[1].Substring(0, 4));
int mm2 = int.Parse(wTime[1].Substring(4, 2));
int dd2 = int.Parse(wTime[1].Substring(6, 2));
weekTime = year1 + "/" + mm1 + "/" + dd1 + "-" + year2 + "/" + mm2 + "/" + dd2;
}
IList <string> dataList = new List <string>();
IList <object> obj = reportService.getDatabyItemCodes(report, cTime);
IList <int> itemCode = addIntNumtoList(obj[0] as List <int>);
Hashtable plantDataHash = obj[1] as Hashtable;
Hashtable deviceDataHash = obj[2] as Hashtable;
CsvStreamWriter csv = new CsvStreamWriter();
dataList.Add(" " + report.ReportName + " ");
ArrayList list2 = new ArrayList();
list2.Add(" " + Resources.SunResource.REPORT_VIEW_TIME);
if (tId == DataReportType.WEEK_REPORT_CODE)
{
list2.Add(weekTime);
}
else
{
list2.Add(cTime);
}
dataList.Add(csv.ConvertToSaveLine(list2));
dataList.Add(Resources.SunResource.REPORT_PLANT_COUNT_DATA);
ArrayList list3 = new ArrayList();
ArrayList list4 = new ArrayList();
int i = 1;
foreach (int code in itemCode)
{
int tmpcode = code;
string keystr = " ", keyvalue = " ";
if (i == 5)
{
i = 1;
}
else
{
i++;
}
if (tmpcode != 0)
{
keystr = DataItem.getNameByCode(tmpcode);
keyvalue = plantDataHash[tmpcode].ToString();
list3.Add(keystr);
list3.Add(keyvalue);
}
}
dataList.Add(csv.ConvertToSaveLine(list3));
dataList.Add(Resources.SunResource.REPORT_DEVICE_COUNT_DATA);
foreach (DictionaryEntry de in deviceDataHash)
{
i = 1;
string tmpcode = de.Key.ToString();
string keystr = "", unit = "";
if (!tmpcode.StartsWith(" "))
{
keystr = MonitorType.getMonitorTypeByCode(MonitorType.PLANT_MONITORITEM_ENERGY_CODE).name;
unit = MonitorType.getMonitorTypeByCode(MonitorType.PLANT_MONITORITEM_ENERGY_CODE).unit;
}
IList <string[]> dataArrList = (IList <string[]>)de.Value;
for (int k = 0; k < dataArrList.Count; k++)
{
ArrayList list5 = new ArrayList();
string[] dataArr = dataArrList[k];
if (i == 1)
{
i++;
foreach (string v in dataArr)
{
list5.Add(v);
}
}
else if (i == 2)
{
i++;
list5.Add(keystr + " " + unit);
for (int n = 1; n < dataArr.Length; n++)
{
list5.Add(dataArr[n]);
}
}
else
{
for (int m = 0; m < dataArr.Length; m++)
{
list5.Add(dataArr[m] == null?" ":dataArr[m]);
}
}
dataList.Add(csv.ConvertToSaveLine(list5));
}
}
CsvStreamWriter scvWriter = new CsvStreamWriter();
scvWriter.AddStrDataList(dataList);
scvWriter.Save(Server.MapPath("/") + "tempexportfile/" + (report.ReportName + "-" + cTime) + ".csv");
//转化为csv格式的字符串
//string res="dsfdsf";
//byte[] bytes = Encoding.Default.GetBytes(res);
return(File(Server.MapPath("/") + "tempexportfile/" + (report.ReportName + "-" + cTime) + ".csv", "text/csv; charset=UTF-8", urlcode(report.ReportName.Replace(" ", "") + "-" + cTime) + ".csv"));
}
public ActionResult DownLoadAllPlantsReport(string id, string reportId, string cTime)
{
DefineReport report = reportService.GetRunReportById(reportId);
int tId = report.ReportType;
string weekTime = string.Empty;
if (tId == DataReportType.TOTAL_REPORT_CODE)
{
IList <int> workYears = null;
if (!(string.IsNullOrEmpty(id)))
{
workYears = collectorYearDataService.GetWorkYears(report.plant);
}
else
{
workYears = collectorYearDataService.GetWorkYears(report.user.plants);
}
if (workYears.Count > 0)
{
cTime = workYears[0] + "-" + workYears[workYears.Count - 1];
}
}
else if (tId == DataReportType.WEEK_REPORT_CODE)
{
string[] wTime = reportService.convertToDateArr(tId, cTime);
int year1 = int.Parse(wTime[0].Substring(0, 4));
int mm1 = int.Parse(wTime[0].Substring(4, 2));
int dd1 = int.Parse(wTime[0].Substring(6, 2));
int year2 = int.Parse(wTime[1].Substring(0, 4));
int mm2 = int.Parse(wTime[1].Substring(4, 2));
int dd2 = int.Parse(wTime[1].Substring(6, 2));
weekTime = year1 + "/" + mm1 + "/" + dd1 + "-" + year2 + "/" + mm2 + "/" + dd2;
}
IList <string> dataList = new List <string>();
IList <object> obj = reportService.getDatabyItemCodes(report, cTime);
IList <int> itemCode = addIntNumtoList(obj[0] as List <int>);
Hashtable plantDataHash = obj[1] as Hashtable;
Hashtable deviceDataHash = obj[2] as Hashtable;
CsvStreamWriter csv = new CsvStreamWriter();
dataList.Add(" " + report.ReportName + " ");
ArrayList list2 = new ArrayList();
list2.Add(" " + Resources.SunResource.REPORT_VIEW_TIME);
if (tId == 2)
{
list2.Add(weekTime);
}
else
{
list2.Add(cTime);
}
dataList.Add(csv.ConvertToSaveLine(list2));
dataList.Add(Resources.SunResource.REPORT_PLANT_COUNT_DATA);
ArrayList list3 = new ArrayList();
int i = 1;
foreach (int code in itemCode)
{
int tmpcode = code;
string keystr = " ", keyvalue = " ";
if (i == 5)
{
i = 1;
}
else
{
i++;
}
if (tmpcode != 0)
{
keystr = DataItem.getNameByCode(tmpcode);
keyvalue = plantDataHash[tmpcode].ToString();
list3.Add(keystr);
list3.Add(keyvalue);
}
}
dataList.Add(csv.ConvertToSaveLine(list3));
CsvStreamWriter scvWriter = new CsvStreamWriter();
scvWriter.AddStrDataList(dataList);
scvWriter.Save(Server.MapPath("/") + "tempexportfile/" + (report.ReportName + "-" + cTime) + ".csv");
//转化为csv格式的字符串
//string res="dsfdsf";
//byte[] bytes = Encoding.Default.GetBytes(res);
return(File(Server.MapPath("/") + "tempexportfile/" + (report.ReportName + "-" + cTime) + ".csv", "text/csv; charset=UTF-8", urlcode(report.ReportName.Replace(" ", "") + "-" + cTime) + ".csv"));
}