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