public reportes_CR(int emp)
{
InitializeComponent();
rpt_empleados emple = new rpt_empleados();
CRV.Refresh();
CRV.RefreshReport();
CRV.ReportSource = emple;
}
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();
}