C#中Enterprise Services（微软应用程序服务器）技术(三)

接上一讲内容，这里再介绍一个Enterprise Services里的一个特殊情况：没有组件的服务。

创建没有组件配置的COM+环境(WindowXP SP2/Windows Server 2003以上支持)，能很容易利用事务处理和同步服务，既不需要派生于基类ServicedComponent，也不需要配置程序集。该环境可以在一个方法中创建，且不需要定义类的环境要求。因为不同的方法可以有不同的环境要求，类也可以有任意基类。（没有组件的服务的核心是ServiceConfig和ServiceDomain类。ServiceConfig用于配置操作执行所需的环境，ServiceDomain用于创建ServiceConfig描述的环境。）

先看看工程布局：

组件服务端代码如下：

OderLineData.cs

#region Using directives using System; using System.Collections.Generic; using System.Text; using System.Data.SqlClient; using System.EnterpriseServices; using System.Configuration; #endregion namespace Wrox.ProCSharp.EnterpriseServices { public interface IOrderLineUpdate { void Insert(int orderId, OrderLine orderDetail); } public class OrderLineData : IOrderLineUpdate { private string connectionString = null; public OrderLineData() { string connectionString = ConfigurationSettings.AppSettings["NorthwindConnection"]; this.connectionString = connectionString; } public void Insert(int orderId, OrderLine orderDetail) { ServiceConfig serviceConfig = new ServiceConfig(); serviceConfig.Transaction = TransactionOption.Required; ServiceDomain.Enter(serviceConfig); SqlConnection connection = new SqlConnection(connectionString); try { SqlCommand command = connection.CreateCommand(); command.CommandText = "INSERT INTO [Order Details] (OrderId, " + "ProductId, UnitPrice, Quantity)" + "VALUES(@OrderId, @ProductId, @UnitPrice, @Quantity)"; command.Parameters.AddWithValue("@OrderId", orderId); command.Parameters.AddWithValue("@ProductId", orderDetail.ProductId); command.Parameters.AddWithValue("@UnitPrice", orderDetail.UnitPrice); command.Parameters.AddWithValue("@Quantity", orderDetail.Quantity); connection.Open(); command.ExecuteNonQuery(); ContextUtil.SetAbort(); // ContextUtil.SetComplete(); } catch { ContextUtil.SetAbort(); throw; } finally { connection.Close(); ServiceDomain.Leave(); } } } }

Order.cs

#region Using directives using System; using System.Collections.Generic; using System.Text; #endregion namespace Wrox.ProCSharp.EnterpriseServices { public class Order { public static Order Create(string customerId, DateTime orderDate, string shipAddress, string shipCity, string shipCountry) { Order o = new Order(); o.customerId = customerId; o.orderDate = orderDate; o.shipAddress = shipAddress; o.shipCity = shipCity; o.shipCountry = shipCountry; return o; } public Order() { } internal void SetOrderId(int orderId) { this.orderId = orderId; } public void AddOrderLine(OrderLine orderLine) { orderLines.Add(orderLine); } private int orderId; private string customerId; private DateTime orderDate; private string shipAddress; private string shipCity; private string shipCountry; private List<OrderLine> orderLines = new List<OrderLine>(); public int OrderId { get { return orderId; } } public string CustomerId { get { return customerId; } } public DateTime OrderDate { get { return orderDate; } } public string ShipAddress { get { return shipAddress; } } public string ShipCity { get { return shipCity; } } public string ShipCountry { get { return shipCountry; } } public OrderLine[] OrderLines { get { OrderLine[] ol = new OrderLine[orderLines.Count]; orderLines.CopyTo(ol); return ol; } } } }

OrderControl.cs

#region Using directives using System; using System.Collections.Generic; using System.Text; using System.EnterpriseServices; #endregion namespace Wrox.ProCSharp.EnterpriseServices { public interface IOrderControl { void NewOrder(Order order); } public class OrderControl { public void NewOrder(Order order) { ServiceConfig serviceConfig = new ServiceConfig(); serviceConfig.Transaction = TransactionOption.Required; serviceConfig.TransactionTimeout = 1200; ServiceDomain.Enter(serviceConfig); try { OrderData data = new OrderData(); data.Insert(order); ContextUtil.SetComplete(); } catch (Exception) { ContextUtil.SetAbort(); throw; } finally { ServiceDomain.Leave(); } } } }

OrderData.cs

#region Using directives using System; using System.Collections.Generic; using System.Text; using System.Data.SqlClient; using System.EnterpriseServices; using System.Configuration; #endregion namespace Wrox.ProCSharp.EnterpriseServices { public interface IOrderUpdate { void Insert(Order order); } public class OrderData : IOrderUpdate { private string connectionString = null; public OrderData() { string connectionString = ConfigurationSettings.AppSettings["NorthwindConnection"]; this.connectionString = connectionString; } [AutoComplete()] public void Insert(Order order) { ServiceConfig serviceConfig = new ServiceConfig(); serviceConfig.Transaction = TransactionOption.Required; serviceConfig.TransactionDescription = "Demo Transaction"; ServiceDomain.Enter(serviceConfig); SqlConnection connection = new SqlConnection(connectionString); try { SqlCommand command = connection.CreateCommand(); command.CommandText = "INSERT INTO Orders (CustomerId, OrderDate, " + "ShipAddress, ShipCity, ShipCountry)" + "VALUES(@CustomerId, @OrderDate, @ShipAddress, @ShipCity, " + "@ShipCountry)"; command.Parameters.AddWithValue("@CustomerId", order.CustomerId); command.Parameters.AddWithValue("@OrderDate", order.OrderDate); command.Parameters.AddWithValue("@ShipAddress", order.ShipAddress); command.Parameters.AddWithValue("@ShipCity", order.ShipCity); command.Parameters.AddWithValue("@ShipCountry", order.ShipCountry); connection.Open(); command.ExecuteNonQuery(); command.CommandText = "SELECT @@IDENTITY AS 'Identity'"; object identity = command.ExecuteScalar(); order.SetOrderId(Convert.ToInt32(identity)); OrderLineData updateOrderLine = new OrderLineData(); foreach (OrderLine orderLine in order.OrderLines) { updateOrderLine.Insert(order.OrderId, orderLine); } // ContextUtil.SetComplete(); } catch { // ContextUtil.SetAbort(); throw; } finally { connection.Close(); ServiceDomain.Leave(); } } } }

OrderLine.cs

#region Using directives using System; using System.Collections.Generic; using System.Text; #endregion namespace Wrox.ProCSharp.EnterpriseServices { [Serializable] public class OrderLine { public static OrderLine Create(int productId, float unitPrice, int quantity) { OrderLine detail = new OrderLine(); detail.productId = productId; detail.unitPrice = unitPrice; detail.quantity = quantity; return detail; } public OrderLine() { } private int productId; private float unitPrice; private int quantity; public int ProductId { get { return productId; } set { productId = value; } } public float UnitPrice { get { return unitPrice; } set { unitPrice = value; } } public int Quantity { get { return quantity; } set { quantity = value; } } } }

 

客户端代码：

#region Using directives using System; using System.Collections.Generic; using System.Text; using Wrox.ProCSharp.EnterpriseServices; using System.Configuration; #endregion namespace Client { class Program { static void Main(string[] args) { // Configuration c = Configuration.GetExeConfiguration("Client.exe", ConfigurationUserLevel.None); // string connectionString = c.AppSettings.Settings["NorthwindConnection"]; // // string connectionString = ConfigurationSettings.AppSettings["NorthwindConnection"]; // // Properties.Settings.Value.NorthwindConnection try { Order order = Order.Create("VINET", DateTime.Today, "TomTom", "Somecity", "Austria"); order.AddOrderLine(OrderLine.Create(16, 17.45F, 2)); order.AddOrderLine(OrderLine.Create(33, 14, 1)); OrderControl orderControl = new OrderControl(); orderControl.NewOrder(order); } catch (Exception ex) { Console.WriteLine(ex.Message); } Console.WriteLine("Transaction completed"); Console.ReadLine(); } } }