userdata.cs

来自「库存管理系统,对企业仓库的产品进行管理,使用C#语句 .net 平台开发」· CS 代码 · 共 78 行

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

namespace FORU_SMS_.BaseClass
{
    public class UserData
    {
        DataConn Dconn = new DataConn();
        DataClass Dclass = new DataClass();
        SqlCommand sqlcom;
        SqlDataAdapter adpter;
        public string _Name;
        public string _Pass;
        public string _confPass;

        public string UserName
        {
            set { _Name = value; }
            get { return _Name; }
        }

        public string Password
        {
            set { _Pass = value; }
            get { return _Pass; }
        }

        public string confPass
        {
            set { _confPass = value; }
            get { return _confPass; }
        }

        public void addAdmin()
        {
            string sql = "";
            sql = sql + "insert into SMS_User(UserName,Password) values (@UserName,@Password)";
            sqlcom = new SqlCommand(sql, Dconn.OpenConn());
            adpter = new SqlDataAdapter();
            adpter.SelectCommand = sqlcom;
            sqlcom.Parameters.Add("@UserName", SqlDbType.VarChar, 20).Value = this.UserName;
            sqlcom.Parameters.Add("@Password", SqlDbType.VarChar, 20).Value = this.Password;
            try
            {
                sqlcom.ExecuteNonQuery();
            }
            catch (Exception) { }
            finally
            {
                Dconn.CloseConn();
            }
        }

        public void editAdmin()
        {
            string sql = "";
            sql = sql + "update SMS_User set Password=@Password where UserName=@UserName";
            sqlcom = new SqlCommand(sql, Dconn.OpenConn());
            adpter = new SqlDataAdapter();
            adpter.SelectCommand = sqlcom;
            sqlcom.Parameters.Add("@UserName", SqlDbType.VarChar, 20).Value = this.UserName;
            sqlcom.Parameters.Add("@Password", SqlDbType.VarChar, 20).Value = this.Password;
            try
            {
                sqlcom.ExecuteNonQuery();
            }
            catch (Exception) { }
            finally
            {
                Dconn.CloseConn();
            }
        }
    }
}