CPUFramework/bizUser.cs at main · FCBernstein/CPUFramework · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
using System;
using System.Collections.Generic;
using Microsoft.Data.SqlClient;
using System.Text;
using System.Data;

namespace CPUFramework
{
    public class bizUser: bizObject<bizUser>
    {
        public void Login()
        {
            SqlCommand cmd = SQLUtility.GetSQLCommand("UserLogin");
            SQLUtility.SetParamValue(cmd, "username", UserName);
            SQLUtility.SetParamValue(cmd, "password", Password);
            this.Password = "";
            DataTable dt = SQLUtility.GetDataTable(cmd);
            if (dt.Rows.Count > 0)
            {
                this.LoadProps(dt.Rows[0]);
            }

        }

        public void Logout()
        {
            SqlCommand cmd = SQLUtility.GetSQLCommand("UserLogout");
            SQLUtility.SetParamValue(cmd, "username", UserName);
            DataTable dt = SQLUtility.GetDataTable(cmd);
            this.UserId = 0;
            this.UserName = "";
            this.RoleId = 0;
            this.RoleName = "";
            this.RoleRank = 0;

        }
        public void LoadBySessionKey()
        {
            SqlCommand cmd = SQLUtility.GetSQLCommand("UserGet");
            SQLUtility.SetParamValue(cmd, "sessionkey", SessionKey);
            DataTable dt = SQLUtility.GetDataTable(cmd);
            if (dt.Rows.Count > 0)
            {
                this.LoadProps(dt.Rows[0]);
            }

        }


        public int UserId { get; set; }
        public int RoleId { get; set; }
        public string UserName { get; set; } = "";
        public string Password { get; set; } = "";
        public string SessionKey { get; set; } = "";
        public string RoleName { get; set; } = "";
        public int RoleRank { get; set; }

    }
}