开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > 企业管理 > 查看源码
SendMedicine.cs
资源名称：VCSDB.rar　[点击查看]
上传用户：hjieqiu
上传日期：2013-05-11
资源大小：16494k
文件大小：16k
源码类别：

企业管理

开发平台：

C#

SendMedicine.cs：源码内容
  1. using System;
  2. using System.Drawing;
  3. using System.Collections;
  4. using System.ComponentModel;
  5. using System.Windows.Forms;
  6. using System.Data;
  7. using System.Data.SqlClient;
  9. namespace 医院管理系统
  10. {
  11. /// <summary>
  12. /// SendMedicine 的摘要说明。
  13. /// </summary>
  14. public class SendMedicine : System.Windows.Forms.Form
  15. {
  16. private System.Windows.Forms.DataGrid dataGrid2;
  17. private System.Data.DataView dataView2;
  18. private System.Windows.Forms.DataGrid dataGrid1;
  19. private System.Data.DataView dataView1;
  20. private System.Data.SqlClient.SqlDataAdapter da2;
  21. private System.Windows.Forms.GroupBox groupBox1;
  22. private System.Windows.Forms.Label label8;
  23. private System.Windows.Forms.Label label4;
  24. private System.Windows.Forms.Button btnSearch;
  25. private System.Windows.Forms.TextBox txt1;
  26. private System.Windows.Forms.TextBox txt2;
  27. private System.Windows.Forms.Label label5;
  28. private System.Windows.Forms.TextBox txt4;
  29. private System.Windows.Forms.TextBox txt3;
  30. private System.Windows.Forms.Label label6;
  31. private System.Windows.Forms.Label label7;
  32. private System.Data.SqlClient.SqlDataAdapter da1;
  33. private 医院管理系统.DataSet3 dataSet31;
  34. private System.Windows.Forms.Button btnSend;
  35. private System.Data.SqlClient.SqlCommand sqlSelectCommand2;
  36. private System.Data.SqlClient.SqlConnection sqlConnection1;
  37. private System.Data.SqlClient.SqlCommand sqlSelectCommand1;
  38. /// <summary>
  39. /// 必需的设计器变量。
  40. /// </summary>
  41. private System.ComponentModel.Container components = null;
  43. public SendMedicine()
  44. {
  45. //
  46. // Windows 窗体设计器支持所必需的
  47. //
  48. InitializeComponent();
  50. //
  51. // TODO: 在 InitializeComponent 调用后添加任何构造函数代码
  52. //
  53. }
  55. /// <summary>
  56. /// 清理所有正在使用的资源。
  57. /// </summary>
  58. protected override void Dispose( bool disposing )
  59. {
  60. if( disposing )
  61. {
  62. if(components != null)
  63. {
  64. components.Dispose();
  65. }
  66. }
  67. base.Dispose( disposing );
  68. }
  70. #region Windows 窗体设计器生成的代码
  71. /// <summary>
  72. /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  73. /// 此方法的内容。
  74. /// </summary>
  75. private void InitializeComponent()
  76. {
  77. System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(SendMedicine));
  78. this.dataGrid2 = new System.Windows.Forms.DataGrid();
  79. this.dataView2 = new System.Data.DataView();
  80. this.dataSet31 = new 医院管理系统.DataSet3();
  81. this.dataGrid1 = new System.Windows.Forms.DataGrid();
  82. this.dataView1 = new System.Data.DataView();
  83. this.da2 = new System.Data.SqlClient.SqlDataAdapter();
  84. this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
  85. this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();
  86. this.groupBox1 = new System.Windows.Forms.GroupBox();
  87. this.btnSend = new System.Windows.Forms.Button();
  88. this.label8 = new System.Windows.Forms.Label();
  89. this.label4 = new System.Windows.Forms.Label();
  90. this.btnSearch = new System.Windows.Forms.Button();
  91. this.txt1 = new System.Windows.Forms.TextBox();
  92. this.txt2 = new System.Windows.Forms.TextBox();
  93. this.label5 = new System.Windows.Forms.Label();
  94. this.txt4 = new System.Windows.Forms.TextBox();
  95. this.txt3 = new System.Windows.Forms.TextBox();
  96. this.label6 = new System.Windows.Forms.Label();
  97. this.label7 = new System.Windows.Forms.Label();
  98. this.da1 = new System.Data.SqlClient.SqlDataAdapter();
  99. this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand();
  100. ((System.ComponentModel.ISupportInitialize)(this.dataGrid2)).BeginInit();
  101. ((System.ComponentModel.ISupportInitialize)(this.dataView2)).BeginInit();
  102. ((System.ComponentModel.ISupportInitialize)(this.dataSet31)).BeginInit();
  103. ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
  104. ((System.ComponentModel.ISupportInitialize)(this.dataView1)).BeginInit();
  105. this.groupBox1.SuspendLayout();
  106. this.SuspendLayout();
  107. // 
  108. // dataGrid2
  109. // 
  110. this.dataGrid2.CaptionVisible = false;
  111. this.dataGrid2.DataMember = "";
  112. this.dataGrid2.DataSource = this.dataView2;
  113. this.dataGrid2.HeaderForeColor = System.Drawing.SystemColors.ControlText;
  114. this.dataGrid2.Location = new System.Drawing.Point(0, 304);
  115. this.dataGrid2.Name = "dataGrid2";
  116. this.dataGrid2.ReadOnly = true;
  117. this.dataGrid2.Size = new System.Drawing.Size(712, 168);
  118. this.dataGrid2.TabIndex = 5;
  119. // 
  120. // dataView2
  121. // 
  122. this.dataView2.Table = this.dataSet31.门诊划价明细;
  123. // 
  124. // dataSet31
  125. // 
  126. this.dataSet31.DataSetName = "DataSet3";
  127. this.dataSet31.Locale = new System.Globalization.CultureInfo("zh-CN");
  128. // 
  129. // dataGrid1
  130. // 
  131. this.dataGrid1.CaptionVisible = false;
  132. this.dataGrid1.DataMember = "";
  133. this.dataGrid1.DataSource = this.dataView1;
  134. this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
  135. this.dataGrid1.Location = new System.Drawing.Point(0, 104);
  136. this.dataGrid1.Name = "dataGrid1";
  137. this.dataGrid1.ReadOnly = true;
  138. this.dataGrid1.Size = new System.Drawing.Size(712, 200);
  139. this.dataGrid1.TabIndex = 4;
  140. // 
  141. // dataView1
  142. // 
  143. this.dataView1.Table = this.dataSet31.门诊划价;
  144. // 
  145. // da2
  146. // 
  147. this.da2.SelectCommand = this.sqlSelectCommand1;
  148. this.da2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
  149.   new System.Data.Common.DataTableMapping("Table", "门诊划价明细", new System.Data.Common.DataColumnMapping[] {
  150. new System.Data.Common.DataColumnMapping("编号", "编号"),
  151. new System.Data.Common.DataColumnMapping("药品编号", "药品编号"),
  152. new System.Data.Common.DataColumnMapping("名称", "名称"),
  153. new System.Data.Common.DataColumnMapping("单价", "单价"),
  154. new System.Data.Common.DataColumnMapping("数量", "数量"),
  155. new System.Data.Common.DataColumnMapping("金额", "金额"),
  156. new System.Data.Common.DataColumnMapping("划价编号", "划价编号")})});
  157. // 
  158. // sqlSelectCommand1
  159. // 
  160. this.sqlSelectCommand1.CommandText = "SELECT DISTINCT a.编号, a.药品编号, b.名称, a.单价, a.数量, a.金额, a.划价编号 FROM 门诊划价明细 a INNER " +
  161. "JOIN v收费项目及药品 b ON a.药品编号 = b.编号";
  162. this.sqlSelectCommand1.Connection = this.sqlConnection1;
  163. // 
  164. // sqlConnection1
  165. // 
  166. this.sqlConnection1.ConnectionString = "workstation id=localhost;packet size=4096;integrated security=SSPI;data source="." +
  167. "";persist security info=False;initial catalog=hisbook";
  168. // 
  169. // groupBox1
  170. // 
  171. this.groupBox1.Controls.Add(this.btnSend);
  172. this.groupBox1.Controls.Add(this.label8);
  173. this.groupBox1.Controls.Add(this.label4);
  174. this.groupBox1.Controls.Add(this.btnSearch);
  175. this.groupBox1.Controls.Add(this.txt1);
  176. this.groupBox1.Controls.Add(this.txt2);
  177. this.groupBox1.Controls.Add(this.label5);
  178. this.groupBox1.Controls.Add(this.txt4);
  179. this.groupBox1.Controls.Add(this.txt3);
  180. this.groupBox1.Controls.Add(this.label6);
  181. this.groupBox1.Controls.Add(this.label7);
  182. this.groupBox1.Location = new System.Drawing.Point(0, 2);
  183. this.groupBox1.Name = "groupBox1";
  184. this.groupBox1.Size = new System.Drawing.Size(712, 100);
  185. this.groupBox1.TabIndex = 3;
  186. this.groupBox1.TabStop = false;
  187. this.groupBox1.Text = "搜索";
  188. // 
  189. // btnSend
  190. // 
  191. this.btnSend.Image = ((System.Drawing.Image)(resources.GetObject("btnSend.Image")));
  192. this.btnSend.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
  193. this.btnSend.Location = new System.Drawing.Point(608, 56);
  194. this.btnSend.Name = "btnSend";
  195. this.btnSend.TabIndex = 6;
  196. this.btnSend.Text = "发药";
  197. this.btnSend.Click += new System.EventHandler(this.btnSend_Click);
  198. // 
  199. // label8
  200. // 
  201. this.label8.Location = new System.Drawing.Point(352, 56);
  202. this.label8.Name = "label8";
  203. this.label8.Size = new System.Drawing.Size(144, 16);
  204. this.label8.TabIndex = 3;
  205. this.label8.Text = "格式如'2004-1-1'";
  206. // 
  207. // label4
  208. // 
  209. this.label4.Location = new System.Drawing.Point(64, 37);
  210. this.label4.Name = "label4";
  211. this.label4.Size = new System.Drawing.Size(32, 16);
  212. this.label4.TabIndex = 2;
  213. this.label4.Text = "编号";
  214. // 
  215. // btnSearch
  216. // 
  217. this.btnSearch.Image = ((System.Drawing.Image)(resources.GetObject("btnSearch.Image")));
  218. this.btnSearch.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
  219. this.btnSearch.Location = new System.Drawing.Point(512, 56);
  220. this.btnSearch.Name = "btnSearch";
  221. this.btnSearch.Size = new System.Drawing.Size(80, 24);
  222. this.btnSearch.TabIndex = 1;
  223. this.btnSearch.Text = "搜索";
  224. this.btnSearch.Click += new System.EventHandler(this.btnSearch_Click);
  225. // 
  226. // txt1
  227. // 
  228. this.txt1.Location = new System.Drawing.Point(96, 32);
  229. this.txt1.Name = "txt1";
  230. this.txt1.Size = new System.Drawing.Size(144, 21);
  231. this.txt1.TabIndex = 0;
  232. this.txt1.Text = "";
  233. // 
  234. // txt2
  235. // 
  236. this.txt2.Location = new System.Drawing.Point(96, 72);
  237. this.txt2.Name = "txt2";
  238. this.txt2.Size = new System.Drawing.Size(144, 21);
  239. this.txt2.TabIndex = 0;
  240. this.txt2.Text = "";
  241. // 
  242. // label5
  243. // 
  244. this.label5.Location = new System.Drawing.Point(64, 72);
  245. this.label5.Name = "label5";
  246. this.label5.Size = new System.Drawing.Size(32, 16);
  247. this.label5.TabIndex = 2;
  248. this.label5.Text = "姓名";
  249. // 
  250. // txt4
  251. // 
  252. this.txt4.Location = new System.Drawing.Point(352, 72);
  253. this.txt4.Name = "txt4";
  254. this.txt4.Size = new System.Drawing.Size(144, 21);
  255. this.txt4.TabIndex = 0;
  256. this.txt4.Text = "";
  257. // 
  258. // txt3
  259. // 
  260. this.txt3.Location = new System.Drawing.Point(352, 32);
  261. this.txt3.Name = "txt3";
  262. this.txt3.Size = new System.Drawing.Size(144, 21);
  263. this.txt3.TabIndex = 0;
  264. this.txt3.Text = "";
  265. // 
  266. // label6
  267. // 
  268. this.label6.Location = new System.Drawing.Point(296, 36);
  269. this.label6.Name = "label6";
  270. this.label6.Size = new System.Drawing.Size(56, 16);
  271. this.label6.TabIndex = 2;
  272. this.label6.Text = "开始时间";
  273. // 
  274. // label7
  275. // 
  276. this.label7.Location = new System.Drawing.Point(296, 76);
  277. this.label7.Name = "label7";
  278. this.label7.Size = new System.Drawing.Size(56, 16);
  279. this.label7.TabIndex = 2;
  280. this.label7.Text = "结束时间";
  281. // 
  282. // da1
  283. // 
  284. this.da1.SelectCommand = this.sqlSelectCommand2;
  285. this.da1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
  286.   new System.Data.Common.DataTableMapping("Table", "门诊划价", new System.Data.Common.DataColumnMapping[] {
  287.   new System.Data.Common.DataColumnMapping("姓名", "姓名"),
  288.   new System.Data.Common.DataColumnMapping("性别", "性别"),
  289.   new System.Data.Common.DataColumnMapping("编号", "编号"),
  290.   new System.Data.Common.DataColumnMapping("科室", "科室"),
  291.   new System.Data.Common.DataColumnMapping("挂号编号", "挂号编号"),
  292.   new System.Data.Common.DataColumnMapping("医生", "医生"),
  293.   new System.Data.Common.DataColumnMapping("划价时间", "划价时间"),
  294.   new System.Data.Common.DataColumnMapping("划价员", "划价员"),
  295.   new System.Data.Common.DataColumnMapping("是否收费", "是否收费"),
  296.   new System.Data.Common.DataColumnMapping("收费员", "收费员"),
  297.   new System.Data.Common.DataColumnMapping("收费时间", "收费时间"),
  298.   new System.Data.Common.DataColumnMapping("划价金额", "划价金额"),
  299.   new System.Data.Common.DataColumnMapping("是否发药", "是否发药"),
  300.   new System.Data.Common.DataColumnMapping("发药时间", "发药时间"),
  301.   new System.Data.Common.DataColumnMapping("发药员", "发药员")})});
  302. // 
  303. // sqlSelectCommand2
  304. // 
  305. this.sqlSelectCommand2.CommandText = "SELECT b.姓名, b.性别, a.编号, a.科室, a.挂号编号, a.医生, a.划价时间, a.划价员, a.是否收费, a.收费员, a.收费时间" +
  306. ", a.划价金额, a.是否发药, a.发药时间, a.发药员 FROM 门诊划价 a INNER JOIN 门诊挂号 b ON a.挂号编号 = b.编号 W" +
  307. "HERE (a.是否发药 = '否') AND (a.是否收费 = '是')";
  308. this.sqlSelectCommand2.Connection = this.sqlConnection1;
  309. // 
  310. // SendMedicine
  311. // 
  312. this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
  313. this.ClientSize = new System.Drawing.Size(712, 477);
  314. this.Controls.Add(this.dataGrid2);
  315. this.Controls.Add(this.dataGrid1);
  316. this.Controls.Add(this.groupBox1);
  317. this.Name = "SendMedicine";
  318. this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
  319. this.Text = "【药房发药】";
  320. this.Load += new System.EventHandler(this.SendMedicine_Load);
  321. ((System.ComponentModel.ISupportInitialize)(this.dataGrid2)).EndInit();
  322. ((System.ComponentModel.ISupportInitialize)(this.dataView2)).EndInit();
  323. ((System.ComponentModel.ISupportInitialize)(this.dataSet31)).EndInit();
  324. ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
  325. ((System.ComponentModel.ISupportInitialize)(this.dataView1)).EndInit();
  326. this.groupBox1.ResumeLayout(false);
  327. this.ResumeLayout(false);
  329. }
  330. #endregion
  334. //------------初始化窗体时读入全部数据-------------
  335. private void SendMedicine_Load(object sender, System.EventArgs e)
  336. {
  337. //填充数据集
  338. da1.Fill(dataSet31);
  339. da2.Fill(dataSet31);
  340. //显示时，首先显示第一个划价单的明细
  341. dataView2.RowFilter="划价编号='"+dataGrid1[0,2].ToString().Trim()+"'";
  342. //明细数据根据选择的划价单编号而变化
  343. dataGrid1.CurrentCellChanged+=new EventHandler(dataGrid1_CurrentCellChanged);
  344. }
  345. //------------根据输入条件检索划价数据--------------
  346. private void btnSearch_Click(object sender, System.EventArgs e)
  347. {
  348. string filter="";
  349. if(txt1.Text.Trim()!="")
  350. {
  351. filter+="编号 like '%"+txt1.Text.Trim()+"%' AND ";
  352. }
  353. if(txt2.Text.Trim()!="")
  354. {
  355. filter+="姓名 like '%"+txt2.Text.Trim()+"%' AND ";
  356. }
  357. if(txt3.Text.Trim()!="")
  358. {
  359. filter+="划价时间>='"+txt3.Text.Trim()+"' AND ";
  360. }
  361. if(txt4.Text.Trim()!="")
  362. {
  363. filter+="划价时间<='"+txt4.Text.Trim()+"' AND ";
  364. }
  365. int length=filter.Length;
  366. if(length>0)
  367. {
  368. filter=filter.Substring(0,length-5);
  369. }
  370. dataView1.RowFilter=filter;
  371. if(dataView1.Count>0)//有确定的划价数据再显示明细
  372. {
  373. dataView2.RowFilter="划价编号='"+dataGrid1[0,2].ToString().Trim()+"'";
  374. }
  375. }
  377. //------------执行收费-----------
  378. private void btnSend_Click(object sender, System.EventArgs e)
  379. {
  380. if(dataView1.Count==0)//必须有选中的数据
  381. {
  382. MessageBox.Show("表中为空，无法执行发药","提示",MessageBoxButtons.OK,MessageBoxIcon.Stop);
  383. return;
  384. }
  386. //执行发药，更新数据库
  387. string strConn="workstation id=localhost;Integrated Security=SSPI;Database=hisbook;";
  388. SqlConnection cn=new SqlConnection(strConn);
  389. cn.Open();
  390. SqlCommand cmd=cn.CreateCommand();
  391. cmd.CommandText="exec sf_药品发出 "+dataGrid1[dataGrid1.CurrentRowIndex,2].ToString().Trim();
  392. cmd.ExecuteNonQuery();
  393. dataSet31.Clear();//刷新数据集
  394. da1.Fill(dataSet31);
  395. da2.Fill(dataSet31);
  396. if(dataView1.Count>0)//若已收费的划价单已空，则不需要再显示明细
  397. {
  398. dataView2.RowFilter="划价编号='"+dataGrid1[0,2].ToString().Trim()+"'";
  399. }
  400. }
  402. //-------------显示单据明细----------------
  403. private void dataGrid1_CurrentCellChanged(object sender, EventArgs e)
  404. {
  405. int i=dataGrid1.CurrentRowIndex;
  406. dataView2.RowFilter="划价编号='"+dataGrid1[i,2].ToString().Trim()+"'";
  407. }
  408. }
  409. }