public IEnumerable <Target> GetModelsByPage <Target>(int pageSize, int pageIndex, string sql)
{
//var users = DBContextFactory.CreateDB().Set<tbl_User_NoPhoto>().SqlQuery(sql).ToArray();
var entities = DBContextFactory.CreateDB().Database.SqlQuery <Target>(sql).ToList().Skip(pageSize * (pageIndex - 1)).Take(pageSize);
return(entities);
}
public IQueryable <V_Role_Menu> GetVModels(System.Linq.Expressions.Expression <Func <V_Role_Menu, bool> > wherelambda)
{
var db = DBContextFactory.CreateDB();
var entities = db.Set <V_Role_Menu>();
return(entities.Where(wherelambda));
}
public IQueryable <V_Role_Data_Verify_Step> GetRoleVerifyStep(System.Linq.Expressions.Expression <Func <V_Role_Data_Verify_Step, bool> > wherelambda)
{
var db = DBContextFactory.CreateDB();
var entities = db.Set <V_Role_Data_Verify_Step>();
return(entities.Where(wherelambda));
}
public tbl_User CheckLogin(string username, string pwd)
{
var users = DBContextFactory.CreateDB().Set <tbl_User>();
if (users != null && users.Count() > 0)
{
return(users.Where(u => u.C_LoginName == username && u.C_PassWord == pwd).FirstOrDefault());
}
else
{
return(null);
}
}
public bool ChangePassword(string userid, string newpassword)
{
var users = DBContextFactory.CreateDB().Set <tbl_User>();
var key = int.Parse(userid);
var target = users.Where(u => u.keyid == key).FirstOrDefault();
if (target != null)
{
target.C_PassWord = newpassword;
target.C_UpdatedDate = DateTime.Now;
return(SaveChanges());
}
return(false);
}
public T GetRoleByKey <T>(int Key)
{
var db = DBContextFactory.CreateDB();
T t = base.GetDtoByKey <T>(Key, @"SELECT TOP 1 [keyid]
,[C_Name]
,[C_ParentRole]
, (select C_Name from [tbl_Role] t1 where t1.keyid=t2.C_ParentRole) as ParentName
,[C_Description]
,[C_CreatedDate]
,[C_UpdatedDate]
FROM [DATA_MANAGE].[dbo].[tbl_Role] t2");
return(t);
}
public UserGrid SearchUserInfos(int pageSize, int pageIndex, System.Linq.Expressions.Expression <Func <tbl_User, bool> > WhereLambda)
{
var datagrid = new UserGrid();
var userlist = new List <tbl_User>();
var userset = DBContextFactory.CreateDB().Set <tbl_User>();
datagrid.total = userset.Where(WhereLambda).Count();
var users = userset.Where(WhereLambda).OrderBy(u => u.keyid).Skip(pageSize * (pageIndex - 1)).Select(u => new { u.keyid, u.C_Name, u.C_LoginName, u.C_PassWord, u.C_Enabled, u.C_Sex, u.C_CreatedDate, u.C_UpdatedDate }).Take(pageSize);
foreach (var u in users)
{
userlist.Add(new tbl_User()
{
keyid = u.keyid, C_CreatedDate = u.C_CreatedDate, C_Enabled = u.C_Enabled, C_LoginName = u.C_LoginName, C_Name = u.C_Name, C_PassWord = u.C_PassWord, C_Sex = u.C_Sex, C_UpdatedDate = u.C_UpdatedDate
});
}
datagrid.OriginRows = userlist;
return(datagrid);
}
public bool UpdateUserRoles(int userid, int[] Roles)
{
var db = DBContextFactory.CreateDB();
using (var tran = db.Database.BeginTransaction())
{
try
{
var deleted_ur = base.GetModels(ur => ur.C_UserId == userid);
if (deleted_ur != null && deleted_ur.Count() > 0)
{
db.Set <tbl_User_Role>().RemoveRange(deleted_ur);
}
foreach (var item in Roles)
{
var new_ur = new tbl_User_Role();
new_ur.C_UserId = userid;
new_ur.C_RoleId = item;
new_ur.C_CreatedDate = DateTime.Now;
base.Add(new_ur);
}
if (SaveChanges())
{
tran.Commit();
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
tran.Rollback();
return(false);
}
}
}
public IQueryable <V_User_Role> GetModels(System.Linq.Expressions.Expression <Func <V_User_Role, bool> > wherelambda)
{
return(DBContextFactory.CreateDB().Set <V_User_Role>().Where(wherelambda));
}
public IQueryable <V_DataVerifyStep> GetVModels(Expression <Func <V_DataVerifyStep, bool> > wherelambda)
{
var entities = DBContextFactory.CreateDB().Set <V_DataVerifyStep>();
return(entities.Where(wherelambda));
}
