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 GetNumberColumn() { return new List(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(new string[]{ CARRY_COMPANY_NAME, // "AGENCY_FL", // "DESTINATION", // "STATION_NO", // "SPCL_LN_NO", // "DESTINATION", // "PORT_NO", // "CARRIER_UNIT", // "RECEIVOR"}), new List(), new List()); // 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(); } } }