protected void Button1_Click(object sender, EventArgs e) { int count = 0; StringBuilder SqlWhere = new StringBuilder(); IList <SqlParam> IList_param = new List <SqlParam>(); SqlWhere.Append("SELECT * "); SqlWhere.Append("FROM View_UserList U"); SqlWhere.Append(" WHERE 1=1 "); if (!string.IsNullOrEmpty(this.AreaName.Value)) { SqlWhere.AppendFormat(" AND AreaName='{0}' ", this.AreaName.Value); } if (!string.IsNullOrEmpty(this.EduBackName.Value)) { SqlWhere.AppendFormat(" AND EduBackName='{0}' ", this.EduBackName.Value); } if (!string.IsNullOrEmpty(this.EduTypeName.Value)) { SqlWhere.AppendFormat(" AND EduTypeName='{0}' ", this.EduTypeName.Value); } if (!string.IsNullOrEmpty(this.CompanyID.Value)) { SqlWhere.AppendFormat(" AND CompanyID='{0}' ", this.CompanyID.Value); } if (!string.IsNullOrEmpty(this.specName.Value)) { SqlWhere.AppendFormat(" AND specName='{0}' ", this.specName.Value); } if (!string.IsNullOrEmpty(this.status.Value)) { SqlWhere.AppendFormat(" AND status='{0}' ", this.status.Value); } if (!string.IsNullOrEmpty(this.sexText.Value)) { SqlWhere.AppendFormat(" AND sexText='{0}' ", this.sexText.Value); } if (!string.IsNullOrEmpty(this.Is985.Value)) { SqlWhere.AppendFormat(" AND Is985={0} ", this.Is985.Value); } if (!string.IsNullOrEmpty(this.Is211.Value)) { SqlWhere.AppendFormat(" AND Is211={0} ", this.Is211.Value); } if (!string.IsNullOrEmpty(this.IsFullDay.Value)) { SqlWhere.AppendFormat(" AND IsFullDay={0} ", this.IsFullDay.Value); } SqlWhere.Append(" AND Checks='是'"); SqlWhere.Append(" AND specName IS NOT NULL"); if (!string.IsNullOrEmpty(this.txt_Search.Value)) { SqlWhere.Append(" AND U." + this.Searchwhere.Value + " like @obj "); IList_param.Add(new SqlParam("@obj", '%' + this.txt_Search.Value.Trim() + '%')); } string webpath = peridal.ExportExcelFilebySQL(SqlWhere); if (webpath != "0") { ShowMsgHelper.showFaceMsg("导出成功!" + webpath); // ShowMsgHelper. } else { ShowMsgHelper.Alert("导出失败!请联系技术人员。电话:18638956262"); } }