コード例 #1
0
        /// <summary>
        /// 根据条件获取一个实体对象
        /// </summary>
        public MemcachedGetFrequencyEntity Select(string where)
        {
            DbCommand cmd = DB.DbProviderFactory.CreateCommand();

            cmd.CommandText = "select * from MemcachedGetFrequency with(nolock) where " + where;
            cmd.CommandType = System.Data.CommandType.Text;

            DataSet ds = DB.ExecuteDataSet(cmd);

            if (ds.Tables[0].Rows.Count == 0)
            {
                return(null);
            }

            DataRow dr = ds.Tables[0].Rows[0];

            return(MemcachedGetFrequencyEntity.CreateEntity(dr));
        }
コード例 #2
0
        /// <summary>
        /// 根据主键获取一个实体对象
        /// </summary>
        public MemcachedGetFrequencyEntity Select(int MemcachedGetFrequencyId)
        {
            DbCommand cmd = DB.DbProviderFactory.CreateCommand();

            cmd.CommandText = "select * from MemcachedGetFrequency with(nolock) where MemcachedGetFrequencyId=@MemcachedGetFrequencyId";
            cmd.CommandType = System.Data.CommandType.Text;

            DB.AddInParameter(cmd, "MemcachedGetFrequencyId", DbType.Int32, MemcachedGetFrequencyId);
            DataSet ds = DB.ExecuteDataSet(cmd);

            if (ds.Tables[0].Rows.Count == 0)
            {
                return(null);
            }

            DataRow dr = ds.Tables[0].Rows[0];

            return(MemcachedGetFrequencyEntity.CreateEntity(dr));
        }