/// <summary>
/// 获得水位数据
/// </summary>
/// <param name="StationId"></param>
/// <param name="Sdate"></param>
/// <param name="Edate"></param>
/// <param name="StationName"></param>
/// <param name="cp"></param>
/// <param name="ps"></param>
/// <param name="transType"></param>
/// <returns></returns>
public object GetWaterData(string StationId, DateTime?Sdate, DateTime?Edate, string StationName, int cp, int ps, string transType)
{
NSY_RTRUNEntity nsy = new NSY_RTRUNEntity();
nsy = nsyBll.GetWaterDataByConditional(StationId, Sdate, Edate, StationName, cp, ps, transType);
object JSONObj = JsonConvert.SerializeObject(nsy);
return(JSONObj);
}
public NSY_RTRUNEntity GetWaterDataByConditional(string StationId, DateTime?Sdate, DateTime?Edate, string StationName, int cp, int ps, string transType)
{
var _sdate = Sdate == null ? new DateTime(1999, 1, 1) : Sdate.Value;
var _edate = Edate == null ? new DateTime(2999, 1, 1) : Edate.Value;
List <NSY_RTRUN> nsy = new List <NSY_RTRUN>();
AbsFacory absfact = AbsFacory.CreatInstance();
INSY_RTRUNBLL nsybll = absfact.CreatINSY_RTRUNBLLInstance();
if (transType == "" || transType == null || transType == "全部报")
{
nsy = nsybll.Query(p => p.STCD == StationId && p.DATATYPE == "39" && p.INSERTTM >= _sdate && p.INSERTTM <= _edate)
.OrderByDescending(s => s.TM)
.ToList();
}
else
{
var transType_ = 0;
if (transType == "加报报")
{
transType_ = 5;
}
else if (transType == "定时报")
{
transType_ = 60;
}
nsy = nsybll.Query(p => p.STCD == StationId &&
p.DATATYPE == "39" && p.INSERTTM >= _sdate &&
p.INSERTTM <= _edate && p.PDR == transType_)
.OrderByDescending(s => s.TM)
.ToList();
}
List <NSY_RTRUN> nsyShow = new List <NSY_RTRUN>();
nsyShow = nsy.Skip(cp).Take(ps)
.ToList();
NSY_RTRUNEntity nsyEntity = new NSY_RTRUNEntity();
nsyEntity.rows = nsyShow;
nsyEntity.total = nsy.Count;
nsyEntity.page = nsy.Count / 5;
return(nsyEntity);
}
