用Sql生成的脚本生成C#类.doc

/* 作者： evlon(阿牛) MSN: QQ:273352165* 功能： 得用Sql生成的脚本生成C#类*/对于Sql Server数据库,有查询分析器的帮助.我们可以省下不少的工夫.如果,在查询分析器的选项.脚本中,勾选将扩展属性脚本作为对象脚本的一部分我们可以生成如下的Create 脚本:CREATETABLEAdminUsers(useridintIDENTITY(1,1)NOTNULL,loginIDvarchar(30)COLLATEChinese_PRC_CI_ASNOTNULL,loginPwdvarchar(50)COLLATEChinese_PRC_CI_ASNOTNULL,UserNamenvarchar(30)COLLATEChinese_PRC_CI_ASNOTNULLCONSTRAINTDF_AdminUsers_UserNameDEFAULT(),IsSuperManbitNOTNULLCONSTRAINTDF_AdminUsers_IsSuperManDEFAULT(0),CONSTRAINTPK_AdminUsersPRIMARYKEYCLUSTERED(userid)ONPRIMARY)ONPRIMARYGOexecsp_addextendedpropertyNMS_Description,N是否超级用户,Nuser,Ndbo,Ntable,NAdminUsers,Ncolumn,NIsSuperManGOexecsp_addextendedpropertyNMS_Description,N登陆名,Nuser,Ndbo,Ntable,NAdminUsers,Ncolumn,NloginIDGOexecsp_addextendedpropertyNMS_Description,N登陆密码,Nuser,Ndbo,Ntable,NAdminUsers,Ncolumn,NloginPwdGOexecsp_addextendedpropertyNMS_Description,N用户系统标识,Nuser,Ndbo,Ntable,NAdminUsers,Ncolumn,NuseridGOexecsp_addextendedpropertyNMS_Description,N真实姓名,Nuser,Ndbo,Ntable,NAdminUsers,Ncolumn,NUserNameGO我们要生成下面的C#类:/*/AdminUsers的摘要说明。/publicclassAdminUsers/*/用户系统标识/privateintuserid;publicintUseridgetreturnuserid;setuserid=value;/*/登陆名/privatestringloginID;publicstringLoginIDgetreturnloginID;setloginID=value;/*/登陆密码/privatestringloginPwd;publicstringLoginPwdgetreturnloginPwd;setloginPwd=value;/*/真实姓名/privatestringuserName;publicstringUserNamegetreturnuserName;setuserName=value;/*/是否超级用户/privateboolisSuperMan;publicboolIsSuperMangetreturnisSuperMan;setisSuperMan=value; 由于Sql脚本中有我们需要的所有的东西.我们就有了生成类的必要条件.我已经把它用Javascript脚本实现了:UntitledStotype.upperFirstChar=function()returnthis.replace(/(w)/,function($1)return$1.toUpperCase(););Stotype.lowerFirstChar=function()returnthis.replace(/(w)/,function($1)return$1.toLowerCase(););varConvertDbTypeToCSType=bigint:long,binary:byte,bit:bool,char:char,datetime:DateTime,decimal:decimal,float:float,image:byte,int:int,money:string,nchar:char,ntext:string,numeric:int,nvarchar:string,real:string,smalldatetime:DateTime,smallint:int,smallmoney:string,sql_variant:string,sysname:string,text:string,timestamp:DateTime,tinyint:int,uniqueidentifier:string,varbinary:byte,varchar:string;functionCsFileStream()this.ms=newArray();this.tabNum=0;this.getTabs=function()vararr=newArray();arr.length=this.tabNum+1;returnarr.join(t);CsFileStotype.append=function()varstr=arguments0;if(strinstanceofArray)str=str.join();if(this.tabNum0)vartabs=this.getTabs();vartmpStr=str.replace(/n/g,n+tabs);this.msthis.ms.length=tmpStr;elsethis.msthis.ms.length=str;CsFileStotype.addTab=function()this.tabNum+;if(this.ms.length0)this.msthis.ms.length-1=this.msthis.ms.length-1.replace(/nt*$/gm,n+this.getTabs();CsFileStotype.delTab=function()this.tabNum-;if(this.ms.length0)this.msthis.ms.length-1=this.msthis.ms.length-1.replace(/nt*$/gm,n+this.getTabs();CsFileStotype.toString=function()returnthis.ms.join();functionbuildCsFromSql(strSql)vartableName=strSql.match(/tables+(+)/i)1;varcolumn=;varrgx=/(+)s+(+)/gi;vararr;while(arr=rgx.exec(strSql)!=null)columnarr1=;=arr1;columnarr1.dbtype=arr2;columnarr1.cstype=ConvertDbTypeToCSTypearr2;rgx=/NMS_Description,s+N(+).+N(+)$/gim;while(arr=rgx.exec(strSql)!=null)columnarr2.dbdesc=arr1;varcs=newCsFileStream();cs.append(/n);cs.append(/,tableName.upperFirstChar(),的摘要说明。n);cs.append(/n);cs.append(publicclass,tableName.upperFirstChar(),n);cs.append(n);cs.addTab();for(variincolumn)/私有成员cs.append(/n);cs.append(/,columni.dbdesc);cs.append(/n);cs.append(private,columni.cstype,.lowerFirstChar(),;n);cs.append(public,columni.cstype,.upperFirstChar(),n);cs.append(n);cs.addTab();cs.append(getreturn,.lowerFirstChar(),;n);cs.append(set,.lowerFirstChar(),=value;n);cs.delTab();cs.append(n);cs.delTab();cs.append(n);returncs.toString();functiongo_buildCsFromSql()txtCs.value=buildCsFromSql(txtSql.value);CREATETABLEAdminUsers(useridintIDENTITY(1,1)NOTNULL,loginIDvarchar(30)COLLATEChinese_PRC_CI_ASNOTNULL,loginPwdvarchar(50)COLLATEChinese_PRC_CI_ASNOTNULL,UserNamenvarchar(30)COLLATEChinese_PRC_CI_ASNOTNULLCONSTRAINTDF_AdminUsers_UserNameDEFAULT(),IsSuperManbitNOTNULLCONSTRAINTDF_AdminUsers_IsSuperManDEFAULT(0),CONSTRAINTPK_AdminUsersPRIMARYKEYCLUSTERED(userid)ONPRIMARY)ONPRIMARYGOexecsp_addextendedpropertyNMS_Description,N是否超级用户,Nuser,Ndbo,Ntable,NAdminUsers,Ncolumn,NIsSuperManGOexecsp_addextendedpropertyNMS_Description,N登陆名,Nuser,Ndbo,Ntable,NAdminUsers,Ncolumn,NloginIDGOexecsp_addextendedpropertyNMS_Description,N登陆密码,Nuser,Ndbo,Ntable,NAdminUsers,Ncolumn,NloginPwdGOexecsp_addextendedpropertyNMS_Description,N用户系统标识,Nuser,Ndbo,Ntable,NAdminUsers,Ncolumn,NuseridGOexecsp_addextendedpropertyNMS_Description,N真实姓名,Nuser,Ndbo,Ntable,NAdminUsers,Ncolumn,NUserNameGO运行效果如下:还可以改成Emeditor宏:记得保存Stotype.upperFirstChar=function()returnthis.replace(/(w)/,function($1)return$1.toUpperCase(););Stotype.lowerFirstChar=function()returnthis.replace(/(w)/,function($1)return$1.toLowerCase(););varConvertDbTypeToCSType=bigint:long,binary:byte,bit:bool,char:char,datetime:DateTime,decimal:decimal,float:float,image:byte,int:int,money:string,nchar:char,ntext:string,numeric:int,nvarchar:string,real:string,smalldatetime:DateTime,smallint:int,smallmoney:string,sql_variant:string,sysname:string,text:string,timestamp:DateTime,tinyint:int,uniqueidentifier:string,varbinary:byte,varchar:string;functionCsFileStream()this.ms=newArray();this.tabNum=0;this.getTabs=function()vararr=newArray();arr.length=this.tabNum+1;returnarr.join(t);CsFileStotype.append=function()varstr=arguments0;if(strinstanceofArray)str=str.join();if(this.tabNum0)vartabs=this.getTabs();vartmpStr=str.replace(/n/g,n+tabs);this.msthis.ms.length=tmpStr;elsethis.msthis.ms.length=str;CsFileStotype.addTab=function()this.tabNum+;if(this.ms.length0)this.msthis.ms.length-1=this.msthis.ms.length-1.replace(/nt*$/gm,n+this.getTabs();CsFileStotype.delTab=function()this.tabNum-;if(this.ms.length0)this.msthis.ms.length-1=this.msthis.ms.length-1.replace(/nt*$/gm,n+this.getTabs();CsFileStotype.toString=function()returnthis.ms.join();functionbuildCsFromSql(strSql)vartableName=strSql.match(/tables+(+)/i)1;varcolumn=;varrgx=/(+)s+(+)/gi;vararr;while(arr=rgx.exec(strSql)!=null)columnarr1=;=arr1;columnarr1.dbtype=arr2;columnarr1.cstype=ConvertDbTypeToCSTypearr2;rgx=/NMS_Description,s+N(+).+N(+)$/gim;while(arr=rgx.exec(strSql)!=null)columnarr2.dbdesc=arr1;varcs=newCsFileStream();cs.append(/n);cs.append(/,tableName.upperFirstChar(),的摘要说明。n);cs.append(/n);cs.