XinYu_LG2MES/ClientSolution/Core.LgMes.Client.LgDeviceManager/FrmEquipStopLog.cs

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

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

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    {
                        proc_Query();
                        break;
                    }
                case "Update":
                    {
                        if (ultraGrid1.ActiveRow == null)
                            return;

                        UltraGridRow ugr = this.ultraGrid1.ActiveRow;
                        DateTime EndTime = DateTime.Parse(ugr.Cells["STARTTIME"].Text.Trim());
                        string optman = ugr.Cells["OPTMAN"].Text.Trim();
                        TimeSpan ts = DateTime.Now.Subtract(EndTime);
                        if (ts.Days > 7) 
                        {
                            MessageBox.Show("所选记录已过期，无法进行更改");
                            return;
                        }
                        if (finalUser.Contains(optman)) 
                        {
                            MessageBox.Show("所选记录已被终判，不可再做修改");
                            return;
                        }

                        if (!finalUser.Contains(username) && !commonUser.Contains(username)) 
                        {
                            MessageBox.Show("当前账户无修改权限");
                            return;
                        }
                        SaveData(ugr);
                        proc_Query();
                        break;
                    }
                case "Split":
                    {
                        if (ultraGrid1.ActiveRow == null)
                            return;

                        UltraGridRow ugr = this.ultraGrid1.ActiveRow;
                        DateTime EndTime = DateTime.Parse(ugr.Cells["STARTTIME"].Text.Trim());
                        string optman = ugr.Cells["OPTMAN"].Text.Trim();
                        TimeSpan ts = DateTime.Now.Subtract(EndTime);
                        if (ts.Days > 7)
                        {
                            MessageBox.Show("所选记录已过期，无法进行拆分");
                            return;
                        }
                        if (!finalUser.Contains(username))
                        {
                            MessageBox.Show("当前账户无拆分权限");
                            return;
                        }
                        SplitData(ugr);
                        proc_Query();
                        break;
                    }
                case "Export":
                    {
                        if (ultraGrid1.Rows.Count <= 0)
                            return;

                        //bool bInstalled = (Type.GetTypeFromProgID("Excel.Application") != null);
                        //if (!bInstalled)
                        //{
                        //    MessageBox.Show("系统没有安装EXCEL组件，无法导出数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                        //    return;
                        //}

                        ExportDataWithSaveDialog(ref ultraGrid1, this.Text);

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

        string username = "";
        ArrayList commonUser, finalUser = new ArrayList();
        private void FrmEquipStopLog_Load(object sender, EventArgs e)
        {
            ultraDateTimeEditor1.DateTime = DateTime.Today;
            ultraDateTimeEditor2.DateTime = DateTime.Today;
            ValueList vl = new ValueList();
            vl.ValueListItems.Add("计划检修-日休", "计划检修-日休");
            vl.ValueListItems.Add("计划检修-周休", "计划检修-周休");
            vl.ValueListItems.Add("设备故障-机械", "设备故障-机械");
            vl.ValueListItems.Add("设备故障-电气", "设备故障-电气");
            vl.ValueListItems.Add("设备故障-液压", "设备故障-液压");
            vl.ValueListItems.Add("设备故障-仪控", "设备故障-仪控");
            vl.ValueListItems.Add("生产计划停机", "生产计划停机");
            vl.ValueListItems.Add("计划检修-集中检修", "计划检修-集中检修");
            vl.ValueListItems.Add("非计划检修", "非计划检修");
            vl.ValueListItems.Add("待料/待机", "待料/待机");
            vl.ValueListItems.Add("生产故障", "生产故障");
            vl.ValueListItems.Add("外部影响", "外部影响");
            vl.ValueListItems.Add("工艺调整-计划", "工艺调整-计划");
            vl.ValueListItems.Add("工艺调整-非计划", "工艺调整-非计划");
            vl.ValueListItems.Add("其他", "其他");
            this.ultraGrid1.DisplayLayout.Bands[0].Columns["STOPTYPE"].ValueList = vl;
            cbbPos.Enabled = false;
            username = this.UserInfo.GetUserID();

            string strSql = "SELECT REMARK COMMON_USER,STOP_MSG FINAL_USER FROM DEV_EQUIPSTOP_LOG T WHERE STATIONCODE = 'USER'";

            try
            {
                CoreClientParam CCP_LgEts = new CoreClientParam();
                DataTable dt = new DataTable();
                CCP_LgEts.ServerName = "Core.LgMes.Server.Common.ComDBExecute";
                CCP_LgEts.MethodName = "doSimpleQuery";
                CCP_LgEts.ServerParams = new object[] { strSql };
                CCP_LgEts.SourceDataTable = dt;
                this.ExecuteQueryToDataTable(CCP_LgEts, CoreInvokeType.Internal); 
                string common = dt.Rows[0][0].ToString();
                string final = dt.Rows[0][1].ToString();
                if (!string.IsNullOrEmpty(common))
                    commonUser = ArrayList.Adapter(common.Split(','));
                if (!string.IsNullOrEmpty(final))
                    finalUser = ArrayList.Adapter(final.Split(','));
            }
            catch { }
        }

        public void proc_Query() 
        {
            string strwhere = "";
            string strFrom = ultraDateTimeEditor1.DateTime.ToString("yyyy-MM-dd");
            string strTo = ultraDateTimeEditor2.DateTime.ToString("yyyy-MM-dd");
            strwhere = " and STARTTIME between trunc(to_date('{0}','yyyy-mm-dd')) and trunc(to_date('{1}','yyyy-mm-dd') + 1)";
            strwhere = string.Format(strwhere, strFrom, strTo);
            if (this.cbPos.Checked)
            {
                strwhere += " and STATIONCODE = '" + this.cbbPos.Text.ToString() + "'";
            }

            string strSql = "SELECT STATIONCODE, SHIFTCLASS, SHIFTGROUP, STOPTYPE, STARTTIME, ENDTIME, REMARK, OPTMAN, OPTDATE, SYSGUID "
                    + ", FLAG, STOP_MSG,ROUND((ENDTIME-STARTTIME)*24*60,2) DELAYTIME,SPLITMAN, SPLITTIME FROM DEV_EQUIPSTOP_LOG T WHERE 1=1 " + strwhere;

            strSql += " AND STATIONCODE <> 'USER' ORDER BY STARTTIME";
            try
            {
                string strOut = "";
                //调用服务端方法
                CoreClientParam CCP_LgEts = new CoreClientParam();
                DataTable dt = new DataTable();
                CCP_LgEts.ServerName = "Core.LgMes.Server.Common.ComDBExecute";
                CCP_LgEts.MethodName = "doSimpleQuery";
                CCP_LgEts.ServerParams = new object[] { strSql };
                CCP_LgEts.SourceDataTable = dt;
                this.ExecuteQueryToDataTable(CCP_LgEts, CoreInvokeType.Internal);

                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);
                    }
                }
                ultraGrid1.UpdateData();
                proc_SetUltraGridReadOnly(ultraGrid1);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }

        public void SaveData(UltraGridRow ugr)
        {
            try
            {
                string strErr = "";
                string sysGuid = ugr.Cells["SYSGUID"].Text.Trim();
                string stopType = ugr.Cells["STOPTYPE"].Text.Trim();
                string remark = ugr.Cells["REMARK"].Text.Trim();

                string strSql = "UPDATE DEV_EQUIPSTOP_LOG SET STOPTYPE = '{0}',REMARK = '{1}',OPTMAN = '{2}',OPTDATE = SYSDATE WHERE SYSGUID = '{3}'";

                strSql = string.Format(strSql, stopType, remark, username, sysGuid);

                try
                {
                    CommonClientToServer cctos = new CommonClientToServer();
                    cctos.ob = this.ob;
                    // DataSet ds = 
                    cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBExecute",
                                            "ExcuteNoParameter", strSql, out strErr);
                    if (string.IsNullOrEmpty(strErr))
                        MessageBox.Show("修改成功!");
                    else
                        MessageBox.Show("修改失败:" + strErr);
                }
                catch (Exception e)
                {
                    MessageBox.Show("修改失败:" + e.Message + "!");
                }
            }
            catch { }
           
        }

        public void SplitData(UltraGridRow ugr)
        {
            string sysGuid = ugr.Cells["SYSGUID"].Text.Trim();
            string endTime = ugr.Cells["ENDTIME"].Text.Trim();
            string starttime = ugr.Cells["STARTTIME"].Text.Trim();
            FrmSplitUtil frm = new FrmSplitUtil();
            frm.sysguid = sysGuid;
            frm.username = username;
            frm.v_endtime = endTime;
            frm.v_starttime = starttime;
            frm.ob1 = this.ob;
            frm.Location = GetChildWindowLocation(frm.Size);
            frm.StartPosition = FormStartPosition.CenterParent;
            frm.ShowDialog();
        }

        private void proc_SetUltraGridReadOnly(Infragistics.Win.UltraWinGrid.UltraGridBase ultGrid)
        {
            foreach (UltraGridRow row in ultGrid.Rows)
            {
                row.Cells["STOPTYPE"].Activation = Activation.AllowEdit;
                row.Cells["REMARK"].Activation = Activation.AllowEdit;
                row.Cells["STATIONCODE"].Activation = Activation.NoEdit;
                row.Cells["SHIFTCLASS"].Activation = Activation.NoEdit;
                row.Cells["SHIFTGROUP"].Activation = Activation.NoEdit;
                row.Cells["STARTTIME"].Activation = Activation.NoEdit;
                row.Cells["ENDTIME"].Activation = Activation.NoEdit;
                row.Cells["DELAYTIME"].Activation = Activation.NoEdit;
                row.Cells["OPTMAN"].Activation = Activation.NoEdit;
                row.Cells["OPTDATE"].Activation = Activation.NoEdit;
            }
        }

        public static void ExportDataWithSaveDialog(ref UltraGrid ultGrid, string strFileName)
        {
            try
            {
                UltraGridExcelExporter ultraGridExcelExporter1 = new UltraGridExcelExporter();
                if (ultGrid.Rows.Count == 0) return;

                if (strFileName.Length == 0)
                    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(ultGrid, strFileName);

                    //2012-04-10何晓晴修改导出功能


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

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

        //==========================================================
        // 获取子窗体弹出的位置坐标
        //==========================================================
        public static Point GetChildWindowLocation(Size ChildWindowSize)
        {
            int width = Cursor.Position.X + ChildWindowSize.Width - Screen.PrimaryScreen.Bounds.Width;
            int height = Cursor.Position.Y + ChildWindowSize.Height - Screen.PrimaryScreen.Bounds.Height + 30;

            width = (width > 0) ? (Cursor.Position.X - width) : Cursor.Position.X; // X坐标
            height = (height > 0) ? (Cursor.Position.Y - height + 10) : (Cursor.Position.Y + 10); // Y坐标

            return new Point(width, height);
        }


        private void cbPos_CheckedChanged(object sender, EventArgs e)
        {
            if (cbPos.Checked)
                cbbPos.Enabled = true;
            else
                cbbPos.Enabled = false;
        }

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

        public static void SetGridRowFilter(ref UltraGrid ultGrid, bool bAllowFilter)
        {
            try
            {
                if (bAllowFilter)
                {
                    ultGrid.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.True;
                }
                else
                {
                    ultGrid.DisplayLayout.Bands[0].ColumnFilters.ClearAllFilters();
                    ultGrid.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
                }
            }
            catch { }
        }
    }
}