| | |
|---|
| | | /** |
|---|
| | | * 获取商品信息表资料 |
|---|
| | | */ |
|---|
| | | @Scheduled(cron = "${erp.refreshtime}") |
|---|
| | | // @Scheduled(cron = "${erp.refreshtime}") |
|---|
| | | public void obtainPedt() { |
|---|
| | | if (!enabledErpPrdt) return; |
|---|
| | | String sqlSelectPrdt = "select prd_no as prdNo,name,ut,spc,status,type,temp1 from ERP_PRDT where 1=1 and temp1 is null"; |
|---|
| | | String sqlSelectPrdt = "select prd_no as prdNo,name,ut,spc,status,type,temp1,temp2,temp3 from ERP_PRDT where 1=1 and temp1 is null"; |
|---|
| | | String sqlUpDatePrdtOne = "update ERP_PRDT set status=1 where prd_no="; |
|---|
| | | String sqlUpDatePrdtTwo = "update ERP_PRDT set status=2 "; |
|---|
| | | try { |
|---|
