银科环企修改付款方式和修改票种

--修改票务销售报表
select  * from GS_F_DEALINFO where NDEALID =1642 or NDEALID =1647 or NDEALID =1638
-- 修改票务付款方式报表
select * FROM  GS_F_DEALRATE where NDEALID =1642 or NDEALID =1647 or NDEALID =1638

直接照着历史记录修改就好

select * from GS_RM_REPORTMANAGEMENT WHERE  rm_name in ('闸机入园报表')
select * from GS_RM_REPORTMANAGEMENT where RM_GROUP in ('线下票务报表') and RM_NAME LIKE '%票务付款%'

EXEC PRC_RM_T_SEELSEQUENCE

--修改票务销售报表
select  * from GS_F_DEALINFO where NDEALID =1642 or NDEALID =1647 or NDEALID =1644
-- 修改票务付款方式报表
select * FROM  GS_F_DEALRATE where NDEALID =1642 or NDEALID =1647 or NDEALID =1644

--项目名称 STICKETNAMECH
select NTICKETID,* from GS_T_TICKETBASEINFO  

LEFT JOIN GS_T_TICKETBASEINFO TBI WITH(NOLOCK) ON TBI.NTICKETID=GFT.NTICKETID 
-- 修改票种信息
select * FROM GS_F_TICKETINFO GFT where NDEALID =1642 or NDEALID =1647 or NDEALID =1644

select SREMARK,* from GS_F_ACCESS order by NTICKETINFOID desc 

select sremark,* from GS_F_ACCESS where SBARCODE='220710000000484'  -- 票信息

-- 卡信息

select  * from MFYEARCRD_TBL

--1972024010

landv / landv.github.io

银科环企修改付款方式和修改票种 #82