private void llenarDiasChequePago()
{
controlador.Sql = "select * from cheque";
chequediasTBX.DataSource = controlador.ConsultarTabla();
chequediasTBX.DisplayMember = "diaspago".Trim();
chequediasTBX.ValueMember = "idcheque".Trim();
chequediasTBX.Refresh();
}
private void ReporteComprasView()
{
controlador.Sql = "SELECT i.idingresos," +
"tc.nombre as 'tipocomprobante' ," +
"p.nombre as proveedor," +
"i.seriecomprobante," +
"i.timbrado," +
"i.fecha," +
"i.total," +
"fp.nombre as formapago," +
"c.diaspago" +
" FROM ingresos as i " +
"inner join proveedores as p on i.idproveedor = p.idproveedores " +
"inner join tipocomprobante as tc on tc.idtipocomprobante=i.idtipocomprobante " +
"left join formapago as fp on fp.idformapago = i.idformapago " +
"left join cheque as c on c.idcheque = i.idcheque";
ReportDataSource rds = new ReportDataSource();
rds.Name = "DataSetCompras";
rds.Value = controlador.ConsultarTabla();
comprasreporteV.LocalReport.DataSources.Clear();
comprasreporteV.LocalReport.DataSources.Add(rds);
comprasreporteV.LocalReport.ReportPath = "ReporteCompras.rdlc";
comprasreporteV.LocalReport.Refresh();
}