/// <summary>
/// 更新会话
/// </summary>
/// <param name="cookie">会话</param>
/// <returns>状态</returns>
public int updateCookie(UserCookie cookie)
{
String sql = String.Format("UPDATE USERCOOKIE SET VALUE = '{0}' WHERE USERID = {1} AND KEY = '{2}'",
FCStrEx.getDBString(cookie.m_value), m_userID, FCStrEx.getDBString(cookie.m_key));
SQLiteConnection conn = new SQLiteConnection(m_connectStr);
SQLiteCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
return(1);
}
/// <summary>
/// 添加用户Cookie
/// </summary>
/// <param name="cookie">消息</param>
/// <returns>状态</returns>
public int addCookie(UserCookie cookie)
{
UserCookie oldCookie = new UserCookie();
if (getCookie(cookie.m_key, ref oldCookie) > 0)
{
updateCookie(cookie);
}
else
{
String sql = String.Format("INSERT INTO USERCOOKIE(USERID, KEY, VALUE, MODIFYTIME, CREATETIME) values ({0}, '{1}', '{2}','1970-1-1','1970-1-1')",
m_userID, FCStrEx.getDBString(cookie.m_key), FCStrEx.getDBString(cookie.m_value));
SQLiteConnection conn = new SQLiteConnection(m_connectStr);
conn.Open();
SQLiteCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
conn.Close();
}
return(1);
}
/// <summary>
/// 获取用户Cookie
/// </summary>
/// <param name="key">键</param>
/// <param name="cookie">会话</param>
/// <returns>状态</returns>
public int getCookie(String key, ref UserCookie cookie)
{
int state = 0;
String sql = String.Format("SELECT * FROM USERCOOKIE WHERE USERID = {0} AND KEY = '{1}'", m_userID, FCStrEx.getDBString(key));
SQLiteConnection conn = new SQLiteConnection(m_connectStr);
SQLiteCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
conn.Open();
SQLiteDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
cookie.m_userID = reader.GetInt32(0);
cookie.m_key = reader.GetString(1);
cookie.m_value = reader.GetString(2);
state = 1;
}
reader.Close();
conn.Close();
return(state);
}
/// <summary>
/// 删除用户Cookie
/// </summary>
/// <param name="key">键</param>
/// <returns>状态</returns>
public int deleteCookie(String key)
{
String sql = String.Format("DELETE FROM USERCOOKIE WHERE USERID = {0} AND KEY = '{1}'", m_userID, FCStrEx.getDBString(key));
SQLiteConnection conn = new SQLiteConnection(m_connectStr);
SQLiteCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
return(1);
}
