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();
}
}
