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 FrmGlOrderManage : FrmBase { public FrmGlOrderManage() { InitializeComponent(); this.IsLoadUserView = true; } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "doQuery": doQuery();//查询 break; case "doAdd": doAdd();//新增合同 break; case "doUpdate": doUpdate();//修改合同 break; case "doDelete": doDelete();//作废合同头 break; case "doSavePrice": doSavePrice();///价格维护 break; case "doConfirm": doConfirm();//确认生效 break; case "cancelConfirm": cancelConfirm();//取消确认 break; case "doApprove1": doApprove("1");//审批通过 break; case "doApprove2": doApprove("2");//审批退回 break; case "doApprove3": doApprove("3");//审批拒绝 break; case "doReturn": doReturn();//审批拒绝 break; case "doPrint": doPrint();//打印 break; case "queryBuyInfo": queryInfo("122302"); break; case "querySaleInfo": queryInfo("122301"); break; } } private void doQuery() { 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.doQuery", new Object[] { orderNo, orderStart, orderEnd, this.ValidDataPurviewIds }, this.ob); GridHelper.CopyDataToDatatable(ref dt, ref this.orderHead, true); if (orderHead.Rows.Count<=0) orderLine.Clear(); GridHelper.RefreshAndAutoSizeExceptColumns(this.ultraGrid1, "MNY_ASK_DESC"); } private void doAdd() { orderHeadInfo head = new orderHeadInfo(); head.Key = "add"; head.ob = this.ob; head.ShowDialog(); if (head.CloseEvent.Equals("Add")) this.doQuery(); } private void doUpdate() { if (this.ultraGrid1.ActiveRow == null) return; if (!ultraGrid1.ActiveRow.Cells["VALIDFLAG"].Value.ToString().Equals("10")) { MessageUtil.ShowTips("合同状态非有效状态，不能修改"); return; } orderHeadInfo head = new orderHeadInfo(); head.Key = "update"; head.OrdPk = ultraGrid1.ActiveRow.Cells["ORD_PK"].Value.ToString(); head.ob = this.ob; head.ShowDialog(); if (head.CloseEvent.Equals("Add")) this.doQuery(); } private void doDelete() { if (ultraGrid1.ActiveRow == null) return; if (!ultraGrid1.ActiveRow.Cells["VALIDFLAG"].Value.ToString().Equals("10")) { MessageUtil.ShowTips("合同状态非有效状态，不能作废"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否确认作废选中合同？") == DialogResult.No) return; String ordPk = ultraGrid1.ActiveRow.Cells["ord_pk"].Value.ToString(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.glbusiness.GlOrderManage"; ccp.MethodName = "deleteHead"; ccp.ServerParams = new object[] { ordPk }; 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 doSavePrice() { if (ultraGrid1.ActiveRow == null) return; List listRow = ComHelper.UltraGridGetOtherRows(ultraGrid2, "Choose"); if(listRow.Count<=0) { MessageUtil.ShowTips("请选择需要保存的记录"); return; } if (!ultraGrid1.ActiveRow.Cells["VALIDFLAG"].Value.ToString().Equals("10")) { MessageUtil.ShowTips("合同状态非有效状态，不能保存价格"); return; } ArrayList parm = new ArrayList(); foreach (UltraGridRow row in listRow) { ArrayList list = new ArrayList(); list.Add(row.Cells["BALNCE_PRICE"].Value.ToString()); list.Add(row.Cells["BALNCE_TOL_PRICE"].Value.ToString()); list.Add(row.Cells["ORD_LN_PK"].Value.ToString()); parm.Add(list); } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.glbusiness.GlOrderManage"; ccp.MethodName = "doSavePrice"; ccp.ServerParams = new object[] { parm }; 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 doConfirm() { if (ultraGrid1.ActiveRow==null) return; String ordPk = ultraGrid1.ActiveRow.Cells["ord_pk"].Value.ToString(); if (!ultraGrid1.ActiveRow.Cells["VALIDFLAG"].Value.ToString().Equals("10")) { MessageUtil.ShowTips("合同状态非有效状态，不能确认"); return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.glbusiness.GlOrderManage"; ccp.MethodName = "doConfirm"; ccp.ServerParams = new object[] { ordPk }; 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 cancelConfirm() { if (ultraGrid1.ActiveRow == null) return; if (!ultraGrid1.ActiveRow.Cells["VALIDFLAG"].Value.ToString().Equals("20")) { MessageUtil.ShowTips("合同状态非生效状态，不能取消确认"); return; } if (!ultraGrid1.ActiveRow.Cells["APPROVALFLAG"].Value.ToString().Equals("00")) { MessageUtil.ShowTips("评审状态非待审不能取消确认"); return; } String ordPk = ultraGrid1.ActiveRow.Cells["ord_pk"].Value.ToString(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.glbusiness.GlOrderManage"; ccp.MethodName = "cancelConfirm"; ccp.ServerParams = new object[] { ordPk }; ccp.IfShowErrMsg = false; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp != null) { if (ccp.ReturnCode == -1) { MessageUtil.ShowWarning(ccp.ReturnInfo); return; } MessageUtil.ShowTips("取消确认成功！"); doQuery(); } } //审批通过 1 退回 2 拒绝 3 private void doApprove(String flag) { if (ultraGrid1.ActiveRow == null) return; String ordPk = ultraGrid1.ActiveRow.Cells["ord_pk"].Value.ToString(); if (!ultraGrid1.ActiveRow.Cells["VALIDFLAG"].Value.ToString().Equals("20")) { MessageUtil.ShowTips("合同状态非生效不能审批"); return; } if (!ultraGrid1.ActiveRow.Cells["APPROVALFLAG"].Value.ToString().Equals("00")) { MessageUtil.ShowTips("评审状态非待审不能审批"); return; } glReviewMemo gl = new glReviewMemo(); gl.ShowDialog(); string reviewMemo = gl.ReviewMemo; if (gl.DialogResult != DialogResult.OK) return; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.glbusiness.GlOrderManage"; ccp.MethodName = "doApprove"; ccp.ServerParams = new object[] { ordPk, flag, reviewMemo,UserInfo.GetUserID(),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 doReturn() { if (ultraGrid1.ActiveRow == null) return; String ordPk = ultraGrid1.ActiveRow.Cells["ord_pk"].Value.ToString(); if (!ultraGrid1.ActiveRow.Cells["VALIDFLAG"].Value.ToString().Equals("20")) { MessageUtil.ShowTips("合同状态非生效不能撤销审批"); return; } if (ultraGrid1.ActiveRow.Cells["APPROVALFLAG"].Value.ToString().Equals("00")) { MessageUtil.ShowTips("未审批，不需要撤销审批"); return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.glbusiness.GlOrderManage"; ccp.MethodName = "doReturn"; ccp.ServerParams = new object[] { ordPk }; 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 doPrint() { UltraGridRow ugr = this.ultraGrid1.ActiveRow; if (ugr == null) { MessageUtil.ShowTips("无数据，请确认！"); return; } string strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepFormalPurchaseContractTH.cpt&op=view" + "&ORD_PK=" + ugr.Cells["ORD_PK"].Value.ToString(); 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(); } private void doApproval() { throw new NotImplementedException(); } private void queryInfo(String flag) { FrmMatInfo line = new FrmMatInfo(); line.ob = this.ob; line.Flag = "1"; line.TradeType = flag; line.ShowDialog(); } private void FrmGlOrderManage_Load(object sender, EventArgs e) { //默认查询当前日期-1月——当前日期数据。 udtStart.DateTime = Convert.ToDateTime(DateTime.Now.AddMonths(-1).ToShortDateString()); udtEnd.DateTime = Convert.ToDateTime(DateTime.Now.ToShortDateString()); DataTable dtCmbType = ServerHelper.GetData("com.steering.pss.glbusiness.GlOrderManage.getBaseInfo", new object[] { "1223" }, this.ob); ultraGrid1.DisplayLayout.Bands[0].Columns["TRADE_TYPE"].ValueList = ComHelper.List_GetBaseInfo(dtCmbType); DataTable dtOrderType = ServerHelper.GetData("com.steering.pss.glbusiness.GlOrderManage.getBaseInfo", new object[] { "1201" }, this.ob); ultraGrid1.DisplayLayout.Bands[0].Columns["ORDER_TYP"].ValueList = ComHelper.List_GetBaseInfo(dtOrderType); DataTable dtOrderUnit = ServerHelper.GetData("com.steering.pss.glbusiness.GlOrderManage.getBaseInfo", new object[] { "1205" }, this.ob); ultraGrid1.DisplayLayout.Bands[0].Columns["SUPPLY_UNIT"].ValueList = ComHelper.List_GetBaseInfo(dtOrderUnit); DataTable dtAddress = ServerHelper.GetData("com.steering.pss.glbusiness.GlOrderManage.getBaseInfo", new object[] { "1106" }, this.ob); ultraGrid1.DisplayLayout.Bands[0].Columns["DELVRY_ADDR"].ValueList = ComHelper.List_GetBaseInfo(dtAddress); DataTable dtDeliveryType = ServerHelper.GetData("com.steering.pss.glbusiness.GlOrderManage.getBaseInfo", new object[] { "1208" }, this.ob); ultraGrid1.DisplayLayout.Bands[0].Columns["DELVRY_TYPE"].ValueList = ComHelper.List_GetBaseInfo(dtDeliveryType); DataTable dtTransType = ServerHelper.GetData("com.steering.pss.glbusiness.GlOrderManage.getBaseInfo", new object[] { "1105" }, this.ob); ultraGrid1.DisplayLayout.Bands[0].Columns["TRANSIT_TYPE"].ValueList = ComHelper.List_GetBaseInfo(dtTransType); DataTable dtPackType = ServerHelper.GetData("com.steering.pss.glbusiness.GlOrderManage.getBaseInfo", new object[] { "1232" }, this.ob); ultraGrid1.DisplayLayout.Bands[0].Columns["PACK_TYPE"].ValueList = ComHelper.List_GetBaseInfo(dtPackType); DataTable dtPayType = ServerHelper.GetData("com.steering.pss.glbusiness.GlOrderManage.getBaseInfo", new object[] { "1212" }, this.ob); ultraGrid1.DisplayLayout.Bands[0].Columns["MNY_ASK_TYP"].ValueList = ComHelper.List_GetBaseInfo(dtPayType); ValueList list = new ValueList(); ValueListItem[] items = new ValueListItem[] { new ValueListItem("00", "无效"), new ValueListItem("10", "有效"), new ValueListItem("20", "生效"), }; list.ValueListItems.AddRange(items); ultraGrid1.DisplayLayout.Bands[0].Columns["VALIDFLAG"].ValueList = list; ValueList list1 = new ValueList(); ValueListItem[] items1 = new ValueListItem[] { new ValueListItem("00", "待审"), new ValueListItem("10", "通过"), new ValueListItem("20", "退回"), new ValueListItem("30", "拒绝"), }; list1.ValueListItems.AddRange(items1); ultraGrid1.DisplayLayout.Bands[0].Columns["APPROVALFLAG"].ValueList = list1; ValueList list2 = new ValueList(); ValueListItem[] items2 = new ValueListItem[] { new ValueListItem("0", "否"), new ValueListItem("1", "是") }; list2.ValueListItems.AddRange(items2); ultraGrid2.DisplayLayout.Bands[0].Columns["PRODUCER_FL"].ValueList = list2; GridHelper.SetAllColumnsActive(ultraGrid1); if("1".Equals(CustomInfo)) { GridHelper.SetAllColumnsActive(ultraGrid2); ultraGrid2.DisplayLayout.Bands[0].Columns["Choose"].Hidden = true; ultraGrid2.DisplayLayout.Bands[0].Columns["BALNCE_PRICE"].Hidden = true; ultraGrid2.DisplayLayout.Bands[0].Columns["BALNCE_TOL_PRICE"].Hidden = true; } else { ultraToolbarsManager1.Visible = false; GridHelper.SetColumnsActivateAndColor(ultraGrid2.Rows.Band, "Choose", "BALNCE_PRICE"); } } private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e) { switch (e.Tool.Key) { case "Add": Add(); break; case "Delete": DeleteLine(); break; case "Export": GridHelper.ulGridToExcel(ultraGrid2, "关联交易合同行信息表"); break; } } private void DeleteLine() { if (ultraGrid2.ActiveRow == null) return; String ordLnPk = ultraGrid2.ActiveRow.Cells["ord_ln_pk"].Value.ToString(); if (!"10".Equals(ultraGrid1.ActiveRow.Cells["VALIDFLAG"].Value.ToString())) { MessageUtil.ShowWarning("合同状态为有效时才能作废合同行"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否确认作废选中合同行？") == DialogResult.No) return; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.glbusiness.GlOrderManage"; ccp.MethodName = "deleteLine"; ccp.ServerParams = new object[] { ordLnPk }; ccp.IfShowErrMsg = false; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp != null) { if (ccp.ReturnCode == -1) { MessageUtil.ShowWarning(ccp.ReturnInfo); return; } MessageUtil.ShowTips("作废成功！"); queryLine(); } } private void Add() { if (ultraGrid1.ActiveRow == null) return; String ordPk = ultraGrid1.ActiveRow.Cells["ord_pk"].Value.ToString(); if (!"10".Equals(ultraGrid1.ActiveRow.Cells["VALIDFLAG"].Value.ToString())) { MessageUtil.ShowWarning("合同状态为有效时才能新增合同行"); return; } FrmMatInfo line = new FrmMatInfo(); line.ob = this.ob; line.OrdPk = ordPk; line.Flag = "0"; line.TradeType = ultraGrid1.ActiveRow.Cells["TRADE_TYPE"].Value.ToString(); line.ShowDialog(); if (line.CloseEvent.Equals("Add")) { this.doQuery(); foreach (UltraGridRow row in ultraGrid1.Rows) { if (row.Cells["ORD_PK"].Value.ToString() == ordPk) { row.Activate(); break; } } } } private void ultraGrid1_AfterRowActivate(object sender, EventArgs e) { queryLine(); } public void queryLine() { if (ultraGrid1.ActiveRow == null) return; String ordPk = ultraGrid1.ActiveRow.Cells["ord_pk"].Value.ToString(); DataTable dt = ServerHelper.GetData("com.steering.pss.glbusiness.GlOrderManage.doQueryLine", new Object[] { ordPk }, this.ob); GridHelper.CopyDataToDatatable(ref dt, ref this.orderLine, true); } 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 ultraGrid2_CellChange(object sender, CellEventArgs e) { this.ultraGrid2.UpdateData(); if (e.Cell.Column.Key != "BALNCE_PRICE") return; int i = e.Cell.Row.Index; double price =0; if (!double.TryParse(ultraGrid2.Rows[i].Cells["BALNCE_PRICE"].Text, out price)) return; double weight = double.Parse(ultraGrid2.Rows[i].Cells["ORDER_QTY"].Text); double money = price * weight; ultraGrid2.Rows[i].Cells["BALNCE_TOL_PRICE"].Value = Math.Round(money, 3); } private void uchkOrderNo_CheckedChanged(object sender, EventArgs e) { if (uchkOrderNo.Checked) utxtOrderNo.ReadOnly = false; else utxtOrderNo.ReadOnly = true; } private void craftImg_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e) { string filePath = ultraGrid2.ActiveRow.GetValue("CRAFT_NO"); DataTable dt = ServerHelper.GetData("com.steering.pss.glbusiness.GlOrderManage.getFilePath", new Object[] { filePath }, this.ob); string file = dt.Rows[0]["CRAFT_PATH"].ToString3(); dlgOrderAskDown askDown = new dlgOrderAskDown(this.ob,file); askDown.DeleteButton.Visible = false; askDown.Show(); } } }