public static int DelRoleFunInfo(RoleFunModel Model) { string sql = "Delete from officedba.RoleFunction where CompanyCD=@CompanyCD and RoleID=@RoleID " + "and ModuleID like @ModuleID "; SqlParameter[] parms = new SqlParameter[3]; parms[0] = SqlHelper.GetParameter("@CompanyCD", Model.CompanyCD); parms[1] = SqlHelper.GetParameter("@RoleID", Model.RoleID); parms[2] = SqlHelper.GetParameter("@ModuleID", "%" + Model.ModuleID.ToString().Substring(0,1) + "%"); return SqlHelper.ExecuteTransSql(sql, parms); }
/// <summary> /// 删除角色功能 /// </summary> /// <param name="Model"></param> /// <returns></returns> public static int DelRoleFun(RoleFunModel Model) { string sql = "Delete from officedba.RoleFunction where CompanyCD=@CompanyCD and RoleID=@RoleID " + "and ModuleID=@ModuleID and FunctionID=@FunctionID "; SqlParameter[] parms = new SqlParameter[4]; parms[0] = SqlHelper.GetParameter("@CompanyCD", Model.CompanyCD); parms[1] = SqlHelper.GetParameter("@RoleID", Model.RoleID); parms[2] = SqlHelper.GetParameter("@ModuleID", Model.ModuleID); parms[3] = SqlHelper.GetParameter("@FunctionID", Model.FunctionID); return SqlHelper.ExecuteTransSql(sql,parms); }
/// <summary> /// 批量增加角色菜单功能 /// </summary> public static bool AddRoleFun(string RoleID, string ModuleID, string FunctionID,string FunctionType) { if (string.IsNullOrEmpty(RoleID) && string.IsNullOrEmpty(ModuleID) && string.IsNullOrEmpty(FunctionID)) return false; string[] sql = null; try { string str1=null; string str2 = null; int sql_index = 0; string[] funId = FunctionID.Split(','); string[] roleid = RoleID.Split(','); string[] moduleId = ModuleID.Split(','); ArrayList lstDelete = new ArrayList(); sql = new string[funId.Length]; if (roleid.Length >= 1) { sql = new string[funId.Length * roleid.Length]; } for (int index_role = 0; index_role < roleid.Length; index_role++) { for (int index_moduleId = 0; index_moduleId < moduleId.Length; index_moduleId++) { if (ModuleFunBus.IsExistByModuleId(moduleId[index_moduleId].ToString())) { DataTable dt = ModuleFunBus.GetModuleFunInfo(moduleId[index_moduleId].ToString(),FunctionType); foreach (DataRow Row in dt.Rows) { for (int i = 0; i < funId.Length; i++) { str1 = funId[i].Split('|')[0].ToString(); str2 = funId[i].Split('|')[1].ToString(); if (str1 == Row["FunctionID"].ToString() && (str2 == Row["ID"].ToString())) { RoleFunModel Model = new RoleFunModel(); Model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;//待修改 Model.FunctionID = Convert.ToInt32(Row["FunctionID"]); Model.RoleID = Convert.ToInt32(roleid[index_role]); Model.ModuleID = Convert.ToInt32(moduleId[index_moduleId]); DelRoleFun(Model); System.Text.StringBuilder cmdsql = new System.Text.StringBuilder(); cmdsql.AppendLine(" Insert into officedba.RoleFunction "); cmdsql.AppendLine(" (CompanyCD,RoleID,ModuleID,FunctionID "); cmdsql.AppendLine(" ,ModifiedDate,ModifiedUserID) "); cmdsql.AppendLine(" Values(@CompanyCD "); cmdsql.AppendLine(" , @roleid,@moduleId,@FunctionID"); cmdsql.AppendLine(" ,getdate(),"); cmdsql.AppendLine(" '" + ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID + "' ) "); sql[sql_index] = cmdsql.ToString(); sql_index++; SqlCommand sqlcomm = new SqlCommand(); sqlcomm.Parameters.Add(SqlHelper.GetParameter("@CompanyCD", Model.CompanyCD)); sqlcomm.Parameters.Add(SqlHelper.GetParameter("@roleid", roleid[index_role].ToString())); sqlcomm.Parameters.Add(SqlHelper.GetParameter("@moduleId", moduleId[index_moduleId].ToString())); sqlcomm.Parameters.Add(SqlHelper.GetParameter("@FunctionID", Row["FunctionID"].ToString())); sqlcomm.CommandText = cmdsql.ToString(); lstDelete.Add(sqlcomm); if (Row["FunctionID"] != null) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "delete from officedba.RoleFunction where ModuleID=@ModuleID and FunctionID is null and RoleID=@RoleID"; cmd.Parameters.Add(SqlHelper.GetParameter("@ModuleID", moduleId[index_moduleId].ToString())); cmd.Parameters.Add(SqlHelper.GetParameter("@RoleID", roleid[index_role].ToString())); lstDelete.Add(cmd); } } } } } } } return SqlHelper.ExecuteTransWithArrayList(lstDelete); } catch (System.Exception ex) { throw ex; } }
public static int DelRoleFunInfo(RoleFunModel Model) { if (Model == null) return 0; try { return RoleFunctionDBHelper.DelRoleFunInfo(Model); } catch (System.Exception ex) { throw ex; } }
/// <summary> /// 批量增加菜单 /// </summary> /// <param name="RoleID"></param> /// <param name="ModuleID"></param> /// <param name="FunctionID"></param> /// <returns></returns> public static bool AddRoleFunInfo(string RoleID, string ModuleID) { if (string.IsNullOrEmpty(RoleID) && string.IsNullOrEmpty(ModuleID)) return false; string[] sql = null; try { ArrayList lstDelete = new ArrayList(); int sql_index = 0; string[] roleid = RoleID.Split(','); string[] moduleId = ModuleID.Split(','); sql = new string[moduleId.Length]; if (roleid.Length >= 1) { sql = new string[moduleId.Length * roleid.Length]; } for (int index_role = 0; index_role < roleid.Length; index_role++) { for (int index_moduleId = 0; index_moduleId < moduleId.Length; index_moduleId++) { if (!string.IsNullOrEmpty(moduleId[index_moduleId])) { RoleFunModel Model = new RoleFunModel(); Model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;//待修改 Model.RoleID = Convert.ToInt32(roleid[index_role]); Model.ModuleID = Convert.ToInt32(moduleId[index_moduleId]); DelRoleFunInfo(Model); System.Text.StringBuilder cmdsql = new System.Text.StringBuilder(); cmdsql.AppendLine(" Insert into officedba.RoleFunction "); cmdsql.AppendLine(" (CompanyCD,RoleID,ModuleID, "); cmdsql.AppendLine(" ModifiedDate,ModifiedUserID) "); cmdsql.AppendLine(" Values(@CompanyCD "); cmdsql.AppendLine(" , @roleid,@moduleId"); cmdsql.AppendLine(" ,getdate(),"); cmdsql.AppendLine(" '" + ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID + "' ) "); sql[sql_index] = cmdsql.ToString(); sql_index++; SqlCommand sqlcomm = new SqlCommand(); sqlcomm.Parameters.Add(SqlHelper.GetParameter("@CompanyCD", Model.CompanyCD)); sqlcomm.Parameters.Add(SqlHelper.GetParameter("@roleid", roleid[index_role].ToString())); sqlcomm.Parameters.Add(SqlHelper.GetParameter("@moduleId", moduleId[index_moduleId].ToString())); sqlcomm.CommandText = cmdsql.ToString(); lstDelete.Add(sqlcomm); } } } return SqlHelper.ExecuteTransWithArrayList(lstDelete); } catch (System.Exception ex) { throw ex; } }