【纯净版】组织-组织维护

[heiyaz]

点击demo连接报错 列名 'modifiedbyname' 无效。: SELECT TOP 1 [organization].[basecurrencyidname],[organization].[basecurrencyid],[organization].[createdby],[organization].[createdon],[organization].[dataaccountname],[organization].[databasename],[organization].[datalogenabled],(case [organization].[datalogenabled] when 0 then '否' when 1 then '是' else '' end) as [datalogenabledname],[organization].[datapassword],[organization].[dataservername],[organization].[description],[organization].[emailsettings],[organization].[languageid],[organization].[managerid],[organization].[modifiedbyname],[organization].[modifiedby],[organization].[modifiedon],[organization].[name],[organization].[organizationid],[organization].[smssettings],[organization].[statecode],[organization].[statuscode],(case [organization].[statuscode] when 0 then '试用版' when 1 then '个人版' when 2 then '企业版' else '' end) as [statuscodename],[organization].[uniquename] FROM [OrganizationView] AS [Organization] WITH(NOLOCK) WHERE ( [Organization].[OrganizationID]=@0 ) ; 00000000-0000-0000-00aa-110000000012

[migomiddle]

db文件夹中的更新脚本执行一下

[heiyaz]

db中的脚本执行了，打开还是报错，是不是查询的地方需要修改，但是我找不到查询的地方

[DUWENINK]

我也是 把 ModifiedBy 改成modifiedbyname 又提示我 ModifiedBy 错了

[DUWENINK]

我都改成 [ModifiedByName]了 ALTER VIEW [dbo].[OrganizationView] AS SELECT [Organization].[BaseCurrencyId], [Organization].[CreatedBy], [Organization].[CreatedOn], [Organization].[DataAccountName], [Organization].[DataBaseName], [Organization].[DataLogEnabled], [Organization].[DataPassword], [Organization].[DataServerName], [Organization].[Description], [Organization].[EmailSettings], [Organization].[LanguageId], [Organization].[ManagerId], [Organization].[ModifiedByName], [Organization].[ModifiedOn], [Organization].[Name], [Organization].[OrganizationId], [Organization].[SmsSettings], [Organization].[StateCode], [Organization].[StatusCode], [Organization].[UniqueName], [lk_Organization_BaseCurrencyId].[Name] AS BaseCurrencyIdName FROM [Organization] WITH(NOLOCK) LEFT JOIN [Currency] AS [lk_Organization_BaseCurrencyId] WITH(NOLOCK) ON [Organization].[BaseCurrencyId]=[lk_Organization_BaseCurrencyId].[CurrencyId] GO