/// <summary> /// 更新一条数据 /// Author 2015-08-11 /// </summary> public bool Update(object tran, RoleModuleInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update RoleModule set "); strSql.Append("RoleID=@RoleID,"); strSql.Append("ModID=@ModID"); strSql.Append(" where RoleID=@RoleID and ModID=@ModID "); SqlParameter[] parameters = { new SqlParameter("@RoleID", SqlDbType.Int, 4), new SqlParameter("@ModID", SqlDbType.Int, 4) }; parameters[0].Value = model.RoleID; parameters[1].Value = model.ModID; int rows = SQLHelper.ExecuteNonQuery((SqlTransaction)tran, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// Author 2015-08-11 /// </summary> public bool Add(object tran, RoleModuleInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into RoleModule("); strSql.Append("RoleID,ModID"); strSql.Append(") values ("); strSql.Append("@RoleID,@ModID"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@RoleID", SqlDbType.Int, 4), new SqlParameter("@ModID", SqlDbType.Int, 4) }; parameters[0].Value = model.RoleID; parameters[1].Value = model.ModID; int rows = SQLHelper.ExecuteNonQuery((SqlTransaction)tran, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// Author 2015-08-11 /// </summary> public RoleModuleInfo GetModel(object tran, int RoleID, int ModID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select RoleID,ModID "); strSql.Append(" from RoleModule "); strSql.Append(" where RoleID=@RoleID and ModID=@ModID "); SqlParameter[] parameters = { new SqlParameter("@RoleID", SqlDbType.Int, 4), new SqlParameter("@ModID", SqlDbType.Int, 4) }; parameters[0].Value = RoleID; parameters[1].Value = ModID; RoleModuleInfo model = new RoleModuleInfo(); DataSet ds = SQLHelper.GetDataSet((SqlTransaction)tran, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["RoleID"].ToString() != "") { model.RoleID = int.Parse(ds.Tables[0].Rows[0]["RoleID"].ToString()); } if (ds.Tables[0].Rows[0]["ModID"].ToString() != "") { model.ModID = int.Parse(ds.Tables[0].Rows[0]["ModID"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// Author 2015-08-11 /// </summary> public bool Update(object tran, RoleModuleInfo model) { return(dal.Update(tran, model)); }
/// <summary> /// 增加一条数据 /// Author 2015-08-11 /// </summary> public bool Add(object tran, RoleModuleInfo model) { return(dal.Add(tran, model)); }
/// <summary> /// 分配菜单和按钮权限 /// pxd 2015-10-19 /// </summary> /// <param name="roleID"></param> /// <param name="modID"></param> /// <param name="mbID"></param> /// <returns></returns> public string Allot(int roleID, List <int> modID, List <string> mbID) { string strReturn = ""; Transaction transaction = new Transaction(); object tran = transaction.CreatTransaction(); try { //判断存在角色菜单权限则先删除 if (new RoleModule().ExistsByRoleID(tran, roleID)) { if (!new RoleModule().DeleteByRoleID(tran, roleID)) { throw new Exception("删除角色菜单权限失败!"); } } //判断存在角色按钮权限则先删除 if (new RoleModButton().ExistsByRoleID(tran, roleID)) { if (!new RoleModButton().DeleteByRoleID(tran, roleID)) { throw new Exception("删除角色菜单权限失败!"); } } //添加角色菜单权限 if (modID != null) { for (int i = 0; i < modID.Count; i++) { RoleModuleInfo model = new RoleModuleInfo() { RoleID = roleID, ModID = modID[i], }; if (!Add(tran, model)) { throw new Exception("添加角色菜单权限失败!"); } } } //添加角色按钮权限 if (mbID != null) { RoleModButtonInfo model = new RoleModButtonInfo(); model.RoleID = roleID; for (int i = 0; i < mbID.Count; i++) { string [] mbID_Arr = mbID[i].Split(new char[] { ',' }); model.ModID = int.Parse(mbID_Arr[0]); model.BtnID = int.Parse(mbID_Arr[1]); if (!new RoleModButton().Add(tran, model)) { throw new Exception("添加角色按钮权限失败!"); } } } transaction.Commit(tran); } catch (Exception ex) { transaction.Rollback(tran); strReturn = new Tools().GetErrorInfo(ex); } return(strReturn); }