//--------------------------------------------------------------
public static List <OrderByClauses> Static_GetList(string ConStr, string TableName)
{
List <OrderByClauses> RetVal = new List <OrderByClauses>();
try
{
OrderByClauses m_OrderByClauses = new OrderByClauses(ConStr);
RetVal = m_OrderByClauses.GetList(TableName);
}
catch (Exception ex)
{
throw ex;
}
return(RetVal);
}
//-----------------------------------------------------------------
private List <OrderByClauses> Init(SqlCommand cmd)
{
SqlConnection con = db.GetConnection();
cmd.Connection = con;
List <OrderByClauses> l_OrderByClauses = new List <OrderByClauses>();
try
{
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
SmartDataReader smartReader = new SmartDataReader(reader);
while (smartReader.Read())
{
OrderByClauses m_OrderByClauses = new OrderByClauses(db.ConnectionString);
m_OrderByClauses.OrderByClauseId = smartReader.GetInt32("OrderByClauseId");
m_OrderByClauses.TableName = smartReader.GetString("TableName");
m_OrderByClauses.OrderByName = smartReader.GetString("OrderByName");
m_OrderByClauses.OrderByDesc = smartReader.GetString("OrderByDesc");
m_OrderByClauses.OrderBy = smartReader.GetString("OrderBy");
m_OrderByClauses.DisplayOrder = smartReader.GetByte("DisplayOrder");
m_OrderByClauses.CrDateTime = smartReader.GetDateTime("CrDateTime");
l_OrderByClauses.Add(m_OrderByClauses);
}
reader.Close();
return(l_OrderByClauses);
}
catch (SqlException err)
{
throw new ApplicationException("Data error: " + err.Message);
}
finally
{
db.closeConnection(con);
}
}