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)); }
public JsonResult GetAxisDetailAction(string axisNumStr) { log = LogFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType.FullName + ":" + MethodBase.GetCurrentMethod().Name); var retData = new VM_Result_Data(); var procDetailList = new List <VM_ProcDetail>(); var hisData = new VM_ProcDetail(); axisNumStr = axisNumStr.Trim(); HisMain axisNum = new HisMain(axisNumStr); var tabName = axisNum.GetHisDataTableName(); if (string.IsNullOrEmpty(tabName)) { retData.Content = "轴号有误"; return(Json(retData)); } try { var bllHisData = new MesWeb.BLL.T_HisMain(tabName); var findData = bllHisData.GetModelList("Axis_No = '" + axisNumStr + "'").FirstOrDefault(); hisData = new VM_ProcDetail { Axis_No = findData.Axis_No, CurrentDataID = findData.CurrentDataID, SpecificationID = findData.SpecificationID, MachineID = findData.MachineID, MachineTypeID = findData.MachineTypeID, EmployeeID_Main = findData.EmployeeID_Main, EmployeeID_Assistant = findData.EmployeeID_Assistant, Start_Axis_No = findData.Start_Axis_No, Printcode = findData.Printcode }; var specID = hisData.SpecificationID; var bllMachine = new MesWeb.BLL.T_Machine(); var bllEmp = new MesWeb.BLL.T_Employee(); var bllSpec = new MesWeb.BLL.T_Specification(); var bllCodeUsed = new MesWeb.BLL.T_CodeUsed(); var bllLayout = new MesWeb.BLL.T_LayoutPicture(); var spec = bllSpec.GetModel((int)specID); hisData.SpecName = spec.SpecificationName; hisData.ODMax = spec.ODMax.ToString(); hisData.ODMin = spec.ODMin.ToString(); hisData.SpecColor = spec.SpecificationColor; hisData.RolledYield = "100%"; hisData.GeneratorTime = bllCodeUsed.GetModelList("Axis_No = '" + hisData.Axis_No + "'").FirstOrDefault().GeneratorTime.Value.ToShortDateString(); var machine = bllMachine.GetModel((int)hisData.MachineID); var machineLayout = bllLayout.GetModelList("LayoutTypeID = " + 1).Find(s => { return(s.TableRowID == machine.MachineID); }); // hisData.EmployeeName = bllEmp.GetModel((int)hisData.EmployeeID_Main).EmployeeName; hisData.EmployeeName = hisData.EmployeeID_Main; var tableName = axisNum.Year + axisNum.Month + ((int)(machine.MachineTypeID)).ToString("00"); hisData.MachineName = "<a href='/HistoryQuery/HistoryMachine/" + tableName + "," + axisNumStr + "'>" + machine.MachineName + "</a>"; retData.Code = RESULT_CODE.OK; } catch (Exception e) { log.Error("查询轴号信息失败", e); retData.Content = "查询失败,请联系管理员"; } procDetailList.Add(hisData); retData.Appendix = procDetailList; return(Json(retData)); }