Example #1
0
        public List <MinhChungDTO> SearchListMinhChung(string valueToSearch)
        {
            List <MinhChungDTO> List = new List <MinhChungDTO>();
            string query             = string.Format("SELECT MChung.ID_TaiLieu, MChung.MaTaiLieu, MChung.TenTaiLieu, MChung.NgayKy, MChung.NguoiKy, MChung.SoBanHanh, MChung.TomTatNoiDung, MChung.GhiChu " +
                                                     "FROM dbo.MinhChung MChung WHERE CONCAT(MChung.MaTaiLieu, MChung.TenTaiLieu, MChung.NgayKy, MChung.NguoiKy, MChung.SoBanHanh, MChung.TomTatNoiDung, MChung.GhiChu) LIKE N'%" + valueToSearch + "%'");
            DataTable dataTable = DataBaseConnection.Instance.ExecuteQuery(query);

            foreach (DataRow dataRow in dataTable.Rows)
            {
                MinhChungDTO minhChung = new MinhChungDTO(dataRow);
                List.Add(minhChung);
            }
            return(List);
        }
Example #2
0
        public List <MinhChungDTO> GetListMinhChung()
        {
            List <MinhChungDTO> List = new List <MinhChungDTO>();
            string query             = "SELECT MChung.ID_TaiLieu, MChung.MaTaiLieu, MChung.TenTaiLieu, MChung.NgayKy, MChung.NguoiKy, MChung.SoBanHanh, MChung.TomTatNoiDung, MChung.GhiChu " +
                                       "FROM dbo.MinhChung MChung";
            DataTable dataTable = DataBaseConnection.Instance.ExecuteQuery(query);

            foreach (DataRow dataRow in dataTable.Rows)
            {
                MinhChungDTO minhChung = new MinhChungDTO(dataRow);
                List.Add(minhChung);
            }
            return(List);
        }