Name

191         public int CheckLogin(string name, string pass)
192         {
193             SqlConnection con = da.GetConnect();
194             SqlCommand cmd = new SqlCommand("select *from Users Where Username='"+name+"' and Password='"+pass+"'",con);
195             con.Open();
196             SqlDataReader dr = cmd.ExecuteReader();
197             if (dr.Read())
198             {
199                 if (dr[2].ToString() == "admin")
200                 {
201                     return 1;
202                 }
203                 else
204                 {
205                     return 2;
206                 }
207             }
208             else
209             {
210                 return -1;
211             }
212         }

24         public override string ResourceName {
25             get {
26                 return "crBaoCao.rpt";
27             }
28             set {
29                 // Do nothing
30             }
31         }

42         public override string FullResourceName {
43             get {
44                 return "QuanLyDiem.crBaoCao.rpt";
45             }
46             set {
47                 // Do nothing
48             }
49         }

104         public void CloseForm(string form_hienthoi)
105         {
106             // duyet qua tung form con dang mo
107             foreach (Form frm in this.MdiChildren)
108             {
109                 // neu hok phai form dang mo thi dong lai
110                 if (!frm.Name.Equals(form_hienthoi))
111                     frm.Close();
112             }
113         }

40         private void btnLoc_Click(object sender, EventArgs e)
41         {
42             SqlConnection con = dal.GetConnect();
43             con.Open();
44             string sql = "select *from SinhVien where MaLop=@MaLop";
45             SqlDataAdapter da = new SqlDataAdapter(sql, con);
46             da.SelectCommand.Parameters.AddWithValue("@MaLop", cmbMaLop.SelectedValue.ToString());
47             DataTable dt = new DataTable();
48             da.Fill(dt);
49             crBaoCao cr = new crBaoCao();
50             ConnectionInfo crConnectionInfo = new ConnectionInfo();
51             crConnectionInfo.ServerName = "Ty-PC";
52             crConnectionInfo.DatabaseName = "CNPM_1";
53             crConnectionInfo.UserID = "sa";
54             crConnectionInfo.Password = "04091990";
55             TableLogOnInfos crTableLogonInfos = new TableLogOnInfos();
56             foreach (CrystalDecisions.CrystalReports.Engine.Table table in cr.Database.Tables)
57             {
58                 TableLogOnInfo crTableLogonInfo = new TableLogOnInfo();
59                 crTableLogonInfo.TableName = table.Name;
60                 crTableLogonInfo.ConnectionInfo = crConnectionInfo;
61                 crTableLogonInfos.Add(crTableLogonInfo);
62                 table.ApplyLogOnInfo(crTableLogonInfo);
63
64             }
65             crvHocKyHocPhan.LogOnInfo = crTableLogonInfos;
66             cr.SetDataSource(dt);
67             ParameterValues a = new ParameterValues();
68             ParameterDiscreteValue b = new ParameterDiscreteValue();
69             b.Value = cmbMaLop.SelectedValue.ToString();
70             a.Add(b);
71             cr.DataDefinition.ParameterFields["txtMaLop"].ApplyCurrentValues(a);
72             crvHocKyHocPhan.ReportSource = cr;
73             crvHocKyHocPhan.Show();
74         }

45         private void btnThem_Click(object sender, EventArgs e)
46         {
47
48             if(txtTenDangNhap.Text!="")
49             {
50                 if(business.Proc_Insert("Insert_Users",txtTenDangNhap.Text))
51                 {
52                     string sql = "'" + txtTenDangNhap.Text + "','" + txtMatKhau.Text + "','" + cmbQuyen.SelectedItem.ToString() + "'";
53                     business.Insert("Users",sql);
54                     FormPhanQuyen_Load(sender, e);
55                 }
56                 else
57                 {
58                     MessageBox.Show("Username này đã tồn tại");
59                 }
60             }
61         }

63         private void btnXoa_Click(object sender, EventArgs e)
64         {
65             DialogResult result;
66             result = MessageBox.Show("Bạn có chắc chắn muốn xóa không ?","Hệ Thống", MessageBoxButtons.YesNo);
67             if (result == DialogResult.Yes)
68             {
69                 string sql = "Username='" + txtTenDangNhap.Text + "'";
70                 business.Delete("Users", sql);
71                 FormPhanQuyen_Load(sender, e);
72             }
73         }

75         private void btnSua_Click(object sender, EventArgs e)
76         {
77             string sql = "Password='" + txtMatKhau.Text + "',Quyen='" + cmbQuyen.SelectedItem.ToString() + "' where Username='"+txtTenDangNhap.Text+"'";
78             business.Update("Users",sql);
79             FormPhanQuyen_Load(sender, e);
80         }

24         public override string ResourceName {
25             get {
26                 return "rptThisinh.rpt";
27             }
28             set {
29                 // Do nothing
30             }
31         }

42         public override string FullResourceName {
43             get {
44                 return "Doan.rptThisinh.rpt";
45             }
46             set {
47                 // Do nothing
48             }
49         }