Exemple #1
0
        /// <summary>
        /// 根据参数条件筛选数据
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="sql"></param>
        /// <param name="param"></param>
        /// <returns></returns>
        public IEnumerable <T> Query <T>(string sql, dynamic param,
                                         IDbConnection conn, IDbTransaction transaction) where T : class
        {
            CacheInfo cacheInfo = new CacheInfo();

            if (param != null)
            {
                var identity = new Identity(sql, CommandType.Text, conn, null, param == null ? null : param.GetType(), null);
                cacheInfo.ParamReader = SqlCached.CreateParamInfoGenerator(identity, false);
            }

            IDbCommand cmd = null;

            try
            {
                cmd = SetupCommand(sql, cacheInfo.ParamReader, param, CommandType.Text, conn, transaction);
                IDataReader reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    DynamicBuilder <T> builder = DynamicBuilder <T> .CreateBuilder(reader);

                    yield return(builder.Build(reader));
                }
                reader.Close();
            }
            finally
            {
                if (cmd != null)
                {
                    cmd.Dispose();
                }
            }
        }
Exemple #2
0
        /// <summary>
        /// 执行SQL 语句
        /// </summary>
        /// <param name="sql"></param>
        /// <param name="param"></param>
        /// <param name="cmdType"></param>
        /// <param name="conn"></param>
        /// <param name="transaction"></param>
        private int Execute(string sql, object param, CommandType cmdType,
                            IDbConnection conn, IDbTransaction transaction)
        {
            CacheInfo cacheInfo = new CacheInfo();

            if (param != null)
            {
                var identity = new Identity(sql, cmdType, conn, null, param == null ? null : param.GetType(), null);
                cacheInfo.ParamReader = SqlCached.CreateParamInfoGenerator(identity, false);
            }

            int result = ExecuteCommandByParamReader(sql, param == null ? null : cacheInfo.ParamReader, param, cmdType, conn, transaction);

            return(result);
        }