private void btmOK_Click(object sender, EventArgs e) { this.mfiInsert.strEquipTagPty = this.tbTag.Text.Trim(); this.mfiInsert.tsDurationPty = TimeSpan.Parse(this.tbDuration.Text.Trim()); this.mfiInsert.strTipPty = this.tbTip.Text.Trim(); this.mfiInsert.tsTimePty = TimeSpan.Parse(this.tbTime.Text.Trim()); this.mfiInsert.intIDPty = this.mfiInsert.Insert(this.cnConnection); foreach (DataRow drPerson in this.dsPersons.Tables["tabMaintenanceFurnacePersons"].Rows) { drPerson["intTabItemsID"] = this.mfiInsert.intIDPty; } foreach (DataRow drEquip in this.dsEquips.Tables["tabMaintenanceFurnaceEquips"].Rows) { drEquip["intTabItemsID"] = this.mfiInsert.intIDPty; } MaintenanceFurnaceItem.InsertItemEquip(this.cnConnection, this.dsEquips); MaintenanceFurnaceItem.InsertItemPerson(this.cnConnection, this.dsPersons); MaintenanceElectricalFurnace frmMfi = (MaintenanceElectricalFurnace)this.Owner; frmMfi.GetCurrentMaintenanceShiftAndItems(); this.Close(); }
private void btmSearchItems_Click(object sender, EventArgs e) { try { this.dsShifts.Clear(); } catch (System.NullReferenceException) { } this.mfiSearch.strEquipTagPty = this.tbTag.Text; this.mfiSearch.strTipPty = this.tbTip.Text; this.dsItems = MaintenanceFurnaceItem.GetMFIs(this.cnConnection, this.mfiSearch, this.tbStoreCode.Text.Trim(), this.tbPersonCoID.Text.Trim()); this.dgvItems.DataSource = this.dsItems; this.dgvItems.DataMember = "tabMaintenanceFurnaceItems"; }
private void dgvShifts_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == -1 && e.RowIndex != -1) { int intIDLoc = (int)this.dgvShifts.Rows[e.RowIndex].Cells["intID"].Value; this.mfiSearch = new MaintenanceFurnaceItem(); this.mfiSearch.intIDPty = intIDLoc; this.dsItems = MaintenanceFurnaceItem.GetMFIs(this.cnConnection, this.mfiSearch, this.tbStoreCode.Text.Trim(), this.tbPersonCoID.Text.Trim()); this.dgvItems.DataSource = this.dsItems; this.dgvItems.DataMember = "tabMaintenanceFurnaceItems"; foreach (DataRow drEmployee in this.dsItems.Tables["tabMaintenanceFurnaceItems"].Rows) { drEmployee["nvcPersonCoID"] = Employee.GetNameByCoID(this.cnConnection, drEmployee["nvcPersonCoID"].ToString()); } } }
private void btmOK_Click(object sender, EventArgs e) { this.mfiUpdate.strEquipTagPty = this.tbTag.Text.Trim(); this.mfiUpdate.tsDurationPty = TimeSpan.Parse(this.tbDuration.Text.Trim()); this.mfiUpdate.strTipPty = this.tbTip.Text.Trim(); this.mfiUpdate.tsTimePty = TimeSpan.Parse(this.tbTime.Text.Trim()); this.mfiUpdate.Update(this.cnConnection); MaintenanceFurnaceItem.DeleteItemEquips(this.cnConnection, this.dsPrimaryEquips); MaintenanceFurnaceItem.DeleteItemPerson(this.cnConnection, this.dsPrimaryPersons); MaintenanceFurnaceItem.InsertItemEquip(this.cnConnection, this.dsEquips); MaintenanceFurnaceItem.InsertItemPerson(this.cnConnection, this.dsPersons); MaintenanceElectricalFurnace frmMfi = (MaintenanceElectricalFurnace)this.Owner; frmMfi.GetCurrentMaintenanceShiftAndItems(); this.Close(); }
private void dgvItems_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e) { if (e.ColumnIndex == -1) { MaintenanceFurnaceItem mfiUpdate = new MaintenanceFurnaceItem(); mfiUpdate.intIDPty = (int)this.dsItems.Tables["tabMaintenanceFurnaceItems"].Rows[e.RowIndex]["intID"]; mfiUpdate.intTabShiftIDPty = this.mfsCurrent.intIDPty; mfiUpdate.strEquipTagPty = this.dsItems.Tables["tabMaintenanceFurnaceItems"].Rows[e.RowIndex]["nvcEquipTag"].ToString(); mfiUpdate.tsTimePty = (TimeSpan)this.dsItems.Tables["tabMaintenanceFurnaceItems"].Rows[e.RowIndex]["timTime"]; mfiUpdate.tsDurationPty = (TimeSpan)this.dsItems.Tables["tabMaintenanceFurnaceItems"].Rows[e.RowIndex]["timDuration"]; mfiUpdate.strTipPty = this.dsItems.Tables["tabMaintenanceFurnaceItems"].Rows[e.RowIndex]["nvcTip"].ToString(); MaintenanceElectricalFurnaceUpdate frmMefUpdate = new MaintenanceElectricalFurnaceUpdate(); frmMefUpdate.Owner = this; frmMefUpdate.cnConnection = this.cnConnection; //frmMefUpdate.mfsUpdate = this.mfsCurrent; frmMefUpdate.mfiUpdate = mfiUpdate; frmMefUpdate.ShowDialog(); } }
private void MaintenanceElectricalFurnaceUpdate_Load(object sender, EventArgs e) { this.tbTag.Text = this.mfiUpdate.strEquipTagPty; this.tbTime.Text = this.mfiUpdate.tsTimePty.ToString(); this.tbDuration.Text = this.mfiUpdate.tsDurationPty.ToString(); this.tbTip.Text = this.mfiUpdate.strTipPty; this.dsPersons = MaintenanceFurnaceItem.GetItemPersons(this.cnConnection, this.mfiUpdate.intIDPty); this.dsPrimaryPersons = this.dsPersons.Copy(); this.dsPersons.Tables["tabMaintenanceFurnacePersons"].Columns.Add("nvcName"); this.dgvPersons.DataSource = this.dsPersons; this.dgvPersons.DataMember = "tabMaintenanceFurnacePersons"; this.dgvPersons.Columns["intID"].Visible = false; foreach (DataRow drPerson in this.dsPersons.Tables["tabMaintenanceFurnacePersons"].Rows) { drPerson["nvcName"] = Employee.GetNameByCoID(this.cnConnection, drPerson["nvcPersonCoID"].ToString()); } this.dsEquips = MaintenanceFurnaceItem.GetItemEquips(this.cnConnection, this.mfiUpdate.intIDPty); this.dsPrimaryEquips = this.dsEquips.Copy(); this.dsEquips.Tables["tabMaintenanceFurnaceEquips"].Columns.Add("nvcName"); this.dgvEquips.DataSource = this.dsEquips; this.dgvEquips.DataMember = "tabMaintenanceFurnaceEquips"; this.dgvEquips.Columns["intID"].Visible = false; foreach (DataRow drEquip in this.dsEquips.Tables["tabMaintenanceFurnaceEquips"].Rows) { Stuff parSearch = new Stuff(); //parSearch.strStoreCode = this.tbEquip.Text.Trim(); //DataSet dsEquipResult = Part.GetParts(this.cnConnection, parSearch); //if (dsEquipResult.Tables["tabParts"].Rows.Count != 0) //{ // String strEquipNameCode = dsEquipResult.Tables["tabParts"].Rows[0]["nvcName"].ToString(); // //String strEquipName = EquipName.GetEquipnameByCode(this.cnConnection, strEquipNameCode); // drEquip["nvcName"] = strEquipName; //} } }
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(); } }
private void btmDelete_Click(object sender, EventArgs e) { MaintenanceFurnaceItem.DeleteItems(this.cnConnection, this.dsItems); GetCurrentMaintenanceShiftAndItems(); }