Quản lý nhân sự công ty bằng c# _ full source code
60.731 lượt xem;
- clsUser.cs
- Class /
- QuanLyNhanSu /
- project /
1 using System;
2 using System.Collections.Generic;
3 using System.Text;
4 using System.Windows.Forms;
5 using System.Data.SqlClient;
6 using System.Collections;
7 using System.Data;
8
9 namespace QuanLyNhanSu.Class
10 {
11 class clsUser
12 {
13 public SqlConnection sc = frmMain.me.sql.connectSQL();
14 public SqlDataAdapter sda = new SqlDataAdapter();
15 public DataSet ds = new DataSet();
16
17 public DataSet taocombo()
18 {
19 ds.Clear();
20 sc.Open();
21 string sql1 = "Select * from tbl_User where id<>'administrator'";
22 SqlCommand scmd = new SqlCommand(sql1,sc);
23 sda.SelectCommand = scmd;
24 sda.Fill(ds, "User");
25 sc.Close();
26 return ds;
27 }
28
29 public bool KiemTraHopLe(string user, string mk)
30 {
31 string sql = "Select * from tbl_User where id='" + user +
32 "' and pass='" + mk + "'";
33 sc.Open();
34 SqlCommand scmd = new SqlCommand(sql, sc);
35 object o= scmd.ExecuteScalar();
36 sc.Close();
37 if (o == null) return false;
38 else return true;
39
40 }
41
42 public void them(string uname, string pass, string nhom)
43 {
44 sql.ExecuteNonQuery("insert_tbl_USER", CommandType.StoredProcedure,
45 "@ID_1", uname,
46 "@Pass_2", pass,
47 "@nhom_3", nhom);
48 }
49
50 public void sua(string uname,string pass,string nhom)
51 {
52 sql.ExecuteNonQuery("update_tbl_USER", CommandType.StoredProcedure,
53 "@ID_1", uname,
54 "@Pass_2", pass,
55 "@nhom_3", nhom);
56 }
57
58 public void xoa(string uname)
59 {
60 sql.ExecuteNonQuery("delete_tbl_USER", CommandType.StoredProcedure,
61 "@ID_1", uname);
62 }
63 }
64 }
2 using System.Collections.Generic;
3 using System.Text;
4 using System.Windows.Forms;
5 using System.Data.SqlClient;
6 using System.Collections;
7 using System.Data;
8
9 namespace QuanLyNhanSu.Class
10 {
11 class clsUser
12 {
13 public SqlConnection sc = frmMain.me.sql.connectSQL();
14 public SqlDataAdapter sda = new SqlDataAdapter();
15 public DataSet ds = new DataSet();
16
17 public DataSet taocombo()
18 {
19 ds.Clear();
20 sc.Open();
21 string sql1 = "Select * from tbl_User where id<>'administrator'";
22 SqlCommand scmd = new SqlCommand(sql1,sc);
23 sda.SelectCommand = scmd;
24 sda.Fill(ds, "User");
25 sc.Close();
26 return ds;
27 }
28
29 public bool KiemTraHopLe(string user, string mk)
30 {
31 string sql = "Select * from tbl_User where id='" + user +
32 "' and pass='" + mk + "'";
33 sc.Open();
34 SqlCommand scmd = new SqlCommand(sql, sc);
35 object o= scmd.ExecuteScalar();
36 sc.Close();
37 if (o == null) return false;
38 else return true;
39
40 }
41
42 public void them(string uname, string pass, string nhom)
43 {
44 sql.ExecuteNonQuery("insert_tbl_USER", CommandType.StoredProcedure,
45 "@ID_1", uname,
46 "@Pass_2", pass,
47 "@nhom_3", nhom);
48 }
49
50 public void sua(string uname,string pass,string nhom)
51 {
52 sql.ExecuteNonQuery("update_tbl_USER", CommandType.StoredProcedure,
53 "@ID_1", uname,
54 "@Pass_2", pass,
55 "@nhom_3", nhom);
56 }
57
58 public void xoa(string uname)
59 {
60 sql.ExecuteNonQuery("delete_tbl_USER", CommandType.StoredProcedure,
61 "@ID_1", uname);
62 }
63 }
64 }