.NET 应用webservices的实现全国各地省市县的选择....

最新推荐文章于 2020-09-17 14:56:39 发布
最新推荐文章于 2020-09-17 14:56:39 发布
阅读量2.2k 收藏
点赞数
文章标签： .net textbox string server asp radiobutton
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/xuezhanliang6886/article/details/4384328
版权

1.首先要在项目里建一个SNWebService.asmx:

SNWebService.cs的代码:

using System;
using System.Web;
using System.Collections;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Web.Script.Services;
using System.Collections.Generic;
using System.Collections.Specialized;
using AjaxControlToolkit;
using System.Data.SqlClient;
using System.Data;

/// <summary>
/// SNWebService 的摘要说明
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[ScriptService]一定要加上这一句,以后应用的时候..
 

public class SNWebService : System.Web.Services.WebService
{

    public SNWebService()
    {
        //如果使用设计的组件，请取消注释以下行
        //InitializeComponent();
    }
    /// <summary>
    /// 获取省份数据
    /// </summary>
    /// <param name="knownCategoryValues"></param>
    /// <param name="category"></param>
    /// <returns></returns>
    [WebMethod]
   
    public CascadingDropDownNameValue[] GetProvinceContents(string knownCategoryValues, string category)
    {
        List<CascadingDropDownNameValue> provinceList = new List<CascadingDropDownNameValue>();
        try
        {


           // string connectionString = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];
            string connectionString = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];
            //string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["WorkDataConnectionString1"];
            SqlConnection sqlConn = new SqlConnection(connectionString);

            sqlConn.Open();

            string strSql = "Select * From Provice";

            SqlCommand sqlCmd = new SqlCommand(strSql, sqlConn);

            SqlDataReader dtrProvince = sqlCmd.ExecuteReader();

            while (dtrProvince.Read())
            {
                provinceList.Add(new CascadingDropDownNameValue(dtrProvince["ProName"].ToString(), dtrProvince["ProId"].ToString()));
            }
           

            dtrProvince.Close();

            sqlConn.Close();

        }
        catch (Exception ex)
        {
           
            throw;
        }
       
        return provinceList.ToArray();
    }
    /// <summary>
    /// 获取市数据
    /// </summary>
    /// <param name="knownCategoryValues"></param>
    /// <param name="category"></param>
    /// <returns></returns>
    [WebMethod]
    public CascadingDropDownNameValue[] GetCityContents(string knownCategoryValues, string category)
    {
        StringDictionary provinceList = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);

        //string connectionString = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];
        string connectionString = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];
        SqlConnection sqlConn = new SqlConnection(connectionString);

        sqlConn.Open();

        string strSql = "Select * From city Where ProId=" + provinceList["Province"] + "";

        SqlCommand sqlCmd = new SqlCommand(strSql, sqlConn);

        SqlDataReader dtrCity = sqlCmd.ExecuteReader();

        List<CascadingDropDownNameValue> cityList = new List<CascadingDropDownNameValue>();

        while (dtrCity.Read())
        {
            cityList.Add(new CascadingDropDownNameValue(dtrCity["CityName"].ToString(), dtrCity["CityID"].ToString()));
        }

        dtrCity.Close();

        return cityList.ToArray();
    }
    /// <summary>
    /// 获取乡镇数据
    /// </summary>
    /// <param name="knownCategoryValues"></param>
    /// <param name="category"></param>
    /// <returns></returns>
    [WebMethod]
    public CascadingDropDownNameValue[] GetViliageContents(string knownCategoryValues, string category)
    {
        StringDictionary cityList = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);

        string connectionString = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];

        SqlConnection sqlConn = new SqlConnection(connectionString);

        sqlConn.Open();

        string strSql = "Select * From County Where CityId='" + cityList["City"] + "'";

        SqlCommand sqlCmd = new SqlCommand(strSql, sqlConn);

        SqlDataReader dtrViliage = sqlCmd.ExecuteReader();

        List<CascadingDropDownNameValue> viliageList = new List<CascadingDropDownNameValue>();

        while (dtrViliage.Read())
        {
            viliageList.Add(new CascadingDropDownNameValue(dtrViliage["CountyName"].ToString(), dtrViliage["Countyid"].ToString()));
        }

        dtrViliage.Close();

        return viliageList.ToArray();
    }
   
}

2.前台代码:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="AgentCenterInformation.aspx.cs"
    Inherits="zhigouwang_web_AgentCenterInformation" EnableEventValidation="false" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<!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 runat="server">
   
    <title>代理管理中心--修改/补充代理商信息</title>
    <link href="css/css.css" type="text/css" rel="stylesheet" />
</head>
<body>
    <form id="form1" runat="server">
        <asp:ScriptManager ID="ScriptManager1" runat="server">
        </asp:ScriptManager>
        <div>
            <!-- right begin-->
            <div class="agent_right">
                <div class="agent_right_list">
                    <p>
                        &nbsp;</p>
                </div>
                <div class="agent_right_list">
                    <li>
                        <p>
                            <table style="width: 494px; height: 281px">
                                <tr>
                                    <td colspan="3">
                                        <h4>
                                            修改补充代理商个人信息</h4>
                                    </td>
                                </tr>
                                <tr>
                                    <td style="width: 86px">
                                        代理商名：</td>
                                    <td style="width: 84px">
                                        <asp:TextBox ID="TextBox1" runat="server" Height="20px"></asp:TextBox></td>
                                    <td style="width: 188px">
                                        <img src="images/icon_18.gif" />
                                        用户的姓名
                                    </td>
                                </tr>
                                <tr>
                                    <td style="width: 86px">
                                        真实姓名：</td>
                                    <td style="width: 84px">
                                        <asp:TextBox ID="TextBox2" runat="server" Height="20px"></asp:TextBox></td>
                                    <td style="width: 188px">
                                        <img src="images/icon_18.gif" />用户的真实姓名</td>
                                </tr>
                                <tr>
                                    <td style="width: 86px; height: 1px;">
                                        &nbsp; 性 &nbsp; &nbsp; 别：</td>
                                    <td style="width: 84px; height: 1px;">
                                        <asp:RadioButtonList ID="Radio" runat="server" Font-Size="12px" Width="89px" Height="44px"
                                            RepeatDirection="Horizontal">
                                            <asp:ListItem Value="男" Selected="True">男</asp:ListItem>
                                            <asp:ListItem Value="女">女</asp:ListItem>
                                        </asp:RadioButtonList></td>
                                    <td style="width: 188px; height: 1px;">
                                        <img src="images/icon_18.gif" />
                                        用户的性别</td>
                                </tr>
                                <tr>
                                    <td style="width: 86px">
                                        手机号码：</td>
                                    <td style="width: 84px">
                                        <asp:TextBox ID="TextBox3" runat="server" Height="20px"></asp:TextBox></td>
                                    <td style="width: 188px">
                                        <img src="images/icon_18.gif" />
                                        用户的手机号码</td>
                                </tr>
                                <tr>
                                    <td style="width: 86px">
                                        电子邮件：</td>
                                    <td style="width: 84px">
                                        <asp:TextBox ID="TextBox4" runat="server" Height="20px"></asp:TextBox></td>
                                    <td style="width: 188px">
                                        <img src="images/icon_18.gif" />
                                        必填请输入有效的电子邮件地址
                                    </td>
                                </tr>
                                <tr>
                                    <td style="width: 86px">
                                        出生年月：</td>
                                    <td style="width: 84px">
                                        <asp:TextBox ID="TextBox5" runat="server" Height="20px"></asp:TextBox></td>
                                    <td style="width: 188px">
                                        <img src="images/icon_18.gif" />
                                        用户的出生日期</td>
                                </tr>
                                <tr>
                                    <td style="width: 86px">
                                        身份证号：</td>
                                    <td style="width: 84px">
                                        <asp:TextBox ID="TextBox6" runat="server" Height="20px"></asp:TextBox></td>
                                    <td style="width: 188px">
                                        <img src="images/icon_18.gif" />
                                        用户的身份证号码</td>
                                </tr>
                                <tr>
                                    <td style="width: 86px">
                                        是否修改地址：</td>
                                    <td colspan="2">
                                        <asp:RadioButton ID="rabtrue" runat="server" AutoPostBack="True" GroupName="0" OnCheckedChanged="rabtrue_CheckedChanged" />是
                                        <asp:RadioButton ID="rabfalse" runat="server" AutoPostBack="True" Checked="True"
                                            GroupName="0" OnCheckedChanged="rabfalse_CheckedChanged" />否&nbsp;</td>
                                </tr>
                                <tr>
                                    <td colspan="3">
                                        <asp:UpdatePanel ID="UpdatePanel1" runat="server">
                                            <ContentTemplate>
                                                所在地区:&nbsp;&nbsp;<asp:DropDownList ID="ddlProvince" runat="server">
                                                </asp:DropDownList>省<asp:DropDownList ID="ddlCity" runat="server">
                                                </asp:DropDownList>市<asp:DropDownList ID="ddlVilliage" runat="server">
                                                </asp:DropDownList>区
                                                <cc1:CascadingDropDown ID="CascadingDropDown2" runat="server" TargetControlID="ddlProvince"
                                                    ServicePath="SNWebService.asmx" ServiceMethod="GetProvinceContents" Category="Province"
                                                    PromptText="请选择省份" LoadingText="省份加载中...">
                                                </cc1:CascadingDropDown>
                                                <cc1:CascadingDropDown ID="CascadingDropDown1" runat="server" ParentControlID="ddlProvince"
                                                    ServicePath="SNWebService.asmx" ServiceMethod="GetCityContents" Category="City"
                                                    TargetControlID="ddlCity" PromptText="请选择城市" LoadingText="城市加载中...">
                                                </cc1:CascadingDropDown>
                                                <cc1:CascadingDropDown ID="CascadingDropDown3" runat="server" Category="Villiage"
                                                    LoadingText="区县加载中..." ParentControlID="ddlCity" PromptText="请选择区县" ServiceMethod="GetViliageContents"
                                                    ServicePath="SNWebService.asmx" TargetControlID="ddlVilliage">
                                                </cc1:CascadingDropDown>
                                            </ContentTemplate>
                                        </asp:UpdatePanel>
                                    </td>
                                </tr>
                                <tr>
                                    <td style="width: 86px">
                                        联系地址：</td>
                                    <td style="width: 84px">
                                        <asp:TextBox ID="TextBox7" runat="server" Height="20px"></asp:TextBox></td>
                                    <td style="width: 188px">
                                        <img src="images/icon_18.gif" />
                                        用户的详细地址
                                    </td>
                                </tr>
                                <tr>
                                    <td style="width: 86px">
                                    </td>
                                    <td style="width: 84px">
                                        <asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="images/icon_20.gif" OnClick="ImageButton1_Click" /></td>
                                    <td style="width: 188px">
                                    </td>
                                </tr>
                            </table>
                        </p>
                    </li>
                </div>
            </div>
            <!-- right end-->
        </div>
    </form>
</body>
</html>

3.后台代码:

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.SqlClient;
using OurWork.DataServer;

public partial class zhigouwang_web_AgentCenterInformation : System.Web.UI.Page
{

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            this.UpdatePanel1.Visible = false;
            if (Session["agentname"] == null)
            {
                Response.Write("<script language='JavaScript'>");
                Response.Write("alert('请先登录！')");
                Response.Write("</script>");
                Response.End();
                return;
            }

            try
            {
                string agentname = Session["agentname"].ToString();
                string sql = "SELECT * FROM Shop_Dls where DlsName='" + agentname + "'";
                SqlDataReader dr = DbHelperSQL.ExecuteReader1(sql);

                if (dr.Read())
                {
                    TextBox1.Text = dr["DlsName"].ToString();
                    TextBox2.Text = dr["DlsRN"].ToString();
                    Radio.SelectedValue = dr["DlsSex"].ToString();
                    TextBox3.Text = dr["DlsPhone"].ToString();
                    TextBox4.Text = dr["DlsEmail"].ToString();
                    TextBox5.Text = dr["DlsBirthday"].ToString();
                    TextBox6.Text = dr["Dlssfzh"].ToString();
                    TextBox7.Text = dr["DlsAdd"].ToString();
                    dr.Close();
                }
                else
                {
                    Response.Write("<script language='JavaScript'>");
                    Response.Write("alert('没有该用户！')");
                    Response.Write("</script>");
                    return;
                }
            }
            catch (Exception)
            {

                throw;
            }

        }
    }

    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
        string AgentName, TrueName, sex, phone, email, birthday, idcard, address;
        AgentName = TextBox1.Text;
        TrueName = TextBox2.Text;
        sex = Radio.SelectedItem.Value;
        phone = TextBox3.Text;
        email = TextBox4.Text;
        birthday = TextBox5.Text;
        idcard = TextBox6.Text;

        string provice = this.ddlProvince.SelectedValue;
        string city = this.ddlCity.SelectedValue;
        string villliage = this.ddlVilliage.SelectedValue;
        string xiaddres = "";
        if (provice != null && provice != "请选择省份" && provice != "")
        {
            xiaddres += this.ddlProvince.SelectedItem.Text;
        }
        if (city != null && city != "请选择城市" && city != "")
        {
            xiaddres += this.ddlCity.SelectedItem.Text;
        }
        if (villliage != null && villliage != "请选择区县" && villliage != "")
        {
            xiaddres += this.ddlVilliage.SelectedItem.Text;
        }
        address = xiaddres;

        this.TextBox7.Text = address;
        //执行sql更新命令
        string sql2 = "update Shop_Dls set DlsName='" + AgentName + "', DlsRN='" + TrueName + "',DlsSex='" + sex + "',DlsPhone='" + phone + "',DlsEmail='" + email + "',DlsBirthday='" + birthday + "',Dlssfzh='" + idcard + "',DlsAdd='" + address + "' where DlsName='" + AgentName + "'";
        DbHelperSQL.ExecuteReader1(sql2);

        Response.Write("<script language='JavaScript'>");
        Response.Write("alert('修改成功！')");
        Response.Write("</script>");
    }

    protected void rabtrue_CheckedChanged(object sender, EventArgs e)
    {
        this.UpdatePanel1.Visible = true;

    }
    protected void rabfalse_CheckedChanged(object sender, EventArgs e)
    {
        this.UpdatePanel1.Visible = false;
    }
}

xuezhanliang6886
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
asp.net Web.config 详细配置说明
10-29
asp.net开发的朋友，经常用得到web.config文件的配置，所以我们特整理了中文说明。
ASP.NET core Web中使用appsettings.json配置文件的方法
10-19
在ASP.NET Core Web开发中，配置管理是一个至关重要的部分，它允许开发者定义并访问应用程序的各种配置参数。在ASP.NET Core中，配置系统被设计得更加灵活和可扩展，其中一个常用的配置源就是`appsettings.json`文件...
web-sn
02-19 271
                        广州东部二手汽车网资料会员ID:20351125   密码:3210352业务内容:          GD939.CN主机管理员账号:    cw25005管理员密码：       t9rlj2q5共享IP地址         210.192.102.104新IP               218.30.96.269558803602143974
java访问WebService.asmx接口post方法说明
fujia305的专栏
03-31 1418
碰到了一个WebService.asmx的接口，在网上搜索了一下解决方式，记录一下，方便后续使用 import javax.xml.namespace.QName; import org.apache.axis.client.Call; import org.apache.axis.client.Service; public class Test{ public static voi...
WebService国内省市县接口
weixin_30384217的博客
01-04 440
主要给自己用的，分享下给大家测试用 地址：http://www.xinyibufang.com/Main_Service.asmx GetProvinceList方法 <string>[{'ID':'1','Name':'北京'},{'ID':'10','Name':'辽宁'},{'ID':'11','Name':'内蒙古'},{'ID':'12','Name':'河北...
记录一次WebService.asmx的实现
qq_31333217的博客
12-05 7939
  本篇文章记录一次调用Service.asmx接口实现的过程，和一些总结的知识。   转载自：http://blog.csdn.net/ckpckp/article/details/71215527   Web Service也叫XML Web Service WebService是一种可以接收从Internet或者Intranet上的其它系统中传递过来的请求，轻量级的独立的通讯技术。是:通...
省市区级联三级联查
QQ_1357581075,百无一用是书生
09-17 826
省市区级联三级联查 jquery-Ajax <script> var Arry = []; $(function () { $("select").prepend('<option value="0">请选择</option>'); Arry = x();//加载省级数据 $("#xdt").change(function () {
基于.netCore 6 +EF 实现webApi增删查改基础应用，开箱即用
05-19
在本文中，我们将深入探讨如何使用`.NET Core 6`框架和`Entity Framework (EF)`来构建一个功能完备的Web API服务，实现数据的增、删、查、改（CRUD）操作。`.NET Core 6`是微软推出的一个高性能、跨平台的开源开发...
详解ASP.NET配置文件Web.config
10-23
主要介绍了ASP.NET配置文件Web.config，Web.config是asp.net应用程序中一个很重要的配置文件，需要的朋友可以参考下
ASP.NET AJAX全国省市县三级联动.doc
04-11
ASP.NET AJAX全国省市县三级联动是一种常见的Web应用程序设计模式，用于在用户选择省份时自动更新城市选项，再根据城市选择更新县（区）选项。这种交互方式提供了良好的用户体验，减少了不必要的页面刷新。以下是对...
获取中国省市县基本信息代码C#版
11-16
数据在data文件夹里边，代码来自github。C#版本的源码，可运行。
web页面实现省份和城市的级联
12-23
web页面实现省份和城市的级联, 免费 可以使用的
ASP.NET AJAX 省市县三级联动 带sql 完整数据库
06-23
AJAX省市县三级联动之XMLHttpRequest XMLHttpRequest.html AJAX(Asynchronous JavaScript And XML，异步JavaScript 和XML)，是2005 年由Google推广开来的一种编程模式。AJAX不是一种新的编程语言，而是一种使用现有标准的新方法，通过基于JavaScript和HTTP请求AJAX，可以创建更好、更快以及更友好的WEB应用程序，他最大的特点就是无刷新，速度快。AJAX的核心就是集成于JavaScript中的XMLHttpRequest对象，他能通过异步的方式与服务器间进行数据交互
.net的省市区县查询
03-16
提供全国各省市区的查询,在一些应用上方便使用.
JS本地实现全国省市区二级、三级地址下拉框联动选择
12-21
全国省市区地址下拉框二级、三级联动选择html例子，JS本地实现，无需网络就能使用，数据为国家省市区6位标准编码，二级联动为省、市的下拉框选择，三级联动为省、市、区的下拉框选择，效果请打开压缩包中的html页面查看。
ionic省市县三级联动
Eric's Blog
11-25 5586
ionic开发移动app过程中地址选择部分涉及省市县三级联动 <!DOCTYPE html> <html ng-app="app"> <head> <meta charset="utf-8"> <title>copyright by leiflyy--leiflyy@outlook.com--</title> <script src="js/ionic.bundle.
ASP.NET省市区级联菜单的3种实现[示例]
07-08
ASP.NET中省、市、区级联菜单的3种(js/jquery/数据库读取)实现方式 【示例代码】
互联网 免费的WebService接口
topMan'blog
07-08 755
股票行情数据 WEB 服务（支持香港、深圳、上海基金、债券和股票；支持多股票同时查询） Endpoint: http://webservice.webxml.com.cn/WebServices/StockInfoWS.asmx 复制 Endpoint Disco: http://webservice.webxml.com.cn/WebServices/StockInfoWS.asmx?dis...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值