public int GetChangeTimeByUnit(string lineID, string unitid)
{
int ct = 0;
try
{
DataSet dataSet = null;
string strSql = "SELECT * FROM tlb_line_change WHERE PLID='{0}' AND UNITID='{1}' ";
strSql = string.Format(strSql, lineID, unitid);
dataSet = MySqlDBHelper.ExecuteDataSet(MySqlDBHelper.Conn, CommandType.Text, strSql);
if (dataSet == null || dataSet.Tables[0].Rows.Count <= 0)
{
return(0);
}
///获取换型时间秒为单位
foreach (DataRow row in dataSet.Tables[0].Rows)
{
ct += ChangeTimeMDL.ParseDataRow(row).TIME_MIG;
}
return(ct);
}
catch
{
throw;
}
}
/// <summary>
/// 处理换型添加记录
/// </summary>
/// <param name="unit"></param>
/// <returns></returns>
public int ProcessAcqLineData(string lineID, string unitid, EMSUnit unit)
{
int ret = 0;
try
{
ChangeTimeDAL dal = new ChangeTimeDAL();
ChangeTimeMDL mdl = new ChangeTimeMDL();
unit.SetTime = DateTime.Now;
mdl.SetTID(unit.SetTime, lineID, unit.EMS, 0);
mdl.PLID = lineID;
mdl.UNITID = unitid;
mdl.PER_PN = this.ems.EMS.ToString();
mdl.CUR_PN = unit.EMS.ToString();
mdl.TIME_MIG = TimeRange.ExecDateDiffSecond(this.ems.SetTime, unit.SetTime);
mdl.PER_TIME = this.ems.SetTime;
mdl.CUR_TIME = DateTime.Now;
int count = dal.IsUionCOUint(unitid, lineID);
if (count <= 0)
{
mdl.SetTID(unit.SetTime, lineID, unit.EMS, 1);
ret = dal.AddChangeUnitItem(mdl);
}
else
{
count += 1;
mdl.SetTID(unit.SetTime, lineID, unit.EMS, count);
ret = dal.AddChangeUnitItem(mdl);
}
LoadEMS(unit);
return(ret);
}
catch
{
throw;
}
}
/// <summary>
/// 获取换型时间
/// </summary>
/// <param name="lineID"></param>
/// <param name="range"></param>
/// <returns>minutes</returns>
public int GetChangeTime(string lineID, TimeRange range, ref string ems)
{
int ct = 0;
try
{
DataSet dataSet = null;
string strSql = "SELECT * FROM tlb_line_change WHERE PLID='{0}' AND CUR_TIME BETWEEN '{1}' AND '{2}'";
strSql = string.Format(strSql, lineID, range.StartTime, range.EndTime);
dataSet = MySqlDBHelper.ExecuteDataSet(MySqlDBHelper.Conn, CommandType.Text, strSql);
if (dataSet == null || dataSet.Tables[0].Rows.Count <= 0)
{
return(0);
}
foreach (DataRow row in dataSet.Tables[0].Rows)
{
ChangeTimeMDL dml = ChangeTimeMDL.ParseDataRow(row);
ct += dml.TIME_MIG;
ems += dml.CUR_PN + ",";
}
return(ct);
}
catch
{
throw;
}
}
//public int
public List <ChangeTimeMDL> GetChangeTimeItems(string lineID, TimeRange range)
{
List <ChangeTimeMDL> ret = new List <ChangeTimeMDL>();
try
{
DataSet dataSet = null;
string strSql = "SELECT * FROM tlb_line_change WHERE PLID='{0}' AND CUR_TIME BETWEEN '{1}' AND '{2}'";
strSql = string.Format(strSql, lineID, range.StartTime, range.EndTime);
dataSet = MySqlDBHelper.ExecuteDataSet(MySqlDBHelper.Conn, CommandType.Text, strSql);
if (dataSet == null || dataSet.Tables[0].Rows.Count <= 0)
{
return(null);
}
foreach (DataRow row in dataSet.Tables[0].Rows)
{
ChangeTimeMDL dml = ChangeTimeMDL.ParseDataRow(row);
ret.Add(dml);
}
return(ret);
}
catch
{
throw;
}
}
public int UpdateChangeUnitItem(ChangeTimeMDL mdl)
{
int ret = 0;
string strSql = string.Empty;
try
{
strSql = "UPDATE tlb_line_change SET PLID='{0}' ,UNITID='{1}',PER_PN='{2}',CUR_PN='{3}',CUR_TIME='{4}',TIME_MIG={5},PER_TIME='{6}' WHERE SEQID='{7}'";
strSql = string.Format(strSql, mdl.PLID, mdl.UNITID, mdl.PER_PN, mdl.CUR_PN, mdl.CUR_TIME.ToString("yyyy-MM-dd HH:mm:ss"),
mdl.TIME_MIG, mdl.PER_TIME.ToString("yyyy-MM-dd HH:mm:ss"), mdl.SEQID);
ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
return(ret);
}
catch
{
throw;
}
}
/// <summary>
/// 添加采集数据单元
/// </summary>
/// <param name="mdl"></param>
/// <returns></returns>
public int AddChangeUnitItem(ChangeTimeMDL mdl)
{
int ret = 0;
string strSql = string.Empty;
try
{
strSql = "insert into tlb_line_change ( SEQID,PLID,UNITID,PER_PN,CUR_PN,CUR_TIME,TIME_MIG,PER_TIME)" +
"values('{0}','{1}','{2}','{3}','{4}','{5}',{6},'{7}')";
strSql = string.Format(strSql, mdl.SEQID, mdl.PLID, mdl.UNITID, mdl.PER_PN, mdl.CUR_PN, mdl.CUR_TIME.ToString("yyyy-MM-dd HH:mm:ss"),
mdl.TIME_MIG, mdl.PER_TIME.ToString("yyyy-MM-dd HH:mm:ss"));
ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
return(ret);
}
catch
{
throw;
}
}
