protected void ddlMediumCategory_SelectedIndexChanged(object sender, EventArgs e) { string selectedId = this.ddlMediumCategory.SelectedValue; if (selectedId != "0") { int mediumCategoryId = int.Parse(selectedId); using (var context = new DataSettingContext()) { var entities = context.SmallCategories.Where(s => s.MediumCategoryID == mediumCategoryId).Select(c => new { text = c.CategoryName, value = c.Id.ToString() }); this.ddlSmallCategory.Items.Clear(); this.ddlSmallCategory.Items.Add(new ListItem { Text = "选择小类", Value = "0" }); entities.ForEach(item => { this.ddlSmallCategory.Items.Add(new ListItem { Text = item.text, Value = item.value }); }); } } else { this.ddlSmallCategory.Items.Clear(); this.ddlSmallCategory.Items.Add(new ListItem { Text = "选择小类", Value = "0" }); } }
public static IEnumerable <Item> GetAllCategory() { using (var context = new DataSettingContext()) { var entities = context.Categories.Select(c => new Item { Text = c.CategoryName, Value = c.Id.ToString() }); return(entities.ToList()); } }
public static IEnumerable <ReportType> GetReportTypeByCategoryName(string categoryName) { using (var context = new DataSettingContext()) { var entities = context.DataServiceCategories.Where(c => c.CategoryName == categoryName).Select(c => new ReportType { Value = c.ID.ToString(), Text = c.CategoryItem }); return(entities.ToList()); } }
public static IEnumerable <Item> GetSmallCategoryById(int mediumCategoryId) { using (var context = new DataSettingContext()) { var items = context.SmallCategories.Where(c => c.MediumCategoryID == mediumCategoryId).Select(c => new Item { Text = c.CategoryName, Value = c.Id.ToString() }); return(items.ToList()); } }
public string GetTypeNameById(int id) { using (var context = new DataSettingContext()) { var entity = context.DataServiceCategories.Find(id); if (entity != null) { return(entity.CategoryItem); } else { return(string.Empty); } } }
public string GetReportTypeName(int reportTypeId) { using (var context = new DataSettingContext()) { var entity = context.DataServiceCategories.FirstOrDefault(c => c.ID == reportTypeId); if (entity != null) { return(entity.CategoryItem); } else { return(string.Empty); } } }
public void InitCategoryDropDownList() { using (var context = new DataSettingContext()) { var entities = context.Categories.Select(c => new { text = c.CategoryName, value = c.Id.ToString() }); this.ddlCategory.Items.Clear(); this.ddlCategory.Items.Add(new ListItem { Text = "选择门类", Value = "0" }); entities.ForEach(item => { this.ddlCategory.Items.Add(new ListItem { Text = item.text, Value = item.value }); }); } }
public void ReportType_GetData() { using (var context = new DataSettingContext()) { var items = context.DataServiceCategories.Where(c => c.CategoryName == "常规服务类型").Select(c => new { text = c.CategoryItem, value = c.ID.ToString(), }); this.ddlReportType.Items.Clear(); this.ddlReportType.Items.Add(new ListItem { Text = "选择类型", Value = "0" }); items.ForEach(item => { ListItem listItem = new ListItem { Text = item.text, Value = item.value }; this.ddlReportType.Items.Add(listItem); }); } }
private void InitRepeater1(int currentPageIndex = 1, string categoryId = "0", string mainCategoryId = "0", string mediumCategoryId = "0", string smallCategoryId = "0", string stars = "0", string keyword = "") { using (var context = new DataSettingContext()) { var entities = context.Judges.Select(j => j).ToList(); if (categoryId != "0") { entities = entities.Where(a => a.CategoryID == int.Parse(categoryId)).ToList(); } if (mainCategoryId != "0") { entities = entities.Where(a => a.MainCategoryID == int.Parse(mainCategoryId)).ToList(); } if (mediumCategoryId != "0") { entities = entities.Where(a => a.MediumCategoryID == int.Parse(mediumCategoryId)).ToList(); } if (smallCategoryId != "0") { entities = entities.Where(a => a.SmallCategoryID == int.Parse(smallCategoryId)).ToList(); } if (stars != "0") { entities = entities.Where(a => a.Star == int.Parse(stars)).ToList(); } if (keyword != "") { entities = entities.Where(a => a.Keyword.Contains(keyword)).ToList(); } this.AspNetPager1.RecordCount = entities.Count(); this.AspNetPager1.PageSize = this.AspNetPager1.PageSize; this.AspNetPager1.CurrentPageIndex = currentPageIndex; this.Repeater1.DataSource = entities.Skip((currentPageIndex - 1) * this.AspNetPager1.PageSize).Take(this.AspNetPager1.PageSize).ToList(); this.Repeater1.DataBind(); } }