stockclass.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;
using System.Data.SqlClient;

/// <summary>
/// stockClass 的摘要说明
/// </summary>
public class stockClass
{
    /// <summary>
    /// 计算进货数量
    /// </summary>
    /// <param name="cid">商品ID</param>
    /// <returns></returns>
    public int stock(int cid)
    {
        int stockNumber, returnNumber;
        SqlConnection strcon = new SqlConnection(ConfigurationManager.ConnectionStrings["SellOrder_ConnectionString"].ConnectionString);
        strcon.Open();
        SqlCommand scdc = new SqlCommand();
        scdc.Connection = strcon;
        scdc.CommandText = "select sum(Number) from 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 Stock where CommodityId=" + cid + " and Type='进货退货'";
        if (scdc.ExecuteScalar() is DBNull)
        {
            returnNumber = 0;
        }
        else
        {
            returnNumber = Convert.ToInt32(scdc.ExecuteScalar());//进货退货数量
        }
        return Convert.ToInt32(stockNumber - returnNumber);
    }
    /// <summary>
    /// 计算进货数量
    /// </summary>
    /// <param name="cid">商品ID</param>
    /// <returns></returns>
    public int sell(int cid)
    {
        int stockNumber, returnNumber;
        SqlConnection strcon = new SqlConnection(ConfigurationManager.ConnectionStrings["SellOrder_ConnectionString"].ConnectionString);
        strcon.Open();
        SqlCommand scdc = new SqlCommand();
        scdc.Connection = strcon;
        scdc.CommandText = "select sum(Number) from Stock where CommodityId=" + cid + " and Type='销售信息'";//该商品销售数量
        if (scdc.ExecuteScalar() is DBNull)//因为商品可能没有任何记录会返回空值，用DBNull判断一下
        {
            stockNumber = 0;//如果是空值手工赋值0
        }
        else
        {
            stockNumber = Convert.ToInt32(scdc.ExecuteScalar());//如果不为空则显示他的本值
        }
        scdc.CommandText = "select sum(Number) from Stock where CommodityId=" + cid + " and Type='销售退货'";//该商品销售退货数量
        if (scdc.ExecuteScalar() is DBNull)//因为商品可能没有任何记录会返回空值，用DBNull判断一下
        {
            returnNumber = 0;//如果是空值手工赋值0
        }
        else
        {
            returnNumber = Convert.ToInt32(scdc.ExecuteScalar());//如果不为空则显示他的本值
        }
        return Convert.ToInt32(stockNumber - returnNumber);//计算进货数量  销售－退货
    }
    /// <summary>
    /// 计算差额
    /// </summary>
    /// <param name="id">商品ID</param>
    /// <returns></returns>
    public int not(string id)
    {
        int payment;
        SqlConnection strcon = new SqlConnection(ConfigurationManager.ConnectionStrings["SellOrder_ConnectionString"].ConnectionString);
        strcon.Open();
        SqlCommand scd = new SqlCommand("select NotPayment from view_Reckoning where id=" + id + "", strcon);//查询未付款金额,查询的是视图
        int notpayment = Convert.ToInt32(scd.ExecuteScalar());
        scd.CommandText = "select sum(Settlement) as payment from 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;//定义bool
        for (int i = 0; i < str.Length; i++)//循环判断传入的字符串每个字符 如：str=asdfo89%^( 则要循环9次
        {
            strobj = str.Substring(i, 1);//读取字符串的值，如 i＝3 时 strobj＝d
            if (strobj == "%" || strobj == "&" || strobj == "'" || strobj == "|" || strobj == "<" || strobj == ">")//判断是否包含特殊符号||表示或者
            {
                ss = true;
                break;
            }
        }
        return ss;
    }
}