public void CrearDataSetCompleto() { dsAlmacen = new DsAlmacen(); daCliente = new DsAlmacenTableAdapters.ClienteTableAdapter(); daCliente.Fill(dsAlmacen.Cliente); daPedido = new DsAlmacenTableAdapters.PedidoTableAdapter(); daPedido.Fill(dsAlmacen.Pedido); daEmpleado = new DsAlmacenTableAdapters.EmpleadoTableAdapter(); daEmpleado.Fill(dsAlmacen.Empleado); daProducto = new DsAlmacenTableAdapters.ProductoTableAdapter(); daProducto.Fill(dsAlmacen.Producto); daDetalles = new DsAlmacenTableAdapters.DetallesPedidoTableAdapter(); daDetalles.Fill(dsAlmacen.DetallesPedido); daCategoria = new DsAlmacenTableAdapters.CategoriaTableAdapter(); daCategoria.Fill(dsAlmacen.Categoria); daProveedor = new DsAlmacenTableAdapters.ProveedorTableAdapter(); daProveedor.Fill(dsAlmacen.Proveedor); }
public ClienteDataTable CarregarTabela() { tbl.Clear(); try { ta.Fill(tbl); } catch (System.Data.SqlClient.SqlException ex) { Console.WriteLine(ex.Message); } return(tbl); }
private void lanza_impresion_electronicos() { BD basedatos = new BD(); string strPagos = "select Plazo, SUM(Prestamo) Prestamo, SUM(Avaluo) Avaluo from PRESTO.dbo.Boleta_Detalle where Boleta_Id=" + boleta_id + " group by Plazo"; SqlDataAdapter da = new SqlDataAdapter(strPagos, basedatos.conexionsql()); DataSet ds = new DataSet(); try { da.Fill(ds); } catch (Exception ex) { MessageBox.Show(ex.Message); } //PRESTODataSet.PagosDataTable dt = new PRESTODataSet.PagosDataTable(); DataTable dt = new DataTable("Pagos"); dt.Columns.Add("IdBoleta", typeof(int)); dt.Columns.Add("Importe", typeof(double)); dt.Columns.Add("Interes", typeof(double)); dt.Columns.Add("Almacenaje", typeof(double)); dt.Columns.Add("IVA", typeof(double)); dt.Columns.Add("PorRefrendo", typeof(double)); dt.Columns.Add("PorDesempenio", typeof(double)); dt.Columns.Add("FechaPago", typeof(string)); dt.Columns.Add("Fecha_Semana", typeof(string)); dt.Columns.Add("Linea", typeof(string)); if (ds != null) { if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { switch (ds.Tables[0].Rows[0][0].ToString()) { case "1": default: double Prestamo = Convert.ToDouble(ds.Tables[0].Rows[0][1]); for (int i = 1; i < 5; i++) { DataRow dr = dt.NewRow(); dr[0] = boleta_id; dr[1] = Prestamo; //double Interes = (Prestamo * .00486) * (i * 7); //0.00397 //4069 double Interes = (Prestamo * 0.004069) * (i * 7); dr[2] = Math.Round(Interes, 2); double Almacenaje = Prestamo * 0.006 * i; dr[3] = Math.Round(Almacenaje, 2); double IVA = (Interes + Almacenaje) * 0.16; dr[4] = Math.Round(IVA, 2); double Refrendo = (Interes + Almacenaje + IVA); dr[5] = Math.Round(Refrendo, 2); dr[6] = Prestamo + Refrendo; dr[7] = "S " + i.ToString() + "-hasta el->" + DateTime.Now.AddDays(i * 7).ToString("dd/MM/yyyy"); dr[8] = DateTime.Now.AddDays(i * 7).ToString("dd/MM/yyyy"); dr[9] = i * 1; dt.Rows.Add(dr); } break; } } } } foreach (DataRow dr in dt.Rows) { try { SqlCommand cmd = new SqlCommand("Insert Into Pagos Values(" + dr[0] + "," + dr[1] + "," + dr[2] + "," + dr[3] + "," + dr[4] + "," + dr[5] + "," + dr[6] + ",'" + dr[7] + "','" + dr[8] + "','" + dr[9] + "')", basedatos.conexionsql()); cmd.Connection.Open(); cmd.ExecuteNonQuery(); cmd.Connection.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } reportViewer1.LocalReport.DataSources.Clear(); Boleta_EncabezadoTableAdapter.Fill(PRESTODataSet.Boleta_Encabezado, boleta_id); Boleta_DetalleTableAdapter.Fill(PRESTODataSet.Boleta_Detalle, boleta_id); InteresesTableAdapter.Fill(PRESTODataSet.Intereses); ClienteTableAdapter.Fill(PRESTODataSet.Cliente, cliente_id); SucursalTableAdapter.Fill(PRESTODataSet.Sucursal, 1); reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("dsEmpenio", dt)); reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("dsBoleta_Encabezado", PRESTODataSet.Tables["Boleta_Encabezado"])); reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("dsBoletaDetalle", PRESTODataSet.Tables["Boleta_Detalle"])); reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("dsIntereses", PRESTODataSet.Tables["Intereses"])); reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("dsCliente", PRESTODataSet.Tables["Cliente"])); reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("dsSucursal", PRESTODataSet.Tables["Sucursal"])); this.reportViewer1.RefreshReport(); }
public override void Atualiza_Grid() { try { this.Text = lblNomeTab.Text = "Clientes"; DB_ConceptDataSet.ClienteDataTable dt = new DB_ConceptDataSet.ClienteDataTable(); ClienteTableAdapter ta = new ClienteTableAdapter(); // dt=ta.GetData DB_ConceptDataSet ds = new DB_ConceptDataSet(); ta.Fill(ds.Cliente); dB_ConceptDataSetbindingSource.DataSource = ds.Cliente; dgvConsulta.DataSource = dB_ConceptDataSetbindingSource; //Config Das Colunas do DGV dgvConsulta.Columns[0].HeaderText = "Cod."; dgvConsulta.Columns[0].Width = 45; dgvConsulta.Columns[1].HeaderText = "Nome"; dgvConsulta.Columns[1].Width = 200; dgvConsulta.Columns[2].HeaderText = "Endereço"; dgvConsulta.Columns[2].Width = 150; dgvConsulta.Columns[3].HeaderText = "N°"; dgvConsulta.Columns[3].Width = 50; dgvConsulta.Columns[4].HeaderText = "Bairro"; dgvConsulta.Columns[4].Width = 150; dgvConsulta.Columns[5].HeaderText = "CEP"; dgvConsulta.Columns[5].Width = 85; dgvConsulta.Columns[6].HeaderText = "Complemento"; dgvConsulta.Columns[6].Width = 150; dgvConsulta.Columns[7].HeaderText = "Cidade"; dgvConsulta.Columns[7].Width = 100; dgvConsulta.Columns[8].HeaderText = "UF"; dgvConsulta.Columns[8].Width = 35; dgvConsulta.Columns[9].HeaderText = "Tel"; dgvConsulta.Columns[9].Width = 125; dgvConsulta.Columns[10].HeaderText = "Cel"; dgvConsulta.Columns[10].Width = 125; dgvConsulta.Columns[11].HeaderText = "E-mail"; dgvConsulta.Columns[11].Width = 150; dgvConsulta.Columns[12].HeaderText = "RG"; dgvConsulta.Columns[12].Width = 100; dgvConsulta.Columns[13].HeaderText = "CPF"; dgvConsulta.Columns[13].Width = 110; dgvConsulta.Columns[14].HeaderText = "Data Nasc."; dgvConsulta.Columns[14].Width = 105; dgvConsulta.Columns[15].HeaderText = "Sexo"; dgvConsulta.Columns[15].Width = 50; dgvConsulta.Columns[16].HeaderText = "Obs"; dgvConsulta.Columns[16].Width = 200; //Carrega as combos com as colunas if (cmbColuna.Items.Count == 0) { foreach (DataColumn coluna in ds.Cliente.Columns) { cmbColuna.Items.Add(coluna.ColumnName); } } cmbColuna.SelectedIndex = 1; dtGenerico = ds.Cliente; } catch (Exception) { } }
public override void Atualiza_Grid() { try { this.Text = lblNomeTab.Text = "Clientes"; DB_ConceptDataSet.ClienteDataTable dt = new DB_ConceptDataSet.ClienteDataTable(); ClienteTableAdapter ta = new ClienteTableAdapter(); // dt=ta.GetData DB_ConceptDataSet ds = new DB_ConceptDataSet(); ta.Fill(ds.Cliente); dB_ConceptBindingSource2.DataSource = ds.Cliente; dgvPesquisa.DataSource = dB_ConceptBindingSource2; //Config Das Colunas do DGV dgvPesquisa.Columns[0].HeaderText = "Cod."; dgvPesquisa.Columns[0].Width = 55; dgvPesquisa.Columns[1].HeaderText = "Nome"; dgvPesquisa.Columns[1].Width = 290; dgvPesquisa.Columns[2].HeaderText = "Endereço"; dgvPesquisa.Columns[2].Width = 170; dgvPesquisa.Columns[3].HeaderText = "N°"; dgvPesquisa.Columns[3].Width = 50; dgvPesquisa.Columns[4].HeaderText = "Bairro"; dgvPesquisa.Columns[4].Width = 150; dgvPesquisa.Columns[5].HeaderText = "CEP"; dgvPesquisa.Columns[5].Width = 90; dgvPesquisa.Columns[6].HeaderText = "Complemento"; dgvPesquisa.Columns[6].Width = 150; dgvPesquisa.Columns[7].HeaderText = "Cidade"; dgvPesquisa.Columns[7].Width = 100; dgvPesquisa.Columns[8].HeaderText = "UF"; dgvPesquisa.Columns[8].Width = 45; dgvPesquisa.Columns[9].HeaderText = "Tel"; dgvPesquisa.Columns[9].Width = 140; dgvPesquisa.Columns[10].HeaderText = "Cel"; dgvPesquisa.Columns[10].Width = 140; dgvPesquisa.Columns[11].HeaderText = "E-mail"; dgvPesquisa.Columns[11].Width = 150; dgvPesquisa.Columns[12].HeaderText = "RG"; dgvPesquisa.Columns[12].Width = 110; dgvPesquisa.Columns[13].HeaderText = "CPF"; dgvPesquisa.Columns[13].Width = 130; dgvPesquisa.Columns[14].HeaderText = "Data Nasc."; dgvPesquisa.Columns[14].Width = 100; dgvPesquisa.Columns[15].HeaderText = "Sexo"; dgvPesquisa.Columns[15].Width = 60; dgvPesquisa.Columns[16].HeaderText = "Obs"; dgvPesquisa.Columns[16].Width = 200; //Carrega as combos com as colunas if (cmbColuna.Items.Count == 0) { foreach (DataColumn coluna in ds.Cliente.Columns) { cmbColuna.Items.Add(coluna.ColumnName); } } /*if (cmbColuna.Items.Count == 0) * { * for (int i = 0; i < 17; i++) * { * cmbColuna.Items.Add(dgvConsulta.Columns[i].HeaderText); * * } * }*/ dtGenerico = ds.Cliente; cmbColuna.Text = "Nome_Cli"; cmbBuscar.SelectedItem = "Que começa com"; txtParam1.Visible = true; } catch (Exception) { } }
private void lanza_impresion_electronicos() { BD basedatos = new BD(); string strPagos = "Select Prestamo,Avaluo,Boleta_Fecha from Boleta_encabezado Where Boleta_id=" + boleta_id + ""; SqlDataAdapter da = new SqlDataAdapter(strPagos, basedatos.conexionsql()); DataSet ds = new DataSet(); try { da.Fill(ds); } catch (Exception ex) { MessageBox.Show(ex.Message); } //PRESTODataSet.PagosDataTable dt = new PRESTODataSet.PagosDataTable(); DataTable dt = new DataTable("Pagos"); dt.Columns.Add("IdBoleta", typeof(int)); dt.Columns.Add("Importe", typeof(double)); dt.Columns.Add("Interes", typeof(double)); dt.Columns.Add("Almacenaje", typeof(double)); dt.Columns.Add("IVA", typeof(double)); dt.Columns.Add("PorRefrendo", typeof(double)); dt.Columns.Add("PorDesempenio", typeof(double)); dt.Columns.Add("FechaPago", typeof(string)); if (ds != null) { if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { switch (ds.Tables[0].Rows[0][0].ToString()) { case "1": default: double Prestamo = Convert.ToDouble(ds.Tables[0].Rows[0][0]); DateTime fecha = Convert.ToDateTime(ds.Tables[0].Rows[0][2]); for (int i = 1; i < 5; i++) { DataRow dr = dt.NewRow(); dr[0] = boleta_id; dr[1] = Prestamo; //double Interes = (Prestamo * .00486) * (i * 7); double Interes = (Prestamo * .00454) * (i * 7); dr[2] = Math.Round(Interes, 2); double Almacenaje = Prestamo * 0.006 * i; dr[3] = Math.Round(Almacenaje, 2); double IVA = (Interes + Almacenaje) * 0.16; dr[4] = Math.Round(IVA, 2); double Refrendo = (Interes + Almacenaje + IVA); dr[5] = Math.Round(Refrendo, 2); dr[6] = Prestamo + Refrendo; dr[7] = "S " + i.ToString() + "-hasta el->" + fecha.AddDays(i * 7).ToString("dd/MM/yyyy"); dt.Rows.Add(dr); } break; } } } } reportViewer1.LocalReport.DataSources.Clear(); Boleta_EncabezadoTableAdapter.Fill(PRESTODataSet.Boleta_Encabezado, boleta_id); Boleta_DetalleTableAdapter.Fill(PRESTODataSet.Boleta_Detalle, boleta_id); InteresesTableAdapter.Fill(PRESTODataSet.Intereses); ClienteTableAdapter.Fill(PRESTODataSet.Cliente, cliente_id); SucursalTableAdapter.Fill(PRESTODataSet.Sucursal, 1); reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("dsReimprime", dt)); reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("dsBoleta_Encabezado", PRESTODataSet.Tables["Boleta_Encabezado"])); reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("dsBoletaDetalle", PRESTODataSet.Tables["Boleta_Detalle"])); reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("dsIntereses", PRESTODataSet.Tables["Intereses"])); reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("dsCliente", PRESTODataSet.Tables["Cliente"])); reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("dsSucursal", PRESTODataSet.Tables["Sucursal"])); this.reportViewer1.RefreshReport(); }