MyOAExx/OA.DAL/OperateLogService.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

//============================================================
// Producnt name:		TenXiang.Code
// Coded by:			hotboart
// Auto generated at: 	2014/1/5 11:47:44
//============================================================



using System;						
using System.Collections.Generic;	
using System.Text;					
using System.Data;					
using System.Data.SqlClient;		
using OA.Models;



namespace OA.DAL
{								

	public static partial class OperateLogService
	{	
		//Add Mothed Start
		public static readonly string InsertSql = "INSERT OperateLog (UserId, OperateName, ObjectId, OperateDesc, OperateTime)VALUES (@UserId, @OperateName, @ObjectId, @OperateDesc, @OperateTime)";
		public static readonly string UpdateSql = "Update OperateLog set UserId=@UserId, OperateName=@OperateName, ObjectId=@ObjectId, OperateDesc=@OperateDesc, OperateTime=@OperateTime where OperateId=@OperateId";
		public static readonly string DeleteSql = "Delete FROM OperateLog  where OperateId=@OperateId";
		public static readonly string SelectSql = "Select * FROM OperateLog";
		public static readonly string SelectSqlById = "Select * FROM OperateLog where OperateId =@OperateId";
	    public static int AddOperateLog(OperateLog operateLog)
	    {								
			string sql = InsertSql;
            SqlParameter[] para = new SqlParameter[]
           						  {
										new SqlParameter("@UserId",operateLog.UserId), new SqlParameter("@OperateName",operateLog.OperateName), new SqlParameter("@ObjectId",operateLog.ObjectId), new SqlParameter("@OperateDesc",operateLog.OperateDesc), new SqlParameter("@OperateTime",operateLog.OperateTime)
								  }	;									
    	    return DBHelper.ExecNonQuery(sql, para);
		}  
		public static int UpdateOperateLog(OperateLog operateLog)
	    {								
			string sql = UpdateSql;
            SqlParameter[] para = new SqlParameter[]
           						  {
										new SqlParameter("@OperateId",operateLog.OperateId), new SqlParameter("@UserId",operateLog.UserId), new SqlParameter("@OperateName",operateLog.OperateName), new SqlParameter("@ObjectId",operateLog.ObjectId), new SqlParameter("@OperateDesc",operateLog.OperateDesc), new SqlParameter("@OperateTime",operateLog.OperateTime)
								  }	;									
    	    return DBHelper.ExecNonQuery(sql, para);
		}  
		public static int DelOperateLog(OperateLog operateLog)
	    {								
			string sql = DeleteSql;
            SqlParameter[] para = new SqlParameter[]
           						  {
										new SqlParameter("@OperateId",operateLog.OperateId)
								  }	;									
    	    return DBHelper.ExecNonQuery(sql, para);
		}
		public static IList< OperateLog > GetAllList()
		{								
			string sql = SelectSql;
    	    return GetListBySql(sql);
		}