DX:ASPxGridView中EditForm模板中实现省、市、区三级联动的方法

DX:ASPxGridView中EditForm模板中实现省、市、区三级联动的方法

2019-11-05 17:08:07 864记忆 阅读数 4更多

一、首先在前端创建ASPxGridView列：
<主要代码如下>

            <dx:GridViewDataComboBoxColumn FieldName="省" VisibleIndex="5">
            <PropertiesComboBox TextField="ProvinceName" ValueField="ProvinceName" EnableSynchronization="false" DataSecurityMode="Strict"  IncrementalFilteringMode="StartsWith" DataSourceID="SqlDataSource1">
                <ClientSideEvents SelectedIndexChanged="function(s, e) { OnShengChanged(s); }" />
            </PropertiesComboBox>
            </dx:GridViewDataComboBoxColumn>
            <dx:GridViewDataComboBoxColumn FieldName="市" VisibleIndex="6">
            <PropertiesComboBox TextField="CityName" ValueField="CityName" EnableSynchronization="false" DataSecurityMode="Strict" IncrementalFilteringMode="StartsWith" DataSourceID="SqlDataSource2">
                <ClientSideEvents SelectedIndexChanged="function(s, e) { OnShiChanged(s); }" />
            </PropertiesComboBox>
            </dx:GridViewDataComboBoxColumn>
            <dx:GridViewDataComboBoxColumn FieldName="区" VisibleIndex="7">
            <PropertiesComboBox TextField="DistrictName" ValueField="DistrictName" EnableSynchronization="false" DataSecurityMode="Strict" IncrementalFilteringMode="StartsWith" DataSourceID="SqlDataSource3" >
                <ClientSideEvents EndCallback="OnEndCallback" />
            </PropertiesComboBox>
            </dx:GridViewDataComboBoxColumn>

这里的省市区三列均为comboBox控件，可以在设计器中实现，也可前端代码实现。
二、为各控件设置数据源：
创建三个sqlDataSource数据源控件，分别为：sqlDataSource1、sqlDataSource2、sqlDataSource3
三、为各控件设置客户端事件：
省：SelectedIndexChanged事件
市：SelectedIndexChanged事件
区：EndCallback事件
四、前端各事件代码：

        var lastsheng = null;
        function OnShengChanged(cmbSheng) {
            if (ASPxGridView1.GetEditor("市").InCallback())
                lastSheng = cmbSheng.GetValue().toString();
            else
                ASPxGridView1.GetEditor("市").PerformCallback(cmbSheng.GetValue().toString());
                ASPxGridView1.GetEditor("区").PerformCallback("");//此处为省改变时，要清空市、区的值
        }

        var lastshi = null;
        function OnShiChanged(cmbShi) {
            
            if (ASPxGridView1.GetEditor("区").InCallback())
                lastShi = cmbShi.GetValue().toString();
            else
                ASPxGridView1.GetEditor("区").PerformCallback(cmbShi.GetValue().toString());
        }

       
        function OnEndCallback(s, e) {
            if (lastshi) {
                ASPxGridView1.GetEditor("区").PerformCallback(lastshi);
                lastshi = null;
            }
        }

五、后台事件及方法：

    /// <summary>
    /// EditForm的单元格编辑初始化事件
    /// </summary>
    /// <param name="sender">EditForm</param>
    /// <param name="e">是指EditForm中的控件</param>
    protected void ASPxGridView1_CellEditorInitialize(object sender, ASPxGridViewEditorEventArgs e)
    {
        if (!ASPxGridView1.IsEditing || (e.Column.FieldName != "市" && e.Column.FieldName != "区"))
        {
            return;
        }
        if (e.KeyValue == DBNull.Value || e.KeyValue == null)
        {
            return;
        }
        if (e.Column.FieldName == "市")
        {
            object val = ASPxGridView1.GetRowValuesByKeyValue(e.KeyValue, "省");//根据本行主键值获取本行中的省列位值
            if (val == DBNull.Value) return;
            string sheng = (string)val;//省名

            ASPxComboBox combo = e.Editor as ASPxComboBox;//市combobox下拉框对象
            FillCityCombo(combo, sheng);//填充市下拉框对象

            combo.Callback += new CallbackEventHandlerBase(cmbCity_OnCallback);
        }
        if (e.Column.FieldName == "区")
        {
            object val = ASPxGridView1.GetRowValuesByKeyValue(e.KeyValue, "市");//根据本行主键值获取本行中的市列位值
            if (val == DBNull.Value) return;
            string shi = (string)val;//市名

            ASPxComboBox combo2 = e.Editor as ASPxComboBox;//市combobox下拉框对象
            FillDistrictCombo(combo2, shi);//填充市下拉框对象

            combo2.Callback += new CallbackEventHandlerBase(cmbDistrict_OnCallback);
        }

    }


    //市绑定下拉项
    /// <summary>
    /// 根据省名获取市以填充市下拉框
    /// </summary>
    /// <param name="cmb"></param>
    /// <param name="sheng"></param>
    protected void FillCityCombo(ASPxComboBox cmb, string sheng)
    {
        if (string.IsNullOrEmpty(sheng)) return;

        List<string> cities = GetCities(sheng);
        cmb.Items.Clear();
        foreach (string city in cities)
            cmb.Items.Add(city);
    }

    /// <summary>
    /// 获取省下面的市
    /// </summary>
    /// <param name="sheng"></param>
    /// <returns></returns>
    List<string> GetCities(string sheng)
    {
        List<string> ls = new List<string> { };
        object osheng_bh=SqlHelper.ExecuteScalar("select ProvinceID from S_Province where ProvinceName='" + sheng + "'", new SqlParameter[] { });
        if (osheng_bh != null)
        {
            string sheng_bh = Convert.ToString(osheng_bh);
            DataTable shi_dt = SqlHelper.ExecuteDataTable("select CityName from S_City where ProvinceID=" + sheng_bh, new SqlParameter[] { });
            
            foreach (DataRow dr in shi_dt.Rows)
            {
                ls.Add(dr["CityName"].ToString());
            }
        }
        
        return ls;
    }

    void cmbCity_OnCallback(object source, CallbackEventArgsBase e)
    {
        FillCityCombo(source as ASPxComboBox, e.Parameter);
    }




    //区绑定下拉项
    /// <summary>
    /// 根据市名称获取市下面的区以填充区下拉框
    /// </summary>
    /// <param name="cmb"></param>
    /// <param name="shi"></param>
    protected void FillDistrictCombo(ASPxComboBox cmb, string shi)
    {
        if (string.IsNullOrEmpty(shi))
        {
            cmb.Items.Clear();
            return;
        }
        List<string> Districts = GetDistricts(shi);
        cmb.Items.Clear();
        if (Districts != null)
        {
            foreach (string District in Districts)
                cmb.Items.Add(District);
        }
    }
    /// <summary>
    /// 获取市下面的区
    /// </summary>
    /// <param name="shi"></param>
    /// <returns></returns>
    List<string> GetDistricts(string shi)
    {
        List<string> ls = new List<string> { };
        object oshi_bh = SqlHelper.ExecuteScalar("select CityID from S_City where CityName='" + shi + "'", new SqlParameter[] { });
        if (oshi_bh != null)
        {
            string shi_bh = Convert.ToString(oshi_bh);
            DataTable District_dt = SqlHelper.ExecuteDataTable("select DistrictName from S_District where CityID=" + shi_bh, new SqlParameter[] { });
            
            foreach (DataRow dr in District_dt.Rows)
            {
                ls.Add(dr["DistrictName"].ToString());
            }
        }
        return ls;
    }
    /// <summary>
    /// 区回调函数
    /// </summary>
    /// <param name="source"></param>
    /// <param name="e"></param>
    void cmbDistrict_OnCallback(object source, CallbackEventArgsBase e)
    {
        FillDistrictCombo(source as ASPxComboBox, e.Parameter);
    }

至此省、市、区三级联动实现。