MES_Client/TGMES/Core.StlMes.Client.PlnSaleOrd/Control/ComMscPilneCtrl.cs

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;
using CoreFS.CA06;
using Core.Mes.Client.Comm.Control;
using Infragistics.Win.UltraWinGrid;

namespace Core.StlMes.Client.PlnSaleOrd
{
    public partial class ComMscPilneCtrl : UserControl
    {
        /// <summary>
        /// 质量设计
        /// </summary>
        private string desginKey = "";
        /// <summary>
        /// 合同行pk
        /// </summary>
        private string ordLnPk = "";
        /// <summary>
        /// 交货行pk
        /// </summary>
        private string ordLnDivPk = "";
        /// <summary>
        /// 选择工艺号
        /// </summary>
        private string cheCraftNo = "";
        /// <summary>
        /// 工艺序号
        /// </summary>
        private string cheCraftSeq = "";
        /// <summary>
        /// 工艺负责人
        /// </summary>
        private string cheCraftName = "";
        /// <summary>
        /// 制程
        /// </summary>
        private string cheMscPline = "";
        /// <summary>
        /// 制程钢种
        /// </summary>
        private string gradeNameAll = "";
        /// <summary>
        /// 合同来源
        /// </summary>
        private string orderSource = "";

        private ComMscPilneBLL mscPilneBLL;

        public ComMscPilneCtrl()
        {
            InitializeComponent();
            PlanComm.setGridActivation(this.ultraGridMscPline.DisplayLayout.Bands[0], "CHC");
        }

        public void ComBLL(OpeBase ob)
        {
            mscPilneBLL = new ComMscPilneBLL(ob);
        }

        /// <summary>
        /// 查询制程
        /// </summary>
        public void DoQuery()
        {
            DataTable dt = new DataTable();
            if (orderSource.Equals("备料需求") || ordLnPk.StartsWith("ZZBY"))
            {
                DataTable ds = mscPilneBLL.QueryPk(ordLnDivPk);
                dt = mscPilneBLL.Query(ds.Rows[0]["ORD_LN_PK"].ToString2());
            }
            else
            {
                dt = mscPilneBLL.Query(ordLnPk);
            }
            
            GridHelper.CopyDataToDatatable(dt, this.dataTable1, true);
            if (!cheMscPline.Equals("") && !cheCraftSeq.Equals("") && ultraGridMscPline.Rows.Count > 0)
            {
                foreach (UltraGridRow uRow in this.ultraGridMscPline.Rows)
                {
                    if (uRow.Cells["MSC_PLINE"].Value.ToString().Equals(cheMscPline)
                        && uRow.Cells["CRAFT_SEQ"].Value.ToString().Equals(cheCraftSeq))
                    {
                        uRow.Cells["CHC"].Value = true;
                        desginKey = uRow.Cells["DESGIN_KEY"].Value.ToString();
                        cheCraftNo = uRow.Cells["CRAFT_NO"].Value.ToString();
                        cheCraftName = uRow.Cells["CRAFT_NAME"].Value.ToString();
                        gradeNameAll = "";
                        foreach (UltraGridRow cRow in ultraGridGrade.Rows)
                        {
                            gradeNameAll += cRow.Cells["GRADENAME"].Value.ToString() + ",";
                        }
                        if (gradeNameAll.Contains(','))
                        {
                            int num = gradeNameAll.LastIndexOf(',');
                            gradeNameAll = gradeNameAll.Substring(0, num);
                        }
                        ultraGridMscPline.ActiveRow = uRow;
                    }
                }
            }
        }

        /// <summary>
        /// 查询制程信息
        /// </summary>
        public void DoQueryInfo(string desginKey, string mscPline)
        {
            DataTable dtPrc = mscPilneBLL.QueryPrc(desginKey, mscPline);
            DataTable dtGrade = mscPilneBLL.QueryGrade(desginKey, mscPline);
            lblStationPath.Value = mscPilneBLL.QueryStation(desginKey, mscPline);

            GridHelper.CopyDataToDatatable(dtPrc, this.dataTable2, true);
            GridHelper.CopyDataToDatatable(dtGrade, this.dataTable3, true);

            PlanComm.setGridActivation(this.ultraGridProcess.DisplayLayout.Bands[0]);
            PlanComm.setGridActivation(this.ultraGridGrade.DisplayLayout.Bands[0]);
        }

        private void ultraGridMscPline_AfterRowActivate(object sender, EventArgs e)
        {
            string mscPline = ultraGridMscPline.ActiveRow.Cells["MSC_PLINE"].Value.ToString();
            DoQueryInfo(desginKey, mscPline);
        }

        private void ultraGridMscPline_CellChange(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e)
        {
            if (e.Cell.Column.Key.Equals("CHC"))
            {
                if (Convert.ToBoolean(e.Cell.Row.Cells["CHC"].Text))
                {
                    cheMscPline = e.Cell.Row.Cells["MSC_PLINE"].Value.ToString();
                    cheCraftNo = e.Cell.Row.Cells["CRAFT_NO"].Value.ToString();
                    cheCraftSeq = e.Cell.Row.Cells["CRAFT_SEQ"].Value.ToString();
                    cheCraftName = e.Cell.Row.Cells["CRAFT_NAME"].Value.ToString();
                    desginKey = e.Cell.Row.Cells["DESGIN_KEY"].Value.ToString();
                    gradeNameAll = "";
                    foreach (UltraGridRow uRow in ultraGridGrade.Rows)
                    {
                        gradeNameAll += uRow.Cells["GRADENAME"].Value.ToString() + ",";
                    }
                    if (gradeNameAll.Contains(','))
                    {
                        gradeNameAll = gradeNameAll.Substring(0,
                            gradeNameAll.LastIndexOf(','));
                    }
                    foreach (UltraGridRow uRow in ultraGridMscPline.Rows)
                    {
                        if (uRow != e.Cell.Row)
                        {
                            uRow.Cells["CHC"].Value = false;
                        }
                    }
                }
                else
                {
                    e.Cell.Row.Cells["CHC"].Value = true;
                }
            }
        }
        
        /// <summary>
        /// 合同来源
        /// </summary>
        public string OrderSource
        {
            get { return orderSource; }
            set { orderSource = value; }
        }
        /// <summary>
        /// 交货行PK
        /// </summary>
        public string OrdLnDivPk
        {
            get { return ordLnDivPk; }
            set { ordLnDivPk = value; }
        }
        /// <summary>
        /// 质量设计
        /// </summary>
        public string DesginKey
        {
            get { return desginKey; }
            set { desginKey = value; }
        }

        /// <summary>
        /// 制程
        /// </summary>
        public string CheMscPline
        {
            get { return cheMscPline; }
            set { cheMscPline = value; }
        }

        /// <summary>
        /// 选择工艺号
        /// </summary>
        public string CheCraftNo
        {
            get { return cheCraftNo; }
            set { cheCraftNo = value; }
        }

        /// <summary>
        /// 工艺序号
        /// </summary>
        public string CheCraftSeq
        {
            get { return cheCraftSeq; }
            set { cheCraftSeq = value; }
        }

        /// <summary>
        /// 工艺负责人
        /// </summary>
        public string CheCraftName
        {
            get { return cheCraftName; }
            set { cheCraftName = value; }
        }

        /// <summary>
        /// 合同行pk
        /// </summary>
        public string OrdLnPk
        {
            get { return ordLnPk; }
            set { ordLnPk = value; }
        }

        /// <summary>
        /// 制程钢种
        /// </summary>
        public string GradeNameAll
        {
            get { return gradeNameAll; }
            set { gradeNameAll = value; }
        }


        /// <summary>
        /// 制程grid
        /// </summary>
        public Infragistics.Win.UltraWinGrid.UltraGrid UltraGridMscPline
        {
            get { return ultraGridMscPline; }
            set { ultraGridMscPline = value; }
        }
    }
}