private void ActcboTasasCambio()
{
l_tasascambiodolar tasascambio = new l_tasascambiodolar();
DataTable dt1 = new DataTable();
dt1 = tasascambio.select("1 order by id desc");
cboTasasCambio.DataSource = dt1;
}
private void ConfigForm()
{
this.dtItems.Columns.Add("codprod", typeof(string));
this.dtItems.Columns.Add("descrip", typeof(string));
this.dtItems.Columns.Add("refere", typeof(string));
this.dtItems.Columns.Add("marca", typeof(string));
this.dtItems.Columns.Add("costact", typeof(decimal));
this.dtItems.Columns.Add("costant", typeof(decimal));
this.dtItems.Columns.Add("precio1", typeof(decimal));
this.dtItems.Columns.Add("precio2", typeof(decimal));
this.dtItems.Columns.Add("precio3", typeof(decimal));
this.dtItems.Columns.Add("existen", typeof(decimal));
this.dtItems.Columns.Add("fechauv", typeof(DateTime));
this.dtItems.Columns.Add("fechauc", typeof(DateTime));
this.dtItems.Columns.Add("sj_selec", typeof(bool));
this.dtItems.Columns.Add("sj_tasacambio", typeof(decimal));
this.dtItems.Columns.Add("sj_costodolar", typeof(decimal));
this.dtItems.Columns.Add("sj_p1dolar", typeof(decimal));
this.dtItems.Columns.Add("sj_p2dolar", typeof(decimal));
this.dtItems.Columns.Add("sj_p3dolar", typeof(decimal));
this.dtItems.Columns.Add("sj_putilidad1", typeof(decimal));
this.dtItems.Columns.Add("sj_putilidad2", typeof(decimal));
this.dtItems.Columns.Add("sj_putilidad3", typeof(decimal));
this.dtItems.Columns.Add("actualiza", typeof(bool));
dataGridView1.AutoGenerateColumns = false;
dataGridView1.DataSource = this.dtItems;
misclases.namecompany = ConfigurationManager.AppSettings["namecompany"].ToUpper();
misclases.conexLite = misclases.Conexion_Sqlite();
misclases.conexSql = misclases.Conexion_Sql();
cboGrupo.DataSource = misclases.CursorTable("select * from sainsta");
cboBuscapor.SelectedIndex = 0;
cboGrupo.SelectedValue = 0;
ActualizaEstructuraBD();
//
l_tasascambiodolar tasascambio = new l_tasascambiodolar();
DataTable dt1 = new DataTable();
dt1 = tasascambio.select("1 order by id desc limit 1");
if (dt1.Rows.Count > 0)
{
this.ultimatasa = Convert.ToDecimal(dt1.Rows[0]["tasacambio"]);
}
texTasaCambio.Text = this.ultimatasa.ToString("F0");
ActcboTasasCambio();
ValidaInicio();
}
