1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49
|
OracleConnection connexion = new OracleConnection(cs);
OracleDataAdapter adapter_eng = new OracleDataAdapter(req_select_eng, connexion);
OracleDataAdapter adapter_obj_eng = new OracleDataAdapter(req_select_obj_eng, connexion);
OracleCommandBuilder builder_eng = new OracleCommandBuilder(adapter_eng);
OracleCommandBuilder builder_obj_eng = new OracleCommandBuilder(adapter_obj_eng);
DataSet dataset = new DataSet();
dataset.Clear();
adapter_eng.Fill(dataset, "ENG_HIST_CLIENT");
adapter_obj_eng.Fill(dataset, "OBJECTIF_ENG");
DataTable ENG_HIST_CLIENT = dataset.Tables["ENG_HIST_CLIENT"];
DataTable OBJECTIF_ENG = dataset.Tables["OBJECTIF_ENG"];
string filePath = @"D:\RAPPORT.xls";
Excel._Application application = new Excel.ApplicationClass();
Excel._Workbook rapport = application.Workbooks.Open(filePath, Type.Missing, false, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing);
Excel._Worksheet evol_eng = (Excel._Worksheet)rapport.Sheets["Evol_ENG"];
((Excel.Range)evol_eng.Cells[6, 4]).Value2 = Convert.ToDecimal(ENG_HIST_CLIENT.Rows[0]["CREDIT_DEC_N_1"]);
((Excel.Range)evol_eng.Cells[7, 4]).Value2 = Convert.ToDecimal(ENG_HIST_CLIENT.Rows[0]["CCT_DEC_N_1"]);
((Excel.Range)evol_eng.Cells[8, 4]).Value2 = Convert.ToDecimal(ENG_HIST_CLIENT.Rows[0]["CMLT_DEC_N_1"]);
((Excel.Range)evol_eng.Cells[9, 4]).Value2 = Convert.ToDecimal(ENG_HIST_CLIENT.Rows[0]["EGS_DEC_N_1"]);
((Excel.Range)evol_eng.Cells[11, 4]).Value2 = Convert.ToDecimal(ENG_HIST_CLIENT.Rows[0]["ENG_DEC_N_1"]);
((Excel.Range)evol_eng.Cells[6, 12]).Value2 = Convert.ToDecimal(ENG_HIST_CLIENT.Rows[0]["CREDIT_M"]);
((Excel.Range)evol_eng.Cells[7, 12]).Value2 = Convert.ToDecimal(ENG_HIST_CLIENT.Rows[0]["CCT_M"]);
((Excel.Range)evol_eng.Cells[8, 12]).Value2 = Convert.ToDecimal(ENG_HIST_CLIENT.Rows[0]["CMLT_M"]);
((Excel.Range)evol_eng.Cells[9, 12]).Value2 = Convert.ToDecimal(ENG_HIST_CLIENT.Rows[0]["EGS_M"]);
((Excel.Range)evol_eng.Cells[11, 12]).Value2 = Convert.ToDecimal(ENG_HIST_CLIENT.Rows[0]["ENG_M"]);
((Excel.Range)evol_eng.Cells[6, 9]).Value2 = Convert.ToDecimal(OBJECTIF_ENG.Rows[0]["CREDIT"]);
((Excel.Range)evol_eng.Cells[7, 9]).Value2 = Convert.ToDecimal(OBJECTIF_ENG.Rows[0]["CCT"]);
((Excel.Range)evol_eng.Cells[8, 9]).Value2 = Convert.ToDecimal(OBJECTIF_ENG.Rows[0]["CMLT"]);
((Excel.Range)evol_eng.Cells[9, 9]).Value2 = Convert.ToDecimal(OBJECTIF_ENG.Rows[0]["ES"]);
((Excel.Range)evol_eng.Cells[11, 9]).Value2 = Convert.ToDecimal(OBJECTIF_ENG.Rows[0]["ENG"]);
rapport.Save();
rapport.Close(false, Type.Missing, Type.Missing);
application.Quit(); |
Partager