public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CrystalReport2 rpt = new CrystalReport2();
rpt.Site = this.Site;
return(rpt);
}
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_doc.Text);
if (txt_note.Text.Length == 0)
{
ps2.Value = "null";
}
else
{
ps2.Value = txt_note.Text;
}
ps4.Value = txt_rib.Text;
if (txt_cin.Text.Length > 4)
{
ps5.Value = txt_cin.Text;
ps6.Value = txt_nom_ben.Text;
ps7.Value = "null";
}
else
{
ps6.Value = "null";
ps5.Value = "null";
ps7.Value = txt_nom_ben.Text;
}
ps8.Value = txt_rib_ben.Text;
ps9.Value = DateTime.Parse(date_OP.Text).ToString("dd / MM / yyyy");
ps10.Value = float.Parse(txt_montant_chiffre.Text);
if (combo_type_op.Text == "Autre")
{
ps11.Value = combo_type_op.Text;
}
else
{
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();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
Impression imp = new Impression();
CrystalReport2 C = new CrystalReport2();
TextObject t = (TextObject)C.ReportDefinition.Sections[1].ReportObjects["Text3"];
t.Text = Num_DOC_AN;
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 = typeop_zone.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_nom_ben.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();
}
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);
}
}
}
