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

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

        private void FrmWeightCheck_Load(object sender, EventArgs e)
        {

        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    {
                        proc_Query();
                        break;
                    }
                case "CheckIn":
                    {
                        CheckIn("审核通过");
                        break;
                    }
                case "  ":
                    {
                        CheckIn("审核不通过");
                        break;
                    }
                case "CheckCancel":
                    {
                        CheckCancel();
                        break;
                    }
                case "Export":
                    {
                        ExportExcel();
                        break;
                    }
                case "Close":
                    {
                        this.Close();
                        break;
                    }
            }
        }


        public void proc_Query()
        {
            this.dataSet1.Tables[0].Clear();
            if (uldtEndTime.DateTime.Date.Subtract(uldtBeginTime.DateTime.Date).Days > 180)
            {
                MessageBox.Show("查询时间不可超过6个月。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            if (uldtBeginTime.DateTime > uldtEndTime.DateTime)
            {
                MessageBox.Show("查询起始时间不能大于结束时间！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            try
            {
                string strErr = "";
                this.dataSet1.Tables[0].Clear();
                string DelToDateFrom = Convert.ToString(this.uldtBeginTime.DateTime.ToString("yyyyMMdd"));
                string DelToDateTo = Convert.ToString(this.uldtEndTime.DateTime.ToString("yyyyMMdd"));
                DateTime t1 = DateTime.ParseExact(DelToDateFrom, "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture);
                DateTime t2 = DateTime.ParseExact(DelToDateTo, "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture);
                System.TimeSpan t3 = t2 - t1;  //两个时间相减 。默认得到的是 两个时间之间的天数   得到：365.00:00:00 

                double getDay = t3.TotalDays; //将这个天数转换成天数, 返回值是double类型的（其实不必转换，因为t3默认就是天数） 得到： 


                if (getDay > 30)
                {
                    MessageBox.Show("查询周期过长，是否继续查询？");
                }
                string sqlCondition = "1=1 AND (T1.MATRL_END_CAUSE_CD IS NULL OR T1.MATRL_END_CAUSE_CD != '4')";

                sqlCondition += " AND T1.SLAB_CUT_DTIME BETWEEN  '" + DelToDateFrom + "000000" + "' AND '" + DelToDateTo + "235959" + "'";

                if (this.chk_CCMID.Checked)
                {
                    sqlCondition += " AND T1.PROC_CD LIKE 'J" + this.cmb_CCMID.Text.Trim() + "%'";
                }
                sqlCondition += " ORDER BY T1.SLAB_CUT_DTIME ";
                ArrayList arry1 = new ArrayList();
                ArrayList sqlList = new ArrayList();

                arry1.Add("FrmWeightCheckInfo.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;//dataSet1.Tables[0];
                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);
                        }
                    }
                }
                //this.dataSet1.data = dt;
                //System.Diagnostics.Debug.WriteLine(this.dataSet1.Tables[0].ToString());
                foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                {
                    if (ugr.Cells["CHECK_STATE"].Text.Trim() == "审核不通过")
                        ugr.CellAppearance.BackColor = Color.OrangeRed;
                    else if (ugr.Cells["CHECK_STATE"].Text.Trim() == "审核通过")
                        ugr.CellAppearance.BackColor = Color.Lime;
                }
                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["BilletType"].CellActivation = Activation.ActivateOnly;
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["THICK"].CellActivation = Activation.ActivateOnly;
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["WIDTH"].CellActivation = Activation.ActivateOnly;
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["LENGTH"].CellActivation = Activation.ActivateOnly;
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["QUANTITY"].CellActivation = Activation.ActivateOnly;
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["WEIGHT"].CellActivation = Activation.ActivateOnly;
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["THEORYWEIGHT"].CellActivation = Activation.ActivateOnly;
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["GOWHERE"].CellActivation = Activation.ActivateOnly;
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["Check_State"].CellActivation = Activation.ActivateOnly;
            }
            catch (Exception EX)
            {
                MessageBox.Show(EX.ToString());
            }

        }

        private void CheckIn(string state)
        {
            string strErr = "", sqlNew = ""; int i = 0;
            if (this.ultraGrid1.Rows.Count == 0)
            {
                MessageBox.Show("请查询数据后再进行审核");
                return;
            }
            foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
            {
                if (ugr.Cells["Choose"].Text.Trim().ToUpper() != "TRUE")
                    continue;

                string billetno = ugr.Cells["BILLETNO"].Text.Trim();//坯号
                string billettype = ugr.Cells["BilletType"].Text.Trim();//坯料类型
                string MeterWeight = ugr.Cells["WeightPerMeter"].Text.Trim();//米单重
                string thick = ugr.Cells["THICK"].Text.Trim();//厚度
                string width = ugr.Cells["WIDTH"].Text.Trim();//宽度
                string length = ugr.Cells["LENGTH"].Text.Trim();//长度
                string quantity = ugr.Cells["QUANTITY"].Text.Trim();//支数
                string weight = ugr.Cells["WEIGHT"].Text.Trim();//磅重
                string theoryweight = ugr.Cells["THEORYWEIGHT"].Text.Trim();//理重
                string optman = this.UserInfo.GetUserName();
                string gowhere = ugr.Cells["GOWHERE"].Text.Trim();//去向
                string ccmid = ugr.Cells["CCMID"].Text.Trim();//铸机号
                if (!string.IsNullOrEmpty(ugr.Cells["Check_State"].Text.Trim()) && ugr.Cells["Check_State"].Text.Trim() != "未审核")
                {
                    MessageBox.Show(billetno + "已审核，如需重新审核，请先撤销审核");
                    return;
                }
                else
                {
                    sqlNew = "select * from CXUSER.JOB_WEIGHTCHECK_INFO@XGCX where billetno = '" + billetno + "'";
                    CoreClientParam CCP_Query = new CoreClientParam();
                    DataTable dt = new DataTable();
                    CCP_Query.ServerName = "Core.LgMes.Server.Common.ComDBExecute"; // 考虑原来返回数据形式性能太低，修改为前端传sql，服务端直接执行模式 2013.11.18
                    CCP_Query.MethodName = "doSimpleQuery";

                    CCP_Query.ServerParams = new object[] { sqlNew };
                    CCP_Query.SourceDataTable = dt;
                    ExecuteQueryToDataTable(CCP_Query, CoreInvokeType.Internal);
                    if (dt != null && dt.Rows.Count > 0)
                    {
                        MessageBox.Show(billetno + "已审核，如需重新审核，请先撤销审核");
                        proc_Query();
                        return;
                    }
                }

                string sql = "insert into CXUSER.JOB_WEIGHTCHECK_INFO@XGCX(BILLETNO,THICK,WIDTH,LENGTH,THEORYWEIGHT,WEIGHT,CHECK_STATE,CHECK_TIME,CHECK_MAN,"
                + "QUANTITY,METER_WEIGHT,BILLETTYPE,SLAB_SOURCE,GOWHERE,CCMID) "
                + " values('" + billetno + "','" + thick + "','" + width + "','" + length + "','" + theoryweight + "','" + weight + "','" + state + "',sysdate,'" + optman + "','" + quantity + "','" + MeterWeight + "','" + billettype + "' , '" + "第二炼钢厂" + "','" + gowhere + "','" + ccmid + "')";

                CommonClientToServer cctos = new CommonClientToServer();
                cctos.ob = this.ob;
                cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBExecute",
                                        "ExcuteNoParameter", sql, out strErr);

                if (!string.IsNullOrEmpty(strErr))
                {
                    MessageBox.Show("坯料:" + billetno + "审核失败。" + strErr);
                    proc_Query();
                    return;
                }
                i++;
            }
            MessageBox.Show(i + "条坯料全部审核成功。");
            proc_Query();
        }

        private void CheckCancel()
        {
            string strErr = "", sqlNew = ""; int i = 0;
            if (this.ultraGrid1.Rows.Count == 0)
            {
                MessageBox.Show("请查询数据后再进行撤销审核");
                return;
            }
            foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
            {
                if (ugr.Cells["Choose"].Text.Trim().ToUpper() != "TRUE")
                    continue;

                string billetno = ugr.Cells["BILLETNO"].Text.Trim();//坯号
                string billettype = ugr.Cells["BilletType"].Text.Trim();//坯料类型
                if (string.IsNullOrEmpty(ugr.Cells["Check_State"].Text.Trim()))
                {
                    MessageBox.Show(billetno + "已撤销，无需再次撤销");
                    return;
                }
                /*if (ugr.Cells["STORAGESTATUS"].Text.Trim() == "已出库")
                {
                    MessageBox.Show(billetno + "已出库，不允许撤销审核，请联系一钢质检");
                    return;
                }
                else 
                {
                    if (billettype == "板坯")
                    {
                        sqlNew = "select STORAGESTATUS from cxuser.kcg_stufflist@xgcx where billetno = '" + billetno + "'";
                    }
                    else
                    {
                        sqlNew = "select MAX(STORAGESTATUS) from cxuser.kcg_stufflist@xgcx where heatno = '" + billetno + "' group by heatno";
                    }
                    CallingMessage par1 = new CallingMessage();
                    par1.ServerName = "lgIntegrationQuery";
                    par1.AssemblyName = "Core.LgMes.Server.lgIntegrationQuery";
                    par1.ClassName = "Core.LgMes.Server.lgIntegrationQuery.LgGeneralInfo";
                    par1.MethodName = "ExecuteCommand_Return";
                    par1.args = new object[] { sqlNew };

                    DataSet ds1 = (DataSet)ClientCommon._RemotingHelp.ExecuteMethod(par1, out strErr);

                    String flag = ds1.Tables[0].Rows[0][0].ToString();
                    if (flag == "2")
                    {
                        MessageBox.Show(billetno + "已出库，不允许撤销审核，请联系一钢质检");
                        return;
                    }
                }*/


                string sql = "DELETE FROM CXUSER.JOB_WEIGHTCHECK_INFO@XGCX WHERE BILLETNO = '" + billetno + "'";

                CommonClientToServer cctos = new CommonClientToServer();
                cctos.ob = this.ob;
                cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBExecute",
                                        "ExcuteNoParameter", sql, out strErr);
                if (!string.IsNullOrEmpty(strErr))
                {
                    MessageBox.Show("坯料:" + billetno + "撤销失败。" + strErr);
                    proc_Query();
                    return;
                }
                i++;
            }
            MessageBox.Show(i + "条坯料全部撤销成功。");
            proc_Query();
        }

        private void ExportExcel()
        {
            try
            {
                if (this.ultraGrid1.Rows.Count == 0)
                {
                    MessageBox.Show("请先检索数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    return;
                }

                string StrfileName = System.Windows.Forms.Application.StartupPath + "\\Report\\过磅数据审核.xls";
                this.GridExcelExporter.Export(this.ultraGrid1, StrfileName);

                ProcessStartInfo p = new ProcessStartInfo(StrfileName);
                p.WindowStyle = System.Diagnostics.ProcessWindowStyle.Maximized;
                p.WorkingDirectory = Path.GetDirectoryName(StrfileName);
                Process.Start(p);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message + "\n处理方法：查看(" + System.Windows.Forms.Application.StartupPath + ")目录下是否有[ Report文件夹 ]，如果没有请手动创建！");
            }
        }

        private void uCkEditorForFilter_CheckedChanged(object sender, EventArgs e)
        {
            try
            {
                if (uCkEditorForFilter.Checked)
                {
                    this.ultraGrid1.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.True;
                }
                else
                {
                    this.ultraGrid1.DisplayLayout.Bands[0].ColumnFilters.ClearAllFilters();
                    this.ultraGrid1.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
                }
            }
            catch { }
        }

        private void chk_CCMID_CheckedChanged(object sender, EventArgs e)
        {
            if (chk_CCMID.Checked)
                cmb_CCMID.Enabled = true;
            else
                cmb_CCMID.Enabled = false;
        }



    }
}