protected void btnExport_Click(object sender, EventArgs e)
{
model = PageHelper.GetModel<KQMLeaveApplyYearQryModel>(pnlContent.Controls);
model.LeaveYear = Convert.ToInt32(this.ddlLeaveyear.SelectedValue.ToString());
string BatchEmployeeNo = "";
string str = this.txtBatchEmployeeNo.Text.Trim();
if (str != "")
{
for (int i = 0; i < str.Split('\n').Length; i++)
{
BatchEmployeeNo = BatchEmployeeNo + str.Split('\n')[i].Trim() + "§";
}
}
string joindatefrom = this.txtJoinDateFrom.Text.Trim();
string joindateto = this.txtJoinDateTo.Text.Trim();
string countdatefrom = this.txtCountDateFrom.Text.Trim();
string countdateto = this.txtCountDateTo.Text.Trim();
string Status = "";
if (!string.IsNullOrEmpty(this.ddlStatus.SelectedValue.ToString()))
{
string[] temVal = ddlStatus.SelectedValuesToString(",").Split(',');
for (int iLoop = 0; iLoop < temVal.Length; iLoop++)
{
Status += "'" + temVal[iLoop] + "',";
}
Status = Status.Substring(0, Status.Length - 1);
}
string sql = SqlDep;
dt = bllLeaveApplyYearQry.GetLeaveApplyYearForExport(model, sql, BatchEmployeeNo, joindatefrom, joindateto, countdatefrom, countdateto, Status);
if (dt.Rows.Count == 0)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "nodataexport", "alert('" + Message.NoDataExport + "');", true);
}
else
{
List<KQMLeaveApplyYearQryModel> list = bllLeaveApplyYearQry.GetList(dt);
string[] header = { ControlText.gvDepName, ControlText.gvWorkNo, ControlText.gvLocalName, ControlText.gvSex, ControlText.gvKQMJoinDate, ControlText.gvEnableStartDate, ControlText.gvLeaveYear, ControlText.gvStartYears, ControlText.gvEndYears, ControlText.gvOutWorkYears, ControlText.gvOutFoxconnYears, ControlText.gvStandardDays, ControlText.gvAlreadDays, ControlText.gvKQMLeaveDays, ControlText.gvNextYearDays, ControlText.gvLeaveRecDays, ControlText.gvCountDays, ControlText.gvStatus, ControlText.gvUpdateDate };
string[] properties = { "DepName", "WorkNo", "LocalName", "SexName", "JoinDate", "EnableStartDate", "LeaveYear", "StartYears", "EndYears", "OutWorkYears", "OutFoxconnYears", "StandardDays", "AlreadDays", "LeaveDays", "NextYearDays", "LeaveRecDays", "CountDays", "StatusName", "UpdateDate" };
string filePath = MapPath("~/ExportFileTemp/") + DateTime.Now.Ticks + ".xls";
NPOIHelper.ExportExcel(list, header, properties, 5000, filePath);
PageHelper.ReturnHTTPStream(filePath, true);
}
}
private void Query()
{
int totalCount = 0;
model = PageHelper.GetModel<KQMLeaveApplyYearQryModel>(pnlContent.Controls);
model.LeaveYear=Convert.ToInt32(this.ddlLeaveyear.SelectedValue.ToString());
string BatchEmployeeNo = "";
string str = this.txtBatchEmployeeNo.Text.Trim();
if (str != "")
{
for (int i = 0; i < str.Split('\n').Length; i++)
{
BatchEmployeeNo = BatchEmployeeNo + str.Split('\n')[i].Trim() + "§";
}
}
string joindatefrom = this.txtJoinDateFrom.Text.Trim();
string joindateto = this.txtJoinDateTo.Text.Trim();
string countdatefrom = this.txtCountDateFrom.Text.Trim();
string countdateto = this.txtCountDateTo.Text.Trim();
string Status = "";
if (!string.IsNullOrEmpty(this.ddlStatus.SelectedValue.ToString()))
{
string[] temVal = ddlStatus.SelectedValuesToString(",").Split(',');
for (int iLoop = 0; iLoop < temVal.Length; iLoop++)
{
Status += "'" + temVal[iLoop] + "',";
}
Status = Status.Substring(0, Status.Length - 1);
}
string sql = SqlDep;
dt_global = bllLeaveApplyYearQry.GetLeaveApplyYear(model,sql, BatchEmployeeNo, joindatefrom, joindateto, countdatefrom, countdateto, Status, pager.CurrentPageIndex, pager.PageSize, out totalCount);
this.UltraWebGridLeaveQry.DataSource = dt_global.DefaultView;
this.UltraWebGridLeaveQry.DataBind();
pager.RecordCount = totalCount;
pager.TextAfterPageIndexBox = "/" + pager.PageCount.ToString();
}