private void AddTraceInfo(AcqLineItemMDL linfInfo, string station_id, int pre_count)
{
try
{
AcqLineTraceMDL traceInfo = new AcqLineTraceMDL();
//EMS+产线编号
traceInfo.ACQID = COMM.CodeComm.GetRandomSeqNum(DateTime.Now, linfInfo.EMS + linfInfo.PLID);
traceInfo.BEG_COUNT = pre_count;
traceInfo.ACQ_DATE = DateTime.Now;
traceInfo.EMS = linfInfo.EMS;
traceInfo.PLID = linfInfo.PLID;
traceInfo.SEQID = linfInfo.UNITID;
traceInfo.STATIONID = station_id;
AcqTraceDAL traceDal = new AcqTraceDAL();
int ret = traceDal.AddAcqTrace(traceInfo);
if (ret <= 1)
{
CLog.WriteStationLog("TRACE_ADD_ERROR", station_id);
}
}
catch (System.Exception ex)
{
CLog.WriteStationLog(linfInfo.PLID + "TRACE_ADD_ERROR", ex.Message.ToString());
}
}
/// <summary>
/// 更新记录数据
/// </summary>
/// <param name="mdl"></param>
/// <returns></returns>
public int UpdateAcqTrace(AcqLineTraceMDL mdl)
{
int ret = 0;
string strSql = string.Empty;
try
{
strSql = "UPDATE tlb_acq_trace SET SEQID='{0}',PLID='{1}',EMS = {2},STATIONID='{3}' WHERE ACQID='{4}'";
strSql = string.Format(strSql, mdl.SEQID, mdl.PLID, mdl.EMS, mdl.STATIONID, mdl.ACQID);
ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
return(ret);
}
catch
{
throw;
}
}
/// <summary>
/// 添加采集数据
/// </summary>
/// <param name="mdl"></param>
/// <returns></returns>
public int AddAcqTrace(AcqLineTraceMDL mdl)
{
int ret = 0;
string strSql = string.Empty;
try
{
strSql = "insert into tlb_acq_trace (ACQID,ACQ_DATE,SEQID,PLID,EMS,STATIONID,BEG_COUNT,ERROR)" +
"values('{0}','{1}','{2}','{3}',{4},'{5}',{6},'{7}')";
strSql = string.Format(strSql, mdl.ACQID, mdl.ACQ_DATE.ToString("yyyy-MM-dd HH:mm:ss"), mdl.SEQID, mdl.PLID, mdl.EMS, mdl.STATIONID, mdl.BEG_COUNT, mdl.ERROR);
ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
return(ret);
}
catch
{
throw;
}
}
