快过年了，工作不怎么忙，闲来无事，把BI中客户端显示用silverlight图表实现了一下，思路还是老一套，ado.net读取数据，wcf推送数据，silverlight显示。
不废话，晒解决方案
为了最大化减少数据的传输量，我们采取服务端集中抓取数据，然后客户端用linq实现数据筛选，重新定义显示实体类，实现数据绑定
服务端同样新建一个实体类,根据返回的数据集合
// 使用下面示例中说明的数据约定将复合类型添加到服务操作。
[DataContract]
public class ProjectDistributed
{
[DataMember]
public int proj_unid { set; get; }
[DataMember]
public string projid { set; get; }
[DataMember]
public string cname { set; get; }
[DataMember]
public string projstatus { set; get; }
[DataMember]
public string projtype { set; get; }
[DataMember]
public int projtypecount { get; set; }
[DataMember]
public int Days { set; get; }
[DataMember]
public int functionnum { set; get; }
[DataMember]
public int realworkload { set; get; }
}
新建服务契约，并实现：
[ServiceContract]
public interface IService1
{
[OperationContract]
List<ProjectDistributed> GetData(int value);
}
namespace WcfService1
{
// 注意: 使用“重构”菜单上的“重命名”命令，可以同时更改代码和配置文件中的类名“Service1”。
public class Service1 : IService1
{
public List<ProjectDistributed> GetData(int value)
{
StringBuilder sqlString = new StringBuilder();
sqlString.Append(" select proj_unid,projid,cname,projstatus,projtype,Days,functionnum,realworkload as realworkload from Func_GetProjectDistributed('2006/1/1', GETDATE()) where dept_unid in ( select dept_unid from View_DepartmentName) and projtype in (select projtype from View_ProjectType) and projstatus in ( select projstatus from View_ProjectStatus )");
List<ProjectDistributed> myCL = null;
ProjectDistributed myOnePro = null;
using (SqlDataReader SDR = SqlHelper.ExecuteReader(SqlHelper.ConnectionString, CommandType.Text, sqlString.ToString()))
{
myCL = new List<ProjectDistributed>();
while (SDR.Read())
{
myOnePro = new ProjectDistributed();
myOnePro.projid = SDR["projid"].ToString();
myOnePro.cname = SDR["cname"].ToString();
myOnePro.Days = Convert.ToInt32(SDR["Days"].ToString());
myOnePro.functionnum = Convert.ToInt32(SDR["functionnum"].ToString());
myOnePro.proj_unid = Convert.ToInt32(SDR["proj_unid"].ToString());
myOnePro.projstatus = SDR["proj_unid"].ToString();
myOnePro.realworkload = Convert.ToInt32(SDR["realworkload"].ToString());
myOnePro.projtype = SDR["projtype"].ToString();
//myOnePro.projtypecount = Convert.ToInt32(SDR["projtypecount"]);
myCL.Add(myOnePro);
}
}
return myCL;
}
}
}
公开服务，本来我本打算采用tcp协议传输的，优点不用说，但是调试了半天没通过，最后采用http协议，这个简单，记住加跨域文件，自定义binging实现数据量的增加：
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<connectionStrings>
<add name="DataConnectionString" connectionString="Data Source=WUXUELEI\MSSQLSERVER2008;Initial Catalog=kmswork;User ID=sa;Password=wuxuelei" providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.web>
<compilation debug="true" targetFramework="4.0" />
</system.web>
<system.serviceModel>
<services>
<service behaviorConfiguration="mybehavior" name="WcfService1.Service1">
<host>
<baseAddresses>
<add baseAddress="http://localhost:8732/Design_Time_Addresses/WcfServiceLibrary1/Service1/"/>
</baseAddresses>
</host>
<!-- Service Endpoints -->
<!-- 除非完全限定，否则地址将与上面提供的基址相关 -->
<endpoint address="" bindingConfiguration="higherMessageSize" binding="basicHttpBinding" contract="WcfService1.IService1">
<!--
部署时，应删除或替换下列标识元素，以反映
用来运行所部署服务的标识。删除之后，WCF 将
自动推断相应标识。
-->
<identity>
<dns value="localhost"/>
</identity>
</endpoint>
<!-- Metadata Endpoints -->
<!-- 元数据交换终结点供相应的服务用于向客户端做自我介绍。 -->
<!-- 此终结点不使用安全绑定，应在部署前确保其安全或将其删除-->
<endpoint address="mex" binding="mexHttpBinding" contract="IMetadataExchange"/>
</service>
</services>
<behaviors>
<serviceBehaviors>
<behavior name="mybehavior">
<!-- 为避免泄漏元数据信息，
请在部署前将以下值设置为 false 并删除上面的元数据终结点 -->
<serviceMetadata httpGetEnabled="true"/>
<!-- 要接收故障异常详细信息以进行调试，
请将以下值设置为 true。在部署前设置为 false
以避免泄漏异常信息-->
<serviceDebug includeExceptionDetailInFaults="true"/>
</behavior>
</serviceBehaviors>
</behaviors>
<bindings>
<basicHttpBinding>
<binding name="higherMessageSize"
maxBufferSize="2147483647"
maxBufferPoolSize="2147483647"
maxReceivedMessageSize="2147483647"/>
</basicHttpBinding>
</bindings>
<serviceHostingEnvironment multipleSiteBindingsEnabled="true" />
</system.serviceModel>
<system.webServer>
<modules runAllManagedModulesForAllRequests="true"/>
</system.webServer>
</configuration>
客户端很简单，拖上控件，后台读取数据显示就行，记住先添加服务引用，生成客户端代码类：
<Grid x:Name="LayoutRoot" Background="White">
<toolkit:Chart HorizontalAlignment="Left" Margin="37,36,0,0" Name="Mychart" Title="中心类型项目分布" VerticalAlignment="Top" Height="352" Width="427">
</toolkit:Chart>
</Grid>
void client_GetDataCompleted(object sender, MyService.GetDataCompletedEventArgs e)
{
if (e.Error == null)
{
List<ProjectDistributed> myResult = e.Result.ToList<ProjectDistributed>();
myAxis axis = new myAxis()
{
FontStyle = FontStyles.Normal,
FontSize = 12f
};
PieSeries series = new PieSeries();
System.Collections.Generic.IEnumerable<Model> mySource = new List<Model>();
mySource = from p in myResult
group p by p.projtype
into g
select new Model
{
projtype = g.Key,
projtypecount = g.Count()
};
//myResult = myResult.GroupBy(p => p.projtype).
// Select
// (k => new Model
// {
// projtype = k.Key,
// projtypecount = k.Count()
// });
series.ItemsSource = mySource;
series.IndependentValueBinding = new System.Windows.Data.Binding("projtype");
series.DependentValueBinding = new System.Windows.Data.Binding("projtypecount");
series.AnimationSequence = AnimationSequence.LastToFirst;
Mychart.Series.Add(series);
}
else
MessageBox.Show(e.Error.ToString());
}
挺简单的一个实例，主要是思路，权作自己笔记只用，晒下结果，我们采用OOB模式：
呵呵..就到这里，上传下源码