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(); }
/// <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(); }
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); }
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(); }
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); }
/// <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(); }
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(); }
/// <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(); }
/// <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); }
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); }
/// <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); }
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(); }