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); }