changepwd.cs

一个较小的采购系统,一些比较实际的代码,可以用来参考

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>
/// changePWD 的摘要说明
/// </summary>
public class changePWD
{
    public SqlDataReader dr()
    {
        //返回区域的SqlDataReader列表
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"];
        conn.Open();
        SqlCommand cmd = new SqlCommand("select area_name from area", conn);
        SqlDataReader dr = cmd.ExecuteReader();
        return dr;
        conn.Dispose();
    }
    public SqlDataReader dr2(string str)
    {
        //返回帐号的SqlDataReader列表
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"];
        conn.Open();
        SqlCommand cmd = new SqlCommand("select user_UID from info where user_area='"+str+"'and user_UID !='administrator' ", conn);
        SqlDataReader dr = cmd.ExecuteReader();
         return dr;
         conn.Dispose();
    }
    public void update(string uid,string pwd)//更新数据库中用户帐号的密码
    {
        string strpwd = FormsAuthentication.HashPasswordForStoringInConfigFile(pwd, "md5");
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"];
        conn.Open();
        SqlCommand cmd = new SqlCommand("update info set user_PWD='" + strpwd + "' where user_UID='" + uid + "'", conn);
        cmd.ExecuteNonQuery();
        conn.Close();
        conn.Dispose();
    }
    public string dr3(string str)
    {
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"];
        conn.Open();
        SqlCommand cmd = new SqlCommand("select user_UID  from info where user_UID= '"+str+"'", conn);
        string struid = Convert.ToString(cmd.ExecuteScalar());
        return struid;
        conn.Dispose();
         
    }
}