private void ModifyUser_Click() { try { Expression <Func <RoleInfo, bool> > p = n => n.Role_Id == Convert.ToInt32(lblId.Text); Action <RoleInfo> ap = n => { n.Role_Name = txtRoleName.Text.Trim(); n.Role_State = comboxState.Text.Trim(); n.Role_Remark = txtRemark.Text.Trim(); }; if (!RoleInfoAdd.UpdateOneRoleInfo(p, ap))//用户是否修改失败 { MessageBox.Show(" 修改失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("修改成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); string Log_Content = String.Format("用户名称:{0} ", lblId.Text.Trim()); CommonalityEntity.WriteLogData("修改", "修改" + Log_Content + "的信息", CommonalityEntity.USERNAME); } } catch { CommonalityEntity.WriteTextLog("用户管理 bntUpUser_Click()"); } finally { page = new PageControl(); LoadData(); userContext(); } }
/// <summary> /// 修改事件 /// </summary> private void btnUpdate_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtRoleName.Text)) { MessageBox.Show(this, "角色名称不能为空!"); return; } if (comboxState.SelectedIndex < 0) { MessageBox.Show(this, "请选择状态!"); return; } string name = txtRoleName.Text; //姓名 string remark = txtRemark.Text; //备注 string state = comboxState.SelectedItem.ToString(); //状态 string id = lblId.Text; //id int j = 0; Action <RoleInfo> action = n => { n.Role_Name = name; n.Role_Remark = remark; n.Role_State = state; n.Role_Permission = ""; }; try { Expression <Func <RoleInfo, bool> > funroleinfo = n => n.Role_Id.ToString() == id; if (!RoleInfoAdd.UpdateOneRoleInfo(funroleinfo, action))//角色是否修改失败 { j++; } if (j == 0) { MessageBox.Show("修改成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); string Log_Content = String.Format("角色名称:{0}", name); CommonalityEntity.WriteLogData("修改", "修改" + Log_Content + "的信息", CommonalityEntity.USERNAME); } else { MessageBox.Show(" 修改失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch { CommonalityEntity.WriteTextLog("角色管理 btnUpdate_Click"); } finally { page = new PageControl(); LoadData(); userContext(); lblId.Text = ""; txtRemark.Text = ""; txtRoleName.Text = ""; comboxState.Text = ""; } }
/// <summary> ///删除用户信息 /// </summary> private void tbtnDelUser_delete() { try { int j = 0; UserIDSearch = lvwUserList.SelectedRows.Count; if (UserIDSearch > 0)//选中删除 { if (MessageBox.Show("确定要删除吗?", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { //选中数量 //遍历 for (int i = 0; i < UserIDSearch; i++) { Expression <Func <RoleInfo, bool> > funuserinfo = n => n.Role_Id == Convert.ToInt32(lvwUserList.SelectedRows[i].Cells["Role_Id"].Value);; if (!RoleInfoAdd.DeleteToMany(funuserinfo)) { j++; } else { CommonalityEntity.WriteLogData("删除", "删除角色名称为:" + lvwUserList.SelectedRows[i].Cells["Role_Name"].Value + "的信息", CommonalityEntity.USERNAME); } } if (j == 0) { MessageBox.Show("成功删除", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("删除失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } else//没有选中 { MessageBox.Show("请选择要删除的行!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch { CommonalityEntity.WriteTextLog("用户管理 tbtnDelUser_delete()+"); } finally { page = new PageControl(); //page.PageMaxCount = tscbxPageSize2.SelectedItem.ToString(); LoadData();//更新 } }
private void lvwUserList_MouseDoubleClick(object sender, MouseEventArgs e) { label3.Visible = false; btnAdd.Visible = false; btnUpdate.Enabled = true; if (this.lvwUserList.SelectedRows.Count > 0)//选中行 { if (lvwUserList.SelectedRows.Count > 1) { MessageBox.Show("修改只能选中一行!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { //修改的值 int ID = int.Parse(this.lvwUserList.SelectedRows[0].Cells["Role_Id"].Value.ToString()); Expression <Func <RoleInfo, bool> > funviewinto = n => n.Role_Id == ID; foreach (var n in RoleInfoAdd.Query(funviewinto)) { if (n.Role_Id != 0) { this.lblId.Text = n.Role_Id.ToString(); } if (n.Role_Name != null) { // IC卡类型状态 this.txtRoleName.Text = n.Role_Name; } if (n.Role_State != null) { // IC卡类型权限 this.comboxState.Text = n.Role_State; } if (n.Role_Remark != null) { // IC卡类型描述 this.txtRemark.Text = n.Role_Remark; } break; } } } else { MessageBox.Show("请选择要修改的行!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
/// <summary> /// 添加事件 /// </summary> private void btnAdd_Click(object sender, EventArgs e) { #region --验证用户名是否重复-- DataTable table = LinQBaseDao.Query(" SELECT * FROM [RoleInfo] where Role_Name='" + txtRoleName.Text.Trim() + "'").Tables[0]; if (table.Rows.Count > 0) { MessageBox.Show("角色名称已存在!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (comboxState.SelectedItem == null) { MessageBox.Show("请选择状态!"); return; } #endregion int j = 0; int rint = 0; if (string.IsNullOrEmpty(txtRoleName.Text)) { MessageBox.Show(this, "角色名称不能为空!"); return; } if (comboxState.SelectedIndex < 0) { MessageBox.Show(this, "请选择状态!"); return; } string name = txtRoleName.Text; //角色名 string remark = txtRemark.Text; //备注 try { if (!btnCheck()) { return; } var rf = new RoleInfo { Role_Name = name, Role_Remark = remark, Role_State = comboxState.SelectedItem.ToString(), Role_Permission = "" }; if (!RoleInfoAdd.InsertOneRoleInfo(rf, out rint)) { j++; } if (j == 0) { MessageBox.Show("成功增加", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); string Log_Content = String.Format("角色名称:{0}", name); CommonalityEntity.WriteLogData("新增", "新增" + Log_Content + "的信息", CommonalityEntity.USERNAME); } else { MessageBox.Show("成功失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch { CommonalityEntity.WriteTextLog("角色管理 btnAdd_Click()"); } finally { page = new PageControl(); LoadData();//更新数据 } }