private void btnShowMonitoring_Click(object sender, EventArgs e) { try { DAL.JobEntry objDAL = new DAL.JobEntry(); DataTable dtData = new DataTable(); if (string.IsNullOrEmpty(dtpFromMonitoring.Text) && string.IsNullOrEmpty(dtpToMonitoring.Text)) { dtData = objDAL.GetCurrentJob(string.Empty, string.Empty, chkIsLive.Checked, txtSearchJobNo.Text.Trim()); } else { dtData = objDAL.GetCurrentJob(dtpFromMonitoring.Value.ToString("dd/MMM/yyyy"), dtpToMonitoring.Value.ToString("dd/MMM/yyyy"), chkIsLive.Checked, txtSearchJobNo.Text.Trim()); } if (dtData.Rows.Count > 0) { SetCurrentJobData(dtData); } else { MessageBox.Show("Record Not Found For Selected Date.", "Data", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnShowCalculation_Click(object sender, EventArgs e) { try { DAL.JobEntry objDAL = new DAL.JobEntry(); DataTable dtData = new DataTable(); if (string.IsNullOrEmpty(dtpFromCalculation.Text) && string.IsNullOrEmpty(dtpToCalculation.Text)) { dtData = objDAL.GetDryRunReport(string.Empty, string.Empty); } else { dtData = objDAL.GetDryRunReport(dtpFromCalculation.Value.ToString("dd/MMM/yyyy"), dtpToCalculation.Value.ToString("dd/MMM/yyyy")); } dgvDryRun.DataSource = dtData; dgvDryRun.Columns[0].Visible = false; dgvDryRun.Columns[1].HeaderText = "Heat Start Time"; dgvDryRun.Columns[2].HeaderText = "Heat End Time"; dgvDryRun.Columns[3].HeaderText = "Tot. Fur. Dur."; dgvDryRun.Columns[4].HeaderText = "Tot. All Job Dur."; dgvDryRun.Columns[5].HeaderText = "Tot. Dry Run Dur."; dgvDryRun.Columns[6].HeaderText = "Tot. Fur. Unit"; dgvDryRun.Columns[7].HeaderText = "Tot. Job Unit"; dgvDryRun.Columns[8].HeaderText = "Tot. Dry Run Unit"; dgvDryRun.Columns[9].HeaderText = "Tot. Dry Run Amt."; dgvDryRun.Columns[0].Width = 0; dgvDryRun.Columns[1].Width = 150; dgvDryRun.Columns[2].Width = 150; dgvDryRun.Columns[3].Width = 65; dgvDryRun.Columns[4].Width = 65; dgvDryRun.Columns[5].Width = 65; dgvDryRun.Columns[6].Width = 65; dgvDryRun.Columns[7].Width = 65; dgvDryRun.Columns[8].Width = 65; dgvDryRun.Columns[9].Width = 65; dgvDryRun.Columns[1].DefaultCellStyle.Format = "dd/MM/yyyy hh:mm:ss tt"; dgvDryRun.Columns[2].DefaultCellStyle.Format = "dd/MM/yyyy hh:mm:ss tt"; dgvDryRun.Columns[9].DefaultCellStyle.Format = "#0.000"; dgvDryRun.Columns[6].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dgvDryRun.Columns[7].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dgvDryRun.Columns[8].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dgvDryRun.Columns[9].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private DataTable GetCurrentJob(string fromDate, string toDate, bool IsLive, string JobNo) { DataTable dtNew = new DataTable(); try { this.Invoke((Action) delegate { dtNew = new DAL.JobEntry().GetCurrentJob(fromDate, toDate, IsLive, JobNo); }); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } return(dtNew); }
public void GetJobEntry() { try { ENT.JobEntry objENT = new ENT.JobEntry(); List <ENT.JobEntry> lstENT = new List <ENT.JobEntry>(); if (checkBox1.Checked) { objENT.Mode = "GetAllJobEntryToday"; } else { objENT.Mode = "GetAllJobEntryByDate"; objENT.strJobStartTime = DAL.DBHelper.ChangeDate(dtpFromDate.Text); objENT.strJobEndTime = DAL.DBHelper.ChangeDate(dtpToDate.Text); objENT.JobNo = txtJobNo.Text.Trim(); } lstENT = new DAL.JobEntry().GetJobEntry(objENT); dgvSales.DataSource = lstENT; dgvSales.Columns[0].HeaderText = "JobID"; dgvSales.Columns[0].Visible = false; dgvSales.Columns[1].HeaderText = "Job No"; dgvSales.Columns[2].HeaderText = "Job Furnace No"; dgvSales.Columns[3].HeaderText = "Start Time"; dgvSales.Columns[4].HeaderText = "End Time"; dgvSales.Columns[5].HeaderText = "Pour1 Time"; dgvSales.Columns[6].HeaderText = "Pour2 Time"; dgvSales.Columns[7].HeaderText = "Pour3 Time"; dgvSales.Columns[8].HeaderText = "Pour4 Time"; dgvSales.Columns[9].HeaderText = "Pour5 Time"; dgvSales.Columns[10].HeaderText = "Pour6 Time"; dgvSales.Columns[11].Visible = false; dgvSales.Columns[12].Visible = false; dgvSales.Columns[13].Visible = false; dgvSales.Columns[14].HeaderText = "Job Status"; dgvSales.Columns[15].Visible = false; dgvSales.Columns[16].Visible = false; dgvSales.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnShowConsumption_Click(object sender, EventArgs e) { try { DAL.JobEntry objDAL = new DAL.JobEntry(); DataTable dtData = new DataTable(); if (string.IsNullOrEmpty(dtpFromConsumption.Text) && string.IsNullOrEmpty(dtpToConsumption.Text)) { dtData = objDAL.GetEnergyConsumptionHeatWise(string.Empty, string.Empty); } else { dtData = objDAL.GetEnergyConsumptionHeatWise(dtpFromConsumption.Value.ToString("dd/MMM/yyyy"), dtpToConsumption.Value.ToString("dd/MMM/yyyy")); } dgvEngCons.DataSource = dtData; dgvEngCons.Columns[0].HeaderText = "Job No."; dgvEngCons.Columns[1].HeaderText = "Job Furnace No."; dgvEngCons.Columns[2].HeaderText = "Total Unit"; dgvEngCons.Columns[3].HeaderText = "Job Start"; dgvEngCons.Columns[4].HeaderText = "Job End"; dgvEngCons.Columns[5].HeaderText = "Heat Start"; dgvEngCons.Columns[6].HeaderText = "Heat End"; dgvEngCons.Columns[0].Width = 100; dgvEngCons.Columns[1].Width = 100; dgvEngCons.Columns[2].Width = 100; dgvEngCons.Columns[3].Width = 150; dgvEngCons.Columns[4].Width = 150; dgvEngCons.Columns[5].Width = 150; dgvEngCons.Columns[6].Width = 150; dgvEngCons.Columns[3].DefaultCellStyle.Format = "dd/MM/yyyy hh:mm:ss tt"; dgvEngCons.Columns[4].DefaultCellStyle.Format = "dd/MM/yyyy hh:mm:ss tt"; dgvEngCons.Columns[5].DefaultCellStyle.Format = "dd/MM/yyyy hh:mm:ss tt"; dgvEngCons.Columns[6].DefaultCellStyle.Format = "dd/MM/yyyy hh:mm:ss tt"; } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnShowOverall_Click(object sender, EventArgs e) { try { DAL.JobEntry objDAL = new DAL.JobEntry(); DataTable dtData = new DataTable(); if (string.IsNullOrEmpty(dtpFromOverall.Text) && string.IsNullOrEmpty(dtpToOverall.Text)) { dtData = objDAL.GetOverAllHeatFurnaceTime(string.Empty, string.Empty); } else { dtData = objDAL.GetOverAllHeatFurnaceTime(dtpFromOverall.Value.ToString("dd/MMM/yyyy"), dtpToOverall.Value.ToString("dd/MMM/yyyy")); } dgvOverAll.DataSource = dtData; dgvOverAll.Columns[0].HeaderText = "Job No."; dgvOverAll.Columns[1].HeaderText = "Job Furnace No."; dgvOverAll.Columns[2].HeaderText = "Job Start"; dgvOverAll.Columns[3].HeaderText = "Job End"; dgvOverAll.Columns[4].HeaderText = "Job Duration"; dgvOverAll.Columns[0].Width = 100; dgvOverAll.Columns[1].Width = 100; dgvOverAll.Columns[2].Width = 150; dgvOverAll.Columns[3].Width = 150; dgvOverAll.Columns[4].Width = 100; dgvOverAll.Columns[2].DefaultCellStyle.Format = "dd/MM/yyyy hh:mm:ss tt"; dgvOverAll.Columns[3].DefaultCellStyle.Format = "dd/MM/yyyy hh:mm:ss tt"; } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }