//得到推荐给用户的音乐
public List <Modelmusicinfo> getRecommendMusic(int userId)
{
string musicstr = dalrecommend.queryRecommendMusicstr(userId);
if (musicstr == "")
{
return(bllmusicinfo.getMusicbyNewid());
}
else
{
DataSet set = dalmusicinfo.queryMusicList(musicstr);
int nums = set.Tables[0].Rows.Count;
List <Modelmusicinfo> list = new List <Modelmusicinfo>();
for (int i = 0; i < nums; i++)
{
Modelmusicinfo musicinfo = new Modelmusicinfo();
musicinfo.musicId = (int)set.Tables[0].Rows[i].ItemArray[0];
musicinfo.musicName = set.Tables[0].Rows[i].ItemArray[1].ToString();
musicinfo.musicSinger = set.Tables[0].Rows[i].ItemArray[6].ToString();
musicinfo.musicPath = set.Tables[0].Rows[i].ItemArray[7].ToString();
musicinfo.uploadUserId = (int)set.Tables[0].Rows[i].ItemArray[8];
list.Add(musicinfo);
}
return(list);
}
}
//分页查询音乐信息 singerName=""表示查询乐库中所有歌曲，singerName="XXX"表示查询某XXX歌手的歌
public List <Modelmusicinfo> pagequerymusic(int offset, int rows, string singerName)
{
List <Modelmusicinfo> list = new List <Modelmusicinfo>();
DataSet data;
if (singerName == "")
{
data = dalmusicinfo.pageQuery(offset, rows);
}
else
{
data = dalmusicinfo.pageQueryBySinger(offset, rows, singerName);
}
int nums = data.Tables[0].Rows.Count;
for (int i = 0; i < nums; i++)
{
Modelmusicinfo musicinfo = new Modelmusicinfo();
musicinfo.musicId = (int)data.Tables[0].Rows[i].ItemArray[1];
musicinfo.musicName = data.Tables[0].Rows[i].ItemArray[2].ToString();
musicinfo.musicRhythm = (int)data.Tables[0].Rows[i].ItemArray[3];
musicinfo.musicEmotion = (int)data.Tables[0].Rows[i].ItemArray[4];
musicinfo.musicType = (int)data.Tables[0].Rows[i].ItemArray[5];
musicinfo.musicLanguage = (int)data.Tables[0].Rows[i].ItemArray[6];
musicinfo.musicSinger = data.Tables[0].Rows[i].ItemArray[7].ToString();
musicinfo.musicPath = data.Tables[0].Rows[i].ItemArray[8].ToString();
musicinfo.uploadUserId = (int)data.Tables[0].Rows[i].ItemArray[9];
musicinfo.musicVolume = (int)data.Tables[0].Rows[i].ItemArray[10];
list.Add(musicinfo);
}
return(list);
}
//查询歌单中的歌曲
public List <Modelmusicinfo> queryMusicListBysongsheetId(string listidstr)
{
if (listidstr == null)
{
return(null);
}
DataSet data = dalmusicinfo.queryMusicList(listidstr);
if (data == null)
{
return(null);
}
else
{
List <Modelmusicinfo> list = new List <Modelmusicinfo>();
int rows = data.Tables[0].Rows.Count;
for (int i = 0; i < rows; i++)
{
Modelmusicinfo musicinfo = new Modelmusicinfo();
musicinfo.musicId = (int)data.Tables[0].Rows[i].ItemArray[0];
musicinfo.musicName = data.Tables[0].Rows[i].ItemArray[1].ToString();
musicinfo.musicSinger = data.Tables[0].Rows[i].ItemArray[6].ToString();
musicinfo.musicPath = data.Tables[0].Rows[i].ItemArray[7].ToString();
musicinfo.uploadUserId = (int)data.Tables[0].Rows[i].ItemArray[8];
list.Add(musicinfo);
}
return(list);
}
}
//保存音乐信息
public int insertMusicinfo(Modelmusicinfo musicinfo)
{
string sql = "insert into tbmusicinfo (music_name,music_rhythm,music_emotion,music_type,music_language,music_singer,music_path,upload_user_id)values('" + musicinfo.musicName + "'," + musicinfo.musicRhythm + "," + musicinfo.musicEmotion + "," + musicinfo.musicType + "," + musicinfo.musicLanguage + ",'" + musicinfo.musicSinger + "','" + musicinfo.musicPath + "'," + musicinfo.uploadUserId + ")";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
int temp = cmd.ExecuteNonQuery();
conn.Close();
return(temp);
}
//查询音乐item
public Modelmusicinfo querymusicitem(int id)
{
Modelmusicinfo musicinfo = new Modelmusicinfo();
DataSet data = dalmusicinfo.queryMusicItem(id);
musicinfo.musicName = data.Tables[0].Rows[0].ItemArray[0].ToString();
musicinfo.musicSinger = data.Tables[0].Rows[0].ItemArray[1].ToString();
musicinfo.musicPath = data.Tables[0].Rows[0].ItemArray[2].ToString();
musicinfo.musicId = id;
return(musicinfo);
}
//随机查询歌曲12首
public List <Modelmusicinfo> getMusicbyNewid()
{
DataSet data = dalmusicinfo.queryMusicbyNewid();
List <Modelmusicinfo> list = new List <Modelmusicinfo>();
int rows = data.Tables[0].Rows.Count;
for (int i = 0; i < rows; i++)
{
Modelmusicinfo musicinfo = new Modelmusicinfo();
musicinfo.musicId = (int)data.Tables[0].Rows[i].ItemArray[0];
musicinfo.musicName = data.Tables[0].Rows[i].ItemArray[1].ToString();
musicinfo.musicSinger = data.Tables[0].Rows[i].ItemArray[6].ToString();
musicinfo.musicPath = data.Tables[0].Rows[i].ItemArray[7].ToString();
musicinfo.uploadUserId = (int)data.Tables[0].Rows[i].ItemArray[8];
list.Add(musicinfo);
}
return(list);
}
//关键字搜索歌曲
public List <Modelmusicinfo> searchMusic(int offset, int rows, string keyword)
{
string[] keywords = System.Text.RegularExpressions.Regex.Split(keyword, @"\s{1,}");
DataSet data = daltools.querymusicByKeyword(offset, rows, keywords);
List <Modelmusicinfo> list = new List <Modelmusicinfo>();
int num = data.Tables[0].Rows.Count;
for (int i = 0; i < num; i++)
{
Modelmusicinfo musicinfo = new Modelmusicinfo();
musicinfo.musicId = (int)data.Tables[0].Rows[i].ItemArray[1];
musicinfo.musicName = data.Tables[0].Rows[i].ItemArray[2].ToString();
musicinfo.musicRhythm = (int)data.Tables[0].Rows[i].ItemArray[3];
musicinfo.musicEmotion = (int)data.Tables[0].Rows[i].ItemArray[4];
musicinfo.musicType = (int)data.Tables[0].Rows[i].ItemArray[5];
musicinfo.musicLanguage = (int)data.Tables[0].Rows[i].ItemArray[6];
musicinfo.musicSinger = data.Tables[0].Rows[i].ItemArray[7].ToString();
musicinfo.musicPath = data.Tables[0].Rows[i].ItemArray[8].ToString();
musicinfo.uploadUserId = (int)data.Tables[0].Rows[i].ItemArray[9];
list.Add(musicinfo);
}
return(list);
}
//上传音乐添加音乐信息
public int uploadmusic(Modelmusicinfo musicinfo)
{
return(dalmusicinfo.insertMusicinfo(musicinfo));
}
protected void upload_Click(object sender, EventArgs e)
{
Modelmusicinfo musicinfo = new Modelmusicinfo();
//select rhythm
if (kuai.Checked == true)
{
musicinfo.musicRhythm = 0;
}
else if (man.Checked == true)
{
musicinfo.musicRhythm = 1;
}
else
{
}
//select emotion
if (gaoxing.Checked == true)
{
musicinfo.musicEmotion = 0;
}
else if (shanggan.Checked == true)
{
musicinfo.musicEmotion = 1;
}
else if (huaijiu.Checked == true)
{
musicinfo.musicEmotion = 2;
}
else if (aiqing.Checked == true)
{
musicinfo.musicEmotion = 3;
}
else
{
}
//select type
if (liuxin.Checked == true)
{
musicinfo.musicType = 0;
}
else if (chunyinyue.Checked == true)
{
musicinfo.musicType = 1;
}
else if (mingyao.Checked == true)
{
musicinfo.musicType = 2;
}
else
{
}
//select language
if (ch.Checked == true)
{
musicinfo.musicLanguage = 0;
}
else if (en.Checked == true)
{
musicinfo.musicLanguage = 1;
}
else
{
}
musicinfo.musicName = musicname.Text;
musicinfo.musicSinger = musicsinger.Text;
if (musicinfo.musicName == "" || musicinfo.musicSinger == "")
{
Response.Write("<script>alert('歌曲名和歌手名为必填项');</script>");
}
else
{
//生成文件名字
string fileName = ((DateTime.Now.ToUniversalTime().Ticks - 621355968000000000) / 10000) + new Random().Next() + ".mp3";
//获得上传文件的完整路径
string fullFileName = "\\music\\" + fileName;
//获得上传文件大小
int fileLength = this.Fileupload.PostedFile.ContentLength;
string typestr = this.Fileupload.PostedFile.ContentType;
if (fileLength == 0)
{
Response.Write("<script>alert('请选择要上传的音乐文件');</script>");
}
else if (typestr != "audio/mp3")
{
Response.Write("<script>alert('系统目前仅支持MP3格式的文件');</script>");
}
else
{
musicinfo.musicPath = fullFileName;
musicinfo.uploadUserId = (int)Session["userid"];
if (fileLength < 104857600)
{
//把文件上传到服务器
Response.Write("<div id='list-table1' class='bg-white-only table-bordered padder-md padder-v' style='position: absolute; left: 30%; top: 15%; width: 30%; height: 300px;z-index:999'><h2>文件正在上传，请稍等，也不要刷新页面</h2></div>");
this.Fileupload.SaveAs(Server.MapPath("\\music\\" + fileName));
//把音乐信息存放在数据库
if (bllmusicinfo.uploadmusic(musicinfo) != 0)
{
Response.Write("<script>alert('歌曲上传成功');window.location.href='musicupload.aspx'</script>");
}
else
{
Response.Write("<script>alert('歌曲已经存在');</script>");
}
}
else
{
Response.Write("<script>alert('文件过大，超过系统限制');</script>");
}
}
}
}
