private void getProductos() { try { spCatProductoDS prd = new spCatProductoDS(); Params.Clear(); Data.DataModule.ParamByName(Params, "Datos", ""); DataModule.FillDataSet(prd, "spCatProducto", Params.ToArray()); DataTable dt = new DataTable(); dt = prd.Tables["spCatProducto"]; IEnumerable <DataRow> query = from dts in dt.AsEnumerable() select dts; foreach (DataRow dr in query) { switch (dr.Field <int>("ProductoID")) { case 1: lbl87oct.Text = "Producto: " + dr.Field <string>("Descripcion") + " Precio: $" + dr.Field <double>("Precio").ToString(); break; case 2: lbl92oct.Text = "Producto: " + dr.Field <string>("Descripcion") + " Precio: $" + dr.Field <double>("Precio").ToString(); break; case 3: lbldiesel.Text = "Producto: " + dr.Field <string>("Descripcion") + " Precio: $" + dr.Field <double>("Precio").ToString(); break; } } lblFecha.Text = "Precio de los combustibles a la fecha: " + DateTime.Today.ToString(); } catch (Exception ex) { throw; } }
private void FillComboEstacion() { List <ValuesCombo> lista = new List <ValuesCombo>(); spCatEstacionDS ds = new spCatEstacionDS(); DataModule.FillDataSet(ds, "spCatEstacion", null); DataTable dt = new DataTable(); dt = ds.Tables["spCatEstacion"]; IEnumerable <DataRow> query = from dts in dt.AsEnumerable() select dts; foreach (DataRow dr in query) { lista.Add(new ValuesCombo() { id = dr.Field <int>("EstacionID").ToString(), nombre = dr.Field <int>("EstacionID").ToString() + "-" + dr.Field <string>("Nombre") }); } cmbLimitarEstacion.DataSource = lista; cmbLimitarEstacion.ValueField = "id"; cmbLimitarEstacion.TextField = "nombre"; cmbLimitarEstacion.DataBind(); chProductos.Items.Add("PREMIUM"); chProductos.Items.Add("MAGNA"); chProductos.Items.Add("DIESEL"); chProductos.Items.Add("OTRO"); }
private void LlenarDetallePedido(int PedidoID) { try { DataSet cdsDatos = detallePedidoDS1; BindingSource cbsDataSource = spDetallePedidoBindingSource; string cDataSetDatos = "spDetallePedido"; cdsDatos.Clear(); //Lenamos el DS de Categorias Params.Clear(); DataModule.ParamByName(Params, "PedidoID", PedidoID); DataModule.FillDataSet(cdsDatos, cDataSetDatos, Params.ToArray()); gvDetallePedido.BestFitColumns(false); //if (gvDetallePedido.DataRowCount > 0) //{ // IEnumerable<DataRow> query = from dts in detallePedidoDS1.Tables["spDetallePedido"].AsEnumerable() select dts; // foreach (DataRow dr in query) // { // CalcularTotales(dr.Field<int>("ProductoID")); // } // gvDetallePedido.UpdateTotalSummary(); //} gvDetallePedido.UpdateTotalSummary(); ButtonGenerarRecibo(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void getEstacionAutoAbasto() { Params.Clear(); Data.DataModule.ParamByName(Params, "Datos", DataModule.Seguridad.Attributes[0].ToString()); spCatEstacionDS ds = new spCatEstacionDS(); DataModule.FillDataSet(ds, "spCatEstacion", Params.ToArray()); DataTable dt = new DataTable(); dt = ds.Tables["spCatEstacion"]; IEnumerable <DataRow> query = from dts in dt.AsEnumerable() select dts; foreach (DataRow dr in query) { if (dr.Field <bool>("AutoAbasto")) { ASPxChkAutoAbasto.Checked = dr.Field <bool>("AutoAbasto"); getTransportistaVehiculo(dr.Field <int>("TransportistaID")); mostrarCampos(true); } else { ASPxChkAutoAbasto.Checked = dr.Field <bool>("AutoAbasto"); mostrarCampos(false); } } }
private DataTable fillComboDataset(DataSet ds, string dstring) { DataTable dt = new DataTable(); DataModule.FillDataSet(ds, dstring, null); dt = ds.Tables[dstring]; return(dt); }
private void getSaldo(string EstacionID) { Params.Clear(); Data.DataModule.ParamByName(Params, "Datos", EstacionID); DataModule.FillDataSet(saldo, "spCatSaldo", Params.ToArray()); bgvSaldo.DataSource = saldo; bgvSaldo.DataBind(); }
private DataTable fillComboDataset(DataSet ds, string dstring) { DataTable dt = new DataTable(); Params.Clear(); Data.DataModule.ParamByName(Params, "Datos", DataModule.Seguridad.UserID); DataModule.FillDataSet(ds, dstring, Params.ToArray()); dt = ds.Tables[dstring]; return(dt); }
private void getDetallePedido(string pedidoid) { Params.Clear(); Data.DataModule.ParamByName(Params, "Pedido", pedidoid); spCatDetallePedidoDS ds = new spCatDetallePedidoDS(); DataModule.FillDataSet(ds, "spCatDetallePedido", Params.ToArray()); GridDetallePedido.DataSource = ds; GridDetallePedido.DataBind(); }
private void getPedido(string UsuarioID) { Params.Clear(); Data.DataModule.ParamByName(Params, "Datos", UsuarioID); spCatPedidoDS ds = new spCatPedidoDS(); DataModule.FillDataSet(ds, "spCatPedido", Params.ToArray()); gvPedido.DataSource = ds; gvPedido.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { Params.Clear(); Data.DataModule.ParamByName(Params, "ClienteID", DataModule.Seguridad.UserID); spVehiculoDS ds = new spVehiculoDS(); DataModule.FillDataSet(ds, "spVehiculo", Params.ToArray()); DataTable dt = new DataTable(); dt = ds.Tables["spVehiculo"]; bgvVehiculo.DataSource = dt; bgvVehiculo.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { Params.Clear(); Data.DataModule.ParamByName(Params, "Datos", DataModule.Seguridad.UserID); spCatPedidoDS ds = new spCatPedidoDS(); DataModule.FillDataSet(ds, "spCatPedido", Params.ToArray()); DataTable dt = new DataTable(); dt = ds.Tables[0]; gvPedidos.DataSource = dt.Select("StatusID=" + 1 + " or StatusID =" + 3); gvPedidos.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { Params.Clear(); Data.DataModule.ParamByName(Params, "Datos", Session["VehiculoID"]); spCatVehiculoDS ds = new spCatVehiculoDS(); DataModule.FillDataSet(ds, "spCatVehiculo", Params.ToArray()); DataTable dt = new DataTable(); dt = ds.Tables["spCatVehiculo"]; FillDataFirstTab(dt); FillCombos(); FillComboEstacion(); FillDataSecondTab(dt); FillDataThirdTab(dt); FillDataFourthTab(dt); FillDataFifthTab(dt); FillDataSixthTab(dt); }
private void LlenarBusquedaPedido(string Datos) { try { //cdsDatos = spPedidoDS1; DataSource = spPedidoBindingSource; NombreDataSetDatos = "spPedido"; cdsDatos.Clear(); //Lenamos el DS de Categorias Params.Clear(); DataModule.ParamByName(Params, "Datos", Datos); DataModule.FillDataSet(cdsDatos, NombreDataSetDatos, Params.ToArray()); gvPedido.BestFitColumns(true); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void LlenarDetallePedido(int PedidoID) { try { cdsDatos = detallePedidoDS1; DataSource = spDetallePedidoBindingSource; NombreDataSetDatos = "spDetallePedido"; cdsDatos.Clear(); //Lenamos el DS de Categorias Params.Clear(); DataModule.ParamByName(Params, "PedidoID", PedidoID); DataModule.FillDataSet(cdsDatos, NombreDataSetDatos, Params.ToArray()); gvDetallePedido.BestFitColumns(true); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void getSaldo(string EstacionID) { try { Params.Clear(); Data.DataModule.ParamByName(Params, "EstacionID", EstacionID); //DataModule.FillDataSet(saldo, "spSaldoCliente", Params.ToArray()); //DataTable dt = saldo.Tables["spSaldoCliente"]; DataModule.FillDataSet(saldo, "spSaldo", Params.ToArray()); DataTable dt = saldo.Tables["spSaldo"]; IEnumerable <DataRow> query = from dts in dt.AsEnumerable() select dts; foreach (DataRow dr in query) { lblCreditoOtorgado.Text = "$ " + string.Format("{0:n2}", dr.Field <double>("LimiteCredito")); lblSaldo.Text = "$ " + string.Format("{0:n2}", dr.Field <double>("Disponible")); lblCreditoUtilizado.Text = "$ " + string.Format("{0:n2}", dr.Field <double>("Saldo")); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void getPedido(string UsuarioID) { try { Params.Clear(); Data.DataModule.ParamByName(Params, "Datos", UsuarioID); DataModule.FillDataSet(ds, "spCatPedido", Params.ToArray()); DataTable dt = new DataTable(); dt = ds.Tables["spCatPedido"]; dt.Columns.Add(new DataColumn("Imagen", typeof(byte[]))); dt.Columns.Add(new DataColumn("ImagenEstatus", typeof(byte[]))); IEnumerable <DataRow> query = from dts in dt.AsEnumerable() select dts; ImageConverter _imageConverter = new ImageConverter(); byte[] xByte; System.Drawing.Image img; foreach (DataRow dr in query) { switch (dr.Field <int>("StatusID")) { case 1: //Nuevo img = System.Drawing.Image.FromFile(@"C:\Users\RedPacifico\Desktop\RedCoSite\RedCoSite\RedCoSite\Image\deliveryGrid.png"); xByte = (byte[])_imageConverter.ConvertTo(img, typeof(byte[])); dr["Imagen"] = xByte; img = System.Drawing.Image.FromFile(@"C:\Users\RedPacifico\Desktop\RedCoSite\RedCoSite\RedCoSite\Image\add.png"); xByte = (byte[])_imageConverter.ConvertTo(img, typeof(byte[])); dr["ImagenEstatus"] = xByte; break; //2.Por Validar case 3: //Procesando img = System.Drawing.Image.FromFile(@"C:\Users\RedPacifico\Desktop\RedCoSite\RedCoSite\RedCoSite\Image\deliveryGrid-location.png"); xByte = (byte[])_imageConverter.ConvertTo(img, typeof(byte[])); dr["Imagen"] = xByte; img = System.Drawing.Image.FromFile(@"C:\Users\RedPacifico\Desktop\RedCoSite\RedCoSite\RedCoSite\Image\red.png"); xByte = (byte[])_imageConverter.ConvertTo(img, typeof(byte[])); dr["ImagenEstatus"] = xByte; break; //4.Cargando case 5: //Ruta de entrega img = System.Drawing.Image.FromFile(@"C:\Users\RedPacifico\Desktop\RedCoSite\RedCoSite\RedCoSite\Image\deliveryGrid-location.png"); xByte = (byte[])_imageConverter.ConvertTo(img, typeof(byte[])); //dr.Field<byte[]>("Imagen").SetValue(xByte, 0); dr["Imagen"] = xByte; img = System.Drawing.Image.FromFile(@"C:\Users\RedPacifico\Desktop\RedCoSite\RedCoSite\RedCoSite\Image\red.png"); xByte = (byte[])_imageConverter.ConvertTo(img, typeof(byte[])); dr["ImagenEstatus"] = xByte; break; case 6: //Entregado img = System.Drawing.Image.FromFile(@"C:\Users\RedPacifico\Desktop\RedCoSite\RedCoSite\RedCoSite\Image\deliveryGrid-ok.png"); xByte = (byte[])_imageConverter.ConvertTo(img, typeof(byte[])); //dr.Field<byte[]>("Imagen").SetValue(xByte, 0); dr["Imagen"] = xByte; img = System.Drawing.Image.FromFile(@"C:\Users\RedPacifico\Desktop\RedCoSite\RedCoSite\RedCoSite\Image\ok.png"); xByte = (byte[])_imageConverter.ConvertTo(img, typeof(byte[])); dr["ImagenEstatus"] = xByte; break; case 7: //Cancelado img = System.Drawing.Image.FromFile(@"C:\Users\RedPacifico\Desktop\RedCoSite\RedCoSite\RedCoSite\Image\deliveryGrid-cancel.png"); xByte = (byte[])_imageConverter.ConvertTo(img, typeof(byte[])); //dr.Field<byte[]>("Imagen").SetValue(xByte, 0); dr["Imagen"] = xByte; img = System.Drawing.Image.FromFile(@"C:\Users\RedPacifico\Desktop\RedCoSite\RedCoSite\RedCoSite\Image\cancel.png"); xByte = (byte[])_imageConverter.ConvertTo(img, typeof(byte[])); dr["ImagenEstatus"] = xByte; break; } //dt.Rows.Add(dr.ItemArray); } grid.DataSource = dt; grid.DataBind(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }