using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Text;
using?System.Windows.Forms;
using?System.IO;

namespace?Access版的代碼生成器
{
????public?partial?class?Form1?:?Form
????{
????????public?Form1（）
????????{
????????????InitializeComponent（）;
????????}
????????#region
????????///?

????????///?查詢出數據庫中的表，并添加
????????///?

????????///?
????????///?
????????private?void?buttonAdd_Click（object?sender?EventArgs?e）
????????{
????????????//Provider=Microsoft.Jet.OLEDB.4.0;Data?Source=F:\FineYear.mdb
????????????SqlHelper.ConnString?=?textbConString.Text;
????????????clbTables.Items.Clear（）;
????????????string?sql?=?“select?*?from?INFORMATION_SCHEMA.TABLES“;
????????????DataTable?tab?=?SqlHelper.GetDataTable（sql）;
????????????foreach?（DataRow?row?in?tab.Rows）
????????????{
????????????????clbTables.Items.Add（row[2].ToString（））;
????????????}
????????}
????????#endregion

????????private?void?Form1_Load（object?sender?EventArgs?e）
????????{

????????}
????????//符號轉變方法
????????public?string?path;
????????private?string?GetType（string?t）
????????{
????????????string?Type?=?string.Empty;
????????????switch?（t.ToLower（））
????????????{
????????????????case?“int“:
????????????????????Type?=?“int?“;break?;
????????????????case?“char“:
????????????????case?“varchar“:
????????????????case?“nvarchar“:
????????????????case?“nchar“:
????????????????case?“text“:
????????????????case?“ntext“:
????????????????????Type?=?“string“;break?;
????????????????case?“datetime“:
????????????????????Type?=?“DateTime“;break?;
????????????????case?“money“:
????????????????????Type?=?“float“;break;
????????????????case?“float“:
????????????????????Type?=?“float?“;break?;
????????????}
????????????return?Type;
????????}
????????//生成Models
????????private?void?Models（）
????????{
????????????for?（int?i?=?0;?i?????????????{
????????????????string?space?=?textbUsing.Text;//命名空間
????????????????string?tabName?=?clbTables.CheckedItems[i].ToString（）;
????????????????string?sql?=?“select?COLUMN_NAME?DATA_TYPE?from?INFORMATION_SCHEMA.COLUMNS?where?TABLE_NAME=‘“?+?tabName?+?“‘“;
????????????????DataTable?tab?=?SqlHelper.GetDataTable（sql）;
????????????????StringBuilder?b?=?new?StringBuilder（）;
????????????????{
????????????????????b.AppendLine（“using?System;“）;
????????????????????b.AppendLine（“using?System.Collections.Generic;“）;
????????????????????b.AppendLine（“using?System.Linq;“）;
????????????????????b.AppendLine（“using?System.Text;“）;
????????????????????b.AppendLine（）;
????????????????}
????????????????b.AppendLine（“namespace?“?+?space?+?“Models“）;
????????????????b.AppendLine（“{“）;
????????????????b.AppendLine（“\t?public?class?“?+?tabName）;
????????????????b.AppendLine（“\t?{“）;
????????????????//屬性字段
????????????????{

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????1410??2013-02-17?13:53??Access版的代碼生成器\Access版的代碼生成器\Properties\AssemblyInfo.cs

?????文件???????5612??2013-02-17?13:53??Access版的代碼生成器\Access版的代碼生成器\Properties\Resources.resx

?????文件???????2904??2013-02-17?13:53??Access版的代碼生成器\Access版的代碼生成器\Properties\Resources.Designer.cs

?????文件????????249??2013-02-17?13:53??Access版的代碼生成器\Access版的代碼生成器\Properties\Settings.settings

?????文件???????1112??2013-02-17?13:53??Access版的代碼生成器\Access版的代碼生成器\Properties\Settings.Designer.cs

?????文件??????25167??2013-02-19?08:42??Access版的代碼生成器\Access版的代碼生成器\Form1.cs

?????文件??????10296??2013-02-18?13:45??Access版的代碼生成器\Access版的代碼生成器\Form1.Designer.cs

?????文件????????488??2013-02-18?14:09??Access版的代碼生成器\Access版的代碼生成器\Program.cs

?????文件???????3660??2013-02-19?09:04??Access版的代碼生成器\Access版的代碼生成器\Access版的代碼生成器.csproj

?????文件??????11608??2013-02-19?09:03??Access版的代碼生成器\Access版的代碼生成器\bin\Debug\Access版的代碼生成器.vshost.exe

?????文件??????37376??2013-02-19?09:04??Access版的代碼生成器\Access版的代碼生成器\bin\Debug\Access版的代碼生成器.exe

?????文件??????44544??2013-02-19?09:04??Access版的代碼生成器\Access版的代碼生成器\bin\Debug\Access版的代碼生成器.pdb

?????文件????????490??2010-03-17?22:39??Access版的代碼生成器\Access版的代碼生成器\bin\Debug\Access版的代碼生成器.vshost.exe.manifest

?????文件???????5467??2013-02-19?09:04??Access版的代碼生成器\Access版的代碼生成器\obj\x86\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件????????180??2013-02-19?09:04??Access版的代碼生成器\Access版的代碼生成器\obj\x86\Debug\Access版的代碼生成器.Form1.resources

?????文件????????180??2013-02-19?09:04??Access版的代碼生成器\Access版的代碼生成器\obj\x86\Debug\Access版的代碼生成器.Properties.Resources.resources

?????文件????????472??2013-02-19?09:04??Access版的代碼生成器\Access版的代碼生成器\obj\x86\Debug\GenerateResource-ResGen.read.1.tlog

?????文件???????1370??2013-02-19?09:04??Access版的代碼生成器\Access版的代碼生成器\obj\x86\Debug\GenerateResource-ResGen.write.1.tlog

?????文件???????1056??2013-02-19?09:03??Access版的代碼生成器\Access版的代碼生成器\obj\x86\Debug\Access版的代碼生成器.csproj.FileListAbsolute.txt

?????文件??????37376??2013-02-19?09:04??Access版的代碼生成器\Access版的代碼生成器\obj\x86\Debug\Access版的代碼生成器.exe

?????文件??????44544??2013-02-19?09:04??Access版的代碼生成器\Access版的代碼生成器\obj\x86\Debug\Access版的代碼生成器.pdb

?????文件???????6424??2013-02-18?13:45??Access版的代碼生成器\Access版的代碼生成器\Form1.resx

?????文件???????2320??2013-02-18?13:42??Access版的代碼生成器\Access版的代碼生成器\SqlHelper.cs

?????文件???????8798??2013-02-19?09:04??Access版的代碼生成器\Access版的代碼生成器\圖標.ico

?????文件????????923??2013-02-17?13:53??Access版的代碼生成器\Access版的代碼生成器.sln

????..A..H.?????28160??2013-02-19?09:32??Access版的代碼生成器\Access版的代碼生成器.suo

?????文件????????438??2013-02-18?13:37??Access版的代碼生成器\obj\x86\Debug\GenerateResource.write.898.tlog

?????文件????????438??2013-02-18?14:10??Access版的代碼生成器\obj\x86\Debug\GenerateResource.write.972.tlog

?????目錄??????????0??2013-02-17?13:53??Access版的代碼生成器\Access版的代碼生成器\obj\x86\Debug\TempPE

?????目錄??????????0??2013-02-17?13:53??Access版的代碼生成器\Access版的代碼生成器\obj\x86\Debug

............此處省略14個文件信息