本文整理汇总了C#中SortableBindingList.Where方法的典型用法代码示例。如果您正苦于以下问题:C# SortableBindingList.Where方法的具体用法?C# SortableBindingList.Where怎么用?C# SortableBindingList.Where使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类SortableBindingList
的用法示例。
在下文中一共展示了SortableBindingList.Where方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: button1_Click_1
private void button1_Click_1(object sender, EventArgs e)
{
gridDaily.DataSource = null;
gridDaily.Rows.Clear();
gridDaily.Refresh();
try
{
var calcDate = dateTimePicker1.Value.Date;
var users = db.Users.Where(x => x.DeptID == comboBox1.SelectedIndex).ToList();
var t = db.DailyPayments.Where(x => users.Any(y => y.UserID == x.LocalUserID) && x.CalculationDate == calcDate);
if (cbxOnlyZeroPayment.Checked)
//gridDaily.DataSource = new SortableBindingList<DailyPayment>(db.DailyPayments.Where(x => x.CalculationDate == calcDate && x.DeptID == comboBox1.SelectedIndex && x.Payment <= 0).ToList());
{
var lst = new List<DailyPayment>();
foreach (var user in users)
{
lst.AddRange(db.DailyPayments.Where(x => user.UserID == x.LocalUserID && x.CalculationDate == calcDate && x.Payment > 0 && x.IsOld).ToList());
}
gridDaily.DataSource = new SortableBindingList<DailyPayment>(lst);
}
else
//gridDaily.DataSource = new SortableBindingList<DailyPayment>(db.DailyPayments.Where(x => x.CalculationDate == calcDate && x.DeptID == comboBox1.SelectedIndex).ToList());
{
var lst = new List<DailyPayment>();
foreach (var user in users)
{
var dblist = db.DailyPayments.Where(x => user.UserID == x.LocalUserID && x.CalculationDate == calcDate).ToList();
dblist.ForEach(x => { db.Entry<DailyPayment>(x).Reload(); });
lst.AddRange(dblist);
}
gridDaily.DataSource = new SortableBindingList<DailyPayment>(lst);
}
////
SortableBindingList<Kunchik> expressPay = new SortableBindingList<Kunchik>();
if (calcDate.Date.DayOfWeek == DayOfWeek.Monday || (calcDate.Date.DayOfWeek == DayOfWeek.Sunday && comboBox1.SelectedIndex == 4))
expressPay = DailyManagement.GetAccountsTest(calcDate.Date.AddDays(-1), calcDate.Date, new decimal[] { 2501 }, null);
else
expressPay = DailyManagement.GetAccountsTest(calcDate.Date, calcDate.Date, new decimal[] { 2501 }, null);
foreach (var row in (SortableBindingList<DailyPayment>)gridDaily.DataSource)
{
var expay = expressPay.Where(x => x.Purpose.Contains(row.AgreementNumber));
if (expay.Count() > 0)
row.Payment += expay.Sum(x => x.DebitAmount.Value);
}
gridDaily.Refresh();
}
catch (Exception ex)
{
LoggingManagement.LogException(ex, User);
}
}