JS调用服务端显示查询数据_js中dbparameter-CSDN博客

本文链接：https://blog.csdn.net/tao19840705/article/details/5839415

本文介绍了一个使用ASP.NET Web API实现的获取库存信息的后台接口，包括请求参数解析、数据库查询和响应数据生成。通过实例展示了如何获取指定商品在特定店铺的库存详情。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

function GetData(url){
       var xhttp = new window.XMLHttpRequest;
       xhttp.open("post",url, false);
       xhttp.send();
       return xhttp.responseText;
}
function GetKC(sptr)//获取库存
{
        var i ;
        var dllbranchno = document.getElementById("dllpayway").options[document.getElementById("dllpayway").selectedIndex].value;
        parm="?type=PDShop&"+
               "value1=" + sptr.cells[3].innerText + "&" +
               "value2=" + dllbranchno + "&" +
               "t=" + (new Date).getTime();
        dat=GetData("GetSpKc.aspx" + parm);
        return dat;
}

GetSpKc.aspx page code

public partial class SaleOrder_GetSpKc : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        String type = "";
        if (this.Request.QueryString["type"] != null)
        {
            type = this.Request.QueryString["type"];
        }
        switch (type)
        {
            case "PDShop":
                HandPDData();
                break;
        }
        Response.End();
    }
    //返回指定商品的库存
    private void HandPDData()
    {
       // int i = 0;
        string itemno = Request.QueryString["value1"];
        string branch = Request.QueryString["value2"];
        DbCommand cmd = GenericDataAccess.createcommand();
        cmd.CommandText = "Get_Item_Store";
        DbParameter parm = cmd.CreateParameter();
        parm.ParameterName = "@kp_item_no";
        parm.Value = itemno;
        parm.DbType = DbType.String;
        cmd.Parameters.Add(parm);

        parm = cmd.CreateParameter();
        parm.ParameterName = "@branch";
        parm.Value = branch;
        parm.DbType = DbType.String;
        cmd.Parameters.Add(parm);

        DataTable tb = GenericDataAccess.selectcommand(cmd);
        if (tb.Rows.Count > 0)
        {
            Response.Write("<table style=' border:1px solid black border-collapse:collapse'   font-size='10pt'   text-align='right' width='545px' bordercolor='black'><caption align='center' border='1'>商品库存信息</caption><tr>");
            for (int i=0; i <tb.Columns .Count;i++)
            {
                Response.Write("<td style='border:1px solid black; border-collapse:collapse'>");
                Response.Write(tb.Columns[i].ColumnName.ToString());
                Response.Write("</td>");
            }
            Response.Write("</tr>");

            for (int k = 0; k < tb .Rows .Count; k++)
            {
                Response.Write("<tr>");
                for(int j = 0; j < tb .Columns .Count; j++)
                {
                    Response.Write("<td style='border:1px solid black; border-collapse:collapse'>");
                    Response.Write(Convert.ToString(tb.Rows[k].ItemArray[j]));
                    Response.Write("</td>");
                }
               Response.Write("</tr>");
            }
            //Response.Write("</tr>");
            Response.Write("</table>");
        }
        else
        {
            Response.Write("0");

        }

}
}