private void button3_Click(object sender, EventArgs e)
{
if (textBox1.Text == string.Empty || textBox2.Text == string.Empty || textBox3.Text == string.Empty)
{
MessageBox.Show("至少输入姓名、性别和生日信息。");
}
else
{
var name = textBox1.Text;
var gender = textBox2.Text;
var birth = textBox3.Text;
var father = textBox4.Text;
var peiou = textBox5.Text;
var sql = "select * from [Member] where 姓名 = '" + name + "'and 性别 = '" + gender + "'and 生日 = '" + birth + "'";
AccessHelp AH = new AccessHelp();
var dt = AH.GetDT(sql);
if (dt != null && dt.Rows.Count > 0)
{
MessageBox.Show("已有该成员信息！");
}
else
{
var sql2 = "insert into [Member]([姓名],[性别],[生日],[父亲姓名],[配偶姓名]) values('" + name + "','" + gender + "','" + birth + "','" + father + "','" + peiou + "') ";
AccessHelp AH2 = new AccessHelp();
AH2.RunSql(sql2);
}
}
}
private void bu_denglu_Click(object sender, EventArgs e)
{
var yhm = tB_zhanghao.Text;
var pwd = tB_pwd.Text;
if (tB_zhanghao.Text == "sa" && tB_pwd.Text == "123456")
{
Form3 Manage = new Form3();
Manage.Show();
}
else if (!string.IsNullOrEmpty(yhm) && !string.IsNullOrEmpty(pwd))
{
var sql = "select * from [User] where Yhm = '" + yhm + "' and Pwd = '" + pwd + "'";
AccessHelp AH = new AccessHelp();
var dt = AH.GetDT(sql);
if (dt != null && dt.Rows.Count > 0)
{
Form4 search = new Form4();
search.Show();
this.Hide();
}
else
{
MessageBox.Show("用户名不存在或密码错误！");
}
}
}
private void button2_Click(object sender, EventArgs e)
{
AccessHelp AH = new AccessHelp();
string sql = "select * from [Member]";
var ds = AH.GetDS(sql);
if (ds != null && ds.Tables.Count > 0)
{
this.dataGridView1.DataSource = ds.Tables[0];
}
}
private void button1_Click(object sender, EventArgs e)
{
var name = textBox1.Text;
AccessHelp AH = new AccessHelp();
string sql = "select * from [Member] where [姓名] = '" + name + "'";
var ds = AH.GetDS(sql);
if (ds != null && ds.Tables.Count > 0)
{
this.dataGridView1.DataSource = ds.Tables[0];
}
}
private void button4_Click(object sender, EventArgs e)
{
var yhm = textBox2.Text;
var sql = "select * from [User] where Yhm= '" + yhm + "'";
AccessHelp AH = new AccessHelp();
var dt = AH.GetDT(sql);
if (dt != null && dt.Rows.Count > 0)
{
var sql2 = "delete form [User] where Yhm='" + yhm + "'";
AccessHelp AH2 = new AccessHelp();
AH2.RunSql(sql2);
}
else
{
MessageBox.Show("没有该成员信息！");
}
}
public static void Test()
{
AccessHelp conn = new AccessHelp(@"..\..\..\Doc\test.accdb");
//by ado
var dbConn = conn.DbConn;
string sql = "insert into UserTable(UserId, UserName) values(@UserId, @UserName)";
OleDbParameter[] dbParams =
{
new OleDbParameter("@UserId", Guid.NewGuid().ToString()),
new OleDbParameter("@UserName", "bb"),
};
conn.ExecuteNonQuery(sql, dbParams);
//by dapper
dbConn.Execute(sql, new { UserId = Guid.NewGuid().ToString(), UserName = "******" });
}
private void button2_Click(object sender, EventArgs e)
{
var name = textBox1.Text;
var gender = textBox2.Text;
var birth = textBox3.Text;
var sql = "select * from [Member] where 姓名 = '" + name + "'and 性别 = '" + gender + "'and 生日 = '" + birth + "'";
AccessHelp AH = new AccessHelp();
var dt = AH.GetDT(sql);
if (dt != null && dt.Rows.Count > 0)
{
var sql2 = "delete form [Member] where 姓名='" + name + "'，性别='" + gender + "'";
AccessHelp AH2 = new AccessHelp();
AH2.RunSql(sql2);
}
else
{
MessageBox.Show("没有该成员信息！");
}
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text == string.Empty)
{
MessageBox.Show("请输入账号");
}
else if (textBox2.Text == string.Empty)
{
MessageBox.Show("请输入密码");
}
else if (textBox3.Text == string.Empty)
{
MessageBox.Show("请确认密码");
}
else if (textBox2.Text == textBox3.Text)
{
var yhm = textBox1.Text;
var pwd = textBox2.Text;
var sql = "select * from [User] where Yhm = '" + yhm + "' and Pwd = '" + pwd + "'";
AccessHelp AH = new AccessHelp();
var dt = AH.GetDT(sql);
if (dt != null && dt.Rows.Count > 0)
{
MessageBox.Show("该用户名已被注册！");
}
else
{
var sql2 = "insert into [user]([Yhm],[Pwd]) values('" + yhm + "','" + pwd + "') ";
AccessHelp AH2 = new AccessHelp();
AH2.RunSql(sql2);
MessageBox.Show("注册成功！");
}
}
else
{
MessageBox.Show("密码错误。");
}
}
private void button4_Click(object sender, EventArgs e)
{
var name = textBox1.Text;
var gender = textBox2.Text;
var birth = textBox3.Text;
var father = textBox4.Text;
var peiou = textBox5.Text;
var sql = "select * from [Member] where 姓名 = '" + name + "'and 性别 = '" + gender + "'and 生日 = '" + birth + "'";
AccessHelp AH = new AccessHelp();
var dt = AH.GetDT(sql);
if (dt != null && dt.Rows.Count > 0)
{
var sql2 = "update [Member] set [性别]='" + gender + "',[生日]='" + birth + "',[父亲姓名]='" + father + "',[配偶姓名]='" + peiou + "' " +
"where [姓名]='" + name + "'";
AccessHelp AH2 = new AccessHelp();
AH2.RunSql(sql2);
}
else
{
MessageBox.Show("没有相关成员信息");
}
}
