vb.net版机房重构--充值记录查询
前言vb.net和VB两种的差距并不是非常大,但是使用起来还是有一些不同的,拿机房的充值记录查询功能实现来具体说明。使用 vs就比使用VB要简单很多,省去了很多人工的操作。 操作说明 在vb.net版机房收费系统中我对需求做了修改,学生端的充值记录查询就变成了如下界面: 'TODO: 这行代码将数据加载到表“Rechargerecord.recharge”中。您可以根据需要移动或删除它。
Me.RechargeTableAdapter.Fill(Me.Rechargerecord.recharge)
Private Sub FillByToolStripButton_Click(sender As Object,e As EventArgs) Handles FillByToolStripButton.Click
Try
Me.RechargeTableAdapter.FillBy(Me.Rechargerecord.recharge,UserNameToolStripTextBox.Text)
Catch ex As System.Exception
System.Windows.Forms.MessageBox.Show(ex.Message)
End Try
End Sub
部分代码展示 Public Class U_Rechargerecord
Private Sub U_Rechargerecord_Load(sender As Object,e As EventArgs) Handles MyBase.Load
'TODO: 这行代码将数据加载到表“Rechargerecord.recharge”中。您可以根据需要移动或删除它。
Me.RechargeTableAdapter.Fill(Me.Rechargerecord.recharge)
'删除最后一行空行
DataGridView1.AllowUserToAddRows = False
'隐藏工具栏
FillByToolStrip.Hide()
'接下来要进行的就是将登录窗体的用户名传入此窗体的文本框中
Dim facadeRechargerecord As New Facade.Fe_Rechargerecord
Dim table As DataTable
Dim UserInfo As New Entity.E_Rechargerecord
table = facadeRechargerecord.CheckLink(UserInfo)
txtstudentNo.Text = table.Rows(0)(1)
End Sub
Private Sub FillByToolStripButton_Click(sender As Object,UserNameToolStripTextBox.Text)
Catch ex As System.Exception
System.Windows.Forms.MessageBox.Show(ex.Message)
End Try
End Sub
Private Sub txtstudentNo_TextChanged(sender As Object,e As EventArgs) Handles txtstudentNo.TextChanged
'因为这里不需要点击按钮,txtstudentNo文本框中的数据直接接受登录窗体的用户名,所以这里需要
'做的就是当文本框中同步登录窗体的内容时触发tool工具
'将文本框中的值赋值给添加的查询tootextbox
UserNameToolStripTextBox.Text = txtstudentNo.Text
Try
Me.RechargeTableAdapter.FillBy(Me.Rechargerecord.recharge,UserNameToolStripTextBox.Text)
Catch ex As System.Exception
System.Windows.Forms.MessageBox.Show(ex.Message)
End Try
End Sub
End Class
外观层Public Class Fe_Rechargerecord
Public Function CheckLink(ByVal UserInfo As Entity.E_Rechargerecord) As DataTable
Dim isLink As New BLL.B_Rechargerecord
Dim flag As DataTable
flag = isLink.Link(UserInfo)
Return flag
End Function
End Class
B层 Public Class B_Rechargerecord
Public Function Link(ByVal UserInfo As Entity.E_Rechargerecord) As DataTable
Dim IRechargerecord As IDAL.I_Rechargerecord
'调用创建用户的工厂方法
IRechargerecord = Factory.Fy_Rechargerecord.CreateUserInterface
Dim table As DataTable
table = IRechargerecord.selectUser(UserInfo)
Return table
End Function
End Class
D层 Imports System.Data.SqlClient
Public Class D_Rechargerecord : Implements IDAL.I_Rechargerecord
'声明并实例化sqlhelper类
Private SqlHelper As SQLHelper.sqlhelper = New SQLHelper.sqlhelper
'增删改查
Public Function selectUser(UserInfo As Entity.E_Rechargerecord) As DataTable Implements IDAL.I_Rechargerecord.selectUser
'定义
Dim Sql As String
'中间变量用于存储从数据库中查找信息
Dim table As DataTable
'声明并实例化参数数组
'这里需要调用登录窗体的用户名
Dim UserInfo1 As New Entity.E_Login
Dim sqlParams As SqlParameter() = {New SqlParameter("@UserName",UserInfo.UserName = UserInfo1.UserName)}
Sql = "select * from recharge where studentNo=@UserName"
table = SqlHelper.GetDataTable(Sql,CommandType.Text,sqlParams)
Return table
End Function
End Class
计算机小白学习到了一个新的知识,兴奋! (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |