public static bool Add(Music music) { //SQL入库 string sql = "INSERT INTO MusicList(Name,Singer,FilePath,AudioName,LyricName) VALUES('{0}','{1}','{2}','{3}','{4}'); "; sql = string.Format(sql, music.Name, music.Singer, music.Filepath, music.Audioname, music.Lyricname); if (SqlHelper.ExecuteNonQuery(constr, CommandType.Text, sql) > 0) { return true; } else { return false; } }
public static Music get(string id) { string sql = string.Format("SELECT * FROM MusicList where ID='{0}'", id); DataSet ds = SqlHelper.ExecuteDataset(constr, CommandType.Text, sql); //将数据库二维表数据转换成实体类对象数据 ORM(对象关系映射) DataRow row = ds.Tables[0].Rows[0]; Music music = new Music(); music.Id = Convert.ToInt32(row["ID"]); music.Name = Convert.ToString(row["Name"]); music.Singer = Convert.ToString(row["Singer"]); music.Filepath = Convert.ToString(row["FilePath"]); music.Audioname = Convert.ToString(row["AudioName"]); music.Lyricname = Convert.ToString(row["LyricName"]); return music; }
/// <summary> /// asp.net上传文件时,默认服务端只能接受4MB大小的文件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnUpload_Click(object sender, EventArgs e) { Music music = new Music(); music.Name = txtName.Text.Trim(); music.Singer = txtSinger.Text.Trim(); music.Filepath = "/Resourses/Audios"; string filename = DateTime.Now.ToString("yyyyMMddHHmmss"); music.Audioname = string.Format("{0}.mp3", filename); music.Lyricname = string.Format("{0}.lcr", filename); string path = Server.MapPath("~/Resourses/Audios"); this.Audio.SaveAs(string.Format("{0}/{1}", path, music.Audioname)); this.lyric.SaveAs(string.Format("{0}/{1}", path, music.Lyricname)); //将music对象数据入库 if (MusicServies.Add(music)) { txtName.Text = ""; txtSinger.Text = ""; } }
public static List<Music> GetsList() { List<Music> listmusic = new List<Music>(); Music music = new Music(); string sqlstr = @"select * from MusicList"; DataSet ds = SqlHelper.ExecuteDataset(constr, CommandType.Text, sqlstr); foreach (DataRow row in ds.Tables[0].Rows) { music.Id = Convert.ToInt32(row["ID"]); music.Name = Convert.ToString(row["Name"]); music.Singer = Convert.ToString(row["Singer"]); music.Filepath = Convert.ToString(row["FilePath"]); music.Audioname = Convert.ToString(row["AudioName"]); music.Lyricname = Convert.ToString(row["LyricName"]); listmusic.Add(music); } return listmusic; }
public static bool Add(Music music) { return MusicDao.Add(music); }