用AJAX做下拉框级联

来源:互联网 发布:ncut算法讲解 编辑:程序博客网 时间:2024/05/06 06:20
 <script language="javascript"type="text/javascript"> 2                         $(document).ready(function () { 3                             var gettime = function () { 4                                 var dt = this.options[this.selectedIndex].value;//获取当前触发Change事件select控件当前选中项的值 5                                 $.get("./FTimeList", { date: dt, time: new Date().getTime() }, function (data) {//将选中值传入,作为查询条件 6                                     var time = data.getElementsByTagName("time");//以<time></time>为标签去子元素,list 7                                     var hl = ""; 8                                     for (var i = 0; i < time.length; i++) { 9                                         hl += "<option value=\"" + time[i].firstChild.data + "\" >" + time[i].firstChild.data + "</option>";10                                         //遍历time赋值给h1(此处做成<option>标签样式)11                                     }12                                     $("#DroTime").html(hl); //赋值给ID为DroTime的dropdownlist实现绑定13                                 });14                             }15                             $("#DroDate").change(gettime);//事件绑定是ID为DroDate的下拉框触发事件,然后将你选中的值传到后台,然后根据这个值查出数据返回绑定                                     给标签为DroTime的下拉框16                             var getdate = function () { //和上面差不多,是下一级的级联选项,如果不需要可以不用17                                 dc = this.options[this.selectedIndex].value;18                                 $.get("./STeaTime", { TID: dc, time: new Date().getTime() }, function (data) {19                                     var date = data.getElementsByTagName("date");20                                     var hl = "";21                                     for (var i = 0; i < date.length; i++) {22                                         hl += "<option>" + date[i].firstChild.data + "</option>";23                                     }24                                     $("#DroDate").html(hl);25                                     gettime;26                                 });27                             }28                             $("#DroTec").change(getdate);29                         });30                     </script> 
      以下是后台Action代码:
 1         public ActionResult FTimeList(string date) 2         { 3             string strr="<?xml version=\"1.0\"?><node>";//加XML文件头 4             if (TeacherID != null) 5             { 6                 var TeacherName = from s4 in wtDB.View_TeacherName 7                                   where s4.TeacherID == TeacherID 8                                   select s4; 9                 if (TeacherName.Count() > 0)10                 {11                    12                     var TeacherTime = from s4 in wtDB.WT_AvailableTime13                                       where s4.CustomerId == TeacherName.First().Id && s4.Date ==Convert.ToDateTime(date)//用户ID14                                       select new { s4.StartTimeId, s4.Date };15                     List<SelectListItem> TimeList = new List<SelectListItem>();// 老师有空时间16                     List<SelectListItem> DateList = new List<SelectListItem>();//日期17                     if (TeacherTime.Count() > 0)18                     {19                         foreach (var time in TeacherTime)20                         {21                             var timeinfo = from s5 in wtDB.WT_Hours22                                            where s5.Id == time.StartTimeId23                                            select s5;//前面的都可以忽略,我功能上要用到的查询语句24                             foreach (var time2 in timeinfo)25                             {26                                 strr += "<time>" + time2.Time + "</time>";//构造返回的数据,以<time>为节点,前台也以<time>为节点取值27                             }28                         29 30                         }31                     }32                 }33             }34             strr += "</node>";//结尾35            36             return Content(strr, "text/xml");37         }
原创粉丝点击