goodsreserve.aspx.cs

比较完整的仓库管理系统 大家都看看 希望对你们有帮助吧

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Configuration ;
using System.Data .SqlClient ;

namespace WMS
{
	/// <summary>
	/// GoodsReserve 的摘要说明。
	/// </summary>
	public class GoodsReserve : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.HyperLink hlk_default;
		protected System.Web.UI.WebControls.DropDownList ddl_gid;
		protected System.Web.UI.WebControls.TextBox tbx_squantity;
		protected System.Web.UI.WebControls.RadioButton rbn_in;
		protected System.Web.UI.WebControls.TextBox tbx_maxout;
		protected System.Web.UI.WebControls.TextBox tbx_maxin;
		protected System.Web.UI.WebControls.TextBox tbx_quantity;
		protected System.Web.UI.WebControls.TextBox tbx_stopline;
		protected System.Web.UI.WebControls.Label lbl_uid;
		protected System.Web.UI.WebControls.Button btn_submit;
		protected System.Web.UI.WebControls.RangeValidator rv_quantity;
		protected System.Web.UI.WebControls.HyperLink hlk_passwordmodify;
		protected System.Web.UI.WebControls.TextBox tbx_handler;
		protected System.Web.UI.WebControls.RequiredFieldValidator rfv_handler;
		protected System.Web.UI.WebControls.RadioButton rbn_out;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			if(!IsPostBack)
			{
				//从文件Web.config中读取连接字符串
				string strconn= ConfigurationSettings.AppSettings["dsn"];
				//绑定货物信息
				//连接本地计算机的WMS数据库
				SqlConnection cn1= new SqlConnection (strconn);
				cn1.Open ();
				//SQL语句，找出所有存放在当前用户工作仓库的所有货品
				string mysql="select * from goods,store where sgid=gid and swid="+Session["udep"].ToString ()+"order by gid desc";
				SqlCommand cm1=new SqlCommand  (mysql,cn1);
				SqlDataReader dr1=cm1.ExecuteReader ();
				while(dr1.Read ())
				{
					ddl_gid.Items .Add (new ListItem(dr1["gname"].ToString(),dr1["gid"].ToString()) );
				}
				cn1.Close ();
				lbl_uid.Text =Session["uid"].ToString ();
				BindTextBox();
			}
		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.ddl_gid.SelectedIndexChanged += new System.EventHandler(this.ddl_gid_SelectedIndexChanged);
			this.rbn_in.CheckedChanged += new System.EventHandler(this.rbn_in_CheckedChanged);
			this.rbn_out.CheckedChanged += new System.EventHandler(this.rbn_out_CheckedChanged);
			this.btn_submit.Click += new System.EventHandler(this.btn_submit_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void ddl_gid_SelectedIndexChanged(object sender, System.EventArgs e)
		{	
			BindTextBox();
		}

		private void btn_submit_Click(object sender, System.EventArgs e)
		{
			if(Page.IsValid )
			{//从文件Web.config中读取连接字符串
				string strconn= ConfigurationSettings.AppSettings["dsn"];
				//连接本地计算机的WMS数据库
				SqlConnection cn= new SqlConnection (strconn);
				cn.Open ();
				//以下对Store表中的物品数量进行改变
				//利用Command对象调用存储过程
				SqlCommand cm=new SqlCommand  ("storereservemodify",cn);
				//将命令类型转为存储类型
				cm.CommandType =CommandType.StoredProcedure ;
				//往存储过程中添加参数
				cm.Parameters .Add ("@SGID",SqlDbType.Int );
				cm.Parameters .Add ("@SWID",SqlDbType.Int );
				cm.Parameters .Add ("@SQuantity",SqlDbType.Float );
				//给存储过程的参数付值
				cm.Parameters ["@SGID"].Value =ddl_gid.SelectedItem .Value  .ToString ();
				cm.Parameters ["@SWID"].Value =Session["udep"] .ToString ();
				if(rbn_in.Checked )//货物入仓
				{
					cm.Parameters ["@SQuantity"].Value =Convert.ToDouble (tbx_squantity.Text .ToString ())+Convert.ToDouble (tbx_quantity.Text .ToString ());
				}
				if(rbn_out.Checked )//货物出仓
				{
					cm.Parameters ["@SQuantity"].Value =Convert.ToDouble (tbx_squantity.Text .ToString ())-Convert.ToDouble (tbx_quantity.Text .ToString ());
				}
				
				cm.ExecuteNonQuery ();
				//关闭连接
				cn.Close();
				//以下往仓库进出货物纪录表中增加数据
				SqlConnection cn1= new SqlConnection (strconn);
				cn1.Open ();
				SqlCommand cm1=new SqlCommand  ("recordsadd",cn1);
				cm1.CommandType =CommandType.StoredProcedure ;
				cm1.Parameters .Add ("@RGID",SqlDbType.Int );
				cm1.Parameters .Add ("@RWID",SqlDbType.Int );
				cm1.Parameters .Add ("@RQuantity",SqlDbType.Float );
				cm1.Parameters .Add ("@RType",SqlDbType.Bit );
				cm1.Parameters .Add ("@RManager",SqlDbType.VarChar );
				cm1.Parameters .Add ("@RDate",SqlDbType.DateTime );
				cm1.Parameters .Add ("@RHandler",SqlDbType.VarChar  );
				cm1.Parameters ["@RGID"].Value =ddl_gid.SelectedItem .Value  .ToString ();
				cm1.Parameters ["@RWID"].Value =Session["udep"] .ToString ();
				cm1.Parameters ["@RQuantity"].Value =tbx_quantity.Text .ToString ();
				if(rbn_in.Checked )//货物入仓,设1 
				{
					cm1.Parameters ["@RType"].Value =1;
				}
				if(rbn_out.Checked )//货物出仓。设0
				{
					cm1.Parameters ["@RType"].Value =0;
				}
				cm1.Parameters ["@RManager"].Value =Session["UID"] .ToString ();
				cm1.Parameters ["@RDate"].Value =System.DateTime .Now;
				cm1.Parameters ["@RHandler"].Value =tbx_handler.Text .ToString ();
                cm1.ExecuteNonQuery ();

				BindTextBox();
			}

		}

		private void rbn_out_CheckedChanged(object sender, System.EventArgs e)
		{
			if(rbn_in.Checked )//货物入仓
			{
				rv_quantity.MaximumValue =tbx_maxin.Text.ToString ();
			}
			if(rbn_out.Checked )//货物出仓
			{
				rv_quantity.MaximumValue =tbx_maxout.Text.ToString ();
			}
		}
		private void rbn_in_CheckedChanged(object sender, System.EventArgs e)
		{
			if(rbn_in.Checked )//货物入仓
			{
				rv_quantity.MaximumValue =tbx_maxin.Text.ToString ();
			}
			if(rbn_out.Checked )//货物出仓
			{
				rv_quantity.MaximumValue =tbx_maxout.Text.ToString ();
			}
		}
		public void BindTextBox()
		{
			//从文件Web.config中读取连接字符串
			string strconn= ConfigurationSettings.AppSettings["dsn"];
			//连接本地计算机的WMS数据库
			SqlConnection cn= new SqlConnection (strconn);
			cn.Open ();
			SqlCommand cm=new SqlCommand  ("storedetail",cn);
			cm.CommandType =CommandType .StoredProcedure ;
			cm.Parameters .Add ("@SGID",SqlDbType.Int );
			cm.Parameters ["@SGID"].Value =Convert.ToInt32 (ddl_gid.SelectedItem .Value .ToString ());
			SqlDataReader dr=cm.ExecuteReader ();
			if(dr.Read ())//存在对应项
			{
				tbx_stopline.Text =dr["stopline"].ToString ();
				tbx_squantity.Text =dr["squantity"].ToString ();
				tbx_maxout.Text=dr["squantity"].ToString ();
				tbx_maxin.Text=Convert.ToString (Convert.ToDouble (dr["stopline"].ToString ())-Convert.ToDouble (dr["squantity"].ToString ()));
			}
			else
			{
				Response.Write ("对不起，没有该产品信息");
				Response.End ();
			}
			if(rbn_in.Checked )//货物入仓
			{
				rv_quantity.MaximumValue =tbx_maxin.Text.ToString ();
			}
			if(rbn_out.Checked )//货物出仓
			{
				rv_quantity.MaximumValue =tbx_maxout.Text.ToString ();
			}
		}
	}
}