예제 #1
0
        private void DataGridViewColumnSet()
        {
            //데이터그리드뷰 초기설정
            DataGridViewUtil.InitSettingGridView(dgvCompanyList);
            //데이터그리드뷰 체크박스 컬럼 추가
            DataGridViewUtil.DataGridViewCheckBoxSet(dgvCompanyList, "");
            DataGridViewColumn col = dgvCompanyList.Columns[0];

            col.Frozen = true;
            //일반컬럼 추가
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCompanyList, "업체코드", "COM_CODE", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCompanyList, "업체명", "COM_NAME", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCompanyList, "업체타입명", "COM_TYP", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCompanyList, "대표자명", "COM_CEO", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCompanyList, "사업자등록번호", "COM_REG_NUM", true, 140);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCompanyList, "업종", "COM_TYP_INDSTRY", true, 80);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCompanyList, "업태", "COM_TYP_BSNS", true, 80);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCompanyList, "담당자명", "COM_MANAGER", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCompanyList, "이메일", "COM_EML", true, 160);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCompanyList, "전화번호", "COM_TEL", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCompanyList, "팩스", "COM_FAX", true, 80);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCompanyList, "출하자동입고유무", "COM_AUTOIN_YN", true, 150);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCompanyList, "출발유무", "COM_START_YN", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCompanyList, "사용유무", "COM_USE_YN", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCompanyList, "수정자", "COM_LAST_MDFR", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCompanyList, "최종수정시간", "COM_LAST_MDFY", true, 120);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCompanyList, "거래유무", "COM_TRAD_YN", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCompanyList, "거래시작일", "COM_STR_DATE", false, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCompanyList, "거래종료일", "COM_END_DATE", false, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCompanyList, "업체정보", "COM_INFO", false, 100);
            dgvCompanyList.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            dgvCompanyList.ColumnHeadersDefaultCellStyle.Font      = new Font("맑은 고딕", 9.75F, FontStyle.Bold);
            DataGridViewUtil.DataGridViewRowNumSet(dgvCompanyList);
            DataGridViewCheckBoxAllCheck();
        }
예제 #2
0
        private void DataGridViewColumnSet()
        {
            //데이터그리드뷰 초기설정
            DataGridViewUtil.InitSettingGridView(dgvProductOUT);
            //데이터그리드뷰 체크박스 컬럼 추가
            DataGridViewUtil.DataGridViewCheckBoxSet(dgvProductOUT, "");
            DataGridViewColumn dc = dgvProductOUT.Columns[0];

            dc.Frozen = true;
            //일반컬럼 추가
            DataGridViewUtil.AddNewColumnToDataGridView(dgvProductOUT, "고객주문번호", "SALES_WORK_ORDER_ID", true, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvProductOUT, "납기일", "SALES_DUEDATE", true, 150);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvProductOUT, "고객사코드", "COM_CODE", true, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvProductOUT, "고객사", "COM_NAME", true, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvProductOUT, "도착지코드", "SALES_COM_CODE", true, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvProductOUT, "품목", "ITEM_CODE", true, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvProductOUT, "품명", "ITEM_NAME", true, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvProductOUT, "주문수량", "WO_PLAN_QTY", true, 120, DataGridViewContentAlignment.MiddleRight);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvProductOUT, "현재고량", "INS_QTY", true, 110, DataGridViewContentAlignment.MiddleRight);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvProductOUT, "출고된수량", "OUTed_QTY", true, 110, DataGridViewContentAlignment.MiddleRight);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvProductOUT, "출고할수량", "OUTing_QTY", true, 110, readOnly: false);
            dgvProductOUT.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            dgvProductOUT.ColumnHeadersDefaultCellStyle.Font      = new Font("맑은 고딕", 9.75F, FontStyle.Bold);
            DataGridViewUtil.DataGridViewRowNumSet(dgvProductOUT);
            DataGridViewCheckBoxAllCheck();
        }
예제 #3
0
        private void DataGridViewColumnSet()
        {
            //설비군
            //데이터그리드뷰 초기설정
            DataGridViewUtil.InitSettingGridView(dgvCom);
            //데이터그리드뷰 체크박스 컬럼 추가
            DataGridViewUtil.DataGridViewCheckBoxSet(dgvCom, "");
            //일반컬럼 추가
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCom, "업체코드", "SALES_COM_CODE", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCom, "업체명", "COM_NAME", true, 110);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCom, "사업자등록번호", "COM_REG_NUM", true, 120);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCom, "매출액", "SALES_TTL", true, 100, DataGridViewContentAlignment.MiddleRight);
            dgvCom.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            dgvCom.ColumnHeadersDefaultCellStyle.Font      = new Font("맑은 고딕", 9.75F, FontStyle.Bold);
            DataGridViewUtil.DataGridViewRowNumSet(dgvCom);
            DataGridViewCheckBoxAllCheck();


            //설비
            //데이터그리드뷰 초기설정
            DataGridViewUtil.InitSettingGridView(dgvComDetail);
            //데이터그리드뷰 체크박스 컬럼 추가
            //일반컬럼 추가
            DataGridViewUtil.AddNewColumnToDataGridView(dgvComDetail, "업체코드", "SALES_COM_CODE", true, 240);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvComDetail, "업체명", "COM_NAME", true, 240);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvComDetail, "마감일", "SALES_ENDDATE", true, 250);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvComDetail, "판매수량", "SALES_QTY", true, 200, DataGridViewContentAlignment.MiddleRight);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvComDetail, "단가", "unitprice", true, 200, DataGridViewContentAlignment.MiddleRight);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvComDetail, "총판매액", "SALES_TTL", true, 200, DataGridViewContentAlignment.MiddleRight);
            dgvComDetail.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            dgvComDetail.ColumnHeadersDefaultCellStyle.Font      = new Font("맑은 고딕", 9.75F, FontStyle.Bold);
            DataGridViewUtil.DataGridViewRowNumSet(dgvComDetail);
        }
예제 #4
0
        /// <summary>
        /// 그리드뷰 컬럼 설정
        /// </summary>
        private void DataGridViewColumnSet()
        {
            //데이터그리드뷰 초기설정
            DataGridViewUtil.InitSettingGridView(dgvShift);
            DataGridViewUtil.DataGridViewCheckBoxSet(dgvShift, "  ");
            DataGridViewUtil.AddNewColumnToDataGridView(dgvShift, "shiftCode", "SHIFT_CODE", false, 50);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvShift, "설비명", "FCLTS_NAME", true, 300, DataGridViewContentAlignment.MiddleCenter);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvShift, "설비코드", "FCLTS_CODE", true, 300, DataGridViewContentAlignment.MiddleCenter);
            dgvShift.Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
            DataGridViewUtil.AddNewColumnToDataGridView(dgvShift, "SHIFT", "SHIFT_TYP", true, 100, DataGridViewContentAlignment.MiddleCenter);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvShift, "시작시간", "SHIFT_STARTTIME", true, 150, DataGridViewContentAlignment.MiddleCenter);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvShift, "완료시간", "SHIFT_ENDTIME", true, 150, DataGridViewContentAlignment.MiddleCenter);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvShift, "적용시간일자", "SHIFT_APPLY_STARTTIME", true, 150, DataGridViewContentAlignment.MiddleCenter);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvShift, "적용완료일자", "SHIFT_APPLY_ENDTIME", true, 150, DataGridViewContentAlignment.MiddleCenter);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvShift, "투입인원", "SHIFT_PERSON_DIR", true, 100, DataGridViewContentAlignment.MiddleCenter);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvShift, "사용유무", "SHIFT_USE_YN", true, 100, DataGridViewContentAlignment.MiddleCenter);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvShift, "비고", "SHIFT_REMARK", true, 250, DataGridViewContentAlignment.MiddleCenter);
            dgvShift.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            dgvShift.ColumnHeadersDefaultCellStyle.Font      = new Font("맑은 고딕", 9.75F, FontStyle.Bold);

            //행번호 추가
            DataGridViewUtil.DataGridViewRowNumSet(dgvShift);

            //체크박스추가
            DataGridViewCheckBoxAllCheck();
        }
예제 #5
0
 /// <summary>
 /// 데이터 그리드뷰 컬럼+체크박스 만들기
 /// </summary>
 private void DataGridViewColumnSet()
 {
     try
     {
         DataGridViewUtil.InitSettingGridView(dgvBOM);
         DataGridViewUtil.AddNewColumnToDataGridView(dgvBOM, "no", "idx", true, 30);
         DataGridViewUtil.DataGridViewCheckBoxSet(dgvBOM, "all");
         DataGridViewUtil.AddNewColumnToDataGridView(dgvBOM, "BOM_CODE", "BOM_CODE", false, 30);
         DataGridViewUtil.AddNewColumnToDataGridView(dgvBOM, "품목", "ITEM_CODE", true, 200);
         DataGridViewUtil.AddNewColumnToDataGridView(dgvBOM, "품명", "ITEM_NAME", true, 200);
         DataGridViewUtil.AddNewColumnToDataGridView(dgvBOM, "품목유형", "ITEM_TYP", true, 100);
         DataGridViewUtil.AddNewColumnToDataGridView(dgvBOM, "단위", "ITEM_UNIT", true, 100);
         DataGridViewUtil.AddNewColumnToDataGridView(dgvBOM, "소요량", "BOM_QTY", true, 80);
         DataGridViewUtil.AddNewColumnToDataGridView(dgvBOM, "BOM레벨", "Lvl", true, 100);
         DataGridViewUtil.AddNewColumnToDataGridView(dgvBOM, "시작일", "BOM_STARTDATE", true, 120);
         DataGridViewUtil.AddNewColumnToDataGridView(dgvBOM, "종료일", "BOM_ENDDATE", true, 120);
         DataGridViewUtil.AddNewColumnToDataGridView(dgvBOM, "사용여부", "BOM_USE_YN", true, 120);
         DataGridViewUtil.AddNewColumnToDataGridView(dgvBOM, "소요계획", "BOM_PLAN_YN", true, 120);
         DataGridViewUtil.AddNewColumnToDataGridView(dgvBOM, "자동차감", "BOM_AUTOREDUCE_YN", true, 100);
         DataGridViewUtil.AddNewColumnToDataGridView(dgvBOM, "설비", "FCLTS_CODE", true, 140);
         DataGridViewUtil.AddNewColumnToDataGridView(dgvBOM, "설비명", "FCLTS_NAME", true, 140);
         DataGridViewUtil.AddNewColumnToDataGridView(dgvBOM, "규격", "ITEM_STND", true, 140);
         DataGridViewCheckBoxAllCheck();
     }
     catch (Exception err)
     {
         this.Log.WriteError($"[[RECV {this.Name}]]:{err.Message}");
     }
 }
        private void DataGridViewColumnSet()
        {
            //데이터그리드뷰 초기설정
            DataGridViewUtil.InitSettingGridView(dgvFactoryList);
            //데이터그리드뷰 체크박스 컬럼 추가
            DataGridViewUtil.DataGridViewCheckBoxSet(dgvFactoryList, "");
            DataGridViewColumn dc = dgvFactoryList.Columns[0];

            dc.Frozen = true;
            //일반컬럼 추가
            DataGridViewUtil.AddNewColumnToDataGridView(dgvFactoryList, "시설군", "FAC_FCLTY", true, 90);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvFactoryList, "시설구분", "FAC_TYP", true, 150);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvFactoryList, "시설코드", "FAC_CODE", true, 150);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvFactoryList, "시설명", "FAC_NAME", true, 150);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvFactoryList, "상위시설", "FAC_FCLTY_PARENT", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvFactoryList, "시설설명", "FAC_DESC", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvFactoryList, "유무상구분", "FAC_FREE_YN", true, 110);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvFactoryList, "시설구분순서", "FAC_TYP_SORT", true, 120);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvFactoryList, "수요차감", "FAC_DEMAND_YN", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvFactoryList, "공정차감", "FAC_PROCS_YN", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvFactoryList, "자재차감여부", "FAC_MTRL_YN", true, 120);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvFactoryList, "업체코드", "COM_NAME", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvFactoryList, "사용유무", "FAC_USE_YN", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvFactoryList, "최종수정자", "FAC_LAST_MDFR", true, 110);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvFactoryList, "최종수정시간", "FAC_LAST_MDFY", true, 200);
            dgvFactoryList.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            dgvFactoryList.ColumnHeadersDefaultCellStyle.Font      = new Font("맑은 고딕", 9.75F, FontStyle.Bold);
            DataGridViewUtil.DataGridViewRowNumSet(dgvFactoryList);
            DataGridViewCheckBoxAllCheck();
        }
예제 #7
0
        private void DataGridViewColumnSet()
        {
            //데이터그리드뷰 초기설정
            DataGridViewUtil.InitSettingGridView(dgvBORList);
            //데이터그리드뷰 체크박스 컬럼 추가
            DataGridViewUtil.DataGridViewCheckBoxSet(dgvBORList, "");
            DataGridViewColumn dc = dgvBORList.Columns[0];

            dc.Frozen = true;
            //일반컬럼 추가
            DataGridViewUtil.AddNewColumnToDataGridView(dgvBORList, "PK", "BOR_CODE", false, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvBORList, "품목", "ITEM_CODE", true, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvBORList, "품명", "ITEM_NAME", true, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvBORList, "공정", "BOR_PROCS_CODE", true, 80);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvBORList, "공정명", "COMMON_NAME", true, 80);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvBORList, "설비", "FCLTS_CODE", true, 150);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvBORList, "설비명", "FCLTS_NAME", true, 150);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvBORList, "Tack Time", "BOR_PROCS_TIME", true, 100, DataGridViewContentAlignment.MiddleRight);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvBORList, "우선순위", "BOR_PRIORT", true, 100, DataGridViewContentAlignment.MiddleRight);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvBORList, "공정선행일", "BOR_PROCS_LEADTIME", true, 200, DataGridViewContentAlignment.MiddleRight);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvBORList, "수율", "BOR_YIELD", true, 80, DataGridViewContentAlignment.MiddleRight);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvBORList, "사용유무", "BOR_USE_YN", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvBORList, "비고", "BOR_REMARK", true, 80);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvBORList, "수정자", "BOR_LAST_MDFR", true, 80);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvBORList, "최종수정날짜", "BOR_LAST_MDFY", true, 200);
            dgvBORList.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            dgvBORList.ColumnHeadersDefaultCellStyle.Font      = new Font("맑은 고딕", 9.75F, FontStyle.Bold);
            DataGridViewUtil.DataGridViewRowNumSet(dgvBORList);
            DataGridViewCheckBoxAllCheck();
        }
예제 #8
0
        /// <summary>
        /// 그리드뷰 컬럼 설정
        /// </summary>
        private void DataGridViewColumnSet()
        {
            //데이터그리드뷰 초기설정
            DataGridViewUtil.InitSettingGridView(dgvWork);
            DataGridViewUtil.DataGridViewCheckBoxSet(dgvWork, "  ");
            DataGridViewColumn dc = dgvWork.Columns[0];

            dc.Frozen = true;
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWork, "품목", "ITEM_CODE", true, 200, DataGridViewContentAlignment.MiddleLeft);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWork, "품명", "ITEM_NAME", true, 200, DataGridViewContentAlignment.MiddleLeft);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWork, "규격", "ITEM_STND", true, 100, DataGridViewContentAlignment.MiddleLeft);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWork, "상태", "WO_WORK_STATE", true, 150, DataGridViewContentAlignment.MiddleCenter);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWork, "설비코드", "FCLTS_CODE", true, 150, DataGridViewContentAlignment.MiddleCenter);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWork, "설비명", "FCLTS_NAME", true, 150, DataGridViewContentAlignment.MiddleCenter);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWork, "계획수량", "WO_PLAN_QTY", true, 100, DataGridViewContentAlignment.MiddleRight);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWork, "지시수량", "WO_QTY_PROD", true, 100, DataGridViewContentAlignment.MiddleRight);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWork, "계획시작일", "WO_PLAN_STARTTIME", true, 100, DataGridViewContentAlignment.MiddleCenter);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWork, "소요시간(Min.)", "Tacminute", true, 150, DataGridViewContentAlignment.MiddleRight);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWork, "계획완료일", "WO_PLAN_ENDTIME", true, 150, DataGridViewContentAlignment.MiddleCenter);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWork, "작업지시번호", "WO_Code", true, 150, DataGridViewContentAlignment.MiddleCenter);
            dgvWork.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            dgvWork.ColumnHeadersDefaultCellStyle.Font      = new Font("맑은 고딕", 9.75F, FontStyle.Bold);



            //행번호 추가
            DataGridViewUtil.DataGridViewRowNumSet(dgvWork);

            //체크박스추가
            DataGridViewCheckBoxAllCheck();
        }
예제 #9
0
        //그리드뷰 컬럼 생성
        private void DataGridViewColumnSet()
        {
            //데이터그리드뷰 초기설정
            DataGridViewUtil.InitSettingGridView(dgvGroups);
            //데이터그리드뷰 컬럼 추가
            DataGridViewUtil.AddNewColumnToDataGridView(dgvGroups, "그룹코드", "RIGHT_ID", false, 80);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvGroups, "그룹", "RIGHT_GROUP", true, 150);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvGroups, "그룹명", "RIGHT_NAME", true, 150);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvGroups, "그룹설명", "RIGHT_DESC", true, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvGroups, "사용여부", "RIGHT_FIRST_MDFR", true, 120);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvGroups, "1", "RIGHT_USE", false, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvGroups, "1", "RIGHT_FIRST_MDFY", false, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvGroups, "1", "RIGHT_LAST_MDFR", false, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvGroups, "1", "RIGHT_LAST_MDFY", false, 100);
            dgvGroups.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            dgvGroups.ColumnHeadersDefaultCellStyle.Font      = new Font("맑은 고딕", 9.75F, FontStyle.Bold);
            //데이터그리드뷰 초기설정
            DataGridViewUtil.InitSettingGridView(dgvMenus);
            ////데이터그리드뷰 체크박스, 컬럼 추가
            DataGridViewUtil.DataGridViewCheckBoxSet(dgvMenus, "    ");
            DataGridViewUtil.AddNewColumnToDataGridView(dgvMenus, "메뉴id", "MENU_ID", false, 80);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvMenus, "메뉴명", "MENU_NAME", true, 200, DataGridViewContentAlignment.MiddleCenter);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvMenus, "1", "A", false, 80);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvMenus, "1", "B", false, 80);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvMenus, "1", "C", false, 80);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvMenus, "1", "D", false, 80);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvMenus, "1", "E", false, 80);
            DataGridViewColumn col = this.dgvMenus.Columns[1];

            col.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
            dgvMenus.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            dgvMenus.ColumnHeadersDefaultCellStyle.Font      = new Font("맑은 고딕", 9.75F, FontStyle.Bold);
            DataGridViewCheckBox();
        }
예제 #10
0
 private void DataGridViewColumnSet2()
 {
     try
     {
         DataGridViewUtil.InitSettingGridView(dgv2);
         DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "no", "idx", true, 30);
         DataGridViewUtil.DataGridViewCheckBoxSet(dgv2, "all");
         DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "품목", "ITEM_CODE", true, 200);
         DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "품명", "ITEM_NAME", true, 200);
         DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "규격", "ITEM_STND", true, 200);
         DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "요청창고", "FAC_NAME", true, 200);
         DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "요청일", "Date", true, 200);
         DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "재고량", "현재고", true, 100);
         DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "표준불출수량", "표준불출수량", true, 150);
         DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "계획요청수량", "WO_PLAN_QTY", true, 150);
         DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "요청수량", "", true, 100, readOnly: false);
         DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "출고수량", "출고", true, 140);
         DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "잔량", "잔량", true, 140);
         DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "입고창고", "FCLTS_WRHS_EXHST", false, 125);
         DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "작업번호", "SALES_WORK_ORDER_ID", false, 125);
         DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "출고창고", "ITEM_WRHS_IN", false, 125);
         DataGridViewCheckBoxAllCheck();
     }
     catch (Exception err)
     {
         this.Log.WriteError($"[[RECV {this.Name}]]:{err.Message}");
     }
 }
예제 #11
0
        /// <summary>
        /// 데이터 그리드뷰 컬럼+체크박스 만들기
        /// </summary>
        private void DataGridViewColumnSet()
        {
            try
            {
                DataGridViewUtil.InitSettingGridView(dgv1);
                DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "no", "idx", true, 30);
                DataGridViewUtil.DataGridViewCheckBoxSet(dgv1, "all");
                DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "창고이름", "FAC_NAME", true, 200);
                DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "창고코드", "INS_WRHS", true, 100);
                DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "품목", "ITEM_CODE", true, 200);
                DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "품명", "ITEM_NAME", true, 200);
                DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "품명유형", "ITEM_TYP", true, 100);
                DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "현재고", "현재고", true, 200);
                DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "규격", "ITEM_STND", true, 200);
                DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "개수", "ITEM_UNIT", true, 100);
                DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "관리등급", "ITEM_MANAGE_LEVEL", true, 100);
                DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "비고", "", true, 380);



                DataGridViewCheckBoxAllCheck();
            }
            catch (Exception err)
            {
                this.Log.WriteError($"[[RECV {this.Name}]]:{err.Message}");
            }
        }
예제 #12
0
 /// <summary>
 /// 데이터 그리드뷰 컬럼+체크박스 만들기
 /// </summary>
 private void DataGridViewColumnSet()
 {
     try
     {
         DataGridViewUtil.InitSettingGridView(dgvitem);
         DataGridViewUtil.AddNewColumnToDataGridView(dgvitem, "no", "idx", true, 30);
         DataGridViewUtil.DataGridViewCheckBoxSet(dgvitem, "all");
         DataGridViewUtil.AddNewColumnToDataGridView(dgvitem, "품목유형", "ITEM_TYP", true, 100);
         DataGridViewUtil.AddNewColumnToDataGridView(dgvitem, "품목", "ITEM_CODE", true, 200);
         DataGridViewUtil.AddNewColumnToDataGridView(dgvitem, "품명", "ITEM_NAME", true, 200);
         DataGridViewUtil.AddNewColumnToDataGridView(dgvitem, "규격", "ITEM_STND", true, 100);
         DataGridViewUtil.AddNewColumnToDataGridView(dgvitem, "단위", "ITEM_UNIT", true, 100);
         DataGridViewUtil.AddNewColumnToDataGridView(dgvitem, "단위수량", "ITEM_QTY_UNIT", true, 80);
         DataGridViewUtil.AddNewColumnToDataGridView(dgvitem, "환산단위", "ITEM_UNIT_CNVR", true, 80);
         DataGridViewUtil.AddNewColumnToDataGridView(dgvitem, "환산수량", "ITEM_QTY_CNVR", true, 80);
         DataGridViewUtil.AddNewColumnToDataGridView(dgvitem, "수입검사여부", "ITEM_INCOME_YN", true, 120);
         DataGridViewUtil.AddNewColumnToDataGridView(dgvitem, "공정검사여부", "ITEM_PROCS_YN", true, 120);
         DataGridViewUtil.AddNewColumnToDataGridView(dgvitem, "출하검사여부", "ITEM_XPORT_YN", true, 120);
         DataGridViewUtil.AddNewColumnToDataGridView(dgvitem, "단종유무", "ITEM_DSCN_YN", true, 100);
         DataGridViewUtil.AddNewColumnToDataGridView(dgvitem, "유무상구분", "ITEM_FREE_YN", true, 100);
         DataGridViewUtil.AddNewColumnToDataGridView(dgvitem, "납품업체", "ITEM_COM_DLVR", true, 140);
         DataGridViewUtil.AddNewColumnToDataGridView(dgvitem, "발주업체", "ITEM_COM_REORDER", true, 140);
         DataGridViewCheckBoxAllCheck();
     }
     catch (Exception err)
     {
         this.Log.WriteError($"[[RECV {this.Name}]]:{err.Message}");
     }
 }
예제 #13
0
        /// <summary>
        /// 데이터 그리드뷰 컬럼+체크박스 만들기
        /// </summary>
        private void DataGridViewColumnSet1()
        {
            try
            {
                DataGridViewUtil.InitSettingGridView(dgv1);
                DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "no", "idx", true, 30);
                DataGridViewUtil.DataGridViewCheckBoxSet(dgv1, "all");
                DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "발주번호", "REORDER_CODE", true, 100);
                DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "발주상세번호", "REORDER_DETAIL_CODE", false, 125);
                DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "발주일", "REORDER_DATE", true, 200);
                DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "입고일", "REORDER_DATE_IN", true, 200);
                DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "검사일", "REORDER_INSPECT_DATE", true, 200);
                DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "납품업체", "COM_CODE", true, 100);
                DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "품목", "ITEM_CODE", true, 200);
                DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "품명", "ITEM_NAME", true, 200);
                DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "규격", "ITEM_STND", true, 100);
                DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "최종결과", "REORDER_INSPECT", true, 125);
                DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "납품수량", "REORDER_DETAIL_QTY", true, 125);
                DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "불량수랑", "REORDER_DETAIL_QTY_BAD", true, 125);
                DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "검사자", "MANAGER_NAME", true, 125);


                DataGridViewCheckBoxAllCheck1();
            }
            catch (Exception err)
            {
                this.Log.WriteError($"[[RECV {this.Name}]]:{err.Message}");
            }
        }
예제 #14
0
        private void DataGridViewColumnSet2()
        {
            try
            {
                DataGridViewUtil.InitSettingGridView(COMPANY);
                DataGridViewUtil.AddNewColumnToDataGridView(COMPANY, "no", "idx", true, 30);
                DataGridViewUtil.DataGridViewCheckBoxSet(COMPANY, "all");
                DataGridViewUtil.AddNewColumnToDataGridView(COMPANY, "발주번호", "REORDER_CODE", true, 125);
                DataGridViewUtil.AddNewColumnToDataGridView(COMPANY, "발주상세번호", "REORDER_DETAIL_CODE", false, 125);
                DataGridViewUtil.AddNewColumnToDataGridView(COMPANY, "발주일", "REORDER_DATE", true, 200);
                DataGridViewUtil.AddNewColumnToDataGridView(COMPANY, "입고일", "REORDER_DATE_IN", true, 200);
                DataGridViewUtil.AddNewColumnToDataGridView(COMPANY, "납품업체", "COM_CODE", true, 125);
                DataGridViewUtil.AddNewColumnToDataGridView(COMPANY, "품목", "ITEM_CODE", true, 200);
                DataGridViewUtil.AddNewColumnToDataGridView(COMPANY, "품명", "ITEM_NAME", true, 200);
                DataGridViewUtil.AddNewColumnToDataGridView(COMPANY, "규격", "ITEM_STND", true, 125);
                DataGridViewUtil.AddNewColumnToDataGridView(COMPANY, "납품수량", "REORDER_DETAIL_QTY", true, 125);
                DataGridViewUtil.AddNewColumnToDataGridView(COMPANY, "불량수량", "", true, 100, readOnly: false);
                DataGridViewUtil.AddNewColumnToDataGridView(COMPANY, "작업번호", "SALES_WORK_ORDER_ID", false, 100);
                DataGridViewUtil.AddNewColumnToDataGridView(COMPANY, "비고", "", true, 400);

                DataGridViewCheckBoxAllCheck2();
            }
            catch (Exception err)
            {
                this.Log.WriteError($"[[RECV {this.Name}]]:{err.Message}");
            }
        }
예제 #15
0
        /// <summary>
        /// 그리드뷰 컬럼 설정
        /// </summary>
        private void DataGridViewColumnSet()
        {
            //데이터그리드뷰 초기설정
            DataGridViewUtil.InitSettingGridView(dgvCost);
            DataGridViewUtil.DataGridViewCheckBoxSet(dgvCost, "");
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCost, "영업코드", "SC_Code", false, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCost, "업체", "COM_Code", true, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCost, "업체명", "COM_NAME", true, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCost, "품목", "ITEM_Code", true, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCost, "품명", "ITEM_NAME", true, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCost, "규격", "ITEM_STND", true, 150);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCost, "단위", "ITEM_UNIT", true, 100);
            dgvCost.Columns[7].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCost, "현재단가", "SC_UNITPRICE_CUR", true, 100);
            dgvCost.Columns[8].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCost, "이전단가", "SC_UNITPRICE_EX", true, 100);
            dgvCost.Columns[9].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCost, "시작일", "SC_STARTDATE", true, 120);
            dgvCost.Columns[10].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCost, "종료일", "SC_ENDDATE", true, 120);
            dgvCost.Columns[11].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCost, "비고", "SC_REMARK", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCost, "사용유무", "SC_USE_YN", true, 100);
            dgvCost.Columns[13].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;

            dgvCost.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            dgvCost.ColumnHeadersDefaultCellStyle.Font      = new Font("맑은 고딕", 9.75F, FontStyle.Bold);

            //행번호 추가
            DataGridViewUtil.DataGridViewRowNumSet(dgvCost);
            //체크박스추가
            DataGridViewCheckBoxAllCheck();
        }
예제 #16
0
        private void DataGridViewColumnSet()
        {
            //데이터그리드뷰 초기설정
            DataGridViewUtil.InitSettingGridView(dgvSalesEndState);
            //데이터그리드뷰 체크박스 컬럼 추가
            DataGridViewUtil.DataGridViewCheckBoxSet(dgvSalesEndState, "");
            DataGridViewColumn dc = dgvSalesEndState.Columns[0];

            dc.Frozen = true;
            //일반컬럼 추가
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesEndState, "고객주문번호", "SALES_WORK_ORDER_ID", true, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesEndState, "고객사", "SALES_COM_CODE", true, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesEndState, "고객사명", "COM_NAME", true, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesEndState, "품목", "ITEM_CODE", true, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesEndState, "품명", "ITEM_NAME", true, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesEndState, "납기일", "SALES_DUEDATE", true, 160);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesEndState, "주문수량", "SALES_QTY", true, 160, DataGridViewContentAlignment.MiddleRight);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesEndState, "판매액", "SALES_TTL", true, 160, DataGridViewContentAlignment.MiddleRight);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesEndState, "마감일", "SALES_ENDDATE", true, 160);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesEndState, "마감취소일", "SALES_CANCELDATE", true, 160);
            dgvSalesEndState.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            dgvSalesEndState.ColumnHeadersDefaultCellStyle.Font      = new Font("맑은 고딕", 9.75F, FontStyle.Bold);
            DataGridViewUtil.DataGridViewRowNumSet(dgvSalesEndState);
            DataGridViewCheckBoxAllCheck();
        }
예제 #17
0
        /// <summary>
        /// 데이터 그리드뷰 컬럼+체크박스 만들기
        /// </summary>
        private void DataGridViewColumnSet1()
        {
            DataGridViewUtil.InitSettingGridView(dgv1);
            DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "no", "idx", true, 30);
            DataGridViewUtil.DataGridViewCheckBoxSet(dgv1, "all");
            DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "발주업체", "COM_NAME", true, 155);
            DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "발주업체코드", "COM_CODE", false, 30);

            DataGridViewCheckBoxAllCheck1();
        }
        private void DataGridViewColumnSet()
        {
            //설비군
            //데이터그리드뷰 초기설정
            DataGridViewUtil.InitSettingGridView(dgvFacilityGroupList);
            //데이터그리드뷰 체크박스 컬럼 추가
            DataGridViewUtil.DataGridViewCheckBoxSet(dgvFacilityGroupList, "");
            DataGridViewColumn dc = dgvFacilityGroupList.Columns[0];

            dc.Frozen = true;
            //일반컬럼 추가
            DataGridViewUtil.AddNewColumnToDataGridView(dgvFacilityGroupList, "설비군코드", "FACG_CODE", true, 110);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvFacilityGroupList, "설비군명", "FACG_NAME", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvFacilityGroupList, "사용유무", "FACG_USE_YN", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvFacilityGroupList, "수정자", "FACG_LAST_MDFR", true, 90);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvFacilityGroupList, "최종수정날짜", "FACG_LAST_MDFY", true, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvFacilityGroupList, "시설설명", "FACG_DESC", true, 100);
            dgvFacilityGroupList.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            dgvFacilityGroupList.ColumnHeadersDefaultCellStyle.Font      = new Font("맑은 고딕", 9.75F, FontStyle.Bold);
            DataGridViewUtil.DataGridViewRowNumSet(dgvFacilityGroupList);
            DataGridViewCheckBoxAllCheck();


            //설비
            //데이터그리드뷰 초기설정
            DataGridViewUtil.InitSettingGridView(dgvFacilityList);
            //데이터그리드뷰 체크박스 컬럼 추가
            DataGridViewUtil.DataGridViewCheckBoxSet(dgvFacilityList, "");
            DataGridViewColumn col = dgvFacilityList.Columns[0];

            col.Frozen = true;
            //일반컬럼 추가
            DataGridViewUtil.AddNewColumnToDataGridView(dgvFacilityList, "설비군코드", "FACG_CODE", true, 110);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvFacilityList, "설비코드", "FCLTS_CODE", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvFacilityList, "설비명", "FCLTS_NAME", true, 90);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvFacilityList, "소진창고", "FCLTS_WRHS_EXHST", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvFacilityList, "양품창고", "FCLTS_WRHS_GOOD", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvFacilityList, "불량창고", "FCLTS_WRHS_BAD", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvFacilityList, "사용유무", "FCLTS_USE_YN", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvFacilityList, "외주여부", "FCLTS_EXTRL_YN", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvFacilityList, "수정자", "FCLTS_LAST_MDFR", true, 90);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvFacilityList, "최종수정일", "FCLTS_LAST_MDFY", true, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvFacilityList, "특이사항", "FCLTS_NOTE", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvFacilityList, "비고", "FCLTS_REMARK", true, 80);
            dgvFacilityList.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            dgvFacilityList.ColumnHeadersDefaultCellStyle.Font      = new Font("맑은 고딕", 9.75F, FontStyle.Bold);
            DataGridViewUtil.DataGridViewRowNumSet(dgvFacilityList);
            DataGridViewCheckBoxAllCheck2();
        }
예제 #19
0
        /// <summary>
        /// 그리드뷰 컬럼 생성 메서드
        /// </summary>
        private void DataGridViewColumnSet()
        {
            //데이터그리드뷰 초기설정

            //관리자 검색
            DataGridViewUtil.InitSettingGridView(dgvUsers);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvUsers, "관리자 ID", "MANAGER_ID", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvUsers, "이름", "MANAGER_NAME", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvUsers, "부서", "MANAGER_DEP", true, 80);
            DataGridViewUtil.DataGridViewBtnSet("  ", "설정", dgvUsers, 0, 0);
            dgvUsers.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            //권한 설정
            DataGridViewUtil.InitSettingGridView(dgvRight);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvRight, "메뉴ID", "MENU_ID", false, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvRight, "메뉴명", "MENU_NAME", true, 150);
            DataGridViewUtil.DataGridViewCheckBoxSet(dgvRight, "A", "등록", 100);
            DataGridViewUtil.DataGridViewCheckBoxSet(dgvRight, "B", "읽기", 100);
            DataGridViewUtil.DataGridViewCheckBoxSet(dgvRight, "C", "수정", 100);
            DataGridViewUtil.DataGridViewCheckBoxSet(dgvRight, "D", "삭제", 100);
            DataGridViewUtil.DataGridViewCheckBoxSet(dgvRight, "E", "인쇄", 100);
            DataGridViewUtil.DataGridViewCheckBoxSet(dgvRight, "F", "리셋", 100);
            DataGridViewColumn col = this.dgvRight.Columns[1];

            col.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
            dgvRight.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            DataGridViewCheckBoxAllCheck();


            //그룹 설정
            DataGridViewUtil.InitSettingGridView(dgvGroup);
            DataGridViewUtil.DataGridViewCheckBoxSet(dgvGroup, "    ");
            DataGridViewUtil.AddNewColumnToDataGridView(dgvGroup, "그룹코드", "RIGHT_ID", false, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvGroup, "그룹", "RIGHT_GROUP", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvGroup, "그룹명", "RIGHT_NAME", true, 150);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvGroup, "상세설명", "RIGHT_DESC", true, 300);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvGroup, "1", "RIGHT_USE", false, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvGroup, "1", "RIGHT_FIRST_MDFR", false, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvGroup, "1", "RIGHT_FIRST_MDFY", false, 150);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvGroup, "1", "RIGHT_LAST_MDFR", false, 300);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvGroup, "1", "RIGHT_LAST_MDFY", false, 300);
            col = this.dgvGroup.Columns[1];
            col.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
            dgvGroup.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;

            DataGridViewCheckBox();
        }
 /// <summary>
 /// 데이터 그리드뷰 컬럼 만들기
 /// </summary>
 private void DataGridViewColumnSet()
 {
     DataGridViewUtil.InitSettingGridView(dgvReorder);
     DataGridViewUtil.AddNewColumnToDataGridView(dgvReorder, "no", "idx", true, 30);
     DataGridViewUtil.DataGridViewCheckBoxSet(dgvReorder, "all");
     DataGridViewUtil.AddNewColumnToDataGridView(dgvReorder, "발주번호", "REORDER_CODE", true, 200);
     DataGridViewUtil.AddNewColumnToDataGridView(dgvReorder, "협렵사", "COM_CODE", true, 100);
     DataGridViewUtil.AddNewColumnToDataGridView(dgvReorder, "납품업체", "REORDER_COM_DLVR", true, 100);
     DataGridViewUtil.AddNewColumnToDataGridView(dgvReorder, "주문상태", "REORDER_STATE", true, 100);
     DataGridViewUtil.AddNewColumnToDataGridView(dgvReorder, "품목", "ITEM_CODE", true, 200);
     DataGridViewUtil.AddNewColumnToDataGridView(dgvReorder, "품명", "ITEM_NAME", true, 200);
     DataGridViewUtil.AddNewColumnToDataGridView(dgvReorder, "규격", "ITEM_STND", true, 80);
     DataGridViewUtil.AddNewColumnToDataGridView(dgvReorder, "단위", "ITEM_UNIT", true, 80);
     DataGridViewUtil.AddNewColumnToDataGridView(dgvReorder, "납기일", "REORDER_DATE_IN", true, 200);
     DataGridViewUtil.AddNewColumnToDataGridView(dgvReorder, "발주량", "REORDER_QTY", true, 100);
     DataGridViewUtil.AddNewColumnToDataGridView(dgvReorder, "입고량", "REORDER_DETAIL_QTY_GOOD", true, 100);
     DataGridViewUtil.AddNewColumnToDataGridView(dgvReorder, "발주일", "REORDER_DATE", true, 200);
     DataGridViewUtil.AddNewColumnToDataGridView(dgvReorder, "발주자", "MANAGER_NAME", true, 100);
     DataGridViewCheckBoxAllCheck();
 }
예제 #21
0
 /// <summary>
 /// 데이터 그리드뷰 컬럼 만들기
 /// </summary>
 private void DataGridViewColumnSet1()
 {
     DataGridViewUtil.InitSettingGridView(dgv1);
     DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "no", "idx", true, 30);
     DataGridViewUtil.DataGridViewCheckBoxSet(dgv1, "all");
     DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "발주일자", "REORDER_DATE", true, 200);
     DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "발주업체", "COM_CODE", true, 100);
     DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "납품업체", "REORDER_COM_DLVR", true, 100);
     DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "품목", "ITEM_CODE", true, 250);
     DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "품명", "ITEM_NAME", true, 250);
     DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "규격", "ITEM_STND", true, 100);
     DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "단위", "ITEM_UNIT", true, 100);
     DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "검사여부", "ITEM_INCOME_YN", true, 100);
     DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "발주량", "REORDER_QTY", true, 100);
     DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "입고량", "REORDER_QTY1", true, 100);
     DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "잔량", "REORDER_QTY2", true, 100);
     DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "납기일자", "REORDER_DATE_IN", true, 200);
     DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "발주유형", "REORDER_TYP", true, 100);
     DataGridViewCheckBoxAllCheck1();
 }
 private void DataGridViewColumnSet()
 {
     //데이터그리드뷰 초기설정
     DataGridViewUtil.InitSettingGridView(dgvCustomerOrder);
     //데이터그리드뷰 체크박스 컬럼 추가
     DataGridViewUtil.DataGridViewCheckBoxSet(dgvCustomerOrder, "");
     //일반컬럼 추가
     DataGridViewUtil.AddNewColumnToDataGridView(dgvCustomerOrder, "품목", "ITEM_CODE", true, 190);
     DataGridViewUtil.AddNewColumnToDataGridView(dgvCustomerOrder, "품명", "ITEM_NAME", true, 190);
     DataGridViewUtil.AddNewColumnToDataGridView(dgvCustomerOrder, "규격", "ITEM_STND", true, 200);
     DataGridViewUtil.AddNewColumnToDataGridView(dgvCustomerOrder, "창고", "FAC_CODE", false, 200);
     DataGridViewUtil.AddNewColumnToDataGridView(dgvCustomerOrder, "창고", "FAC_NAME", true, 200);
     DataGridViewUtil.AddNewColumnToDataGridView(dgvCustomerOrder, "이동량", "WO_QTY_OUT", true, 150, DataGridViewContentAlignment.MiddleRight);
     DataGridViewUtil.AddNewColumnToDataGridView(dgvCustomerOrder, "비고", "WO_REMARK", true, 400);
     DataGridViewUtil.AddNewColumnToDataGridView(dgvCustomerOrder, "작업지시ID", "SALES_WORK_ORDER_ID", true, 150);
     DataGridViewUtil.AddNewColumnToDataGridView(dgvCustomerOrder, "제품타입", "ITEM_TYP", true, 120);
     DataGridViewUtil.AddNewColumnToDataGridView(dgvCustomerOrder, "이동창고", "ToWHouse", true, 200);
     dgvCustomerOrder.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
     dgvCustomerOrder.ColumnHeadersDefaultCellStyle.Font      = new Font("맑은 고딕", 9.75F, FontStyle.Bold);
     DataGridViewUtil.DataGridViewRowNumSet(dgvCustomerOrder);
     DataGridViewCheckBoxAllCheck();
 }
예제 #23
0
 private void DataGridViewColumnSet2()
 {
     DataGridViewUtil.InitSettingGridView(dgv2);
     DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "no", "idx", true, 30);
     DataGridViewUtil.DataGridViewCheckBoxSet(dgv2, "all");
     DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "발주코드", "REORDER_CODE", true, 100);
     DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "품목", "ITEM_CODE", true, 200);
     DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "품명", "ITEM_NAME", true, 200);
     DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "규격", "ITEM_STND", true, 100);
     DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "단위", "ITEM_UNIT", true, 100);
     DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "발수수량", "REORDER_QTY", true, 80);
     DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "잔여수량", "REORDER_QTY1", true, 80);
     DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "입고수량", "", true, 80, readOnly: false);
     DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "발주상태", "REORDER_STATE", true, 200);
     DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "납품일자", "REORDER_DATE_IN", true, 200);
     DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "발주일자", "REORDER_DATE", true, 200);
     DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "검사유무", "ITEM_INCOME_YN", true, 100);
     DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "입고창고", "ITEM_WRHS_IN", false, 100);
     DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "작업번호", "SALES_WORK_ORDER_ID", false, 100);
     DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "비고", "", true, 150);
     DataGridViewCheckBoxAllCheck2();
 }
예제 #24
0
        private void DataGridViewColumnSet2()
        {
            DataGridViewUtil.InitSettingGridView(dgv2);
            DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "no", "idx", true, 30);
            DataGridViewUtil.DataGridViewCheckBoxSet(dgv2, "all");
            DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "발주업체", "ITEM_COM_REORDER", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "납품업체", "ITEM_COM_DLVR", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "담당자", "ITEM_MANAGER", true, 80);
            DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "품목", "ITEM_CODE", true, 150);
            DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "품명", "ITEM_NAME", true, 150);
            DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "창고", "FAC_NAME", true, 80);
            DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "창고", "FAC_CODE", false, 80);
            DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "검사여부", "ITEM_INCOME_YN", true, 80);
            DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "발주방식", "ITEM_REORDER_TYP", false, 80);
            DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "발주제안", "발주제한", true, 80);
            DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "현재고", "현재고", true, 70);
            DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "가상재고", "가상재고", true, 80);
            DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "작업지시번호", "SALES_Work_Order_ID", true, 150);
            DataGridViewUtil.AddNewColumnToDataGridView(dgv2, "ITEM_LEADTIME", "ITEM_LEADTIME", false, 180);

            DataGridViewCheckBoxAllCheck2();
        }
예제 #25
0
 private void DataGridViewColumnSet()
 {
     //데이터그리드뷰 초기설정
     DataGridViewUtil.InitSettingGridView(dgvSalesEnd);
     //데이터그리드뷰 체크박스 컬럼 추가
     DataGridViewUtil.DataGridViewCheckBoxSet(dgvSalesEnd, "");
     //일반컬럼 추가
     DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesEnd, "고객주문번호", "SALES_WORK_ORDER_ID", true, 200);
     DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesEnd, "고객사", "COM_NAME", true, 200);
     DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesEnd, "도착지명", "SALES_COM_CODE", true, 200);
     DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesEnd, "품목", "ITEM_CODE", true, 200);
     DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesEnd, "품명", "ITEM_NAME", true, 210);
     DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesEnd, "납기일", "SALES_DUEDATE", true, 150);
     DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesEnd, "주문수량", "WO_PLAN_QTY", true, 150, DataGridViewContentAlignment.MiddleRight);
     DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesEnd, "출하수량", "OUTed_QTY", true, 150, DataGridViewContentAlignment.MiddleRight);
     DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesEnd, "마감수량", "WO_PLAN_QTY", true, 150, DataGridViewContentAlignment.MiddleRight);
     DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesEnd, "매출확정금액", "EndPrice", true, 200, DataGridViewContentAlignment.MiddleRight);
     dgvSalesEnd.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
     dgvSalesEnd.ColumnHeadersDefaultCellStyle.Font      = new Font("맑은 고딕", 9.75F, FontStyle.Bold);
     DataGridViewUtil.DataGridViewRowNumSet(dgvSalesEnd);
     DataGridViewCheckBoxAllCheck();
 }
예제 #26
0
        /// <summary>
        /// 그리드뷰 컬럼 설정
        /// </summary>
        private void DataGridViewColumnSet()
        {
            //데이터그리드뷰 초기설정
            DataGridViewUtil.InitSettingGridView(dgvSales);
            DataGridViewUtil.DataGridViewCheckBoxSet(dgvSales, "  ");
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSales, "code", "SALES_ID", false, 50);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSales, "고객 WO", "SALES_Work_Order_ID", true, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSales, "고객주문번호", "SO_PurchaseOrder", true, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSales, "고객사코드", "COM_CODE", true, 120);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSales, "고객사명", "COM_NAME", true, 120);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSales, "도착지코드", "SALES_COM_CODE", true, 120);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSales, "도착지명", "SALES_COM_NAME", true, 150);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSales, "고객주문유형", "SALES_Order_TYPE", true, 120);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSales, "품목", "ITEM_CODE", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSales, "품명", "ITEM_NAME", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSales, "생산납기일", "SALES_DUEDATE", true, 150);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSales, "주문수량", "SALES_QTY", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSales, "출고수량", "SALES_Out_QTY", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSales, "취소수량", "SALES_NO_QTY", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSales, "주문상태", "SALES_ORDER_STATE", true, 100);

            //행번호 추가
            DataGridViewUtil.DataGridViewRowNumSet(dgvSales);
        }
        private void DataGridViewColumnSet()
        {
            //설비군
            //데이터그리드뷰 초기설정
            DataGridViewUtil.InitSettingGridView(dgvCom);
            //데이터그리드뷰 체크박스 컬럼 추가
            DataGridViewUtil.DataGridViewCheckBoxSet(dgvCom, "");
            //일반컬럼 추가
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCom, "업체코드", "COM_CODE", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCom, "업체명", "ITEM_COM_DLVR", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCom, "사업자번호", "COM_REG_NUM", true, 120);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvCom, "금액", "TTLPRICE", true, 110, DataGridViewContentAlignment.MiddleRight);
            dgvCom.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            dgvCom.ColumnHeadersDefaultCellStyle.Font      = new Font("맑은 고딕", 9.75F, FontStyle.Bold);
            DataGridViewUtil.DataGridViewRowNumSet(dgvCom);
            DataGridViewCheckBoxAllCheck();


            //설비
            //데이터그리드뷰 초기설정
            DataGridViewUtil.InitSettingGridView(dgvComDetail);
            //데이터그리드뷰 체크박스 컬럼 추가
            //일반컬럼 추가
            DataGridViewUtil.AddNewColumnToDataGridView(dgvComDetail, "업체명", "ITEM_COM_DLVR", true, 150);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvComDetail, "납품업체명", "ITEM_COM_REORDER", true, 150);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvComDetail, "입고일", "INS_DATE", true, 150);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvComDetail, "카테고리", "INS_TYP", true, 120);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvComDetail, "창고", "FAC_NAME", true, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvComDetail, "품목", "ITEM_CODE", true, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvComDetail, "수불량", "INS_QTY", true, 120, DataGridViewContentAlignment.MiddleRight);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvComDetail, "단가", "MC_UNITPRICE_CUR", true, 120, DataGridViewContentAlignment.MiddleRight);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvComDetail, "금액", "TTLPRICE", true, 120, DataGridViewContentAlignment.MiddleRight);
            dgvComDetail.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            dgvComDetail.ColumnHeadersDefaultCellStyle.Font      = new Font("맑은 고딕", 9.75F, FontStyle.Bold);
            DataGridViewUtil.DataGridViewRowNumSet(dgvComDetail);
        }
        private void DataGridViewColumnSet()
        {
            //데이터그리드뷰 초기설정
            DataGridViewUtil.InitSettingGridView(dgvList);
            //데이터그리드뷰 체크박스 컬럼 추가
            DataGridViewUtil.DataGridViewCheckBoxSet(dgvList, "");
            DataGridViewColumn dc = dgvList.Columns[0];

            dc.Frozen = true;
            //일반컬럼 추가
            DataGridViewUtil.AddNewColumnToDataGridView(dgvList, "창고코드", "INS_WRHS", true, 120);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvList, "창고", "FAC_NAME", true, 150);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvList, "품목", "ITEM_CODE", true, 300);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvList, "품명", "ITEM_NAME", true, 300);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvList, "품목타입", "ITEM_TYP", true, 150);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvList, "규격", "ITEM_STND", true, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvList, "재고량", "INS_QTY", true, 120, DataGridViewContentAlignment.MiddleRight);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvList, "단위", "ITEM_UNIT", true, 100);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvList, "비고", "", true, 370);
            dgvList.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            dgvList.ColumnHeadersDefaultCellStyle.Font      = new Font("맑은 고딕", 9.75F, FontStyle.Bold);
            DataGridViewUtil.DataGridViewRowNumSet(dgvList);
            DataGridViewCheckBoxAllCheck();
        }
예제 #29
0
        private void DataGridViewColumnSet()
        {
            //데이터그리드뷰 초기설정
            DataGridViewUtil.InitSettingGridView(dgvWorkRecordList);
            //데이터그리드뷰 체크박스 컬럼 추가
            DataGridViewUtil.DataGridViewCheckBoxSet(dgvWorkRecordList, "");
            DataGridViewColumn col = dgvWorkRecordList.Columns[0];

            col.Frozen = true;
            //일반컬럼 추가
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWorkRecordList, "지시일", "WO_PLAN_DATE", true, 100);                                                      //1
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWorkRecordList, "생산일", "WO_PROD_DATE", true, 100);                                                      //2
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWorkRecordList, "설비ID", "FCLTS_CODE", true, 100);                                                       //3
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWorkRecordList, "설비명", "FCLTS_NAME", true, 100);                                                        //4
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWorkRecordList, "작업순서", "WO_WORK_SEQ", true, 100, DataGridViewContentAlignment.MiddleRight);            //5
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWorkRecordList, "품목", "ITEM_CODE", true, 100);                                                          //6
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWorkRecordList, "품명", "ITEM_NAME", true, 100);                                                          //7
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWorkRecordList, "작업상태", "WO_WORK_STATE", true, 100);                                                    //8
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWorkRecordList, "양품창고", "FCLTS_WRHS_GOOD", true, 100);                                                  //9
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWorkRecordList, "불량창고", "FCLTS_WRHS_BAD", true, 100);                                                   //10
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWorkRecordList, "지시량", "WO_PLAN_QTY", true, 90, DataGridViewContentAlignment.MiddleRight);              //11
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWorkRecordList, "취소수량", "SALES_NO_QTY", true, 100, DataGridViewContentAlignment.MiddleRight);           //12
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWorkRecordList, "양품수량", "WO_QTY_OUT", true, 100, DataGridViewContentAlignment.MiddleRight);             //13
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWorkRecordList, "투입수량", "WO_QTY_IN", true, 100, DataGridViewContentAlignment.MiddleRight);              //14
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWorkRecordList, "불량수량", "WO_QTY_BAD", true, 100, DataGridViewContentAlignment.MiddleRight);             //15
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWorkRecordList, "잔량", "WO_QTY", true, 80, DataGridViewContentAlignment.MiddleRight);                    //16
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWorkRecordList, "생산량", "WO_QTY_PROD", true, 90, DataGridViewContentAlignment.MiddleRight);              //17
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWorkRecordList, "계획시작일", "WO_PLAN_STARTTIME", true, 110);                                               //18
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWorkRecordList, "계획종료일", "WO_PLAN_ENDTIME", true, 110);                                                 //19
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWorkRecordList, "비고", "WO_REMARK", true, 80);                                                           //20
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWorkRecordList, "수정자", "WO_LAST_MDFR", true, 100);                                                      //21
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWorkRecordList, "수정일", "WO_LAST_MDFY", true, 200);                                                      //22
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWorkRecordList, "작업지시번호", "WO_Code", true, 120);                                                        //23
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWorkRecordList, "작업지시서번호", "SALES_WORK_ORDER_ID", true, 130, DataGridViewContentAlignment.MiddleRight); //24
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWorkRecordList, "계획ID", "PLAN_ID", true, 90);                                                           //25
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWorkRecordList, "TYPE", "ITEM_TYP", true, 90);                                                          //25
            dgvWorkRecordList.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            dgvWorkRecordList.ColumnHeadersDefaultCellStyle.Font      = new Font("맑은 고딕", 9.75F, FontStyle.Bold);
            DataGridViewUtil.DataGridViewRowNumSet(dgvWorkRecordList);
            DataGridViewCheckBoxAllCheck();


            //데이터그리드뷰 초기설정
            DataGridViewUtil.InitSettingGridView(dgvMOVEList);
            //데이터그리드뷰 체크박스 컬럼 추가
            DataGridViewUtil.DataGridViewCheckBoxSet(dgvMOVEList, "");
            DataGridViewColumn dc = dgvWorkRecordList.Columns[0];

            dc.Frozen = true;
            //일반컬럼 추가
            DataGridViewUtil.AddNewColumnToDataGridView(dgvMOVEList, "품목", "ITEM_CODE", true, 150);                                              //1
            DataGridViewUtil.AddNewColumnToDataGridView(dgvMOVEList, "품명", "ITEM_NAME", true, 300);                                              //2
            DataGridViewUtil.AddNewColumnToDataGridView(dgvMOVEList, "규격", "ITEM_STND", true, 200);                                              //3
            DataGridViewUtil.AddNewColumnToDataGridView(dgvMOVEList, "창고코드", "FCLTS_CODE", true, 180);                                           //4
            DataGridViewUtil.AddNewColumnToDataGridView(dgvMOVEList, "이동창고", "FCLTS_NAME", true, 180);                                           //5
            DataGridViewUtil.AddNewColumnToDataGridView(dgvMOVEList, "이동수량", "WO_QTY_OUT", true, 100, DataGridViewContentAlignment.MiddleRight); //6 양품수량
            DataGridViewUtil.AddNewColumnToDataGridView(dgvMOVEList, "비고", "WO_REMARK", true, 400);                                              //7
            DataGridViewUtil.AddNewColumnToDataGridView(dgvMOVEList, "작업지시서번호", "SALES_WORK_ORDER_ID", true, 200);                               //8
            DataGridViewUtil.AddNewColumnToDataGridView(dgvMOVEList, "TYPE", "ITEM_TYP", true, 100);                                             //9
            dgvMOVEList.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            dgvMOVEList.ColumnHeadersDefaultCellStyle.Font      = new Font("맑은 고딕", 9.75F, FontStyle.Bold);
            DataGridViewUtil.DataGridViewRowNumSet(dgvMOVEList);
            DataGridViewCheckBoxAllCheck2();
        }