class chooseGoods(QtGui.QDialog):
def __init__(self, parent=None):
QtGui.QWidget.__init__(self, parent)
self.chooseGoodsWidget = Ui_ChooseGoodsForm()
self.chooseGoodsWidget.setupUi(self)
self.chooseGoodsWidget.splitter.setSizes([150, 500])
self.loadData()
def loadData(self): # Дописать словарь !!!!!!!!!!
if db_filename:
print("Loading data...")
__sortingEnabled = self.chooseGoodsWidget.goodsTableWidget.isSortingEnabled(
)
self.chooseGoodsWidget.goodsTableWidget.setSortingEnabled(False)
# Задаём соответствие между полями БД и заголовками столбцов
# Сделать это глобально ?
dictionary = {
'name': 'Название',
'article': 'Артикул',
'measure': 'Ед. изм.'
}
conn = sqlite3.connect(str(db_filename))
cur = conn.cursor()
for key in dictionary:
query = ('select %s from goodscatalog' % key)
line = 0
cur.execute(query)
rows = cur.fetchall()
self.chooseGoodsWidget.goodsTableWidget.setRowCount(len(rows))
for row in rows:
item = QtGui.QTableWidgetItem()
for i in range(self.chooseGoodsWidget.goodsTableWidget.
columnCount()):
if self.chooseGoodsWidget.goodsTableWidget.horizontalHeaderItem(
i).text() == dictionary[key]:
self.chooseGoodsWidget.goodsTableWidget.setItem(
line, i, item)
item.setText(str(row[0]))
line += 1
print(row[0], dictionary[key])
conn.commit()
self.chooseGoodsWidget.goodsTableWidget.setSortingEnabled(
__sortingEnabled)
class chooseGoods(QtGui.QDialog):
def __init__(self, parent = None):
QtGui.QWidget.__init__(self, parent)
self.chooseGoodsWidget = Ui_ChooseGoodsForm()
self.chooseGoodsWidget.setupUi(self)
self.chooseGoodsWidget.splitter.setSizes([150, 500])
self.loadData()
def loadData(self): # Дописать словарь !!!!!!!!!!
if db_filename:
print ("Loading data...")
__sortingEnabled = self.chooseGoodsWidget.goodsTableWidget.isSortingEnabled()
self.chooseGoodsWidget.goodsTableWidget.setSortingEnabled(False)
# Задаём соответствие между полями БД и заголовками столбцов
# Сделать это глобально ?
dictionary = {'name': 'Название', 'article': 'Артикул', 'measure': 'Ед. изм.'}
conn = sqlite3.connect(str(db_filename))
cur = conn.cursor()
for key in dictionary:
query = ('select %s from goodscatalog' % key)
line = 0
cur.execute(query)
rows = cur.fetchall()
self.chooseGoodsWidget.goodsTableWidget.setRowCount(len(rows))
for row in rows:
item = QtGui.QTableWidgetItem()
for i in range(self.chooseGoodsWidget.goodsTableWidget.columnCount()):
if self.chooseGoodsWidget.goodsTableWidget.horizontalHeaderItem(i).text() == dictionary[key]:
self.chooseGoodsWidget.goodsTableWidget.setItem(line, i, item)
item.setText(str(row[0]))
line += 1
print (row[0], dictionary[key])
conn.commit()
self.chooseGoodsWidget.goodsTableWidget.setSortingEnabled(__sortingEnabled)
def __init__(self, parent = None):
QtGui.QWidget.__init__(self, parent)
self.chooseGoodsWidget = Ui_ChooseGoodsForm()
self.chooseGoodsWidget.setupUi(self)
self.chooseGoodsWidget.splitter.setSizes([150, 500])
self.loadData()
def __init__(self, parent=None):
QtGui.QWidget.__init__(self, parent)
self.chooseGoodsWidget = Ui_ChooseGoodsForm()
self.chooseGoodsWidget.setupUi(self)
self.chooseGoodsWidget.splitter.setSizes([150, 500])
self.loadData()
