生成表对应字段

/* 生成表对应字段 使用方法:修改 set @tableName='bbsTopic' bbsTopic为你自已的表名 时间 2009-7-30 */ use bbsDB GO set nocount on declare @tableName varchar(20) set @tableName='bbsTopic' select 'private '+case when b.name in ('int','smallint') then 'int' when b.name in ('float') then 'float' when b.name in ('numeric') then 'double' else 'string' end +' _'+convert(varchar(20),a.name)+';' FROM syscolumns a left join systypes b on a.xusertype=b.xusertype inner join sysobjects d on a.id=d.id where d.name=@tableName union all select '/// <summary>'+char(10) +'/// '+a.name+char(10) +'/// </summary>'+char(10) +'public ' +case when b.name in ('int','smallint') then 'int' when b.name in ('float') then 'float' when b.name in ('numeric') then 'double' else 'string' end +' '+convert(varchar(20),a.name)+ char(10)+'{'+char(10)+ ' get{ return _'+convert(varchar(20),a.name)+';}'+char(10)+ ' set{ _'+convert(varchar(20),a.name)+'=value;}'+char(10)+'}' FROM syscolumns a left join systypes b on a.xusertype=b.xusertype inner join sysobjects d on a.id=d.id where d.name=@tableName

 

 

//效果

 

 private int _TID; private int _TsID; private int _TuID; private int _TreplyCount; private int _Tface; private string _Ttopic; private string _Tcontents; private string _Ttime; private int _TclickCount; private int _Tstate; private string _TlastReply; /// <summary> /// TID /// </summary> public int TID { get { return _TID; } set { _TID = value; } } /// <summary> /// TsID /// </summary> public int TsID { get { return _TsID; } set { _TsID = value; } } /// <summary> /// TuID /// </summary> public int TuID { get { return _TuID; } set { _TuID = value; } } /// <summary> /// TreplyCount /// </summary> public int TreplyCount { get { return _TreplyCount; } set { _TreplyCount = value; } } /// <summary> /// Tface /// </summary> public int Tface { get { return _Tface; } set { _Tface = value; } } /// <summary> /// Ttopic /// </summary> public string Ttopic { get { return _Ttopic; } set { _Ttopic = value; } } /// <summary> /// Tcontents /// </summary> public string Tcontents { get { return _Tcontents; } set { _Tcontents = value; } } /// <summary> /// Ttime /// </summary> public string Ttime { get { return _Ttime; } set { _Ttime = value; } } /// <summary> /// TclickCount /// </summary> public int TclickCount { get { return _TclickCount; } set { _TclickCount = value; } } /// <summary> /// Tstate /// </summary> public int Tstate { get { return _Tstate; } set { _Tstate = value; } } /// <summary> /// TlastReply /// </summary> public string TlastReply { get { return _TlastReply; } set { _TlastReply = value; } }