using ComponentFactory.Krypton.Toolkit; using NXWMS.Client.Code.Extends; using NXWMS.Client.Model.AppModels.Condition.Base; using NXWMS.Client.Model.AppModels.Condition.Report; using NXWMS.Client.Model.AppModels.Result; using NXWMS.Client.Model.AppModels.Result.Base; using NXWMS.Client.Model.AppModels.Result.Report; 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.Report { public partial class frmOutstockDayStatisticsReport : KryptonForm { /// /// 客户端字段排序列表 /// private List _clientFieldOrderList; /// /// 库区列表 /// private List _materielTypeList; private int _pageSize; private int _pageIndex; private int _totalCount; public frmOutstockDayStatisticsReport() { 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); 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.GetOutStockDayStatisticsList(new OutStockDayStatisticsCondition { OperationUserId = AppConfig.UserLoginResult.UserInfo.UserId, BeginTime = dtpSearchBeginDate.GetDateTimeValue().Value, EndTime = dtpSearchEndDate.GetDateTimeValue().Value, BillType = cmbSearchBillType.SelectedValue.GetObjectToString(), OutStockNo=txtSearchOutstockNo.Text, MaterielCode = txtSearchMateriel.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 materielTypeResult = BaseServices.materielTypeService.GetList(new MaterielTypeSearchCondition { IsUsed = true, ItemSQL = "MATERIEL_TYPE_CODE,MATERIEL_TYPE_NAME" }); if (materielTypeResult.Status == OperateStatus.Success) { _materielTypeList = materielTypeResult.Data.RowData.ToList(); } _clientFieldOrderList = new List(); _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "OutstockNo", FieldDesc = "出库单据编号" }); _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "BillTypeName", FieldDesc = "出库单据类型" }); _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "LineNumber", FieldDesc = "出库单据行号" }); _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "OutstockTime", FieldDesc = "出库时间" }); _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "OutstockBillCreateTime", FieldDesc = "出库单据创建时间" }); _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "MaterielCode", FieldDesc = "物品编码" }); _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "MaterielName", FieldDesc = "物品名称" }); _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "MaterielTypeName", FieldDesc = "物品分类名称" }); _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "PackageName", FieldDesc = "包装" }); _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "UnitName", FieldDesc = "单位" }); _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "QTY", FieldDesc = "数量" }); _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "Volume", FieldDesc = "体积" }); _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "Weight", FieldDesc = "重量" }); _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "StandardQTY", FieldDesc = "数量" }); _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "SupplierCode", FieldDesc = "供应商编码" }); _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "SupplierName", FieldDesc = "供应商名称" }); _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "SupplierContract", FieldDesc = "供应商联系人" }); _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "ProductDate", FieldDesc = "生产日期" }); _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "ExpDate", FieldDesc = "失效日期" }); _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "BalanceStatusName", FieldDesc = "库存状态" }); _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "UsedFlagName", 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 = "全部" }); cmbSearchMaterielType.DataSource = fieldList.GetFieldValueIdList(_materielTypeList, "MATERIEL_TYPE_CODE", "MATERIEL_TYPE_NAME"); cmbSearchMaterielType.DisplayMember = "Name"; cmbSearchMaterielType.ValueMember = "Id"; cmbSearchMaterielType.SelectedIndex = -1; fieldList = new List().Add(new FieldValue { Code = "", Name = "全部" }); cmbSearchBillType.DataSource = fieldList.GetFieldValueIdList(); cmbSearchBillType.DisplayMember = "Name"; cmbSearchBillType.ValueMember = "Id"; cmbSearchBillType.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")); } } }