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