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()); } } } }
Copyright © 2004-2024 Ynicp.com 版权所有 法律顾问:建纬(昆明)律师事务所 昆明市网翼通科技有限公司 滇ICP备08002592号-4