selectall.cs

网上购物中介

using System;
using System.Data;
using System.Data.OleDb;

namespace _3DLib
{
	/// <summary>
	/// selectAll 的摘要说明。
	/// </summary>
	public class SelectAll
	{
		public SelectAll()
		{
			
		}
		public static System.Data.DataTable getAllInfo(int flag)
		{
			string table=null;
			OleDbConnection con=DataBaseCon.GetCon();
			System.Data.OleDb.OleDbCommand cmd=new System.Data.OleDb.OleDbCommand();
			cmd.Connection=con;
			con.Open();
			if(flag==1)
			   table="会员";
			else if(flag==0)table="会员日志";
			else if(flag==2)table="展出商品";
			else if(flag==3)table="出售商品";
			else if(flag==4)table="提供商";
			else if(flag==5)table="news";
			else if(flag==6)table="tips";
            string query="select * from "+table;
			cmd.CommandText=query;
			//cmd.ExecuteReader();
			System.Data.OleDb.OleDbDataAdapter da=new System.Data.OleDb.OleDbDataAdapter();
			DataSet ds1=new DataSet();
			da.SelectCommand=cmd;
			da.Fill(ds1,"table1");
			con.Close();
			return ds1.Tables[0];
		}
		public static System.Data.DataTable getOneInfo(string table,string text,string tj)
		{
			OleDbConnection con=DataBaseCon.GetCon();
			System.Data.OleDb.OleDbCommand cmd=new System.Data.OleDb.OleDbCommand();
			cmd.Connection=con;
			string query=null;
//			if(tj.Equals("用户名"))
//			{
//				query="用户名='"+text+"'";
//			}
//			else if(tj.Equals("姓名"))
//			{
//				query="姓名='"+text+"'";
//			}
//			else if(tj.Equals("职业"))
//			{
//				query="职业='"+text+"'";
//			}
			query="select * from "+table+" where "+tj+"='"+text+"'";
            cmd.CommandText=query;
			con.Open();
			System.Data.OleDb.OleDbDataAdapter da=new System.Data.OleDb.OleDbDataAdapter();
			DataSet ds=new DataSet();
			da.SelectCommand=cmd;
			da.Fill(ds,"table2");
			con.Close();
			return ds.Tables[0];
		}

	}
}