public List <RW_CF_MASTER> getDataSource() { SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); List <RW_CF_MASTER> list = new List <RW_CF_MASTER>(); RW_CF_MASTER obj = null; String sql = " Use [rbi] Select [ID]" + ",[CF1]" + ",[CF2]" + ",[CF3]" + ",[CF4]" + ",[CF5]" + ",[CF6]" + ",[CF7]" + ",[CF8]" + ",[CF9]" + "From [dbo].[RW_CF_MASTER] "; 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_CF_MASTER(); obj.ID = reader.GetInt32(0); if (!reader.IsDBNull(1)) { obj.CF1 = reader.GetFloat(1); } if (!reader.IsDBNull(2)) { obj.CF2 = reader.GetFloat(2); } if (!reader.IsDBNull(3)) { obj.CF3 = reader.GetFloat(3); } if (!reader.IsDBNull(4)) { obj.CF4 = reader.GetFloat(4); } if (!reader.IsDBNull(5)) { obj.CF5 = reader.GetFloat(5); } if (!reader.IsDBNull(6)) { obj.CF6 = reader.GetFloat(6); } if (!reader.IsDBNull(7)) { obj.CF7 = reader.GetFloat(7); } if (!reader.IsDBNull(8)) { obj.CF8 = reader.GetFloat(8); } if (!reader.IsDBNull(9)) { obj.CF9 = reader.GetFloat(9); } list.Add(obj); } } } } catch (Exception e) { MessageBox.Show(e.ToString(), "GET DATA FAIL!"); } finally { conn.Close(); } return(list); }
public void edit(RW_CF_MASTER obj) { DAL.edit(obj.ID, obj.CF1, obj.CF2, obj.CF3, obj.CF4, obj.CF5, obj.CF6, obj.CF7, obj.CF8, obj.CF9); }
public void delete(RW_CF_MASTER obj) { DAL.delete(obj.ID); }
public void add(RW_CF_MASTER obj) { DAL.add(obj.ID, obj.CF1, obj.CF2, obj.CF3, obj.CF4, obj.CF5, obj.CF6, obj.CF7, obj.CF8, obj.CF9); }