public GreatWallForm()
{
InitializeComponent();
var provinces = new Maticsoft.BLL.Provinces();
var provincesList = provinces.GetModelList(string.Empty);
cbBoxProvinces.DataSource = provincesList;
cbBoxProvinces.ValueMember = "ProvincesName";
var provincesInfo = provincesList.FirstOrDefault();
var cityBll = new Maticsoft.BLL.City();
var cityList = cityBll.GetModelList(string.Empty);
cityList = cityList.FindAll(x => provincesInfo != null && x.ProvincesID == provincesInfo.ProvincesID);
cbBoxCity.DataSource = cityList;
cbBoxCity.DisplayMember = "CityName";
var cityInfo = cityList.FirstOrDefault();
var districtBll = new Maticsoft.BLL.District();
var districtList = districtBll.GetModelList(String.Empty);
cbbDistrict.DataSource = districtList.FindAll(x => cityInfo != null && x.CityID == cityInfo.CityID);
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";
}
private void InitializeClb()
{
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";
}
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.Empty)
.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 button5_Click(object sender, EventArgs e)
{
var searchText = textBox2.Text;
var cookingStylesBll = new Maticsoft.BLL.CookingStyles();
//var cookingStylesList = cookingStylesBll.GetModelList(String.Empty).OrderBy(x => x.CookingStyleName).ToList();
var ckeckItemList = chbCookingStyles.CheckedItems;
var resualtList = ckeckItemList.Cast<CookingStyles>().ToList();
var cookingStylesList = cookingStylesBll.GetModelList(String.Empty);
if (cookingStylesList != null)
{
resualtList.AddRange(cookingStylesList.FindAll(x => (x.CookingStyleName.Contains(searchText) && !string.IsNullOrEmpty(searchText)) && !resualtList.Exists(y => x.CookingStyleID == y.CookingStyleID)));
}
chbCookingStyles.DataSource = resualtList;
chbCookingStyles.DisplayMember = "CookingStyleName";
}
private void button3_Click(object sender, EventArgs e)
{
var cookingStylesBll = new Maticsoft.BLL.CookingStyles();
var cookingStylesList = cookingStylesBll.GetModelList(String.Empty).OrderBy(x => x.CookingStyleName).ToList();
chbCookingStyles.DataSource = cookingStylesList;
chbCookingStyles.DisplayMember = "CookingStyleName";
}
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;
chbCookingStyles.DisplayMember = "CookingStyleName";
}