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>
<%} %>
<% } %>