XinYu_LG2MES/ClientSolution/Core.LgMes.Client.lgIntegrationQuery/FrmCombineCutSlabOpt.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 Core.Mes.Client.Common;
using System.Collections;
using Infragistics.Win.UltraWinGrid.ExcelExport;
using System.Diagnostics;
using System.IO;
using CoreFS.CA06;
using Infragistics.Win.UltraWinGrid;
using Core.LgMes.Client.Comm;
using System.Net;

namespace Core.LgMes.Client.lgIntegrationQuery
{
    public partial class FrmCombineCutSlabOpt : frmStyleBase
    {
        public FrmCombineCutSlabOpt()
        {
            InitializeComponent();
        }

        private static UltraGridExcelExporter ultraGridExcelExporter1 = new UltraGridExcelExporter();

        private void FrmCombineCutSlabOpt_Load(object sender, EventArgs e)
        {
            cbbPos.SelectedIndex = 0;
            cbType.Enabled = false;
            foreach(UltraGridRow ugr in this.ultraGrid1.Rows)
            {
                ugr.Cells["Choose"].Value = false;
            }
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    {
                        proc_Query();
                        break;
                    }

                case "WeightMatch":
                    {
                        proc_divide();
                        break;
                    }
                case "Export":
                    {
                        try
                        {
                            
                            if (ultraGrid2.Rows.Count == 0) return;

                            string strFileName = "合切坯拆分历史";

                            SaveFileDialog dlg = new SaveFileDialog();
                            dlg.Title = "保存";
                            dlg.OverwritePrompt = true;
                            dlg.Filter = "Excel文件(*.xls)|*.xls";
                            dlg.AddExtension = true;
                            dlg.FileName = strFileName;
                            if (dlg.ShowDialog() == DialogResult.OK)
                            {
                                strFileName = dlg.FileName;
                                ultraGridExcelExporter1.Export(ultraGrid2, strFileName);

                                if (MessageBox.Show("数据导出成功！\r\n需要打开所导出文件吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                                {
                                    ultraGridExcelExporter1.Export(ultraGrid2, strFileName);

                                    ProcessStartInfo p = new ProcessStartInfo(strFileName);
                                    p.WorkingDirectory = Path.GetDirectoryName(strFileName);
                                    Process.Start(p);
                                }
                            }
                        }
                        catch (Exception ex)
                        {
                            MessageBox.Show(ex.Message);
                        }
                        break;
                    }

                case "Close":
                    {
                        this.Close();
                        break;
                    }
            }
        }

        public void proc_Query() 
        {
            try
            {
                string strErr = "", sqlcondition = "";
                if (ultraTabControl2.ActiveTab.Index == 0)
                {
                    sqlcondition = " WHERE 1=1 ";
                    if (!string.IsNullOrEmpty(textBox1.Text.Trim()) && string.IsNullOrEmpty(textBox2.Text.Trim())) 
                    {
                        sqlcondition += " AND SLAB_NO LIKE '" + textBox1.Text.Trim() + "%' ";
                    }
                    if(!string.IsNullOrEmpty(textBox2.Text.Trim()) && !string.IsNullOrEmpty(textBox2.Text.Trim()))
                    {
                        sqlcondition += " AND SUBSTR(T.SLAB_NO,1,10) BETWEEN '" + textBox1.Text.Trim() + "' AND '" + textBox2.Text.Trim() + "' ";
                    }
                    if (string.IsNullOrEmpty(textBox1.Text.Trim()) && string.IsNullOrEmpty(textBox2.Text.Trim())) 
                    {
                        MessageBox.Show("请输入初始炉号");
                        return;
                    }
                    if (cbType.Checked) 
                    {
                        sqlcondition += " AND SLAB_DCS_DETAIL LIKE '%" + cbbPos.SelectedItem.ToString() + "%' ";
                    }
                    //定义一个ArrayList集合存储变量[参数]值 
                    ArrayList arry1 = new ArrayList();
                    ArrayList sqlList = new ArrayList();

                    arry1.Add("CombineCutSlab.select");//此ID为XML文件ID
                    sqlList.Add(sqlcondition);

                    //调用服务端方法
                    CoreClientParam CCP_JJBQuery = new CoreClientParam();
                    DataTable dt = new DataTable();
                    CCP_JJBQuery.ServerName = "Core.LgMes.Server.Common.ComDBQuery";
                    CCP_JJBQuery.MethodName = "doQuery";
                    CCP_JJBQuery.ServerParams = new object[] { arry1, sqlList };
                    CCP_JJBQuery.SourceDataTable = dt;
                    this.ExecuteQueryToDataTable(CCP_JJBQuery, CoreInvokeType.Internal);

                    if (string.IsNullOrEmpty(strErr)) {
                        if (dt != null && dt.Rows.Count > 0)
                        {
                            this.dataTable1.Rows.Clear();
                            DataRow dr;
                            for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
                            {
                                dr = this.dataTable1.NewRow();
                                for (int jCol = 0; jCol < dt.Columns.Count; jCol++)
                                {
                                    if (this.dataTable1.Columns.Contains(dt.Columns[jCol].ColumnName))
                                    {
                                        dr[dt.Columns[jCol].ColumnName] = dt.Rows[iRow][jCol];
                                    }

                                }
                                this.dataTable1.Rows.Add(dr);
                            }
                        }
                    }
                    foreach (UltraGridRow ugr in this.ultraGrid1.Rows) 
                    {
                        if (ugr.Cells["SLAB_STAT"].Text.Trim() == "已出库") 
                        {
                            ugr.Cells["SLAB_STAT"].Appearance.BackColor = Color.Red;
                        }
                    }
                    this.ultraGrid1.DisplayLayout.Bands[0].Columns["Choose"].CellActivation = Activation.AllowEdit;
                    this.ultraGrid1.DisplayLayout.Bands[0].Columns["BILLETNO"].CellActivation = Activation.ActivateOnly;
                    this.ultraGrid1.DisplayLayout.Bands[0].Columns["SLAB_STAT"].CellActivation = Activation.ActivateOnly;
                    this.ultraGrid1.DisplayLayout.Bands[0].Columns["LENGTH"].CellActivation = Activation.ActivateOnly;
                    this.ultraGrid1.DisplayLayout.Bands[0].Columns["WEIGHT"].CellActivation = Activation.ActivateOnly;
                    this.ultraGrid1.DisplayLayout.Bands[0].Columns["THEORYWEIGHT"].CellActivation = Activation.ActivateOnly;
                }
                else
                {
                    if (dtpBegin.DateTime.Date > dtpEnd.DateTime.Date)
                    {
                        MessageBox.Show("查询开始日期不能大于结束日期！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        return;
                    }
                    string strFrom = dtpBegin.DateTime.ToString("yyyy-MM-dd");
                    string strTo = dtpEnd.DateTime.ToString("yyyy-MM-dd");

                    sqlcondition = " WHERE SUBSTR(OPT_TIME,1,10) BETWEEN '" + strFrom + "' AND '" + strTo + "'";

                    if (checkBox1.Checked)
                        sqlcondition += " AND OPT_TYPE = '" + cvPos1.SelectedItem.ToString() + "'";

                    ArrayList arry1 = new ArrayList();
                    ArrayList sqlList = new ArrayList();

                    arry1.Add("LogCombineCutSlabLog.select");//此ID为XML文件ID
                    sqlList.Add(sqlcondition);

                    //调用服务端方法
                    CoreClientParam CCP_JJBQuery = new CoreClientParam();
                    DataTable dt1 = new DataTable();
                    CCP_JJBQuery.ServerName = "Core.LgMes.Server.Common.ComDBQuery";
                    CCP_JJBQuery.MethodName = "doQuery";
                    CCP_JJBQuery.ServerParams = new object[] { arry1, sqlList };
                    CCP_JJBQuery.SourceDataTable = dt1;
                    this.ExecuteQueryToDataTable(CCP_JJBQuery, CoreInvokeType.Internal);

                    if (string.IsNullOrEmpty(strErr))
                    {
                        if (dt1 != null && dt1.Rows.Count > 0)
                        {
                            this.dataTable2.Rows.Clear();
                            DataRow dr;
                            for (int iRow = 0; iRow < dt1.Rows.Count; iRow++)
                            {
                                dr = this.dataTable2.NewRow();
                                for (int jCol = 0; jCol < dt1.Columns.Count; jCol++)
                                {
                                    if (this.dataTable2.Columns.Contains(dt1.Columns[jCol].ColumnName))
                                    {
                                        dr[dt1.Columns[jCol].ColumnName] = dt1.Rows[iRow][jCol];
                                    }

                                }
                                this.dataTable2.Rows.Add(dr);
                            }
                        }
                    }
                    JJBStaticFunction.SetRowEdit(ultraGrid2);
                }
                foreach (UltraGridRow ugr in this.ultraGrid1.Rows) 
                {
                    if (ugr.Cells["ISVALID"].Text.Trim() == "是") 
                    {
                        ugr.Cells["ISVALID"].Appearance.ForeColor = Color.Red;
                    }
                }
            }
            catch { }
        }

        public void proc_divide() 
        {
            int flag = 0;
            int icount = 0;
            double lengthAll = 0;
            double weightAll = 0.0;
            string billetAll = "重量拆分,";
            double length = 0;
            string strErr = "";

            if (ultraTabControl2.ActiveTab.Index == 1)
            {
                MessageBox.Show("请选择拆分管理界面进行拆分操作");
                return;
            }

            if (this.ultraGrid1.Rows.Count == 0) 
            {
                MessageBox.Show("请先查询数据再进行重量拆分操作");
                return;
            }
            try
            {
                //获取统计数据
                foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                {
                    if (ugr.Cells["Choose"].Text.Trim().ToUpper() == "TRUE")
                    {
                        if (string.IsNullOrEmpty(ugr.Cells["LENGTH"].Text.Trim())) 
                        {
                            MessageBox.Show("选择的合切坯中有无长度的板坯，请核实");
                            return;
                        }
                        if (ugr.Cells["SLAB_STAT"].Text.Trim() == "已出库")
                        {
                            MessageBox.Show("选择的合切坯已出库，不可进行拆分操作");
                            return;
                        }
                        if (Int32.Parse(ugr.Cells["LENGTH"].Text.Trim()) == 0 || Int32.Parse(ugr.Cells["LENGTH"].Text.Trim()) < 1000 )
                        {
                            MessageBox.Show("选择的合切坯中有长度不正确的板坯，请核实");
                            return;
                        }
                        if (ugr.Cells["ISVALID"].Text.Trim() == "是" )
                        {
                            MessageBox.Show("板坯已拆分，不可再进行重量拆分操作");
                            return;
                        }
                        lengthAll += Int32.Parse(ugr.Cells["LENGTH"].Text.Trim());

                        if (!string.IsNullOrEmpty(ugr.Cells["WEIGHT"].Text.Trim()))
                        {
                            weightAll += double.Parse(ugr.Cells["WEIGHT"].Text.Trim());
                            flag++;
                        }
                        if (flag > 1)
                        {
                            MessageBox.Show("选择的合切坯中有多个过磅重量，请核实");
                            return;
                        }
                        billetAll += ugr.Cells["BILLETNO"].Text.Trim() + ",";
                    }
                }

                foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                {
                    if (ugr.Cells["Choose"].Text.Trim().ToUpper() == "TRUE")
                    {
                        if (flag == 0)
                        {

                            if (MessageBox.Show("选择的合切坯未过磅,是否按各板坯理重拆分?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                            {

                                if (string.IsNullOrEmpty(ugr.Cells["THEORYWEIGHT"].Text.Trim()))
                                {
                                    MessageBox.Show("选择的合切坯无理论重量，请核实");
                                    return;
                                }

                                //查询是否已经拆分过
                                string sql = "select t.* from WEIGHT_DIVIDE_LOG t WHERE BILLETNO = '" + ugr.Cells["BILLETNO"].Text.Trim() + "' and isvalid = '1'";
                                //调用服务端方法
                                CoreClientParam CCP_JJBQuery = new CoreClientParam();
                                DataTable dtAll = new DataTable();
                                CCP_JJBQuery.ServerName = "Core.LgMes.Server.Common.ComDBExecute";
                                CCP_JJBQuery.MethodName = "doSimpleQuery";
                                CCP_JJBQuery.ServerParams = new object[] { sql };
                                CCP_JJBQuery.SourceDataTable = dtAll;
                                this.ExecuteQueryToDataTable(CCP_JJBQuery, CoreInvokeType.Internal);
                                if (strErr == "")
                                {
                                    if (dtAll.Rows.Count > 0) 
                                    {
                                        MessageBox.Show("该板坯已拆分过，不可再次拆分");
                                        proc_Query();
                                        return;
                                    }
                                }

                                ArrayList arry = new ArrayList();
                                arry.Add("CombineCutSlab.Update");//更新重量
                                arry.Add(ugr.Cells["THEORYWEIGHT"].Text.Trim());
                                arry.Add(ugr.Cells["BILLETNO"].Text.Trim());
                                //arry.Add(this.UserInfo.GetUserName());

                                CommonClientToServer cctos = new CommonClientToServer();
                                cctos.ob = this.ob;
                                DataSet ds1 = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBSave",
                                                "doSimpleSave", arry, out strErr);
                                if (strErr == "")
                                {
                                    object[] sArgs = new object[5];
                                    sArgs[0] = ugr.Cells["BILLETNO"].Text.Trim();
                                    sArgs[1] = "11AA";
                                    sArgs[2] = "N";
                                    sArgs[3] = "合切坯重量分配";
                                    sArgs[4] = this.UserInfo.GetUserName();
                                    string strSqlID = "UpLoadData.CAL";
                                    cctos = new CommonClientToServer();
                                    cctos.ob = ob;
                                    string strRCode = cctos.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure",
                                                                    "ExecProcWithOneReturn", strSqlID, sArgs, out strErr);
                                    if (strRCode == "1" && !string.IsNullOrEmpty(strErr)) 
                                    {
                                        MessageBox.Show("数据上传失败:" + strRCode + "," + strErr);
                                    }
                                    //写操作记录
                                    ArrayList arry1 = new ArrayList();
                                    arry1.Add("LogCombineCutSlab.insert");
                                    arry1.Add("0");
                                    arry1.Add(ugr.Cells["THEORYWEIGHT"].Text.Trim());
                                    arry1.Add(cbbPos.SelectedItem.ToString());
                                    arry1.Add(GetLocalMachineIP());
                                    arry1.Add(this.UserInfo.GetUserName());
                                    arry1.Add(billetAll);
                                    arry1.Add(ugr.Cells["BILLETNO"].Text.Trim());

                                    CommonClientToServer cctos2 = new CommonClientToServer();
                                    cctos2.ob = this.ob;
                                    DataSet ds2 = cctos2.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBSave",
                                                    "doSimpleSave", arry1, out strErr);
                                    if (strErr == "")
                                    {
                                        icount++;
                                    }
                                    else
                                    {
                                        MessageBox.Show("记录新增失败:" + strErr + "!");
                                        return;
                                    }

                                }
                                else
                                {
                                    MessageBox.Show("拆分失败:" + strErr + "!");
                                    return;
                                }
                            }
                        }
                        else
                        {
                            length = Int32.Parse(ugr.Cells["LENGTH"].Text.Trim());

                            ArrayList arryOver = new ArrayList();
                            arryOver.Add("CombineCutSlab.Update");
                            arryOver.Add(Math.Round((length / lengthAll) * weightAll, 3));
                            arryOver.Add(ugr.Cells["BILLETNO"].Text.Trim());

                            CommonClientToServer cctos = new CommonClientToServer();
                            cctos.ob = this.ob;
                            DataSet ds3 = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBSave",
                                            "doSimpleSave", arryOver, out strErr);

                            if (strErr == "")
                            {
                                object[] sArgs = new object[5];
                                sArgs[0] = ugr.Cells["BILLETNO"].Text.Trim();
                                sArgs[1] = "11AA";
                                sArgs[2] = "N";
                                sArgs[3] = "合切坯重量分配";
                                sArgs[4] = this.UserInfo.GetUserName();
                                string strSqlID = "UpLoadData.CAL";
                                cctos = new CommonClientToServer();
                                cctos.ob = ob;
                                string strRCode = cctos.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure",
                                                                "ExecProcWithOneReturn", strSqlID, sArgs, out strErr);
                                if (strRCode == "1" && !string.IsNullOrEmpty(strErr))
                                {
                                    MessageBox.Show("数据上传失败:" + strRCode + "," + strErr);
                                }
                                //写操作记录
                                ArrayList arry2 = new ArrayList();
                                arry2.Add("LogCombineCutSlab.insert");
                                arry2.Add(ugr.Cells["WEIGHT"].Text.Trim());
                                arry2.Add(length / lengthAll * weightAll);
                                arry2.Add(cbbPos.SelectedItem.ToString());
                                arry2.Add(GetLocalMachineIP());
                                arry2.Add(this.UserInfo.GetUserName());
                                arry2.Add(billetAll);
                                arry2.Add(ugr.Cells["BILLETNO"].Text.Trim());
                                CommonClientToServer cctos4 = new CommonClientToServer();
                                cctos4.ob = this.ob;
                                DataSet ds4 = cctos4.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBSave",
                                                "doSimpleSave", arry2, out strErr);
                                if (strErr == "")
                                {
                                    icount++;
                                }
                                else
                                {
                                    MessageBox.Show("记录新增失败:" + strErr + "!");
                                    return;
                                }
                            }
                            else
                            {
                                MessageBox.Show("记录新增失败:" + strErr + "!");
                                return;
                            }
                        }
                    }
                }
                if (icount > 1) 
                {
                    MessageBox.Show("拆分成功");
                    proc_Query();
                    return;
                }
            }
            catch { }
            
        }

        private void uCkEditorForFilter_CheckedChanged(object sender, EventArgs e)
        {
            JJBStaticFunction.SetGridRowFilter(ref this.ultraGrid1, uCkEditorForFilter.Checked);
        }

        private void ultraCheckEditor1_CheckedChanged(object sender, EventArgs e)
        {
            JJBStaticFunction.SetGridRowFilter(ref this.ultraGrid2, uCkEditorForFilter.Checked);
        }

        public string GetLocalMachineIP()
        {
            IPHostEntry myHost = new IPHostEntry();
            //myHost = Dns.GetHostByName(Dns.GetHostName());
            myHost = Dns.GetHostEntry(Dns.GetHostName());
            string str = "";
            str = myHost.AddressList[0].ToString();
            return str;
        }
    }
}