8,497
社区成员
发帖
与我相关
我的任务
分享
var allpages = from c in po.db.BA_MYWORK
where
(
(c.POP1.Contains(DropDownList_POP.SelectedItem.Value) || string.IsNullOrEmpty(DropDownList_POP.SelectedItem.Value)) &&
(c.ZDATE.Value.Equals(DatePicker1.SelectedDate.Value) || string.IsNullOrEmpty(DatePicker1.Text))
)
select c;
var allpages = from c in po.db.MM_MATNR
where
(
(c.WERKS.Contains(TextBox1.Text.Trim()) || string.IsNullOrEmpty(TextBox1.Text.Trim()) ) &&
(c.MATNR.Contains(TextBox2.Text.Trim()) || string.IsNullOrEmpty(TextBox2.Text.Trim())) &&
(c.MATNR_NAME.Contains(TextBox3.Text.Trim()) || string.IsNullOrEmpty(TextBox3.Text.Trim())) &&
(((EntityFunctions.TruncateTime(c.LAEDA) >= DatePicker1.SelectedDate.Value)) || string.IsNullOrEmpty(DatePicker1.Text.Trim())) &&
(((EntityFunctions.TruncateTime(c.LAEDA) <= DatePicker2.SelectedDate.Value)) || string.IsNullOrEmpty(DatePicker2.Text.Trim()))
)
orderby c.MATNR ascending
select c;
d.Time>=new DateTime(2016,5,1) && d.Time< new DateTime(2016,6,1)