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(new String[] { BILL_NO }), new List(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(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); 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 list = new List(); 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); } } }