/// <summary>
/// 绑定数据
/// </summary>
/// <param name="x"></param>
/// <param name="y"></param>
protected void BindData(float x, float y, int wid)
{
BLL.wx_lbs_setting setBll = new BLL.wx_lbs_setting();
Model.wx_lbs_setting setting = setBll.GetSettingByWid(wid);
bannerPic.ImageUrl = setting.bannerPicUrl;
BLL.wx_lbs_shopInfo sBll = new BLL.wx_lbs_shopInfo();
//SELECT * FROM wx_lbs_shopInfo WHERE dbo.[ufn_GetMapDistance](121.4624,31.220933,yPoint, xPoint) < 5
IList <Model.wx_lbs_shopInfo> shopList = sBll.GetDetailList(wid, "dbo.[ufn_GetMapDistance](" + y + "," + x + ",yPoint, xPoint) < " + setting.searchRadius);
StringBuilder rpLocationStr = new StringBuilder("");
if (shopList != null && shopList.Count > 0)
{
string juli = "0";
for (int i = 0; i < shopList.Count; i++)
{
juli = (sBll.getMapDistance((double)y, (double)x, (double)(shopList[i].yPoint.Value), (double)(shopList[i].xPoint.Value))).ToString("F1");
rpLocationStr.Append("<li>");
string dUrl = DetailUrl(wid, shopList[i].id, x, y, shopList[i].wUrl);
rpLocationStr.Append("<a href=\"" + dUrl + "\" rel=\"external\" data-ajax=\"false\">");
rpLocationStr.Append(" <h2><img src=\"images/1.gif\" /><span onclick='" + shopList[i].telphone + "'>" + shopList[i].telphone + "</span></h2>");
rpLocationStr.Append("<p>地址：" + shopList[i].detailAddr + " 距离：约" + juli + "公里 </p>");
rpLocationStr.Append("<p> 简介：" + shopList[i].brief + "</p>");
rpLocationStr.Append("</li>");
}
txtrpLocationStr.Text = rpLocationStr.ToString();
litshopNum.Text = shopList.Count.ToString();
}
else
{
txtrpLocationStr.Text = "暂无数据";
}
}
/// <summary>
/// 绑定数据
/// </summary>
/// <param name="x"></param>
/// <param name="y"></param>
protected void BindData(float x, float y,int wid)
{
BLL.wx_lbs_setting setBll = new BLL.wx_lbs_setting();
Model.wx_lbs_setting setting = setBll.GetSettingByWid(wid);
bannerPic.ImageUrl = setting.bannerPicUrl;
BLL.wx_lbs_shopInfo sBll = new BLL.wx_lbs_shopInfo();
//SELECT * FROM wx_lbs_shopInfo WHERE dbo.[ufn_GetMapDistance](121.4624,31.220933,yPoint, xPoint) < 5
IList<Model.wx_lbs_shopInfo> shopList = sBll.GetDetailList(wid,"dbo.[ufn_GetMapDistance](" + y + "," + x + ",yPoint, xPoint) < " + setting.searchRadius);
StringBuilder rpLocationStr =new StringBuilder("");
if (shopList != null && shopList.Count > 0)
{
string juli = "0";
for (int i = 0; i < shopList.Count; i++)
{
juli = (sBll.getMapDistance((double)y, (double)x, (double)(shopList[i].yPoint.Value), (double)(shopList[i].xPoint.Value))).ToString("F1");
rpLocationStr.Append("<li>");
string dUrl = DetailUrl(wid, shopList[i].id, x, y, shopList[i].wUrl);
rpLocationStr.Append("<a href=\"" + dUrl + "\" rel=\"external\" data-ajax=\"false\">");
rpLocationStr.Append(" <h2><img src=\"images/1.gif\" /><span onclick='" + shopList[i].telphone + "'>" + shopList[i].telphone+ "</span></h2>");
rpLocationStr.Append("<p>地址：" + shopList[i].detailAddr + " 距离：约" + juli + "公里 </p>");
rpLocationStr.Append("<p> 简介：" + shopList[i].brief + "</p>");
rpLocationStr.Append("</li>");
}
txtrpLocationStr.Text = rpLocationStr.ToString();
litshopNum.Text = shopList.Count.ToString();
}
else {
txtrpLocationStr.Text = "暂无数据";
}
}
public IResponseMessageBase GetResponseMessage(RequestMessageLocation requestMessage)
{
#region 注释掉的
//var responseMessage = ResponseMessageBase.CreateFromRequestMessage<ResponseMessageNews>(requestMessage);
//var markersList = new List<Markers>();
//markersList.Add(new Markers()
//{
// X = requestMessage.Location_X,
// Y = requestMessage.Location_Y,
// Color = "red",
// Label = "S",
// Size = MarkerSize.Default,
//});
//var mapSize = "480x600";
//var mapUrl = GoogleMapHelper.GetGoogleStaticMap(19 /*requestMessage.Scale*//*微信和GoogleMap的Scale不一致，这里建议使用固定值*/,
// markersList, mapSize);
//responseMessage.Articles.Add(new Article()
//{
// Description = string.Format("您刚才发送了地理位置信息。Location_X：{0}，Location_Y：{1}，Scale：{2}，标签：{3}",
// requestMessage.Location_X, requestMessage.Location_Y,
// requestMessage.Scale, requestMessage.Label),
// PicUrl = mapUrl,
// Title = "定位地点周边地图",
// Url = mapUrl
//});
//responseMessage.Articles.Add(new Article()
//{
// Title = "微信公众平台SDK 官网链接",
// Description = "Senparc.Weixin.MK SDK地址",
// PicUrl = "http://weixin.senparc.com/images/logo1.jpg",
// Url = "http://www.yubom.net"
//});
//return responseMessage;
#endregion
WeiXCommFun wxcomm = new WeiXCommFun();
string yuming = MyCommFun.getWebSite();
int apiid = wxcomm.getApiid();
//1 查询店面，如果查询到店面，则返回图文列表信息，如果未查询到，则返回纯文本“找不到你查询的内容”
BLL.wx_lbs_setting setBll = new BLL.wx_lbs_setting();
Model.wx_lbs_setting setting = setBll.GetSettingByWid(apiid);
BLL.wx_lbs_shopInfo sBll = new BLL.wx_lbs_shopInfo();
//SELECT * FROM wx_lbs_shopInfo WHERE dbo.[ufn_GetMapDistance](121.4624,31.220933,yPoint, xPoint) < 5
IList<Model.wx_lbs_shopInfo> shopList = sBll.GetDetailList(apiid,"dbo.[ufn_GetMapDistance](" + requestMessage.Location_Y + "," + requestMessage.Location_X + ",yPoint, xPoint) < " + setting.searchRadius);
if (shopList == null || shopList.Count <= 0)
{ //未查询到
var responseTextMessage = ResponseMessageBase.CreateFromRequestMessage<ResponseMessageText>(requestMessage);
responseTextMessage.Content = "找不到你查询的内容";
return responseTextMessage;
}
else
{ //查询到了数据
var responseMessage = ResponseMessageBase.CreateFromRequestMessage<ResponseMessageNews>(requestMessage);
////第一条信息
//responseMessage.Articles.Add(new Article()
//{
// Description = string.Format("您刚才发送了地理位置信息。Location_X：{0}，Location_Y：{1}，Scale：{2}，标签：{3}",
// requestMessage.Location_X, requestMessage.Location_Y,
// requestMessage.Scale, requestMessage.Label),
// PicUrl = yuming + "/lbsInfo/images/ditu.jpg",
// Title = "周边门店信息",
// Url = yuming + "/weixin/lbs/index.aspx?x=" + requestMessage.Location_X + "&y=" + requestMessage.Location_Y + "&wid=" + apiid + "&openid=" + requestMessage.FromUserName
//});
//中间n条信息 ，图文消息个数，限制为10条以内，所以中间控制最多8条信息
for (int i = 0; i < shopList.Count; i++)
{
if (i == 8)
{
break;
}
Model.wx_lbs_shopInfo shop = shopList[i];
string pUrl = "";
if (shop.shopLogo == null || shop.shopLogo.Trim() == "")
{
// pUrl = yuming + "/lbsinfo/images/logo.jpg";
}
else
{
pUrl = yuming + shop.shopLogo;
}
responseMessage.Articles.Add(new Article()
{
Title = shop.shopName + "\n 地址：" + shop.detailAddr + "\n电话：" + shop.telphone,
Description = shop.shopName + "分店信息",
PicUrl = pUrl,
Url = yuming + "/weixin/lbs/detailAddr.aspx?shopid=" + shop.id + "&x=" + requestMessage.Location_X + "&y=" + requestMessage.Location_Y + "&wid=" + apiid + "&openid=" + requestMessage.FromUserName
});
}
//最后一条信息
responseMessage.Articles.Add(new Article()
{
Title = "更多门店>>",
Url = yuming + "/weixin/lbs/index.aspx?x=" + requestMessage.Location_X + "&y=" + requestMessage.Location_Y + "&wid=" + apiid + "&openid=" + requestMessage.FromUserName
});
return responseMessage;
}
}
public IResponseMessageBase GetResponseMessage(RequestMessageLocation requestMessage)
{
#region 注释掉的
//var responseMessage = ResponseMessageBase.CreateFromRequestMessage<ResponseMessageNews>(requestMessage);
//var markersList = new List<Markers>();
//markersList.Add(new Markers()
//{
// X = requestMessage.Location_X,
// Y = requestMessage.Location_Y,
// Color = "red",
// Label = "S",
// Size = MarkerSize.Default,
//});
//var mapSize = "480x600";
//var mapUrl = GoogleMapHelper.GetGoogleStaticMap(19 /*requestMessage.Scale*//*微信和GoogleMap的Scale不一致，这里建议使用固定值*/,
// markersList, mapSize);
//responseMessage.Articles.Add(new Article()
//{
// Description = string.Format("您刚才发送了地理位置信息。Location_X：{0}，Location_Y：{1}，Scale：{2}，标签：{3}",
// requestMessage.Location_X, requestMessage.Location_Y,
// requestMessage.Scale, requestMessage.Label),
// PicUrl = mapUrl,
// Title = "定位地点周边地图",
// Url = mapUrl
//});
//responseMessage.Articles.Add(new Article()
//{
// Title = "微信公众平台SDK 官网链接",
// Description = "Senparc.Weixin.MK SDK地址",
// PicUrl = "http://weixin.senparc.com/images/logo1.jpg",
// Url = "http://www.yubom.net"
//});
//return responseMessage;
#endregion
WeiXCommFun wxcomm = new WeiXCommFun();
string yuming = MyCommFun.getWebSite();
int apiid = 38;// wxcomm.getApiid()该了
//1 查询店面，如果查询到店面，则返回图文列表信息，如果未查询到，则返回纯文本“找不到你查询的内容”
BLL.wx_lbs_setting setBll = new BLL.wx_lbs_setting();
Model.wx_lbs_setting setting = setBll.GetSettingByWid(apiid);
BLL.wx_lbs_shopInfo sBll = new BLL.wx_lbs_shopInfo();
//SELECT * FROM wx_lbs_shopInfo WHERE dbo.[ufn_GetMapDistance](121.4624,31.220933,yPoint, xPoint) < 5
IList <Model.wx_lbs_shopInfo> shopList = sBll.GetDetailList(apiid, "dbo.[ufn_GetMapDistance](" + requestMessage.Location_Y + "," + requestMessage.Location_X + ",yPoint, xPoint) < " + setting.searchRadius);
if (shopList == null || shopList.Count <= 0)
{ //未查询到
var responseTextMessage = ResponseMessageBase.CreateFromRequestMessage <ResponseMessageText>(requestMessage);
responseTextMessage.Content = "找不到你查询的内容";
return(responseTextMessage);
}
else
{ //查询到了数据
var responseMessage = ResponseMessageBase.CreateFromRequestMessage <ResponseMessageNews>(requestMessage);
////第一条信息
//responseMessage.Articles.Add(new Article()
//{
// Description = string.Format("您刚才发送了地理位置信息。Location_X：{0}，Location_Y：{1}，Scale：{2}，标签：{3}",
// requestMessage.Location_X, requestMessage.Location_Y,
// requestMessage.Scale, requestMessage.Label),
// PicUrl = yuming + "/lbsInfo/images/ditu.jpg",
// Title = "周边门店信息",
// Url = yuming + "/weixin/lbs/index.aspx?x=" + requestMessage.Location_X + "&y=" + requestMessage.Location_Y + "&wid=" + apiid + "&openid=" + requestMessage.FromUserName
//});
//中间n条信息 ，图文消息个数，限制为10条以内，所以中间控制最多8条信息
for (int i = 0; i < shopList.Count; i++)
{
if (i == 8)
{
break;
}
Model.wx_lbs_shopInfo shop = shopList[i];
string pUrl = "";
if (shop.shopLogo == null || shop.shopLogo.Trim() == "")
{
// pUrl = yuming + "/lbsinfo/images/logo.jpg";
}
else
{
pUrl = yuming + shop.shopLogo;
}
responseMessage.Articles.Add(new Article()
{
Title = shop.shopName + "\n 地址：" + shop.detailAddr + "\n电话：" + shop.telphone,
Description = shop.shopName + "分店信息",
PicUrl = pUrl,
Url = yuming + "/weixin/lbs/detailAddr.aspx?shopid=" + shop.id + "&x=" + requestMessage.Location_X + "&y=" + requestMessage.Location_Y + "&wid=" + apiid + "&openid=" + requestMessage.FromUserName
});
}
//最后一条信息
responseMessage.Articles.Add(new Article()
{
Title = "更多门店>>",
Url = yuming + "/weixin/lbs/index.aspx?x=" + requestMessage.Location_X + "&y=" + requestMessage.Location_Y + "&wid=" + apiid + "&openid=" + requestMessage.FromUserName
});
return(responseMessage);
}
}