AddISelectItemWithEntityFieldInfoName实现通过EntityFieldInfo的Name在select中添加指定字段项

2015-04-05 19:42:46 访问(1754) 赞(0) 踩(0)

生成和输出的SQL语句

select 
t.TheName as 名称, 
t.CreateTime as 创建时间
from UTB_EXAM_CLASS t
order by 
t.ID asc

关键代码


            ISelectDriver iselect = entity;
            SqlSelectAssist sa = new SqlSelectAssist();
            sa.selectName = "名称";
            iselect.AddISelectItemWithEntityFieldInfoName
                (
                    sa,
                    "TheName"
                );

            sa = new SqlSelectAssist();
            sa.selectName = "创建时间";
            iselect.AddISelectItemWithEntityFieldInfoName
                (
                    sa,
                    "CreateTime"
                );

代码写法

   #region 操作

    /// <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;
            SqlSelectAssist sa = new SqlSelectAssist();
            sa.selectName = "名称";
            iselect.AddISelectItemWithEntityFieldInfoName
                (
                    sa,
                    "TheName"
                );

            sa = new SqlSelectAssist();
            sa.selectName = "创建时间";
            iselect.AddISelectItemWithEntityFieldInfoName
                (
                    sa,
                    "CreateTime"
                );


            IOrderByDriver iorder = entity;
            iorder.AddIOrderByItemWithEntityFieldInfo(entity._ID, SlowX.Core.Enums.OrderBy.EmOrderBy.ASC);

            
            DataSet ds = bll.List(entity, xdbHelper);

            theResult =
                @"<textarea name=""TextBox1"" rows=""2"" cols=""20"" id=""TextBox1"" style=""height:400px;width:99%;"">"
                + bll.BuildSqlList(entity, xdbHelper)
                + "</textarea>";

            theResult += "<br /><br />";

            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;
    }

    #endregion 操作