private void txtExv_chidinh_Click(object sender, EventArgs e) { Export_Oracle ex_oralce = new Export_Oracle(); int i_result = 0; int n = int.Parse(txtSoThang.Text); DateTime ngayhh = dExport.Value; ex_oralce.f_deletetemp("bv115.temp_v_chidinh"); for (int i = 0; i < n; i++) { i_result += ex_oralce.f_ExportFromV_chidinh(ngayhh.AddMonths(-i), " and idtrongoi='42252' "); } MessageBox.Show(i_result.ToString()); }
private void txtbhytcn_Click(object sender, EventArgs e) { Export_Oracle ex_oralce = new Export_Oracle(); int i_result = 0; int n = int.Parse(txtSoThang.Text); DateTime ngayhh = dExport.Value; ex_oralce.f_deletetemp("bv115.bhyt_cn"); i_result += ex_oralce.f_ExportFrombhyt(" and length(macn)>4 "); for (int i = 0; i < n; i++) { i_result += ex_oralce.f_ExportFrombhyt(ngayhh.AddMonths(-i), " and length(macn)>4 "); } MessageBox.Show(i_result.ToString()); }