Esempio n. 1
0
        public List<Parameter> GetFilterColumns(XsdDataBase.TBL_FilterRow filtro, int id_Objeto)
        {
            var param = new List<Parameter>();
            var filterFields = filtro.GetTBL_Filter_FieldRows();

            foreach (var Flt in filterFields)
            {
                var field = (TBL_FieldRow)(TBL_Field.Select("fk_Object = " + id_Objeto + " AND Field_Name = '" + Flt.Field_Name + "'")[0]);

                var direction = (ParameterDirection)(Enum.Parse(typeof(ParameterDirection), field.Direction));
                var fType = (DbType)(Enum.Parse(typeof(DbType), field.Field_Type));

                param.Add(new Parameter(field.Field_Name, fType, "", field.Specific_Type, field.Is_Nullable, field.Max_Length, field.Precision, field.Scale, direction));
            }

            return param;
        }