예제 #1
0
        /// <summary>
        /// 设备实时状态列表查询
        /// </summary>
        public JsonResult StateNowListQuery()
        {
            //json结果
            JsonResult result = new JsonResult();
            //获取设备类型
            string iMachineGroupID = Request.QueryString["query[iMachineGroupID]"];

            if (String.IsNullOrEmpty(iMachineGroupID))
            {
                return(result);
            }
            //获取查询
            string query = Request.QueryString["query[generalSearch]"];
            //获取状态
            string status = Request.QueryString["query[Status]"];
            //获取排序
            string field = Request.QueryString["sort[field]"];
            string sort  = Request.QueryString["sort[sort]"];

            //json.data
            AjaxTablePageData <Machine> pageData = new AjaxTablePageData <Machine>();
            //根据当前页和行数,获取数据集
            List <Machine> list = new YarnMachineDAL().GetStateNowListQuery(query, iMachineGroupID, status, field, sort);

            pageData.data = list;
            //允许get
            result.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
            result.Data = pageData;
            return(result);
        }
예제 #2
0
        /// <summary>
        /// 获取折线图
        /// </summary>
        public JsonResult QueryData(string MachineNo, string MachineVar, string MachineType, string TimeStart, string TimeEnd)
        {
            JsonResult result = new JsonResult();

            if (String.IsNullOrEmpty(MachineNo) || String.IsNullOrEmpty(MachineVar))
            {
                result.Data = "";
                return(result);
            }
            DateTime tStartTime = Convert.ToDateTime(TimeStart);
            DateTime tEndTime   = Convert.ToDateTime(TimeEnd);

            string[]         MachineVarList = MachineVar.Split(',');
            List <ChartData> list1          = new List <ChartData>();

            //遍历类型
            for (int j = 0; j < MachineVarList.Length; j++)
            {
                //获取类型名称和明细个数
                DataTable data1 = new YarnMachineDAL().GetMachineVar(MachineNo, MachineVarList[j], MachineType, TimeStart, TimeEnd);
                if (data1.Rows.Count == 0)
                {
                    continue;
                }
                //获取明细数据
                DataTable data2 = new YarnMachineDAL().GetMachineVarList(MachineNo, MachineVarList[j], MachineType, TimeStart, TimeEnd);
                int       count = data2.Rows.Count;
                //根据数量定义数组个数
                object[] List2 = new object[count];
                //对象赋值
                ChartData chardata = new ChartData()
                {
                    name          = (string)data1.Rows[0]["saddressName"],
                    type          = "line",
                    showAllSymbol = true,
                    smooth        = true,
                    symbolSize    = 2
                };
                int i = 0;
                //明细数据处理
                foreach (DataRow row2 in data2.Rows)
                {
                    DateTime time = (DateTime)row2["tCreateTime"];
                    List2[i] = new object[] { time.ToString(), (string)row2["sValue"] };
                    i++;
                }
                //明细赋值
                chardata.data = List2;
                list1.Add(chardata);
            }
            //写入结果
            result.Data = list1;
            return(result);
        }
예제 #3
0
        /// <summary>
        /// 获取机型
        /// </summary>
        public JsonResult QueryMachineType()
        {
            JsonResult result = new JsonResult();
            DataTable  data   = new YarnMachineDAL().GetMachineType();
            int        count  = data.Rows.Count;

            object[] List = new object[count];
            int      i    = 0;

            foreach (DataRow row in data.Rows)
            {
                List[i] = new object[] { (int)row["iMachineGroupID"], (string)row["sMachineGroupName"] };
                i++;
            }
            result.Data = List;
            return(result);
        }