public static int UpdateHistorialData(DataDuDoan sl, double capacity)
{
string sql = "UPDATE DuLieuDuDoan SET capacity_db = @cap, ghi_db = @ghi , envtemp_db = @evn " +
" WHERE time_db = @time ";
SqlParameter param1 = new SqlParameter("@time", SqlDbType.DateTime);
param1.Value = sl.date;
SqlParameter param2 = new SqlParameter("@cap", SqlDbType.Float);
param2.Value = capacity;
SqlParameter param3 = new SqlParameter("@ghi", SqlDbType.Float);
param3.Value = sl.ghi;
SqlParameter param4 = new SqlParameter("@evn", SqlDbType.Float);
param4.Value = sl.air_temperature;
return(DAO.UpdateDataBySQLWithParametes(sql, param1, param2, param3, param4));
}
public static int InsertHistorialData(DataDuDoan sl, double capacity)
{
string sql = "INSERT INTO DuLieuDuDoan ( time_db , capacity_db, ghi_db , envtemp_db ) " +
"VALUES ( @time, @cap, @ghi, @evn )";
SqlParameter param1 = new SqlParameter("@time", SqlDbType.DateTime);
param1.Value = sl.date;
SqlParameter param2 = new SqlParameter("@cap", SqlDbType.Float);
param2.Value = capacity;
SqlParameter param3 = new SqlParameter("@ghi", SqlDbType.Float);
param3.Value = sl.ghi;
SqlParameter param4 = new SqlParameter("@evn", SqlDbType.Float);
param4.Value = sl.air_temperature;
return(DAO.UpdateDataBySQLWithParametes(sql, param1, param2, param3, param4));
}