private void BindDataList(string query)
{
try
{
SqlCommand cmd = new SqlCommand(query, connect);
connect.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
DataSearchResult.DataSource = reader;
DataSearchResult.DataBind();
reader.Close();
connect.Close();
}
else
{
if (!String.IsNullOrWhiteSpace(RecipeNameText.Text))
{
SearchError.InnerHtml += "</br>Can't find Recipe Name : " + RecipeNameText.Text;
SearchError.Visible = true;
}
if (!String.IsNullOrWhiteSpace(SubmittedBy.Text))
{
SearchError.InnerHtml += "</br>Can't find Recipe submissions by : " + SubmittedBy.Text;
SearchError.Visible = true;
}
if (SelectedCuisine == null && SelectedCategories == null)
{
SearchError.Visible = true;
}
else if (SelectedCuisine != null && SelectedCategories == null)
{
SearchError.InnerHtml += string.Format("</br>Can't find Recipes with the selected:</br>{0}", SelectedCuisine);
SearchError.Visible = true;
}
else if (SelectedCuisine == null && SelectedCategories != null)
{
SearchError.InnerHtml += string.Format("</br>Can't find Recipes with the selected:</br>{0}", SelectedCategories);
SearchError.Visible = true;
}
else
{
SearchError.InnerHtml += string.Format("</br>Can't find Recipes with the selected:</br>{0}</br>{1}", SelectedCuisine, SelectedCategories);
SearchError.Visible = true;
}
reader.Close();
connect.Close();
}
}
catch (ArgumentNullException)
{
DataSearchResult.DataSource = null;
DataSearchResult.DataBind();
connect.Close();
SearchError.Visible = true;
throw;
}
}
/// <summary>
/// 云图数据本地检索
/// </summary>
/// <param name="queryParam">本地检索参数</param>
/// <returns>本地检索结果对象</returns>
public DataSearchResult LocalQuery(LocalSearchParam queryParam)
{
string jsonResult = LocalOriginalQuery(queryParam);
if (!string.IsNullOrWhiteSpace(jsonResult))
{
jsonResult = jsonResult.Replace("[]", "\"\"");
}
DataSearchResult queryResult = JsonConvert.DeserializeObject <DataSearchResult>(jsonResult);
return(queryResult);
}
