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 MSS_SYS_004_Load(object sender, EventArgs e)
{
dtpEnd.MaxDate = DateTime.Now;
userlist = new List <UserInfoVO>();
userlist = userservice.GetAllUser();
screenitemlist = new List <ScreenItem_MasterVO>();
screenitemlist = screenservice.GetALLScreenItem(); //모든스크린
UserInfoVO ufirst = new UserInfoVO();
userlist.Insert(0, ufirst);
cbbUser.DisplayMember = "User_Name";
cbbUser.ValueMember = "User_ID";
cbbUser.DataSource = userlist;
ScreenItem_MasterVO sfirst = new ScreenItem_MasterVO();
screenitemlist.Insert(0, sfirst);
cbbScreen.DisplayMember = "Type";
cbbScreen.ValueMember = "Screen_Code";
cbbScreen.DataSource = screenitemlist;
DatagridviewDesigns.SetDesign(dgvGroup);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvGroup, "이름", "User_Name", true, 210, default, true);
public void RefreshFormShow(object sender, EventArgs e) // 새로고침 // 초기화
{
try
{
if (this == ((MainForm)this.MdiParent).ActiveMdiChild)
{
aDateTimePickerSearch1.ADateTimePickerValue1 = Convert.ToDateTime(DateTime.Now.AddDays(-7).ToShortDateString());
aDateTimePickerSearch1.ADateTimePickerValue2 = Convert.ToDateTime(DateTime.Now.ToShortDateString());
DataLoad();
dgvSubGrid.DataSource = null;
if (dgvSubGrid.Columns.Count == 0)
{
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvSubGrid, "팔렛트번호", "Pallet_No", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvSubGrid, "등급", "Grade_Code", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvSubGrid, "등급상세 코드", "Grade_Detail_Code", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvSubGrid, "등급상세명", "Grade_Detail_Name", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvSubGrid, "수량", "In_Qty", true, 100, DataGridViewContentAlignment.MiddleRight, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvSubGrid, "팔렛트 마감 여부", "Use_YN", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
}
}
}
catch (Exception err)
{
Program.Log.WriteError(err.Message);
}
}
private void PRM_PRF_005_Load(object sender, EventArgs e)
{
((MainForm)this.MdiParent).RefreshFormEvent += new System.EventHandler(this.RefreshFormShow); // 새로고침
DatagridviewDesigns.SetDesign(dgvMainGrid);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "대차코드", "GV_Code", true, 100, DataGridViewContentAlignment.MiddleCenter, false);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "대차명", "GV_Name", true, 100, DataGridViewContentAlignment.MiddleCenter, false);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "대차그룹명", "GV_Group", true, 100, DataGridViewContentAlignment.MiddleCenter, false);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "작업지시번호", "Workorderno", true, 120, DataGridViewContentAlignment.MiddleCenter, false);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "품목코드", "Item_Code", true, 100, DataGridViewContentAlignment.MiddleCenter, false);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "품목명", "Item_Name", true, 150, DataGridViewContentAlignment.MiddleCenter, false);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "대차상태", "GV_Status", true, 100, DataGridViewContentAlignment.MiddleCenter, false);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "대차수량", "GV_Qty", true, 100, DataGridViewContentAlignment.MiddleRight, false);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "로딩일자", "Loading_date", true, 100, DataGridViewContentAlignment.MiddleCenter, false);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "로딩시간", "Loading_time", true, 150, DataGridViewContentAlignment.MiddleCenter, false);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "로딩작업장", "Loading_Wc", true, 120, DataGridViewContentAlignment.MiddleCenter, false);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "언로딩일자", "Unloading_date", true, 120, DataGridViewContentAlignment.MiddleCenter, false);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "언로딩시간", "Unloading_time", true, 120, DataGridViewContentAlignment.MiddleCenter, false);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "언로딩작업장", "Unloading_Wc", true, 150, DataGridViewContentAlignment.MiddleCenter, false);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "요입시간", "In_Time", true, 150, DataGridViewContentAlignment.MiddleCenter, false);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "중간시간", "Center_Time", true, 150, DataGridViewContentAlignment.MiddleCenter, false);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "요출시간", "Out_Time", true, 150, DataGridViewContentAlignment.MiddleCenter, false);
gvwi = gvwiservice.GetAllGV_Work_Item();
dgvMainGrid.DataSource = gvwi;
}
private void MSS_SYS_009_Load(object sender, EventArgs e)
{
dtpstart.MaxDate = DateTime.Now;
DatagridviewDesigns.SetDesign(dgvsys);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvsys, "공지번호", "Req", true, 210, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvsys, "공지시작일자", "Notice_Date", true, 210, default, true);
private void QAM_SQC_004_Load(object sender, EventArgs e)
{
((MainForm)this.MdiParent).RefreshFormEvent += new System.EventHandler(this.RefreshFormShow); // 새로고침
#region 그리드뷰
DatagridviewDesigns.SetDesign(dgvMainGrid);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "작업지시번호", "Workorderno", true, 150, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "생산일", "Prd_Date", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "공정", "Process_name", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "작업장", "Wc_Name", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "품목코드", "Item_Code", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "품목명", "Item_Name", true, 150, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "측정항목", "Inspect_name", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "USL", "USL", true, 100, DataGridViewContentAlignment.MiddleRight, true);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "SL", "SL", true, 100, DataGridViewContentAlignment.MiddleRight, true);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "LSL", "LSL", true, 100, DataGridViewContentAlignment.MiddleRight, true);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "측정일시", "Inspect_datetime", true, 150, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "측정회차", "Inspect_date", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "측정순번", "Inspect_measure_seq", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "측정값", "Inspect_val", true, 100, DataGridViewContentAlignment.MiddleRight, true);
#endregion
lhm = lhmservice.GetAllInspectMeasure_History_Master(); //전체 조회
dgvMainGrid.DataSource = lhm;
}
private void PRM_PRF_008_Load(object sender, EventArgs e)
{
((MainForm)this.MdiParent).RefreshFormEvent += new System.EventHandler(this.RefreshFormShow); // 새로고침
((MainForm)this.MdiParent).InsertFormEvent += new System.EventHandler(this.InsertFormShow); // 추가
((MainForm)this.MdiParent).MyUpdateEvent += new System.EventHandler(this.UpdateFormShow); // 수정
dgvMainGrid.CellDoubleClick += DgvMainGrid_CellDoubleClick; //메인그리드뷰 더블클릭
#region 그리드뷰
DatagridviewDesigns.SetDesign(dgvMainGrid);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "발생순번", "Nop_Seq", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "비가동일자", "Nop_Date", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "작업장코드", "Wc_Code", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "작업장명", "Wc_Name", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "비가동대분류", "Nop_Ma_Name", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "비가동상세분류", "Nop_Mi_Name", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "비가동발생시각", "Nop_Happentime", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "비가동종료시각", "Nop_Canceltime", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "비가동시간", "Nop_Time", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "비고", "Remark", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "발생유형", "Nop_Type", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
#endregion
nohm = nohmservice.GetAllNop_History_Mi_Ma();
dgvMainGrid.DataSource = nohm;
}
private void MSS_CON_003_Load(object sender, EventArgs e)
{
((MainForm)this.MdiParent).InsertFormEvent += new System.EventHandler(this.InsertFormShow);//입력이벤트 등록
((MainForm)this.MdiParent).RefreshFormEvent += new EventHandler(this.RefreshFormShow);
((MainForm)this.MdiParent).MyDeleteEvent += new EventHandler(this.MyDelete);
DatagridviewDesigns.SetDesign(dgvUser);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvUser, "아이디", "User_ID", true, 200, default, true);
private void MDS_SDS_007_Load(object sender, EventArgs e)
{
((MainForm)this.MdiParent).MyUpdateEvent += new System.EventHandler(this.MyUpdateShow); //입력이벤트 등록
((MainForm)this.MdiParent).InsertFormEvent += new System.EventHandler(this.InsertFormShow); //입력이벤트 등록
((MainForm)this.MdiParent).RefreshFormEvent += new EventHandler(this.RefreshFormShow);
((MainForm)this.MdiParent).MyDeleteEvent += new EventHandler(this.MyDelete);
DatagridviewDesigns.SetDesign(dgvItem);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvItem, "품목코드", "Item_Code", true, 210, default, true);
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 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 MDS_ODS_001_Load(object sender, EventArgs e)
{
aPanel3.Enabled = false;
((MainForm)this.MdiParent).MyUpdateEvent += new System.EventHandler(this.MyUpdateShow); //입력이벤트 등록
((MainForm)this.MdiParent).InsertFormEvent += new System.EventHandler(this.InsertFormShow); //입력이벤트 등록
((MainForm)this.MdiParent).RefreshFormEvent += new EventHandler(this.RefreshFormShow);
((MainForm)this.MdiParent).MyDeleteEvent += new EventHandler(this.MyDelete);
///gridview
DatagridviewDesigns.SetDesign(dgvProcess);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvProcess, "공정코드", "Process_code", true, 210, default, true);
private void MDS_ODS_002_Load(object sender, EventArgs e)
{
aBigTextBox_FindNameByCode1.Enabled = false;
((MainForm)this.MdiParent).MyUpdateEvent += new System.EventHandler(this.MyUpdateShow); //입력이벤트 등록
((MainForm)this.MdiParent).InsertFormEvent += new System.EventHandler(this.InsertFormShow); //입력이벤트 등록
((MainForm)this.MdiParent).RefreshFormEvent += new EventHandler(this.RefreshFormShow); // 수정
((MainForm)this.MdiParent).MyDeleteEvent += new EventHandler(this.MyDelete);
///gridview
DatagridviewDesigns.SetDesign(dgvWork);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvWork, "작업장코드", "Wc_Code", true, 210, default, true);
private void MDS_SDS_001_Load(object sender, EventArgs e)
{
panelsetting.Enabled = false;
((MainForm)this.MdiParent).MyUpdateEvent += new System.EventHandler(this.MyUpdateShow); //입력이벤트 등록
((MainForm)this.MdiParent).InsertFormEvent += new System.EventHandler(this.InsertFormShow); //입력이벤트 등록
((MainForm)this.MdiParent).RefreshFormEvent += new EventHandler(this.RefreshFormShow);
((MainForm)this.MdiParent).MyDeleteEvent += new EventHandler(this.MyDelete);
DatagridviewDesigns.SetDesign(dgvGroup);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvGroup, "품목그룹코드", "Level_Code", true, 210, default, true);
private void MDS_CDS_001_1_Load(object sender, EventArgs e)
{
panelDefma.Enabled = false;
((MainForm)this.MdiParent).MyUpdateEvent += new System.EventHandler(this.MyUpdateShow); //입력이벤트 등록
((MainForm)this.MdiParent).InsertFormEvent += new System.EventHandler(this.InsertFormShow); //입력이벤트 등록
((MainForm)this.MdiParent).RefreshFormEvent += new EventHandler(this.RefreshFormShow);
((MainForm)this.MdiParent).MyDeleteEvent += new EventHandler(this.MyDelete);
///gridview
DatagridviewDesigns.SetDesign(dgvMainGrid);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "불량현상대분류코드", "Def_Ma_Code", true, 210, default, true);
private void MDS_CDS_007_Load(object sender, EventArgs e)
{
rdbgroup = radioButton1;
panelbox.Enabled = false;
((MainForm)this.MdiParent).MyUpdateEvent += new System.EventHandler(this.MyUpdateShow); //입력이벤트 등록
((MainForm)this.MdiParent).InsertFormEvent += new System.EventHandler(this.InsertFormShow); //입력이벤트 등록
((MainForm)this.MdiParent).RefreshFormEvent += new EventHandler(this.RefreshFormShow);
((MainForm)this.MdiParent).MyDeleteEvent += new EventHandler(this.MyDelete);
///gridview
DatagridviewDesigns.SetDesign(dgvbox);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvbox, "포장등급", "Boxing_Grade_Code", true, 210, default, true);
private void QAM_SQC_003_Load(object sender, EventArgs e)
{
((MainForm)this.MdiParent).RefreshFormEvent += new System.EventHandler(this.RefreshFormShow); // 새로고침
((MainForm)this.MdiParent).InsertFormEvent += new System.EventHandler(this.InsertFormShow); // 추가
((MainForm)this.MdiParent).MyDeleteEvent += new System.EventHandler(this.MyDeleteShow); // 삭제
dgvMainGrid.CellDoubleClick += DgvMainGrid_CellDoubleClick; //메인그리드뷰 더블클릭
dgvSubGrid.CellDoubleClick += DgvSubGrid_CellDoubleClick; //서브그리드뷰 더블클릭
dgvSubSubGrid.CellDoubleClick += DgvSubSubGrid_CellDoubleClick; //서브서브그리드뷰 더블클릭
#region 메인그리드뷰
DatagridviewDesigns.SetDesign(dgvMainGrid);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "조건순번", "Condition_measure_seq", true, 100, default, false);
private void PRM_PRF_010_Load(object sender, EventArgs e)
{
((MainForm)this.MdiParent).RefreshFormEvent += new System.EventHandler(this.RefreshFormShow); // 새로고침
dgvMainGrid.CellDoubleClick += DgvMainGrid_CellDoubleClick; //메인그리드뷰 더블클릭
try
{
#region 메인그리드뷰
DatagridviewDesigns.SetDesign(dgvMainGrid);
dgvMainGrid.AutoGenerateColumns = true;
dgvMainGrid.AllowUserToAddRows = false;
dgvMainGrid.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "사용자ID", "User_ID", true, 100, default, false);
private void PRM_PRF_004_Load(object sender, EventArgs e)
{
((MainForm)this.MdiParent).RefreshFormEvent += new System.EventHandler(this.RefreshFormShow); // 새로고침
DatagridviewDesigns.SetDesign(dgvMainGrid);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "이력순번", "Seq", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "기준일자", "Std_Date", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "작업코드", "Wc_Code", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "작업장명", "Wc_Name", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "GAS사용량", "Gas_Val", true, 100, DataGridViewContentAlignment.MiddleRight, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "비고", "Remark", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
guho = ghservice.GetAllGasUse_History();
dgvMainGrid.DataSource = guho;
}
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 aDateTimePickerSearch1_btnDateTimeSearch_Click(object sender, EventArgs args) //날짜별로 조회
{
wowc = woservice.GetDatePicker_WorkOrder_Item_WC(aDateTimePickerSearch1.ADateTimePickerValue1.ToShortDateString(), aDateTimePickerSearch1.ADateTimePickerValue2.ToShortDateString());
dgvMainGrid.DataSource = wowc;
dgvSubGrid.DataSource = null;
if (dgvSubGrid.Columns.Count == 0)
{
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvSubGrid, "팔렛트번호", "Pallet_No", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvSubGrid, "등급", "Grade_Code", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvSubGrid, "등급상세 코드", "Grade_Detail_Code", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvSubGrid, "등급상세명", "Grade_Detail_Name", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvSubGrid, "수량", "In_Qty", true, 100, DataGridViewContentAlignment.MiddleRight, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvSubGrid, "팔렛트 마감 여부", "Use_YN", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
}
}
private void MDS_CDS_002_Load(object sender, EventArgs e)
{
aPanel2.Enabled = false;
aDataGridView1.CellDoubleClick += DgvMainGrid_CellDoubleClick;
aDataGridView2.CellDoubleClick += aDataGridView2_CellDoubleClick;
aDataGridView2.CellContentClick += aDataGridView2_CellContentClick;
((MainForm)this.MdiParent).MyUpdateEvent += new System.EventHandler(this.MyUpdateShow); //입력이벤트 등록
((MainForm)this.MdiParent).InsertFormEvent += new System.EventHandler(this.InsertFormShow); //입력이벤트 등록
((MainForm)this.MdiParent).RefreshFormEvent += new EventHandler(this.RefreshFormShow);
((MainForm)this.MdiParent).MyDeleteEvent += new EventHandler(this.MyDelete);
///gridview
DatagridviewDesigns.SetDesign(aDataGridView1);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(aDataGridView1, "불량현상대분류코드", "Def_Ma_Code", true, 210, default, true);
private void QAM_SQC_006_Load(object sender, EventArgs e)
{
((MainForm)this.MdiParent).RefreshFormEvent += new System.EventHandler(this.RefreshFormShow); // 새로고침
#region 그리드뷰
DatagridviewDesigns.SetDesign(dgvMainGrid);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "생산년도", "YYYY", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "레벨코드", "Level_Code", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "레벨명", "Level_Name", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "차수", "Prd_Order", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "원자재LOT번호", "Mat_LotNo", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
#endregion
mlmilm = mlmilmservice.GetAllMatLotMaster_ItemLevelMaster(); //전체 조회
dgvMainGrid.DataSource = mlmilm;
}
private void MSS_SYS_001_Load(object sender, EventArgs e)
{
ImageList imgList = new ImageList();
//imgList.Images.Add(Bitmap.FromFile("treeimg.png"));
imgList.Images.Add(Properties.Resources.treeimg);
tvMenu.ImageList = imgList;
tvMenu.AllowDrop = true;
treeview();
((MainForm)this.MdiParent).InsertFormEvent += new System.EventHandler(this.InsertFormShow);//입력이벤트 등록
((MainForm)this.MdiParent).RefreshFormEvent += new EventHandler(this.RefreshFormShow);
((MainForm)this.MdiParent).MyDeleteEvent += new EventHandler(this.MyDelete);
DatagridviewDesigns.SetDesign(dgvParent);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvParent, "코드", "Screen_Code", true, 210, default, true);
private void PRM_PRF_009_Load(object sender, EventArgs e)
{
((MainForm)this.MdiParent).RefreshFormEvent += new System.EventHandler(this.RefreshFormShow); // 새로고침
#region 그리드뷰
DatagridviewDesigns.SetDesign(dgvMainGrid);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "근무일", "Work_Date", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "작업장", "Wc_Name", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "작업자", "User_Name", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "근무시작시간", "Work_StartTime", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "근무종료시간", "Work_EndTime", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "근무시간", "Work_Time", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
#endregion
whcu = whcuservice.GetAllWorkHistory_Center_UserMaster(); //전체 조회
dgvMainGrid.DataSource = whcu;
}
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);
}
private void PRM_PRF_003_Load(object sender, EventArgs e)
{
((MainForm)this.MdiParent).RefreshFormEvent += new System.EventHandler(this.RefreshFormShow); // 새로고침
DatagridviewDesigns.SetDesign(dgvMainGrid);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "생산일자", "Prd_Date", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "작업지시번호", "Workorderno", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "작업지시상태", "Wo_Status", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "품목코드", "Item_Code", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "품목명", "Item_Name", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "팔레트번호", "Pallet_No", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "입고수량", "Plan_Qty", true, 100, DataGridViewContentAlignment.MiddleRight, true);
DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "마감시각", "Closed_Time", true, 100, DataGridViewContentAlignment.MiddleCenter, true);
igh = imservice.GetworkOrder_Item_Goods();
dgvMainGrid.DataSource = igh;
}
}//새로고침버튼클릭
/// <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 PRM_PRF_006_Load(object sender, EventArgs e)
{
((MainForm)this.MdiParent).RefreshFormEvent += new System.EventHandler(this.RefreshFormShow); // 새로고침
#region 그리드뷰
DatagridviewDesigns.SetDesign(dgvMainGrid);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "대차코드", "GV_Code", true, 100, DataGridViewContentAlignment.MiddleCenter, false);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "대차명", "GV_Name", true, 100, DataGridViewContentAlignment.MiddleCenter, false);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "작업지시번호", "Workorderno", true, 120, DataGridViewContentAlignment.MiddleCenter, false);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "품목코드", "Item_Code", true, 100, DataGridViewContentAlignment.MiddleCenter, false);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "품목명", "Item_Name", true, 150, DataGridViewContentAlignment.MiddleCenter, false);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "로딩일자", "Loading_Date", true, 100, DataGridViewContentAlignment.MiddleCenter, false);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "로딩수량", "Loading_Qty", true, 100, DataGridViewContentAlignment.MiddleRight, false);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "로딩시간", "Loading_time", true, 150, DataGridViewContentAlignment.MiddleCenter, false);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "로딩작업장", "Loading_Wc", true, 100, DataGridViewContentAlignment.MiddleCenter, false);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "요입시간", "In_Time", true, 150, DataGridViewContentAlignment.MiddleCenter, false);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "중간시간", "Center_Time", true, 150, DataGridViewContentAlignment.MiddleCenter, false);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "요출시간", "Out_Time", true, 150, DataGridViewContentAlignment.MiddleCenter, false);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "언로딩수량", "Unloading_Qty", true, 100, DataGridViewContentAlignment.MiddleRight, false);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "언로딩일자", "Unloading_date", true, 100, DataGridViewContentAlignment.MiddleCenter, false);
DatagridviewDesigns.AddNewColumnToDataGridView(dgvMainGrid, "언로딩일시", "Unloading_datetime", true, 150, default, false);