class1.cs

本程序只要配置好IIS就可以直接使用,是一个在线网上考试系统

using System;
using System.Data;

namespace ECClass
{
	public class T_AppManger
	{
		DataSet ds=new DataSet();
		string strsql;
		DBClass.DataClass db=new DBClass.DataClass();
		public DataSet showalldata(string tablename)
		{
			strsql="select * from "+ tablename;
			ds=db.SelectData(strsql);
			return ds;
		}
		public DataSet shiti()
		{
			strsql="select top 20 * from Subject order by newid()";
			ds=db.SelectData(strsql);
			return ds;
		}
		
	}
	public abstract class T_Core
	{
		public string strsql;
		public DataSet dss=new DataSet();
		public DBClass.DataClass dbb=new DBClass.DataClass();
		public bool bo;
	}

	public class Users: T_Core
	{
		public bool db_insert(string name,string pwd,string sex,string cardtype,string cardid,string tel,string address,string email)
		{
			strsql="exec procId '"+ name +"','"+ pwd +"','"+ sex +"','"+ cardtype +"','"+ cardid +"','"+ tel +"','"+ address +"','"+ email +"'";
			bo=dbb.updateData(strsql);
			return bo;
		}
		public bool db_update(string pwd,string sex,string cardtype,string cardid,string tel,string address,string email,string iftest,string name)
		{
			strsql="update Users set U_pwd='"+ pwd +"',U_sex='"+ sex +"',U_cardtype='"+ cardtype +"',U_cardId='"+ cardid +"',U_tel='"+ tel +"',U_address='"+ address +"',U_email='"+ email +"',U_iftest='"+ iftest +"' where U_Name='"+ name +"'";
			bo=dbb.updateData(strsql);
			return bo;
		}
		public bool db_delete(string name)
		{
			strsql="delete from Users where U_Name='"+ name +"'";
			bo=dbb.updateData(strsql);
			return bo;
		}
		public DataSet db_select(string name)
		{
			strsql="select * from Users where U_Name='"+ name +"'";
			dss=dbb.SelectData(strsql);
			return dss;
		}
	}
	public class Manager: T_Core
	{
		public bool db_insert(string name,string truename,string sex,string pwd,string address,string tel,string email)
		{
			strsql="insert into Manager (M_Name,M_Truename,M_Sex,M_Pwd,M_Address,M_Tel,M_Email) values ('"+ name +"','"+ truename +"','"+ sex +"','"+ pwd +"','"+ address +"','"+ tel +"','"+ email +"')";
			bo=dbb.updateData(strsql);
			return bo;
		}
		public bool db_update(string truename,string sex,string pwd,string address,string tel,string email,string name)
		{
			strsql="update Manager set M_Truename='"+ truename +"',M_Sex='"+ sex +"',M_Pwd='"+ pwd +"',M_Address='"+ address +"',M_Tel='"+ tel +"',M_Email='"+ email +"' where M_Name='"+ name +"'";
			bo=dbb.updateData(strsql);
			return bo;
		}
		public bool db_delete(string name)
		{
			strsql="delete from Manager where M_Name='"+ name +"'";
			bo=dbb.updateData(strsql);
			return bo;
		}
		public DataSet db_select(string name)
		{
			strsql="select * from Manager where M_Name='"+ name +"'";
			dss=dbb.SelectData(strsql);
			return dss;
		}
	}
	public class News: T_Core
	{
		public bool db_insert(string m_name,string title,string infor)
		{
			strsql="insert into News (N_M_name,N_title,N_infor) values ('"+ m_name +"','"+ title +"','"+ infor +"')";
			bo=dbb.updateData(strsql);
			return bo;
		}
		public bool db_update(string m_name,string title,string infor,string id)
		{
			strsql="update News set N_M_name='"+ m_name +"',N_title='"+ title +"',N_infor='"+ infor +"' where N_id='"+ id +"'";
			bo=dbb.updateData(strsql);
			return bo;
		}
		public bool db_delete(string id)
		{
			strsql="delete from News where N_id='"+ id +"'";
			bo=dbb.updateData(strsql);
			return bo;
		}
		public DataSet db_select(string id)
		{
			strsql="select * from News where N_id='"+ id +"'";
			dss=dbb.SelectData(strsql);
			return dss;
		}
	}
	public class Subject: T_Core
	{
		public bool db_insert(string question,string text1,string text2,string text3,string text4,string answer)
		{
			strsql="insert into Subject (S_question,S_text1,S_text2,S_text3,S_text4,S_answer) values ('"+ question +"','"+ text1 +"','"+ text2 +"','"+ text3 +"','"+ text4 +"','"+ answer +"')";
			bo=dbb.updateData(strsql);
			return bo;
		}
		public bool db_update(string question,string text1,string text2,string text3,string text4,string answer,string id)
		{
			strsql="update Subject set S_question='"+ question +"',S_text1='"+ text1 +"',S_text2='"+ text2 +"',S_text3='"+ text3 +"',S_text4='"+ text4 +"',S_answer='"+ answer +"' where S_Id='"+ id +"'";
			bo=dbb.updateData(strsql);
			return bo;
		}
		public bool db_delete(string id)
		{
			strsql="delete from Subject where S_ID='"+ id +"'";
			bo=dbb.updateData(strsql);
			return bo;
		}
		public DataSet db_select(string id)
		{
			strsql="select * from Subject where S_ID='"+ id +"'";
			dss=dbb.SelectData(strsql);
			return dss;
		}
	}
	public class Test: T_Core
	{
		public bool db_insert(string U_name,string score,string date)
		{
			strsql="insert into Test (T_U_name,T_score,T_date) values ('"+ U_name +"','"+ score +"','"+ date +"')";
			bo=dbb.updateData(strsql);
			return bo;
		}
//		public bool db_update(string U_Id,string score,string date)
//		{
//			strsql="update Test set T_U_Id='',T_score='',T_date='' where ";
//			bo=dbb.updateData(strsql);
//			return bo;
//		}
		public bool db_delete(string Id)
		{
			strsql="delete from Test where T_Id='"+ Id +"'";
			bo=dbb.updateData(strsql);
			return bo;
		}
		public DataSet db_select(string Name)
		{
			strsql="select * from Test where T_U_name='"+ Name +"'";
			dss=dbb.SelectData(strsql);
			return dss;
		}
	}
}