//添加歌曲
public bool addSong(SoundSong add)
{
bool flag = false;
string cmdText = "Pr_AddSong";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@Category", add.Category),
new SqlParameter("@Name", add.Name),
new SqlParameter("@Singer", add.Singer),
new SqlParameter("@Content",add.Content),
new SqlParameter("@MemId",add.MemId)
};
int res = (sqlhelper.ExecuteNonQuery(cmdText, paras, CommandType.StoredProcedure));
if (res > 0)
{
flag = true;
}
return flag;
}
//protected void BSearch_Click(object sender, EventArgs e)
//{
// string key = TBSearch.Text.Trim();
// string action = DropDownList.SelectedValue;
// if (key == "")
// {
// showMessage.JsHistory(this, "搜索内容不能为空！", -1);
// return;
// }
// Response.Redirect("~/search.aspx?key=" + Server.UrlEncode(key) + "&action=" + action);
//}
protected void upButton_Click(object sender, EventArgs e)
{
string name = Session["name"].ToString();
string[] allowExtensions = { ".mp3" };
int maxLength = 10;
string savePath = Server.MapPath("../music/") + name + "/";
string saveName = TBUpName.Text.Trim().ToString() + ".mp3";
Upload(FileUpload, allowExtensions, maxLength, savePath, saveName);
SoundMember m = new SoundMemberManager().selectMemByName(name);
string Name = TBUpName.Text.Trim().ToString();//5_1_a_s_p_x
string Category = TBUpCategory.Text.Trim().ToString();
string Singer = TBUpSonger.Text.Trim().ToString();
string Content = savePath + saveName;
string MemId = m.Id;
SoundSong s = new SoundSong();
s.Name = Name;
s.Category = Category;
s.Singer = Singer;
s.Content = Content;
s.MemId = MemId;
new SoundSongManager().addSong(s);
}
//通过歌曲id查找歌曲
public SoundSong selectSongById(string id)
{
SoundSong s = new SoundSong();
string cmdText = "select category,[name],[content],singer,createTime,clickCount,memId,id from song where id=@id";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@id",id)
};
DataTable dt = new DataTable();
dt = sqlhelper.ExecuteQuery(cmdText, paras, CommandType.Text);
s.Id = dt.Rows[0]["id"].ToString();
s.Category = dt.Rows[0]["category"].ToString();
s.Name = dt.Rows[0]["name"].ToString();
s.Content = dt.Rows[0]["content"].ToString();
s.Singer = dt.Rows[0]["singer"].ToString();
s.CreateTime = dt.Rows[0]["createTime"].ToString();
s.ClickCount = dt.Rows[0]["clickCount"].ToString();
s.MemId = dt.Rows[0]["memId"].ToString();
return s;
}
public bool addSong(SoundSong add)
{
return sdao.addSong(add);
}
