private void ViewFaultyImage_Load(object sender, EventArgs e) { MES_DB.PerformService service = new MES_DB.PerformService(); List <RegFaultyVO> list = service.GetImage(Seq); TypeConverter tc = TypeDescriptor.GetConverter(typeof(Bitmap)); picFaulty.Image = (Bitmap)tc.ConvertFrom(list[0].Def_Image); //pictureBox1.Image = Image.FromFile(url+"/"+filename); }
private void btnRemove_Click(object sender, EventArgs e) { if (check != null && check != "") { MES_DB.PerformService service = new MES_DB.PerformService(); service.DeleteRegProcess(primary); MessageBox.Show("삭제되었습니다."); dgvJob.DataSource = null; dgvList.DataSource = null; dgvListDetail.DataSource = null; ShowDgv(); } else { MessageBox.Show("삭제할 셀을 선택해주세요."); } }
private void GetDate(object sender, EventArgs e) { MES_DB.PerformService service = new MES_DB.PerformService(); Alllist = service.GetAllWorkCenter(); List <WorkCenterVO> RunList = (from item in Alllist where item.Wo_Status == "RUN" select item).ToList(); dgvRun.DataSource = RunList; List <WorkCenterVO> NoRunList = (from norun in Alllist where norun.Wo_Status == "STOP" select norun).ToList(); dgvNoRun.DataSource = NoRunList; }
private void btnEdit_Click(object sender, EventArgs e) { //수정하기 bool Check = false; MES_DB.PerformService service = new MES_DB.PerformService(); if (cmbSelect.SelectedItem.ToString() == "투입수량") { Edit.In_Qty_Main = Convert.ToInt32(nuCount.Value); service.EditPerformSearch(Edit); Check = true; } else if (cmbSelect.SelectedItem.ToString() == "불량") { Edit.Bad_Qty = Convert.ToInt32(nuCount.Value); service.EditPerformSearch(Edit); Check = true; } else if (cmbSelect.SelectedItem.ToString() == "생산수량") { Edit.Prd_Qty = Convert.ToInt32(nuCount.Value); service.EditPerformSearch(Edit); Check = true; } else { MessageBox.Show("항목을 선택해주세요."); } if (Check == true) { MessageBox.Show("수정되었습니다."); this.Close(); } else { MessageBox.Show("값을 선택해주세요."); } }
private void btnRemove_Click(object sender, EventArgs e) { if (MessageBox.Show("삭제하시겠습니까?", "삭제", MessageBoxButtons.YesNo) == DialogResult.Yes) { MES_DB.PerformService service = new MES_DB.PerformService(); service.DeleteRegUqlityForm(primary); MessageBox.Show("삭제되었습니다."); dgvJob.DataSource = null; dgvDetail.DataSource = null; dgvDetaillist.DataSource = null; if (dgvJob.Columns.Count < 1 && dgvDetail.Columns.Count < 1 && dgvDetaillist.Columns.Count < 1) { ShowDgv(); } } else { MessageBox.Show("취소되었습니다."); } }
private void btnFaltyIns_Click(object sender, EventArgs e) { //DB 입력부분 MES_DB.PerformService service = new MES_DB.PerformService(); ImageConverter converter = new ImageConverter(); byte[] imagebyte = (byte[])converter.ConvertTo(pic.Image, typeof(byte[])); if (MessageBox.Show("수정하시겠습니까?", "", MessageBoxButtons.YesNo) == DialogResult.Yes) { service.InsFaltyImage(fileName, imagebyte, WorkOrder, Convert.ToInt32(nuFaultyCount.Value)); dgvJobOrder.DataSource = null; GetData(); frm.btnS.PerformClick(); } else { MessageBox.Show("취소되었습니다."); } }
private void btnAdd_Click(object sender, EventArgs e) { if (MessageBox.Show("수정하시겠습니까?", "", MessageBoxButtons.YesNo) == DialogResult.Yes) { if (nuNum.Value > 0) { MES_DB.PerformService service = new MES_DB.PerformService(); service.UpdateRegQulityForm(Convert.ToInt32(nuNum.Value), primary); dgvJob.DataSource = null; dgvDetail.DataSource = null; dgvDetaillist.DataSource = null; if (dgvJob.Columns.Count < 1 && dgvDetail.Columns.Count < 1 && dgvDetaillist.Columns.Count < 1) { ShowDgv(); } MessageBox.Show("수정되었습니다."); } else { MessageBox.Show("수정할 측정값을 입력해주세요."); } } else { MessageBox.Show("취소되었습니다."); } //QulityRegisterForm frm = new QulityRegisterForm(InsVO); //if (frm.ShowDialog() == DialogResult.OK) //{ // dgvJob.DataSource = null; // dgvDetail.DataSource = null; // dgvDetaillist.DataSource = null; // if (dgvJob.Columns.Count < 1 && dgvDetail.Columns.Count < 1 && dgvDetaillist.Columns.Count < 1) // { // ShowDgv(); // } //} }
private void GetData(object sender, EventArgs e) { MES_DB.PerformService service = new MES_DB.PerformService(); allList = service.GetAllRegProcess(); List <SubRegProcessVO> AList = (from aa in allList select new SubRegProcessVO { Workorderno = aa.Workorderno, Wc_Name = aa.Wc_Name, Process_name = aa.Process_name, Condition_measure_seq = aa.Condition_measure_seq }).ToList(); List <SubRegProcessVO> RList = new List <SubRegProcessVO>(); List <SubRegProcessVO> QList = new List <SubRegProcessVO>(); SubRegProcessVO subvo = new SubRegProcessVO(); foreach (var it in AList) { if (it.Process_name == subvo.Process_name) { continue; } else { subvo = it; RList.Add(it); } } dgvJob.DataSource = RList; }
private void GetData(object sender, EventArgs e) { MES_DB.PerformService service = new MES_DB.PerformService(); allList = service.GetAllPerformSearch(); dgvSearchResult.DataSource = allList; }
private void GetData(object sender, EventArgs e) { MES_DB.PerformService service = new MES_DB.PerformService(); allList = service.GetAllQuality(); dgvJob.DataSource = allList; }
private void GetData(object sender, EventArgs e) { MES_DB.PerformService service = new MES_DB.PerformService(); allList = service.GetAllRegFaultyImage(); dgvProductRequset.DataSource = allList; }