采购新品.cs

进存销系统..适合书店的进销存..功能可以满足一般的需求.很简单

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.ComponentModel.Design;
using BookStore.DataAccess;

namespace BookStore.Forms
{
    public partial class newProduct : Form
    {
        private BusinessRule.Product product = new BookStore.BusinessRule.Product();
        public newProduct()
        {
            InitializeComponent();
        }

        private void btnOK_Click(object sender, EventArgs e)
        {
            string select = "select Max(ProductID) from Products";
            product.ProID = Convert.ToInt32(DataAccess.Narnu.GetObjectBySqlString(select)) + 1;
            product.ProName = (string)tbName.Text.ToString();
            product.CategoryID = (int)Narnu.GetCategoryID(this.cboCategory.SelectedItem.ToString().Trim());
            product.DetailCategoryID = (int)Narnu.GetDetailCategoryID(this.cboDetailCategory.SelectedItem.ToString().Trim());
            product.SupplierID = (int)Narnu.GetSupplierID(this.cboSupplier.SelectedItem.ToString().Trim());
            product.UnitCost = Convert.ToInt32(tbCost.Text.ToString());
            product.UnitPrice =Convert.ToInt32(tbPrice.Text.ToString());
            product.Units = (int)this.NUDamount.Value;
            product.Description = tbRemark.Text.ToString();
            product.Fomat = cboFormat1.SelectedItem.ToString().Trim() + cboFomat2.SelectedItem.ToString().Trim();
            product.InsertProduct();
        }

        private void 采购_Load(object sender, EventArgs e)
        {
            // TODO: 这行代码将数据加载到表“bookShopDataSet.Categories”中。您可以根据需要移动或移除它。
            SupplierAdd();
            EmployeeAdd();
            CategoryAdd();
        }

        private void SupplierAdd()
        {
            ComboxAddValue add = new ComboxAddValue("Suppliers", "CompanyName");
            cboSupplier.Items.Clear();
            for (int i = 0; i < add.items.Count; i++)
            {
                cboSupplier.Items.Add(add.items[i].ToString());
            }
        }

        private void CategoryAdd()
        {
            DataAccess.ComboxAddValue add = new BookStore.DataAccess.ComboxAddValue("Categories", "CategoryName");
            cboCategory.Items.Clear();
            for (int i = 0; i < add.items.Count; i++)
            {
                cboCategory.Items.Add(add.items[i].ToString());
            }
        }

        private void EmployeeAdd()
        {
            ComboxAddValue add = new ComboxAddValue("Employees", "Name");
            cboEmployee.Items.Clear();
            for (int i = 0; i < add.items.Count; i++)
            {
                this.cboEmployee.Items.Add(add.items[i].ToString());
            }
        }

        private void DetailCategoryAdd()
        {
            string categoryName = cboCategory.Text.ToString().Trim();
            string select = "select CategoryID from Categories where CategoryName='" + categoryName + "'";
            int id=Convert.ToInt32(Narnu.GetObjectBySqlString(select));
            select = "select Name from DetailCategorys where CategoryID=" + id;
            DataSet DS = Narnu.GetDataSetBySqlString(select);
            cboDetailCategory.Items.Clear();
            for (int i = 0; i < DS.Tables[0].Rows.Count; i++)
            {
                
                cboDetailCategory.Items.Add(DS.Tables[0].Rows[i][0]);
            }
        }

        private void cboCategory_SelectedIndexChanged(object sender, EventArgs e)
        {
            DetailCategoryAdd();
        }

        private void btnCancel_Click(object sender, EventArgs e)
        {
            this.Close();
        }

    }
}