package com.yc.sdk.shopping.service;

import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import org.springframework.context.annotation.Scope;
import org.springframework.dao.DataAccessException;
import org.springframework.dao.EmptyResultDataAccessException;
import org.springframework.stereotype.Service;

import com.yc.action.grid.GridUtils;
import com.yc.sdk.shopping.entity.MatCodeImageEntity;
import com.yc.service.BaseService;
@Service("MatCodeImageImpl")
@Scope("prototype")
public class MatCodeImageImpl extends BaseService implements MatCodeImageIfc {

	@Override
	public List<MatCodeImageEntity> getMatCodeImage(String matCode) {
		String sql = " set nocount on ; select a.Image as Image \n"
				+ " from t710110 a join t110503 b on a.doccode = b.doccode \n"
				//+ "  join _sys_Attachment9 c on a.Image = c.UNID \n"
				+ " where b.MatCode = "+GridUtils.prossSqlParm(matCode)+" and ISNULL(b.Status,0) = 1 \n "
				+ " order by a.SortOrder asc ;" ;
		List<Map<String,Object>> list = null ;
		try {
			list = this.jdbcTemplate.queryForList(sql) ;
		}catch(DataAccessException e ) {
			if (e instanceof EmptyResultDataAccessException){
				return null ;
			}else {
				e.printStackTrace();
				 throw e;
			}
		}catch(Exception e){
			e.printStackTrace();
		    throw e;
		}
		
		List<MatCodeImageEntity> matCodeImageList = new ArrayList<MatCodeImageEntity>() ;
		for (int i = 0 ; list != null && i < list.size();i++) {
			Map<String,Object> map = list.get(i) ;
			MatCodeImageEntity matCodeImage = new MatCodeImageEntity() ;
			matCodeImage.setImage(map.get("Image") == null ? "": (String)map.get("Image"));
			matCodeImageList.add(matCodeImage);
		}
		return matCodeImageList;
	}

}