usercenteraccess.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>
///UserCenterAccess 的摘要说明
/// </summary>

public struct customerInfo
{
    public string customerName;
    public string realName;
    public string address;
    public string phone;
    public string post;
    public string Email;

}

public static  class UserCenterAccess
{
    //修改客户密码
    public static bool ChangeCustomerPassword(string customerName, string newPassword)
   
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "ChangeCustomerPassword";

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

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

        return CmdPart.ExcuteNonSelectCommand(cmd);
    }
    //取得用户订单
    public static DataTable GetCustomerOrders(string customerName)
    
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "GetCustomerOrders";

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

        return CmdPart.ExcuteSelectCommand(cmd);
    }

    //删除某个客户订单
    public static bool DeleteCustomerOrder(string orderID)
  
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "DeleteCustomerOrder";

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

        return CmdPart.ExcuteNonSelectCommand(cmd);
    }

    //取得某一订单的所有产品信息
    public static DataTable GetOrderProducts(string orderID)
    
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "GetOrderProducts";

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

        return CmdPart.ExcuteSelectCommand(cmd);
    }

    //取得某一订单的详情
    public static DataTable GetOrderDetail(string orderID)
   
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "GetOrderDetail";

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

        return CmdPart.ExcuteSelectCommand(cmd);
    }

    //取得用户信息
    public static customerInfo GetCustomerInfo(string customerName)
   
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "GetCustomerInfo";

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

        customerInfo user = new customerInfo();
        DataTable dt = CmdPart.ExcuteSelectCommand(cmd);
        if (dt.Rows.Count > 0)
        {
            user.customerName = dt.Rows[0][0].ToString();
            user.realName = dt.Rows[0][1].ToString();
            user.address = dt.Rows[0][2].ToString();
            user.phone = dt.Rows[0][3].ToString();
            user.post = dt.Rows[0][4].ToString();
            user.Email = dt.Rows[0][5].ToString();

        }
        return user;
    }

    //修改用户信息
    public static bool ModifyUserInfo(string customerName, string realname, string address,
        string phone, string post, string Email)
    
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "ModifyUserInfo";

        DbParameter param = cmd.CreateParameter();
        param.ParameterName = "@CustomerName";
        param.DbType = DbType.String;
        param.Value = customerName;
        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 = "@Phone";
        param.DbType = DbType.String;
        param.Value = phone;
        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 = "@Email";
        param.DbType = DbType.String;
        param.Value = Email;
        cmd.Parameters.Add(param);

        return CmdPart.ExcuteNonSelectCommand(cmd);

    }

    //修改用户找回密码问题和答案
    public static bool ChangeQuestionAndAnswer(string customerName, string question,
        string answer)
    
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "ChangeQuestionAndAnswer";

        DbParameter param = cmd.CreateParameter();
        param.ParameterName = "@CustomerName";
        param.DbType = DbType.String;
        param.Value = customerName;
        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 string GetQuestion(string customerName)
   
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "GetQuestion";

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

        return CmdPart.ExecuteScalar(cmd);
    }
}