XinYu_LZMES_Client/.svn/pristine/d1/d19bbaba5eda7b3236943a21ffdc2013f01a14f6.svn-base

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;

namespace Core.LZMes.Client.UIK
{
    public partial class UIK010040 : FrmBase
    {
        public UIK010040()
        {
            InitializeComponent();
        }
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query"://查询
                    this.DoQuery();
                    break;
                case "Insert"://添加换上轧辊实绩
                    this.DoInsert();
                    break;
                case "Update"://下发换上轧辊实绩
                    this.DoUpdate();
                    break;
            }
        }
        private void DoQuery()
        {
            if (this.ultraCalendarENDTIME.Enabled == false && this.ultraCalendarSTRATTIME.Enabled == false)
            {
                this.ultraCalendarENDTIME.Text = "";
                this.ultraCalendarSTRATTIME.Text = "";
            }
            try
            {

                string starttiem = this.ultraCalendarSTRATTIME.Text.ToString();
                string endtime = this.ultraCalendarENDTIME.Text.ToString();
                bool flag = false;

                CoreClientParam ccp = new CoreClientParam();

                //DataTable dt = new DataTable();


                if (this.ultraCheckEditor1.Checked == false && this.ultraCheckAll.Checked == false)
                {
                    MessageBox.Show("请选择查询条件！");
                }
                else
                {

                    if (this.ultraCheckAll.Checked)
                    {
                        this.dataSet1.Tables[0].Clear();
                        this.ultraCheckAll.Checked = false;
                        ccp.ServerName = "UIK.UIK01.UIK010040";
                        ccp.MethodName = "DoQuery";
                        ccp.ServerParams = new object[] { starttiem, endtime, flag };
                        ccp.SourceDataTable = this.dataSet1.Tables[0];
                        this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);

                        DataRowCollection drc = this.dataSet1.Tables[0].Rows;

                        if (drc.Count <= 0)
                        {
                            MessageBox.Show("暂无酸洗液记录！");
                        }
                        this.ultraCalendarENDTIME.Enabled = false;
                        this.ultraCalendarSTRATTIME.Enabled = false;
                        return;
                    }

                    if (this.ultraCheckEditor1.Checked)
                    {
                        flag = true;
                        this.dataSet1.Tables[0].Clear();

                        ccp.ServerName = "UIK.UIK01.UIK010040";
                        ccp.MethodName = "DoQuery";
                        ccp.ServerParams = new object[] { starttiem, endtime, flag };
                        ccp.SourceDataTable = this.dataSet1.Tables[0];
                        this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);

                        DataRowCollection drc = this.dataSet1.Tables[0].Rows;

                        if (drc.Count <= 0)
                        {
                            MessageBox.Show("暂无酸洗液记录！");
                        }
                        this.ultraCheckAll.Checked = false;
                        this.ultraCalendarENDTIME.Enabled = false;
                        this.ultraCalendarSTRATTIME.Enabled = false;
                        return;
                    }

                }
            }
            catch (Exception Ex)
            {
                MessageBox.Show(Ex.ToString());
            }
        }

        private void UIK010040_Load(object sender, EventArgs e)
        {
            this.ultraCalendarENDTIME.Enabled = false;
            this.ultraCalendarSTRATTIME.Enabled = false;
            this.ultraTextREG_DTIME.Enabled = false;
            this.ultraTextREG_ID.Enabled = false;
        }

     
       private void ultraCheckEditor1_CheckedChanged(object sender, EventArgs e)
        {
            if (this.ultraCheckEditor1.Checked)
            {
                this.ultraCalendarENDTIME.Enabled = true;
                this.ultraCalendarSTRATTIME.Enabled = true;
                this.ultraCheckAll.Checked = false;
            }
            if (!this.ultraCheckEditor1.Checked)
            {
                this.ultraCalendarENDTIME.Enabled = false;
                this.ultraCalendarSTRATTIME.Enabled = false;
            }
        }

       private void ultraCheckAll_CheckedChanged(object sender, EventArgs e)
       {
            try
            {
                if (this.ultraCheckAll.Checked)
                {
                    this.ultraCheckEditor1.Checked = false;
                    this.ultraCalendarSTRATTIME.Enabled = false;
                    this.ultraCalendarENDTIME.Enabled = false;
                }
            }
            catch (Exception Ex)
            {
                MessageBox.Show(Ex.ToString());
            }
        }

       private void DoUpdate()
       {
           if (MessageBox.Show("您确认要修改？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
           {
               try
               {
                   Infragistics.Win.UltraWinGrid.UltraGridRow ugr = this.ultraGrid1.ActiveRow;

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

                       string IACID_CONCENT_1, ITEMPERATURE_1, IFE_CONCENT_1, IACID_CONCENT_2, ITEMPERATURE_2, IFE_CONCENT_2, IACID_CONCENT_3, ITEMPERATURE_3, IFE_CONCENT_3, IREG_ID, IREG_DTIME, IALTER_DTIME, IREG_ACID,IREG_FE,INEW_ACID,IDIS_ACID,IDIS_FE,ISAM_TATE,ISAM_TIME,ISAM_ADDRESS,ICL;

                       IREG_ID = this.ultraTextREG_ID.Text;
                       IREG_DTIME = this.ultraTextREG_DTIME.Text;
                       IACID_CONCENT_1 = this.ultraTextACID_CONCENT_1.Text;
                       IACID_CONCENT_2 = this.ultraTextACID_CONCENT_2.Text;
                       IACID_CONCENT_3 = this.ultraTextACID_CONCENT_3.Text;
                       IFE_CONCENT_1 = this.ultraTextFE_CONCENT_1.Text;
                       IFE_CONCENT_3 = this.ultraTextFE_CONCENT_3.Text;
                       IFE_CONCENT_2 = this.ultraTextFE_CONCENT_2.Text;
                       ITEMPERATURE_1 = this.ultraTextTEMPERATURE_1.Text;
                       ITEMPERATURE_2 = this.ultraTextTEMPERATURE_2.Text;
                       ITEMPERATURE_3 = this.ultraTextTEMPERATURE_3.Text;

                       IALTER_DTIME = DateTime.Now.ToString();

                       IREG_ACID = this.ultraTextREG_ACID.Text;
                       IREG_FE = this.ultraTextREG_FE.Text;
                       INEW_ACID = this.ultraTextNEW_ACID.Text;
                       IDIS_ACID = this.ultraTextDIS_ACID.Text;
                       IDIS_FE = this.ultraTextDIS_FE.Text;
                       ISAM_TATE = this.ultraCalendarSAM_TATE.Text.ToString();
                       ISAM_TIME = this.ultraTextSAM_TIME.Text;
                       ISAM_ADDRESS = this.ultraTextSAM_ADDRESS.Text;

                       ICL = this.ultraTextCL.Text;

                       CoreClientParam ccp2 = new CoreClientParam();
                       ccp2.ServerName = "UIK.UIK01.UIK010040";
                       ccp2.MethodName = "DoUpdate";
                       ccp2.ServerParams = new object[] { IACID_CONCENT_1, ITEMPERATURE_1, IFE_CONCENT_1, IACID_CONCENT_2, ITEMPERATURE_2, IFE_CONCENT_2, IACID_CONCENT_3, ITEMPERATURE_3, IFE_CONCENT_3, IREG_ID, IALTER_DTIME, IREG_DTIME, IREG_ACID, IREG_FE, INEW_ACID, IDIS_ACID, IDIS_FE, ISAM_TATE, ISAM_TIME, ISAM_ADDRESS, ICL };
                       ccp2 = this.ExecuteNonQuery(ccp2, CoreInvokeType.Internal);

                       if (0 != ccp2.ReturnCode)
                       {
                           MessageBox.Show("修改失败！");
                       }
                       else
                       {
                           MessageBox.Show("修改成功！");
                           this.ultraTextREG_ID.Clear();
                           this.ultraTextREG_DTIME.Clear();
                           this.ultraTextACID_CONCENT_1.Clear();
                           this.ultraTextACID_CONCENT_2.Clear();
                           this.ultraTextACID_CONCENT_3.Clear();
                           this.ultraTextFE_CONCENT_1.Clear();
                           this.ultraTextFE_CONCENT_3.Clear();
                           this.ultraTextFE_CONCENT_2.Clear();
                           this.ultraTextTEMPERATURE_1.Clear();
                           this.ultraTextTEMPERATURE_2.Clear();
                           this.ultraTextTEMPERATURE_3.Clear();

                           this.ultraTextSAM_TIME.Clear();
                           this.ultraTextREG_ACID.Clear();
                           this.ultraTextREG_FE.Clear();
                           this.ultraTextNEW_ACID.Clear();
                           this.ultraTextDIS_ACID.Clear();
                           this.ultraTextDIS_FE.Clear();
                           this.ultraTextSAM_ADDRESS.Clear();
                           this.ultraTextCL.Clear();
                           
                       }

                   }
                   else
                   {
                       MessageBox.Show("请选择修改行！");
                   }
               }
               catch (Exception Ex)
               {
                   MessageBox.Show(Ex.ToString());
               }
           }
       }

       private void ultraGrid1_CellChange(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e)
       {
           if (e.Cell.Column.Key == "SELECT_ITEM")
           {
               if (e.Cell.Text == "True")
               {
                   string ireg_datetime;

                   ireg_datetime = e.Cell.Row.Cells["REG_DTIME"].Text.ToString();
                   this.ultraTextREG_DTIME.Enabled = false;


                   /*for循环控制单选*/
                   int i = this.ultraGrid1.Rows.Count;
                   for (int j = 0; j < i; j++)
                   {
                       if (this.ultraGrid1.Rows[j].Cells["REG_DTIME"].Text != ireg_datetime)
                       {
                           this.ultraGrid1.Rows[j].Cells["SELECT_ITEM"].Value = false;
                       }
                   }

                   DataTable dt = new DataTable();
                   CoreClientParam ccp = new CoreClientParam();

                   ccp.ServerName = "UIK.UIK01.UIK010040";
                   ccp.MethodName = "DoSelect";
                   ccp.ServerParams = new object[] { ireg_datetime };
                   ccp.SourceDataTable = dt;
                   this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);

                   foreach (DataRow dr in dt.Rows)
                   {
                       this.ultraTextREG_ID.Text = dr["REG_ID"].ToString();
                       this.ultraTextREG_DTIME.Text = dr["REG_DTIME"].ToString();
                       this.ultraTextACID_CONCENT_1.Text = dr["ACID_CONCENT_1"].ToString();
                       this.ultraTextACID_CONCENT_2.Text = dr["ACID_CONCENT_2"].ToString();
                       this.ultraTextACID_CONCENT_3.Text = dr["ACID_CONCENT_3"].ToString();
                       this.ultraTextFE_CONCENT_1.Text = dr["FE_CONCENT_1"].ToString();
                       this.ultraTextFE_CONCENT_3.Text = dr["FE_CONCENT_3"].ToString();
                       this.ultraTextFE_CONCENT_2.Text = dr["FE_CONCENT_2"].ToString();
                       this.ultraTextTEMPERATURE_1.Text = dr["TEMPERATURE_1"].ToString();
                       this.ultraTextTEMPERATURE_2.Text = dr["TEMPERATURE_2"].ToString();
                       this.ultraTextTEMPERATURE_3.Text = dr["TEMPERATURE_3"].ToString();
                    
                       this.ultraCalendarSAM_TATE.Text = dr["SAM_TATE"].ToString();
                       this.ultraTextSAM_TIME.Text = dr["SAM_TIME"].ToString();
                       this.ultraTextREG_ACID.Text = dr["REG_ACID"].ToString();
                       this.ultraTextREG_FE.Text = dr["REG_FE"].ToString();
                       this.ultraTextNEW_ACID.Text = dr["NEW_ACID"].ToString();
                       this.ultraTextDIS_ACID.Text = dr["DIS_ACID"].ToString();
                       this.ultraTextDIS_FE.Text = dr["DIS_FE"].ToString();
                       this.ultraTextSAM_ADDRESS.Text = dr["SAM_ADDRESS"].ToString();

                       this.ultraTextCL.Text = dr["CL_DEEP"].ToString();
                   }
                
               }
               else
               {
                   this.ultraTextREG_ID.Clear();
                   this.ultraTextREG_DTIME.Clear();
                   this.ultraTextACID_CONCENT_1.Clear();
                   this.ultraTextACID_CONCENT_2.Clear();
                   this.ultraTextACID_CONCENT_3.Clear();
                   this.ultraTextFE_CONCENT_1.Clear();
                   this.ultraTextFE_CONCENT_3.Clear();
                   this.ultraTextFE_CONCENT_2.Clear();
                   this.ultraTextTEMPERATURE_1.Clear();
                   this.ultraTextTEMPERATURE_2.Clear();
                   this.ultraTextTEMPERATURE_3.Clear();

                   
                   this.ultraTextSAM_TIME.Clear();
                   this.ultraTextREG_ACID.Clear();
                   this.ultraTextREG_FE.Clear();
                   this.ultraTextNEW_ACID.Clear();
                   this.ultraTextDIS_ACID.Clear();
                   this.ultraTextDIS_FE.Clear();
                   this.ultraTextSAM_ADDRESS.Clear();
                   this.ultraTextCL.Clear();

               }


           }
       }

       private void DoInsert()
       {
           if (MessageBox.Show("您确认要添加信息吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
           {
               string IACID_CONCENT_1, ITEMPERATURE_1, IFE_CONCENT_1, IACID_CONCENT_2, ITEMPERATURE_2, IFE_CONCENT_2, IACID_CONCENT_3, ITEMPERATURE_3, IFE_CONCENT_3, IREG_ID, IREG_DTIME, IREG_ACID,IREG_FE,INEW_ACID,IDIS_ACID,IDIS_FE,ISAM_TATE,ISAM_TIME,ISAM_ADDRESS,ICL;

               IREG_ID = this.UserInfo.GetUserID();              
               IACID_CONCENT_1 = this.ultraTextACID_CONCENT_1.Text;
               IACID_CONCENT_2 = this.ultraTextACID_CONCENT_2.Text;
               IACID_CONCENT_3 = this.ultraTextACID_CONCENT_3.Text;
               IFE_CONCENT_1 = this.ultraTextFE_CONCENT_1.Text;
               IFE_CONCENT_3 = this.ultraTextFE_CONCENT_3.Text;
               IFE_CONCENT_2 = this.ultraTextFE_CONCENT_2.Text;
               ITEMPERATURE_1 = this.ultraTextTEMPERATURE_1.Text;
               ITEMPERATURE_2 = this.ultraTextTEMPERATURE_2.Text;
               ITEMPERATURE_3 = this.ultraTextTEMPERATURE_3.Text;

               IREG_DTIME = DateTime.Now.ToString();
               
               IREG_ACID = this.ultraTextREG_ACID.Text;
               IREG_FE = this.ultraTextREG_FE.Text;
               INEW_ACID = this.ultraTextNEW_ACID.Text;
               IDIS_ACID = this.ultraTextDIS_ACID.Text;
               IDIS_FE = this.ultraTextDIS_FE.Text;
               ISAM_TATE = this.ultraCalendarSAM_TATE.Text.ToString();
               ISAM_TIME = this.ultraTextSAM_TIME.Text;
               ISAM_ADDRESS = this.ultraTextSAM_ADDRESS.Text;

               ICL = this.ultraTextCL.Text;

               CoreClientParam ccp2 = new CoreClientParam();
               ccp2.ServerName = "UIK.UIK01.UIK010040";
               ccp2.MethodName = "DoInsert";
               ccp2.ServerParams = new object[] { IACID_CONCENT_1, ITEMPERATURE_1, IFE_CONCENT_1, IACID_CONCENT_2, ITEMPERATURE_2, IFE_CONCENT_2, IACID_CONCENT_3, ITEMPERATURE_3, IFE_CONCENT_3, IREG_ID, IREG_DTIME, IREG_ACID, IREG_FE, INEW_ACID, IDIS_ACID, IDIS_FE, ISAM_TATE, ISAM_TIME, ISAM_ADDRESS,ICL };
               ccp2 = this.ExecuteNonQuery(ccp2, CoreInvokeType.Internal);

               if (0 != ccp2.ReturnCode)
               {
                   MessageBox.Show("添加失败！");
               }
               else
               {
                   MessageBox.Show("添加成功！");
                   this.ultraTextREG_ID.Clear();
                   this.ultraTextREG_DTIME.Clear();
                   this.ultraTextACID_CONCENT_1.Clear();
                   this.ultraTextACID_CONCENT_2.Clear();
                   this.ultraTextACID_CONCENT_3.Clear();
                   this.ultraTextFE_CONCENT_1.Clear();
                   this.ultraTextFE_CONCENT_3.Clear();
                   this.ultraTextFE_CONCENT_2.Clear();
                   this.ultraTextTEMPERATURE_1.Clear();
                   this.ultraTextTEMPERATURE_2.Clear();
                   this.ultraTextTEMPERATURE_3.Clear();

                   
                   this.ultraTextSAM_TIME.Clear();
                   this.ultraTextREG_ACID.Clear();
                   this.ultraTextREG_FE.Clear();
                   this.ultraTextNEW_ACID.Clear();
                   this.ultraTextDIS_ACID.Clear();
                   this.ultraTextDIS_FE.Clear();
                   this.ultraTextSAM_ADDRESS.Clear();
                   this.ultraTextCL.Clear();

               }

           }
       }

       
        
    }
}