logdb.cs

专业的办公oa代码下载 c#语言编写 三层结构

using System;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
using qminoa.Common.Data;

namespace qminoa.DA
{
	/// <summary>
	/// LogDB 的摘要说明。
	/// </summary>
	public class LogDB
	{
		public LogDB()
		{

		}
		public void WriteOperationLog(LogData mylogdata)
		{
			SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
			SqlCommand myCommand = new SqlCommand("sysAddOptLog", myConnection);

			myCommand.CommandType = CommandType.StoredProcedure;

			SqlParameter parameterOperatorID = new SqlParameter("@OperatorID", SqlDbType.VarChar, 10);
			parameterOperatorID.Value = mylogdata.OperatorID;
			myCommand.Parameters.Add(parameterOperatorID);

			SqlParameter parameterOperatorName = new SqlParameter("@OperatorName", SqlDbType.VarChar, 50);
			parameterOperatorName.Value = mylogdata.OperatorName;
			myCommand.Parameters.Add(parameterOperatorName);

			SqlParameter parameterOperateTime = new SqlParameter("@OperateTime", SqlDbType.VarChar, 50);
			parameterOperateTime.Value = mylogdata.OperateTime;
			myCommand.Parameters.Add(parameterOperateTime);

			SqlParameter parameterFuncName = new SqlParameter("@FuncName", SqlDbType.VarChar, 50);
			parameterFuncName.Value = mylogdata.FuncName;
			myCommand.Parameters.Add(parameterFuncName);

			SqlParameter parameterOperationDescription = new SqlParameter("@OperationDescription", SqlDbType.VarChar, 50);
			parameterOperationDescription.Value = mylogdata.OperationDescription;
			myCommand.Parameters.Add(parameterOperationDescription);

			myConnection.Open();
			myCommand.ExecuteNonQuery();
			myConnection.Close();
		}
		public DataTable ReadOperationLog()
		{
			SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
			SqlCommand myCommand = new SqlCommand("sysReadOptLog", myConnection);

			myCommand.CommandType = CommandType.StoredProcedure;
			DataSet myds=new DataSet ();
			SqlDataAdapter myda =new SqlDataAdapter ();
			myda.SelectCommand =myCommand;

			myConnection .Open ();
			myda.Fill (myds,"GetLogInfo");
			myConnection.Close();

			return myds.Tables ["GetLogInfo"];

		}
		public void DelOptLog(int pkid)
		{
			SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
			SqlCommand myCommand = new SqlCommand("sysDelOptLog", myConnection);

			myCommand.CommandType = CommandType.StoredProcedure;

			SqlParameter parameterPkID = new SqlParameter("@pkid", SqlDbType.Int);
			parameterPkID.Value = pkid;
			myCommand.Parameters.Add(parameterPkID);

			myConnection.Open();
			myCommand.ExecuteNonQuery();
			myConnection.Close();
		}
	}
}