public MenuRightCheckDataModel CheckMenuRightByMenuID(MenuRightCheckParameter parameter)
{
this.ExecuteSQL = "SELECT CASE WHEN COUNT(1)>0 THEN TRUE ELSE FALSE END HaveRight FROM userright WHERE menuid=@MenuID AND userid=@UserID";
this.DataParameter = new IDbDataParameter[]
{
new SqlParameter("@UserID", parameter.UserID),
new SqlParameter("@MenuID", parameter.MenuID)
};
return(this.ExecuteReadSqlToMenuRightCheckDataModel());
}
public RespondMenuRightCheckViewModel CheckMenuRightByMenuID(RequestMenuRightCheckViewModel request)
{
var user = CPSSAuthenticate.GetCurrentUser();
return(MemcacheHelper.Get(() =>
{
var parameter = new MenuRightCheckParameter
{
MenuID = request.MenuID,
UserID = user.UserID
};
var dataModel = this.mMenuRightCheckDataAccess.CheckMenuRightByMenuID(parameter);
var result = new RespondMenuRightCheckViewModel
{
HaveRight = dataModel != null && dataModel.HaveRight
};
return result;
}, string.Format(preCacheKey, "CheckMenuRightByMenuID"),
false,
request.MenuID
, user.UserID));
}
