db.cs

酒店管理系统

using System;
using System.Data.SqlClient;
using System.Data;

namespace hotel
{
	/// <summary>
	/// DB 的摘要说明。
	/// </summary>
	public class DB
	{
		public DB()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		public static SqlConnection createCon()
		{
			SqlConnection con=new SqlConnection("server=.;uid=sa;pwd=sa;database=twj;");
			return con;
		}
		public static  bool judge(string username)
		{
			SqlConnection con = DB.createCon();
			con.Open();
			SqlCommand cmd=new SqlCommand("select count(*) from users where username='"+username+"'",con);
			int count=Convert.ToInt32(cmd.ExecuteScalar());
			if(count>0)
			{
				return true;

			}
			else
			{
				return false;
			}
		}
		public static  bool judgerummery(string rummeryname)
		{
			SqlConnection con = DB.createCon();
			con.Open();
			SqlCommand cmd=new SqlCommand("select count(*) from rummery where rummeryname='"+rummeryname+"'",con);
			int count=Convert.ToInt32(cmd.ExecuteScalar());
			if(count>0)
			{
				return true;

			}
			else
			{
				return false;
			}
		}
		public static  bool judgescape(string scapename)
		{
			SqlConnection con = DB.createCon();
			con.Open();
			SqlCommand cmd=new SqlCommand("select count(*) from rummery where scapename='"+scapename+"'",con);
			int count=Convert.ToInt32(cmd.ExecuteScalar());
			if(count>0)
			{
				return true;

			}
			else
			{
				return false;
			}
		}
		public static  bool judgeciceroni(string ciceroniid)
		{
			SqlConnection con = DB.createCon();
			con.Open();
			SqlCommand cmd=new SqlCommand("select count(*) from ciceroni where ciceroniid='"+ciceroniid+"'",con);
			int count=Convert.ToInt32(cmd.ExecuteScalar());
			if(count>0)
			{
				return true;

			}
			else
			{
				return false;
			}
		}
		public static bool insertoperate(user p)
		{
			try
			{
				SqlConnection con=DB.createCon();
				con.Open();
				SqlCommand cmd=new SqlCommand("insert into users values(@username,@name,@sex,@password,@homemail,@mobiletelephone,@email,@company)",con);
				SqlParameter para=new SqlParameter("@username",SqlDbType.VarChar,50);
				para.Value=p.username;
				cmd.Parameters.Add(para);
				para=new SqlParameter("@name",SqlDbType.VarChar,50);
				para.Value=p.name;
				cmd.Parameters.Add(para);
				para=new SqlParameter("@sex",SqlDbType.Char,10);
				para.Value=p.sex;
				cmd.Parameters.Add(para);
				para=new SqlParameter("@password",SqlDbType.VarChar,50);
				para.Value=p.password;
				cmd.Parameters.Add(para);
				para=new SqlParameter("@homemail",SqlDbType.VarChar,50);
				para.Value=p.homemail;
				cmd.Parameters.Add(para);
				para=new SqlParameter("@mobiletelephone",SqlDbType.VarChar,50);
				para.Value=p.mobiletelephone;
				cmd.Parameters.Add(para);
				para=new SqlParameter("@email",SqlDbType.VarChar,50);
				para.Value=p.email;
				cmd.Parameters.Add(para);
				para=new SqlParameter("@company",SqlDbType.VarChar,50);
				para.Value=p.company;
				cmd.Parameters.Add(para);
				cmd.ExecuteNonQuery();
				return true;
			}
			catch(Exception e)
			{
				return false;
			 }




		}
	}
}