emp.cs

asp.net 办公自动化系统 人事管理 公文管理 内部邮件管理以及办公自动化系统中不可或缺的模块

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

namespace eOA
{
	/// <summary>
	/// Emp 的摘要说明。
	/// </summary>
	public class Emp
	{
		public Emp()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}


		public DataSet GetAllEmp()
		{
			
			return SqlAccess.ExecuteDataset(SqlAccess .CONN_STRING, CommandType.StoredProcedure,"GetAllEmp");

		}  

		public void DeleteEmp(int EmpID)
		{
			SqlParameter[] para = {
									  new SqlParameter("@EmpID", EmpID)
								  };

			SqlAccess.ExecuteNonQuery(SqlAccess.CONN_STRING, CommandType.StoredProcedure, "DeleteEmp", para);
		}

		public void UpdateEmp(int EmpID,string EmpName,string LoginID,string Pwd,string Sex,string Age,string School,
			string Subject,string Address,string Tel,string QQ,string Email)
		{
			SqlParameter[] para = {
									  new SqlParameter("@EmpID", EmpID),
									  new SqlParameter("@EmpName", EmpName),
									  new SqlParameter("@LoginID", LoginID),
									  new SqlParameter("@Pwd", Pwd),
									  new SqlParameter("@Sex", Sex),
									  new SqlParameter("@Age", Age),
									  new SqlParameter("@School", School),
									  new SqlParameter("@Subject", Subject),
									  new SqlParameter("@Address", Address),
									  new SqlParameter("@Tel", Tel),
									  new SqlParameter("@QQ", QQ),
									  new SqlParameter("@Email", Email)
								  };

			SqlAccess.ExecuteNonQuery(SqlAccess.CONN_STRING, CommandType.StoredProcedure, "UpdateEmp", para);
		}

		public SqlDataReader GetEmpByID(int EmpID)
		{			
			SqlParameter[] para = {
									  new SqlParameter("@EmpID", EmpID)
								  };
			return SqlAccess.ExecuteReader(SqlAccess.CONN_STRING,CommandType.StoredProcedure, "GetEmpByID", para);
		}


		public void SetEmpAdmin(int EmpID)
		{
			SqlParameter[] para = {
									  new SqlParameter("@EmpID", EmpID)		
								  };

			SqlAccess.ExecuteNonQuery(SqlAccess.CONN_STRING, CommandType.StoredProcedure, "SetEmpAdmin", para);
		}

		public void SetEmpNormal(int EmpID)
		{
			SqlParameter[] para = {
									  new SqlParameter("@EmpID", EmpID)		
								  };

			SqlAccess.ExecuteNonQuery(SqlAccess.CONN_STRING, CommandType.StoredProcedure, "SetEmpNormal", para);
		}

		public void AddEmp(string EmpName,string LoginID,string Pwd,string Sex,string Age,string School,
			string Subject,string Address,string Tel,string QQ,string Email,string Role)
		{
			SqlParameter[] para = {
									  new SqlParameter("@EmpName", EmpName),
									  new SqlParameter("@LoginID", LoginID),
									  new SqlParameter("@Pwd", Pwd),
									  new SqlParameter("@Sex", Sex),
									  new SqlParameter("@Age", Age),
									  new SqlParameter("@School", School),
									  new SqlParameter("@Subject", Subject),
									  new SqlParameter("@Address", Address),
									  new SqlParameter("@Tel", Tel),
									  new SqlParameter("@QQ", QQ),
									  new SqlParameter("@Email", Email),
									  new SqlParameter("@Role", Role)
								  };

			SqlAccess.ExecuteNonQuery(SqlAccess.CONN_STRING, CommandType.StoredProcedure, "AddEmp", para);
		}
	}
}