public InstrumentFault GetFault(string FaultID)
{
InstrumentFault instrumentFault = null;
string sqlCommandText = ModuleConfiguration.SQL_CMD_SelectFaultById;
var dbResult = this.dmlOperable.ExeReader(sqlCommandText, new Dictionary <string, object>()
{
{ "@ID", long.Parse(FaultID) }
});
if (dbResult != null && dbResult.Count == 1)
{
instrumentFault = new InstrumentFault()
{
FaultTime = (DateTime?)dbResult[0]["FaultTime"],
Fault = new Fault()
{
ID = dbResult[0]["ID"].ToString(),
FaultType = dbResult[0]["FaultType"] == null ? 0 : (int?)dbResult[0]["FaultType"],
FaultCode = (string)dbResult[0]["FaultCode"],
FaultMessage = (string)dbResult[0]["FaultMessage"]
},
Instrument = new Instrument()
{
ID = dbResult[0]["InstrumentID"].ToString()
}
};
}
return(instrumentFault);
}
public string AddInstrumentFault(InstrumentFault InstrumentFault)
{
//if (InstrumentFault == null || InstrumentFault.Fault == null|| string.IsNullOrEmpty(InstrumentFault.Fault.ID))
//{
// throw new IDNullException("仪器故障ID不可为空！");
//}
string sqlCommandText = ModuleConfiguration.SQL_CMD_InsertInstrumentFault;
this.dmlOperable.ExeSql(sqlCommandText, new Dictionary <string, object>()
{
//{ "@ID", long.Parse(InstrumentFault.Fault.ID)},
{ "@InstrumentID", InstrumentFault.Instrument.ID },
{ "@FaultTime", InstrumentFault.FaultTime },
{ "@FaultType", InstrumentFault.Fault.FaultType },
{ "@FaultCode", InstrumentFault.Fault.FaultCode },
{ "@FaultMessage", InstrumentFault.Fault.FaultMessage }
});
return(GenerateInstrumentFaultID(0)); //InstrumentFault.Fault.ID;
}
