public Lbl.Comprobantes.ColeccionDetalleArticulos ObtenerArticulos(Lbl.Comprobantes.ComprobanteConArticulos comprobante)
{
if (m_Articulos == null)
{
m_Articulos = new Lbl.Comprobantes.ColeccionDetalleArticulos(comprobante);
}
else
{
m_Articulos.Clear();
}
int i = 1;
foreach (DetalleCompra Pro in this.ChildControls)
{
if (Pro.IsEmpty == false)
{
Lbl.Comprobantes.DetalleArticulo DetArt = new Lbl.Comprobantes.DetalleArticulo(comprobante);
DetArt.Articulo = Pro.Articulo;
DetArt.Alicuota = Pro.Alicuota;
DetArt.Nombre = Pro.TextDetail;
DetArt.Orden = i++;
DetArt.Cantidad = Pro.Cantidad;
DetArt.ImporteIvaUnitario = Pro.ImporteIvaUnitario;
DetArt.ImporteUnitario = Pro.ImporteUnitario;
DetArt.ImporteNoGravado = Pro.ImporteNoGravado;
DetArt.Descuento = Pro.Descuento;
DetArt.DatosSeguimiento = Pro.DatosSeguimiento;
m_Articulos.Add(DetArt);
}
}
return(m_Articulos);
}
public void EnviarNP(object sender, System.EventArgs e)
{
Lbl.Comprobantes.ComprobanteDeCompra Comprob = new Lbl.Comprobantes.ComprobanteDeCompra(this.Connection);
Comprob.Tipo = Lbl.Comprobantes.Tipo.TodosPorLetra["NP"];
Comprob.FormaDePago = new Lbl.Pagos.FormaDePago(this.Connection, 3);
Lbl.Comprobantes.ColeccionDetalleArticulos newCole = new Lbl.Comprobantes.ColeccionDetalleArticulos(this.Connection);
foreach (ListViewItem Itm in this.Listado.Items)
{
Lbl.Articulos.Articulo art = new Lbl.Articulos.Articulo(this.Connection, int.Parse(Itm.SubItems[0].Text));
Lbl.Comprobantes.DetalleArticulo detArt = new Lbl.Comprobantes.DetalleArticulo(this.Connection);
detArt.Crear();
detArt.Articulo = art;
decimal costoFinal = decimal.Parse(Itm.SubItems["articulos.costo"].Text);
detArt.ImporteUnitario = costoFinal;
decimal stockAct = decimal.Parse(Itm.SubItems["articulos.stock_actual"].Text);
decimal stockMin = decimal.Parse(Itm.SubItems["articulos.stock_minimo"].Text);
if (stockMin == 0)
{
detArt.Cantidad = 1;
}
else
{
detArt.Cantidad = stockMin > stockAct ? stockMin - stockAct : stockMin;
}
newCole.Add(detArt);
}
Comprob.Articulos.AddRange(newCole);
Comprob.Estado = 50;
Lfc.FormularioEdicion FormularioEdicion = Lfc.Instanciador.InstanciarFormularioEdicion(Comprob);
FormularioEdicion.MdiParent = this.MdiParent; //this.ParentForm.MdiParent;
FormularioEdicion.Show();
//Lbl.IElementoDeDatos El = Lbl.Instanciador.Instanciar(this.Definicion.ElementoTipo, Lfx.Workspace.Master.GetNewConnection("Crear " + this.Definicion.ElementoTipo.ToString()) as Lfx.Data.Connection);
//El.Crear();
}
public Lbl.Comprobantes.ColeccionDetalleArticulos ObtenerArticulos(Lfx.Data.IConnection dataBase)
{
m_Articulos = new Lbl.Comprobantes.ColeccionDetalleArticulos(dataBase);
int i = 1;
foreach (DetalleComprobante Pro in this.ChildControls)
{
if (Pro.IsEmpty == false)
{
Lbl.Comprobantes.DetalleArticulo DetArt = new Lbl.Comprobantes.DetalleArticulo(dataBase);
DetArt.Articulo = Pro.Elemento as Lbl.Articulos.Articulo;
DetArt.Nombre = Pro.TextDetail;
DetArt.Orden = i++;
DetArt.Cantidad = Pro.Cantidad;
DetArt.ImporteUnitario = Pro.ImporteUnitario;
DetArt.Descuento = Pro.Descuento;
DetArt.DatosSeguimiento = Pro.DatosSeguimiento;
m_Articulos.Add(DetArt);
}
}
return(m_Articulos);
}
public virtual Lazaro.Pres.Spreadsheet.Workbook ToWorkbookDetalle(int IDComprobante)
{
Lbl.Comprobantes.Factura selComprobante = new Lbl.Comprobantes.Factura(this.Connection, IDComprobante);
Lazaro.Pres.Spreadsheet.Workbook Res = new Lazaro.Pres.Spreadsheet.Workbook();
Lazaro.Pres.Spreadsheet.Sheet Sheet = new Lazaro.Pres.Spreadsheet.Sheet(this.Text + " Comprobante");
Res.Sheets.Add(Sheet);
int OrderColumn = -1;
if (selComprobante != null)
{
for (int i = 0; i < 9; i++)
{
ExcelReg nexc = new ExcelReg();
switch (i)
{
case 0:
nexc.name = "id_articulo";
nexc.desc = "Código";
nexc.alig = Lfx.Types.StringAlignment.Near;
nexc.width = 100;
nexc.fieldtype = Lfx.Data.InputFieldTypes.Integer;
break;
case 1:
nexc.name = "nombre";
nexc.desc = "Nombre";
nexc.alig = Lfx.Types.StringAlignment.Near;
nexc.width = 300;
nexc.fieldtype = Lfx.Data.InputFieldTypes.Text;
break;
case 2:
nexc.name = "descripcion";
nexc.desc = "Descripción";
nexc.alig = Lfx.Types.StringAlignment.Near;
nexc.width = 150;
nexc.fieldtype = Lfx.Data.InputFieldTypes.Text;
break;
case 3:
nexc.name = "cantidad";
nexc.desc = "Cantidad";
nexc.alig = Lfx.Types.StringAlignment.Near;
nexc.width = 80;
nexc.fieldtype = Lfx.Data.InputFieldTypes.Numeric;
break;
case 4:
nexc.name = "costo";
nexc.desc = "Costo";
nexc.alig = Lfx.Types.StringAlignment.Near;
nexc.width = 90;
nexc.fieldtype = Lfx.Data.InputFieldTypes.Currency;
break;
case 5:
nexc.name = "precio";
nexc.desc = "Precio Uni.";
nexc.alig = Lfx.Types.StringAlignment.Near;
nexc.width = 120;
nexc.fieldtype = Lfx.Data.InputFieldTypes.Currency;
break;
case 6:
nexc.name = "importe";
nexc.desc = "Importe";
nexc.alig = Lfx.Types.StringAlignment.Near;
nexc.width = 120;
nexc.fieldtype = Lfx.Data.InputFieldTypes.Currency;
break;
case 7:
nexc.name = "recargo";
nexc.desc = "Recargo";
nexc.alig = Lfx.Types.StringAlignment.Near;
nexc.width = 100;
nexc.fieldtype = Lfx.Data.InputFieldTypes.Currency;
break;
case 8:
nexc.name = "total";
nexc.desc = "Total";
nexc.alig = Lfx.Types.StringAlignment.Near;
nexc.width = 120;
nexc.fieldtype = Lfx.Data.InputFieldTypes.Currency;
break;
}
Lazaro.Pres.Spreadsheet.ColumnHeader ColHead = new Lazaro.Pres.Spreadsheet.ColumnHeader(nexc.desc, nexc.width);
ColHead.Name = Lazaro.Orm.Data.ColumnValue.GetNameOnly(nexc.name);
ColHead.TextAlignment = nexc.alig; ColHead.DataType = nexc.fieldtype; ColHead.Format = nexc.format; ColHead.Printable = true;
if (i == 8)
{
ColHead.TotalFunction = Lazaro.Pres.Spreadsheet.QuickFunctions.Sum;
}
Sheet.ColumnHeaders.Add(ColHead);
excReg.Add(nexc);
}
}
// Exporto los renglones
Lbl.Comprobantes.ColeccionDetalleArticulos detArt = selComprobante.Articulos;
foreach (Lbl.Comprobantes.DetalleArticulo DtRow in detArt)
{
Lazaro.Pres.Spreadsheet.Row Reng = this.FormatArt(Sheet, DtRow);
Sheet.Rows.Add(Reng);
}
if (OrderColumn >= 0)
{
if (m_GroupingColumnName != null)
{
Sheet.SortByGroupAndColumn(OrderColumn, true);
}
else
{
if (OrderColumn >= 0)
{
Sheet.Sort(OrderColumn, true);
}
}
}
return(Res);
}
public Lbl.Comprobantes.ColeccionDetalleArticulos ObtenerArticulos(Lbl.Comprobantes.ComprobanteConArticulos comprobante)
{
if (m_Articulos == null)
m_Articulos = new Lbl.Comprobantes.ColeccionDetalleArticulos(comprobante);
else
m_Articulos.Clear();
int i = 1;
foreach (DetalleComprobante Pro in this.ChildControls) {
if (Pro.IsEmpty == false) {
Lbl.Comprobantes.DetalleArticulo DetArt = new Lbl.Comprobantes.DetalleArticulo(comprobante);
DetArt.Articulo = Pro.Articulo;
DetArt.Nombre = Pro.TextDetail;
DetArt.Orden = i++;
DetArt.Cantidad = Pro.Cantidad;
DetArt.Unitario = Pro.Unitario;
DetArt.Descuento = Pro.Descuento;
DetArt.DatosSeguimiento = Pro.DatosSeguimiento;
m_Articulos.Add(DetArt);
}
}
return m_Articulos;
}
public Lbl.Comprobantes.ColeccionDetalleArticulos ObtenerArticulos(Lfx.Data.Connection dataBase)
{
m_Articulos = new Lbl.Comprobantes.ColeccionDetalleArticulos(dataBase);
int i = 1;
foreach (DetalleComprobante Pro in this.ChildControls) {
if (Pro.IsEmpty == false) {
Lbl.Comprobantes.DetalleArticulo DetArt = new Lbl.Comprobantes.DetalleArticulo(dataBase);
DetArt.Articulo = Pro.Elemento as Lbl.Articulos.Articulo;
DetArt.Nombre = Pro.TextDetail;
DetArt.Orden = i++;
DetArt.Cantidad = Pro.Cantidad;
DetArt.Unitario = Pro.Unitario;
DetArt.Descuento = Pro.Descuento;
DetArt.DatosSeguimiento = Pro.DatosSeguimiento;
m_Articulos.Add(DetArt);
}
}
return m_Articulos;
}
