commondataaccess.cs

网上书店

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.Common;
/// <summary>
///CommonDataAccess 的摘要说明
///网站前台提供给用户界面时候所需要用到的函数
/// </summary>
public class CommonDataAccess
{
    public CommonDataAccess()
    {
        //
        //TODO: 在此处添加构造函数逻辑
        //
    }

    //获得推荐图书
    public static DataTable GetBooksRecommand(int pageNumber, out int howManyPages)
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "GetBooksRecommand";

        DbParameter param = cmd.CreateParameter();
        param.ParameterName = "@ProductsPerPage";
        param.DbType = DbType.Int32;
        param.Value = DatabaseConfiguration.ProductsPerPage;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.ParameterName = "@ContentLength";
        param.DbType = DbType.Int32;
        param.Value = DatabaseConfiguration.ContentLength.ToString();
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.ParameterName = "@PageNumber";
        param.DbType = DbType.Int32;
        param.Value = pageNumber.ToString();
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.ParameterName = "@HowManyProducts";
        param.DbType = DbType.Int32;
        param.Direction = ParameterDirection.Output;
        cmd.Parameters.Add(param);

        DataTable dt = CmdPart.ExcuteSelectCommand(cmd);
        string str = cmd.Parameters["@HowManyProducts"].Value.ToString();
        int howManyProducts = Int32.Parse(str);
        howManyPages = howManyProducts > 0 ? (howManyProducts - 1) / DatabaseConfiguration.ProductsPerPage + 1 : 0;
        return dt;

    }

    //获得图书门类
    public static DataTable GetDepartments()
    {
        DbCommand cmd = CmdPart.CreateCommand();

        cmd.CommandText = "GetDepartments";

        return CmdPart.ExcuteSelectCommand(cmd);
    }

    //根据图书门图书类获得图书分类
    public static DataTable GetCategoriesInDepartment(string departmentID)
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "GetCategoriesInDepartment";

        DbParameter param = cmd.CreateParameter();
        param.ParameterName = "@DepartmentID";
        param.DbType = DbType.Int32;
        param.Value = departmentID;
        cmd.Parameters.Add(param);

        return CmdPart.ExcuteSelectCommand(cmd);
    }

    //取得某个分类下的产品信息
    public static DataTable GetBooksInCategory(string categoryID, int pageNumber, out int howManyPages)
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "GetBooksInCategory";

        DbParameter param = cmd.CreateParameter();
        param.ParameterName = "@CategoryID";
        param.DbType = DbType.Int32;
        param.Value = categoryID;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.ParameterName = "@ProductsPerPage";
        param.DbType = DbType.Int32;
        param.Value = DatabaseConfiguration.ProductsPerPage.ToString();
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.ParameterName = "@ContentLength";
        param.DbType = DbType.Int32;
        param.Value = DatabaseConfiguration.ContentLength.ToString();
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.ParameterName = "@PageNumber";
        param.DbType = DbType.Int32;
        param.Value = pageNumber.ToString();
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.ParameterName = "@HowManyProducts";
        param.DbType = DbType.Int32;
        param.Direction = ParameterDirection.Output;
        cmd.Parameters.Add(param);

        DataTable dt = CmdPart.ExcuteSelectCommand(cmd);
        string str = cmd.Parameters["@HowManyProducts"].Value.ToString();
        int howManyProducts = Int32.Parse(str);
        howManyPages = howManyProducts > 0 ? (howManyProducts - 1) / DatabaseConfiguration.ProductsPerPage + 1 : 0;
        return dt;
    }

    //取得某个门类下的50个产品信息
    public static DataTable GetBooksInDepartment(string departmentID, int pageNumber, out int howManyPages)
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "GetBooksInDepartment";

        DbParameter param = cmd.CreateParameter();
        param.ParameterName = "@DepartmentID";
        param.DbType = DbType.Int32;
        param.Value = departmentID;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.ParameterName = "@ProductsPerPage";
        param.DbType = DbType.Int32;
        param.Value = DatabaseConfiguration.ProductsPerPage.ToString();
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.ParameterName = "@ContentLength";
        param.DbType = DbType.Int32;
        param.Value = DatabaseConfiguration.ContentLength.ToString();
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.ParameterName = "@PageNumber";
        param.DbType = DbType.Int32;
        param.Value = pageNumber.ToString();
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.ParameterName = "@HowManyProducts";
        param.DbType = DbType.Int32;
        param.Direction = ParameterDirection.Output;
        cmd.Parameters.Add(param);

        DataTable dt = CmdPart.ExcuteSelectCommand(cmd);
        string str = cmd.Parameters["@HowManyProducts"].Value.ToString();
        int howManyProducts = Int32.Parse(str);
        howManyPages = howManyProducts > 0 ? (howManyProducts - 1) / DatabaseConfiguration.ProductsPerPage + 1 : 0;
        return dt;
    }

    //判断用户名是否存在 
    public static bool IsCustomerNameExsist(string customerName)
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "IsCustomerNameExsist";

        DbParameter param = cmd.CreateParameter();
        param.ParameterName = "@CustomerName";
        param.DbType = DbType.String;
        param.Value = customerName;
        cmd.Parameters.Add(param);

        DataTable dt = CmdPart.ExcuteSelectCommand(cmd);
        if (dt.Rows.Count > 0)
        {
            return true;
        }
        else
        {
            return false;
        }
    }

    //用户注册
    public static bool InsertCustomerInfo(string customerName, string password,
        string Email, string realName, string address, string post, string phone,
        string question, string answer)
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "InsertCustomerInfo";

        DbParameter param = cmd.CreateParameter();
        param.ParameterName = "@CustomerName";
        param.DbType = DbType.String;
        param.Value = customerName;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.ParameterName = "@Password";
        param.DbType = DbType.String;
        param.Value = password;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.ParameterName = "@Email";
        param.DbType = DbType.String;
        param.Value = Email;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.ParameterName = "@RealName";
        param.DbType = DbType.String;
        param.Value = realName;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.ParameterName = "@Address";
        param.DbType = DbType.String;
        param.Value = address;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.ParameterName = "@Post";
        param.DbType = DbType.String;
        param.Value = post;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.ParameterName = "@Phone";
        param.DbType = DbType.String;
        param.Value = phone;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.ParameterName = "@Question";
        param.DbType = DbType.String;
        param.Value = question;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.ParameterName = "@Answer";
        param.DbType = DbType.String;
        param.Value = answer;
        cmd.Parameters.Add(param);

        return CmdPart.ExcuteNonSelectCommand(cmd);
    }

    //判断用户是否存在
    public static bool IsCustomerExsist(string customerName, string password)
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "IsCustomerExsist";

        DbParameter param = cmd.CreateParameter();
        param.ParameterName = "@CustomerName";
        param.DbType = DbType.String;
        param.Value = customerName;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.ParameterName = "@password";
        param.DbType = DbType.String;
        param.Value = password;
        cmd.Parameters.Add(param);

        DataTable dt = CmdPart.ExcuteSelectCommand(cmd);
        if (dt.Rows.Count > 0)
        {
            return true;
        }
        else