Newer
Older
EMS_REFACTOR / LogManager.cs
T440 on 10 Mar 2019 1 KB first release
using System;
using System.Data;

namespace Cyberpipe
{
    class LogManager
    {
        //保存日志
        public static void saveLog(String username, String operation)
        {
            try
            {
                //获得当前时间
                string now = DateTime.Now.ToString("yyyy-MM-dd HH-mm-ss");

                //保存日志
                //string sql = " insert into casic_loginfo values('" + now + "','" +
                //    username + "','" + operId + "','')";
                string sql = "insert into casic_loginfo(LOGDATE,LOGUSERNAME,LOGOPER) values (to_date('"
                    + now + "','yyyy-MM-dd HH24-MI-SS'),'" + username + "','" + operation + "')";

                int count = OledbHelper.sqlExecuteNonQuery(sql);

            }
            catch (Exception ex)
            {
                LogError.PublishError(ex);
                
            }

        }
        /// <summary>
        /// 一个参数,便于线程进行调用
        /// </summary>
        /// <param name="userAndOperate"></param>
        public static void saveLog(string userAndOperate)
        {
            string userName = userAndOperate.Substring(0, userAndOperate.IndexOf(","));
            string operation = userAndOperate.Substring(userAndOperate.IndexOf(",") + 1);
            try
            {
                saveLog(userName, operation);
            }
            catch (Exception)
            {

                throw;

            }


        }
    }
}