MES_Client/TGMES/Core.StlMes.Client.Judge/Forms/RolledTubePhyFailQueryLg.cs

using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.Judge.Commons;
using CoreFS.CA06;
using Infragistics.Win.UltraWinGrid;
using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace Core.StlMes.Client.Judge.Forms
{
    public partial class RolledTubePhyFailQueryLg : FrmBase
    {
        private Dal _d;
        public RolledTubePhyFailQueryLg()
        {
            InitializeComponent();
        }


        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            base.ToolBar_Click(sender, ToolbarKey);
            switch (ToolbarKey)
            {
                case "Query":
                    Query();
                    break;
                case "Update":
                    DoUpdate();
                    break;
                case "Export":
                    Export();
                    break;
                case "Close":
                    this.Close();
                    break;
            }
        }

        private void DoUpdate()
        {
            this.ultraGrid1.UpdateData();
            ArrayList list = new ArrayList();
            if (this.ultraGrid1.Selected.Rows.Count <= 0)
            {
                MessageUtil.ShowTips("请选择数据！");
                return;
            }
            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow row in this.ultraGrid1.Selected.Rows)
            {
                list.Add(new object[] { row.Cells["计入一次不合"].Text.ToString2(), row.Cells["原因分析"].Text.ToString2(), row.Cells["判定炉号"].Text.ToString2() });
            }

            CoreClientParam ccp = new CoreClientParam();
            ccp.IfShowErrMsg = false;
            ccp.ServerName = "com.steering.pss.judge.DAL.QcmZgJugdeApplyDAL";
            ccp.MethodName = "doUpdatePassrate";
            ccp.ServerParams = new object[] { list };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp != null)
            {
                if (ccp.ReturnCode == -1)
                {
                    MessageUtil.ShowWarning(ccp.ReturnInfo);
                    return;
                }
                MessageUtil.ShowTips("修改成功！");
                Query();
            }
        }


        private void Query()
        {
            string[] plines;
            if (!labelComboBox1.Checked)
            {
                plines = new string[labelComboBox1.ComboBox.Items.Count];
                for (int i = 0; i < labelComboBox1.ComboBox.Items.Count; i++)
                {
                    plines[i] = labelComboBox1.ComboBox.Items[i].DataValue.ToString2();
                }
                if (plines.Length == 0)
                {
                    plines = new string[] { "1" };
                }
            }
            else if (labelComboBox1.ComboBox.Value == null)
            {
                plines = new string[] { "1" };
            }
            else
            {
                plines = ((List<object>)labelComboBox1.ComboBox.Value).Select(a => a.ToString()).ToArray();
            }
            string yearMonth = ultraComboEditor1.Value.ToString2() + ultraComboEditor2.Value.ToString2();
            string yearMonth2 = ultraComboEditor3.Value.ToString2() + ultraComboEditor4.Value.ToString2();
            DataTable dt1 = _d.GetTableByXmlId("QcmZgJugdeApplyDAL.PhyFailQueryLg", plines.Length, plines, yearMonth, yearMonth2);
            DataTable dt = dt1.Clone();
            foreach (DataColumn dc in dt1.Columns)
            {
                if (dt.Columns.Contains(dc.ColumnName)) continue;
                dt.Columns.Add(new DataColumn() { ColumnName = dc.ColumnName });
            }
            foreach (DataRow dr1 in dt1.Rows)
            {
                DataRow drNew = dt.NewRow();
                foreach (DataColumn dc in dt.Columns)
                {
                    if (dt1.Columns.Contains(dc.ColumnName))
                    {
                        drNew[dc.ColumnName] = dr1[dc.ColumnName].ToString();
                    }
                }
                dt.Rows.Add(drNew);
            }
            ultraGrid1.DataSource = dt;
            GridHelper.RefreshAndAutoSize(ultraGrid1);

            ultraGrid1.DisplayLayout.Bands[0].Columns["judgeStoveNo"].Hidden = true;
            foreach (UltraGridRow row in ultraGrid1.Rows)
            {
                row.Cells["计入一次不合"].Activation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                row.Cells["计入一次不合"].Appearance.BackColor = Color.FromArgb(255, 255, 192);
                row.Cells["计入一次不合"].EditorComponent = ultraComboEditor5;
                row.Cells["原因分析"].Activation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                row.Cells["原因分析"].Appearance.BackColor = Color.FromArgb(255, 255, 192);
            }

        }

        private void Export()
        {
            GridHelper.ulGridToExcel(ultraGrid1, "炼钢理化不合信息");
        }

        private void RolledTubePhyFailQueryLg_Load(object sender, EventArgs e)
        {
            _d = new Dal(ob);
            for (int i = DateTime.Now.Year - 10; i <= DateTime.Now.Year + 10; i++)
            {
                ultraComboEditor1.Items.Add(i);
                ultraComboEditor3.Items.Add(i);
            }
            ultraComboEditor1.Value = DateTime.Now.Year;
            ultraComboEditor2.Value = DateTime.Now.Month.ToString().PadLeft(2, '0');
            ultraComboEditor3.Value = DateTime.Now.Year;
            ultraComboEditor4.Value = DateTime.Now.Month.ToString().PadLeft(2, '0');

            JudgeBaseInfo.LoadPlineName(labelComboBox1.ComboBox, ob, false, CustomInfo);
            labelComboBox1.ComboBox.DropDownListWidth = -1;
            foreach (var item in labelComboBox1.ComboBox.Items)
            {
                item.CheckState = CheckState.Checked;
            }
            labelComboBox1.Checked = true;
        }
    }
}