login.cs

网上购物中介

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

namespace _3DLib
{
	/// <summary>
	/// Login 的摘要说明。
	/// </summary>
	public class Login
	{
		public Login()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		public static int getLoginFlag(string uid,string pwd)
		{
			int i=0;
			OleDbConnection con=DataBaseCon.GetCon();
			System.Data.OleDb.OleDbCommand cmd=new System.Data.OleDb.OleDbCommand();
			cmd.Connection=con;
			con.Open();
			cmd.CommandText="select * from admin where uid='"+uid+"' and pwd='"+pwd+"'";
			OleDbDataReader odr;
			odr=cmd.ExecuteReader();
			if(odr.Read())
			{
               string state=odr.GetString(2);
				if(state.Equals("0"))
				{
					i=3;
				}
				else if(state.Equals("1"))
				{
					i=1;
				}
				else i=2;
			}
			con.Close();
			return i;
		}
	}
}