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.BalanceAccount { public partial class FrmBalanceTicketAffrim : Core.StlMes.Client.Sale.Common.FrmStyleBase.FrmUIBase { public FrmBalanceTicketAffrim() { InitializeComponent(); } private DataSet dsGridOne = new DataSet(); private DataSet dsGridTwo = new DataSet(); private DataSet dsGridThree = new DataSet(); private DataSet dsGridFour = new DataSet(); private DataSet dsGridFine = new DataSet(); private DataSet dsBalance = null; private Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Balance.SlmBalanceInfo slmBalanceInfo = null; private Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.StaticData.PublicStaticVariable publicStaticVariable = null; private Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Trans.YdmZcLoadVehicleMatMgt ydmZcLoadVehicleMatMgt = null; private void InitDataSource() { this.dsGridOne = base.GetDataSetByColumnName(this.GetGridOneDataStruct(), StaticData.TbColumnAndCaption.GetDataSetColumnType(), StaticData.TbColumnAndCaption.GetColumnAndCaption()); this.dsGridTwo = base.GetDataSetByColumnName(this.GetGridTwoDataStruct(), StaticData.TbColumnAndCaption.GetDataSetColumnType(), StaticData.TbColumnAndCaption.GetColumnAndCaption()); this.dsGridThree = base.GetDataSetByColumnName(this.GetGridThreeDataStruct(), StaticData.TbColumnAndCaption.GetDataSetColumnType(), StaticData.TbColumnAndCaption.GetColumnAndCaption()); this.dsGridFour = base.GetDataSetByColumnName(this.GetGridFourDataStruct(), StaticData.TbColumnAndCaption.GetDataSetColumnType(), StaticData.TbColumnAndCaption.GetColumnAndCaption()); this.dsGridFine = base.GetDataSetByColumnName(this.GetGridFiveDataStruct(), GetDataSetColumnType(), GetDataSetColumnCaption()); this.ultraGrid1.DataSource = this.dsGridOne; this.ultraGrid2.DataSource = this.dsGridTwo; this.ultraGrid3.DataSource = this.dsGridThree; this.ultraGrid4.DataSource = this.dsGridFour; this.ultraGrid5.DataSource = this.dsGridFine; } protected override List GetGridColumnListHidden() { return new List(new string[]{StaticData.TbColumnAndCaption.ASKPLAN_ID_SEQ}); } 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, "交货行"); hs.Add("PLID", "产线"); return hs; } protected override Hashtable GetGridColumnLength() { return StaticData.TbColumnAndCaption.GetDataSetColumnLength(); } protected override List GetNumberColumn() { return new List(new string[] { "SEND_NUM", "MONEY", "WEIGHT", "QUANTITY", "ACT_WGT", "OUTSTOCKMNY", "TRANSMNY" }); } private void FrmBalanceTicketAffrim_Load(object sender, EventArgs e) { this.radioButton1.Checked = true; PublicStaticVariable = new Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.StaticData.PublicStaticVariable(this.ob); ydmZcLoadVehicleMatMgt = new Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Trans.YdmZcLoadVehicleMatMgt(this.ob); this.dateTimePicker1.Value = System.DateTime.Now.AddDays(-30); InitDataSource(); slmBalanceInfo = new Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Balance.SlmBalanceInfo(this.ob); HiddenColumn(); this.ultraGrid4.DisplayLayout.Bands[0].Override.ColumnAutoSizeMode = Infragistics.Win.UltraWinGrid.ColumnAutoSizeMode.VisibleRows; base.SetGridStyle(ref this.ultraGrid1,ref this.ultraGrid2,ref this.ultraGrid3,ref this.ultraGrid4,ref this.ultraGrid5); InitGrid(); } /// /// 是否代办 /// /// private Infragistics.Win.ValueList GetAgenCyFlList() { Infragistics.Win.ValueList lit = new Infragistics.Win.ValueList(); lit.ValueListItems.Add("0", "否"); lit.ValueListItems.Add("1", "是"); return lit; } private void InitGrid() { try { this.ultraGrid4.DisplayLayout.Bands[0].Columns["AGENCY_FL"].ValueList = GetAgenCyFlList(); this.ultraGrid1.DisplayLayout.Bands[0].Columns["TICKETSTATUS"].ValueList = GetAgenCyFlList(); } catch { } this.ultraGrid5.DisplayLayout.Bands[0].Columns[this.SPCL_LN_NO].ValueList = PublicStaticVariable.Static_SpecLine_Tg(true).GetValueListDB; this.ultraGrid5.DisplayLayout.Bands[0].Columns[this.STATION_NO].ValueList = PublicStaticVariable.Static_StationNoAndName_Tg(true).GetValueListDB; transTypelist = PublicStaticVariable.Static_TransType_Tg(true).GetValueListDB; this.ultraGrid5.DisplayLayout.Bands[0].Columns["TRANS_TYPE"].ValueList = transTypelist; this.ultraGrid5.DisplayLayout.Bands[0].Columns["AGENCY_FL"].ValueList = GetAgenCyFl(); } private Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.StaticData.PublicStaticVariable PublicStaticVariable = null; private Infragistics.Win.ValueList transTypelist = null; 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 void SetGrid5TicketNumAndMoney(string billno) { if (this.dsGridFine == null || this.dsGridFine.Tables.Count == 0 || this.dsGridFine.Tables[0].Rows.Count == 0) return; DataSet ds = this.slmBalanceInfo.GetSlmBalanceTransMoneyAskPlanid(billno); ds = Util.UtilDataSet.GetDataSetWithRowFilter(ds, "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.dsGridFine.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; } } private void HiddenColumn() { try { this.ultraGrid2.DisplayLayout.Bands[0].Columns["BALANCESTATUS"].Hidden = true; this.ultraGrid2.DisplayLayout.Bands[0].Columns["BALANCESTATUS_ORG"].Hidden = true; this.ultraGrid1.DisplayLayout.Bands[0].Columns["BUYERCODE"].Hidden = true; this.ultraGrid1.DisplayLayout.Bands[0].Columns["MONEY"].Hidden = true; this.ultraGrid5.DisplayLayout.Bands[0].Columns["ORD_PK"].Hidden = true; this.ultraGrid5.DisplayLayout.Bands[0].Columns["ORD_LN_PK"].Hidden = true; this.ultraGrid5.DisplayLayout.Bands[0].Columns["ORD_LN_DLY_PK"].Hidden = true; // this.ultraGrid5.DisplayLayout.Bands[0].Columns["TRANSNUM"].Hidden = true; } catch { } } public override void ToolBar_Click(object sender, string ToolbarKey) { if (ToolbarKey == "Query") { this.QueryGridOne(); } if (ToolbarKey == "Affrim") { this.Affrim(); } if (ToolbarKey == "UnAffrim") { this.UnAffrim(); } if (ToolbarKey == "RollBack") { this.RollBack(); } if (ToolbarKey == "Exit") { this.Close(); } if (ToolbarKey == "AffrimTrans") { this.AffrimTransMny(); } if (ToolbarKey == "UpdateSendNum") { // this.UpdateSendNum(); } } private void UpdateSendNum() { this.ultraGrid3.UpdateData(); Infragistics.Win.UltraWinGrid.UltraGridRow ugr = null; string askPlanid = ""; if (this.ultraGrid2.Rows.Count == 0) return; if (this.ultraGrid2.Rows.Count == 1) ugr = this.ultraGrid2.Rows[0]; else ugr = this.ultraGrid2.ActiveRow; if (ugr == null) { Util.MessageUtil.ShowError("请选择需要修改的行"); return; } if (Util.MessageUtil.ShowYesNoAndTips("是否确定修改") == DialogResult.No) return; string errMsg = ""; if (this.ultraGrid3.Rows.Count == 0) return; double sendnum = 0; ArrayList list = new ArrayList(); foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugs in this.ultraGrid3.Rows) { if (Util.ConverObject.ConvertToDouble(ugs.Cells["SEND_NUM"].Value) == 0) { Util.MessageUtil.ShowError("请填写修改实发数"); return; } string[] str = new string[2]; str[0] = ugs.Cells["BATCH_NO"].Value.ToString(); str[1] = ugs.Cells["SEND_NUM"].Value.ToString(); list.Add(str); sendnum += Util.ConverObject.ConvertToDouble(ugs.Cells["SEND_NUM"].Value); } string val = sendnum + ""; if (ugr.Cells["BALANCESTATUS"].Value.ToString() != "0" || ugr.Cells["BALANCESTATUS_ORG"].Value.ToString() != "0") { Util.MessageUtil.ShowError("该结算数据已经确认结算，请先取消再修改"); return; } this.slmBalanceInfo.UpdateSendNum( ugr.Cells["ORD_NO"].Value.ToString(), ugr.Cells["ORD_SEQ"].Value.ToString(), ugr.Cells["ORD_LN_DLY"].Value.ToString(), ugr.Cells["ASKPLAN_ID"].Value.ToString(), ugr.Cells["ASKPLAN_ID_SEQ"].Value.ToString(), ugr.Cells["SPETKEY"].Value.ToString(), ugr.Cells["STEELCODEKEY"].Value.ToString(), val,list, CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName(), out errMsg); if (errMsg.Length == 0) { Util.MessageUtil.ShowTips("操作成功"); } askPlanid = ugr.Cells["ASKPLAN_ID"].Value.ToString(); this.QueryGridOne(); foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugrr in this.ultraGrid1.Rows) { if (ugrr.Cells["ASKPLAN_ID"].Value.ToString() == askPlanid) { ugrr.Activated = true; } } } private void AffrimTransMny() { 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 askPlanId = ugr.Cells[StaticData.TbColumnAndCaption.ASKPLAN_ID].Value.ToString(); this.slmBalanceInfo.AffrimTransMnyTicket(askPlanId, CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName()); this.QueryGridOne(); } private void Affrim() { 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]; ugr.Selected = true; ArrayList listask = new ArrayList(); foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugs in this.ultraGrid1.Selected.Rows) { listask.Add(ugs.Cells[StaticData.TbColumnAndCaption.ASKPLAN_ID].Value.ToString()); } // string askPlanId = ugr.Cells[StaticData.TbColumnAndCaption.ASKPLAN_ID].Value.ToString(); if (Util.MessageUtil.ShowYesNoAndQuestion("是否确定选定行？") == DialogResult.No) return; //if (!IsTranmoneyExists()) //{ // return; //} foreach(string s in listask) { this.slmBalanceInfo.AffrimTicket(s, CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName()); } this.QueryGridOne(); } private Boolean IsTranmoneyExists() { if (this.ultraGrid5.Rows.Count == 0) return true; foreach( Infragistics.Win.UltraWinGrid.UltraGridRow ugr in this.ultraGrid5.Rows ) { if ( Util.ConverObject.ConvertToDouble( ugr.Cells["TRANSMNY"].Value) == 0) { Util.MessageUtil.ShowError("有运费暂无输入，请先维护运费"); return false; } } return true; } private void UnAffrim() { 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 askPlanId = ugr.Cells[StaticData.TbColumnAndCaption.ASKPLAN_ID].Value.ToString(); if (Util.MessageUtil.ShowYesNoAndQuestion("是否确定取消选定行？") == DialogResult.No) return; this.slmBalanceInfo.UnAffrimTicket(askPlanId, CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName()); this.QueryGridOne(); } private void RollBack() { 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 askPlanId = ugr.Cells[StaticData.TbColumnAndCaption.ASKPLAN_ID].Value.ToString(); if (Util.MessageUtil.ShowYesNoAndQuestion("是否确定回退提单？") == DialogResult.No) return; foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugs in this.ultraGrid1.Selected.Rows) { askPlanId = ugs.Cells[StaticData.TbColumnAndCaption.ASKPLAN_ID].Value.ToString(); this.slmBalanceInfo.RollBaskAskPlanId(askPlanId, CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName()); ugs.Delete(); } // ugr.Delete(); //this.QueryGridOne(); } private void QueryGridFive() { 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 askPlanId = ugr.Cells[StaticData.TbColumnAndCaption.ASKPLAN_ID].Value.ToString(); DataSet dsDetail = this.ydmZcLoadVehicleMatMgt.GetDistinctOrderLineDeliveryTransitByBillNo(askPlanId); Util.UtilDataSet.SetDataSetByMergeSameColumnName(ref this.dsGridFine, dsDetail); this.SetGrid5TicketNumAndMoney(askPlanId); //DataSet ds = this.slmBalanceInfo.GetSlmBalanceTransMoneyAskPlanid(askPlanId); //ds = Util.UtilDataSet.GetDataSetWithRowFilter(ds, "MONEY_TYPE", "运费"); //Util.UtilDataSet.SetDataSetByMergeSameColumnName(ref this.dsGridFine, ds); } private void QueryGridFour() { Infragistics.Win.UltraWinGrid.UltraGridRow ugr = null; if (this.ultraGrid1.Rows.Count == 0) return; if (this.ultraGrid1.Rows.Count == 1) this.ultraGrid1.Rows[0].Activated = true; ugr = this.ultraGrid1.ActiveRow; if (ugr == null) return; //string orderno = ugr.Cells[StaticData.TbColumnAndCaption.ORD_NO].Value.ToString(); //string orderseq = ugr.Cells[StaticData.TbColumnAndCaption.ORD_SEQ].Value.ToString(); //string orderlineseq = ugr.Cells[StaticData.TbColumnAndCaption.ORD_LN_DLY].Value.ToString(); //string askplanid = ugr.Cells[StaticData.TbColumnAndCaption.ASKPLAN_ID].Value.ToString(); //string askplanidseq = ugr.Cells[StaticData.TbColumnAndCaption.ASKPLAN_ID_SEQ].Value.ToString(); //string spetkey = ugr.Cells[StaticData.TbColumnAndCaption.SPETKEY].Value.ToString(); //string steelkey = ugr.Cells[StaticData.TbColumnAndCaption.STEELCODEKEY].Value.ToString(); string askplanid = ugr.Cells[StaticData.TbColumnAndCaption.ASKPLAN_ID].Value.ToString(); DataSet dsDetail = this.slmBalanceInfo.GetSlmBalanceDetailAllGroupByAskPlanId(askplanid); // orderno, orderseq, orderlineseq, askplanid, askplanidseq, spetkey, steelkey); //DataSet dsDetail = // this.slmBalanceInfo.GetSlmBalanceDetailAllGroupByBatchNo( // orderno, orderseq, orderlineseq, askplanid, askplanidseq, spetkey, steelkey); Util.UtilDataSet.SetDataSetByMergeSameColumnName(ref this.dsGridFour, dsDetail); } private Infragistics.Win.UltraWinGrid.UltraGridRow GetUltraGrid2ActiveRow() { Infragistics.Win.UltraWinGrid.UltraGridRow ugr = null; if (this.ultraGrid2.Rows.Count == 0) return null ; ugr = this.ultraGrid2.ActiveRow; if (ugr == null) ugr = this.ultraGrid2.Rows[0]; return ugr; } private void QueryGridThree() { Infragistics.Win.UltraWinGrid.UltraGridRow ugr = null; if(this.ultraGrid2.Rows.Count == 0) return; if (this.ultraGrid2.Rows.Count == 1) this.ultraGrid2.Rows[0].Activated = true; ugr = this.ultraGrid2.ActiveRow; if (ugr == null) return; string orderno = ugr.Cells[StaticData.TbColumnAndCaption.ORD_NO].Value.ToString(); string orderseq = ugr.Cells[StaticData.TbColumnAndCaption.ORD_SEQ].Value.ToString(); string orderlineseq = ugr.Cells[StaticData.TbColumnAndCaption.ORD_LN_DLY].Value.ToString(); string askplanid = ugr.Cells[StaticData.TbColumnAndCaption.ASKPLAN_ID].Value.ToString(); string askplanidseq = ugr.Cells[StaticData.TbColumnAndCaption.ASKPLAN_ID_SEQ].Value.ToString(); string spetkey = ugr.Cells[StaticData.TbColumnAndCaption.SPETKEY].Value.ToString(); string steelkey = ugr.Cells[StaticData.TbColumnAndCaption.STEELCODEKEY].Value.ToString(); // string askplanid = ugr.Cells[StaticData.TbColumnAndCaption.ASKPLAN_ID].Value.ToString(); DataSet dsDetail = this.slmBalanceInfo.GetSlmBalanceDetailAllGroupByBatchNo(orderno,orderseq,orderlineseq, askplanid,askplanidseq,spetkey,steelkey); Util.UtilDataSet.SetDataSetByMergeSameColumnName(ref this.dsGridThree, dsDetail); InitGird3(ugr.Cells["ORDER_UNIT"].Value.ToString()); } private void InitGird3(String orderUnit) { if (orderUnit == "吨" || orderUnit == "支") { this.ultraGrid3.DisplayLayout.Bands[0].Columns["SEND_NUM"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly; this.ultraGrid3.DisplayLayout.Bands[0].Columns["SEND_NUM"].CellAppearance.BackColor = this.ultraGrid1.DisplayLayout.Bands[0].Columns[0].CellAppearance.BackColor; } else { try { this.ultraGrid3.DisplayLayout.Bands[0].Columns["SEND_NUM"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit; this.ultraGrid3.DisplayLayout.Bands[0].Columns["SEND_NUM"].CellAppearance.BackColor = base.GetEditColor(); // this.ultraGrid2.DisplayLayout.Bands[0].Columns["SEND_NUM"].MaskInput = "-nnnnnnnn.nnn"; // this.ultraGrid2.DisplayLayout.Bands[0].Columns["SEND_NUM"].Format = ""; } catch { } } } private void QueryGridTwo() { 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 askPlanId = ugr.Cells[StaticData.TbColumnAndCaption.ASKPLAN_ID].Value.ToString(); DataSet ds = Util.UtilDataSet.GetDataSetWithRowFilter(this.dsBalance, StaticData.TbColumnAndCaption.ASKPLAN_ID, askPlanId); Util.UtilDataSet.SetDataSetByMergeSameColumnName(ref this.dsGridTwo, ds); } private void SetTransMoney(ref DataSet dsGridOne) { if (dsGridOne == null || dsGridOne.Tables.Count == 0 || dsGridOne.Tables[0].Rows.Count == 0) return; double money = 0; double outstockmoney = 0; foreach (DataRow dr in dsGridOne.Tables[0].Rows) { money = 0; outstockmoney = 0; string askPlanId = dr[StaticData.TbColumnAndCaption.ASKPLAN_ID].ToString(); DataSet dsDetail = this.slmBalanceInfo.GetSlmBalanceDetailAllGroupByAskPlanId(askPlanId); try { if (dsDetail.Tables[0].Rows.Count > 0) { foreach (DataRow dr1 in dsDetail.Tables[0].Rows) { outstockmoney += Util.ConverObject.ConvertToDouble(dr1["OUTSTOCKMNY"].ToString()); } dr["OUTSTOCKMNY"] = outstockmoney; } } catch { } DataSet ds = this.slmBalanceInfo.GetSlmBalanceTransMoneyAskPlanid(askPlanId); ds = Util.UtilDataSet.GetDataSetWithRowFilter(ds, "MONEY_TYPE", "运费"); if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) continue; foreach (DataRow dr0 in ds.Tables[0].Rows) { money += Util.ConverObject.ConvertToDouble(dr0["MONEY"].ToString()); } dr["TRANSMNY"] = money; } } private void ClearGrid() { this.dsGridTwo.Clear(); this.dsGridThree.Clear(); this.dsGridFour.Clear(); this.dsGridFine.Clear(); } private void QueryGridOne() { DataSet ds = null; Boolean exists = false; ArrayList list = new ArrayList(); if (this.radioButton1.Checked) { ds = this.slmBalanceInfo.GetunAffrimTicketsSlmBalaneInfoByPlanBeginDateAndEndDate(this.dateTimePicker1.Value, this.dateTimePicker2.Value); DataSet dsClosedAskpLanid = this.slmBalanceInfo.GetUnAffrimVirtualTicketsSlmBalaneInfoByPlanBeginDateAndEndDate(this.dateTimePicker1.Value, this.dateTimePicker2.Value); try { if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) ds = dsClosedAskpLanid; else { foreach (DataRow dr in dsClosedAskpLanid.Tables[0].Rows) { if (ds.Tables[0].Select(string.Format(" ASKPLAN_ID = '{0}' ", dr["ASKPLAN_ID"].ToString())).Length == 0) { if (!list.Contains(dr["ASKPLAN_ID"].ToString())) { list.Add(dr["ASKPLAN_ID"].ToString()); } } } foreach (string s in list) { DataRow[] drs = dsClosedAskpLanid.Tables[0].Select(string.Format(" ASKPLAN_ID = '{0}' ", s)); foreach (DataRow drss in drs) { ds.Tables[0].Rows.Add(drss.ItemArray); } } } } catch { } } if (this.radioButton2.Checked) { ds = this.slmBalanceInfo.GetAffrimTicketsSlmBalaneInfoByPlanBeginDateAndEndDate(this.dateTimePicker1.Value, this.dateTimePicker2.Value); } if (this.textBox7.Text.Length > 0) { ds = Util.UtilDataSet.GetDataSetWithRowFilterWithApproximateMatch(ds, StaticData.TbColumnAndCaption.ASKPLAN_ID, this.textBox7.Text.Trim()); } if (this.textBox1.Text.Length > 0) { ds = Util.UtilDataSet.GetDataSetWithRowFilterWithApproximateMatch(ds, StaticData.TbColumnAndCaption.ORD_NO, this.textBox1.Text.Trim()); } if (!this.UserInfo.GetUserName().Equals("admin")) { ds = base.GetDataSetByFilterDeptId(ds); } this.dsBalance = ds.Copy(); ds = Util.UtilDataSet.GetDateSetByGroupColumnAndStaticsColumnName(ds, new List(GetGridOneGroupColumn()), null, new List(new string[]{StaticData.TbColumnAndCaption.QUANTITY, StaticData.TbColumnAndCaption.WEIGHT, StaticData.TbColumnAndCaption.MONEY})); Util.UtilDataSet.SetDataSetByMergeSameColumnName(ref this.dsGridOne, ds); SetTransMoney(ref this.dsGridOne); ClearGrid(); } private string[] GetGridOneGroupColumn() { return new string[] { StaticData.TbColumnAndCaption.ASKPLAN_ID, StaticData.TbColumnAndCaption.BUYERCODE, StaticData.TbColumnAndCaption.BUYERNAME, StaticData.TbColumnAndCaption.INCEPTCORPCODE, StaticData.TbColumnAndCaption.ISPRECLOSE, "ISREALCLOSE", "TICKETSTATUS" }; } 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("TRANSNUM", "System.String"); return hs; } private string[] GetGridFiveDataStruct() { return new string[] { // "TICKETTYPE", // "MONEY", // "TICKETNUM", // "MONEY_TYPE", // "TRANS_TYPE", // "MOTORMANNAME", // "REG_ID", // "REG_DTIME", // // "AFFRIM_ID", //// "AFFRIM_TIME", // "STATUS_CD" "TRANSMNY", // " TRANSNUM", "TRANS_TYPE", "AGENCY_FL", "DESTINATION", "STATION_NO", "SPCL_LN_NO", "DESTINATION", "PORT_NO", // "CARRIER_UNIT", "RECEIVOR", "RECEIV_ADDR", "DELVRY_ADDR", "ORD_PK", "ORD_LN_PK", "ORD_LN_DLY_PK", "ORDER_NO", "ORDER_SEQ", "DELIVERY_NO", "INDEX_SEQ" }; } private string[] GetGridFourDataStruct() { return new string[] { "ASKPLAN_ID", "TALLYSHEET_NO", "BATCH_NO", "QUANTITY", "ACT_WGT" , "OUTSTOCKMNY", "MONEY_TYPE", "AGENCY_FL", "DELVRY_ADDR", "RECEIV_ADDR" }; } private string[] GetGridThreeDataStruct() { return new string[] { "ASKPLAN_ID", "TALLYSHEET_NO", // "ORD_LN_DLY", "BATCH_NO", "SEND_NUM", "QUANTITY", "ACT_WGT" , "PLID" }; } private string[] GetGridTwoDataStruct() { return new string[] { // "BUYERCODE", "ORD_NO", "ORD_SEQ", "ORD_LN_DLY", "ASKPLAN_ID", "ASKPLAN_ID_SEQ", "CATEGORY", "SPEC_ABBSYMNAME", "STD_STYLE_DESC", "STEELCODEKEY", "MODEL_DESC", "SPETKEY", "SEND_NUM", "QUANTITY", "WEIGHT", "ORDER_UNIT", // "PRICE", // "MONEY", // "BASEPRICE", // "STATIONCODE", "TICKETPERSON", "TICKETDATE", "FORECORPCODE", "TRANS_TYPE_NAME", "BALANCESTATUS_ORG", // "AREACODE", // "DOCKCODE", // "SHIPNO", // "FIXSIZE", "BALANCESTATUS" }; } private string[] GetGridOneDataStruct() { return new string[] { "ASKPLAN_ID", "BUYERCODE", "BUYERNAME", "INCEPTCORPCODE", "QUANTITY", "WEIGHT", "MONEY", "OUTSTOCKMNY", "TRANSMNY", "ISPRECLOSE", "ISREALCLOSE", "TICKETSTATUS" }; } 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 ultraGrid1_AfterRowActivate(object sender, EventArgs e) { this.QueryGridTwo(); this.QueryGridThree(); this.QueryGridFive(); } private void ultraGrid2_AfterRowActivate(object sender, EventArgs e) { this.QueryGridThree(); this.QueryGridFour(); } private void ultraGrid1_AfterRowActivate_1(object sender, EventArgs e) { this.QueryGridTwo(); this.QueryGridThree(); this.QueryGridFive(); } private void ultraGrid2_AfterRowActivate_1(object sender, EventArgs e) { this.QueryGridThree(); this.QueryGridFour(); } private void ultraGrid1_KeyPress(object sender, KeyPressEventArgs e) { if (e.KeyChar == 13) { this.Affrim(); } } private void textBox7_KeyDown(object sender, KeyEventArgs e) { } private void textBox7_KeyPress(object sender, KeyPressEventArgs e) { if (e.KeyChar == 13) { this.QueryGridOne(); } } private void textBox1_KeyPress(object sender, KeyPressEventArgs e) { if (e.KeyChar == 13) { this.QueryGridOne(); } } } }