private void ShowDgv()
{
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "사용자정의코드 대분류 코드", "1", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "사용자정의코드 대분류 명", "1", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "비고", "1", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "사용유무", "1", true, 100);
}
private void ShowDgv()
{
tabPage4.Text = "작업지시";
tabPage2.Text = "상세내역";
dgvProductRequset.CellDoubleClick += ViewDgvDetail;
CommonClass.AddNewColumnToDataGridView(dgvProductRequset, "작업지시상태", "Wo_Status", true, 150);
CommonClass.AddNewColumnToDataGridView(dgvProductRequset, "작업지시번호", "Workorderno", true, 150);
CommonClass.AddNewColumnToDataGridView(dgvProductRequset, "생산일자", "Plan_Date", true, 120, DataGridViewContentAlignment.MiddleCenter);
CommonClass.AddNewColumnToDataGridView(dgvProductRequset, "품목코드", "Item_Code", true, 120);
CommonClass.AddNewColumnToDataGridView(dgvProductRequset, "품목명", "Item_Name", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvProductRequset, "작업장", "Wc_Name", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvProductRequset, "실적", "Prd_Qty", true, 100, DataGridViewContentAlignment.MiddleRight);
CommonClass.AddNewColumnToDataGridView(dgvProductRequset, "불량이미지 건수", "workImageCount", true, 180, DataGridViewContentAlignment.MiddleRight);
CommonClass.AddNewColumnToDataGridView(dgvProductRequset, "x", "Def_Ma_Code", false, 100);
CommonClass.AddNewColumnToDataGridView(dgvProductRequset, "x", "Def_Mi_Code", false, 100);
CommonClass.AddNewColumnToDataGridView(dgvProductRequset, "x", "Def_Date", false, 100);
CommonClass.AddNewColumnToDataGridView(dgvProductRequset, "x", "Def_Qty", false, 100);
CommonClass.AddNewColumnToDataGridView(dgvProductRequset, "x", "Def_Image_Name", false, 100);
CommonClass.AddNewColumnToDataGridView(dgvProductRequset, "x", "Process_name", false, 100);
CommonClass.AddNewColumnToDataGridView(dgvProductRequset, "x", "Def_Image", false, 100);
CommonClass.AddNewColumnToDataGridView(dgvProductRequset, "x", "Def_Seq", false, 100);
GetData();
}
private void ShowDgv()
{
dgvSearchResult.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.None;
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "직급명", "UserGroup_Name", true, 120);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "화면명", "Screen_Code", true, 200);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "권한", "Pre_Type", true, 120);
}
private void ShowDgv()
{
dgvSearchResult.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "비가동 대분류 코드", "Nop_Ma_Code", true, 300);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "비가동 대분류 명", "Nop_Ma_Name", true, 300);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "사용유무", "Use_YN", true, 300, DataGridViewContentAlignment.MiddleCenter);
}
private void MoldUseStatus_Load(object sender, EventArgs e)
{
frm = (MainForm)this.MdiParent;
//AddNewColumnToDataGridView(dgvSearchResult, "생산일자", "???", true, 120);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "금형코드", "Mold_Code", true, 110);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "금형명", "Mold_Name", true, 150);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "작업지시번호", "Workorderno", true, 200);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "품목코드", "Item_Code", true, 110);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "품목명", "Item_Name", true, 110);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "작업장코드", "Wc_Code", true, 130);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "작업장명", "Wc_Name", true, 110);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "금형타수", "Mold_Shot_Cnt", true, 110, DataGridViewContentAlignment.MiddleRight);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "금형생산량", "Mold_Prd_Qty", true, 130, DataGridViewContentAlignment.MiddleRight);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "금형사용시작시간", "Use_Starttime", true, 170, DataGridViewContentAlignment.MiddleCenter);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "금형사용종료시간", "Use_Endtime", true, 170, DataGridViewContentAlignment.MiddleCenter);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "금형사용시간", "UsingTime", true, 150);
LoadList();
this.dgvSearchResult.DefaultCellStyle.Font = new Font("나눔고딕", 9);
dgvSearchResult.DataSource = list;
dgvSearchResult.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvSearchResult.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvSearchResult.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvSearchResult.Columns[2].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvSearchResult.Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dtpStart.Value = dtpEnd.Value.AddDays(-7);
}
private void ShowDgv()
{
dgvSearchResult.CellDoubleClick += DgvSearchResult_CellDoubleClick;
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "사용자 그룹코드", "UserGroup_Code", true, 200);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "사용자 그룹 명", "UserGroup_Name", true, 200);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "사용여부", "Use_YN", true, 150);
}
private void ShowDgv()
{
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "사번", "User_ID", true, 150, DataGridViewContentAlignment.MiddleCenter);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "사원명", "User_Name", true, 200, DataGridViewContentAlignment.MiddleCenter);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "접속 프로그램", "Form_Type", true, 200, DataGridViewContentAlignment.MiddleCenter);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "로그인 시간", "Login_Time", true, 200, DataGridViewContentAlignment.MiddleCenter);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "로그아웃 시간", "Logout_Time", true, 200, DataGridViewContentAlignment.MiddleCenter);
}
private void ShowDgv()
{
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "화면 코드", "1", true, 120);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "화면 명", "1", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "화면 경로", "1", true, 120);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "ContentDLL", "1", true, 120);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "사용여부", "1", true, 120);
}
private void ShowDgv()
{
CommonClass.AddNewColumnToDataGridView(dgvProductRequset, "모듈 코드", "1", true, 120);
CommonClass.AddNewColumnToDataGridView(dgvProductRequset, "모듈 명", "1", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvJobOrder, "화면 코드", "1", true, 120);
CommonClass.AddNewColumnToDataGridView(dgvJobOrder, "화면 명", "1", true, 100);
}
private void ShowDgv()
{
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "그룹코드", "Level_Code", true, 150);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "그룹명", "Level_Name", true, 200);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "Level", "Level", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "P/L당 PCS 수량", "PCS_Qty", true, 200, DataGridViewContentAlignment.MiddleRight);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "PCS당 소재량", "Mat_Qty", true, 200, DataGridViewContentAlignment.MiddleRight);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "사용여부", "Use_YN", true, 120, DataGridViewContentAlignment.MiddleCenter);
}
private void ShowDgv()
{
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "IPC 코드", "1", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "IPC 명", "1", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "IP", "1", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "SPEC", "1", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "공정", "1", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "사용유무", "1", true, 100);
}
private void ShowDgv()
{
dgvSearchResult.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "대차코드", "GV_Code", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "대차명", "GV_Name", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "대차그룹", "GV_Group", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "대차상태", "GV_Status", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "사용유무", "Use_YN", true, 100, DataGridViewContentAlignment.MiddleCenter);
}
private void MakeDgv()
{
dgvList.CellDoubleClick += dgvList_CellDoubleClick;
CommonClass.AddNewColumnToDataGridView(dgvList, "측정항목", "Condition_Name", false, 130);
CommonClass.AddNewColumnToDataGridView(dgvList, "측정항목", "Condition_Group", true, 130);
CommonClass.AddNewColumnToDataGridView(dgvList, "기준값", "SL", true, 100);
dgvListDetail.CellDoubleClick += DgvListDetail_CellDoubleClick;
CommonClass.AddNewColumnToDataGridView(dgvListDetail, "측정값", "Condition_Val", true, 100);
}
private void ShowDgv()
{
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "순번", "1", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "유형", "1", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "성공여부", "1", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "실행프로시저", "1", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "Target 정보", "1", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "Source 정보", "1", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "Message", "1", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "인터페이스 시각", "1", true, 100);
}
private void ShowDgv()
{
CommonClass.AddNewColumnToDataGridView(dgvSelect, "불량현상 대분류 코드", "Def_Ma_Code", true, 200);
CommonClass.AddNewColumnToDataGridView(dgvSelect, "불량현상 대분류 명", "Def_Ma_Name", true, 200);
CommonClass.AddNewColumnToDataGridView(dgvSelect, "사용유무", "Use_YN", true, 150, DataGridViewContentAlignment.MiddleCenter);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "불량현상 대분류 코드", "Def_Ma_Code", true, 200);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "불량현상 상세분류 코드", "Def_Mi_Code", true, 250);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "불량현상 상세분류 명", "Def_Mi_Name", true, 250);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "사용여부", "Use_YN", true, 150, DataGridViewContentAlignment.MiddleCenter);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "비고", "Remark", true, 500);
}
private void ShowDgv()
{
dgvSearchResult.CellDoubleClick += DgvSearchResult_CellDoubleClick;
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "사용자 이름", "User_Name", true, 150);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "사용자 ID", "User_ID", true, 150, DataGridViewContentAlignment.MiddleCenter);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "사용자 그룹코드", "UserGroup_Code", true, 150, DataGridViewContentAlignment.MiddleCenter);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "사용자 그룹 명", "UserGroup_Name", true, 150);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "사용여부", "Use_YN", true, 120, DataGridViewContentAlignment.MiddleCenter);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "패스워드 초기화 횟수", "Pw_Reset_Count", true, 200, DataGridViewContentAlignment.MiddleRight);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "기본 공정", "User_Type", true, 120);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "x", "Default_Process_Code", false, 100);
}
private void ShowDgv()
{
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "생산일자", "In_Date", true, 120, DataGridViewContentAlignment.MiddleCenter);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "품목코드", "Item_Code", true, 120);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "품목명", "Item_Name", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "팔레트번호", "Pallet_No", true, 130);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "입고수량", "Prd_Qty", true, 120, DataGridViewContentAlignment.MiddleRight);
//CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "마감시각", "Closed_Time", true, 120, DataGridViewContentAlignment.MiddleCenter);
//CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "취소시각", "Cancel_Time", true, 120, DataGridViewContentAlignment.MiddleCenter);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "ERP 업로드여부", "Upload_Flag", true, 180, DataGridViewContentAlignment.MiddleRight);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "작업지시번호", "Workorderno", true, 150);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "작업지시상태", "Wo_Status", true, 150);
}
private void ShowDgv()
{
tabPage3.Text = "";
tabPage4.Text = "";
CommonClass.AddNewColumnToDataGridView(dgvSelect, "시스템 대분류 코드", "1", true, 150);
CommonClass.AddNewColumnToDataGridView(dgvSelect, "시스템 대분류 명", "1", true, 180);
CommonClass.AddNewColumnToDataGridView(dgvSelect, "비고", "1", true, 230);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "시스템 상세분류 코드", "1", true, 150);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "시스템 상세분류 명", "1", true, 180);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "정렬순번", "1", true, 200);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "비고", "1", true, 230);
}
private void ShowDgv()
{
tabPage3.Text = "포장등급 목록";
tabPage4.Text = "포장등급 상세목록";
dgvSelect.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
CommonClass.AddNewColumnToDataGridView(dgvSelect, "포장 등급", "1", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "포장등급 상세코드", "1", true, 200);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "포장등급 상세 명", "1", true, 200);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "상세명 수동 입력 여부", "1", true, 200);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "사용유무", "1", true, 150);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "비고", "1", true, 100);
}
private void MakeDgv()
{
dgvDetail.CellDoubleClick += dgvDetail_CellDoubleClick;
CommonClass.AddNewColumnToDataGridView(dgvDetail, "측정항목", "Inspect_name", true, 120);
CommonClass.AddNewColumnToDataGridView(dgvDetail, "기준값", "SL", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvDetaillist, "측정일시", "Inspect_Datetime", true, 120);
CommonClass.AddNewColumnToDataGridView(dgvDetaillist, "품목코드", "Item_Code", true, 120);
CommonClass.AddNewColumnToDataGridView(dgvDetaillist, "품목명", "Item_Name", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvDetaillist, "편차", "deviation", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvDetaillist, "측정값", "Inspect_Val", true, 100);
}
private void ShowDgv()
{
tabPage3.Text = "";
tabPage4.Text = "";
CommonClass.AddNewColumnToDataGridView(dgvSelect, "사용자정의코드 대분류 코드", "1", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSelect, "사용자정의코드 대분류 명", "1", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSelect, "사용자정의코드 대분류 비고", "1", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSelect, "사용자정의코드 대분류 사용유무", "1", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "사용자정의코드 상세분류 코드", "1", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "사용자정의코드 상세분류 명", "1", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "정렬순번", "1", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "비고", "1", true, 100);
}
private void ShowDgv()
{
tabPage3.Text = "비가동 대분류 목록";
tabPage4.Text = "비가동 상세분류 조회";
CommonClass.AddNewColumnToDataGridView(dgvSelect, "비가동 대분류 코드", "Nop_Ma_Code", true, 200);
CommonClass.AddNewColumnToDataGridView(dgvSelect, "비가동 대분류 명", "Nop_Ma_Name", true, 200);
CommonClass.AddNewColumnToDataGridView(dgvSelect, "사용유무", "Use_YN", true, 150, DataGridViewContentAlignment.MiddleCenter);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "비가동 상세분류 코드", "Nop_Mi_Code", true, 200);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "비가동 상세분류 명", "Nop_Mi_Name", true, 200);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "사용유무", "Use_YN", true, 150, DataGridViewContentAlignment.MiddleCenter);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "비고", "Remark", true, 300);
}
private void GetData()
{
dgvJobOrder.CellDoubleClick += DgvProductRequset_CellDoubleClick;
CommonClass.AddNewColumnToDataGridView(dgvJobOrder, "작업지시번호", "Workorderno", true, 150);
CommonClass.AddNewColumnToDataGridView(dgvJobOrder, "품목코드", "Item_Code", true, 120);
CommonClass.AddNewColumnToDataGridView(dgvJobOrder, "품목명", "Item_Name", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvJobOrder, "불량대분류", "Def_Ma_Code", true, 120);
CommonClass.AddNewColumnToDataGridView(dgvJobOrder, "불량상세분류", "Def_Mi_Code", true, 150);
CommonClass.AddNewColumnToDataGridView(dgvJobOrder, "발생일시", "Def_Date", true, 120, DataGridViewContentAlignment.MiddleCenter);
CommonClass.AddNewColumnToDataGridView(dgvJobOrder, "불량수량", "Def_Qty", true, 120, DataGridViewContentAlignment.MiddleRight);
CommonClass.AddNewColumnToDataGridView(dgvJobOrder, "사진이름", "Def_Image_Name", true, 120);
CommonClass.AddNewColumnToDataGridView(dgvJobOrder, "불량사진", "Def_Image", false, 120);
CommonClass.AddNewColumnToDataGridView(dgvJobOrder, "x", "Def_Image_Path", false, 100);
}
private void ShowDgv()
{
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "공정코드", "Process_Code", true, 200);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "공정 명", "Process_Name", true, 250);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "공정그룹", "Process_Group", true, 120);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "비고", "Remark", true, 400);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "사용여부", "Use_YN", true, 120, DataGridViewContentAlignment.MiddleCenter);
dgvSearchResult.RowHeadersVisible = false;
DataGridViewCheckBoxColumn chkboxCol = new DataGridViewCheckBoxColumn();
chkboxCol.Width = 30;
chkboxCol.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvSearchResult.Columns.Insert(0, chkboxCol);
}
private void ShowDgv()
{
dgvSearchResult.CellDoubleClick += DgvSearchResult_CellDoubleClick;
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "작업지시상태", "Wo_Status", true, 150);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "작업지시번호", "Workorderno", true, 150, DataGridViewContentAlignment.MiddleRight);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "품목코드", "Item_Code", true, 120);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "품목명", "Item_Name", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "작업장", "Wc_Code", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "투입수량", "In_Qty_Main", true, 120, DataGridViewContentAlignment.MiddleRight);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "불량수량", "Bad_Qty", true, 120, DataGridViewContentAlignment.MiddleRight);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "생산수량", "Prd_Qty", true, 120, DataGridViewContentAlignment.MiddleRight);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "불량률(%)", "Faulty", true, 140, DataGridViewContentAlignment.MiddleRight);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "생산수량", "Plan_Date", false, 120);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "생산수량", "Process_code", false, 120);
}
private void ShowDgv()
{
CommonClass.AddNewColumnToDataGridView(dgvRun, "작업장 코드", "Wc_Code", true, 140);
CommonClass.AddNewColumnToDataGridView(dgvRun, "작업장 이름", "Wc_Name", true, 140);
CommonClass.AddNewColumnToDataGridView(dgvRun, "작업장 그룹명", "Wc_Group", true, 170);
CommonClass.AddNewColumnToDataGridView(dgvRun, "작업장 상태", "Wo_Status", true, 150);
CommonClass.AddNewColumnToDataGridView(dgvRun, "최근 시작시간", "Prd_Starttime", true, 150);
CommonClass.AddNewColumnToDataGridView(dgvRun, "최근 멈춘시간", "Prd_Endtime", false, 150);
CommonClass.AddNewColumnToDataGridView(dgvNoRun, "작업장 코드", "Wc_Code", true, 140);
CommonClass.AddNewColumnToDataGridView(dgvNoRun, "작업장 이름", "Wc_Name", true, 140);
CommonClass.AddNewColumnToDataGridView(dgvNoRun, "작업장 그룹명", "Wc_Group", true, 170);
CommonClass.AddNewColumnToDataGridView(dgvNoRun, "작업장 상태", "Wo_Status", true, 150);
CommonClass.AddNewColumnToDataGridView(dgvNoRun, "최근 시작시간", "Prd_Starttime", false, 150);
CommonClass.AddNewColumnToDataGridView(dgvNoRun, "최근 멈춘시간", "Prd_Endtime", true, 150);
}
private void NoticeSearch()
{
dgvSearchResult.RowHeadersVisible = false;
DataGridViewCheckBoxColumn chkboxCol = new DataGridViewCheckBoxColumn();
chkboxCol.Width = 30;
chkboxCol.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvSearchResult.Columns.Insert(0, chkboxCol);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "번호", "Seq", false, 200);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "공지 날짜", "Notice_Date", true, 150);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "제목", "Title", true, 500);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "공지 내용", "Description", true, 1500);
NoticeService noticeService = new NoticeService();
dgvSearchResult.DataSource = noticeService.GetAllNotice();
}
private void ShowDgv()
{
dgvSearchResult.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.None;
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "작업지시번호", "Workorderno", true, 200);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "생산일", "Plan_Date", true, 100, DataGridViewContentAlignment.MiddleCenter);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "공정", "Process_name", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "작업장", "Wc_Name", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "품목코드", "Item_Code", true, 120);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "품목명", "Item_Name", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "측정항목", "Condition_Name", true, 120);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "USL", "USL", true, 100, DataGridViewContentAlignment.MiddleRight);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "SL", "SL", true, 100, DataGridViewContentAlignment.MiddleRight);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "LSL", "LSL", true, 100, DataGridViewContentAlignment.MiddleRight);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "측정일시", "Condition_Date", true, 120, DataGridViewContentAlignment.MiddleCenter);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "측정일자", "Condition_Datetime", true, 120, DataGridViewContentAlignment.MiddleCenter);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "측정값", "Condition_Val", true, 100, DataGridViewContentAlignment.MiddleRight);
}
private void MoldInformationRegister_Load(object sender, EventArgs e)
{
//dgv 추가
frm = (MainForm)this.MdiParent;
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "금형코드", "Mold_Code", true, 110);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "금형명", "Mold_Name", true, 120);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "금형그룹", "Mold_Group", true, 140);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "금형상태", "Mold_Status", true, 110);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "금형누적타수", "Cum_Shot_Cnt", true, 150, DataGridViewContentAlignment.MiddleRight);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "금형누적생산량", "Cum_Prd_Qty", true, 150, DataGridViewContentAlignment.MiddleRight);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "금형누적사용시간", "Cum_Time", true, 160, DataGridViewContentAlignment.MiddleRight);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "보장타수", "Guar_Shot_Cnt", true, 110, DataGridViewContentAlignment.MiddleRight);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "구입금액", "Purchase_Amt", true, 110, DataGridViewContentAlignment.MiddleRight);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "입고일자", "In_Date", true, 150, DataGridViewContentAlignment.MiddleCenter);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "최종장착일시", "Last_Setup_Time", true, 150, DataGridViewContentAlignment.MiddleCenter);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "비고", "Remark", true, 80);
CommonClass.AddNewColumnToDataGridView(dgvSearchResult, "사용유무", "Use_YN", true, 110, DataGridViewContentAlignment.MiddleCenter);
LoadList();
dgvSearchResult.DataSource = List;
dgvSearchResult.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvSearchResult.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvSearchResult.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvSearchResult.Columns[2].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvSearchResult.Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
this.dgvSearchResult.CellDoubleClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.DgvSearchResult_DoubleClick);
this.dgvSearchResult.CellClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.dgvSearchResult_Click);
//콤보바인딩
List <ComboItem> item = (from items in List
select new ComboItem
{
comboText = items.Mold_Group.ToString(),
comboValue = items.Mold_Group.ToString()
}).Distinct().ToList();
ComboClass.ComboBind(item, cmbMoldGroupSearch, true);
//ComboClass.ComboBind(item, cmbMoldGroupI, false);
//ComboClass.ComboBind(item, cmbMoldGroupM, false);
cmbMoldGroupSearch.DataSource = item.Select(items => items.comboText).Distinct().ToList();
cmbMoldGroupM.DataSource = item.Select(items => items.comboText).Distinct().ToList();
cmbMoldGroupI.DataSource = item.Select(items => items.comboText).Distinct().ToList();
}
private void ShowDgv()
{
dgvProductRequset.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.None;
dgvProductRequset.CellDoubleClick += DgvProductRequset_CellDoubleClick;
CommonClass.AddNewColumnToDataGridView(dgvProductRequset, "작업자", "User_ID", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvProductRequset, "근무일", "Work_Date", true, 150, DataGridViewContentAlignment.MiddleCenter);
dgvJobOrder.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.None;
CommonClass.AddNewColumnToDataGridView(dgvJobOrder, "작업지시번호", "Workorderno", true, 200);
CommonClass.AddNewColumnToDataGridView(dgvJobOrder, "작업장코드", "Wc_Code", true, 150);
CommonClass.AddNewColumnToDataGridView(dgvJobOrder, "작업장명", "Wc_Name", true, 130);
CommonClass.AddNewColumnToDataGridView(dgvJobOrder, "품목코드", "Item_Code", true, 130);
CommonClass.AddNewColumnToDataGridView(dgvJobOrder, "품목명", "Item_Name", true, 100);
CommonClass.AddNewColumnToDataGridView(dgvJobOrder, "작업시작일시", "Allocation_datetime", true, 200, DataGridViewContentAlignment.MiddleCenter);
CommonClass.AddNewColumnToDataGridView(dgvJobOrder, "작업종료일시", "Release_datetime", true, 200, DataGridViewContentAlignment.MiddleCenter);
CommonClass.AddNewColumnToDataGridView(dgvJobOrder, "생산수량", "Prd_Qty", true, 120, DataGridViewContentAlignment.MiddleRight);
CommonClass.AddNewColumnToDataGridView(dgvJobOrder, "할당작업자", "User_ID", true, 150);
CommonClass.AddNewColumnToDataGridView(dgvJobOrder, "근무일", "Work_Date", false, 150, DataGridViewContentAlignment.MiddleCenter);
}