/// <summary> /// Shift 저장 메서드 /// </summary> /// <param name="vo"></param> /// <returns></returns> public Message InsertOrUpdateShift(SHIFT_VO vo) { try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = new SqlConnection(this.ConnectionString); cmd.CommandText = "SP_SaveShift"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@P_SHIFT_CODE", vo.SHIFT_CODE); cmd.Parameters.AddWithValue("@P_SHIFT_STARTTIME", vo.SHIFT_STARTTIME); cmd.Parameters.AddWithValue("@P_SHIFT_ENDTIME", vo.SHIFT_ENDTIME); cmd.Parameters.AddWithValue("@P_SHIFT_APPLY_STARTTIME", vo.SHIFT_APPLY_STARTTIME); cmd.Parameters.AddWithValue("@P_SHIFT_APPLY_ENDTIME", vo.SHIFT_APPLY_ENDTIME); cmd.Parameters.AddWithValue("@P_SHIFT_PERSON_DIR", vo.SHIFT_PERSON_DIR); cmd.Parameters.AddWithValue("@P_SHIFT_USE_YN", vo.SHIFT_USE_YN); cmd.Parameters.AddWithValue("@P_SHIFT_LAST_MDFR", vo.SHIFT_LAST_MDFR); cmd.Parameters.AddWithValue("@P_SHIFT_LAST_MDFY", vo.SHIFT_LAST_MDFY); cmd.Parameters.AddWithValue("@P_SHIFT_REMARK", vo.SHIFT_REMARK); cmd.Parameters.AddWithValue("@P_FCLTS_CODE", vo.FCLTS_CODE); cmd.Parameters.AddWithValue("@P_SHIFT_TYP", vo.SHIFT_TYP); 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 == "S00") { message.IsSuccess = false; message.ResultMessage = "실패하였습니다."; } return(message); } } catch (Exception err) { return(new Message(err)); } }
/// <summary> /// Shift 저장버튼 클릭시 발생하는 이벤트 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnOK_Click(object sender, EventArgs e) { //유효값 확인 bool bStartTime = txtSTARTTIME.Text.Length == 6; bool bEndTime = txtENDTIME.Text.Length == 6; bool bPerson = txtPersonDirect.Text.Length > 0 && int.Parse(txtPersonDirect.Text) > 0; if (!(bStartTime || bEndTime || bPerson)) { MessageBox.Show("필수값을 입력해주세요.", "필수값 입력 확인", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } //전달 vo 생성 SHIFT_VO vo = new SHIFT_VO(); vo.SHIFT_CODE = 0; //등록 if (InsertOrUpdate == 2) { vo.SHIFT_CODE = int.Parse(txtShiftCode.Text); //수정 } vo.SHIFT_TYP = cboShift.Text; vo.SHIFT_STARTTIME = int.Parse(txtSTARTTIME.Text); vo.SHIFT_ENDTIME = int.Parse(txtENDTIME.Text); vo.SHIFT_APPLY_STARTTIME = dtpApplyStartTime.Value.ToShortDateString(); vo.SHIFT_APPLY_ENDTIME = dtpApplyEndTime.Value.ToShortDateString(); vo.SHIFT_PERSON_DIR = int.Parse(txtPersonDirect.Text); vo.SHIFT_USE_YN = cboShiftUseYN.Text; vo.SHIFT_LAST_MDFR = LoginInfo.UserInfo.LI_ID; vo.SHIFT_LAST_MDFY = DateTime.Now.ToShortDateString(); vo.SHIFT_REMARK = txtRemark.Text; vo.FCLTS_CODE = cboFcltsCode.Text; //서비스호출 ShiftService service = new ShiftService(); Message msg = service.InsertOrUpdateShift(vo); if (msg.IsSuccess) { MessageBox.Show(msg.ResultMessage); this.Close(); } else { MessageBox.Show(msg.ResultMessage); return; } }
public Message InsertOrUpdateShift(SHIFT_VO vo) { ShiftDAC dac = new ShiftDAC(); return(dac.InsertOrUpdateShift(vo)); }