public List <Person> GetList(string Number, string Name) { List <Person> result; using (this.mcFace = new McFaceContext()) { IQueryable <Person> source = this.mcFace.Persons.AsQueryable <Person>(); if (!string.Empty.Equals(Name)) { source = from p in source where p.Name.Contains(Name) select p; } if (!string.Empty.Equals(Number)) { source = from p in source where p.Number.Contains(Number) select p; } result = source.Take(500).ToList <Person>(); } return(result); }
public void Delete(Person person) { using (this.mcFace = new McFaceContext()) { this.mcFace.Entry <Person>(person).State = EntityState.Deleted; this.mcFace.SaveChanges(); } }
public List <Person> GetList() { List <Person> result; using (this.mcFace = new McFaceContext()) { result = this.mcFace.Persons.ToList <Person>(); } return(result); }
public List <CamerInfo> GetList() { List <CamerInfo> result; using (this.mcFace = new McFaceContext()) { result = this.mcFace.CamerInfos.ToList <CamerInfo>(); } return(result); }
public int GetCount() { int result; using (this.mcFace = new McFaceContext()) { result = this.mcFace.Persons.Count <Person>(); } return(result); }
public int GetCount() { int result; using (this._mcFace = new McFaceContext()) { result = this._mcFace.FaceCompareLogs.Count <FaceCompareLog>(); } return(result); }
public int Clear() { int result; using (this.mcFace = new McFaceContext()) { result = this.mcFace.Database.ExecuteSqlCommand("Delete from Person", new object[0]); } return(result); }
public Person getTop() { Person result; using (this.mcFace = new McFaceContext()) { result = this.mcFace.Persons.FirstOrDefault <Person>(); } return(result); }
public int Clear() { int result; using (this._mcFace = new McFaceContext()) { result = this._mcFace.Database.ExecuteSqlCommand("DELETE from FaceCompareLog", new object[0]); } return(result); }
public Person GetPerson(int ID) { Person result; using (this.mcFace = new McFaceContext()) { result = this.mcFace.Persons.FirstOrDefault((Person p) => p.ID == (long)ID); } return(result); }
public List <FaceCompareLog> GetList(out int Count, int pagesize, int pageindex) { List <FaceCompareLog> result; using (this._mcFace = new McFaceContext()) { Count = this._mcFace.FaceCompareLogs.Count <FaceCompareLog>(); result = this._mcFace.FaceCompareLogs.Skip(pagesize * (pageindex - 1)).Take(pagesize).ToList <FaceCompareLog>(); } return(result); }
public long Update(CamerInfo camerInfo) { long iD; using (this.mcFace = new McFaceContext()) { this.mcFace.Entry <CamerInfo>(camerInfo).State = EntityState.Modified; this.mcFace.SaveChanges(); iD = camerInfo.ID; } return(iD); }
public int Add(Person person) { int result; using (this.mcFace = new McFaceContext()) { this.mcFace.Persons.Add(person); this.mcFace.SaveChanges(); result = (int)Convert.ToInt16(person.ID); } return(result); }
public int Add(FaceCompareLog faceCompareLog) { int result; using (this._mcFace = new McFaceContext()) { this._mcFace.FaceCompareLogs.Add(faceCompareLog); this._mcFace.SaveChanges(); result = (int)Convert.ToInt16(faceCompareLog.ID); } return(result); }
public long add(CamerInfo camerInfo) { long iD; using (this.mcFace = new McFaceContext()) { this.mcFace.CamerInfos.Add(camerInfo); this.mcFace.SaveChanges(); iD = camerInfo.ID; } return(iD); }
public void Delete(int id) { using (this.mcFace = new McFaceContext()) { Person entity = this.mcFace.Persons.Find(new object[] { id }); this.mcFace.Entry <Person>(entity).State = EntityState.Deleted; this.mcFace.SaveChanges(); } }
public int Update(Person person) { int result; using (this.mcFace = new McFaceContext()) { this.mcFace.Entry <Person>(person).State = EntityState.Modified; this.mcFace.SaveChanges(); result = (int)Convert.ToInt16(person.ID); } return(result); }
public List <Person> GetList(long id) { List <Person> result; using (this.mcFace = new McFaceContext()) { result = ( from p in this.mcFace.Persons where p.ID > id select p).ToList <Person>(); } return(result); }
public List <FaceCompareLog> GetListByPersonName(DateTime time, string number, int pagesize, int pageindex) { List <FaceCompareLog> result; using (this._mcFace = new McFaceContext()) { result = ( from p in this._mcFace.FaceCompareLogs where p.PersonNumber.Equals(number) orderby p.ID descending select p).Skip(pagesize * (pageindex - 1)).Take(pagesize).ToList <FaceCompareLog>(); } return(result); }
public List <FaceCompareLog> GetList(out int Count, DateTime time, int pagesize, int pageindex) { List <FaceCompareLog> result; using (this._mcFace = new McFaceContext()) { string date = time.ToString("yyyy\\/M\\/d"); IQueryable <FaceCompareLog> source = this._mcFace.FaceCompareLogs.AsQueryable <FaceCompareLog>(); source = from p in source where p.FaceDetcetDate.Contains(date) select p; Count = source.Count <FaceCompareLog>(); result = ( from p in source orderby p.ID descending select p).Skip(pagesize * (pageindex - 1)).Take(pagesize).ToList <FaceCompareLog>(); } return(result); }
public List <FaceCompareLog> GetList(out int Count, DateTime time, string number, string Port, int pagesize, int pageindex) { List <FaceCompareLog> result; using (this._mcFace = new McFaceContext()) { string date = time.ToString("yyyy\\/M\\/d"); IQueryable <FaceCompareLog> source = this._mcFace.FaceCompareLogs.AsQueryable <FaceCompareLog>(); if (Port.Equals("全部")) { source = from p in source where p.FaceDetcetDate.Contains(date) select p; } else { source = from p in source where p.FaceDetcetDate.Contains(date) where p.tmp1.Equals(Port) select p; } if (!number.Equals(string.Empty)) { source = from p in source where p.PersonNumber.Contains(number) select p; } Count = source.Count <FaceCompareLog>(); result = ( from p in source orderby p.ID descending select p).Skip(pagesize * (pageindex - 1)).Take(pagesize).ToList <FaceCompareLog>(); } return(result); }