备份:DpMap二期修改
sendRequest.js
- //
- /ShopProductSales.aspx modify by elifefly 2008.8.25
- //
- function ReqShopProductSales()
- {
- var serials; //系列
- var type; //类别
- if($("productCat").options($("productCat").selectedIndex).innerHTML=="全部")
- type="";
- else
- type =$("productCat").options($("productCat").selectedIndex).innerHTML;
- if($("productSeries").options($("productSeries").selectedIndex).innerHTML=="全部")
- serials="";
- else serials=$("productSeries").options($("productSeries").selectedIndex).innerHTML;
- var s = "sn=" + $("storename").value //门店名称
- + "&rn=" + $("retailername").value //隶属连锁商
- + "&pl=" + $("provincelist").value //省份
- + "&cl=" + $("citylist").value //地级市
- + "&rl=" + $("regionlist").value //大区
- + "&fl=" + $("filialenamelist").value //分公司
- + "&ai=" + $("agentnameinput").value //代理商
- + "&st=" + $("sBegin_sBegin").value //上报时间 起 //sBegin_sBegin对应页面中cBegin这个标签
- + "&et=" + $("sEnd_sEnd").value //上报日期 止 //sEnd_sEnd对应页面中sEnd这个标签
- + "&se=" + serials //系列
- + "&ty=" + type //类别
- + "&sk=" + $("productSKU").value //产品SKU
- + "&co=" + $("productCoding").value; //产品编码
- var url = "./shopProductSales.ashx?" + s;
- url = encodeURI(url);///对url中文参数处理/// add by elifefly 2008.8.22/
- xhrSendRequest.open("post",url,false);
- xhrSendRequest.setRequestHeader("Content-Length",url.length);
- xhrSendRequest.setRequestHeader("CONTENT-TYPE","application/x-www-form-urlencoded");
- xhrSendRequest.onreadystatechange = showShopProductSalesGeoPoints; //调用showShopProductSalesGeoPoints()
- xhrSendRequest.send();
- }
- function showShopProductSalesGeoPoints() //在地图上显示从服务端返回的地理数据
- {
- if (xhrSendRequest.readyState==4 || xhrSendRequest.readyState=="complete")
- {
- var points = [];
- var items = null;
- try
- {
- items = eval("(" + xhrSendRequest.responseText + ")");
- }
- catch(ex)
- {
- alert("没有你要找的门店!");
- }
- var marker = null;//标注点符号
- var point = null;//地理点
- var storename = null;//标注点名称
- var salescount = null;//产品销量
- var avgprice = null;
- var sumprice = null;
- if(!items) return;
- map.clearOverLays();
- for (i=0; i<(items.length); i++)
- {
- var node = items[i];
- if(!node) continue;
- point = new LTPoint(parseInt(node.Longitude),parseInt(node.Latitude));//根据读取的经度和纬度创建一个地理点坐标--标注点
- points.push(point); //入栈,把标注点装入points = []数组,因为标注点有多个
- 获取节点 add by elifefly 2008.8.21///
- storename = node.storeName; //获取节点
- salescount = node.sumDistrib;
- avgprice = node.avgPrice;
- sumprice = node.sumPrice;
- 获取节点 add by elifefly 2008.8.21///
- //设置点的样式,高,宽
- var ptIcon = new LTIcon();
- ptIcon.setWidth( 32 );
- ptIcon.setHeight( 32 );
- marker = new LTMarker(point,ptIcon); //标注点根据标注点图标的大小选择性的显示出来,避免标注点过于密集
- ptIcon.setImageUrl( "./icons/s/red.gif" ); /设置默认门店标注点图标/// add by elifefly 2008.8.21/
- var text = new LTMapText( marker ); //创建一个文本标注对象,该对象显示在指定的地理位置或标注处
- if($("checkNumInfo").checked == true)
- {
- text.setLabel( "<div style=background:#809FFF;><span style=font-size:14px; font-color:#FFFFFF;><strong>" + storename + "</strong></span><br/><span style=font-size:12px; font-color:#FFFFFF;>产品销量:" + salescount +" 平均单价:"+ avgprice +" 零售总额:"+ sumprice +"</span><br/></div>");
- map.addOverLay( text ); //指定的座标出显示文本,对地图进行拖放等操作,文本将始终保持在该坐标处
- }
- map.addOverLay(marker); //在标记的图标上显示一个信息浮窗,该信息浮窗箭头指向该标记;
- }
- var c = new LTSmallMapControl(); //显示地图最小工具栏
- map.addControl(c);
- map.setCenterAtLatLng(point); //将地图的中心点直接变换到指定的地理坐标,不执行滑动过程
- //map.zoomTo(9); //将视图切换到指定的缩放等级9,中心点坐标不变
- map.getBestMap(points); //地图会自动的选择最佳视图(缩放等级和中心点坐标),以显示数组之中的所有点
- //
- }
- }
shopProductSales.js
- shopProductSales.js add by elifefly 2008.8.22
- /shopProductSales.js 用于ShopProductSales.aspx页面地图初始化所有门店标注点
- var map;//地图对象
- var editMark;//当前正在编辑的标注
- var defaultCenter = new LTPoint(10671030,3310736);//默认的地图中心
- var defalutMapLevel = 13; //默认的地图级别
- var markCollection;
- var markOper;
- var currentTool;
- var defaultTool;
- var markerTool;
- var iconsWin;
- //地图初始化
- function onLoad()
- {
- map = new LTMaps("mapDiv"); //mapDiv是页面标签/LTMaps("mapDiv")函数使用指定的mapDiv层创建一个地图对象
- map.centerAndZoom(defaultCenter,defalutMapLevel); /创建默认地图,使用默认的中心位置的经纬度和“缩放级别”
- map.addControl(new LTStandMapControl()); 为地图添加标准导航控件
- 生成标记管理类 LTMarkerCollection(map) add by elifefly 2008.8.16
- //markCollection =new LTMarkerCollection(map);/
- //markOper = new MarkerOper(map);/
- map.handleKeyboard();//启用键盘
- map.handleMouseScroll();//启用鼠标滚轮功能支持,参数true代表使用鼠标指向点位置不变模式
- initTools(); //初始化工具栏
- initMarkerOper();
- ///initIcons()函数有问题,待改进
- ///initIcons();///绑定各种彩色标注图标//
- initMapDivSize(); 加载地图的层大小值
- // RequestAllStoreMark() add by elifefly 2008.8.22//
- //加载所有已经标注的门店标注点/
- //RequestAllStoreMark();
- }
- //地图的层大小
- function initMapDivSize()
- {
- document.getElementById("mapDiv").style.height = window.screen.availHeight * 0.75;
- }
- //获取下拉框中的选择值
- function getSelectedValue(id)
- {
- var selectControl = $(id);
- return selectControl.options(selectControl.selectedIndex).innerHTML;
- }
- //根据id获取要素
- function $(id)
- {
- return document.getElementById(id);
- }
- function CreateXMLDom()
- {
- if(window.ActiveXObject)
- {
- var arrSignatures = ["MSXML2.DOMDocument.5.0","MSXML2.DOMDocument.4.0",
- "MSXML2.DOMDocument.3.0","MSXML2.DOMDocument","Microsoft.XMLDom"];
- for (var i = 0; i < arrSignatures.length;i++)
- {
- try
- {
- var oXmlDom = new ActiveXObject(arrSignatures[i]);
- return oXmlDom;
- }
- catch(oError){}
- }
- throw new Error("MSXML is not installed on your system");
- }
- else if(document.implementation && document.implementation.cereateDocument)
- {
- var oXmlDom = document.implementation.createDocument("","",null);
- return oXmlDom;
- }
- else
- {
- throw new Error("Your browser doesn't support an XML DOM object");
- }
- }
- function RequestAllStoreMark() //显示所有标注点
- {
- //var s 无条件查询/// add by elifefly 2008.8.25/
- var s = "sn=" //门店名称
- + "&rn=" //隶属连锁商
- + "&pl=" //省份
- + "&cl=" //地级市
- + "&rl=" //大区
- + "&fl=" //分公司
- + "&ai=" //代理商
- + "&st=" + $("sBegin_sBegin").value //上报时间 起 //sBegin_sBegin对应页面中cBegin这个标签
- + "&et=" + $("sEnd_sEnd").value //上报日期 止 //sEnd_sEnd对应页面中sEnd这个标签
- + "&se=" //系列
- + "&ty=" //类别
- + "&sk=" //产品SKU
- + "&co="; //产品编码
- var url = "./shopProductSales.ashx?" + s;
- url = encodeURI(url);///对url中文参数处理/// add by elifefly 2008.8.22/
- xhrSendRequest.open("post",url,false);
- xhrSendRequest.setRequestHeader("Content-Length",url.length);
- xhrSendRequest.setRequestHeader("CONTENT-TYPE","application/x-www-form-urlencoded");
- xhrSendRequest.onreadystatechange = showShopProductSalesGeoPoints; //调用showShopProductSalesGeoPoints()
- xhrSendRequest.send();
- }
shopProductSales.ashx
- <%@ WebHandler Language="C#" Class="shopProductSales" %>
- using System;
- using System.Web;
- using System.Data;
- /// <summary>
- /// 右侧查询条件
- /// </summary>
- //
- /ShopProductSales.aspx elifefly 2008.8.20
- //
- public class shopProductSales : IHttpHandler {
- public void ProcessRequest (HttpContext context)
- {
- context.Response.ContentType = "text/plain";
- string storeName = context.Request.QueryString["sn"]; //门店名称 $("storename").value
- string retailerName = context.Request.QueryString["rn"]; //隶属连锁商 $("retailername").value
- string provinceName = context.Request.QueryString["pl"]; //省份 $("provincelist").value
- string cityName = context.Request.QueryString["cl"]; //地级市 $("citylist").value
- string regionName = context.Request.QueryString["rl"]; //大区 $("regionlist").value
- string filialeName = context.Request.QueryString["fl"]; //分公司 $("filialenamelist").value
- string agentName = context.Request.QueryString["ai"]; //代理商 $("agentnameinput").value
- string startTime = context.Request.QueryString["st"]; //上报时间 起 $("sBegin_sBegin").value
- string endTime = context.Request.QueryString["et"]; //上报日期 止 $("sEnd_sEnd").value
- string serials = context.Request.QueryString["se"]; //系列 serials
- string type = context.Request.QueryString["ty"]; //类别 type
- string sku = context.Request.QueryString["sk"]; //产品SKU $("productSKU").value
- string code = context.Request.QueryString["co"]; //产品编码 $("productCoding").value
- //调用GetshopProductSales
- string result = this.GetshopProductSales(storeName, retailerName, provinceName, cityName, regionName, filialeName, agentName, startTime, endTime, serials, type, sku, code);
- context.Response.Clear(); //清空服务器端为此会话开辟的输出缓存
- context.Response.Write(result);//将结果写入到服务器端为此会话开辟的输出缓存中
- context.Response.Flush();
- context.Response.Close();//将服务器端为此会话开辟的输出缓存中的信息传送到客户端
- }
- private string GetshopProductSales(string storeName, string retailerName, string provinceName, string cityName, string regionName, string filialeName, string agentName, string startTime, string endTime, string serials, string type, string sku, string code)
- {
- start判断参数是否为空或者是“全部”字符串,如果为空或者是“全部”字符串,则相应的条件置空///add by elifefly 2008.8.25//
- string storenamesql = " ";
- string retailernamesql = " ";
- string provinceNamesql = " ";
- string cityNamesql = " ";
- string regionNamesql = " ";
- string filialeNamesql = " ";
- string agentNamesql = " ";
- string starttimesql = " ";
- string endtimesql = " ";
- string serialssql = " ";
- string typesql = " ";
- string skusql = " ";
- string codesql = " ";
- //storenamesql 门店名称
- if (storeName != string.Empty)
- {
- storenamesql = " StoreName like '%" + storeName + "%' and";
- }
- // retailernamesql 隶属连锁商
- if (retailerName != string.Empty)
- {
- retailernamesql = " RetailerName like '%" + retailerName + "%' and";
- }
- // provinceNamesql 省份
- if (provinceName != string.Empty && provinceName != "全部")
- {
- provinceNamesql = " Province like '%" + provinceName + "%' and";
- }
- // cityNamesql 地级市
- if (cityName != string.Empty && cityName != "全部")
- {
- cityNamesql = " City like '%" + cityName + "%' and";
- }
- // regionNamesql 大区
- if (regionName != string.Empty && regionName != "全部")
- {
- regionNamesql = " Region like '%" + regionName + "%' and";
- }
- // filialeNamesql 分公司
- if (filialeName != string.Empty && filialeName != "全部")
- {
- filialeNamesql = " FilialeName like '%" + filialeName + "%' and";
- }
- // agentNamesql 代理商
- if (agentName != string.Empty && agentName != "全部")
- {
- agentNamesql = " AgentName like '%" + agentName + "%' and";
- }
- //starttimesql 上报时间 起
- if (startTime != string.Empty)
- {
- starttimesql = " convert(varchar(10),RecvTime,120) >='" + startTime + "' and";
- }
- //endtimesql 上报日期 止
- if (endTime != string.Empty)
- {
- endtimesql = " convert(varchar(10),recvtime,120)<'" + endTime + "' and";
- }
- // serialssql 系列
- if (serials != string.Empty && serials != "全部")
- {
- serialssql = " Series like '%" + serials + "%' and";
- }
- // typesql 类别
- if (type != string.Empty && type != "全部")
- {
- typesql = " Category like '%" + type + "%' and";
- }
- // skusql 产品SKU
- if (sku != string.Empty)
- {
- skusql = " Sku = '" + sku + "' and";
- }
- // codesql 产品编码
- if (code != string.Empty)
- {
- codesql = " Code = '" + code + "' and";
- }
- end判断参数是否为空,如果为空,则相应的条件置空///add by elifefly 2008.8.25/
- string sql = "select distinct StoreName, Longitude ,Latitude, sum(Distribution) as sumDistrib, convert(numeric(15,2),isnull(sum(Price*Distribution)/sum(Distribution),0)) as avgPrice,isnull(sum(Price*Distribution),0) as sumPrice"
- + " from V_Map where"
- + starttimesql // + " convert(varchar(10),RecvTime,120)>='2008-08-18'"
- + endtimesql //+ " and convert(varchar(10),recvtime,120) < '2008-08-19'"
- + storenamesql // + " and StoreName like '%广州%'"
- + retailernamesql //+ " and RetailerName like '%gome%'"
- + provinceNamesql
- + cityNamesql
- + regionNamesql
- + filialeNamesql
- + agentNamesql
- + serialssql
- + typesql
- + skusql
- + codesql
- + " Longitude is not null and Latitude is not null"
- + " group by StoreName,Longitude,Latitude ;";
- System.Data.DataTable dtResult = Utils.Instance.GetDataFromSqlServerr(sql);
- string result = "[";
- foreach(System.Data.DataRow dr in dtResult.Rows)
- {
- result += "{";
- result += string.Format("storeName:'{0}',Longitude:'{1}',Latitude:'{2}',sumDistrib:'{3}',avgPrice:'{4}',sumPrice:'{5}'", dr["StoreName"].ToString(), dr["Longitude"].ToString(), dr["Latitude"].ToString(), dr["sumDistrib"].ToString(), dr["avgPrice"].ToString(), dr["sumPrice"].ToString());
- result += "},";
- }
- if (result.Length > 1)
- {
- result = result.Remove(result.Length - 1);
- }
- result += "]";
- /start//如果result返回结果为空,则不返回任何值///add by elifefly 2008.8.22/
- if (result == "[]")
- {
- return "";
- }
- else
- {
- return result;
- }
- end///如果result返回结果为空,则不返回任何值///add by elifefly 2008.8.22/
- }
- public bool IsReusable
- {
- get
- {
- return false;
- }
- }
- }
ShopProductSales.aspx
- <%@ Page Language="C#" AutoEventWireup="true" CodeFile="ShopProductSales.aspx.cs" Inherits="Webroot_DPCS_51ditu_ProductSales" %>
- <%@ Register TagPrefix="cc1" Namespace="Myvas.Web.UI.WebControls" Assembly="Myvas.Web.UI.WebControls" %>
- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
- <html xmlns="http://www.w3.org/1999/xhtml" >
- <head id="Head1" runat="server">
- <title>门 店 - 产品销售</title>
- <link rel="stylesheet" type="text/css" href="StyleSheet.css" />
- <script language="javascript" src="http://api.51ditu.com/js/maps.js" type="text/jscript"></script>
- <script language="javascript" src="http://api.51ditu.com/js/ajax.js" type="text/jscript"></script>
- <script language="javascript" src="./js/tools.js" type="text/jscript"></script>
- <script language="javascript" src="./js/shopProductSales.js" type="text/jscript"></script>
- <script language="javascript" src="./js/postdata.js" type="text/jscript"></script>
- <script language="javascript" src="./js/marker.js" type="text/jscript"></script>
- <script language="javascript" src="./js/getdata.js" type="text/jscript"></script>
- <script language="javascript" src="./js/business.js" type="text/jscript"></script>
- <script language="javascript" src="./js/sendRequest.js" type="text/jscript"></script>
- <script language ="javascript" src="./js/select.js" type="text/javascript"></script>
- </head>
- <body οnlοad="onLoad()">
- <form id="form1" runat="server">
- <div>
- <div class="headInfo"><div class="MapName">门 店 - 产品销售</div><div class="helpTitle"><a href="#">帮 助</a></div></div>
- <div id="toolsDiv" class="Tools" ></div>
- <div id="bzDiv" class="selSection">
- <div class="rightSelectionHead" ><div class="SelectionTitle">查询条件</div></div>
- <div class="bzContont" style="left: 0px; top: 0px; width: 195px;">
- <span style="margin-left:0px; font-family:黑体; font-size:14px; color:#7B8DBD; margin-top:10px;">门店选择</span>
- <table style="margin-top:5px; margin-left:0px;"><tr><td>
- <span style="font-size:14px;">门店名称</span><input id="storename" name="storename" size="12" style="margin-left:0px;" /></td>
- <td style="height: 42px"><span style="font-size:14px;">隶属连锁商 </span><input id="retailername" name="retailername" size="12" style="margin-left:0px;" /></td>
- </tr>
- <tr><td style="height: 42px"><span style="font-size:14px;">省份<asp:DropDownList ID="provincelist" runat="server" AutoPostBack="True" OnSelectedIndexChanged="provincelist_SelectedIndexChanged" >
- </asp:DropDownList></span></td>
- <td style="height: 42px"><span style="font-size:14px;">地级市<asp:DropDownList ID="citylist" runat="server" >
- </asp:DropDownList></span></td></tr>
- <tr><td style="height: 42px"><span style="font-size:14px;">大区<asp:DropDownList ID="regionlist" runat="server" AutoPostBack="True" DataTextField="rgName"
- DataValueField="rgId" OnSelectedIndexChanged="region_SelectedIndexChanged">
- </asp:DropDownList></span></td>
- <td style="height: 42px"><span style="font-size:14px;">分公司<asp:DropDownList ID="filialenamelist" runat="server">
- </asp:DropDownList></span></td></tr>
- <tr><td style="height: 42px"><span style="font-size:14px;">代理商</span><input id="agentnameinput" name="agentname" size="12" style="margin-left:0px;" /></td></tr>
- </table>
- <br>
- <span style="margin-left:0px; font-family:黑体; font-size:14px; color:#7B8DBD; margin-top:5px;">数据时间范围</span><table style="margin-top: 0px; margin-left: 0px; height: 1px; width: 237px;">
- <tr>
- <td style="width: 116px; height: 20px;">
- <div class="dateTitle">
- 上报时间 起<cc1:DateTimeSelector ID="sBegin" runat="server" DateStyle="yyyy-MM-dd" SitePath="../../DateTimeSelector/" Width="127px" /></div></td>
- <td style="width: 116px; height: 20px">
- <div class="dateTitle">上报日期 止<cc1:DateTimeSelector ID="sEnd" runat="server" DateStyle="yyyy-MM-dd" SitePath="../../DateTimeSelector/" Width="129px" /></div>
- </td>
- </tr>
- </table>
- <span style="font-size: 10pt; color: #7b8dbd; font-family: 黑体">数据范围</span>
- <div class="productSeries">系 列<select id="productSeries" name="productSeriesList" οnchange="redirec(this.options.selectedIndex)" >
- <option selected="selected">全部</option>
- <option value="S机">S机</option>
- <option value="Q机">Q机</option>
- <option value="G机">G机</option>
- </select> </div><div class="productSeries">类 别<select id="productCat" name="productCatList" >
- <option selected="selected">全部</option>
- </select>
- </div>
- <div class="productCat">
- </div>
- <div class="inputTitle">
- 产品SKU<input id="productSKU" name="productSKU" size="12" style="margin-left: 18px" /></div>
- <div class="inputTitle">产品编码
- <input id="productCoding" name="productCoding" size="12" style="margin-left: 18px" /></div>
- <br />
- <div class="inputTitle"><input type="checkbox" id="checkNumInfo" name="checkNumInfo" tabindex="0" value="on" οnclick="ReqShopProductSales()" />出现数据框</div>
- <div id="btnQuery" style="margin-top:10px; margin-left:70px;">
- <input id="btnViewPOI" type="button" value="查 询" οnclick="ReqShopProductSales()" />
- </div>
- </div>
- </div>
- <div id="mapDiv" class="map"></div>
- <div id="markerEdit" style="display:none; margin-top:800px; margin-left:80px;" tabindex="1" >
- <table id="markerEditForm" >
- <tr>
- <td style="width: 53px">级别</td>
- <td class="style2">
- <select id="label" style="width: 150px">
- <option selected="selected">大区</option>
- <option >分公司</option>
- <option >代理商</option>
- <option >省</option>
- <option >地级市</option>
- </select>
- </td>
- <td class="style1" rowspan="3">
- <div id="iconDiv" style="overflow:auto;border:solid 1px blue;margin-top:0px;scrollbar-face-color: CornflowerBlue; scrollbar-track-color:white; width:165px; height:100px"></div></td>
- </tr>
- <tr>
- <td style="width: 53px" >名称</td>
- <td class="style2"><input type="text" id="name" style="font-size:12px;width:150px;border:#0000FF solid 1px;"/></td>
- </tr>
- <tr>
- <td style="width: 53px" >图标</td>
- <td align="left" class="style2"><img id="icon" src="./img/trak.gif" alt="" /></td>
- </tr>
- </table>
- <input type="hidden" id="index" value="0" />
- </div>
- </form>
- </body>
- </html>
ShopProductSales.aspx.cs
- using System;
- using System.Data;
- using System.Configuration;
- using System.Collections;
- using System.Web;
- using System.Web.Security;
- using System.Web.UI;
- using System.Web.UI.WebControls;
- using System.Web.UI.WebControls.WebParts;
- using System.Web.UI.HtmlControls;
- using System.Data.Sql;
- using System.Data.SqlClient;
- using CoreLib.Web;
- using DPSystem5Biz.Utils;
- //
- /ShopProductSales.aspx.cs add by elifefly 2008.8.26
- //
- public partial class Webroot_DPCS_51ditu_ProductSales : System.Web.UI.Page
- {
- protected void Page_Load(object sender, EventArgs e)
- {
- if (!IsPostBack) //为上报时间 起---添加默认日期(昨天日期)
- {
- this.sBegin.Text = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
- this.sEnd.Text = DateTime.Now.AddDays(-0).ToString("yyyy-MM-dd");
- provincelistSql(); //绑定省份列表
- citylistSql(); //绑定地级市列表
- regionlistSql(); //绑定大区列表
- filialenamelistSql(); //绑定分公司列表
- }
- }
- //实现绑定省份列表
- public void provincelistSql()
- {
- string provincelistsql = "select distinct Province from V_Map where Province is not null;";
- string sConnPars1 = Utils.Instance.GetConnectionString();
- SqlConnection oConn = new SqlConnection(sConnPars1);
- SqlDataAdapter myda = new SqlDataAdapter(provincelistsql, oConn);
- DataSet myds = new DataSet();
- oConn.Open();
- myda.Fill(myds, " Temp_Map");
- provincelist.DataSource = myds;
- provincelist.DataTextField = "Province";
- provincelist.DataValueField = "Province";
- provincelist.DataBind();
- DPWebUtils.AddOptionToSelect(this.provincelist, (string)GetGlobalResourceObject("Resource", "lbSelectAll"), "");
- oConn.Close();
- }
- //绑定地级市列表,显示字符串"全部"
- public void citylistSql()
- {
- citylist.DataBind();
- //添加字符串"全部"
- DPWebUtils.AddOptionToSelect(this.citylist, (string)GetGlobalResourceObject("Resource", "lbSelectAll"), "");
- }
- //实现绑定大区列表
- public void regionlistSql()
- {
- string regionlistsql = "select distinct Region from V_Map where Region is not null;";
- string sConnPars3 = Utils.Instance.GetConnectionString();
- SqlConnection oConn3 = new SqlConnection(sConnPars3);
- SqlDataAdapter myda3 = new SqlDataAdapter(regionlistsql, oConn3);
- DataSet myds3 = new DataSet();
- oConn3.Open();
- myda3.Fill(myds3, " Temp_Map3");
- regionlist.DataSource = myds3;
- regionlist.DataTextField = "Region";
- regionlist.DataValueField = "Region";
- regionlist.DataBind();
- //添加字符串"全部"
- DPWebUtils.AddOptionToSelect(this.regionlist, (string)GetGlobalResourceObject("Resource", "lbSelectAll"), "");
- oConn3.Close();
- }
- //绑定分公司列表,显示字符串"全部"
- public void filialenamelistSql()
- {
- filialenamelist.DataBind();
- //添加字符串"全部"
- DPWebUtils.AddOptionToSelect(this.filialenamelist, (string)GetGlobalResourceObject("Resource", "lbSelectAll"), "");
- }
- //实现绑定分公司列表
- protected void provincelist_SelectedIndexChanged(object sender, EventArgs e)
- {
- string provincevalue = this.provincelist.SelectedValue;
- string citylistsql = "select distinct City from V_Map where City is not null and Province = '" + provincevalue + "';";
- string sConnPars2 = Utils.Instance.GetConnectionString();
- SqlConnection oConn2 = new SqlConnection(sConnPars2);
- SqlDataAdapter myda2 = new SqlDataAdapter(citylistsql, oConn2);
- DataSet myds2 = new DataSet();
- oConn2.Open();
- myda2.Fill(myds2, " Temp_Map2");
- citylist.DataSource = myds2;
- citylist.DataTextField = "City";
- citylist.DataValueField = "City";
- citylist.DataBind();
- //添加字符串"全部"
- DPWebUtils.AddOptionToSelect(this.citylist, (string)GetGlobalResourceObject("Resource", "lbSelectAll"), "");
- oConn2.Close();
- }
- //实现绑定分公司列表
- protected void region_SelectedIndexChanged(object sender, EventArgs e)
- {
- string regionlistvalue = this.regionlist.SelectedValue;
- string filialenamelistsql = "select distinct FilialeName from V_Map where FilialeName is not null and Region = '" + regionlistvalue + "';";
- string sConnPars4 = Utils.Instance.GetConnectionString();
- SqlConnection oConn4 = new SqlConnection(sConnPars4);
- SqlDataAdapter myda4 = new SqlDataAdapter(filialenamelistsql, oConn4);
- DataSet myds4 = new DataSet();
- oConn4.Open();
- myda4.Fill(myds4, " Temp_Map4");
- filialenamelist.DataSource = myds4;
- filialenamelist.DataTextField = "FilialeName";
- filialenamelist.DataValueField = "FilialeName";
- filialenamelist.DataBind();
- //添加字符串"全部"
- DPWebUtils.AddOptionToSelect(this.filialenamelist, (string)GetGlobalResourceObject("Resource", "lbSelectAll"), "");
- oConn4.Close();
- }
- }