/// <summary>
/// 获取生产线所有设备传感器当前状态
/// </summary>
/// <param name="strAssemblyLineId">生产线编号</param>
/// <returns></returns>
public DeviceProduceLogCollection GetDeviceProduceLogCollection(string strAssemblyLineId)
{
try
{
DeviceProduceLogCollection items = new DeviceProduceLogCollection();
using (DataModels.HnfactoryautodbDB dataContext = new DataModels.HnfactoryautodbDB())
{
var datas = (from c in dataContext.VDeviceproducelogs
where c.AssemblyLineId == strAssemblyLineId
select c
).ToList();
foreach (DataModels.VDeviceproducelog data in datas)
{
DeviceProduceLog item = new DeviceProduceLog(data);
items.Add(item);
}
}
return(items);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 添加设备状态日志记录
/// </summary>
/// <param name="log"></param>
/// <returns></returns>
public bool AddDeviceProduceLog(DeviceProduceLog log)
{
try
{
bool isAdd = false;
if (log != null)
{
using (DataModels.HnfactoryautodbDB dataContext = new DataModels.HnfactoryautodbDB())
{
//日志流水编号{设备编号}-{年月日时分秒}
string strNewLogCode = string.Format("{0}-{1:yyMMddHHmmss}", log.DeviceId, DateTime.Now);
log.DeviceProduceLogId = strNewLogCode;
//DataModels.LDeviceproducelog data = log.ToData();
//dataContext.Insert<DataModels.LDeviceproducelog>(data);
#region 调用存储过程方式来添加日志
string strProName = "proc_AddDeviceProduceLog";
List <MySqlParameter> sqlParameters = new List <MySqlParameter>
{
new MySqlParameter("?mDeviceProduceLogId", log.DeviceProduceLogId)
, new MySqlParameter("?mDeviceId", log.DeviceId)
, new MySqlParameter("?mCreated", log.Created)
, new MySqlParameter("?mDeviceStatus", Enum.GetName(log.DeviceStatus.GetType(), log.DeviceStatus))
, new MySqlParameter("?mSensorId", log.SensorId)
, new MySqlParameter("?mValueType", log.ValueType)
, new MySqlParameter("?mSensorStatusValue", log.SensorStatusValue)
, new MySqlParameter("?mSensorStatus", Enum.GetName(log.SensorStatus.GetType(), log.SensorStatus))
, new MySqlParameter("?mParType", log.ParType)
, new MySqlParameter("?mParUnit", log.ParUnit)
, new MySqlParameter("?mParValue", log.ParValue)
};
MySqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, strProName, sqlParameters.ToArray());
#endregion
isAdd = true;
}
}
return(isAdd);
}
catch
{
throw;
}
}