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