/// <summary>
/// 添加设备操作日志记录
/// </summary>
/// <param name="log">日志对象</param>
/// <returns></returns>
public bool AddDeviceActionLog(DeviceActionLog log)
{
try
{
bool isAdd = false;
if (log != null)
{
using (DataModels.HnfactoryautodbDB dataContext = new DataModels.HnfactoryautodbDB())
{
//日志流水编号{设备编号}-{年月日时分秒}
string strNewLogCode = string.Format("Log-{0}-{1:yyMMddHHmmss}", log.SensorId, DateTime.Now);
log.DeviceActionLogId = strNewLogCode;
DataModels.LDeviceactionlog data = log.ToData();
dataContext.Insert <DataModels.LDeviceactionlog>(data);
isAdd = true;
}
}
return(isAdd);
}
catch
{
throw;
}
}
/// <summary>
///
/// </summary>
/// <param name="log"></param>
/// <param name="strDeviceId"></param>
/// <returns></returns>
public bool AddDeviceProduceLogPar(DeviceProduceLogPar log, string strDeviceId)
{
try
{
bool isAdd = false;
if (log != null)
{
using (DataModels.HnfactoryautodbDB dataContext = new DataModels.HnfactoryautodbDB())
{
//日志流水编号{设备编号}-{年月日时分秒}
string strNewLogCode = string.Format("{0}-{1}-{2:yyMMddHHmmss}", strDeviceId, log.ParType.ToString(), DateTime.Now);
log.LogParId = strNewLogCode;
DataModels.LDeviceproducelogpar data = log.ToData();
dataContext.Insert <DataModels.LDeviceproducelogpar>(data);
isAdd = true;
}
}
return(isAdd);
}
catch
{
throw;
}
}
/// <summary>
/// 添加工艺子流程步骤日志表
/// </summary>
/// <param name="log"></param>
/// <returns></returns>
public bool AddExProcessStepLog(ProcessData.ExProcessStepLog log)
{
try
{
bool isAdd = false;
if (log != null)
{
using (DataModels.HnfactoryautodbDB dataContext = new DataModels.HnfactoryautodbDB())
{
//获取已经执行的步骤数量
string strSQL = "select count(*) from l_exprocesssteplog where ExProcessLogId=?ExProcessLogId";
List <MySqlParameter> sqlParameters = new List <MySqlParameter>();
sqlParameters.Add(new MySqlParameter("?ExProcessLogId", log.ExProcessLogId));
int iNowSum = Convert.ToInt32(MySqlHelper.ExecuteScalar(CommandType.Text, strSQL, sqlParameters.ToArray()));
//{工艺子流程日志编号}-{2位流水号}
string strNewLogCode = string.Format("{0}-{1:00}", log.ExProcessLogId, iNowSum);
log.ExProcessStepLogId = strNewLogCode;
DataModels.LExprocesssteplog data = log.ToData();
dataContext.Insert <DataModels.LExprocesssteplog>(data);
isAdd = true;
}
}
return(isAdd);
}
catch
{
throw;
}
}
/// <summary>
/// 添加工艺主流程日志
/// </summary>
/// <param name="log">日志对象</param>
/// <returns></returns>
public bool AddMainProcessLog(ProcessData.ProcessLog log)
{
try
{
bool isAdd = false;
if (log != null)
{
//提取得到新的流水号
//{生产线编号}-{年月日}-{2位流水号}
//string strYMD = DateTime.Now.ToString("yyMMdd");
using (DataModels.HnfactoryautodbDB dataContext = new DataModels.HnfactoryautodbDB())
{
//先查询日志集合
string strSQL = "select count(*) from l_processlog where AssemblyLineId=?AssemblyLineId and DATE_FORMAT(created,'%Y%m%d') = ?NowDate";
List <MySqlParameter> sqlParameters = new List <MySqlParameter>
{
new MySqlParameter("?AssemblyLineId", log.AssemblyLineId)
, new MySqlParameter("?NowDate", log.Created)
};
int iNowSum = Convert.ToInt32(MySqlHelper.ExecuteScalar(CommandType.Text, strSQL, sqlParameters.ToArray()));
string strNewLogCode = string.Format("{0}-{1:yyMMdd}-{2:00}", log.AssemblyLineId, log.Created, iNowSum);
log.ProcessLogId = strNewLogCode;
DataModels.LProcesslog data = log.ToData();
dataContext.Insert <DataModels.LProcesslog>(data);
isAdd = true;
}
}
return(isAdd);
}
catch
{
throw;
}
}
/// <summary>
/// 添加工艺子流程步骤参数日志数据
/// </summary>
/// <param name="log"></param>
/// <returns></returns>
public bool AddExProcessStepParLog(ProcessData.ExProcessStepParsLog log)
{
try
{
bool isAdd = false;
if (log != null)
{
using (DataModels.HnfactoryautodbDB dataContext = new DataModels.HnfactoryautodbDB())
{
DataModels.LExprocessstepparslog data = log.ToData();
dataContext.Insert <DataModels.LExprocessstepparslog>(data);
isAdd = true;
}
}
return(isAdd);
}
catch
{
throw;
}
}
