public static void DeleteByMid(int mid) { TianLaiDBDataContext db = new TianLaiDBDataContext(); var item = db.Music.FirstOrDefault(p => p.Mid == mid); db.Music.DeleteOnSubmit(item); db.SubmitChanges(); }
public static void DeleteByAid(int aid) { TianLaiDBDataContext db = new TianLaiDBDataContext(); var item = db.Album.FirstOrDefault(p => p.Aid == aid); db.Album.DeleteOnSubmit(item); db.SubmitChanges(); }
public static void DeleteList(int mid,string uid) { TianLaiDBDataContext db = new TianLaiDBDataContext(); var item = db.PlayList.FirstOrDefault(p => p.Mid == mid&&p.Uid==uid); db.PlayList.DeleteOnSubmit(item); db.SubmitChanges(); }
public static void DeleteBySid(int sid) { TianLaiDBDataContext db = new TianLaiDBDataContext(); var item = db.Singer.FirstOrDefault(p => p.Sid == sid); db.Singer.DeleteOnSubmit(item); db.SubmitChanges(); }
public static UserInfo userinfo(string uid) { TianLaiDBDataContext db = new TianLaiDBDataContext(); var result = db.UserInfo.FirstOrDefault(p => p.Uid == uid); return(result); }
public static void DeleteListAll(string uid) { TianLaiDBDataContext db = new TianLaiDBDataContext(); var item = db.PlayList.Where(p => p.Uid == uid); db.PlayList.DeleteAllOnSubmit(item); db.SubmitChanges(); }
public static IEnumerable<Album> SearchByAlbum(string name) { TianLaiDBDataContext db = new TianLaiDBDataContext(); string sql = "select * from Album where Aname like '%" + name + "%'"; var result = db.ExecuteQuery<Album>(sql); return result; }
public static void DeletePlayListAll() { TianLaiDBDataContext db = new TianLaiDBDataContext(); db.PlayList.DeleteAllOnSubmit(db.PlayList); db.SubmitChanges(); }
public ActionResult AddMusic([Bind(Exclude="Mid")] Music music) { foreach (string upload in Request.Files) { string path = AppDomain.CurrentDomain.BaseDirectory + "uploads/"; string filename = Path.GetFileName(Request.Files[upload].FileName); if (filename.ToLower().IndexOf(".mp3") == -1) { Response.Write("<div style='color:Red;'>请上传mp3格式文件!</div>"); return View(); } Request.Files[upload].SaveAs(Path.Combine(path, filename)); music.Url = "../../uploads/" + filename; } if (ModelState.IsValid) { try { TianLaiDBDataContext db = new TianLaiDBDataContext(); db.Music.InsertOnSubmit(music); db.SubmitChanges(); return Content("<label style='color:#35006A'>操作成功!</label>"); } catch (Exception ex) { ex.ToString(); return Content("<label style='color:Red'>操作失败!</label>"); } } else return View(music); }
public static IEnumerable<Singer> SearchBySname(string name) { TianLaiDBDataContext db = new TianLaiDBDataContext(); string sql="select * from Singer where Sname like '%"+name+"%'"; var result = db.ExecuteQuery<Singer>(sql); return result; }
public static IEnumerable <Album> SearchByAlbum(string name) { TianLaiDBDataContext db = new TianLaiDBDataContext(); string sql = "select * from Album where Aname like '%" + name + "%'"; var result = db.ExecuteQuery <Album>(sql); return(result); }
public static IEnumerable <Music> SearchByMname(string name) { TianLaiDBDataContext db = new TianLaiDBDataContext(); string sql = "select * from Music where Mname like '%" + name + "%'"; var result = db.ExecuteQuery <Music>(sql); return(result); }
public static void DeleteList(int mid, string uid) { TianLaiDBDataContext db = new TianLaiDBDataContext(); var item = db.PlayList.FirstOrDefault(p => p.Mid == mid && p.Uid == uid); db.PlayList.DeleteOnSubmit(item); db.SubmitChanges(); }
protected void Page_Load(object sender, EventArgs e) { UserInfo uinfo=(UserInfo)Session["CurrentUser"]; if (uinfo == null) { m = "<a href='../Member/LogOn' id='inin0'>登录</a>"; } else { m = "<a href='../Member/Index?uid="+uinfo.Uid+"' id='inin0' style='color:Red'>"+uinfo.Uname+"</a>"; } TianLaiDBDataContext db = new TianLaiDBDataContext(); int count=db.Music.Count(); Random random = new Random(); s = random.Next(count+1); }
public ActionResult AddAlbum([Bind(Exclude="Aid")] Album album) { if (ModelState.IsValid) { try { TianLaiDBDataContext db = new TianLaiDBDataContext(); db.Album.InsertOnSubmit(album); db.SubmitChanges(); return Content("<label style='color:#35006A'>操作成功!</label>"); } catch (Exception ex) { ex.ToString(); return Content("<label style='color:Red'>操作失败!</label>"); } } else return View(album); }
public ActionResult Register([Bind(Exclude = "ID,IsAdmin,AuthCode,CreateTime")] FormCollection formcollection) { UserInfo userinfo=new UserInfo(); userinfo.Uid = formcollection["username"]; userinfo.Password = formcollection["password"]; userinfo.Uname = formcollection["nickname"]; userinfo.Email = formcollection["email"]; userinfo.Photo = formcollection["selectbox"]; try { using (TianLaiDBDataContext db = new TianLaiDBDataContext()) { //检查账户是否重复 if (db.UserInfo.Where(p => p.Uid == userinfo.Uid).FirstOrDefault() != null) { ViewData["unameconfirm"] = "<label style='color:Red'>用户名重复,请重新输入</label>"; return View(userinfo); } using (System.Transactions.TransactionScope transaction = new System.Transactions.TransactionScope()) { //指定已排除的默认值 userinfo.IsAdmin = false; userinfo.AuthCode = Guid.NewGuid().ToString(); userinfo.Password = HashPassword(userinfo.Password); userinfo.Createdata = DateTime.Now; //将数据保存至数据库 db.UserInfo.InsertOnSubmit(userinfo); db.SubmitChanges(); System.Net.Mail.SmtpClient sc = new System.Net.Mail.SmtpClient("smtp.qq.com", 25); sc.Credentials = new System.Net.NetworkCredential("342354548", "0oO0oO"); sc.DeliveryMethod = System.Net.Mail.SmtpDeliveryMethod.Network; string verify_url = new Uri(Request.Url, System.Web.Routing.RouteTable.Routes.GetVirtualPath (Request.RequestContext, new System.Web.Routing.RouteValueDictionary (new { action = "Verify", authCode = userinfo.AuthCode })).VirtualPath).AbsoluteUri; sc.Send("*****@*****.**", userinfo.Email, "会员注册确认信", verify_url); transaction.Complete(); } } } catch (System.Net.Mail.SmtpException) { ModelState.AddModelError("Email", "很抱歉!系统发生异常,目前无法寄送确认信,请稍候再试!"); return View(userinfo); } return Content("注册信息已发出,请登录邮箱验证!"); }
public ActionResult Verify(string authCode) { using (TianLaiDBDataContext db = new TianLaiDBDataContext()) { var member = db.UserInfo.Where(p => p.AuthCode == authCode).FirstOrDefault(); if (member != null) { ViewData["Result"] = "会员验证成功!"; member.AuthCode = null; db.SubmitChanges(); Session["CurrentUser"] = db.UserInfo.ToList().Find(u => u.Uid == member.Uid); } else { ViewData["Result"] = "找不到此验证码,您是否已经验证过了呢?"; } } return View(); }
private bool ValidateLogOn(string uid, string password) { string hashed_pw = HashPassword(password); using (TianLaiDBDataContext db = new TianLaiDBDataContext()) { UserInfo userinfo = db.UserInfo.Where(p => p.Uid == uid && p.Password == hashed_pw).FirstOrDefault(); if (userinfo != null) { //如果会员尚未点击验证信中的超链接就无法登录 if (userinfo.AuthCode != null) { ModelState.AddModelError("password", "您的Email尚未验证成功!"); return false; } return true; } else { return false; } } }
public ActionResult DeletePlayList() { TianLaiDBDataContext db = new TianLaiDBDataContext(); var item = db.PlayList; return View(item); }
public ActionResult ModSinger(int sid,Singer singer) { if (ModelState.IsValid) { try { TianLaiDBDataContext db = new TianLaiDBDataContext(); singer = db.Singer.SingleOrDefault(d => d.Sid == sid); UpdateModel(singer); db.SubmitChanges(); return Content("<label style='color:#35006A'>操作成功!</label>"); } catch (Exception ex) { ex.ToString(); return Content("<label style='color:Red'>操作失败!</label>"); } } else { return View(singer); } }
//权限修改 public ActionResult Permission() { TianLaiDBDataContext db = new TianLaiDBDataContext(); var item = db.UserInfo; return View(item); }
public ActionResult ModPermission(string uid) { try { TianLaiDBDataContext db = new TianLaiDBDataContext(); UserInfo userinfo = db.UserInfo.SingleOrDefault(p => p.Uid == uid); if (userinfo.IsAdmin == true) userinfo.IsAdmin = false; else userinfo.IsAdmin = true; UpdateModel(userinfo); db.SubmitChanges(); return View("Permission",db.UserInfo); } catch (Exception ex) { ex.ToString(); return Content("<label style='color:Red'>操作失败!</label>"); } }
public ActionResult ModMusic(int mid,Music music) { try { TianLaiDBDataContext db = new TianLaiDBDataContext(); music = db.Music.SingleOrDefault(p => p.Mid == mid); UpdateModel(music); db.SubmitChanges(); return Content("<label style='color:#35006A'>操作成功!</label>"); } catch (Exception ex) { ex.ToString(); return Content("<label style='color:Red'>操作失败!</label>"); } }
public ActionResult ModifySinger() { TianLaiDBDataContext db = new TianLaiDBDataContext(); var item = db.Singer; return View(item); }
public static IQueryable <Music> SelectById(int id) { TianLaiDBDataContext db = new TianLaiDBDataContext(); return(db.Music.Where(d => d.Mid == id)); }
public ActionResult ModAlbum(int aid,Album album) { try { TianLaiDBDataContext db = new TianLaiDBDataContext(); album = db.Album.SingleOrDefault(p => p.Aid == aid); UpdateModel(album); db.SubmitChanges(); return Content("<label style='color:#35006A'>操作成功!</label>"); } catch (Exception ex) { ex.ToString(); return Content("<label style='color:Red'>操作失败!</label>"); } }
public ActionResult ModifyAlbum() { TianLaiDBDataContext db = new TianLaiDBDataContext(); var item = db.Album; return View(item); }
public static IQueryable<Music> SelectById(int id) { TianLaiDBDataContext db = new TianLaiDBDataContext(); return db.Music.Where(d => d.Mid == id); }
public static UserInfo userinfo(string uid) { TianLaiDBDataContext db = new TianLaiDBDataContext(); var result = db.UserInfo.FirstOrDefault(p => p.Uid == uid); return result; }
public ActionResult ModifyMusic() { TianLaiDBDataContext db = new TianLaiDBDataContext(); var item = db.Music; return View(item); }