golddlg.cs

用c#写的房源管理软件。刚开始学C#

		private void Add_Click(object sender, System.EventArgs e)
		{
			Form1 dlg = new Form1();
			if(m_Control == false)
			{
				listView1.Items.Clear();
			}
			m_Control =true;		
			string strhezuo	 =  hezuo.Text;
			if(strhezuo	== "" || strhezuo == " ")
			{
				strhezuo = " ";
			}
			string HoursName =	HoursPos.Text;
			if(HoursName	== "" || HoursName == " ")
			{
				HoursName = " ";
			}
			string Gole = GetGold.Text;
		//	dlg.g
			if(Gole	== "" || Gole == " ")
			{
				Gole = " ";
			}
			else
			{
				bool m_bis_no = dlg.IsHaveNum(Gole);
				if(m_bis_no == false)
				{
					MessageBox.Show("写入金额请使用纯数字!");
					return ;
				}
			}
			string HosID	 =	hoursNum.Text;
			if(HosID	== "" || HosID == " ")
			{
				HosID = " ";
			}
			string time	     =	zutime.Text;
			if(time	== "" || time == " ")
			{
				time = " ";
			}
			

			string strCommand1 = "select * from 金额 where 编号 = '"+HosID+"'"; 
			// 打开数据连接 
			oleDbConnection1.Open() ;
			OleDbCommand cmd1 = new OleDbCommand ( strCommand1 , oleDbConnection1 ) ; 
			cmd1.CommandText=strCommand1;
			//获得数据集
			reader = cmd1.ExecuteReader() ;
			//获得符合条件的bool值
			bool df = reader.HasRows; 
			oleDbConnection1.Close();
			
			if(df == false)
			{
				strCommand = "INSERT INTO 金额 (编号,收取金额,合作对象,房屋名称,租售时间) VALUES ('"+HosID+"','"+Gole+"','"+strhezuo+"','"+HoursName+"','"+time+"')"; 
			}
			else
			{
				strCommand = "UPDATE 金额 SET 编号 = '"+HosID+"',合作对象 = '"+strhezuo+"',房屋名称 = '"+HoursName+"',收取金额 = '"+Gole+"',租售时间 = '"+time+"' where 编号 = '"+HosID+"'";
			}
			oleDbConnection1.Open() ; // 打开数据连接 
			OleDbCommand cmd = new OleDbCommand ( strCommand ,oleDbConnection1 ) ; 
			cmd.CommandText=strCommand;
			//reader = cmd.ExecuteReader() ;//获得数据集
			int i=cmd.ExecuteNonQuery();
			oleDbConnection1.Close();
			cmd.Dispose();

			ListViewItem li = new ListViewItem () ;
			li.SubItems.Clear() ; 
			li.SubItems[0].Text = HosID; 
			li.SubItems.Add (strhezuo) ;
			li.SubItems.Add (HoursName) ;
			li.SubItems.Add (Gole) ;
			li.SubItems.Add (time) ;
			listView1.Items.Add ( li ) ;
		}

		private void delete_Click(object sender, System.EventArgs e)
		{
			int i;
			m_Control =false;
			for(i = listView1.SelectedItems.Count - 1;i>=0;i--)
			{
				string DBnum;
				//获取当前选中的条目之一
				ListViewItem li = listView1.SelectedItems[i];
				//listView1.SelectedItems[0].SubItems[0].Text

				//删除这个条目
				listView1.Items.Remove(li);
				DBnum =li.SubItems[0].Text;
				//DBnum = listView1.SelectedItems[i].SubItems[5].Text;

				string strCommand = "delete from 金额 where 编号 = '"+DBnum+"'"; 
				oleDbConnection1.Open() ; // 打开数据连接 
				OleDbCommand cmd = new OleDbCommand ( strCommand , oleDbConnection1 ) ; 
				cmd.CommandText=strCommand;
				//		reader = cmd.ExecuteReader() ;//获得数据集
				int i1=cmd.ExecuteNonQuery();
				oleDbConnection1.Close();
			}
		}

		private void Amend_Click(object sender, System.EventArgs e)
		{
			int i = 0;
			m_Control =false;
			for(i = listView1.SelectedItems.Count - 1;i>=0;i--)
			{
				ListViewItem li = listView1.SelectedItems[0];
				//stro = li.SubItems[6].Text;
				string strHouID = hoursNum.Text;
				if(strHouID == "" || strHouID == " ")
				{
					strHouID = " ";
				}
				string strHezuo = hezuo.Text;
				if(strHezuo == "" || strHezuo == " ")
				{
					strHezuo = " ";
				}
				string strHousInfo = HoursPos.Text;
				if(strHousInfo == "" || strHousInfo == " ")
				{
					strHousInfo = " ";
				}
				string strGold = GetGold.Text;
				if(strGold == "" || strGold == " ")
				{
					strGold = " ";
				}
				string strTime = zutime.Text;
				if(strTime == "" || strTime == " ")
				{
					strTime = " ";
				}

				//--------------------------------------------------

				string strCommand = "UPDATE 金额 SET 编号 = '"+strHouID+"',合作对象 = '"+strHezuo+"',房屋名称 = '"+strHousInfo+"',收取金额 = '"+strGold+"',租售时间 = '"+strTime+"' where 编号 = '"+strHouID+"'";
				oleDbConnection1.Open() ; // 打开数据连接 
				OleDbCommand cmd = new OleDbCommand ( strCommand , oleDbConnection1 ) ; 
				cmd.CommandText=strCommand;
				//		reader = cmd.ExecuteReader() ;//获得数据集
				int i1=cmd.ExecuteNonQuery();
				oleDbConnection1.Close();
				
				hoursNum.Text = strHouID;
				hezuo.Text = strHezuo;
				HoursPos.Text = strHousInfo;
				GetGold.Text = strGold;
				zutime.Text= strTime;

				li.SubItems[0].Text = strHouID;
				li.SubItems[1].Text = strHezuo;
				li.SubItems[2].Text = strHousInfo;
				li.SubItems[3].Text = strGold;
				li.SubItems[4].Text =strTime;

				break ;
			}
			
		}

		private void findInfo_Click(object sender, System.EventArgs e)
		{
			bool m_bcontrol = false;
			string strSql = "select * from 金额 where ";
			string strliebie = findhezuo.Text;
			if(strliebie == "" || strliebie == " ")
			{
			}
			else
			{
				strSql+= "合作对象 = '"+strliebie+"'";
				m_bcontrol = true;
			}

			string strname = beginTime.Text;
			if(strname == "" || strname == " ")
			{
			}
			else
			{
				if(m_bcontrol == true)
				{
					strSql += " and 租售时间 >= '"+strname+"'";
				}
				else
				{
					strSql += " 租售时间 >= '"+strname+"'";
					m_bcontrol = true;
				}
			}
			string strdianhua = EndTime.Text;
			if(strdianhua == "" || strdianhua == " ")
			{
			}
			else
			{
				if(m_bcontrol == true)
				{
					strSql += " and 租售时间 <= '"+strdianhua+"'";
				}
				else
				{
					strSql += " 租售时间 <= '"+strdianhua+"'";
					m_bcontrol = true;
				}
			}
			if(m_bcontrol == false)
			{
				MessageBox.Show("请输入一个查询消息");
				return ;
			}
			oleDbConnection1.Open();
			OleDbCommand cmd1 = new OleDbCommand ( strSql , oleDbConnection1 ) ; 
			cmd1.CommandText=strSql;
			//获得数据集
			reader = cmd1.ExecuteReader() ;
			 
			listView1.Items.Clear();
			while (reader.Read())
			{
				ListViewItem li = new ListViewItem () ;
				li.SubItems.Clear() ; 

				li.SubItems[0].Text = reader["编号"].ToString(); 

				li.SubItems.Add (reader["合作对象"].ToString()) ; 
				li.SubItems.Add (reader["房屋名称"].ToString()) ; 
				li.SubItems.Add (reader["收取金额"].ToString()) ; 
				li.SubItems.Add (reader["租售时间"].ToString()) ; 

				listView1.Items.Add ( li ) ;
			}
			oleDbConnection1.Close();
		}


		private void ShowAll_Click(object sender, System.EventArgs e)
		{
			string strSql = "select * from 金额 ";
			m_Control =false;
			oleDbConnection1.Open();
			OleDbCommand cmd1 = new OleDbCommand ( strSql , oleDbConnection1 ) ; 
			cmd1.CommandText=strSql;
			//获得数据集
			reader = cmd1.ExecuteReader() ;
			 
			listView1.Items.Clear();
			while (reader.Read())
			{
				string strTemp;
				ListViewItem li = new ListViewItem () ;
				li.SubItems.Clear() ; 

				li.SubItems[0].Text = reader["编号"].ToString() ;

				strTemp = reader["收取金额"].ToString();
				if(strTemp == " " || strTemp == "   ")
				{
					strTemp = "";
				}
				li.SubItems.Add (strTemp) ; 
				strTemp = reader["合作对象"].ToString();
				if(strTemp == " " || strTemp == "   ")
				{
					strTemp = "";
				}
				li.SubItems.Add (strTemp) ; 
				strTemp = reader["房屋名称"].ToString();
				if(strTemp == " " || strTemp == "   ")
				{
					strTemp = "";
				}
				li.SubItems.Add (strTemp) ; 
				strTemp = reader["租售时间"].ToString();
				if(strTemp == " " || strTemp == "   ")
				{
					strTemp = "";
				}
				li.SubItems.Add (strTemp) ; 
				listView1.Items.Add ( li ) ;
			}
			oleDbConnection1.Close();
		}

		private void deleteAll_Click(object sender, System.EventArgs e)
		{
			string strCommand = "delete from 金额"; 
			m_Control =false;
			oleDbConnection1.Open() ; // 打开数据连接 
			OleDbCommand cmd = new OleDbCommand ( strCommand , oleDbConnection1 ) ; 
			cmd.CommandText=strCommand;
			//		reader = cmd.ExecuteReader() ;//获得数据集
			int i1=cmd.ExecuteNonQuery();
			oleDbConnection1.Close();
			listView1.Items.Clear();
		}

		private void listView1_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			int i = 0;
			for(i = listView1.SelectedItems.Count - 1;i>=0;i--)
			{
				string str;
				ListViewItem li = listView1.SelectedItems[0];
				
				str = li.SubItems[0].Text;
				if(str == " "|| str == null)
				{
					str = "";
				}
				hoursNum.Text = str;
				
				str = li.SubItems[1].Text;
				if(str == " "|| str == null)
				{
					str = "";
				}
				hezuo.Text =   str;

				str = li.SubItems[2].Text;
				if(str == " "|| str == null)
				{
					str = "";
				}
				HoursPos.Text =str;

				str = li.SubItems[3].Text;
				if(str == " "|| str == null)
				{
					str = "";
				}
				GetGold.Text =str;
				
				str = li.SubItems[4].Text;
				if(str == " "|| str == null)
				{
					str = "";
				}
				zutime.Text = str;
				
				break ;
			}
		}
		public void GetControlValue(string strHoursType,string ID)
		{
			HoursPos.Text = strHoursType;
			hoursNum.Text = ID;
		}
	}
}