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