SIMDP_FEM/SIMDP/SIMDP.View/FormDataManage.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Linq;
using System.Threading.Tasks;
using System.Windows.Forms;
using DevExpress.XtraEditors;
using ProjectBase.Data.Logs;
using SIMDP.Model;
using ProjectBase.Data.BaseDAL;
using SIMDP.BLL;
using DevExpress.XtraNavBar;

namespace SIMDP
{
    public partial class FormDataManage : DevExpress.XtraEditors.XtraForm
    {
        private List<TextEdit> txtList = new List<TextEdit>();  //用于存储动态生成的textEdit控件

        private DataTable table = null; // 数据规则解析表
        private string condition = ""; // 查询条件
        private string selectRuleName = ""; //  选中的规则名称

        private string batchid = null;

        public FormDataManage()
        {
            InitializeComponent();
        }

        /// <summary>
        /// 初始化导航栏
        /// </summary>
        private void InitNavBarControl()
        {
            List<MoRule> ruleList = new List<MoRule>();
            ruleList = BLLFactory<BlRule>.Instance.GetAll();
            if (ruleList == null || ruleList.Count < 1)
            {
                MessageBox.Show("请先添加数据规则！");
            }
            foreach (MoRule mo in ruleList)
            {
                NavBarItem item = new NavBarItem();
                item.Visible = true;
                item.SmallImage = Image.FromFile(Application.StartupPath + "/Images/101.png");
                item.Name = mo.RuleId.ToString();
                item.Caption = mo.RuleName;
                item.LinkClicked += Item_Click;
                this.navBarControl.Items.AddRange(new DevExpress.XtraNavBar.NavBarItem[] { item });
                this.nbDataHistory.ItemLinks.AddRange(new DevExpress.XtraNavBar.NavBarItemLink[] { new DevExpress.XtraNavBar.NavBarItemLink(item) });
            }
            if (this.nbDataHistory.ItemLinks.Count > 0)
            {
                this.navBarControl.SelectedLink = this.nbDataHistory.ItemLinks[0];
            }

        }

        /// <summary>
        /// 初始化右侧控件
        /// </summary>
        private void InitData()
        {
            MoRule mo = new MoRule();
            mo = BLLFactory<BlRule>.Instance.FindByID(this.navBarControl.SelectedLink.ItemName);
            table.Clear();
            table = BLLFactory<BlRule>.Instance.AnalyzeRuleValue(mo);
            InitPanel();
            selectRuleName = this.navBarControl.SelectedLink.ItemName;
            condition = string.Format(" rule_id = '{0}'", selectRuleName);
            string startTime = string.Format("{0} {1}", this.dateEditStart.Text, this.timeEditStart.Text);
            string endTime = string.Format("{0} {1}", this.dateEditEnd.Text, this.timeEditEnd.Text);
            condition += string.Format(" and rule_time >= '{0}' and rule_time <= '{1}'", startTime, endTime);
            if (!string.IsNullOrEmpty(txt_batchid.Text))
            {
                condition += string.Format(" and batchid like '%{0}%'", txt_batchid.Text);
            }
            BindData(table, condition);
        }

        /// <summary>        
        /// 导航栏子项目的点击事件        
        /// </summary>        
        private void Item_Click(object sender, NavBarLinkEventArgs e)
        {
            MoRule mo = new MoRule();
            mo = BLLFactory<BlRule>.Instance.FindByID(e.Link.ItemName);
            table.Clear();
            table = BLLFactory<BlRule>.Instance.AnalyzeRuleValue(mo);
            InitPanel();
            selectRuleName = e.Link.ItemName;
            condition = string.Format(" rule_id = '{0}'", selectRuleName);
            string startTime = string.Format("{0} {1}", this.dateEditStart.Text, this.timeEditStart.Text);
            string endTime = string.Format("{0} {1}", this.dateEditEnd.Text, this.timeEditEnd.Text);
            condition += string.Format(" and rule_time >= '{0}' and rule_time <= '{1}'", startTime, endTime);
            if (!string.IsNullOrEmpty(txt_batchid.Text))
            {
                condition += string.Format(" and batchid like '%{0}%'", txt_batchid.Text);
            }
            BindData(table, condition);
        }

        /// <summary>
        /// 初始化panel
        /// </summary>
        private void InitPanel()
        {
            this.panelControl1.Visible = true;
            this.dateEditStart.EditValue = DateTime.Today;
            this.dateEditEnd.EditValue = DateTime.Today;
            this.timeEditStart.EditValue = DateTime.Parse("00:00:00");
            this.timeEditEnd.EditValue = DateTime.Parse("23:59:59");
        }

        /// <summary>
        /// 按条件查询内容
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void SbtnSelect_Click(object sender, EventArgs e)
        {
            condition = string.Format(" rule_id = '{0}'", selectRuleName);
            string startTime = string.Format("{0} {1}", this.dateEditStart.Text, this.timeEditStart.Text);
            string endTime = string.Format("{0} {1}", this.dateEditEnd.Text, this.timeEditEnd.Text);
            condition += string.Format(" and rule_time >= '{0}' and rule_time <= '{1}'", startTime, endTime);
            if (!string.IsNullOrEmpty(txt_batchid.Text))
            {
                condition += string.Format(" and batchid like '%{0}%'", txt_batchid.Text);
            }
            BindData(table, condition);
        }

        /// <summary>
        /// 页面切换
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void winGridViewPager1_OnPageChanged(object sender, EventArgs e)
        {
            BindData(table, condition);
        }

        /// <summary>
        /// 绑定产品数据
        /// </summary>
        /// <param name="table">需要查询的某一规则列表</param>
        /// <param name="condition">输入的查询语句</param>
        private void BindData(DataTable table, string condition)
        {
            try
            {
                this.gridView1.Columns.Clear();
                List<MoProductData> productList = new List<MoProductData>();
                productList = BLLFactory<BlProductData>.Instance.Find(condition);
                DataTable dtProduct = new DataTable();
                int columns = 0;
                dtProduct.Columns.Add("ID", typeof(string));
                dtProduct.Columns.Add("产生时间", typeof(DateTime));
                dtProduct.Columns.Add("产品条码", typeof(string));
                foreach (DataRow item in table.Rows)
                {
                    dtProduct.Columns.Add(item.Field<string>("Name"), typeof(string));
                }
                for (int i = 0; i < productList.Count; i++)
                {
                    string id = productList[i].DataId.ToString();
                    string time = productList[i].RuleTime.ToString("yyyy-MM-dd HH:mm:ss");
                    batchid = productList[i].Batchid;
                    string[] values = productList[i].DataValue.Split(',');
                    if (table.Rows.Count != values.Count())
                    {
                        continue;
                    }
                    List<string> tempList = new List<string>();
                    tempList = values.ToList();
                    tempList.Insert(0, batchid);
                    tempList.Insert(0, time);
                    tempList.Insert(0, id);
                    dtProduct.Rows.Add(tempList.ToArray());
                }
                //按时间降序排列
                dtProduct.DefaultView.Sort = "产生时间 DESC";
                dtProduct = dtProduct.DefaultView.ToTable();

                this.gridView1.Appearance.HeaderPanel.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
                this.gridControl1.DataSource = dtProduct;

                //添加一列修改项
                DevExpress.XtraGrid.Columns.GridColumn gridColumn11 = new DevExpress.XtraGrid.Columns.GridColumn();
                gridColumn11.AppearanceCell.Options.UseTextOptions = true;
                gridColumn11.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
                gridColumn11.AppearanceCell.TextOptions.VAlignment = DevExpress.Utils.VertAlignment.Center;
                gridColumn11.Caption = "修改操作";
                gridColumn11.Name = "gridColumn11";
                gridColumn11.Visible = true;
                gridColumn11.VisibleIndex = dtProduct.Columns.Count;

                DevExpress.XtraEditors.Repository.RepositoryItemHyperLinkEdit repositoryItemLinkEdit = new DevExpress.XtraEditors.Repository.RepositoryItemHyperLinkEdit();
                repositoryItemLinkEdit.AutoHeight = false;
                repositoryItemLinkEdit.Name = "repositoryItemHyperLinkAlter_Click";
                repositoryItemLinkEdit.NullText = "修改";
                repositoryItemLinkEdit.Click += new System.EventHandler(repositoryItemLinkEdit_Click);
                gridColumn11.ColumnEdit = repositoryItemLinkEdit;
                this.gridView1.Columns.Add(gridColumn11);

                for (int i = 0; i < this.gridView1.Columns.Count; i++)   //设置每列内容居中显示
                {
                    this.gridView1.Columns[i].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
                    //设置时间列显示格式
                    this.gridView1.Columns[1].DisplayFormat.FormatString = "yyyy-MM-dd HH:mm:ss";
                    this.gridView1.Columns[1].DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
                }

                //设置除修改列，其他列不可编辑
                for (int i = 0; i < this.gridView1.Columns.Count - 1; i++)
                {
                    this.gridView1.Columns[i].OptionsColumn.AllowEdit = false;
                    this.gridView1.Columns[i].OptionsColumn.ReadOnly = true;
                }

                foreach (DataRow item in table.Rows)
                {
                    if (item.Field<string>("Query").Equals("是"))
                    {
                        gridView1.Columns[columns].OptionsFilter.AllowAutoFilter = true;
                        gridView1.Columns[columns].OptionsFilter.AllowFilter = true;
                        gridView1.Columns[columns].OptionsFilter.ImmediateUpdateAutoFilter = true;
                    }
                    else
                    {
                        gridView1.Columns[columns].OptionsFilter.AllowAutoFilter = false;
                        gridView1.Columns[columns].OptionsFilter.AllowFilter = false;
                        gridView1.Columns[columns].OptionsFilter.ImmediateUpdateAutoFilter = false;
                    }
                    columns++;
                }

                this.gridControl1.RefreshDataSource();
            }
            catch (Exception ex)
            {
                DevExpress.XtraEditors.XtraMessageBox.Show("绑定产品数据出现错误。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                LogHelper.log.Error(string.Format("查询数据库product_data出现错误：{0}", ex));
            }
        }

        /// <summary>
        /// 过滤界面数据
        /// </summary>
        /// <param name="table"></param>
        /// <param name="values"></param>
        /// <param name="result"></param>
        /// <returns></returns>
        private bool FilterData(DataTable table, string[] values, out string[] result)
        {
            result = null;
            foreach (DataRow item in table.Rows)
            {
                if (item.Field<string>("Name").Equals("日期"))
                {
                    int pos = Convert.ToInt32(item.Field<string>("OrderNum"));
                    DateTime dateValue = Convert.ToDateTime(values[pos]);
                    DateTime dateStart = Convert.ToDateTime(this.dateEditStart.EditValue.ToString());
                    DateTime dateEnd = Convert.ToDateTime(this.dateEditEnd.EditValue.ToString());
                    if (!((0 >= dateValue.CompareTo(dateStart)) && (0 <= dateValue.CompareTo(dateEnd))))
                    {
                        return false;
                    }
                }
                if (item.Field<string>("Name").Equals("时间"))
                {

                    int pos = item.Field<int>("OrderNum");
                    DateTime timeValue = Convert.ToDateTime(values[pos]);
                    DateTime timeStart = Convert.ToDateTime(this.timeEditStart.EditValue.ToString());
                    DateTime timeEnd = Convert.ToDateTime(this.timeEditEnd.EditValue.ToString());
                    if (!((0 >= timeValue.CompareTo(timeStart)) && (0 < timeValue.CompareTo(timeEnd))))
                    {
                        return false;
                    }
                }
            }
            result = values;
            return true;
        }

        private void gridView1_CustomDrawRowIndicator(object sender, DevExpress.XtraGrid.Views.Grid.RowIndicatorCustomDrawEventArgs e)
        {
            if (e.Info.IsRowIndicator && e.RowHandle > -1)
            {
                e.Info.DisplayText = (e.RowHandle + 1).ToString();
            }
        }

        private void btn_ExportData_Click(object sender, EventArgs e)
        {
            string dir = System.Environment.CurrentDirectory;
            SaveFileDialog dialog = new SaveFileDialog();
            dialog.Filter = "Excel(*.xls)|*.xls|All File(*.*)|*.*";
            dialog.Title = "保存Excel";
            dialog.FileName = "";
            dialog.RestoreDirectory = true;
            if (!string.IsNullOrEmpty(dir))
            {
                dialog.InitialDirectory = dir;
            }
            if (dialog.ShowDialog() == DialogResult.OK)
            {
                try
                {
                    DevExpress.XtraPrinting.XlsExportOptions options = new DevExpress.XtraPrinting.XlsExportOptions();
                    this.gridControl1.ExportToXls(dialog.FileName);
                    DevExpress.XtraEditors.XtraMessageBox.Show("保存Excel文件成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                catch (Exception ex)
                {
                    DevExpress.XtraEditors.XtraMessageBox.Show("保存Excel文件失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    LogHelper.log.Error(string.Format("保存Excel文件失败，错误为{0}", ex.ToString()));
                }
            }
        }

        private void FormDataManage_Load(object sender, EventArgs e)
        {
            //初始化分页表格控件
            table = new DataTable();
            InitNavBarControl();
            this.panelControl1.Visible = false;
            InitData();
            this.splitContainerControl1.SplitterPosition = 1;
        }

        /// <summary>
        /// 修改操作
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void repositoryItemLinkEdit_Click(object sender, EventArgs e)
        {
            DataRow selectRow = this.gridView1.GetFocusedDataRow();
  
            FormEditDataManage form = new FormEditDataManage();
            form.row = selectRow;
            form.dtRule = table;
            form.ruleId = selectRuleName;
            form.ShowDialog();
            BindData(table, condition);
        }
    }
}