当前位置：首页 > news >正文

ASPxGridView中使用PopupEditForm表单字段联动填充

news 2025/9/14 0:13:28

c#中devexpress的控件ASPxGridView中使用PopupEditForm表单字段联动填充

//选择项目名称，自动填充项目编号
<Columns><dx:GridViewDataTextColumn FieldName="id" ReadOnly="True" VisibleIndex="0" Visible="False" ShowInCustomizationForm="True"><EditFormSettings Visible="False"  Caption="编辑"/></dx:GridViewDataTextColumn><dx:GridViewDataComboBoxColumn FieldName="number" VisibleIndex="1" Caption="项目编号" ShowInCustomizationForm="True" Width="100px"><PropertiesComboBox DataSourceID="SqlDataSource5" ValueField="name" DropDownStyle="DropDown" EnableSynchronization="False"IncrementalFilteringMode="StartsWith" TextField="name" ValueType="System.String" NullText="选择编号" ClientInstanceName="from_project_name">                         </PropertiesComboBox>   </dx:GridViewDataComboBoxColumn><dx:GridViewDataComboBoxColumn  FieldName="name" VisibleIndex="2" Caption="项目名称" ShowInCustomizationForm="True" Width="250px"><PropertiesComboBox DataSourceID="SqlDataSource5" ValueField="all_info" DropDownStyle="DropDown" EnableSynchronization="False"IncrementalFilteringMode="StartsWith" TextField="all_info" ValueType="System.String" NullText="选择项目" ClientInstanceName="project_name">                   <ClientSideEvents SelectedIndexChanged="function(s, e) { OnProTypeChanged(s); }"></ClientSideEvents>               </PropertiesComboBox>   </dx:GridViewDataComboBoxColumn>
...可使用两个不同的数据源绑定
SQL的其中一个字段把多个字段拼接到一起，用#隔开，名字为all_info<asp:SqlDataSource ID="SqlDataSource5" runat="server" ConnectionString="<%$ ConnectionStrings:MyConnectionString %>"ProviderName="<%$ ConnectionStrings:MyConnectionString.ProviderName %>"SelectCommand="select  name,project_name,customer_name,name||'#'||project_name||'#'||customer_name as all_info from fnt_fm1212_fnt_project">
</asp:SqlDataSource>//JS代码如下
<script type="text/javascript">function OnProTypeChanged(s) {var array= s.stateObject.rawValue.split("#");// 根据项目名称获取项目编号// var projectNumber = GetProjectNumber(s.stateObject.rawValue);console.log(array[1]);// 更新项目编号文本框的值project_name.SetValue(array[1]);from_project_name.SetValue(array[0]);}
</script>

查看全文

http://www.lryc.cn/news/306180.html