sendmedicine.cs

医院门诊收费系统

			// 
			this.label1.Location = new System.Drawing.Point(16, 32);
			this.label1.Name = "label1";
			this.label1.TabIndex = 4;
			this.label1.Text = "编号";
			// 
			// txt4
			// 
			this.txt4.Location = new System.Drawing.Point(400, 56);
			this.txt4.Name = "txt4";
			this.txt4.TabIndex = 3;
			this.txt4.Text = "";
			// 
			// txt3
			// 
			this.txt3.Location = new System.Drawing.Point(120, 64);
			this.txt3.Name = "txt3";
			this.txt3.TabIndex = 2;
			this.txt3.Text = "";
			// 
			// txt2
			// 
			this.txt2.Location = new System.Drawing.Point(400, 24);
			this.txt2.Name = "txt2";
			this.txt2.TabIndex = 1;
			this.txt2.Text = "";
			// 
			// txt1
			// 
			this.txt1.Location = new System.Drawing.Point(120, 32);
			this.txt1.Name = "txt1";
			this.txt1.TabIndex = 0;
			this.txt1.Text = "";
			// 
			// da1
			// 
			this.da1.SelectCommand = this.sqlSelectCommand1;
			this.da1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																						  new System.Data.Common.DataTableMapping("Table", "门诊划价", 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("挂号编号", "挂号编号"),
																																																  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("收费时间", "收费时间"),
																																																  new System.Data.Common.DataColumnMapping("划价金额", "划价金额"),
																																																  new System.Data.Common.DataColumnMapping("是否发药", "是否发药"),
																																																  new System.Data.Common.DataColumnMapping("发药时间", "发药时间"),
																																																  new System.Data.Common.DataColumnMapping("发药员", "发药员")})});
			// 
			// sqlSelectCommand1
			// 
			this.sqlSelectCommand1.CommandText = "SELECT b.姓名, b.性别, a.编号, a.科室, a.挂号编号, a.医生, a.划价时间, a.划价员, a.是否收费, a.收费员, a.收费时间" +
				", a.划价金额, a.是否发药, a.发药时间, a.发药员 FROM 门诊划价 a INNER JOIN 门诊挂号 b ON a.挂号编号 = b.编号 W" +
				"HERE (a.是否发药 = \'否\') AND (a.是否收费 = \'是\')";
			this.sqlSelectCommand1.Connection = this.sqlConnection1;
			// 
			// sqlConnection1
			// 
			this.sqlConnection1.ConnectionString = "workstation id=BRIGHT;packet size=4096;user id=sa;data source=BRIGHT;persist secu" +
				"rity info=False;initial catalog=hospitalms";
			// 
			// da2
			// 
			this.da2.SelectCommand = this.sqlSelectCommand2;
			this.da2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																						  new System.Data.Common.DataTableMapping("Table", "门诊划价明细", 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("数量", "数量"),
																																																	new System.Data.Common.DataColumnMapping("金额", "金额"),
																																																	new System.Data.Common.DataColumnMapping("划价编号", "划价编号")})});
			// 
			// sqlSelectCommand2
			// 
			this.sqlSelectCommand2.CommandText = "SELECT DISTINCT a.编号, a.药品编号, b.名称, a.单价, a.数量, a.金额, a.划价编号 FROM 门诊划价明细 a INNER " +
				"JOIN v收费项目及药品 b ON a.药品编号 = b.编号";
			this.sqlSelectCommand2.Connection = this.sqlConnection1;
			// 
			// SendMedicine
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(840, 416);
			this.Controls.Add(this.dataGrid2);
			this.Controls.Add(this.dataGrid1);
			this.Controls.Add(this.groupBox1);
			this.Name = "SendMedicine";
			this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
			this.Text = "SendMedicine";
			this.Load += new System.EventHandler(this.SendMedicine_Load);
			((System.ComponentModel.ISupportInitialize)(this.dataGrid2)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.dataView2)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.dataSet31)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.dataView1)).EndInit();
			this.groupBox1.ResumeLayout(false);
			this.ResumeLayout(false);

		}
		#endregion
	

		private void SendMedicine_Load(object sender, System.EventArgs e)
		{
			
			try
			{
				dataSet31.EnforceConstraints=false;//去掉约束
				da1.Fill(dataSet31);
				da2.Fill(dataSet31);
			
				dataView2.RowFilter="划价编号='"+dataGrid1[0,2].ToString().Trim()+"'";
				
				dataGrid1.CurrentCellChanged+=new EventHandler(dataGrid1_CurrentCellChanged);
			}
			catch(Exception ex)
			{
				MessageBox.Show(ex.Message);
			}
		}
    
		private void btnSearch_Click(object sender, System.EventArgs e)
		{
			string filter="";
			if(txt1.Text.Trim()!="")
			{
				filter+="编号 like '%"+txt1.Text.Trim()+"%' AND ";
			}
			if(txt2.Text.Trim()!="")
			{
				filter+="姓名 like '%"+txt2.Text.Trim()+"%' AND ";
			}
			if(txt3.Text.Trim()!="")
			{
				filter+="划价时间>='"+txt3.Text.Trim()+"' AND ";
			}
			if(txt4.Text.Trim()!="")
			{
				filter+="划价时间<='"+txt4.Text.Trim()+"' AND ";
			}
			int length=filter.Length;
			if(length>0)
			{
				filter=filter.Substring(0,length-5);
			}
			dataView1.RowFilter=filter;
			if(dataView1.Count>0)
			{				
				dataView2.RowFilter="划价编号='"+dataGrid1[0,2].ToString().Trim()+"'";
			}
		}
     
		private void btnSend_Click(object sender, System.EventArgs e)
		{
			string message = "确认是否要发药";
			string caption = "确认框";
			MessageBoxButtons buttons = MessageBoxButtons.YesNo;
			DialogResult result;
                result = MessageBox.Show(this, message, caption, buttons,
				MessageBoxIcon.Question, MessageBoxDefaultButton.Button1, 
				MessageBoxOptions.RightAlign);

			if(result == DialogResult.Yes)
			{
                
				if(dataView1.Count==0)
				{
					MessageBox.Show("表中为空，无法执行发药","提示",MessageBoxButtons.OK,MessageBoxIcon.Stop);
					
				}
				else
				{
					string strConn="workstation id=localhost;Integrated Security=SSPI;Database=hospitalms;";
					SqlConnection cn=new SqlConnection(strConn);
					cn.Open();
					SqlCommand cmd=cn.CreateCommand();
					cmd.CommandText="exec sf_药品发出 "+dataGrid1[dataGrid1.CurrentRowIndex,2].ToString().Trim();
					cmd.ExecuteNonQuery();
					dataSet31.Clear();
					da1.Fill(dataSet31);
					da2.Fill(dataSet31);
					if(dataView1.Count>0)
					{
						dataView2.RowFilter="划价编号='"+dataGrid1[0,2].ToString().Trim()+"'";
					}	
					MessageBox.Show("发药成功","提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
				}
				return;
			}
		}
      
		private void dataGrid1_CurrentCellChanged(object sender, System.EventArgs e)
		{
			int i=dataGrid1.CurrentRowIndex;
			dataView2.RowFilter="划价编号='"+dataGrid1[i,2].ToString().Trim()+"'";
		}
		
	
	}
}