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