public List <MenuAndRoleRelationEntity> QueryRoleAndMenuList(MenuAndRoleRelationRequest request)
{
DynamicParameters dp = new DynamicParameters();
StringBuilder strSQL = new StringBuilder();
strSQL.Append(" select * from tblMenuAndRoleRelation with(nolock) where 1=1 ");
if (!string.IsNullOrEmpty(request.Id))
{
strSQL.Append(" and Id=@Id ");
dp.Add("Id", request.Id, DbType.String, ParameterDirection.Input, 50);
}
if (!string.IsNullOrEmpty(request.RoleId))
{
strSQL.Append(" and RoleId=@RoleId ");
dp.Add("RoleId", request.RoleId, DbType.String, ParameterDirection.Input, 50);
}
if (!string.IsNullOrEmpty(request.MenuId))
{
strSQL.Append(" and MenuId=@MenuId ");
dp.Add("MenuId", request.MenuId, DbType.String, ParameterDirection.Input, 50);
}
using (DbConnection conn = new SqlConnection(DbConnectionStringConfig.Default.MyShopConnectionString))
{
return(conn.Query <MenuAndRoleRelationEntity>(strSQL.ToString(), request).ToList());
}
}
public List <MenuAndRoleRelationEntity> GetRoleAndMenuList(MenuAndRoleRelationRequest request)
{
return(menuAndRoleRelation.QueryRoleAndMenuList(request));
}
