ASP.NET开发的pos机收银系统源码

USE [PosOnline] GO /****** Object: StoredProcedure [dbo].[GetSerialNo] Script Date: 2017-06-23 18:15:09 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: stevenzheng@ingpalgroup.com -- Create date: 2015-05-12 -- Description: 生成不唯一序列号 -- Exanple: exec GetSerialNo 'LS' -- ============================================= CREATE procedure [dbo].[GetSerialNo] ( @sCode varchar(50), @StoreID varchar(50) ) as begin Declare @sValue varchar(16), @dToday datetime, @sQZ varchar(50), --这个代表前缀 @dNowDate VARCHAR(8)=convert(varchar(8), getdate(), 112) Begin Tran Begin Try -- 锁定该条记录，好多人用lock去锁，起始这里只要执行一句update就可以了 --在同一个事物中，执行了update语句之后就会启动锁 Update SerialNo set Value=Value where Code=@sCode AND StoreID=@StoreID Select @sValue = Value,@sQZ=QZ From SerialNo where Code=@sCode AND StoreID=@StoreID --Select @sQZ = sQZ From SerialNo where sCode=@sCode -- 因子表中没有记录，插入初始值--基数据必须手动去创建 If @sValue is null Begin Select @sValue = convert(bigint, @dNowDate + '0001') Update SerialNo set Value=@sValue where Code=@sCode AND StoreID=@StoreID end else Begin --因子表有记录 Select @dToday = substring(@sValue,1,8) --如果日期相等，则加1 If @dToday = @dNowDate Select @sValue = convert(varchar(16), (convert(bigint, @sValue) + 1)) else --如果日期不相等，则先赋值日期，流水号从1开始 Select @sValue = convert(bigint, @dNowDate +'0001') Update SerialNo set Value =@sValue where Code=@sCode AND StoreID=@StoreID End Select result = @sQZ+@sValue Commit Tran End Try Begin Catch Rollback Tran Select result = 'Error' End Catch end GO /****** Object: StoredProcedure [dbo].[usp_DeleteRestPos] Script Date: 2017-06-23 18:15:09 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: Stevenzheng@ingpalgroup.com -- Create date: 2017-5-22 -- Description: 删除挂单记录 /* */ -- ============================================= CREATE PROCEDURE [dbo].[usp_DeleteRestPos] ( @PosID VARCHAR(50) ) AS BEGIN BEGIN TRY BEGIN TRANSACTION trans DELETE FROM dbo.RestPos WHERE Id=@PosID IF(@@ROWCOUNT>0) BEGIN DELETE FROM RestPosDetail WHERE PosID=@PosID COMMIT TRAN trans END ELSE BEGIN ROLLBACK TRAN trans END END TRY BEGIN CATCH ROLLBACK TRAN trans END CATCH END GO /****** Object: StoredProcedure [dbo].[usp_DeleteUserAndRoleRelation] Script Date: 2017-06-23 18:15:09 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: stevenzheng@ingpalgroup.com -- Create date: 2015-05-10 -- Description: 删除用户及用户角色关联 /* [usp_DeleteUserAndRoleRelation] 'a9630436-5667-4365-b8a6-a1e1a274db02' */ -- ============================================= CREATE PROCEDURE [dbo].[usp_DeleteUserAndRoleRelation]( @UserID UNIQUEIDENTIFIER ) AS BEGIN DELETE FROM dbo.[Users] WHERE ID=@UserID IF(@@ROWCOUNT>0) BEGIN DELETE FROM dbo.UserRoleRelation WHERE UserID=@UserID; END END GO /****** Object: StoredProcedure [dbo].[usp_GetGoodsBaseByBarIdOrName] Script Date: 2017-06-23 18:15:09 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: Stevenzheng@ingpalgroup.com -- Create date: 2017-5-5 -- Description: 获取商品基础信息 -- ============================================= CREATE PROCEDURE [dbo].[usp_GetGoodsBaseByBarIdOrName] ( @BarId NVARCHAR(30)=-1 ) AS BEGIN SELECT [BarID] ,RTRIM(Name)Name ,[NameAbbr�