using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Collections; using System.Windows.Forms; using CoreFS.CA06; using Infragistics.Win.UltraWinGrid; using Infragistics.Win; using SaleBusiness = Core.StlMes.Client.Sale.BLL.SaleBusinessMgt; namespace Core.StlMes.Client.Sale.UI.Balance.DlgBox { public partial class DlgSelectInvoceTransMnyAndOutStockMny : Core.StlMes.Client.Sale.Common.FrmStyleBase.FrmUIBase { private Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Balance.SlmBalanceInfo slmBalanceInfo = null; private string saleOrg = ""; private string custUser = ""; private CoreFS.CA06.OpeBase _ob = null; DataSet dsMain = new DataSet(); DataSet dsGrid2 = new DataSet(); DataSet dsGrid3 = new DataSet(); public string _invocieFlag = "0"; private Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Trans.YdmZcLoadVehicleMatMgt ydmZcLoadVehicleMatMgt = null; private Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.StaticData.PublicStaticVariable PublicStaticVariable = null; private Infragistics.Win.ValueList transTypelist = null; public DlgSelectInvoceTransMnyAndOutStockMny(CoreFS.CA06.OpeBase ob) { _ob = ob; InitializeComponent(); } 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 InitDataSource() { dsMain = base.GetDataSetByColumnName(this.GetDataStructGridOne(), this.GetDataSetColumnType(), GetDataSetColumnCaption()); dsGrid2 = base.GetDataSetByColumnName(this.GetGrid2DataStruct(), GetDataSetColumnType(), 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(); } private void DlgSelectInvoceTransMnyAndOutStockMny_Load(object sender, EventArgs e) { PublicStaticVariable = new Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.StaticData.PublicStaticVariable(_ob); InitDataSource(); ydmZcLoadVehicleMatMgt = new Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Trans.YdmZcLoadVehicleMatMgt(_ob); slmBalanceInfo = new Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Balance.SlmBalanceInfo(_ob); HiddenCol(); base.SetGridStyle(ref this.ultraGrid2); Query(); } private void Query() { 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.GetDataSetWithRowFilterWithApproximateMatch(ds, this.TICKETTYPE, "应收"); // 只有应收，未开票显示 // 末次 if (this._invocieFlag == "0") { ds = Util.UtilDataSet.GetDataSetWithRowFilter(ds, this.INVOICENO, ""); } else { ds = Util.UtilDataSet.GetDataSetWithRowFilter(ds, "INVOICENO_ORG", ""); } 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[] { "TRANS_PK", 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 GetDataSetColumnType() { 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", "票据数"); 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 ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e) { if (e.Tool.Key == "Choose") { Choose(); } if (e.Tool.Key == "Query") { this.Query(); } if (e.Tool.Key == "Exit") { this.Close(); } } public ArrayList Tranpk = new ArrayList(); private void Choose() { if (this.ultraGrid2.Rows.Count == 0) { this.DialogResult = DialogResult.Cancel; return; } Infragistics.Win.UltraWinGrid.UltraGridRow ugr = this.ultraGrid2.ActiveRow; if (ugr == null) { Core.StlMes.Client.Sale.Util.MessageUtil.ShowError("请选择数据"); return; } else ugr.Selected = true; string buyernameAdnForcode = ugr.Cells[this.BUYERNAME].Value.ToString() + ugr.Cells[this.FORECORPNAME].Value.ToString() + ugr.Cells[this.MONEY_TYPE].Value.ToString(); foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugrs in this.ultraGrid2.Selected.Rows) { if (buyernameAdnForcode != ugrs.Cells[this.BUYERNAME].Value.ToString() + ugrs.Cells[this.FORECORPNAME].Value.ToString() + ugrs.Cells[this.MONEY_TYPE].Value.ToString()) { Core.StlMes.Client.Sale.Util.MessageUtil.ShowError("只允许编制同结算单位，同销售组织，同费用类型数据"); return; } Tranpk.Add(ugrs.Cells["TRANS_PK"].Value.ToString()); } if (Core.StlMes.Client.Sale.Util.MessageUtil.ShowYesNoAndQuestion("是否确认编制结算单") == DialogResult.No) return; this.DialogResult = DialogResult.OK; } } }