public void Search(object sender, EventArgs e)
{
if (((FrmMAIN)this.MdiParent).ActiveMdiChild == this)
{
//서비스호출
ShiftService service = new ShiftService();
DataTable list = service.GetShiftManage(dtpFromdate.Value.ToShortDateString(), dtpTodate.Value.ToShortDateString());
//shift 조회
if (list.Rows.Count > 0 && cboShift.Text.Length > 0)
{
var rows = (from item in list.AsEnumerable() select item).Where
(p => p.Field <string>(1) == cboShift.Text).ToList();
var dt = rows.Any() ? rows.CopyToDataTable() : new DataTable();
//int A = dt.Rows.Count;
list = dt;
}
//설비명 조회
if (list.Rows.Count > 0 && cboFclts.SelectedIndex > 0)
{
var rows = (from item in list.AsEnumerable() select item).Where
(p => p.Field <string>(0) == cboFclts.Text).ToList();
var dt = rows.Any() ? rows.CopyToDataTable() : new DataTable();
list = dt;
}
dgvShift.DataSource = null;
dgvShift.DataSource = list;
//그리드 초기화
DataGridViewColumnSet();
}
}
private void ShiftPop_Load(object sender, EventArgs e)
{
//콤보박스 바인딩
BindingComboBox();
//초기값
txtMDFDate.Text = DateTime.Now.ToShortDateString();
cboShift.SelectedIndex = 0;
cboShiftUseYN.SelectedIndex = 0;
cboFcltsCode.SelectedIndex = 1;
if (InsertOrUpdate == 2) //수정
{
//서비스 호출
ShiftService service = new ShiftService();
var vo = service.GetShiftInfo(ShiftCode);
cboFcltsCode.SelectedIndex = cboFcltsCode.FindStringExact(vo.FCLTS_CODE);
txtFcltsName.Text = vo.FCLTS_NAME;
cboShift.SelectedIndex = cboShift.FindStringExact(vo.SHIFT_TYP);
cboShiftUseYN.SelectedIndex = cboShiftUseYN.FindStringExact(vo.SHIFT_USE_YN);
txtSTARTTIME.Text = vo.SHIFT_STARTTIME.ToString().PadLeft(6, '0');;
txtENDTIME.Text = vo.SHIFT_ENDTIME.ToString().PadLeft(6, '0');
dtpApplyStartTime.Value = Convert.ToDateTime(vo.SHIFT_APPLY_STARTTIME);
dtpApplyEndTime.Value = Convert.ToDateTime(vo.SHIFT_APPLY_ENDTIME);
txtPersonDirect.Text = vo.SHIFT_PERSON_DIR.ToString();
txtShiftCode.Text = vo.SHIFT_CODE.ToString();
txtRemark.Text = vo.SHIFT_REMARK;
}
}
private void LoadShiftList()
{
//서비스호출
ShiftService service = new ShiftService();
AllList = service.GetShiftList();
dgvShift.DataSource = null;
dgvShift.DataSource = AllList;
}
private void LoadShiftList()
{
//서비스호출
ShiftService service = new ShiftService();
var list = service.GetShiftManage(dtpFromdate.Value.ToShortDateString(), dtpTodate.Value.ToShortDateString());
dgvShift.DataSource = null;
dgvShift.DataSource = list;
//그리드 초기화
if (list.Rows.Count > 0)
{
DataGridViewColumnSet();
}
}
/// <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 void Delete(object sender, EventArgs e)
{
if (((FrmMAIN)this.MdiParent).ActiveMdiChild == this)
{
string lists = CheckedList();
if (lists.Length > 0)
{
if (MessageBox.Show("정말로 삭제하시겠습니까?", "삭제확인", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
//서비스 호출
ShiftService service = new ShiftService();
if (service.DeleteShiftList(lists, "@"))
{
MessageBox.Show("삭제되었습니다.", "삭제 성공", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("삭제 중 오류가 발생하였습니다. 다시 시도하여 주십시오.", "삭제 실패", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
Reset(null, null);
}
}
