MES_Client/TGMES/Core.StlMes.Client.Qcm/质量基础信息/QcmBaseInfo.cs

using Core.Mes.Client.Comm.Server;
using CoreFS.CA06;
using Infragistics.Win.UltraWinEditors;
using System;
using System.Data;
using System.Windows.Forms;

namespace Core.StlMes.Client.Qcm
{
    public class QcmBaseInfo
    {

        /// <summary>
        /// 填充质量标准名称
        /// </summary>
        /// <param name="cmb">ComboBox控件</param>
        /// <param name="ob">OpeBase操作对象</param>
        /// <param name="hasBlankLine">是否包含空行</param>
        /// <returns>是否填充成功</returns>
        public static bool Fill_STD_NAME(ComboBox cmb, OpeBase ob, bool hasBlankLine)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreStandard.bandCmbStd", new Object[] { }, ob);

            if (hasBlankLine && dt != null && dt.Rows.Count > 0)
            {
                DataRow dr = dt.NewRow();
                dt.Rows.InsertAt(dr, 0);
            }
            cmb.DataSource = dt;
            cmb.DisplayMember = "STD_NAME";
            cmb.ValueMember = "STD_CODE";
            return true;
        }

        /// <summary>
        /// 填充质量标准协会
        /// </summary>
        /// <param name="cmb">ComboBox控件</param>
        /// <param name="ob">OpeBase操作对象</param>
        /// <param name="hasBlankLine">是否包含空行</param>
        /// <returns>是否填充成功</returns>
        public static bool Fill_STD_STYLE(ComboBox cmb, OpeBase ob, bool hasBlankLine)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreStandard.bandCmbMaxStdXh", new Object[] { }, ob);

            if (hasBlankLine && dt != null && dt.Rows.Count > 0)
            {
                DataRow dr = dt.NewRow();
                dt.Rows.InsertAt(dr, 0);
            }
            cmb.DataSource = dt;
            cmb.DisplayMember = "BASENAME";
            cmb.ValueMember = "BASECODE";
            return true;
        }

        /// <summary>
        /// 填充质量品名
        /// </summary>
        /// <param name="cmb">ComboBox控件</param>
        /// <param name="ob">OpeBase操作对象</param>
        /// <param name="hasBlankLine">是否包含空行</param>
        /// <returns>是否填充成功</returns>
        public static bool Fill_ProducName(ComboBox cmb, OpeBase ob, bool hasBlankLine)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.ComBaseQuery.getProducName",
                new Object[] { }, ob);

            if (hasBlankLine && dt != null && dt.Rows.Count > 0)
            {
                DataRow dr = dt.NewRow();
                dt.Rows.InsertAt(dr, 0);
            }
            cmb.DataSource = dt;
            cmb.DisplayMember = "PRODUCNAME";
            cmb.ValueMember = "PRODUCCODE";
            return true;
        }

        /// <summary>
        /// 填充质量品名
        /// </summary>
        /// <param name="cmb">ComboBox控件</param>
        /// <param name="ob">OpeBase操作对象</param>
        /// <param name="hasBlankLine">是否包含空行</param>
        /// <returns>是否填充成功</returns>
        public static bool Fill_ProducName(UltraComboEditor cmb, OpeBase ob, bool hasBlankLine)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.ComBaseQuery.getProducName",
                new Object[] { }, ob);

            if (hasBlankLine && dt != null && dt.Rows.Count > 0)
            {
                DataRow dr = dt.NewRow();
                dt.Rows.InsertAt(dr, 0);
            }
            cmb.DataSource = dt;
            cmb.DisplayMember = "PRODUCNAME";
            cmb.ValueMember = "PRODUCCODE";
            ClsBaseInfo.SetComboItemHeight(cmb);
            return true;
        }

        /// <summary>
        /// 填充质量品名(简称)
        /// </summary>
        /// <param name="cmb">ComboBox控件</param>
        /// <param name="ob">OpeBase操作对象</param>
        /// <param name="hasBlankLine">是否包含空行</param>
        /// <returns>是否填充成功</returns>
        public static bool Fill_ProducJx(UltraComboEditor cmb, OpeBase ob, bool hasBlankLine)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.ComBaseQuery.getProducName2",
                new Object[] { }, ob);

            if (hasBlankLine && dt != null && dt.Rows.Count > 0)
            {
                DataRow dr = dt.NewRow();
                dt.Rows.InsertAt(dr, 0);
            }
            cmb.DataSource = dt;
            cmb.DisplayMember = "PRODUC_JX";
            cmb.ValueMember = "PRODUCCODE";
            ClsBaseInfo.SetComboItemHeight(cmb);
            return true;
        }

        /// <summary>
        /// 填充规格类型
        /// </summary>
        /// <param name="cmb">ComboBox控件</param>
        /// <param name="ob">OpeBase操作对象</param>
        /// <param name="hasBlankLine">是否包含空行</param>
        /// <returns>是否填充成功</returns>
        public static bool Fill_SpecType(UltraComboEditor cmb, bool hasBlankLine)
        {
            DataTable dt = new DataTable();
            dt.Columns.AddRange(new DataColumn[] { new DataColumn("ID"), new DataColumn("NAME") });
            dt.Rows.Add(new object[] { "A", "钢管" });
            dt.Rows.Add(new object[] { "B", "管坯" });
            dt.Rows.Add(new object[] { "D", "钢锭" });
            dt.Rows.Add(new object[] { "C", "其它" });

            if (hasBlankLine && dt != null && dt.Rows.Count > 0)
            {
                DataRow dr = dt.NewRow();
                dt.Rows.InsertAt(dr, 0);
            }
            cmb.DataSource = dt;
            cmb.DisplayMember = "NAME";
            cmb.ValueMember = "ID";
            ClsBaseInfo.SetComboItemHeight(cmb);
            return true;
        }

        /// <summary>
        /// 填充品名类型
        /// </summary>
        /// <param name="cmb"></param>
        /// <param name="hasBlankLine">是否空白行</param>
        /// <returns></returns>
        public static bool FillProductType(ComboBox cmb, bool hasBlankLine)
        {
            DataTable dt = new DataTable();
            dt.Columns.AddRange(new DataColumn[] { new DataColumn("NAME"), new DataColumn("CODE") });
            dt.Rows.Add(new object[] { "钢管（管坯）", "A" });
            dt.Rows.Add(new object[] { "钢管+接箍", "B" });
            dt.Rows.Add(new object[] { "短节+附件", "C" });
            dt.Rows.Add(new object[] { "接箍", "D" });
            dt.Rows.Add(new object[] { "双公短节", "E" });

            if (hasBlankLine)
            {
                DataRow dr = dt.NewRow();
                dt.Rows.InsertAt(dr, 0);
            }
            cmb.DataSource = dt;
            cmb.DisplayMember = "NAME";
            cmb.ValueMember = "CODE";
            return true;
        }

        /// <summary>
        /// 填充品名类型
        /// </summary>
        /// <param name="cmb"></param>
        /// <param name="hasBlankLine">是否空白行</param>
        /// <returns></returns>
        public static bool FillProductType(UltraComboEditor cmb, bool hasBlankLine)
        {
            DataTable dt = new DataTable();
            dt.Columns.AddRange(new DataColumn[] { new DataColumn("NAME"), new DataColumn("CODE") });
            dt.Rows.Add(new object[] { "钢管（管坯）", "A" });
            dt.Rows.Add(new object[] { "钢管+接箍", "B" });
            dt.Rows.Add(new object[] { "短节+附件", "C" });
            dt.Rows.Add(new object[] { "接箍", "D" });
            dt.Rows.Add(new object[] { "双工短节", "E" });

            if (hasBlankLine)
            {
                DataRow dr = dt.NewRow();
                dt.Rows.InsertAt(dr, 0);
            }
            cmb.DataSource = dt;
            cmb.DisplayMember = "NAME";
            cmb.ValueMember = "CODE";
            return true;
        }

        /// <summary>
        /// 判断6大标准，上下限同时存在时，数据的合法性。
        /// </summary>
        /// <param name="minSign">下限符号</param>
        /// <param name="maxSign">上限符号</param>
        /// <param name="minValue">下限值</param>
        /// <param name="maxValue">上限值</param>
        /// <returns>-1: 数据合理  0:数据不完整  1:符号导致的数据不合理 2:数据本身不合理</returns>
        public static int CheckStdData(string minSign, string maxSign, string minValue, string maxValue)
        {
            if (minSign == "" || maxSign == "" || minValue == "" || maxValue == "")
            {
                return 0;    //数据不完整
            }

            if (minValue == maxValue)  //范围值相同(上下限符号必须包含"=")
            {
                if (minSign.Contains("=") && maxSign.Contains("="))
                    return -1;     //合理
                return 1;  //符号不合理
            }
            else
            {
                if (maxValue.TryParseDecimal() && minValue.TryParseDecimal() && Convert.ToDouble(maxValue) < Convert.ToDouble(minValue))
                {
                    return 2; //数据大小不合理
                }
                return -1;  //合理
            }

        }
    }
}