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);
}
