获取/获取数据,是查询数据源的剑道下拉列表,并使用它在谷歌地图
Getting/Fetching Datas that is Queried on Datasource of Kendo DropdownList and use it on Google Maps
我可以问什么是获取值的方式在数据源查询和使用它,因为在我的Json结果有列的纬度和经度,我想用它来使地图中心的位置
下拉菜单的变化这是我的位置下拉列表
$("#ddlLocation").kendoDropDownList({
dataTextField: "Address",
dataValueField: "Client_CustomerID",
autoBind: false,
optionLabel: "-- Please Select Position --",
template: '<h5>${ data.Address }</h5>',
dataSource: {
transport: {
read: {
url: '/Dashboard/LoadCompanyDropdownList?userId=' + userId,
dataType: "json",
type: "POST"
}
}
}
});
$("#LocationInputs").kendoDropDownList({
dataTextField: "Address",
dataValueField: "Client_CustomerID",
// index: 0,
autoBind: false,
change: function () {
var value = this.value();
if (value) {
**This is where i want to use the fetched Latitude and Longitude**
}
else {
$("#PositionGrid").data("kendoGrid").dataSource.filter({});
}
},
cascadeFrom: "PositionInputs",
optionLabel: "-- Please Select Position --",
template: '<h5>${ data.Address }</h5>',
dataSource: {
transport: {
read: {
url: '/Dashboard/LoadCompanyDropdownList?userId=' + userId,
dataType: "json",
type: "POST"
}
}
}
});
这是LoadCompanyDropdownList
public JsonResult LoadCustomerList()
{
// check if search string has value
// retrieve list of workers filtered by search criteria
var list = (from a in db.Client_Customer_Location
join b in db.Client_Customer
on a.Client_CustomerID equals b.ID
where a.LogicalDelete == false
&& b.LogicalDelete == false
&& a.Longitude != null
&& a.Longitude != 0
select new
{
b.ID,
a.Client_CustomerID,
a.Address_Line1,
a.Address_Line2,
a.City,
a.STATE_LookID,
a.ZipCode,
a.Latitude,
a.Longitude,
a.LogicalDelete,
}).ToList();
List<CustomerInfo> clist = new List<CustomerInfo>();
foreach (var row in list)
{
CustomerInfo ci = new CustomerInfo
{
ID = row.ID,
Client_CustomerID = row.Client_CustomerID,
ClientID = row.ClientID,
AddressLine1 = row.Address_Line1 + " " + row.Address_Line2 + " " + row.City + " " + GetLookupDisplayValById(row.STATE_LookID),
Latitude = Math.Round(Convert.ToDecimal(row.Latitude), 8),
Longitude = Math.Round(Convert.ToDecimal(row.Longitude), 8),
LogicalDelete = row.LogicalDelete
};
clist.Add(ci);
}
return Json(clist.ToList().OrderBy(p => p.AddressLine1), JsonRequestBehavior.AllowGet);
}
你可以试试:
change: function () {
var dataItem = this.dataItem(this.select());
var lat = dataItem.Latitude;
var long = dataItem.Longitude;
var value = this.value();
if (value) {
........
}
相关文章:
- 在谷歌地图上获取事件的x,y坐标
- 如何获取谷歌地图多边形的当前fillColor
- 如何用javascript获取谷歌地图的经度和纬度
- 从AngularJs获取谷歌地图对象的正确方法是什么
- 如何在javascript谷歌地图中获取数据库值
- 谷歌地图:获取点击或标记(x,y)像素坐标内的标记点击侦听器
- 谷歌地图API-获取信息窗口打开时,点击一个圆圈
- 从用户那里获取谷歌地图坐标
- 从外部网站获取谷歌地图数据
- 获取谷歌地图搜索结果的大小/面积
- 使用按钮获取谷歌地图上的json数据和过滤标记
- 获取谷歌地图中已创建标记的位置(纬度,lng)
- 获取谷歌地图链接
- 我需要帮助获取谷歌地图上多个信息窗口的信息!!标记出现,但没有信息
- 获取谷歌地图的gps坐标
- 获取谷歌地图标记的方向
- Open Layers 3获取谷歌地图基线层
- 获取谷歌地图上一组标记的东北角和西南角
- 使用Place获取谷歌地图的地点id
- 从Chrome扩展中获取谷歌地图对象