列出“李志坚”所在的班级

2014-10-25 17:04:55 访问(1645) 赞(0) 踩(0)

提示：
考虑“李志坚”重名的情况

select c.TheName as '班级名称'
from
UTB_EXAM_STUDENT s,
UTB_EXAM_CLASS c
where
s.ClassId = c.Id
and s.TheName = '李志坚'
order by c.TheName


    /// <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();

            SlowX.ExamLib.Entity.UTB_EXAM_STUDENT
                entityStudent
                =
                new SlowX.ExamLib.Entity.UTB_EXAM_STUDENT();

            IFromTableDriver ifrom = entity;
            ifrom.AddIFromTableItemWithBaseEntity("tStudent", entityStudent);

            IQueryDriver iq = entity;
            iq.AddIQueryItemWithEntityFieldInfo(entity._ID, entityStudent._ClassId);
            iq.AddIQueryItemWithEntityFieldInfo(entityStudent._TheName, "李志坚");

            ISelectDriver iselect = entity;
            SqlSelectAssist SelectAssist = new SqlSelectAssist();
            SelectAssist.selectName = "'班级名称'";
            iselect.AddISelectItemWithEntityFieldInfo
                (
                    SelectAssist,
                    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;
    }


select 
slxt.TheName as '班级名称'
from UTB_EXAM_CLASS slxt , 
UTB_EXAM_STUDENT slxtStudent
where slxt.ID = slxtStudent.ClassId and slxtStudent.TheName = '李志坚'
order by 
slxt.TheName asc, slxt.ID asc

@slxtStudentp1 = '李志坚'


select 
slxt.TheName as '班级名称'
from UTB_EXAM_CLASS slxt , 
UTB_EXAM_STUDENT slxtStudent
where slxt.ID = slxtStudent.ClassId and slxtStudent.TheName = @slxtStudentp1
order by 
slxt.TheName asc, slxt.ID asc

@slxtStudentp1 	 李志坚 	 String 	 Input 	 SqlParameter