/// <summary>
/// 获取基础数据
/// </summary>
/// <returns></returns>
public string getData()
{
string search = "";
StringBuilder strb = new StringBuilder();
string customerName = Request["cusId"];
string op = Request["op"];
if (customerName != null && customerName != "")
{
search = " and customerName like '%" + customerName + "%'";
CustomerBll customerBll = new CustomerBll();
Customer cus = customerBll.getCustomerBuName(customerName);
customerId = cus.CustomerId;
customer = cus.CustomerName;
kinds = repBll.getMonkinds(customerId, 1);
counts = repBll.getTotalMon(customerId, 1);
}
else
{
search = "";
kinds = repBll.getMonkinds(0, 2);
counts = repBll.getTotalMon(0, 2);
customer = "";
}
//获取分页数据
int currentPage = Convert.ToInt32(Request["page"]);
if (currentPage == 0)
{
currentPage = 1;
}
TableBuilder tb = new TableBuilder();
tb.StrTable = "V_ReplenishMentMononer";
tb.OrderBy = "rsMononerID";
tb.StrColumnlist = "regionName,customerName,rsMononerID,bookNum,ISBN,bookName,sum(count) as count,dateTime";
tb.IntPageSize = pageSize;
tb.IntPageNum = currentPage;
tb.StrWhere = "ISNULL(finishTime) and deleteState=0" + search + " group by regionName,customerName,bookNum,ISBN,bookName";
//获取展示的客户数据
ds = saleBll.selectBypage(tb, out totalCount, out intPageCount);
//生成table
strb.Append("<tbody>");
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
strb.Append("<tr><td>" + (i + 1 + ((currentPage - 1) * pageSize)) + "</td>");
strb.Append("<td>" + ds.Tables[0].Rows[i]["ISBN"].ToString() + "</td>");
strb.Append("<td>" + ds.Tables[0].Rows[i]["bookNum"].ToString() + "</td>");
strb.Append("<td><nobr>" + ds.Tables[0].Rows[i]["bookName"].ToString() + "</nobr></td>");
strb.Append("<td>" + ds.Tables[0].Rows[i]["count"].ToString() + "</td>");
strb.Append("<td>" + ds.Tables[0].Rows[i]["customerName"].ToString() + "</td>");
strb.Append("<td>" + ds.Tables[0].Rows[i]["regionName"].ToString() + "</td>");
strb.Append("<td><nobr>" + Convert.ToDateTime(ds.Tables[0].Rows[i]["dateTime"].ToString()).ToString("yyyy/MM/dd") + "</nobr></td></tr>");
}
strb.Append("<input type='hidden' value='" + intPageCount + "' id='intPageCount' />");
strb.Append("</tbody>");
if (op == "paging")
{
Response.Write(strb.ToString() + ":|" + kinds + ":|" + counts + ":|" + customer);
Response.End();
}
return(strb.ToString());
}
