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