Wms_Winform/NXWMS/Forms/Balance/frmBalanceChangeLogSearch.cs

using ComponentFactory.Krypton.Toolkit;
using NXWMS.Client.Code.Extends;
using NXWMS.Client.Model.AppModels.Condition.Balance;
using NXWMS.Client.Model.AppModels.Condition.Base;
using NXWMS.Client.Model.AppModels.Result;
using NXWMS.Client.Model.AppModels.Result.Balance;
using NXWMS.Client.Model.AppModels.Result.Base;
using NXWMS.Client.Model.CoreModels;
using NXWMS.Client.String.Enums;
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.Balance
{
    public partial class frmBalanceChangeLogSearch : KryptonForm
    { 
        /// <summary>
        /// 客户端字段排序列表
        /// </summary>
        private List<ClientFieldOrderResult> _clientFieldOrderList;

        /// <summary>
        /// 库区列表
        /// </summary>
        private List<RegionResult> _regionList;

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

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

        private void btnSearch_Click(object sender, EventArgs e)
        {
            _pageIndex = 1;
            var loadfrm = new frmLoading();
            loadfrm.Show();
            // pageTool.Initialize(LoadSearch, 0, _pageSize);
            var message = loadfrm.EventCalExec(LoadSearch, this.pageTool.PageIndex, this.pageTool.PageSize);
            //var message = loadfrm.EventCalExec(LoadSearch, _pageIndex, _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 = BalanceServices.balanceSearchService.GetChangeLogList(new BalanceChangeLogSearchCondition
            {
                OperationUserId = AppConfig.UserLoginResult.UserInfo.UserId,
                RegionCode = cmbSearchRegionCode.SelectedValue.GetObjectToString(),
                BalanceStatus = cmbSearchBalanceStatus.SelectedValue.GetObjectToInt(),
                BatchNo = txtSearchBatchInfo.Text,
                BinInfo = txtSearchBinInfo.Text,
                InspectionStatus = cmbSearchInspectionStatus.SelectedValue.GetObjectToInt(),
                MaterielInfo = txtSearchMaterielInfo.Text,
                MaterielTypeInfo = txtSearchMaterielTypeInfo.Text,
                PalletInfo = txtSearchPalletInfo.Text,
                WarehouseInfo = txtSearchWarehouseInfo.Text,
                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<BalanceChangeLogResult>();
                    }
                    dataGridView.BuildDataGridView(CommonUtil.GetFieldOrderDic(_clientFieldOrderList), false);
                }
                return string.Empty;
            }
            else
            {
                return result.Message;
            }
        }

        /// <summary>
        /// 数据初始化
        /// </summary>
        private void InitData()
        {
            var regionResult = BaseServices.regionService.GetList(new RegionSearchCondition { IsUsed = true, ItemSQL = "REGION_CODE,REGION_NAME,AREA_NAME,AREA_CODE,WAREHOUSE_CODE,WAREHOUSE_NAME" });
            if (regionResult.Status == OperateStatus.Success)
            {
                _regionList = regionResult.Data.RowData.ToList();
            }
 
            _clientFieldOrderList = new List<ClientFieldOrderResult>();
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "MATERIEL_TYPE_CODE", FieldDesc = "物料类型编码" });
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "MATERIEL_TYPE_NAME", FieldDesc = "物料类型名称" });
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "MATERIEL_CODE", FieldDesc = "物料编码" });
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "MATERIEL_NAME", FieldDesc = "物料名称" }); 
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "UNIT_NAME", FieldDesc = "单位名称" });
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "CHANGE_BEFORE_QTY", FieldDesc = "变更前数量" });
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "CHANGE_AFTER_QTY", FieldDesc = "变更后数量" });
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "QTY", FieldDesc = "变更数量" });
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "ChangeReasonTypeName", FieldDesc = "变更原因" });
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "BATCH_NO", FieldDesc = "批次号" });
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "WAREHOUSE_NAME", FieldDesc = "所在仓库" });
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "REGION_NAME", FieldDesc = "所在库区" });
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "BIN_NAME", FieldDesc = "所在库位" });
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "TRAY_CODE", FieldDesc = "所在组盘码" });
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "PALLET_NAME", FieldDesc = "所在托盘" });
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "CreateName", FieldDesc = "创建人" });
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "CREATE_TIME", FieldDesc = "创建时间" });
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "UpdateName", FieldDesc = "更新人" });
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "UPDATE_TIME", FieldDesc = "更新时间" });
        }

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


            var fieldList = new List<FieldValue>().Add<FieldValue>(new FieldValue { Code = "", Name = "全部" });
            cmbSearchRegionCode.DataSource = fieldList.GetFieldValueIdList(_regionList, "REGION_CODE", "REGION_NAME");
            cmbSearchRegionCode.DisplayMember = "Name";
            cmbSearchRegionCode.ValueMember = "Id";
            cmbSearchRegionCode.SelectedIndex = -1;

            fieldList = new List<FieldValue>().Add<FieldValue>(new FieldValue { Id = "", Name = "全部" });
            cmbSearchInspectionStatus.DataSource = fieldList.GetFieldValueIdList<InspectionStatus>();
            cmbSearchInspectionStatus.DisplayMember = "Name";
            cmbSearchInspectionStatus.ValueMember = "Id";
            cmbSearchInspectionStatus.SelectedIndex = -1;

            fieldList = new List<FieldValue>().Add<FieldValue>(new FieldValue { Id = "", Name = "全部" });
            cmbSearchBalanceStatus.DataSource = fieldList.GetFieldValueIdList<BalanceStatus>();
            cmbSearchBalanceStatus.DisplayMember = "Name";
            cmbSearchBalanceStatus.ValueMember = "Id";
            cmbSearchBalanceStatus.SelectedIndex = -1;

            _pageIndex = 1;
            _pageSize = 20;
        }

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