From f830c733cbc071f023c9a9a4e1571b7c81d672bf Mon Sep 17 00:00:00 2001 From: king <18310653075@163.com> Date: 星期四, 12 十一月 2020 11:47:33 +0800 Subject: [PATCH] 2020-11-12 --- src/templates/sharecomponent/actioncomponent/index.jsx | 12 ++++++------ 1 files changed, 6 insertions(+), 6 deletions(-) diff --git a/src/templates/sharecomponent/actioncomponent/index.jsx b/src/templates/sharecomponent/actioncomponent/index.jsx index 9d03aa8..4302d09 100644 --- a/src/templates/sharecomponent/actioncomponent/index.jsx +++ b/src/templates/sharecomponent/actioncomponent/index.jsx @@ -75,11 +75,11 @@ } getBillPrintTemp = () => { - let _sql = `select PrintTempNO,Images,PrintTempNO+PrintTempName as PN from sPrintTemplate - where appkey= @appkey@ and Deleted=0 and typechartwo='web_print' + let _sql = `select ID,Images,PrintTempNO+PrintTempName as PN from sPrintTemplate + where appkey= @appkey@ and Deleted=0 and typechartwo='web_print' union select ID,Images,a.PrintTempNO+PrintTempName as PN - from (select * from sPrintTemplate where appkey= '' and Deleted=0 and typechartwo='web_print') a - left join (select PrintTempNO from sPrintTemplate where appkey= @appkey@ and Deleted=0 ) b + from (select * from sPrintTemplate where appkey= '' and Deleted=0 and typechartwo='web_print') a + left join (select PrintTempNO from sPrintTemplate where appkey= @appkey@ and Deleted=0 ) b on a.PrintTempNO=b.PrintTempNO left join (select Srcid from sPrintTemplate_Log where appkey='' and apicode= @appkey@ and Deleted=0 ) c on a.ID=c.Srcid where b.PrintTempNO is null and c.Srcid is null` @@ -88,7 +88,7 @@ func: 'sPC_Get_SelectedList', LText: Utils.formatOptions(_sql), obj_name: 'data', - arr_field: 'PN,PrintTempNO,Images' + arr_field: 'PN,ID,Images' } param.timestamp = moment().format('YYYY-MM-DD HH:mm:ss') @@ -100,7 +100,7 @@ if (res.status) { let temps = res.data.map(temp => { return { - value: temp.PrintTempNO, + value: temp.ID, text: temp.PN } }) -- Gitblit v1.8.0