XinYu_LG2MES/ClientSolution/Core.LgMes.Client.Report/成本核算/frmInterface.cs

using System;
using System.IO;
using System.Drawing;
using System.Collections;
using System.Diagnostics;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Threading;
using CoreFS.CA06;
using Infragistics.Win.UltraWinMaskedEdit;
using Infragistics.Win.UltraWinGrid;
using Infragistics.Win;
using Core.Mes.Client.Common;
//using Core.LgMes.Client.LgJobMgt;
using Core.LgMes.Client.LgDeviceManager;

namespace Core.LgMes.Client.Report
{
    public partial class frmInterface : FrmBase
    {
        public frmInterface()
        {
            InitializeComponent();
        }

        private static string strKey = "";

        private static string serverDateTime = "";
        private static string oldValue = "";

        private static SortedList sortPsendtime = new SortedList();///冶炼结束时间
        ///
        private static string startTime = "";
        private static string endTime = "";

        private bool[] updateFlag = new bool[] {false, false, false, false, false, false, false, false, false, false, false,
            false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false };

        private static ArrayList listArray = new ArrayList();

        private void timer1_Tick(object sender, EventArgs e)
        {

            getSeverDateTime();
            string strWhere = setTimeSlot();
            setUpdate();
            getQuery(strWhere);

        }

        /// <summary>
        /// 获取服务器上的时间
        /// </summary>
        private void getSeverDateTime()
        {

            ArrayList arry = new ArrayList();
            ArrayList sqlList = new ArrayList();
            arry.Add("QueryCostList.Querytime");

            CoreClientParam CCP_LgEts = new CoreClientParam();
            DataTable dt = new DataTable();
            CCP_LgEts.ServerName = "Core.LgMes.Server.Common.ComDBQuery";
            CCP_LgEts.MethodName = "doQuery";
            CCP_LgEts.ServerParams = new object[] { arry, sqlList };
            CCP_LgEts.SourceDataTable = dt;
            this.ExecuteQueryToDataTable(CCP_LgEts, CoreInvokeType.Internal);

            serverDateTime = dt.Rows[0][0].ToString();
        }

        /// <summary>
        /// 设置表单上的状态
        /// </summary>
        private void setFormSate()
        {

        }

        /// <summary>
        /// 设置时间段
        /// </summary>
        /// <returns></returns>
        private string setTimeSlot()
        {
            DateTime dtime = Convert.ToDateTime(serverDateTime);
            string timeSlot = "";
            if (dtime.Hour == 8)
            {
                if (dtime.Minute > 10)
                {
                    label2.Text = "白";
                    timeSlot = " WHERE TO_CHAR(TAPPINGSTARTTIME, 'yyyy-MM-dd HH24:MI:SS') BETWEEN '"
                        + dtime.ToString("yyyy-MM-dd") + " 08:10:01' AND '" + dtime.ToString("yyyy-MM-dd") + " 15:40:00' "
                        + "OR TAPPINGSTARTTIME IS NULL";
                    startTime = dtime.ToString("yyyy-MM-dd") + " 08:10:01";
                    endTime = dtime.ToString("yyyy-MM-dd") + " 15:40:00";

                }
                else
                {
                    label2.Text = "晚";
                    timeSlot = " WHERE TO_CHAR(TAPPINGSTARTTIME, 'yyyy-MM-dd HH24:MI:SS') BETWEEN '"
                        + dtime.AddDays(-1).ToString("yyyy-MM-dd") + " 23:40:01' AND '" + dtime.ToString("yyyy-MM-dd") + " 08:10:00'"
                        + "OR TAPPINGSTARTTIME IS NULL";
                    startTime = dtime.AddDays(-1).ToString("yyyy-MM-dd") + " 23:40:01";
                    endTime = dtime.ToString("yyyy-MM-dd") + " 08:10:00";
                }
            }
            else if (dtime.Hour == 15)
            {
                if (dtime.Minute > 40)
                {
                    label2.Text = "中";
                    timeSlot = " WHERE TO_CHAR(TAPPINGSTARTTIME, 'yyyy-MM-dd HH24:MI:SS') BETWEEN '"
                        + dtime.ToString("yyyy-MM-dd") + " 15:40:01' AND '" + dtime.ToString("yyyy-MM-dd") + " 23:40:00'"
                        + "OR TAPPINGSTARTTIME IS NULL";
                    startTime = dtime.ToString("yyyy-MM-dd") + " 15:40:01";
                    endTime = dtime.ToString("yyyy-MM-dd") + " 23:40:00";
                }
                else
                {
                    label2.Text = "白";
                    timeSlot = " WHERE TO_CHAR(TAPPINGSTARTTIME, 'yyyy-MM-dd HH24:MI:SS') BETWEEN '"
                        + dtime.ToString("yyyy-MM-dd") + " 08:10:01' AND '" + dtime.ToString("yyyy-MM-dd") + " 15:40:00'"
                        + "OR TAPPINGSTARTTIME IS NULL";
                    startTime = dtime.ToString("yyyy-MM-dd") + " 08:10:01";
                    endTime = dtime.ToString("yyyy-MM-dd") + " 15:40:00";
                }
            }
            else if (dtime.Hour == 23)
            {
                if (dtime.Minute > 40)
                {
                    label2.Text = "晚";
                    timeSlot = " WHERE TO_CHAR(TAPPINGSTARTTIME, 'yyyy-MM-dd HH24:MI:SS') BETWEEN '"
                        + dtime.ToString("yyyy-MM-dd") + " 23:40:01' AND '" + dtime.AddDays(1).ToString("yyyy-MM-dd") + " 08:10:00'"
                        + "OR TAPPINGSTARTTIME IS NULL";
                    startTime = dtime.ToString("yyyy-MM-dd") + " 23:40:01";
                    endTime = dtime.AddDays(1).ToString("yyyy-MM-dd") + " 08:10:00";
                }
                else
                {
                    label2.Text = "中";
                    timeSlot = " WHERE TO_CHAR(TAPPINGSTARTTIME, 'yyyy-MM-dd HH24:MI:SS') BETWEEN '"
                        + dtime.ToString("yyyy-MM-dd") + " 15:40:01' AND '" + dtime.ToString("yyyy-MM-dd") + " 23:40:00'"
                        + "OR TAPPINGSTARTTIME IS NULL";
                    startTime = dtime.ToString("yyyy-MM-dd") + " 15:40:01";
                    endTime = dtime.ToString("yyyy-MM-dd") + " 23:40:00";
                }
            }
            else if (dtime.Hour < 8)
            {
                label2.Text = "晚";
                timeSlot = " WHERE TO_CHAR(TAPPINGSTARTTIME, 'yyyy-MM-dd HH24:MI:SS') BETWEEN '"
                        + dtime.AddDays(-1).ToString("yyyy-MM-dd") + " 23:40:01' AND '" + dtime.ToString("yyyy-MM-dd") + " 08:10:00'"
                        + "OR TAPPINGSTARTTIME IS NULL";
                startTime = dtime.AddDays(-1).ToString("yyyy-MM-dd") + " 23:40:01";
                endTime = dtime.ToString("yyyy-MM-dd") + " 08:10:00";
            }
            else if (dtime.Hour < 15 && dtime.Hour > 8)
            {
                label2.Text = "早";
                timeSlot = " WHERE TO_CHAR(TAPPINGSTARTTIME, 'yyyy-MM-dd HH24:MI:SS') BETWEEN '"
                        + dtime.ToString("yyyy-MM-dd") + " 08:10:01' AND '" + dtime.ToString("yyyy-MM-dd") + " 15:40:00'"
                        + "OR TAPPINGSTARTTIME IS NULL";
                startTime = dtime.ToString("yyyy-MM-dd") + " 08:10:01";
                endTime = dtime.ToString("yyyy-MM-dd") + " 15:40:00";
            }
            else if (dtime.Hour < 23 && dtime.Hour > 15)
            {
                label2.Text = "中";
                timeSlot = " WHERE TO_CHAR(TAPPINGSTARTTIME, 'yyyy-MM-dd HH24:MI:SS') BETWEEN '"
                        + dtime.ToString("yyyy-MM-dd") + " 15:40:01' AND '" + dtime.ToString("yyyy-MM-dd") + " 23:40:00'"
                        + "OR TAPPINGSTARTTIME IS NULL";
                startTime = dtime.ToString("yyyy-MM-dd") + " 15:40:01";
                endTime = dtime.ToString("yyyy-MM-dd") + " 23:40:00";
            }
            else
            {
                label2.Text = "晚";
                timeSlot = " WHERE TO_CHAR(TAPPINGSTARTTIME, 'yyyy-MM-dd HH24:MI:SS') BETWEEN '"
                        + dtime.ToString("yyyy-MM-dd") + " 23:40:01' AND '" + dtime.AddDays(1).ToString("yyyy-MM-dd") + " 08:10:00'"
                        + "OR TAPPINGSTARTTIME IS NULL";
                startTime = dtime.ToString("yyyy-MM-dd") + " 23:40:01";
                endTime = dtime.AddDays(1).ToString("yyyy-MM-dd") + " 08:10:00";
            }
            return timeSlot;
        }

        private void frmInterface_Load(object sender, EventArgs e)
        {
            try
            {
                strKey = this.Text;
                if (strKey.Contains("科室"))///科室人员
                {
                    panel1.Visible = true;
                }
                else if (strKey.Contains("管理员"))
                {
                    panel1.Visible = true;
                }
            }
            catch { }

            getSeverDateTime();
            string strWhere = setTimeSlot();
            getQuery(strWhere);
        }

        /// <summary>
        /// 设置数据源
        /// </summary>
        /// <param name="dt"></param>
        private void setGridView(DataTable dt)
        {
            //dataSet1.Clear();
            dataSet1.Tables[0].Clear();
            listArray.Clear();
            if (dt != null || dt.Rows.Count > 0)
            {

                for (int i = 1; i <= dt.Rows.Count; i++)
                {

                    listArray.Add(dt.Rows[i - 1]["HEATNO"].ToString() + "false");
                    DataRow dr = dataSet1.Tables[0].NewRow();
                    dr["DateTime"] = dt.Rows[i - 1]["TAPPINGSTARTTIME"].ToString().Length == 0 ? DateTime.Now.ToString("yyyy-MM-dd") : dt.Rows[i - 1]["TAPPINGSTARTTIME"].ToString().Substring(0, 8);
                    dr["XH"] = i.ToString();
                    dr["HEATNO"] = dt.Rows[i - 1]["HEATNO"].ToString();
                    dr["PLANSTEEL"] = dt.Rows[i - 1]["PLANSTEEL"].ToString();
                    dr["TAPPINGWGT"] = dt.Rows[i - 1]["TAPPINGWGT"].ToString();
                    dr["BILLET_PRODUCTION"] = dt.Rows[i - 1]["BILLET_PRODUCTION"].ToString();
                    dr["HEAVY_SCRAP"] = dt.Rows[i - 1]["HEAVY_SCRAP"].ToString();
                    dr["LIGHT_SCRAP"] = dt.Rows[i - 1]["LIGHT_SCRAP"].ToString();
                    dr["STEEL_SLAG"] = dt.Rows[i - 1]["STEEL_SLAG"].ToString();
                    dr["PIG_IRON"] = dt.Rows[i - 1]["PIG_IRON"].ToString();
                    dr["MOLTEN_IRON"] = dt.Rows[i - 1]["MOLTEN_IRON"].ToString();
                    dr["OXYGEN_SUPPLY"] = dt.Rows[i - 1]["OXYGEN_SUPPLY"].ToString();
                    dr["NITROGEN_SUPPLY"] = dt.Rows[i - 1]["NITROGEN_SUPPLY"].ToString();
                    dr["Lime"] = dt.Rows[i - 1]["Lime"].ToString();
                    dr["Modifying_agent"] = dt.Rows[i - 1]["Modifying_agent"].ToString();
                    dr["LIGHT_BURNED_DOLOMITE"] = dt.Rows[i - 1]["LIGHT_BURNED_DOLOMITE"].ToString();
                    dr["RAW_WHITE"] = dt.Rows[i - 1]["RAW_WHITE"].ToString();
                    dr["Quality_lime"] = dt.Rows[i - 1]["Quality_lime"].ToString();
                    dr["High_phosphorus_ore"] = dt.Rows[i - 1]["High_phosphorus_ore"].ToString();
                    dr["Fluorite"] = dt.Rows[i - 1]["Fluorite"].ToString();
                    dr["Pellet"] = dt.Rows[i - 1]["Pellet"].ToString();
                    dr["Modifier_ladle"] = dt.Rows[i - 1]["Modifier_ladle"].ToString();
                    dr["Ferrosilicon"] = dt.Rows[i - 1]["Ferrosilicon"].ToString();
                    dr["Carbon_silicon_ball"] = dt.Rows[i - 1]["Carbon_silicon_ball"].ToString();
                    dr["SILICON_MANGANESE"] = dt.Rows[i - 1]["SILICON_MANGANESE"].ToString();
                    dr["Manganese"] = dt.Rows[i - 1]["Manganese"].ToString();
                    dr["Steel_cored_aluminium"] = dt.Rows[i - 1]["Steel_cored_aluminium"].ToString();
                    dr["Silicon_aluminum_barium"] = dt.Rows[i - 1]["Silicon_aluminum_barium"].ToString();
                    dr["Carburizing_agent"] = dt.Rows[i - 1]["Carburizing_agent"].ToString();
                    dr["Manganese_metal"] = dt.Rows[i - 1]["Manganese_metal"].ToString();
                    dr["Copper_plate"] = dt.Rows[i - 1]["Copper_plate"].ToString();
                    dr["Nickel_plate"] = dt.Rows[i - 1]["Nickel_plate"].ToString();

                    dataSet1.Tables[0].Rows.Add(dr);
                }
            }
        }


        private void getQuery(string strWhere)
        {
            ArrayList arry = new ArrayList();
            ArrayList sqlList = new ArrayList();
            arry.Add("QueryCostList.QueryData");
            sqlList.Add(strWhere);

            CoreClientParam CCP_LgEts = new CoreClientParam();
            DataTable dt = new DataTable();
            CCP_LgEts.ServerName = "Core.LgMes.Server.Common.ComDBQuery";
            CCP_LgEts.MethodName = "doQuery";
            CCP_LgEts.ServerParams = new object[] { arry, sqlList };
            CCP_LgEts.SourceDataTable = dt;
            this.ExecuteQueryToDataTable(CCP_LgEts, CoreInvokeType.Internal);

            setGridView(dt);
            getTimeDistance();
            if (strKey.Contains("科室"))///科室人员
            {
                ultraGrid1.DisplayLayout.Bands[0].Columns[5].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
            }
            else if (strKey.Contains("管理员"))
            {
                ultraGrid1.DisplayLayout.Bands[0].Columns[4].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
            }
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    break;
                case "Export":
                    try
                    {
                        Core.Mes.Client.Common.Globals.ulGridToExcel(ultraGrid1, Text);
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message);
                    }
                    break;
                case "Close":
                    this.Close();
                    break;
            }
        }

        private void setUpdate()
        {
            bool timerFlag = false;
            if (timer1.Enabled)
            {
                timer1.Enabled = false;
                timerFlag = true;
            }
            for (int i = 0; i < ultraGrid1.Rows.Count; i++)
            {
                string strSql = "";
                string strErr = "";
                if (ultraGrid1.Rows[i].Cells["TAPPINGWGT"].Text != dataSet1.Tables[0].Rows[i]["TAPPINGWGT"].ToString())
                {
                    strSql = "UPDATE STL_COST_ACCOUNTING SET TAPPINGWGT = " + ultraGrid1.Rows[i].Cells["TAPPINGWGT"].Text + "  WHERE HEATNO = '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "'";
                    strErr = NoQueryExecutive(strSql, ob);
                    strSql = @"INSERT INTO STL_UPDATE_COST_ACC_COLS
        (HEATNO_COL, MODIFY_ROOT, MODIFY_VALUE, MODIFY_STATE)
      VALUES ( '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "_TAPPINGSTARTTIME','" + UserInfo.GetUserName() + "', " + ultraGrid1.Rows[i].Cells["TAPPINGWGT"].Text + ", 'UPDATE')";
                    strErr = NoQueryExecutive(strSql, ob);
                }
                if (ultraGrid1.Rows[i].Cells["BILLET_PRODUCTION"].Text != dataSet1.Tables[0].Rows[i]["BILLET_PRODUCTION"].ToString())
                {
                    strSql = "UPDATE STL_COST_ACCOUNTING SET BILLET_PRODUCTION = " + ultraGrid1.Rows[i].Cells["BILLET_PRODUCTION"].Text + "  WHERE HEATNO = '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "'";
                    strErr = NoQueryExecutive(strSql, ob);
                    strSql = @"INSERT INTO STL_UPDATE_COST_ACC_COLS
        (HEATNO_COL, MODIFY_ROOT, MODIFY_VALUE, MODIFY_STATE)
      VALUES ( '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "_BILLET_PRODUCTION','" + UserInfo.GetUserName() + "', " + ultraGrid1.Rows[i].Cells["BILLET_PRODUCTION"].Text + ", 'UPDATE')";
                    strErr = NoQueryExecutive(strSql, ob);
                }
                if (ultraGrid1.Rows[i].Cells["HEAVY_SCRAP"].Text != dataSet1.Tables[0].Rows[i]["HEAVY_SCRAP"].ToString())
                {
                    strSql = "UPDATE STL_COST_ACCOUNTING SET HEAVY_SCRAP = " + ultraGrid1.Rows[i].Cells["HEAVY_SCRAP"].Text + "  WHERE HEATNO = '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "'";
                    strErr = NoQueryExecutive(strSql, ob);
                    strSql = @"INSERT INTO STL_UPDATE_COST_ACC_COLS
        (HEATNO_COL, MODIFY_ROOT, MODIFY_VALUE, MODIFY_STATE)
      VALUES ( '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "_HEAVY_SCRAP','" + UserInfo.GetUserName() + "', " + ultraGrid1.Rows[i].Cells["HEAVY_SCRAP"].Text + ", 'UPDATE')";
                    strErr = NoQueryExecutive(strSql, ob);
                }
                if (ultraGrid1.Rows[i].Cells["LIGHT_SCRAP"].Text != dataSet1.Tables[0].Rows[i]["LIGHT_SCRAP"].ToString())
                {
                    strSql = "UPDATE STL_COST_ACCOUNTING SET LIGHT_SCRAP = " + ultraGrid1.Rows[i].Cells["LIGHT_SCRAP"].Text + "  WHERE HEATNO = '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "'";
                    strErr = NoQueryExecutive(strSql, ob);
                    strSql = @"INSERT INTO STL_UPDATE_COST_ACC_COLS
        (HEATNO_COL, MODIFY_ROOT, MODIFY_VALUE, MODIFY_STATE)
      VALUES ( '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "_LIGHT_SCRAP','" + UserInfo.GetUserName() + "', " + ultraGrid1.Rows[i].Cells["LIGHT_SCRAP"].Text + ", 'UPDATE')";
                    strErr = NoQueryExecutive(strSql, ob);
                }
                if (ultraGrid1.Rows[i].Cells["STEEL_SLAG"].Text != dataSet1.Tables[0].Rows[i]["STEEL_SLAG"].ToString())
                {
                    strSql = "UPDATE STL_COST_ACCOUNTING SET STEEL_SLAG = " + ultraGrid1.Rows[i].Cells["STEEL_SLAG"].Text + "  WHERE HEATNO = '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "'";
                    strErr = NoQueryExecutive(strSql, ob);
                    strSql = @"INSERT INTO STL_UPDATE_COST_ACC_COLS
        (HEATNO_COL, MODIFY_ROOT, MODIFY_VALUE, MODIFY_STATE)
      VALUES ( '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "_STEEL_SLAG','" + UserInfo.GetUserName() + "', " + ultraGrid1.Rows[i].Cells["STEEL_SLAG"].Text + ", 'UPDATE')";
                    strErr = NoQueryExecutive(strSql, ob);
                }
                if (ultraGrid1.Rows[i].Cells["PIG_IRON"].Text != dataSet1.Tables[0].Rows[i]["PIG_IRON"].ToString())
                {
                    strSql = "UPDATE STL_COST_ACCOUNTING SET PIG_IRON = " + ultraGrid1.Rows[i].Cells["PIG_IRON"].Text + "  WHERE HEATNO = '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "'";
                    strErr = NoQueryExecutive(strSql, ob);
                    strSql = @"INSERT INTO STL_UPDATE_COST_ACC_COLS
        (HEATNO_COL, MODIFY_ROOT, MODIFY_VALUE, MODIFY_STATE)
      VALUES ( '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "_PIG_IRON','" + UserInfo.GetUserName() + "', " + ultraGrid1.Rows[i].Cells["PIG_IRON"].Text + ", 'UPDATE')";
                    strErr = NoQueryExecutive(strSql, ob);
                }
                if (ultraGrid1.Rows[i].Cells["MOLTEN_IRON"].Text != dataSet1.Tables[0].Rows[i]["MOLTEN_IRON"].ToString())
                {
                    strSql = "UPDATE STL_COST_ACCOUNTING SET MOLTEN_IRON = " + ultraGrid1.Rows[i].Cells["MOLTEN_IRON"].Text + "  WHERE HEATNO = '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "'";
                    strErr = NoQueryExecutive(strSql, ob);
                    strSql = @"INSERT INTO STL_UPDATE_COST_ACC_COLS
        (HEATNO_COL, MODIFY_ROOT, MODIFY_VALUE, MODIFY_STATE)
      VALUES ( '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "_MOLTEN_IRON','" + UserInfo.GetUserName() + "', " + ultraGrid1.Rows[i].Cells["MOLTEN_IRON"].Text + ", 'UPDATE')";
                    strErr = NoQueryExecutive(strSql, ob);
                }
                if (ultraGrid1.Rows[i].Cells["OXYGEN_SUPPLY"].Text != dataSet1.Tables[0].Rows[i]["OXYGEN_SUPPLY"].ToString())
                {
                    strSql = "UPDATE STL_COST_ACCOUNTING SET OXYGEN_SUPPLY = " + ultraGrid1.Rows[i].Cells["OXYGEN_SUPPLY"].Text + "  WHERE HEATNO = '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "'";
                    strErr = NoQueryExecutive(strSql, ob);
                    strSql = @"INSERT INTO STL_UPDATE_COST_ACC_COLS
        (HEATNO_COL, MODIFY_ROOT, MODIFY_VALUE, MODIFY_STATE)
      VALUES ( '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "_OXYGEN_SUPPLY','" + UserInfo.GetUserName() + "', " + ultraGrid1.Rows[i].Cells["OXYGEN_SUPPLY"].Text + ", 'UPDATE')";
                    strErr = NoQueryExecutive(strSql, ob);
                }
                if (ultraGrid1.Rows[i].Cells["NITROGEN_SUPPLY"].Text != dataSet1.Tables[0].Rows[i]["NITROGEN_SUPPLY"].ToString())
                {
                    strSql = "UPDATE STL_COST_ACCOUNTING SET NITROGEN_SUPPLY = " + ultraGrid1.Rows[i].Cells["NITROGEN_SUPPLY"].Text + "  WHERE HEATNO = '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "'";
                    strErr = NoQueryExecutive(strSql, ob);
                    strSql = @"INSERT INTO STL_UPDATE_COST_ACC_COLS
        (HEATNO_COL, MODIFY_ROOT, MODIFY_VALUE, MODIFY_STATE)
      VALUES ( '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "_NITROGEN_SUPPLY','" + UserInfo.GetUserName() + "', " + ultraGrid1.Rows[i].Cells["NITROGEN_SUPPLY"].Text + ", 'UPDATE')";
                    strErr = NoQueryExecutive(strSql, ob);
                }
                if (ultraGrid1.Rows[i].Cells["Lime"].Text != dataSet1.Tables[0].Rows[i]["Lime"].ToString())
                {
                    strSql = "UPDATE STL_COST_ACCOUNTING SET Lime = " + ultraGrid1.Rows[i].Cells["Lime"].Text + "  WHERE HEATNO = '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "'";
                    strErr = NoQueryExecutive(strSql, ob);
                    strSql = @"INSERT INTO STL_UPDATE_COST_ACC_COLS
        (HEATNO_COL, MODIFY_ROOT, MODIFY_VALUE, MODIFY_STATE)
      VALUES ( '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "_Lime','" + UserInfo.GetUserName() + "', " + ultraGrid1.Rows[i].Cells["Lime"].Text + ", 'UPDATE')";
                    strErr = NoQueryExecutive(strSql, ob);
                }
                if (ultraGrid1.Rows[i].Cells["Modifying_agent"].Text != dataSet1.Tables[0].Rows[i]["Modifying_agent"].ToString())
                {
                    strSql = "UPDATE STL_COST_ACCOUNTING SET Modifying_agent = " + ultraGrid1.Rows[i].Cells["Modifying_agent"].Text + "  WHERE HEATNO = '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "'";
                    strErr = NoQueryExecutive(strSql, ob);
                    strSql = @"INSERT INTO STL_UPDATE_COST_ACC_COLS
        (HEATNO_COL, MODIFY_ROOT, MODIFY_VALUE, MODIFY_STATE)
      VALUES ( '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "_Modifying_agent','" + UserInfo.GetUserName() + "', " + ultraGrid1.Rows[i].Cells["Modifying_agent"].Text + ", 'UPDATE')";
                    strErr = NoQueryExecutive(strSql, ob);
                }
                if (ultraGrid1.Rows[i].Cells["LIGHT_BURNED_DOLOMITE"].Text != dataSet1.Tables[0].Rows[i]["LIGHT_BURNED_DOLOMITE"].ToString())
                {
                    strSql = "UPDATE STL_COST_ACCOUNTING SET LIGHT_BURNED_DOLOMITE = " + ultraGrid1.Rows[i].Cells["LIGHT_BURNED_DOLOMITE"].Text + "  WHERE HEATNO = '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "'";
                    strErr = NoQueryExecutive(strSql, ob);
                    strSql = @"INSERT INTO STL_UPDATE_COST_ACC_COLS
        (HEATNO_COL, MODIFY_ROOT, MODIFY_VALUE, MODIFY_STATE)
      VALUES ( '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "_LIGHT_BURNED_DOLOMITE','" + UserInfo.GetUserName() + "', " + ultraGrid1.Rows[i].Cells["LIGHT_BURNED_DOLOMITE"].Text + ", 'UPDATE')";
                    strErr = NoQueryExecutive(strSql, ob);
                }
                if (ultraGrid1.Rows[i].Cells["RAW_WHITE"].Text != dataSet1.Tables[0].Rows[i]["RAW_WHITE"].ToString())
                {
                    strSql = "UPDATE STL_COST_ACCOUNTING SET RAW_WHITE = " + ultraGrid1.Rows[i].Cells["RAW_WHITE"].Text + "  WHERE HEATNO = '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "'";
                    strErr = NoQueryExecutive(strSql, ob);
                    strSql = @"INSERT INTO STL_UPDATE_COST_ACC_COLS
        (HEATNO_COL, MODIFY_ROOT, MODIFY_VALUE, MODIFY_STATE)
      VALUES ( '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "_RAW_WHITE','" + UserInfo.GetUserName() + "', " + ultraGrid1.Rows[i].Cells["RAW_WHITE"].Text + ", 'UPDATE')";
                    strErr = NoQueryExecutive(strSql, ob);
                }
                if (ultraGrid1.Rows[i].Cells["Quality_lime"].Text != dataSet1.Tables[0].Rows[i]["Quality_lime"].ToString())
                {
                    strSql = "UPDATE STL_COST_ACCOUNTING SET Quality_lime = " + ultraGrid1.Rows[i].Cells["Quality_lime"].Text + "  WHERE HEATNO = '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "'";
                    strErr = NoQueryExecutive(strSql, ob);
                    strSql = @"INSERT INTO STL_UPDATE_COST_ACC_COLS
        (HEATNO_COL, MODIFY_ROOT, MODIFY_VALUE, MODIFY_STATE)
      VALUES ( '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "_Quality_lime','" + UserInfo.GetUserName() + "', " + ultraGrid1.Rows[i].Cells["Quality_lime"].Text + ", 'UPDATE')";
                    strErr = NoQueryExecutive(strSql, ob);
                }
                if (ultraGrid1.Rows[i].Cells["High_phosphorus_ore"].Text != dataSet1.Tables[0].Rows[i]["High_phosphorus_ore"].ToString())
                {
                    strSql = "UPDATE STL_COST_ACCOUNTING SET High_phosphorus_ore = " + ultraGrid1.Rows[i].Cells["High_phosphorus_ore"].Text + "  WHERE HEATNO = '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "'";
                    strErr = NoQueryExecutive(strSql, ob);
                    strSql = @"INSERT INTO STL_UPDATE_COST_ACC_COLS
        (HEATNO_COL, MODIFY_ROOT, MODIFY_VALUE, MODIFY_STATE)
      VALUES ( '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "_High_phosphorus_ore','" + UserInfo.GetUserName() + "', " + ultraGrid1.Rows[i].Cells["High_phosphorus_ore"].Text + ", 'UPDATE')";
                    strErr = NoQueryExecutive(strSql, ob);
                }
                if (ultraGrid1.Rows[i].Cells["Fluorite"].Text != dataSet1.Tables[0].Rows[i]["Fluorite"].ToString())
                {
                    strSql = "UPDATE STL_COST_ACCOUNTING SET Fluorite = " + ultraGrid1.Rows[i].Cells["Fluorite"].Text + "  WHERE HEATNO = '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "'";
                    strErr = NoQueryExecutive(strSql, ob);
                    strSql = @"INSERT INTO STL_UPDATE_COST_ACC_COLS
        (HEATNO_COL, MODIFY_ROOT, MODIFY_VALUE, MODIFY_STATE)
      VALUES ( '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "_Fluorite','" + UserInfo.GetUserName() + "', " + ultraGrid1.Rows[i].Cells["Fluorite"].Text + ", 'UPDATE')";
                    strErr = NoQueryExecutive(strSql, ob);
                }
                if (ultraGrid1.Rows[i].Cells["Pellet"].Text != dataSet1.Tables[0].Rows[i]["Pellet"].ToString())
                {
                    strSql = "UPDATE STL_COST_ACCOUNTING SET Pellet = " + ultraGrid1.Rows[i].Cells["Pellet"].Text + "  WHERE HEATNO = '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "'";
                    strErr = NoQueryExecutive(strSql, ob);
                    strSql = @"INSERT INTO STL_UPDATE_COST_ACC_COLS
        (HEATNO_COL, MODIFY_ROOT, MODIFY_VALUE, MODIFY_STATE)
      VALUES ( '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "_Pellet','" + UserInfo.GetUserName() + "', " + ultraGrid1.Rows[i].Cells["Pellet"].Text + ", 'UPDATE')";
                    strErr = NoQueryExecutive(strSql, ob);
                }
                if (ultraGrid1.Rows[i].Cells["Modifier_ladle"].Text != dataSet1.Tables[0].Rows[i]["Modifier_ladle"].ToString())
                {
                    strSql = "UPDATE STL_COST_ACCOUNTING SET Modifier_ladle = " + ultraGrid1.Rows[i].Cells["Modifier_ladle"].Text + "  WHERE HEATNO = '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "'";
                    strErr = NoQueryExecutive(strSql, ob);
                    strSql = @"INSERT INTO STL_UPDATE_COST_ACC_COLS
        (HEATNO_COL, MODIFY_ROOT, MODIFY_VALUE, MODIFY_STATE)
      VALUES ( '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "_Modifier_ladle','" + UserInfo.GetUserName() + "', " + ultraGrid1.Rows[i].Cells["Modifier_ladle"].Text + ", 'UPDATE')";
                    strErr = NoQueryExecutive(strSql, ob);
                }
                if (ultraGrid1.Rows[i].Cells["Ferrosilicon"].Text != dataSet1.Tables[0].Rows[i]["Ferrosilicon"].ToString())
                {
                    strSql = "UPDATE STL_COST_ACCOUNTING SET Ferrosilicon = " + ultraGrid1.Rows[i].Cells["Ferrosilicon"].Text + "  WHERE HEATNO = '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "'";
                    strErr = NoQueryExecutive(strSql, ob);
                    strSql = @"INSERT INTO STL_UPDATE_COST_ACC_COLS
        (HEATNO_COL, MODIFY_ROOT, MODIFY_VALUE, MODIFY_STATE)
      VALUES ( '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "_Ferrosilicon','" + UserInfo.GetUserName() + "', " + ultraGrid1.Rows[i].Cells["Ferrosilicon"].Text + ", 'UPDATE')";
                    strErr = NoQueryExecutive(strSql, ob);
                }
                if (ultraGrid1.Rows[i].Cells["Carbon_silicon_ball"].Text != dataSet1.Tables[0].Rows[i]["Carbon_silicon_ball"].ToString())
                {
                    strSql = "UPDATE STL_COST_ACCOUNTING SET Carbon_silicon_ball = " + ultraGrid1.Rows[i].Cells["Carbon_silicon_ball"].Text + "  WHERE HEATNO = '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "'";
                    strErr = NoQueryExecutive(strSql, ob);
                    strSql = @"INSERT INTO STL_UPDATE_COST_ACC_COLS
        (HEATNO_COL, MODIFY_ROOT, MODIFY_VALUE, MODIFY_STATE)
      VALUES ( '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "_Carbon_silicon_ball','" + UserInfo.GetUserName() + "', " + ultraGrid1.Rows[i].Cells["Carbon_silicon_ball"].Text + ", 'UPDATE')";
                    strErr = NoQueryExecutive(strSql, ob);
                }
                if (ultraGrid1.Rows[i].Cells["SILICON_MANGANESE"].Text != dataSet1.Tables[0].Rows[i]["SILICON_MANGANESE"].ToString())
                {
                    strSql = "UPDATE STL_COST_ACCOUNTING SET SILICON_MANGANESE = " + ultraGrid1.Rows[i].Cells["SILICON_MANGANESE"].Text + "  WHERE HEATNO = '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "'";
                    strErr = NoQueryExecutive(strSql, ob);
                    strSql = @"INSERT INTO STL_UPDATE_COST_ACC_COLS
        (HEATNO_COL, MODIFY_ROOT, MODIFY_VALUE, MODIFY_STATE)
      VALUES ( '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "_SILICON_MANGANESE','" + UserInfo.GetUserName() + "', " + ultraGrid1.Rows[i].Cells["SILICON_MANGANESE"].Text + ", 'UPDATE')";
                    strErr = NoQueryExecutive(strSql, ob);
                }
                if (ultraGrid1.Rows[i].Cells["Manganese"].Text != dataSet1.Tables[0].Rows[i]["Manganese"].ToString())
                {
                    strSql = "UPDATE STL_COST_ACCOUNTING SET Manganese = " + ultraGrid1.Rows[i].Cells["Manganese"].Text + "  WHERE HEATNO = '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "'";
                    strErr = NoQueryExecutive(strSql, ob);
                    strSql = @"INSERT INTO STL_UPDATE_COST_ACC_COLS
        (HEATNO_COL, MODIFY_ROOT, MODIFY_VALUE, MODIFY_STATE)
      VALUES ( '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "_Manganese','" + UserInfo.GetUserName() + "', " + ultraGrid1.Rows[i].Cells["Manganese"].Text + ", 'UPDATE')";
                    strErr = NoQueryExecutive(strSql, ob);
                }
                if (ultraGrid1.Rows[i].Cells["Steel_cored_aluminium"].Text != dataSet1.Tables[0].Rows[i]["Steel_cored_aluminium"].ToString())
                {
                    strSql = "UPDATE STL_COST_ACCOUNTING SET Steel_cored_aluminium = " + ultraGrid1.Rows[i].Cells["Steel_cored_aluminium"].Text + "  WHERE HEATNO = '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "'";
                    strErr = NoQueryExecutive(strSql, ob);
                    strSql = @"INSERT INTO STL_UPDATE_COST_ACC_COLS
        (HEATNO_COL, MODIFY_ROOT, MODIFY_VALUE, MODIFY_STATE)
      VALUES ( '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "_Steel_cored_aluminium','" + UserInfo.GetUserName() + "', " + ultraGrid1.Rows[i].Cells["Steel_cored_aluminium"].Text + ", 'UPDATE')";
                    strErr = NoQueryExecutive(strSql, ob);
                }
                if (ultraGrid1.Rows[i].Cells["Silicon_aluminum_barium"].Text != dataSet1.Tables[0].Rows[i]["Silicon_aluminum_barium"].ToString())
                {
                    strSql = "UPDATE STL_COST_ACCOUNTING SET Silicon_aluminum_barium = " + ultraGrid1.Rows[i].Cells["Silicon_aluminum_barium"].Text + "  WHERE HEATNO = '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "'";
                    strErr = NoQueryExecutive(strSql, ob);
                    strSql = @"INSERT INTO STL_UPDATE_COST_ACC_COLS
        (HEATNO_COL, MODIFY_ROOT, MODIFY_VALUE, MODIFY_STATE)
      VALUES ( '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "_Silicon_aluminum_barium','" + UserInfo.GetUserName() + "', " + ultraGrid1.Rows[i].Cells["Silicon_aluminum_barium"].Text + ", 'UPDATE')";
                    strErr = NoQueryExecutive(strSql, ob);
                }
                if (ultraGrid1.Rows[i].Cells["Carburizing_agent"].Text != dataSet1.Tables[0].Rows[i]["Carburizing_agent"].ToString())
                {
                    strSql = "UPDATE STL_COST_ACCOUNTING SET Carburizing_agent = " + ultraGrid1.Rows[i].Cells["Carburizing_agent"].Text + "  WHERE HEATNO = '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "'";
                    strErr = NoQueryExecutive(strSql, ob);
                    strSql = @"INSERT INTO STL_UPDATE_COST_ACC_COLS
        (HEATNO_COL, MODIFY_ROOT, MODIFY_VALUE, MODIFY_STATE)
      VALUES ( '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "_Carburizing_agent','" + UserInfo.GetUserName() + "', " + ultraGrid1.Rows[i].Cells["Carburizing_agent"].Text + ", 'UPDATE')";
                    strErr = NoQueryExecutive(strSql, ob);
                }
                if (ultraGrid1.Rows[i].Cells["Manganese_metal"].Text != dataSet1.Tables[0].Rows[i]["Manganese_metal"].ToString())
                {
                    strSql = "UPDATE STL_COST_ACCOUNTING SET Manganese_metal = " + ultraGrid1.Rows[i].Cells["Manganese_metal"].Text + "  WHERE HEATNO = '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "'";
                    strErr = NoQueryExecutive(strSql, ob);
                    strSql = @"INSERT INTO STL_UPDATE_COST_ACC_COLS
        (HEATNO_COL, MODIFY_ROOT, MODIFY_VALUE, MODIFY_STATE)
      VALUES ( '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "_Manganese_metal','" + UserInfo.GetUserName() + "', " + ultraGrid1.Rows[i].Cells["Manganese_metal"].Text + ", 'UPDATE')";
                    strErr = NoQueryExecutive(strSql, ob);
                }
                if (ultraGrid1.Rows[i].Cells["Copper_plate"].Text != dataSet1.Tables[0].Rows[i]["Copper_plate"].ToString())
                {
                    strSql = "UPDATE STL_COST_ACCOUNTING SET Copper_plate = " + ultraGrid1.Rows[i].Cells["Copper_plate"].Text + "  WHERE HEATNO = '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "'";
                    strErr = NoQueryExecutive(strSql, ob);
                    strSql = @"INSERT INTO STL_UPDATE_COST_ACC_COLS
        (HEATNO_COL, MODIFY_ROOT, MODIFY_VALUE, MODIFY_STATE)
      VALUES ( '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "_Copper_plate','" + UserInfo.GetUserName() + "', " + ultraGrid1.Rows[i].Cells["Copper_plate"].Text + ", 'UPDATE')";
                    strErr = NoQueryExecutive(strSql, ob);
                }
                if (ultraGrid1.Rows[i].Cells["Nickel_plate"].Text != dataSet1.Tables[0].Rows[i]["Nickel_plate"].ToString())
                {
                    strSql = "UPDATE STL_COST_ACCOUNTING SET Nickel_plate = " + ultraGrid1.Rows[i].Cells["Nickel_plate"].Text + "  WHERE HEATNO = '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "'";
                    strErr = NoQueryExecutive(strSql, ob);
                    strSql = @"INSERT INTO STL_UPDATE_COST_ACC_COLS
        (HEATNO_COL, MODIFY_ROOT, MODIFY_VALUE, MODIFY_STATE)
      VALUES ( '" + ultraGrid1.Rows[i].Cells["HEATNO"].Text + "_Nickel_plate','" + UserInfo.GetUserName() + "', " + ultraGrid1.Rows[i].Cells["Nickel_plate"].Text + ", 'UPDATE')";
                    strErr = NoQueryExecutive(strSql, ob);
                }
            }
            if (timerFlag)
                timer1.Enabled = true;
        }

        public string NoQueryExecutive(string ServerParams, OpeBase opb)
        {
            //string strerr = "";
            CoreClientParam ccp_K = new CoreClientParam();
            ccp_K.ServerName = "Core.LgMes.Server.DEV.Methods.DEVPublicMethods";
            ccp_K.MethodName = "UpdateMethods";
            ccp_K.ServerParams = new object[] { ServerParams };
            opb.ExecuteNonQuery(ccp_K, CoreInvokeType.Internal);
            //strerr = ccp_K.ReturnInfo.ToString();
            return ccp_K.ReturnInfo.ToString();
        }

        private void checkBox1_CheckedChanged(object sender, EventArgs e)
        {
            if (checkBox1.Checked)
            {
                timer1.Enabled = true;
                button1.Enabled = false;
            }
            else
            {
                timer1.Enabled = false;
                button1.Enabled = true; ;
            }
        }

        /// <summary>
        /// 获取冶炼结束时间
        /// </summary>
        private void getTimeDistance()
        {
            string strErr = "";

            ArrayList arry = new ArrayList();
            arry.Add("QueryCostList.QueryPsendtime");

            arry.Add(startTime); arry.Add(endTime);
            arry.Add(startTime); arry.Add(endTime);

            CommonClientToServer ccs = new CommonClientToServer();
            ccs.ob = this.ob;
            DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr);

            setUltraGridRowCell(ds.Tables[0]);
        }

        /// <summary>
        /// 设置ultraGrid1内单元格不可编辑
        /// </summary>
        /// <param name="dt"></param>
        private void setUltraGridRowCell(DataTable dt)
        {
            if (dt.Rows.Count == ultraGrid1.Rows.Count)
                for (int i = 0; i < ultraGrid1.Rows.Count; i++)
                {
                    //供氧量、改质剂
                    if (dt.Rows[i]["TIMEDIS"].ToString() != "")
                    {
                        //ultraGrid1.Rows[i].Cells["OXYGEN_SUPPLY"] = false;
                        ultraGrid1.Rows[i].Cells["Modifying_agent"].Activated = false;
                    }
                    //
                    if (Convert.ToInt32(dt.Rows[i]["TIMEDIS"]) > 30 || Convert.ToInt32(dt.Rows[i]["TIMEDIS"]) == 0)
                    {
                        ultraGrid1.Rows[i].Cells["Manganese_metal"].Activated = false;
                        ultraGrid1.Rows[i].Cells["Carburizing_agent"].Activated = false;
                        ultraGrid1.Rows[i].Cells["Copper_plate"].Activated = false;
                        ultraGrid1.Rows[i].Cells["Nickel_plate"].Activated = false;
                    }
                }
        }


        private void button1_Click(object sender, EventArgs e)
        {
            getQuery(setTimeSlotAll());//查询出来
        }


        private string setTimeSlotAll()
        {
            string timeSlot = "";
            if (comboBox1.Text == "早")
                timeSlot = " WHERE TO_CHAR(TAPPINGSTARTTIME, 'yyyy-MM-dd HH24:MI:SS') BETWEEN '"
                        + start_Date.DateTime.ToString("yyyy-MM-dd") + " 08:10:01' AND '" + start_Date.DateTime.ToString("yyyy-MM-dd") + " 15:40:00'"
                        + "OR TAPPINGSTARTTIME IS NULL";
            else if (comboBox1.Text == "早")
                timeSlot = " WHERE TO_CHAR(TAPPINGSTARTTIME, 'yyyy-MM-dd HH24:MI:SS') BETWEEN '"
                            + start_Date.DateTime.ToString("yyyy-MM-dd") + " 15:40:01' AND '" + start_Date.DateTime.ToString("yyyy-MM-dd") + " 23:40:00'"
                            + "OR TAPPINGSTARTTIME IS NULL";
            else
                timeSlot = " WHERE TO_CHAR(TAPPINGSTARTTIME, 'yyyy-MM-dd HH24:MI:SS') BETWEEN '"
                        + start_Date.DateTime.ToString("yyyy-MM-dd") + " 23:40:01' AND '" + start_Date.DateTime.AddDays(1).ToString("yyyy-MM-dd") + " 08:10:00'"
                        + "OR TAPPINGSTARTTIME IS NULL";
            return timeSlot;
        }

        private void ultraGrid1_InitializeRow(object sender, InitializeRowEventArgs e)
        {

        }

    }
}