Ejemplo n.º 1
0
        /// <summary>
        /// 获取所有的系统操作日志 Sys_OpLog对象(即:一条记录
        /// </summary>
        public List <Sys_OpLog> GetAll()
        {
            List <Sys_OpLog> ret = new List <Sys_OpLog>();
            string           sql = "SELECT  EL_ID,EL_Module,EL_ModuleName,EL_Date,EL_Author,EL_AuthorName,EL_ClientIP,EL_RequireURL,EL_Message,Stat FROM Sys_OpLog where 1=1 AND ((Stat is null) or (Stat=0) ) order by EL_ID desc ";
            SqlDataReader    dr  = null;

            try {
                dr = (SqlDataReader)idb.ReturnReader(sql);
                while (dr.Read())
                {
                    Sys_OpLog sys_OpLog = new Sys_OpLog();
                    if (dr["EL_ID"] != DBNull.Value)
                    {
                        sys_OpLog.EL_ID = Convert.ToDecimal(dr["EL_ID"]);
                    }
                    if (dr["EL_Module"] != DBNull.Value)
                    {
                        sys_OpLog.EL_Module = Convert.ToString(dr["EL_Module"]);
                    }
                    if (dr["EL_ModuleName"] != DBNull.Value)
                    {
                        sys_OpLog.EL_ModuleName = Convert.ToString(dr["EL_ModuleName"]);
                    }
                    if (dr["EL_Date"] != DBNull.Value)
                    {
                        sys_OpLog.EL_Date = Convert.ToDateTime(dr["EL_Date"]);
                    }
                    if (dr["EL_Author"] != DBNull.Value)
                    {
                        sys_OpLog.EL_Author = Convert.ToString(dr["EL_Author"]);
                    }
                    if (dr["EL_AuthorName"] != DBNull.Value)
                    {
                        sys_OpLog.EL_AuthorName = Convert.ToString(dr["EL_AuthorName"]);
                    }
                    if (dr["EL_ClientIP"] != DBNull.Value)
                    {
                        sys_OpLog.EL_ClientIP = Convert.ToString(dr["EL_ClientIP"]);
                    }
                    if (dr["EL_RequireURL"] != DBNull.Value)
                    {
                        sys_OpLog.EL_RequireURL = Convert.ToString(dr["EL_RequireURL"]);
                    }
                    if (dr["EL_Message"] != DBNull.Value)
                    {
                        sys_OpLog.EL_Message = Convert.ToString(dr["EL_Message"]);
                    }
                    if (dr["Stat"] != DBNull.Value)
                    {
                        sys_OpLog.Stat = Convert.ToInt32(dr["Stat"]);
                    }
                    ret.Add(sys_OpLog);
                }
            }catch (System.Exception ex) { throw ex; }  finally { if (dr != null)
                                                                  {
                                                                      dr.Close();
                                                                  }
                                                                  if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open)
                                                                  {
                                                                      idb.GetConnection().Close();
                                                                  }
            }
            return(ret);
        }
Ejemplo n.º 2
0
        /// <summary>
        /// 获取指定的系统操作日志 Sys_OpLog对象集合
        /// </summary>
        public List <Sys_OpLog> GetListByWhere(string strCondition)
        {
            List <Sys_OpLog> ret = new List <Sys_OpLog>();
            string           sql = "SELECT  EL_ID,EL_Module,EL_ModuleName,EL_Date,EL_Author,EL_AuthorName,EL_ClientIP,EL_RequireURL,EL_Message,Stat FROM Sys_OpLog WHERE 1=1 AND ((Stat is null) or (Stat=0) ) ";

            if (!string.IsNullOrEmpty(strCondition))
            {
                strCondition.Replace('\'', '"'); //防sql注入
                sql += strCondition;
            }
            sql += " ORDER BY EL_ID DESC ";
            SqlDataReader dr = null;

            try {
                dr = (SqlDataReader)idb.ReturnReader(sql);
                while (dr.Read())
                {
                    Sys_OpLog sys_OpLog = new Sys_OpLog();
                    if (dr["EL_ID"] != DBNull.Value)
                    {
                        sys_OpLog.EL_ID = Convert.ToDecimal(dr["EL_ID"]);
                    }
                    if (dr["EL_Module"] != DBNull.Value)
                    {
                        sys_OpLog.EL_Module = Convert.ToString(dr["EL_Module"]);
                    }
                    if (dr["EL_ModuleName"] != DBNull.Value)
                    {
                        sys_OpLog.EL_ModuleName = Convert.ToString(dr["EL_ModuleName"]);
                    }
                    if (dr["EL_Date"] != DBNull.Value)
                    {
                        sys_OpLog.EL_Date = Convert.ToDateTime(dr["EL_Date"]);
                    }
                    if (dr["EL_Author"] != DBNull.Value)
                    {
                        sys_OpLog.EL_Author = Convert.ToString(dr["EL_Author"]);
                    }
                    if (dr["EL_AuthorName"] != DBNull.Value)
                    {
                        sys_OpLog.EL_AuthorName = Convert.ToString(dr["EL_AuthorName"]);
                    }
                    if (dr["EL_ClientIP"] != DBNull.Value)
                    {
                        sys_OpLog.EL_ClientIP = Convert.ToString(dr["EL_ClientIP"]);
                    }
                    if (dr["EL_RequireURL"] != DBNull.Value)
                    {
                        sys_OpLog.EL_RequireURL = Convert.ToString(dr["EL_RequireURL"]);
                    }
                    if (dr["EL_Message"] != DBNull.Value)
                    {
                        sys_OpLog.EL_Message = Convert.ToString(dr["EL_Message"]);
                    }
                    if (dr["Stat"] != DBNull.Value)
                    {
                        sys_OpLog.Stat = Convert.ToInt32(dr["Stat"]);
                    }
                    ret.Add(sys_OpLog);
                }
            }catch (System.Exception ex) { throw ex; }  finally { if (dr != null)
                                                                  {
                                                                      dr.Close();
                                                                  }
                                                                  if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open)
                                                                  {
                                                                      idb.GetConnection().Close();
                                                                  }
            }
            return(ret);
        }
Ejemplo n.º 3
0
        /// <summary>
        /// 添加系统操作日志 Sys_OpLog对象(即:一条记录)
        /// </summary>
        public int Add(Sys_OpLog sys_OpLog)
        {
            string sql = "INSERT INTO Sys_OpLog (EL_Module,EL_ModuleName,EL_Date,EL_Author,EL_AuthorName,EL_ClientIP,EL_RequireURL,EL_Message,Stat) VALUES (@EL_Module,@EL_ModuleName,@EL_Date,@EL_Author,@EL_AuthorName,@EL_ClientIP,@EL_RequireURL,@EL_Message,@Stat)";

            if (string.IsNullOrEmpty(sys_OpLog.EL_Module))
            {
                idb.AddParameter("@EL_Module", DBNull.Value);
            }
            else
            {
                idb.AddParameter("@EL_Module", sys_OpLog.EL_Module);
            }
            if (string.IsNullOrEmpty(sys_OpLog.EL_ModuleName))
            {
                idb.AddParameter("@EL_ModuleName", DBNull.Value);
            }
            else
            {
                idb.AddParameter("@EL_ModuleName", sys_OpLog.EL_ModuleName);
            }
            if (sys_OpLog.EL_Date == DateTime.MinValue)
            {
                idb.AddParameter("@EL_Date", DBNull.Value);
            }
            else
            {
                idb.AddParameter("@EL_Date", sys_OpLog.EL_Date);
            }
            if (string.IsNullOrEmpty(sys_OpLog.EL_Author))
            {
                idb.AddParameter("@EL_Author", DBNull.Value);
            }
            else
            {
                idb.AddParameter("@EL_Author", sys_OpLog.EL_Author);
            }
            if (string.IsNullOrEmpty(sys_OpLog.EL_AuthorName))
            {
                idb.AddParameter("@EL_AuthorName", DBNull.Value);
            }
            else
            {
                idb.AddParameter("@EL_AuthorName", sys_OpLog.EL_AuthorName);
            }
            if (string.IsNullOrEmpty(sys_OpLog.EL_ClientIP))
            {
                idb.AddParameter("@EL_ClientIP", DBNull.Value);
            }
            else
            {
                idb.AddParameter("@EL_ClientIP", sys_OpLog.EL_ClientIP);
            }
            if (string.IsNullOrEmpty(sys_OpLog.EL_RequireURL))
            {
                idb.AddParameter("@EL_RequireURL", DBNull.Value);
            }
            else
            {
                idb.AddParameter("@EL_RequireURL", sys_OpLog.EL_RequireURL);
            }
            if (string.IsNullOrEmpty(sys_OpLog.EL_Message))
            {
                idb.AddParameter("@EL_Message", DBNull.Value);
            }
            else
            {
                idb.AddParameter("@EL_Message", sys_OpLog.EL_Message);
            }
            if (sys_OpLog.Stat == 0)
            {
                idb.AddParameter("@Stat", 0);
            }
            else
            {
                idb.AddParameter("@Stat", sys_OpLog.Stat);
            }

            return(idb.ExeCmd(sql));
        }
Ejemplo n.º 4
0
        /// <summary>
        /// 获取指定的系统操作日志 Sys_OpLog对象(即:一条记录
        /// </summary>
        public Sys_OpLog GetByKey(decimal eL_ID)
        {
            Sys_OpLog sys_OpLog = new Sys_OpLog();
            string    sql       = "SELECT  EL_ID,EL_Module,EL_ModuleName,EL_Date,EL_Author,EL_AuthorName,EL_ClientIP,EL_RequireURL,EL_Message,Stat FROM Sys_OpLog WHERE 1=1 AND ((Stat is null) or (Stat=0) )  AND EL_ID=@EL_ID ";

            idb.AddParameter("@EL_ID", eL_ID);

            SqlDataReader dr = null;

            try {
                dr = (SqlDataReader)idb.ReturnReader(sql);
                while (dr.Read())
                {
                    if (dr["EL_ID"] != DBNull.Value)
                    {
                        sys_OpLog.EL_ID = Convert.ToDecimal(dr["EL_ID"]);
                    }
                    if (dr["EL_Module"] != DBNull.Value)
                    {
                        sys_OpLog.EL_Module = Convert.ToString(dr["EL_Module"]);
                    }
                    if (dr["EL_ModuleName"] != DBNull.Value)
                    {
                        sys_OpLog.EL_ModuleName = Convert.ToString(dr["EL_ModuleName"]);
                    }
                    if (dr["EL_Date"] != DBNull.Value)
                    {
                        sys_OpLog.EL_Date = Convert.ToDateTime(dr["EL_Date"]);
                    }
                    if (dr["EL_Author"] != DBNull.Value)
                    {
                        sys_OpLog.EL_Author = Convert.ToString(dr["EL_Author"]);
                    }
                    if (dr["EL_AuthorName"] != DBNull.Value)
                    {
                        sys_OpLog.EL_AuthorName = Convert.ToString(dr["EL_AuthorName"]);
                    }
                    if (dr["EL_ClientIP"] != DBNull.Value)
                    {
                        sys_OpLog.EL_ClientIP = Convert.ToString(dr["EL_ClientIP"]);
                    }
                    if (dr["EL_RequireURL"] != DBNull.Value)
                    {
                        sys_OpLog.EL_RequireURL = Convert.ToString(dr["EL_RequireURL"]);
                    }
                    if (dr["EL_Message"] != DBNull.Value)
                    {
                        sys_OpLog.EL_Message = Convert.ToString(dr["EL_Message"]);
                    }
                    if (dr["Stat"] != DBNull.Value)
                    {
                        sys_OpLog.Stat = Convert.ToInt32(dr["Stat"]);
                    }
                }
            }catch (System.Exception ex) { throw ex; }  finally { if (dr != null)
                                                                  {
                                                                      dr.Close();
                                                                  }
                                                                  if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open)
                                                                  {
                                                                      idb.GetConnection().Close();
                                                                  }
            }
            return(sys_OpLog);
        }
Ejemplo n.º 5
0
        /// <summary>
        /// 更新系统操作日志 Sys_OpLog对象(即:一条记录
        /// </summary>
        public int Update(Sys_OpLog sys_OpLog)
        {
            StringBuilder sbParameter = new StringBuilder();
            StringBuilder sb          = new StringBuilder();

            sb.Append(@"UPDATE       Sys_OpLog       SET ");
            if (sys_OpLog.EL_Module_IsChanged)
            {
                sbParameter.Append("EL_Module=@EL_Module, ");
            }
            if (sys_OpLog.EL_ModuleName_IsChanged)
            {
                sbParameter.Append("EL_ModuleName=@EL_ModuleName, ");
            }
            if (sys_OpLog.EL_Date_IsChanged)
            {
                sbParameter.Append("EL_Date=@EL_Date, ");
            }
            if (sys_OpLog.EL_Author_IsChanged)
            {
                sbParameter.Append("EL_Author=@EL_Author, ");
            }
            if (sys_OpLog.EL_AuthorName_IsChanged)
            {
                sbParameter.Append("EL_AuthorName=@EL_AuthorName, ");
            }
            if (sys_OpLog.EL_ClientIP_IsChanged)
            {
                sbParameter.Append("EL_ClientIP=@EL_ClientIP, ");
            }
            if (sys_OpLog.EL_RequireURL_IsChanged)
            {
                sbParameter.Append("EL_RequireURL=@EL_RequireURL, ");
            }
            if (sys_OpLog.EL_Message_IsChanged)
            {
                sbParameter.Append("EL_Message=@EL_Message, ");
            }
            if (sys_OpLog.Stat_IsChanged)
            {
                sbParameter.Append("Stat=@Stat ");
            }
            sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
            sb.Append(" WHERE 1=1 AND ((Stat is null) or (Stat=0))   and EL_ID=@EL_ID; ");
            string sql = sb.ToString();

            if (sys_OpLog.EL_Module_IsChanged)
            {
                if (string.IsNullOrEmpty(sys_OpLog.EL_Module))
                {
                    idb.AddParameter("@EL_Module", DBNull.Value);
                }
                else
                {
                    idb.AddParameter("@EL_Module", sys_OpLog.EL_Module);
                }
            }
            if (sys_OpLog.EL_ModuleName_IsChanged)
            {
                if (string.IsNullOrEmpty(sys_OpLog.EL_ModuleName))
                {
                    idb.AddParameter("@EL_ModuleName", DBNull.Value);
                }
                else
                {
                    idb.AddParameter("@EL_ModuleName", sys_OpLog.EL_ModuleName);
                }
            }
            if (sys_OpLog.EL_Date_IsChanged)
            {
                if (sys_OpLog.EL_Date == DateTime.MinValue)
                {
                    idb.AddParameter("@EL_Date", DBNull.Value);
                }
                else
                {
                    idb.AddParameter("@EL_Date", sys_OpLog.EL_Date);
                }
            }
            if (sys_OpLog.EL_Author_IsChanged)
            {
                if (string.IsNullOrEmpty(sys_OpLog.EL_Author))
                {
                    idb.AddParameter("@EL_Author", DBNull.Value);
                }
                else
                {
                    idb.AddParameter("@EL_Author", sys_OpLog.EL_Author);
                }
            }
            if (sys_OpLog.EL_AuthorName_IsChanged)
            {
                if (string.IsNullOrEmpty(sys_OpLog.EL_AuthorName))
                {
                    idb.AddParameter("@EL_AuthorName", DBNull.Value);
                }
                else
                {
                    idb.AddParameter("@EL_AuthorName", sys_OpLog.EL_AuthorName);
                }
            }
            if (sys_OpLog.EL_ClientIP_IsChanged)
            {
                if (string.IsNullOrEmpty(sys_OpLog.EL_ClientIP))
                {
                    idb.AddParameter("@EL_ClientIP", DBNull.Value);
                }
                else
                {
                    idb.AddParameter("@EL_ClientIP", sys_OpLog.EL_ClientIP);
                }
            }
            if (sys_OpLog.EL_RequireURL_IsChanged)
            {
                if (string.IsNullOrEmpty(sys_OpLog.EL_RequireURL))
                {
                    idb.AddParameter("@EL_RequireURL", DBNull.Value);
                }
                else
                {
                    idb.AddParameter("@EL_RequireURL", sys_OpLog.EL_RequireURL);
                }
            }
            if (sys_OpLog.EL_Message_IsChanged)
            {
                if (string.IsNullOrEmpty(sys_OpLog.EL_Message))
                {
                    idb.AddParameter("@EL_Message", DBNull.Value);
                }
                else
                {
                    idb.AddParameter("@EL_Message", sys_OpLog.EL_Message);
                }
            }
            if (sys_OpLog.Stat_IsChanged)
            {
                if (sys_OpLog.Stat == 0)
                {
                    idb.AddParameter("@Stat", 0);
                }
                else
                {
                    idb.AddParameter("@Stat", sys_OpLog.Stat);
                }
            }

            idb.AddParameter("@EL_ID", sys_OpLog.EL_ID);

            return(idb.ExeCmd(sql));
        }