[原创]SAP Business One SDK Grid中添加ComboBox CheckBox(Demo)

      ComboBoxColumn Object
Description
This object represents a column with a combo box.
Available from Columns.Item when the column type is gct_ComboBox.

      CheckBoxColumn Object
Description
This object represents a column with a check box.
Available from Columns.Item when the column type is gct_CheckBox.

     Grid Class
1.只能利用SQL Query对列Columns操作，不能象Matrix那样可以oColumns.Add("A1", SAPbouiCOM.BoFormItemTypes.it_EDIT);
2.ComboBoxColumn只能识别字符串string类型的值。CheckBoxColumn 空值。

以下为部分代码.

    //   Set the grid data
        oGrid  =  ( ( SAPbouiCOM.Grid )( oItem.Specific ) ); 
        
        oForm.DataSources.DataTables.Add(  " MyDataTable "  );
        oForm.DataSources.DataTables.Item( 0 ).ExecuteQuery( " select DocNum, CardName,docentry,'' as YorN from OINV where docstatus='O' order by docnum " ); 
        oGrid.DataTable  =  oForm.DataSources.DataTables.Item(  " MyDataTable "  );  // 对Grid绑定数据源
        
  

         // Set columns size
        oGridColumn  =  (SAPbouiCOM.GridColumn)(oGrid.Columns.Item( 1 ));
        oGridColumn.Type  =  SAPbouiCOM.BoGridColumnType.gct_ComboBox; // 转换成ComboBoxColumn
        oComboBoxColumn  =  (SAPbouiCOM.ComboBoxColumn)(oGrid.Columns.Item( 1 ));
        oComboBoxColumn.ValidValues.Add( " 1 " ,  " One " );
        oComboBoxColumn.ValidValues.Add( " 2 " ,  " Two " );
        oComboBoxColumn.ValidValues.Add( " 3 " ,  " Three " );

        oGridColumn  =  (SAPbouiCOM.GridColumn)(oGrid.Columns.Item( 3 ));
        oGridColumn.Type  =  SAPbouiCOM.BoGridColumnType.gct_CheckBox; // 转换成CheckBoxColumn
       
        oGrid.Columns.Item( 1 ).Width  =   150 ;
        oGrid.Columns.Item( 1 ).Editable  =   true ;
        oGrid.Columns.Item( 2 ).Width  =   30 ;
        oGrid.Columns.Item( 2 ).Editable  =   true ;
        oGrid.Columns.Item( 3 ).Width  =   50 ;
        oGrid.Columns.Item( 3 ).Editable  =   true ;


        oGrid.CollapseLevel  =   1 ;
        oGrid.AutoResizeColumns();
        oForm.Freeze( false );       

Project 下载

转载于:https://www.cnblogs.com/el-net/articles/1049368.html