初始化

13693261870

2024-04-02 2a1b873b4b78b508d5d53c57992e734c56619df8

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
using Newtonsoft.Json.Linq;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Reflection;
using System.Web;
using Terra.YaoGan.Common;
using Terra.YaoGan.Service;
 
namespace Terra.YaoGan.Web.Ashx
{
    /// <summary>
    /// Firstcommon 的摘要说明
    /// </summary>
    public class Firstcommon : IHttpHandler
    {
 
        public void ProcessRequest(HttpContext context)
        {
            string Action = context.Request["Action"];
 
            MethodInfo mif = this.GetType().GetMethod(Action);
            if (mif != null)
            {
                mif.Invoke(this, new object[] { context });
            }
 
        }
 
        //获取数据
        public void GetAllSumData(HttpContext context)
        {
            try
            {
                string tableName = context.Request["tableName"];
                string sql = string.Format(@"select  SUM(CAST(area as FLOAT))  Area,[Year]  from  {0} GROUP BY [Year] ;", tableName);
                GetTableCommon gt = new GetTableCommon();
                DataTable dt = gt.GetTable(sql);
                string jsonStr = DataTableToJson.DtToJson(dt);
                context.Response.Write(jsonStr);
            }
            catch
            {
                context.Response.Write("");
            }
            
        }
 
        //获取选择的数据
        public void GetAllChooseData(HttpContext context)
        {
            try
            {
                string where = context.Request["pathName"];
                string TableName = context.Request["tableName"];
                //转化json对象
                JArray jo = JArray.Parse(where);
 
                string sql = "";
                for (int i = 0; i < jo.Count; i++)
                {
                    if (i == 0)
                    {
                        sql += string.Format(@"(select  SUM(CAST(area as FLOAT))  Area,[Year] from {0} where [Year]='{1}' GROUP BY [Year]
                         union all
                        select '0' as Area, '{1}' as [Year] where not exists(select  SUM(CAST(area as FLOAT))  Area,[Year] from {0} where [Year]='{1}' 
                        GROUP BY [Year]))", TableName, jo[i]);
                    }
                    else
                    {
                        sql += string.Format(@" union all (select  SUM(CAST(area as FLOAT))  Area,[Year] from {0} where [Year]='{1}' GROUP BY [Year]
                         union all
                        select '0' as Area, '{1}' as [Year] where not exists(select  SUM(CAST(area as FLOAT))  Area,[Year] from {0} where [Year]='{1}' 
                        GROUP BY [Year]))", TableName, jo[i]);
                    }
                }
                sql = sql + "order by [Year]";
                GetTableCommon gt = new GetTableCommon();
                DataTable dt = gt.GetTable(sql);
                string jsonStr = DataTableToJson.DtToJson(dt);
                context.Response.Write(jsonStr);
            }
            catch
            {
                context.Response.Write("");
            }
            
        }
 
        public bool IsReusable
        {
            get
            {
                return false;
            }
        }
    }
}