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