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();
}
