/// <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);
}
/// <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);
}
/// <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);
}