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(); }