GET_USER.txt
| 1 |
SELECT A.TLNANME,A.TLFullName,D.BRANCH_CODE,D.BRANCH_NAME,E.DEP_CODE,E.DEP_NAME,C.[Desc] |
|---|---|
| 2 |
FROM TL_USER A |
| 3 |
LEFT JOIN AbpUserRoles B ON A.ID = B.UserId |
| 4 |
LEFT JOIN AbpRoles C ON B.RoleId = C.Id |
| 5 |
LEFT JOIN CM_BRANCH D ON A.TLSUBBRID = D.BRANCH_ID |
| 6 |
LEFT JOIN CM_DEPARTMENT E ON A.DEP_ID = E.DEP_ID |
| 7 |
WHERE A.DEP_ID IS NOT NULL AND A.DEP_ID <> '' |
| 8 |
ORDER BY D.BRANCH_ID,E.DEP_ID |
| 9 |
|
| 10 |
SELECT A.TLNANME,A.TLFullName,D.BRANCH_CODE,D.BRANCH_NAME,E.DEP_CODE,E.DEP_NAME,C.[Desc] |
| 11 |
FROM TL_USER A |
| 12 |
LEFT JOIN AbpUserRoles B ON A.ID = B.UserId |
| 13 |
LEFT JOIN AbpRoles C ON B.RoleId = C.Id |
| 14 |
LEFT JOIN CM_BRANCH D ON A.TLSUBBRID = D.BRANCH_ID |
| 15 |
LEFT JOIN CM_DEPARTMENT E ON A.DEP_ID = E.DEP_ID |
| 16 |
WHERE A.DEP_ID IS NULL OR A.DEP_ID = '' |
| 17 |
ORDER BY D.BRANCH_ID,E.DEP_ID |