C#权限设计代码
来源:互联网 发布:迈腾轮毂尺寸数据 编辑:程序博客网 时间:2024/06/16 03:22
新增栏目;using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using Model;using DAL.Main;public partial class Main_AddProjectModel : System.Web.UI.Page{ DAL.Main.ProjectModel MPModel = new DAL.Main.ProjectModel(); //声明数据层对象 protected void Page_Load(object sender, EventArgs e) { if(!IsPostBack) { BindDDl(); } } /// <summary> /// 绑定父级栏目 /// </summary> public void BindDDl() { ddlModelList.DataSource = MPModel.GetProjectModel("0"); ddlModelList.DataTextField = "ModelName"; ddlModelList.DataValueField = "ModelId"; ddlModelList.DataBind(); } protected void btn_Add_Model_Click(object sender, EventArgs e) { Model.ProjectModel model = new Model.ProjectModel(); model.ModelName = txtModelName.Text.ToString(); model.ModelUrl = txtUrl.Text.ToString(); model.IsFoot = Convert.ToBoolean(int.Parse(ROrNO.SelectedValue.ToString())); if (CheckBox1.Checked) { model.HightModelID = int.Parse(ddlModelList.SelectedValue.ToString()); } else { model.HightModelID = int.Parse("0"); } if (MPModel.InsertProjectModel(model)!=0) { RegisterClientScriptBlock("","<script>alert('success!');</script>"); } } protected void CheckBox1_CheckedChanged(object sender, EventArgs e) { if (CheckBox1.Checked) { lblIsModel.Visible = false; ddlModelList.Visible = true; } else { lblIsModel.Visible = true; ddlModelList.Visible = false; } }}数据 /// <summary> /// 得到所有模块详细信息 /// </summary> /// <returns></returns> public IList<Model.ProjectModel> GetProjectModel(string hightId) { IList<Model.ProjectModel> GetPModel = new List<Model.ProjectModel>(); string SQL_GetProject=""; if (hightId != null) { SQL_GetProject = "select * from project_model where HightModelId=" + Convert.ToInt32(hightId); } Model.ProjectModel Projects = null; using (SqlDataReader rdr = SQLHelper.ExecuteReader(SQLHelper.SQLConnString, CommandType.Text, SQL_GetProject, null)) { while (rdr.Read()) { Projects = new Model.ProjectModel(); Projects.ModelName = rdr["ModelName"].ToString(); Projects.ModelId = int.Parse(rdr["ModelId"].ToString()); Projects.ModelUrl = rdr["ModelUrl"].ToString(); Projects.IsFoot = Convert.ToBoolean( rdr["IsFoot"].ToString()); Projects.HightModelID = int.Parse(rdr["HightModelID"].ToString()); GetPModel.Add(Projects); } return GetPModel; } } /// <summary> /// 添加栏目 /// </summary> /// <param name="PJModel"></param> /// <returns></returns> public int InsertProjectModel(Model.ProjectModel PJModel) { SqlParameter[] parm ={ new SqlParameter("@ModelName",PJModel.ModelName), new SqlParameter("@HightModelID",PJModel.HightModelID), new SqlParameter("@IsFoot",PJModel.IsFoot), new SqlParameter("@ModelUrl",PJModel.ModelUrl) }; string INSERT_PROJECTMODEL = "insert project_model values(@ModelName,@HightModelID,@IsFoot,@ModelUrl)"; using (SqlConnection conn = new SqlConnection(SQLHelper.SQLConnString)) { return SQLHelper.ExecuteNonQuery(conn, CommandType.Text, INSERT_PROJECTMODEL, parm); } }角色using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using DAL;using System.Collections.Generic;using DAL.SysUser;using DAL.Main;public partial class Main_AddRole : System.Web.UI.Page{ DicDepartment DDept = new DicDepartment(); ProjectModel PMain = new ProjectModel(); SysRole role = new SysRole(); protected void Page_Load(object sender, EventArgs e) { if(!IsPostBack) { Bind(); IList<Model.ProjectModel> DicDModel = PMain.GetProjectModel("0"); for (int i = 0; i < DicDModel.Count; i++) { string dicName=DicDModel[i].ModelName.ToString(); string dicId=DicDModel[i].ModelId.ToString(); TreeNode treefather = CreateTreeNode(dicName, dicId); CreateChileNode(dicId, treefather); TreeView1.Nodes.Add(treefather); TreeView1.Attributes.Add("onclick", "postBackByObject()"); } } } /// <summary> /// 得到选择的值 /// </summary> /// <param name="tc"></param> public void getnode(TreeNodeCollection tc) { foreach (TreeNode tnode in tc) { if (tnode.Checked) { //Response.Write(tnode.Value + "<br/>"); string txt = txtName.Text.ToString(); string x = tnode.Value.ToString(); role.InsertSysRole(txt, x); } getnode(tnode.ChildNodes); } } public TreeNode CreateTreeNode(string NodeName,string NodeValue) { TreeNode treenode = new TreeNode(); treenode.Text = NodeName; treenode.Value = NodeValue; return treenode; } /// <summary> /// 得到父节点下的子节点 /// </summary> /// <param name="NodeId"></param> /// <param name="TreeFather"></param> /// <returns></returns> public void CreateChileNode(string NodeId, TreeNode TreeFather) { IList<Model.ProjectModel> DicDModel = PMain.GetProjectModel(""+NodeId+""); for (int i = 0; i < DicDModel.Count; i++) { string dicName = DicDModel[i].ModelName.ToString(); string dicId=DicDModel[i].ModelId.ToString(); TreeNode childNode = CreateTreeNode(dicName, dicId); AddTree(TreeFather, childNode); CreateChileNodes(dicId, childNode);//子级的下一级 } TreeView1.ExpandDepth = 0; } public void CreateChileNodes(string NodeId, TreeNode TreeFather) { IList<Model.ProjectModel> DicDModel = PMain.GetProjectModel("" + NodeId + ""); for (int i = 0; i < DicDModel.Count; i++) { string dicName = DicDModel[i].ModelName.ToString(); string dicId = DicDModel[i].ModelId.ToString(); TreeNode childNode = CreateTreeNode(dicName, dicId); AddTree(TreeFather, childNode); } } /// <summary> /// 将子节点加入父节点 /// </summary> /// <param name="fatherNode"></param> /// <param name="chlidNode"></param> private void AddTree(TreeNode fatherNode,TreeNode chlidNode) { fatherNode.ChildNodes.Add(chlidNode); } public void Bind() { GridView1.DataSource = DDept.GetDept(); GridView1.DataBind(); } //提交 protected void butTH_Click(object sender, EventArgs e) { string DName = txtName.Text.ToString(); string DMode = txtDescript.Text.ToString(); if (DDept.insert(DName, DMode) != 0) { RegisterClientScriptBlock("", "<script>alert('成功!');</script>"); } TreeNodeCollection tc = TreeView1.Nodes; getnode(tc); } protected void TreeView1_TreeNodeCheckChanged(object sender, TreeNodeEventArgs e) { SetChildChecked(e.Node); // 调用 根据父节点状态设置子节点的状态 方法 SetParentChecked(e.Node);//调用 选中子节点,其父节点也选中 方法 } /// <summary> /// 选中子节点,其父节点也选中 /// </summary> /// <param name="childNode"></param> private void SetParentChecked(TreeNode childNode) { if (childNode.Parent != null) { childNode.Parent.Checked = true; SetParentChecked(childNode.Parent); } } /// <summary> /// 根据父节点状态设置子节点的状态 /// </summary> /// <param name="parentNode"></param> private void SetChildChecked(TreeNode parentNode) { foreach (TreeNode node in parentNode.ChildNodes) { node.Checked = parentNode.Checked; if (node.ChildNodes.Count > 0) { SetChildChecked(node); } } }}部门数据 /// <summary> /// 插入部门 /// </summary> /// <returns></returns> public int insert(string DName,string DMemo) { string SQL_INSERT = "insert DicDepartment values('"+DName+"','"+DMemo+"')"; using (SqlConnection conn = new SqlConnection(SQLHelper.SQLConnString)) { return SQLHelper.ExecuteNonQuery(conn, CommandType.Text, SQL_INSERT, null); //执行插入 } } /// <summary> /// 得到所有部门 /// </summary> /// <returns></returns> public DataTable GetDept() { string SQL_SELECT = "select * from DicDepartment"; return SQLHelper.ExecuteReaderDataSet(SQLHelper.SQLConnString, CommandType.Text, SQL_SELECT, null); } 栏目数据 /// <summary> /// 得到所有模块详细信息 /// </summary> /// <returns></returns> public IList<Model.ProjectModel> GetProjectModel(string hightId) { IList<Model.ProjectModel> GetPModel = new List<Model.ProjectModel>(); string SQL_GetProject=""; if (hightId != null) { SQL_GetProject = "select * from project_model where HightModelId=" + Convert.ToInt32(hightId); } Model.ProjectModel Projects = null; using (SqlDataReader rdr = SQLHelper.ExecuteReader(SQLHelper.SQLConnString, CommandType.Text, SQL_GetProject, null)) { while (rdr.Read()) { Projects = new Model.ProjectModel(); Projects.ModelName = rdr["ModelName"].ToString(); Projects.ModelId = int.Parse(rdr["ModelId"].ToString()); Projects.ModelUrl = rdr["ModelUrl"].ToString(); Projects.IsFoot = Convert.ToBoolean( rdr["IsFoot"].ToString()); Projects.HightModelID = int.Parse(rdr["HightModelID"].ToString()); GetPModel.Add(Projects); } return GetPModel; } }角色数据 /// <summary> /// 插入角色的权限 /// </summary> /// <param name="model"></param> /// <returns></returns> public int InsertSysRole(string name,string url) { string INSERT_SYSROLE = "insert SysRole values('"+name+"','"+url+"')"; using (SqlConnection conn = new SqlConnection(SQLHelper.SQLConnString)) { return SQLHelper.ExecuteNonQuery(conn, CommandType.Text, INSERT_SYSROLE, null); } }人员录入using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using DAL.SysUser;using Model;using BLL;public partial class Main_MemberAdd : System.Web.UI.Page{ DicDepartment DicDept = new DicDepartment(); SysUserModel user = new SysUserModel(); SysUserBLL sysUserBLL = new SysUserBLL(); protected void Page_Load(object sender, EventArgs e) { if(!IsPostBack) { bin(); BindDDl(); } } public void bin() { GridView1.DataSource = sysUserBLL.GetSysUser(); GridView1.DataBind(); } /// <summary> /// 绑定部门 /// </summary> public void BindDDl() { ddldept.DataSource = DicDept.GetDept(); ddldept.DataTextField = "SysDeptName"; ddldept.DataValueField = "SysDept"; ddldept.DataBind(); } protected void butTH_Click(object sender, EventArgs e) { string sysuser = txtName.Text.ToString(); int dept = int.Parse(ddldept.SelectedValue.ToString()); string pwd = txtPwd.Text.ToString(); pwd = FormsAuthentication.HashPasswordForStoringInConfigFile(pwd, "md5"); user.RealName = sysuser; user.SysUserPwd = pwd; user.DepId = dept; bool sysUser = sysUserBLL.insert(user); if (sysUser = true) { this.Page.RegisterStartupScript("", "<script>alert('成功!');</script>"); Response.Redirect("RoleManager.aspx"); } }}人员数据 /// <summary> /// 注册新用户 /// </summary> /// <param name="realName">用户名</param> /// <param name="sysUserPwd">密码</param> /// <param name="depId">部门</param> /// <returns></returns> public int insert(SysUserModel user) { //对应相应的参数 SqlParameter[] parm ={ new SqlParameter("@realName",user.RealName), new SqlParameter("@sysUserPwd",user.SysUserPwd), new SqlParameter("@depId",Convert.ToInt32( user.DepId)), new SqlParameter("@sex",Convert.ToInt32( user.Sex)) }; //插入user表的sql语句 string sql_INSERT = "insert into SysUser(realName,sysUserPwd,depId,sex) values (@realName,@sysUserPwd,@depId,@sex)"; using (SqlConnection conn = new SqlConnection(SQLHelper.SQLConnString)) { return SQLHelper.ExecuteNonQuery(conn, CommandType.Text, sql_INSERT, parm); //执行插入 } } /// <summary> /// 得到所有用户 /// </summary> /// <param name="userCode"></param> /// <returns></returns> public IList<SysUserModel> GetSysUser() { IList<SysUserModel> GetSysUser = new List<SysUserModel>(); string SQL_GetSysUsers = "select sysuser.*,DicDepartment.sysDeptName from sysuser left join DicDepartment on SysUser.depId=DicDepartment.sysDept"; SysUserModel Sysuser = null; using (SqlDataReader rdr = SQLHelper.ExecuteReader(SQLHelper.SQLConnString, CommandType.Text, SQL_GetSysUsers, null)) { while (rdr.Read()) { Sysuser = new SysUserModel(); Sysuser.RealName = rdr["RealName"].ToString(); Sysuser.SysUserId = int.Parse(rdr["sysUserId"].ToString()); Sysuser.SysUserPwd = rdr["SysUserPwd"].ToString(); Sysuser.DepId = int.Parse(rdr["DepId"].ToString()); Sysuser.Sex = int.Parse(rdr["Sex"].ToString()); DicDepartmentModel de = new DicDepartmentModel(); de.SysDeptName = rdr["SysDeptName"].ToString(); Sysuser.Dep = de; GetSysUser.Add(Sysuser); } return GetSysUser; } }部门数据 /// <summary> /// 得到所有部门 /// </summary> /// <returns></returns> public DataTable GetDept() { string SQL_SELECT = "select * from DicDepartment"; return SQLHelper.ExecuteReaderDataSet(SQLHelper.SQLConnString, CommandType.Text, SQL_SELECT, null); }
- C#权限设计代码
- C# asp.net MVC4 权限设计
- 权限表设计之代码解析
- C#大话设计模式代码
- C#登录窗体代码设计
- java &|~<< 位运算设计权限代码!查询权限、增加权限、删除权限
- C# asp.net MVC 权限设计(续)
- C#使用安全权限验证 ADO.NET 代码访问
- C#设计登录界面及代码
- C#窗体设计《体检套餐》代码
- springrain -权限表结构 分析设计 Jfinal 代码生成器
- 权限设计
- 权限设计
- 权限设计
- 权限设计
- 权限设计
- 权限设计
- 权限设计
- 仿百度,豆瓣读书文库阅读器
- Oracle APEX 3.2 安装
- Linux定时删除过期文件
- 英译汉小词典
- python命令行参数
- C#权限设计代码
- Oracle APEX系列(一) 安装
- 在Red Hat Linux 5.1.19.6上安装Oracle10.2.0.1
- 第十六周实验报告1
- 国内首个HTML5应用开发平台AppCan开启限量内测
- XP系统中如何查哪些网址曾经远程连接过本机器。
- bootstrap 与 rails 2.3.8整合之:will_paginate插件的使用
- 转帖 3DEX加密
- 国内外著名开源b2c电子商务系统比较包括asp.net和php