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