| | |
|---|
| | | |
|---|
| | | // 使用你提供的 SQL 查询，并新增一个字段 daa002 |
|---|
| | | var query = @" |
|---|
| | | SELECT c.SALE_ORDER_NO, to_char(a.daa016,'YYYY-MM-DD HH24:MI:SS'), a.daa008, a.daa011, a.daa002,s.item_no,nvl(bz.bzsl,0),s.ITEM_NAME,s.ITEM_MODEL, |
|---|
| | | SELECT c.SALE_ORDER_NO, to_char(NVL(a.daa016, SYSDATE), 'YYYY-MM-DD HH24:MI:SS'), a.daa008, a.daa011, a.daa002,s.item_no,nvl(bz.bzsl,0),a.daa018,s.ITEM_NAME,s.ITEM_MODEL, |
|---|
| | | case when sj.FSECOND_RESU ='合格' then 1 else case when sj.FSECOND_RESU ='不合格' then 2 else 0 end end sj, |
|---|
| | | case when xj.FCHECK_RESU ='合格' then 1 else case when xj.FCHECK_RESU ='不合格' then 2 else 0 end end xj |
|---|
| | | FROM womdaa a left join BZFS_WH bz on bz.ITEM_ID=a.daa002 |
|---|
| | |
|---|
| | | ItemId = reader.GetString(4) , // 新增字段 item_id 对应 daa002 |
|---|
| | | ItemNO=reader.GetString(5), |
|---|
| | | BZSL= reader.GetString(6), //包装数 |
|---|
| | | Itemname=reader.GetString(7), |
|---|
| | | Itemmodel= reader.GetString(8), |
|---|
| | | sj=reader.GetInt32(9), |
|---|
| | | xj=reader.GetInt32(10) |
|---|
| | | GDZT= reader.GetString(7), //工单状态 |
|---|
| | | Itemname=reader.GetString(8), |
|---|
| | | Itemmodel= reader.GetString(9), |
|---|
| | | sj=reader.GetInt32(10), |
|---|
| | | xj=reader.GetInt32(11) |
|---|
| | | }, parameters); |
|---|
| | | |
|---|
| | | if (orderDetailsList.Count == 0) |
|---|
