📄 medinfo.cs
字号:
this.txt6.Name = "txt6";
this.txt6.ReadOnly = true;
this.txt6.Size = new System.Drawing.Size(48, 21);
this.txt6.TabIndex = 57;
this.txt6.Text = "";
//
// txt7
//
this.txt7.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "药品资料.整量单位"));
this.txt7.Location = new System.Drawing.Point(336, 344);
this.txt7.Name = "txt7";
this.txt7.ReadOnly = true;
this.txt7.Size = new System.Drawing.Size(48, 21);
this.txt7.TabIndex = 60;
this.txt7.Text = "";
//
// txt8
//
this.txt8.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "药品资料.散量单位"));
this.txt8.Location = new System.Drawing.Point(400, 344);
this.txt8.Name = "txt8";
this.txt8.ReadOnly = true;
this.txt8.Size = new System.Drawing.Size(48, 21);
this.txt8.TabIndex = 68;
this.txt8.Text = "";
//
// txt9
//
this.txt9.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "药品资料.入库单价"));
this.txt9.Location = new System.Drawing.Point(464, 344);
this.txt9.Name = "txt9";
this.txt9.ReadOnly = true;
this.txt9.Size = new System.Drawing.Size(64, 21);
this.txt9.TabIndex = 65;
this.txt9.Text = "";
//
// txt10
//
this.txt10.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "药品资料.出库单价"));
this.txt10.Location = new System.Drawing.Point(544, 344);
this.txt10.Name = "txt10";
this.txt10.ReadOnly = true;
this.txt10.Size = new System.Drawing.Size(72, 21);
this.txt10.TabIndex = 62;
this.txt10.Text = "";
//
// txt11
//
this.txt11.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "药品资料.批发价"));
this.txt11.Location = new System.Drawing.Point(632, 344);
this.txt11.Name = "txt11";
this.txt11.ReadOnly = true;
this.txt11.Size = new System.Drawing.Size(72, 21);
this.txt11.TabIndex = 55;
this.txt11.Text = "";
//
// txt12
//
this.txt12.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "药品资料.整散比"));
this.txt12.Location = new System.Drawing.Point(24, 408);
this.txt12.Name = "txt12";
this.txt12.ReadOnly = true;
this.txt12.Size = new System.Drawing.Size(72, 21);
this.txt12.TabIndex = 56;
this.txt12.Text = "";
//
// txt15
//
this.txt15.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "药品资料.效期"));
this.txt15.Location = new System.Drawing.Point(432, 408);
this.txt15.Name = "txt15";
this.txt15.ReadOnly = true;
this.txt15.Size = new System.Drawing.Size(64, 21);
this.txt15.TabIndex = 66;
this.txt15.Text = "";
//
// txt16
//
this.txt16.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "药品资料.上限"));
this.txt16.Location = new System.Drawing.Point(520, 408);
this.txt16.Name = "txt16";
this.txt16.ReadOnly = true;
this.txt16.Size = new System.Drawing.Size(80, 21);
this.txt16.TabIndex = 61;
this.txt16.Text = "";
//
// txt14
//
this.txt14.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "药品资料.拼音码"));
this.txt14.Location = new System.Drawing.Point(328, 408);
this.txt14.Name = "txt14";
this.txt14.ReadOnly = true;
this.txt14.Size = new System.Drawing.Size(80, 21);
this.txt14.TabIndex = 64;
this.txt14.Text = "";
//
// txt13
//
this.txt13.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "药品资料.费用归类"));
this.txt13.Location = new System.Drawing.Point(248, 408);
this.txt13.Name = "txt13";
this.txt13.ReadOnly = true;
this.txt13.Size = new System.Drawing.Size(64, 21);
this.txt13.TabIndex = 67;
this.txt13.Text = "";
//
// txt17
//
this.txt17.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "药品资料.下限"));
this.txt17.Location = new System.Drawing.Point(624, 408);
this.txt17.Name = "txt17";
this.txt17.ReadOnly = true;
this.txt17.Size = new System.Drawing.Size(80, 21);
this.txt17.TabIndex = 63;
this.txt17.Text = "";
//
// label5
//
this.label5.Location = new System.Drawing.Point(104, 328);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(56, 16);
this.label5.TabIndex = 45;
this.label5.Text = "名称";
//
// label6
//
this.label6.Location = new System.Drawing.Point(272, 328);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(56, 16);
this.label6.TabIndex = 46;
this.label6.Text = "规格";
//
// label9
//
this.label9.Location = new System.Drawing.Point(336, 328);
this.label9.Name = "label9";
this.label9.Size = new System.Drawing.Size(56, 16);
this.label9.TabIndex = 40;
this.label9.Text = "整量单位";
//
// label11
//
this.label11.Location = new System.Drawing.Point(464, 328);
this.label11.Name = "label11";
this.label11.Size = new System.Drawing.Size(56, 16);
this.label11.TabIndex = 43;
this.label11.Text = "入库单价";
//
// label12
//
this.label12.Location = new System.Drawing.Point(400, 328);
this.label12.Name = "label12";
this.label12.Size = new System.Drawing.Size(56, 16);
this.label12.TabIndex = 51;
this.label12.Text = "散量单位";
//
// label17
//
this.label17.Location = new System.Drawing.Point(544, 328);
this.label17.Name = "label17";
this.label17.Size = new System.Drawing.Size(88, 16);
this.label17.TabIndex = 53;
this.label17.Text = "出库单价";
//
// label16
//
this.label16.Location = new System.Drawing.Point(632, 328);
this.label16.Name = "label16";
this.label16.Size = new System.Drawing.Size(56, 16);
this.label16.TabIndex = 47;
this.label16.Text = "批发价";
//
// label7
//
this.label7.Location = new System.Drawing.Point(24, 392);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(56, 16);
this.label7.TabIndex = 48;
this.label7.Text = "整散比";
//
// label8
//
this.label8.Location = new System.Drawing.Point(120, 392);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(56, 16);
this.label8.TabIndex = 49;
this.label8.Text = "分类";
//
// label10
//
this.label10.Location = new System.Drawing.Point(536, 392);
this.label10.Name = "label10";
this.label10.Size = new System.Drawing.Size(56, 16);
this.label10.TabIndex = 42;
this.label10.Text = "上限";
//
// label13
//
this.label13.Location = new System.Drawing.Point(440, 392);
this.label13.Name = "label13";
this.label13.Size = new System.Drawing.Size(56, 16);
this.label13.TabIndex = 54;
this.label13.Text = "有效期";
//
// label14
//
this.label14.Location = new System.Drawing.Point(256, 392);
this.label14.Name = "label14";
this.label14.Size = new System.Drawing.Size(56, 16);
this.label14.TabIndex = 41;
this.label14.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, "编号"));
//
// 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, "规格"));
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -