public List <COMPONENT_MODELLING> getDataSource() { SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); List <COMPONENT_MODELLING> list = new List <COMPONENT_MODELLING>(); COMPONENT_MODELLING obj = null; String sql = "USE [rbi] SELECT [ID]" + ",[ComponentID]" + ",[ObjectName]" + " FROM [rbi].[dbo].[COMPONENT_MODELLING] "; try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; using (DbDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { if (reader.HasRows) { obj = new COMPONENT_MODELLING(); obj.ID = reader.GetInt32(0); obj.ComponentID = reader.GetInt32(1); obj.ObjectName = reader.GetString(2); list.Add(obj); } } } } catch (Exception e) { MessageBox.Show(e.ToString(), "GET DATA FAIL!"); } finally { conn.Close(); conn.Dispose(); } return(list); }
public void delete(COMPONENT_MODELLING obj) { DAL.delete(obj.ID); }
public void edit(COMPONENT_MODELLING obj) { DAL.edit(obj.ID, obj.ComponentID, obj.ObjectName); }
public void add(COMPONENT_MODELLING obj) { DAL.add(obj.ComponentID, obj.ObjectName); }