public static OracleParameter SetParams(string name, OperationsId value)
{
return new OracleParameter
{
ParameterName = name,
Direction = ParameterDirection.Input,
OracleDbType = OracleDbType.Int32,
Value = value
};
}
protected List<OracleParameter> MandatoryParams(OperationsId operationId, int iCnvNo, string heatNumber, int par1)
{
return new List<OracleParameter>
{
SetParams("OPERATION_ID", operationId),
SetParams("CNV_NO", iCnvNo),
SetParams("HEAT_NO", heatNumber),
SetParams("PAR1", par1)
};
}
protected List<OracleParameter> MandatoryParams(OperationsId operationId, int iCnvNo)
{
return new List<OracleParameter>
{
SetParams("OPERATION_ID", operationId),
SetParams("CNV_NO", iCnvNo)
};
}
protected DateTime GetLastOperationTime(OperationsId operationId, int iCnvNo, string heatNumber, int par1)
{
const string sql = "SELECT MAX(EVENTTIME) FROM BOF_TELEGRAMS " +
"WHERE OPERATION_ID = :OPERATION_ID AND CV_NO = :CV_NO AND HEAT_NO = :HEAT_NO AND PAR1 = :PAR1 ";
var parametres = MandatoryParams(operationId, iCnvNo, heatNumber, par1);
var res = Execute(sql, parametres.ToArray());
var ret = res.Read() ? DateTime.Parse(CheckDateForNull(res[0].ToString())) : DateTime.MinValue;
res.Close();
return ret;
}
protected string GetLastHeatNumber(OperationsId operationId, int iCnvNo)
{
const string sql = "SELECT PAR1 FROM BOF_TELEGRAMS " +
"WHERE OPERATION_ID = :OPERATION_ID AND CV_NO = :CV_NO " +
"AND EVENTTIME = (SELECT MAX(EVENTTIME) FROM BOF_TELEGRAMS WHERE OPERATION_ID = :OPERATION_ID AND CV_NO = :CV_NO)";
var parametres = MandatoryParams(operationId, iCnvNo);
var res = Execute(sql, parametres.ToArray());
var ret = res.Read() ? res[0].ToString() : "0";
res.Close();
return ret;
}
private bool InsertTelegrams(OperationsId oparationId, DateTime eventTime, int iCnvNr, string heatNumber, ICollection<string> param)
{
const string sql = "INSERT INTO BOF_TELEGRAMS (OPERATION_ID, CV_NO, HEAT_NO, EVENTTIME, PAR1, PAR2, PAR3, PAR4, PAR5, PAR6, PAR7, PAR8, PAR9) " +
"VALUES (:OPERATION_ID, :CV_NO, :HEAT_NO, :EVENTTIME, :PAR1, :PAR2, :PAR3, :PAR4, :PAR5, :PAR6, :PAR7, :PAR8, :PAR9) ";
var parametres = MandatoryParams(oparationId, iCnvNr, heatNumber);
parametres.Add(SetParams("EVENTTIME", eventTime));
parametres.AddRange(param.Select((t, i) => SetParams(string.Format("PAR{0}", i + 1), t)));
for (var i = param.Count; i < 9; i++)
{
parametres.Add(SetParams(string.Format("PAR{0}", i + 1), ""));
}
return ExecuteNonQuery(sql, parametres.ToArray()) > -1;
}
