XinYu_LZMES_Client/Core.LZMes.Client.QCM/QCM03/QCM030702.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 Infragistics.Win.UltraWinGrid;
using System.Text.RegularExpressions;


namespace Core.LZMes.Client.QCM.QCM03
{
    public partial class QCM030702 : FrmBase
    {
        public QCM030702()
        {
            InitializeComponent();
        }
        public string lock_id = "";
        public static bool IsNumberal(string input)
        {
            bool flag = true;
            int count = 0;
            int count1 = 0;
            if (input.Length == 0)
            {
                flag = false;
            }
            else
            {
                char[] x = input.ToCharArray();
                for (int i = 0; i < input.Length; i++)
                {
                    if (!char.IsNumber(x[i]) && x[i] != '.' && x[i] != '-')
                    {
                        flag = false; break;
                    }
                    if (x[i] == '.')
                    {
                        count++;
                        if (i == 0 || i == input.Length - 1) flag = false;
                    }
                    if (x[i] == '-')
                    {
                        count1++;
                        if (i > 1) flag = false;
                    }
                }
                if (count > 1 || count1 > 1) flag = false;
            }
            return flag;
        }
        private static bool ishz(string text)
        {
            if (Regex.IsMatch(text, @"[\u4e00-\u9fa5]"))
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        private void QCM030702_Load(object sender, EventArgs e)
        {
            try
            {
                this.dataSet4.Clear();
                string phy_id = lock_id;
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM03.QCM0302.QcmJhyPhyresultServiceImpl";
                ccp.MethodName = "querryJudgetItemss";
                ccp.ServerParams = new object[] { phy_id };
                ccp.SourceDataTable = this.dataSet4.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                foreach (UltraGridRow ugrs in this.ultraGrid2.Rows)
                {
                    if (ugrs.Cells["defect_flag"].Value.ToString() == "是")
                    {
                        ugrs.Cells["defect_flag"].Appearance.ForeColor = Color.Red;
                    }
                    if (ugrs.Cells["isjudge"].Value.ToString() == "是")
                    {
                        if (ugrs.Cells["judge_basis"].Value.ToString() == "逐值判定")
                        {
                            DataTable dt = new DataTable();
                            if (IsNumberal(ugrs.Cells["val1"].Value.ToString()))
                            {
                                if (ishz(ugrs.Cells["jf_stdmin"].Value.ToString()) || ishz(ugrs.Cells["jf_stdmax"].Value.ToString()))
                                {
                                    ugrs.Cells["val1"].Appearance.ForeColor = Color.Red;
                                }
                                else
                                {
                                    if (ugrs.Cells["jf_stdmin"].Value.ToString() != "" && ugrs.Cells["val1"].Value.ToString() != "" && !(bool)dt.Compute(ugrs.Cells["val1"].Value.ToString() + ugrs.Cells["jf_stdmin"].Value.ToString(), ""))
                                    {
                                        ugrs.Cells["val1"].Appearance.ForeColor = Color.Red;
                                    }
                                    if (ugrs.Cells["jf_stdmax"].Value.ToString() != "" && ugrs.Cells["val1"].Value.ToString() != "" && !(bool)dt.Compute(ugrs.Cells["val1"].Value.ToString() + ugrs.Cells["jf_stdmax"].Value.ToString(), ""))
                                    {
                                        ugrs.Cells["val1"].Appearance.ForeColor = Color.Red;
                                    }
                                    if (ugrs.Cells["jf_stdmin"].Value.ToString() != "" && ugrs.Cells["val2"].Value.ToString() != "" && !(bool)dt.Compute(ugrs.Cells["val2"].Value.ToString() + ugrs.Cells["jf_stdmin"].Value.ToString(), ""))
                                    {
                                        ugrs.Cells["val2"].Appearance.ForeColor = Color.Red;
                                    }
                                    if (ugrs.Cells["jf_stdmax"].Value.ToString() != "" && ugrs.Cells["val2"].Value.ToString() != "" && !(bool)dt.Compute(ugrs.Cells["val2"].Value.ToString() + ugrs.Cells["jf_stdmax"].Value.ToString(), ""))
                                    {
                                        ugrs.Cells["val2"].Appearance.ForeColor = Color.Red;
                                    }
                                    if (ugrs.Cells["jf_stdmin"].Value.ToString() != "" && ugrs.Cells["val3"].Value.ToString() != "" && !(bool)dt.Compute(ugrs.Cells["val3"].Value.ToString() + ugrs.Cells["jf_stdmin"].Value.ToString(), ""))
                                    {
                                        ugrs.Cells["val3"].Appearance.ForeColor = Color.Red;
                                    }
                                    if (ugrs.Cells["jf_stdmax"].Value.ToString() != "" && ugrs.Cells["val3"].Value.ToString() != "" && !(bool)dt.Compute(ugrs.Cells["val3"].Value.ToString() + ugrs.Cells["jf_stdmax"].Value.ToString(), ""))
                                    {
                                        ugrs.Cells["val3"].Appearance.ForeColor = Color.Red;
                                    }
                                    if (ugrs.Cells["nk_stdmin"].Value.ToString() != "" && ugrs.Cells["val1"].Value.ToString() != "" && !(bool)dt.Compute(ugrs.Cells["val1"].Value.ToString() + ugrs.Cells["nk_stdmin"].Value.ToString(), ""))
                                    {
                                        ugrs.Cells["val1"].Appearance.ForeColor = Color.Red;
                                    }
                                    if (ugrs.Cells["nk_stdmax"].Value.ToString() != "" && ugrs.Cells["val1"].Value.ToString() != "" && !(bool)dt.Compute(ugrs.Cells["val1"].Value.ToString() + ugrs.Cells["nk_stdmax"].Value.ToString(), ""))
                                    {
                                        ugrs.Cells["val1"].Appearance.ForeColor = Color.Red;
                                    }
                                    if (ugrs.Cells["nk_stdmin"].Value.ToString() != "" && ugrs.Cells["val2"].Value.ToString() != "" && !(bool)dt.Compute(ugrs.Cells["val2"].Value.ToString() + ugrs.Cells["nk_stdmin"].Value.ToString(), ""))
                                    {
                                        ugrs.Cells["val2"].Appearance.ForeColor = Color.Red;
                                    }
                                    if (ugrs.Cells["nk_stdmax"].Value.ToString() != "" && ugrs.Cells["val2"].Value.ToString() != "" && !(bool)dt.Compute(ugrs.Cells["val2"].Value.ToString() + ugrs.Cells["nk_stdmax"].Value.ToString(), ""))
                                    {
                                        ugrs.Cells["val2"].Appearance.ForeColor = Color.Red;
                                    }
                                    if (ugrs.Cells["nk_stdmin"].Value.ToString() != "" && ugrs.Cells["val3"].Value.ToString() != "" && !(bool)dt.Compute(ugrs.Cells["val3"].Value.ToString() + ugrs.Cells["nk_stdmin"].Value.ToString(), ""))
                                    {
                                        ugrs.Cells["val3"].Appearance.ForeColor = Color.Red;
                                    }
                                    if (ugrs.Cells["nk_stdmax"].Value.ToString() != "" && ugrs.Cells["val3"].Value.ToString() != "" && !(bool)dt.Compute(ugrs.Cells["val3"].Value.ToString() + ugrs.Cells["nk_stdmax"].Value.ToString(), ""))
                                    {
                                        ugrs.Cells["val3"].Appearance.ForeColor = Color.Red;
                                    }
                                    if (ugrs.Cells["kh_stdmin"].Value.ToString() != "" && ugrs.Cells["val1"].Value.ToString() != "" && !(bool)dt.Compute(ugrs.Cells["val1"].Value.ToString() + ugrs.Cells["kh_stdmin"].Value.ToString(), ""))
                                    {
                                        ugrs.Cells["val1"].Appearance.ForeColor = Color.Red;
                                    }
                                    if (ugrs.Cells["kh_stdmax"].Value.ToString() != "" && ugrs.Cells["val1"].Value.ToString() != "" && !(bool)dt.Compute(ugrs.Cells["val1"].Value.ToString() + ugrs.Cells["kh_stdmax"].Value.ToString(), ""))
                                    {
                                        ugrs.Cells["val1"].Appearance.ForeColor = Color.Red;
                                    }
                                    if (ugrs.Cells["kh_stdmin"].Value.ToString() != "" && ugrs.Cells["val2"].Value.ToString() != "" && !(bool)dt.Compute(ugrs.Cells["val2"].Value.ToString() + ugrs.Cells["kh_stdmin"].Value.ToString(), ""))
                                    {
                                        ugrs.Cells["val2"].Appearance.ForeColor = Color.Red;
                                    }
                                    if (ugrs.Cells["kh_stdmax"].Value.ToString() != "" && ugrs.Cells["val2"].Value.ToString() != "" && !(bool)dt.Compute(ugrs.Cells["val2"].Value.ToString() + ugrs.Cells["kh_stdmax"].Value.ToString(), ""))
                                    {
                                        ugrs.Cells["val2"].Appearance.ForeColor = Color.Red;
                                    }
                                    if (ugrs.Cells["kh_stdmin"].Value.ToString() != "" && ugrs.Cells["val3"].Value.ToString() != "" && !(bool)dt.Compute(ugrs.Cells["val3"].Value.ToString() + ugrs.Cells["kh_stdmin"].Value.ToString(), ""))
                                    {
                                        ugrs.Cells["val3"].Appearance.ForeColor = Color.Red;
                                    }
                                    if (ugrs.Cells["kh_stdmax"].Value.ToString() != "" && ugrs.Cells["val3"].Value.ToString() != "" && !(bool)dt.Compute(ugrs.Cells["val3"].Value.ToString() + ugrs.Cells["kh_stdmax"].Value.ToString(), ""))
                                    {
                                        ugrs.Cells["val3"].Appearance.ForeColor = Color.Red;
                                    }
                                }
                            }
                            else
                            {
                                if (ugrs.Cells["jf_stdmin"].Value.ToString() != "" && ugrs.Cells["val1"].Value.ToString() != "" && ugrs.Cells["jf_stdmin_sign"].Value.ToString() + ugrs.Cells["val1"].Value.ToString() != ugrs.Cells["jf_stdmin"].Value.ToString())
                                {
                                    ugrs.Cells["val1"].Appearance.ForeColor = Color.Red;
                                }
                                if (ugrs.Cells["jf_stdmax"].Value.ToString() != "" && ugrs.Cells["val1"].Value.ToString() != "" && ugrs.Cells["jf_stdmax_sign"].Value.ToString() + ugrs.Cells["val1"].Value.ToString() != ugrs.Cells["jf_stdmax"].Value.ToString())
                                {
                                    ugrs.Cells["val1"].Appearance.ForeColor = Color.Red;
                                }
                            }
                            
                        }
                        else if (ugrs.Cells["judge_basis"].Value.ToString() == "平均值")
                        {
                            DataTable dt = new DataTable();
                            if (ugrs.Cells["jf_stdmin"].Value.ToString() != "" && ugrs.Cells["avg_val"].Value.ToString() != "" && !(bool)dt.Compute(ugrs.Cells["avg_val"].Value.ToString() + ugrs.Cells["jf_stdmin"].Value.ToString(), ""))
                            {
                                ugrs.Cells["avg_val"].Appearance.ForeColor = Color.Red;
                            }
                            if (ugrs.Cells["jf_stdmax"].Value.ToString() != "" && ugrs.Cells["avg_val"].Value.ToString() != "" && !(bool)dt.Compute(ugrs.Cells["avg_val"].Value.ToString() + ugrs.Cells["jf_stdmax"].Value.ToString(), ""))
                            {
                                ugrs.Cells["avg_val"].Appearance.ForeColor = Color.Red;
                            }
                            if (ugrs.Cells["kh_stdmin"].Value.ToString() != "" && ugrs.Cells["avg_val"].Value.ToString() != "" && !(bool)dt.Compute(ugrs.Cells["avg_val"].Value.ToString() + ugrs.Cells["kh_stdmin"].Value.ToString(), ""))
                            {
                                ugrs.Cells["avg_val"].Appearance.ForeColor = Color.Red;
                            }
                            if (ugrs.Cells["kh_stdmax"].Value.ToString() != "" && ugrs.Cells["avg_val"].Value.ToString() != "" && !(bool)dt.Compute(ugrs.Cells["avg_val"].Value.ToString() + ugrs.Cells["kh_stdmax"].Value.ToString(), ""))
                            {
                                ugrs.Cells["avg_val"].Appearance.ForeColor = Color.Red;
                            }
                            if (ugrs.Cells["nk_stdmin"].Value.ToString() != "" && ugrs.Cells["avg_val"].Value.ToString() != "" && !(bool)dt.Compute(ugrs.Cells["avg_val"].Value.ToString() + ugrs.Cells["nk_stdmin"].Value.ToString(), ""))
                            {
                                ugrs.Cells["avg_val"].Appearance.ForeColor = Color.Red;
                            }
                            if (ugrs.Cells["nk_stdmax"].Value.ToString() != "" && ugrs.Cells["avg_val"].Value.ToString() != "" && !(bool)dt.Compute(ugrs.Cells["avg_val"].Value.ToString() + ugrs.Cells["nk_stdmax"].Value.ToString(), ""))
                            {
                                ugrs.Cells["avg_val"].Appearance.ForeColor = Color.Red;
                            }
                        }
                    }
                }
                //ccp = new CoreClientParam();
                //ccp.ServerName = "QCM.QCM03.QCM0301.QcmJhyElementsServiceImpl";
                //ccp.MethodName = "GetCheme";
                //ccp.ServerParams = new object[] { phy_id };
                //this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                //for (int i = 0; i < ccp.SourceDataTable.Rows.Count; i++)
                //{
                //    foreach (UltraGridRow ugr5 in this.ultraGrid2.Rows)
                //    {
                //        if (ccp.SourceDataTable.Rows[i]["phy_code_l"].ToString() == ugr5.Cells["phy_code_l"].Value.ToString() && ccp.SourceDataTable.Rows[i]["phy_code_m"].ToString() == ugr5.Cells["phy_code_m"].Value.ToString() && ccp.SourceDataTable.Rows[i]["phy_code_s"].ToString() == ugr5.Cells["phy_code_s"].Value.ToString() && ccp.SourceDataTable.Rows[i]["item_code_d"].ToString() == ugr5.Cells["item_code_d"].Value.ToString() && ccp.SourceDataTable.Rows[i]["item_code_t"].ToString() == ugr5.Cells["item_code_t"].Value.ToString() && ccp.SourceDataTable.Rows[i]["item_code_s"].ToString() == ugr5.Cells["item_code_s"].Value.ToString() && ccp.SourceDataTable.Rows[i]["item_code_l"].ToString() == ugr5.Cells["item_code_l"].Value.ToString())
                //        {
                //            if (ccp.SourceDataTable.Rows[i]["stdmin_sign"].ToString() + ccp.SourceDataTable.Rows[i]["stdmin"].ToString() == ugr5.Cells["jf_stdmin"].Value.ToString() && ugr5.Cells["jf_stdmin"].Value.ToString() != "")
                //            {
                //                ugr5.Cells["jf_stdmin"].Appearance.BackColor = Color.Red;
                //            }
                //            if (ccp.SourceDataTable.Rows[i]["stdmax_sign"].ToString() + ccp.SourceDataTable.Rows[i]["stdmax"].ToString() == ugr5.Cells["jf_stdmax"].Value.ToString() && ugr5.Cells["jf_stdmax"].Value.ToString() != "")
                //            {
                //                ugr5.Cells["jf_stdmax"].Appearance.BackColor = Color.Red;
                //            }
                //            if (ccp.SourceDataTable.Rows[i]["stdmin_sign"].ToString() + ccp.SourceDataTable.Rows[i]["stdmin"].ToString() == ugr5.Cells["kh_stdmin"].Value.ToString() && ugr5.Cells["kh_stdmin"].Value.ToString() != "")
                //            {
                //                ugr5.Cells["kh_stdmin"].Appearance.BackColor = Color.Red;
                //            }
                //            if (ccp.SourceDataTable.Rows[i]["stdmax_sign"].ToString() + ccp.SourceDataTable.Rows[i]["stdmax"].ToString() == ugr5.Cells["kh_stdmax"].Value.ToString() && ugr5.Cells["kh_stdmax"].Value.ToString() != "")
                //            {
                //                ugr5.Cells["kh_stdmax"].Appearance.BackColor = Color.Red;
                //            }
                //            if (ccp.SourceDataTable.Rows[i]["stdmin_sign"].ToString() + ccp.SourceDataTable.Rows[i]["stdmin"].ToString() == ugr5.Cells["nk_stdmin"].Value.ToString() && ugr5.Cells["nk_stdmin"].Value.ToString() != "")
                //            {
                //                ugr5.Cells["nk_stdmin"].Appearance.BackColor = Color.Red;
                //            }
                //            if (ccp.SourceDataTable.Rows[i]["stdmax_sign"].ToString() + ccp.SourceDataTable.Rows[i]["stdmax"].ToString() == ugr5.Cells["nk_stdmax"].Value.ToString() && ugr5.Cells["nk_stdmax"].Value.ToString() != "")
                //            {
                //                ugr5.Cells["nk_stdmax"].Appearance.BackColor = Color.Red;
                //            }
                //        }
                //    }
                //}

                RefreshAndAutoSize(ultraGrid2);
            }
            catch (Exception ex)
            {
                //System.Diagnostics.Debug.WriteLine(ex.ToString());
                //MessageBox.Show("系统出错，请联系管理人员", "警告");
            }
        }

        public static void RefreshAndAutoSize(UltraGrid ultraGrid)
        {
            try
            {
                ultraGrid.BeginUpdate();
                foreach (UltraGridBand band in ultraGrid.DisplayLayout.Bands)
                {
                    foreach (UltraGridColumn column in band.Columns)
                    {
                        column.PerformAutoResize(PerformAutoSizeType.AllRowsInBand, band.ColHeadersVisible ? true : false);
                    }
                }
            }
            catch { }
            ultraGrid.EndUpdate();
        }
    }
}