public string GetMaxLng(string hostGUID) { object ob = DbHelperSQL.GetSingle("select max(fLng) from tLightInfoes where iEnable=1 and sHostInfoGUID='" + hostGUID + "'"); LumluxSSYDB.BLL.tHostInfo host_bll = new LumluxSSYDB.BLL.tHostInfo(); LumluxSSYDB.Model.tHostInfo host_mod = host_bll.GetModel(hostGUID); if (ob != null) { return(comMax(Convert.ToSingle(ob.ToString()), Convert.ToSingle(host_mod.fLng))); } return(""); }
// // GET: /Lamp/AlarmPage/ public ActionResult Index() { string strLightName = " 1=1 and "; string curTime = DateTime.Now.ToString("yyyy-MM-dd"); DateTime dtStart = DateTime.Now.AddDays(-7);//DateTime.Parse("1999-01-01"); DateTime dtEnd = DateTime.Parse(curTime).Add(new TimeSpan(23, 59, 59)); if (Request.QueryString["sGUID"] != null) { ViewBag.sHostGUID = Request.QueryString["sGUID"].ToString(); AlarmSelectedGUID = Request.QueryString["sGUID"].ToString(); LumluxSSYDB.BLL.tHostInfo thostbll = new LumluxSSYDB.BLL.tHostInfo(); LumluxSSYDB.Model.tHostInfo thostmode = thostbll.GetModel(AlarmSelectedGUID); if (thostmode != null) { ViewBag.HostNames = thostmode.sName; } //getdataresource gd = new getdataresource(); //PagingHelper<AlarmInfo> DataPaging = new PagingHelper<AlarmInfo>(10, GetDataSouceByTime(AlarmSelectedGUID, dtStart, dtEnd, 10)); List <AlarmInfo> DataPaging = GetDataSouceByTime(PrjGUID, AlarmSelectedGUID, dtStart, dtEnd, 0, strLightName); ViewBag.CurPageIndex = 1;//当前页 ViewBag.CurPageIndex = 1; if (DataPaging.Count > 0) { ViewBag.iCount = DataPaging[0].iCount;//总记录 ViewBag.iPage = (int)Math.Ceiling(Convert.ToInt32(DataPaging[0].iCount) / (double)10); ViewBag.Alarms = DataPaging; } else { ViewBag.iCount = 0;//总记录 ViewBag.iPage = 0; ViewBag.Alarms = new List <AlarmInfo>(); } ViewBag.vHost = new List <LumluxSSYDB.Model.tHostInfo>(); } else { #region MyRegion LumluxSSYDB.BLL.tHostInfo lbt = new LumluxSSYDB.BLL.tHostInfo(); //and iState_Alarm=1 List <LumluxSSYDB.Model.tHostInfo> listhost = lbt.GetModelList("sProjectInfoGUID='" + PrjGUID + "' and iState_Enable='" + (int)StateEnable.Enable + "' ");; if (listhost.Count > 0) { ViewBag.vHost = listhost; } else { ViewBag.vHost = new List <LumluxSSYDB.Model.tHostInfo>(); } #endregion // ViewBag.Alarms = new List<AlarmInfo>(); List <AlarmInfo> DataPagingall = GetDataSouceByTime(PrjGUID, dtStart, dtEnd, 0, strLightName); ViewBag.CurPageIndex = 1;; //当前页 ViewBag.HostNames = "单灯信息"; //"全部主机"; if (DataPagingall.Count > 0) { ViewBag.iCount = DataPagingall[0].iCount; //总记录 ViewBag.iPage = (int)Math.Ceiling(Convert.ToInt32(DataPagingall[0].iCount) / (double)10); //总页数 ViewBag.Alarms = DataPagingall; } else { ViewBag.iCount = 0;//总记录 ViewBag.iPage = 0; ViewBag.Alarms = new List <AlarmInfo>(); } } #region MyRegion List <PrjectSetInfoVM> pslist = new List <PrjectSetInfoVM>(); LumluxSSYDB.BLL.tPrjectSet light_bll = new LumluxSSYDB.BLL.tPrjectSet(); LightsViewModel lightVM = new LightsViewModel(); DataTable dt = light_bll.GetTableByWhere("sPrjectGUID='" + PrjGUID + "' and sKey like '%Light_Image_%'"); if (dt != null) { PrjectSetInfoVM psm; foreach (DataRow dr in dt.Rows) { psm = addprjectsetInfo(dr); pslist.Add(psm); } ViewBag.AlarmDemos = pslist; } else { ViewBag.AlarmDemos = new List <PrjectSetInfoVM>(); } #endregion return(View()); }