jz_yw_zl.cs

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

			int lc_sysl=0;
			this.dim_dysj=new int[lc_rowcount];
			//dim_dysj[0]=0;
			int lc_jsq=0;
			string lc_zt="0";
			string lc_bzbz="";
			this.listBox1.Items.Clear();
			foreach (DataRowView tmp_DR in lc_view)
			{
				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 button_start_Click(object sender, System.EventArgs e)
		{
			//执行确认功能
			lc_seleid=0;
			if (this.listBox1.Items.Count>0)
			{
				lc_seleid=this.dim_dysj[this.listBox1.SelectedIndex];
				lc_view1=new DataView(lc_ylxm,"流水号="+lc_seleid.ToString().Trim(),"收费日期",DataViewRowState.CurrentRows);
				int lc_sysl=0;
				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());
	
				}
				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.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");
					}

				}
				//MessageBox.Show(this.dim_dysj[lc_seleid].ToString());
			}
		
			

		}
		private void excute_rec(int lsh,int zxsl,string gh,string zt)
		{
			//执行选中的记录，发送数据至数据库
			//MessageBox.Show(lsh.ToString()+zxsl.ToString()+gh.ToString());

			//System.Data.SqlClient.SqlCommand lc_sqlcmd=new SqlCommand();
			SqlDataAdapter sql_da=new SqlDataAdapter();
			SqlCommandBuilder sql_cb=new SqlCommandBuilder();
			DataTable ret_sp=new DataTable();
			int lc_ret=0;
			//int lc_cmd_ok=0;
			//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();
			//DataRow[] Edit_Row;
			if (ret_sp.Rows.Count==1)
			{
				lc_ret=int.Parse(ret_sp.Rows[0]["数据返回"].ToString());
				if (lc_ret==-1)
				{
					MessageBox.Show("Sp执行错误！");
				}
				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();
					
				}  
			}


//			string sp_name="pda_rec_zl";
//			lc_sqlcmd.Connection=this.JZYW_Sql_conn_str;
//			lc_sqlcmd.CommandType=CommandType.StoredProcedure;
//			lc_sqlcmd.CommandText=sp_name.ToString();
//			lc_sqlcmd.Parameters.Add("lsh",lsh);
//			lc_sqlcmd.Parameters.Add("zxsl",zxsl);
//			lc_sqlcmd.Parameters.Add("gh",gh);
//			lc_sqlcmd.Parameters.Add("zh",lc_zh);
//			lc_sqlcmd.Parameters.Add("cfh",lc_cfh);
//			lc_sqlcmd.Parameters.Add("zt",zt);
//			SqlParameter paramResult = new SqlParameter("@databack", SqlDbType.Int ); 
//			paramResult.Direction = ParameterDirection.Output; 
//			lc_sqlcmd.Parameters.Add(paramResult); 

//			this.JZYW_Sql_conn_str.Open();
//			lc_sqlcmd.ExecuteNonQuery();
//			this.JZYW_Sql_conn_str.Close();
			
				//lc_ret=(int)lc_cmd_ok.Parameters["@lc_ret"].value;
//				lc_ret=int.Parse(paramResult.Value.ToString());
//				MessageBox.Show(lc_ret.ToString());
//				this.JZYW_Sql_conn_str.Close();
	


		}

		private void button1_Click(object sender, System.EventArgs e)
		{
			string lczt="";
			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);
			this.label_zxsl.Text="1";
		}

		private void button2_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 button8_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 button7_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 button3_Click(object sender, System.EventArgs e)
		{
			
			this.label_zxsl.Text=this.label_yysl.Text.ToString().Trim();
		}

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

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