egovframework.rfc3.fooderp.dao
Class ErpDAO

java.lang.Object
  org.springframework.dao.support.DaoSupport
      org.springframework.orm.ibatis.support.SqlMapClientDaoSupport
          egovframework.rte.psl.dataaccess.EgovAbstractDAO
              egovframework.rfc3.common.dao.RfcCMSAbstractDAO
                  egovframework.rfc3.fooderp.dao.ErpDAO

All Implemented Interfaces:

org.springframework.beans.factory.InitializingBean

@Repository(value="ErpDAO")
public class ErpDAO
extends RfcCMSAbstractDAO

Constructor Summary

ErpDAO()

Method Summary

LoginVO	actionLogin(java.lang.String partnerCd) 생산자 지원 로그인 하기
void	deleteBizProd(ProdMstVO prodMstVO) 취급상품 삭제
void	deleteDeliveryPlanSub(DeliveryPlanVO deliveryPlanVO)
void	deleteFarmDiary(FarmingVO farmingVO)
void	deleteFarmDiarySub(FarmingVO farmingVO)
void	deleteFarmMstVO(FarmMstVO farmMstVO) 생산자정보 삭제
DeliveryPlanVO	getDeliveryPlan(DeliveryPlanVO deliveryPlanVO)
FarmingVO	getFarming(FarmingVO farmingVO)
void	insertDeliveryPlanSub(PlanSubVO planSubVO)
void	insertFarmDiary(FarmingVO farmingVO)
void	insertFarmDiarySub(FarmingVO farmingVO)
void	insertFarmMstVO(FarmMstVO farmMstVO) 재배지 정보 입력
void	insertProdMstVO(ProdMstVO prodMstVO) 취급상품 등록
java.util.List<CodeMstSubVO>	selectCodeMstSub(java.lang.String param)
java.util.List<CodeMstVO>	selectCodeMstVO(CodeMstVO codeMstVO)
java.util.List<FarmMstVO>	selectCodeSearch(FarmMstVO farmMstVO) 거래처 재배지 정보
java.util.List<ProdMstVO>	selectCodeSearch(ProdMstVO prodMstVO) 상품검색 다중 검색 ()
java.util.List<ProdMstVO>	selectCodeSearchList(ProdMstVO prodMstVO) 취급상품 조건 검색
java.util.List<ProdContractVO>	selectContractList(ProdContractVO prodContractVO) 계약정보 조회 리스트
int	selectContractTotal(ProdContractVO prodContractVO) 계약정보 조회 카운트
ProdContractVO	selectContractVO(ProdContractVO prodContractVO) 생산계약 상세보기
java.util.List<DeliveryPlanVO>	selectDeliveryPlan(DeliveryPlanVO deliveryPlanVO)
java.util.List<PlanSubVO>	selectDeliveryPlanChangeList(DeliveryPlanVO deliveryPlanVO)
java.util.List<PlanSubVO>	selectDeliveryPlanPackList(DeliveryPlanVO deliveryPlanVO)
java.util.List<PlanSubVO>	selectDeliveryPlanSubList(DeliveryPlanVO deliveryPlanVO)
int	selectDeliveryPlanSubTotal(DeliveryPlanVO deliveryPlanVO)
java.util.List<PlanSubVO>	selectDeliverySubTradeInfo(DeliveryPlanVO deliveryPlanVO)
java.util.List<PlanSubVO>	selectDeliveryTradeInfo(DeliveryPlanVO deliveryPlanVO)
java.util.List<FarmingVO>	selectFarmingList(FarmingVO farmingVO)
int	selectFarmingListTotal(FarmingVO farmingVO)
long	selectFarmingMaxId()
java.util.List<FarmingSubVO>	selectFarmingSubList(FarmingVO farmingVO) 재배지 정보
int	selectFarmSidCnt() 재배지정보 입력 sid
java.util.List<OrderIngVO>	selectOrderIngCalculateList(OrderIngVO orderIngVO) 정산관리
java.util.List<OrderIngVO>	selectOrderIngCodeVO(OrderIngVO orderIngVO) 납품관리 상세보기(납품 코드별 상품)
java.util.List<OrderIngVO>	selectOrderIngList(OrderIngVO orderIngVO) 납품관리
int	selectOrderIngTotal(OrderIngVO orderIngVO) 납품관리 페이징 카운트
OrderIngVO	selectOrderIngVO(OrderIngVO orderIngVO) 납품관리 상세보기
java.util.List<PackMainVO>	selectPackCode(PackMainVO packMainVO)
int	selectPackCodeTotal(PackMainVO packMainVO)
java.util.List<PartnerVO>	selectPartnerList(PartnerVO partnerVO) 생산자 정보 리스트
int	selectPartnerTotal(PartnerVO partnerVO) 생산자 정보 전체 카운팅
PartnerVO	selectPartnerVO(PartnerVO partnerVO) 생산자 정보 상세보기
java.util.List<PesticideVO>	selectPesticideInfo(PesticideVO pesticideVO)
java.util.List<ProdDivision>	selectProdDivisionList(ProdDivision prodDivision)
java.util.List<ProdDivision>	selectProdDivisionVOList(ProdDivision prodDivision)
java.util.List<ProdMstVO>	selectProdMstList(ProdMstVO prodMstVO) 취급상품 코드 리스트 T_BIZ_PROD(partnerCd) & T_PROD_MST 이너조인
java.util.List<PlanSubVO>	selectTradeInfo(DeliveryPlanVO deliveryPlanVO)
void	updateFarmDiary(FarmingVO farmingVO)
void	updatePartnerVO(PartnerVO partnerVO) 생산자 정보 수정

Methods inherited from class egovframework.rfc3.common.dao.RfcCMSAbstractDAO

delete, desDecoding, desDecoding2, desDecodingList, desDecodingList2, desEncoding, desEncoding2, insert, list, listWithPaging, selectByPk, setSuperSqlMapClient, update

Methods inherited from class org.springframework.orm.ibatis.support.SqlMapClientDaoSupport

getDataSource, getSqlMapClient, getSqlMapClientTemplate, setDataSource, setSqlMapClient, setSqlMapClientTemplate

Methods inherited from class org.springframework.dao.support.DaoSupport

afterPropertiesSet

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

ErpDAO

public ErpDAO()

Method Detail

selectPackCode

public java.util.List<PackMainVO> selectPackCode(PackMainVO packMainVO)
                                          throws java.lang.Exception

Throws:

java.lang.Exception

selectPackCodeTotal

public int selectPackCodeTotal(PackMainVO packMainVO)
                        throws java.lang.Exception

Throws:

java.lang.Exception

selectDeliveryPlan

public java.util.List<DeliveryPlanVO> selectDeliveryPlan(DeliveryPlanVO deliveryPlanVO)
                                                  throws java.lang.Exception

Throws:

java.lang.Exception

selectCodeMstSub

public java.util.List<CodeMstSubVO> selectCodeMstSub(java.lang.String param)
                                              throws java.lang.Exception

Throws:

java.lang.Exception

selectDeliveryPlanSubTotal

public int selectDeliveryPlanSubTotal(DeliveryPlanVO deliveryPlanVO)
                               throws java.lang.Exception

Throws:

java.lang.Exception

selectDeliveryPlanSubList

public java.util.List<PlanSubVO> selectDeliveryPlanSubList(DeliveryPlanVO deliveryPlanVO)
                                                    throws java.lang.Exception

Throws:

java.lang.Exception

selectDeliveryPlanPackList

public java.util.List<PlanSubVO> selectDeliveryPlanPackList(DeliveryPlanVO deliveryPlanVO)
                                                     throws java.lang.Exception

Throws:

java.lang.Exception

selectDeliveryPlanChangeList

public java.util.List<PlanSubVO> selectDeliveryPlanChangeList(DeliveryPlanVO deliveryPlanVO)
                                                       throws java.lang.Exception

Throws:

java.lang.Exception

getDeliveryPlan

public DeliveryPlanVO getDeliveryPlan(DeliveryPlanVO deliveryPlanVO)
                               throws java.lang.Exception

Throws:

java.lang.Exception

deleteDeliveryPlanSub

public void deleteDeliveryPlanSub(DeliveryPlanVO deliveryPlanVO)
                           throws java.lang.Exception

Throws:

java.lang.Exception

insertDeliveryPlanSub

public void insertDeliveryPlanSub(PlanSubVO planSubVO)
                           throws java.lang.Exception

Throws:

java.lang.Exception

selectDeliverySubTradeInfo

public java.util.List<PlanSubVO> selectDeliverySubTradeInfo(DeliveryPlanVO deliveryPlanVO)
                                                     throws java.lang.Exception

Throws:

java.lang.Exception

selectDeliveryTradeInfo

public java.util.List<PlanSubVO> selectDeliveryTradeInfo(DeliveryPlanVO deliveryPlanVO)
                                                  throws java.lang.Exception

Throws:

java.lang.Exception

selectTradeInfo

public java.util.List<PlanSubVO> selectTradeInfo(DeliveryPlanVO deliveryPlanVO)
                                          throws java.lang.Exception

Throws:

java.lang.Exception

selectPesticideInfo

public java.util.List<PesticideVO> selectPesticideInfo(PesticideVO pesticideVO)
                                                throws java.lang.Exception

Throws:

java.lang.Exception

selectPartnerList

public java.util.List<PartnerVO> selectPartnerList(PartnerVO partnerVO)
                                            throws java.lang.Exception

생산자 정보 리스트

Parameters:

partnerVO -

Returns:

Throws:

java.lang.Exception

selectPartnerTotal

public int selectPartnerTotal(PartnerVO partnerVO)
                       throws java.lang.Exception

생산자 정보 전체 카운팅

Parameters:

partnerVO -

Returns:

Throws:

java.lang.Exception

selectProdMstList

public java.util.List<ProdMstVO> selectProdMstList(ProdMstVO prodMstVO)

취급상품 코드 리스트 T_BIZ_PROD(partnerCd) & T_PROD_MST 이너조인

Parameters:

prodMstVO - : partnerCd PK값 사용

Returns:

selectCodeMstVO

public java.util.List<CodeMstVO> selectCodeMstVO(CodeMstVO codeMstVO)
                                          throws java.lang.Exception

Throws:

java.lang.Exception

selectProdDivisionList

public java.util.List<ProdDivision> selectProdDivisionList(ProdDivision prodDivision)
                                                    throws java.lang.Exception

Parameters:

prodDivision -

Returns:

Throws:

java.lang.Exception

selectProdDivisionVOList

public java.util.List<ProdDivision> selectProdDivisionVOList(ProdDivision prodDivision)
                                                      throws java.lang.Exception

Parameters:

prodDivision -

Returns:

Throws:

java.lang.Exception

selectCodeSearch

public java.util.List<ProdMstVO> selectCodeSearch(ProdMstVO prodMstVO)

상품검색 다중 검색 ()

Parameters:

prodMstVO -

searchKey1 - 대분류

searchKey2 - 중분류

searchKey3 - 상품코드

searchKey4 - 상품명

Returns:

selectPartnerVO

public PartnerVO selectPartnerVO(PartnerVO partnerVO)
                          throws java.lang.Exception

생산자 정보 상세보기

Parameters:

partnerVO -

Returns:

Throws:

java.lang.Exception

selectCodeSearch

public java.util.List<FarmMstVO> selectCodeSearch(FarmMstVO farmMstVO)
                                           throws java.lang.Exception

거래처 재배지 정보

Parameters:

farmMstVO -

Returns:

Throws:

java.lang.Exception

updatePartnerVO

public void updatePartnerVO(PartnerVO partnerVO)
                     throws java.lang.Exception

생산자 정보 수정

Parameters:

partnerVO -

Throws:

java.lang.Exception

insertProdMstVO

public void insertProdMstVO(ProdMstVO prodMstVO)
                     throws java.lang.Exception

취급상품 등록

Parameters:

prodMstVO -

Throws:

java.lang.Exception

selectCodeSearchList

public java.util.List<ProdMstVO> selectCodeSearchList(ProdMstVO prodMstVO)
                                               throws java.lang.Exception

취급상품 조건 검색

Parameters:

ProdMstVO -

Returns:

Throws:

java.lang.Exception

selectFarmSidCnt

public int selectFarmSidCnt()
                     throws java.lang.Exception

재배지정보 입력 sid

Returns:

Throws:

java.lang.Exception

insertFarmMstVO

public void insertFarmMstVO(FarmMstVO farmMstVO)
                     throws java.lang.Exception

재배지 정보 입력

Parameters:

farmMstVO -

Throws:

java.lang.Exception

deleteBizProd

public void deleteBizProd(ProdMstVO prodMstVO)
                   throws java.lang.Exception

취급상품 삭제

Parameters:

prodMstVO -

Throws:

java.lang.Exception

actionLogin

public LoginVO actionLogin(java.lang.String partnerCd)
                    throws java.lang.Exception

생산자 지원 로그인 하기

Parameters:

partnerCd -

Returns:

Throws:

java.lang.Exception

selectContractList

public java.util.List<ProdContractVO> selectContractList(ProdContractVO prodContractVO)
                                                  throws java.lang.Exception

계약정보 조회 리스트

Parameters:

prodContractVO -

Returns:

Throws:

java.lang.Exception

selectContractTotal

public int selectContractTotal(ProdContractVO prodContractVO)
                        throws java.lang.Exception

계약정보 조회 카운트

Parameters:

prodContractVO -

Returns:

Throws:

java.lang.Exception

selectContractVO

public ProdContractVO selectContractVO(ProdContractVO prodContractVO)
                                throws java.lang.Exception

생산계약 상세보기

Parameters:

prodContractVO -

Returns:

Throws:

java.lang.Exception

selectOrderIngList

public java.util.List<OrderIngVO> selectOrderIngList(OrderIngVO orderIngVO)
                                              throws java.lang.Exception

납품관리

Parameters:

orderIngVO -

Returns:

Throws:

java.lang.Exception

selectOrderIngTotal

public int selectOrderIngTotal(OrderIngVO orderIngVO)
                        throws java.lang.Exception

납품관리 페이징 카운트

Parameters:

orderIngVO -

Returns:

Throws:

java.lang.Exception

selectOrderIngVO

public OrderIngVO selectOrderIngVO(OrderIngVO orderIngVO)
                            throws java.lang.Exception

납품관리 상세보기

Parameters:

orderIngVO -

Returns:

Throws:

java.lang.Exception

selectOrderIngCodeVO

public java.util.List<OrderIngVO> selectOrderIngCodeVO(OrderIngVO orderIngVO)
                                                throws java.lang.Exception

납품관리 상세보기(납품 코드별 상품)

Parameters:

orderIngVO -

Returns:

Throws:

java.lang.Exception

deleteFarmMstVO

public void deleteFarmMstVO(FarmMstVO farmMstVO)
                     throws java.lang.Exception

생산자정보 삭제

Parameters:

prodMstVO -

Throws:

java.lang.Exception

selectOrderIngCalculateList

public java.util.List<OrderIngVO> selectOrderIngCalculateList(OrderIngVO orderIngVO)
                                                       throws java.lang.Exception

정산관리

Parameters:

orderIngVO -

Returns:

Throws:

java.lang.Exception

selectFarmingMaxId

public long selectFarmingMaxId()
                        throws java.lang.Exception

Throws:

java.lang.Exception

selectFarmingListTotal

public int selectFarmingListTotal(FarmingVO farmingVO)
                           throws java.lang.Exception

Throws:

java.lang.Exception

selectFarmingList

public java.util.List<FarmingVO> selectFarmingList(FarmingVO farmingVO)
                                            throws java.lang.Exception

Throws:

java.lang.Exception

getFarming

public FarmingVO getFarming(FarmingVO farmingVO)
                     throws java.lang.Exception

Throws:

java.lang.Exception

insertFarmDiary

public void insertFarmDiary(FarmingVO farmingVO)
                     throws java.lang.Exception

Throws:

java.lang.Exception

updateFarmDiary

public void updateFarmDiary(FarmingVO farmingVO)
                     throws java.lang.Exception

Throws:

java.lang.Exception

deleteFarmDiary

public void deleteFarmDiary(FarmingVO farmingVO)
                     throws java.lang.Exception

Throws:

java.lang.Exception

selectFarmingSubList

public java.util.List<FarmingSubVO> selectFarmingSubList(FarmingVO farmingVO)
                                                  throws java.lang.Exception

재배지 정보

Parameters:

farmingVO -

Returns:

Throws:

java.lang.Exception

insertFarmDiarySub

public void insertFarmDiarySub(FarmingVO farmingVO)
                        throws java.lang.Exception

Throws:

java.lang.Exception

deleteFarmDiarySub

public void deleteFarmDiarySub(FarmingVO farmingVO)
                        throws java.lang.Exception

Throws:

java.lang.Exception