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