MES_Client/TGMES/Core.StlMes.Client.Plan.Order/PopupWindow/FrmPlineGroup.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 System.Collections;
using CoreFS.CA06;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Control;

namespace Core.StlMes.Client.Plan.Order
{
    public partial class FrmPlineGroup : FrmBase
    {
        public FrmPlineGroup()
        {
            InitializeComponent();
        }

        private void FrmPlineGroup_Load(object sender, EventArgs e)
        {
            queryPlanWeight();
        }

        public FrmPlineGroup(OpeBase ops)
        {
            this.ob = ops;
            InitializeComponent();
        }

        private void queryPlanWeight()
        {
            DataTable dtGroup = new DataTable();
            dtGroup.Columns.Add("GROUP_ROLL");
            dtGroup.Columns.Add("PLINE_NAME");

            DataTable dt1 = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryRollPlanWeight",
                new object[] { DateTime.Now.AddMonths(-1).ToString("yyyy-MM") }, this.ob);
            DataTable dt2 = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryRollPlanWeight",
                new object[] { DateTime.Now.ToString("yyyy-MM") }, this.ob);
            DataTable dt3 = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryRollPlanWeight",
                new object[] { DateTime.Now.AddMonths(1).ToString("yyyy-MM") }, this.ob);
            foreach (DataRow dr in dt1.Rows)
            {
                DataRow row = dtGroup.NewRow();
                row["GROUP_ROLL"] = dr["GROUP_ROLL"].ToString();
                row["PLINE_NAME"] = dr["PLINE_NAME"].ToString();
                dtGroup.Rows.Add(row);
            }

            foreach (DataRow dr in dt2.Rows)
            {
                dtGroup.DefaultView.RowFilter = "GROUP_ROLL = '" + dr["GROUP_ROLL"].ToString() + "'";
                if (dtGroup.DefaultView.ToTable().Rows.Count == 0)
                {
                    DataRow row = dtGroup.NewRow();
                    row["GROUP_ROLL"] = dr["GROUP_ROLL"].ToString();
                    row["PLINE_NAME"] = dr["PLINE_NAME"].ToString();
                    dtGroup.Rows.Add(row);
                }
            }

            foreach (DataRow dr in dt3.Rows)
            {
                dtGroup.DefaultView.RowFilter = "GROUP_ROLL = '" + dr["GROUP_ROLL"].ToString() + "'";
                if (dtGroup.DefaultView.ToTable().Rows.Count == 0)
                {
                    DataRow row = dtGroup.NewRow();
                    row["GROUP_ROLL"] = dr["GROUP_ROLL"].ToString();
                    row["PLINE_NAME"] = dr["PLINE_NAME"].ToString();
                    dtGroup.Rows.Add(row);
                }
            }

            DataTable dt = new DataTable();
            dt.Columns.Add("GROUP_ROLL");
            dt.Columns.Add("PLANWEIGHT1");
            dt.Columns.Add("PLANWEIGHT2");
            dt.Columns.Add("PLANWEIGHT3");
            foreach (DataRow row in dtGroup.Rows)
            {
                DataRow dr = dt.NewRow();
                dr["GROUP_ROLL"] = row["PLINE_NAME"].ToString();

                dt1.DefaultView.RowFilter = "GROUP_ROLL='" + row["GROUP_ROLL"].ToString() + "'";
                if (dt1.DefaultView.ToTable() != null && dt1.DefaultView.ToTable().Rows.Count > 0)
                {
                    dr["PLANWEIGHT1"] = dt1.DefaultView.ToTable().Rows[0]["PLANWEIGHT"].ToString();
                }

                dt2.DefaultView.RowFilter = "GROUP_ROLL='" + row["GROUP_ROLL"].ToString() + "'";
                if (dt2.DefaultView.ToTable() != null && dt2.DefaultView.ToTable().Rows.Count > 0)
                {
                    dr["PLANWEIGHT2"] = dt2.DefaultView.ToTable().Rows[0]["PLANWEIGHT"].ToString();
                }

                dt3.DefaultView.RowFilter = "GROUP_ROLL='" + row["GROUP_ROLL"].ToString() + "'";
                if (dt3.DefaultView.ToTable() != null && dt3.DefaultView.ToTable().Rows.Count > 0)
                {
                    dr["PLANWEIGHT3"] = dt3.DefaultView.ToTable().Rows[0]["PLANWEIGHT"].ToString();
                }
                dt.Rows.Add(dr);
            }
            GridHelper.CopyDataToDatatable(dt, dataTable1, true);
            PlanComm.setGridActivation(ultraGrid1.DisplayLayout.Bands[0]);
        }
    }
}