?? stockclass.cs
字號(hào):
?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(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;
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -