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; namespace APSM { public partial class Sc_WorkProcReport_New : Form //简单报表-直接有一个存储过程+简单过滤,返回生成报表 { public Sc_WorkProcReport_New() { InitializeComponent(); } public const Int16 FixCols = 4; public const Int16 HMaterIDCol = 0; public const Int16 HMaterNumberCol = 1; public const Int16 HMaterNameCol = 2; public const Int16 HMaterModelCol = 3; // public string ModName = "0507"; public string ModCaption = "生产进度表"; Pub_Class.ClsGridListSum oSumGrid = new Pub_Class.ClsGridListSum(); #region 固定代码 private void initGrid() { DBUtility.Xt_BaseBillFun.initGridList(grdMain, this.Name); } //得到对应列 private int Fun_GetCol(string sColName) { //return DBUtility.Xt_BaseBillFun.Fun_GetCol(sColName, grdMain); return 0; } private void tc_Click(object sender, EventArgs e) { this.Close(); } Sc_WorkProcReport_NewDlg oDlg = new Sc_WorkProcReport_NewDlg(); 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 Xs_SellOutDayReport_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.ClsPub.SaveGridView(grdMain, this.Name, ClsPub.AppPath); } //打印 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); } } //预览 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(true); } } #endregion #region 界面处理 //初始化表头显示 private void initHeadCaption() { } private bool Fun_AllowQuery()//审核查询条件 { return true; } private void Display() { SQLHelper.ClsCN SubCn = new SQLHelper.ClsCN(); DataSet DSet = new DataSet(); int c = 0; int row = -1; long HMaterID = 0; //显示报表头 标题 //显示过滤条件 //过滤条件Dlg string sDlgWhere = ""; sDlgWhere = sDlgWhere + ",'" + oDlg.txtHSeOrderBillNo.Text.Trim() + "'"; sDlgWhere = sDlgWhere + ",'" + DBUtility.ClsPub.isStrNull(oDlg.txtHBMaterID.Text) + "'"; sDlgWhere = sDlgWhere + ",'" + DBUtility.ClsPub.isStrNull(oDlg.txtHEMaterID.Text) + "'"; if (sDlgWhere.Trim().Length > 0) { sDlgWhere = sDlgWhere.Substring(1, sDlgWhere.Length - 1); } DSet = SubCn.RunProcReturn("exec h_p_Sc_WorkProcReport_New " + sDlgWhere, "Gy_Czygl", ref DBUtility.ClsPub.sExeReturnInfo); //生成首行标题 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(); } #endregion #region 打印设置 //打印设置 GridppReport Report; //设置打印模版路径 private void Sub_SetReport(string sOpenTmp) { //判断行数 // 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()// { } //填入单据明细信息 private void ReportFetchRecordByDataTable() { try { DataTable oDt = new DataTable(); BLL.Utility.FillRecordToReport(Report, grdMain, oDt, 0); } catch (Exception e) { MessageBox.Show("打印失败!表体:" + e.Message); } } #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; } } //合计 new private void Total() { if (grdMain.Rows.Count > 0 && grdMain.ColumnCount > 0) { oSumGrid.SetGridsum(); oSumGrid.Total(); } } //合计 new private void grdMain_ColumnWidthChanged(object sender, DataGridViewColumnEventArgs e) { Total(); } //合计 new private void grdMain_CellMouseUp(object sender, DataGridViewCellMouseEventArgs e) { Total(); } private void grdMain_Paint(object sender, PaintEventArgs e) { DBUtility.Xt_BaseBillFun.GraphicsGrid(grdMain); } } }