Ejemplo n.º 1
0
 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());
 }
Ejemplo n.º 2
0
 // 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);
 }
Ejemplo n.º 3
0
 public static DataTable GetList(XEnum.ParamType type = XEnum.ParamType.All)
 {
     return ParamDao.GetList(type);
 }