protected void btnExport_Click(object sender, EventArgs e) { if (this.ImportFlag.Value != "Import") { string LevelCondition = ""; string ManagerCondition = ""; model = PageHelper.GetModel<EmpSupportInModel>(pnlContent.Controls, txtDepCode, txtDepName); string depname = this.txtDepName.Text; if (!string.IsNullOrEmpty(this.ddlLevelName.SelectedValue.ToString())) { string[] temVal = ddlLevelName.SelectedValuesToString(",").Split(','); for (int iLoop = 0; iLoop < temVal.Length; iLoop++) { LevelCondition += "'" + temVal[iLoop] + "',"; } LevelCondition = LevelCondition.Substring(0, LevelCondition.Length - 1); } if (!string.IsNullOrEmpty(this.ddlManagerName.SelectedValue.ToString())) { string[] temVal = ddlManagerName.SelectedValuesToString(",").Split(','); for (int iLoop = 0; iLoop < temVal.Length; iLoop++) { ManagerCondition += "'" + temVal[iLoop] + "',"; } ManagerCondition = ManagerCondition.Substring(0, ManagerCondition.Length - 1); } string StartDateFrom = this.txtStartDate1.Text.Trim(); string StartDateTo = this.txtStartDate2.Text.Trim(); string PrepEndDateFrom = this.txtPrepEndDate1.Text.Trim(); string PrepEndDateTo = this.txtPrepEndDate2.Text.Trim(); DataTable dt = empSupportInBll.GetEmpSupportInForExport(model, depname, LevelCondition, ManagerCondition, StartDateFrom, StartDateTo, PrepEndDateFrom, PrepEndDateTo); if (dt.Rows.Count == 0) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "nodataexport", "alert('" + Message.NoDataExport + "');", true); } else { List<EmpSupportInModel> list = empSupportInBll.GetList(dt); string[] header = { ControlText.gvWorkNo, ControlText.gvHeadLocalName, ControlText.gvSex, ControlText.gvSupportOrder, ControlText.gvSupportDeptName, ControlText.gvEmpStartDate, ControlText.gvPrepEndDate, ControlText.gvRealEndDate, ControlText.gvStateName, ControlText.gvRemark }; string[] properties = { "WorkNo", "LocalName", "SexName", "SupportOrder", "SupportDept", "StartDate", "PrepEndDate", "EndDate", "StateName", "Remark" }; 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<EmpSupportInModel> list = empSupportInBll.GetList(dt_global); string[] header = { ControlText.gvWorkNo, ControlText.gvCostCode, ControlText.gvSupportDeptName, ControlText.gvEmpStartDate, ControlText.gvPrepEndDate, ControlText.gvRealEndDate, ControlText.gvRemark }; string[] properties = { "WorkNo", "CostCode", "SupportDeptName", "StartDate", "PrepEndDate", "EndDate", "Remark" }; 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<EmpSupportInModel>(pnlContent.Controls); string WorkNo = model.WorkNo; if (empSupportInBll.GetEmpStatus(WorkNo).Rows[0][0].ToString().Equals("2")) { base.Response.Write("<script type='text/javascript'>alert(\"" + Message.WorkNoIsWrong + "\");</script>"); return; } if (this.ProcessFlag.Value == "Add") { logmodel.ProcessFlag = "insert"; if (empSupportInBll.GetEmpSupportIn(WorkNo).Rows.Count>0) { base.Response.Write("<script type='text/javascript'>alert(\"" + Message.MoreThanOneSupport + "\");</script>"); return; } model.SupportOrder = empSupportInBll.GetEmpsupportOrder(WorkNo).Rows[0][0].ToString(); bool flag = empSupportInBll.AddEmpSupportIn(model,logmodel); if (flag == true) { alert = "alert('" + Message.AddSuccess + "')"; this.ddlState.SelectedIndex = 0; this.txtWorkNo.Text = ""; this.txtSupportDept.Text = ""; this.txtSupportDeptName.Text = ""; this.txtStartDate.Text = ""; this.txtPrepEndDate.Text = ""; this.txtEndDate.Text = ""; this.txtRemark.Text = ""; this.HiddenSupportOrder.Value = ""; } else { alert = "alert('" + Message.AddFailed + "')"; this.TextBoxsReset("Add", false); } } if (this.ProcessFlag.Value == "Modify") { logmodel.ProcessFlag = "update"; string tmpSupportOrder = this.HiddenSupportOrder.Value.Trim(); if (empSupportInBll.GetEmpSupportByWorkNoAndOrder(WorkNo, tmpSupportOrder).Rows.Count > 0) { base.Response.Write("<script type='text/javascript'>alert(\"" + Message.DuplicateState + "\");</script>"); return; } model.SupportOrder = tmpSupportOrder; bool flag = empSupportInBll.UpdateEmpSupportIn(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<EmpSupportInModel>(pnlContent.Controls,txtDepCode,txtDepName); string depname = this.txtDepName.Text; if (!string.IsNullOrEmpty(this.ddlLevelName.SelectedValue.ToString())) { string[] temVal = ddlLevelName.SelectedValuesToString(",").Split(','); for (int iLoop = 0; iLoop < temVal.Length; iLoop++) { LevelCondition += "'" + temVal[iLoop] + "',"; } LevelCondition = LevelCondition.Substring(0, LevelCondition.Length - 1); } if (!string.IsNullOrEmpty(this.ddlManagerName.SelectedValue.ToString())) { string[] temVal = ddlManagerName.SelectedValuesToString(",").Split(','); for (int iLoop = 0; iLoop < temVal.Length; iLoop++) { ManagerCondition += "'" + temVal[iLoop] + "',"; } ManagerCondition = ManagerCondition.Substring(0, ManagerCondition.Length - 1); } string StartDateFrom = this.txtStartDate1.Text.Trim(); string StartDateTo = this.txtStartDate2.Text.Trim(); string PrepEndDateFrom = this.txtPrepEndDate1.Text.Trim(); string PrepEndDateTo = this.txtPrepEndDate2.Text.Trim(); DataTable dt = empSupportInBll.GetEmpSupportInPageInfo(model,depname, LevelCondition, ManagerCondition, StartDateFrom, StartDateTo, PrepEndDateFrom, PrepEndDateTo, pager.CurrentPageIndex, pager.PageSize, out totalCount); pager.RecordCount = totalCount; this.UltraWebGridSupportIn.DataSource = dt.DefaultView; this.UltraWebGridSupportIn.DataBind(); pager.TextAfterPageIndexBox = "/" + pager.PageCount.ToString(); }