예제 #1
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();
        }
예제 #2
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();
        }
예제 #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
        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();
        }
        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();
        }
예제 #6
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();
        }
        /// <summary>
        /// 그리드뷰 컬럼 설정
        /// </summary>
        private void DataGridViewColumnSet()
        {
            //데이터그리드뷰 초기설정
            DataGridViewUtil.InitSettingGridView(dgvWork);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWork, "투입시간", "WO_PLAN_STARTTIME", true, 150, DataGridViewContentAlignment.MiddleCenter);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWork, "지시일", "WO_PLAN_DATE", true, 150, DataGridViewContentAlignment.MiddleCenter);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWork, "설비코드", "FCLTS_CODE", true, 120, DataGridViewContentAlignment.MiddleLeft);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWork, "설비명", "FCLTS_Name", true, 150, DataGridViewContentAlignment.MiddleLeft);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWork, "우선순위", "WO_WORK_SEQ", true, 100, DataGridViewContentAlignment.MiddleCenter);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWork, "상태", "WO_WORK_STATE", true, 120, DataGridViewContentAlignment.MiddleCenter);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWork, "품목", "ITEM_CODE", true, 120, DataGridViewContentAlignment.MiddleLeft);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWork, "품명", "ITEM_NAME", true, 150, DataGridViewContentAlignment.MiddleLeft);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWork, "소진창고", "FCLTS_WRHS_EXHST", true, 120, DataGridViewContentAlignment.MiddleLeft);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWork, "양품창고", "FCLTS_WRHS_GOOD", true, 120, DataGridViewContentAlignment.MiddleLeft);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWork, "불량창고", "FCLTS_WRHS_BAD", true, 120, DataGridViewContentAlignment.MiddleLeft);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWork, "지시량", "WO_PLAN_QTY", true, 100, DataGridViewContentAlignment.MiddleRight);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWork, "양품량", "WO_QTY_GOOD", true, 100, DataGridViewContentAlignment.MiddleRight);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWork, "불량", "WO_QTY_BAD", true, 100, DataGridViewContentAlignment.MiddleRight);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvWork, "작업지시번호", "WO_Code", false, 150, DataGridViewContentAlignment.MiddleCenter);
            dgvWork.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            dgvWork.ColumnHeadersDefaultCellStyle.Font      = new Font("맑은 고딕", 9.75F, FontStyle.Bold);

            //행번호 추가
            DataGridViewUtil.DataGridViewRowNumSet(dgvWork);
        }
예제 #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(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();
        }
예제 #10
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();
        }
        private void DataGridViewColumnSet()
        {
            //데이터그리드뷰 초기설정
            dgvPlan.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing;
            dgvPlan.AutoGenerateColumns         = true;
            dgvPlan.AllowUserToAddRows          = false;
            dgvPlan.MultiSelect   = false;
            dgvPlan.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
            dgvPlan.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            dgvPlan.ColumnHeadersDefaultCellStyle.Font      = new Font("맑은 고딕", 9.75F, FontStyle.Bold);
            dgvPlan.RowsDefaultCellStyle.Alignment          = DataGridViewContentAlignment.MiddleCenter;

            if (dgvPlan.Rows.Count > 0)
            {
                DataGridViewColumn column = dgvPlan.Columns[0];
                dgvPlan.Columns[0].Frozen = true;
                column.Width      = 200;
                column.Visible    = false;
                column.HeaderText = "설비코드";

                column = dgvPlan.Columns[1];
                dgvPlan.Columns[1].Frozen = true;
                column.Width      = 200;
                column.HeaderText = "설비";

                column = dgvPlan.Columns[2];
                dgvPlan.Columns[2].Frozen = true;
                column.Width      = 150;
                column.HeaderText = "공정";

                column = dgvPlan.Columns[3];
                dgvPlan.Columns[3].Frozen = true;
                column.Width      = 150;
                column.HeaderText = "품목";

                column = dgvPlan.Columns[4];
                dgvPlan.Columns[4].Frozen = true;
                column.Width      = 150;
                column.HeaderText = "품명";

                column = dgvPlan.Columns[5];
                dgvPlan.Columns[5].Frozen = true;
                column.Width      = 150;
                column.HeaderText = "규격";

                foreach (DataGridViewColumn item in dgvPlan.Columns)
                {
                    item.ReadOnly = true;
                }

                //행번호 추가
                DataGridViewUtil.DataGridViewRowNumSet(dgvPlan);
            }
        }
        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();
        }
예제 #13
0
        /// <summary>
        /// 그리드뷰 컬럼 생성 메소드
        /// </summary>
        private void DataGridViewColumnSet()
        {
            //데이터그리드뷰 초기설정
            DataGridViewUtil.InitSettingGridView(dgvGroup);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvGroup, "관리자 ID", "MANAGER_ID", true, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvGroup, "이름", "MANAGER_NAME", true, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvGroup, "부서", "MANAGER_DEP", true, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvGroup, "권한명", "RIGHT_NAME", true, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvGroup, "권한그룹", "RIGHT_GROUP", true, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvGroup, "권한그룹설명", "RIGHT_DESC", true, 500);
            dgvGroup.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            dgvGroup.ColumnHeadersDefaultCellStyle.Font      = new Font("맑은 고딕", 9.75F, FontStyle.Bold);

            //행번호 추가
            DataGridViewUtil.DataGridViewRowNumSet(dgvGroup);
        }
예제 #14
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();
 }
 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();
 }
        /// <summary>
        /// 그리드뷰 컬럼 설정
        /// </summary>
        private void DataGridViewColumnSet()
        {
            //데이터그리드뷰 초기설정
            DataGridViewUtil.InitSettingGridView(dgvSalesMaster);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesMaster, "SALES_ID", "SALES_ID", false, 160);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesMaster, "SALES Work Order ID", "SALES_Work_Order_ID", true, 250);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesMaster, "업체CODE", "COM_CODE", true, 150);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesMaster, "발주구분", "SALES_Order_TYPE", true, 150);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesMaster, "납품처", "SALES_COM_CODE", true, 150);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesMaster, "품목", "ITEM_CODE", true, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesMaster, "계획수량합계", "SALES_QTY", true, 120);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesMaster, "납기일", "SALES_DUEDATE", true, 300);

            DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesMaster, "생략", "SO_PurchaseOrder", false, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesMaster, "생략1", "SALES_Out_QTY", false, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesMaster, "생략2", "SALES_NO_QTY", false, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesMaster, "생략3", "SALES_MKT", false, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesMaster, "생략4", "SALES_Order_TYPE", false, 200);
            DataGridViewUtil.AddNewColumnToDataGridView(dgvSalesMaster, "생략5", "SALES_REMARK", false, 200);

            //행번호 추가
            DataGridViewUtil.DataGridViewRowNumSet(dgvSalesMaster);
        }
예제 #17
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(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();
        }
        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);
        }
예제 #20
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();
        }