internal static object GetList(员工信息Filter filter)
{
using (var client = new BDKRWS.BDKRWSClient())
{
return client.员工信息_GetList(filter);
}
}
private void LoadData()
{
var filter = 员工信息FilterBindingSource.DataSource as 员工信息Filter;
if (null == filter)
filter = new 员工信息Filter();
var list = 员工信息Logic.GetList(filter);
员工信息ViewModelGridControl.DataSource = list;
gridView1.AutoConfig();
}
public List<员工信息ViewModel> 员工信息_GetList(员工信息Filter filter)
{
using (var context = new BDKRContext())
{
var q = from t in context.员工信息S
select t;
if (filter.关键词 != null && filter.关键词.Length > 0)
q = from t in q
where (t.姓名 != null && t.姓名.Contains(filter.关键词))
|| (t.拼音 != null && t.拼音.Contains(filter.关键词))
|| (t.工号 != null && t.工号.Contains(filter.关键词))
|| (t.联系电话 != null && t.联系电话.Contains(filter.关键词))
|| (t.身份证号 != null && t.身份证号.Contains(filter.关键词))
select t;
if (filter.门店编码 != null && filter.门店编码.Length > 0)
q = from t in q
where filter.门店编码.Contains(t.门店编码)
select t;
var list = new List<员工信息ViewModel>();
q.ToList()
.ForEach(t =>
{
list.Add(t.ConvertToViewModel());
});
return list;
}
}