protected void btnExport_Click(object sender, EventArgs e) { if (this.ImportFlag.Value == "Import") { if (dt_global.Rows.Count == 0) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "nodataexport", "alert('" + Message.NoDataExport + "');", true); } else { List<OTMRemainModel> list = oTMRemainBll.GetList(dt_global); string[] header = { ControlText.gvWorkNo, ControlText.gvYearMonth, ControlText.gvG1Remain, ControlText.gvG23Remain }; string[] properties = { "WorkNo", "YearMonth", "G1Remain", "G23Remain" }; string filePath = MapPath("~/ExportFileTemp/") + DateTime.Now.Ticks + ".xls"; NPOIHelper.ExportExcel(list, header, properties, 5000, filePath); PageHelper.ReturnHTTPStream(filePath, true); } } else { string sql = base.SqlDep; string YearMonth = this.txtYearMonth.Text.Replace("/", ""); model = PageHelper.GetModel<OTMRemainModel>(pnlContent.Controls); if (model != null) { model.YearMonth = this.txtYearMonth.Text.Replace("/", ""); } DataTable dt = oTMRemainBll.GetAllRemainForExport(model, sql); if (dt.Rows.Count == 0) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "nodataexport", "alert('" + Message.NoDataExport + "');", true); } else { List<OTMRemainModel> list = oTMRemainBll.GetList(dt); string[] header = { ControlText.gvWorkNo, ControlText.gvHeadLocalName, ControlText.gvOverTimeType, ControlText.gvYearMonth, ControlText.gvG1Remain, ControlText.gvG23Remain }; string[] properties = { "WorkNo", "LocalName", "OverTimeType", "YearMonth", "G1Remain", "G23Remain" }; string filePath = MapPath("~/ExportFileTemp/") + DateTime.Now.Ticks + ".xls"; NPOIHelper.ExportExcel(list, header, properties, 5000, filePath); PageHelper.ReturnHTTPStream(filePath, true); } } }
protected void Query() { string sql = base.SqlDep; string YearMonth = this.txtYearMonth.Text.Replace("/", ""); int totalCount=0; model = PageHelper.GetModel<OTMRemainModel>(pnlContent.Controls); if (model != null) { model.YearMonth=this.txtYearMonth.Text.Replace("/", ""); DataTable dt = oTMRemainBll.GetAllRemainInfo(model,sql, pager.CurrentPageIndex, pager.PageSize, out totalCount); pager.RecordCount = totalCount; this.UltraWebGrid.DataSource = dt.DefaultView; this.UltraWebGrid.DataBind(); pager.TextAfterPageIndexBox = "/" + pager.PageCount.ToString(); } }