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);
}
