|  |  | 
 |  |  |                     { | 
 |  |  |                         switch (li_io_type) | 
 |  |  |                         { | 
 |  |  |                             #region 空托盘入库 | 
 |  |  |                             #region 空货架入库 | 
 |  |  |                             case 10: | 
 |  |  |                                 sql = "update asr_loc_mast set loc_sts='D',io_time='" + ldt_date + "',modi_time='" + ldt_date + "'"; | 
 |  |  |                                 sql += " where loc_no='" + ls_loc_no + "' and (loc_sts = 'S' Or loc_sts = 'Q')"; | 
 |  |  | 
 |  |  |                                     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); | 
 |  |  |                 } |