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 Mes_OrderProcFlowAllReport_RateMain : Form //简单报表－直接有一个存储过程＋简单过滤，返回生成报表 { public int HSupFlag; public Mes_OrderProcFlowAllReport_RateMain() { InitializeComponent(); } public string ModName = ""; public string ModCaption = "车间工序全程跟踪达成率报表"; Pub_Class.ClsGridListSum oSumGrid = new Pub_Class.ClsGridListSum(); public Int32 iTopRow = 0;//画横线 int _ScrollValue = 0;//刷新 回位 public string HOrderProcNo; #region 固定代码 private void initGrid() { DBUtility.Xt_BaseBillFun.initGridRpt(grdMain, this.Name); grdMain.AlternatingRowsDefaultCellStyle.BackColor = Color.White; } //得到对应列 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(); } } //Mes_OrderProcFlowAllReport_RateMainDlg oDlg = new Mes_OrderProcFlowAllReport_RateDlg(); 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 Mes_OrderProcFlowAllReport_RateMain_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 (txtHOrderProcNo.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刷新 加快速度 //if (txtHOrderProcNo.Text.Trim() == "") //{ // return; //} //过滤条件Dlg string sDlgWhere = ""; sDlgWhere = sDlgWhere + ",'" + txtHOrderProcNo.Text.Trim() + "'"; sDlgWhere = sDlgWhere + ",'" + txtHMaterNumber.Text.Trim() + "'"; sDlgWhere = sDlgWhere + ",'" + txtHCusName.Text.Trim() + "'"; sDlgWhere = sDlgWhere + ",'" + dtpHBDate.Value.ToShortDateString() + "'"; sDlgWhere = sDlgWhere + ",'" + dtpHEDate.Value.ToShortDateString() + "'"; if (checkBox1.Checked) { sDlgWhere = sDlgWhere + ",'结案'"; } else { sDlgWhere = sDlgWhere + ",''"; } if (sDlgWhere.Trim().Length > 0) { sDlgWhere = sDlgWhere.Substring(1, sDlgWhere.Length - 1); } // DSet = SubCn.RunProcReturn("exec h_p_Mes_OrderProcFlowAllReport_AllRateMain " + sDlgWhere, "Gy_Czygl"); //生成首行标题 if (DSet == null) { MessageBox.Show("没有返回任何结果,尝试再次查询！" + DBUtility.ClsPub.sExeReturnInfo); return; } // grdMain.DataSource = DSet.Tables[0].DefaultView; ////获取动态列 （物料信息） //设置合计列 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(); //int HPlanQtyCol = Fun_GetCol("计划数量"); //int HRecProc1Col = Fun_GetCol("接收工序1"); ////将数量大于等于 生产数量的 网格变成 绿色 //for (int i = 0; i < grdMain.Rows.Count; i++) //{ // for (int j = HRecProc1Col; j < grdMain.Columns.Count; j++) // { // if (j % 2 == 1) // { // if (DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[j].Value) == "") // { // grdMain.Rows[i].Cells[j].Style.BackColor = Color.White; // grdMain.Rows[i].Cells[j-1].Style.BackColor = Color.White; // } // else // { // if (DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells[j].Value) >= DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells[HPlanQtyCol].Value)) // { // grdMain.Rows[i].Cells[j].Style.BackColor = Color.MediumAquamarine; // grdMain.Rows[i].Cells[j-1].Style.BackColor = Color.MediumAquamarine; // } // else // { // grdMain.Rows[i].Cells[j].Style.BackColor = Color.Violet; // grdMain.Rows[i].Cells[j-1].Style.BackColor = Color.Violet; // } // } // } // if ((j - HRecProc1Col) % 8 == 7) // { // grdMain.Rows[i].Cells[j].Style.BackColor = Color.White; // grdMain.Rows[i].Cells[j - 1].Style.BackColor = Color.White; // } // } //} //for (int j = HRecProc1Col; j < grdMain.Columns.Count-2; j++) //{ // if (checkBox1.Checked == false) // { // if (ClsPub.isStrNull(grdMain.Columns[j].HeaderText).ToUpper().Trim().Contains("不合格") == true) // { // grdMain.Columns[j].Visible = false; // } // else // { // grdMain.Columns[j].Visible = true; // } // } // else // { // grdMain.Columns[j].Visible = true; // } //} // } #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.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 cmdHBDeptID_Click(object sender, EventArgs e) { } private void cmdHEDeptID_Click(object sender, EventArgs e) { } 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 Mes_OrderProcFlowAllReport_RateMain_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.F7) { TotalAll(); } } private void cmdHWorkCenter_Click(object sender, EventArgs e) { } 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 dc_Click(object sender, EventArgs e) { DBUtility.Gy_BaseFun.DataGridViewToExcel2(grdMain, this.Text, this.Text); } 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 grdMain_DoubleClick(object sender, EventArgs e) { //if (grdMain.CurrentRow == null) //{ // MessageBox.Show("请先选择行!"); // return; //} //int HProcExchBillNoCol = Fun_GetCol("流转卡号"); //string sProcExchBillNo = DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.CurrentRow.Index].Cells[HProcExchBillNoCol].Value); //QC_NoPassProdCheckBillList oFrm = new QC_NoPassProdCheckBillList(); //oFrm.txtHBillNo.Text = sProcExchBillNo; //oFrm.ShowDialog(); } private void taizhang_Click(object sender, EventArgs e) { if (grdMain.CurrentRow == null) { MessageBox.Show("请先选择行!"); return; } int HProcExchBillNoCol = Fun_GetCol("订单跟踪号"); string sProcExchBillNo = DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.CurrentRow.Index].Cells[HProcExchBillNoCol].Value); Mes_OrderProcFlowAllReport_Rate oFrm = new Mes_OrderProcFlowAllReport_Rate(); oFrm.txtHOrderProcNo.Text = sProcExchBillNo; oFrm.ShowDialog(); } private void button1_Click(object sender, EventArgs e) { // int HProcRateCol = Fun_GetCol(cmbHProc.Text); for (int i = 0; i < grdMain.Rows.Count; i++) { //判断 if (DBUtility.ClsPub.isDoule(DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HProcRateCol].Value).Replace("%","")) <= DBUtility.ClsPub.isDoule(txtHRate.Text)) { grdMain.Rows[i].Visible = true; } else { grdMain.Rows[i].Visible = false; } } } } }