/// <summary>
/// 测试数据库连接
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Splash_Load(object sender, EventArgs e)
{
try
{
SqlLiteConn conn = new SqlLiteConn();
conn.getConn();
}
catch (Exception ex)
{
MessageBox.Show("数据库迷之消失:"+ex.Message);
}
return;
}
public void SaveCookie(string username)
{
List <Cookie> cooklist = GetAllCookies(cookiec);
SqlLiteConn conn = new SqlLiteConn();
string sql = "";
sql = "delete from cookie where username = '******';";
conn.ExecuteScalar(sql);
foreach (Cookie cookie in cooklist)
{
string cookieString = JsonConvert.SerializeObject(cookie);
sql = "insert into cookie (username,cookie) values ('" + username + "','" + cookieString + "');";
conn.ExecuteScalar(sql);
}
}
public CookieContainer RestoreCookie(string username)
{
DataTable dt = null;
cookiec = new CookieContainer();
SqlLiteConn conn = new SqlLiteConn();
string sql = "select username,cookie from cookie where username = '******' ;";
dt = conn.ExecuteDataTable(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
Cookie ck = JsonConvert.DeserializeObject <Cookie>(dt.Rows[i]["cookie"].ToString());
cookiec.Add(ck);
}
return(cookiec);
}
private void checkIn()
{
MessageBox.Show("banana throw start");
DataTable dt = null;
SqlLiteConn conn = new SqlLiteConn();
string sql = "select username,userpassword,userid from user ;";
dt = conn.ExecuteDataTable(sql);
conn.ExecuteDataTable(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
string s = webutil.login(dt.Rows[i]["username"].ToString(), dt.Rows[i]["userpassword"].ToString());
string userid = dt.Rows[i]["userid"].ToString();
string s1 = webutil.throwBanana(acNo,userid,webutil.cookiec);
Thread.Sleep(20000);
}
MessageBox.Show("banana OK");
}
/// <summary>
/// 检查是否为第一次使用和是否有id记录
/// </summary>
/// <returns></returns>
public void checkUserId()
{
bool isUserIdRec = false;
SqlLiteConn conn = new SqlLiteConn();
DataTable dt = conn.GetSchema();
if (dt.Rows.Count > 0)
{
//是否有记录
SQLiteParameter[] pars = new SQLiteParameter[] { new SQLiteParameter("", "") };
string sql = "select count() from user where id >0";
SQLiteDataReader r = conn.ExecuteReader(sql, pars);
if (r.Read() && (r.GetInt32(0) > 0))
{
r.Close();
isUserIdRec = true;
}
else
{
isUserIdRec = false;
}
}
else
{
//空数据库初始化
string sql = @"
DROP TABLE IF EXISTS 'main'.'user';
CREATE TABLE 'user' (
'id' INTEGER NOT NULL,
'userid' INTEGER,
'username' TEXT NOT NULL,
'userpassword' TEXT NOT NULL,
'moni' REAL,
PRIMARY KEY ('id')
);";
conn.ExecuteNonQuery(sql);
}
if (!isUserIdRec)
{
login loginform = new login();
loginform.Show();
}
}
