/// <summary> /// 打印 /// </summary> private void print() { saleheadId = Session["saleheadId"].ToString(); saletaskId = Session["saleId"].ToString(); string op = Request["op"]; if (op == "print") { StringBuilder sb = new StringBuilder(); SellOffMonomerBll sellOffMonomerBll = new SellOffMonomerBll(); DataSet dataSet; if (type == "copy") { dataSet = sellOffMonomerBll.searchSalesDetailCopy(saletaskId, saleheadId); } else { dataSet = sellOffMonomerBll.searchSalesDetail(saletaskId, saleheadId); } DataRowCollection drc = dataSet.Tables[0].Rows; int datacount = dataSet.Tables[0].Rows.Count; for (int i = 0; i < datacount; i++) { sb.Append("<tr><td>" + (i + 1) + "</td>"); sb.Append("<td>" + dataSet.Tables[0].Rows[i]["ISBN"] + "</td>"); //sb.Append("<td>" + dataSet.Tables[0].Rows[i]["bookNum"] + "</td>"); sb.Append("<td>" + dataSet.Tables[0].Rows[i]["bookName"] + "</td>"); sb.Append("<td>" + dataSet.Tables[0].Rows[i]["unitPrice"] + "</td>"); sb.Append("<td>" + dataSet.Tables[0].Rows[i]["allnumber"] + "</td>"); sb.Append("<td>" + dataSet.Tables[0].Rows[i]["realDiscount"] + "</td>"); sb.Append("<td>" + dataSet.Tables[0].Rows[i]["allrealPrice"] + "</td></tr>"); //sb.Append("<td>" + ds.Tables[0].Rows[i]["ISBN"] + "</td>"); //sb.Append("<td>" + ds.Tables[0].Rows[i]["bookNum"] + "</td>"); //sb.Append("<td>" + ds.Tables[0].Rows[i]["bookName"] + "</td>"); //sb.Append("<td>" + ds.Tables[0].Rows[i]["unitPrice"] + "</td>"); //sb.Append("<td>" + ds.Tables[0].Rows[i]["allnumber"] + "</td>"); //sb.Append("<td>" + ds.Tables[0].Rows[i]["realDiscount"] + "</td>"); //sb.Append("<td>" + ds.Tables[0].Rows[i]["allrealPrice"] + "</td></tr>"); } Response.Write(sb); Response.End(); } }
public String GetData() { DataSet ds; SellOffMonomerBll smBll = new SellOffMonomerBll(); ds = smBll.getRetailRank(startTime, endTime, regionName); StringBuilder sb = new StringBuilder(); sb.Append("<tbody>"); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { sb.Append("<tr>"); sb.Append("<td>" + (i + 1) + "</td>"); sb.Append("<td title='" + ds.Tables[0].Rows[i]["bookName"].ToString() + "'>" + ds.Tables[0].Rows[i]["bookName"].ToString() + "</td>"); sb.Append("<td>" + ds.Tables[0].Rows[i]["unitPrice"].ToString() + "</td>"); sb.Append("<td>" + ds.Tables[0].Rows[i]["num"].ToString() + "</td>"); sb.Append("<td>" + Convert.ToDouble(ds.Tables[0].Rows[i]["allPrice"].ToString()).ToString("F2") + "</td>"); sb.Append("</tr>"); } sb.Append("</tbody>"); sb.Append("<input type='hidden' value='" + regionName + "' id='rName'/>"); return(sb.ToString()); }