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