You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
103 lines
3.3 KiB
103 lines
3.3 KiB
using System;
|
|
using System.Collections.Generic;
|
|
using System.Data;
|
|
using System.Linq;
|
|
using System.Web;
|
|
|
|
namespace FangYar.WebUI.ashx
|
|
{
|
|
/// <summary>
|
|
/// ZYFireResource 的摘要说明
|
|
/// </summary>
|
|
public class ZYFireResource : IHttpHandler
|
|
{
|
|
#region 变量
|
|
FangYar.BLL.FIRE.FIRERESOURCE bll = new BLL.FIRE.FIRERESOURCE();
|
|
#endregion
|
|
|
|
public void ProcessRequest(HttpContext context)
|
|
{
|
|
context.Response.ContentType = "text/plain";
|
|
|
|
string action = context.Request.Params["Action"];
|
|
string returnstr = "";
|
|
|
|
switch (action)
|
|
{
|
|
case "GetWaterResource":
|
|
returnstr = GetWaterResource(context);
|
|
break;
|
|
case "GetWaterResourceSingle":
|
|
returnstr = GetWaterResourceSingle(context);
|
|
break;
|
|
}
|
|
|
|
context.Response.Write(returnstr);
|
|
}
|
|
//获取消防资源
|
|
private string GetWaterResource(HttpContext context)
|
|
{
|
|
string strReturn = string.Empty;
|
|
try
|
|
{
|
|
|
|
string OrgId = context.Request.Params["OrgId"];
|
|
|
|
string sql = " select ID,TYPE,LON,LAT,ORG_ID,NAME,ADDR,IFNULL(COORDINATE_TYPE,'0') COORDINATE_TYPE FROM FIRE_RESOURCES where ";
|
|
|
|
sql += " 1=1 and org_id in (select o.org_id from fire_org o ,(select get_Org_child_list('" + OrgId + "') cids ) s where find_in_set(org_id,cids) )";
|
|
|
|
DataTable dt = FangYar.Common.MySqlHelper.QueryTable(sql);
|
|
|
|
if (dt != null)
|
|
{
|
|
strReturn += FangYar.Common.JsonHelper.ToJson(dt);
|
|
}
|
|
}
|
|
catch (Exception e)
|
|
{
|
|
// 记录操作日志
|
|
BLL.SysOperationLogHelp.AddSysOperationLog(context, Common.EnumOperationLogType.Error, "获取消防资源操作请求", "获取消防资源异常：" + e);
|
|
}
|
|
|
|
return strReturn;
|
|
}
|
|
//获取消防资源-单个
|
|
private string GetWaterResourceSingle(HttpContext context)
|
|
{
|
|
string strReturn = string.Empty;
|
|
try
|
|
{
|
|
|
|
string ID = context.Request.Params["ID"];
|
|
|
|
string sql = " select ID,NUM,NAME,TYPE,ADDR,LON,LAT,GPS,ORG_ID,STA_ID,DVC_SN,I_FORM,I_HEIGHT,HYD_TYPE,M_PRE,M_DIA,FLOW_SIZE,CAPACITY,AREA,IFNULL(COORDINATE_TYPE,'0') COORDINATE_TYPE,SUB_ROAD,PLA_FORM,INT_FORM,I_FORM,SUB_M,M_FORM,SUP_UNIT,FOUND_DATE,I_RECORD FROM FIRE_RESOURCES where ";
|
|
|
|
sql += " ID = '" + ID + "'";
|
|
|
|
DataTable dt = FangYar.Common.MySqlHelper.QueryTable(sql);
|
|
|
|
if (dt != null)
|
|
{
|
|
strReturn += FangYar.Common.JsonHelper.ToJson(dt);
|
|
}
|
|
}
|
|
catch (Exception e)
|
|
{
|
|
// 记录操作日志
|
|
BLL.SysOperationLogHelp.AddSysOperationLog(context, Common.EnumOperationLogType.Error, "获取消防资源操作请求", "获取消防资源异常：" + e);
|
|
}
|
|
|
|
return strReturn;
|
|
}
|
|
|
|
|
|
public bool IsReusable
|
|
{
|
|
get
|
|
{
|
|
return false;
|
|
}
|
|
}
|
|
}
|
|
}
|