public JsonResult LoadData(string dateMin,
string dateMax,
DeviceEnum deviceName,
string productionLine,
RFIDStationNameEnum stationName,
int page, int limit)
{
if (string.IsNullOrEmpty(dateMin))
{
_list = new List <RFIDReadCounts>();
}
else
{
string device = $"{productionLine}-{deviceName}";
string station = $"{stationName}".Substring(4);
_list = _repository.GetRFIDReadCounts(dateMin, dateMax, device, station);
}
var data = new
{
code = 0,
msg = "success",
count = _list.Count,
data = _list.Skip((page - 1) * limit).Take(limit).ToList()
};
return(Json(data));
}
/// <summary>
/// 动态加载数据
/// </summary>
/// <param name="dateMin"></param>
/// <param name="dateMax"></param>
/// <param name="deviceName"></param>
/// <param name="productionLine"></param>
/// <param name="obtStation"></param>
/// <param name="rfidStation"></param>
/// <param name="page"></param>
/// <param name="limit"></param>
/// <returns></returns>
public JsonResult LoadData(string dateMin, string dateMax
, DeviceEnum deviceName, string productionLine
, OBTStationNameEnum obtStation, RFIDStationNameEnum rfidStation
, int page, int limit)
{
if (string.IsNullOrEmpty(dateMin))
{
_list = new List <OBTRFIDRecord>();
}
else
{
string device = $"{productionLine}-{deviceName}";
string obt = $"{obtStation}";
string rfid = $"{rfidStation}";
_list = _repository.GetOBTRFIDRecords(dateMin, dateMax, device, obt, rfid);
}
var data = new
{
code = 0,
msg = "hello",
count = _list.Count,
data = _list.Skip((page - 1) * limit).Take(limit).ToList()
};
return(Json(data));
}
// GET
public IActionResult Index(string dateMin, string dateMax
, DeviceEnum deviceName, string productionLine
, OBTStationNameEnum obtStation, RFIDStationNameEnum rfidStation)
{
DetailedSiteComparisonViewModel model = new DetailedSiteComparisonViewModel()
{
DateMin = dateMin,
DateMax = dateMax,
DeviceName = deviceName,
ProductionLine = productionLine,
ObtStation = obtStation,
RfidStation = rfidStation
};
return(View(model));
}
public JsonResult LoadData(string dateMin,
string dateMax,
DeviceEnum deviceName,
string productionLine,
StationCategoryEnum stationCategory,
RFIDStationNameEnum rfidStation,
int page, int limit)
{
dynamic list = new List <object>();
int cnt = 0;
if (string.IsNullOrEmpty(dateMin))
{
_obtList = new List <OBTRecord>();
_rfidList = new List <RFIDRecord>();
//list = _obtList;
}
else
{
string device = $"{productionLine}-{deviceName}";
string station = $"{rfidStation}";
//_list = _repository.GetObtOrRfidRecords(dateMin, dateMax, device, stationCategory, station);
if (stationCategory == StationCategoryEnum.OBT)
{
_obtList = _repository.GetObtRecords(dateMin, dateMax, device, station);
cnt = _obtList.Count;
list = _obtList.Skip((page - 1) * limit).Take(limit).ToList();
}
else if (stationCategory == StationCategoryEnum.RFID)
{
_rfidList = _repository.GetRfidRecords(dateMin, dateMax, device, station);
cnt = _rfidList.Count;
list = _rfidList.Skip((page - 1) * limit).Take(limit).ToList();
}
}
var data = new
{
code = 0,
msg = "hello",
count = cnt,
category = stationCategory,
data = list
};
return(Json(data));
}
public IActionResult Index(string dateMin,
string dateMax,
DeviceEnum deviceName,
string productionLine,
RFIDStationNameEnum stationName)
{
RFIDReadCountsViewModel model = new RFIDReadCountsViewModel
{
DateMin = dateMin,
DateMax = dateMax,
DeviceName = deviceName,
ProductionLine = productionLine,
StationName = stationName
};
return(View(model));
}
/// <summary>
/// 导出excel
/// </summary>
/// <param name="dateMin"></param>
/// <param name="dateMax"></param>
/// <param name="deviceName"></param>
/// <param name="productionLine"></param>
/// <param name="obtStation"></param>
/// <param name="rfidStation"></param>
/// <returns></returns>
public JsonResult ExportFile(string dateMin, string dateMax
, DeviceEnum deviceName, string productionLine
, OBTStationNameEnum obtStation, RFIDStationNameEnum rfidStation)
{
if (string.IsNullOrEmpty(dateMin))
{
_list = new List <OBTRFIDRecord>();
}
else
{
string device = $"{productionLine}-{deviceName}";
string obt = $"{obtStation}";
string rfid = $"{rfidStation}";
_list = _repository.GetOBTRFIDRecords(dateMin, dateMax, device, obt, rfid);
}
return(Json(_list));
}
// GET
public IActionResult Index(string dateMin, string dateMax,
DeviceEnum deviceName,
string productionLine,
StationCategoryEnum stationCategory,
RFIDStationNameEnum rfidStation)
{
SiteDetailsViewModel model = new SiteDetailsViewModel
{
DateMin = dateMin,
DateMax = dateMax,
DeviceName = deviceName,
ProductionLine = productionLine,
StationCategory = stationCategory,
RfidStationName = rfidStation
};
return(View(model));
}
public JsonResult ExportFile(string dateMin,
string dateMax,
DeviceEnum deviceName,
string productionLine,
RFIDStationNameEnum stationName)
{
if (string.IsNullOrEmpty(dateMin))
{
_list = new List <RFIDReadCounts>();
}
else
{
string device = $"{productionLine}-{deviceName}";
string station = $"{stationName}".Substring(4);
_list = _repository.GetRFIDReadCounts(dateMin, dateMax, device, station);
}
return(Json(_list));
}
public JsonResult ExportFile(string dateMin,
string dateMax,
DeviceEnum deviceName,
string productionLine,
StationCategoryEnum stationCategory,
RFIDStationNameEnum rfidStation)
{
dynamic list = new List <object>();
//int cnt = 0;
if (string.IsNullOrEmpty(dateMin))
{
_obtList = new List <OBTRecord>();
_rfidList = new List <RFIDRecord>();
//list = _obtList;
}
else
{
string device = $"{productionLine}-{deviceName}";
string station = $"{rfidStation}";
//_list = _repository.GetObtOrRfidRecords(dateMin, dateMax, device, stationCategory, station);
if (stationCategory == StationCategoryEnum.OBT)
{
_obtList = _repository.GetObtRecords(dateMin, dateMax, device, station);
list = _obtList;
}
else if (stationCategory == StationCategoryEnum.RFID)
{
_rfidList = _repository.GetRfidRecords(dateMin, dateMax, device, station);
list = _rfidList;
}
}
return(Json(list));
}
