-
Notifications
You must be signed in to change notification settings - Fork 0
/
SearchFA.aspx.cs
94 lines (81 loc) · 2.45 KB
/
SearchFA.aspx.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
using System;
using System.Collections;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class SearchFA : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
BindRepeater();
}
protected string checkEmptyLink(object ob)
{
string typ = ob.ToString();
if (typ == "")
{
return "沒有資料可供下載";
}
else
{
return "<a href=\"" + typ + "\">檔案下載</a>";
}
}
protected void BindRepeater()
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["WY-FADBConnectionString"].ConnectionString.ToString());
SqlCommand cmd = new SqlCommand("SELECT * FROM ClassingFA where exists (SELECT ClassName FROM FA_Class where ClassName=@ClassName and FA_Class.Class_ID=ClassingFA.Class_ID)", con);
cmd.Parameters.AddWithValue("ClassName", DropDownList1.Text);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
DataTable dt = new DataTable();
SqlDataAdapter adp = new SqlDataAdapter(cmd);
adp.Fill(dt);
PagedDataSource pgitems = new PagedDataSource();
DataView dv = new DataView(dt);
pgitems.DataSource = dv;
pgitems.AllowPaging = true;
pgitems.PageSize = 10;
pgitems.CurrentPageIndex = PageNumber;
if (pgitems.PageCount > 1)
{
rptPaging.Visible = true;
ArrayList pages = new ArrayList();
for (int i = 0; i < pgitems.PageCount; i++)
pages.Add((i + 1).ToString());
rptPaging.DataSource = pages;
rptPaging.DataBind();
}
else
{
rptPaging.Visible = false;
}
rptResult.DataSource = pgitems;
rptResult.DataBind();
}
public int PageNumber
{
get
{
if (ViewState["PageNumber"] != null)
return Convert.ToInt32(ViewState["PageNumber"]);
else
return 0;
}
set
{
ViewState["PageNumber"] = value;
}
}
protected void rptPaging_ItemCommand(object source, RepeaterCommandEventArgs e)
{
PageNumber = Convert.ToInt32(e.CommandArgument) - 1;
BindRepeater();
}
}