public String Print() { string isbn = Request["isbn"]; string price = Request["price"]; string discount = Request["discount"]; string bookName = Request["bookName"]; string stockNumber = Request["stockNumber"]; string strWhere = groupType; string fileName = name; if (isbn != null && isbn != "") { strWhere += " and isbn='" + isbn + "'"; } if (price != "" && price != null) { string[] sArray = price.Split('于'); string type1 = sArray[0]; string number = sArray[1]; if (strWhere == "" || strWhere == null) { if (type1 == "小") { strWhere = "price < '" + number + "'"; } else if (type1 == "等") { strWhere = "price = '" + number + "'"; } else { strWhere = "price > '" + number + "'"; } } else { if (type1 == "小") { strWhere += " and price < '" + number + "'"; } else if (type1 == "等") { strWhere += " and price = '" + number + "'"; } else { strWhere += " and price > '" + number + "'"; } } } //if (price != null && price != "") //{ // strWhere += " and uPrice=" + price; //} if (discount != null && discount != "") { strWhere += " and discount=" + discount; } if (bookName != null && bookName != "") { strWhere += " and bookName like '%" + bookName + "%'"; } if (stockNumber != "" && stockNumber != null) { string[] sArray = stockNumber.Split('于'); string type = sArray[0]; string number = sArray[1]; if (strWhere == "" || strWhere == null) { if (type == "小") { strWhere = " and stockNum < '" + number + "'"; } else if (type == "等") { strWhere = " and stockNum = '" + number + "'"; } else { strWhere = " and stockNum > '" + number + "'"; } } else { if (type == "小") { strWhere += " and stockNum < '" + number + "'"; } else if (type == "等") { strWhere += " and stockNum = '" + number + "'"; } else { strWhere += " and stockNum > '" + number + "'"; } } } //DataTable printDt = stockBll.census(strWhere, groupType); //bookKinds = int.Parse(printDt.Rows[0]["品种数量"].ToString()); //allBookCount = int.Parse(printDt.Rows[0]["总数"].ToString()); DataTable dt = stockBll.ExportExcelDetail(strWhere, type); StringBuilder strb = new StringBuilder(); int dscount = dt.Rows.Count; for (int i = 0; i < dscount; i++) { DataRow dr = dt.Rows[i]; //序号 (i + 1 + ((currentPage - 1) * pageSize)) strb.Append("<tr><td>" + (i + 1) + "</td>"); strb.Append("<td>" + dr["ISBN"].ToString() + "</td>"); //strb.Append("<td>" + dr["书号"].ToString() + "</td>"); strb.Append("<td>" + dr["书名"].ToString() + "</td>"); strb.Append("<td>" + dr["单价"].ToString() + "</td>"); strb.Append("<td>" + dr["供应商"].ToString() + "</td>"); strb.Append("<td>" + dr["数量"].ToString() + "</td>"); strb.Append("<td>" + dr["进货折扣"].ToString() + "</td>"); strb.Append("<td>" + dr["销售折扣"].ToString() + "</td>"); strb.Append("<td>" + dr["组织名称"].ToString() + "</td></tr>"); } Response.Write(strb.ToString()); Response.End(); return(strb.ToString()); }