Exemple #1
0
 private void llenarDiasChequePago()
 {
     controlador.Sql             = "select * from cheque";
     chequediasTBX.DataSource    = controlador.ConsultarTabla();
     chequediasTBX.DisplayMember = "diaspago".Trim();
     chequediasTBX.ValueMember   = "idcheque".Trim();
     chequediasTBX.Refresh();
 }
Exemple #2
0
        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();
        }