private void btnInsertMeasure_Click(object sender, EventArgs e)
{
if (!GlobalUsage.WorkOrderNo.Equals("설정안됨"))
{
if (!string.IsNullOrEmpty(lblInspectcode.Text))
{
Inspect_Measure_HistoryService service = new Inspect_Measure_HistoryService();
InspectHistoryVO item = new InspectHistoryVO();
item.Inspect_code = lblInspectcode.Text;
item.Item_code = lblItemCode.Text;
item.Inspect_val = Convert.ToDecimal(nudMeasure.Value);
item.Process_code = lblProcesscode.Text;
item.Workorderno = GlobalUsage.WorkOrderNo;
if (service.InsertInspect_Measure(item, GlobalUsage.UserID))
{
Program.Log.WriteInfo($"{GlobalUsage.UserID}이(가) 품질측정 조건({lblInspectcode.Text})에 값({nudMeasure.Value})를 넣는데에 성공하였음");
nudMeasure.Value = 0;
SearchData();
}
else
{
Program.Log.WriteInfo($"{GlobalUsage.UserID}이(가) 품질측정 조건({lblInspectcode.Text})에 값({nudMeasure.Value})를 넣는데에 실패하였음");
MessageBox.Show("입력할 수 없는 항목입니다.");
}
}
}
else
{
Program.Log.WriteInfo($"{GlobalUsage.UserID}이(가) 작업시작을 하지않고 품질측정값을 등록하려하였음");
MessageBox.Show("작업을 시작해주세요");
}
}
private void ReportBinding()
{
string date = dtpDate.Value.ToString("yyyy-MM-dd");
dryList = service.GetDryingHistory(date);
List <string> workno = new List <string>();
foreach (var item in dryList)
{
workno.Add(item.Workorderno);
}
Inspect_Measure_HistoryService inservice = new Inspect_Measure_HistoryService();
imhList = inservice.GetDrying(workno);
var figurationList = (from req in dryList
join val in imhList on req.Workorderno equals val.Workorderno
where req.Workorderno == val.Workorderno
select new
{
Num = req.Num,
GV_Code = req.GV_Code,
Item_Name = req.Item_Name,
Prd_Endtime = req.Prd_Endtime,
Workorderno = val.Workorderno,
ADate = val.Adate,
AVal = val.Aval,
BDate = val.Bdate,
BVal = val.Bval,
CDate = val.Cdate,
CVal = val.Cval
}).ToList();
try
{
ds.Relations.Clear();
ds.Tables.Clear();
dt = ListToDataTable.ToDataTable(figurationList);
ds.Tables.Add(dt);
ds.Tables[0].TableName = "dtDrying";
rpt.DataSource = ds.Tables["dtDrying"];
}
catch
{
}
rpt.Parameters["Ins_Date"].Value = dtpDate.Value.ToString("yyyy-MM-dd");
rpt.Parameters["Ins_Date"].Visible = false; //파라미터 바로 넘기기
documentViewer1.DocumentSource = rpt;
rpt.CreateDocument();
}
private void btnDeleteMeasure_Click(object sender, EventArgs e)
{
if (dgvInspectMeasure.SelectedRows.Count > 0)
{
Inspect_Measure_HistoryService service = new Inspect_Measure_HistoryService();
if (service.DeleteInspect_MeasureBySeq(Convert.ToInt32(dgvInspectMeasure.SelectedRows[0].Cells[2].Value)))
{
Program.Log.WriteInfo($"{GlobalUsage.UserID}이(가) 품질측정 조건({lblInspectcode.Text})의 값({nudMeasure.Value})을 삭제하는데 성공하였음");
SearchData();
}
else
{
Program.Log.WriteInfo($"{GlobalUsage.UserID}이(가) 품질측정 조건({lblInspectcode.Text})의 값({nudMeasure.Value})을 삭제하는데 실패하였음");
MessageBox.Show("입력할 수 없는 항목입니다.");
}
}
}
private void SearchData()
{
Inspect_Measure_HistoryService mservice = new Inspect_Measure_HistoryService();
dgvInspectMeasure.DataSource = mservice.GetAll(lblItemCode.Text, lblProcesscode.Text, lblInspectcode.Text, GlobalUsage.WorkOrderNo);
}
