コード例 #1
0
        private void _Test(QueryTypeInstance queryType, IDbConnection connection)
        {
            var _ins = new Dictionary <int, string>();

            _ins.Add(1, "1");
            var _parts = new Dictionary <int, bool>();

            _parts.Add(1, true);
            var    preparedSql = queryType.ConstructSql(_ins, _parts);
            string sql         = preparedSql.Item1;

            using (var command = connection.CreateCommand())
            {
                connection.Open();
                command.CommandText = sql;
                foreach (var item in preparedSql.Item2)
                {
                    var parameter = command.CreateParameter();
                    parameter.ParameterName = item.Key;
                    parameter.Value         = item.Value;
                    command.Parameters.Add(parameter);
                }
                using (var reader = command.ExecuteReader())
                {
                    var dataTable = new DataTable();
                    dataTable.Load(reader);
                }
            }
        }
コード例 #2
0
        public QueryTypeInstance _GetQueryTypeByID(WebBuilderEFContext db, int queryTypeID)
        {
            QueryType type = this._GetQueryType(db, queryTypeID);
            List <QueryTypeInInstance>     ins     = this._GetQueryTypeIns(db, queryTypeID);
            List <QueryTypeOutInstance>    outs    = this._GetQueryTypeOuts(db, queryTypeID);
            List <QueryTypeTableInstance>  tables  = this._GetQueryTypeTables(db, queryTypeID);
            List <QueryTypeColumnInstance> columns = this._GetQueryTypeColumns(db, queryTypeID);
            List <QueryTypePart>           parts   = this._GetQueryTypeParts(db, queryTypeID);

            QueryTypeInstance queryType = new QueryTypeInstance(type, ins, outs, parts, tables, columns);

            return(queryType);
        }