• shzoo


    ---1财务接收2财务发放3票务科发放4售票组长发放5售票点返库6售票组长返库7票务科返库 Select * from TrnInv_Details where FPDM='2012041701' ---1财务接收(1笔)IN,2财务发放(2笔记录)TOUT、TIN,3票务科发放(2笔记录)TOUT、TIN,4售票组长发放TOUT\TIN ; ---5售票员返库(2笔记录)ROUT、RIN,6售票组长返库 ROUT\RIN,7票务科返库 ROUT\RIN --发给谁TrnInv_Tb, person是接收人,LUSERID是操作人员 Select * from TrnInv_Tbl where TrnNo in (Select trnno from TrnInv_Details where FPDM='2012041701' ) order by LDateTime asc ---1财务接收(1笔)IN,2财务发放(2笔记录)TIN\TOUT,3票务科发放(2笔记录)TOUT、TIN,4售票组长发放TOUT\TIN;5销售员门票返库ROUT、RIN,6售票组长返库 ROUT\RIN ,7票务科返库 ROUT\RIN Select * from TrnInv_Movements where FPDM='2012041701' order by LDateTime asc ---1财务接收(财务科)2财务发放(票务科)3票务科发放4售票组长发放{不含数量}5售票员门票返库 {含数量} Select * from TrnInv_Balance where FPDM='2012041701' ---1财务接收(财务科)2财务发放(票务科)3票务科发放(004)4售票组长发放(销售点) 返:5售票员门票返库 {含数量} 6组长返库7票务库返库--售票时UPDATE SELECT * FROM TRNINV_SUBBALANCE where FPDM='2012041701' order by LDateTime asc ---(组长将门票发给了谁)发放给销售员时insert,售票时update ;虽然返库了,但这笔发放给售票员的记录还在 select * from TERMINALTICKETNO_TRN where FPDM='2012041701' select * from TerminalTicketNo_Detail where FPDM='2012041701' ORDER BY LDATETIME DESC --前台登录后,选择发票代码后Insert进来,售票时update ---票挂在哪个售票员名下: Select TSB.TRNINV_SUBID as ID,TB.TicketOwner as 票类型, TB.FPDM as 发票代码, TT.startno as 开始号码, TT.endno as 结束号码,(TT.LastUsedNo- TT.startno) as 剩余数量, TT.LastUsedNo as 最后使用号码 from TRNINV_BALANCE TB INNER JOIN TRNINV_SUBBALANCE TSB ON TB.LOCATION=TSB.LOCATION inner join TERMINALTICKETNO_TRN tt on tt.FPdM=TB.FPDM and tt.startno=tsb.fromfphm and tt.endNo=tsb.Tofphm where TT.LUserId = N'GET' and (TT.LastUsedNo- TT.startno)>0 and TSB.LastUsedNo<>0 and TB.LOCATION<>N'财务科' and TB.LOCATION<>N'票务科' and tsb.LOCATION=N'销售点' and tt.terminalid=N'销售点' AND TB.FPDM IN (SELECT FPDM from trninv_details TD LEFT OUTER JOIN TrnInvTicketCat_TBL TT ON TD.MPZL=TT.CatCode GROUP BY FPDM, MPZL, MPXL,CATCONTROL HAVING CATCONTROL IS NULL ) and (TT.LastUsedNo- TT.startno)>0 order by TB.FPDM desc --select * from TrnInvTicketCat_TBL --税务 --SHUIWU
  • 相关阅读:
    实验 3:Mininet 实验——测量路径的损耗率
    福州大学软件工程实践个人编程作业
    实验 2:Mininet 实验——拓扑的命令脚本生成
    初识MinIO
    基础《Go学习笔记》读书笔记——函数
    Linux配置Golang 依赖包安装
    《Linux shell 脚本攻略》第1章——读书笔记
    vscode连接云服务,搭建Python远程开发
    Python多线程
    Python多进程
  • 原文地址:https://www.cnblogs.com/BrianLee/p/2454602.html
Copyright © 2020-2023  润新知