コード例 #1
0
 //Sửa dữ liệu
 public bool UpdateData(DangNhapObj dnObj)
 {
     cmd.CommandText = string.Format("UPDATE tbleDangNhap SET MADN = '{0}', MANV = '{1}', TENDN = '{2}', MATKHAU = '{3}', QUYENTC = '{4}' WHERE (MADN = '{0}')", dnObj.MaDN, dnObj.MaNV, dnObj.TenDN, dnObj.MatKhau, dnObj.QuyenTC);
     cmd.CommandType = CommandType.Text;
     cmd.Connection  = con.Connection;
     try
     {
         con.openCon();
         cmd.ExecuteNonQuery();
         con.closeCon();
         return(true);
     }
     catch (Exception ex)
     {
         string mes = ex.Message;
         cmd.Dispose();
         con.closeCon();
     }
     return(false);
 }
コード例 #2
0
 //Thêm dữ liệu
 public bool AddData(DangNhapObj dnObj)
 {
     cmd.CommandText = string.Format("INSERT INTO tbleDangNhap (MADN, MANV, TENDN, MATKHAU, QUYENTC) VALUES ('{0}', '{1}', '{2}', '{3}', '{4}')", dnObj.MaDN, dnObj.MaNV, dnObj.TenDN, dnObj.MatKhau, dnObj.QuyenTC);
     cmd.CommandType = CommandType.Text;
     cmd.Connection  = con.Connection;
     try
     {
         con.openCon();
         cmd.ExecuteNonQuery();
         con.closeCon();
         return(true);
     }
     catch (Exception ex)
     {
         string mes = ex.Message;
         cmd.Dispose();
         con.closeCon();
     }
     return(false);
 }
コード例 #3
0
 public bool updateData(DangNhapObj dnObj)
 {
     return(dnMod.UpdateData(dnObj));
 }
コード例 #4
0
 public bool addData(DangNhapObj dnObj)
 {
     return(dnMod.AddData(dnObj));
 }