当前文件路径：hevod/DAL/AdminLoginLogs.cs

		            
 1using System;
 2using System.Data;
 3using System.Data.OleDb;
 4using System.Text;
 5
 6namespace DAL
 7...{
 8    /**//// <summary>
 9    /// adminLoginLogs
10    /// </summary>
11    public class AdminLoginLogs
12    ...{
13        public DBConn dbConn = new DBConn();
14        /**//// <summary>
15        /// 添加loginLog
16        /// </summary>
17        /// <returns></returns>
18        public bool AddLoginLog(Model.AdminLoginLogs modelALL)
19        ...{
20            bool isOK=false;
21            string sql = "insert into adminLoginLogs (adminName,adminIp) values ('"+modelALL.AdminName+"','"+modelALL.AdminIp+"')";
22            OleDbCommand cmd = new OleDbCommand(sql, dbConn.conn);
23            try
24            ...{
25                dbConn.Open();
26                if (cmd.ExecuteNonQuery() > 0)
27                    isOK = true;
28            }
29            catch (OleDbException ex)
30            ...{
31                throw ex;
32            }
33            finally
34            ...{
35                dbConn.Close();
36            }
37            return isOK;
38        }
39
40
41        /**//// <summary>
42        /// 得到所有日志列表
43        /// </summary>
44        /// <returns></returns>
45        public DataSet GetLoginLogs()
46        ...{
47            string sql = "select id,adminName,adminIp,adminTime from adminLoginLogs order by id desc";
48            OleDbCommand cmd = new OleDbCommand(sql, dbConn.conn);
49            OleDbDataAdapter da = new OleDbDataAdapter(cmd);
50            DataSet ds = null;
51            try
52            ...{
53                dbConn.Open();
54                ds = new DataSet();
55                da.Fill(ds);
56            }
57            catch (OleDbException ex)
58            ...{
59                throw ex;
60            }
61            finally
62            ...{
63                dbConn.Close();
64            }
65            return ds;
66        }
67    }
68}
69