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