From 02a05c4e82e74c290e80ae7710fbb394ed7cac7a Mon Sep 17 00:00:00 2001 From: king <18310653075@163.com> Date: 星期三, 15 四月 2020 12:51:04 +0800 Subject: [PATCH] 2020-04-15 --- src/templates/zshare/verifycardprint/index.jsx | 20 ++++++++++---------- 1 files changed, 10 insertions(+), 10 deletions(-) diff --git a/src/templates/zshare/verifycardprint/index.jsx b/src/templates/zshare/verifycardprint/index.jsx index 9c9cb76..24242c7 100644 --- a/src/templates/zshare/verifycardprint/index.jsx +++ b/src/templates/zshare/verifycardprint/index.jsx @@ -54,20 +54,20 @@ } componentDidMount() { - let _sql = `select ID,Images,PrintTempNO+PrintTempName as PN from sPrintTemplate - where appkey= @appkey@ and Deleted=0 - union select ID,Images,a.PrintTempNO+PrintTempName as PN - from (select * from sPrintTemplate where appkey= '' and Deleted=0 ) 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` + let _sql = `select PrintTempNO,Images,PrintTempNO+PrintTempName as PN from sPrintTemplate + where appkey= @appkey@ and Deleted=0 + union select ID,Images,a.PrintTempNO+PrintTempName as PN + from (select * from sPrintTemplate where appkey= '' and Deleted=0 ) 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` let param = { func: 'sPC_Get_SelectedList', LText: Utils.formatOptions(_sql), obj_name: 'data', - arr_field: 'PN,ID,Images' + arr_field: 'PN,PrintTempNO,Images' } param.timestamp = moment().format('YYYY-MM-DD HH:mm:ss') + '.000' @@ -77,7 +77,7 @@ if (res.status) { let temps = res.data.map(temp => { return { - value: temp.ID, + value: temp.PrintTempNO, text: temp.PN, img: temp.Images } -- Gitblit v1.8.0