MES_Client/TGMES/Core.StlMes.Client.Mcp.Treatment/HeatTreatment/FrmSizBaseConfigInfo.cs

using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Tool;
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.Mcp.Treatment.HeatTreatment
{
    public partial class FrmSizBaseConfigInfo : FrmBase
    {
        public FrmSizBaseConfigInfo()
        {
            InitializeComponent();
        }

        private void FrmSizBaseConfigInfo_Load(object sender, EventArgs e)
        {
            //获取工序
            DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.FrmMachine.getQueryGx", new object[] { "F" }, this.ob);
            cmbGx.DataSource = dt;
            cmbGx.DisplayMember = "STATION_DESC";
            cmbGx.ValueMember = "STATION_CODE";

            cmbGxEdi.DataSource = dt;
            cmbGxEdi.DisplayMember = "STATION_DESC";
            cmbGxEdi.ValueMember = "STATION_CODE";

            //获取产线
            DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.coup.FrmMachine.getQueryPline", new object[] { "F" }, this.ob);
            cmbCx.DataSource = dt1;
            cmbCx.DisplayMember = "PLINE_NAME";
            cmbCx.ValueMember = "PLINE_CODE";

            cmbCxEdi.DataSource = dt1;
            cmbCxEdi.DisplayMember = "PLINE_NAME";
            cmbCxEdi.ValueMember = "PLINE_CODE";

        }
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "DoQuery":
                    DoQuery();
                    break;
                case "DoSave":
                    DoSave();
                    break;
                case "DoUpdate":
                    DoUpdate();
                    break;
                case "DoDelete":
                    DoDelete();
                    break;
                case "DoClose":
                    this.Close();
                    break;
            }
        }
        /// <summary>
        /// 查询
        /// </summary>
        private void DoQuery() 
        {
            string plincode="";
            string stationNo="";
            if (chkCx.Checked) { if (cmbCx.Text != "") { plincode = cmbCx.Value.ToString(); } }
            if (chkGx.Checked) { if (cmbGx.Text != "") { stationNo = cmbGx.Value.ToString(); } }

            DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.heatTreatment.FrmSizBaseConfigInfo.getQueryBasic", new object[] { plincode, stationNo }, this.ob);
            GridHelper.CopyDataToDatatable(ref dt, ref dataTable1, true);
        }
        /// <summary>
        /// 新增
        /// </summary>
        private void DoSave()
        {
            int count = 0;
            if (cmbCxEdi.Text == "") { MessageUtil.ShowTips("请选择产线！"); return; }
            if (cmbGxEdi.Text == "") { MessageUtil.ShowTips("请选择工序点！"); return; }
            ArrayList pram = new ArrayList();
            pram.Add(cmbCxEdi.Value.ToString());
            pram.Add(cmbCxEdi.Text.ToString());
            pram.Add(cmbGxEdi.Value.ToString());
            pram.Add(cmbGxEdi.Text.ToString());
            pram.Add(TxtGxSeq.Text.ToString());
            pram.Add(this.UserInfo.GetUserName());

            DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.heatTreatment.FrmSizBaseConfigInfo.getQueryBasic", new object[] { cmbCxEdi.Value.ToString(), cmbGxEdi.Value.ToString() }, this.ob);
            if (dt.Rows.Count > 0)
            {
                MessageUtil.ShowTips("有重复产线和工序点,请确认？");
                return;
            }
            count = ServerHelper.SetData("com.steering.mes.mcp.heatTreatment.FrmSizBaseConfigInfo.getAddBasic", new object[] { pram }, this.ob);
            if (count >0)
            {
                MessageUtil.ShowTips("新增成功！");
                DoQuery();
            }
            else
            {
                MessageUtil.ShowTips("新增失败！");
                return;
            }
        }
        /// <summary>
        /// 修改
        /// </summary>
        private void DoUpdate() 
        {
            UltraGridRow uRow = ultraGrid1.ActiveRow;
            if (uRow == null) return;
            int count = 0;
            ArrayList pram = new ArrayList();
            pram.Add(cmbCxEdi.Value.ToString());
            pram.Add(cmbCxEdi.Text.ToString());
            pram.Add(cmbGxEdi.Value.ToString());
            pram.Add(cmbGxEdi.Text.ToString());
            pram.Add(TxtGxSeq.Text.ToString());
            pram.Add(this.UserInfo.GetUserName());
            pram.Add(uRow.Cells["PLINE_CODE"].Value.ToString());
            pram.Add(uRow.Cells["STATION_CODE"].Value.ToString());
            if (cmbCxEdi.Value.ToString() != uRow.Cells["PLINE_CODE"].Value.ToString() || cmbGxEdi.Value.ToString() != uRow.Cells["STATION_CODE"].Value.ToString())
            {
                DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.heatTreatment.FrmSizBaseConfigInfo.getQueryBasic", new object[] { cmbCxEdi.Value.ToString(), cmbGxEdi.Value.ToString() }, this.ob);
                if (dt.Rows.Count > 0)
                {
                    MessageUtil.ShowTips("有重复产线和工序点,请确认？");
                    return;
                }
            }
            count = ServerHelper.SetData("com.steering.mes.mcp.heatTreatment.FrmSizBaseConfigInfo.getUpdateBasic", new object[] { pram }, this.ob);
            if (count > 0)
            {
                MessageUtil.ShowTips("修改成功！");
                DoQuery();
            }
            else
            {
                MessageUtil.ShowTips("修改失败！");
                return;
            }
        }
        /// <summary>
        /// 删除
        /// </summary>
        private void DoDelete() 
        {
            UltraGridRow uRow = ultraGrid1.ActiveRow;
            if (uRow == null) return;
            int count = 0;
            ArrayList pram = new ArrayList();
            pram.Add(uRow.Cells["PLINE_CODE"].Value.ToString());
            pram.Add(uRow.Cells["STATION_CODE"].Value.ToString());
            DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.heatTreatment.FrmSizBaseConfigInfo.getQueryBasic", new object[] { uRow.Cells["PLINE_CODE"].Value.ToString(), uRow.Cells["STATION_CODE"].Value.ToString() }, this.ob);
            if (dt.Rows.Count == 0)
            {
                MessageUtil.ShowTips("已删除！");
                return;
            }
            count = ServerHelper.SetData("com.steering.mes.mcp.heatTreatment.FrmSizBaseConfigInfo.getDeleteBasic", new object[] { pram }, this.ob);
            if (count > 0)
            {
                MessageUtil.ShowTips("删除成功！");
                DoQuery();
            }
            else
            {
                MessageUtil.ShowTips("删除失败！");
                return;
            }
        }

        private void chkCx_CheckedChanged(object sender, EventArgs e)
        {
            if (chkCx.Checked) { cmbCx.Enabled = true; } else { cmbCx.Enabled = false; }
            if (chkGx.Checked) { cmbGx.Enabled = true; } else { cmbGx.Enabled = false; }
        }

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow uRow = ultraGrid1.ActiveRow;
            if (uRow == null) return;
            TxtGxSeq.Text = uRow.Cells["STATION_NO"].Text.ToString();
            cmbCxEdi.Value = uRow.Cells["PLINE_CODE"].Text.ToString();
            cmbGxEdi.Value = uRow.Cells["STATION_CODE"].Text.ToString();
        }

    }
}