package com.slcf.service.impl;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.slcf.bean.LocationCondition;
import com.slcf.dao.LocationDao;
import com.slcf.pojo.LocationBean;
import com.slcf.service.LocationService;

/**
 * 库位管理接口实现
 * @author admin
 * @date 2018年11月7日
 */
@Service
public class LocationServiceImpl implements LocationService {

	@Autowired
	LocationDao locationDao;
	
	/**
	 * 添加
	 */
	public int insertLocation(LocationBean location) {
		int result=0;
		try {
			result=locationDao.insertLocation(location);
		}catch(Exception e) {
			System.out.println(e.getMessage());
		}
		return result;
	}

//	/**
//	 * 统计数量
//	 */
//	public int queryLocationCount(){
//		int result = 0;
//		try {
//			result = locationDao.getLocationCount();
//		}catch(Exception e) {
//			System.out.println(e.getMessage());
//		}
//		return result;
//	}

	/**
	 * 分页查询所有
	 */
	public Map<String,Object> queryLocationList(LocationCondition locationCon) {
		try {
			Map<String,Object> map=new HashMap<String, Object>();
			List<LocationBean> list=locationDao.queryLocationList(locationCon);
			int count =locationDao.getLocationCount(locationCon);
			map.put("rows", list);
			map.put("total", count);
			return map;
		}catch(Exception e) {
			System.out.println(e.getMessage());
			return null;
		}
	}
//	public List<LocationBean> queryLocationList(int spage, int epage) {
//		try {
//			return locationDao.queryLocationList(spage, epage);
//		}catch(Exception e) {
//			System.out.println(e.getMessage());
//			return null;
//		}
//	}

	/**
	 * 根据id查找
	 */
	public LocationBean queryLocationById(String id) {
		LocationBean location = new LocationBean();
		try {
			location = locationDao.getLocationById(id);
		}catch(Exception e) {
			System.out.println(e.getMessage());
		}
		return location;
	}
	
	//更新
	public int upLocation(LocationBean location) {
		int result=0;
		try {
			result=locationDao.upLocation(location);
		}catch(Exception e) {
			System.out.println(e.getMessage());
		}
		return result;
	}

	/**
	 * 根据id删除
	 */
	public int delLocation(String did) {
		int result=0;
		try {
			result=locationDao.delLocationById(did);
		}catch(Exception e) {
			System.out.println(e.getMessage());
		}
		return result;
	}

	/**
	 * 查询所有
	 * @return
	 */
	public List<LocationBean> getLocationList() {
		try {
			return locationDao.getLocationList();
		}catch(Exception e) {
			System.out.println(e.getMessage());
			return null;
		}
	}
	
	/**
	 * 删除所有库位
	 */
	public int resetLocation() {
		int result=0;
		try {
			result=locationDao.resetLocation();
		}catch(Exception e) {
			System.out.println(e.getMessage());
		}
		return result;
	}

	public List<LocationBean> getRowList() {
		List<LocationBean> list = null;
		try {
			list = locationDao.getRowList();
		}catch(Exception e) {
			System.out.println(e.getMessage());
		}
		return list;
	}
	
	/**
	 * 根据id查找
	 */
	public LocationBean getLocNoByRow(int row1, int loc_type) {
		LocationBean location = new LocationBean();
		try {
			location = locationDao.getLocNo(row1, loc_type);
		}catch(Exception e) {
			System.out.println(e.getMessage());
		}
		return location;
	}
	
	public String getLocationListBySts(String loc_sts) {
		try {
			return locationDao.getLocationListBySts(loc_sts);
		}catch(Exception e) {
			System.out.println(e.getMessage());
			return null;
		}
	}
	
	/**
	 * 根据库位状态查找
	 */
	public String queryLocationBySts(String loc_sts) {
//		LocationBean location = new LocationBean();
		String loc_no = "";
		try {
			loc_no = locationDao.getLocationBySts(loc_sts);
		}catch(Exception e) {
			System.out.println(e.getMessage());
		}
		return loc_no;
	}
	
	/**
	 * 根据条码号查找
	 */
	public String queryLocationByBarcode(String barcode) {
		String loc_no = "";
		try {
			loc_no = locationDao.getLocationByBarcode(barcode);
		}catch(Exception e) {
			System.out.println(e.getMessage());
		}
		return loc_no;
	}
}