private void LoatL() { DateTime ngaydau, ngaycuoi; songaylam = "0"; if (m == 0) { ngaydau = Convert.ToDateTime(thang + "/" + "01/" + nam); ngaycuoi = Convert.ToDateTime(thang + "/" + "30/" + nam); } else { ngaydau = Convert.ToDateTime(txtThang.Text + "/" + "01/" + txtNam.Text); ngaycuoi = Convert.ToDateTime(txtThang.Text + "/" + "30/" + txtNam.Text); } btnCapNhat.Enabled = false; LbTen.Text = null; LbCV.Text = null; lbTB.Text = null; mydt.loadcombobox(comboHSL, "select HeSoLuong from tblLuong", "HeSoLuong"); dt.Clear(); dt = sqlcong.TongLuongNV("0"); gridViewLuong.DataSource = dt; for (int i = 0; i < gridViewLuong.RowCount; i++) { manv = gridViewLuong.Rows[i].Cells["ma"].Value == null ? string.Empty : gridViewLuong.Rows[i].Cells["ma"].Value.ToString(); gridViewLuong.Rows[i].Cells["SNL"].Value = LaySoNgayLam(manv, ngaydau, ngaycuoi); gridViewLuong.Rows[i].Cells["TT"].Value = TienThuong(manv, ngaycuoi); gridViewLuong.Rows[i].Cells["TP"].Value = TienPhat(manv, ngaycuoi); gridViewLuong.Rows[i].Cells["PC"].Value = tienPhuCap(manv, ngaycuoi); tongluong = TinhLuong1(manv, songaylam, ngaydau, ngaycuoi); gridViewLuong.Rows[i].Cells["TL"].Value = String.Format("{0:0,0}", tongluong); } }
private void HosoNV_Load(object sender, EventArgs e) { gridViewHSNV.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; gridViewHSNV.DataSource = hSNV().Tables[0]; ngaySinh.CustomFormat = "MM/dd/yyyy"; mydt.loadcombobox(combPB, "Select MaPhongBan from tblPhongBan", "MaPhongBan"); mydt.loadcombobox(combCV, "select MaChucVu from tblChucVu", "MaChucVu"); mydt.loadcombobox(comHSL, "select HeSoLuong from tblLuong", "HeSoLuong"); }