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

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

企业管理

开发平台：

C#

ClinicReg.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. /// ClinicReg 的摘要说明。
  13. /// </summary>
  14. public class ClinicReg : System.Windows.Forms.Form
  15. {
  16. private string regID,infoID;//保存门诊挂号编号和病人信息库编号
  17. private System.Windows.Forms.GroupBox groupBox1;
  18. private System.Windows.Forms.GroupBox groupBox2;
  19. private System.Windows.Forms.GroupBox groupBox3;
  20. private System.Windows.Forms.Label label1;
  21. private System.Windows.Forms.TextBox txt1;
  22. private System.Windows.Forms.Label label2;
  23. private System.Windows.Forms.ComboBox cmb1;
  24. private System.Windows.Forms.TextBox txt2;
  25. private System.Windows.Forms.Label label3;
  26. private System.Windows.Forms.Label label4;
  27. private System.Windows.Forms.ComboBox cmb2;
  28. private System.Windows.Forms.Label label5;
  29. private System.Windows.Forms.ComboBox cmb3;
  30. private System.Windows.Forms.Label label6;
  31. private System.Windows.Forms.ComboBox cmb4;
  32. private System.Windows.Forms.Label label7;
  33. private System.Windows.Forms.ComboBox cmb5;
  34. private System.Windows.Forms.Label label8;
  35. private System.Windows.Forms.ComboBox cmb6;
  36. private System.Windows.Forms.Label label9;
  37. private System.Windows.Forms.Label label10;
  38. private System.Windows.Forms.ImageList imageList1;
  39. protected System.Windows.Forms.ToolBar toolBar1;
  40. private System.Windows.Forms.ToolBarButton tBtnNew;
  41. private System.Windows.Forms.ToolBarButton tBtnSubmit;
  42. private System.Windows.Forms.ToolBarButton tBtnCancel;
  43. private System.Windows.Forms.ToolBarButton tBtnQuit;
  44. private System.Windows.Forms.TextBox txt3;
  45. private System.Windows.Forms.TextBox txt4;
  46. private System.Windows.Forms.TextBox txt5;
  47. private System.Windows.Forms.TextBox txt6;
  48. private System.Windows.Forms.TextBox txt7;
  49. private System.Windows.Forms.TextBox txt8;
  50. private System.ComponentModel.IContainer components;
  52. public ClinicReg()
  53. {
  54. //
  55. // Windows 窗体设计器支持所必需的
  56. //
  57. InitializeComponent();
  59. //
  60. // TODO: 在 InitializeComponent 调用后添加任何构造函数代码
  61. //
  62. }
  64. /// <summary>
  65. /// 清理所有正在使用的资源。
  66. /// </summary>
  67. protected override void Dispose( bool disposing )
  68. {
  69. if( disposing )
  70. {
  71. if(components != null)
  72. {
  73. components.Dispose();
  74. }
  75. }
  76. base.Dispose( disposing );
  77. }
  79. #region Windows 窗体设计器生成的代码
  80. /// <summary>
  81. /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  82. /// 此方法的内容。
  83. /// </summary>
  84. private void InitializeComponent()
  85. {
  86. this.components = new System.ComponentModel.Container();
  87. System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(ClinicReg));
  88. this.txt5 = new System.Windows.Forms.TextBox();
  89. this.txt6 = new System.Windows.Forms.TextBox();
  90. this.txt7 = new System.Windows.Forms.TextBox();
  91. this.txt8 = new System.Windows.Forms.TextBox();
  92. this.groupBox1 = new System.Windows.Forms.GroupBox();
  93. this.label5 = new System.Windows.Forms.Label();
  94. this.cmb1 = new System.Windows.Forms.ComboBox();
  95. this.txt1 = new System.Windows.Forms.TextBox();
  96. this.label1 = new System.Windows.Forms.Label();
  97. this.groupBox2 = new System.Windows.Forms.GroupBox();
  98. this.groupBox3 = new System.Windows.Forms.GroupBox();
  99. this.label2 = new System.Windows.Forms.Label();
  100. this.txt2 = new System.Windows.Forms.TextBox();
  101. this.label3 = new System.Windows.Forms.Label();
  102. this.label4 = new System.Windows.Forms.Label();
  103. this.cmb2 = new System.Windows.Forms.ComboBox();
  104. this.cmb3 = new System.Windows.Forms.ComboBox();
  105. this.label6 = new System.Windows.Forms.Label();
  106. this.cmb4 = new System.Windows.Forms.ComboBox();
  107. this.label7 = new System.Windows.Forms.Label();
  108. this.cmb5 = new System.Windows.Forms.ComboBox();
  109. this.label8 = new System.Windows.Forms.Label();
  110. this.cmb6 = new System.Windows.Forms.ComboBox();
  111. this.label9 = new System.Windows.Forms.Label();
  112. this.txt3 = new System.Windows.Forms.TextBox();
  113. this.txt4 = new System.Windows.Forms.TextBox();
  114. this.label10 = new System.Windows.Forms.Label();
  115. this.imageList1 = new System.Windows.Forms.ImageList(this.components);
  116. this.toolBar1 = new System.Windows.Forms.ToolBar();
  117. this.tBtnNew = new System.Windows.Forms.ToolBarButton();
  118. this.tBtnSubmit = new System.Windows.Forms.ToolBarButton();
  119. this.tBtnCancel = new System.Windows.Forms.ToolBarButton();
  120. this.tBtnQuit = new System.Windows.Forms.ToolBarButton();
  121. this.groupBox1.SuspendLayout();
  122. this.SuspendLayout();
  123. // 
  124. // txt5
  125. // 
  126. this.txt5.BackColor = System.Drawing.SystemColors.Desktop;
  127. this.txt5.Enabled = false;
  128. this.txt5.Location = new System.Drawing.Point(0, 472);
  129. this.txt5.Name = "txt5";
  130. this.txt5.TabIndex = 0;
  131. this.txt5.Text = "必填";
  132. this.txt5.TextAlign = System.Windows.Forms.HorizontalAlignment.Center;
  133. // 
  134. // txt6
  135. // 
  136. this.txt6.Enabled = false;
  137. this.txt6.Location = new System.Drawing.Point(104, 472);
  138. this.txt6.Name = "txt6";
  139. this.txt6.TabIndex = 0;
  140. this.txt6.Text = "选填";
  141. this.txt6.TextAlign = System.Windows.Forms.HorizontalAlignment.Center;
  142. // 
  143. // txt7
  144. // 
  145. this.txt7.BackColor = System.Drawing.SystemColors.ControlLight;
  146. this.txt7.Enabled = false;
  147. this.txt7.Location = new System.Drawing.Point(208, 472);
  148. this.txt7.Name = "txt7";
  149. this.txt7.TabIndex = 0;
  150. this.txt7.Text = "自动";
  151. this.txt7.TextAlign = System.Windows.Forms.HorizontalAlignment.Center;
  152. // 
  153. // txt8
  154. // 
  155. this.txt8.BackColor = System.Drawing.SystemColors.Control;
  156. this.txt8.Enabled = false;
  157. this.txt8.Location = new System.Drawing.Point(312, 472);
  158. this.txt8.Name = "txt8";
  159. this.txt8.Size = new System.Drawing.Size(368, 21);
  160. this.txt8.TabIndex = 0;
  161. this.txt8.Text = "";
  162. // 
  163. // groupBox1
  164. // 
  165. this.groupBox1.Controls.Add(this.label5);
  166. this.groupBox1.Controls.Add(this.cmb1);
  167. this.groupBox1.Controls.Add(this.txt1);
  168. this.groupBox1.Controls.Add(this.label1);
  169. this.groupBox1.Controls.Add(this.groupBox2);
  170. this.groupBox1.Controls.Add(this.groupBox3);
  171. this.groupBox1.Controls.Add(this.label2);
  172. this.groupBox1.Controls.Add(this.txt2);
  173. this.groupBox1.Controls.Add(this.label3);
  174. this.groupBox1.Controls.Add(this.label4);
  175. this.groupBox1.Controls.Add(this.cmb2);
  176. this.groupBox1.Controls.Add(this.cmb3);
  177. this.groupBox1.Controls.Add(this.label6);
  178. this.groupBox1.Controls.Add(this.cmb4);
  179. this.groupBox1.Controls.Add(this.label7);
  180. this.groupBox1.Controls.Add(this.cmb5);
  181. this.groupBox1.Controls.Add(this.label8);
  182. this.groupBox1.Controls.Add(this.cmb6);
  183. this.groupBox1.Controls.Add(this.label9);
  184. this.groupBox1.Controls.Add(this.txt3);
  185. this.groupBox1.Controls.Add(this.txt4);
  186. this.groupBox1.Controls.Add(this.label10);
  187. this.groupBox1.Location = new System.Drawing.Point(0, 40);
  188. this.groupBox1.Name = "groupBox1";
  189. this.groupBox1.Size = new System.Drawing.Size(680, 432);
  190. this.groupBox1.TabIndex = 1;
  191. this.groupBox1.TabStop = false;
  192. this.groupBox1.Text = "挂号信息";
  193. // 
  194. // label5
  195. // 
  196. this.label5.Location = new System.Drawing.Point(72, 160);
  197. this.label5.Name = "label5";
  198. this.label5.Size = new System.Drawing.Size(56, 16);
  199. this.label5.TabIndex = 4;
  200. this.label5.Text = "费用类型";
  201. // 
  202. // cmb1
  203. // 
  204. this.cmb1.Items.AddRange(new object[] {
  205.   "男",
  206.   "女"});
  207. this.cmb1.Location = new System.Drawing.Point(208, 61);
  208. this.cmb1.Name = "cmb1";
  209. this.cmb1.Size = new System.Drawing.Size(104, 20);
  210. this.cmb1.TabIndex = 3;
  211. // 
  212. // txt1
  213. // 
  214. this.txt1.BackColor = System.Drawing.SystemColors.Desktop;
  215. this.txt1.Location = new System.Drawing.Point(56, 61);
  216. this.txt1.Name = "txt1";
  217. this.txt1.TabIndex = 2;
  218. this.txt1.Text = "";
  219. // 
  220. // label1
  221. // 
  222. this.label1.Location = new System.Drawing.Point(24, 64);
  223. this.label1.Name = "label1";
  224. this.label1.Size = new System.Drawing.Size(32, 16);
  225. this.label1.TabIndex = 1;
  226. this.label1.Text = "姓名";
  227. // 
  228. // groupBox2
  229. // 
  230. this.groupBox2.Location = new System.Drawing.Point(8, 120);
  231. this.groupBox2.Name = "groupBox2";
  232. this.groupBox2.Size = new System.Drawing.Size(664, 8);
  233. this.groupBox2.TabIndex = 0;
  234. this.groupBox2.TabStop = false;
  235. // 
  236. // groupBox3
  237. // 
  238. this.groupBox3.Location = new System.Drawing.Point(8, 288);
  239. this.groupBox3.Name = "groupBox3";
  240. this.groupBox3.Size = new System.Drawing.Size(664, 8);
  241. this.groupBox3.TabIndex = 0;
  242. this.groupBox3.TabStop = false;
  243. // 
  244. // label2
  245. // 
  246. this.label2.Location = new System.Drawing.Point(176, 64);
  247. this.label2.Name = "label2";
  248. this.label2.Size = new System.Drawing.Size(32, 16);
  249. this.label2.TabIndex = 1;
  250. this.label2.Text = "性别";
  251. // 
  252. // txt2
  253. // 
  254. this.txt2.Location = new System.Drawing.Point(368, 61);
  255. this.txt2.Name = "txt2";
  256. this.txt2.TabIndex = 2;
  257. this.txt2.Text = "";
  258. // 
  259. // label3
  260. // 
  261. this.label3.Location = new System.Drawing.Point(488, 64);
  262. this.label3.Name = "label3";
  263. this.label3.Size = new System.Drawing.Size(32, 16);
  264. this.label3.TabIndex = 1;
  265. this.label3.Text = "民族";
  266. // 
  267. // label4
  268. // 
  269. this.label4.Location = new System.Drawing.Point(336, 64);
  270. this.label4.Name = "label4";
  271. this.label4.Size = new System.Drawing.Size(32, 16);
  272. this.label4.TabIndex = 1;
  273. this.label4.Text = "年龄";
  274. // 
  275. // cmb2
  276. // 
  277. this.cmb2.Items.AddRange(new object[] {
  278.   "汉族",
  279.   "满族",
  280.   "蒙古族",
  281.   "回族",
  282.   "藏族",
  283.   "维吾尔族",
  284.   "哈萨克族"});
  285. this.cmb2.Location = new System.Drawing.Point(520, 61);
  286. this.cmb2.Name = "cmb2";
  287. this.cmb2.Size = new System.Drawing.Size(104, 20);
  288. this.cmb2.TabIndex = 3;
  289. // 
  290. // cmb3
  291. // 
  292. this.cmb3.BackColor = System.Drawing.SystemColors.Desktop;
  293. this.cmb3.Items.AddRange(new object[] {
  294.   "自费",
  295.   "公费",
  296.   "离休"});
  297. this.cmb3.Location = new System.Drawing.Point(128, 160);
  298. this.cmb3.Name = "cmb3";
  299. this.cmb3.Size = new System.Drawing.Size(136, 20);
  300. this.cmb3.TabIndex = 3;
  301. // 
  302. // label6
  303. // 
  304. this.label6.Location = new System.Drawing.Point(328, 160);
  305. this.label6.Name = "label6";
  306. this.label6.Size = new System.Drawing.Size(56, 16);
  307. this.label6.TabIndex = 4;
  308. this.label6.Text = "挂号类型";
  309. // 
  310. // cmb4
  311. // 
  312. this.cmb4.Items.AddRange(new object[] {
  313.   "普通",
  314.   "专家号20元",
  315.   "专家号5元"});
  316. this.cmb4.Location = new System.Drawing.Point(384, 160);
  317. this.cmb4.Name = "cmb4";
  318. this.cmb4.Size = new System.Drawing.Size(144, 20);
  319. this.cmb4.TabIndex = 3;
  320. this.cmb4.SelectionChangeCommitted += new System.EventHandler(this.cmb4_SelectionChangeCommitted);
  321. // 
  322. // label7
  323. // 
  324. this.label7.Location = new System.Drawing.Point(72, 220);
  325. this.label7.Name = "label7";
  326. this.label7.Size = new System.Drawing.Size(56, 16);
  327. this.label7.TabIndex = 4;
  328. this.label7.Text = "挂号科室";
  329. // 
  330. // cmb5
  331. // 
  332. this.cmb5.BackColor = System.Drawing.SystemColors.Desktop;
  333. this.cmb5.Location = new System.Drawing.Point(128, 216);
  334. this.cmb5.Name = "cmb5";
  335. this.cmb5.Size = new System.Drawing.Size(136, 20);
  336. this.cmb5.TabIndex = 3;
  337. // 
  338. // label8
  339. // 
  340. this.label8.Location = new System.Drawing.Point(328, 219);
  341. this.label8.Name = "label8";
  342. this.label8.Size = new System.Drawing.Size(56, 16);
  343. this.label8.TabIndex = 4;
  344. this.label8.Text = "医生";
  345. this.label8.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
  346. // 
  347. // cmb6
  348. // 
  349. this.cmb6.BackColor = System.Drawing.SystemColors.Desktop;
  350. this.cmb6.Location = new System.Drawing.Point(384, 216);
  351. this.cmb6.Name = "cmb6";
  352. this.cmb6.Size = new System.Drawing.Size(144, 20);
  353. this.cmb6.TabIndex = 3;
  354. this.cmb6.DropDown += new System.EventHandler(this.cmb6_DropDown);
  355. // 
  356. // label9
  357. // 
  358. this.label9.Location = new System.Drawing.Point(128, 328);
  359. this.label9.Name = "label9";
  360. this.label9.Size = new System.Drawing.Size(56, 16);
  361. this.label9.TabIndex = 1;
  362. this.label9.Text = "挂号费用";
  363. // 
  364. // txt3
  365. // 
  366. this.txt3.Location = new System.Drawing.Point(128, 344);
  367. this.txt3.Name = "txt3";
  368. this.txt3.ReadOnly = true;
  369. this.txt3.Size = new System.Drawing.Size(136, 21);
  370. this.txt3.TabIndex = 2;
  371. this.txt3.Text = "";
  372. // 
  373. // txt4
  374. // 
  375. this.txt4.Location = new System.Drawing.Point(384, 344);
  376. this.txt4.Name = "txt4";
  377. this.txt4.ReadOnly = true;
  378. this.txt4.Size = new System.Drawing.Size(144, 21);
  379. this.txt4.TabIndex = 2;
  380. this.txt4.Text = "";
  381. // 
  382. // label10
  383. // 
  384. this.label10.Location = new System.Drawing.Point(384, 328);
  385. this.label10.Name = "label10";
  386. this.label10.Size = new System.Drawing.Size(64, 16);
  387. this.label10.TabIndex = 1;
  388. this.label10.Text = "挂号时间";
  389. // 
  390. // imageList1
  391. // 
  392. this.imageList1.ImageSize = new System.Drawing.Size(16, 16);
  393. this.imageList1.ImageStream = ((System.Windows.Forms.ImageListStreamer)(resources.GetObject("imageList1.ImageStream")));
  394. this.imageList1.TransparentColor = System.Drawing.SystemColors.ControlLightLight;
  395. // 
  396. // toolBar1
  397. // 
  398. this.toolBar1.Buttons.AddRange(new System.Windows.Forms.ToolBarButton[] {
  399. this.tBtnNew,
  400. this.tBtnSubmit,
  401. this.tBtnCancel,
  402. this.tBtnQuit});
  403. this.toolBar1.DropDownArrows = true;
  404. this.toolBar1.ImageList = this.imageList1;
  405. this.toolBar1.Location = new System.Drawing.Point(0, 0);
  406. this.toolBar1.Name = "toolBar1";
  407. this.toolBar1.ShowToolTips = true;
  408. this.toolBar1.Size = new System.Drawing.Size(680, 41);
  409. this.toolBar1.TabIndex = 30;
  410. this.toolBar1.ButtonClick += new System.Windows.Forms.ToolBarButtonClickEventHandler(this.toolBar1_ButtonClick);
  411. // 
  412. // tBtnNew
  413. // 
  414. this.tBtnNew.ImageIndex = 4;
  415. this.tBtnNew.Text = "新增";
  416. this.tBtnNew.ToolTipText = "新增";
  417. // 
  418. // tBtnSubmit
  419. // 
  420. this.tBtnSubmit.ImageIndex = 7;
  421. this.tBtnSubmit.Text = "保存";
  422. this.tBtnSubmit.ToolTipText = "保存";
  423. // 
  424. // tBtnCancel
  425. // 
  426. this.tBtnCancel.ImageIndex = 8;
  427. this.tBtnCancel.Text = "取消";
  428. this.tBtnCancel.ToolTipText = "取消";
  429. // 
  430. // tBtnQuit
  431. // 
  432. this.tBtnQuit.ImageIndex = 9;
  433. this.tBtnQuit.Text = "退出";
  434. this.tBtnQuit.ToolTipText = "退出";
  435. // 
  436. // ClinicReg
  437. // 
  438. this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
  439. this.ClientSize = new System.Drawing.Size(680, 493);
  440. this.Controls.Add(this.groupBox1);
  441. this.Controls.Add(this.txt5);
  442. this.Controls.Add(this.txt6);
  443. this.Controls.Add(this.txt7);
  444. this.Controls.Add(this.txt8);
  445. this.Controls.Add(this.toolBar1);
  446. this.Name = "ClinicReg";
  447. this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
  448. this.Text = "【门诊挂号】";
  449. this.Load += new System.EventHandler(this.ClinicReg_Load);
  450. this.groupBox1.ResumeLayout(false);
  451. this.ResumeLayout(false);
  453. }
  454. #endregion
  456. //-----------创建窗体时设置下拉列表框项目---------------
  457. private void ClinicReg_Load(object sender, System.EventArgs e)
  458. {
  459. //设置【科室资料】下拉列表框的下拉选项
  460. string strConn="workstation id=localhost;Integrated Security=SSPI;database=hisbook;";
  461. SqlConnection cn=new SqlConnection(strConn);
  462. cn.Open();
  463. SqlCommand cmb=cn.CreateCommand();
  464. cmb.CommandText="select distinct 名称 from 科室资料";
  465. SqlDataReader dr=cmb.ExecuteReader();
  466. cmb5.Items.Clear();
  467. while(dr.Read())
  468. {
  469. cmb5.Items.Add(dr.GetValue(0).ToString().Trim());
  470. }
  471. dr.Close();
  472. }
  474. //--------------工具栏控制代码------------------
  475. private void toolBar1_ButtonClick(object sender, System.Windows.Forms.ToolBarButtonClickEventArgs e)
  476. {
  477. if(e.Button.ToolTipText=="新增")
  478. {
  479. this.SetDefaultValue();//设置默认值
  480. //生成新编号
  481. this.regID=this.CreateNewID("select max(编号) 最大编号 from 门诊挂号");
  482. this.infoID=this.CreateNewID("select max(编号) 最大编号 from 病人信息库");
  483. }
  484. if(e.Button.ToolTipText=="保存")
  485. {
  486. if(this.CheckNotNull()==false)
  487. {
  488. return;
  489. }
  490. this.SaveReg();
  491. this.clearInfo();
  493. }
  494. if(e.Button.ToolTipText=="取消")
  495. {
  496. this.clearInfo();
  498. }
  499. if(e.Button.ToolTipText=="退出")
  500. {
  501. this.Close();
  502. }
  503. }
  505. //-------------根据选择的科室显示医生清单------------
  506. private void cmb6_DropDown(object sender, System.EventArgs e)
  507. {
  508. //设置【医生】下拉列表框的下拉选项
  509. cmb6.Items.Clear();//清空原有下拉选项
  510. if(cmb5.Text.Trim()=="")
  511. {
  512. return;
  513. }
  514. string strConn="workstation id=localhost;Integrated Security=SSPI;database=hisbook;";
  515. SqlConnection cn=new SqlConnection(strConn);
  516. cn.Open();
  517. SqlCommand cmb=cn.CreateCommand();
  518. cmb.CommandText="select distinct 姓名 from 医生资料 where 科室='"+cmb5.Text.Trim()+"'";
  519. SqlDataReader dr=cmb.ExecuteReader();
  520. while(dr.Read())
  521. {
  522. cmb6.Items.Add(dr.GetValue(0).ToString().Trim());
  523. }
  524. dr.Close();
  525. }
  527. //-----------清空面板中的信息------------
  528. private void clearInfo()
  529. {
  530. txt1.Clear();
  531. txt2.Clear();
  532. txt3.Clear();
  533. txt4.Clear();
  534. cmb1.Text="";
  535. cmb2.Text="";
  536. cmb3.Text="";
  537. cmb4.Text="";
  538. cmb5.Text="";
  539. cmb6.Text="";
  540. }
  541. //-----------新增病人时设置默认信息------------
  542. private void SetDefaultValue()
  543. {
  544. cmb1.SelectedText="男";//默认性别为男性
  545. cmb2.SelectedText="汉族";//默认民族为汉族
  546. cmb3.SelectedText="自费";//默认费用类型为自费
  547. cmb4.SelectedText="普通";//默认挂号类型为普通
  548. cmb5.SelectedText="内科";//默认挂号科室为内科
  549. txt3.Text="1";//默认挂号费1元
  550. txt4.Text=System.DateTime.Now.ToString();//当前系统时间为挂号时间
  551. }
  553. //----------根据挂号类型设置挂号费用-----------
  554. private void cmb4_SelectionChangeCommitted(object sender, System.EventArgs e)
  555. {
  556. if(cmb4.SelectedIndex==0)//普通号1元
  557. {
  558. txt3.Text="1";
  559. }
  560. if(cmb4.SelectedIndex==1)//20元专家号
  561. {
  562. txt3.Text="20";
  563. }
  564. if(cmb4.SelectedIndex==2)//5元专家号
  565. {
  566. txt3.Text="5";
  567. }
  569. }
  571. //---------------检查非空字段--------------
  572. private bool CheckNotNull()
  573. {
  574. if(txt1.Text.Trim()=="")
  575. {
  576. MessageBox.Show("病人姓名不能为空,请输入姓名","提示",MessageBoxButtons.OK,MessageBoxIcon.Stop);
  577. return(false);
  578. }
  579. if(cmb3.Text.Trim()=="")
  580. {
  581. MessageBox.Show("费用类型不能为空,请选择费用类型","提示",MessageBoxButtons.OK,MessageBoxIcon.Stop);
  582. return(false);
  583. }
  584. if(cmb5.Text.Trim()=="")
  585. {
  586. MessageBox.Show("挂号科室不能为空,请选择挂号科室","提示",MessageBoxButtons.OK,MessageBoxIcon.Stop);
  587. return(false);
  588. }
  589. if(cmb6.Text.Trim()=="")
  590. {
  591. MessageBox.Show("未选择医生或您选择的挂号科室没有医生","提示",MessageBoxButtons.OK,MessageBoxIcon.Stop);
  592. return(false);
  593. }
  594. return(true);
  595. }
  596. //-----------保存挂号信息和病人信息-------------
  597. private void SaveReg()
  598. {
  599. string strConn="workstation id=localhost;Integrated Security=SSPI;database=hisbook;";
  600. SqlConnection cn=new SqlConnection(strConn);
  601. cn.Open();
  602. SqlCommand cmb=cn.CreateCommand();
  604. string insertStr="insert into 病人信息库([编号], [姓名], [性别], [年龄], [民族], [费用类型]) "
  605. +"values('"+infoID+"','"+txt1.Text.Trim()+"','"+cmb1.Text.Trim()+"','"+txt2.Text.Trim()
  606. +"','"+cmb2.Text.Trim()+"','"+cmb3.Text.Trim()+"')";
  607. cmb.CommandText=insertStr;
  608. try
  609. {
  610. cmb.ExecuteNonQuery();
  611. }
  612. catch(Exception express)
  613. {
  614. MessageBox.Show(express.ToString(),"新增病人信息错误",MessageBoxButtons.OK,MessageBoxIcon.Error);
  615. return;
  616. }
  617. insertStr="insert into 门诊挂号([编号], [病人编号], [姓名], [性别], [挂号科室], [费用类型],"
  618.                 +"[挂号类型], [挂号费用], [医生], [时间], [是否已划价]) "
  619. +"values('"+regID+"','"+infoID+"','"+txt1.Text.Trim()+"','"+cmb1.Text.Trim()+"','"
  620. +cmb5.Text.Trim()+"','"+cmb3.Text.Trim()+"','"+cmb4.Text.Trim()+"',CAST('"+txt3.Text
  621. +"' as decimal),'"+cmb6.Text.Trim()+"','"+txt4.Text+"','否')";
  622. cmb.CommandText=insertStr;
  623. try
  624. {
  625. cmb.ExecuteNonQuery();
  626. }
  627. catch(Exception express)
  628. {
  629. MessageBox.Show(express.ToString(),"新增门诊挂号错误",MessageBoxButtons.OK,MessageBoxIcon.Error);
  630. return;
  631. }
  634. }
  636. //---------在新增信息时，根据sql语句计算并设置新的门诊挂号编号和病人信息---------
  637. private string CreateNewID(string sql)
  638. {
  639. string strConn="workstation id=localhost;Integrated Security=SSPI;database=hisbook;";
  640. SqlConnection cn=new SqlConnection(strConn);
  641. cn.Open();
  642. SqlCommand cmb=cn.CreateCommand();
  643. cmb.CommandText=sql;
  644. string result;
  645. if(cmb.ExecuteScalar()!=System.DBNull.Value)
  646. {
  647. result=cmb.ExecuteScalar().ToString().Trim();
  648. }
  649. else
  650. {
  651. return(System.DateTime.Now.Year.ToString()+"0000001");//命名规则为年份+7位编号
  652. }
  653. result=result.Substring(4,7);
  654. int newID=Convert.ToInt32(result)+1;
  655. int length=newID.ToString().Length;
  656. string returnStr=System.DateTime.Now.Year.ToString();
  657. switch(length)//生成新的编码
  658. {
  659. case 1:
  660. returnStr+="000000"+newID.ToString();
  661. break;
  662. case 2:
  663. returnStr+="00000"+newID.ToString();
  664. break;
  665. case 3:
  666. returnStr+="0000"+newID.ToString();
  667. break;
  668. case 4:
  669. returnStr+="000"+newID.ToString();
  670. break;
  671. case 5:
  672. returnStr+="00"+newID.ToString();
  673. break;
  674. case 6:
  675. returnStr+="0"+newID.ToString();
  676. break;
  677. case 7:
  678. returnStr+=newID.ToString();
  679. break;
  680. }
  681. return(returnStr);
  682. }
  683. }
  684. }