/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.Sys_RoleInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Sys_RoleInfo("); strSql.Append("RoleName,RoleDesc,WriteRight,AddTime,AddUser)"); strSql.Append(" values ("); strSql.Append("@RoleName,@RoleDesc,@WriteRight,@AddTime,@AddUser)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@RoleName", SqlDbType.NVarChar, 50), new SqlParameter("@RoleDesc", SqlDbType.NVarChar, 200), new SqlParameter("@WriteRight", SqlDbType.NVarChar, 250), new SqlParameter("@AddTime", SqlDbType.DateTime), new SqlParameter("@AddUser", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.RoleName; parameters[1].Value = model.RoleDesc; parameters[2].Value = model.WriteRight; parameters[3].Value = model.AddTime; parameters[4].Value = model.AddUser; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
protected void btnSave_Click(object sender, EventArgs e) { string strWhere = " RoleName='" + txtRoleName.Text + "'"; string adduser = Session["uLoginName"].ToString(); int roleId = 0; DataSet ds = bll_ri.GetRoleList(strWhere, roleId); if (ds.Tables[0].Rows.Count > 0) { lblMsg.InnerHtml = "<script type='text/javascript'>alert('该角色名称已经存在!');</script>"; } else { Model.Sys_RoleInfo model_ri = new Model.Sys_RoleInfo(); model_ri.RoleName = txtRoleName.Text; model_ri.RoleDesc = getCheckBoxListValue(); model_ri.WriteRight = "1"; model_ri.AddTime = DateTime.Now; model_ri.AddUser = adduser; if (bll_ri.AddNewRole(model_ri) > 0) { lblMsg.InnerHtml = "<script type='text/javascript'>alert('添加成功!');window.location='Manage_Role.aspx'</script>"; } } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.Sys_RoleInfo DataRowToModel(DataRow row) { Model.Sys_RoleInfo model = new Model.Sys_RoleInfo(); if (row != null) { if (row["RoleID"] != null && row["RoleID"].ToString() != "") { model.RoleID = int.Parse(row["RoleID"].ToString()); } if (row["RoleName"] != null) { model.RoleName = row["RoleName"].ToString(); } if (row["RoleDesc"] != null) { model.RoleDesc = row["RoleDesc"].ToString(); } if (row["WriteRight"] != null) { model.WriteRight = row["WriteRight"].ToString(); } if (row["AddTime"] != null && row["AddTime"].ToString() != "") { model.AddTime = DateTime.Parse(row["AddTime"].ToString()); } if (row["AddUser"] != null) { model.AddUser = row["AddUser"].ToString(); } } return(model); }
protected void btnSave_Click(object sender, EventArgs e) { string strWhere = " RoleName='" + txtRoleName.Text + "'"; string adduser = Session["uLoginName"].ToString(); int rid = 0; DataSet ds = bll_ri.GetRoleList(strWhere, rid); if (ds.Tables[0].Rows.Count > 0) { Model.Sys_RoleInfo model_ri = new Model.Sys_RoleInfo(); model_ri.RoleID = int.Parse(Request.QueryString["RoleID"].ToString()); model_ri.RoleName = txtRoleName.Text; model_ri.RoleDesc = getCheckBoxListValue(); if (bll_ri.EditRole(model_ri) > 0) { lblMsg.InnerHtml = "<script type='text/javascript'>alert('修改成功!');window.location='RoleList.aspx'</script>"; } else { lblMsg.InnerHtml = "<script type='text/javascript'>alert('修改失败!');</script>"; } } else { lblMsg.InnerHtml = "<script type='text/javascript'>alert('该角色名称不存在!');</script>"; } }
/// <summary> /// 编辑角色 /// </summary> public int EditRole(Model.Sys_RoleInfo model) { SqlParameter[] parameters = { new SqlParameter("@RoleName", SqlDbType.NVarChar, 50), new SqlParameter("@RoleDesc", SqlDbType.NVarChar, 200), new SqlParameter("@RoleID", SqlDbType.Int, 4) }; parameters[0].Value = model.RoleName; parameters[1].Value = model.RoleDesc; parameters[2].Value = model.RoleID; int result = 0; return(DbHelperSQL.RunProcedure("EditRole", parameters, out result)); }
/// <summary> /// 新增角色 /// </summary> public int AddNewRole(Model.Sys_RoleInfo model) { SqlParameter[] parameters = { new SqlParameter("@RoleName", SqlDbType.NVarChar, 50), new SqlParameter("@RoleDesc", SqlDbType.NVarChar, 200), new SqlParameter("@WriteRight", SqlDbType.NVarChar, 250), new SqlParameter("@AddTime", SqlDbType.DateTime), new SqlParameter("@AddUser", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.RoleName; parameters[1].Value = model.RoleDesc; parameters[2].Value = model.WriteRight; parameters[3].Value = model.AddTime; parameters[4].Value = model.AddUser; int result = 0; return(DbHelperSQL.RunProcedure("AddNewRole", parameters, out result)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.Sys_RoleInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Sys_RoleInfo set "); strSql.Append("RoleName=@RoleName,"); strSql.Append("RoleDesc=@RoleDesc,"); strSql.Append("WriteRight=@WriteRight,"); strSql.Append("AddTime=@AddTime,"); strSql.Append("AddUser=@AddUser"); strSql.Append(" where RoleID=@RoleID"); SqlParameter[] parameters = { new SqlParameter("@RoleName", SqlDbType.NVarChar, 50), new SqlParameter("@RoleDesc", SqlDbType.NVarChar, 200), new SqlParameter("@WriteRight", SqlDbType.NVarChar, 250), new SqlParameter("@AddTime", SqlDbType.DateTime), new SqlParameter("@AddUser", SqlDbType.NVarChar, 50), new SqlParameter("@RoleID", SqlDbType.Int, 4) }; parameters[0].Value = model.RoleName; parameters[1].Value = model.RoleDesc; parameters[2].Value = model.WriteRight; parameters[3].Value = model.AddTime; parameters[4].Value = model.AddUser; parameters[5].Value = model.RoleID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 初始该角色的小类菜单 /// </summary> private void DataBindRole() { if (Request.QueryString["RoleID"].ToString() == null || !Common.PositiveInt.IsPositiveInt(Request.QueryString["RoleID"].ToString())) { return; } int roleID = int.Parse(Request.QueryString["RoleID"]); Model.Sys_RoleInfo model_ri = new Model.Sys_RoleInfo(); model_ri = bll_ri.GetModel(roleID); if (model_ri == null) { return; } this.txtRoleName.Text = model_ri.RoleName; int rid = -1; string strWhere = " RoleID=" + roleID + ""; BLL.Sys_RoleMenuMappingBLL bll_rmm = new BLL.Sys_RoleMenuMappingBLL(); DataSet ds = bll_rmm.GetRoleList(strWhere, rid); if (ds.Tables[0].Rows.Count > 0) { //初始化CheckBoxList选中项 foreach (RepeaterItem DataItem in rpt_RoleList.Items) { foreach (ListItem item in ((CheckBoxList)DataItem.FindControl("cbList")).Items) { DataRow[] dr = ds.Tables[0].Select("MenuID=" + item.Value + ""); if (dr.Length > 0) { item.Selected = true; } } } } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.Sys_RoleInfo GetModel(int RoleID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 RoleID,RoleName,RoleDesc,WriteRight,AddTime,AddUser from Sys_RoleInfo "); strSql.Append(" where RoleID=@RoleID"); SqlParameter[] parameters = { new SqlParameter("@RoleID", SqlDbType.Int, 4) }; parameters[0].Value = RoleID; Model.Sys_RoleInfo model = new Model.Sys_RoleInfo(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }