public bool Delete(Model.T_Music model)
{
//读取配置文件中的相关节点信息：数据库连接字符串
string setting = ConfigurationManager.ConnectionStrings["connstring"].ToString();
//创建数据库对象
SqlConnection myconn = new SqlConnection(setting);
//打开连接
myconn.Open();
//创建命令对象，并准备好操作数据库的SQL语句
SqlCommand cmd = new SqlCommand("delect from T_Music where Id=@id", myconn);
//为SQL语句匹配相关参数，并赋值
cmd.Parameters.AddWithValue("@id", model.Id);
//执行相关SQL语句并返回受影响的行数，若受影响行数大于0，则表示执行成功，否者，执行失败
if (cmd.ExecuteNonQuery() > 0)
{
cmd.Dispose();
myconn.Dispose();
return(true);
}
else
{
cmd.Dispose();
myconn.Dispose();
return(false);
}
}
public bool Update(Model.T_Music model)
{
//读取配置文件中的相关节点信息：数据库连接字符串
string setting = ConfigurationManager.ConnectionStrings["connstring"].ToString();
SqlConnection myconn = new SqlConnection(setting);
myconn.Open();
SqlCommand cmd = new SqlCommand("update T_Stu set MusicName=@musicname,MusicPath=@musicpath,LyricPath=@lyricpath,StyleId=@styleid,SingerId=@singerid AddDate=@adddate where Id=@id", myconn);
cmd.Parameters.AddWithValue("@musicname", model.MusicName);
cmd.Parameters.AddWithValue("@musicpath", model.MusicPath);
cmd.Parameters.AddWithValue("@lyricpath", model.LyricPath);
cmd.Parameters.AddWithValue("@styleid", model.StyleId);
cmd.Parameters.AddWithValue("@singerid", model.SingerId);
cmd.Parameters.AddWithValue("@adddate", DateTime.Now);
if (cmd.ExecuteNonQuery() > 0)
{
cmd.Dispose();
myconn.Dispose();
return(true);
}
else
{
cmd.Dispose();
myconn.Dispose();
return(false);
}
}
public bool Add(Model.T_Music model)
{
//读取配置文件中的相关节点信息：数据库连接字符串
string setting = ConfigurationManager.ConnectionStrings["connstring"].ToString();
//创建数据库对象
SqlConnection myconn = new SqlConnection(setting);
//打开连接
myconn.Open();
//创建命令对象，并准备好操作数据库的SQL语句
SqlCommand cmd = new SqlCommand("insert into T_Music([MusicName],[MusicPath],[LyricPath],[StyleId],[SingerId]) values (@musicname,@musicpath,@lyricpath,@styleid,@singerid)", myconn);
//为SQL语句匹配相关参数，并赋值
cmd.Parameters.AddWithValue("@musicname", model.MusicName);
cmd.Parameters.AddWithValue("@musicpath", model.MusicPath);
cmd.Parameters.AddWithValue("@lyricpath", model.LyricPath);
cmd.Parameters.AddWithValue("@styleid", model.StyleId);
cmd.Parameters.AddWithValue("@singerid", model.SingerId);
//执行相关SQL语句并返回受影响的行数，若受影响行数大于0，则表示执行成功，否者，执行失败
if (cmd.ExecuteNonQuery() > 0)
{
cmd.Dispose();
myconn.Dispose();
return(true);
}
else
{
cmd.Dispose();
myconn.Dispose();
return(false);
}
}
//上传歌曲
private void UpLoad()
{
Boolean FileOK = false;
Boolean MusicOK = true;
//Boolean LyricOK = false;
string Musicpath = Server.MapPath("~/File/Mp3/");
string Lyricpath = Server.MapPath("~/File/Lyric/");
if (UpLoadMusic.HasFile)
{
String MusicExtension = System.IO.Path.GetExtension(UpLoadMusic.FileName).ToLower();
String LyricExtension = System.IO.Path.GetExtension(LyricUpload.FileName).ToLower();
String[] allowedMusicExtensions = { ".mp3", ".wma", ".wav" };
//for (int i = 0; i < allowedMusicExtensions.Length; i++)
//{
// if (MusicExtension == allowedMusicExtensions[i])
// {
// FileOK = true;
// }
//}
if (LyricExtension == ".lrc" && MusicOK)
{
FileOK = true;
}
}
if (FileOK)
{
try
{
//歌曲，歌词上传到服务器
UpLoadMusic.PostedFile.SaveAs(Musicpath + UpLoadMusic.FileName);
LyricUpload.PostedFile.SaveAs(Lyricpath + LyricUpload.FileName);
//int =
//str = str.Remove(0, i);
//文件路径等信息写入数据库
Model.T_Music Music = new Model.T_Music();
Music.MusicName = UpLoadMusic.FileName.Substring(0, UpLoadMusic.FileName.LastIndexOf("."));
Music.MusicPath = @"\web\File\Mp3\" + UpLoadMusic.FileName;
Music.LyricPath = @"\web\File\Mp3\" + LyricUpload.FileName;
Music.StyleId = Convert.ToInt32(DropDownList1.SelectedValue);
Music.SingerId = Convert.ToInt32(DpDSinger.SelectedValue);
BLL.T_Music MusicBll = new BLL.T_Music();
if (MusicBll.Add(Music))
{
//上传成功，给出提示
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), Guid.NewGuid().ToString(), "alert('Upload Successfully')", true);
//Response.Write("<script><alert>上传成功</alert></script>");
//Response.Redirect("Login.aspx");
}
//else
//{
// //上传失败，给出提示
// Page.ClientScript.RegisterStartupScript(this.GetType(), Guid.NewGuid().ToString(), "alert('歌曲上传失败，请稍后重试')", true);
// //Response.Write("保存失败");
//}
}
catch (Exception ex)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), Guid.NewGuid().ToString(), "alert('Upload failed')", true);
}
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), Guid.NewGuid().ToString(), "alert('Wrong format')", true);
}
}
//增加
public bool Add(Model.T_Music model)
{
return(db.Add(model));
}
