sum.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>
/// Sum 的摘要说明
/// </summary>
public class Sum
{
	public Sum()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    public static DataTable GetKeep() //返回仓库数据集
    {
        SqlDataBase MyDb = new SqlDataBase();
        return MyDb.DT("select ID,KeepName from KeepNum");
    }
    public static DataTable GetKeepsNum(int UserID)//返回用户所管理的仓库 
    {
        SqlDataBase MyDb = new SqlDataBase();
        return MyDb.DT("select Controls,GoodsType from UserList Where ID = '" + UserID + "'");
    }
    public static string GetKeepsName(int KeepID) 
    {
        SqlDataBase MyDb = new SqlDataBase();
        return MyDb.ReturnSQL("select KeepName from KeepNum where ID ='" + KeepID + "'");
    }
    public DataTable GetUserGlist(int UserID) 
    {
        SqlDataBase MyDb = new SqlDataBase();
        DataTable MyDt = (DataTable)MyDb.DT("select * from UserList Where ID = '"+UserID+"'");
        string UserType = Convert.ToString(MyDt.Rows[0]["UserType"]);
        string UserKeep = Convert.ToString(MyDt.Rows[0]["Controls"]);
        string GiveSqlString = "";
        if (UserType == "1" || UserKeep=="0")
        {
            GiveSqlString = "select * from View_Dao";
        }
        else 
        {
            GiveSqlString = "select * from View_Dao Where KeepID = '" + UserKeep + "'";
        }
        return (DataTable)MyDb.DT(GiveSqlString);
    }
}