ticketdb.sql

倉庫下線條碼源碼

values(0, 6, '6', '仓位', 0, '0.6')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(0, 7, '7', '客源地', 0, '0.7')


insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(6, 1, '01', '一号柜', 0, '0.6.8') --8
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(6, 2, '02', '二号柜', 0, '0.6.9') --9

insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(8, 1, '01.001', '第一格', 1, '0.6.8.10') --8
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(8, 2, '01.002', '第二格', 1, '0.6.8.11') --8

insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(9, 1, '02.001', '第一格', 1, '0.6.9.12') --9
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(9, 2, '02.002', '第二格', 1, '0.6.9.13') --9

insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(1, 1, '001', '制票入库', 1, '0.1.14') 
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(1, 2, '002', '采购入库', 1, '0.1.15')

insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(2, 1, '001', '领票', 1, '0.2.16')

insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(3, 1, '001', '作废', 1, '0.3.17')

insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(4, 1, '001', '制票', 1, '0.4.18')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(4, 2, '002', '外购', 1, '0.4.19')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(4, 3, '003', '撤消', 1, '0.4.20')

insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(5, 1, '001', '售票', 1, '0.5.21')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(5, 2, '002', '退票', 1, '0.5.22')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(5, 3, '003', '充值', 1, '0.5.23')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(5, 4, '004', '挂失', 1, '0.5.24')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(5, 5, '005', '违规', 1, '0.5.25')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(5, 6, '006', '解挂', 1, '0.5.26')

insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(7, 1, 'WZ', '未知', 1, '0.7.27')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(7, 2, 'GW', '国外', 1, '0.7.28')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(7, 3, 'SX', '山西', 1, '0.7.29')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(7, 4, 'XG', '香港', 1, '0.7.30')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(7, 5, 'AM', '澳门', 1, '0.7.31')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(7, 6, 'GD', '广东', 1, '0.7.32')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(7, 7, 'BJ', '北京', 1, '0.7.33')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(7, 8, 'SH', '上海', 1, '0.7.34')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(7, 9, 'JS', '江苏', 1, '0.7.35')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(7, 10, 'ZJ', '浙江', 1, '0.7.36')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(7, 11, 'GZ', '贵州', 1, '0.7.37')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(7, 12, 'CQ', '重庆', 1, '0.7.38')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(7, 13, 'YN', '云南', 1, '0.7.39')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(7, 14, 'SC', '四川', 1, '0.7.40')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(7, 15, 'TJ', '天津', 1, '0.7.41')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(7, 16, 'SD', '山东', 1, '0.7.42')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(7, 17, 'GX', '广西', 1, '0.7.43')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(7, 18, 'FJ', '福建', 1, '0.7.44')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(7, 19, 'HN', '湖南', 1, '0.7.45')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(7, 20, 'HB', '湖北', 1, '0.7.46')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(7, 21, 'AH', '安徽', 1, '0.7.47')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(7, 22, 'SHX', '陕西', 1, '0.7.48')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(7, 23, 'HAN', '海南', 1, '0.7.49')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(7, 24, 'JX', '江西', 1, '0.7.50')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(7, 25, 'HEB', '河北', 1, '0.7.51')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(7, 26, 'HEN', '河南', 1, '0.7.52')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(7, 27, 'JL', '吉林', 1, '0.7.53')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(7, 28, 'GS', '甘肃', 1, '0.7.54')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(7, 29, 'LN', '辽宁', 1, '0.7.55')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(7, 30, 'HLJ', '黑龙江', 1, '0.7.56')
insert SysParamTab(iParentID, iNo, sCode, sName, bIsLeaf, sPath)
values(7, 31, 'NMG', '内蒙古', 1, '0.7.57')
GO


insert into UserGroupTab(sGroupName, sCreator)
values('Administrator', 'SYSTEM_INIT')

insert into UserGroupTab(sGroupName, sCreator)
values('GeneralUsers', 'SYSTEM_INIT')
GO

insert into UserTab(sUserName, sPSW, sCreator)
values('Admin', '', 'SYSTEM_INIT')
GO

insert into UserTab(sUserName, sPSW, sCreator)
values('Users', '', 'SYSTEM_INIT')
GO

insert into UserAndGroup(iUserID, iGroupID)
values(1, 1)
GO

insert into PopedomModuleTab(sModuleName) values ('售票设置')
insert into PopedomModuleTab(sModuleName) values ('制票设置')
insert into PopedomModuleTab(sModuleName) values ('用户管理')
insert into PopedomModuleTab(sModuleName) values ('基础设施')
insert into PopedomModuleTab(sModuleName) values ('销售分录序时簿')
insert into PopedomModuleTab(sModuleName) values ('销售汇总明细表')
insert into PopedomModuleTab(sModuleName) values ('通道票务统计')
insert into PopedomModuleTab(sModuleName) values ('客源分析')
insert into PopedomModuleTab(sModuleName) values ('上机日志')
insert into PopedomModuleTab(sModuleName) values ('备份')
insert into PopedomModuleTab(sModuleName) values ('导入')
insert into PopedomModuleTab(sModuleName) values ('导出')
insert into PopedomModuleTab(sModuleName) values ('清空')
GO

insert into CardTypeTab(sCardTypeName, sCardTypeNote) values
('条码卡','')
insert into CardTypeTab(sCardTypeName, sCardTypeNote) values
('EM卡(ID卡)','')
--insert into CardTypeTab(sCardTypeName, sCardTypeNote) values
--('磁卡','')
--insert into CardTypeTab(sCardTypeName, sCardTypeNote) values
--('MIFARE卡','')
--insert into CardTypeTab(sCardTypeName, sCardTypeNote) values
--('TEMIC卡','')
GO

----------------------------------------------------------------------------------------------------
/*
drop proc pCanSaleTicket
GO
Create Proc pCanSaleTicket
  @iMakeTicketMode int,
  @sStartNo varchar(255),
  @sEndNo varchar(255),
  @iSaleCount int,
  @iTicketFlag int,
  @Result int output
As
begin  
BEGIN TRAN
  if @iMakeTicketMode=0
  begin
    select 1 success from InitCardTab with (TABLOCKX)
      where  sTicketSerial between @sStartNo and @sEndNo
    if @@RowCount>0
    begin
      set @Result = 0
      Rollback Tran 
      return
    end
    else
    begin
      set @Result = 1
    end
  end
  if @iMakeTicketMode=0
  begin
    select * from InitCardTab with (TABLOCKX) 
      where  sTicketSerial between @sStartNo and @sEndNo
      and iTicketFlag = @iTicketFlag --<>时不能检查库中不存在的票
    if @@RowCount<>@iSaleCount 
    begin
      set @Result = 0
      Rollback Tran 
      return 
    end 
    else
    begin
      set @Result = 1  
    end
  end
end
*/