public HinhThucThanhToanDTO[] LayDanhSachHTTT() { HinhThucThanhToanDTO[] Kq; Connect(); SqlCommand cmd = new SqlCommand("spLayDanhSachHTTT", cnn); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); int i = 0; int n = dt.Rows.Count; Kq = new HinhThucThanhToanDTO[n]; for (i = 0; i < n; ++i) { object htkm = GetDataFromDataRow(dt, i); Kq[i] = (HinhThucThanhToanDTO)htkm; } Disconnect(); return(Kq); }
protected override object GetDataFromDataRow(DataTable dt, int i) { HinhThucThanhToanDTO httt = new HinhThucThanhToanDTO(); httt.Mahinh_thuc_tt = (int)dt.Rows[i]["MaHinhThucThanhToan"]; httt.Ten_hinh_thuc_tt = dt.Rows[i]["TenHinhThucThanhToan"].ToString(); return((object)httt); }
protected void LayDSHTTT() { HinhThucThanhToanDTO[] DsHTTT = htttBus.LayDanhSachHTTT(); XL_THE Kq = new XL_THE("DANH_SACH"); for (int i = 0; i < DsHTTT.Length; i++) { XL_THE Kq1 = new XL_THE("HinhThucThanhToan"); HinhThucThanhToanDTO HTTT = DsHTTT[i]; XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("MaHinhThucThanhToan", HTTT.Mahinh_thuc_tt.ToString()); Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); Thuoc_tinh = new XL_THUOC_TINH("TenHinhThucThanhToan", HTTT.Ten_hinh_thuc_tt); Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); Kq.Danh_sach_the.Add(Kq1); } XL_CHUOI.XuatXML(Response, Kq.Chuoi()); }