yusijie
2022-11-15 ca964154bcc4a8a7a617320b3c9355e0c464ad39
奥邦(新增车间报表,超产报表)
4个文件已修改
6个文件已添加
2038 ■■■■■ 已修改文件
BLL/系统公用CLS/ClsBaseSelect.cs 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
LMES/ClsShowMod.cs 14 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WorkM/WorkM.csproj 18 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WorkM/WorkM.csproj.user 1 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WorkM/报表分析/Sc_WareHouseReport.Designer.cs 532 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WorkM/报表分析/Sc_WareHouseReport.cs 342 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WorkM/报表分析/Sc_WareHouseReport.resx 129 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WorkM/报表分析/Sc_WorkShopReport.Designer.cs 532 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WorkM/报表分析/Sc_WorkShopReport.cs 339 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WorkM/报表分析/Sc_WorkShopReport.resx 129 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
BLL/ϵͳ¹«ÓÃCLS/ClsBaseSelect.cs
@@ -530,7 +530,7 @@
            DAL.ClsGy_Department_View oDept = new DAL.ClsGy_Department_View();
            if (oDept.RefreshView())
            {
                txt.Text = oDept.oModel.HNumber;
                txt.Text = oDept.oModel.HName;
                txt.Tag = oDept.oModel.HItemID.ToString();
            }
            else
LMES/ClsShowMod.cs
@@ -7948,6 +7948,20 @@
                        oSc_WorkProcReport_New.Show();
                        oMainForm.AddTabPage(oSc_WorkProcReport_New);
                        break;
                    case "sc_workshopreport":
                        Sc_WorkShopReport oSc_WorkShopReport = new Sc_WorkShopReport();
                        oSc_WorkShopReport.MdiParent = oMain;
                        oSc_WorkShopReport.ModCaption = gnmc;
                        oSc_WorkShopReport.Show();
                        oMainForm.AddTabPage(oSc_WorkShopReport);
                        break;
                    case "sc_warehousereport":
                        Sc_WareHouseReport oSc_WareHouseReport = new Sc_WareHouseReport();
                        oSc_WareHouseReport.MdiParent = oMain;
                        oSc_WareHouseReport.ModCaption = gnmc;
                        oSc_WareHouseReport.Show();
                        oMainForm.AddTabPage(oSc_WareHouseReport);
                        break;
                    case "sc_brfhkb":
                        Sc_BRFHKB oSc_BRFHKB = new Sc_BRFHKB();
                        oSc_BRFHKB.ShowDialog();
WorkM/WorkM.csproj
@@ -221,6 +221,18 @@
    <Compile Include="报表分析\Pt_RadiumCarvingCodeBillList.designer.cs">
      <DependentUpon>Pt_RadiumCarvingCodeBillList.cs</DependentUpon>
    </Compile>
    <Compile Include="报表分析\Sc_WareHouseReport.cs">
      <SubType>Form</SubType>
    </Compile>
    <Compile Include="报表分析\Sc_WareHouseReport.Designer.cs">
      <DependentUpon>Sc_WareHouseReport.cs</DependentUpon>
    </Compile>
    <Compile Include="报表分析\Sc_WorkShopReport.cs">
      <SubType>Form</SubType>
    </Compile>
    <Compile Include="报表分析\Sc_WorkShopReport.Designer.cs">
      <DependentUpon>Sc_WorkShopReport.cs</DependentUpon>
    </Compile>
    <Compile Include="报表分析\WMS_BarCodeBackInfoReport.cs">
      <SubType>Form</SubType>
    </Compile>
@@ -971,6 +983,12 @@
    <EmbeddedResource Include="报表分析\Pt_RadiumCarvingCodeBillList.resx">
      <DependentUpon>Pt_RadiumCarvingCodeBillList.cs</DependentUpon>
    </EmbeddedResource>
    <EmbeddedResource Include="报表分析\Sc_WareHouseReport.resx">
      <DependentUpon>Sc_WareHouseReport.cs</DependentUpon>
    </EmbeddedResource>
    <EmbeddedResource Include="报表分析\Sc_WorkShopReport.resx">
      <DependentUpon>Sc_WorkShopReport.cs</DependentUpon>
    </EmbeddedResource>
    <EmbeddedResource Include="报表分析\WMS_BarCodeBackInfoReport.resx">
      <DependentUpon>WMS_BarCodeBackInfoReport.cs</DependentUpon>
      <SubType>Designer</SubType>
WorkM/WorkM.csproj.user
@@ -9,5 +9,6 @@
    <ErrorReportUrlHistory />
    <FallbackCulture>zh-CN</FallbackCulture>
    <VerifyUploadedFiles>false</VerifyUploadedFiles>
    <ProjectView>ProjectFiles</ProjectView>
  </PropertyGroup>
</Project>
WorkM/±¨±í·ÖÎö/Sc_WareHouseReport.Designer.cs
New file
@@ -0,0 +1,532 @@
namespace WorkM
{
    partial class Sc_WareHouseReport
    {
        /// <summary>
        /// å¿…需的设计器变量。
        /// </summary>
        private System.ComponentModel.IContainer components = null;
        /// <summary>
        /// æ¸…理所有正在使用的资源。
        /// </summary>
        /// <param name="disposing">如果应释放托管资源,为 true;否则为 false。</param>
        protected override void Dispose(bool disposing)
        {
            if (disposing && (components != null))
            {
                components.Dispose();
            }
            base.Dispose(disposing);
        }
        #region Windows çª—体设计器生成的代码
        /// <summary>
        /// è®¾è®¡å™¨æ”¯æŒæ‰€éœ€çš„æ–¹æ³• - ä¸è¦
        /// ä½¿ç”¨ä»£ç ç¼–辑器修改此方法的内容。
        /// </summary>
        private void InitializeComponent()
        {
            this.components = new System.ComponentModel.Container();
            System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Sc_ProcExchListReport));
            this.timer1 = new System.Windows.Forms.Timer(this.components);
            this.Tool = new System.Windows.Forms.ToolStrip();
            this.yl = new System.Windows.Forms.ToolStripButton();
            this.toolStripSeparator4 = new System.Windows.Forms.ToolStripSeparator();
            this.dy = new System.Windows.Forms.ToolStripButton();
            this.view = new System.Windows.Forms.ToolStripButton();
            this.toolStripSeparator2 = new System.Windows.Forms.ToolStripSeparator();
            this.cx = new System.Windows.Forms.ToolStripButton();
            this.toolStripSeparator1 = new System.Windows.Forms.ToolStripSeparator();
            this.tc = new System.Windows.Forms.ToolStripButton();
            this.toolStripSeparator3 = new System.Windows.Forms.ToolStripSeparator();
            this.toolStripSeparator8 = new System.Windows.Forms.ToolStripSeparator();
            this.mrlk = new System.Windows.Forms.ToolStripButton();
            this.toolStripSeparator7 = new System.Windows.Forms.ToolStripSeparator();
            this.bclk = new System.Windows.Forms.ToolStripButton();
            this.toolStripSeparator9 = new System.Windows.Forms.ToolStripSeparator();
            this.pPic = new System.Windows.Forms.Panel();
            this.dataGridView1 = new System.Windows.Forms.DataGridView();
            //this.cmdHEDeptID = new System.Windows.Forms.Button();
            //this.cmdHBDeptID = new System.Windows.Forms.Button();
            //this.label6 = new System.Windows.Forms.Label();
            //this.txtHEDeptID = new System.Windows.Forms.TextBox();
            //this.txtHBDeptID = new System.Windows.Forms.TextBox();
            //this.label1 = new System.Windows.Forms.Label();
            //this.dtpHEDate = new System.Windows.Forms.DateTimePicker();
            //this.label3 = new System.Windows.Forms.Label();
            //this.dtpHBDate = new System.Windows.Forms.DateTimePicker();
            //this.label4 = new System.Windows.Forms.Label();
            this.lblCaption = new System.Windows.Forms.Label();
            this.timer2 = new System.Windows.Forms.Timer(this.components);
            this.grdMain = new System.Windows.Forms.DataGridView();
            this.grdSum = new System.Windows.Forms.DataGridView();
            this.toolStripDropDownButton1 = new System.Windows.Forms.ToolStripDropDownButton();
            this.eXCELToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
            this.cSVToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
            this.Tool.SuspendLayout();
            this.pPic.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.grdMain)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.grdSum)).BeginInit();
            this.SuspendLayout();
            //
            // timer1
            //
            this.timer1.Tick += new System.EventHandler(this.timer1_Tick);
            //
            // Tool
            //
            this.Tool.AutoSize = false;
            this.Tool.BackColor = System.Drawing.SystemColors.Control;
            this.Tool.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("Tool.BackgroundImage")));
            this.Tool.BackgroundImageLayout = System.Windows.Forms.ImageLayout.Stretch;
            this.Tool.ImageScalingSize = new System.Drawing.Size(22, 22);
            this.Tool.Items.AddRange(new System.Windows.Forms.ToolStripItem[] {
            this.toolStripDropDownButton1,
            this.yl,
            this.toolStripSeparator4,
            this.dy,
            this.view,
            this.toolStripSeparator2,
            this.cx,
            this.toolStripSeparator1,
            this.tc,
            this.toolStripSeparator3,
            this.toolStripSeparator8,
            this.mrlk,
            this.toolStripSeparator7,
            this.bclk,
            this.toolStripSeparator9});
            this.Tool.Location = new System.Drawing.Point(0, 0);
            this.Tool.Name = "Tool";
            this.Tool.Padding = new System.Windows.Forms.Padding(0);
            this.Tool.Size = new System.Drawing.Size(1257, 59);
            this.Tool.Stretch = true;
            this.Tool.TabIndex = 16;
            this.Tool.Text = "toolStrip1";
            //
            // yl
            //
            this.yl.AutoSize = false;
            this.yl.Image = ((System.Drawing.Image)(resources.GetObject("yl.Image")));
            this.yl.ImageAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.yl.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
            this.yl.ImageTransparentColor = System.Drawing.Color.Magenta;
            this.yl.Name = "yl";
            this.yl.Size = new System.Drawing.Size(35, 42);
            this.yl.Text = "引出";
            this.yl.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.yl.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            this.yl.Visible = false;
            this.yl.Click += new System.EventHandler(this.yc_Click);
            //
            // toolStripSeparator4
            //
            this.toolStripSeparator4.Name = "toolStripSeparator4";
            this.toolStripSeparator4.Size = new System.Drawing.Size(6, 59);
            this.toolStripSeparator4.Visible = false;
            //
            // dy
            //
            this.dy.AutoSize = false;
            this.dy.Image = ((System.Drawing.Image)(resources.GetObject("dy.Image")));
            this.dy.ImageAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.dy.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
            this.dy.ImageTransparentColor = System.Drawing.Color.Magenta;
            this.dy.Name = "dy";
            this.dy.Size = new System.Drawing.Size(35, 42);
            this.dy.Text = "打印";
            this.dy.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.dy.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            this.dy.Visible = false;
            this.dy.Click += new System.EventHandler(this.dy_Click);
            //
            // view
            //
            this.view.AutoSize = false;
            this.view.Image = ((System.Drawing.Image)(resources.GetObject("view.Image")));
            this.view.ImageAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.view.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
            this.view.ImageTransparentColor = System.Drawing.Color.Magenta;
            this.view.Name = "view";
            this.view.Size = new System.Drawing.Size(35, 42);
            this.view.Text = "预览";
            this.view.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.view.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            this.view.Visible = false;
            this.view.Click += new System.EventHandler(this.view_Click);
            //
            // toolStripSeparator2
            //
            this.toolStripSeparator2.Name = "toolStripSeparator2";
            this.toolStripSeparator2.Size = new System.Drawing.Size(6, 59);
            //
            // cx
            //
            this.cx.AutoSize = false;
            this.cx.Image = ((System.Drawing.Image)(resources.GetObject("cx.Image")));
            this.cx.ImageAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.cx.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
            this.cx.ImageTransparentColor = System.Drawing.Color.White;
            this.cx.Name = "cx";
            this.cx.Size = new System.Drawing.Size(35, 42);
            this.cx.Text = "查询";
            this.cx.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.cx.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            this.cx.Click += new System.EventHandler(this.cx_Click);
            //
            // toolStripSeparator1
            //
            this.toolStripSeparator1.Name = "toolStripSeparator1";
            this.toolStripSeparator1.Size = new System.Drawing.Size(6, 59);
            //
            // tc
            //
            this.tc.AutoSize = false;
            this.tc.Image = ((System.Drawing.Image)(resources.GetObject("tc.Image")));
            this.tc.ImageAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.tc.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
            this.tc.ImageTransparentColor = System.Drawing.Color.White;
            this.tc.Name = "tc";
            this.tc.Size = new System.Drawing.Size(35, 42);
            this.tc.Text = "退出";
            this.tc.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.tc.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            this.tc.Click += new System.EventHandler(this.tc_Click);
            //
            // toolStripSeparator3
            //
            this.toolStripSeparator3.Name = "toolStripSeparator3";
            this.toolStripSeparator3.Size = new System.Drawing.Size(6, 59);
            //
            // toolStripSeparator8
            //
            this.toolStripSeparator8.Alignment = System.Windows.Forms.ToolStripItemAlignment.Right;
            this.toolStripSeparator8.Name = "toolStripSeparator8";
            this.toolStripSeparator8.Size = new System.Drawing.Size(6, 59);
            //
            // mrlk
            //
            this.mrlk.Alignment = System.Windows.Forms.ToolStripItemAlignment.Right;
            this.mrlk.Image = ((System.Drawing.Image)(resources.GetObject("mrlk.Image")));
            this.mrlk.ImageAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.mrlk.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
            this.mrlk.ImageTransparentColor = System.Drawing.Color.White;
            this.mrlk.Name = "mrlk";
            this.mrlk.Size = new System.Drawing.Size(73, 56);
            this.mrlk.Text = "默认列宽";
            this.mrlk.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.mrlk.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            this.mrlk.Click += new System.EventHandler(this.mrlk_Click);
            //
            // toolStripSeparator7
            //
            this.toolStripSeparator7.Alignment = System.Windows.Forms.ToolStripItemAlignment.Right;
            this.toolStripSeparator7.Name = "toolStripSeparator7";
            this.toolStripSeparator7.Size = new System.Drawing.Size(6, 59);
            //
            // bclk
            //
            this.bclk.Alignment = System.Windows.Forms.ToolStripItemAlignment.Right;
            this.bclk.Image = ((System.Drawing.Image)(resources.GetObject("bclk.Image")));
            this.bclk.ImageAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.bclk.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
            this.bclk.ImageTransparentColor = System.Drawing.Color.White;
            this.bclk.Name = "bclk";
            this.bclk.Size = new System.Drawing.Size(73, 56);
            this.bclk.Text = "保存列宽";
            this.bclk.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.bclk.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            this.bclk.Click += new System.EventHandler(this.bclk_Click);
            //
            // toolStripSeparator9
            //
            this.toolStripSeparator9.Alignment = System.Windows.Forms.ToolStripItemAlignment.Right;
            this.toolStripSeparator9.Name = "toolStripSeparator9";
            this.toolStripSeparator9.Size = new System.Drawing.Size(6, 59);
            //
            // pPic
            //
            this.pPic.BackColor = System.Drawing.Color.White;
            this.pPic.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("pPic.BackgroundImage")));
            this.pPic.BackgroundImageLayout = System.Windows.Forms.ImageLayout.None;
            this.pPic.Controls.Add(this.dataGridView1);
            //this.pPic.Controls.Add(this.cmdHEDeptID);
            //this.pPic.Controls.Add(this.cmdHBDeptID);
            //this.pPic.Controls.Add(this.label6);
            //this.pPic.Controls.Add(this.txtHEDeptID);
            //this.pPic.Controls.Add(this.txtHBDeptID);
            //this.pPic.Controls.Add(this.label1);
            //this.pPic.Controls.Add(this.dtpHEDate);
            //this.pPic.Controls.Add(this.label3);
            //this.pPic.Controls.Add(this.dtpHBDate);
            //this.pPic.Controls.Add(this.label4);
            this.pPic.Controls.Add(this.lblCaption);
            this.pPic.Dock = System.Windows.Forms.DockStyle.Top;
            this.pPic.Location = new System.Drawing.Point(0, 59);
            this.pPic.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            this.pPic.Name = "pPic";
            this.pPic.Size = new System.Drawing.Size(1257, 69);
            this.pPic.TabIndex = 17;
            //
            // dataGridView1
            //
            this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
            this.dataGridView1.Location = new System.Drawing.Point(1217, 6);
            this.dataGridView1.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            this.dataGridView1.Name = "dataGridView1";
            this.dataGridView1.RowTemplate.Height = 23;
            this.dataGridView1.Size = new System.Drawing.Size(36, 19);
            this.dataGridView1.TabIndex = 68;
            this.dataGridView1.Visible = false;
            ////
            //// cmdHEDeptID
            ////
            //this.cmdHEDeptID.Image = ((System.Drawing.Image)(resources.GetObject("cmdHEDeptID.Image")));
            //this.cmdHEDeptID.ImageAlign = System.Drawing.ContentAlignment.TopRight;
            //this.cmdHEDeptID.Location = new System.Drawing.Point(733, 32);
            //this.cmdHEDeptID.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            //this.cmdHEDeptID.Name = "cmdHEDeptID";
            //this.cmdHEDeptID.Size = new System.Drawing.Size(29, 28);
            //this.cmdHEDeptID.TabIndex = 67;
            //this.cmdHEDeptID.UseVisualStyleBackColor = true;
            //this.cmdHEDeptID.Click += new System.EventHandler(this.cmdHEDeptID_Click);
            ////
            //// cmdHBDeptID
            ////
            //this.cmdHBDeptID.Image = ((System.Drawing.Image)(resources.GetObject("cmdHBDeptID.Image")));
            //this.cmdHBDeptID.ImageAlign = System.Drawing.ContentAlignment.TopRight;
            //this.cmdHBDeptID.Location = new System.Drawing.Point(733, 4);
            //this.cmdHBDeptID.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            //this.cmdHBDeptID.Name = "cmdHBDeptID";
            //this.cmdHBDeptID.Size = new System.Drawing.Size(29, 28);
            //this.cmdHBDeptID.TabIndex = 66;
            //this.cmdHBDeptID.UseVisualStyleBackColor = true;
            //this.cmdHBDeptID.Click += new System.EventHandler(this.cmdHBDeptID_Click);
            ////
            //// label6
            ////
            //this.label6.AutoSize = true;
            //this.label6.BackColor = System.Drawing.Color.Transparent;
            //this.label6.Location = new System.Drawing.Point(543, 39);
            //this.label6.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
            //this.label6.Name = "label6";
            //this.label6.Size = new System.Drawing.Size(22, 15);
            //this.label6.TabIndex = 65;
            //this.label6.Text = "至";
            ////
            //// txtHEDeptID
            ////
            //this.txtHEDeptID.Location = new System.Drawing.Point(579, 34);
            //this.txtHEDeptID.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            //this.txtHEDeptID.Name = "txtHEDeptID";
            //this.txtHEDeptID.Size = new System.Drawing.Size(160, 25);
            //this.txtHEDeptID.TabIndex = 64;
            ////
            //// txtHBDeptID
            ////
            //this.txtHBDeptID.Location = new System.Drawing.Point(579, 5);
            //this.txtHBDeptID.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            //this.txtHBDeptID.Name = "txtHBDeptID";
            //this.txtHBDeptID.Size = new System.Drawing.Size(160, 25);
            //this.txtHBDeptID.TabIndex = 63;
            ////
            //// label1
            ////
            //this.label1.AutoSize = true;
            //this.label1.BackColor = System.Drawing.Color.Transparent;
            //this.label1.Location = new System.Drawing.Point(512, 10);
            //this.label1.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
            //this.label1.Name = "label1";
            //this.label1.Size = new System.Drawing.Size(61, 15);
            //this.label1.TabIndex = 62;
            //this.label1.Text = "部   é—¨";
            ////
            //// dtpHEDate
            ////
            //this.dtpHEDate.Format = System.Windows.Forms.DateTimePickerFormat.Short;
            //this.dtpHEDate.Location = new System.Drawing.Point(352, 35);
            //this.dtpHEDate.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            //this.dtpHEDate.Name = "dtpHEDate";
            //this.dtpHEDate.Size = new System.Drawing.Size(147, 25);
            //this.dtpHEDate.TabIndex = 61;
            ////
            //// label3
            ////
            //this.label3.AutoSize = true;
            //this.label3.BackColor = System.Drawing.Color.Transparent;
            //this.label3.Location = new System.Drawing.Point(276, 39);
            //this.label3.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
            //this.label3.Name = "label3";
            //this.label3.Size = new System.Drawing.Size(67, 15);
            //this.label3.TabIndex = 60;
            //this.label3.Text = "结束日期";
            ////
            //// dtpHBDate
            ////
            //this.dtpHBDate.Format = System.Windows.Forms.DateTimePickerFormat.Short;
            //this.dtpHBDate.Location = new System.Drawing.Point(352, 6);
            //this.dtpHBDate.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            //this.dtpHBDate.Name = "dtpHBDate";
            //this.dtpHBDate.Size = new System.Drawing.Size(147, 25);
            //this.dtpHBDate.TabIndex = 59;
            ////
            //// label4
            ////
            //this.label4.AutoSize = true;
            //this.label4.BackColor = System.Drawing.Color.Transparent;
            //this.label4.Location = new System.Drawing.Point(276, 10);
            //this.label4.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
            //this.label4.Name = "label4";
            //this.label4.Size = new System.Drawing.Size(67, 15);
            //this.label4.TabIndex = 58;
            //this.label4.Text = "开始日期";
            //
            // lblCaption
            //
            this.lblCaption.AutoSize = true;
            this.lblCaption.BackColor = System.Drawing.Color.Transparent;
            this.lblCaption.Cursor = System.Windows.Forms.Cursors.No;
            this.lblCaption.Font = new System.Drawing.Font("宋体", 14.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
            this.lblCaption.Location = new System.Drawing.Point(16, 20);
            this.lblCaption.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
            this.lblCaption.Name = "lblCaption";
            this.lblCaption.Size = new System.Drawing.Size(179, 24);
            this.lblCaption.TabIndex = 4;
            this.lblCaption.Text = "ReportTemplet";
            //
            // timer2
            //
            this.timer2.Tick += new System.EventHandler(this.timer2_Tick);
            //
            // grdMain
            //
            this.grdMain.AllowUserToAddRows = false;
            this.grdMain.AllowUserToDeleteRows = false;
            this.grdMain.BackgroundColor = System.Drawing.Color.White;
            this.grdMain.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
            this.grdMain.Dock = System.Windows.Forms.DockStyle.Fill;
            this.grdMain.Location = new System.Drawing.Point(0, 128);
            this.grdMain.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            this.grdMain.Name = "grdMain";
            this.grdMain.ReadOnly = true;
            this.grdMain.RowTemplate.Height = 23;
            this.grdMain.Size = new System.Drawing.Size(1257, 414);
            this.grdMain.TabIndex = 54;
            this.grdMain.CellMouseUp += new System.Windows.Forms.DataGridViewCellMouseEventHandler(this.grdMain_CellMouseUp);
            this.grdMain.Paint += new System.Windows.Forms.PaintEventHandler(this.grdMain_Paint);
            this.grdMain.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler(this.grdMain_ColumnWidthChanged);
            //
            // grdSum
            //
            this.grdSum.AllowUserToAddRows = false;
            this.grdSum.AllowUserToDeleteRows = false;
            this.grdSum.BackgroundColor = System.Drawing.SystemColors.Control;
            this.grdSum.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
            this.grdSum.Dock = System.Windows.Forms.DockStyle.Bottom;
            this.grdSum.Location = new System.Drawing.Point(0, 542);
            this.grdSum.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            this.grdSum.Name = "grdSum";
            this.grdSum.ReadOnly = true;
            this.grdSum.RowTemplate.Height = 23;
            this.grdSum.ScrollBars = System.Windows.Forms.ScrollBars.None;
            this.grdSum.Size = new System.Drawing.Size(1257, 24);
            this.grdSum.TabIndex = 55;
            //
            // toolStripDropDownButton1
            //
            this.toolStripDropDownButton1.DropDownItems.AddRange(new System.Windows.Forms.ToolStripItem[] {
            this.eXCELToolStripMenuItem,
            this.cSVToolStripMenuItem});
            this.toolStripDropDownButton1.Image = ((System.Drawing.Image)(resources.GetObject("toolStripDropDownButton1.Image")));
            this.toolStripDropDownButton1.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
            this.toolStripDropDownButton1.ImageTransparentColor = System.Drawing.Color.Magenta;
            this.toolStripDropDownButton1.Name = "toolStripDropDownButton1";
            this.toolStripDropDownButton1.Size = new System.Drawing.Size(52, 56);
            this.toolStripDropDownButton1.Text = "引出";
            this.toolStripDropDownButton1.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.toolStripDropDownButton1.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            //
            // eXCELToolStripMenuItem
            //
            this.eXCELToolStripMenuItem.Name = "eXCELToolStripMenuItem";
            this.eXCELToolStripMenuItem.Size = new System.Drawing.Size(152, 24);
            this.eXCELToolStripMenuItem.Text = "EXCEL";
            this.eXCELToolStripMenuItem.Click += new System.EventHandler(this.eXCELToolStripMenuItem_Click);
            //
            // cSVToolStripMenuItem
            //
            this.cSVToolStripMenuItem.Name = "cSVToolStripMenuItem";
            this.cSVToolStripMenuItem.Size = new System.Drawing.Size(152, 24);
            this.cSVToolStripMenuItem.Text = "CSV";
            this.cSVToolStripMenuItem.Click += new System.EventHandler(this.cSVToolStripMenuItem_Click);
            //
            // Sc_ProcExchListReport
            //
            this.AutoScaleDimensions = new System.Drawing.SizeF(8F, 15F);
            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
            this.ClientSize = new System.Drawing.Size(1257, 566);
            this.Controls.Add(this.grdMain);
            this.Controls.Add(this.grdSum);
            this.Controls.Add(this.pPic);
            this.Controls.Add(this.Tool);
            this.KeyPreview = true;
            this.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            this.Name = "Sc_ProcExchListReport";
            this.Text = "ReportTemplet";
            this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
            this.Load += new System.EventHandler(this.Frm_EasyReport_Load);
            this.KeyUp += new System.Windows.Forms.KeyEventHandler(this.Sc_ProcExchListReport_KeyUp);
            this.KeyDown += new System.Windows.Forms.KeyEventHandler(this.Sc_ProcExchListReport_KeyDown);
            this.Tool.ResumeLayout(false);
            this.Tool.PerformLayout();
            this.pPic.ResumeLayout(false);
            this.pPic.PerformLayout();
            ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.grdMain)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.grdSum)).EndInit();
            this.ResumeLayout(false);
        }
        #endregion
        public System.Windows.Forms.Timer timer1;
        private System.Windows.Forms.ToolStrip Tool;
        private System.Windows.Forms.ToolStripButton yl;
        private System.Windows.Forms.ToolStripSeparator toolStripSeparator4;
        private System.Windows.Forms.ToolStripButton dy;
        private System.Windows.Forms.ToolStripButton view;
        private System.Windows.Forms.ToolStripSeparator toolStripSeparator2;
        private System.Windows.Forms.ToolStripButton cx;
        private System.Windows.Forms.ToolStripSeparator toolStripSeparator1;
        private System.Windows.Forms.ToolStripButton tc;
        private System.Windows.Forms.ToolStripSeparator toolStripSeparator3;
        private System.Windows.Forms.ToolStripSeparator toolStripSeparator8;
        private System.Windows.Forms.ToolStripButton mrlk;
        private System.Windows.Forms.ToolStripSeparator toolStripSeparator7;
        private System.Windows.Forms.ToolStripButton bclk;
        private System.Windows.Forms.ToolStripSeparator toolStripSeparator9;
        private System.Windows.Forms.Panel pPic;
        private System.Windows.Forms.Label lblCaption;
        private System.Windows.Forms.DateTimePicker dtpHEDate;
        private System.Windows.Forms.Label label3;
        private System.Windows.Forms.DateTimePicker dtpHBDate;
        private System.Windows.Forms.Label label4;
        private System.Windows.Forms.Timer timer2;
        private System.Windows.Forms.DataGridView grdMain;
        private System.Windows.Forms.DataGridView grdSum;
        private System.Windows.Forms.Button cmdHEDeptID;
        private System.Windows.Forms.Button cmdHBDeptID;
        private System.Windows.Forms.Label label6;
        public System.Windows.Forms.TextBox txtHEDeptID;
        public System.Windows.Forms.TextBox txtHBDeptID;
        private System.Windows.Forms.Label label1;
        private System.Windows.Forms.DataGridView dataGridView1;
        private System.Windows.Forms.ToolStripDropDownButton toolStripDropDownButton1;
        private System.Windows.Forms.ToolStripMenuItem eXCELToolStripMenuItem;
        private System.Windows.Forms.ToolStripMenuItem cSVToolStripMenuItem;
    }
}
WorkM/±¨±í·ÖÎö/Sc_WareHouseReport.cs
New file
@@ -0,0 +1,342 @@
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Runtime.InteropServices;
using gregn6Lib;
using DBUtility;
using SQLHelper;
namespace WorkM
{
    public partial class Sc_WareHouseReport : Form
    {
        public Sc_WareHouseReport()
        {
            InitializeComponent();
        }
        public string ModName = "";
        public string ModCaption = "超产报表";
        Pub_Class.ClsGridListSum oSumGrid = new Pub_Class.ClsGridListSum();
        #region å›ºå®šä»£ç 
        private void initGrid()
        {
            DBUtility.Xt_BaseBillFun.initGridRpt(grdMain, this.Name);
        }
        //得到对应列
        private Int32 Fun_GetCol(string sCol)
        {
            return DBUtility.Xt_BaseBillFun.Fun_GetCol(sCol, grdMain);
        }
        private void tc_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        private void TotalAll()
        {
            if (grdMain.Rows.Count > 0 && grdMain.ColumnCount > 0)
            {
                oSumGrid.SetGridsum();
                oSumGrid.TotalAll();
            }
        }
        //Sc_ProcExchListReportDlg oDlg = new Sc_ProcExchListReportDlg();
        private void cx_Click(object sender, EventArgs e)
        {
            //oDlg.ShowDialog();
            //if (oDlg.IsOk == 1)
            //{
            timer1.Enabled = true;
            //}
        }
        //设置报表名称
        private void SetFormCaption()
        {
            this.Text = ModCaption;
            lblCaption.Text = this.Text;
            initGrid();//网格标题初始化
            initHeadCaption();//表头初始化
        }
        private void Frm_EasyReport_Load(object sender, EventArgs e)
        {
            SetFormCaption();
            oSumGrid.ogrdMain = grdMain;  //初始化 new
            oSumGrid.oGridsum = grdSum;
        }
        private void timer1_Tick(object sender, EventArgs e)
        {
            timer1.Enabled = false;
            if (Fun_AllowQuery())
            {
                initGrid();
                Xt_Wait oFrm = new Xt_Wait();
                oFrm.Show();
                System.Windows.Forms.Application.DoEvents();
                Display();
                System.Windows.Forms.Application.DoEvents();
                oFrm.Close();
                oFrm.Dispose();
            }
        }
        private void Sc_ProcExchListReport_KeyUp(object sender, KeyEventArgs e)
        {
            if (e.KeyValue == 13)
                timer1.Enabled = true;
        }
        private void mrlk_Click(object sender, EventArgs e)
        {
            DBUtility.Xt_BaseBillFun.DefaultGridView(grdMain, this.Name);
        }
        private void bclk_Click(object sender, EventArgs e)
        {
            //保存列宽
            DBUtility.Xt_BaseBillFun.SaveGrid(grdMain, this.Name);
        }
        //打印
        private void dy_Click(object sender, EventArgs e)
        {
            Sub_SetReport();
            Report.Print(true);
        }
        //预览
        private void view_Click(object sender, EventArgs e)
        {
            Sub_SetReport();
            Report.PrintPreview(true);
        }
        #endregion
        #region ç•Œé¢å¤„理
        //初始化表头显示
        private void initHeadCaption()
        {
            //dtpHBDate.Value = DateTime.Today;
            //dtpHEDate.Value = DateTime.Today;
        }
        private bool Fun_AllowQuery()//审核查询条件
        {
            //if (txtHBDeptID.Text.Trim().Length == 0)
            //{
            //    MessageBox.Show(this, "请选择开始部门!", "提示");
            //    return false;
            //}
            return true;
        }
        private void Display()
        {
            ClsCN SubCn = new ClsCN();
            DataSet DSet;
            DataSet DsHead;
            DataSet DsQty;
            int BCol = 7;
            long HDeptID = 0;
            long HMaterID = 0;
            long HEmpID = 0;
            long HProcID = 0;
            //显示报表头 æ ‡é¢˜
            //停止GRID刷新 åŠ å¿«é€Ÿåº¦
            //过滤条件Dlg
            //string sDlgWhere = "";
            //sDlgWhere = sDlgWhere + ",'" + txtHBDeptID.Text.Trim() + "'";
            //if (sDlgWhere.Trim().Length > 0)
            //{
            //    sDlgWhere = sDlgWhere.Substring(1, sDlgWhere.Length - 1);
            //}
            //
            DSet = SubCn.RunProcReturn("exec h_p_CCBB " , "Gy_Czygl");
            //生成首行标题
            if (DSet == null)
            {
                MessageBox.Show("没有返回任何结果,尝试再次查询!" + DBUtility.ClsPub.sExeReturnInfo);
                return;
            }
            //
            grdMain.DataSource = DSet.Tables[0].DefaultView;
            //获取动态列 ï¼ˆç‰©æ–™ä¿¡æ¯ï¼‰
            //DsHead = SubCn.RunProcReturn("exec h_p_Sc_GetProcExchReportHead " + sDlgWhere, "Gy_Czygl");
            //for (int a = 0; a < DsHead.Tables[0].Rows.Count; a++)
            //{
            //    if (ClsPub.isLong(DsHead.Tables[0].Rows[a]["HMaterID"]) != 0)
            //    {
            //        grdMain.Columns.Add(ClsPub.isStrNull(DsHead.Tables[0].Rows[a]["HMaterID"]), ClsPub.isStrNull(DsHead.Tables[0].Rows[a]["HName"]));
            //        grdMain.Columns[BCol].Tag = ClsPub.isLong(DsHead.Tables[0].Rows[a]["HMaterID"]);
            //        BCol = BCol + 1;
            //    }
            //}
            BCol = 7;
            //获取动态内容  ï¼ˆæ•°é‡ä¿¡æ¯ï¼‰
            for (int row = 0; row <= grdMain.RowCount - 1; row++)
            {
                for (int col = BCol; col <= grdMain.ColumnCount - 1; col++)
                {
                    //HDeptID = DBUtility.ClsPub.isLong(grdMain.Rows[row].Cells[Fun_GetCol("HDeptID")].Value);
                    //HMaterID = DBUtility.ClsPub.isLong(grdMain.Columns[col].Tag);
                    //HEmpID = DBUtility.ClsPub.isLong(grdMain.Rows[row].Cells[Fun_GetCol("HEmpID")].Value);
                    //HProcID = DBUtility.ClsPub.isLong(grdMain.Rows[row].Cells[Fun_GetCol("HProcID")].Value);
                    DsQty = SubCn.RunProcReturn("exec h_p_CCBB", "Gy_Czygl");
                    if (DsQty != null && DsQty.Tables[0].Rows.Count > 0)
                    {
                        grdMain.Rows[row].Cells[col].Value = DBUtility.ClsPub.isDoule(DsQty.Tables[0].Rows[0]["HQty"], 2);
                    }
                }
            }
            //设置合计列
            string sTotalCol = "";
            sTotalCol = DBUtility.Gy_BaseFun.GetTotalCols(DSet);
            string[] sT;
            sT = sTotalCol.Split(Convert.ToChar(","));
            oSumGrid.BuildTotalCols(sT);
            //
            DBUtility.Xt_BaseBillFun.DisplayGrid(grdMain, this.Name, "是", 0);
            //
            DBUtility.Xt_BaseBillFun.GetGrid(grdMain, this.Name);
            Total();
        }
        #endregion
        #region æ‰“印设置
        //打印设置
        GridppReport Report;
        //设置打印模版路径
        private void Sub_SetReport()
        {
            Report = new GridppReport();
            Report.LoadFromFile(ClsPub.AppPath + @"\Report\应收款明细表.grf");  //here .
            Report.BeforePostRecord += new _IGridppReportEvents_BeforePostRecordEventHandler(ReportBeforePostRecord);
            Report.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(ReportFetchRecordByDataTable);
        }
        //填入单据表头信息
        private void ReportBeforePostRecord()//your report?kao
        {
            //Report.FieldByName("HDateItemID").AsString = lblHDateItemID.Text;
            //Report.FieldByName("CusNumber").AsString = lblHCusNumber.Text;
            //Report.FieldByName("CusName").AsString = lblHCusName.Text;
            //Report.FieldByName("BeginBalance").AsString = lblHBeginBalance.Text;
        }
        //填入单据明细信息
        private void ReportFetchRecordByDataTable()
        {
            //Utility.FillRecordToReport(Report, grdMain, false);
        }
        #endregion
        #region æ•°æ®å¯¼å‡º
        private void yc_Click(object sender, EventArgs e)
        {
            //DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            //DBUtility.Gy_BaseFun.Data2Excel(this.Text, grdMain, this.Name);
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
        }
        #endregion
        private void timer2_Tick(object sender, EventArgs e)
        {
            timer2.Enabled = false;
            //oDlg.ShowDialog();
            //if (oDlg.IsOk == 1)
            //{
            timer1.Enabled = true;
            //}
        }
        private void Total()
        {
            if (grdMain.Rows.Count > 0 && grdMain.ColumnCount > 0)
            {
                oSumGrid.SetGridsum();
                oSumGrid.Total();
            }
        }
        private void grdMain_CellMouseUp(object sender, DataGridViewCellMouseEventArgs e)
        {
            Total();
        }
        private void grdMain_ColumnWidthChanged(object sender, DataGridViewColumnEventArgs e)
        {
            Total();
        }
        private void grdMain_Paint(object sender, PaintEventArgs e)
        {
            DBUtility.Xt_BaseBillFun.GraphicsGrid(grdMain);
        }
        private void cmdHBDeptID_Click(object sender, EventArgs e)
        {
            BLL.ClsBaseSelect.SetTextByDept(txtHBDeptID, true);
            if (txtHEDeptID.Text.Trim() == "")
            {
                txtHEDeptID.Text = txtHBDeptID.Text;
            }
        }
        private void cmdHEDeptID_Click(object sender, EventArgs e)
        {
            BLL.ClsBaseSelect.SetTextByDept(txtHEDeptID, true);
        }
        private void yc_Click_1(object sender, EventArgs e)
        {
            BLL.Gy_GridView_Hide oHide = new BLL.Gy_GridView_Hide();
            oHide.KeyItem = this.Name;
            oHide.oGrd = grdMain;
            oHide.ShowDialog();
            //
            DBUtility.ClsPub.HideGridView(grdMain, Name, DBUtility.ClsPub.AppPath);//设置隐藏列
        }
        private void Sc_ProcExchListReport_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.F7)
            {
                TotalAll();
            }
        }
        private void eXCELToolStripMenuItem_Click(object sender, EventArgs e)
        {
            //DBUtility.Gy_BaseFun.Data2Excel(this.Text, grdMain, this.Name);
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
        }
        private void cSVToolStripMenuItem_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataGridViewToExcel2(grdMain, this.Text, this.Text);
        }
    }
}
WorkM/±¨±í·ÖÎö/Sc_WareHouseReport.resx
New file
@@ -0,0 +1,129 @@
<?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>
  <metadata name="timer1.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
    <value>17, 17</value>
  </metadata>
  <metadata name="Tool.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
    <value>122, 17</value>
  </metadata>
  <metadata name="timer2.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
    <value>211, 17</value>
  </metadata>
</root>
WorkM/±¨±í·ÖÎö/Sc_WorkShopReport.Designer.cs
New file
@@ -0,0 +1,532 @@
namespace WorkM
{
    partial class Sc_WorkShopReport
    {
        /// <summary>
        /// å¿…需的设计器变量。
        /// </summary>
        private System.ComponentModel.IContainer components = null;
        /// <summary>
        /// æ¸…理所有正在使用的资源。
        /// </summary>
        /// <param name="disposing">如果应释放托管资源,为 true;否则为 false。</param>
        protected override void Dispose(bool disposing)
        {
            if (disposing && (components != null))
            {
                components.Dispose();
            }
            base.Dispose(disposing);
        }
        #region Windows çª—体设计器生成的代码
        /// <summary>
        /// è®¾è®¡å™¨æ”¯æŒæ‰€éœ€çš„æ–¹æ³• - ä¸è¦
        /// ä½¿ç”¨ä»£ç ç¼–辑器修改此方法的内容。
        /// </summary>
        private void InitializeComponent()
        {
            this.components = new System.ComponentModel.Container();
            System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Sc_ProcExchListReport));
            this.timer1 = new System.Windows.Forms.Timer(this.components);
            this.Tool = new System.Windows.Forms.ToolStrip();
            this.yl = new System.Windows.Forms.ToolStripButton();
            this.toolStripSeparator4 = new System.Windows.Forms.ToolStripSeparator();
            this.dy = new System.Windows.Forms.ToolStripButton();
            this.view = new System.Windows.Forms.ToolStripButton();
            this.toolStripSeparator2 = new System.Windows.Forms.ToolStripSeparator();
            this.cx = new System.Windows.Forms.ToolStripButton();
            this.toolStripSeparator1 = new System.Windows.Forms.ToolStripSeparator();
            this.tc = new System.Windows.Forms.ToolStripButton();
            this.toolStripSeparator3 = new System.Windows.Forms.ToolStripSeparator();
            this.toolStripSeparator8 = new System.Windows.Forms.ToolStripSeparator();
            this.mrlk = new System.Windows.Forms.ToolStripButton();
            this.toolStripSeparator7 = new System.Windows.Forms.ToolStripSeparator();
            this.bclk = new System.Windows.Forms.ToolStripButton();
            this.toolStripSeparator9 = new System.Windows.Forms.ToolStripSeparator();
            this.pPic = new System.Windows.Forms.Panel();
            this.dataGridView1 = new System.Windows.Forms.DataGridView();
            //this.cmdHEDeptID = new System.Windows.Forms.Button();
            this.cmdHBDeptID = new System.Windows.Forms.Button();
            //this.label6 = new System.Windows.Forms.Label();
            //this.txtHEDeptID = new System.Windows.Forms.TextBox();
            this.txtHBDeptID = new System.Windows.Forms.TextBox();
            this.label1 = new System.Windows.Forms.Label();
            //this.dtpHEDate = new System.Windows.Forms.DateTimePicker();
            //this.label3 = new System.Windows.Forms.Label();
            //this.dtpHBDate = new System.Windows.Forms.DateTimePicker();
            //this.label4 = new System.Windows.Forms.Label();
            this.lblCaption = new System.Windows.Forms.Label();
            this.timer2 = new System.Windows.Forms.Timer(this.components);
            this.grdMain = new System.Windows.Forms.DataGridView();
            this.grdSum = new System.Windows.Forms.DataGridView();
            this.toolStripDropDownButton1 = new System.Windows.Forms.ToolStripDropDownButton();
            this.eXCELToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
            this.cSVToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
            this.Tool.SuspendLayout();
            this.pPic.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.grdMain)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.grdSum)).BeginInit();
            this.SuspendLayout();
            //
            // timer1
            //
            this.timer1.Tick += new System.EventHandler(this.timer1_Tick);
            //
            // Tool
            //
            this.Tool.AutoSize = false;
            this.Tool.BackColor = System.Drawing.SystemColors.Control;
            this.Tool.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("Tool.BackgroundImage")));
            this.Tool.BackgroundImageLayout = System.Windows.Forms.ImageLayout.Stretch;
            this.Tool.ImageScalingSize = new System.Drawing.Size(22, 22);
            this.Tool.Items.AddRange(new System.Windows.Forms.ToolStripItem[] {
            this.toolStripDropDownButton1,
            this.yl,
            this.toolStripSeparator4,
            this.dy,
            this.view,
            this.toolStripSeparator2,
            this.cx,
            this.toolStripSeparator1,
            this.tc,
            this.toolStripSeparator3,
            this.toolStripSeparator8,
            this.mrlk,
            this.toolStripSeparator7,
            this.bclk,
            this.toolStripSeparator9});
            this.Tool.Location = new System.Drawing.Point(0, 0);
            this.Tool.Name = "Tool";
            this.Tool.Padding = new System.Windows.Forms.Padding(0);
            this.Tool.Size = new System.Drawing.Size(1257, 59);
            this.Tool.Stretch = true;
            this.Tool.TabIndex = 16;
            this.Tool.Text = "toolStrip1";
            //
            // yl
            //
            this.yl.AutoSize = false;
            this.yl.Image = ((System.Drawing.Image)(resources.GetObject("yl.Image")));
            this.yl.ImageAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.yl.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
            this.yl.ImageTransparentColor = System.Drawing.Color.Magenta;
            this.yl.Name = "yl";
            this.yl.Size = new System.Drawing.Size(35, 42);
            this.yl.Text = "引出";
            this.yl.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.yl.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            this.yl.Visible = false;
            this.yl.Click += new System.EventHandler(this.yc_Click);
            //
            // toolStripSeparator4
            //
            this.toolStripSeparator4.Name = "toolStripSeparator4";
            this.toolStripSeparator4.Size = new System.Drawing.Size(6, 59);
            this.toolStripSeparator4.Visible = false;
            //
            // dy
            //
            this.dy.AutoSize = false;
            this.dy.Image = ((System.Drawing.Image)(resources.GetObject("dy.Image")));
            this.dy.ImageAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.dy.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
            this.dy.ImageTransparentColor = System.Drawing.Color.Magenta;
            this.dy.Name = "dy";
            this.dy.Size = new System.Drawing.Size(35, 42);
            this.dy.Text = "打印";
            this.dy.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.dy.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            this.dy.Visible = false;
            this.dy.Click += new System.EventHandler(this.dy_Click);
            //
            // view
            //
            this.view.AutoSize = false;
            this.view.Image = ((System.Drawing.Image)(resources.GetObject("view.Image")));
            this.view.ImageAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.view.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
            this.view.ImageTransparentColor = System.Drawing.Color.Magenta;
            this.view.Name = "view";
            this.view.Size = new System.Drawing.Size(35, 42);
            this.view.Text = "预览";
            this.view.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.view.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            this.view.Visible = false;
            this.view.Click += new System.EventHandler(this.view_Click);
            //
            // toolStripSeparator2
            //
            this.toolStripSeparator2.Name = "toolStripSeparator2";
            this.toolStripSeparator2.Size = new System.Drawing.Size(6, 59);
            //
            // cx
            //
            this.cx.AutoSize = false;
            this.cx.Image = ((System.Drawing.Image)(resources.GetObject("cx.Image")));
            this.cx.ImageAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.cx.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
            this.cx.ImageTransparentColor = System.Drawing.Color.White;
            this.cx.Name = "cx";
            this.cx.Size = new System.Drawing.Size(35, 42);
            this.cx.Text = "查询";
            this.cx.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.cx.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            this.cx.Click += new System.EventHandler(this.cx_Click);
            //
            // toolStripSeparator1
            //
            this.toolStripSeparator1.Name = "toolStripSeparator1";
            this.toolStripSeparator1.Size = new System.Drawing.Size(6, 59);
            //
            // tc
            //
            this.tc.AutoSize = false;
            this.tc.Image = ((System.Drawing.Image)(resources.GetObject("tc.Image")));
            this.tc.ImageAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.tc.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
            this.tc.ImageTransparentColor = System.Drawing.Color.White;
            this.tc.Name = "tc";
            this.tc.Size = new System.Drawing.Size(35, 42);
            this.tc.Text = "退出";
            this.tc.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.tc.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            this.tc.Click += new System.EventHandler(this.tc_Click);
            //
            // toolStripSeparator3
            //
            this.toolStripSeparator3.Name = "toolStripSeparator3";
            this.toolStripSeparator3.Size = new System.Drawing.Size(6, 59);
            //
            // toolStripSeparator8
            //
            this.toolStripSeparator8.Alignment = System.Windows.Forms.ToolStripItemAlignment.Right;
            this.toolStripSeparator8.Name = "toolStripSeparator8";
            this.toolStripSeparator8.Size = new System.Drawing.Size(6, 59);
            //
            // mrlk
            //
            this.mrlk.Alignment = System.Windows.Forms.ToolStripItemAlignment.Right;
            this.mrlk.Image = ((System.Drawing.Image)(resources.GetObject("mrlk.Image")));
            this.mrlk.ImageAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.mrlk.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
            this.mrlk.ImageTransparentColor = System.Drawing.Color.White;
            this.mrlk.Name = "mrlk";
            this.mrlk.Size = new System.Drawing.Size(73, 56);
            this.mrlk.Text = "默认列宽";
            this.mrlk.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.mrlk.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            this.mrlk.Click += new System.EventHandler(this.mrlk_Click);
            //
            // toolStripSeparator7
            //
            this.toolStripSeparator7.Alignment = System.Windows.Forms.ToolStripItemAlignment.Right;
            this.toolStripSeparator7.Name = "toolStripSeparator7";
            this.toolStripSeparator7.Size = new System.Drawing.Size(6, 59);
            //
            // bclk
            //
            this.bclk.Alignment = System.Windows.Forms.ToolStripItemAlignment.Right;
            this.bclk.Image = ((System.Drawing.Image)(resources.GetObject("bclk.Image")));
            this.bclk.ImageAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.bclk.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
            this.bclk.ImageTransparentColor = System.Drawing.Color.White;
            this.bclk.Name = "bclk";
            this.bclk.Size = new System.Drawing.Size(73, 56);
            this.bclk.Text = "保存列宽";
            this.bclk.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.bclk.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            this.bclk.Click += new System.EventHandler(this.bclk_Click);
            //
            // toolStripSeparator9
            //
            this.toolStripSeparator9.Alignment = System.Windows.Forms.ToolStripItemAlignment.Right;
            this.toolStripSeparator9.Name = "toolStripSeparator9";
            this.toolStripSeparator9.Size = new System.Drawing.Size(6, 59);
            //
            // pPic
            //
            this.pPic.BackColor = System.Drawing.Color.White;
            this.pPic.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("pPic.BackgroundImage")));
            this.pPic.BackgroundImageLayout = System.Windows.Forms.ImageLayout.None;
            this.pPic.Controls.Add(this.dataGridView1);
            //this.pPic.Controls.Add(this.cmdHEDeptID);
            this.pPic.Controls.Add(this.cmdHBDeptID);
            //this.pPic.Controls.Add(this.label6);
            //this.pPic.Controls.Add(this.txtHEDeptID);
            this.pPic.Controls.Add(this.txtHBDeptID);
            this.pPic.Controls.Add(this.label1);
            //this.pPic.Controls.Add(this.dtpHEDate);
            //this.pPic.Controls.Add(this.label3);
            //this.pPic.Controls.Add(this.dtpHBDate);
            //this.pPic.Controls.Add(this.label4);
            this.pPic.Controls.Add(this.lblCaption);
            this.pPic.Dock = System.Windows.Forms.DockStyle.Top;
            this.pPic.Location = new System.Drawing.Point(0, 59);
            this.pPic.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            this.pPic.Name = "pPic";
            this.pPic.Size = new System.Drawing.Size(1257, 69);
            this.pPic.TabIndex = 17;
            //
            // dataGridView1
            //
            this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
            this.dataGridView1.Location = new System.Drawing.Point(1217, 6);
            this.dataGridView1.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            this.dataGridView1.Name = "dataGridView1";
            this.dataGridView1.RowTemplate.Height = 23;
            this.dataGridView1.Size = new System.Drawing.Size(36, 19);
            this.dataGridView1.TabIndex = 68;
            this.dataGridView1.Visible = false;
            ////
            //// cmdHEDeptID
            ////
            //this.cmdHEDeptID.Image = ((System.Drawing.Image)(resources.GetObject("cmdHEDeptID.Image")));
            //this.cmdHEDeptID.ImageAlign = System.Drawing.ContentAlignment.TopRight;
            //this.cmdHEDeptID.Location = new System.Drawing.Point(733, 32);
            //this.cmdHEDeptID.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            //this.cmdHEDeptID.Name = "cmdHEDeptID";
            //this.cmdHEDeptID.Size = new System.Drawing.Size(29, 28);
            //this.cmdHEDeptID.TabIndex = 67;
            //this.cmdHEDeptID.UseVisualStyleBackColor = true;
            //this.cmdHEDeptID.Click += new System.EventHandler(this.cmdHEDeptID_Click);
            ////
            // cmdHBDeptID
            //
            this.cmdHBDeptID.Image = ((System.Drawing.Image)(resources.GetObject("cmdHBDeptID.Image")));
            this.cmdHBDeptID.ImageAlign = System.Drawing.ContentAlignment.TopRight;
            this.cmdHBDeptID.Location = new System.Drawing.Point(733, 4);
            this.cmdHBDeptID.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            this.cmdHBDeptID.Name = "cmdHBDeptID";
            this.cmdHBDeptID.Size = new System.Drawing.Size(29, 28);
            this.cmdHBDeptID.TabIndex = 66;
            this.cmdHBDeptID.UseVisualStyleBackColor = true;
            this.cmdHBDeptID.Click += new System.EventHandler(this.cmdHBDeptID_Click);
            ////
            //// label6
            ////
            //this.label6.AutoSize = true;
            //this.label6.BackColor = System.Drawing.Color.Transparent;
            //this.label6.Location = new System.Drawing.Point(543, 39);
            //this.label6.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
            //this.label6.Name = "label6";
            //this.label6.Size = new System.Drawing.Size(22, 15);
            //this.label6.TabIndex = 65;
            //this.label6.Text = "至";
            ////
            //// txtHEDeptID
            ////
            //this.txtHEDeptID.Location = new System.Drawing.Point(579, 34);
            //this.txtHEDeptID.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            //this.txtHEDeptID.Name = "txtHEDeptID";
            //this.txtHEDeptID.Size = new System.Drawing.Size(160, 25);
            //this.txtHEDeptID.TabIndex = 64;
            ////
            // txtHBDeptID
            //
            this.txtHBDeptID.Location = new System.Drawing.Point(579, 5);
            this.txtHBDeptID.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            this.txtHBDeptID.Name = "txtHBDeptID";
            this.txtHBDeptID.Size = new System.Drawing.Size(160, 25);
            this.txtHBDeptID.TabIndex = 63;
            //
            // label1
            //
            this.label1.AutoSize = true;
            this.label1.BackColor = System.Drawing.Color.Transparent;
            this.label1.Location = new System.Drawing.Point(512, 10);
            this.label1.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
            this.label1.Name = "label1";
            this.label1.Size = new System.Drawing.Size(61, 15);
            this.label1.TabIndex = 62;
            this.label1.Text = "部   é—¨";
            ////
            //// dtpHEDate
            ////
            //this.dtpHEDate.Format = System.Windows.Forms.DateTimePickerFormat.Short;
            //this.dtpHEDate.Location = new System.Drawing.Point(352, 35);
            //this.dtpHEDate.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            //this.dtpHEDate.Name = "dtpHEDate";
            //this.dtpHEDate.Size = new System.Drawing.Size(147, 25);
            //this.dtpHEDate.TabIndex = 61;
            ////
            //// label3
            ////
            //this.label3.AutoSize = true;
            //this.label3.BackColor = System.Drawing.Color.Transparent;
            //this.label3.Location = new System.Drawing.Point(276, 39);
            //this.label3.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
            //this.label3.Name = "label3";
            //this.label3.Size = new System.Drawing.Size(67, 15);
            //this.label3.TabIndex = 60;
            //this.label3.Text = "结束日期";
            ////
            //// dtpHBDate
            ////
            //this.dtpHBDate.Format = System.Windows.Forms.DateTimePickerFormat.Short;
            //this.dtpHBDate.Location = new System.Drawing.Point(352, 6);
            //this.dtpHBDate.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            //this.dtpHBDate.Name = "dtpHBDate";
            //this.dtpHBDate.Size = new System.Drawing.Size(147, 25);
            //this.dtpHBDate.TabIndex = 59;
            ////
            //// label4
            ////
            //this.label4.AutoSize = true;
            //this.label4.BackColor = System.Drawing.Color.Transparent;
            //this.label4.Location = new System.Drawing.Point(276, 10);
            //this.label4.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
            //this.label4.Name = "label4";
            //this.label4.Size = new System.Drawing.Size(67, 15);
            //this.label4.TabIndex = 58;
            //this.label4.Text = "开始日期";
            //
            // lblCaption
            //
            this.lblCaption.AutoSize = true;
            this.lblCaption.BackColor = System.Drawing.Color.Transparent;
            this.lblCaption.Cursor = System.Windows.Forms.Cursors.No;
            this.lblCaption.Font = new System.Drawing.Font("宋体", 14.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
            this.lblCaption.Location = new System.Drawing.Point(16, 20);
            this.lblCaption.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
            this.lblCaption.Name = "lblCaption";
            this.lblCaption.Size = new System.Drawing.Size(179, 24);
            this.lblCaption.TabIndex = 4;
            this.lblCaption.Text = "ReportTemplet";
            //
            // timer2
            //
            this.timer2.Tick += new System.EventHandler(this.timer2_Tick);
            //
            // grdMain
            //
            this.grdMain.AllowUserToAddRows = false;
            this.grdMain.AllowUserToDeleteRows = false;
            this.grdMain.BackgroundColor = System.Drawing.Color.White;
            this.grdMain.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
            this.grdMain.Dock = System.Windows.Forms.DockStyle.Fill;
            this.grdMain.Location = new System.Drawing.Point(0, 128);
            this.grdMain.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            this.grdMain.Name = "grdMain";
            this.grdMain.ReadOnly = true;
            this.grdMain.RowTemplate.Height = 23;
            this.grdMain.Size = new System.Drawing.Size(1257, 414);
            this.grdMain.TabIndex = 54;
            this.grdMain.CellMouseUp += new System.Windows.Forms.DataGridViewCellMouseEventHandler(this.grdMain_CellMouseUp);
            this.grdMain.Paint += new System.Windows.Forms.PaintEventHandler(this.grdMain_Paint);
            this.grdMain.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler(this.grdMain_ColumnWidthChanged);
            //
            // grdSum
            //
            this.grdSum.AllowUserToAddRows = false;
            this.grdSum.AllowUserToDeleteRows = false;
            this.grdSum.BackgroundColor = System.Drawing.SystemColors.Control;
            this.grdSum.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
            this.grdSum.Dock = System.Windows.Forms.DockStyle.Bottom;
            this.grdSum.Location = new System.Drawing.Point(0, 542);
            this.grdSum.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            this.grdSum.Name = "grdSum";
            this.grdSum.ReadOnly = true;
            this.grdSum.RowTemplate.Height = 23;
            this.grdSum.ScrollBars = System.Windows.Forms.ScrollBars.None;
            this.grdSum.Size = new System.Drawing.Size(1257, 24);
            this.grdSum.TabIndex = 55;
            //
            // toolStripDropDownButton1
            //
            this.toolStripDropDownButton1.DropDownItems.AddRange(new System.Windows.Forms.ToolStripItem[] {
            this.eXCELToolStripMenuItem,
            this.cSVToolStripMenuItem});
            this.toolStripDropDownButton1.Image = ((System.Drawing.Image)(resources.GetObject("toolStripDropDownButton1.Image")));
            this.toolStripDropDownButton1.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
            this.toolStripDropDownButton1.ImageTransparentColor = System.Drawing.Color.Magenta;
            this.toolStripDropDownButton1.Name = "toolStripDropDownButton1";
            this.toolStripDropDownButton1.Size = new System.Drawing.Size(52, 56);
            this.toolStripDropDownButton1.Text = "引出";
            this.toolStripDropDownButton1.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.toolStripDropDownButton1.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            //
            // eXCELToolStripMenuItem
            //
            this.eXCELToolStripMenuItem.Name = "eXCELToolStripMenuItem";
            this.eXCELToolStripMenuItem.Size = new System.Drawing.Size(152, 24);
            this.eXCELToolStripMenuItem.Text = "EXCEL";
            this.eXCELToolStripMenuItem.Click += new System.EventHandler(this.eXCELToolStripMenuItem_Click);
            //
            // cSVToolStripMenuItem
            //
            this.cSVToolStripMenuItem.Name = "cSVToolStripMenuItem";
            this.cSVToolStripMenuItem.Size = new System.Drawing.Size(152, 24);
            this.cSVToolStripMenuItem.Text = "CSV";
            this.cSVToolStripMenuItem.Click += new System.EventHandler(this.cSVToolStripMenuItem_Click);
            //
            // Sc_ProcExchListReport
            //
            this.AutoScaleDimensions = new System.Drawing.SizeF(8F, 15F);
            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
            this.ClientSize = new System.Drawing.Size(1257, 566);
            this.Controls.Add(this.grdMain);
            this.Controls.Add(this.grdSum);
            this.Controls.Add(this.pPic);
            this.Controls.Add(this.Tool);
            this.KeyPreview = true;
            this.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            this.Name = "Sc_ProcExchListReport";
            this.Text = "ReportTemplet";
            this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
            this.Load += new System.EventHandler(this.Frm_EasyReport_Load);
            this.KeyUp += new System.Windows.Forms.KeyEventHandler(this.Sc_WorkShopReport_KeyUp);
            this.KeyDown += new System.Windows.Forms.KeyEventHandler(this.Sc_WorkShopReport_KeyDown);
            this.Tool.ResumeLayout(false);
            this.Tool.PerformLayout();
            this.pPic.ResumeLayout(false);
            this.pPic.PerformLayout();
            ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.grdMain)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.grdSum)).EndInit();
            this.ResumeLayout(false);
        }
        #endregion
        public System.Windows.Forms.Timer timer1;
        private System.Windows.Forms.ToolStrip Tool;
        private System.Windows.Forms.ToolStripButton yl;
        private System.Windows.Forms.ToolStripSeparator toolStripSeparator4;
        private System.Windows.Forms.ToolStripButton dy;
        private System.Windows.Forms.ToolStripButton view;
        private System.Windows.Forms.ToolStripSeparator toolStripSeparator2;
        private System.Windows.Forms.ToolStripButton cx;
        private System.Windows.Forms.ToolStripSeparator toolStripSeparator1;
        private System.Windows.Forms.ToolStripButton tc;
        private System.Windows.Forms.ToolStripSeparator toolStripSeparator3;
        private System.Windows.Forms.ToolStripSeparator toolStripSeparator8;
        private System.Windows.Forms.ToolStripButton mrlk;
        private System.Windows.Forms.ToolStripSeparator toolStripSeparator7;
        private System.Windows.Forms.ToolStripButton bclk;
        private System.Windows.Forms.ToolStripSeparator toolStripSeparator9;
        private System.Windows.Forms.Panel pPic;
        private System.Windows.Forms.Label lblCaption;
        private System.Windows.Forms.DateTimePicker dtpHEDate;
        private System.Windows.Forms.Label label3;
        private System.Windows.Forms.DateTimePicker dtpHBDate;
        private System.Windows.Forms.Label label4;
        private System.Windows.Forms.Timer timer2;
        private System.Windows.Forms.DataGridView grdMain;
        private System.Windows.Forms.DataGridView grdSum;
        private System.Windows.Forms.Button cmdHEDeptID;
        private System.Windows.Forms.Button cmdHBDeptID;
        private System.Windows.Forms.Label label6;
        public System.Windows.Forms.TextBox txtHEDeptID;
        public System.Windows.Forms.TextBox txtHBDeptID;
        private System.Windows.Forms.Label label1;
        private System.Windows.Forms.DataGridView dataGridView1;
        private System.Windows.Forms.ToolStripDropDownButton toolStripDropDownButton1;
        private System.Windows.Forms.ToolStripMenuItem eXCELToolStripMenuItem;
        private System.Windows.Forms.ToolStripMenuItem cSVToolStripMenuItem;
    }
}
WorkM/±¨±í·ÖÎö/Sc_WorkShopReport.cs
New file
@@ -0,0 +1,339 @@
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Runtime.InteropServices;
using gregn6Lib;
using DBUtility;
using SQLHelper;
namespace WorkM
{
    public partial class Sc_WorkShopReport : Form
    {
        public Sc_WorkShopReport()
        {
            InitializeComponent();
        }
        public string ModName = "";
        public string ModCaption = "车间报表";
        Pub_Class.ClsGridListSum oSumGrid = new Pub_Class.ClsGridListSum();
        #region å›ºå®šä»£ç 
        private void initGrid()
        {
            DBUtility.Xt_BaseBillFun.initGridRpt(grdMain, this.Name);
        }
        //得到对应列
        private Int32 Fun_GetCol(string sCol)
        {
            return DBUtility.Xt_BaseBillFun.Fun_GetCol(sCol, grdMain);
        }
        private void tc_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        private void TotalAll()
        {
            if (grdMain.Rows.Count > 0 && grdMain.ColumnCount > 0)
            {
                oSumGrid.SetGridsum();
                oSumGrid.TotalAll();
            }
        }
        //Sc_WorkShopReportDlg oDlg = new Sc_WorkShopReportDlg();
        private void cx_Click(object sender, EventArgs e)
        {
            //oDlg.ShowDialog();
            //if (oDlg.IsOk == 1)
            //{
            timer1.Enabled = true;
            //}
        }
        //设置报表名称
        private void SetFormCaption()
        {
            this.Text = ModCaption;
            lblCaption.Text = this.Text;
            initGrid();//网格标题初始化
            initHeadCaption();//表头初始化
        }
        private void Frm_EasyReport_Load(object sender, EventArgs e)
        {
            SetFormCaption();
            oSumGrid.ogrdMain = grdMain;  //初始化 new
            oSumGrid.oGridsum = grdSum;
        }
        private void timer1_Tick(object sender, EventArgs e)
        {
            timer1.Enabled = false;
            if (Fun_AllowQuery())
            {
                initGrid();
                Xt_Wait oFrm = new Xt_Wait();
                oFrm.Show();
                System.Windows.Forms.Application.DoEvents();
                Display();
                System.Windows.Forms.Application.DoEvents();
                oFrm.Close();
                oFrm.Dispose();
            }
        }
        private void Sc_WorkShopReport_KeyUp(object sender, KeyEventArgs e)
        {
            if (e.KeyValue == 13)
                timer1.Enabled = true;
        }
        private void mrlk_Click(object sender, EventArgs e)
        {
            DBUtility.Xt_BaseBillFun.DefaultGridView(grdMain, this.Name);
        }
        private void bclk_Click(object sender, EventArgs e)
        {
            //保存列宽
            DBUtility.Xt_BaseBillFun.SaveGrid(grdMain, this.Name);
        }
        //打印
        private void dy_Click(object sender, EventArgs e)
        {
            Sub_SetReport();
            Report.Print(true);
        }
        //预览
        private void view_Click(object sender, EventArgs e)
        {
            Sub_SetReport();
            Report.PrintPreview(true);
        }
        #endregion
        #region ç•Œé¢å¤„理
        //初始化表头显示
        private void initHeadCaption()
        {
            //dtpHBDate.Value = DateTime.Today;
            //dtpHEDate.Value = DateTime.Today;
        }
        private bool Fun_AllowQuery()//审核查询条件
        {
            //if (txtHBDeptID.Text.Trim().Length == 0)
            //{
            //    MessageBox.Show(this, "请选择开始部门!", "提示");
            //    return false;
            //}
            return true;
        }
        private void Display()
        {
            ClsCN SubCn = new ClsCN();
            DataSet DSet;
            DataSet DsHead;
            DataSet DsQty;
            int BCol = 7;
            long HDeptID = 0;
            long HMaterID = 0;
            long HEmpID = 0;
            long HProcID = 0;
            //显示报表头 æ ‡é¢˜
            //停止GRID刷新 åŠ å¿«é€Ÿåº¦
            //过滤条件Dlg
            string sDlgWhere = "";
            sDlgWhere = sDlgWhere + ",'" + txtHBDeptID.Tag + "'";
            if (sDlgWhere.Trim().Length > 0)
            {
                sDlgWhere = sDlgWhere.Substring(1, sDlgWhere.Length - 1);
            }
            //
            DSet = SubCn.RunProcReturn("exec h_p_CJKB" + sDlgWhere, "Gy_Czygl");
            //生成首行标题
            if (DSet == null)
            {
                MessageBox.Show("没有返回任何结果,尝试再次查询!" + DBUtility.ClsPub.sExeReturnInfo);
                return;
            }
            //
            grdMain.DataSource = DSet.Tables[0].DefaultView;
            //获取动态列 ï¼ˆç‰©æ–™ä¿¡æ¯ï¼‰
            //DsHead = SubCn.RunProcReturn("exec h_p_Sc_GetProcExchReportHead " + sDlgWhere, "Gy_Czygl");
            //for (int a = 0; a < DsHead.Tables[0].Rows.Count; a++)
            //{
            //    if (ClsPub.isLong(DsHead.Tables[0].Rows[a]["HMaterID"]) != 0)
            //    {
            //        grdMain.Columns.Add(ClsPub.isStrNull(DsHead.Tables[0].Rows[a]["HMaterID"]), ClsPub.isStrNull(DsHead.Tables[0].Rows[a]["HName"]));
            //        grdMain.Columns[BCol].Tag = ClsPub.isLong(DsHead.Tables[0].Rows[a]["HMaterID"]);
            //        BCol = BCol + 1;
            //    }
            //}
            BCol = 7;
            //获取动态内容  ï¼ˆæ•°é‡ä¿¡æ¯ï¼‰
            for (int row = 0; row <= grdMain.RowCount - 1; row++)
            {
                for (int col = BCol; col <= grdMain.ColumnCount - 1; col++)
                {
                    HDeptID = DBUtility.ClsPub.isLong(grdMain.Rows[row].Cells[Fun_GetCol("HDeptID")].Value);
                    DsQty = SubCn.RunProcReturn("exec h_p_CJKB '" +  HDeptID.ToString(), "Gy_Czygl");
                    if (DsQty != null && DsQty.Tables[0].Rows.Count > 0)
                    {
                        grdMain.Rows[row].Cells[col].Value = DBUtility.ClsPub.isDoule(DsQty.Tables[0].Rows[0]["HQty"], 2);
                    }
                }
            }
            //设置合计列
            string sTotalCol = "";
            sTotalCol = DBUtility.Gy_BaseFun.GetTotalCols(DSet);
            string[] sT;
            sT = sTotalCol.Split(Convert.ToChar(","));
            oSumGrid.BuildTotalCols(sT);
            //
            DBUtility.Xt_BaseBillFun.DisplayGrid(grdMain, this.Name, "是", 0);
            //
            DBUtility.Xt_BaseBillFun.GetGrid(grdMain, this.Name);
            Total();
        }
        #endregion
        #region æ‰“印设置
        //打印设置
        GridppReport Report;
        //设置打印模版路径
        private void Sub_SetReport()
        {
            Report = new GridppReport();
            Report.LoadFromFile(ClsPub.AppPath + @"\Report\应收款明细表.grf");  //here .
            Report.BeforePostRecord += new _IGridppReportEvents_BeforePostRecordEventHandler(ReportBeforePostRecord);
            Report.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(ReportFetchRecordByDataTable);
        }
        //填入单据表头信息
        private void ReportBeforePostRecord()//your report?kao
        {
            //Report.FieldByName("HDateItemID").AsString = lblHDateItemID.Text;
            //Report.FieldByName("CusNumber").AsString = lblHCusNumber.Text;
            //Report.FieldByName("CusName").AsString = lblHCusName.Text;
            //Report.FieldByName("BeginBalance").AsString = lblHBeginBalance.Text;
        }
        //填入单据明细信息
        private void ReportFetchRecordByDataTable()
        {
            //Utility.FillRecordToReport(Report, grdMain, false);
        }
        #endregion
        #region æ•°æ®å¯¼å‡º
        private void yc_Click(object sender, EventArgs e)
        {
            //DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            //DBUtility.Gy_BaseFun.Data2Excel(this.Text, grdMain, this.Name);
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
        }
        #endregion
        private void timer2_Tick(object sender, EventArgs e)
        {
            timer2.Enabled = false;
            //oDlg.ShowDialog();
            //if (oDlg.IsOk == 1)
            //{
            timer1.Enabled = true;
            //}
        }
        private void Total()
        {
            if (grdMain.Rows.Count > 0 && grdMain.ColumnCount > 0)
            {
                oSumGrid.SetGridsum();
                oSumGrid.Total();
            }
        }
        private void grdMain_CellMouseUp(object sender, DataGridViewCellMouseEventArgs e)
        {
            Total();
        }
        private void grdMain_ColumnWidthChanged(object sender, DataGridViewColumnEventArgs e)
        {
            Total();
        }
        private void grdMain_Paint(object sender, PaintEventArgs e)
        {
            DBUtility.Xt_BaseBillFun.GraphicsGrid(grdMain);
        }
        private void cmdHBDeptID_Click(object sender, EventArgs e)
        {
            BLL.ClsBaseSelect.SetTextByDept(txtHBDeptID, true);
            //if (txtHEDeptID.Text.Trim() == "")
            //{
            //    txtHEDeptID.Text = txtHBDeptID.Text;
            //}
        }
        private void cmdHEDeptID_Click(object sender, EventArgs e)
        {
            BLL.ClsBaseSelect.SetTextByDept(txtHEDeptID, true);
        }
        private void yc_Click_1(object sender, EventArgs e)
        {
            BLL.Gy_GridView_Hide oHide = new BLL.Gy_GridView_Hide();
            oHide.KeyItem = this.Name;
            oHide.oGrd = grdMain;
            oHide.ShowDialog();
            //
            DBUtility.ClsPub.HideGridView(grdMain, Name, DBUtility.ClsPub.AppPath);//设置隐藏列
        }
        private void Sc_WorkShopReport_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.F7)
            {
                TotalAll();
            }
        }
        private void eXCELToolStripMenuItem_Click(object sender, EventArgs e)
        {
            //DBUtility.Gy_BaseFun.Data2Excel(this.Text, grdMain, this.Name);
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
        }
        private void cSVToolStripMenuItem_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataGridViewToExcel2(grdMain, this.Text, this.Text);
        }
    }
}
WorkM/±¨±í·ÖÎö/Sc_WorkShopReport.resx
New file
@@ -0,0 +1,129 @@
<?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>
  <metadata name="timer1.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
    <value>17, 17</value>
  </metadata>
  <metadata name="Tool.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
    <value>122, 17</value>
  </metadata>
  <metadata name="timer2.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
    <value>211, 17</value>
  </metadata>
</root>