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 { /// /// JZData 的摘要说明 /// public class JZData : 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 GetAll(HttpContext context) { string SQL = "SELECT COUNT(TBLX) NUMBER,TBLX,SUM(CONVERT(decimal(9,2), JCMJ)) MJZH from JianZhuYongDiInfo GROUP BY TBLX"; GetTableCommon gt = new GetTableCommon(); DataTable dt = gt.GetTable(SQL); string jsonStr = DataTableToJson.DtToJson(dt); context.Response.Write(jsonStr); } //获取二级也就是县级类型和数量 public void GetCounty(HttpContext context) { var xm = context.Request["XMC"]; string SQL = string.Format(@"SELECT COUNT(TBLX) NUMBER,TBLX,SUM(CONVERT(decimal(9,2), JCMJ)) MJZH from JianZhuYongDiInfo WHERE XMC='{0}' GROUP BY TBLX",xm); GetTableCommon gt = new GetTableCommon(); DataTable dt = gt.GetTable(SQL); string jsonStr = DataTableToJson.DtToJson(dt); context.Response.Write(jsonStr); } //获取最低一级站点的类型和数量 public void GetStation(HttpContext context) { var staName = context.Request["XMC"]; string SQL = string.Format(@"SELECT COUNT(TBLX) NUMBER,TBLX,SUM(CONVERT(decimal(9,2), JCMJ)) MJZH from JianZhuYongDiInfo WHERE TCBH='{0}' GROUP BY TBLX", staName); GetTableCommon gt = new GetTableCommon(); DataTable dt = gt.GetTable(SQL); string jsonStr = DataTableToJson.DtToJson(dt); context.Response.Write(jsonStr); } //获取所有的Feature数据 public void GetAllFeatures(HttpContext context) { string arg = context.Request["staname"]; string text = string.Format("SELECT JCBH,JCMJ,TBLX from JianZhuYongDiInfo WHERE TCBH='{0}'", arg); string s = DataTableToJson.DtToJson(new GetTableCommon().GetTable(text)); context.Response.Write(s); } public bool IsReusable { get { return false; } } } }