private void treeRoles_AfterSelect(object sender, TreeViewEventArgs e) { DDRole role = new DDRole("RoleName", treeRoles.SelectedNode.Text.Trim()); TreeNode tempTreeNode; for (int i = 0; i < treeModules.Nodes[0].Nodes.Count; i++) { tempTreeNode = treeModules.Nodes[0].Nodes[i]; for (int j = 0; j < tempTreeNode.Nodes.Count; j++) { DDModule module = new DDModule("ModuleName", tempTreeNode.Nodes[j].Text.Trim()); Query query = new Query(DDPermission.Schema); query.AddWhere("RoleID", role.RoleID); query.AddWhere("ModuleID", module.ModuleID); DataTable dt = query.ExecuteDataSet().Tables[0]; if (dt.Rows.Count > 0) { tempTreeNode.Nodes[j].Checked = true; } else { tempTreeNode.Nodes[j].Checked = false; } } } }
private void btnAdd_Click(object sender, EventArgs e) { int AmountLimit = 0; try { AmountLimit = Convert.ToInt32(tbxAmountLimit.Text); if (this.tbxRoleName.Text.Trim().Length > 0) { DDRole role = new DDRole(); role.RoleName = this.tbxRoleName.Text.Trim(); role.AmountLimit = AmountLimit; role.Save(); InitRoles(); } else { MessageBox.Show("角色名不能为空!", "提示信息"); } } catch { MessageBox.Show("请输入正确的金额!", "提示信息"); } }
private void btnUpdate_Click(object sender, EventArgs e) { try { DDRole role = new DDRole("RoleName", treeRoles.SelectedNode.Text.Trim()); Query queryDel = new Query(DDPermission.Schema); queryDel.AddWhere("RoleID", role.RoleID); queryDel.QueryType = QueryType.Delete; queryDel.Execute(); TreeNode tempTreeNode; for (int i = 0; i < treeModules.Nodes[0].Nodes.Count; i++) { tempTreeNode = treeModules.Nodes[0].Nodes[i]; for (int j = 0; j < tempTreeNode.Nodes.Count; j++) { if (tempTreeNode.Nodes[j].Checked == true) { DDModule module = new DDModule("ModuleName", tempTreeNode.Nodes[j].Text.Trim()); DDPermission permission = new DDPermission(); permission.RoleID = role.RoleID; permission.ModuleID = module.ModuleID; permission.Save(); } } } MessageBox.Show("更新成功!", "提示信息"); } catch { MessageBox.Show("更新失败,请检查数据库是否连接正确!", "提示信息"); } }
public void Insert(string RoleName) { DDRole item = new DDRole(); item.RoleName = RoleName; item.Save(UserName); }
public void Update(int RoleID, string RoleName) { DDRole item = new DDRole(); item.MarkOld(); item.IsLoaded = true; item.RoleID = RoleID; item.RoleName = RoleName; item.Save(UserName); }
private void btnAdd_Click(object sender, EventArgs e) { if (this.tbxRoleName.Text.Trim().Length > 0) { DDRole role = new DDRole(); role.RoleName = this.tbxRoleName.Text.Trim(); role.Save(); InitRoles(); } else { MessageBox.Show("角色名不能为空!", "提示信息"); } }
private void btnUpdate_Click(object sender, EventArgs e) { if (treeRoles.SelectedNode != null) { this.RoleNameRecord = treeRoles.SelectedNode.Text.Trim(); } try { int AmountLimit = Convert.ToInt32(tbxAmountLimit.Text); DDRole role = new DDRole("RoleName", RoleNameRecord); role.AmountLimit = AmountLimit; role.RoleName = tbxRoleName.Text; role.Save(); Query queryDel = new Query(DDPermission.Schema); queryDel.AddWhere("RoleID", role.RoleID); queryDel.QueryType = QueryType.Delete; queryDel.Execute(); TreeNode tempTreeNode; for (int i = 0; i < treeModules.Nodes[0].Nodes.Count; i++) { tempTreeNode = treeModules.Nodes[0].Nodes[i]; for (int j = 0; j < tempTreeNode.Nodes.Count; j++) { if (tempTreeNode.Nodes[j].Checked == true) { DDModule module = new DDModule("ModuleName", tempTreeNode.Nodes[j].Text.Trim()); DDPermission permission = new DDPermission(); permission.RoleID = role.RoleID; permission.ModuleID = module.ModuleID; permission.Save(); } } } MessageBox.Show("更新成功!", "提示信息"); } catch { MessageBox.Show("更新失败,请检查资金限额和数据库连接!", "提示信息"); } InitRoles(); }
private void btnDelete_Click(object sender, EventArgs e) { try { DDRole role = new DDRole("RoleName", treeRoles.SelectedNode.Text); Query queryPermission = new Query(DDPermission.Schema); queryPermission.AddWhere("RoleID", role.RoleID); queryPermission.QueryType = QueryType.Delete; queryPermission.Execute(); Query queryRole = new Query(DDRole.Schema); queryRole.AddWhere("RoleName", treeRoles.SelectedNode.Text); queryRole.QueryType = QueryType.Delete; queryRole.Execute(); InitRoles(); } catch { MessageBox.Show("请选择需要删除的角色!", "提示信息"); } }
public bool Destroy(object RoleID) { return(DDRole.Destroy(RoleID) == 1); }
public bool Delete(object RoleID) { return(DDRole.Delete(RoleID) == 1); }