public static void RowNumberGrid(SAPbouiCOM.Grid oGrid) { SAPbouiCOM.RowHeaders oHeader = null; oHeader = oGrid.RowHeaders; for (int i = 0; i <= oGrid.Rows.Count - 1; i++) { oHeader.SetText(i, Convert.ToString(i + 1)); } }
public static void Numero_Fila_Grid(SAPbouiCOM.Grid oGrid) { SAPbouiCOM.RowHeaders oHeader = null; oHeader = oGrid.RowHeaders; if (!oGrid.DataTable.IsEmpty) { for (int i = 0; i <= oGrid.Rows.Count - 1; i++) { oHeader.SetText(i, Convert.ToString(i + 1)); } } }
private void buscarDatos() { String fechaD, fechaH, Ruta, Estado, DocnumDesde, DocnumHasta; try { oForm.Freeze(true); fechaD = ((System.String)((SAPbouiCOM.EditText)oForm.Items.Item("FechaD").Specific).Value); fechaH = ((System.String)((SAPbouiCOM.EditText)oForm.Items.Item("FechaH").Specific).Value); Ruta = ((System.String)((SAPbouiCOM.ComboBox)oForm.Items.Item("tpoRuta").Specific).Value); Estado = ((System.String)((SAPbouiCOM.ComboBox)oForm.Items.Item("tpoEstado").Specific).Value); DocnumDesde = ((System.String)((SAPbouiCOM.EditText)oForm.Items.Item("docDesde").Specific).Value); DocnumHasta = ((System.String)((SAPbouiCOM.EditText)oForm.Items.Item("docHasta").Specific).Value); s = @"SELECT 'N' ""Selec."", T0.""DocNum"" ""N° Documento"" , T0.""U_CorrelativoERP"" ""Pre-Orden"", T0.""U_RUTA"" ""Ruta"", T1.""SlpName"" ""Vendedor"", T0.""DocDueDate"" ""Fecha Despacho"", T0.""CardCode"" ""Código Cliente/Proveedor"", T0.""CardName"" ""Nombre Cliente/Proveedor"", T0.""DocTotal"" ""Total Documento"", T0.""DocEntry"" ""DocEntry"", T12.""StreetS"" ""DirDespacho"", T12.""CityS"" ""Ciudad"", T12.""CountyS"" ""Comuna"", T0.""U_CorrelativoERP"" ""CorrelativoERP"" FROM ""ORDR"" T0 JOIN ""RDR12"" T12 ON T12.""DocEntry"" = T0.""DocEntry"" LEFT JOIN ""OSLP"" T1 ON T0.""SlpCode"" = T1.""SlpCode"" WHERE 1=1 AND T0.""DocDueDate"" BETWEEN '{0}' AND '{1}'"; s = String.Format(s, fechaD, fechaH); if (Ruta != "Todos") { s = s + @"AND T0.""U_RUTA"" = '{0}'"; s = String.Format(s, Ruta); } if (Estado != "T") { s = s + @"AND T0.""DocStatus"" = '{0}'"; s = String.Format(s, Estado); } if (((SAPbouiCOM.CheckBox)oForm.Items.Item("chkImp").Specific).Checked) { s = s + @"AND T0.""Printed"" = '{0}'"; s = String.Format(s, 'N'); } if (DocnumDesde != "" && DocnumHasta != "") { s = s + @"AND T0.""DocNum"" BETWEEN '{0}' AND '{1}'"; s = String.Format(s, DocnumDesde, DocnumHasta); } s = s + @"ORDER BY T0.""DocDueDate"" , T0.""U_RUTA"", T0.""CardCode"" , T0.""DocTotal"" DESC "; //cambio conversado con JC oDataTable.ExecuteQuery(s); oGrid.Columns.Item("Selec.").Type = SAPbouiCOM.BoGridColumnType.gct_CheckBox; var ocheckColumns = (SAPbouiCOM.GridColumn)(oGrid.Columns.Item("Selec.")); var ocheckColumn = (SAPbouiCOM.CheckBoxColumn)(ocheckColumns); ocheckColumn.Editable = true; oGrid.Columns.Item("N° Documento").Type = SAPbouiCOM.BoGridColumnType.gct_EditText; var oColumn = (SAPbouiCOM.GridColumn)(oGrid.Columns.Item("N° Documento")); var oEditColumn = (SAPbouiCOM.EditTextColumn)(oColumn); oEditColumn.Editable = false; oEditColumn.LinkedObjectType = "17"; oGrid.Columns.Item("Pre-Orden").Type = SAPbouiCOM.BoGridColumnType.gct_EditText; oColumn = (SAPbouiCOM.GridColumn)(oGrid.Columns.Item("Pre-Orden")); oEditColumn = (SAPbouiCOM.EditTextColumn)(oColumn); oEditColumn.Editable = false; oGrid.Columns.Item("Ruta").Type = SAPbouiCOM.BoGridColumnType.gct_EditText; oColumn = (SAPbouiCOM.GridColumn)(oGrid.Columns.Item("Ruta")); oEditColumn = (SAPbouiCOM.EditTextColumn)(oColumn); oEditColumn.Editable = false; oGrid.Columns.Item("Vendedor").Type = SAPbouiCOM.BoGridColumnType.gct_EditText; oColumn = (SAPbouiCOM.GridColumn)(oGrid.Columns.Item("Vendedor")); oEditColumn = (SAPbouiCOM.EditTextColumn)(oColumn); oEditColumn.Editable = false; oGrid.Columns.Item("Fecha Despacho").Type = SAPbouiCOM.BoGridColumnType.gct_EditText; oColumn = (SAPbouiCOM.GridColumn)(oGrid.Columns.Item("Fecha Despacho")); oEditColumn = (SAPbouiCOM.EditTextColumn)(oColumn); oEditColumn.Editable = false; oGrid.Columns.Item("Código Cliente/Proveedor").Type = SAPbouiCOM.BoGridColumnType.gct_EditText; oColumn = (SAPbouiCOM.GridColumn)(oGrid.Columns.Item("Código Cliente/Proveedor")); oEditColumn = (SAPbouiCOM.EditTextColumn)(oColumn); oEditColumn.Editable = false; oGrid.Columns.Item("Nombre Cliente/Proveedor").Type = SAPbouiCOM.BoGridColumnType.gct_EditText; oColumn = (SAPbouiCOM.GridColumn)(oGrid.Columns.Item("Nombre Cliente/Proveedor")); oEditColumn = (SAPbouiCOM.EditTextColumn)(oColumn); oEditColumn.Editable = false; oGrid.Columns.Item("Total Documento").Type = SAPbouiCOM.BoGridColumnType.gct_EditText; oColumn = (SAPbouiCOM.GridColumn)(oGrid.Columns.Item("Total Documento")); oEditColumn = (SAPbouiCOM.EditTextColumn)(oColumn); oEditColumn.Editable = false; oGrid.Columns.Item("DocEntry").Type = SAPbouiCOM.BoGridColumnType.gct_EditText; oColumn = (SAPbouiCOM.GridColumn)(oGrid.Columns.Item("DocEntry")); oColumn.Visible = false; oEditColumn = (SAPbouiCOM.EditTextColumn)(oColumn); oEditColumn.Visible = false; oGrid.Columns.Item("DirDespacho").Type = SAPbouiCOM.BoGridColumnType.gct_EditText; oColumn = (SAPbouiCOM.GridColumn)(oGrid.Columns.Item("DirDespacho")); oColumn.Visible = false; oEditColumn = (SAPbouiCOM.EditTextColumn)(oColumn); oEditColumn.Visible = false; oGrid.Columns.Item("Comuna").Type = SAPbouiCOM.BoGridColumnType.gct_EditText; oColumn = (SAPbouiCOM.GridColumn)(oGrid.Columns.Item("Comuna")); oColumn.Visible = false; oEditColumn = (SAPbouiCOM.EditTextColumn)(oColumn); oEditColumn.Visible = false; oGrid.Columns.Item("CorrelativoERP").Type = SAPbouiCOM.BoGridColumnType.gct_EditText; oColumn = (SAPbouiCOM.GridColumn)(oGrid.Columns.Item("CorrelativoERP")); oColumn.Visible = false; oEditColumn = (SAPbouiCOM.EditTextColumn)(oColumn); oEditColumn.Visible = false; oGrid.Columns.Item("Ciudad").Type = SAPbouiCOM.BoGridColumnType.gct_EditText; oColumn = (SAPbouiCOM.GridColumn)(oGrid.Columns.Item("Ciudad")); oColumn.Visible = false; oEditColumn = (SAPbouiCOM.EditTextColumn)(oColumn); oEditColumn.Visible = false; SAPbouiCOM.RowHeaders oHeader = null; for (int i = 0; i <= oGrid.DataTable.Rows.Count - 1; i++) { //Enumera Fila oHeader = oGrid.RowHeaders; oHeader.SetText(i, Convert.ToString(i + 1)); } } catch (Exception e) { Application.SBO_Application.StatusBar.SetText(e.Message + " ** Trace: " + e.StackTrace, SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Error); log.AddLog(e.Message + " ** Trace: "); } finally { oForm.Freeze(false); } }