From 7f5fd4b07afcf2f41371829d3f9774b2618d5916 Mon Sep 17 00:00:00 2001
From: yxj <1qaz@123>
Date: 星期五, 26 十一月 2021 16:16:22 +0800
Subject: [PATCH] 1
---
WorkM/报表分析/EAM_SourceRuningStatus.cs | 344 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 344 insertions(+), 0 deletions(-)
diff --git "a/WorkM/\346\212\245\350\241\250\345\210\206\346\236\220/EAM_SourceRuningStatus.cs" "b/WorkM/\346\212\245\350\241\250\345\210\206\346\236\220/EAM_SourceRuningStatus.cs"
new file mode 100644
index 0000000..6490a07
--- /dev/null
+++ "b/WorkM/\346\212\245\350\241\250\345\210\206\346\236\220/EAM_SourceRuningStatus.cs"
@@ -0,0 +1,344 @@
+锘縰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 EAM_SourceRuningStatus : Form //绠�鍗曟姤琛紞鐩存帴鏈変竴涓瓨鍌ㄨ繃绋嬶紜绠�鍗曡繃婊わ紝杩斿洖鐢熸垚鎶ヨ〃
+ {
+ public EAM_SourceRuningStatus()
+ {
+ InitializeComponent();
+ }
+ public string ModName = "";
+ public string ModCaption = "璁惧杩愯鐘舵�佽〃";
+ Pub_Class.ClsGridListSum oSumGrid = new Pub_Class.ClsGridListSum();
+ public Int32 iTopRow = 0;//鐢绘í绾�
+ int _ScrollValue = 0;//鍒锋柊 鍥炰綅
+
+
+ #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();
+ }
+
+ //Sc_ICMOProcFlowExecReportDlg oDlg = new Sc_ICMOProcFlowExecReportDlg();
+ 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_ICMOProcFlowExecReport_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()
+ {
+
+ }
+
+ 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 DsQty;
+ int BCol = 7;
+ long HDeptID = 0;
+ long HMaterID = 0;
+ long HEmpID = 0;
+ long HProcID = 0;
+ //鏄剧ず鎶ヨ〃澶� 鏍囬
+
+ //鍋滄GRID鍒锋柊 鍔犲揩閫熷害
+
+ //杩囨护鏉′欢Dlg
+ string sDlgWhere = "";
+
+ sDlgWhere = "";
+ sDlgWhere = " '" + dtpHBeginDate.Value.ToShortDateString() + "'";
+ sDlgWhere = sDlgWhere + ",'" + dtpHEndDate.Value.ToShortDateString() + "'" ;
+ sDlgWhere = sDlgWhere + ", 0 ";
+ if (sDlgWhere == "")
+ {
+ sDlgWhere = "";
+ }
+
+ //if (sDlgWhere.Trim().Length > 0)
+ //{
+ // sDlgWhere = sDlgWhere.Substring(1, sDlgWhere.Length - 1);
+ //}
+ //
+ DSet = SubCn.RunProcReturn("exec h_p_EAM_SourceRuningStatus " + 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_ICMOProcFlowExecReport " + 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_Sc_ICMOProcFlowExecReport " + sDlgWhere, "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);
+ }
+ #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.TotalAll();
+ }
+ }
+
+ private void grdMain_CellMouseUp(object sender, DataGridViewCellMouseEventArgs e)
+ {
+ //oSumGrid.SetGridsum_NoData();
+ }
+
+ private void grdMain_ColumnWidthChanged(object sender, DataGridViewColumnEventArgs e)
+ {
+ //oSumGrid.SetGridsum_NoData();
+ }
+
+ private void grdMain_Paint(object sender, PaintEventArgs e)
+ {
+ //DBUtility.Xt_BaseBillFun.GraphicsGrid(grdMain);
+ }
+
+ private void EAM_SourceRuningStatus_KeyDown(object sender, KeyEventArgs e)
+ {
+ if (e.KeyCode == Keys.F7)
+ {
+ TotalAll();
+ }
+ }
+ private void TotalAll()
+ {
+ if (grdMain.Rows.Count > 0 && grdMain.ColumnCount > 0)
+ {
+ oSumGrid.SetGridsum();
+ oSumGrid.TotalAll();
+ }
+ }
+
+ private void grdMain_Scroll(object sender, ScrollEventArgs e)
+ {
+ if (e.ScrollOrientation == ScrollOrientation.VerticalScroll)
+ {
+ this.iTopRow = e.NewValue;
+ _ScrollValue = e.NewValue;
+ }
+
+ if (e.ScrollOrientation == ScrollOrientation.HorizontalScroll)
+ {
+ oSumGrid.SetGridsum_NoData();
+ }
+ }
+
+ 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);
+ }
+
+ private void cmdcx_Click(object sender, EventArgs e)
+ {
+ timer1.Enabled = true;
+ }
+
+
+
+
+ }
+}
\ No newline at end of file
--
Gitblit v1.9.1