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 { /// /// 客户端字段排序列表 /// private List _clientFieldOrderList; /// /// 库区列表 /// private List _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(); } dataGridView.BuildDataGridView(CommonUtil.GetFieldOrderDic(_clientFieldOrderList), false); } return string.Empty; } else { return result.Message; } } /// /// 数据初始化 /// 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(); _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 = "更新时间" }); } /// /// 控件初始化 /// private void InitControl() { CheckForIllegalCrossThreadCalls = false; dataGridView.BuildDataGridView(CommonUtil.GetFieldOrderDic(_clientFieldOrderList), false); var fieldList = new List().Add(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().Add(new FieldValue { Id = "", Name = "全部" }); cmbSearchInspectionStatus.DataSource = fieldList.GetFieldValueIdList(); cmbSearchInspectionStatus.DisplayMember = "Name"; cmbSearchInspectionStatus.ValueMember = "Id"; cmbSearchInspectionStatus.SelectedIndex = -1; fieldList = new List().Add(new FieldValue { Id = "", Name = "全部" }); cmbSearchBalanceStatus.DataSource = fieldList.GetFieldValueIdList(); 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")); } } }