//根据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);
}
}
