App_Code/PData.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

/// <summary>
/// PData 的摘要说明
/// </summary>
public class PData
{
    DataBase db = new DataBase();
	public PData()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}

    public float Y_Price(string yno)
    {
        float price = 0.0f;
        DataSet ds = db.Getdata("select * from yp where yno='"+yno+"'");
        DataRow[] dr = ds.Tables[0].Select();
        foreach (DataRow dw in dr)
        {
            price =float.Parse(dw["price"].ToString());
        }
        return price;
    }
    public int Y_Number(string yno,string cno)
    {
        int number = 0;
        DataSet ds = db.Getdata("select * from kc where yno='" + yno + "' and cno='"+cno+"'");
        DataRow[] dr = ds.Tables[0].Select();
        foreach (DataRow dw in dr)
        {
            number = int.Parse(dw["total"].ToString());
        }
        return number;
    }
}