Model

Mode - ModelArgs 생성

Models폴더 – 업무모듈폴더 – 프로그램코드폴더내 생성 : Models.업무모듈.프로그램코드.XxxModelArgs.cs ex) Models.MM.PurInBound.PurInBoundModelArgs.cs

ModelArgs Sample

namespace BPackWebMobile.Models.MM.PurInBound
{
    public class PurInBoundModelArgs : ModelArgsBase
    {
        public string Select_Pih_No { get; set; }
        public string Select_Hu_No { get; internal set; }
    }
}

ModelArgsBase 상속 Select 에서 사용할 PID_NO의 조건 값을 저장하는 속성이다.

Model 생성

업무모듈폴더, 업무기능폴더 아래 필요한 Model 을 생성한다. (​해당 업무기능 폴더내 Pocket 파일도 포함한다.)

예) Models/MM/PurInBound/PurInBoundHeaderModel.cs

ModelBase 상속

public class MovLocHeaderModel : ModelBase
{

}

Model 종류

Header - XxxHeaderModel Detail - XxxDetailModel Insert용도 - XxxInsertModel BusinessProcess 용도 - XxxBpModel 요청Parameters - XxxParamsModel 등... 상황에 따라 여러 용도로 생성하여 사용

Model Sample

public class PurInBoundHeaderModel : ModelBase
{
    [Display(Name = "구매입고번호")]
    public string PIH_NO { get; set; }
    [Display(Name = "회사코드")]
    public string COMP_CD { get; set; }
    [Display(Name = "거래처")]
    public string BP_CD { get; set; }
    [Display(Name = "입고공장")]
    public string IN_PLANT_CD { get; set; }
    [Display(Name = "입고예정번호")]
    public string DO_NO { get; set; }
    [Display(Name = "처리일시")]
    public DateTime? CLOSE_DTTM { get; set; }
    [Display(Name = "입고처리상태")]
    public string PIH_STATUS { get; set; }
    [Display(Name = "비고")]
    public string REMARK { get; set; }
    [Display(Name = "생성일시")]
    [DisplayFormat(DataFormatString = "{0:yyyy-MM-dd HH:mm}")]
    public DateTime CREATE_DTTM { get; set; }
    [Display(Name = "수정일시")]
    [DisplayFormat(DataFormatString = "{0:yyyy-MM-dd HH:mm}")]
    public DateTime MODIFY_DTTM { get; set; }
    [Display(Name = "생성자")]
    public string CREATE_USER_ID { get; set; }
    [Display(Name = "수정자")]
    public string MODIFY_USER_ID { get; set; }
}

Model Annotations

[Display(Name = "품번")]
[DisableParam(Insert = False) //Insert 처리시 제외한다.(Select,Insert,Update,Delete 속성이 있다)
public string ITEM_CD { get; set; }

[Display(Name = "품명")]
[DisableParam] //CRUD 모든 처리의 Parameter에서 제외한다.
public string ITEM_CD { get; set; }

Pocket 생성

Models폴더 – 업무모듈폴더 – 프로그램코드폴더내 생성 : Models.업무모듈.프로그램코드.XxxPocket.cs ex) Models.MM.PurInBound.PurInBoundPocket.cs

using BPackWebMobile.Models.Base;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

namespace BPackWebMobile.Models.MM.PurInBound
{
    public class PurInBoundPocket : PocketBase
    {
        public List<PurInBoundHeaderModel> SelectPurInboundHeaderModels(PurInBoundModelArgs args)
        {
            return PocketQuery<PurInBoundHeaderModel>("SELECT * FROM MM_PUR_INPH", null, System.Data.CommandType.Text);
        }

        public List<PurInBoundHuModel> SelectPurInboundHuModels(PurInBoundModelArgs args)
        {
            //샘플 쿼리문
            string sql = @"
SELECT 
      ROW_NUMBER() OVER(ORDER BY IU.CREATE_DTTM) AS ROW_NO
    , IU.PIH_NO
	, IU.HU_NO       
    , HM.ITEM_CD
	, HM.HU_INIT_QTY
	, HM.HU_STOCK_QTY
	, IU.INHU_INSP_STATUS    
	, IU.INHU_IN_STATUS      
	, IU.IN_DTTM             
	, IU.REMARK              
	, IU.DEL_FG              
	, IU.CREATE_DTTM         
	, IU.MODIFY_DTTM         
	, IU.CREATE_USER_ID      
	, IU.MODIFY_USER_ID      
FROM MM_PUR_INHU AS IU
JOIN MM_HUM_MAST AS HM ON IU.HU_NO = HM.HU_NO
WHERE IU.PIH_NO = @PIH_NO
";
            return PocketQuery<PurInBoundHuModel>(sql, new { PIH_NO = args.Select_Pih_No }, System.Data.CommandType.Text);
        }

        public void InsertPurInboundHuModels(List<PurInBoundHuModel> purInHuModels)
        {
            PocketExecute("MM.PurInbound.Pda.InHu.Insert", ConvertParameters(purInHuModels, Crud.Insert));
        }

        internal void DeletePurInboundHuModel(PurInBoundModelArgs args)
        {
            PocketExecute("MM.PurInbound.Pda.InHu.Delete", new { PIH_NO = args.Select_Pih_No, HU_NO = args.Select_Hu_No });
        }

        public void InsertPurInBoundHeaderDetail(PurInBoundHeaderModel  purInBoundHeaderModel, List<PurInBoundHuModel> purInBoundHuModels)
        {
            HeaderDetailModelArgs headerDetailModelArgs = new HeaderDetailModelArgs() {
                HeaderPK = new string[] { "PIH_NO" },
                HeaderQueryID = "MM.PurInbound.Pda.InHeader.Insert",
                DetailFK = new string[] { "PIH_NO" },
                DetailQueryID = "MM.PurInbound.Pda.InHu.Insert"
            };
            PocketInsertHeaderDetail<PurInBoundHeaderModel, PurInBoundHuModel>(purInBoundHeaderModel, purInBoundHuModels, headerDetailModelArgs);
        }
    }
}