首页 新闻 会员 周边

自动生成代码软件

0
[已解决问题] 解决于 2009-10-09 16:52

请问什么软件可以生成以下代码:

Imports TierLibrary

Public Class ConfCommon

#Region "Members and Constants"
 Public Enum CommonType
  None
  Header = 1
  Footer
  Menu
  Label
  Message
 End Enum

 Private Const SP_SELECTLIST As String = "spConfCommon_GetList"
 Private Const SP_SELECTLISTBYFIIDANDSITETYPEID As String = "spConfCommon_GetList_ByFIIDAndSitTypeID"
 Public Enum EListField
  ConfCommonID
  ConfCommonName
  ControlID
  ControlText
  ConfCommonTypeID
  ConfSiteTypeID
 End Enum

 Private Const SP_SELECTONE As String = "spConfCommon_GetOne"
 Public Enum ESelectField
  ConfCommonID
  ConfCommonName
  ControlID
  ControlText
  ConfCommonTypeID
  ConfSiteTypeID
 End Enum

 Private Const SP_INSERT As String = "spConfCommon_Insert"
 Private Const SP_UPDATE As String = "spConfCommon_Update"
 Private Const SP_DELETE As String = "spConfCommon_Delete"

 Private Class ConfCommonData
  Public iConfCommonID As Integer
  Public sConfCommonName As String
  Public sControlID As String
  Public sControlText As String
  Public iConfCommonTypeID As Integer
  Public iConfSiteTypeID As Integer
 End Class

 'Private mPermissions As PermissionService.NounPermission
 Private mbLoadedFromDB As Boolean
 Private mbUncommittedChanges As Boolean
 Private mTheConfCommon As ConfCommonData

#End Region

#Region "Properties"

 Public ReadOnly Property ConfCommonID() As Integer
  Get
   Return mTheConfCommon.iConfCommonID
  End Get

 End Property

 Public Property ConfCommonName() As String
  Get
   Return mTheConfCommon.sConfCommonName
  End Get
  Set(ByVal Value As String)
   If Value <> mTheConfCommon.sConfCommonName Then
    mbUncommittedChanges = True
    mTheConfCommon.sConfCommonName = Value
   End If
  End Set
 End Property

 Public Property ConfSiteTypeID() As Integer
  Get
   Return mTheConfCommon.iConfSiteTypeID
  End Get
  Set(ByVal Value As Integer)
   If Value <> mTheConfCommon.iConfSiteTypeID Then
    mbUncommittedChanges = True
    mTheConfCommon.iConfSiteTypeID = Value
   End If
  End Set
 End Property

 

 Public Property ControlID() As String
  Get
   Return mTheConfCommon.sControlID
  End Get
  Set(ByVal Value As String)
   If Value <> mTheConfCommon.sControlID Then
    mbUncommittedChanges = True
    mTheConfCommon.sControlID = Value
   End If
  End Set
 End Property

 Public Property ControlText() As String
  Get
   Return mTheConfCommon.sControlText
  End Get
  Set(ByVal Value As String)
   If Value <> mTheConfCommon.sControlText Then
    mbUncommittedChanges = True
    mTheConfCommon.sControlText = Value
   End If
  End Set
 End Property

 Public Property ConfCommonTypeID() As Integer
  Get
   Return mTheConfCommon.iConfCommonTypeID
  End Get
  Set(ByVal Value As Integer)
   If Value <> mTheConfCommon.iConfCommonTypeID Then
    mbUncommittedChanges = True
    mTheConfCommon.iConfCommonTypeID = Value
   End If
  End Set
 End Property


#End Region

#Region "Methods"
 ''' <summary>
 ''' Initializes a new instance of the <see cref="T:ConfCommon" /> class.
 ''' </summary>
 Public Sub New()
  mTheConfCommon = New ConfCommonData()
  mbUncommittedChanges = False
 End Sub

 ''' <summary>
 ''' Initializes a new instance of the <see cref="T:ConfCommon" /> class.
 ''' </summary>
 ''' <param name="iConfCommonID">The iConfCommonID.</param>
 Public Sub New(ByVal iConfCommonID As Integer)
  Me.New()
  FillFromDB(iConfCommonID)
 End Sub

 ''' <summary>
 ''' Initializes a new instance of the <see cref="T:ConfCommon" /> class.
 ''' </summary>
 ''' <param name="DataRow">The data row.</param>
 Public Sub New(ByVal DataRow As IDataRecord)
  Me.New()
  FillFromDB(DataRow)
 End Sub

 

 ''' <summary>
 ''' Inserts the specified transaction.
 ''' </summary>
 ''' <returns></returns>
 Public Function Insert() As Integer

  Dim Parameters() As Object = { _
  mTheConfCommon.sConfCommonName, _
  mTheConfCommon.iConfSiteTypeID, _
  mTheConfCommon.sControlID, _
  mTheConfCommon.sControlText, _
  mTheConfCommon.iConfCommonTypeID _
  }
  AppAssertion.Assert(Not mbLoadedFromDB, _
   "Tried to insert a ConfCommon that was loaded from database.", _
   AppAssertion.LineNumber)

  ' If there's been no changes, exit doing nothing.
  If Not mbUncommittedChanges Then Return mTheConfCommon.iConfCommonID


  ' Perform the insert.
  mTheConfCommon.iConfCommonID = CType(DataService.ExecuteScalar(Nothing, SP_INSERT, Parameters), Integer)

  ' In case caller doesn't discard this object after insert, ensure internal state
  ' is correct
  mbUncommittedChanges = False
  mbLoadedFromDB = True

  ' Return ID of new object to caller
  Return mTheConfCommon.iConfCommonID
 End Function

 ''' <summary>
 ''' Updates the specified ConfCommon.
 ''' </summary>
 Public Sub Update()

  Dim Parameters() As Object = { _
  mTheConfCommon.iConfCommonID, _
  mTheConfCommon.sConfCommonName, _
  mTheConfCommon.iConfSiteTypeID, _
  mTheConfCommon.sControlID, _
  mTheConfCommon.sControlText, _
  mTheConfCommon.iConfCommonTypeID _
  }
  AppAssertion.Assert(mbLoadedFromDB, _
   "Tried to update the ConfCommon that hadn't been loaded first.", _
   AppAssertion.LineNumber)

  ' If there's been no changes, exit doing nothing.
  If Not mbUncommittedChanges Then Return

  ' Save changes to the database.
  DataService.ExecuteScalar(Nothing, SP_UPDATE, Parameters)

  ' In case caller doesn't disacard this object after update, ensure internal state
  ' is correct
  mbUncommittedChanges = False
 End Sub

 ''' <summary>
 ''' Deletes the specified ConfCommon.
 ''' </summary>
 Public Sub Delete()

  Dim Parameters() As Object = {mTheConfCommon.iConfCommonID}

  'Perform the delete.
  DataService.ExecuteScalar(Nothing, SP_DELETE, Parameters)

  'In case caller doesn't discard this object after delete, ensure internal state is corrrect
  mTheConfCommon = Nothing
  mbUncommittedChanges = False
  mbLoadedFromDB = False
 End Sub

 ''' <summary>
 ''' Saves the specified ConfCommon.
 ''' </summary>
 ''' <returns></returns>
 Public Function Save() As Integer

  ' Note: Permissions are checked in the Insert/Update routines
  If mbLoadedFromDB Then
   Update()
   Return mTheConfCommon.iConfCommonID
  Else
   Return Insert()
  End If
 End Function

 ''' <summary>
 ''' Fills from DB.
 ''' </summary>
 ''' <param name="iConfCommonID">The iConfCommonID.</param>
 Private Sub FillFromDB(ByVal iConfCommonID As Integer)
  Dim DataReader As IDataReader
  Dim Parameters() As Object = {iConfCommonID}
  DataReader = DataService.ExecuteReader(Nothing, SP_SELECTONE, Parameters)
  Try
   If Not DataReader.Read() Then
    Throw New AppDataObjectNotFound("ApplicationDefinition", mTheConfCommon.iConfCommonID)
   End If
   FillFromDB(DataReader)
  Finally
   DataReader.Close()
  End Try
 End Sub

 ''' <summary>
 ''' Fills from DB.
 ''' </summary>
 ''' <param name="DataRow">The data row.</param>
 Private Sub FillFromDB(ByVal DataRow As IDataRecord)
  With mTheConfCommon
   'Fields that should new be null
   .iConfCommonID = DataRow.GetInt32(ESelectField.ConfCommonID)
   .iConfSiteTypeID = DataRow.GetInt32(ESelectField.ConfSiteTypeID)
   .iConfCommonTypeID = DataRow.GetInt32(ESelectField.ConfCommonTypeID)

   'Fields that could be null
   .sConfCommonName = DataService.GetString(DataRow, ESelectField.ConfCommonName)
   .sControlID = DataService.GetString(DataRow, ESelectField.ControlID)
   .sControlText = DataService.GetString(DataRow, ESelectField.ControlText)

   'Revision fields (won't be null)

  End With
  mbLoadedFromDB = True
 End Sub
#End Region

#Region "Shared Methods"


 Public Shared Function GetList() As IDataReader
  Return DataService.ExecuteReader(Nothing, SP_SELECTLIST)
 End Function


 Public Shared Function GetListAsDataSet() As DataSet
  Return DataService.ExecuteDataset(Nothing, SP_SELECTLIST)
 End Function

 #End Region
End Class

驢騎士的主页 驢騎士 | 初学一级 | 园豆:0
提问于:2009-10-09 14:03
< >
分享
最佳答案
0

动软代码生成器 百度一下~

Mr雨 | 小虾三级 |园豆:1199 | 2009-10-09 14:53
动软看过了,不是。
驢騎士 | 园豆:0 (初学一级) | 2009-10-09 16:08
刚仔细看了,应该是,呵呵 改动一下模版就ok了
驢騎士 | 园豆:0 (初学一级) | 2009-10-09 16:52
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册