超市管理系统代码.docx

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

namespace 超市管理信息系统
{
public partial class f_供应商基本信息 : Form
{
//公有变量记录选定数据
public string strOldNO "";
public string strOldName = "";
public string strOldAdd = "";

public f_供应商基本信息()
{
InitializeComponent();
}

private void f_供应商基本信息_Load(object sender, EventArgs e)
{
// TODO: 这行代码将数据加载到表“连锁超市管理信息数据库DataSet.供应商”中。您可以根据需要移动或移除它。
this.供应商TableAdapter.Fill(this.连锁超市管理信息数据库DataSet.供应商);

}

//新增数据单击事件
private void btnInsert_Click(object sender, EventArgs e)
{
//获取前台数据
string strName = txtName.Text;
string strAdd = txtAdd.Text;
string strNO = txtNO.Text;
int iNO = 0;

int iErrCode = 0;
//对前台编号数据的格式审核
try
{
iNO = Convert.ToInt32(txtNO.Text.Trim());
}
catch (Exception eINO)
{
iErrCode = 1;
}
//对前台名称数据的格式审核
if (strName.Length > 20)
{
iErrCode = 2;
}
if (strAdd.Length > 30)
{
iErrCode = 3;
}

if (iErrCode != 0)
{
MessageBox.Show("你所输入的数据有误，请核查！");
}
else
{
try
{
//新增写入数据库
this.供应商TableAdapter.Insert(iNO, strName, strAdd);
}
catch (Exception exInsert)
{
MessageBox.Show("新增数据发生错误，请与管理员联系！");
}
}

//刷新数据列数
this.供应商TableAdapter.Fill(this.连锁超市管理信息数据库DataSet.供应商);
}

//单击数据表单元格触发事件
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
//获取对应行的各个单元格数据
string strNO = this.dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();
string strName = this.dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
string strAdd = this.dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();
//填充回对应的文本框
txtNO.Text = strNO;
txtName.Text = strName;
txtAdd.Text = strAdd;
//将原数据值赋予公有变量
strOldNO = strNO;
strOldName = strName;
strOldAdd = strAdd;
}

//删除按钮事件
private void btnDelete_Click(object sender, EventArgs e)
{
//获取前台数据
string strName = txtName.Text;
string strAdd = txtAdd.Text;
string strNO = txtNO.Text;
int iNO = 0;

int iErrCode = 0;
//对前台编号数据的格式审核
try
{
iNO = Convert.ToInt32(txtNO.Text.Trim());
}
catch (Exception eINO)
{
iErrCode = 1;
}
//对前台名称数据的格式审核
if (strName.Length > 20)
{
iErrCode = 2;
}
if (strAdd.Length > 30)
{
iErrCode = 3;
}

if (iErrCode != 0)
{
MessageBox.Show("你所输入的数据有误，请核查！");

}
else
{
try
{
//新增写入数据库
this.供应商TableAdapter.Delete(iNO, strName, strAdd);
}
catch (Exception exInsert)
{
MessageBox.Show("删除数据发生错误，请与管理员联系！");
}
}

//刷新数据列数
this.供应商TableAdapter.Fill(this.连锁超市管理信息数据库DataSet.供应商);

}

//修改按钮事件
private void btnUpdate_Click(object sender, EventArgs e)
{
//获取前台数据
string strName = txtName.Text;
string strAdd = txtAdd.Text;
string strNO = txtNO.Text;
int iNO = 0;

int iErrCode = 0;
//对前台编号数据的格式审核
try
{
iNO = Convert.ToInt32(txtNO.Text.Trim());
}
catch (Exception eINO)
{
iErrCode = 1;
}
//对前台名称数据的格式审核
if (strName.Length > 20)
{
iErrCode = 2;
}
if (strAdd.Length > 30)
{
iErrCode = 3;
}
if (iErrCode != 0)
{
MessageBox.Show("你所输入的数据有误，请核查！");
}
else
{
try
{
this.供应商TableAdapter.Update(iNO, strName, strAdd, Convert.ToInt32(strOldNO), strOldName, strOldAdd);
}
catch (Exception exUpdate)
{
MessageBox.Show("修改数据发生错误，请与管理员联系！");
}

}
//刷新数据列数
this.供应商TableAdapter.Fill(this.连锁超市管理信息数据库DataSet.供应商);
}

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

namespace 超市管理信息系统
{
public partial class f_供应商基本信息 : Form
{
//公有变量记录选定数据
public string strOldNO = "";
public string strOldName = "";
public string strOldAdd = "";

public f_供应商基本信息()
{
InitializeComponent();
}

private void f_供应商基本信息_Load(object sender, EventArgs e)
{
// TODO: 这行代码将数据加载到表“连锁超市管理信息数据库DataSet.供应商”中。您可以根据需要移动或移除它。
this.供应商TableAdapter.Fill(this.连锁超市管理信息数据库DataSet.供应商);

}

//新增数据单击事件
private void btnInsert_Click(object sender, EventArgs e)
{
//获取前台数据
string strName = txtName.Text;
string strAdd = txtAdd.Text;
string strNO = txtNO.Text;
int iNO = 0;

int iErrCode = 0;
//对前台编号数据的格式审核
try
{
iNO = Convert.ToInt32(txtNO.Text.Trim());
}
catch (Exception eINO)
{
iErrCode = 1;
}
//对前台名称数据的格式审核
if (strName.Length > 20)
{
iErrCode = 2;
}
if (strAdd.Length > 30)
{
iErrCode = 3;
}

if (iErrCode != 0)
{
MessageBox.Show("你所输入的数据有误，请核查！");
}
else
{
try
{
//新增写入数据库
this.供应商TableAdapter.Insert(iNO, strName, strAdd);

}
catch (Exception exInsert)
{
MessageBox.Show("新增数据发生错误，请与管理员联系！");
}
}

//刷新数据列数
this.供应商TableAdapter.Fill(this.连锁超市管理信息数据库DataSet.供应商);
}

//单击数据表单元格触发事件
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
//获取对应行的各个单元格数据
string strNO = this.dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();
string strName = this.dataGridView1.Rows[e.RowIndex].Cells[1]Value.ToString();
string strAdd = this.dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();
//填充回对应的文本框
txtNO.Text = strNO;
txtName.Text = strName;
txtAdd.Text = strAdd;
//将原数据值赋予公有变量
strOldNO = strNO;
strOldName = strName;
strOldAdd = strAdd;
}

//删除按钮事件
private void btnDelete_Click(object sender, EventArgs e)
{
//获取前台数据
string strName = txtName.Text;
string strAdd = txtAdd.Text;
string strNO = txtNO.Text;
int iNO = 0;

int iErrCode = 0;
//对前台编号数据的格式审核
try
{
iNO = Convert.ToInt32(txtNO.Text.Trim());
}
catch (Exception eINO)
{
iErrCode = 1;
}
//对前台名称数据的格式审核
if (strName.Length > 20)
{
iErrCode = 2;
}
if (strAdd.Length > 30)
{
iErrCode = 3;
}

if (iErrCode != 0)
{
MessageBox.Show("你所输入的数据有误，请核查！");
}
else
{
try
{
//新增写入数据库
this.供应商TableAdapter.Delete(iNO, strName, strAdd);
}
catch (Exception exInsert)
{
MessageBox.Show("删除数据发生错误，请与管理员联系！");
}
}

//刷新数据列数
this.供应商TableAdapter.Fill(this.连锁超市管理信息数据库DataSet.供应商);

}

//修改按钮事件
private void btnUpdate_Click(object sender, EventArgs e)
{
//获取前台数据
string strName = txtName.Text;
string strAdd = txtAdd.Text;
string strNO = txtNO.Text;
int iNO = 0;

int iErrCode = 0;
//对前台编号数据的格式审核
try
{
iNO = Convert.ToInt32(txtNO.Text.Trim());
}
catch (Exception eINO)
{
iErrCode = 1;
}
//对前台名称数据的格式审核
if (strName.Length > 20)
{
iErrCode = 2;
}
if (strAdd.Length > 30)
{
iErrCode = 3;
}
if (iErrCode != 0)
{
MessageBox.Show("你所输入的数据有误，请核查！");
}
else
{
try
{
this.供应商TableAdapter.Update(iNO, strName, strAdd, Convert.ToInt32(strOldNO), strOldName, strOldAdd);
}
catch (Exception exUpdate)
{
MessageBox.Show("修改数据发生错误，请与管理员联系！");
}

}
//刷新数据列数
this.供应商TableAdapter.Fill(this.连锁超市管理信息数据库DataSet.供应商);
}

}
}