?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;
using System.Data.SqlClient;
//該源碼下載自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)

/// <summary>
/// stockClass 的摘要說明
/// </summary>
public class stockClass
{
	public stockClass()
	{
		//
		// TODO: 在此處添加構(gòu)造函數(shù)邏輯
		//
	}
    public int stock(int cid)
    {
        //計(jì)算進(jìn)貨數(shù)量
        int stockNumber, returnNumber;
        SqlConnection strcon = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["strcon"]);
        strcon.Open();
        SqlCommand scdc = new SqlCommand();
        scdc.Connection = strcon;
        scdc.CommandText = "select sum(Number) from tb_Stock where CommodityId=" + cid + " and Type='進(jìn)貨信息'";
        if (scdc.ExecuteScalar() is DBNull)
        {
            stockNumber = 0;
        }
        else
        {
            stockNumber = Convert.ToInt32(scdc.ExecuteScalar());//商品進(jìn)貨數(shù)量
        }
        scdc.CommandText = "select sum(Number) from tb_Stock where CommodityId=" + cid + " and Type='進(jìn)貨退貨'";
        if (scdc.ExecuteScalar() is DBNull)
        {
            returnNumber = 0;
        }
        else
        {
            returnNumber = Convert.ToInt32(scdc.ExecuteScalar());//進(jìn)貨退貨數(shù)量
        }
        return Convert.ToInt32(stockNumber - returnNumber);
    }
    public int sell(int cid)
    {
         //計(jì)算進(jìn)貨數(shù)量
        int stockNumber, returnNumber;
        SqlConnection strcon = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["strcon"]);
        strcon.Open();
        SqlCommand scdc = new SqlCommand();
        scdc.Connection = strcon;
        scdc.CommandText = "select sum(Number) from tb_Stock where CommodityId=" + cid + " and Type='銷售信息'";
        if (scdc.ExecuteScalar() is DBNull)
        {
            stockNumber = 0;
        }
        else
        {
            stockNumber = Convert.ToInt32(scdc.ExecuteScalar());
        }
        scdc.CommandText = "select sum(Number) from tb_Stock where CommodityId=" + cid + " and Type='銷售退貨'";
        if (scdc.ExecuteScalar() is DBNull)
        {
            returnNumber = 0;
        }
        else
        {
            returnNumber = Convert.ToInt32(scdc.ExecuteScalar());
        }
        return Convert.ToInt32(stockNumber - returnNumber);
    }
    public int not(string id)
    {
        int payment;
        SqlConnection strcon = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["strcon"]);
        strcon.Open();
        SqlCommand scd = new SqlCommand("select NotPayment from Reckoning where id=" + id, strcon);
        int notpayment = Convert.ToInt32(scd.ExecuteScalar());
        scd.CommandText = "select sum(Settlement) as payment from tb_Reckoning where CommodityId=" + id;
        if (scd.ExecuteScalar() is DBNull)
        {
            payment = 0;
        }
        else
        {
            payment = Convert.ToInt32(scd.ExecuteScalar());
        }
        int not = notpayment - payment;
        return not;
    }
    public bool validate(string str)
    {
        string strobj;
        bool ss=false;
        for (int i = 0; i < str.Length; i++)
        {
            strobj = str.Substring(i, 1);
            if (strobj == "%" || strobj == "&" || strobj == "'" || strobj == "|" || strobj == "<" || strobj == ">")
            {
                ss = true;
                break;
            }
        }
        return ss;
    }

}