XinYu_LZMES_Client/Core.LZMes.Client.UIC/UIC020140.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.Diagnostics;
using System.Collections;
using Infragistics.Win.UltraWinGrid;

namespace Core.LZMes.Client.UIC
{
    public partial class UIC020140 : FrmBase
    {
        public UIC020140()
        {
            InitializeComponent();
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    this.DoQuery();
                    break;
                case "Export":
                    this.DoExport();
                    break;
                case "Save":
                    this.DoSave();
                    break;
                case "Update":
                    this.DoUpdate();
                    break;
                case "Exit":
                    this.Close();
                    break;
            }
        }
        private void DoExport()
        {
            try
            {
                if (this.ultraGrid1.Rows.Count == 0)
                {
                    MessageBox.Show("没有可以导出的数据", "提示");
                    return;
                }
                saveFileDialog1.FileName = "热轧停扎时间" + DateTime.Today.ToShortDateString() + "_01";
                saveFileDialog1.Filter = "表格(*.xls)|*.xls";
                if (this.saveFileDialog1.ShowDialog(this) == DialogResult.OK)
                {
                    string fName = this.saveFileDialog1.FileName;
                    this.ultraGridExcelExporter1.Export(ultraGrid1, fName);
                    Process.Start(fName);
                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
        }

        private void JZExport()
        {
            try
            {
                if (this.ultraGrid4.Rows.Count == 0)
                {
                    MessageBox.Show("没有可以导出的数据", "提示");
                    return;
                }
                saveFileDialog1.FileName = "热轧班组节奏" + DateTime.Today.ToShortDateString() + "_01";
                saveFileDialog1.Filter = "表格(*.xls)|*.xls";
                if (this.saveFileDialog1.ShowDialog(this) == DialogResult.OK)
                {
                    string fName1 = this.saveFileDialog1.FileName;
                    this.ultraGridExcelExporter1.Export(ultraGrid4, fName1);
                    Process.Start(fName1);
                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
        }


        public void DoQuery()
        {
            try
            {
                ArrayList al = new ArrayList();
                al.Add("UIC020140_01.SELECT");
                al.Add(this.ultraDateTimeEditor1.DateTime.ToString("yyyyMMddHHmmss").Trim());
                al.Add(this.ultraDateTimeEditor2.DateTime.ToString("yyyyMMdd").Trim()+"999999");
                //查询详细停轧时间
                this.dataSet1.Tables[0].Clear();
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.COM.ComDBQuery";
                ccp.MethodName = "doSimpleQuery";
                ccp.ServerParams = new object[] { al };
                ccp.SourceDataTable = this.dataSet1.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);

                Color color = Color.FromArgb(255, 255, 255);
                foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugr in ultraGrid1.Rows)
                {
                    string status = ugr.Cells["CHKFLAG"].Value.ToString().Trim();
                
                    if ("1".Equals(status))
                    {
                        ugr.Cells["CHKTIME"].Appearance.BackColor = Color.Pink;
                    }
                   
                }
                  
              


                this.ultraGrid1.Update();
                //停扎时间按班次统计
                this.dataSet1.Tables[1].Clear();
                string queryDate = this.ultraDateTimeEditor1.DateTime.ToString("yyyyMMddHHmmss").Trim();
                string queryDate1 = this.ultraDateTimeEditor2.DateTime.ToString("yyyyMMdd").Trim() + "999999";

                if (queryDate.Substring(0, 6) != queryDate1.Substring(0, 6))
                {
                    MessageBox.Show("请确保两个查询日期在同一月份", "错误");
                    return;
                }

                string queryDate2 = "";//月累统计截止日期
                if (queryDate1.Substring(0, 6) == DateTime.Today.ToString("yyyyMM"))//查询日期为当月
                    queryDate2 = DateTime.Today.ToString("yyyyMMdd");
                else
                {
                    DateTime date = ultraDateTimeEditor2.DateTime;
                    queryDate2 = date.AddDays(1 - date.Day).AddMonths(1).AddDays(-1).ToString("yyyyMMdd");
                }
                CoreClientParam ccp1 = new CoreClientParam();
                ccp1.ServerName = "UIC.UIC02.UIC020120";
                ccp1.MethodName = "queryhot";
                ccp1.ServerParams = new object[] { queryDate, queryDate1, queryDate2 };
                ccp1.SourceDataTable = this.dataSet1.Tables[1];
                this.ExecuteQueryToDataTable(ccp1, CoreInvokeType.Internal);





                this.dataSet2.Tables[0].Clear();
                CoreClientParam ccp2 = new CoreClientParam();
                ccp2.ServerName = "UIC.UIC02.UIC020120";
                ccp2.MethodName = "queryTeam";
                ccp2.ServerParams = new object[] { queryDate, queryDate1, queryDate2 };
                ccp2.SourceDataTable = this.dataSet2.Tables[0];
                this.ExecuteQueryToDataTable(ccp2, CoreInvokeType.Internal);
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
        }
        private void label2_Click(object sender, EventArgs e)
        {

        }
        private void DoSave()
        {
            try
            {
                

                if (MessageBox.Show("确认保存？", "提示", MessageBoxButtons.OKCancel) == DialogResult.Cancel)
                    return;


                ArrayList al = new ArrayList();
                ArrayList list = null;
                string num1 = "";//日历时间
                string num2 = "";//停轧时间
                string strBC = "";//班次
                string strTime = "";
                string strProdLine = "";
                foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                {
                    
                    if (ugr.Cells["CHK"].Text == "True")
                    {

                        list = new ArrayList();
                        list.Add("UIC020140_01.UPDATE");
                        list.Add(ugr.Cells["CHKRESON"].Text.Trim());
                        list.Add(ugr.Cells["CHKNAME"].Text.Trim());
                        list.Add(ugr.Cells["BUGLOCAION"].Text.Trim());
                        list.Add(ugr.Cells["PRDSMOD"].Text.Trim());
                        list.Add(ugr.Cells["TIMESTART"].Text.Trim());
                        al.Add(list);
                    }
                }

                if (al.Count == 0)
                {
                    MessageBox.Show("没有修改的数据（红色行），保存无效", "提示");
                    return;
                }

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.COM.ComDBSave";
                ccp.MethodName = "doXmlSave";
                ccp.ServerParams = new object[] { al };
                ccp.IfShowErrMsg = false;
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                
                this.DoQuery();
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统发生异常，请与管理员联系", "提示");
            }
        }
        private void DoUpdate()
        {
            try
            {


                if (MessageBox.Show("确认保存？", "提示", MessageBoxButtons.OKCancel) == DialogResult.Cancel)
                    return;


                ArrayList al = new ArrayList();
                ArrayList list = null;
                string num1 = "";//日历时间
                string num2 = "";//停轧时间
                string strBC = "";//班次
                string strTime = "";
                string strProdLine = "";
                foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                {

                    if (ugr.Cells["CHK"].Text == "True")
                    {

                        list = new ArrayList();
                        list.Add("UIC020140_02.UPDATE");
                        list.Add(ugr.Cells["CHKRESON"].Text.Trim());
                        list.Add(ugr.Cells["CHKNAME"].Text.Trim());
                        list.Add(ugr.Cells["BUGLOCAION"].Text.Trim());
                        list.Add(ugr.Cells["PRDSMOD"].Text.Trim());
                        list.Add(ugr.Cells["TIMESTART"].Text.Trim());
                        al.Add(list);
                    }
                }

                if (al.Count == 0)
                {
                    MessageBox.Show("没有修改的数据（红色行），保存无效", "提示");
                    return;
                }

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.COM.ComDBSave";
                ccp.MethodName = "doXmlSave";
                ccp.ServerParams = new object[] { al };
                ccp.IfShowErrMsg = false;
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);


                this.DoQuery();
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统发生异常，请与管理员联系", "提示");
            }
        }
        private void UIC020140_Load(object sender, EventArgs e)
        {

        }

        private void ultraButton1_Click(object sender, EventArgs e)
        {
            this.JZExport();

           
        }
    }
}