From ca964154bcc4a8a7a617320b3c9355e0c464ad39 Mon Sep 17 00:00:00 2001
From: yusijie <ysj@hz-kingdee.com>
Date: 星期二, 15 十一月 2022 15:09:49 +0800
Subject: [PATCH] 奥邦（新增车间报表，超产报表）
---
BLL/系统公用CLS/ClsBaseSelect.cs | 2
WorkM/WorkM.csproj | 18
WorkM/报表分析/Sc_WareHouseReport.Designer.cs | 532 +++++++++++++++
WorkM/报表分析/Sc_WorkShopReport.cs | 339 +++++++++
LMES/ClsShowMod.cs | 14
WorkM/报表分析/Sc_WorkShopReport.resx | 129 +++
WorkM/报表分析/Sc_WorkShopReport.Designer.cs | 532 +++++++++++++++
WorkM/WorkM.csproj.user | 1
WorkM/报表分析/Sc_WareHouseReport.resx | 129 +++
WorkM/报表分析/Sc_WareHouseReport.cs | 342 ++++++++++
10 files changed, 2,037 insertions(+), 1 deletions(-)
diff --git "a/BLL/\347\263\273\347\273\237\345\205\254\347\224\250CLS/ClsBaseSelect.cs" "b/BLL/\347\263\273\347\273\237\345\205\254\347\224\250CLS/ClsBaseSelect.cs"
index f25d45c..97e802f 100644
--- "a/BLL/\347\263\273\347\273\237\345\205\254\347\224\250CLS/ClsBaseSelect.cs"
+++ "b/BLL/\347\263\273\347\273\237\345\205\254\347\224\250CLS/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
diff --git a/LMES/ClsShowMod.cs b/LMES/ClsShowMod.cs
index 8c48f25..a51c8aa 100644
--- a/LMES/ClsShowMod.cs
+++ b/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();
diff --git a/WorkM/WorkM.csproj b/WorkM/WorkM.csproj
index 0bd33f7..e33ea83 100644
--- a/WorkM/WorkM.csproj
+++ b/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>
diff --git a/WorkM/WorkM.csproj.user b/WorkM/WorkM.csproj.user
index b159ef0..1c6f68c 100644
--- a/WorkM/WorkM.csproj.user
+++ b/WorkM/WorkM.csproj.user
@@ -9,5 +9,6 @@
<ErrorReportUrlHistory />
<FallbackCulture>zh-CN</FallbackCulture>
<VerifyUploadedFiles>false</VerifyUploadedFiles>
+ <ProjectView>ProjectFiles</ProjectView>
</PropertyGroup>
</Project>
\ No newline at end of file
diff --git "a/WorkM/\346\212\245\350\241\250\345\210\206\346\236\220/Sc_WareHouseReport.Designer.cs" "b/WorkM/\346\212\245\350\241\250\345\210\206\346\236\220/Sc_WareHouseReport.Designer.cs"
new file mode 100644
index 0000000..2e67f46
--- /dev/null
+++ "b/WorkM/\346\212\245\350\241\250\345\210\206\346\236\220/Sc_WareHouseReport.Designer.cs"
@@ -0,0 +1,532 @@
+锘縩amespace 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;
+ }
+}
\ No newline at end of file
diff --git "a/WorkM/\346\212\245\350\241\250\345\210\206\346\236\220/Sc_WareHouseReport.cs" "b/WorkM/\346\212\245\350\241\250\345\210\206\346\236\220/Sc_WareHouseReport.cs"
new file mode 100644
index 0000000..db6f737
--- /dev/null
+++ "b/WorkM/\346\212\245\350\241\250\345\210\206\346\236\220/Sc_WareHouseReport.cs"
@@ -0,0 +1,342 @@
+锘縰sing 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);
+ }
+ }
+}
diff --git "a/WorkM/\346\212\245\350\241\250\345\210\206\346\236\220/Sc_WareHouseReport.resx" "b/WorkM/\346\212\245\350\241\250\345\210\206\346\236\220/Sc_WareHouseReport.resx"
new file mode 100644
index 0000000..3955877
--- /dev/null
+++ "b/WorkM/\346\212\245\350\241\250\345\210\206\346\236\220/Sc_WareHouseReport.resx"
@@ -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>
\ No newline at end of file
diff --git "a/WorkM/\346\212\245\350\241\250\345\210\206\346\236\220/Sc_WorkShopReport.Designer.cs" "b/WorkM/\346\212\245\350\241\250\345\210\206\346\236\220/Sc_WorkShopReport.Designer.cs"
new file mode 100644
index 0000000..936a5dd
--- /dev/null
+++ "b/WorkM/\346\212\245\350\241\250\345\210\206\346\236\220/Sc_WorkShopReport.Designer.cs"
@@ -0,0 +1,532 @@
+锘縩amespace 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;
+ }
+}
\ No newline at end of file
diff --git "a/WorkM/\346\212\245\350\241\250\345\210\206\346\236\220/Sc_WorkShopReport.cs" "b/WorkM/\346\212\245\350\241\250\345\210\206\346\236\220/Sc_WorkShopReport.cs"
new file mode 100644
index 0000000..2ddd55c
--- /dev/null
+++ "b/WorkM/\346\212\245\350\241\250\345\210\206\346\236\220/Sc_WorkShopReport.cs"
@@ -0,0 +1,339 @@
+锘縰sing 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);
+ }
+ }
+}
diff --git "a/WorkM/\346\212\245\350\241\250\345\210\206\346\236\220/Sc_WorkShopReport.resx" "b/WorkM/\346\212\245\350\241\250\345\210\206\346\236\220/Sc_WorkShopReport.resx"
new file mode 100644
index 0000000..3955877
--- /dev/null
+++ "b/WorkM/\346\212\245\350\241\250\345\210\206\346\236\220/Sc_WorkShopReport.resx"
@@ -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>
\ No newline at end of file
--
Gitblit v1.9.1