MES_Client/TGMES/Core.StlMes.Client.Sale.UI.Balance/TranMoney/FrmTransMoneyInput.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.TranMoney
{
    public partial class FrmTransMoneyInput : Core.StlMes.Client.Sale.Common.FrmStyleBase.FrmUIBase
    {
        public FrmTransMoneyInput()
        {
            InitializeComponent();
        }

        DataSet dsMain = new DataSet();
        DataSet dsGrid2 = new DataSet();
        DataSet dsGrid3 = new DataSet();







        private Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Trans.YdmZcLoadVehicleMatMgt ydmZcLoadVehicleMatMgt
            = null;
        private Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Balance.SlmBalanceInfo slmBalanceInfo = null;
        private Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.StaticData.PublicStaticVariable
            PublicStaticVariable = null;
        private Infragistics.Win.ValueList transTypelist = null;

        private void InitDataSource()
        {


            dsMain = base.GetDataSetByColumnName(this.GetDataStructGridOne(), this.GetDataSetColumnType(),
                GetDataSetColumnCaption());
            this.ultraGrid1.DataSource = dsMain;
            dsGrid2 = base.GetDataSetByColumnName(this.GetGrid2DataStruct(), GetDataSetColumnType(), GetDataSet2ColumnCaption());
         //   this.ultraGrid2.DataSource = dsGrid2;

            dsGrid3 = base.GetDataSetByColumnName(this.GetDataStructGridThree(), GetDataSetColumnType(), GetDataSetColumnCaption());
            this.ultraGrid3.DataSource = dsGrid3;


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

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

            //this.ultraGrid2.DisplayLayout.Bands[0].Columns["STATUS_CD"].ValueList
            //            = GetStatusCd();
            base.SetGridStyle(ref this.ultraGrid3, ref this.ultraGrid1);
        }


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

        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 Infragistics.Win.ValueList GetStatusCd()
        {
            Infragistics.Win.ValueList lit = new Infragistics.Win.ValueList();
            lit.ValueListItems.Add("0", "输入");
            lit.ValueListItems.Add("1", "确认");
            lit.ValueListItems.Add("2", "开单");
            return lit;
        }


        private void FrmTransMoneyInput_Load(object sender, EventArgs e)
        {
            this.dateTimePicker1.Value = System.DateTime.Now.AddDays(-14);
            PublicStaticVariable = new Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.StaticData.PublicStaticVariable(this.ob);
            InitDataSource();
            base.SetGridStyle(ref this.ultraGrid1);
            ydmZcLoadVehicleMatMgt = new Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Trans.YdmZcLoadVehicleMatMgt(this.ob);
            slmBalanceInfo = new Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Balance.SlmBalanceInfo(this.ob);
            InitAllowEdit();
            HiddenCol();
            this.ultraGrid3.DisplayLayout.Bands[0].Override.ColumnAutoSizeMode = Infragistics.Win.UltraWinGrid.ColumnAutoSizeMode.VisibleRows;
        }



        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    {
                        if (this.tabControl1.SelectedIndex == 0)
                            this.Query();
                        else
                            this.QueryGrid2();
                        break;
                    }
                case "Save":
                    {
                        this.Save();
                        break;
                    }
                case "Edit":
                    {
                        this.Edit();
                        break;
                    }
                case "Exit":
                    {
                        this.Close();
                        break;
                    }
                case "Delete":
                    {
                        this.Delete();
                        break;
                    }
            }

        }

        private void ClearGrid()
        {
            this.dsGrid2.Clear();
        }


        private void Query()
        {

            DataSet ds = this.ydmZcLoadVehicleMatMgt.GetYdmZcBillMByCreateTime(this.dateTimePicker1.Value,
                this.dateTimePicker2.Value);
            // 
            ds = Util.UtilDataSet.GetDataSetWithRowFilter(ds, "LOADVEHICLE_TYPE", "1");
            ds = Util.UtilDataSet.GetDateSetByGroupColumnAndStaticsColumnName
                (ds, new List<string>(new String[] { BILL_NO }), new List<string>(new String[]
                {   STLMT_UNIT_NO,
                     CUSTOMER_NO,
                CUSTOMER_NM,
                SPCL_LN_NM,
                DELIVY_PLACE_CODE,
                DELIVY_PLACE_NAME,       
                  this.SALE_ORG,
                this.SALE_ORG_DESC,
                RECEIV_NO,
                RECEIV_NM,
                CARRY_COMPANY_CODE,
                CARRY_COMPANY_NAME }), null);
            if (this.textBox7.Text.Length > 0)
            {
                ds = Util.UtilDataSet.GetDataSetWithRowFilterWithApproximateMatch(ds, this.BILL_NO, this.textBox7.Text.Trim());
            }
            Util.UtilDataSet.SetDataSetByMergeSameColumnName(ref dsMain, ds);

            ClearGrid();
          


        }



        private void QueryGrid3(string billNo)
        {
            DataSet dsDetail =
                this.ydmZcLoadVehicleMatMgt.GetDistinctOrderLineDeliveryTransitByBillNo(billNo);


            //dsDetail = Util.UtilDataSet.GetDateSetByGroupColumnAndStaticsColumnName(dsDetail,
            //    new List<string>(new string[]{  CARRY_COMPANY_NAME,
            //    "AGENCY_FL",
            //    "DESTINATION",
            //    "STATION_NO",
            //    "SPCL_LN_NO",
            //      "DESTINATION",
            //    "PORT_NO",
            //    "CARRIER_UNIT",
            //    "RECEIVOR"}), new List<string>(), new List<string>());
            Util.UtilDataSet.SetDataSetByMergeSameColumnName(ref this.dsGrid3, dsDetail);
            SetGrid3TicketNumAndMoney(billNo);

        }

        private string GetMoneyType()
        {
            return "";
        }

        private void SetGrid3TicketNumAndMoney(string billno)
        {
            if (this.dsGrid3 == null || this.dsGrid3.Tables.Count == 0 || this.dsGrid3.Tables[0].Rows.Count == 0)
                return;
            DataSet ds = this.slmBalanceInfo.GetSlmBalanceTransMoneyAskPlanid(billno);
            ds = Util.UtilDataSet.GetDataSetWithRowFilter(ds, this.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.dsGrid3.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;
                dr["TRANSNUM"] = ticketnum;

                         

            }
        }

        private bool isDataSetRowsExists(DataSet ds)
        {
            try
            {
                return ds.Tables[0].Rows.Count > 0;
            }
            catch
            {
                return false;
            }
        }



        private void QueryGrid2()
        {
            //DataSet ds = this.slmBalanceInfo.GetSlmBalanceTransMoneyByRegeditTime(this.dateTimePicker3.Value,
            //    this.dateTimePicker4.Value);


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

            //ds = Util.UtilDataSet.GetDataSetWithRowFilter(ds, this.MONEY_TYPE, "运费");


            //Util.UtilDataSet.SetDataSetByMergeSameColumnName(ref this.dsGrid2, ds);


            //InitDefaultValueGrid2();



        }




        private Boolean CheckInputParameter( Infragistics.Win.UltraWinGrid.UltraGridRow ugr )
        {
            if(ugr == null)
                return false;
            double TRANSMNY = Util.ConverObject.ConvertToDouble(ugr.Cells["TRANSMNY"].Value.ToString());
            double TICKETNUM = Util.ConverObject.ConvertToDouble(ugr.Cells["TRANSNUM"].Value.ToString());

            //if (TRANSMNY == 0)
            //{
            //    Util.MessageUtil.ShowError("请输入正确的运费");
            //    return false;
            //}
            //if ( TICKETNUM == 0)
            //{
            //    Util.MessageUtil.ShowError("请输入正确的单据数");
            //    return false;
            //}
            return true;
 
        }


            // hs.Add("TRANSMNY", "System.Decimal");
            //hs.Add("MONEY", "System.Decimal");
            //hs.Add("TICKETNUM", "System.Decimal");
            //hs.Add(this.TRANSNUM, "System.Decimal");



        private void Save()
        {
            if (this.tabControl1.SelectedIndex == 1)
                return;
            if (this.ultraGrid3.Rows.Count == 0)
                return;
            this.ultraGrid3.UpdateData();
            System.Collections.Generic.List<Hashtable> list = new List<Hashtable>();
            Hashtable hs = null;
            string[] str = null;
            string[] strcolumn = GetDataStructGridThree();
            int lenght = strcolumn.Length;

            Infragistics.Win.UltraWinGrid.UltraGridRow ugrm = null;
            ugrm = this.ultraGrid1.ActiveRow;
            if (ugrm == null)
                ugrm = this.ultraGrid1.Rows[0];

            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugr in this.ultraGrid3.Rows)
            {
                if (ugr.Cells[this.SELECT].Value.ToString().ToUpper() == "TRUE")
                {


                    hs = new Hashtable();
                    if (!CheckInputParameter(ugr))
                    {
                        return;
                    }
                    foreach (string s in strcolumn)
                    {
                        if (!hs.ContainsKey(s))
                        {
                            if (s == this.TRANS_TYPE)
                                hs.Add(s, ugr.Cells[s].Text.Trim());
                            else
                                hs.Add(s, ugr.Cells[s].Value.ToString());
                        }


                    }

                    if (!hs.ContainsKey(this.CUSTOMER_NO))
                    {
                        hs.Add(this.CUSTOMER_NO, ugrm.Cells[this.CUSTOMER_NO].Value.ToString());

                    }
                    if (!hs.ContainsKey(this.CUSTOMER_NM))
                    {
                        hs.Add(this.CUSTOMER_NM, ugrm.Cells[this.CUSTOMER_NM].Value.ToString());

                    }
                    if (!hs.ContainsKey(this.RECEIV_NM))
                    {
                        hs.Add(this.RECEIV_NM, ugrm.Cells[this.RECEIV_NM].Value.ToString());

                    }

                    if (!hs.ContainsKey(this.RECEIV_NO))
                    {
                        hs.Add(this.RECEIV_NO, ugrm.Cells[this.RECEIV_NO].Value.ToString());

                    }
                    if (!hs.ContainsKey(this.BILL_NO))
                    {
                        hs.Add(this.BILL_NO, ugrm.Cells[this.BILL_NO].Value.ToString());

                    }

                    if (!hs.ContainsKey(this.SALE_ORG))
                    {
                        hs.Add(this.SALE_ORG, ugrm.Cells[this.SALE_ORG].Value.ToString());

                    }
                    if (!hs.ContainsKey(this.SALE_ORG_DESC))
                    {
                        hs.Add(this.SALE_ORG_DESC, ugrm.Cells[this.SALE_ORG_DESC].Value.ToString());

                    }

                    if (!hs.ContainsKey(this.ORD_PK))
                    {
                        hs.Add(this.ORD_PK, ugrm.Cells[this.ORD_PK].Value.ToString());

                    }

                    if (!hs.ContainsKey(this.ORD_LN_PK))
                    {
                        hs.Add(this.ORD_LN_PK, ugrm.Cells[this.ORD_LN_PK].Value.ToString());

                    }

                    if (!hs.ContainsKey(this.ORD_LN_DLY_PK))
                    {
                        hs.Add(this.ORD_LN_DLY_PK, ugrm.Cells[this.ORD_LN_DLY_PK].Value.ToString());

                    }

                    if (!hs.ContainsKey(this.INDEX_SEQ))
                    {
                        hs.Add(this.INDEX_SEQ, ugrm.Cells[this.INDEX_SEQ].Value.ToString());

                    }

                 


                    list.Add(hs);
                }

            }
            if (list.Count == 0)
                return;
            string errMsg = "";
            this.slmBalanceInfo.SaveTransMoney(list, CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName(), out errMsg);
            if (errMsg.Length > 0)
            {
                Util.MessageUtil.ShowError(errMsg);
                return;
            }
            else
            {
                Core.StlMes.Client.Sale.Util.MessageUtil.ShowTips("操作成功");
                return;
            }


        }


        private void Edit()
        {
            //this.ultraGrid2.UpdateData();
            //if (this.tabControl1.SelectedIndex == 0)
            //    return;
            //if (this.ultraGrid2.Rows.Count == 0)
            //    return;

            //try
            //{
            //    foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugr in this.ultraGrid2.Rows)
            //    {
            //        if (ugr.Cells[this.SELECT].Value.ToString().ToUpper() == "TRUE")
            //        {
            //            string seq = ugr.Cells[this.TRANS_PK].Value.ToString();
            //            string money = ugr.Cells[this.MONEY].Value.ToString();

            //            if (Util.ConverObject.ConvertToDouble(money) == 0)
            //            {
            //                Util.MessageUtil.ShowError("请输入正确的费用");
            //                return;
            //            }

            //            string ticketnum = ugr.Cells["TICKETNUM"].Value.ToString();

            //            if (Util.ConverObject.ConvertToDouble(ticketnum) == 0)
            //            {
            //                Util.MessageUtil.ShowError("请输入正确的单据");
            //                return;
            //            }
            //            string person = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName();

            //            string status = ugr.Cells[this.STATUS_CD].Value.ToString();
            //            if (status == "1" || status == "2")
            //            {
            //                Core.StlMes.Client.Sale.Util.MessageUtil.ShowTips("该记录已经确认或开具结算单");
            //                return;
            //            }

            //            string errMsg = "";
            //            this.slmBalanceInfo.EditTransMoney(seq, money, ticketnum, person, out errMsg);
            //            if (errMsg.Length > 0)
            //            {
            //                Util.MessageUtil.ShowError(errMsg);
            //                return;
            //            }
            //        }
            //    }
            //    Core.StlMes.Client.Sale.Util.MessageUtil.ShowTips("操作成功");



            //}
            //catch (System.Exception ex)
            //{
            //    Core.StlMes.Client.Sale.Util.MessageUtil.ShowError(ex.Message);
            //}


        }



        private void Delete()
        {
            //this.ultraGrid2.UpdateData();
            //string errMsg = "";
            //if (this.ultraGrid2.Rows.Count == 0)
            //    return;
            //if (this.tabControl1.SelectedIndex == 0)
            //    return;
            //Boolean isRecordsDel = false;
            //foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugr in this.ultraGrid2.Rows)
            //{
            //    if (ugr.Cells[this.SELECT].Value.ToString().ToUpper() == "TRUE")
            //    {
            //        isRecordsDel = true;
            //        break;
                   
            //    }
            //}
            //if (isRecordsDel)
            //{
            //    if (Util.MessageUtil.ShowYesNoAndQuestion("是否确定删除选定行？") == DialogResult.No) return;
            //}
            //else
            //{
            //    Util.MessageUtil.ShowTips(" 请选择要删除的行 ");
            //    return;
            //}
       

            //foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugr in this.ultraGrid2.Rows)
            //{
            //    if (ugr.Cells[this.SELECT].Value.ToString().ToUpper() == "TRUE")
            //    {
            //        string seq = ugr.Cells[this.TRANS_PK].Value.ToString();
            //        string status = ugr.Cells[this.STATUS_CD].Value.ToString();
            //        if (status == "1" || status == "2")
            //        {
            //               Core.StlMes.Client.Sale.Util.MessageUtil.ShowTips("该记录已经确认或开具结算单，不允许删除");
            //            return;
            //        }
            //        this.slmBalanceInfo.DeleteTransMoney(seq, CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName(), out errMsg);
            //        if (errMsg.Length > 0)
            //        {
            //            Util.MessageUtil.ShowError(errMsg);
            //            return;
            //        }
            //    }
            //}
            //Core.StlMes.Client.Sale.Util.MessageUtil.ShowTips("操作成功");
            //this.QueryGrid2();


        }



        private void InitDefaultValueGrid2()
        {
            if (dsGrid2 == null || dsGrid2.Tables.Count == 0 || dsGrid2.Tables[0].Rows.Count == 0)
                return;
            foreach (DataRow dr in dsGrid2.Tables[0].Rows)
            {
                dr[this.SELECT] = false;
            }


        }




        private void HiddenCol()
        {
            foreach (string s in GetHiddenCol())
            {
                try
                {
                    this.ultraGrid1.DisplayLayout.Bands[0].Columns[s].Hidden = true;
                }
                catch
                { }
            }

          //  this.ultraGrid2.DisplayLayout.Bands[0].Columns[this.STATUS_CD].Hidden = true;
        //    this.ultraGrid2.DisplayLayout.Bands[0].Columns[this.TRANS_PK].Hidden = true;

            this.ultraGrid3.DisplayLayout.Bands[0].Columns[this.ORD_PK].Hidden = true;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns[this.ORD_LN_PK].Hidden = true;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns[this.ORD_LN_DLY_PK].Hidden = true;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns[this.TRANSNUM].Hidden = true;
        }






        private void InitAllowEdit()
        {
            for (int i = 0; i < this.ultraGrid3.DisplayLayout.Bands[0].Columns.Count; i++)
            {
                this.ultraGrid3.DisplayLayout.Bands[0].Columns[i].CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
            }

            foreach (string s in new string[] 
            {
                this.SELECT,             
               this.TRANSMNY,
               TRANSNUM
            })
            {
                try
                {
                    this.ultraGrid3.DisplayLayout.Bands[0].Columns[s].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                    this.ultraGrid3.DisplayLayout.Bands[0].Columns[s].CellAppearance.BackColor = base.GetEditColor();
                    this.ultraGrid3.DisplayLayout.Bands[0].Columns[s].Width = 60;
                }
                catch
                { }
            }

            try
            {
                //this.ultraGrid2.DisplayLayout.Bands[0].Columns[this.MONEY].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                //this.ultraGrid2.DisplayLayout.Bands[0].Columns[this.MONEY].CellAppearance.BackColor = base.GetEditColor();
                //this.ultraGrid2.DisplayLayout.Bands[0].Columns[this.MONEY].Width = 60;
                //this.ultraGrid2.DisplayLayout.Bands[0].Columns[this.SELECT].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                //this.ultraGrid2.DisplayLayout.Bands[0].Columns[this.SELECT].CellAppearance.BackColor = base.GetEditColor();
                //this.ultraGrid2.DisplayLayout.Bands[0].Columns[this.SELECT].Width = 60;
                //this.ultraGrid2.DisplayLayout.Bands[0].Columns["TICKETNUM"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                //this.ultraGrid2.DisplayLayout.Bands[0].Columns["TICKETNUM"].CellAppearance.BackColor = base.GetEditColor();
                //this.ultraGrid2.DisplayLayout.Bands[0].Columns["TICKETNUM"].Width = 60;

            }
            catch
            { }





        }


     



        private string[] GetDataStructGridOne()
        {
            return new string[]
            {
                this.BILL_NO,
                CUSTOMER_NO,
                CUSTOMER_NM,
                STLMT_UNIT_NO,
                this.SALE_ORG,
                this.SALE_ORG_DESC,
             //   SPCL_LN_NM,
             //   DELIVY_PLACE_CODE,
               // DELIVY_PLACE_NAME,             
                RECEIV_NO,
                RECEIV_NM
            //    CARRY_COMPANY_CODE,
             //   CARRY_COMPANY_NAME                
            };
        }

        private string[] GetDataStructGridThree()
        {
            return new string[]
            {
                SELECT,
                TRANSMNY,
                TRANSNUM,    
                "TRANS_TYPE",
                "AGENCY_FL",
                "DESTINATION",
                "STATION_NO",
                "SPCL_LN_NO",
                  "DESTINATION",
                "PORT_NO",
             //   "CARRIER_UNIT",
                "RECEIVOR"
                ,RECEIV_ADDR,
                DELVRY_ADDR,
                this.ORD_PK,
                this.ORD_LN_PK,
                this.ORD_LN_DLY_PK,
                   this.ORDER_NO,
                this.ORDER_SEQ,
                this.DELIVERY_NO,
                this.INDEX_SEQ

            };
        }




        private string[] GetGrid2DataStruct()
        {
            return new string[] 
            {
               SELECT,
              TICKETTYPE,
                MONEY,
                "TICKETNUM",             
                 MONEY_TYPE,
                TRANS_PK,
                ASKPLAN_ID,            
                BUYERNAME,           
           //     STATIONNAME,
          //      LEASEDLINENAME,
                INCEPTCORPCODE,
                TRANS_TYPE,
                MOTORMANNAME,
                STATUS_CD
            };
        }

        private string[] GetHiddenCol()
        {
            return new string[] {   this.TRANS_TYPE,
                this.RECEIV_NO,
                this.STATION_NO,
                this.SPCL_LN_NO,
                this.VSTEL_CODE,
                this.VSTEL_DESC,
                DELIVY_PLACE_CODE,
                DELIVY_PLACE_NAME,
                  this.SALE_ORG,
                this.SALE_ORG_DESC,
                STLMT_UNIT_NO,
                CUSTOMER_NO,
            MONET_TYPE};
        }

        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(this.TRANSNUM, "System.String");

            //hs.Add("SELECT", "System.Boolean");
            //hs.Add("TRANSMNY", "System.Decimal");
            //hs.Add("MONEY", "System.Decimal");
            //hs.Add("TICKETNUM", "System.Decimal");
            //hs.Add(this.TRANSNUM, "System.Decimal");
            return hs;
        }

        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, "交货行");

            


            return hs;

        }

        private Hashtable GetDataSet2ColumnCaption()
        {
            Hashtable hs = new Hashtable();
            hs.Add(TRANS_PK, "主键");
            hs.Add(ASKPLAN_ID, "提单号");
            hs.Add(TALLYSHEET_NO, "理货单号");
            hs.Add(LOADVEHICLE_NO, "装车单号");
            hs.Add(TRAINWAGON, "车号");
            hs.Add(BUYERCODE, "结算单位");
            hs.Add(BUYERNAME, "结算单位");
            hs.Add(FORECORPCODE, "销售组织");
            hs.Add(FORECORPNAME, "销售组织");
            hs.Add(FST_DRAWEE_UNIT, "首次受票人");
            hs.Add(STATIONCODE, "到站");
            hs.Add(STATIONNAME, "到站");
            hs.Add(LEASEDLINE, "专用线名称");
            hs.Add(LEASEDLINENAME, "专用线名称");
            hs.Add(INCEPTCORPCODE, "收货单位");
            hs.Add(TRANS_TYPE, "运输方式");
            hs.Add(MOTORMANNAME, "承运单位");
            hs.Add(DOCKNAME, "水运起始与目的港口");
            hs.Add(TICKETTYPE, "单据类型");
            hs.Add(TICKETNO, "单据号");
            hs.Add(MONEY_TYPE, "费用类型");
            hs.Add(MONEY, "金额");
            hs.Add(LOAD_TIME, "装车时间");
            hs.Add(INVOICENO, "结算单号");
            hs.Add(INVOICEDATE, "编单时间");
            hs.Add(INVOICE_ID, "编单人");
            hs.Add(STATUS_CD, "状态区分");
            hs.Add(REG_ID, "录入者");
            hs.Add(REG_DTIME, "录入时间");
            hs.Add(AFFRIM_ID, "确认人");
            hs.Add(AFFRIM_TIME, "确认时间");
            hs.Add(SELECT, "选择");
            hs.Add("TICKETNUM", "票据数");

            return hs;
        }


        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 tabControl1_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (tabControl1.SelectedIndex == 0)
                this.Query();
            else
                this.QueryGrid2();
        }

        private void ultraGrid1_MouseHover(object sender, EventArgs e)
        {

        }

        private void ultraGrid1_MouseUp(object sender, MouseEventArgs e)
        {

        }

        private void ultraGrid1_MouseMove(object sender, MouseEventArgs e)
        {

        }

        private void ultraGrid1_ClickCell(object sender, Infragistics.Win.UltraWinGrid.ClickCellEventArgs e)
        {



        }

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            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 billno = ugr.Cells[this.BILL_NO].Value.ToString();
            this.QueryGrid3(billno);
        }

        private void ultraGrid1_InitializeLayout(object sender, Infragistics.Win.UltraWinGrid.InitializeLayoutEventArgs e)
        {

        }

        private void ultraGrid1_AfterRowActivate_1(object sender, EventArgs e)
        {
            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 billno = ugr.Cells[this.BILL_NO].Value.ToString();
            this.QueryGrid3(billno);

        }


    }
}