user.cs

本论文叙述了联机考试系统的现状以及C#语言的概况。重点介绍了联机考试系统的实现过程：包括系统分析、 系统调查、 数据流程分析、功能设计、 数据库设计、 系统物理配置方案、 系统实现、 系统测试和调试。

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


namespace OES
{
	/// <summary>
	/// Summary description for User.
	/// </summary>
	public class User
	{
		public User()
		{
			
		}
		public string ValidateUser(string usrid, string passwd)
		{
			string utype="USER_NOT_EXISTS";
			//modify by dong ping 2004-12-25
			//string str="select * from tbl_user where usrId like '"+ usrid +"' and Passwd = '" + passwd +" '";
			string str="select * from tbl_user where usrId= '"+ usrid +"' and Passwd = '" + passwd +" '"; 

			//DataAccess.GetInstance();modify by dong ping 2004-12-25
			
			
			DataAccess.command.CommandText=str;
			OleDbDataReader reader=DataAccess.command.ExecuteReader();
			
			if(reader.Read())
			{
				bool status = (bool)reader.GetValue(3);
				if(! status)
					utype = "USER_ACCOUNT_INACTIVE";
				else
					utype = reader.GetValue(4).ToString();
				
			}
			reader.Close();
				return utype;
		}


		public void InsertRecords(DataRow drUser)
		{
		
			//DataAccess.GetInstance();modify by dong ping 2004-12-25
			DataAccess.sql="Insert into tbl_User values('"+drUser["usrId"]+"','"+
				drUser["usrName"]+"','"+
				drUser["passwd"]+"',"+
				drUser["usrStatus"]+",'"+
				drUser["usrType"]+"',"+
				drUser["gender"]+",'"+
				drUser["address"]+"','"+
				drUser["emailid"]+"','"+
				drUser["phone"]+"');";
		
			//Console.WriteLine(DataAccess.sql);
			DataAccess.command.CommandText=DataAccess.sql;
			DataAccess.command.ExecuteNonQuery ();
			
		}
		public void UpdateRecords(DataTable dtUser)
		{

			try
			{ 	
				//for every row in the dataset that was sent 
				//as a parameter, perform an update 
				//into the table	
				foreach(DataRow drUser in dtUser.Rows)
				{
					//write the sql statement for that row
					DataAccess.sql="Update tbl_User Set	usrname='"
						+drUser["usrname"]+"'," 
						+"Passwd = '"
						+drUser["passwd"] +"', UsrStatus = "
						+drUser["usrStatus"]+", UsrType = '"
						+drUser["usrType"]  +"', Gender = "
						+drUser["gender"]+", Address = '"
						+drUser["address"] +"', EmailId = '"
						+drUser["emailid"]+"', Phone = '" 
						+drUser["phone"]+"' where UsrId = '"+drUser["usrid"]+"';";                       
			
					DataAccess.command.CommandText = DataAccess.sql;
					DataAccess.command.ExecuteNonQuery ();
					Console.WriteLine("Updated");
				}
			}
			catch(OleDbException excep)
			{
				Console.WriteLine ("Exception occured: "+excep.Message);   
			}
		}

		//return the fetched data in the form of a table back to 
		//the calling form

		public DataTable FetchRecords(string[] searchValue)
		{
		
			string str="";
	        str="select * from tbl_user";
			
			Console.WriteLine (searchValue[0]);
            Console.WriteLine (searchValue[1]);
			Console.WriteLine (searchValue[2]);
			Console.WriteLine (searchValue[3]);
			if(searchValue[0] != "") //username is not null
			{
				 str = str+" where usrName like '"+searchValue[0]+ "'";
				if(searchValue[1] != "") // Usertype is not null
				{
					str += " and Usrtype = '"+searchValue[1]+"'";
					str += " and usrStatus = "+Convert.ToBoolean(searchValue[2]);
				}
				else if(searchValue[2] != "")
					str += " and usrStatus = "+Convert.ToBoolean(searchValue[2]);
			}
			else 
			{
				if(searchValue[1] != "")
				{
					str="select * from tbl_user where Usrtype = '"+searchValue[1]+ "'";
					if (searchValue[2] != "ALL_USER_BY_TYPE")
						str += " and usrStatus = "+Convert.ToBoolean(searchValue[2]);	
						
				}
				else if(searchValue[1] != "") //////??????					
				{
					str += " Select * from tbl_user where usrStatus = "+Convert.ToBoolean(searchValue[2]);

				}

				if(searchValue[3] !="")
				{
					Console.WriteLine (str);
					str+=" where UsrId='"+searchValue[3]+"';";
				}
				Console.WriteLine (str);
			}

			DataAccess.oleAdapter=new OleDbDataAdapter(str,DataAccess.oleconn);
			DataAccess.dSet = new DataSet("User");
			DataAccess.oleAdapter.Fill(DataAccess.dSet,"User");
			Console.WriteLine(DataAccess.dSet.Tables[0].Rows.Count.ToString());
			return DataAccess.dSet.Tables[0]; 
		}


	}
}