readerform.cs

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

//					Form2.frm2.isShow=true;
//				}
//				else
//				{
//					Form2.frm2.isShow=false;
//				}
//				Form2.frm2.Show();
//				sn2=textBox1.Text;
//				Form2.frm2.sn=textBox1.Text;
//				//lastcode=textBox1.Text;
//				textBox1.Text="";
				//Form2.frm2.textBox1.Text=Form2.frm2.sn;


				if (true)
				{
					//if (exec_save(textBox1.Text.ToString().Trim(),gonghao.Text.ToString().Trim(),label_name.Text.ToString().Trim()))
					if (this.confirm_start!=null)
					{
						textBox1.Text="";
						this.confirm_start.textIn(textBox1.Text.Trim());
						this.confirm_start.Show();
						this.Hide();
					}
					else
					{
					
						//MessageBox.Show("该记录保存成功","成功");
						textBox1.Text="";
						this.confirm_start=new confirm(this);
						this.confirm_start.textIn(textBox1.Text.ToString().Trim());
						this.confirm_start.Show();
						//this.confirm_start.Capture="success";
						this.Hide();
					}
					
				}
				else
				{
					MessageBox.Show("请核对所输入的条码："+textBox1.Text.ToString().Trim());
				}
//执行过程				
//				this.exec_check_mz(textBox1.Text.ToString().Trim());
				

				//frm1.Hide();

			}
		}

		private Boolean exec_save(string barcode,string id,string name)
		{
			string str="";
			string hislist="";
			Boolean flag=false;
			hislist=DateTime.Now.ToString("yyyy-MM-dd").Trim();
			str=barcode+"*"+id+"*"+"化验"+"*"+DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");

			if (chkCode(barcode))
			{
				try
				{
					if (File.Exists(fname)) 
					{
						StreamWriter sw = File.AppendText(fname);
						sw.WriteLine (str);
						sw.Close();
						flag=true;
					}
					else
					{
						StreamWriter sw = File.CreateText(fname);
						sw.WriteLine (str);
						sw.Close();
						flag=true;
					}
					if (File.Exists(hislist)) 
					{
						StreamWriter sw2 = File.AppendText(hislist);
						sw2.WriteLine (str);
						sw2.Close();
						flag=true;
					}
					else
					{
						StreamWriter sw2 = File.CreateText(hislist);
						sw2.WriteLine (str);
						sw2.Close();
						flag=true;
					}
					if (flag)
					{
						return true;
					}
					else
					{
						return false;
					}
				}
				catch
				{
					return false;
				}
			}
			else
			{
				MessageBox.Show("该条码"+barcode+"已在"+scanTime+"扫描过");
				return false;
			}
		}
		private Boolean chkCode(string code)
		{
			StreamReader chkLine=File.OpenText(fname);
			string line;
			string[] sArray;
			while ((line=chkLine.ReadLine()) != null) 
			{
				sArray=line.Split('*');
				if (sArray[0].ToString()==code)
				{
					scanTime=Convert.ToDateTime(sArray[3]);
					chkLine.Close();
					return false;
				}
			}
			scanTime=Convert.ToDateTime("1900-01-01");
			chkLine.Close();
			return true;

		}
		private void exec_check_mz(string mzh)
		{
			//按照传入的门诊号到数据库执行操作
			//this.textBox1.Text="";
			try
			{	
				data_test=new DataTable();
				data_ybkh=new DataTable();
				sql_cmd=new SqlCommand();
				sql_cmd.Connection=sql_conn;
				//string lc_mzh=this.textBox_ch.Text.ToString().Trim();

				//判断是否是医保卡号
				string lc_mzh=mzh.ToString().Trim();
				int yb_flag=0;
				if (lc_mzh.Length>=10 || lc_mzh.Length==9)
				{
					
					string yb_sql_cmd="exec FGHISDB.dbo.MZ_GetMZH '"+lc_mzh+"'";
					sql_conn.Open();
					sql_da =new SqlDataAdapter(yb_sql_cmd, sql_conn );
					sql_cb =new SqlCommandBuilder( sql_da );
					sql_da.Fill(data_ybkh);	
					sql_conn.Close();
					int yb_rowcount=data_ybkh.Rows.Count;
					if (yb_rowcount==0)
					{
						MessageBox.Show("医保号有误！！");
						yb_flag=1;
					}
					else
					{
						string tmp_mzh=this.data_ybkh.Rows[0][0].ToString().Trim();
						//MessageBox.Show(tmp_mzh);
						lc_mzh=tmp_mzh;
					
					}



				}

				if (yb_flag==0)
				{
					string lc_name="";
					string lc_sex="";
					string lc_age="";
					string lc_jzdm="";
					string lc_sqlcmd="";
					int lcret=0;
			
					//	string lc_sql_cmd="select * from 治疗_任务记录 where 门诊编号='"+lc_cwh+"' and 状态='0'";
					string lc_sql_cmd="select 姓名,性别,出生日期,记帐代码 from  FGMZDB..门诊_病人基本信息 where 门诊号='"+lc_mzh+"'";
					sql_conn.Open();
					sql_da =new SqlDataAdapter(lc_sql_cmd, sql_conn );
					sql_cb =new SqlCommandBuilder( sql_da );
					sql_da.Fill(data_test);	
					sql_conn.Close();
					//this.dataGrid1.DataSource=data_test;
					int lc_rowcount=data_test.Rows.Count;
					if (lc_rowcount==0)
					{
						MessageBox.Show("门诊号有误！！");
					}
					else
					{
											
						//		lc_mzh=this.data_test.Rows[0]["门诊号"].ToString().Trim();
						lc_sqlcmd="exec pda_check_mzfph  '"+lc_mzh+"','"+this.log_name.ToString().Trim()+"'";
						this.sql_conn.Open();
						//MessageBox.Show(up_cmd.ToString());
				
						sql_cmd.CommandText=lc_sqlcmd.ToString();
						lcret=sql_cmd.ExecuteNonQuery();
						this.sql_conn.Close();
						//MessageBox.Show(lcret.ToString());
						lc_name=this.data_test.Rows[0]["姓名"].ToString().Trim();
						lc_sex=this.data_test.Rows[0]["性别"].ToString().Trim();
						if (lc_sex=="1")
							lc_sex="男";
						else
							lc_sex="女";
						lc_age="生日:"+this.data_test.Rows[0]["出生日期"].ToString().Trim();

						lc_jzdm=this.data_test.Rows[0]["记帐代码"].ToString().Trim();
												
						//MessageBox.Show(lc_mzh.ToString()+"  "+lc_name.ToString());
						//调用SY_HSXC界面
						lc_jzhsxc=new JZ_HSXC(this);
						lc_jzhsxc.br_jbxx=lc_name+","+lc_sex+","+lc_age;
						lc_jzhsxc.mzh=lc_mzh;
						lc_jzhsxc.Sql_string=this.Sql_string.ToString();
						lc_jzhsxc.Sql_conn_str=this.sql_conn;
						lc_jzhsxc.log_name=this.log_name;
											    
						//												lc_syhscx.cf_no="18247";
						//												lc_syhscx.br_jbxx=lc_mzh+","+lc_name;
						//												lc_syhscx.mzh=lc_mzh.ToString().Trim();
						//												lc_syhscx.ch=lc_cwh.ToString().Trim();
						//												lc_syhscx.Sql_conn_str=this.sql_conn;
						lc_jzhsxc.Show();
						this.Hide();
											
											
						//MessageBox.Show(lc_mzh.ToString()+"数据读写错误----001!!!"+lcret.ToString());
											
					}
				}
										
										
				//sql_conn.Close();
			}
			catch (SqlException ex) 
			{
				MessageBox.Show( "Error connecting to the server: " + ex.Message );
			}

		}

		private void timer1_Tick(object sender, System.EventArgs e)
		{
			label1.Text=DateTime.Now.ToString("yyyy年MM月dd日HH点mm分ss秒");
		}

		private void n1_Click(object sender, System.EventArgs e)
		{
			textBox1.Text=textBox1.Text+"1";
		}

		private void n2_Click(object sender, System.EventArgs e)
		{
			textBox1.Text=textBox1.Text+"2";
		}

		private void n3_Click(object sender, System.EventArgs e)
		{
			textBox1.Text=textBox1.Text+"3";
		}

		private void n4_Click(object sender, System.EventArgs e)
		{
			textBox1.Text=textBox1.Text+"4";
		}

		private void n5_Click(object sender, System.EventArgs e)
		{
			textBox1.Text=textBox1.Text+"5";
		}

		private void n6_Click(object sender, System.EventArgs e)
		{
			textBox1.Text=textBox1.Text+"6";
		}

		private void n7_Click(object sender, System.EventArgs e)
		{
			textBox1.Text=textBox1.Text+"7";
		}

		private void n8_Click(object sender, System.EventArgs e)
		{
			textBox1.Text=textBox1.Text+"8";
		}

		private void n9_Click(object sender, System.EventArgs e)
		{
			textBox1.Text=textBox1.Text+"9";
		}

		private void n0_Click(object sender, System.EventArgs e)
		{
			textBox1.Text=textBox1.Text+"0";
		}

		private void nClear_Click(object sender, System.EventArgs e)
		{
			textBox1.Text="";
		}

		private void nBackSpace_Click(object sender, System.EventArgs e)
		{
			textBox1.Text=textBox1.Text.Substring(0,textBox1.Text.Length-1);
		}

		private void label5_ParentChanged(object sender, System.EventArgs e)
		{
		
		}

		private void comboBox1_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			textBox1.Text=textBox1.Text+comboBox1.SelectedItem.ToString();
		}

		private void button2_Click(object sender, System.EventArgs e)
		{
			this.frm_start=new dataSync(this);
			this.frm_start.Show();
			this.Hide();
			
//			connSql="data source=172.16.80.25;user id=sa;initial catalog=;password=";
//			try 
//			{
//				sql_conn = new SqlConnection( connSql );
//				sql_cmd=new SqlCommand();
//				sql_cmd.Connection=sql_conn;
//				string lc_sql_cmd="select * from syncData";
//				sql_conn.Open();
//				sql_da =new SqlDataAdapter(lc_sql_cmd, sql_conn );
//				sql_cb =new SqlCommandBuilder( sql_da );
//				data_uid=new DataTable();
//				sql_da.Fill(data_uid);
//				sql_conn.Close();
//			}
//			catch (SqlException ex) 
//			{
//				//MessageBox.Show( "Error connecting to the server: " + ex.Message );
//				//MessageBox.Show("网络故障，连接中断，请重起程序。");
//				//MessageBox.Show(this.connSql.ToString());
//			}
		}

		
	}
}