public void edit(RW_FULL_COF_HOLE_SIZE obj) { DAL.edit(obj.ID, obj.GFF_n, obj.An, obj.Wn, obj.t_n, obj.ld_max_n, obj.mass_add_n, obj.mass_avail_n, obj.rate_n, obj.ld_n, obj.mass_n, obj.eneff_n, obj.factIC_n, obj.ReleaseType_n); }
public void delete(RW_FULL_COF_HOLE_SIZE obj) { DAL.delete(obj.ID); }
// get Datasource public List <RW_FULL_COF_HOLE_SIZE> getDataSource() { SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); List <RW_FULL_COF_HOLE_SIZE> list = new List <RW_FULL_COF_HOLE_SIZE>(); RW_FULL_COF_HOLE_SIZE obj = null; String sql = "Use[rbi] Select [ID]" + ",[GFF_n]" + ",[An]" + ",[Wn]" + ",[t_n]" + ",[ld_max_n]" + ",[mass_add_n]" + ",[mass_avail_n]" + ",[rate_n]" + ",[ld_n]" + ",[mass_n]" + ",[eneff_n]" + ",[factIC_n]" + ",[ReleaseType_n]" + "From [dbo].[RW_FULL_COF_HOLE_SIZE] "; 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_HOLE_SIZE(); obj.ID = reader.GetInt32(0); obj.GFF_n = reader.GetString(1); if (!reader.IsDBNull(2)) { obj.An = reader.GetFloat(2); } if (!reader.IsDBNull(3)) { obj.Wn = reader.GetFloat(3); } if (!reader.IsDBNull(4)) { obj.t_n = reader.GetFloat(4); } if (!reader.IsDBNull(5)) { obj.ld_max_n = reader.GetFloat(5); } if (!reader.IsDBNull(6)) { obj.mass_add_n = reader.GetFloat(6); } if (!reader.IsDBNull(7)) { obj.mass_avail_n = reader.GetFloat(7); } if (!reader.IsDBNull(8)) { obj.rate_n = reader.GetFloat(8); } if (!reader.IsDBNull(9)) { obj.ld_n = reader.GetFloat(9); } if (!reader.IsDBNull(10)) { obj.mass_n = reader.GetFloat(10); } if (!reader.IsDBNull(11)) { obj.eneff_n = reader.GetFloat(11); } if (!reader.IsDBNull(12)) { obj.factIC_n = reader.GetFloat(12); } list.Add(obj); } } } } catch (Exception e) { MessageBox.Show(e.ToString(), "GET DATA FAIL"); } finally { conn.Close(); } return(list); }