/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.managers.manager_role model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into " + databaseprefix + "manager_role("); strSql.Append("role_name,role_type,is_sys)"); strSql.Append(" values ("); strSql.Append("@role_name,@role_type,@is_sys)"); strSql.Append(";set @ReturnValue= @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@role_name", SqlDbType.NVarChar, 100), new SqlParameter("@role_type", SqlDbType.TinyInt, 1), new SqlParameter("@is_sys", SqlDbType.TinyInt, 1), new SqlParameter("@ReturnValue", SqlDbType.Int) }; parameters[0].Value = model.role_name; parameters[1].Value = model.role_type; parameters[2].Value = model.is_sys; parameters[3].Direction = ParameterDirection.Output; List <CommandInfo> sqllist = new List <CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); StringBuilder strSql2; if (model.manager_role_values != null) { foreach (Model.managers.manager_role_value modelt in model.manager_role_values) { strSql2 = new StringBuilder(); strSql2.Append("insert into " + databaseprefix + "manager_role_value("); strSql2.Append("role_id,nav_name,action_type)"); strSql2.Append(" values ("); strSql2.Append("@role_id,@nav_name,@action_type)"); SqlParameter[] parameters2 = { new SqlParameter("@role_id", SqlDbType.Int, 4), new SqlParameter("@nav_name", SqlDbType.NVarChar, 100), new SqlParameter("@action_type", SqlDbType.NVarChar, 50) }; parameters2[0].Direction = ParameterDirection.InputOutput; parameters2[1].Value = modelt.nav_name; parameters2[2].Value = modelt.action_type; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); } } DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist); return((int)parameters[3].Value); }
/// <summary> /// 检查是否有权限 /// </summary> public bool Exists(int role_id, string nav_name, string action_type) { Model.managers.manager_role model = dal.GetModel(role_id); if (model != null) { if (model.role_type == 1) { return(true); } Model.managers.manager_role_value modelt = model.manager_role_values.Find(p => p.nav_name == nav_name && p.action_type == action_type); if (modelt != null) { return(true); } } return(false); }
private void ShowInfo(int _id) { BLL.managers.manager_role bll = new BLL.managers.manager_role(); Model.managers.manager_role model = bll.GetModel(_id); txtRoleName.Text = model.role_name; ddlRoleType.SelectedValue = model.role_type.ToString(); //管理权限 if (model.manager_role_values != null) { for (int i = 0; i < rptList.Items.Count; i++) { string navName = ((HiddenField)rptList.Items[i].FindControl("hidName")).Value; CheckBoxList cblActionType = (CheckBoxList)rptList.Items[i].FindControl("cblActionType"); for (int n = 0; n < cblActionType.Items.Count; n++) { Model.managers.manager_role_value modelt = model.manager_role_values.Find(p => p.nav_name == navName && p.action_type == cblActionType.Items[n].Value); if (modelt != null) { cblActionType.Items[n].Selected = true; } } } } }
private bool DoEdit(int _id) { bool result = false; BLL.managers.manager_role bll = new BLL.managers.manager_role(); Model.managers.manager_role model = bll.GetModel(_id); model.role_name = txtRoleName.Text.Trim(); model.role_type = int.Parse(ddlRoleType.SelectedValue); //管理权限 List <Model.managers.manager_role_value> ls = new List <Model.managers.manager_role_value>(); for (int i = 0; i < rptList.Items.Count; i++) { string navName = ((HiddenField)rptList.Items[i].FindControl("hidName")).Value; CheckBoxList cblActionType = (CheckBoxList)rptList.Items[i].FindControl("cblActionType"); for (int n = 0; n < cblActionType.Items.Count; n++) { if (cblActionType.Items[n].Selected == true) { ls.Add(new Model.managers.manager_role_value { role_id = _id, nav_name = navName, action_type = cblActionType.Items[n].Value }); } } } model.manager_role_values = ls; if (bll.Update(model)) { AddAdminLog(OSEnums.ActionEnum.Edit.ToString(), "修改管理角色:" + model.role_name); //记录日志 result = true; } return(result); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.managers.manager_role GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,role_name,role_type,is_sys from " + databaseprefix + "manager_role "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Model.managers.manager_role model = new Model.managers.manager_role(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { #region 父表信息 if (ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } model.role_name = ds.Tables[0].Rows[0]["role_name"].ToString(); if (ds.Tables[0].Rows[0]["role_type"].ToString() != "") { model.role_type = int.Parse(ds.Tables[0].Rows[0]["role_type"].ToString()); } if (ds.Tables[0].Rows[0]["is_sys"].ToString() != "") { model.is_sys = int.Parse(ds.Tables[0].Rows[0]["is_sys"].ToString()); } #endregion #region 子表信息 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("select id,role_id,nav_name,action_type from " + databaseprefix + "manager_role_value "); strSql2.Append(" where role_id=@role_id"); SqlParameter[] parameters2 = { new SqlParameter("@role_id", SqlDbType.Int, 4) }; parameters2[0].Value = id; DataSet ds2 = DbHelperSQL.Query(strSql2.ToString(), parameters2); if (ds2.Tables[0].Rows.Count > 0) { List <Model.managers.manager_role_value> models = new List <Model.managers.manager_role_value>(); Model.managers.manager_role_value modelt; foreach (DataRow dr in ds2.Tables[0].Rows) { modelt = new Model.managers.manager_role_value(); if (dr["id"].ToString() != "") { modelt.id = int.Parse(dr["id"].ToString()); } if (dr["role_id"].ToString() != "") { modelt.role_id = int.Parse(dr["role_id"].ToString()); } modelt.nav_name = dr["nav_name"].ToString(); modelt.action_type = dr["action_type"].ToString(); models.Add(modelt); } model.manager_role_values = models; } #endregion return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.managers.manager_role model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update " + databaseprefix + "manager_role set "); strSql.Append("role_name=@role_name,"); strSql.Append("role_type=@role_type,"); strSql.Append("is_sys=@is_sys"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@role_name", SqlDbType.NVarChar, 100), new SqlParameter("@role_type", SqlDbType.TinyInt, 1), new SqlParameter("@is_sys", SqlDbType.TinyInt, 1), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.role_name; parameters[1].Value = model.role_type; parameters[2].Value = model.is_sys; parameters[3].Value = model.id; List <CommandInfo> sqllist = new List <CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); //先删除该角色所有权限 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("delete from " + databaseprefix + "manager_role_value where role_id=@role_id "); SqlParameter[] parameters2 = { new SqlParameter("@role_id", SqlDbType.Int, 4) }; parameters2[0].Value = model.id; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); //添加权限 if (model.manager_role_values != null) { StringBuilder strSql3; foreach (Model.managers.manager_role_value modelt in model.manager_role_values) { strSql3 = new StringBuilder(); strSql3.Append("insert into " + databaseprefix + "manager_role_value("); strSql3.Append("role_id,nav_name,action_type)"); strSql3.Append(" values ("); strSql3.Append("@role_id,@nav_name,@action_type)"); SqlParameter[] parameters3 = { new SqlParameter("@role_id", SqlDbType.Int, 4), new SqlParameter("@nav_name", SqlDbType.NVarChar, 100), new SqlParameter("@action_type", SqlDbType.NVarChar, 50) }; parameters3[0].Value = model.id; parameters3[1].Value = modelt.nav_name; parameters3[2].Value = modelt.action_type; cmd = new CommandInfo(strSql3.ToString(), parameters3); sqllist.Add(cmd); } } int rowsAffected = DbHelperSQL.ExecuteSqlTran(sqllist); if (rowsAffected > 0) { return(true); } else { return(false); } }
private bool DoAdd() { bool result = false; Model.managers.manager_role model = new Model.managers.manager_role(); BLL.managers.manager_role bll = new BLL.managers.manager_role(); model.role_name = txtRoleName.Text.Trim(); model.role_type = int.Parse(ddlRoleType.SelectedValue); //管理权限 List<Model.managers.manager_role_value> ls = new List<Model.managers.manager_role_value>(); for (int i = 0; i < rptList.Items.Count; i++) { string navName = ((HiddenField)rptList.Items[i].FindControl("hidName")).Value; CheckBoxList cblActionType = (CheckBoxList)rptList.Items[i].FindControl("cblActionType"); for (int n = 0; n < cblActionType.Items.Count; n++) { if (cblActionType.Items[n].Selected == true) { ls.Add(new Model.managers.manager_role_value { nav_name = navName, action_type = cblActionType.Items[n].Value }); } } } model.manager_role_values = ls; if (bll.Add(model) > 0) { AddAdminLog(OSEnums.ActionEnum.Add.ToString(), "添加管理角色:" + model.role_name); //记录日志 result = true; } return result; }
/// <summary> /// �õ�һ������ʵ�� /// </summary> public Model.managers.manager_role GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,role_name,role_type,is_sys from " + databaseprefix + "manager_role "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = id; Model.managers.manager_role model = new Model.managers.manager_role(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { #region ������Ϣ if (ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } model.role_name = ds.Tables[0].Rows[0]["role_name"].ToString(); if (ds.Tables[0].Rows[0]["role_type"].ToString() != "") { model.role_type = int.Parse(ds.Tables[0].Rows[0]["role_type"].ToString()); } if (ds.Tables[0].Rows[0]["is_sys"].ToString() != "") { model.is_sys = int.Parse(ds.Tables[0].Rows[0]["is_sys"].ToString()); } #endregion #region �ӱ���Ϣ StringBuilder strSql2 = new StringBuilder(); strSql2.Append("select id,role_id,nav_name,action_type from " + databaseprefix + "manager_role_value "); strSql2.Append(" where role_id=@role_id"); SqlParameter[] parameters2 = { new SqlParameter("@role_id", SqlDbType.Int,4)}; parameters2[0].Value = id; DataSet ds2 = DbHelperSQL.Query(strSql2.ToString(), parameters2); if (ds2.Tables[0].Rows.Count > 0) { List<Model.managers.manager_role_value> models = new List<Model.managers.manager_role_value>(); Model.managers.manager_role_value modelt; foreach (DataRow dr in ds2.Tables[0].Rows) { modelt = new Model.managers.manager_role_value(); if (dr["id"].ToString() != "") { modelt.id = int.Parse(dr["id"].ToString()); } if (dr["role_id"].ToString() != "") { modelt.role_id = int.Parse(dr["role_id"].ToString()); } modelt.nav_name = dr["nav_name"].ToString(); modelt.action_type = dr["action_type"].ToString(); models.Add(modelt); } model.manager_role_values = models; } #endregion return model; } else { return null; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.managers.manager_role model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.managers.manager_role model) { return(dal.Add(model)); }