public string resultReturn(preg_page data)
{
string result = "{";
for (int i = 0; i < data.GetType().GetProperties().ToList().Count(); i++)
{
string propertyName = data.GetType().GetProperties().ToList()[i].Name;
var propertyValue = data.GetType().GetProperty(propertyName).GetValue(data, null);
if (propertyName == "preg_guides")
{
//result += @"""" + propertyName + @""":[";
//GuidesDao guidesdao = new GuidesDao();
//preg_guides item = new preg_guides();
//item.page_id = data.id;
//IEnumerable<preg_guides> return_preg_guides = guidesdao.GetItemsByParams(item);
//foreach (var item2 in return_preg_guides)
//{
// result+=guidesdao.resultReturn(item2);
//}
//result+="],";
}
else if (propertyName.Substring(propertyName.Length - 4, propertyName.Length - 1) == "_id")
{
}
else
{
result += @"""" + propertyName + @""":""" + propertyValue.ToString() + @""",";
}
}
result += "}";
return(result);
}
public IQueryable <preg_page> GetItemsByParams(preg_page data)
{
IQueryable <preg_page> result = connect.preg_page;
for (int i = 0; i < data.GetType().GetProperties().ToList().Count(); i++)
{
string propertyName = data.GetType().GetProperties().ToList()[i].Name;
var propertyValue = data.GetType().GetProperty(propertyName).GetValue(data, null);
if (propertyName == "id" && (int)propertyValue != 0)
{
result = result.Where(c => c.id == (int)(propertyValue));
}
else if (propertyName == "title" && propertyValue != null)
{
result = result.Where(c => SqlFunctions.PatIndex("%" + propertyValue.ToString() + "%", c.title) > 0);
}
else if (propertyName == "content" && propertyValue != null)
{
result = result.Where(c => SqlFunctions.PatIndex("%" + propertyValue.ToString() + "%", c.content) > 0);
}
else if (propertyName == "page_image" && propertyValue != null)
{
result = result.Where(c => SqlFunctions.PatIndex("%" + propertyValue.ToString() + "%", c.page_image) > 0);
}
}
return(result);
}