public JsonResult TestSuccItems(VM_Trace_Search_Cond cond) { var retData = new VM_Result_Data(); var items = SearchTraceBrefAction(cond); List <List <MesWeb.Model.T_HisMain> > listArray = null; List <MesWeb.Model.T_HisMain> hisMainListArray = new List <MesWeb.Model.T_HisMain>(); listArray = getSameYearData(cond.StartTime, cond.EndTime, cond.MachineType); filterListMainArrary(hisMainListArray, listArray, cond.AxisNum); List <VM_JSMind> jsMindList = new List <VM_JSMind>(); hisMainListArray.ForEach(h => { VM_JSMind vmJsMind = new VM_JSMind(); genMindStruct(h.Axis_No.Trim(), "root", ref vmJsMind, isRoot: true); jsMindList.Add(vmJsMind); }); var succTimes = 0; jsMindList.ForEach(mind => { if (mind.data.Count >= 4) { succTimes++; } }); retData.Code = RESULT_CODE.OK; retData.Content = succTimes; return(Json(retData)); }
public JsonResult SearchTraceBrefAction(VM_Trace_Search_Cond cond) { var retData = new VM_Result_Data(); retData.Content = "查询失败"; if (string.IsNullOrEmpty(cond.MachineType)) { cond.MachineType = "5"; } var brefList = new List <VM_Trace_Bref>(); try { var isFirstSearch = true; List <MesWeb.Model.T_HisMain> hisMainListArray = new List <MesWeb.Model.T_HisMain>(); if (cond.StartTime.HasValue && cond.EndTime.HasValue && cond.StartTime < cond.EndTime) { isFirstSearch = false; List <List <MesWeb.Model.T_HisMain> > listArray = null; //同一年 if (cond.StartTime.Value.Year == cond.EndTime.Value.Year) { listArray = getSameYearData(cond.StartTime, cond.EndTime, cond.MachineType); filterListMainArrary(hisMainListArray, listArray, cond.AxisNum); } //不是同一年 else { for (var y = cond.StartTime.Value.Year; y <= cond.EndTime.Value.Year; ++y) { if (y == cond.StartTime.Value.Year) { listArray = getSameYearData(cond.StartTime, new DateTime(y, 12, 31), cond.MachineType); } else if (y == cond.EndTime.Value.Year) { listArray = getSameYearData(new DateTime(y, 1, 1), cond.EndTime, cond.MachineType); } else { listArray = getSameYearData(new DateTime(y, 1, 1), new DateTime(y, 12, 31), cond.MachineType); } filterListMainArrary(hisMainListArray, listArray, cond.AxisNum); } } } if (!string.IsNullOrEmpty(cond.AxisNum) && isFirstSearch) { var axisNum = new HisMain(cond.AxisNum); var hisTabName = "HISMAIN" + axisNum.Year + axisNum.Month + axisNum.MachineTypeID.Trim(); var bllHisMain = new MesWeb.BLL.T_HisMain(hisTabName); var hisMainList = bllHisMain.GetModelList("Axis_No like '%" + cond.AxisNum + "%'"); hisMainListArray.AddRange(hisMainList); } hisMainListArray.ForEach(h => { //生成结果 try { var bref = new VM_Trace_Bref(); bref.SpecNum = "未录入"; bref.Axis_No = h.Axis_No.Replace(",", ""); var axisNum = new HisMain(h.Axis_No); bref.Date = axisNum.Year + "-" + axisNum.Month + "-" + axisNum.Day; bref.PrintCode = string.IsNullOrEmpty(h.Printcode) ? "未录入" : h.Printcode; bref.Detail = "<a tabId=" + h.CurrentDataID + " tabName = '" + axisNum.GetHisDataTableName() + "' axisNum='" + axisNum.AxisNumStr + "' onclick='showTraceDetail(this)'>详情</a>"; brefList.Add(bref); } catch { } }); if (brefList.Count > 0) { retData.Code = RESULT_CODE.OK; retData.Appendix = brefList; retData.Content = "查询成功"; } } catch (Exception e) { Console.WriteLine(e.ToString()); } return(Json(retData)); }