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());
}
