#############################
# 库位维护
#############################
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
#############################
# 入库作业
#############################
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'备注',
#############################
# 供应商维护
#############################
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'供应商名称：')
#############################
# 字典维护
#############################
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)
]
#############################
# 出库作业
#############################
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'出库状态',
#############################
# 仓库维护
#############################
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'录入时间',