Wms_Winform/NXWMS/Forms/Report/frmFrequencyStatisticsReport.cs

using ComponentFactory.Krypton.Toolkit;
using NXWMS.Client.Code.Extends;
using NXWMS.Client.Model.AppModels.Condition.Report;
using NXWMS.Client.Model.AppModels.Result;
using NXWMS.Client.Model.AppModels.Result.Report;
using NXWMS.Client.Model.CoreModels;
using NXWMS.Commons;
using NXWMS.Services;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace NXWMS.Forms.Report
{
    public partial class frmFrequencyStatisticsReport : KryptonForm
    {

        /// <summary>
        /// 客户端字段排序列表
        /// </summary>
        private List<ClientFieldOrderResult> _clientFieldOrderList;


        private int _pageSize;
        private int _pageIndex;
        private int _totalCount;

        public frmFrequencyStatisticsReport()
        {
            InitializeComponent();
            InitData();
            InitControl();
        }


        /// <summary>
        /// 数据初始化
        /// </summary>
        private void InitData()
        {
            _clientFieldOrderList = new List<ClientFieldOrderResult>();
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "Date", FieldDesc = "日期" });
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "Schedule", FieldDesc = "排班" });
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "ScheduleTimeSection", FieldDesc = "班次时间段" });
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "ReceiptOrderQTY", FieldDesc = "收货订单数" });
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "ReceiptTrayQTY", FieldDesc = "收货组盘数" });
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "InvoiveQTY", FieldDesc = "发货数量" });
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "InvoiveExamineQTY", FieldDesc = "发货审核数" });
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "PutAwayQTY", FieldDesc = "上架数量" });
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "PutDownQTY", FieldDesc = "下架数量" });
        }

        /// <summary>
        /// 控件初始化
        /// </summary>
        private void InitControl()
        {
            CheckForIllegalCrossThreadCalls = false;
            dataGridView.BuildDataGridView(CommonUtil.GetFieldOrderDic(_clientFieldOrderList), false);

            var fieldList = new List<FieldValue>();
            fieldList.Add(new FieldValue { Id = "Day", Name = "白班" });  
            cmbSearchSchedule.DataSource = fieldList;
            cmbSearchSchedule.DisplayMember = "Name";
            cmbSearchSchedule.ValueMember = "Id";
            cmbSearchSchedule.SelectedIndex = 0;


            fieldList = new List<FieldValue>().Add<FieldValue>(new FieldValue { Code = "", Name = "全部" });
            fieldList.Add(new FieldValue { Id = "8:00-10:00", Name = "8:00-10:00" });
            fieldList.Add(new FieldValue { Id = "10:00-12:00", Name = "10:00-12:00" });
            fieldList.Add(new FieldValue { Id = "12:00-14:00", Name = "12:00-14:00" });
            fieldList.Add(new FieldValue { Id = "14:00-16:00", Name = "14:00-16:00" });
            fieldList.Add(new FieldValue { Id = "16:00-18:00", Name = "16:00-18:00" });
            fieldList.Add(new FieldValue { Id = "18:00-20:00", Name = "18:00-20:00" });
            cmbSearchTime.DataSource = fieldList;
            cmbSearchTime.DisplayMember = "Name";
            cmbSearchTime.ValueMember = "Id";

            _pageIndex = 1;
            _pageSize = 20;
        }

        private void btnSearch_Click(object sender, EventArgs e)
        {
            _pageIndex = 1;
            var loadfrm = new frmLoading();
            loadfrm.Show();
            var message = loadfrm.EventCalExec(LoadSearch, this.pageTool.PageIndex, this.pageTool.PageSize);
            pageTool.DataCount = _totalCount;
            if (!string.IsNullOrWhiteSpace(message))
            {
                KryptonMessageBox.Show($"查询失败!\r\n{message}", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }

        private string LoadSearch(int pageIndex, int pageSize)
        {
            var result = ReportServices.reportSearchService.GetFrequencyStatisticsReportList(new FrequencyStatisticsCondition
            {
                OperationUserId = AppConfig.UserLoginResult.UserInfo.UserId,
                Date= dtpSearchDate.Value,
                ScheduleCode= cmbSearchSchedule.SelectedValue.GetObjectToString(),
                SectionStr= cmbSearchTime.SelectedValue.GetObjectToString(),
                PageIndex = pageIndex,
                PageSize = pageSize
            });
            if (result.Status == OperateStatus.Success)
            {
                _totalCount = result.Data.TotalCount;
                _pageIndex = pageIndex;
                _pageSize = pageSize;
                if (result.Data.RowData.Any())
                {
                    dataGridView.Columns.Clear();
                    dataGridView.DataSource = result.Data.RowData.ToList();
                    dataGridView.BuildDataGridView(CommonUtil.GetFieldOrderDic(_clientFieldOrderList));
                }
                else
                {
                    if (dataGridView.DataSource != null)
                    {
                        dataGridView.DataSource = new List<FrequencyStatisticsResult>();
                    }
                    dataGridView.BuildDataGridView(CommonUtil.GetFieldOrderDic(_clientFieldOrderList), false);
                }
                return string.Empty;
            }
            else
            {
                return result.Message;
            }
        }

        private void btnSearchExport_Click(object sender, EventArgs e)
        {
            dataGridView.DataGridViewExport($"{AppConfig.CurrentMenu.FirstOrDefault().MenuName}列表" +
                        DateTime.Now.ToString("yyyyMMddHH"));
        }
    }
}