//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";
}
