三层框架加WCF的实现.docx

三层框架加WCF的实现实现三层框架加WCF的原因是三层框架直接暴露了数据库的连接给客户端，程序如果是广域网部署必然需要把数据库暴露在广域网，容易招致攻击，在三层架构中加入WCF就能通过WCF连接数据库从而避免上述问题。不管UI采用的是那种方式这种方法都适用，本例的目的是演示完整的三层框架加WCF的实现。整体的架构如下：关键代码：LovIServicenamespace LovWcfServiceLibrary{ [ServiceContract] public interface LovIService { /// summary /// 获取最大值 /// /summary /// param name=FieldName字段/param /// param name=TableName表名/param /// returns/returns [OperationContract] int GetMaxID(string str); /// summary /// 记录是否存在 /// /summary /// param name=strSqlSQL/param /// param name=cmdParms参数/param /// returns/returns [OperationContract] bool Exists(string str); /// summary /// 执行一条计算查询结果语句，返回查询结果（object） /// /summary /// param name=SQLStringSQLString/param /// returns/returns [OperationContract] object GetSingle(string StrSql); [OperationContract] object GetSingleTimeOut(string StrSql); [OperationContract] object GetSingleAdd(string str); /// summary /// 执行SQL语句，返回影响的记录数 /// /summary /// param name=SQLStringSQL语句/param /// param name=cmdParms影响的记录数/param /// returns/returns [OperationContract] int ExecuteSql(string str); /// summary /// 执行查询语句，返回DataSet /// /summary /// param name=SQLString查询语句/param /// returnsDataSet/returns [OperationContract] DataSet Query(string str); /// summary /// 执行查询语句，返回DataSet /// /summary /// param name=SQLString查询语句/param /// returnsDataSet/returns [OperationContract] DataSet QueryDataSet(string StrSql); /// summary /// 执行SQL语句，返回影响的记录数 /// /summary /// param name=SQLStringSQL语句/param /// returns影响的记录数/returns [OperationContract] int ExecuteSqlString(string StrSql); /// summary /// 获取一个Datatable /// /summary /// param name=SQLString/param /// returns/returns [OperationContract] DataTable QueryDataTable(string StrSql); /// summary /// 执行更新、删除操作，返回影响行数 /// /summary /// param name=sqlsql/param /// returns返回影响行数/returns [OperationContract] int UpdateInsert(string StrSql); [OperationContract] bool SaveDataTable(string StrSql); [OperationContract] CompositeType GetDataUsingDataContract(CompositeType composite); }namespa