| | |
|---|
| | | FROM WOMDAB B |
|---|
| | | LEFT JOIN WOMDAA A ON A.guid = B.daaGuid |
|---|
| | | LEFT JOIN MES_ITEMS C ON B.dab003 = C.item_id |
|---|
| | | LEFT JOIN MES_BACK_FLASH F ON b.dab003 = F.ItemId |
|---|
| | | LEFT JOIN WOMCAB D ON B.erpid = D.ERPID |
|---|
| | | WHERE daa001 = '{0}' AND F_WPVT_BASE_QTR='{1}' AND ISSUE_TYPE = 1 ORDER BY DAB002", query.daa001,query.userName); |
|---|
| | | left join SYS_USER e on e.sid = c.F_WPVT_BASE_QTR |
|---|
| | | WHERE daa001 = '{0}' AND e.account='{1}' AND ISSUE_TYPE = 1 AND (F.ItemId is null OR F.checkStatus<>1) ORDER BY DAB002", query.daa001,query.userName); |
|---|
| | | |
|---|
| | | var womdabs = Db.Ado.SqlQuery<ItemDetailModel>(sql); |
|---|
| | | |
|---|
