示例#1
0
        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));
         }
     }
 }
示例#3
0
        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);
            }
        }