LogDB.cs
上传用户:autodoor
上传日期:2022-08-04
资源大小:9973k
文件大小:3k
- 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();
- }
- }
- }