public bool BORUpdate(BORVO bor) { string sql = @"UPDATE TBL_BOR SET product_id = @product_id, process_name = @process_name, m_id = @m_id, bor_tacttime = @bor_tacttime, bor_yn = @bor_yn, bor_comment = @bor_comment , bor_uadmin = @bor_comment, bor_udate = @bor_udate WHERE bor_id = @bor_id"; using (SqlCommand cmd = new SqlCommand(sql, conn)) { cmd.Parameters.AddWithValue("@bor_id", bor.BOR_id); cmd.Parameters.AddWithValue("@product_id", bor.product_id); cmd.Parameters.AddWithValue("@process_name", bor.process_name); cmd.Parameters.AddWithValue("@m_id", bor.m_id); cmd.Parameters.AddWithValue("@bor_tacttime", bor.bor_tacttime); cmd.Parameters.AddWithValue("@bor_yn", bor.bor_yn); cmd.Parameters.AddWithValue("@bor_comment", bor.bor_comment); cmd.Parameters.AddWithValue("@bor_uadmin", bor.bor_uadmin); cmd.Parameters.AddWithValue("@bor_udate", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); int iRowAffect = cmd.ExecuteNonQuery(); conn.Close(); return(iRowAffect > 0); } }
public bool BORInsert(BORVO bor) { string sql = @"insert into TBL_BOR(product_id, process_name, m_id, bor_tacttime, bor_yn, bor_comment, bor_uadmin, bor_udate) values(@product_id, @process_name, @m_id, @bor_tacttime, @bor_yn, @bor_comment, @bor_uadmin, @bor_udate)"; int iRowAffect = 0; using (SqlCommand cmd = new SqlCommand(sql, conn)) { cmd.Parameters.AddWithValue("@product_id", bor.product_id); cmd.Parameters.AddWithValue("@process_name", bor.process_name); cmd.Parameters.AddWithValue("@m_id", bor.m_id); cmd.Parameters.AddWithValue("@bor_tacttime", bor.bor_tacttime); cmd.Parameters.AddWithValue("@bor_yn", bor.bor_yn); cmd.Parameters.AddWithValue("@bor_comment", bor.bor_comment); cmd.Parameters.AddWithValue("@bor_uadmin", bor.bor_uadmin); cmd.Parameters.AddWithValue("@bor_udate", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); iRowAffect = cmd.ExecuteNonQuery(); Dispose(); } return(iRowAffect > 0); }
public bool BORUpdate(BORVO bor) { BORDAC dac = new BORDAC(); return(dac.BORUpdate(bor)); }
public bool BORInsert(BORVO bor) { BORDAC dac = new BORDAC(); return(dac.BORInsert(bor)); }
private void btnCreate_Click(object sender, EventArgs e) { if (cboProductName.SelectedIndex < 1 || cboMachine.SelectedIndex < 1 || cboProcessName.SelectedIndex < 1 || txtTactTime.Text.Trim().Length < 1 || cboYN.SelectedIndex < 1) { MessageBox.Show("필수항목을 채워주세요"); return; } try { if (headName == "BOR추가") { BORVO bor = new BORVO { product_id = cboProductName.SelectedValue.ToString(), process_name = cboProcessName.Text, m_id = Convert.ToInt32(cboMachine.SelectedValue), bor_tacttime = Convert.ToInt32(txtTactTime.Text), bor_yn = cboYN.Text, bor_comment = txtComment.Text, bor_uadmin = txtUadmin.Text }; BORService service = new BORService(); bool bResult = service.BORInsert(bor); if (bResult) { MessageBox.Show("새로운 BOR를 등록하셨습니다"); } else { MessageBox.Show("등록에 실패하셨습니다"); } } else if (headName == "BOR수정") { BORVO bor = new BORVO { BOR_id = bor_id, product_id = cboProductName.SelectedValue.ToString(), process_name = cboProcessName.Text, m_id = Convert.ToInt32(cboMachine.SelectedValue), bor_tacttime = Convert.ToInt32(txtTactTime.Text), bor_yn = cboYN.Text, bor_comment = txtComment.Text, bor_uadmin = txtUadmin.Text }; BORService service = new BORService(); bool bResult = service.BORUpdate(bor); if (bResult) { MessageBox.Show("BOR항목을 수정하셨습니다"); } else { MessageBox.Show("수정에 실패하셨습니다"); } } this.Close(); } catch (Exception err) { MessageBox.Show(err.Message); } }