protected void btnExport_Click(object sender, EventArgs e) { if (this.ImportFlag.Value != "Import") { string LevelCondition = ""; string ManagerCondition = ""; model = PageHelper.GetModel<EmpSupportOutModel>(pnlContent.Controls, txtSupportDept, txtSupportDeptName); string SupportDept = this.txtSupportDeptName.Text; if (!string.IsNullOrEmpty(this.ddlLevelCode.SelectedValue.ToString())) { string[] temVal = ddlLevelCode.SelectedValuesToString(",").Split(','); for (int iLoop = 0; iLoop < temVal.Length; iLoop++) { LevelCondition += "'" + temVal[iLoop] + "',"; } LevelCondition = LevelCondition.Substring(0, LevelCondition.Length - 1); } if (!string.IsNullOrEmpty(this.ddlManagerCode.SelectedValue.ToString())) { string[] temVal = ddlManagerCode.SelectedValuesToString(",").Split(','); for (int iLoop = 0; iLoop < temVal.Length; iLoop++) { ManagerCondition += "'" + temVal[iLoop] + "',"; } ManagerCondition = ManagerCondition.Substring(0, ManagerCondition.Length - 1); } string sql = base.SqlDep; DataTable newdt = empSupportOutBll.GetEmpSupportOutForExport(model, sql, SupportDept, LevelCondition, ManagerCondition); if (newdt.Rows.Count == 0) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "nodataexport", "alert('" + Message.NoDataExport + "');", true); } else { List<EmpSupportOutModel> list = empSupportOutBll.GetList(newdt); string[] header = { ControlText.gvSupportOrder, ControlText.gvSupportDeptName, ControlText.gvSubDepName, ControlText.gvWorkNo, ControlText.gvHeadLocalName, ControlText.gvEmpJoinDate, ControlText.gvSex, ControlText.gvLevel, ControlText.gvManager, ControlText.gvHeaderDataValue, ControlText.gvEmpStartDate, ControlText.gvPrepEndDate, ControlText.gvRealEndDate, ControlText.gvCardNo, ControlText.gvIsKaoQin, ControlText.gvRemark, ControlText.gvStateName }; string[] properties = { "SupportOrder", "SupportDeptName", "DepName", "WorkNo", "LocalName", "JoinDate", "SexName", "LevelName", "ManagerName", "OverTimeType", "StartDate", "PrepEndDate", "EndDate", "CardNo", "IsKaoQin", "Remark", "StateName" }; string filePath = MapPath("~/ExportFileTemp/") + DateTime.Now.Ticks + ".xls"; NPOIHelper.ExportExcel(list, header, properties, 5000, filePath); PageHelper.ReturnHTTPStream(filePath, true); } } else { if (dt_global.Rows.Count == 0) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "nodataexport", "alert('" + Message.NoDataExport + "');", true); } else { List<EmpSupportOutModel> list = empSupportOutBll.GetList(dt_global); string[] header = { ControlText.gvCostCode, ControlText.gvSupportDeptName, ControlText.gvWorkNo, ControlText.gvHeadLocalName, ControlText.gvSex, ControlText.gvLevel, ControlText.gvManager, ControlText.gvHeaderDataValue, ControlText.gvEmpStartDate, ControlText.gvPrepEndDate, ControlText.gvRealEndDate, ControlText.gvCardNo, ControlText.gvRemark, ControlText.gvIsKaoQin, ControlText.gvEmpJoinDate }; string[] properties = { "CostCode", "SupportDeptName", "DepName", "WorkNo", "LocalName", "SexName", "LevelName", "ManagerName", "OverTimeType", "StartDate", "PrepEndDate", "EndDate", "CardNo", "Remark", "IsKaoQin", "JoinDate" }; string filePath = MapPath("~/ExportFileTemp/") + DateTime.Now.Ticks + ".xls"; NPOIHelper.ExportExcel(list, header, properties, 5000, filePath); PageHelper.ReturnHTTPStream(filePath, true); } } }
protected void btnSave_Click(object sender, EventArgs e) { string alert = ""; model = PageHelper.GetModel<EmpSupportOutModel>(pnlContent.Controls); string WorkNo = model.WorkNo; model.SupportOrder = this.HiddenSeqNo.Value; if (this.ProcessFlag.Value == "Add") { logmodel.ProcessFlag = "insert"; if (employeeBll.GetEmp(WorkNo).Rows.Count > 0 || empSupportOutBll.GetEmpSupportOut(WorkNo).Rows.Count > 0) { base.Response.Write("<script type='text/javascript'>alert(\"" + Message.DuplicateState + "\");</script>"); return; } model.SupportOrder = empSupportOutBll.GetEmpsupportOrder(WorkNo).Rows[0][0].ToString(); bool flag = empSupportOutBll.AddEmpSupportOut(model, logmodel); if (flag == true) { alert = "alert('" + Message.AddSuccess + "')"; this.txtWorkNo.Text = ""; this.txtLocalName.Text = ""; this.ddlSex.SelectedValue = ""; this.txtSupportDept.Text = ""; this.txtSupportDeptName.Text = ""; this.txtDepName.Text = ""; this.txtJoinDate.Text = ""; this.txtStartDate.Text = ""; this.txtPrepEndDate.Text = ""; this.txtEndDate.Text = ""; this.txtNotes.Text = ""; this.ddlLevelCode.SelectedValue = ""; this.ddlManagerCode.SelectedValue = ""; this.ddlOverTimeType.SelectedValue = ""; this.ddlIsKaoQin.SelectedValue = ""; this.txtRemark.Text = ""; this.txtCardNo.Text = ""; } else { alert = "alert('" + Message.AddFailed + "')"; } } if (this.ProcessFlag.Value == "Modify") { logmodel.ProcessFlag = "update"; string tmpSupportOrder = this.HiddenSeqNo.Value.Trim(); if (empSupportOutBll.GetEmpSupportByWorkNoAndOrder(WorkNo, tmpSupportOrder).Rows.Count > 0) { base.Response.Write("<script type='text/javascript'>alert(\"" + Message.DuplicateState + "\");</script>"); return; } bool flag = empSupportOutBll.UpdateEmpSupportOut(model, logmodel); if (flag == true) { base.Response.Write("<script type='text/javascript'>alert('" + Message.UpdateSuccess + "');window.parent.document.all.btnQuery.click();</script>"); } else { alert = "alert('" + Message.UpdateFailed + "')"; } } ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "save", alert, true); }
private void DataUIBind() { int totalCount; string LevelCondition = ""; string ManagerCondition = ""; model = PageHelper.GetModel<EmpSupportOutModel>(pnlContent.Controls,txtSupportDept,txtSupportDeptName); string SupportDept = this.txtSupportDeptName.Text; if (!string.IsNullOrEmpty(this.ddlLevelCode.SelectedValue.ToString())) { string[] temVal = ddlLevelCode.SelectedValuesToString(",").Split(','); for (int iLoop = 0; iLoop < temVal.Length; iLoop++) { LevelCondition += "'" + temVal[iLoop] + "',"; } LevelCondition = LevelCondition.Substring(0, LevelCondition.Length - 1); } if (!string.IsNullOrEmpty(this.ddlManagerCode.SelectedValue.ToString())) { string[] temVal = ddlManagerCode.SelectedValuesToString(",").Split(','); for (int iLoop = 0; iLoop < temVal.Length; iLoop++) { ManagerCondition += "'" + temVal[iLoop] + "',"; } ManagerCondition = ManagerCondition.Substring(0, ManagerCondition.Length - 1); } string sql = base.SqlDep; DataTable dt = empSupportOutBll.GetEmpSupportOutPageInfo(model,sql, SupportDept, LevelCondition, ManagerCondition, pager.CurrentPageIndex, pager.PageSize, out totalCount); pager.RecordCount = totalCount; this.UltraWebGrid.DataSource = dt.DefaultView; this.UltraWebGrid.DataBind(); pager.TextAfterPageIndexBox = "/" + pager.PageCount.ToString(); }