| | |
|---|
| | | } |
|---|
| | | |
|---|
| | | // 定义获取工单数据的 SQL 查询 |
|---|
| | | var query = "SELECT daa001, nvl(b.qty, 0) FROM womdaa a left join (select sum(QUANTITY) qty, PBILL_NO from MES_WORK_PROD_C_DETAILS where to_char(CREATE_DATE, 'YYYY-MM-DD') = to_char(sysdate, 'YYYY-MM-DD') group by PBILL_NO) b on a.daa001 = b.PBILL_NO left Join womcaa c on c.caa001=a.daa014 WHERE SJ_XTNO = :lineNo and (daa018 = '已开工'or daa018 = '待开工' or daa018='未开工') and c.JA_BS<>1 order by a.BC_TIME "; |
|---|
| | | var query = "SELECT daa001, nvl(b.qty, 0) FROM womdaa a left join (select sum(QUANTITY) qty, PBILL_NO from MES_WORK_PROD_C_DETAILS where to_char(CREATE_DATE, 'YYYY-MM-DD') = to_char(sysdate, 'YYYY-MM-DD') group by PBILL_NO) b on a.daa001 = b.PBILL_NO left Join womcaa c on c.caa001=a.daa014 WHERE SJ_XTNO = :lineNo and ( daa018 = '待开工' or daa018='暂停'or daa018='已开工') and c.JA_BS<>1 and A.FSTATUS=1 order by a.BC_TIME "; |
|---|
| | | |
|---|
| | | // 定义 SQL 查询的参数 |
|---|
| | | var parameters = new List<OracleParameter> |
|---|
| | |
|---|
| | | |
|---|
| | | return Ok(orders); // 返回结果 |
|---|
| | | } |
|---|
| | | //20250410 修改为调用存储过程 |
|---|
| | | |
|---|
| | | } |
|---|
| | | } |
|---|
