protected void btnExport_Click(object sender, EventArgs e) { if (ImportFlag.Value == "2") { if (dt.Rows.Count != 0) { model = PageHelper.GetModel<KQMLeaveYearImportModel>(pnlContent.Controls); List<KQMLeaveYearImportModel> list = bll.GetList(dt); string[] header = { ControlText.gvErrorMsg, ControlText.gvWorkNo, ControlText.gvLeaveYear, ControlText.gvLeaveDays }; string[] properties = { "ErrorMsg", "WorkNo", "LeaveYear", "LeaveDays" }; string filePath = MapPath("~/ExportFileTemp/") + DateTime.Now.Ticks + ".xls"; NPOIHelper.ExportExcel(list, header, properties, 5000, filePath); PageHelper.ReturnHTTPStream(filePath, true); } else { lblupload.Text =Message.NoDataExport; } } else { if (dt.Rows.Count != 0) { model = PageHelper.GetModel<KQMLeaveYearImportModel>(pnlContent.Controls); string SQLDep = base.SqlDep; string depCode = model.DepCode; model.DepCode = null; model.DName = null; model.LeaveYear = Convert.ToInt32(ddlLeaveYear.SelectedValue.ToString() == "" ? null : ddlLeaveYear.SelectedValue.ToString()); dt = bll.GetLeaveDaysList(model, SQLDep, depCode); List<KQMLeaveYearImportModel> list = bll.GetList(dt); string[] header = { ControlText.gvWorkNo, ControlText.gvLocalName, ControlText.gvBuOTMQryName, ControlText.gvDName, ControlText.gvLeaveYear, ControlText.gvLeaveDays, ControlText.gvCreateUser, ControlText.gvCreateDate }; string[] properties = { "WorkNo", "LocalName", "BuOTMQryName", "DName", "LeaveYear", "LeaveDays", "CreateUser", "CreateDate" }; string filePath = MapPath("~/ExportFileTemp/") + DateTime.Now.Ticks + ".xls"; NPOIHelper.ExportExcel(list, header, properties, 5000, filePath); PageHelper.ReturnHTTPStream(filePath, true); } else { lblupload.Text = Message.NoDataExport; } } }
protected void pager_PageChanged(object sender, EventArgs e) { model = PageHelper.GetModel<KQMLeaveYearImportModel>(pnlContent.Controls); ImportFlag.Value = "1"; DataUIBind(); }
protected void btnDelete_Click(object sender, EventArgs e) { int intDeleteOk = 0; int intDeleteError = 0; TemplatedColumn tcol = (TemplatedColumn)this.UltraWebGrid.Bands[0].Columns[0]; for (int i = 0; i < this.UltraWebGrid.Rows.Count; i++) { CellItem GridItem = (CellItem)tcol.CellItems[i]; CheckBox chkIsHaveRight = (CheckBox)GridItem.FindControl("CheckBoxCell"); if (chkIsHaveRight.Checked) { logmodel.ProcessFlag = "delete"; model.WorkNo = this.UltraWebGrid.Rows[i].Cells.FromKey("WorkNo").Text.Trim(); model.LeaveYear = Convert.ToInt32(this.UltraWebGrid.Rows[i].Cells.FromKey("LeaveYear").Text.Trim()); int flag = bll.DeleteLeaveYearByKey(model, logmodel); if (flag == 1) { intDeleteOk++; } else { intDeleteError++; } } } if ((intDeleteOk + intDeleteError) > 0) { string alertText = "成功刪除:" + intDeleteOk + "," + "刪除失敗:" + intDeleteError; Page.ClientScript.RegisterStartupScript(GetType(), "show", "alert('" + alertText + "')", true); } pager.CurrentPageIndex = 1; PageHelper.CleanControlsValue(pnlContent.Controls); model = new KQMLeaveYearImportModel(); int thisYear = DateTime.Now.Year; this.ddlLeaveYear.SelectedIndex = this.ddlLeaveYear.Items.IndexOf(this.ddlLeaveYear.Items.FindByValue(Convert.ToString(thisYear))); DataUIBind(); }
protected void btnQuery_Click(object sender, EventArgs e) { model = PageHelper.GetModel<KQMLeaveYearImportModel>(pnlContent.Controls); ImportFlag.Value = "1"; pager.CurrentPageIndex = 1; DataUIBind(); }