private void GetData()
{
string strWhere = "1=1";
string year = Request["year"];
//拼写条件语句(注：条件中的列名要与点位上的列名一致)
if (year != "")
{
strWhere += " and YEAR='" + year + "'";
}
//填报表需要显示信息(注：这Table里面的第一列数据要与填报表的列名一致)
DataTable dtShow = new DataTable();
dtShow = new TEnvFillNoiseRoadLogic().CreateShowDT();
CommonLogic com = new CommonLogic();
DataTable dt = com.GetFillData(strWhere,
dtShow,
TEnvFillNoiseRoadSummaryVo.T_ENV_FILL_NOISE_ROAD_SUMMARY_TABLE,
TEnvPNoiseRoadVo.T_ENV_P_NOISE_ROAD_TABLE,
TEnvPNoiseRoadItemVo.T_ENV_P_NOISE_ROAD_ITEM_TABLE,
TEnvFillNoiseRoadVo.T_ENV_FILL_NOISE_ROAD_TABLE,
TEnvFillNoiseRoadItemVo.T_ENV_FILL_NOISE_ROAD_ITEM_TABLE,
SerialType.T_ENV_FILL_NOISE_ROAD,
SerialType.T_ENV_FILL_NOISE_ROAD_ITEM,
SerialType.T_ENV_FILL_NOISE_ROAD_SUMMARY);
string json = DataTableToJsonUnsureCol(dt);
Response.ContentType = "application/json";
Response.Write(json);
Response.End();
}
//21,交通噪声汇总表
//22,区域噪声汇总表
//23,功能区噪声汇总表
private void PrintLocal_EnvNoise(string strYear, string strMonth, string strPointID, string strSheetType)
{
DataTable dtSrcFill = new DataTable();
DataTable dtSrcResult = new DataTable();
if (strSheetType == "21")
{
dtSrcFill = new TEnvFillNoiseRoadLogic().SelectFill_ForSummary(strYear, strMonth, strPointID);
dtSrcResult = new TEnvFillNoiseRoadLogic().SelectResult_ForSummary(strYear, strMonth, strPointID);
}
else if (strSheetType == "22")
{
dtSrcFill = new TEnvFillNoiseAreaLogic().SelectFill_ForSummary(strYear, strMonth, strPointID);
dtSrcResult = new TEnvFillNoiseAreaLogic().SelectResult_ForSummary(strYear, strMonth, strPointID);
}
else if (strSheetType == "23")
{
dtSrcFill = new TEnvFillNoiseFunctionLogic().SelectFill_ForSummary(strYear, strMonth, strPointID);
dtSrcResult = new TEnvFillNoiseFunctionLogic().SelectResult_ForSummary(strYear, strMonth, strPointID);
}
//标题数组
ArrayList arrTitle = getPrintLocalTitle_EnvNoise(strYear, strMonth, strSheetType);
//结尾数组
ArrayList arrEnd = new ArrayList();
DataTable dtNew = new DataTable();
getPrintLocalColumn_EnvNoise(strSheetType, ref dtNew);
getPrintLocalData_EnvNoise(dtSrcFill, dtSrcResult, strSheetType, ref dtNew);
//项目列名数组
ArrayList arrData = getPrintLocalData(dtNew);
new ExcelHelper().RenderDataTableToExcel(dtNew, "监测数据汇总表.xls", "../../../../TempFile/DataTotal-EnvNoise.xls", "监测数据汇总表", 3, true, arrTitle, arrData, arrEnd);
}