Beispiel #1
0
        public PhongLuuTru getPhongLuuTru(int ID)
        {
            PhongLuuTru result = null;
            string      query  = "SELECT * FROM Su_PhongLuuTru WHERE ID = " + ID + "";
            DataTable   dt     = getData(query);

            if (dt.Rows.Count > 0)
            {
                result                    = new PhongLuuTru();
                result.ID                 = ID;
                result.Coquan             = dt.Rows[0]["Coquan"].ToString();
                result.MaPhong            = dt.Rows[0]["MaPhong"].ToString();
                result.TenPhong           = dt.Rows[0]["TenPhong"].ToString();
                result.LichSu             = dt.Rows[0]["LichSu"].ToString();
                result.ThoigianTaiLieu    = dt.Rows[0]["ThoigianTaiLieu"].ToString();
                result.TongSoTaiLieu      = dt.Rows[0]["TongSoTaiLieu"].ToString();
                result.TaiLieuChinhLy     = dt.Rows[0]["TaiLieuChinhLy"].ToString();
                result.TaiLieuChuaChinhLy = dt.Rows[0]["TaiLieuChuaChinhLy"].ToString();
                result.CacNhomTaiLieu     = dt.Rows[0]["CacNhomTaiLieu"].ToString();
                result.NhomTaiLieuKhac    = dt.Rows[0]["NhomTaiLieuKhac"].ToString();
                result.ThoiGianNhap       = dt.Rows[0]["ThoiGianNhap"].ToString();
                result.NgonNgu            = dt.Rows[0]["NgonNgu"].ToString();
                result.CongCu             = dt.Rows[0]["CongCu"].ToString();
                result.BanSaoBaoHiem      = dt.Rows[0]["BanSaoBaoHiem"].ToString();
                result.GhiChu             = dt.Rows[0]["GhiChu"].ToString();
            }
            return(result);
        }
Beispiel #2
0
        public bool addPhongLuuTru(PhongLuuTru newSec)
        {
            bool          result = false;
            SqlConnection conn   = new SqlConnection(connectionString);

            try
            {
                string query = @"INSERT INTO Su_PhongLuuTru ([Coquan]
           ,[MaPhong]
           ,[TenPhong]
           ,[LichSu]
           ,[ThoigianTaiLieu]
           ,[TongSoTaiLieu]
           ,[TaiLieuChinhLy]
           ,[TaiLieuChuaChinhLy]
           ,[CacNhomTaiLieu]
           ,[NhomTaiLieuKhac]
           ,[ThoiGianNhap]
           ,[NgonNgu]
           ,[CongCu]
           ,[BanSaoBaoHiem]
           ,[GhiChu]) VALUES('"
                               + newSec.Coquan
                               + "', N'" + newSec.MaPhong
                               + "', N'" + newSec.TenPhong
                               + "', N'" + newSec.LichSu
                               + "', N'" + newSec.ThoigianTaiLieu
                               + "', N'" + newSec.TongSoTaiLieu
                               + "', N'" + newSec.TaiLieuChinhLy
                               + "', N'" + newSec.TaiLieuChuaChinhLy
                               + "', N'" + newSec.CacNhomTaiLieu
                               + "', N'" + newSec.NhomTaiLieuKhac
                               + "', N'" + newSec.ThoiGianNhap
                               + "', N'" + newSec.NgonNgu
                               + "', N'" + newSec.CongCu
                               + "', N'" + newSec.BanSaoBaoHiem
                               + "', N'" + newSec.GhiChu

                               + "');";
                conn.Open();
                executeDataByQuery(query, conn, null);
                result = true;
            }
            catch (Exception e)
            {
                logUserManagement("addPhongLuuTru()", e.Message);
            }
            finally
            {
                conn.Close();
            }
            return(result);
        }
Beispiel #3
0
        public bool updatePhongLuuTru(PhongLuuTru Sec)
        {
            bool          result = false;
            SqlConnection conn   = new SqlConnection(connectionString);
            string        query  = "UPDATE Su_PhongLuuTru SET Coquan = '" + Sec.Coquan
                                   + "', MaPhong = N'" + Sec.MaPhong
                                   + "', TenPhong = N'" + Sec.TenPhong
                                   + "', LichSu = N'" + Sec.LichSu
                                   + "', TongSoTaiLieu = N'" + Sec.TongSoTaiLieu
                                   + "', TaiLieuChinhLy = N'" + Sec.TaiLieuChinhLy
                                   + "', TaiLieuChuaChinhLy = N'" + Sec.TaiLieuChuaChinhLy
                                   + "', CacNhomTaiLieu = N'" + Sec.CacNhomTaiLieu
                                   + "', NhomTaiLieuKhac = N'" + Sec.NhomTaiLieuKhac
                                   + "', ThoiGianNhap = N'" + Sec.ThoiGianNhap
                                   + "', ThoigianTaiLieu = N'" + Sec.ThoigianTaiLieu
                                   + "', NgonNgu = N'" + Sec.NgonNgu
                                   + "', CongCu = N'" + Sec.CongCu
                                   + "', BanSaoBaoHiem = N'" + Sec.BanSaoBaoHiem
                                   + "', GhiChu = N'" + Sec.GhiChu
                                   + "' WHERE ID = " + Sec.ID + "";

            try
            {
                conn.Open();
                executeDataByQuery(query, conn, null);
                result = true;
            }
            catch (Exception e)
            {
                logUserManagement("updatePhongLuuTru()", e.Message);
            }
            finally
            {
                conn.Close();
            }
            return(result);
        }