|  |  | 
 |  |  |                                     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; | 
 |  |  | 
 |  |  |                             #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; | 
 |  |  | 
 |  |  |                             #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; | 
 |  |  | 
 |  |  |                             #endregion | 
 |  |  |                             #region 盘点再入库 | 
 |  |  |                             case 57: | 
 |  |  |                                 ///根据工作号,查询工作明细档物料编码 | 
 |  |  |                                 ///根据工作号,查询工作明细档商品编号 | 
 |  |  |                                 sqlDetl = ""; | 
 |  |  |                                 sqlWaitIn = ""; | 
 |  |  |                                 sql = "select lgnum,tbnum,tbpos,matnr from asr_wrk_detl where wrk_no=" + li_wrk_no; | 
 |  |  | 
 |  |  |                         { | 
 |  |  |                             #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); | 
 |  |  | 
 |  |  |                     ProcWaitOutToLog("6"); // done | 
 |  |  |  | 
 |  |  |                     //删除超过半年历史档 | 
 |  |  |                     ProcOverYearLog("7"); | 
 |  |  |                     ProcOverYearLog("7"); // done | 
 |  |  |  | 
 |  |  |                     ProcErrorStockData("8"); | 
 |  |  |                     ProcErrorStockData("8"); // done | 
 |  |  |  | 
 |  |  |                     Thread.Sleep(3000); | 
 |  |  |                 } |