Пример #1
0
    public void GetPackages()
    {
        string keyword  = tools.CheckStr(Request["keyword"]);
        int    isinsale = tools.CheckInt(Request["isinsale"]);
        string PageUrl  = "?keyword=" + keyword;

        QueryInfo Query = new QueryInfo();

        Query.PageSize    = 15;
        Query.CurrentPage = tools.CheckInt(Request["page"]);
        if (Query.CurrentPage < 1)
        {
            Query.CurrentPage = 1;
        }
        //Query.ParamInfos.Add(new ParamInfo("AND", "str", "PackageInfo.Package_Site", "=", pub.GetCurrentSite()));
        Query.ParamInfos.Add(new ParamInfo("AND", "int", "PackageInfo.Package_SupplierID", "=", tools.NullInt(Session["supplier_id"]).ToString()));

        if (isinsale == 1)
        {
            Query.ParamInfos.Add(new ParamInfo("AND", "int", "PackageInfo.Package_IsInsale", "=", "1"));
        }
        else if (isinsale == 2)
        {
            Query.ParamInfos.Add(new ParamInfo("AND", "int", "PackageInfo.Package_IsInsale", "=", "0"));
        }
        if (keyword.Length > 0)
        {
            Query.ParamInfos.Add(new ParamInfo("AND", "str", "PackageInfo.Package_Name", "like", keyword));
        }
        Query.OrderInfos.Add(new OrderInfo("PackageInfo.Package_ID", "DESC"));

        //Response.Write("<table class=\"commontable\">");
        //Response.Write("<tr>");
        Response.Write("<table width=\"100%\" cellpadding=\"0\" align=\"center\" cellspacing=\"1\" style=\"background:#dadada;\" >");
        Response.Write("<tr style=\"background:url(/images/ping.jpg); height:30px;\">");
        Response.Write("  <th align=\"center\" valign=\"middle\">名称</th>");
        Response.Write("  <th width=\"100\" align=\"center\" valign=\"middle\">捆绑价格</th>");
        Response.Write("  <th width=\"100\" align=\"center\" valign=\"middle\">重量</th>");
        Response.Write("  <th width=\"100\" align=\"center\" valign=\"middle\">销售状态</th>");
        Response.Write("  <th width=\"100\" align=\"center\" valign=\"middle\">添加时间</th>");
        Response.Write("  <th width=\"80\" align=\"center\" valign=\"middle\">操作</th>");
        Response.Write("</tr>");

        PageInfo pageinfo = MyBLL.GetPageInfo(Query, pub.CreateUserPrivilege("0dd17a70-862d-4e57-9b45-897b98e8a858"));

        IList <PackageInfo> entitys = MyBLL.GetPackages(Query, pub.CreateUserPrivilege("0dd17a70-862d-4e57-9b45-897b98e8a858"));

        if (entitys != null)
        {
            foreach (PackageInfo entity in entitys)
            {
                Response.Write("<tr bgcolor=\"#ffffff\">");
                Response.Write("<td height=\"35\" align=\"center\" valign=\"middle\">" + entity.Package_Name + "</td>");
                Response.Write("<td height=\"35\" align=\"center\" valign=\"middle\">" + pub.FormatCurrency(entity.Package_Price) + "</td>");
                Response.Write("<td height=\"35\" align=\"center\" valign=\"middle\">" + entity.Package_Weight + "</td>");
                Response.Write("<td height=\"35\" align=\"center\" valign=\"middle\">");
                if (entity.Package_IsInsale == 1)
                {
                    Response.Write("上架");
                }
                else
                {
                    Response.Write("下架");
                }
                Response.Write("</td>");
                Response.Write("<td height=\"35\" align=\"center\" valign=\"middle\">" + entity.Package_Addtime + "</td>");

                Response.Write("<td height=\"35\" align=\"center\" valign=\"middle\">");
                Response.Write("<a href=\"/supplier/package_edit.aspx?package_id=" + entity.Package_ID + "\">修改</a>");
                Response.Write(" <a href=\"/supplier/package_do.aspx?action=move&package_id=" + entity.Package_ID + "\">删除</a>");
                Response.Write("</td>");
                Response.Write("</tr>");
            }

            Response.Write("</table>");
            Response.Write("<table width=\"100%\" border=\"0\" cellspacing=\"0\" align=\"center\" cellpadding=\"2\"><tr><td align=\"right\" height=\"10\"></td></tr><tr><td align=\"right\"><div class=\"page\" style=\"float:right;\">");
            pub.Page(pageinfo.PageCount, pageinfo.CurrentPage, PageUrl, pageinfo.PageSize, pageinfo.RecordCount);
            Response.Write("</div></td></tr></table>");
        }
        else
        {
            Response.Write("<tr bgcolor=\"#ffffff\"><td height=\"35\" colspan=\"8\" align=\"center\">没有记录</td></tr>");
            Response.Write("</table>");
        }
    }
Пример #2
0
    //网站公告右侧列表 /**/
    public void Notice_List(int cateid)
    {
        int page = tools.CheckInt(Request["page"]);

        if (page < 1)
        {
            page = 1;
        }
        NoticeCateInfo CateInfo = MyNoticeCate.GetNoticeCateByID(cateid, pub.CreateUserPrivilege("fb3e87ba-3d4d-480d-934e-80048bcc0100"));

        if (CateInfo != null)
        {
            Response.Write("<div id=\"help-right\">");
            Response.Write("  <h3>" + CateInfo.Notice_Cate_Name + "</h3>");
            Response.Write("  <div id=\"help-rightwen1\">");
            Response.Write("  <ul>");
            QueryInfo Query = new QueryInfo();
            Query.PageSize    = 20;
            Query.CurrentPage = page;
            Query.ParamInfos.Add(new ParamInfo("AND", "int", "NoticeInfo.Notice_IsAudit", "=", "1"));
            Query.ParamInfos.Add(new ParamInfo("AND", "str", "NoticeInfo.Notice_Site", "=", "CN"));
            Query.ParamInfos.Add(new ParamInfo("AND", "int", "NoticeInfo.Notice_Cate", "=", CateInfo.Notice_Cate_ID.ToString()));
            Query.OrderInfos.Add(new OrderInfo("NoticeInfo.Notice_ID", "DESC"));
            IList <NoticeInfo> notices = Webnotice.GetNotices(Query, pub.CreateUserPrivilege("9d4d1366-35ab-4eb6-b88e-e49e6bfae9d7"));
            if (notices != null)
            {
                foreach (NoticeInfo entity in notices)
                {
                    Response.Write("<li><span style=\"color:#535353;\">[ " + entity.Notice_Addtime.ToString("yy-MM-dd") + " ]</span><a href=\"/notice/detail.aspx?notice_id=" + entity.Notice_ID + "\">" + tools.CutStr(entity.Notice_Title, 35) + "</a></li>");
                }
            }
            else
            {
                Response.Write("<div height=\"50\"  style=\" height:50px; text-align:center;line-height:50px; color:#707070;\">信息正在维护中...</div>");
            }
            Response.Write("</ul>");

            PageInfo pageinfo = Webnotice.GetPageInfo(Query, pub.CreateUserPrivilege("9d4d1366-35ab-4eb6-b88e-e49e6bfae9d7"));
            if (pageinfo != null && pageinfo.RecordCount >= 1)
            {
                string url = "/notice/index.aspx?cate_id=" + CateInfo.Notice_Cate_ID;
                Response.Write("<div style=\" float:right; padding-right:30px; padding-bottom:5px;\">");
                pub.Page(pageinfo.PageCount, pageinfo.CurrentPage, url, pageinfo.PageSize, pageinfo.RecordCount);
                Response.Write("</div>");
            }

            Response.Write("  </div>");
            Response.Write("</div>");
        }
        else
        {
            Response.Write("<div id=\"help-right\">");
            Response.Write("  <h3>热点公告</h3>");
            Response.Write("  <div id=\"help-rightwen1\">");
            Response.Write("  <ul>");
            QueryInfo Query = new QueryInfo();
            Query.PageSize    = 20;
            Query.CurrentPage = 1;
            Query.ParamInfos.Add(new ParamInfo("AND", "int", "NoticeInfo.Notice_IsAudit", "=", "1"));
            Query.ParamInfos.Add(new ParamInfo("AND", "int", "NoticeInfo.Notice_IsHot", "=", "1"));
            Query.ParamInfos.Add(new ParamInfo("AND", "str", "NoticeInfo.Notice_Site", "=", "CN"));
            Query.OrderInfos.Add(new OrderInfo("NoticeInfo.Notice_ID", "DESC"));
            IList <NoticeInfo> notices = Webnotice.GetNotices(Query, pub.CreateUserPrivilege("9d4d1366-35ab-4eb6-b88e-e49e6bfae9d7"));

            if (notices != null)
            {
                foreach (NoticeInfo entity in notices)
                {
                    Response.Write("<li><span>[ " + entity.Notice_Addtime.ToString("yy-MM-dd") + " ]</span><a href=\"/notice/detail.aspx?notice_id=" + entity.Notice_ID + "\">" + tools.CutStr(entity.Notice_Title, 35) + "</a></li>");
                }
            }
            else
            {
                Response.Write("<div height=\"50\"  style=\" height:50px; text-align:center;line-height:50px; color:#707070;\">信息正在维护中...</div>");
            }
            Response.Write("  </ul>");
            PageInfo pageinfo = Webnotice.GetPageInfo(Query, pub.CreateUserPrivilege("9d4d1366-35ab-4eb6-b88e-e49e6bfae9d7"));
            if (pageinfo != null && pageinfo.RecordCount > 0)
            {
                string url = "/notice/index.aspx?cate_id=0";
                Response.Write("<div style=\" float:right; padding-right:30px; padding-bottom:5px;\">");
                pub.Page(pageinfo.PageCount, pageinfo.CurrentPage, url, pageinfo.PageSize, pageinfo.RecordCount);
                Response.Write("</div>");
            }
            Response.Write("  </div>");
            Response.Write("</div>");
        }
    }
Пример #3
0
    /// <summary>
    /// 搜索店铺
    /// </summary>
    /// <returns></returns>
    public void SearchShops()
    {
        string page_url = "action=list";

        StringBuilder strHTML = new StringBuilder();

        QueryInfo Query = new QueryInfo();

        Query.PageSize    = 6;
        Query.CurrentPage = tools.CheckInt(Request["page"]);
        if (Query.CurrentPage <= 0)
        {
            Query.CurrentPage = 1;
        }
        Query.ParamInfos.Add(new ParamInfo("AND", "str", "SupplierShopInfo.Shop_Site", "=", pub.GetCurrentSite()));
        Query.ParamInfos.Add(new ParamInfo("AND", "int", "SupplierShopInfo.Shop_Status", "=", "1"));

        string keyword = tools.CheckStr(Request["keyword"]);

        if (keyword.Length > 0)
        {
            Query.ParamInfos.Add(new ParamInfo("AND", "str", "SupplierShopInfo.Shop_Name", "like", keyword));
            page_url += "&keyword=" + Server.UrlEncode(keyword);
        }

        Query.OrderInfos.Add(new OrderInfo("SupplierShopInfo.Shop_ID", "ASC"));
        PageInfo pageinfo = myshop.GetPageInfo(Query);
        IList <SupplierShopInfo> entitys;

        strHTML.Append("<h2 class=\"title10\">共找到<strong>" + pageinfo.RecordCount + "</strong>条信息</h2>");

        if (pageinfo.RecordCount >= 1)
        {
            string       targetURL = string.Empty;
            SupplierInfo supplierInfo;
            entitys = myshop.GetSupplierShops(Query);

            if (entitys != null)
            {
                foreach (SupplierShopInfo entity in entitys)
                {
                    #region 循环体

                    supplierInfo = supplier.GetSupplierByID(entity.Shop_SupplierID);
                    if (supplierInfo == null)
                    {
                        supplierInfo = new SupplierInfo();
                    }

                    targetURL = supplier.GetShopURL(entity.Shop_Domain);

                    strHTML.Append("<div class=\"blk61\">");
                    strHTML.Append("	<div class=\"b61_left\">");
                    strHTML.Append("			<h2><a href=\""+ targetURL + "\" target=\"_blank\">" + entity.Shop_Name + "</a><span onclick=\"NTKF.im_openInPageChat('sz_" + (entity.Shop_SupplierID + 1000) + "_9999');\"><img style=\"display:inline-block; vertical-align:middle; margin-left:15px;width:74px;margin-right:10px;\" src=\"/images/icon04.png\"></span><span><a href=\"javascript:void(0);\">推广</a></span></h2>");
                    strHTML.Append("			<div class=\"b61_left_main\">");
                    strHTML.Append("				<ul>");
                    strHTML.Append("					<li><span>主营产品:</span>"+ entity.Shop_MainProduct + "</li>");
                    strHTML.Append("					<li><span>经营年限:</span>"+ supplierInfo.Supplier_OperateYear + "</li>");
                    strHTML.Append("					<li><span>所在地:</span>"+ addr.DisplayAddress(supplierInfo.Supplier_State, supplierInfo.Supplier_City, supplierInfo.Supplier_County) + "</li>");
                    strHTML.Append("					<li><span>注册资金:</span>"+ (supplierInfo.Supplier_RegisterFunds == 0 ? "无需验证" : supplierInfo.Supplier_RegisterFunds + "万") + "</li>");
                    strHTML.Append("				</ul>");
                    strHTML.Append("				<div class=\"clear\"></div>");

                    strHTML.Append("<p>");
                    IList <SupplierCertInfo> certs = supplier.GetSupplierCertByType(0);
                    if (certs != null)
                    {
                        int icert = 0;
                        foreach (SupplierCertInfo cert in certs)
                        {
                            if (supplier.Get_Supplier_Cert(cert.Supplier_Cert_ID, supplierInfo.SupplierRelateCertInfos).Length > 0)
                            {
                                icert++;

                                if (icert >= 2)
                                {
                                    strHTML.Append(" > ");
                                }

                                strHTML.Append(cert.Supplier_Cert_Name);
                            }
                        }
                    }
                    strHTML.Append("</p>");

                    strHTML.Append("			</div>");
                    strHTML.Append("	</div>");
                    strHTML.Append("	<div class=\"b61_right\">");
                    strHTML.Append("			<h2><a href=\""+ targetURL + "\" target=\"_blank\">进入本店铺 ></a></h2>");
                    strHTML.Append("			<div class=\"b61_right_main\">");
                    strHTML.Append("			<ul>");
                    strHTML.Append(ShopProducts(entity.Shop_SupplierID));
                    strHTML.Append("			</ul>");
                    strHTML.Append("			<div class=\"clear\"></div>");
                    strHTML.Append("			</div>");
                    strHTML.Append("	</div>");
                    strHTML.Append("	<div class=\"clear\"></div>");
                    strHTML.Append("	<em><img src=\"/images/div_bg.jpg\"></em>");
                    strHTML.Append("</div>");

                    #endregion
                }
            }
        }

        Response.Write(strHTML.ToString());

        page_url = Request.Path + "?" + page_url.TrimStart('&');
        pub.Page(pageinfo.PageCount, pageinfo.CurrentPage, page_url, pageinfo.PageSize, pageinfo.RecordCount);
    }
Пример #4
0
    /// <summary>
    /// 账户明细
    /// </summary>
    /// <param name="subAccNo"></param>
    /// <param name="startDate"></param>
    /// <param name="endDate"></param>
    public void Account_List(string subAccNo, DateTime startDate, DateTime endDate)
    {
        int    i = 0;
        string Pageurl;
        int    curpage = tools.CheckInt(tools.NullStr(Request["page"]));

        Pageurl = "?action=list&date_start=" + startDate.ToString("yyyy-MM-dd") + "&date_end=" + endDate.ToString("yyyy-MM-dd");
        if (curpage < 1)
        {
            curpage = 1;
        }
        //Response.Write("<div  class=\"blk05_sz\" >");
        Response.Write("<table width=\"100%\" cellpadding=\"0\" align=\"center\" cellspacing=\"1\" >");
        Response.Write("<tr style=\"background:url(/images/ping.jpg); height:30px;\">");
        Response.Write("  <td width=\"130\"align=\"center\" valign=\"middle\">交易时间</th>");
        Response.Write("  <td width=\"80\" align=\"center\" valign=\"middle\">借贷标志</th>");
        Response.Write("  <td width=\"80\" align=\"center\" valign=\"middle\">交易金额</th>");
        Response.Write("  <td width=\"80\" align=\"center\" valign=\"middle\">账户余额</th>");
        Response.Write("  <td align=\"center\" valign=\"middle\">对方账户名称</th>");
        Response.Write("  <td width=\"136\" align=\"center\" valign=\"middle\">打印校验码</th>");
        Response.Write("  <td align=\"center\" valign=\"middle\">摘要</th>");
        Response.Write("</tr>");

        int    startRecord = (curpage - 1) * 10 + 1;
        string strXml      = strXml = sendmessages.AccountDetail(subAccNo, startDate.ToString("yyyyMMdd"), endDate.ToString("yyyyMMdd"), startRecord);
        int    icount      = 0;

        if (strXml.Length > 0)
        {
            XPathDocument     xmlDoc    = new XPathDocument(new StringReader(strXml));
            XPathNavigator    navigator = xmlDoc.CreateNavigator();
            XPathNodeIterator nodes     = navigator.Select("/stream/list[@name='userDataList']/row");
            if (nodes != null)
            {
                while (nodes.MoveNext())
                {
                    icount++;
                    Response.Write("<tr bgcolor=\"#ffffff\">");
                    Response.Write("<td height=\"35\" align=\"left\" class=\"comment_td_bg\" style=\"padding:0px 5px;text-align:center;\" valign=\"middle\">" + DateTime.ParseExact(nodes.Current.SelectSingleNode("tranDate").InnerXml + nodes.Current.SelectSingleNode("tranTime").InnerXml, "yyyyMMddHHmmss", System.Globalization.CultureInfo.CurrentCulture).ToString("yyyy-MM-dd HH:mm:ss") + "</td>");
                    Response.Write("<td height=\"35\" class=\"comment_td_bg\" style=\"padding:0px 5px;\" >" + (nodes.Current.SelectSingleNode("loanFlag").InnerXml == "D" ? "借" : "贷") + "</td>");
                    Response.Write("<td height=\"35\" class=\"comment_td_bg\" style=\"padding:0px 5px;\" >" + nodes.Current.SelectSingleNode("tranAmt").InnerXml + "</td>");
                    Response.Write("<td height=\"35\" class=\"comment_td_bg\" style=\"padding:0px 5px;\" >" + nodes.Current.SelectSingleNode("accBalAmt").InnerXml + "</td>");
                    Response.Write("<td height=\"35\" class=\"comment_td_bg\" style=\"padding:0px 5px;\" >" + nodes.Current.SelectSingleNode("accountNm").InnerXml + "</td>");
                    Response.Write("<td height=\"35\" class=\"comment_td_bg\" style=\"padding:0px 5px;text-align:center;\" >" + nodes.Current.SelectSingleNode("verifyCode").InnerXml + "</td>");
                    Response.Write("<td height=\"35\" class=\"comment_td_bg\" style=\"padding:0px 5px;\" >" + nodes.Current.SelectSingleNode("memo").InnerXml + "</td>");
                    Response.Write("</tr>");
                }
            }

            Response.Write("</table>");
            //Response.Write("</div>");
            Response.Write("<table width=\"100%\" border=\"0\" cellspacing=\"0\" align=\"center\" cellpadding=\"2\"><tr><td align=\"right\" height=\"10\"></td></tr><tr><td align=\"right\"><div class=\"page\" style=\"float:right;\">");
            if (icount == 10)
            {
                pub.Page(curpage + 1, curpage, Pageurl, 10, 10 * (curpage + 1));
            }
            else
            {
                pub.Page(curpage, curpage, Pageurl, 10, 10 * curpage);
            }

            Response.Write("</div></td></tr></table>");
        }
        else
        {
            Response.Write("<tr bgcolor=\"#ffffff\"><td height=\"35\" colspan=\"7\" align=\"center\" valign=\"middle\">没有记录</td></tr>");
        }

        Response.Write("</table>");
    }
Пример #5
0
    public void GetProductTags()
    {
        string keyword      = tools.CheckStr(Request["keyword"]);
        int    tag_isactive = tools.CheckInt(Request["tag_isactive"]);
        int    i            = 0;
        string Pageurl;
        int    curpage = tools.CheckInt(tools.NullStr(Request["page"]));

        Pageurl = "?action=list";
        if (curpage < 1)
        {
            curpage = 1;
        }
        QueryInfo Query = new QueryInfo();

        Query.PageSize    = 10;
        Query.CurrentPage = curpage;
        if (tag_isactive == 1)
        {
            Query.ParamInfos.Add(new ParamInfo("AND", "int", "ProductTagInfo.Product_Tag_IsActive", "=", "1"));
        }
        else if (tag_isactive == 2)
        {
            Query.ParamInfos.Add(new ParamInfo("AND", "int", "ProductTagInfo.Product_Tag_IsActive", "=", "0"));
        }
        if (keyword.Length > 0)
        {
            Query.ParamInfos.Add(new ParamInfo("AND", "str", "ProductTagInfo.Product_Tag_Name", "like", keyword));
        }
        //Query.ParamInfos.Add(new ParamInfo("AND", "str", "ProductTagInfo.Product_Tag_Site", "=", pub.GetCurrentSite()));
        Query.ParamInfos.Add(new ParamInfo("AND", "int", "ProductTagInfo.Product_Tag_SupplierID", "=", tools.NullInt(Session["supplier_id"]).ToString()));
        Query.OrderInfos.Add(new OrderInfo("ProductTagInfo.Product_Tag_ID", "DESC"));

        //Response.Write("<table class=\"commontable\">");
        //Response.Write("<tr>");
        Response.Write("<table width=\"973\" cellpadding=\"0\" align=\"center\" cellspacing=\"2\" class=\"table02\" >");
        Response.Write("<tr>");
        Response.Write("  <td width=\"300\" class=\"name\">标签名称</td>");
        Response.Write("  <td width=\"223\"  class=\"name\">启用</td>");
        Response.Write("  <td width=\"225\"  class=\"name\">排序</td>");
        Response.Write("  <td width=\"225\"  class=\"name\">操作</td>");
        Response.Write("</tr>");

        IList <ProductTagInfo> entitys = MyBLL.GetProductTags(Query, pub.CreateUserPrivilege("ed87eb87-dade-4fbc-804c-c139c1cbe9c8"));
        PageInfo page = MyBLL.GetPageInfo(Query, pub.CreateUserPrivilege("ed87eb87-dade-4fbc-804c-c139c1cbe9c8"));

        if (entitys != null)
        {
            foreach (ProductTagInfo entity in entitys)
            {
                i++;

                if (i % 2 == 0)
                {
                    Response.Write("<tr class=\"bg\" >");
                }
                else
                {
                    Response.Write("<tr>");
                }

                Response.Write("<td>" + entity.Product_Tag_Name + "</td>");

                Response.Write("<td>");
                if (entity.Product_Tag_IsActive == 1)
                {
                    Response.Write("启用");
                }
                else
                {
                    Response.Write("关闭");
                }
                Response.Write("</td>");

                Response.Write("<td>");
                Response.Write(entity.Product_Tag_Sort);
                Response.Write("</td>");

                Response.Write("<td>");
                Response.Write("<span><a href=\"/supplier/tag_edit.aspx?product_tag_id=" + entity.Product_Tag_ID + "\" class=\"a12\">修改</a></span>");
                Response.Write(" <span><a href=\"/supplier/tag_do.aspx?action=del&product_tag_id=" + entity.Product_Tag_ID + "\">删除</a></span>");
                Response.Write("</td>");
                Response.Write("</tr>");
            }
            Response.Write("</table>");
            pub.Page(page.PageCount, page.CurrentPage, Pageurl, page.PageSize, page.RecordCount);
        }
        else
        {
            Response.Write("<table width=\"973\" cellpadding=\"0\" align=\"center\" cellspacing=\"2\" class=\"table02\" >");
            Response.Write("<tr><td  colspan=\"4\" align=\"center\" >没有记录</td></tr>");
            Response.Write("</table>");
        }
    }
Пример #6
0
    public void GetPromotionLimitis()
    {
        string page_url  = "";
        int    curr_page = tools.CheckInt(Request["page"]);

        if (curr_page < 1)
        {
            curr_page = 1;
        }
        page_url = "/Promotion/Promotioning.aspx?flag=1";
        int       i     = 0;
        QueryInfo Query = new QueryInfo();

        Query.PageSize    = 100;
        Query.CurrentPage = curr_page;
        Query.ParamInfos.Add(new ParamInfo("AND", "str", "PromotionLimitInfo.Promotion_Limit_Site", "=", "CN"));
        Query.ParamInfos.Add(new ParamInfo("AND", "funint", "DATEDIFF(s,{PromotionLimitInfo.Promotion_Limit_Starttime},'" + DateTime.Now + "')", ">=", "0"));
        Query.ParamInfos.Add(new ParamInfo("AND", "funint", "DATEDIFF(s,{PromotionLimitInfo.Promotion_Limit_Endtime},'" + DateTime.Now + "')", "<=", "0"));
        Query.OrderInfos.Add(new OrderInfo("PromotionLimitInfo.Promotion_Limit_Starttime", "ASC"));
        IList <PromotionLimitInfo> entitys = MyLimits.GetPromotionLimits(Query, pub.CreateUserPrivilege("22d21441-155a-4dc5-aec6-dcf5bdedd5cf"));
        PageInfo pageinfo = MyLimits.GetPageInfo(Query, pub.CreateUserPrivilege("22d21441-155a-4dc5-aec6-dcf5bdedd5cf"));

        if (entitys != null)
        {
            Response.Write(" <div id=\"webwrap\">");
            Response.Write(" <div class=\"blk01\">");
            Response.Write(" <ul class=\"lst1\">");
            foreach (PromotionLimitInfo entity in entitys)
            {
                i++;
                Response.Write("<li><p class=\"p1\" id=\"limit_tip_" + i + "\" name=\"limit_tip\">");

                TimeSpan span1 = entity.Promotion_Limit_Endtime - DateTime.Now;
                int      timespan;
                timespan = (span1.Days * (24 * 3600)) + (span1.Hours * 3600) + (span1.Minutes * 60) + (span1.Seconds);
                Response.Write("               ");

                Response.Write("<script>updatetime1(" + timespan + ",'limit_tip_" + i + "')</script>");
                Response.Write("</p>");
                ProductInfo productinfo = myproduct.GetProductByID(entity.Promotion_Limit_ProductID);
                if (productinfo != null)
                {
                    Response.Write("<a class=\"a2\" href=\"/Product/detail.aspx?Product_ID=" + entity.Promotion_Limit_ProductID + "\" target=\"_blank\" alt=\"" + productinfo.Product_Name + "\" title=\"" + productinfo.Product_Name + "\"><img src=\"" + pub.FormatImgURL(productinfo.Product_Img, "fullpath") + "\" width=\"170\" height=\"170\" onload=\"javascript:AutosizeImage(this,170,170);\"></a><p class=\"p2\"><a href=\"/Product/detail.aspx?Product_ID=" + entity.Promotion_Limit_ProductID + "\" target=\"_blank\" alt=\"" + productinfo.Product_Name + "\" title=\"" + productinfo.Product_Name + "\">" + productinfo.Product_Name + "</a></p>");
                    Response.Write("<p>原价:<span class=\"sp01\">¥" + pub.FormatCurrency(myproduct.Get_Member_Price(productinfo.Product_ID, productinfo.Product_Price)) + "</span></p>");
                }

                Response.Write(" <p>抢购价: <strong>" + pub.FormatCurrency(entity.Promotion_Limit_Price) + "</strong></p>");
                Response.Write("<a href=\"/Product/detail.aspx?Product_ID=" + entity.Promotion_Limit_ProductID + "\" target=\"_blank\" class=\"a1\"></a></li>");
            }
            Response.Write("</ul><div class=\"clear\"></div>");
            Response.Write("<div class=\"clear\"></div>");
            Response.Write("</div>");
            Response.Write("<table width=\"940px\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">");
            Response.Write("<tr><td height=\"10\"></td></tr>");
            Response.Write("<tr><td align=\"right\">");
            pub.Page(pageinfo.PageCount, pageinfo.CurrentPage, page_url, pageinfo.PageSize, pageinfo.RecordCount);
            Response.Write("</td></tr>");
            Response.Write("</table>");
            Response.Write("<div class=\"clear\"></div>");
            Response.Write("</div>");
        }
        else
        {
            Response.Write("<div style=\"width:960px; margin:0 auto; text-align:center; height:40px; line-height:40px;\">暂无相关信息</div>");
        }
    }