XinYu_LG2MES/ClientSolution/Core.LgMes.Client.Comm/公共弹出窗体/.svn/text-base/frmZDInIron.cs.svn-base

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Threading;
using Core.LgMes.Client.lgClassModel;
using System.Collections;
using System.Reflection;
using CoreFS.CA06;

namespace Core.LgMes.Client.lgJobMgt.弹出窗体
{
    public partial class frmZDInIron : Form
    {

        public double AllWeight = 0;
        public string Laiyuan = "";
        public string stoveNo = "";
        public ArrayList alZDInIron = new ArrayList();
        public string str_C = "", str_Si = "", str_Mn = "", str_P = "", str_S = "", str_Asn = "", str_Cu = "", str_Sn = "", str_Sb = "";

        public frmZDInIron()
        {
            InitializeComponent();
        }


        private void frmZDInIron_Load_1(object sender, EventArgs e)
        {
            getInIronNoDate();
        }

        private void getInIronNoDate()
        {
            string strOut = "", strWhere = "";
            //string potid = this.Text.Substring(0, 1) + "#混铁炉";
            strWhere = "where FOLDPOTWGT > 0 and to_char(ARRIVETIME, 'YYYYMMDDHH24MISS') BETWEEN " +
                       " to_char((sysdate - 1 / 3), 'YYYYMMDDHH24MISS') and to_char(sysdate, 'YYYYMMDDHH24MISS') " +
                       " and  (substr(MolirnSource,1,1)<>'Z' and substr(MolirnSource,1,1)<>'N' or MolirnSource is null) ";
            try
            {
                //hengxing
                //CallingMessage par = new CallingMessage();
                //par.ServerName = "lgJobMgt";
                //par.AssemblyName = "Core.LgMes.Server.lgJobMgt";
                //par.ClassName = "Core.LgMes.Server.lgJobMgt.classIronJob";
                //par.MethodName = "GetZDInIronNoDate";
                //par.args = new object[] { strWhere };

                DataSet ds = null;// (DataSet)ClientCommon._RemotingHelp.ExecuteMethod(par, out strOut);

                ultraDataSource1.Rows.Clear();
                if (ds.Tables.Count > 0)
                {
                    foreach (DataRow dr in ds.Tables[0].Rows)
                    {
                        ultraDataSource1.Rows.Add(new object[] {
                                                       Convert.ToBoolean(dr["flag"]),
                                                        dr["MISID"].ToString(),
                                                        dr["FOLDPOTWGT"].ToString(),                                                   
                                                        dr["ZDWeight"].ToString(),
                                                        "0",
                                                        dr["STOVEID"].ToString(),
                                                        dr["TFPOTID"].ToString(),
                                                        dr["ARRIVETIME"].ToString(),
                                                        dr["C"].ToString(),
                                                        dr["Si"].ToString(),
                                                        dr["Mn"].ToString(),
                                                        dr["P"].ToString(),
                                                        dr["S"].ToString(),
                                                        dr["Asn"].ToString(),
                                                        dr["Cu"].ToString(),
                                                        dr["Sn"].ToString(),
                                                        dr["Sb"].ToString()}); //dr["FOLDPOTWGT"].ToString()
                    }
                }
            }
            catch
            {
            }
        }

        private void ulbtnCancel_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void ultraGrid1_CellChange(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e)
        {
            switch (e.Cell.Column.Key)
            {
                case "OutWeight":
                    {
                        try
                        {
                            float a = Convert.ToSingle(ultraGrid1.ActiveRow.Cells["AllWeight"].Text != System.DBNull.Value.ToString() ? ultraGrid1.ActiveRow.Cells["AllWeight"].Text : "0");
                            float b = Convert.ToSingle(ultraGrid1.ActiveRow.Cells["OutWeight"].Text != System.DBNull.Value.ToString() ? ultraGrid1.ActiveRow.Cells["OutWeight"].Text : "0");

                            ultraGrid1.ActiveRow.Cells["ShengyuWeight"].Value = Convert.ToString(a - b);
                        }
                        catch { }
                        break;
                    }

            }
        }

        private void ulbtnOK_Click(object sender, EventArgs e)
        {
            AllWeight = 0;
            Laiyuan = "";
            stoveNo = "";
            string strError = "";
            double dblIronSumWgt = 0;
            double dbl_C = 0, dbl_Si = 0, dbl_Mn = 0, dbl_P = 0, dbl_S = 0, dbl_Asn = 0, dbl_Cu = 0, dbl_Sn = 0, dbl_Sb = 0;
           
            try
            {
                foreach (Infragistics.Win.UltraWinGrid.UltraGridRow r in ultraGrid1.Rows)
                {
                    if (r.Cells["Check"].Value.ToString().ToUpper() == "TRUE")
                    {
                        AllWeight = AllWeight+Convert.ToDouble(r.Cells["OutWeight"].Value) ;
                        Laiyuan =  r.Cells["InIronNo"].Value.ToString() + " " + Laiyuan;
                        stoveNo = r.Cells["stoveno"].Value.ToString() + " " + stoveNo;

                        dblIronSumWgt = AllWeight;  //总共兑铁重量

                        dbl_C += Convert.ToDouble(r.Cells["OutWeight"].Value) * Convert.ToDouble(r.Cells["C"].Value);
                        dbl_Si += Convert.ToDouble(r.Cells["OutWeight"].Value) * Convert.ToDouble(r.Cells["Si"].Value);
                        dbl_Mn += Convert.ToDouble(r.Cells["OutWeight"].Value) * Convert.ToDouble(r.Cells["Mn"].Value);
                        dbl_P += Convert.ToDouble(r.Cells["OutWeight"].Value) * Convert.ToDouble(r.Cells["P"].Value);
                        dbl_S += Convert.ToDouble(r.Cells["OutWeight"].Value) * Convert.ToDouble(r.Cells["S"].Value);
                        dbl_Asn += Convert.ToDouble(r.Cells["OutWeight"].Value) * Convert.ToDouble(r.Cells["Asn"].Value);

                        string[] ArrayIronRow = new string[20] { "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "" }; //成分 

                        ArrayIronRow[0] = r.Cells["InIronNo"].Value.ToString();
                        ArrayIronRow[1] = r.Cells["StoveNo"].Value.ToString();
                        ArrayIronRow[2] = r.Cells["GuanNo"].Value.ToString();
                        ArrayIronRow[3] = r.Cells["InIronTime"].Value.ToString();
                        ArrayIronRow[4] = r.Cells["AllWeight"].Value.ToString();
                        ArrayIronRow[5] = r.Cells["OutWeight"].Value.ToString();
                        ArrayIronRow[6] = r.Cells["ShengyuWeight"].Value.ToString();

                        alZDInIron.Add(ArrayIronRow);         
                    }
                }            

                if (dblIronSumWgt > 0)
                {
                    str_C = Convert.ToDouble(dbl_C / dblIronSumWgt).ToString("F3");
                    str_Si = Convert.ToDouble(dbl_Si / dblIronSumWgt).ToString("F3");
                    str_Mn = Convert.ToDouble(dbl_Mn / dblIronSumWgt).ToString("F3");
                    str_P = Convert.ToDouble(dbl_P / dblIronSumWgt).ToString("F3");
                    str_S= Convert.ToDouble(dbl_S / dblIronSumWgt).ToString("F3");
                    str_Asn = Convert.ToDouble(dbl_Asn / dblIronSumWgt).ToString("F3");
                }
                   
                if (strError != "")
                    MessageBox.Show("修改记录失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            catch
            {
            }
            this.DialogResult = DialogResult.OK;

        }


        private void ultsaveHBdata_Click(object sender, EventArgs e)
        {
            string strError = "";
            try
            {
                foreach (Infragistics.Win.UltraWinGrid.UltraGridRow r in ultraGrid1.Rows)
                {
                    string[] ArrayIronRow = new string[20] { "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "" }; //记录混包数据 
                    if (r.Cells["Check"].Value.ToString().ToUpper() == "TRUE")
                    {
                        ArrayIronRow[0] = r.Cells["InIronNo"].Value.ToString();
                        ArrayIronRow[1] = r.Cells["StoveNo"].Value.ToString();
                        ArrayIronRow[2] = r.Cells["GuanNo"].Value.ToString();
                        ArrayIronRow[3] = r.Cells["IronTime"].Value.ToString();
                        ArrayIronRow[4] = r.Cells["AllWeight"].Value.ToString();
                        ArrayIronRow[5] = r.Cells["OutWeight"].Value.ToString();
                        ArrayIronRow[6] = r.Cells["ShengyuWeight"].Value.ToString();

                      
                        //Core.Mes.ClientFrameWork.ClientCommon._RemotingHelp.ExecuteMethod("lgJobMgt", "Core.LgMes.Server.lgJobMgt.classIronJob", "InsertZDHBData", new object[] { ArrayIronRow }, out strError);

                    }
                }

                if (strError != "")
                    MessageBox.Show("插入记录失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            catch
            {
            }

        }
     
    }
}