//选择销售管理标签时，自动加载相应的combobox选项，包括员工姓名和产品类别
private void Manage_Sys_SelectedIndexChanged(object sender, EventArgs e)
{
//库存管理标签
if (this.Manage_Sys.SelectedIndex == 1)
{
DataSet ds = new DataSet();
String cmdProSort = "select distinct Pro_Sort from db_Product";
ds = allOperate.getDS(cmdProSort);
//使用SelectedValueChanged方法要将数据源的绑定放在DisplayMember和ValueMember前面；
//使用SelectedIndexChanged方法要将数据源的绑定放在DisplayMember和ValueMember后面；
SortCombobox.DataSource = ds.Tables[0];
SortCombobox.DisplayMember = "Pro_Sort";
SortCombobox.ValueMember = "Pro_Sort";
SortCombobox.Text = "请选择";
}
//销售记录标签
if (this.Manage_Sys.SelectedIndex == 2)
{
DataSet ds = new DataSet();
String cmdEmployeeName = "select * from db_Employee";
ds = allOperate.getDS(cmdEmployeeName);
employeeName.DataSource = ds.Tables[0];
employeeName.DisplayMember = "EmployeeName";
employeeName.ValueMember = "EmployeeName";
employeeName.Text = "请选择";
employeeID.Text = "请选择";
DatabaseOP operateDB = new DatabaseOP();
String sortStr = "select distinct Pro_Sort from db_Product";
DataSet sortDS = new DataSet();
sortDS = operateDB.getDS(sortStr);
saleProductSort.DataSource = sortDS.Tables[0];
saleProductSort.DisplayMember = "Pro_sort";
saleProductSort.ValueMember = "Pro_sort";
saleProductSort.Text = "请选择";
saleProductType.Text = "请选择";
}
//销售明细标签
if (this.Manage_Sys.SelectedIndex == 5)
{
DataSet ds = new DataSet();
String cmdEmployeeName = "select * from db_Employee";
ds = allOperate.getDS(cmdEmployeeName);
viewEmployeeName.DataSource = ds.Tables[0];
viewEmployeeName.DisplayMember = "EmployeeName";
viewEmployeeName.ValueMember = "EmployeeName";
//viewEmployeeID.DataSource = ds.Tables[0];
//viewEmployeeID.DisplayMember = "EmployeeID";
viewEmployeeName.Text = "请选择";
viewEmployeeID.Text = "请选择";
}
}
//将销售记录写入数据库
private void saleRecord_Click(object sender, EventArgs e)
{
DatabaseOP saleDB = new DatabaseOP();
String getEmployeeID = employeeID.Text.Trim();
String getPro_Type = saleProductType.Text.Trim();
int getSale_Price = int.Parse(salePrice.Text.ToString());
DateTime getSale_Date = DateTime.Now;
String getCustomerName = customerName.Text.Trim();
String getCustomerPhone = customerPhone.Text.Trim();
String getCustomerAddress = customerAddress.Text.Trim();
String getAddInfo = addInfo.Text.Trim();
saleDB.addSaleRecorde(getEmployeeID, getPro_Type, getSale_Price, getCustomerName, getCustomerPhone, getCustomerAddress, getAddInfo, getSale_Date.Day, getSale_Date.Month, getSale_Date.Year);
this.viewAllSaleBtn_Click(sender, e);
//清空控件内容
employeeName.Text = "请选择";
employeeID.Text = "请选择";
saleProductSort.Text = "请选择";
saleProductType.Text = "请选择";
salePrice.Clear();
customerName.Clear();
customerPhone.Clear();
customerAddress.Clear();
addInfo.Clear();
}
//刷新销售记录
private void viewAllSaleBtn_Click(object sender, EventArgs e)
{
DatabaseOP viewAllSale = new DatabaseOP();
DataSet getAllSale = new DataSet();
getAllSale = viewAllSale.viewSaleRecorde();
allSaleDataGridView.DataSource = getAllSale.Tables[0].DefaultView;
}
//个人月销售明细
private void monthSaleBtn_Click(object sender, EventArgs e)
{
DateTime dt = DateTime.Now;
DataSet ds = new DataSet();
DatabaseOP db = new DatabaseOP();
ds = db.viewMonthProfit(viewEmployeeID.Text.Trim(), int.Parse(dt.Month.ToString()), int.Parse(dt.Year.ToString()));
dataGridViewProfit.DataSource = ds.Tables[0].DefaultView;
profitLabel.Text = allOperate.showMonthProfit(viewEmployeeID.Text.Trim(), int.Parse(dt.Month.ToString()), int.Parse(dt.Year.ToString())).ToString();
}
//产品类别发生变化时，自动加载相应的型号列表
private void saleProductSort_SelectedValueChanged(object sender, EventArgs e)
{
DatabaseOP operateDB = new DatabaseOP();
String sqlTypeStr = "select Pro_Type from db_Product where Pro_Sort = '" + saleProductSort.Text.Trim() + "';";
DataSet ds = new DataSet();
ds = operateDB.getDS(sqlTypeStr);
saleProductType.DataSource = ds.Tables[0];
saleProductType.DisplayMember = "Pro_Type";
saleProductType.Text = "请选择";
}
//当员工姓名发生变化时，自动查找相应的工号
private void employeeName_SelectedValueChanged(object sender, EventArgs e)
{
DatabaseOP opDatabase = new DatabaseOP();
DataSet ds = new DataSet();
String cmdEmployeeID = "select * from db_Employee where EmployeeName = " + "'" + employeeName.SelectedValue.ToString() + "'";
ds = opDatabase.getDS(cmdEmployeeID);
employeeID.DataSource = ds.Tables[0];
employeeID.DisplayMember = "EmployeeID";
//employeeID.Text = "请选择";
}
//添加新产品
private void addNewProduct_Click(object sender, EventArgs e)
{
DatabaseOP addPro = new DatabaseOP();
String newSort = sortTextBox.Text.Trim();
String newType = typeTextBox.Text.Trim();
addPro.addNewProduct(newSort, newType);
DataSet ds = new DataSet();
ds = addPro.getDS("select * from db_Product;");
productDataGridView.DataSource = ds.Tables[0].DefaultView;
sortTextBox.Clear();
typeTextBox.Clear();
}
//增加新员工
private void btn_addNewEmployee_Click(object sender, EventArgs e)
{
DatabaseOP insertDB = new DatabaseOP();
String newEmployeeName = newNameBox.Text.Trim();
String newEmployeeID = newIDBox.Text.Trim();
insertDB.insertData(newEmployeeName, newEmployeeID);
String employeeSelect = "select * from db_Employee";
DataSet ds = new DataSet();
ds = insertDB.getDS(employeeSelect);
employeeDataGridView.DataSource = ds.Tables[0].DefaultView;
newNameBox.Clear();
newIDBox.Clear();
}
