奥邦（新增车间报表，超产报表）

yusijie

2022-11-15 ca964154bcc4a8a7a617320b3c9355e0c464ad39

奥邦（新增车间报表，超产报表）

 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>