コード例 #1
0
        public override void UpdateInfo(AIOCommonInfo info)
        {
            base.UpdateInfo(info);
            AIOMusic     music = (AIOMusic)info;
            string       sql   = "update Music set Name = ?, ArtistID = ?, AlbumID = ? where ID =?";
            OleDbCommand cmd   = aioDb.CreateSqlWithParam(sql, new object[] { music.name, music.artist, music.album, music.ID });

            aioDb.ExecuteCommand(cmd);
        }
コード例 #2
0
 public override AIOCommonInfo Select(string ID)
 {
     AIOMusic music = new AIOMusic( base.Select( ID ) );
     string sql = "SELECT * FROM Music WHERE ID='" + ID + "'";
     DataTable DTMusic = aioDb.ExecuteSelect( sql );
     object[] obj = DTMusic.Rows[0].ItemArray;
     music.name = obj[1].ToString();
     music.album = obj[2].ToString();
     music.artist = obj[3].ToString();
     return music;
 }
コード例 #3
0
        public override AIOCommonInfo Select(string ID)
        {
            AIOMusic  music   = new AIOMusic(base.Select(ID));
            string    sql     = "SELECT * FROM Music WHERE ID='" + ID + "'";
            DataTable DTMusic = aioDb.ExecuteSelect(sql);

            object[] obj = DTMusic.Rows[0].ItemArray;
            music.name   = obj[1].ToString();
            music.album  = obj[2].ToString();
            music.artist = obj[3].ToString();
            return(music);
        }
コード例 #4
0
        public frmMusicInfo( AIODatabase aioDb, AIOMusicController controller, string ID )
        {
            //
            // Required for Windows Form Designer support
            //
            InitializeComponent();
            this.aioDb = aioDb;
            this.musicControler = ( AIOMusicController )controller;
            this.music = ( AIOMusic )this.musicControler.Select( ID );

            //
            // TODO: Add any constructor code after InitializeComponent call
            //
        }