MES_Client/TGMES/Core.StlMes.Client.Sale.Common/FrmStyleBase/FrmUIBase.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 System.Collections;

namespace Core.StlMes.Client.Sale.Common.FrmStyleBase
{
    public partial class FrmUIBase : FrmStyleBase
    {
        public FrmUIBase()
        {
            InitializeComponent();
        }

        protected System.Collections.Generic.List<string[]> GetDataStructCaption()
        {
            List<string[]> list = new List<string[]>();
            list.Add(new string[] { "INVOICE_MONTH", "账本月" });
            list.Add(new string[] { "INVOICE_ACCOUNT", "账本名" });
            list.Add(new string[] { "BALANCESUBJECT", "销售组织" });
            list.Add(new string[] { "SECONDACCOUNT", "区域" });
            list.Add(new string[] { "BUYERCODE", "结算单位" });
            list.Add(new string[] { "PRE_MONEY", "期初" });
            list.Add(new string[] { "INMONEY", "本月进款" });
            list.Add(new string[] { "INVOICE_MONEY", "本月结算" });
            list.Add(new string[] { "LST_MONEY", "期末" });
            list.Add(new string[] { "INVOICE_PERSON", "结转人" });
            list.Add(new string[] { "UPDATE_PERSON", "修改人" });
            list.Add(new string[] { "UPDATE_DATE", "修改时间" });
            list.Add(new string[] { "INVOICE_STS", "结转状态" });
            list.Add(new string[] { "INVOICE_DATE", "结转时间" });
            list.Add(new string[] { "PACTNO", "合同头" });
            list.Add(new string[] { "BUYERNAME", "结算单位" });
            list.Add(new string[] { "SALE_AREA_DESC", "销售区域" });
            list.Add(new string[] { "FST_DRAWEE_UNIT", "首次受票单位" });
            list.Add(new string[] { "WEIGHT", "重量" });

            list.Add(new string[] { "SHIPNO", "船号" });
            list.Add(new string[] { "INCEPTCORPCODE", "收货单位" });
            list.Add(new string[] { "QUANTITY", "支数" });
            list.Add(new string[] { "WEIGHT", "重量" });

            list.Add(new string[] { "MONEY", "金额" });
            list.Add(new string[] { "OUTSTOCKMNY", "吊装费" });
            list.Add(new string[] { "TRANSMNY", "运费" });
            list.Add(new string[] { "ISPRECLOSE", "是否虚单" });

            list.Add(new string[] { "ORD_NO", "合同号" });
            list.Add(new string[] { "ORD_SEQ", "合同行" });
            list.Add(new string[] { "ORD_LN_DLY", "交货行" });
            list.Add(new string[] { "SPETKEY", "规格" });

            list.Add(new string[] { "STEELCODEKEY", "钢级(牌号)" });
            list.Add(new string[] { "PRICE", "单价" });
            list.Add(new string[] { "AFFRIMPERSON", "末次确认人" });
            list.Add(new string[] { "AFFIRMTIME", "末次确认时间" });

            list.Add(new string[] { "BASEPRICE", "订单价" });
            list.Add(new string[] { "FORECORPCODE", "子公司" });
            list.Add(new string[] { "STATIONCODE", "到站" });
            list.Add(new string[] { "TALLYSHEET_NO", "理货单" });

            list.Add(new string[] { "BATCH_NO", "炉号" });
            list.Add(new string[] { "PNO", "批号" });
            list.Add(new string[] { "ACT_WGT", "重量" });
            list.Add(new string[] { "TICKETTYPE", "类型" });


            list.Add(new string[] { "TICKETNUM", "票据数" });
            list.Add(new string[] { "TRANS_TYPE", "运输类型" });
            list.Add(new string[] { "MOTORMANNAME", "承运公司" });
            list.Add(new string[] { "REG_ID", "维护人" });
            list.Add(new string[] { "REG_DTIME", "维护时间" });
            list.Add(new string[] { "AFFRIM_ID", "确认人" });
            list.Add(new string[] { "AFFRIM_TIME", "确认时间" });
            list.Add(new string[] { "MONEY_TYPE", "费用类型" });

            list.Add(new string[] { "ASKPLAN_ID", "提单号" });
            list.Add(new string[] { "TRANS_TYPE_NAME", "运输方式" });
            list.Add(new string[] { "REALINVOICENO_ORG", "首次真实发票号" });
            list.Add(new string[] { "REALINVOICENO", "末次真实发票号" });

            list.Add(new string[] { "INVOICENO", "末次结算单号" });
            list.Add(new string[] { "MONEY_ORG", "首次结算金额" });
            list.Add(new string[] { "PRICE_ORG", "首次单价" });
            list.Add(new string[] { "INVOICENO_ORG", "首次结算单号" });

            list.Add(new string[] { "INVOICENO_SEQ_ORG", "序号" });
            list.Add(new string[] { "TICKETPERSON", "确认人" });
            list.Add(new string[] { "TICKETDATE", "确认时间" });
            list.Add(new string[] { "CATEGORY", "品名" });

            list.Add(new string[] { "SPEC_ABBSYMNAME", "标准" });
            list.Add(new string[] { "STD_STYLE_DESC", "标准类别" });
            list.Add(new string[] { "MODEL_DESC", "扣型" });
            list.Add(new string[] { "ORDER_UNIT", "计量单位" });

            list.Add(new string[] { "SALE_AREA_DESC", "销售区域" });
            list.Add(new string[] { "SEND_NUM", "实发量" });
            list.Add(new string[] { "RECEIV_ADDR", "指定地址" });
            list.Add(new string[] { "DELVRY_ADDR", "交货地点" });

            list.Add(new string[] { "AGENCY_FL", "是否代办" });
            list.Add(new string[] { "ISREALCLOSE", "虚单关闭状态" });
            list.Add(new string[] { "TICKETSTATUS", "提单是否确认" });
            list.Add(new string[] { "INVOICEPERSON_ORG", "首次编单人" });

            list.Add(new string[] { "INVOICEPERSON", "末次编单人" });
            list.Add(new string[] { "INVOICEDATE", "末次编单时间" });
            list.Add(new string[] { "CONTAIN_TAX", "是否含税" });
            list.Add(new string[] { "BALNCE_PRICE_STS", "首次价格有效性" });

            list.Add(new string[] { "BALNCE_PRICE_ORG_STS", "末次价格有效性" });
            list.Add(new string[] { "REALINVOICENO_DATE1", "末次发票时间" });
            list.Add(new string[] { "REALINVOICENO_DATE", "末次发票时间" });
            list.Add(new string[] { "REALINVOICENO_DATE_ORG1", "首次发票时间" });
            list.Add(new string[] { "PACTINDEX", "钢种" });

            list.Add(new string[] { "INOUTMONEY", "金额" });
            list.Add(new string[] { "ACT_COUNT", "支数" });
            list.Add(new string[] { "ACT_WEIGHT", "重量" });
            list.Add(new string[] { "INOUTMONEY", "金额" });
            list.Add(new string[] { "TOTALMONEY", "金额" });
            list.Add(new string[] { "BATCHNO", "炉号" });
            list.Add(new string[] { "INVOICE_MONTH", "月份" });
            list.Add(new string[] { "REALINVOICENO_DATE_ORG", "首次发票时间" });

            

            
            return list;
        }

        public DataSet ExecuteReader(string sql)
        {
            Core.StlMes.Client.Sale.DbHelp.DbExecute dbExecute
                = new Core.StlMes.Client.Sale.DbHelp.DbExecute(this.ob);
            DataSet ds =  dbExecute.ExecuteQuery(sql);
            return ds;
        }


        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            if (ToolbarKey == "Query")
            {
                Query();
            }
            else  if (ToolbarKey == "Close")
            {
                this.Close();
            }
            else if (ToolbarKey == "Exit")
            {
                this.Close();
            }
            else if (ToolbarKey == "Add")
            {
                Add();
            }
            else if (ToolbarKey == "Delete")
            {
                Delete();
            }
            else if (ToolbarKey == "Update")
            {
                Update();
            }
            else if (ToolbarKey == "Affrim")
            {
                Affrim();
            }
            else if (ToolbarKey == "UnAffrim")
            {
                UnAffrim();
            }

            else if (ToolbarKey == "Export")
            {
                Export();
            }

            else if (ToolbarKey == "Send")
            {
                this.Send();
            }

            else if (ToolbarKey == "Send1")
            {
                this.Send1();
            }

            else if (ToolbarKey == "UnSend")
            {
                this.UnSend();
            }

            else if (ToolbarKey == "ImportTemplate")
            {
                this.ImportTemplate();
            }

            else if (ToolbarKey == "Import")
            {
                this.Import();
            }
            else
            { }

            
            
        }

        public virtual void Query()
        { 
        }
        public virtual void Add()
        {
        }
        public virtual void Delete()
        {
        }
        public virtual void Update()
        {
        }

        public virtual void Affrim()
        {
        }

        public virtual void UnAffrim()
        {
        }

        public virtual void Export()
        {
        }

        public virtual void Send()
        {
        }
        public virtual void Send1()
        {
        }
        public virtual void UnSend()
        {
        }
        public virtual void ImportTemplate()
        {
        }
        public virtual void Import()
        {
        }
        
       
       


        public void ExecuteNoReader(string sql)
        {
            Core.StlMes.Client.Sale.DbHelp.DbExecute dbExecute
                = new Core.StlMes.Client.Sale.DbHelp.DbExecute(this.ob);
            dbExecute.ExecuteNoQuery(sql);
        }

        public void ExecuteNoReader(ArrayList sqlList)
        {
            Core.StlMes.Client.Sale.DbHelp.DbExecute dbExecute
              = new Core.StlMes.Client.Sale.DbHelp.DbExecute(this.ob);
            if (sqlList == null || sqlList.Count == 0)
                return;
            StringBuilder sblist = new StringBuilder();
            foreach (string s in sqlList)
            {
              
                sblist.Append(s).Append(" ;");
               
            }
            StringBuilder sb = new StringBuilder();
            sb.Append("declare");
            sb.Append("  begin   ");
            sb.Append(sblist.ToString());
            sb.Append( "  commit; ");
            sb.Append("  exception when others then rollback;");
            sb.Append(" end ;");
            string sql = sb.ToString();
           
          
            dbExecute.ExecuteNoQuery(sql);
        }

       

        private void FrmUIBase_Load(object sender, EventArgs e)
        {
            this.IsLoadUserView = true;

        }

       

        protected  string GetSaleOrg()
        {
          string DeptID =   CoreFS.SA06.CoreUserInfo.UserInfo.GetDeptid();
            if (DeptID.IndexOf("002002") >= 0)
            {
                return "100102";
            }
            if (DeptID.IndexOf("002001004") >= 0)
            {
                return "100101";
            }
            if (DeptID.IndexOf("002001005") >= 0)
            {
                return "100103";
            }
            if (DeptID.IndexOf("002023001") >= 0)
            {
                return "100105";
            }
            return "100101";
        }

        protected string GetSaleOrgDesc()
        {
            string saleorg = GetSaleOrg();
            if ("100101" == saleorg)
                return "国内贸易部";
            else if("100102" == saleorg)
                return "国际贸易部";
            else if ("100103" == saleorg)
                return "钢贸公司";
            else if ("100105" == saleorg)
                return "天淮公司";
            return "";
        
        }

        protected string TextBoxValue = "Text";

        protected const string UnConfirm = "0";
        protected const string Confirm = "1";

        protected const string OrderStatus_Input = "0";
        protected const string OrderStatus_PendReview = "1";
        protected const string OrderStatus_Declared = "2";
        protected const string OrderStatus_SPass = "3";
        protected const string OrderStatus_SUnPass = "-3";
        protected const string OrderStatus_XPass = "5";
        protected const string OrderStatus_XUnpass = "-5";
        protected const string OrderStatus_Affrim = "6";
        protected const string OrderStatus_Send = "7";
        protected const string OrderStatus_SendClose = "8";
        protected const string OrderStatus_OrderClose = "9";

        protected const string ToolbarKey_Query = "Query";
        protected const string ToolbarKey_Add = "Add";
        protected const string ToolbarKey_Update = "Update";
        protected const string ToolbarKey_Delete = "Delete";
        protected const string ToolbarKey_unDelete = "unDelete";
        protected const string ToolbarKey_Export = "Export";
        protected const string ToolbarKey_Affrim = "Affrim";
        protected const string ToolbarKey_Declare = "Declare";
        protected const string ToolbarKey_UnDeclare = "UnDeclare";
        protected const string Toolbarkey_UnAffrim = "UnAffrim";
        protected const string ToolbarKey_Close = "Exit";
        protected const string ToolbarKey_OrderClose = "Close";
        protected const string ToolbarKey_OrderUnClose = "UnClose";
        protected const string ToolbarKey_Select = "Select";
        protected const string ToolbarKey_Save = "Save";
        protected const string ToolbarKey_Send = "Send";
        protected const string ToolbarKey_UnSend = "UnSend";

        protected const string Choice_DeleteInfo = "请选择需要删除的信息";
        protected const string Choice_UnDelteInfo = "请选择回退删除的信息";
        protected const string Choice_UpdateInfo = "请选择需要修改的信息";
        protected const string Choice_AffrimInfo = "请选择需要确认的合同";
        protected const string Choice_DeclareAffrimInfo = "请选择需要评审的合同";
        protected const string Choice_OrderUnAffrimInfo = "请选择需要撤销的合同";
        protected const string Choice_OrderCloseInfo = "请选择订单发运关闭的信息";
        protected const string Choice_OrderSendInfo = "请选择需要下发的订单";
        protected const string Choice_OrderUnSendInfo = "请选择取消下发的订单信息";
        protected const string Choice_SendRound = "请选择下发轮次";

        protected const string ReturnInfo_Delte = "确定删除本条信息吗？";
        protected const string RetrunInfo_Update = "确定修改本条信息吗？";
        protected const string RetrunInfo_Exit = "确认关闭界面吗？";
        protected const string RetrunInfo_Affrim = "是否合同确认？";
        protected const string RetrunInfo_DeclareAffrim = "是否确认评审？";
        protected const string ReturnInfo_OrderUnAffrim = "是否撤销合同确认？";
        protected const string ReturnInfo_OrderClose = "是否确认关闭发运信息？";
        protected const string ReturnInfo_OrderUnClose = "是否确认回退关闭发运信息？";
        protected const string ReturnInfo_OrderSend = "是否确认下发订单";
        protected const string ReturnInfo_OrderUnSend = "是否确认取消下发订单";
        protected const string ReturnInfo_Save = "是否确认保存？";
        protected const string RetrunInfo_Prompt = "提示";

        protected const string NotDelete = "本条信息未删除";
        protected const string Deleted = "本条信息已经被删除";
        protected const string NotEditLoadNo = "不能修改到站编号";
        protected const string NotEditOrderNo = "不能修改合同号";
        protected const string NotDeleteOrderLineInfo = "合同下存在订单，不能删除";
        protected const string NotDeleteOrderCreateName = "该合同不是由您创建，不能删除";
        protected const string NotOrderDStatusPassOrPlan = "订单已生效或者资源已下发，不允许删除";
        protected const string NotOrderUStatusPassOrPlan = "订单已生效或者资源已下发，不允许修改";
        protected const string SendRount = "该订单已经下发";
        protected const string NotSend = "该订单未下发";

        protected const string LoadExisting = "到站名称已存在";
        protected const string PortExisting = "港口名称已存在";
        protected const string ForeCorpExisting = "子公司名称已存在";
        protected const string Offic = "办事处";
        protected const string Subsidiary = "子公司";
        protected const string Snonentity = "子公司名称已存在";
        protected const string Car = "101102";
        protected const string Port = "101103";

        /// <summary>
        /// 操作成功提示信息
        /// </summary>
        protected string _MessageSuccess = "操作成功";

        /// <summary>
        /// 过滤数据方法，按配置的部门数据权限在客户端过滤
        /// </summary>
        /// <param name="dsSource"></param>
        /// <param name="deptidColName"></param>
        /// <returns></returns>
        protected DataSet GetDataSetByFilterDeptId(DataSet dsSource,string deptidColName)
        {
            Boolean isFilterData = true;
            //this.ValidDataPurviewIds
            if (this.ValidDataPurviewIds == null || this.ValidDataPurviewIds.Length == 0)
                return dsSource;
            if (!isFilterData)
                return dsSource;
            DataSet dsReturn = Util.UtilDataSet.GetDataSetWithRowFilter(dsSource, deptidColName, ValidDataPurviewIds);
            return dsReturn;
           

        }
        /// <summary>
        /// 客户端过滤数据，默认按字段为create_dept的值过滤
        /// </summary>
        /// <param name="dsSource"></param>
        /// <returns></returns>
        protected DataSet GetDataSetByFilterDeptId(DataSet dsSource)
        {
           
            return GetDataSetByFilterDeptId(dsSource, "CREATE_DEPT");

        }

        #region ds 构造
        protected  DataSet GetDataSetByColumnName()
        {
            DataSet ds = new DataSet();
            string[] columnName = GetDataSetColumnName();

            List<string> list = this.GetNumberColumn();
            if(columnName.Length == 0)
                return ds;
            Hashtable hsColumn = GetTbColumnNameAndDataType();
            Hashtable hsColumnCaption =  
                TbColumnDefine.TbColumnAndCaptionDefine.GetInstance().GetTbColumnAndCaption();          
            DataTable dt = new DataTable();
            if(GetTbName().Trim().Length > 0)
                dt.TableName = GetTbName().Trim();
            DataColumn dc =  null;
            foreach(String s in columnName)
            {
                dc = new DataColumn(s);
                if(hsColumn.ContainsKey(s.ToUpper()))
                {
                    dc.DataType = System.Type.GetType(hsColumn[s.ToUpper()].ToString());
                }
                else
                {
                    dc.DataType = System.Type.GetType("System.String");
                }
                if (list.Contains(s.ToUpper()))
                {
                    dc.DataType = System.Type.GetType("System.Decimal"); 
                }
                if(hsColumnCaption.ContainsKey(s.ToUpper()))
                {
                    dc.Caption = hsColumnCaption[s.ToUpper()].ToString();
                }

                // 自定义的重写caption

                if(GetDataSetColumnCaption().ContainsKey(s.ToUpper()))
                {
                    dc.Caption = GetDataSetColumnCaption()[s.ToUpper()].ToString();
                }

                try
                {
                    dt.Columns.Add(dc);
                }
                catch
                {
                }

            }
            ds.Tables.Add(dt);
            return ds;
           
        }

        protected DataSet GetDataSetByColumnName(string[] columnName,Hashtable hsColumnType, Hashtable hsCaption)
        {
            DataSet ds = new DataSet();
            if(columnName.Length == 0)
                return ds;
            Hashtable hsColumn = hsColumnType;
            Hashtable hsColumnCaption = TbColumnDefine.TbColumnAndCaptionDefine.GetInstance().GetTbColumnAndCaption(); 
            DataTable dt = new DataTable();
            DataColumn dc = null;
            List<string> list = this.GetNumberColumn();
            foreach(String s in columnName)
            {
                dc = new DataColumn(s);
                if( hsColumn != null && hsColumn.ContainsKey(s.ToUpper()))
                {
                    dc.DataType = System.Type.GetType(hsColumn[s.ToUpper()].ToString());
                }
                else
                {
                    dc.DataType = System.Type.GetType("System.String");
                }

                if (list.Contains(s.ToUpper()))
                {
                    dc.DataType = System.Type.GetType("System.Decimal");
                }

                // 如果是选择,表格编辑，表格删除按钮
                if(s == SelectColumnName || s== EditColumnName || s == DeleteColumnName)
                {
                    dc.DataType = System.Type.GetType("System.Boolean");
                    dc.DefaultValue = "FALSE";
                    dc.Caption = (s == SelectColumnName) ? SelectColumnCaption : ((s == EditColumnName) ? EditColumnCaption : DeleteColumnCaption);
                }

                // 自定义的重写caption
                if(hsCaption != null && hsCaption.ContainsKey(s.ToUpper()))
                {
                    dc.Caption = hsCaption[s.ToUpper()].ToString();
                }
                else
                {
                    if(hsColumnCaption.ContainsKey(s.ToUpper()))
                    {
                        dc.Caption = hsColumnCaption[s.ToUpper()].ToString();
                    }

                }

                if (GetDataSetColumnCaption().ContainsKey(s.ToUpper()))
                {
                    dc.Caption = GetDataSetColumnCaption()[s.ToUpper()].ToString();
                }






                try
                {
                    dt.Columns.Add(dc);
                }
                catch
                {
                }

            }
            ds.Tables.Add(dt);
            return ds;

        }

      

        protected virtual string GetTbName()
        {
            return "";
        }

        protected virtual string[] GetDataSetColumnName()
        {
            return new string[] { };
        }

        protected virtual string[] GetDataSetColumnType()
        {
            return new string[] { };
        }

        protected virtual System.Collections.Hashtable GetTbColumnNameAndDataType()
        {
            return new System.Collections.Hashtable();
        }

        protected virtual System.Collections.Hashtable GetDataSetColumnCaption()
        {
            return new System.Collections.Hashtable();
        }

      
        #endregion
        #region Grid 相关操作


        protected void SetGridStyle(ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd)
        {
            try
            {
                SetGridStyleAll(ref ugrd);
            }
            catch
            {
            }
        }

        protected void SetGridStyle(ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd1, ref  Infragistics.Win.UltraWinGrid.UltraGrid ugrd2)
        {
            try
            {
                SetGridStyle(ref ugrd1);
            }
            catch
            {
            }

            try
            {
                SetGridStyle(ref ugrd2);
            }
            catch
            {
            }
        }

        protected void SetGridStyle(ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd1,
            ref  Infragistics.Win.UltraWinGrid.UltraGrid ugrd2, ref  Infragistics.Win.UltraWinGrid.UltraGrid ugrd3)
        {
            try
            {
                SetGridStyle(ref ugrd1, ref ugrd2);
            }
            catch
            {
            }

            try
            {
                SetGridStyle(ref ugrd3);
            }
            catch
            {
            }
        }

        protected void SetGridStyle(ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd1,
           ref  Infragistics.Win.UltraWinGrid.UltraGrid ugrd2, ref  Infragistics.Win.UltraWinGrid.UltraGrid ugrd3,
            ref  Infragistics.Win.UltraWinGrid.UltraGrid ugrd4)
        {
            try
            {
                 SetGridStyle(ref ugrd1, ref ugrd2, ref ugrd3);
            }
            catch
            {
            }

            try
            {
                SetGridStyle(ref ugrd4);
                
            }
            catch
            {
            }
        }

        

        protected void SetGridStyle(ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd1,
           ref  Infragistics.Win.UltraWinGrid.UltraGrid ugrd2, ref  Infragistics.Win.UltraWinGrid.UltraGrid ugrd3,
            ref  Infragistics.Win.UltraWinGrid.UltraGrid ugrd4,
            ref  Infragistics.Win.UltraWinGrid.UltraGrid ugrd5)
        {
            try
            {
                SetGridStyle(ref ugrd1, ref ugrd2, ref ugrd3, ref ugrd4);
            }
            catch
            {
            }

            try
            {
                SetGridStyle(ref ugrd5);
            }
            catch
            {
            }
        }

        protected void SetGridStyle(ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd1,
           ref  Infragistics.Win.UltraWinGrid.UltraGrid ugrd2,
            ref  Infragistics.Win.UltraWinGrid.UltraGrid ugrd3,
            ref  Infragistics.Win.UltraWinGrid.UltraGrid ugrd4,
            ref  Infragistics.Win.UltraWinGrid.UltraGrid ugrd5,
            ref  Infragistics.Win.UltraWinGrid.UltraGrid ugrd6)
        {
            try
            {
                SetGridStyle(ref ugrd1, ref ugrd2, ref ugrd3, ref ugrd4, ref ugrd5);
            }
            catch
            {
            }

            try
            {
                SetGridStyle(ref ugrd6);
            }
            catch
            {
            }
        }


        protected void SetGridStaticsSum(ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd)
        {
            Util.UtilUltraGrid.SetStaticsInfoSum(ref ugrd, GetGridColumnForStaticsSum());
 
        }

        protected void SetGridStaticsAvg(ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd)
        {
            Util.UtilUltraGrid.SetStaticsInfoSum(ref ugrd, GetGridColumnForStaticsAvg());

        }

        /// <summary>
        /// 求和列的列表
        /// </summary>
        /// <returns></returns>
        protected virtual ArrayList GetGridColumnForStaticsSum()
        {
            ArrayList list = new ArrayList();
            list.Add("ACT_WGT");
            list.Add("CAL_WGT");
        
            list.Add("MONEY");
            list.Add("MONEY_ORG");
   
            list.Add("ORD_WGT");
            list.Add("OUTSTOCKMNY");
            list.Add("PRD_QTY");
      
            list.Add("QUANTITY");
            list.Add("SEND_NUM");
            list.Add("TESTPRICE");
            list.Add("TICKETNUM");
            list.Add("TRANSMONEY");
     

            list.Add("INOUTMONEY");
            list.Add("TOTALMONEY");
            list.Add("TRANS_MONEY");
            list.Add("LEAVEMONEY");
            list.Add("ASKPLAN_MONEY");
            list.Add("WEIGHT");
            list.Add("ACT_COUNT");
            list.Add("ACT_WEIGHT");

            list.Add("PRE_MONEY");
            list.Add("INMONEY");
            list.Add("INVOICE_MONEY");
            list.Add("LST_MONEY");

            list.Add("BALNCE_PRICE");
            list.Add("WEIGHT1");
            list.Add("MONEY1");
            list.Add("MONEY2");

            list.Add("STAMP_DUTY_MONEY");
            return list;
        }

        /// <summary>
        /// 求平均值列表
        /// </summary>
        /// <returns></returns>
        protected virtual ArrayList GetGridColumnForStaticsAvg()
        {
            return new ArrayList();
        }

        protected virtual Hashtable GetGridColumnHidden()
        {
            return new Hashtable();
        }

        protected virtual List<string> GetGridColumnListHidden()
        {
            return new List<string>();
        }


        protected void SetGridStyleAll(ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd)
        {
            Hashtable hsLength = TbColumnDefine.TbColumnAndCaptionDefine.GetInstance().GetTbColumnAndShowLength();
            Hashtable haHiddenColumn = GetGridColumnHidden();
            Hashtable hsDefineLen = GetGridColumnLength();
            List<string> listHiddenColumn = GetGridColumnListHidden();
            bool isExists = false;
            try
            {
                for(int i = 0; i < ugrd.DisplayLayout.Bands.Count; i++)
                {
                    foreach(Infragistics.Win.UltraWinGrid.UltraGridColumn ugc in ugrd.DisplayLayout
                        .Bands[i].Columns)
                    {
                        isExists = false;
                        ugc.Width = columnLen;
                        ugc.CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
                        try
                        {
                            if (hsLength.ContainsKey(ugc.Key.ToUpper()))
                            {
                                ugc.Width = int.Parse(hsLength[ugc.Key.ToUpper()].ToString());
                                isExists = true;

                            }
                             if (hsDefineLen.Count > 0 && hsDefineLen.ContainsKey(ugc.Key.ToUpper()))
                            {
                                ugc.Width = int.Parse(hsDefineLen[ugc.Key.ToUpper()].ToString());
                                isExists = true;

                            }

                      
                          

                            

                        }
                        catch
                        {
                        }

                        try
                        {
                            if(listHiddenColumn.Count > 0 && listHiddenColumn.Contains(ugc.Key.ToUpper()))
                            {
                                ugc.Hidden = true;

                            }

                            if(haHiddenColumn.Count > 0 && haHiddenColumn.ContainsKey(ugc.Key.ToUpper()))
                            {
                                ugc.Hidden = true;

                            }

                            
                        }
                        catch
                        {
                        }
                    }

                }
              
                
                
            }
            catch
            {

            }

            SetShareGridStyle(ref ugrd);
        }

        private int columnLen = 100;
        protected void SetGridStyleAll(ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd, Hashtable hsDefineLength)
        {
            Hashtable hsLength = TbColumnDefine.TbColumnAndCaptionDefine.GetInstance().GetTbColumnAndShowLength();
            Hashtable haHiddenColumn = GetGridColumnHidden();
            Hashtable hsDefineLen = hsDefineLength;
            List<string> listHiddenColumn = GetGridColumnListHidden();
            try
            {
                for(int i = 0; i < ugrd.DisplayLayout.Bands.Count; i++)
                {
                    foreach(Infragistics.Win.UltraWinGrid.UltraGridColumn ugc in ugrd.DisplayLayout
                        .Bands[i].Columns)
                    {
                        try
                        {
                            ugc.Width = columnLen;
                            if(hsLength.ContainsKey(ugc.Key.ToUpper()))
                            {
                                ugc.Width = int.Parse(hsLength[ugc.Key.ToUpper()].ToString());

                            }

                            if(hsDefineLen != null && hsDefineLen.Count > 0 && hsDefineLen.ContainsKey(ugc.Key.ToUpper()))
                            {
                                ugc.Width = int.Parse(hsDefineLen[ugc.Key.ToUpper()].ToString());

                            }


                        }
                        catch
                        {
                        }

                        try
                        {
                            if(listHiddenColumn.Count > 0 && listHiddenColumn.Contains(ugc.Key.ToUpper()))
                            {
                                ugc.Hidden = true;

                            }

                            if(haHiddenColumn.Count > 0 && haHiddenColumn.ContainsKey(ugc.Key.ToUpper()))
                            {
                                ugc.Hidden = true;

                            }
                        }
                        catch
                        {
                        }
                    }
                }

            }
            catch
            {

            }

            SetShareGridStyle(ref ugrd);

          

          
        }


        private void SetShareGridStyle(ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd)
        {
            SetChildGridHeaderApperance(ref ugrd);
            SetGridStaticsSum(ref ugrd);
            SetGridStaticsAvg(ref ugrd);
            SetGridTextAlign(ref ugrd);
            SetGridDateTypeColumnFormat(ref ugrd);
        }

        protected void SetChildGridHeaderApperance(ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd)
        {
          //  ugrd.Font.Bold = false;
           
 
        }


        protected void ResetGridFilterStyle(ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd)
        {
            try
            {
                ugrd.DisplayLayout.Override.FilterUIType = Infragistics.Win.UltraWinGrid.FilterUIType.FilterRow;
                ugrd.DisplayLayout.Override.FilterOperatorDefaultValue = Infragistics.Win.UltraWinGrid.FilterOperatorDefaultValue.Contains;

            }
            catch
            { }
        }


        protected void SetGridTextAlign(ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd)
        {
              List<string> list  = null;
              if (GetNumberTypeColulmn().Count > 0)
              {
                  list = GetNumberTypeColulmn();
              }
              else
              {
                  list = TbColumnDefine.TbColumnAndCaptionDefine.GetInstance().GetNumberTypeColulmn();
              }
            if (list == null || list.Count == 0)
                return;
            foreach (String s in list)
            {
                try
                {
                    for (int i = 0; i < ugrd.DisplayLayout.Bands.Count; i++)
                    {
                        ugrd.DisplayLayout.Bands[i].Columns[s].CellAppearance.TextHAlign = Infragistics.Win.HAlign.Right;
                    }
                }
                catch
                { 
                }
            }
        }

        protected virtual List<string> GetNumberTypeColulmn()
        {
            return new List<string>(new string[]{  
            });
        }

        /// <summary>
        /// 设置日期格式的显示时间
        /// </summary>
        /// <param name="ugrd"></param>
        protected void SetGridDateTypeColumnFormat(ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd)
        {
            try
            {
                string defaultFormat = "yyyy-MM-dd HH:mm:ss";
                List<string> list = TbColumnDefine.TbColumnAndCaptionDefine.GetInstance().GetDateTypeColulmn();
                if (list == null || list.Count == 0)
                { }
                else
                {
                    foreach (String s in list)
                    {
                        try
                        {
                            for (int i = 0; i < ugrd.DisplayLayout.Bands.Count; i++)
                            {
                                ugrd.DisplayLayout.Bands[i].Columns[s].Format = defaultFormat;
                            }
                        }
                        catch
                        {
                        }
                    }
                }
            }
            catch
            { }


            try
            {
                List<string> listNumber = GetNumberColumn();
                if (listNumber == null || listNumber.Count == 0)
                    return;
                List<string> listInteger = TbColumnDefine.TbColumnAndCaptionDefine.GetInstance().GetIntegerTypeColulmn();
                List<string> listPrice = TbColumnDefine.TbColumnAndCaptionDefine.GetInstance().GetPriceTypeColulmn();
                foreach (String s in listNumber)
                {
                  
                    try
                    {
                        for (int i = 0; i < ugrd.DisplayLayout.Bands.Count; i++)
                        {
                            if (listInteger.Contains(s))
                            {

                                ugrd.DisplayLayout.Bands[i].Columns[s].MaskInput = "-nnn,nnn,nnn,nnn,nnn";
                            }
                            else if
                             (listPrice.Contains(s))
                            {

                                ugrd.DisplayLayout.Bands[i].Columns[s].MaskInput = "-nnn,nnn,nnn,nnn.nnnn";
                            }
                            else
                            {
                                ugrd.DisplayLayout.Bands[i].Columns[s].MaskInput = "-nnn,nnn,nnn,nnn.nnn";
                            }
                            ugrd.DisplayLayout.Bands[i].Columns[s].MaskDisplayMode = Infragistics.Win.UltraWinMaskedEdit.MaskMode.IncludeLiterals;
                        }
                    }
                    catch
                    {
                    }
                }
            }
            catch
            { }
        }


        protected virtual List<string> GetNumberColumn()
        {
            return new List<string>(new string[]{    "SEND_NUM",
                "MONEY","STAMP_DUTY_MONEY",
                "WEIGHT",
              "QUANTITY",
                "ACT_WGT",
                "OUTSTOCKMNY",
                "TRANSMNY", 
                "PRICE",
                  "PRICE_ORG",
                "MONEY_ORG",
                "BALNCE_PRICE_ORG",
                "BALNCE_PRICE",
              "INOUTMONEY",
              "TOTALMONEY",
              "LEAVEMONEY",
              "ASKPLAN_MONEY",
              "TRANS_MONEY","ACT_COUNT","ACT_WEIGHT","SEND_NUM","PRE_MONEY","INMONEY","INVOICE_MONEY",
              "LST_MONEY",
              "INMONEY","INVOICE_MONEY","LST_MONEY","WEIGHT1","MONEY1","MONEY2"
            });
        }

      

        protected virtual Hashtable GetGridColumnLength()
        {
            return new Hashtable();
        }


        protected string SelectColumnName
        {
            get
            {
                return "SELECTEDCELL";
            }
        }

        protected string EditColumnName
        {
            get
            {
                return "EDITCELL";
            }
        }


        protected  string DeleteColumnName
        {
             get
            {
                return "DELETEDCELL";

            }
        }

        protected string SelectColumnCaption
        {
            get
            {
                return "选择";

            }
        }

        protected virtual string EditColumnCaption
        {
            get
            {
                return "编辑";

            }
        }

        protected virtual string DeleteColumnCaption
        {
            get
            {
                return "删除";

            }
        }

      


      

        
         
        #endregion

        #region  表数据结构定义
        protected string[] GetTbSlmOrderHeadDataSetColumnName()
        {
            return new string[]
            {
                "ORDER_NO",
                "CUSTOMER_NO",
                "CUSTOMER_NM",
                "MNY_ASK_TYP",
                "FORECORPCODE",
                "FORECORPNAME",
                "ORDER_WGT",
                "INPUT_WGT",
                "ORDER_MNY_TAX",
                "PRICE_FL",
                "ADVANCESCALE",
                "ADVANCEMONEY",
                "SIGN_DATE",
                "MNY_ASK_TYP",
                "ISIMPORTORDER",
                "ISDEV",
                "ISOUT",
                "ORDER_BDATE",
                "ORDER_EDATE",
                "CREATE_NAME",
                "CREATE_TIME",
                "APPROVAL_MAN",
                "APPROVAL_TIME",
                "MEMO"
            };
        }


        protected string[] GetTbSlmOrderLineDataSetColumnName()
        {
            return new string[]
            {
                 //"ORDER_NO",
                 //"ORDER_SEQ",
                 //"HEIGHT",
                 //"WIDTH",
                 //"LENGTH",
                 //"ORDER_QTY",
                 //"WEIGHT",
                 //"ORDER_PRICE",
                 //"FIXSIZE",
                 //"WIDTH_MIN",
                 //"WIDTH_MAX",
                 //"LEN_MIN",
                 //"LEN_MAX",
                 //"NUCLEARSTEEL",
                 //"KHIC",
                 //"ISPOSTER",
                 //"ORDER_SPECIAL_FL",
                 //"VALIDFLAG",
                 //"DELVRY_BDATE",
                 //"DELVRY_EDATE",
                 //"DELVRY_DATE",
                 //"MEMO",

                 //"PROD_LINE",
                 //"SPEC_ABBSYM",
                 //"STEEL_CODE",
                 //"USED_CD",
                 //"PRDNM_CD",

                 //"TRANSIT_TYP",
                 //"REGION_NO",
                 //"DESTINATION",
                 //"SPCL_LN_NO",
                 //"ISOWNEDCAR",
                 //"PORT_NO",
                 //"INCEPTCORPCODE",
                 //"REINCEPTCORP",
                 //"CREATE_NAME",
                 //"CREATE_TIME",
                 //"UPDATE_NAME",
                 //"UPDATE_TIME",
                 //"DELETE_NAME",
                 //"DELETE_TIME"

                "ORDER_NO",
                "ORDER_SEQ",
                "PROD_LINE",
                "STEEL_CODE",
                "USED_CD",
                "PRDNM_CD",
                "SPEC_ABBSYM",
                "ISALPHA",
                "HEIGHT",
                "WIDTH",
                "LENGTH",
                "ORDER_PRICE",
                "ORDER_QTY",      
                "WEIGHT",
                "ORD_SEND_WGT",
                "ORD_INVOICE_WGT",
                "FIXSIZE",
                "LEN_MIN",
                "LEN_MAX",
                "WIDTH_MIN",
                "WIDTH_MAX",
                "SENDSTATUS",
                "ORDER_UNIT",
                "SPCL_LN_NO",
                "PRI",
                       
                "DELVRY_RANGE_TPE",
                "DELVRY_RANGE_MIN",
                "DELVRY_RANGE_MAX",
                "ORDER_SPECIAL_FL",
                "TRANSIT_TYP",
                "DESTINATION",
                "DELVRY_BDATE",
                "DELVRY_EDATE",
                "DELVRY_DATE",
                "REGION_NO",
                "STATION_NO",
                "STATION_NM",
                "ISOWNEDCAR",
                "ISSHIPPING",
                "PORT_NO",
                "INCEPTCORPCODE",
                "REINCEPTCORP",
                "ISWELDED_HEAT",
                "NUCLEARSTEEL",
                "KHIC",
                "ISPOSTER",
                "FINAL_USER",
                "FINAL_USER_DESC",
                "QUALITY_DESIGH_RESULT",
                "QUALITY_DESIGH_ERRMSG",
                "QUALITY_DESIGH_NAME",
                "QUALITY_DESIGH_DATE",
                "ZBS",
                "TRANS_PRICE",
                "TEST_ID",
                "TEST_PRICE",
                "OUT_PRICE",
                "BALNCE_PRICE",
                "ORDER_LN_STATUS",
                "REVIEW_STATUS",
                "REVIEW_MSG",
                "REVIEW_DATE",
                "REVIEW_ENTRYDATE",
                "MEMO",
                "VALIDFLAG",
                "CREATE_NAME",
                "CREATE_TIME",
                "UPDATE_NAME",
                "UPDATE_TIME",
                "DELETE_NAME",
                "DELETE_TIME"
            };
        }
        #endregion

        protected System.Drawing.Color GetEditColor()
        {
            return Color.FromArgb(255, 255, 128);
        }



        protected Hashtable ConvertListStringArrayToHashTable(List<string[]> list)
        {
            Hashtable hs = new Hashtable();
            if (list == null || list.Count == 0)
                return hs;
            foreach (string[] s in list)
            {
                if (hs.ContainsKey(s[0]))
                {
                    hs.Remove(s[0]);
                }
                hs.Add(s[0],s[1]);
            }
            return hs;
        }


    }


   

   
}