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