/// <summary>
///
/// </summary>
/// <param name="device"></param>
/// <param name="data"></param>
/// <returns></returns>
static public object Insert(XD202Device device, XD202Data data)
{
string sql = "insert into tblMeasureSluiceData(DeviceID, DT, BeforeWL, BehindWL, InstantFlux, Height, UsedAmount, RemainedAmount) " +
"values(@DeviceID, @DT, @BeforeWL, @BehindWL, @InstantFlux, @Height, @UsedAmount, @RemainedAmount)";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter p = null;
p = new SqlParameter("@DeviceID", device.ID);
cmd.Parameters.Add(p);
p = new SqlParameter("@DT", data.DT);
cmd.Parameters.Add(p);
AddParameter(cmd, "@BeforeWL", data.BeforeWaterLevel);
AddParameter(cmd, "@BehindWL", data.BehindWaterLevel);
AddParameter(cmd, "@InstantFlux", data.InstantFlux);
AddParameter(cmd, "@Height", data.Height);
AddParameter(cmd, "@RemainedAmount", data.RemainAmount);
AddParameter(cmd, "@UsedAmount", 0);
return(CSDBI.CSDB.ExecuteScalar(cmd));
}
/// <summary>
///
/// </summary>
/// <param name="device"></param>
/// <param name="data"></param>
/// <returns></returns>
public static object Insert(XD202Device device, XD202Data data)
{
string sql = "insert into tblMeasureSluiceData(DeviceID, DT, BeforeWL, BehindWL, InstantFlux, Height, UsedAmount, RemainedAmount) " +
"values(@DeviceID, @DT, @BeforeWL, @BehindWL, @InstantFlux, @Height, @UsedAmount, @RemainedAmount)";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter p = null;
p = new SqlParameter("@DeviceID", device.ID);
cmd.Parameters.Add(p);
p = new SqlParameter("@DT", data.DT);
cmd.Parameters.Add(p);
AddParameter(cmd, "@BeforeWL", data.BeforeWaterLevel);
AddParameter(cmd, "@BehindWL", data.BehindWaterLevel );
AddParameter(cmd, "@InstantFlux", data.InstantFlux);
AddParameter(cmd, "@Height", data.Height);
AddParameter(cmd, "@RemainedAmount", data.RemainAmount);
AddParameter(cmd, "@UsedAmount", 0);
return CSDBI.Instance.ExecuteScalar(cmd);
}