public bool SearchRecordset(SAPbobsCOM.Recordset oRecordSet, string field, string value)
        {
            HelperRecordset hrs = new HelperRecordset();

            if (oRecordSet.RecordCount != 0)
            {
                oRecordSet.MoveFirst();
                for (int i = 0; i < oRecordSet.RecordCount; i++)
                {
                    var val = oRecordSet.Fields.Item(field).Value.ToString();
                    if (val.Trim() == value.Trim())
                    {
                        return true;
                    }

                    oRecordSet.MoveNext();
                }

                return false;
            }
            else
                return false;
        }
示例#2
0
        public void loadComboEmGrid(string matrix, string combo, SAPbobsCOM.Recordset valores)
        {
            oMatrix = checked((SAPbouiCOM.Matrix)oForm.Items.Item(matrix).Specific);
            SAPbouiCOM.ComboBox oCombo = checked((SAPbouiCOM.ComboBox)oMatrix.Columns.Item(combo).Cells.Item(1).Specific);
            RemoveValoresDeCombo(ref oCombo);

            oCombo.ValidValues.Add("", "");

            int RecCount = valores.RecordCount;
            valores.MoveFirst();

            for (int RecIndex = 0; RecIndex <= RecCount - 1; RecIndex++)
            {
                oCombo.ValidValues.Add(Convert.ToString(valores.Fields.Item(0).Value), Convert.ToString(valores.Fields.Item(1).Value));
                valores.MoveNext();
            }
        }
示例#3
0
        public void loadCombo(string combo, SAPbobsCOM.Recordset valores)
        {
            string sPrimeirovalorCombo = "";
            oNewItem = oForm.Items.Item(combo);
            SAPbouiCOM.ComboBox oCombo = ((SAPbouiCOM.ComboBox)(oNewItem.Specific));
            RemoveValoresDeCombo(ref oCombo);

            oCombo.ValidValues.Add("", "");

            int RecCount = valores.RecordCount;
            valores.MoveFirst();

            for (int RecIndex = 0; RecIndex <= RecCount - 1; RecIndex++)
            {
                //Se for combo de ambientes da aba de Entrevista
                if ((combo == "Ent_Amb") & (RecIndex == 0))
                    sPrimeirovalorCombo = valores.Fields.Item(0).Value.ToString();
                oCombo.ValidValues.Add(Convert.ToString(valores.Fields.Item(0).Value), Convert.ToString(valores.Fields.Item(1).Value));
                valores.MoveNext();
            }

            //Se for combo de ambientes da aba de Entrevista
            if (combo == "Ent_Amb")
            {
                oCombo.Select(sPrimeirovalorCombo, SAPbouiCOM.BoSearchKey.psk_ByValue);
            }
        }