예제 #1
0
        public static UpdateReview GetNewVersionFiles(Int32 curVersion, String connection)
        {
            MySqlParameter[] param = new MySqlParameter[2];

            param[0] = new MySqlParameter("_versionDesc", 'c');

            param[1] = new MySqlParameter("_Curver", curVersion);

            UpdateReview u = null;

            DbAccessLayer.MySqlDbAccess db = new MySqlDbAccess(connection, ConnectionStringSourceType.MySetting);

            IDataReader reader = db.GetDataReaderFromProcedure("stpDad_updateSelCurrentVersion", param);

            if (db.HasError)
            {
                throw db.ErrorException;
            }

            if (reader.Read())
            {
                u = GetUpdateReviewFromReader(reader);
            }
            reader.Close();

            return(u);
        }
예제 #2
0
        private static UpdateReview GetUpdateReviewFromReader(IDataReader reader)
        {
            if (reader == null)
            {
                return(null);
            }

            UpdateReview param = new UpdateReview();

            param.updContent = DbAccessLayer.MySqlDataHelper.GetBytes(reader, "updContent");

            param.updVersion = DbAccessLayer.MySqlDataHelper.GetInt(reader, "updVersion");

            param.updVersionName = DbAccessLayer.MySqlDataHelper.GetString(reader, "updVersionName");

            param.updFileName = DbAccessLayer.MySqlDataHelper.GetString(reader, "updFileName");

            return(param);
        }