Wms_Winform/NXWMS/Forms/Rule/frmImportTemplate.cs

using ComponentFactory.Krypton.Toolkit;
using NXWMS.Client.Code.Extends;
using NXWMS.Client.Model.AppModels.Condition.Rule;
using NXWMS.Client.Model.AppModels.Result;
using NXWMS.Client.Model.AppModels.Result.Rule;
using NXWMS.Client.Model.CoreModels;
using NXWMS.Commons;
using NXWMS.Forms.Rule.frmRuleChild;
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.Rule
{
    public partial class frmImportTemplate : Form
    {
        /// <summary>
        /// 客户端字段排序列表
        /// </summary>
        private List<ClientFieldOrderResult> _clientFieldOrderList;

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


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

        private int _selectIndex;
        private int _selectId;
        private string _selectNo;

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

        /// <summary>
        /// 主键Key
        /// </summary>
        private string _PrimaryKey = "IMPORT_TEMPLATE_ID";

        /// <summary>
        /// 主键编码
        /// </summary>
        private string _PrimaryNo = "IMPORT_TEMPLATE_CODE";
         
        /// <summary>
        /// 选择行主键列表
        /// </summary>
        private List<string> _CheckRowIdList = new List<string>();

        /// <summary>
        /// 控件初始化
        /// </summary>
        private void InitControl()
        {
            CheckForIllegalCrossThreadCalls = false;
            dataGridView.BuildDataGridView(CommonUtil.GetFieldOrderDic(_clientFieldOrderList), false);
            dataGridView.CellClick += new DataGridViewCellEventHandler(dataGridView_CellClick);
            dataGridViewDTL.BuildDataGridView(CommonUtil.GetFieldOrderDic(_clientDTLFieldOrderList), false);

            _pageIndex = 1;
            _pageSize = 20;
        }

        /// <summary>
        /// 数据初始化
        /// </summary>
        private void InitData()
        {

            _clientFieldOrderList = new List<ClientFieldOrderResult>();
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "IMPORT_TEMPLATE_CODE", FieldDesc = "导入模版编号" });
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "IMPORT_TEMPLATE_NAME", FieldDesc = "导入模版名称" }); 
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "ImportModeName", FieldDesc = "导入方式" });
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "TARGET_OBJECT_CODE", FieldDesc = "源对象编码" });
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "TARGET_OBJECT_NAME", FieldDesc = "源对象名称" });
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "TargetObjectType", FieldDesc = "源对象类型" });
            _clientFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "DESCRIBE", 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 = "更新时间" });

            _clientDTLFieldOrderList = new List<ClientFieldOrderResult>();
            _clientDTLFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "IMPORT_TEMPLATE_CODE", FieldDesc = "导入模版编号" });
            _clientDTLFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "SOURCE_CODE", FieldDesc = "源结构编码" });
            _clientDTLFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "SOURCE_NAME", FieldDesc = "源结构名称" });
            _clientDTLFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "SourceTypeName", FieldDesc = "源结构类型" });
            _clientDTLFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "SourceLength", FieldDesc = "源结构长度" });
            _clientDTLFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "SourceRequiredFlagName", FieldDesc = "源结构必填标识" }); 
            _clientDTLFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "TARGET_CODE", FieldDesc = "目标结构编码" });
            _clientDTLFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "TARGET_NAME", FieldDesc = "目标结构名称" });
            _clientDTLFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "TargetTypeName", FieldDesc = "目标结构类型" });
            _clientDTLFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "TargetLength", FieldDesc = "目标结构长度" });
            _clientDTLFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "TargetRequiredFlagName", FieldDesc = "目标结构必填标识" }); 
            _clientDTLFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "TargetRelationTypeName", FieldDesc = "目标关联类型编码" });
            _clientDTLFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "TargetRelationContent", FieldDesc = "目标关联类型内容" });

            _clientDTLFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "UsedFlagName", FieldDesc = "使用标识" }); 
            _clientDTLFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "CreateName", FieldDesc = "创建人" });
            _clientDTLFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "CREATE_TIME", FieldDesc = "创建时间" });
            _clientDTLFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "UpdateName", FieldDesc = "更新人" });
            _clientDTLFieldOrderList.Add(new ClientFieldOrderResult { FieldName = "UPDATE_TIME", FieldDesc = "更新时间" });
        }

        private void SelectInit()
        {
            if (dataGridView.SelectedRows.Count > 0)
            {
                _selectIndex = dataGridView.SelectedRows[0].Index;
                if (_selectIndex >= 0)
                {
                    _selectId = Convert.ToInt32(dataGridView.Rows[_selectIndex].Cells[_PrimaryKey].Value);
                    _selectNo = dataGridView.Rows[_selectIndex].Cells[_PrimaryNo].Value.ToString();
                }
            }
            else
            {
                _selectIndex = -1;
            }
            _CheckRowIdList = new List<string>();
            foreach (DataGridViewRow item in dataGridView.Rows)
            {
                if (item.Cells["#SELECTED"].Value.GetObjectToInt() == 1)
                {
                    _CheckRowIdList.Add(item.Cells[_PrimaryKey].Value.ToString());
                }
            }
        }

        private void btnSearch_Click(object sender, EventArgs e)
        {
            _pageIndex = 1;

            dataGridViewDTL.DataSource = new List<ImportTemplateDetailResult>();
            dataGridViewDTL.BuildDataGridView(CommonUtil.GetFieldOrderDic(_clientDTLFieldOrderList), false);

            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 void btnSearchExport_Click(object sender, EventArgs e)
        {
            this.dataGridView.DataGridViewExport($"{AppConfig.CurrentMenu.FirstOrDefault().MenuName}列表" + DateTime.Now.ToString("yyyyMMddHH"));
        }

        private string LoadSearch(int pageIndex, int pageSize)
        {
            var result = RuleServices.importTemplateService.GetList(new ImportTemplateSearchCondition
            {
                OperationUserId = AppConfig.UserLoginResult.UserInfo.UserId,
                TemplateName=txtSearchTemplateName.Text,
                TemplateCode=txtSearchTemplateCode.Text,
                SourceObjName=txtSearchSourceName.Text,
                ImportMode= cmbSearchImportMode.SelectedValue.GetObjectToString(),
                IsUsed = chkSearchUse.Checked,
                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<PutAwayRuleResult>();
                    }
                    dataGridView.BuildDataGridView(CommonUtil.GetFieldOrderDic(_clientFieldOrderList), false);
                }
                return string.Empty;
            }
            else
            {
                return result.Message;
            }
        }
        private void dataGridView_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            SelectInit();
            if (_selectIndex >= 0)
            {
                _pageIndex = 1;
                var loadfrm = new frmLoading();
                loadfrm.Show();
                var message = loadfrm.EventCalExec(LoadDTLSearch, 0, 0);
                if (!string.IsNullOrWhiteSpace(message))
                {
                    KryptonMessageBox.Show($"查询失败!\r\n{message}", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
        }
         
        private string LoadDTLSearch(int pageIndex, int pageSize)
        {
            var result = RuleServices.importTemplateService.GetDetailList(new ImportTemplateDetailSearchCondition
            {
                OperationUserId = AppConfig.UserLoginResult.UserInfo.UserId,
                TemplateCode=_selectNo,
                IsUsed = true,
            });
            if (result.Status == OperateStatus.Success)
            {
                if (result.Data.Any())
                {
                    dataGridViewDTL.Columns.Clear();
                    dataGridViewDTL.DataSource = result.Data.ToList();
                    dataGridViewDTL.BuildDataGridView(CommonUtil.GetFieldOrderDic(_clientDTLFieldOrderList));
                }
                else
                {
                    if (dataGridViewDTL.DataSource != null)
                    {
                        dataGridViewDTL.DataSource = new List<ImportTemplateDetailResult>();
                    }
                    dataGridViewDTL.BuildDataGridView(CommonUtil.GetFieldOrderDic(_clientDTLFieldOrderList), false);
                }
                return string.Empty;
            }
            else
            {
                return result.Message;
            }
        }

        private void btnAdd_Click(object sender, EventArgs e)
        {
            var form = new frmOperateImportTemplate();
            form._FunctionType = frmOperateImportTemplate.EnumFunctionType.Add;
            if (form.ShowDialog() == DialogResult.Yes)
            {
                btnSearch_Click(null, null);
            }
        }

        private void btnEdit_Click(object sender, EventArgs e)
        {
            SelectInit();
            if (string.IsNullOrWhiteSpace(_selectNo))
            {
                KryptonMessageBox.Show($"请选择记录!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            var form = new frmOperateImportTemplate();
            form._FunctionType = frmOperateImportTemplate.EnumFunctionType.Edit;
            if (form.ShowDialog() == DialogResult.Yes)
            {
                btnSearch_Click(null, null);
            }
        }

        private void btnRemove_Click(object sender, EventArgs e)
        {
            SelectInit();
            if (_CheckRowIdList.Count == 0)
            {
                return;
            }

            if (KryptonMessageBox.Show($"确认删除选中数据？", "提示信息", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
            {
                var editResult = RuleServices.importTemplateService.Deleted(new ImportTemplateCondition
                {
                    OperationUserId = AppConfig.UserLoginResult.UserInfo.UserId,
                    TemplateIds = string.Join(",", _CheckRowIdList),
                });
                if (editResult.Status == OperateStatus.Success)
                {
                    KryptonMessageBox.Show($"操作成功!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    btnSearch_Click(null, null);
                }
                else
                {
                    KryptonMessageBox.Show($"操作失败!\r\n{editResult.Message}", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
        }

        private void btnSearchImport_Click(object sender, EventArgs e)
        {

        }
    }
}