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()
}));
}
}
