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();
}
/// <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(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();
}
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();
}
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(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);
}
//그리드뷰 컬럼 생성
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();
}
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 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}");
}
}
/// <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();
}
/// <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}");
}
}
/// <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}");
}
}
/// <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}");
}
}
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}");
}
}
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();
}
/// <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}");
}
}
/// <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();
}
/// <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()
{
//데이터그리드뷰 초기설정
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(dgv1);
DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "no", "idx", true, 30);
DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "입출고일", "INS_DATE", true, 200);
DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "구분", "INS_TYP", true, 100);
DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "창고", "FAC_NAME", true, 100);
DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "품목", "ITEM_CODE", true, 200);
DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "품명", "ITEM_NAME", true, 200);
DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "규격", "ITEM_STND", true, 200);
DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "품목형태", "ITEM_TYP", true, 100);
DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "관리등급", "ITEM_MANAGE_LEVEL", true, 100);
DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "수불량", "INS_QTY", true, 200);
DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "단가", "MC_UNITPRICE_CUR", true, 200);
DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "금액", "price", true, 200);
}
private void DataGridViewColumnSet()
{
try
{
DataGridViewUtil.InitSettingGridView(dgvCOMMON);
DataGridViewUtil.AddNewColumnToDataGridView(dgvCOMMON, "No", "idx", true, 30);
DataGridViewUtil.AddNewColumnToDataGridView(dgvCOMMON, "코드", "COMMON_CODE", true, 170);
DataGridViewUtil.AddNewColumnToDataGridView(dgvCOMMON, "이름", "COMMON_NAME", true, 170);
DataGridViewUtil.AddNewColumnToDataGridView(dgvCOMMON, "부모", "COMMON_PARENT", true, 80);
DataGridViewUtil.AddNewColumnToDataGridView(dgvCOMMON, "SEQ", "COMMON_SEQ", true, 29);
}
catch (Exception err)
{
this.Log.WriteError($"[[RECV {this.Name}]]:{err.Message}");
}
}
/// <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);
}
/// <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();
}
/// <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();
}
/// <summary>
/// 데이터 그리드뷰 컬럼+체크박스 만들기
/// </summary>
private void DataGridViewColumnSet1()
{
try
{
DataGridViewUtil.InitSettingGridView(dgv1);
DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "no", "idx", true, 30);
DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "계획시작일자", "WO_PLAN_DATE", true, 200);
DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "작업지시ID", "WO_Code", true, 200);
DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "설비명", "FCLTS_NAME", true, 200);
DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "소진창고", "FAC_NAME", true, 200);
DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "품목", "ITEM_CODE", true, 200);
DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "품명", "ITEM_NAME", true, 200);
DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "지시수량", "WO_PLAN_QTY", true, 200);
DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "단위", "ITEM_UNIT", true, 200);
DataGridViewUtil.AddNewColumnToDataGridView(dgv1, "상태명", "WO_WORK_STATE", true, 200);
}
catch (Exception err)
{
this.Log.WriteError($"[[RECV {this.Name}]]:{err.Message}");
}
}
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();
}
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();
}
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();
}
