public ActionResult CXXJ(AtriclList tiaoJaian)
{
List <AtriclList> list = GETListXJ(tiaoJaian);
ViewBag.queryList = list;
return(View());
}
public ActionResult CXWS2(AtriclList tiaoJaian)
{
List <AtriclList> list = GetListws(tiaoJaian);
ViewBag.queryList = list;
return(View());
}
//新增一个类来存这些条件值。。暂时不弄。。。。。
private void TJcl(AtriclList tiaoJian)
{
if (tiaoJian.JSRiQi <= DateTime.MinValue)
{
tiaoJian.JSRiQi = DateTime.Today.AddDays(+1);
}
else
{
tiaoJian.JSRiQi = tiaoJian.JSRiQi.AddDays(+1);
}
if (tiaoJian.KSRiQi <= DateTime.MinValue)
{
// new DateTime(2018, 10, 1)
tiaoJian.KSRiQi = DateTime.Today;
}
string k = "01";
string f = "02";
if (tiaoJian.TJsjdw == k)
{
k = "01";
f = "01";
}
else if (tiaoJian.TJsjdw == f)
{
f = "02";
k = "02";
}
}
private List <AtriclList> GETListDW(AtriclList tiaoJian)
{
if (tiaoJian.JSRiQi <= DateTime.MinValue)
{
tiaoJian.JSRiQi = DateTime.Today.AddDays(+1);
}
else
{
tiaoJian.JSRiQi = tiaoJian.JSRiQi.AddDays(+1);
}
if (tiaoJian.KSRiQi <= DateTime.MinValue)
{
// new DateTime(2018, 10, 1)
tiaoJian.KSRiQi = new DateTime(2018, 10, 1);
}
var query = queryDW().Where(m => m.DJRQ1 >= tiaoJian.KSRiQi && m.DJRQ1 <= tiaoJian.JSRiQi || m.DJRQ1 == null);
if (null != tiaoJian.DWCX)
{
query = query.Where(m => m.DWBH1 == tiaoJian.DWCX);
}
if (null != tiaoJian.DJCX)
{
query = query.Where(m => m.SFDJ == tiaoJian.DJCX);
}
//TOLOST
var list = Common.ToList(query);
return(list);
}
private List <AtriclList> GETListDJ(AtriclList tiaoJian)
{
if (tiaoJian.JSRiQi <= DateTime.MinValue)
{
tiaoJian.JSRiQi = DateTime.Today.AddDays(+1);
}
else
{
tiaoJian.JSRiQi = tiaoJian.JSRiQi.AddDays(+1);
}
if (tiaoJian.KSRiQi <= DateTime.MinValue)
{
// new DateTime(2018, 10, 1)
tiaoJian.KSRiQi = DateTime.Today;
}
var queryDJ = queryCX().Where(m => m.DJRQ >= tiaoJian.KSRiQi && m.DJRQ <= tiaoJian.JSRiQi);
if (null != tiaoJian.DWCX)
{
queryDJ = queryDJ.Where(m => m.DWBH == tiaoJian.DWCX);
}
//TOLOST
var list = Common.ToList(queryDJ);
//去重复
list = list.Distinct <AtriclList>(new Compare()).ToList();
return(list);
}
public ActionResult CXWS3(AtriclList tiaoJaian)
{
tiaoJaian.TJsjdw = "10";
List <AtriclList> list = GetListws(tiaoJaian);
ViewBag.queryList = list;
return(View());
}
public ActionResult CXDJ3(AtriclList tiaoJaian)
{
List <AtriclList> list = queryCX();
ViewBag.queryList = list;
return(View());
}
private List <AtriclList> GETlistWS(AtriclList tiaoJian)
{
if (tiaoJian.JSRiQi <= DateTime.MinValue)
{
tiaoJian.JSRiQi = DateTime.Today.AddDays(+1);
}
else
{
tiaoJian.JSRiQi = tiaoJian.JSRiQi.AddDays(+1);
}
if (tiaoJian.KSRiQi <= DateTime.MinValue)
{
// new DateTime(2018, 10, 1)
tiaoJian.KSRiQi = DateTime.Today;
}
string k = "01";
string f = "02";
if (tiaoJian.TJsjdw == k)
{
k = "01";
f = "01";
}
else if (tiaoJian.TJsjdw == f)
{
f = "02";
k = "02";
}
//重新组成表，增加查询条件
var queryWS = queryCX().Select(a => new AtriclList {
TJBH = a.TJBH, DJLSH = a.DJLSH, XM = a.XM, XB = a.XB, NL = a.NL, DJRQ = a.DJRQ, ZDYM = a.ZDYM, LXBH = a.LXBH, XMMC = a.XMMC
})
.Where(m => m.DJRQ >= tiaoJian.KSRiQi && m.DJRQ <= tiaoJian.JSRiQi);
queryWS = queryWS.Where(m => m.LXBH == k || m.LXBH == f);
var list = Common.ToList(queryWS);
list = list.Distinct <AtriclList>(new Compare()).ToList(); //这一步好像是去重
return(list);
}
private List <AtriclList> GetListws(AtriclList tiaoJian)//增加了第三个查询，取消了去重
{
if (tiaoJian.JSRiQi <= DateTime.MinValue)
{
tiaoJian.JSRiQi = DateTime.Today.AddDays(+1);
}
else
{
tiaoJian.JSRiQi = tiaoJian.JSRiQi.AddDays(+1);
}
if (tiaoJian.KSRiQi <= DateTime.MinValue)
{
// new DateTime(2018, 10, 1)
tiaoJian.KSRiQi = DateTime.Today;
}
var queryWS = queryCX().Select(a => new AtriclList {
TJBH = a.TJBH, DJLSH = a.DJLSH, XM = a.XM, XB = a.XB, NL = a.NL, DJRQ = a.DJRQ, ZDYM = a.ZDYM, LXBH = a.LXBH, XMMC = a.XMMC,
SFZH = a.SFZH, PHONE = a.PHONE, DWBH = a.DWBH, JCZT = a.JCZT
});
//var queryWS = queryCX().Select(a => new AtriclList { TJBH = a.TJBH, DJLSH = a.DJLSH, XM = a.XM, XB = a.XB, DJRQ = a.DJRQ, ZDYM = a.ZDYM, LXBH = a.LXBH, XMMC = a.XMMC });
if (null != tiaoJian)
{
queryWS = queryWS.Where(m => m.DJRQ >= tiaoJian.KSRiQi && m.DJRQ <= tiaoJian.JSRiQi);
}
if (null != tiaoJian.TJsjdw)
{
queryWS = queryWS.Where(m => m.LXBH == tiaoJian.TJsjdw);
}
var list = Common.ToList(queryWS);
return(list);
}
private List <AtriclList> GETListXJ(AtriclList tiaoJian)
{
if (tiaoJian.JSRiQi <= DateTime.MinValue)
{
tiaoJian.JSRiQi = DateTime.Today.AddDays(+1);
}
else
{
tiaoJian.JSRiQi = tiaoJian.JSRiQi.AddDays(+1);
}
if (tiaoJian.KSRiQi <= DateTime.MinValue)
{
// new DateTime(2018, 10, 1)
tiaoJian.KSRiQi = DateTime.Today;
}
var queryWS = queryCX().Select(a => new AtriclList
{
TJBH = a.TJBH,
DJLSH = a.DJLSH,
XM = a.XM,
XB = a.XB,
NL = a.NL,
DJRQ = a.DJRQ,
ZDYM = a.ZDYM,
LXBH = a.LXBH,
XMMC = a.XMMC,
TJXJ = a.TJXJ,
KS = a.KS,
SFZH = a.SFZH,
PHONE = a.PHONE,
DWBH = a.DWBH,
JCZT = a.JCZT,
BZ = a.BZ
});
queryWS = queryWS.Where(m => m.KS != "54 ");
if (null != tiaoJian)
{
queryWS = queryWS.Where(m => m.DJRQ >= tiaoJian.KSRiQi && m.DJRQ <= tiaoJian.JSRiQi);
}
if (null != tiaoJian.TJsjdw)
{
queryWS = queryWS.Where(m => m.KS == tiaoJian.TJsjdw);
}
if (null != tiaoJian.DJCX)
{
if (tiaoJian.DJCX == "0" || tiaoJian.DJCX == "2")
{
queryWS = queryWS.Where(m => m.TJXJ == null);
if (tiaoJian.DJCX == "0")
{
queryWS = queryWS.Where(m => m.JCZT == "未检");
}
else
{
queryWS = queryWS.Where(m => m.JCZT == "拒检");
}
}
else
{
queryWS = queryWS.Where(m => m.TJXJ != null);
}
}
if (null != tiaoJian.XB1)
{
queryWS = queryWS.Where(m => m.XB == tiaoJian.XB1);
}
var list = Common.ToList(queryWS);
return(list);
}
