[WebMethod]
public string GetODR_BillDetail(string orderno)
{
string jsonResult = null;
DataTable dt = C_c.SelectT("select * from ODR_OrderMain where OrderNo='" + orderno + "' or TrackingNo='" + orderno + "' or Field1='" + orderno + "' or (ORDERREFNO!='' and ORDERREFNO='" + orderno + "')");
if (dt.Rows.Count > 0)
{
DataTable dtbill = C_c.SelectT("select * from ODR_BillDetail where ODR_OrderMainID='" + dt.Rows[0]["ODR_OrderMainID"].ToString() + " ' and Void_Flag='0'");
if (dtbill.Rows.Count > 0)
{
jsonResult = JsonConvert.SerializeObject(dtbill);
}
}
else
{}
return jsonResult;
}
数据库查出来的数据可直接JSON格式化
最新推荐文章于 2024-05-17 10:29:32 发布