logmassagedb.cs

来自「高校 学籍管理、成绩、收费、网上教学」· CS 代码 · 共 71 行

//************************************************************
//项目:学生学籍管理系统　　　　　　　 
//版权:Copyright(c) ,TZZ   　　　　　　　　　　　　　
//模块名:基础数据模块
//说明:LogManage基础类
//版本:1.0
//修改历史：
//	2006-6-6 BY Gawain
//			初始版本
//*****************************************************************

using System;
using System.Data;
using System.Data.SqlClient;
using System.Reflection;

using QSEDUNET.MODEL.BaseInfo;
using QSEDUNET.COMMAND;

namespace QSEDUNET.DATALABLE.BaseInfo
{
    public class LogManageDB:SqlDBBaseConnection
    {
        public LogManageDB() { }
        public LogManageDB(SqlConnection objCon) : base(objCon) { }
        public LogManageDB(SqlConnection objCon, SqlTransaction objTrans) : base(objCon, objTrans) { }

        /// <summary>
        /// 新建数据
        /// </summary>
        public int NewLogManage(LogManageModel objLogManageModel)
        {
            try
            {
                SqlParameter[] parameters = 
					{
						new SqlParameter( "@Log_ID",SqlDbType.Int),
						new SqlParameter( "@User_ID",SqlDbType.Int),
						new SqlParameter( "@Log_Msg",SqlDbType.NVarChar,200),
						new SqlParameter( "@Log_Type",SqlDbType.Int),
						new SqlParameter( "@Function_Name",SqlDbType.NVarChar,100),
						new SqlParameter( "@LOG_TIME",SqlDbType.DateTime),
						new SqlParameter( "@IsSucess",SqlDbType.Int),
					};
                parameters[0].Direction = ParameterDirection.Output;
                parameters[1].Value = objLogManageModel.User_ID;
                parameters[2].Value = objLogManageModel.Log_Msg;
                parameters[3].Value = objLogManageModel.Log_Type;
                parameters[4].Value = objLogManageModel.Function_Name;
                parameters[5].Value = objLogManageModel.LOG_TIME;
                parameters[6].Value = objLogManageModel.IsSucess;

                StroedProdedure("SP_LogManage_Insert", parameters);
                int returnValue = Run();

                return returnValue;

            }
            catch (Exception ex)
            {
                throw (ex);
            }
            finally
            {
                CommandDispose();
            }
        }
    }

}