Jquery+json绑定带层次下拉框(select控件)-创新互联

一、实现的效果图

创新互联服务项目包括鄂城网站建设、鄂城网站制作、鄂城网页制作以及鄂城网络营销策划等。多年来,我们专注于互联网行业,利用自身积累的技术优势、行业经验、深度合作伙伴关系等,向广大中小型企业、政府机构等提供互联网行业的解决方案,鄂城网站推广取得了明显的社会效益与经济效益。目前,我们服务的客户以成都为中心已经辐射到鄂城省份的部分城市,未来相信会继续扩大服务区域并继续获得客户的支持与信任!

备注:

1、主要实现添加类别绑定到Ztree树之后,select下拉框在不刷新页面的情况下,通过Jquery重新绑定问题,增加用户体验度;

2、这个只是实现两层的绑定,通过sql语句排列成树状结构,然后绑定到select控件上;

select * from NewsCategoryorder by case when ParentId=0 then Id*10000 else ParentId*10000+Id end

二、主要代码

html代码

     不选父级类  

Jquery代码

               //加载选择栏 var html = [''];
var data = eval(json.msg);//转换为json对象 var levelStr;//记录层级值 for (var key in data) {
var str = data[key].itemvalue;
var _p = str.split("|")[2];
var _c = data[key].pId;
//判断是否是二级分类  if (_p == _c) {
//判断是否是一级分类   if (_p != "") {
                                    levelStr= "┗━┻━";
                                }
else {
                                    levelStr= "┗━";
                                }
                                html.push('');
                            }
                            $("select[name='pid']").empty().append(html.join(''));

json格式字符串

"[
{"id":31,"name":"u65b0u95fbu4e2du5fc3","pid":0,"itemvalue":"|0|"},
{"id":51,"name":"u4f01u4e1au5febu8baf","pid":31,"itemvalue":"|0|31|"},
{"id":52,"name":"u4f01u4e1au516cu544a","pid":31,"itemvalue":"|0|31|"},
{"id":53,"name":"u884cu4e1au52a8u6001","pid":31,"itemvalue":"|0|31|"},
{"id":54,"name":"u5173u4e8eu76dfu53cbu634cu634c","pid":0,"itemvalue":"|0|"}, {"id":55,"name":"u4f01u4e1au6982u51b5","pid":54,"itemvalue":"|0|54|"}, {"id":56,"name":"u4f01u4e1au6587u5316","pid":54,"itemvalue":"|0|54|"}, {"id":57,"name":"u4f01u4e1au53d1u5c55","pid":54,"itemvalue":"|0|54|"}, {"id":58,"name":"u8054u7cfbu6211u4eec","pid":54,"itemvalue":"|0|54|"}, {"id":65,"name":"u4ea7u54c1u670du52a1","pid":0,"itemvalue":"|0|"}, {"id":70,"name":"u63a8u8350u670du52a1","pid":65,"itemvalue":"|0|65|"}, {"id":71,"name":"u8ba1u8d39u65b9u5f0f","pid":65,"itemvalue":"|0|65|"}, {"id":72,"name":"u7528u6237u987bu77e5","pid":65,"itemvalue":"|0|65|"}, {"id":73,"name":"u7981u5bc4u8303u56f4","pid":65,"itemvalue":"|0|65|"}, {"id":75,"name":"u666eu901au5febu9012","pid":70,"itemvalue":"|0|65|70|"}, {"id":76,"name":"u7279u79cdu5febu4ef6","pid":70,"itemvalue":"|0|65|70|"} ...... ]"

 涉及的知识点:

1、记录层级值ItemValue的添加(即类别添加)

     if (model.ParentId == 0)
        {
            model.ItemValue= "|0|";
        }
else
        {            
            Express.Model.NewsCategory modelid= Express.BLL.NewsCategory.GetModel(model.ParentId);
            model.ItemValue= modelid.ItemValue + model.ParentId + "|";
        }

2、获取的json字符串(json.msg)

    if (Express.BLL.NewsCategory.Insert(model) > 0)
       {
return json.Serialize(new { code = 1, msg= GetJson() });
       }
  //序列化,将对象转化为JSON字符串  protected string GetJson()    {
//为启用 AFAX 的应用程序提供序列化和反序列化功能        System.Web.Script.Serialization.JavaScriptSerializer json = new System.Web.Script.Serialization.JavaScriptSerializer();
        List list = new List();
//获取管理员模块列表        list = Express.BLL.NewsCategory.Get();
//将对象转换为JSON字符串   return json.Serialize(list);       
    }

标题名称:Jquery+json绑定带层次下拉框(select控件)-创新互联
浏览路径:http://scyanting.com/article/dcecos.html