selectmenu.cs

一个酒店管理系统

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

namespace bggl.cs
{
	/// <summary>
	/// frmcaidan 的摘要说明。
	/// </summary>
	public class selectmenu
	{
		conn.conn insertcaidan=new bggl.conn.conn();
		DataSet objset;
		public selectmenu()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		public DataSet selmenu(string type,string cname)
		{   
			string  sel=null;
			
			DataSet dataset=new DataSet();

			if(type!="" && cname!="")
			{
				sel="select mid as '菜单ID',mtype as '菜型',mname as '菜名',mcpuid as '菜名编号',mprice as '单价' from BG_Menu where mtype='"+type+"' and mname='"+cname+"'";
			}
			else if(type!="")
			{
				sel="select mid as '菜单ID',mtype as '菜型',mname as '菜名',mcpuid as '菜名编号',mprice as '单价' from BG_Menu where mtype='"+type+"'";
			  
			}
			else	if(cname!="")
			{
				sel="select mid as '菜单ID',mtype as '菜型',mname as '菜名',mcpuid as '菜名编号',mprice as '单价' from BG_Menu where mname='"+cname+"'";
			}
			else{
				sel="select mid as '菜单ID',mtype as '菜型',mname as '菜名',mcpuid as '菜名编号',mprice as '单价' from BG_Menu";
			}
			
			
			try
			{
				dataset=insertcaidan.selectexe(sel,"BG_Menu");
				
			}
			catch(SqlException ex)
			{
			  MessageBox.Show(ex.Message);
			}
			return dataset;
		}
		public DataSet seltype()
		{
			
			try
			{
				objset=insertcaidan.selectexe("select distinct mtype from BG_Menu","BG_Menu");
			}
			catch(SqlException ex)
			{
				MessageBox.Show(ex.Message);
			}
			return objset;
		}
	}
}