on 01-29-2020 7:46 PM
Buenas tardes,
Estoy tratando de realizar un AddOn dentro y quería saber si es que alguien me podría ayudar a agregar una columna de checkbox en un grid simple.
He tratado de buscar ayuda en la documentación del SDK pero no he podido.
Hi,
Here is an example:
The grid is being filled with a query result and one of the Grid column is being set to Checkbox type:
string Sql = "Select SelectRow as 'Select', ItemCode as 'Item Code', ItemName as 'Item Name', Qty as 'Qty.', DocRef , LineID , ProjectDescription as 'Project Details', Project From [@TEMPTABLEFORMATERIALREQUEST] Where UserLogin = '" + SBO_Company.UserName + "'";
this.m_SBO_Form.DataSources.DataTables.Add("MYDATATABLE");
this.m_SBO_Form.DataSources.DataTables.Item(0).Clear();
this.m_SBO_Form.DataSources.DataTables.Item(0).ExecuteQuery(Sql);
SAPbouiCOM.Grid oGrid = (Grid)this.m_SBO_Form.Items.Item(enControlName.Grid).Specific;
oGrid.DataTable = this.m_SBO_Form.DataSources.DataTables.Item("MYDATATABLE");
SAPbouiCOM.EditTextColumn oEditColumn;
oEditColumn = ((SAPbouiCOM.EditTextColumn)(oGrid.Columns.Item("DocRef")));
oEditColumn.Visible = false;
oEditColumn = ((SAPbouiCOM.EditTextColumn)(oGrid.Columns.Item("LineID")));
oEditColumn.Visible = false;
oEditColumn = ((SAPbouiCOM.EditTextColumn)(oGrid.Columns.Item("Select")));
oEditColumn.Type = BoGridColumnType.gct_CheckBox;
oEditColumn = ((SAPbouiCOM.EditTextColumn)(oGrid.Columns.Item("Item Code")));
oEditColumn.Editable = false;
oEditColumn = ((SAPbouiCOM.EditTextColumn)(oGrid.Columns.Item("Item Name")));
oEditColumn.Editable = false;
oEditColumn = ((SAPbouiCOM.EditTextColumn)(oGrid.Columns.Item("Qty.")));
oEditColumn.Editable = false;
oEditColumn = ((SAPbouiCOM.EditTextColumn)(oGrid.Columns.Item("Project Details")));
oEditColumn.Editable = false;
oEditColumn = ((SAPbouiCOM.EditTextColumn)(oGrid.Columns.Item("Project")));
oEditColumn.Visible = false;
oGrid.AutoResizeColumns();
oEditColumn = ((SAPbouiCOM.EditTextColumn)(oGrid.Columns.Item("Item Code")));
oEditColumn.LinkedObjectType = "4";
Hope it helps!
Kind regards,
ANKIT CHAUHAN
SAP Business One Support
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.