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