private String Print() { 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"]; string regionid = Request["regionId"]; 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; } if (groupbyType == "supplier") { groupbyType += ",regionId"; } if (regionid != null && regionid != "") { str += " and regionId=" + regionid; } DataTable dt = StockBll.bookStock(str, groupbyType).Tables[0]; int count = dt.Rows.Count; StringBuilder strb = new StringBuilder(); for (int i = 0; i < count; i++) { DataRow dr = dt.Rows[i]; strb.Append("<tr><td>" + (i + 1) + "</td>"); strb.Append("<td>" + dr[2].ToString() + "</td>"); strb.Append("<td>" + dr[1].ToString() + "</td>"); strb.Append("<td>" + dr[0].ToString() + "</td>"); strb.Append("<td>" + dr[3].ToString() + "</td>"); //strb.Append("<td>" + dr[4].ToString() + "</td></tr>"); } Response.Write(strb.ToString()); Response.End(); return(strb.ToString()); }