/// <summary>
/// 获取当前产量 一般个时钟后期定义一次
/// </summary>
/// <param name="curUnit">当前数据量</param>
/// <returns></returns>
//public PDNumberUnit GetCurrentCount(int curUnit,DateTime acqTime)
//{
// try
// {
// PDNumberUnit unit = new PDNumberUnit();
// CheckReload(acqTime);
// int currentcount = GetTimeRangCount(acqTime);
// //if (startCount != currentcount && startCount < currentcount)
// // startCount = currentcount;
// ///当前采集数量的减去已采集的数量
// unit.dataCount = curUnit - startCount;
// int index = AddProductList(unit, acqTime);
// if (index > 0)
// return lists[index];
// else
// return null;
// //unit.StartDataTime = startTime;
// //unit.EndDataTime = endTime;
// }
// catch (Exception ex)
// {
// CLog.WriteErrLog(ex.Message.ToString());
// }
// return null;
//}
/// <summary>
/// 获取在当前生产区间范围的采集信息
/// </summary>
/// <param name="PDUnit"></param>
private AcqCountMDL GetAcqInfo(AcqCountMDL PDUnit, DateTime acqTime)
{
AcqCountMDL acqCount = new AcqCountMDL();
try
{
CLog.WriteStationLog("ST400", lists.Count.ToString());
for (int i = 0; i < lists.Count; i++)
{
//判断在时间范围内
if (lists[i].rang.IsInRange(acqTime))
{
acqCount.TID = i;
acqCount.TagName = i.ToString();
acqCount.StartTime = lists[i].rang.StartTime;
acqCount.EndTime = lists[i].rang.EndTime;
acqCount.CurrentCount = PDUnit.CurrentCount;
CLog.WriteStationLog("ST400", acqCount.CurrentCount.ToString() + acqCount.StartTime.ToLongDateString());
return(acqCount);
}
}
return(null);
}
catch (Exception ex)
{
CLog.WriteErrLog(ex.Message.ToString());
}
return(null);
}
/// <summary>
/// 更新产品计划信息
/// </summary>
/// <param name="info"></param>
public int UpdateAcqCountItem(AcqCountMDL mdl)
{
int ret = 0;
string strSql = string.Empty;
try
{
string startTime = String.Format("{0:yyyy-MM-dd HH:mm:ss}", mdl.StartTime); //4-10-2010 17:16:50\
string endTime = String.Format("{0:yyyy-MM-dd HH:mm:ss}", mdl.EndTime);
//(plan_id,pline_id,station_id,start_time,end_time,brakeid,plan_num,actual_num,shift,create_time,remark)
strSql = "update acq_count_list set tagName='{0}',StartTime='{1}',EndTime='{2}',CurrentCount='{3}',Remark='{4}' "
+ " where tid='{5}'";
strSql = string.Format(strSql, mdl.TagName, startTime, endTime, mdl.StartTime,
mdl.CurrentCount, mdl.Remark);
// ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
ret = SQLiteDBHelper.ExecuteNonQuery(strSql);
return(ret);
}
catch (Exception ex)
{
CLog.WriteErrLogInTrace(ex.Message);
return(0);
}
}
/// <summary>
/// 插入单项产品计划
/// </summary>
/// <param name="mdl"></param>
/// <returns></returns>
public int InsertAcqCountItem(AcqCountMDL mdl)
{
int ret = 0;
string strSql = string.Empty;
try
{
strSql = "insert into acq_count_list (tagName,StartTime,EndTime,CurrentCount,Remark)" +
"values('{0}','{1}','{2}','{3}','{4}')";
//2015-05-11 08:30:00
string startTime = String.Format("{0:yyyy-MM-dd HH:mm:ss}", mdl.StartTime); //4-10-2010 17:16:50\
string endTime = String.Format("{0:yyyy-MM-dd HH:mm:ss}", mdl.EndTime);
strSql = string.Format(strSql, mdl.TagName, startTime, endTime, mdl.CurrentCount, mdl.Remark);
//ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
ret = SQLiteDBHelper.ExecuteNonQuery(strSql);
return(ret);
}
catch (Exception ex)
{
CLog.WriteErrLogInTrace(ex.Message);
return(0);
}
}
public int UpdateAcqCountValue(AcqCountMDL mdl)
{
int ret = 0;
string strSql = string.Empty;
try
{
//(plan_id,pline_id,station_id,start_time,end_time,brakeid,plan_num,actual_num,shift,create_time,remark)
strSql = "update acq_count_list set CurrentCount='{0}' "
+ " where tagName='{1}'";
strSql = string.Format(strSql, mdl.CurrentCount, mdl.TagName);
//ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
ret = SQLiteDBHelper.ExecuteNonQuery(strSql);
return(ret);
}
catch (Exception ex)
{
CLog.WriteErrLogInTrace(ex.Message);
return(0);
}
}
