实例介绍
特别说明：本人不在接触C#相关内容，该项目能否对你有价值仅供参考。——2021/06/05
【实例简介】如有疑问，请通过邮箱联系作者！
e-mail : liuyong_0556@qq.com
QQ : 1791053991
一、实训目的
本课程设计的目的旨在帮助学生掌握C#技术，初步掌握软件系统分析、开发和应用的能力，使学生对于信息系统的分析，开发，管理等方面受到较为全面、系统和规范的训练。
二、实训任务及要求
根据立项任务进行需求分析，分析系统的用户需求，系统需求，并形成需求分析说明书，接着根据需求分析说明书进行概要设计，其中包括软件结构的概要设计，系统框架的概要设计，数据结构的概要设计，然后根据概要设计的文档，确定软件结构中的每个模块的内部细节，即详细设计，接着进行编码、测试和运行。
实训的课题为“进销存管理系统”，通过该系统实现对企业商品的销售、进货、库存情况进行综合管理。该系统的开发经过以下几个步骤：
【实例截图】
【核心代码】
三、关键代码：
（1）用户登录
//登录按钮
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text.Trim() == "") //Trim()方法去掉前后的空格；
{
MessageBox.Show("用户名不能为空!", "警告！");
return;
}
if (textBox2.Text.Trim() == "")
{
MessageBox.Show("密码不能为空!", "警告！");
return;
}
//连接数据库
string str = "Server=.\\SQLEXPRESS;DataBase=jxcsystem;Integrated Security=SSPI";
// string str = "Server=(LOCAL);DataBase=jxcsystem;Integrated Security=SSPI";
conn = new SqlConnection(str);
conn.Open();
//选择管理员登录
if (radioButton1.Checked == true)
{
string srt1 = "select * from admin where users='" textBox1.Text.Trim() "' and pwd='" textBox2.Text.Trim() "'";
DataSet myds = new DataSet();
SqlDataAdapter sqlda = new SqlDataAdapter(srt1, conn);
sqlda.Fill(myds);
if (myds.Tables[0].Rows.Count > 0)
{
MessageBox.Show("管理员登录成功！", "提示");
this.Hide();
m.Show();
}
else {
MessageBox.Show("账户或密码有误！", "警告！");
conn.Close();
}
}
//选择员工登录
if (radioButton2.Checked==true)
{
string str2 = "select * from employee where 员工编号='" textBox1.Text.Trim() "' and password='" textBox2.Text.Trim() "'";
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(str2, conn);
da.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
MessageBox.Show("员工登录成功！", "提示");
m.flag = 1; //员工修改密码标识
//员工权限判断
cmd = new SqlCommand("select sales,system,bases,stock,purchase from power where 员工编号 = '" textBox1.Text.Trim() "'", conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
sales = Convert.ToInt32(dr["sales"]);
bases = Convert.ToInt32(dr["bases"]);
system = Convert.ToInt32(dr["system"]);
stock = Convert.ToInt32(dr["stock"]);
purchase = Convert.ToInt32(dr["purchase"]);
}
dr.Dispose();
conn.Close();
if (purchase == 0)
{ m.purchase = 0; }
if (sales == 0)
{ m.sales = 0; }
if (stock == 0)
{ m.stock = 0; }
if (bases == 0)
{ m.bases = 0; }
if (system == 0)
{ m.system = 0; }
m.Show();
this.Hide();
}
else
{
MessageBox.Show("账户或密码有误！", "警告！");
}
}
（2）系统主界面
private void 库存商品ToolStripMenuItem_Click(object sender, EventArgs e)
{
Goods frm = new Goods();
frm.Show();
}
private void 退出ToolStripMenuItem_Click(object sender, EventArgs e)
{
Application.Exit();
}
private void menuStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
{
}
private void Mainform_Load(object sender, EventArgs e)
{
label1.Text = DateTime.Now.ToString();
//employee(员工)无法访问权限管理
if (flag==1)
{
权限管理ToolStripMenuItem.Enabled = false;
}
//基础信息访问限制
if (bases == 0)
{
基础信息ToolStripMenuItem.Enabled = false;
}
//进货管理访问限制
if (purchase == 0)
{
进货管理ToolStripMenuItem.Enabled = false;
}
//销售管理访问限制
if (sales == 0)
{
销售管理ToolStripMenuItem.Enabled = false;
}
//库存管理访问限制
if(stock==0)
{
库存管理ToolStripMenuItem.Enabled = false;
}
//系统维护访问限制
if(system==0)
{
系统维护ToolStripMenuItem.Enabled = false;
}
}
private void 公司员工ToolStripMenuItem_Click(object sender, EventArgs e)
{
employee frm = new employee();
frm.Show();
}
private void 往来单位ToolStripMenuItem_Click(object sender, EventArgs e)
{
Units frm = new Units();
frm.Show();
}
private void 密码修改ToolStripMenuItem_Click(object sender, EventArgs e)
{
repassword frm =new repassword();
frm.flag = flag; //员工修改密码标识
frm.Show();
}
private void 基础信息ToolStripMenuItem_Click(object sender, EventArgs e)
{
}
private void 进货单ToolStripMenuItem_Click(object sender, EventArgs e)
{
Purchase frm = new Purchase();
frm.Show();
}
private void 计算器ToolStripMenuItem_Click(object sender, EventArgs e)
{
//启动微软计算器
System.Diagnostics.Process.Start("calc.exe"); //C:\\WINDOWS\\system32\\calc.exe
}
private void 记事本ToolStripMenuItem_Click(object sender, EventArgs e)
{
//启动微软记事本
System.Diagnostics.Process.Start("notepad.exe");
}
private void 工具ToolStripMenuItem_Click(object sender, EventArgs e)
{
}
private void excelToolStripMenuItem_Click(object sender, EventArgs e)
{
//启动Excel
System.Diagnostics.Process.Start("EXCEL.EXE");
}
private void wordToolStripMenuItem_Click(object sender, EventArgs e)
{
//启动Word
System.Diagnostics.Process.Start("WINWORD.EXE");
}
private void pPtToolStripMenuItem_Click(object sender, EventArgs e)
{
//启动PPt
System.Diagnostics.Process.Start("POWERPNT.EXE");
}
private void 权限管理ToolStripMenuItem_Click(object sender, EventArgs e)
{
Power frm = new Power();
frm.Show();
}
private void 单位信息ToolStripMenuItem_Click(object sender, EventArgs e)
{
Unit frm = new Unit();
frm.Show();
}
private void 进货管理ToolStripMenuItem_Click(object sender, EventArgs e)
{
}
private void label1_Click(object sender, EventArgs e)
{
}
private void timer1_Tick(object sender, EventArgs e)
{
this.label1.Text =" 欢迎登录！" "当前时间：" (DateTime.Now.ToString());
}
private void 关于ToolStripMenuItem_Click(object sender, EventArgs e)
{
}
private void 更多ToolStripMenuItem_Click(object sender, EventArgs e)
{
about frm = new about();
frm.Show();
}
private void 销售统计ToolStripMenuItem_Click(object sender, EventArgs e)
{
saleroom frm = new saleroom();
frm.Show();
}
private void 库存盘点ToolStripMenuItem_Click(object sender, EventArgs e)
{
}
private void 库存盘点ToolStripMenuItem_Click_1(object sender, EventArgs e)
{
Stock frm = new Stock();
frm.Show();
}
private void 库存上限报警ToolStripMenuItem_Click(object sender, EventArgs e)
{
Stocktop frm = new Stocktop();
frm.Show();
}
private void 库存下限报警ToolStripMenuItem_Click(object sender, EventArgs e)
{
Stocklow frm = new Stocklow();
frm.Show();
}
private void 进货退货单ToolStripMenuItem_Click(object sender, EventArgs e)
{
Repurchase frm = new Repurchase();
frm.Show();
}
private void 销售单ToolStripMenuItem_Click(object sender, EventArgs e)
{
Sale frm = new Sale();
frm.Show();
}
private void 销售退货单ToolStripMenuItem_Click(object sender, EventArgs e)
{
Regoods frm = new Regoods();
frm.Show();
}
（3）进货管理
进货单
private void Purchase_Load(object sender, EventArgs e)
{
//获取进货单号、日期
textBox4.Text= DateTime.Now.ToString();
int code = Convert.ToInt32(DateTime.Now.ToString("HHmmss")) 111111;
textBox1.Text = "AH" code;
//string str = "Server=(local);DataBase=jxcsystem;Integrated Security=SSPI";
string str = "Server=.\\sqlexpress;DataBase=jxcsystem;Integrated Security=SSPI";
conn = new SqlConnection(str);
conn.Open();
string sqlstr = "select 商品编号,商品名称,供货单位,数量,进价,总金额 from purchase";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
}
private void button2_Click(object sender, EventArgs e)
{
this.Close();
}
private void button3_Click(object sender, EventArgs e)
{
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox8.Text.Trim() == "" || textBox9.Text.Trim() == "" || textBox2.Text == "" || textBox3.Text == "" || textBox5.Text == "" || textBox6.Text == "" || textBox7.Text == "")
{
MessageBox.Show("不能有空值！", "错误！");
return;
}
//添加进货单记录
conn.Open();
cmd = new SqlCommand("insert into purchase values('" textBox1.Text.Trim() "','" textBox8.Text.Trim() "','" textBox9.Text.Trim() "', '" textBox5.Text.Trim() "' , ' " textBox2.Text.Trim() "', ' ' ,' " Convert.ToSingle(textBox6.Text.Trim()) " ', ' " Convert.ToSingle(textBox7.Text.Trim()) / Convert.ToSingle(textBox6.Text.Trim()) " ' , ' " Convert.ToSingle(textBox7.Text.Trim()) " ' , '" Convert.ToDateTime(textBox4.Text) "', ' " textBox3.Text.Trim() " ')", conn);
cmd.Connection = conn;
cmd.ExecuteNonQuery();
cmd.Dispose();
a = 1;
conn.Close();
if (a==1)
{
conn.Open();
string selectSql = "select * from Goods where 商品编号='" textBox8.Text.Trim() "' ";
SqlCommand sqlcmd = new SqlCommand(selectSql, conn);
sqlcmd.CommandType = CommandType.Text;
sdr = sqlcmd.ExecuteReader();
//根据查询表Goods商品编号的结果判断是否 添加新的商品记录 或 添加对应商品库存数量；
if (sdr.Read() == true)
{
conn.Close();
//获取表Goods中对应的商品数量；
conn.Open();
cmd = new SqlCommand("select 数量 from Goods where 商品编号 = '" textBox8.Text.Trim() "'", conn);
sdr = cmd.ExecuteReader();
while (sdr.Read())
{
qty = Convert.ToSingle(sdr["数量"]); //qty为数量
}
conn.Close();
//实现添加对应商品库存数量
conn.Open();
cmd = new SqlCommand("update Goods set 数量='" (Convert.ToSingle(textBox6.Text.Trim()) qty) "' where 商品编号='" textBox8.Text.Trim() "' ", conn);
cmd.Connection = conn;
cmd.ExecuteNonQuery();
if(cmd.ExecuteNonQuery()>0)
{
b = 1;
}
conn.Close();
}
//实现添加新的商品记录
if (b != 1)
{
conn.Close();
conn.Open();
cmd = new SqlCommand("insert into Goods values('" textBox8.Text.Trim() "','" textBox9.Text.Trim() "','" (Convert.ToSingle(textBox7.Text.Trim()) / Convert.ToSingle(textBox6.Text.Trim()) ) 1 "', '" Convert.ToSingle(textBox6.Text.Trim()) "' ,'" Convert.ToDateTime(textBox4.Text.Trim()) "', ' ' , ' ' ) ", conn);
cmd.Connection = conn;
cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Close();
}
}
MessageBox.Show("添加成功！","提示");
//绑定dataGridView，显示数据；
conn.Open();
string sqlstr = "select 商品编号,商品名称,供货单位,数量,进价,总金额 from purchase";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
//重新获取进货单号、日期 ，其它内容清空；
int code = Convert.ToInt32(DateTime.Now.ToString("HHmmss")) 111111;
textBox1.Text = "AH" code;
textBox4.Text = DateTime.Now.ToString();
textBox2.Text = "";
textBox3.Text = "";
textBox5.Text = "";
textBox6.Text = "";
textBox7.Text = "";
textBox8.Text = "";
textBox9.Text = "";
进货退货单
private void Repurchase_Load(object sender, EventArgs e)
{
//conn = new SqlConnection("Server=(local);DataBase=jxcsystem;Integrated Security=SSPI");
conn = new SqlConnection("Server=.\\SQLEXPRESS;DataBase=jxcsystem;Integrated Security=SSPI");
conn.Open();
string sqlstr = "select * from purchase";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
}
private void button2_Click(object sender, EventArgs e)
{
Application.Exit();
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
intindex = e.RowIndex;
//单击dataGridView控件中的某一行向textBox控件中填充内容；
textBox1.Text = dataGridView1.Rows[intindex].Cells[0].Value.ToString();
textBox2.Text = dataGridView1.Rows[intindex].Cells[1].Value.ToString();
textBox3.Text = dataGridView1.Rows[intindex].Cells[6].Value.ToString();
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text.Trim() == "") //Trim()方法去掉前后的空格；
{
MessageBox.Show("订单编号无效!", "警告！");
return;
}
if (textBox2.Text.Trim() == "")
{
MessageBox.Show("商品编号无效!", "警告！");
return;
}
if (textBox3.Text.Trim() == "")
{
MessageBox.Show("数量不能为空!", "警告！");
return;
}
conn.Open();
cmd = new SqlCommand("select 数量 from Goods where 商品编号 = '" textBox2.Text.Trim() "'", conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
qty = Convert.ToSingle(dr["数量"]); //qty为数量
}
conn.Close();
if (qty== Convert.ToSingle(textBox3.Text.Trim()))
{
conn.Open();
cmd = new SqlCommand("delete from Goods where 商品编号 = '" textBox2.Text.Trim() "'", conn);
dr = cmd.ExecuteReader();
conn.Close();
}
if (Convert.ToSingle(textBox3.Text.Trim()) > qty)
{
MessageBox.Show("数量不能大于库存！","提示");
}
if (qty != Convert.ToSingle(textBox3.Text.Trim()))
{
conn.Open();
cmd = new SqlCommand("update Goods set 数量='" (qty-Convert.ToSingle(textBox3.Text.Trim()) ) "' where 商品编号='" textBox2.Text.Trim() "' ", conn);
cmd.ExecuteNonQuery();
conn.Close();
}
（4）销售管理
销售单
private void Sale_Load(object sender, EventArgs e)
{
//获取进货单号、日期
textBox4.Text = DateTime.Now.ToString();
int code = Convert.ToInt32(DateTime.Now.ToString("HHmmss")) 111111;
textBox1.Text = "AH" code;
//string str = "Server=(local);DataBase=jxcsystem;Integrated Security=SSPI";
string str = "Server=.\\SQLEXPRESS;DataBase=jxcsystem;Integrated Security=SSPI";
conn = new SqlConnection(str);
conn.Open();
string sqlstr = "select 商品编号,商品名称,销售单位,数量,售价,总金额 from sales";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
}
private void button1_Click_1(object sender, EventArgs e)
{
if (textBox8.Text.Trim() == "" || textBox9.Text.Trim() == "" || textBox2.Text == "" || textBox3.Text == "" || textBox5.Text == "" || textBox6.Text == "" || textBox7.Text == "")
{
MessageBox.Show("不能有空值！", "错误！");
return;
}
//添加销售单记录
conn.Open();
cmd = new SqlCommand("insert into sales values('" textBox1.Text.Trim() "','" textBox8.Text.Trim() "','" textBox9.Text.Trim() "', '" textBox5.Text.Trim() "' , ' " textBox2.Text.Trim() "' ,' " Convert.ToSingle(textBox6.Text.Trim()) " ', '" Convert.ToSingle(textBox7.Text.Trim()) "' , ' " Convert.ToSingle(textBox6.Text.Trim()) *Convert.ToSingle(textBox7.Text.Trim()) " ' , '" Convert.ToDateTime(textBox4.Text) "', ' " textBox3.Text.Trim() " ')", conn);
cmd.Connection = conn;
cmd.ExecuteNonQuery();
cmd.Dispose();
a = 1;
conn.Close();
if (a == 1)
{
conn.Open();
string selectSql = "select * from Goods where 商品编号='" textBox8.Text.Trim() "' ";
SqlCommand sqlcmd = new SqlCommand(selectSql, conn);
sqlcmd.CommandType = CommandType.Text;
sdr = sqlcmd.ExecuteReader();
//根据查询表Goods商品编号的结果判断是否 添加新的商品记录 或 添加对应商品库存数量；
if (sdr.Read() == true)
{
conn.Close();
//获取表Goods中对应的商品数量；
conn.Open();
cmd = new SqlCommand("select 数量 from Goods where 商品编号 = '" textBox8.Text.Trim() "'", conn);
sdr = cmd.ExecuteReader();
while (sdr.Read())
{
qty = Convert.ToSingle(sdr["数量"]); //qty为数量
}
conn.Close();
if (Convert.ToSingle(textBox6.Text.Trim()) > qty)
{
MessageBox.Show("数量不能大于库存！", "提示");
}
if (qty == Convert.ToSingle(textBox6.Text.Trim()))
{
conn.Open();
cmd = new SqlCommand("update Goods set 数量='0' where 商品编号='" textBox8.Text.Trim() "' ", conn);
sdr = cmd.ExecuteReader();
conn.Close();
}
if (qty != Convert.ToSingle(textBox6.Text.Trim()))
{
conn.Open();
cmd = new SqlCommand("update Goods set 数量='" (qty - Convert.ToSingle(textBox6.Text.Trim())) "' where 商品编号='" textBox8.Text.Trim() "' ", conn);
cmd.ExecuteNonQuery();
conn.Close();
}
MessageBox.Show("成功！", "提示");
}
else {
MessageBox.Show("商品不存在","错误");
conn.Close();
}
//绑定dataGridView，显示数据；
conn.Open();
string sqlstr = "select 商品编号,商品名称,销售单位,数量,售价,总金额 from sales";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
//重新获取销售单号、日期 ，其它内容清空；
int code = Convert.ToInt32(DateTime.Now.ToString("HHmmss")) 111111;
textBox1.Text = "AH" code;
textBox4.Text = DateTime.Now.ToString();
textBox2.Text = "";
textBox3.Text = "";
textBox5.Text = "";
textBox6.Text = "";
textBox7.Text = "";
textBox8.Text = "";
textBox9.Text = "";
}
销售退货单
private void Regoods_Load(object sender, EventArgs e)
{
//连接数据库
string str = "Server=.\\SQLEXPRESS;DataBase=jxcsystem;Integrated Security=SSPI";
//string str = "Server=(local);DataBase=jxcsystem;Integrated Security=SSPI";
conn = new SqlConnection(str);
conn.Open();
string sqlstr = "select 销售单号,商品编号,商品名称,销售单位,数量,售价,总金额 from sales";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
intindex = e.RowIndex;
//单击dataGridView控件中的某一行向textBox控件中填充内容；
textBox1.Text = dataGridView1.Rows[intindex].Cells[0].Value.ToString();
textBox2.Text = dataGridView1.Rows[intindex].Cells[1].Value.ToString();
textBox3.Text = dataGridView1.Rows[intindex].Cells[4].Value.ToString();
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text.Trim() == "" || textBox2.Text.Trim() == "" || textBox3.Text.Trim() == "")
{
MessageBox.Show("不能为空！","提示");
return;
}
//销售退货
conn.Open();
string selectSql = "select * from sales where 销售单号='" textBox1.Text.Trim() "' and 商品编号='" textBox2.Text.Trim() "'";
SqlCommand sqlcmd = new SqlCommand(selectSql, conn);
sqlcmd.CommandType = CommandType.Text;
sdr = sqlcmd.ExecuteReader();
//根据查询表sales商品编号的结果判断是否 删除销售记录 或 减少销售记录 并 添加对应商品库存数量；
if (sdr.Read() == true)
{
conn.Close();
//获取表Goods中对应的库存商品数量；
conn.Open();
cmd = new SqlCommand("select 数量 from Goods where 商品编号 = '" textBox2.Text.Trim() "'", conn);
sdr = cmd.ExecuteReader();
while (sdr.Read())
{
qty1 = Convert.ToSingle(sdr["数量"]); //qty1为库存数量
}
conn.Close();
//获取表sales中对应的已出售商品数量；
conn.Open();
cmd = new SqlCommand("select 数量 ,售价 from sales where 商品编号 = '" textBox2.Text.Trim() "'", conn);
sdr = cmd.ExecuteReader();
while (sdr.Read())
{
qty2 = Convert.ToSingle(sdr["数量"]); //qty2为销售数量
price = Convert.ToSingle(sdr["售价"]); //price为售价
}
conn.Close();
if (Convert.ToSingle(textBox3.Text.Trim()) > qty2)
{
MessageBox.Show("退货不能大于销售数量！", "提示");
return;
}
if (qty2 == Convert.ToSingle(textBox3.Text.Trim()))
{
conn.Open();
cmd = new SqlCommand("update sales set 数量='0' ,总金额='0' where 销售单号='" textBox1.Text.Trim() "' and 商品编号='" textBox2.Text.Trim() "'", conn);
cmd.ExecuteNonQuery();
conn.Close();
conn.Open();
string srt1 = "select * from sales where 销售单号='" textBox1 .Text.Trim() "' and 商品编号='" textBox2.Text.Trim() "'";
DataSet myds = new DataSet();
SqlDataAdapter sqlda = new SqlDataAdapter(srt1, conn);
sqlda.Fill(myds);
if (myds.Tables[0].Rows.Count > 0)
{
cmd = new SqlCommand("update Goods set 数量='" (qty1 Convert.ToSingle(textBox3.Text.Trim())) "' where 商品编号='" textBox2.Text.Trim() "' ", conn);
cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Close();
}
}
if ( Convert.ToSingle(textBox3.Text.Trim())!=qty2)
{
conn.Open();
cmd = new SqlCommand("update Goods set 数量='" (qty1 Convert.ToSingle(textBox3.Text.Trim())) "' where 商品编号='" textBox2.Text.Trim() "' ", conn);
cmd.ExecuteNonQuery();
conn.Close();
conn.Open();
cmd = new SqlCommand("update sales set 数量='" (qty2 - Convert.ToSingle(textBox3.Text.Trim())) "' ,总金额='" (price * (qty2 - Convert.ToSingle(textBox3.Text.Trim()))) "' where 商品编号='" textBox2.Text.Trim() "'and 销售单号='" textBox1.Text.Trim() "'", conn);
cmd.ExecuteNonQuery();
conn.Close();
}
MessageBox.Show("成功！", "提示");
}
else
{
MessageBox.Show("销售记录或商品不存在", "错误");
conn.Close();
}
conn.Close();
//DataGridView控件刷新显示
conn.Open();
string sqlstr = "select 销售单号,商品编号,商品名称,销售单位,数量,售价,总金额 from sales";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
销售统计
private void saleroom_Load(object sender, EventArgs e)
{
//string str = "Server=(local);DataBase=jxcsystem;Integrated Security=SSPI";
string str = "Server=.\\SQLEXPRESS;DataBase=jxcsystem;Integrated Security=SSPI";
conn = new SqlConnection(str);
conn.Open();
string sqlstr = "select 销售单号,商品编号,商品名称,销售单位,数量,售价,总金额 from sales";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
}
private void button1_Click(object sender, EventArgs e)
{
conn.Open();
cmd = new SqlCommand("select sum(总金额) as SUM from sales ", conn);
sdr = cmd.ExecuteReader();
while (sdr.Read())
{
SUM = Convert.ToString(sdr["SUM"]); //SUM所有销售总金额
}
conn.Close();
textBox1.Text = SUM "元";
}
private void button2_Click(object sender, EventArgs e)
{
if (textBox3.Text.Trim() == "")
{
MessageBox.Show("请输入销售单号", "提示");
return;
}
conn.Open();
string selectSql = "select 总金额 from sales where 销售单号='" textBox3.Text.Trim() "' ";
cmd = new SqlCommand(selectSql, conn);
cmd.CommandType = CommandType.Text;
cmd.Dispose();
sdr =cmd.ExecuteReader();
if (sdr.Read() == true)
{
sum = Convert.ToString(sdr["总金额"]); //sum单条销售总金额
conn.Close();
conn.Open();
string sqlstr = "select * from sales where 销售单号='" textBox3.Text.Trim() "'";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
textBox2.Text = sum "元";
}
else
{
conn.Close();
MessageBox.Show("销售单号不存在！", "警告");
}
（5）库存管理
库存盘点
private void Stock_Load(object sender, EventArgs e)
{
//连接数据库
string str = "Server=.\\SQLEXPRESS;DataBase=jxcsystem;Integrated Security=SSPI";
// string str = "Server=(local);DataBase=jxcsystem;Integrated Security=SSPI";
conn = new SqlConnection(str);
conn.Open();
string sqlstr = "select * from Goods";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text.Trim() == "")
{
MessageBox.Show("请输入商品编号", "提示");
return;
}
conn.Open();
string selectSql = "select * from Goods where 商品编号='" textBox1.Text.Trim() "' ";
SqlCommand sqlcmd = new SqlCommand(selectSql, conn);
sqlcmd.CommandType = CommandType.Text;
sqlcmd.Dispose();
SqlDataReader sdr = sqlcmd.ExecuteReader();
if (sdr.Read() == true)
{
conn.Close();
conn.Open();
string sqlstr = "select * from Goods where 商品编号='" textBox1.Text.Trim() "'";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
textBox1.Text = "";
}
else
{
conn.Close();
MessageBox.Show("商品编号不存在！","警告");
}
库存上限
private void Stocktop_Load(object sender, EventArgs e)
{
string str = "Server=.\\SQLEXPRESS;DataBase=jxcsystem;Integrated Security=SSPI";
//string str = "Server=(local);DataBase=jxcsystem;Integrated Security=SSPI";
conn = new SqlConnection(str);
conn.Open();
string sqlstr = "select 商品编号,商品名称,数量 from Goods order by 数量 desc";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
}
private void button2_Click(object sender, EventArgs e)
{
if (textBox1.Text.Trim() == "")
{
MessageBox.Show("请输入库存上限！", "提示");
return;
}
else
{
qty = Convert.ToSingle(textBox1.Text.Trim()); //qty为库存上限值
MessageBox.Show("OK", "提示");
}
}
private void button1_Click(object sender, EventArgs e)
{
conn.Open();
string str = "select 商品编号,商品名称,数量 from Goods where 数量>='" qty "'";
cmd = new SqlCommand(str, conn);
dr = cmd.ExecuteReader();
if (dr.Read())
{
dr.Dispose();
cmd.Dispose();
conn.Close();
conn.Open();
da = new SqlDataAdapter(str, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
label2.Text = "★ 警告 以上商品库存超限！";
}
else
{
label2.Text = "√ 商品库存正常！";
conn.Close();
}
}
库存下限
private void Stocklow_Load(object sender, EventArgs e)
{
string str = "Server=.\\SQLEXPRESS;DataBase=jxcsystem;Integrated Security=SSPI";
//string str = "Server=(local);DataBase=jxcsystem;Integrated Security=SSPI";
conn = new SqlConnection(str);
conn.Open();
string sqlstr = "select 商品编号,商品名称,数量 from Goods order by 数量";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
}
private void button2_Click(object sender, EventArgs e)
{
if (textBox1.Text.Trim() == "")
{
MessageBox.Show("请输入库存下限！", "提示");
return;
}
else
{
qty = Convert.ToSingle(textBox1.Text.Trim()); //qty为库存下限值
MessageBox.Show("OK", "提示");
}
}
private void button1_Click(object sender, EventArgs e)
{
conn.Open();
string str = "select 商品编号,商品名称,数量 from Goods where 数量 <= ' " qty " ' ";
cmd = new SqlCommand(str, conn);
dr = cmd.ExecuteReader();
if (dr.Read())
{
dr.Dispose();
cmd.Dispose();
conn.Close();
conn.Open();
da = new SqlDataAdapter(str, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
label2.Text = "★ 警告 以上商品库存不足！";
}
else
{
label2.Text = "√ 商品库存正常！";
conn.Close();
}
（6）基础数据管理
库存商品
private void 库存商品_Load(object sender, EventArgs e)
{
//连接数据库
string str = "Server=.\\SQLEXPRESS;DataBase=jxcsystem;Integrated Security=SSPI";
//string str = "Server=(local);DataBase=jxcsystem;Integrated Security=SSPI";
conn = new SqlConnection(str);
conn.Open();
//绑定dataGridView控件显示
//string sqlstr = "select 商品编号,商品名称,[商品价格(元)],生产日期,制造商,产地 from Goods";
string sqlstr = "select * from Goods";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
textBox4.Text = DateTime.Now.ToString();
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
intindex = e.RowIndex;
//获取选中第一行的值，即商品编号值；
str = this.dataGridView1.SelectedCells[0].Value.ToString();
}
//单击dataGridView控件中的某一行向textBox控件中填充内容；
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
intindex = e.RowIndex;
textBox1.Text = dataGridView1.Rows[intindex].Cells[0].Value.ToString();
textBox2.Text = dataGridView1.Rows[intindex].Cells[1].Value.ToString();
textBox3.Text = dataGridView1.Rows[intindex].Cells[2].Value.ToString();
textBox4.Text = dataGridView1.Rows[intindex].Cells[4].Value.ToString();
textBox5.Text = dataGridView1.Rows[intindex].Cells[6].Value.ToString();
textBox6.Text = dataGridView1.Rows[intindex].Cells[5].Value.ToString();
}
//点击编号行删除按钮
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text.Trim() == "")
{
MessageBox.Show("点击选择下列商品编号进行删除","提示");
}
conn.Open();
SqlCommand cmd = new SqlCommand("DELETE from Goods where 商品编号=" textBox1.Text.Trim() "", conn);
cmd.Connection = conn;
cmd.ExecuteNonQuery();
cmd.Dispose();
textBox1.Text= "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox5.Text = "";
textBox6.Text = "";
string sqlstr = "select * from Goods";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
}
//编辑按钮
private void button2_Click(object sender, EventArgs e)
{
groupBox1.Enabled = true; //设置该控件有效，可以在其中进行编辑修改等操作。
}
//添加记录按钮
private void button4_Click(object sender, EventArgs e)
{
groupBox1.Enabled = true;
if (textBox1.Text.Trim() == "")
{
MessageBox.Show("商品编号不能为空！","提示");
return;
}
if (textBox2.Text.Trim() == "")
{
MessageBox.Show("商品名称不能为空！", "提示");
return;
}
if (textBox3.Text.Trim() == "")
{
MessageBox.Show("商品价格不能为空！", "提示");
return;
}
if (textBox4.Text.Trim() == "")
{
MessageBox.Show("日期不能为空！", "提示");
return;
}
conn.Open();
string selectSql = "select * from Goods where 商品编号='" textBox1.Text.Trim() "' ";
SqlCommand sqlcmd = new SqlCommand(selectSql, conn);
sqlcmd.CommandType = CommandType.Text;
sqlcmd.Dispose();
SqlDataReader sdr = sqlcmd.ExecuteReader();
if (sdr.Read()!=true)
{
sdr.Close();
conn.Close();
conn.Open();
SqlCommand cmd = new SqlCommand("insert into Goods values('" textBox1.Text.Trim() "','" textBox2.Text.Trim() "','" Convert.ToSingle(textBox3.Text.Trim()) "', '' ,'" Convert.ToDateTime(textBox4.Text.Trim()) "','" textBox6.Text.Trim() "','" textBox5.Text.Trim() "')", conn);
cmd.Connection = conn;
cmd.ExecuteNonQuery();
cmd.Dispose();
string sqlstr = "select * from Goods";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
MessageBox.Show("成功！");
}
else
{
conn.Close();
MessageBox.Show("请输入新的商品编号！","错误！");
}
conn.Close();
}
private void label6_Click(object sender, EventArgs e)
{
}
//修改记录并保存按钮
private void button5_Click(object sender, EventArgs e)
{
//if (textBox1.Text.Trim() == "")
//{
// MessageBox.Show("日期不能为空！","提示");
// return;
//}
groupBox1.Enabled = false;
conn.Open();
if (textBox1.Text.Trim() ==""||textBox2.Text.Trim() =="")
{
MessageBox.Show("商品编号不能为空！", "错误！");
return;
}
string selectstr="select count(*) from Goods where 商品编号='" textBox1.Text .Trim () "'";
SqlCommand sqlcmd=new SqlCommand(selectstr,conn);
int intConut=Convert.ToInt32(sqlcmd.ExecuteScalar().ToString());
if (intConut!=0)
{
string Updatestr = "update Goods set 商品名称='" textBox2.Text.Trim() "',[商品价格(元)]='" Convert.ToSingle(textBox3.Text.Trim()) "',数量='0',生产日期='" Convert.ToDateTime(textBox4.Text.Trim()) "',制造商='" textBox6.Text.Trim() "',产地='" textBox5.Text.Trim() "' where 商品编号='" textBox1.Text.Trim() "' ";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = Updatestr;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
MessageBox.Show("修改成功！", "提示");
}
else {
MessageBox.Show("编号错误，无法修改记录！", "提示！");
}
conn.Close();
}
//刷新记录
private void button3_Click(object sender, EventArgs e)
{
conn.Open();
string sqlstr = "select * from Goods";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
}
private void groupBox1_Enter(object sender, EventArgs e)
{
}
//查询(搜索)
private void button6_Click(object sender, EventArgs e)
{
if (textBox7.Text.Trim() == "")
{
MessageBox.Show("请输入商品编号", "提示");
return;
}
conn.Open();
string selectSql = "select * from Goods where 商品编号='" textBox7.Text.Trim() "' ";
SqlCommand sqlcmd = new SqlCommand(selectSql, conn);
sqlcmd.CommandType = CommandType.Text;
sqlcmd.Dispose();
SqlDataReader sdr = sqlcmd.ExecuteReader();
if (sdr.Read() == true)
{
conn.Close();
conn.Open();
string sqlstr = "select * from Goods where 商品编号='" textBox7.Text.Trim() "'";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
textBox7.Text = "";
}
else
{
conn.Close();
MessageBox.Show("商品编号不存在！", "警告");
}
}
往来单位
private void Units_Load(object sender, EventArgs e)
{
//连接数据库
string str = "Server=.\\SQLEXPRESS;DataBase=jxcsystem;Integrated Security=SSPI";
//string str = "Server=(local);DataBase=jxcsystem;Integrated Security=SSPI";
conn = new SqlConnection(str);
conn.Open();
//绑定dataGridView控件显示
string sqlstr = "select * from units";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
}
//查询记录
private void button6_Click(object sender, EventArgs e)
{
if (textBox7.Text.Trim() == "")
{
MessageBox.Show("请输入单位编号", "提示");
return;
}
conn.Open();
string selectSql = "select * from units where 单位编号='" textBox7.Text.Trim() "' ";
SqlCommand sqlcmd = new SqlCommand(selectSql, conn);
sqlcmd.CommandType = CommandType.Text;
sqlcmd.Dispose();
SqlDataReader sdr = sqlcmd.ExecuteReader();
if (sdr.Read() == true)
{
conn.Close();
conn.Open();
string sqlstr = "select * from units where 单位编号='" textBox7.Text.Trim() "'";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
textBox7.Text= "";
}
else
{
conn.Close();
MessageBox.Show("单位编号不存在！", "警告");
}
}
//编辑按钮
private void button1_Click(object sender, EventArgs e)
{
groupBox1.Enabled = true; //设置该控件有效，可以在其中进行编辑修改等操作。
}
//修改记录并(保存)按钮
private void button2_Click(object sender, EventArgs e)
{
groupBox1.Enabled = false;
conn.Open();
if (textBox1.Text.Trim() == "" && textBox1.Text.Trim() == "")
{
MessageBox.Show("单位编号不能为空！", "错误！");
return;
}
string selectstr = "select count(*) from units where 单位编号='" textBox1.Text.Trim() "'";
SqlCommand sqlcmd = new SqlCommand(selectstr, conn);
int intConut = Convert.ToInt32(sqlcmd.ExecuteScalar().ToString());
if (intConut != 0)
{
string Updatestr = "update units set 单位名称='" textBox2.Text.Trim() "',单位电话='" textBox3.Text.Trim() "',单位联系人='" textBox4.Text.Trim() "',单位地址='" textBox6.Text.Trim() "',开户银行账号='" textBox5.Text.Trim() "' where 单位编号=' " textBox1.Text.Trim() "' ";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = Updatestr;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
MessageBox.Show("修改成功！", "提示！");
}
else
{
MessageBox.Show("编号错误，无法修改记录！", "提示！");
}
conn.Close();
}
//添加记录按钮
private void button3_Click(object sender, EventArgs e)
{
groupBox1.Enabled = true;
conn.Open();
string selectSql = "select * from units where 单位编号='" textBox1.Text.Trim() "' ";
SqlCommand sqlcmd = new SqlCommand(selectSql, conn);
sqlcmd.CommandType = CommandType.Text;
sqlcmd.Dispose();
SqlDataReader sdr = sqlcmd.ExecuteReader();
if (textBox1.Text.Trim() == "" && textBox1.Text.Trim() == "")
{
MessageBox.Show("单位编号不能为空！", "错误！");
}
else if (sdr.Read() != true)
{
sdr.Close();
SqlCommand cmd = new SqlCommand("insert into units values('" textBox1.Text.Trim() "','" textBox2.Text.Trim() "','" textBox3.Text.Trim() "','" textBox4.Text.Trim() "','" textBox6.Text.Trim() "','" textBox5.Text.Trim() "')", conn);
cmd.Connection = conn;
cmd.ExecuteNonQuery();
cmd.Dispose();
MessageBox.Show("添加成功！", "提示");
}
else
{
MessageBox.Show("请输入新的单位编号！", "错误！");
}
conn.Close();
}
//点击编号行删除按钮
private void button4_Click(object sender, EventArgs e)
{
conn.Open();
SqlCommand cmd = new SqlCommand("DELETE from units where 单位编号=" textBox1.Text.Trim() "", conn);
cmd.Connection = conn;
cmd.ExecuteNonQuery();
cmd.Dispose();
//清空textBox内容
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox5.Text = "";
textBox6.Text = "";
string sqlstr = "select * from units";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
}
//刷新记录按钮
private void button5_Click(object sender, EventArgs e)
{
conn.Open();
string sqlstr = "select * from units";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
}
公司员工
//删除按钮
private void button4_Click(object sender, EventArgs e)
{
if (textBox1.Text == "")
{
MessageBox.Show("请选中删除员工行", "提示");
return;
}
else
{
conn.Open();
SqlCommand cmd = new SqlCommand("DELETE from employee where 员工编号=" textBox1.Text.Trim() "", conn);
cmd.Connection = conn;
cmd.ExecuteNonQuery();
cmd.Dispose();
textBox1.Text = "";
textBox2.Text = "";
textBox4.Text = "";
textBox5.Text = "";
textBox6.Text = "";
string sqlstr = "select 员工编号,员工姓名,员工性别,所属部门,手机号码,备注 from employee";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
}
}
private void label5_Click(object sender, EventArgs e)
{
}
//编辑按钮
private void button1_Click(object sender, EventArgs e)
{
groupBox1.Enabled = true; //设置该控件有效，可以在其中进行编辑修改等操作。
}
//修改记录并保存按钮
private void button2_Click(object sender, EventArgs e)
{
groupBox1.Enabled = false;
if (radioButton1.Checked == true||radioButton1.Checked == true)
{
MessageBox.Show("请选择性别","提示");
}
if (radioButton1.Checked == true)
{
sex = "男";
}
if (radioButton2.Checked == true)
{
sex = "女";
}
conn.Open();
if (textBox1.Text.Trim() == "" || textBox1.Text.Trim() == "")
{
MessageBox.Show("编号不能为空！", "错误！");
return;
}
string selectstr = "select count(*) from employee where 员工编号='" textBox1.Text.Trim() "'";
SqlCommand sqlcmd = new SqlCommand(selectstr, conn);
int intConut = Convert.ToInt32(sqlcmd.ExecuteScalar().ToString());
if (intConut != 0)
{
string Updatestr = "update employee set 员工姓名='" textBox2.Text.Trim() "',员工性别='" sex "',所属部门='" textBox4.Text.Trim() "',手机号码='" textBox5.Text.Trim() "',备注='" textBox6.Text.Trim() "' where 员工编号='" textBox1.Text.Trim() "' ";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = Updatestr;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
MessageBox.Show("修改成功！", "提示");
}
else
{
MessageBox.Show("编号错误，无法修改记录！", "提示！");
}
conn.Close();
}
//添加记录按钮
private void button3_Click(object sender, EventArgs e)
{
groupBox1.Enabled = true;
if (radioButton1.Checked == true || radioButton1.Checked == true)
{
MessageBox.Show("请选择性别", "提示");
}
if (radioButton1.Checked == true)
{
sex = "男";
}
if (radioButton2.Checked == true)
{
sex = "女";
}
conn.Open();
string selectSql = "select * from employee where 员工编号='" textBox1.Text.Trim() "' ";
SqlCommand sqlcmd = new SqlCommand(selectSql, conn);
sqlcmd.CommandType = CommandType.Text;
sqlcmd.Dispose();
SqlDataReader sdr = sqlcmd.ExecuteReader();
if (textBox1.Text.Trim() == "" && textBox1.Text.Trim() == "")
{
MessageBox.Show("编号不能为空！", "错误！");
}
else if (sdr.Read() != true)
{
sdr.Close();
SqlCommand cmd = new SqlCommand("insert into employee values('" textBox1.Text.Trim() "','" textBox2.Text.Trim() "','123','" sex "','" textBox4.Text.Trim() "','" textBox6.Text.Trim() "','" textBox6.Text.Trim() "')", conn);
cmd.Connection = conn;
cmd.ExecuteNonQuery();
cmd.Dispose();
MessageBox.Show("添加成功！刷新显示", "提示！");
flag = 1;
}
else
{
MessageBox.Show("请输入新的员工编号！", "错误！");
}
conn.Close();
//如果添加了新员工，同时向power表中添加员工编号；
if(flag==1)
{
conn.Open();
SqlCommand cmd = new SqlCommand("insert into power values('" textBox1.Text.Trim() "','0','0','0','0','0')", conn);
sdr = cmd.ExecuteReader();
conn.Close();
}
}
//刷新记录按钮
private void button5_Click(object sender, EventArgs e)
{
conn.Open();
string sqlstr = "select 员工编号,员工姓名,员工性别,所属部门,手机号码,备注 from employee";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
}
//清空textBox.Text(取消)按钮
private void button6_Click(object sender, EventArgs e)
{
textBox1.Text = "";
textBox2.Text = "";
radioButton1.Checked = false;
radioButton2.Checked = false;
textBox4.Text = "";
textBox5.Text = "";
textBox6.Text = "";
}
//查询(索搜)按钮;
private void button7_Click(object sender, EventArgs e)
{
if (textBox7.Text.Trim() == "")
{
MessageBox.Show("请输入员工编号", "提示");
return;
}
conn.Open();
string selectSql = "select * from employee where 员工编号='" textBox7.Text.Trim() "' ";
SqlCommand sqlcmd = new SqlCommand(selectSql, conn);
sqlcmd.CommandType = CommandType.Text;
sqlcmd.Dispose();
SqlDataReader sdr = sqlcmd.ExecuteReader();
if (sdr.Read() == true)
{
conn.Close();
conn.Open();
string sqlstr = "select 员工编号,员工姓名,员工性别,所属部门,手机号码,备注 from employee where 员工编号='" textBox7.Text.Trim() "'";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
textBox7.Text = "";
}
else
{
conn.Close();
MessageBox.Show("员工编号不存在！", "警告");
}
密码修改
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text.Trim() == "")
{
MessageBox.Show("用户名不能为空！", "警告");
return;
}
if (textBox2.Text.Trim() == "")
{
MessageBox.Show("密码不能为空！", "警告");
return;
}
if (textBox3.Text.Trim() == "")
{
MessageBox.Show("密码不能为空！", "警告");
return;
}
conn.Open();
if (flag==1)
{
//员工修改密码
string selectSql = "select * from employee where 员工编号='" textBox1.Text.Trim() "' and password='" textBox2.Text.Trim() "'";
SqlCommand sqlcmd = new SqlCommand(selectSql, conn);
sqlcmd.CommandType = CommandType.Text;
SqlDataReader sdr = sqlcmd.ExecuteReader();
if (sdr.Read() == true)
{
sdr.Close();
string Updatestr = "update employee set password='" textBox3.Text.Trim() "' where 员工编号='" textBox1.Text.Trim() "' ";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = Updatestr;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
sqlcmd.Dispose();
MessageBox.Show("密码修改成功！", "提示");
}
else
{
MessageBox.Show("用户名或密码错误，无法修改密码！", "提示！");
}
}
else
{
//管理员修改密码
string selectSql = "select * from admin where users='" textBox1.Text.Trim() "' and pwd='" textBox2.Text.Trim() "'";
SqlCommand sqlcmd = new SqlCommand(selectSql, conn);
sqlcmd.CommandType = CommandType.Text;
SqlDataReader sdr = sqlcmd.ExecuteReader();
if (sdr.Read() == true)
{
sdr.Close();
string Updatestr = "update admin set pwd='" textBox3.Text.Trim() "' where users='" textBox1.Text.Trim() "' ";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = Updatestr;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
sqlcmd.Dispose();
MessageBox.Show("密码修改成功！", "提示");
}
else
{
MessageBox.Show("用户名或密码错误，无法修改密码！", "提示！");
}
}
conn.Close();
}
//重置密码按钮
private void button2_Click(object sender, EventArgs e)
{
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
}
（7）系统维护管理
本单位信息
private void Unit_Load(object sender, EventArgs e)
{
textBox7.Text = "A001";
conn = new SqlConnection("Server=.\\SQLEXPRESS;DataBase=jxcsystem;Integrated Security=SSPI");
//conn = new SqlConnection("Server=(local);DataBase=jxcsystem;Integrated Security=SSPI");
conn.Open();
string sql = "select * from units ";
SqlCommand myCommand = new SqlCommand(sql, conn);
myReader = myCommand.ExecuteReader();
while (myReader.Read())
{
textBox1.Text = myReader["单位名称"].ToString();
textBox2.Text = myReader["单位联系人"].ToString();
textBox4.Text = myReader["单位电话"].ToString();
textBox6.Text = myReader["单位地址"].ToString();
textBox5.Text = myReader["开户银行账号"].ToString();
}
conn.Close();
}
private void button1_Click(object sender, EventArgs e)
{
conn.Open();
//更新记录
string updatestr = "update units set 单位名称='" textBox1.Text.Trim() "',单位联系人='" textBox2.Text.Trim() "',单位电话='" textBox4.Text.Trim() "',开户银行账号='" textBox5.Text.Trim() "' ,单位地址='" textBox6.Text.Trim() "' where 单位编号='" textBox7.Text.Trim() "' ";
SqlCommand cmd = new SqlCommand(updatestr, conn);
cmd.Connection = conn;
cmd.ExecuteNonQuery();
if (Convert.ToInt32(cmd.ExecuteNonQuery()) > 0)
{
MessageBox.Show("更新成功!");
}
else
{
MessageBox.Show("更新失败!");
}
cmd.Dispose();
conn.Close();
权限管理
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text.Trim() == "")
{
MessageBox.Show("员工编号不能为空", "提示！");
return;
}else
{
conn.Open();
string srt1 = "select * from employee where 员工编号='" textBox1.Text.Trim() "' ";
SqlCommand cmd = new SqlCommand(srt1, conn);
cmd.CommandType = CommandType.Text;
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read() != true)
{
MessageBox.Show("编号无效！", "提示");
conn.Close();
}
conn.Close();
}
if (checkBox1.Checked== true)
{
conn.Open();
string Updatestr = "update power set sales='1' where 员工编号='" textBox1.Text.Trim() "'";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = Updatestr;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
conn.Close();
} else
{
conn.Open();
string Updatestr = "update power set sales='0' where 员工编号='" textBox1.Text.Trim() "'";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = Updatestr;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
conn.Close();
}
if (checkBox2.Checked == true)
{
conn.Open();
string Updatestr = "update power set bases='1' where 员工编号='" textBox1.Text.Trim() "'";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = Updatestr;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
conn.Close();
} else
{
conn.Open();
string Updatestr = "update power set bases='0' where 员工编号='" textBox1.Text.Trim() "'";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = Updatestr;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
conn.Close();
}
if (checkBox3.Checked == true)
{
conn.Open();
string Updatestr = "update power set system='1' where 员工编号='" textBox1.Text.Trim() "'";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = Updatestr;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
conn.Close();
} else
{
conn.Open();
string Updatestr = "update power set system='0' where 员工编号='" textBox1.Text.Trim() "'";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = Updatestr;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
conn.Close();
}
if (checkBox4.Checked == true)
{
conn.Open();
string Updatestr = "update power set purchase='1' where 员工编号='" textBox1.Text.Trim() "'";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = Updatestr;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
conn.Close();
} else
{
conn.Open();
string Updatestr = "update power set purchase='0' where 员工编号='" textBox1.Text.Trim() "'";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = Updatestr;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
conn.Close();
}
if (checkBox5.Checked == true)
{
conn.Open();
string Updatestr = "update power set stock='1' where 员工编号='" textBox1.Text.Trim() "'";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = Updatestr;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
conn.Close();
} else
{
conn.Open();
string Updatestr = "update power set stock='0' where 员工编号='" textBox1.Text.Trim() "'";
三、关键代码：
（1）用户登录
//登录按钮
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text.Trim() == "") //Trim()方法去掉前后的空格；
{
MessageBox.Show("用户名不能为空!", "警告！");
return;
}
if (textBox2.Text.Trim() == "")
{
MessageBox.Show("密码不能为空!", "警告！");
return;
}
//连接数据库
string str = "Server=.\\SQLEXPRESS;DataBase=jxcsystem;Integrated Security=SSPI";
// string str = "Server=(LOCAL);DataBase=jxcsystem;Integrated Security=SSPI";
conn = new SqlConnection(str);
conn.Open();
//选择管理员登录
if (radioButton1.Checked == true)
{
string srt1 = "select * from admin where users='" textBox1.Text.Trim() "' and pwd='" textBox2.Text.Trim() "'";
DataSet myds = new DataSet();
SqlDataAdapter sqlda = new SqlDataAdapter(srt1, conn);
sqlda.Fill(myds);
if (myds.Tables[0].Rows.Count > 0)
{
MessageBox.Show("管理员登录成功！", "提示");
this.Hide();
m.Show();
}
else {
MessageBox.Show("账户或密码有误！", "警告！");
conn.Close();
}
}
//选择员工登录
if (radioButton2.Checked==true)
{
string str2 = "select * from employee where 员工编号='" textBox1.Text.Trim() "' and password='" textBox2.Text.Trim() "'";
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(str2, conn);
da.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
MessageBox.Show("员工登录成功！", "提示");
m.flag = 1; //员工修改密码标识
//员工权限判断
cmd = new SqlCommand("select sales,system,bases,stock,purchase from power where 员工编号 = '" textBox1.Text.Trim() "'", conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
sales = Convert.ToInt32(dr["sales"]);
bases = Convert.ToInt32(dr["bases"]);
system = Convert.ToInt32(dr["system"]);
stock = Convert.ToInt32(dr["stock"]);
purchase = Convert.ToInt32(dr["purchase"]);
}
dr.Dispose();
conn.Close();
if (purchase == 0)
{ m.purchase = 0; }
if (sales == 0)
{ m.sales = 0; }
if (stock == 0)
{ m.stock = 0; }
if (bases == 0)
{ m.bases = 0; }
if (system == 0)
{ m.system = 0; }
m.Show();
this.Hide();
}
else
{
MessageBox.Show("账户或密码有误！", "警告！");
}
}
（2）系统主界面
private void 库存商品ToolStripMenuItem_Click(object sender, EventArgs e)
{
Goods frm = new Goods();
frm.Show();
}
private void 退出ToolStripMenuItem_Click(object sender, EventArgs e)
{
Application.Exit();
}
private void menuStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
{
}
private void Mainform_Load(object sender, EventArgs e)
{
label1.Text = DateTime.Now.ToString();
//employee(员工)无法访问权限管理
if (flag==1)
{
权限管理ToolStripMenuItem.Enabled = false;
}
//基础信息访问限制
if (bases == 0)
{
基础信息ToolStripMenuItem.Enabled = false;
}
//进货管理访问限制
if (purchase == 0)
{
进货管理ToolStripMenuItem.Enabled = false;
}
//销售管理访问限制
if (sales == 0)
{
销售管理ToolStripMenuItem.Enabled = false;
}
//库存管理访问限制
if(stock==0)
{
库存管理ToolStripMenuItem.Enabled = false;
}
//系统维护访问限制
if(system==0)
{
系统维护ToolStripMenuItem.Enabled = false;
}
}
private void 公司员工ToolStripMenuItem_Click(object sender, EventArgs e)
{
employee frm = new employee();
frm.Show();
}
private void 往来单位ToolStripMenuItem_Click(object sender, EventArgs e)
{
Units frm = new Units();
frm.Show();
}
private void 密码修改ToolStripMenuItem_Click(object sender, EventArgs e)
{
repassword frm =new repassword();
frm.flag = flag; //员工修改密码标识
frm.Show();
}
private void 基础信息ToolStripMenuItem_Click(object sender, EventArgs e)
{
}
private void 进货单ToolStripMenuItem_Click(object sender, EventArgs e)
{
Purchase frm = new Purchase();
frm.Show();
}
private void 计算器ToolStripMenuItem_Click(object sender, EventArgs e)
{
//启动微软计算器
System.Diagnostics.Process.Start("calc.exe"); //C:\\WINDOWS\\system32\\calc.exe
}
private void 记事本ToolStripMenuItem_Click(object sender, EventArgs e)
{
//启动微软记事本
System.Diagnostics.Process.Start("notepad.exe");
}
private void 工具ToolStripMenuItem_Click(object sender, EventArgs e)
{
}
private void excelToolStripMenuItem_Click(object sender, EventArgs e)
{
//启动Excel
System.Diagnostics.Process.Start("EXCEL.EXE");
}
private void wordToolStripMenuItem_Click(object sender, EventArgs e)
{
//启动Word
System.Diagnostics.Process.Start("WINWORD.EXE");
}
private void pPtToolStripMenuItem_Click(object sender, EventArgs e)
{
//启动PPt
System.Diagnostics.Process.Start("POWERPNT.EXE");
}
private void 权限管理ToolStripMenuItem_Click(object sender, EventArgs e)
{
Power frm = new Power();
frm.Show();
}
private void 单位信息ToolStripMenuItem_Click(object sender, EventArgs e)
{
Unit frm = new Unit();
frm.Show();
}
private void 进货管理ToolStripMenuItem_Click(object sender, EventArgs e)
{
}
private void label1_Click(object sender, EventArgs e)
{
}
private void timer1_Tick(object sender, EventArgs e)
{
this.label1.Text =" 欢迎登录！" "当前时间：" (DateTime.Now.ToString());
}
private void 关于ToolStripMenuItem_Click(object sender, EventArgs e)
{
}
private void 更多ToolStripMenuItem_Click(object sender, EventArgs e)
{
about frm = new about();
frm.Show();
}
private void 销售统计ToolStripMenuItem_Click(object sender, EventArgs e)
{
saleroom frm = new saleroom();
frm.Show();
}
private void 库存盘点ToolStripMenuItem_Click(object sender, EventArgs e)
{
}
private void 库存盘点ToolStripMenuItem_Click_1(object sender, EventArgs e)
{
Stock frm = new Stock();
frm.Show();
}
private void 库存上限报警ToolStripMenuItem_Click(object sender, EventArgs e)
{
Stocktop frm = new Stocktop();
frm.Show();
}
private void 库存下限报警ToolStripMenuItem_Click(object sender, EventArgs e)
{
Stocklow frm = new Stocklow();
frm.Show();
}
private void 进货退货单ToolStripMenuItem_Click(object sender, EventArgs e)
{
Repurchase frm = new Repurchase();
frm.Show();
}
private void 销售单ToolStripMenuItem_Click(object sender, EventArgs e)
{
Sale frm = new Sale();
frm.Show();
}
private void 销售退货单ToolStripMenuItem_Click(object sender, EventArgs e)
{
Regoods frm = new Regoods();
frm.Show();
}
（3）进货管理
进货单
private void Purchase_Load(object sender, EventArgs e)
{
//获取进货单号、日期
textBox4.Text= DateTime.Now.ToString();
int code = Convert.ToInt32(DateTime.Now.ToString("HHmmss")) 111111;
textBox1.Text = "AH" code;
//string str = "Server=(local);DataBase=jxcsystem;Integrated Security=SSPI";
string str = "Server=.\\sqlexpress;DataBase=jxcsystem;Integrated Security=SSPI";
conn = new SqlConnection(str);
conn.Open();
string sqlstr = "select 商品编号,商品名称,供货单位,数量,进价,总金额 from purchase";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
}
private void button2_Click(object sender, EventArgs e)
{
this.Close();
}
private void button3_Click(object sender, EventArgs e)
{
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox8.Text.Trim() == "" || textBox9.Text.Trim() == "" || textBox2.Text == "" || textBox3.Text == "" || textBox5.Text == "" || textBox6.Text == "" || textBox7.Text == "")
{
MessageBox.Show("不能有空值！", "错误！");
return;
}
//添加进货单记录
conn.Open();
cmd = new SqlCommand("insert into purchase values('" textBox1.Text.Trim() "','" textBox8.Text.Trim() "','" textBox9.Text.Trim() "', '" textBox5.Text.Trim() "' , ' " textBox2.Text.Trim() "', ' ' ,' " Convert.ToSingle(textBox6.Text.Trim()) " ', ' " Convert.ToSingle(textBox7.Text.Trim()) / Convert.ToSingle(textBox6.Text.Trim()) " ' , ' " Convert.ToSingle(textBox7.Text.Trim()) " ' , '" Convert.ToDateTime(textBox4.Text) "', ' " textBox3.Text.Trim() " ')", conn);
cmd.Connection = conn;
cmd.ExecuteNonQuery();
cmd.Dispose();
a = 1;
conn.Close();
if (a==1)
{
conn.Open();
string selectSql = "select * from Goods where 商品编号='" textBox8.Text.Trim() "' ";
SqlCommand sqlcmd = new SqlCommand(selectSql, conn);
sqlcmd.CommandType = CommandType.Text;
sdr = sqlcmd.ExecuteReader();
//根据查询表Goods商品编号的结果判断是否 添加新的商品记录 或 添加对应商品库存数量；
if (sdr.Read() == true)
{
conn.Close();
//获取表Goods中对应的商品数量；
conn.Open();
cmd = new SqlCommand("select 数量 from Goods where 商品编号 = '" textBox8.Text.Trim() "'", conn);
sdr = cmd.ExecuteReader();
while (sdr.Read())
{
qty = Convert.ToSingle(sdr["数量"]); //qty为数量
}
conn.Close();
//实现添加对应商品库存数量
conn.Open();
cmd = new SqlCommand("update Goods set 数量='" (Convert.ToSingle(textBox6.Text.Trim()) qty) "' where 商品编号='" textBox8.Text.Trim() "' ", conn);
cmd.Connection = conn;
cmd.ExecuteNonQuery();
if(cmd.ExecuteNonQuery()>0)
{
b = 1;
}
conn.Close();
}
//实现添加新的商品记录
if (b != 1)
{
conn.Close();
conn.Open();
cmd = new SqlCommand("insert into Goods values('" textBox8.Text.Trim() "','" textBox9.Text.Trim() "','" (Convert.ToSingle(textBox7.Text.Trim()) / Convert.ToSingle(textBox6.Text.Trim()) ) 1 "', '" Convert.ToSingle(textBox6.Text.Trim()) "' ,'" Convert.ToDateTime(textBox4.Text.Trim()) "', ' ' , ' ' ) ", conn);
cmd.Connection = conn;
cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Close();
}
}
MessageBox.Show("添加成功！","提示");
//绑定dataGridView，显示数据；
conn.Open();
string sqlstr = "select 商品编号,商品名称,供货单位,数量,进价,总金额 from purchase";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
//重新获取进货单号、日期 ，其它内容清空；
int code = Convert.ToInt32(DateTime.Now.ToString("HHmmss")) 111111;
textBox1.Text = "AH" code;
textBox4.Text = DateTime.Now.ToString();
textBox2.Text = "";
textBox3.Text = "";
textBox5.Text = "";
textBox6.Text = "";
textBox7.Text = "";
textBox8.Text = "";
textBox9.Text = "";
进货退货单
private void Repurchase_Load(object sender, EventArgs e)
{
//conn = new SqlConnection("Server=(local);DataBase=jxcsystem;Integrated Security=SSPI");
conn = new SqlConnection("Server=.\\SQLEXPRESS;DataBase=jxcsystem;Integrated Security=SSPI");
conn.Open();
string sqlstr = "select * from purchase";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
}
private void button2_Click(object sender, EventArgs e)
{
Application.Exit();
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
intindex = e.RowIndex;
//单击dataGridView控件中的某一行向textBox控件中填充内容；
textBox1.Text = dataGridView1.Rows[intindex].Cells[0].Value.ToString();
textBox2.Text = dataGridView1.Rows[intindex].Cells[1].Value.ToString();
textBox3.Text = dataGridView1.Rows[intindex].Cells[6].Value.ToString();
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text.Trim() == "") //Trim()方法去掉前后的空格；
{
MessageBox.Show("订单编号无效!", "警告！");
return;
}
if (textBox2.Text.Trim() == "")
{
MessageBox.Show("商品编号无效!", "警告！");
return;
}
if (textBox3.Text.Trim() == "")
{
MessageBox.Show("数量不能为空!", "警告！");
return;
}
conn.Open();
cmd = new SqlCommand("select 数量 from Goods where 商品编号 = '" textBox2.Text.Trim() "'", conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
qty = Convert.ToSingle(dr["数量"]); //qty为数量
}
conn.Close();
if (qty== Convert.ToSingle(textBox3.Text.Trim()))
{
conn.Open();
cmd = new SqlCommand("delete from Goods where 商品编号 = '" textBox2.Text.Trim() "'", conn);
dr = cmd.ExecuteReader();
conn.Close();
}
if (Convert.ToSingle(textBox3.Text.Trim()) > qty)
{
MessageBox.Show("数量不能大于库存！","提示");
}
if (qty != Convert.ToSingle(textBox3.Text.Trim()))
{
conn.Open();
cmd = new SqlCommand("update Goods set 数量='" (qty-Convert.ToSingle(textBox3.Text.Trim()) ) "' where 商品编号='" textBox2.Text.Trim() "' ", conn);
cmd.ExecuteNonQuery();
conn.Close();
}
（4）销售管理
销售单
private void Sale_Load(object sender, EventArgs e)
{
//获取进货单号、日期
textBox4.Text = DateTime.Now.ToString();
int code = Convert.ToInt32(DateTime.Now.ToString("HHmmss")) 111111;
textBox1.Text = "AH" code;
//string str = "Server=(local);DataBase=jxcsystem;Integrated Security=SSPI";
string str = "Server=.\\SQLEXPRESS;DataBase=jxcsystem;Integrated Security=SSPI";
conn = new SqlConnection(str);
conn.Open();
string sqlstr = "select 商品编号,商品名称,销售单位,数量,售价,总金额 from sales";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
}
private void button1_Click_1(object sender, EventArgs e)
{
if (textBox8.Text.Trim() == "" || textBox9.Text.Trim() == "" || textBox2.Text == "" || textBox3.Text == "" || textBox5.Text == "" || textBox6.Text == "" || textBox7.Text == "")
{
MessageBox.Show("不能有空值！", "错误！");
return;
}
//添加销售单记录
conn.Open();
cmd = new SqlCommand("insert into sales values('" textBox1.Text.Trim() "','" textBox8.Text.Trim() "','" textBox9.Text.Trim() "', '" textBox5.Text.Trim() "' , ' " textBox2.Text.Trim() "' ,' " Convert.ToSingle(textBox6.Text.Trim()) " ', '" Convert.ToSingle(textBox7.Text.Trim()) "' , ' " Convert.ToSingle(textBox6.Text.Trim()) *Convert.ToSingle(textBox7.Text.Trim()) " ' , '" Convert.ToDateTime(textBox4.Text) "', ' " textBox3.Text.Trim() " ')", conn);
cmd.Connection = conn;
cmd.ExecuteNonQuery();
cmd.Dispose();
a = 1;
conn.Close();
if (a == 1)
{
conn.Open();
string selectSql = "select * from Goods where 商品编号='" textBox8.Text.Trim() "' ";
SqlCommand sqlcmd = new SqlCommand(selectSql, conn);
sqlcmd.CommandType = CommandType.Text;
sdr = sqlcmd.ExecuteReader();
//根据查询表Goods商品编号的结果判断是否 添加新的商品记录 或 添加对应商品库存数量；
if (sdr.Read() == true)
{
conn.Close();
//获取表Goods中对应的商品数量；
conn.Open();
cmd = new SqlCommand("select 数量 from Goods where 商品编号 = '" textBox8.Text.Trim() "'", conn);
sdr = cmd.ExecuteReader();
while (sdr.Read())
{
qty = Convert.ToSingle(sdr["数量"]); //qty为数量
}
conn.Close();
if (Convert.ToSingle(textBox6.Text.Trim()) > qty)
{
MessageBox.Show("数量不能大于库存！", "提示");
}
if (qty == Convert.ToSingle(textBox6.Text.Trim()))
{
conn.Open();
cmd = new SqlCommand("update Goods set 数量='0' where 商品编号='" textBox8.Text.Trim() "' ", conn);
sdr = cmd.ExecuteReader();
conn.Close();
}
if (qty != Convert.ToSingle(textBox6.Text.Trim()))
{
conn.Open();
cmd = new SqlCommand("update Goods set 数量='" (qty - Convert.ToSingle(textBox6.Text.Trim())) "' where 商品编号='" textBox8.Text.Trim() "' ", conn);
cmd.ExecuteNonQuery();
conn.Close();
}
MessageBox.Show("成功！", "提示");
}
else {
MessageBox.Show("商品不存在","错误");
conn.Close();
}
//绑定dataGridView，显示数据；
conn.Open();
string sqlstr = "select 商品编号,商品名称,销售单位,数量,售价,总金额 from sales";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
//重新获取销售单号、日期 ，其它内容清空；
int code = Convert.ToInt32(DateTime.Now.ToString("HHmmss")) 111111;
textBox1.Text = "AH" code;
textBox4.Text = DateTime.Now.ToString();
textBox2.Text = "";
textBox3.Text = "";
textBox5.Text = "";
textBox6.Text = "";
textBox7.Text = "";
textBox8.Text = "";
textBox9.Text = "";
}
销售退货单
private void Regoods_Load(object sender, EventArgs e)
{
//连接数据库
string str = "Server=.\\SQLEXPRESS;DataBase=jxcsystem;Integrated Security=SSPI";
//string str = "Server=(local);DataBase=jxcsystem;Integrated Security=SSPI";
conn = new SqlConnection(str);
conn.Open();
string sqlstr = "select 销售单号,商品编号,商品名称,销售单位,数量,售价,总金额 from sales";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
intindex = e.RowIndex;
//单击dataGridView控件中的某一行向textBox控件中填充内容；
textBox1.Text = dataGridView1.Rows[intindex].Cells[0].Value.ToString();
textBox2.Text = dataGridView1.Rows[intindex].Cells[1].Value.ToString();
textBox3.Text = dataGridView1.Rows[intindex].Cells[4].Value.ToString();
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text.Trim() == "" || textBox2.Text.Trim() == "" || textBox3.Text.Trim() == "")
{
MessageBox.Show("不能为空！","提示");
return;
}
//销售退货
conn.Open();
string selectSql = "select * from sales where 销售单号='" textBox1.Text.Trim() "' and 商品编号='" textBox2.Text.Trim() "'";
SqlCommand sqlcmd = new SqlCommand(selectSql, conn);
sqlcmd.CommandType = CommandType.Text;
sdr = sqlcmd.ExecuteReader();
//根据查询表sales商品编号的结果判断是否 删除销售记录 或 减少销售记录 并 添加对应商品库存数量；
if (sdr.Read() == true)
{
conn.Close();
//获取表Goods中对应的库存商品数量；
conn.Open();
cmd = new SqlCommand("select 数量 from Goods where 商品编号 = '" textBox2.Text.Trim() "'", conn);
sdr = cmd.ExecuteReader();
while (sdr.Read())
{
qty1 = Convert.ToSingle(sdr["数量"]); //qty1为库存数量
}
conn.Close();
//获取表sales中对应的已出售商品数量；
conn.Open();
cmd = new SqlCommand("select 数量 ,售价 from sales where 商品编号 = '" textBox2.Text.Trim() "'", conn);
sdr = cmd.ExecuteReader();
while (sdr.Read())
{
qty2 = Convert.ToSingle(sdr["数量"]); //qty2为销售数量
price = Convert.ToSingle(sdr["售价"]); //price为售价
}
conn.Close();
if (Convert.ToSingle(textBox3.Text.Trim()) > qty2)
{
MessageBox.Show("退货不能大于销售数量！", "提示");
return;
}
if (qty2 == Convert.ToSingle(textBox3.Text.Trim()))
{
conn.Open();
cmd = new SqlCommand("update sales set 数量='0' ,总金额='0' where 销售单号='" textBox1.Text.Trim() "' and 商品编号='" textBox2.Text.Trim() "'", conn);
cmd.ExecuteNonQuery();
conn.Close();
conn.Open();
string srt1 = "select * from sales where 销售单号='" textBox1 .Text.Trim() "' and 商品编号='" textBox2.Text.Trim() "'";
DataSet myds = new DataSet();
SqlDataAdapter sqlda = new SqlDataAdapter(srt1, conn);
sqlda.Fill(myds);
if (myds.Tables[0].Rows.Count > 0)
{
cmd = new SqlCommand("update Goods set 数量='" (qty1 Convert.ToSingle(textBox3.Text.Trim())) "' where 商品编号='" textBox2.Text.Trim() "' ", conn);
cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Close();
}
}
if ( Convert.ToSingle(textBox3.Text.Trim())!=qty2)
{
conn.Open();
cmd = new SqlCommand("update Goods set 数量='" (qty1 Convert.ToSingle(textBox3.Text.Trim())) "' where 商品编号='" textBox2.Text.Trim() "' ", conn);
cmd.ExecuteNonQuery();
conn.Close();
conn.Open();
cmd = new SqlCommand("update sales set 数量='" (qty2 - Convert.ToSingle(textBox3.Text.Trim())) "' ,总金额='" (price * (qty2 - Convert.ToSingle(textBox3.Text.Trim()))) "' where 商品编号='" textBox2.Text.Trim() "'and 销售单号='" textBox1.Text.Trim() "'", conn);
cmd.ExecuteNonQuery();
conn.Close();
}
MessageBox.Show("成功！", "提示");
}
else
{
MessageBox.Show("销售记录或商品不存在", "错误");
conn.Close();
}
conn.Close();
//DataGridView控件刷新显示
conn.Open();
string sqlstr = "select 销售单号,商品编号,商品名称,销售单位,数量,售价,总金额 from sales";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
销售统计
private void saleroom_Load(object sender, EventArgs e)
{
//string str = "Server=(local);DataBase=jxcsystem;Integrated Security=SSPI";
string str = "Server=.\\SQLEXPRESS;DataBase=jxcsystem;Integrated Security=SSPI";
conn = new SqlConnection(str);
conn.Open();
string sqlstr = "select 销售单号,商品编号,商品名称,销售单位,数量,售价,总金额 from sales";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
}
private void button1_Click(object sender, EventArgs e)
{
conn.Open();
cmd = new SqlCommand("select sum(总金额) as SUM from sales ", conn);
sdr = cmd.ExecuteReader();
while (sdr.Read())
{
SUM = Convert.ToString(sdr["SUM"]); //SUM所有销售总金额
}
conn.Close();
textBox1.Text = SUM "元";
}
private void button2_Click(object sender, EventArgs e)
{
if (textBox3.Text.Trim() == "")
{
MessageBox.Show("请输入销售单号", "提示");
return;
}
conn.Open();
string selectSql = "select 总金额 from sales where 销售单号='" textBox3.Text.Trim() "' ";
cmd = new SqlCommand(selectSql, conn);
cmd.CommandType = CommandType.Text;
cmd.Dispose();
sdr =cmd.ExecuteReader();
if (sdr.Read() == true)
{
sum = Convert.ToString(sdr["总金额"]); //sum单条销售总金额
conn.Close();
conn.Open();
string sqlstr = "select * from sales where 销售单号='" textBox3.Text.Trim() "'";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
textBox2.Text = sum "元";
}
else
{
conn.Close();
MessageBox.Show("销售单号不存在！", "警告");
}
（5）库存管理
库存盘点
private void Stock_Load(object sender, EventArgs e)
{
//连接数据库
string str = "Server=.\\SQLEXPRESS;DataBase=jxcsystem;Integrated Security=SSPI";
// string str = "Server=(local);DataBase=jxcsystem;Integrated Security=SSPI";
conn = new SqlConnection(str);
conn.Open();
string sqlstr = "select * from Goods";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text.Trim() == "")
{
MessageBox.Show("请输入商品编号", "提示");
return;
}
conn.Open();
string selectSql = "select * from Goods where 商品编号='" textBox1.Text.Trim() "' ";
SqlCommand sqlcmd = new SqlCommand(selectSql, conn);
sqlcmd.CommandType = CommandType.Text;
sqlcmd.Dispose();
SqlDataReader sdr = sqlcmd.ExecuteReader();
if (sdr.Read() == true)
{
conn.Close();
conn.Open();
string sqlstr = "select * from Goods where 商品编号='" textBox1.Text.Trim() "'";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
textBox1.Text = "";
}
else
{
conn.Close();
MessageBox.Show("商品编号不存在！","警告");
}
库存上限
private void Stocktop_Load(object sender, EventArgs e)
{
string str = "Server=.\\SQLEXPRESS;DataBase=jxcsystem;Integrated Security=SSPI";
//string str = "Server=(local);DataBase=jxcsystem;Integrated Security=SSPI";
conn = new SqlConnection(str);
conn.Open();
string sqlstr = "select 商品编号,商品名称,数量 from Goods order by 数量 desc";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
}
private void button2_Click(object sender, EventArgs e)
{
if (textBox1.Text.Trim() == "")
{
MessageBox.Show("请输入库存上限！", "提示");
return;
}
else
{
qty = Convert.ToSingle(textBox1.Text.Trim()); //qty为库存上限值
MessageBox.Show("OK", "提示");
}
}
private void button1_Click(object sender, EventArgs e)
{
conn.Open();
string str = "select 商品编号,商品名称,数量 from Goods where 数量>='" qty "'";
cmd = new SqlCommand(str, conn);
dr = cmd.ExecuteReader();
if (dr.Read())
{
dr.Dispose();
cmd.Dispose();
conn.Close();
conn.Open();
da = new SqlDataAdapter(str, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
label2.Text = "★ 警告 以上商品库存超限！";
}
else
{
label2.Text = "√ 商品库存正常！";
conn.Close();
}
}
库存下限
private void Stocklow_Load(object sender, EventArgs e)
{
string str = "Server=.\\SQLEXPRESS;DataBase=jxcsystem;Integrated Security=SSPI";
//string str = "Server=(local);DataBase=jxcsystem;Integrated Security=SSPI";
conn = new SqlConnection(str);
conn.Open();
string sqlstr = "select 商品编号,商品名称,数量 from Goods order by 数量";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
}
private void button2_Click(object sender, EventArgs e)
{
if (textBox1.Text.Trim() == "")
{
MessageBox.Show("请输入库存下限！", "提示");
return;
}
else
{
qty = Convert.ToSingle(textBox1.Text.Trim()); //qty为库存下限值
MessageBox.Show("OK", "提示");
}
}
private void button1_Click(object sender, EventArgs e)
{
conn.Open();
string str = "select 商品编号,商品名称,数量 from Goods where 数量 <= ' " qty " ' ";
cmd = new SqlCommand(str, conn);
dr = cmd.ExecuteReader();
if (dr.Read())
{
dr.Dispose();
cmd.Dispose();
conn.Close();
conn.Open();
da = new SqlDataAdapter(str, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
label2.Text = "★ 警告 以上商品库存不足！";
}
else
{
label2.Text = "√ 商品库存正常！";
conn.Close();
}
（6）基础数据管理
库存商品
private void 库存商品_Load(object sender, EventArgs e)
{
//连接数据库
string str = "Server=.\\SQLEXPRESS;DataBase=jxcsystem;Integrated Security=SSPI";
//string str = "Server=(local);DataBase=jxcsystem;Integrated Security=SSPI";
conn = new SqlConnection(str);
conn.Open();
//绑定dataGridView控件显示
//string sqlstr = "select 商品编号,商品名称,[商品价格(元)],生产日期,制造商,产地 from Goods";
string sqlstr = "select * from Goods";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
textBox4.Text = DateTime.Now.ToString();
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
intindex = e.RowIndex;
//获取选中第一行的值，即商品编号值；
str = this.dataGridView1.SelectedCells[0].Value.ToString();
}
//单击dataGridView控件中的某一行向textBox控件中填充内容；
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
intindex = e.RowIndex;
textBox1.Text = dataGridView1.Rows[intindex].Cells[0].Value.ToString();
textBox2.Text = dataGridView1.Rows[intindex].Cells[1].Value.ToString();
textBox3.Text = dataGridView1.Rows[intindex].Cells[2].Value.ToString();
textBox4.Text = dataGridView1.Rows[intindex].Cells[4].Value.ToString();
textBox5.Text = dataGridView1.Rows[intindex].Cells[6].Value.ToString();
textBox6.Text = dataGridView1.Rows[intindex].Cells[5].Value.ToString();
}
//点击编号行删除按钮
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text.Trim() == "")
{
MessageBox.Show("点击选择下列商品编号进行删除","提示");
}
conn.Open();
SqlCommand cmd = new SqlCommand("DELETE from Goods where 商品编号=" textBox1.Text.Trim() "", conn);
cmd.Connection = conn;
cmd.ExecuteNonQuery();
cmd.Dispose();
textBox1.Text= "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox5.Text = "";
textBox6.Text = "";
string sqlstr = "select * from Goods";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
}
//编辑按钮
private void button2_Click(object sender, EventArgs e)
{
groupBox1.Enabled = true; //设置该控件有效，可以在其中进行编辑修改等操作。
}
//添加记录按钮
private void button4_Click(object sender, EventArgs e)
{
groupBox1.Enabled = true;
if (textBox1.Text.Trim() == "")
{
MessageBox.Show("商品编号不能为空！","提示");
return;
}
if (textBox2.Text.Trim() == "")
{
MessageBox.Show("商品名称不能为空！", "提示");
return;
}
if (textBox3.Text.Trim() == "")
{
MessageBox.Show("商品价格不能为空！", "提示");
return;
}
if (textBox4.Text.Trim() == "")
{
MessageBox.Show("日期不能为空！", "提示");
return;
}
conn.Open();
string selectSql = "select * from Goods where 商品编号='" textBox1.Text.Trim() "' ";
SqlCommand sqlcmd = new SqlCommand(selectSql, conn);
sqlcmd.CommandType = CommandType.Text;
sqlcmd.Dispose();
SqlDataReader sdr = sqlcmd.ExecuteReader();
if (sdr.Read()!=true)
{
sdr.Close();
conn.Close();
conn.Open();
SqlCommand cmd = new SqlCommand("insert into Goods values('" textBox1.Text.Trim() "','" textBox2.Text.Trim() "','" Convert.ToSingle(textBox3.Text.Trim()) "', '' ,'" Convert.ToDateTime(textBox4.Text.Trim()) "','" textBox6.Text.Trim() "','" textBox5.Text.Trim() "')", conn);
cmd.Connection = conn;
cmd.ExecuteNonQuery();
cmd.Dispose();
string sqlstr = "select * from Goods";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
MessageBox.Show("成功！");
}
else
{
conn.Close();
MessageBox.Show("请输入新的商品编号！","错误！");
}
conn.Close();
}
private void label6_Click(object sender, EventArgs e)
{
}
//修改记录并保存按钮
private void button5_Click(object sender, EventArgs e)
{
//if (textBox1.Text.Trim() == "")
//{
// MessageBox.Show("日期不能为空！","提示");
// return;
//}
groupBox1.Enabled = false;
conn.Open();
if (textBox1.Text.Trim() ==""||textBox2.Text.Trim() =="")
{
MessageBox.Show("商品编号不能为空！", "错误！");
return;
}
string selectstr="select count(*) from Goods where 商品编号='" textBox1.Text .Trim () "'";
SqlCommand sqlcmd=new SqlCommand(selectstr,conn);
int intConut=Convert.ToInt32(sqlcmd.ExecuteScalar().ToString());
if (intConut!=0)
{
string Updatestr = "update Goods set 商品名称='" textBox2.Text.Trim() "',[商品价格(元)]='" Convert.ToSingle(textBox3.Text.Trim()) "',数量='0',生产日期='" Convert.ToDateTime(textBox4.Text.Trim()) "',制造商='" textBox6.Text.Trim() "',产地='" textBox5.Text.Trim() "' where 商品编号='" textBox1.Text.Trim() "' ";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = Updatestr;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
MessageBox.Show("修改成功！", "提示");
}
else {
MessageBox.Show("编号错误，无法修改记录！", "提示！");
}
conn.Close();
}
//刷新记录
private void button3_Click(object sender, EventArgs e)
{
conn.Open();
string sqlstr = "select * from Goods";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
}
private void groupBox1_Enter(object sender, EventArgs e)
{
}
//查询(搜索)
private void button6_Click(object sender, EventArgs e)
{
if (textBox7.Text.Trim() == "")
{
MessageBox.Show("请输入商品编号", "提示");
return;
}
conn.Open();
string selectSql = "select * from Goods where 商品编号='" textBox7.Text.Trim() "' ";
SqlCommand sqlcmd = new SqlCommand(selectSql, conn);
sqlcmd.CommandType = CommandType.Text;
sqlcmd.Dispose();
SqlDataReader sdr = sqlcmd.ExecuteReader();
if (sdr.Read() == true)
{
conn.Close();
conn.Open();
string sqlstr = "select * from Goods where 商品编号='" textBox7.Text.Trim() "'";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
textBox7.Text = "";
}
else
{
conn.Close();
MessageBox.Show("商品编号不存在！", "警告");
}
}
往来单位
private void Units_Load(object sender, EventArgs e)
{
//连接数据库
string str = "Server=.\\SQLEXPRESS;DataBase=jxcsystem;Integrated Security=SSPI";
//string str = "Server=(local);DataBase=jxcsystem;Integrated Security=SSPI";
conn = new SqlConnection(str);
conn.Open();
//绑定dataGridView控件显示
string sqlstr = "select * from units";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
}
//查询记录
private void button6_Click(object sender, EventArgs e)
{
if (textBox7.Text.Trim() == "")
{
MessageBox.Show("请输入单位编号", "提示");
return;
}
conn.Open();
string selectSql = "select * from units where 单位编号='" textBox7.Text.Trim() "' ";
SqlCommand sqlcmd = new SqlCommand(selectSql, conn);
sqlcmd.CommandType = CommandType.Text;
sqlcmd.Dispose();
SqlDataReader sdr = sqlcmd.ExecuteReader();
if (sdr.Read() == true)
{
conn.Close();
conn.Open();
string sqlstr = "select * from units where 单位编号='" textBox7.Text.Trim() "'";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
textBox7.Text= "";
}
else
{
conn.Close();
MessageBox.Show("单位编号不存在！", "警告");
}
}
//编辑按钮
private void button1_Click(object sender, EventArgs e)
{
groupBox1.Enabled = true; //设置该控件有效，可以在其中进行编辑修改等操作。
}
//修改记录并(保存)按钮
private void button2_Click(object sender, EventArgs e)
{
groupBox1.Enabled = false;
conn.Open();
if (textBox1.Text.Trim() == "" && textBox1.Text.Trim() == "")
{
MessageBox.Show("单位编号不能为空！", "错误！");
return;
}
string selectstr = "select count(*) from units where 单位编号='" textBox1.Text.Trim() "'";
SqlCommand sqlcmd = new SqlCommand(selectstr, conn);
int intConut = Convert.ToInt32(sqlcmd.ExecuteScalar().ToString());
if (intConut != 0)
{
string Updatestr = "update units set 单位名称='" textBox2.Text.Trim() "',单位电话='" textBox3.Text.Trim() "',单位联系人='" textBox4.Text.Trim() "',单位地址='" textBox6.Text.Trim() "',开户银行账号='" textBox5.Text.Trim() "' where 单位编号=' " textBox1.Text.Trim() "' ";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = Updatestr;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
MessageBox.Show("修改成功！", "提示！");
}
else
{
MessageBox.Show("编号错误，无法修改记录！", "提示！");
}
conn.Close();
}
//添加记录按钮
private void button3_Click(object sender, EventArgs e)
{
groupBox1.Enabled = true;
conn.Open();
string selectSql = "select * from units where 单位编号='" textBox1.Text.Trim() "' ";
SqlCommand sqlcmd = new SqlCommand(selectSql, conn);
sqlcmd.CommandType = CommandType.Text;
sqlcmd.Dispose();
SqlDataReader sdr = sqlcmd.ExecuteReader();
if (textBox1.Text.Trim() == "" && textBox1.Text.Trim() == "")
{
MessageBox.Show("单位编号不能为空！", "错误！");
}
else if (sdr.Read() != true)
{
sdr.Close();
SqlCommand cmd = new SqlCommand("insert into units values('" textBox1.Text.Trim() "','" textBox2.Text.Trim() "','" textBox3.Text.Trim() "','" textBox4.Text.Trim() "','" textBox6.Text.Trim() "','" textBox5.Text.Trim() "')", conn);
cmd.Connection = conn;
cmd.ExecuteNonQuery();
cmd.Dispose();
MessageBox.Show("添加成功！", "提示");
}
else
{
MessageBox.Show("请输入新的单位编号！", "错误！");
}
conn.Close();
}
//点击编号行删除按钮
private void button4_Click(object sender, EventArgs e)
{
conn.Open();
SqlCommand cmd = new SqlCommand("DELETE from units where 单位编号=" textBox1.Text.Trim() "", conn);
cmd.Connection = conn;
cmd.ExecuteNonQuery();
cmd.Dispose();
//清空textBox内容
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox5.Text = "";
textBox6.Text = "";
string sqlstr = "select * from units";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
}
//刷新记录按钮
private void button5_Click(object sender, EventArgs e)
{
conn.Open();
string sqlstr = "select * from units";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
}
公司员工
//删除按钮
private void button4_Click(object sender, EventArgs e)
{
if (textBox1.Text == "")
{
MessageBox.Show("请选中删除员工行", "提示");
return;
}
else
{
conn.Open();
SqlCommand cmd = new SqlCommand("DELETE from employee where 员工编号=" textBox1.Text.Trim() "", conn);
cmd.Connection = conn;
cmd.ExecuteNonQuery();
cmd.Dispose();
textBox1.Text = "";
textBox2.Text = "";
textBox4.Text = "";
textBox5.Text = "";
textBox6.Text = "";
string sqlstr = "select 员工编号,员工姓名,员工性别,所属部门,手机号码,备注 from employee";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
}
}
private void label5_Click(object sender, EventArgs e)
{
}
//编辑按钮
private void button1_Click(object sender, EventArgs e)
{
groupBox1.Enabled = true; //设置该控件有效，可以在其中进行编辑修改等操作。
}
//修改记录并保存按钮
private void button2_Click(object sender, EventArgs e)
{
groupBox1.Enabled = false;
if (radioButton1.Checked == true||radioButton1.Checked == true)
{
MessageBox.Show("请选择性别","提示");
}
if (radioButton1.Checked == true)
{
sex = "男";
}
if (radioButton2.Checked == true)
{
sex = "女";
}
conn.Open();
if (textBox1.Text.Trim() == "" || textBox1.Text.Trim() == "")
{
MessageBox.Show("编号不能为空！", "错误！");
return;
}
string selectstr = "select count(*) from employee where 员工编号='" textBox1.Text.Trim() "'";
SqlCommand sqlcmd = new SqlCommand(selectstr, conn);
int intConut = Convert.ToInt32(sqlcmd.ExecuteScalar().ToString());
if (intConut != 0)
{
string Updatestr = "update employee set 员工姓名='" textBox2.Text.Trim() "',员工性别='" sex "',所属部门='" textBox4.Text.Trim() "',手机号码='" textBox5.Text.Trim() "',备注='" textBox6.Text.Trim() "' where 员工编号='" textBox1.Text.Trim() "' ";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = Updatestr;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
MessageBox.Show("修改成功！", "提示");
}
else
{
MessageBox.Show("编号错误，无法修改记录！", "提示！");
}
conn.Close();
}
//添加记录按钮
private void button3_Click(object sender, EventArgs e)
{
groupBox1.Enabled = true;
if (radioButton1.Checked == true || radioButton1.Checked == true)
{
MessageBox.Show("请选择性别", "提示");
}
if (radioButton1.Checked == true)
{
sex = "男";
}
if (radioButton2.Checked == true)
{
sex = "女";
}
conn.Open();
string selectSql = "select * from employee where 员工编号='" textBox1.Text.Trim() "' ";
SqlCommand sqlcmd = new SqlCommand(selectSql, conn);
sqlcmd.CommandType = CommandType.Text;
sqlcmd.Dispose();
SqlDataReader sdr = sqlcmd.ExecuteReader();
if (textBox1.Text.Trim() == "" && textBox1.Text.Trim() == "")
{
MessageBox.Show("编号不能为空！", "错误！");
}
else if (sdr.Read() != true)
{
sdr.Close();
SqlCommand cmd = new SqlCommand("insert into employee values('" textBox1.Text.Trim() "','" textBox2.Text.Trim() "','123','" sex "','" textBox4.Text.Trim() "','" textBox6.Text.Trim() "','" textBox6.Text.Trim() "')", conn);
cmd.Connection = conn;
cmd.ExecuteNonQuery();
cmd.Dispose();
MessageBox.Show("添加成功！刷新显示", "提示！");
flag = 1;
}
else
{
MessageBox.Show("请输入新的员工编号！", "错误！");
}
conn.Close();
//如果添加了新员工，同时向power表中添加员工编号；
if(flag==1)
{
conn.Open();
SqlCommand cmd = new SqlCommand("insert into power values('" textBox1.Text.Trim() "','0','0','0','0','0')", conn);
sdr = cmd.ExecuteReader();
conn.Close();
}
}
//刷新记录按钮
private void button5_Click(object sender, EventArgs e)
{
conn.Open();
string sqlstr = "select 员工编号,员工姓名,员工性别,所属部门,手机号码,备注 from employee";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
}
//清空textBox.Text(取消)按钮
private void button6_Click(object sender, EventArgs e)
{
textBox1.Text = "";
textBox2.Text = "";
radioButton1.Checked = false;
radioButton2.Checked = false;
textBox4.Text = "";
textBox5.Text = "";
textBox6.Text = "";
}
//查询(索搜)按钮;
private void button7_Click(object sender, EventArgs e)
{
if (textBox7.Text.Trim() == "")
{
MessageBox.Show("请输入员工编号", "提示");
return;
}
conn.Open();
string selectSql = "select * from employee where 员工编号='" textBox7.Text.Trim() "' ";
SqlCommand sqlcmd = new SqlCommand(selectSql, conn);
sqlcmd.CommandType = CommandType.Text;
sqlcmd.Dispose();
SqlDataReader sdr = sqlcmd.ExecuteReader();
if (sdr.Read() == true)
{
conn.Close();
conn.Open();
string sqlstr = "select 员工编号,员工姓名,员工性别,所属部门,手机号码,备注 from employee where 员工编号='" textBox7.Text.Trim() "'";
da = new SqlDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
textBox7.Text = "";
}
else
{
conn.Close();
MessageBox.Show("员工编号不存在！", "警告");
}
密码修改
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text.Trim() == "")
{
MessageBox.Show("用户名不能为空！", "警告");
return;
}
if (textBox2.Text.Trim() == "")
{
MessageBox.Show("密码不能为空！", "警告");
return;
}
if (textBox3.Text.Trim() == "")
{
MessageBox.Show("密码不能为空！", "警告");
return;
}
conn.Open();
if (flag==1)
{
//员工修改密码
string selectSql = "select * from employee where 员工编号='" textBox1.Text.Trim() "' and password='" textBox2.Text.Trim() "'";
SqlCommand sqlcmd = new SqlCommand(selectSql, conn);
sqlcmd.CommandType = CommandType.Text;
SqlDataReader sdr = sqlcmd.ExecuteReader();
if (sdr.Read() == true)
{
sdr.Close();
string Updatestr = "update employee set password='" textBox3.Text.Trim() "' where 员工编号='" textBox1.Text.Trim() "' ";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = Updatestr;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
sqlcmd.Dispose();
MessageBox.Show("密码修改成功！", "提示");
}
else
{
MessageBox.Show("用户名或密码错误，无法修改密码！", "提示！");
}
}
else
{
//管理员修改密码
string selectSql = "select * from admin where users='" textBox1.Text.Trim() "' and pwd='" textBox2.Text.Trim() "'";
SqlCommand sqlcmd = new SqlCommand(selectSql, conn);
sqlcmd.CommandType = CommandType.Text;
SqlDataReader sdr = sqlcmd.ExecuteReader();
if (sdr.Read() == true)
{
sdr.Close();
string Updatestr = "update admin set pwd='" textBox3.Text.Trim() "' where users='" textBox1.Text.Trim() "' ";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = Updatestr;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
sqlcmd.Dispose();
MessageBox.Show("密码修改成功！", "提示");
}
else
{
MessageBox.Show("用户名或密码错误，无法修改密码！", "提示！");
}
}
conn.Close();
}
//重置密码按钮
private void button2_Click(object sender, EventArgs e)
{
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
}
（7）系统维护管理
本单位信息
private void Unit_Load(object sender, EventArgs e)
{
textBox7.Text = "A001";
conn = new SqlConnection("Server=.\\SQLEXPRESS;DataBase=jxcsystem;Integrated Security=SSPI");
//conn = new SqlConnection("Server=(local);DataBase=jxcsystem;Integrated Security=SSPI");
conn.Open();
string sql = "select * from units ";
SqlCommand myCommand = new SqlCommand(sql, conn);
myReader = myCommand.ExecuteReader();
while (myReader.Read())
{
textBox1.Text = myReader["单位名称"].ToString();
textBox2.Text = myReader["单位联系人"].ToString();
textBox4.Text = myReader["单位电话"].ToString();
textBox6.Text = myReader["单位地址"].ToString();
textBox5.Text = myReader["开户银行账号"].ToString();
}
conn.Close();
}
private void button1_Click(object sender, EventArgs e)
{
conn.Open();
//更新记录
string updatestr = "update units set 单位名称='" textBox1.Text.Trim() "',单位联系人='" textBox2.Text.Trim() "',单位电话='" textBox4.Text.Trim() "',开户银行账号='" textBox5.Text.Trim() "' ,单位地址='" textBox6.Text.Trim() "' where 单位编号='" textBox7.Text.Trim() "' ";
SqlCommand cmd = new SqlCommand(updatestr, conn);
cmd.Connection = conn;
cmd.ExecuteNonQuery();
if (Convert.ToInt32(cmd.ExecuteNonQuery()) > 0)
{
MessageBox.Show("更新成功!");
}
else
{
MessageBox.Show("更新失败!");
}
cmd.Dispose();
conn.Close();
权限管理
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text.Trim() == "")
{
MessageBox.Show("员工编号不能为空", "提示！");
return;
}else
{
conn.Open();
string srt1 = "select * from employee where 员工编号='" textBox1.Text.Trim() "' ";
SqlCommand cmd = new SqlCommand(srt1, conn);
cmd.CommandType = CommandType.Text;
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read() != true)
{
MessageBox.Show("编号无效！", "提示");
conn.Close();
}
conn.Close();
}
if (checkBox1.Checked== true)
{
conn.Open();
string Updatestr = "update power set sales='1' where 员工编号='" textBox1.Text.Trim() "'";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = Updatestr;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
conn.Close();
} else
{
conn.Open();
string Updatestr = "update power set sales='0' where 员工编号='" textBox1.Text.Trim() "'";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = Updatestr;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
conn.Close();
}
if (checkBox2.Checked == true)
{
conn.Open();
string Updatestr = "update power set bases='1' where 员工编号='" textBox1.Text.Trim() "'";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = Updatestr;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
conn.Close();
} else
{
conn.Open();
string Updatestr = "update power set bases='0' where 员工编号='" textBox1.Text.Trim() "'";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = Updatestr;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
conn.Close();
}
if (checkBox3.Checked == true)
{
conn.Open();
string Updatestr = "update power set system='1' where 员工编号='" textBox1.Text.Trim() "'";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = Updatestr;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
conn.Close();
} else
{
conn.Open();
string Updatestr = "update power set system='0' where 员工编号='" textBox1.Text.Trim() "'";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = Updatestr;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
conn.Close();
}
if (checkBox4.Checked == true)
{
conn.Open();
string Updatestr = "update power set purchase='1' where 员工编号='" textBox1.Text.Trim() "'";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = Updatestr;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
conn.Close();
} else
{
conn.Open();
string Updatestr = "update power set purchase='0' where 员工编号='" textBox1.Text.Trim() "'";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = Updatestr;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
conn.Close();
}
if (checkBox5.Checked == true)
{
conn.Open();
string Updatestr = "update power set stock='1' where 员工编号='" textBox1.Text.Trim() "'";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = Updatestr;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
conn.Close();
} else
{
conn.Open();
string Updatestr = "update power set stock='0' where 员工编号='" textBox1.Text.Trim() "'";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = Updatestr;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
conn.Close(); SqlCommand cmd = new SqlCommand();
cmd.CommandText = Updatestr;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
conn.Close();
好例子网口号：伸出你的我的手 — 分享！
网友评论
小贴士
感谢您为本站写下的评论，您的评论对其它用户来说具有重要的参考价值，所以请认真填写。
- 类似“顶”、“沙发”之类没有营养的文字，对勤劳贡献的楼主来说是令人沮丧的反馈信息。
- 相信您也不想看到一排文字/表情墙，所以请不要反馈意义不大的重复字符，也请尽量不要纯表情的回复。
- 提问之前请再仔细看一遍楼主的说明，或许是您遗漏了。
- 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦，又没人会搭理，于人于己都无利。
关于好例子网
本站旨在为广大IT学习爱好者提供一个非营利性互相学习交流分享平台。本站所有资源都可以被免费获取学习研究。本站资源来自网友分享，对搜索内容的合法性不具有预见性、识别性、控制性，仅供学习研究，请务必在下载后24小时内给予删除，不得用于其他任何用途，否则后果自负。基于互联网的特殊性，平台无法对用户传输的作品、信息、内容的权属或合法性、安全性、合规性、真实性、科学性、完整权、有效性等进行实质审查；无论平台是否已进行审查，用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二与二十三条之规定，若资源存在侵权或相关问题请联系本站客服人员，点此联系我们。关于更多版权及免责申明参见 版权及免责申明
支持(0) 盖楼(回复)
支持(0) 盖楼(回复)
支持(0) 盖楼(回复)
支持(0) 盖楼(回复)