//根据查询条件展示招领信息
public ResData <List <GoodsId> > get(GoodsCon data)
{
ResData <List <GoodsId> > res = new ResData <List <GoodsId> >();
List <GoodsId> goods = dbcontext.t_lostgoods
//查询条件
.Where(t => (t.goods.Contains(data.goods) || data.goods == null) && (t.describe.Contains(data.describe) || data.describe == null) && t.collect_date >= data.bdate && t.collect_date <= data.edate)
//查询结果 t_lostgoods==>GoodsId
.Select(t => new GoodsId(t.id, t.goods, t.describe, t.collect_date, t.collect_addr, t.contact_man, t.contact_phone, t.contact_email))
//转换结果
.ToList();
res.code = 1;
res.msg = "查询成功";
res.data = goods;
return(res);
}
//根据查询条件展示招领信息
public ResData <List <GoodsId> > get(string goods, string describe, string bdate, string edate)
{
ResData <List <GoodsId> > res = new ResData <List <GoodsId> >();
res.code = 1;
GoodsCon data = new GoodsCon();
//赋值查询条件
if (string.IsNullOrEmpty(goods))
{
data.goods = null;
}
else
{
data.goods = goods;
}
if (string.IsNullOrEmpty(describe))
{
data.describe = null;
}
else
{
data.describe = describe;
}
if (string.IsNullOrEmpty(bdate))
{
data.bdate = DateTime.MinValue;
}
else
{
try
{
data.bdate = DateTime.Parse(bdate);
}
catch (Exception e) {
res.code = -1;
res.msg = "开始日期不是有效的日期格式";
}
}
if (string.IsNullOrEmpty(edate))
{
data.edate = DateTime.Now;
}
else
{
try
{
data.edate = DateTime.Parse(edate);
}
catch (Exception e)
{
res.code = -1;
res.msg = "结束日期不是有效的日期格式";
}
}
//如果查询条件有误，则返回提示
if (res.code == -1)
{
return(res);
}
//显示查询结果
res = lostGoodsDal.get(data);
return(res);
}
