def on_CmdExportToExcel_clicked(self):
sql = """
SELECT fOrderID,
fQuant AS '数量Qtd',
fProductName AS '名称Descrição',
fLength AS '长Comp.',
fWidth AS '宽Larg.',
fPrice AS '单价P. Unitario',
fAmount AS '金额Total'
FROM t_order_detail
WHERE fOrderID IN (
SELECT 订单号码OrderID FROM ({cur_sql}) Q)"""
sql = sql.format(cur_sql=self.currentSQL)
tab = JPQueryFieldInfo(sql)
exp = JPExpExcelFromTabelFieldInfo(self.model.TabelFieldInfo,
self.MainForm)
exp.setSubQueryFieldInfo(tab, 0, 0)
exp.run()
def on_CmdExportToExcel_clicked(self):
exp = JPExpExcelFromTabelFieldInfo(self.model.TabelFieldInfo,
self.MainForm)
exp.run()
def on_CmdExportExcel_RecDetail_clicked(self):
if self.mod_rec:
exp = JPExpExcelFromTabelFieldInfo(self.mod_rec.TabelFieldInfo,
self.MainForm)
exp.run()
def on_CmdExportExcel_BillDetail_clicked(self):
if self.mod_order:
exp = JPExpExcelFromTabelFieldInfo(self.mod_order.TabelFieldInfo,
self.MainForm)
exp.run()
def on_CmdExportToExcel_Detail_clicked(self):
exp = JPExpExcelFromTabelFieldInfo(self.dataInfo_detail, self.MainForm)
exp.run()
def on_CmdExportToExcel_Low_clicked(self):
if self.dataInfo_low:
exp = JPExpExcelFromTabelFieldInfo(self.dataInfo_low,
self.MainForm)
exp.run()