這個功能來自一個實際專案:食品安全監管系統(MVC5 + EF6 + Bootstrap3)。需求是從某一批產品出發,看它被賣到了哪些省市、各有幾家單位,並在地圖上標出這些單位的位置。以下是實作過程與幾個關鍵設計決策。
先查產品生產批次資訊,再依批次統計銷售流向。地圖部分需要完成兩件事:依省市聚合單位數量,以及把每個單位的地址轉成座標後標記在地圖上。
從批次列表進入後,可以看到該批產品的詳細資訊。

左側表格列出省市與單位家數,右側地圖顯示對應位置。點擊表格中的某一列,地圖會重新定位到該省市並標記其中所有單位。

畫面採用左右分割:左邊是 DataTables 表格,右邊是地圖容器。工具列提供「返回列表/上一條/下一條」的導覽。
@{
ViewBag.Title = "Index";
Layout = "~/Views/Shared/_TableLayout.cshtml";
}
@*工具欄*@
@section actionBar{
<button class="btn dark btn-outline btn-circle btn-sm" data-bind="click: returnCommand" id="btnCancel">返回列表</button>
<button class="btn dark btn-outline btn-circle btn-sm" data-bind="click: prevCommand" id="btnPrev">上一條</button>
<button class="btn dark btn-outline btn-circle btn-sm" data-bind="click: nextCommand" id="btnNext">下一條</button>
}
@section CustomContent {
<form id="frmObj" name="frmObj" class="form-horizontal form-table-bordered" enctype="multipart/form-data">
<div class="form-body">
<div class="portlet box blue">
<div class="portlet-title">
<div class="caption"><i class="fa fa-gift"></i>產品生產資訊 </div>
<div class="tools"><a href="javascript:;" class="collapse"></a></div>
</div>
<div class="portlet-body">
<input type="hidden" id="Id" name="Id" data-bind="value:viewmodel.Id" />
<input type="hidden" id="OrgId" name="OrgId" data-bind="value:viewmodel.OrgId" />
<input type="hidden" id="ProductId" name="ProductId" data-bind="value:viewmodel.ProductId" />
<div class="form-body">
<div class="form-group">
<label class="col-md-1 control-label">備案單位 <span class="required"> * </span></label>
<div class="col-md-5">
<input type="text" readonly="readonly" class="form-control"
data-bind="value: viewmodel.OrgName" name="OrgName" id="OrgName" />
</div>
<label class="col-md-1 control-label">產品名稱 <span class="required"> * </span></label>
<div class="col-md-5">
<input type="text" readonly="readonly" class="form-control"
data-bind="value: viewmodel.ProductName" name="ProductName" id="ProductName" />
</div>
</div>
<div class="form-group">
<label class="col-md-1 control-label">生產批號 <span class="required"> * </span></label>
<div class="col-md-2">
<input type="text" readonly="readonly" class="form-control"
name="BatchNumber" id="BatchNumber" data-bind="value: viewmodel.BatchNumber" />
</div>
<label class="control-label col-md-1">注冊日期</label>
<div class="col-md-2">
<input type="text" readonly="readonly" class="form-control"
name="RegDate" id="RegDate" data-bind="value: viewmodel.RegDate" />
</div>
<label class="control-label col-md-1">生產日期</label>
<div class="col-md-2">
<input type="text" readonly="readonly" class="form-control"
name="ProductMakeDate" id="ProductMakeDate" data-bind="value: viewmodel.ProductMakeDate" />
</div>
<label class="control-label col-md-1">過期日期</label>
<div class="col-md-2">
<input type="text" readonly="readonly" class="form-control"
name="ProductExpDate" id="ProductExpDate" data-bind="value: viewmodel.ProductExpDate" />
</div>
</div>
</div>
</div>
</div>
<div class="portlet box blue">
<div class="portlet-title">
<div class="caption"><i class="fa fa-gift"></i>銷售地圖 </div>
<div class="tools"><a href="javascript:;" class="collapse"></a></div>
</div>
<div class="portlet-body">
<div class="form-body form-group">
<div class="col-md-5">
<table class="table table-striped table-bordered table-hover dt-responsive" id="myDataGrid">
<thead>
<tr><th>省市</th><th>市區</th><th>單位家數</th></tr>
</thead>
</table>
</div>
<div class="col-md-7">
<div style="height:500px;border:1px solid gray" id="divMap"></div>
</div>
</div>
</div>
</div>
</div>
</form>
}
JavaScript 部分以 Knockout 做資料綁定,地圖操作則集中在幾個方法裡。
@section customScript {
<script src="~/Scripts/page/share/_SecondTableLayout.js"></script>
<script type="text/javascript">
var mDataGrid = function () {
var TableViewModel = SecondTableLayoutViewModel.extend({
constructor: function (ViewModel) {
this.base(ViewModel, undefined);
own.viewmodel = ko.mapping.fromJS(ViewModel);
own.btnAddVisible = false;
own.btnEditVisible = false;
own.btnDelVisible = false;
own.Caption("生產批號 - " + ViewModel.BatchNumber);
own.loadTableData(own.tableOptions, ViewModel.ProductID, ViewModel.Id);
own.ProductId = ViewModel.ProductID;
own.CurrentId = ViewModel.Id;
own.InitMap();
},
viewmodel: null,
ProductId: null,
CurrentId: null,
PrevId: null,
NextId: null,
bMap: null,
tableOptions: {
src: $("#myDataGrid"),
dataTable: {
"ajax": {
"url": "/Basic/ProductBatch/GetBAreaStatistics",
"type": "GET"
},
"columns": [
{ "data": "ProvinceName" },
{ "data": "CityName" },
{ "data": "Amount" }
]
}
},
loadTableData: function (options, ProductId, BatchId) {
if (own.grid != undefined) return;
var table = own.getTable();
table.clearAjaxParams();
table.addAjaxParam("ProductId", ProductId);
table.addAjaxParam("BatchId", BatchId);
var tableSetting = $.extend({}, {
onSuccess: function (grid, response) { own.table_on_success(grid, response); },
onError: function (grid) { own.table_on_error(grid); },
onDataLoad: function (grid) { own.table_on_dataload(grid); },
dataTable: { "bStateSave": true },
rowClick: function (grid, rowData) { own.tableRowClick(grid, rowData); }
}, options);
//記下 loadUrl,自刷新時使用
own.loadUrl = tableSetting.dataTable.ajax.url;
table.init(tableSetting);
},
InitMap: function () {
//建立 Map 實例
bMap = new BMap.Map("divMap");
var point = new BMap.Point(118.060576, 36.842432);
bMap.centerAndZoom("山東省禹城市", 15);
//滑鼠滾動縮放
bMap.enableScrollWheelZoom();
//縮略圖控件
bMap.addControl(new BMap.OverviewMapControl({ isOpen: false, anchor: BMAP_ANCHOR_BOTTOM_RIGHT }));
//縮放平移控件
bMap.addControl(new BMap.NavigationControl());
//比例尺控件
bMap.addControl(new BMap.ScaleControl());
//地圖類型控件(視需要啟用)
//bMap.addControl(new BMap.MapTypeControl());
},
LoadMap: function (cityName, listEnter) {
//重新定位城市
bMap.centerAndZoom(cityName, 12);
for (var i = 0; i < listEnter.length; i++) {
own.LoadMarker(cityName, listEnter[i]);
}
},
LoadMarker: function (cityName, enterinfo) {
//為該城市的單位做標記
var mGeocoder = new BMap.Geocoder();
var mAddress = enterinfo.Address;
//地址為空時,退回用「區域名 + 街道名」組出可查詢的地址
if (enterinfo.Address == "") {
mAddress = enterinfo.AreaName + enterinfo.StreetName;
}
if (mAddress == "") return;
mGeocoder.getPoint(mAddress, function(point){
if (point) {
var mPoint = new BMap.Point(point.lng, point.lat);
var marker = new BMap.Marker(mPoint);
bMap.addOverlay(marker);
marker.setLabel(new BMap.Label(enterinfo.EnterName, { offset: new BMap.Size(20, -10) }));
var content = "<table>";
content += "<tr><td>名稱:" + enterinfo.EnterName + "</td></tr>";
content += "<tr><td>地址:" + mAddress + "</td></tr>";
content += "</table>";
var infowindow = new BMap.InfoWindow(content);
marker.addEventListener("click", function () {
this.openInfoWindow(infowindow);
});
}
}, cityName);
},
tableRowClick: function (grid, rowData) {
if (rowData == undefined) return;
$.post("/Basic/ProductBatch/GetBEnterStatistics", {
ProductId: own.ProductId,
BatchId: own.CurrentId,
ProvinceName: rowData.ProvinceName,
CityName: rowData.CityName
}, function (result) {
if (result.ResultType != undefined) return;
//重新載入地圖
own.LoadMap(rowData.ProvinceName + "" + rowData.CityName, result.data);
});
this.base(grid, rowData);
},
returnCommand: function () {
App.jumpTo({ url: "/Basic/ProductBatch/Index", data: { Id: this.CurrentId } });
},
prevCommand: function () {
if (this.PrevId == undefined || this.PrevId == null || this.PrevId == "") {
alert("上一條為空,已沒有其它結果!");
return;
}
App.jumpTo({ url: "/Basic/ProductBatch/IndexMap",
data: { ProductId: this.ProductId, BatchId: this.PrevId } });
},
nextCommand: function () {
if (this.NextId == undefined || this.NextId == null || this.NextId == "") {
alert("下一條為空,已沒有其它結果!");
return;
}
App.jumpTo({ url: "/Basic/ProductBatch/IndexMap",
data: { ProductId: this.ProductId, BatchId: this.NextId } });
}
});
return {
init: function (ViewModel, PrevId, NextId) {
SecondTableLayoutViewModel.resetKoBindID("divIndexView");
var node = document.getElementById("divIndexView");
ko.cleanNode(node);
var mTableViewModel = new TableViewModel(ViewModel);
mTableViewModel.ProductId = ViewModel.ProductID;
mTableViewModel.PrevId = PrevId;
mTableViewModel.NextId = NextId;
ko.applyBindings(mTableViewModel, node);
}
};
}();
jQuery(document).ready(function () {
var mPrevId = "@ViewBag.PrevId";
var mNextId = "@ViewBag.NextId";
mDataGrid.init(@Html.Raw(ViewBag.ViewModel), mPrevId, mNextId);
});
</script>
}
Controller 負責組裝 ViewModel、計算上下一筆的 ID,並提供兩個給前端 AJAX 呼叫的聚合端點。
#region 銷售地圖
public ActionResult IndexMap(Guid ProductId, Guid BatchId)
{
try
{
List<ProductBatchViewModel> list =
_IProductBatchs.GetEntityList(t => t.IsDelete == false && t.ProductID == ProductId);
ProductBatchViewModel mViewModel = null;
string mPrevId = string.Empty, mNextId = string.Empty;
//讀取當前任務及上、下一筆的標識
for (int index = 0; index < list.Count; index++)
{
if (list[index].Id == BatchId)
{
mViewModel = list[index];
if (list.Count > index + 1) mNextId = list[index + 1].Id.ToString();
break;
}
mPrevId = list[index].Id.ToString();
}
if (mViewModel == null)
{
return this.ResultError("產品生產資訊不能為空!");
}
ViewBag.bCreate = 0;
ViewBag.ProductId = ProductId;
ViewBag.PrevId = mPrevId;
ViewBag.NextId = mNextId;
ViewBag.ViewModel = mViewModel.ToViewModel();
return View("_IndexMap");
}
catch (Exception e)
{
return this.ResultError(e.Message);
}
}
[Import(typeof(IProductBatchSup))]
public IProductBatchSup _IProductBatchSup;
/// 依省市聚合單位家數
public ActionResult GetBAreaStatistics(Guid ProductId, Guid BatchId)
{
try
{
ReturnResult mReturn = _IProductBatchSup.GetBAreaStatistics(ProductId, BatchId);
if (mReturn.State == false) return this.ResultError(mReturn.Message);
return JsonNetResult.toDataTable(mReturn.Result);
}
catch (Exception e)
{
return this.ResultError(e.Message);
}
}
/// 依省市取得該區域下的單位清單
public ActionResult GetBEnterStatistics(Guid ProductId, Guid BatchId, string ProvinceName, string CityName)
{
try
{
ReturnResult mReturn =
_IProductBatchSup.GetBEnterStatistics(ProductId, BatchId, ProvinceName, CityName);
if (mReturn.State == false) return this.ResultError(mReturn.Message);
return JsonNetResult.toDataTable(mReturn.Result);
}
catch (Exception e)
{
return this.ResultError(e.Message);
}
}
#endregion
Geocoder.getPoint() 的第三個參數是城市名稱。這一步很重要——同一個「中山路」在全國有幾百條,不指定城市會大量誤命中。範例中把省市名拼起來傳入,就是為了縮小地理檢索的範圍。
程式裡先檢查 Address,若為空就改用「區域名 + 街道名」組合。這個防禦是必要的——地圖標記失敗不該讓整個頁面掛掉。
目前 LoadMap() 直接疊加新標記。使用者連續點擊幾個省市之後,圖上會殘留先前區域的標記。實務上應該在重新載入前先清掉:
bMap.clearOverlays();
百度地圖的地理編碼介面有每日呼叫量與併發限制。若單一省市下的單位數量大(例如幾十家),迴圈逐一呼叫可能觸發限流。比較穩健的做法是後端先批次轉好座標存進資料庫,前端直接拿座標畫點,完全不依賴即時地理編碼。
content 是用字串拼接 HTML,而 enterinfo.EnterName 與 mAddress 都來自資料庫。如果這些欄位可能包含使用者輸入,就存在 XSS 風險。建議改用 DOM API 建立節點,或在拼接前做 HTML 轉義。