[原] XAF 添加日期筛选下拉选择

 1.ListView 添加日期筛选下拉选择，选择指定，可指定日期范围

2.Code

using DevExpress.Data.Filtering;
using DevExpress.ExpressApp;
using DevExpress.ExpressApp.Actions;
using DevExpress.ExpressApp.DC;
using DevExpress.ExpressApp.Editors;
using DevExpress.ExpressApp.SystemModule;
using DevExpress.ExpressApp.Templates;
using DevExpress.Persistent.Base;
using DevExpress.Persistent.Validation;
using DevExpress.Xpo;
using DevExpress.XtraPrinting.Native;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Linq;
using System.Reflection;
using System.Text;

namespace E1554.Module
{
    public interface ISupportFilterByDate
    {
        // Properties
        DateTime Date { get; }
    }

    [NonPersistent]
    public class DateInterval
    {
        private DateTime _start;

        private DateTime _end;

        public DateTime Start
        {
            get
            {
                return this._start;
            }
            set
            {
                this._start = value;
                bool flag = value > this._end;
                if (flag)
                {
                    this._end = this._start;
                }
            }
        }

        public DateTime End
        {
            get
            {
                return this._end;
            }
            set
            {
                this._end = value;
                bool flag = value < this._start;
                if (flag)
                {
                    this._start = value;
                }
            }
        }
    }
    public enum TransactionStatus
    {
        [XafDisplayName("Cancelled")]
        Cancelled = 3,
        [XafDisplayName("Comlited")]
        Comlited = 2,
        [XafDisplayName("Save")]
        Save = 1
    }
   public class CreateDataFilterController : ViewController
{
    // Fields
    private IContainer components = null;
    private DetailView detailView;
    private IObjectSpace os;
    private SingleChoiceAction saFilterByDate;
    public static int SelectedIndex;

    // Methods
    public CreateDataFilterController()
    {
        this.InitializeComponent();
        base.RegisterActions(this.components);
        this.saFilterByDate = new SingleChoiceAction(this, "FilterByDateID", PredefinedCategory.Search);
        this.saFilterByDate.Category = "Filters";
        this.saFilterByDate.TargetObjectType = typeof(ISupportFilterByDate);
        ChoiceActionItem item = new ChoiceActionItem("所有", null) {
            Id = "All"
        };
        this.saFilterByDate.Items.Add(item);
        item = new ChoiceActionItem("今天", null) {
            Id = "Today"
        };
        this.saFilterByDate.Items.Add(item);
        item = new ChoiceActionItem("本周", null) {
            Id = "ThisWeek"
        };
        this.saFilterByDate.Items.Add(item);
        item = new ChoiceActionItem("上周", null)
        {
            Id = "PrevWeek"
        };
        this.saFilterByDate.Items.Add(item);
        item = new ChoiceActionItem("兩周", null)
        {
            Id = "TwoWeek"
        };
        this.saFilterByDate.Items.Add(item);
        item = new ChoiceActionItem("本月", null) {
            Id = "ThisMonth"
        };
        this.saFilterByDate.Items.Add(item);
        item = new ChoiceActionItem("上月", null)
        {
            Id = "PrevMonth"
        };
        this.saFilterByDate.Items.Add(item); //今天,本週,上週,兩週,本月,上月,今年,去年,指定
        item = new ChoiceActionItem("今年", null) {
            Id = "ThisYear"
        };
        this.saFilterByDate.Items.Add(item);
        item = new ChoiceActionItem("去年", null) {
            Id = "PrevYear"
        };
        this.saFilterByDate.Items.Add(item);
        item = new ChoiceActionItem("指定", null) {
            Id = "DatesInterval"
        };
        this.saFilterByDate.Items.Add(item);
        this.saFilterByDate.Caption = "按日期";
        this.saFilterByDate.PaintStyle = ActionItemPaintStyle.Caption;
        this.saFilterByDate.Execute += new SingleChoiceActionExecuteEventHandler(this.saFilterByDate_Execute);
        base.ViewControlsCreated += new EventHandler(this.CreateDataFilterController_ViewControlsCreated);
    }
    private void CreateDataFilterController_Activated(object sender, EventArgs e)
    {
        this.SetCurrentFilterItem();
    }

    private void CreateDataFilterController_ViewControlsCreated(object sender, EventArgs e)
    {
        this.saFilterByDate.Active.SetItemValue("HIDE_FOR_MONTH_STATISTIC", true);
        //this.saFilterByDate.Active.SetItemValue("HIDE_FOR_MONTH_STATISTIC", (base.View.Id != "SaleItem_PivotView_ByMonth_Chart_Common") && !(base.View.Id == "SaleItem_Share_ByMonth_Chart_Common"));
    }

    private void dc_Accepting(object sender, DialogControllerAcceptingEventArgs e)
    {
        DateInterval currentObject = e.AcceptActionArgs.CurrentObject as DateInterval;
        ListView view = base.View as ListView;
        CriteriaOperator @operator = Helper.GetFilterByDates(view.ObjectTypeInfo.Type, currentObject.Start, currentObject.End);
        if (!view.CollectionSource.Criteria.ContainsKey("DateFilter"))
        {
            view.CollectionSource.Criteria.Add(new KeyValuePair<string, CriteriaOperator>("DateFilter", @operator));
        }
        else
        {
            view.CollectionSource.Criteria["DateFilter"] = @operator;
        }
    }
    protected override void Dispose(bool disposing)
    {
        if (disposing && (this.components != null))
        {
            this.components.Dispose();
        }
        base.Dispose(disposing);
    }

    private void Filter(ChoiceActionItem item, SingleChoiceActionExecuteEventArgs e)
    {
        bool flag = base.View.Model.GetValue<bool>("UseServerMode");
        ListView view = base.View as ListView;
        if ((view != null) && (item != null))
        {
            if (item.Id == "DatesInterval")
            {
                #region MyRegion
                this.os = base.ObjectSpace.CreateNestedObjectSpace();
                DateInterval interval1 = new DateInterval
                {
                    Start = DateTime.Now.Date,
                    End = DateTime.Now
                };
                this.detailView = base.Application.CreateDetailView(this.os, interval1);
                this.detailView.ViewEditMode = ViewEditMode.View;
                this.os.Committed += new EventHandler(this.os_Committed);
                e.ShowViewParameters.CreatedView = this.detailView;
                //if (base.Application.GetType().Name == "WinterQueenAspNetApplication")
                //{
                //    e.ShowViewParameters.TargetWindow = TargetWindow.NewModalWindow;
                //}
                e.ShowViewParameters.Context = TemplateContext.PopupWindow;
                DialogController controller = base.Application.CreateController<DialogController>();
                controller.Accepting += new EventHandler<DialogControllerAcceptingEventArgs>(this.dc_Accepting);
                e.ShowViewParameters.Controllers.Add(controller); 
                #endregion
            }
            else
            {
                DateTime minValue = DateTime.MinValue;
                CriteriaOperator left = null;
                if (item.Id == "All")
                {
                    view.CollectionSource.Criteria[0] = null;
                }
                else
                {
                    #region MyRegion
                    string dateFieldStr = "Date";// "CreateOn";
                    #region MyRegion
                    if (item.Id == "Today")
                    {
                        if (view.Model.ModelClass.ShortName == "SaleItem")
                        {
                            left = CriteriaOperator.Parse("[Sale_ID.DateConfirm] >= LocalDateTimeToday()", new object[0]);
                        }
                        else
                        {
                            left = CriteriaOperator.Parse(string.Format("[{0}] >= LocalDateTimeToday()", dateFieldStr), new object[0]);
                        }
                    }
                    if (item.Id == "ThisWeek")
                    {
                        if (view.Model.ModelClass.ShortName == "SaleItem")
                        {
                            left = CriteriaOperator.Parse("[Sale_ID.DateConfirm] >= LocalDateTimeThisWeek()", new object[0]);
                        }
                        else
                        {
                            left = CriteriaOperator.Parse(string.Format("IsThisWeek([{0}])", dateFieldStr), new object[0]);
                        }
                    }

                    if (item.Id == "PrevWeek")
                    {
                        if (view.Model.ModelClass.ShortName == "SaleItem")
                        {
                            left = CriteriaOperator.Parse("[Sale_ID.DateConfirm] >= LocalDateTimeThisWeek()", new object[0]);
                        }
                        else//  IsOutlookIntervalLastWeek
                        {
                            left = CriteriaOperator.Parse(string.Format("IsOutlookIntervalLastWeek([{0}])", dateFieldStr), new object[0]);
                        }
                    }

                    if (item.Id == "TwoWeek")
                    {
                        if (view.Model.ModelClass.ShortName == "SaleItem")
                        {
                            left = CriteriaOperator.Parse("[Sale_ID.DateConfirm] >= LocalDateTimeThisWeek()", new object[0]);
                        }
                        else
                        {
                            left = CriteriaOperator.Parse(string.Format("[{0}] > ADDDAYS(LocalDateTimeToday(), -14) AND [{0}] <LocalDateTimeToday()", dateFieldStr), new object[0]);
                        }
                    }
                    #endregion

                    #region MyRegion
                    if (item.Id == "ThisMonth")
                    {
                        if (view.Model.ModelClass.ShortName == "SaleItem")
                        {
                            left = CriteriaOperator.Parse("[Sale_ID.DateConfirm]>= LocalDateTimeThisMonth()", new object[0]);

                        }
                        else
                        {
                            left = CriteriaOperator.Parse(string.Format("IsThisMonth([{0}])", dateFieldStr), new object[0]);
                        }
                    }
                    if (item.Id == "PrevMonth")
                    {
                        if (view.Model.ModelClass.ShortName == "SaleItem")
                        {
                            left = CriteriaOperator.Parse("[Sale_ID.DateConfirm]>= LocalDateTimeThisMonth()", new object[0]);
                        }
                        else
                        {
                            left = CriteriaOperator.Parse(string.Format("IsThisMonth(AddMonths([{0}],1))", dateFieldStr), new object[0]);
                        }
                    }
                    if (item.Id == "ThisYear")
                    {
                        if (view.Model.ModelClass.ShortName == "SaleItem")
                        {
                            left = CriteriaOperator.Parse("[Sale_ID.DateConfirm]>=LocalDateTimeThisYear()", new object[0]);
                        }
                        else
                        {
                            left = CriteriaOperator.Parse(string.Format("IsThisYear([{0}])", dateFieldStr), new object[0]);
                        }
                    }
                    if (item.Id == "PrevYear")
                    {
                        if (view.Model.ModelClass.ShortName == "SaleItem")
                        {
                            left = CriteriaOperator.Parse("[Sale_ID.DateConfirm]>=LocalDateTimeThisYear()", new object[0]);
                        }
                        else
                        {
                            left = CriteriaOperator.Parse(string.Format("IsThisYear(AddYears([{0}],1))", dateFieldStr), new object[0]);
                        }
                    }
                    //if (item.Id == "PrevMonth")
                    //{
                    //    DateTime time3 = DateTime.Now.AddMonths(-1);
                    //    minValue = new DateTime(time3.Year, time3.Month, 1);
                    //    DateTime time4 = minValue.AddMonths(1);
                    //    if (view.Model.ModelClass.ShortName == "SaleItem")
                    //    {
                    //        object[] parameters = new object[] { minValue, time4 };
                    //        left = CriteriaOperator.Parse("[Sale_ID.DateConfirm]>=? AND [Sale_ID.DateConfirm]<=?", parameters);
                    //    }
                    //    else
                    //    {
                    //        object[] objArray2 = new object[] { minValue, time4 };
                    //        left = CriteriaOperator.Parse("Date>=? AND Date<=?", objArray2);
                    //    }
                    //} 
                    #endregion
                    if (view.Model.ModelClass.ShortName == "Sale")
                    {
                        object[] objArray3 = new object[] { TransactionStatus.Comlited };
                        left = CriteriaOperator.And(left, CriteriaOperator.Parse("TransactionStatus=?", objArray3));
                    }
                    if (view.Model.ModelClass.ShortName == "SaleItem")
                    {
                        object[] objArray4 = new object[] { TransactionStatus.Comlited };
                        left = CriteriaOperator.And(left, CriteriaOperator.Parse("Sale_ID.TransactionStatus=?", objArray4));
                    }
                    if (!view.CollectionSource.Criteria.ContainsKey("DateFilter"))
                    {
                        view.CollectionSource.Criteria.Add(new KeyValuePair<string, CriteriaOperator>("DateFilter", left));
                    }
                    else
                    {
                        view.CollectionSource.Criteria["DateFilter"] = left;
                    }
                    #endregion
                }                  
            }
        }
    }
    private void InitializeComponent()
    {
        base.TargetObjectType = typeof(ISupportFilterByDate);
        base.TargetViewNesting = Nesting.Root;
        base.TargetViewType = ViewType.ListView;
        base.TypeOfView = typeof(ListView);
        base.Activated += new EventHandler(this.CreateDataFilterController_Activated);
    }

    private void os_Committed(object sender, EventArgs e)
    {
    }

    private void saFilterByDate_Execute(object sender, SingleChoiceActionExecuteEventArgs e)
    {
        this.Filter(this.saFilterByDate.SelectedItem, e);
    }

    private void SetCurrentFilterItem()
    {        
        this.saFilterByDate.SelectedIndex = 2;
            
        this.Filter(this.saFilterByDate.Items[2], null);
    }

    // Properties
    public SingleChoiceAction FilterByDate
    {
        get
        {
            return this.saFilterByDate;
        }
    }
}

   public class Helper
   {
       // Methods
       public static CriteriaOperator GetFilterByDates(Type obj, DateTime start, DateTime end)
       {
           CriteriaOperator @operator = null;
           if (obj.GetInterface("ISupportFilterByDate") != null)
           {
               object[] parameters = new object[] { start, end };
               MethodInfo method = obj.GetMethod("GetFilterString");
               if (method != null)
               {
                   @operator = method.Invoke(null, parameters) as CriteriaOperator;
               }
           }
           return @operator;
       }

   }
}

using System;
using DevExpress.Xpo;
using DevExpress.ExpressApp;
using DevExpress.Persistent.Base;
using DevExpress.Persistent.BaseImpl;
using DevExpress.Persistent.Validation;
using DevExpress.Data.Filtering;
using DevExpress.ExpressApp.SystemModule;

namespace E1554.Module {
    [DefaultClassOptions]  
    public class Detail : BaseObject, ISupportFilterByDate
    {
        public Detail(Session session) : base(session) { }
        private string _DetailName;
        public string DetailName {
            get { return _DetailName; }
            set { SetPropertyValue("DetailName", ref _DetailName, value); }
        }
        private Master _Master;
        [Association("Master-Details")]
        public Master Master {
            get { return _Master; }
            set { SetPropertyValue("Master", ref _Master, value); }
        }

        private int _Qty;
        public int Qty
        {
            get { return _Qty;}
            set {
                int oldQty = _Qty;
                SetPropertyValue("Qty", ref _Qty, value);
                if (!IsLoading && !IsSaving && oldQty != _Qty) { 
                    mDefaultAddress = Qty.ToString();
                    OnChanged("DefaultAddress");
                }
            }
           
        }     

        [Persistent("DefaultAddress")]
        private string mDefaultAddress=null;

        [PersistentAlias("mDefaultAddress")]
        public string DefaultAddress
        {
            get
            {
                if (!IsLoading && !IsSaving && mDefaultAddress == null)
                    mDefaultAddress = Qty.ToString();
                return mDefaultAddress;
            }
            set { SetPropertyValue("DefaultAddress", ref mDefaultAddress, value); }
        }
        
        private DateTime date;
        public DateTime Date
        {
            get { return date; }
            set { SetPropertyValue("Date", ref date, value); }
        }
        public static CriteriaOperator GetFilterString(DateTime start, DateTime end)
        {
            return CriteriaOperator.Parse("Date>=? AND Date<=?", new object[]
            {
                start,
                end
            });
        }
    }
}