message.cs

办公室系统包括上下班打卡

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using GUCAS.SC.SqlHelper;

public class Message
{
	public DataSet GetMessageByEmployee(int employeeID)
	{
		///定义保存从数据库获取的结果的DataSet
		DataSet ds = new DataSet();

		///添加存储过程的参数
		SqlParameter[] parameters = {
			SqlHelper.CreateInParam("@EmployeeID",SqlDbType.Int,4,employeeID)
		};

		///执行存储过程
		SqlHelper.RunProc("Pr_GetMessageByEmployee",parameters,ref ds);
		
		///返回从数据库获取的结果
		return ds;
	}

	public DataSet GetMessageByEmployee(int employeeID,byte status)
	{
		///定义保存从数据库获取的结果的DataSet
		DataSet ds = new DataSet();

		///添加存储过程的参数
		SqlParameter[] parameters = {
			SqlHelper.CreateInParam("@EmployeeID",SqlDbType.Int,4,employeeID),
			SqlHelper.CreateInParam("@Status",SqlDbType.TinyInt,1,status)
		};

		///执行存储过程
		SqlHelper.RunProc("Pr_GetMessageByEmployeeAndStatus",parameters,ref ds);

		///返回从数据库获取的结果
		return ds;
	}


	public SqlDataReader GetSingleMessage(int messageID)
	{
		return (DataCommon.GetDataByReaderIDParam("Pr_GetSingleMessage",messageID));
	}

	public int AddMessage(string name,string desn,int sender,
		int reciever)
	{
		SqlParameter[] parameters = {
			SqlHelper.CreateInParam("@Name",SqlDbType.VarChar,100,name),
			SqlHelper.CreateInParam("@Desn",SqlDbType.NVarChar,1000,desn),
			SqlHelper.CreateInParam("@Sender",SqlDbType.Int,4,sender),
			SqlHelper.CreateInParam("@Reciever",SqlDbType.Int,4,reciever)
		};
		return (SqlHelper.RunProc("Pr_AddMessage",parameters));
	}

	public int UpdateMessageStatus(int messageID,byte status)
	{
		SqlParameter[] parameters = {
			SqlHelper.CreateInParam("@ID",SqlDbType.Int,4,messageID),
			SqlHelper.CreateInParam("@Status",SqlDbType.TinyInt,1,status)
		};
		return (SqlHelper.RunProc("Pr_UpdateMessageStatus",parameters));
	}

	public int DeleteMessage(int messageID)
	{
		return (DataCommon.QueryDataIDParam("Pr_DeleteMessage",messageID));
	}
}