AutoThrCode 三层结构业务层代码自动生成工具
来源:互联网 发布:学编程用什么系统 编辑:程序博客网 时间:2024/04/27 11:27
点击下载
请看下面示例:
数据表结构如下:
生成的 属性成员 和 添加,更新的代码:
此程序部分界面截屏
请看下面示例:
数据表结构如下:
生成的 属性成员 和 添加,更新的代码:
'AutoThrCode自动生成三层结构业务逻辑层代码
'IsDotNet 版权所有
'作者:梦虫
'Msn:IsDotNet@MsN.CoM
'Http://www.IsDotNet.com
'本代码引用 IsDotNet.Data.SqlDbHelper 类,请将 AdoHelper.dll 拷贝到WEB程序的BIN目录下
'请在WEB程序的web.config文件的节配置数据库连接字符串,"ConnectionString" value="Server=(local); database=databasename; User ID=sa; Password=sa;" />
Imports System
Imports System.Data
Imports System.Data.SqlClient
Class DBShippers
'属性成员ErrMsg
Private _ErrMsg As String
Public Property [ErrMsg] As String
Get
Return Me._Errmsg
End Get
Set(ByVal Value As String)
Me._Errmsg = Value
End Set
End Property
'属性成员:ShipperID
Private intShipperid As Integer
Public Property [ShipperID] As Integer
Get
Return Me.intShipperid
End Get
Set(ByVal Value As Integer )
Me.intShipperid = Value
End Set
End Property
'属性成员:CompanyName
Private strCompanyname As String
Public Property [CompanyName] As String
Get
Return Me.strCompanyname
End Get
Set(ByVal Value As String )
Me.strCompanyname = Value
End Set
End Property
'属性成员:Phone
Private strPhone As String
Public Property [Phone] As String
Get
Return Me.strPhone
End Get
Set(ByVal Value As String )
Me.strPhone = Value
End Set
End Property
'添加
Public Function Shippers_Insert() As Boolean
Dim db As New IsDotNet.Data.SqlDbHelper
Dim strSql As String = "Insert Into [Shippers] ([CompanyName],[Phone]) values (@CompanyName,@Phone)"
Dim param() As SqlParameter = { _
db.MakeInParam("@CompanyName", SqlDbType.NVarChar, 40, Me.strCompanyname) , _
db.MakeInParam("@Phone", SqlDbType.NVarChar, 24, Me.strPhone) _
}
If db.Execute(strSql,param) Then
Return True
Else
Me._ErrMsg = db.ErrMsg
Return False
End If
End Function
'更新
Public Function Shippers_Update() As Boolean
Dim db As New IsDotNet.Data.SqlDbHelper
Dim strSql As String = "Update [Shippers] Set [CompanyName]=@CompanyName,[Phone]=@Phone where [ShipperID]=@ShipperID"
Dim param() As SqlParameter = { _
db.MakeInParam("@CompanyName", SqlDbType.NVarChar, 40, Me.strCompanyname) , _
db.MakeInParam("@Phone", SqlDbType.NVarChar, 24, Me.strPhone) , _
db.MakeInParam("@ShipperID", SqlDbType.Int, 0, Me.intShipperid) _
}
If db.Execute(strSql, param) Then
Return True
Else
Me.ErrMsg = db.ErrMsg
Return False
End If
End Function
End Class
'IsDotNet 版权所有
'作者:梦虫
'Msn:IsDotNet@MsN.CoM
'Http://www.IsDotNet.com
'本代码引用 IsDotNet.Data.SqlDbHelper 类,请将 AdoHelper.dll 拷贝到WEB程序的BIN目录下
'请在WEB程序的web.config文件的
Imports System
Imports System.Data
Imports System.Data.SqlClient
Class DBShippers
'属性成员ErrMsg
Private _ErrMsg As String
Public Property [ErrMsg] As String
Get
Return Me._Errmsg
End Get
Set(ByVal Value As String)
Me._Errmsg = Value
End Set
End Property
'属性成员:ShipperID
Private intShipperid As Integer
Public Property [ShipperID] As Integer
Get
Return Me.intShipperid
End Get
Set(ByVal Value As Integer )
Me.intShipperid = Value
End Set
End Property
'属性成员:CompanyName
Private strCompanyname As String
Public Property [CompanyName] As String
Get
Return Me.strCompanyname
End Get
Set(ByVal Value As String )
Me.strCompanyname = Value
End Set
End Property
'属性成员:Phone
Private strPhone As String
Public Property [Phone] As String
Get
Return Me.strPhone
End Get
Set(ByVal Value As String )
Me.strPhone = Value
End Set
End Property
'添加
Public Function Shippers_Insert() As Boolean
Dim db As New IsDotNet.Data.SqlDbHelper
Dim strSql As String = "Insert Into [Shippers] ([CompanyName],[Phone]) values (@CompanyName,@Phone)"
Dim param() As SqlParameter = { _
db.MakeInParam("@CompanyName", SqlDbType.NVarChar, 40, Me.strCompanyname) , _
db.MakeInParam("@Phone", SqlDbType.NVarChar, 24, Me.strPhone) _
}
If db.Execute(strSql,param) Then
Return True
Else
Me._ErrMsg = db.ErrMsg
Return False
End If
End Function
'更新
Public Function Shippers_Update() As Boolean
Dim db As New IsDotNet.Data.SqlDbHelper
Dim strSql As String = "Update [Shippers] Set [CompanyName]=@CompanyName,[Phone]=@Phone where [ShipperID]=@ShipperID"
Dim param() As SqlParameter = { _
db.MakeInParam("@CompanyName", SqlDbType.NVarChar, 40, Me.strCompanyname) , _
db.MakeInParam("@Phone", SqlDbType.NVarChar, 24, Me.strPhone) , _
db.MakeInParam("@ShipperID", SqlDbType.Int, 0, Me.intShipperid) _
}
If db.Execute(strSql, param) Then
Return True
Else
Me.ErrMsg = db.ErrMsg
Return False
End If
End Function
End Class
此程序部分界面截屏
- AutoThrCode 三层结构业务层代码自动生成工具
- BLL-自动生成业务逻辑层代码
- [C#]一步一步开发自己的自动代码生成工具之六:业务层模板
- [C#]一步一步开发自己的自动代码生成工具之四:简单三层代码模板实例Model层
- Mybatis中根据数据库表结构自动生成dao层等代码的工具及其步骤
- 三层结构数据访问层代码
- 代码自动生成工具
- 数据库的连接及三层结构中的业务层及数据处理层的编写
- 三层结构:实体层
- 三层结构:逻辑层
- 自动生成bean层dao层以及xml层工具
- .NET中数据层自动生成工具
- .NET中数据层自动生成工具
- Ibatis代码自动生成工具
- Mybatis 自动生成代码工具
- Mybatis 自动生成代码工具
- mybatis代码自动生成工具
- Ibatis代码自动生成工具
- 脆弱的中国互联网
- aaa
- 数据访问策略建议.DataSet&DataReader.(摘自msdn.写的很好!放在blog中了!)
- Java Language Conversion Assistant 2.0
- C#命名规则和开发习惯(引用于天上的星星亮晶晶(zj492)的blog)
- AutoThrCode 三层结构业务层代码自动生成工具
- I will come to you
- 看魔鬼代言人(Devil's Advocate)有感
- 『-琼海-』人生感悟四则(转载)
- 北京环球嘉年华游戏安全锁伤游客 伤者提出赔偿
- 欢迎大家来做客!
- 一段JS代码模仿SINA的广告条
- 缺电给一些企业带来了新的商机
- 个人收藏的编程下载资源全部公布!!!