private async void checkedListBox_TypeAbon_SelectedIndexChanged(object sender, EventArgs e) { var checkedIndexes = checkedListBox_TypeAbon.CheckedIndices; IEnumerable <Person> r1 = new List <Person>(); IEnumerable <Person> r2 = new List <Person>(); IEnumerable <Person> r3 = new List <Person>(); if ((checkedIndexes.Count != 3) && (checkedIndexes.Count != 0)) { if ((MyCheckedListBox.IsChecked(checkedListBox_TypeAbon, 0))) { r1 = _personsAll.Where(x => x.Value?.AbonementCurent?.AbonementName == AbonementByDays.NameAbonement).Select(x => x.Value); } if (MyCheckedListBox.IsChecked(checkedListBox_TypeAbon, 1)) { r2 = _personsAll.Where(x => x.Value?.AbonementCurent?.AbonementName == ClubCardA.NameAbonement).Select(x => x.Value); } if (MyCheckedListBox.IsChecked(checkedListBox_TypeAbon, 2)) { r3 = _personsAll.Where(x => x.Value?.AbonementCurent?.AbonementName == SingleVisit.NameAbonement).Select(x => x.Value); } _reqAbonType = r1.Union(r2).Union(r3); } else { _reqAbonType = _personsAll.Values; // Если не нужна выборка по этому признаку } MyCheckedListBox.ClearSelection(checkedListBox_TypeAbon); var result = await GetUpdatedRequestsAsync(); ShowPersons(result); }
private void checkedListBox_Gender_SelectedIndexChanged(object sender, EventArgs e) { var checkedIndexes = checkedListBox_Gender.CheckedIndices; IEnumerable <Person> r1 = new List <Person>(); IEnumerable <Person> r2 = new List <Person>(); if ((checkedIndexes.Count != 2) && (checkedIndexes.Count != 0)) { // Мужчины if ((MyCheckedListBox.IsChecked(checkedListBox_Gender, 0))) { r1 = _personsAll.Where(x => x.Value.GenderType == Gender.Мужской).Select(x => x.Value); } // Женщины if (MyCheckedListBox.IsChecked(checkedListBox_Gender, 1)) { r2 = _personsAll.Where(x => (x.Value.GenderType == Gender.Женский)).Select(x => x.Value); } _reqGender = r1.Union(r2); } else { _reqGender = _personsAll.Values; // Если не нужна выборка по этому признаку } MyCheckedListBox.ClearSelection(checkedListBox_Gender); var result = GetUpdatedRequestsAsync(); ShowPersons(result.Result); }
public void ReverseAllCheckStatus() { base.FindForm().Cursor = Cursors.WaitCursor; MyCheckedListBox.BeginUpdate(); for (int i = 0; i < MyCheckedListBox.Items.Count; i++) { MyCheckedListBox.SetItemChecked(i, !MyCheckedListBox.GetItemChecked(i)); } MyCheckedListBox.EndUpdate(); base.FindForm().Cursor = Cursors.Default; }
private void checkedListBox_Tren_Name_SelectedIndexChanged(object sender, EventArgs e) { var checkedIndexes = checkedListBox_Tren_Name.CheckedIndices; var pList = new List <Person>(); _reqTrenName = _personsAll.Values; if (checkedIndexes.Count != 0) { foreach (var item in checkedIndexes) { var checkedItemString = checkedListBox_Tren_Name.Items[(int)item].ToString(); var indexOfBrace = checkedItemString.IndexOf('('); string trimmedCheckedItemString; if (indexOfBrace > 0) { trimmedCheckedItemString = checkedItemString.Substring(0, checkedItemString.IndexOf('(')).Trim(); } else { trimmedCheckedItemString = checkedItemString; } var r2 = _aerobVisits.Where(x => { string groupTrName = x.GroupTimeName; if (groupTrName.Contains("(")) { groupTrName = groupTrName.Substring(0, x.GroupTimeName.IndexOf('(')).Trim(); } return(groupTrName == trimmedCheckedItemString); }).Select(y => y.NamePerson).Distinct().ToList(); foreach (var name in r2) { pList.Add(PersonObject.GetLink(name)); } _reqTrenName = _reqTrenName.Intersect(pList).Distinct(); } } else { _reqTrenName = _personsAll.Values; // Если не нужна выборка по этому признаку } MyCheckedListBox.ClearSelection(checkedListBox_Tren_Name); var result = GetUpdatedRequestsAsync(); ShowPersons(result.Result); }
public BindBox() { InitializeComponent(); FM = new MyWinForm(this); FM.SetDefaultStyle("选择"); conA = MyDB.GetAccessConnection(AccessPath); conS = MyDB.GetSqlServerConnection("127.0.0.1", "111", "Northwind"); CBB = new MyComboBox(comboBox1, "select CustomerID,ContactName from Customers", "ContactName", "CustomerID", conA); LB = new MyListBox(listBox1, "select CustomerID,ContactName from Customers", "CustomerID", "ContactName", conA); CLB = new MyCheckedListBox(checkedListBox1, "select CustomerID,ContactName from Customers", "ContactName", "CustomerID", conA); //checkedListBox1.Items.Add("selection1", true);//添加选中状态的项 }
public string GetListAsString(bool all) { StringBuilder str; base.FindForm().Cursor = Cursors.WaitCursor; str = new StringBuilder(20 * TheCheckedListBox.Items.Count); for (int i = 0; i < MyCheckedListBox.Items.Count; i++) { if (MyCheckedListBox.GetItemChecked(i) || all) { str.Append(MyCheckedListBox.Items[i].ToString() + Environment.NewLine); } } base.FindForm().Cursor = Cursors.Default; return(str.ToString()); }
private async void checkedListBox_Age_SelectedIndexChanged(object sender, EventArgs e) { var checkedIndexes = checkedListBox_Age.CheckedIndices; IEnumerable <Person> r1 = new List <Person>(); IEnumerable <Person> r2 = new List <Person>(); IEnumerable <Person> r3 = new List <Person>(); if ((checkedIndexes.Count != 3) && (checkedIndexes.Count != 0)) { // До 30 if (MyCheckedListBox.IsChecked(checkedListBox_Age, 0)) { var data = DateTime.Now.AddYears(-30); // Дата проверки для 30 летних r1 = _personsAll.Where(x => x.Value?.BirthDate.Date.CompareTo(data) >= 0).Select(x => x.Value); } // 30 - 40 if (MyCheckedListBox.IsChecked(checkedListBox_Age, 1)) { var dataFrom = DateTime.Now.AddYears(-40); var dataTo = DateTime.Now.AddYears(-30); r2 = _personsAll.Where(x => (x.Value?.BirthDate.Date.CompareTo(dataFrom) >= 0 && x.Value?.BirthDate.Date.CompareTo(dataTo) <= 0)).Select(x => x.Value); } // От 40 if (MyCheckedListBox.IsChecked(checkedListBox_Age, 2)) { var data = DateTime.Now.AddYears(-40); r3 = _personsAll.Where(x => x.Value?.BirthDate.Date.CompareTo(data) <= 0).Select(x => x.Value); } _reqAge = r1.Union(r2).Union(r3); } else { _reqAge = _personsAll.Values; // Если не нужна выборка по этому признаку } MyCheckedListBox.ClearSelection(checkedListBox_Age); var result = await GetUpdatedRequestsAsync(); ShowPersons(result); }
private async void checkedListBox_Activation_SelectedIndexChanged(object sender, EventArgs e) { var checkedIndexes = checkedListBox_Activation.CheckedIndices; // Сортировка по этому признаку не важна. Содержит 2 поля(Оплачено, Не оплачено) if ((checkedIndexes.Count == 2) || (checkedIndexes.Count == 0)) { _reqActivation = _personsAll.Values; } else { var activation = MyCheckedListBox.IsChecked(checkedListBox_Activation, 0); _reqActivation = _personsAll.Where(x => x.Value?.AbonementCurent?.IsActivated == activation).Select(x => x.Value); } MyCheckedListBox.ClearSelection(checkedListBox_Activation); var result = await GetUpdatedRequestsAsync(); ShowPersons(result); }
private async void checkedListBox_TimeTren_SelectedIndexChanged(object sender, EventArgs e) { var checkedIndexes = checkedListBox_TimeTren.CheckedIndices; // Сортировка по этому признаку не важна. Содержит 2 поля(Оплачено, Не оплачено) if ((checkedIndexes.Count == 2) || (checkedIndexes.Count == 0)) { _reqTimeTren = _personsAll.Values; } else { var timeTren = (MyCheckedListBox.IsChecked(checkedListBox_TimeTren, 0)) ? TimeForTr.Утро : TimeForTr.Весь_День; _reqTimeTren = _personsAll.Where(x => x.Value?.AbonementCurent?.TimeTraining == timeTren).Select(x => x.Value); } MyCheckedListBox.ClearSelection(checkedListBox_TimeTren); var result = await GetUpdatedRequestsAsync(); ShowPersons(result); }
private async void checkedListBox_Pay_SelectedIndexChanged(object sender, EventArgs e) { var checkedIndexes = checkedListBox_Pay.CheckedIndices; // Сортировка по этому признаку не важна. Содержит 2 поля(Оплачено, Не оплачено) if ((checkedIndexes.Count == 2) || (checkedIndexes.Count == 0)) { _reqPay = _personsAll.Values; } else { var payment = (MyCheckedListBox.IsChecked(checkedListBox_Pay, 0)) ? Pay.Не_Оплачено : Pay.Оплачено; _reqPay = _personsAll.Where(x => x.Value?.AbonementCurent?.PayStatus == payment).Select(x => x.Value); } MyCheckedListBox.ClearSelection(checkedListBox_Pay); var result = await GetUpdatedRequestsAsync(); ShowPersons(result); }
private void CheckFromFileMenuItem_Click(object sender, System.EventArgs e) { FileServer fs; string filename; string[] loadedItems; bool isUnknownItem; try { //Get file name. MyOpenFileDialog.ShowDialog(); filename = MyOpenFileDialog.FileName; if (filename == "") { return; } base.FindForm().Cursor = Cursors.WaitCursor; //Load file. fs = new FileServer(); loadedItems = fs.ReadSingleColumn(filename); if (loadedItems.GetLength(0) < 1) { base.FindForm().Cursor = Cursors.Default; return; } //See if there are loaded items which are not //in the checked list box. for (int i = 0; i < loadedItems.GetLength(0); i++) { isUnknownItem = true; for (int j = 0; j < MyCheckedListBox.Items.Count; j++) { if (MyCheckedListBox.Items[j].ToString().ToUpper() == loadedItems[i].ToUpper()) { isUnknownItem = false; break; //Exit for. } } if (isUnknownItem) { base.FindForm().Cursor = Cursors.Default; MessageManager.ShowWarning("The item " + loadedItems[i] + " in the file is not present in the list.", base.FindForm()); return; } } //Check the loaded items. for (int i = 0; i < loadedItems.GetLength(0); i++) { for (int j = 0; j < MyCheckedListBox.Items.Count; j++) { if (MyCheckedListBox.Items[j].ToString().ToUpper() == loadedItems[i].ToUpper()) { MyCheckedListBox.SetItemChecked(j, true); break; //Exit for. } } } base.FindForm().Cursor = Cursors.Default; } catch (Exception ex) { MessageManager.ShowError(ex, "Unable to check items from file.", base.FindForm()); } }