protected void Page_Load(object sender, EventArgs e) { ketnoi kn = new ketnoi(); ListViewThuCungDuc.DataSource = kn.laybang("Select top 10 * from tblThuCung where bGioiTinh = 1 order by iID desc"); ListViewThuCungDuc.DataBind(); ListViewThuCungCai.DataSource = kn.laybang("Select top 10 * from tblThuCung where bGioiTinh = 0 order by iID desc"); ListViewThuCungCai.DataBind(); }
private void LayThuCungTheoDieuKien(string type, string min, string max) { if (type == null) { if (min != null) { object[] para = new object[] { 0, min, max }; List <string> paraName = new List <string> { "@bGioiTinh", "@min", "@max" }; using (DataTable dt = kn.ExecuteQuery("GetThuCung", para, paraName)) { if (dt != null && dt.Rows.Count > 0) { ListViewThuCungCai.DataSource = dt; ListViewThuCungCai.DataBind(); } else { ThongBao.Style.Remove("display"); } } } else if (min == null && max != null) { Response.Redirect("Cai.aspx"); } else { ListViewThuCungCai.DataSource = kn.ExecuteQuery("GetThuCung", new object[] { 0 }, new List <string> { "@bGioiTinh" }); ListViewThuCungCai.DataBind(); } } else { using (DataTable dt = kn.ExecuteQuery("GetThuCung", new object[] { 0, type }, new List <string> { "@bGioiTinh", "@iMaLoai" })) { if (dt != null) { Response.Write("<title>" + kn.lay1giatri("Select sTenLoaiThuCung from tblLoaiThuCung where iMaLoai='" + type + "'") + " - ThuCung.VN</title>"); ListViewThuCungCai.DataSource = dt; ListViewThuCungCai.DataBind(); } else { Response.Redirect("Cai.aspx"); } } } }