private void Button3_Click(object sender, EventArgs e)
{
if (txtZHnew.Text.Trim() == "")
{
MessageBox.Show("请输入账号！");
txtZHnew.Focus();
return;
}
else if (txtPwd.Text.Trim() == "")
{
MessageBox.Show("请输入密码！");
txtPwd.Focus();
return;
}
AdministratorTable at = new AdministratorTable()
{
AdministratorName = txtZHnew.Text.Trim(),
Password = int.Parse(txtPwd.Text.Trim()),
Jurisdiction = int.Parse(cbQuan.Text.Trim())
};
if (am.AdminisreInsert(at) > 0)
{
MessageBox.Show("操作成功");
dgvAdministr.DataSource = am.AdministrTable(txtZH.Text.Trim());
groupBox3.Visible = false;
}
else
{
MessageBox.Show("操作失败");
}
}
/// <summary>
/// 新增
/// </summary>
/// <param name="at"></param>
/// <returns></returns>
public int AdminisreInsert(AdministratorTable at)
{
StringBuilder sql = new StringBuilder("INSERT INTO [AdministratorTable]([password],[AdministratorName],[jurisdiction])VALUES(@password,@AdministratorName,@jurisdiction)");
SqlParameter[] sp =
{
new SqlParameter("@password", at.Password),
new SqlParameter("@AdministratorName", at.AdministratorName),
new SqlParameter("@jurisdiction", at.Jurisdiction)
};
return(db.ExecuteNonQuery(sql.ToString(), sp));
}
/// <summary>
/// 新增
/// </summary>
/// <param name="at"></param>
/// <returns></returns>
public int AdminisreInsert(AdministratorTable at)
{
return(ams.AdminisreInsert(at));
}
