From 35234992fc339e6a5fb283feec593d7692955862 Mon Sep 17 00:00:00 2001 From: lu <99954486@qq.com> Date: 星期六, 07 十二月 2024 08:11:25 +0800 Subject: [PATCH] 1 --- DevApp/Gs.DevApp/UserControl/SelectCheckDt.cs | 101 ++++++----- DevApp/Gs.DevApp/ToolBox/UpdateParentEventArgs.cs | 2 DevApp/Gs.DevApp/UserControl/SelectCheckDt.Designer.cs | 147 ++++++++------- DevApp/Gs.DevApp/DevFrm/QC/Frm_MesQmCheckitemDt.cs | 78 +++----- DevApp/Gs.DevApp/DevFrm/QC/Frm_MesQmCheckitemDt.Designer.cs | 209 ++++++++++++++++++++-- 5 files changed, 351 insertions(+), 186 deletions(-) diff --git a/DevApp/Gs.DevApp/DevFrm/QC/Frm_MesQmCheckitemDt.Designer.cs b/DevApp/Gs.DevApp/DevFrm/QC/Frm_MesQmCheckitemDt.Designer.cs index 11017ee..32d436b 100644 --- a/DevApp/Gs.DevApp/DevFrm/QC/Frm_MesQmCheckitemDt.Designer.cs +++ b/DevApp/Gs.DevApp/DevFrm/QC/Frm_MesQmCheckitemDt.Designer.cs @@ -29,11 +29,16 @@ /// </summary> private void InitializeComponent() { - DevExpress.XtraEditors.Controls.EditorButtonImageOptions editorButtonImageOptions3 = new DevExpress.XtraEditors.Controls.EditorButtonImageOptions(); - DevExpress.Utils.SerializableAppearanceObject serializableAppearanceObject9 = new DevExpress.Utils.SerializableAppearanceObject(); - DevExpress.Utils.SerializableAppearanceObject serializableAppearanceObject10 = new DevExpress.Utils.SerializableAppearanceObject(); - DevExpress.Utils.SerializableAppearanceObject serializableAppearanceObject11 = new DevExpress.Utils.SerializableAppearanceObject(); - DevExpress.Utils.SerializableAppearanceObject serializableAppearanceObject12 = new DevExpress.Utils.SerializableAppearanceObject(); + DevExpress.XtraEditors.Controls.EditorButtonImageOptions editorButtonImageOptions1 = new DevExpress.XtraEditors.Controls.EditorButtonImageOptions(); + DevExpress.Utils.SerializableAppearanceObject serializableAppearanceObject1 = new DevExpress.Utils.SerializableAppearanceObject(); + DevExpress.Utils.SerializableAppearanceObject serializableAppearanceObject2 = new DevExpress.Utils.SerializableAppearanceObject(); + DevExpress.Utils.SerializableAppearanceObject serializableAppearanceObject3 = new DevExpress.Utils.SerializableAppearanceObject(); + DevExpress.Utils.SerializableAppearanceObject serializableAppearanceObject4 = new DevExpress.Utils.SerializableAppearanceObject(); + DevExpress.XtraEditors.Controls.EditorButtonImageOptions editorButtonImageOptions2 = new DevExpress.XtraEditors.Controls.EditorButtonImageOptions(); + DevExpress.Utils.SerializableAppearanceObject serializableAppearanceObject5 = new DevExpress.Utils.SerializableAppearanceObject(); + DevExpress.Utils.SerializableAppearanceObject serializableAppearanceObject6 = new DevExpress.Utils.SerializableAppearanceObject(); + DevExpress.Utils.SerializableAppearanceObject serializableAppearanceObject7 = new DevExpress.Utils.SerializableAppearanceObject(); + DevExpress.Utils.SerializableAppearanceObject serializableAppearanceObject8 = new DevExpress.Utils.SerializableAppearanceObject(); this.gvMx1pid = new DevExpress.XtraGrid.Columns.GridColumn(); this.gvMx1facLevel = new DevExpress.XtraGrid.Columns.GridColumn(); this.rptJSSP = new DevExpress.XtraEditors.Repository.RepositoryItemComboBox(); @@ -99,8 +104,19 @@ this.pageBar1 = new UserControls.Data.UcPageBar(); this.xtraTabPage2 = new DevExpress.XtraTab.XtraTabPage(); this.tabMx = new DevExpress.XtraTab.XtraTabControl(); - this.panel1 = new System.Windows.Forms.Panel(); + this.xtraTabPage3 = new DevExpress.XtraTab.XtraTabPage(); + this.gridControl2 = new DevExpress.XtraGrid.GridControl(); + this.gridView2 = new DevExpress.XtraGrid.Views.Grid.GridView(); + this.gridColumn11 = new DevExpress.XtraGrid.Columns.GridColumn(); + this.gridColumn12 = new DevExpress.XtraGrid.Columns.GridColumn(); + this.gridColumn13 = new DevExpress.XtraGrid.Columns.GridColumn(); + this.gridColumn14 = new DevExpress.XtraGrid.Columns.GridColumn(); + this.gridColumn15 = new DevExpress.XtraGrid.Columns.GridColumn(); + this.gridColumn6 = new DevExpress.XtraGrid.Columns.GridColumn(); + this.repositoryItemButtonEdit3 = new DevExpress.XtraEditors.Repository.RepositoryItemButtonEdit(); + this.panelControl1 = new DevExpress.XtraEditors.PanelControl(); this.btnSelect = new DevExpress.XtraEditors.SimpleButton(); + this.panel1 = new System.Windows.Forms.Panel(); this.txt_itemModel = new DevExpress.XtraEditors.MemoEdit(); this.txt_ItemId = new Gs.DevApp.UserControl.UcLookItems(); this.txt_isenabled = new DevExpress.XtraEditors.CheckEdit(); @@ -137,6 +153,12 @@ this.xtraTabPage2.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.tabMx)).BeginInit(); this.tabMx.SuspendLayout(); + this.xtraTabPage3.SuspendLayout(); + ((System.ComponentModel.ISupportInitialize)(this.gridControl2)).BeginInit(); + ((System.ComponentModel.ISupportInitialize)(this.gridView2)).BeginInit(); + ((System.ComponentModel.ISupportInitialize)(this.repositoryItemButtonEdit3)).BeginInit(); + ((System.ComponentModel.ISupportInitialize)(this.panelControl1)).BeginInit(); + this.panelControl1.SuspendLayout(); this.panel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.txt_itemModel.Properties)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.txt_isenabled.Properties)).BeginInit(); @@ -350,7 +372,7 @@ this.tabMxPage1.Controls.Add(this.gcMx1); this.tabMxPage1.Name = "tabMxPage1"; this.tabMxPage1.Size = new System.Drawing.Size(1125, 371); - this.tabMxPage1.Text = "鏄庣粏"; + this.tabMxPage1.Text = "妫�楠岄」鐩槑缁�"; // // gcMx1 // @@ -429,10 +451,10 @@ // repositoryItemButtonEdit1 // this.repositoryItemButtonEdit1.AutoHeight = false; - editorButtonImageOptions3.Image = global::Gs.DevApp.Properties.Resources.removegroupfooter_16x16; - editorButtonImageOptions3.ImageToTextAlignment = DevExpress.XtraEditors.ImageAlignToText.LeftCenter; + editorButtonImageOptions1.Image = global::Gs.DevApp.Properties.Resources.removegroupfooter_16x16; + editorButtonImageOptions1.ImageToTextAlignment = DevExpress.XtraEditors.ImageAlignToText.LeftCenter; this.repositoryItemButtonEdit1.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] { - new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Glyph, "绉婚櫎", -1, true, true, false, editorButtonImageOptions3, new DevExpress.Utils.KeyShortcut(System.Windows.Forms.Keys.None), serializableAppearanceObject9, serializableAppearanceObject10, serializableAppearanceObject11, serializableAppearanceObject12, "", null, null, DevExpress.Utils.ToolTipAnchor.Default)}); + new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Glyph, "绉婚櫎", -1, true, true, false, editorButtonImageOptions1, new DevExpress.Utils.KeyShortcut(System.Windows.Forms.Keys.None), serializableAppearanceObject1, serializableAppearanceObject2, serializableAppearanceObject3, serializableAppearanceObject4, "", null, null, DevExpress.Utils.ToolTipAnchor.Default)}); this.repositoryItemButtonEdit1.Name = "repositoryItemButtonEdit1"; this.repositoryItemButtonEdit1.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.HideTextEditor; this.repositoryItemButtonEdit1.ButtonClick += new DevExpress.XtraEditors.Controls.ButtonPressedEventHandler(this.repositoryItemButtonEdit1_ButtonClick); @@ -919,12 +941,149 @@ this.tabMx.Size = new System.Drawing.Size(1127, 403); this.tabMx.TabIndex = 2; this.tabMx.TabPages.AddRange(new DevExpress.XtraTab.XtraTabPage[] { - this.tabMxPage1}); + this.tabMxPage1, + this.xtraTabPage3}); + // + // xtraTabPage3 + // + this.xtraTabPage3.Controls.Add(this.gridControl2); + this.xtraTabPage3.Controls.Add(this.panelControl1); + this.xtraTabPage3.Name = "xtraTabPage3"; + this.xtraTabPage3.Size = new System.Drawing.Size(1125, 371); + this.xtraTabPage3.Text = "澶嶅埗鍒板叾瀹冪墿鏂�"; + // + // gridControl2 + // + this.gridControl2.Dock = System.Windows.Forms.DockStyle.Fill; + this.gridControl2.Location = new System.Drawing.Point(0, 43); + this.gridControl2.MainView = this.gridView2; + this.gridControl2.Name = "gridControl2"; + this.gridControl2.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] { + this.repositoryItemButtonEdit3}); + this.gridControl2.Size = new System.Drawing.Size(1125, 328); + this.gridControl2.TabIndex = 1; + this.gridControl2.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] { + this.gridView2}); + // + // gridView2 + // + this.gridView2.Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] { + this.gridColumn11, + this.gridColumn12, + this.gridColumn13, + this.gridColumn14, + this.gridColumn15, + this.gridColumn6}); + this.gridView2.GridControl = this.gridControl2; + this.gridView2.Name = "gridView2"; + this.gridView2.OptionsBehavior.AllowAddRows = DevExpress.Utils.DefaultBoolean.True; + this.gridView2.OptionsFind.ShowSearchNavButtons = false; + this.gridView2.OptionsView.NewItemRowPosition = DevExpress.XtraGrid.Views.Grid.NewItemRowPosition.Bottom; + this.gridView2.OptionsView.ShowGroupPanel = false; + // + // gridColumn11 + // + this.gridColumn11.AppearanceCell.Font = new System.Drawing.Font("Tahoma", 10F); + this.gridColumn11.AppearanceCell.Options.UseFont = true; + this.gridColumn11.Caption = "浣跨敤缁勭粐"; + this.gridColumn11.FieldName = "fSubsidiary"; + this.gridColumn11.MinWidth = 150; + this.gridColumn11.Name = "gridColumn11"; + this.gridColumn11.Tag = "query_a.FCHECK_ITEM"; + this.gridColumn11.Visible = true; + this.gridColumn11.VisibleIndex = 0; + this.gridColumn11.Width = 150; + // + // gridColumn12 + // + this.gridColumn12.Caption = "鐗╂枡ID"; + this.gridColumn12.FieldName = "id"; + this.gridColumn12.MinWidth = 150; + this.gridColumn12.Name = "gridColumn12"; + this.gridColumn12.Visible = true; + this.gridColumn12.VisibleIndex = 1; + this.gridColumn12.Width = 150; + // + // gridColumn13 + // + this.gridColumn13.AppearanceCell.Font = new System.Drawing.Font("Tahoma", 10F); + this.gridColumn13.AppearanceCell.Options.UseFont = true; + this.gridColumn13.Caption = "鐗╂枡缂栧彿"; + this.gridColumn13.FieldName = "itemNo"; + this.gridColumn13.MinWidth = 150; + this.gridColumn13.Name = "gridColumn13"; + this.gridColumn13.Tag = "query_a.MEMO"; + this.gridColumn13.Visible = true; + this.gridColumn13.VisibleIndex = 2; + this.gridColumn13.Width = 150; + // + // gridColumn14 + // + this.gridColumn14.AppearanceCell.Font = new System.Drawing.Font("Tahoma", 10F); + this.gridColumn14.AppearanceCell.Options.UseFont = true; + this.gridColumn14.Caption = "鐗╂枡鍚嶇О"; + this.gridColumn14.FieldName = "itemName"; + this.gridColumn14.MinWidth = 150; + this.gridColumn14.Name = "gridColumn14"; + this.gridColumn14.Tag = "query_a.FCHECK_TOOL"; + this.gridColumn14.Visible = true; + this.gridColumn14.VisibleIndex = 3; + this.gridColumn14.Width = 150; + // + // gridColumn15 + // + this.gridColumn15.AppearanceCell.Font = new System.Drawing.Font("Tahoma", 10F); + this.gridColumn15.AppearanceCell.Options.UseFont = true; + this.gridColumn15.Caption = "瑙勬牸鍨嬪彿"; + this.gridColumn15.FieldName = "itemModel"; + this.gridColumn15.MinWidth = 150; + this.gridColumn15.Name = "gridColumn15"; + this.gridColumn15.Tag = "query_a.SAMPLE_SIZE_NO"; + this.gridColumn15.Visible = true; + this.gridColumn15.VisibleIndex = 4; + this.gridColumn15.Width = 150; + // + // gridColumn6 + // + this.gridColumn6.Caption = "绉诲嚭"; + this.gridColumn6.ColumnEdit = this.repositoryItemButtonEdit3; + this.gridColumn6.MinWidth = 25; + this.gridColumn6.Name = "gridColumn6"; + this.gridColumn6.Visible = true; + this.gridColumn6.VisibleIndex = 5; + this.gridColumn6.Width = 94; + // + // repositoryItemButtonEdit3 + // + this.repositoryItemButtonEdit3.AutoHeight = false; + editorButtonImageOptions2.Image = global::Gs.DevApp.Properties.Resources.removegroupfooter_16x16; + editorButtonImageOptions2.ImageToTextAlignment = DevExpress.XtraEditors.ImageAlignToText.LeftCenter; + this.repositoryItemButtonEdit3.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] { + new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Glyph, "绉诲嚭", -1, true, true, false, editorButtonImageOptions2, new DevExpress.Utils.KeyShortcut(System.Windows.Forms.Keys.None), serializableAppearanceObject5, serializableAppearanceObject6, serializableAppearanceObject7, serializableAppearanceObject8, "", null, null, DevExpress.Utils.ToolTipAnchor.Default)}); + this.repositoryItemButtonEdit3.Name = "repositoryItemButtonEdit3"; + this.repositoryItemButtonEdit3.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.HideTextEditor; + // + // panelControl1 + // + this.panelControl1.Controls.Add(this.btnSelect); + this.panelControl1.Dock = System.Windows.Forms.DockStyle.Top; + this.panelControl1.Location = new System.Drawing.Point(0, 0); + this.panelControl1.Name = "panelControl1"; + this.panelControl1.Size = new System.Drawing.Size(1125, 43); + this.panelControl1.TabIndex = 0; + // + // btnSelect + // + this.btnSelect.ImageOptions.Image = global::Gs.DevApp.Properties.Resources.lookup_reference_16x16; + this.btnSelect.Location = new System.Drawing.Point(10, 5); + this.btnSelect.Name = "btnSelect"; + this.btnSelect.Size = new System.Drawing.Size(101, 29); + this.btnSelect.TabIndex = 449; + this.btnSelect.Text = "閫夋嫨鐗╂枡"; // // panel1 // this.panel1.BackColor = System.Drawing.Color.White; - this.panel1.Controls.Add(this.btnSelect); this.panel1.Controls.Add(this.txt_itemModel); this.panel1.Controls.Add(this.txt_ItemId); this.panel1.Controls.Add(this.txt_isenabled); @@ -960,15 +1119,6 @@ this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(1127, 167); this.panel1.TabIndex = 1; - // - // btnSelect - // - this.btnSelect.ImageOptions.Image = global::Gs.DevApp.Properties.Resources.lookup_reference_16x16; - this.btnSelect.Location = new System.Drawing.Point(612, 131); - this.btnSelect.Name = "btnSelect"; - this.btnSelect.Size = new System.Drawing.Size(85, 29); - this.btnSelect.TabIndex = 449; - this.btnSelect.Text = "鍘诲鍒�"; // // txt_itemModel // @@ -1118,6 +1268,12 @@ this.xtraTabPage2.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.tabMx)).EndInit(); this.tabMx.ResumeLayout(false); + this.xtraTabPage3.ResumeLayout(false); + ((System.ComponentModel.ISupportInitialize)(this.gridControl2)).EndInit(); + ((System.ComponentModel.ISupportInitialize)(this.gridView2)).EndInit(); + ((System.ComponentModel.ISupportInitialize)(this.repositoryItemButtonEdit3)).EndInit(); + ((System.ComponentModel.ISupportInitialize)(this.panelControl1)).EndInit(); + this.panelControl1.ResumeLayout(false); this.panel1.ResumeLayout(false); this.panel1.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.txt_itemModel.Properties)).EndInit(); @@ -1223,5 +1379,16 @@ private DevExpress.XtraGrid.Columns.GridColumn gvMxDel; private DevExpress.XtraEditors.Repository.RepositoryItemButtonEdit repositoryItemButtonEdit1; private System.Windows.Forms.PictureBox picCheckBox; + private DevExpress.XtraTab.XtraTabPage xtraTabPage3; + private DevExpress.XtraEditors.PanelControl panelControl1; + private DevExpress.XtraGrid.GridControl gridControl2; + private DevExpress.XtraGrid.Views.Grid.GridView gridView2; + private DevExpress.XtraGrid.Columns.GridColumn gridColumn11; + private DevExpress.XtraGrid.Columns.GridColumn gridColumn12; + private DevExpress.XtraGrid.Columns.GridColumn gridColumn13; + private DevExpress.XtraGrid.Columns.GridColumn gridColumn14; + private DevExpress.XtraGrid.Columns.GridColumn gridColumn15; + private DevExpress.XtraGrid.Columns.GridColumn gridColumn6; + private DevExpress.XtraEditors.Repository.RepositoryItemButtonEdit repositoryItemButtonEdit3; } } \ No newline at end of file diff --git a/DevApp/Gs.DevApp/DevFrm/QC/Frm_MesQmCheckitemDt.cs b/DevApp/Gs.DevApp/DevFrm/QC/Frm_MesQmCheckitemDt.cs index 4845ef9..85f4d4c 100644 --- a/DevApp/Gs.DevApp/DevFrm/QC/Frm_MesQmCheckitemDt.cs +++ b/DevApp/Gs.DevApp/DevFrm/QC/Frm_MesQmCheckitemDt.cs @@ -1,6 +1,7 @@ using System; using System.Collections.Generic; using System.Data; +using System.Reflection; using System.Threading.Tasks; using System.Windows.Forms; using DevExpress.XtraEditors; @@ -39,10 +40,10 @@ //鍒濆鍖栫墿鏂欓�夋嫨鍜屽悇绉嶄笅鎷� _setIno(); } - private void GridView1_ColumnFilterChanged(object sender, EventArgs e) + private void GridView1_ColumnFilterChanged(object sender, EventArgs e) { _filterList = Gs.DevApp.ToolBox.UtilityHelper.GetDilter(gridView1.Columns); - Task.Delay(100); + Task.Delay(100); getPageList(1); } /// <summary> @@ -333,9 +334,9 @@ /// </summary> /// <param name="curPage">绗嚑椤�</param> /// <param name="pageSize">姣忛〉鍑犳潯</param> - private void getPageList(int curPage) + private void getPageList(int curPage) { - + var _sbSqlWhere = UtilityHelper.GetSearchWhere(_filterList); var pgq = new PageQueryModel(curPage, this.pageBar1.RowsCount, "a.create_date", "asc", "", _sbSqlWhere.ToString()); @@ -372,7 +373,7 @@ { MsgHelper.Warning("鎻愮ず锛�" + ex.Message); } - + } private void getModel(string strGuid, bool isEdit, int tabIdx) @@ -439,53 +440,30 @@ #region 浠ヤ笅涓虹绉嶄笅鎷� - private void getCopyMx(string strGuid) + private DataTable ListToTable<T>(List<T> items) { - if (string.IsNullOrEmpty(strGuid)) + DataTable dataTable = new DataTable(typeof(T).Name); + + // 鑾峰彇鎵�鏈夌殑灞炴�� + PropertyInfo[] Props = typeof(T).GetProperties(BindingFlags.Public | BindingFlags.Instance); + foreach (PropertyInfo prop in Props) { - MsgHelper.Warning("璇峰厛閫夋嫨浣犺澶嶅埗鐨勮锛�"); - return; + // 璁剧疆鍒楃殑鍚嶅瓧鍜屾暟鎹被鍨� + dataTable.Columns.Add(prop.Name, Nullable.GetUnderlyingType(prop.PropertyType) ?? prop.PropertyType); } - var _obj = new + + // 閬嶅巻鎵�鏈夌殑瀵硅薄 + foreach (T item in items) { - guid = strGuid - }; - try - { - var strJson = UtilityHelper.HttpPost("", - _webServiceName + "GetModelIQC", - JsonConvert.SerializeObject(_obj)); - var _rtn = - UtilityHelper.ReturnToDynamic(strJson); - if (_rtn.rtnCode > 0) + var values = new object[Props.Length]; + for (int i = 0; i < Props.Length; i++) { - var dy = _rtn.rtnData; - var _job = JObject.Parse(strJson); - var array = new JArray(); - foreach (var a in _job["rtnData"]["list"]) array.Add(a); - var dt = - JsonConvert.DeserializeObject<DataTable>( - array.ToString()); - if (dt.Rows.Count > 0) - { - gcMx1.BindingContext = new BindingContext(); - gcMx1.DataSource = dt; - gcMx1.ForceInitialize(); - } - else - { - MsgHelper.Warning("鎻愮ず锛氭病鎵惧埌鐩稿簲鐨勬槑缁嗭紝璇烽�夋嫨鍏跺畠璇曡瘯锛�"); - } + // 鎻掑叆灞炴�у�煎埌datatable + values[i] = Props[i].GetValue(item, null); } - else - { - MsgHelper.Warning("鎻愮ず锛�" + _rtn.rtnMsg); - } + dataTable.Rows.Add(values); } - catch (Exception ex) - { - MsgHelper.Warning("鎻愮ず锛�" + ex.Message); - } + return dataTable; } private void _setIno() @@ -500,10 +478,12 @@ var frm = new SelectCheckDt(); frm.UpdateParent += (ss, ee) => { - var lst = new List<string>(); - lst = ee.StringList; - getCopyMx(lst[0]); - + var lst = new List<dynamic>(); + lst = ee.DynamicList; + DataTable table = ListToTable(lst); + gridControl2.BindingContext = new BindingContext(); + gridControl2.DataSource = table; + gridControl2.ForceInitialize(); }; frm.ShowDialog(); }; diff --git a/DevApp/Gs.DevApp/ToolBox/UpdateParentEventArgs.cs b/DevApp/Gs.DevApp/ToolBox/UpdateParentEventArgs.cs index 7ca7160..b133217 100644 --- a/DevApp/Gs.DevApp/ToolBox/UpdateParentEventArgs.cs +++ b/DevApp/Gs.DevApp/ToolBox/UpdateParentEventArgs.cs @@ -12,5 +12,7 @@ public List<FilterEntity> FilterList { get; set; } public List<string> StringList { get; set; } + + public List<dynamic> DynamicList { get; set; } } } \ No newline at end of file diff --git a/DevApp/Gs.DevApp/UserControl/SelectCheckDt.Designer.cs b/DevApp/Gs.DevApp/UserControl/SelectCheckDt.Designer.cs index 4f0360b..2ce22ea 100644 --- a/DevApp/Gs.DevApp/UserControl/SelectCheckDt.Designer.cs +++ b/DevApp/Gs.DevApp/UserControl/SelectCheckDt.Designer.cs @@ -31,16 +31,17 @@ this.gcMain = new DevExpress.XtraGrid.GridControl(); this.gridView1 = new DevExpress.XtraGrid.Views.Grid.GridView(); this.gv_guid = new DevExpress.XtraGrid.Columns.GridColumn(); - this.鏄惁鍙敤 = new DevExpress.XtraGrid.Columns.GridColumn(); + this.gv_chk = new DevExpress.XtraGrid.Columns.GridColumn(); + this.gridColumn1 = new DevExpress.XtraGrid.Columns.GridColumn(); + this.gv2 = new DevExpress.XtraGrid.Columns.GridColumn(); this.gv_salesOrderId = new DevExpress.XtraGrid.Columns.GridColumn(); this.gv_orderLineId = new DevExpress.XtraGrid.Columns.GridColumn(); this.gv_itemId = new DevExpress.XtraGrid.Columns.GridColumn(); - this.gv_purchaseUnit = new DevExpress.XtraGrid.Columns.GridColumn(); - this.gv_purchaseQty = new DevExpress.XtraGrid.Columns.GridColumn(); this.xtraTabControl1 = new DevExpress.XtraTab.XtraTabControl(); this.xtraTabPage1 = new DevExpress.XtraTab.XtraTabPage(); this.panelControl1 = new DevExpress.XtraEditors.PanelControl(); this.pageBar1 = new UserControls.Data.UcPageBar(); + this.btnIn = new DevExpress.XtraEditors.SimpleButton(); ((System.ComponentModel.ISupportInitialize)(this.gcMain)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.gridView1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xtraTabControl1)).BeginInit(); @@ -57,7 +58,7 @@ this.gcMain.Location = new System.Drawing.Point(0, 0); this.gcMain.MainView = this.gridView1; this.gcMain.Name = "gcMain"; - this.gcMain.Size = new System.Drawing.Size(941, 607); + this.gcMain.Size = new System.Drawing.Size(1112, 609); this.gcMain.TabIndex = 1; this.gcMain.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] { this.gridView1}); @@ -68,12 +69,12 @@ this.gridView1.Appearance.Row.Options.UseFont = true; this.gridView1.Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] { this.gv_guid, - this.鏄惁鍙敤, + this.gv_chk, + this.gridColumn1, + this.gv2, this.gv_salesOrderId, this.gv_orderLineId, - this.gv_itemId, - this.gv_purchaseUnit, - this.gv_purchaseQty}); + this.gv_itemId}); this.gridView1.GridControl = this.gcMain; this.gridView1.IndicatorWidth = 50; this.gridView1.Name = "gridView1"; @@ -93,89 +94,83 @@ this.gv_guid.Tag = "query_a.guid"; this.gv_guid.Width = 94; // - // 鏄惁鍙敤 + // gv_chk // - this.鏄惁鍙敤.AppearanceCell.Font = new System.Drawing.Font("Tahoma", 10F); - this.鏄惁鍙敤.AppearanceCell.Options.UseFont = true; - this.鏄惁鍙敤.Caption = "閲囪喘鍗曞彿 "; - this.鏄惁鍙敤.FieldName = "isEnabled"; - this.鏄惁鍙敤.MinWidth = 100; - this.鏄惁鍙敤.Name = "鏄惁鍙敤"; - this.鏄惁鍙敤.OptionsColumn.AllowEdit = false; - this.鏄惁鍙敤.Tag = "query_a.BILL_NO"; - this.鏄惁鍙敤.Visible = true; - this.鏄惁鍙敤.VisibleIndex = 0; - this.鏄惁鍙敤.Width = 100; + this.gv_chk.Caption = "閫夋嫨"; + this.gv_chk.FieldName = "gvChk"; + this.gv_chk.MaxWidth = 40; + this.gv_chk.MinWidth = 40; + this.gv_chk.Name = "gv_chk"; + this.gv_chk.Visible = true; + this.gv_chk.VisibleIndex = 0; + this.gv_chk.Width = 40; + // + // gridColumn1 + // + this.gridColumn1.Caption = "浣跨敤缁勭粐"; + this.gridColumn1.FieldName = "fSubsidiary"; + this.gridColumn1.MinWidth = 25; + this.gridColumn1.Name = "gridColumn1"; + this.gridColumn1.Tag = "org.FNumber"; + this.gridColumn1.Visible = true; + this.gridColumn1.VisibleIndex = 1; + this.gridColumn1.Width = 94; + // + // gv2 + // + this.gv2.AppearanceCell.Font = new System.Drawing.Font("Tahoma", 10F); + this.gv2.AppearanceCell.Options.UseFont = true; + this.gv2.Caption = "鐗╂枡ID"; + this.gv2.FieldName = "id"; + this.gv2.MinWidth = 100; + this.gv2.Name = "gv2"; + this.gv2.OptionsColumn.AllowEdit = false; + this.gv2.Tag = "query_a.id"; + this.gv2.Visible = true; + this.gv2.VisibleIndex = 2; + this.gv2.Width = 100; // // gv_salesOrderId // this.gv_salesOrderId.AppearanceCell.Font = new System.Drawing.Font("Tahoma", 10F); this.gv_salesOrderId.AppearanceCell.Options.UseFont = true; - this.gv_salesOrderId.Caption = "瀹℃壒鏍囧織"; - this.gv_salesOrderId.FieldName = "fOneChecked"; + this.gv_salesOrderId.Caption = "鐗╂枡缂栧彿"; + this.gv_salesOrderId.FieldName = "itemNo"; this.gv_salesOrderId.MinWidth = 100; this.gv_salesOrderId.Name = "gv_salesOrderId"; this.gv_salesOrderId.OptionsColumn.AllowEdit = false; - this.gv_salesOrderId.Tag = "query_a.SALES_ORDER_ID"; + this.gv_salesOrderId.Tag = "query_a.itemNo"; this.gv_salesOrderId.Visible = true; - this.gv_salesOrderId.VisibleIndex = 1; + this.gv_salesOrderId.VisibleIndex = 3; this.gv_salesOrderId.Width = 100; // // gv_orderLineId // this.gv_orderLineId.AppearanceCell.Font = new System.Drawing.Font("Tahoma", 10F); this.gv_orderLineId.AppearanceCell.Options.UseFont = true; - this.gv_orderLineId.Caption = "鎵瑰噯鏍囪"; - this.gv_orderLineId.FieldName = "fTwoChecked"; + this.gv_orderLineId.Caption = "鐗╂枡鍚嶇О"; + this.gv_orderLineId.FieldName = "itemName"; this.gv_orderLineId.MinWidth = 100; this.gv_orderLineId.Name = "gv_orderLineId"; this.gv_orderLineId.OptionsColumn.AllowEdit = false; - this.gv_orderLineId.Tag = "query_a.ORDER_LINE_ID"; + this.gv_orderLineId.Tag = "query_a.itemName"; this.gv_orderLineId.Visible = true; - this.gv_orderLineId.VisibleIndex = 2; + this.gv_orderLineId.VisibleIndex = 4; this.gv_orderLineId.Width = 100; // // gv_itemId // this.gv_itemId.AppearanceCell.Font = new System.Drawing.Font("Tahoma", 10F); this.gv_itemId.AppearanceCell.Options.UseFont = true; - this.gv_itemId.Caption = "鐗╂枡缂栫爜 "; - this.gv_itemId.FieldName = "itemNo"; + this.gv_itemId.Caption = "鐗╂枡瑙勬牸"; + this.gv_itemId.FieldName = "itemModel"; this.gv_itemId.MinWidth = 100; this.gv_itemId.Name = "gv_itemId"; this.gv_itemId.OptionsColumn.AllowEdit = false; - this.gv_itemId.Tag = "query_a.ITEM_ID"; + this.gv_itemId.Tag = "query_a.itemModel"; this.gv_itemId.Visible = true; - this.gv_itemId.VisibleIndex = 3; + this.gv_itemId.VisibleIndex = 5; this.gv_itemId.Width = 100; - // - // gv_purchaseUnit - // - this.gv_purchaseUnit.AppearanceCell.Font = new System.Drawing.Font("Tahoma", 10F); - this.gv_purchaseUnit.AppearanceCell.Options.UseFont = true; - this.gv_purchaseUnit.Caption = "鐗╂枡鍚嶇О"; - this.gv_purchaseUnit.FieldName = "itemName"; - this.gv_purchaseUnit.MinWidth = 100; - this.gv_purchaseUnit.Name = "gv_purchaseUnit"; - this.gv_purchaseUnit.OptionsColumn.AllowEdit = false; - this.gv_purchaseUnit.Tag = "query_a.PURCHASE_UNIT"; - this.gv_purchaseUnit.Visible = true; - this.gv_purchaseUnit.VisibleIndex = 4; - this.gv_purchaseUnit.Width = 100; - // - // gv_purchaseQty - // - this.gv_purchaseQty.AppearanceCell.Font = new System.Drawing.Font("Tahoma", 10F); - this.gv_purchaseQty.AppearanceCell.Options.UseFont = true; - this.gv_purchaseQty.Caption = "鐗╂枡瑙勬牸"; - this.gv_purchaseQty.FieldName = "itemModel"; - this.gv_purchaseQty.MinWidth = 100; - this.gv_purchaseQty.Name = "gv_purchaseQty"; - this.gv_purchaseQty.OptionsColumn.AllowEdit = false; - this.gv_purchaseQty.Tag = "query_a.PURCHASE_QTY"; - this.gv_purchaseQty.Visible = true; - this.gv_purchaseQty.VisibleIndex = 5; - this.gv_purchaseQty.Width = 100; // // xtraTabControl1 // @@ -183,7 +178,7 @@ this.xtraTabControl1.Location = new System.Drawing.Point(0, 0); this.xtraTabControl1.Name = "xtraTabControl1"; this.xtraTabControl1.SelectedTabPage = this.xtraTabPage1; - this.xtraTabControl1.Size = new System.Drawing.Size(943, 682); + this.xtraTabControl1.Size = new System.Drawing.Size(1114, 682); this.xtraTabControl1.TabIndex = 3; this.xtraTabControl1.TabPages.AddRange(new DevExpress.XtraTab.XtraTabPage[] { this.xtraTabPage1}); @@ -193,35 +188,46 @@ this.xtraTabPage1.Controls.Add(this.gcMain); this.xtraTabPage1.Controls.Add(this.panelControl1); this.xtraTabPage1.Name = "xtraTabPage1"; - this.xtraTabPage1.Size = new System.Drawing.Size(941, 650); + this.xtraTabPage1.Size = new System.Drawing.Size(1112, 650); this.xtraTabPage1.Text = "璇烽�夋嫨闇�瑕佸鍏ョ殑鏁版嵁"; // // panelControl1 // + this.panelControl1.Controls.Add(this.btnIn); this.panelControl1.Controls.Add(this.pageBar1); this.panelControl1.Dock = System.Windows.Forms.DockStyle.Bottom; - this.panelControl1.Location = new System.Drawing.Point(0, 607); + this.panelControl1.Location = new System.Drawing.Point(0, 609); this.panelControl1.Name = "panelControl1"; - this.panelControl1.Size = new System.Drawing.Size(941, 43); + this.panelControl1.Size = new System.Drawing.Size(1112, 41); this.panelControl1.TabIndex = 4; // // pageBar1 // this.pageBar1.CurrentPage = 1; this.pageBar1.Dock = System.Windows.Forms.DockStyle.Right; - this.pageBar1.Location = new System.Drawing.Point(-45, 2); + this.pageBar1.Location = new System.Drawing.Point(126, 2); this.pageBar1.Margin = new System.Windows.Forms.Padding(3, 5, 3, 5); this.pageBar1.Name = "pageBar1"; this.pageBar1.RecordCount = 0; - this.pageBar1.Size = new System.Drawing.Size(984, 39); + this.pageBar1.Size = new System.Drawing.Size(984, 37); this.pageBar1.TabIndex = 3; this.pageBar1.TotalPages = 0; + // + // btnIn + // + this.btnIn.Dock = System.Windows.Forms.DockStyle.Left; + this.btnIn.ImageOptions.Image = global::Gs.DevApp.Properties.Resources.checkbuttons_16x161; + this.btnIn.Location = new System.Drawing.Point(2, 2); + this.btnIn.Name = "btnIn"; + this.btnIn.Size = new System.Drawing.Size(94, 37); + this.btnIn.TabIndex = 6; + this.btnIn.Text = "纭畾瀵煎叆"; // // SelectCheckDt // this.AutoScaleDimensions = new System.Drawing.SizeF(8F, 18F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; - this.ClientSize = new System.Drawing.Size(943, 682); + this.ClientSize = new System.Drawing.Size(1114, 682); this.Controls.Add(this.xtraTabControl1); this.IconOptions.Image = global::Gs.DevApp.Properties.Resources.logo_png_black; this.MaximizeBox = false; @@ -246,13 +252,14 @@ private DevExpress.XtraTab.XtraTabControl xtraTabControl1; private DevExpress.XtraTab.XtraTabPage xtraTabPage1; private UserControls.Data.UcPageBar pageBar1; - private DevExpress.XtraGrid.Columns.GridColumn gv_purchaseQty; - private DevExpress.XtraGrid.Columns.GridColumn gv_purchaseUnit; private DevExpress.XtraGrid.Columns.GridColumn gv_itemId; private DevExpress.XtraGrid.Columns.GridColumn gv_orderLineId; private DevExpress.XtraGrid.Columns.GridColumn gv_salesOrderId; - private DevExpress.XtraGrid.Columns.GridColumn 鏄惁鍙敤; + private DevExpress.XtraGrid.Columns.GridColumn gv2; private DevExpress.XtraGrid.Columns.GridColumn gv_guid; private DevExpress.XtraEditors.PanelControl panelControl1; + private DevExpress.XtraGrid.Columns.GridColumn gridColumn1; + private DevExpress.XtraGrid.Columns.GridColumn gv_chk; + private DevExpress.XtraEditors.SimpleButton btnIn; } } \ No newline at end of file diff --git a/DevApp/Gs.DevApp/UserControl/SelectCheckDt.cs b/DevApp/Gs.DevApp/UserControl/SelectCheckDt.cs index cc7f795..d635452 100644 --- a/DevApp/Gs.DevApp/UserControl/SelectCheckDt.cs +++ b/DevApp/Gs.DevApp/UserControl/SelectCheckDt.cs @@ -1,8 +1,8 @@ 锘縰sing System; using System.Collections.Generic; -using System.Text; +using System.Data; +using System.Threading.Tasks; using System.Windows.Forms; -using DevExpress.XtraEditors; using Gs.DevApp.Entity; using Gs.DevApp.ToolBox; using Newtonsoft.Json; @@ -11,42 +11,43 @@ { public partial class SelectCheckDt : DevExpress.XtraEditors.XtraForm { - private readonly List<FilterEntity> _filterList = - new List<FilterEntity>(); - + private List<FilterEntity> _filterList = new List<FilterEntity>(); private readonly string _webServiceName = "MesQmCheckitemManager/"; public SelectCheckDt() { InitializeComponent(); + getPageList(1); pageBar1.PagerEvent += PageBar1_PagerEvent; - gcMain.MouseDoubleClick += GcMain_MouseDoubleClick; - getPageList(1, UtilityHelper.GetPageSize()); - gridView1.IndicatorWidth = 50; - gridView1.CustomDrawRowIndicator += (s, e) => + Gs.DevApp.ToolBox.UtilityHelper.SetGridSear(gridView1); + btnIn.Click += (s, e) => { - if (e.Info.IsRowIndicator && e.RowHandle >= 0) - e.Info.DisplayText = (e.RowHandle + 1).ToString(); + var list = new List<dynamic>(); + for (var i = 0; i < gridView1.DataRowCount; i++) + { + var checkBox = gridView1.GetRowCellDisplayText(i, "gvChk"); + if (checkBox == "Checked") + { + list.Add(new + { + guid = gridView1.GetRowCellValue(i, "guid").ToString(), + fSubsidiary = gridView1.GetRowCellValue(i, "fSubsidiary").ToString(), + id = gridView1.GetRowCellValue(i, "id").ToString(), + itemNo = gridView1.GetRowCellValue(i, "itemNo").ToString(), + itemName = gridView1.GetRowCellValue(i, "itemName").ToString(), + itemModel = gridView1.GetRowCellValue(i, "itemModel").ToString(), + }); + } + } + UpdateParent?.Invoke(this, new UpdateParentEventArgs { DynamicList = list }); + Close(); }; - } - /// <summary> - /// 鍙屽嚮浜嬩欢 - /// </summary> - /// <param name="sender"></param> - /// <param name="e"></param> - private void GcMain_MouseDoubleClick(object sender, MouseEventArgs e) + private void GridView1_ColumnFilterChanged(object sender, EventArgs e) { - var rowGuid = - UtilityHelper.GetCurrentDoubleRow(gridView1, e, "guid"); - if (string.IsNullOrEmpty(rowGuid)) - return; - var list = new List<string>(); - list.Add(rowGuid); - UpdateParent?.Invoke(this, - new UpdateParentEventArgs { StringList = list }); - Close(); - + _filterList = Gs.DevApp.ToolBox.UtilityHelper.GetDilter(gridView1.Columns); + Task.Delay(100); + getPageList(1); } /// <summary> @@ -61,36 +62,44 @@ /// <param name="pageSize"></param> private void PageBar1_PagerEvent(int curPage, int pageSize) { - getPageList(curPage, pageSize); + getPageList(curPage); } /// <summary> /// </summary> /// <param name="curPage">绗嚑椤�</param> /// <param name="pageSize">姣忛〉鍑犳潯</param> - private void getPageList(int curPage, int pageSize) + private void getPageList(int curPage) { - var _sbSqlWhere = new StringBuilder(); - foreach (var itm in _filterList) - _sbSqlWhere.Append(" and " + itm.fileId + itm.fileOper + "'" + - itm.fileValue + "'"); - var pgq = new PageQueryModel(curPage, pageSize, "create_date", "asc", + var _sbSqlWhere = UtilityHelper.GetSearchWhere(_filterList); + var pgq = new PageQueryModel(curPage, this.pageBar1.RowsCount, "item_no", "asc", "", _sbSqlWhere.ToString()); var json = JsonConvert.SerializeObject(pgq); try { - var strReturn = UtilityHelper.HttpPost("", - _webServiceName + "GetListPage", json); + var strReturn = UtilityHelper.HttpPost("", "MesItemsManager/GetListSelect", json); var dd = UtilityHelper.ReturnToTablePage(strReturn); - var dt = dd.rtnData.list; - gcMain.BindingContext = new BindingContext(); - gcMain.DataSource = dt; - gcMain.ForceInitialize(); - var dddd = dd.rtnData.pages; //鎬婚〉 - pageBar1.TotalPages = dddd; - pageBar1.RecordCount = dd.rtnData.total; //璁板綍鎬绘暟 - pageBar1.CurrentPage = curPage; //褰撳墠椤� - pageBar1.setTxt(); + if (dd.rtnCode > 0) + { + DataTable dt = dd.rtnData.list; + gcMain.BindingContext = new BindingContext(); + gridView1.ColumnFilterChanged -= GridView1_ColumnFilterChanged; + if (dt.Rows.Count > 0) + { + gcMain.DataSource = dt; + gcMain.ForceInitialize(); + } + else + UtilityHelper.SetDefaultTable(gcMain, gridView1); + gridView1.ColumnFilterChanged += GridView1_ColumnFilterChanged; + pageBar1.TotalPages = dd.rtnData.pages;//鎬婚〉 + pageBar1.CurrentPage = curPage;//褰撳墠椤� + pageBar1.RecordCount = dd.rtnData.total;//鎬昏褰曟暟 + } + else + { + ToolBox.MsgHelper.ShowError("鎻愮ず锛�" + dd.rtnMsg); + } } catch (Exception ex) { -- Gitblit v1.9.3