// Load ra danh sách các CategoryLevel1 bằng CodeCategpryLevel2 va IDLang public void Sel_Ext_ByCodeCategoryLevel2_ByIDLang(HttpContext context) { String jSonString = ""; bool Disable = !String.IsNullOrEmpty(context.Request.QueryString["Disable"]) ? Convert.ToBoolean(context.Request.QueryString["Disable"]) : false; string CodeCategoryLevel2 = context.Request.QueryString["CodeCategoryLevel2"] != null && context.Request.QueryString["CodeCategoryLevel2"] != "undefined" ? context.Request.QueryString["CodeCategoryLevel2"] : "-1"; int TitleLenght = context.Request.QueryString["TitleLenght"] != null && context.Request.QueryString["TitleLenght"] != "undefined" ? int.Parse(context.Request.QueryString["TitleLenght"]) : 100; int Limit = context.Request.QueryString["Limit"] != null && context.Request.QueryString["Limit"] != "undefined" ? int.Parse(context.Request.QueryString["Limit"]) : 100; string Order = context.Request.QueryString["Order"] != null && context.Request.QueryString["Order"] != "undefined" ? context.Request.QueryString["Order"] : "CategoryLevel1_CategoryNameLevel1"; string IsDesc = context.Request.QueryString["IsDesc"] != null && context.Request.QueryString["IsDesc"] != "undefined" ? context.Request.QueryString["IsDesc"] : "true"; int IDLang = !string.IsNullOrEmpty(context.Request.QueryString["IDLang"]) ? int.Parse(context.Request.QueryString["IDLang"]) : 1; CategoryLevel1BO aCategoryLevel1BO = new CategoryLevel1BO(); List<vw_CategoryLevel1ViewAll> obj = String.IsNullOrEmpty(context.Request.QueryString["Disable"]) ? aCategoryLevel1BO.Sel_Ext_ByCodeCategoryLevel2_ByIDLang(CodeCategoryLevel2, IDLang).ToList() : aCategoryLevel1BO.Sel_Ext_ByCodeCategoryLevel2_ByIDLang(CodeCategoryLevel2, IDLang, Disable).ToList(); List<vw_CategoryLevel1ViewAll> ObjOrder = new List<vw_CategoryLevel1ViewAll>(); switch (Order) { case "CategoryLevel1_CategoryNameLevel1": if (IsDesc == "False") { ObjOrder = obj.OrderBy(a => a.CategoryLevel1_CategoryNameLevel1).ToList(); } else { ObjOrder = obj.OrderByDescending(a => a.CategoryLevel1_CategoryNameLevel1).ToList(); } break; case "CategoryLevel2_CategoryNameLevel2": if (IsDesc == "False") { ObjOrder = obj.OrderBy(a => a.CategoryLevel2_CategoryNameLevel2).ToList(); } else { ObjOrder = obj.OrderByDescending(a => a.CategoryLevel2_CategoryNameLevel2).ToList(); } break; case "CategoryLevel1_ID": if (IsDesc == "False") { ObjOrder = obj.OrderBy(a => a.CategoryLevel1_ID).ToList(); } else { ObjOrder = obj.OrderByDescending(a => a.CategoryLevel1_ID).ToList(); } break; default: ObjOrder = obj; break; } for (int i = 0; i < ObjOrder.Count; i++) { if ((TitleLenght > -1) & (ObjOrder[i].CategoryLevel1_CategoryNameLevel1.Length > TitleLenght)) { ObjOrder[i].CategoryLevel1_CategoryNameLevel1 = ObjOrder[i].CategoryLevel1_CategoryNameLevel1.Substring(0, TitleLenght - 1); } } List<vw_CategoryLevel1ViewAll> ObjOrderLimit = new List<vw_CategoryLevel1ViewAll>(); if ((Limit > -1) & (ObjOrder.Count > Limit)) { ObjOrderLimit = ObjOrder.GetRange(0, Limit).ToList(); _converter.DateTimeFormat = "dd/MM/yyyy"; jSonString = JsonConvert.SerializeObject(ObjOrderLimit, _converter); } else { if (ObjOrder != null) { _converter.DateTimeFormat = "dd/MM/yyyy"; jSonString = JsonConvert.SerializeObject(ObjOrder, _converter); } } jSonString = "{\"data\":" + jSonString + "}"; context.Response.Write(jSonString); }