コード例 #1
0
        private void desenharCampos()
        {
            oItem = oForm.Items.Item("7");

            oNewItem          = oForm.Items.Add("Ver_Amb", SAPbouiCOM.BoFormItemTypes.it_MATRIX);
            oNewItem.Left     = 25;
            oNewItem.Width    = 880;
            oNewItem.Top      = oItem.Top + 205;
            oNewItem.Height   = 120;
            oNewItem.FromPane = 11;
            oNewItem.ToPane   = 11;

            oMatrix  = ((SAPbouiCOM.Matrix)(oNewItem.Specific));
            oColumns = oMatrix.Columns;

            oColumn = oColumns.Add("Ver_#", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "#";
            oColumn.Width    = 30;
            oColumn.Editable = false;

            oColumn = oColumns.Add("Ver_Amb_C0", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Ambiente";
            oColumn.Width    = 80;
            oColumn.Editable = false;

            oColumn = oColumns.Add("Ver_Amb_C1", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Data Verificação";
            oColumn.Width    = 80;
            oColumn.Editable = true;

            /*oColumn = oColumns.Add("Ver_Amb_C2", SAPbouiCOM.BoFormItemTypes.it_COMBO_BOX);
             * oColumn.TitleObject.Caption = "Verificado por";
             * oColumn.Width = 100;
             * oColumn.Editable = true;
             * oColumn.DataBind.SetBound(true, "OPR4", "U_FLX_FB_ENT_PENDENC");*/

            oColumn = oColumns.Add("Ver_Amb_C2", SAPbouiCOM.BoFormItemTypes.it_COMBO_BOX);
            oColumn.TitleObject.Caption = "Verificado por";
            oColumn.Width    = 100;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Ver_Amb_C3", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Observações";
            oColumn.Width    = 470;
            oColumn.Editable = true;

            oForm.DataSources.DataTables.Item("oMatrixDT").ExecuteQuery("SELECT T1.[Num], T1.[Descript], T0.* FROM OPR4 T0 INNER JOIN OOIN T1 ON T1.Num = T0.IntId WHERE T0.[OprId] = '1'");

            oColumn = oColumns.Item("Ver_Amb_C0");
            oColumn.DataBind.Bind("oMatrixDT", "Descript");

            oColumn = oColumns.Item("Ver_Amb_C1");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_VRF_DATEVER");

            oColumn = oColumns.Item("Ver_Amb_C2");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_VRF_VERIFPO");

            oColumn = oColumns.Item("Ver_Amb_C3");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_VRF_OBS");
        }
コード例 #2
0
        private void desenharCampos()
        {
            oItem = oForm.Items.Item("Grade");

            oNewItem          = oForm.Items.Add("Apr_Text0", SAPbouiCOM.BoFormItemTypes.it_STATIC);
            oNewItem.Top      = oItem.Top + 65;
            oNewItem.Height   = 19;
            oNewItem.Width    = 350;
            oNewItem.Left     = 25;
            oNewItem.FromPane = 12;
            oNewItem.ToPane   = 12;
            oNewItem.Visible  = true;
            oTextItem         = ((SAPbouiCOM.StaticText)(oNewItem.Specific));
            oTextItem.Caption = "Ambiente / Análise Crítica";

            oNewItem          = oForm.Items.Add("Apr_Text1", SAPbouiCOM.BoFormItemTypes.it_STATIC);
            oNewItem.Top      = oItem.Top + 200;
            oNewItem.Height   = 19;
            oNewItem.Width    = 350;
            oNewItem.Left     = 25;
            oNewItem.FromPane = 12;
            oNewItem.ToPane   = 12;
            oNewItem.Visible  = true;
            oTextItem         = ((SAPbouiCOM.StaticText)(oNewItem.Specific));
            oTextItem.Caption = "Ambiente / Aprovação";

            oNewItem          = oForm.Items.Add("Apr_Text2a", SAPbouiCOM.BoFormItemTypes.it_STATIC);
            oItem             = oForm.Items.Item("Grade");
            oNewItem.Top      = oItem.Top + 17;
            oNewItem.Height   = 19;
            oNewItem.Width    = 400;
            oNewItem.Left     = 25;
            oNewItem.FromPane = 12;
            oNewItem.ToPane   = 12;
            oNewItem.Visible  = true;
            oTextItem         = ((SAPbouiCOM.StaticText)(oNewItem.Specific));
            oTextItem.Caption = "Data";

            oNewItem          = oForm.Items.Add("Apr_Text2b", SAPbouiCOM.BoFormItemTypes.it_STATIC);
            oNewItem.Top      = oItem.Top + 17;
            oNewItem.Height   = 19;
            oNewItem.Width    = 400;
            oNewItem.Left     = 120;
            oNewItem.FromPane = 12;
            oNewItem.ToPane   = 12;
            oNewItem.Visible  = true;
            oTextItem         = ((SAPbouiCOM.StaticText)(oNewItem.Specific));
            oTextItem.Caption = "Hora";

            oNewItem          = oForm.Items.Add("Apr_Text2c", SAPbouiCOM.BoFormItemTypes.it_STATIC);
            oItem             = oForm.Items.Item("Grade");
            oNewItem.Top      = oItem.Top + 17;
            oNewItem.Height   = 19;
            oNewItem.Width    = 400;
            oNewItem.Left     = 175;
            oNewItem.FromPane = 12;
            oNewItem.ToPane   = 12;
            oNewItem.Visible  = true;
            oTextItem         = ((SAPbouiCOM.StaticText)(oNewItem.Specific));
            oTextItem.Caption = "Projetista";

            oNewItem          = oForm.Items.Add("Apr_Data", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oNewItem.Top      = oItem.Top + 35;
            oNewItem.Height   = 17;
            oNewItem.Width    = 80;
            oNewItem.Left     = 25;
            oNewItem.FromPane = 12;
            oNewItem.ToPane   = 12;
            oEditItem         = ((SAPbouiCOM.EditText)(oNewItem.Specific));
            oEditItem.DataBind.SetBound(true, "OOPR", "U_FLX_FB_APS_DATE");

            oNewItem          = oForm.Items.Add("Apr_Hora", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oNewItem.Top      = oItem.Top + 35;
            oNewItem.Height   = 17;
            oNewItem.Width    = 40;
            oNewItem.Left     = 120;
            oNewItem.FromPane = 12;
            oNewItem.ToPane   = 12;
            //oEditItem.DataBind.SetBound(true, "", "EditSource");
            oEditItem = ((SAPbouiCOM.EditText)(oNewItem.Specific));
            oEditItem.DataBind.SetBound(true, "OOPR", "U_FLX_FB_APS_HORA");

            oNewItem             = oForm.Items.Add("Apr_Proj", SAPbouiCOM.BoFormItemTypes.it_COMBO_BOX);
            oNewItem.Top         = oItem.Top + 35;
            oNewItem.Height      = 17;
            oNewItem.Width       = 140;
            oNewItem.Left        = 175;
            oNewItem.FromPane    = 12;
            oNewItem.ToPane      = 12;
            oNewItem.DisplayDesc = true;
            //oComboItem.DataBind.SetBound(true, "", "CombSource");
            oComboItem = ((SAPbouiCOM.ComboBox)(oNewItem.Specific));
            //oComboItem.DataBind.SetBound(true, "OOPR", "U_FLX_FB_APS_PROJT");
            //LoadResponsavelComboVals(oComboItem);

            oNewItem          = oForm.Items.Add("Apr_Ped", SAPbouiCOM.BoFormItemTypes.it_BUTTON);
            oNewItem.Top      = oItem.Top + 235;
            oNewItem.Width    = 100;
            oNewItem.Left     = 725;
            oNewItem.Height   = 25;
            oNewItem.FromPane = 12;
            oNewItem.ToPane   = 12;
            oNewItem.Visible  = true;
            oButton           = ((SAPbouiCOM.Button)(oNewItem.Specific));
            oButton.Caption   = "Pedido (fechamento)";

            oNewItem          = oForm.Items.Add("Apr_Text3", SAPbouiCOM.BoFormItemTypes.it_STATIC);
            oNewItem.Top      = oItem.Top + 220;
            oNewItem.Height   = 19;
            oNewItem.Width    = 50;
            oNewItem.Left     = 840;
            oNewItem.FromPane = 12;
            oNewItem.ToPane   = 12;
            oNewItem.Visible  = true;
            oTextItem         = ((SAPbouiCOM.StaticText)(oNewItem.Specific));
            oTextItem.Caption = "Pedido";

            oNewItem          = oForm.Items.Add("Apr_Pedido", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oNewItem.Top      = oItem.Top + 240;
            oNewItem.Height   = 17;
            oNewItem.Width    = 40;
            oNewItem.Left     = 840;
            oNewItem.FromPane = 12;
            oNewItem.ToPane   = 12;
            oNewItem.Enabled  = false;
            oEditItem         = ((SAPbouiCOM.EditText)(oNewItem.Specific));

            oNewItem          = oForm.Items.Add("Apr_LinkPd", SAPbouiCOM.BoFormItemTypes.it_LINKED_BUTTON);
            oNewItem.Top      = oItem.Top + 240;
            oNewItem.Height   = 17;
            oNewItem.Width    = 40;
            oNewItem.Left     = 810;
            oNewItem.FromPane = 12;
            oNewItem.ToPane   = 12;
            oNewItem.Visible  = true;
            oNewItem.Enabled  = true;
            oLink             = ((SAPbouiCOM.LinkedButton)(oNewItem.Specific));
            //oLink.LinkedObject = "Apr_Pedido";

            oNewItem          = oForm.Items.Add("Apr_Ctr", SAPbouiCOM.BoFormItemTypes.it_BUTTON);
            oNewItem.Top      = oItem.Top + 300;
            oNewItem.Width    = 100;
            oNewItem.Left     = 725;
            oNewItem.Height   = 25;
            oNewItem.FromPane = 12;
            oNewItem.ToPane   = 12;
            oNewItem.Visible  = true;
            oButton           = ((SAPbouiCOM.Button)(oNewItem.Specific));
            oButton.Caption   = "Gerar Contrato(s)";

            oNewItem          = oForm.Items.Add("Apr_Text4", SAPbouiCOM.BoFormItemTypes.it_STATIC);
            oNewItem.Top      = oItem.Top + 285;
            oNewItem.Height   = 19;
            oNewItem.Width    = 55;
            oNewItem.Left     = 840;
            oNewItem.FromPane = 12;
            oNewItem.ToPane   = 12;
            oNewItem.Visible  = true;
            oTextItem         = ((SAPbouiCOM.StaticText)(oNewItem.Specific));
            oTextItem.Caption = "Contrato(s)";

            oNewItem          = oForm.Items.Add("Apr_Contr", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oNewItem.Top      = oItem.Top + 305;
            oNewItem.Height   = 17;
            oNewItem.Width    = 40;
            oNewItem.Left     = 840;
            oNewItem.FromPane = 12;
            oNewItem.ToPane   = 12;
            oEditItem         = ((SAPbouiCOM.EditText)(oNewItem.Specific));



            oNewItem          = oForm.Items.Add("Apr_Amb", SAPbouiCOM.BoFormItemTypes.it_MATRIX);
            oNewItem.Left     = 25;
            oNewItem.Width    = 420;
            oNewItem.Top      = oItem.Top + 85;
            oNewItem.Height   = 110;
            oNewItem.FromPane = 12;
            oNewItem.ToPane   = 12;

            oMatrix = ((SAPbouiCOM.Matrix)(oNewItem.Specific));
            oMatrix.SelectionMode = SAPbouiCOM.BoMatrixSelect.ms_Auto;
            oColumns = oMatrix.Columns;

            oColumn = oColumns.Add("#", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "#";
            oColumn.Width    = 30;
            oColumn.Editable = false;

            oColumn = oColumns.Add("Apr_Amb_C0", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Ambiente";
            oColumn.Width    = 80;
            oColumn.Editable = false;

            oColumn = oColumns.Add("Apr_Amb_C1", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Detalhamento";
            oColumn.Width    = 100;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Apr_Amb_C2", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Id";
            oColumn.Editable            = true;
            oColumn.Visible             = false;

            oForm.DataSources.DataTables.Item("oMatrixDT").ExecuteQuery("SELECT T1.[Num], T1.[Descript], T0.* FROM OPR4 T0 INNER JOIN OOIN T1 ON T1.Num = T0.IntId WHERE T0.[OprId] = '1'");

            oColumn = oColumns.Item("Apr_Amb_C0");
            oColumn.DataBind.Bind("oMatrixDT", "Descript");
            oColumn = oColumns.Item("Apr_Amb_C1");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_ANC_DETALHA");
            oColumn = oColumns.Item("Apr_Amb_C2");
            oColumn.DataBind.Bind("oMatrixDT", "Line");

            oNewItem          = oForm.Items.Add("NvAnalise", SAPbouiCOM.BoFormItemTypes.it_BUTTON);
            oNewItem.Top      = oItem.Top + 35;
            oNewItem.Width    = 140;
            oNewItem.Left     = oForm.Width - 270;
            oNewItem.Height   = 21;
            oNewItem.FromPane = 12;
            oNewItem.ToPane   = 12;
            oNewItem.Visible  = true;
            oButton           = ((SAPbouiCOM.Button)(oNewItem.Specific));
            oButton.Caption   = "Nova análise crítica";


            oNewItem = oForm.Items.Add("Ans_Amb", SAPbouiCOM.BoFormItemTypes.it_MATRIX);
            SAPbouiCOM.Item teste = oForm.Items.Item("Apr_Amb");
            oNewItem.Left     = oForm.Width - 270;
            oNewItem.Width    = 200;
            oNewItem.Top      = oItem.Top + 85;
            oNewItem.Height   = 110;
            oNewItem.FromPane = 12;
            oNewItem.ToPane   = 12;

            oMatrix = ((SAPbouiCOM.Matrix)(oNewItem.Specific));
            oMatrix.SelectionMode = SAPbouiCOM.BoMatrixSelect.ms_Auto;
            oColumns = oMatrix.Columns;

            oColumn = oColumns.Add("#", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "#";
            oColumn.Width    = 30;
            oColumn.Editable = false;

            oColumn = oColumns.Add("Ans_Amb_C0", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Analise Crítica";
            oColumn.Width    = 120;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Ans_Amb_C1", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Id";
            oColumn.Editable            = true;
            oColumn.Visible             = false;

            DBDSflx = oForm.DataSources.DBDataSources.Add("@FLX_FB_CONFMED");
            oForm.DataSources.DataTables.Add("oDataTableAnalise");
            oForm.DataSources.DataTables.Item("oDataTableAnalise").ExecuteQuery("SELECT * FROM [@FLX_FB_ANLCRI] where U_FLX_FB_ANLCRI_ID = '1' and U_FLX_FB_ANLCRI_AMBI = '1'");

            oColumn = oColumns.Item("Ans_Amb_C0");
            oColumn.DataBind.Bind("oDataTableAnalise", "U_FLX_FB_ANLCRI_ANEX");

            oColumn = oColumns.Item("Ans_Amb_C1");
            oColumn.DataBind.Bind("oDataTableAnalise", "Code");



            oNewItem          = oForm.Items.Add("Apv_Amb", SAPbouiCOM.BoFormItemTypes.it_MATRIX);
            oNewItem.Left     = 25;
            oNewItem.Width    = 700;
            oNewItem.Top      = oItem.Top + 220;
            oNewItem.Height   = 110;
            oNewItem.FromPane = 12;
            oNewItem.ToPane   = 12;

            oMatrix  = ((SAPbouiCOM.Matrix)(oNewItem.Specific));
            oColumns = oMatrix.Columns;

            oColumn = oColumns.Add("#", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "#";
            oColumn.Width    = 30;
            oColumn.Editable = false;

            oColumn = oColumns.Add("Apv_Amb_C0", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Ambiente";
            oColumn.Width    = 80;
            oColumn.Editable = false;

            oColumn = oColumns.Add("Apv_Amb_C1", SAPbouiCOM.BoFormItemTypes.it_COMBO_BOX);
            oColumn.TitleObject.Caption = "Aprovado por";
            oColumn.Width    = 100;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Apv_Amb_C2", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Data Aprovação";
            oColumn.Width    = 80;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Apv_Amb_C3", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "PDFs visto com o cliente";
            oColumn.Width    = 120;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Apv_Amb_C4", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Prancha de Imagem";
            oColumn.Width    = 120;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Apv_Amb_C5", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Memorial Descritivo";
            oColumn.Width    = 130;
            oColumn.Editable = true;

            oForm.DataSources.DataTables.Item("oMatrixDT").ExecuteQuery("SELECT T1.[Num], T1.[Descript], T0.* FROM OPR4 T0 INNER JOIN OOIN T1 ON T1.Num = T0.IntId WHERE T0.[OprId] = '1'");

            oColumn = oColumns.Item("Apv_Amb_C0");
            oColumn.DataBind.Bind("oMatrixDT", "Descript");

            oColumn = oColumns.Item("Apv_Amb_C1");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_APR_APROVAD");

            oColumn = oColumns.Item("Apv_Amb_C2");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_APR_DATAAPR");

            oColumn = oColumns.Item("Apv_Amb_C3");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_APR_PDFCLIE");

            oColumn = oColumns.Item("Apv_Amb_C4");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_APR_PRANIMG");

            oColumn = oColumns.Item("Apv_Amb_C5");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_APR_MEMDESC");
        }
コード例 #3
0
ファイル: Pedido.cs プロジェクト: Planticenter/SAP-Repository
        private void desenharCampos()
        {
            oItem = oForm.Items.Item("7");

            oNewItem          = oForm.Items.Add("Ped_Amb", SAPbouiCOM.BoFormItemTypes.it_MATRIX);
            oNewItem.Left     = 25;
            oNewItem.Width    = 880;
            oNewItem.Top      = oItem.Top + 50;
            oNewItem.Height   = 120;
            oNewItem.FromPane = 13;
            oNewItem.ToPane   = 13;

            oMatrix  = ((SAPbouiCOM.Matrix)(oNewItem.Specific));
            oColumns = oMatrix.Columns;

            oColumn = oColumns.Add("Ped_#", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "#";
            oColumn.Width    = 30;
            oColumn.Editable = false;

            oColumn = oColumns.Add("Ped_Amb_C0", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Ambiente";
            oColumn.Width    = 80;
            oColumn.Editable = false;

            oColumn = oColumns.Add("Ped_Amb_C1", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Data Pedido";
            oColumn.Width    = 80;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Ped_Amb_C2", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "No.Pedido";
            oColumn.Width    = 100;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Ped_Amb_C3", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Ordem de Compra";
            oColumn.Width    = 120;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Ped_Amb_C4", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Valor";
            oColumn.Width    = 100;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Ped_Amb_C5", SAPbouiCOM.BoFormItemTypes.it_COMBO_BOX);
            oColumn.TitleObject.Caption = "Solicitante";
            oColumn.Width    = 120;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Ped_Amb_C6", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Prazo Entrega";
            oColumn.Width    = 80;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Ped_Amb_C7", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Anexo (pedido impresso)";
            oColumn.Width    = 100;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Ped_Amb_C8", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "URL";
            oColumn.Width    = 100;
            oColumn.Editable = true;

            oForm.DataSources.DataTables.Item("oMatrixDT").ExecuteQuery("SELECT T1.[Num], T1.[Descript], T0.* FROM OPR4 T0 INNER JOIN OOIN T1 ON T1.Num = T0.IntId WHERE T0.[OprId] = '1'");

            oColumn = oColumns.Item("Ped_Amb_C0");
            oColumn.DataBind.Bind("oMatrixDT", "Descript");

            oColumn = oColumns.Item("Ped_Amb_C1");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_PED_DATE");

            oColumn = oColumns.Item("Ped_Amb_C2");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_PED_NPEDIDO");

            oColumn = oColumns.Item("Ped_Amb_C3");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_PED_ORDENDE");

            oColumn = oColumns.Item("Ped_Amb_C4");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_PED_VALOR");

            oColumn = oColumns.Item("Ped_Amb_C5");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_PED_SOLICIT");

            oColumn = oColumns.Item("Ped_Amb_C6");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_PED_PRAZOEN");

            oColumn = oColumns.Item("Ped_Amb_C7");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_PED_ANEXOPE");

            oColumn = oColumns.Item("Ped_Amb_C8");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_PED_URL");
        }
コード例 #4
0
        private void desenharCampos()
        {
            oItem = oForm.Items.Item("Grade");

            oNewItem          = oForm.Items.Add("Ela_Cot", SAPbouiCOM.BoFormItemTypes.it_BUTTON);
            oNewItem.Top      = oItem.Top + 30;
            oNewItem.Width    = 150;
            oNewItem.Left     = 730;
            oNewItem.Height   = 19;
            oNewItem.FromPane = 11;
            oNewItem.ToPane   = 11;
            oNewItem.Visible  = true;
            oButton           = ((SAPbouiCOM.Button)(oNewItem.Specific));
            oButton.Caption   = "Gerar Orçamento...";

            oNewItem          = oForm.Items.Add("Ela_Text1", SAPbouiCOM.BoFormItemTypes.it_STATIC);
            oNewItem.Top      = oItem.Top + 30;
            oNewItem.Height   = 19;
            oNewItem.Width    = 350;
            oNewItem.Left     = 25;
            oNewItem.FromPane = 11;
            oNewItem.ToPane   = 11;
            oNewItem.Visible  = true;
            oTextItem         = ((SAPbouiCOM.StaticText)(oNewItem.Specific));
            oTextItem.Caption = "Ambiente / Elaboração do projeto";

            oNewItem          = oForm.Items.Add("Ela_Text0", SAPbouiCOM.BoFormItemTypes.it_STATIC);
            oNewItem.Top      = oItem.Top + 185;
            oNewItem.Height   = 19;
            oNewItem.Width    = 350;
            oNewItem.Left     = 25;
            oNewItem.FromPane = 11;
            oNewItem.ToPane   = 11;
            oNewItem.Visible  = true;
            oTextItem         = ((SAPbouiCOM.StaticText)(oNewItem.Specific));
            oTextItem.Caption = "Ambiente / Verificação do projeto";

            oNewItem          = oForm.Items.Add("Ela_Amb", SAPbouiCOM.BoFormItemTypes.it_MATRIX);
            oNewItem.Left     = 25;
            oNewItem.Width    = 880;
            oNewItem.Top      = oItem.Top + 50;
            oNewItem.Height   = 120;
            oNewItem.FromPane = 11;
            oNewItem.ToPane   = 11;

            oMatrix  = ((SAPbouiCOM.Matrix)(oNewItem.Specific));
            oColumns = oMatrix.Columns;

            oColumn = oColumns.Add("Ela_#", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "#";
            oColumn.Width    = 30;
            oColumn.Editable = false;

            oColumn = oColumns.Add("Ela_Amb_C0", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Ambiente";
            oColumn.Width    = 80;
            oColumn.Editable = false;

            /*oColumn = oColumns.Add("Ela_Amb_C1", SAPbouiCOM.BoFormItemTypes.it_CHECK_BOX);
             * oColumn.TitleObject.Caption = "Revisão";
             * oColumn.Width = 60;
             * oColumn.Editable = true;*/

            oColumn = oColumns.Add("Ela_Amb_C1", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Revisão";
            oColumn.Width    = 60;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Ela_Amb_C2", SAPbouiCOM.BoFormItemTypes.it_COMBO_BOX);
            oColumn.TitleObject.Caption = "Projetista";
            oColumn.Width       = 100;
            oColumn.Editable    = true;
            oColumn.DisplayDesc = true;


            oColumn = oColumns.Add("Ela_Amb_C3", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Início Prev";
            oColumn.Width    = 90;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Ela_Amb_C4", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Término Prev";
            oColumn.Width    = 90;
            oColumn.Editable = true;
            //oColumn.DataBind.SetBound(true, "OPR4", "U_FLX_FB_VRF_OBS");

            oColumn = oColumns.Add("Ela_Amb_C5", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Início Realiz";
            oColumn.Width    = 90;
            oColumn.Editable = true;
            //oColumn.DataBind.SetBound(true, "OPR4", "U_FLX_FB_VRF_OBS");

            oColumn = oColumns.Add("Ela_Amb_C6", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Término Realiz";
            oColumn.Width    = 90;
            oColumn.Editable = true;
            //oColumn.DataBind.SetBound(true, "OPR4", "U_FLX_FB_VRF_OBS");

            oColumn = oColumns.Add("Ela_Amb_C7", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Arquivos CAD";
            oColumn.Width    = 120;
            oColumn.Editable = true;
            //oColumn.DataBind.SetBound(true, "OPR4", "U_FLX_FB_VRF_OBS");

            oColumn = oColumns.Add("Ela_Amb_C8", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Arquivos PRJ";
            oColumn.Width    = 120;
            oColumn.Editable = true;
            //oColumn.DataBind.SetBound(true, "OPR4", "U_FLX_FB_VRF_OBS");

            oColumn = oColumns.Add("Ela_Amb_C9", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Arquivos JPG";
            oColumn.Width    = 120;
            oColumn.Editable = true;
            //oColumn.DataBind.SetBound(true, "OPR4", "U_FLX_FB_VRF_OBS");

            oForm.DataSources.DataTables.Item("oMatrixDT").ExecuteQuery("SELECT T1.[Num], T1.[Descript], T0.* FROM OPR4 T0 INNER JOIN OOIN T1 ON T1.Num = T0.IntId WHERE T0.[OprId] = '1'");

            oColumn = oColumns.Item("Ela_Amb_C0");
            oColumn.DataBind.Bind("oMatrixDT", "Descript");

            oColumn = oColumns.Item("Ela_Amb_C1");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_ELB_REVISAO");

            oColumn = oColumns.Item("Ela_Amb_C2");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_ELB_PROJETI");

            oColumn = oColumns.Item("Ela_Amb_C3");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_ELB_INICIOP");

            oColumn = oColumns.Item("Ela_Amb_C4");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_ELB_TERMINP");

            oColumn = oColumns.Item("Ela_Amb_C5");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_ELB_INICIOR");

            oColumn = oColumns.Item("Ela_Amb_C6");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_ELB_TERMINR");

            oColumn = oColumns.Item("Ela_Amb_C7");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_ELB_ARQCAD");

            oColumn = oColumns.Item("Ela_Amb_C8");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_ELB_ARQPRJ");

            oColumn = oColumns.Item("Ela_Amb_C9");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_ELB_ARQJPG");
        }
コード例 #5
0
        private void desenharCampos()
        {
            oItem = oForm.Items.Item("Grade");

            oNewItem          = oForm.Items.Add("Fab_Text0", SAPbouiCOM.BoFormItemTypes.it_STATIC);
            oNewItem.Top      = oItem.Top + 30;
            oNewItem.Height   = 19;
            oNewItem.Width    = 350;
            oNewItem.Left     = 25;
            oNewItem.FromPane = 15;
            oNewItem.ToPane   = 15;
            oNewItem.Visible  = true;
            oTextItem         = ((SAPbouiCOM.StaticText)(oNewItem.Specific));
            oTextItem.Caption = "Recebimento dos Ambientes";

            oNewItem          = oForm.Items.Add("Fab_Text1", SAPbouiCOM.BoFormItemTypes.it_STATIC);
            oNewItem.Top      = oItem.Top + 185;
            oNewItem.Height   = 19;
            oNewItem.Width    = 350;
            oNewItem.Left     = 25;
            oNewItem.FromPane = 15;
            oNewItem.ToPane   = 15;
            oNewItem.Visible  = true;
            oTextItem         = ((SAPbouiCOM.StaticText)(oNewItem.Specific));
            oTextItem.Caption = "Registro de Avarias";

            oNewItem          = oForm.Items.Add("Fab_Amb", SAPbouiCOM.BoFormItemTypes.it_MATRIX);
            oNewItem.Left     = 25;
            oNewItem.Width    = 480;
            oNewItem.Top      = oItem.Top + 50;
            oNewItem.Height   = 120;
            oNewItem.FromPane = 15;
            oNewItem.ToPane   = 15;

            oMatrix = ((SAPbouiCOM.Matrix)(oNewItem.Specific));
            oMatrix.SelectionMode = SAPbouiCOM.BoMatrixSelect.ms_Auto;
            oColumns = oMatrix.Columns;

            oColumn = oColumns.Add("Fab_#", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "#";
            oColumn.Width    = 30;
            oColumn.Editable = false;

            oColumn = oColumns.Add("Fab_Amb_C0", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Ambiente";
            oColumn.Width    = 80;
            oColumn.Editable = false;

            /*oColumn = oColumns.Add("Fab_Amb_C1", SAPbouiCOM.BoFormItemTypes.it_CHECK_BOX);
             * oColumn.TitleObject.Caption = "Expedição";
             * oColumn.Width = 80;
             * oColumn.Editable = true;*/

            oColumn = oColumns.Add("Fab_Amb_C1", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Expedição";
            oColumn.Width    = 80;
            oColumn.Editable = true;

            /*oColumn = oColumns.Add("Fab_Amb_C2", SAPbouiCOM.BoFormItemTypes.it_COMBO_BOX);
             * oColumn.TitleObject.Caption = "Recebimento";
             * oColumn.Width = 80;
             * oColumn.Editable = true;*/

            oColumn = oColumns.Add("Fab_Amb_C2", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Recebimento";
            oColumn.Width    = 80;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Fab_Amb_C3", SAPbouiCOM.BoFormItemTypes.it_COMBO_BOX);
            oColumn.TitleObject.Caption = "Conferente";
            oColumn.Width    = 120;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Fab_Amb_C4", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "IdAmbiente";
            oColumn.Width    = 80;
            oColumn.Editable = true;
            oColumn.Visible  = false;

            oForm.DataSources.DataTables.Item("oMatrixDT").ExecuteQuery(
                "SELECT T1.[Num], T1.[Descript], T0.* FROM OPR4 T0 " +
                "INNER JOIN OOIN T1 ON T1.Num = T0.IntId " +
                "WHERE T0.[OprId] = '1'");

            oColumn = oColumns.Item("Fab_Amb_C0");
            oColumn.DataBind.Bind("oMatrixDT", "Descript");

            oColumn = oColumns.Item("Fab_Amb_C1");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_FAB_EXPEDIC");

            oColumn = oColumns.Item("Fab_Amb_C2");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_FAB_RECEBIM");

            oColumn = oColumns.Item("Fab_Amb_C3");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_FAB_CONFERE");

            oColumn = oColumns.Item("Fab_Amb_C4");
            oColumn.DataBind.Bind("oMatrixDT", "Line");


            oNewItem          = oForm.Items.Add("Ava_Amb", SAPbouiCOM.BoFormItemTypes.it_MATRIX);
            oNewItem.Left     = 25;
            oNewItem.Width    = 680;
            oNewItem.Top      = oItem.Top + 205;
            oNewItem.Height   = 120;
            oNewItem.FromPane = 15;
            oNewItem.ToPane   = 15;

            oMatrix = ((SAPbouiCOM.Matrix)(oNewItem.Specific));
            oMatrix.SelectionMode = SAPbouiCOM.BoMatrixSelect.ms_Auto;
            oColumns = oMatrix.Columns;

            oColumn = oColumns.Add("Ava_#", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "#";
            oColumn.Width    = 30;
            oColumn.Editable = false;

            oColumn = oColumns.Add("Ava_Amb_C0", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Descrição";
            oColumn.Width    = 600;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Ava_Amb_C1", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "id";
            oColumn.Width    = 600;
            oColumn.Editable = true;
            oColumn.Visible  = false;

            oForm.DataSources.DataTables.Add("oDataTableAvr");
            oForm.DataSources.DataTables.Item("oDataTableAvr").ExecuteQuery("select * from [@FLX_FB_AVR] where U_FLX_FB_AVR_IDOOPR = '1' and U_FLX_FB_AVR_IDAMBI = '1'");

            oColumn = oColumns.Item("Ava_Amb_C0");
            oColumn.DataBind.Bind("oDataTableAvr", "U_FLX_FB_AVR_DESC");

            oColumn = oColumns.Item("Ava_Amb_C1");
            oColumn.DataBind.Bind("oDataTableAvr", "Code");
        }
コード例 #6
0
        private void desenharCampos()
        {
            oItem = oForm.Items.Item("Grade");

            oNewItem          = oForm.Items.Add("Det_Text0", SAPbouiCOM.BoFormItemTypes.it_STATIC);
            oNewItem.Top      = oItem.Top + 30;
            oNewItem.Height   = 19;
            oNewItem.Width    = 350;
            oNewItem.Left     = 25;
            oNewItem.FromPane = 14;
            oNewItem.ToPane   = 14;
            oNewItem.Visible  = true;
            oTextItem         = ((SAPbouiCOM.StaticText)(oNewItem.Specific));
            oTextItem.Caption = "Ambiente / Detalhamento do Projeto";

            oNewItem          = oForm.Items.Add("Det_Text1", SAPbouiCOM.BoFormItemTypes.it_STATIC);
            oNewItem.Top      = oItem.Top + 185;
            oNewItem.Height   = 19;
            oNewItem.Width    = 350;
            oNewItem.Left     = 25;
            oNewItem.FromPane = 14;
            oNewItem.ToPane   = 14;
            oNewItem.Visible  = true;
            oTextItem         = ((SAPbouiCOM.StaticText)(oNewItem.Specific));
            oTextItem.Caption = "Itens Complementares";

            oNewItem          = oForm.Items.Add("Det_Amb", SAPbouiCOM.BoFormItemTypes.it_MATRIX);
            oNewItem.Left     = 25;
            oNewItem.Width    = 860;
            oNewItem.Top      = oItem.Top + 50;
            oNewItem.Height   = 120;
            oNewItem.FromPane = 14;
            oNewItem.ToPane   = 14;

            oMatrix  = ((SAPbouiCOM.Matrix)(oNewItem.Specific));
            oColumns = oMatrix.Columns;

            oColumn = oColumns.Add("Det_#", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "#";
            oColumn.Width    = 30;
            oColumn.Editable = false;

            oColumn = oColumns.Add("Det_Amb_C0", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Ambiente";
            oColumn.Width    = 80;
            oColumn.Editable = false;

            oColumn = oColumns.Add("Det_Amb_C2", SAPbouiCOM.BoFormItemTypes.it_COMBO_BOX);
            oColumn.TitleObject.Caption = "Projetista";
            oColumn.Width       = 120;
            oColumn.Editable    = true;
            oColumn.DisplayDesc = true;
            //oColumn.DataBind.SetBound(true, "OPR4", "U_FLX_FB_ENT_PENDENC");

            oColumn = oColumns.Add("Det_Amb_C3", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Início Previsto";
            oColumn.Width    = 100;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Det_Amb_C4", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Término Previsto";
            oColumn.Width    = 100;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Det_Amb_C5", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Início Realizado";
            oColumn.Width    = 100;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Det_Amb_C6", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Término Realzado";
            oColumn.Width    = 100;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Det_Amb_C7", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "PDFs Detalhamento";
            oColumn.Width    = 200;
            oColumn.Editable = true;
            oColumn.DataBind.SetBound(true, "@FLX_FB_CONFMED", "U_FLX_FB_CONFMED_PRJ");

            oForm.DataSources.DataTables.Item("oMatrixDT").ExecuteQuery("SELECT T1.[Num], T1.[Descript], T0.* FROM OPR4 T0 INNER JOIN OOIN T1 ON T1.Num = T0.IntId WHERE T0.[OprId] = '1'");

            oColumn = oColumns.Item("Det_Amb_C0");
            oColumn.DataBind.Bind("oMatrixDT", "Descript");

            oColumn = oColumns.Item("Det_Amb_C2");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_DET_PROJETI");

            oColumn = oColumns.Item("Det_Amb_C3");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_DET_INICIOP");

            oColumn = oColumns.Item("Det_Amb_C4");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_DET_TERMINP");

            oColumn = oColumns.Item("Det_Amb_C5");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_DET_INICIRE");

            oColumn = oColumns.Item("Det_Amb_C6");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_DET_TERMINO");

            oColumn = oColumns.Item("Det_Amb_C7");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_DET_PDF");



            oNewItem          = oForm.Items.Add("Det_Cmp", SAPbouiCOM.BoFormItemTypes.it_MATRIX);
            oNewItem.Left     = 25;
            oNewItem.Width    = 880;
            oNewItem.Top      = oItem.Top + 205;
            oNewItem.Height   = 120;
            oNewItem.FromPane = 14;
            oNewItem.ToPane   = 14;

            oMatrix  = ((SAPbouiCOM.Matrix)(oNewItem.Specific));
            oColumns = oMatrix.Columns;

            oColumn = oColumns.Add("Cmp_#", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "#";
            oColumn.Width    = 30;
            oColumn.Editable = false;

            oColumn = oColumns.Add("Cmp_Amb_C0", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Item";
            oColumn.Width    = 40;
            oColumn.Editable = false;

            oColumn = oColumns.Add("Cmp_Amb_C1", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Descrição";
            oColumn.Width    = 200;
            oColumn.Editable = true;
            oColumn.DataBind.SetBound(true, "", "dt");
            oColumn.ChooseFromListUID   = "CFL1";
            oColumn.ChooseFromListAlias = "ItemName";

            oColumn = oColumns.Add("Cmp_Amb_C4", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Estoque";
            oColumn.Width    = 70;
            oColumn.Editable = false;

            oColumn = oColumns.Add("Cmp_Amb_C2", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Qtd";
            oColumn.Width    = 40;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Cmp_Amb_C6", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "IdFornecedor";
            oColumn.Width    = 40;
            oColumn.Editable = false;
            oColumn.Visible  = false;

            oColumn = oColumns.Add("Cmp_Amb_C3", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Fornecedor";
            oColumn.Width    = 150;
            oColumn.Editable = true;
            oColumn.DataBind.SetBound(true, "", "dt");
            oColumn.ChooseFromListUID   = "CFL2";
            oColumn.ChooseFromListAlias = "CardName";

            oColumn = oColumns.Add("Cmp_Amb_C5", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Observação";
            oColumn.Width    = 120;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Cmp_Amb_C7", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "id";
            oColumn.Width    = 120;
            oColumn.Editable = true;
            oColumn.Visible  = false;

            oForm.DataSources.DataTables.Add("oDataTableItc");
            oForm.DataSources.DataTables.Item("oDataTableItc").ExecuteQuery("select T1.ItemCode, T1.ItemName, T1.OnHand, T0.U_FLX_FB_ITC_QTD, T2.CardCode, T2.CardName, T0.U_FLX_FB_ITC_OBS, T0.Code from [@FLX_FB_ITC] T0 inner join OITM T1 on T1.ItemCode = T0.U_FLX_FB_ITC_IDOITM inner join OCRD T2 on T2.CardCode = T0.U_FLX_FB_ITC_IDOCRD where T0.U_FLX_FB_ITC_IDOOPR = '1'");

            oColumn = oColumns.Item("Cmp_Amb_C0");
            oColumn.DataBind.Bind("oDataTableItc", "ItemCode");
            oColumn = oColumns.Item("Cmp_Amb_C1");
            oColumn.DataBind.Bind("oDataTableItc", "ItemName");
            oColumn = oColumns.Item("Cmp_Amb_C4");
            oColumn.DataBind.Bind("oDataTableItc", "OnHand");
            oColumn = oColumns.Item("Cmp_Amb_C2");
            oColumn.DataBind.Bind("oDataTableItc", "U_FLX_FB_ITC_QTD");
            oColumn = oColumns.Item("Cmp_Amb_C6");
            oColumn.DataBind.Bind("oDataTableItc", "CardCode");
            oColumn = oColumns.Item("Cmp_Amb_C3");
            oColumn.DataBind.Bind("oDataTableItc", "CardName");
            oColumn = oColumns.Item("Cmp_Amb_C5");
            oColumn.DataBind.Bind("oDataTableItc", "U_FLX_FB_ITC_OBS");
            oColumn = oColumns.Item("Cmp_Amb_C7");
            oColumn.DataBind.Bind("oDataTableItc", "Code");
        }
コード例 #7
0
        private void desenharCampos()
        {
            oItem = oForm.Items.Item("7");

            oNewItem          = oForm.Items.Add("Etg_TextY", SAPbouiCOM.BoFormItemTypes.it_STATIC);
            oNewItem.Top      = oItem.Top + 60;
            oNewItem.Height   = 19;
            oNewItem.Width    = 150;
            oNewItem.Left     = 25;
            oNewItem.FromPane = 17;
            oNewItem.ToPane   = 17;
            oNewItem.Visible  = true;
            oTextItem         = ((SAPbouiCOM.StaticText)(oNewItem.Specific));
            oTextItem.Caption = "Declaração de conformidade: ";

            oNewItem          = oForm.Items.Add("Etg_Dec_An", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oNewItem.Top      = oItem.Top + 60;
            oNewItem.Height   = 17;
            oNewItem.Width    = 250;
            oNewItem.Left     = 170;
            oNewItem.FromPane = 17;
            oNewItem.ToPane   = 17;
            oEditItem         = ((SAPbouiCOM.EditText)(oNewItem.Specific));
            oEditItem.DataBind.SetBound(true, "OOPR", "U_FLX_FB_ENT_DECLARA");

            oNewItem          = oForm.Items.Add("Etg_Decl", SAPbouiCOM.BoFormItemTypes.it_BUTTON);
            oNewItem.Top      = oItem.Top + 60;
            oNewItem.Width    = 180;
            oNewItem.Left     = 430;
            oNewItem.Height   = 20;
            oNewItem.FromPane = 17;
            oNewItem.ToPane   = 17;
            oNewItem.Visible  = true;
            oButton           = ((SAPbouiCOM.Button)(oNewItem.Specific));
            oButton.Caption   = "Nova declaração de conformidade";

            ///////////////////////////////////////////

            oNewItem          = oForm.Items.Add("Etg_Text2", SAPbouiCOM.BoFormItemTypes.it_STATIC);
            oNewItem.Top      = oItem.Top + 85;
            oNewItem.Height   = 19;
            oNewItem.Width    = 150;
            oNewItem.Left     = 25;
            oNewItem.FromPane = 17;
            oNewItem.ToPane   = 17;
            oNewItem.Visible  = true;
            oTextItem         = ((SAPbouiCOM.StaticText)(oNewItem.Specific));
            oTextItem.Caption = "Pesquisa de satisfação: ";

            oNewItem          = oForm.Items.Add("Etg_Pesqu", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oNewItem.Top      = oItem.Top + 85;
            oNewItem.Height   = 17;
            oNewItem.Width    = 250;
            oNewItem.Left     = 170;
            oNewItem.FromPane = 17;
            oNewItem.ToPane   = 17;
            oEditItem         = ((SAPbouiCOM.EditText)(oNewItem.Specific));
            oEditItem.DataBind.SetBound(true, "OOPR", "U_FLX_FB_ENT_PESQUIS");

            oNewItem          = oForm.Items.Add("Etg_Pq", SAPbouiCOM.BoFormItemTypes.it_BUTTON);
            oNewItem.Top      = oItem.Top + 85;
            oNewItem.Width    = 180;
            oNewItem.Left     = 430;
            oNewItem.Height   = 20;
            oNewItem.FromPane = 17;
            oNewItem.ToPane   = 17;
            oNewItem.Visible  = true;
            oButton           = ((SAPbouiCOM.Button)(oNewItem.Specific));
            oButton.Caption   = "Nova pesquisa de satisfação";

            /////////////////////////////////////////////////////
            oNewItem          = oForm.Items.Add("Etg_Text0", SAPbouiCOM.BoFormItemTypes.it_STATIC);
            oNewItem.Top      = oItem.Top + 105;
            oNewItem.Height   = 19;
            oNewItem.Width    = 350;
            oNewItem.Left     = 25;
            oNewItem.FromPane = 17;
            oNewItem.ToPane   = 17;
            oNewItem.Visible  = true;
            oTextItem         = ((SAPbouiCOM.StaticText)(oNewItem.Specific));
            oTextItem.Caption = "Ambiente / Entrega";

            oNewItem          = oForm.Items.Add("Etg_Amb", SAPbouiCOM.BoFormItemTypes.it_MATRIX);
            oNewItem.Left     = 25;
            oNewItem.Width    = 580;
            oNewItem.Top      = oItem.Top + 125;
            oNewItem.Height   = 120;
            oNewItem.FromPane = 17;
            oNewItem.ToPane   = 17;

            oMatrix = ((SAPbouiCOM.Matrix)(oNewItem.Specific));
            oMatrix.SelectionMode = SAPbouiCOM.BoMatrixSelect.ms_Auto;
            oColumns = oMatrix.Columns;

            oColumn = oColumns.Add("Etg_#", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "#";
            oColumn.Width    = 30;
            oColumn.Editable = false;

            oColumn = oColumns.Add("Etg_Amb_C0", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Ambiente";
            oColumn.Width    = 80;
            oColumn.Editable = false;

            oColumn = oColumns.Add("Etg_Amb_C1", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Entrega";
            oColumn.Width    = 80;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Etg_Amb_C2", SAPbouiCOM.BoFormItemTypes.it_COMBO_BOX);
            oColumn.TitleObject.Caption = "Responsável";
            oColumn.Width    = 120;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Etg_Amb_C3", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Laudo de Entrega";
            oColumn.Width    = 80;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Etg_Amb_C4", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Data p/Solução";
            oColumn.Width    = 100;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Etg_Amb_C5", SAPbouiCOM.BoFormItemTypes.it_CHECK_BOX);
            oColumn.TitleObject.Caption = "Resolvido";
            oColumn.Width       = 80;
            oColumn.Editable    = true;
            oColumn.DisplayDesc = true;
            oColumn.ValOn       = "1";
            oColumn.ValOff      = "0";

            oColumn = oColumns.Add("Etg_Amb_C6", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Id Ambiente";
            oColumn.Width    = 30;
            oColumn.Editable = true;
            oColumn.Visible  = false;

            oForm.DataSources.DataTables.Item("oMatrixDT").ExecuteQuery("SELECT T1.[Num], T1.[Descript], T0.* FROM OPR4 T0 INNER JOIN OOIN T1 ON T1.Num = T0.IntId WHERE T0.[OprId] = '1'");

            oColumn = oColumns.Item("Etg_Amb_C0");
            oColumn.DataBind.Bind("oMatrixDT", "Descript");

            oColumn = oColumns.Item("Etg_Amb_C1");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_ENT_ENTREGA");

            oColumn = oColumns.Item("Etg_Amb_C2");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_ENT_RESPONS");

            oColumn = oColumns.Item("Etg_Amb_C3");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_ENT_LAUDO");

            oColumn = oColumns.Item("Etg_Amb_C4");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_ENT_DATASOL");

            oColumn = oColumns.Item("Etg_Amb_C5");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_ENT_RESOLVI");

            oColumn = oColumns.Item("Etg_Amb_C6");
            oColumn.DataBind.Bind("oMatrixDT", "Line");

            /////////////////////////////

            //Botao Nova vistoria de entrega
            oNewItem          = oForm.Items.Add("Laudo_Ent", SAPbouiCOM.BoFormItemTypes.it_BUTTON);
            oNewItem.Top      = oItem.Top + 125;
            oNewItem.Width    = 200;
            oNewItem.Left     = oForm.Width - 250;
            oNewItem.Height   = 25;
            oNewItem.FromPane = 17;
            oNewItem.ToPane   = 17;
            oNewItem.Visible  = true;
            oButton           = ((SAPbouiCOM.Button)(oNewItem.Specific));
            oButton.Caption   = "Novo laudo de vistoria de entrega";

            oNewItem          = oForm.Items.Add("Etg_Text1", SAPbouiCOM.BoFormItemTypes.it_STATIC);
            oNewItem.Top      = oItem.Top + 265;
            oNewItem.Height   = 19;
            oNewItem.Width    = 350;
            oNewItem.Left     = 25;
            oNewItem.FromPane = 17;
            oNewItem.ToPane   = 17;
            oNewItem.Visible  = true;
            oTextItem         = ((SAPbouiCOM.StaticText)(oNewItem.Specific));
            oTextItem.Caption = "Registro de Pendências";

            oNewItem          = oForm.Items.Add("Pen_Amb", SAPbouiCOM.BoFormItemTypes.it_MATRIX);
            oNewItem.Left     = 25;
            oNewItem.Width    = 880;
            oNewItem.Top      = oItem.Top + 285;
            oNewItem.Height   = 120;
            oNewItem.FromPane = 17;
            oNewItem.ToPane   = 17;

            oMatrix  = ((SAPbouiCOM.Matrix)(oNewItem.Specific));
            oColumns = oMatrix.Columns;

            oColumn = oColumns.Add("Pen_#", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "#";
            oColumn.Width    = 30;
            oColumn.Editable = false;

            oColumn = oColumns.Add("Pen_Amb_C0", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Descrição";
            oColumn.Width    = 600;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Pen_Amb_C1", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Code";
            oColumn.Width    = 50;
            oColumn.Editable = false;
            oColumn.Visible  = false;

            oForm.DataSources.DataTables.Add("oDataTablePend");
            oForm.DataSources.DataTables.Item("oDataTablePend").ExecuteQuery("select * from [@FLX_FB_PEN] where U_FLX_FB_PEN_IDOOPR = '1' and U_FLX_FB_PEN_IDAMB = '1'");

            oColumn = oColumns.Item("Pen_Amb_C0");
            oColumn.DataBind.Bind("oDataTablePend", "U_FLX_FB_PEN_DESC");

            oColumn = oColumns.Item("Pen_Amb_C1");
            oColumn.DataBind.Bind("oDataTablePend", "Code");
        }
コード例 #8
0
        private void desenharCampos()
        {
            oItem = oForm.Items.Item("7");

            oNewItem          = oForm.Items.Add("Med_Text0", SAPbouiCOM.BoFormItemTypes.it_STATIC);
            oNewItem.Top      = oItem.Top + 110;
            oNewItem.Height   = 19;
            oNewItem.Width    = 350;
            oNewItem.Left     = 25;
            oNewItem.FromPane = 10;
            oNewItem.ToPane   = 10;
            oNewItem.Visible  = true;
            oTextItem         = ((SAPbouiCOM.StaticText)(oNewItem.Specific));
            oTextItem.Caption = "Ambiente / Levantamento";

            oNewItem          = oForm.Items.Add("Med_Text1", SAPbouiCOM.BoFormItemTypes.it_STATIC);
            oNewItem.Top      = oItem.Top + 270;
            oNewItem.Height   = 19;
            oNewItem.Width    = 350;
            oNewItem.Left     = 25;
            oNewItem.FromPane = 10;
            oNewItem.ToPane   = 10;
            oNewItem.Visible  = true;
            oTextItem         = ((SAPbouiCOM.StaticText)(oNewItem.Specific));
            oTextItem.Caption = "Conferências de Medições";

            oNewItem          = oForm.Items.Add("Med_Text2a", SAPbouiCOM.BoFormItemTypes.it_STATIC);
            oItem             = oForm.Items.Item("Grade");
            oNewItem.Top      = oItem.Top + 17;
            oNewItem.Height   = 19;
            oNewItem.Width    = 400;
            oNewItem.Left     = 25;
            oNewItem.FromPane = 10;
            oNewItem.ToPane   = 10;
            oNewItem.Visible  = true;
            oTextItem         = ((SAPbouiCOM.StaticText)(oNewItem.Specific));
            oTextItem.Caption = "Data";

            oNewItem          = oForm.Items.Add("Med_Text2b", SAPbouiCOM.BoFormItemTypes.it_STATIC);
            oNewItem.Top      = oItem.Top + 17;
            oNewItem.Height   = 19;
            oNewItem.Width    = 400;
            oNewItem.Left     = 120;
            oNewItem.FromPane = 10;
            oNewItem.ToPane   = 10;
            oNewItem.Visible  = true;
            oTextItem         = ((SAPbouiCOM.StaticText)(oNewItem.Specific));
            oTextItem.Caption = "Hora";

            oNewItem          = oForm.Items.Add("Med_Text2c", SAPbouiCOM.BoFormItemTypes.it_STATIC);
            oNewItem.Top      = oItem.Top + 17;
            oNewItem.Height   = 19;
            oNewItem.Width    = 400;
            oNewItem.Left     = 175;
            oNewItem.FromPane = 10;
            oNewItem.ToPane   = 10;
            oNewItem.Visible  = true;
            oTextItem         = ((SAPbouiCOM.StaticText)(oNewItem.Specific));
            oTextItem.Caption = "Projetista";

            // Comentado campos de ligação com a tabela a partir daqui
            DBDSflx = oForm.DataSources.DBDataSources.Add("@FLX_FB_MED");

            oNewItem          = oForm.Items.Add("Med_Data", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oNewItem.Top      = oItem.Top + 35;
            oNewItem.Height   = 17;
            oNewItem.Width    = 80;
            oNewItem.Left     = 25;
            oNewItem.FromPane = 10;
            oNewItem.ToPane   = 10;
            oEditItem         = ((SAPbouiCOM.EditText)(oNewItem.Specific));
            oEditItem.DataBind.SetBound(true, "OOPR", "U_FLX_FB_MED_DATEMED");

            oNewItem          = oForm.Items.Add("Med_Hora", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oNewItem.Top      = oItem.Top + 35;
            oNewItem.Height   = 17;
            oNewItem.Width    = 40;
            oNewItem.Left     = 120;
            oNewItem.FromPane = 10;
            oNewItem.ToPane   = 10;
            oEditItem         = ((SAPbouiCOM.EditText)(oNewItem.Specific));
            oEditItem.DataBind.SetBound(true, "OOPR", "U_FLX_FB_MED_HORAMED");

            oNewItem             = oForm.Items.Add("Med_Proj", SAPbouiCOM.BoFormItemTypes.it_COMBO_BOX);
            oNewItem.Top         = oItem.Top + 35;
            oNewItem.Height      = 17;
            oNewItem.Width       = 140;
            oNewItem.Left        = 175;
            oNewItem.FromPane    = 10;
            oNewItem.ToPane      = 10;
            oNewItem.DisplayDesc = true;
            oComboItem           = ((SAPbouiCOM.ComboBox)(oNewItem.Specific));


            DBDSflx           = oForm.DataSources.DBDataSources.Add("@FLX_FB_CONFMED");
            oNewItem          = oForm.Items.Add("Med_Amb", SAPbouiCOM.BoFormItemTypes.it_MATRIX);
            oNewItem.Left     = 25;
            oNewItem.Width    = 500;
            oNewItem.Top      = oItem.Top + 85;
            oNewItem.Height   = 110;
            oNewItem.FromPane = 10;
            oNewItem.ToPane   = 10;

            //SBO_Application.MessageBox("PASSO 14", 1, "Ok", "", "");


            oMatrix = ((SAPbouiCOM.Matrix)(oNewItem.Specific));
            oMatrix.SelectionMode = SAPbouiCOM.BoMatrixSelect.ms_Auto;
            oColumns = oMatrix.Columns;

            oColumn = oColumns.Add("#", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "#";
            oColumn.Width    = 30;
            oColumn.Editable = false;

            oColumn = oColumns.Add("Med_Amb_C0", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Ambiente";
            oColumn.Width    = 60;
            oColumn.Editable = false;

            oColumn = oColumns.Add("Med_Amb_C1", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Levantamento (anexos)";
            oColumn.Width    = 140;
            oColumn.Editable = true;
            oColumn.DataBind.SetBound(true, "@FLX_FB_CONFMED", "U_FLX_FB_CONFMED_PRJ");

            oColumn = oColumns.Add("Med_Amb_C2", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "IdAmbiente";
            oColumn.Width    = 80;
            oColumn.Editable = true;
            oColumn.Visible  = false;

            oForm.DataSources.DataTables.Item("oMatrixDT").ExecuteQuery(
                "SELECT T1.[Num], T1.[Descript], T0.* FROM OPR4 T0 " +
                "INNER JOIN OOIN T1 ON T1.Num = T0.IntId " +
                "WHERE T0.[OprId] = '1'");

            oColumn = oColumns.Item("Med_Amb_C0");
            oColumn.DataBind.Bind("oMatrixDT", "Descript");
            oColumn = oColumns.Item("Med_Amb_C1");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_MED_LEVANTA");
            oColumn = oColumns.Item("Med_Amb_C2");
            oColumn.DataBind.Bind("oMatrixDT", "Line");

            oMatrix.LoadFromDataSource();

            oNewItem          = oForm.Items.Add("NvLev", SAPbouiCOM.BoFormItemTypes.it_BUTTON);
            oNewItem.Top      = oItem.Top + 210;
            oNewItem.Width    = 180;
            oNewItem.Left     = 400;
            oNewItem.Height   = 19;
            oNewItem.FromPane = 10;
            oNewItem.ToPane   = 10;
            oNewItem.Visible  = true;
            oButton           = ((SAPbouiCOM.Button)(oNewItem.Specific));
            oButton.Caption   = "Novo levantamento";


            oNewItem          = oForm.Items.Add("Med_Cnf", SAPbouiCOM.BoFormItemTypes.it_MATRIX);
            oNewItem.Left     = 25;
            oNewItem.Width    = 300;
            oNewItem.Top      = oItem.Top + 250;
            oNewItem.Height   = 110;
            oNewItem.FromPane = 10;
            oNewItem.ToPane   = 10;

            oMatrix = ((SAPbouiCOM.Matrix)(oNewItem.Specific));
            oMatrix.SelectionMode = SAPbouiCOM.BoMatrixSelect.ms_Auto;
            oColumns = oMatrix.Columns;

            oColumn = oColumns.Add("#", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "#";
            oColumn.Width    = 30;
            oColumn.Editable = false;

            oColumn = oColumns.Add("Med_Cnf_C0", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Data";
            oColumn.Width    = 80;
            oColumn.Editable = true;

            oColumn = oColumns.Add("med_Cnf_C1", SAPbouiCOM.BoFormItemTypes.it_COMBO_BOX);
            oColumn.TitleObject.Caption = "Conferente";
            oColumn.Width    = 100;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Med_Cnf_C2", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Id";
            oColumn.Width    = 100;
            oColumn.Editable = true;
            oColumn.Visible  = false;

            oNewItem          = oForm.Items.Add("Med_Age", SAPbouiCOM.BoFormItemTypes.it_BUTTON);
            oNewItem.Top      = oItem.Top + 35;
            oNewItem.Width    = 80;
            oNewItem.Left     = 430;
            oNewItem.Height   = 19;
            oNewItem.FromPane = 10;
            oNewItem.ToPane   = 10;
            oNewItem.Visible  = true;
            oButton           = ((SAPbouiCOM.Button)(oNewItem.Specific));
            oButton.Caption   = "Agendar";

            oForm.DataSources.DataTables.Add("oDataTable");
            oForm.DataSources.DataTables.Item("oDataTable").ExecuteQuery("select * from [@FLX_FB_CONFMED] where U_FLX_FB_CONFMED_ID = '1'");

            oColumn = oColumns.Item("Med_Cnf_C0");
            oColumn.DataBind.Bind("oDataTable", "U_FLX_FB_CONFMED_DAT");
            oColumn = oColumns.Item("med_Cnf_C1");
            oColumn.DataBind.Bind("oDataTable", "U_FLX_FB_CONFMED_PRJ");
            oColumn = oColumns.Item("Med_Cnf_C2");
            oColumn.DataBind.Bind("oDataTable", "Code");
        }
コード例 #9
0
        private void SBO_Application_ItemEvent(string FormUID, ref SAPbouiCOM.ItemEvent pVal, out bool BubbleEvent)
        {
            SAPbouiCOM.BoEventTypes EventEnum = 0;
            EventEnum = pVal.EventType;
            BubbleEvent = true;

            if (pVal.FormType == 320)
            {
                if ((pVal.EventType == SAPbouiCOM.BoEventTypes.et_ITEM_PRESSED) & (!pVal.Before_Action))
                {
                    //Laudo_Ini
                    if (pVal.ItemUID == "Laudo_Ini")
                    {
                        abrirRelatorio("Laudo inicial", oForm.Items.Item("74").Specific.Value);
                    }

                    //Ent_Imp
                    if (pVal.ItemUID == "Ent_Imp")
                    {
                        abrirRelatorio("Descricao dos ambientes", oForm.Items.Item("74").Specific.Value);
                    }

                    //Laudo_Int
                    if (pVal.ItemUID == "Laudo_Int")
                    {
                        abrirRelatorio("Laudo intermediario", oForm.Items.Item("74").Specific.Value);
                    }
                    //NvAnalise
                    if (pVal.ItemUID == "NvAnalise")
                    {
                        abrirRelatorio("Analise critica", oForm.Items.Item("74").Specific.Value);
                    }
                    //Laudo_ent
                    if (pVal.ItemUID == "Laudo_Ent")
                    {
                        abrirRelatorio("Laudo de entrega", oForm.Items.Item("74").Specific.Value);
                    }
                    //Pesquisa de satisfacao
                    if (pVal.ItemUID == "Etg_Pq")
                    {
                        abrirRelatorio("Pesquisa de satisfacao", oForm.Items.Item("74").Specific.Value);
                    }
                    //NvLev
                    if (pVal.ItemUID == "NvLev")
                    {
                        abrirRelatorio("Levantamento", "");
                    }
                    //Etg_Decl
                    if (pVal.ItemUID == "Etg_Decl")
                    {
                        abrirRelatorio("Declaracao de conformidade", oForm.Items.Item("74").Specific.Value);
                    }

                }

                // Ao mudar o ambiente
                if (pVal.Before_Action && (EventEnum == SAPbouiCOM.BoEventTypes.et_COMBO_SELECT) && pVal.ItemUID == "Ent_Amb" && pVal.ItemChanged)
                {
                    // Verifica a descricao de Ent_Det se mudou e captura
                    oEditItem = ((SAPbouiCOM.EditText)oForm.Items.Item("Ent_Det").Specific);
                    string sEnt_Det = oEditItem.String;
                    try
                    {
                        if (sEnt_Det != sDescricaoOriginalAmbiente)
                        {
                            int idOOPR = int.Parse(((SAPbouiCOM.EditText)oForm.Items.Item("74").Specific).Value);
                            string selectedValue = ((SAPbouiCOM.ComboBox)oForm.Items.Item("Ent_Amb").Specific).Value;
                            int iSelectedValue;
                            if (selectedValue != "")
                            {
                                iSelectedValue = int.Parse(selectedValue);
                                // Atualiza a Descrição na Oportunidade de Vendas
                                AddOportunidadeVendas(idOOPR, "0", "0", "0", iSelectedValue, sEnt_Det);
                            }
                        }
                    }
                    catch
                    {
                    }
                }

                if (!pVal.Before_Action && (EventEnum == SAPbouiCOM.BoEventTypes.et_COMBO_SELECT) && pVal.ItemUID == "Ent_Amb" && pVal.ItemChanged)
                {
                    oEditItem = ((SAPbouiCOM.EditText)oForm.Items.Item("Ent_Det").Specific);

                    string idOOPR = ((SAPbouiCOM.EditText)oForm.Items.Item("74").Specific).Value;
                    string selectedValue = ((SAPbouiCOM.ComboBox)oForm.Items.Item("Ent_Amb").Specific).Value;

                    ambiente = new Ambiente(idOOPR);
                    oEditItem.Value = ambiente.getDescricaoEntrevista(selectedValue);
                }

                //Evento da Drop.

                if (!pVal.Before_Action && (EventEnum == SAPbouiCOM.BoEventTypes.et_COMBO_SELECT) & pVal.ItemChanged & (pVal.ItemUID == "Ela_Amb"))
                {
                    string coluna2 = pVal.ColUID;
                    if (coluna2 == "Ela_Amb_C2")
                    {
                        string linha = pVal.Row.ToString();
                    }
                }

                if (!pVal.Before_Action && (EventEnum == SAPbouiCOM.BoEventTypes.et_COMBO_SELECT) & pVal.ItemChanged & (pVal.ItemUID == "Ent_Proj"))
                {
                    upProjEnt = true;
                    //SBO_Application.MessageBox("Mudou Proj Entrevista.");
                }
                if (!pVal.Before_Action && (EventEnum == SAPbouiCOM.BoEventTypes.et_COMBO_SELECT) & pVal.ItemChanged & (pVal.ItemUID == "Med_Proj"))
                {
                    upProjMed = true;
                    //SBO_Application.MessageBox("Mudou Proj Medição.");
                }
                if (!pVal.Before_Action && (EventEnum == SAPbouiCOM.BoEventTypes.et_COMBO_SELECT) & pVal.ItemChanged & (pVal.ItemUID == "Apr_Proj"))
                {
                    upProjAps = true;
                    //SBO_Application.MessageBox("Mudou Proj Apresentação.");
                }
                if (!pVal.Before_Action && (EventEnum == SAPbouiCOM.BoEventTypes.et_COMBO_SELECT) & pVal.ItemChanged & (pVal.ItemUID == "Ent_Amb"))
                {
                    upEtvAmb = true;
                    //SBO_Application.MessageBox("Mudou Combo de Ambiente");
                }

                //Abre tela de Atividades.
                if (((pVal.ItemUID == "Ent_Age") & (pVal.EventType == SAPbouiCOM.BoEventTypes.et_ITEM_PRESSED) & (pVal.Before_Action == false)))
                {
                    bBotaoAgendarFoiClicado = true;
                    SBO_Application.ActivateMenuItem("2563");
                }

                //Abre tela de Atividades.
                if (((pVal.ItemUID == "Med_Age") & (pVal.EventType == SAPbouiCOM.BoEventTypes.et_ITEM_PRESSED) & (pVal.Before_Action == false)))
                {
                    bBotaoAgendarFoiClicado = true;
                    SBO_Application.ActivateMenuItem("2563");
                }

                //Clique do Botão Atualizar
                if (((pVal.ItemUID == "1") & (pVal.FormMode == 1) & (pVal.EventType == SAPbouiCOM.BoEventTypes.et_ITEM_PRESSED) & (pVal.Before_Action == false)))
                {
                    if (ambiente.possuiAmbientesCadastrados())
                    {
                       Atualizar();
                    }
                }

                //Criar os campos do formulario.
                if (pVal.Before_Action && pVal.EventType == SAPbouiCOM.BoEventTypes.et_FORM_LOAD)
                {
                    oForm = SBO_Application.Forms.GetFormByTypeAndCount(pVal.FormType, pVal.FormTypeCount);

                    AddItemsToForm();

                    oForm.Resize(300, 130);// (132, 100);

                    resumo = new Resumo(oForm);
                    fases = new Fases(oForm);
                }

                //Evento do Clique da aba Resumo.
                if (pVal.ItemUID == "Projeto1" & (pVal.EventType == SAPbouiCOM.BoEventTypes.et_ITEM_PRESSED || pVal.EventType == SAPbouiCOM.BoEventTypes.et_CLICK) & pVal.Before_Action)
                {
                    resumo.disableCampos();
                    oForm.PaneLevel = 8;
                }

                //Evento do Clique da aba Fases.
                if (pVal.ItemUID == "Projeto2" & (pVal.EventType == SAPbouiCOM.BoEventTypes.et_ITEM_PRESSED || pVal.EventType == SAPbouiCOM.BoEventTypes.et_CLICK) & pVal.Before_Action)
                {
                    oForm.PaneLevel = 9;
                }

                int panel = 9;
                if (pVal.ItemUID.StartsWith("Folder") & (pVal.EventType == SAPbouiCOM.BoEventTypes.et_ITEM_PRESSED || pVal.EventType == SAPbouiCOM.BoEventTypes.et_CLICK) & pVal.Before_Action)
                {
                    switch (pVal.ItemUID)
                    {
                        case "Folder1": panel = 9;
                            break;
                        case "Folder2": panel = 10;
                            break;
                        case "Folder3": panel = 11;
                            break;
                        case "Folder4": panel = 12;
                            break;
                        case "Folder5": panel = 13;
                            break;
                        case "Folder6": panel = 14;
                            break;
                        case "Folder7": panel = 15;
                            break;
                        case "Folder8": panel = 16;
                            break;
                        case "Folder9": panel = 17;
                            break;
                    }

                    oForm.PaneLevel = panel;
                }

                if (pVal.EventType == SAPbouiCOM.BoEventTypes.et_CHOOSE_FROM_LIST)
                {
                    SAPbouiCOM.IChooseFromListEvent oCFLEvento = ((SAPbouiCOM.IChooseFromListEvent)(pVal));
                    string sCFL_ID = oCFLEvento.ChooseFromListUID;
                    SAPbouiCOM.Form oForm = SBO_Application.Forms.Item(FormUID);
                    SAPbouiCOM.ChooseFromList oCFL = oForm.ChooseFromLists.Item(sCFL_ID);

                    if (oCFLEvento.BeforeAction == false && sCFL_ID == "CFL1")
                    {
                        SAPbouiCOM.DataTable oDataTable = oCFLEvento.SelectedObjects;
                        string valItemName = null;
                        string valItemCode = null;
                        try
                        {
                            valItemCode = System.Convert.ToString(oDataTable.GetValue(0, 0));
                            valItemName = System.Convert.ToString(oDataTable.GetValue(1, 0));

                            string qtdEstoque = GetQtdEmEstoque(valItemCode);
                            ((SAPbouiCOM.EditText)oMatrix.Columns.Item("Cmp_Amb_C4").Cells.Item(pVal.Row).Specific).Value = qtdEstoque;

                            ((SAPbouiCOM.EditText)oMatrix.Columns.Item("Cmp_Amb_C0").Cells.Item(pVal.Row).Specific).Value = valItemCode;
                            ((SAPbouiCOM.EditText)oMatrix.Columns.Item("Cmp_Amb_C1").Cells.Item(pVal.Row).Specific).Value = valItemName;
                        }
                        catch (Exception ex)
                        {
                        }
                    }
                    else if (oCFLEvento.BeforeAction == false && sCFL_ID == "CFL2")
                    {
                        SAPbouiCOM.DataTable oDataTable = oCFLEvento.SelectedObjects;
                        string valCarName = null;
                        string idFornecedor = null;
                        try
                        {
                            idFornecedor = System.Convert.ToString(oDataTable.GetValue(0, 0));
                            valCarName = System.Convert.ToString(oDataTable.GetValue(1, 0));

                            ((SAPbouiCOM.EditText)oMatrix.Columns.Item("Cmp_Amb_C6").Cells.Item(pVal.Row).Specific).Value = idFornecedor;
                            ((SAPbouiCOM.EditText)oMatrix.Columns.Item("Cmp_Amb_C3").Cells.Item(pVal.Row).Specific).Value = valCarName;
                        }
                        catch (Exception ex)
                        {
                        }
                    }
                }

                string coluna = pVal.ColUID;

                if (EventEnum == SAPbouiCOM.BoEventTypes.et_DOUBLE_CLICK && !pVal.BeforeAction)
                {
                    //Anexo de arquivo
                    if (coluna == "Ela_Amb_C7" || coluna == "Ela_Amb_C8" || coluna == "Ela_Amb_C9" || coluna == "Med_Amb_C1"
                                               || coluna == "Apv_Amb_C3" || coluna == "Ped_Amb_C7" || coluna == "Det_Amb_C7"
                                               || coluna == "Etg_Amb_C3" || coluna == "Mon_Amb_C3" || coluna == "Mon_Amb_C4"
                                               || coluna == "Mon_Amb_C5" || coluna == "Apv_Amb_C4" || coluna == "Ans_Amb_C0")
                    {
                        oNewItem = oForm.Items.Item(pVal.ItemUID);
                        oMatrix = ((SAPbouiCOM.Matrix)(oNewItem.Specific));
                        oEditItem = (SAPbouiCOM.EditText)oMatrix.Columns.Item(coluna).Cells.Item(pVal.Row).Specific;

                        GridComAnexo(oEditItem);
                    }

                    //Url
                    if (coluna == "Ped_Amb_C8" && ((SAPbouiCOM.EditText)oMatrix.Columns.Item("Ped_Amb_C8").Cells.Item(pVal.Row).Specific).Value != "")
                    {
                        newProcess = new Process();
                        string valor = ((SAPbouiCOM.EditText)oMatrix.Columns.Item("Ped_Amb_C8").Cells.Item(pVal.Row).Specific).Value;
                        info = new ProcessStartInfo(valor);
                        newProcess.StartInfo = info;
                        newProcess.Start();

                    }
                }

                if (EventEnum == SAPbouiCOM.BoEventTypes.et_LOST_FOCUS && !pVal.BeforeAction)
                {
                    if (coluna == "Cmp_Amb_C2")
                    {
                        oNewItem = oForm.Items.Item("Det_Cmp");
                        oMatrix = ((SAPbouiCOM.Matrix)(oNewItem.Specific));

                        string qtd = ((SAPbouiCOM.EditText)oMatrix.Columns.Item("Cmp_Amb_C2").Cells.Item(pVal.Row).Specific).String;
                        decimal teste = Convert.ToDecimal(qtd);
                        string estoque = ((SAPbouiCOM.EditText)oMatrix.Columns.Item("Cmp_Amb_C4").Cells.Item(pVal.Row).Specific).String;
                        decimal teste2 = Convert.ToDecimal(estoque);
                        if (qtd != "" && teste > teste2)
                        {
                            SBO_Application.MessageBox("Sem ítens sufucintes no estoque");
                        }
                    }
                }

                //Evento da grid de ambiente/análise crítica.
                if (!pVal.BeforeAction && pVal.ItemUID == "Apr_Amb" && EventEnum == SAPbouiCOM.BoEventTypes.et_CLICK && pVal.ColUID == "#" && pVal.Row > 0)
                {

                    if (modificouAnsCritica)
                    {
                        SBO_Application.MessageBox("Vai atualizar");
                        Atualizar();
                        oForm.Mode = SAPbouiCOM.BoFormMode.fm_OK_MODE;
                        modificouAnsCritica = false;
                    }

                    //Instancia a matriz de ambiente da aba apresentação.
                    oNewItem = oForm.Items.Item("Apr_Amb");
                    SAPbouiCOM.Matrix matrixApresentacao;
                    matrixApresentacao = ((SAPbouiCOM.Matrix)(oNewItem.Specific));

                    //Instancia a matriz de análise crítica da aba apresentação.
                    oNewItem = oForm.Items.Item("Ans_Amb");
                    SAPbouiCOM.Matrix matrixAnaliseCritica;
                    matrixAnaliseCritica = ((SAPbouiCOM.Matrix)(oNewItem.Specific));

                    //Pega a coluna onde vai setar os valores pra o ambiente na matriz de análise crítica.
                    oColumnsAnaliseCritica = matrixAnaliseCritica.Columns;
                    oColumnAnaliseCritica = oColumnsAnaliseCritica.Item("Ans_Amb_C0");

                    //Pega o id do ambiente e a descrição do ambiente.
                    oEditItem = (SAPbouiCOM.EditText)matrixApresentacao.Columns.Item("Apr_Amb_C2").Cells.Item(pVal.Row).Specific;
                    SAPbouiCOM.EditText oItemGrid = (SAPbouiCOM.EditText)matrixApresentacao.Columns.Item("Apr_Amb_C0").Cells.Item(pVal.Row).Specific;
                    idAmbiente = int.Parse(oEditItem.String);
                    string nomeGrid = oItemGrid.String;

                    //Mostra na matriz de análise crítica qual ambiente selecionado.
                    oColumnAnaliseCritica.TitleObject.Caption = "Analise Crítica (" + nomeGrid + ")";
                    LoadGridAnaliseCritica();
                    countMatrixAnaliseCriticaAntes = matrixAnaliseCritica.RowCount;

                    if (matrixAnaliseCritica.RowCount == 0)
                    {
                        matrixAnaliseCritica.AddRow(1, 1);
                    }
                }
                //Evento da grid de ambiente/análise crítica.
                if (!pVal.BeforeAction && pVal.ItemUID == "Ans_Amb" && EventEnum == SAPbouiCOM.BoEventTypes.et_KEY_DOWN && pVal.ColUID == "Ans_Amb_C0" && pVal.CharPressed == 9)
                {
                    oNewItem = oForm.Items.Item("Ans_Amb");
                    SAPbouiCOM.Matrix matrixAnaliseCritica;
                    matrixAnaliseCritica = ((SAPbouiCOM.Matrix)(oNewItem.Specific));

                    oEditItem = (SAPbouiCOM.EditText)matrixAnaliseCritica.Columns.Item("Ans_Amb_C0").Cells.Item(matrixAnaliseCritica.RowCount).Specific;
                    string nome = oEditItem.String;

                    if (matrixAnaliseCritica.RowCount > 0 && nome != "")
                    {
                        matrixAnaliseCritica.AddRow(1, matrixAnaliseCritica.RowCount + 1);
                        ((SAPbouiCOM.EditText)matrixAnaliseCritica.Columns.Item("Ans_Amb_C0").Cells.Item(matrixAnaliseCritica.RowCount).Specific).Value = "";
                        ((SAPbouiCOM.EditText)matrixAnaliseCritica.Columns.Item("Ans_Amb_C1").Cells.Item(matrixAnaliseCritica.RowCount).Specific).Value = "";
                    }
                }

                if (pVal.ItemUID == "Ans_Amb" && pVal.ColUID == "Ans_Amb_C0" && pVal.ItemChanged && !pVal.BeforeAction)
                {
                    SBO_Application.MessageBox("Teste");
                    modificouAnsCritica = true;
                }

                if (!pVal.BeforeAction && pVal.ItemUID == "Fab_Amb" && EventEnum == SAPbouiCOM.BoEventTypes.et_CLICK && pVal.ColUID == "Fab_#" && pVal.Row > 0)
                {
                    if (bGravouAvarias)
                    {
                        SBO_Application.MessageBox("Vai atualizar Avarias");
                        Atualizar();
                        oForm.Mode = SAPbouiCOM.BoFormMode.fm_OK_MODE;
                        bGravouAvarias = false;
                    }

                    oNewItem = oForm.Items.Item("Fab_Amb");
                    SAPbouiCOM.Matrix matrixFabrica;
                    matrixFabrica = ((SAPbouiCOM.Matrix)(oNewItem.Specific));

                    oNewItem = oForm.Items.Item("Ava_Amb");
                    SAPbouiCOM.Matrix matrixAvarias;
                    matrixAvarias = ((SAPbouiCOM.Matrix)(oNewItem.Specific));

                    SAPbouiCOM.Columns oColumnsAvarias = null;
                    SAPbouiCOM.Column oColumnAvarias = null;
                    oColumnsAvarias = matrixAvarias.Columns;
                    oColumnAvarias = oColumnsAvarias.Item("Ava_Amb_C0");

                    //Pega o id do ambiente e a descrição do ambiente.
                    oEditItem = (SAPbouiCOM.EditText)matrixFabrica.Columns.Item("Fab_Amb_C4").Cells.Item(pVal.Row).Specific;
                    SAPbouiCOM.EditText oItemGrid = (SAPbouiCOM.EditText)matrixFabrica.Columns.Item("Fab_Amb_C0").Cells.Item(pVal.Row).Specific;
                    iRowAmbiente = int.Parse(oEditItem.String);
                    string nomeGrid = oItemGrid.String;

                    oColumnAvarias.TitleObject.Caption = "Descrição (" + nomeGrid + ")";
                    LoadGridAvarias();
                    countMatrixAvariasAntes = matrixAvarias.RowCount;

                    if (matrixAvarias.RowCount == 0)
                    {
                        matrixAvarias.AddRow(1, 1);
                    }
                }

                if (!pVal.BeforeAction && pVal.ItemUID == "Ava_Amb" && EventEnum == SAPbouiCOM.BoEventTypes.et_KEY_DOWN && pVal.ColUID == "Ava_Amb_C0" && pVal.CharPressed == 9)
                {
                    oNewItem = oForm.Items.Item("Ava_Amb");
                    SAPbouiCOM.Matrix matrixAvarias;
                    matrixAvarias = ((SAPbouiCOM.Matrix)(oNewItem.Specific));

                    oEditItem = (SAPbouiCOM.EditText)matrixAvarias.Columns.Item("Ava_Amb_C0").Cells.Item(matrixAvarias.RowCount).Specific;
                    string nome = oEditItem.String;

                    if (matrixAvarias.RowCount > 0 && nome != "")
                    {
                        matrixAvarias.AddRow(1, matrixAvarias.RowCount + 1);
                        ((SAPbouiCOM.EditText)matrixAvarias.Columns.Item("Ava_Amb_C0").Cells.Item(matrixAvarias.RowCount).Specific).Value = "";
                        ((SAPbouiCOM.EditText)matrixAvarias.Columns.Item("Ava_Amb_C1").Cells.Item(matrixAvarias.RowCount).Specific).Value = "";
                    }
                }

                if (pVal.ItemUID == "Ava_Amb" && pVal.ColUID == "Ava_Amb_C0" && pVal.ItemChanged && !pVal.BeforeAction)
                {
                    SBO_Application.MessageBox("Teste Avarias");
                    bGravouAvarias = true;
                }

                //Evento da grid de ambiente/conferência medições.
                if (!pVal.BeforeAction && pVal.ItemUID == "Med_Amb" && EventEnum == SAPbouiCOM.BoEventTypes.et_CLICK && pVal.ColUID == "#" && pVal.Row > 0)
                {
                    //Instancia a matriz de ambiente da aba medições.
                    oNewItem = oForm.Items.Item("Med_Amb");
                    SAPbouiCOM.Matrix matrixMedicoes;
                    matrixMedicoes = ((SAPbouiCOM.Matrix)(oNewItem.Specific));

                    //Instancia a matriz de conferência medições da aba medições.
                    oNewItem = oForm.Items.Item("Med_Cnf");
                    SAPbouiCOM.Matrix matrixConferenciaMedicoes;
                    matrixConferenciaMedicoes = ((SAPbouiCOM.Matrix)(oNewItem.Specific));

                    //Pega a coluna onde vai setar os valores para o ambiente na matriz de conferência medições.
                    oColumnsConferenciaMedicoes = matrixConferenciaMedicoes.Columns;
                    oColumnConferenciaMedicoes = oColumnsConferenciaMedicoes.Item("med_Cnf_C1");

                    //Pega o id do ambiente e a descrição do ambiente.
                    oEditItem = (SAPbouiCOM.EditText)matrixMedicoes.Columns.Item("Med_Amb_C2").Cells.Item(pVal.Row).Specific;
                    SAPbouiCOM.EditText oItemGrid = (SAPbouiCOM.EditText)matrixMedicoes.Columns.Item("Med_Amb_C0").Cells.Item(pVal.Row).Specific;
                    iIdAmbienteMedicao = int.Parse(oEditItem.String);
                    string nomeGrid = oItemGrid.String;

                    //Mostra na matriz de conferência medições qual ambiente selecionado.
                    oColumnConferenciaMedicoes.TitleObject.Caption = "Conferente (" + nomeGrid + ")";
                    LoadGridConferenciaMedicao();
                    countMatrixConfMedAntes = matrixConferenciaMedicoes.RowCount;

                    if (matrixConferenciaMedicoes.RowCount == 0)
                    {
                        matrixConferenciaMedicoes.AddRow(1, 1);
                        //Projetistas - Grid Conferencia de Medicao
                        loadComboEmGrid("Med_Cnf", "med_Cnf_C1", projetistas);
                    }
                }
                //Evento da grid de ambiente/conferência medições.
                if (pVal.CharPressed == 9 && !pVal.BeforeAction && pVal.ItemUID == "Med_Cnf" && EventEnum == SAPbouiCOM.BoEventTypes.et_KEY_DOWN && pVal.ColUID == "med_Cnf_C1")
                {
                    oNewItem = oForm.Items.Item("Med_Cnf");
                    SAPbouiCOM.Matrix matrixConferenciaMedicao;
                    matrixConferenciaMedicao = ((SAPbouiCOM.Matrix)(oNewItem.Specific));

                    oEditItem = (SAPbouiCOM.EditText)matrixConferenciaMedicao.Columns.Item("Med_Cnf_C0").Cells.Item(matrixConferenciaMedicao.RowCount).Specific;
                    string data = oEditItem.String;
                    SAPbouiCOM.ComboBox combo = (SAPbouiCOM.ComboBox)matrixConferenciaMedicao.Columns.Item("med_Cnf_C1").Cells.Item(matrixConferenciaMedicao.RowCount).Specific;
                    string nome = combo.Value;

                    if (matrixConferenciaMedicao.RowCount > 0 && data != "" && nome != "")
                    {
                        matrixConferenciaMedicao.AddRow(1, matrixConferenciaMedicao.RowCount + 1);
                        ((SAPbouiCOM.EditText)matrixConferenciaMedicao.Columns.Item("Med_Cnf_C0").Cells.Item(matrixConferenciaMedicao.RowCount).Specific).Value = "";
                        //Projetistas - Grid Conferencia de Medicao
                        RemoveValoresDeCombo(ref combo);
                        loadComboEmGrid("Med_Cnf", "med_Cnf_C1", projetistas);
                        ((SAPbouiCOM.ComboBox)matrixConferenciaMedicao.Columns.Item("med_Cnf_C1").Cells.Item(matrixConferenciaMedicao.RowCount).Specific).Select("", SAPbouiCOM.BoSearchKey.psk_ByValue);
                        ((SAPbouiCOM.EditText)matrixConferenciaMedicao.Columns.Item("Med_Cnf_C2").Cells.Item(matrixConferenciaMedicao.RowCount).Specific).Value = "";

                    }
                }

                //Evento da grid de Entrega
                if (!pVal.BeforeAction && pVal.ItemUID == "Etg_Amb" && EventEnum == SAPbouiCOM.BoEventTypes.et_CLICK && pVal.ColUID == "Etg_#" && pVal.Row > 0)
                {

                    if (modificouPendecia)
                    {
                        SBO_Application.MessageBox("Vai atualizar Pendencia");
                        Atualizar();
                        oForm.Mode = SAPbouiCOM.BoFormMode.fm_OK_MODE;
                        modificouPendecia = false;
                    }

                    //Instancia a matriz de ambiente da aba apresentação.
                    oNewItem = oForm.Items.Item("Etg_Amb");
                    SAPbouiCOM.Matrix matrixEntrega;
                    matrixEntrega = ((SAPbouiCOM.Matrix)(oNewItem.Specific));

                    //Instancia a matriz de análise crítica da aba apresentação.
                    oNewItem = oForm.Items.Item("Pen_Amb");
                    SAPbouiCOM.Matrix matrixPendencia;
                    matrixPendencia = ((SAPbouiCOM.Matrix)(oNewItem.Specific));

                    //Pega a coluna onde vai setar os valores pra o ambiente na matriz de Pendencia.
                    oColumnsPendencia = matrixPendencia.Columns;
                    oColumnPendencia = oColumnsPendencia.Item("Pen_Amb_C0");

                    //Pega o id do ambiente e a descrição do ambiente.
                    oEditItem = (SAPbouiCOM.EditText)matrixEntrega.Columns.Item("Etg_Amb_C6").Cells.Item(pVal.Row).Specific;
                    SAPbouiCOM.EditText oItemGrid = (SAPbouiCOM.EditText)matrixEntrega.Columns.Item("Etg_Amb_C0").Cells.Item(pVal.Row).Specific;
                    idAmbientePendencia = int.Parse(oEditItem.String);
                    string nomeAmbiente = oItemGrid.String;

                    //Mostra na matriz de Pendencia qual ambiente selecionado.
                    oColumnPendencia.TitleObject.Caption = "Ambiente (" + nomeAmbiente + ")";
                    LoadGridPendencias();
                    countMatrixPendenciaAntes = matrixPendencia.RowCount;

                    if (matrixPendencia.RowCount == 0)
                    {
                        matrixPendencia.AddRow(1, 1);
                    }
                }
                //Evento da grid de ambiente/análise crítica.
                if (!pVal.BeforeAction && pVal.ItemUID == "Pen_Amb" && EventEnum == SAPbouiCOM.BoEventTypes.et_KEY_DOWN && pVal.ColUID == "Pen_Amb_C0" && pVal.CharPressed == 9)
                {
                    oNewItem = oForm.Items.Item("Pen_Amb");
                    SAPbouiCOM.Matrix matrixPendencia;
                    matrixPendencia = ((SAPbouiCOM.Matrix)(oNewItem.Specific));

                    oEditItem = (SAPbouiCOM.EditText)matrixPendencia.Columns.Item("Pen_Amb_C0").Cells.Item(matrixPendencia.RowCount).Specific;
                    string nome = oEditItem.String;

                    if (matrixPendencia.RowCount > 0 && nome != "")
                    {
                        matrixPendencia.AddRow(1, matrixPendencia.RowCount + 1);
                        ((SAPbouiCOM.EditText)matrixPendencia.Columns.Item("Pen_Amb_C0").Cells.Item(matrixPendencia.RowCount).Specific).Value = "";
                        ((SAPbouiCOM.EditText)matrixPendencia.Columns.Item("Pen_Amb_C1").Cells.Item(matrixPendencia.RowCount).Specific).Value = "";
                    }
                }

                if (pVal.ItemUID == "Pen_Amb" && pVal.ColUID == "Pen_Amb_C0" && pVal.ItemChanged && !pVal.BeforeAction)
                {
                    SBO_Application.MessageBox("Teste Pendencia");
                    modificouPendecia = true;
                }
            }

            if (pVal.FormType == 651)
            {
                if (pVal.EventType != SAPbouiCOM.BoEventTypes.et_FORM_UNLOAD)
                {
                    oFormAtual = SBO_Application.Forms.GetFormByTypeAndCount(pVal.FormType, pVal.FormTypeCount);

                    if (pVal.ItemUID == "Ata_Ativ" & pVal.EventType == SAPbouiCOM.BoEventTypes.et_ITEM_PRESSED & !pVal.Before_Action)
                    {
                        abrirRelatorio("Ata de reuniao", oFormAtual.Items.Item("5").Specific.Value);
                    }

                    if (!pVal.Before_Action && (pVal.EventType == SAPbouiCOM.BoEventTypes.et_COMBO_SELECT) & pVal.ItemChanged & (pVal.ItemUID == "67"))
                    {
                        if (oFormAtual.Items.Item("67").Specific.Value == "M")
                        {
                            atividade.habilitaBotaoAta();
                        }
                        else
                        {
                            atividade.desabilitaBotaoAta();
                        }
                    }

                    if (pVal.EventType == SAPbouiCOM.BoEventTypes.et_FORM_LOAD)
                    {

                        if (pVal.Before_Action)
                        {
                            atividade = new Atividade(oFormAtual);
                        }

                        if (bBotaoAgendarFoiClicado)
                        {
                            oFormPai = SBO_Application.Forms.GetFormByTypeAndCount(320, iUltimoFormTypeCount_SalesOpportunities);

                            sSalesOpportunities_Id = ((SAPbouiCOM.EditText)oFormPai.Items.Item("74").Specific).Value;
                            sBPCode = ((SAPbouiCOM.EditText)oFormPai.Items.Item("9").Specific).Value;

                            oFormAtual = SBO_Application.Forms.GetFormByTypeAndCount(pVal.FormType, pVal.FormTypeCount);

                            ((SAPbouiCOM.EditText)oFormAtual.Items.Item("9").Specific).Value = sBPCode;

                            bBotaoAgendarFoiClicado = false;
                        }
                    }
                }
            }
        }
コード例 #10
0
        private void desenharCampos()
        {
            oItem = oForm.Items.Item("7");

            oNewItem          = oForm.Items.Add("Laudo_Text", SAPbouiCOM.BoFormItemTypes.it_STATIC);
            oNewItem.Top      = oItem.Top + 60;
            oNewItem.Height   = 19;
            oNewItem.Width    = 150;
            oNewItem.Left     = 25;
            oNewItem.FromPane = 16;
            oNewItem.ToPane   = 16;
            oNewItem.Visible  = true;
            oTextItem         = ((SAPbouiCOM.StaticText)(oNewItem.Specific));
            oTextItem.Caption = "Laudo de vistoria inicial: ";

            oNewItem          = oForm.Items.Add("Ini_An", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oNewItem.Top      = oItem.Top + 60;
            oNewItem.Height   = 17;
            oNewItem.Width    = 250;
            oNewItem.Left     = 170;
            oNewItem.FromPane = 16;
            oNewItem.ToPane   = 16;
            oEditItem         = ((SAPbouiCOM.EditText)(oNewItem.Specific));
            //oEditItem.DataBind.SetBound(true, "OOPR", "U_FLX_FB_MTG_INICIAL");

            oNewItem          = oForm.Items.Add("Laudo_Ini", SAPbouiCOM.BoFormItemTypes.it_BUTTON);
            oNewItem.Top      = oItem.Top + 60;
            oNewItem.Width    = 200;
            oNewItem.Left     = 430;
            oNewItem.Height   = 20;
            oNewItem.FromPane = 16;
            oNewItem.ToPane   = 16;
            oNewItem.Visible  = true;
            oButton           = ((SAPbouiCOM.Button)(oNewItem.Specific));
            oButton.Caption   = "Novo laudo de vistoria inicial";

            oNewItem          = oForm.Items.Add("Mon_Text0", SAPbouiCOM.BoFormItemTypes.it_STATIC);
            oNewItem.Top      = oItem.Top + 80;
            oNewItem.Height   = 19;
            oNewItem.Width    = 350;
            oNewItem.Left     = 25;
            oNewItem.FromPane = 16;
            oNewItem.ToPane   = 16;
            oNewItem.Visible  = true;
            oTextItem         = ((SAPbouiCOM.StaticText)(oNewItem.Specific));
            oTextItem.Caption = "Ambiente / Pendências";

            oNewItem          = oForm.Items.Add("Mon_Amb", SAPbouiCOM.BoFormItemTypes.it_MATRIX);
            oNewItem.Left     = 25;
            oNewItem.Width    = 740;
            oNewItem.Top      = oItem.Top + 100;
            oNewItem.Height   = 120;
            oNewItem.FromPane = 16;
            oNewItem.ToPane   = 16;

            oMatrix  = ((SAPbouiCOM.Matrix)(oNewItem.Specific));
            oColumns = oMatrix.Columns;

            oColumn = oColumns.Add("Mon_#", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "#";
            oColumn.Width    = 30;
            oColumn.Editable = false;

            oColumn = oColumns.Add("Mon_Amb_C0", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Ambiente";
            oColumn.Width    = 80;
            oColumn.Editable = false;

            oColumn = oColumns.Add("Mon_Amb_C1", SAPbouiCOM.BoFormItemTypes.it_COMBO_BOX);
            oColumn.TitleObject.Caption = "Responsável";
            oColumn.Width    = 120;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Mon_Amb_C2", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Descrição";
            oColumn.Width    = 320;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Mon_Amb_C3", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Anexo Vistoria Int. 1";
            oColumn.Width    = 120;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Mon_Amb_C4", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Anexo Vistoria Int. 2";
            oColumn.Width    = 120;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Mon_Amb_C5", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Anexo Vistoria Int. 3";
            oColumn.Width    = 120;
            oColumn.Editable = true;

            oForm.DataSources.DataTables.Item("oMatrixDT").ExecuteQuery("SELECT T1.[Num], T1.[Descript], T0.* FROM OPR4 T0 INNER JOIN OOIN T1 ON T1.Num = T0.IntId WHERE T0.[OprId] = '1'");

            oColumn = oColumns.Item("Mon_Amb_C0");
            oColumn.DataBind.Bind("oMatrixDT", "Descript");

            oColumn = oColumns.Item("Mon_Amb_C1");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_MTG_RESPONS");

            oColumn = oColumns.Item("Mon_Amb_C2");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_MTG_DESCRIC");

            oColumn = oColumns.Item("Mon_Amb_C3");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_MTG_VSTINT1");

            oColumn = oColumns.Item("Mon_Amb_C4");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_MTG_VSTINT2");

            oColumn = oColumns.Item("Mon_Amb_C5");
            oColumn.DataBind.Bind("oMatrixDT", "U_FLX_FB_MTG_VSTINT3");

            //Botao Nova vistoria intermediaria
            oNewItem          = oForm.Items.Add("Laudo_Int", SAPbouiCOM.BoFormItemTypes.it_BUTTON);
            oNewItem.Top      = oItem.Top + 230;
            oNewItem.Width    = 200;
            oNewItem.Left     = 25;
            oNewItem.Height   = 25;
            oNewItem.FromPane = 16;
            oNewItem.ToPane   = 16;
            oNewItem.Visible  = true;
            oButton           = ((SAPbouiCOM.Button)(oNewItem.Specific));
            oButton.Caption   = "Novo laudo de vistoria intermediária";

            oNewItem          = oForm.Items.Add("Mon_OS", SAPbouiCOM.BoFormItemTypes.it_BUTTON);
            oNewItem.Top      = oItem.Top + 50;
            oNewItem.Width    = 100;
            oNewItem.Left     = 780;
            oNewItem.Height   = 25;
            oNewItem.FromPane = 16;
            oNewItem.ToPane   = 16;
            oNewItem.Visible  = true;
            oButton           = ((SAPbouiCOM.Button)(oNewItem.Specific));
            oButton.Caption   = "Gerar OS";

            oNewItem          = oForm.Items.Add("Mon_Text2", SAPbouiCOM.BoFormItemTypes.it_STATIC);
            oNewItem.Top      = oItem.Top + 80;
            oNewItem.Height   = 19;
            oNewItem.Width    = 60;
            oNewItem.Left     = 810;
            oNewItem.FromPane = 16;
            oNewItem.ToPane   = 16;
            oNewItem.Visible  = true;
            oTextItem         = ((SAPbouiCOM.StaticText)(oNewItem.Specific));
            oTextItem.Caption = "No. OS";

            oNewItem          = oForm.Items.Add("Mon_NoOS", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oNewItem.Top      = oItem.Top + 100;
            oNewItem.Height   = 17;
            oNewItem.Width    = 40;
            oNewItem.Left     = 810;
            oNewItem.FromPane = 16;
            oNewItem.ToPane   = 16;
            oNewItem.Enabled  = false;
            oEditItem         = ((SAPbouiCOM.EditText)(oNewItem.Specific));

            oNewItem          = oForm.Items.Add("Mon_Planej", SAPbouiCOM.BoFormItemTypes.it_BUTTON);
            oNewItem.Top      = oItem.Top + 150;
            oNewItem.Width    = 100;
            oNewItem.Left     = 780;
            oNewItem.Height   = 25;
            oNewItem.FromPane = 16;
            oNewItem.ToPane   = 16;
            oNewItem.Visible  = true;
            oButton           = ((SAPbouiCOM.Button)(oNewItem.Specific));
            oButton.Caption   = "Planejamento";

            oNewItem          = oForm.Items.Add("Mon_Text1", SAPbouiCOM.BoFormItemTypes.it_STATIC);
            oNewItem.Top      = oItem.Top + 285;
            oNewItem.Height   = 19;
            oNewItem.Width    = 350;
            oNewItem.Left     = 25;
            oNewItem.FromPane = 16;
            oNewItem.ToPane   = 16;
            oNewItem.Visible  = true;
            oTextItem         = ((SAPbouiCOM.StaticText)(oNewItem.Specific));
            oTextItem.Caption = "Itens Complementares";

            oNewItem          = oForm.Items.Add("Mon_Itc", SAPbouiCOM.BoFormItemTypes.it_MATRIX);
            oNewItem.Left     = 25;
            oNewItem.Width    = 880;
            oNewItem.Top      = oItem.Top + 305;
            oNewItem.Height   = 120;
            oNewItem.FromPane = 16;
            oNewItem.ToPane   = 16;

            oMatrix  = ((SAPbouiCOM.Matrix)(oNewItem.Specific));
            oColumns = oMatrix.Columns;

            oColumn = oColumns.Add("Itc_#", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "#";
            oColumn.Width    = 30;
            oColumn.Editable = false;

            oColumn = oColumns.Add("Itc_Amb_C0", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Item";
            oColumn.Width    = 40;
            oColumn.Editable = false;

            oColumn = oColumns.Add("Itc_Amb_C1", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Descrição";
            oColumn.Width    = 200;
            oColumn.Editable = false;

            oColumn = oColumns.Add("Itc_Amb_C8", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Estoque";
            oColumn.Width    = 40;
            oColumn.Editable = false;

            oColumn = oColumns.Add("Itc_Amb_C2", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Qtd";
            oColumn.Width    = 40;
            oColumn.Editable = false;

            oColumn = oColumns.Add("Itc_Amb_C3", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Fornecedor";
            oColumn.Width    = 150;
            oColumn.Editable = false;

            oColumn = oColumns.Add("Itc_Amb_C4", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Observação";
            oColumn.Width    = 200;
            oColumn.Editable = false;

            oColumn = oColumns.Add("Itc_Amb_C5", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Prz Entrega";
            oColumn.Width    = 80;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Itc_Amb_C6", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "Solicitante";
            oColumn.Width    = 100;
            oColumn.Editable = true;

            oColumn = oColumns.Add("Itc_Amb_C7", SAPbouiCOM.BoFormItemTypes.it_CHECK_BOX);
            oColumn.TitleObject.Caption = "Recebido";
            oColumn.Width       = 80;
            oColumn.Editable    = true;
            oColumn.DisplayDesc = true;
            oColumn.ValOn       = "1";
            oColumn.ValOff      = "0";

            oColumn = oColumns.Add("Itc_Amb_C9", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "idFornecedor";
            oColumn.Width    = 40;
            oColumn.Editable = false;
            oColumn.Visible  = false;

            oColumn = oColumns.Add("Itc_Amb_10", SAPbouiCOM.BoFormItemTypes.it_EDIT);
            oColumn.TitleObject.Caption = "idItensComp";
            oColumn.Width    = 40;
            oColumn.Editable = false;
            oColumn.Visible  = false;

            oForm.DataSources.DataTables.Item("oDataTableItc").ExecuteQuery("select T1.ItemCode, T1.ItemName, T1.OnHand, T0.U_FLX_FB_ITC_QTD, T2.CardCode, T2.CardName, T0.U_FLX_FB_ITC_OBS, T0.DocEntry, T0.U_FLX_FB_ITC_PRZETG, T0.U_FLX_FB_ITC_SOLICI, T0.U_FLX_FB_ITC_RECEB from [@FLX_FB_ITC] T0 inner join OITM T1 on T1.ItemCode = T0.U_FLX_FB_ITC_IDOITM inner join OCRD T2 on T2.CardCode = T0.U_FLX_FB_ITC_IDOCRD where T0.U_FLX_FB_ITC_IDOOPR = '1'");

            oColumn = oColumns.Item("Itc_Amb_C0");
            oColumn.DataBind.Bind("oDataTableItc", "ItemCode");

            oColumn = oColumns.Item("Itc_Amb_C1");
            oColumn.DataBind.Bind("oDataTableItc", "ItemName");

            oColumn = oColumns.Item("Itc_Amb_C8");
            oColumn.DataBind.Bind("oDataTableItc", "OnHand");

            oColumn = oColumns.Item("Itc_Amb_C2");
            oColumn.DataBind.Bind("oDataTableItc", "U_FLX_FB_ITC_QTD");

            oColumn = oColumns.Item("Itc_Amb_C9");
            oColumn.DataBind.Bind("oDataTableItc", "CardCode");

            oColumn = oColumns.Item("Itc_Amb_C3");
            oColumn.DataBind.Bind("oDataTableItc", "CardName");

            oColumn = oColumns.Item("Itc_Amb_C4");
            oColumn.DataBind.Bind("oDataTableItc", "U_FLX_FB_ITC_OBS");

            oColumn = oColumns.Item("Itc_Amb_10");
            oColumn.DataBind.Bind("oDataTableItc", "DocEntry");

            oColumn = oColumns.Item("Itc_Amb_C5");
            oColumn.DataBind.Bind("oDataTableItc", "U_FLX_FB_ITC_PRZETG");

            oColumn = oColumns.Item("Itc_Amb_C6");
            oColumn.DataBind.Bind("oDataTableItc", "U_FLX_FB_ITC_SOLICI");

            oColumn = oColumns.Item("Itc_Amb_C7");
            oColumn.DataBind.Bind("oDataTableItc", "U_FLX_FB_ITC_RECEB");
        }