2018-08-17
exec sp_executesql N'SELECT [t4].[test], [t4].[CustomerID], [t4].[IsPartner], [t1].[TMKEmployee], [t6].[test] AS [test2], [t6].[ID], [t6].[Birthday], [t6].[Birthplace], [t6].[DocumentNum], [t6].[Email], [t6].[EntryDate], [t6].[ExitSystem], [t6].[Forzen], [t6].[Img], [t6].[IsAdmin], [t6].[IsConsultation], [t6].[IsDoctor], [t6].[IsSuperAdmin], [t6].[Name], [t6].[Password], [t6].[People], [t6].[Phone], [t6].[PositionID], [t6].[PositionTwoID], [t6].[Remark], [t6].[Sex], [t6].[Username], [t6].[Valid], [t6].[WorkingStatus], [t6].[WorkStatus], [t0].[Date] AS [ComeDate], [t7].[Name] AS [ComeRegister], [t9].[Name] AS [ComeRegisterDept], [t1].[IsCome] AS [cs], [t0].[CustomerID] AS [CustomerID2], [t1].[Name] AS [CustomerName],
(CASE
WHEN [t1].[CustomerServiceEmployee] IS NULL THEN CONVERT(NVarChar(20),@p8)
ELSE [t10].[Name]
END) AS [CustomerServiceName],
(CASE
WHEN [t1].[Sex] IS NULL THEN CONVERT(NVarChar(1),@p9)
ELSE [t1].[Sex]
END) AS [CustomerSex], [t11].[Status] AS [cs2], [t12].[Success] AS [ss], [t13].[Region],
(CASE
WHEN [t1].[SceneEmployee] IS NULL THEN CONVERT(NVarChar(20),@p10)
ELSE [t14].[Name]
END) AS [SceneEmployee],
(CASE
WHEN [t1].[TempEmployee] IS NULL THEN CONVERT(NVarChar(20),@p11)
ELSE [t15].[Name]
END) AS [TempEmployee],
(CASE
WHEN [t1].[UnderstandWayID] IS NULL THEN CONVERT(NVarChar(20),@p12)
ELSE [t16].[UnderstandWayName]
END) AS [UnderstandWay]
FROM [dbo].[CustomerComeLog] AS [t0]
INNER JOIN [dbo].[CustomerBaseInfo] AS [t1] ON [t1].[ID] = [t0].[CustomerID]
LEFT OUTER JOIN [dbo].[MemberCardInfo] AS [t2] ON [t2].[CustomerID] = [t1].[ID]
LEFT OUTER JOIN (
SELECT 1 AS [test], [t3].[CustomerID], [t3].[IsPartner]
FROM [dbo].[BeautifulPartnerCustomer] AS [t3]
) AS [t4] ON [t4].[CustomerID] = [t1].[ID]
LEFT OUTER JOIN (
SELECT 1 AS [test], [t5].[ID], [t5].[Birthday], [t5].[Birthplace], [t5].[DocumentNum], [t5].[Email], [t5].[EntryDate], [t5].[ExitSystem], [t5].[Forzen], [t5].[Img], [t5].[IsAdmin], [t5].[IsConsultation], [t5].[IsDoctor], [t5].[IsSuperAdmin], [t5].[Name], [t5].[Password], [t5].[People], [t5].[Phone], [t5].[PositionID], [t5].[PositionTwoID], [t5].[Remark], [t5].[Sex], [t5].[Username], [t5].[Valid], [t5].[WorkingStatus], [t5].[WorkStatus]
FROM [dbo].[Employee] AS [t5]
) AS [t6] ON [t6].[ID] = [t1].[TMKEmployee]
INNER JOIN [dbo].[Employee] AS [t7] ON [t7].[ID] = [t0].[HandleBy]
INNER JOIN [dbo].[PositionInfo] AS [t8] ON [t8].[ID] = [t7].[PositionID]
INNER JOIN [dbo].[Department] AS [t9] ON [t9].[ID] = [t8].[DepartmentID]
LEFT OUTER JOIN [dbo].[Employee] AS [t10] ON [t10].[ID] = [t1].[CustomerServiceEmployee]
LEFT OUTER JOIN [dbo].[StatusOfCustomer] AS [t11] ON [t11].[CustomerID] = [t1].[ID]
LEFT OUTER JOIN [dbo].[SuccessOfCustomer] AS [t12] ON [t12].[CustomerID] = [t1].[ID]
LEFT OUTER JOIN [dbo].[CustomerRegion] AS [t13] ON [t13].[ID] = [t1].[RegionID]
LEFT OUTER JOIN [dbo].[Employee] AS [t14] ON [t14].[ID] = [t1].[SceneEmployee]
LEFT OUTER JOIN [dbo].[Employee] AS [t15] ON [t15].[ID] = [t1].[TempEmployee]
LEFT OUTER JOIN [dbo].[CustomerUnderstandWay] AS [t16] ON [t16].[ID] = [t1].[UnderstandWayID]
WHERE ([t1].[Name] LIKE @p0) AND ((
(CASE
WHEN @p1 = 1 THEN
(CASE
WHEN ([t2].[MemberCardNum] IS NOT NULL) AND ([t2].[MemberCardNum] LIKE @p2) THEN 1
WHEN NOT (([t2].[MemberCardNum] IS NOT NULL) AND ([t2].[MemberCardNum] LIKE @p2)) THEN 0
ELSE NULL
END)
WHEN [t2].[MemberCardNum] IS NOT NULL THEN CONVERT(Int,
(CASE
WHEN [t2].[MemberCardNum] LIKE @p3 THEN 1
WHEN NOT ([t2].[MemberCardNum] LIKE @p3) THEN 0
ELSE NULL
END))
ELSE @p4
END)) = 1) AND ([t1].[IsCome] <> @p5) AND (([t0].[Date]) >= @p6) AND (([t0].[Date]) < @p7)',N'@p0 nvarchar(4000),@p1 int,@p2 varchar(8000),@p3 varchar(8000),@p4 int,@p5 int,@p6 datetime,@p7 datetime,@p8 nvarchar(4000),@p9 nvarchar(4000),@p10 nvarchar(4000),@p11 nvarchar(4000),@p12 nvarchar(4000)',@p0=N'%%',@p1=0,@p2='%%',@p3='%%',@p4=1,@p5=1,@p6='2018-08-17 00:00:00',@p7='2018-08-18 00:00:00',@p8=N'',@p9=N'',@p10=N'',@p11=N'',@p12=N''
select * from SuccessOfCustomer where CustomerID='D6CYD5NND9'
select * from MorHKeepAccountsInfo where Date>'2018-08-01 00:00:00' and Date<'2018-08-18 00:00:00' and MedicineDoc=1 and EditOrCharge=0;
update MorHKeepAccountsInfo set EditOrCharge=0
exec sp_executesql N'SELECT [t0].[Amount], [t0].[ChargeBy], [t0].[ChargeDate], [t0].[ID], [t0].[CustomerID], [t0].[Date], [t0].[EditOrCharge], [t0].[Handleby], [t0].[Register], [t0].[HospitalizedID], [t0].[MedicineDoc], [t0].[Status], [t0].[Type]
FROM [dbo].[MorHKeepAccountsInfo] AS [t0]
WHERE ([t0].[Date] >= @p0) AND ([t0].[Date] <= @p1) AND ([t0].[MedicineDoc] = @p2) AND ([t0].[EditOrCharge] = @p3) AND ([t0].[Type] = @p4)',N'@p0 datetime,@p1 datetime,@p2 int,@p3 int,@p4 int',@p0='2018-08-01 00:00:00',@p1='2018-08-18 00:00:00',@p2=1,@p3=0,@p4=0