private void btnOK_Click(object sender, EventArgs e)
{
try
{
#region 설비군 등록&수정
if (txtFACGCODE.Text == "" || txtFACGNAME.Text == "" || cboFACGUseYN.Text == "")
{
MessageBox.Show("필수정보 입력 필요");
return;
}
FACILITY_GROUP vo = new FACILITY_GROUP();
vo.FACG_CODE = txtFACGCODE.Text;
vo.FACG_NAME = txtFACGNAME.Text;
vo.FACG_USE_YN = cboFACGUseYN.Text;
vo.FACG_LAST_MDFR = txtModifier.Text;
vo.FACG_LAST_MDFY = txtModifyDate.Text;
vo.FACG_DESC = txtDesc.Text;
if (!Update) //설비군 등록
{
FacilityService service = new FacilityService();
Message msg = service.InsertFacilityGroup(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.UpdateFacilityGroup(vo, Update);
if (msg.IsSuccess)
{
MessageBox.Show("성공");
this.DialogResult = DialogResult.OK;
this.Close();
}
else
{
MessageBox.Show(msg.ResultMessage);
return;
}
}
#endregion
}
catch (Exception err)
{
_logging = new LoggingUtility(this.Name, Level.Info, 30);
}
}
public Message UpdateFacilityGroup(FACILITY_GROUP fac, bool update)
{
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = new SqlConnection(this.ConnectionString);
cmd.CommandText = "SP_SaveFacilityGroup";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@P_UPDATE", update);
cmd.Parameters.AddWithValue("@P_FACG_CODE", fac.FACG_CODE);
cmd.Parameters.AddWithValue("@P_FACG_NAME", fac.FACG_NAME);
cmd.Parameters.AddWithValue("@P_FACG_USE_YN", fac.FACG_USE_YN);
cmd.Parameters.AddWithValue("@P_FACG_LAST_MDFR", fac.FACG_LAST_MDFR);
cmd.Parameters.AddWithValue("@P_FACG_LAST_MDFY", fac.FACG_LAST_MDFY);
cmd.Parameters.AddWithValue("@P_FACG_DESC", fac.FACG_DESC);
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 UpdateFacilityGroup(FACILITY_GROUP fac, bool update)
{
FacilityDAC dac = new FacilityDAC();
return(dac.UpdateFacilityGroup(fac, update));
}
