/// <summary> /// 根据用户编码更新用户数据 /// </summary> /// <param name="EditUser">要更新数据的用户对象实例</param> /// <returns></returns> public int Update(IUser EditUser) { IDvTable dvt = entityfactory.CreateDriveTable(EditUser); dvt.WhereClause("UserCode", Operator.Deng, LinkOperator.nul); int i = dvt.Update(); return(i); }
/// <summary> /// 更新权限项目 /// </summary> /// <param name="AuthCtrl"></param> /// <returns></returns> public int UpdateAuthCtrl(IAuthControl AuthCtrl) { IDvTable dvt = entityfactory.CreateDriveTable(AuthCtrl); dvt.WhereClause("RowCode", Operator.Deng, LinkOperator.nul); int i = dvt.Update(); return(i); }
/// <summary> /// 更新角色 /// </summary> /// <param name="Role"></param> /// <returns></returns> public int UpdateRole(IRole Role) { IDvTable dvt = entityfactory.CreateDriveTable(Role); dvt.WhereClause("RoleCode", Operator.Deng, LinkOperator.nul); int i = dvt.Update(); return(i); }
/// <summary> /// 更新单位 /// </summary> /// <param name="Units"></param> /// <returns></returns> public int UpdateUnits(IUnits Units) { IDvTable dvt = entityfactory.CreateDriveTable(Units); dvt.WhereClause("UnitCode", Operator.Deng, LinkOperator.nul); int i = dvt.Update(); return(i); }
/// <summary> /// 根据角色名和菜单类型查询菜单 /// </summary> /// <param name="Role">角色</param> /// <param name="MType">菜单类型</param> /// <returns></returns> public List <IMenu> QueryMenus(IRole Role, MenuType MType) { IMenu menu = entityfactory.CreateEntityInstance <IMenu>(); menu.MENUTYPE = MType.ToString(); IAuthControl actrl = entityfactory.CreateEntityInstance <IAuthControl>(); actrl.RoleCode = Role.RoleCode; IDvTable dvt = entityfactory.CreateDriveTable(menu); dvt.Join.Entitys.Add(actrl); dvt.WhereClause("MENUTYPE", Operator.Deng, LinkOperator.and); dvt.WhereClause(actrl, "RoleCode", Operator.Deng, LinkOperator.nul); DataSet ds = dvt.Select(); List <IMenu> list = this.dh.Convert <IMenu>(menu.GetType(), ds); List <IMenu> result = RefactoringMenu(list); return(result); }
/// <summary> /// 移除角色 /// </summary> /// <param name="RoleName"></param> /// <returns></returns> public int RemoveRole(string RoleName) { IRole role = entityfactory.CreateEntityInstance <IRole>(); IDvTable dvt = entityfactory.CreateDriveTable(role); role.RoleName = RoleName; dvt.WhereClause("RoleName", Operator.Deng, LinkOperator.nul); int i = dvt.Delete(); return(i); }
/// <summary> /// 删除用户 /// </summary> /// <param name="UserCode"></param> /// <returns></returns> public virtual int RemoveUserCode(long UserCode) { IUser user = entityfactory.CreateEntityInstance <IUser>(); IDvTable dvt = entityfactory.CreateDriveTable(user); user.UserCode = UserCode; dvt.WhereClause("UserCode", Operator.Deng, LinkOperator.nul); int i = dvt.Delete(); return(i); }
/// <summary> /// 移除单位 /// </summary> /// <param name="UnitName"></param> /// <returns></returns> public int RemoveUnits(string UnitName) { IUnits nit = entityfactory.CreateEntityInstance <IUnits>(); IDvTable dvt = entityfactory.CreateDriveTable(nit); nit.UnitName = UnitName; dvt.WhereClause("UnitName", Operator.Deng, LinkOperator.nul); int i = dvt.Delete(); return(i); }
/// <summary> /// 移除权限项 /// </summary> /// <param name="AuthItemCode"></param> /// <returns></returns> public virtual int RemoveAuthItem(string AuthItemCode) { IAuthItem item = entityfactory.CreateEntityInstance <IAuthItem>(); IDvTable dvt = entityfactory.CreateDriveTable(item); item.AuthItemCode = AuthItemCode; dvt.WhereClause("AuthItemCode", Operator.Deng, LinkOperator.nul); int i = dvt.Delete(); return(i); }
/// <summary> /// 根据角色编码查询角色 /// </summary> /// <param name="RoleCode">角色编码</param> /// <returns></returns> public IRole QueryRoleForCode(long RoleCode) { IRole role = entityfactory.CreateEntityInstance <IRole>(); IDvTable dvt = entityfactory.CreateDriveTable(role); role.RoleCode = RoleCode; dvt.WhereClause("RoleCode", Operator.Deng, LinkOperator.nul); DataSet ds = dvt.Select(); role = this.dh.Convert <IRole>(role.GetType(), ds, 0); return(role); }
/// <summary> /// 根据单位编码查询单位 /// </summary> /// <param name="UnitCode"></param> /// <returns></returns> public IUnits QueryUnitsForCode(long UnitCode) { IUnits uit = entityfactory.CreateEntityInstance <IUnits>(); IDvTable dvt = entityfactory.CreateDriveTable(uit); uit.UnitCode = UnitCode; dvt.WhereClause("UnitCode", Operator.Deng, LinkOperator.nul); DataSet ds = dvt.Select(); uit = this.dh.Convert <IUnits>(uit.GetType(), ds, 0); return(uit); }
/// <summary> /// 根据菜单类全名查询菜单 /// </summary> /// <param name="FullClassName"></param> /// <returns></returns> public IMenu QueryMenu(string FullClassName) { IMenu menu = entityfactory.CreateEntityInstance <IMenu>(); IDvTable dvt = entityfactory.CreateDriveTable(menu); menu.FULLCLASSNAME = FullClassName; dvt.WhereClause("FULLCLASSNAME", Operator.Deng, LinkOperator.nul); DataSet ds = dvt.Select(); DataHelper dte = new DataHelper(); return(dte.Convert <IMenu>(menu.GetType(), ds, 0)); }
/// <summary> /// 根据用户名称查询用户 /// </summary> /// <param name="UserName"></param> /// <returns></returns> public virtual IUser QueryUserName(string UserName) { IUser user = entityfactory.CreateEntityInstance <IUser>(); IDvTable dvt = entityfactory.CreateDriveTable(user); user.UserName = UserName; dvt.WhereClause("UserName", Operator.Deng, LinkOperator.nul); DataSet ds = dvt.Select(); user = this.dh.Convert <IUser>(user.GetType(), ds, 0); return(user); }
/// <summary> /// 根据指定的权限项编码查询权限项对象 /// </summary> /// <param name="AuthItemCode"></param> /// <returns></returns> public virtual IAuthItem QueryAuthItem(string AuthItemCode) { IAuthItem item = this.entityfactory.CreateEntityInstance <IAuthItem>(); item.AuthItemCode = AuthItemCode; IDvTable dvt = this.entityfactory.CreateDriveTable(item); dvt.WhereClause("AuthItemCode", Operator.Deng, LinkOperator.nul); DataSet ds = dvt.Select(); DataHelper dte = new DataHelper(); return(dte.Convert <IAuthItem>(item.GetType(), ds, 0));; }
/// <summary> /// 批量更新用户 /// </summary> /// <param name="UserList"></param> /// <returns></returns> public int Update(List <IUser> UserList) { IDvTableBatch dvtb = entityfactory.CreateDriveTableBatch(); foreach (IUser user in UserList) { IDvTable dvt = dvtb.CreateDriveTable(user); dvt.WhereClause("UserCode", Operator.Deng, LinkOperator.nul); dvtb.AddUpdate(dvt); } int i = dvtb.Execute(); return(i); }
/// <summary> /// 根据用户名称和密码查询用户 /// </summary> /// <param name="UserName"></param> /// <param name="UserPassword"></param> /// <returns></returns> public IUser QueryUserInfo(string UserName, string UserPassword) { IUser user = entityfactory.CreateEntityInstance <IUser>(); IDvTable dvt = entityfactory.CreateDriveTable(user); user.UserName = UserName; user.Userpd = UserPassword; dvt.WhereClause("UserName", Operator.Deng, LinkOperator.and); dvt.WhereClause("Userpd", Operator.Deng, LinkOperator.nul); DataSet ds = dvt.Select(); DataHelper dte = new DataHelper(); List <object> userlist = dte.ConvertToEntity(user.GetType(), ds); if (userlist.Count > 0) { user = (IUser)userlist[0]; } else { user = null; } return(user); }
/// <summary> /// 根据角色编码查询用户 /// </summary> /// <param name="RoleCode"></param> /// <returns></returns> public List <IUser> QueryUserRoleCode(long RoleCode) { IUser user = entityfactory.CreateEntityInstance <IUser>(); IDvTable dvt = entityfactory.CreateDriveTable(user); user.RoleCode = RoleCode; dvt.WhereClause("UserName", Operator.Deng, LinkOperator.nul); DataSet ds = dvt.Select(); DataHelper dte = new DataHelper(); List <object> userlist = dte.ConvertToEntity(user.GetType(), ds); List <IUser> result = new List <IUser>(); foreach (object obj in userlist) { result.Add((IUser)obj); } return(result); }