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