| | |
| | | "sql_db_name": "LZGS", |
| | | "sql_username": "sa", |
| | | "sql_password": "basic@2023", |
| | | "nsq_server": "fai365.com:4150", |
| | | "nsq_server": "121.31.232.83:4150", |
| | | "nsq_webapi": "http://121.31.232.83:9080/api/nsq/pub?topic=your_topic", |
| | | "order_topic": "aps.factory.erp.seorder", |
| | | "inventory_topic": "aps.factory.erp.inventory", |
| | | "query_topic": "aps.factory.erp.k3resource", |
| | | "reply_topic": "aps.factory.erp.k3reply", |
| | | "order_topic": "aps.wangpengfei.erp.seorder", |
| | | "inventory_topic": "aps.wangpengfei.erp.inventory", |
| | | "query_topic": "aps.wangpengfei.erp.k3resource", |
| | | "reply_topic": "aps.wangpengfei.erp.k3reply", |
| | | "cst_webapi": "http://192.168.20.249/cst/local_post.ashx", |
| | | "cst_query_topic": "aps.factory.erp.cstApply", |
| | | "cst_reply_topic": "aps.factory.erp.cstReply", |
| | | "cst_query_topic": "aps.wangpengfei.erp.cstApply", |
| | | "cst_reply_topic": "aps.wangpengfei.erp.cstReply", |
| | | "interval": 60, |
| | | "debug": false |
| | | } |
| | |
| | | logger.Warn("解析请求失败, %s", err.Error()) |
| | | return err |
| | | } |
| | | logger.Debug("接收到创建生产任务单请求, 共%d条订单", len(query)) |
| | | |
| | | for _, q := range query { |
| | | ret := Commit2CSTService(q) |
| | |
| | | TOP (100) PERCENT item.FNumber AS FNumber, |
| | | item.FName AS FName, |
| | | item.FModel AS FModel, |
| | | item.FSource AS FSource, |
| | | ti1.FNumber AS FSource, |
| | | i.FBatchNo AS FBatchNo, |
| | | s.FNumber AS FStockNo, |
| | | s.FName AS FStockName, |
| | |
| | | LEFT OUTER JOIN t_ICItem AS item ON i.FItemID = item.FItemID |
| | | LEFT OUTER JOIN t_Stock AS s ON i.FStockID = s.FItemID |
| | | LEFT OUTER JOIN t_Item AS ti ON item.FUnitID = ti.FItemID |
| | | LEFT OUTER JOIN t_Item AS ti1 ON item.FSource = ti1.FItemID |
| | | LEFT OUTER JOIN t_Item AS ti2 ON item.FStoreUnitID = ti2.FItemID |
| | | LEFT OUTER JOIN t_Item AS ti3 ON LEFT (item.FNumber, 5) = ti3.FNumber |
| | | AND ti3.FItemClassID = 4 |