订餐网站0(与数据库交互)

using System;

using System.Collections.Generic;

using System.Web;

using System.Data.OleDb;

using System.Configuration;

using System.Data;

namespace Common

{

/// <summary>

///dbOperation 的摘要说明

/// </summary>

public class dbOperation

{

#region 私有静态字段

private static OleDbConnection conn;

#endregion

#region 构造，析构函数

public dbOperation()

{

conn = new OleDbConnection(ConfigurationManager.ConnectionStrings["oledbconn"].ConnectionString);

conn.Open();

}

~dbOperation()

{

if (conn != null && conn.State != System.Data.ConnectionState.Closed)

conn.Close();

}

#endregion

#region 公开静态方法

public static OleDbConnection GetConnection()

{

if(conn ==null)

conn = new OleDbConnection(ConfigurationManager.ConnectionStrings["oledbconn"].ConnectionString);

if(conn.State != System.Data.ConnectionState.Open)

conn.Open();

return conn;

}

public static bool IsRootUser(long username, string password)

{

string sql = string.Format("select count(*) from members where phone={0} AND password = '{1}'",username.ToString(),password);

OleDbCommand cmd = new OleDbCommand(sql, GetConnection());

int count = 0;

if (int.TryParse(cmd.ExecuteScalar().ToString(), out count) && count == 1)

return true;

else

return false;

}

public static DataTable GetAllDishes2()

{

DataSet ds=new DataSet();

using (OleDbCommand oleCmd = new OleDbCommand("Select * from dish", GetConnection()))

{

using (OleDbDataAdapter da = new OleDbDataAdapter(oleCmd))

{

da.Fill(ds, "Dish");

}

}

return ds.Tables["Dish"];

}

public static List<Dish> GetAllDishes()

{

List<Dish> dishes = new List<Dish>();

string sql = "select * from dish";

OleDbCommand cmd = new OleDbCommand(sql, GetConnection());

OleDbDataReader reader = cmd.ExecuteReader();

while (reader.Read())

{

Dish d = new Dish(int.Parse(reader["dishId"].ToString()));

d.Name = reader["dishName"].ToString();

d.DishType = reader["type"].ToString();

d.Details = reader["details"].ToString();

d.Intro = reader["intro"].ToString();

d.IsTodayDish = bool.Parse(reader["isTodayDish"].ToString());

d.Pic = reader["pic"].ToString();

d.TotalOrders = int.Parse(reader["totalOrders"].ToString());

d.WeeklyOrders = int.Parse(reader["weeklyOrders"].ToString());

d.TotalOrders = int.Parse(reader["todayOrders"].ToString());

dishes.Add(d);

}

return dishes;

}

public static int ExcuteSql(string sql)

{

try

{

OleDbConnection conn = GetConnection();

OleDbCommand cmd = new OleDbCommand(sql, conn);

return cmd.ExecuteNonQuery();

}

catch (Exception ex)

{

Console.WriteLine(ex.Message);

return -1;

}

}

#endregion

}

}