saleform.cs

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

			this.goodsNameTextBox.Size = new System.Drawing.Size(123, 21);
			this.goodsNameTextBox.TabIndex = 15;
			this.goodsNameTextBox.Text = "";
			// 
			// goodsCodeTextBox
			// 
			this.goodsCodeTextBox.Enabled = false;
			this.goodsCodeTextBox.Location = new System.Drawing.Point(121, 28);
			this.goodsCodeTextBox.Name = "goodsCodeTextBox";
			this.goodsCodeTextBox.Size = new System.Drawing.Size(123, 21);
			this.goodsCodeTextBox.TabIndex = 14;
			this.goodsCodeTextBox.Text = "";
			// 
			// button1
			// 
			this.button1.Location = new System.Drawing.Point(174, 226);
			this.button1.Name = "button1";
			this.button1.TabIndex = 14;
			this.button1.Text = "查询";
			this.button1.Click += new System.EventHandler(this.button1_Click);
			// 
			// button2
			// 
			this.button2.Location = new System.Drawing.Point(388, 226);
			this.button2.Name = "button2";
			this.button2.TabIndex = 15;
			this.button2.Text = "重置";
			this.button2.Click += new System.EventHandler(this.button2_Click);
			// 
			// m_SaleDataGrid
			// 
			this.m_SaleDataGrid.DataMember = "";
			this.m_SaleDataGrid.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.m_SaleDataGrid.Location = new System.Drawing.Point(13, 255);
			this.m_SaleDataGrid.Name = "m_SaleDataGrid";
			this.m_SaleDataGrid.ReadOnly = true;
			this.m_SaleDataGrid.Size = new System.Drawing.Size(617, 189);
			this.m_SaleDataGrid.TabIndex = 17;
			// 
			// label9
			// 
			this.label9.AutoSize = true;
			this.label9.Location = new System.Drawing.Point(169, 207);
			this.label9.Name = "label9";
			this.label9.Size = new System.Drawing.Size(313, 17);
			this.label9.TabIndex = 20;
			this.label9.Text = "友情提示：名称和姓名支持模糊查询；缺省为查询所有。";
			// 
			// textBox1
			// 
			this.textBox1.Location = new System.Drawing.Point(576, 232);
			this.textBox1.Name = "textBox1";
			this.textBox1.TabIndex = 21;
			this.textBox1.Text = "textBox1";
			// 
			// SaleForm
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(642, 456);
			this.Controls.Add(this.textBox1);
			this.Controls.Add(this.label9);
			this.Controls.Add(this.m_SaleDataGrid);
			this.Controls.Add(this.button2);
			this.Controls.Add(this.button1);
			this.Controls.Add(this.groupBox1);
			this.MaximizeBox = false;
			this.Name = "SaleForm";
			this.Text = "销售记录查询";
			this.Load += new System.EventHandler(this.SaleForm_Load);
			this.groupBox1.ResumeLayout(false);
			this.groupBox2.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.m_SaleDataGrid)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

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

		private void checkBox2_CheckedChanged(object sender, System.EventArgs e)
		{
			if (checkBox2.Checked == true)
			{
				goodsNameTextBox.Enabled = true;
			}
			else
			{
				goodsNameTextBox.Enabled = false;
			}
		}

		private void checkBox3_CheckedChanged(object sender, System.EventArgs e)
		{
			if (checkBox3.Checked == true)
			{
				employeeNameTextBox.Enabled = true;
			}
			else
			{
				employeeNameTextBox.Enabled = false;
			}
		}

		private void button1_Click(object sender, System.EventArgs e)
		{
			string query = "select * from SaleRecord inner join Goods on Goods.GoodsID = SaleRecord.GoodsID inner join Employee on Employee.EmployeeID = SaleRecord.EmployeeID left outer join Guest on Guest.GuestID = SaleRecord.GuestID where ";

			if (checkBox1.Checked == true)
			{
				query += "Goods.GoodsCode = '" + goodsCodeTextBox.Text + "' and ";
			}
			if (checkBox2.Checked == true)
			{
				query += "Goods.GoodsName like '%" + goodsNameTextBox.Text + "%' and ";
			}
			if (checkBox3.Checked == true)
			{
				query += "Employee.EmployeeName like '%" + employeeNameTextBox.Text + "%' and ";
			}
			if (checkBox4.Checked == true)
			{
				if (radioButton1.Checked == true)
				{//今日销售
					query += "convert(varchar(10),SaleRecord.SaleTime,20) = convert(varchar(10),GETDATE(),20)";
				}
				else 
				{//日期范围
					DateTime startDateTime = startDateTimePicker.Value;
					DateTime endDateTime = endDateTimePicker.Value;
					query += "SaleRecord.SaleTime > '" + startDateTime + "' and SaleRecord.SaleTime < '" + endDateTime +"'";
				}
                
			}

			if (query.EndsWith("and "))
			{
				query = query.Substring(0, query.LastIndexOf("and "));
			}
			if (query.EndsWith("where "))
			{
				query = query.Substring(0, query.LastIndexOf("where "));
			}

			Console.WriteLine(query);

			startDateTimePicker.ResetText();
			endDateTimePicker.ResetText();

			System.Data.DataTable datatable = new System.Data.DataTable();
			System.Data.DataRow datarow;
			datatable.Columns.Add(new System.Data.DataColumn("销售记录号"));
			datatable.Columns.Add(new System.Data.DataColumn("商品名称"));
			datatable.Columns.Add(new System.Data.DataColumn("销售数量"));
			datatable.Columns.Add(new System.Data.DataColumn("客户名称"));
			datatable.Columns.Add(new System.Data.DataColumn("售价(元)"));
			datatable.Columns.Add(new System.Data.DataColumn("销售员姓名"));
			datatable.Columns.Add(new System.Data.DataColumn("销售日期"));

			SqlConnection conn = DBUtil.GetConnection();
			conn.Open();
			SqlCommand cmd = new SqlCommand(query, conn);
			SqlDataReader reader = cmd.ExecuteReader();
			while (reader.Read())
			{
				datarow = datatable.NewRow();
				datarow[0] = reader["SaleRecordID"];
				datarow[1] = reader["GoodsName"];
				datarow[2] = reader["SaleNumber"];
				datarow[3] = reader["GuestName"];
				datarow[4] = reader["SalePrice"];
				datarow[5] = reader["EmployeeName"];
				datarow[6] = reader["SaleTime"];
				datatable.Rows.Add(datarow);
			}
			System.Data.DataView dataview = new System.Data.DataView(datatable);
			m_SaleDataGrid.DataSource = dataview;
			conn.Close();
		}

		private void button2_Click(object sender, System.EventArgs e)
		{
			checkBox1.Checked = false;
			checkBox2.Checked = false;
			checkBox3.Checked = false;
			checkBox4.Checked = false;

			goodsCodeTextBox.Text = "";
			goodsNameTextBox.Text = "";
			employeeNameTextBox.Text = "";

			startDateTimePicker.ResetText();
			endDateTimePicker.ResetText();
		}

		private void checkBox1_CheckedChanged(object sender, System.EventArgs e)
		{
			if (checkBox1.Checked == true)
			{
				goodsCodeTextBox.Enabled = true;
			}
			else
			{
				goodsCodeTextBox.Enabled = false;
			}
		}

		private void checkBox4_CheckedChanged(object sender, System.EventArgs e)
		{
			if (checkBox4.Checked == true)
			{
				groupBox2.Enabled = true;
			}
			else
			{
				groupBox2.Enabled = false;
			}
		}

		private void radioButton2_CheckedChanged(object sender, System.EventArgs e)
		{
			if (radioButton2.Checked == true)
			{
				startDateTimePicker.Enabled = true;
				endDateTimePicker.Enabled = true;
			}
			else
			{
				startDateTimePicker.Enabled = false;
				endDateTimePicker.Enabled = false;
			}
		}
	}
}