formspkcrl.cs

超市进销存管理系统 Visual Studio 2005+SQL Sever2005

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

namespace _10901BS
{
    public partial class formSpKcRl : Form
    {
        SqlCaoZuo cz = new SqlCaoZuo();
        formJhrk f1 = new formJhrk();
        SqlDataAdapter da;
        DataTable dt;
        SqlCommandBuilder cb;
        public formSpKcRl()
        {
            InitializeComponent();
        }

        private void formSpKcRl_Load(object sender, EventArgs e)
        {            
            
            da = new SqlDataAdapter("select spID as '商品编号',spName,spBzsj as '商品标准价格',spKcsx as '商品库存上限',spKcxx as '商品库存下限' from spxqBiao where spID='"+this.Text+"'",cz.sqlCon());
            dt = new DataTable();
            da.Fill(dt);
            cb = new SqlCommandBuilder(da);           
            this.dataGridView1.DataSource = dt;
            this.dataGridView1.Columns[1].Visible = false;
            if (this.dataGridView1.RowCount > 1)
            {
                this.lb_spName.Text = this.dataGridView1.Rows[0].Cells[1].Value.ToString();
            }
        }

        private void bt_Qd_Click(object sender, EventArgs e)
        {            
            da.Update(dt);
            this.Close();
        }

        private void bt_Cz_Click(object sender, EventArgs e)
        {
            this.dataGridView1.Rows[0].Cells[2].Value = 0;
            this.dataGridView1.Rows[0].Cells[3].Value = 0;
            this.dataGridView1.Rows[0].Cells[4].Value = 0;
        }

        private void formSpKcRl_FormClosing(object sender, FormClosingEventArgs e)
        {
            f1.tb_spBzsj.Text = this.dataGridView1.Rows[0].Cells[2].Value.ToString();
        }

    }
}