XinYu_LZMES/.svn/pristine/94/94b5ac405436697363b33016656dca826a2abb35.svn-base

<?xml version="1.0" encoding="UTF-8"?>
<queryMap desc="公差检验管理">
<select id="QCM030310_QUERYMEASURE" desc="获取综合判定检验实绩信息">
select 
          SIC_ID,
          HEAT_NO,
          BATCH_NO,
          INSPECTION_LOT,
          MATERIAL_NO,
          SIC_RESULT_CODE,
          SIC_RESULT_DESC,
          SIC_MEMO,
          PROD_THICK,
          PROD_WIDTH,
          PROD_LENGTH,
          JUDGE_THICK,
          JUDGE_WIDTH,
          JUDGE_LENGTH,
          WEIGHT,
          SOUTH_THICK_VAL,
          SOUTH_H_VAL,
          SOUTH_M_VAL,
          SOUTH_R_VAL,
          MIDDLE_THICK_VAL,
          MIDDLE_H_VAL,
          MIDDLE_M_VAL,
          MIDDLE_R_VAL,
          NORTH_THICK_VAL,  
          NORTH_H_VAL,
          NORTH_M_VAL,
          NORTH_R_VAL,
          PLINE_CODE,
          PLINE_NAME,
          JUDGE_UNEVENNESS,
		  JUDGE_CAMBER,
		  JUDGE_OFFSQUARE,
          JUDGE_TURRIFORM,
          WRK_ORD,
          WRK_GRP,
          JUDGE_NAME,
          JUDGE_TIME
      from QCM_JUDGE_MEASURE
      where 
          SIC_ID=#{param1}
</select>

</queryMap>