public ActionResult Report2()
{
if (Session["Email"] == null || Session["Type"].ToString() != "Donner")
{
return(RedirectToAction("Login", "Home"));
}
var user = userInfoRepository.GetAll();
return(View(user));
}
public ICollection <UserInfo> GetAll()
{
try
{
return(_userInfoRepository.GetAll());
}
catch (Exception exception)
{
throw;
}
}
private bool UsersExist()
{
UserInfoRepository repo = new UserInfoRepository();
return(repo.GetAll().Any());
}
public ActionResult Index()
{
UserInfoRepository r = new UserInfoRepository();
return(View("~/Views/Employees.cshtml", r.GetAll()));
}
public ActionResult UserPanel()
{
return(View(usrepo.GetAll().Where(us => us.UserType.UserTypeName != "Admin")));
}
public void TextDapperContext()
{
DbEntityMap.InitMapCfgs();
IDbDatasource dbDatasource = new DbDataSource();
dbDatasource.Init(new NameValueCollection()
{
["aa.dataSource.master_AaCenter.connectionString"] = "Data Source =.; Initial Catalog = AaCenter;User ID = sa; Password = lee2018;",
["aa.dataSource.master_AaCenter.provider"] = "SqlServer"
});
dbDatasource.Init(new NameValueCollection()
{
["aa.dataSource.slave_AaCenter.connectionString"] = "Data Source =.; Initial Catalog = AaCenterS1;User ID = sa; Password = lee2018;",
["aa.dataSource.slave_AaCenter.provider"] = "SqlServer"
});
DbContextHolder.SetDbSourceMode("slave");
IDapperContext dapperContext = new DapperContext();
IUserInfoRepository _userInforepository = new UserInfoRepository(dapperContext);
var list = _userInforepository.GetAll().ToList();
//IVillageRepository villageRepository = new VillageRepository();
//villageRepository.Insert(new Village
//{
// Id = Guid.NewGuid(),
// VillageName = "aa",
// GmtCreate = DateTime.Now,
// GmtModified = DateTime.Now
//});
//var model = villageRepository.Get(new Guid("6D880321-DB17-4B32-9F0A-CE9F3F25AA01"));
//model.VillageName = "bbb";
//villageRepository.Update(model);
////var obj = _userInforepository.Insert(new UserInfo()
////{
//// RealName = "111",
//// UserName = "******",
//// GmtCreate=DateTime.Now,
//// LastLoginDate=DateTime.Now,
//// GmtModified=DateTime.Now
////});
// var users = _userInforepository.QueryAll();
//var userList = _userInforepository.From(sql =>
// sql.Select()
// .Where(p => p.RealName.Contains("成"))
// .OrderBy(x => x.SysNo)
// .Page(1, 20)
// );
//var count = userList.ToList().Count();
////动态where
//Expression<Func<UserInfo, bool>> expression = p => p.RealName == "成天";
//var where = DynamicWhereExpression.Init<UserInfo>();
//where = where.And(x => x.RealName == "成天");
//var dynamicUsers = _userInforepository.From(sql =>
// sql.Select()
// .Where(where)
// .OrderBy(x => x.SysNo)
// .Page(1, 20)
//);
//var count2 = dynamicUsers.ToList().Count();
}
