syslog.cs

某个公司需要维持良好的客户关系

using System;
using System.Collections;
using System.Data;
using System.Data.SqlClient;
using CRM.IDAL;
using CRM.Model;

namespace CRM.SQLServerDAL
{
	/// <summary>
	/// SysLog 的摘要说明。
	/// </summary>
	public class SysLog : ISysLog
	{
		#region ISysLog 成员

		public DataTable GetSysLogByUserId(string userId)
		{
			return DAI.RunProcTable("CRM_SysLog_GetSysLogByUserId",userId);
		}

		public DataTable GetAllSysLog()
		{
			return DAI.RunProcTable("CRM_SysLog_GetAllSysLog");
		}

		public void Insert(SysLogInfo log)
		{
			object[] parms = {
								Common.GetNextIdByTable("SysLog","LogId","SingleLayer",null,10),
								log.UserId,
								log.FuncId,
								log.OptState,
								log.HostName,
								log.HostIP,
								log.BZ
							 };
			DAI.RunProcNonQuery("CRM_SysLog_Insert",parms);
		}

		public DataTable GetSysLogByFuncId(string funcid)
		{
			return DAI.RunProcTable("CRM_SysLog_GetSysLogByFuncId",funcid);
		}

		public SysLogInfo GetSysLogById(string logId)
		{
			SysLogInfo log = null;
			using (SqlDataReader rdr = DAI.RunProcReader("CRM_SysLog_GetSysLogById",logId))
			{
				if (rdr.Read())
				{
					log = new SysLogInfo();

					log.LogId = rdr["LogId"].ToString();
					log.UserId = rdr["UserId"].ToString();
					log.OptTime = rdr["OptTime"].ToString();
					log.FuncId = rdr["FuncId"].ToString();
					log.OptState = rdr["OptState"].ToString();
					log.HostName = rdr["HostName"].ToString();
					log.HostIP = rdr["HostIP"].ToString();
					log.BZ = rdr["BZ"].ToString();
				}
			}
			return log;
		}

		public void Delete(string logId)
		{
			DAI.RunProcNonQuery("CRM_SysLog_Delete",logId);
		}

		#endregion
	}
}