• .net Ajax与后台一般处理程序(ashx) 交互


        本文主要实现无动态刷新查询后台数据功能,主要用到ajax+ashx+sqlserver进行交互.

    首先需要引用Jquery:

     <script language="javascript" type="text/javascript" src="../js/jquery.js">

    html脚本:

    <asp:TextBox ID="tb_corpName" runat="server" MaxLength="100" Width="369px"></asp:TextBox>

    前台通过一个事件来调用ashx:

    <script type="text/javascript">
        $(function () {
            $("#tb_corpName").blur(function () {           //鼠标失去焦点事件
                var corpName = $("#tb_corpName").val();     
                $.ajax({        
                    type: "post",                           //提交方式     
                    url: "/ashx/FZGpyShowData.ashx",        //一般处理程序的路径
                    data: { corpName: corpName },           //向后台传入的值
                    dataType: "json",                       //返回值格式
                    success: function (data) {              //返回成功后将要做的事,这里是返回一个表
                        $("#tb_CreditCode").val(data[0].CreditCode);    
                        $("#tb_corpCode").val(data[0].CorpCode);
                        $("#tb_linkTel").val(data[0].LinkPhone);
    
                        $("#corpProvince option[text='" + data[0].StateName + "']").attr("selected", true);
                        showCity();
                        $("#corpCity option[text='" + data[0].AdminAreaName + "']").attr("selected", true); 
    
                        $("#tb_address").val(data[0].Address);
                        $("#tb_linkMan").val(data[0].LinkMan);
                        $("#tb_Mobile").val(data[0].LinkMobile);
                    }
                });
            })
        })
    </script>

    后台来接收前台传过来的值,对其进行操作:

         public void ProcessRequest(HttpContext context)
            {
                context.Response.ContentType = "text/plain";
                string corpName = context.Request["corpName"].Trim().ToString();      //接收前台传过来的参数
                if (corpName != "")
                {
                    string sql = @"select top 1 CorpName,CreditCode,CorpCode,LinkPhone,StateName,AdminAreaName,LinkMan,LinkMobile,Address from tbProductOrder as a 
                                            inner join tbStateDic as b on a.StateNum = b.StateNum
                                            inner join tbAdminAreaClass on a.CityNum = AdminAreaClassID
                                            where CorpName =@CorpName order by CorpName";
                    SqlParameter[] par = new SqlParameter[1];
                    par[0] = new SqlParameter("@CorpName", corpName);
                    DataSet ds = DBHerpler.Load(sql, par); 
                    string json = SerializerHelper.ToJsonString(ds.Tables[0]);    //返回json类型的数据
                    context.Response.Write(json);                      
                    context.Response.End(); 
                } 
            }

    SerializerHelper类的定义:

    using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Web;
    using System.Text;
    using System.IO;
    using System.Xml.Serialization;
    using Newtonsoft.Json;
    
    /// <summary>
    /// SerializerHelper 的摘要说明
    /// </summary>
    public static class SerializerHelper
    {
        /// <summary>
        /// 反序列化XML文件
        /// </summary>
        public static T LoadFromXmlFile<T>(string filepath) where T : class
        {
            using (FileStream stream = new FileStream(filepath, FileMode.Open, FileAccess.Read))
            {
                XmlSerializer serializer = new XmlSerializer(typeof(T));
                return (T)serializer.Deserialize(stream);
            }
        }
    
        /// <summary>
        /// 反序列化XML字符串
        /// </summary>
        public static T LoadFromXmlString<T>(string xml) where T : class
        {
            XmlSerializer serializer = new XmlSerializer(typeof(T));
            byte[] bytes = Encoding.UTF8.GetBytes(xml);
    
            using (MemoryStream stream = new MemoryStream(bytes))
            {
                return (T)serializer.Deserialize(stream);
            }
        }
    
        /// <summary>
        /// 序列化XML对象
        /// </summary>
        public static string SaveToXmlString<T>(T entity) where T : class
        {
            using (MemoryStream stream = new MemoryStream())
            {
                XmlSerializer serializer = new XmlSerializer(typeof(T));
                serializer.Serialize(stream, entity);
                return Encoding.UTF8.GetString(stream.ToArray());
            }
        }
    
        /// <summary>
        /// 序列化Json对象
        /// </summary>
        public static string ToJsonString(object obj)
        {
            return ToJsonString<object>(obj);
        }
    
        /// <summary>
        /// 序列化Json对象
        /// </summary>
        public static string ToJsonString<T>(T obj) where T : class
        {
            string text = JsonConvert.SerializeObject(obj);
            return text;
        }
    
        /// <summary>
        /// 反序列化Json字符串
        /// </summary>
        public static T ToJsonObject<T>(string text) where T : class
        {
            T obj = (T)JsonConvert.DeserializeObject(text, typeof(T));
            return obj;
        }
    }

    如果向后台传入多个参数在data里面用逗号分割可写多个参数:

        data: { corpName: corpName , corpName2: corpName2} 

  • 相关阅读:
    System.Windows.Forms.Timer与System.Timers.Timer的区别(zz)
    30个最常用css选择器解析(zz)
    Highcharts选项配置详细说明文档(zz)
    CSS For Bar Graphs(maybe old)
    学习CSS3BUTTON(二)
    学习CSS3BUTTON(一)
    CSS CURSOR属性
    CSS3的文字阴影—text-shadow
    display:inline-block; 到底是个啥玩意?
    mysql 子查询
  • 原文地址:https://www.cnblogs.com/swjian/p/6855863.html
Copyright © 2020-2023  润新知