LINQ 动态查询太牛B!

最新推荐文章于 2025-09-12 14:21:37 发布

weixin_30432007

最新推荐文章于 2025-09-12 14:21:37 发布

阅读量60

点赞数

CC 4.0 BY-SA版权

文章标签： ui

原文链接：http://www.cnblogs.com/flysnow-z/archive/2009/06/23/1509498.html

近日做几个项目用到linq动态查询,但微软官方所提供的那些动态查询机制相当复杂, 网上也有不少网友发过一些动态查询的方案,本人觉得那些方案比较繁索,也不易理解，今提供一种易理解简单实用的方法.

方法如下:

在中间层写:

public List<View_InvoiceTransferLog> GetTransferLogByCondition(DateTime? startDate,
            DateTime? endDate,int? startNum,int? endNum, InvoiceLogType logType)
        {
            int theType = (int)logType;
            IQueryable<View_InvoiceTransferLog> query = from view in Context.View_InvoiceTransferLogs
                                                        where
                                                        (startDate == null || view.LogDate >= startDate) &&
                                                        (endDate == null || view.LogDate <= endDate) &&
                                                        (startNum == null || view.InvoiceStartNum >= startNum) &&
                                                        (endNum == null || view.InvoiceEndNum <= endNum) &&
                                                        view.TransferType == theType
                                                        select view;
            return query.ToList();
        }

调用过程如下:

在ui层写

        protected void SearchButton_Click(object sender, EventArgs e)
        {
            if (!HaveCondition())
            {
                GetAllDataByStatus();
                return;
            }
            DateTime? startDate = null;
            DateTime? endDate = null;
            int? startNumber = null;
            int? endNumber = null;

            if (!ValidateData())
            {
                return;
            }

            //get select condition
            //
            if (!string.IsNullOrEmpty(StartDate.Text.Trim()))
            {
                startDate = DateTime.Parse(StartDate.Text.Trim());
            }
            if (!string.IsNullOrEmpty(EndDate.Text.Trim()))
            {
                endDate = DateTime.Parse(EndDate.Text.Trim());
            }
            if (!string.IsNullOrEmpty(StartNum.Text.Trim()))
            {
                startNumber = int.Parse(StartNum.Text.Trim());
            }
            if (!string.IsNullOrEmpty(EndNum.Text.Trim()))
            {
                endNumber = int.Parse(EndNum.Text.Trim());
            }
            List<View_InvoiceTransferLog> list = _control.GetTransferLogByCondition(startDate, endDate, startNumber, endNumber,InvoiceLogTypeEnum);
            gd.DataSource = list;
            gd.DataBind();
        }