XinYu_LG2MES/ClientSolution/Core.Mes.Client.Common/ClientBaseOperate.cs

using System;
using System.Data;
using System.Collections;
using System.Drawing;
using System.Windows.Forms;

using Infragistics.Win;
using Infragistics.Win.Misc;
using Infragistics.Win.UltraWinEditors;
using Infragistics.Win.UltraWinGrid;
using Infragistics.Win.UltraWinTabControl;
using Infragistics.Win.UltraWinToolbars;
using Core.Mes.ClientFrameWork;

namespace Core.Mes.Client.Common
{
    /// <summary>
    /// ClientBaseOperate 的摘要说明。�
    /// </summary>
    public class ClientBaseOperate
    {
        public ClientBaseOperate()
        {
            //
            //TODO: 在此处添加构造函数逻辑���߼�
            //

        }

        //�޸修改操作，带返回值
        public StructBaseOperateResult Edit_Result(string strAssembly, string strMethod, object[] objs)
        {
            string strOut = "";
            object rtnObj = ClientCommon._RemotingHelp.ExecuteMethod("SaleServer",
                strAssembly, strMethod, objs, out strOut);

            StructBaseOperateResult sbor = new StructBaseOperateResult();
            if (strOut != "")
            {
                sbor.vFlag = false;
                MessageBox.Show(strOut);
                return sbor;
            }
            sbor.vMessage = (rtnObj as ArrayList)[1].ToString();
            sbor.vFlag = true;
            sbor.vOutlist = rtnObj;

            return sbor;
        }
        //erp
        public void Erp_Call(object[] objs)
        {
            string strOut = "";
            object rtnObj = ClientCommon._RemotingHelp.ExecuteMethod("ServerPlanManager",
                "Core.CgMes.ServerPlanManger", "ManuStartInterFace", objs, out strOut);
            if (strOut != "")
            {
                MessageBox.Show(strOut);
                return;
            }
        }
        //查询操作���
        private StructBaseOperateResult Query_Result(string strAssembly, string strMethod, object[] objs)
        {
            string strOut = "";
            DataSet rtnObj = ClientCommon._RemotingHelp.ExecuteMethod("SaleServer",
                strAssembly, strMethod, objs, out strOut) as DataSet;

            StructBaseOperateResult sbor = new StructBaseOperateResult();
            if (strOut != "")
            {
                sbor.vFlag = false;
                MessageBox.Show(strOut);
                return sbor;
            }

            sbor.vFlag = true;
            rtnObj.Tables[0].TableName = "dtMain";
            sbor.vDataSet = rtnObj;
            return sbor;
        }
        //查询操作���
        private StructBaseOperateResult Query_Result(string strAssembly, string strClass, string strMethod, object[] objs)
        {
            string strOut = "";
            DataSet rtnObj = ClientCommon._RemotingHelp.ExecuteMethod(strAssembly,
                strClass, strMethod, objs, out strOut) as DataSet;

            StructBaseOperateResult sbor = new StructBaseOperateResult();
            if (strOut != "")
            {
                sbor.vFlag = false;
                MessageBox.Show(strOut);
                return sbor;
            }

            sbor.vFlag = true;
            rtnObj.Tables[0].TableName = "dtMain";
            sbor.vDataSet = rtnObj;
            return sbor;
        }
        //基本查询
        public StructBaseOperateResult CommonQueryOperate(string vID_, string[] vParameter)
        {
            return Query_Result("Core.CgMes.XS1.Server.SaleCommonOperate", "Select_DataSet",
                new object[] { vID_, vParameter });
        }
        //显示报表SQL
        public string Query_Rpt_Sql(string vID_)
        {
            string strOut = "";
            string sqlstr = "";
            object rtnObj = ClientCommon._RemotingHelp.ExecuteMethod("SaleServer", "Core.CgMes.XS1.Server.SaleCommonOperate",
                "Get_Common_Sqlstr_rpt", new object[] { vID_ }, out strOut);
            if (rtnObj != null)
            {
                sqlstr = rtnObj.ToString();
            }
            if (strOut != "")
            {
                MessageBox.Show(strOut);
                return "";
            }
            return sqlstr;
        }

        //直接执行SQL语句
        public DataSet ExecuteSql(string sqlstr)
        {
            string strOut = "";
            object[] objs = new object[] { sqlstr };
            object rtnObj = ClientCommon._RemotingHelp.ExecuteMethod("SaleServer",
                "Core.CgMes.XS1.Server.SaleCommonOperate", "ExecuteSql", objs, out strOut);
            if (strOut != "")
            {
                MessageBox.Show(strOut);
            }
            return rtnObj as DataSet;
        }
        public void ExecuteOpeSql(string sqlstr)
        {
            string strOut = "";
            object[] objs = new object[] { sqlstr };
            object rtnObj = ClientCommon._RemotingHelp.ExecuteMethod("SaleServer",
                "Core.CgMes.XS1.Server.SaleCommonOperate", "ExecuteOpeSql", objs, out strOut);
            if (strOut != "")
            {
                MessageBox.Show(strOut);
            }
        }
        //连带绑定的查询
        /// <summary>
        /// 直接绑定到DATASET的查询(可以指定TABLE)
        /// </summary>
        /// <param name="ds"></param>
        /// <param name="vID_"></param>
        /// <param name="vParameter"></param>
        public void CommonQueryOperate_bind(DataSet ds,string vID_, string[] vParameter)
        {
            StructBaseOperateResult sbor = CommonQueryOperate(vID_, vParameter);
            if (!sbor.vFlag) { return; }
            ds.Clear();
            sbor.vDataSet.Tables[0].TableName = ds.Tables[0].TableName;
            ds.EnforceConstraints = false;
            ds.Merge(sbor.vDataSet.Tables[0]);
            ds.AcceptChanges();
        }
        public void CommonExecuteQuery_bind(DataSet ds, string vSql, string[] vParameter)
        {
            string strOut = "";
            object[] objs = new object[] { vSql };
            object rtnObj = ClientCommon._RemotingHelp.ExecuteMethod("SaleServer",
                "Core.CgMes.XS1.Server.SaleCommonOperate", "ExecuteSql", objs, out strOut);
            if (strOut != "")
            {
                MessageBox.Show(strOut);
            }
            DataSet dsreslut =  rtnObj as DataSet;
            ds.Clear();
            dsreslut.Tables[0].TableName = ds.Tables[0].TableName;
            ds.EnforceConstraints = false;
            ds.Merge(dsreslut.Tables[0]);
            ds.AcceptChanges();
        }
        /// <summary>
        /// 直接绑定到DATASET
        /// </summary>
        /// <param name="ds"></param>
        /// <param name="i"></param>
        /// <param name="vID_"></param>
        /// <param name="vParameter"></param>
        public void CommonQueryOperate_bind(DataSet ds,int i,string vID_, string[] vParameter)
        {
            StructBaseOperateResult sbor = CommonQueryOperate(vID_, vParameter);
            if (!sbor.vFlag) { return; }
            if (i == 0)
            {
                ds.Clear();
            }
            else
            {
                ds.Tables[i].Clear();
            }
            sbor.vDataSet.Tables[0].TableName = ds.Tables[i].TableName;
            ds.Merge(sbor.vDataSet.Tables[0]);
            ds.AcceptChanges();
        }
        /// <summary>
        ///  代提示，带判断的基本操作
        /// </summary>
        /// <param name="vID_"></param>
        public void CommonEdit_Result(string vID_)
        {
            string strOut = "";
            object[] objs = new object[] { vID_ };
            object rtnObj = ClientCommon._RemotingHelp.ExecuteMethod("SaleServer",
                "Core.CgMes.XS1.Server.SaleCommonOperate", "Exec_CommonOperate0", objs, out strOut);
            if (strOut != "")
            {
                MessageBox.Show(strOut);
            }
        }
        public void CommonEdit_Result(object[] objs, string Message)
        {
            StructBaseOperateResult sbor = Edit_Result("Core.CgMes.XS1.Server.SaleCommonOperate",
                    "Exec_CommonOperate", objs);
            if (Convert.ToInt32((sbor.vOutlist as ArrayList)[0]) == -1)
            {
                MessageBox.Show((sbor.vOutlist as ArrayList)[1].ToString(), "提示", MessageBoxButtons.OK);
                return;
            }
            else
            {
                if (Convert.ToString((sbor.vOutlist as ArrayList)[1]) != "")
                {
                    MessageBox.Show((sbor.vOutlist as ArrayList)[1].ToString(), "提示", MessageBoxButtons.OK);
                }
                else
                {
                    MessageBox.Show(Message);
                }
            }
        }
        public void CommonEdit_Result2(object[] objs, string Message)
        {
            StructBaseOperateResult sbor = Edit_Result("Core.CgMes.XS1.Server.SaleCommonOperate",
                    "Exec_CommonOperate2", objs);
            if (Convert.ToInt32((sbor.vOutlist as ArrayList)[0]) == -1)
            {
                MessageBox.Show((sbor.vOutlist as ArrayList)[1].ToString(), "提示", MessageBoxButtons.OK);
                return;
            }
            else
            {
                if (Convert.ToString((sbor.vOutlist as ArrayList)[1]) != "")
                {
                    MessageBox.Show((sbor.vOutlist as ArrayList)[1].ToString(), "提示", MessageBoxButtons.OK);
                }
                else
                {
                    MessageBox.Show(Message);
                }
            }
        }
        public void CommonEdit_Result3(object[] objs, string Message)
        {
            StructBaseOperateResult sbor = Edit_Result("Core.CgMes.XS1.Server.SaleCommonOperate",
                    "Exec_CommonOperate3", objs);
            if (Convert.ToInt32((sbor.vOutlist as ArrayList)[0]) == -1)
            {
                MessageBox.Show((sbor.vOutlist as ArrayList)[1].ToString(), "提示", MessageBoxButtons.OK);
                return;
            }
            else
            {
                if (Convert.ToString((sbor.vOutlist as ArrayList)[1]) != "")
                {
                    MessageBox.Show((sbor.vOutlist as ArrayList)[1].ToString(), "提示", MessageBoxButtons.OK);
                }
                else
                {
                    MessageBox.Show(Message);
                }
            }
        }
        public void CommonEdit_Result4(object[] objs, string Message)
        {
            StructBaseOperateResult sbor = Edit_Result("Core.CgMes.XS1.Server.SaleCommonOperate",
                    "Exec_CommonOperate4", objs);
            if (Convert.ToInt32((sbor.vOutlist as ArrayList)[0]) == -1)
            {
                MessageBox.Show((sbor.vOutlist as ArrayList)[1].ToString(), "提示", MessageBoxButtons.OK);
                return;
            }
            else
            {
                if (Convert.ToString((sbor.vOutlist as ArrayList)[1]) != "")
                {
                    MessageBox.Show((sbor.vOutlist as ArrayList)[1].ToString(), "提示", MessageBoxButtons.OK);
                }
                else
                {
                    MessageBox.Show(Message);
                }
            }
        }
        public void CommonEdit_Result5(object[] objs, string Message)
        {
            StructBaseOperateResult sbor = Edit_Result("Core.CgMes.XS1.Server.SaleCommonOperate",
                    "Exec_CommonOperate5", objs);
            if (Convert.ToInt32((sbor.vOutlist as ArrayList)[0]) == -1)
            {
                MessageBox.Show((sbor.vOutlist as ArrayList)[1].ToString(), "提示", MessageBoxButtons.OK);
                return;
            }
            else
            {
                if (Convert.ToString((sbor.vOutlist as ArrayList)[1]) != "")
                {
                    MessageBox.Show((sbor.vOutlist as ArrayList)[1].ToString(), "提示", MessageBoxButtons.OK);
                }
                else
                {
                    MessageBox.Show(Message);
                }
            }
        }
        //自动多提示
        public void CommonEdit_Result(object[] objs)
        {
            string message = "";
            StructBaseOperateResult sbor = Edit_Result("Core.CgMes.XS1.Server.SaleCommonOperate",
                    "Exec_CommonOperate", objs);
            if (Convert.ToInt32((sbor.vOutlist as ArrayList)[0]) == -1)
            {
                MessageBox.Show((sbor.vOutlist as ArrayList)[1].ToString(), "提示", MessageBoxButtons.OK);
                return;
            }
            else
            {
                String[] ms = (sbor.vOutlist as ArrayList)[1].ToString().Split('@');
                if (ms.Length == 0)
                {
                    ms[0] = (sbor.vOutlist as ArrayList)[1].ToString();
                }
                for (int i = 0; i < ms.Length; i++)
                {
                    if (ms[0].ToString() == "")
                    {
                        MessageBox.Show("操作成功!");
                        return;
                    }
                    else
                    {
                        message += ms[i].ToString() + "\n";
                    }
                }
                MessageBox.Show(message);
            }
        }
        /// <summary>
        /// 返回客户端问询是否继续操作的修改
        /// </summary>
        /// <param name="objs"></param>
        /// <param name="revlaueindex"></param>
        /// <param name="Message"></param>
        /// 

        public void CommonEdit_Result(object[] objs, int revlaueindex, string Message)
        {
            string strOut = "";
            object rtnObj = ClientCommon._RemotingHelp.ExecuteMethod("SaleServer",
                "Core.CgMes.XS1.Server.SaleCommonOperate", "Exec_CommonOperate",objs, out strOut);
            if (strOut != "")
            {
                MessageBox.Show(strOut);
            }
            if (Convert.ToInt32((rtnObj as ArrayList)[0]) == -1)
            {
                MessageBox.Show((rtnObj as ArrayList)[1].ToString(), "提示", MessageBoxButtons.OK);
                return;
            }
            else
            {
                if (Convert.ToInt32((rtnObj as ArrayList)[0]) == 0)
                {
                    if (MessageBox.Show((rtnObj as ArrayList)[1].ToString(), "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
                    {
                        ((string[])objs[1])[revlaueindex] = "1";
                        CommonEdit_Result(objs, revlaueindex, Message);
                        return;
                    }
                    else
                    {
                        return;
                    }

                }
                MessageBox.Show(Message);
            }
 
        }
        public string[] GetSelectRow(UltraGrid ug,string Column)
        {
            ug.UpdateData();
            ArrayList ar = new ArrayList();
            foreach (UltraGridRow ugr in ug.Rows)
            {
                if (Convert.ToBoolean(ugr.Cells["CHECK"].Value.ToString()))
                {
                    ar.Add(ugr.Cells[Column].Value.ToString());
                }
            }
            string[] strs = new string[ar.Count];
            for (int i = 0; i < ar.Count; i++)
            {
                strs[i] = ar[i].ToString();
            }
            return strs;
        }
        //忽略分组的取GRID选择字段数据
        /// <summary>
        /// 获取忽略分组的选中数据(不带起始索引)
        /// </summary>
        /// <param name="ugr"></param>
        /// <param name="ar"></param>
        /// <param name="Column"></param>
        /// <returns></returns>
        public string[] GetSelectColumnItems(UltraGrid ug, ArrayList ar, string Column)
        {
            for (int i = 0; i < ug.Rows.Count; i++)
            {
                CheckIsGroupByRow(ug.Rows[i], ar, Column);
            }
            string[] strs = new string[ar.Count];
            for (int i = 0; i < ar.Count; i++)
            {
                strs[i] = ar[i].ToString();
            }
            return strs;
        }
        //忽略分组指定起始INDEX的取GRID的选择字段数据
        /// <summary>
        /// 获取忽略分组的选中数据(带起始索引)
        /// </summary>
        /// <param name="ugr"></param>
        /// <param name="ar"></param>
        /// <param name="Column"></param>
        /// <param name="start"></param>
        /// <returns></returns>
        public string[] GetSelectColumnItems(UltraGrid ug, ArrayList ar, string Column,int start)
        {
            for (int i = 0; i < ug.Rows.Count; i++)
            {
                CheckIsGroupByRow(ug.Rows[i], ar, Column);
            }
            string[] strs = new string[ar.Count];
            for (int i = 0; i < ar.Count; i++)
            {
                strs[i + start] = ar[i].ToString();
            }
            return strs;
        }
        private void CheckIsGroupByRow(UltraGridRow ugr, ArrayList ar,string column)
        {
            if (ugr is UltraGridGroupByRow)
            {
                foreach (UltraGridRow ugrc in ugr.ChildBands[0].Rows)
                {
                    CheckIsGroupByRow(ugrc, ar, column);
                }
            }
            else
            {
                if (Convert.ToBoolean(ugr.Cells["CHECK"].Value.ToString()))
                {
                    ar.Add(ugr.Cells[column].Value.ToString());
                }
            }
        }
        //分组
        public void SetGroupBy(CheckBox chk, UltraGrid ug)
        {
            if (chk.Checked)
            {
                ug.DisplayLayout.Override.AllowGroupBy = DefaultableBoolean.True;
                ug.DisplayLayout.GroupByBox.Hidden = false;
            }
            else
            {
                ug.DisplayLayout.Override.AllowGroupBy = DefaultableBoolean.False;
                ug.DisplayLayout.GroupByBox.Hidden = true;
                ug.DisplayLayout.Bands[0].SortedColumns.Clear();
            }
        }
        //过滤
        public void SetFilter(CheckBox chk, UltraGrid ug)
        {
            if (chk.Checked)
            {
                ug.DisplayLayout.Override.FilterUIType = FilterUIType.FilterRow;
            }
            else
            {
                ug.DisplayLayout.Bands[0].ColumnFilters.ClearAllFilters();
                ug.DisplayLayout.Override.FilterUIType = FilterUIType.Default;
            }
        }
        public void SetToolBarStyle(UltraToolbarsManager utm)
        {
            utm.LockToolbars = true;
            utm.MdiMergeable = false;
            utm.ShowQuickCustomizeButton = false;
            utm.Style = ToolbarStyle.VisualStudio2005;
            foreach (ButtonTool bt in utm.Tools)
            {
                if (bt.Key == "query")
                {
                    bt.SharedProps.Shortcut = Shortcut.F1;
                    bt.SharedProps.Caption = "查询";
                }
            }
        }
        public bool IsNumber(string str)
        {
            if (str.Equals(String.Empty)) return true;
            try
            {
                Convert.ToSingle(str);
            }
            catch
            {
                return false;
            }
            return true;
        }
        public Decimal GetDecimal(object obj)
        {
            if (obj == null || obj == DBNull.Value) return 0;

            Decimal rtnObj = 0;

            try
            {
                rtnObj = Convert.ToDecimal(obj);
            }
            catch
            {
                rtnObj = 0;
            }
            return rtnObj;

        }
        public bool CheckOpeDataNULL(UltraExpandableGroupBoxPanel ugp)
        {
            foreach (Control ctrl in ugp.Controls)
            {
                if (ctrl is UltraTextEditor && ctrl.ToString().IndexOf("UltraTextEditor") > 0)
                {
                    if ((ctrl as UltraTextEditor).Text.Trim() == "")
                    {
                        MessageBox.Show(string.Format("请录入{0}", (ctrl as UltraTextEditor).StyleSetName));
                        return false;
                    }
                }
                if (ctrl is UltraNumericEditor && ctrl.ToString().IndexOf("UltraNumericEditor") > 0)
                {
                    if ((ctrl as UltraNumericEditor).Text.Trim() == ".")
                    {
                        MessageBox.Show(string.Format("请录入{0}", (ctrl as UltraNumericEditor).NullText));
                        return false;
                    }
                }
                if (ctrl is ComboBox && ctrl.ToString().IndexOf("ComboBox") > 0)
                {
                    if ((ctrl as ComboBox).SelectedValue.ToString() == "")
                    {
                        MessageBox.Show(string.Format("请选择{0}", (ctrl as ComboBox).Tag));
                        return false;
                    }
                }
            }
            return true;
        }
        
        /// <summary>
        /// 设置GRID样式
        /// </summary>
        /// <param name="ulgrid"></param>
        public void SetUltraGridStyle(UltraGrid ulgrid)
        {
            ulgrid.DisplayLayout.GroupByBox.Hidden = true;
            ulgrid.DisplayLayout.ScrollBounds = Infragistics.Win.UltraWinGrid.ScrollBounds.ScrollToFill;
            ulgrid.DisplayLayout.CaptionVisible = DefaultableBoolean.False;
            ulgrid.DisplayLayout.ScrollStyle = Infragistics.Win.UltraWinGrid.ScrollStyle.Immediate;
            ulgrid.DisplayLayout.MaxColScrollRegions = 2;
            ulgrid.DisplayLayout.MaxRowScrollRegions = 2;
            ulgrid.DisplayLayout.Override.HeaderClickAction = HeaderClickAction.SortMulti;
            ulgrid.DisplayLayout.UseFixedHeaders = true;
            ulgrid.DisplayLayout.Override.FixedHeaderIndicator = FixedHeaderIndicator.None;
            //ulgrid.DisplayLayout.Override.BorderStyleCell = Infragistics.Win.UIElementBorderStyle.RaisedSoft;
            ulgrid.DisplayLayout.Override.HeaderAppearance.TextHAlign = Infragistics.Win.HAlign.Center;
            ulgrid.DisplayLayout.Override.HeaderStyle = Infragistics.Win.HeaderStyle.Standard;
            ulgrid.DisplayLayout.Override.MinRowHeight = 21;
            //ulgrid.DisplayLayout.Override.RowSelectorHeaderStyle = Infragistics.Win.UltraWinGrid.RowSelectorHeaderStyle.SeparateElement;
            ulgrid.DisplayLayout.Override.RowSelectorNumberStyle = Infragistics.Win.UltraWinGrid.RowSelectorNumberStyle.RowIndex;
            ulgrid.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.True;
            ulgrid.DisplayLayout.Override.CellAppearance.TextHAlign = HAlign.Center;
            ulgrid.Font = new System.Drawing.Font("宋体", 9F);
            ulgrid.DisplayLayout.Appearance.FontData.SizeInPoints = 9;
            ulgrid.DisplayLayout.GroupByBox.Prompt = "可以选择需要统计的列拖放到此处，系统将自动按该列统计!可以拖放多列分层";
            ulgrid.DisplayLayout.Override.SummaryValueAppearance.BackColor = Color.LightPink;
            if (ulgrid.DisplayLayout.Bands.Count == 1)
            {
                ulgrid.DisplayLayout.Override.HeaderAppearance.BackColor = System.Drawing.Color.LightSteelBlue;
                ulgrid.DisplayLayout.Override.RowSelectorAppearance.BackColor = System.Drawing.Color.LightSteelBlue;
                ulgrid.DisplayLayout.Override.RowAlternateAppearance.BackColor = Color.GhostWhite;
            }
            else if (ulgrid.DisplayLayout.Bands.Count == 2)
            {
                ulgrid.DisplayLayout.Bands[0].Override.HeaderAppearance.BackColor = System.Drawing.Color.LightSteelBlue;
                ulgrid.DisplayLayout.Bands[0].Override.RowSelectorAppearance.BackColor = System.Drawing.Color.LightSteelBlue;
                ulgrid.DisplayLayout.Bands[0].Override.RowAppearance.BackColor = Color.LightGray;

                ulgrid.DisplayLayout.Bands[1].Override.HeaderAppearance.BackColor = Color.FromArgb(233, 242, 199);
                ulgrid.DisplayLayout.Bands[1].Override.HeaderAppearance.BackColor2 = Color.FromArgb(170, 184, 131);
                ulgrid.DisplayLayout.Bands[1].Override.HeaderAppearance.BackGradientStyle = Infragistics.Win.GradientStyle.Vertical;

                ulgrid.DisplayLayout.Bands[1].Override.RowSelectorAppearance.BackColor = Color.FromArgb(233, 242, 199);
                ulgrid.DisplayLayout.Bands[1].Override.RowSelectorAppearance.BackColor2 = Color.FromArgb(170, 184, 131);
                ulgrid.DisplayLayout.Bands[1].Override.RowSelectorAppearance.BackGradientStyle = Infragistics.Win.GradientStyle.Vertical;

                ulgrid.DisplayLayout.Bands[1].Override.RowAppearance.BorderColor = Color.FromArgb(170, 184, 131);
            }
            foreach (UltraGridBand ugb in ulgrid.DisplayLayout.Bands)
            {
                foreach (UltraGridColumn ugc in ugb.Columns)
                {
                    switch (ugc.Key.ToUpper())
                    {
                        case "CHECK":
                            ugc.Header.Caption = "选择";
                            ugc.Width = 20;
                            ugc.DataType = typeof(Boolean);
                            break;
                        case "OVERMONEY":
                            ugc.Header.Caption = "溢短装金额";
                            ugc.Format = "C";
                            ugc.Width = 50;
                            break;
                        case "PRI":
                            ugc.Header.Caption = "优先级";
                            ugc.ValueList = PublicStaticVariable.Static_BaseData("优先级").ValueListDB;
                            ugc.Width = 50;
                            break;
                        case "SAMPLINGREQUEST":
                            ugc.Header.Caption = "取样要求";
                            ugc.ValueList = PublicStaticVariable.Static_BaseData("取样要求").ValueListDB;
                            ugc.Width = 50;
                            break;
                        case "TRANSTYPE":
                            ugc.Header.Caption = "运输方式";
                            ugc.ValueList = PublicStaticVariable.Static_BaseData("运输方式").ValueListDB;
                            ugc.Width = 50;
                            break;
                        case "PACTTYPECODE":
                            ugc.Header.Caption = "订单性质";
                            ugc.ValueList = PublicStaticVariable.Static_BaseData("订单性质").ValueListDB;
                            ugc.Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
                            break;
                        case "BALANCETYPE":
                            ugc.Header.Caption = "结算方式";
                            ugc.ValueList = PublicStaticVariable.Static_BaseData("结算方式").ValueListDB;
                            ugc.Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
                            break;
                        case "ISLOCKPRICE":
                            ugc.Header.Caption = "是否定价";
                            ugc.ValueList = PublicStaticVariable.Static_YesOrNo_1().ValueListDB;
                            ugc.Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
                            break;
                        case "JDDJ":
                            ugc.Header.Caption = "精度等级";
                            ugc.ValueList = PublicStaticVariable.Static_BaseData("6053").ValueListDB;
                            ugc.Width = 70;
                            break;
                        case "ISNEWPACT":
                            ugc.Header.Caption = "研发";
                            ugc.ValueList = PublicStaticVariable.Static_YesOrNo_1().ValueListDB;
                            ugc.Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
                            ugc.Width = 35;
                            break;
                        case "ISOUTPACT":
                            ugc.Header.Caption = "出口";
                            ugc.ValueList = PublicStaticVariable.Static_YesOrNo_1().ValueListDB;
                            ugc.Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
                            ugc.Width = 35;
                            break;
                        case "FIXSIZE":
                            ugc.Header.Caption = "定尺方式";
                            ugc.ValueList = PublicStaticVariable.Static_BaseData("定尺方式").ValueListDB;
                            ugc.Width = 50;
                            break;
                        case "PRICE":
                            ugc.Format = "C";
                            ugc.Width = 70;
                            ugc.Header.Caption = "单价";
                            ugc.Band.Summaries.Add(SummaryType.Average, ugc, SummaryPosition.UseSummaryPositionColumn);
                            break;
                        case "HEIGHT":
                            ugc.Header.Caption = "厚度";
                            break;
                        case "WIDTH":
                            ugc.Header.Caption = "宽度";
                            break;
                        case "ADVANCESCALE":
                            ugc.Header.Caption = "预付比例";
                            ugc.Format = "P";
                            ugc.Width = 60;
                            break;
                        case "BUYERCODE":
                            ugc.Header.Caption = "客户名称";
                            ugc.ValueList = PublicStaticVariable.Static_BuyerCode_FcAr(false).ValueListDB;
                            ugc.Width = 180;
                            break;
                        case "CHECKORG":
                            ugc.Header.Caption = "检验机构";
                            ugc.ValueList = PublicStaticVariable.Static_BaseData("检验机构").ValueListDB;
                            ugc.Width = 60;
                            break;
                        case "STATIONCODE":
                            ugc.Header.Caption = "到站";
                            ugc.ValueList = PublicStaticVariable.Static_StationCode(true).ValueListDB;
                            ugc.Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
                            ugc.Width = 50;
                            break;
                        case "PACTNO":
                            ugc.Header.Caption = "订单号";
                            ugc.Width = 100;
                            break;
                        case "TRAINPLANNO":
                            ugc.Header.Caption = "发运计划号";
                            ugc.Width = 90;
                            break;
                        case "FORECORPCODE":
                            ugc.Header.Caption = "驻外公司";
                            ugc.ValueList = PublicStaticVariable.Static_BaseData("驻外公司").ValueListDB;
                            ugc.Width = 70;
                            break;
                        case "SENDSTATUS":
                            ugc.Header.Caption = "交货状态";
                            ugc.ValueList = PublicStaticVariable.Static_BaseData("交货状态分类").ValueListDB;
                            ugc.Width = 60;
                            break;
                        case "INCEPTCORPCODE":
                            ugc.Header.Caption = "收货单位";
                            ugc.ValueList = PublicStaticVariable.Static_InceptCorp(true).ValueListDB;
                            ugc.Width = 180;
                            break;
                        case "SENDTYPE":
                            ugc.Header.Caption = "定量方式";
                            ugc.ValueList = PublicStaticVariable.Static_BaseData("定量方式").ValueListDB;
                            ugc.Width = 40;
                            break;
                        case "PURPOSEID":
                            ugc.Header.Caption = "产品用途";
                            ugc.ValueList = PublicStaticVariable.Static_BaseData("产品用途").ValueListDB;
                            ugc.Width = 40;
                            break;
                        case "LEASEDLINE":
                            ugc.Header.Caption = "专用线";
                            ugc.ValueList = PublicStaticVariable.Static_BaseData("专用线").ValueListDB;
                            ugc.Width = 50;
                            break;
                        case "CATEGORY":
                            ugc.Header.Caption = "钢种";
                            ugc.ValueList = PublicStaticVariable.Static_BaseData("牌号分类").ValueListDB;
                            ugc.Width = 120;
                            break;
                        case "STEELCODE":
                            ugc.Header.Caption = "牌号";
                            ugc.ValueList = PublicStaticVariable.Static_SteelName(true).ValueListDB;
                            break;
                        case "SENDENDDATE":
                            ugc.Header.Caption = "交货结束日期";
                            break;
                        case "PERSON":
                            ugc.ValueList = PublicStaticVariable.Static_UserName(false).ValueListDB;
                            break;
                        case "ASKPLAN_ID":
                            ugc.Header.Caption = "请车号";
                            break;
                        case "F_ASKPLAN_ID":
                            ugc.Header.Caption = "请车批车号";
                            break;
                        case "VEHICLEPLANNO":
                            ugc.Header.Caption = "运输号码";
                            break;
                        case "INPUTPERSON":
                            ugc.Header.Caption = "录入人";
                            ugc.ValueList = PublicStaticVariable.Static_UserName(true).ValueListDB;
                            break;
                        case "WEIGHT":
                            ugc.Header.Caption = "重量";
                            ugc.Width = 55;
                            break;
                        case "QUANTITY":
                            ugc.Header.Caption = "卷(块)数";
                            ugc.Width = 55;
                            break;
                        case "USEDSTAND":
                            ugc.Header.Caption = "标准";
                            ugc.ValueList = PublicStaticVariable.Static_STD_ID(true).ValueListDB;
                            ugc.Width = 60;
                            break;
                        case "TRAINTYPE":
                            ugc.Header.Caption = "车种";
                            ugc.ValueList = PublicStaticVariable.Static_BaseData("车种").ValueListDB;
                            ugc.Width = 40;
                            break;
                        case "LOADPOSITION":
                            ugc.Header.Caption = "装车地点";
                            ugc.ValueList = PublicStaticVariable.Static_BaseData("装车地点").ValueListDB;
                            ugc.Width = 50;
                            break;
                        case "FIXTYPE":
                            ugc.Header.Caption = "装车方式";
                            ugc.ValueList = PublicStaticVariable.Static_BaseData("装车方式").ValueListDB;
                            ugc.Width = 60;
                            break;
                        case "INPUTTIME":
                            ugc.Header.Caption = "录入时间";
                            break;
                        case "IMPORTTIME":
                            ugc.Header.Caption = "录入时间";
                            break;
                        case "PLANDATE":
                            ugc.Header.Caption = "计划日期";
                            break;
                        case "CARAFFIRM":
                            ugc.Hidden = true;
                            break;
                        case "AFFIRMSTATUS":
                            ugc.Hidden = true;
                            break;
                        case "ISMIXED":
                            ugc.Hidden = true;
                            break;
                        case "REMARK":
                            ugc.Header.Caption = "备注";
                            break;
                        case "MOTORMANNAME":
                            ugc.Header.Caption = "承运单位";
                            ugc.Width = 80;
                            break;
                        case "DRIVERIDCARD":
                            ugc.Header.Caption = "身份证号";
                            ugc.Width = 70;
                            break;
                        case "PHONECODE":
                            ugc.Header.Caption = "电话号码";
                            ugc.Width = 60;
                            break;
                        case "TRANWAGON":
                            ugc.Header.Caption = "车号";
                            ugc.Width = 60;
                            break;
                        case "SENDWEIGHT":
                            ugc.Header.Caption = "发运重量";
                            ugc.Width = 60;
                            break;
                        //结算
                        case "INOUTTYPE":
                            ugc.Header.Caption = "出入类型";
                            ugc.Width = 60;
                            ugc.ValueList = PublicStaticVariable.Static_BaseData("2078").ValueListDB;
                            break;
                        case "PIAOTYPE":
                            ugc.Header.Caption = "票据类型";
                            ugc.Width = 60;
                            ugc.ValueList = PublicStaticVariable.Static_BaseData("2084").ValueListDB;
                            break;
                        case "PDVALIDITY":
                            ugc.Header.Caption = "承兑期限";
                            ugc.Width = 60;
                            ugc.ValueList = PublicStaticVariable.Static_BaseData("2085").ValueListDB;
                            break;
                        case "SHAPCODE":
                            ugc.Header.Caption = "产品形态";
                            ugc.Width = 60;
                            ugc.ValueList = PublicStaticVariable.Static_BaseData("1002").ValueListDB;
                            break;
                        case "BILLNO":
                            ugc.Header.Caption = "票号";
                            ugc.Width = 50;
                            break;
                        case "ISEXAIME":
                            ugc.Header.Caption = "是否审批";
                            ugc.Width = 60;
                            ugc.ValueList = PublicStaticVariable.Static_YesOrNo_1().ValueListDB;
                            break;
                        case "ISBEGINBALANCE":
                            ugc.Header.Caption = "开始结算";
                            ugc.ValueList = PublicStaticVariable.Static_YesOrNo_1().ValueListDB;
                            ugc.Width = 60;
                            break;
                        case "HONOURBEDATE":
                            ugc.Header.Caption = "开始日期";
                            break;
                        case "HONOURENDDATE":
                            ugc.Header.Caption = "结束日期";
                            break;
                        case "AFFIRMTIME":
                            ugc.Header.Caption = "审批时间";
                            break;
                        case "AFFIRMFLAG":
                            ugc.Header.Caption = "是否确认";
                            ugc.ValueList = PublicStaticVariable.Static_YesOrNo_1().ValueListDB;
                            break;
                        case "AFFIRMPERSON":
                            ugc.Header.Caption = "审批人";
                            break;
                        case "ORDERNO":
                            ugc.Header.Caption = "订单行号";
                            break;
                        //协议管理
                        case "CONFERNO":
                            ugc.Header.Caption = "协议号";
                            break;
                        case "ADVANCE":
                            ugc.Header.Caption = "预约金";
                            break;
                        case "INPUTDATE":
                            ugc.Header.Caption = "签订日期";
                            break;
                        case "BEGINDATE":
                            ugc.Header.Caption = "生效日期";
                            break;
                        case "ENDDATE":
                            ugc.Header.Caption = "截至日期";
                            break;
                        case "CONFERTYPE":
                            ugc.Header.Caption = "协议类型";
                            ugc.ValueList = PublicStaticVariable.Static_BaseData("2087").ValueListDB;
                            break;
                        case "PREFERENTIALWAY":
                            ugc.Header.Caption = "优惠类型";
                            ugc.ValueList = PublicStaticVariable.Static_BaseData("2088").ValueListDB;
                            break;
                        case "CHECKWAY":
                            ugc.Header.Caption = "考核方式";
                            ugc.ValueList = PublicStaticVariable.Static_BaseData("2089").ValueListDB;
                            break;
                        case "SELLITEMCODE":
                            ugc.Header.Caption = "销售项目";
                            ugc.ValueList = PublicStaticVariable.Static_BaseData("6001").ValueListDB;
                            break;
                        case "SHAPECODE":
                            ugc.Header.Caption = "产品形态";
                            ugc.ValueList = PublicStaticVariable.Static_BaseData("1002").ValueListDB;
                            break;
                        case "AREA":
                            ugc.Header.Caption = "区域";
                            ugc.ValueList = PublicStaticVariable.Static_BaseData("2017").ValueListDB;
                            break;
                        case "BALANCE_ID":
                            ugc.Header.Caption = "结算明细号";
                            break;
                        case "TRAINWAGON":
                            ugc.Header.Caption = "车号";
                            break;
                        case "LISTNUMBER":
                            ugc.Header.Caption = "发货明细号";
                            break;
                        case "COILNO":
                            ugc.Header.Caption = "卷号";
                            break;
                        case "STOVENO":
                            ugc.Header.Caption = "炉号";
                            break;
                    }
                    if (ugc.Key.ToUpper().IndexOf("DATE") > 1)
                    {
                        ugc.Format = "yyyy年MM月dd日";
                        ugc.Width = 100;
                    }
                    if (ugc.Key.ToUpper().IndexOf("TIME") > 1)
                    {
                        ugc.Format = "yyyy年MM月dd日HH时mm分";
                        ugc.Width = 140;
                    }
                    if (ugc.Key.ToUpper() != "CHECK")
                    {
                        ugc.CellActivation = Activation.NoEdit;
                    }
                    else
                    {
                        ugc.CellActivation = Activation.AllowEdit;
                    }
                    if (ugc.Key.ToUpper().IndexOf("MONEY") >= 0)
                    {
                        ugc.Format = "C";
                        ugc.Width = 90;
                        ugc.CellAppearance.TextHAlign = HAlign.Right;
                        ugc.Band.Summaries.Add(SummaryType.Sum, ugc, SummaryPosition.UseSummaryPositionColumn);
                    }
                    if (ugc.Key.ToUpper().IndexOf("WEIGHT") >= 0)
                    {
                        ugc.Band.Summaries.Add(SummaryType.Sum, ugc, SummaryPosition.UseSummaryPositionColumn);
                    }
                    if (ugc.Key.ToUpper().IndexOf("QUANTITY") >= 0)
                    {
                        ugc.Band.Summaries.Add(SummaryType.Sum, ugc, SummaryPosition.UseSummaryPositionColumn);
                    }
                    if (ugc.Key.ToUpper().IndexOf("PRICE") >= 0)
                    {
                        ugc.Format = "C";
                        ugc.Width = 60;
                        ugc.CellAppearance.TextHAlign = HAlign.Right;

                        //SummarySettings ss1 = new SummarySettings();
                        //ss1.DisplayFormat = "平均{0}";
                        //ss1.SummaryPosition = SummaryPosition.UseSummaryPositionColumn;
                        //ss1.SummaryType = SummaryType.Average;
                        //ss1.SummaryDisplayArea = SummaryDisplayAreas.Bottom;
                        //ss1.SourceColumn = ugc;
                        //ss1.SummaryPositionColumn = ugc;
                    }
                    if (ugc.Key.ToUpper().StartsWith("IS"))
                    {
                        ugc.ValueList = PublicStaticVariable.Static_YesOrNo_1().ValueListDB;
                    }
                }
                ugb.SummaryFooterCaption = "统计:";
                foreach (SummarySettings sss in ugb.Summaries)
                {
                    if (sss.SourceColumn.Key.ToUpper().IndexOf("PRICE") >= 0)
                    {
                        sss.DisplayFormat = "平均{0:C}";
                        sss.SummaryPositionColumn = sss.SourceColumn;
                    }
                    if (sss.SourceColumn.Key.ToUpper().IndexOf("WEIGHT") >= 0)
                    {
                        sss.DisplayFormat = "{0}";
                        sss.SummaryPositionColumn = sss.SourceColumn;
                    }
                    if (sss.SourceColumn.Key.ToUpper().IndexOf("MONEY") >= 0)
                    {
                        sss.DisplayFormat = "{0:C}";
                        sss.SummaryPositionColumn = sss.SourceColumn;
                    }
                    if (sss.SourceColumn.Key.ToUpper().IndexOf("QUANTITY") >= 0)
                    {
                        sss.DisplayFormat = "{0}";
                        sss.SummaryPositionColumn = sss.SourceColumn;
                    }
                }
            }
        }


        //检验编辑区域数据有效行
        public bool CheckEditData(Control Pctl)
        {
            foreach (Control ctl in Pctl.Controls)
            {
                if (ctl.Controls != null)
                {
                    CheckEditData(ctl);
                }
                else
                {
                    if (ctl is ComboBox && ctl.Parent is Panel)
                    {
                        if ((ctl as ComboBox).SelectedIndex == -1 && ctl.Parent.Controls[0])
                        {
                            if(ctl.Parent is Panel)
                            {
                                MessageBox.Show(string.Format("请选择{0}!"));
                                return false;
                            }
                        }
                    }
                    if(ctl is TextBox)
                    {
                        if((ctl as TextBox).Text.Trim() == "")
                        {
                            MessageBox.Show(string.Format("请输入{0}",(ctl as TextBox).ToString()));
                        }
                    }
                }
            }
        }
    }
    public struct StructBaseOperateResult
    {
        public string vMessage;
        public DataSet vDataSet;
        public object vOutlist;
        public bool vFlag;

        public void SetGridDB(DataSet ds)
        {
            ds.Clear();
            vDataSet.Tables[0].TableName = ds.Tables[0].TableName;
            ds.Merge(vDataSet.Tables[0]);
            ds.AcceptChanges();
        }
    }


}