reporting services 2008的报表使用Resource File中的多语言信息

声明: 本文算是半原创,idea是公司另一个同事想出来的,但他的方案比较高阶,我细化了,也把遇到的问题都解决了,基于VS.NET2008和Reporting Services2008

目的:? 实现reporting services 2008的报表(多语言)使用Resource file中的多语言信息

方案: ?用web service读取resource file,再用一个DLL的类来调用这个web service,把DLL复制到reporting service和vs.net2008的相应安装目录,在报表中引用这个DLL,并用vbscript调用DLL里封装的获取多语言的方法

?

步骤:

1.?????? 建立一个WebApplication1,在里边加资源文件和一个web service

?

?

?

2. 在web service类中加入方法,此方法就是从resx中按id和lang code读取,在初次load resx这个xml文件时,就放到缓存中

??????? [WebMethod]

??????? public string GetLabel(string msgID,string langCode)

??????? {

??????????? string returnVal = "";

??????????? //string localResrouceFile = "../App_LocalResources/Default.aspx.resx";

??????????? string localResrouceFile = System.Web.Hosting.HostingEnvironment.MapPath(System.Web.Hosting.HostingEnvironment.ApplicationVirtualPath + @"/App_LocalResources/" + "Default.aspx.resx");

?

??????????? XElement doc = (XElement)HttpRuntime.Cache.Get("ResourceCacheKey");

??????????? if (doc == null)

??????????? {

??????????????? doc = XElement.Load(localResrouceFile);

? ??????????????//System.Web.Caching.Cache c = new System.Web.Caching.Cache();

??????????????? HttpRuntime.Cache.Add("ResourceCacheKey",doc,null,

??????????????????????? DateTime.Now.AddDays(1),System.Web.Caching.Cache.NoSlidingExpiration,

?????????????? ?????????System.Web.Caching.CacheItemPriority.Default,null);

??????????? }

???????????

??????????? var resource = from pn in doc.Descendants("data")

?????????????????????????? where (string)pn.Attribute("name") == msgID

?????????????????????????? select pn; //.Descendants("value");

?

??????????? if (resource.Count() < 1)

??????????? {

??????????????? //doc = XElement.Load(globalResrouceFile);

??????????????? //resource = from pn in doc.Descendants("data")

??????????????? //?????????? where (string)pn.Attribute("name") == msgID

??????????????? //?????????? select pn; //.Descendants("value");

?

??????????????? returnVal = "没有找到id是:" + msgID + "的资源";

??????????? }

??????????? else

??????????? {

??????????????? returnVal = resource.First().Value;

??????????? }

?

??????????? return returnVal;

??????? }

?

?

?

?

?

?

3.??? 建立类库并命名为GetResourceLib,?并”Add Web Reference”,加入步骤1中所建的web service

在类Class1中加入方法

?

?

????????public static string GetMessage(string msgID,string langCode)

??????? {??

??????????? using (WebReference.WebService1 w = new GetResourceLib.WebReference.WebService1())

??????????? {

??????????????? string path = "";

??????????????? try

??????????????? {

??????????????????? //string serviceUrl = ConfigurationManager.AppSettings["WebServiceKey "].ToString()

??????????????????? //Assembly myAssembly = Assembly.GetExecutingAssembly();

??????????????????? path = AppDomain.CurrentDomain.RelativeSearchPath;

???????????????????????????? //D:/Program Files/Microsoft SQL Server/MSRS10.MSSQLSERVER/Reporting Services/ReportServer/bin/GetResourceLib.dll.config

??????????????????? //path = @"D:/Program Files/Microsoft SQL Server/MSRS10.MSSQLSERVER/Reporting Services/ReportServer/bin";

??????????????????? path += @"/GetResourceLib.dll.config";

??????????????????? string[] pathList = path.Split(new char[]{';'});

??????????????????? if (pathList.Length > 1)

??????????????????? {

??????????????????????? path = pathList[1];

??????????????????? }

???????????????????

?

??????????????????? XElement doc = XElement.Load(path);

??????????????????? var filePaths = from setting in doc.Descendants("setting")

??????????????????????????????????? where (string)setting.Attribute("name") == "GetResourceLib_WebReference_WebService1"

??????????????????????????????????? select setting; //.Descendants("value");

?

??????????????????? //string serviceUrl = filePaths.First().Value;

??????????????????? string serviceUrl = filePaths.First().Element(XName.Get("value")).Value;

??????????????????? string userName = filePaths.First().Element(XName.Get("UserName")).Value;

??????????????????? string password = filePaths.First().Element(XName.Get("Password")).Value;

??????????????????? string domain = filePaths.First().Element(XName.Get("Domain")).Value;

??????????????????? //System.Windows.Forms.Application.CommonAppDataPath

??????????????????? w.Url = serviceUrl;

??????????????????? //在reporting service里调用这个web service的方法,会出现"无法连接到远程服务器"的问题,是防火墙的问题,开放Web Server(HTTP)就可以了

??????????????????? //下边两用,一种是指定web application的impersonate用户,一种是用default的credentials 都可以

??????????????????? //20100527: 在把web service部署到别的电脑后,发现用default的credentials是不可以的,所以只能用指定用户名,密码和域的做法(也从config取)

??????????????????? //System.Net.NetworkCredential n = new System.Net.NetworkCredential("apjuser","apj","APJ");

??????????????????? System.Net.NetworkCredential n = new System.Net.NetworkCredential(userName,password,domain);

??????????????????? w.Credentials = n;

??????? ????????????//w.Credentials = System.Net.CredentialCache.DefaultCredentials; //

??????????????? }

??????????????? catch(Exception ex)

??????????????? {

??????????????????? return ex.Message + "--1---" + path;

??????????????? }

?

??????????????? return w.GetLabel(msgID,langCode);

??????????? }

??????? }

?

?

?

同时修改app.config文件,在<setting 节点下加多UserName,Password,Domain 三个值,用于动态配置credentials时用

?

??????????? <setting name="GetResourceLib_WebReference_WebService1" serializeAs="String">

??????????????? <value>http://10.199.130.7/GetResourceLibWebApp/WebService1.asmx</value>

??????????????? <UserName>apjuser</UserName>

??????????????? <Password>apj</Password>

??????????????? <Domain>APJ</Domain>

??????? </setting>

?

?

???????

?

把这个类库编译后,把DLL和生成的config文件GetResourceLib.dll.config复制到reporting service的安装目录D:/Program Files/Microsoft SQL Server/MSRS10.MSSQLSERVER/Reporting Services/ReportServer/bin下也同时把它复制到vs.net 2008的安装目录D:/Program Files/Microsoft Visual Studio 9.0/Common7/IDE/PrivateAssemblies下.

?

?

?

?

?

同时,为了能在vs.net2008的报表设计画面中也能成功的preview一个报表,还需要在D:/Program Files/Microsoft Visual Studio 9.0/Common7/IDE/PrivateAssemblies下修改文件RSPreviewPolicy.config,和上边文件rssrvpolicy.config同样改法,但Url值就要改成本目录路径下的值了.

?

?

?

5.??? 建立报表项目” 报表项目1”,在下边新建一个报表Report1.rdl,拖一个textbox到报表体中

?

点击vs.net的菜单”报表”à”报表属性”

在”References”中加入刚才复制到D:/Program Files/Microsoft SQL Server/MSRS10.MSSQLSERVER/Reporting Services/ReportServer/bin下的GetResourceLib.dll的引用并在Class Name中输入GetResourceLib.Class1和在Instance Name中输入c

?

?

在”Code”中输入vbscript:

Public Function GetLabel(labelID as String,langCode as String) as String

?

Try??

?

Return c.GetMessage(LabelID,langCode)

?

Catch ex as Exception

?

Return ex.Message

?

End Try

?

End Function

?

?

?

?

?

?

6. 以上五步完成后部署到报表服务器可以成功实现目的

?

?

?

?

?

7.????? 以上所有的操作都在同一台电脑上进行,为了模似真实环境,webapplication(web service)和报表都放到不同的电脑上.?

???a) 报表放到其它电脑上由于报表和web service不在同一电脑会出现一些问题

????????? "无法连接到远程服务器"

?

?

??????? 上图的问题是由于web service所在的电脑的防火墙没有开放Web Server(HTTP)导致

?

???b) 由于步骤3中有一句代码path = AppDomain.CurrentDomain.RelativeSearchPath;在vs.net2008的报表设计界面中preview时有时会提示找不到D:/ GetResourceLib.dll.config或E:/ GetResourceLib.dll.config等等只要把这个config文件复制到相应盘符下就可以解决

?

---------------------------------------------------------------------------------------------------------------------------end------------

?

?

?

“OK”后,?在报表的textbox的expression中输入

=Code.GetLabel("Label2.Text","1")

?

4.?????? 回到目录D:/Program Files/Microsoft SQL Server/MSRS10.MSSQLSERVER/Reporting Services/ReportServer,打开文件rssrvpolicy.config,?在该文件中查找文本Name="Report_Expressions_Default_Permissions"将其上面一行内容修改为PermissionSetName="FullTrust",其次还需在该文件（rssrvpolicy.config）的倒数第2个</CodeGroup>前增加一段引用自定义程序集的内容：

??????????????????????????? <CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="FullTrust" Description="This special code group grants RSCustomLib.dll FUllTrust permission. ">

???????????????????????????? ?<IMembershipCondition class="UrlMembershipCondition" version="1" Url="D:/Program Files/Microsoft SQL Server/MSRS10.MSSQLSERVER/Reporting Services/ReportServer/bin/GetResourceLib.dll" />

??????????????????????????? </CodeGroup>