public JsonResult GetHistoryData(string axisNumStr)
{
log = LogFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType.FullName + ":" + MethodBase.GetCurrentMethod().Name);
var retData = new VM_Result_Data();
if (HisMain.IsAxisNum(axisNumStr))
{
var axisNum = new HisData(axisNumStr);
var bllHisData = new MesWeb.BLL.T_HisData(axisNum.TableName);
try {
var hisDataList = bllHisData.GetModelList("machineID = " + axisNum.MachineId);
var sensorDataList = new List <VM_Sensor_Online>();
foreach (var item in ParamCodeDic)
{
//找出映射的数据
var data = (from s in hisDataList where s.ParameterCodeID == item.Key select s).ToList();
if (data.Count > 0)
{
//生成传感器的数据结构
var sensorData = new VM_Sensor_Online {
ParamCodeId = item.Value
};
sensorData.SeriesData = new List <VM_Sensor_Data>();
foreach (var d in data)
{
try {
var seriesData = new VM_Sensor_Data {
X = ((DateTime)(d.CollectedTime)).AddHours(8).ToUniversalTime().ToString(), Y = float.Parse(d.CollectedValue)
};
sensorData.SeriesData.Add(seriesData);
} catch (Exception e) {
log.Error(e);
continue;
}
}
sensorDataList.Add(sensorData);
}
}
retData.Appendix = sensorDataList;
retData.Content = "加载机台历史数据成功";
retData.Code = RESULT_CODE.OK;
} catch (Exception e) {
log.Error(e);
retData.Content = "加载机台历史数据失败";
}
}
return(Json(retData));
}
public VM_JSMind genMindStruct(string axisNumStr, string id, ref VM_JSMind mind, string parentId = "", bool isRoot = false)
{
if (string.IsNullOrEmpty(axisNumStr) || !HisMain.IsAxisNum(axisNumStr))
{
return(null);
}
var bllMachine = new MesWeb.BLL.T_Machine();
var bllMachineType = new MesWeb.BLL.T_MachineType();
var bllEmployee = new MesWeb.BLL.T_Employee();
var bllMaterial = new MesWeb.BLL.T_MaterialOutput();
HisMain axisNum = new HisMain();
if (axisNumStr.StartsWith("ZD"))
{
axisNum.Year = axisNumStr.Substring(2, 4);
axisNum.Month = axisNumStr.Substring(6, 2);
axisNum.MachineTypeID = "5";
}
else if (axisNumStr.StartsWith("CP"))
{
axisNum = new HisMain(axisNumStr);
}
var hisTabName = "HISMAIN" + axisNum.Year + axisNum.Month + axisNum.MachineTypeID.Trim();
var bllHisMain = new MesWeb.BLL.T_HisMain(hisTabName);
var hisMain = bllHisMain.GetModelList("Axis_No like '%" + axisNumStr + "%'").FirstOrDefault();
if (hisMain == null)
{
return(null);
}
var machineType = bllMachineType.GetModel(int.Parse(axisNum.MachineTypeID));
MesWeb.Model.T_MaterialOutput material = null;
if (hisMain != null)
{
material = bllMaterial.GetModelList("MaterialRFID = '" + hisMain.MaterialRFID + "'").FirstOrDefault();
}
if (material != null)
{
hisMain.SpecColor = material.Color;
hisMain.SpecName = material.MaterialType;
hisMain.Supplier = material.SupplyCompany;
hisMain.BatchNo = material.BatchNo;
}
var employeeCode = hisMain.EmployeeID_Main;
var employee = bllEmployee.GetModelList("EmployeeCode = '" + employeeCode + "'").FirstOrDefault();
if (employee != null)
{
hisMain.EmployeeID_Main = employee.EmployeeName;
}
var machine = bllMachine.GetModel(hisMain.MachineID.Value);
var node = new JSMind_Data();
node.topic = machineType.MachineType + machine.MachineName;
node.id = id;
node.parentid = parentId;
node.isroot = isRoot;
node.data = hisMain;
mind.data.Add(node);
if (hisMain != null)
{
var startAxisNums = ("" + hisMain.Start_Axis_No).Split(',');
foreach (var stNum in startAxisNums)
{
genMindStruct(stNum, stNum, ref mind, id);
}
}
return(mind);
}
