tableviewfilter.h

跨平台,多数据库查看编辑和查询工具,平台支持windows,linux,数据库支持oracle,odbc,mysql,slite等

#ifndef TABLEVIEWFILTER_H
#define TABLEVIEWFILTER_H

#include <QtGui>
#include <QtSql>


class SpreadSheetDelegate : public QItemDelegate
{
    Q_OBJECT
public:
    SpreadSheetDelegate(QObject *parent = 0);
    QWidget *createEditor(QWidget *parent, const QStyleOptionViewItem &,
        const QModelIndex &index) const;
    void setEditorData(QWidget *editor, const QModelIndex &index) const;
    void setModelData(QWidget *editor, QAbstractItemModel *model,
        const QModelIndex &index) const;
    QSqlTableModel *globalModel;
    QWidget *parentWidget;
    void readValue();
    //int type; //0 是条件过滤 1 是排序
private slots:
    void commitAndCloseEditor( const QString &);
private :
	  //QSqlDatabase db;	  
	  QMap <int,QStringList  > mapValue;
	  

};


class TableViewFilter : public QDialog
{
	Q_OBJECT

public:
	TableViewFilter(QWidget *parent ,QSqlTableModel *modelparm);	
	~TableViewFilter();
	void setType(int nType);
	
signals:
public slots:
private slots:
	void tableChanged ( QTableWidgetItem *item);
	void itemChanged ( QTableWidgetItem * cur, QTableWidgetItem * pre);
	
private:
	QTableWidget *tableWidget;
	QSqlTableModel *globalModel;
	QString tableName;
	QMap <int ,QString> mapField;
	QMap <int ,QString> mapFieldName;
	SpreadSheetDelegate *delegate;
	//int type; //0 是条件过滤 1 是排序
	
	
	
};
#endif