admin.cs

Asp.net物资流通管理系统源码 本系统主要针对物流供应链中的库存管理环节

using System;
using System.Data;
using System.Data.SqlClient;
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>
/// admin 的摘要说明
/// </summary>
public class admin
{
	public admin()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    public void InsertSystemT(string Tital,string Count)
    {
        string Dtime = DateTime.Now.ToString();
        string MySql = "Insert Into SystemTest(Tatile,Counts,InputTime,TestType) Values('" + Tital + "','" + Count + "','" + Dtime + "','0')";
        SqlDataBase MyDb = new SqlDataBase();
        MyDb.NoreturnSql(MySql);
    }
    public static void InsertBigCl(string BigNam)//添加大类
    {
        SqlDataBase MyDb1 = new SqlDataBase();
        MyDb1.NoreturnSql("Insert Into BigClass(GoodsName) Values('" + BigNam + "')");
    }
    public static DataTable GetKeepG()//获得货架个数
    {
        SqlDataBase MyDb = new SqlDataBase();
        return MyDb.DT("select ID,GoodClass from KeepNum");
    }
    public static void InsertGds(string GoodN, string GoodNam, string TopNum, string EndNum, string AlignGoodC, string AlignKeeps, string AlignType) 
    {
        SqlDataBase MyDb = new SqlDataBase();
        MyDb.NoreturnSql("Insert into AllGood(GoodsNum,GoodsName,TopNum,EndNum,AlignGoodC,AlignKeeps,AlignType)Values('" + GoodN + "','" + GoodNam + "','" + TopNum + "','" + EndNum + "','" + AlignGoodC + "','" + AlignKeeps + "','" + AlignType + "')");
    }
}