MES_Client/TGMES/Core.StlMes.Client.SalePrice/SalePriceClass.cs

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using Core.Mes.Client.Comm.Server;
using CoreFS.CA06;
using Infragistics.Win;
using Infragistics.Win.UltraWinEditors;
using System.Collections;
using Infragistics.Win.UltraWinEditors;
using Infragistics.Win.UltraWinGrid;
using System.Drawing;


namespace Core.StlMes.Client.SalePrice
{
    public class SalePriceClass
    {
        /// <summary>
        /// 初始化下拉框
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="methodId">请求的服务</param>
        /// <param name="valueMember">值成员</param>
        /// <param name="ob">ob对象</param>
        /// <param name="isEmpty">是否有空行</param>
        public static void InitComboEditor(UltraComboEditor uce, string methodId, string valueMember, OpeBase ob, bool isEmpty)
        {
            DataTable dt = ServerHelper.GetData(methodId, null, ob);
            if (dt != null && dt.Rows.Count > 0)
            {
                if (isEmpty)
                {
                    Object[] obj = new Object[] { "", "" };
                    DataRow dr = dt.NewRow();
                    dr.ItemArray = obj;
                    dt.Rows.InsertAt(dr, 0);
                }
                uce.DataSource = dt;
                uce.ValueMember = valueMember;
                ClsBaseInfo.SetComboItemHeight(uce);
            }
        }
        /// <summary>
        /// 初始化下拉框
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="methodId">请求的服务</param>
        /// <param name="valueMember">值成员</param>
        /// <param name="ob">ob对象</param>
        /// <param name="isEmpty">是否有空行</param>
        public static void InitComboEditor1(UltraComboEditor uce, string methodId, string valueMember, string displayMember, OpeBase ob, bool isEmpty)
        {
            DataTable dt = ServerHelper.GetData(methodId, null, ob);
            if (dt != null && dt.Rows.Count > 0)
            {
                if (isEmpty)
                {
                    Object[] obj = new Object[] { "", "" };
                    DataRow dr = dt.NewRow();
                    dr.ItemArray = obj;
                    dt.Rows.InsertAt(dr, 0);
                }
                uce.DataSource = dt;
                uce.ValueMember = valueMember;
                uce.DisplayMember = displayMember;
                ClsBaseInfo.SetComboItemHeight(uce);
            }
        }

        /// <summary>
        /// 初始化下拉框 --带参数的
        /// </summary>
        /// <param name="uce"></param>
        /// <param name="methodId"></param>
        /// <param name="valueMember">值成员</param>
        /// <param name="displayMember">显示成员</param>
        /// <param name="ob"></param>
        /// <param name="isEmpty"></param>
        /// <param name="obj"></param>
        public static void InitComboEditorWithParm(UltraComboEditor uce, string methodId, string valueMember, string displayMember, OpeBase ob, bool isEmpty, Object[] parm)
        {
            DataTable dt = ServerHelper.GetData(methodId, parm, ob);
            if (dt != null && dt.Rows.Count > 0)
            {
                if (isEmpty)
                {
                    Object[] obj = new Object[] { "", "" };
                    DataRow dr = dt.NewRow();
                    dr.ItemArray = obj;
                    dt.Rows.InsertAt(dr, 0);
                }
                uce.DataSource = dt;
                uce.ValueMember = valueMember;
                uce.DisplayMember = displayMember;
                ClsBaseInfo.SetComboItemHeight(uce);
            }
        }

        /// <summary>
        /// 根据数据DATATYPE 返回类型简称
        /// </summary>
        /// <param name="dataType"></param>
        /// <returns></returns>
        public static string GetColumnType(string dataType)
        {
            if (dataType.Equals(""))
                return "";
             if (dataType.Contains("CHAR"))
                return "C";
             if (dataType.Contains("INT") || dataType.Contains("NUM"))
                return "D";
             if (dataType.Contains("DATE"))
                 return "T";
             else
                 return "";   //尚未定义
        }
       //public static string[] XiaXianFuHao = new string[2] { ">",">=" }; //下限 符号 
       //public static string[] ShangXianFuHao = new string[2] { "<", "<=" }; //下限 符号 
  //static     ValueListItem DaYu = new ValueListItem(">");
  //static ValueListItem DaYuDengYu = new ValueListItem(">=");
  //static ValueListItem XiaoYu = new ValueListItem("<");
  //static ValueListItem XiaoYuDengYu = new ValueListItem("<=");

        //public  ValueListItem[] XiaXianFuHao = new ValueListItem[2] { new ValueListItem(">"), new ValueListItem(">=") };
        //public  ValueListItem[] ShangXianFuHao = new ValueListItem[2] { new ValueListItem("<"), new ValueListItem("<=") };


        /// <summary>
        /// 初始化上限符号
        /// </summary>
        /// <param name="uce">下拉框</param>
        public static void NitializeSignMax(UltraComboEditor uce)
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("STDMAX_SIGN");
            DataRow dr1 = dt.NewRow();
            dr1["STDMAX_SIGN"] = "";
            DataRow dr2 = dt.NewRow();
            dr2["STDMAX_SIGN"] = "<";
            DataRow dr3 = dt.NewRow();
            dr3["STDMAX_SIGN"] = "<=";
            dt.Rows.Add(dr1);
            dt.Rows.Add(dr2);
            dt.Rows.Add(dr3);
            uce.DataSource = dt;
            uce.DisplayMember = "STDMAX_SIGN";
        }

        /// <summary>
        /// 初始化下限符号
        /// </summary>
        /// <param name="uce">下拉框</param>
        public static void NitializeSignMin(UltraComboEditor uce)
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("STDMIN_SIGN");
            DataRow dr1 = dt.NewRow();
            dr1["STDMIN_SIGN"] = "";
            DataRow dr2 = dt.NewRow();
            dr2["STDMIN_SIGN"] = ">";
            DataRow dr3 = dt.NewRow();
            dr3["STDMIN_SIGN"] = ">=";
            DataRow dr4 = dt.NewRow();
            dr4["STDMIN_SIGN"] = "=";
            dt.Rows.Add(dr1);
            dt.Rows.Add(dr2);
            dt.Rows.Add(dr3);
            dt.Rows.Add(dr4);
            uce.DataSource = dt;
            uce.DisplayMember = "STDMIN_SIGN";
        }


        public static bool IsRepeat(ArrayList yourValue)
        {
            Hashtable ht = new Hashtable();
            foreach (var mv in yourValue)
            {
                if (ht.Contains(mv))
                {
                    return true;
                }
                else
                {
                    ht.Add(mv,mv);
                }
            }

           
            return false;
        }
        /// <summary>
        /// 颜色区别
        /// </summary>
        /// <param name="ultraGrid">数据集</param>
        /// <param name="columnName">列</param>
        /// <param name="columnName">属性</param>
        public static void DistinguishColor(UltraGrid ultraGrid, string columnName, string state)
        {
            UltraGridRow row = null;
            UltraGridRow rowChild = null;
            for (int i = 0; i < ultraGrid.Rows.Count; i++)
            {
                row = ultraGrid.Rows[i];
                if (!row.Cells[columnName].Value.ToString().Equals(state))
                {
                    row.Appearance.ForeColor = Color.Red;
                }
                if (row.HasChild())
                {
                    for (int j = 0; j < row.ChildBands[0].Rows.Count; j++)
                    {
                        rowChild = row.ChildBands[0].Rows[j];
                        if (!rowChild.Cells[columnName].Value.ToString().Equals(state))
                            rowChild.Appearance.ForeColor = Color.Red;
                    }
                }

            }
        }
        /// <summary>
        /// 执行DataTable中的查询返回新的DataTable
        /// </summary>
        /// <param name="dt">源数据DataTable</param>
        /// <param name="condition">查询条件</param>
        /// <returns></returns>
        public static DataTable GetNewDataTable(DataTable dt, string condition)
        {

            DataTable newdt = new DataTable();
            try
            {
                newdt = dt.Clone();
                DataRow[] dr = dt.Select(condition);
                for (int i = 0; i < dr.Length; i++)
                {
                    newdt.ImportRow((DataRow)dr[i]);
                }
                return newdt;//返回的查询结果
            }
            catch (Exception ex)
            {
                //MessageBox.Show(ex.Message);
                return newdt;
            }
        }
        /// <summary>
        /// 初始化上限符号
        /// </summary>
        /// <param name="uce">下拉框</param>
        public static void NitializeFactorClassifyId(UltraComboEditor uce)
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("FactorClassifyId");
            dt.Columns.Add("FactorClassifyName");
            DataRow dr1 = dt.NewRow();
            dr1["FactorClassifyId"] = "";
            dr1["FactorClassifyName"] = "";
            DataRow dr2 = dt.NewRow();
            dr2["FactorClassifyId"] = "X_1_FACTOR_ID";
            dr2["FactorClassifyName"] = "X轴因素一";
            DataRow dr3 = dt.NewRow();
            dr3["FactorClassifyId"] = "X_2_FACTOR_ID";
            dr3["FactorClassifyName"] = "X轴因素二";
            DataRow dr4 = dt.NewRow();
            dr4["FactorClassifyId"] = "X_3_FACTOR_ID";
            dr4["FactorClassifyName"] = "X轴因素三";
            DataRow dr5 = dt.NewRow();
            dr5["FactorClassifyId"] = "X_4_FACTOR_ID";
            dr5["FactorClassifyName"] = "X轴因素四";
            DataRow dr6 = dt.NewRow();
            dr6["FactorClassifyId"] = "X_5_FACTOR_ID";
            dr6["FactorClassifyName"] = "X轴因素五";
            DataRow dr7 = dt.NewRow();
            dr7["FactorClassifyId"] = "X_6_FACTOR_ID";
            dr7["FactorClassifyName"] = "X轴因素六";
            DataRow dr8 = dt.NewRow();
            dr8["FactorClassifyId"] = "X_7_FACTOR_ID";
            dr8["FactorClassifyName"] = "X轴因素七";
            DataRow dr9 = dt.NewRow();
            dr9["FactorClassifyId"] = "X_8_FACTOR_ID";
            dr9["FactorClassifyName"] = "X轴因素八";
            DataRow dr10 = dt.NewRow();
            dr10["FactorClassifyId"] = "Y_1_FACTOR_ID";
            dr10["FactorClassifyName"] = "Y轴范围一";
            DataRow dr11 = dt.NewRow();
            dr11["FactorClassifyId"] = "Y_2_FACTOR_ID";
            dr11["FactorClassifyName"] = "Y轴范围二";
        
            dt.Rows.Add(dr1);
            dt.Rows.Add(dr2);
            dt.Rows.Add(dr3);
            dt.Rows.Add(dr4);
            dt.Rows.Add(dr5);
            dt.Rows.Add(dr6);
            dt.Rows.Add(dr7);
            dt.Rows.Add(dr8);
            dt.Rows.Add(dr9);
            dt.Rows.Add(dr10);
            dt.Rows.Add(dr11);
          
            uce.DataSource = dt;
            uce.DisplayMember = "FactorClassifyName";
            uce.ValueMember = "FactorClassifyId";
        }

        /// <summary>
        /// 根据Column的 KEY来更改列显示标题
        /// </summary>
        /// <param name="BR_ID"></param>
        /// <param name="colName"></param>
        public static void ModifyColumnName(string BR_ID, string colName, UltraGrid ug, Boolean bl)
        {
            //   this.ugFramePrice.DisplayLayout.Bands[0].Columns.Add(BR_ID);
            UltraGridColumn GridColumn = ug.DisplayLayout.Bands[0].Columns[BR_ID];
            GridColumn.Header.Caption = colName;
            GridColumn.Hidden = !bl;
        }

    }
}