public ReportQueryModelNew getRequestModel()
{
string Faild = "Error";
string starttime = Strings.getRequestString(System.Web.HttpContext.Current.Request["starttime"], RequestDataType.DataTime);
string endtimestr = Strings.getRequestString(System.Web.HttpContext.Current.Request["endtime"], RequestDataType.DataString);
if (endtimestr.Contains("24:00:00"))
{
endtimestr = endtimestr.Replace("24:00:00", "23:59:59");
DateTime dts = DateTime.Parse(endtimestr);
dts = dts.AddSeconds(1);
endtimestr = dts.ToShortDateString();
}
string endtime = Strings.getRequestString(endtimestr, RequestDataType.DataTime);
string itemcode = Strings.getRequestString(System.Web.HttpContext.Current.Request["itemcode"], RequestDataType.DataInt);
string objectid = Strings.getRequestString(System.Web.HttpContext.Current.Request["objectid"], RequestDataType.DataString);
string unit = Strings.getRequestString(System.Web.HttpContext.Current.Request["unit"], RequestDataType.DataInt);
string objecttype = Strings.getRequestString(System.Web.HttpContext.Current.Request["objecttype"], RequestDataType.DataInt);
if (starttime.Equals(Faild) || endtime.Equals(Faild) || itemcode.Equals(Faild) || objectid.Equals(Faild) || unit.Equals(Faild))
{
return(null);
//return "{msg:'参数传递的格式不正确。'}";
}
ReportQueryModelNew model = new ReportQueryModelNew();
model.startime = DateTime.Parse(starttime);
model.objectid = objectid;
model.endtime = DateTime.Parse(endtime);
model.itemcode = itemcode;
model.timeunit = (ReportStyleNew)int.Parse(unit);
model.objecttype = Convert.ToInt32(objecttype);
return(model);
}
/// <summary>
/// 导出所有能源信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string ExportItemEnergy(string starttime, string endtime, string objectid, string timeunit, string counttype, string SavePath)
{
try
{
Itemcode itemcodeBll = new Itemcode();
ReportQueryModelNew model = new ReportQueryModelNew();
model.startime = DateTime.Parse(starttime);
model.endtime = DateTime.Parse(endtime);
model.objectid = objectid;
model.timeunit = (ReportStyleNew)(int.Parse(timeunit));
model.objecttype = 0;
model.itemcode = counttype;
string strPath = SavePath; // AppDomain.CurrentDomain.BaseDirectory + "temp_file\\";
string strTemPath = AppDomain.CurrentDomain.BaseDirectory + "ExcelTemplate\\项目能耗查询.xls";
IList <Model.Itemcode> itemcode = itemcodeBll.GetItemcodeList(
" and itemcodenumber = '" + counttype + "'", "");
string strUnit = "mch";
if (itemcode.Count > 0)
{
strUnit = itemcode[0].Unit;
}
#region 第2种方法
DataTable dtlist = GetItemcodeData(model);
string name = GetBaseLayerObjectName(model.objectid);
#endregion
if (dtlist != null)
{
string temp_path = strPath; //AppDomain.CurrentDomain.BaseDirectory + "temp_file\\";
if (!Directory.Exists(temp_path))
{
Directory.CreateDirectory(temp_path);
string[] files = Directory.GetFiles(temp_path);
foreach (string fn in files)
{
File.Delete(temp_path + fn);
}
}
string save_path = DateTime.Now.Ticks + ".xls";
string templatePath = strTemPath; // AppDomain.CurrentDomain.BaseDirectory + "template\\区域能耗查询.xls";
string datetime = model.startime.ToString("yyyy-MM-dd") + "~" + (model.timeunit == ReportStyleNew.DayStyle ? model.endtime.ToString("yyyy-MM-dd HH:59:59") : model.endtime.ToString("yyyy-MM-dd"));
TemplateParam param = new TemplateParam(name, new CellParam(0, 0), datetime, new CellParam(3, 0), false, new CellParam(4, 0));
//param.DataColumn = new[] { 0, 3, 6, 7, 8, 9};
param.DataColumn = new[] { 0, 1, 3, 6, 7 };
param.ItemUnit = "能耗值:(" + strUnit + "）";
param.ItemUnitCell = new CellParam(4, 4);
dtlist.TableName = "能耗查询统计";
string strDownFile = temp_path + save_path;
//return "{\"status\":\"success\",\"msg\":\"" + "/temp_file/" + save_path + "\"}";
ExportHelper.ExportExcel(dtlist, strDownFile, strTemPath, param);
//return "{\"status\":\"success\",\"msg\":\"" + "/temp_file/" + save_path + "\"}";
return("{\"status\":\"success\",\"msg\":\"" + "/temp_file/" + save_path + "\"}");
}
else
{
return("{\"status\":\"error\",\"msg\":\"导出失败：当前无任何数据\"}");
}
}
catch (Exception ex)
{
return("{\"status\":\"error\",\"msg\":\"导出失败:没有数据！\"}");
}
}
public DataTable GetItemcodeData(ReportQueryModelNew model)
{
int objectid;
float total = 0;
DataTable dt = CreateTable.CreateBaseDataTable();
//if (!new CreateTable().ObjectIsConfig(model, out objectid))
//{
// return null;
//}
try
{
string objectname = Getobjectname(model.objectid);
string itemcodename = Getitemcodename(model.itemcode);
BaseDataModelNew DataModel = new BaseDataModelNew();
DataModel.Starttime = model.startime;
DataModel.Endtime = model.endtime;
DataModel.ObjectId = int.Parse(model.objectid);
DataModel.ItemCode = model.itemcode;
DataModel.Unit = CreateTable.ConvertBaseCountType(model.timeunit).ToString();
// Datamodel.timeunit = CreateTable.ConvertBaseCountType(model.timeunit).ToString(); //
#region 处理加工
DataTable dtdata = DataCommon.GetBaseDataItem(DataModel);
#region 非年
if (model.timeunit != ReportStyleNew.YearStyle) // 非年
{
//if (model.timeunit == ReportStyleNew.DayStyle)
//{
// model.startime = model.startime.AddHours(1);
//}
for (DateTime i = model.startime; i <= model.endtime; i = (model.timeunit == ReportStyleNew.DayStyle) ? i.AddHours(1) : i.AddDays(1))
{
//if (model.timeunit == ReportStyleNew.DayStyle && i.Hour==0)
//{
// continue;
//}
DataRow dr = dt.NewRow();
dr[1] = CreateTable.ReportFormatDate(i.ToString(), model.timeunit);
dr[2] = model.objectid;
dr[3] = objectname;
dr[4] = i;
dr[5] = i.AddDays(1);
dr[6] = itemcodename;
dr[7] = 0;
if (dtdata.Rows.Count > 0)
{
for (int j = 0; j < dtdata.Rows.Count; j++)
{
if (model.timeunit == ReportStyleNew.DayStyle)
{
if (Convert.ToDateTime(dtdata.Rows[j]["Starttime"]).Hour == i.Hour)
{
//dr[1] = CreateTable.FormatDate(dtdata.Rows[j]["Starttime"].ToString(), model.timeunit);
dr[7] = Math.Round(float.Parse(dtdata.Rows[j]["CountValue"].ToString()), 2);
total += float.Parse(dr[7].ToString());
break;
}
}
else
{
if (Convert.ToDateTime(dtdata.Rows[j]["Starttime"]).Date == i.Date)
{
//dr[1] = CreateTable.FormatDate(dtdata.Rows[j]["Starttime"].ToString(), model.timeunit);
dr[7] = Math.Round(float.Parse(dtdata.Rows[j]["CountValue"].ToString()), 2);
total += float.Parse(dr[7].ToString());
break;
}
}
}
}
dt.Rows.Add(dr);
}
}
#endregion
#region 年
else // 年
{
for (DateTime i = model.startime; i <= model.endtime; i = i.AddMonths(1))
{
DataRow dr = dt.NewRow();
dr[1] = CreateTable.ReportFormatDate(i.ToString(), model.timeunit);
dr[2] = model.objectid;
dr[3] = objectname;
dr[4] = i;
dr[5] = i.AddDays(1);
dr[6] = itemcodename;
dr[7] = 0;
if (dtdata.Rows.Count > 0)
{
for (int j = 0; j < dtdata.Rows.Count; j++)
{
if (model.timeunit == ReportStyleNew.DayStyle)
{
if (Convert.ToDateTime(dtdata.Rows[j]["Starttime"]).Hour == i.Hour)
{
//dr[1] = CreateTable.ReportFormatDate(dtdata.Rows[j]["Starttime"].ToString(), model.timeunit);
dr[7] = Math.Round(float.Parse(dtdata.Rows[j]["CountValue"].ToString()), 2);
total += float.Parse(dr[7].ToString());
break;
}
}
else
{
if (Convert.ToDateTime(dtdata.Rows[j]["Starttime"]).Date == i.Date)
{
//dr[1] = CreateTable.ReportFormatDate(dtdata.Rows[j]["Starttime"].ToString(), model.timeunit);
dr[7] = Math.Round(float.Parse(dtdata.Rows[j]["CountValue"].ToString()), 2);
total += float.Parse(dr[7].ToString());
break;
}
}
}
}
dt.Rows.Add(dr);
}
}
#endregion
DataRow totaldr = dt.NewRow();
totaldr[1] = CreateTable.ReportFormatDate(model.startime.ToString(), model.timeunit) + "-" +
CreateTable.ReportFormatDate(model.endtime.ToString(),
model.timeunit);
totaldr[2] = model.objectid;
totaldr[3] = objectname;
totaldr[4] = "-";
totaldr[5] = "-";
totaldr[6] = itemcodename;
totaldr[7] = Math.Round(total, 2).ToString();
dt.Rows.Add(totaldr);
#endregion
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
//return null;
}
}
public DataTable GetItemcodeDataAll(ReportQueryModelNew model, DataTable dtItemCode)
{
int objectid;
float total1 = 0;
float total2 = 0;
float total3 = 0;
float total4 = 0;
// 电
float decITEMCOAL1 = 0;
// 水
float decITEMCOAL2 = 0;
// 气
float decITEMCOAL3 = 0;
// 煤
float decITEMCOAL4 = 0;
if (dtItemCode.Rows[0]["ITEMCOAL"] != DBNull.Value)
{
decITEMCOAL1 = float.Parse(dtItemCode.Rows[0]["ITEMCOAL"].ToString());
}
if (dtItemCode.Rows[1]["ITEMCOAL"] != DBNull.Value)
{
decITEMCOAL2 = float.Parse(dtItemCode.Rows[1]["ITEMCOAL"].ToString());
}
if (dtItemCode.Rows[2]["ITEMCOAL"] != DBNull.Value)
{
decITEMCOAL3 = float.Parse(dtItemCode.Rows[2]["ITEMCOAL"].ToString());
}
if (dtItemCode.Rows[3]["ITEMCOAL"] != DBNull.Value)
{
decITEMCOAL4 = float.Parse(dtItemCode.Rows[3]["ITEMCOAL"].ToString());
}
float totalzhm = 0;
DataTable dt = CreateTable.CreateBaseDataTableAll();
//if (!new CreateTable().ObjectIsConfigAll(model, out objectid))
//{
// return null;
//}
try
{
string objectname = Getobjectname(model.objectid);
string itemcodename = Getitemcodename(model.itemcode);
////List<int> lstCountId = new List<int>();
////for (int jCount = 0; jCount < dtItemCode.Rows.Count; jCount++)
////{
//// int countId = GetObjectCountId(model.objectid, model.objecttype, CreateTable.ConvertBaseCountType(model.timeunit), int.Parse(dtItemCode.Rows[jCount]["ItemCodeId"].ToString()));
//// lstCountId.Add(countId);
////}
BaseDataModelNew DataModel = new BaseDataModelNew();
DataModel.Starttime = model.startime;
DataModel.Endtime = model.endtime;
DataModel.ObjectId = int.Parse(model.objectid);
DataModel.Unit = CreateTable.ConvertBaseCountType(model.timeunit).ToString();
#region 处理加工
DataTable[] dtdata = DataCommon.GetBaseDataAll(DataModel, dtItemCode);
#endregion
if (model.timeunit != ReportStyleNew.YearStyle)
{
#region 日月
for (DateTime i = model.startime; i <= model.endtime; i = (model.timeunit == ReportStyleNew.DayStyle) ? i.AddHours(1) : i.AddDays(1))
{
//if (model.timeunit == ReportStyleNew.DayStyle && i.Hour==0)
//{
// continue;
//}
DataRow dr = dt.NewRow();
dr[1] = CreateTable.ReportFormatDate(i.ToString(), model.timeunit);
dr[2] = model.objectid;
dr[3] = objectname;
dr[4] = i;
dr[5] = i.AddDays(1);
//dr[6] = itemcodename;
//dr[7] = 0;
dr[6] = 0;
dr[7] = 0;
dr[8] = 0;
dr[9] = 0;
dr[10] = 0;
DataTable dt1 = dtdata[0];
DataTable dt2 = dtdata[1];
DataTable dt3 = dtdata[2];
DataTable dt4 = dtdata[3];
#region 电
if (dt1.Rows.Count > 0)
{
for (int j = 0; j < dt1.Rows.Count; j++)
{
if (model.timeunit == ReportStyleNew.DayStyle)
{
if (Convert.ToDateTime(dt1.Rows[j]["Starttime"]).Hour == i.Hour)
{
//dr[1] = CreateTable.ReportFormatDate(dtdata.Rows[j]["Starttime"].ToString(), model.timeunit);
dr[6] = Math.Round(float.Parse(dt1.Rows[j]["CountValue"].ToString()), 2);
total1 += float.Parse(dr[6].ToString());
}
}
else
{
if (Convert.ToDateTime(dt1.Rows[j]["Starttime"]).Date == i.Date)
{
//dr[1] = CreateTable.ReportFormatDate(dtdata.Rows[j]["Starttime"].ToString(), model.timeunit);
dr[6] = Math.Round(float.Parse(dt1.Rows[j]["CountValue"].ToString()), 2);
total1 += float.Parse(dr[6].ToString());
break;
}
}
}
}
#endregion
#region 水
if (dt2.Rows.Count > 0)
{
for (int j = 0; j < dt2.Rows.Count; j++)
{
if (model.timeunit == ReportStyleNew.DayStyle)
{
if (Convert.ToDateTime(dt2.Rows[j]["Starttime"]).Hour == i.Hour)
{
dr[7] = Math.Round(float.Parse(dt2.Rows[j]["CountValue"].ToString()), 2);
total2 += float.Parse(dr[7].ToString());
break;
}
}
else
{
if (Convert.ToDateTime(dt2.Rows[j]["Starttime"]).Date == i.Date)
{
//dr[1] = CreateTable.ReportFormatDate(dtdata.Rows[j]["Starttime"].ToString(), model.timeunit);
dr[7] = Math.Round(float.Parse(dt2.Rows[j]["CountValue"].ToString()), 2);
total2 += float.Parse(dr[7].ToString());
break;
}
}
}
}
#endregion
#region 气
if (dt3.Rows.Count > 0)
{
for (int j = 0; j < dt3.Rows.Count; j++)
{
if (model.timeunit == ReportStyleNew.DayStyle)
{
if (Convert.ToDateTime(dt3.Rows[j]["Starttime"]).Hour == i.Hour)
{
//dr[1] = CreateTable.FormatDate(dtdata.Rows[j]["Starttime"].ToString(), model.timeunit);
dr[8] = Math.Round(float.Parse(dt3.Rows[j]["CountValue"].ToString()), 2);
total3 += float.Parse(dr[8].ToString());
break;
}
}
else
{
if (Convert.ToDateTime(dt3.Rows[j]["Starttime"]).Date == i.Date)
{
//dr[1] = CreateTable.FormatDate(dtdata.Rows[j]["Starttime"].ToString(), model.timeunit);
dr[8] = Math.Round(float.Parse(dt3.Rows[j]["CountValue"].ToString()), 2);
total3 += float.Parse(dr[8].ToString());
break;
}
}
}
}
#endregion
#region 供暖
if (dt4.Rows.Count > 0)
{
for (int j = 0; j < dt4.Rows.Count; j++)
{
if (model.timeunit == ReportStyleNew.DayStyle)
{
if (Convert.ToDateTime(dt4.Rows[j]["Starttime"]).Hour == i.Hour)
{
//dr[1] = CreateTable.FormatDate(dtdata.Rows[j]["Starttime"].ToString(), model.timeunit);
dr[9] = Math.Round(float.Parse(dt4.Rows[j]["CountValue"].ToString()), 2);
total4 += float.Parse(dr[9].ToString());
break;
}
}
else
{
if (Convert.ToDateTime(dt4.Rows[j]["Starttime"]).Date == i.Date)
{
//dr[1] = CreateTable.FormatDate(dtdata.Rows[j]["Starttime"].ToString(), model.timeunit);
dr[9] = Math.Round(float.Parse(dt4.Rows[j]["CountValue"].ToString()), 2);
total4 += float.Parse(dr[9].ToString());
break;
}
}
}
}
dr[10] = float.Parse(dr[6].ToString()) * decITEMCOAL1 +
float.Parse(dr[7].ToString()) * decITEMCOAL2 +
float.Parse(dr[8].ToString()) * decITEMCOAL3 +
float.Parse(dr[9].ToString()) * decITEMCOAL4;
#endregion
dt.Rows.Add(dr);
}
#endregion
}
else
{
#region 年
for (DateTime i = model.startime; i <= model.endtime; i = i.AddMonths(1))
{
//if (model.timeunit == ReportStyleNew.DayStyle && i.Hour==0)
//{
// continue;
//}
DataRow dr = dt.NewRow();
dr[1] = CreateTable.ReportFormatDate(i.ToString(), model.timeunit);
dr[2] = model.objectid;
dr[3] = objectname;
dr[4] = i;
dr[5] = i.AddDays(1);
//dr[6] = itemcodename;
//dr[7] = 0;
dr[6] = 0;
dr[7] = 0;
dr[8] = 0;
dr[9] = 0;
DataTable dt1 = dtdata[0];
DataTable dt2 = dtdata[1];
DataTable dt3 = dtdata[2];
DataTable dt4 = dtdata[3];
#region 电
if (dt1.Rows.Count > 0)
{
for (int j = 0; j < dt1.Rows.Count; j++)
{
if (model.timeunit == ReportStyleNew.DayStyle)
{
if (Convert.ToDateTime(dt1.Rows[j]["ENDTIME"]).Hour == i.Hour)
{
//dr[1] = CreateTable.FormatDate(dtdata.Rows[j]["Starttime"].ToString(), model.timeunit);
dr[6] = Math.Round(float.Parse(dt1.Rows[j]["CountValue"].ToString()), 2);
total1 += float.Parse(dr[6].ToString());
break;
}
}
else
{
if (Convert.ToDateTime(dt1.Rows[j]["Starttime"]).Date == i.Date)
{
//dr[1] = CreateTable.FormatDate(dtdata.Rows[j]["Starttime"].ToString(), model.timeunit);
dr[6] = Math.Round(float.Parse(dt1.Rows[j]["CountValue"].ToString()), 2);
total1 += float.Parse(dr[6].ToString());
break;
}
}
}
}
#endregion
#region 水
if (dt2.Rows.Count > 0)
{
for (int j = 0; j < dt2.Rows.Count; j++)
{
if (model.timeunit == ReportStyleNew.DayStyle)
{
if (Convert.ToDateTime(dt2.Rows[j]["ENDTIME"]).Hour == i.Hour)
{
//dr[1] = CreateTable.FormatDate(dtdata.Rows[j]["Starttime"].ToString(), model.timeunit);
dr[7] = Math.Round(float.Parse(dt2.Rows[j]["CountValue"].ToString()), 2);
total2 += float.Parse(dr[7].ToString());
break;
}
}
else
{
if (Convert.ToDateTime(dt2.Rows[j]["Starttime"]).Date == i.Date)
{
//dr[1] = CreateTable.FormatDate(dtdata.Rows[j]["Starttime"].ToString(), model.timeunit);
dr[7] = Math.Round(float.Parse(dt2.Rows[j]["CountValue"].ToString()), 2);
total2 += float.Parse(dr[7].ToString());
break;
}
}
}
}
#endregion
#region 气
if (dt3.Rows.Count > 0)
{
for (int j = 0; j < dt3.Rows.Count; j++)
{
if (model.timeunit == ReportStyleNew.DayStyle)
{
if (Convert.ToDateTime(dt3.Rows[j]["ENDTIME"]).Hour == i.Hour)
{
//dr[1] = CreateTable.FormatDate(dtdata.Rows[j]["Starttime"].ToString(), model.timeunit);
dr[8] = Math.Round(float.Parse(dt3.Rows[j]["CountValue"].ToString()), 2);
total3 += float.Parse(dr[8].ToString());
break;
}
}
else
{
if (Convert.ToDateTime(dt3.Rows[j]["Starttime"]).Date == i.Date)
{
//dr[1] = CreateTable.FormatDate(dtdata.Rows[j]["Starttime"].ToString(), model.timeunit);
dr[8] = Math.Round(float.Parse(dt3.Rows[j]["CountValue"].ToString()), 2);
total3 += float.Parse(dr[8].ToString());
break;
}
}
}
}
#endregion
#region 供暖
if (dt4.Rows.Count > 0)
{
for (int j = 0; j < dt4.Rows.Count; j++)
{
if (model.timeunit == ReportStyleNew.DayStyle)
{
if (Convert.ToDateTime(dt4.Rows[j]["ENDTIME"]).Hour == i.Hour)
{
//dr[1] = CreateTable.FormatDate(dtdata.Rows[j]["Starttime"].ToString(), model.timeunit);
dr[9] = Math.Round(float.Parse(dt4.Rows[j]["CountValue"].ToString()), 2);
total4 += float.Parse(dr[9].ToString());
break;
}
}
else
{
if (Convert.ToDateTime(dt4.Rows[j]["Starttime"]).Date == i.Date)
{
//dr[1] = CreateTable.FormatDate(dtdata.Rows[j]["Starttime"].ToString(), model.timeunit);
dr[9] = Math.Round(float.Parse(dt4.Rows[j]["CountValue"].ToString()), 2);
total4 += float.Parse(dr[9].ToString());
break;
}
}
}
}
#endregion
dr[10] = float.Parse(dr[6].ToString()) * decITEMCOAL1 +
float.Parse(dr[7].ToString()) * decITEMCOAL2 +
float.Parse(dr[8].ToString()) * decITEMCOAL3 +
float.Parse(dr[9].ToString()) * decITEMCOAL4;
dt.Rows.Add(dr);
}
#endregion
}
#region
DataRow totaldr = dt.NewRow();
totaldr[1] = CreateTable.ReportFormatDate(model.startime.ToString(), model.timeunit) + "-" +
CreateTable.ReportFormatDate(model.endtime.ToString(),
model.timeunit);
totaldr[2] = model.objectid;
totaldr[3] = objectname;
totaldr[4] = "-";
totaldr[5] = "-";
//totaldr[6] = itemcodename;
totaldr[6] = Math.Round(total1, 2).ToString();
totaldr[7] = Math.Round(total2, 2).ToString();
totaldr[8] = Math.Round(total3, 2).ToString();
totaldr[9] = Math.Round(total4, 2).ToString();
// 加转换煤
totaldr[10] = Math.Round((total1 * decITEMCOAL1 + total2 * decITEMCOAL2 + total3 * decITEMCOAL3 + total4 * decITEMCOAL4), 2).ToString();
dt.Rows.Add(totaldr);
#endregion
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
//return null;
}
}
/// <summary>
/// 导出所有能源信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string ExportAllEnergy(string starttime, string endtime, string objectid, string timeunit, string SavePath)
{
try
{
ReportQueryModelNew model = new ReportQueryModelNew();
model.startime = DateTime.Parse(starttime);
model.endtime = DateTime.Parse(endtime);
model.objectid = objectid;
model.timeunit = (ReportStyleNew)(int.Parse(timeunit));
model.objecttype = 0;
string strPath = SavePath; // AppDomain.CurrentDomain.BaseDirectory + "temp_file\\";
string strTemPath = AppDomain.CurrentDomain.BaseDirectory + "ExcelTemplate\\区域能耗查询.xls";
#region 第2种方法
DataTable dtItemCode = GetItemCode(" and itemcodenumber in ('01000','02000','03000','04000')");
DataTable dtlist = GetItemcodeDataAll(model, dtItemCode);
string name = GetBaseLayerObjectName(model.objectid);
#endregion
if (dtlist != null)
{
string temp_path = strPath; //AppDomain.CurrentDomain.BaseDirectory + "temp_file\\";
if (!Directory.Exists(temp_path))
{
Directory.CreateDirectory(temp_path);
string[] files = Directory.GetFiles(temp_path);
foreach (string fn in files)
{
File.Delete(temp_path + fn);
}
}
string save_path = DateTime.Now.Ticks + ".xls";
string templatePath = strTemPath; // AppDomain.CurrentDomain.BaseDirectory + "template\\区域能耗查询.xls";
string datetime = model.startime.ToString("yyyy-MM-dd") + "~" + (model.timeunit == ReportStyleNew.DayStyle ? model.endtime.ToString("yyyy-MM-dd HH:59:59") : model.endtime.ToString("yyyy-MM-dd"));
TemplateParam param = new TemplateParam(name, new CellParam(0, 0), datetime, new CellParam(3, 0), false, new CellParam(4, 0));
//param.DataColumn = new[] { 0, 3, 6, 7, 8, 9};
param.DataColumn = new[] { 0, 3, 1, 6, 7, 8, 9, 10 };
dtlist.TableName = "能耗查询统计";
string strDownFile = temp_path + save_path;
ExportHelper.ExportExcel(dtlist, strDownFile, strTemPath, param);
return("{\"status\":\"success\",\"msg\":\"" + "/temp_file/" + save_path + "\"}");
}
else
{
return("{\"status\":\"error\",\"msg\":\"导出失败：当前无任何数据\"}");
//return "导出失败：当前无任何数据!";
}
}
catch (Exception ex)
{
return("{\"status\":\"error\",\"msg\":\"导出失败:没有数据\"}");
}
}