<%@ Page Language="C#" Debug="true" %>
<%@ Import Namespace="System" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.SqlClient" %> <%@ Import Namespace="System.Configuration" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <script runat="server"> string conStr = ConfigurationManager.ConnectionStrings["SqlConn"].ConnectionString; DataSet ds = new DataSet(); public void Page_Load(object sender, EventArgs e) {
if (!Page.IsPostBack) { } showDetail(); } public void showDetail() { using (SqlConnection sqlConn = new SqlConnection(conStr)) { sqlConn.Open(); SqlCommand comm = new SqlCommand(); comm.Connection = sqlConn; comm.CommandType = CommandType.StoredProcedure; comm.CommandText = "N06_ALEX_DETAIL_QUERY_P"; SqlParameter sp1 = new SqlParameter("@dateF", SqlDbType.VarChar); if (Request["DateFrom"] == null) { sp1.Value = DateTime.Now.ToString("yyyy-MM-dd"); } else { sp1.Value = Request["DateFrom"].ToString(); }
SqlParameter sp2 = new SqlParameter("@dateT", SqlDbType.VarChar); if (Request["DateTo"] == null) { sp2.Value = DateTime.Now.AddDays(7).ToString("yyyy-MM-dd"); } else { sp2.Value = Request["DateTo"].ToString(); }
SqlParameter sp3 = new SqlParameter("@deptf", SqlDbType.VarChar); if (Request["DeptFrom"] == null) { sp3.Value = ""; } else { sp3.Value = Request["DeptFrom"].ToString(); }
SqlParameter sp4 = new SqlParameter("@deptt", SqlDbType.VarChar); if (Request["DeptTo"] == null) { sp4.Value = ""; } else { sp4.Value = Request["DeptTo"].ToString(); } comm.Parameters.Add(sp1); comm.Parameters.Add(sp2); comm.Parameters.Add(sp3); comm.Parameters.Add(sp4); SqlDataAdapter da = new SqlDataAdapter(comm); da.Fill(ds); gvDetail.DataSource = ds.Tables[0]; for (int i = 3; i < ds.Tables[0].Columns.Count; i++) { BoundField bd = new BoundField(); bd.HeaderText = ds.Tables[0].Columns[i].Caption; bd.DataField = ds.Tables[0].Columns[i].ToString(); if (bd.HeaderText == "UniqueID") { bd.Visible = false; } if (bd.HeaderText == "管理員更新信息") { bd.Visible = false; } bd.ItemStyle.HorizontalAlign = HorizontalAlign.Center; gvDetail.Columns.Insert(i, bd); } gvDetail.DataBind(); fDayDetail.Controls.Add(gvDetail); sqlConn.Close(); } } </script> <html xmlns="http://www.w3.org/1999/xhtml"> <head id="Head1" runat="server"> <title></title> <style type="text/css"> .bt { font-style: normal; font-weight: normal; font-size: 11px; font-family: Arial; padding: top 10px right 10px bottom 10px left 10px; margin: top 10px right 10px bottom 10px left 10px; } hr { 100%; background-color: #bfbfbf; } </style> </head> <body> <form id="fDayDetail" runat="server" class="bt"> <div> <asp:GridView runat="server" ID="gvDetail" AutoGenerateColumns="false" DataKeyNames="UniqueID" Width="660" AlternatingRowStyle-BackColor="0xF2, 0xF2, 0xF2" HeaderStyle-BackColor="192, 192, 216" HeaderStyle-Font-Bold="true" HeaderStyle-ForeColor="White"> <Columns> <asp:BoundField DataField="序號" HeaderText="序號" ItemStyle-HorizontalAlign="Center" /> <asp:BoundField DataField="設置部門" HeaderText="設置部門" ItemStyle-HorizontalAlign="Center" /> <asp:BoundField DataField="班別日期" HeaderText="班別日期" ItemStyle-HorizontalAlign="Center" /> <asp:TemplateField HeaderText="管理員更新"> <ItemTemplate> <a href="#" onclick="window.open('rpAdminupdateinfo.aspx?uniqueid=<%#Eval("uniqueID") %>','newwin','height=200,width=300,top=80,left=90,toolbar=no,menubar=no,scrollbars=no, resizable=yes,location=no, status=no')"> <%#Eval("管理員更新信息")%></a> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Eidt"> <ItemTemplate> <a href="#" onclick="window.open('rpAdminDetailEdit.aspx?uniqueid=<%#Eval("uniqueID") %>','newwin','height=320,width=400,top=70,left=80,toolbar=no,menubar=no,scrollbars=no, resizable=yes,location=no, status=no')"> 修改</a> </ItemTemplate> </asp:TemplateField> </Columns> </asp:GridView> </div> </form> </body> </html>