using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Runtime.InteropServices; using gregn6Lib; using DBUtility; using SQLHelper; namespace WorkM { public partial class Sc_ICMOWorkCompleteSetBySendGoods : Form //简单报表－直接有一个存储过程＋简单过滤，返回生成报表 { public Sc_ICMOWorkCompleteSetBySendGoods() { InitializeComponent(); ClsCN SubCn = new ClsCN(); DataSet DSet; string sSql; string TableName = "Sc_ICMOWorkCompleteSetBySendGoods"; sSql = "truncate table " + TableName; DSet = SubCn.RunProcReturn(sSql, TableName, ref DBUtility.ClsPub.sExeReturnInfo); if (DSet == null) { MessageBox.Show("清除失败！" + DBUtility.ClsPub.sExeReturnInfo); return; } } public string ModName = "999999"; public string ModCaption = "发料清单"; Pub_Class.ClsGridListSum oSumGrid = new Pub_Class.ClsGridListSum(); #region 固定代码 private void initGrid() { DBUtility.Xt_BaseBillFun.initGridRpt(grdMain, this.Name); DBUtility.Xt_BaseBillFun.initGridRpt(grdSub, 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) { //选择打印模板 BLL.Gy_OpenTmp oFrm = new BLL.Gy_OpenTmp(); oFrm.sBillName = ModName; oFrm.sBillModel = ModCaption; oFrm.ShowDialog(); if (oFrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK) { // Sub_SetReport(oFrm.sOpenTmp); Report.Print(true); cmdelte_Click(sender, e); } //Sub_SetReport(); //Report.Print(true); } //预览 private void view_Click(object sender, EventArgs e) { //选择打印模板 BLL.Gy_OpenTmp oFrm = new BLL.Gy_OpenTmp(); oFrm.sBillName = ModName; oFrm.sBillModel = ModCaption; oFrm.ShowDialog(); if (oFrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK) { // Sub_SetReport(oFrm.sOpenTmp); Report.PrintPreview(false); cmdelte_Click(sender, e); } } #endregion #region 界面处理 //初始化表头显示 private void initHeadCaption() { } private bool Fun_AllowQuery()//审核查询条件 { //if (txtHBDeptID.Text.Trim().Length == 0) //{ // MessageBox.Show(this, "请选择开始部门！", "提示"); // return false; //} return true; } private void DisplaySub() { ClsCN SubCn = new ClsCN(); DataSet DSet; //显示报表头 标题 //停止GRID刷新 加快速度 //过滤条件Dlg string sDlgWhere = ""; for (int i = 0; i < grdMain.SelectedRows.Count; i++) { sDlgWhere = sDlgWhere + "," + DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.SelectedRows[i].Index].Cells[Fun_GetCol("标识列")].Value) + ""; } if (sDlgWhere.Trim().Length > 0) { sDlgWhere = sDlgWhere.Substring(1, sDlgWhere.Length - 1); } // DSet = SubCn.RunProcReturn("exec h_p_Sc_ICMOWorkCompleteSetBySendGoods_Print '" + sDlgWhere + "'", "Gy_Czygl"); //生成首行标题 if (DSet == null) { MessageBox.Show("没有返回任何结果,尝试再次查询！" + DBUtility.ClsPub.sExeReturnInfo); return; } // grdSub.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(grdSub, this.Name, "否", 0); // DBUtility.Xt_BaseBillFun.GetGrid(grdSub, this.Name); //Total(); //// // } private void Display() { try { ClsCN SubCn = new ClsCN(); DataSet DSet; //DataSet DsQty; //int BCol = 7; //long HDeptID = 0; //long HMaterID = 0; //long HEmpID = 0; //long HProcID = 0; //显示报表头 标题 //停止GRID刷新 加快速度 // string[] sNumber = txtHMaterNumber.Text.Split(','); string sNewMaterNumber = ""; for (int i = 0; i < sNumber.Length; i++) { sNewMaterNumber = sNewMaterNumber + ",''" + sNumber[i] + "''"; } if (sNewMaterNumber == "") { sNewMaterNumber = "''''"; } else { sNewMaterNumber = sNewMaterNumber.Substring(1, sNewMaterNumber.Length - 1); } //过滤条件Dlg string OrderProcNO = txtHICMOInterID.Text.Trim(); string sDlgWhere = ""; string[] tx = OrderProcNO.Split(','); for (int i = 0; i < tx.Length; i++) { string tt = tx[i]; sDlgWhere = "'" + tt + "'"; if (chkHSupFlag.Checked == true) { sDlgWhere = sDlgWhere + ",-1 "; } else { sDlgWhere = sDlgWhere + "," + DBUtility.ClsPub.isLong(txtHCenterID.Tag); } if (chkHShowPPBom.Checked == true) { sDlgWhere = sDlgWhere + ",1"; } else { sDlgWhere = sDlgWhere + ",0"; } sDlgWhere = sDlgWhere + ",'" + sNewMaterNumber + "'"; if (sDlgWhere == "") { sDlgWhere = "_"; } //if (sDlgWhere.Trim().Length > 0) //{ // sDlgWhere = sDlgWhere.Substring(1, sDlgWhere.Length - 1); //} // DSet = SubCn.RunProcReturn("exec h_p_Sc_ICMOWorkCompleteSetBySendGoods " + sDlgWhere, "Gy_Czygl"); //生成首行标题 if (DSet == null) { //MessageBox.Show("没有返回任何结果,尝试再次查询！" + DBUtility.ClsPub.sExeReturnInfo); MessageBox.Show("查询结果有误,尝试再次查询！" + DBUtility.ClsPub.sExeReturnInfo); return; } grdMain.DataSource = DSet.Tables[0].DefaultView; // //grdSub.DataSource = DSet.Tables[1].DefaultView; //获取动态列 （物料信息） //if (DSet.Tables[2].Rows.Count != 0) //{ //txtcpNumber.Text = DSet.Tables[2].Rows[0]["成品代码"].ToString(); //txtcpName.Text = DSet.Tables[2].Rows[0]["成品名称"].ToString(); //txtcpQty.Text = DSet.Tables[2].Rows[0]["成品数量"].ToString(); //txtHDate.Text = DSet.Tables[2].Rows[0]["HWGDate"].ToString(); //} //设置合计列 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.DisplayGrid(grdSub, this.Name + "grdSub", "是", 0); // DBUtility.Xt_BaseBillFun.GetGrid(grdMain, this.Name); //DBUtility.Xt_BaseBillFun.GetGrid(grdSub, this.Name + "grdSub"); //合并相同板材 //int FBCModelCol = Fun_GetCol("零件规格"); //int FFLQtyCol = Fun_GetCol("板材发料数"); //string FBCModel = ""; //for (int i = 0; i < grdMain.Rows.Count; i++) //{ // FBCModel = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[FBCModelCol].Value); // if (i < grdMain.Rows.Count - 1) // { // for (int j = i + 1; j < grdMain.Rows.Count; j++) // { // if (FBCModel == DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[FBCModelCol].Value)) //当板材零件规格相同时，合并 // { // grdMain.Rows[i].Cells[FFLQtyCol].Value = DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells[FFLQtyCol].Value) + DBUtility.ClsPub.isDoule(grdMain.Rows[j].Cells[FFLQtyCol].Value); // //grdMain.Rows[j].Cells[FFLQtyCol].Value = 0; // } // } //} // grdMain.Rows[i].Cells[FFLQtyCol].Value = Math.Ceiling(DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells[FFLQtyCol].Value)); //} // Total(); } } catch (Exception e) { MessageBox.Show("" + e.Message); } } #endregion #region 打印设置 //打印设置 GridppReport Report; //设置打印模版路径 private void Sub_SetReport(string sOpenTmp) { //判断行数 for (int i = 0; i < grdMain.Rows.Count; i++) { grdMain.Rows[i].Cells[0].Value = ""; } for (int i = 0; i < grdMain.SelectedRows.Count; i++) { grdMain.Rows[grdMain.SelectedRows[i].Index].Cells[0].Value = "*"; } DisplaySub(); Report = new GridppReport(); Report.LoadFromFile(DBUtility.ClsPub.AppPath + @"\" + sOpenTmp + ".grf"); //here . Report.BeforePostRecord += new _IGridppReportEvents_BeforePostRecordEventHandler(ReportBeforePostRecord); Report.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(ReportFetchRecordByDataTable); } //填入单据表头信息 private void ReportBeforePostRecord()//your report?kao { //Report.FieldByName("订单跟踪号").AsString = txtHICMOInterID.Text; //Report.FieldByName("成品代码").AsString = txtcpNumber.Text; //Report.FieldByName("成品名称").AsString = txtcpName.Text; //Report.FieldByName("成品数量").AsString = txtcpQty.Text; //Report.FieldByName("订单交期").AsString = txtHDate.Text; Report.FieldByName("工作中心").AsString = txtHCenterID.Text; //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() { DataTable oDT = new DataTable(); BLL.Utility.FillRecordToReportBySel(Report, grdSub, oDT, 0); //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.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 Sc_ICMOWorkCompleteSetBySendGoods_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 cmdcx_Click(object sender, EventArgs e) { timer1.Enabled = true; } private void cmdHCenterID_Click(object sender, EventArgs e) { BLL.ClsBaseSelect.SetTextByWorkCenter(txtHCenterID); } private void txtHCenterID_TextChanged(object sender, EventArgs e) { BLL.ClsPub_BLL.Sub_ClearText(txtHCenterID); } private void cmdelte_Click(object sender, EventArgs e) { ClsCN SubCn = new ClsCN(); DataSet DSet; string sSql; string TableName="Sc_ICMOWorkCompleteSetBySendGoods"; sSql = "truncate table " + TableName; DSet = SubCn.RunProcReturn(sSql, TableName, ref DBUtility.ClsPub.sExeReturnInfo); if (DSet == null) { MessageBox.Show("清除失败！" + DBUtility.ClsPub.sExeReturnInfo); return; } timer1.Enabled = true; } } }