MES_Client/TGMES/Core.StlMes.Client.Sale.UI.Balance/BalanceAccount/FrmBalanceTicketAffrim.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;

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

        private DataSet dsGridOne = new DataSet();
        private DataSet dsGridTwo = new DataSet();
        private DataSet dsGridThree = new DataSet();
        private DataSet dsGridFour = new DataSet();
        private DataSet dsGridFine = new DataSet();
        private DataSet dsBalance = null;

        private Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Balance.SlmBalanceInfo slmBalanceInfo = null;
        private Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.StaticData.PublicStaticVariable publicStaticVariable = null;
        private Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Trans.YdmZcLoadVehicleMatMgt ydmZcLoadVehicleMatMgt
         = null;


        private void InitDataSource()
        {
            this.dsGridOne = base.GetDataSetByColumnName(this.GetGridOneDataStruct(),
                StaticData.TbColumnAndCaption.GetDataSetColumnType(), StaticData.TbColumnAndCaption.GetColumnAndCaption());
            this.dsGridTwo = base.GetDataSetByColumnName(this.GetGridTwoDataStruct(),
                 StaticData.TbColumnAndCaption.GetDataSetColumnType(), StaticData.TbColumnAndCaption.GetColumnAndCaption());
            this.dsGridThree = base.GetDataSetByColumnName(this.GetGridThreeDataStruct(),
                StaticData.TbColumnAndCaption.GetDataSetColumnType(), StaticData.TbColumnAndCaption.GetColumnAndCaption());
            this.dsGridFour = base.GetDataSetByColumnName(this.GetGridFourDataStruct(),
                 StaticData.TbColumnAndCaption.GetDataSetColumnType(), StaticData.TbColumnAndCaption.GetColumnAndCaption());
            this.dsGridFine = base.GetDataSetByColumnName(this.GetGridFiveDataStruct(),
              GetDataSetColumnType(), GetDataSetColumnCaption());
            this.ultraGrid1.DataSource = this.dsGridOne;
            this.ultraGrid2.DataSource = this.dsGridTwo;
            this.ultraGrid3.DataSource = this.dsGridThree;
            this.ultraGrid4.DataSource = this.dsGridFour;
            this.ultraGrid5.DataSource = this.dsGridFine;
        }

        protected override List<string> GetGridColumnListHidden()
        {
            return new List<string>(new string[]{StaticData.TbColumnAndCaption.ASKPLAN_ID_SEQ});
        }

        private Hashtable GetDataSetColumnCaption()
        {
            Hashtable hs = new Hashtable();
            hs.Add(LOADVEHICLE_NO, "装车单号");
            hs.Add(BILL_NO, "提货单号");
            hs.Add(TICKETTYPE, "单据类型");
            hs.Add(TALLYSHEET_NO, "理货单号");
            hs.Add(LOADVEHICLE_TYPE, "发货单类型（1实际、2虚拟)");
            hs.Add(AFFIRM_FLAG, "确认标志（1确认、0未确认）");
            hs.Add(VEHICLE_NO, "车船号");
            hs.Add(TRANS_TYPE, "运输方式");
            hs.Add(RECEIV_NO, "收货单位编码");
            hs.Add(RECEIV_NM, "收货单位名称");
            hs.Add(STATION_NO, "到站");
            hs.Add(STATION_NM, "到站名称");
            hs.Add(SPCL_LN_NO, "专用线");
            hs.Add(SPCL_LN_NM, "专用线名称");
            hs.Add(PORT, "港口/码头");
            hs.Add(SHIP_LOT_NO, "船批号");
            hs.Add(PLANT, "出货工厂");
            hs.Add(PLANT_DESC, "出货工厂描述");
            hs.Add(VSTEL_CODE, "装运点");
            hs.Add(VSTEL_DESC, "装运点描述");
            hs.Add(CARRIER_NO, "承运单号");
            hs.Add(CARRY_COMPANY_CODE, "承运公司代码");
            hs.Add(CARRY_COMPANY_NAME, "承运公司名称");
            hs.Add(STACKING_WT, "发货单重量");
            hs.Add(STACKING_PIECE, "发货单支数");
            hs.Add(STACKING_TOTL_LEN, "发货单总长度");
            hs.Add(WEIGH_FLAG, "是否需过磅");
            hs.Add(PONDER_NO, "过磅单号");
            hs.Add(PONDER_GROSS_WT, "过磅重量");
            hs.Add(OUT_STOCK_CODE, "出库库区代码");
            hs.Add(DELIVY_PLACE_CODE, "交货点代码");
            hs.Add(DELIVY_PLACE_NAME, "交货点名称");
            hs.Add(STLMT_UNIT_NO, "结算单位编码");
            hs.Add(STLMT_UNIT_NM, "结算单位名称");
            hs.Add(INFACTORY_TIME, "进厂时间");
            hs.Add(LOAD_TIME, "装车时间");
            hs.Add(DELIVY_TIME, "出厂时间");
            hs.Add(STACKING_PRINTS, "打印次数");
            hs.Add(THREE_READY_NO, "单据结齐号");
            hs.Add(HANDHELD_NO, "手持编号");
            hs.Add(HANDHELD_FLAG, "手持标志（1：已发送，2：退回，3：完成）';");
            hs.Add(MANAGEMENT_NO, "管理单位代码");
            hs.Add(MANAGEMENT_NAME, "管理单位名称");
            hs.Add(MEMO, "备注");
            hs.Add(VALIDFLAG, "有效标志(1:有效，0:无效)");
            hs.Add(CREATE_NAME, "创建人");
            hs.Add(CREATE_TIME, "创建时间");
            hs.Add(UPDATE_NAME, "修改人");
            hs.Add(UPDATE_TIME, "修改时间");
            hs.Add(DELETE_NAME, "删除人");
            hs.Add(DELETE_TIME, "删除时间");
            hs.Add(SELECT, "选择");
            hs.Add(MONET_TYPE, "支付类型");
            hs.Add(TRANSMNY, "运费");
            hs.Add(TRANSNUM, "票据数");

            hs.Add(RECEIV_ADDR, "指定地点");
            hs.Add(DELVRY_ADDR, "交货地点");
            hs.Add(DELIVERY_NO, "交货行");
            hs.Add("PLID", "产线");
          




            return hs;

        }

        protected override Hashtable GetGridColumnLength()
        {
            return StaticData.TbColumnAndCaption.GetDataSetColumnLength();
        }

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





        private void FrmBalanceTicketAffrim_Load(object sender, EventArgs e)
        {
            this.radioButton1.Checked = true;
            PublicStaticVariable = new Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.StaticData.PublicStaticVariable(this.ob);
            ydmZcLoadVehicleMatMgt = new Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Trans.YdmZcLoadVehicleMatMgt(this.ob);
            this.dateTimePicker1.Value = System.DateTime.Now.AddDays(-30);
            InitDataSource();
            slmBalanceInfo = new Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Balance.SlmBalanceInfo(this.ob);
            HiddenColumn();
            this.ultraGrid4.DisplayLayout.Bands[0].Override.ColumnAutoSizeMode = Infragistics.Win.UltraWinGrid.ColumnAutoSizeMode.VisibleRows;
            base.SetGridStyle(ref this.ultraGrid1,ref this.ultraGrid2,ref this.ultraGrid3,ref this.ultraGrid4,ref this.ultraGrid5);
            InitGrid();
        }

        /// <summary>
        /// 是否代办
        /// </summary>
        /// <returns></returns>
        private Infragistics.Win.ValueList GetAgenCyFlList()
        {
            Infragistics.Win.ValueList lit = new Infragistics.Win.ValueList();
            lit.ValueListItems.Add("0", "否");
            lit.ValueListItems.Add("1", "是");
            return lit;
        }


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

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


            this.ultraGrid5.DisplayLayout.Bands[0].Columns[this.SPCL_LN_NO].ValueList
                = PublicStaticVariable.Static_SpecLine_Tg(true).GetValueListDB;
            this.ultraGrid5.DisplayLayout.Bands[0].Columns[this.STATION_NO].ValueList
                          = PublicStaticVariable.Static_StationNoAndName_Tg(true).GetValueListDB;

            transTypelist = PublicStaticVariable.Static_TransType_Tg(true).GetValueListDB;
            this.ultraGrid5.DisplayLayout.Bands[0].Columns["TRANS_TYPE"].ValueList
                          = transTypelist;
            this.ultraGrid5.DisplayLayout.Bands[0].Columns["AGENCY_FL"].ValueList
                        = GetAgenCyFl();
        }

        private Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.StaticData.PublicStaticVariable
         PublicStaticVariable = null;
        private Infragistics.Win.ValueList transTypelist = null;

        private Infragistics.Win.ValueList GetAgenCyFl()
        {
            Infragistics.Win.ValueList lit = new Infragistics.Win.ValueList();
            lit.ValueListItems.Add("0", "无客户代办");
            lit.ValueListItems.Add("1", "TPCO代办");
            lit.ValueListItems.Add("2", "客户代办");
            return lit;
        }


        private void SetGrid5TicketNumAndMoney(string billno)
        {
            if (this.dsGridFine == null || this.dsGridFine.Tables.Count == 0 || this.dsGridFine.Tables[0].Rows.Count == 0)
                return;
            DataSet ds = this.slmBalanceInfo.GetSlmBalanceTransMoneyAskPlanid(billno);
            ds = Util.UtilDataSet.GetDataSetWithRowFilter(ds, "MONEY_TYPE", "运费");
            if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
                return;
            double ticketnum = 0;
            double money = 0;
            foreach (DataRow dr in this.dsGridFine.Tables[0].Rows)
            {
                ticketnum = 0;
                money = 0;
                string rowfilter = string.Format(@"  ASKPLAN_ID = '{0}' and ORD_PK = '{1}' and 
                ORD_LN_PK = '{2}' and  ORD_LN_DLY_PK = '{3}' and  INDEX_SEQ = '{4}' ",

                    billno, dr[this.ORD_PK].ToString(), dr[this.ORD_LN_PK].ToString(), dr[this.ORD_LN_DLY_PK].ToString()
                    , dr[this.INDEX_SEQ].ToString());
                DataRow[] drs = ds.Tables[0].Select(rowfilter);
                if (drs == null || drs.Length == 0)
                    continue;
                foreach (DataRow drm in drs)
                {
                    ticketnum = ticketnum + Util.ConverObject.ConvertToDouble(drm["TICKETNUM"]);
                    money = money + Util.ConverObject.ConvertToDouble(drm["MONEY"]);
                }
                dr["TRANSMNY"] = money;



            }
        }


        private void HiddenColumn()
        {
            try
            {
                this.ultraGrid2.DisplayLayout.Bands[0].Columns["BALANCESTATUS"].Hidden = true;
                this.ultraGrid2.DisplayLayout.Bands[0].Columns["BALANCESTATUS_ORG"].Hidden = true;
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["BUYERCODE"].Hidden = true;
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["MONEY"].Hidden = true;


                this.ultraGrid5.DisplayLayout.Bands[0].Columns["ORD_PK"].Hidden = true;
                this.ultraGrid5.DisplayLayout.Bands[0].Columns["ORD_LN_PK"].Hidden = true;
                this.ultraGrid5.DisplayLayout.Bands[0].Columns["ORD_LN_DLY_PK"].Hidden = true;
             //   this.ultraGrid5.DisplayLayout.Bands[0].Columns["TRANSNUM"].Hidden = true;

                
                
            }
            catch
            { }
        }


        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            if (ToolbarKey == "Query")
            {
                this.QueryGridOne();
            }

            if (ToolbarKey == "Affrim")
            {
                this.Affrim();
            }

            if (ToolbarKey == "UnAffrim")
            {
                this.UnAffrim();
            }

            if (ToolbarKey == "RollBack")
            {
                this.RollBack();
            }

            if (ToolbarKey == "Exit")
            {
                this.Close();
            }

            if (ToolbarKey == "AffrimTrans")
            {
                this.AffrimTransMny();
            }

            if (ToolbarKey == "UpdateSendNum")
            {
               // this.UpdateSendNum();
            }
        }


        private void UpdateSendNum()
        {
            this.ultraGrid3.UpdateData();
            Infragistics.Win.UltraWinGrid.UltraGridRow ugr = null;
            string askPlanid = "";
            if (this.ultraGrid2.Rows.Count == 0)
                return;
            if (this.ultraGrid2.Rows.Count == 1)
                ugr = this.ultraGrid2.Rows[0];
            else
                ugr = this.ultraGrid2.ActiveRow;
            if (ugr == null)
            {
                Util.MessageUtil.ShowError("请选择需要修改的行");
                return;
            }
            if (Util.MessageUtil.ShowYesNoAndTips("是否确定修改") == DialogResult.No)
                return;
            string errMsg = "";
            if (this.ultraGrid3.Rows.Count == 0)
                return;
            double sendnum = 0;
            ArrayList list = new ArrayList();
            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugs in this.ultraGrid3.Rows)
            {
                if (Util.ConverObject.ConvertToDouble(ugs.Cells["SEND_NUM"].Value) == 0)
                {
                    Util.MessageUtil.ShowError("请填写修改实发数");
                    return;
                }
                string[] str = new string[2];
                str[0] = ugs.Cells["BATCH_NO"].Value.ToString();
                str[1] = ugs.Cells["SEND_NUM"].Value.ToString();
                list.Add(str);


                sendnum += Util.ConverObject.ConvertToDouble(ugs.Cells["SEND_NUM"].Value);

            }
            string val = sendnum + "";

          


            if (ugr.Cells["BALANCESTATUS"].Value.ToString() != "0" || ugr.Cells["BALANCESTATUS_ORG"].Value.ToString() != "0")
            {

                Util.MessageUtil.ShowError("该结算数据已经确认结算，请先取消再修改");
                return; 
 
            }
            this.slmBalanceInfo.UpdateSendNum(
                  ugr.Cells["ORD_NO"].Value.ToString(),
               ugr.Cells["ORD_SEQ"].Value.ToString(),
            ugr.Cells["ORD_LN_DLY"].Value.ToString(),
             ugr.Cells["ASKPLAN_ID"].Value.ToString(),
             ugr.Cells["ASKPLAN_ID_SEQ"].Value.ToString(),
             ugr.Cells["SPETKEY"].Value.ToString(),
             ugr.Cells["STEELCODEKEY"].Value.ToString(),
             val,list, CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName(), out errMsg);
            if (errMsg.Length == 0)
            {
                Util.MessageUtil.ShowTips("操作成功");
            }
            askPlanid =   ugr.Cells["ASKPLAN_ID"].Value.ToString();
            this.QueryGridOne();
            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugrr in this.ultraGrid1.Rows)
            {
                if (ugrr.Cells["ASKPLAN_ID"].Value.ToString() == askPlanid)
                {
                    ugrr.Activated = true;
                }
            }
        }


        private void AffrimTransMny()
        {
            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();
            this.slmBalanceInfo.AffrimTransMnyTicket(askPlanId, CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName());
            this.QueryGridOne();
        }


        private void Affrim()
        {
            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];

            ugr.Selected = true;

            ArrayList listask = new ArrayList();

            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugs in this.ultraGrid1.Selected.Rows)
            {
                listask.Add(ugs.Cells[StaticData.TbColumnAndCaption.ASKPLAN_ID].Value.ToString());
 
            }

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

            //if (!IsTranmoneyExists())
            //{
            //    return;
            //}

            foreach(string s in listask)
            {
            this.slmBalanceInfo.AffrimTicket(s, CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName());
            }
            this.QueryGridOne();
        }

        private Boolean IsTranmoneyExists()
        {
            if (this.ultraGrid5.Rows.Count == 0)
                return true;
            foreach( Infragistics.Win.UltraWinGrid.UltraGridRow ugr in this.ultraGrid5.Rows )
            {
                if ( Util.ConverObject.ConvertToDouble( ugr.Cells["TRANSMNY"].Value) == 0)
                {
                    Util.MessageUtil.ShowError("有运费暂无输入，请先维护运费");
                    return false;
                }
            }
            return true;
        }

        private void UnAffrim()
        {
            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();
            if (Util.MessageUtil.ShowYesNoAndQuestion("是否确定取消选定行？") == DialogResult.No) return;
            this.slmBalanceInfo.UnAffrimTicket(askPlanId, CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName());
            this.QueryGridOne();
        }
        private void RollBack()
        {
            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();
            if (Util.MessageUtil.ShowYesNoAndQuestion("是否确定回退提单？") == DialogResult.No) return;

            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugs in this.ultraGrid1.Selected.Rows)
            {
                askPlanId = ugs.Cells[StaticData.TbColumnAndCaption.ASKPLAN_ID].Value.ToString();
                this.slmBalanceInfo.RollBaskAskPlanId(askPlanId, CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName());
                ugs.Delete();
            }
         //   ugr.Delete();
            //this.QueryGridOne();
        }


        private void QueryGridFive()
        {
            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 dsDetail =
               this.ydmZcLoadVehicleMatMgt.GetDistinctOrderLineDeliveryTransitByBillNo(askPlanId);


            Util.UtilDataSet.SetDataSetByMergeSameColumnName(ref this.dsGridFine, dsDetail);
            this.SetGrid5TicketNumAndMoney(askPlanId);
            //DataSet ds = this.slmBalanceInfo.GetSlmBalanceTransMoneyAskPlanid(askPlanId);
            //ds = Util.UtilDataSet.GetDataSetWithRowFilter(ds, "MONEY_TYPE", "运费");
            //Util.UtilDataSet.SetDataSetByMergeSameColumnName(ref this.dsGridFine, ds);

        }

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

            if (ugr == null)
                return;

            //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();

            string askplanid = ugr.Cells[StaticData.TbColumnAndCaption.ASKPLAN_ID].Value.ToString();
            DataSet dsDetail =
                this.slmBalanceInfo.GetSlmBalanceDetailAllGroupByAskPlanId(askplanid);
              //  orderno, orderseq, orderlineseq, askplanid, askplanidseq, spetkey, steelkey);

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

 
        }

        private Infragistics.Win.UltraWinGrid.UltraGridRow GetUltraGrid2ActiveRow()
        {
            Infragistics.Win.UltraWinGrid.UltraGridRow ugr = null;
            if (this.ultraGrid2.Rows.Count == 0)
                return null ;
            ugr = this.ultraGrid2.ActiveRow;
            if (ugr == null)
                ugr = this.ultraGrid2.Rows[0];
            return ugr;
 
        }


        private void QueryGridThree()
        {
            Infragistics.Win.UltraWinGrid.UltraGridRow ugr = null;
            if(this.ultraGrid2.Rows.Count == 0)
                return;
            if (this.ultraGrid2.Rows.Count == 1)
                this.ultraGrid2.Rows[0].Activated = true;
            ugr = this.ultraGrid2.ActiveRow;
        
            if (ugr == null)
                return;
            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();
          //  string askplanid = ugr.Cells[StaticData.TbColumnAndCaption.ASKPLAN_ID].Value.ToString();
            DataSet dsDetail =
                this.slmBalanceInfo.GetSlmBalanceDetailAllGroupByBatchNo(orderno,orderseq,orderlineseq,
                askplanid,askplanidseq,spetkey,steelkey);
            Util.UtilDataSet.SetDataSetByMergeSameColumnName(ref this.dsGridThree, dsDetail);
            InitGird3(ugr.Cells["ORDER_UNIT"].Value.ToString());

         
 
        }

        private void InitGird3(String orderUnit)
        {
            if (orderUnit == "吨" || orderUnit == "支")
            {
                this.ultraGrid3.DisplayLayout.Bands[0].Columns["SEND_NUM"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
                this.ultraGrid3.DisplayLayout.Bands[0].Columns["SEND_NUM"].CellAppearance.BackColor =
                    this.ultraGrid1.DisplayLayout.Bands[0].Columns[0].CellAppearance.BackColor;
            }
            else
            {
                try
                {
                    this.ultraGrid3.DisplayLayout.Bands[0].Columns["SEND_NUM"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                    this.ultraGrid3.DisplayLayout.Bands[0].Columns["SEND_NUM"].CellAppearance.BackColor
                        = base.GetEditColor();
                    //     this.ultraGrid2.DisplayLayout.Bands[0].Columns["SEND_NUM"].MaskInput = "-nnnnnnnn.nnn";
                    //  this.ultraGrid2.DisplayLayout.Bands[0].Columns["SEND_NUM"].Format = "";
                }
                catch
                { }
            }
            

        }




        private void QueryGridTwo()
        {
            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 = Util.UtilDataSet.GetDataSetWithRowFilter(this.dsBalance,
                StaticData.TbColumnAndCaption.ASKPLAN_ID, askPlanId);
            Util.UtilDataSet.SetDataSetByMergeSameColumnName(ref this.dsGridTwo, ds);
        }


        private void SetTransMoney(ref  DataSet dsGridOne)
        {
            if (dsGridOne == null || dsGridOne.Tables.Count == 0 || dsGridOne.Tables[0].Rows.Count == 0)
                return;
            double money = 0;
            double outstockmoney = 0;
            foreach (DataRow dr in dsGridOne.Tables[0].Rows)
            {
                money = 0;
                outstockmoney = 0;
                string askPlanId = dr[StaticData.TbColumnAndCaption.ASKPLAN_ID].ToString();


                DataSet dsDetail =
             this.slmBalanceInfo.GetSlmBalanceDetailAllGroupByAskPlanId(askPlanId);

                try
                {
                    if (dsDetail.Tables[0].Rows.Count > 0)
                    {
                        foreach (DataRow dr1 in dsDetail.Tables[0].Rows)
                        {
                            outstockmoney += Util.ConverObject.ConvertToDouble(dr1["OUTSTOCKMNY"].ToString());

                        }

                        dr["OUTSTOCKMNY"] = outstockmoney;



                    }
                }
                catch
                { 
                }

                DataSet ds = this.slmBalanceInfo.GetSlmBalanceTransMoneyAskPlanid(askPlanId);
                ds = Util.UtilDataSet.GetDataSetWithRowFilter(ds, "MONEY_TYPE", "运费");
                if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
                    continue;
                foreach (DataRow dr0 in ds.Tables[0].Rows)
                {
                    money += Util.ConverObject.ConvertToDouble(dr0["MONEY"].ToString());
 
                }
                dr["TRANSMNY"] = money;

              
            }


              
          
           
        }

        private void ClearGrid()
        {

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

        private void QueryGridOne()
        {
            DataSet ds = null;
            Boolean exists = false;
            ArrayList list = new ArrayList();
            if (this.radioButton1.Checked)
            {
                ds = this.slmBalanceInfo.GetunAffrimTicketsSlmBalaneInfoByPlanBeginDateAndEndDate(this.dateTimePicker1.Value,
                    this.dateTimePicker2.Value);

                DataSet dsClosedAskpLanid = this.slmBalanceInfo.GetUnAffrimVirtualTicketsSlmBalaneInfoByPlanBeginDateAndEndDate(this.dateTimePicker1.Value,
                    this.dateTimePicker2.Value);
                try
                {
                    if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
                        ds = dsClosedAskpLanid;
                    else
                    {
                        foreach (DataRow dr in dsClosedAskpLanid.Tables[0].Rows)
                        {
                            if (ds.Tables[0].Select(string.Format("  ASKPLAN_ID = '{0}' ", dr["ASKPLAN_ID"].ToString())).Length == 0)
                            {
                                if (!list.Contains(dr["ASKPLAN_ID"].ToString()))
                                {
                                    list.Add(dr["ASKPLAN_ID"].ToString());
                                }
                            }

                        }
                        foreach (string s in list)
                        {
                            DataRow[] drs = dsClosedAskpLanid.Tables[0].Select(string.Format("  ASKPLAN_ID = '{0}' ", s));
                            foreach (DataRow drss in drs)
                            {
                                ds.Tables[0].Rows.Add(drss.ItemArray);
                            }
                        }
                       
                    }
                }
                catch
                { 
                }
            }
            if (this.radioButton2.Checked)
            {
                ds = this.slmBalanceInfo.GetAffrimTicketsSlmBalaneInfoByPlanBeginDateAndEndDate(this.dateTimePicker1.Value,
                    this.dateTimePicker2.Value);
            }

            if (this.textBox7.Text.Length > 0)
            {
                ds = Util.UtilDataSet.GetDataSetWithRowFilterWithApproximateMatch(ds,
                    StaticData.TbColumnAndCaption.ASKPLAN_ID, this.textBox7.Text.Trim());
            }
            if (this.textBox1.Text.Length > 0)
            {
                ds = Util.UtilDataSet.GetDataSetWithRowFilterWithApproximateMatch(ds,
                    StaticData.TbColumnAndCaption.ORD_NO, this.textBox1.Text.Trim());
            }
            if (!this.UserInfo.GetUserName().Equals("admin"))
            {
                ds = base.GetDataSetByFilterDeptId(ds);
            }
            this.dsBalance = ds.Copy();
            ds = Util.UtilDataSet.GetDateSetByGroupColumnAndStaticsColumnName(ds,
                new List<string>(GetGridOneGroupColumn()),
               null,
                new List<string>(new string[]{StaticData.TbColumnAndCaption.QUANTITY,
                StaticData.TbColumnAndCaption.WEIGHT,
                 StaticData.TbColumnAndCaption.MONEY}));
            Util.UtilDataSet.SetDataSetByMergeSameColumnName(ref this.dsGridOne, ds);

            SetTransMoney(ref this.dsGridOne);
            ClearGrid();

        
        }

        private string[] GetGridOneGroupColumn()
        {
            return new string[] 
            {
                StaticData.TbColumnAndCaption.ASKPLAN_ID,
                StaticData.TbColumnAndCaption.BUYERCODE,
                 StaticData.TbColumnAndCaption.BUYERNAME,
                StaticData.TbColumnAndCaption.INCEPTCORPCODE,
                StaticData.TbColumnAndCaption.ISPRECLOSE,
                "ISREALCLOSE",
                "TICKETSTATUS"
            };
        }

        private Hashtable GetDataSetColumnType()
        {
            Hashtable hs = new Hashtable();
            hs.Add("SELECT", "System.Boolean");
            hs.Add("TRANSMNY", "System.String");
            hs.Add("MONEY", "System.String");
            hs.Add("TICKETNUM", "System.String");
            hs.Add("TRANSNUM", "System.String");
            return hs;
        }
             



        private string[] GetGridFiveDataStruct()
        {
            return new string[] 
            {
            //  "TICKETTYPE",
            //    "MONEY",
            //    "TICKETNUM",             
            //     "MONEY_TYPE",              
            //    "TRANS_TYPE",
            //    "MOTORMANNAME",
            //    "REG_ID",
            //    "REG_DTIME",
            // //   "AFFRIM_ID",
            ////    "AFFRIM_TIME",
            //    "STATUS_CD"
             "TRANSMNY",
          //    " TRANSNUM",    
                "TRANS_TYPE",
                "AGENCY_FL",
                "DESTINATION",
                "STATION_NO",
                "SPCL_LN_NO",
                  "DESTINATION",
                "PORT_NO",
             //   "CARRIER_UNIT",
                "RECEIVOR",
                "RECEIV_ADDR",
                "DELVRY_ADDR",
                "ORD_PK",
                "ORD_LN_PK",
                "ORD_LN_DLY_PK",
                   "ORDER_NO",
                "ORDER_SEQ",
                "DELIVERY_NO",
                "INDEX_SEQ"
            };
        }

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

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

     

        private string[] GetGridTwoDataStruct()
        {
            return new string[]
            { 
             //   "BUYERCODE",
                "ORD_NO",
                "ORD_SEQ",
                "ORD_LN_DLY",
                "ASKPLAN_ID",
                "ASKPLAN_ID_SEQ",
                   "CATEGORY",
                "SPEC_ABBSYMNAME",
                "STD_STYLE_DESC",     
                  "STEELCODEKEY",
                "MODEL_DESC",      
                "SPETKEY",              
               "SEND_NUM",
                "QUANTITY",
                "WEIGHT",
                 "ORDER_UNIT",
              //  "PRICE",
            //    "MONEY",              
            //    "BASEPRICE",            
             //   "STATIONCODE",
                "TICKETPERSON",
                "TICKETDATE",
                "FORECORPCODE",
                   "TRANS_TYPE_NAME",
                   "BALANCESTATUS_ORG",
            //    "AREACODE",
             //   "DOCKCODE",
             //   "SHIPNO",
            //    "FIXSIZE",
                "BALANCESTATUS"                
            };
        }

        private string[] GetGridOneDataStruct()
        {
            return new string[] 
            {
                "ASKPLAN_ID",
                "BUYERCODE",
                "BUYERNAME",
                "INCEPTCORPCODE",
                "QUANTITY",
                "WEIGHT",
                "MONEY",              
                "OUTSTOCKMNY",
                "TRANSMNY",
                 "ISPRECLOSE",
                 "ISREALCLOSE",
                 "TICKETSTATUS"
            };
        }

        private string SELECT = "SELECT";
        private string MONET_TYPE = "MONET_TYPE";
        private string TICKETNO = "TICKETNO";
        private string OUTSTOCKMNY = "OUTSTOCKMNY";

        private string DZFMNY = "DZFMNY";
        private string TRANSMNY = "TRANSMNY";
        private string TRANSNUM = "TRANSNUM";

        private string LOADVEHICLE_NO = "LOADVEHICLE_NO";
        private string BILL_NO = "BILL_NO";
        private string TALLYSHEET_NO = "TALLYSHEET_NO";
        private string LOADVEHICLE_TYPE = "LOADVEHICLE_TYPE";
        private string AFFIRM_FLAG = "AFFIRM_FLAG";
        private string VEHICLE_NO = "VEHICLE_NO";
        private string TRANS_TYPE = "TRANS_TYPE";
        private string RECEIV_NO = "RECEIV_NO";
        private string RECEIV_NM = "RECEIV_NM";
        private string STATION_NO = "STATION_NO";
        private string STATION_NM = "STATION_NM";
        private string SPCL_LN_NO = "SPCL_LN_NO";
        private string SPCL_LN_NM = "SPCL_LN_NM";
        private string PORT = "PORT";
        private string SHIP_LOT_NO = "SHIP_LOT_NO";
        private string PLANT = "PLANT";
        private string PLANT_DESC = "PLANT_DESC";
        private string VSTEL_CODE = "VSTEL_CODE";
        private string VSTEL_DESC = "VSTEL_DESC";
        private string CARRIER_NO = "CARRIER_NO";
        private string CARRY_COMPANY_CODE = "CARRY_COMPANY_CODE";
        private string CARRY_COMPANY_NAME = "CARRY_COMPANY_NAME";
        private string STACKING_WT = "STACKING_WT";
        private string STACKING_PIECE = "STACKING_PIECE";
        private string STACKING_TOTL_LEN = "STACKING_TOTL_LEN";
        private string WEIGH_FLAG = "WEIGH_FLAG";
        private string PONDER_NO = "PONDER_NO";
        private string PONDER_GROSS_WT = "PONDER_GROSS_WT";
        private string OUT_STOCK_CODE = "OUT_STOCK_CODE";
        private string DELIVY_PLACE_CODE = "DELIVY_PLACE_CODE";
        private string DELIVY_PLACE_NAME = "DELIVY_PLACE_NAME";
        private string STLMT_UNIT_NO = "STLMT_UNIT_NO";
        private string STLMT_UNIT_NM = "STLMT_UNIT_NM";
        private string INFACTORY_TIME = "INFACTORY_TIME";
        private string LOAD_TIME = "LOAD_TIME";
        private string DELIVY_TIME = "DELIVY_TIME";
        private string STACKING_PRINTS = "STACKING_PRINTS";
        private string THREE_READY_NO = "THREE_READY_NO";
        private string HANDHELD_NO = "HANDHELD_NO";
        private string HANDHELD_FLAG = "HANDHELD_FLAG";
        private string MANAGEMENT_NO = "MANAGEMENT_NO";
        private string MANAGEMENT_NAME = "MANAGEMENT_NAME";
        private string MEMO = "MEMO";
        private string VALIDFLAG = "VALIDFLAG";
        private string CREATE_NAME = "CREATE_NAME";
        private string CREATE_TIME = "CREATE_TIME";
        private string UPDATE_NAME = "UPDATE_NAME";
        private string UPDATE_TIME = "UPDATE_TIME";
        private string DELETE_NAME = "DELETE_NAME";
        private string DELETE_TIME = "DELETE_TIME";

        private string TRANS_PK = "TRANS_PK";
        private string ASKPLAN_ID = "ASKPLAN_ID";

        private string TRAINWAGON = "TRAINWAGON";
        private string BUYERCODE = "BUYERCODE";
        private string BUYERNAME = "BUYERNAME";
        private string FORECORPCODE = "FORECORPCODE";
        private string FORECORPNAME = "FORECORPNAME";
        private string FST_DRAWEE_UNIT = "FST_DRAWEE_UNIT";
        private string STATIONCODE = "STATIONCODE";
        private string STATIONNAME = "STATIONNAME";
        private string LEASEDLINE = "LEASEDLINE";
        private string LEASEDLINENAME = "LEASEDLINENAME";
        private string INCEPTCORPCODE = "INCEPTCORPCODE";
        private string MOTORMANNAME = "MOTORMANNAME";
        private string DOCKNAME = "DOCKNAME";
        private string TICKETTYPE = "TICKETTYPE";
        private string MONEY_TYPE = "MONEY_TYPE";
        private string MONEY = "MONEY";
        private string INVOICENO = "INVOICENO";
        private string INVOICEDATE = "INVOICEDATE";
        private string INVOICE_ID = "INVOICE_ID";
        private string STATUS_CD = "STATUS_CD";
        private string REG_ID = "REG_ID";
        private string REG_DTIME = "REG_DTIME";
        private string AFFRIM_ID = "AFFRIM_ID";
        private string AFFRIM_TIME = "AFFRIM_TIME";

        private string ORDER_NO = "ORDER_NO";
        private string ORDER_SEQ = "ORDER_SEQ";
        private string DELIVERY_NO = "DELIVERY_NO";
        private string ORD_PK = "ORD_PK";
        private string ORD_LN_PK = "ORD_LN_PK";
        private string ORD_LN_DLY_PK = "ORD_LN_DLY_PK";
        private string AGENCY_FL = "AGENCY_FL";

        private string RECEIV_ADDR = "RECEIV_ADDR";
        private string DELVRY_ADDR = "DELVRY_ADDR";

        private string CUSTOMER_NO = "CUSTOMER_NO";
        private string CUSTOMER_NM = "CUSTOMER_NM";

        private string SALE_ORG = "SALE_ORG";
        private string SALE_ORG_DESC = "SALE_ORG_DESC";

        private string INDEX_SEQ = "INDEX_SEQ";

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            this.QueryGridTwo();
            this.QueryGridThree();
            this.QueryGridFive();
        }

        private void ultraGrid2_AfterRowActivate(object sender, EventArgs e)
        {
            this.QueryGridThree();
            this.QueryGridFour();
        }

        private void ultraGrid1_AfterRowActivate_1(object sender, EventArgs e)
        {
            this.QueryGridTwo();
            this.QueryGridThree();
            this.QueryGridFive();

        }

        private void ultraGrid2_AfterRowActivate_1(object sender, EventArgs e)
        {
            this.QueryGridThree();
            this.QueryGridFour();

        }

        private void ultraGrid1_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (e.KeyChar == 13)
            {
                this.Affrim();
            }
        }

        private void textBox7_KeyDown(object sender, KeyEventArgs e)
        {
           

        }

        private void textBox7_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (e.KeyChar == 13)
            {
                this.QueryGridOne();
            }

        }

        private void textBox1_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (e.KeyChar == 13)
            {
                this.QueryGridOne();
            }

        }

      
    }
}