【人参果】
无
【披荆斩棘】
技术点:
获取dataGridView1的某一条数据。
public string UserName="";
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
string value0 = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[0].Value.ToString();
string value1 = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[1].Value.ToString();//用户名
string value2 = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[2].Value.ToString();
string value3 = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[3].Value.ToString();
UserName = value1;
}
点击下拉菜单时,按照选择条件搜索数据。
private void cmbUserLevel_SelectedIndexChanged(object sender, EventArgs e)
{
string userLevel = cmbUserLevel.SelectedItem.ToString();
Entity.UserInfo UserInfo = new Entity.UserInfo();
UserInfo.Level = userLevel;
Facade.QueryFacade facadeQueryAddUserLevel = new Facade.QueryFacade();
List<Entity.UserInfo> List = new List<Entity.UserInfo>();
List = facadeQueryAddUserLevel.queryAddUserLevel(UserInfo);
dataGridView1.DataSource = List;
}
删除
private void btnDelete_Click(object sender, EventArgs e)
{
Entity.UserInfo UserInfo = new Entity.UserInfo();
UserInfo.UserName = UserName;
Facade.DeleteFacade facadeDeleteUser = new Facade.DeleteFacade();
bool flag = false;
flag = facadeDeleteUser.deleteUser(UserInfo);
if (flag==true)
{
MessageBox.Show("删除成功!");
}
else
{
MessageBox.Show("删除失败!");
}
}
添加用户
private void btnConfirm_Click(object sender, EventArgs e)
{
if (txtUserName.Text==""||txtPassword.Text==""||txtConfirmPassword.Text==""||cmbUserLevel.Text=="")
{
MessageBox.Show("请完善用户信息!");
return;
}
if (txtPassword.Text!=txtConfirmPassword.Text)
{
MessageBox.Show("密码请重新输入!");
return;
}
#region 查询用户看看存不存在
Entity.UserInfo UserInfo = new Entity.UserInfo();
UserInfo.UserName = txtUserName.Text.Trim();
Facade.QueryFacade facadeQueryAddUser = new Facade.QueryFacade();
bool flag = facadeQueryAddUser.queryAddUser(UserInfo);
if (flag ==true )
{
MessageBox.Show("该用户存在!");
}
else
{
#region 添加新用户
UserInfo.PassWord = txtPassword.Text.Trim();
UserInfo.Level = cmbUserLevel.Text.Trim();
Facade.AddFacade facadeInsertUserInfo = new Facade.AddFacade();
facadeInsertUserInfo.insertUserInfo(UserInfo);
#endregion
}
#endregion
}
【筋斗云】