public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { Crysta_MAD rpt = new Crysta_MAD(); rpt.Site = this.Site; return(rpt); }
private void btn_imprimer_Click(object sender, EventArgs e) { string Type_operation; if (combo_type_op.Text == "Autre") { Type_operation = txt_typeop.Text; } else { Type_operation = combo_type_op.Text; } if (Declaration.doc_type == "Ordre") { try { Impression imp = new Impression(); CrystalReport2 C = new CrystalReport2(); TextObject t = (TextObject)C.ReportDefinition.Sections[1].ReportObjects["Text3"]; t.Text = txt_num_doc.Text; TextObject t1 = (TextObject)C.ReportDefinition.Sections[1].ReportObjects["Text4"]; t1.Text = combo_banque.Text; TextObject t2 = (TextObject)C.ReportDefinition.Sections[2].ReportObjects["Text7"]; if (combo_type_op.Text != "Autre") { t2.Text = combo_type_op.Text; } else { t2.Text = txt_typeop.Text; } string msg = "Virement au compte n° \n " + txt_rib_ben.Text; TextObject t3 = (TextObject)C.ReportDefinition.Sections[2].ReportObjects["Text9"]; t3.Text = msg; TextObject t4 = (TextObject)C.ReportDefinition.Sections[2].ReportObjects["Text18"]; t4.Text = txt_montant_chiffre.Text; Declaration D = new Declaration(); TextObject t5 = (TextObject)C.ReportDefinition.Sections[2].ReportObjects["Text11"]; t5.Text = D.IntToFr(int.Parse(txt_montant_chiffre.Text)) + "DIRHAMS"; string msg2 = "Messieurs, Par le débit de notre compte N°" + txt_rib.Text + ", nous vous prions d’effectuer le virement mentionné sous rubrique."; TextObject t6 = (TextObject)C.ReportDefinition.Sections[3].ReportObjects["Text12"]; t6.Text = msg2; TextObject t7 = (TextObject)C.ReportDefinition.Sections[3].ReportObjects["Text15"]; t7.Text = t2.Text; TextObject t8 = (TextObject)C.ReportDefinition.Sections[3].ReportObjects["Text16"]; t8.Text = "C/" + txt_ben_moral.Text; TextObject t9 = (TextObject)C.ReportDefinition.Sections[3].ReportObjects["Text17"]; t9.Text = "OIS/H/M/P- 185 DU " + DateTime.Parse(date_OP.Text).ToString("dd / MM / yyyy"); imp.crystalReportViewer1.ReportSource = C; imp.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } else { try { Impression imp = new Impression(); Crysta_MAD CM = new Crysta_MAD(); Declaration C = new Declaration(); TextObject t = (TextObject)CM.ReportDefinition.Sections[1].ReportObjects["Text3"]; t.Text = Nom_Doc; TextObject t1 = (TextObject)CM.ReportDefinition.Sections[1].ReportObjects["Text4"]; t1.Text = combo_banque.Text; TextObject t2 = (TextObject)CM.ReportDefinition.Sections[1].ReportObjects["Text8"]; t2.Text = "Par prélèvement sur notre compte n° " + txt_rib.Text + ", \n" + "nous vous prions de mettre à la disposition de \n " + txt_ben_pc.Text + "(C.I.N. n°" + txt_cin.Text + "),"; TextObject t3 = (TextObject)CM.ReportDefinition.Sections[1].ReportObjects["Text9"]; t3.Text = "La somme de " + txt_montant_chiffre.Text + " DH (" + C.IntToFr(int.Parse(txt_montant_chiffre.Text)) + ")."; imp.crystalReportViewer1.ReportSource = CM; imp.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
private void button2_Click(object sender, EventArgs e) { try { SqlConnection cnx = new SqlConnection(Connection); cnx.Open(); DateTime d; d = DateTime.Now; string req2 = "PS_ajouter_Document"; SqlCommand cmd2 = new SqlCommand(req2, cnx); cmd2.CommandType = CommandType.StoredProcedure; SqlParameter ps1 = cmd2.Parameters.Add("@P_NUM", SqlDbType.Int); SqlParameter ps2 = cmd2.Parameters.Add("@P_NOTE", SqlDbType.Text); SqlParameter ps4 = cmd2.Parameters.Add("@P_NUMCMPT", SqlDbType.VarChar, 24); SqlParameter ps5 = cmd2.Parameters.Add("@P_CIN ", SqlDbType.VarChar, 10); SqlParameter ps6 = cmd2.Parameters.Add("@P_NOM_PC", SqlDbType.Char, 50); SqlParameter ps7 = cmd2.Parameters.Add("@P_NOM_MORALE", SqlDbType.Char, 50); SqlParameter ps8 = cmd2.Parameters.Add("@P_RIB", SqlDbType.Char, 24); SqlParameter ps9 = cmd2.Parameters.Add("@P_DATEOP", SqlDbType.Date); SqlParameter ps10 = cmd2.Parameters.Add("@P_MONTANTOP", SqlDbType.Float); SqlParameter ps11 = cmd2.Parameters.Add("@P_TYPEOP", SqlDbType.VarChar, 50); SqlParameter ps12 = cmd2.Parameters.Add("@p_etat", SqlDbType.Char, 50); ps1.Value = int.Parse(txt_num.Text); if (txt_note.Text.Length == 0) { ps2.Value = "null"; } else { ps2.Value = txt_note.Text; } ps4.Value = txt_rib.Text; ps5.Value = txt_cin.Text; ps6.Value = txt_ben.Text; ps7.Value = "null"; ps8.Value = "null"; ps9.Value = DateTime.Parse(date_op.Text).ToString("dd / MM / yyyy"); ps10.Value = float.Parse(txt_montant_chiffre.Text); ps11.Value = combo_type_op.Text; ps12.Direction = ParameterDirection.Output; int i = cmd2.ExecuteNonQuery(); if (i == 1) { MessageBox.Show("Ajout avec succee"); } else { MessageBox.Show("Echec d ajout "); } cnx.Close(); DateTime now = DateTime.Now; string year = now.Year.ToString().Substring(2, 2);/*Ce code va nous permettre de prendre la partie de l'annee apres le 20 */ Impression imp = new Impression(); Crysta_MAD CM = new Crysta_MAD(); Declaration C = new Declaration(); TextObject t = (TextObject)CM.ReportDefinition.Sections[1].ReportObjects["Text3"]; t.Text = Nom_Doc; TextObject t1 = (TextObject)CM.ReportDefinition.Sections[1].ReportObjects["Text4"]; t1.Text = combo_banque.Text; TextObject t2 = (TextObject)CM.ReportDefinition.Sections[1].ReportObjects["Text8"]; t2.Text = "Par prélèvement sur notre compte n° " + txt_rib.Text + ", \n" + "nous vous prions de mettre à la disposition de \n " + txt_ben.Text + "(C.I.N. n°" + txt_cin.Text + "),"; TextObject t3 = (TextObject)CM.ReportDefinition.Sections[1].ReportObjects["Text9"]; t3.Text = "La somme de " + txt_montant_chiffre.Text + " DH (" + C.IntToFr(int.Parse(txt_montant_chiffre.Text)) + ")."; imp.crystalReportViewer1.ReportSource = CM; imp.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }