conndb.cs

在线pizza 预定系统,可以供现在正编写预定程序的朋友学习或借鉴

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

namespace PizzaOnline
{
	/// <summary>
	/// ConnDB 的摘要说明--连接数据库
	/// </summary>
	public class ConnDB
	{
		public static SqlConnection Conn()
		{
			string str=ConfigurationSettings.AppSettings["connection"];
			return new SqlConnection(str);
		}
		public static int isEmailExist(string email)
		{
			SqlConnection con=ConnDB.Conn();
			con.Open();
			SqlCommand cmd=new SqlCommand("sel_Customer_tbl",con);
			cmd.CommandType=CommandType.StoredProcedure;
			cmd.Parameters.Add("@email",email);
			cmd.Parameters.Add("@bool",SqlDbType.Int);
			cmd.Parameters["@bool"].Direction=ParameterDirection.Output;
			cmd.ExecuteNonQuery();
			int i=Convert.ToInt32(cmd.Parameters["@bool"].Value.ToString());
			con.Close();
            return i;
		}
		public static void addUser(string username,string email,string address,string tel)
		{
			SqlConnection con=ConnDB.Conn();
			con.Open();
			SqlCommand cmd=new SqlCommand("ins_Customer_tbl",con);
			cmd.CommandType=CommandType.StoredProcedure;
			cmd.Parameters.Add("@username",username);
			cmd.Parameters.Add("@email",email);
			cmd.Parameters.Add("@address",address);
			cmd.Parameters.Add("@tel",tel);
            cmd.ExecuteNonQuery();
			con.Close();
		}
		public static int insOrder(string email)
		{
			SqlConnection con=ConnDB.Conn();
			con.Open();
			SqlCommand cmd=new SqlCommand("ins_Order_tbl",con);
			cmd.CommandType=CommandType.StoredProcedure;
			cmd.Parameters.Add("@email",email);
            cmd.Parameters.Add("@Orderid",SqlDbType.Int);
            cmd.Parameters["@Orderid"].Direction=ParameterDirection.Output;
			cmd.ExecuteNonQuery();
            int j=Convert.ToInt32(cmd.Parameters["@Orderid"].Value.ToString());
			con.Close();
			return j;
		}
		public static void insOrderDetail(int orderid,int pid,string size,int quan)
		{
			SqlConnection con=ConnDB.Conn();
			con.Open();
            SqlCommand cmd=new SqlCommand("ins_OrderDetail_tbl",con);
			cmd.CommandType=CommandType.StoredProcedure;
			cmd.Parameters.Add("@orderid",orderid);
			cmd.Parameters.Add("@pid",pid);
			cmd.Parameters.Add("@size",size);
			cmd.Parameters.Add("@quan",quan);
			cmd.ExecuteNonQuery();
			con.Close();
		}
	}
}