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

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

企业管理

开发平台：

C#

ClinicCharge.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. /// ClinicCharge 的摘要说明。
  13. /// </summary>
  14. public class ClinicCharge : System.Windows.Forms.Form
  15. {
  16. private System.Windows.Forms.GroupBox groupBox1;
  17. private System.Windows.Forms.DataGrid dataGrid1;
  18. private System.Windows.Forms.DataGrid dataGrid2;
  19. private System.Windows.Forms.Label label1;
  20. private System.Windows.Forms.Label label2;
  21. private System.Windows.Forms.Label label3;
  22. private System.Data.SqlClient.SqlDataAdapter da2;
  23. private System.Data.SqlClient.SqlDataAdapter da1;
  24. private 医院管理系统.DataSet2 dataSet21;
  25. private System.Data.DataView dataView1;
  26. private System.Data.DataView dataView2;
  27. private System.Windows.Forms.TextBox txt5;
  28. private System.Windows.Forms.TextBox txt6;
  29. private System.Windows.Forms.TextBox txt7;
  30. private System.Windows.Forms.TextBox txt1;
  31. private System.Windows.Forms.TextBox txt2;
  32. private System.Windows.Forms.Label label4;
  33. private System.Windows.Forms.Label label5;
  34. private System.Windows.Forms.TextBox txt4;
  35. private System.Windows.Forms.TextBox txt3;
  36. private System.Windows.Forms.Label label6;
  37. private System.Windows.Forms.Label label7;
  38. private System.Windows.Forms.Label label8;
  39. private System.Windows.Forms.Button btnCash;
  40. private System.Windows.Forms.Button btnSearch;
  41. private System.Data.SqlClient.SqlCommand sqlSelectCommand2;
  42. private System.Data.SqlClient.SqlConnection sqlConnection1;
  43. private System.Data.SqlClient.SqlCommand sqlSelectCommand1;
  44. /// <summary>
  45. /// 必需的设计器变量。
  46. /// </summary>
  47. private System.ComponentModel.Container components = null;
  49. public ClinicCharge()
  50. {
  51. //
  52. // Windows 窗体设计器支持所必需的
  53. //
  54. InitializeComponent();
  56. //
  57. // TODO: 在 InitializeComponent 调用后添加任何构造函数代码
  58. //
  59. }
  61. /// <summary>
  62. /// 清理所有正在使用的资源。
  63. /// </summary>
  64. protected override void Dispose( bool disposing )
  65. {
  66. if( disposing )
  67. {
  68. if(components != null)
  69. {
  70. components.Dispose();
  71. }
  72. }
  73. base.Dispose( disposing );
  74. }
  76. #region Windows 窗体设计器生成的代码
  77. /// <summary>
  78. /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  79. /// 此方法的内容。
  80. /// </summary>
  81. private void InitializeComponent()
  82. {
  83. System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(ClinicCharge));
  84. this.groupBox1 = new System.Windows.Forms.GroupBox();
  85. this.label8 = new System.Windows.Forms.Label();
  86. this.label4 = new System.Windows.Forms.Label();
  87. this.btnSearch = new System.Windows.Forms.Button();
  88. this.txt1 = new System.Windows.Forms.TextBox();
  89. this.txt2 = new System.Windows.Forms.TextBox();
  90. this.label5 = new System.Windows.Forms.Label();
  91. this.txt4 = new System.Windows.Forms.TextBox();
  92. this.txt3 = new System.Windows.Forms.TextBox();
  93. this.label6 = new System.Windows.Forms.Label();
  94. this.label7 = new System.Windows.Forms.Label();
  95. this.dataGrid1 = new System.Windows.Forms.DataGrid();
  96. this.dataView1 = new System.Data.DataView();
  97. this.dataSet21 = new 医院管理系统.DataSet2();
  98. this.dataGrid2 = new System.Windows.Forms.DataGrid();
  99. this.dataView2 = new System.Data.DataView();
  100. this.txt5 = new System.Windows.Forms.TextBox();
  101. this.txt6 = new System.Windows.Forms.TextBox();
  102. this.txt7 = new System.Windows.Forms.TextBox();
  103. this.label1 = new System.Windows.Forms.Label();
  104. this.label2 = new System.Windows.Forms.Label();
  105. this.label3 = new System.Windows.Forms.Label();
  106. this.btnCash = new System.Windows.Forms.Button();
  107. this.da2 = new System.Data.SqlClient.SqlDataAdapter();
  108. this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
  109. this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();
  110. this.da1 = new System.Data.SqlClient.SqlDataAdapter();
  111. this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand();
  112. this.groupBox1.SuspendLayout();
  113. ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
  114. ((System.ComponentModel.ISupportInitialize)(this.dataView1)).BeginInit();
  115. ((System.ComponentModel.ISupportInitialize)(this.dataSet21)).BeginInit();
  116. ((System.ComponentModel.ISupportInitialize)(this.dataGrid2)).BeginInit();
  117. ((System.ComponentModel.ISupportInitialize)(this.dataView2)).BeginInit();
  118. this.SuspendLayout();
  119. // 
  120. // groupBox1
  121. // 
  122. this.groupBox1.Controls.Add(this.label8);
  123. this.groupBox1.Controls.Add(this.label4);
  124. this.groupBox1.Controls.Add(this.btnSearch);
  125. this.groupBox1.Controls.Add(this.txt1);
  126. this.groupBox1.Controls.Add(this.txt2);
  127. this.groupBox1.Controls.Add(this.label5);
  128. this.groupBox1.Controls.Add(this.txt4);
  129. this.groupBox1.Controls.Add(this.txt3);
  130. this.groupBox1.Controls.Add(this.label6);
  131. this.groupBox1.Controls.Add(this.label7);
  132. this.groupBox1.Location = new System.Drawing.Point(0, 0);
  133. this.groupBox1.Name = "groupBox1";
  134. this.groupBox1.Size = new System.Drawing.Size(712, 100);
  135. this.groupBox1.TabIndex = 0;
  136. this.groupBox1.TabStop = false;
  137. this.groupBox1.Text = "搜索";
  138. // 
  139. // label8
  140. // 
  141. this.label8.Location = new System.Drawing.Point(352, 56);
  142. this.label8.Name = "label8";
  143. this.label8.Size = new System.Drawing.Size(144, 16);
  144. this.label8.TabIndex = 3;
  145. this.label8.Text = "格式如'2004-1-1'";
  146. // 
  147. // label4
  148. // 
  149. this.label4.Location = new System.Drawing.Point(64, 37);
  150. this.label4.Name = "label4";
  151. this.label4.Size = new System.Drawing.Size(32, 16);
  152. this.label4.TabIndex = 2;
  153. this.label4.Text = "编号";
  154. // 
  155. // btnSearch
  156. // 
  157. this.btnSearch.Image = ((System.Drawing.Image)(resources.GetObject("btnSearch.Image")));
  158. this.btnSearch.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
  159. this.btnSearch.Location = new System.Drawing.Point(584, 48);
  160. this.btnSearch.Name = "btnSearch";
  161. this.btnSearch.Size = new System.Drawing.Size(104, 32);
  162. this.btnSearch.TabIndex = 1;
  163. this.btnSearch.Text = "搜索";
  164. this.btnSearch.Click += new System.EventHandler(this.btnSearch_Click);
  165. // 
  166. // txt1
  167. // 
  168. this.txt1.Location = new System.Drawing.Point(96, 32);
  169. this.txt1.Name = "txt1";
  170. this.txt1.Size = new System.Drawing.Size(144, 21);
  171. this.txt1.TabIndex = 0;
  172. this.txt1.Text = "";
  173. // 
  174. // txt2
  175. // 
  176. this.txt2.Location = new System.Drawing.Point(96, 72);
  177. this.txt2.Name = "txt2";
  178. this.txt2.Size = new System.Drawing.Size(144, 21);
  179. this.txt2.TabIndex = 0;
  180. this.txt2.Text = "";
  181. // 
  182. // label5
  183. // 
  184. this.label5.Location = new System.Drawing.Point(64, 72);
  185. this.label5.Name = "label5";
  186. this.label5.Size = new System.Drawing.Size(32, 16);
  187. this.label5.TabIndex = 2;
  188. this.label5.Text = "姓名";
  189. // 
  190. // txt4
  191. // 
  192. this.txt4.Location = new System.Drawing.Point(352, 72);
  193. this.txt4.Name = "txt4";
  194. this.txt4.Size = new System.Drawing.Size(144, 21);
  195. this.txt4.TabIndex = 0;
  196. this.txt4.Text = "";
  197. // 
  198. // txt3
  199. // 
  200. this.txt3.Location = new System.Drawing.Point(352, 32);
  201. this.txt3.Name = "txt3";
  202. this.txt3.Size = new System.Drawing.Size(144, 21);
  203. this.txt3.TabIndex = 0;
  204. this.txt3.Text = "";
  205. // 
  206. // label6
  207. // 
  208. this.label6.Location = new System.Drawing.Point(296, 36);
  209. this.label6.Name = "label6";
  210. this.label6.Size = new System.Drawing.Size(56, 16);
  211. this.label6.TabIndex = 2;
  212. this.label6.Text = "开始时间";
  213. // 
  214. // label7
  215. // 
  216. this.label7.Location = new System.Drawing.Point(296, 76);
  217. this.label7.Name = "label7";
  218. this.label7.Size = new System.Drawing.Size(56, 16);
  219. this.label7.TabIndex = 2;
  220. this.label7.Text = "结束时间";
  221. // 
  222. // dataGrid1
  223. // 
  224. this.dataGrid1.CaptionVisible = false;
  225. this.dataGrid1.DataMember = "";
  226. this.dataGrid1.DataSource = this.dataView1;
  227. this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
  228. this.dataGrid1.Location = new System.Drawing.Point(0, 104);
  229. this.dataGrid1.Name = "dataGrid1";
  230. this.dataGrid1.ReadOnly = true;
  231. this.dataGrid1.Size = new System.Drawing.Size(720, 200);
  232. this.dataGrid1.TabIndex = 1;
  233. // 
  234. // dataView1
  235. // 
  236. this.dataView1.Table = this.dataSet21.门诊划价;
  237. // 
  238. // dataSet21
  239. // 
  240. this.dataSet21.DataSetName = "DataSet2";
  241. this.dataSet21.Locale = new System.Globalization.CultureInfo("zh-CN");
  242. // 
  243. // dataGrid2
  244. // 
  245. this.dataGrid2.CaptionVisible = false;
  246. this.dataGrid2.DataMember = "";
  247. this.dataGrid2.DataSource = this.dataView2;
  248. this.dataGrid2.HeaderForeColor = System.Drawing.SystemColors.ControlText;
  249. this.dataGrid2.Location = new System.Drawing.Point(0, 304);
  250. this.dataGrid2.Name = "dataGrid2";
  251. this.dataGrid2.ReadOnly = true;
  252. this.dataGrid2.Size = new System.Drawing.Size(720, 168);
  253. this.dataGrid2.TabIndex = 2;
  254. // 
  255. // dataView2
  256. // 
  257. this.dataView2.Table = this.dataSet21.门诊划价明细;
  258. // 
  259. // txt5
  260. // 
  261. this.txt5.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataView1, "划价金额"));
  262. this.txt5.Location = new System.Drawing.Point(72, 496);
  263. this.txt5.Name = "txt5";
  264. this.txt5.ReadOnly = true;
  265. this.txt5.TabIndex = 3;
  266. this.txt5.Text = "";
  267. // 
  268. // txt6
  269. // 
  270. this.txt6.Location = new System.Drawing.Point(264, 496);
  271. this.txt6.Name = "txt6";
  272. this.txt6.TabIndex = 3;
  273. this.txt6.Text = "";
  274. this.txt6.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.txt6_KeyPress);
  275. this.txt6.TextChanged += new System.EventHandler(this.txt6_TextChanged);
  276. // 
  277. // txt7
  278. // 
  279. this.txt7.Location = new System.Drawing.Point(432, 496);
  280. this.txt7.Name = "txt7";
  281. this.txt7.ReadOnly = true;
  282. this.txt7.TabIndex = 3;
  283. this.txt7.Text = "";
  284. // 
  285. // label1
  286. // 
  287. this.label1.Location = new System.Drawing.Point(72, 480);
  288. this.label1.Name = "label1";
  289. this.label1.Size = new System.Drawing.Size(100, 16);
  290. this.label1.TabIndex = 4;
  291. this.label1.Text = "合计金额";
  292. // 
  293. // label2
  294. // 
  295. this.label2.Location = new System.Drawing.Point(264, 480);
  296. this.label2.Name = "label2";
  297. this.label2.Size = new System.Drawing.Size(100, 16);
  298. this.label2.TabIndex = 4;
  299. this.label2.Text = "收款";
  300. // 
  301. // label3
  302. // 
  303. this.label3.Location = new System.Drawing.Point(432, 480);
  304. this.label3.Name = "label3";
  305. this.label3.Size = new System.Drawing.Size(100, 16);
  306. this.label3.TabIndex = 4;
  307. this.label3.Text = "找零";
  308. // 
  309. // btnCash
  310. // 
  311. this.btnCash.Image = ((System.Drawing.Image)(resources.GetObject("btnCash.Image")));
  312. this.btnCash.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
  313. this.btnCash.Location = new System.Drawing.Point(576, 488);
  314. this.btnCash.Name = "btnCash";
  315. this.btnCash.TabIndex = 5;
  316. this.btnCash.Text = "收费";
  317. this.btnCash.Click += new System.EventHandler(this.btnCash_Click);
  318. // 
  319. // da2
  320. // 
  321. this.da2.SelectCommand = this.sqlSelectCommand1;
  322. this.da2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
  323.   new System.Data.Common.DataTableMapping("Table", "门诊划价明细", new System.Data.Common.DataColumnMapping[] {
  324. new System.Data.Common.DataColumnMapping("编号", "编号"),
  325. new System.Data.Common.DataColumnMapping("药品编号", "药品编号"),
  326. new System.Data.Common.DataColumnMapping("名称", "名称"),
  327. new System.Data.Common.DataColumnMapping("单价", "单价"),
  328. new System.Data.Common.DataColumnMapping("数量", "数量"),
  329. new System.Data.Common.DataColumnMapping("金额", "金额"),
  330. new System.Data.Common.DataColumnMapping("划价编号", "划价编号")})});
  331. // 
  332. // sqlSelectCommand1
  333. // 
  334. this.sqlSelectCommand1.CommandText = "SELECT DISTINCT a.编号, a.药品编号, b.名称, a.单价, a.数量, a.金额, a.划价编号 FROM 门诊划价明细 a INNER " +
  335. "JOIN v收费项目及药品 b ON a.药品编号 = b.编号";
  336. this.sqlSelectCommand1.Connection = this.sqlConnection1;
  337. // 
  338. // sqlConnection1
  339. // 
  340. this.sqlConnection1.ConnectionString = "workstation id=localhost;packet size=4096;integrated security=SSPI;data source="." +
  341. "";persist security info=False;initial catalog=hisbook";
  342. // 
  343. // da1
  344. // 
  345. this.da1.SelectCommand = this.sqlSelectCommand2;
  346. this.da1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
  347.   new System.Data.Common.DataTableMapping("Table", "门诊划价", new System.Data.Common.DataColumnMapping[] {
  348.   new System.Data.Common.DataColumnMapping("姓名", "姓名"),
  349.   new System.Data.Common.DataColumnMapping("性别", "性别"),
  350.   new System.Data.Common.DataColumnMapping("编号", "编号"),
  351.   new System.Data.Common.DataColumnMapping("科室", "科室"),
  352.   new System.Data.Common.DataColumnMapping("挂号编号", "挂号编号"),
  353.   new System.Data.Common.DataColumnMapping("医生", "医生"),
  354.   new System.Data.Common.DataColumnMapping("划价时间", "划价时间"),
  355.   new System.Data.Common.DataColumnMapping("划价员", "划价员"),
  356.   new System.Data.Common.DataColumnMapping("是否收费", "是否收费"),
  357.   new System.Data.Common.DataColumnMapping("收费员", "收费员"),
  358.   new System.Data.Common.DataColumnMapping("收费时间", "收费时间"),
  359.   new System.Data.Common.DataColumnMapping("划价金额", "划价金额"),
  360.   new System.Data.Common.DataColumnMapping("是否发药", "是否发药"),
  361.   new System.Data.Common.DataColumnMapping("发药时间", "发药时间"),
  362.   new System.Data.Common.DataColumnMapping("发药员", "发药员")})});
  363. // 
  364. // sqlSelectCommand2
  365. // 
  366. this.sqlSelectCommand2.CommandText = "SELECT b.姓名, b.性别, a.编号, a.科室, a.挂号编号, a.医生, a.划价时间, a.划价员, a.是否收费, a.收费员, a.收费时间" +
  367. ", a.划价金额, a.是否发药, a.发药时间, a.发药员 FROM 门诊划价 a INNER JOIN 门诊挂号 b ON a.挂号编号 = b.编号 W" +
  368. "HERE (a.是否收费 = '否')";
  369. this.sqlSelectCommand2.Connection = this.sqlConnection1;
  370. // 
  371. // ClinicCharge
  372. // 
  373. this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
  374. this.ClientSize = new System.Drawing.Size(720, 525);
  375. this.Controls.Add(this.btnCash);
  376. this.Controls.Add(this.label1);
  377. this.Controls.Add(this.txt5);
  378. this.Controls.Add(this.dataGrid2);
  379. this.Controls.Add(this.dataGrid1);
  380. this.Controls.Add(this.groupBox1);
  381. this.Controls.Add(this.txt6);
  382. this.Controls.Add(this.txt7);
  383. this.Controls.Add(this.label2);
  384. this.Controls.Add(this.label3);
  385. this.Name = "ClinicCharge";
  386. this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
  387. this.Text = "【门诊收费】";
  388. this.Load += new System.EventHandler(this.ClinicCharge_Load);
  389. this.groupBox1.ResumeLayout(false);
  390. ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
  391. ((System.ComponentModel.ISupportInitialize)(this.dataView1)).EndInit();
  392. ((System.ComponentModel.ISupportInitialize)(this.dataSet21)).EndInit();
  393. ((System.ComponentModel.ISupportInitialize)(this.dataGrid2)).EndInit();
  394. ((System.ComponentModel.ISupportInitialize)(this.dataView2)).EndInit();
  395. this.ResumeLayout(false);
  397. }
  398. #endregion
  400. //---------初始化窗体，填充数据集----------
  401. private void ClinicCharge_Load(object sender, System.EventArgs e)
  402. {
  403. //填充数据集
  404. da1.Fill(dataSet21);
  405. da2.Fill(dataSet21);
  406. //显示时，首先显示第一个划价单的明细
  407. dataView2.RowFilter="划价编号='"+dataGrid1[0,2].ToString().Trim()+"'";
  408. //明细数据根据选择的划价单编号而变化
  409. dataGrid1.CurrentCellChanged+=new EventHandler(dataGrid1_CurrentCellChanged);
  410. }
  412. //-------------显示划价单明细----------------
  413. private void dataGrid1_CurrentCellChanged(object sender, EventArgs e)
  414. {
  415. txt6.Clear();
  416. txt7.Clear();
  417. int i=dataGrid1.CurrentRowIndex;
  418.             dataView2.RowFilter="划价编号='"+dataGrid1[i,2].ToString().Trim()+"'";
  419. }
  421. //------------根据输入条件检索划价数据--------------
  422. private void btnSearch_Click(object sender, System.EventArgs e)
  423. {
  424. string filter="";
  425. if(txt1.Text.Trim()!="")
  426. {
  427. filter+="编号 like '%"+txt1.Text.Trim()+"%' AND ";
  428. }
  429. if(txt2.Text.Trim()!="")
  430. {
  431. filter+="姓名 like '%"+txt2.Text.Trim()+"%' AND ";
  432. }
  433. if(txt3.Text.Trim()!="")
  434. {
  435. filter+="划价时间>='"+txt3.Text.Trim()+"' AND ";
  436. }
  437. if(txt4.Text.Trim()!="")
  438. {
  439. filter+="划价时间<='"+txt4.Text.Trim()+"' AND ";
  440. }
  441. int length=filter.Length;
  442. if(length>0)
  443. {
  444. filter=filter.Substring(0,length-5);
  445. }
  446. dataView1.RowFilter=filter;
  447. if(dataView1.Count>0)//有确定的划价数据再显示明细
  448. {
  449. dataView2.RowFilter="划价编号='"+dataGrid1[0,2].ToString().Trim()+"'";
  450. }
  451. }
  453. //-----------根据输入金额计算找零-------------
  454. private void txt6_KeyPress(object sender, System.Windows.Forms.KeyPressEventArgs e)
  455. {
  457. //除小数点，数字和Del键之外，不相应其他键
  458. if(!(e.KeyChar=='.'||(e.KeyChar>='0'&&e.KeyChar<='9'))||e.KeyChar=='8')
  459. {
  460. e.Handled=true;
  462. }
  463. }
  465. //-----------随时计算找零金额------------
  466. private void txt6_TextChanged(object sender, System.EventArgs e)
  467. {
  468. if(txt5.Text.Trim()=="")//无合计金额不计算
  469. {
  470. return;
  471. }
  472. decimal money=0;
  473. money=Convert.ToDecimal(txt6.Text)-Convert.ToDecimal(txt5.Text);
  474. txt7.Text=money.ToString();
  475. }
  477. //------------执行收费-----------
  478. private void btnCash_Click(object sender, System.EventArgs e)
  479. {
  480. if(txt7.Text=="")//检查收款金额
  481. {
  482. MessageBox.Show("未输入收款金额","提示",MessageBoxButtons.OK,MessageBoxIcon.Stop);
  483. return;
  484. }
  485. if(Convert.ToDecimal(txt7.Text)<0)
  486. {
  487. MessageBox.Show("收款不足支付费用","提示",MessageBoxButtons.OK,MessageBoxIcon.Stop);
  488. return;
  489. }
  490. //收取款项，更新数据库
  491. string strConn="workstation id=localhost;Integrated Security=SSPI;Database=hisbook;";
  492. SqlConnection cn=new SqlConnection(strConn);
  493. cn.Open();
  494. SqlCommand cmd=cn.CreateCommand();
  495. cmd.CommandText="update 门诊划价 set 是否收费='是',收费时间='"+System.DateTime.Now.ToString()
  496. +"' where 编号='"+dataGrid1[dataGrid1.CurrentRowIndex,2].ToString().Trim()+"'";
  497. cmd.ExecuteNonQuery();
  498. dataSet21.Clear();//刷新数据集
  499. da1.Fill(dataSet21);
  500. da2.Fill(dataSet21);
  502. }
  505. }
  506. }