石基银客环企相关

银客环企年卡库存状态修改

select * from GS_RM_REPORTMANAGEMENT WHERE  rm_name like ('%入库%')
-- 年卡入库

 select
GS_One.NPHYSICALNO 物理号,
GS_One.SPRINTNO 印刷号,
GS_Four.NTYPEID 一卡通ID,
GS_Four.STYPENAME 类型名称,
 CONVERT(varchar(100),GS_One.DCREATEDT,23) AS 录入日期,
GS_One.DCREATEDT AS 录入时间,
GS_Three.EMP_NAME 录入人,
 case GS_One.NSTATUS  
 when '0' then '已初始化'
 when '1' then '流通中'
 when '2' then '流通结束'
 when '3' then '作废'
 when '4' then '挂失'
 when '5' then '冻结'
 end 状态 ,
GS_Four.ISCARD 
from   GS_W_WRISTBANDDEPOT  GS_One
left join sac_employee GS_Three ON GS_One.NCREATEBY=GS_Three.EMP_ID
left join GS_W_WristbandType GS_Four ON GS_One.NSTARTNO= GS_Four.NTYPEID

select NSTATUS,* from GS_W_WRISTBANDDEPOT

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

--修改票务销售报表
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

银科环企修改入库单

-- 采购入库单据
SELECT  * FROM  GS_I_WHINDL WHERE WHINID  ='INB2021071316495900095' and WHNUMBER IN (440.000000)
select * from GS_T_COMMODITY where NCOMMSONCLASS =5 and ncommid =123

--采购入库单，显示明细名字
SELECT  gtc.VCOMMYNAME ,g.* FROM  GS_I_WHINDL g LEFT JOIN GS_T_COMMODITY gtc on g.ITID = gtc.NCOMMID  WHERE WHINID  ='INB2021071316495900095' 

--删除数据
DELETE FROM Galasys.dbo.GS_I_WHINDL
WHERE WHINID=N'INB2021071316495900095' AND INREC=N'102';


- 分类
select * from GS_T_CLASSES  
--- select * from GS_T_CLASSES_SK

-- 明细商品
select * from GS_T_COMMODITY where NCOMMSONCLASS =5 and VCOMMYNAME in (
select VCOMMYNAME from GS_T_COMMODITY where NCOMMSONCLASS =5 group by VCOMMYNAME
having count (VCOMMYNAME)>1) order by VCOMMYNAME

select * from GS_T_COMMODITY where NCOMMSONCLASS =5 and NCOMMID in (145)
delete  GS_T_COMMODITY where NCOMMSONCLASS =5 and NCOMMID in (145)

--超过反审核日期入库单如何修改


--报表查询
select * from GS_RM_REPORTMANAGEMENT where RM_GROUP like '%库%'

--库存视图
select * from v_item_base 

--库存视图
select b.VCOMMYNAME 商品名称,ra.itid,b.VCOMMBARCODE 商品编码,Convert(decimal(18,2),ra.stocknumber) 库存数量
FROM V_STOCK ra left join v_item_base b on b.NCOMMID=ra.itid
where b.VCOMMBARCODE='03B306'

-- 库存明细数据，自入库日期以后，明日数据
SELECT   *  FROM   GS_WH_STOCK WHERE itid=306   --TODO这里需要进行修改明细数据

--入库单据视图
select * from v_ioflow where billid ='INB2022060211052800655' and vcommbarcode  ='03B306'
--    入库单明细                             
select * from GS_I_WHINDL where WHINID ='INB2022060211052800655'   --TODO这里需要进行修改明细数据
--入库单主单
select * from GS_I_WHIN where WHINID ='INB2022060211052800655'


-- 更新入库单审核时间
-- UPDATE GS_I_WHIN SET BLADTTIME = '2022-06-21 11:10:36.000' where WHINID ='INB2022060211052800655'

银科环企快捷登录

C:\BaiduNetdiskDownload\逸享客户端\\app_login.exe userName=admin url=http://IP:8001 platform=1 update_server_port=8001 update_server=127.0.0.1 password=123


C:\BaiduNetdiskDownload\逸享客户端\\app_login.exe userName=admin url=http://IP:8001 platform=2 update_server_port=8001 update_server=127.0.0.1 password=123

platform =1 前台
platform =2 后台


password md5加密

账号~md5密码
"admin~202cb962ac59075b964b07152d234b70"

银科环企删除商品信息

-- 分类
select * from GS_T_CLASSES  
--- select * from GS_T_CLASSES_SK

-- 明细商品
select * from GS_T_COMMODITY where NCOMMSONCLASS =5 and VCOMMYNAME in (
select VCOMMYNAME from GS_T_COMMODITY where NCOMMSONCLASS =5 group by VCOMMYNAME
having count (VCOMMYNAME)>1) order by VCOMMYNAME

select * from GS_T_COMMODITY where NCOMMSONCLASS =5 and NCOMMID in (157,169,159,127,153,165,160,176,152,149,161,172,154,170,164)
delete  GS_T_COMMODITY where NCOMMSONCLASS =5 and NCOMMID in (157,169,159,127,153,165,160,176,152,149,161,172,154,170,164)