private string createList(string BBNo, string BBName, string BBAddr, string BBStatus, string BBType, string BBSPNo, int page) { System.Text.StringBuilder sb = new System.Text.StringBuilder(""); sb.Append("<table class=\"table table-border table-bordered table-hover table-bg table-sort\" id=\"tablelist\">"); sb.Append("<thead>"); sb.Append("<tr class=\"text-c\">"); sb.Append("<th width=\"4%\">序号</th>"); sb.Append("<th width='10%'>广告位编号</th>"); sb.Append("<th width='14%'>广告位名称</th>"); sb.Append("<th width='10%'>所在园区</th>"); sb.Append("<th width='20%'>所在位置</th>"); sb.Append("<th width='9%'>广告位类别</th>"); sb.Append("<th width='10%'>服务商</th>"); sb.Append("<th width='9%'>规格</th>"); sb.Append("<th width='7%'>状态</th>"); sb.Append("<th width='7%'>是否禁用</th>"); sb.Append("</tr>"); sb.Append("</thead>"); int r = 1; sb.Append("<tbody>"); Business.Base.BusinessBillboard bc = new project.Business.Base.BusinessBillboard(); foreach (Entity.Base.EntityBillboard it in bc.GetListQuery(BBNo, BBName, BBAddr, BBStatus, BBType, BBSPNo, page, pageSize)) { sb.Append("<tr class=\"text-c\" id=\"" + it.BBNo + "\">"); sb.Append("<td style=\"text-align:center;\">" + r.ToString() + "</td>"); sb.Append("<td>" + it.BBNo + "</td>"); sb.Append("<td>" + it.BBName + "</td>"); sb.Append("<td>" + it.BBSPName + "</td>"); sb.Append("<td>" + it.BBAddr + "</td>"); sb.Append("<td>" + it.BBTypeName + "</td>"); sb.Append("<td>" + it.BBSPName + "</td>"); sb.Append("<td>" + it.BBSize + "</td>"); sb.Append("<td class=\"td-status\"><span class=\"label " + (it.BBStatus == "use" ? "label-success" : "") + " radius\">" + it.BBStatusName + "</span></td>"); sb.Append("<td class=\"td-status\"><span class=\"label " + (it.BBISEnable == false ? "label-success" : "") + " radius\">" + (it.BBISEnable == false ? "正常" : "已禁用") + "</span></td>"); sb.Append("</tr>"); r++; } sb.Append("</tbody>"); sb.Append("</table>"); sb.Append(Paginat(bc.GetListCount(BBNo, BBName, BBAddr, BBStatus, BBType, BBSPNo), pageSize, page, 7)); return(sb.ToString()); }
private string createList(string Name, int page) { System.Text.StringBuilder sb = new System.Text.StringBuilder(""); try { if (Request.QueryString["type"] == "user") { sb.Append("<table class=\"table table-border table-bordered table-hover table-bg table-sort\" id=\"tablelist\">"); sb.Append("<thead>"); sb.Append("<tr class=\"text-c\">"); sb.Append("<th width='35%'>用户编号</th>"); sb.Append("<th width='65%'>用户名称</th>"); sb.Append("</tr>"); sb.Append("</thead>"); sb.Append("<tbody>"); Business.Sys.BusinessUserInfo pt = new project.Business.Sys.BusinessUserInfo(); foreach (Entity.Sys.EntityUserInfo it in pt.GetUserInfoListQuery(string.Empty, Name, page, 15)) { sb.Append("<tr class=\"text-c\" id='" + it.UserNo + "' onclick='submit(\"" + it.UserNo + "\")'>"); sb.Append("<td style='white-space: nowrap;'>" + it.UserNo + "<input type='hidden' id='it" + it.UserNo + "' value='" + it.UserName + "' /></td>"); sb.Append("<td style='white-space: nowrap;'>" + it.UserName + "</td>"); sb.Append("</tr>"); } sb.Append("</tbody>"); sb.Append("</table>"); sb.Append(Paginat(pt.GetUserInfoListCount(string.Empty, Name), 15, page, 5)); } else if (Request.QueryString["type"] == "SRVType") { sb.Append("<table class=\"table table-border table-bordered table-hover table-bg table-sort\" id=\"tablelist\">"); sb.Append("<thead>"); sb.Append("<tr class=\"text-c\">"); sb.Append("<th width='35%'>服务类型编号</th>"); sb.Append("<th width='65%'>服务类型名称</th>"); sb.Append("</tr>"); sb.Append("</thead>"); sb.Append("<tbody>"); Business.Base.BusinessServiceType pt = new project.Business.Base.BusinessServiceType(); foreach (Entity.Base.EntityServiceType it in pt.GetListQuery(string.Empty, Name, "null", string.Empty, true, page, 15)) { sb.Append("<tr class=\"text-c\" id='" + it.SRVTypeNo + "' onclick='submit(\"" + it.SRVTypeNo + "\")'>"); sb.Append("<td style='white-space: nowrap;'>" + it.SRVTypeNo + "<input type='hidden' id='it" + it.SRVTypeNo + "' value='" + it.SRVTypeName + "' /></td>"); sb.Append("<td style='white-space: nowrap;'>" + it.SRVTypeName + "</td>"); sb.Append("</tr>"); } sb.Append("</tbody>"); sb.Append("</table>"); sb.Append(Paginat(pt.GetListCount(string.Empty, Name, "null", string.Empty, true), 15, page, 5)); } else if (Request.QueryString["type"] == "LOC") { sb.Append("<table class=\"table table-border table-bordered table-hover table-bg table-sort\" id=\"tablelist\">"); sb.Append("<thead>"); sb.Append("<tr class=\"text-c\">"); sb.Append("<th width='35%'>编号</th>"); sb.Append("<th width='65%'>名称</th>"); sb.Append("</tr>"); sb.Append("</thead>"); sb.Append("<tbody>"); Business.Base.BusinessLocation pt = new project.Business.Base.BusinessLocation(); foreach (Entity.Base.EntityLocation it in pt.GetListQuery(string.Empty, Name, string.Empty, page, 15)) { string spacestr = ""; int row = 1; while (row <= it.LOCLevel) { spacestr += " "; row++; } sb.Append("<tr class=\"text-c\" id='" + it.LOCNo + "' onclick='submit(\"" + it.LOCNo + "\")'>"); sb.Append("<td style=\"white-space: nowrap;text-align:left;\">" + it.LOCNo + "<input type='hidden' id='it" + it.LOCNo + "' value='" + it.LOCName + "' /></td>"); sb.Append("<td style=\"white-space: nowrap;text-align:left;\">" + spacestr + it.LOCName + "</td>"); sb.Append("</tr>"); } sb.Append("</tbody>"); sb.Append("</table>"); sb.Append(Paginat(pt.GetListCount(string.Empty, Name, string.Empty), 15, page, 5)); } else if (Request.QueryString["type"] == "Cust") { sb.Append("<table class=\"table table-border table-bordered table-hover table-bg table-sort\" id=\"tablelist\">"); sb.Append("<thead>"); sb.Append("<tr class=\"text-c\">"); sb.Append("<th width='35%'>客户编号</th>"); sb.Append("<th width='65%'>客户名称</th>"); sb.Append("</tr>"); sb.Append("</thead>"); sb.Append("<tbody>"); Business.Base.BusinessCustomer pt = new project.Business.Base.BusinessCustomer(); foreach (Entity.Base.EntityCustomer it in pt.GetListQuery(string.Empty, Name, string.Empty, string.Empty, page, 15)) { sb.Append("<tr class=\"text-c\" id='" + it.CustNo + "' onclick='submit(\"" + it.CustNo + "\")'>"); sb.Append("<td style='white-space: nowrap;'>" + it.CustNo + "<input type='hidden' id='it" + it.CustNo + "' value='" + it.CustName + "' /></td>"); sb.Append("<td style='white-space: nowrap;'>" + it.CustName + "</td>"); sb.Append("</tr>"); } sb.Append("</tbody>"); sb.Append("</table>"); sb.Append(Paginat(pt.GetListCount(string.Empty, Name, string.Empty, string.Empty), 15, page, 5)); } else if (Request.QueryString["type"] == "Billboard") { sb.Append("<table class=\"table table-border table-bordered table-hover table-bg table-sort\" id=\"tablelist\">"); sb.Append("<thead>"); sb.Append("<tr class=\"text-c\">"); sb.Append("<th width='20%'>广告位编号</th>"); sb.Append("<th width='25%'>广告位名称</th>"); sb.Append("<th width='40%'>位置</th>"); sb.Append("<th width='15%'>广告位类型</th>"); sb.Append("</tr>"); sb.Append("</thead>"); sb.Append("<tbody>"); Business.Base.BusinessBillboard pt = new project.Business.Base.BusinessBillboard(); foreach (Entity.Base.EntityBillboard it in pt.GetListQuery(string.Empty, Name, string.Empty, string.Empty, string.Empty, string.Empty, page, 15)) { sb.Append("<tr class=\"text-c\" id='" + it.BBNo + "' onclick='submit(\"" + it.BBNo + "\")'>"); sb.Append("<td style='white-space: nowrap;'>" + it.BBNo + "<input type='hidden' id='it" + it.BBNo + "' value='" + it.BBName + "' /></td>"); sb.Append("<td style='white-space: nowrap;'>" + it.BBName + "</td>"); sb.Append("<td style='white-space: nowrap;'>" + it.BBAddr + "</td>"); sb.Append("<td style='white-space: nowrap;'>" + it.BBTypeName + "</td>"); sb.Append("</tr>"); } sb.Append("</tbody>"); sb.Append("</table>"); sb.Append(Paginat(pt.GetListCount(string.Empty, Name, string.Empty, string.Empty, string.Empty, string.Empty), 15, page, 5)); } } catch { } return(sb.ToString()); }