//添加记录 public static bool Insert(CriminalBasicInfoTable user) { using (CriminalDbContext db = new CriminalDbContext()) { db.CriminalBasicInfo.Add(user); return(db.SaveChanges() > 0); //保存数据 } }
//修改记录 public static bool Update(CriminalBasicInfoTable user) { using (CriminalDbContext db = new CriminalDbContext()) { db.CriminalBasicInfo.Attach(user); db.Entry(user).State = System.Data.Entity.EntityState.Modified; return(db.SaveChanges() > 0); } }
//删除记录(User中应包含主键ID值) public static bool Delete(CriminalBasicInfoTable user) { using (CriminalDbContext db = new CriminalDbContext()) { db.CriminalBasicInfo.Attach(user); db.CriminalBasicInfo.Remove(user); return(db.SaveChanges() > 0); } }
//返回所有记录 public static List <CriminalBasicInfoTable> GetAll() { using (CriminalDbContext db = new CriminalDbContext()) { var CrimeQuery = (from b in db.CriminalBasicInfo orderby b.criminalID select b).ToList(); return(CrimeQuery); } }
//RFID查询 public static List <CriminalBasicInfoTable> GetRFIDNumber(string s) { using (CriminalDbContext db = new CriminalDbContext()) { var CrimeQuery1 = from b in db.CriminalBasicInfo where b.RFIDNumber.Contains(s) orderby b.RFIDNumber select b; List <CriminalBasicInfoTable> CrimeList = new List <CriminalBasicInfoTable>(); CrimeList = CrimeQuery1.ToList(); return(CrimeList); } }