精品文档

} } }

}

3.2出库管理界面

using System;

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

using System.Windows.Forms; using System.Data.SqlClient;

namespace XRX.GoodsManage {

public partial class OutManage : Form {

int a = 0, aa = 0, bb = 0; public OutManage() {

InitializeComponent(); }

精品文档

精品文档

private void btnAdd_Click(object sender, EventArgs e) {

DataBase db = new DataBase();

SqlParameter[] Pa = new SqlParameter[6];

Pa[0] = db.MakeInParam(\, SqlDbType.Int, 4, aa); Pa[1] = db.MakeInParam(\, SqlDbType.Int, 4, bb); Pa[2] = db.MakeInParam(\, SqlDbType.Int, 4, Convert.ToInt32(this.txtGSpec.Text));

Pa[3] = db.MakeInParam(\, SqlDbType.VarChar, 20, this.txtGIPrice.Text);

Pa[4] = db.MakeInParam(\, SqlDbType.VarChar, 20, this.dateTimePicker1.Value);

Pa[5] = db.MakeInParam(\, SqlDbType.VarChar, 20, this.txtISRemark.Text);

int b = db.ExecuteNonQuery(CommandType.StoredProcedure, \, Pa);

int Add = db.ExecuteNonQuery(CommandType.Text, \(StorageID,GoodsID,OutNum,OutUnit,OutDate,OutRemark) values ('\ + aa + \ + bb + \ + this.txtGSpec.Text + \ + this.txtGIPrice + \ + this.dateTimePicker1.Value + \ + this.txtISRemark.Text + \, null); if (Add == 1) {

MessageBox.Show(\添加出库信息成功\, \添加成功\, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); aaa(); } else {

MessageBox.Show(\添加出库信息失败\, \添加失败\, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); }

}

private void btnDel_Click(object sender, EventArgs e) {

DataBase db = new DataBase();

int Delete = db.ExecuteNonQuery(CommandType.Text, \from OutInfo where OutOrder='\ + a + \, null); if (Delete == 1) {

MessageBox.Show(\删除入库信息成功\, \修改成功\, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); aaa();

精品文档

精品文档

} else {

MessageBox.Show(\删除入库信息失败\, \修改失败\, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }

private void btnExit_Click(object sender, EventArgs e) {

this.Close(); }

private void OutManage_Load(object sender, EventArgs e) {

aaa(); }

private void aaa() {

DataBase db = new DataBase();

DataSet ds = db.GetDs(CommandType.StoredProcedure, \, null);

this.dgvISManage.DataSource = ds.Tables[0];

this.cboxSName.DataSource = ds.Tables[0].DefaultView; this.cboxSName.DisplayMember = \;

this.comboBox1.DataSource = ds.Tables[0].DefaultView; this.comboBox1.DisplayMember = \; this.dgvISManage.Columns[0].Visible = false; this.dgvISManage.Columns[1].HeaderText = \仓库名\; this.dgvISManage.Columns[2].HeaderText = \物品名\; this.dgvISManage.Columns[3].HeaderText = \出库数量\; this.dgvISManage.Columns[4].HeaderText = \出库单位\; this.dgvISManage.Columns[5].HeaderText = \出库日期\; this.dgvISManage.Columns[6].HeaderText = \备注\; this.dgvISManage.Columns[1].Width = 100; this.dgvISManage.Columns[2].Width = 80; this.dgvISManage.Columns[3].Width = 80; this.dgvISManage.Columns[4].Width = 80; this.dgvISManage.Columns[5].Width = 80; this.dgvISManage.Columns[6].Width = 100; this.dgvISManage.ReadOnly = true;//只读 dgvISManage.SelectionMode =

DataGridViewSelectionMode.FullRowSelect;//选中行

this.dgvISManage.AllowUserToResizeRows = false;

精品文档

精品文档

this.dgvISManage.AllowUserToResizeColumns = false;//禁止拖动 this.dgvISManage.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;//文本居中

this.dgvISManage.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;//表头居中 }

private void dgvISManage_CellClick(object sender, DataGridViewCellEventArgs e) { try { a =

Convert.ToInt32(this.dgvISManage.Rows[e.RowIndex].Cells[0].Value.ToString());

this.cboxSName.Text =

this.dgvISManage.Rows[e.RowIndex].Cells[1].Value.ToString(); this.textBox1.Text =

this.dgvISManage.Rows[e.RowIndex].Cells[7].Value.ToString(); this.comboBox1.Text =

this.dgvISManage.Rows[e.RowIndex].Cells[2].Value.ToString(); this.txtGSpec.Text =

this.dgvISManage.Rows[e.RowIndex].Cells[3].Value.ToString(); this.dateTimePicker1.Value =

Convert.ToDateTime(this.dgvISManage.Rows[e.RowIndex].Cells[5].Value.ToString());

this.txtGIPrice.Text =

this.dgvISManage.Rows[e.RowIndex].Cells[4].Value.ToString(); this.txtISRemark.Text =

this.dgvISManage.Rows[e.RowIndex].Cells[6].Value.ToString(); }

catch { } }

private void cboxSName_SelectedIndexChanged(object sender, EventArgs e) {

DataBase db = new DataBase();

SqlDataReader dr = db.ExecuteReader(CommandType.Text, \StorageID from StorageInfo where StorageName ='\ + this.cboxSName.Text + \, null);

if (dr.Read())

aa = Convert.ToInt32(dr[\].ToString()); dr.Close();

SqlDataReader dr2 = db.ExecuteReader(CommandType.Text, \

精品文档