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