DataTable结构.txt

using System;
using System.Data;

namespace ProductManager
{
    static class ClassTable
    {
        private static DataSet dataSet;
        private static DataTable worker, provider, product, productBuy, productSell, productIn, productOut;

        #region ClassTable
        static ClassTable()
        {
            dataSet = new DataSet("ProductSet");
            dataSet.Locale = System.Globalization.CultureInfo.InvariantCulture;

            worker = dataSet.Tables.Add("Worker");
            string[] columns = { "WorkerID", "WorkerName", "DepartmentName", "Sex", "Jiguan", "Minzu", "Xueli", "CardID", "Single", "Phone", "TEL", "Address" };
            foreach (string name in columns)
            {
                worker.Columns.Add(name, typeof(string));
            }
            worker.Columns.Add("Birthday", typeof(DateTime));
            worker.Columns.Add("Age", typeof(byte));
            worker.Columns.Add("DataImage", typeof(byte[]));

            provider = dataSet.Tables.Add("Provider");
            columns = new string[] { "ProviderID", "ProviderName", "Linkman", "Email", "Bank", "LinkPhone", "Fax", "Address", "BankAccount", "Memo" };
            foreach (string name in columns)
            {