列出所有班级的名称

2014-10-25 16:04:20  访问(1924) 赞(0) 踩(0)

• 内容
• SQL语句
• SQL执行结果
• SlowX框架

• 单表操作,SQL简单查询语句

• select TheName from UTB_EXAM_CLASS
  

• 代码写法：

  
      /// <summary>
      /// 
      /// </summary>
      /// <param name="xdbHelper"></param>
      protected void DataBindTheContorls(DBHelper xdbHelper)
      {
          string theResult=null;
          bool bIsCreate = true;
  
          if (xdbHelper == null)
          {
              xdbHelper = SlowX.DAL.Helpers.DBHelper.CreateDBHelper();
          }
          else
          {
              // 没有打开链接 //
              bIsCreate = xdbHelper.IsNotOpen();
          }
  
          try
          {
              if (bIsCreate)
                  xdbHelper.OpenDBHelper();
  
              SlowX.ExamLib.Business.UTB_EXAM_CLASS
                  bll
                  =
                  SlowX.ExamLib.Business.UTB_EXAM_CLASS.instance;
  
              SlowX.ExamLib.Entity.UTB_EXAM_CLASS
                  entity
                  =
                  new SlowX.ExamLib.Entity.UTB_EXAM_CLASS();
  
              ISelectDriver iselect = entity;
              iselect.AddISelectItemWithEntityFieldInfo(entity._TheName);
  
              IOrderByDriver iorder = entity;
              iorder.AddIOrderByItemWithEntityFieldInfo(entity._TheName, SlowX.Core.Enums.OrderBy.EmOrderBy.ASC);
              iorder.AddIOrderByItemWithEntityFieldInfo(entity._ID, SlowX.Core.Enums.OrderBy.EmOrderBy.ASC);
  
              DataSet ds = bll.List(entity, xdbHelper);
  
              theResult = DataSetSlowXFunctions.DataSetToHtmlTable(ds, true);
  
              if (bIsCreate)
                  xdbHelper.EndDBHelper();
  
          }
          catch (Exception err)
          {
              if (bIsCreate)
                  xdbHelper.TranDBHelper();
  
              throw err;
          }
          finally
          {
              if (bIsCreate)
                  xdbHelper.FinallyDBHelper();
          }
  
          strResult = theResult;
      }
  

  输出SQL：

  select 
  slxt.TheName as TheName
  from UTB_EXAM_CLASS slxt
  order by 
  slxt.TheName asc, slxt.ID asc
  
  

标签：列出所有班级的名称 

上一条：

下一条：

相关评论

发表评论

类型：	留言 建议 疑问
内容：
	(Alt+Enter)