userclass.cs

来自「主要是一个图片展示效果」· CS 代码 · 共 78 行

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

/// <summary>
/// UserClass 的摘要说明
/// </summary>
public class UserClass
{
    public UserClass() { }

    private static string strCon = ConfigurationSettings.AppSettings["ConnectionString"].ToString();

    /// <summary>
    /// 添加
    /// </summary>
    /// <param name="userName"></param>
    /// <param name="userPass"></param>
    /// <returns></returns>
    public int UserAdd(string userName, string userPass,string question,string answer)
    { 
        SqlParameter[] paras = {new SqlParameter("@UserName",userName),new SqlParameter("@UserPass",userPass),new SqlParameter("@Result",SqlDbType.Int),new SqlParameter("@Question",question),new SqlParameter("@Answer",answer)};
        paras[2].Direction = ParameterDirection.Output;
        Real.DAL.SqlHelper.ExecuteNonQuery(strCon,CommandType.StoredProcedure,"U_UserAdd",paras);
        return Convert.ToInt32(paras[2].Value);
    }

    /// <summary>
    /// 删除用户
    /// </summary>
    /// <param name="userId"></param>
    /// <returns></returns>
    public void UserDelete(int userId)
    {
        string sql = "Delete From R_User Where UserId="+userId;
        Real.DAL.SqlHelper.ExecuteNonQuery(strCon, CommandType.Text,sql,null);
    }

    /// <summary>
    /// 密码找回
    /// </summary>
    /// <param name="userName"></param>
    /// <param name="xinPass"></param>
    /// <param name="question"></param>
    /// <param name="answer"></param>
    /// <returns></returns>
    public int UserPassBack(string userName,string xinPass,string question,string answer)
    {
        SqlParameter[] paras = { new SqlParameter("@UserName",userName),new SqlParameter("XinPass",xinPass),new SqlParameter("@Result",SqlDbType.Int),new SqlParameter("@Question",question),new SqlParameter("@Answer",answer)};
        paras[2].Direction = ParameterDirection.Output;
        int result = Real.DAL.SqlHelper.ExecuteNonQuery(strCon, CommandType.StoredProcedure, "U_UserPassBack", paras);
        return Convert.ToInt32(paras[2].Value);
    }

    /// <summary>
    /// 修改密码
    /// </summary>
    /// <param name="userId"></param>
    /// <param name="jiuPass"></param>
    /// <param name="xinPass"></param>
    /// <returns></returns>
    public int UserModifyPass(int userId, string jiuPass, string xinPass)
    {
        SqlParameter[] paras = { new SqlParameter("@UserId",userId),new SqlParameter("@JiuPass",jiuPass),new SqlParameter("@XinPass",xinPass),new SqlParameter("@Result",SqlDbType.Int)};
        paras[3].Direction = ParameterDirection.Output;
        Real.DAL.SqlHelper.ExecuteNonQuery(strCon, CommandType.StoredProcedure, "U_UserModifyPass", paras);
        return Convert.ToInt32(paras[3].Value);
    }
}