MES_Client/TGMES/Core.StlMes.Client.Sale.UI.Balance/BalanceAccount/FrmBalanceTicketMgt.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Threading;
using System.Collections;
using System.Reflection;
using CoreFS.CA06;
using Infragistics.Win.UltraWinGrid;

namespace Core.StlMes.Client.Sale.UI.Balance.BalanceAccount
{
    public partial class FrmBalanceTicketMgt : Core.StlMes.Client.Sale.Common.FrmStyleBase.FrmUIBase
    {
        public FrmBalanceTicketMgt()
        {
            InitializeComponent();

        }

        private String cusInfo = "";

        private String suppunit = "";

        private string _key = "2";

        private void SetKey()
        {
            if (this.CustomInfo.Length > 0)
            {
                this._key = this.CustomInfo.Trim().Split('_')[0];
            }
        }

        //待结算单据管理(结算价维护) 1
        //待结算单据管理(结算编单) 2
        private void HiddenToolbars()
        {
            
                try
                {
                    foreach (  Infragistics.Win.UltraWinToolbars.ToolBase tb in toolMenu.Toolbars[0].Tools)
                    {
                        if (tb.Key == "QueryUnAcept" || tb.Key == "Accept" || tb.Key == "Exit" || tb.Key == "Export")
                        {
                            continue;
                        }
                        else
                            tb.SharedProps.Visible = false;
                    }
                  
                   
                }
                catch
                { 
                }
                try
                {
                    this.ultraExpandableGroupBox1.Visible = false;
                    this.toolMenu.Toolbars[0].Tools["UpdatePrice"].SharedProps.Visible = false;
                    this.toolMenu.Toolbars[0].Tools["RollBack"].SharedProps.Visible = false;
                    this.toolMenu.Toolbars[0].Tools["SavePrice"].SharedProps.Visible = false;
                  
                }
                catch
                { }
            

            if (this._key == "1")
            {
                try
                {
                    this.label4.Visible = false;
                    this.textBox2.Visible = false;
                    this.ultraExpandableGroupBox2.Visible = false;
                    this.toolMenu.Toolbars[0].Tools["UpdatePrice"].SharedProps.Visible = false;
                    this.toolMenu.Toolbars[0].Tools["RollBack"].SharedProps.Visible = false;                  
                    this.toolMenu.Toolbars[0].Tools["Invoice"].SharedProps.Visible = false;
                    this.toolMenu.Toolbars[0].Tools["UnAffrim"].SharedProps.Visible = false;
                    this.toolMenu.Toolbars[0].Tools["Affrim"].SharedProps.Visible = false;
                  
                }
                catch
                { }
            }

            
            
 
        }


        private string LISTNUMBER = "LISTNUMBER";


        private void AcceptTicket()
        {
            Infragistics.Win.UltraWinGrid.UltraGridRow ugr = null;
            if (this.ultraGrid5.Rows.Count == 0)
                return;
            ugr = this.ultraGrid5.ActiveRow;
            if (ugr == null)
                ugr = this.ultraGrid5.Rows[0];

            ugr.Selected = true;

            ArrayList listask = new ArrayList();

            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugs in this.ultraGrid5.Selected.Rows)
            {
                listask.Add(ugs.Cells[LISTNUMBER].Value.ToString());

            }

            //   string askPlanId = ugr.Cells[StaticData.TbColumnAndCaption.ASKPLAN_ID].Value.ToString();
            if (Util.MessageUtil.ShowYesNoAndQuestion("是否接收选定行？") == DialogResult.No) return;
            string errMsg = "";


            this.slmBalanceInfo.AffrimAcceptTicket(listask, CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName(), out errMsg);
            if (errMsg.Length == 0)
            {
                Core.StlMes.Client.Sale.Util.MessageUtil.ShowTips("操作成功");
                this.QueryUnAcceptTicket();
                

            }


        }

        private void UnAcceptTicket()
        {
            Infragistics.Win.UltraWinGrid.UltraGridRow ugr = null;
            if (this.ultraGrid1.Rows.Count == 0)
                return;
            ugr = this.ultraGrid1.ActiveRow;
            if (ugr == null)
                ugr = this.ultraGrid1.Rows[0];

            if (ugr == null)
            {
                Core.StlMes.Client.Sale.Util.MessageUtil.ShowError("请选择需要取消的行");
                return;
            }

            //   string askPlanId = ugr.Cells[StaticData.TbColumnAndCaption.ASKPLAN_ID].Value.ToString();
            if (Util.MessageUtil.ShowYesNoAndQuestion("是否取消接收选定行？") == DialogResult.No) return;

            string errMsg = "";
            this.slmBalanceInfo.UnAffrimAcceptTicket(ugr.Cells[this.LISTNUMBER].Value.ToString(), CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName(), out errMsg);
            if (errMsg.Length == 0)
            {
                Core.StlMes.Client.Sale.Util.MessageUtil.ShowTips("操作成功");
                try
                {
                    string listnum = ugr.Cells[this.LISTNUMBER].Value.ToString();
                    ArrayList list = new ArrayList();
                    foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugs in this.ultraGrid1.Rows)
                    {
                        if (ugs.Cells[this.LISTNUMBER].Value.ToString() == listnum)
                        {
                            list.Add(ugs);
                        }
                       
                    }

                    foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugg in list)
                    {
                        ugg.Delete();
                    }
                }
                catch
                { 
                }
            }

        }


        

        private Infragistics.Win.ValueList GetAgenCyFlList()
        {
            Infragistics.Win.ValueList lit = new Infragistics.Win.ValueList();
            lit.ValueListItems.Add("0", "否");
            lit.ValueListItems.Add("1", "是");
            return lit;
        }

        private Infragistics.Win.ValueList GetStatusList()
        {
            Infragistics.Win.ValueList lit = new Infragistics.Win.ValueList();
            lit.ValueListItems.Add("0", "未确认");
            lit.ValueListItems.Add("1", "确认");
            lit.ValueListItems.Add("2", "编单");
            return lit;
        }

        private Infragistics.Win.ValueList GetPriceStatusList()
        {
            Infragistics.Win.ValueList lit = new Infragistics.Win.ValueList();
            lit.ValueListItems.Add("0", " 无效");
            lit.ValueListItems.Add("1", " 有效");
            return lit;
        }

        private Infragistics.Win.ValueList GetBalStatusList()
        {
            Infragistics.Win.ValueList lit = new Infragistics.Win.ValueList();
            lit.ValueListItems.Add("0", "未确认");
          //  lit.ValueListItems.Add("1", "确认");
            lit.ValueListItems.Add("2", "确认");
            lit.ValueListItems.Add("3", "编单");
            return lit;
        }

        private Infragistics.Win.ValueList GetFst_Drawee_unit()
        {
            Infragistics.Win.ValueList lit = new Infragistics.Win.ValueList();
            lit.ValueListItems.Add("120601", "N/A");
            lit.ValueListItems.Add("120602", "/");
            lit.ValueListItems.Add("120603", "天津钢管集团股份有限公司");
            lit.ValueListItems.Add("120604", "天津钢管钢铁贸易有限公司");
            lit.ValueListItems.Add("120605", "天津钢管国际经济贸易有限公司");
            lit.ValueListItems.Add("120606", "合同结算单位");
            lit.ValueListItems.Add("120607", "江苏天淮钢管有限公司");
            lit.ValueListItems.Add("120608", "天津钢管制造有限公司");
            return lit;
        }

        private string[] GetGridFourDataStruct()
        {
            return new string[] 
            {
               "ASKPLAN_ID",
                "TALLYSHEET_NO",
                "BATCH_NO",
                "QUANTITY",
                "ACT_WGT"     ,
                 "OUTSTOCKMNY",
                "MONEY_TYPE",
                 "AGENCY_FL",
                "DELVRY_ADDR",
                "RECEIV_ADDR"
            };
        }

        protected override List<string> GetNumberColumn()
        {
            return new List<string>(new string[] { 
                "SEND_NUM",
                "MONEY",
                "WEIGHT",
              "QUANTITY",
                "ACT_WGT",
                "OUTSTOCKMNY",
                "TRANSMNY", 
                "PRICE",
                  "PRICE_ORG",
                "MONEY_ORG",
            });
        }



     


        private DataSet dsBalanceMain = new DataSet ();
        private Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Balance.SlmBalanceInfo slmBalanceInfo = null;
        DataSet dsGridThree = new DataSet();
        DataSet dsGridFour = new DataSet();

        DataSet dsGridUnAccept = new DataSet();

        private void FrmBalanceTicketMgt_Load(object sender, EventArgs e)
        {
            this.ultraExpandableGroupBox1.Visible = false;
            this.ultraExpandableGroupBox2.Visible = true;
            this.dateTimePicker1.Value = System.DateTime.Now.AddMonths(-1);
            SetKey();
            this.Init();

            this.dsBalanceMain = base.GetDataSetByColumnName(this.GetGrid1DataStruct(),
                null, GetColumnAndCaption());
            this.ultraGrid1.DataSource = dsBalanceMain;

            this.dsGridThree = base.GetDataSetByColumnName(this.GetGridThreeDataStruct(),
                 StaticData.TbColumnAndCaption.GetDataSetColumnType(), StaticData.TbColumnAndCaption.GetColumnAndCaption());

            this.ultraGrid3.DataSource = dsGridThree;

            dsGridFour = base.GetDataSetByColumnName(this.GetGridFourDataStruct(),
                 StaticData.TbColumnAndCaption.GetDataSetColumnType(), StaticData.TbColumnAndCaption.GetColumnAndCaption());

      //      this.ultraGrid4.DataSource = dsGridFour;
            slmBalanceInfo = new Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Balance.SlmBalanceInfo(this.ob);

            this.dsGridFine = base.GetDataSetByColumnName(this.GetGridFiveDataStruct(),
            StaticData.TbColumnAndCaption.GetDataSetColumnType(), StaticData.TbColumnAndCaption.GetColumnAndCaption());

        //   this.ultraGrid2.DataSource = dsGridFine;
            this.ultraGrid1.DisplayLayout.GroupByBox.Hidden = true;

            dsGridUnAccept = base.GetDataSetByColumnName(GetUnAcceptBalaceColumn(),
                null, GetColumnAndCaption());
            this.ultraGrid5.DataSource = dsGridUnAccept;


            HiddenColumn();
            InitGrid();
          base.SetGridStyle(ref this.ultraGrid1,  ref this.ultraGrid3,ref this.ultraGrid5);
          cusInfo = CustomInfo.Split('_')[0];
          if (CustomInfo.Split('_').Length > 1)
              suppunit = CustomInfo.Split('_')[1];


          
            SetGridShowLength();

            if (this.cusInfo == "2")
            {
                this.ultraTabControl1.Tabs[0].Visible = true;
                
            }
            else
            {
                if (base.GetSaleOrgDesc() == "国贸公司" || suppunit == "120504")
                    this.ultraTabControl1.Tabs[0].Visible = true;
                else
                {
                   this.ultraTabControl1.Tabs[0].Visible = false;
                   
                    
                }
                   
            }

            this.ultraGrid1.DisplayLayout.Bands[0].Columns[this.ASKPLAN_ID].MergedCellStyle = Infragistics.Win.UltraWinGrid.MergedCellStyle.Always;
            this.ultraGrid1.DisplayLayout.Bands[0].Columns["LISTNUMBER"].MergedCellStyle = Infragistics.Win.UltraWinGrid.MergedCellStyle.Always;


         

        }

    



        private void InitGrid()
        {
            try
            {
              //  this.ultraGrid4.DisplayLayout.Bands[0].Columns["AGENCY_FL"].ValueList = GetAgenCyFlList();
            }
            catch
            { }


            try
            {
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["CONTAIN_TAX"].ValueList = GetAgenCyFlList();
            }
            catch
            { }

            try
            {
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["TICKETSTATUS"].ValueList = GetAgenCyFlList();
            }
            catch
            { }

               try
            {
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["BALANCESTATUS_ORG"].ValueList = GetBalStatusList();
            }
            catch
            { }

            try
            {
             //   this.ultraGrid2.DisplayLayout.Bands[0].Columns["STATUS_CD"].ValueList = GetStatusList();
            }
            catch
            { }

              try
            {
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["FST_DRAWEE_UNIT"].ValueList = GetFst_Drawee_unit();
            }
            catch
            { }

               try
            {
                this.ultraGrid1.DisplayLayout.Bands[0].Columns[this.BALNCE_PRICE_STS].ValueList = GetPriceStatusList();
              
            }
            catch
            { }

               try
               {
                   this.ultraGrid1.DisplayLayout.Bands[0].Columns[this.BALNCE_PRICE_ORG_STS].ValueList = GetPriceStatusList();
                
               }
               catch
               { }

            


            

            
        }


        private void HiddenColumn()
        {
            try
            {
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["BALANCESTATUS"].Hidden = true;
              //  this.ultraGrid1.DisplayLayout.Bands[0].Columns["BALANCESTATUS_ORG"].Hidden = true;
                
                this.ultraGrid1.DisplayLayout.Bands[0].Columns[this.ADJUSTPRICEREASON].Hidden = true;
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["ADJUSTPRICEREASON"].Hidden = true;
                this.ultraGrid1.DisplayLayout.Bands[0].Columns[BUYERCODE].Hidden = true;
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["ADJUSTPRICEPERSON"].Hidden = true;
                
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["ORD_PK"].Hidden = true;
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["ORD_LN_PK"].Hidden = true;
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["ORD_LN_DLY_PK"].Hidden = true;

                this.ultraGrid1.DisplayLayout.Bands[0].Columns["CUSTOMER_NO"].Hidden = true;
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["SALE_AREA_NO"].Hidden = true;
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["STD_STYLE"].Hidden = true;
            }
            catch
            { }
        }
        private DataSet dsGridFine = new DataSet();
        private Hashtable hstransFee = new Hashtable();


        private void QueryGridFour()
        {
            this.dsGridFour.Clear();
            Infragistics.Win.UltraWinGrid.UltraGridRow ugr = null;
            if (this.ultraGrid1.Rows.Count == 0)
                return;
            ugr = this.ultraGrid1.ActiveRow;
            if (ugr == null)
                ugr = this.ultraGrid1.Rows[0];


            string orderno = ugr.Cells[StaticData.TbColumnAndCaption.ORD_NO].Value.ToString();
            string orderseq = ugr.Cells[StaticData.TbColumnAndCaption.ORD_SEQ].Value.ToString();
            string orderlineseq = ugr.Cells[StaticData.TbColumnAndCaption.ORD_LN_DLY].Value.ToString();
            string askplanid = ugr.Cells[StaticData.TbColumnAndCaption.ASKPLAN_ID].Value.ToString();
            string askplanidseq = ugr.Cells[StaticData.TbColumnAndCaption.ASKPLAN_ID_SEQ].Value.ToString();
            string spetkey = ugr.Cells[StaticData.TbColumnAndCaption.SPETKEY].Value.ToString();
            string steelkey = ugr.Cells[StaticData.TbColumnAndCaption.STEELCODEKEY].Value.ToString();


            DataSet dsDetail =
              this.slmBalanceInfo.GetSlmBalanceDetailAllGroupByBatchNo(
              orderno, orderseq, orderlineseq, askplanid, askplanidseq, spetkey, steelkey);
            Util.UtilDataSet.SetDataSetByMergeSameColumnName(ref this.dsGridFour, dsDetail);
 
        }

        private void QueryGridFive()
        {
            this.dsGridFine.Clear();
            Infragistics.Win.UltraWinGrid.UltraGridRow ugr = null;
            if (this.ultraGrid1.Rows.Count == 0)
                return;
            ugr = this.ultraGrid1.ActiveRow;
            if (ugr == null)
                ugr = this.ultraGrid1.Rows[0];
            string askPlanId = ugr.Cells[StaticData.TbColumnAndCaption.ASKPLAN_ID].Value.ToString();
            DataSet ds = null;
          
                ds = this.slmBalanceInfo.GetSlmBalanceTransMoneyAskPlanid(askPlanId);
       
         
            ds = Util.UtilDataSet.GetDataSetWithRowFilter(ds, "MONEY_TYPE", "运费");
            Util.UtilDataSet.SetDataSetByMergeSameColumnName(ref this.dsGridFine, ds);

        }

  

        private void Init()
        {
            try
            {
                this.radioButton1.Checked = true;
            }
            catch
            { }
        }


        private Hashtable GetHashTableByImpExcel()
        {
            Hashtable hs = new Hashtable();
            string fileName = Util.UtilExcel.GetExcelFileName();
            if (fileName.Length == 0)
                return hs;

            DataSet ds = Util.UtilExcel.ToDataSet(fileName);
            if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
                return hs;
            string key = "";
            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                key = dr[0].ToString() + dr[1].ToString() + dr[2].ToString();
                if (!hs.ContainsKey(key))
                {
                    hs.Add(key,dr[3].ToString());
                }
               
            }
            return hs;
        }

        private string GetSqlStr(string price,string person,string condition)
        {

            String sqlStr = @"  update  SLM_BALANCEINFO set PRICE_ORG =  nvl({1},0), 
				  MONEY_ORG = round(nvl({1},0) * weight ,5), 
				 PRICE_INPUTPERSON_ORG = '{2}' ,PRICE_INPUTPEDATE_ORG = sysdate,PRICE_PRE_ORG = {1} 
			  where ORD_NO||ORD_SEQ||ORD_LN_DLY||ASKPLAN_ID||ASKPLAN_ID_SEQ||spetKey||steelCodeKey = '{0}' 
                    and forecorpcode = '国贸公司'  and balancestatus_org = '0'   ";

            sqlStr = string.Format(sqlStr, condition, price, person);
            return sqlStr;
        }


        private void BatchUPdateBalancePrice()
        {
            if (this.ultraGrid1.Selected.Rows.Count == 0)
            {
                Core.StlMes.Client.Sale.Util.MessageUtil.ShowError("请选择需要保存价格的行");
                return;
            }

            if (this.radioButton2.Checked)
            {
                Core.StlMes.Client.Sale.Util.MessageUtil.ShowError("只允许保存未接收数据价格");
                return;
            }

            Hashtable hsOrderPrice = GetHashTableByImpExcel();

            if (hsOrderPrice.Count == 0)
                return;

            ArrayList sqllist = new ArrayList();

            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugr in this.ultraGrid1.Selected.Rows)
            {
                string sql = "";
                string key = ugr.Cells["CATEGORY"].Value.ToString().Trim() + ugr.Cells["STEELCODEKEY"].Value.ToString().Trim() + ugr.Cells["MODEL_DESC"].Value.ToString().Trim();
                string orderno = ugr.Cells[this.ORD_NO].Value.ToString();
                string ord_seq = ugr.Cells[this.ORD_SEQ].Value.ToString();
                string ord_ln = ugr.Cells[this.ORD_LN_DLY].Value.ToString();
                string askplanId = ugr.Cells[this.ASKPLAN_ID].Value.ToString();
                string askPlanIdSeq = ugr.Cells[this.ASKPLAN_ID_SEQ].Value.ToString();
                string spetKey = ugr.Cells[this.SPETKEY].Value.ToString();
                string steelcodekey = ugr.Cells[this.STEELCODEKEY].Value.ToString();
                string person = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName();
                string price = "0";
                if (hsOrderPrice.ContainsKey(key))
                {
                    price = hsOrderPrice[key].ToString();
                    if (Core.StlMes.Client.Sale.Util.ConverObject.ConvertToDouble(price) == 0)
                        continue;
 
                }

                if (price == "0")
                    continue;
                sql = GetSqlStr(price, person, orderno + ord_seq + ord_ln + askplanId + askPlanIdSeq + spetKey + steelcodekey);

                sqllist.Add(sql);


            }

            if (sqllist.Count > 0)
            {
                base.ExecuteNoReader(sqllist);
                this.QueryOrg();
            }
           
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    {
                        this.Query();
                        break;
                    }

                case "QueryUnAcept":
                    {
                        this.QueryUnAcceptTicket();
                        break;
                    }

                case "QueryOrg":
                    {
                        this.QueryOrg();
                        break;
                    }
                case "Affrim":
                    {
                        this.Affrim();
                        break;
                    }
                case "AffrimOrg":
                    {
                        this.AffrimOrg();
                        break;
                    }
                case "UnAffrim":
                    {
                        this.UnAffrim();
                        break;
                    }
                case "UnAffrimOrg":
                    {
                        this.UnAffrimOrg();
                        break;
                    }
                case "Exit":
                    {
                        this.Close();
                        break;
                    }
                case "Invoice":
                    {
                        InvoiceWithTranMny();
                      //  this.Invoice();
                        break;
                    }
                case "InvoiceOrg":
                    {
                        this.InvoiceOrg();
                        //  this.Invoice();
                        break;
                    }
                case "InvoiceGuoMao":
                    {
                        this.InvoiceGuom();
                        //  this.Invoice();
                        break;
                    }
                case "InvoiceWithTranMny":
                    {
                        InvoiceWithTranMny();
                        break;
                    }
                case "UpdatePrice":
                    {
                        this.UpdatePrice();
                        break;
                    }
                case "SavePrice":
                    {
                        this.InputPrice();
                        break;
                    }
                case "RollBack":
                    {
                        this.RollBackAskPlanId();
                        break;
                    }
                case "Export":
                    {
                        Util.UtilUltraGrid.ExportGridDataToExcel(this.Text, this.ultraGrid1);
                        break;
                    }
                case "SetPrice":
                    {
                        SetBalPrice();
                        break;
                    }
                case "SetPriceOrg":
                    {
                        SetBalPriceOrg();
                        break;
                    }

                case "ExportPrice":
                    {
                        BatchUPdateBalancePrice();
                        break;
                    }

                       case "Accept":
                    {
                        AcceptTicket();
                        break;
                    }

                       case "UnAccept":
                    {
                        UnAcceptTicket();
                        break;
                    }
                       case "AcpRllRecord":
                    {
                       AccetpRollCreditRecord();
                        break;
                    }

                    
            }
        }



        private void AccetpRollCreditRecord()
        {
            try 
            {
                DlgBox.DlgCredit dlgCredit
                    = new Core.StlMes.Client.Sale.UI.Balance.DlgBox.DlgCredit(this.ob);
                if (this.cusInfo == "3")
                    dlgCredit.SetFlag("2");
                dlgCredit.ShowDialog();
            }
            catch
            {
            }
        }


        private void SetBalPriceOrg()
        {
            ArrayList listOrder = GetUpdateCondition();
            if (listOrder.Count == 0)
                return;
            //foreach (string[] s in listOrder)
            //{
            //    this.slmBalanceInfo.SetBalPriceOrg(new ArrayList() { s }, CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName());
            //}

            this.slmBalanceInfo.SetBalPriceOrg(listOrder, CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName());
            this.QueryOrg();


        }

        /// <summary>
        ///  重新获取结算明细价格,防止因维护不及时无法获取正确价格
        /// </summary>
        private void SetBalPrice()
        {
            ArrayList listOrder = GetUpdateCondition();
            if (listOrder.Count == 0)
                return;
            //foreach (string[] s in listOrder)
            //{
            //    this.slmBalanceInfo.SetBalPrice(new ArrayList() { s}, CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName());
            //}

            this.slmBalanceInfo.SetBalPrice(listOrder, CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName());
            this.Query();


        }


        private void InvoiceWithTranMny()
        {
            if (!IsCanBeInvoiced())
                return;
            ArrayList listOrder = GetUpdateCondition();
            if (listOrder.Count == 0)
                return;
            if (Util.MessageUtil.ShowYesNoAndQuestion("是否确定编制结算单？") == DialogResult.No) return;
            string errMsg = "";
            this.slmBalanceInfo.InvoiceLightly(listOrder, "", CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName(), out errMsg);

            if (errMsg.Length > 0)
            {
            }
            else
            {
                removeUgr();
                Core.StlMes.Client.Sale.Util.MessageUtil.ShowTips("操作成功");
            }
          //  this.Query();
        }

        private void InvoiceOrg()
        {
            if (!this.IsCanBeInvoicedOrg())
                return;
            ArrayList listOrder = GetUpdateConditionSaleOrg();
            if (listOrder.Count == 0)
                return;
            if (Util.MessageUtil.ShowYesNoAndQuestion("是否确定编制结算单？") == DialogResult.No) return;
            string errMsg = "";
            this.slmBalanceInfo.InvoiceLightlyOrg(listOrder, "", CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName(), out errMsg);
           // this.QueryOrg();

            if (errMsg.Length > 0)
            {
            }
            else
            {
                removeUgr();
                Core.StlMes.Client.Sale.Util.MessageUtil.ShowTips("操作成功");
            }
        }

        private void InvoiceGuom()
        {
            if (!this.IsCanBeInvoiced())
                return;
            ArrayList listOrder = GetUpdateCondition();
            if (listOrder.Count == 0)
                return;
            if (Util.MessageUtil.ShowYesNoAndQuestion("是否确定编制结算单？") == DialogResult.No) return;
            string errMsg = "";
            //    this.slmBalanceInfo.Invoice(listOrder,"", CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName());
            this.slmBalanceInfo.InvoiceLightlyGuoM(listOrder, "", CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName(),out errMsg);

     //       this.QueryOrg();

            if (errMsg.Length > 0)
            {
            }
            else
            {
                removeUgr();
                Core.StlMes.Client.Sale.Util.MessageUtil.ShowTips("操作成功");
            }
        }

        private DataSet GetSlmOrderLine(List<string> odpkList)
        {
            DataSet ds = new DataSet();

            if (odpkList.Count == 0)
            {
                return ds;
            }

            string sqlCondition = Core.StlMes.Client.Sale.Util.ConverObject
                .ConvertListStringValueToSqlCondition("ORD_PK", odpkList);

            string sql = @"select nvl(A.BALNCE_PRICE_STS, '0') BALNCE_PRICE_STS,
                                   nvl(A.BALNCE_PRICE_ORG_STS, '0') BALNCE_PRICE_ORG_STS,
                                   a.ord_pk,
                                   a.ord_ln_pk
                              from slm_order_line a
                             where 1=1 and  validflag = '1' {0}";

            sql = string.Format(sql,sqlCondition);
            ds = base.ExecuteReader(sql);

            return ds;
        }


        private Hashtable GetOrderBalSts(List<string> odpkList)
        {
            Hashtable hs = new Hashtable();
            DataSet ds = GetSlmOrderLine(odpkList);
            try
            {
                string ordandlinePk = "";
                foreach (DataRow dr in ds.Tables[0].Rows)
                {
                    ordandlinePk = dr["ORD_PK"].ToString() + dr["ORD_LN_PK"].ToString();
                    if (!hs.ContainsKey(ordandlinePk))
                    {
                        hs.Add(ordandlinePk, new string[] { dr["BALNCE_PRICE_STS"].ToString(), dr["BALNCE_PRICE_ORG_STS"].ToString() });
                    }
 
                }
            }
            catch
            { 
            }
            return hs;
        }


        private void QueryUnAcceptTicket()
        {
            DataSet ds = null;
            ds = this.slmBalanceInfo.GetUnAcceptTicketAndTransAndOutStockTicket(this.dateTimePicker1.Value,
                  this.dateTimePicker2.Value,cusInfo, suppunit);

            if (this.textBox7.Text.Length > 0)
            {
                ds = Core.StlMes.Client.Sale.Util.UtilDataSet.GetDataSetWithRowFilterWithApproximateMatch
                    (ds, ASKPLAN_ID, this.textBox7.Text.Trim());
            }
            if (!this.UserInfo.GetUserName().Equals("admin"))
                ds = base.GetDataSetByFilterDeptId(ds);
            //if ("120504".Equals(suppunit))
            //    ds = Util.UtilDataSet.GetDataSetWithRowFilter(ds, "supply_unit", suppunit);

            Core.StlMes.Client.Sale.Util.UtilDataSet.SetDataSetByMergeSameColumnName(ref this.dsGridUnAccept, ds);
            Core.StlMes.Client.Sale.Util.UtilDataSet.GetDsByDescOrderFromSourceDataSet(dsGridUnAccept, "LISTNUMBER");

        }

        private void Query()
        {
         
            DataSet ds = null;
            DataSet dsTrans = null;

            // 只有编单界面才查
     
                if (this.radioButton1.Checked) // 已编卡
                {
                    ds = this.slmBalanceInfo.GetUnAffrimSlmBalaneInfoByPlanBeginDateAndEndDate(this.dateTimePicker1.Value,
                       this.dateTimePicker2.Value, suppunit);
                    dsTrans = this.slmBalanceInfo.GetAcceptAndUnAffrimTransAndOutStockTicket(suppunit);
                }
                if (this.radioButton2.Checked)// 未编卡
                {
                    ds = this.slmBalanceInfo.GetAffrimSlmBalaneInfoByPlanBeginDateAndEndDate(this.dateTimePicker1.Value,
                      this.dateTimePicker2.Value, suppunit);
                    dsTrans = this.slmBalanceInfo.GetAcceptAndAffrimTransAndOutStockTicket(suppunit);
                }



            if (this.textBox7.Text.Trim().Length > 0)
            {
                ds = Util.UtilDataSet.GetDataSetWithRowFilterWithApproximateMatch(ds, this.ASKPLAN_ID, this.textBox7.Text.Trim());
                dsTrans = Util.UtilDataSet.GetDataSetWithRowFilterWithApproximateMatch(dsTrans, this.ASKPLAN_ID, this.textBox7.Text.Trim());
            }
            if (this.textBox1.Text.Trim().Length > 0)
            {
                ds = Util.UtilDataSet.GetDataSetWithRowFilterWithApproximateMatch(ds, this.ORD_NO, this.textBox1.Text.Trim());
            }

            if (!this.UserInfo.GetUserName().Equals("admin"))
                ds = base.GetDataSetByFilterDeptId(ds);
            dsTrans = base.GetDataSetByFilterDeptId(dsTrans);
            //if ("120504".Equals(suppunit))
            //    ds = Util.UtilDataSet.GetDataSetWithRowFilter(ds, "supply_unit", suppunit);
            //if ("120504".Equals(suppunit))
            //    dsTrans = Util.UtilDataSet.GetDataSetWithRowFilter(dsTrans, "supply_unit", suppunit);
            this.dsBalanceMain.Clear();

            Util.UtilDataSet.SetDataSetByMergeSameColumnName(ref this.dsBalanceMain,ds);
            SetTicketMoneyType(ref this.dsBalanceMain);
            SetOrd();

            try
            {
                dsTrans.Tables[0].TableName = this.dsBalanceMain.Tables[0].TableName;
                this.dsBalanceMain.Merge(dsTrans, false, System.Data.MissingSchemaAction.Ignore);
            }
            catch
            { 
            }


            Core.StlMes.Client.Sale.Util.UtilDataSet.GetDsByDescOrderFromSourceDataSet(this.dsBalanceMain, this.ASKPLAN_ID);
            this.ultraGrid1.DisplayLayout.Bands[0].Columns[this.BALNCE_PRICE_STS].CellActivation = Activation.ActivateOnly;
            this.ultraGrid1.DisplayLayout.Bands[0].Columns[this.BALNCE_PRICE_ORG_STS].CellActivation = Activation.ActivateOnly;
            CleanGrid();


        //    this.SetMoney(ref this.dsBalanceMain);


        }


        private void SetTicketMoneyType(ref DataSet ds)
        {
            try 
            {
                foreach (DataRow dr in ds.Tables[0].Rows)
                {
                    dr["MONEY_TYPE"] = "货款";
                }
            }
            catch
            { 
            }
        }

        private string ORD_PK = "ORD_PK";
        private string ORD_LN_PK = "ORD_LN_PK";

        private string  BALNCE_PRICE_STS =  "BALNCE_PRICE_STS";
        private string  BALNCE_PRICE_ORG_STS =  "BALNCE_PRICE_ORG_STS";

        private void SetOrd()
        {
            if (this.ultraGrid1.Rows.Count == 0)
            {
                return;
            }

            List<string> list = new List<string>();
            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugr in this.ultraGrid1.Rows)
            {
                if (!list.Contains(ugr.Cells[this.ORD_PK].Value.ToString()))
                {
                    list.Add(ugr.Cells[this.ORD_PK].Value.ToString());
                }

            }

            Hashtable hs = GetOrderBalSts(list);

            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugr in this.ultraGrid1.Rows)
            {
                if (hs.ContainsKey(ugr.Cells[this.ORD_PK].Value.ToString() + ugr.Cells[this.ORD_LN_PK].Value.ToString()))
                {
                    string[] str = (string[])
                        hs[ugr.Cells[this.ORD_PK].Value.ToString() + ugr.Cells[this.ORD_LN_PK].Value.ToString()];
                    ugr.Cells[this.BALNCE_PRICE_STS].Value = str[0];
                    ugr.Cells[this.BALNCE_PRICE_ORG_STS].Value = str[1];
                }
             //   list.Add(ugr.Cells[this.ORD_PK].Value.ToString() + ugr.Cells[this.ORD_LN_PK].Value.ToString());

            }
        }

        private void QueryOrg()
        {

            DataSet ds = null;
            DataSet dsTrans = null;
            
            // 只有编单界面才查

            if (this.radioButton1.Checked)
            {
                ds = this.slmBalanceInfo.GetUnAffrimSlmBalaneInfoByPlanBeginDateAndEndDateOrg(this.dateTimePicker1.Value,
                   this.dateTimePicker2.Value);
                dsTrans = this.slmBalanceInfo.GetAcceptAndUnAffrimTransAndOutStockTicketOrg();
            }
            if (this.radioButton2.Checked)
            {
                ds = this.slmBalanceInfo.GetAffrimSlmBalaneInfoByPlanBeginDateAndEndDateOrg(this.dateTimePicker1.Value,
                  this.dateTimePicker2.Value);
                dsTrans = this.slmBalanceInfo.GetAcceptAndAffrimTransAndOutStockTicketOrg();
            }



            if (this.textBox7.Text.Trim().Length > 0)
            {
                ds = Util.UtilDataSet.GetDataSetWithRowFilterWithApproximateMatch(ds, this.ASKPLAN_ID, this.textBox7.Text.Trim());
                dsTrans = Util.UtilDataSet.GetDataSetWithRowFilterWithApproximateMatch(dsTrans, this.ASKPLAN_ID, this.textBox7.Text.Trim());
            }
            if (this.textBox1.Text.Trim().Length > 0)
            {
                ds = Util.UtilDataSet.GetDataSetWithRowFilterWithApproximateMatch(ds, this.ORD_NO, this.textBox1.Text.Trim());
            }

            // 按部门过滤数据
            // 按首次受票人过滤数据

            ds = Util.UtilDataSet.GetDataSetWithRowFilter(ds, "FST_DRAWEE_UNIT", GetFilterSaleOrg(suppunit));
           //if ("120504".Equals(suppunit))
            ds = Util.UtilDataSet.GetDataSetWithRowFilter(ds, "supply_unit", suppunit);
            if (!this.UserInfo.GetUserName().Equals("admin"))
                ds = base.GetDataSetByFilterDeptId(ds);

            dsTrans = base.GetDataSetByFilterDeptId(dsTrans);
            //if ("120504".Equals(suppunit))
                dsTrans = Util.UtilDataSet.GetDataSetWithRowFilter(dsTrans, "supply_unit", suppunit);
            this.dsBalanceMain.Clear();

            Util.UtilDataSet.SetDataSetByMergeSameColumnName(ref this.dsBalanceMain, ds);

            SetTicketMoneyType(ref this.dsBalanceMain);
            try
            {
                dsTrans.Tables[0].TableName = this.dsBalanceMain.Tables[0].TableName;
                this.dsBalanceMain.Merge(dsTrans, false, System.Data.MissingSchemaAction.Ignore);
            }
            catch
            {
            }
            SetOrd();
            this.ultraGrid1.DisplayLayout.Bands[0].Columns[this.BALNCE_PRICE_STS].CellActivation = Activation.ActivateOnly;
            this.ultraGrid1.DisplayLayout.Bands[0].Columns[this.BALNCE_PRICE_ORG_STS].CellActivation = Activation.ActivateOnly;
            CleanGrid();
            //    this.SetMoney(ref this.dsBalanceMain);


        }



        private string[] GetFilterSaleOrg(String flag)
        {
            if (flag == "120504")
                return new string[] { "120603", "120604", "120605", "120608" };
            else
                return new string[] { "120603", "120604", "120605" };
        }


        private void CleanGrid()
        {

            this.dsGridThree.Clear();
            this.dsGridFour.Clear();
            
        }

        private void Affrim()
        {
            ArrayList listOrder = GetUpdateCondition();
            if (listOrder.Count == 0)
                return;
            string errMsg = "";
            this.slmBalanceInfo.Affrim(listOrder, CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName(), out errMsg);
            if (errMsg.Length > 0)
            {
            }
            else
            {
                removeUgr();
                Core.StlMes.Client.Sale.Util.MessageUtil.ShowTips("操作成功");
            }
          


        }


        private void removeUgr()
        {
            try
            {
                System.Collections.Generic.List<Infragistics.Win.UltraWinGrid.UltraGridRow> listugr
                           = new List<UltraGridRow>();
                if(this.ultraGrid1.ActiveRow != null)
                this.ultraGrid1.ActiveRow.Selected = true;
                foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugr in this.ultraGrid1.Selected.Rows)
                {
                    listugr.Add(ugr);
                }

                foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugr in listugr)
                {
                    ugr.Delete();
                }
                this.ultraGrid1.UpdateData();
            }
            catch { }
        }

        private void AffrimOrg()
        {
            ArrayList listOrder = GetUpdateCondition();
            if (listOrder.Count == 0)
                return;
            string errMsg = "";
            this.slmBalanceInfo.AffrimOrg(listOrder, CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName(),out  errMsg);
           // this.QueryOrg();

            if (errMsg.Length > 0)
            {
            }
            else
            {
                removeUgr();
                Core.StlMes.Client.Sale.Util.MessageUtil.ShowTips("操作成功");
            }


        }


        private void UnAffrim()
        {
            ArrayList listOrder = GetUpdateCondition();
            if (listOrder.Count == 0)
                return;
            string errMsg = "";
            if (Util.MessageUtil.ShowYesNoAndQuestion("是否确定取消选定行？") == DialogResult.No) return;
            this.slmBalanceInfo.UnAffrim(listOrder, CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName(),out errMsg);
        //    this.Query();

            if (errMsg.Length > 0)
            {
            }
            else
            {
                removeUgr();
                Core.StlMes.Client.Sale.Util.MessageUtil.ShowTips("操作成功");
            }

        }

        private void UnAffrimOrg()
        {
            ArrayList listOrder = GetUpdateCondition();
            if (listOrder.Count == 0)
                return;
            if (Util.MessageUtil.ShowYesNoAndQuestion("是否确定取消选定行？") == DialogResult.No) return;
            string errMsg = "";
            this.slmBalanceInfo.UnAffrimOrg(listOrder, CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName(),out errMsg);
           // this.QueryOrg();

            if (errMsg.Length > 0)
            {
            }
            else
            {
                removeUgr();
                Core.StlMes.Client.Sale.Util.MessageUtil.ShowTips("操作成功");
            }

        }


       private  int saveDigit = 4;

        private void SetMoney(ref DataSet ds)
        {
         
            if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
                return;
            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                dr[this.MONEY] = Math.Round(Util.ConverObject.ConvertToDouble(dr[this.WEIGHT].ToString())
                    * Util.ConverObject.ConvertToDouble(dr[this.PRICE].ToString()), saveDigit);
            }

        }

        private Boolean IsCanBeUpdateWithDifferentPerson(string user)
        {

            if (user == CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName())
            {
                return true;
            }
            else
            {
                Core.StlMes.Client.Sale.Util.MessageUtil.ShowError("只允许操作本人数据");
                return false;
            }

        }

        private void Invoice()
        {
            if (!IsCanBeInvoiced())
                return;
            ArrayList listOrder = GetUpdateCondition();
            if (listOrder.Count == 0)
                return;
            if (Util.MessageUtil.ShowYesNoAndQuestion("是否确定编制结算单？") == DialogResult.No) return;
            string errMsg = "";
        //    this.slmBalanceInfo.Invoice(listOrder,"", CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName());
            this.slmBalanceInfo.InvoiceLightly(listOrder, "", CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName(), out errMsg);

            if (errMsg.Length > 0)
            {
            }
            else
            {
                removeUgr();
                Core.StlMes.Client.Sale.Util.MessageUtil.ShowTips("操作成功");
            }
        
          //  this.Query();
        }





        private void RollBackAskPlanId()
        {
            if (this.ultraGrid1.Rows.Count == 0)
                return;
            UltraGridRow ugr = this.ultraGrid1.ActiveRow;
            if (ugr == null)
                return;
            this.slmBalanceInfo.RollBaskAskPlanId(ugr.Cells[this.ASKPLAN_ID].Value.ToString(),
                CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName());
        }



        private Boolean IsCanBeInvoiced()
        {
            // 钢贸是否必须要在首次结算后再进行末次编单
            Boolean isAllowInvoice = true;
            if (this.ultraGrid1.Rows.Count == 0)
                return false;
            if (this.ultraGrid1.Rows.Count == 1)
                this.ultraGrid1.Rows[0].Selected = true;
            this.ultraGrid1.ActiveRow.Selected = true;
            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugr in this.ultraGrid1.Selected.Rows)
            {
                //if (Util.ConverObject.ConvertToDouble(ugr.Cells["PRICE"].Value.ToString()) == 0
                //    && ugr.Cells["MONEY_TYPE"].Value.ToString() == "货款"
                //    )
                //{
                //    Util.MessageUtil.ShowError("记录中有单价为0记录，不允许编单");
                //    return false;
                //}

                string FST_DRAWEE_UNIT = ugr.Cells["FST_DRAWEE_UNIT"].Value.ToString();

                // 钢贸的首次结算必须要等首次开票完成
                if ((  FST_DRAWEE_UNIT =="120604"|| FST_DRAWEE_UNIT =="120605") && isAllowInvoice && ugr.Cells["FORECORPCODE"].Value.ToString() == "钢贸公司" && ugr.Cells["BALANCESTATUS_ORG"].Value.ToString()+"" != "3")
                {
                    if (ugr.Cells["MONEY_TYPE"].Value.ToString() == "货款")
                    {
                        Util.MessageUtil.ShowError("记录中有未进行首次编单记录，不允许编单");
                        return false;
                    }
                }

                if ( ugr.Cells["MONEY_TYPE"].Value.ToString() == "货款" && !IsCanBeUpdateWithDifferentPerson(ugr.Cells["AFFRIMPERSON"].Value.ToString()))
                {
                    return false;
                }
            }

            return true;
        }

        private Boolean IsCanBeInvoicedOrg()
        {
            if (this.ultraGrid1.Rows.Count == 0)
                return false;
            if (this.ultraGrid1.Rows.Count == 1)
                this.ultraGrid1.Rows[0].Selected = true;
            this.ultraGrid1.ActiveRow.Selected = true;
            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugr in this.ultraGrid1.Selected.Rows)
            {
                if (Util.ConverObject.ConvertToDouble(ugr.Cells["PRICE_ORG"].Value.ToString()) == 0 && ugr.Cells["MONEY_TYPE"].Value.ToString() == "货款")
                {
                    Util.MessageUtil.ShowError("记录中有单价为0记录，不允许编单");
                    return false;
                }


                if (ugr.Cells["MONEY_TYPE"].Value.ToString() == "货款" && !IsCanBeUpdateWithDifferentPerson(ugr.Cells["AFFRIMPERSON_ORG"].Value.ToString()))
                {
                    return false;
                }
            }

            return true;
        }




        private ArrayList GetUpdateCondition()
        {
            ArrayList list = new ArrayList();
            if (this.ultraGrid1.Rows.Count == 0)
                return list;
            UltraGridRow ugr = this.ultraGrid1.ActiveRow;
            if (ugr == null)
                return list;
            if (this.ultraGrid1.Selected.Rows.Count == 0)
            {
                CheckedIsGridGroupRow(ugr, ref list);
            }
            else
            {
                for (int i = 0; i < this.ultraGrid1.Selected.Rows.Count; i++)
                {
                  
                    CheckedIsGridGroupRow(this.ultraGrid1.Selected.Rows[i], ref list);
                }
            }
            return list;
        }

        private ArrayList GetUpdateConditionSaleOrg()
        {
            ArrayList list = new ArrayList();
            if (this.ultraGrid1.Rows.Count == 0)
                return list;
            UltraGridRow ugr = this.ultraGrid1.ActiveRow;
            if (ugr == null)
                return list;
            if (this.ultraGrid1.Selected.Rows.Count == 0)
            {
                CheckedIsGridGroupRowSaleOrg(ugr, ref list);
            }
            else
            {
                for (int i = 0; i < this.ultraGrid1.Selected.Rows.Count; i++)
                {
                    CheckedIsGridGroupRowSaleOrg(this.ultraGrid1.Selected.Rows[i], ref list);
                }
            }
            return list;
        }

        private void CheckedIsGridGroupRow(UltraGridRow ugr, ref ArrayList ar1)
        {
            if (ugr is UltraGridGroupByRow)
            {
                for (int i = 0; i < ugr.ChildBands[0].Rows.Count; i++)
                {
                    CheckedIsGridGroupRow(ugr.ChildBands[0].Rows[i], ref ar1);
                }
            }
            else
            {
              


                    ar1.Add(new string[]{
              ugr.Cells[this.ORD_NO].Value.ToString(),
               ugr.Cells[this.ORD_SEQ].Value.ToString(),
            ugr.Cells[this.ORD_LN_DLY].Value.ToString(),
             ugr.Cells[this.ASKPLAN_ID].Value.ToString(),
             ugr.Cells[this.ASKPLAN_ID_SEQ].Value.ToString(),
             ugr.Cells[this.SPETKEY].Value.ToString(),
             ugr.Cells[this.STEELCODEKEY].Value.ToString(),
              ugr.Cells[this.BUYERCODE].Value.ToString(),
              ugr.Cells[this.PRICE].Value.ToString(),
               ugr.Cells[this.BALANCESTATUS].Value.ToString(),
                 ugr.Cells["ORD_PK"].Value.ToString(),
              ugr.Cells["ORD_LN_PK"].Value.ToString(),
               ugr.Cells["ORD_LN_DLY_PK"].Value.ToString(),
                 ugr.Cells["BALANCESTATUS_ORG"].Value.ToString(),
                  ugr.Cells["CUSTOMER_NO"].Value.ToString(),
                 ugr.Cells["SALE_AREA_NO"].Value.ToString(),
                   ugr.Cells["FST_DRAWEE_UNIT"].Value.ToString(),
                      ugr.Cells["FORECORPCODE"].Value.ToString(),
                       ugr.Cells["LISTNUMBER"].Value.ToString(),
                       ugr.Cells["MONEY_TYPE"].Value.ToString()

                });
                
            }
        }


        private void CheckedIsGridGroupRowSaleOrg(UltraGridRow ugr, ref ArrayList ar1)
        {
            if (ugr is UltraGridGroupByRow)
            {
                for (int i = 0; i < ugr.ChildBands[0].Rows.Count; i++)
                {
                    CheckedIsGridGroupRowSaleOrg(ugr.ChildBands[0].Rows[i], ref ar1);
                }
            }
            else
            {
               
                    ar1.Add(new string[]{
              ugr.Cells[this.ORD_NO].Value.ToString(),
               ugr.Cells[this.ORD_SEQ].Value.ToString(),
            ugr.Cells[this.ORD_LN_DLY].Value.ToString(),
             ugr.Cells[this.ASKPLAN_ID].Value.ToString(),
             ugr.Cells[this.ASKPLAN_ID_SEQ].Value.ToString(),
             ugr.Cells[this.SPETKEY].Value.ToString(),
             ugr.Cells[this.STEELCODEKEY].Value.ToString(),
              ugr.Cells[this.BUYERCODE].Value.ToString(),
              ugr.Cells["PRICE_ORG"].Value.ToString(),
               ugr.Cells[this.BALANCESTATUS].Value.ToString(),
                 ugr.Cells["ORD_PK"].Value.ToString(),
              ugr.Cells["ORD_LN_PK"].Value.ToString(),
               ugr.Cells["ORD_LN_DLY_PK"].Value.ToString(),
                 ugr.Cells["BALANCESTATUS_ORG"].Value.ToString(),
                  ugr.Cells["CUSTOMER_NO"].Value.ToString(),
                 ugr.Cells["SALE_AREA_NO"].Value.ToString(),
                   ugr.Cells["FST_DRAWEE_UNIT"].Value.ToString(),
                      ugr.Cells["FORECORPCODE"].Value.ToString(),
                       ugr.Cells["LISTNUMBER"].Value.ToString(),
                         ugr.Cells["MONEY_TYPE"].Value.ToString()
                });
                
            }
        }

        


        private void UpdatePrice()
        {
            if (this.ultraGrid1.Rows.Count == 0)
                return;
            Infragistics.Win.UltraWinGrid.UltraGridRow ugr = this.ultraGrid1.ActiveRow;
            double price = Convert.ToDouble(this.ultraNumericEditor1.Value);
            string reason = this.textBox2.Text.Trim();
            if (reason.Length == 0)
            {
                MessageBox.Show("请输入调整原因");
                return;
            }
            if (price == 0)
                return;
            string errMsg = "";
            string orderno = ugr.Cells[this.ORD_NO].Value.ToString();
            string ord_seq = ugr.Cells[this.ORD_SEQ].Value.ToString();
            string ord_ln = ugr.Cells[this.ORD_LN_DLY].Value.ToString();
            string askplanId = ugr.Cells[this.ASKPLAN_ID].Value.ToString();
            string askPlanIdSeq = ugr.Cells[this.ASKPLAN_ID_SEQ].Value.ToString();
            string spetKey = ugr.Cells[this.SPETKEY].Value.ToString();
            string steelcodekey = ugr.Cells[this.STEELCODEKEY].Value.ToString();
            string person = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName();
            this.slmBalanceInfo.UpdatePrice(orderno, ord_seq, ord_ln, askplanId, askPlanIdSeq, spetKey, steelcodekey,
                price, reason, person, out errMsg);
            if (errMsg.Length == 0)
            {
                MessageBox.Show("修改成功");
                ugr.Cells[this.PRICE].Value = Math.Round(price,this.saveDigit);
                ugr.Cells[this.MONEY].Value = Math.Round(Convert.ToDouble(ugr.Cells[this.WEIGHT].Value) * price, this.saveDigit);
                ugr.Cells[this.ADJUSTPRICEREASON].Value = reason;
            }
         

        }

        private string[] GetGridThreeDataStruct()
        {
            return new string[] 
            {
                "ASKPLAN_ID",
                "TALLYSHEET_NO",
               // "ORD_LN_DLY",    
                "BATCH_NO",
                "QUANTITY",
                "ACT_WGT"            
            };
        }     


        /// <summary>
        /// 价格由专门的人员维护，结算人员只需要进行编单
        /// 但是也提供价格调整功能，只是调整原因必须输入，见UpdatePrice
        /// </summary>

        private void InputPrice()
        {
            if (this.ultraGrid1.Rows.Count == 0)
                return;
            Infragistics.Win.UltraWinGrid.UltraGridRow ugr = this.ultraGrid1.ActiveRow;
            double price = Convert.ToDouble(this.ultraNumericEditor1.Value);
            string reason = this.textBox2.Text.Trim();
            if (price == 0)
                return;
            string errMsg = "";
            string orderno = ugr.Cells[this.ORD_NO].Value.ToString();
            string ord_seq = ugr.Cells[this.ORD_SEQ].Value.ToString();
            string ord_ln = ugr.Cells[this.ORD_LN_DLY].Value.ToString();
            string askplanId = ugr.Cells[this.ASKPLAN_ID].Value.ToString();
            string askPlanIdSeq = ugr.Cells[this.ASKPLAN_ID_SEQ].Value.ToString();
            string spetKey = ugr.Cells[this.SPETKEY].Value.ToString();
            string steelcodekey = ugr.Cells[this.STEELCODEKEY].Value.ToString();
            string person = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName();
            this.slmBalanceInfo.inputPrice(orderno, ord_seq, ord_ln, askplanId, askPlanIdSeq, spetKey, steelcodekey,
                price, person, out errMsg);
            if (errMsg.Length == 0)
            {
                MessageBox.Show("修改成功");
                ugr.Cells[this.PRICE].Value = Math.Round(price, this.saveDigit);
                ugr.Cells[this.MONEY].Value = Math.Round(Convert.ToDouble(ugr.Cells[this.WEIGHT].Value) * price, this.saveDigit);
                ugr.Cells[this.ADJUSTPRICEREASON].Value = reason;
            }


        }

      


        private string[] GetGrid1DataStruct()
        {
            return GetBalanceMainColumn();
        }



        private string[] GetUnAcceptBalaceColumn()
        {
            return new string[] 
            {
                 "LISTNUMBER",
                  "ASKPLAN_ID",
                     "SEND_NUM",
              //  "ORDER_UNIT",
                "QUANTITY",
                "WEIGHT",
                "MONEY",
                "OUTWEIGHT",
                "OUTSTOCKMNY",
                "TRANSMONEY",
                "TRANS_TYPE_NAME",
                   "SALE_AREA_DESC",
                 "BUYERNAME",
                 "INCEPTCORPCODE",
                 "SUPPLY_UNIT_DESC"
            };
        }


        private string[] GetBalanceMainColumn()
        {
            return new string[]
            { 
                 "ASKPLAN_ID",
                  LISTNUMBER,
                "MONEY_TYPE",
                 "SALE_AREA_DESC",
                    "FORECORPCODE",
                "BUYERCODE",
                 "BUYERNAME",
                 "SUPPLY_UNIT_DESC",
                 "FST_DRAWEE_UNIT",                 
                "ORD_NO",
                "ORD_SEQ",
                "ORD_LN_DLY",               
                "ASKPLAN_ID_SEQ",    
                 "STEELCODEKEY",
                 "PACTINDEX",
                 "SPETKEY",  
                "SEND_NUM",
                "ORDER_UNIT",
                "QUANTITY",
                "WEIGHT",
                "BALNCE_PRICE_STS",
                "BALNCE_PRICE_ORG_STS",
                "PRICE",
                "MONEY",
                  "PRICE_ORG",
                "MONEY_ORG",
                "CONTAIN_TAX",
                  "CATEGORY",
                "SPEC_ABBSYMNAME",
                "STD_STYLE_DESC",                 
                "MODEL_DESC",                      
                   "TRANS_TYPE_NAME",
              "ADJUSTPRICEPERSON",
                "ADJUSTPRICEREASON",
                "BASEPRICE",
                "INCEPTCORPCODE",
             //   "STATIONCODE",
                 "BALANCESTATUS_ORG",
                "AFFRIMPERSON_ORG",
                "AFFIRMTIME_ORG",
                   "BALANCESTATUS",
                 "AFFRIMPERSON",
                "AFFIRMTIME",
             //   "AREACODE",
           //     "DOCKCODE",
          //      "SHIPNO",
               // "FIXSIZE",
             
              
                "INVOICENO_ORG",
                "REALINVOICENO_ORG",
                "ORD_PK",
                "ORD_LN_PK",
                "ORD_LN_DLY_PK",
                 "CUSTOMER_NO",
                "CUSTOMER_NM",
                "SALE_AREA_NO"
               
                
            };
        }


        private string BUYERCODE = "BUYERCODE";
        private string ORD_NO = "ORD_NO";
        private string ORD_SEQ = "ORD_SEQ";
        private string ORD_LN_DLY = "ORD_LN_DLY";
        private string ASKPLAN_ID = "ASKPLAN_ID";
        private string ASKPLAN_ID_SEQ = "ASKPLAN_ID_SEQ";
        private string SPETKEY = "SPETKEY";
        private string STEELCODEKEY = "STEELCODEKEY";
        private string MONEY = "MONEY";
        private string WEIGHT = "WEIGHT";
        private string PRICE = "PRICE";
        private string BALANCESTATUS = "BALANCESTATUS";
        private string ADJUSTPRICEREASON = "ADJUSTPRICEREASON";

        private string BALANCESTATUS_INIT = "0";
        private string BALANCESTATUS_AFFRIM = "2";
        private string BALANCESTATUS_INVOINCE = "3";




        private string[] GetGrid2DataStruct()
        {
            return new string[]
            {
                "ORDERNO",
                "PLY",
                "WIDTH",
                "LENGTH",
                "STEELCODE",
                "WEIGHT",
                "QUANTITY",
                "BASEPRICE",
                "PRICE",
                 "MONEY",
                  "HOISTINGFEE",
                "CARFMONEY",
                 "SHIPPRICE",
                "TRANSMONEYQC",
                "TRANSMONEYSY1",
                 "TRANSMONETRAIN"
            }
            ;
        }

      

        private Hashtable GetColumnAndCaption()
        {
            Hashtable hs = new Hashtable();
            hs.Add("SHIPNO", "船号");
            hs.Add("WEIGHT", "重量");
            hs.Add("DOCKCODE", "港口");     
             hs.Add("TRANSMONEYSY1", "船运费");    
              hs.Add("SHIPPRICE", "船运价");
              hs.Add("PLY", "厚/直径/壁厚");
              hs.Add("WIDTH", "宽/外径");
              hs.Add("HOISTINGFEE", "吊装费");
              hs.Add("TRANSMONETRAIN", "火运费");


              hs.Add("ORD_NO", "合同号");
              hs.Add("ORD_SEQ", "合同行");
              hs.Add("ORD_LN_DLY", "交货行");
              hs.Add("ASKPLAN_ID", "提单号");
              hs.Add("ASKPLAN_ID_SEQ", "提单序号");

              hs.Add("SPETKEY", "规格");
              hs.Add("STEELCODEKEY", " 钢级(牌号)");
              hs.Add("ADJUSTPRICEPERSON", "调价人");
              hs.Add("ADJUSTPRICEREASON", "调价原因");
              hs.Add("AFFRIMPERSON", "末次确认人");
              hs.Add("AFFIRMTIME", "末次确认时间");
              hs.Add("AFFRIMPERSON_ORG", "首次确认人");
              hs.Add("AFFIRMTIME_ORG", "首次确认时间");
              hs.Add("BASEPRICE", "订单价");
              hs.Add("FORECORPCODE", "子公司");
              hs.Add("STATIONCODE", "到站");
              hs.Add("BUYERNAME", "结算单位名称");
              hs.Add("BUYERCODE", "客户编码");
              hs.Add("CUSTOMER_NM", "订货单位");
              hs.Add("TRANS_TYPE_NAME", "运输方式");

              hs.Add("MONEY_ORG", "首次结算金额");
              hs.Add("PRICE_ORG", "首次结算价");

              hs.Add("CATEGORY", "品名");
              hs.Add("SPEC_ABBSYMNAME", "标准");
              hs.Add("STD_STYLE_DESC", "标准类别");
              hs.Add("MODEL_DESC", "扣型");
              hs.Add("ORDER_UNIT", "计量单位");
              hs.Add("SALE_AREA_DESC", "销售区域");
              hs.Add("SEND_NUM", "实发量");
              hs.Add("CONTAIN_TAX", "是否含税");
              hs.Add("BALANCESTATUS_ORG", "首次结算状态");

              hs.Add("FST_DRAWEE_UNIT", "首次受票人");
              hs.Add("INVOICENO_ORG", "首次结算单号");
              hs.Add("REALINVOICENO_ORG", "首次真实单号");

              hs.Add("BALNCE_PRICE_STS", "末次价格有效性");
              hs.Add("BALNCE_PRICE_ORG_STS", "首次价格有效性");
             hs.Add("PACTINDEX", "钢种");

             hs.Add("OUTWEIGHT", "出库费(重量)");
             hs.Add("OUTSTOCKMNY", "出库费(金额)");
             hs.Add("MONEY_TYPE", "类型"); 

            hs.Add("SUPPLY_UNIT_DESC", "制造商"); 
            return hs;

          
        }

        protected override List<string> GetGridColumnListHidden()
        {
            List<string> list = new List<string>();
            list.Add(this.ASKPLAN_ID_SEQ);
            list.Add(this.BALANCESTATUS);
            return list;
       
        }

        private void SetGridShowLength()
        {
            Hashtable hs = StaticData.TbColumnAndCaption.GetDataSetColumnLength();
            try
            {
                foreach (string s in hs.Keys)
                {
                    try
                    {
                        this.ultraGrid1.DisplayLayout.Bands[0].Columns[s].Width =
                           (int) Util.ConverObject.ConvertToDouble(hs[s]);
                    }
                    catch
                    { }
                    try
                    {
                       // this.ultraGrid2.DisplayLayout.Bands[0].Columns[s].Width = (int)Util.ConverObject.ConvertToDouble(hs[s]);
                    }
                    catch
                    { }
                    try
                    {
                        this.ultraGrid3.DisplayLayout.Bands[0].Columns[s].Width = (int)Util.ConverObject.ConvertToDouble(hs[s]);
                    }
                    catch
                    { }
                }

            }
            catch
            { }
        }

        private string[] GetGridFiveDataStruct()
        {
            return new string[] 
            {
              "TICKETTYPE",
                "MONEY",
              //  "TICKETNUM",             
                 "MONEY_TYPE",              
                "TRANS_TYPE",
           //     "MOTORMANNAME",
                "REG_ID",
                "REG_DTIME",
                "AFFRIM_ID",
                "AFFRIM_TIME",
                "STATUS_CD"
            };
        }
        protected override Hashtable GetGridColumnLength()
        {
            return StaticData.TbColumnAndCaption.GetDataSetColumnLength();
        }

        private void QueryGridThree()
        {
            this.dsGridThree.Clear();
            if (this.ultraGrid1.Rows.Count == 0)
                return;
            Infragistics.Win.UltraWinGrid.UltraGridRow ugr = this.ultraGrid1.ActiveRow;
            if (ugr == null)
                ugr = this.ultraGrid1.Rows[0];
           
            string orderno = ugr.Cells[this.ORD_NO].Value.ToString();
            string orderseq = ugr.Cells[this.ORD_SEQ].Value.ToString();
            string orderlineseq = ugr.Cells[this.ORD_LN_DLY].Value.ToString();
            string askplanid = ugr.Cells[this.ASKPLAN_ID].Value.ToString();
            string askplanidseq = ugr.Cells[this.ASKPLAN_ID_SEQ].Value.ToString();
            string spetkey = ugr.Cells[this.SPETKEY].Value.ToString();
            string steelkey = ugr.Cells[this.STEELCODEKEY].Value.ToString();

         
            DataSet dsDetail =
                this.slmBalanceInfo.GetSlmBalanceDetailAllGroupByBatchNo(
                orderno, orderseq, orderlineseq, askplanid, askplanidseq, spetkey, steelkey);
            Util.UtilDataSet.SetDataSetByMergeSameColumnName(ref this.dsGridThree, dsDetail);



        }

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            QueryGridThree();
            QueryGridFive();
            QueryGridFour();
            Infragistics.Win.UltraWinGrid.UltraGridRow ugr = null;
            if (this.ultraGrid1.Rows.Count == 0)
                return;
            if (this.ultraGrid1.Rows.Count == 1)
                ugr = this.ultraGrid1.Rows[0];
            else
                ugr = this.ultraGrid1.ActiveRow;
            double price = Util.ConverObject.ConvertToDouble(ugr.Cells[this.PRICE].Value);
            string adjustReason = ugr.Cells[this.ADJUSTPRICEREASON].Value.ToString();
            this.ultraNumericEditor1.Value = price;
            this.textBox2.Text = adjustReason;
        }

      

        private void FrmBalanceTicketMgt_Shown(object sender, EventArgs e)
        {
         
            HiddenToolbars();

            if (!(base.GetSaleOrgDesc() == "国贸公司"))
            {
                string[] keys = new string[] { "QueryOrg", "AffrimOrg", "UnAffrimOrg",
                "InvoiceOrg","SetPriceOrg","ExportPrice","Export","AcpRllRecord"};
                try
                {
                    foreach (string s in keys)
                    {
                        toolMenu.Toolbars[0].Tools[s].SharedProps.Visible = true;
                    }
                }
                catch
                { }

                try
                {
                    if (cusInfo == "2")
                    {
                        toolMenu.Toolbars[0].Tools["Accept"].SharedProps.Visible = true;
                        toolMenu.Toolbars[0].Tools["QueryUnAcept"].SharedProps.Visible = true;
                        // toolMenu.Toolbars[0].Tools["UnAccept"].SharedProps.Visible = true;
                    }
                    else
                    {
                        toolMenu.Toolbars[0].Tools["Accept"].SharedProps.Visible = false;
                        toolMenu.Toolbars[0].Tools["QueryUnAcept"].SharedProps.Visible = false;
                     //   toolMenu.Toolbars[0].Tools["UnAccept"].SharedProps.Visible = false;
                    }
                }
                catch
                {
                }

            }

        }

        private void ultraGrid1_AfterRowActivate_1(object sender, EventArgs e)
        {
            QueryGridThree();
            QueryGridFive();
            QueryGridFour();
            Infragistics.Win.UltraWinGrid.UltraGridRow ugr = null;
            if (this.ultraGrid1.Rows.Count == 0)
                return;
            if (this.ultraGrid1.Rows.Count == 1)
                ugr = this.ultraGrid1.Rows[0];
            else
                ugr = this.ultraGrid1.ActiveRow;
            double price = Util.ConverObject.ConvertToDouble(ugr.Cells[this.PRICE].Value);
            string adjustReason = ugr.Cells[this.ADJUSTPRICEREASON].Value.ToString();
            this.ultraNumericEditor1.Value = price;
            this.textBox2.Text = adjustReason;

        }

        private void groupBox1_Enter(object sender, EventArgs e)
        {

        }

        private void textBox7_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (e.KeyChar == 13)
            {
                if (cusInfo  == "2")
                    this.Query();
                else
                    this.QueryOrg();
            }
        }

        private void textBox1_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (e.KeyChar == 13)
            {
                if (cusInfo == "2")
                    this.Query();
                else
                    this.QueryOrg();
            }
        }

        private void radioButton1_CheckedChanged(object sender, EventArgs e)
        {
            if (cusInfo == "2")
             this.Query();
            else
                this.QueryOrg();
        }

        private void radioButton2_CheckedChanged(object sender, EventArgs e)
        {
            if (cusInfo == "2")
                this.Query();
            else
                this.QueryOrg();
        }

        private void checkBox1_CheckedChanged(object sender, EventArgs e)
        {
           
        }




        private void SetToolBars()
        {
            string[] keys = new string[] { "QueryOrg", "AffrimOrg", "UnAffrimOrg",
            "InvoiceOrg","SetPriceOrg","ExportPrice","Export"};

            if (ultraTabControl1.SelectedTab.Index == 0)
            {
                this.textBox1.ReadOnly = true;
                this.radioButton1.Visible = false;
                this.radioButton2.Visible = false;

                try
                {
                    toolMenu.Toolbars[0].Tools["Accept"].SharedProps.Visible = true;
                    toolMenu.Toolbars[0].Tools["QueryUnAcept"].SharedProps.Visible = true;
                //    toolMenu.Toolbars[0].Tools["UnAccept"].SharedProps.Visible = false;
                }
                catch
                {
                }

              

                foreach (string s in keys)
                {
                    try
                    {
                        toolMenu.Toolbars[0].Tools[s].SharedProps.Visible = false;

                    }
                    catch
                    { 
                    }
                }
            }

            if (ultraTabControl1.SelectedTab.Index == 1)
            {
                this.textBox1.ReadOnly = false;
                this.radioButton1.Visible = true;
                this.radioButton2.Visible = true;

                try 
                {
                   
                        toolMenu.Toolbars[0].Tools["Accept"].SharedProps.Visible = false;
                        toolMenu.Toolbars[0].Tools["QueryUnAcept"].SharedProps.Visible = false;
                    //    toolMenu.Toolbars[0].Tools["UnAccept"].SharedProps.Visible = true;
                    
                    
                }
                catch
                { 
                }

              

                foreach (string s in keys)
                {
                    try
                    {
                        toolMenu.Toolbars[0].Tools[s].SharedProps.Visible = true;

                    }
                    catch
                    {
                    }
                }
            }

     
        }


   


        private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            if (cusInfo == "2")
            {
                if (ultraTabControl1.SelectedTab.Index == 0)
                {
                    this.textBox1.ReadOnly = true;
                    this.radioButton1.Visible = false;
                    this.radioButton2.Visible = false;
                    try
                    {
                        toolMenu.Toolbars[0].Tools["Accept"].SharedProps.Visible = true;
                        toolMenu.Toolbars[0].Tools["QueryUnAcept"].SharedProps.Visible = true;

                //        toolMenu.Toolbars[0].Tools["UnAccept"].SharedProps.Visible = false;

                        toolMenu.Toolbars[0].Tools["Affrim"].SharedProps.Visible = false;
                        toolMenu.Toolbars[0].Tools["UnAffrim"].SharedProps.Visible = false;

                        toolMenu.Toolbars[0].Tools["Invoice"].SharedProps.Visible = false;
                        toolMenu.Toolbars[0].Tools["SetPrice"].SharedProps.Visible = false;
                     //   toolMenu.Toolbars[0].Tools["Export"].SharedProps.Visible = false;
                        toolMenu.Toolbars[0].Tools["Query"].SharedProps.Visible = false;
                    }
                    catch
                    { }
                }
                else
                {
                    try
                    {
                        this.textBox1.ReadOnly = false;
                        this.radioButton1.Visible = true;
                        this.radioButton2.Visible = true;
                        toolMenu.Toolbars[0].Tools["Accept"].SharedProps.Visible = false;
                        toolMenu.Toolbars[0].Tools["QueryUnAcept"].SharedProps.Visible = false;

                        toolMenu.Toolbars[0].Tools["Affrim"].SharedProps.Visible = true;
                        toolMenu.Toolbars[0].Tools["UnAffrim"].SharedProps.Visible = true;

                        toolMenu.Toolbars[0].Tools["Invoice"].SharedProps.Visible = true;
                        toolMenu.Toolbars[0].Tools["SetPrice"].SharedProps.Visible = true;
                        toolMenu.Toolbars[0].Tools["Export"].SharedProps.Visible = true;
                     //   toolMenu.Toolbars[0].Tools["UnAccept"].SharedProps.Visible = true;

                        try
                        {
                            toolMenu.Toolbars[0].Tools["Query"].SharedProps.Visible = true;
                        }
                        catch
                        { }

                        try
                        {
                            toolMenu.Toolbars[0].Tools["AcpRllRecord"].SharedProps.Visible = true;
                        }
                        catch
                        { }
                        
                    }
                    catch
                    { }

                }
            }
            else if (cusInfo == "3")
                SetToolBars();
        }

        private void ultraGrid1_AfterRowActivate_2(object sender, EventArgs e)
        {
            QueryGridThree();
         //   QueryGridFive();
           // QueryGridFour();
            Infragistics.Win.UltraWinGrid.UltraGridRow ugr = null;
            if (this.ultraGrid1.Rows.Count == 0)
                return;
            if (this.ultraGrid1.Rows.Count == 1)
                ugr = this.ultraGrid1.Rows[0];
            else
                ugr = this.ultraGrid1.ActiveRow;
            double price = Util.ConverObject.ConvertToDouble(ugr.Cells[this.PRICE].Value);
            string adjustReason = ugr.Cells[this.ADJUSTPRICEREASON].Value.ToString();
            this.ultraNumericEditor1.Value = price;
            this.textBox2.Text = adjustReason;

        }
      
    }
}