public IList <t_EE_ExEnergy1> InExDeviate(t_EE_ExEnergy1 ex)
{
string sql = $"DELETE FROM t_EE_ExEnergy WHERE PID = {ex.PID} AND CID = {ex.CID} AND RecordTime = '{ex.RecordTime}'; " +
$" INSERT INTO t_EE_ExEnergy(DID,PID,enerUserTypeID, CID, BudgetEnergy, ActualEnergy, Proportion, ProportionValue, People, Area, CODID, Purpose, Temperature, RecordTime,Conclusion) output inserted.*" +
$" VALUES({ex.DID},{ex.PID},{ex.enerUserTypeID},{ex.CID},{ex.BudgetEnergy},{ex.ActualEnergy},{ex.Proportion},{ex.ProportionValue},{ex.People},{ex.Area},{ex.CODID},'{ex.Purpose}','{ex.Temperature}','{ex.RecordTime}','');";
return(SQLQuery <t_EE_ExEnergy1>(sql));
}
public IList <t_EE_ExEnergy1> InExDeviate(t_EE_ExEnergy1 err)
{
try
{
return(_dbFactory.exEnergy.InExDeviate(err));
}
catch (Exception ex)
{
throw ex;
}
}
