private void exportDetail()
{
User user = (User)Session["user"];
int regionId = user.ReginId.RegionId;
string roleName = user.RoleId.RoleName;
string strWhere = "";
string groupbyType = Request["groupbyType"];
string supplier = Request["supplier"];
string regionName = Request["regionName"];
if (groupbyType == "state" || groupbyType == null)
{
groupbyType = "supplier";
}
if (supplier != "" && supplier != null)
{
strWhere = "supplier='" + supplier + "'";
}
if (regionName != "" && regionName != null)
{
strWhere = "regionName='" + regionName + "'";
}
if (roleName != "超级管理员")
{
if (strWhere == "" || strWhere == null)
{
strWhere = "regionId=" + regionId;
}
else
{
strWhere += "and regionId=" + regionId;
}
}
string str = "";
if (strWhere == "" || strWhere == null)
{
str = groupbyType + " like'%'";
}
else
{
str = strWhere;
}
string file = "书籍库存明细导出" + DateTime.Now.ToString("yyyyMMddHHmmss");
DataTable dt = StockBll.bookStockDe(str, groupbyType);
int count = dt.Rows.Count;
if (count > 0)
{
ExcelHelp.dtToExcelForXlsxByNpoi(dt, file);
}
else
{
Response.Write("<script language='javascript'>alert('查询不到数据，不能执行导出操作!')</script>");
}
}
