/// <summary> /// /// </summary> /// <param name="begin"></param> /// <param name="end"></param> /// <param name="typeID"></param> /// <param name="code"></param> /// <returns></returns> internal List<Business.SystemLog> GetByCodeAndTime(DateTime begin, DateTime end, int typeID, string code) { SqlConnection connection = new SqlConnection(DBConnection.DBConnection.Connection); DS.SystemLogDataTable tb = null; try { DSTableAdapters.SystemLogTableAdapter adap = new DSTableAdapters.SystemLogTableAdapter(); adap.Connection = connection; tb = adap.GetByCodeAndTime(begin, typeID, end, code); } catch (Exception ex) { } finally { connection.Dispose(); } return this.MapSystemLog(tb); }
/// <summary> /// /// </summary> /// <param name="begin"></param> /// <param name="end"></param> /// <param name="ipAddress"></param> /// <param name="typeID"></param> /// <returns></returns> internal List<Business.SystemLog> GetByIPAddressAndType(DateTime begin, DateTime end, string ipAddress, int typeID) { SqlConnection connection = new SqlConnection(DBConnection.DBConnection.Connection); DS.SystemLogDataTable tb = null; DSTableAdapters.SystemLogTableAdapter adap = new DSTableAdapters.SystemLogTableAdapter(); try { connection.Open(); adap.Connection = connection; tb = adap.GetByIPAddressAndType(ipAddress.Trim(), typeID, begin, end); } catch (Exception ex) { } finally { adap.Connection.Close(); connection.Close(); } return this.MapSystemLog(tb); }
/// <summary> /// /// </summary> /// <param name="systemLog"></param> /// <returns></returns> internal bool InsertLog(Business.SystemLog systemLog) { SqlConnection connection = new SqlConnection(DBConnection.DBConnection.Connection); int rowAffect=0; try { DSTableAdapters.SystemLogTableAdapter adap = new DSTableAdapters.SystemLogTableAdapter(); adap.Connection = connection; connection.Open(); rowAffect = adap.Insert(systemLog.TypeID, systemLog.LogContent, systemLog.LogDay, systemLog.Comment, systemLog.IPAddress, systemLog.InvestorCode); ; } catch (Exception ex) { } finally { connection.Close(); connection.Dispose(); } if (rowAffect == 0) { return false; } else { return true; } }