public IEnumerable <T> MenuGetList <T>(MenuGetListRequest req) where T : class
{
var client = DBProxy.CreateClient();
var sql = new StringBuilder(@"SELECT
sm.*,srmp.R_ID
FROM SS_MENU sm
JOIN SS_ROLE_MENU_PURVIEWCODE srmp
ON sm.M_CODE = srmp.MPC_CODE
INNER JOIN (SELECT
sru.R_ID
FROM SS_USER su
LEFT JOIN SS_ROLE_USER sru
ON su.U_ID = sru.U_ID
WHERE 1=1 ");
var param = new DynamicParameters();
if (req.U_ID.HasValue)
{
sql.Append(" AND sru.U_ID = @U_ID");
param.Add("@U_ID", req.U_ID);
}
sql.Append(@") t
ON srmp.R_ID = t.R_ID
WHERE sm.M_DISABLED = 0 ");
if (!string.IsNullOrEmpty(req.M_NAME))
{
sql.Append(" AND sm.M_NAME_C LIKE @M_NAME_C");
param.Add("@M_NAME_C", $"%{req.M_NAME}%");
}
return(client.Query <T>(sql.ToString(), param));
}
public SingleApiResponse MenuGetList(MenuGetListRequest req)
{
var result = MenuRepo.MenuGetList <SS_MENU>(req);
return(new SingleApiResponse()
{
Data = result
});
}
public BasicResponse <List <MenuInfo> > GetMenuList(MenuGetListRequest menurequest)
{
var menuresponse = new BasicResponse <List <MenuInfo> >();
menurequest.PagerInfo.PageIndex = menurequest.PagerInfo.PageIndex - 1;
if (menurequest.PagerInfo.PageIndex < 0)
{
menurequest.PagerInfo.PageIndex = 0;
}
int rowcount = 0;
var menuModelLists = _Repository.GetMenuList(menurequest.PagerInfo.PageIndex, menurequest.PagerInfo.PageSize, out rowcount);
var menuInfoLists = new List <MenuInfo>();
foreach (var item in menuModelLists)
{
var MenuInfo = ObjectConverter.Copy <MenuModel, MenuInfo>(item);
menuInfoLists.Add(MenuInfo);
}
menuresponse.Data = menuInfoLists;
return(menuresponse);
}
public BasicResponse <List <MenuInfo> > GetMenuList(MenuGetListRequest menurequest)
{
return(_menuService.GetMenuList(menurequest));
}
public SingleApiResponse GetList([FromBody] MenuGetListRequest req)
{
return(MenuBiz.MenuGetList(req));
}
public BasicResponse <List <MenuInfo> > GetMenuList(MenuGetListRequest menurequest)
{
var responseStr = HttpClientHelper.Post(Webapi + "/v1/Menu/GetPageList?token=" + Token, JSONHelper.ToJSONString(menurequest));
return(JSONHelper.ParseJSONString <BasicResponse <List <MenuInfo> > >(responseStr));
}
