public static string GetSubDataList(string parentId, string parentIdStr) { try { BLL_S_MeasureTarget bll = new BLL_S_MeasureTarget(); DataTable dt = new DataTable(); List <object> listReturn = new List <object>(); string strWhere = " Parent_Id='" + parentId + "' "; dt = bll.GetListJoinDict(strWhere, "MTCode").Tables[0]; DataTable dtAll = bll.GetList("").Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { DataRow[] drSub = dtAll.Select("Parent_Id='" + dt.Rows[i]["S_MeasureTarget_Id"].ToString() + "'"); listReturn.Add(new { S_MeasureTarget_Id = dt.Rows[i]["S_MeasureTarget_Id"].ToString(), Parent_Id = dt.Rows[i]["Parent_Id"].ToString(), MTName = dt.Rows[i]["MTName"].ToString(), MTCode = dt.Rows[i]["MTCode"].ToString(), MTLevel = dt.Rows[i]["MTLevel"].ToString(), MTLevelName = dt.Rows[i]["MTLevelName"].ToString(), parentIdStr = parentIdStr, paddingLeft = 15 * (parentIdStr.Split('&').Length - 1), hasChildren = drSub.Length }); } if (dt.Rows.Count > 0) { return(JsonConvert.SerializeObject(new { err = "null", list = listReturn })); } else { return(JsonConvert.SerializeObject(new { err = "暂无数据" })); } } catch (Exception ex) { return(JsonConvert.SerializeObject(new { err = ex.Message.ToString() })); } }
public static string GetDataList(string Name, string GradeTerm, string Subject, string Resource_Version, int PageIndex, int PageSize) { try { BLL_S_MeasureTarget bll = new BLL_S_MeasureTarget(); DataTable dt = new DataTable(); List <object> listReturn = new List <object>(); string strWhere = " Parent_Id='0' "; if (!string.IsNullOrEmpty(Name)) { strWhere += " and (MTName like '%" + Name.Filter() + "%' or MTCode like '%" + Name.Filter() + "%') "; } if (!string.IsNullOrEmpty(GradeTerm)) { strWhere += " and GradeTerm='" + GradeTerm.Filter() + "' "; } if (!string.IsNullOrEmpty(GradeTerm)) { strWhere += " and Subject='" + Subject.Filter() + "' "; } if (!string.IsNullOrEmpty(GradeTerm)) { strWhere += " and Resource_Version='" + Resource_Version.Filter() + "' "; } dt = bll.GetListByPageJoinDict(strWhere, "MTCode", ((PageIndex - 1) * PageSize + 1), (PageIndex * PageSize)).Tables[0]; int rCount = bll.GetRecordCount(strWhere); DataTable dtAll = bll.GetList("").Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { DataRow[] drSub = dtAll.Select("Parent_Id='" + dt.Rows[i]["S_MeasureTarget_Id"].ToString() + "'"); listReturn.Add(new { S_MeasureTarget_Id = dt.Rows[i]["S_MeasureTarget_Id"].ToString(), Parent_Id = dt.Rows[i]["Parent_Id"].ToString().Trim(), MTName = dt.Rows[i]["MTName"].ToString(), MTCode = dt.Rows[i]["MTCode"].ToString(), MTLevel = dt.Rows[i]["MTLevel"].ToString(), MTLevelName = dt.Rows[i]["MTLevelName"].ToString(), parentIdStr = "", paddingLeft = "", hasChildren = drSub.Length }); } if (dt.Rows.Count > 0) { return(JsonConvert.SerializeObject(new { err = "null", PageIndex = PageIndex, PageSize = PageSize, TotalCount = rCount, list = listReturn })); } else { return(JsonConvert.SerializeObject(new { err = "暂无数据" })); } } catch (Exception ex) { return(JsonConvert.SerializeObject(new { err = ex.Message.ToString() })); } }