public void LowLyingPolice()
{
LowLyingModel llmodel = new LowLyingModel();
LowLyingOldModel llomodel = new LowLyingOldModel();
List <glxxModel> glxxlist = llbll.GetGlxxList();
foreach (var glxxitem in glxxlist)
{
List <glxxModel> glxxChildrenlist = llbll.getGlxxChildren(glxxitem.id);
foreach (var sbxxitem in glxxChildrenlist)
{
List <sbxxModel> getSbxxList = llbll.getSbxxList(sbxxitem.id);
foreach (var lsjltemp in getSbxxList)
{
LowLyingModel model = llbll.GetLowLyingModel(lsjltemp.id);
if (model != null)
{
model.id = lsjltemp.id;
model.jkdmc = lsjltemp.name;
model.zt = lsjltemp.isenabled == "是" ? "启用" : "未启用";
model.whdw = glxxitem.name;
model.whry = "";
model.dz = sbxxitem.name;
llbll.Edit(model);
lsjlModel getOldRecordingList = llbll.getOldRecordingList(lsjltemp.id);
llomodel.lowid = lsjltemp.id;
llomodel.bjz = getOldRecordingList.waterlevel.ToString();
llomodel.bjljz = model.bjljz;
llomodel.cjsj = getOldRecordingList.recordingtime;
llomodel.clqk = "";
decimal bjljz = Convert.ToDecimal(model.bjljz);
if (bjljz > getOldRecordingList.waterlevel)
{
llomodel.sfbj = 0;
}
else
{
llomodel.sfbj = 1;
}
llbll.AddPolice(llomodel);
}
else
{
llmodel.id = lsjltemp.id;
llmodel.jkdmc = lsjltemp.name;
llmodel.zt = lsjltemp.isenabled == "是" ? "启用" : "未启用";
llmodel.whdw = glxxitem.name;
llmodel.whry = "";
llmodel.bjljz = "0";
llmodel.dz = sbxxitem.name;
llbll.Add(llmodel);
}
}
}
}
}
/// <summary>
/// 获取水位信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public lsjlModel getOldRecordingList(int id)
{
string year = DateTime.Now.Year.ToString();
string oldid = id.ToString().PadLeft(6, '0');
string bm = "历史记录_" + oldid + "_" + year;
using (SqlEntities db = new SqlEntities())
{
string sql = string.Format(@"select [记录时间] recordingtime, [上报水位] waterlevel from [{0}] ORDER BY [记录时间] desc", bm);
lsjlModel model = db.Database.SqlQuery <lsjlModel>(sql).FirstOrDefault();
return(model);
}
}
