protected void btnSave_Click(object sender, EventArgs e) { string alert = ""; model = PageHelper.GetModel<TWCadreModel>(pnlContent.Controls); if (this.ProcessFlag.Value == "Add") { DataTable dt = tWCadreBll.GetTWCafreByKey(model); if (dt.Rows.Count > 0) { alert = "alert('" + Message.NotOnlyOne + "')"; } logmodel.ProcessFlag = "insert"; model.CreateUser = base.CurrentUserInfo.Personcode; model.CreateDate = System.DateTime.Now; bool flag = tWCadreBll.AddTWCdare(model, logmodel); if (flag == true) { alert = "alert('" + Message.AddSuccess + "')"; } else { alert = "alert('" + Message.AddFailed + "')"; } PageHelper.CleanControlsValue(pnlContent.Controls); } if (this.ProcessFlag.Value == "Modify") { logmodel.ProcessFlag = "update"; model.UpdateDate = System.DateTime.Now; model.UpdateUser = base.CurrentUserInfo.Personcode; bool flag = tWCadreBll.UpdateTWCdareByKey(model, logmodel); if (flag == true) { alert = "alert('" + Message.UpdateSuccess + "')"; } else { alert = "alert('" + Message.UpdateFailed + "')"; } } ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "save", alert, true); }
/// <summary> /// 輸出 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> 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<TWCadreModel> list = tWCadreBll.GetList(dt_global); string[] header = { ControlText.gvWorkNo, ControlText.gvHeadLocalName, ControlText.gvSex, ControlText.gvIdentityNo, ControlText.gvByName, ControlText.gvLevel, ControlText.gvManager, ControlText.gvHeadDepCode, ControlText.gvExtension, ControlText.gvHeadNotes, ControlText.gvJoinDate, ControlText.gvStatus, ControlText.gvLeaveDate, ControlText.gvCardNo, ControlText.gvIsKaoQin }; string[] properties = { "WorkNo", "LocalName", "Sex", "IdentityNo", "ByName", "LevelName", "ManagerName", "DepName", "Extension", "Notes", "JoinDate", "Status", "LeaveDate", "CardNo", "IsKaoQin" }; string filePath = MapPath("~/ExportFileTemp/") + DateTime.Now.Ticks + ".xls"; NPOIHelper.ExportExcel(list, header, properties, 5000, filePath); PageHelper.ReturnHTTPStream(filePath, true); } } else { string LevelCondition = ""; string ManagerCondition = ""; string StatusCondition = ""; string sql = SqlDep; model = PageHelper.GetModel<TWCadreModel>(pnlContent.Controls); if (!string.IsNullOrEmpty(this.DropDownCheckListLevelCode.SelectedValue.ToString())) { string[] temVal = DropDownCheckListLevelCode.SelectedValuesToString(",").Split(','); for (int iLoop = 0; iLoop < temVal.Length; iLoop++) { LevelCondition += "'" + temVal[iLoop] + "',"; } LevelCondition = LevelCondition.Substring(0, LevelCondition.Length - 1); } if (!string.IsNullOrEmpty(this.DropDownCheckListManager.SelectedValue.ToString())) { string[] temVal = DropDownCheckListManager.SelectedValuesToString(",").Split(','); for (int iLoop = 0; iLoop < temVal.Length; iLoop++) { ManagerCondition += "'" + temVal[iLoop] + "',"; } ManagerCondition = ManagerCondition.Substring(0, ManagerCondition.Length - 1); } if (!string.IsNullOrEmpty(this.DropDownCheckListStatus.SelectedValue.ToString())) { string[] temVal = DropDownCheckListStatus.SelectedValuesToString(",").Split(','); for (int iLoop = 0; iLoop < temVal.Length; iLoop++) { StatusCondition += "'" + temVal[iLoop] + "',"; } StatusCondition = StatusCondition.Substring(0, StatusCondition.Length - 1); } string JoinDateFrom = this.txtJoinDateFrom.Text.Trim(); string JoinDateTo = this.txtJoinDateTo.Text.Trim(); string LeaveDateFrom = this.txtLeaveDateFrom.Text.Trim(); string LeaveDateTo = this.txtLeaveDateTo.Text.Trim(); DataTable newdt = tWCadreBll.GetTWCadreForExport(model, sql, LevelCondition, ManagerCondition, StatusCondition, JoinDateFrom, JoinDateTo, LeaveDateFrom, LeaveDateTo); if (newdt.Rows.Count == 0) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "nodataexport", "alert('" + Message.NoDataExport + "');", true); } else { List<TWCadreModel> list = tWCadreBll.GetList(newdt); string[] header = { ControlText.gvOrgName, ControlText.gvWorkNo, ControlText.gvHeadLocalName, ControlText.gvSex, ControlText.gvIdentityNo, ControlText.gvByName, ControlText.gvLevel, ControlText.gvManager, ControlText.gvExtension, ControlText.gvHeadNotes, ControlText.gvJoinDate, ControlText.gvLeaveDate, ControlText.gvStatus, ControlText.gvCardNo, ControlText.gvIsKaoQin, ControlText.gvModifier, ControlText.gvModifyDate }; string[] properties = { "DepName", "WorkNo", "LocalName", "SexName", "IdentityNo", "ByName", "LevelName", "ManagerName", "Extension", "Notes", "JoinDate", "LeaveDate", "StatusName", "CardNo", "IsKaoQin", "UpdateUser", "UpdateDate" }; string filePath = MapPath("~/ExportFileTemp/") + DateTime.Now.Ticks + ".xls"; NPOIHelper.ExportExcel(list, header, properties, 5000, filePath); PageHelper.ReturnHTTPStream(filePath, true); } } }
protected void GridDataBind() { int totalCount; string LevelCondition = ""; string ManagerCondition = ""; string StatusCondition = ""; string sql = SqlDep; model = PageHelper.GetModel<TWCadreModel>(pnlContent.Controls); if (!string.IsNullOrEmpty(this.DropDownCheckListLevelCode.SelectedValue.ToString())) { string[] temVal = DropDownCheckListLevelCode.SelectedValuesToString(",").Split(','); for (int iLoop = 0; iLoop < temVal.Length; iLoop++) { LevelCondition += "'" + temVal[iLoop] + "',"; } LevelCondition = LevelCondition.Substring(0, LevelCondition.Length - 1); } if (!string.IsNullOrEmpty(this.DropDownCheckListManager.SelectedValue.ToString())) { string[] temVal = DropDownCheckListManager.SelectedValuesToString(",").Split(','); for (int iLoop = 0; iLoop < temVal.Length; iLoop++) { ManagerCondition += "'" + temVal[iLoop] + "',"; } ManagerCondition = ManagerCondition.Substring(0, ManagerCondition.Length - 1); } if (!string.IsNullOrEmpty(this.DropDownCheckListStatus.SelectedValue.ToString())) { string[] temVal = DropDownCheckListStatus.SelectedValuesToString(",").Split(','); for (int iLoop = 0; iLoop < temVal.Length; iLoop++) { StatusCondition += "'" + temVal[iLoop] + "',"; } StatusCondition = StatusCondition.Substring(0, StatusCondition.Length - 1); } string JoinDateFrom = this.txtJoinDateFrom.Text.Trim(); string JoinDateTo = this.txtJoinDateTo.Text.Trim(); string LeaveDateFrom = this.txtLeaveDateFrom.Text.Trim(); string LeaveDateTo = this.txtLeaveDateTo.Text.Trim(); DataTable dt = tWCadreBll.GetTWCadrePageInfo(model, sql, LevelCondition, ManagerCondition, StatusCondition, JoinDateFrom, JoinDateTo, LeaveDateFrom, LeaveDateTo, pager.CurrentPageIndex, pager.PageSize, out totalCount); pager.RecordCount = totalCount; this.UltraWebGrid.DataSource = dt.DefaultView; this.UltraWebGrid.DataBind(); pager.TextAfterPageIndexBox = "/" + pager.PageCount.ToString(); }