createtableprofitanalyse.cs

《C#数据库项目案例导航》一书的配套光盘

using System;
using System.Data;
using System.Data.SqlClient;
using Sale.DataLevel;

namespace Sale.BussinessRule
{
	/// <summary>
	/// CreateTableProfitAnalyse 的摘要说明。
	/// </summary>
	public class CreateTableProfitAnalyse
	{
		public DataTable ProfitAnalyse=new DataTable();
		//创建新DataTable实例ProfitAnalyse
		public DataColumn  ProID;
		public DataColumn  TotalNumber;
		public DataColumn  TotalProfit;
		//声明三个DataColum

		public CreateTableProfitAnalyse()
		{
			ProID = new DataColumn();
			//创建DataColum ProID
			ProID.DataType=typeof(string);
			//设置DataColumn ProID的数据类型
			ProID.ColumnName = "ProID";
			//设置DataColumn ProID的Name			
			ProID.Caption = "商品号码";
			//Datacolum的Caption			
			ProID.ReadOnly = true;
			ProID.Unique = true;
			//设置DataColumn的 ReadOnly和Unique约束
			ProfitAnalyse.Columns.Add(ProID);
			//把DataColumn ProID添加到DataTable ProfitAnalyse
			
			TotalNumber = new DataColumn();
			TotalNumber.DataType =typeof(int);
			TotalNumber.ColumnName = "TotalNumber";		    
			TotalNumber.Caption = "销售总量";
			TotalNumber.ReadOnly = true;
			TotalNumber.Unique = false;			
			ProfitAnalyse.Columns.Add(TotalNumber);
			//完成DataColumn TotalNumber的创建并添加到DataTable ProfitAnalyse

			TotalProfit = new DataColumn();
			TotalProfit.DataType = typeof(float);
			TotalProfit.ColumnName = "TotalProfit";			
			TotalProfit.Caption = "销售利润";
			TotalProfit.ReadOnly = true;
			TotalProfit.Unique = false;			
			ProfitAnalyse.Columns.Add(TotalProfit);
			//完成DataColumn TotalProfit的创建并添加到DataTable ProfitAnalyse
			
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		
	}
}