jz_sy_zl.cs

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

//				lc_lx=tmp_DR["类型"].ToString().Trim();
//			
//				if (lc_sfrq==zl_sfrq)
//				{
//					if (lc_zh==0 &lc_zt=="0")
//					{
//						if (lc_lx==this.fil_lx || lc_lx=="材料")
//						{
//							lc_nr1=tmp_DR["名称"].ToString();
//							str_len=24-lc_nr1.Length;
//							if (str_len<0)
//								str_len=1;
//							lcnr=lc_nr1.PadRight(str_len,' ')+tmp_DR["剩余数量"].ToString()+tmp_DR["单位"].ToString();		
//							this.listBox1.Items.Add(lcnr);
//							this.dim_dysj[lc_jsq]=(int) tmp_DR["流水号"];
//							lc_jsq+=1;
//						}
//					}
//				}
				lc_zt=tmp_DR["状态"].ToString().Trim();
				lc_zh=(int) tmp_DR["组号"];
				lc_sfrq=(DateTime) tmp_DR["收费日期"];
				lcnr="";
				lc_lx=tmp_DR["类型"].ToString().Trim();
				lc_sysl=int.Parse ( tmp_DR["剩余数量"].ToString().Trim());
				if (lc_sysl==0)
					lc_bzbz="＊";
				else
					lc_bzbz="";

				if (lc_sfrq==zl_sfrq)
				{
					if (lc_zh==0 )
					{
						if (lc_lx==this.fil_lx || lc_lx=="材料")
						{
							
							lc_nr1=CLS_PDA.LStrB(tmp_DR["名称"].ToString().Trim(),14,true);
							str_len=24-lc_nr1.Length;
							if (str_len<0)
								str_len=1;
							lcnr=lc_bzbz.ToString()+lc_nr1.ToString()+"原:"+tmp_DR["数量"].ToString().Trim()+"  "+"剩:"+tmp_DR["剩余数量"].ToString()+tmp_DR["单位"].ToString();		
							this.listBox1.Items.Add(lcnr);
							this.dim_dysj[lc_jsq]=(int) tmp_DR["流水号"];
							lc_jsq+=1;
						}
					}
				}
			}
		}
	
		private void syinfo_refresh( int t1_index)
		{
			//显示需要进行的输液及注射明细药物
			lc_row_total=this.sy_dt.Tables[0].Rows.Count;
			if (lc_row_total>1)
			{
				if (t1_index==0)
				{    
                    this.button8.Visible=true;
					this.button7.Visible=false;
				}
				else
				{
					
					
					if (t1_index==(lc_row_total-1))
					{
						this.button8.Visible=false;
						this.button7.Visible=true;
					}
					else
					{
						this.button7.Visible=true;
						this.button8.Visible=true;
					}
				}

			}
			else
			{
				this.button7.Visible=false;
				this.button8.Visible=false;
			}
			string lc_title_text="";
			string lc_zsff_text="";
			lc_cfh=0;
			int lc_sysl=0;
            //this.listBox2.Items.Clear();
			//this.label_nr.Text="";
			this.textBox_ypxx.Text="";
			if (lc_row_total>0 & lc_row_total>=t1_index)
			{
			  lc_sysl=(int) this.sy_dt.Tables[0].Rows[t1_index]["剩余次数"];
			  lc_title_text=this.sy_dt.Tables[0].Rows[t1_index]["开方日期"].ToString().Trim()+",剩余:"+
							this.sy_dt.Tables[0].Rows[t1_index]["剩余次数"].ToString().Trim()+"次,"+
							this.sy_dt.Tables[0].Rows[t1_index]["途径"].ToString().Trim();
			  //this.label_title.Text=lc_title_text;
				this.button_syqr.Text=lc_title_text;
			  lc_cfh=(int) this.sy_dt.Tables[0].Rows[t1_index]["处方编号"];
				cfh_sy=(int) this.sy_dt.Tables[0].Rows[t1_index]["处方编号"];
			  lc_zsff_text=this.sy_dt.Tables[0].Rows[t1_index]["途径"].ToString().Trim();
			  this.label1.Text=lc_zsff_text;
				//this.button_syqr.Text=lc_zsff_text;
			  this.sy_mx=new DataView(this.sy_dt.Tables[1],"处方编号="+lc_cfh.ToString().Trim(),"处方序号",DataViewRowState.CurrentRows);

				string lc_nr="";
				string lc_mc="";
				foreach (DataRowView tmp_DR in sy_mx)
				{
					lc_mc=CLS_PDA.LStrB(tmp_DR["名称"].ToString().Trim(),20,true);
					lc_nr=lc_mc.ToString()+"   "+"   "+tmp_DR["剂量"].ToString();
					this.textBox_ypxx.Text=this.textBox_ypxx.Text.ToString().Trim()+"\r\n"+lc_nr.ToString();
				}
				if (lc_sysl<1)
				{
					this.textBox_ypxx.ForeColor=Color.Red; 
				}
				else
				{
					this.textBox_ypxx.ForeColor=Color.Black; 
				}
			  
			}
		}

		private void excute_rec(int lsh,int zxsl,string gh,string zt,string rec_lx)
		{
		

			//执行选中的记录，发送数据至数据库
		
			SqlDataAdapter sql_da=new SqlDataAdapter();
			SqlCommandBuilder sql_cb=new SqlCommandBuilder();
			DataTable ret_sp=new DataTable();
			int lc_ret=0;
			string lc_sql_cmd="exec pda_rec_zl "+lsh.ToString().Trim()+
				","+zxsl.ToString().Trim()+",'"+gh.ToString().Trim()+"',"+
				lc_zh.ToString().Trim()+","+lc_cfh.ToString().Trim()+",'"+zt.ToString().Trim()+"'" ;
			

			this.JZYW_Sql_conn_str.Open();
			sql_da =new SqlDataAdapter(lc_sql_cmd, JZYW_Sql_conn_str);
			sql_cb =new SqlCommandBuilder( sql_da );
			sql_da.Fill(ret_sp);	
			this.JZYW_Sql_conn_str.Close();
			if (ret_sp.Rows.Count==1)
			{
				lc_ret=int.Parse(ret_sp.Rows[0]["数据返回"].ToString());
				if (lc_ret==-1)
				{
					MessageBox.Show("Sp执行错误！111");
				}
				if (lc_ret==0)
				{
					MessageBox.Show("数据没有更新！");
				}
				if (lc_ret>0)
				{
					//判断执行成功后对数据源表进行更新

					//MessageBox.Show("数据更新成功！");
					
					//	lc_ylxm
					int lc_lsh=0;
					int lc_sysl_old=0;
					int lc_sysl_new=0;
					if (zt=="2")
					{
					
						foreach (DataRow tmp_DR in this.lc_ylxm.Rows)
						{
							lc_lsh=(int)tmp_DR["流水号"];

							if (lc_lsh==lsh)
							{
								//MessageBox.Show(tmp_DR["流水号"].ToString());
								//MessageBox.Show(tmp_DR["流水号"].ToString());
								tmp_DR.BeginEdit();
								tmp_DR["状态"]=zt;
								tmp_DR.EndEdit();
							}

						}
					}
						
					
					else
					{
						foreach (DataRow tmp_DR in this.lc_ylxm.Rows)
						{
							lc_lsh=(int)tmp_DR["流水号"];

							if (lc_lsh==lsh)
							{
								lc_sysl_old=int.Parse(tmp_DR["剩余数量"].ToString());
								lc_sysl_new=lc_sysl_old-zxsl;
								tmp_DR.BeginEdit();
								tmp_DR["剩余数量"]=lc_sysl_new;
								tmp_DR.EndEdit();
							}

						}
					}
					
					this.mF_Form.updt_ds_rwjl(lsh,zt,lc_sysl_new);
					this.form_refresh();
					


					
				}  
			}

		}

		private void exec_syxx (int zxsl,string gh)
		{
//			if (rec_lx==fil_lx)
//			{
			int lc_ret=0;
			SqlDataAdapter sql_da=new SqlDataAdapter();
			SqlCommandBuilder sql_cb=new SqlCommandBuilder();
			DataTable ret_sp=new DataTable();
			this.button_syqr.Text="";
				this.JZYW_Sql_conn_str.Open();
				//	MessageBox.Show(lc_cfh.ToString()+" "+zxsl.ToString().Trim());
			string lc_sql_cmd="exec pda_rec_sy "+cfh_sy.ToString().Trim()+","+zxsl.ToString().Trim();
				sql_da =new SqlDataAdapter(lc_sql_cmd, JZYW_Sql_conn_str);
				sql_cb =new SqlCommandBuilder( sql_da );
				sql_da.Fill(ret_sp);	
				this.JZYW_Sql_conn_str.Close();
				if (ret_sp.Rows.Count==1)
				{
					lc_ret=int.Parse(ret_sp.Rows[0]["返回值"].ToString());
					if (lc_ret==-1)
					{
						MessageBox.Show("Sp执行错误！112");
					}
					if (lc_ret==0)
					{
						MessageBox.Show("数据没有更新！");
					}
					if (lc_ret==1)
					{
						this.get_syxx();
					}
//				}
			}
		}
		private void button_back_Click(object sender, System.EventArgs e)
		{
			this.mF_Form.Show();
			this.Close();
		}

		private void button7_Click(object sender, System.EventArgs e)
		{
			if (this.lc_sy_index>0)
				this.lc_sy_index-=1;
			else
				this.lc_sy_index=0;
			this.syinfo_refresh(lc_sy_index) ;
		}

		private void button8_Click(object sender, System.EventArgs e)
		{
			if (this.lc_sy_index<lc_row_total)
				this.lc_sy_index+=1;
			else
				this.lc_sy_index=lc_row_total;
			this.syinfo_refresh(lc_sy_index) ;
		}

		private void button_start_Click(object sender, System.EventArgs e)
		{
			//执行确认功能
			lc_seleid=0;
			if (this.listBox1.Items.Count>0 )
			{
				//this.listBox1.
				lc_seleid=this.dim_dysj[this.listBox1.SelectedIndex];
				lc_view1=new DataView(lc_ylxm,"流水号="+lc_seleid.ToString().Trim(),"收费日期",DataViewRowState.CurrentRows);
				int lc_sysl=0;
				string lc_exec_lx="";
				foreach (DataRowView tmp_DR in lc_view1)
				{
				
					lc_sysl=int.Parse (tmp_DR["剩余数量"].ToString().Trim());
					lc_zh=(int) tmp_DR["组号"];
					lc_cfh=int.Parse( tmp_DR["处方编号"].ToString());
					lc_exec_lx=tmp_DR["类型"].ToString().Trim();
	
				}
				lc_ok_exec="OK";
		
				if (lc_ok_exec=="OK")
				{
					if (lc_sysl>1)
					{
						//调用数量显示界面
						this.listBox1.Enabled=false;
						this.button_start.Enabled=false;
						this.button_back.Enabled=false;
						this.panel1.Left=0;
						this.panel1.Top=24;
						this.label4.Text=lc_exec_lx.ToString().Trim();

						this.panel1.Visible=true;
						this.label_yysl.Text=lc_sysl.ToString().Trim();
				
					}
					else
					{
						if (lc_sysl<1)
						{
							MessageBox.Show("医疗项目已经执行完毕！");
						}
						else
						{
							//直接调用sp进行记录确认
							this.excute_rec(lc_seleid,1,this.log_name.ToString(),"2",lc_exec_lx);
						}
					}
				}
			}
		}
		private void button6_Click(object sender, System.EventArgs e)
		{
			string lczt="";
			string lc_exec_lx=this.label4.Text.ToString().Trim();
			int  lc_yysl=int.Parse(this.label_yysl.Text.ToString().Trim());
			int  lc_zxsl=int.Parse(this.label_zxsl.Text.ToString().Trim());
			if (lc_zxsl==lc_yysl)
				lczt="2";
			else
				lczt="0";
			this.listBox1.Enabled=true;
			this.button_start.Enabled=true;
			this.button_back.Enabled=true;
			this.panel1.Visible=false;
			this.excute_rec(this.lc_seleid,lc_zxsl,this.log_name.ToString(),lczt,lc_exec_lx);
			this.label_zxsl.Text="1";
		}

		private void button5_Click(object sender, System.EventArgs e)
		{
			this.listBox1.Enabled=true;
			this.button_start.Enabled=true;
			this.button_back.Enabled=true;
			this.panel1.Visible=false;
			this.label_zxsl.Text="1";
		}

		private void button9_Click(object sender, System.EventArgs e)
		{
			lc_ok_exec="OK";
			this.panel2.Visible=false;
			this.button_start.Enabled=true;
			this.button_back.Enabled=true;
		}

		private void button10_Click(object sender, System.EventArgs e)
		{
			lc_ok_exec="NO";
			this.panel2.Visible=false;
			this.button_start.Enabled=true;
			this.button_back.Enabled=true;
		}

		private void button1_Click(object sender, System.EventArgs e)
		{
			int lc_sl=int.Parse(this.label_zxsl.Text.ToString().Trim());
			int lc_yysl=int.Parse(this.label_yysl.Text.ToString().Trim());
			if (lc_sl<lc_yysl)
			{
				lc_sl+=1;
			}
			this.label_zxsl.Text=lc_sl.ToString().Trim();
		}

		private void button2_Click(object sender, System.EventArgs e)
		{
			int lc_sl=int.Parse(this.label_zxsl.Text.ToString().Trim());
			if (lc_sl>1)
				lc_sl-=1;
			this.label_zxsl.Text=lc_sl.ToString().Trim();
		}

		private void button4_Click(object sender, System.EventArgs e)
		{
			this.label_zxsl.Text="1";
		}

		private void button3_Click(object sender, System.EventArgs e)
		{
			this.label_zxsl.Text=this.label_yysl.Text.ToString().Trim();
		}

		private void listBox1_SelectedIndexChanged(object sender, System.EventArgs e)
		{
		this.button_start.Visible=true;
		}

		private void button_syqr_Click(object sender, System.EventArgs e)
		{
			string lc_rgb="0";
			lc_rgb=this.textBox_ypxx.ForeColor.R.ToString().Trim();
			if (lc_rgb=="0")
			{
				this.exec_syxx(1,this.log_name);
			}
			else
			{
				MessageBox.Show("已经执行过！");
			}
		}

	}
}