//根据sql查询登录信息 IList <LoginMarks> GetLoginMarksBySql(string sql) { SqlDataReader reader = DBHelper.ExecuteReader(sql); IList <LoginMarks> LoginMarks = new List <LoginMarks>(); try { while (reader.Read()) { LoginMarks lm = new LoginMarks(); lm.markId = Convert.ToInt32(reader["markId"]); lm.userId = Convert.ToInt32(reader["userId "]); lm.userName = reader["userName"].ToString(); lm.loginTime = (DateTime)reader["loginTime"]; LoginMarks.Add(lm); } } catch (Exception) { throw; } finally { if (reader != null) { reader.Close(); } } return(LoginMarks); }
//插入 登录记录 public bool save(LoginMarks lm) { string sql = "insert into t_LoginMarks(userId,userName,loginTime) values(" + lm.userId + ",'" + lm.userName + "','" + lm.loginTime + "')"; int flag = DBHelper.ExecuteSQL(sql); if (flag == 1) { return(true); } else { return(false); } }