void LoadDataTableMenu()
{
dtMenu = p._SQLTraveDatatable("SELECT t.TransactionCode, t.RoleCode, t1.RoleName, formName, TransactionName, ParentFolder, IsParent, t2.TransactionCode as fav FROM Transactions t LEFT JOIN Roles t1 ON t.RoleCode = t1.RoleCode LEFT JOIN TransactionFav t2 ON t.TransactionCode = t2.TransactionCode and t2.username = '******' WHERE t.rolecode IN ( SELECT RoleCode FROM UserJoinRole WHERE username = '******' ) and t.IsDisplay = 1 ORDER BY SortNo ASC", gen.GetConn());
}
