public void edit(RW_PRIMARY_FLUID obj) { DAL.edit(obj.ID, obj.FluidName, obj.NBP, obj.MW, obj.Density, obj.ChemicalFactor, obj.HealthDegree, obj.Flammability, obj.Reactivity); }
public void delete(RW_PRIMARY_FLUID obj) { DAL.delete(obj.ID); }
public List <RW_PRIMARY_FLUID> getDataSource() { List <RW_PRIMARY_FLUID> list = new List <RW_PRIMARY_FLUID>(); RW_PRIMARY_FLUID obj = null; SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); String sql = "USE [rbi] " + "SELECT [ID]" + ",[FluidName]" + ",[NBP]" + ",[MW]" + ",[Density]" + ",[ChemicalFactor]" + ",[HealthDegree]" + ",[Flammability]" + ",[Reactivity]" + " FROM [rbi].[dbo].[RW_PRIMARY_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_PRIMARY_FLUID(); obj.ID = reader.GetInt32(0); if (!reader.IsDBNull(1)) { obj.FluidName = reader.GetString(1); } if (!reader.IsDBNull(2)) { obj.NBP = reader.GetFloat(2); } if (!reader.IsDBNull(3)) { obj.MW = reader.GetFloat(3); } if (!reader.IsDBNull(4)) { obj.Density = reader.GetFloat(4); } if (!reader.IsDBNull(5)) { obj.ChemicalFactor = reader.GetInt32(5); } if (!reader.IsDBNull(6)) { obj.HealthDegree = reader.GetInt32(6); } if (!reader.IsDBNull(7)) { obj.Flammability = reader.GetInt32(7); } if (!reader.IsDBNull(8)) { obj.Reactivity = reader.GetInt32(8); } list.Add(obj); } } } } catch { MessageBox.Show("GET DATA SOURCE FAIL!", "ERROR!"); } finally { conn.Close(); } return(list); }