Exemplo n.º 1
0
        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());
        }
Exemplo n.º 2
0
        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 += "&nbsp;&nbsp;&nbsp;&nbsp;";
                            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());
        }