using System;
using System.Data;
using System.Runtime.Serialization;

namespace qminoa.Common.Data
{
	/// <summary>
	/// Filemess 的摘要說明。
	/// </summary>
	[System.ComponentModel.DesignerCategory("Code")]
	[SerializableAttribute] 
	public class Filemessdata:DataSet
	{
		//
		//daFileInfo Table constants
		//
		public const String DAFILEINFO_TABLE = "daFileInfo";
		public const String DAFILEINFO_FILE_ID = "FileID";
		public const String TITLE_FIELD = "Title";
		public const String SUB_TITLE_FIELD = "SubTitle";
		public const String KEYWORD_FIELD = "Keyword";
		public const String FILE_NUMBER_FIELD = "FileNumber";
		public const String PRINCIPAL_FIELD = "Principal";
		public const String DAFILEINFO_CDATE_FIELD = "CDate";
		public const String SECRET_FIELD = "Secret";
		public const String CATEGORY_FIELD = "Category";
		public const String SAVE_TIME_FIELD = "SaveTime";
		public const String VIEW_FLAG_FIELD = "ViewFlag";
		public const String DAFILEINFO_FILE_TYPE_FIELD = "FileType";
		public const String NOTE_FIELD = "Note";
		public const String FILECONT_FIELD = "FileCont";
		public const String COLCLEAR_FIELD = "Colclear";

		//
		//daFilecont Table constants
		//
		public const String DAFILECONT_TABLE = "daFilecont";
		public const String DAFILECONT_ID = "ID";
		public const String DAFILECONT_FILE_ID = "FileID";
		public const String FILE_NAME_FIELD = "FileName";
		public const String SIZE_FIELD = "Size";
		public const String DAFILECONT_CDATE_FIELD = "CDate";
		public const String DAFILECONT_FILE_TYPE_FIELD = "FileType";
		public const String FILE_PATH_FIELD = "FilePath";
		public const String CONT_FIELD = "Cont";
		public const String FILE_FLAG_FIELD = "FileFlag";

		public Filemessdata()
		{
			BuildTables();
		}
		public void BuildTables()
		{
			DataTable table;
			DataColumnCollection columns;
			//
			//create daFileInfo Table
			//
			table = new DataTable(DAFILEINFO_TABLE);
			columns = table.Columns;

			columns.Add(DAFILEINFO_FILE_ID,typeof(System.Int32));
			columns.Add(TITLE_FIELD,typeof(System.String));
			columns.Add(SUB_TITLE_FIELD,typeof(System.String));
			columns.Add(KEYWORD_FIELD,typeof(System.String));
			columns.Add(FILE_NUMBER_FIELD,typeof(System.String));
			columns.Add(PRINCIPAL_FIELD,typeof(System.String));
			columns.Add(DAFILEINFO_CDATE_FIELD,typeof(System.DateTime));
			columns.Add(SECRET_FIELD,typeof(System.Int32));
			columns.Add(CATEGORY_FIELD,typeof(System.Int32));
			columns.Add(SAVE_TIME_FIELD,typeof(System.Int32));
			columns.Add(VIEW_FLAG_FIELD,typeof(System.Boolean));
			columns.Add(DAFILEINFO_FILE_TYPE_FIELD,typeof(System.Byte));
			columns.Add(NOTE_FIELD,typeof(System.String));
			columns.Add(FILECONT_FIELD,typeof(System.String));
			columns.Add(COLCLEAR_FIELD,typeof(System.Byte));

			this.Tables.Add(table);
			//
			//create daFileCont Table
			//
			table = new DataTable(DAFILECONT_TABLE);
			columns = table.Columns;

			columns.Add(DAFILECONT_ID,typeof(System.Int32));
			columns.Add(DAFILECONT_FILE_ID,typeof(System.Int32));
			columns.Add(FILE_NAME_FIELD,typeof(System.String));
			columns.Add(SIZE_FIELD,typeof(System.Int32));
			columns.Add(DAFILECONT_CDATE_FIELD,typeof(System.DateTime));
			columns.Add(DAFILECONT_FILE_TYPE_FIELD,typeof(System.String));
			columns.Add(FILE_PATH_FIELD,typeof(System.String));
			columns.Add(CONT_FIELD,typeof(System.Byte[]));
			columns.Add(FILE_FLAG_FIELD,typeof(System.Boolean));

			this.Tables.Add(table);
		}
	}
}