private void check()
{
string s = "";
DataTable dt = null;
SqlLiteConn conn = new SqlLiteConn();
string sql = "select username from regname where isreg = 0;";
dt = conn.ExecuteDataTable(sql);
//conn.ExecuteDataTable(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
s += dt.Rows[i]["username"].ToString() + " 的状态为：";
bool isThisUserUnique = webutil.checkUsernameReg(dt.Rows[i]["username"].ToString());
if (isThisUserUnique)
{
s += " 可以使用 ";
sql = "update regname set isused = 0 where username = '******';";
conn.ExecuteScalar(sql);
}
else
{
s += " 已被注册 ";
sql = "update regname set isused = 1 where username = '******';";
conn.ExecuteScalar(sql);
}
SetText("\r\n" + s);
}
}
public void BindData()
{
this.pictureBox1.Image = webutil.getCaptcha();
if (this.pictureBox1.Image == null)
{
this.pictureBox1.Image = webutil.getCaptcha();
}
string s = "";
DataTable dt = null;
SqlLiteConn conn = new SqlLiteConn();
string sql = "select username from regname where isreg = 0 and isused = 0 limit 1;";
dt = conn.ExecuteDataTable(sql);
conn.ExecuteDataTable(sql);
this.textBox_name.Text = dt.Rows[0]["username"].ToString();
string id = Guid.NewGuid().ToString();
pictureBox1.Image.Save(System.Environment.CurrentDirectory + "\\Image\\" + id + ".jpg", System.Drawing.Imaging.ImageFormat.Jpeg);
string temp = Marshal.PtrToStringAnsi(OCRpart(System.Environment.CurrentDirectory + "\\Image\\" + id + ".jpg", -1, 0, 0, 110, 50));
string newStr = "";
for (int i = 0; i < temp.Length; i++)
{
int tmp = (int)temp[i];
if ((tmp >= 65 && tmp <= 90) || (tmp >= 97 && tmp <= 122))
{
newStr += temp[i];
}
}
this.textBox_captcha.Text = newStr;
if (newStr.Length != 4)
{
BindControl();
}
}
/// <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;
}
private void button3_Click(object sender, EventArgs e)
{
DataTable dt = null;
SqlLiteConn conn = new SqlLiteConn();
string sqlUpdate = " update regname set isreg = 1 , isused = 1 where username = '******'";
conn.ExecuteScalar(sqlUpdate, null);
string sql = "select username from regname where isreg = 0 and isused = 0 limit 1;";
dt = conn.ExecuteDataTable(sql);
conn.ExecuteDataTable(sql);
this.textBox_name.Text = dt.Rows[0]["username"].ToString();
}
private void checkOldUser()
{
string s = "";
DataTable dt = null;
SqlLiteConn conn = new SqlLiteConn();
string sql = "select account from acfunolduser ";
dt = conn.ExecuteDataTable(sql);
conn.ExecuteDataTable(sql);
for (int i = 118132; i < dt.Rows.Count; i++)
{
// s += dt.Rows[i]["account"].ToString() + " 的uid为：";
string usercardString = webutil.getUserInfo(dt.Rows[i]["account"].ToString());
if (!usercardString.Contains("用户被封禁") && !usercardString.Contains("用户不存在"))
{
string uid = "";
Root root = (Root)JsonConvert.DeserializeObject(usercardString, typeof(Root));
if (root != null)
{
uid = root.getuserjson().getUid();
if (uid == "" || uid == null)
{
MessageBox.Show("空");
return;
}
else
{
//{"userjson":{"currExp":61,"stows":1,"comments":65,"gender":1,"level":22,"sign":"人家真的不搞基的。。","follows":0,"lastLoginDate":"2015-04-26 15:01:46.0","avatar":"http://static.acfun.mm111.net/dotnet/artemis/u/cms/www/201504/26143138p36q.jpg","posts":1,"followed":0,"lastLoginIp":"113.90.21.*","fans":0,"uid":1292228,"regTime":"2015-04-25 22:10:44.0","nextLevelNeed":100,"comeFrom":"","name":"一个不搞基的男孩子","dTime":"","expPercent":22,"isFriend":0,"views":0},"success":true}
//更新基本信息
string usersign = "";
if (root.getuserjson().getSign() != null)
{
usersign = root.getuserjson().getSign().Replace("\'", "");
}
string sign = " sign='" + usersign + "',";
//sign = sign.Replace("\'", "");
sql = "update acfunolduser set userid = " + uid + ",id = " + i + ", currexp = " + root.getuserjson().getCurrExp() + ", level = " + root.getuserjson().getLevel() + " ,follows=" + root.getuserjson().getFollows() + " ,lastlogindate= '" + root.getuserjson().getLastLoginDate() + "',stows=" + root.getuserjson().getStows() + " ,comments=" + root.getuserjson().getComments() + " ,gender=" + root.getuserjson().getGender() + " ," + sign + " avatar='" + root.getuserjson().getAvatar() + "' ,posts=" + root.getuserjson().getPosts() + " ,followed=" + root.getuserjson().getFollowed() + " ,lastloginip='" + root.getuserjson().getLastLoginIp() + "' ,fans=" + root.getuserjson().getFans() + " ,regTime='" + root.getuserjson().getRegTime() + "' ,nextlevelneed=" + root.getuserjson().getNextLevelNeed() + " ,comefrom= '" + root.getuserjson().getComeFrom() + "',dtime='" + root.getuserjson().getDTime() + "' ,exppercent=" + root.getuserjson().getExpPercent() + " ,isfriend=" + root.getuserjson().getIsFriend() + " ,views=" + root.getuserjson().getViews() + " " +
" where account = '" + dt.Rows[i]["account"].ToString() + "';";
conn.ExecuteScalar(sql);
//更新uid
s = uid;
SetText("\n" + s);
}
}
}
}
}
/// <summary>
/// reg
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
string mail = textBox_mail.Text.Trim();
webutil.regQianmo(mail, "153037");
label_STATUS.Text = "ok";
SqlLiteConn conn = new SqlLiteConn();
string sql = "INSERT INTO qianmo ( username , mail , password , nickname , id , userid , isactive , isnamereg ) VALUES ('" + mail + "', ' ', '153037', '', NULL, NULL, '0.0', '0.0');";
conn.ExecuteScalar(sql, null);
button1.Enabled = false;
button2.Enabled = false;
button3.Enabled = true;
button4.Enabled = false;
}
private void checkIn()
{
MessageBox.Show("check in start");
DataTable dt = null;
SqlLiteConn conn = new SqlLiteConn();
string sql = "select username,userpassword 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 s1 = webutil.checkIn(webutil.cookiec);
Thread.Sleep(20000);
}
MessageBox.Show("check in success!");
}
private void throwBananaStart()
{
MessageBox.Show("banana throw start");
DataTable dt = null;
SqlLiteConn conn = new SqlLiteConn();
string sql = "select username,userpassword,userid from user ;";
dt = 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, banCount, userid, webutil.RestoreCookie(dt.Rows[i]["username"].ToString()));
Thread.Sleep(1000);
}
MessageBox.Show("banana OK");
}
//检查是否被占用
private void button2_Click(object sender, EventArgs e)
{
label_STATUS.Text = "用户名可用性检测中";
DataTable dt = null;
SqlLiteConn conn = new SqlLiteConn();
string sql = "select username from regname ;";
dt = conn.ExecuteDataTable(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
if (webutil.checkQianmoName(dt.Rows[i]["username"].ToString()))
{
string sqlUpdate = " update regname set isused = 1 where username = '******'";
conn.ExecuteScalar(sqlUpdate, null);
}
}
label_STATUS.Text = "用户名可用性检测完成";
}
/// <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);
}
finally
{
string connstring = "Data Source=" + System.Environment.CurrentDirectory + "\\DB\\article.db";
System.Data.SQLite.SQLiteConnection.CreateFile(connstring);
}
return;
}
/// <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();
}
}
/// <summary>
/// 测试数据库连接
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dataLoad()
{
try
{
SqlLiteConn conn = new SqlLiteConn();
conn.getConn();
}
catch (Exception ex)
{
string dblocation = System.Environment.CurrentDirectory + "\\DB\\article.db";
string connstring = "Data Source=" + System.Environment.CurrentDirectory + "\\DB\\article.db";
//System.Data.SQLite.SQLiteConnection.CreateFile(dblocation);
MessageBox.Show("数据库迷之消失:" + ex.Message);
}
finally
{
}
return;
}
/// <summary>
/// reg
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
label_STATUS.Text = "Name set start";
string s = webutil.loginQianmo(textBox_mail.Text.Trim(), textBox_pwd.Text.Trim());
if (webutil.setQianmoName(textBox_name.Text.Trim(), webutil.cookiec))
{
SqlLiteConn conn = new SqlLiteConn();
string sql = "update qianmo set nickname='" + textBox_name.Text + "',isnamereg =1.0 where username = '******';";
conn.ExecuteScalar(sql, null);
string sqlUpdate = " update regname set isused = 1 where username = '******'";
conn.ExecuteScalar(sqlUpdate, null);
label_STATUS.Text = "Name set ok";
BindData();
}
else
{
MessageBox.Show("error!");
}
}
/// <summary>
/// reg
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
string s = webutil.regNewUser(textBox_mail.Text.Trim(), textBox_name.Text.Trim(), textBox_pwd.Text.Trim(), textBox_invite.Text, textBox_captcha.Text.Trim(), webutil.cookiec);
if (!s.Contains("false"))
{
string sqlInsert = "insert into user (username,userpassword,mailbox) values('" + textBox_name.Text + "','" + textBox_pwd.Text + "','" + textBox_mail.Text + "');";
SqlLiteConn conn = new SqlLiteConn();
string sqlUpdate = " update regname set isreg = 1 , isused = 1 where username = '******'";
conn.ExecuteScalar(sqlUpdate, null);
conn.ExecuteScalar(sqlInsert, null);
MessageBox.Show(s);
BindControl();
this.textBox_mail.Text = "";
}
else
{
MessageBox.Show(s);
}
}
public void BindData()
{
DataTable dtname = null;
DataTable dtmail = null;
SqlLiteConn conn = new SqlLiteConn();
string sqlname = "select username from regname where isreg = 0 and isused = 0 limit 1;";
string sqlmail = "select username from qianmo where isnamereg = 0 limit 1;";
dtname = conn.ExecuteDataTable(sqlname);
dtmail = conn.ExecuteDataTable(sqlmail);
if (dtname.Rows.Count == 0)
{
MessageBox.Show("error! username count is 0");
return;
}
else if (dtmail.Rows.Count == 0)
{
MessageBox.Show("error! mail count is 0");
return;
}
this.textBox_name.Text = dtname.Rows[0]["username"].ToString();
this.textBox_mail.Text = dtmail.Rows[0]["username"].ToString();
string id = Guid.NewGuid().ToString();
}
