public List <RW_SAFETY_FACTOR> getDataSource()
{
List <RW_SAFETY_FACTOR> list = new List <RW_SAFETY_FACTOR>();
RW_SAFETY_FACTOR obj = null;
SqlConnection conn = MSSQLDBUtils.GetDBConnection();
conn.Open();
String sql = "USE [rbi] SELECT ID]" +
",[SafetyFactorScheme]" +
",[A]" +
",[B]" +
",[C]" +
",[D]" +
",[E] FROM [dbo].[RW_SAFETY_FACTOR] ";
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_SAFETY_FACTOR();
obj.ID = reader.GetInt32(0);
obj.SafetyFactorScheme = reader.GetString(1);
obj.A = reader.GetFloat(2);
obj.B = reader.GetFloat(3);
obj.C = reader.GetFloat(4);
obj.D = reader.GetFloat(5);
obj.E = reader.GetFloat(6);
list.Add(obj);
}
}
}
}
catch
{
MessageBox.Show("GET DATA SOURCE FAIL!", "ERROR!");
}
finally
{
conn.Close();
conn.Dispose();
}
return(list);
}
public void delete(RW_SAFETY_FACTOR obj)
{
DAL.delete(obj.ID);
}
public void edit(RW_SAFETY_FACTOR obj)
{
DAL.edit(obj.ID, obj.SafetyFactorScheme, obj.A, obj.B, obj.C, obj.D, obj.E);
}
