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