// get datasource
public List <RW_FULL_COF_FLUID> getDataSource()
{
SqlConnection conn = MSSQLDBUtils.GetDBConnection();
conn.Open();
List <RW_FULL_COF_FLUID> list = new List <RW_FULL_COF_FLUID>();
RW_FULL_COF_FLUID obj = null;
String sql = "Use[rbi] Select[ID]" +
",[Cp]" +
",[k]" +
",[GFFTotal]" +
",[Kv_n]" +
",[ReleasePhase]" +
",[Cd]" +
",[Ptrans]" +
",[NBP]" +
",[Density]" +
",[MW]" +
",[R]" +
",[Ps]" +
",[Ts]" +
",[Patm]" +
",[fact_di]" +
",[fact_mit]" +
",[fact_AIT]" +
",[g]" +
",[h]" +
"From [dbo].[RW_FULL_COF_FLUID] ";
try
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
using (DbDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
if (reader.HasRows)
{
obj = new RW_FULL_COF_FLUID();
obj.ID = reader.GetInt32(0);
if (!reader.IsDBNull(1))
{
obj.Cp = reader.GetFloat(1);
}
if (!reader.IsDBNull(2))
{
obj.k = reader.GetFloat(2);
}
if (!reader.IsDBNull(3))
{
obj.GFFTotal = reader.GetFloat(3);
}
if (!reader.IsDBNull(4))
{
obj.Kv_n = reader.GetFloat(4);
}
if (!reader.IsDBNull(5))
{
obj.ReleasePhase = reader.GetString(5);
}
if (!reader.IsDBNull(6))
{
obj.Cd = reader.GetFloat(6);
}
if (!reader.IsDBNull(7))
{
obj.Ptrans = reader.GetFloat(7);
}
if (!reader.IsDBNull(8))
{
obj.NBP = reader.GetFloat(8);
}
if (!reader.IsDBNull(9))
{
obj.Density = reader.GetFloat(9);
}
if (!reader.IsDBNull(10))
{
obj.MW = reader.GetFloat(10);
}
if (!reader.IsDBNull(11))
{
obj.R = reader.GetFloat(11);
}
if (!reader.IsDBNull(12))
{
obj.Ps = reader.GetFloat(12);
}
if (!reader.IsDBNull(13))
{
obj.Ts = reader.GetFloat(13);
}
if (!reader.IsDBNull(14))
{
obj.Patm = reader.GetFloat(14);
}
if (!reader.IsDBNull(15))
{
obj.fact_di = reader.GetFloat(15);
}
if (!reader.IsDBNull(16))
{
obj.fact_mit = reader.GetFloat(16);
}
if (!reader.IsDBNull(17))
{
obj.fact_AIT = reader.GetFloat(17);
}
if (!reader.IsDBNull(18))
{
obj.g = reader.GetFloat(18);
}
if (!reader.IsDBNull(19))
{
obj.h = reader.GetFloat(19);
}
list.Add(obj);
}
}
}
}
catch (Exception e)
{
MessageBox.Show(e.ToString(), "GET DATA FAIL");
}
finally
{
conn.Close();
conn.Dispose();
}
return(list);
}
public void add(RW_FULL_COF_FLUID obj)
{
DAL.add(obj.ID, obj.Cp, obj.k, obj.GFFTotal, obj.Kv_n, obj.ReleasePhase, obj.Cd, obj.Ptrans, obj.NBP, obj.Density, obj.MW, obj.R, obj.Ps, obj.Ts, obj.Patm, obj.fact_di, obj.fact_mit, obj.fact_AIT, obj.g, obj.h);
}