public List <Model.BB_Factory> QueryAll()
{
var res = dal.QueryWhere().ToList();
return(res);
}
public object StationListJson(int limit, int page, string code)
{
var query = dal.QueryWhere();
int num;
decimal dnum;
if (code != null)
{
if (int.TryParse(code, out num))
{
num = Convert.ToInt32(code);
query = query.Where(x => x.ID == num || x.GasMainSize == num);
}
else if (decimal.TryParse(code, out dnum))
{
dnum = Convert.ToDecimal(code);
query = query.Where(x => x.Latitude.Equals(dnum) || x.Longtitude == dnum || x.StationArea == dnum || x.NearGasArea == dnum);
}
else
{
if (code == "有效")
{
query = query.Where(x => x.Valid.Equals("1"));
}
else if (code == "无效")
{
query = query.Where(x => x.Valid.Equals("0"));
}
else
{
var fac = facdal.QueryWhere(x => x.Name.Contains(code)).ToList();
if (fac.Count() > 0)
{
foreach (var item in fac)
{
query = query.Where(x => x.FactoryID == item.ID);
}
}
else
{
var cli = clidal.QueryWhere(x => x.Name.Contains(code)).ToList();
if (cli.Count() > 0)
{
foreach (var item in cli)
{
query = query.Where(x => x.ClientID == item.ID);
}
}
else
{
query = query.Where(x => x.Introduction.Contains(code) || x.Name.Contains(code) || x.StationControlSystem.Contains(code) || x.Code.Contains(code) || x.DeviceBindMode.Contains(code));
}
}
}
}
}
var res = query.OrderBy(o => o.ID).Skip((page - 1) * limit).Take(limit).ToList().Select(s => new
{
s.ID,
s.Code,
s.Name,
s.Introduction,
s.Latitude,
s.Longtitude,
FactoryID = facdal.Find(new object[] { s.FactoryID }).Name,
ClientID = clidal.Find(new object[] { s.ClientID }).Name,
s.GasMainSize,
s.DeviceBindMode,
s.StationArea,
s.NearGasArea,
s.StationControlSystem,
Valid = Enum.GetName(typeof(Enums.Valid), Convert.ToInt32(s.Valid)),
s.Remark
}).ToList();
var count = query.Count();
var tranres = new
{
code = 0,
msg = "success",
data = res,
count
};
return(tranres);
}