private void btnOK_Click(object sender, EventArgs e)
{
try
{
#region 공장등록 & 수정
if (cboCategory.Text == "" || txtCode.Text == "" || cboType.Text == "" || cboParent.Text == "" ||
txtName.Text == "" || cboUseYN.Text == "")
{
MessageBox.Show("필수정보 입력 필요");
return;
}
//공통코드 완성 후 콤보박스 바인딩하고 수정이 필요
FACTORY_VO vo = new FACTORY_VO();
vo.FAC_CODE = txtCode.Text;
vo.FAC_FCLTY = cboCategory.Text;
vo.FAC_FCLTY_PARENT = cboParent.Text;
vo.FAC_NAME = txtName.Text;
vo.FAC_TYP = cboType.Text;
vo.FAC_FREE_YN = cboFreeYN.Text;
//순서 텍스트에 null, 숫자 외 입력시 null 값 입력
if (int.TryParse(txtSort.Text, out int plzNull))
{
vo.FAC_TYP_SORT = plzNull;
}
else
{
vo.FAC_TYP_SORT = null;
}
vo.FAC_DEMAND_YN = cboDemandYN.Text;
vo.FAC_PROCS_YN = cboProcYN.Text;
vo.FAC_MTRL_YN = cboMtrlYN.Text;
vo.FAC_LAST_MDFR = txtModifier.Text;
vo.FAC_LAST_MDFY = txtModifyDate.Text;
vo.FAC_USE_YN = cboUseYN.Text;
vo.FAC_DESC = txtDesc.Text;
vo.COM_NAME = (cboCom.Text.Length < 1) ? "" : cboCom.SelectedValue.ToString();
FactoryService service = new FactoryService();
Message msg = service.SaveFactory(vo, Update);
if (msg.IsSuccess)
{
MessageBox.Show(msg.ResultMessage);
this.DialogResult = DialogResult.OK;
this.Close();
}
else
{
MessageBox.Show(msg.ResultMessage);
return;
}
#endregion
}
catch (Exception err)
{
this.Log.WriteError($"[[RECV {this.Name}]]:{err.Message}");
}
}
//데이터 insert
public Message SaveFactory(FACTORY_VO fac, bool update)
{
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = new SqlConnection(this.ConnectionString);
cmd.CommandText = "SP_SaveFactory";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@P_UPDATE", update);
cmd.Parameters.AddWithValue("@P_FAC_CODE", fac.FAC_CODE);
cmd.Parameters.AddWithValue("@P_FAC_FCLTY", fac.FAC_FCLTY);
cmd.Parameters.AddWithValue("@P_FAC_FCLTY_PARENT", fac.FAC_FCLTY_PARENT);
cmd.Parameters.AddWithValue("@P_FAC_NAME", fac.FAC_NAME);
cmd.Parameters.AddWithValue("@P_FAC_TYP", fac.FAC_TYP);
cmd.Parameters.AddWithValue("@P_FAC_FREE_YN", fac.FAC_FREE_YN);
cmd.Parameters.Add(new SqlParameter("@P_FAC_TYP_SORT", System.Data.SqlDbType.Int));
cmd.Parameters["@P_FAC_TYP_SORT"].Value = (object)fac.FAC_TYP_SORT ?? DBNull.Value;
cmd.Parameters.AddWithValue("@P_FAC_DEMAND_YN", fac.FAC_DEMAND_YN);
cmd.Parameters.AddWithValue("@P_FAC_PROCS_YN", fac.FAC_PROCS_YN);
cmd.Parameters.AddWithValue("@P_FAC_MTRL_YN", fac.FAC_MTRL_YN);
cmd.Parameters.AddWithValue("@P_FAC_LAST_MDFR", fac.FAC_LAST_MDFR);
cmd.Parameters.AddWithValue("@P_FAC_LAST_MDFY", fac.FAC_LAST_MDFY);
cmd.Parameters.AddWithValue("@P_FAC_USE_YN", fac.FAC_USE_YN);
cmd.Parameters.AddWithValue("@P_FAC_DESC", fac.FAC_DESC);
cmd.Parameters.AddWithValue("@P_COM_NAME", fac.COM_NAME);
cmd.Parameters.Add(new SqlParameter("@P_ReturnCode", System.Data.SqlDbType.NVarChar, 5));
cmd.Parameters["@P_ReturnCode"].Direction = System.Data.ParameterDirection.Output;
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
string result = cmd.Parameters["@P_ReturnCode"].Value.ToString();
Message message = new Message();
if (result == "S01")
{
message.IsSuccess = true;
message.ResultMessage = "성공적으로 등록되었습니다.";
}
else if (result == "S02")
{
message.IsSuccess = true;
message.ResultMessage = "성공적으로 수정되었습니다.";
}
else if (result == "S03")
{
message.IsSuccess = false;
message.ResultMessage = "코드 중복";
}
else if (result == "S00")
{
message.IsSuccess = false;
message.ResultMessage = "실패하였습니다.";
}
return(message);
}
}
catch (Exception err)
{
return(new Message(err));
}
}
public Message SaveFactory(FACTORY_VO fac, bool update)
{
FactoryDAC dac = new FactoryDAC();
return(dac.SaveFactory(fac, update));
}