using System;
using System.Data.SqlClient;
using System.Windows.Forms;
using System.Collections.Generic;
using System.Drawing;
namespace SnacksInventorySystem
{
public partial class FormSalesManagement : Form
{
private List<Goods> goodsList;
public FormSalesManagement()
{
InitializeComponent();
InitializeUI();
LoadGoodsData();
}
private void InitializeUI()
{
// 设置窗口标题
Text = "销售管理";
// 设置窗口大小
Width = 600;
Height = 400;
// 设置窗口起始位置为屏幕中央
StartPosition = FormStartPosition.CenterScreen;
// 创建销售日期选择器
dateTimePickerSalesDate = new DateTimePicker();
dateTimePickerSalesDate.Location = new Point(20, 20);
dateTimePickerSalesDate.Width = 150;
// 创建商品下拉框
comboBoxGoods = new ComboBox();
comboBoxGoods.Location = new Point(200, 20);
comboBoxGoods.Width = 150;
// 创建销售数量输入框
textBoxQuantity = new TextBox();
textBoxQuantity.Location = new Point(20, 60);
textBoxQuantity.Width = 100;
// 创建商品单价输入框
textBoxUnitPrice = new TextBox();
textBoxUnitPrice.Location = new Point(200, 60);
textBoxUnitPrice.Width = 100;
// 创建销售总金额显示框（只读）
textBoxTotalAmount = new TextBox();
textBoxTotalAmount.Location = new Point(380, 60);
textBoxTotalAmount.Width = 100;
textBoxTotalAmount.ReadOnly = true;
// 创建添加销售记录按钮
Button buttonAddSales = new Button();
buttonAddSales.Text = "添加销售记录";
buttonAddSales.Location = new Point(20, 100);
buttonAddSales.Click += buttonAddSales_Click;
// 创建查看销售记录按钮
Button buttonViewSales = new Button();
buttonViewSales.Text = "查看销售记录";
buttonViewSales.Location = new Point(200, 100);
buttonViewSales.Click += buttonViewSales_Click;
// 创建用于显示销售记录列表的DataGridView（可根据实际需求添加更多列显示详细信息）
dataGridViewSales = new DataGridView();
dataGridViewSales.Location = new Point(20, 140);
dataGridViewSales.Width = 560;
dataGridViewSales.Height = 200;
dataGridViewSales.Columns.Add("SalesDate", "销售日期");
dataGridViewSales.Columns.Add("GoodsName", "商品名称");
dataGridViewSales.Columns.Add("Quantity", "销售数量");
dataGridViewSales.Columns.Add("UnitPrice", "单价");
dataGridViewSales.Columns.Add("TotalAmount", "总金额");
// 将各控件添加到销售管理窗口
Controls.Add(dateTimePickerSalesDate);
Controls.Add(comboBoxGoods);
Controls.Add(textBoxQuantity);
Controls.Add(textBoxUnitPrice);
Controls.Add(textBoxTotalAmount);
Controls.Add(buttonAddSales);
Controls.Add(buttonViewSales);
Controls.Add(dataGridViewSales);
}
private void LoadGoodsData()
{
goodsList = LoadGoods();
foreach (Goods good in goodsList)
{
comboBoxGoods.Items.Add(good.Name);
}
}
private List<Goods> LoadGoods()
{
List<Goods> result = new List<Goods>();
string connectionString = "Data Source=LAPTOP-ODQTAPDG\\MSSQLSERVER01;Initial Catalog=SnacksInventoryDB;User ID=root;Password=123456";
using (SqlConnection connection = new SqlConnection(connectionString))
{
string query = "SELECT Goods_id, Goods_name, Unit_price, Category FROM Goods";
SqlCommand command = new SqlCommand(query, connection);
try
{
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
int id = (int)reader["Goods_id"];
string name = reader["Goods_name"].ToString();
decimal price = (decimal)reader["Unit_price"];
string category = reader["Category"].ToString();
result.Add(new Goods(id, name, price, category));
}
reader.Close();
}
catch (Exception ex)
{
MessageBox.Show("加载商品数据出错：" + ex.Message);
}
}
return result;
}
private void buttonAddSales_Click(object sender, EventArgs e)
{
if (ValidateInput())
{
int goodsId = GetSelectedGoodsId();
int quantity = Convert.ToInt32(textBoxQuantity.Text);
decimal unitPrice = Convert.ToDecimal(textBoxUnitPrice.Text);
decimal totalAmount = quantity * unitPrice;
DateTime salesDate = dateTimePickerSalesDate.Value;
string connectionString = "Data Source=LAPTOP-ODQTAPDG\\MSSQLSERVER01;Initial Catalog=SnacksInventoryDB;User ID=root;Password=123456";
using (SqlConnection connection = new SqlConnection(connectionString))
{
string query = "INSERT INTO sales (sales_date, goods_id, quantity, total_amount) VALUES (@SalesDate, @GoodsId, @Quantity, @TotalAmount)";
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("@SalesDate", salesDate);
command.Parameters.AddWithValue("@GoodsId", goodsId);
command.Parameters.AddWithValue("@Quantity", quantity);
command.Parameters.AddWithValue("@TotalAmount", totalAmount);
try
{
connection.Open();
command.ExecuteNonQuery();
MessageBox.Show("销售记录添加成功！");
ClearInputFields();
LoadSalesRecords();
}
catch (Exception ex)
{
MessageBox.Show("添加销售记录出错：" + ex.Message);
}
}
}
}
private bool ValidateInput()
{
if (string.IsNullOrEmpty(textBoxQuantity.Text))
{
MessageBox.Show("请输入销售数量！");
return false;
}
if (string.IsNullOrEmpty(textBoxUnitPrice.Text))
{
MessageBox.Show("请输入商品单价！");
return false;
}
if (!int.TryParse(textBoxQuantity.Text, out _))
{
MessageBox.Show("销售数量必须为整数！");
return false;
}
if (!decimal.TryParse(textBoxUnitPrice.Text, out _))
{
MessageBox.Show("商品单价格式不正确！");
return false;
}
return true;
}
private int GetSelectedGoodsId()
{
string selectedGoodsName = comboBoxGoods.SelectedItem.ToString();
foreach (Goods good in goodsList)
{
if (good.Name == selectedGoodsName)
{
return good.Id;
}
}
return -1;
}
private void ClearInputFields()
{
textBoxQuantity.Text = "";
textBoxUnitPrice.Text = "";
textBoxTotalAmount.Text = "";
comboBoxGoods.SelectedIndex = -1;
}
private void buttonViewSales_Click(object sender, EventArgs e)
{
LoadSalesRecords();
}
private void LoadSalesRecords()
{
dataGridViewSales.Rows.Clear();
string connectionString = "Data Source=LAPTOP-ODQTAPDG\\MSSQLSERVER01;Initial Catalog=SnacksInventoryDB;User ID=root;Password=123456";
using (SqlConnection connection = new SqlConnection(connectionString))
{
string query = "SELECT s.sales_date, g.goods_name, s.quantity, g.unit_price, s.total_amount " +
"FROM sales s " +
"JOIN goods g ON s.goods_id = g.goods_id";
SqlCommand command = new SqlCommand(query, connection);
try
{
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
DateTime salesDate = (DateTime)reader["sales_date"];
string goodsName = reader["goods_name"].ToString();
int quantity = (int)reader["quantity"];
decimal unitPrice = (decimal)reader["unit_price"];
decimal totalAmount = (decimal)reader["total_amount"];
dataGridViewSales.Rows.Add(salesDate, goodsName, quantity, unitPrice, totalAmount);
}
reader.Close();
}
catch (Exception ex)
{
MessageBox.Show("加载销售记录出错：" + ex.Message);
}
}
}
private class Goods
{
public int Id { get; set; }
public string Name { get; set; }
public decimal Price { get; set; }
public string Category { get; set; }
public Goods(int id, string name, decimal price, string category)
{
Id = id;
Name = name;
Price = price;
Category = category;
}
}
private void FormSalesManagement_Load(object sender, EventArgs e)
{
// 加载商品列表数据，用于填充商品下拉框
LoadGoodsData();
// 设置销售日期选择器的初始值（示例，可根据需求调整，比如设置为最近一周开始日期等）
dateTimePickerSalesDate.Value = DateTime.Today;
// 可以设置页面中其他控件的初始状态，例如输入框的默认提示文本等
textBoxQuantity.Text = "请输入销售数量";
textBoxQuantity.ForeColor = Color.Gray;
textBoxQuantity.GotFocus += (s, args) =>
{
if (textBoxQuantity.Text == "请输入销售数量")
{
textBoxQuantity.Text = "";
textBoxQuantity.ForeColor = Color.Black;
}
};
textBoxQuantity.LostFocus += (s, args) =>
{
if (string.IsNullOrEmpty(textBoxQuantity.Text))
{
textBoxQuantity.Text = "请输入销售数量";
textBoxQuantity.ForeColor = Color.Gray;
}
};
// 还可以进行页面外观相关的设置，比如设置背景颜色等（以下是示例，可按需更改）
this.BackColor = Color.WhiteSmoke;
}
private DateTimePicker dateTimePickerSalesDate;
private ComboBox comboBoxGoods;
private TextBox textBoxQuantity;
private TextBox textBoxUnitPrice;
private TextBox textBoxTotalAmount;
private DataGridView dataGridViewSales;
}
}
namespace SnacksInventorySystem
{
partial class FormSalesManagement
{
/// <summary>
/// 必需的设计器变量。
/// </summary>
private System.ComponentModel.IContainer components = null;
/// <summary>
/// 清理所有正在使用的资源。
/// </summary>
/// <param name="disposing">如果应释放托管资源，为 true；否则为 false。
protected override void Dispose(bool disposing)
{
if (disposing && (components != null))
{
components.Dispose();
}
base.Dispose(disposing);
}
#region Windows 窗体设计器生成的代码
/// <summary>
/// 设计器支持所需的方法 - 不要修改
/// 使用代码编辑器修改此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(600, 400);
this.IsMdiContainer = false;
this.MainMenuStrip = null;
this.Name = "FormSalesManagement";
this.Text = "销售管理";
this.Load += new System.EventHandler(this.FormSalesManagement_Load);
}
#endregion
}
}
浙公网安备 33010602011771号