下拉框改变并绑定相关信息操作

需要完成功能：

选中客户下拉框，绑定联系人、凉席电话、交货地点三个文本框的值。

 

分析：

1. 先绑定好客户下拉框的值：（事先定义好全局变量 DataTable kh）

//客户      kh = myKh.Window_Loaded_SelectClient().Tables[0];

            cbo_client.ItemsSource = kh.DefaultView;

            cbo_client.DisplayMemberPath = "clientName";

            cbo_client.SelectedValuePath = "clientFileID";

 

1. 再给客户下拉框加一个SelectionChanged 事件：

<TextBlock Grid.Row="1" Grid.Column="1" Text="客   户:" Margin="10,0,0,0" HorizontalAlignment="Stretch" VerticalAlignment="Center"/>

<ComboBox Grid.Row="1" Grid.Column="2" x:Name="cbo_client" Width="162" SelectionChanged="cbo_client_SelectionChanged"/>

 

1. 再到下拉框改变事件中编写相关代码

//客户下拉框改变事件

        private void cbo_client_SelectionChanged(object sender, System.Windows.Controls.SelectionChangedEventArgs e)

        {

            if (Convert.ToInt32(cbo_client.SelectedValue) != 0)

            {

                  txt_address.Text = kh.Rows[0]["area"].ToString();

txt_phone.Text = kh.Rows[0]["cellphone"].ToString();             txt_content.Text = kh.Rows[0]["contact"].ToString();

            }

        }

1. Sql这边的代码如下：

if(@type='Window_Loaded_SelectClient')

begin

SELECT  ROW_NUMBER() over(order by t_clientFile.clientFileID)asxuHao,

t_clientFile.clientFileID, t_provideClient.contact, t_provideClient.phone,

t_provideClient.fax, t_provideClient.zipCode, t_provideClient.address, t_clientFile.clientNumber, t_clientFile.dealNum, t_clientFile.clientName,

t_clientFile.cellphone,t_clientFile.area, t_clientFile.wholesalePrice, t_clientFile.wholesaleDisCount, t_clientFile.bookBuilder_id, t_operators.name, t_clientFile.lockOrNo, t_clientFile.effectiveDay, t_clientFile.updateDay, t_clientFile.mode, t_clientFile.startSum, t_clientFile.jk_Type, t_clientFile.jz_date, t_clientFile.yp_batch, t_clientFile.js_cycle,

t_clientFile.note, t_bankAccount.account

FROM  

     t_clientFile INNER JOIN

t_provideClient ON t_clientFile.provideClientID = t_provideClient.provideClientID INNER JOIN

t_bankAccount ON t_clientFile.bankAccountID = t_bankAccount.bankAccountID INNER JOIN

            t_operators ON t_clientFile.bookBuilder_id = t_operators.operator_id

end

圈圈内的是改变下拉框绑定相关数据的三个文本框的值，下划线的就是绑定客户下拉框的选中值和显示值。