Pocket

Pocket 생성

• BPack.Pocket.App 프로젝트 - 업무모듈폴더 – 프로그램코드폴더내 생성

  : BPack.Pocket.App.업무모듈.프로그램코드.XxxPocket.cs

  ex) BPack.Pocket.App.MM.PurInbound.PurInboundPocket.cs

• Parent Class : PocketBase

  Ex) public class PurInboundPocket : PocketBase

  : PocketBase는 DB Connection 및 CRUD 처리 기능이 구현되어 있다.

• Implement Interface : IXxxPocket

  Ex) public class PurInboundPocket : PocketBase, IPurInboundPocket

  : IPurInboundPocket 인터페이스에 정의된 메서드에 대해 구현하여야 한다.

초기화

생성자에서 InitPocket(프로그램코드) 메서드 호출

public PurInboundPocket()
{
    InitPocket("PurInbound");
}

Query정보에서 프로그램 코드가 “PurInbound”인 데이터를 가져온다.

TB_SYS_QUERY 테이블의 정보로 쿼리ID, 커넥션, SP/TEXT분류, 쿼리문장등을 저장하고 있다.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using BPack.Common.Pocket;
using BPack.IPocket.App.MM.PurInbound;
using BPack.Model.App.MM.PurInbound;

namespace BPack.Pocket.App.MM.PurInbound
{
    public class PurInboundPocket : PocketBase, IPurInboundPocket
    {
        public PurInboundPocket()
        {
            InitPocket("PurInbound");
        }

        public void BpInDetail(List<InDetailModel> inDetailModels)
        {
            PocketExecute("MM.PurInbound.InDetail.BP", inDetailModels);
        }

        public void BpInHeader(List<InHeaderModel> inHeaderModels)
        {
            PocketExecute("MM.PurInbound.InHeader.BP", inHeaderModels);
        }

        public void BpInHu(List<InHuProcessModel> inHuProcessModels)
        {
            PocketExecute("MM.PurInbound.InHu.BP", GetParameters_StrapDisableParam(inHuProcessModels));
        }

        public void SaveInDetailModel(InDetailModel inDetailModel)
        {
            PocketExecute("MM.PurInbound.InDetail.Save", inDetailModel);
        }

        public void SaveInDetailModels(List<InDetailModel> inDetailModels)
        {
            PocketExecute("MM.PurInbound.InDetail.Save", inDetailModels);
        }

        public void SaveInHeaderModel(InHeaderModel inHeaderModel)
        {
            PocketExecute("MM.PurInbound.InHeader.Save", inHeaderModel);
        }

        public void SaveInHeaderModels(List<InHeaderModel> inHeaderModels)
        {
            PocketExecute("MM.PurInbound.InHeader.Save", inHeaderModels);
        }

        public void SaveInHuModel(InHuModel inHuModel)
        {
            PocketExecute("MM.PurInbound.InHu.Save", GetParameters_StrapDisableParam(inHuModel));
        }

        public void SaveInHuModels(List<InHuModel> inHuModels)
        {
            PocketExecute("MM.PurInbound.InHu.Save", GetParameters_StrapDisableParam(inHuModels));
        }

        public List<InDetailModel> SelectInDetailModels(PurInboundModelArgs args)
        {
            return PocketQuery<InDetailModel>("MM.PurInbound.InDetail.Select", new {
                PIH_NO = args.Select_Pih_No
            });
        }

        public List<InHeaderModel> SelectInHeaderModels(PurInboundModelArgs args)
        {
            return PocketQuery<InHeaderModel>("MM.PurInbound.InHeader.Select", new
            {
                COMP_CD = args.Select_Comp_Cd,
                BP_CD = args.Select_Main_Bp_Cd,
                PIH_NO = args.Select_Main_Pih_No
            });
        }

        public List<InHuModel> SelectInHuModels(PurInboundModelArgs args)
        {
            return PocketQuery<InHuModel>("MM.PurInbound.InHu.Select", new
            {
                PIH_NO = args.Select_Pih_No,
                PID_NO = args.Select_Pid_No
            });
        }
    }
}

Select 메서드

public List<InHeaderModel> SelectInHeaderModels(PurInboundModelArgs args)
{
    return PocketQuery<InHeaderModel>("MM.PurInbound.InHeader.Select", new
    {
        COMP_CD = args.Select_Comp_Cd,
        BP_CD = args.Select_Main_Bp_Cd,
        PIH_NO = args.Select_Main_Pih_No
    });
}

Save 메서드

필요에 의해 1행 데이터와 여러행 데이터에 해당하는 메서드를 구현한다.

public void SaveInHeaderModel(InHeaderModel inHeaderModel)
{
    PocketExecute("MM.PurInbound.InHeader.Save", inHeaderModel);
}

public void SaveInHeaderModels(List<InHeaderModel> inHeaderModels)
{
    PocketExecute("MM.PurInbound.InHeader.Save", inHeaderModels);
}