private void btnTongLuong_Click(object sender, EventArgs e)
        {
            Luong temp = new Luong(txtMaNV.Text, txtLuong.Text, txtLuongThuong.Text, txtGhichu.Text, txtSNTC.Text, txtTongLuong.Text);

            ConnectDatabase.TongLuong_NV(temp);
            dgvLuong_CaNhan.DataSource = ConnectDatabase.GetAllLuong_NV();
        }
        public static void SuaLuong_PhongBan(Luong l, ChucVu cv, NhanVien nv)
        {
            //string sql = "UPDATE LUONG set Luong = @luong, LuongThuong=@luongthuong, GhiChu=@ghichu where MaNV=@manv";

            //using (SqlCommand command = new SqlCommand(sql, conn))
            //{
            //    command.Parameters.Add(new SqlParameter("@tencv", cv.Tencv));
            //    command.Parameters.Add(new SqlParameter("@macv", cv.Macv));
            //    command.ExecuteNonQuery();
            //    command.Cancel();
            //}
        }
        public static void TongLuong_NV(Luong luong)
        {
            string sql = "update LUONG set TongLuong = SoNgayTangCa * 50000 + LuongCB + LuongThuong where MaNV = @Manv";

            using (SqlCommand command = new SqlCommand(sql, conn))
            {
                command.Parameters.Add(new SqlParameter("@luongCB", luong.LuongNV1));
                command.Parameters.Add(new SqlParameter("@luongthuong", luong.LuongThuong1));
                command.Parameters.Add(new SqlParameter("@ghichu", luong.Chichu1));
                command.Parameters.Add(new SqlParameter("@SNTC", luong.SoNgayTangCa1));
                command.Parameters.Add(new SqlParameter("@TongLuong", luong.TongLuong1));
                command.Parameters.Add(new SqlParameter("@manv", luong.MaNV1));
                command.ExecuteNonQuery();
                command.Cancel();
            }
        }
        public static void SuaLuong_PB(Luong luong)
        {
            string sql = "UPDATE LUONG set LuongCB=@luongCB, LuongThuong=@luongthuong, GhiChu=@ghichu, SoNgayTangCa = @SNTC, TongLuong = @TongLuong where MaNV=@manv";

            using (SqlCommand command = new SqlCommand(sql, conn))
            {
                command.Parameters.Add(new SqlParameter("@luongCB", luong.LuongNV1));
                command.Parameters.Add(new SqlParameter("@luongthuong", luong.LuongThuong1));
                command.Parameters.Add(new SqlParameter("@ghichu", luong.Chichu1));
                command.Parameters.Add(new SqlParameter("@SNTC", luong.SoNgayTangCa1));
                command.Parameters.Add(new SqlParameter("@TongLuong", luong.TongLuong1));
                command.Parameters.Add(new SqlParameter("@manv", luong.MaNV1));
                command.ExecuteNonQuery();
                command.Cancel();
            }
        }