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