?? medinfo.cs
字號:
this.txt13.Size = new System.Drawing.Size(64, 21);
this.txt13.TabIndex = 33;
this.txt13.Text = "";
//
// label14
//
this.label14.Location = new System.Drawing.Point(248, 72);
this.label14.Name = "label14";
this.label14.Size = new System.Drawing.Size(56, 16);
this.label14.TabIndex = 20;
this.label14.Text = "費用歸類";
//
// label15
//
this.label15.Location = new System.Drawing.Point(328, 72);
this.label15.Name = "label15";
this.label15.Size = new System.Drawing.Size(88, 16);
this.label15.TabIndex = 26;
this.label15.Text = "拼音碼";
//
// txt17
//
this.txt17.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "藥品資料.下限"));
this.txt17.Location = new System.Drawing.Point(624, 88);
this.txt17.Name = "txt17";
this.txt17.ReadOnly = true;
this.txt17.Size = new System.Drawing.Size(80, 21);
this.txt17.TabIndex = 32;
this.txt17.Text = "";
//
// label18
//
this.label18.Location = new System.Drawing.Point(624, 72);
this.label18.Name = "label18";
this.label18.Size = new System.Drawing.Size(56, 16);
this.label18.TabIndex = 20;
this.label18.Text = "下限";
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT 編號, 名稱, 規格, 整量單位, 散量單位, 入庫單價, 出庫單價, 批發價, 整散比, 分類, 費用歸類, 拼音碼, 效期, 上限, 下限 FR" +
"OM 藥品資料 WHERE (拼音碼 LIKE @Param4 OR 拼音碼 IS NULL) AND (名稱 LIKE @Param5) AND (編號 LI" +
"KE @Param6)";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param4", System.Data.SqlDbType.VarChar, 50, "拼音碼"));
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param5", System.Data.SqlDbType.VarChar, 150, "名稱"));
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param6", System.Data.SqlDbType.VarChar, 20, "編號"));
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "workstation id=localhost;packet size=4096;integrated security=SSPI;data source=\"." +
"\";persist security info=False;initial catalog=hisbook";
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = @"INSERT INTO 藥品資料(編號, 名稱, 規格, 整量單位, 散量單位, 入庫單價, 出庫單價, 批發價, 整散比, 分類, 費用歸類, 拼音碼, 效期, 上限, 下限) VALUES (@編號, @名稱, @規格, @整量單位, @散量單位, @入庫單價, @出庫單價, @批發價, @整散比, @分類, @費用歸類, @拼音碼, @效期, @上限, @下限); SELECT 編號, 名稱, 規格, 整量單位, 散量單位, 入庫單價, 出庫單價, 批發價, 整散比, 分類, 費用歸類, 拼音碼, 效期, 上限, 下限 FROM 藥品資料 WHERE (編號 = @編號)";
this.sqlInsertCommand1.Connection = this.sqlConnection1;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@編號", System.Data.SqlDbType.VarChar, 20, "編號"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@名稱", System.Data.SqlDbType.VarChar, 150, "名稱"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@規格", System.Data.SqlDbType.VarChar, 100, "規格"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@整量單位", System.Data.SqlDbType.VarChar, 50, "整量單位"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@散量單位", System.Data.SqlDbType.VarChar, 50, "散量單位"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@入庫單價", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(12)), ((System.Byte)(2)), "入庫單價", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@出庫單價", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(12)), ((System.Byte)(2)), "出庫單價", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@批發價", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(12)), ((System.Byte)(2)), "批發價", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@整散比", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(12)), ((System.Byte)(2)), "整散比", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@分類", System.Data.SqlDbType.VarChar, 100, "分類"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@費用歸類", System.Data.SqlDbType.VarChar, 100, "費用歸類"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@拼音碼", System.Data.SqlDbType.VarChar, 50, "拼音碼"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@效期", System.Data.SqlDbType.Int, 4, "效期"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@上限", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(12)), ((System.Byte)(2)), "上限", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@下限", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(12)), ((System.Byte)(2)), "下限", System.Data.DataRowVersion.Current, null));
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = @"UPDATE 藥品資料 SET 編號 = @編號, 名稱 = @名稱, 規格 = @規格, 整量單位 = @整量單位, 散量單位 = @散量單位, 入庫單價 = @入庫單價, 出庫單價 = @出庫單價, 批發價 = @批發價, 整散比 = @整散比, 分類 = @分類, 費用歸類 = @費用歸類, 拼音碼 = @拼音碼, 效期 = @效期, 上限 = @上限, 下限 = @下限 WHERE (編號 = @Original_編號) AND (上限 = @Original_上限 OR @Original_上限 IS NULL AND 上限 IS NULL) AND (下限 = @Original_下限 OR @Original_下限 IS NULL AND 下限 IS NULL) AND (入庫單價 = @Original_入庫單價 OR @Original_入庫單價 IS NULL AND 入庫單價 IS NULL) AND (出庫單價 = @Original_出庫單價 OR @Original_出庫單價 IS NULL AND 出庫單價 IS NULL) AND (分類 = @Original_分類 OR @Original_分類 IS NULL AND 分類 IS NULL) AND (名稱 = @Original_名稱 OR @Original_名稱 IS NULL AND 名稱 IS NULL) AND (批發價 = @Original_批發價 OR @Original_批發價 IS NULL AND 批發價 IS NULL) AND (拼音碼 = @Original_拼音碼 OR @Original_拼音碼 IS NULL AND 拼音碼 IS NULL) AND (效期 = @Original_效期 OR @Original_效期 IS NULL AND 效期 IS NULL) AND (散量單位 = @Original_散量單位 OR @Original_散量單位 IS NULL AND 散量單位 IS NULL) AND (整散比 = @Original_整散比 OR @Original_整散比 IS NULL AND 整散比 IS NULL) AND (整量單位 = @Original_整量單位 OR @Original_整量單位 IS NULL AND 整量單位 IS NULL) AND (規格 = @Original_規格 OR @Original_規格 IS NULL AND 規格 IS NULL) AND (費用歸類 = @Original_費用歸類 OR @Original_費用歸類 IS NULL AND 費用歸類 IS NULL); SELECT 編號, 名稱, 規格, 整量單位, 散量單位, 入庫單價, 出庫單價, 批發價, 整散比, 分類, 費用歸類, 拼音碼, 效期, 上限, 下限 FROM 藥品資料 WHERE (編號 = @編號)";
this.sqlUpdateCommand1.Connection = this.sqlConnection1;
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@編號", System.Data.SqlDbType.VarChar, 20, "編號"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@名稱", System.Data.SqlDbType.VarChar, 150, "名稱"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@規格", System.Data.SqlDbType.VarChar, 100, "規格"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@整量單位", System.Data.SqlDbType.VarChar, 50, "整量單位"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@散量單位", System.Data.SqlDbType.VarChar, 50, "散量單位"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@入庫單價", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(12)), ((System.Byte)(2)), "入庫單價", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@出庫單價", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(12)), ((System.Byte)(2)), "出庫單價", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@批發價", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(12)), ((System.Byte)(2)), "批發價", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@整散比", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(12)), ((System.Byte)(2)), "整散比", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@分類", System.Data.SqlDbType.VarChar, 100, "分類"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@費用歸類", System.Data.SqlDbType.VarChar, 100, "費用歸類"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@拼音碼", System.Data.SqlDbType.VarChar, 50, "拼音碼"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@效期", System.Data.SqlDbType.Int, 4, "效期"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@上限", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(12)), ((System.Byte)(2)), "上限", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@下限", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(12)), ((System.Byte)(2)), "下限", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_編號", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "編號", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_上限", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(12)), ((System.Byte)(2)), "上限", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_下限", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(12)), ((System.Byte)(2)), "下限", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_入庫單價", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(12)), ((System.Byte)(2)), "入庫單價", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_出庫單價", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(12)), ((System.Byte)(2)), "出庫單價", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_分類", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "分類", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_名稱", System.Data.SqlDbType.VarChar, 150, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "名稱", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_批發價", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(12)), ((System.Byte)(2)), "批發價", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_拼音碼", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "拼音碼", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_效期", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "效期", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_散量單位", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "散量單位", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_整散比", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(12)), ((System.Byte)(2)), "整散比", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_整量單位", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "整量單位", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_規格", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "規格", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_費用歸類", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "費用歸類", System.Data.DataRowVersion.Original, null));
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = @"DELETE FROM 藥品資料 WHERE (編號 = @Original_編號) AND (上限 = @Original_上限 OR @Original_上限 IS NULL AND 上限 IS NULL) AND (下限 = @Original_下限 OR @Original_下限 IS NULL AND 下限 IS NULL) AND (入庫單價 = @Original_入庫單價 OR @Original_入庫單價 IS NULL AND 入庫單價 IS NULL) AND (出庫單價 = @Original_出庫單價 OR @Original_出庫單價 IS NULL AND 出庫單價 IS NULL) AND (分類 = @Original_分類 OR @Original_分類 IS NULL AND 分類 IS NULL) AND (名稱 = @Original_名稱 OR @Original_名稱 IS NULL AND 名稱 IS NULL) AND (批發價 = @Original_批發價 OR @Original_批發價 IS NULL AND 批發價 IS NULL) AND (拼音碼 = @Original_拼音碼 OR @Original_拼音碼 IS NULL AND 拼音碼 IS NULL) AND (效期 = @Original_效期 OR @Original_效期 IS NULL AND 效期 IS NULL) AND (散量單位 = @Original_散量單位 OR @Original_散量單位 IS NULL AND 散量單位 IS NULL) AND (整散比 = @Original_整散比 OR @Original_整散比 IS NULL AND 整散比 IS NULL) AND (整量單位 = @Original_整量單位 OR @Original_整量單位 IS NULL AND 整量單位 IS NULL) AND (規格 = @Original_規格 OR @Original_規格 IS NULL AND 規格 IS NULL) AND (費用歸類 = @Original_費用歸類 OR @Original_費用歸類 IS NULL AND 費用歸類 IS NULL)";
this.sqlDeleteCommand1.Connection = this.sqlConnection1;
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_編號", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "編號", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_上限", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(12)), ((System.Byte)(2)), "上限", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_下限", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(12)), ((System.Byte)(2)), "下限", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_入庫單價", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(12)), ((System.Byte)(2)), "入庫單價", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_出庫單價", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(12)), ((System.Byte)(2)), "出庫單價", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_分類", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "分類", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_名稱", System.Data.SqlDbType.VarChar, 150, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "名稱", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_批發價", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(12)), ((System.Byte)(2)), "批發價", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_拼音碼", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "拼音碼", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_效期", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "效期", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_散量單位", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "散量單位", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_整散比", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(12)), ((System.Byte)(2)), "整散比", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_整量單位", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "整量單位", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_規格", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "規格", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_費用歸類", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "費用歸類", System.Data.DataRowVersion.Original, null));
//
// MedInfo
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(728, 502);
this.Name = "MedInfo";
this.Text = "【藥品信息】";
this.Load += new System.EventHandler(this.MedInfo_Load);
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
this.groupBox2.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
} #endregion
//--------------創建窗體時，讀入藥品資料，并設置藥品分類選項--------------------
private void MedInfo_Load(object sender, System.EventArgs e)
{
da1.SelectCommand.Parameters[0].Value="%%";
da1.SelectCommand.Parameters[1].Value="%%";
da1.SelectCommand.Parameters[2].Value="%%";
da1.Fill(dataSet11);
this.cmOrders=(CurrencyManager) BindingContext[dataSet11,"藥品資料"];
base.dataSet11=this.dataSet11;//基類中有一個dataSet11和cmOrders相連
//添加【藥品分類】下拉菜單的下拉選項
cmb1.Items.Clear();
string strConn="workstation id=localhost;Integrated Security=SSPI;Database=hisbook;";
SqlConnection cn=new SqlConnection(strConn);
cn.Open();
SqlCommand cmd=cn.CreateCommand();
cmd.CommandText="select distinct 名稱 from 藥品分類";
SqlDataReader dr=cmd.ExecuteReader();
while(dr.Read())
{
cmb1.Items.Add(dr.GetValue(0).ToString().Trim());
}
}
//----------根據輸入的信息，查詢藥品信息--------
private void btnSearch_Click(object sender, System.EventArgs e)
{
da1.SelectCommand.Parameters[0].Value="%%";
da1.SelectCommand.Parameters[1].Value="%%";
da1.SelectCommand.Parameters[2].Value="%%";
if(txt1.Text!="")
{
da1.SelectCommand.Parameters[0].Value="%"+txt1.Text+"%";
}
if(txt2.Text!="")
{
da1.SelectCommand.Parameters[1].Value="%"+txt2.Text+"%";
}
if(txt3.Text!="")
{
da1.SelectCommand.Parameters[2].Value="%"+txt3.Text+"%";
}
dataSet11.藥品資料.Clear();//刷新數據集
da1.Fill(dataSet11);
base.dataSet11=this.dataSet11;
}
//----------重寫函數，檢查藥品資料窗體中的非空字段-----------
protected override bool CheckNotNull()
{
if(txt4.Text.Trim()=="")//檢查藥品編號
{
MessageBox.Show("藥品編號不能為空，請輸入編號","提示",MessageBoxButtons.OK,MessageBoxIcon.Warning);
return(false);
}
if(txt5.Text.Trim()=="")//檢查藥品名稱
{
MessageBox.Show("藥品名稱不能為空，請輸入名稱","提示",MessageBoxButtons.OK,MessageBoxIcon.Warning);
return(false);
}
return(base.CheckNotNull());
}
//----------設置各個文本框的編輯屬性-----------------
protected override void SetModifyMode(bool blnEdit)
{
base.SetModifyMode (blnEdit);
txt4.ReadOnly=!blnEdit;
txt5.ReadOnly=!blnEdit;
txt6.ReadOnly=!blnEdit;
txt7.ReadOnly=!blnEdit;
txt8.ReadOnly=!blnEdit;
txt9.ReadOnly=!blnEdit;
txt10.ReadOnly=!blnEdit;
txt11.ReadOnly=!blnEdit;
txt12.ReadOnly=!blnEdit;
txt13.ReadOnly=!blnEdit;
txt14.ReadOnly=!blnEdit;
txt15.ReadOnly=!blnEdit;
txt16.ReadOnly=!blnEdit;
txt17.ReadOnly=!blnEdit;
cmb1.Enabled=blnEdit;
}
}}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -