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