using Core.Mes.Client.Comm; using Core.Mes.Client.Comm.Control; using Core.Mes.Client.Comm.Server; using Core.Mes.Client.Comm.Tool; using Core.StlMes.Client.GlBusiness.Dialog; using Core.StlMes.Client.Judge.Forms; using CoreFS.CA06; using Infragistics.Win; using Infragistics.Win.UltraWinGrid; using System; using System.Collections; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; namespace Core.StlMes.Client.GlBusiness { public partial class FrmGpPriceCarry : FrmBase { public FrmGpPriceCarry() { InitializeComponent(); } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "doQuery": doQuery();//查询 break; case "doAdd": doAdd();//挂账 break; case "doDelete": doDelete();//取消挂账 break; case "doPrint": doPrint();//打印 break; case "Close": Close();//关闭 break; } } private void doQuery() { if (ultraTabControl1.SelectedTab == ultraTabControl1.Tabs[0]) { string orderNo = ""; //合同号 string orderStart = ""; string orderEnd = ""; if (uchkOrderNo.Checked) { orderNo = utxtOrderNo.Text.Trim(); } if (uchkDate.Checked) { orderStart = udtStart.DateTime.ToString("yyyy-MM-dd") + " 00:00:01"; orderEnd = udtEnd.DateTime.ToString("yyyy-MM-dd") + " 23:59:59"; } else { orderStart = "1000-01-01 00:00:01"; orderEnd = "9999-12-31 23:59:59"; } DataTable dt = ServerHelper.GetData("com.steering.pss.glbusiness.GlOrderManage.QueryHeadAndLineGp", new Object[] { orderNo, orderStart, orderEnd, this.ValidDataPurviewIds }, this.ob); GridHelper.CopyDataToDatatable(ref dt, ref this.orderLine, true); GridHelper.RefreshAndAutoSizeExceptColumns(this.ultraGrid1); } else { string balanceNo = ""; string orderNo = ""; //合同号 string orderStart = ""; string orderEnd = ""; if (ckBalanceNo.Checked) { balanceNo = utBalanceNo.Text.Trim(); } if (ckOrderNo.Checked) { orderNo = utOrderNo.Text.Trim(); } if (ckDate.Checked) { orderStart = utDate1.DateTime.ToString("yyyy-MM-dd") + " 00:00:01"; orderEnd = utDate2.DateTime.ToString("yyyy-MM-dd") + " 23:59:59"; } else { orderStart = "1000-01-01 00:00:01"; orderEnd = "9999-12-31 23:59:59"; } DataTable dt = ServerHelper.GetData("com.steering.pss.glbusiness.GlOrderManage.QueryBalanceInfo", new Object[] { balanceNo, orderNo, orderStart, orderEnd, txt_isPrint.Value.ToString()}, this.ob); GridHelper.CopyDataToDatatable(ref dt, ref this.dataTable1, true); GridHelper.RefreshAndAutoSizeExceptColumns(this.ultraGrid3); } } private void doAdd() { if (ultraGrid1.ActiveRow == null) return; List list = new List(); List rows = ComHelper.UltraGridGetChooseRows(ultraGrid2); if (rows.Count <= 0) { MessageUtil.ShowTips("请勾选需要挂账的数据"); return; } foreach (UltraGridRow row in rows) { if (!list.Contains(row.Cells["OUTSTOCK_DOC"].Value.ToString())) list.Add(row.Cells["OUTSTOCK_DOC"].Value.ToString()); } String ordLnPk = ultraGrid1.ActiveRow.Cells["ORD_LN_PK"].Value.ToString(); String gradeCode = ultraGrid1.ActiveRow.Cells["GRADECODE"].Value.ToString(); String diamter = ultraGrid1.ActiveRow.Cells["DIMATER"].Value.ToString(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.glbusiness.GlOrderManage"; ccp.MethodName = "addGpPriceInfo"; ccp.ServerParams = new object[] { list, ordLnPk, gradeCode,diamter, UserInfo.GetUserName() }; ccp.IfShowErrMsg = false; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp != null) { if (ccp.ReturnCode == -1) { MessageUtil.ShowWarning(ccp.ReturnInfo); return; } MessageUtil.ShowTips("挂账成功!"); doQuery(); } } private void doDelete() { if (ultraGrid3.ActiveRow == null) return; if (MessageUtil.ShowYesNoAndQuestion("是否确认撤销挂账?") == DialogResult.No) return; String balanceNo = ultraGrid3.ActiveRow.Cells["BALANCE_NO"].Value.ToString(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.glbusiness.GlOrderManage"; ccp.MethodName = "doCancelCarryGp"; ccp.ServerParams = new object[] { balanceNo }; ccp.IfShowErrMsg = false; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp != null) { if (ccp.ReturnCode == -1) { MessageUtil.ShowWarning(ccp.ReturnInfo); return; } MessageUtil.ShowTips("撤销成功!"); doQuery(); } } private void FrmGlPriceCarry_Load(object sender, EventArgs e) { //默认查询当前日期-1月——当前日期数据。 udtStart.DateTime = Convert.ToDateTime(DateTime.Now.AddMonths(-1).ToShortDateString()); udtEnd.DateTime = Convert.ToDateTime(DateTime.Now.ToShortDateString()); utDate1.DateTime = Convert.ToDateTime(DateTime.Now.AddMonths(-1).ToShortDateString()); utDate2.DateTime = Convert.ToDateTime(DateTime.Now.ToShortDateString()); txt_isPrint.SelectedIndex = 0; ValueList list2 = new ValueList(); ValueListItem[] items2 = new ValueListItem[] { new ValueListItem("0", "否"), new ValueListItem("1", "是") }; list2.ValueListItems.AddRange(items2); ultraGrid1.DisplayLayout.Bands[0].Columns["PRODUCER_FL"].ValueList = list2; GridHelper.SetAllColumnsActive(ultraGrid1); //if (toolMenu.Toolbars[0].Tools.Exists("doDelete")) { toolMenu.Toolbars[0].Tools["doDelete"].InstanceProps.Visible = DefaultableBoolean.False; } ComHelper.SetComboItemHeight(txt_isPrint); } private void uchkDate_CheckedChanged(object sender, EventArgs e) { if (uchkDate.Checked) { udtStart.ReadOnly = false; udtEnd.ReadOnly = false; } else { udtStart.ReadOnly = true; udtEnd.ReadOnly = true; } } private void uchkOrderNo_CheckedChanged(object sender, EventArgs e) { if (uchkOrderNo.Checked) utxtOrderNo.ReadOnly = false; else utxtOrderNo.ReadOnly = true; } private void ultraGrid1_AfterRowActivate(object sender, EventArgs e) { queryOutInfo(); } private void queryOutInfo(){ if (ultraGrid1.ActiveRow == null) return; String gradeCode = ultraGrid1.ActiveRow.Cells["GRADECODE"].Value.ToString(); String dimater = ultraGrid1.ActiveRow.Cells["DIMATER"].Value.ToString(); DataTable dt = ServerHelper.GetData("com.steering.pss.glbusiness.GlOrderManage.QueryGpOutList", new Object[] { gradeCode,dimater }, this.ob); GridHelper.CopyDataToDatatable(ref dt, ref this.outList, true); } private void ckBalanceNo_CheckedChanged(object sender, EventArgs e) { if (ckBalanceNo.Checked) utBalanceNo.ReadOnly = false; else utBalanceNo.ReadOnly = true; } private void ckOrderNo_CheckedChanged(object sender, EventArgs e) { if (ckOrderNo.Checked) utOrderNo.ReadOnly = false; else utOrderNo.ReadOnly = true; } private void ckDate_CheckedChanged(object sender, EventArgs e) { if (ckDate.Checked) { utDate1.ReadOnly = false; utDate2.ReadOnly = false; } else { utDate1.ReadOnly = true; utDate2.ReadOnly = true; } } private void doPrint() { if (ultraGrid3.ActiveRow == null) return; List list = new List(); foreach (UltraGridRow row in ultraGrid3.Rows.Where(t => t.Selected)) { list.Add(row.Cells["BALANCE_NO"].Value.ToString()); } if (list.Count <= 0) { MessageUtil.ShowTips("请选择需要打印的数据"); return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.glbusiness.GlOrderManage"; ccp.MethodName = "doPrint"; ccp.ServerParams = new object[] { list }; ccp.IfShowErrMsg = false; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp != null) { if (ccp.ReturnCode == -1) { MessageUtil.ShowWarning(ccp.ReturnInfo); return; } string strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepInvoiceTicketTHGL.cpt&op=view" + "&PRINT_NO=" + ccp.ReturnInfo; FrmOrderRepExcel fBug = new FrmOrderRepExcel(this.ob, strurl); fBug.AutoSize = true; fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height); fBug.WindowState = FormWindowState.Maximized; fBug.Text = "半成品结算清单"; fBug.Show(); doQuery(); doQuery(); } } private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e) { if (toolMenu == null) return; if (ultraTabControl1.SelectedTab == ultraTabControl1.Tabs[0]) { if (toolMenu.Toolbars[0].Tools.Exists("doAdd")) { toolMenu.Toolbars[0].Tools["doAdd"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("doDelete")) { toolMenu.Toolbars[0].Tools["doDelete"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("doPrint")) { toolMenu.Toolbars[0].Tools["doPrint"].InstanceProps.Visible = DefaultableBoolean.False; } } else { if (toolMenu.Toolbars[0].Tools.Exists("doAdd")) { toolMenu.Toolbars[0].Tools["doAdd"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("doDelete")) { toolMenu.Toolbars[0].Tools["doDelete"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("doPrint")) { toolMenu.Toolbars[0].Tools["doPrint"].InstanceProps.Visible = DefaultableBoolean.True; } } } private void FrmGpPriceCarry_Shown(object sender, EventArgs e) { if (toolMenu == null) return; if (ultraTabControl1.SelectedTab == ultraTabControl1.Tabs[0]) { if (toolMenu.Toolbars[0].Tools.Exists("doAdd")) { toolMenu.Toolbars[0].Tools["doAdd"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("doDelete")) { toolMenu.Toolbars[0].Tools["doDelete"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("doPrint")) { toolMenu.Toolbars[0].Tools["doPrint"].InstanceProps.Visible = DefaultableBoolean.False; } } else { if (toolMenu.Toolbars[0].Tools.Exists("doAdd")) { toolMenu.Toolbars[0].Tools["doAdd"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("doDelete")) { toolMenu.Toolbars[0].Tools["doDelete"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("doPrint")) { toolMenu.Toolbars[0].Tools["doPrint"].InstanceProps.Visible = DefaultableBoolean.True; } } } } }