private void thongke()
{
int thuong, le, dem, chunhat, tong;
thuong = le = dem = chunhat = tong = 0;
DataTable dt = BUS_Tangca.select_1NV_thang(manv, thang, nam);
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["maloai"].ToString() == "tct")
{
thuong += int.Parse(dt.Rows[i]["sogio"].ToString());
}
if (dt.Rows[i]["maloai"].ToString() == "tcd")
{
dem += int.Parse(dt.Rows[i]["sogio"].ToString());
}
if (dt.Rows[i]["maloai"].ToString() == "tccn")
{
chunhat += int.Parse(dt.Rows[i]["sogio"].ToString());
}
if (dt.Rows[i]["maloai"].ToString() == "tcl")
{
le += int.Parse(dt.Rows[i]["sogio"].ToString());
}
}
tong = thuong + le + dem + chunhat;
lbChunhat.Text = chunhat.ToString();
lbDem.Text = dem.ToString();
lbLe.Text = le.ToString();
lbThuong.Text = thuong.ToString();
lbTong.Text = tong.ToString();
}
public void loadFull()
{
DataTable dt = BUS_Tangca.select_1NV_thang(manv, thang, nam);
gridChitietTangcaNV.DataSource = dt;
txtNgay.DataBindings.Clear();
txtNgay.DataBindings.Add("Text", gridChitietTangcaNV.DataSource, "ngay");
lbSogio.DataBindings.Clear();
lbSogio.DataBindings.Add("Text", gridChitietTangcaNV.DataSource, "sogio");
lbmaloai.DataBindings.Clear();
lbmaloai.DataBindings.Add("Text", gridChitietTangcaNV.DataSource, "tenca");
thongke();
}