private void getFacturaUso()
{
//Variables
DataTable dt = new DataTable();
BindingSource bs = new BindingSource();
List <FillCombos> lst = new List <FillCombos>();
FillCombos obj = new FillCombos();
//Lenamos el DS de FormaPago
Data.DataModule.ParamByName(Params, "Datos", "");
Data.DataModule.FillDataSet(spCatFacturaUsoDS, "spCatFacturaUso", Params.ToArray());
dt = spCatFacturaUsoDS.Tables["spCatFacturaUso"];
lst = obj.FillListCombo(dt, "FacturaUsoID", "Descripcion");
bs.DataSource = lst;
this.lueFacturaUso.Properties.DataSource = bs.List;
//this.lueCambiaEstacion.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("EstacionID", "Banco ID"));
this.lueFacturaUso.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Nombre", "Nombre"));
this.lueFacturaUso.Properties.DisplayMember = "Nombre";
this.lueFacturaUso.Properties.ValueMember = "ID";
this.lueFacturaUso.Properties.DropDownRows = lst.Count;
}
//CargarValores a los Combos
#region CargarValores
// Se llena el Combo de Las estaciones
public void GetEstacion()
{
//variables
DataTable dt = new DataTable();
BindingSource bs = new BindingSource();
List <FillCombos> Estaciones = new List <FillCombos>();
FillCombos e = new FillCombos();
////llenamos DS de Estaciones
Params.Clear();
Data.DataModule.ParamByName(Params, "Datos", "");
Data.DataModule.FillDataSet(spCatEstacionDS, "spCatEstacion", Params.ToArray());
dt = spCatEstacionDS.Tables["spCatEstacion"];
Estaciones = e.FillListCombo(dt, "EstacionID", "Nombre");
bs.DataSource = Estaciones;
this.lueEstacionDestino.Properties.DataSource = bs.List;
this.lueEstacionDestino.Properties.Columns.Add(new LookUpColumnInfo("ID", "EstacionID"));
this.lueEstacionDestino.Properties.Columns.Add(new LookUpColumnInfo("Nombre", "Nombre"));
this.lueEstacionDestino.Properties.DisplayMember = "Nombre";
this.lueEstacionDestino.Properties.ValueMember = "ID";
// Specify the dropdown height.
this.lueEstacionDestino.Properties.DropDownRows = Estaciones.Count;
}
// Llenamos el Combo de los Proveedores
public void GetProveedores()
{
//variables
DataTable dt = new DataTable();
BindingSource bs = new BindingSource();
List <FillCombos> proveedor = new List <FillCombos>();
FillCombos e = new FillCombos();
////llenamos DS de Almacen
Params.Clear();
Data.DataModule.ParamByName(Params, "Datos", "");
Data.DataModule.FillDataSet(spCatProveedorDS, "spCatProveedor", Params.ToArray());
dt = spCatProveedorDS.Tables["spCatProveedor"];
proveedor = e.FillListCombo(dt, "ProveedorId", "Nombre");
bs.DataSource = proveedor;
this.lueProveedor.Properties.DataSource = bs.List;
this.lueProveedor.Properties.Columns.Add(new LookUpColumnInfo("ID", "ProveedorId"));
this.lueProveedor.Properties.Columns.Add(new LookUpColumnInfo("Nombre", "Nombre"));
this.lueProveedor.Properties.DisplayMember = "Nombre";
this.lueProveedor.Properties.ValueMember = "ID";
// Specify the dropdown height.
this.lueProveedor.Properties.DropDownRows = proveedor.Count;
}
private void CargarOperador()
{
DataTable dt = new DataTable();
BindingSource bs = new BindingSource();
List <FillCombos> lst = new List <FillCombos>();
FillCombos obj = new FillCombos();
//Lenamos el DS de FormaPago
Params.Clear();
Data.DataModule.ParamByName(Params, "Datos", "");
Data.DataModule.FillDataSet(spCatOperadorDS1, "spCatOperador", Params.ToArray());
dt = spCatOperadorDS1.Tables["spCatOperador"];
lst = obj.FillListCombo(dt, "OperadorID", "Nombre");
bs.DataSource = lst;
this.lueNombreOperador.Properties.DataSource = bs.List;
//this.lueCambiaEstacion.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("EstacionID", "Banco ID"));
this.lueNombreOperador.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("ID", "ID"));
this.lueNombreOperador.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Nombre", "Nombre"));
this.lueNombreOperador.Properties.DisplayMember = "Nombre";
this.lueNombreOperador.Properties.ValueMember = "ID";
this.lueNombreOperador.Properties.DropDownRows = lst.Count;
}
public void getMetodoPago()
{
//Variables
DataTable dt = new DataTable();
BindingSource bs = new BindingSource();
List <FillCombos> lst = new List <FillCombos>();
FillCombos obj = new FillCombos();
//Lenamos el DS de FormaPago
Data.DataModule.FillDataSet(spCatMetodoPagoDS1, "spCatMetodoPago", null);
dt = spCatMetodoPagoDS1.Tables["spCatMetodoPago"];
lst = obj.FillListCombo(dt, "MetodoPagoID", "Descripcion");
bs.DataSource = lst;
this.lueMetodoPago.Properties.DataSource = bs.List;
//this.lueCambiaEstacion.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("EstacionID", "Banco ID"));
this.lueMetodoPago.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Nombre", "Nombre"));
this.lueMetodoPago.Properties.DisplayMember = "Nombre";
this.lueMetodoPago.Properties.ValueMember = "ID";
this.lueMetodoPago.Properties.DropDownRows = lst.Count;
}
public void GetTipoMovimiento()
{
//variables
DataTable dt = new DataTable();
BindingSource bs = new BindingSource();
List <FillCombos> TipoMovimiento = new List <FillCombos>();
FillCombos e = new FillCombos();
////llenamos DS de TipoMovimiento
;
Data.DataModule.FillDataSet(spCatTipoMovimientoDS, "spCatTipoMovimiento", null);
dt = spCatTipoMovimientoDS.Tables["spCatTipoMovimiento"];
TipoMovimiento = e.FillListCombo(dt, "TipoMovimientoAlmacenID", "Nombre");
bs.DataSource = TipoMovimiento;
this.lueTipoMovimiento.Properties.DataSource = bs.List;
this.lueTipoMovimiento.Properties.Columns.Add(new LookUpColumnInfo("ID", "TipoMovimientoAlmacenID"));
this.lueTipoMovimiento.Properties.Columns.Add(new LookUpColumnInfo("Nombre", "Nombre"));
this.lueTipoMovimiento.Properties.DisplayMember = "Nombre";
this.lueTipoMovimiento.Properties.ValueMember = "ID";
// Specify the dropdown height.
this.lueTipoMovimiento.Properties.DropDownRows = TipoMovimiento.Count;
}
