public Vehicle CreateVehicle(string model, string color, int numDoors, string[] options = string[0]) { Vehicle vehicle = null; if (model.Equals("Civic")) { // Ooh! My favorite! vehicle = new Civic(); vehicle.Doors = numDoors; vehicle.Color = color; vehicle.Options = options; } else if (model.Equals("Accord")) { // Only comes in 4 doors. So, ignore numDoors. vehicle = new Accord(); vehicle.Color = color; vehicle.Options = options; } else if (model.Equals("CR-V")) { // Only comes in 4 doors. So, ignore numDoors. vehicle = new CRV(); vehicle.Color = color; vehicle.Options = options; } else { throw new InvalidArgumentException("Cannot make requested model for Honda"); } return vehicle; }
private void Button1_Click(object sender, EventArgs e) { try { cryRpt.Load(CHEMINRPT); ConnectionInfo connectionInfo = new ConnectionInfo(); ConnectionInfo connectionInfo2 = connectionInfo; connectionInfo2.ServerName = "erp_db"; connectionInfo2.DatabaseName = ""; connectionInfo2.UserID = Globals.BDUSER; connectionInfo2.Password = Globals.BDPW; connectionInfo2.IntegratedSecurity = true; connectionInfo2 = null; TableLogOnInfos tableLogOnInfos = new TableLogOnInfos(); TableLogOnInfo tableLogOnInfo = new TableLogOnInfo(); Tables tables = cryRpt.Database.Tables; IEnumerator enumerator = default(IEnumerator); try { enumerator = tables.GetEnumerator(); while (enumerator.MoveNext()) { Table table = (Table)enumerator.Current; tableLogOnInfo = table.LogOnInfo; tableLogOnInfo.ConnectionInfo = connectionInfo; table.ApplyLogOnInfo(tableLogOnInfo); } } finally { if (enumerator is IDisposable) { (enumerator as IDisposable).Dispose(); } } cryRpt.SetParameterValue(PARAMFACT, NUMFACT.Text); cryRpt.SetParameterValue("REMISEPARAM", Globals.convertDN(REMVAL.Text)); cryRpt.SetParameterValue("TIMBREPARAM", Globals.convertDN(TIMVAL.Text)); cryRpt.SetParameterValue("Profil_Adresse", PROFIL); CRV.ReportSource = cryRpt; CRV.Refresh(); } catch (Exception ex) { ProjectData.SetProjectError(ex); Exception ex2 = ex; MessageBox.Show(ex2.Message); ProjectData.ClearProjectError(); } finally { if (Globals.conn != null) { Globals.conn.Close(); } } }
public reportes_CR(int emp) { InitializeComponent(); rpt_empleados emple = new rpt_empleados(); CRV.Refresh(); CRV.RefreshReport(); CRV.ReportSource = emple; }
public reportes_CR(string ss) { InitializeComponent(); rpt_edades CR = new rpt_edades(); CR.DataDefinition.FormulaFields["edad"].Text = "3"; //CR.SetDataSource(ss.ToList()); CRV.Refresh(); CRV.ReportSource = CR; }
public ActionResult buildVehicle(string make, string model, string color, int numDoors, string[] options = string[0]) { Vehicle vehicle = null; if (make.Equals("Honda")) { if (model.Equals("Civic")) { // Ooh! My favorite! vehicle = new Civic(); vehicle.Doors = numDoors; vehicle.Color = color; vehicle.Options = options; } else if (model.Equals("Accord")) { // Only comes in 4 doors. So, ignore numDoors. vehicle = new Accord(); vehicle.Color = color; vehicle.Options = options; } else if (model.Equals("CR-V")) { // Only comes in 4 doors. So, ignore numDoors. vehicle = new CRV(); vehicle.Color = color; vehicle.Options = options; } else { throw new InvalidArgumentException("Cannot make requested model for Honda"); } } else if (make.Equals("Chevrolet")) { if (model.Equals("Suburban")) { vehicle = new Suburban(); vehicle.Doors = numDoors; vehicle.Color = color; vehicle.Options = options; } else if (model.Equals("Silverado")) { vehicle = new Silverado(); vehicle.Doors = numDoors; vehicle.Color = color; vehicle.Options = options; } else { throw new InvalidArgumentException("Cannot make requested model for Chevrolet"); } } else if (make.Equals("BMW")) { // Pompus luxury vehicle. } else if (make.Equals("Ferrari")) { // Not likely in my lifetime. } else if (make.Equals("Lamborghini")) { // I wish. } // Save. this.vehicleContext.Attach(vehicle); this.vehicleContext.SaveAll(); // Display our newly created vehicle. return View("BuildVehicle", vehicle); }
private void Button5_Click(object sender, EventArgs e) { try { cryRpt.Load(CHEMINRPT); ConnectionInfo connectionInfo = new ConnectionInfo(); ConnectionInfo connectionInfo2 = connectionInfo; connectionInfo2.ServerName = "erp_db"; connectionInfo2.DatabaseName = ""; connectionInfo2.UserID = Globals.BDUSER; connectionInfo2.Password = Globals.BDPW; connectionInfo2.IntegratedSecurity = true; connectionInfo2 = null; TableLogOnInfos tableLogOnInfos = new TableLogOnInfos(); TableLogOnInfo tableLogOnInfo = new TableLogOnInfo(); Tables tables = cryRpt.Database.Tables; IEnumerator enumerator = default(IEnumerator); try { enumerator = tables.GetEnumerator(); while (enumerator.MoveNext()) { Table table = (Table)enumerator.Current; tableLogOnInfo = table.LogOnInfo; tableLogOnInfo.ConnectionInfo = connectionInfo; table.ApplyLogOnInfo(tableLogOnInfo); } } finally { if (enumerator is IDisposable) { (enumerator as IDisposable).Dispose(); } } ParameterValues parameterValues = new ParameterValues(); ParameterDiscreteValue parameterDiscreteValue = new ParameterDiscreteValue(); parameterDiscreteValue.Value = NUMFACT.Text; ParameterFieldDefinitions parameterFields = cryRpt.DataDefinition.ParameterFields; ParameterFieldDefinition parameterFieldDefinition = parameterFields[PARAMFACT]; parameterValues = parameterFieldDefinition.CurrentValues; parameterValues.Clear(); parameterValues.Add(parameterDiscreteValue); parameterFieldDefinition.ApplyCurrentValues(parameterValues); CRV.ReportSource = cryRpt; CRV.Refresh(); } catch (Exception ex) { ProjectData.SetProjectError(ex); Exception ex2 = ex; MessageBox.Show(ex2.Message); ProjectData.ClearProjectError(); } finally { if (Globals.conn != null) { Globals.conn.Close(); } } try { DiskFileDestinationOptions diskFileDestinationOptions = new DiskFileDestinationOptions(); PdfRtfWordFormatOptions formatOptions = new PdfRtfWordFormatOptions(); NOMFICHJOINT = Nommail + " " + DateTime.Now.ToString("yyyy_MM_dd HH_mm_ss"); diskFileDestinationOptions.DiskFileName = "C:\\SIGC utility\\Fichier joint\\" + NOMFICHJOINT + ".pdf"; MyProject.Forms.Mail.chemin.Text = "C:\\SIGC utility\\Fichier joint\\" + NOMFICHJOINT + ".pdf"; ExportOptions exportOptions = cryRpt.ExportOptions; ExportOptions exportOptions2 = exportOptions; exportOptions2.ExportDestinationType = ExportDestinationType.DiskFile; exportOptions2.ExportFormatType = ExportFormatType.PortableDocFormat; exportOptions2.DestinationOptions = diskFileDestinationOptions; exportOptions2.FormatOptions = formatOptions; exportOptions2 = null; cryRpt.Export(); MyProject.Forms.Mail.Show(); MyProject.Forms.Mail.BringToFront(); MyProject.Forms.Mail.pathT.Text = "C:\\SIGC utility\\Fichier joint\\" + NOMFICHJOINT + ".pdf"; MyProject.Forms.Mail.AjoutFJ_Click(RuntimeHelpers.GetObjectValue(sender), e); } catch (Exception ex3) { ProjectData.SetProjectError(ex3); Exception ex4 = ex3; Interaction.MsgBox(ex4.ToString(), MsgBoxStyle.OkOnly, null); ProjectData.ClearProjectError(); } }
public void Frm_Fact_Load(object sender, EventArgs e) { try { LB_Article.SelectedItem = "Profil Nb"; if (Operators.CompareString(TYPEFACT, "D", false) == 0) { PARAMFACT = "NUMDEVIS"; TABLEFACT = "DEVIS"; CHEMINRPT = "C:\\SIGC utility\\Reports\\Report_Devis.rpt"; Label1.Text = "Entrer Num Devis"; Button1.Text = "Afficher Devis"; Nommail = "Devis"; Text = "Devis"; } else if (Operators.CompareString(TYPEFACT, "F", false) == 0) { PARAMFACT = "NUMTICKET"; TABLEFACT = "TICKET"; CHEMINRPT = "C:\\SIGC utility\\Reports\\Report_Facture.rpt"; Label1.Text = "Entrer Num Facture"; Button1.Text = "Afficher Facture"; Text = "Facture"; Nommail = "Facture"; } else if (Operators.CompareString(TYPEFACT, "TIC", false) == 0) { PARAMFACT = "NUMTICKET"; TABLEFACT = "TICKET"; CHEMINRPT = "C:\\SIGC utility\\Reports\\Report_Ticket.rpt"; Label1.Text = "Entrer Num Ticket"; Button1.Text = "Afficher Ticket"; Text = "Ticket"; Nommail = "Ticket"; } else if (Operators.CompareString(TYPEFACT, "BC", false) == 0) { PARAMFACT = "NUMBC"; TABLEFACT = "BONC"; CHEMINRPT = "C:\\SIGC utility\\Reports\\Report_BC.rpt"; Label1.Text = "Entrer Num Bon C."; Button1.Text = "Afficher Bon C."; Text = "Bon Commande"; Nommail = "BC"; } else if (Operators.CompareString(TYPEFACT, "BL", false) == 0) { PARAMFACT = "NUMBL"; TABLEFACT = "BONL"; CHEMINRPT = "C:\\SIGC utility\\Reports\\Report_BL.rpt"; Label1.Text = "Entrer Num Bon L."; Button1.Text = "Afficher Bon L."; Text = "Bon livraison"; Nommail = "BL"; } else if (Operators.CompareString(TYPEFACT, "DA", false) == 0) { PARAMFACT = "NUMDEVIS"; TABLEFACT = "A_DEVIS"; CHEMINRPT = "C:\\SIGC utility\\Reports\\Report_A_Devis.rpt"; Label1.Text = "Entrer Num Devis"; Button1.Text = "Afficher Devis Achat"; Text = "Devis Achat"; Nommail = "Devis Achat"; } else if (Operators.CompareString(TYPEFACT, "BCA", false) == 0) { PARAMFACT = "NUMBONC"; TABLEFACT = "A_BONC"; CHEMINRPT = "C:\\SIGC utility\\Reports\\Report_A_BONC.rpt"; Label1.Text = "Entrer Num Bon C."; Button1.Text = "Afficher Bon C."; Text = "Bon Commande Achat"; Nommail = "BC Achat"; } else if (Operators.CompareString(TYPEFACT, "BLA", false) == 0) { PARAMFACT = "NUMBONL"; TABLEFACT = "A_BONL"; CHEMINRPT = "C:\\SIGC utility\\Reports\\Report_A_BONL.rpt"; Label1.Text = "Entrer Num Bon L."; Button1.Text = "Afficher Bon L."; Text = "Bon livraison Achat"; Nommail = "BL Achat"; } else if (Operators.CompareString(TYPEFACT, "FA", false) == 0) { PARAMFACT = "NUMFACT"; TABLEFACT = "A_FACTURE"; CHEMINRPT = "C:\\SIGC utility\\Reports\\Report_A_Facture.rpt"; Label1.Text = "Entrer Num Facture"; Button1.Text = "Afficher Facture"; Text = "Facture Achat"; Nommail = "Facture Achat"; } if (Globals.conn.State == ConnectionState.Closed) { Globals.conn.Open(); } Globals.cmd.Connection = Globals.conn; Globals.cmd.CommandText = "select REMISE,TIMBRE from " + TABLEFACT + " where NUM_FACT ='" + NUMFACT.Text + "'"; MySqlDataReader mySqlDataReader = Globals.cmd.ExecuteReader(); Globals.cmd.CommandType = CommandType.Text; if (mySqlDataReader.Read()) { string text = mySqlDataReader["REMISE"].ToString(); if (string.IsNullOrEmpty(text) | decimal.Compare(Globals.convertDN(text), decimal.Zero) == 0) { REMISE.Checked = false; REMVAL.Visible = false; REMVAL.Text = "0"; } else { REMISE.Checked = true; REMVAL.Visible = true; REMVAL.Text = text; } string text2 = mySqlDataReader["TIMBRE"].ToString(); if (string.IsNullOrEmpty(text2) | decimal.Compare(Globals.convertDN(text2), decimal.Zero) == 0) { TIMBRE.Checked = false; TIMVAL.Visible = false; TIMVAL.Text = "0"; } else { TIMBRE.Checked = true; TIMVAL.Visible = true; TIMVAL.Text = text2; } } mySqlDataReader.Close(); mySqlDataReader.Dispose(); if (Globals.conn != null) { Globals.conn.Close(); } cryRpt.Load(CHEMINRPT); ConnectionInfo connectionInfo = new ConnectionInfo(); ConnectionInfo connectionInfo2 = connectionInfo; connectionInfo2.ServerName = "erp_db"; connectionInfo2.DatabaseName = ""; connectionInfo2.UserID = Globals.BDUSER; connectionInfo2.Password = Globals.BDPW; connectionInfo2.IntegratedSecurity = true; connectionInfo2 = null; TableLogOnInfos tableLogOnInfos = new TableLogOnInfos(); TableLogOnInfo tableLogOnInfo = new TableLogOnInfo(); Tables tables = cryRpt.Database.Tables; IEnumerator enumerator = default(IEnumerator); try { enumerator = tables.GetEnumerator(); while (enumerator.MoveNext()) { Table table = (Table)enumerator.Current; tableLogOnInfo = table.LogOnInfo; tableLogOnInfo.ConnectionInfo = connectionInfo; table.ApplyLogOnInfo(tableLogOnInfo); } } finally { if (enumerator is IDisposable) { (enumerator as IDisposable).Dispose(); } } cryRpt.SetParameterValue(PARAMFACT, NUMFACT.Text); if (Operators.CompareString(TYPEFACT, "TIC", false) != 0) { cryRpt.SetParameterValue("REMISEPARAM", Globals.convertDN(REMVAL.Text)); cryRpt.SetParameterValue("TIMBREPARAM", Globals.convertDN(TIMVAL.Text)); cryRpt.SetParameterValue("Profil_Adresse", PROFIL); } CRV.ReportSource = cryRpt; CRV.Refresh(); Nom_mail.Text = Nommail; } catch (Exception ex) { ProjectData.SetProjectError(ex); Exception ex2 = ex; MessageBox.Show(ex2.Message); ProjectData.ClearProjectError(); } finally { if (Globals.conn != null) { Globals.conn.Close(); } } }
private void FrmFacture_Load(object sender, EventArgs e) { try { ReportDocument reportDocument = new ReportDocument(); reportDocument.Load("C:\\SIGC utility\\Reports\\Report_Facture.rpt"); ConnectionInfo connectionInfo = new ConnectionInfo(); ConnectionInfo connectionInfo2 = connectionInfo; connectionInfo2.ServerName = "erp_db"; connectionInfo2.DatabaseName = ""; connectionInfo2.UserID = Globals.BDUSER; connectionInfo2.Password = Globals.BDPW; connectionInfo2.IntegratedSecurity = false; connectionInfo2 = null; TableLogOnInfos tableLogOnInfos = new TableLogOnInfos(); TableLogOnInfo tableLogOnInfo = new TableLogOnInfo(); Tables tables = reportDocument.Database.Tables; IEnumerator enumerator = default(IEnumerator); try { enumerator = tables.GetEnumerator(); while (enumerator.MoveNext()) { Table table = (Table)enumerator.Current; tableLogOnInfo = table.LogOnInfo; tableLogOnInfo.ConnectionInfo = connectionInfo; table.ApplyLogOnInfo(tableLogOnInfo); } } finally { if (enumerator is IDisposable) { (enumerator as IDisposable).Dispose(); } } ParameterValues parameterValues = new ParameterValues(); ParameterDiscreteValue parameterDiscreteValue = new ParameterDiscreteValue(); if (Operators.CompareString(NUMFACT.Text, "", false) != 0) { parameterDiscreteValue.Value = NUMFACT.Text; } else { parameterDiscreteValue.Value = "0"; } ParameterFieldDefinitions parameterFields = reportDocument.DataDefinition.ParameterFields; ParameterFieldDefinition parameterFieldDefinition = parameterFields["NUMTICKET"]; parameterValues = parameterFieldDefinition.CurrentValues; parameterValues.Clear(); parameterValues.Add(parameterDiscreteValue); parameterFieldDefinition.ApplyCurrentValues(parameterValues); CRV.ReportSource = reportDocument; CRV.Refresh(); } catch (Exception ex) { ProjectData.SetProjectError(ex); Exception ex2 = ex; MessageBox.Show(ex2.Message); ProjectData.ClearProjectError(); } finally { if (Globals.conn != null) { Globals.conn.Close(); } } }
private void Stat_Stock_Load(object sender, EventArgs e) { try { MySqlCommand mySqlCommand = new MySqlCommand(); MySqlDataAdapter mySqlDataAdapter = new MySqlDataAdapter(mySqlCommand); DataSet dataSet = new DataSet(); if (Globals.conn.State == ConnectionState.Closed) { Globals.conn.Open(); } mySqlCommand.Connection = Globals.conn; mySqlCommand.CommandText = "select distinct REFART from ARTICLE_D"; mySqlDataAdapter.Fill(dataSet, "list"); AutoCompleteStringCollection autoCompleteStringCollection = new AutoCompleteStringCollection(); ReportDocument reportDocument; ConnectionInfo connectionInfo; Tables tables; checked { int num = dataSet.Tables[0].Rows.Count - 1; for (int i = 0; i <= num; i++) { autoCompleteStringCollection.Add(dataSet.Tables[0].Rows[i]["REFART"].ToString()); } REFART.AutoCompleteSource = AutoCompleteSource.CustomSource; REFART.AutoCompleteCustomSource = autoCompleteStringCollection; REFART.AutoCompleteMode = AutoCompleteMode.Suggest; reportDocument = new ReportDocument(); reportDocument.Load("C:\\SIGC utility\\Reports\\Report_Suivi_Stock.rpt"); connectionInfo = new ConnectionInfo(); ConnectionInfo connectionInfo2 = connectionInfo; connectionInfo2.ServerName = "erp_db"; connectionInfo2.DatabaseName = ""; connectionInfo2.UserID = Globals.BDUSER; connectionInfo2.Password = Globals.BDPW; connectionInfo2.IntegratedSecurity = false; connectionInfo2 = null; TableLogOnInfos tableLogOnInfos = new TableLogOnInfos(); TableLogOnInfo tableLogOnInfo = new TableLogOnInfo(); tables = reportDocument.Database.Tables; } IEnumerator enumerator = default(IEnumerator); try { enumerator = tables.GetEnumerator(); while (enumerator.MoveNext()) { Table table = (Table)enumerator.Current; TableLogOnInfo tableLogOnInfo = table.LogOnInfo; tableLogOnInfo.ConnectionInfo = connectionInfo; table.ApplyLogOnInfo(tableLogOnInfo); } } finally { if (enumerator is IDisposable) { (enumerator as IDisposable).Dispose(); } } ParameterValues parameterValues = new ParameterValues(); ParameterDiscreteValue parameterDiscreteValue = new ParameterDiscreteValue(); parameterDiscreteValue.Value = REFART.Text; ParameterFieldDefinitions parameterFields = reportDocument.DataDefinition.ParameterFields; ParameterFieldDefinition parameterFieldDefinition = parameterFields["REFART_P"]; parameterValues = parameterFieldDefinition.CurrentValues; parameterValues.Clear(); parameterValues.Add(parameterDiscreteValue); parameterFieldDefinition.ApplyCurrentValues(parameterValues); CRV.ReportSource = reportDocument; CRV.Refresh(); if (Globals.conn != null) { Globals.conn.Close(); } } catch (Exception ex) { ProjectData.SetProjectError(ex); Exception ex2 = ex; MessageBox.Show(ex2.Message); ProjectData.ClearProjectError(); } finally { if (Globals.conn != null) { Globals.conn.Close(); } } }
private void Button1_Click(object sender, EventArgs e) { try { base.WindowState = FormWindowState.Maximized; ReportDocument reportDocument = new ReportDocument(); reportDocument.Load("C:\\SIGC utility\\Reports\\Report_perso_imprim.rpt"); ConnectionInfo connectionInfo = new ConnectionInfo(); ConnectionInfo connectionInfo2 = connectionInfo; connectionInfo2.ServerName = "erp_db"; connectionInfo2.DatabaseName = ""; connectionInfo2.UserID = Globals.BDUSER; connectionInfo2.Password = Globals.BDPW; connectionInfo2.IntegratedSecurity = false; connectionInfo2 = null; TableLogOnInfos tableLogOnInfos = new TableLogOnInfos(); TableLogOnInfo tableLogOnInfo = new TableLogOnInfo(); Tables tables = reportDocument.Database.Tables; IEnumerator enumerator = default(IEnumerator); try { enumerator = tables.GetEnumerator(); while (enumerator.MoveNext()) { Table table = (Table)enumerator.Current; tableLogOnInfo = table.LogOnInfo; tableLogOnInfo.ConnectionInfo = connectionInfo; table.ApplyLogOnInfo(tableLogOnInfo); } } finally { if (enumerator is IDisposable) { (enumerator as IDisposable).Dispose(); } } ParameterValues parameterValues = new ParameterValues(); ParameterDiscreteValue parameterDiscreteValue = new ParameterDiscreteValue(); parameterDiscreteValue.Value = CODE_PERSO.Text; ParameterFieldDefinitions parameterFields = reportDocument.DataDefinition.ParameterFields; ParameterFieldDefinition parameterFieldDefinition = parameterFields["code_perso"]; parameterValues = parameterFieldDefinition.CurrentValues; parameterValues.Clear(); parameterValues.Add(parameterDiscreteValue); parameterFieldDefinition.ApplyCurrentValues(parameterValues); CRV.ReportSource = reportDocument; CRV.Refresh(); } catch (Exception ex) { ProjectData.SetProjectError(ex); Exception ex2 = ex; MessageBox.Show(ex2.Message); ProjectData.ClearProjectError(); } finally { if (Globals.conn != null) { Globals.conn.Close(); } } }
public reportes_CR(string empresa, string localidad, string cuit, string estudio, string desde, string hasta, string domicilio, string per_pagado, string per_NO_pagado, string per_NO_declarado, string per_total, string aporte_ley, string aporte_socio, string total_aportes, string depositado, string intereses, string total_capital, string total_deuda, double cuit2 ) //txt_actas_pagados.Text, txt_actas_no_pagados.Text, txt_actas_no_declarados.Text, txt_actas_total_periodos.Text, //txt_actas_aporte2.Text, txt_actas_aportes_socio.Text, txt_actas_depositado.Text, txt_actas_intereses.Text, //txt_actas_total_con_interes.Text { InitializeComponent(); rpt_consulta_empresa CR = new rpt_consulta_empresa(); //System.Configuration. .ConfigurationSettings.AppSettings["ConexionCadena"].ToString(); //System.Configuration. .ConfigurationSettings.AppSettings["ConexionCadena"].ToString(); //CR.DataSourceConnections[0].SetConnection("192.168.1.253", "sindicato", false); //CR.DataSourceConnections[0].SetLogon("sec", "nosenose101"); //CR.DataSourceConnections = db_sindicato.impresion_comprobante; CR.DataDefinition.FormulaFields["empresa"].Text = "'" + empresa + "'"; CR.DataDefinition.FormulaFields["localidad"].Text = "'" + localidad + "'"; CR.DataDefinition.FormulaFields["cuit"].Text = "'" + cuit + "'"; CR.DataDefinition.FormulaFields["estudio"].Text = "'" + estudio + "'"; CR.DataDefinition.FormulaFields["desde"].Text = "'" + desde + "'"; CR.DataDefinition.FormulaFields["hasta"].Text = "'" + hasta + "'";//"'" + hasta.Substring(0, 2) + "-" + hasta.Substring(3, 8) + "-" + hasta.Substring(9, 1) + "'"; CR.DataDefinition.FormulaFields["domicilio"].Text = "'" + domicilio + "'"; CR.DataDefinition.FormulaFields["per_pagado"].Text = "'" + per_pagado + "'"; CR.DataDefinition.FormulaFields["per_NO_pagado"].Text = "'" + per_NO_pagado + "'"; CR.DataDefinition.FormulaFields["per_NO_declarado"].Text = "'" + per_NO_declarado + "'"; CR.DataDefinition.FormulaFields["per_total"].Text = "'" + per_total + "'"; CR.DataDefinition.FormulaFields["aporte_ley"].Text = "'" + aporte_ley + "'"; CR.DataDefinition.FormulaFields["aporte_total"].Text = "'" + total_aportes + "'"; CR.DataDefinition.FormulaFields["aporte_socio"].Text = "'" + aporte_socio + "'"; CR.DataDefinition.FormulaFields["depositado"].Text = "'" + depositado + "'"; CR.DataDefinition.FormulaFields["intereses"].Text = "'" + intereses + "'"; CR.DataDefinition.FormulaFields["capital"].Text = "'" + total_capital + "'"; CR.DataDefinition.FormulaFields["total_deuda"].Text = "'" + total_deuda + "'"; var actas_involucradas = (from act in db_sindicato.ACTAS where act.CUIT == Convert.ToInt64(cuit2) select new { Fecha = String.Format("{0:d}", act.DESDE), // act.FECHA == null ? "" : act.FECHA.ToString(), Acta = Convert.ToInt64(act.ACTA).ToString(), // act.ACTA == null ? "" : act.ACTA.ToString(),//.ToString(), //cuit = act.CUIT.ToString() , Desde = String.Format("{0:MM/yyyy}", act.DESDE), // act.DESDE.Value.Month.ToString() + "/" + act.DESDE.Value.Year.ToString() , Hasta = String.Format("{0:MM/yyyy}", act.HASTA), // act.HASTA.Value.Month.ToString() + "/" + act.HASTA.Value.Year.ToString() , Deudatotal = String.Format("{0:C}", act.DEUDATOTAL), Cobradototalmente = act.COBRADOTOTALMENTE == null ? "NO" : act.COBRADOTOTALMENTE, Inspector = act.INSPECTOR }).ToList(); CR.Subreports[0].SetDataSource(actas_involucradas); var act_ = actas_involucradas.ToList(); var comprobantes_actas = (from comp in db_sindicato.COBROS where comp.CUIT == Convert.ToDouble(cuit2) select new { //cobro_id = comp.Id, //cuota = (comp.CONCEPTO == "2") ? (comp.CUOTAX.ToString() + " de " + comp.CANTIDAD_CUOTAS.ToString()) : ("Anticipo"), //fecha_venc = comp.FECHA_VENC, acta = comp.ACTA, FECHARECAUDACION = comp.FECHARECAUDACION, RECIBO = comp.RECIBO, TOTAL = comp.TOTAL }).ToList(); foreach (var item in comprobantes_actas) { impresion_actas comp_act = new impresion_actas(); comp_act.num3 = Convert.ToDecimal(item.acta); comp_act.fecha1 = item.FECHARECAUDACION; comp_act.num1 = Convert.ToDecimal(item.RECIBO); comp_act.importe = Convert.ToDecimal(item.TOTAL); db_sindicato.impresion_actas.InsertOnSubmit(comp_act); db_sindicato.SubmitChanges(); } //CR.Subreports[1].SetDataSource(db_sindicato.impresion_actas); //CR.Subreports[1].Refresh(); CRV.ReportSource = CR; CRV.RefreshReport(); }