operate.cs

学生考勤管理系统学生考勤管理系统学生考勤管理系统学生考勤管理系统学生考勤管理系统

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

namespace kqxt
{
	/// <summary>
	/// Operate 的摘要说明。
	/// </summary>
	public class Operate
	{
		public Operate()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		public static bool Addclass(person p)
		{
			try
			{
				SqlConnection con=DB.createcon();
				con.Open();
				SqlCommand cmd=new SqlCommand("addclass",con);
				cmd.CommandType=CommandType.StoredProcedure;
				SqlParameter para=new SqlParameter("@classID",SqlDbType.VarChar,20);
				para.Value=p.classID;
				cmd.Parameters.Add(para);
				para=new SqlParameter("@thID",SqlDbType.VarChar,20);
				para.Value=p.thID;
				cmd.Parameters.Add(para);
//				para=new SqlParameter("@DepID",SqlDbType.VarChar,20);
//				para.Value=p.DepID;
//				cmd.Parameters.Add(para);
				cmd.ExecuteNonQuery();
				con.Close();
				return true;
			}
			catch (Exception e)
			{
				return false;
			}

		}
		public static bool Addteacher(person p)
		{
			try
			{
				SqlConnection con=DB.createcon();
				con.Open();
				SqlCommand cmd=new SqlCommand("addteacher",con);
				cmd.CommandType=CommandType.StoredProcedure;
				SqlParameter para=new SqlParameter("@thID",SqlDbType.VarChar,20);
				para.Value=p.thID;
				cmd.Parameters.Add(para);
				para=new SqlParameter("@thName",SqlDbType.VarChar,20);
				para.Value=p.thName;
				cmd.Parameters.Add(para);
				para=new SqlParameter("@courseName",SqlDbType.VarChar,20);
				para.Value=p.courseName;
				cmd.Parameters.Add(para);
				cmd.ExecuteNonQuery();
				con.Close();
				return true;
			}
			catch (Exception e)
			{
				return false;
			}

		}
		public static bool Addstudent(person p)
		{
			try
			{
				SqlConnection con=DB.createcon();
				con.Open();
				SqlCommand cmd=new SqlCommand("addstudent",con);
				cmd.CommandType=CommandType.StoredProcedure;
				SqlParameter para=new SqlParameter("@stuID",SqlDbType.VarChar,20);
				para.Value=p.stuID;
				cmd.Parameters.Add(para);
				para=new SqlParameter("@stuName",SqlDbType.VarChar,20);
				para.Value=p.stuName;
				cmd.Parameters.Add(para);
				para=new SqlParameter("@classID",SqlDbType.VarChar,20);
				para.Value=p.classID;
				cmd.Parameters.Add(para);
				cmd.ExecuteNonQuery();
				con.Close();
				return true;
			}
			catch (Exception e)
			{
				return false;
			}

		}
		public static bool Addusers(person p)
		{
			try
			{
				SqlConnection con=DB.createcon();
				con.Open();
				SqlCommand cmd=new SqlCommand("addusers",con);
				cmd.CommandType=CommandType.StoredProcedure;
				SqlParameter para=new SqlParameter("@usersID",SqlDbType.VarChar,20);
				para.Value=p.usersID;
				cmd.Parameters.Add(para);
				para=new SqlParameter("@usersPwd",SqlDbType.VarChar,20);
				para.Value=p.usersPwd;
				cmd.Parameters.Add(para);
				para=new SqlParameter("@powers",SqlDbType.VarChar,20);
				para.Value=p.powers;
				cmd.Parameters.Add(para);
				cmd.ExecuteNonQuery();
				con.Close();
				return true;
			}
			catch (Exception e)
			{
				return false;
			}

		}

		public static bool Addcourse(person p)
		{
			try
			{
				SqlConnection con=DB.createcon();
				con.Open();
				SqlCommand cmd=new SqlCommand("addcourse",con);
				cmd.CommandType=CommandType.StoredProcedure;
				SqlParameter para=new SqlParameter("@courseID",SqlDbType.VarChar,20);
				para.Value=p.courseID;
				cmd.Parameters.Add(para);
				para=new SqlParameter("@courseName",SqlDbType.VarChar,20);
				para.Value=p.courseName;
				cmd.Parameters.Add(para);
				cmd.ExecuteNonQuery();
				con.Close();
				return true;
			}
			catch (Exception e)
			{
				return false;
			}
		}
		public static bool Addclasscourse(person p)
		{
			try
			{
				SqlConnection con=DB.createcon();
				con.Open();
				SqlCommand cmd=new SqlCommand("addclasscourse",con);
				cmd.CommandType=CommandType.StoredProcedure;
				SqlParameter para=new SqlParameter("@classID",SqlDbType.VarChar,20);
				para.Value=p.classID;
				cmd.Parameters.Add(para);
				para=new SqlParameter("@courseID",SqlDbType.VarChar,20);
				para.Value=p.courseID;
				para=new SqlParameter("@thID",SqlDbType.VarChar,20);
				para.Value=p.thID;
				cmd.Parameters.Add(para);
				cmd.ExecuteNonQuery();
				con.Close();
				return true;
			}
			catch (Exception e)
			{
				return false;
			}

		}


		public static DataTable selectAll()
		{
			SqlConnection con=DB.createcon();
			con.Open();
			SqlDataAdapter sdr=new SqlDataAdapter();
			sdr.SelectCommand=new SqlCommand("select * from class",con);
			DataSet ds=new DataSet();
			sdr.Fill(ds,"class");
			return ds.Tables["class"];
		}
		public static DataTable selectAll1()
		{
			SqlConnection con=DB.createcon();
			con.Open();
			SqlDataAdapter sdr=new SqlDataAdapter();
			sdr.SelectCommand=new SqlCommand("select * from classCourse",con);
			DataSet ds=new DataSet();
			sdr.Fill(ds,"classCourse");
			return ds.Tables["classCourse"];
		}
		public static DataTable selectteacher()
		{
			SqlConnection con=DB.createcon();
			con.Open();
			SqlDataAdapter sdr=new SqlDataAdapter();
			sdr.SelectCommand=new SqlCommand("select * from teacher",con);
			DataSet ds=new DataSet();
			sdr.Fill(ds,"teacher");
			return ds.Tables["teacher"];
		}
		public static DataTable selectstudent()
		{
			SqlConnection con=DB.createcon();
			con.Open();
			SqlDataAdapter sdr=new SqlDataAdapter();
			sdr.SelectCommand=new SqlCommand("select * from student",con);
			DataSet ds=new DataSet();
			sdr.Fill(ds,"student");
			return ds.Tables["student"];
		}
		public static DataTable selectusers()
		{
			SqlConnection con=DB.createcon();
			con.Open();
			SqlDataAdapter sdr=new SqlDataAdapter();
			sdr.SelectCommand=new SqlCommand("select * from users",con);
			DataSet ds=new DataSet();
			sdr.Fill(ds,"users");
			return ds.Tables["users"];
		}
		public static DataTable selectcourse()
		{
			SqlConnection con=DB.createcon();
			con.Open();
			SqlDataAdapter sdr=new SqlDataAdapter();
			sdr.SelectCommand=new SqlCommand("select * from course",con);
			DataSet ds=new DataSet();
			sdr.Fill(ds,"course");
			return ds.Tables["course"];
		}
		public static DataTable selectclasscourse()
		{
			SqlConnection con=DB.createcon();
			con.Open();
			SqlDataAdapter sdr=new SqlDataAdapter();
			sdr.SelectCommand=new SqlCommand("select * from classcourse",con);
			DataSet ds=new DataSet();
			sdr.Fill(ds,"classcourse");
			return ds.Tables["classcourse"];
		}
	}
}