protected void Button2_Click(object sender, EventArgs e) { string sql = ""; if (this.DropDownListName.SelectedValue != "不限" && string.IsNullOrEmpty(this.tbCheckName.Text) == false) { sql += " and " + this.DropDownListName.SelectedItem.Value + " like '%" + this.tbCheckName.Text + "%'"; } if (this.ddlState.SelectedValue != "不限") { sql += " and a.States = " + Common.TypeHelper.ObjectToInt(this.ddlState.SelectedValue, 0); } if (this.ddlJx.SelectedValue != "不限") { sql += " and a.Jx = '" + this.ddlJx.SelectedItem.Value + "'"; } if (this.ddlIsOCR.SelectedValue != "不限") { if (this.ddlIsOCR.SelectedValue == "是") { sql += " and ap.note is not null "; } else { sql += " and ap.note is null "; } } string stime = this.tbSt1.Text; string etime = this.tbSt2.Text; DateTime d = Convert.ToDateTime("2000-01-01"); if (stime != "") { string t1 = Common.TypeHelper.ObjectToDateTime(stime, d).ToShortDateString(); sql += " and a.CreateTime >= '" + t1 + " 00:00:00'"; } if (etime != "") { string t2 = Common.TypeHelper.ObjectToDateTime(etime, d).ToShortDateString(); sql += " and a.CreateTime <= '" + t2 + " 23:59:59'"; } string NoColum = this.HiddenFieldNum.Value; sql += " order by a.Id DESC"; string joinTab = "";//left join orderinfo as I on I.id=a.Id #region 转换类型 if (userseesion.GroupId != 2 && userseesion.GroupId != 22) { ColumnName = ColumnName.Replace("a.Mob;", "left(a.Mob,3)+'****'+right(a.Mob,4);"); ColumnName = ColumnName.Replace("a.PrizeCode;", "case len(a.PrizeCode) when 0 then '' else left(a.PrizeCode,3)+'****'+right(a.PrizeCode,4) end;"); ColumnName = ColumnName.Replace("a.Name;", "case len(a.Name) when 0 then '' else left(a.Name,1)+'*'+right(a.Name,1) end;"); } ColumnName = ColumnName.Replace("a.Id;", "CONVERT(varchar(50),a.Id);"); ColumnName = ColumnName.Replace("a.CreateTime;", "CONVERT(varchar(100),a.CreateTime,21);"); ColumnName = ColumnName.Replace("a.UpdateTime;", "CONVERT(varchar(100),a.UpdateTime,21);"); ColumnName = ColumnName.Replace("a.States;", "case a.States when 0 then '未审核' when 1 then '已审核' when -1 then '已作废' end;"); ColumnName = ColumnName.Replace("a.Number;", "CONVERT(varchar(50),a.Number);"); ColumnName = ColumnName.Replace("a.Types;", "CONVERT(varchar(50),a.Types);"); #endregion Common.NPOIHelper.ExportByWeb(dal.GetExcelList(sql, RowsName, ColumnName, joinTab, "OrderInfo", NoColum, true), "", "参与数据.xlsx");//true 表示导出OCR数据 非小票项目可不填 }