public static string LoadPesticidesProces(string Search)
{
DataTable nTable = ListSearch_Data.GetListByPesticides(Search);
HttpContext.Current.Session["nTableSearch"] = nTable;
HttpContext.Current.Session["nCount"] = nTable.Rows.Count;
string cities = "";
if (nTable.Rows.Count > 0)
{
for (int i = 0; i < nTable.Rows.Count & i < 10; i++)
{
string SeasonName = "";
if (nTable.Rows[i]["SeasonName"].ToString() == "1")
{
SeasonName = "Được sử dụng";
}
if (nTable.Rows[i]["SeasonName"].ToString() == "2")
{
SeasonName = "Hạn chế sử dụng";
}
if (nTable.Rows[i]["SeasonName"].ToString() == "3")
{
SeasonName = "Cấm sử dụng";
}
cities += ",{\"Key\":\"" + nTable.Rows[i]["PesticideKey"].ToString() + "\"" +
",\"Name\":\"" + nTable.Rows[i]["TradeName"].ToString() + "\"" +
",\"CategoryName\":\"" + nTable.Rows[i]["Crop_Name"].ToString() + "\"" +
",\"CompanyName\":\"" + nTable.Rows[i]["CompanyName"].ToString() + "\"" +
",\"StatusName\":\"" + nTable.Rows[i]["Common_Name"].ToString() + "\"" +
",\"SeasonName\":\"" + SeasonName + "\"" +
",\"Images\":\"" + nTable.Rows[i]["Images"].ToString().Substring(2) + "\"" +
"}";
}
cities = cities.Substring(1);
}
cities = "[" + cities + "]";
return(cities);
}
