产品信息.cs

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

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

namespace BookStore.Forms
{
    public partial class ProductsInfo : Form
    {
        private DataSet ds = new DataSet();
        private string select = "select ProductID,ProductName,SupplierID,CategoryID,DetailCategoryID,UnitCost,UnitPrice,Units,Fomart from Products";
        private string[] columns = new string[] { "产品编号", "产品名称", "供应商", "类别", "成本价", "销售价", "在库量", "规格" };
        private bool sellTable = false;
        public ProductsInfo(bool n)
        {
            InitializeComponent();
            SetDataGridStyle();
            this.sellTable = n;

        }

        private void SetDataGridStyle()
        {
            DataGridTableStyle ts = new DataGridTableStyle();
            for (int i = 0; i < 8; i++)
            {
                DataGridBoolColumn aColumnsText = new DataGridBoolColumn();
                aColumnsText.MappingName = columns[i];
                aColumnsText.HeaderText = columns[i];
                aColumnsText.NullText = "";

                ts.GridColumnStyles.Add(aColumnsText);
            }
            this.dg_ProductsInfo.TableStyles.Add(ts);
        }


        //采购窗口调用返回的信息
        private void dg_ProductsInfo_DoubleClick(object sender, EventArgs e)
        {
            if (this.dg_ProductsInfo.ReadOnly == true)
            {
                int CurrentRowNum = this.dg_ProductsInfo.CurrentCell.RowNumber;
                string ProID, ProName, ProPrice;
                ProID = this.dg_ProductsInfo[CurrentRowNum, 0].ToString().Trim();
                ProName = this.dg_ProductsInfo[CurrentRowNum, 1].ToString().Trim();
                ProPrice = this.dg_ProductsInfo[CurrentRowNum, 5].ToString().Trim();
                if (this.sellTable == false)
                {
                    StockTable.inputDataGridArray[0] = ProID;
                    StockTable.inputDataGridArray[1] = ProName;
                    StockTable.inputDataGridArray[2] = ProPrice;
                }
                else
                {
                    Sell.inputDataGridArray[0] = ProID;
                    Sell.inputDataGridArray[1] = ProName;
                    Sell.inputDataGridArray[2] = ProPrice;
                }
                this.Close();
            }
        }

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

        //小商品类别
        private void DetailCategoryAdd()
        {
            string categoryName = cbo_Category.Text.ToString().Trim();
            string select = "select CategoryID from Categories where CategoryName='" + categoryName + "'";
            int id = Convert.ToInt32(DataAccess.Narnu.GetObjectBySqlString(select));
            select = "select Name from DetailCategorys where CategoryID=" + id;
            DataSet DS = DataAccess.Narnu.GetDataSetBySqlString(select);
            cbo_DetailCategory.Items.Clear();
            for (int i = 0; i < DS.Tables[0].Rows.Count; i++)
            {

                cbo_DetailCategory.Items.Add(DS.Tables[0].Rows[i][0]);
            }
        }

        public void DataGridReadOnly()
        {
            this.dg_ProductsInfo.ReadOnly = true;
        }

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

        private void ProductsInfo_Load(object sender, EventArgs e)
        {
            CategoryAdd();
        }

        //商品搜索
        private void button1_Click(object sender, EventArgs e)
        {
            if (cbo_Category.Text == "")
            {
                ds = DataAccess.Narnu.GetDataSetBySqlString(select);
                dg_ProductsInfo.DataSource = ds.Tables[0];
            }
            else
            {
                if (cbo_DetailCategory.Text == "")
                {
                    string strselect = "select CategoryID from Categories where CategoryName='" + this.cbo_Category.Text.ToString() + "'";
                    int CategoryID = int.Parse(DataAccess.Narnu.GetObjectBySqlString(strselect).ToString());
                    strselect = "select ProductID,ProductName,SupplierID,CategoryID," +
                        "DetailCategoryID,UnitCost,UnitPrice,Units,Fomart from Products where CategoryID=" + CategoryID;
                    ds = DataAccess.Narnu.GetDataSetBySqlString(strselect);
                    dg_ProductsInfo.DataSource = ds.Tables[0];
                }
                else
                {
                    string strselect = "select CategoryID from Categories where CategoryName='" + this.cbo_Category.Text.ToString() + "'";
                    int CategoryID = int.Parse(DataAccess.Narnu.GetObjectBySqlString(strselect).ToString());
                    strselect = "select DetailCategoryID from DetailCategorys where CategoryID=" + 
                                CategoryID + "and Name='" + this.cbo_DetailCategory.Text.ToString().Trim() + "'";
                    int DetailCategoryID = int.Parse(DataAccess.Narnu.GetObjectBySqlString(strselect).ToString());
                    strselect = "select ProductID,ProductName,SupplierID,CategoryID," +
                        "DetailCategoryID,UnitCost,UnitPrice,Units,Fomart from Products where DetailCategoryID=" + DetailCategoryID;
                    ds = DataAccess.Narnu.GetDataSetBySqlString(strselect);
                    dg_ProductsInfo.DataSource = ds.Tables[0];
                }
            }
        }

        private void cboDetailCategory_SelectedIndexChanged(object sender, EventArgs e)
        {

        }

    }
}