public static DataTable GetList(XEnum.ParamType type)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("SELECT * FROM Param");
if (type != XEnum.ParamType.All) {
sql.AppendLine("WHERE paraType = " + ((int)type).ToString());
}
sql.AppendLine("ORDER BY paraName");
return helper.ExecuteDataTable(sql.ToString());
}
// Used to populate dropdown lists
public static DataTable GetBriefList(XEnum.ParamType type)
{
string sql = "SELECT ID, Name = paraValue FROM Param WHERE paraType = " + ((int)type).ToString() + " ORDER BY paraName";
return helper.ExecuteDataTable(sql);
}
public static DataTable GetList(XEnum.ParamType type = XEnum.ParamType.All)
{
return ParamDao.GetList(type);
}