//private OpenFileDialog file = new OpenFileDialog(); public AnalysisForm() { InitializeComponent(); var provinces = new Maticsoft.BLL.Provinces(); var provincesList = provinces.GetModelList(string.Empty); cbBoxProvinces.DataSource = provincesList; cbBoxProvinces.ValueMember = "ProvincesName"; var cityBll = new Maticsoft.BLL.City(); var cityList = cityBll.GetModelList(string.Empty); cbBoxCity.DataSource = cityList; cbBoxCity.DisplayMember = "CityName"; var districtBll = new Maticsoft.BLL.District(); var districtList = districtBll.GetModelList(String.Empty); cbbDistrict.DataSource = districtList; cbbDistrict.DisplayMember = "DistrictName"; var specialTagBll = new Maticsoft.BLL.SpecialTag(); chlBoxSpecialTag.DataSource = specialTagBll.GetModelList(string.Empty); chlBoxSpecialTag.DisplayMember = "TagName"; var cookingStylesBll = new Maticsoft.BLL.CookingStyles(); chbCookingStyles.DataSource = cookingStylesBll.GetModelList(String.Empty).OrderBy(x => x.CookingStyleName).ToList(); chbCookingStyles.DisplayMember = "CookingStyleName"; var cityLocalTagBll = new Maticsoft.BLL.CityLocalTagBll(); clbStoreTag.DataSource = cityLocalTagBll.GetModelList(string.Empty).OrderBy(x => x.TagName).ToList(); clbStoreTag.DisplayMember = "TagName"; btnNextPage.Enabled = false; btnBeforePage.Enabled = false; }
private void cbBoxCity_SelectedIndexChanged(object sender, EventArgs e) { try { var cityList = cbBoxCity.DataSource as List<Maticsoft.Model.City>; if (cityList == null) { return; } var cityInfo = cityList[cbBoxCity.SelectedIndex]; var districtBll = new Maticsoft.BLL.District(); var districtList = districtBll.GetModelList(String.Empty); cbbDistrict.DataSource = districtList.FindAll(x => x.CityID == cityInfo.CityID); ; cbbDistrict.DisplayMember = "DistrictName"; cbbDistrict.ValueMember = "DistrictID"; var cookingStylesBll = new Maticsoft.BLL.CookingStyles(); chbCookingStyles.DataSource = cookingStylesBll.GetModelList(string.Format("cityid = '{0}'", cityInfo.CityID)) .OrderBy(x => x.CookingStyleName) .ToList(); chbCookingStyles.DisplayMember = "CookingStyleName"; var cityLocalTagBll = new Maticsoft.BLL.CityLocalTagBll(); clbStoreTag.DataSource = cityLocalTagBll.GetModelList(string.Format("CityID = '{0}'", cityInfo.CityID)) .OrderBy(x => x.TagName) .ToList(); clbStoreTag.DisplayMember = "TagName"; } catch (System.Exception ex) { MessageBox.Show(ex.Message); } }
private void button3_Click(object sender, EventArgs e) { var searchText = textBox2.Text; if (string.IsNullOrEmpty(searchText)) { return; } var cookingStylesBll = new Maticsoft.BLL.CookingStyles(); var cookingStylesList = cookingStylesBll.GetModelList(String.Empty).OrderBy(x => x.CookingStyleName).ToList(); chbCookingStyles.DataSource = cookingStylesList.FindAll(x => x.CookingStyleName.Contains(searchText)); chbCookingStyles.DisplayMember = "CookingStyleName"; }