S1总复习(3)办公用品管理系统
Dbhelper 文件见S1总复习(2)手机信息管理系统
数据库操作
主界面
界面
代码
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace frmMain
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void 记录录入ToolStripMenuItem_Click(object sender, EventArgs e)
{
recordEntry recordEntry = new recordEntry();
recordEntry.Show();
recordEntry.MdiParent = this;
}
private void 记录查询ToolStripMenuItem_Click(object sender, EventArgs e)
{
query query = new query();
query.Show();
query.MdiParent = this;
}
private void 退出ToolStripMenuItem_Click(object sender, EventArgs e)
{
this.Close();
}
}
}
添加窗口
界面
代码
using System;
using System.Windows.Forms;
namespace frmMain
{
public partial class recordEntry : Form
{
public recordEntry()
{
InitializeComponent();
}
private void btnEmpty_Click(object sender, EventArgs e)
{
txtGoods.Text = "";
txtDate.Text = "";
txtNum.Text = "";
txtReason.Text = "";
txtMan.Text = "";
}
private void btnYes_Click(object sender, EventArgs e)
{
//接送文本框中的值
//物品
String goods = txtGoods.Text;
//数量
String num = txtNum.Text;
//时间
String date = txtDate.Text;
//用途
String reason = txtReason.Text;
//员工
String man = txtMan.Text;
//非空验证
if (goods.Length == 0 && num.Length == 0 && date.Length == 0 && reason.Length == 0 && man.Length == 0)
{
MessageBox.Show("所有文本框不能为空,请认真填写!");
return;
}
else if (goods.Length == 0 || num.Length == 0 || date.Length == 0 || reason.Length == 0 || man.Length == 0)
{
MessageBox.Show("文本框不能为空,请认真填写!");
return;
}
//新建sql语句
String sql = String.Format("insert into Record values ('{0}','{1}','{2}','{3}','{4}');",goods,num,date,reason,man);
//调用帮手
DbHelper helper = new DbHelper();
//让帮手干活
int update = helper.update(sql);
if (update > 0)
{
MessageBox.Show("提交成功!");
}
else
{
MessageBox.Show("提交失败!");
}
this.Close();
}
private void btnNo_Click(object sender, EventArgs e)
{
this.Close();
}
}
}
查询窗口
界面
代码
using System;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
namespace frmMain
{
public partial class query : Form
{
public query()
{
InitializeComponent();
}
private void query_Load(object sender, EventArgs e)
{
//关闭空行
dataGridView1.AllowUserToAddRows = false;
//关闭自动生成列
dataGridView1.AutoGenerateColumns = false;
//绑定数据
//新建 sql 语句
String sql = "select * from Record;";
//调用帮手
DbHelper helper = new DbHelper();
//让帮手干活
DataTable dt = helper.getTable(sql);
dataGridView1.DataSource = dt;
}
private void button1_Click(object sender, EventArgs e)
{
//调用帮手
DbHelper helper = new DbHelper();
//提取文本框内容
String query = txtQuery.Text;
if (query.Length == 0)
{
String sqlAll = "select * from Record";
DataTable dt = helper.getTable(sqlAll);
dataGridView1.DataSource = dt;
}
//sql语句
String sql = "select * from Record";
//让帮手干活
DataSet ds = helper.getDataSet(sql);
//新建查询
//调用DataView
DataView dv = new DataView(ds.Tables["table"]);
String cond = String.Format("GoodsName like '%{0}%'",query);
dv.RowFilter = cond;
dataGridView1.DataSource = dv;
}
}
}