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("작업을 시작해주세요");
}
}
/// <summary>
/// 품질측정값 등록
/// </summary>
/// <param name="item">Inspect_measure_seq를 제외하고 채워야함</param>
public bool InsertInspect_Measure(InspectHistoryVO item, string userid)
{
using (SqlCommand comm = new SqlCommand())
{
comm.Connection = new SqlConnection(Connstr);
comm.CommandText =
@" INSERT INTO Inspect_Measure_History(
Item_code, Process_code, Inspect_code, Inspect_date, Inspect_datetime
, Inspect_val, Workorderno, Ins_Date , Ins_Emp, Up_Date, Up_Emp)
VALUES(
@Item_code,
@Process_code,
@Inspect_code,
getdate() ,
getdate(),
@Inspect_val,
@Workorderno,
getdate(),
@Ins_Emp,
getdate() ,
@Up_Emp); ";
comm.CommandType = CommandType.Text;
comm.Parameters.AddWithValue("@Item_code", item.Item_code);
comm.Parameters.AddWithValue("@Process_code", item.Process_code);
comm.Parameters.AddWithValue("@Inspect_code", item.Inspect_code);
comm.Parameters.AddWithValue("@Inspect_val", item.Inspect_val);
comm.Parameters.AddWithValue("@Workorderno", item.Workorderno);
comm.Parameters.AddWithValue("@Ins_Emp", userid);
comm.Parameters.AddWithValue("@Up_Emp", userid);
comm.Connection.Open();
int result = comm.ExecuteNonQuery();
comm.Connection.Close();
return(result > 0);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (MessageBox.Show("추가하시겠습니까?", "추가여부", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
InspectHistoryVO item = new InspectHistoryVO();
item.Item_code = Item_code;
item.Process_code = Process_code;
item.Inspect_code = Inspect_code;
item.Inspect_val = nudusl.Value;
item.Workorderno = Workorderno;
bool IsSuccess = ihService.InsertInspect_Measure(item, lblManager.Text); //품질측정 추가 조회
if (IsSuccess)
{
MessageBox.Show("성공적으로 추가하였습니다.", "추가성공", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("추가에 실패하였습니다.", "추가오류", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
/// <summary>
/// 품질측정값 등록
/// </summary>
/// <param name="item">Inspect_measure_seq를 제외하고 채워야함</param>
public bool InsertInspect_Measure(InspectHistoryVO item, string userid)
{
Inspect_Measure_HistoryDAC dac = new Inspect_Measure_HistoryDAC();
return(dac.InsertInspect_Measure(item, userid));
}
