public List <clsTinhQuanHuyen_DTO> LayDanhSachQuanHuyen(string MaTinh)
{
SqlConnection conn = ThaoTacDuLieu.TaoVaMoKetNoi();
string sql = string.Format("SELECT MAQH,TENQH FROM TINHQUANHUYEN WHERE MATINH = '{0}' GROUP BY MAQH,TENQH", MaTinh);
SqlCommand cmd = ThaoTacDuLieu.TaoDoiTuongTruyVan(sql, conn);
SqlDataReader dr = cmd.ExecuteReader();
List <clsTinhQuanHuyen_DTO> lsQuanHuyen = new List <clsTinhQuanHuyen_DTO>();
while (dr.Read())
{
clsTinhQuanHuyen_DTO QuanHuyen = new clsTinhQuanHuyen_DTO();
if (!dr.IsDBNull(0))
{
QuanHuyen.MAQH = dr.GetString(0);
}
if (!dr.IsDBNull(1))
{
QuanHuyen.TENQH = dr.GetString(1);
}
lsQuanHuyen.Add(QuanHuyen);
}
ThaoTacDuLieu.DongKetNoi(conn);
return(lsQuanHuyen);
}
public List <clsTinhQuanHuyen_DTO> LayDanhSachTinhThanh()
{
SqlConnection conn = ThaoTacDuLieu.TaoVaMoKetNoi();
string sql = "SELECT MATINH,TENTINH FROM TINHQUANHUYEN GROUP BY MATINH,TENTINH";
SqlCommand cmd = ThaoTacDuLieu.TaoDoiTuongTruyVan(sql, conn);
SqlDataReader dr = cmd.ExecuteReader();
List <clsTinhQuanHuyen_DTO> lsTinhThanh = new List <clsTinhQuanHuyen_DTO>();
while (dr.Read())
{
clsTinhQuanHuyen_DTO TinhThanh = new clsTinhQuanHuyen_DTO();
if (!dr.IsDBNull(0))
{
TinhThanh.MATINH = dr.GetString(0);
}
if (!dr.IsDBNull(1))
{
TinhThanh.TENTINH = dr.GetString(1);
}
lsTinhThanh.Add(TinhThanh);
}
ThaoTacDuLieu.DongKetNoi(conn);
return(lsTinhThanh);
}
