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