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