jz_hsxc.cs

windows mobile 2005 上可以运行的资产管理系统

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data ;

namespace PDA_test
{
	/// <summary>
	/// JZ_HSXC 的摘要说明。
	/// </summary>
	public class JZ_HSXC : System.Windows.Forms.Form
	{
		private System.Windows.Forms.Button button_back;
		private System.Windows.Forms.TextBox textBox_brjbxx;
		public string br_jbxx;//病人基本信息
		public string mzh;
		public System.Data.SqlClient.SqlConnection Sql_conn_str;
		private System.Windows.Forms.Button button1;
		private System.Windows.Forms.Button button2;
		private System.Windows.Forms.Button button3;
		private System.Windows.Forms.Button button4;
		private System.Windows.Forms.Button button5;
		private System.Windows.Forms.Button button6;
		public System.Data.DataSet ds_rwjl;
		private System.Data.SqlClient.SqlDataAdapter sql_da;
		private System.Data.SqlClient.SqlCommandBuilder sql_cb;
		private System.Data.SqlClient.SqlCommand sql_cmd;
		private System.Windows.Forms.Button button7;
		private System.Windows.Forms.Button button8;
		private System.Windows.Forms.Label label1;
		private string[] dim_cfh ;
		private string[] dim_lx;
		private int[] dim_zh;
		private int lc_rqnum;
		private PDA_test.JZ_YW_ZL frm_zl;
		private DateTime lc_fprq;
		private PDA_test.JZ_SY_ZL frm_sy;
		public string Sql_string;
		public string log_name;
		private PDA_test.ReaderForm mF_Form;
		

		public JZ_HSXC(ReaderForm myform)
		{
			//
			// Windows 窗体设计器支持所必需的
			//
			InitializeComponent();
			this.mF_Form  = myform ;
			//
			// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
			//
		}

		/// <summary>
		/// 清理所有正在使用的资源。
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			base.Dispose( disposing );
		}

		#region Windows 窗体设计器生成的代码
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			this.button_back = new System.Windows.Forms.Button();
			this.textBox_brjbxx = new System.Windows.Forms.TextBox();
			this.button1 = new System.Windows.Forms.Button();
			this.button2 = new System.Windows.Forms.Button();
			this.button3 = new System.Windows.Forms.Button();
			this.button4 = new System.Windows.Forms.Button();
			this.button5 = new System.Windows.Forms.Button();
			this.button6 = new System.Windows.Forms.Button();
			this.button7 = new System.Windows.Forms.Button();
			this.button8 = new System.Windows.Forms.Button();
			this.label1 = new System.Windows.Forms.Label();
			// 
			// button_back
			// 
			this.button_back.Font = new System.Drawing.Font("宋体", 12F, System.Drawing.FontStyle.Regular);
			this.button_back.Location = new System.Drawing.Point(44, 256);
			this.button_back.Size = new System.Drawing.Size(148, 32);
			this.button_back.Text = "返回";
			this.button_back.Click += new System.EventHandler(this.button_back_Click);
			// 
			// textBox_brjbxx
			// 
			this.textBox_brjbxx.Font = new System.Drawing.Font("宋体", 12F, System.Drawing.FontStyle.Regular);
			this.textBox_brjbxx.Location = new System.Drawing.Point(4, 0);
			this.textBox_brjbxx.Size = new System.Drawing.Size(228, 26);
			this.textBox_brjbxx.Text = "";
			// 
			// button1
			// 
			this.button1.Font = new System.Drawing.Font("楷体_GB2312", 14.25F, System.Drawing.FontStyle.Bold);
			this.button1.Location = new System.Drawing.Point(16, 60);
			this.button1.Size = new System.Drawing.Size(204, 32);
			this.button1.Text = "button1";
			this.button1.Visible = false;
			this.button1.Click += new System.EventHandler(this.button1_Click);
			// 
			// button2
			// 
			this.button2.Font = new System.Drawing.Font("楷体_GB2312", 14.25F, System.Drawing.FontStyle.Bold);
			this.button2.Location = new System.Drawing.Point(16, 92);
			this.button2.Size = new System.Drawing.Size(204, 32);
			this.button2.Text = "button2";
			this.button2.Visible = false;
			this.button2.Click += new System.EventHandler(this.button2_Click);
			// 
			// button3
			// 
			this.button3.Font = new System.Drawing.Font("楷体_GB2312", 14.25F, System.Drawing.FontStyle.Bold);
			this.button3.Location = new System.Drawing.Point(16, 124);
			this.button3.Size = new System.Drawing.Size(204, 32);
			this.button3.Text = "button3";
			this.button3.Visible = false;
			this.button3.Click += new System.EventHandler(this.button3_Click);
			// 
			// button4
			// 
			this.button4.Font = new System.Drawing.Font("楷体_GB2312", 14.25F, System.Drawing.FontStyle.Bold);
			this.button4.Location = new System.Drawing.Point(16, 156);
			this.button4.Size = new System.Drawing.Size(204, 32);
			this.button4.Text = "button4";
			this.button4.Visible = false;
			this.button4.Click += new System.EventHandler(this.button4_Click);
			// 
			// button5
			// 
			this.button5.Font = new System.Drawing.Font("楷体_GB2312", 14.25F, System.Drawing.FontStyle.Bold);
			this.button5.Location = new System.Drawing.Point(16, 188);
			this.button5.Size = new System.Drawing.Size(204, 32);
			this.button5.Text = "button5";
			this.button5.Visible = false;
			this.button5.Click += new System.EventHandler(this.button5_Click);
			// 
			// button6
			// 
			this.button6.Font = new System.Drawing.Font("楷体_GB2312", 14.25F, System.Drawing.FontStyle.Bold);
			this.button6.Location = new System.Drawing.Point(16, 220);
			this.button6.Size = new System.Drawing.Size(204, 32);
			this.button6.Text = "button6";
			this.button6.Visible = false;
			this.button6.Click += new System.EventHandler(this.button6_Click);
			// 
			// button7
			// 
			this.button7.Location = new System.Drawing.Point(16, 32);
			this.button7.Size = new System.Drawing.Size(32, 20);
			this.button7.Text = "<";
			this.button7.Visible = false;
			this.button7.Click += new System.EventHandler(this.button7_Click);
			// 
			// button8
			// 
			this.button8.Location = new System.Drawing.Point(188, 32);
			this.button8.Size = new System.Drawing.Size(32, 20);
			this.button8.Text = ">";
			this.button8.Visible = false;
			this.button8.Click += new System.EventHandler(this.button8_Click);
			// 
			// label1
			// 
			this.label1.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Regular);
			this.label1.Location = new System.Drawing.Point(48, 32);
			this.label1.Size = new System.Drawing.Size(140, 20);
			this.label1.Text = "无医嘱信息";
			this.label1.TextAlign = System.Drawing.ContentAlignment.TopCenter;
			// 
			// JZ_HSXC
			// 
			this.ClientSize = new System.Drawing.Size(240, 263);
			this.Controls.Add(this.label1);
			this.Controls.Add(this.button8);
			this.Controls.Add(this.button7);
			this.Controls.Add(this.button6);
			this.Controls.Add(this.button5);
			this.Controls.Add(this.button4);
			this.Controls.Add(this.button3);
			this.Controls.Add(this.button2);
			this.Controls.Add(this.button1);
			this.Controls.Add(this.button_back);
			this.Controls.Add(this.textBox_brjbxx);
			this.Text = "急诊巡查";
			this.Load += new System.EventHandler(this.JZ_HSXC_Load);

		}
		#endregion

		private void JZ_HSXC_Load(object sender, System.EventArgs e)
		{
			dim_cfh= new string[6];
			dim_lx=new string[6];
			dim_zh=new int[6];
			this.button1.Visible=false;
			this.button2.Visible=false;
			this.button3.Visible=false;
			this.button4.Visible=false;
			this.button5.Visible=false;
			this.button6.Visible=false;
			//this.button7.Visible=false;
			ds_rwjl=new DataSet() ;
			this.textBox_brjbxx.Text=br_jbxx.ToString().Trim();
			//	MessageBox.Show(DateTime.Now.ToShortDateString());
			string lc_sql_cmd="exec pda_info_check '"+mzh.ToString()+"'";
			//,'"+DateTime.Now.ToShortDateString()+"' ";
			 
			
			//string sql_conn=this.Sql_conn_str.ConnectionString.ToString().Trim()+";password=1";
			
			this.Sql_conn_str=new SqlConnection(Sql_string);
			this.Sql_conn_str.Open();
			sql_da =new SqlDataAdapter(lc_sql_cmd, Sql_conn_str);
			sql_cb =new SqlCommandBuilder( sql_da );
			sql_da.Fill(ds_rwjl);	
			this.Sql_conn_str.Close();
			this.show_items(0);
			this.lc_rqnum=0;	
			
		
			
		}

		public void updt_ds_rwjl(int lsh,string zt,int sysl)
		{
			//对数据表3-(详细数据)进行数据更新
			int lc_tblsh=0;
			foreach (DataRow tmp_DR in this.ds_rwjl.Tables[2].Rows)
			{
				lc_tblsh=(int) tmp_DR["流水号"];
				if (lc_tblsh==lsh)
				{
					tmp_DR.BeginEdit();
					tmp_DR["状态"]=zt.ToString().Trim();
					tmp_DR["剩余数量"]=(int) sysl;
					tmp_DR.EndEdit();
				}
			}
		}

		private void excute_frm(string exec_type,string fil_con )
		{
				
			string lc_lx_sy="";
			string lc_sy_cmd="";
			string lc_name_sy="aaa";
			string lc_age_sy="35";
			string lc_gh=this.log_name.ToString().Trim();
			int lc_ret_sy=0;
			DataTable lc_sy_table=new DataTable();

			switch (exec_type)
			{
				case "治疗":
					//MessageBox.Show(fil_con.ToString());

					this.frm_zl=new JZ_YW_ZL(this);
					this.frm_zl.lc_ylxm=this.ds_rwjl.Tables[2];
					this.frm_zl.zl_sfrq=lc_fprq;
					this.frm_zl.fil_con=fil_con.ToString().Trim();
					this.frm_zl.br_jbxx=br_jbxx.ToString().Trim();
					this.frm_zl.fil_lx=exec_type.ToString().Trim();
					this.frm_zl.JZYW_Sql_conn_str=this.Sql_conn_str;
					this.frm_zl.tilte_string=exec_type.ToString().Trim();
					this.frm_zl.Sql_string=this.Sql_string.ToString();
					this.frm_zl.log_name=this.log_name.ToString();
					this.frm_zl.Show();
					this.Hide();
					


					break;
				case "材料":
					//MessageBox.Show(fil_con.ToString());

					this.frm_zl=new JZ_YW_ZL(this);
					this.frm_zl.lc_ylxm=this.ds_rwjl.Tables[2];
					this.frm_zl.zl_sfrq=lc_fprq;
					this.frm_zl.fil_con=fil_con.ToString().Trim();
					this.frm_zl.br_jbxx=br_jbxx.ToString().Trim();
					this.frm_zl.fil_lx=exec_type.ToString().Trim();
					this.frm_zl.JZYW_Sql_conn_str=this.Sql_conn_str;
					this.frm_zl.tilte_string=exec_type.ToString().Trim();
					this.frm_zl.Sql_string=this.Sql_string.ToString();
					this.frm_zl.log_name=this.log_name.ToString();
					this.frm_zl.Show();
					this.Hide();
					break;

				case "手术":
					//MessageBox.Show(fil_con.ToString());

					this.frm_zl=new JZ_YW_ZL(this);
					this.frm_zl.lc_ylxm=this.ds_rwjl.Tables[2];
					this.frm_zl.zl_sfrq=lc_fprq;
					this.frm_zl.fil_con=fil_con.ToString().Trim();
					this.frm_zl.br_jbxx=br_jbxx.ToString().Trim();
					this.frm_zl.fil_lx=exec_type.ToString().Trim();
					this.frm_zl.JZYW_Sql_conn_str=this.Sql_conn_str;
					this.frm_zl.tilte_string=exec_type.ToString().Trim();
					this.frm_zl.Sql_string=this.Sql_string.ToString();
					this.frm_zl.log_name=this.log_name.ToString();
					this.frm_zl.Show();
					this.Hide();
					break;

				case "检查":
					//MessageBox.Show(fil_con.ToString());

					this.frm_zl=new JZ_YW_ZL(this);
					this.frm_zl.lc_ylxm=this.ds_rwjl.Tables[2];
					this.frm_zl.zl_sfrq=lc_fprq;
					this.frm_zl.fil_con=fil_con.ToString().Trim();
					this.frm_zl.br_jbxx=br_jbxx.ToString().Trim();
					this.frm_zl.fil_lx=exec_type.ToString().Trim();
					this.frm_zl.JZYW_Sql_conn_str=this.Sql_conn_str;