ListControlStockView Class Reference

Muestra y administra el listado de control de stocks. More...

#include <listcontrolstockview.h>

Inheritance diagram for ListControlStockView:

SubForm2Bf SubForm3 BLWidget Ui_SubForm3Base QWidget PEmpresaBase

Public Member Functions

 ListControlStockView (QWidget *parent=0, const char *name=0)
 ~ListControlStockView ()
virtual int borrar ()
virtual void cargar (QString)
virtual int guardar ()
virtual void pregenerar ()

Data Fields

QString mdb_idinventario

Detailed Description

Muestra y administra el listado de control de stocks.

Definition at line 32 of file listcontrolstockview.h.

Constructor & Destructor Documentation

ListControlStockView::ListControlStockView ( QWidget *  parent = 0,
const char *  name = 0 
)

Parameters:
parent 

Definition at line 28 of file listcontrolstockview.cpp.

References _depura(), SubForm3::addSHeader(), SHeader::DBBlockView, DBCampo::DBboolean, DBCampo::DBDupPrimaryKey, DBCampo::DBint, SHeader::DBNone, DBCampo::DBNoSave, DBCampo::DBNothing, SHeader::DBNoView, SHeader::DBNoWrite, DBCampo::DBnumeric, DBCampo::DBPrimaryKey, DBCampo::DBRequired, DBCampo::DBvarchar, FALSE, SubForm3::setDBCampoId(), SubForm3::setDBTableName(), and SubForm3::setinsercion().

00029         : SubForm2Bf(parent) {
00030     _depura("ListControlStockView::ListControlStockView", 0);
00031     setDBTableName("controlstock");
00032     setDBCampoId("idarticulo");
00033     addSHeader("punteocontrolstock", DBCampo::DBboolean, DBCampo::DBNothing, SHeader::DBNone, tr("Punteado"));
00034     addSHeader("codigoalmacen", DBCampo::DBvarchar, DBCampo::DBNoSave, SHeader::DBNone, tr("Codigo almacen"));
00035     addSHeader("nomalmacen", DBCampo::DBvarchar, DBCampo::DBNoSave, SHeader::DBNone | SHeader::DBNoWrite, tr("Nombre almacen"));
00036     addSHeader("codigocompletoarticulo", DBCampo::DBvarchar, DBCampo::DBNoSave, SHeader::DBNone | SHeader::DBNoWrite, tr("Codigo completo articulo"));
00037     addSHeader("nomarticulo", DBCampo::DBvarchar, DBCampo::DBNoSave, SHeader::DBNone | SHeader::DBNoWrite, tr("Nombre articulo"));
00038     addSHeader("stockantcontrolstock", DBCampo::DBnumeric, DBCampo::DBNothing, SHeader::DBNoWrite, tr("Stock anterior"));
00039     addSHeader("stocknewcontrolstock", DBCampo::DBnumeric, DBCampo::DBRequired, SHeader::DBNone, tr("Stock revisado"));
00040     addSHeader("idarticulo", DBCampo::DBint, DBCampo::DBPrimaryKey, SHeader::DBNone | SHeader::DBNoView, tr("Id articulo"));
00041     addSHeader("idalmacen", DBCampo::DBint, DBCampo::DBPrimaryKey, SHeader::DBNone | SHeader::DBNoView, "Id almacen");
00042     addSHeader("idinventario", DBCampo::DBint, DBCampo::DBPrimaryKey, SHeader::DBNone | SHeader::DBNoView, "Id inventario");
00043     addSHeader("idarticulopk", DBCampo::DBint, DBCampo::DBNoSave | DBCampo::DBDupPrimaryKey, SHeader::DBNone | SHeader::DBNoView | SHeader::DBBlockView, "idarticulo");
00044     addSHeader("idalmacenpk", DBCampo::DBint,  DBCampo::DBNoSave | DBCampo::DBDupPrimaryKey, SHeader::DBNone | SHeader::DBNoView | SHeader::DBBlockView, "idalmacen");
00045 //    addSHeader("idinventariopk", DBCampo::DBint,  DBCampo::DBNoSave | DBCampo::DBDupPrimaryKey, SHeader::DBNone | SHeader::DBNoView | SHeader::DBBlockView, "idinventario");
00046     setinsercion(FALSE);
00047     _depura("END ListControlStockView::ListControlStockView", 0);
00048 }

ListControlStockView::~ListControlStockView (  ) 

Definition at line 95 of file listcontrolstockview.cpp.

References _depura().

00095                                             {
00096     _depura("ListControlStockView::~ListControlStockView", 0);
00097     _depura("END ListControlStockView::~ListControlStockView", 0);
00098 }

Member Function Documentation

int ListControlStockView::borrar (  )  [virtual]

Returns:

Reimplemented from SubForm3.

Definition at line 72 of file listcontrolstockview.cpp.

References _depura(), postgresiface2::ejecuta(), PEmpresaBase::empresaBase(), and mdb_idinventario.

Referenced by Inventario::borrar().

00072                                  {
00073     _depura("ListControlStockView::borrar", 0);
00074     empresaBase()->ejecuta("DELETE FROM controlstock WHERE idinventario = " + mdb_idinventario);
00075     _depura("END ListControlStockView::borrar", 0);
00076     return 0;
00077 }

void ListControlStockView::cargar ( QString  idinventario  )  [virtual]

Parameters:
idinventario 

Reimplemented from SubForm2Bf.

Definition at line 55 of file listcontrolstockview.cpp.

References _depura(), SubForm2Bf::cargar(), and mdb_idinventario.

Referenced by Inventario::cargar().

00055                                                       {
00056     _depura("ListControlStockView::cargar", 0);
00057     mdb_idinventario = idinventario;
00058     QString SQLQuery = "SELECT * FROM ";
00059     SQLQuery += " (SELECT idarticulo, idalmacen, nomarticulo, nomalmacen, codigocompletoarticulo, codigoalmacen FROM articulo, almacen) AS t1 ";
00060     SQLQuery += " LEFT JOIN (SELECT punteocontrolstock,stockantcontrolstock, stocknewcontrolstock, idarticulo AS idarticulopk, idalmacen AS idalmacenpk, idinventario FROM controlstock WHERE idinventario = " + idinventario + ") AS t2 ON t1.idarticulo = t2.idarticulopk AND t1.idalmacen = t2.idalmacenpk ";
00061     SQLQuery += " WHERE idarticulo IN (SELECT idarticulo from lalbaranp UNION SELECT idarticulo FROM lalbaran)";
00062     SQLQuery += " ORDER BY codigoalmacen, codigocompletoarticulo";
00063     SubForm2Bf::cargar(SQLQuery);
00064     _depura("END ListControlStockView::cargar", 0);
00065 }

int ListControlStockView::guardar (  )  [virtual]

Returns:

Reimplemented from SubForm3.

Definition at line 105 of file listcontrolstockview.cpp.

References _depura(), and SubForm3::guardar().

Referenced by Inventario::guardar().

00105                                   {
00106     _depura("ListControlStockView::guardar", 0);
00107     SubForm2Bf::guardar();
00108     _depura("END ListControlStockView::guardar", 0);
00109     return 0;
00110 }

void ListControlStockView::pregenerar (  )  [virtual]

Definition at line 83 of file listcontrolstockview.cpp.

References _depura(), and SubForm3::cargar().

Referenced by Inventario::pregenerar().

00083                                       {
00084     _depura("ListControlStockView::pregenerar", 0);
00085     QString query;
00086     query = "SELECT * FROM (SELECT * FROM articulo, almacen) AS t1 LEFT JOIN (SELECT stocknewcontrolstock, idarticulo AS idarticulopk, idalmacen AS idalmacenpk, idinventario AS idinventariopk FROM controlstock WHERE idinventario = 1) AS t2 ON t1.idarticulo = t2.idarticulopk AND t1.idalmacen = t2.idalmacenpk ORDER BY codigoalmacen, codigocompletoarticulo;";
00087     SubForm3::cargar(query);
00088     _depura("END ListControlStockView::pregenerar", 0);
00089 }

Field Documentation

QString ListControlStockView::mdb_idinventario

Definition at line 36 of file listcontrolstockview.h.

Referenced by borrar(), and cargar().

The documentation for this class was generated from the following files:
Generated on Sat Dec 15 00:01:56 2007 for BulmaGes by  doxygen 1.5.1