sellform.cs

超市管理系统的完整版文档

			// 
			// m_txtGoodsInfoCode
			// 
			this.m_txtGoodsInfoCode.Location = new System.Drawing.Point(96, 32);
			this.m_txtGoodsInfoCode.Name = "m_txtGoodsInfoCode";
			this.m_txtGoodsInfoCode.TabIndex = 6;
			this.m_txtGoodsInfoCode.Text = "";
			// 
			// label10
			// 
			this.label10.Location = new System.Drawing.Point(32, 120);
			this.label10.Name = "label10";
			this.label10.Size = new System.Drawing.Size(48, 16);
			this.label10.TabIndex = 5;
			this.label10.Text = "备注";
			// 
			// label9
			// 
			this.label9.Location = new System.Drawing.Point(360, 80);
			this.label9.Name = "label9";
			this.label9.Size = new System.Drawing.Size(32, 16);
			this.label9.TabIndex = 4;
			this.label9.Text = "库存";
			// 
			// label8
			// 
			this.label8.Location = new System.Drawing.Point(216, 80);
			this.label8.Name = "label8";
			this.label8.Size = new System.Drawing.Size(48, 16);
			this.label8.TabIndex = 3;
			this.label8.Text = "数量";
			// 
			// label7
			// 
			this.label7.Location = new System.Drawing.Point(32, 72);
			this.label7.Name = "label7";
			this.label7.Size = new System.Drawing.Size(48, 23);
			this.label7.TabIndex = 2;
			this.label7.Text = "单价";
			// 
			// label6
			// 
			this.label6.Location = new System.Drawing.Point(216, 40);
			this.label6.Name = "label6";
			this.label6.Size = new System.Drawing.Size(56, 16);
			this.label6.TabIndex = 1;
			this.label6.Text = "名称";
			// 
			// label5
			// 
			this.label5.Location = new System.Drawing.Point(32, 32);
			this.label5.Name = "label5";
			this.label5.Size = new System.Drawing.Size(48, 23);
			this.label5.TabIndex = 0;
			this.label5.Text = "条码";
			// 
			// m_goodsList
			// 
			this.m_goodsList.AllowColumnReorder = true;
			this.m_goodsList.Columns.AddRange(new System.Windows.Forms.ColumnHeader[] {
																						  this.columnHeader1,
																						  this.columnHeader2,
																						  this.columnHeader3,
																						  this.columnHeader4,
																						  this.columnHeader5,
																						  this.columnHeader6,
																						  this.columnHeader7,
																						  this.columnHeader8,
																						  this.columnHeader9,
																						  this.columnHeader10,
																						  this.columnHeader11});
			this.m_goodsList.Font = new System.Drawing.Font("宋体", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.m_goodsList.FullRowSelect = true;
			this.m_goodsList.Location = new System.Drawing.Point(32, 104);
			this.m_goodsList.Name = "m_goodsList";
			this.m_goodsList.Size = new System.Drawing.Size(816, 216);
			this.m_goodsList.TabIndex = 13;
			this.m_goodsList.View = System.Windows.Forms.View.Details;
			this.m_goodsList.Leave += new System.EventHandler(this.m_goodsList_Leave);
			this.m_goodsList.Enter += new System.EventHandler(this.m_goodsList_Enter);
			this.m_goodsList.SelectedIndexChanged += new System.EventHandler(this.m_goodsList_SelectedIndexChanged);
			// 
			// columnHeader1
			// 
			this.columnHeader1.Text = "序号";
			this.columnHeader1.Width = 55;
			// 
			// columnHeader2
			// 
			this.columnHeader2.Text = "商品条码";
			this.columnHeader2.Width = 121;
			// 
			// columnHeader3
			// 
			this.columnHeader3.Text = "商品名称";
			this.columnHeader3.Width = 102;
			// 
			// columnHeader4
			// 
			this.columnHeader4.Text = "单价（元）";
			this.columnHeader4.TextAlign = System.Windows.Forms.HorizontalAlignment.Right;
			this.columnHeader4.Width = 80;
			// 
			// columnHeader5
			// 
			this.columnHeader5.Text = "数量";
			this.columnHeader5.TextAlign = System.Windows.Forms.HorizontalAlignment.Right;
			this.columnHeader5.Width = 64;
			// 
			// columnHeader6
			// 
			this.columnHeader6.Text = "计量单位";
			this.columnHeader6.Width = 74;
			// 
			// columnHeader7
			// 
			this.columnHeader7.Text = "小计(元)";
			this.columnHeader7.TextAlign = System.Windows.Forms.HorizontalAlignment.Right;
			this.columnHeader7.Width = 74;
			// 
			// columnHeader8
			// 
			this.columnHeader8.Text = "备注";
			this.columnHeader8.Width = 324;
			// 
			// columnHeader9
			// 
			this.columnHeader9.Text = "库存";
			this.columnHeader9.Width = 0;
			// 
			// columnHeader10
			// 
			this.columnHeader10.Text = "进价";
			this.columnHeader10.Width = 0;
			// 
			// columnHeader11
			// 
			this.columnHeader11.Text = "商品编号";
			this.columnHeader11.Width = 0;
			// 
			// m_bntClearAll
			// 
			this.m_bntClearAll.Location = new System.Drawing.Point(376, 24);
			this.m_bntClearAll.Name = "m_bntClearAll";
			this.m_bntClearAll.Size = new System.Drawing.Size(64, 23);
			this.m_bntClearAll.TabIndex = 14;
			this.m_bntClearAll.Text = "清空列表";
			this.m_bntClearAll.Click += new System.EventHandler(this.m_bntClearAll_Click);
			// 
			// m_txtCustomName
			// 
			this.m_txtCustomName.Enabled = false;
			this.m_txtCustomName.Location = new System.Drawing.Point(344, 64);
			this.m_txtCustomName.Name = "m_txtCustomName";
			this.m_txtCustomName.Size = new System.Drawing.Size(72, 21);
			this.m_txtCustomName.TabIndex = 15;
			this.m_txtCustomName.Text = "";
			// 
			// m_bntBrowse
			// 
			this.m_bntBrowse.Location = new System.Drawing.Point(432, 64);
			this.m_bntBrowse.Name = "m_bntBrowse";
			this.m_bntBrowse.Size = new System.Drawing.Size(40, 23);
			this.m_bntBrowse.TabIndex = 16;
			this.m_bntBrowse.Text = "验证";
			this.m_bntBrowse.Click += new System.EventHandler(this.m_bntBrowse_Click);
			// 
			// SellForm
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(928, 542);
			this.Controls.Add(this.m_bntBrowse);
			this.Controls.Add(this.m_txtCustomName);
			this.Controls.Add(this.m_bntClearAll);
			this.Controls.Add(this.groupBox1);
			this.Controls.Add(this.m_txtDebtMoney);
			this.Controls.Add(this.label4);
			this.Controls.Add(this.label3);
			this.Controls.Add(this.m_chkIsDebt);
			this.Controls.Add(this.label2);
			this.Controls.Add(this.m_txtTotalMoney);
			this.Controls.Add(this.m_bntCancelGoods);
			this.Controls.Add(this.label1);
			this.Controls.Add(this.m_txtgoodscode);
			this.Controls.Add(this.m_bntSell);
			this.Controls.Add(this.m_goodsList);
			this.Name = "SellForm";
			this.Text = "商品销售";
			this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
			this.Load += new System.EventHandler(this.SellForm_Load);
			this.groupBox1.ResumeLayout(false);
			this.ResumeLayout(false);

		}
		#endregion

		private void label1_Click(object sender, System.EventArgs e)
		{
		 
		}

		private void m_txtgoodscode_TextChanged(object sender, System.EventArgs e)
		{
	
		}

		private void label2_Click(object sender, System.EventArgs e)
		{
		
		}

		private void label4_Click(object sender, System.EventArgs e)
		{
		
		}

		private void comboBox1_SelectedIndexChanged(object sender, System.EventArgs e)
		{
		
		}

		private void textBox2_TextChanged(object sender, System.EventArgs e)
		{
		
		}

		private void m_txtgoodscode_KeyPress(object sender, System.Windows.Forms.KeyPressEventArgs e)
		{

		   if (e.KeyChar != 13 && e.KeyChar != 8 && e.KeyChar!=22 && (e.KeyChar < '0'|| e.KeyChar > '9'))
			{				
				e.Handled = true;
			}

			if(e.KeyChar == 13)
			{  
			   e.Handled = true;
			   OnGoodsCodeEnter();
			}

		}

		private void m_txtgoodscode_KeyDown(object sender, System.Windows.Forms.KeyEventArgs e)
		{
	
		}

		private void OnGoodsCodeEnter()
		{
			string enterGoodsCode = m_txtgoodscode.Text;
            
			int count = this.m_goodsList.Items.Count;
            


			try
			{
				SqlConnection conn = DBUtil.GetConnection();

				SqlCommand command = new SqlCommand ("select * from goods where GoodsCode='"+enterGoodsCode+"'",conn);
				command.Connection.Open();

				SqlDataReader  readerset = command.ExecuteReader();
				
				if(readerset.Read())
				{

				  NumberFormatInfo nfi = new CultureInfo( "en-US", false ).NumberFormat;
				  nfi.NumberDecimalDigits = 2;

				  m_txtGoodsInfoCode.Text = readerset["GoodsCode"].ToString();
				  m_txtGoodsInfoName.Text = readerset["Goodsname"].ToString();

				  double temp = System.Convert.ToDouble(readerset["SalePrice"]);
				  m_txtGoodsInfoPrice.Text = temp.ToString("N",nfi);
				  m_txtGoodsInfoStock.Text = readerset["StockNumber"].ToString();
				  m_txtGoodsInfoRemark.Text = readerset["Remark"].ToString();
				  m_txtGoodsInfoNumber.Text = "1";
				  m_labelGoodsUnit.Text = readerset["Unit"].ToString();
                   
				  ListViewItem item1 = new ListViewItem(nextGoodsID.ToString(),nextGoodsID-1);
				 
				  item1.SubItems.Add(m_txtGoodsInfoCode.Text);
				  item1.SubItems.Add(m_txtGoodsInfoName.Text);
				  item1.SubItems.Add(m_txtGoodsInfoPrice.Text.ToString());
				  item1.SubItems.Add(m_txtGoodsInfoNumber.Text);
				  item1.SubItems.Add(m_labelGoodsUnit.Text);
                  int num =   System.Convert.ToInt32(m_txtGoodsInfoNumber.Text);
				  double total = System.Convert.ToDouble(m_txtGoodsInfoPrice.Text) * num;
				  item1.SubItems.Add(total.ToString("N",nfi));
				  item1.SubItems.Add(m_txtGoodsInfoRemark.Text);
				  item1.SubItems.Add(m_txtGoodsInfoStock.Text);

				  item1.SubItems.Add(readerset["PurchasePrice"].ToString());
			      item1.SubItems.Add(readerset["GoodsID"].ToString());
				  
				  m_goodsList.Items.AddRange(new ListViewItem[]{item1});	
				  m_goodsList.Items[nextGoodsID-1].Selected = true;
				  nextGoodsID = nextGoodsID  + 1;
				  

				 TotalMoneyCal();

				}
				else
				{
				    MessageBox.Show("该商品不存在！");
				}