frmzhangdan.cs

一个酒店管理系统

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

namespace bggl.cs
{
	/// <summary>
	/// tablezhangdan 的摘要说明。
	/// </summary>
	public class tablezhangdan
	{
		bggl.conn.conn con=new bggl.conn.conn();
		DataSet objset=new DataSet();

		public tablezhangdan()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		public DataSet selzdcd()
		{
			try
			{
				string str=null;
				str="select top 1 zdid from BG_ZD zdid order by zdid desc";
				objset=con.selectexe(str,"BG_ZD");
			}
			catch(SqlException ex)
			{
			   MessageBox.Show(ex.Message);
			}
			return objset;
		}
		public bool insertzhangdan(string setid,string type,string knumber,string kname,string khao,string dctime,string jztime,string cperson,string ys)
		{
			try
			{
				string str=null;
				str="insert into BG_ZD values('"+setid+"','"+type+"','"+knumber+"','"+kname+"','"+khao+"','"+dctime+"','"+jztime+"','"+cperson+"',"+ys+")";
				con.execomm(str);
			}
			catch(SqlException ex)
			{
			   MessageBox.Show(ex.Message);
			}
			return true;
		}
		public bool addzdcd(string zdid,string zwid,string cdid,string cname,string dj)  //将要插入数据到帐单菜单表
		{
			try
			{
				string str=null;
				str="insert into BG_ZDCD values('"+zdid+"','"+zwid+"','"+cdid+"','"+cname+"',"+dj+")";
				con.execomm(str);
			}
			catch(SqlException ex)
			{
			   MessageBox.Show(ex.Message);
			}
			return true;

		}
		public DataSet selzd()
		{
			try
			{
				string str=null;
				str="select * from BG_ZD";
				objset=con.selectexe(str,"BG_ZD");
			}
			catch(SqlException ex)
			{
			   MessageBox.Show(ex.Message);
			}
			return objset;
		}
		public DataSet chaxunzdcd()
		{
			try
			{
				string str=null;
				str="select * from BG_ZDCD";
				objset=con.selectexe(str,"BG_ZDCD");
			}
			catch(SqlException ex)
			{
			   MessageBox.Show(ex.Message);
			}
			return objset;
		}
		public DataSet cxzdcd(string desk1)
		{
			try
			{
			   string str=null;
				str="select * from BG_ZDCD where zdid='"+desk1+"'";
				objset=con.selectexe(str,"BG_ZDCD");
			}
			catch(SqlException ex)
			{
				MessageBox.Show(ex.Message);
			}
			return objset;
		}
	}
}