初始化 System.Collections.ArrayList 类的新实例,该实例为空并且具有指定的初始容量,datatable单独取值

new一个ArrayList
在这里插入图片描述

protected ArrayList values = new ArrayList();

        protected void Page_Load(object sender, EventArgs e)
        {
            string reurl = Request.Url.ToString();//获取当前url
            CookieHelper.WriteCookie("returnurl", reurl);//把返回信息写入cookies
            bool r = wxhelper.checkLogin();//wxhelper.checkLogin() 该函数会自动去获得用户openid 获得openid后需要返回当前入口页面 reurl 就是获得openid后的入口页面
            string kk = "";
            string openidde = CookieHelper.GetCookie("openid"); 
            string sql = "select tell from jydUser where OpenID='" + openidde + "' and tell<>'' ";
            DataRow dr = SqlEasy.ExecuteDataRow(sql);
            //if(dr == null) { 
            //Context.Response.End("<script>alert('手机绑定之后才可进行查询订单');location.href='http://szh.s3.natapp.cc/weixin/bindyg.aspx';</script>");
            //}
            //else
            //{
            //    de = SqlEasy.ExecuteDataTable("select orderid from jydOrder where tel='" + dr["tell"].ToString() + "' group by orderid order by orderid desc");
            //}
            if (dr == null)
            {

            }
            else
            {
                string sqlyi = "select orderid from jydOrder where tel='" + dr["tell"].ToString() + "' group by orderid order by orderid desc";
                de = SqlEasy.ExecuteDataTable(sqlyi);

                 zt = SqlEasy.ExecuteDataTable("select * from jydOrder where tel='" + dr["tell"].ToString() + "' order by orderid desc");
                foreach (DataRow ztt in zt.Rows)
                {
                    if (zt.Rows.Count > 0)
                    {
                        sta = zt.Rows[0]["status"].ToString();
                    }
                }


                foreach (DataRow drw in de.Rows)
                {
                    string[] odArr = drw["orderid"].ToString().Split('-');
                    if (odArr.Length == 4)
                    {
                        dw = SqlEasy.ExecuteDataTable("select yspmc,orderid from jydOrderDetail where orderid='" + drw["orderid"].ToString() + "' order by KeyId desc");
                        for (int i = 0; i < dw.Rows.Count; i++)
                        {
                            values.Add(dw.Rows[i]["yspmc"].ToString() + "," + dw.Rows[i]["orderid"].ToString());
                        }
                    }
                }
            }

要循环的句子放进去用逗号分开
在这里插入图片描述

 if (dr == null)
            {

            }
            else
            {
                string sqlyi = "select orderid from jydOrder where tel='" + dr["tell"].ToString() + "' group by orderid order by orderid desc";
                de = SqlEasy.ExecuteDataTable(sqlyi);

                 zt = SqlEasy.ExecuteDataTable("select * from jydOrder where tel='" + dr["tell"].ToString() + "' order by orderid desc");
                foreach (DataRow ztt in zt.Rows)
                {
                    if (zt.Rows.Count > 0)
                    {
                        sta = zt.Rows[0]["status"].ToString();
                    }
                }


                foreach (DataRow drw in de.Rows)
                {
                    string[] odArr = drw["orderid"].ToString().Split('-');
                    if (odArr.Length == 4)
                    {
                        dw = SqlEasy.ExecuteDataTable("select yspmc,orderid from jydOrderDetail where orderid='" + drw["orderid"].ToString() + "' order by KeyId desc");
                        for (int i = 0; i < dw.Rows.Count; i++)
                        {
                            values.Add(dw.Rows[i]["yspmc"].ToString() + "," + dw.Rows[i]["orderid"].ToString());
                        }
                    }
                }
            }
           

前台调用进行拆分
在这里插入图片描述

<% string myzt = sta; %>
            <%if (values != null)
                {%>
            <%for (int i = 0; i < values.Count; i++)
                {
                    string[] strArr = values[i].ToString().Split(',');
            %>
            <label class="weui-cell weui-check__label">
                <div class="weui-cell__bd">
                    <p>
                        印刷品名称:<span><%=strArr[0] %></span> <br>
                    订单号:<span><%=strArr[1] %></span>
                    </p>
                    <input class="weui-btn weui-btn_mini weui-btn_primary" onclick="caozuo('<%=strArr[1] %>')" type="button" value="催单" />

                </div>
            </label>
            
            <%} %>
            <% } %>
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值