using?System;
using?System.Collections.Generic;
using?System.Text;
using?System.IO;
namespace?ForExcel
{
????///?

????///?CSharpCodeGen?的摘要說明。
????///?

????public?class?CSharpCodeGen?:?ICodeGen
????{
????????private?StringBuilder?sbContent;
????????private?string?sTemp;

????????public?CSharpCodeGen（）
????????{
????????}

????????#region?私有成員
????????private?string?ConvertToCsType（string?dbType）
????????{
????????????if?（dbType.IndexOf（“（“）?!=?-1）
????????????????dbType?=?dbType.Substring（0?dbType.IndexOf（“（“））;

????????????switch?（dbType.ToLower（））
????????????{
????????????????case?“bit“:
????????????????????return?“bool“;
????????????????case?“nvarchar“:
????????????????case?“nchar“:
????????????????case?“varchar“:
????????????????case?“char“:
????????????????case?“text“:
????????????????case?“ntext“:
????????????????????return?“string“;
????????????????case?“datetime“:
????????????????case?“date“:
????????????????????return?“DateTime“;
????????????????case?“float“:
????????????????case?“money“:
????????????????????return?“float“;
????????????????case?“int“:
????????????????case?“integer“:
????????????????case?“smallint“:
????????????????case?“tinyint“:
????????????????case?“number“:
????????????????????return?“int“;
????????????????case?“bigint“:
????????????????????return?“l(fā)ong“;
????????????????case?“numeric“:
????????????????case?“decimal“:
????????????????????return?“decimal“;
????????????????case?“image“:
????????????????????return?“byte[]“;
????????????????case?“l(fā)ongtype“:
????????????????????return?“l(fā)ong“;
????????????????case?“floattype“:
????????????????????return?“float“;
????????????????default:
????????????????????return?“string“;
????????????}
????????}
????????#endregion

????????#region?ICodeGen?成員

????????public?void?GenHead（string?tableName?string?nameSpace?string?extendsFrom?UsedType?usedType）
????????{
????????????sbContent?=?new?StringBuilder（）;
??????????????
????????????????sbContent.Append（“using?System;\n“?
????????????????????+?“using?System.Data;\n\n“
????????????????????+?“namespace?“?+?nameSpace?+?“\n“
????????????????????+?“{\n“
????????????????????+?（（usedType?==?UsedType.WinForm）???““?:?（“\t[Serializable]\n“））
?????????????????????+?“\tpublic?class?“?+?tableName?+?（extendsFrom?==?String.Empty???““?:?（“:“?+?extendsFrom））?+?“\n“
????????????????????+?“\t{\n“
????????????????????+?“\t\tpublic?“?+?tableName?+?“（）{}\n\n“
????????????????????+?（（extendsFrom?==?String.Empty）???““?:?（“\t\tpublic?“?+?tableName?+?“（int?entID）:base（entID）{}\n\n“）））;
????????????
????????}

????????public?void?GenProperty（string?propertyName?string?columnName?string?dbType?string?description?string?length?ColumnType?colType?params?string[]?otherInfo）
????????{
????????????sTemp?=?“\t\tprivate?{0}?{3}_{1};“
????????????????????????+?“\n\t\t///?
“
????????????????????????+?“\n\t\t///?{2}“
????????????????????????+?“\n\

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件???????2014??2008-12-08?10:43??ForExcel\ForExcel\bin\Debug\Domen\Mediaitem.cs

?????文件???????1095??2008-12-08?10:43??ForExcel\ForExcel\bin\Debug\Domen\Mediaitem.hbm.xml

?????文件???????1860??2008-12-08?10:43??ForExcel\ForExcel\bin\Debug\Domen\Mediamain.cs

?????文件???????1023??2008-12-08?10:43??ForExcel\ForExcel\bin\Debug\Domen\Mediamain.hbm.xml

?????文件??????36864??2008-12-05?09:29??ForExcel\ForExcel\bin\Debug\ForExcel.exe

?????文件??????42496??2008-12-05?09:29??ForExcel\ForExcel\bin\Debug\ForExcel.pdb

?????文件???????5632??2005-12-08?14:51??ForExcel\ForExcel\bin\Debug\ForExcel.vshost.exe

?????文件??????12800??2006-07-07?09:15??ForExcel\ForExcel\bin\Debug\Iesi.Collections.dll

?????文件?????249856??2006-07-07?09:15??ForExcel\ForExcel\bin\Debug\log4net.dll

?????文件?????775168??2006-07-07?09:17??ForExcel\ForExcel\bin\Debug\NHibernate.dll

?????文件???????3847??2008-12-02?09:51??ForExcel\ForExcel\bin\Debug\sqlnet.log

?????文件???????4089??2008-12-02?13:29??ForExcel\ForExcel\CSharpCodeGen.cs

?????文件??????13121??2008-12-02?11:58??ForExcel\ForExcel\Database.cs

?????文件???????4306??2008-08-22?17:18??ForExcel\ForExcel\ForExcel.csproj

?????文件????????168??2006-12-15?16:28??ForExcel\ForExcel\ForExcel.csproj.user

?????文件????????274??2008-08-22?17:18??ForExcel\ForExcel\ForExcel.csproj.vspscc

?????文件???????4120??2008-08-22?13:41??ForExcel\ForExcel\frmCreate.cs

?????文件??????13424??2007-08-10?08:46??ForExcel\ForExcel\frmCreate.Designer.cs

?????文件???????5814??2007-08-10?08:46??ForExcel\ForExcel\frmCreate.resx

?????文件???????4486??2008-12-02?11:29??ForExcel\ForExcel\HbmCodeGen.cs

?????文件???????1610??2007-04-13?14:51??ForExcel\ForExcel\ICodeGen.cs

?????文件????????192??2008-08-22?17:18??ForExcel\ForExcel\mssccprj.scc

?????文件????????846??2008-12-05?09:29??ForExcel\ForExcel\obj\Debug\ForExcel.csproj.GenerateResource.Cache

?????文件??????36864??2008-12-05?09:29??ForExcel\ForExcel\obj\Debug\ForExcel.exe

?????文件????????180??2008-12-05?09:29??ForExcel\ForExcel\obj\Debug\ForExcel.frmCreate.resources

?????文件??????42496??2008-12-05?09:29??ForExcel\ForExcel\obj\Debug\ForExcel.pdb

?????文件????????180??2008-12-05?09:29??ForExcel\ForExcel\obj\Debug\ForExcel.Properties.Resources.resources

?????文件??????12481??2008-12-05?09:29??ForExcel\ForExcel\obj\Debug\ResolveAssemblyReference.cache

?????文件????????360??2008-08-22?14:25??ForExcel\ForExcel\obj\ForExcel.csproj.FileList.txt

?????文件????????591??2008-12-05?09:29??ForExcel\ForExcel\obj\ForExcel.csproj.FileListAbsolute.txt

............此處省略31個(gè)文件信息