?? sendmedicine.cs
字號:
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
namespace 醫(yī)院管理系統(tǒng)
{
/// <summary>
/// SendMedicine 的摘要說明。
/// </summary>
public class SendMedicine : System.Windows.Forms.Form
{
private System.Windows.Forms.DataGrid dataGrid2;
private System.Data.DataView dataView2;
private System.Windows.Forms.DataGrid dataGrid1;
private System.Data.DataView dataView1;
private System.Data.SqlClient.SqlDataAdapter da2;
private System.Windows.Forms.GroupBox groupBox1;
private System.Windows.Forms.Label label8;
private System.Windows.Forms.Label label4;
private System.Windows.Forms.Button btnSearch;
private System.Windows.Forms.TextBox txt1;
private System.Windows.Forms.TextBox txt2;
private System.Windows.Forms.Label label5;
private System.Windows.Forms.TextBox txt4;
private System.Windows.Forms.TextBox txt3;
private System.Windows.Forms.Label label6;
private System.Windows.Forms.Label label7;
private System.Data.SqlClient.SqlDataAdapter da1;
private 醫(yī)院管理系統(tǒng).DataSet3 dataSet31;
private System.Windows.Forms.Button btnSend;
private System.Data.SqlClient.SqlCommand sqlSelectCommand2;
private System.Data.SqlClient.SqlConnection sqlConnection1;
private System.Data.SqlClient.SqlCommand sqlSelectCommand1;
/// <summary>
/// 必需的設(shè)計器變量。
/// </summary>
private System.ComponentModel.Container components = null;
public SendMedicine()
{
//
// Windows 窗體設(shè)計器支持所必需的
//
InitializeComponent();
//
// TODO: 在 InitializeComponent 調(diào)用后添加任何構(gòu)造函數(shù)代碼
//
}
/// <summary>
/// 清理所有正在使用的資源。
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if(components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows 窗體設(shè)計器生成的代碼
/// <summary>
/// 設(shè)計器支持所需的方法 - 不要使用代碼編輯器修改
/// 此方法的內(nèi)容。
/// </summary>
private void InitializeComponent()
{
System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(SendMedicine));
this.dataGrid2 = new System.Windows.Forms.DataGrid();
this.dataView2 = new System.Data.DataView();
this.dataSet31 = new 醫(yī)院管理系統(tǒng).DataSet3();
this.dataGrid1 = new System.Windows.Forms.DataGrid();
this.dataView1 = new System.Data.DataView();
this.da2 = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.btnSend = new System.Windows.Forms.Button();
this.label8 = new System.Windows.Forms.Label();
this.label4 = new System.Windows.Forms.Label();
this.btnSearch = new System.Windows.Forms.Button();
this.txt1 = new System.Windows.Forms.TextBox();
this.txt2 = new System.Windows.Forms.TextBox();
this.label5 = new System.Windows.Forms.Label();
this.txt4 = new System.Windows.Forms.TextBox();
this.txt3 = new System.Windows.Forms.TextBox();
this.label6 = new System.Windows.Forms.Label();
this.label7 = new System.Windows.Forms.Label();
this.da1 = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand();
((System.ComponentModel.ISupportInitialize)(this.dataGrid2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataView2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet31)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataView1)).BeginInit();
this.groupBox1.SuspendLayout();
this.SuspendLayout();
//
// dataGrid2
//
this.dataGrid2.CaptionVisible = false;
this.dataGrid2.DataMember = "";
this.dataGrid2.DataSource = this.dataView2;
this.dataGrid2.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid2.Location = new System.Drawing.Point(0, 304);
this.dataGrid2.Name = "dataGrid2";
this.dataGrid2.ReadOnly = true;
this.dataGrid2.Size = new System.Drawing.Size(712, 168);
this.dataGrid2.TabIndex = 5;
//
// dataView2
//
this.dataView2.Table = this.dataSet31.門診劃價明細(xì);
//
// dataSet31
//
this.dataSet31.DataSetName = "DataSet3";
this.dataSet31.Locale = new System.Globalization.CultureInfo("zh-CN");
//
// dataGrid1
//
this.dataGrid1.CaptionVisible = false;
this.dataGrid1.DataMember = "";
this.dataGrid1.DataSource = this.dataView1;
this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid1.Location = new System.Drawing.Point(0, 104);
this.dataGrid1.Name = "dataGrid1";
this.dataGrid1.ReadOnly = true;
this.dataGrid1.Size = new System.Drawing.Size(712, 200);
this.dataGrid1.TabIndex = 4;
//
// dataView1
//
this.dataView1.Table = this.dataSet31.門診劃價;
//
// da2
//
this.da2.SelectCommand = this.sqlSelectCommand1;
this.da2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "門診劃價明細(xì)", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("編號", "編號"),
new System.Data.Common.DataColumnMapping("藥品編號", "藥品編號"),
new System.Data.Common.DataColumnMapping("名稱", "名稱"),
new System.Data.Common.DataColumnMapping("單價", "單價"),
new System.Data.Common.DataColumnMapping("數(shù)量", "數(shù)量"),
new System.Data.Common.DataColumnMapping("金額", "金額"),
new System.Data.Common.DataColumnMapping("劃價編號", "劃價編號")})});
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT DISTINCT a.編號, a.藥品編號, b.名稱, a.單價, a.數(shù)量, a.金額, a.劃價編號 FROM 門診劃價明細(xì) a INNER " +
"JOIN v收費項目及藥品 b ON a.藥品編號 = b.編號";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "workstation id=localhost;packet size=4096;integrated security=SSPI;data source=\"." +
"\";persist security info=False;initial catalog=hisbook";
//
// groupBox1
//
this.groupBox1.Controls.Add(this.btnSend);
this.groupBox1.Controls.Add(this.label8);
this.groupBox1.Controls.Add(this.label4);
this.groupBox1.Controls.Add(this.btnSearch);
this.groupBox1.Controls.Add(this.txt1);
this.groupBox1.Controls.Add(this.txt2);
this.groupBox1.Controls.Add(this.label5);
this.groupBox1.Controls.Add(this.txt4);
this.groupBox1.Controls.Add(this.txt3);
this.groupBox1.Controls.Add(this.label6);
this.groupBox1.Controls.Add(this.label7);
this.groupBox1.Location = new System.Drawing.Point(0, 2);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(712, 100);
this.groupBox1.TabIndex = 3;
this.groupBox1.TabStop = false;
this.groupBox1.Text = "搜索";
//
// btnSend
//
this.btnSend.Image = ((System.Drawing.Image)(resources.GetObject("btnSend.Image")));
this.btnSend.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
this.btnSend.Location = new System.Drawing.Point(608, 56);
this.btnSend.Name = "btnSend";
this.btnSend.TabIndex = 6;
this.btnSend.Text = "發(fā)藥";
this.btnSend.Click += new System.EventHandler(this.btnSend_Click);
//
// label8
//
this.label8.Location = new System.Drawing.Point(352, 56);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(144, 16);
this.label8.TabIndex = 3;
this.label8.Text = "格式如\'2004-1-1\'";
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -