private void btmSearchShifts_Click(object sender, EventArgs e) { try { this.dsItems.Clear(); } catch (System.NullReferenceException) { } DateTime dtFromDate = new DateTime(); DateTime dtToDate = new DateTime(); if (this.cekDate.Checked) { dtFromDate = new DateTime(this.dtpFromDate.Value.Year, this.dtpFromDate.Value.Month, this.dtpFromDate.Value.Day); dtToDate = new DateTime(this.dtpToDate.Value.Year, this.dtpToDate.Value.Month, this.dtpToDate.Value.Day); } this.mfsSearch.shiShiftPty = ShiftInfo.ConvertTextToShift(this.cbShift.Text); this.mfsSearch.strGroupPty = this.cbGroup.Text; this.dsShifts = MaintenanceFurnaceShift.GetMFSs(this.cnConnection, mfsSearch, dtFromDate, dtToDate); this.dgvShifts.DataSource = this.dsShifts; this.dgvShifts.DataMember = "tabMaintenanceFurnaceShifts"; for (int i = 0; i < this.dsShifts.Tables["tabMaintenanceFurnaceShifts"].Rows.Count; i++) { int intShift = int.Parse(this.dsShifts.Tables["tabMaintenanceFurnaceShifts"].Rows[i]["nvcShift"].ToString()); this.dsShifts.Tables["tabMaintenanceFurnaceShifts"].Rows[i]["nvcShift"] = ((ShiftInfo.Shift)intShift).ToString(); } }
private void dgvItems_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == -1 && e.RowIndex != -1) { MaintenanceFurnaceShift mfsSearchLoc = new MaintenanceFurnaceShift(); int intIDLoc = (int)this.dgvItems.Rows[e.RowIndex].Cells["intTabShiftID"].Value; mfsSearchLoc.intIDPty = intIDLoc; this.dsShifts = MaintenanceFurnaceShift.GetMFSs(this.cnConnection, mfsSearchLoc); this.dgvShifts.DataSource = this.dsShifts; this.dgvShifts.DataMember = "tabMaintenanceFurnaceShifts"; for (int i = 0; i < this.dsShifts.Tables["tabMaintenanceFurnaceShifts"].Rows.Count; i++) { int intShift = int.Parse(this.dsShifts.Tables["tabMaintenanceFurnaceShifts"].Rows[i]["nvcShift"].ToString()); this.dsShifts.Tables["tabMaintenanceFurnaceShifts"].Rows[i]["nvcShift"] = ((ShiftInfo.Shift)intShift).ToString(); } } }
public void GetCurrentMaintenanceShiftAndItems() { this.dsShifts.Clear(); this.dsItems.Clear(); this.mfsCurrent.dtDatePty = siShiftInfo.GetDate(DateTime.Now); this.mfsCurrent.shiShiftPty = siShiftInfo.GetShift(DateTime.Now.TimeOfDay); this.mfsCurrent.strCaltegoryPty = "01"; this.dsShifts = MaintenanceFurnaceShift.GetMFSs(this.cnConnection, this.mfsCurrent); //Shift Already Inserted if (this.dsShifts.Tables["tabMaintenanceFurnaceShifts"].Rows.Count != 0) { this.mfsCurrent.intIDPty = (int)this.dsShifts.Tables["tabMaintenanceFurnaceShifts"].Rows[0]["intID"]; this.mfsCurrent.strGroupPty = this.dsShifts.Tables["tabMaintenanceFurnaceShifts"].Rows[0]["nvcGroup"].ToString(); this.dgvShifts.DataSource = this.dsShifts; this.dgvShifts.DataMember = "tabMaintenanceFurnaceShifts"; this.mfiCurrent.intTabShiftIDPty = this.mfsCurrent.intIDPty; this.dsItems = MaintenanceFurnaceItem.GetMFIs(this.cnConnection, this.mfiCurrent, this.tbStoreCode.Text.Trim(), this.tbPersonCoID.Text.Trim()); if (this.dsItems.Tables["tabMaintenanceFurnaceItems"].Rows.Count != 0) { this.dgvItems.DataSource = this.dsItems; this.dgvItems.DataMember = "tabMaintenanceFurnaceItems"; } } //Insert Shift else { this.mfsCurrent.strGroupPty = siShiftInfo.GetGroup(siShiftInfo.GetDate(DateTime.Now)).ToString(); this.mfsCurrent.Insert(this.cnConnection); GetCurrentMaintenanceShiftAndItems(); } }