Python QTable.ColumnDfnの例

コード例 #1

#############################
# 库位维护
#############################

import wx
import util.QTable as qtable
import util.SqliteUtil as sqliteUtil

columns = [qtable.CheckBoxColumnDfn(),
           qtable.ColumnDfn(u'仓库', 'shAlias', percent=20, type=qtable.TextType(), readonly=True),
           qtable.ColumnDfn(u'库位编号', 'slId', percent=15, type=qtable.TextType(), readonly=True),
           qtable.ColumnDfn(u'库位名称', 'slName', percent=15, type=qtable.TextType(), readonly=True),
           qtable.ColumnDfn(u'备注', 'remark', percent=40, type=qtable.TextType(), readonly=True),
           qtable.ColumnDfn(u'录入时间', 'ctime', size=150, type=qtable.TextType(), readonly=True)
           ]
YES_NO = 1
SAVE_NO = 2


def GetSHDict():
    dic = {}
    db = sqliteUtil.EasySqlite()
    result = db.execute(
        " select t1.sh_id as key, t1.sh_id || '-' || (case when t1.status = 1 then t1.sh_name else t1.sh_name || '(失效)' end) as value "
        " from storehouse t1 "
        " order by t1.ctime desc")
    for e in result:
        dic[e["key"]] = e["value"]

    return dic

コード例 #2

ファイル: InStoreHouse.py プロジェクト: liliangming/wms_wxpython

#############################
# 入库作业
#############################
import wx
import util.QTable as qtable
import util.SqliteUtil as sqliteUtil
import wx.adv as adv

columns = [
    qtable.CheckBoxColumnDfn(),
    qtable.ColumnDfn(u'产品编码',
                     'productCode',
                     percent=10,
                     type=qtable.TextType(),
                     readonly=True),
    qtable.ColumnDfn(u'产品名称',
                     'productName',
                     percent=10,
                     type=qtable.TextType(),
                     readonly=True),
    qtable.ColumnDfn(u'产品分类',
                     'productCategoryName',
                     percent=10,
                     type=qtable.TextType(),
                     readonly=True),
    qtable.ColumnDfn(u'产品描述',
                     'productDesc',
                     percent=20,
                     type=qtable.TextType(),
                     readonly=True),
    qtable.ColumnDfn(u'备注',

コード例 #3

#############################
# 供应商维护
#############################

import wx
import util.QTable as qtable
import util.SqliteUtil as sqliteUtil

columns = [qtable.CheckBoxColumnDfn(),
           qtable.ColumnDfn(u'编号', 'supplierId', size=60, type=qtable.TextType(), readonly=True),
           qtable.ColumnDfn(u'名称', 'supplierName', percent=10, type=qtable.TextType(), readonly=True),
           qtable.ColumnDfn(u'地址', 'supplierAddr', percent=20, type=qtable.TextType(), readonly=True),
           qtable.ColumnDfn(u'电话', 'phoneNumber', percent=10, type=qtable.TextType(), readonly=True),
           qtable.ColumnDfn(u'邮箱', 'email', percent=10,
                            type=qtable.TextType(), readonly=True),
           qtable.ColumnDfn(u'备注', 'remark', percent=20, type=qtable.TextType(), readonly=True),
           qtable.ColumnDfn(u'录入时间', 'ctime', size=150, type=qtable.TextType(), readonly=True)
           ]
YES_NO = 1
SAVE_NO = 2


class SupplierPanel(wx.Panel):
    def __init__(self, parent):
        wx.Panel.__init__(self, parent)

        vbox = wx.BoxSizer(wx.VERTICAL)

        # 查询栏
        hbox1 = wx.BoxSizer(wx.HORIZONTAL)
        self.supplier_name = wx.StaticText(self, label=u'供应商名称：')

コード例 #4

ファイル: Dictionary.py プロジェクト: liliangming/wms_wxpython

#############################
# 字典维护
#############################

import wx
import util.QTable as qtable
import util.SqliteUtil as sqliteUtil

columns = [
    qtable.CheckBoxColumnDfn(),
    qtable.ColumnDfn(u'字典类型',
                     'dicTypeName',
                     percent=20,
                     type=qtable.TextType(),
                     readonly=True),
    qtable.ColumnDfn(u'字典值',
                     'dicValue',
                     percent=30,
                     type=qtable.TextType(),
                     readonly=True),
    qtable.ColumnDfn(u'备注',
                     'remark',
                     percent=50,
                     type=qtable.TextType(),
                     readonly=True),
    qtable.ColumnDfn(u'录入时间',
                     'ctime',
                     size=150,
                     type=qtable.TextType(),
                     readonly=True)
]

コード例 #5

ファイル: OutStoreHouse.py プロジェクト: liliangming/wms_wxpython

#############################
# 出库作业
#############################
import wx
import util.QTable as qtable
import util.SqliteUtil as sqliteUtil
import wx.adv as adv

columns = [
    qtable.CheckBoxColumnDfn(),
    qtable.ColumnDfn(u'出库单号',
                     'orderNo',
                     percent=10,
                     type=qtable.TextType(),
                     readonly=True),
    qtable.ColumnDfn(u'客户',
                     'customerName',
                     percent=10,
                     type=qtable.TextType(),
                     readonly=True),
    qtable.ColumnDfn(u'仓库',
                     'shName',
                     percent=10,
                     type=qtable.TextType(),
                     readonly=True),
    qtable.ColumnDfn(u'出库类型',
                     'orderTypeName',
                     percent=20,
                     type=qtable.TextType(),
                     readonly=True),
    qtable.ColumnDfn(u'出库状态',

コード例 #6

ファイル: StoreHouse.py プロジェクト: liliangming/wms_wxpython

#############################
# 仓库维护
#############################

import wx
import util.QTable as qtable
import util.SqliteUtil as sqliteUtil

columns = [
    qtable.CheckBoxColumnDfn(),
    qtable.ColumnDfn(u'编号',
                     'shId',
                     percent=10,
                     type=qtable.TextType(),
                     readonly=True),
    qtable.ColumnDfn(u'名称',
                     'shName',
                     percent=10,
                     type=qtable.TextType(),
                     readonly=True),
    qtable.ColumnDfn(u'地址',
                     'shAddr',
                     percent=40,
                     type=qtable.TextType(),
                     readonly=True),
    qtable.ColumnDfn(u'备注',
                     'remark',
                     percent=40,
                     type=qtable.TextType(),
                     readonly=True),
    qtable.ColumnDfn(u'录入时间',