protected void bindGoods() { string sql = "select * from TB_GoodsReturn with(nolock) where ReturnOrderId is null and ((Status in (6,15) and id in (" + GoodsIdStr + ")) or ChangeFlag in (" + GoodsIdStr + ")) order by ChangeFlag,id"; SqlHelper sp = LocalSqlHelper.WH; DataTable dt = null; string dingdan = string.Empty; int OrderType = 0; try { dt = sp.ExecDataTable(sql); } catch { JSHelper.WriteScript("alert('数据有误');history.back();"); Response.End(); } if (dt.Rows.Count > 0) { txtReceiver.Text = dt.Rows[0]["UserName"].ToString(); txtAddress.Text = dt.Rows[0]["UserAddress"].ToString(); txtProvince.Text = dt.Rows[0]["UserProvince"].ToString(); txtCity.Text = dt.Rows[0]["UserCity"].ToString(); txtTown.Text = dt.Rows[0]["UserTown"].ToString(); txtTel.Text = dt.Rows[0]["UserTel"].ToString(); txtAgentId.Text = dt.Rows[0]["AgentId"].ToString(); } OrderDetail.DataShow(dt); }
/// <summary> /// 订单商品 /// </summary> protected void bindGoods() { string sql = "select * from TB_GoodsReturn with(nolock) where ReturnOrderId='" + OrderId + "'"; SqlHelper sp = LocalSqlHelper.WH; DataTable dt = null; string dingdan = string.Empty; int OrderType = 0; try { dt = sp.ExecDataTable(sql); } catch { JSHelper.WriteScript("alert('数据有误');history.back();"); Response.End(); } OrderDetail.DataShow(dt); }