/// <summary> /// 获取类别子菜单 /// </summary> /// <param name="sw">sw</param> /// <param name="dt">dt</param> /// <param name="SubRightID">SubRightID</param> /// <returns></returns> private static JArray getTreeChild(T_SYSSEC_RIGHT_SW sw, DataTable dt, string SubRightID) { JArray childobjArray = new JArray(); DataRow[] dr = dt.Select("len(RIGHTID)=" + (SubRightID.Length + 3) + " and SUBSTRING(RIGHTID,1," + SubRightID.Length + ")='" + SubRightID + "'", "ORDERBY"); string flag = ConfigCls.getSystemFlag(); for (int i = 0; i < dr.Length; i++) { string text = dr[i]["RIGHTNAME"].ToString(); if (dr[i]["SYSFLAG"].ToString() != flag) { text = "<font color=red>" + text + "</font>"; } JObject root = new JObject { { "id", dr[i]["RIGHTID"].ToString() }, { "text", text }, { "state", "open" }, }; if (dr[i]["RIGHTID"].ToString().Length <= 3) { root.Add("children", getTreeChild(sw, dt, dr[i]["RIGHTID"].ToString())); } childobjArray.Add(root); } return(childobjArray); }
/// <summary> /// 获取数据,获取所有角色 /// </summary> /// <returns>参见模型</returns> public static DataTable getDT(T_SYSSEC_RIGHT_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("SELECT RIGHTID, RIGHTNAME, SYSFLAG,ORDERBY"); sb.AppendFormat(" FROM T_SYSSEC_RIGHT"); sb.AppendFormat(" WHERE 1=1"); if (string.IsNullOrEmpty(sw.SYSFLAG) == false) { sb.AppendFormat(" AND SYSFLAG = '{0}'", ClsSql.EncodeSql(sw.SYSFLAG)); } if (string.IsNullOrEmpty(sw.RIGHTID) == false) { sb.AppendFormat(" AND RIGHTID = '{0}'", ClsSql.EncodeSql(sw.RIGHTID)); } if (string.IsNullOrEmpty(sw.SubRightID) == false) { if (sw.SubRightID == "0") { sb.AppendFormat(" AND Len(RIGHTID)=3"); } else { sb.AppendFormat(" AND len(RIGHTID)=" + (sw.SubRightID.Length + 3).ToString() + " AND SUBSTRING(RIGHTID,1," + sw.SubRightID.Length.ToString() + ")=" + sw.SubRightID); } } sb.AppendFormat(" ORDER BY ORDERBY,RIGHTID "); DataSet ds = DataBaseClass.FullDataSet(sb.ToString()); return(ds.Tables[0]); }
/// <summary> /// 类别树形菜单 /// </summary> /// <param name="sw">参见模型</param> /// <returns>string</returns> public static string getTypeTree(T_SYSSEC_RIGHT_SW sw) { JArray childobjArray = new JArray(); DataTable dt = BaseDT.T_SYSSEC_RIGHT.getDT(sw); JArray JA = getTreeChild(sw, dt, "");//, dctypetopid); dt.Clear(); dt.Dispose(); return(JsonConvert.SerializeObject(JA)); }
/// <summary> /// 判断记录是否存在 /// </summary> /// <param name="sw">参见模型</param> /// <returns>true存在 false不存在 </returns> public static bool isExists(T_SYSSEC_RIGHT_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("select 1 from T_SYSSEC_RIGHT where 1=1"); if (string.IsNullOrEmpty(sw.RIGHTID) == false) { sb.AppendFormat(" and RIGHTID='{0}'", ClsSql.EncodeSql(sw.RIGHTID)); } if (string.IsNullOrEmpty(sw.SYSFLAG) == false) { sb.AppendFormat(" and SYSFLAG='{0}'", ClsSql.EncodeSql(sw.SYSFLAG)); } return(DataBaseClass.JudgeRecordExists(sb.ToString())); }
/// <summary> /// 根据查询条件获取某一条用户信息记录,用于修改、删除、用户登录验证 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static T_SYSSEC_RIGHT_Model getModel(T_SYSSEC_RIGHT_SW sw) { DataTable dt = BaseDT.T_SYSSEC_RIGHT.getDT(sw); T_SYSSEC_RIGHT_Model m = new T_SYSSEC_RIGHT_Model(); if (dt.Rows.Count > 0) { int i = 0; //数据库表字段 m.RIGHTID = dt.Rows[i]["RIGHTID"].ToString(); m.RIGHTNAME = dt.Rows[i]["RIGHTNAME"].ToString(); m.SYSFLAG = dt.Rows[i]["SYSFLAG"].ToString(); m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString(); //扩充字段 } return(m); }
/// <summary> /// 获取列表 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static IEnumerable <T_SYSSEC_RIGHT_Model> getListModel(T_SYSSEC_RIGHT_SW sw) { var result = new List <T_SYSSEC_RIGHT_Model>(); DataTable dt = BaseDT.T_SYSSEC_RIGHT.getDT(sw); for (int i = 0; i < dt.Rows.Count; i++) { T_SYSSEC_RIGHT_Model m = new T_SYSSEC_RIGHT_Model(); m.RIGHTID = dt.Rows[i]["RIGHTID"].ToString(); m.RIGHTNAME = dt.Rows[i]["RIGHTNAME"].ToString(); m.SYSFLAG = dt.Rows[i]["SYSFLAG"].ToString(); m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString(); result.Add(m); } dt.Clear(); dt.Dispose(); return(result); }
/// <summary> /// 根据编号查询权限名称 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static string getNameByID(T_SYSSEC_RIGHT_SW sw) { return(BaseDT.T_SYSSEC_RIGHT.getNameByID(sw)); }
/// <summary> /// 根据编号查询权限名称 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static string getNameByID(T_SYSSEC_RIGHT_SW sw) { string sql = "SELECT RIGHTNAME FROM T_SYSSEC_RIGHT WHERE RIGHTID='" + sw.RIGHTID + "' and SYSFLAG='" + sw.SYSFLAG + "'"; return(DataBaseClass.ReturnSqlField(sql)); }