private string createList(string CustNo, string CustName, string CustType, string CustStatus, 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='8%'>客户编号</th>"); sb.Append("<th width='19%'>客户名称</th>"); sb.Append("<th width='19%'>客户简称</th>"); sb.Append("<th width='6%'>客户类别</th>"); sb.Append("<th width='6%'>单位法人</th>"); sb.Append("<th width='6%'>客户联系人</th>"); sb.Append("<th width='8%'>固定电话</th>"); sb.Append("<th width='9%'>联系人手机号码</th>"); sb.Append("<th width='9%'>电子邮箱</th>"); sb.Append("<th width='6%'>状态</th>"); sb.Append("</tr>"); sb.Append("</thead>"); int r = 1; sb.Append("<tbody>"); Business.Base.BusinessCustomer bc = new project.Business.Base.BusinessCustomer(); foreach (Entity.Base.EntityCustomer it in bc.GetListQuery(CustNo, CustName, CustType, CustStatus, page, pageSize)) { sb.Append("<tr class=\"text-c\" id=\"" + it.CustNo + "\">"); sb.Append("<td style=\"text-align:center;\">" + r.ToString() + "</td>"); sb.Append("<td>" + it.CustNo + "</td>"); sb.Append("<td>" + it.CustName + "</td>"); sb.Append("<td>" + it.CustShortName + "</td>"); sb.Append("<td>" + it.CustType + "</td>"); sb.Append("<td>" + it.Representative + "</td>"); sb.Append("<td>" + it.CustContact + "</td>"); sb.Append("<td>" + it.CustTel + "</td>"); sb.Append("<td>" + it.CustContactMobile + "</td>"); sb.Append("<td>" + it.CustEmail + "</td>"); sb.Append("<td class=\"td-status\"><span class=\"label " + (it.CustStatus == "1" ? "label-success" : "") + " radius\">" + it.CustStatusName + "</span></td>"); sb.Append("</tr>"); r++; } sb.Append("</tbody>"); sb.Append("</table>"); sb.Append(Paginat(bc.GetListCount(CustNo, CustName, CustType, CustStatus), 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()); }