连接ERP 获取ERP库存信息

zyx

2023-10-18 080fdceed464c56f43633e85daeaf929d40496af

 src/main/resources/UpdateThread.cs

@@ -835,7 +835,7 @@
                                    goto re;
                                }

                                ///根据工作号，查询工作明细档物料编码
                                ///根据工作号，查询工作明细档商品编号
                                string sqlDetl = "";
                                string sqlWaitIn = "";
                                sql = "select lgnum,tbnum,tbpos,zmatid,matnr,maktx,werks,anfme,altme,zpallet,bname from asr_wrk_detl where wrk_no=" + li_wrk_no;
@@ -910,7 +910,7 @@
                            #endregion
                            #region 拣料再入库
                            case 53:
                                ///根据工作号，查询工作明细档物料编码
                                ///根据工作号，查询工作明细档商品编号
                                sqlDetl = "";
                                sqlWaitIn = "";
                                sql = "select lgnum,tbnum,tbpos,zmatid,matnr,maktx,werks,anfme,altme,zpallet,bname from asr_wrk_detl where wrk_no=" + li_wrk_no;
@@ -964,7 +964,7 @@
                            #endregion
                            #region 并板再入库
                            case 54:
                                ///根据工作号，查询工作明细档物料编码
                                ///根据工作号，查询工作明细档商品编号
                                sqlDetl = "";
                                sqlWaitIn = "";
                                sql = "select lgnum,tbnum,tbpos,zmatid,matnr,maktx,werks,anfme,altme,zpallet,bname from asr_wrk_detl where wrk_no=" + li_wrk_no;
@@ -1030,7 +1030,7 @@
                            #endregion
                            #region 盘点再入库
                            case 57:
                                ///根据工作号，查询工作明细档物料编码
                                ///根据工作号，查询工作明细档商品编号
                                sqlDetl = "";
                                sqlWaitIn = "";
                                sql = "select lgnum,tbnum,tbpos,matnr from asr_wrk_detl where wrk_no=" + li_wrk_no;
@@ -1133,7 +1133,7 @@
                        {
                            #region 全板出库
                            case 101:
                                ///根据工作号，查询工作明细档物料编码
                                ///根据工作号，查询工作明细档商品编号
                                string sqlWaitIn = "";
                                sql = "select lgnum,tbnum,tbpos,matnr from asr_wrk_detl where wrk_no=" + li_wrk_no;
                                DataView dv_wrkdetl = Common.ExecAsrsSelect(sql);
@@ -1699,13 +1699,13 @@
                    ProcLocToWorkData("11");

                    //处理工作档状态4、14、6的资料
                    ProcWorkMast("2");
                    ProcWorkMast("2"); // done

                    //工作档转历史档
                    //工作档转历史档 // done
                    ProcWorkToLog("3");

                    //堆垛机&PLC命令转历史档
                    ProcDevCommandToLog("4");
                    ProcDevCommandToLog("4"); // done

                    //转已完成物料信息到历史档
                    //ProcMatCodeToLog("5");
@@ -1713,12 +1713,12 @@
                    ProcCheckToWorkData("5");

                    //转出库完成待出库档数据到历史档
                    ProcWaitOutToLog("6");
                    ProcWaitOutToLog("6"); // done

                    //删除超过半年历史档
                    ProcOverYearLog("7");
                    ProcOverYearLog("7"); // done

                    ProcErrorStockData("8");
                    ProcErrorStockData("8"); // done

                    Thread.Sleep(3000);
                }