MES_Client/TGMES/Core.StlMes.Client.PlnSaleOrd/炼钢计划/control/FrmOrderZgPln.cs

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

namespace Core.StlMes.Client.PlnSaleOrd.炼钢计划.control
{
    public partial class FrmOrderZgPln : FrmBase
    {
        private string proPlanId = "";
        private OpeBase ob;
        public FrmOrderZgPln(string _proPlanId, OpeBase _ob)
        {
            InitializeComponent();
            proPlanId = _proPlanId;
            ob = _ob;
            this.IsLoadUserView = true;
        }
        private void FrmOrderZgPln_Load(object sender, EventArgs e)
        {
            PlanComm.setGridDigitalCol(ultraGridZgMs.DisplayLayout.Bands[0], 5, 2, "OUTDIAMETER",
               "WALLTHICK", "LEN_ROLL_MAX", "LEN_ROLL_MIN", "AIMOUTDIAMETER", "AIMLENGTH",
               "DIAMETER_GP", "LENGTH_GP", "ROLL_LENGTH", "DIAMETER_MANDREL", "AIMWALLTHICK",
               "LEN_GP_SINGLE", "LEN_CUTHEAD", "LEN_CUTEND", "TUBE_END_RATIO");
            PlanComm.setGridDigitalCol(ultraGridZgMs.DisplayLayout.Bands[0], 5, 3, "IN_WEIGHT_S",
                "WEIGTH_S", "BATCHED_WT", "FINISHWEIGHT", "WEIGTH_S_MIN", "GPREQ_WEIGHT", "FurnWt", "LjWeight", "Reall_WT", "ALLOWANCE", "MATCH_WT_IN", "OUT_WT","OUT_NUM");
            PlanComm.setGridDigitalCol(ultraGridZgMs.DisplayLayout.Bands[0], 5, 0, "FINISHNUM",
                "BATCHED_NUM", "NUM_S", "IN_NUM_S", "OUTNUM_CUT", "MULTIPLE_NUM", "PLAN_USETIME", "GPREQ_NUM", "PLANS_NUM", "FurnNum", "LjNum", "Reall_NUM", "MATCH_NUM_IN", "OUT_NUM");
            BaseHelper.GridColumnSum(ultraGridZgMs, new string[] {
                "WEIGTH_S", "WEIGTH_S_MIN", "GPREQ_WEIGHT", "FurnWt", "LjWeight", "Reall_WT","MATCH_WT_IN","OUT_WT"});
            BaseHelper.GridColumnCount(ultraGridZgMs, new string[] {
               "NUM_S", "GPREQ_NUM", "FurnNum", "LjNum", "Reall_NUM", "MATCH_NUM_IN","OUT_NUM" });
            Query();
        }
        private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
        {
            switch (e.Tool.Key)
            {
                case "Query":
                    Query();
                    break;
                case "Close":
                    this.Close();
                    break;
            }
        }
        private void Query()
        {
            //DataTable dtlz = new DataTable();
            DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.steelMarkingPlan.FrmSteelPlnZg.doPlnZgQuery",
           new object[] { proPlanId }, this.ob);
            GridHelper.CopyDataToDatatable(dt, dataTable4, true);
            //if (dt.Rows.Count > 0)
            //{
            //    dtlz = ServerHelper.GetData("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.queryLZDataZg", new object[] { }, ob);
            //}
            foreach (UltraGridRow ugr in ultraGridZgMs.Rows)
            {
                //int numz = 0;
                //double wtz = 0;
                int numLj = 0;
                double wtLj = 0;
                //int batNum = 0;
                //double batWt = 0;
                //if (dtlz.Rows.Count > 0)
                //{
                //    DataRow[] drs = dtlz.Select("订单号 ='" + ugr.Cells["PRO_PLAN_ID"].Value.ToString() + "' AND 序号='" + ugr.Cells["GX_PLAN_NO"].Value.ToString() + "'");

                //    if (drs != null && drs.Length > 0)
                //    {
                //        //if(dtlz.Rows.Count>0){
                //        if (!drs[0]["装炉支"].ToString().Equals(""))
                //        {
                //            ugr.Cells["FurnNum"].Value = drs[0]["装炉支"].ToString();
                //            ugr.Cells["FurnWt"].Value = drs[0]["装炉吨"].ToString();
                //            numz = int.Parse(ugr.Cells["FurnNum"].Value.ToString());
                //            wtz = double.Parse(ugr.Cells["FurnWt"].Value.ToString());
                //        }
                //        else
                //        {
                //            numz = 0;
                //            wtz = 0;
                //        }
                //        if (!drs[0]["LJ支"].ToString().Equals(""))
                //        {
                //            ugr.Cells["LjNum"].Value = drs[0]["LJ支"].ToString();
                //            ugr.Cells["LjWeight"].Value = drs[0]["LJ吨"].ToString();
                //            numLj = int.Parse(ugr.Cells["LjNum"].Value.ToString());
                //            wtLj = double.Parse(ugr.Cells["LjWeight"].Value.ToString());
                //        }
                //        else
                //        {
                //            numLj = 0;
                //            wtLj = 0;
                //        }
                //        if (!drs[0]["出库支"].ToString().Equals(""))
                //        {
                //            ugr.Cells["OUT_NUM"].Value = drs[0]["出库支"].ToString();
                //            ugr.Cells["OUT_WT"].Value = drs[0]["出库吨"].ToString();
                //            batNum = int.Parse(ugr.Cells["OUT_NUM"].Value.ToString());
                //            batWt = double.Parse(ugr.Cells["OUT_WT"].Value.ToString());
                //        }
                //        else
                //        {
                //            batNum = 0;
                //            batWt = 0;
                //        }
                //    }
                //}
                //if (ugr.Cells["LjNum"].Value.Equals("0"))
                //{
                //    numLj = int.Parse(ugr.Cells["MATCH_NUM_IN"].Value.ToString());
                //    wtLj = double.Parse(ugr.Cells["MATCH_WT_IN"].Value.ToString());
                //}
                //else
                //{
                    numLj = int.Parse(ugr.Cells["LjNum"].Value.ToString());
                    wtLj = double.Parse(ugr.Cells["LjWeight"].Value.ToString());
                //}
                int gpNum = 0;
                double gpWt = 0;
                if (ugr.Cells["GPREQ_NUM"].Text.Equals(""))
                {
                    gpNum = 0;
                    gpWt = 0;
                }
                else
                {
                    gpNum = int.Parse(ugr.Cells["GPREQ_NUM"].Value.ToString());
                    gpWt = double.Parse(ugr.Cells["GPREQ_WEIGHT"].Value.ToString());
                }
                double matcInWt = double.Parse(ugr.Cells["MATCH_WT_IN"].Value.ToString());
                int matcInNum = int.Parse(ugr.Cells["MATCH_NUM_IN"].Value.ToString());
                if (gpNum  - numLj - matcInNum < 0)
                {
                    ugr.Cells["Reall_NUM"].Value = "0";
                }
                else
                {
                    ugr.Cells["Reall_NUM"].Value = (gpNum - numLj).ToString();
                }
                if (gpWt -  wtLj - matcInWt < 0)
                {
                    ugr.Cells["Reall_WT"].Value = "0";
                }
                else
                {
                    ugr.Cells["Reall_WT"].Value = (gpWt - - wtLj ).ToString();
                }
                if (!ugr.Cells["Reall_WT"].Text.ToString().Equals(""))
                {

                }
                string[] groupCic = null;
                if (!ugr.Cells["CIC_GROUP_GP"].Text.Equals(""))
                {
                    groupCic = ugr.Cells["CIC_GROUP_GP"].Text.ToString().Split(',');
                }
                string cic = "";
                DataTable dtcic = ServerHelper.GetData("com.steering.pss.plnsaleord.GpOptimize.FrmGradeAnalysis.getQueryGradeZl",
                new object[] { groupCic, "0" }, this.ob);
                if (dtcic.Rows.Count > 0)
                {
                    for (int z = 0; z < dtcic.Rows.Count; z++)
                    {
                        cic += dtcic.Rows[z]["CIC"].ToString() + ",";
                    }
                    cic = cic.Substring(0, cic.Length - 1);
                }
                ugr.Cells["CIC_GROUP_GP"].Value = cic;
            }
        }
       
    }
}