public void GetOne()
{
Logsystem log = db.Logsystem.Select(e => e).FirstOrDefault();
UtilReflection.print_r(log);
Assert.IsNotNull(log);
}
public void GetOne()
{
Admin admin = db.Admin.Select(e => e).FirstOrDefault();
UtilReflection.print_r(admin);
Assert.IsNotNull(admin);
}
public void GetOne()
{
Admin admin = adminService.GetOne();
UtilReflection.print_r(admin);
Assert.IsNotNull(admin);
}
public void Get()
{
List <Logsystem> logs = db.Logsystem.Take(10).ToList <Logsystem>();
foreach (Logsystem log in logs)
{
UtilReflection.print_r(log);
}
Assert.AreEqual(10, logs.Count);
}
public void Get()
{
List <Admin> admins = db.Admin.Take(10).ToList <Admin>();
foreach (Admin admin in admins)
{
UtilReflection.print_r(admin);
}
Assert.AreEqual(10, admins.Count);
}
public void QueryPageByPageNo()
{
List <Admin> admins = adminService.QueryPage(1, 10);
foreach (Admin admin in admins)
{
UtilReflection.print_r(admin);
}
Assert.AreEqual(10, admins.Count);
}
public void Get()
{
List <Admin> admins = adminService.Get();
foreach (Admin admin in admins)
{
UtilReflection.print_r(admin);
}
Assert.AreEqual(10, admins.Count);
}
public void SqlExecute()
{
List <Logsystem> logs = db.Logsystem.SqlQuery("select * from Logsystem where Logtime<getdate()").ToList <Logsystem>();
Console.WriteLine("总计数:" + logs.Count);
foreach (Logsystem log in logs)
{
UtilReflection.print_r(log);
}
Assert.IsTrue(logs.Count > 10);
}
public void SqlExecute()
{
List <Admin> admins = db.Admin.SqlQuery("select * from Admin where LoginTimes>900").ToList <Admin>();
Console.WriteLine("总计数:" + admins.Count);
foreach (Admin admin in admins)
{
UtilReflection.print_r(admin);
}
Assert.IsTrue(admins.Count > 10);
}
public void GetByIDAdmin()
{
Admin admin = db.Admin.Find(AdminID);//new Guid(PersonID)
if (admin != null)
{
UtilReflection.print_r(admin);
Assert.AreEqual("admin", admin.Username);
}
else
{
Assert.IsTrue(false);
}
}
public void GetByIDLogSystem()
{
Guid logID = new Guid(originalLogID);
Logsystem log = db.Logsystem.Find(logID);
if (log != null)
{
UtilReflection.print_r(log);
Assert.IsTrue(true);
}
else
{
Assert.IsTrue(false);
}
}
public void QueryPageByPageNo()
{
int PageNo = 3;
int PageSize = 10;
int StartPoint = (PageNo - 1) * PageSize;
List <Logsystem> logs = db.Logsystem
.OrderByDescending(e => e.Logtime)
.Skip(StartPoint)
.Take(PageSize).ToList <Logsystem>();
foreach (Logsystem log in logs)
{
UtilReflection.print_r(log);
}
Assert.AreEqual(10, logs.Count);
}
public void QueryPageByPageNo()
{
int PageNo = 1;
int PageSize = 10;
int StartPoint = (PageNo - 1) * PageSize;
List <Admin> admins = db.Admin
.OrderByDescending(e => e.ID)
.Skip(StartPoint)
.Take(PageSize).ToList <Admin>();
foreach (Admin admin in admins)
{
UtilReflection.print_r(admin);
}
Assert.AreEqual(10, admins.Count);
}
public void QueryPage()
{
//开始记录数
int StartPoint = 1;
//结束记录数
int EndPoint = 10;
int From = StartPoint - 1;
int PageSize = EndPoint - StartPoint + 1;
List <Logsystem> logs = db.Logsystem
.OrderByDescending(e => e.Logtime)
.Skip(From)
.Take(PageSize).ToList <Logsystem>();
foreach (Logsystem log in logs)
{
UtilReflection.print_r(log);
}
Assert.AreEqual(10, logs.Count);
}
public void QueryPage()
{
//开始记录数
int StartPoint = 1;
//结束记录数
int EndPoint = 10;
int From = StartPoint - 1;
int PageSize = EndPoint - StartPoint + 1;
List <Admin> admins = db.Admin
.OrderByDescending(e => e.ID)
.Skip(From)
.Take(PageSize).ToList <Admin>();
foreach (Admin admin in admins)
{
UtilReflection.print_r(admin);
}
Assert.AreEqual(10, admins.Count);
}
