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;
}
