frmmdcfquery.vb
上传用户:wj57717022
上传日期:2014-12-16
资源大小:4093k
文件大小:13k
- Public Class frmmdcfquery
- Inherits System.Windows.Forms.Form
- #Region " Windows 窗体设计器生成的代码 "
- Public Sub New()
- MyBase.New()
- '该调用是 Windows 窗体设计器所必需的。
- InitializeComponent()
- '在 InitializeComponent() 调用之后添加任何初始化
- End Sub
- '窗体重写 dispose 以清理组件列表。
- Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
- If disposing Then
- If Not (components Is Nothing) Then
- components.Dispose()
- End If
- End If
- MyBase.Dispose(disposing)
- End Sub
- 'Windows 窗体设计器所必需的
- Private components As System.ComponentModel.IContainer
- '注意: 以下过程是 Windows 窗体设计器所必需的
- '可以使用 Windows 窗体设计器修改此过程。
- '不要使用代码编辑器修改它。
- Friend WithEvents GroupBox1 As System.Windows.Forms.GroupBox
- Friend WithEvents txtkhname As System.Windows.Forms.TextBox
- Friend WithEvents Label5 As System.Windows.Forms.Label
- Friend WithEvents Label4 As System.Windows.Forms.Label
- Friend WithEvents txtmedname As System.Windows.Forms.TextBox
- Friend WithEvents Label3 As System.Windows.Forms.Label
- Friend WithEvents txtendtime As System.Windows.Forms.DateTimePicker
- Friend WithEvents txtbegintime As System.Windows.Forms.DateTimePicker
- Friend WithEvents Label2 As System.Windows.Forms.Label
- Friend WithEvents Label1 As System.Windows.Forms.Label
- Friend WithEvents Panel1 As System.Windows.Forms.Panel
- Friend WithEvents btnPrint As System.Windows.Forms.Button
- Friend WithEvents btnQuery As System.Windows.Forms.Button
- Friend WithEvents btnqueryall As System.Windows.Forms.Button
- Friend WithEvents Panel2 As System.Windows.Forms.Panel
- Friend WithEvents dgview As System.Windows.Forms.DataGrid
- Friend WithEvents Label6 As System.Windows.Forms.Label
- Friend WithEvents txtdemo As System.Windows.Forms.TextBox
- Friend WithEvents txtmedtype As System.Windows.Forms.TextBox
- <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
- Me.GroupBox1 = New System.Windows.Forms.GroupBox
- Me.txtmedtype = New System.Windows.Forms.TextBox
- Me.txtdemo = New System.Windows.Forms.TextBox
- Me.Label6 = New System.Windows.Forms.Label
- Me.txtkhname = New System.Windows.Forms.TextBox
- Me.Label5 = New System.Windows.Forms.Label
- Me.Label4 = New System.Windows.Forms.Label
- Me.txtmedname = New System.Windows.Forms.TextBox
- Me.Label3 = New System.Windows.Forms.Label
- Me.txtendtime = New System.Windows.Forms.DateTimePicker
- Me.txtbegintime = New System.Windows.Forms.DateTimePicker
- Me.Label2 = New System.Windows.Forms.Label
- Me.Label1 = New System.Windows.Forms.Label
- Me.Panel1 = New System.Windows.Forms.Panel
- Me.btnPrint = New System.Windows.Forms.Button
- Me.btnQuery = New System.Windows.Forms.Button
- Me.btnqueryall = New System.Windows.Forms.Button
- Me.Panel2 = New System.Windows.Forms.Panel
- Me.dgview = New System.Windows.Forms.DataGrid
- Me.GroupBox1.SuspendLayout()
- Me.Panel1.SuspendLayout()
- Me.Panel2.SuspendLayout()
- CType(Me.dgview, System.ComponentModel.ISupportInitialize).BeginInit()
- Me.SuspendLayout()
- '
- 'GroupBox1
- '
- Me.GroupBox1.Controls.Add(Me.txtmedtype)
- Me.GroupBox1.Controls.Add(Me.txtdemo)
- Me.GroupBox1.Controls.Add(Me.Label6)
- Me.GroupBox1.Controls.Add(Me.txtkhname)
- Me.GroupBox1.Controls.Add(Me.Label5)
- Me.GroupBox1.Controls.Add(Me.Label4)
- Me.GroupBox1.Controls.Add(Me.txtmedname)
- Me.GroupBox1.Controls.Add(Me.Label3)
- Me.GroupBox1.Controls.Add(Me.txtendtime)
- Me.GroupBox1.Controls.Add(Me.txtbegintime)
- Me.GroupBox1.Controls.Add(Me.Label2)
- Me.GroupBox1.Controls.Add(Me.Label1)
- Me.GroupBox1.Dock = System.Windows.Forms.DockStyle.Top
- Me.GroupBox1.Location = New System.Drawing.Point(0, 0)
- Me.GroupBox1.Name = "GroupBox1"
- Me.GroupBox1.Size = New System.Drawing.Size(726, 112)
- Me.GroupBox1.TabIndex = 5
- Me.GroupBox1.TabStop = False
- '
- 'txtmedtype
- '
- Me.txtmedtype.Location = New System.Drawing.Point(312, 64)
- Me.txtmedtype.Name = "txtmedtype"
- Me.txtmedtype.Size = New System.Drawing.Size(136, 25)
- Me.txtmedtype.TabIndex = 13
- Me.txtmedtype.Text = ""
- '
- 'txtdemo
- '
- Me.txtdemo.Location = New System.Drawing.Point(532, 64)
- Me.txtdemo.Name = "txtdemo"
- Me.txtdemo.Size = New System.Drawing.Size(179, 25)
- Me.txtdemo.TabIndex = 12
- Me.txtdemo.Text = ""
- '
- 'Label6
- '
- Me.Label6.AutoSize = True
- Me.Label6.Location = New System.Drawing.Point(456, 72)
- Me.Label6.Name = "Label6"
- Me.Label6.Size = New System.Drawing.Size(90, 21)
- Me.Label6.TabIndex = 11
- Me.Label6.Text = "备注/功用:"
- '
- 'txtkhname
- '
- Me.txtkhname.Location = New System.Drawing.Point(80, 62)
- Me.txtkhname.Name = "txtkhname"
- Me.txtkhname.Size = New System.Drawing.Size(136, 25)
- Me.txtkhname.TabIndex = 9
- Me.txtkhname.Text = ""
- '
- 'Label5
- '
- Me.Label5.AutoSize = True
- Me.Label5.Location = New System.Drawing.Point(8, 72)
- Me.Label5.Name = "Label5"
- Me.Label5.Size = New System.Drawing.Size(75, 21)
- Me.Label5.TabIndex = 8
- Me.Label5.Text = "处方名称:"
- '
- 'Label4
- '
- Me.Label4.AutoSize = True
- Me.Label4.Location = New System.Drawing.Point(256, 72)
- Me.Label4.Name = "Label4"
- Me.Label4.Size = New System.Drawing.Size(60, 21)
- Me.Label4.TabIndex = 6
- Me.Label4.Text = "药剂师:"
- '
- 'txtmedname
- '
- Me.txtmedname.Location = New System.Drawing.Point(533, 21)
- Me.txtmedname.Name = "txtmedname"
- Me.txtmedname.Size = New System.Drawing.Size(179, 25)
- Me.txtmedname.TabIndex = 5
- Me.txtmedname.Text = ""
- '
- 'Label3
- '
- Me.Label3.AutoSize = True
- Me.Label3.Location = New System.Drawing.Point(459, 31)
- Me.Label3.Name = "Label3"
- Me.Label3.Size = New System.Drawing.Size(75, 21)
- Me.Label3.TabIndex = 4
- Me.Label3.Text = "药品名称:"
- '
- 'txtendtime
- '
- Me.txtendtime.Location = New System.Drawing.Point(312, 21)
- Me.txtendtime.Name = "txtendtime"
- Me.txtendtime.Size = New System.Drawing.Size(136, 25)
- Me.txtendtime.TabIndex = 3
- Me.txtendtime.Value = New Date(2006, 2, 23, 0, 0, 0, 0)
- '
- 'txtbegintime
- '
- Me.txtbegintime.Location = New System.Drawing.Point(80, 21)
- Me.txtbegintime.Name = "txtbegintime"
- Me.txtbegintime.Size = New System.Drawing.Size(136, 25)
- Me.txtbegintime.TabIndex = 2
- Me.txtbegintime.Value = New Date(2006, 2, 23, 0, 0, 0, 0)
- '
- 'Label2
- '
- Me.Label2.AutoSize = True
- Me.Label2.Location = New System.Drawing.Point(240, 31)
- Me.Label2.Name = "Label2"
- Me.Label2.Size = New System.Drawing.Size(75, 21)
- Me.Label2.TabIndex = 1
- Me.Label2.Text = "结束日期:"
- '
- 'Label1
- '
- Me.Label1.AutoSize = True
- Me.Label1.Location = New System.Drawing.Point(11, 31)
- Me.Label1.Name = "Label1"
- Me.Label1.Size = New System.Drawing.Size(75, 21)
- Me.Label1.TabIndex = 0
- Me.Label1.Text = "开始日期:"
- '
- 'Panel1
- '
- Me.Panel1.Controls.Add(Me.btnPrint)
- Me.Panel1.Controls.Add(Me.btnQuery)
- Me.Panel1.Controls.Add(Me.btnqueryall)
- Me.Panel1.Dock = System.Windows.Forms.DockStyle.Right
- Me.Panel1.Location = New System.Drawing.Point(630, 112)
- Me.Panel1.Name = "Panel1"
- Me.Panel1.Size = New System.Drawing.Size(96, 358)
- Me.Panel1.TabIndex = 9
- '
- 'btnPrint
- '
- Me.btnPrint.Dock = System.Windows.Forms.DockStyle.Top
- Me.btnPrint.FlatStyle = System.Windows.Forms.FlatStyle.Popup
- Me.btnPrint.Location = New System.Drawing.Point(0, 62)
- Me.btnPrint.Name = "btnPrint"
- Me.btnPrint.Size = New System.Drawing.Size(96, 31)
- Me.btnPrint.TabIndex = 5
- Me.btnPrint.Text = "打印"
- '
- 'btnQuery
- '
- Me.btnQuery.Dock = System.Windows.Forms.DockStyle.Top
- Me.btnQuery.FlatStyle = System.Windows.Forms.FlatStyle.Popup
- Me.btnQuery.Location = New System.Drawing.Point(0, 31)
- Me.btnQuery.Name = "btnQuery"
- Me.btnQuery.Size = New System.Drawing.Size(96, 31)
- Me.btnQuery.TabIndex = 4
- Me.btnQuery.Text = "条件查询"
- Me.btnQuery.TextAlign = System.Drawing.ContentAlignment.TopCenter
- '
- 'btnqueryall
- '
- Me.btnqueryall.Dock = System.Windows.Forms.DockStyle.Top
- Me.btnqueryall.FlatStyle = System.Windows.Forms.FlatStyle.Popup
- Me.btnqueryall.Location = New System.Drawing.Point(0, 0)
- Me.btnqueryall.Name = "btnqueryall"
- Me.btnqueryall.Size = New System.Drawing.Size(96, 31)
- Me.btnqueryall.TabIndex = 3
- Me.btnqueryall.Text = "全部查询"
- Me.btnqueryall.TextAlign = System.Drawing.ContentAlignment.TopCenter
- '
- 'Panel2
- '
- Me.Panel2.Controls.Add(Me.dgview)
- Me.Panel2.Dock = System.Windows.Forms.DockStyle.Fill
- Me.Panel2.Location = New System.Drawing.Point(0, 112)
- Me.Panel2.Name = "Panel2"
- Me.Panel2.Size = New System.Drawing.Size(630, 358)
- Me.Panel2.TabIndex = 10
- '
- 'dgview
- '
- Me.dgview.DataMember = ""
- Me.dgview.Dock = System.Windows.Forms.DockStyle.Fill
- Me.dgview.HeaderForeColor = System.Drawing.SystemColors.ControlText
- Me.dgview.Location = New System.Drawing.Point(0, 0)
- Me.dgview.Name = "dgview"
- Me.dgview.Size = New System.Drawing.Size(630, 358)
- Me.dgview.TabIndex = 10
- '
- 'frmmdcfquery
- '
- Me.AutoScaleBaseSize = New System.Drawing.Size(8, 18)
- Me.ClientSize = New System.Drawing.Size(726, 470)
- Me.Controls.Add(Me.Panel2)
- Me.Controls.Add(Me.Panel1)
- Me.Controls.Add(Me.GroupBox1)
- Me.Name = "frmmdcfquery"
- Me.Text = "frmmdcfquery"
- Me.WindowState = System.Windows.Forms.FormWindowState.Maximized
- Me.GroupBox1.ResumeLayout(False)
- Me.Panel1.ResumeLayout(False)
- Me.Panel2.ResumeLayout(False)
- CType(Me.dgview, System.ComponentModel.ISupportInitialize).EndInit()
- Me.ResumeLayout(False)
- End Sub
- #End Region
- Public lsweb As New jxcmanage
- Private Sub frmmdcfquery_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
- txtbegintime.Value = Today.ToString
- txtendtime.Value = Today.ToString
- End Sub
- Private Sub btnQuery_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnQuery.Click
- Dim strmedname, strmedtype, strkhname, strdemo, strquery As String
- If txtmedname.Text = "" Then
- strmedname = ""
- Else
- strmedname = " and MedName='" & txtmedname.Text & "'"
- End If
- If txtmedtype.Text = "" Then
- strmedtype = ""
- Else
- strmedtype = " and Yjs='" & txtmedtype.Text & "'"
- End If
- If txtkhname.Text = "" Then
- strkhname = ""
- Else
- strkhname = " and CfName='" & txtkhname.Text & "'"
- End If
- If txtdemo.Text = "" Then
- strdemo = ""
- Else
- strdemo = " and demo='" & txtdemo.Text & "'"
- End If
- Dim strsql As String
- strsql = "select BillNumber as 票号,Number as 序号,CfName as 处方名称,CDate as 日期,Yjs as 药剂师,MedNumber as 药品编号,MedName as 药品名称,MedRule as 药品规格,Unit as 单位,Lcount as 数量,Price as 单价,Money as 金额,Batch as 批号,Product as 产地,Avaid as 有效期,Package as 包装,Shy as 审核员,Demo as [备注/功用] from mdcf where CDate between '" & txtbegintime.Value & "' and '" & txtendtime.Value & "'" & strmedname & strmedtype & strkhname & strdemo
- lsweb.runSql(strsql)
- Dim dslocal As DataSet
- dslocal = lsweb.runSql(strsql)
- dgview.DataSource = dslocal.Tables(0).DefaultView
- End Sub
- Private Sub btnqueryall_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnqueryall.Click
- Dim strquery As String
- strquery = "select BillNumber as 票号,Number as 序号,CfName as 处方名称,CDate as 日期,Yjs as 药剂师,MedNumber as 药品编号,MedName as 药品名称,MedRule as 药品规格,Unit as 单位,Lcount as 数量,Price as 单价,Money as 金额,Batch as 批号,Product as 产地,Avaid as 有效期,Package as 包装,Shy as 审核员,Demo as [备注/功用] from mdcf"
- lsweb.runSql(strquery)
- Dim dslocal As DataSet
- dslocal = lsweb.runSql(strquery)
- dgview.DataSource = dslocal.Tables(0).DefaultView
- End Sub
- End Class