2018-04-28

by 沧海之树 In 工作

select * from H_FrontSK_Project where Keyid='121213162658269501'

select * from CardInfo where CardNumber='PZSN4QGW8A'

select * from MemberCardHandle where MemberCardNum='12101516'

select count(*) from ChargeForCertainDocDetails

--alter table ReturnMoneyForCertainDocDetails drop CONSTRAINT [FK_ReturnMoneyForCertainDocDetails_CardInfo]

--delete from ChargeForCertainDocDetails

--DBCC CHECKIDENT('ChargeForCertainDocDetails', RESEED, 1)

select * from MorHKeepAccountsDetails

select * from Employee where id='00353'

select * from MemberCardHandle where CustomerID='V3QR829O42'

select * from ReturnMoneyForMHDetails;

SELECT [t0].[ID], [t0].[MhID], [t0].[GoodsID], [t0].[MedicineID], [t0].[ItemID], [t0].[UnitPrice], [t0].[Quantity], [t0].[Sconto], [t0].[Amount], [t0].[ItemType], [t0].[PrescriptionCode], [t0].[PrescriptionDetailsID], [t0].[Status]
FROM [dbo].[MorHKeepAccountsDetails] AS [t0]

SELECT [t0].[ID], [t0].[MhID], [t0].[MhDetailsID], [t0].[GoodsID], [t0].[MedicineID], [t0].[ItemID], [t0].[ItemName], [t0].[MhDocHandleBy], [t0].[BuyDate], [t0].[BuyPrice], [t0].[BuyQuantity], [t0].[BuySconto], [t0].[BuyAmount], [t0].[Price], [t0].[Quantity], [t0].[Amount], [t0].[CustomerID], [t0].[Date], [t0].[Status], [t0].[HandleBy], [t0].[Remark], [t0].[IsInside]
FROM [dbo].[ReturnMoneyForMHInfo] AS [t0]
WHERE ([t0].[Date] >= @p0) AND ([t0].[Date] < @p1)

select * from CustomerConsumptionInfo;
select count(*) from CustomerConsumptionDetailsID
select count(*) from CustomerConsumptionDetails

select * from CustomerConsumptionInfo where ExcutionNumber='F8ICK3XCSKYC'

select * from CustomerConsumptionInfoID where Now='F8ICK3XCSKYC'

select * from CustomerConsumptionInfoID where ID>=86066 --where Original='SK121015001'

--delete from CustomerConsumptionInfo where ExcutionNumber in (select Now from CustomerConsumptionInfoID where ID>=86066)
--delete from ChargeForCertainDocInfo where ExcutionNumber in (select Now from CustomerConsumptionInfoID where ID>=86066)
--delete from CustomerConsumptionInfoID where ID>=86066

--select * from CustomerConsumptionDetails where ID>=135069 and ID<=135769
--delete from CustomerConsumptionDetailsID where ID>=135069

--delete from CustomerConsumptionDetails where ID=135069

select * from ChargeForCertainDocInfo where ExcutionNumber in (select Now from CustomerConsumptionInfoID where ID>=86066)

select * from MorHKeepAccountsInfo where ID in (select Now from MorHKeepAccountsInfoID where ID>=20193)
select * from ChargeForMHInfo where MhID in (select Now from MorHKeepAccountsInfoID where ID>=20193)
select * from MorHKeepAccountsInfoID where ID>=20193

select * from MorHKeepAccountsDetails where ID>=44898

select count(*) from FinanceTotal

--delete from MorHKeepAccountsInfo where ID in (select Now from MorHKeepAccountsInfoID where ID>=20193)
--delete from ChargeForMHInfo where MhID in (select Now from MorHKeepAccountsInfoID where ID>=20193)
--delete from MorHKeepAccountsInfoID where ID>=20193

--delete from MorHKeepAccountsDetails where ID>=44898
--delete from MorHKeepAccountsDetailsID where ID>=44898

delete from CustomerConsumptionDetails where ExcutionNumber not in (select ExcutionNumber from ChargeForCertainDocInfo)

select * from CustomerConsumptionDetails where ExcutionNumber='72G1K5Z0IB9I'
select * from ChargeForCertainDocInfo where ExcutionNumber='72G1K5Z0IB9I'

select * from ExcuteInfo where CertainProjectID='102110'

select * from CustomerConsumptionInfo where ExcutionNumber='72G1K5Z0IB9I'

select* from PrePaymentRecharge