WEBform地图描点之XGJBCo.ashx部分
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using CDHB.Common.FileHelper;
using CDHB.Common.Config;
using CDHB.Library;
using CDHB.Common.PageHelper;
namespace PMIS.UI.AjaxHandler
{
/// <summary>
/// XGJBCo 的摘要说明
/// </summary>
public class XGJBCo : IHttpHandler
{
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string PKID = HttpContext.Current.Server.UrlDecode(PageHelper.SafeRequest("PKID"));
if (PageHelper.SafeRequest("t") == "X")
{
string XGT = HttpContext.Current.Server.UrlDecode(PageHelper.SafeRequest("XGT"));
context.Response.Write(XGTRef(PKID, XGT));
}
else if (PageHelper.SafeRequest("t") == "XS")
{
string XGT = HttpContext.Current.Server.UrlDecode(PageHelper.SafeRequest("XGT"));
context.Response.Write(XGTSBRef(PKID, XGT));
}
else if(PageHelper.SafeRequest("t") == "D")
{
string Lng = HttpContext.Current.Server.UrlDecode(PageHelper.SafeRequest("Lng"));
string Lat = HttpContext.Current.Server.UrlDecode(PageHelper.SafeRequest("Lat"));
string list = HttpContext.Current.Server.UrlDecode(PageHelper.SafeRequest("list"));
string lx = HttpContext.Current.Server.UrlDecode(PageHelper.SafeRequest("lx"));
context.Response.Write(ZBRef(PKID, Lat, Lng, list,lx));
}
else if(PageHelper.SafeRequest("t") == "D_CB")
{
string Lng = HttpContext.Current.Server.UrlDecode(PageHelper.SafeRequest("Lng"));
string Lat = HttpContext.Current.Server.UrlDecode(PageHelper.SafeRequest("Lat"));
string list = HttpContext.Current.Server.UrlDecode(PageHelper.SafeRequest("list"));
string lx = HttpContext.Current.Server.UrlDecode(PageHelper.SafeRequest("lx"));
context.Response.Write(ZBRef_CB(PKID, Lat, Lng, list, lx));
}
else if (PageHelper.SafeRequest("t") == "DS")
{
string Lng = HttpContext.Current.Server.UrlDecode(PageHelper.SafeRequest("Lng"));
string Lat = HttpContext.Current.Server.UrlDecode(PageHelper.SafeRequest("Lat"));
context.Response.Write(ZBSBRef(PKID, Lat, Lng));
}
}
public bool IsReusable
{
get
{
return false;
}
}
/// <summary>
/// 修改效果图路径
/// </summary>
/// <param name="xmid"></param>
/// <param name="xgt"></param>
/// <returns></returns>
public string XGTRef(string xmid,string xgt)
{
string sql = "UPDATE dbo.table SET XGT = '" + xgt + "' WHERE ID = '" + xmid + "'";
int re = LDDBhelper.ExecuteSqlNoLog(sql);
if (re > 0)
{
return "true";
}
else
{
return "false";
}
}
/// <summary>
/// 修改效果图路径
/// </summary>
/// <param name="xmid"></param>
/// <param name="xgt"></param>
/// <returns></returns>
public string XGTSBRef(string xmid, string xgt)
{
string sql = "UPDATE dbo.table SET XGT = '" + xgt + "' WHERE ID = '" + xmid + "'";
int re = LDDBhelper.ExecuteSqlNoLog(sql);
if (re > 0)
{
return "true";
}
else
{
return "false";
}
}
/// <summary>
/// 修改坐标点位置
/// </summary>
/// <param name="xmid"></param>
/// <param name="xgt"></param>
/// <returns></returns>
public string ZBRef(string xmid, string lat,string lng,string list,string lx)
{
string sql = "UPDATE dbo.table SET Lat = '" + lat + "',Lng = '" + lng + "',PList='" + list + "',PLX='"+lx+"' WHERE ID = '" + xmid + "'";
int re = LDDBhelper.ExecuteSqlNoLog(sql);
if (re > 0)
{
return "true";
}
else
{
return "false";
}
}
/// <summary>
/// 修改坐标点位置
/// </summary>
/// <param name="xmid"></param>
/// <param name="xgt"></param>
/// <returns></returns>
public string ZBRef_CB(string xmid, string lat, string lng, string list, string lx)
{
string sql = "UPDATE table SET Lat = '" + lat + "',Lng = '" + lng + "',PList='" + list + "',PLX='" + lx + "' WHERE ID = '" + xmid + "'";
int re = LDDBhelper.ExecuteSqlNoLog(sql);
if (re > 0)
{
return "true";
}
else
{
return "false";
}
}
/// <summary>
/// 修改坐标点位置
/// </summary>
/// <param name="xmid"></param>
/// <param name="xgt"></param>
/// <returns></returns>
public string ZBSBRef(string xmid, string lat, string lng)
{
string sql = "UPDATE table SET Lat = '" + lat + "',Lng = '" + lng + "' WHERE ID = '" + xmid + "'";
int re = LDDBhelper.ExecuteSqlNoLog(sql);
if (re > 0)
{
return "true";
}
else
{
return "false";
}
}
}
}