/// <summary>
/// 获取变化后的商品信息
/// </summary>
/// <returns></returns>
public List <LocalCommodityCode> GetLocalCommodityCodeChange(InventoryChangesApo pageDataApo, out int totalCount)
{
totalCount = 0;
List <LocalCommodityCode> data;
//查询语句
var queryable = SqlSugarHelper.GetInstance().Db.Queryable <LocalCommodityCode>()
.Where((lcc) => lcc.operate_type == pageDataApo.operate_type)
.WhereIF(pageDataApo.startTime.HasValue, (lcc) => lcc.create_time >= pageDataApo.startTime)
.WhereIF(pageDataApo.endTime.HasValue, (lcc) => lcc.create_time <= pageDataApo.endTime)
.WhereIF((!string.IsNullOrEmpty(pageDataApo.name) && !string.IsNullOrWhiteSpace(pageDataApo.name)), (lcc) => lcc.CommodityName.Contains(pageDataApo.name))
.OrderBy((lcc) => lcc.create_time, OrderByType.Desc)
.Select <LocalCommodityCode>();
//如果小于0，默认查全部
if (pageDataApo.PageSize > 0)
{
data = queryable.ToPageList(pageDataApo.PageIndex, pageDataApo.PageSize, ref totalCount);
}
else
{
data = queryable.ToList();
totalCount = data.Count();
}
return(data);
}
/// <summary>
/// 查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void queryData(object sender, RoutedEventArgs e)
{
if (this.stockSnapshot.IsChecked == true)//库存快照
{
List <Commodity> list = listViewData;
if ((Commodity)goods_name.SelectedValue != null)
{
if (((Commodity)goods_name.SelectedValue).name != "全部")
{
list = listViewData.Where(item => item.name == ((Commodity)goods_name.SelectedValue).name).ToList();
}
}
listView.DataContext = list;
totalNum.Content = list.Sum(item => item.Count);
}
if (this.validity.IsChecked == true)//效期查询
{
List <CommodityCode> list = listView1Data;
if ((Commodity)goods_name.SelectedValue != null)
{
if (((Commodity)goods_name.SelectedValue).name != "全部")
{
list = listView1Data.Where(item => item.CommodityName == ((Commodity)goods_name.SelectedValue).name).ToList();
}
}
if (goods_code.Text != "")
{
list = list.Where(item => item.name.Contains(goods_code.Text)).ToList();
}
if (single1.IsChecked == true)
{
list = list.Where(item => item.ExpirationDate < DateTime.Now.AddMonths(1)).ToList();
}
if (single2.IsChecked == true)
{
list = list.Where(item => item.ExpirationDate < DateTime.Now.AddMonths(2)).ToList();
}
if (single3.IsChecked == true)
{
list = list.Where(item => item.ExpirationDate < DateTime.Now.AddMonths(3)).ToList();
}
listView1.DataContext = list;
}
else if (this.stock.IsChecked == true)//库存查询
{
InventoryChangesApo pageDataApo = new InventoryChangesApo();
if (this.outStock.IsChecked == true)
{
pageDataApo.operate_type = 0;
}
else if (this.inStock.IsChecked == true)
{
pageDataApo.operate_type = 1;
}
if (!string.IsNullOrEmpty(startTime.Text) && !string.IsNullOrWhiteSpace(startTime.Text))
{
pageDataApo.startTime = Convert.ToDateTime(startTime.Text);
}
if (!string.IsNullOrEmpty(endTime.Text) && !string.IsNullOrWhiteSpace(endTime.Text))
{
DateTime time = Convert.ToDateTime(endTime.Text.Replace("0:00:00", "23:59:59"));
pageDataApo.endTime = new DateTime(time.Year, time.Month, time.Day, 23, 59, 59);
}
if ((LocalCommodityCode)goods_name.SelectedValue != null)
{
if (((LocalCommodityCode)goods_name.SelectedValue).name != "全部")
{
pageDataApo.name = ((LocalCommodityCode)goods_name.SelectedValue).name;
}
}
List <LocalCommodityCode> list = ConsumingBll.GetInstance().GetLocalCommodityCodeChange(pageDataApo, out int count);
listView2.DataContext = list;
}
}
