private void btnSave_Click(object sender, EventArgs e)
{
if (aTextBox1.Text.Length > 0 && aTextBox2.Text.Length > 0 && placeHolderTextBox1.Text.Length > 0)
{
NopHistoryVO nop = new NopHistoryVO();
nop.Wc_Code = aComboBox1.SelectedValue.ToString();
nop.Nop_Mi_Code = aComboBox2.SelectedValue.ToString();
nop.Nop_Type = placeHolderTextBox1.Text;
nop.Nop_Time = nudusl.Value;
nop.Remark = txtRemark.Text;
nop.Ins_Emp = lblManager.Text;
string msg = Nop_HistoryService.InsertNop_History(nop);
if (msg == "OK")
{
MessageBox.Show("성공적으로 등록하였습니다.", "비동기 성공", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
this.Close();
}
else
{
MessageBox.Show($"{msg}", "비동기 오류", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.Close();
}
}
else
{
MessageBox.Show("모두 입력해주세요");
}
}
public string InsertNop_History(NopHistoryVO nop)
{
using (SqlConnection conn = new SqlConnection(Connstr))
{
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
string chksql = "INSERT INTO Nop_History(Wc_Code, Nop_Mi_Code, Nop_Type, Nop_Time, Remark, Ins_Emp) values(@Wc_Code, @Nop_Mi_Code, @Nop_Type, @Nop_Time, @Remark, @Ins_Emp)";
using (SqlCommand cmdchk = new SqlCommand(chksql, conn))
{
cmdchk.Transaction = tran;
cmdchk.Parameters.AddWithValue("@Wc_Code", nop.Wc_Code);
cmdchk.Parameters.AddWithValue("@Nop_Mi_Code", nop.Nop_Mi_Code);
cmdchk.Parameters.AddWithValue("@Nop_Type", nop.Nop_Type);
cmdchk.Parameters.AddWithValue("@Nop_Time", nop.Nop_Time);
cmdchk.Parameters.AddWithValue("@Remark", nop.Remark);
cmdchk.Parameters.AddWithValue("@Ins_Emp", nop.Ins_Emp);
int iResult = Convert.ToInt32(cmdchk.ExecuteScalar());
if (iResult > 0)
{
throw new Exception("비가동 등록 중 오류가 발생했습니다.");
}
cmdchk.Parameters.Clear();
}
//-------------------------------------------------------------
string Stsql = @"UPDATE WorkCenter_Master SET Use_YN = 'N' Where Wc_Code=@Wc_Code";
using (SqlCommand cmd = new SqlCommand(Stsql, conn))
{
cmd.Transaction = tran;
cmd.Parameters.AddWithValue("@Wc_Code", nop.Wc_Code);
int iResult = cmd.ExecuteNonQuery();
if (iResult < 1)
{
throw new Exception("비가동 등록 중 오류가 발생했습니다.");
}
cmd.Parameters.Clear();
tran.Commit();
return("OK");
}
}
catch (Exception err)
{
tran.Rollback();
return(err.Message);
}
finally
{
conn.Close();
}
}
}
public string InsertNop_History(NopHistoryVO nop) //PRM_PRF_008_1
{
Nop_HistoryDAC dac = new Nop_HistoryDAC();
return(dac.InsertNop_History(nop));
}
