Data_Control/User_Control.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Data_Access;

namespace Data_Control
{
    public  class User_Control:EquipmentDBConnection 
    {
        /// <summary>
        /// 用户登录验证
        /// </summary>
        /// <param name="Userinfo">ArrayList类型的用户信息数组</param>
        /// <returns>包含指定用户信息的IDataReader</returns>
        public DataSet  User_Login(ArrayList Userinfo)
        {
            using (SqlConnection conn = this.GetEquipmentConnStr())
            {
               
                try
                {
                    conn.Open();
                    string sqlstr = "select * from Admin where Admin_User='" + Userinfo[0].ToString() + "' and " +
                       "Admin_Pwd='" + Userinfo[1].ToString() + "'";

                    //SqlCommand cmd = new SqlCommand("sqlstr", conn);
                    SqlDataAdapter da = new SqlDataAdapter(sqlstr ,conn );
                    DataSet ds = new DataSet();
                  
                    da.Fill (ds,"Admin");
                    return ds;
                 
                }
                catch (Exception e)
                {
                    throw (e);
                }
            }
        }
        /// <summary>
        /// 修改指定用户的密码
        /// </summary>
        /// <param name="UserPwd">ArrayList类型的用户密码数组</param>
        public void UP_Pwd(ArrayList UserPwd)
        {
            using (SqlConnection conn = this.GetEquipmentConnStr())
            {
                string strsql = "update Admin set Admin_Pwd='" + UserPwd[1] + "' where Admin_User='" + UserPwd[0] + "'";
                conn.Open();
                SqlCommand cmd = new SqlCommand(strsql, conn);
                cmd.ExecuteNonQuery();
                conn.Close();
            }
        }
    }
}