dev前台代码
上一版本: 45658068 | 补丁 | 提交 | 忽略空白
cdk
2025-11-19 21f1cfd93d7a8d997cba3d2a8986b0630d518805 
增加超期条码
已修改1个文件
已添加3个文件
698 ■■■■■ 文件已修改
DevApp/Gs.DevApp/DevFrm/Rpt/Frm_CQTM.Designer.cs 376 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
DevApp/Gs.DevApp/DevFrm/Rpt/Frm_CQTM.cs 193 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
DevApp/Gs.DevApp/DevFrm/Rpt/Frm_CQTM.resx 120 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
DevApp/Gs.DevApp/Gs.DevApp.csproj 9 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 
 DevApp/Gs.DevApp/DevFrm/Rpt/Frm_CQTM.Designer.cs


¶Ô±ÈÐÂÎļþ


@@ -0,0 +1,376 @@


namespace Gs.DevApp.DevFrm.Rpt


{


    partial class Frm_CQTM


    {


        /// <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.pageBar1 = new UserControls.Data.UcPageBar();


            this.gridColumn1 = new DevExpress.XtraGrid.Columns.GridColumn();


            this.gridColumn2 = new DevExpress.XtraGrid.Columns.GridColumn();


            this.gridColumn3 = new DevExpress.XtraGrid.Columns.GridColumn();


            this.gridColumn4 = new DevExpress.XtraGrid.Columns.GridColumn();


            this.gridColumn5 = new DevExpress.XtraGrid.Columns.GridColumn();


            this.gridColumn6 = new DevExpress.XtraGrid.Columns.GridColumn();


            this.gridColumn7 = new DevExpress.XtraGrid.Columns.GridColumn();


            this.gridColumn8 = new DevExpress.XtraGrid.Columns.GridColumn();


            this.gridColumn9 = new DevExpress.XtraGrid.Columns.GridColumn();


            this.gridColumn10 = new DevExpress.XtraGrid.Columns.GridColumn();


            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();


            ((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.Margin = new System.Windows.Forms.Padding(5);


            this.toolBarMenu1.Name = "toolBarMenu1";


            this.toolBarMenu1.rptParameter = null;


            this.toolBarMenu1.Size = new System.Drawing.Size(1640, 98);


            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, 98);


            this.xtraTabControl1.Margin = new System.Windows.Forms.Padding(4);


            this.xtraTabControl1.Name = "xtraTabControl1";


            this.xtraTabControl1.SelectedTabPage = this.xtraTabPage1;


            this.xtraTabControl1.Size = new System.Drawing.Size(1640, 736);


            this.xtraTabControl1.TabIndex = 3;


            this.xtraTabControl1.TabPages.AddRange(new DevExpress.XtraTab.XtraTabPage[] {


            this.xtraTabPage1});


            // 


            // xtraTabPage1


            // 


            this.xtraTabPage1.Controls.Add(this.split1);


            this.xtraTabPage1.Margin = new System.Windows.Forms.Padding(4);


            this.xtraTabPage1.Name = "xtraTabPage1";


            this.xtraTabPage1.Size = new System.Drawing.Size(1638, 698);


            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.Margin = new System.Windows.Forms.Padding(4);


            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(1638, 698);


            this.split1.SplitterPosition = 0;


            this.split1.TabIndex = 0;


            // 


            // gcMain1


            // 


            this.gcMain1.Dock = System.Windows.Forms.DockStyle.Fill;


            this.gcMain1.EmbeddedNavigator.Margin = new System.Windows.Forms.Padding(4);


            this.gcMain1.Location = new System.Drawing.Point(0, 0);


            this.gcMain1.MainView = this.gridView1;


            this.gcMain1.Margin = new System.Windows.Forms.Padding(4);


            this.gcMain1.Name = "gcMain1";


            this.gcMain1.Size = new System.Drawing.Size(1638, 635);


            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.gridColumn1,


            this.gridColumn2,


            this.gridColumn3,


            this.gridColumn4,


            this.gridColumn5,


            this.gridColumn6,


            this.gridColumn7,


            this.gridColumn8,


            this.gridColumn9,


            this.gridColumn10,


            this.gridColumn11,


            this.gridColumn12,


            this.gridColumn13,


            this.gridColumn14,


            this.gridColumn15});


            this.gridView1.DetailHeight = 428;


            this.gridView1.GridControl = this.gcMain1;


            this.gridView1.IndicatorWidth = 62;


            this.gridView1.Name = "gridView1";


            this.gridView1.OptionsFind.ShowSearchNavButtons = false;


            this.gridView1.OptionsView.ShowAutoFilterRow = true;


            this.gridView1.OptionsView.ShowFooter = true;


            this.gridView1.OptionsView.ShowGroupPanel = false;


            // 


            // pageBar1


            // 


            this.pageBar1.CurrentPage = 1;


            this.pageBar1.Dock = System.Windows.Forms.DockStyle.Bottom;


            this.pageBar1.Location = new System.Drawing.Point(0, 635);


            this.pageBar1.Margin = new System.Windows.Forms.Padding(4, 6, 4, 6);


            this.pageBar1.Name = "pageBar1";


            this.pageBar1.RecordCount = 0;


            this.pageBar1.Size = new System.Drawing.Size(1638, 48);


            this.pageBar1.TabIndex = 4;


            this.pageBar1.TotalPages = 0;


            // 


            // gridColumn1


            // 


            this.gridColumn1.Caption = "条码编号";


            this.gridColumn1.FieldName = "条码编号";


            this.gridColumn1.MinWidth = 30;


            this.gridColumn1.Name = "gridColumn1";


            this.gridColumn1.Visible = true;


            this.gridColumn1.VisibleIndex = 0;


            this.gridColumn1.Width = 112;


            // 


            // gridColumn2


            // 


            this.gridColumn2.Caption = "物料编码";


            this.gridColumn2.FieldName = "物料编码";


            this.gridColumn2.MinWidth = 30;


            this.gridColumn2.Name = "gridColumn2";


            this.gridColumn2.Visible = true;


            this.gridColumn2.VisibleIndex = 1;


            this.gridColumn2.Width = 112;


            // 


            // gridColumn3


            // 


            this.gridColumn3.Caption = "物料名称";


            this.gridColumn3.FieldName = "物料名称";


            this.gridColumn3.MinWidth = 30;


            this.gridColumn3.Name = "gridColumn3";


            this.gridColumn3.Visible = true;


            this.gridColumn3.VisibleIndex = 2;


            this.gridColumn3.Width = 112;


            // 


            // gridColumn4


            // 


            this.gridColumn4.Caption = "物料规格";


            this.gridColumn4.FieldName = "物料规格";


            this.gridColumn4.MinWidth = 30;


            this.gridColumn4.Name = "gridColumn4";


            this.gridColumn4.Visible = true;


            this.gridColumn4.VisibleIndex = 3;


            this.gridColumn4.Width = 112;


            // 


            // gridColumn5


            // 


            this.gridColumn5.Caption = "数量";


            this.gridColumn5.FieldName = "数量";


            this.gridColumn5.MinWidth = 30;


            this.gridColumn5.Name = "gridColumn5";


            this.gridColumn5.Visible = true;


            this.gridColumn5.VisibleIndex = 4;


            this.gridColumn5.Width = 112;


            // 


            // gridColumn6


            // 


            this.gridColumn6.Caption = "最后一次检验日期";


            this.gridColumn6.FieldName = "最后一次检验日期";


            this.gridColumn6.MinWidth = 30;


            this.gridColumn6.Name = "gridColumn6";


            this.gridColumn6.Visible = true;


            this.gridColumn6.VisibleIndex = 5;


            this.gridColumn6.Width = 112;


            // 


            // gridColumn7


            // 


            this.gridColumn7.Caption = "保质期限";


            this.gridColumn7.FieldName = "保质期限";


            this.gridColumn7.MinWidth = 30;


            this.gridColumn7.Name = "gridColumn7";


            this.gridColumn7.Visible = true;


            this.gridColumn7.VisibleIndex = 6;


            this.gridColumn7.Width = 112;


            // 


            // gridColumn8


            // 


            this.gridColumn8.Caption = "到期日期";


            this.gridColumn8.FieldName = "到期日期";


            this.gridColumn8.MinWidth = 30;


            this.gridColumn8.Name = "gridColumn8";


            this.gridColumn8.Visible = true;


            this.gridColumn8.VisibleIndex = 7;


            this.gridColumn8.Width = 112;


            // 


            // gridColumn9


            // 


            this.gridColumn9.Caption = "检验次数";


            this.gridColumn9.FieldName = "检验次数";


            this.gridColumn9.MinWidth = 30;


            this.gridColumn9.Name = "gridColumn9";


            this.gridColumn9.Visible = true;


            this.gridColumn9.VisibleIndex = 8;


            this.gridColumn9.Width = 112;


            // 


            // gridColumn10


            // 


            this.gridColumn10.Caption = "取出库位";


            this.gridColumn10.FieldName = "取出库位";


            this.gridColumn10.MinWidth = 30;


            this.gridColumn10.Name = "gridColumn10";


            this.gridColumn10.Visible = true;


            this.gridColumn10.VisibleIndex = 9;


            this.gridColumn10.Width = 112;


            // 


            // gridColumn11


            // 


            this.gridColumn11.Caption = "组织机构";


            this.gridColumn11.FieldName = "组织机构";


            this.gridColumn11.MinWidth = 30;


            this.gridColumn11.Name = "gridColumn11";


            this.gridColumn11.Visible = true;


            this.gridColumn11.VisibleIndex = 10;


            this.gridColumn11.Width = 112;


            // 


            // gridColumn12


            // 


            this.gridColumn12.Caption = "提前预警天数";


            this.gridColumn12.FieldName = "提前预警天数";


            this.gridColumn12.MinWidth = 30;


            this.gridColumn12.Name = "gridColumn12";


            this.gridColumn12.Visible = true;


            this.gridColumn12.VisibleIndex = 11;


            this.gridColumn12.Width = 112;


            // 


            // gridColumn13


            // 


            this.gridColumn13.Caption = "剩余有效天数";


            this.gridColumn13.FieldName = "剩余有效天数";


            this.gridColumn13.MinWidth = 30;


            this.gridColumn13.Name = "gridColumn13";


            this.gridColumn13.Visible = true;


            this.gridColumn13.VisibleIndex = 12;


            this.gridColumn13.Width = 112;


            // 


            // gridColumn14


            // 


            this.gridColumn14.Caption = "开始预警日期";


            this.gridColumn14.FieldName = "开始预警日期";


            this.gridColumn14.MinWidth = 30;


            this.gridColumn14.Name = "gridColumn14";


            this.gridColumn14.Visible = true;


            this.gridColumn14.VisibleIndex = 13;


            this.gridColumn14.Width = 112;


            // 


            // gridColumn15


            // 


            this.gridColumn15.Caption = "方案名称";


            this.gridColumn15.FieldName = "方案名称";


            this.gridColumn15.MinWidth = 30;


            this.gridColumn15.Name = "gridColumn15";


            this.gridColumn15.Visible = true;


            this.gridColumn15.VisibleIndex = 14;


            this.gridColumn15.Width = 112;


            // 


            // Frm_CQTM


            // 


            this.AutoScaleDimensions = new System.Drawing.SizeF(10F, 22F);


            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;


            this.ClientSize = new System.Drawing.Size(1640, 834);


            this.Controls.Add(this.xtraTabControl1);


            this.Controls.Add(this.toolBarMenu1);


            this.IconOptions.Image = global::Gs.DevApp.Properties.Resources.logo_png_black;


            this.Margin = new System.Windows.Forms.Padding(4);


            this.Name = "Frm_CQTM";


            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 UserControls.Data.UcPageBar pageBar1;


        private DevExpress.XtraGrid.Views.Grid.GridView gridView1;


        private DevExpress.XtraGrid.Columns.GridColumn gridColumn1;


        private DevExpress.XtraGrid.Columns.GridColumn gridColumn2;


        private DevExpress.XtraGrid.Columns.GridColumn gridColumn3;


        private DevExpress.XtraGrid.Columns.GridColumn gridColumn4;


        private DevExpress.XtraGrid.Columns.GridColumn gridColumn5;


        private DevExpress.XtraGrid.Columns.GridColumn gridColumn6;


        private DevExpress.XtraGrid.Columns.GridColumn gridColumn7;


        private DevExpress.XtraGrid.Columns.GridColumn gridColumn8;


        private DevExpress.XtraGrid.Columns.GridColumn gridColumn9;


        private DevExpress.XtraGrid.Columns.GridColumn gridColumn10;


        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;


    }


}




 DevApp/Gs.DevApp/DevFrm/Rpt/Frm_CQTM.cs


¶Ô±ÈÐÂÎļþ


@@ -0,0 +1,193 @@


using DevExpress.Utils;


using DevExpress.XtraEditors;


using DevExpress.XtraRichEdit.Model;


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.Configuration;


using System.Data;


using System.Drawing;


using System.Linq;


using System.Net;


using System.Text;


using System.Threading.Tasks;


using System.Windows.Forms;




namespace Gs.DevApp.DevFrm.Rpt


{


    public partial class Frm_CQTM : DevExpress.XtraEditors.XtraForm


    {


        string _webServiceName = "Ck/";


        List<FilterEntity> _filterList = new List<FilterEntity>();


        public Frm_CQTM()


        {


            InitializeComponent();


            this.toolBarMenu1.btnLoadClick += ToolBarMenu1_btnLoadClick;


            this.toolBarMenu1.btnQueryClick += ToolBarMenu1_btnQueryClick;


            this.toolBarMenu1.btnOutClick += ToolBarMenu1_btnOutClick;


            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;


            System.Text.StringBuilder _sbSqlWhere = new System.Text.StringBuilder();


            _sbSqlWhere.Append(" and a.kcorgid in");


            _sbSqlWhere.Append(ToolBox.UtilityHelper.GetOrgWhere());


            _sbSqlWhere.Append(UtilityHelper.GetSearchWhere(_filterList));


            PageQueryModel pgq = new PageQueryModel(curPage, this.pageBar1.RowsCount, "a.RKDate", "asc", "", _sbSqlWhere.ToString());


            string json = JsonConvert.SerializeObject(pgq);


            try


            {


                var strReturn = UtilityHelper.HttpPost("", _webServiceName + "GetListPageCQTM", 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);


            }


        }




        private void ToolBarMenu1_btnOutClick(object sender, EventArgs e)


        {


            using (FolderBrowserDialog folderBrowserDialog = new FolderBrowserDialog())


            {


                folderBrowserDialog.Description = "选择导出文件的保存路径";


                DialogResult dialogResult = folderBrowserDialog.ShowDialog();


                System.Text.StringBuilder _sbSqlWhere = new System.Text.StringBuilder();


                _sbSqlWhere.Append(" and a.kcorgid in");


                _sbSqlWhere.Append(ToolBox.UtilityHelper.GetOrgWhere());


                _sbSqlWhere.Append(UtilityHelper.GetSearchWhere(_filterList));


                if (dialogResult == DialogResult.OK)


                {


                    string _folder = folderBrowserDialog.SelectedPath;


                    var _params = new


                    {


                        inSortName = "",


                        inSortOrder = "",


                        inQueryWhere = _sbSqlWhere.ToString()


                    };


                    var _obj = new Gs.DevApp.Entity.XlsOutModel("xlsout_CQTM", "", "", "", _params);


                    try


                    {


                        string strJson = UtilityHelper.HttpPost("", "XlsInOut/XlsOutView_NEW", JsonConvert.SerializeObject(_obj));


                        ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson);


                        if (_rtn.rtnCode > 0)


                        {


                            string _file = _rtn.rtnData.fileUrl.ToString();


                            string _folderName = _folder + "\\" + _file.Replace("down/", "");


                            string _url = ConfigurationManager.AppSettings["WebApiUrl"].ToString() + _file;


                            using (WebClient client = new WebClient())


                            {


                                client.DownloadFile(_url, _folderName);


                            }


                            ToolBox.MsgHelper.ShowInformation("导出成功！");


                        }


                        else


                        {


                            ToolBox.MsgHelper.Warning("提示：" + _rtn.rtnMsg);


                        }


                    }


                    catch (Exception ex)


                    {


                        ToolBox.MsgHelper.Warning("提示：" + ex.Message);


                    }


                }


            }


        }


    }


}




 DevApp/Gs.DevApp/DevFrm/Rpt/Frm_CQTM.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>




 DevApp/Gs.DevApp/Gs.DevApp.csproj


@@ -825,6 +825,12 @@


    <Compile Include="DevFrm\Rpt\CPMX.Designer.cs">


      <DependentUpon>CPMX.cs</DependentUpon>


    </Compile>


    <Compile Include="DevFrm\Rpt\Frm_CQTM.cs">


      <SubType>Form</SubType>


    </Compile>


    <Compile Include="DevFrm\Rpt\Frm_CQTM.Designer.cs">


      <DependentUpon>Frm_CQTM.cs</DependentUpon>


    </Compile>


    <Compile Include="DevFrm\Rpt\Frm_MesQL.cs">


      <SubType>Form</SubType>


    </Compile>


@@ -2015,6 +2021,9 @@


    <EmbeddedResource Include="DevFrm\Rpt\CPMX.resx">


      <DependentUpon>CPMX.cs</DependentUpon>


    </EmbeddedResource>


    <EmbeddedResource Include="DevFrm\Rpt\Frm_CQTM.resx">


      <DependentUpon>Frm_CQTM.cs</DependentUpon>


    </EmbeddedResource>


    <EmbeddedResource Include="DevFrm\Rpt\Frm_MesQL.resx">


      <DependentUpon>Frm_MesQL.cs</DependentUpon>


    </EmbeddedResource>