using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace MvcApplication2.Models { public class InfoBf { private MydbDataContext _Context = new MydbDataContext(); //查询 public List<student> Select() { return _Context.student.ToList(); } //查询出一条数据修改使用 public student Select(string sno) { var query = _Context.student.Where(p=>p.sno==http://www.mamicode.com/sno); if (query.Count()>0) { return query.First(); } return null; } //添加 public void Insert(string sno,string sname,string ssex,DateTime sbirthdy,string @class) { student data = new student { sno =http://www.mamicode.com/ sno, sname =http://www.mamicode.com/ sname, ssex =http://www.mamicode.com/ ssex, sbirthdy =http://www.mamicode.com/ sbirthdy, @class =http://www.mamicode.com/ @class }; _Context.student.InsertOnSubmit(data); _Context.SubmitChanges(); } //删除 public void Delete(string sno) { var query = _Context.student.Where(p=>p.sno==http://www.mamicode.com/sno); if (query.Count()>0) { student data =http://www.mamicode.com/ query.First(); _Context.student.DeleteOnSubmit(data); _Context.SubmitChanges(); } } //修改 public void Update(string sno, string sname, string ssex, DateTime sbirthdy, string @class) { var query = _Context.student.Where(p => p.sno ==http://www.mamicode.com/ sno); if (query.Count()>0) { student data =http://www.mamicode.com/ query.First(); data.sno =http://www.mamicode.com/ sno; data.sname =http://www.mamicode.com/ sname; data.ssex =http://www.mamicode.com/ ssex; data.sbirthdy =http://www.mamicode.com/ sbirthdy; data.@class =http://www.mamicode.com/ @class; _Context.SubmitChanges(); } } } }