ext.form.combobox的联动

新手，废了蛮多时间才把ext.form.combobox的联动做出来了，与大家分享，希望可以帮到大家。

效果图：

先上代码：JS文件

///<reference path="vswd-ext_2.0.2.js" />
Ext.onReady(function () {
    Ext.define("comboboxdata1", {
        extend: "Ext.data.Model",
        fields: [
             "tbname", "tbdesc"
        ]
    });
    var store1 = Ext.create("Ext.data.Store", {
        storeId: "store1",
        model: "comboboxdata1",
        proxy: {
            type: "ajax",
            url: "ComboData.ashx",
            reader: {
                type: "json",
                root: "root"
            }
        }
    });
    Ext.define("comboboxdata2", {
        extend: "Ext.data.Model",
        fields: [
             "listname", "listdesc", "tbname"
        ]
    });
    var store2 = Ext.create("Ext.data.Store", {
        storeId: "store2",
        model: "comboboxdata2",
        proxy: {
            type: "ajax",
            url: "ComboData1.ashx",
            reader: {
                type: "json",
                root: "combo2root"
            }
        }
    });
    store2.load();
    var store3 = Ext.create("Ext.data.Store", {
        fields: [
             "listname", "listdesc", "tbname"
        ]
    });
    var combo1 = Ext.create("Ext.form.ComboBox", {
        id: "c1",
        valueField: "tbname",
        fieldLabel: "选择条件",
        store: store1,
        displayField: "tbdesc",
        listeners: {
            change: function (f, n, o) {

                store3.removeAll();
                combo2 = Ext.getCmp("c2");
                combo2.reset();
                combo3 = Ext.getCmp("c3");
                combo3.reset();
                store2.each(function (record) {
                   //过滤表列名

                    if (record.get('tbname') == n) {
                        store3.add(record);
                    };
                });
            }
        }
    });

    var combo2 = Ext.create("Ext.form.ComboBox", {
        id: "c2",
        store: store3,
        queryMode: 'local',
        valueField: "listname",
        displayField: "listdesc"
    });

    var combo3 = Ext.create("Ext.form.ComboBox", {
        id: "c3",
        store: store3,
        queryMode: 'local',
        valueField: "listname",
        displayField: "listdesc"
    });
    var selectbut = Ext.create('Ext.Button', {
        text: '搜索',
        handler: function () {
            var listname2 = Ext.getCmp('c2').getValue();
            var listname3 = Ext.getCmp('c3').getValue();
            //排除为null时，赋值为""  
            if (!listname2) {
                sexCode = "";
            }
            if (!listname3) {
                nameCode = "";
            }
            alert("listname2:" + listname2 + "\nlistname3:" + listname3);
        }
    });
    var tb = Ext.create("Ext.toolbar.Toolbar",
        { renderTo: "combo1", items: [
        combo1, combo2,combo3,selectbut]
        });
});

后台读出来的数据

Store1的数据：

{root:[{"tbname":"vw_ccx","tbdesc":"员工信息表"},{"tbname":"itemTurnoverMsg","tbdesc":"员工物品进出表"},{"tbname":"message_2D","tbdesc":"员工物品登记表"}]}

 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Configuration;
using System.Text;
using System.Web.Script.Serialization;
using System.Data.SqlClient;


namespace extjstest_CShape
{
    /// <summary>
    /// ComboData 的摘要说明
    /// </summary>
    public class ComboData : IHttpHandler
    {
        public void ProcessRequest(HttpContext context)
        {


            context.Response.ContentType = "text/javascript";
            string connstr = ConfigurationManager.ConnectionStrings["ItemManageSystemConnectionString2"].ConnectionString;
            SqlConnection conn = new SqlConnection(connstr);
            conn.Open();
            string sqlstr = "select * from listdescription";
            SqlCommand cmd = new SqlCommand(sqlstr, conn);
            SqlDataReader sdr = cmd.ExecuteReader();
            
            context.Response.Write(GetJSON(conn,sdr, "T_Ware"));
        }
        protected string GetJSON(SqlConnection conn,SqlDataReader drValue, string strTableName)
        {
            
            List<tablename> tbdescs = new List<tablename>();
            tablename tbdesc1 = new tablename();
            tablename tbdesc2 = new tablename(); 
            tablename tbdesc3 = new tablename();
            int tbdesccount1 = 0;
            int tbdesccount2 = 0;
            int tbdesccount3 = 0;
            try
            {
                
                while (drValue.Read())
                {
                    #region
                    if (drValue["tbname"].ToString().Trim() == "vw_ccx") 
                    {
                        if (tbdesccount1 == 0) 
                        { 
                            tbdesccount1++;
                            tbdesc1.tbdesc = "员工信息表";
                            tbdesc1.tbname = drValue["tbname"].ToString().Trim();
                        }
                    }
                    if (drValue["tbname"].ToString().Trim() == "itemTurnoverMsg")
                    {
                        if (tbdesccount2 == 0)
                        {
                            tbdesccount2++;
                            tbdesc2.tbdesc = "员工物品进出表";
                            tbdesc2.tbname = drValue["tbname"].ToString().Trim();
                        }
                    }
                    if (drValue["tbname"].ToString().Trim() == "message_2D")
                    {
                        if (tbdesccount3 == 0)
                        {
                            tbdesccount3++;
                            tbdesc3.tbdesc = "员工物品登记表";
                            tbdesc3.tbname = drValue["tbname"].ToString().Trim();
                        }
                    }
                    #endregion
                }
                tbdescs.Add(tbdesc1);
                tbdescs.Add(tbdesc2);
                tbdescs.Add(tbdesc3);
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
            finally
            {
                drValue.Close();
                conn.Close();
            }


            JavaScriptSerializer jsSerializer = new JavaScriptSerializer();
            StringBuilder sb = new StringBuilder("{");
            sb.Append("root:");
            sb.Append(jsSerializer.Serialize(tbdescs));
            sb.Append("}");
            return sb.ToString();
        } 


        public bool IsReusable
        {
            get
            {
                return false;
            }
        }
    }
}

Store2的数据：

{combo2root:[{"listname":"nothing","listdesc":"","tbname":"vw_ccx"},{"listname":"department","listdesc":"部门","tbname":"vw_ccx"},{"listname":"dorm_number","listdesc":"宿舍号","tbname":"vw_ccx"},{"listname":"emp_name","listdesc":"员工姓名","tbname":"vw_ccx"},{"listname":"card_number","listdesc":"员工厂牌号","tbname":"vw_ccx"},{"listname":"sex","listdesc":"性别","tbname":"vw_ccx"},{"listname":"in_date","listdesc":"入住时间","tbname":"vw_ccx"},{"listname":"area","listdesc":"宿舍区号","tbname":"vw_ccx"},{"listname":"nothing","listdesc":"","tbname":"message_2D"},{"listname":"dorm_number","listdesc":"宿舍号","tbname":"message_2D"},{"listname":"emp_name","listdesc":"员工姓名","tbname":"message_2D"},{"listname":"makeperson","listdesc":"制码人","tbname":"message_2D"},{"listname":"makedate","listdesc":"制码时间","tbname":"message_2D"},{"listname":"card_number","listdesc":"员工厂牌号","tbname":"message_2D"},{"listname":"sex","listdesc":"性别","tbname":"message_2D"},{"listname":"in_date","listdesc":"入住时间","tbname":"message_2D"},{"listname":"area","listdesc":"宿舍区号","tbname":"message_2D"},{"listname":"number2D","listdesc":"二维码编码","tbname":"message_2D"},{"listname":"nothing","listdesc":"","tbname":"itemTurnoverMsg"},{"listname":"number2D","listdesc":"二维码编码","tbname":"itemTurnoverMsg"},{"listname":"card_number","listdesc":"员工厂牌号","tbname":"itemTurnoverMsg"},{"listname":"emp_name","listdesc":"员工姓名","tbname":"itemTurnoverMsg"},{"listname":"dorm_number","listdesc":"宿舍号","tbname":"itemTurnoverMsg"},{"listname":"item_in","listdesc":"物品进区时间","tbname":"itemTurnoverMsg"},{"listname":"item_out","listdesc":"物品出区时间","tbname":"itemTurnoverMsg"},{"listname":"register_emp","listdesc":"登记人员姓名","tbname":"itemTurnoverMsg"},{"listname":"register_card","listdesc":"登记人员厂牌号","tbname":"itemTurnoverMsg"}]}

后台语句：

经验总结：要注意store是什么时候加载的，如果把store2放到combo1 去加载，那就过滤不了了（我自己试的时候是这样的）
还有为什么要用store3来存放combo2和combo3的数据那是在这为学者那得到的提示！点击打开链接

如果大家有什么更好的方法请指导下我哦，谢谢。