private void cmbKodHazmana_SelectionChangeCommitted(object sender, EventArgs e) { DataTable dtHespekiHazmana = DAL.dal.GetTableFromSQL("SELECT hespekim.kodHespek, hespekim.theDate, hespekim.fromTime, hespekim.tillTime FROM pirteHazmana INNER JOIN hespekim ON pirteHazmana.kodPirteyHazmana = hespekim.kodParitHazmana WHERE (((pirteHazmana.kodPirteyHazmana)=" + cmbKodHazmana.SelectedValue + ") AND ((hespekim.kodParitHazmana)=" + cmbKodHazmana.SelectedValue + "))"); dgvHespekiHazmana.DataSource = dtHespekiHazmana; dgvHespekiHazmana.Columns[0].HeaderText = "קוד הספק"; dgvHespekiHazmana.Columns[1].HeaderText = "תאריך ביצוע"; dgvHespekiHazmana.Columns[2].HeaderText = "שעת התחלה"; dgvHespekiHazmana.Columns[3].HeaderText = "שעת סיום"; lblZover.Text = Convert.ToString(HoursFigure(dtHespekiHazmana)); pirteHazmanaTable p1 = new pirteHazmanaTable(); lblHoursRequiered.Text = Convert.ToString(p1.getNumWorkHour(Convert.ToInt32(cmbKodHazmana.SelectedValue))); lblHefres.Text = Convert.ToString(Convert.ToDouble(lblHoursRequiered.Text) - Convert.ToDouble(lblZover.Text)); if (Convert.ToDouble(lblZover.Text) >= Convert.ToDouble(lblHoursRequiered.Text)) { proBTahalichHazmana.Value = 100; lblHefres.Text = "0"; lblHariga.Text = Convert.ToString(Convert.ToDouble(lblZover.Text) - Convert.ToDouble(lblHoursRequiered.Text)); LB.Visible = true; lblHariga.Visible = true; } else { proBTahalichHazmana.Value = Convert.ToInt32((Convert.ToDouble(lblZover.Text) / Convert.ToDouble(lblHoursRequiered.Text)) * 100); } }
public frmHespekiHazmana(int numPirteHazmana) { InitializeComponent(); this.numPirteHazmana = numPirteHazmana; cmbKodHazmana.Visible = false; DataTable dt = DAL.dal.GetTableFromSQL("SELECT hespekim.kodHespek, hespekim.kodParitHazmana, hespekim.theDate, hespekim.fromTime, hespekim.tillTime FROM hespekim WHERE (((hespekim.kodParitHazmana)=" + numPirteHazmana + ")) ORDER BY hespekim.theDate"); dgvHespekiHazmana.DataSource = dt; dgvHespekiHazmana.Columns[0].Visible = false; dgvHespekiHazmana.Columns[1].Visible = false; dgvHespekiHazmana.Columns[2].HeaderText = "תאריך"; dgvHespekiHazmana.Columns[3].HeaderText = "משעה"; dgvHespekiHazmana.Columns[4].HeaderText = "עד שעה"; lblZover.Text = Convert.ToString(HoursFigure(dt)); pirteHazmanaTable p1 = new pirteHazmanaTable(); lblHoursRequiered.Text = Convert.ToString(p1.getNumWorkHour(this.numPirteHazmana)); lblHefres.Text = Convert.ToString(Convert.ToDouble(lblHoursRequiered.Text) - Convert.ToDouble(lblZover.Text)); if (Convert.ToDouble(lblZover.Text) >= Convert.ToDouble(lblHoursRequiered.Text)) { proBTahalichHazmana.Value = 100; lblHefres.Text = "0"; lblHariga.Text = Convert.ToString(Convert.ToDouble(lblZover.Text) - Convert.ToDouble(lblHoursRequiered.Text)); LB.Visible = true; lblHariga.Visible = true; } else { proBTahalichHazmana.Value = Convert.ToInt32((Convert.ToDouble(lblZover.Text) / Convert.ToDouble(lblHoursRequiered.Text)) * 100); } }
public frmPirteHazmana(statusKind sta) { InitializeComponent(); this.mypirteHazmanots = new pirteHazmanaTable(); this.statusFrm = sta; cmbKodAboda.DataSource = new abodotStamTable().GetTableTrue(); cmbKodAboda.DisplayMember = "nameOfAboda"; cmbKodAboda.ValueMember = "kodAboda"; }