namespace DataRead.Data
{
using System;
using System.Data;
using System.Runtime.Serialization;
/// <summary>
/// OrderRequestData继承DataSet类
/// </summary>
//[SerializableAttribute]
public class OrderRequestData : DataSet
{
public DataTable OrderRequestTable;
public DataTable OrderTable;
public DataTable OrderDetailTable;
/// <summary>
/// Table OrderRequestData
/// </summary>
public const String SessionID_OrderRequestData = "sessionID";
/// <summary>
/// Table Order
/// </summary>
public const String Values_Order = "values";
public const String CustomerNo_Order = "customerNo";
public const String Remark_Order = "remark";
public const String RequireDate_Order = "requireDate";
public const String OrderNo_Order = "orderNo";
/// <summary>
/// Table OrderDetail
/// </summary>
///
public const String ProducetNo_OrderDetail = "productNo";
public const String Price_OrderDetail = "price";
public const String Quantity_OrderDetail = "quantity";
public const String Remark_OrderDetail = "remark";
public const String OrderNo_OrderDetail = "orderNo";
public const String LineNo_OrderDetail = "lineNo";
public const String Discount_OrderDetail = "discount";
public OrderRequestData(SerializationInfo info, StreamingContext context) : base(info, context)
{
}
public OrderRequestData()
{
BuildDataTables();
}
private void BuildDataTables()
{
//建立表 OrderRequestData 结构
OrderRequestTable = new DataTable("OrderRequestData");
DataColumnCollection oRColumn = OrderRequestTable.Columns;
oRColumn.Add( SessionID_OrderRequestData,typeof(System.String));
oRColumn.Add( "OrderRequestData_Id",typeof(System.Int32));
this.Tables.Add(OrderRequestTable);
this.Tables["OrderRequestData"].Columns["OrderRequestData_Id"].ColumnMapping = MappingType.Hidden;
this.Tables["OrderRequestData"].Columns["OrderRequestData_Id"].AutoIncrement =true;
//建立表 Order 结构
OrderTable = new DataTable("Order");
DataColumnCollection orderColumn = OrderTable.Columns;
orderColumn.Add( "OrderRequestData_Id",typeof(System.Int32));
orderColumn.Add( Values_Order,typeof(System.String));
orderColumn.Add( CustomerNo_Order,typeof(System.String));
orderColumn.Add( Remark_Order,typeof(System.String));
orderColumn.Add( RequireDate_Order,typeof(System.String));
orderColumn.Add( OrderNo_Order,typeof(System.String));
this.Tables.Add(OrderTable);
this.Tables["Order"].Columns["OrderRequestData_Id"].ColumnMapping = MappingType.Hidden;
this.Tables["Order"].Columns["OrderRequestData_Id"].AutoIncrement = true;
//建立表 OrderDetail 结构
OrderDetailTable = new DataTable("OrderDetail");
DataColumnCollection orderDetailColumn = OrderDetailTable.Columns;
orderDetailColumn.Add( ProducetNo_OrderDetail,typeof(System.String));
orderDetailColumn.Add( Price_OrderDetail,typeof(System.String));
orderDetailColumn.Add( Quantity_OrderDetail,typeof(System.String));
orderDetailColumn.Add( Remark_OrderDetail,typeof(System.String));
orderDetailColumn.Add( OrderNo_OrderDetail,typeof(System.String));
orderDetailColumn.Add( LineNo_OrderDetail,typeof(System.String));
orderDetailColumn.Add( Discount_OrderDetail,typeof(System.String));
this.Tables.Add(OrderDetailTable);
//建立表关系
this.Relations.Add("Order_OrderDetail",this.Tables["Order"].Columns["orderNo"],this.Tables["OrderDetail"].Columns["orderNo"]);
this.Relations["Order_OrderDetail"].Nested = true;
this.Relations.Add("OrderRequestData_Order",this.Tables["OrderRequestData"].Columns["OrderRequestData_Id"],this.Tables["Order"].Columns["OrderRequestData_Id"]);
this.Relations["OrderRequestData_Order"].Nested = true;
}
}
}
Xml文件结构如下
<?xml version="1.0" standalone="yes" ?>