/// <summary>
/// 데이터 그리드뷰 설정
/// </summary>
private void SetDGV()
{
InitControlUtil.SetPOPDGVDesign(dgvMain);
InitControlUtil.AddNewColumnToDataGridView(dgvMain, "상태", "Wo_Status", true, 80, DataGridViewContentAlignment.MiddleCenter, false);
InitControlUtil.AddNewColumnToDataGridView(dgvMain, "작업지시번호", "Workorderno", true, 180, DataGridViewContentAlignment.MiddleLeft, false);
InitControlUtil.AddNewColumnToDataGridView(dgvMain, "할당작업자", "User_ID", true, 130, DataGridViewContentAlignment.MiddleLeft, false);
InitControlUtil.AddNewColumnToDataGridView(dgvMain, "품목코드", "Item_Code", true, 110, DataGridViewContentAlignment.MiddleLeft, false);
InitControlUtil.AddNewColumnToDataGridView(dgvMain, "품목명", "Item_Name", true, 80, DataGridViewContentAlignment.MiddleLeft, true);
InitControlUtil.AddNewColumnToDataGridView(dgvMain, "단위", "Prd_Unit", true, 70, DataGridViewContentAlignment.MiddleCenter, false);
InitControlUtil.AddNewColumnToDataGridView(dgvMain, "계획수량", "Plan_Qty", true, 110, DataGridViewContentAlignment.MiddleRight, false);
InitControlUtil.AddNewColumnToDataGridView(dgvMain, "실적수량", "Prd_Qty", true, 110, DataGridViewContentAlignment.MiddleRight, false);
InitControlUtil.AddNewColumnToDataGridView(dgvMain, "생산시작시간", "Prd_Starttime", true, 200, DataGridViewContentAlignment.MiddleLeft, false);
InitControlUtil.AddNewColumnToDataGridView(dgvMain, "생산종료시간", "Prd_Endtime", true, 200);
InitControlUtil.AddNewColumnToDataGridView(dgvMain, "계획 날짜", "Plan_Date", false);
InitControlUtil.AddNewColumnToDataGridView(dgvMain, "실적수량", "Prd_Qty", false);
InitControlUtil.AddNewColumnToDataGridView(dgvMain, "성형 줄 수", "Line_Per_Qty", false);
InitControlUtil.AddNewColumnToDataGridView(dgvMain, "포장 샷당 pcs수", "Shot_Per_Qty", false);
InitControlUtil.AddNewColumnToDataGridView(dgvMain, "공정코드", "Process_Code", false);
InitControlUtil.AddNewColumnToDataGridView(dgvMain, "산출수량", "Out_Qty_Main", false);
InitControlUtil.AddNewColumnToDataGridView(dgvMain, "팔렛당 박스수", "Box_Qty", false);
InitControlUtil.AddNewColumnToDataGridView(dgvMain, "박스당 pcs수", "Pcs_Qty", false);
dgvMain.Columns[8].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss";
dgvMain.Columns[9].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss";
}
private void MainDataLoad()
{
InitControlUtil.SetDGVDesign(dgvMainGrid);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "작업지시상태", "Wo_Status", true, 110);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "작업지시번호", "Workorderno", true, 110);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "계획일자", "Plan_Date", true, 90);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "계획수량", "Plan_Qty", true, 90);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "계획수량단위", "Plan_Unit", true, 110);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "품목코드", "Item_Code", true, 90);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "품목명", "Item_Name", true, 90);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "작업장명", "Wc_Name", true, 90);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "작업일자", "Prd_Date", true, 90);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "작업시작시간", "Prd_Starttime", true, 80);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "작업종료시간", "Prd_Endtime", true, 80);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "투입수량", "In_Qty_Main", true, 80);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "산출수량", "Out_Qty_Main", true, 80);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "생산수량", "Prd_Qty", true, 80);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "생산의뢰순번", "Req_Seq", true, 80);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "생산의뢰번호", "Wo_Req_No", true, 80);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "프로젝트명", "Project_Name", true, 100);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "공정코드", "Process_Code", false, 100);
dgvMainGrid.Columns[9].DefaultCellStyle.Format = "HH:mm:ss";
dgvMainGrid.Columns[10].DefaultCellStyle.Format = "HH:mm:ss";
}
private void InitControls()
{
lblGvCode.Text = "";
InitControlUtil.SetPOPDGVDesign(dgvGVList);
InitControlUtil.AddNewColumnToDataGridView(dgvGVList, "건조대차", "GV_Name", true, 110);
InitControlUtil.AddNewColumnToDataGridView(dgvGVList, "품목코드", "Item_Code", true, 100, DataGridViewContentAlignment.MiddleLeft, true);
InitControlUtil.AddNewColumnToDataGridView(dgvGVList, "품목명", "Item_Name", true, 200, DataGridViewContentAlignment.MiddleLeft, true);
InitControlUtil.AddNewColumnToDataGridView(dgvGVList, "수량", "Loading_Qty", true, 100, DataGridViewContentAlignment.MiddleLeft);
InitControlUtil.AddNewColumnToDataGridView(dgvGVList, "품목이름", "Item_Name", false, 100);
InitControlUtil.AddNewColumnToDataGridView(dgvGVList, "품목이름", "Item_Code", false, 100);
InitControlUtil.AddNewColumnToDataGridView(dgvGVList, "작업장코드", "Wc_Code", false, 100);
InitControlUtil.AddNewColumnToDataGridView(dgvGVList, "작업장명", "Wc_Code", false, 100);
InitControlUtil.AddNewColumnToDataGridView(dgvGVList, "공정코드", "Process_code", false, 100);
InitControlUtil.AddNewColumnToDataGridView(dgvGVList, "공정이름", "Process_name", false, 100);
InitControlUtil.AddNewColumnToDataGridView(dgvGVList, "작업지시일", "Plan_Date", false, 100);
InitControlUtil.AddNewColumnToDataGridView(dgvGVList, "계획수량", "Plan_Qty", false, 100);
InitControlUtil.AddNewColumnToDataGridView(dgvGVList, "계획단위", "Prd_Unit", false, 100);
InitControlUtil.AddNewColumnToDataGridView(dgvGVList, "생산의뢰번호", "Wo_Req_No", false, 100);
InitControlUtil.AddNewColumnToDataGridView(dgvGVList, "생산의뢰순서", "Req_Seq", false, 100);
InitControlUtil.AddNewColumnToDataGridView(dgvGVList, "대차이력 순서", "Hist_Seq", false);
InitControlUtil.AddNewColumnToDataGridView(dgvGVList, "작업지시번호", "Workorderno", false);
InitControlUtil.AddNewColumnToDataGridView(dgvGVList, "건조대차코드", "GV_Code", false);
InitControlUtil.AddNewColumnToDataGridView(dgvGVList, "대차현황순서", "Status_Seq", false);
dgvGVList.Columns[10].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss";
}
private void MainDataLoad()
{
InitControlUtil.SetDGVDesign(dgvMainGrid);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "품목코드", "Item_Code", true, 250, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "품목명", "Item_Name", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "포장일자", "In_Date", true, 250, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "일일 포장량", "F_In_Qty", true, 170, DataGridViewContentAlignment.MiddleRight);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "누계 포장량", "Qty_Sum", true, 170, DataGridViewContentAlignment.MiddleRight);
}
private void SearchForm_Load(object sender, EventArgs e)
{
InitControlUtil.SetDGVDesign(dgvSearchResult);
InitControlUtil.AddNewColumnToDataGridView(dgvSearchResult, "등급상세", "Grade_Detail_Name", true, 100, DataGridViewContentAlignment.MiddleLeft, true);
InitControlUtil.AddNewColumnToDataGridView(dgvSearchResult, "팔레트번호", "Pallet_No", true, 100, DataGridViewContentAlignment.MiddleLeft, true);
Pallet_MasterService service = new Pallet_MasterService();
dgvSearchResult.DataSource = service.GetAll(GlobalUsage.WorkOrderNo);
lblSearch.Text = "팔레트 목록";
}
private void MainDataLoad()
{
InitControlUtil.SetDGVDesign(dgvMainGrid);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "작업지시상태", "Wo_Status", true, 110);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "작업지시번호", "Workorderno", true, 110);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "계획일자", "Plan_Date", true, 100);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "계획수량", "Plan_Qty", true, 80);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "계획수량단위", "Plan_Unit", true, 80);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "품목코드", "Item_Code", true, 90);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "품목명", "Item_Name", true, 90, default, true);
private void InitControls()
{
InitControlUtil.SetPOPDGVDesign(dgvPalletList);
InitControlUtil.AddNewColumnToDataGridView(dgvPalletList, "팔레트번호", "Pallet_No", true, 100, DataGridViewContentAlignment.MiddleLeft, true);
InitControlUtil.AddNewColumnToDataGridView(dgvPalletList, "제품", "Item_Name", true, 200);
InitControlUtil.AddNewColumnToDataGridView(dgvPalletList, "등급", "Grade_Detail_Name", true, 200, DataGridViewContentAlignment.MiddleCenter);
InitControlUtil.AddNewColumnToDataGridView(dgvPalletList, "수량", "CurrentQty", true, 100, DataGridViewContentAlignment.MiddleRight);
InitControlUtil.AddNewColumnToDataGridView(dgvPalletList, "등급상세", "Grade_Detail_Code", false);
InitControlUtil.AddNewColumnToDataGridView(dgvPalletList, "사이즈", "Size_Code", false);
InitControlUtil.AddNewColumnToDataGridView(dgvPalletList, "등급", "Boxing_Grade_Code", false);
}
private void InitControls()
{
InitControlUtil.SetPOPDGVDesign(dgvEquipMoldList);
InitControlUtil.AddNewColumnToDataGridView(dgvEquipMoldList, "금형코드", "Mold_Code", true, 110);
InitControlUtil.AddNewColumnToDataGridView(dgvEquipMoldList, "금형명", "Mold_Name", true, 100, DataGridViewContentAlignment.MiddleLeft, true);
InitControlUtil.AddNewColumnToDataGridView(dgvEquipMoldList, "그룹", "Mold_Group", true, 100, DataGridViewContentAlignment.MiddleCenter);
InitControlUtil.SetPOPDGVDesign(dgvEquipedMoldList);
InitControlUtil.AddNewColumnToDataGridView(dgvEquipedMoldList, "금형코드", "Mold_Code", true, 110);
InitControlUtil.AddNewColumnToDataGridView(dgvEquipedMoldList, "금형명", "Mold_Name", true, 100, DataGridViewContentAlignment.MiddleLeft, true);
InitControlUtil.AddNewColumnToDataGridView(dgvEquipedMoldList, "그룹", "Mold_Group", true, 100, DataGridViewContentAlignment.MiddleCenter);
}
private void InitControls()
{
InitControlUtil.SetPOPDGVDesign(dgvAllocatedWorker);
InitControlUtil.AddNewColumnToDataGridView(dgvAllocatedWorker, "작업자", "User_Name", true, 100);
InitControlUtil.AddNewColumnToDataGridView(dgvAllocatedWorker, "할당시각", "Allocation_datetime", true, 200, DataGridViewContentAlignment.MiddleLeft, true);
InitControlUtil.AddNewColumnToDataGridView(dgvAllocatedWorker, "ID", "User_ID", true, 80);
dgvAllocatedWorker.Columns[1].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss";
InitControlUtil.SetPOPDGVDesign(dgvAllocatableWorker);
InitControlUtil.AddNewColumnToDataGridView(dgvAllocatableWorker, "작업자", "User_Name", true, 100);
InitControlUtil.AddNewColumnToDataGridView(dgvAllocatableWorker, "현재 작업장", "NOWWC", true, 100, DataGridViewContentAlignment.MiddleLeft, true);
InitControlUtil.AddNewColumnToDataGridView(dgvAllocatableWorker, "ID", "User_ID", false, 80);
}
private void InitControls()
{
InitControlUtil.SetPOPDGVDesign(dgvGVList);
InitControlUtil.AddNewColumnToDataGridView(dgvGVList, "대차코드", "GV_Code", false, 80);
InitControlUtil.AddNewColumnToDataGridView(dgvGVList, "소성대차", "GV_Name", true, 100, DataGridViewContentAlignment.MiddleLeft, true);
InitControlUtil.AddNewColumnToDataGridView(dgvGVList, "적재시각", "Loading_time", true, 200);
InitControlUtil.AddNewColumnToDataGridView(dgvGVList, "수량", "Loading_Qty", true, 150, DataGridViewContentAlignment.MiddleCenter);
InitControlUtil.AddNewColumnToDataGridView(dgvGVList, "요입시각", "In_Time", true, 200);
InitControlUtil.AddNewColumnToDataGridView(dgvGVList, "요출시각", "Out_Time", true, 200);
InitControlUtil.AddNewColumnToDataGridView(dgvGVList, "소요시간", "Center_Time", true, 110);
dgvGVList.Columns[4].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss";
dgvGVList.Columns[5].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss";
dgvGVList.Columns[2].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss";
}
/// <summary>
/// 컨트롤 설정
/// </summary>
private void InitControls()
{
lblHistReq.Text = "";
InitControlUtil.SetPOPDGVDesign(dgvWoReq);
InitControlUtil.AddNewColumnToDataGridView(dgvWoReq, "의뢰순번", "Req_Seq", false, 100, DataGridViewContentAlignment.MiddleLeft, false);
InitControlUtil.AddNewColumnToDataGridView(dgvWoReq, "생산의뢰번호", "Wo_Req_No", false, 160, DataGridViewContentAlignment.MiddleLeft, false);
InitControlUtil.AddNewColumnToDataGridView(dgvWoReq, "생산수량단위", "Prd_Unit", false, 200, DataGridViewContentAlignment.MiddleLeft, true);
InitControlUtil.AddNewColumnToDataGridView(dgvWoReq, "소성대차", "GV_Name", true, 130, DataGridViewContentAlignment.MiddleLeft, false);
InitControlUtil.AddNewColumnToDataGridView(dgvWoReq, "품목코드", "Item_Code", true, 130, DataGridViewContentAlignment.MiddleLeft, false);
InitControlUtil.AddNewColumnToDataGridView(dgvWoReq, "품목명", "Item_Name", true, 200, DataGridViewContentAlignment.MiddleLeft, true);
InitControlUtil.AddNewColumnToDataGridView(dgvWoReq, "수량", "Loading_Qty", true, 130, DataGridViewContentAlignment.MiddleRight, false);
InitControlUtil.AddNewColumnToDataGridView(dgvWoReq, "대차이력 순서", "Hist_Seq", false);
InitControlUtil.AddNewColumnToDataGridView(dgvWoReq, "박스당PCS", "Pcs_Qty", true, 120, DataGridViewContentAlignment.MiddleRight);
}
private void InitControls()
{
InitControlUtil.SetPOPDGVDesign(dgvNopList);
InitControlUtil.AddNewColumnToDataGridView(dgvNopList, "작업장", "Wc_Name", true, 100, DataGridViewContentAlignment.MiddleLeft, true);
InitControlUtil.AddNewColumnToDataGridView(dgvNopList, "주원인", "Nop_Ma_Name", true, 130, DataGridViewContentAlignment.MiddleCenter);
InitControlUtil.AddNewColumnToDataGridView(dgvNopList, "상세원인", "Nop_Mi_Name", true, 130, DataGridViewContentAlignment.MiddleCenter);
InitControlUtil.AddNewColumnToDataGridView(dgvNopList, "발생시각", "Nop_Happentime", true, 200);
InitControlUtil.AddNewColumnToDataGridView(dgvNopList, "해제시각", "Nop_Canceltime", true, 200);
InitControlUtil.AddNewColumnToDataGridView(dgvNopList, "비가동시간(분)", "Nop_Time", true, 200);
InitControlUtil.AddNewColumnToDataGridView(dgvNopList, "작업장코드", "Wc_Code", true, 120);
InitControlUtil.AddNewColumnToDataGridView(dgvNopList, "발생순번", "Nop_Seq", true, 120);
dgvNopList.Columns[3].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss";
dgvNopList.Columns[4].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss";
}
private void InitControls()
{
InitControlUtil.SetPOPDGVDesign(dgvBoxing);
InitControlUtil.AddNewColumnToDataGridView(dgvBoxing, "대차코드", "GV_Code", true, 110);
InitControlUtil.AddNewColumnToDataGridView(dgvBoxing, "대차명", "GV_Name", true, 100);
InitControlUtil.AddNewColumnToDataGridView(dgvBoxing, "작업지시번호", "Workorderno", true, 200, DataGridViewContentAlignment.MiddleLeft, true);
InitControlUtil.AddNewColumnToDataGridView(dgvBoxing, "품목코드", "Item_Code", true, 120);
InitControlUtil.AddNewColumnToDataGridView(dgvBoxing, "품목명", "Item_Name", true, 200);
InitControlUtil.AddNewColumnToDataGridView(dgvBoxing, "수량", "Loading_Qty", true, 100, DataGridViewContentAlignment.MiddleRight);
InitControlUtil.AddNewColumnToDataGridView(dgvBoxing, "대차상태", "GV_Status", true, 110, DataGridViewContentAlignment.MiddleCenter);
InitControlUtil.AddNewColumnToDataGridView(dgvBoxing, "palinbox", "Box_Qty", false, 100);
InitControlUtil.AddNewColumnToDataGridView(dgvBoxing, "boxinpcs", "Pcs_Qty", false, 100);
InitControlUtil.AddNewColumnToDataGridView(dgvBoxing, "내역순서", "Hist_Seq", false, 100);
InitControlUtil.AddNewColumnToDataGridView(dgvBoxing, "현황순서", "Status_Seq", false, 100);
}
private void InitControls()
{
InitControlUtil.SetPOPDGVDesign(dgvGVTo);
InitControlUtil.AddNewColumnToDataGridView(dgvGVTo, "코드", "GV_Code", true, 100);
InitControlUtil.AddNewColumnToDataGridView(dgvGVTo, "대차명", "GV_Name", true, 100, DataGridViewContentAlignment.MiddleLeft, true);
InitControlUtil.SetPOPDGVDesign(dgvGVFrom);
InitControlUtil.AddNewColumnToDataGridView(dgvGVFrom, "코드", "GV_Code", true, 150);
InitControlUtil.AddNewColumnToDataGridView(dgvGVFrom, "대차명", "GV_Name", true, 120, DataGridViewContentAlignment.MiddleLeft, true);
InitControlUtil.AddNewColumnToDataGridView(dgvGVFrom, "적재시각", "Loading_time", true, 200);
InitControlUtil.AddNewColumnToDataGridView(dgvGVFrom, "수량", "Loading_Qty", true, 80, DataGridViewContentAlignment.MiddleCenter);
InitControlUtil.AddNewColumnToDataGridView(dgvGVFrom, "", "Item_Code", false, 50);
InitControlUtil.AddNewColumnToDataGridView(dgvGVFrom, "작업지시번호", "Workorderno", true, 200);
dgvGVFrom.Columns[2].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss";
}
private void InitControls()
{
InitControlUtil.SetPOPDGVDesign(dgvInPallet);
InitControlUtil.AddNewColumnToDataGridView(dgvInPallet, "작업지시번호", "WorkOrderNo", false);
InitControlUtil.AddNewColumnToDataGridView(dgvInPallet, "팔레트번호", "Pallet_No", true, 100, DataGridViewContentAlignment.MiddleLeft, true);
InitControlUtil.AddNewColumnToDataGridView(dgvInPallet, "Seq", "Pal_Seq", true, 100);
InitControlUtil.AddNewColumnToDataGridView(dgvInPallet, "제품", "Item_Name", true, 250);
InitControlUtil.AddNewColumnToDataGridView(dgvInPallet, "등급", "Boxing_Grade_Code", true, 200, DataGridViewContentAlignment.MiddleCenter);
InitControlUtil.AddNewColumnToDataGridView(dgvInPallet, "수량", "In_Qty", true, 100, DataGridViewContentAlignment.MiddleRight);
InitControlUtil.AddNewColumnToDataGridView(dgvInPallet, "등급상세", "Grade_Detail_Code", false);
InitControlUtil.AddNewColumnToDataGridView(dgvInPallet, "사이즈", "Size_Code", false);
InitControlUtil.AddNewColumnToDataGridView(dgvInPallet, "계획날짜", "Plan_Date", false);
InitControlUtil.AddNewColumnToDataGridView(dgvInPallet, "제품", "Item_Code", false);
InitControlUtil.AddNewColumnToDataGridView(dgvInPallet, "작업장코드", "Wc_Code", false);
}
private void InitControls()
{
InitControlUtil.SetPOPDGVDesign(dgvPalletList);
InitControlUtil.AddNewColumnToDataGridView(dgvPalletList, "작업지시번호", "WorkOrderNo", false);
InitControlUtil.AddNewColumnToDataGridView(dgvPalletList, "팔레트번호", "Pallet_No", true, 100, DataGridViewContentAlignment.MiddleLeft, true);
InitControlUtil.AddNewColumnToDataGridView(dgvPalletList, "제품", "Item_Name", true, 200);
InitControlUtil.AddNewColumnToDataGridView(dgvPalletList, "등급", "Boxing_Grade_Code", true, 200, DataGridViewContentAlignment.MiddleCenter);
InitControlUtil.AddNewColumnToDataGridView(dgvPalletList, "수량", "CurrentQty", true, 100, DataGridViewContentAlignment.MiddleRight);
InitControlUtil.AddNewColumnToDataGridView(dgvPalletList, "등급상세", "Grade_Detail_Code", false);
InitControlUtil.AddNewColumnToDataGridView(dgvPalletList, "사이즈", "Size_Code", false);
InitControlUtil.AddNewColumnToDataGridView(dgvPalletList, "등급상세명", "Grade_Detail_Name", false);
dtpTodate.Value = DateTime.Now;
dtpFromdate.Value = DateTime.Now.AddDays(-7);
}
private void MainDataLoad()
{
InitControlUtil.SetDGVDesign(dgvMainGrid);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "공정명", "Process_Name", true, 100, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "작업장명", "Wc_Name", true, 110, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "품목명", "Item_Name", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "전월목표량", "laPlan_Oty", true, 95, DataGridViewContentAlignment.MiddleRight);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "전월생산량", "laPrd_Qty", true, 95, DataGridViewContentAlignment.MiddleRight);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "전월생산시간(h)", "laPrd_Time", true, 120, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "전월달성률", "laAttain", true, 95, DataGridViewContentAlignment.MiddleRight);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "당월목표량", "Plan_Oty", true, 95, DataGridViewContentAlignment.MiddleRight);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "당월생산량", "Prd_Qty", true, 95, DataGridViewContentAlignment.MiddleRight);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "당월생산시간(h)", "Prd_Time", true, 120, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "당월달성률", "Attain", true, 95, DataGridViewContentAlignment.MiddleRight);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "전월대비증감량", "Inde", true, 90, DataGridViewContentAlignment.MiddleRight);
}
private void SubDataLoad()
{
InitControlUtil.SetDGVDesign(dgvSubGrid);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvSubGrid, "No.", "Req_Seq", true, 60, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvSubGrid, "생산의뢰번호", "Wo_Req_No", true, 120, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvSubGrid, "작업지시상태", "Wo_Status", true, 120, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvSubGrid, "작업지시번호", "Workorderno", true, 110, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvSubGrid, "작업지시일자", "Prd_Date", true, 110, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvSubGrid, "품목코드", "Item_Code", true, 110, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvSubGrid, "품목명", "Item_Name", true, 120, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvSubGrid, "작업장명", "Wc_Name", true, 120, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvSubGrid, "계획수량", "Plan_Qty", true, 60, DataGridViewContentAlignment.MiddleRight);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvSubGrid, "투입수량", "In_Qty_Main", true, 60, DataGridViewContentAlignment.MiddleRight);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvSubGrid, "산출수량", "Out_Qty_Main", true, 60, DataGridViewContentAlignment.MiddleRight);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvSubGrid, "생산수량", "Prd_Qty", true, 60, DataGridViewContentAlignment.MiddleRight);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvSubGrid, "비고", "Remark", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
}
}//새로고침버튼클릭
/// <summary>
/// 데이터 그리드뷰 바인딩
/// </summary>
private void MainGridLoad()
{
InitControlUtil.SetDGVDesign(dgvMainGrid);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "작업지시번호", "Workorderno", true, 110, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "품목코드", "Item_Code", true, 85, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "품목명", "Item_Name", true, 85, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "생산일자", "Prd_Date", true, 95, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "작업장코드", "Wc_Code", true, 95, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "작업장이름", "Wc_Name", true, 95, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "금형코드", "Mold_Code", true, 100, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "금형명", "Mold_Name", true, 90, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "금형타수", "Mold_Shot_Cnt", true, 80, DataGridViewContentAlignment.MiddleRight);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "금형생산량", "Mold_Prd_Qty", true, 90, DataGridViewContentAlignment.MiddleRight);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "금형사용시작시간", "Use_Starttime", true, 145, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "금형사용종료시간", "Use_Endtime", true, 145, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "금형사용시간", "Use_time", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
}
}//추가버튼클릭
/// <summary>
/// 데이터 그리드뷰 바인딩
/// </summary>
private void MainDataLoad()
{
InitControlUtil.SetDGVDesign(dgvMainGrid);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "금형코드", "Mold_Code", true, 100, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "금형명", "Mold_Name", true, 110, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "금형그룹", "Mold_Group", true, 90, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "금형상태", "Mold_Status", true, 80, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "금형누적타수", "Cum_Shot_Cnt", true, 105, DataGridViewContentAlignment.MiddleRight);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "금형누적생산량", "Cum_Prd_Qty", true, 120, DataGridViewContentAlignment.MiddleRight);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "금형누적사용시간", "Cum_Time", true, 130, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "보장타수", "Guar_Shot_Cnt", true, 90, DataGridViewContentAlignment.MiddleRight);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "구입금액", "Purchase_Amt", true, 90, DataGridViewContentAlignment.MiddleRight);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "입고일자", "In_Date", true, 100, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "최종장착일시", "Last_Setup_Time", true, 140, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "사용여부", "Use_YN", true, 60, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "비고", "Remark", true, 140, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "비고", "Wc_Code", false, 160);
}
private void InitControls()
{
lblInspectcode.Text = lblItemCode.Text = lblProcesscode.Text = "";
//lblInspectcode.Visible = lblItemCode.Visible = lblProcesscode.Visible = false;
InitControlUtil.SetPOPDGVDesign(dgvInspect);
InitControlUtil.AddNewColumnToDataGridView(dgvInspect, "측정항목", "Inspect_name", true, 100, DataGridViewContentAlignment.MiddleLeft, true);
InitControlUtil.AddNewColumnToDataGridView(dgvInspect, "USL", "USL", true, 140, DataGridViewContentAlignment.MiddleRight);
InitControlUtil.AddNewColumnToDataGridView(dgvInspect, "SL", "SL", true, 140, DataGridViewContentAlignment.MiddleRight);
InitControlUtil.AddNewColumnToDataGridView(dgvInspect, "LSL", "LSL", true, 140, DataGridViewContentAlignment.MiddleRight);
InitControlUtil.AddNewColumnToDataGridView(dgvInspect, "품목코드", "Item_Code", false, 100);
InitControlUtil.AddNewColumnToDataGridView(dgvInspect, "공정코드", "Process_code", false, 100);
InitControlUtil.AddNewColumnToDataGridView(dgvInspect, "항목코드", "Inspect_code", false, 100);
InitControlUtil.SetPOPDGVDesign(dgvInspectMeasure);
InitControlUtil.AddNewColumnToDataGridView(dgvInspectMeasure, "측정값", "Inspect_val", true, 120, DataGridViewContentAlignment.MiddleLeft, true);
InitControlUtil.AddNewColumnToDataGridView(dgvInspectMeasure, "측정일시", "Inspect_datetime", true, 200);
InitControlUtil.AddNewColumnToDataGridView(dgvInspectMeasure, "조건순번", "Inspect_measure_seq", false, 200);
dgvInspectMeasure.Columns[1].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss";
}
private void InitControls()
{
lblConditionCode.Text = lblItemCode.Text = lblWcCode.Text = "";
lblConditionCode.Visible = lblItemCode.Visible = lblWcCode.Visible = false;
InitControlUtil.SetPOPDGVDesign(dgvConditionList);
InitControlUtil.AddNewColumnToDataGridView(dgvConditionList, "측정항목", "Condition_Name", true, 100, DataGridViewContentAlignment.MiddleLeft, true);
InitControlUtil.AddNewColumnToDataGridView(dgvConditionList, "USL", "USL", true, 140, DataGridViewContentAlignment.MiddleRight);
InitControlUtil.AddNewColumnToDataGridView(dgvConditionList, "SL", "SL", true, 140, DataGridViewContentAlignment.MiddleRight);
InitControlUtil.AddNewColumnToDataGridView(dgvConditionList, "LSL", "LSL", true, 140, DataGridViewContentAlignment.MiddleRight);
InitControlUtil.AddNewColumnToDataGridView(dgvConditionList, "품목코드", "Item_Code", false, 100);
InitControlUtil.AddNewColumnToDataGridView(dgvConditionList, "코드", "Condition_Code", false, 100);
InitControlUtil.AddNewColumnToDataGridView(dgvConditionList, "작업장코드", "Wc_Code", false, 100);
InitControlUtil.SetPOPDGVDesign(dgvConditionMeasureList);
InitControlUtil.AddNewColumnToDataGridView(dgvConditionMeasureList, "그룹", "Condition_Name", true, 80);
InitControlUtil.AddNewColumnToDataGridView(dgvConditionMeasureList, "측정값", "Condition_Val", true, 120, DataGridViewContentAlignment.MiddleLeft, true);
InitControlUtil.AddNewColumnToDataGridView(dgvConditionMeasureList, "측정일시", "Condition_Datetime", true, 200);
InitControlUtil.AddNewColumnToDataGridView(dgvConditionMeasureList, "조건순번", "Condition_measure_seq", false, 200);
dgvConditionMeasureList.Columns[2].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss";
}
private void MainDataLoad()
{
InitControlUtil.SetDGVDesign(dgvMainGrid);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "No.", "Req_Seq", true, 60, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "생산의뢰번호", "Wo_Req_No", true, 110, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "의뢰일자", "Ins_Date", true, 110, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "품목코드", "Item_Code", true, 100, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "품목명", "Item_Name", true, 80, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "의뢰수량", "Req_Qty", true, 90, DataGridViewContentAlignment.MiddleRight);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "프로젝트명", "Project_Name", true, 110, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "거래처명", "Cust_Name", true, 90, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "영업담당", "Sale_Emp", true, 90, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "생산의뢰상태", "Req_Status", true, 110, DataGridViewContentAlignment.MiddleCenter);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "생산완료예정일", "Prd_Plan_Date", true, 90, DataGridViewContentAlignment.MiddleCenter, true);
DataGridViewCheckBoxColumn chk = new DataGridViewCheckBoxColumn();
chk.HeaderText = "선택";
chk.Name = "check";
chk.TrueValue = true;
chk.FalseValue = false;
chk.Width = 50;
dgvMainGrid.Columns.Insert(0, chk);
}
private void GridForm_Load(object sender, EventArgs e)
{
InitControlUtil.SetDGVDesign(dgvMainGrid);
}
private void MainDataLoad()
{
InitControlUtil.SetDGVDesign(dgvMainGrid);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "생산일자", "Prd_Date", true, 100);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "공정명", "Process_Name", true, 110, default, true);
