/// <summary>
/// 작업장추가
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public bool InsertWorkservice(WorkCenter_Master2VO item)
{
try
{
using (SqlCommand comm = new SqlCommand())
{
comm.Connection = new SqlConnection(Connstr);
comm.CommandText = $"insert into WorkCenter_Master(Wc_Code,Wc_Name,Process_Code,Remark,Ins_Date,Ins_Emp) values(@Wc_Code,@Wc_Name,@Process_Code,@Remark,'{DateTime.Now.ToShortDateString()}',@Ins_Emp)";
comm.CommandType = CommandType.Text;
comm.Parameters.AddWithValue("@Wc_Code", item.Wc_Code);
comm.Parameters.AddWithValue("@Wc_Name", item.Wc_Name);
comm.Parameters.AddWithValue("@Process_Code", item.Process_Code);
comm.Parameters.AddWithValue("@Remark", item.Remark);
comm.Parameters.AddWithValue("@Ins_Emp", item.Ins_Emp);
comm.Connection.Open();
int result = Convert.ToInt32(comm.ExecuteNonQuery());
comm.Connection.Close();
if (result > 0)
{
return(true);
}
return(false);
}
}
catch
{
throw;
}
}
private void BtnSave_Click(object sender, EventArgs e)
{
try
{
if (!string.IsNullOrEmpty(txtwork_code.Text) && !string.IsNullOrEmpty(txtwork_name.Text) && !string.IsNullOrEmpty(lblprocess.Text))
{
WorkCenter_Master2VO additem = new WorkCenter_Master2VO()
{
Wc_Code = txtwork_code.Text,
Wc_Name = txtwork_name.Text,
Process_Code = lblprocess.Text,
Remark = txtRemark.Text,
Ins_Emp = UserInfo.User_Name
};
if (Workservice.InsertWorkservice(additem))
{
this.DialogResult = DialogResult.OK;
this.Close();
}
else
{
MessageBox.Show("이미 등록된 검사항목입니다.", "알림", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
}
else
{
MessageBox.Show("필수 항목을 입력하세요.", "알림", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
}
catch (Exception err)
{
MessageBox.Show(err.ToString(), "알림", MessageBoxButtons.OK, MessageBoxIcon.Information);
Program.Log.WriteError(err.Message);
}
}
public bool InsertWorkservice(WorkCenter_Master2VO item)
{
WorkCenter_MasterDAC dac = new WorkCenter_MasterDAC();
return(dac.InsertWorkservice(item));
}
