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>");
}
}
/// <summary>
/// 导出
/// </summary>
public void excelBook()
{
string bookName = Request["bookName"];
string bookNum = Request["bookNum"];
string bookISBN = Request["bookISBN"];
string discount = Request["discount"];
string discount2 = Request["discount2"];
string bookGys = Request["bookGys"];
string fileName = "";
string strExcel = "";
if (bookName != "" && bookName != null)
{
if (strExcel == "" || strExcel == null)
{
strExcel = "bookName like '%" + bookName + "%'";
}
else
{
strExcel += " and bookName like '%" + bookName + "%'";
}
}
if (bookNum != "" && bookNum != null)
{
if (strExcel == "" || strExcel == null)
{
strExcel = "bookNum like '%" + bookNum + "%'";
}
else
{
strExcel += " and bookNum like '%" + bookNum + "%'";
}
}
if (bookISBN != "" && bookISBN != null)
{
if (strExcel == "" || strExcel == null)
{
strExcel = "isbn like '%" + bookISBN + "%'";
}
else
{
strExcel += " and isbn like '%" + bookISBN + "%'";
}
}
if (discount != "" && discount != null)
{
string[] sArray = discount.Split('于');
string type = sArray[0];
string number = sArray[1];
try
{
if (strExcel == "" || strExcel == null)
{
if (type == "小")
{
strExcel = "remarks < '" + number + "'";
}
else if (type == "等")
{
strExcel = "remarks = '" + number + "'";
}
else
{
strExcel = "remarks > '" + number + "'";
}
}
else
{
if (type == "小")
{
strExcel += " and remarks < '" + number + "'";
}
else if (type == "等")
{
strExcel += " and remarks = '" + number + "'";
}
else
{
strExcel += " and remarks > '" + number + "'";
}
}
}
catch
{
Response.Write("数据库存在不符合格式的数据");
Response.End();
}
}
if (discount2 != "" && discount2 != null)
{
string[] sArray = discount2.Split('于');
string type = sArray[0];
string number = sArray[1];
try
{
if (strExcel == "" || strExcel == null)
{
if (type == "小")
{
strExcel = "author < '" + number + "'";
}
else if (type == "等")
{
strExcel = "author = '" + number + "'";
}
else
{
strExcel = "author > '" + number + "'";
}
}
else
{
if (type == "小")
{
strExcel += " and author < '" + number + "'";
}
else if (type == "等")
{
strExcel += " and author = '" + number + "'";
}
else
{
strExcel += " and author > '" + number + "'";
}
}
}
catch
{
Response.Write("数据库存在不符合格式的数据");
Response.End();
}
}
if (bookGys != "" && bookGys != null)
{
if (strExcel == "" || strExcel == null)
{
strExcel += "supplier like '%" + bookGys + "%'";
}
else
{
strExcel += " and supplier like '%" + bookGys + "%'";
}
}
string Name = fileName + "-书籍基础数据-" + DateTime.Now.ToString("yyyyMMdd") + new Random(DateTime.Now.Second).Next(10000);
DataTable dt = bookbll.excelBook(strExcel);
if (dt != null && dt.Rows.Count > 0)
{
ExcelHelp.dtToExcelForXlsxByNpoi(dt, Name);
}
else
{
Response.Write("<script>alert('没有数据，不能执行导出操作!');</script>");
Response.End();
}
}