MES_Client/TGMES/Core.StlMes.Client.Sale.UI.Balance/TranMoney/FrmTransMoneyQuery.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 FrmTransMoneyQuery : Core.StlMes.Client.Sale.Common.FrmStyleBase.FrmUIBase
    {
        public FrmTransMoneyQuery()
        {
            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());
            dsGrid2 = base.GetDataSetByColumnName(this.GetDataStruct(), GetDataSet2ColumnType(), GetDataSet2ColumnCaption());
            this.ultraGrid2.DataSource = dsGrid2;

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



           // transTypelist = PublicStaticVariable.Static_TransType_Tg(true).GetValueListDB;
         

            //this.ultraGrid2.DisplayLayout.Bands[0].Columns["STATUS_CD"].ValueList
            //            = GetStatusCd();

        }


        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 string GetSql()
        {
            string sql = @"SELECT A.BILL_NO ASKPLAN_ID,
                           A.ORDER_NO || '/' || A.ORDER_SEQ ORD_SEQ,
                           MIN(A.RECEIV_NM) INCEPTCORPCODE,
                           MIN(F.TRANS_TYPE) TRANS_TYPE_NAME,
                           MIN(F.STATION_NM) STATIONCODE,
                           MIN(TO_CHAR(F.DELETE_TIME, 'YYYYMMDD')) PLANDATE,
                           SUM(CASE
                                 WHEN A.PONDER_GROSS_WT > 0 THEN
                                  A.PONDER_GROSS_WT
                                 ELSE
                                  A.ACT_WEIGHT
                               END) WEIGHT,
                           MIN(D.SALE_AREA_DESC) SALE_AREA_DESC,
                           MIN(E.STORAGE_NAME) STORAGE_NAME,
                           ROUND(SUM(CASE
                                       WHEN B.TRANS_TYPE = '汽运' THEN
                                        8.62
                                       ELSE
                                        19.83
                                     END * CASE
                                       WHEN A.PONDER_GROSS_WT > 0 THEN
                                        A.PONDER_GROSS_WT
                                       ELSE
                                        A.ACT_WEIGHT
                                     END),
                                 5) MONEY,
                           MIN(A.VSTEL_DESC) VSTEL_DESC,
       
                           COUNT(DISTINCT A.LOADVEHICLE_NO) CNT,
                           MAX(CASE
                                 WHEN B.ASKPLAN_ID IS NOT NULL THEN
                                  'TPCO付'
                                 ELSE
                                  '自付'
                               END) JB,
                           MIN(D.CREATE_DEPT) CREATE_DEPT,
                           MIN(D.SALE_ORG_DESC) SALE_ORG_DESC,
	                        MIN(A.PRODUCNAME) PRODUCNAME,
	                        MIN(A.SPEC_NAME) SPEC_NAME,
	                        SUM(A.ACT_COUNT) ACT_COUNT
                      FROM YDM_ZC_LOADVEHICLE_MAT A
                      LEFT JOIN (SELECT B.ASKPLAN_ID,
                                        MIN(B.TRANS_TYPE) TRANS_TYPE
                                   FROM SLM_BALANCE_TRANSMONEY B
                                  WHERE 1 = 1
                                    AND B.MONEY_TYPE = '出库费'
                                    AND B.MONEY > 0
             
                                  GROUP BY ASKPLAN_ID) B
                        ON A.BILL_NO = B.ASKPLAN_ID

                      JOIN SLM_ORDER_HEAD D
                        ON D.ORD_PK = A.ORD_PK
                      LEFT JOIN YDM_BS_STORAGE E
                        ON A.STORAGE_NO = E.STORAGE_NO
                      JOIN (SELECT MIN(M.PRINT_FLAG) PRINT_FLAG,
                                   M.BILL_NO,
                                   MIN(DELETE_TIME) DELETE_TIME,
                                   MIN(M.STATION_NM) STATION_NM,
                                   MIN((SELECT BASENAME
                                         FROM COM_BASE_INFO
                                        WHERE BASECODE = M.PLAN_TRANS_TYPE)) TRANS_TYPE
                              FROM YDM_ZC_BILL_M M
                             WHERE 1 = 1
                               AND M.BILL_STATUS >= '4'
                               AND EXISTS (SELECT 1
                                      FROM SLM_BALANCEINFO BA
                                     WHERE BA.ASKPLAN_ID = M.BILL_NO)
                             GROUP BY M.BILL_NO) F
                        ON A.BILL_NO = F.BILL_NO
                     WHERE 1 = 1
                           {0}
                     GROUP BY A.BILL_NO, A.ORDER_NO || '/' || A.ORDER_SEQ, A.STORAGE_NO

                     UNION ALL   SELECT F.BILL_NO ASKPLAN_ID,
                           F.ORDER_NO || '/' || F.ORDER_SEQ ORD_SEQ,
                           MIN(F.RECEIV_NM) INCEPTCORPCODE,
                           MIN((SELECT BASENAME
                                         FROM COM_BASE_INFO
                                        WHERE BASECODE = F.PLAN_TRANS_TYPE)) TRANS_TYPE_NAME,
                           MIN(F.STATION_NM) STATIONCODE,
                           MIN(TO_CHAR(F.CREATE_TIME, 'YYYYMMDD')) PLANDATE,
                           SUM(F.ACT_WT) WEIGHT,
                           MIN(D.SALE_AREA_DESC) SALE_AREA_DESC,
                           (SELECT DISTINCT B.STORAGE_NAME FROM YDM_ZC_OUTLIST Z,YDM_BS_STORAGE B
                            WHERE Z.STORAGE_NO=B.STORAGE_NO AND F.BILL_NO=Z.M_BILL_NO) STORAGE_NAME,
                           ROUND(SUM(CASE
                                       WHEN F.PLAN_TRANS_TYPE = '110501' THEN
                                        8.62
                                       ELSE
                                        19.83
                                     END * F.ACT_WT),
                                 5) MONEY,
                           MIN(F.VSTEL_DESC) VSTEL_DESC,
                           0 CNT,
                           'TPCO付' JB,
                           MIN(D.CREATE_DEPT) CREATE_DEPT,
                           MIN(D.SALE_ORG_DESC) SALE_ORG_DESC,
                           '' PRODUCNAME,
	                       '' SPEC_NAME,
	                       0 ACT_COUNT
                      FROM YDM_ZC_BILL_M F
                      JOIN SLM_ORDER_HEAD D
                        ON D.ORD_PK = F.ORD_PK
                      
                      WHERE F.BILL_STATUS >= '4'
                      AND F.RETURN_FLAG='1'
                      {1}
                               AND EXISTS (SELECT 1
                                      FROM SLM_BALANCEINFO BA
                                     WHERE BA.ASKPLAN_ID = F.BILL_NO)
                 GROUP BY F.BILL_NO, F.ORDER_NO || '/' || F.ORDER_SEQ";

            return sql;

        }

        private string GetSqlCondition()
        {
            string str =
         "";

            str = Core.StlMes.Client.Sale.Util.ConverObject.ConvertDateTimeValueToDbLanguage("f.DELETE_TIME",
                this.dateTimePicker3.Value, this.dateTimePicker2.Value);
            if (this.textBox7.Text.Length > 0)
            {
                str += string.Format("  and f.bill_no like  '%'||'{0}'||'%' ", this.textBox7.Text);
 
            }
      
            return str;
        }

        private string GetSqlCondition2()
        {
            string str =
         "";

            str = "and f.create_time between to_date('"+this.dateTimePicker3.Value+
                "','yyyy-MM-dd hh24:mi:ss') and to_date('" + this.dateTimePicker2.Value + "','yyyy-MM-dd hh24:mi:ss')";
            if (this.textBox7.Text.Length > 0)
            {
                str += string.Format("  and f.bill_no like  '%'||'{0}'||'%' ", this.textBox7.Text);

            }

            return str;
        }

        private void Query01()
        {
            string sql = string.Format(GetSql(), GetSqlCondition(), GetSqlCondition2());
            DataSet ds = base.ExecuteReader(sql);
            if (!this.UserInfo.GetUserName().Equals("admin"))
                ds = base.GetDataSetByFilterDeptId(ds);
            Core.StlMes.Client.Sale.Util.UtilDataSet.SetDataSetByMergeSameColumnName(ref dsGrid2, ds);
 
        }

        private string[] GetDataStruct()
        {
            return new string[] 
            {
                "PLANDATE",
                "ASKPLAN_ID",
                "ORD_SEQ",
                "INCEPTCORPCODE",
                "TRANS_TYPE_NAME",
                "STATIONCODE",
                "WEIGHT",
                "SALE_AREA_DESC",
                "MONEY",
                "VSTEL_DESC",
                "STORAGE_NAME",
                "CNT",
                "JB",
                "SALE_ORG_DESC",
                "PRODUCNAME",
	            "SPEC_NAME",
	            "ACT_COUNT"
            };
        }

        private void FrmTransMoneyInput_Load(object sender, EventArgs e)
        {
            this.label1.Visible = false;
            this.dateTimePicker1.Visible = false;
            this.dateTimePicker3.Value = System.DateTime.Now.AddMonths(-1);
            this.dateTimePicker1.Format = DateTimePickerFormat.Custom;
            this.dateTimePicker1.CustomFormat = "yyyyMM";
            //PublicStaticVariable = new Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.StaticData.PublicStaticVariable(this.ob);
            InitDataSource();
            //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();
            base.SetGridStyle(ref this.ultraGrid2);



        }

        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",
            });
        }



        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    {
                        Query01();
                        break;
                    }
                case "Exit":
                    {
                        this.Close();
                        break;
                    }
                case "Excel":
                    {
                        Core.StlMes.Client.Sale.Util.UtilUltraGrid.ExportGridDataToExcel(this.Text,  this.ultraGrid2);
                        break;
                    }
            }

        }

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


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

        //}

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

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




        //}

        //private void remvoeMonyEqualsZero()
        //{
        //    try
        //    {
        //        foreach (DataRow dr in this.dsGrid2.Tables[0].Rows)
        //        {
        //            if (Util.ConverObject.ConvertToDouble(dr["MONEY"].ToString()) == 0)
        //            {
        //                dr.Delete();
        //            }

        //        }
        //    }
        //    catch
        //    {
        //    }

        //    this.dsGrid2.AcceptChanges();

        //}

        //private void HiddenCol()
        //{
          

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

        //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

        //    };
        //}




        //private string[] GetGrid2DataStruct()
        //{
        //    return new string[] 
        //    {
        //      TICKETTYPE,
        //        MONEY,
        //        "TICKETNUM",             
        //         MONEY_TYPE,
        //        TRANS_PK,
        //        ASKPLAN_ID,            
        //        BUYERNAME,           
        //   //     STATIONNAME,
        //  //      LEASEDLINENAME,
        //        INCEPTCORPCODE,
        //       FORECORPNAME,
        //        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 GetDataSet2ColumnType()
        {
            Hashtable hs = new Hashtable();
            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, "交货地点");


        //    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", "票据数");


            hs.Add("ORD_SEQ", "合同号");

            //hs.Add("INCEPTCORPCODE", "收货单位");
            hs.Add("TRANS_TYPE_NAME", "外运类型");
            hs.Add("PLANDATE", " 关闭时间");
            hs.Add("WEIGHT", "重量");

            hs.Add("SALE_AREA_DESC", "区域");
            hs.Add("VSTEL_DESC", "装车地点");
            hs.Add("STORAGE_NAME", "出库地点");
            hs.Add("CNT", "装车数");
            hs.Add("JB", "出库结标");
            hs.Add("SALE_ORG_DESC", "销售组织");
            hs.Add("PRODUCNAME", "品名");
            hs.Add("SPEC_NAME", "规格");
            hs.Add("ACT_COUNT", "支数");

            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 void textBox7_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (e.KeyChar == 13)
                Query01();
        }


    }
}