private void simpleButton2_Click(object sender, EventArgs e)
        {
            gridControl_ketqua.DataSource = null;
            gridView1.Columns.Clear();
            DataTable kq2 = new DataTable();

            kq2 = Class_CorrectData.Quick_Scan_7980_3360(Table_7980, table_Cv3360);
            gridControl_ketqua.DataSource = kq2;
        }
        public void du_lieu_tai_bv(string tungay, string denngay, string solieu)
        {
            OracleConnection conn = Database.GetDBConnection();
            var cmd = new OracleCommand();

            //var Table_7980 = new DataTable();
            Table_7980.Clear();
            string so_lieu_kcb = Class_CorrectData.Get_LoaiKCB(Convert.ToInt16(solieu));
            string mmyy_user   = datauser(tungay, denngay);

            MessageBox.Show(so_lieu_kcb + mmyy_user);
            try
            {
                cmd.Connection  = conn;
                cmd.CommandText = "select * from (table(hsoft.vnpt.func_bc_mau79802the('" + mmyy_user + "','" + tungay + "','" + denngay + "','" + so_lieu_kcb + "')))";
                cmd.CommandType = CommandType.Text;


                conn.Open();
                using (var reader = cmd.ExecuteReader())
                {
                    Table_7980.Load(reader);
                    MessageBox.Show("Xử lý dữ liệu thành công");
                }
                //DataSet ds_du_lieu_tai_bv = new DataSet();
                //OracleDataAdapter da_du_lieu_tai_bv = new OracleDataAdapter();
                //da_du_lieu_tai_bv.SelectCommand = cmd;
                //da_du_lieu_tai_bv.Fill(ds_du_lieu_tai_bv, "data");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            string soluong_7980 = Convert.ToString(String.Format("{0:#,##0.##}", Table_7980.Compute("COUNT(SOTHE)", "")));

            labelControl_sobn7980.Text = soluong_7980;
            int    soluong_7980num = Convert.ToInt32(Table_7980.Compute("COUNT(SOTHE)", ""));
            string tongchi_7980    = Convert.ToString(String.Format("{0:#,##0.##}", Table_7980.Compute("Sum(T_TONGCHI)", "")));

            labelControl_tongcp7980.Text = "Tổng chi phí: " + tongchi_7980;
            string tongbntt_7980 = Convert.ToString(String.Format("{0:#,##0.##}", Table_7980.Compute("Sum(T_BNTT)", "")));

            labelControl_tongbntt7980.Text = "Tổng BNTT: " + tongbntt_7980;
            string tongbhtt_7980 = Convert.ToString(String.Format("{0:#,##0.##}", Table_7980.Compute("Sum(T_BHTT)", "")));

            labelControl_tongbhtt7980.Text = "Tổng BHTT: " + tongbhtt_7980;
            //MessageBox.Show(tongchi_7980);
            string ket_qua = Class_CorrectData.Get_SoLechBN(soluong_7980num, slbncv3360);

            labelControl_thongbao.Text = "Đã chuẩn hóa số liệu thành công, " + ket_qua;
            conn.Close();
        }
        private void simpleButton1_Click_1(object sender, EventArgs e)
        {
            gridControl_ketqua.DataSource = null;
            gridView1.Columns.Clear();
            DataTable kq = new DataTable();

            kq = Class_CorrectData.Quick_Scan_3360_7980(Table_7980, table_Cv3360);
            gridControl_ketqua.DataSource = kq;
            //MessageBox.Show("Xử lý thành công" + kq.Rows[0][0]);
            //Form_viewdata f = new Form_viewdata();
            //f.Visible = true;
            //f.load_data(kq);
        }
 private void simpleButton3_Click(object sender, EventArgs e)
 {
     du_lieu_tai_bv(dateEdit_tungay.Text, dateEdit_denngay.Text, so_lieu_7980);
     Table_kqtthuyqt         = Class_CorrectData.TTHuyQT(Table_tthuyqt, Table_7980);
     gridControl2.DataSource = Table_kqtthuyqt;
 }