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");
}
}
}
}
