public static IDictionary <string, decimal> GetData(string id, string startTime, string endTime, int timeSpan)
        {
            string[] myArray = id.Split('>');

            /*
             * //标准电量ID为:OrganizationID>VariableId>ElectricityQuantity
             * //标准功率ID为:OrganizationID>VariableId>Power
             * //标准煤耗ID为:OrganizationID>VariableId>CoalConsumption
             * //标准电耗ID为:OrganizationID>VariableId>ElectricityConsumption
             * //标准产量ID为:OrganizationID>VariableId>Material
             */

            //找出属于本班(class)、本日(day)、本月(month)中除去产量的标签,并修改传入ID为标准ID
            if (myArray[2] != "ElectricityQuantity" && myArray[2] != "Power" && myArray[2] != "CoalConsumption" && myArray[2] != "ElectricityConsumption")//后缀不为电量、功率、煤耗、电耗的标签
            {
                //标签中部为电量、功率、煤耗、电耗的标签
                if (myArray[1].Split('_')[1] == "ElectricityQuantity" || myArray[1].Split('_')[1] == "Power" || myArray[1].Split('_')[1] == "CoalConsumption" || myArray[1].Split('_')[1] == "ElectricityConsumption")
                {
                    id = myArray[0] + ">" + myArray[1].Split('_')[0] + ">" + myArray[1].Split('_')[1];
                }
            }

            //找出本班(class)、本日(day)、本月(month)中属于产量的标签,并修改传入ID为标准ID
            if (myArray[2] != "ElectricityQuantity" && myArray[2] != "Power" && myArray[2] != "CoalConsumption" && myArray[2] != "ElectricityConsumption")
            {
                //标签中部不为电量、功率、煤耗、电耗的标签即为产量标签
                if (myArray[1].Split('_')[1] != "ElectricityQuantity" && myArray[1].Split('_')[1] != "Power" && myArray[1].Split('_')[1] != "CoalConsumption" && myArray[1].Split('_')[1] != "ElectricityConsumption")
                {
                    id = myArray[0] + ">" + myArray[1] + ">" + "Material";
                }
            }
            return(TrendLineService.GetData(id, DateTime.Parse(startTime), DateTime.Parse(endTime), timeSpan));
        }
Beispiel #2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            ///以下是接收js脚本中post过来的参数
            string m_FunctionName = Request.Form["myFunctionName"] == null ? "" : Request.Form["myFunctionName"].ToString();             //方法名称,调用后台不同的方法
            string m_Parameter1   = Request.Form["myParameter1"] == null ? "" : Request.Form["myParameter1"].ToString();                 //方法的参数名称1

            //方法的参数名称2
            if (m_FunctionName == "ExcelStream")
            {
                //ExportFile("xls", "导出报表1.xls");
                string m_ExportTable = m_Parameter1.Replace("&lt;", "<");
                m_ExportTable = m_ExportTable.Replace("&gt;", ">");
                //m_ExportTable = m_ExportTable.Replace("&nbsp", "  ");
                TrendLineService.ExportExcelFile("xls", "历史数据报表.xls", m_ExportTable);
            }
        }
Beispiel #3
0
        public static string GetTrendName(string id)
        {
            string m_Id = GetTrendDataId(id);

            return(TrendLineService.GetTrendName(m_Id));
        }
Beispiel #4
0
        public static IDictionary <string, decimal> GetData(string id, string startTime, string endTime, int timeSpan)
        {
            string m_Id = GetTrendDataId(id);

            return(TrendLineService.GetData(m_Id, DateTime.Parse(startTime), DateTime.Parse(endTime), timeSpan));
        }