using SSWMS.Common;
using System;
using System.Windows;

namespace SSWMS.Client
{
    public partial class DateSectQueryWindow : AvalonDock.DocumentContent
    {
        private string U_DateSectColumn = string.Empty;
        private string U_WindowName = "COMMON";
        private string U_TableName = string.Empty;
        private string U_XmlTableName = string.Empty;
        private string U_DataSource_SQL = string.Empty;
        private string U_Where = string.Empty;
        private string U_OrderField = string.Empty;
        private string U_TotalColumnName = string.Empty;
        private bool U_AllowChecked = false;
        private bool U_AllowOperatData = false;

        public DateSectQueryWindow(string type)
        {
            InitializeComponent();
            switch (type)
            {
                case "RECORD":
                    this.U_TableName = "V_RECORD_MANAGE";
                    this.U_XmlTableName = "V_RECORD_MANAGE";
                    this.U_DateSectColumn = "MANAGE_END_TIME";
                    this.U_OrderField = "RECORD_LIST_ID";
                    //this.U_TotalColumnName = "RECORD_LIST_QUANTITY";
                    this.dsDateSect.cbTime.Content = "完成时间区间";
                    break;
                case "RECORD_SUMMARY":
                    this.U_DataSource_SQL = "select GOODS_CODE,GOODS_NAME,STORAGE_PROPERTY_01,STORAGE_PROPERTY_02," +
                        "sum(case when MANAGE_TYPE='InCell' and STOCK_BARCODE=GOODS_BARCODE then 1 else 0 end) IN_STOCK_QUANTITY," +
                        "sum(case when MANAGE_TYPE='InCell' or STOCK_BARCODE<>GOODS_BARCODE then 0 else 1 end) OUT_STOCK_QUANTITY," +
                        "sum(case when MANAGE_TYPE='InCell' then 1 else 0 end) IN_STORAGE_LIST_QUANTITY," +
                        "sum(case when MANAGE_TYPE='InCell' then 0 else 1 end) OUT_STORAGE_LIST_QUANTITY" +
                        $" from V_RECORD_MANAGE where MANAGE_STATUS<>'{SystemCode.MANAGE_STATUS.Delete}'" +
                        $" and (MANAGE_TYPE='{SystemCode.MANAGE_TYPE.InCell}' or MANAGE_TYPE='{SystemCode.MANAGE_TYPE.OutCell}' or MANAGE_TYPE='{SystemCode.MANAGE_TYPE.OutPick}')" +
                        " and {0} group by GOODS_CODE,GOODS_NAME,STORAGE_PROPERTY_01,STORAGE_PROPERTY_02";
                    this.U_TableName = "V_RECORD_SUMMARY";
                    this.U_XmlTableName = "V_RECORD_SUMMARY";
                    this.U_DateSectColumn = "MANAGE_END_TIME";
                    this.U_OrderField = "STORAGE_PROPERTY_01";
                    this.dsDateSect.cbTime.Content = "完成时间区间";
                    break;
                case "PLAN":
                    this.U_TableName = "V_RECORD_PLAN";
                    this.U_XmlTableName = "V_RECORD_PLAN";
                    this.U_DateSectColumn = "PLAN_CREATE_TIME";
                    this.U_OrderField = "PLAN_LIST_ID";
                    //this.U_TotalColumnName = "PLAN_LIST_QUANTITY";
                    this.dsDateSect.cbTime.Content = "创建时间区间";
                    break;
            }
            DocumentContent_Loaded(null, null);
        }

        private void DocumentContent_Loaded(object sender, RoutedEventArgs e)
        {
            this.qqQuickQuery.U_Query += new UC.ucQuickQuery.U_QueryEventHandler((sQueryWhere) =>
            {
                string sAppendWhere = string.Empty;
                if (true == this.dsDateSect.cbTime.IsChecked)
                {
                    sAppendWhere = string.Format("{0}>='{1}' and {0}<='{2}' and {3}",
                        this.U_DateSectColumn,
                        this.dsDateSect.dtpStartTime.Value.ToString("yyyy-MM-dd HH:mm:ss"),
                        this.dsDateSect.dtpEndTime.Value.ToString("yyyy-MM-dd HH:mm:ss"),
                        string.IsNullOrWhiteSpace(sQueryWhere) ? "1=1" : sQueryWhere);
                }
                else
                {
                    sAppendWhere = sQueryWhere;
                }
                if (this.U_TableName == "V_RECORD_SUMMARY")
                {
                    this.dgDataGrid.U_DataSource_SQL = string.Format(this.U_DataSource_SQL, sAppendWhere);
                }
                else
                {
                    this.dgDataGrid.U_AppendWhere = sAppendWhere;
                }
                this.dgDataGrid.U_InitControl();
            });
            this.qqQuickQuery.U_WindowName = this.U_WindowName;
            this.qqQuickQuery.U_XmlTableName = this.U_XmlTableName;
            this.qqQuickQuery.U_InitControl();
            this.dgDataGrid.U_WindowName = this.U_WindowName;
            this.dgDataGrid.U_TableName = this.U_TableName;
            this.dgDataGrid.U_XmlTableName = this.U_XmlTableName;
            this.dgDataGrid.U_Where = this.U_Where;
            this.dsDateSect.dtpStartTime.Value = DateTime.Today;
            this.dsDateSect.dtpEndTime.Value = this.dsDateSect.dtpStartTime.Value.AddDays(1);
            string sAppendWhereToday = string.Format("{0}>='{1}' and {0}<='{2}'",
                U_DateSectColumn,
                this.dsDateSect.dtpStartTime.Value.ToString("yyyy-MM-dd HH:mm:ss"),
                this.dsDateSect.dtpEndTime.Value.ToString("yyyy-MM-dd HH:mm:ss"));
            if (this.U_TableName == "V_RECORD_SUMMARY")
            {
                this.dgDataGrid.U_DataSource_SQL = string.Format(this.U_DataSource_SQL, sAppendWhereToday);
            }
            else
            {
                this.dgDataGrid.U_AppendWhere = sAppendWhereToday;
            }
            this.dgDataGrid.U_OrderField = this.U_OrderField;
            this.dgDataGrid.U_AllowChecked = this.U_AllowChecked;
            this.dgDataGrid.U_AllowOperatData = this.U_AllowOperatData;
            this.dgDataGrid.U_TotalColumnName = this.U_TotalColumnName;
            this.dgDataGrid.U_InitControl();
        }
    }
}