private void btnNuevo_Click(object sender, EventArgs e) { try { Boolean IsProcedio = false; int Opcion = 0; if (dgvEmpresas.RowCount > 0) { foreach (DataGridViewRow row in dgvEmpresas.Rows) { DataGridViewCheckBoxCell chk = (DataGridViewCheckBoxCell)row.Cells[0]; if (chk.Value != null) { EmpresaTopBE IEntity = new EmpresaTopBE(); IEntity.FlgComite = 0; decimal Linea = string.IsNullOrEmpty(row.Cells["nLinea"].Value.ToString()) ? 0 : Convert.ToDecimal(row.Cells["nLinea"].Value); if (chk.Value.ToString().Equals("1")) { IEntity.FlgComite = 1; } IEntity.OPCION = 5; IEntity.USUARIO = General.General.GetUsuario; IEntity.Year = row.Cells["Year"].Value.ToString(); IEntity.RUC = row.Cells["RUC"].Value.ToString(); IEntity.nLinea = Linea; new EmpresaTopBL().ProcesarEmpresaTop(IEntity); } } btnBuscar.PerformClick(); MessageBox.Show("Se Proceso Correctamente", "Mensaje", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnBuscar_Click(object sender, EventArgs e) { try { DataSet ds = new DataSet(); EmpresaTopBE SocioLineaBE = new EmpresaTopBE() { OPCION = 4, USUARIO = General.General.GetUsuario, RUC = TextBoxX1.Text.Trim(), RazonSocial = txtRazonSocial.Text.Trim() }; ds = new EmpresaTopBL().ProcesarEmpresaTop(SocioLineaBE); dgvEmpresas.DataSource = ds.Tables[0]; lblRegistros.Text = ds.Tables[0].Rows.Count.ToString() + " registro(s)"; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnImportar_Click(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(txtYear.Text)) { MessageBox.Show("Ingresar un año a cargar", "Advertencia", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } if (txtYear.Text.Trim().Length != 4) { MessageBox.Show("El año debe ser de 4 digitos", "Advertencia", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } try { DateTime dt = new DateTime(int.Parse(txtYear.Text), 1, 1); } catch { MessageBox.Show("Ingresar un año valido", "Advertencia", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } string srutaArchivo = string.Empty; openFileDialog1.InitialDirectory = @"C:\"; openFileDialog1.Filter = "Archivos de Excel (*.xls) |*.xlsx"; openFileDialog1.FilterIndex = 2; openFileDialog1.RestoreDirectory = true; openFileDialog1.FileName = ""; List <Tuple <string, string, string> > LstNoEncontrados = new List <Tuple <string, string, string> >(); if (openFileDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK) { srutaArchivo = openFileDialog1.FileName; try { cnExcel = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + srutaArchivo + ";Extended Properties='Excel 12.0 Xml;HDR=YES';"); if (cnExcel.State == ConnectionState.Closed) { cnExcel.Open(); } if (!System.IO.File.Exists(srutaArchivo)) { MessageBox.Show("No se encontró el Libro: " + srutaArchivo, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } OleDbDataAdapter daExcel = new OleDbDataAdapter("Select * " + "From [Sheet1$A1:CH20000] ", cnExcel); DataTable dtTable = new DataTable(); daExcel.Fill(dtTable); pbCargaTop10K.Value = 0; pbCargaTop10K.Minimum = 0; pbCargaTop10K.Maximum = dtTable.Rows.Count; pbCargaTop10K.Step = 1; int Count = 0; int CountRegCargados = 0; int CountRegNoCargados = 0; lblRegistros.Text = CountRegCargados.ToString() + " registro(s) cargado(s)"; foreach (DataRow row in dtTable.Rows) { Count = 0; EmpresaTopBE IEntity = new EmpresaTopBE(); //RUC Razón Social Nombre Comercial Ciiu Ciiu 5dig Sector Esp Sector Ing Subsector Esp Ciiu Esp Detalle Ciiu Ing Detalle //Productos Servicios Grupo Partgrupo Listada Bolsa Regulada Sbs string RUC = row[Count].ToString().Trim(); Count++; string RazonSocial = row[Count].ToString().Trim(); Count++; if (string.IsNullOrEmpty(RUC)) { break; } IEntity.OPCION = 2; IEntity.USUARIO = General.General.GetUsuario; IEntity.Year = txtYear.Text.Trim(); IEntity.RUC = RUC; IEntity.RazonSocial = RazonSocial; IEntity.NombreComercial = row[Count].ToString().Trim(); Count++; IEntity.CIIU = row[Count].ToString().Trim(); Count++; IEntity.CIIU5 = row[Count].ToString().Trim(); Count++; IEntity.SectorEsp = row[Count].ToString().Trim(); Count++; IEntity.SectorIng = row[Count].ToString().Trim(); Count++; IEntity.SubsectorEsp = row[Count].ToString().Trim(); Count++; IEntity.CIIUEspDetalle = row[Count].ToString().Trim(); Count++; IEntity.CIIUIngDetalle = row[Count].ToString().Trim(); Count++; IEntity.ProductosServicios = row[Count].ToString().Trim(); Count++; IEntity.Grupo = row[Count].ToString().Trim(); Count++; IEntity.Partgrupo = row[Count].ToString().Trim(); Count++; IEntity.ListadaBolsa = row[Count].ToString().Trim(); Count++; IEntity.ReguladaSbs = row[Count].ToString().Trim(); Count++; //N Trabajadores, N Sucursales, Fecha Fundacion, AÑos De Funcionamiento,Tamano De Empresa, Extranjera, Porcextranjera, Estatal, //Porcestatal, Situación, Direccion, Distrito, Provincia, Departamento, Telefono1, IEntity.NTrabajadores = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : int.Parse(row[Count].ToString()); Count++; IEntity.NSucursales = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : int.Parse(row[Count].ToString()); Count++; IEntity.FechaFundacion = row[Count].ToString().Trim(); Count++; IEntity.AniosFuncionamiento = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.TamanoEmpresa = row[Count].ToString().Trim(); Count++; IEntity.Extranjera = row[Count].ToString().Trim(); Count++; IEntity.PorcExtranjera = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.Estatal = row[Count].ToString().Trim(); Count++; IEntity.PorcEstatal = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.Situacion = row[Count].ToString().Trim(); Count++; IEntity.Direccion = row[Count].ToString().Trim(); Count++; IEntity.Distrito = row[Count].ToString().Trim(); Count++; IEntity.Provincia = row[Count].ToString().Trim(); Count++; IEntity.Departamento = row[Count].ToString().Trim(); Count++; IEntity.Telefono1 = row[Count].ToString().Trim(); Count++; //Telefono2, Telefono3, Celular 1, Celular 2, Fax1, Fax2, Email Corp, Pagweb, Ranking 2016, Ranking 2015, Ranking 2014, //Facturado 2016 Soles Minimo, Facturado 2016 Soles Maximo, Facturado 2016 Usd Minimo, Facturado 2016 Usd Maximo, IEntity.Telefono2 = row[Count].ToString().Trim(); Count++; IEntity.Telefono3 = row[Count].ToString().Trim(); Count++; IEntity.Celular1 = row[Count].ToString().Trim(); Count++; IEntity.Celular2 = row[Count].ToString().Trim(); Count++; IEntity.Fax1 = row[Count].ToString().Trim(); Count++; IEntity.Fax2 = row[Count].ToString().Trim(); Count++; IEntity.EmailCorp = row[Count].ToString().Trim(); Count++; IEntity.PaginaWeb = row[Count].ToString().Trim(); Count++; IEntity.RankingY = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.RankingY_1 = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.RankingY_2 = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.FacturadoMinSolY = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.FacturadoMaxSolY = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.FacturadoMinUsdY = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.FacturadoMaxUsdY = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; //Facturado 2015 Soles Minimo, Facturado 2015 Soles Maximo, Facturado 2015 Usd Minimo, Facturado 2015 Usd Maximo, //Facturado 2014 Soles Minimo, Facturado 2014 Soles Maximo, Facturado 2014 Usd Minimo, Facturado 2014 Usd Maximo, //Priv Publ, Ingresos2016, Utilidad Neta 2016, Activos 2016, Patrimonio 2016, Pasivo Total 2016, Ingresos2015, IEntity.FacturadoMinSolY_1 = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.FacturadoMaxSolY_1 = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.FacturadoMinUsdY_1 = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.FacturadoMaxUsdY_1 = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.FacturadoMinSolY_2 = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.FacturadoMaxSolY_2 = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.FacturadoMinUsdY_2 = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.FacturadoMaxUsdY_2 = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.TipoPrivadaPublica = row[Count].ToString().Trim(); Count++; IEntity.IngresosY = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.UtilidadNetaY = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.ActivosY = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.PatrimonioY = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.PasivoTotalY = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.IngresosY_1 = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; //Utilidad Neta 2015, Activos 2015, Patrimonio 2015, Pasivo Total 2015, //Ingresos 2014, Utilidad Neta 2014, Activos 2014, Patrimonio 2014, Pasivo Total 2014, //Exportadora, Porcexpo Vtas2016, Importadora, Usdexpo2016, Usdexpo2015, Usdexpo2014, IEntity.UtilidadNetaY_1 = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.ActivosY_1 = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.PatrimonioY_1 = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.PasivoTotalY_1 = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.IngresosY_2 = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.UtilidadNetaY_2 = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.ActivosY_2 = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.PatrimonioY_2 = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.PasivoTotalY_2 = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.TipoExportadora = row[Count].ToString().Trim(); Count++; IEntity.PorExpoVtasY = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.Importadora = row[Count].ToString().Trim(); Count++; IEntity.USDExpoY = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.USDExpoY_1 = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.USDExpoY_2 = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; //Usdexpo2013, Usdexpo2012, Usdexpo2011, Usdexpo2010, Usdimpo2016, //Usdimpo2015, Usdimpo2014, Usdimpo2013, Usdimpo2012, Usdimpo2011, Usdimpo2010 IEntity.USDExpoY_3 = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.USDExpoY_4 = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.USDExpoY_5 = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.USDExpoY_6 = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.USDImpoY = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.USDImpoY_1 = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.USDImpoY_2 = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.USDImpoY_3 = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.USDImpoY_4 = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.USDImpoY_5 = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; IEntity.USDImpoY_6 = string.IsNullOrEmpty(row[Count].ToString().Trim()) ? 0 : Convert.ToDecimal(row[Count].ToString()); Count++; try { new EmpresaTopBL().ProcesarEmpresaTop(IEntity); CountRegCargados++; lblRegistros.Text = CountRegCargados.ToString() + " registro(s) cargado(s)"; } catch (Exception ex) { LstNoEncontrados.Add(new Tuple <string, string, string>(RUC, RazonSocial, ex.Message)); CountRegNoCargados++; } pbCargaTop10K.PerformStep(); } cnExcel.Close(); lblRegNoCargados.Text = CountRegNoCargados.ToString() + " registro(s) que no se cargaron"; dgvRegistrosNoCargados.DataSource = LstNoEncontrados; MessageBox.Show("Se Proceso Correctamente", "Mensaje", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); cnExcel.Close(); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); throw ex; } }
public DataSet ProcesarEmpresaTop(EmpresaTopBE BE) { return(EmpresaTopDA.ProcesarEmpresaTop(BE)); }
public DataSet ProcesarEmpresaTop(EmpresaTopBE BE) { DataSet dsResult; try { cmd = db.GetStoredProcCommand("EmpresaTop_Mnt"); cmd.CommandTimeout = 0; db.AddInParameter(cmd, "OPCION", DbType.Int32, BE.OPCION); db.AddInParameter(cmd, "USUARIO", DbType.String, BE.USUARIO); db.AddInParameter(cmd, "Year", DbType.String, BE.Year); db.AddInParameter(cmd, "RUC", DbType.String, BE.RUC); db.AddInParameter(cmd, "RazonSocial", DbType.String, BE.RazonSocial); db.AddInParameter(cmd, "NombreComercial", DbType.String, BE.NombreComercial); db.AddInParameter(cmd, "CIIU", DbType.String, BE.CIIU); db.AddInParameter(cmd, "CIIU5", DbType.String, BE.CIIU5); db.AddInParameter(cmd, "SectorEsp", DbType.String, BE.SectorEsp); db.AddInParameter(cmd, "SectorIng", DbType.String, BE.SectorIng); db.AddInParameter(cmd, "SubsectorEsp", DbType.String, BE.SubsectorEsp); db.AddInParameter(cmd, "CIIUEspDetalle", DbType.String, BE.CIIUEspDetalle); db.AddInParameter(cmd, "CIIUIngDetalle", DbType.String, BE.CIIUIngDetalle); db.AddInParameter(cmd, "ProductosServicios", DbType.String, BE.ProductosServicios); db.AddInParameter(cmd, "Grupo", DbType.String, BE.Grupo); db.AddInParameter(cmd, "Partgrupo", DbType.String, BE.Partgrupo); db.AddInParameter(cmd, "ListadaBolsa", DbType.String, BE.ListadaBolsa); db.AddInParameter(cmd, "ReguladaSbs", DbType.String, BE.ReguladaSbs); db.AddInParameter(cmd, "NTrabajadores", DbType.Decimal, BE.NTrabajadores); db.AddInParameter(cmd, "NSucursales", DbType.Decimal, BE.NSucursales); db.AddInParameter(cmd, "FechaFundacion", DbType.String, BE.FechaFundacion); db.AddInParameter(cmd, "AniosFuncionamiento", DbType.Decimal, BE.AniosFuncionamiento); db.AddInParameter(cmd, "TamanoEmpresa", DbType.String, BE.TamanoEmpresa); db.AddInParameter(cmd, "Extranjera", DbType.String, BE.Extranjera); db.AddInParameter(cmd, "PorcExtranjera", DbType.Decimal, BE.PorcExtranjera); db.AddInParameter(cmd, "Estatal", DbType.String, BE.Estatal); db.AddInParameter(cmd, "PorcEstatal", DbType.Decimal, BE.PorcEstatal); db.AddInParameter(cmd, "Situacion", DbType.String, BE.Situacion); db.AddInParameter(cmd, "Direccion", DbType.String, BE.Direccion); db.AddInParameter(cmd, "Distrito", DbType.String, BE.Distrito); db.AddInParameter(cmd, "Provincia", DbType.String, BE.Provincia); db.AddInParameter(cmd, "Departamento", DbType.String, BE.Departamento); db.AddInParameter(cmd, "Telefono1", DbType.String, BE.Telefono1); db.AddInParameter(cmd, "Telefono2", DbType.String, BE.Telefono2); db.AddInParameter(cmd, "Telefono3", DbType.String, BE.Telefono3); db.AddInParameter(cmd, "Celular1", DbType.String, BE.Celular1); db.AddInParameter(cmd, "Celular2", DbType.String, BE.Celular2); db.AddInParameter(cmd, "Fax1", DbType.String, BE.Fax1); db.AddInParameter(cmd, "Fax2", DbType.String, BE.Fax2); db.AddInParameter(cmd, "EmailCorp", DbType.String, BE.EmailCorp); db.AddInParameter(cmd, "PaginaWeb", DbType.String, BE.PaginaWeb); db.AddInParameter(cmd, "RankingY", DbType.Decimal, BE.RankingY); db.AddInParameter(cmd, "RankingY_1", DbType.Decimal, BE.RankingY_1); db.AddInParameter(cmd, "RankingY_2", DbType.Decimal, BE.RankingY_2); db.AddInParameter(cmd, "FacturadoMinSolY", DbType.Decimal, BE.FacturadoMinSolY); db.AddInParameter(cmd, "FacturadoMaxSolY", DbType.Decimal, BE.FacturadoMaxSolY); db.AddInParameter(cmd, "FacturadoMinUsdY", DbType.Decimal, BE.FacturadoMinUsdY); db.AddInParameter(cmd, "FacturadoMaxUsdY", DbType.Decimal, BE.FacturadoMaxUsdY); db.AddInParameter(cmd, "FacturadoMinSolY_1", DbType.Decimal, BE.FacturadoMinSolY_1); db.AddInParameter(cmd, "FacturadoMaxSolY_1", DbType.Decimal, BE.FacturadoMaxSolY_1); db.AddInParameter(cmd, "FacturadoMinUsdY_1", DbType.Decimal, BE.FacturadoMinUsdY_1); db.AddInParameter(cmd, "FacturadoMaxUsdY_1", DbType.Decimal, BE.FacturadoMaxUsdY_1); db.AddInParameter(cmd, "FacturadoMinSolY_2", DbType.Decimal, BE.FacturadoMinSolY_2); db.AddInParameter(cmd, "FacturadoMaxSolY_2", DbType.Decimal, BE.FacturadoMaxSolY_2); db.AddInParameter(cmd, "FacturadoMinUsdY_2", DbType.Decimal, BE.FacturadoMinUsdY_2); db.AddInParameter(cmd, "FacturadoMaxUsdY_2", DbType.Decimal, BE.FacturadoMaxUsdY_2); db.AddInParameter(cmd, "TipoPrivadaPublica", DbType.String, BE.TipoPrivadaPublica); db.AddInParameter(cmd, "IngresosY", DbType.Decimal, BE.IngresosY); db.AddInParameter(cmd, "UtilidadNetaY", DbType.Decimal, BE.UtilidadNetaY); db.AddInParameter(cmd, "ActivosY", DbType.Decimal, BE.ActivosY); db.AddInParameter(cmd, "PatrimonioY", DbType.Decimal, BE.PatrimonioY); db.AddInParameter(cmd, "PasivoTotalY", DbType.Decimal, BE.PasivoTotalY); db.AddInParameter(cmd, "IngresosY_1", DbType.Decimal, BE.IngresosY_1); db.AddInParameter(cmd, "UtilidadNetaY_1", DbType.Decimal, BE.UtilidadNetaY_1); db.AddInParameter(cmd, "ActivosY_1", DbType.Decimal, BE.ActivosY_1); db.AddInParameter(cmd, "PatrimonioY_1", DbType.Decimal, BE.PatrimonioY_1); db.AddInParameter(cmd, "PasivoTotalY_1", DbType.Decimal, BE.PasivoTotalY_1); db.AddInParameter(cmd, "IngresosY_2", DbType.Decimal, BE.IngresosY_2); db.AddInParameter(cmd, "UtilidadNetaY_2", DbType.Decimal, BE.UtilidadNetaY_2); db.AddInParameter(cmd, "ActivosY_2", DbType.Decimal, BE.ActivosY_2); db.AddInParameter(cmd, "PatrimonioY_2", DbType.Decimal, BE.PatrimonioY_2); db.AddInParameter(cmd, "PasivoTotalY_2", DbType.Decimal, BE.PasivoTotalY_2); db.AddInParameter(cmd, "TipoExportadora", DbType.String, BE.TipoExportadora); db.AddInParameter(cmd, "PorExpoVtasY", DbType.Decimal, BE.PorExpoVtasY); db.AddInParameter(cmd, "USDExpoY", DbType.Decimal, BE.USDExpoY); db.AddInParameter(cmd, "USDExpoY_1", DbType.Decimal, BE.USDExpoY_1); db.AddInParameter(cmd, "USDExpoY_2", DbType.Decimal, BE.USDExpoY_2); db.AddInParameter(cmd, "USDExpoY_3", DbType.Decimal, BE.USDExpoY_3); db.AddInParameter(cmd, "USDExpoY_4", DbType.Decimal, BE.USDExpoY_4); db.AddInParameter(cmd, "USDExpoY_5", DbType.Decimal, BE.USDExpoY_5); db.AddInParameter(cmd, "USDExpoY_6", DbType.Decimal, BE.USDExpoY_6); db.AddInParameter(cmd, "USDImpoY", DbType.Decimal, BE.USDImpoY); db.AddInParameter(cmd, "USDImpoY_1", DbType.Decimal, BE.USDImpoY_1); db.AddInParameter(cmd, "USDImpoY_2", DbType.Decimal, BE.USDImpoY_2); db.AddInParameter(cmd, "USDImpoY_3", DbType.Decimal, BE.USDImpoY_3); db.AddInParameter(cmd, "USDImpoY_4", DbType.Decimal, BE.USDImpoY_4); db.AddInParameter(cmd, "USDImpoY_5", DbType.Decimal, BE.USDImpoY_5); db.AddInParameter(cmd, "USDImpoY_6", DbType.Decimal, BE.USDImpoY_6); db.AddInParameter(cmd, "FlgComite", DbType.Decimal, BE.FlgComite); db.AddInParameter(cmd, "nLinea", DbType.Decimal, BE.nLinea); dsResult = db.ExecuteDataSet(cmd); } catch (Exception ex) { throw new Exception(ex.Message); } return(dsResult); }