public static string LoadFertilizersProces(string Search)
{
DataTable nTable = ListSearch_Data.GetListByFertilizers(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++)
{
cities += ",{\"Key\":\"" + nTable.Rows[i]["FertilizersKey"].ToString() + "\"" +
",\"Name\":\"" + nTable.Rows[i]["TradeName"].ToString() + "\"" +
",\"CategoryName\":\"" + nTable.Rows[i]["CategoryName"].ToString() + "\"" +
",\"CompanyName\":\"" + nTable.Rows[i]["CompanyName"].ToString() + "\"" +
",\"StatusName\":\"" + nTable.Rows[i]["Common_Name"].ToString() + "\"" +
",\"SeasonName\":\"" + nTable.Rows[i]["Fertilizer_Unit_Name"].ToString() + "\"" +
",\"Images\":\"" + nTable.Rows[i]["Images"].ToString().Substring(2) + "\"" +
"}";
}
cities = cities.Substring(1);
}
cities = "[" + cities + "]";
return(cities);
}
public static string LoadSeedProces(string Search)
{
int memberID = HttpContext.Current.Session["MemberID"].ToInt();
DataTable nTable = ListSearch_Data.GetListBySeed(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++)
{
cities += ",{\"Key\":\"" + nTable.Rows[i]["SeedsKey"].ToString() + "\"" +
",\"Name\":\"" + nTable.Rows[i]["SeedsName"].ToString() + "\"" +
",\"CategoryName\":\"" + nTable.Rows[i]["CategoryName"].ToString() + "\"" +
",\"CompanyName\":\"" + nTable.Rows[i]["CompanyName"].ToString() + "\"" +
",\"StatusName\":\"" + nTable.Rows[i]["StatusName"].ToString() + "\"" +
",\"SeasonName\":\"" + nTable.Rows[i]["SeasonName"].ToString() + "\"" +
",\"Images\":\"" + nTable.Rows[i]["Images"].ToString().Substring(2) + "\"" +
"}";
}
cities = cities.Substring(1);
}
cities = "[" + cities + "]";
return(cities);
}
public static string LoadSearchCode(string Code)
{
int memberID = HttpContext.Current.Session["MemberID"].ToInt();
DataTable nTable = ListSearch_Data.GetListByCode(Code);
string cities = "";
if (nTable.Rows.Count > 0)
{
for (int i = 0; i < nTable.Rows.Count; i++)
{
if (i + 1 < nTable.Rows.Count)
{
cities += "{\"Name\":\"" + nTable.Rows[i]["Name"] + "\"" +
",\"Cooperative_Name\":\"" + nTable.Rows[i]["Cooperative_Name"] + "\"" +
",\"Address\":\"" + nTable.Rows[i]["Address"] + "\"" +
",\"VietGAPCode\":\"" + nTable.Rows[i]["VietGAPCode"] + "\"" +
",\"Phone\":\"" + nTable.Rows[i]["Phone"] + "\"" +
",\"Email\":\"" + nTable.Rows[i]["Email"] + "\"" +
",\"DateRange\":\"" + Utils.DateTostring((DateTime)(nTable.Rows[i]["DateRange"])) + "\"" +
",\"DateExpiration\":\"" + Utils.DateTostring((DateTime)(nTable.Rows[i]["DateExpiration"])) + "\"" +
",\"SeedsName\":\"" + nTable.Rows[i]["SeedsName"] + "\"" +
",\"DateOfManufacture\":\"" + Utils.DateTostring((DateTime)(nTable.Rows[i]["DateOfManufacture"])) + "\"" +
",\"DatetimeSale\":\"" + Utils.DateTostring((DateTime)(nTable.Rows[i]["DatetimeSale"])) + "\"" +
",\"WhereToBuy\":\"" + nTable.Rows[i]["WhereToBuy"] + "\"" +
",\"TreeType\":\"" + nTable.Rows[i]["TreeType"] + "\"" +
"},";
}
else
{
cities += "{\"Name\":\"" + nTable.Rows[i]["Name"] + "\"" +
",\"Cooperative_Name\":\"" + nTable.Rows[i]["Cooperative_Name"] + "\"" +
",\"Address\":\"" + nTable.Rows[i]["Address"] + "\"" +
",\"VietGAPCode\":\"" + nTable.Rows[i]["VietGAPCode"] + "\"" +
",\"Phone\":\"" + nTable.Rows[i]["Phone"] + "\"" +
",\"Email\":\"" + nTable.Rows[i]["Email"] + "\"" +
",\"DateRange\":\"" + Utils.DateTostring((DateTime)(nTable.Rows[i]["DateRange"])) + "\"" +
",\"DateExpiration\":\"" + Utils.DateTostring((DateTime)(nTable.Rows[i]["DateExpiration"])) + "\"" +
",\"SeedsName\":\"" + nTable.Rows[i]["SeedsName"] + "\"" +
",\"DateOfManufacture\":\"" + Utils.DateTostring((DateTime)(nTable.Rows[i]["DateOfManufacture"])) + "\"" +
",\"DatetimeSale\":\"" + Utils.DateTostring((DateTime)(nTable.Rows[i]["DatetimeSale"])) + "\"" +
",\"WhereToBuy\":\"" + nTable.Rows[i]["WhereToBuy"] + "\"" +
",\"TreeType\":\"" + nTable.Rows[i]["TreeType"] + "\"" +
"}";
}
}
cities = "[" + cities + "]";
}
else
{
cities = "";
}
return(cities);
}
public static string LoadSeedProces()
{
int memberID = HttpContext.Current.Session["MemberID"].ToInt();
DataTable nTable = ListSearch_Data.GetListByMemberDay(memberID, DateTime.Now);
string cities = "";
for (int i = 0; i < nTable.Rows.Count; i++)
{
if (i + 1 < nTable.Rows.Count)
{
cities += "{\"Key\":\"" + nTable.Rows[i]["SeedsKey"].ToString() + "\",\"Name\":\"" + nTable.Rows[i]["SeedsName"].ToString() + "\",\"Images\":\"" + nTable.Rows[i]["Images"].ToString().Substring(2) + "\"},";
}
else
{
cities += "{\"Key\":\"" + nTable.Rows[i]["SeedsKey"].ToString() + "\",\"Name\":\"" + nTable.Rows[i]["SeedsName"].ToString() + "\",\"Images\":\"" + nTable.Rows[i]["Images"].ToString().Substring(2) + "\"}";
}
}
cities = "[" + cities + "]";
return(cities);
}
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);
}
