From aef15a6e8acc366ff60e428a347d7f7fe8f9cadc Mon Sep 17 00:00:00 2001 From: lu <99954486@qq.com> Date: 星期六, 07 六月 2025 11:32:03 +0800 Subject: [PATCH] 报表 --- DevApp/Gs.DevApp/DevFrm/Rpt/Ckcgmx.cs | 136 +++++++++++ DevApp/Gs.DevApp/Gs.DevApp.csproj | 9 DevApp/Gs.DevApp/DevFrm/Rpt/Ckcgmx.resx | 120 ++++++++++ DevApp/Gs.DevApp/DevFrm/Rpt/Ckcgmx.Designer.cs | 411 ++++++++++++++++++++++++++++++++++ 4 files changed, 676 insertions(+), 0 deletions(-) diff --git a/DevApp/Gs.DevApp/DevFrm/Rpt/Ckcgmx.Designer.cs b/DevApp/Gs.DevApp/DevFrm/Rpt/Ckcgmx.Designer.cs new file mode 100644 index 0000000..aed2178 --- /dev/null +++ b/DevApp/Gs.DevApp/DevFrm/Rpt/Ckcgmx.Designer.cs @@ -0,0 +1,411 @@ +锘縩amespace Gs.DevApp.DevFrm.Rpt +{ + partial class Ckcgmx + { + /// <summary> + /// Required designer variable. + /// </summary> + private System.ComponentModel.IContainer components = null; + + /// <summary> + /// Clean up any resources being used. + /// </summary> + /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param> + protected override void Dispose(bool disposing) + { + if (disposing && (components != null)) + { + components.Dispose(); + } + base.Dispose(disposing); + } + + #region Windows Form Designer generated code + + /// <summary> + /// Required method for Designer support - do not modify + /// the contents of this method with the code editor. + /// </summary> + private void InitializeComponent() + { + this.toolBarMenu1 = new Gs.DevApp.UserControl.UcToolBarMenu(); + this.xtraTabControl1 = new DevExpress.XtraTab.XtraTabControl(); + this.xtraTabPage1 = new DevExpress.XtraTab.XtraTabPage(); + this.split1 = new DevExpress.XtraEditors.SplitContainerControl(); + this.gcMain1 = new DevExpress.XtraGrid.GridControl(); + this.gridView1 = new DevExpress.XtraGrid.Views.Grid.GridView(); + this.gv_guid = new DevExpress.XtraGrid.Columns.GridColumn(); + this.gv_itemId = new DevExpress.XtraGrid.Columns.GridColumn(); + this.gridColumn3 = new DevExpress.XtraGrid.Columns.GridColumn(); + this.gridColumn2 = new DevExpress.XtraGrid.Columns.GridColumn(); + this.gridColumn4 = new DevExpress.XtraGrid.Columns.GridColumn(); + this.gv_itemBarcode = new DevExpress.XtraGrid.Columns.GridColumn(); + this.gv_quantity = new DevExpress.XtraGrid.Columns.GridColumn(); + this.gv_depotId = new DevExpress.XtraGrid.Columns.GridColumn(); + this.gridColumn6 = new DevExpress.XtraGrid.Columns.GridColumn(); + this.gridColumn1 = new DevExpress.XtraGrid.Columns.GridColumn(); + this.gv_depotSectionsCode = new DevExpress.XtraGrid.Columns.GridColumn(); + this.gv_ownerType = new DevExpress.XtraGrid.Columns.GridColumn(); + this.gv_ownerId = new DevExpress.XtraGrid.Columns.GridColumn(); + this.gridColumn5 = new DevExpress.XtraGrid.Columns.GridColumn(); + this.gv_indepUserCode = new DevExpress.XtraGrid.Columns.GridColumn(); + this.gv_indepDate = new DevExpress.XtraGrid.Columns.GridColumn(); + this.pageBar1 = new UserControls.Data.UcPageBar(); + ((System.ComponentModel.ISupportInitialize)(this.xtraTabControl1)).BeginInit(); + this.xtraTabControl1.SuspendLayout(); + this.xtraTabPage1.SuspendLayout(); + ((System.ComponentModel.ISupportInitialize)(this.split1)).BeginInit(); + ((System.ComponentModel.ISupportInitialize)(this.split1.Panel1)).BeginInit(); + this.split1.Panel1.SuspendLayout(); + ((System.ComponentModel.ISupportInitialize)(this.split1.Panel2)).BeginInit(); + this.split1.SuspendLayout(); + ((System.ComponentModel.ISupportInitialize)(this.gcMain1)).BeginInit(); + ((System.ComponentModel.ISupportInitialize)(this.gridView1)).BeginInit(); + this.SuspendLayout(); + // + // toolBarMenu1 + // + this.toolBarMenu1.chkParameter = null; + this.toolBarMenu1.currentAction = null; + this.toolBarMenu1.defaultActions = "鏌ヨ"; + this.toolBarMenu1.Dock = System.Windows.Forms.DockStyle.Top; + this.toolBarMenu1.guidKey = null; + this.toolBarMenu1.isSetBtn = false; + this.toolBarMenu1.Location = new System.Drawing.Point(0, 0); + this.toolBarMenu1.Name = "toolBarMenu1"; + this.toolBarMenu1.rptParameter = null; + this.toolBarMenu1.Size = new System.Drawing.Size(1128, 80); + this.toolBarMenu1.TabIndex = 0; + this.toolBarMenu1.xlsInService = null; + this.toolBarMenu1.xlsOutParameter = null; + // + // xtraTabControl1 + // + this.xtraTabControl1.Dock = System.Windows.Forms.DockStyle.Fill; + this.xtraTabControl1.Location = new System.Drawing.Point(0, 80); + this.xtraTabControl1.Name = "xtraTabControl1"; + this.xtraTabControl1.SelectedTabPage = this.xtraTabPage1; + this.xtraTabControl1.Size = new System.Drawing.Size(1128, 602); + this.xtraTabControl1.TabIndex = 3; + this.xtraTabControl1.TabPages.AddRange(new DevExpress.XtraTab.XtraTabPage[] { + this.xtraTabPage1}); + // + // xtraTabPage1 + // + this.xtraTabPage1.Controls.Add(this.split1); + this.xtraTabPage1.Name = "xtraTabPage1"; + this.xtraTabPage1.Size = new System.Drawing.Size(1126, 570); + this.xtraTabPage1.Text = "鏁版嵁鍒楄〃"; + // + // split1 + // + this.split1.Dock = System.Windows.Forms.DockStyle.Fill; + this.split1.FixedPanel = DevExpress.XtraEditors.SplitFixedPanel.Panel2; + this.split1.Horizontal = false; + this.split1.Location = new System.Drawing.Point(0, 0); + this.split1.Name = "split1"; + // + // split1.Panel1 + // + this.split1.Panel1.Controls.Add(this.gcMain1); + this.split1.Panel1.Controls.Add(this.pageBar1); + this.split1.Panel1.Text = "Panel1"; + // + // split1.Panel2 + // + this.split1.Panel2.Text = "Panel2"; + this.split1.ShowSplitGlyph = DevExpress.Utils.DefaultBoolean.True; + this.split1.Size = new System.Drawing.Size(1126, 570); + this.split1.SplitterPosition = 0; + this.split1.TabIndex = 0; + // + // gcMain1 + // + this.gcMain1.Dock = System.Windows.Forms.DockStyle.Fill; + this.gcMain1.Location = new System.Drawing.Point(0, 0); + this.gcMain1.MainView = this.gridView1; + this.gcMain1.Name = "gcMain1"; + this.gcMain1.Size = new System.Drawing.Size(1126, 519); + this.gcMain1.TabIndex = 2; + this.gcMain1.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] { + this.gridView1}); + // + // gridView1 + // + this.gridView1.Appearance.Row.Options.UseFont = true; + this.gridView1.Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] { + this.gv_guid, + this.gv_itemId, + this.gridColumn3, + this.gridColumn2, + this.gridColumn4, + this.gv_itemBarcode, + this.gv_quantity, + this.gv_depotId, + this.gridColumn6, + this.gridColumn1, + this.gv_depotSectionsCode, + this.gv_ownerType, + this.gv_ownerId, + this.gridColumn5, + this.gv_indepUserCode, + this.gv_indepDate}); + this.gridView1.GridControl = this.gcMain1; + this.gridView1.IndicatorWidth = 50; + this.gridView1.Name = "gridView1"; + this.gridView1.OptionsFind.ShowSearchNavButtons = false; + this.gridView1.OptionsView.ShowAutoFilterRow = true; + this.gridView1.OptionsView.ShowFooter = true; + this.gridView1.OptionsView.ShowGroupPanel = false; + // + // gv_guid + // + this.gv_guid.AppearanceCell.Options.UseFont = true; + this.gv_guid.Caption = "涓婚敭GUID"; + this.gv_guid.FieldName = "guid"; + this.gv_guid.MinWidth = 50; + this.gv_guid.Name = "gv_guid"; + this.gv_guid.OptionsColumn.AllowEdit = false; + this.gv_guid.Tag = "query_a.guid"; + this.gv_guid.Width = 94; + // + // gv_itemId + // + this.gv_itemId.AppearanceCell.Options.UseFont = true; + this.gv_itemId.Caption = "鐗╂枡ID "; + this.gv_itemId.FieldName = "itemId"; + this.gv_itemId.MinWidth = 50; + this.gv_itemId.Name = "gv_itemId"; + this.gv_itemId.OptionsColumn.AllowEdit = false; + this.gv_itemId.Tag = "query_a.ITEM_ID"; + this.gv_itemId.Visible = true; + this.gv_itemId.VisibleIndex = 0; + this.gv_itemId.Width = 73; + // + // gridColumn3 + // + this.gridColumn3.Caption = "鐗╂枡缂栫爜"; + this.gridColumn3.FieldName = "itemNo"; + this.gridColumn3.MinWidth = 25; + this.gridColumn3.Name = "gridColumn3"; + this.gridColumn3.Visible = true; + this.gridColumn3.VisibleIndex = 1; + this.gridColumn3.Width = 73; + // + // gridColumn2 + // + this.gridColumn2.Caption = "鐗╂枡鍚嶇О"; + this.gridColumn2.FieldName = "itemName"; + this.gridColumn2.MinWidth = 25; + this.gridColumn2.Name = "gridColumn2"; + this.gridColumn2.Visible = true; + this.gridColumn2.VisibleIndex = 2; + this.gridColumn2.Width = 73; + // + // gridColumn4 + // + this.gridColumn4.Caption = "瑙勬牸鍨嬪彿"; + this.gridColumn4.FieldName = "itemModel"; + this.gridColumn4.MinWidth = 25; + this.gridColumn4.Name = "gridColumn4"; + this.gridColumn4.Visible = true; + this.gridColumn4.VisibleIndex = 3; + this.gridColumn4.Width = 73; + // + // gv_itemBarcode + // + this.gv_itemBarcode.AppearanceCell.Options.UseFont = true; + this.gv_itemBarcode.Caption = "鐗╂枡鏉$爜"; + this.gv_itemBarcode.FieldName = "itemBarcode"; + this.gv_itemBarcode.MinWidth = 50; + this.gv_itemBarcode.Name = "gv_itemBarcode"; + this.gv_itemBarcode.OptionsColumn.AllowEdit = false; + this.gv_itemBarcode.Tag = "query_a.ITEM_BARCODE"; + this.gv_itemBarcode.Visible = true; + this.gv_itemBarcode.VisibleIndex = 4; + this.gv_itemBarcode.Width = 73; + // + // gv_quantity + // + this.gv_quantity.AppearanceCell.Options.UseFont = true; + this.gv_quantity.Caption = "鏁伴噺 "; + this.gv_quantity.FieldName = "quantity"; + this.gv_quantity.MinWidth = 50; + this.gv_quantity.Name = "gv_quantity"; + this.gv_quantity.OptionsColumn.AllowEdit = false; + this.gv_quantity.Summary.AddRange(new DevExpress.XtraGrid.GridSummaryItem[] { + new DevExpress.XtraGrid.GridColumnSummaryItem(DevExpress.Data.SummaryItemType.Sum, "quantity", "鍚堣={0:0.##}")}); + this.gv_quantity.Tag = "query_a.QUANTITY"; + this.gv_quantity.Visible = true; + this.gv_quantity.VisibleIndex = 5; + this.gv_quantity.Width = 73; + // + // gv_depotId + // + this.gv_depotId.AppearanceCell.Options.UseFont = true; + this.gv_depotId.Caption = "浠撳簱ID"; + this.gv_depotId.FieldName = "depotId"; + this.gv_depotId.MinWidth = 50; + this.gv_depotId.Name = "gv_depotId"; + this.gv_depotId.OptionsColumn.AllowEdit = false; + this.gv_depotId.Tag = "query_a.DEPOT_ID"; + this.gv_depotId.Visible = true; + this.gv_depotId.VisibleIndex = 6; + this.gv_depotId.Width = 73; + // + // gridColumn6 + // + this.gridColumn6.Caption = "浠撳簱缂栧彿"; + this.gridColumn6.FieldName = "depotNo"; + this.gridColumn6.MinWidth = 25; + this.gridColumn6.Name = "gridColumn6"; + this.gridColumn6.Visible = true; + this.gridColumn6.VisibleIndex = 7; + this.gridColumn6.Width = 73; + // + // gridColumn1 + // + this.gridColumn1.Caption = "浠撳簱鍚嶇О"; + this.gridColumn1.FieldName = "depotName"; + this.gridColumn1.MinWidth = 25; + this.gridColumn1.Name = "gridColumn1"; + this.gridColumn1.Visible = true; + this.gridColumn1.VisibleIndex = 8; + this.gridColumn1.Width = 73; + // + // gv_depotSectionsCode + // + this.gv_depotSectionsCode.AppearanceCell.Options.UseFont = true; + this.gv_depotSectionsCode.Caption = "璐т綅缂栧彿"; + this.gv_depotSectionsCode.FieldName = "depotSectionsCode"; + this.gv_depotSectionsCode.MinWidth = 50; + this.gv_depotSectionsCode.Name = "gv_depotSectionsCode"; + this.gv_depotSectionsCode.OptionsColumn.AllowEdit = false; + this.gv_depotSectionsCode.Tag = "query_a.DEPOT_SECTIONS_CODE"; + this.gv_depotSectionsCode.Visible = true; + this.gv_depotSectionsCode.VisibleIndex = 9; + this.gv_depotSectionsCode.Width = 73; + // + // gv_ownerType + // + this.gv_ownerType.AppearanceCell.Options.UseFont = true; + this.gv_ownerType.Caption = "璐т富绫诲瀷"; + this.gv_ownerType.FieldName = "ownerType"; + this.gv_ownerType.MinWidth = 50; + this.gv_ownerType.Name = "gv_ownerType"; + this.gv_ownerType.OptionsColumn.AllowEdit = false; + this.gv_ownerType.Tag = "query_a.Owner_Type"; + this.gv_ownerType.Visible = true; + this.gv_ownerType.VisibleIndex = 10; + this.gv_ownerType.Width = 73; + // + // gv_ownerId + // + this.gv_ownerId.AppearanceCell.Options.UseFont = true; + this.gv_ownerId.Caption = "璐т富ID"; + this.gv_ownerId.FieldName = "ownerId"; + this.gv_ownerId.MinWidth = 50; + this.gv_ownerId.Name = "gv_ownerId"; + this.gv_ownerId.OptionsColumn.AllowEdit = false; + this.gv_ownerId.Tag = "query_a.Owner_Id"; + this.gv_ownerId.Visible = true; + this.gv_ownerId.VisibleIndex = 11; + this.gv_ownerId.Width = 73; + // + // gridColumn5 + // + this.gridColumn5.Caption = "璐т富鍚嶇О"; + this.gridColumn5.FieldName = "ownerName"; + this.gridColumn5.MinWidth = 25; + this.gridColumn5.Name = "gridColumn5"; + this.gridColumn5.Visible = true; + this.gridColumn5.VisibleIndex = 12; + this.gridColumn5.Width = 73; + // + // gv_indepUserCode + // + this.gv_indepUserCode.AppearanceCell.Options.UseFont = true; + this.gv_indepUserCode.Caption = "鍏ュ簱浜�"; + this.gv_indepUserCode.FieldName = "indepUserCode"; + this.gv_indepUserCode.MinWidth = 50; + this.gv_indepUserCode.Name = "gv_indepUserCode"; + this.gv_indepUserCode.OptionsColumn.AllowEdit = false; + this.gv_indepUserCode.Tag = "query_a.INDEP_USER_CODE"; + this.gv_indepUserCode.Visible = true; + this.gv_indepUserCode.VisibleIndex = 13; + this.gv_indepUserCode.Width = 73; + // + // gv_indepDate + // + this.gv_indepDate.AppearanceCell.Options.UseFont = true; + this.gv_indepDate.Caption = "鍏ュ簱鏃ユ湡 "; + this.gv_indepDate.FieldName = "indepDate"; + this.gv_indepDate.MinWidth = 10; + this.gv_indepDate.Name = "gv_indepDate"; + this.gv_indepDate.OptionsColumn.AllowEdit = false; + this.gv_indepDate.Tag = "query_a.INDEP_DATE"; + this.gv_indepDate.Visible = true; + this.gv_indepDate.VisibleIndex = 14; + this.gv_indepDate.Width = 10; + // + // pageBar1 + // + this.pageBar1.CurrentPage = 1; + this.pageBar1.Dock = System.Windows.Forms.DockStyle.Bottom; + this.pageBar1.Location = new System.Drawing.Point(0, 519); + 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(1126, 39); + this.pageBar1.TabIndex = 4; + this.pageBar1.TotalPages = 0; + // + // CKTmkc + // + this.AutoScaleDimensions = new System.Drawing.SizeF(8F, 18F); + this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; + this.ClientSize = new System.Drawing.Size(1128, 682); + this.Controls.Add(this.xtraTabControl1); + this.Controls.Add(this.toolBarMenu1); + this.IconOptions.Image = global::Gs.DevApp.Properties.Resources.logo_png_black; + this.Name = "CKTmkc"; + this.Text = "鏉$爜搴撳瓨"; + ((System.ComponentModel.ISupportInitialize)(this.xtraTabControl1)).EndInit(); + this.xtraTabControl1.ResumeLayout(false); + this.xtraTabPage1.ResumeLayout(false); + ((System.ComponentModel.ISupportInitialize)(this.split1.Panel1)).EndInit(); + this.split1.Panel1.ResumeLayout(false); + ((System.ComponentModel.ISupportInitialize)(this.split1.Panel2)).EndInit(); + ((System.ComponentModel.ISupportInitialize)(this.split1)).EndInit(); + this.split1.ResumeLayout(false); + ((System.ComponentModel.ISupportInitialize)(this.gcMain1)).EndInit(); + ((System.ComponentModel.ISupportInitialize)(this.gridView1)).EndInit(); + this.ResumeLayout(false); + + } + #endregion + private UserControl.UcToolBarMenu toolBarMenu1; + private DevExpress.XtraTab.XtraTabControl xtraTabControl1; + private DevExpress.XtraTab.XtraTabPage xtraTabPage1; + private DevExpress.XtraEditors.SplitContainerControl split1; + private DevExpress.XtraGrid.GridControl gcMain1; + private DevExpress.XtraGrid.Views.Grid.GridView gridView1; + private DevExpress.XtraGrid.Columns.GridColumn gv_guid; + private DevExpress.XtraGrid.Columns.GridColumn gv_itemId; + private DevExpress.XtraGrid.Columns.GridColumn gridColumn3; + private DevExpress.XtraGrid.Columns.GridColumn gridColumn2; + private DevExpress.XtraGrid.Columns.GridColumn gridColumn4; + private DevExpress.XtraGrid.Columns.GridColumn gv_itemBarcode; + private DevExpress.XtraGrid.Columns.GridColumn gv_quantity; + private DevExpress.XtraGrid.Columns.GridColumn gv_depotId; + private DevExpress.XtraGrid.Columns.GridColumn gridColumn6; + private DevExpress.XtraGrid.Columns.GridColumn gridColumn1; + private DevExpress.XtraGrid.Columns.GridColumn gv_depotSectionsCode; + private DevExpress.XtraGrid.Columns.GridColumn gv_ownerType; + private DevExpress.XtraGrid.Columns.GridColumn gv_ownerId; + private DevExpress.XtraGrid.Columns.GridColumn gridColumn5; + private DevExpress.XtraGrid.Columns.GridColumn gv_indepUserCode; + private DevExpress.XtraGrid.Columns.GridColumn gv_indepDate; + private UserControls.Data.UcPageBar pageBar1; + } +} \ No newline at end of file diff --git a/DevApp/Gs.DevApp/DevFrm/Rpt/Ckcgmx.cs b/DevApp/Gs.DevApp/DevFrm/Rpt/Ckcgmx.cs new file mode 100644 index 0000000..881f5b8 --- /dev/null +++ b/DevApp/Gs.DevApp/DevFrm/Rpt/Ckcgmx.cs @@ -0,0 +1,136 @@ +锘縰sing DevExpress.XtraEditors; +using Gs.DevApp.Entity; +using Gs.DevApp.ToolBox; +using Gs.DevApp.UserControl; +using Newtonsoft.Json; +using System; +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 Gs.DevApp.DevFrm.Rpt +{ + public partial class Ckcgmx : DevExpress.XtraEditors.XtraForm + { + string _webServiceName = "Ck/"; + List<FilterEntity> _filterList = new List<FilterEntity>(); + public Ckcgmx() + { + InitializeComponent(); + this.toolBarMenu1.btnLoadClick += ToolBarMenu1_btnLoadClick; + this.toolBarMenu1.btnQueryClick += ToolBarMenu1_btnQueryClick; + this.toolBarMenu1.getXmlConfig(); + Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameter(gridView1, null, this, "", "", (value) => + { + + }); + Gs.DevApp.ToolBox.UtilityHelper.SetTabParameter(gridView1, xtraTabControl1, pageBar1, (value) => + { + }, (value) => + { + getPageList(this.pageBar1.CurrentPage); + }); + getPageList(1); + pageBar1.PagerEvent += PageBar1_PagerEvent; + } + private async void GridView1_ColumnFilterChanged(object sender, EventArgs e) + { + _filterList = Gs.DevApp.ToolBox.UtilityHelper.GetDilter(gridView1.Columns, gridView1); + await Task.Delay(100); + getPageList(1); + } + + /// <summary> + /// 鍒嗛〉浜嬩欢 + /// </summary> + /// <param name="curPage"></param> + /// <param name="pageSize"></param> + private void PageBar1_PagerEvent(int curPage, int pageSize) + { + getPageList(curPage); + } + /// <summary> + /// 鏌ヨ浜嬩欢 + /// </summary> + /// <param name="sender"></param> + /// <param name="e"></param> + private void ToolBarMenu1_btnQueryClick(object sender, EventArgs e) + { + gridView1.ColumnFilterChanged -= GridView1_ColumnFilterChanged; + gridView1.ActiveFilter.Clear(); + gridView1.ColumnFilterChanged += GridView1_ColumnFilterChanged; + var frm = new ShowFilter(gridView1.Columns, _filterList, this.GetType().FullName); + frm.UpdateParent += Frm_UpdateParent; + frm.ShowDialog(); + } + /// <summary> + /// 鏌ヨ鍥炶皟 + /// </summary> + /// <param name="sender"></param> + /// <param name="e"></param> + private void Frm_UpdateParent(object sender, UpdateParentEventArgs e) + { + _filterList = e.FilterList; + getPageList(1); + } + + /// <summary> + /// 鍒锋柊浜嬩欢 + /// </summary> + /// <param name="sender"></param> + /// <param name="e"></param> + private void ToolBarMenu1_btnLoadClick(object sender, EventArgs e) + { + getPageList(this.pageBar1.CurrentPage); + } + + /// <summary> + /// + /// </summary> + /// <param name="curPage">绗嚑椤�</param> + /// <param name="pageSize">姣忛〉鍑犳潯</param> + private void getPageList(int curPage) + { + gcMain1.DataSource = null; var _sbSqlWhere = UtilityHelper.GetSearchWhere(_filterList); + PageQueryModel pgq = new PageQueryModel(curPage, this.pageBar1.RowsCount, "a.INDEP_DATE", "asc", "", _sbSqlWhere.ToString()); + string json = JsonConvert.SerializeObject(pgq); + try + { + var strReturn = UtilityHelper.HttpPost("", _webServiceName + "GetListPage", json); + ReturnModel<PageListModel> dd = UtilityHelper.ReturnToTablePage(strReturn); + if (dd.rtnCode > 0) + { + DataTable dt = dd.rtnData.list; + gcMain1.BindingContext = new BindingContext(); + gridView1.ColumnFilterChanged -= GridView1_ColumnFilterChanged; + if (dt.Rows.Count > 0) + { + gcMain1.DataSource = dt; + gcMain1.ForceInitialize(); + gridView1.BestFitColumns(); Gs.DevApp.ToolBox.UtilityHelper.SetGridLayout(gridView1); + + } + else + UtilityHelper.SetDefaultTable(gcMain1, 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) + { + ToolBox.MsgHelper.ShowError("鎻愮ず锛�" + ex.Message); + } + } + } +} \ No newline at end of file diff --git a/DevApp/Gs.DevApp/DevFrm/Rpt/Ckcgmx.resx b/DevApp/Gs.DevApp/DevFrm/Rpt/Ckcgmx.resx new file mode 100644 index 0000000..1af7de1 --- /dev/null +++ b/DevApp/Gs.DevApp/DevFrm/Rpt/Ckcgmx.resx @@ -0,0 +1,120 @@ +锘�<?xml version="1.0" encoding="utf-8"?> +<root> + <!-- + Microsoft ResX Schema + + Version 2.0 + + The primary goals of this format is to allow a simple XML format + that is mostly human readable. The generation and parsing of the + various data types are done through the TypeConverter classes + associated with the data types. + + Example: + + ... ado.net/XML headers & schema ... + <resheader name="resmimetype">text/microsoft-resx</resheader> + <resheader name="version">2.0</resheader> + <resheader name="reader">System.Resources.ResXResourceReader, System.Windows.Forms, ...</resheader> + <resheader name="writer">System.Resources.ResXResourceWriter, System.Windows.Forms, ...</resheader> + <data name="Name1"><value>this is my long string</value><comment>this is a comment</comment></data> + <data name="Color1" type="System.Drawing.Color, System.Drawing">Blue</data> + <data name="Bitmap1" mimetype="application/x-microsoft.net.object.binary.base64"> + <value>[base64 mime encoded serialized .NET Framework object]</value> + </data> + <data name="Icon1" type="System.Drawing.Icon, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> + <value>[base64 mime encoded string representing a byte array form of the .NET Framework object]</value> + <comment>This is a comment</comment> + </data> + + There are any number of "resheader" rows that contain simple + name/value pairs. + + Each data row contains a name, and value. The row also contains a + type or mimetype. Type corresponds to a .NET class that support + text/value conversion through the TypeConverter architecture. + Classes that don't support this are serialized and stored with the + mimetype set. + + The mimetype is used for serialized objects, and tells the + ResXResourceReader how to depersist the object. This is currently not + extensible. For a given mimetype the value must be set accordingly: + + Note - application/x-microsoft.net.object.binary.base64 is the format + that the ResXResourceWriter will generate, however the reader can + read any of the formats listed below. + + mimetype: application/x-microsoft.net.object.binary.base64 + value : The object must be serialized with + : System.Runtime.Serialization.Formatters.Binary.BinaryFormatter + : and then encoded with base64 encoding. + + mimetype: application/x-microsoft.net.object.soap.base64 + value : The object must be serialized with + : System.Runtime.Serialization.Formatters.Soap.SoapFormatter + : and then encoded with base64 encoding. + + mimetype: application/x-microsoft.net.object.bytearray.base64 + value : The object must be serialized into a byte array + : using a System.ComponentModel.TypeConverter + : and then encoded with base64 encoding. + --> + <xsd:schema id="root" xmlns="" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> + <xsd:import namespace="http://www.w3.org/XML/1998/namespace" /> + <xsd:element name="root" msdata:IsDataSet="true"> + <xsd:complexType> + <xsd:choice maxOccurs="unbounded"> + <xsd:element name="metadata"> + <xsd:complexType> + <xsd:sequence> + <xsd:element name="value" type="xsd:string" minOccurs="0" /> + </xsd:sequence> + <xsd:attribute name="name" use="required" type="xsd:string" /> + <xsd:attribute name="type" type="xsd:string" /> + <xsd:attribute name="mimetype" type="xsd:string" /> + <xsd:attribute ref="xml:space" /> + </xsd:complexType> + </xsd:element> + <xsd:element name="assembly"> + <xsd:complexType> + <xsd:attribute name="alias" type="xsd:string" /> + <xsd:attribute name="name" type="xsd:string" /> + </xsd:complexType> + </xsd:element> + <xsd:element name="data"> + <xsd:complexType> + <xsd:sequence> + <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" /> + <xsd:element name="comment" type="xsd:string" minOccurs="0" msdata:Ordinal="2" /> + </xsd:sequence> + <xsd:attribute name="name" type="xsd:string" use="required" msdata:Ordinal="1" /> + <xsd:attribute name="type" type="xsd:string" msdata:Ordinal="3" /> + <xsd:attribute name="mimetype" type="xsd:string" msdata:Ordinal="4" /> + <xsd:attribute ref="xml:space" /> + </xsd:complexType> + </xsd:element> + <xsd:element name="resheader"> + <xsd:complexType> + <xsd:sequence> + <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" /> + </xsd:sequence> + <xsd:attribute name="name" type="xsd:string" use="required" /> + </xsd:complexType> + </xsd:element> + </xsd:choice> + </xsd:complexType> + </xsd:element> + </xsd:schema> + <resheader name="resmimetype"> + <value>text/microsoft-resx</value> + </resheader> + <resheader name="version"> + <value>2.0</value> + </resheader> + <resheader name="reader"> + <value>System.Resources.ResXResourceReader, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value> + </resheader> + <resheader name="writer"> + <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value> + </resheader> +</root> \ No newline at end of file diff --git a/DevApp/Gs.DevApp/Gs.DevApp.csproj b/DevApp/Gs.DevApp/Gs.DevApp.csproj index 4b780da..ed0229c 100644 --- a/DevApp/Gs.DevApp/Gs.DevApp.csproj +++ b/DevApp/Gs.DevApp/Gs.DevApp.csproj @@ -566,6 +566,12 @@ <Compile Include="DevFrm\Rk\HistoryDhmxcs.Designer.cs"> <DependentUpon>HistoryDhmxcs.cs</DependentUpon> </Compile> + <Compile Include="DevFrm\Rpt\Ckcgmx.cs"> + <SubType>Form</SubType> + </Compile> + <Compile Include="DevFrm\Rpt\Ckcgmx.Designer.cs"> + <DependentUpon>Ckcgmx.cs</DependentUpon> + </Compile> <Compile Include="DevFrm\Rpt\CKTmkc.cs"> <SubType>Form</SubType> </Compile> @@ -1441,6 +1447,9 @@ <EmbeddedResource Include="DevFrm\Rk\HistoryDhmxcs.resx"> <DependentUpon>HistoryDhmxcs.cs</DependentUpon> </EmbeddedResource> + <EmbeddedResource Include="DevFrm\Rpt\Ckcgmx.resx"> + <DependentUpon>Ckcgmx.cs</DependentUpon> + </EmbeddedResource> <EmbeddedResource Include="DevFrm\Rpt\CKTmkc.resx"> <DependentUpon>CKTmkc.cs</DependentUpon> </EmbeddedResource> -- Gitblit v1.9.3