---------------------------------------- Timestamp: 2026/3/7 8:04:23 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[DrugFlag] AS [DrugFlag], [Extent1].[Memo] AS [Memo], [Extent1].[EditorFlag] AS [EditorFlag], [Extent1].[Shortcut] AS [Shortcut], [Extent1].[ReserveFlag] AS [ReserveFlag], [Extent1].[GroupFlag] AS [GroupFlag], [Extent1].[SceneFlag] AS [SceneFlag], [Extent1].[Color] AS [Color], [Extent1].[ImageName] AS [ImageName], [Extent1].[TimeStamp] AS [TimeStamp] FROM [OP].[RecipeKind] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[DrugFlag] IN (cast(1 as smallint)) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:04:23 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[DrugFlag] AS [DrugFlag], [Extent1].[Memo] AS [Memo], [Extent1].[EditorFlag] AS [EditorFlag], [Extent1].[Shortcut] AS [Shortcut], [Extent1].[ReserveFlag] AS [ReserveFlag], [Extent1].[GroupFlag] AS [GroupFlag], [Extent1].[SceneFlag] AS [SceneFlag], [Extent1].[Color] AS [Color], [Extent1].[ImageName] AS [ImageName], [Extent1].[TimeStamp] AS [TimeStamp] FROM [OP].[RecipeKind] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[DrugFlag] IN (cast(0 as smallint)) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:04:23 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[DrugFlag] AS [DrugFlag], [Extent1].[Memo] AS [Memo], [Extent1].[EditorFlag] AS [EditorFlag], [Extent1].[Shortcut] AS [Shortcut], [Extent1].[ReserveFlag] AS [ReserveFlag], [Extent1].[GroupFlag] AS [GroupFlag], [Extent1].[SceneFlag] AS [SceneFlag], [Extent1].[Color] AS [Color], [Extent1].[ImageName] AS [ImageName], [Extent1].[TimeStamp] AS [TimeStamp] FROM [OP].[RecipeKind] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[DrugFlag] IN (cast(1 as smallint)) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:04:23 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[DrugFlag] AS [DrugFlag], [Extent1].[Memo] AS [Memo], [Extent1].[EditorFlag] AS [EditorFlag], [Extent1].[Shortcut] AS [Shortcut], [Extent1].[ReserveFlag] AS [ReserveFlag], [Extent1].[GroupFlag] AS [GroupFlag], [Extent1].[SceneFlag] AS [SceneFlag], [Extent1].[Color] AS [Color], [Extent1].[ImageName] AS [ImageName], [Extent1].[TimeStamp] AS [TimeStamp] FROM [OP].[RecipeKind] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[DrugFlag] IN (cast(0 as smallint)) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:04:23 Message: SELECT TOP (1) [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Py] AS [Py], [Extent1].[Wb] AS [Wb], [Extent1].[Birthday] AS [Birthday], [Extent1].[SexId] AS [SexId], [Extent1].[MaritalStatusId] AS [MaritalStatusId], [Extent1].[Sfzh] AS [Sfzh], [Extent1].[TechTitleId] AS [TechTitleId], [Extent1].[DegreeId] AS [DegreeId], [Extent1].[InnerPhone] AS [InnerPhone], [Extent1].[Mobile] AS [Mobile], [Extent1].[Mail] AS [Mail], [Extent1].[DefaultDeptId] AS [DefaultDeptId], [Extent1].[DefaultWardId] AS [DefaultWardId], [Extent1].[Depts] AS [Depts], [Extent1].[Wards] AS [Wards], [Extent1].[StaffFlag] AS [StaffFlag], [Extent1].[DataMaintainFlag] AS [DataMaintainFlag], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[YBStaffId] AS [YBStaffId], [Extent1].[YBDeptId] AS [YBDeptId], [Extent1].[HRStaffId] AS [HRStaffId], [Extent1].[StaffDesc] AS [StaffDesc], [Extent1].[Memo] AS [Memo], [Extent1].[TimeStamp] AS [TimeStamp], [Extent1].[CAOpenId] AS [CAOpenId], [Extent1].[StdCode] AS [StdCode], [Extent1].[StdName] AS [StdName] FROM [Common].[Staff] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Id] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:04:23 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>zz001 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:04:23 Message: SELECT [Extent1].[Xh] AS [Xh], [Extent1].[RegXh] AS [RegXh], [Extent1].[VisitDate] AS [VisitDate], [Extent1].[PatId] AS [PatId], [Extent1].[YBId] AS [YBId], [Extent1].[CredenceXh] AS [CredenceXh], [Extent1].[RecipeName] AS [RecipeName], [Extent1].[RecipeNum] AS [RecipeNum], [Extent1].[RecipeKindId] AS [RecipeKindId], [Extent1].[DoctorId] AS [DoctorId], [Extent1].[DoctorDatetime] AS [DoctorDatetime], [Extent1].[DoctorRecipeNo] AS [DoctorRecipeNo], [Extent1].[DoctorDept] AS [DoctorDept], [Extent1].[ValidFlag] AS [ValidFlag], [Extent1].[ExeDept] AS [ExeDept], [Extent1].[ExeDate] AS [ExeDate], [Extent1].[ExeFlag] AS [ExeFlag], [Extent1].[ExeStaffId] AS [ExeStaffId], [Extent1].[MessageFlag] AS [MessageFlag], [Extent1].[FeeFlag] AS [FeeFlag], [Extent1].[FeeDate] AS [FeeDate], [Extent1].[StaffId] AS [StaffId], [Extent1].[MessageDate] AS [MessageDate], [Extent1].[ETOrderXh] AS [ETOrderXh], [Extent1].[OriginFlag] AS [OriginFlag], [Extent1].[DiseaseFlag] AS [DiseaseFlag], [Extent1].[ReturnFlag] AS [ReturnFlag], [Extent1].[ReturnReason] AS [ReturnReason], [Extent1].[Memo] AS [Memo], [Extent1].[RecipeFlag] AS [RecipeFlag], [Extent1].[RecipeSerialNo] AS [RecipeSerialNo], [Extent1].[PrintFlag] AS [PrintFlag], [Extent1].[PrintDate] AS [PrintDate], [Extent1].[FYWinId] AS [FYWinId], [Extent1].[FYWinName] AS [FYWinName], [Extent1].[MedicalGuidance] AS [MedicalGuidance], [Extent1].[TreatmentScopeFlag] AS [TreatmentScopeFlag], [Extent1].[AttorneysName] AS [AttorneysName], [Extent1].[AttorneysPhone] AS [AttorneysPhone], [Extent1].[AttorneySfzh] AS [AttorneySfzh], [Extent1].[RelatedRecipeXh] AS [RelatedRecipeXh], [Extent1].[OperationRequestXh] AS [OperationRequestXh], [Extent1].[GenerationFriedFlag] AS [GenerationFriedFlag], [Extent1].[GenerationFriedNum] AS [GenerationFriedNum], [Extent1].[RecipeNumPerDay] AS [RecipeNumPerDay], [Extent1].[ModifiedDate] AS [ModifiedDate], [Extent1].[UsageId] AS [UsageId], [Extent1].[PrepayFlag] AS [PrepayFlag], [Extent1].[ConfirmFlag] AS [ConfirmFlag], [Extent1].[SourceXh] AS [SourceXh], [Extent1].[SourceKind] AS [SourceKind], [Extent1].[ZQNum] AS [ZQNum], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[ValidUsableFlag] AS [ValidUsableFlag], [Extent1].[SyncSignNo] AS [SyncSignNo], [Extent1].[ReturnStaffId] AS [ReturnStaffId], [Extent1].[ReturnTime] AS [ReturnTime], [Extent1].[DoctorCAFlag] AS [DoctorCAFlag], [Extent1].[AddressXh] AS [AddressXh], [Extent1].[DecoctFlag] AS [DecoctFlag], [Extent1].[FixTemplateName] AS [FixTemplateName] FROM [OP].[Recipe] AS [Extent1] WITH (NOLOCK) INNER JOIN [OP].[IdXhJoin] AS [Extent2] WITH (NOLOCK) ON [Extent2].[JoinXh] = [Extent1].[Xh] WHERE [Extent2].[PId] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:04:23 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustCIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=OPApp;uid=sa;>>1471 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:04:24 Message: SELECT [Extent1].[Xh] AS [Xh], [Extent1].[PatId] AS [PatId], [Extent1].[PatName] AS [PatName], [Extent1].[YBId] AS [YBId], [Extent1].[CredenceXh] AS [CredenceXh], [Extent1].[RegFlag] AS [RegFlag], [Extent1].[DeptId] AS [DeptId], [Extent1].[RegDate] AS [RegDate], [Extent1].[ReturnVisitFlag] AS [ReturnVisitFlag], [Extent1].[PreRegFlag] AS [PreRegFlag], [Extent1].[BookingXh] AS [BookingXh], [Extent1].[RegKindId] AS [RegKindId], [Extent1].[StaffId] AS [StaffId], [Extent1].[CreatedDate] AS [CreatedDate], [Extent1].[FeeFlag] AS [FeeFlag], [Extent1].[RegId] AS [RegId], [Extent1].[RegName] AS [RegName], [Extent1].[RegDoctorId] AS [RegDoctorId], [Extent1].[RegTimeFlag] AS [RegTimeFlag], [Extent1].[VisitFlag] AS [VisitFlag], [Extent1].[DoctorId1] AS [DoctorId1], [Extent1].[DoctorId2] AS [DoctorId2], [Extent1].[CreditLine] AS [CreditLine], [Extent1].[HomeBedXh] AS [HomeBedXh], [Extent1].[HisVisitNo] AS [HisVisitNo], [Extent1].[AnmeldenProvinceId] AS [AnmeldenProvinceId], [Extent1].[AnmeldenStateId] AS [AnmeldenStateId], [Extent1].[AnmeldenCountyId] AS [AnmeldenCountyId], [Extent1].[AnmeldenAddress] AS [AnmeldenAddress], [Extent1].[AnmeldenZip] AS [AnmeldenZip], [Extent1].[WorkingUnit] AS [WorkingUnit], [Extent1].[WorkingZip] AS [WorkingZip], [Extent1].[WorkingPhone] AS [WorkingPhone], [Extent1].[ReturnAuditFlag] AS [ReturnAuditFlag], [Extent1].[IndexNumber] AS [IndexNumber], [Extent1].[CardKindId] AS [CardKindId], [Extent1].[CardNo] AS [CardNo], [Extent1].[DisplayCardNo] AS [DisplayCardNo], [Extent1].[ZoneId] AS [ZoneId], [Extent1].[EmergencyFlag] AS [EmergencyFlag], [Extent1].[SelfRegister] AS [SelfRegister], [Extent1].[DiseaseId] AS [DiseaseId], [Extent1].[PredictVisitTime] AS [PredictVisitTime], [Extent1].[SerialFlag] AS [SerialFlag], [Extent1].[SpaceRegFlag] AS [SpaceRegFlag], [Extent1].[OverFlag] AS [OverFlag], [Extent1].[RescueCarFlag] AS [RescueCarFlag], [Extent1].[DoctorTime1] AS [DoctorTime1], [Extent1].[DoctorTime2] AS [DoctorTime2], [Extent1].[PatLogXh] AS [PatLogXh], [Extent1].[LastSignTime] AS [LastSignTime] FROM [OP].[Register] AS [Extent1] WITH (NOLOCK) INNER JOIN [OP].[IdXhJoin] AS [Extent2] WITH (NOLOCK) ON [Extent2].[JoinXh] = [Extent1].[Xh] WHERE [Extent2].[PId] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:04:24 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=OPApp;uid=sa;>>2827 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:04:24 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[SurName] AS [SurName], [Extent1].[GivenName] AS [GivenName], [Extent1].[Py] AS [Py], [Extent1].[Wb] AS [Wb], [Extent1].[OPBLH] AS [OPBLH], [Extent1].[IPBLH] AS [IPBLH], [Extent1].[SexId] AS [SexId], [Extent1].[Birthday] AS [Birthday], [Extent1].[Weight] AS [Weight], [Extent1].[IdentityKindId] AS [IdentityKindId], [Extent1].[Sfzh] AS [Sfzh], [Extent1].[MaritalStatusId] AS [MaritalStatusId], [Extent1].[CountryId] AS [CountryId], [Extent1].[NationId] AS [NationId], [Extent1].[ProvinceId] AS [ProvinceId], [Extent1].[StateId] AS [StateId], [Extent1].[CountyId] AS [CountyId], [Extent1].[Address] AS [Address], [Extent1].[Phone] AS [Phone], [Extent1].[Mobile] AS [Mobile], [Extent1].[Mail] AS [Mail], [Extent1].[StaffId] AS [StaffId], [Extent1].[ModifiedDate] AS [ModifiedDate], [Extent1].[Memo] AS [Memo], [Extent1].[PatImage] AS [PatImage], [Extent1].[HospitalId] AS [HospitalId], [Extent1].[SysFlag] AS [SysFlag], [Extent1].[HisPatId] AS [HisPatId], [Extent1].[HisVerId] AS [HisVerId], [Extent1].[ProfessionId] AS [ProfessionId], [Extent1].[BirthProvinceId] AS [BirthProvinceId], [Extent1].[BirthStateId] AS [BirthStateId], [Extent1].[BirthCountyId] AS [BirthCountyId], [Extent1].[BirthAddress] AS [BirthAddress], [Extent1].[Zip] AS [Zip], [Extent1].[BirthZip] AS [BirthZip], [Extent1].[Password] AS [Password], [Extent1].[CreditLine] AS [CreditLine], [Extent1].[Enterprise] AS [Enterprise], [Extent1].[ABOBloodTypeId] AS [ABOBloodTypeId], [Extent1].[RHBloodTypeFlag] AS [RHBloodTypeFlag], [Extent1].[ObstetricsNo] AS [ObstetricsNo], [Extent1].[RegionFlag] AS [RegionFlag], [Extent1].[NativePlaceProvinceId] AS [NativePlaceProvinceId], [Extent1].[NativePlaceStateId] AS [NativePlaceStateId], [Extent1].[NativePlaceCountyId] AS [NativePlaceCountyId], [Extent1].[EnterpriseZip] AS [EnterpriseZip], [Extent1].[EnterprisePhone] AS [EnterprisePhone], [Extent1].[Contactman] AS [Contactman], [Extent1].[ContactRelationshipId] AS [ContactRelationshipId], [Extent1].[ContactPhone] AS [ContactPhone], [Extent1].[ContactAdress] AS [ContactAdress], [Extent1].[NativePlace] AS [NativePlace], [Extent1].[AnmeldenProvinceId] AS [AnmeldenProvinceId], [Extent1].[AnmeldenStateId] AS [AnmeldenStateId], [Extent1].[AnmeldenCountyId] AS [AnmeldenCountyId], [Extent1].[AnmeldenAddress] AS [AnmeldenAddress], [Extent1].[AnmeldenZip] AS [AnmeldenZip], [Extent1].[CrippleFlag] AS [CrippleFlag], [Extent1].[CrippleNo] AS [CrippleNo], [Extent1].[Height] AS [Height], [Extent1].[VillageId] AS [VillageId], [Extent1].[BirthVillageId] AS [BirthVillageId], [Extent1].[NativePlaceVillageId] AS [NativePlaceVillageId], [Extent1].[AnmeldenVillageId] AS [AnmeldenVillageId], [Extent1].[NullSfzhReason] AS [NullSfzhReason], [Extent1].[ContactIdentityKindId] AS [ContactIdentityKindId], [Extent1].[ContactIdentityNo] AS [ContactIdentityNo], [Extent1].[Guardianman] AS [Guardianman], [Extent1].[GuardianRelationshipId] AS [GuardianRelationshipId], [Extent1].[GuardianPhone] AS [GuardianPhone], [Extent1].[GuardianAddress] AS [GuardianAddress], [Extent1].[GuardianIdentityNo] AS [GuardianIdentityNo], [Extent1].[EnterpriseAddress] AS [EnterpriseAddress], [Extent1].[OPTotalYBMoney] AS [OPTotalYBMoney], [Extent1].[OPTotalMoney] AS [OPTotalMoney] FROM [Common].[Patient] AS [Extent1] WITH (NOLOCK) INNER JOIN [Common].[IdXhJoin] AS [Extent2] WITH (NOLOCK) ON [Extent2].[JoinXh] = [Extent1].[Id] WHERE [Extent2].[PId] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:04:24 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>10140 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:04:24 Message: SELECT TOP (1) [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Description] AS [Description], [Extent1].[Value] AS [Value], [Extent1].[RefValue] AS [RefValue], [Extent1].[DataType] AS [DataType], [Extent1].[CanSelect] AS [CanSelect], [Extent1].[SelectSource] AS [SelectSource], [Extent1].[GroupId] AS [GroupId], [Extent1].[Editor] AS [Editor], [Extent1].[EditableFlag] AS [EditableFlag], [Extent1].[ModifyStaffId] AS [ModifyStaffId], [Extent1].[ModifyTime] AS [ModifyTime], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[TimeStamp] AS [TimeStamp] FROM [Common].[Setting] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Id] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:04:24 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>DrugPublicConfig ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:11:54 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[DrugFlag] AS [DrugFlag], [Extent1].[Memo] AS [Memo], [Extent1].[EditorFlag] AS [EditorFlag], [Extent1].[Shortcut] AS [Shortcut], [Extent1].[ReserveFlag] AS [ReserveFlag], [Extent1].[GroupFlag] AS [GroupFlag], [Extent1].[SceneFlag] AS [SceneFlag], [Extent1].[Color] AS [Color], [Extent1].[ImageName] AS [ImageName], [Extent1].[TimeStamp] AS [TimeStamp] FROM [OP].[RecipeKind] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[DrugFlag] IN (cast(1 as smallint)) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:11:54 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[DrugFlag] AS [DrugFlag], [Extent1].[Memo] AS [Memo], [Extent1].[EditorFlag] AS [EditorFlag], [Extent1].[Shortcut] AS [Shortcut], [Extent1].[ReserveFlag] AS [ReserveFlag], [Extent1].[GroupFlag] AS [GroupFlag], [Extent1].[SceneFlag] AS [SceneFlag], [Extent1].[Color] AS [Color], [Extent1].[ImageName] AS [ImageName], [Extent1].[TimeStamp] AS [TimeStamp] FROM [OP].[RecipeKind] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[DrugFlag] IN (cast(0 as smallint)) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:11:54 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[DrugFlag] AS [DrugFlag], [Extent1].[Memo] AS [Memo], [Extent1].[EditorFlag] AS [EditorFlag], [Extent1].[Shortcut] AS [Shortcut], [Extent1].[ReserveFlag] AS [ReserveFlag], [Extent1].[GroupFlag] AS [GroupFlag], [Extent1].[SceneFlag] AS [SceneFlag], [Extent1].[Color] AS [Color], [Extent1].[ImageName] AS [ImageName], [Extent1].[TimeStamp] AS [TimeStamp] FROM [OP].[RecipeKind] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[DrugFlag] IN (cast(1 as smallint)) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:11:54 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[DrugFlag] AS [DrugFlag], [Extent1].[Memo] AS [Memo], [Extent1].[EditorFlag] AS [EditorFlag], [Extent1].[Shortcut] AS [Shortcut], [Extent1].[ReserveFlag] AS [ReserveFlag], [Extent1].[GroupFlag] AS [GroupFlag], [Extent1].[SceneFlag] AS [SceneFlag], [Extent1].[Color] AS [Color], [Extent1].[ImageName] AS [ImageName], [Extent1].[TimeStamp] AS [TimeStamp] FROM [OP].[RecipeKind] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[DrugFlag] IN (cast(0 as smallint)) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:11:54 Message: SELECT TOP (1) [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Py] AS [Py], [Extent1].[Wb] AS [Wb], [Extent1].[Birthday] AS [Birthday], [Extent1].[SexId] AS [SexId], [Extent1].[MaritalStatusId] AS [MaritalStatusId], [Extent1].[Sfzh] AS [Sfzh], [Extent1].[TechTitleId] AS [TechTitleId], [Extent1].[DegreeId] AS [DegreeId], [Extent1].[InnerPhone] AS [InnerPhone], [Extent1].[Mobile] AS [Mobile], [Extent1].[Mail] AS [Mail], [Extent1].[DefaultDeptId] AS [DefaultDeptId], [Extent1].[DefaultWardId] AS [DefaultWardId], [Extent1].[Depts] AS [Depts], [Extent1].[Wards] AS [Wards], [Extent1].[StaffFlag] AS [StaffFlag], [Extent1].[DataMaintainFlag] AS [DataMaintainFlag], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[YBStaffId] AS [YBStaffId], [Extent1].[YBDeptId] AS [YBDeptId], [Extent1].[HRStaffId] AS [HRStaffId], [Extent1].[StaffDesc] AS [StaffDesc], [Extent1].[Memo] AS [Memo], [Extent1].[TimeStamp] AS [TimeStamp], [Extent1].[CAOpenId] AS [CAOpenId], [Extent1].[StdCode] AS [StdCode], [Extent1].[StdName] AS [StdName] FROM [Common].[Staff] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Id] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:11:54 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>zz001 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:11:54 Message: SELECT [Extent1].[Xh] AS [Xh], [Extent1].[RegXh] AS [RegXh], [Extent1].[VisitDate] AS [VisitDate], [Extent1].[PatId] AS [PatId], [Extent1].[YBId] AS [YBId], [Extent1].[CredenceXh] AS [CredenceXh], [Extent1].[RecipeName] AS [RecipeName], [Extent1].[RecipeNum] AS [RecipeNum], [Extent1].[RecipeKindId] AS [RecipeKindId], [Extent1].[DoctorId] AS [DoctorId], [Extent1].[DoctorDatetime] AS [DoctorDatetime], [Extent1].[DoctorRecipeNo] AS [DoctorRecipeNo], [Extent1].[DoctorDept] AS [DoctorDept], [Extent1].[ValidFlag] AS [ValidFlag], [Extent1].[ExeDept] AS [ExeDept], [Extent1].[ExeDate] AS [ExeDate], [Extent1].[ExeFlag] AS [ExeFlag], [Extent1].[ExeStaffId] AS [ExeStaffId], [Extent1].[MessageFlag] AS [MessageFlag], [Extent1].[FeeFlag] AS [FeeFlag], [Extent1].[FeeDate] AS [FeeDate], [Extent1].[StaffId] AS [StaffId], [Extent1].[MessageDate] AS [MessageDate], [Extent1].[ETOrderXh] AS [ETOrderXh], [Extent1].[OriginFlag] AS [OriginFlag], [Extent1].[DiseaseFlag] AS [DiseaseFlag], [Extent1].[ReturnFlag] AS [ReturnFlag], [Extent1].[ReturnReason] AS [ReturnReason], [Extent1].[Memo] AS [Memo], [Extent1].[RecipeFlag] AS [RecipeFlag], [Extent1].[RecipeSerialNo] AS [RecipeSerialNo], [Extent1].[PrintFlag] AS [PrintFlag], [Extent1].[PrintDate] AS [PrintDate], [Extent1].[FYWinId] AS [FYWinId], [Extent1].[FYWinName] AS [FYWinName], [Extent1].[MedicalGuidance] AS [MedicalGuidance], [Extent1].[TreatmentScopeFlag] AS [TreatmentScopeFlag], [Extent1].[AttorneysName] AS [AttorneysName], [Extent1].[AttorneysPhone] AS [AttorneysPhone], [Extent1].[AttorneySfzh] AS [AttorneySfzh], [Extent1].[RelatedRecipeXh] AS [RelatedRecipeXh], [Extent1].[OperationRequestXh] AS [OperationRequestXh], [Extent1].[GenerationFriedFlag] AS [GenerationFriedFlag], [Extent1].[GenerationFriedNum] AS [GenerationFriedNum], [Extent1].[RecipeNumPerDay] AS [RecipeNumPerDay], [Extent1].[ModifiedDate] AS [ModifiedDate], [Extent1].[UsageId] AS [UsageId], [Extent1].[PrepayFlag] AS [PrepayFlag], [Extent1].[ConfirmFlag] AS [ConfirmFlag], [Extent1].[SourceXh] AS [SourceXh], [Extent1].[SourceKind] AS [SourceKind], [Extent1].[ZQNum] AS [ZQNum], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[ValidUsableFlag] AS [ValidUsableFlag], [Extent1].[SyncSignNo] AS [SyncSignNo], [Extent1].[ReturnStaffId] AS [ReturnStaffId], [Extent1].[ReturnTime] AS [ReturnTime], [Extent1].[DoctorCAFlag] AS [DoctorCAFlag], [Extent1].[AddressXh] AS [AddressXh], [Extent1].[DecoctFlag] AS [DecoctFlag], [Extent1].[FixTemplateName] AS [FixTemplateName] FROM [OP].[Recipe] AS [Extent1] WITH (NOLOCK) INNER JOIN [OP].[IdXhJoin] AS [Extent2] WITH (NOLOCK) ON [Extent2].[JoinXh] = [Extent1].[Xh] WHERE [Extent2].[PId] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:11:54 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustCIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=OPApp;uid=sa;>>1473 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:11:54 Message: SELECT [Extent1].[Xh] AS [Xh], [Extent1].[PatId] AS [PatId], [Extent1].[PatName] AS [PatName], [Extent1].[YBId] AS [YBId], [Extent1].[CredenceXh] AS [CredenceXh], [Extent1].[RegFlag] AS [RegFlag], [Extent1].[DeptId] AS [DeptId], [Extent1].[RegDate] AS [RegDate], [Extent1].[ReturnVisitFlag] AS [ReturnVisitFlag], [Extent1].[PreRegFlag] AS [PreRegFlag], [Extent1].[BookingXh] AS [BookingXh], [Extent1].[RegKindId] AS [RegKindId], [Extent1].[StaffId] AS [StaffId], [Extent1].[CreatedDate] AS [CreatedDate], [Extent1].[FeeFlag] AS [FeeFlag], [Extent1].[RegId] AS [RegId], [Extent1].[RegName] AS [RegName], [Extent1].[RegDoctorId] AS [RegDoctorId], [Extent1].[RegTimeFlag] AS [RegTimeFlag], [Extent1].[VisitFlag] AS [VisitFlag], [Extent1].[DoctorId1] AS [DoctorId1], [Extent1].[DoctorId2] AS [DoctorId2], [Extent1].[CreditLine] AS [CreditLine], [Extent1].[HomeBedXh] AS [HomeBedXh], [Extent1].[HisVisitNo] AS [HisVisitNo], [Extent1].[AnmeldenProvinceId] AS [AnmeldenProvinceId], [Extent1].[AnmeldenStateId] AS [AnmeldenStateId], [Extent1].[AnmeldenCountyId] AS [AnmeldenCountyId], [Extent1].[AnmeldenAddress] AS [AnmeldenAddress], [Extent1].[AnmeldenZip] AS [AnmeldenZip], [Extent1].[WorkingUnit] AS [WorkingUnit], [Extent1].[WorkingZip] AS [WorkingZip], [Extent1].[WorkingPhone] AS [WorkingPhone], [Extent1].[ReturnAuditFlag] AS [ReturnAuditFlag], [Extent1].[IndexNumber] AS [IndexNumber], [Extent1].[CardKindId] AS [CardKindId], [Extent1].[CardNo] AS [CardNo], [Extent1].[DisplayCardNo] AS [DisplayCardNo], [Extent1].[ZoneId] AS [ZoneId], [Extent1].[EmergencyFlag] AS [EmergencyFlag], [Extent1].[SelfRegister] AS [SelfRegister], [Extent1].[DiseaseId] AS [DiseaseId], [Extent1].[PredictVisitTime] AS [PredictVisitTime], [Extent1].[SerialFlag] AS [SerialFlag], [Extent1].[SpaceRegFlag] AS [SpaceRegFlag], [Extent1].[OverFlag] AS [OverFlag], [Extent1].[RescueCarFlag] AS [RescueCarFlag], [Extent1].[DoctorTime1] AS [DoctorTime1], [Extent1].[DoctorTime2] AS [DoctorTime2], [Extent1].[PatLogXh] AS [PatLogXh], [Extent1].[LastSignTime] AS [LastSignTime] FROM [OP].[Register] AS [Extent1] WITH (NOLOCK) INNER JOIN [OP].[IdXhJoin] AS [Extent2] WITH (NOLOCK) ON [Extent2].[JoinXh] = [Extent1].[Xh] WHERE [Extent2].[PId] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:11:54 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=OPApp;uid=sa;>>2829 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:11:54 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[SurName] AS [SurName], [Extent1].[GivenName] AS [GivenName], [Extent1].[Py] AS [Py], [Extent1].[Wb] AS [Wb], [Extent1].[OPBLH] AS [OPBLH], [Extent1].[IPBLH] AS [IPBLH], [Extent1].[SexId] AS [SexId], [Extent1].[Birthday] AS [Birthday], [Extent1].[Weight] AS [Weight], [Extent1].[IdentityKindId] AS [IdentityKindId], [Extent1].[Sfzh] AS [Sfzh], [Extent1].[MaritalStatusId] AS [MaritalStatusId], [Extent1].[CountryId] AS [CountryId], [Extent1].[NationId] AS [NationId], [Extent1].[ProvinceId] AS [ProvinceId], [Extent1].[StateId] AS [StateId], [Extent1].[CountyId] AS [CountyId], [Extent1].[Address] AS [Address], [Extent1].[Phone] AS [Phone], [Extent1].[Mobile] AS [Mobile], [Extent1].[Mail] AS [Mail], [Extent1].[StaffId] AS [StaffId], [Extent1].[ModifiedDate] AS [ModifiedDate], [Extent1].[Memo] AS [Memo], [Extent1].[PatImage] AS [PatImage], [Extent1].[HospitalId] AS [HospitalId], [Extent1].[SysFlag] AS [SysFlag], [Extent1].[HisPatId] AS [HisPatId], [Extent1].[HisVerId] AS [HisVerId], [Extent1].[ProfessionId] AS [ProfessionId], [Extent1].[BirthProvinceId] AS [BirthProvinceId], [Extent1].[BirthStateId] AS [BirthStateId], [Extent1].[BirthCountyId] AS [BirthCountyId], [Extent1].[BirthAddress] AS [BirthAddress], [Extent1].[Zip] AS [Zip], [Extent1].[BirthZip] AS [BirthZip], [Extent1].[Password] AS [Password], [Extent1].[CreditLine] AS [CreditLine], [Extent1].[Enterprise] AS [Enterprise], [Extent1].[ABOBloodTypeId] AS [ABOBloodTypeId], [Extent1].[RHBloodTypeFlag] AS [RHBloodTypeFlag], [Extent1].[ObstetricsNo] AS [ObstetricsNo], [Extent1].[RegionFlag] AS [RegionFlag], [Extent1].[NativePlaceProvinceId] AS [NativePlaceProvinceId], [Extent1].[NativePlaceStateId] AS [NativePlaceStateId], [Extent1].[NativePlaceCountyId] AS [NativePlaceCountyId], [Extent1].[EnterpriseZip] AS [EnterpriseZip], [Extent1].[EnterprisePhone] AS [EnterprisePhone], [Extent1].[Contactman] AS [Contactman], [Extent1].[ContactRelationshipId] AS [ContactRelationshipId], [Extent1].[ContactPhone] AS [ContactPhone], [Extent1].[ContactAdress] AS [ContactAdress], [Extent1].[NativePlace] AS [NativePlace], [Extent1].[AnmeldenProvinceId] AS [AnmeldenProvinceId], [Extent1].[AnmeldenStateId] AS [AnmeldenStateId], [Extent1].[AnmeldenCountyId] AS [AnmeldenCountyId], [Extent1].[AnmeldenAddress] AS [AnmeldenAddress], [Extent1].[AnmeldenZip] AS [AnmeldenZip], [Extent1].[CrippleFlag] AS [CrippleFlag], [Extent1].[CrippleNo] AS [CrippleNo], [Extent1].[Height] AS [Height], [Extent1].[VillageId] AS [VillageId], [Extent1].[BirthVillageId] AS [BirthVillageId], [Extent1].[NativePlaceVillageId] AS [NativePlaceVillageId], [Extent1].[AnmeldenVillageId] AS [AnmeldenVillageId], [Extent1].[NullSfzhReason] AS [NullSfzhReason], [Extent1].[ContactIdentityKindId] AS [ContactIdentityKindId], [Extent1].[ContactIdentityNo] AS [ContactIdentityNo], [Extent1].[Guardianman] AS [Guardianman], [Extent1].[GuardianRelationshipId] AS [GuardianRelationshipId], [Extent1].[GuardianPhone] AS [GuardianPhone], [Extent1].[GuardianAddress] AS [GuardianAddress], [Extent1].[GuardianIdentityNo] AS [GuardianIdentityNo], [Extent1].[EnterpriseAddress] AS [EnterpriseAddress], [Extent1].[OPTotalYBMoney] AS [OPTotalYBMoney], [Extent1].[OPTotalMoney] AS [OPTotalMoney] FROM [Common].[Patient] AS [Extent1] WITH (NOLOCK) INNER JOIN [Common].[IdXhJoin] AS [Extent2] WITH (NOLOCK) ON [Extent2].[JoinXh] = [Extent1].[Id] WHERE [Extent2].[PId] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:11:54 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>10142 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:11:54 Message: SELECT TOP (1) [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Description] AS [Description], [Extent1].[Value] AS [Value], [Extent1].[RefValue] AS [RefValue], [Extent1].[DataType] AS [DataType], [Extent1].[CanSelect] AS [CanSelect], [Extent1].[SelectSource] AS [SelectSource], [Extent1].[GroupId] AS [GroupId], [Extent1].[Editor] AS [Editor], [Extent1].[EditableFlag] AS [EditableFlag], [Extent1].[ModifyStaffId] AS [ModifyStaffId], [Extent1].[ModifyTime] AS [ModifyTime], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[TimeStamp] AS [TimeStamp] FROM [Common].[Setting] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Id] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:11:54 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>DrugPublicConfig ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:19:37 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[DrugFlag] AS [DrugFlag], [Extent1].[Memo] AS [Memo], [Extent1].[EditorFlag] AS [EditorFlag], [Extent1].[Shortcut] AS [Shortcut], [Extent1].[ReserveFlag] AS [ReserveFlag], [Extent1].[GroupFlag] AS [GroupFlag], [Extent1].[SceneFlag] AS [SceneFlag], [Extent1].[Color] AS [Color], [Extent1].[ImageName] AS [ImageName], [Extent1].[TimeStamp] AS [TimeStamp] FROM [OP].[RecipeKind] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[DrugFlag] IN (cast(1 as smallint)) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:19:37 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[DrugFlag] AS [DrugFlag], [Extent1].[Memo] AS [Memo], [Extent1].[EditorFlag] AS [EditorFlag], [Extent1].[Shortcut] AS [Shortcut], [Extent1].[ReserveFlag] AS [ReserveFlag], [Extent1].[GroupFlag] AS [GroupFlag], [Extent1].[SceneFlag] AS [SceneFlag], [Extent1].[Color] AS [Color], [Extent1].[ImageName] AS [ImageName], [Extent1].[TimeStamp] AS [TimeStamp] FROM [OP].[RecipeKind] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[DrugFlag] IN (cast(0 as smallint)) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:19:37 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[DrugFlag] AS [DrugFlag], [Extent1].[Memo] AS [Memo], [Extent1].[EditorFlag] AS [EditorFlag], [Extent1].[Shortcut] AS [Shortcut], [Extent1].[ReserveFlag] AS [ReserveFlag], [Extent1].[GroupFlag] AS [GroupFlag], [Extent1].[SceneFlag] AS [SceneFlag], [Extent1].[Color] AS [Color], [Extent1].[ImageName] AS [ImageName], [Extent1].[TimeStamp] AS [TimeStamp] FROM [OP].[RecipeKind] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[DrugFlag] IN (cast(1 as smallint)) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:19:37 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[DrugFlag] AS [DrugFlag], [Extent1].[Memo] AS [Memo], [Extent1].[EditorFlag] AS [EditorFlag], [Extent1].[Shortcut] AS [Shortcut], [Extent1].[ReserveFlag] AS [ReserveFlag], [Extent1].[GroupFlag] AS [GroupFlag], [Extent1].[SceneFlag] AS [SceneFlag], [Extent1].[Color] AS [Color], [Extent1].[ImageName] AS [ImageName], [Extent1].[TimeStamp] AS [TimeStamp] FROM [OP].[RecipeKind] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[DrugFlag] IN (cast(0 as smallint)) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:19:37 Message: SELECT TOP (1) [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Py] AS [Py], [Extent1].[Wb] AS [Wb], [Extent1].[Birthday] AS [Birthday], [Extent1].[SexId] AS [SexId], [Extent1].[MaritalStatusId] AS [MaritalStatusId], [Extent1].[Sfzh] AS [Sfzh], [Extent1].[TechTitleId] AS [TechTitleId], [Extent1].[DegreeId] AS [DegreeId], [Extent1].[InnerPhone] AS [InnerPhone], [Extent1].[Mobile] AS [Mobile], [Extent1].[Mail] AS [Mail], [Extent1].[DefaultDeptId] AS [DefaultDeptId], [Extent1].[DefaultWardId] AS [DefaultWardId], [Extent1].[Depts] AS [Depts], [Extent1].[Wards] AS [Wards], [Extent1].[StaffFlag] AS [StaffFlag], [Extent1].[DataMaintainFlag] AS [DataMaintainFlag], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[YBStaffId] AS [YBStaffId], [Extent1].[YBDeptId] AS [YBDeptId], [Extent1].[HRStaffId] AS [HRStaffId], [Extent1].[StaffDesc] AS [StaffDesc], [Extent1].[Memo] AS [Memo], [Extent1].[TimeStamp] AS [TimeStamp], [Extent1].[CAOpenId] AS [CAOpenId], [Extent1].[StdCode] AS [StdCode], [Extent1].[StdName] AS [StdName] FROM [Common].[Staff] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Id] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:19:37 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>zz001 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:19:37 Message: SELECT [Extent1].[Xh] AS [Xh], [Extent1].[RegXh] AS [RegXh], [Extent1].[VisitDate] AS [VisitDate], [Extent1].[PatId] AS [PatId], [Extent1].[YBId] AS [YBId], [Extent1].[CredenceXh] AS [CredenceXh], [Extent1].[RecipeName] AS [RecipeName], [Extent1].[RecipeNum] AS [RecipeNum], [Extent1].[RecipeKindId] AS [RecipeKindId], [Extent1].[DoctorId] AS [DoctorId], [Extent1].[DoctorDatetime] AS [DoctorDatetime], [Extent1].[DoctorRecipeNo] AS [DoctorRecipeNo], [Extent1].[DoctorDept] AS [DoctorDept], [Extent1].[ValidFlag] AS [ValidFlag], [Extent1].[ExeDept] AS [ExeDept], [Extent1].[ExeDate] AS [ExeDate], [Extent1].[ExeFlag] AS [ExeFlag], [Extent1].[ExeStaffId] AS [ExeStaffId], [Extent1].[MessageFlag] AS [MessageFlag], [Extent1].[FeeFlag] AS [FeeFlag], [Extent1].[FeeDate] AS [FeeDate], [Extent1].[StaffId] AS [StaffId], [Extent1].[MessageDate] AS [MessageDate], [Extent1].[ETOrderXh] AS [ETOrderXh], [Extent1].[OriginFlag] AS [OriginFlag], [Extent1].[DiseaseFlag] AS [DiseaseFlag], [Extent1].[ReturnFlag] AS [ReturnFlag], [Extent1].[ReturnReason] AS [ReturnReason], [Extent1].[Memo] AS [Memo], [Extent1].[RecipeFlag] AS [RecipeFlag], [Extent1].[RecipeSerialNo] AS [RecipeSerialNo], [Extent1].[PrintFlag] AS [PrintFlag], [Extent1].[PrintDate] AS [PrintDate], [Extent1].[FYWinId] AS [FYWinId], [Extent1].[FYWinName] AS [FYWinName], [Extent1].[MedicalGuidance] AS [MedicalGuidance], [Extent1].[TreatmentScopeFlag] AS [TreatmentScopeFlag], [Extent1].[AttorneysName] AS [AttorneysName], [Extent1].[AttorneysPhone] AS [AttorneysPhone], [Extent1].[AttorneySfzh] AS [AttorneySfzh], [Extent1].[RelatedRecipeXh] AS [RelatedRecipeXh], [Extent1].[OperationRequestXh] AS [OperationRequestXh], [Extent1].[GenerationFriedFlag] AS [GenerationFriedFlag], [Extent1].[GenerationFriedNum] AS [GenerationFriedNum], [Extent1].[RecipeNumPerDay] AS [RecipeNumPerDay], [Extent1].[ModifiedDate] AS [ModifiedDate], [Extent1].[UsageId] AS [UsageId], [Extent1].[PrepayFlag] AS [PrepayFlag], [Extent1].[ConfirmFlag] AS [ConfirmFlag], [Extent1].[SourceXh] AS [SourceXh], [Extent1].[SourceKind] AS [SourceKind], [Extent1].[ZQNum] AS [ZQNum], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[ValidUsableFlag] AS [ValidUsableFlag], [Extent1].[SyncSignNo] AS [SyncSignNo], [Extent1].[ReturnStaffId] AS [ReturnStaffId], [Extent1].[ReturnTime] AS [ReturnTime], [Extent1].[DoctorCAFlag] AS [DoctorCAFlag], [Extent1].[AddressXh] AS [AddressXh], [Extent1].[DecoctFlag] AS [DecoctFlag], [Extent1].[FixTemplateName] AS [FixTemplateName] FROM [OP].[Recipe] AS [Extent1] WITH (NOLOCK) INNER JOIN [OP].[IdXhJoin] AS [Extent2] WITH (NOLOCK) ON [Extent2].[JoinXh] = [Extent1].[Xh] WHERE [Extent2].[PId] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:19:37 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustCIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=OPApp;uid=sa;>>1475 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:19:37 Message: SELECT [Extent1].[Xh] AS [Xh], [Extent1].[PatId] AS [PatId], [Extent1].[PatName] AS [PatName], [Extent1].[YBId] AS [YBId], [Extent1].[CredenceXh] AS [CredenceXh], [Extent1].[RegFlag] AS [RegFlag], [Extent1].[DeptId] AS [DeptId], [Extent1].[RegDate] AS [RegDate], [Extent1].[ReturnVisitFlag] AS [ReturnVisitFlag], [Extent1].[PreRegFlag] AS [PreRegFlag], [Extent1].[BookingXh] AS [BookingXh], [Extent1].[RegKindId] AS [RegKindId], [Extent1].[StaffId] AS [StaffId], [Extent1].[CreatedDate] AS [CreatedDate], [Extent1].[FeeFlag] AS [FeeFlag], [Extent1].[RegId] AS [RegId], [Extent1].[RegName] AS [RegName], [Extent1].[RegDoctorId] AS [RegDoctorId], [Extent1].[RegTimeFlag] AS [RegTimeFlag], [Extent1].[VisitFlag] AS [VisitFlag], [Extent1].[DoctorId1] AS [DoctorId1], [Extent1].[DoctorId2] AS [DoctorId2], [Extent1].[CreditLine] AS [CreditLine], [Extent1].[HomeBedXh] AS [HomeBedXh], [Extent1].[HisVisitNo] AS [HisVisitNo], [Extent1].[AnmeldenProvinceId] AS [AnmeldenProvinceId], [Extent1].[AnmeldenStateId] AS [AnmeldenStateId], [Extent1].[AnmeldenCountyId] AS [AnmeldenCountyId], [Extent1].[AnmeldenAddress] AS [AnmeldenAddress], [Extent1].[AnmeldenZip] AS [AnmeldenZip], [Extent1].[WorkingUnit] AS [WorkingUnit], [Extent1].[WorkingZip] AS [WorkingZip], [Extent1].[WorkingPhone] AS [WorkingPhone], [Extent1].[ReturnAuditFlag] AS [ReturnAuditFlag], [Extent1].[IndexNumber] AS [IndexNumber], [Extent1].[CardKindId] AS [CardKindId], [Extent1].[CardNo] AS [CardNo], [Extent1].[DisplayCardNo] AS [DisplayCardNo], [Extent1].[ZoneId] AS [ZoneId], [Extent1].[EmergencyFlag] AS [EmergencyFlag], [Extent1].[SelfRegister] AS [SelfRegister], [Extent1].[DiseaseId] AS [DiseaseId], [Extent1].[PredictVisitTime] AS [PredictVisitTime], [Extent1].[SerialFlag] AS [SerialFlag], [Extent1].[SpaceRegFlag] AS [SpaceRegFlag], [Extent1].[OverFlag] AS [OverFlag], [Extent1].[RescueCarFlag] AS [RescueCarFlag], [Extent1].[DoctorTime1] AS [DoctorTime1], [Extent1].[DoctorTime2] AS [DoctorTime2], [Extent1].[PatLogXh] AS [PatLogXh], [Extent1].[LastSignTime] AS [LastSignTime] FROM [OP].[Register] AS [Extent1] WITH (NOLOCK) INNER JOIN [OP].[IdXhJoin] AS [Extent2] WITH (NOLOCK) ON [Extent2].[JoinXh] = [Extent1].[Xh] WHERE [Extent2].[PId] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:19:37 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=OPApp;uid=sa;>>2831 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:19:37 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[SurName] AS [SurName], [Extent1].[GivenName] AS [GivenName], [Extent1].[Py] AS [Py], [Extent1].[Wb] AS [Wb], [Extent1].[OPBLH] AS [OPBLH], [Extent1].[IPBLH] AS [IPBLH], [Extent1].[SexId] AS [SexId], [Extent1].[Birthday] AS [Birthday], [Extent1].[Weight] AS [Weight], [Extent1].[IdentityKindId] AS [IdentityKindId], [Extent1].[Sfzh] AS [Sfzh], [Extent1].[MaritalStatusId] AS [MaritalStatusId], [Extent1].[CountryId] AS [CountryId], [Extent1].[NationId] AS [NationId], [Extent1].[ProvinceId] AS [ProvinceId], [Extent1].[StateId] AS [StateId], [Extent1].[CountyId] AS [CountyId], [Extent1].[Address] AS [Address], [Extent1].[Phone] AS [Phone], [Extent1].[Mobile] AS [Mobile], [Extent1].[Mail] AS [Mail], [Extent1].[StaffId] AS [StaffId], [Extent1].[ModifiedDate] AS [ModifiedDate], [Extent1].[Memo] AS [Memo], [Extent1].[PatImage] AS [PatImage], [Extent1].[HospitalId] AS [HospitalId], [Extent1].[SysFlag] AS [SysFlag], [Extent1].[HisPatId] AS [HisPatId], [Extent1].[HisVerId] AS [HisVerId], [Extent1].[ProfessionId] AS [ProfessionId], [Extent1].[BirthProvinceId] AS [BirthProvinceId], [Extent1].[BirthStateId] AS [BirthStateId], [Extent1].[BirthCountyId] AS [BirthCountyId], [Extent1].[BirthAddress] AS [BirthAddress], [Extent1].[Zip] AS [Zip], [Extent1].[BirthZip] AS [BirthZip], [Extent1].[Password] AS [Password], [Extent1].[CreditLine] AS [CreditLine], [Extent1].[Enterprise] AS [Enterprise], [Extent1].[ABOBloodTypeId] AS [ABOBloodTypeId], [Extent1].[RHBloodTypeFlag] AS [RHBloodTypeFlag], [Extent1].[ObstetricsNo] AS [ObstetricsNo], [Extent1].[RegionFlag] AS [RegionFlag], [Extent1].[NativePlaceProvinceId] AS [NativePlaceProvinceId], [Extent1].[NativePlaceStateId] AS [NativePlaceStateId], [Extent1].[NativePlaceCountyId] AS [NativePlaceCountyId], [Extent1].[EnterpriseZip] AS [EnterpriseZip], [Extent1].[EnterprisePhone] AS [EnterprisePhone], [Extent1].[Contactman] AS [Contactman], [Extent1].[ContactRelationshipId] AS [ContactRelationshipId], [Extent1].[ContactPhone] AS [ContactPhone], [Extent1].[ContactAdress] AS [ContactAdress], [Extent1].[NativePlace] AS [NativePlace], [Extent1].[AnmeldenProvinceId] AS [AnmeldenProvinceId], [Extent1].[AnmeldenStateId] AS [AnmeldenStateId], [Extent1].[AnmeldenCountyId] AS [AnmeldenCountyId], [Extent1].[AnmeldenAddress] AS [AnmeldenAddress], [Extent1].[AnmeldenZip] AS [AnmeldenZip], [Extent1].[CrippleFlag] AS [CrippleFlag], [Extent1].[CrippleNo] AS [CrippleNo], [Extent1].[Height] AS [Height], [Extent1].[VillageId] AS [VillageId], [Extent1].[BirthVillageId] AS [BirthVillageId], [Extent1].[NativePlaceVillageId] AS [NativePlaceVillageId], [Extent1].[AnmeldenVillageId] AS [AnmeldenVillageId], [Extent1].[NullSfzhReason] AS [NullSfzhReason], [Extent1].[ContactIdentityKindId] AS [ContactIdentityKindId], [Extent1].[ContactIdentityNo] AS [ContactIdentityNo], [Extent1].[Guardianman] AS [Guardianman], [Extent1].[GuardianRelationshipId] AS [GuardianRelationshipId], [Extent1].[GuardianPhone] AS [GuardianPhone], [Extent1].[GuardianAddress] AS [GuardianAddress], [Extent1].[GuardianIdentityNo] AS [GuardianIdentityNo], [Extent1].[EnterpriseAddress] AS [EnterpriseAddress], [Extent1].[OPTotalYBMoney] AS [OPTotalYBMoney], [Extent1].[OPTotalMoney] AS [OPTotalMoney] FROM [Common].[Patient] AS [Extent1] WITH (NOLOCK) INNER JOIN [Common].[IdXhJoin] AS [Extent2] WITH (NOLOCK) ON [Extent2].[JoinXh] = [Extent1].[Id] WHERE [Extent2].[PId] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:19:37 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>10144 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:19:37 Message: SELECT TOP (1) [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Description] AS [Description], [Extent1].[Value] AS [Value], [Extent1].[RefValue] AS [RefValue], [Extent1].[DataType] AS [DataType], [Extent1].[CanSelect] AS [CanSelect], [Extent1].[SelectSource] AS [SelectSource], [Extent1].[GroupId] AS [GroupId], [Extent1].[Editor] AS [Editor], [Extent1].[EditableFlag] AS [EditableFlag], [Extent1].[ModifyStaffId] AS [ModifyStaffId], [Extent1].[ModifyTime] AS [ModifyTime], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[TimeStamp] AS [TimeStamp] FROM [Common].[Setting] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Id] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/7 8:19:37 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>DrugPublicConfig ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:00:58 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[DrugFlag] AS [DrugFlag], [Extent1].[Memo] AS [Memo], [Extent1].[EditorFlag] AS [EditorFlag], [Extent1].[Shortcut] AS [Shortcut], [Extent1].[ReserveFlag] AS [ReserveFlag], [Extent1].[GroupFlag] AS [GroupFlag], [Extent1].[SceneFlag] AS [SceneFlag], [Extent1].[Color] AS [Color], [Extent1].[ImageName] AS [ImageName], [Extent1].[TimeStamp] AS [TimeStamp] FROM [OP].[RecipeKind] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[DrugFlag] IN (cast(1 as smallint)) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:00:58 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[DrugFlag] AS [DrugFlag], [Extent1].[Memo] AS [Memo], [Extent1].[EditorFlag] AS [EditorFlag], [Extent1].[Shortcut] AS [Shortcut], [Extent1].[ReserveFlag] AS [ReserveFlag], [Extent1].[GroupFlag] AS [GroupFlag], [Extent1].[SceneFlag] AS [SceneFlag], [Extent1].[Color] AS [Color], [Extent1].[ImageName] AS [ImageName], [Extent1].[TimeStamp] AS [TimeStamp] FROM [OP].[RecipeKind] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[DrugFlag] IN (cast(0 as smallint)) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:00:58 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[DrugFlag] AS [DrugFlag], [Extent1].[Memo] AS [Memo], [Extent1].[EditorFlag] AS [EditorFlag], [Extent1].[Shortcut] AS [Shortcut], [Extent1].[ReserveFlag] AS [ReserveFlag], [Extent1].[GroupFlag] AS [GroupFlag], [Extent1].[SceneFlag] AS [SceneFlag], [Extent1].[Color] AS [Color], [Extent1].[ImageName] AS [ImageName], [Extent1].[TimeStamp] AS [TimeStamp] FROM [OP].[RecipeKind] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[DrugFlag] IN (cast(1 as smallint)) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:00:58 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[DrugFlag] AS [DrugFlag], [Extent1].[Memo] AS [Memo], [Extent1].[EditorFlag] AS [EditorFlag], [Extent1].[Shortcut] AS [Shortcut], [Extent1].[ReserveFlag] AS [ReserveFlag], [Extent1].[GroupFlag] AS [GroupFlag], [Extent1].[SceneFlag] AS [SceneFlag], [Extent1].[Color] AS [Color], [Extent1].[ImageName] AS [ImageName], [Extent1].[TimeStamp] AS [TimeStamp] FROM [OP].[RecipeKind] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[DrugFlag] IN (cast(0 as smallint)) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:00:58 Message: SELECT TOP (1) [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Py] AS [Py], [Extent1].[Wb] AS [Wb], [Extent1].[Birthday] AS [Birthday], [Extent1].[SexId] AS [SexId], [Extent1].[MaritalStatusId] AS [MaritalStatusId], [Extent1].[Sfzh] AS [Sfzh], [Extent1].[TechTitleId] AS [TechTitleId], [Extent1].[DegreeId] AS [DegreeId], [Extent1].[InnerPhone] AS [InnerPhone], [Extent1].[Mobile] AS [Mobile], [Extent1].[Mail] AS [Mail], [Extent1].[DefaultDeptId] AS [DefaultDeptId], [Extent1].[DefaultWardId] AS [DefaultWardId], [Extent1].[Depts] AS [Depts], [Extent1].[Wards] AS [Wards], [Extent1].[StaffFlag] AS [StaffFlag], [Extent1].[DataMaintainFlag] AS [DataMaintainFlag], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[YBStaffId] AS [YBStaffId], [Extent1].[YBDeptId] AS [YBDeptId], [Extent1].[HRStaffId] AS [HRStaffId], [Extent1].[StaffDesc] AS [StaffDesc], [Extent1].[Memo] AS [Memo], [Extent1].[TimeStamp] AS [TimeStamp], [Extent1].[CAOpenId] AS [CAOpenId], [Extent1].[StdCode] AS [StdCode], [Extent1].[StdName] AS [StdName] FROM [Common].[Staff] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Id] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:00:58 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>zz001 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:00:59 Message: SELECT [Extent1].[Xh] AS [Xh], [Extent1].[RegXh] AS [RegXh], [Extent1].[VisitDate] AS [VisitDate], [Extent1].[PatId] AS [PatId], [Extent1].[YBId] AS [YBId], [Extent1].[CredenceXh] AS [CredenceXh], [Extent1].[RecipeName] AS [RecipeName], [Extent1].[RecipeNum] AS [RecipeNum], [Extent1].[RecipeKindId] AS [RecipeKindId], [Extent1].[DoctorId] AS [DoctorId], [Extent1].[DoctorDatetime] AS [DoctorDatetime], [Extent1].[DoctorRecipeNo] AS [DoctorRecipeNo], [Extent1].[DoctorDept] AS [DoctorDept], [Extent1].[ValidFlag] AS [ValidFlag], [Extent1].[ExeDept] AS [ExeDept], [Extent1].[ExeDate] AS [ExeDate], [Extent1].[ExeFlag] AS [ExeFlag], [Extent1].[ExeStaffId] AS [ExeStaffId], [Extent1].[MessageFlag] AS [MessageFlag], [Extent1].[FeeFlag] AS [FeeFlag], [Extent1].[FeeDate] AS [FeeDate], [Extent1].[StaffId] AS [StaffId], [Extent1].[MessageDate] AS [MessageDate], [Extent1].[ETOrderXh] AS [ETOrderXh], [Extent1].[OriginFlag] AS [OriginFlag], [Extent1].[DiseaseFlag] AS [DiseaseFlag], [Extent1].[ReturnFlag] AS [ReturnFlag], [Extent1].[ReturnReason] AS [ReturnReason], [Extent1].[Memo] AS [Memo], [Extent1].[RecipeFlag] AS [RecipeFlag], [Extent1].[RecipeSerialNo] AS [RecipeSerialNo], [Extent1].[PrintFlag] AS [PrintFlag], [Extent1].[PrintDate] AS [PrintDate], [Extent1].[FYWinId] AS [FYWinId], [Extent1].[FYWinName] AS [FYWinName], [Extent1].[MedicalGuidance] AS [MedicalGuidance], [Extent1].[TreatmentScopeFlag] AS [TreatmentScopeFlag], [Extent1].[AttorneysName] AS [AttorneysName], [Extent1].[AttorneysPhone] AS [AttorneysPhone], [Extent1].[AttorneySfzh] AS [AttorneySfzh], [Extent1].[RelatedRecipeXh] AS [RelatedRecipeXh], [Extent1].[OperationRequestXh] AS [OperationRequestXh], [Extent1].[GenerationFriedFlag] AS [GenerationFriedFlag], [Extent1].[GenerationFriedNum] AS [GenerationFriedNum], [Extent1].[RecipeNumPerDay] AS [RecipeNumPerDay], [Extent1].[ModifiedDate] AS [ModifiedDate], [Extent1].[UsageId] AS [UsageId], [Extent1].[PrepayFlag] AS [PrepayFlag], [Extent1].[ConfirmFlag] AS [ConfirmFlag], [Extent1].[SourceXh] AS [SourceXh], [Extent1].[SourceKind] AS [SourceKind], [Extent1].[ZQNum] AS [ZQNum], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[ValidUsableFlag] AS [ValidUsableFlag], [Extent1].[SyncSignNo] AS [SyncSignNo], [Extent1].[ReturnStaffId] AS [ReturnStaffId], [Extent1].[ReturnTime] AS [ReturnTime], [Extent1].[DoctorCAFlag] AS [DoctorCAFlag], [Extent1].[AddressXh] AS [AddressXh], [Extent1].[DecoctFlag] AS [DecoctFlag], [Extent1].[FixTemplateName] AS [FixTemplateName] FROM [OP].[Recipe] AS [Extent1] WITH (NOLOCK) INNER JOIN [OP].[IdXhJoin] AS [Extent2] WITH (NOLOCK) ON [Extent2].[JoinXh] = [Extent1].[Xh] WHERE [Extent2].[PId] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:00:59 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustCIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=OPApp;uid=sa;>>105 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:00 Message: SELECT [Extent1].[Xh] AS [Xh], [Extent1].[PatId] AS [PatId], [Extent1].[PatName] AS [PatName], [Extent1].[YBId] AS [YBId], [Extent1].[CredenceXh] AS [CredenceXh], [Extent1].[RegFlag] AS [RegFlag], [Extent1].[DeptId] AS [DeptId], [Extent1].[RegDate] AS [RegDate], [Extent1].[ReturnVisitFlag] AS [ReturnVisitFlag], [Extent1].[PreRegFlag] AS [PreRegFlag], [Extent1].[BookingXh] AS [BookingXh], [Extent1].[RegKindId] AS [RegKindId], [Extent1].[StaffId] AS [StaffId], [Extent1].[CreatedDate] AS [CreatedDate], [Extent1].[FeeFlag] AS [FeeFlag], [Extent1].[RegId] AS [RegId], [Extent1].[RegName] AS [RegName], [Extent1].[RegDoctorId] AS [RegDoctorId], [Extent1].[RegTimeFlag] AS [RegTimeFlag], [Extent1].[VisitFlag] AS [VisitFlag], [Extent1].[DoctorId1] AS [DoctorId1], [Extent1].[DoctorId2] AS [DoctorId2], [Extent1].[CreditLine] AS [CreditLine], [Extent1].[HomeBedXh] AS [HomeBedXh], [Extent1].[HisVisitNo] AS [HisVisitNo], [Extent1].[AnmeldenProvinceId] AS [AnmeldenProvinceId], [Extent1].[AnmeldenStateId] AS [AnmeldenStateId], [Extent1].[AnmeldenCountyId] AS [AnmeldenCountyId], [Extent1].[AnmeldenAddress] AS [AnmeldenAddress], [Extent1].[AnmeldenZip] AS [AnmeldenZip], [Extent1].[WorkingUnit] AS [WorkingUnit], [Extent1].[WorkingZip] AS [WorkingZip], [Extent1].[WorkingPhone] AS [WorkingPhone], [Extent1].[ReturnAuditFlag] AS [ReturnAuditFlag], [Extent1].[IndexNumber] AS [IndexNumber], [Extent1].[CardKindId] AS [CardKindId], [Extent1].[CardNo] AS [CardNo], [Extent1].[DisplayCardNo] AS [DisplayCardNo], [Extent1].[ZoneId] AS [ZoneId], [Extent1].[EmergencyFlag] AS [EmergencyFlag], [Extent1].[SelfRegister] AS [SelfRegister], [Extent1].[DiseaseId] AS [DiseaseId], [Extent1].[PredictVisitTime] AS [PredictVisitTime], [Extent1].[SerialFlag] AS [SerialFlag], [Extent1].[SpaceRegFlag] AS [SpaceRegFlag], [Extent1].[OverFlag] AS [OverFlag], [Extent1].[RescueCarFlag] AS [RescueCarFlag], [Extent1].[DoctorTime1] AS [DoctorTime1], [Extent1].[DoctorTime2] AS [DoctorTime2], [Extent1].[PatLogXh] AS [PatLogXh], [Extent1].[LastSignTime] AS [LastSignTime] FROM [OP].[Register] AS [Extent1] WITH (NOLOCK) INNER JOIN [OP].[IdXhJoin] AS [Extent2] WITH (NOLOCK) ON [Extent2].[JoinXh] = [Extent1].[Xh] WHERE [Extent2].[PId] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:00 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=OPApp;uid=sa;>>2913 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:00 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[SurName] AS [SurName], [Extent1].[GivenName] AS [GivenName], [Extent1].[Py] AS [Py], [Extent1].[Wb] AS [Wb], [Extent1].[OPBLH] AS [OPBLH], [Extent1].[IPBLH] AS [IPBLH], [Extent1].[SexId] AS [SexId], [Extent1].[Birthday] AS [Birthday], [Extent1].[Weight] AS [Weight], [Extent1].[IdentityKindId] AS [IdentityKindId], [Extent1].[Sfzh] AS [Sfzh], [Extent1].[MaritalStatusId] AS [MaritalStatusId], [Extent1].[CountryId] AS [CountryId], [Extent1].[NationId] AS [NationId], [Extent1].[ProvinceId] AS [ProvinceId], [Extent1].[StateId] AS [StateId], [Extent1].[CountyId] AS [CountyId], [Extent1].[Address] AS [Address], [Extent1].[Phone] AS [Phone], [Extent1].[Mobile] AS [Mobile], [Extent1].[Mail] AS [Mail], [Extent1].[StaffId] AS [StaffId], [Extent1].[ModifiedDate] AS [ModifiedDate], [Extent1].[Memo] AS [Memo], [Extent1].[PatImage] AS [PatImage], [Extent1].[HospitalId] AS [HospitalId], [Extent1].[SysFlag] AS [SysFlag], [Extent1].[HisPatId] AS [HisPatId], [Extent1].[HisVerId] AS [HisVerId], [Extent1].[ProfessionId] AS [ProfessionId], [Extent1].[BirthProvinceId] AS [BirthProvinceId], [Extent1].[BirthStateId] AS [BirthStateId], [Extent1].[BirthCountyId] AS [BirthCountyId], [Extent1].[BirthAddress] AS [BirthAddress], [Extent1].[Zip] AS [Zip], [Extent1].[BirthZip] AS [BirthZip], [Extent1].[Password] AS [Password], [Extent1].[CreditLine] AS [CreditLine], [Extent1].[Enterprise] AS [Enterprise], [Extent1].[ABOBloodTypeId] AS [ABOBloodTypeId], [Extent1].[RHBloodTypeFlag] AS [RHBloodTypeFlag], [Extent1].[ObstetricsNo] AS [ObstetricsNo], [Extent1].[RegionFlag] AS [RegionFlag], [Extent1].[NativePlaceProvinceId] AS [NativePlaceProvinceId], [Extent1].[NativePlaceStateId] AS [NativePlaceStateId], [Extent1].[NativePlaceCountyId] AS [NativePlaceCountyId], [Extent1].[EnterpriseZip] AS [EnterpriseZip], [Extent1].[EnterprisePhone] AS [EnterprisePhone], [Extent1].[Contactman] AS [Contactman], [Extent1].[ContactRelationshipId] AS [ContactRelationshipId], [Extent1].[ContactPhone] AS [ContactPhone], [Extent1].[ContactAdress] AS [ContactAdress], [Extent1].[NativePlace] AS [NativePlace], [Extent1].[AnmeldenProvinceId] AS [AnmeldenProvinceId], [Extent1].[AnmeldenStateId] AS [AnmeldenStateId], [Extent1].[AnmeldenCountyId] AS [AnmeldenCountyId], [Extent1].[AnmeldenAddress] AS [AnmeldenAddress], [Extent1].[AnmeldenZip] AS [AnmeldenZip], [Extent1].[CrippleFlag] AS [CrippleFlag], [Extent1].[CrippleNo] AS [CrippleNo], [Extent1].[Height] AS [Height], [Extent1].[VillageId] AS [VillageId], [Extent1].[BirthVillageId] AS [BirthVillageId], [Extent1].[NativePlaceVillageId] AS [NativePlaceVillageId], [Extent1].[AnmeldenVillageId] AS [AnmeldenVillageId], [Extent1].[NullSfzhReason] AS [NullSfzhReason], [Extent1].[ContactIdentityKindId] AS [ContactIdentityKindId], [Extent1].[ContactIdentityNo] AS [ContactIdentityNo], [Extent1].[Guardianman] AS [Guardianman], [Extent1].[GuardianRelationshipId] AS [GuardianRelationshipId], [Extent1].[GuardianPhone] AS [GuardianPhone], [Extent1].[GuardianAddress] AS [GuardianAddress], [Extent1].[GuardianIdentityNo] AS [GuardianIdentityNo], [Extent1].[EnterpriseAddress] AS [EnterpriseAddress], [Extent1].[OPTotalYBMoney] AS [OPTotalYBMoney], [Extent1].[OPTotalMoney] AS [OPTotalMoney] FROM [Common].[Patient] AS [Extent1] WITH (NOLOCK) INNER JOIN [Common].[IdXhJoin] AS [Extent2] WITH (NOLOCK) ON [Extent2].[JoinXh] = [Extent1].[Id] WHERE [Extent2].[PId] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:00 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>10837 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:00 Message: SELECT TOP (1) [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Description] AS [Description], [Extent1].[Value] AS [Value], [Extent1].[RefValue] AS [RefValue], [Extent1].[DataType] AS [DataType], [Extent1].[CanSelect] AS [CanSelect], [Extent1].[SelectSource] AS [SelectSource], [Extent1].[GroupId] AS [GroupId], [Extent1].[Editor] AS [Editor], [Extent1].[EditableFlag] AS [EditableFlag], [Extent1].[ModifyStaffId] AS [ModifyStaffId], [Extent1].[ModifyTime] AS [ModifyTime], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[TimeStamp] AS [TimeStamp] FROM [Common].[Setting] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Id] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:00 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>DrugPublicConfig ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:00 Message: SELECT TOP (1) [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Description] AS [Description], [Extent1].[Value] AS [Value], [Extent1].[RefValue] AS [RefValue], [Extent1].[DataType] AS [DataType], [Extent1].[CanSelect] AS [CanSelect], [Extent1].[SelectSource] AS [SelectSource], [Extent1].[GroupId] AS [GroupId], [Extent1].[Editor] AS [Editor], [Extent1].[EditableFlag] AS [EditableFlag], [Extent1].[ModifyStaffId] AS [ModifyStaffId], [Extent1].[ModifyTime] AS [ModifyTime], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[TimeStamp] AS [TimeStamp] FROM [Common].[Setting] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Id] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:00 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>HospitalDefaultValueSetting ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:01 Message: SELECT [Extent1].[Idm] AS [Idm], [Extent1].[DrugId] AS [DrugId], [Extent1].[DrugBasicName] AS [DrugBasicName], [Extent1].[Name] AS [Name], [Extent1].[Py] AS [Py], [Extent1].[Wb] AS [Wb], [Extent1].[RegisterNo] AS [RegisterNo], [Extent1].[Spec] AS [Spec], [Extent1].[DrugKindId] AS [DrugKindId], [Extent1].[DrugFormId] AS [DrugFormId], [Extent1].[ManuId] AS [ManuId], [Extent1].[ManuName] AS [ManuName], [Extent1].[ValidMonth] AS [ValidMonth], [Extent1].[PriceLS] AS [PriceLS], [Extent1].[PricePF] AS [PricePF], [Extent1].[PriceJJ] AS [PriceJJ], [Extent1].[UpperPrice] AS [UpperPrice], [Extent1].[MinUnit] AS [MinUnit], [Extent1].[YKUnit] AS [YKUnit], [Extent1].[YKRatio] AS [YKRatio], [Extent1].[JHUnit] AS [JHUnit], [Extent1].[JHRatio] AS [JHRatio], [Extent1].[ControlFlag] AS [ControlFlag], [Extent1].[LimitFlag] AS [LimitFlag], [Extent1].[GZFlag] AS [GZFlag], [Extent1].[KLRatio] AS [KLRatio], [Extent1].[SJZJFlag] AS [SJZJFlag], [Extent1].[DrugImage] AS [DrugImage], [Extent1].[ZMLBId] AS [ZMLBId], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[LJLYFlag] AS [LJLYFlag], [Extent1].[AccId] AS [AccId], [Extent1].[PackageFlag] AS [PackageFlag], [Extent1].[OPUnit] AS [OPUnit], [Extent1].[OPRatio] AS [OPRatio], [Extent1].[IPUnit] AS [IPUnit], [Extent1].[IPRatio] AS [IPRatio], [Extent1].[SkinTestFlag] AS [SkinTestFlag], [Extent1].[PrintId] AS [PrintId], [Extent1].[SkinSendFlag] AS [SkinSendFlag], CAST( [Extent1].[SpecialFlag] AS smallint) AS [C1], [Extent1].[ManuFromFlag] AS [ManuFromFlag], [Extent1].[DDDId] AS [DDDId], [Extent1].[DDDDoseRatio] AS [DDDDoseRatio], [Extent1].[SkinTestValidDay] AS [SkinTestValidDay], [Extent1].[SysBitFlag] AS [SysBitFlag], [Extent1].[OPPartialSelfFlag] AS [OPPartialSelfFlag], [Extent1].[IPPartialSelfFlag] AS [IPPartialSelfFlag], [Extent1].[DistributorXh] AS [DistributorXh], [Extent1].[DistributorName] AS [DistributorName], [Extent1].[YBControlFlag] AS [YBControlFlag], [Extent1].[SubAccItemId] AS [SubAccItemId], [Extent1].[LossRatio] AS [LossRatio], [Extent1].[DoseUnit] AS [DoseUnit], [Extent1].[DrugCode] AS [DrugCode], [Extent1].[CategoryFlag] AS [CategoryFlag], [Extent1].[SpecialNote] AS [SpecialNote], [Extent1].[DoseRatio] AS [DoseRatio], [Extent1].[AMSIdm] AS [AMSIdm], [Extent1].[MinBitFlag] AS [MinBitFlag], [Extent1].[OriginalSpec] AS [OriginalSpec], [Extent1].[CustomKind] AS [CustomKind], [Extent1].[RefId] AS [RefId], [Extent1].[EKUnit] AS [EKUnit], [Extent1].[EKRatio] AS [EKRatio], [Extent1].[BidFlag] AS [BidFlag], [Extent1].[BidNo] AS [BidNo], [Extent1].[BidUnit] AS [BidUnit], [Extent1].[RegisterNoSource] AS [RegisterNoSource], [Extent1].[StoreDescription] AS [StoreDescription], [Extent1].[DrugCode1] AS [DrugCode1], [Extent1].[DrugCode2] AS [DrugCode2], [Extent1].[RegisterNoValidDate] AS [RegisterNoValidDate], [Extent1].[CommonDrugFlag] AS [CommonDrugFlag], [Extent1].[ProductName] AS [ProductName], [Extent1].[PriceLSOriginal] AS [PriceLSOriginal], [Extent1].[FullPronunciation] AS [FullPronunciation], [Extent1].[FullPronunciation1] AS [FullPronunciation1], [Extent1].[DrugVarietiesFlag] AS [DrugVarietiesFlag], [Extent1].[RecipePrintingFlag] AS [RecipePrintingFlag], [Extent1].[ZYLJLYFlag] AS [ZYLJLYFlag], [Extent1].[UnPackageFlagForIP] AS [UnPackageFlagForIP], [Extent1].[ValidMonthLowLimit] AS [ValidMonthLowLimit], [Extent1].[OutHospitalFlag] AS [OutHospitalFlag], [Extent1].[StdCode] AS [StdCode], [Extent1].[StdName] AS [StdName], [Extent1].[TempProcFlag] AS [TempProcFlag], [Extent1].[RowStamp] AS [RowStamp] FROM [Common].[Drug] AS [Extent1] WITH (NOLOCK) INNER JOIN [Common].[IdXhJoin] AS [Extent2] WITH (NOLOCK) ON [Extent1].[Idm] = [Extent2].[JoinXh] WHERE ([Extent2].[PId] = @p__linq__0) AND (1 = [Extent1].[SkinTestFlag]) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:01 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>10839 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:01 Message: SELECT [Extent1].[Xh] AS [Xh], [Extent1].[YBId] AS [YBId], [Extent3].[Id] AS [Id], [Extent3].[Name] AS [Name], [Extent3].[ValidMonth] AS [ValidMonth], [Extent3].[CredenceRegFlag] AS [CredenceRegFlag], [Extent3].[CredenceExTemplate] AS [CredenceExTemplate], [Extent3].[Memo] AS [Memo], [Extent3].[CredenceLenSet] AS [CredenceLenSet], [Extent2].[Id] AS [Id1], [Extent2].[YBPolicyId] AS [YBPolicyId], [Extent2].[Name] AS [Name1], [Extent2].[Py] AS [Py], [Extent2].[Wb] AS [Wb], [Extent2].[CredenceKindId] AS [CredenceKindId], [Extent2].[SysFlag] AS [SysFlag], [Extent2].[CalcFlag] AS [CalcFlag], [Extent2].[OPSelfRatio] AS [OPSelfRatio], [Extent2].[IPSelfRatio] AS [IPSelfRatio], [Extent2].[PriceRatio] AS [PriceRatio], [Extent2].[YBPayLine] AS [YBPayLine], [Extent2].[DepositLowerLine] AS [DepositLowerLine], [Extent2].[PatScopeFlag] AS [PatScopeFlag], [Extent2].[DisableFlag] AS [DisableFlag], [Extent2].[Memo] AS [Memo1], [Extent2].[CreditLine] AS [CreditLine], [Extent2].[YBPayUpperLine] AS [YBPayUpperLine], [Extent2].[IsOPDisease] AS [IsOPDisease], [Extent2].[YBCode1] AS [YBCode1], [Extent2].[YBCode2] AS [YBCode2], [Extent2].[IsCombined] AS [IsCombined], [Extent2].[YBPayLineKind] AS [YBPayLineKind], [Extent2].[YBPayLineCalcKind] AS [YBPayLineCalcKind], [Extent2].[YBPayLineStartDate] AS [YBPayLineStartDate], [Extent2].[RefYBId] AS [RefYBId], [Extent2].[NonAuditYBId] AS [NonAuditYBId], [Extent2].[YBSummaryKind] AS [YBSummaryKind], [Extent2].[BIReportFlag] AS [BIReportFlag], [Extent2].[CalcCombineItem] AS [CalcCombineItem], [Extent2].[PostPaid] AS [PostPaid], [Extent2].[LastPostPaidConstraint] AS [LastPostPaidConstraint], [Extent2].[CredenceLenSet] AS [CredenceLenSet1], [Extent2].[CantUseIfBlock] AS [CantUseIfBlock], [Extent2].[BindUnitAccount] AS [BindUnitAccount], [Extent2].[MRYBId] AS [MRYBId], [Extent2].[SimCalcFlag] AS [SimCalcFlag], [Extent2].[InvoiceDisableFlag] AS [InvoiceDisableFlag], [Extent2].[YBPatKind] AS [YBPatKind], [Extent1].[CredenceNo] AS [CredenceNo], [Extent1].[CredenceKindId] AS [CredenceKindId1], [Extent1].[CreditLine] AS [CreditLine1], [Extent1].[DiagId] AS [DiagId], [Extent1].[DisableFlag] AS [DisableFlag1], [Extent1].[ModifiedDate] AS [ModifiedDate], [Extent1].[PatId] AS [PatId], [Extent1].[PayingEntXh] AS [PayingEntXh], [Extent1].[StaffId] AS [StaffId], [Extent1].[SysFlag] AS [SysFlag1], [Extent1].[ValidFrom] AS [ValidFrom], [Extent1].[ValidTo] AS [ValidTo], [Extent1].[YBCountyId] AS [YBCountyId], [Extent1].[YBCredenceEx] AS [YBCredenceEx], [Extent1].[YBDiseaseId] AS [YBDiseaseId], [Extent1].[AccountId] AS [AccountId], [Extent1].[AccountAmount] AS [AccountAmount], [Extent1].[AccountFlag] AS [AccountFlag], [Extent1].[AccountKind] AS [AccountKind], [Extent1].[AssistanceFlag] AS [AssistanceFlag], [Extent1].[InsureNo] AS [InsureNo], [Extent1].[CardNo] AS [CardNo], [Extent1].[CardKindId] AS [CardKindId], [Extent1].[YBUnitId] AS [YBUnitId], [Extent1].[YBUnitName] AS [YBUnitName], [Extent1].[YBPatAddress] AS [YBPatAddress], [Extent1].[CredenceToken] AS [CredenceToken], [Extent1].[EcToken] AS [EcToken], [Extent1].[EcTokenDate] AS [EcTokenDate] FROM [Common].[PatYBCredence] AS [Extent1] WITH (NOLOCK) INNER JOIN [Common].[YBCode] AS [Extent2] WITH (NOLOCK) ON [Extent1].[YBId] = [Extent2].[Id] INNER JOIN [Common].[YBCredenceKind] AS [Extent3] WITH (NOLOCK) ON [Extent1].[CredenceKindId] = [Extent3].[Id] WHERE ([Extent1].[PatId] = @p__linq__0) AND ([Extent1].[ValidFrom] <= @p__linq__1) AND ([Extent1].[ValidTo] >= @p__linq__2) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:01 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>16392 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:01 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Py] AS [Py], [Extent1].[Wb] AS [Wb], [Extent1].[Memo] AS [Memo] FROM [Common].[YBDisease] AS [Extent1] WITH (NOLOCK) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:01 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[YBPolicyId] AS [YBPolicyId], [Extent1].[Name] AS [Name], [Extent1].[Py] AS [Py], [Extent1].[Wb] AS [Wb], [Extent1].[CredenceKindId] AS [CredenceKindId], [Extent1].[SysFlag] AS [SysFlag], [Extent1].[CalcFlag] AS [CalcFlag], [Extent1].[OPSelfRatio] AS [OPSelfRatio], [Extent1].[IPSelfRatio] AS [IPSelfRatio], [Extent1].[PriceRatio] AS [PriceRatio], [Extent1].[YBPayLine] AS [YBPayLine], [Extent1].[DepositLowerLine] AS [DepositLowerLine], [Extent1].[PatScopeFlag] AS [PatScopeFlag], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[Memo] AS [Memo], [Extent1].[CreditLine] AS [CreditLine], [Extent1].[YBPayUpperLine] AS [YBPayUpperLine], [Extent1].[IsOPDisease] AS [IsOPDisease], [Extent1].[YBCode1] AS [YBCode1], [Extent1].[YBCode2] AS [YBCode2], [Extent1].[IsCombined] AS [IsCombined], [Extent1].[YBPayLineKind] AS [YBPayLineKind], [Extent1].[YBPayLineCalcKind] AS [YBPayLineCalcKind], [Extent1].[YBPayLineStartDate] AS [YBPayLineStartDate], [Extent1].[RefYBId] AS [RefYBId], [Extent1].[NonAuditYBId] AS [NonAuditYBId], [Extent1].[YBSummaryKind] AS [YBSummaryKind], [Extent1].[BIReportFlag] AS [BIReportFlag], [Extent1].[CalcCombineItem] AS [CalcCombineItem], [Extent1].[PostPaid] AS [PostPaid], [Extent1].[LastPostPaidConstraint] AS [LastPostPaidConstraint], [Extent1].[CredenceLenSet] AS [CredenceLenSet], [Extent1].[CantUseIfBlock] AS [CantUseIfBlock], [Extent1].[BindUnitAccount] AS [BindUnitAccount], [Extent1].[MRYBId] AS [MRYBId], [Extent1].[SimCalcFlag] AS [SimCalcFlag], [Extent1].[InvoiceDisableFlag] AS [InvoiceDisableFlag], [Extent1].[YBPatKind] AS [YBPatKind] FROM [Common].[YBCode] AS [Extent1] WITH (NOLOCK) WHERE 0 = [Extent1].[DisableFlag] ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:01 Message: SELECT TOP (1) [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Description] AS [Description], [Extent1].[Value] AS [Value], [Extent1].[RefValue] AS [RefValue], [Extent1].[DataType] AS [DataType], [Extent1].[CanSelect] AS [CanSelect], [Extent1].[SelectSource] AS [SelectSource], [Extent1].[GroupId] AS [GroupId], [Extent1].[Editor] AS [Editor], [Extent1].[EditableFlag] AS [EditableFlag], [Extent1].[ModifyStaffId] AS [ModifyStaffId], [Extent1].[ModifyTime] AS [ModifyTime], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[TimeStamp] AS [TimeStamp] FROM [Common].[Setting] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Id] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:01 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>OPDepositConfig ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:01 Message: SELECT TOP (1) [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Description] AS [Description], [Extent1].[Value] AS [Value], [Extent1].[RefValue] AS [RefValue], [Extent1].[DataType] AS [DataType], [Extent1].[CanSelect] AS [CanSelect], [Extent1].[SelectSource] AS [SelectSource], [Extent1].[GroupId] AS [GroupId], [Extent1].[Editor] AS [Editor], [Extent1].[EditableFlag] AS [EditableFlag], [Extent1].[ModifyStaffId] AS [ModifyStaffId], [Extent1].[ModifyTime] AS [ModifyTime], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[TimeStamp] AS [TimeStamp] FROM [Common].[Setting] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Id] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:01 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>CommonPublicConfig ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:01 Message: SELECT [Extent1].[Idm] AS [Idm], [Extent1].[DrugId] AS [DrugId], [Extent1].[DrugBasicName] AS [DrugBasicName], [Extent1].[Name] AS [Name], [Extent1].[Py] AS [Py], [Extent1].[Wb] AS [Wb], [Extent1].[RegisterNo] AS [RegisterNo], [Extent1].[Spec] AS [Spec], [Extent1].[DrugKindId] AS [DrugKindId], [Extent1].[DrugFormId] AS [DrugFormId], [Extent1].[ManuId] AS [ManuId], [Extent1].[ManuName] AS [ManuName], [Extent1].[ValidMonth] AS [ValidMonth], [Extent1].[PriceLS] AS [PriceLS], [Extent1].[PricePF] AS [PricePF], [Extent1].[PriceJJ] AS [PriceJJ], [Extent1].[UpperPrice] AS [UpperPrice], [Extent1].[MinUnit] AS [MinUnit], [Extent1].[YKUnit] AS [YKUnit], [Extent1].[YKRatio] AS [YKRatio], [Extent1].[JHUnit] AS [JHUnit], [Extent1].[JHRatio] AS [JHRatio], [Extent1].[ControlFlag] AS [ControlFlag], [Extent1].[LimitFlag] AS [LimitFlag], [Extent1].[GZFlag] AS [GZFlag], [Extent1].[KLRatio] AS [KLRatio], [Extent1].[SJZJFlag] AS [SJZJFlag], [Extent1].[DrugImage] AS [DrugImage], [Extent1].[ZMLBId] AS [ZMLBId], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[LJLYFlag] AS [LJLYFlag], [Extent1].[AccId] AS [AccId], [Extent1].[PackageFlag] AS [PackageFlag], [Extent1].[OPUnit] AS [OPUnit], [Extent1].[OPRatio] AS [OPRatio], [Extent1].[IPUnit] AS [IPUnit], [Extent1].[IPRatio] AS [IPRatio], [Extent1].[SkinTestFlag] AS [SkinTestFlag], [Extent1].[PrintId] AS [PrintId], [Extent1].[SkinSendFlag] AS [SkinSendFlag], CAST( [Extent1].[SpecialFlag] AS smallint) AS [C1], [Extent1].[ManuFromFlag] AS [ManuFromFlag], [Extent1].[DDDId] AS [DDDId], [Extent1].[DDDDoseRatio] AS [DDDDoseRatio], [Extent1].[SkinTestValidDay] AS [SkinTestValidDay], [Extent1].[SysBitFlag] AS [SysBitFlag], [Extent1].[OPPartialSelfFlag] AS [OPPartialSelfFlag], [Extent1].[IPPartialSelfFlag] AS [IPPartialSelfFlag], [Extent1].[DistributorXh] AS [DistributorXh], [Extent1].[DistributorName] AS [DistributorName], [Extent1].[YBControlFlag] AS [YBControlFlag], [Extent1].[SubAccItemId] AS [SubAccItemId], [Extent1].[LossRatio] AS [LossRatio], [Extent1].[DoseUnit] AS [DoseUnit], [Extent1].[DrugCode] AS [DrugCode], [Extent1].[CategoryFlag] AS [CategoryFlag], [Extent1].[SpecialNote] AS [SpecialNote], [Extent1].[DoseRatio] AS [DoseRatio], [Extent1].[AMSIdm] AS [AMSIdm], [Extent1].[MinBitFlag] AS [MinBitFlag], [Extent1].[OriginalSpec] AS [OriginalSpec], [Extent1].[CustomKind] AS [CustomKind], [Extent1].[RefId] AS [RefId], [Extent1].[EKUnit] AS [EKUnit], [Extent1].[EKRatio] AS [EKRatio], [Extent1].[BidFlag] AS [BidFlag], [Extent1].[BidNo] AS [BidNo], [Extent1].[BidUnit] AS [BidUnit], [Extent1].[RegisterNoSource] AS [RegisterNoSource], [Extent1].[StoreDescription] AS [StoreDescription], [Extent1].[DrugCode1] AS [DrugCode1], [Extent1].[DrugCode2] AS [DrugCode2], [Extent1].[RegisterNoValidDate] AS [RegisterNoValidDate], [Extent1].[CommonDrugFlag] AS [CommonDrugFlag], [Extent1].[ProductName] AS [ProductName], [Extent1].[PriceLSOriginal] AS [PriceLSOriginal], [Extent1].[FullPronunciation] AS [FullPronunciation], [Extent1].[FullPronunciation1] AS [FullPronunciation1], [Extent1].[DrugVarietiesFlag] AS [DrugVarietiesFlag], [Extent1].[RecipePrintingFlag] AS [RecipePrintingFlag], [Extent1].[ZYLJLYFlag] AS [ZYLJLYFlag], [Extent1].[UnPackageFlagForIP] AS [UnPackageFlagForIP], [Extent1].[ValidMonthLowLimit] AS [ValidMonthLowLimit], [Extent1].[OutHospitalFlag] AS [OutHospitalFlag], [Extent1].[StdCode] AS [StdCode], [Extent1].[StdName] AS [StdName], [Extent1].[TempProcFlag] AS [TempProcFlag], [Extent1].[RowStamp] AS [RowStamp] FROM [Common].[Drug] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Idm] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:01 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>3 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:01 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Py] AS [Py], [Extent1].[Wb] AS [Wb], [Extent1].[OpInvoiceAccItemId] AS [OpInvoiceAccItemId], [Extent1].[IPInvoiceAccItemId] AS [IPInvoiceAccItemId], [Extent1].[OPYBAccItem] AS [OPYBAccItem], [Extent1].[IPYBAccItem] AS [IPYBAccItem], [Extent1].[OPAccItem] AS [OPAccItem], [Extent1].[IPAccItem] AS [IPAccItem], [Extent1].[EMRAccItem] AS [EMRAccItem], [Extent1].[Memo] AS [Memo], [Extent1].[TimeStamp] AS [TimeStamp] FROM [Common].[AccountItem] AS [Extent1] WITH (NOLOCK) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:01 Message: SELECT TOP (1) [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Description] AS [Description], [Extent1].[Value] AS [Value], [Extent1].[RefValue] AS [RefValue], [Extent1].[DataType] AS [DataType], [Extent1].[CanSelect] AS [CanSelect], [Extent1].[SelectSource] AS [SelectSource], [Extent1].[GroupId] AS [GroupId], [Extent1].[Editor] AS [Editor], [Extent1].[EditableFlag] AS [EditableFlag], [Extent1].[ModifyStaffId] AS [ModifyStaffId], [Extent1].[ModifyTime] AS [ModifyTime], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[TimeStamp] AS [TimeStamp] FROM [Common].[Setting] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Id] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:01 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>OPSettlementConfig ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:01 Message: SELECT TOP (1) [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Description] AS [Description], [Extent1].[Value] AS [Value], [Extent1].[RefValue] AS [RefValue], [Extent1].[DataType] AS [DataType], [Extent1].[CanSelect] AS [CanSelect], [Extent1].[SelectSource] AS [SelectSource], [Extent1].[GroupId] AS [GroupId], [Extent1].[Editor] AS [Editor], [Extent1].[EditableFlag] AS [EditableFlag], [Extent1].[ModifyStaffId] AS [ModifyStaffId], [Extent1].[ModifyTime] AS [ModifyTime], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[TimeStamp] AS [TimeStamp] FROM [Common].[Setting] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Id] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:01 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>ETOCommonConfig ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:01 Message: SELECT TOP (1) [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Description] AS [Description], [Extent1].[Value] AS [Value], [Extent1].[RefValue] AS [RefValue], [Extent1].[DataType] AS [DataType], [Extent1].[CanSelect] AS [CanSelect], [Extent1].[SelectSource] AS [SelectSource], [Extent1].[GroupId] AS [GroupId], [Extent1].[Editor] AS [Editor], [Extent1].[EditableFlag] AS [EditableFlag], [Extent1].[ModifyStaffId] AS [ModifyStaffId], [Extent1].[ModifyTime] AS [ModifyTime], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[TimeStamp] AS [TimeStamp] FROM [Common].[Setting] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Id] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:01 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>ETOCommonConfig ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: SELECT [Extent1].[Xh] AS [Xh], [Extent1].[OrderXh] AS [OrderXh], [Extent1].[PatId] AS [PatId], [Extent1].[VisitXh] AS [VisitXh], [Extent1].[SysFlag] AS [SysFlag], [Extent1].[DoctorId] AS [DoctorId], [Extent1].[RequestDeptId] AS [RequestDeptId], [Extent1].[SheetId] AS [SheetId], [Extent1].[DeviceId] AS [DeviceId], [Extent1].[SampleId] AS [SampleId], [Extent1].[TemplateId] AS [TemplateId], [Extent1].[MainComplaint] AS [MainComplaint], [Extent1].[OrderDescript] AS [OrderDescript], [Extent1].[EmergentFlag] AS [EmergentFlag], [Extent1].[OutSourceFlag] AS [OutSourceFlag], [Extent1].[HospitalId] AS [HospitalId], [Extent1].[ExeDepts] AS [ExeDepts], [Extent1].[Status] AS [Status], [Extent1].[BookFlag] AS [BookFlag], [Extent1].[BookedFlag] AS [BookedFlag], [Extent1].[BookDate] AS [BookDate], [Extent1].[BookTimeSlotId] AS [BookTimeSlotId], [Extent1].[BookStaffId] AS [BookStaffId], [Extent1].[BookStaffName] AS [BookStaffName], [Extent1].[BookCreatedDate] AS [BookCreatedDate], [Extent1].[ExeFlag] AS [ExeFlag], [Extent1].[ExeDeptId] AS [ExeDeptId], [Extent1].[ExeDate] AS [ExeDate], [Extent1].[ExeStaffId] AS [ExeStaffId], [Extent1].[ExeStaffName] AS [ExeStaffName], [Extent1].[PublishFlag] AS [PublishFlag], [Extent1].[PublishDate] AS [PublishDate], [Extent1].[PublishStaffId] AS [PublishStaffId], [Extent1].[PublishStaffName] AS [PublishStaffName], [Extent1].[MessageFlag] AS [MessageFlag], [Extent1].[MessageDate] AS [MessageDate], [Extent1].[Attention] AS [Attention], [Extent1].[OrderKind] AS [OrderKind], [Extent1].[SampleDate] AS [SampleDate], [Extent1].[SampleFlag] AS [SampleFlag], [Extent1].[SerialNo] AS [SerialNo], [Extent1].[TemplateName] AS [TemplateName], [Extent1].[CreateTime] AS [CreateTime], [Extent1].[BedSideFlag] AS [BedSideFlag], [Extent1].[GetMediaFlag] AS [GetMediaFlag], [Extent1].[ExamTarget] AS [ExamTarget], [Extent1].[BookingNo] AS [BookingNo], [Extent1].[BookingDept] AS [BookingDept], [Extent1].[BookingDiscardedStaffId] AS [BookingDiscardedStaffId], [Extent1].[BookingDiscardedDate] AS [BookingDiscardedDate], [Extent1].[BookPrintFlag] AS [BookPrintFlag], [Extent1].[LockFlag] AS [LockFlag], [Extent1].[SourceFlag] AS [SourceFlag], [Extent1].[RefId] AS [RefId], [Extent1].[Memo] AS [Memo], [Extent1].[SynchFlag] AS [SynchFlag], [Extent1].[OrderFlag] AS [OrderFlag], [Extent1].[FreqId] AS [FreqId], [Extent1].[ETOrderIndex] AS [ETOrderIndex], [Extent1].[ExecCount] AS [ExecCount], [Extent1].[StartDate] AS [StartDate], [Extent1].[StopDate] AS [StopDate], [Extent1].[ModifyTime] AS [ModifyTime], [Extent1].[WeekDay] AS [WeekDay], [Extent1].[DayTime] AS [DayTime], [Extent1].[PrepayFlag] AS [PrepayFlag], [Extent1].[PreVisitXh] AS [PreVisitXh], [Extent1].[BookEndDate] AS [BookEndDate], [Extent1].[ExamRoomId] AS [ExamRoomId], [Extent1].[ExamDeviceId] AS [ExamDeviceId], [Extent1].[ExamImageKey] AS [ExamImageKey], [Extent1].[ExamCatalogId] AS [ExamCatalogId], [Extent1].[SourceXh] AS [SourceXh], [Extent1].[SourceKind] AS [SourceKind], [Extent1].[DynamicFormXml] AS [DynamicFormXml], [Extent1].[BarPrintFlag] AS [BarPrintFlag], [Extent1].[BarPrintDate] AS [BarPrintDate], [Extent1].[BarPrintStaffId] AS [BarPrintStaffId], [Extent1].[RequestExeDeptId] AS [RequestExeDeptId], [Extent1].[PregnantFlag] AS [PregnantFlag], [Extent1].[CreateStaffId] AS [CreateStaffId], [Extent1].[DCStaffId] AS [DCStaffId], [Extent1].[DCDate] AS [DCDate], [Extent1].[GetMediaKind] AS [GetMediaKind], [Extent1].[PhysiologicalCycle] AS [PhysiologicalCycle] FROM [ETO].[ETOrder] AS [Extent1] WITH (NOLOCK) WHERE ([Extent1].[VisitXh] = @p__linq__0) AND ( CAST( [Extent1].[SysFlag] AS int) = @p__linq__1) AND (3 <> [Extent1].[Status]) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: ReaderExecuting>>Data Source=172.16.64.175;initial Catalog=TrustCIS;integrated security=false;MultipleActiveResultSets=True;Application Name=ETOApp;uid=sa;>>1101 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Py] AS [Py], [Extent1].[Wb] AS [Wb], [Extent1].[Memo] AS [Memo], [Extent1].[PrintOrder] AS [PrintOrder], [Extent1].[TimeStamp] AS [TimeStamp] FROM [Common].[OPInvoiceAccItem] AS [Extent1] WITH (NOLOCK) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Py] AS [Py], [Extent1].[Wb] AS [Wb], [Extent1].[Memo] AS [Memo], [Extent1].[TimeStamp] AS [TimeStamp] FROM [Common].[OPYBAccItem] AS [Extent1] WITH (NOLOCK) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: SELECT [Extent1].[YBId] AS [YBId], [Extent1].[YBFLExFlag] AS [YBFLExFlag], [Extent1].[YBFLExName] AS [YBFLExName], [Extent1].[Memo] AS [Memo], [Extent1].[YBFLExId] AS [YBFLExId] FROM [Common].[YBCodeEx] AS [Extent1] WITH (NOLOCK) WHERE @p__linq__0 = [Extent1].[YBId] ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>M1 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: SELECT TOP (2) [Extent1].[Id] AS [Id], [Extent1].[YBPolicyId] AS [YBPolicyId], [Extent1].[Name] AS [Name], [Extent1].[Py] AS [Py], [Extent1].[Wb] AS [Wb], [Extent1].[CredenceKindId] AS [CredenceKindId], [Extent1].[SysFlag] AS [SysFlag], [Extent1].[CalcFlag] AS [CalcFlag], [Extent1].[OPSelfRatio] AS [OPSelfRatio], [Extent1].[IPSelfRatio] AS [IPSelfRatio], [Extent1].[PriceRatio] AS [PriceRatio], [Extent1].[YBPayLine] AS [YBPayLine], [Extent1].[DepositLowerLine] AS [DepositLowerLine], [Extent1].[PatScopeFlag] AS [PatScopeFlag], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[Memo] AS [Memo], [Extent1].[CreditLine] AS [CreditLine], [Extent1].[YBPayUpperLine] AS [YBPayUpperLine], [Extent1].[IsOPDisease] AS [IsOPDisease], [Extent1].[YBCode1] AS [YBCode1], [Extent1].[YBCode2] AS [YBCode2], [Extent1].[IsCombined] AS [IsCombined], [Extent1].[YBPayLineKind] AS [YBPayLineKind], [Extent1].[YBPayLineCalcKind] AS [YBPayLineCalcKind], [Extent1].[YBPayLineStartDate] AS [YBPayLineStartDate], [Extent1].[RefYBId] AS [RefYBId], [Extent1].[NonAuditYBId] AS [NonAuditYBId], [Extent1].[YBSummaryKind] AS [YBSummaryKind], [Extent1].[BIReportFlag] AS [BIReportFlag], [Extent1].[CalcCombineItem] AS [CalcCombineItem], [Extent1].[PostPaid] AS [PostPaid], [Extent1].[LastPostPaidConstraint] AS [LastPostPaidConstraint], [Extent1].[CredenceLenSet] AS [CredenceLenSet], [Extent1].[CantUseIfBlock] AS [CantUseIfBlock], [Extent1].[BindUnitAccount] AS [BindUnitAccount], [Extent1].[MRYBId] AS [MRYBId], [Extent1].[SimCalcFlag] AS [SimCalcFlag], [Extent1].[InvoiceDisableFlag] AS [InvoiceDisableFlag], [Extent1].[YBPatKind] AS [YBPatKind] FROM [Common].[YBCode] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Id] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>M1 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: SELECT TOP (2) [Extent1].[Id] AS [Id], [Extent1].[YBPolicyId] AS [YBPolicyId], [Extent1].[Name] AS [Name], [Extent1].[Py] AS [Py], [Extent1].[Wb] AS [Wb], [Extent1].[CredenceKindId] AS [CredenceKindId], [Extent1].[SysFlag] AS [SysFlag], [Extent1].[CalcFlag] AS [CalcFlag], [Extent1].[OPSelfRatio] AS [OPSelfRatio], [Extent1].[IPSelfRatio] AS [IPSelfRatio], [Extent1].[PriceRatio] AS [PriceRatio], [Extent1].[YBPayLine] AS [YBPayLine], [Extent1].[DepositLowerLine] AS [DepositLowerLine], [Extent1].[PatScopeFlag] AS [PatScopeFlag], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[Memo] AS [Memo], [Extent1].[CreditLine] AS [CreditLine], [Extent1].[YBPayUpperLine] AS [YBPayUpperLine], [Extent1].[IsOPDisease] AS [IsOPDisease], [Extent1].[YBCode1] AS [YBCode1], [Extent1].[YBCode2] AS [YBCode2], [Extent1].[IsCombined] AS [IsCombined], [Extent1].[YBPayLineKind] AS [YBPayLineKind], [Extent1].[YBPayLineCalcKind] AS [YBPayLineCalcKind], [Extent1].[YBPayLineStartDate] AS [YBPayLineStartDate], [Extent1].[RefYBId] AS [RefYBId], [Extent1].[NonAuditYBId] AS [NonAuditYBId], [Extent1].[YBSummaryKind] AS [YBSummaryKind], [Extent1].[BIReportFlag] AS [BIReportFlag], [Extent1].[CalcCombineItem] AS [CalcCombineItem], [Extent1].[PostPaid] AS [PostPaid], [Extent1].[LastPostPaidConstraint] AS [LastPostPaidConstraint], [Extent1].[CredenceLenSet] AS [CredenceLenSet], [Extent1].[CantUseIfBlock] AS [CantUseIfBlock], [Extent1].[BindUnitAccount] AS [BindUnitAccount], [Extent1].[MRYBId] AS [MRYBId], [Extent1].[SimCalcFlag] AS [SimCalcFlag], [Extent1].[InvoiceDisableFlag] AS [InvoiceDisableFlag], [Extent1].[YBPatKind] AS [YBPatKind] FROM [Common].[YBCode] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Id] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>M1 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: SELECT [Extent1].[Idm] AS [Idm], [Extent1].[ItemId] AS [ItemId], [Extent1].[YBPolicyId] AS [YBPolicyId], [Extent1].[YBDrugCatalogId] AS [YBDrugCatalogId], [Extent1].[OPSelfRatio] AS [OPSelfRatio], [Extent1].[IPSelfRatio] AS [IPSelfRatio], [Extent1].[ModifiedDate] AS [ModifiedDate], [Extent1].[SuitableDisease] AS [SuitableDisease], [Extent1].[Memo] AS [Memo] FROM [Common].[YBItemSelfConfig] AS [Extent1] WITH (NOLOCK) WHERE ([Extent1].[YBPolicyId] = @p__linq__0) AND ([Extent1].[Idm] > 0) AND ([Extent1].[Idm] IN (3)) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>00 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: SELECT [Extent1].[Idm] AS [Idm], [Extent1].[ItemId] AS [ItemId], [Extent1].[YBId] AS [YBId], [Extent1].[PriceRatio] AS [PriceRatio], [Extent1].[ModifiedDate] AS [ModifiedDate], [Extent1].[Memo] AS [Memo] FROM [Common].[YBItemSpecialPrice] AS [Extent1] WITH (NOLOCK) WHERE ([Extent1].[YBId] = @p__linq__0) AND ([Extent1].[Idm] > 0) AND ([Extent1].[Idm] IN (3)) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>M1 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: SELECT [Extent1].[YBId] AS [YBId], [Extent1].[SubAccItemId] AS [SubAccItemId], [Extent1].[OPSelfRatio] AS [OPSelfRatio], [Extent1].[IPSelfRatio] AS [IPSelfRatio], [Extent1].[OPOffRatio] AS [OPOffRatio], [Extent1].[IPOffRatio] AS [IPOffRatio], [Extent1].[ModifiedDate] AS [ModifiedDate], [Extent1].[Memo] AS [Memo], [Extent1].[UpperPrice] AS [UpperPrice] FROM [Common].[YBItemSubAccSpecialConfig] AS [Extent1] WITH (NOLOCK) WHERE ([Extent1].[YBId] = @p__linq__0) AND ([Extent1].[SubAccItemId] IN ('01')) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>M1 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: SELECT [Extent1].[Idm] AS [Idm], [Extent1].[ItemId] AS [ItemId], [Extent1].[YBId] AS [YBId], [Extent1].[OPSelfRatio] AS [OPSelfRatio], [Extent1].[IPSelfRatio] AS [IPSelfRatio], [Extent1].[ModifiedDate] AS [ModifiedDate], [Extent1].[Memo] AS [Memo], [Extent1].[OPOffRatio] AS [OPOffRatio], [Extent1].[IPOffRatio] AS [IPOffRatio], [Extent1].[UpperPrice] AS [UpperPrice], [Extent1].[CXh] AS [CXh] FROM [Common].[YBItemSpecialConfig] AS [Extent1] WITH (NOLOCK) WHERE ([Extent1].[YBId] = @p__linq__0) AND ([Extent1].[Idm] > 0) AND ([Extent1].[Idm] IN (3)) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>M1 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Py] AS [Py], [Extent1].[Wb] AS [Wb], [Extent1].[YBPolicyId] AS [YBPolicyId], [Extent1].[SelfRatio] AS [SelfRatio], [Extent1].[FontColor] AS [FontColor], [Extent1].[Prefix] AS [Prefix], [Extent1].[Memo] AS [Memo], [Extent1].[TimeStamp] AS [TimeStamp] FROM [Common].[YBItemCatalog] AS [Extent1] WITH (NOLOCK) WHERE EXISTS (SELECT 1 AS [C1] FROM [Common].[YBCode] AS [Extent2] WITH (NOLOCK) WHERE ([Extent1].[YBPolicyId] = [Extent2].[YBPolicyId]) AND ([Extent2].[Id] = @p__linq__0) ) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>M1 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: SELECT [Extent1].[Idm] AS [Idm], [Extent1].[DrugId] AS [DrugId], [Extent1].[DrugBasicName] AS [DrugBasicName], [Extent1].[Name] AS [Name], [Extent1].[Py] AS [Py], [Extent1].[Wb] AS [Wb], [Extent1].[RegisterNo] AS [RegisterNo], [Extent1].[Spec] AS [Spec], [Extent1].[DrugKindId] AS [DrugKindId], [Extent1].[DrugFormId] AS [DrugFormId], [Extent1].[ManuId] AS [ManuId], [Extent1].[ManuName] AS [ManuName], [Extent1].[ValidMonth] AS [ValidMonth], [Extent1].[PriceLS] AS [PriceLS], [Extent1].[PricePF] AS [PricePF], [Extent1].[PriceJJ] AS [PriceJJ], [Extent1].[UpperPrice] AS [UpperPrice], [Extent1].[MinUnit] AS [MinUnit], [Extent1].[YKUnit] AS [YKUnit], [Extent1].[YKRatio] AS [YKRatio], [Extent1].[JHUnit] AS [JHUnit], [Extent1].[JHRatio] AS [JHRatio], [Extent1].[ControlFlag] AS [ControlFlag], [Extent1].[LimitFlag] AS [LimitFlag], [Extent1].[GZFlag] AS [GZFlag], [Extent1].[KLRatio] AS [KLRatio], [Extent1].[SJZJFlag] AS [SJZJFlag], [Extent1].[DrugImage] AS [DrugImage], [Extent1].[ZMLBId] AS [ZMLBId], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[LJLYFlag] AS [LJLYFlag], [Extent1].[AccId] AS [AccId], [Extent1].[PackageFlag] AS [PackageFlag], [Extent1].[OPUnit] AS [OPUnit], [Extent1].[OPRatio] AS [OPRatio], [Extent1].[IPUnit] AS [IPUnit], [Extent1].[IPRatio] AS [IPRatio], [Extent1].[SkinTestFlag] AS [SkinTestFlag], [Extent1].[PrintId] AS [PrintId], [Extent1].[SkinSendFlag] AS [SkinSendFlag], CAST( [Extent1].[SpecialFlag] AS smallint) AS [C1], [Extent1].[ManuFromFlag] AS [ManuFromFlag], [Extent1].[DDDId] AS [DDDId], [Extent1].[DDDDoseRatio] AS [DDDDoseRatio], [Extent1].[SkinTestValidDay] AS [SkinTestValidDay], [Extent1].[SysBitFlag] AS [SysBitFlag], [Extent1].[OPPartialSelfFlag] AS [OPPartialSelfFlag], [Extent1].[IPPartialSelfFlag] AS [IPPartialSelfFlag], [Extent1].[DistributorXh] AS [DistributorXh], [Extent1].[DistributorName] AS [DistributorName], [Extent1].[YBControlFlag] AS [YBControlFlag], [Extent1].[SubAccItemId] AS [SubAccItemId], [Extent1].[LossRatio] AS [LossRatio], [Extent1].[DoseUnit] AS [DoseUnit], [Extent1].[DrugCode] AS [DrugCode], [Extent1].[CategoryFlag] AS [CategoryFlag], [Extent1].[SpecialNote] AS [SpecialNote], [Extent1].[DoseRatio] AS [DoseRatio], [Extent1].[AMSIdm] AS [AMSIdm], [Extent1].[MinBitFlag] AS [MinBitFlag], [Extent1].[OriginalSpec] AS [OriginalSpec], [Extent1].[CustomKind] AS [CustomKind], [Extent1].[RefId] AS [RefId], [Extent1].[EKUnit] AS [EKUnit], [Extent1].[EKRatio] AS [EKRatio], [Extent1].[BidFlag] AS [BidFlag], [Extent1].[BidNo] AS [BidNo], [Extent1].[BidUnit] AS [BidUnit], [Extent1].[RegisterNoSource] AS [RegisterNoSource], [Extent1].[StoreDescription] AS [StoreDescription], [Extent1].[DrugCode1] AS [DrugCode1], [Extent1].[DrugCode2] AS [DrugCode2], [Extent1].[RegisterNoValidDate] AS [RegisterNoValidDate], [Extent1].[CommonDrugFlag] AS [CommonDrugFlag], [Extent1].[ProductName] AS [ProductName], [Extent1].[PriceLSOriginal] AS [PriceLSOriginal], [Extent1].[FullPronunciation] AS [FullPronunciation], [Extent1].[FullPronunciation1] AS [FullPronunciation1], [Extent1].[DrugVarietiesFlag] AS [DrugVarietiesFlag], [Extent1].[RecipePrintingFlag] AS [RecipePrintingFlag], [Extent1].[ZYLJLYFlag] AS [ZYLJLYFlag], [Extent1].[UnPackageFlagForIP] AS [UnPackageFlagForIP], [Extent1].[ValidMonthLowLimit] AS [ValidMonthLowLimit], [Extent1].[OutHospitalFlag] AS [OutHospitalFlag], [Extent1].[StdCode] AS [StdCode], [Extent1].[StdName] AS [StdName], [Extent1].[TempProcFlag] AS [TempProcFlag], [Extent1].[RowStamp] AS [RowStamp] FROM [Common].[Drug] AS [Extent1] WITH (NOLOCK) WHERE ([Extent1].[Idm] IN (3)) AND (1 = [Extent1].[OPPartialSelfFlag]) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Py] AS [Py], [Extent1].[Wb] AS [Wb], [Extent1].[AccItemId] AS [AccItemId], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[Memo] AS [Memo], [Extent1].[SelfRatio] AS [SelfRatio], [Extent1].[OffRatio] AS [OffRatio], [Extent1].[UpperPrice] AS [UpperPrice], [Extent1].[IPSelfRatio] AS [IPSelfRatio], [Extent1].[IPOffRatio] AS [IPOffRatio], [Extent1].[OPPartialSelfFlag] AS [OPPartialSelfFlag], [Extent1].[IPPartialSelfFlag] AS [IPPartialSelfFlag], [Extent1].[NHItemId] AS [NHItemId], [Extent1].[TimeStamp] AS [TimeStamp] FROM [Common].[SubAccountItem] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Id] IN ('01') ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: SELECT TOP (1) [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Description] AS [Description], [Extent1].[Value] AS [Value], [Extent1].[RefValue] AS [RefValue], [Extent1].[DataType] AS [DataType], [Extent1].[CanSelect] AS [CanSelect], [Extent1].[SelectSource] AS [SelectSource], [Extent1].[GroupId] AS [GroupId], [Extent1].[Editor] AS [Editor], [Extent1].[EditableFlag] AS [EditableFlag], [Extent1].[ModifyStaffId] AS [ModifyStaffId], [Extent1].[ModifyTime] AS [ModifyTime], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[TimeStamp] AS [TimeStamp] FROM [Common].[Setting] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Id] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>CommonPublicConfig ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: SELECT TOP (2) [Extent1].[Xh] AS [Xh], [Extent1].[PatId] AS [PatId], [Extent1].[CredenceNo] AS [CredenceNo], [Extent1].[ValidFrom] AS [ValidFrom], [Extent1].[ValidTo] AS [ValidTo], [Extent1].[YBId] AS [YBId], [Extent1].[CredenceKindId] AS [CredenceKindId], [Extent1].[DiagId] AS [DiagId], [Extent1].[YBDiseaseId] AS [YBDiseaseId], [Extent1].[YBCountyId] AS [YBCountyId], [Extent1].[StaffId] AS [StaffId], [Extent1].[SysFlag] AS [SysFlag], [Extent1].[ModifiedDate] AS [ModifiedDate], [Extent1].[YBCredenceEx] AS [YBCredenceEx], [Extent1].[CreditLine] AS [CreditLine], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[PayingEntXh] AS [PayingEntXh], [Extent1].[AccountId] AS [AccountId], [Extent1].[AccountFlag] AS [AccountFlag], [Extent1].[AccountAmount] AS [AccountAmount], [Extent1].[AccountKind] AS [AccountKind], [Extent1].[InsureNo] AS [InsureNo], [Extent1].[AssistanceFlag] AS [AssistanceFlag], [Extent1].[CardKindId] AS [CardKindId], [Extent1].[CardNo] AS [CardNo], [Extent1].[JSSJH] AS [JSSJH], [Extent1].[YBPayLine] AS [YBPayLine], [Extent1].[AccountBlockFlag] AS [AccountBlockFlag], [Extent1].[BindUnitPayLine] AS [BindUnitPayLine], [Extent1].[YBUnitId] AS [YBUnitId], [Extent1].[YBUnitName] AS [YBUnitName], [Extent1].[YBPatAddress] AS [YBPatAddress], [Extent1].[CredenceToken] AS [CredenceToken], [Extent1].[EcToken] AS [EcToken], [Extent1].[EcTokenDate] AS [EcTokenDate] FROM [Common].[PatYBCredence] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Xh] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>29745 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: SELECT TOP (2) [Extent1].[Xh] AS [Xh], [Extent1].[YBTransPreNo] AS [YBTransPreNo], [Extent1].[YBTransNo] AS [YBTransNo], [Extent1].[PatId] AS [PatId], [Extent1].[YBId] AS [YBId], [Extent1].[HISSjh] AS [HISSjh], [Extent1].[YBTransFlag] AS [YBTransFlag], [Extent1].[TransKind] AS [TransKind], [Extent1].[HISTransFlag] AS [HISTransFlag], [Extent1].[YBHCTransNo] AS [YBHCTransNo], [Extent1].[HISHCSjh] AS [HISHCSjh], [Extent1].[TransTime] AS [TransTime], [Extent1].[HCTransTime] AS [HCTransTime], [Extent1].[TransData] AS [TransData], [Extent1].[TransReturn] AS [TransReturn], [Extent1].[TransConfirmData] AS [TransConfirmData], [Extent1].[TransConfirmReturn] AS [TransConfirmReturn], [Extent1].[SpecialPatFlag] AS [SpecialPatFlag], [Extent1].[DiagnosisId] AS [DiagnosisId], [Extent1].[SeriousIllnessId] AS [SeriousIllnessId], [Extent1].[AccountFlag] AS [AccountFlag], [Extent1].[AdtKind] AS [AdtKind], [Extent1].[PatientType] AS [PatientType], [Extent1].[YBTransKind] AS [YBTransKind], [Extent1].[PolicyId] AS [PolicyId], [Extent1].[YBKind] AS [YBKind], [Extent1].[CardKindId] AS [CardKindId], [Extent1].[CardNo] AS [CardNo], [Extent1].[RegFee] AS [RegFee], [Extent1].[TreatmentFee] AS [TreatmentFee], [Extent1].[PatName] AS [PatName], [Extent1].[TotalMoney] AS [TotalMoney], [Extent1].[YBTotalMoney] AS [YBTotalMoney], [Extent1].[YBTransMoney] AS [YBTransMoney], [Extent1].[DiseaseOffFlag] AS [DiseaseOffFlag], [Extent1].[DiseaseOffTotalMoney] AS [DiseaseOffTotalMoney], [Extent1].[YBTransNo1] AS [YBTransNo1], [Extent1].[PayStatus] AS [PayStatus], [Extent1].[HospitalId] AS [HospitalId] FROM [Common].[YBTransaction] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Xh] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: SELECT [Extent1].[Xh] AS [Xh], [Extent1].[YBTransPreNo] AS [YBTransPreNo], [Extent1].[YBTransNo] AS [YBTransNo], [Extent1].[PatId] AS [PatId], [Extent1].[YBId] AS [YBId], [Extent1].[HISSjh] AS [HISSjh], [Extent1].[YBTransFlag] AS [YBTransFlag], [Extent1].[TransKind] AS [TransKind], [Extent1].[HISTransFlag] AS [HISTransFlag], [Extent1].[YBHCTransNo] AS [YBHCTransNo], [Extent1].[HISHCSjh] AS [HISHCSjh], [Extent1].[TransTime] AS [TransTime], [Extent1].[HCTransTime] AS [HCTransTime], [Extent1].[TransData] AS [TransData], [Extent1].[TransReturn] AS [TransReturn], [Extent1].[TransConfirmData] AS [TransConfirmData], [Extent1].[TransConfirmReturn] AS [TransConfirmReturn], [Extent1].[SpecialPatFlag] AS [SpecialPatFlag], [Extent1].[DiagnosisId] AS [DiagnosisId], [Extent1].[SeriousIllnessId] AS [SeriousIllnessId], [Extent1].[AccountFlag] AS [AccountFlag], [Extent1].[AdtKind] AS [AdtKind], [Extent1].[PatientType] AS [PatientType], [Extent1].[YBTransKind] AS [YBTransKind], [Extent1].[PolicyId] AS [PolicyId], [Extent1].[YBKind] AS [YBKind], [Extent1].[CardKindId] AS [CardKindId], [Extent1].[CardNo] AS [CardNo], [Extent1].[RegFee] AS [RegFee], [Extent1].[TreatmentFee] AS [TreatmentFee], [Extent1].[PatName] AS [PatName], [Extent1].[TotalMoney] AS [TotalMoney], [Extent1].[YBTotalMoney] AS [YBTotalMoney], [Extent1].[YBTransMoney] AS [YBTransMoney], [Extent1].[DiseaseOffFlag] AS [DiseaseOffFlag], [Extent1].[DiseaseOffTotalMoney] AS [DiseaseOffTotalMoney], [Extent1].[YBTransNo1] AS [YBTransNo1], [Extent1].[PayStatus] AS [PayStatus], [Extent1].[HospitalId] AS [HospitalId] FROM [Common].[YBTransaction] AS [Extent1] WITH (NOLOCK) WHERE (1 = [Extent1].[YBTransFlag]) AND ([Extent1].[HISSjh] = @p__linq__0) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>020260308zz001000001 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: SELECT [Extent1].[ObjectId] AS [ObjectId], [Extent1].[Name] AS [Name], [Extent1].[EntityType] AS [EntityType], [Extent1].[EntitySetName] AS [EntitySetName], [Extent1].[Description] AS [Description], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[ReleatedFlag] AS [ReleatedFlag], [Extent1].[ReleatedObjectId] AS [ReleatedObjectId], [Extent1].[ReleatedKeyExpress] AS [ReleatedKeyExpress] FROM [Common].[BaseDataLogConfig] AS [Extent1] WITH (NOLOCK) WHERE (0 = [Extent1].[DisableFlag]) AND ([Extent1].[ReleatedFlag] IN (cast(0 as smallint), cast(1 as smallint))) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: INSERT [Common].[YBTransaction]([YBTransPreNo], [YBTransNo], [PatId], [YBId], [SpecialPatFlag], [DiagnosisId], [SeriousIllnessId], [AccountFlag], [HISSjh], [YBTransFlag], [TransKind], [HISTransFlag], [YBHCTransNo], [HISHCSjh], [TransTime], [HCTransTime], [TransData], [TransReturn], [TransConfirmData], [TransConfirmReturn], [AdtKind], [PatientType], [YBTransKind], [PolicyId], [YBKind], [CardKindId], [CardNo], [RegFee], [TreatmentFee], [PatName], [TotalMoney], [YBTotalMoney], [YBTransMoney], [DiseaseOffFlag], [DiseaseOffTotalMoney], [YBTransNo1], [PayStatus], [HospitalId]) VALUES (@0, @1, @2, @3, NULL, NULL, NULL, NULL, @4, @5, @6, @7, NULL, NULL, @8, NULL, @9, NULL, NULL, NULL, NULL, NULL, NULL, @10, NULL, @11, @12, @13, @14, @15, @16, @17, @18, @19, @20, NULL, NULL, NULL) SELECT [Xh] FROM [Common].[YBTransaction] WHERE @@ROWCOUNT > 0 AND [Xh] = scope_identity() ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: SELECT TOP (1) [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Description] AS [Description], [Extent1].[Value] AS [Value], [Extent1].[RefValue] AS [RefValue], [Extent1].[DataType] AS [DataType], [Extent1].[CanSelect] AS [CanSelect], [Extent1].[SelectSource] AS [SelectSource], [Extent1].[GroupId] AS [GroupId], [Extent1].[Editor] AS [Editor], [Extent1].[EditableFlag] AS [EditableFlag], [Extent1].[ModifyStaffId] AS [ModifyStaffId], [Extent1].[ModifyTime] AS [ModifyTime], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[TimeStamp] AS [TimeStamp] FROM [Common].[Setting] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Id] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>SRDigital ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: SELECT TOP (1) [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Description] AS [Description], [Extent1].[Value] AS [Value], [Extent1].[RefValue] AS [RefValue], [Extent1].[DataType] AS [DataType], [Extent1].[CanSelect] AS [CanSelect], [Extent1].[SelectSource] AS [SelectSource], [Extent1].[GroupId] AS [GroupId], [Extent1].[Editor] AS [Editor], [Extent1].[EditableFlag] AS [EditableFlag], [Extent1].[ModifyStaffId] AS [ModifyStaffId], [Extent1].[ModifyTime] AS [ModifyTime], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[TimeStamp] AS [TimeStamp] FROM [Common].[Setting] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Id] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>SRCarryValue ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: SELECT TOP (2) [Extent1].[Xh] AS [Xh], [Extent1].[YBTransPreNo] AS [YBTransPreNo], [Extent1].[YBTransNo] AS [YBTransNo], [Extent1].[PatId] AS [PatId], [Extent1].[YBId] AS [YBId], [Extent1].[HISSjh] AS [HISSjh], [Extent1].[YBTransFlag] AS [YBTransFlag], [Extent1].[TransKind] AS [TransKind], [Extent1].[HISTransFlag] AS [HISTransFlag], [Extent1].[YBHCTransNo] AS [YBHCTransNo], [Extent1].[HISHCSjh] AS [HISHCSjh], [Extent1].[TransTime] AS [TransTime], [Extent1].[HCTransTime] AS [HCTransTime], [Extent1].[TransData] AS [TransData], [Extent1].[TransReturn] AS [TransReturn], [Extent1].[TransConfirmData] AS [TransConfirmData], [Extent1].[TransConfirmReturn] AS [TransConfirmReturn], [Extent1].[SpecialPatFlag] AS [SpecialPatFlag], [Extent1].[DiagnosisId] AS [DiagnosisId], [Extent1].[SeriousIllnessId] AS [SeriousIllnessId], [Extent1].[AccountFlag] AS [AccountFlag], [Extent1].[AdtKind] AS [AdtKind], [Extent1].[PatientType] AS [PatientType], [Extent1].[YBTransKind] AS [YBTransKind], [Extent1].[PolicyId] AS [PolicyId], [Extent1].[YBKind] AS [YBKind], [Extent1].[CardKindId] AS [CardKindId], [Extent1].[CardNo] AS [CardNo], [Extent1].[RegFee] AS [RegFee], [Extent1].[TreatmentFee] AS [TreatmentFee], [Extent1].[PatName] AS [PatName], [Extent1].[TotalMoney] AS [TotalMoney], [Extent1].[YBTotalMoney] AS [YBTotalMoney], [Extent1].[YBTransMoney] AS [YBTransMoney], [Extent1].[DiseaseOffFlag] AS [DiseaseOffFlag], [Extent1].[DiseaseOffTotalMoney] AS [DiseaseOffTotalMoney], [Extent1].[YBTransNo1] AS [YBTransNo1], [Extent1].[PayStatus] AS [PayStatus], [Extent1].[HospitalId] AS [HospitalId] FROM [Common].[YBTransaction] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Xh] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>1338 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: SELECT TOP (2) [Extent1].[Xh] AS [Xh], [Extent1].[YBTransPreNo] AS [YBTransPreNo], [Extent1].[YBTransNo] AS [YBTransNo], [Extent1].[PatId] AS [PatId], [Extent1].[YBId] AS [YBId], [Extent1].[HISSjh] AS [HISSjh], [Extent1].[YBTransFlag] AS [YBTransFlag], [Extent1].[TransKind] AS [TransKind], [Extent1].[HISTransFlag] AS [HISTransFlag], [Extent1].[YBHCTransNo] AS [YBHCTransNo], [Extent1].[HISHCSjh] AS [HISHCSjh], [Extent1].[TransTime] AS [TransTime], [Extent1].[HCTransTime] AS [HCTransTime], [Extent1].[TransData] AS [TransData], [Extent1].[TransReturn] AS [TransReturn], [Extent1].[TransConfirmData] AS [TransConfirmData], [Extent1].[TransConfirmReturn] AS [TransConfirmReturn], [Extent1].[SpecialPatFlag] AS [SpecialPatFlag], [Extent1].[DiagnosisId] AS [DiagnosisId], [Extent1].[SeriousIllnessId] AS [SeriousIllnessId], [Extent1].[AccountFlag] AS [AccountFlag], [Extent1].[AdtKind] AS [AdtKind], [Extent1].[PatientType] AS [PatientType], [Extent1].[YBTransKind] AS [YBTransKind], [Extent1].[PolicyId] AS [PolicyId], [Extent1].[YBKind] AS [YBKind], [Extent1].[CardKindId] AS [CardKindId], [Extent1].[CardNo] AS [CardNo], [Extent1].[RegFee] AS [RegFee], [Extent1].[TreatmentFee] AS [TreatmentFee], [Extent1].[PatName] AS [PatName], [Extent1].[TotalMoney] AS [TotalMoney], [Extent1].[YBTotalMoney] AS [YBTotalMoney], [Extent1].[YBTransMoney] AS [YBTransMoney], [Extent1].[DiseaseOffFlag] AS [DiseaseOffFlag], [Extent1].[DiseaseOffTotalMoney] AS [DiseaseOffTotalMoney], [Extent1].[YBTransNo1] AS [YBTransNo1], [Extent1].[PayStatus] AS [PayStatus], [Extent1].[HospitalId] AS [HospitalId] FROM [Common].[YBTransaction] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Xh] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>1338 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:02 Message: UPDATE [Common].[YBTransaction] SET [YBTransFlag] = @0, [TransTime] = @1 WHERE ([Xh] = @2) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:03 Message: SELECT TOP (1) [Extent1].[DeptId] AS [DeptId], [Extent1].[DeptName] AS [DeptName], [Extent1].[TimeStamp] AS [TimeStamp] FROM [Common].[ChargeDept] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[DeptId] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:03 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>H038 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:03 Message: SELECT TOP (1) [Extent1].[Xh] AS [Xh], [Extent1].[PatId] AS [PatId], [Extent1].[PatName] AS [PatName], [Extent1].[YBId] AS [YBId], [Extent1].[CredenceXh] AS [CredenceXh], [Extent1].[RegFlag] AS [RegFlag], [Extent1].[DeptId] AS [DeptId], [Extent1].[RegDate] AS [RegDate], [Extent1].[ReturnVisitFlag] AS [ReturnVisitFlag], [Extent1].[PreRegFlag] AS [PreRegFlag], [Extent1].[BookingXh] AS [BookingXh], [Extent1].[RegKindId] AS [RegKindId], [Extent1].[StaffId] AS [StaffId], [Extent1].[CreatedDate] AS [CreatedDate], [Extent1].[FeeFlag] AS [FeeFlag], [Extent1].[RegId] AS [RegId], [Extent1].[RegName] AS [RegName], [Extent1].[RegDoctorId] AS [RegDoctorId], [Extent1].[RegTimeFlag] AS [RegTimeFlag], [Extent1].[VisitFlag] AS [VisitFlag], [Extent1].[DoctorId1] AS [DoctorId1], [Extent1].[DoctorId2] AS [DoctorId2], [Extent1].[CreditLine] AS [CreditLine], [Extent1].[HomeBedXh] AS [HomeBedXh], [Extent1].[HisVisitNo] AS [HisVisitNo], [Extent1].[AnmeldenProvinceId] AS [AnmeldenProvinceId], [Extent1].[AnmeldenStateId] AS [AnmeldenStateId], [Extent1].[AnmeldenCountyId] AS [AnmeldenCountyId], [Extent1].[AnmeldenAddress] AS [AnmeldenAddress], [Extent1].[AnmeldenZip] AS [AnmeldenZip], [Extent1].[WorkingUnit] AS [WorkingUnit], [Extent1].[WorkingZip] AS [WorkingZip], [Extent1].[WorkingPhone] AS [WorkingPhone], [Extent1].[ReturnAuditFlag] AS [ReturnAuditFlag], [Extent1].[IndexNumber] AS [IndexNumber], [Extent1].[CardKindId] AS [CardKindId], [Extent1].[CardNo] AS [CardNo], [Extent1].[DisplayCardNo] AS [DisplayCardNo], [Extent1].[ZoneId] AS [ZoneId], [Extent1].[EmergencyFlag] AS [EmergencyFlag], [Extent1].[SelfRegister] AS [SelfRegister], [Extent1].[DiseaseId] AS [DiseaseId], [Extent1].[PredictVisitTime] AS [PredictVisitTime], [Extent1].[SerialFlag] AS [SerialFlag], [Extent1].[SpaceRegFlag] AS [SpaceRegFlag], [Extent1].[OverFlag] AS [OverFlag], [Extent1].[RescueCarFlag] AS [RescueCarFlag], [Extent1].[DoctorTime1] AS [DoctorTime1], [Extent1].[DoctorTime2] AS [DoctorTime2], [Extent1].[PatLogXh] AS [PatLogXh], [Extent1].[LastSignTime] AS [LastSignTime] FROM [OP].[Register] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Xh] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:03 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=OPApp;uid=sa;>>1101 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:03 Message: INSERT [OP].[Settlement]([SJH], [PatId], [PatName], [YBId], [CredenceXh], [Prefix], [InvoiceBookXh], [InvoiceNo], [InvoiceTitle], [InvoiceCount], [RegXh], [RegDate], [ListMoney], [ActualMoney], [SelfMoney], [YBPartialSelfMoney], [YBSelfMoney], [YBMoney], [OffMoney], [ReliefMoney], [UnitAccountMoney], [UnitOutMoney], [SRMoney], [ReturnSJH], [PrintFlag], [PrintDate], [PrintStaffId], [RecFlag], [SettlementFlag], [SettlementDate], [SettlementStaffId], [YBJSFlag], [YBTransNo], [OweFlag], [OweMoney], [OweAuthorizedStaffId], [YBAccountInfo], [PayInfo], [SettlementKind], [DiseaseId], [SpecialOffMoney], [SelfPay], [EmergencyFlag], [RePrintFlag], [RePrintInvoice], [DiseaseOffMoney], [YBReSelfPay], [YBPayLineSum], [YBWholePlanSum], [YBMoneySum], [FYWinGuidance], [MedicalGuidance], [SpecialSettleFlag], [StaffId], [CreatedDate], [SourceKind], [ReceiptMoney], [ChangeMoney]) VALUES (@0, @1, @2, @3, @4, NULL, @5, @6, @7, @8, @9, @10, @11, @12, @13, @14, @15, @16, @17, @18, @19, @20, @21, NULL, @22, NULL, NULL, @23, @24, NULL, @25, @26, NULL, @27, NULL, NULL, @28, @29, @30, @31, @32, @33, @34, @35, NULL, @36, @37, @38, @39, @40, NULL, NULL, @41, @42, @43, @44, NULL, NULL) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:03 Message: INSERT [OP].[FeeData]([RegXh], [RecipeXh], [RecipeDetailXh], [RecipeDetailKind], [JSSJH], [DeptId], [WardId], [DoctorId], [ExecDeptId], [ExecStaffId], [Idm], [ItemId], [PrintId], [AccItemId], [AccItemName], [ItemName], [ItemSpec], [OPUnit], [OPUnitRatio], [YKRatio], [ListPrice], [Quantity], [Money], [YBMoney], [UpperPrice], [PriceRatio], [SelfRatio], [Prefix], [YBPartialSelfRatio], [ReliefMoney], [OffRatio], [SpecialOffMoney], [SubAccItemId], [SelfPay], [YBPartialSelfMoney], [DiseaseOffMoney], [SelfMoney], [OffMoney], [YBSelfMoney], [YBReSelfRatio], [UnitOutMoney], [UnitAccountMoney], [YBReSelfPay], [UnitTotalMoney], [ReturnQuantity], [TreatmentMemo], [YBAuditFail], [SettlementFlag], [RecFlag], [ConfirmFlag], [ReturnXh], [StaffId], [ModifiedDate], [DefaultRatio], [ClinicItemXh], [CalcFlag], [MDHBarCode], [RuleIds]) VALUES (@0, @1, @2, @3, @4, @5, NULL, @6, @7, @8, @9, @10, @11, @12, @13, @14, @15, @16, @17, @18, @19, @20, @21, @22, @23, @24, @25, NULL, @26, @27, @28, @29, @30, @31, @32, @33, @34, @35, @36, @37, @38, @39, @40, @41, @42, NULL, @43, @44, @45, @46, NULL, @47, @48, NULL, NULL, NULL, NULL, NULL) SELECT [Xh] FROM [OP].[FeeData] WHERE @@ROWCOUNT > 0 AND [Xh] = scope_identity() ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:03 Message: INSERT [OP].[SettlementData]([JSSJH], [AccId], [AccName], [InvoiceAccId], [InvoiceAccName], [OPYBAccId], [OPYBAccName], [ListMoney], [ActualMoney], [SelfMoney], [YBPartialSelfMoney], [ReliefMoney], [OffMoney], [UnitAccountMoney], [UnitOutMoney], [SpecialOffMoney], [YBSelfMoney], [SelfPay], [YBMoney], [UnitTotalMoney]) VALUES (@0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10, NULL, @11, @12, @13, @14, @15, @16, @17, @18) SELECT [Xh] FROM [OP].[SettlementData] WHERE @@ROWCOUNT > 0 AND [Xh] = scope_identity() ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:03 Message: INSERT [OP].[SettlementMoney]([JSSJH], [MoneyKindId], [MoneyName], [Money], [ReturnFlag], [PayingUnit], [BankName], [BankAccount], [RelatedXh], [Memo]) VALUES (@0, @1, @2, @3, @4, NULL, NULL, NULL, @5, NULL) SELECT [Xh] FROM [OP].[SettlementMoney] WHERE @@ROWCOUNT > 0 AND [Xh] = scope_identity() ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:03 Message: SELECT [Extent1].[Xh] AS [Xh], [Extent1].[RegXh] AS [RegXh], [Extent1].[VisitDate] AS [VisitDate], [Extent1].[PatId] AS [PatId], [Extent1].[YBId] AS [YBId], [Extent1].[CredenceXh] AS [CredenceXh], [Extent1].[RecipeName] AS [RecipeName], [Extent1].[RecipeNum] AS [RecipeNum], [Extent1].[RecipeKindId] AS [RecipeKindId], [Extent1].[DoctorId] AS [DoctorId], [Extent1].[DoctorDatetime] AS [DoctorDatetime], [Extent1].[DoctorRecipeNo] AS [DoctorRecipeNo], [Extent1].[DoctorDept] AS [DoctorDept], [Extent1].[ValidFlag] AS [ValidFlag], [Extent1].[ExeDept] AS [ExeDept], [Extent1].[ExeDate] AS [ExeDate], [Extent1].[ExeFlag] AS [ExeFlag], [Extent1].[ExeStaffId] AS [ExeStaffId], [Extent1].[MessageFlag] AS [MessageFlag], [Extent1].[FeeFlag] AS [FeeFlag], [Extent1].[FeeDate] AS [FeeDate], [Extent1].[StaffId] AS [StaffId], [Extent1].[MessageDate] AS [MessageDate], [Extent1].[ETOrderXh] AS [ETOrderXh], [Extent1].[OriginFlag] AS [OriginFlag], [Extent1].[DiseaseFlag] AS [DiseaseFlag], [Extent1].[ReturnFlag] AS [ReturnFlag], [Extent1].[ReturnReason] AS [ReturnReason], [Extent1].[Memo] AS [Memo], [Extent1].[RecipeFlag] AS [RecipeFlag], [Extent1].[RecipeSerialNo] AS [RecipeSerialNo], [Extent1].[PrintFlag] AS [PrintFlag], [Extent1].[PrintDate] AS [PrintDate], [Extent1].[FYWinId] AS [FYWinId], [Extent1].[FYWinName] AS [FYWinName], [Extent1].[MedicalGuidance] AS [MedicalGuidance], [Extent1].[TreatmentScopeFlag] AS [TreatmentScopeFlag], [Extent1].[AttorneysName] AS [AttorneysName], [Extent1].[AttorneysPhone] AS [AttorneysPhone], [Extent1].[AttorneySfzh] AS [AttorneySfzh], [Extent1].[RelatedRecipeXh] AS [RelatedRecipeXh], [Extent1].[OperationRequestXh] AS [OperationRequestXh], [Extent1].[GenerationFriedFlag] AS [GenerationFriedFlag], [Extent1].[GenerationFriedNum] AS [GenerationFriedNum], [Extent1].[RecipeNumPerDay] AS [RecipeNumPerDay], [Extent1].[ModifiedDate] AS [ModifiedDate], [Extent1].[UsageId] AS [UsageId], [Extent1].[PrepayFlag] AS [PrepayFlag], [Extent1].[ConfirmFlag] AS [ConfirmFlag], [Extent1].[SourceXh] AS [SourceXh], [Extent1].[SourceKind] AS [SourceKind], [Extent1].[ZQNum] AS [ZQNum], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[ValidUsableFlag] AS [ValidUsableFlag], [Extent1].[SyncSignNo] AS [SyncSignNo], [Extent1].[ReturnStaffId] AS [ReturnStaffId], [Extent1].[ReturnTime] AS [ReturnTime], [Extent1].[DoctorCAFlag] AS [DoctorCAFlag], [Extent1].[AddressXh] AS [AddressXh], [Extent1].[DecoctFlag] AS [DecoctFlag], [Extent1].[FixTemplateName] AS [FixTemplateName] FROM [OP].[Recipe] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Xh] IN (629) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:03 Message: SELECT [Extent1].[Xh] AS [Xh], [Extent1].[GroupXh] AS [GroupXh], [Extent1].[RecipeXh] AS [RecipeXh], [Extent1].[Idm] AS [Idm], [Extent1].[Name] AS [Name], [Extent1].[WarehouseId] AS [WarehouseId], [Extent1].[ItemSpec] AS [ItemSpec], [Extent1].[DoseUnit] AS [DoseUnit], [Extent1].[DoseRatio] AS [DoseRatio], [Extent1].[YKRatio] AS [YKRatio], [Extent1].[MinUnit] AS [MinUnit], [Extent1].[DoseQuantity] AS [DoseQuantity], [Extent1].[MinQuantity] AS [MinQuantity], [Extent1].[TotalQuantity] AS [TotalQuantity], [Extent1].[OPUnit] AS [OPUnit], [Extent1].[OPRatio] AS [OPRatio], [Extent1].[Days] AS [Days], [Extent1].[FreqId] AS [FreqId], [Extent1].[FreqName] AS [FreqName], [Extent1].[UsageId] AS [UsageId], [Extent1].[UsageName] AS [UsageName], [Extent1].[ListPrice] AS [ListPrice], [Extent1].[Money] AS [Money], [Extent1].[JJPrice] AS [JJPrice], [Extent1].[FeeFlag] AS [FeeFlag], [Extent1].[FeeDate] AS [FeeDate], [Extent1].[StartDay] AS [StartDay], [Extent1].[ValidFlag] AS [ValidFlag], [Extent1].[Remark] AS [Remark], [Extent1].[SelfProvidedFlag] AS [SelfProvidedFlag], [Extent1].[ApproveFlag] AS [ApproveFlag], [Extent1].[Prefix] AS [Prefix], [Extent1].[RecFlag] AS [RecFlag], [Extent1].[CanReturnCount] AS [CanReturnCount], [Extent1].[PassWarn] AS [PassWarn], [Extent1].[YBAuditFail] AS [YBAuditFail], [Extent1].[RemarkValue] AS [RemarkValue], [Extent1].[ProductName] AS [ProductName], [Extent1].[DiseaseFlag] AS [DiseaseFlag], [Extent1].[TreatmentScopeFlag] AS [TreatmentScopeFlag], [Extent1].[ReturnQuantity] AS [ReturnQuantity], [Extent1].[ConfirmFlag] AS [ConfirmFlag], [Extent1].[SourceXh] AS [SourceXh], [Extent1].[SourceKind] AS [SourceKind], [Extent1].[ValidUsableFlag] AS [ValidUsableFlag], [Extent1].[AllergyPositiveSetFlag] AS [AllergyPositiveSetFlag], [Extent1].[SkinTestFlag] AS [SkinTestFlag], [Extent1].[SkinTestResult] AS [SkinTestResult], [Extent1].[SkinTestResultTime] AS [SkinTestResultTime], [Extent1].[YBControlFlag] AS [YBControlFlag] FROM [OP].[RecipeData] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[RecipeXh] IN (629) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:03 Message: SELECT [Extent1].[Xh] AS [Xh], [Extent1].[RecipeDataXh] AS [RecipeDataXh], [Extent1].[RecipeKind] AS [RecipeKind], [Extent1].[PatId] AS [PatId], [Extent1].[Idm] AS [Idm], [Extent1].[DrugId] AS [DrugId], [Extent1].[SkinTestResult] AS [SkinTestResult], [Extent1].[TestBeginDate] AS [TestBeginDate], [Extent1].[TestEndDate] AS [TestEndDate], [Extent1].[TestStaffId] AS [TestStaffId], [Extent1].[TreatmentDate] AS [TreatmentDate], [Extent1].[ClinicItemXh] AS [ClinicItemXh], [Extent1].[FeeFlag] AS [FeeFlag], [Extent1].[FeeData] AS [FeeData], [Extent1].[SysFlag] AS [SysFlag], [Extent1].[ValidDate] AS [ValidDate], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[ResultFlag] AS [ResultFlag], [Extent1].[DrugKindId] AS [DrugKindId], [Extent1].[ExemptTestFlag] AS [ExemptTestFlag], [Extent1].[ExemptTestReason] AS [ExemptTestReason], [Extent1].[DesensitizationFlag] AS [DesensitizationFlag], [Extent1].[PastHistoryFlag] AS [PastHistoryFlag], [Extent1].[EntryStaffId] AS [EntryStaffId], [Extent1].[EntryDate] AS [EntryDate], [Extent1].[Memo] AS [Memo], [Extent1].[BatchNo] AS [BatchNo], [Extent1].[AuditStaffId] AS [AuditStaffId] FROM [Common].[SkinTest] AS [Extent1] WITH (NOLOCK) WHERE ([Extent1].[PatId] = @p__linq__0) AND ([Extent1].[RecipeDataXh] IN (285)) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:03 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustCIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>16392 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:04 Message: SELECT [Extent1].[ObjectId] AS [ObjectId], [Extent1].[Name] AS [Name], [Extent1].[EntityType] AS [EntityType], [Extent1].[EntitySetName] AS [EntitySetName], [Extent1].[Description] AS [Description], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[ReleatedFlag] AS [ReleatedFlag], [Extent1].[ReleatedObjectId] AS [ReleatedObjectId], [Extent1].[ReleatedKeyExpress] AS [ReleatedKeyExpress] FROM [Common].[BaseDataLogConfig] AS [Extent1] WITH (NOLOCK) WHERE (0 = [Extent1].[DisableFlag]) AND ([Extent1].[ReleatedFlag] IN (cast(0 as smallint), cast(1 as smallint))) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:04 Message: SELECT TOP (1) [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Description] AS [Description], [Extent1].[Value] AS [Value], [Extent1].[RefValue] AS [RefValue], [Extent1].[DataType] AS [DataType], [Extent1].[CanSelect] AS [CanSelect], [Extent1].[SelectSource] AS [SelectSource], [Extent1].[GroupId] AS [GroupId], [Extent1].[Editor] AS [Editor], [Extent1].[EditableFlag] AS [EditableFlag], [Extent1].[ModifyStaffId] AS [ModifyStaffId], [Extent1].[ModifyTime] AS [ModifyTime], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[TimeStamp] AS [TimeStamp] FROM [Common].[Setting] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Id] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:04 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>SeparateMode ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:05 Message: SELECT TOP (1) [Extent1].[Id] AS [Id], [Extent1].[SurName] AS [SurName], [Extent1].[GivenName] AS [GivenName], [Extent1].[Py] AS [Py], [Extent1].[Wb] AS [Wb], [Extent1].[OPBLH] AS [OPBLH], [Extent1].[IPBLH] AS [IPBLH], [Extent1].[SexId] AS [SexId], [Extent1].[Birthday] AS [Birthday], [Extent1].[Weight] AS [Weight], [Extent1].[IdentityKindId] AS [IdentityKindId], [Extent1].[Sfzh] AS [Sfzh], [Extent1].[MaritalStatusId] AS [MaritalStatusId], [Extent1].[CountryId] AS [CountryId], [Extent1].[NationId] AS [NationId], [Extent1].[ProvinceId] AS [ProvinceId], [Extent1].[StateId] AS [StateId], [Extent1].[CountyId] AS [CountyId], [Extent1].[Address] AS [Address], [Extent1].[Phone] AS [Phone], [Extent1].[Mobile] AS [Mobile], [Extent1].[Mail] AS [Mail], [Extent1].[StaffId] AS [StaffId], [Extent1].[ModifiedDate] AS [ModifiedDate], [Extent1].[Memo] AS [Memo], [Extent1].[PatImage] AS [PatImage], [Extent1].[HospitalId] AS [HospitalId], [Extent1].[SysFlag] AS [SysFlag], [Extent1].[HisPatId] AS [HisPatId], [Extent1].[HisVerId] AS [HisVerId], [Extent1].[ProfessionId] AS [ProfessionId], [Extent1].[BirthProvinceId] AS [BirthProvinceId], [Extent1].[BirthStateId] AS [BirthStateId], [Extent1].[BirthCountyId] AS [BirthCountyId], [Extent1].[BirthAddress] AS [BirthAddress], [Extent1].[Zip] AS [Zip], [Extent1].[BirthZip] AS [BirthZip], [Extent1].[Password] AS [Password], [Extent1].[CreditLine] AS [CreditLine], [Extent1].[Enterprise] AS [Enterprise], [Extent1].[ABOBloodTypeId] AS [ABOBloodTypeId], [Extent1].[RHBloodTypeFlag] AS [RHBloodTypeFlag], [Extent1].[ObstetricsNo] AS [ObstetricsNo], [Extent1].[RegionFlag] AS [RegionFlag], [Extent1].[NativePlaceProvinceId] AS [NativePlaceProvinceId], [Extent1].[NativePlaceStateId] AS [NativePlaceStateId], [Extent1].[NativePlaceCountyId] AS [NativePlaceCountyId], [Extent1].[EnterpriseZip] AS [EnterpriseZip], [Extent1].[EnterprisePhone] AS [EnterprisePhone], [Extent1].[Contactman] AS [Contactman], [Extent1].[ContactRelationshipId] AS [ContactRelationshipId], [Extent1].[ContactPhone] AS [ContactPhone], [Extent1].[ContactAdress] AS [ContactAdress], [Extent1].[NativePlace] AS [NativePlace], [Extent1].[AnmeldenProvinceId] AS [AnmeldenProvinceId], [Extent1].[AnmeldenStateId] AS [AnmeldenStateId], [Extent1].[AnmeldenCountyId] AS [AnmeldenCountyId], [Extent1].[AnmeldenAddress] AS [AnmeldenAddress], [Extent1].[AnmeldenZip] AS [AnmeldenZip], [Extent1].[CrippleFlag] AS [CrippleFlag], [Extent1].[CrippleNo] AS [CrippleNo], [Extent1].[Height] AS [Height], [Extent1].[VillageId] AS [VillageId], [Extent1].[BirthVillageId] AS [BirthVillageId], [Extent1].[NativePlaceVillageId] AS [NativePlaceVillageId], [Extent1].[AnmeldenVillageId] AS [AnmeldenVillageId], [Extent1].[NullSfzhReason] AS [NullSfzhReason], [Extent1].[ContactIdentityKindId] AS [ContactIdentityKindId], [Extent1].[ContactIdentityNo] AS [ContactIdentityNo], [Extent1].[Guardianman] AS [Guardianman], [Extent1].[GuardianRelationshipId] AS [GuardianRelationshipId], [Extent1].[GuardianPhone] AS [GuardianPhone], [Extent1].[GuardianAddress] AS [GuardianAddress], [Extent1].[GuardianIdentityNo] AS [GuardianIdentityNo], [Extent1].[EnterpriseAddress] AS [EnterpriseAddress] FROM [Common].[Patient] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Id] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:05 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustPDS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>16392 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:05 Message: SELECT TOP (1) [Extent1].[Xh] AS [Xh], [Extent1].[PatId] AS [PatId], [Extent1].[PatName] AS [PatName], [Extent1].[YBId] AS [YBId], [Extent1].[CredenceXh] AS [CredenceXh], [Extent1].[RegFlag] AS [RegFlag], [Extent1].[DeptId] AS [DeptId], [Extent1].[RegDate] AS [RegDate], [Extent1].[ReturnVisitFlag] AS [ReturnVisitFlag], [Extent1].[PreRegFlag] AS [PreRegFlag], [Extent1].[BookingXh] AS [BookingXh], [Extent1].[RegKindId] AS [RegKindId], [Extent1].[StaffId] AS [StaffId], [Extent1].[CreatedDate] AS [CreatedDate], [Extent1].[FeeFlag] AS [FeeFlag], [Extent1].[RegId] AS [RegId], [Extent1].[RegName] AS [RegName], [Extent1].[RegDoctorId] AS [RegDoctorId], [Extent1].[RegTimeFlag] AS [RegTimeFlag], [Extent1].[VisitFlag] AS [VisitFlag], [Extent1].[DoctorId1] AS [DoctorId1], [Extent1].[DoctorId2] AS [DoctorId2], [Extent1].[CreditLine] AS [CreditLine], [Extent1].[HomeBedXh] AS [HomeBedXh], [Extent1].[HisVisitNo] AS [HisVisitNo], [Extent1].[AnmeldenProvinceId] AS [AnmeldenProvinceId], [Extent1].[AnmeldenStateId] AS [AnmeldenStateId], [Extent1].[AnmeldenCountyId] AS [AnmeldenCountyId], [Extent1].[AnmeldenAddress] AS [AnmeldenAddress], [Extent1].[AnmeldenZip] AS [AnmeldenZip], [Extent1].[WorkingUnit] AS [WorkingUnit], [Extent1].[WorkingZip] AS [WorkingZip], [Extent1].[WorkingPhone] AS [WorkingPhone], [Extent1].[ReturnAuditFlag] AS [ReturnAuditFlag], [Extent1].[IndexNumber] AS [IndexNumber], [Extent1].[CardKindId] AS [CardKindId], [Extent1].[CardNo] AS [CardNo], [Extent1].[DisplayCardNo] AS [DisplayCardNo], [Extent1].[ZoneId] AS [ZoneId], [Extent1].[EmergencyFlag] AS [EmergencyFlag], [Extent1].[SelfRegister] AS [SelfRegister], [Extent1].[DiseaseId] AS [DiseaseId], [Extent1].[PredictVisitTime] AS [PredictVisitTime], [Extent1].[SerialFlag] AS [SerialFlag], [Extent1].[SpaceRegFlag] AS [SpaceRegFlag], [Extent1].[OverFlag] AS [OverFlag], [Extent1].[RescueCarFlag] AS [RescueCarFlag], [Extent1].[DoctorTime1] AS [DoctorTime1], [Extent1].[DoctorTime2] AS [DoctorTime2], [Extent1].[PatLogXh] AS [PatLogXh], [Extent1].[LastSignTime] AS [LastSignTime] FROM [OP].[Register] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Xh] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:05 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustPDS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=OPApp;uid=sa;>>1101 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:05 Message: SELECT [Extent1].[Xh] AS [Xh], [Extent1].[RegXh] AS [RegXh], [Extent1].[VisitDate] AS [VisitDate], [Extent1].[PatId] AS [PatId], [Extent1].[YBId] AS [YBId], [Extent1].[CredenceXh] AS [CredenceXh], [Extent1].[RecipeName] AS [RecipeName], [Extent1].[RecipeNum] AS [RecipeNum], [Extent1].[RecipeKindId] AS [RecipeKindId], [Extent1].[DoctorId] AS [DoctorId], [Extent1].[DoctorDatetime] AS [DoctorDatetime], [Extent1].[DoctorRecipeNo] AS [DoctorRecipeNo], [Extent1].[DoctorDept] AS [DoctorDept], [Extent1].[ValidFlag] AS [ValidFlag], [Extent1].[ExeDept] AS [ExeDept], [Extent1].[ExeDate] AS [ExeDate], [Extent1].[ExeFlag] AS [ExeFlag], [Extent1].[ExeStaffId] AS [ExeStaffId], [Extent1].[MessageFlag] AS [MessageFlag], [Extent1].[FeeFlag] AS [FeeFlag], [Extent1].[FeeDate] AS [FeeDate], [Extent1].[StaffId] AS [StaffId], [Extent1].[MessageDate] AS [MessageDate], [Extent1].[ETOrderXh] AS [ETOrderXh], [Extent1].[OriginFlag] AS [OriginFlag], [Extent1].[DiseaseFlag] AS [DiseaseFlag], [Extent1].[ReturnFlag] AS [ReturnFlag], [Extent1].[ReturnReason] AS [ReturnReason], [Extent1].[Memo] AS [Memo], [Extent1].[RecipeFlag] AS [RecipeFlag], [Extent1].[RecipeSerialNo] AS [RecipeSerialNo], [Extent1].[PrintFlag] AS [PrintFlag], [Extent1].[PrintDate] AS [PrintDate], [Extent1].[FYWinId] AS [FYWinId], [Extent1].[FYWinName] AS [FYWinName], [Extent1].[MedicalGuidance] AS [MedicalGuidance], [Extent1].[TreatmentScopeFlag] AS [TreatmentScopeFlag], [Extent1].[AttorneysName] AS [AttorneysName], [Extent1].[AttorneysPhone] AS [AttorneysPhone], [Extent1].[AttorneySfzh] AS [AttorneySfzh], [Extent1].[RelatedRecipeXh] AS [RelatedRecipeXh], [Extent1].[OperationRequestXh] AS [OperationRequestXh], [Extent1].[GenerationFriedFlag] AS [GenerationFriedFlag], [Extent1].[GenerationFriedNum] AS [GenerationFriedNum], [Extent1].[RecipeNumPerDay] AS [RecipeNumPerDay], [Extent1].[ModifiedDate] AS [ModifiedDate], [Extent1].[UsageId] AS [UsageId], [Extent1].[PrepayFlag] AS [PrepayFlag], [Extent1].[ConfirmFlag] AS [ConfirmFlag], [Extent1].[SourceXh] AS [SourceXh], [Extent1].[SourceKind] AS [SourceKind], [Extent1].[ZQNum] AS [ZQNum], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[ValidUsableFlag] AS [ValidUsableFlag], [Extent1].[SyncSignNo] AS [SyncSignNo], [Extent1].[ReturnStaffId] AS [ReturnStaffId], [Extent1].[ReturnTime] AS [ReturnTime], [Extent1].[DoctorCAFlag] AS [DoctorCAFlag], [Extent1].[AddressXh] AS [AddressXh], [Extent1].[DecoctFlag] AS [DecoctFlag], [Extent1].[FixTemplateName] AS [FixTemplateName] FROM [OP].[Recipe] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[RegXh] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:05 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustPDS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=OPApp;uid=sa;>>1101 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:05 Message: SELECT [Extent1].[ObjectId] AS [ObjectId], [Extent1].[Name] AS [Name], [Extent1].[EntityType] AS [EntityType], [Extent1].[EntitySetName] AS [EntitySetName], [Extent1].[Description] AS [Description], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[ReleatedFlag] AS [ReleatedFlag], [Extent1].[ReleatedObjectId] AS [ReleatedObjectId], [Extent1].[ReleatedKeyExpress] AS [ReleatedKeyExpress] FROM [Common].[BaseDataLogConfig] AS [Extent1] WITH (NOLOCK) WHERE (0 = [Extent1].[DisableFlag]) AND ([Extent1].[ReleatedFlag] IN (cast(0 as smallint), cast(1 as smallint))) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:05 Message: INSERT [OP].[Recipe]([Xh], [RegXh], [VisitDate], [PatId], [YBId], [CredenceXh], [RecipeName], [RecipeNum], [RecipeKindId], [OriginFlag], [StaffId], [DoctorId], [DoctorDatetime], [DoctorRecipeNo], [DoctorDept], [ValidFlag], [ExeDept], [ExeDate], [ExeFlag], [ExeStaffId], [FeeFlag], [FeeDate], [MessageFlag], [MessageDate], [ETOrderXh], [DiseaseFlag], [ReturnFlag], [ReturnReason], [RecipeFlag], [RecipeSerialNo], [PrintFlag], [PrintDate], [FYWinId], [FYWinName], [MedicalGuidance], [TreatmentScopeFlag], [AttorneysName], [AttorneysPhone], [AttorneySfzh], [RelatedRecipeXh], [OperationRequestXh], [GenerationFriedFlag], [GenerationFriedNum], [RecipeNumPerDay], [UsageId], [PrepayFlag], [ConfirmFlag], [SourceXh], [SourceKind], [ModifiedDate], [Memo], [ZQNum], [DisableFlag], [ValidUsableFlag], [SyncSignNo], [ReturnStaffId], [ReturnTime], [DoctorCAFlag], [AddressXh], [DecoctFlag], [FixTemplateName]) VALUES (@0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10, @11, @12, @13, @14, @15, @16, NULL, @17, NULL, @18, @19, @20, NULL, NULL, NULL, NULL, NULL, @21, NULL, @22, NULL, NULL, NULL, NULL, @23, NULL, NULL, NULL, NULL, NULL, @24, @25, NULL, NULL, @26, @27, NULL, NULL, @28, NULL, NULL, @29, @30, NULL, NULL, NULL, NULL, NULL, NULL, NULL) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:05 Message: INSERT [OP].[RecipeData]([Xh], [GroupXh], [RecipeXh], [Idm], [Name], [WarehouseId], [ItemSpec], [DoseUnit], [DoseRatio], [YKRatio], [MinUnit], [DoseQuantity], [MinQuantity], [TotalQuantity], [OPUnit], [OPRatio], [Days], [FreqId], [FreqName], [UsageId], [UsageName], [StartDay], [ListPrice], [Money], [JJPrice], [SelfProvidedFlag], [ValidFlag], [ApproveFlag], [Prefix], [RecFlag], [PassWarn], [YBAuditFail], [RemarkValue], [ProductName], [DiseaseFlag], [TreatmentScopeFlag], [ConfirmFlag], [CanReturnCount], [ReturnQuantity], [SourceXh], [SourceKind], [Remark], [FeeFlag], [FeeDate], [ValidUsableFlag], [AllergyPositiveSetFlag], [SkinTestFlag], [SkinTestResult], [SkinTestResultTime]) VALUES (@0, @1, @2, @3, @4, NULL, @5, @6, @7, @8, @9, @10, @11, @12, @13, @14, @15, @16, @17, @18, @19, @20, @21, @22, @23, @24, @25, @26, @27, @28, @29, @30, NULL, NULL, NULL, @31, @32, NULL, NULL, NULL, NULL, NULL, @33, @34, @35, @36, NULL, NULL, NULL) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:05 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Py] AS [Py], [Extent1].[Wb] AS [Wb], [Extent1].[Memo] AS [Memo], [Extent1].[TimeSlotIds] AS [TimeSlotIds], [Extent1].[DrugPrepareFlagForOP] AS [DrugPrepareFlagForOP], [Extent1].[DrugPrepareFlagForIP] AS [DrugPrepareFlagForIP], [Extent1].[PharamcyFlag] AS [PharamcyFlag], [Extent1].[DispenseFlagForIP] AS [DispenseFlagForIP] FROM [Drug].[Pharmacy] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Id] IN ('Y011') ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:05 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[DeptId] AS [DeptId], [Extent1].[BindedWorkstation] AS [BindedWorkstation], [Extent1].[BindedWorkstationName] AS [BindedWorkstationName], [Extent1].[VisitDate] AS [VisitDate], [Extent1].[Memo] AS [Memo], [Extent1].[CloseFlag] AS [CloseFlag], [Extent1].[WinFlag] AS [WinFlag], [Extent1].[DispenseFlag] AS [DispenseFlag], [Extent1].[ExpertFlag] AS [ExpertFlag], [Extent1].[PrepareStaffId] AS [PrepareStaffId], [Extent1].[SendStaffId] AS [SendStaffId], [Extent1].[CheckStaffId] AS [CheckStaffId], [Extent1].[DisplayText] AS [DisplayText], [Extent1].[QueuedNo] AS [QueuedNo], [Extent1].[RemainningNum] AS [RemainningNum], [Extent1].[TimeStamp] AS [TimeStamp] FROM [Common].[FYWin] AS [Extent1] WITH (NOLOCK) WHERE 0 = [Extent1].[DispenseFlag] ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:05 Message: SELECT TOP (1) [Extent1].[PatId] AS [PatId], [Extent1].[RecipeXh] AS [RecipeXh], [Extent1].[Memo] AS [Memo] FROM [Drug].[FYWinRecipeQueue] AS [Extent1] WITH (NOLOCK) WHERE ([Extent1].[PatId] = @p__linq__0) AND ([Extent1].[RecipeXh] = @p__linq__1) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:05 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustPDS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=DrugApp;uid=sa;>>16392 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:05 Message: SELECT [Extent1].[Idm] AS [Idm], [Extent1].[DrugId] AS [DrugId], [Extent1].[DrugBasicName] AS [DrugBasicName], [Extent1].[Name] AS [Name], [Extent1].[Py] AS [Py], [Extent1].[Wb] AS [Wb], [Extent1].[RegisterNo] AS [RegisterNo], [Extent1].[Spec] AS [Spec], [Extent1].[DrugKindId] AS [DrugKindId], [Extent1].[DrugFormId] AS [DrugFormId], [Extent1].[ManuId] AS [ManuId], [Extent1].[ManuName] AS [ManuName], [Extent1].[ValidMonth] AS [ValidMonth], [Extent1].[PriceLS] AS [PriceLS], [Extent1].[PricePF] AS [PricePF], [Extent1].[PriceJJ] AS [PriceJJ], [Extent1].[UpperPrice] AS [UpperPrice], [Extent1].[MinUnit] AS [MinUnit], [Extent1].[YKUnit] AS [YKUnit], [Extent1].[YKRatio] AS [YKRatio], [Extent1].[JHUnit] AS [JHUnit], [Extent1].[JHRatio] AS [JHRatio], [Extent1].[ControlFlag] AS [ControlFlag], [Extent1].[LimitFlag] AS [LimitFlag], [Extent1].[GZFlag] AS [GZFlag], [Extent1].[KLRatio] AS [KLRatio], [Extent1].[SJZJFlag] AS [SJZJFlag], [Extent1].[DrugImage] AS [DrugImage], [Extent1].[ZMLBId] AS [ZMLBId], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[LJLYFlag] AS [LJLYFlag], [Extent1].[AccId] AS [AccId], [Extent1].[PackageFlag] AS [PackageFlag], [Extent1].[OPUnit] AS [OPUnit], [Extent1].[OPRatio] AS [OPRatio], [Extent1].[IPUnit] AS [IPUnit], [Extent1].[IPRatio] AS [IPRatio], [Extent1].[SkinTestFlag] AS [SkinTestFlag], [Extent1].[PrintId] AS [PrintId], [Extent1].[SkinSendFlag] AS [SkinSendFlag], CAST( [Extent1].[SpecialFlag] AS smallint) AS [C1], [Extent1].[ManuFromFlag] AS [ManuFromFlag], [Extent1].[DDDId] AS [DDDId], [Extent1].[DDDDoseRatio] AS [DDDDoseRatio], [Extent1].[SkinTestValidDay] AS [SkinTestValidDay], [Extent1].[SysBitFlag] AS [SysBitFlag], [Extent1].[OPPartialSelfFlag] AS [OPPartialSelfFlag], [Extent1].[IPPartialSelfFlag] AS [IPPartialSelfFlag], [Extent1].[DistributorXh] AS [DistributorXh], [Extent1].[DistributorName] AS [DistributorName], [Extent1].[YBControlFlag] AS [YBControlFlag], [Extent1].[SubAccItemId] AS [SubAccItemId], [Extent1].[LossRatio] AS [LossRatio], [Extent1].[DoseUnit] AS [DoseUnit], [Extent1].[DrugCode] AS [DrugCode], [Extent1].[CategoryFlag] AS [CategoryFlag], [Extent1].[SpecialNote] AS [SpecialNote], [Extent1].[DoseRatio] AS [DoseRatio], [Extent1].[AMSIdm] AS [AMSIdm], [Extent1].[MinBitFlag] AS [MinBitFlag], [Extent1].[OriginalSpec] AS [OriginalSpec], [Extent1].[CustomKind] AS [CustomKind], [Extent1].[RefId] AS [RefId], [Extent1].[EKUnit] AS [EKUnit], [Extent1].[EKRatio] AS [EKRatio], [Extent1].[BidFlag] AS [BidFlag], [Extent1].[BidNo] AS [BidNo], [Extent1].[BidUnit] AS [BidUnit], [Extent1].[RegisterNoSource] AS [RegisterNoSource], [Extent1].[StoreDescription] AS [StoreDescription], [Extent1].[DrugCode1] AS [DrugCode1], [Extent1].[DrugCode2] AS [DrugCode2], [Extent1].[RegisterNoValidDate] AS [RegisterNoValidDate], [Extent1].[CommonDrugFlag] AS [CommonDrugFlag], [Extent1].[ProductName] AS [ProductName], [Extent1].[PriceLSOriginal] AS [PriceLSOriginal], [Extent1].[FullPronunciation] AS [FullPronunciation], [Extent1].[FullPronunciation1] AS [FullPronunciation1], [Extent1].[DrugVarietiesFlag] AS [DrugVarietiesFlag], [Extent1].[RecipePrintingFlag] AS [RecipePrintingFlag], [Extent1].[ZYLJLYFlag] AS [ZYLJLYFlag], [Extent1].[UnPackageFlagForIP] AS [UnPackageFlagForIP], [Extent1].[ValidMonthLowLimit] AS [ValidMonthLowLimit], [Extent1].[RowStamp] AS [RowStamp], [Extent1].[OutHospitalFlag] AS [OutHospitalFlag], [Extent1].[StdCode] AS [StdCode], [Extent1].[StdName] AS [StdName], [Extent1].[TempProcFlag] AS [TempProcFlag] FROM [Common].[Drug] AS [Extent1] WITH (NOLOCK) INNER JOIN [Common].[IdXhJoin] AS [Extent2] WITH (NOLOCK) ON [Extent1].[Idm] = [Extent2].[JoinXh] WHERE [Extent2].[PId] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:05 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustPDS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>48 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:05 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[SurName] AS [SurName], [Extent1].[GivenName] AS [GivenName], [Extent1].[Py] AS [Py], [Extent1].[Wb] AS [Wb], [Extent1].[OPBLH] AS [OPBLH], [Extent1].[IPBLH] AS [IPBLH], [Extent1].[SexId] AS [SexId], [Extent1].[Birthday] AS [Birthday], [Extent1].[Weight] AS [Weight], [Extent1].[IdentityKindId] AS [IdentityKindId], [Extent1].[Sfzh] AS [Sfzh], [Extent1].[MaritalStatusId] AS [MaritalStatusId], [Extent1].[CountryId] AS [CountryId], [Extent1].[NationId] AS [NationId], [Extent1].[ProvinceId] AS [ProvinceId], [Extent1].[StateId] AS [StateId], [Extent1].[CountyId] AS [CountyId], [Extent1].[Address] AS [Address], [Extent1].[Phone] AS [Phone], [Extent1].[Mobile] AS [Mobile], [Extent1].[Mail] AS [Mail], [Extent1].[StaffId] AS [StaffId], [Extent1].[ModifiedDate] AS [ModifiedDate], [Extent1].[Memo] AS [Memo], [Extent1].[PatImage] AS [PatImage], [Extent1].[HospitalId] AS [HospitalId], [Extent1].[SysFlag] AS [SysFlag], [Extent1].[HisPatId] AS [HisPatId], [Extent1].[HisVerId] AS [HisVerId], [Extent1].[ProfessionId] AS [ProfessionId], [Extent1].[BirthProvinceId] AS [BirthProvinceId], [Extent1].[BirthStateId] AS [BirthStateId], [Extent1].[BirthCountyId] AS [BirthCountyId], [Extent1].[BirthAddress] AS [BirthAddress], [Extent1].[Zip] AS [Zip], [Extent1].[BirthZip] AS [BirthZip], [Extent1].[Password] AS [Password], [Extent1].[CreditLine] AS [CreditLine], [Extent1].[Enterprise] AS [Enterprise], [Extent1].[ABOBloodTypeId] AS [ABOBloodTypeId], [Extent1].[RHBloodTypeFlag] AS [RHBloodTypeFlag], [Extent1].[ObstetricsNo] AS [ObstetricsNo], [Extent1].[RegionFlag] AS [RegionFlag], [Extent1].[NativePlaceProvinceId] AS [NativePlaceProvinceId], [Extent1].[NativePlaceStateId] AS [NativePlaceStateId], [Extent1].[NativePlaceCountyId] AS [NativePlaceCountyId], [Extent1].[EnterpriseZip] AS [EnterpriseZip], [Extent1].[EnterprisePhone] AS [EnterprisePhone], [Extent1].[Contactman] AS [Contactman], [Extent1].[ContactRelationshipId] AS [ContactRelationshipId], [Extent1].[ContactPhone] AS [ContactPhone], [Extent1].[ContactAdress] AS [ContactAdress], [Extent1].[NativePlace] AS [NativePlace], [Extent1].[AnmeldenProvinceId] AS [AnmeldenProvinceId], [Extent1].[AnmeldenStateId] AS [AnmeldenStateId], [Extent1].[AnmeldenCountyId] AS [AnmeldenCountyId], [Extent1].[AnmeldenAddress] AS [AnmeldenAddress], [Extent1].[AnmeldenZip] AS [AnmeldenZip], [Extent1].[CrippleFlag] AS [CrippleFlag], [Extent1].[CrippleNo] AS [CrippleNo], [Extent1].[Height] AS [Height], [Extent1].[VillageId] AS [VillageId], [Extent1].[BirthVillageId] AS [BirthVillageId], [Extent1].[NativePlaceVillageId] AS [NativePlaceVillageId], [Extent1].[AnmeldenVillageId] AS [AnmeldenVillageId], [Extent1].[NullSfzhReason] AS [NullSfzhReason], [Extent1].[ContactIdentityKindId] AS [ContactIdentityKindId], [Extent1].[ContactIdentityNo] AS [ContactIdentityNo], [Extent1].[Guardianman] AS [Guardianman], [Extent1].[GuardianRelationshipId] AS [GuardianRelationshipId], [Extent1].[GuardianPhone] AS [GuardianPhone], [Extent1].[GuardianAddress] AS [GuardianAddress], [Extent1].[GuardianIdentityNo] AS [GuardianIdentityNo], [Extent1].[EnterpriseAddress] AS [EnterpriseAddress] FROM [Common].[Patient] AS [Extent1] WITH (NOLOCK) INNER JOIN [Common].[IdXhJoin] AS [Extent2] WITH (NOLOCK) ON [Extent1].[Id] = [Extent2].[JoinXh] WHERE [Extent2].[PId] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:05 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustPDS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>50 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:05 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[ParentId] AS [ParentId], [Extent1].[HospitalId] AS [HospitalId], [Extent1].[Name] AS [Name], [Extent1].[Py] AS [Py], [Extent1].[Wb] AS [Wb], [Extent1].[LocationId] AS [LocationId], [Extent1].[DeptFlag] AS [DeptFlag], [Extent1].[DeptKindId] AS [DeptKindId], [Extent1].[SamplingFlag] AS [SamplingFlag], [Extent1].[EnvironmentFlag] AS [EnvironmentFlag], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[Memo] AS [Memo], [Extent1].[TimeStamp] AS [TimeStamp], [Extent1].[CheckDeptFlag] AS [CheckDeptFlag], [Extent1].[Abbreviation] AS [Abbreviation] FROM [Common].[Dept] AS [Extent1] WITH (NOLOCK) INNER JOIN [Common].[IdXhJoin] AS [Extent2] WITH (NOLOCK) ON [Extent1].[Id] = [Extent2].[JoinId] WHERE [Extent2].[PId] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:05 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustPDS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>52 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:05 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Py] AS [Py], [Extent1].[Wb] AS [Wb], [Extent1].[Birthday] AS [Birthday], [Extent1].[SexId] AS [SexId], [Extent1].[MaritalStatusId] AS [MaritalStatusId], [Extent1].[Sfzh] AS [Sfzh], [Extent1].[TechTitleId] AS [TechTitleId], [Extent1].[DegreeId] AS [DegreeId], [Extent1].[InnerPhone] AS [InnerPhone], [Extent1].[Mobile] AS [Mobile], [Extent1].[Mail] AS [Mail], [Extent1].[DefaultDeptId] AS [DefaultDeptId], [Extent1].[DefaultWardId] AS [DefaultWardId], [Extent1].[Depts] AS [Depts], [Extent1].[Wards] AS [Wards], [Extent1].[StaffFlag] AS [StaffFlag], [Extent1].[DataMaintainFlag] AS [DataMaintainFlag], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[YBStaffId] AS [YBStaffId], [Extent1].[YBDeptId] AS [YBDeptId], [Extent1].[HRStaffId] AS [HRStaffId], [Extent1].[StaffDesc] AS [StaffDesc], [Extent1].[Memo] AS [Memo], [Extent1].[TimeStamp] AS [TimeStamp], [Extent1].[CAOpenId] AS [CAOpenId], [Extent1].[StdCode] AS [StdCode], [Extent1].[StdName] AS [StdName] FROM [Common].[Staff] AS [Extent1] WITH (NOLOCK) INNER JOIN [Common].[IdXhJoin] AS [Extent2] WITH (NOLOCK) ON [Extent1].[Id] = [Extent2].[JoinId] WHERE [Extent2].[PId] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:05 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustPDS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>54 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:05 Message: SELECT TOP (1) [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Description] AS [Description], [Extent1].[Value] AS [Value], [Extent1].[RefValue] AS [RefValue], [Extent1].[DataType] AS [DataType], [Extent1].[CanSelect] AS [CanSelect], [Extent1].[SelectSource] AS [SelectSource], [Extent1].[GroupId] AS [GroupId], [Extent1].[Editor] AS [Editor], [Extent1].[EditableFlag] AS [EditableFlag], [Extent1].[ModifyStaffId] AS [ModifyStaffId], [Extent1].[ModifyTime] AS [ModifyTime], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[TimeStamp] AS [TimeStamp] FROM [Common].[Setting] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Id] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:05 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>OPPharmacySetting ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:05 Message: SELECT TOP (1) [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Description] AS [Description], [Extent1].[Value] AS [Value], [Extent1].[RefValue] AS [RefValue], [Extent1].[DataType] AS [DataType], [Extent1].[CanSelect] AS [CanSelect], [Extent1].[SelectSource] AS [SelectSource], [Extent1].[GroupId] AS [GroupId], [Extent1].[Editor] AS [Editor], [Extent1].[EditableFlag] AS [EditableFlag], [Extent1].[ModifyStaffId] AS [ModifyStaffId], [Extent1].[ModifyTime] AS [ModifyTime], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[TimeStamp] AS [TimeStamp] FROM [Common].[Setting] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Id] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:05 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>DrugPublicConfig ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:05 Message: SELECT [Extent1].[Xh] AS [Xh], [Extent1].[SendRequestXh] AS [SendRequestXh], [Extent1].[RegXh] AS [RegXh], [Extent1].[PatId] AS [PatId], [Extent1].[PatName] AS [PatName], [Extent1].[RecipeXh] AS [RecipeXh], [Extent1].[SendPharmacyId] AS [SendPharmacyId], [Extent1].[SendWinId] AS [SendWinId], [Extent1].[RecievePharmacyId] AS [RecievePharmacyId], [Extent1].[RecieveWinId] AS [RecieveWinId], [Extent1].[ReciveStaffId] AS [ReciveStaffId], [Extent1].[ReciveDate] AS [ReciveDate], [Extent1].[FeeDate] AS [FeeDate], [Extent1].[FeeStaffId] AS [FeeStaffId], [Extent1].[ReturnReason] AS [ReturnReason], [Extent1].[RecFlag] AS [RecFlag], [Extent1].[Memo] AS [Memo], [Extent1].[JSSJH] AS [JSSJH] FROM [Drug].[OPDrugReturnRequest] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[RecipeXh] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:05 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustPDS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=DrugApp;uid=sa;>>629 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:05 Message: SELECT [Extent1].[Xh] AS [Xh], [Extent1].[MessageId] AS [MessageId], [Extent1].[SenderlXh] AS [SenderlXh], [Extent1].[SenderDept] AS [SenderDept], [Extent1].[PharmacyId] AS [PharmacyId], [Extent1].[JSSJH] AS [JSSJH], [Extent1].[PatId] AS [PatId], [Extent1].[RegXh] AS [RegXh], [Extent1].[RecipeXh] AS [RecipeXh], [Extent1].[RecipeKindId] AS [RecipeKindId], [Extent1].[PatientName] AS [PatientName], [Extent1].[Age] AS [Age], [Extent1].[Sex] AS [Sex], [Extent1].[KFStaffId] AS [KFStaffId], [Extent1].[KFStaffName] AS [KFStaffName], [Extent1].[KFDeptId] AS [KFDeptId], [Extent1].[KFDeptName] AS [KFDeptName], [Extent1].[KFDate] AS [KFDate], [Extent1].[RecipeTS] AS [RecipeTS], [Extent1].[SFWin] AS [SFWin], [Extent1].[PYWin] AS [PYWin], [Extent1].[FYWin] AS [FYWin], [Extent1].[ReceivedDate] AS [ReceivedDate], [Extent1].[RequestSendDate] AS [RequestSendDate], [Extent1].[PrepareStaffId] AS [PrepareStaffId], [Extent1].[PrepareDate] AS [PrepareDate], [Extent1].[SendStaffId] AS [SendStaffId], [Extent1].[SendDate] AS [SendDate], [Extent1].[RecFlag] AS [RecFlag], [Extent1].[TXh] AS [TXh], [Extent1].[OriginFlag] AS [OriginFlag], [Extent1].[IndexNumber] AS [IndexNumber], [Extent1].[WaitFlag] AS [WaitFlag], [Extent1].[SFStaffId] AS [SFStaffId], [Extent1].[SendSerialNo] AS [SendSerialNo], [Extent1].[PrintFlag] AS [PrintFlag], [Extent1].[AutidStaffId] AS [AutidStaffId], [Extent1].[PrintDate] AS [PrintDate] FROM [Drug].[OPDrugSendRequest] AS [Extent1] WITH (NOLOCK) WHERE ([Extent1].[RecipeXh] = @p__linq__0) AND ([Extent1].[JSSJH] = @p__linq__1) AND (0 = [Extent1].[RecFlag]) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:05 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustPDS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=DrugApp;uid=sa;>>629 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:05 Message: SELECT [Extent1].[Xh] AS [Xh], [Extent1].[MessageId] AS [MessageId], [Extent1].[SenderlXh] AS [SenderlXh], [Extent1].[SenderDept] AS [SenderDept], [Extent1].[PharmacyId] AS [PharmacyId], [Extent1].[JSSJH] AS [JSSJH], [Extent1].[PatId] AS [PatId], [Extent1].[RegXh] AS [RegXh], [Extent1].[RecipeXh] AS [RecipeXh], [Extent1].[RecipeKindId] AS [RecipeKindId], [Extent1].[PatientName] AS [PatientName], [Extent1].[Age] AS [Age], [Extent1].[Sex] AS [Sex], [Extent1].[KFStaffId] AS [KFStaffId], [Extent1].[KFStaffName] AS [KFStaffName], [Extent1].[KFDeptId] AS [KFDeptId], [Extent1].[KFDeptName] AS [KFDeptName], [Extent1].[KFDate] AS [KFDate], [Extent1].[RecipeTS] AS [RecipeTS], [Extent1].[SFWin] AS [SFWin], [Extent1].[PYWin] AS [PYWin], [Extent1].[FYWin] AS [FYWin], [Extent1].[ReceivedDate] AS [ReceivedDate], [Extent1].[RequestSendDate] AS [RequestSendDate], [Extent1].[PrepareStaffId] AS [PrepareStaffId], [Extent1].[PrepareDate] AS [PrepareDate], [Extent1].[SendStaffId] AS [SendStaffId], [Extent1].[SendDate] AS [SendDate], [Extent1].[RecFlag] AS [RecFlag], [Extent1].[TXh] AS [TXh], [Extent1].[OriginFlag] AS [OriginFlag], [Extent1].[IndexNumber] AS [IndexNumber], [Extent1].[WaitFlag] AS [WaitFlag], [Extent1].[SFStaffId] AS [SFStaffId], [Extent1].[SendSerialNo] AS [SendSerialNo], [Extent1].[PrintFlag] AS [PrintFlag], [Extent1].[AutidStaffId] AS [AutidStaffId], [Extent1].[PrintDate] AS [PrintDate] FROM [Drug].[OPDrugSendRequest] AS [Extent1] WITH (NOLOCK) WHERE ([Extent1].[RecipeXh] = @p__linq__0) AND (([Extent1].[JSSJH] IS NULL) OR ((LEN([Extent1].[JSSJH])) = 0)) AND (-1 = [Extent1].[RecFlag]) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:05 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustPDS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=DrugApp;uid=sa;>>629 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: SELECT TOP (1) [Extent1].[Xh] AS [Xh], [Extent1].[RegXh] AS [RegXh], [Extent1].[VisitDate] AS [VisitDate], [Extent1].[PatId] AS [PatId], [Extent1].[YBId] AS [YBId], [Extent1].[CredenceXh] AS [CredenceXh], [Extent1].[RecipeName] AS [RecipeName], [Extent1].[RecipeNum] AS [RecipeNum], [Extent1].[RecipeKindId] AS [RecipeKindId], [Extent1].[DoctorId] AS [DoctorId], [Extent1].[DoctorDatetime] AS [DoctorDatetime], [Extent1].[DoctorRecipeNo] AS [DoctorRecipeNo], [Extent1].[DoctorDept] AS [DoctorDept], [Extent1].[ValidFlag] AS [ValidFlag], [Extent1].[ExeDept] AS [ExeDept], [Extent1].[ExeDate] AS [ExeDate], [Extent1].[ExeFlag] AS [ExeFlag], [Extent1].[ExeStaffId] AS [ExeStaffId], [Extent1].[MessageFlag] AS [MessageFlag], [Extent1].[FeeFlag] AS [FeeFlag], [Extent1].[FeeDate] AS [FeeDate], [Extent1].[StaffId] AS [StaffId], [Extent1].[MessageDate] AS [MessageDate], [Extent1].[ETOrderXh] AS [ETOrderXh], [Extent1].[OriginFlag] AS [OriginFlag], [Extent1].[DiseaseFlag] AS [DiseaseFlag], [Extent1].[ReturnFlag] AS [ReturnFlag], [Extent1].[ReturnReason] AS [ReturnReason], [Extent1].[Memo] AS [Memo], [Extent1].[RecipeFlag] AS [RecipeFlag], [Extent1].[RecipeSerialNo] AS [RecipeSerialNo], [Extent1].[PrintFlag] AS [PrintFlag], [Extent1].[PrintDate] AS [PrintDate], [Extent1].[FYWinId] AS [FYWinId], [Extent1].[FYWinName] AS [FYWinName], [Extent1].[MedicalGuidance] AS [MedicalGuidance], [Extent1].[TreatmentScopeFlag] AS [TreatmentScopeFlag], [Extent1].[AttorneysName] AS [AttorneysName], [Extent1].[AttorneysPhone] AS [AttorneysPhone], [Extent1].[AttorneySfzh] AS [AttorneySfzh], [Extent1].[RelatedRecipeXh] AS [RelatedRecipeXh], [Extent1].[OperationRequestXh] AS [OperationRequestXh], [Extent1].[GenerationFriedFlag] AS [GenerationFriedFlag], [Extent1].[GenerationFriedNum] AS [GenerationFriedNum], [Extent1].[RecipeNumPerDay] AS [RecipeNumPerDay], [Extent1].[ModifiedDate] AS [ModifiedDate], [Extent1].[UsageId] AS [UsageId], [Extent1].[PrepayFlag] AS [PrepayFlag], [Extent1].[ConfirmFlag] AS [ConfirmFlag], [Extent1].[SourceXh] AS [SourceXh], [Extent1].[SourceKind] AS [SourceKind], [Extent1].[ZQNum] AS [ZQNum], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[ValidUsableFlag] AS [ValidUsableFlag], [Extent1].[SyncSignNo] AS [SyncSignNo], [Extent1].[ReturnStaffId] AS [ReturnStaffId], [Extent1].[ReturnTime] AS [ReturnTime], [Extent1].[DoctorCAFlag] AS [DoctorCAFlag], [Extent1].[AddressXh] AS [AddressXh], [Extent1].[DecoctFlag] AS [DecoctFlag], [Extent1].[FixTemplateName] AS [FixTemplateName] FROM [OP].[Recipe] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Xh] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustPDS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=OPApp;uid=sa;>>629 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: UPDATE [Drug].[OPDrugSendRequest] SET [JSSJH] = @0, [SFWin] = @1, [FYWin] = @2, [RecFlag] = @3, [SFStaffId] = @4 WHERE (([Xh] = @5) AND ([RecFlag] = @6)) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: SELECT [Extent1].[Idm] AS [Idm], [Extent1].[DrugId] AS [DrugId], [Extent1].[DrugBasicName] AS [DrugBasicName], [Extent1].[Name] AS [Name], [Extent1].[Py] AS [Py], [Extent1].[Wb] AS [Wb], [Extent1].[RegisterNo] AS [RegisterNo], [Extent1].[Spec] AS [Spec], [Extent1].[DrugKindId] AS [DrugKindId], [Extent1].[DrugFormId] AS [DrugFormId], [Extent1].[ManuId] AS [ManuId], [Extent1].[ManuName] AS [ManuName], [Extent1].[ValidMonth] AS [ValidMonth], [Extent1].[PriceLS] AS [PriceLS], [Extent1].[PricePF] AS [PricePF], [Extent1].[PriceJJ] AS [PriceJJ], [Extent1].[UpperPrice] AS [UpperPrice], [Extent1].[MinUnit] AS [MinUnit], [Extent1].[YKUnit] AS [YKUnit], [Extent1].[YKRatio] AS [YKRatio], [Extent1].[JHUnit] AS [JHUnit], [Extent1].[JHRatio] AS [JHRatio], [Extent1].[ControlFlag] AS [ControlFlag], [Extent1].[LimitFlag] AS [LimitFlag], [Extent1].[GZFlag] AS [GZFlag], [Extent1].[KLRatio] AS [KLRatio], [Extent1].[SJZJFlag] AS [SJZJFlag], [Extent1].[DrugImage] AS [DrugImage], [Extent1].[ZMLBId] AS [ZMLBId], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[LJLYFlag] AS [LJLYFlag], [Extent1].[AccId] AS [AccId], [Extent1].[PackageFlag] AS [PackageFlag], [Extent1].[OPUnit] AS [OPUnit], [Extent1].[OPRatio] AS [OPRatio], [Extent1].[IPUnit] AS [IPUnit], [Extent1].[IPRatio] AS [IPRatio], [Extent1].[SkinTestFlag] AS [SkinTestFlag], [Extent1].[PrintId] AS [PrintId], [Extent1].[SkinSendFlag] AS [SkinSendFlag], CAST( [Extent1].[SpecialFlag] AS smallint) AS [C1], [Extent1].[ManuFromFlag] AS [ManuFromFlag], [Extent1].[DDDId] AS [DDDId], [Extent1].[DDDDoseRatio] AS [DDDDoseRatio], [Extent1].[SkinTestValidDay] AS [SkinTestValidDay], [Extent1].[SysBitFlag] AS [SysBitFlag], [Extent1].[OPPartialSelfFlag] AS [OPPartialSelfFlag], [Extent1].[IPPartialSelfFlag] AS [IPPartialSelfFlag], [Extent1].[DistributorXh] AS [DistributorXh], [Extent1].[DistributorName] AS [DistributorName], [Extent1].[YBControlFlag] AS [YBControlFlag], [Extent1].[SubAccItemId] AS [SubAccItemId], [Extent1].[LossRatio] AS [LossRatio], [Extent1].[DoseUnit] AS [DoseUnit], [Extent1].[DrugCode] AS [DrugCode], [Extent1].[CategoryFlag] AS [CategoryFlag], [Extent1].[SpecialNote] AS [SpecialNote], [Extent1].[DoseRatio] AS [DoseRatio], [Extent1].[AMSIdm] AS [AMSIdm], [Extent1].[MinBitFlag] AS [MinBitFlag], [Extent1].[OriginalSpec] AS [OriginalSpec], [Extent1].[CustomKind] AS [CustomKind], [Extent1].[RefId] AS [RefId], [Extent1].[EKUnit] AS [EKUnit], [Extent1].[EKRatio] AS [EKRatio], [Extent1].[BidFlag] AS [BidFlag], [Extent1].[BidNo] AS [BidNo], [Extent1].[BidUnit] AS [BidUnit], [Extent1].[RegisterNoSource] AS [RegisterNoSource], [Extent1].[StoreDescription] AS [StoreDescription], [Extent1].[DrugCode1] AS [DrugCode1], [Extent1].[DrugCode2] AS [DrugCode2], [Extent1].[RegisterNoValidDate] AS [RegisterNoValidDate], [Extent1].[CommonDrugFlag] AS [CommonDrugFlag], [Extent1].[ProductName] AS [ProductName], [Extent1].[PriceLSOriginal] AS [PriceLSOriginal], [Extent1].[FullPronunciation] AS [FullPronunciation], [Extent1].[FullPronunciation1] AS [FullPronunciation1], [Extent1].[DrugVarietiesFlag] AS [DrugVarietiesFlag], [Extent1].[RecipePrintingFlag] AS [RecipePrintingFlag], [Extent1].[ZYLJLYFlag] AS [ZYLJLYFlag], [Extent1].[UnPackageFlagForIP] AS [UnPackageFlagForIP], [Extent1].[ValidMonthLowLimit] AS [ValidMonthLowLimit], [Extent1].[RowStamp] AS [RowStamp], [Extent1].[OutHospitalFlag] AS [OutHospitalFlag], [Extent1].[StdCode] AS [StdCode], [Extent1].[StdName] AS [StdName], [Extent1].[TempProcFlag] AS [TempProcFlag] FROM [Common].[Drug] AS [Extent1] WITH (NOLOCK) INNER JOIN [Common].[IdXhJoin] AS [Extent2] WITH (NOLOCK) ON [Extent1].[Idm] = [Extent2].[JoinXh] WHERE [Extent2].[PId] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustPDS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>-9999 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[SurName] AS [SurName], [Extent1].[GivenName] AS [GivenName], [Extent1].[Py] AS [Py], [Extent1].[Wb] AS [Wb], [Extent1].[OPBLH] AS [OPBLH], [Extent1].[IPBLH] AS [IPBLH], [Extent1].[SexId] AS [SexId], [Extent1].[Birthday] AS [Birthday], [Extent1].[Weight] AS [Weight], [Extent1].[IdentityKindId] AS [IdentityKindId], [Extent1].[Sfzh] AS [Sfzh], [Extent1].[MaritalStatusId] AS [MaritalStatusId], [Extent1].[CountryId] AS [CountryId], [Extent1].[NationId] AS [NationId], [Extent1].[ProvinceId] AS [ProvinceId], [Extent1].[StateId] AS [StateId], [Extent1].[CountyId] AS [CountyId], [Extent1].[Address] AS [Address], [Extent1].[Phone] AS [Phone], [Extent1].[Mobile] AS [Mobile], [Extent1].[Mail] AS [Mail], [Extent1].[StaffId] AS [StaffId], [Extent1].[ModifiedDate] AS [ModifiedDate], [Extent1].[Memo] AS [Memo], [Extent1].[PatImage] AS [PatImage], [Extent1].[HospitalId] AS [HospitalId], [Extent1].[SysFlag] AS [SysFlag], [Extent1].[HisPatId] AS [HisPatId], [Extent1].[HisVerId] AS [HisVerId], [Extent1].[ProfessionId] AS [ProfessionId], [Extent1].[BirthProvinceId] AS [BirthProvinceId], [Extent1].[BirthStateId] AS [BirthStateId], [Extent1].[BirthCountyId] AS [BirthCountyId], [Extent1].[BirthAddress] AS [BirthAddress], [Extent1].[Zip] AS [Zip], [Extent1].[BirthZip] AS [BirthZip], [Extent1].[Password] AS [Password], [Extent1].[CreditLine] AS [CreditLine], [Extent1].[Enterprise] AS [Enterprise], [Extent1].[ABOBloodTypeId] AS [ABOBloodTypeId], [Extent1].[RHBloodTypeFlag] AS [RHBloodTypeFlag], [Extent1].[ObstetricsNo] AS [ObstetricsNo], [Extent1].[RegionFlag] AS [RegionFlag], [Extent1].[NativePlaceProvinceId] AS [NativePlaceProvinceId], [Extent1].[NativePlaceStateId] AS [NativePlaceStateId], [Extent1].[NativePlaceCountyId] AS [NativePlaceCountyId], [Extent1].[EnterpriseZip] AS [EnterpriseZip], [Extent1].[EnterprisePhone] AS [EnterprisePhone], [Extent1].[Contactman] AS [Contactman], [Extent1].[ContactRelationshipId] AS [ContactRelationshipId], [Extent1].[ContactPhone] AS [ContactPhone], [Extent1].[ContactAdress] AS [ContactAdress], [Extent1].[NativePlace] AS [NativePlace], [Extent1].[AnmeldenProvinceId] AS [AnmeldenProvinceId], [Extent1].[AnmeldenStateId] AS [AnmeldenStateId], [Extent1].[AnmeldenCountyId] AS [AnmeldenCountyId], [Extent1].[AnmeldenAddress] AS [AnmeldenAddress], [Extent1].[AnmeldenZip] AS [AnmeldenZip], [Extent1].[CrippleFlag] AS [CrippleFlag], [Extent1].[CrippleNo] AS [CrippleNo], [Extent1].[Height] AS [Height], [Extent1].[VillageId] AS [VillageId], [Extent1].[BirthVillageId] AS [BirthVillageId], [Extent1].[NativePlaceVillageId] AS [NativePlaceVillageId], [Extent1].[AnmeldenVillageId] AS [AnmeldenVillageId], [Extent1].[NullSfzhReason] AS [NullSfzhReason], [Extent1].[ContactIdentityKindId] AS [ContactIdentityKindId], [Extent1].[ContactIdentityNo] AS [ContactIdentityNo], [Extent1].[Guardianman] AS [Guardianman], [Extent1].[GuardianRelationshipId] AS [GuardianRelationshipId], [Extent1].[GuardianPhone] AS [GuardianPhone], [Extent1].[GuardianAddress] AS [GuardianAddress], [Extent1].[GuardianIdentityNo] AS [GuardianIdentityNo], [Extent1].[EnterpriseAddress] AS [EnterpriseAddress] FROM [Common].[Patient] AS [Extent1] WITH (NOLOCK) INNER JOIN [Common].[IdXhJoin] AS [Extent2] WITH (NOLOCK) ON [Extent1].[Id] = [Extent2].[JoinXh] WHERE [Extent2].[PId] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustPDS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>-9999 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[ParentId] AS [ParentId], [Extent1].[HospitalId] AS [HospitalId], [Extent1].[Name] AS [Name], [Extent1].[Py] AS [Py], [Extent1].[Wb] AS [Wb], [Extent1].[LocationId] AS [LocationId], [Extent1].[DeptFlag] AS [DeptFlag], [Extent1].[DeptKindId] AS [DeptKindId], [Extent1].[SamplingFlag] AS [SamplingFlag], [Extent1].[EnvironmentFlag] AS [EnvironmentFlag], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[Memo] AS [Memo], [Extent1].[TimeStamp] AS [TimeStamp], [Extent1].[CheckDeptFlag] AS [CheckDeptFlag], [Extent1].[Abbreviation] AS [Abbreviation] FROM [Common].[Dept] AS [Extent1] WITH (NOLOCK) INNER JOIN [Common].[IdXhJoin] AS [Extent2] WITH (NOLOCK) ON [Extent1].[Id] = [Extent2].[JoinId] WHERE [Extent2].[PId] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustPDS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>-9999 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Py] AS [Py], [Extent1].[Wb] AS [Wb], [Extent1].[Birthday] AS [Birthday], [Extent1].[SexId] AS [SexId], [Extent1].[MaritalStatusId] AS [MaritalStatusId], [Extent1].[Sfzh] AS [Sfzh], [Extent1].[TechTitleId] AS [TechTitleId], [Extent1].[DegreeId] AS [DegreeId], [Extent1].[InnerPhone] AS [InnerPhone], [Extent1].[Mobile] AS [Mobile], [Extent1].[Mail] AS [Mail], [Extent1].[DefaultDeptId] AS [DefaultDeptId], [Extent1].[DefaultWardId] AS [DefaultWardId], [Extent1].[Depts] AS [Depts], [Extent1].[Wards] AS [Wards], [Extent1].[StaffFlag] AS [StaffFlag], [Extent1].[DataMaintainFlag] AS [DataMaintainFlag], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[YBStaffId] AS [YBStaffId], [Extent1].[YBDeptId] AS [YBDeptId], [Extent1].[HRStaffId] AS [HRStaffId], [Extent1].[StaffDesc] AS [StaffDesc], [Extent1].[Memo] AS [Memo], [Extent1].[TimeStamp] AS [TimeStamp], [Extent1].[CAOpenId] AS [CAOpenId], [Extent1].[StdCode] AS [StdCode], [Extent1].[StdName] AS [StdName] FROM [Common].[Staff] AS [Extent1] WITH (NOLOCK) INNER JOIN [Common].[IdXhJoin] AS [Extent2] WITH (NOLOCK) ON [Extent1].[Id] = [Extent2].[JoinId] WHERE [Extent2].[PId] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustPDS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>-9999 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: SELECT TOP (1) [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Description] AS [Description], [Extent1].[Value] AS [Value], [Extent1].[RefValue] AS [RefValue], [Extent1].[DataType] AS [DataType], [Extent1].[CanSelect] AS [CanSelect], [Extent1].[SelectSource] AS [SelectSource], [Extent1].[GroupId] AS [GroupId], [Extent1].[Editor] AS [Editor], [Extent1].[EditableFlag] AS [EditableFlag], [Extent1].[ModifyStaffId] AS [ModifyStaffId], [Extent1].[ModifyTime] AS [ModifyTime], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[TimeStamp] AS [TimeStamp] FROM [Common].[Setting] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Id] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>OPPharmacySetting ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: SELECT TOP (1) [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Description] AS [Description], [Extent1].[Value] AS [Value], [Extent1].[RefValue] AS [RefValue], [Extent1].[DataType] AS [DataType], [Extent1].[CanSelect] AS [CanSelect], [Extent1].[SelectSource] AS [SelectSource], [Extent1].[GroupId] AS [GroupId], [Extent1].[Editor] AS [Editor], [Extent1].[EditableFlag] AS [EditableFlag], [Extent1].[ModifyStaffId] AS [ModifyStaffId], [Extent1].[ModifyTime] AS [ModifyTime], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[TimeStamp] AS [TimeStamp] FROM [Common].[Setting] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Id] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>DrugPublicConfig ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: SELECT [Extent1].[Xh] AS [Xh], [Extent1].[RegXh] AS [RegXh], [Extent1].[VisitDate] AS [VisitDate], [Extent1].[PatId] AS [PatId], [Extent1].[YBId] AS [YBId], [Extent1].[CredenceXh] AS [CredenceXh], [Extent1].[RecipeName] AS [RecipeName], [Extent1].[RecipeNum] AS [RecipeNum], [Extent1].[RecipeKindId] AS [RecipeKindId], [Extent1].[DoctorId] AS [DoctorId], [Extent1].[DoctorDatetime] AS [DoctorDatetime], [Extent1].[DoctorRecipeNo] AS [DoctorRecipeNo], [Extent1].[DoctorDept] AS [DoctorDept], [Extent1].[ValidFlag] AS [ValidFlag], [Extent1].[ExeDept] AS [ExeDept], [Extent1].[ExeDate] AS [ExeDate], [Extent1].[ExeFlag] AS [ExeFlag], [Extent1].[ExeStaffId] AS [ExeStaffId], [Extent1].[MessageFlag] AS [MessageFlag], [Extent1].[FeeFlag] AS [FeeFlag], [Extent1].[FeeDate] AS [FeeDate], [Extent1].[StaffId] AS [StaffId], [Extent1].[MessageDate] AS [MessageDate], [Extent1].[ETOrderXh] AS [ETOrderXh], [Extent1].[OriginFlag] AS [OriginFlag], [Extent1].[DiseaseFlag] AS [DiseaseFlag], [Extent1].[ReturnFlag] AS [ReturnFlag], [Extent1].[ReturnReason] AS [ReturnReason], [Extent1].[Memo] AS [Memo], [Extent1].[RecipeFlag] AS [RecipeFlag], [Extent1].[RecipeSerialNo] AS [RecipeSerialNo], [Extent1].[PrintFlag] AS [PrintFlag], [Extent1].[PrintDate] AS [PrintDate], [Extent1].[FYWinId] AS [FYWinId], [Extent1].[FYWinName] AS [FYWinName], [Extent1].[MedicalGuidance] AS [MedicalGuidance], [Extent1].[TreatmentScopeFlag] AS [TreatmentScopeFlag], [Extent1].[AttorneysName] AS [AttorneysName], [Extent1].[AttorneysPhone] AS [AttorneysPhone], [Extent1].[AttorneySfzh] AS [AttorneySfzh], [Extent1].[RelatedRecipeXh] AS [RelatedRecipeXh], [Extent1].[OperationRequestXh] AS [OperationRequestXh], [Extent1].[GenerationFriedFlag] AS [GenerationFriedFlag], [Extent1].[GenerationFriedNum] AS [GenerationFriedNum], [Extent1].[RecipeNumPerDay] AS [RecipeNumPerDay], [Extent1].[ModifiedDate] AS [ModifiedDate], [Extent1].[UsageId] AS [UsageId], [Extent1].[PrepayFlag] AS [PrepayFlag], [Extent1].[ConfirmFlag] AS [ConfirmFlag], [Extent1].[SourceXh] AS [SourceXh], [Extent1].[SourceKind] AS [SourceKind], [Extent1].[ZQNum] AS [ZQNum], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[ValidUsableFlag] AS [ValidUsableFlag], [Extent1].[SyncSignNo] AS [SyncSignNo], [Extent1].[ReturnStaffId] AS [ReturnStaffId], [Extent1].[ReturnTime] AS [ReturnTime], [Extent1].[DoctorCAFlag] AS [DoctorCAFlag], [Extent1].[AddressXh] AS [AddressXh], [Extent1].[DecoctFlag] AS [DecoctFlag], [Extent1].[FixTemplateName] AS [FixTemplateName] FROM [OP].[Recipe] AS [Extent1] WITH (NOLOCK) INNER JOIN [OP].[IdXhJoin] AS [Extent2] WITH (NOLOCK) ON [Extent1].[Xh] = [Extent2].[JoinXh] WHERE [Extent2].[PId] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustPDS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=OPApp;uid=sa;>>3 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[DeptId] AS [DeptId], [Extent1].[BindedWorkstation] AS [BindedWorkstation], [Extent1].[BindedWorkstationName] AS [BindedWorkstationName], [Extent1].[VisitDate] AS [VisitDate], [Extent1].[Memo] AS [Memo], [Extent1].[CloseFlag] AS [CloseFlag], [Extent1].[WinFlag] AS [WinFlag], [Extent1].[DispenseFlag] AS [DispenseFlag], [Extent1].[ExpertFlag] AS [ExpertFlag], [Extent1].[PrepareStaffId] AS [PrepareStaffId], [Extent1].[SendStaffId] AS [SendStaffId], [Extent1].[CheckStaffId] AS [CheckStaffId], [Extent1].[DisplayText] AS [DisplayText], [Extent1].[QueuedNo] AS [QueuedNo], [Extent1].[RemainningNum] AS [RemainningNum], [Extent1].[TimeStamp] AS [TimeStamp] FROM [Common].[FYWin] AS [Extent1] WITH (NOLOCK) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: UPDATE [OP].[Recipe] SET [FYWinId] = @0, [FYWinName] = @1 WHERE ((([Xh] = @2) AND ([ValidFlag] = @3)) AND ([FeeFlag] = @4)) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[DeptId] AS [DeptId], [Extent1].[BindedWorkstation] AS [BindedWorkstation], [Extent1].[BindedWorkstationName] AS [BindedWorkstationName], [Extent1].[VisitDate] AS [VisitDate], [Extent1].[Memo] AS [Memo], [Extent1].[CloseFlag] AS [CloseFlag], [Extent1].[WinFlag] AS [WinFlag], [Extent1].[DispenseFlag] AS [DispenseFlag], [Extent1].[ExpertFlag] AS [ExpertFlag], [Extent1].[PrepareStaffId] AS [PrepareStaffId], [Extent1].[SendStaffId] AS [SendStaffId], [Extent1].[CheckStaffId] AS [CheckStaffId], [Extent1].[DisplayText] AS [DisplayText], [Extent1].[QueuedNo] AS [QueuedNo], [Extent1].[RemainningNum] AS [RemainningNum], [Extent1].[TimeStamp] AS [TimeStamp] FROM [Common].[FYWin] AS [Extent1] WITH (NOLOCK) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: SELECT TOP (1) [Extent1].[Xh] AS [Xh], [Extent1].[RegXh] AS [RegXh], [Extent1].[VisitDate] AS [VisitDate], [Extent1].[PatId] AS [PatId], [Extent1].[YBId] AS [YBId], [Extent1].[CredenceXh] AS [CredenceXh], [Extent1].[RecipeName] AS [RecipeName], [Extent1].[RecipeNum] AS [RecipeNum], [Extent1].[RecipeKindId] AS [RecipeKindId], [Extent1].[DoctorId] AS [DoctorId], [Extent1].[DoctorDatetime] AS [DoctorDatetime], [Extent1].[DoctorRecipeNo] AS [DoctorRecipeNo], [Extent1].[DoctorDept] AS [DoctorDept], [Extent1].[ValidFlag] AS [ValidFlag], [Extent1].[ExeDept] AS [ExeDept], [Extent1].[ExeDate] AS [ExeDate], [Extent1].[ExeFlag] AS [ExeFlag], [Extent1].[ExeStaffId] AS [ExeStaffId], [Extent1].[MessageFlag] AS [MessageFlag], [Extent1].[FeeFlag] AS [FeeFlag], [Extent1].[FeeDate] AS [FeeDate], [Extent1].[StaffId] AS [StaffId], [Extent1].[MessageDate] AS [MessageDate], [Extent1].[ETOrderXh] AS [ETOrderXh], [Extent1].[OriginFlag] AS [OriginFlag], [Extent1].[DiseaseFlag] AS [DiseaseFlag], [Extent1].[ReturnFlag] AS [ReturnFlag], [Extent1].[ReturnReason] AS [ReturnReason], [Extent1].[Memo] AS [Memo], [Extent1].[RecipeFlag] AS [RecipeFlag], [Extent1].[RecipeSerialNo] AS [RecipeSerialNo], [Extent1].[PrintFlag] AS [PrintFlag], [Extent1].[PrintDate] AS [PrintDate], [Extent1].[FYWinId] AS [FYWinId], [Extent1].[FYWinName] AS [FYWinName], [Extent1].[MedicalGuidance] AS [MedicalGuidance], [Extent1].[TreatmentScopeFlag] AS [TreatmentScopeFlag], [Extent1].[AttorneysName] AS [AttorneysName], [Extent1].[AttorneysPhone] AS [AttorneysPhone], [Extent1].[AttorneySfzh] AS [AttorneySfzh], [Extent1].[RelatedRecipeXh] AS [RelatedRecipeXh], [Extent1].[OperationRequestXh] AS [OperationRequestXh], [Extent1].[GenerationFriedFlag] AS [GenerationFriedFlag], [Extent1].[GenerationFriedNum] AS [GenerationFriedNum], [Extent1].[RecipeNumPerDay] AS [RecipeNumPerDay], [Extent1].[ModifiedDate] AS [ModifiedDate], [Extent1].[UsageId] AS [UsageId], [Extent1].[PrepayFlag] AS [PrepayFlag], [Extent1].[ConfirmFlag] AS [ConfirmFlag], [Extent1].[SourceXh] AS [SourceXh], [Extent1].[SourceKind] AS [SourceKind], [Extent1].[ZQNum] AS [ZQNum], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[ValidUsableFlag] AS [ValidUsableFlag], [Extent1].[SyncSignNo] AS [SyncSignNo], [Extent1].[ReturnStaffId] AS [ReturnStaffId], [Extent1].[ReturnTime] AS [ReturnTime], [Extent1].[DoctorCAFlag] AS [DoctorCAFlag], [Extent1].[AddressXh] AS [AddressXh], [Extent1].[DecoctFlag] AS [DecoctFlag], [Extent1].[FixTemplateName] AS [FixTemplateName] FROM [OP].[Recipe] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Xh] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustCIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=OPApp;uid=sa;>>629 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: UPDATE [OP].[Recipe] SET [FYWinId] = @0, [FYWinName] = @1 WHERE ((([Xh] = @2) AND ([ValidFlag] = @3)) AND ([FeeFlag] = @4)) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: SELECT TOP (1) [Extent1].[SJH] AS [SJH], [Extent1].[PatId] AS [PatId], [Extent1].[PatName] AS [PatName], [Extent1].[YBId] AS [YBId], [Extent1].[CredenceXh] AS [CredenceXh], [Extent1].[InvoiceBookXh] AS [InvoiceBookXh], [Extent1].[InvoiceNo] AS [InvoiceNo], [Extent1].[InvoiceTitle] AS [InvoiceTitle], [Extent1].[RegXh] AS [RegXh], [Extent1].[RegDate] AS [RegDate], [Extent1].[ListMoney] AS [ListMoney], [Extent1].[ActualMoney] AS [ActualMoney], [Extent1].[SelfMoney] AS [SelfMoney], [Extent1].[YBSelfMoney] AS [YBSelfMoney], [Extent1].[YBMoney] AS [YBMoney], [Extent1].[SRMoney] AS [SRMoney], [Extent1].[ReturnSJH] AS [ReturnSJH], [Extent1].[RecFlag] AS [RecFlag], [Extent1].[YBJSFlag] AS [YBJSFlag], [Extent1].[YBTransNo] AS [YBTransNo], [Extent1].[OweFlag] AS [OweFlag], [Extent1].[OweMoney] AS [OweMoney], [Extent1].[OweAuthorizedStaffId] AS [OweAuthorizedStaffId], [Extent1].[StaffId] AS [StaffId], [Extent1].[CreatedDate] AS [CreatedDate], [Extent1].[YBAccountInfo] AS [YBAccountInfo], [Extent1].[PayInfo] AS [PayInfo], [Extent1].[PrintFlag] AS [PrintFlag], [Extent1].[PrintDate] AS [PrintDate], [Extent1].[PrintStaffId] AS [PrintStaffId], [Extent1].[SettlementFlag] AS [SettlementFlag], [Extent1].[SettlementDate] AS [SettlementDate], [Extent1].[SettlementStaffId] AS [SettlementStaffId], [Extent1].[Prefix] AS [Prefix], [Extent1].[SettlementKind] AS [SettlementKind], [Extent1].[YBPartialSelfMoney] AS [YBPartialSelfMoney], [Extent1].[OffMoney] AS [OffMoney], [Extent1].[ReliefMoney] AS [ReliefMoney], [Extent1].[UnitAccountMoney] AS [UnitAccountMoney], [Extent1].[UnitOutMoney] AS [UnitOutMoney], [Extent1].[DiseaseId] AS [DiseaseId], [Extent1].[SpecialOffMoney] AS [SpecialOffMoney], [Extent1].[SelfPay] AS [SelfPay], [Extent1].[EmergencyFlag] AS [EmergencyFlag], [Extent1].[RePrintFlag] AS [RePrintFlag], [Extent1].[RePrintInvoice] AS [RePrintInvoice], [Extent1].[DiseaseOffMoney] AS [DiseaseOffMoney], [Extent1].[YBReSelfPay] AS [YBReSelfPay], [Extent1].[YBPayLineSum] AS [YBPayLineSum], [Extent1].[YBWholePlanSum] AS [YBWholePlanSum], [Extent1].[YBMoneySum] AS [YBMoneySum], [Extent1].[FYWinGuidance] AS [FYWinGuidance], [Extent1].[MedicalGuidance] AS [MedicalGuidance], [Extent1].[SpecialSettleFlag] AS [SpecialSettleFlag], [Extent1].[InvoiceCount] AS [InvoiceCount], [Extent1].[SourceKind] AS [SourceKind], [Extent1].[ReceiptMoney] AS [ReceiptMoney], [Extent1].[ChangeMoney] AS [ChangeMoney] FROM [OP].[Settlement] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[SJH] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=OPApp;uid=sa;>>020260308zz001000001 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: UPDATE [OP].[Settlement] SET [FYWinGuidance] = @0, [MedicalGuidance] = @1 WHERE ((([SJH] = @2) AND ([RecFlag] = @3)) AND ([SettlementFlag] = @4)) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: SELECT TOP (1) [Extent1].[Xh] AS [Xh], [Extent1].[RegXh] AS [RegXh], [Extent1].[VisitDate] AS [VisitDate], [Extent1].[PatId] AS [PatId], [Extent1].[YBId] AS [YBId], [Extent1].[CredenceXh] AS [CredenceXh], [Extent1].[RecipeName] AS [RecipeName], [Extent1].[RecipeNum] AS [RecipeNum], [Extent1].[RecipeKindId] AS [RecipeKindId], [Extent1].[DoctorId] AS [DoctorId], [Extent1].[DoctorDatetime] AS [DoctorDatetime], [Extent1].[DoctorRecipeNo] AS [DoctorRecipeNo], [Extent1].[DoctorDept] AS [DoctorDept], [Extent1].[ValidFlag] AS [ValidFlag], [Extent1].[ExeDept] AS [ExeDept], [Extent1].[ExeDate] AS [ExeDate], [Extent1].[ExeFlag] AS [ExeFlag], [Extent1].[ExeStaffId] AS [ExeStaffId], [Extent1].[MessageFlag] AS [MessageFlag], [Extent1].[FeeFlag] AS [FeeFlag], [Extent1].[FeeDate] AS [FeeDate], [Extent1].[StaffId] AS [StaffId], [Extent1].[MessageDate] AS [MessageDate], [Extent1].[ETOrderXh] AS [ETOrderXh], [Extent1].[OriginFlag] AS [OriginFlag], [Extent1].[DiseaseFlag] AS [DiseaseFlag], [Extent1].[ReturnFlag] AS [ReturnFlag], [Extent1].[ReturnReason] AS [ReturnReason], [Extent1].[Memo] AS [Memo], [Extent1].[RecipeFlag] AS [RecipeFlag], [Extent1].[RecipeSerialNo] AS [RecipeSerialNo], [Extent1].[PrintFlag] AS [PrintFlag], [Extent1].[PrintDate] AS [PrintDate], [Extent1].[FYWinId] AS [FYWinId], [Extent1].[FYWinName] AS [FYWinName], [Extent1].[MedicalGuidance] AS [MedicalGuidance], [Extent1].[TreatmentScopeFlag] AS [TreatmentScopeFlag], [Extent1].[AttorneysName] AS [AttorneysName], [Extent1].[AttorneysPhone] AS [AttorneysPhone], [Extent1].[AttorneySfzh] AS [AttorneySfzh], [Extent1].[RelatedRecipeXh] AS [RelatedRecipeXh], [Extent1].[OperationRequestXh] AS [OperationRequestXh], [Extent1].[GenerationFriedFlag] AS [GenerationFriedFlag], [Extent1].[GenerationFriedNum] AS [GenerationFriedNum], [Extent1].[RecipeNumPerDay] AS [RecipeNumPerDay], [Extent1].[ModifiedDate] AS [ModifiedDate], [Extent1].[UsageId] AS [UsageId], [Extent1].[PrepayFlag] AS [PrepayFlag], [Extent1].[ConfirmFlag] AS [ConfirmFlag], [Extent1].[SourceXh] AS [SourceXh], [Extent1].[SourceKind] AS [SourceKind], [Extent1].[ZQNum] AS [ZQNum], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[ValidUsableFlag] AS [ValidUsableFlag], [Extent1].[SyncSignNo] AS [SyncSignNo], [Extent1].[ReturnStaffId] AS [ReturnStaffId], [Extent1].[ReturnTime] AS [ReturnTime], [Extent1].[DoctorCAFlag] AS [DoctorCAFlag], [Extent1].[AddressXh] AS [AddressXh], [Extent1].[DecoctFlag] AS [DecoctFlag], [Extent1].[FixTemplateName] AS [FixTemplateName] FROM [OP].[Recipe] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Xh] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustCIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=OPApp;uid=sa;>>629 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: SELECT [Extent1].[ItemId] AS [ItemId], [Extent1].[DeviceKindId] AS [DeviceKindId], [Extent1].[ClinicItemXh] AS [ClinicItemXh], [Extent1].[ClinicFlag] AS [ClinicFlag], [Extent1].[BindItemId] AS [BindItemId], [Extent1].[ItemFeeFlag] AS [ItemFeeFlag], [Extent1].[Idm] AS [Idm], [Extent1].[Xh] AS [Xh], [Extent1].[ModifyTime] AS [ModifyTime], [Extent1].[ModifyStaffId] AS [ModifyStaffId], [Extent1].[ModifyTimeStamp] AS [ModifyTimeStamp], [Extent1].[RuleXml] AS [RuleXml], [Extent1].[AgeMinLimit] AS [AgeMinLimit], [Extent1].[AgeMaxLimit] AS [AgeMaxLimit], [Extent1].[Quantity] AS [Quantity] FROM [ETO].[ETOItemRef] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[ItemId] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: ReaderExecuting>>Data Source=172.16.64.175;initial Catalog=TrustCIS;integrated security=false;MultipleActiveResultSets=True;Application Name=ETOApp;uid=sa;>> ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: SELECT [Extent2].[Xh] AS [Xh], [Extent2].[RequestXh] AS [RequestXh], [Extent2].[RecipeDataXh] AS [RecipeDataXh], [Extent2].[Idm] AS [Idm], [Extent2].[DrugName] AS [DrugName], [Extent2].[Spec] AS [Spec], [Extent2].[BatchXh] AS [BatchXh], [Extent2].[BatchNo] AS [BatchNo], [Extent2].[Quantity] AS [Quantity], [Extent2].[PriceLS] AS [PriceLS], [Extent2].[PriceJJ] AS [PriceJJ], [Extent2].[PricePF] AS [PricePF], [Extent2].[Memo] AS [Memo], [Extent2].[WarehouseId] AS [WarehouseId], [Extent2].[OPUnit] AS [OPUnit], [Extent2].[OPUnitRatio] AS [OPUnitRatio], [Extent2].[CumulativeFlag] AS [CumulativeFlag] FROM [Drug].[OPDrugReturnRequest] AS [Extent1] WITH (NOLOCK) INNER JOIN [Drug].[OPDrugReturnRequestData] AS [Extent2] WITH (NOLOCK) ON [Extent1].[Xh] = [Extent2].[RequestXh] WHERE [Extent1].[JSSJH] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustPDS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=DrugApp;uid=sa;>>020260308zz001000001 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: SELECT [Extent1].[Xh] AS [Xh], [Extent1].[GroupXh] AS [GroupXh], [Extent1].[RecipeXh] AS [RecipeXh], [Extent1].[Idm] AS [Idm], [Extent1].[Name] AS [Name], [Extent1].[WarehouseId] AS [WarehouseId], [Extent1].[ItemSpec] AS [ItemSpec], [Extent1].[DoseUnit] AS [DoseUnit], [Extent1].[DoseRatio] AS [DoseRatio], [Extent1].[YKRatio] AS [YKRatio], [Extent1].[MinUnit] AS [MinUnit], [Extent1].[DoseQuantity] AS [DoseQuantity], [Extent1].[MinQuantity] AS [MinQuantity], [Extent1].[TotalQuantity] AS [TotalQuantity], [Extent1].[OPUnit] AS [OPUnit], [Extent1].[OPRatio] AS [OPRatio], [Extent1].[Days] AS [Days], [Extent1].[FreqId] AS [FreqId], [Extent1].[FreqName] AS [FreqName], [Extent1].[UsageId] AS [UsageId], [Extent1].[UsageName] AS [UsageName], [Extent1].[ListPrice] AS [ListPrice], [Extent1].[Money] AS [Money], [Extent1].[JJPrice] AS [JJPrice], [Extent1].[FeeFlag] AS [FeeFlag], [Extent1].[FeeDate] AS [FeeDate], [Extent1].[StartDay] AS [StartDay], [Extent1].[ValidFlag] AS [ValidFlag], [Extent1].[Remark] AS [Remark], [Extent1].[SelfProvidedFlag] AS [SelfProvidedFlag], [Extent1].[ApproveFlag] AS [ApproveFlag], [Extent1].[Prefix] AS [Prefix], [Extent1].[RecFlag] AS [RecFlag], [Extent1].[CanReturnCount] AS [CanReturnCount], [Extent1].[PassWarn] AS [PassWarn], [Extent1].[YBAuditFail] AS [YBAuditFail], [Extent1].[RemarkValue] AS [RemarkValue], [Extent1].[ProductName] AS [ProductName], [Extent1].[DiseaseFlag] AS [DiseaseFlag], [Extent1].[TreatmentScopeFlag] AS [TreatmentScopeFlag], [Extent1].[ReturnQuantity] AS [ReturnQuantity], [Extent1].[ConfirmFlag] AS [ConfirmFlag], [Extent1].[SourceXh] AS [SourceXh], [Extent1].[SourceKind] AS [SourceKind], [Extent1].[ValidUsableFlag] AS [ValidUsableFlag], [Extent1].[AllergyPositiveSetFlag] AS [AllergyPositiveSetFlag], [Extent1].[SkinTestFlag] AS [SkinTestFlag], [Extent1].[SkinTestResult] AS [SkinTestResult], [Extent1].[SkinTestResultTime] AS [SkinTestResultTime], [Extent1].[YBControlFlag] AS [YBControlFlag] FROM [OP].[RecipeData] AS [Extent1] WITH (NOLOCK) INNER JOIN [OP].[IdXhJoin] AS [Extent2] WITH (NOLOCK) ON [Extent2].[JoinXh] = [Extent1].[Xh] WHERE [Extent2].[PId] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustCIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=OPApp;uid=sa;>>107 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: SELECT [Extent1].[Xh] AS [Xh], [Extent1].[RegXh] AS [RegXh], [Extent1].[VisitDate] AS [VisitDate], [Extent1].[PatId] AS [PatId], [Extent1].[YBId] AS [YBId], [Extent1].[CredenceXh] AS [CredenceXh], [Extent1].[RecipeName] AS [RecipeName], [Extent1].[RecipeNum] AS [RecipeNum], [Extent1].[RecipeKindId] AS [RecipeKindId], [Extent1].[DoctorId] AS [DoctorId], [Extent1].[DoctorDatetime] AS [DoctorDatetime], [Extent1].[DoctorRecipeNo] AS [DoctorRecipeNo], [Extent1].[DoctorDept] AS [DoctorDept], [Extent1].[ValidFlag] AS [ValidFlag], [Extent1].[ExeDept] AS [ExeDept], [Extent1].[ExeDate] AS [ExeDate], [Extent1].[ExeFlag] AS [ExeFlag], [Extent1].[ExeStaffId] AS [ExeStaffId], [Extent1].[MessageFlag] AS [MessageFlag], [Extent1].[FeeFlag] AS [FeeFlag], [Extent1].[FeeDate] AS [FeeDate], [Extent1].[StaffId] AS [StaffId], [Extent1].[MessageDate] AS [MessageDate], [Extent1].[ETOrderXh] AS [ETOrderXh], [Extent1].[OriginFlag] AS [OriginFlag], [Extent1].[DiseaseFlag] AS [DiseaseFlag], [Extent1].[ReturnFlag] AS [ReturnFlag], [Extent1].[ReturnReason] AS [ReturnReason], [Extent1].[Memo] AS [Memo], [Extent1].[RecipeFlag] AS [RecipeFlag], [Extent1].[RecipeSerialNo] AS [RecipeSerialNo], [Extent1].[PrintFlag] AS [PrintFlag], [Extent1].[PrintDate] AS [PrintDate], [Extent1].[FYWinId] AS [FYWinId], [Extent1].[FYWinName] AS [FYWinName], [Extent1].[MedicalGuidance] AS [MedicalGuidance], [Extent1].[TreatmentScopeFlag] AS [TreatmentScopeFlag], [Extent1].[AttorneysName] AS [AttorneysName], [Extent1].[AttorneysPhone] AS [AttorneysPhone], [Extent1].[AttorneySfzh] AS [AttorneySfzh], [Extent1].[RelatedRecipeXh] AS [RelatedRecipeXh], [Extent1].[OperationRequestXh] AS [OperationRequestXh], [Extent1].[GenerationFriedFlag] AS [GenerationFriedFlag], [Extent1].[GenerationFriedNum] AS [GenerationFriedNum], [Extent1].[RecipeNumPerDay] AS [RecipeNumPerDay], [Extent1].[ModifiedDate] AS [ModifiedDate], [Extent1].[UsageId] AS [UsageId], [Extent1].[PrepayFlag] AS [PrepayFlag], [Extent1].[ConfirmFlag] AS [ConfirmFlag], [Extent1].[SourceXh] AS [SourceXh], [Extent1].[SourceKind] AS [SourceKind], [Extent1].[ZQNum] AS [ZQNum], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[ValidUsableFlag] AS [ValidUsableFlag], [Extent1].[SyncSignNo] AS [SyncSignNo], [Extent1].[ReturnStaffId] AS [ReturnStaffId], [Extent1].[ReturnTime] AS [ReturnTime], [Extent1].[DoctorCAFlag] AS [DoctorCAFlag], [Extent1].[AddressXh] AS [AddressXh], [Extent1].[DecoctFlag] AS [DecoctFlag], [Extent1].[FixTemplateName] AS [FixTemplateName] FROM [OP].[Recipe] AS [Extent1] WITH (NOLOCK) INNER JOIN [OP].[IdXhJoin] AS [Extent2] WITH (NOLOCK) ON [Extent2].[JoinXh] = [Extent1].[Xh] WHERE [Extent2].[PId] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustCIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=OPApp;uid=sa;>>109 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: SELECT TOP (1) [Extent1].[SJH] AS [SJH], [Extent1].[PatId] AS [PatId], [Extent1].[PatName] AS [PatName], [Extent1].[YBId] AS [YBId], [Extent1].[CredenceXh] AS [CredenceXh], [Extent1].[InvoiceBookXh] AS [InvoiceBookXh], [Extent1].[InvoiceNo] AS [InvoiceNo], [Extent1].[InvoiceTitle] AS [InvoiceTitle], [Extent1].[RegXh] AS [RegXh], [Extent1].[RegDate] AS [RegDate], [Extent1].[ListMoney] AS [ListMoney], [Extent1].[ActualMoney] AS [ActualMoney], [Extent1].[SelfMoney] AS [SelfMoney], [Extent1].[YBSelfMoney] AS [YBSelfMoney], [Extent1].[YBMoney] AS [YBMoney], [Extent1].[SRMoney] AS [SRMoney], [Extent1].[ReturnSJH] AS [ReturnSJH], [Extent1].[RecFlag] AS [RecFlag], [Extent1].[YBJSFlag] AS [YBJSFlag], [Extent1].[YBTransNo] AS [YBTransNo], [Extent1].[OweFlag] AS [OweFlag], [Extent1].[OweMoney] AS [OweMoney], [Extent1].[OweAuthorizedStaffId] AS [OweAuthorizedStaffId], [Extent1].[StaffId] AS [StaffId], [Extent1].[CreatedDate] AS [CreatedDate], [Extent1].[YBAccountInfo] AS [YBAccountInfo], [Extent1].[PayInfo] AS [PayInfo], [Extent1].[PrintFlag] AS [PrintFlag], [Extent1].[PrintDate] AS [PrintDate], [Extent1].[PrintStaffId] AS [PrintStaffId], [Extent1].[SettlementFlag] AS [SettlementFlag], [Extent1].[SettlementDate] AS [SettlementDate], [Extent1].[SettlementStaffId] AS [SettlementStaffId], [Extent1].[Prefix] AS [Prefix], [Extent1].[SettlementKind] AS [SettlementKind], [Extent1].[YBPartialSelfMoney] AS [YBPartialSelfMoney], [Extent1].[OffMoney] AS [OffMoney], [Extent1].[ReliefMoney] AS [ReliefMoney], [Extent1].[UnitAccountMoney] AS [UnitAccountMoney], [Extent1].[UnitOutMoney] AS [UnitOutMoney], [Extent1].[DiseaseId] AS [DiseaseId], [Extent1].[SpecialOffMoney] AS [SpecialOffMoney], [Extent1].[SelfPay] AS [SelfPay], [Extent1].[EmergencyFlag] AS [EmergencyFlag], [Extent1].[RePrintFlag] AS [RePrintFlag], [Extent1].[RePrintInvoice] AS [RePrintInvoice], [Extent1].[DiseaseOffMoney] AS [DiseaseOffMoney], [Extent1].[YBReSelfPay] AS [YBReSelfPay], [Extent1].[YBPayLineSum] AS [YBPayLineSum], [Extent1].[YBWholePlanSum] AS [YBWholePlanSum], [Extent1].[YBMoneySum] AS [YBMoneySum], [Extent1].[FYWinGuidance] AS [FYWinGuidance], [Extent1].[MedicalGuidance] AS [MedicalGuidance], [Extent1].[SpecialSettleFlag] AS [SpecialSettleFlag], [Extent1].[InvoiceCount] AS [InvoiceCount], [Extent1].[SourceKind] AS [SourceKind], [Extent1].[ReceiptMoney] AS [ReceiptMoney], [Extent1].[ChangeMoney] AS [ChangeMoney] FROM [OP].[Settlement] AS [Extent1] WITH (NOLOCK) WHERE ([Extent1].[SJH] = @p__linq__0) AND (0 = [Extent1].[SettlementFlag]) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=OPApp;uid=sa;>>020260308zz001000001 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: SELECT [Extent1].[Xh] AS [Xh], [Extent1].[StartNo] AS [StartNo], [Extent1].[EndNo] AS [EndNo], [Extent1].[CurrentNo] AS [CurrentNo], [Extent1].[OwnerStaffId] AS [OwnerStaffId], [Extent1].[StaffId] AS [StaffId], [Extent1].[ModifiedDate] AS [ModifiedDate], [Extent1].[Memo] AS [Memo], [Extent1].[InvoiceFlag] AS [InvoiceFlag], CAST( [Extent1].[InvoiceKindFlag] AS smallint) AS [C1], [Extent1].[Prefix] AS [Prefix], [Extent1].[OwnerFlag] AS [OwnerFlag] FROM [Common].[InvoiceBook] AS [Extent1] WITH (NOLOCK) WHERE ([Extent1].[OwnerStaffId] = @p__linq__0) AND ( CAST( (@p__linq__1) & ( CAST( CAST( [Extent1].[InvoiceKindFlag] AS smallint) AS int)) AS smallint) > 0) AND ([Extent1].[InvoiceFlag] < 2) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>zz001 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: UPDATE [Common].[InvoiceBook] SET [CurrentNo] = @0 WHERE ([Xh] = @1) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: INSERT [OP].[SettlementInvoice]([JSSJH], [Prefix], [InvoiceBookXh], [InvoiceNo], [RecFlag], [ActualMoney], [Memo], [PrintDate], [PrintStaffId]) VALUES (@0, @1, @2, @3, @4, @5, NULL, @6, @7) SELECT [Xh] FROM [OP].[SettlementInvoice] WHERE @@ROWCOUNT > 0 AND [Xh] = scope_identity() ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: SELECT [Extent1].[Xh] AS [Xh], [Extent1].[JSSJH] AS [JSSJH], [Extent1].[MoneyKindId] AS [MoneyKindId], [Extent1].[MoneyName] AS [MoneyName], [Extent1].[Money] AS [Money], [Extent1].[Memo] AS [Memo], [Extent1].[ReturnFlag] AS [ReturnFlag], [Extent1].[PayingUnit] AS [PayingUnit], [Extent1].[BankName] AS [BankName], [Extent1].[BankAccount] AS [BankAccount], [Extent1].[RelatedXh] AS [RelatedXh] FROM [OP].[SettlementMoney] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[JSSJH] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=OPApp;uid=sa;>>020260308zz001000001 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: SELECT TOP (2) [Extent1].[Xh] AS [Xh], [Extent1].[DeptCheckoutXh] AS [DeptCheckoutXh], [Extent1].[StaffId] AS [StaffId], [Extent1].[CheckoutDate] AS [CheckoutDate], [Extent1].[BeginSJH] AS [BeginSJH], [Extent1].[EndSJH] AS [EndSJH], [Extent1].[ListMoney] AS [ListMoney], [Extent1].[ActualMoney] AS [ActualMoney], [Extent1].[SRMoney] AS [SRMoney], [Extent1].[SelfMoney] AS [SelfMoney], [Extent1].[YBSelfMoney] AS [YBSelfMoney], [Extent1].[YBMoney] AS [YBMoney], [Extent1].[OweMoney] AS [OweMoney], [Extent1].[ReturnInvoiceNum] AS [ReturnInvoiceNum], [Extent1].[ReturnMoney] AS [ReturnMoney], [Extent1].[CheckoutFlag] AS [CheckoutFlag], [Extent1].[DeptCheckoutDate] AS [DeptCheckoutDate], [Extent1].[DeptCheckoutStaffId] AS [DeptCheckoutStaffId], [Extent1].[ConfirmFlag] AS [ConfirmFlag], [Extent1].[ConfirmDate] AS [ConfirmDate], [Extent1].[ConfirmStaffId] AS [ConfirmStaffId], [Extent1].[SelfPay] AS [SelfPay], [Extent1].[CashMoney] AS [CashMoney], [Extent1].[PosMoney] AS [PosMoney], [Extent1].[CheckMoney] AS [CheckMoney], [Extent1].[UnitAccountMoney] AS [UnitAccountMoney], [Extent1].[ReferralMoney] AS [ReferralMoney], [Extent1].[CreateDate] AS [CreateDate], [Extent1].[EmergencyFlag] AS [EmergencyFlag], [Extent1].[DepositMoney] AS [DepositMoney], [Extent1].[DeptId] AS [DeptId], [Extent1].[OtherMoney] AS [OtherMoney], [Extent1].[OffMoney] AS [OffMoney], [Extent1].[RecallDate] AS [RecallDate], [Extent1].[RecallStaffId] AS [RecallStaffId], [Extent1].[AuditDate] AS [AuditDate], [Extent1].[AuditStaffId] AS [AuditStaffId] FROM [OP].[CheckoutSettlementOp] AS [Extent1] WITH (NOLOCK) WHERE ([Extent1].[StaffId] = @p__linq__0) AND (0 = [Extent1].[CheckoutFlag]) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=OPApp;uid=sa;>>zz001 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: SELECT TOP (1) [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Py] AS [Py], [Extent1].[Wb] AS [Wb], [Extent1].[Birthday] AS [Birthday], [Extent1].[SexId] AS [SexId], [Extent1].[MaritalStatusId] AS [MaritalStatusId], [Extent1].[Sfzh] AS [Sfzh], [Extent1].[TechTitleId] AS [TechTitleId], [Extent1].[DegreeId] AS [DegreeId], [Extent1].[InnerPhone] AS [InnerPhone], [Extent1].[Mobile] AS [Mobile], [Extent1].[Mail] AS [Mail], [Extent1].[DefaultDeptId] AS [DefaultDeptId], [Extent1].[DefaultWardId] AS [DefaultWardId], [Extent1].[Depts] AS [Depts], [Extent1].[Wards] AS [Wards], [Extent1].[StaffFlag] AS [StaffFlag], [Extent1].[DataMaintainFlag] AS [DataMaintainFlag], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[YBStaffId] AS [YBStaffId], [Extent1].[YBDeptId] AS [YBDeptId], [Extent1].[HRStaffId] AS [HRStaffId], [Extent1].[StaffDesc] AS [StaffDesc], [Extent1].[Memo] AS [Memo], [Extent1].[TimeStamp] AS [TimeStamp], [Extent1].[CAOpenId] AS [CAOpenId], [Extent1].[StdCode] AS [StdCode], [Extent1].[StdName] AS [StdName] FROM [Common].[Staff] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Id] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>zz001 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: INSERT [OP].[CheckoutSettlementOp]([DeptCheckoutXh], [StaffId], [DeptId], [CheckoutDate], [BeginSJH], [EndSJH], [ListMoney], [ActualMoney], [SelfPay], [SRMoney], [SelfMoney], [YBSelfMoney], [YBMoney], [OweMoney], [OffMoney], [UnitAccountMoney], [ReferralMoney], [DepositMoney], [CashMoney], [PosMoney], [CheckMoney], [OtherMoney], [ReturnInvoiceNum], [ReturnMoney], [CheckoutFlag], [DeptCheckoutDate], [DeptCheckoutStaffId], [EmergencyFlag], [ConfirmFlag], [ConfirmDate], [ConfirmStaffId], [CreateDate], [RecallDate], [RecallStaffId], [AuditDate], [AuditStaffId]) VALUES (NULL, @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10, @11, @12, @13, @14, NULL, @15, @16, @17, @18, @19, @20, @21, @22, NULL, NULL, @23, NULL, NULL, NULL, @24, NULL, NULL, NULL, NULL) SELECT [Xh] FROM [OP].[CheckoutSettlementOp] WHERE @@ROWCOUNT > 0 AND [Xh] = scope_identity() ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: SELECT [Extent1].[Xh] AS [Xh], [Extent1].[RegXh] AS [RegXh], [Extent1].[RecipeXh] AS [RecipeXh], [Extent1].[RecipeDetailXh] AS [RecipeDetailXh], [Extent1].[RecipeDetailKind] AS [RecipeDetailKind], [Extent1].[JSSJH] AS [JSSJH], [Extent1].[Idm] AS [Idm], [Extent1].[ItemId] AS [ItemId], [Extent1].[PrintId] AS [PrintId], [Extent1].[AccItemId] AS [AccItemId], [Extent1].[AccItemName] AS [AccItemName], [Extent1].[ItemName] AS [ItemName], [Extent1].[ItemSpec] AS [ItemSpec], [Extent1].[OPUnit] AS [OPUnit], [Extent1].[OPUnitRatio] AS [OPUnitRatio], [Extent1].[YKRatio] AS [YKRatio], [Extent1].[ListPrice] AS [ListPrice], [Extent1].[Quantity] AS [Quantity], [Extent1].[Money] AS [Money], [Extent1].[YBMoney] AS [YBMoney], [Extent1].[UpperPrice] AS [UpperPrice], [Extent1].[PriceRatio] AS [PriceRatio], [Extent1].[SelfRatio] AS [SelfRatio], [Extent1].[SettlementFlag] AS [SettlementFlag], [Extent1].[RecFlag] AS [RecFlag], [Extent1].[ReturnXh] AS [ReturnXh], [Extent1].[StaffId] AS [StaffId], [Extent1].[ModifiedDate] AS [ModifiedDate], [Extent1].[DeptId] AS [DeptId], [Extent1].[WardId] AS [WardId], [Extent1].[DoctorId] AS [DoctorId], [Extent1].[ExecDeptId] AS [ExecDeptId], [Extent1].[ExecStaffId] AS [ExecStaffId], [Extent1].[ConfirmFlag] AS [ConfirmFlag], [Extent1].[Prefix] AS [Prefix], [Extent1].[YBPartialSelfRatio] AS [YBPartialSelfRatio], [Extent1].[ReliefMoney] AS [ReliefMoney], [Extent1].[OffRatio] AS [OffRatio], [Extent1].[SpecialOffMoney] AS [SpecialOffMoney], [Extent1].[SubAccItemId] AS [SubAccItemId], [Extent1].[SelfPay] AS [SelfPay], [Extent1].[YBPartialSelfMoney] AS [YBPartialSelfMoney], [Extent1].[DiseaseOffMoney] AS [DiseaseOffMoney], [Extent1].[SelfMoney] AS [SelfMoney], [Extent1].[OffMoney] AS [OffMoney], [Extent1].[YBSelfMoney] AS [YBSelfMoney], [Extent1].[YBReSelfRatio] AS [YBReSelfRatio], [Extent1].[UnitOutMoney] AS [UnitOutMoney], [Extent1].[UnitAccountMoney] AS [UnitAccountMoney], [Extent1].[YBReSelfPay] AS [YBReSelfPay], [Extent1].[UnitTotalMoney] AS [UnitTotalMoney], [Extent1].[ReturnQuantity] AS [ReturnQuantity], [Extent1].[TreatmentMemo] AS [TreatmentMemo], [Extent1].[YBAuditFail] AS [YBAuditFail], [Extent1].[DefaultRatio] AS [DefaultRatio], [Extent1].[ClinicItemXh] AS [ClinicItemXh], [Extent1].[CalcFlag] AS [CalcFlag], [Extent1].[MDHBarCode] AS [MDHBarCode], [Extent1].[RuleIds] AS [RuleIds] FROM [OP].[FeeData] AS [Extent1] WITH (NOLOCK) WHERE ([Extent1].[RecipeXh] IS NOT NULL) AND ([Extent1].[RecipeXh] = @p__linq__0) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=OPApp;uid=sa;>>629 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: SELECT [Extent1].[Xh] AS [Xh], [Extent1].[SendRequestXh] AS [SendRequestXh], [Extent1].[RegXh] AS [RegXh], [Extent1].[PatId] AS [PatId], [Extent1].[PatName] AS [PatName], [Extent1].[RecipeXh] AS [RecipeXh], [Extent1].[SendPharmacyId] AS [SendPharmacyId], [Extent1].[SendWinId] AS [SendWinId], [Extent1].[RecievePharmacyId] AS [RecievePharmacyId], [Extent1].[RecieveWinId] AS [RecieveWinId], [Extent1].[ReciveStaffId] AS [ReciveStaffId], [Extent1].[ReciveDate] AS [ReciveDate], [Extent1].[FeeDate] AS [FeeDate], [Extent1].[FeeStaffId] AS [FeeStaffId], [Extent1].[ReturnReason] AS [ReturnReason], [Extent1].[RecFlag] AS [RecFlag], [Extent1].[Memo] AS [Memo], [Extent1].[JSSJH] AS [JSSJH] FROM [Drug].[OPDrugReturnRequest] AS [Extent1] WITH (NOLOCK) INNER JOIN [Drug].[IdXhJoin] AS [Extent2] WITH (NOLOCK) ON [Extent1].[Xh] = [Extent2].[JoinXh] WHERE (3 <> [Extent1].[RecFlag]) AND ([Extent2].[PId] = @p__linq__0) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustPDS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=DrugApp;uid=sa;>>-9999 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: SELECT [Extent1].[Xh] AS [Xh], [Extent1].[RequestXh] AS [RequestXh], [Extent1].[RecipeDataXh] AS [RecipeDataXh], [Extent1].[Idm] AS [Idm], [Extent1].[DrugName] AS [DrugName], [Extent1].[Spec] AS [Spec], [Extent1].[BatchXh] AS [BatchXh], [Extent1].[BatchNo] AS [BatchNo], [Extent1].[Quantity] AS [Quantity], [Extent1].[PriceLS] AS [PriceLS], [Extent1].[PriceJJ] AS [PriceJJ], [Extent1].[PricePF] AS [PricePF], [Extent1].[Memo] AS [Memo], [Extent1].[WarehouseId] AS [WarehouseId], [Extent1].[OPUnit] AS [OPUnit], [Extent1].[OPUnitRatio] AS [OPUnitRatio], [Extent1].[CumulativeFlag] AS [CumulativeFlag] FROM [Drug].[OPDrugReturnRequestData] AS [Extent1] WITH (NOLOCK) INNER JOIN [Drug].[IdXhJoin] AS [Extent2] WITH (NOLOCK) ON [Extent1].[RequestXh] = [Extent2].[JoinXh] WHERE [Extent2].[PId] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustPDS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=DrugApp;uid=sa;>>-9999 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: SELECT [Extent1].[Xh] AS [Xh], [Extent1].[MessageId] AS [MessageId], [Extent1].[SenderlXh] AS [SenderlXh], [Extent1].[SenderDept] AS [SenderDept], [Extent1].[PharmacyId] AS [PharmacyId], [Extent1].[JSSJH] AS [JSSJH], [Extent1].[PatId] AS [PatId], [Extent1].[RegXh] AS [RegXh], [Extent1].[RecipeXh] AS [RecipeXh], [Extent1].[RecipeKindId] AS [RecipeKindId], [Extent1].[PatientName] AS [PatientName], [Extent1].[Age] AS [Age], [Extent1].[Sex] AS [Sex], [Extent1].[KFStaffId] AS [KFStaffId], [Extent1].[KFStaffName] AS [KFStaffName], [Extent1].[KFDeptId] AS [KFDeptId], [Extent1].[KFDeptName] AS [KFDeptName], [Extent1].[KFDate] AS [KFDate], [Extent1].[RecipeTS] AS [RecipeTS], [Extent1].[SFWin] AS [SFWin], [Extent1].[PYWin] AS [PYWin], [Extent1].[FYWin] AS [FYWin], [Extent1].[ReceivedDate] AS [ReceivedDate], [Extent1].[RequestSendDate] AS [RequestSendDate], [Extent1].[PrepareStaffId] AS [PrepareStaffId], [Extent1].[PrepareDate] AS [PrepareDate], [Extent1].[SendStaffId] AS [SendStaffId], [Extent1].[SendDate] AS [SendDate], [Extent1].[RecFlag] AS [RecFlag], [Extent1].[TXh] AS [TXh], [Extent1].[OriginFlag] AS [OriginFlag], [Extent1].[IndexNumber] AS [IndexNumber], [Extent1].[WaitFlag] AS [WaitFlag], [Extent1].[SFStaffId] AS [SFStaffId], [Extent1].[SendSerialNo] AS [SendSerialNo], [Extent1].[PrintFlag] AS [PrintFlag], [Extent1].[AutidStaffId] AS [AutidStaffId], [Extent1].[PrintDate] AS [PrintDate] FROM [Drug].[OPDrugSendRequest] AS [Extent1] WITH (NOLOCK) INNER JOIN [Drug].[IdXhJoin] AS [Extent2] WITH (NOLOCK) ON [Extent1].[Xh] = [Extent2].[JoinXh] WHERE [Extent2].[PId] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustPDS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=DrugApp;uid=sa;>>-9999 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: SELECT TOP (1) [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Description] AS [Description], [Extent1].[Value] AS [Value], [Extent1].[RefValue] AS [RefValue], [Extent1].[DataType] AS [DataType], [Extent1].[CanSelect] AS [CanSelect], [Extent1].[SelectSource] AS [SelectSource], [Extent1].[GroupId] AS [GroupId], [Extent1].[Editor] AS [Editor], [Extent1].[EditableFlag] AS [EditableFlag], [Extent1].[ModifyStaffId] AS [ModifyStaffId], [Extent1].[ModifyTime] AS [ModifyTime], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[TimeStamp] AS [TimeStamp] FROM [Common].[Setting] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Id] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>OPPharmacySetting ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: SELECT TOP (1) [Extent1].[Xh] AS [Xh], [Extent1].[PatId] AS [PatId], [Extent1].[IdentityKindId] AS [IdentityKindId], [Extent1].[Sfzh] AS [Sfzh], [Extent1].[Password] AS [Password], [Extent1].[OPDepositMoney] AS [OPDepositMoney], [Extent1].[OPFreezeMoney] AS [OPFreezeMoney], [Extent1].[IPDepositMoney] AS [IPDepositMoney], [Extent1].[IPFreezeMoney] AS [IPFreezeMoney], [Extent1].[AccountFlag] AS [AccountFlag], [Extent1].[SettleLockFlag] AS [SettleLockFlag], [Extent1].[SettleLockTime] AS [SettleLockTime], [Extent1].[CreateStaff] AS [CreateStaff], [Extent1].[CreateTime] AS [CreateTime], [Extent1].[StampCode] AS [StampCode], [Extent1].[Memo] AS [Memo], [Extent1].[SettleLockStaff] AS [SettleLockStaff] FROM [Common].[PatDepositAccount] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[PatId] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>16392 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: SELECT TOP (1) [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Py] AS [Py], [Extent1].[Wb] AS [Wb], [Extent1].[Birthday] AS [Birthday], [Extent1].[SexId] AS [SexId], [Extent1].[MaritalStatusId] AS [MaritalStatusId], [Extent1].[Sfzh] AS [Sfzh], [Extent1].[TechTitleId] AS [TechTitleId], [Extent1].[DegreeId] AS [DegreeId], [Extent1].[InnerPhone] AS [InnerPhone], [Extent1].[Mobile] AS [Mobile], [Extent1].[Mail] AS [Mail], [Extent1].[DefaultDeptId] AS [DefaultDeptId], [Extent1].[DefaultWardId] AS [DefaultWardId], [Extent1].[Depts] AS [Depts], [Extent1].[Wards] AS [Wards], [Extent1].[StaffFlag] AS [StaffFlag], [Extent1].[DataMaintainFlag] AS [DataMaintainFlag], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[YBStaffId] AS [YBStaffId], [Extent1].[YBDeptId] AS [YBDeptId], [Extent1].[HRStaffId] AS [HRStaffId], [Extent1].[StaffDesc] AS [StaffDesc], [Extent1].[Memo] AS [Memo], [Extent1].[TimeStamp] AS [TimeStamp], [Extent1].[CAOpenId] AS [CAOpenId], [Extent1].[StdCode] AS [StdCode], [Extent1].[StdName] AS [StdName] FROM [Common].[Staff] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Id] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>zz001 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: SELECT TOP (1) [Extent1].[Id] AS [Id], [Extent1].[ParentId] AS [ParentId], [Extent1].[HospitalId] AS [HospitalId], [Extent1].[Name] AS [Name], [Extent1].[Py] AS [Py], [Extent1].[Wb] AS [Wb], [Extent1].[LocationId] AS [LocationId], [Extent1].[DeptFlag] AS [DeptFlag], [Extent1].[DeptKindId] AS [DeptKindId], [Extent1].[SamplingFlag] AS [SamplingFlag], [Extent1].[EnvironmentFlag] AS [EnvironmentFlag], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[Memo] AS [Memo], [Extent1].[TimeStamp] AS [TimeStamp], [Extent1].[CheckDeptFlag] AS [CheckDeptFlag], [Extent1].[Abbreviation] AS [Abbreviation] FROM [Common].[Dept] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[Id] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustFIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=CommonApp;uid=sa;>>H038 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[DrugFlag] AS [DrugFlag], [Extent1].[Memo] AS [Memo], [Extent1].[EditorFlag] AS [EditorFlag], [Extent1].[Shortcut] AS [Shortcut], [Extent1].[ReserveFlag] AS [ReserveFlag], [Extent1].[GroupFlag] AS [GroupFlag], [Extent1].[SceneFlag] AS [SceneFlag], [Extent1].[Color] AS [Color], [Extent1].[ImageName] AS [ImageName], [Extent1].[TimeStamp] AS [TimeStamp] FROM [OP].[RecipeKind] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[DrugFlag] IN (cast(1 as smallint)) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: SELECT [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[DrugFlag] AS [DrugFlag], [Extent1].[Memo] AS [Memo], [Extent1].[EditorFlag] AS [EditorFlag], [Extent1].[Shortcut] AS [Shortcut], [Extent1].[ReserveFlag] AS [ReserveFlag], [Extent1].[GroupFlag] AS [GroupFlag], [Extent1].[SceneFlag] AS [SceneFlag], [Extent1].[Color] AS [Color], [Extent1].[ImageName] AS [ImageName], [Extent1].[TimeStamp] AS [TimeStamp] FROM [OP].[RecipeKind] AS [Extent1] WITH (NOLOCK) WHERE [Extent1].[DrugFlag] IN (cast(0 as smallint)) ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: SELECT [Extent1].[Xh] AS [Xh], [Extent1].[RegXh] AS [RegXh], [Extent1].[VisitDate] AS [VisitDate], [Extent1].[PatId] AS [PatId], [Extent1].[YBId] AS [YBId], [Extent1].[CredenceXh] AS [CredenceXh], [Extent1].[RecipeName] AS [RecipeName], [Extent1].[RecipeNum] AS [RecipeNum], [Extent1].[RecipeKindId] AS [RecipeKindId], [Extent1].[DoctorId] AS [DoctorId], [Extent1].[DoctorDatetime] AS [DoctorDatetime], [Extent1].[DoctorRecipeNo] AS [DoctorRecipeNo], [Extent1].[DoctorDept] AS [DoctorDept], [Extent1].[ValidFlag] AS [ValidFlag], [Extent1].[ExeDept] AS [ExeDept], [Extent1].[ExeDate] AS [ExeDate], [Extent1].[ExeFlag] AS [ExeFlag], [Extent1].[ExeStaffId] AS [ExeStaffId], [Extent1].[MessageFlag] AS [MessageFlag], [Extent1].[FeeFlag] AS [FeeFlag], [Extent1].[FeeDate] AS [FeeDate], [Extent1].[StaffId] AS [StaffId], [Extent1].[MessageDate] AS [MessageDate], [Extent1].[ETOrderXh] AS [ETOrderXh], [Extent1].[OriginFlag] AS [OriginFlag], [Extent1].[DiseaseFlag] AS [DiseaseFlag], [Extent1].[ReturnFlag] AS [ReturnFlag], [Extent1].[ReturnReason] AS [ReturnReason], [Extent1].[Memo] AS [Memo], [Extent1].[RecipeFlag] AS [RecipeFlag], [Extent1].[RecipeSerialNo] AS [RecipeSerialNo], [Extent1].[PrintFlag] AS [PrintFlag], [Extent1].[PrintDate] AS [PrintDate], [Extent1].[FYWinId] AS [FYWinId], [Extent1].[FYWinName] AS [FYWinName], [Extent1].[MedicalGuidance] AS [MedicalGuidance], [Extent1].[TreatmentScopeFlag] AS [TreatmentScopeFlag], [Extent1].[AttorneysName] AS [AttorneysName], [Extent1].[AttorneysPhone] AS [AttorneysPhone], [Extent1].[AttorneySfzh] AS [AttorneySfzh], [Extent1].[RelatedRecipeXh] AS [RelatedRecipeXh], [Extent1].[OperationRequestXh] AS [OperationRequestXh], [Extent1].[GenerationFriedFlag] AS [GenerationFriedFlag], [Extent1].[GenerationFriedNum] AS [GenerationFriedNum], [Extent1].[RecipeNumPerDay] AS [RecipeNumPerDay], [Extent1].[ModifiedDate] AS [ModifiedDate], [Extent1].[UsageId] AS [UsageId], [Extent1].[PrepayFlag] AS [PrepayFlag], [Extent1].[ConfirmFlag] AS [ConfirmFlag], [Extent1].[SourceXh] AS [SourceXh], [Extent1].[SourceKind] AS [SourceKind], [Extent1].[ZQNum] AS [ZQNum], [Extent1].[DisableFlag] AS [DisableFlag], [Extent1].[ValidUsableFlag] AS [ValidUsableFlag], [Extent1].[SyncSignNo] AS [SyncSignNo], [Extent1].[ReturnStaffId] AS [ReturnStaffId], [Extent1].[ReturnTime] AS [ReturnTime], [Extent1].[DoctorCAFlag] AS [DoctorCAFlag], [Extent1].[AddressXh] AS [AddressXh], [Extent1].[DecoctFlag] AS [DecoctFlag], [Extent1].[FixTemplateName] AS [FixTemplateName] FROM [OP].[Recipe] AS [Extent1] WITH (NOLOCK) INNER JOIN [OP].[IdXhJoin] AS [Extent2] WITH (NOLOCK) ON [Extent2].[JoinXh] = [Extent1].[Xh] WHERE [Extent2].[PId] = @p__linq__0 ---------------------------------------- ---------------------------------------- Timestamp: 2026/3/8 3:01:06 Message: ReaderExecuting>>Data Source=172.16.64.175;Initial Catalog=TrustCIS;Integrated Security=false;MultipleActiveResultSets=True;Application Name=OPApp;uid=sa;>>111 ----------------------------------------