/// <summary> /// 获取类别子菜单 /// </summary> /// <param name="sw">sw</param> /// <param name="dt">dt</param> /// <param name="RATID">RATID</param> /// <returns></returns> private static JArray getTreeChild(T_SYS_ADDREDDTYPE_SW sw, DataTable dt, string RATID) { JArray childobjArray = new JArray(); DataRow[] dr = dt.Select("RATID = " + RATID + "", "ORDERBY"); getTreeUser(childobjArray, sw, RATID); for (int i = 0; i < dr.Length; i++) { string atid = "typeid" + dr[i]["ATID"].ToString(); if (sw.treeIsShowTypeID == "0") { atid = ""; } JObject root = new JObject { { "id", atid } , { "text", dr[i]["RTNAME"].ToString() } , { "rid", dr[i]["RATID"].ToString() } , { "flag", "type" } , { "state", sw.isTreeOpen }, }; root.Add("children", getTreeChild(sw, dt, dr[i]["ATID"].ToString())); childobjArray.Add(root); } return(childobjArray); }
/// <summary> /// 下拉框 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static string getSelectOption(T_SYS_ADDREDDTYPE_SW sw) { DataTable dt = BaseDT.T_SYS_ADDREDDTYPE.getDT(sw); string str = getSelectOptionChiled(dt, sw.CurATID, "0", 0); dt.Clear(); dt.Dispose(); return(str); }
/// <summary> /// 获取数据列表 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static IEnumerable <T_SYS_ADDREDDTYPE_Model> getModelList(T_SYS_ADDREDDTYPE_SW sw) { var result = new List <T_SYS_ADDREDDTYPE_Model>(); DataTable dt = BaseDT.T_SYS_ADDREDDTYPE.getDT(sw);//列表 for (int i = 0; i < dt.Rows.Count; i++) { T_SYS_ADDREDDTYPE_Model m = new T_SYS_ADDREDDTYPE_Model(); m.ATID = dt.Rows[i]["ATID"].ToString(); m.RATID = dt.Rows[i]["RATID"].ToString(); m.RTNAME = dt.Rows[i]["RTNAME"].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 T_SYS_ADDREDDTYPE_Model getModel(T_SYS_ADDREDDTYPE_SW sw) { var result = new List <T_SYS_ADDREDDTYPE_Model>(); DataTable dt = BaseDT.T_SYS_ADDREDDTYPE.getDT(sw);//列表 T_SYS_ADDREDDTYPE_Model m = new T_SYS_ADDREDDTYPE_Model(); if (dt.Rows.Count > 0) { int i = 0; m.ATID = dt.Rows[i]["ATID"].ToString(); m.RATID = dt.Rows[i]["RATID"].ToString(); m.RTNAME = dt.Rows[i]["RTNAME"].ToString(); m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString(); } dt.Clear(); dt.Dispose(); return(m); }
/// <summary> /// 获取数据 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static DataTable getDT(T_SYS_ADDREDDTYPE_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" from T_SYS_ADDREDDTYPE a "); sb.AppendFormat("where 1=1"); if (string.IsNullOrEmpty(sw.ATID) == false) { sb.AppendFormat("and ATID = '{0}'", ClsSql.EncodeSql(sw.ATID)); } if (string.IsNullOrEmpty(sw.RATID) == false) { sb.AppendFormat("and RATID = '{0}'", ClsSql.EncodeSql(sw.RATID)); } string sql = ("select ATID, RATID, RTNAME, ORDERBY") + sb.ToString() + (" order by ATID "); DataSet ds = DataBaseClass.FullDataSet(sql); return(ds.Tables[0]); }
/// <summary> /// 类别树形菜单 /// </summary> /// <param name="sw">参见模型</param> /// <returns>string</returns> public static string getTypeTreeYU(T_SYS_ADDREDDTYPE_SW sw) { JArray childobjArray = new JArray(); DataTable dt = BaseDT.T_SYS_ADDREDDTYPE.getDT(sw); if (string.IsNullOrEmpty(sw.RATID)) { sw.RATID = "0"; } if (sw.isTreeOpen == "0") { sw.isTreeOpen = "closed"; } else { sw.isTreeOpen = "open"; } JArray JA = getTreeChild(sw, dt, sw.RATID);//, dctypetopid); DataRow[] dr = dt.Select("", "ORDERBY"); getTreeUser(childobjArray, sw, sw.RATID); for (int i = 0; i < dr.Length; i++) { string atid = "typeid" + dr[i]["ATID"].ToString(); if (sw.treeIsShowTypeID == "0") { atid = ""; } JObject root = new JObject { { "id", atid } , { "text", dr[i]["RTNAME"].ToString() } , { "rid", dr[i]["RATID"].ToString() } , { "flag", "type" } , { "state", sw.isTreeOpen }, }; //root.Add("children", getTreeChild(sw, dt, dr[i]["ATID"].ToString())); childobjArray.Add(root); } dt.Clear(); dt.Dispose(); return(JsonConvert.SerializeObject(childobjArray)); }
private static JArray getTreeUser(JArray childobjArray, T_SYS_ADDREDDTYPE_SW sw, string atid) { DataTable dtU = BaseDT.T_SYS_ADDREDDBOOK.getDT(new T_SYS_ADDREDDBOOK_SW { ATID = atid }); for (int k = 0; k < dtU.Rows.Count; k++) {//{ADID}{PHONE}{ADNAME}{USERJOB}{ORDERBY} if (string.IsNullOrEmpty(sw.treeIDShowUserType)) { sw.treeIDShowUserType = "{ADID}"; } if (string.IsNullOrEmpty(sw.treeNameShowUserType)) { sw.treeNameShowUserType = "{ADNAME}[{USERJOB}]"; } string id = sw.treeIDShowUserType .Replace("{ADID}", dtU.Rows[k]["ADID"].ToString()) .Replace("{PHONE}", dtU.Rows[k]["PHONE"].ToString()) .Replace("{ADNAME}", dtU.Rows[k]["ADNAME"].ToString()) .Replace("{USERJOB}", dtU.Rows[k]["USERJOB"].ToString()) .Replace("{ORDERBY}", dtU.Rows[k]["ORDERBY"].ToString()); string name = sw.treeNameShowUserType .Replace("{ADID}", dtU.Rows[k]["ADID"].ToString()) .Replace("{PHONE}", dtU.Rows[k]["PHONE"].ToString()) .Replace("{ADNAME}", dtU.Rows[k]["ADNAME"].ToString()) .Replace("{USERJOB}", dtU.Rows[k]["USERJOB"].ToString()) .Replace("{ORDERBY}", dtU.Rows[k]["ORDERBY"].ToString()); id = id.Replace("<>", "").Replace("[]", ""); name = name.Replace("<>", "").Replace("[]", ""); JObject root1 = new JObject { { "id", id } , { "text", name } , { "rid", "" } , { "flag", "user" } }; childobjArray.Add(root1); } dtU.Clear(); dtU.Dispose(); return(childobjArray); }
/// <summary> /// 类别树形菜单 /// </summary> /// <param name="sw">参见模型</param> /// <returns>string</returns> public static string getTypeTree(T_SYS_ADDREDDTYPE_SW sw) { JArray childobjArray = new JArray(); DataTable dt = BaseDT.T_SYS_ADDREDDTYPE.getDT(sw); if (string.IsNullOrEmpty(sw.RATID)) { sw.RATID = "0"; } if (sw.isTreeOpen == "0") { sw.isTreeOpen = "closed"; } else { sw.isTreeOpen = "open"; } JArray JA = getTreeChild(sw, dt, sw.RATID);//, dctypetopid); dt.Clear(); dt.Dispose(); return(JsonConvert.SerializeObject(JA)); }