public Message UpdateFacility(FACILITY_VO fac, bool update)
{
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = new SqlConnection(this.ConnectionString);
cmd.CommandText = "SP_SaveFacility";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@P_UPDATE", update);
cmd.Parameters.AddWithValue("@P_FCLTS_CODE", fac.FCLTS_CODE);
cmd.Parameters.AddWithValue("@P_FCLTS_NAME", fac.FCLTS_NAME);
cmd.Parameters.AddWithValue("@P_FCLTS_WRHS_EXHST", fac.FCLTS_WRHS_EXHST);
cmd.Parameters.AddWithValue("@P_FCLTS_WRHS_GOOD", fac.FCLTS_WRHS_GOOD);
cmd.Parameters.AddWithValue("@P_FCLTS_WRHS_BAD", fac.FCLTS_WRHS_BAD);
cmd.Parameters.AddWithValue("@P_FCLTS_USE_YN", fac.FCLTS_USE_YN);
cmd.Parameters.AddWithValue("@P_FCLTS_EXTRL_YN", fac.FCLTS_EXTRL_YN);
cmd.Parameters.AddWithValue("@P_FCLTS_LAST_MDFR", fac.FCLTS_LAST_MDFR);
cmd.Parameters.AddWithValue("@P_FCLTS_LAST_MDFY", fac.FCLTS_LAST_MDFY);
cmd.Parameters.AddWithValue("@P_FCLTS_NOTE", fac.FCLTS_NOTE);
cmd.Parameters.AddWithValue("@P_FCLTS_REMARK", fac.FCLTS_REMARK);
cmd.Parameters.AddWithValue("@P_FACG_CODE", fac.FACG_CODE);
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));
}
}
internal Message UpdateFacility(FACILITY_VO fac, bool update)
{
FacilityDAC dac = new FacilityDAC();
return(dac.UpdateFacility(fac, update));
}
public Message InsertFacility(FACILITY_VO fac, bool update)
{
FacilityDAC dac = new FacilityDAC();
return(dac.InsertFacility(fac, update));
}
private void btnOK_Click(object sender, EventArgs e)
{
try
{
#region 설비군 등록&수정
if (txtFACGCODE.Text == "" || txtFACCODE.Text == "" || txtFACNAME.Text == "" ||
cboFACEXHST.Text == "" || cboFACGOOD.Text == "" || cboFACUseYN.Text == "")
{
MessageBox.Show("필수정보 입력 필요");
return;
}
FACILITY_VO vo = new FACILITY_VO();
vo.FACG_CODE = txtFACGCODE.Text;
vo.FCLTS_CODE = txtFACCODE.Text;
vo.FCLTS_NAME = txtFACNAME.Text;
vo.FCLTS_WRHS_EXHST = cboFACEXHST.SelectedValue.ToString();
vo.FCLTS_WRHS_GOOD = cboFACGOOD.SelectedValue.ToString();
vo.FCLTS_WRHS_BAD = (cboFACBAD.SelectedValue == null) ? "" : cboFACBAD.SelectedValue.ToString();
vo.FCLTS_USE_YN = cboFACUseYN.Text;
vo.FCLTS_EXTRL_YN = cboEXTRLYN.Text;
vo.FCLTS_LAST_MDFR = FCLTS_LAST_MDFR;
vo.FCLTS_LAST_MDFY = FCLTS_LAST_MDFY;
vo.FCLTS_NOTE = txtNote.Text;
vo.FCLTS_REMARK = txtREMARK.Text;
if (!Update) //설비 등록
{
FacilityService service = new FacilityService();
Message msg = service.InsertFacility(vo, Update);
if (msg.IsSuccess)
{
MessageBox.Show(msg.ResultMessage);
this.DialogResult = DialogResult.OK;
this.Close();
}
else
{
MessageBox.Show(msg.ResultMessage);
return;
}
}
else //설비 수정
{
FacilityService service = new FacilityService();
Message msg = service.UpdateFacility(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)
{
_logging = new LoggingUtility(this.Name, Level.Info, 30);
}
}
