实例介绍
VS2013 C# ACCESS 开发的 简单的茶楼管理系统
【实例截图】 private void FrmMain_Load(object sender, EventArgs e)
{
this.cmbhh.DataSource = new DirectoryInfo("Skins").GetFiles();
this.cmbhh.DisplayMember = "Name";
FrmMain.tbc = this.tbczy;
timer1_Tick(null, null);
// Bind();
tbczy_SelectedIndexChanged(null, null);
this.tssry.Text = "当前操作人员:" ry;
ryy = ry;
CtZs();
this.labctzs.Text = zb.ToString();
this.labkg.Text = ky.ToString();
this.labzy.Text = zy.ToString();
this.labyd.Text = yus.ToString();
//上座率
double zzsy = Convert.ToDouble(zy);//正在使用的坐台
double zszw = Convert.ToDouble(zb);//总数桌台
int sadsad = Convert.ToInt32(zzsy / zszw * 100);
this.labszl.Text = sadsad.ToString() "%"; //给上座率赋值
}
/// <summary>
/// 餐台总数/可用,待用
/// </summary>
private void CtZs()
{
conn = new OleDbConnection(str);
conn.Open();
string sql = "select count(RoomName) from tb_Room ";
cmd = new OleDbCommand(sql, conn);
zb = cmd.ExecuteScalar();
string sqlky = "select count(RoomName) from tb_Room where RoomzT='待用' ";
cmd.CommandText = sqlky;
ky = cmd.ExecuteScalar();
string sqlzy = "select count(RoomName) from tb_Room where RoomzT='使用' ";
cmd.CommandText = sqlzy;
zy = cmd.ExecuteScalar();
string sqlyd = "select count(RoomName) from tb_Room where RoomzT='预定' ";
cmd.CommandText = sqlyd;
yus = cmd.ExecuteScalar();
conn.Close();
}
/// <summary>
/// 获取每一个界面的值,传入绑定工程调用每一个bind绑上去
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tbczy_SelectedIndexChanged(object sender, EventArgs e)
{
ListView lvzs = lvdt; //定义listview
kw = tbczy.SelectedTab.Text;//拿到选中的选项卡文字判断
labwd.Text = this.tbczy.SelectedTab.Text;
//判断位置,把获取的lsitview 保存到listview
switch (kw)
{
case "一楼大厅":
kw = "大厅";
lvzs = lvdt;
lvzs.Clear();
break;
case "二楼小包":
kw = "包房";
lvzs = lvxb;
lvzs.Clear();
break;
case "一楼大包":
kw = "大包房";
lvzs = lvdb;
lvzs.Clear();
break;
}
//开数据库获取数据 逐一绑定
conn = new OleDbConnection(str);
conn.Open();
string sql = "select * from tb_Room where RoomWZ='" kw "' ";
cmd = new OleDbCommand(sql, conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
lv1 = new ListViewItem(dr["RoomName"].ToString());
if (dr["RoomZT"].ToString() == "使用")
{
lv1.ImageIndex = 0;
}
else if (dr["RoomZT"].ToString() == "预定")
{
lv1.ImageIndex = 1;
}
else
{
lv1.ImageIndex = 2;
}
lvzs.Items.Add(lv1);
}
dr.Close();
conn.Close();
}
/// <summary>
/// 顾客开单
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void butkd_Click(object sender, EventArgs e)
{
if (kdcz == null)
{
MessageBox.Show("请选择餐台后开单");
}
else if (s == "使用")
{
MessageBox.Show("此餐台处于非可用状态");
}
else
{
string xxbt = this.tbczy.SelectedTab.Text;
FrmTj tj = new FrmTj();
FrmTj.bt = xxbt;
FrmTj.zd = jc;
FrmTj.xf = bjf;
tj.ShowDialog();
FrmMain_Load(null, null);
}
}
/// <summary>
/// 绑定菜单在lvstview上
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void lvdt_MouseClick(object sender, MouseEventArgs e)
{
//鼠标在list上的点击事件
this.Cursor = Cursors.Default;
ListView listView = (ListView)sender;
ListViewItem item = listView.GetItemAt(e.X, e.Y);
if (item != null && e.Button == MouseButtons.Right)
{
this.cmsda.Show(listView, e.X, e.Y);
}
//获取items中的文字
for (int i = 0; i < lvdt.Items.Count; i )
{
ListViewItem iwtem = lvdt.Items[i];
for (int j = 0; j < iwtem.SubItems.Count; j )
{
kdcz = item.SubItems[j].Text;
}
}
conn = new OleDbConnection(str);
conn.Open();
string sql = "select * from tb_Room where RoomName='" kdcz "' ";
cmd = new OleDbCommand(sql, conn);
dr = cmd.ExecuteReader();
if (dr.Read())
{
jc = dr["RoomJC"].ToString();//接受简称
s = dr["RoomZT"].ToString();//接受是否在使用
bjf = dr["RoomBJF"].ToString();//接受包间费
zuidi = dr["RoomBJF"].ToString();//最低消费
jifbz = dr["RoomType"].ToString();//类型
jidsj = dr["zhangdanDate"].ToString();//进店时间;
}
jdzsj = jidsj;//全局接受进店时间
dr.Close();
//消费金额
string sqlcxjq = "select sum(je) from tb_xfxf where cth='" jc "'";
cmd.CommandText = sqlcxjq;
this.labxfje.Text = cmd.ExecuteScalar().ToString();
conn.Close();
switch (jifbz)
{
case "普通":
this.labjfbz.Text = "不计房间费";
break;
case "中级":
this.labjfbz.Text = "小包";
break;
case "高级":
this.labjfbz.Text = "大包";
break;
}
this.labzuidi.Text = zuidi;//计费标准
this.labjdsj.Text = jidsj;//进店时间
//给予判断是否在使用
if (s == "使用")
{
//计算已用时间
DateTime d = new DateTime();
d = DateTime.Parse(jidsj);
//调用时间类
SJTime sjj = new SJTime(d);
sjj.SjTime01();
this.labyysj.Text = sjj.SjTime01().ToString();
}
else
{
this.labyysj.Text = "";
}
Pdshiy(s);
Zyxxm(jc);
}
/// <summary>
/// 离开菜单隐藏
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmsda_MouseLeave(object sender, EventArgs e)
{
this.cmsda.Hide();
}
/// <summary>
/// 判断菜单里面按钮是否可以使用
/// </summary>
/// <param name="s"></param>
private void Pdshiy(string s)
{
//遍历每一个下拉选项 全部可以使用
foreach (ToolStripItem info in this.cmsda.Items)
{
info.Enabled = true;
}
//判断是否使用
if (s == "使用")
{
this.顾客开单ToolStripMenuItem.Enabled = false;
this.宾客预定ToolStripMenuItem.Enabled = false;
}
else
{
this.宾客预定ToolStripMenuItem.Enabled = true;
this.宾客消费ToolStripMenuItem.Enabled = false;
this.增加消费ToolStripMenuItem.Enabled = false;
}
}
【实例截图】 private void FrmMain_Load(object sender, EventArgs e)
{
this.cmbhh.DataSource = new DirectoryInfo("Skins").GetFiles();
this.cmbhh.DisplayMember = "Name";
FrmMain.tbc = this.tbczy;
timer1_Tick(null, null);
// Bind();
tbczy_SelectedIndexChanged(null, null);
this.tssry.Text = "当前操作人员:" ry;
ryy = ry;
CtZs();
this.labctzs.Text = zb.ToString();
this.labkg.Text = ky.ToString();
this.labzy.Text = zy.ToString();
this.labyd.Text = yus.ToString();
//上座率
double zzsy = Convert.ToDouble(zy);//正在使用的坐台
double zszw = Convert.ToDouble(zb);//总数桌台
int sadsad = Convert.ToInt32(zzsy / zszw * 100);
this.labszl.Text = sadsad.ToString() "%"; //给上座率赋值
}
/// <summary>
/// 餐台总数/可用,待用
/// </summary>
private void CtZs()
{
conn = new OleDbConnection(str);
conn.Open();
string sql = "select count(RoomName) from tb_Room ";
cmd = new OleDbCommand(sql, conn);
zb = cmd.ExecuteScalar();
string sqlky = "select count(RoomName) from tb_Room where RoomzT='待用' ";
cmd.CommandText = sqlky;
ky = cmd.ExecuteScalar();
string sqlzy = "select count(RoomName) from tb_Room where RoomzT='使用' ";
cmd.CommandText = sqlzy;
zy = cmd.ExecuteScalar();
string sqlyd = "select count(RoomName) from tb_Room where RoomzT='预定' ";
cmd.CommandText = sqlyd;
yus = cmd.ExecuteScalar();
conn.Close();
}
/// <summary>
/// 获取每一个界面的值,传入绑定工程调用每一个bind绑上去
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tbczy_SelectedIndexChanged(object sender, EventArgs e)
{
ListView lvzs = lvdt; //定义listview
kw = tbczy.SelectedTab.Text;//拿到选中的选项卡文字判断
labwd.Text = this.tbczy.SelectedTab.Text;
//判断位置,把获取的lsitview 保存到listview
switch (kw)
{
case "一楼大厅":
kw = "大厅";
lvzs = lvdt;
lvzs.Clear();
break;
case "二楼小包":
kw = "包房";
lvzs = lvxb;
lvzs.Clear();
break;
case "一楼大包":
kw = "大包房";
lvzs = lvdb;
lvzs.Clear();
break;
}
//开数据库获取数据 逐一绑定
conn = new OleDbConnection(str);
conn.Open();
string sql = "select * from tb_Room where RoomWZ='" kw "' ";
cmd = new OleDbCommand(sql, conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
lv1 = new ListViewItem(dr["RoomName"].ToString());
if (dr["RoomZT"].ToString() == "使用")
{
lv1.ImageIndex = 0;
}
else if (dr["RoomZT"].ToString() == "预定")
{
lv1.ImageIndex = 1;
}
else
{
lv1.ImageIndex = 2;
}
lvzs.Items.Add(lv1);
}
dr.Close();
conn.Close();
}
/// <summary>
/// 顾客开单
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void butkd_Click(object sender, EventArgs e)
{
if (kdcz == null)
{
MessageBox.Show("请选择餐台后开单");
}
else if (s == "使用")
{
MessageBox.Show("此餐台处于非可用状态");
}
else
{
string xxbt = this.tbczy.SelectedTab.Text;
FrmTj tj = new FrmTj();
FrmTj.bt = xxbt;
FrmTj.zd = jc;
FrmTj.xf = bjf;
tj.ShowDialog();
FrmMain_Load(null, null);
}
}
/// <summary>
/// 绑定菜单在lvstview上
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void lvdt_MouseClick(object sender, MouseEventArgs e)
{
//鼠标在list上的点击事件
this.Cursor = Cursors.Default;
ListView listView = (ListView)sender;
ListViewItem item = listView.GetItemAt(e.X, e.Y);
if (item != null && e.Button == MouseButtons.Right)
{
this.cmsda.Show(listView, e.X, e.Y);
}
//获取items中的文字
for (int i = 0; i < lvdt.Items.Count; i )
{
ListViewItem iwtem = lvdt.Items[i];
for (int j = 0; j < iwtem.SubItems.Count; j )
{
kdcz = item.SubItems[j].Text;
}
}
conn = new OleDbConnection(str);
conn.Open();
string sql = "select * from tb_Room where RoomName='" kdcz "' ";
cmd = new OleDbCommand(sql, conn);
dr = cmd.ExecuteReader();
if (dr.Read())
{
jc = dr["RoomJC"].ToString();//接受简称
s = dr["RoomZT"].ToString();//接受是否在使用
bjf = dr["RoomBJF"].ToString();//接受包间费
zuidi = dr["RoomBJF"].ToString();//最低消费
jifbz = dr["RoomType"].ToString();//类型
jidsj = dr["zhangdanDate"].ToString();//进店时间;
}
jdzsj = jidsj;//全局接受进店时间
dr.Close();
//消费金额
string sqlcxjq = "select sum(je) from tb_xfxf where cth='" jc "'";
cmd.CommandText = sqlcxjq;
this.labxfje.Text = cmd.ExecuteScalar().ToString();
conn.Close();
switch (jifbz)
{
case "普通":
this.labjfbz.Text = "不计房间费";
break;
case "中级":
this.labjfbz.Text = "小包";
break;
case "高级":
this.labjfbz.Text = "大包";
break;
}
this.labzuidi.Text = zuidi;//计费标准
this.labjdsj.Text = jidsj;//进店时间
//给予判断是否在使用
if (s == "使用")
{
//计算已用时间
DateTime d = new DateTime();
d = DateTime.Parse(jidsj);
//调用时间类
SJTime sjj = new SJTime(d);
sjj.SjTime01();
this.labyysj.Text = sjj.SjTime01().ToString();
}
else
{
this.labyysj.Text = "";
}
Pdshiy(s);
Zyxxm(jc);
}
/// <summary>
/// 离开菜单隐藏
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmsda_MouseLeave(object sender, EventArgs e)
{
this.cmsda.Hide();
}
/// <summary>
/// 判断菜单里面按钮是否可以使用
/// </summary>
/// <param name="s"></param>
private void Pdshiy(string s)
{
//遍历每一个下拉选项 全部可以使用
foreach (ToolStripItem info in this.cmsda.Items)
{
info.Enabled = true;
}
//判断是否使用
if (s == "使用")
{
this.顾客开单ToolStripMenuItem.Enabled = false;
this.宾客预定ToolStripMenuItem.Enabled = false;
}
else
{
this.宾客预定ToolStripMenuItem.Enabled = true;
this.宾客消费ToolStripMenuItem.Enabled = false;
this.增加消费ToolStripMenuItem.Enabled = false;
}
}
好例子网口号:伸出你的我的手 — 分享!
网友评论
小贴士
感谢您为本站写下的评论,您的评论对其它用户来说具有重要的参考价值,所以请认真填写。
- 类似“顶”、“沙发”之类没有营养的文字,对勤劳贡献的楼主来说是令人沮丧的反馈信息。
- 相信您也不想看到一排文字/表情墙,所以请不要反馈意义不大的重复字符,也请尽量不要纯表情的回复。
- 提问之前请再仔细看一遍楼主的说明,或许是您遗漏了。
- 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦,又没人会搭理,于人于己都无利。
关于好例子网
本站旨在为广大IT学习爱好者提供一个非营利性互相学习交流分享平台。本站所有资源都可以被免费获取学习研究。本站资源来自网友分享,对搜索内容的合法性不具有预见性、识别性、控制性,仅供学习研究,请务必在下载后24小时内给予删除,不得用于其他任何用途,否则后果自负。基于互联网的特殊性,平台无法对用户传输的作品、信息、内容的权属或合法性、安全性、合规性、真实性、科学性、完整权、有效性等进行实质审查;无论平台是否已进行审查,用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。本站所有资源不代表本站的观点或立场,基于网友分享,根据中国法律《信息网络传播权保护条例》第二十二与二十三条之规定,若资源存在侵权或相关问题请联系本站客服人员,点此联系我们。关于更多版权及免责申明参见 版权及免责申明
支持(0) 盖楼(回复)