Exemplo n.º 1
0
        private void QueryData()
        {
            string beginTime = Request["beginTime"] == null ? string.Empty : Request["beginTime"].ToString();
            string endTime = string.Empty;
            string timeType = Request["timeType"] == null ? string.Empty : Request["timeType"].ToString();
            string quarterType = Request["quarterType"] == null ? string.Empty : Request["quarterType"].ToString();

            //根据选择的时间段,设置quarterType开始时间和结束时间
            switch (timeType)
            {
                case "1"://月度平均值
                    DateTime dt1 = new DateTime();
                    dt1 = Convert.ToDateTime(beginTime.Substring(0, 7) + "-01");
                    beginTime = dh.GetFirstDayOfMonth(dt1).ToString().Replace("/", "-");
                    endTime = dh.GetLastDayOfMonth(dt1).ToString().Replace("/", "-");
                    break;
                case "2"://季度平均值
                    switch (quarterType)
                    {
                        case "0"://一季度
                            string ti = beginTime.Substring(0, 4) + "-01-01 00:00:00";
                            beginTime = ti;
                            endTime = beginTime.Substring(0, 4) + "-03-31 23:59:59";
                            break;
                        case "1"://二季度
                            string ti1 = beginTime.Substring(0, 4) + "-04-01 00:00:00";
                            beginTime = ti1;
                            endTime = beginTime.Substring(0, 4) + "-06-30 23:59:59";
                            break;
                        case "2"://三季度
                            string ti2 = beginTime.Substring(0, 4) + "-07-01 00:00:00";
                            beginTime = ti2;
                            endTime = beginTime.Substring(0, 4) + "-09-30 23:59:59";
                            break;
                        case "3"://四季度
                            string ti3 = beginTime.Substring(0, 4) + "-10-01 00:00:00";
                            beginTime = ti3;
                            endTime = beginTime.Substring(0, 4) + "-12-31 23:59:59";
                            break;
                    }
                    break;
                case "3"://年度平均值
                    string tim = beginTime.Substring(0, 4);
                    beginTime = tim + "-01-01 00:00:00";
                    endTime = tim + "-12-31 23:59:59";
                    break;
            }

            //先根据paraId,取出所有paraId的outtable,循环outtable,取平均值。
            AllInfo allInfo = new AllInfo();
            ArrayList list = new ArrayList();
            IList<Hashtable> iList = new List<Hashtable>();
            Hashtable ht = null;
            List<ConsumeInfo> infoList;
            infoList = bl.get(beginTime, endTime, out errMsg);

            //记录七月份数据,供分项比例用
            List<ConsumeInfo> tmpList = new List<ConsumeInfo>();
            List<ConsumeInfo> beforInfoList;
            infos tmpZhuTu = new infos();
            double tmpCount = 0.00;
            string beforBeginTime = DateTime.Parse(beginTime).AddMonths(-1).ToString("yyyy-MM-dd HH:mm:ss");
            string beforEndTime = DateTime.Parse(beforBeginTime).AddMonths(1).AddDays(-1).ToString("yyyy-MM-dd HH:mm:ss");
            beforInfoList = bl.get(beforBeginTime, beforEndTime, out errMsg);

            for (int j = 0; j < 4; j++)
            {
                ht = new Hashtable();
                //总耗差
                double allCount = 0;
                //infoList = new List<ConsumeInfo>();
                switch (j)
                {
                    case 0:
                        ht.Add("记录时间", DateTime.Parse(beginTime).Month + "月份耗差平均");
                        tmpList = infoList;
                        allCount = infoList.Select(info => info.Count).Sum();
                        ht.Add("总耗差", Math.Round(allCount,4));
                        //平均值柱状图
                        ArrayList name = new ArrayList();
                        ArrayList value = new ArrayList();

                        foreach (ConsumeInfo tmp in infoList)
                        {
                            ht.Add(tmp.Name, Math.Round(tmp.Count, 3));
                            name.Add(tmp.Name);
                            value.Add(Math.Round(tmp.Count, 3));
                        }
                        tmpZhuTu.name = name;
                        tmpZhuTu.value = value;
                        tmpCount = allCount;
                        //ht.Add("总耗差", allCount);
                        iList.Add(ht);

                        break;
                    case 1:
                        ht.Add("记录时间",  DateTime.Parse(beginTime).Month +"月份分项比列");
                        ht.Add("总耗差", 100.00);
                        if (tmpCount > 0)
                        {
                            foreach (ConsumeInfo tmp in tmpList)
                            {
                                ht.Add(tmp.Name, Math.Round((tmp.Count / tmpCount) * 100, 3));
                            }
                        }
                        else
                        {
                            foreach (ConsumeInfo tmp in tmpList)
                            {
                                ht.Add(tmp.Name, 0);
                            }
                        }
                        iList.Add(ht);

                        break;
                    case 2:

                        ht.Add("记录时间", DateTime.Parse(beforBeginTime).Month + "月份耗差平均");

                        allCount = beforInfoList.Select(info => info.Count).Sum();
                        ht.Add("总耗差", allCount);

                        foreach (ConsumeInfo tmp in beforInfoList)
                        {
                            ht.Add(tmp.Name, Math.Round(tmp.Count, 3));
                            // allCount += tmp.Count;

                        }
                        //ht.Add("总耗差", allCount);

                        iList.Add(ht);

                        break;
                    case 3:
                        ht.Add("记录时间", DateTime.Parse(beginTime).Month + "月份环比" + DateTime.Parse(beforBeginTime).Month + "月份增长");
                        foreach (ConsumeInfo infos in tmpList)
                        {
                            ConsumeInfo c = beforInfoList.Where(t => t.Name == infos.Name).FirstOrDefault();

                            //SsHb.name.Add(c.Name);
                            if (infos.Count > 0)
                            {
                                //SsHb.value.Add(Math.Round(((infos.Count - c.Count) / infos.Count) * 100, 2));
                                ht.Add(c.Name, Math.Round(((infos.Count - c.Count) / infos.Count) * 100, 2));
                            }
                            else
                            {
                                ht.Add(c.Name,0);
                            }
                        }
                        iList.Add(ht);

                        break;
                }
            }

            string str = this.CreateDataGridColumnModel(iList);

            object obj = new
            {
                rows = iList,
                columns = str
            };
            string result = JsonConvert.SerializeObject(obj);
            Response.Write(result);
            Response.End();
        }
Exemplo n.º 2
0
        private void QueryData(string time, string timeType, string quarterType)
        {
            //先根据paraId,取出所有paraId的outtable,循环outtable,取平均值。

            AllInfo allInfo = new AllInfo();

            //info allInfo = new info();

            ArrayList list = new ArrayList();
            IList<Hashtable> iList = new List<Hashtable>();
            //IList<ArrayList> iList = new List<ArrayList>();

            Hashtable ht = null;//BLL.NoSortHashtable ht = null;
            //ArrayList ht = null;
            List<ConsumeInfo> infoList;
            //记录七月份数据,供分项比例用
            List<ConsumeInfo> tmpList=new List<ConsumeInfo> ();
               // List<infos> zhutu=new List<infos> ();
            infos tmpZhuTu = new infos();

            double tmpCount=0.00;

            for (int j = 0; j < 4; j++)
            {
                ht = new Hashtable();
                //总耗差
                double allCount = 0;
                infoList = new List<ConsumeInfo>();
                switch (j)
                {
                    case 0:
                        ht.Add("记录时间", "七月份耗差平均");
                        infoList = bl.get(time, timeType, quarterType, out errMsg);
                        tmpList = infoList;
                        allCount=infoList.Select(info => info.Count).Sum();
                        ht.Add("总耗差", allCount);
                        //平均值柱状图
                         ArrayList name=new ArrayList ();
                            ArrayList value=new ArrayList ();

                        foreach (ConsumeInfo tmp in infoList)
                        {

                            ht.Add(tmp.Name,Math.Round(tmp.Count,3));

                            name.Add(tmp.Name);
                           value.Add(Math.Round(tmp.Count,3));

                            //allCount += tmp.Count;
                        }
                        tmpZhuTu.name=name;
                        tmpZhuTu.value=value;
                        tmpCount = allCount;
                        //ht.Add("总耗差", allCount);
                        iList.Add(ht);

                        break;
                    case 1:
                        ht.Add("记录时间", "七月份分项比列");
                        ht.Add("总耗差", 100.00);
                        foreach (ConsumeInfo tmp in tmpList)
                        {
                            ht.Add(tmp.Name, Math.Round((tmp.Count / tmpCount) * 100,3));

                        }
                        iList.Add(ht);

                        break;
                    case 2:

                        ht.Add("记录时间", "六月份耗差平均");

                        infoList = bl.get(time, timeType, quarterType, out errMsg);
                        allCount=infoList.Select(info => info.Count).Sum();
                        ht.Add("总耗差", allCount);

                        foreach (ConsumeInfo tmp in infoList)
                        {
                            ht.Add(tmp.Name, Math.Round(tmp.Count,3));
                           // allCount += tmp.Count;

                        }
                        //ht.Add("总耗差", allCount);

                        iList.Add(ht);

                        break;
                    case 3:
                        ht.Add("记录时间", "七月份环比六月份增长");

                        iList.Add(ht);

                        break;
                    //}
                    //else
                    //{
                    //    ht.Add(i.ToString(), "test");
                    //}
                    //iList.Add(ht);
                }
            }

            string str = this.CreateDataGridColumnModel(iList);

            object obj = new
            {
                rows = iList,
                columns = str
            };
            //string result = JsonConvert.SerializeObject(obj);
            allInfo.table = str;
            allInfo.ZhuTu = tmpZhuTu;
            string content = allInfo.ToJsonItem();

            Response.Write(content);
            Response.End();
        }
Exemplo n.º 3
0
        private void QueryData()
        {
            string beginTime   = Request["beginTime"] == null ? string.Empty : Request["beginTime"].ToString();
            string endTime     = string.Empty;
            string timeType    = Request["timeType"] == null ? string.Empty : Request["timeType"].ToString();
            string quarterType = Request["quarterType"] == null ? string.Empty : Request["quarterType"].ToString();

            //根据选择的时间段,设置quarterType开始时间和结束时间
            switch (timeType)
            {
            case "1":    //月度平均值
                DateTime dt1 = new DateTime();
                dt1       = Convert.ToDateTime(beginTime.Substring(0, 7) + "-01");
                beginTime = dh.GetFirstDayOfMonth(dt1).ToString().Replace("/", "-");
                endTime   = dh.GetLastDayOfMonth(dt1).ToString().Replace("/", "-");
                break;

            case "2":    //季度平均值
                switch (quarterType)
                {
                case "0":        //一季度
                    string ti = beginTime.Substring(0, 4) + "-01-01 00:00:00";
                    beginTime = ti;
                    endTime   = beginTime.Substring(0, 4) + "-03-31 23:59:59";
                    break;

                case "1":        //二季度
                    string ti1 = beginTime.Substring(0, 4) + "-04-01 00:00:00";
                    beginTime = ti1;
                    endTime   = beginTime.Substring(0, 4) + "-06-30 23:59:59";
                    break;

                case "2":        //三季度
                    string ti2 = beginTime.Substring(0, 4) + "-07-01 00:00:00";
                    beginTime = ti2;
                    endTime   = beginTime.Substring(0, 4) + "-09-30 23:59:59";
                    break;

                case "3":        //四季度
                    string ti3 = beginTime.Substring(0, 4) + "-10-01 00:00:00";
                    beginTime = ti3;
                    endTime   = beginTime.Substring(0, 4) + "-12-31 23:59:59";
                    break;
                }
                break;

            case "3":    //年度平均值
                string tim = beginTime.Substring(0, 4);
                beginTime = tim + "-01-01 00:00:00";
                endTime   = tim + "-12-31 23:59:59";
                break;
            }

            //先根据paraId,取出所有paraId的outtable,循环outtable,取平均值。
            AllInfo            allInfo = new AllInfo();
            ArrayList          list    = new ArrayList();
            IList <Hashtable>  iList   = new List <Hashtable>();
            Hashtable          ht      = null;
            List <ConsumeInfo> infoList;

            infoList = bl.get(beginTime, endTime, out errMsg);

            //记录七月份数据,供分项比例用
            List <ConsumeInfo> tmpList = new List <ConsumeInfo>();
            List <ConsumeInfo> beforInfoList;
            infos  tmpZhuTu       = new infos();
            double tmpCount       = 0.00;
            string beforBeginTime = DateTime.Parse(beginTime).AddMonths(-1).ToString("yyyy-MM-dd HH:mm:ss");
            string beforEndTime   = DateTime.Parse(beforBeginTime).AddMonths(1).AddDays(-1).ToString("yyyy-MM-dd HH:mm:ss");

            beforInfoList = bl.get(beforBeginTime, beforEndTime, out errMsg);

            for (int j = 0; j < 4; j++)
            {
                ht = new Hashtable();
                //总耗差
                double allCount = 0;
                //infoList = new List<ConsumeInfo>();
                switch (j)
                {
                case 0:
                    ht.Add("记录时间", DateTime.Parse(beginTime).Month + "月份耗差平均");
                    tmpList  = infoList;
                    allCount = infoList.Select(info => info.Count).Sum();
                    ht.Add("总耗差", Math.Round(allCount, 4));
                    //平均值柱状图
                    ArrayList name  = new ArrayList();
                    ArrayList value = new ArrayList();

                    foreach (ConsumeInfo tmp in infoList)
                    {
                        ht.Add(tmp.Name, Math.Round(tmp.Count, 3));
                        name.Add(tmp.Name);
                        value.Add(Math.Round(tmp.Count, 3));
                    }
                    tmpZhuTu.name  = name;
                    tmpZhuTu.value = value;
                    tmpCount       = allCount;
                    //ht.Add("总耗差", allCount);
                    iList.Add(ht);

                    break;

                case 1:
                    ht.Add("记录时间", DateTime.Parse(beginTime).Month + "月份分项比列");
                    ht.Add("总耗差", 100.00);
                    if (tmpCount > 0)
                    {
                        foreach (ConsumeInfo tmp in tmpList)
                        {
                            ht.Add(tmp.Name, Math.Round((tmp.Count / tmpCount) * 100, 3));
                        }
                    }
                    else
                    {
                        foreach (ConsumeInfo tmp in tmpList)
                        {
                            ht.Add(tmp.Name, 0);
                        }
                    }
                    iList.Add(ht);

                    break;

                case 2:

                    ht.Add("记录时间", DateTime.Parse(beforBeginTime).Month + "月份耗差平均");

                    allCount = beforInfoList.Select(info => info.Count).Sum();
                    ht.Add("总耗差", allCount);

                    foreach (ConsumeInfo tmp in beforInfoList)
                    {
                        ht.Add(tmp.Name, Math.Round(tmp.Count, 3));
                        // allCount += tmp.Count;
                    }
                    //ht.Add("总耗差", allCount);

                    iList.Add(ht);

                    break;

                case 3:
                    ht.Add("记录时间", DateTime.Parse(beginTime).Month + "月份环比" + DateTime.Parse(beforBeginTime).Month + "月份增长");
                    foreach (ConsumeInfo infos in tmpList)
                    {
                        ConsumeInfo c = beforInfoList.Where(t => t.Name == infos.Name).FirstOrDefault();

                        //SsHb.name.Add(c.Name);
                        if (infos.Count > 0)
                        {
                            //SsHb.value.Add(Math.Round(((infos.Count - c.Count) / infos.Count) * 100, 2));
                            ht.Add(c.Name, Math.Round(((infos.Count - c.Count) / infos.Count) * 100, 2));
                        }
                        else
                        {
                            ht.Add(c.Name, 0);
                        }
                    }
                    iList.Add(ht);

                    break;
                }
            }

            string str = this.CreateDataGridColumnModel(iList);

            object obj = new
            {
                rows    = iList,
                columns = str
            };
            string result = JsonConvert.SerializeObject(obj);

            Response.Write(result);
            Response.End();
        }