protected void Page_Load(object sender, EventArgs e)
{
if (Session["userID"] == null)
{
Response.Redirect("ADLogin.aspx", true);
}
if (!IsPostBack)
{
#region 設定餐點類型
Category.Items.Add(new ListItem("不拘", "不拘"));
Category.Items.Add(new ListItem("中餐", "0"));
Category.Items.Add(new ListItem("點心", "1"));
Category.Items.Add(new ListItem("飲料", "2"));
#endregion
#region 設定素食選項
IsVegetarianism.Items.Add(new ListItem("不拘", "不拘"));
IsVegetarianism.Items.Add(new ListItem("否", "false"));
IsVegetarianism.Items.Add(new ListItem("是", "true"));
#endregion
#region 設定部門別
DepartMent.Items.Add(new ListItem("不拘", "不拘"));
using (SqlConnection conn = new SqlConnection(DBTools.ConnectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("SELECT * FROM Department", conn))
{
using (SqlDataReader dr = cmd.ExecuteReader())
{
//while (dr.Read())
// DepartMent.Items.Add(new ListItem(dr.GetString(1), dr.GetString(1)));
DepartMent.DataTextField = "DepartmentName";
DepartMent.DataValueField = "DepartmentName";
DepartMent.DataSource = dr;
DepartMent.DataBind();
}
cmd.Cancel();
}
}
#endregion
#region 查詢菜單內容
if (!string.IsNullOrWhiteSpace(Request["ShopName"]))
{
QueryString.Add("ShopName", Request["ShopName"]);
ShopName.Text = Request["ShopName"];
}
if (!string.IsNullOrWhiteSpace(Request["Category"]))
{
QueryString.Add("Category", Request["Category"]);
Category.Items.FindByValue(Request["Category"]).Selected = true;
}
if (!string.IsNullOrWhiteSpace(Request["IsVegetarianism"]) && (Request["IsVegetarianism"].Equals("是") || Request["IsVegetarianism"].Equals("否")))
{
QueryString.Add("IsVegetarianism", Request["IsVegetarianism"]);
IsVegetarianism.Items.FindByText(Request["IsVegetarianism"]).Selected = true;
}
if (!string.IsNullOrWhiteSpace(Request["Department"]))
{
QueryString.Add("Department", Request["Department"]);
DepartMent.Items.FindByText(Request["Department"]).Selected = true;
}
if (!string.IsNullOrWhiteSpace(Request["Creator"]))
{
QueryString.Add("Creator", Request["Creator"]);
Creator.Text = Request["Creator"];
}
int PageNumber;
if (string.IsNullOrWhiteSpace(Request["Page"]) || !int.TryParse(Request["Page"], out PageNumber))
{
PageNumber = 1;
}
ucPagination.CPage = PageNumber;
Query(PageNumber);
#endregion
}
}
