private void button5_Click(object sender, EventArgs e)
{
//List<user> users = user.Select("userid", "username").Where("userid", 4, "username", "qq").Limit(0, 1).Order("AAA", "desc").Execute();
user us = new user();
//HOYICMD cmd = user.Select<user>().Where("userid", 4, "username", "qq");
//HOYICMD cmd = user.Select<user>("userid", "username").Where("userid", 4, "username", "qq");
//this.dataGridView1.DataSource = user.I<user>().Where("userid", 4).Select("userid", "username");
//this.dataGridView1.DataSource = user.I<user>().Where("userid", 4).Select();
//this.dataGridView1.DataSource = HOYI.I<user>().Select HOYI.I<user>;// user.I<user>().Select();
//this.dataGridView1.DataSource = HOYI.I<user>().Where("userid", 4).Select();
var ids = new[] { 4, 5 };
//this.dataGridView1.DataSource = HOYI.I<user>().In("userid", ids).Select();
//this.dataGridView1.DataSource = user.E.Where(user.userid, 4).Select(user.userid, 5, user.username);
//this.dataGridView1.DataSource = user.E.In(user.userid, ids).Select();
//user.E.Where(Equals(user.username, "3"));
//user.E.Where(user.username , "3", &&, user.userid ,4);
//user.E.Where(user.username, "3");
//user.E.Where(user.username.Equals("11"));
//user.E.Where(user.username.Equals(3));
//user.E.Where()
//string cmd = (user.username == "3" & user.userid != 3);
//HOYICMD cmd = user.username.EQ("3") && user.userid.IndexOf();
//user.userid.EQ(3) && ;
//user.userid.In(ids);
//user.E.Where(user.username == "3" && user.userid == 4 || user.userid in ids);
//Expression<Func<string, bool>> e1 = c => c == "London";
//string cmd = (user.username.Equals("3") & user.userid.Except(5) & user.username in ids));
//string cmd2 = user.username.Equals("3") & user.username.In(ids);
user.E.Where(user.username.Equals("3") & user.username.Except("5"));
//user.E.Where(user.userid.In(ids));
//MessageBox.Show(cmd.cmd);
}
private void button7_Click(object sender, EventArgs e)
{
user us = new user(tx_username.Text, tx_password.Text, 0, "");
int id = us.Insert_RETURN_ID();
MessageBox.Show(id.ToString());
button1_Click(null, null);
}
private void button7_Click(object sender, EventArgs e)
{
//user user = user.E.First<user>();
user user = new user("XX", 12,"XX");
bool Exists = user.Exists();
MessageBox.Show(Exists.ToString());
}
private void button5_Click(object sender, EventArgs e)
{
user us = new user(tx_username.Text, tx_password.Text, 0, "");
int count = us.Insert();
var ss = new{ user.userid, user.username };
button1_Click(null, null);
}