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数据 非小票项目可不填
}
