XinYu_LG2MES/ClientSolution/Core.LgMes.Client.LgJobMgt/弹出窗体/frmScrapSteel.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using CoreFS.CA06;
using System.IO;
using Infragistics.Win.UltraWinGrid;
using System.Collections;
using Core.Mes.Client.Common;

namespace Core.LgMes.Client.LgJobMgt
{
    public partial class frmScrapSteel : Form
    {
        public frmScrapSteel(string strHeatNo, string strStationCode, string strDisposalTime, string szDT)
        {
            InitializeComponent();
            _szCZSJ = szDT;
            _strHeatNo = strHeatNo;
            _strStationCode = strStationCode;
            _strDisposalTime = strDisposalTime;
        }


        private string _szCZSJ;
        private string _strHeatNo;
        private string _strStationCode;
        private string _strDisposalTime;
        private DataSet _dsTBH = new DataSet();
        public OpeBase ob;   //服务端URL

        /// <summary>
        /// 打开窗体时自动取入炉明细数据
        /// </summary>
        private void GetDataSource()
        {
            try
            {
                this.dataTable1.Rows.Clear();              
                int intRowId = 0;               
                string strErr = "";

                ArrayList arry = new ArrayList();
                arry.Add("GetScrapSteelInfo.Select");//此ID为XML文件ID
                arry.Add(System.DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00");
                arry.Add(System.DateTime.Now.ToString("yyyy-MM-dd") + " 23:59:59");

                CommonClientToServer ccTs = new CommonClientToServer();
                ccTs.ob = ob;
                //查询转炉作业信息
                DataSet ds = ccTs.ExecuteQueryFunctions("Core.LgMes.Server.LgJobMgt.ClassBofJob",
                                                           "GetScrapSteelInfo", arry, out strErr);


                if (strErr == "" && ds != null)
                {
                    if (ds.Tables[0].Rows.Count > 0)
                    {
                        for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                        {
                            DataRow dr = this.dataTable1.NewRow();
                            for (int j = 0; j < this.dataTable1.Columns.Count; j++)
                            {
                                if (dataTable1.Columns[j].ColumnName == "BC")
                                {
                                    if (ds.Tables[0].Rows[i]["BC"].ToString().Length > 1)
                                    {
                                        string v_BC = ds.Tables[0].Rows[i]["BC"].ToString().Trim().Substring(1, 1);
                                        if (v_BC == "1")
                                            dr[dataTable1.Columns[j].ColumnName] = "甲班";
                                        if (v_BC == "2")
                                            dr[dataTable1.Columns[j].ColumnName] = "乙班";
                                        if (v_BC == "3")
                                            dr[dataTable1.Columns[j].ColumnName] = "丙班";
                                        if (v_BC == "4")
                                            dr[dataTable1.Columns[j].ColumnName] = "丁班";
                                    }
                                }
                                else if (dataTable1.Columns[j].ColumnName == "ZYSJ")
                                {
                                    dr["ZYSJ"] = Convert.ToDateTime(ds.Tables[0].Rows[i]["ZYSJ"].ToString()).ToString("yyyy-MM-dd HH:mm:ss");
                                }
                                else
                                {
                                    if (ds.Tables[0].Columns.Contains(dataTable1.Columns[j].ColumnName) && !string.IsNullOrEmpty(ds.Tables[0].Rows[i][dataTable1.Columns[j].ColumnName].ToString()))
                                        dr[dataTable1.Columns[j].ColumnName] = ds.Tables[0].Rows[i][dataTable1.Columns[j].ColumnName].ToString();
                                }


                            }
                            this.dataTable1.Rows.Add(dr);

                            if (dr["LH"].ToString() == _strHeatNo)
                            {
                                foreach (UltraGridCell cell in ultrScrapSteel.Rows[intRowId].Cells)
                                {
                                    cell.Appearance.ForeColor = Color.Red;
                                }
                            }
                            intRowId += 1;
                        }
                        this.dataTable1.AcceptChanges();
                        SetSteelSum();
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        /// <summary>
        /// 统计废钢重量
        /// </summary>
        private void SetSteelSum()
        {
            UltraGridBand band = this.ultrScrapSteel.DisplayLayout.Bands[0];

            band.Summaries.Clear();

            SummarySettings summary = band.Summaries.Add(SummaryType.Count, band.Columns[1]);
            summary.SummaryPosition = SummaryPosition.UseSummaryPositionColumn;
            summary.DisplayFormat = "合计：";

            for (int i = 7; i < 14; i++)
            {
                summary = band.Summaries.Add(SummaryType.Sum, band.Columns[i]);

                summary.SummaryPosition = SummaryPosition.UseSummaryPositionColumn;

                summary.DisplayFormat = " {0:#####.00}";

                summary.Appearance.TextHAlign = Infragistics.Win.HAlign.Center;
                summary.Appearance.ForeColor = Color.DarkBlue;
                summary.Appearance.BackColor = Color.White;
            }


            band.Override.SummaryFooterCaptionVisible = Infragistics.Win.DefaultableBoolean.False;
        }

        private void frmScrapSteel_Load(object sender, EventArgs e)
        {
            GetDataSource();
        }

        private void ultrScrapSteel_DoubleClick(object sender, EventArgs e)
        {
            string strSqlID = "";
            string strErr = "";

            if (ultrScrapSteel.ActiveRow != null)
            {
                string v_LH = _strHeatNo;

                string v_FGZL = ultrScrapSteel.ActiveRow.Cells["HGZL"].Value.ToString() == "" ? "0" : ultrScrapSteel.ActiveRow.Cells["HGZL"].Value.ToString();
                string v_STZL = ultrScrapSteel.ActiveRow.Cells["STZL"].Value.ToString() == "" ? "0" : ultrScrapSteel.ActiveRow.Cells["STZL"].Value.ToString();
                string v_ZLH = _strStationCode;                
                string v_XH = ultrScrapSteel.ActiveRow.Cells["ZYXH"].Value.ToString();
                string v_JOINMARLWGT = ultrScrapSteel.ActiveRow.Cells["CLZL"].Value.ToString();
                string V_RSTEELWGT = ultrScrapSteel.ActiveRow.Cells["ZGZL"].Value.ToString();

                if (!string.IsNullOrEmpty(v_XH) && !string.IsNullOrEmpty(v_FGZL.Trim()) &&
                    !string.IsNullOrEmpty(v_STZL.Trim()) && !string.IsNullOrEmpty(v_LH.Trim()))
                {
                    strSqlID = "BofScrapSteel.INSERT"; //SQLID 

                    Hashtable ht = new Hashtable();
                 
                    ht.Add("I1", v_LH);           //炉号
                    ht.Add("I2", v_FGZL);         //废钢重量
                    ht.Add("I3", v_STZL);         //生铁重量
                    ht.Add("I4", v_ZLH  );        //工位号
                    ht.Add("I5", v_XH);           //作业序号
                    ht.Add("I6", v_JOINMARLWGT);  //压块
                    ht.Add("I7", V_RSTEELWGT);    //渣钢
                 
                    CommonClientToServer ccTs = new CommonClientToServer();
                    ccTs.ob = ob;

                    string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.LgJobMgt.ClassBofJob",
                                                    "BofScrapSteel", strSqlID, ht, out strErr);
                    if (strErr != "")
                        MessageBox.Show("废钢生铁数据确认失败，重试！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    else
                    {
                        MessageBox.Show("废钢加入成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                        this.Close();
                    }
                }
            }
        }
    }
}