XinYu_LZMES_Client/Core.LZMes.Client.UIK/UIK01/UIK010010.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;

namespace Core.LZMes.Client.UIK
{
    public partial class UIK010010 : FrmBase
    {
        public UIK010010()
        {
            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 UIK010010_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 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.UIK010010";
                        ccp.MethodName = "DoQuery";
                        ccp.ServerParams = new object[] { starttiem, endtime, flag };
                        ccp.SourceDataTable = this.dataSet1.Tables[0];
                        this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);

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

                        if (drc1.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.UIK010010";
                        ccp.MethodName = "DoQuery";
                        ccp.ServerParams = new object[] { starttiem, endtime, flag };
                        ccp.SourceDataTable = this.dataSet1.Tables[0];
                        this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);

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


                        if (drc1.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 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;
                    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.UIK010010";
                    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_DTIME.Text = dr["REG_DTIME"].ToString();
                        this.ultraTextDENSITY.Text = dr["DENSITY"].ToString();
                        this.ultraTextVISCOSITY.Text = dr["VISCOSITY"].ToString();
                        this.ultraTextFLASH_POINT.Text = dr["FLASH_POINT"].ToString();
                        this.ultraTextFREEZ_POINT.Text = dr["FREEZ_POINT"].ToString();
                        this.ultraTextSTABILITY.Text = dr["STABILITY"].ToString();
                        this.ultraTextCONCENT.Text = dr["CONCENT"].ToString();
                        this.ultraTextESI.Text = dr["ESI"].ToString();
                        this.ultraTextACID.Text = dr["ACID"].ToString();
                        this.ultraTextPH.Text = dr["PH"].ToString();
                        this.ultraTextCONDUCTIVITY.Text = dr["CONDUCTIVITY"].ToString();
                        this.ultraTextSAPONIFICATION_VALUE.Text = dr["SAPONIFICATION_VALUE"].ToString();
                        this.ultraTextFE_VALUE.Text = dr["FE_VALUE"].ToString();
                        this.ultraTextASH_VALUE.Text = dr["ASH_VALUE"].ToString();
                        this.ultraTextC_VALUE.Text = dr["C_VALUE"].ToString();
                        this.ultraTextCL_VALUE.Text = dr["CL_VALUE"].ToString();
                        this.ultraTextBACTERIA_FUNGI.Text = dr["BACTERIA_FUNGI"].ToString();
                        this.ultraTextTEMPERATURE.Text = dr["TEMPERATURE"].ToString();
                        this.ultraTextREG_ID.Text = dr["REG_ID"].ToString();

                        this.ultraTextMAG_OIL.Text = dr["MAG_OIL"].ToString();
                        this.ultraTextBER_CON.Text = dr["BER_CON"].ToString();
                        this.ultraCalendarSAM_DATE.Text = dr["SAM_DATE"].ToString();
                        this.ultraTextSAM_TIME.Text = dr["SAM_TIME"].ToString();
                        this.ultraComboSAM_ADDRESS.Text = dr["SAM_ADDRESS"].ToString();
                        this.ultraTextEditor1.Text = dr["CANYOU"].ToString();
                        this.ultraTextEditor2.Text = dr["CATIE"].ToString();
                        this.ultraTextEditor3.Text = dr["STL_GRD"].ToString();
                        this.ultraTextEditor8.Text = dr["TYPH"].ToString();
                    }
                }
                else
                {
                    this.ultraTextREG_DTIME.Clear();
                    this.ultraTextDENSITY.Clear();
                    this.ultraTextVISCOSITY.Clear();
                    this.ultraTextFLASH_POINT.Clear();
                    this.ultraTextFREEZ_POINT.Clear();
                    this.ultraTextSTABILITY.Clear();
                    this.ultraTextCONCENT.Clear();
                    this.ultraTextESI.Clear();
                    this.ultraTextACID.Clear();
                    this.ultraTextPH.Clear();
                    this.ultraTextCONDUCTIVITY.Clear();
                    this.ultraTextSAPONIFICATION_VALUE.Clear();
                    this.ultraTextFE_VALUE.Clear();
                    this.ultraTextASH_VALUE.Clear();
                    this.ultraTextC_VALUE.Clear();
                    this.ultraTextCL_VALUE.Clear();
                    this.ultraTextBACTERIA_FUNGI.Clear();
                    this.ultraTextTEMPERATURE.Clear();
                    this.ultraTextREG_ID.Clear();

                    this.ultraTextMAG_OIL.Clear();
                    this.ultraTextBER_CON.Clear();
                    this.ultraTextSAM_TIME.Clear();
                    this.ultraComboSAM_ADDRESS.Clear();
                    this.ultraTextEditor1.Clear();
                    this.ultraTextEditor2.Clear();
                    this.ultraTextEditor3.Clear();
                    this.ultraTextEditor8.Clear();
                }

            }
        }

        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 IDENSITY, IVISCOSITY, IFLASH_POINT, IFREEZ_POINT, ISTABILITY, ICONCENT, IESI, IACID, IPH, ICONDUCTIVITY, ISAPONIFICATION_VALUE, IFE_VALUE, IASH_VALUE, IC_VALUE, ICL_VALUE, IBACTERIA_FUNGI, ITEMPERATURE, IREG_ID, IALTER_TIME, IREG_DTIME, IMAG_OIL, IBER_CON, ISAM_DATE, ISAM_TIME, ISAM_ADDRESS,CANYOU,CANTIE,GANGZ,TYPH;

                        IREG_DTIME = this.ultraTextREG_DTIME.Text.Trim();
                        IDENSITY = this.ultraTextDENSITY.Text.Trim();
                        IVISCOSITY = this.ultraTextVISCOSITY.Text.Trim();
                        IFLASH_POINT = this.ultraTextFLASH_POINT.Text.Trim();
                        IFREEZ_POINT = this.ultraTextFREEZ_POINT.Text.Trim();
                        ISTABILITY = this.ultraTextSTABILITY.Text.Trim();
                        ICONCENT = this.ultraTextCONCENT.Text.Trim();
                        IESI = this.ultraTextESI.Text.Trim();
                        IACID = this.ultraTextACID.Text.Trim();
                        IPH = this.ultraTextPH.Text.Trim();
                        ICONDUCTIVITY = this.ultraTextCONDUCTIVITY.Text.Trim();
                        ISAPONIFICATION_VALUE = this.ultraTextSAPONIFICATION_VALUE.Text.Trim();
                        IFE_VALUE = this.ultraTextFE_VALUE.Text.Trim();
                        IASH_VALUE = this.ultraTextASH_VALUE.Text.Trim();
                        IC_VALUE = this.ultraTextC_VALUE.Text.Trim();
                        ICL_VALUE = this.ultraTextCL_VALUE.Text.Trim();
                        IBACTERIA_FUNGI = this.ultraTextBACTERIA_FUNGI.Text.Trim();
                        ITEMPERATURE = this.ultraTextTEMPERATURE.Text.Trim();
                        IREG_ID = this.ultraTextREG_ID.Text;



                        IALTER_TIME = DateTime.Now.ToString();

                        IMAG_OIL = this.ultraTextMAG_OIL.Text.Trim();
                        IBER_CON = this.ultraTextBER_CON.Text.Trim();
                        ISAM_DATE = this.ultraCalendarSAM_DATE.Text.ToString().Trim();
                        ISAM_TIME = this.ultraTextSAM_TIME.Text.Trim();
                        ISAM_ADDRESS = this.ultraComboSAM_ADDRESS.Text.Trim();
                        CANYOU = this.ultraTextEditor1.Text.Trim();
                        CANTIE = this.ultraTextEditor2.Text.Trim();
                        GANGZ = this.ultraTextEditor3.Text.Trim();
                        TYPH = this.ultraTextEditor8.Text.Trim();
                        CoreClientParam ccp2 = new CoreClientParam();
                        ccp2.ServerName = "UIK.UIK01.UIK010010";
                        ccp2.MethodName = "DoUpdate";
                        ccp2.ServerParams = new object[] { IDENSITY, IVISCOSITY, IFLASH_POINT, IFREEZ_POINT, ISTABILITY, ICONCENT, IESI, IACID, IPH, ICONDUCTIVITY, ISAPONIFICATION_VALUE, IFE_VALUE, IASH_VALUE, IC_VALUE, ICL_VALUE, IBACTERIA_FUNGI, ITEMPERATURE, IREG_ID, IALTER_TIME, IREG_DTIME, IMAG_OIL, IBER_CON, ISAM_DATE, ISAM_TIME, ISAM_ADDRESS,CANYOU,CANTIE,GANGZ,TYPH };
                        ccp2 = this.ExecuteNonQuery(ccp2, CoreInvokeType.Internal);

                        if (0 != ccp2.ReturnCode)
                        {
                            MessageBox.Show("修改失败！");
                        }
                        else
                        {
                            MessageBox.Show("修改成功！");

                            this.ultraTextREG_DTIME.Enabled = true;
                            this.ultraTextREG_DTIME.Clear();
                            this.ultraTextDENSITY.Clear();
                            this.ultraTextVISCOSITY.Clear();
                            this.ultraTextFLASH_POINT.Clear();
                            this.ultraTextFREEZ_POINT.Clear();
                            this.ultraTextSTABILITY.Clear();
                            this.ultraTextCONCENT.Clear();
                            this.ultraTextESI.Clear();
                            this.ultraTextACID.Clear();
                            this.ultraTextPH.Clear();
                            this.ultraTextCONDUCTIVITY.Clear();
                            this.ultraTextSAPONIFICATION_VALUE.Clear();
                            this.ultraTextFE_VALUE.Clear();
                            this.ultraTextASH_VALUE.Clear();
                            this.ultraTextC_VALUE.Clear();
                            this.ultraTextCL_VALUE.Clear();
                            this.ultraTextBACTERIA_FUNGI.Clear();
                            this.ultraTextTEMPERATURE.Clear();
                            this.ultraTextREG_ID.Clear();

                            this.ultraTextMAG_OIL.Clear();
                            this.ultraTextBER_CON.Clear();
                            this.ultraTextSAM_TIME.Clear();
                            this.ultraComboSAM_ADDRESS.Clear();
                            this.ultraTextEditor1.Clear();
                            this.ultraTextEditor2.Clear();
                            this.ultraTextEditor3.Clear();
                            this.ultraTextEditor8.Clear();
                        }

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

        private void DoInsert()
        {
            if (MessageBox.Show("您确认要添加信息吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
            {
                string IDENSITY, IVISCOSITY, IFLASH_POINT, IFREEZ_POINT, ISTABILITY, ICONCENT, IESI, IACID, IPH, ICONDUCTIVITY, ISAPONIFICATION_VALUE, IFE_VALUE, IASH_VALUE, IC_VALUE, ICL_VALUE, IBACTERIA_FUNGI, ITEMPERATURE, IREG_ID, ireg_datetime, IMAG_OIL, IBER_CON, ISAM_DATE, ISAM_TIME, ISAM_ADDRESS,CANYOU,CANTIE,GANGZ,TYPH;

                ireg_datetime = DateTime.Now.ToString();
                IDENSITY = this.ultraTextDENSITY.Text.Trim();
                IVISCOSITY = this.ultraTextVISCOSITY.Text.Trim();
                IFLASH_POINT = this.ultraTextFLASH_POINT.Text.Trim();
                IFREEZ_POINT = this.ultraTextFREEZ_POINT.Text.Trim();
                ISTABILITY = this.ultraTextSTABILITY.Text.Trim();
                ICONCENT = this.ultraTextCONCENT.Text.Trim();
                IESI = this.ultraTextESI.Text.Trim();
                IACID = this.ultraTextACID.Text.Trim();
                IPH = this.ultraTextPH.Text.Trim();
                ICONDUCTIVITY = this.ultraTextCONDUCTIVITY.Text.Trim();
                ISAPONIFICATION_VALUE = this.ultraTextSAPONIFICATION_VALUE.Text.Trim();
                IFE_VALUE = this.ultraTextFE_VALUE.Text.Trim();
                IASH_VALUE = this.ultraTextASH_VALUE.Text.Trim();
                IC_VALUE = this.ultraTextC_VALUE.Text.Trim();
                ICL_VALUE = this.ultraTextCL_VALUE.Text.Trim();
                IBACTERIA_FUNGI = this.ultraTextBACTERIA_FUNGI.Text.Trim();
                ITEMPERATURE = this.ultraTextTEMPERATURE.Text.Trim();
                IREG_ID = this.UserInfo.GetUserID();


                IMAG_OIL = this.ultraTextMAG_OIL.Text.Trim();
                IBER_CON = this.ultraTextBER_CON.Text.Trim();
                ISAM_DATE = this.ultraCalendarSAM_DATE.Text.ToString();
                ISAM_TIME = this.ultraTextSAM_TIME.Text.Trim();
                ISAM_ADDRESS = this.ultraComboSAM_ADDRESS.Text.Trim();
                CANYOU = this.ultraTextEditor1.Text.Trim();
                CANTIE = this.ultraTextEditor2.Text.Trim();
                GANGZ = this.ultraTextEditor3.Text.Trim();
                TYPH = this.ultraTextEditor8.Text.Trim();
                    CoreClientParam ccp2 = new CoreClientParam();
                    ccp2.ServerName = "UIK.UIK01.UIK010010";
                    ccp2.MethodName = "DoInsert";
                    ccp2.ServerParams = new object[] { IDENSITY, IVISCOSITY, IFLASH_POINT, IFREEZ_POINT, ISTABILITY, ICONCENT, IESI, IACID, IPH, ICONDUCTIVITY, ISAPONIFICATION_VALUE, IFE_VALUE, IASH_VALUE, IC_VALUE, ICL_VALUE, IBACTERIA_FUNGI, ITEMPERATURE, IREG_ID, ireg_datetime, IMAG_OIL, IBER_CON, ISAM_DATE, ISAM_TIME, ISAM_ADDRESS,CANYOU,CANTIE,GANGZ,TYPH };
                    ccp2 = this.ExecuteNonQuery(ccp2, CoreInvokeType.Internal);

                    if (0 != ccp2.ReturnCode)
                    {
                        MessageBox.Show("添加失败！");
                    }
                    else
                    {
                        MessageBox.Show("添加成功！");

                        this.ultraTextREG_DTIME.Enabled = true;
                        this.ultraTextREG_DTIME.Clear();
                        this.ultraTextDENSITY.Clear();
                        this.ultraTextVISCOSITY.Clear();
                        this.ultraTextFLASH_POINT.Clear();
                        this.ultraTextFREEZ_POINT.Clear();
                        this.ultraTextSTABILITY.Clear();
                        this.ultraTextCONCENT.Clear();
                        this.ultraTextESI.Clear();
                        this.ultraTextACID.Clear();
                        this.ultraTextPH.Clear();
                        this.ultraTextCONDUCTIVITY.Clear();
                        this.ultraTextSAPONIFICATION_VALUE.Clear();
                        this.ultraTextFE_VALUE.Clear();
                        this.ultraTextASH_VALUE.Clear();
                        this.ultraTextC_VALUE.Clear();
                        this.ultraTextCL_VALUE.Clear();
                        this.ultraTextBACTERIA_FUNGI.Clear();
                        this.ultraTextTEMPERATURE.Clear();
                        this.ultraTextREG_ID.Clear();

                        this.ultraTextMAG_OIL.Clear();
                        this.ultraTextBER_CON.Clear();
                        this.ultraTextSAM_TIME.Clear();
                        this.ultraComboSAM_ADDRESS.Clear();
                        this.ultraTextEditor1.Clear();
                        this.ultraTextEditor2.Clear();
                        this.ultraTextEditor3.Clear();
                        this.ultraTextEditor8.Clear();
                    }
                
            }
        }

    }
}