C#进销存系统源码(仓库管理)

【实例简介】

XRD仓库管理系统源码

源码描述：
一、源码特点
    仓库管理、后台管理、登陆验证、div css、登陆注册等
二、功能介绍
    此系统包括用户登录注册，用户，仓库，货物等基本信息的添加、修改、删除、查询；货物的进货、出货管理等，以及紧急货物采购提醒等一系列仓库管理所涉及的方面。
三、菜单功能
    1、登陆
    2、个人信息管理：添加人员信息；修改人员信息
    3、仓库信息管理：添加仓库信息；修改仓库信息
    4、存储规则管理：添加存储规则；修改存储规则
    5、查看进出信息：查看入库登陆信息；浏览出库登记信息
    6、货物信息管理：添加货物信息；修改货物信息
    7、个人密码修改
    8、返回登陆界面
四、注意事项
    1、开发环境为Visual Studio 2010，数据库为SQLServer2012，使用.net 3.5开发。数据库连接文件：App_Code/WMS.cs
    2、管理员登陆名密码均为:admin 

【实例截图】

【核心代码】

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class AddInOut : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            bindData();
        }
    }
    private void bindData()
    {
        string st = "select * from Goods,Store where Goods.GID=Store.SGID and SWID='" Session["Udep"].ToString() "'order by GID desc";
        SqlConnection con = WMS.createCon();
        con.Open();
        SqlCommand da = new SqlCommand(st, con);
        SqlDataReader cn = da.ExecuteReader();
        while(cn.Read())
        {
            DropDownList1.Items.Add(new ListItem (cn["GID"].ToString()));
        }
        con.Close();
        BindTextBox();
    }
    private void BindTextBox()
    {
        string st1 = "select SQuantity,STopLine from Store where SGID='"   DropDownList1.Text  "'";
        SqlConnection con = WMS.createCon();
        con.Open();
        SqlCommand da = new SqlCommand(st1, con);
        SqlDataReader dr = da.ExecuteReader();
        if (dr.Read())
        {
            TextBox2.Text = dr["SQuantity"].ToString();
            TextBox3.Text = dr["STopLine"].ToString();
            TextBox4.Text = dr["SQuantity"].ToString();
            TextBox5.Text = Convert.ToString(int.Parse(TextBox3.Text) - int.Parse(TextBox2.Text));
        }
        else
        {
            Response.Write("<script language=javascript>alert('对不起，没有该产品信息')</script>");
        }
        if (RadioButton1.Checked == true)
        {
            RangeValidator1.MaximumValue = TextBox5.Text;
            RangeValidator1.MinimumValue = "0";
        }
        if (RadioButton2.Checked == true)
        {
            RangeValidator1.MaximumValue = TextBox4.Text;
            RangeValidator1.MinimumValue ="0";
        }
    }
    // 下载于www.mycodes.net
    protected void Button1_Click1(object sender, EventArgs e)
    {
        string newSQuantity;
        string str1 = "insert into Records(RGID,RWID,RQuantity,Rtype,RHandler) values ('"   DropDownList1.Text   "','"   Session["Udep"].ToString()   "','"   TextBox6.Text   "',' 1 ','"   TextBox7.Text   "')";
        string str2 = "insert into Records(RGID,RWID,RQuantity,Rtype,RHandler) values ('"   DropDownList1.Text   "','"   Session["Udep"].ToString()   "','"   TextBox6.Text   "',' 2 ','"   TextBox7.Text   "')";
        
        SqlConnection con = WMS.createCon();
        con.Open();
        if (RadioButton1.Checked == true)
        {
            SqlCommand comm = new SqlCommand(str1,con);
            comm.ExecuteNonQuery();
            con.Close();
        }
        if (RadioButton2.Checked == true)
        {
            SqlCommand comm = new SqlCommand(str2, con);
            comm.ExecuteNonQuery();
            con.Close();
        }
       
        SqlConnection cn = WMS.createCon();
        cn.Open();
        if (RadioButton1.Checked == true)
        {
            newSQuantity = Convert.ToString(int.Parse(TextBox2.Text)   int.Parse(TextBox6.Text));
            string str3 = "update Store set SQuantity='"   newSQuantity   " 'where SGID='"   DropDownList1.Text   "'";
            SqlCommand com = new SqlCommand(str3, cn);
            com.ExecuteNonQuery();
            cn.Close();
            Response.Write("<script language='javascript'>alert('入库信息添加成功！');</script>");
        }
        if (RadioButton2.Checked == true)
        {
            newSQuantity = Convert.ToString(int.Parse(TextBox2.Text) - int.Parse(TextBox6.Text));
            string str3 = "update Store set SQuantity='"   newSQuantity   " 'where SGID='"   DropDownList1.Text   "'";
            SqlCommand com = new SqlCommand(str3, cn);
            com.ExecuteNonQuery();
            cn.Close();
            Response.Write("<script language='javascript'>alert('出库信息添加成功！');</script>");
        }
        BindTextBox();             
    }

    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        BindTextBox();
    }
}