当前文件路径：StaffSalaryManage/CheckManage/MonthCheckForm.aspx 
1
<%...--文件名:MonthCheckForm.aspx--%>
2<%...@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="MonthCheckForm.aspx.cs" Inherits="CheckManage_MonthCheckForm" Title="当前位置：考勤管理->月度部门考勤" %>
3
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
4 <table style="width: 556px; height: 161px">
5 <tr>
6 <td align="left" style="font-size: 0.8em; width: 2232px; font-family: 宋体; height: 16px;
7 background-color: teal">
8 <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MyPersonnelDBConnectionString %>"
9 SelectCommand="SELECT * FROM [公司部门]"></asp:SqlDataSource>
10 考勤年份：<asp:DropDownList ID="DropDownList2" runat="server">
11 <asp:ListItem>2006</asp:ListItem>
12 <asp:ListItem>2007</asp:ListItem>
13 <asp:ListItem>2008</asp:ListItem>
14 <asp:ListItem>2009</asp:ListItem>
15 <asp:ListItem>2010</asp:ListItem>
16 <asp:ListItem>2011</asp:ListItem>
17 <asp:ListItem>2012</asp:ListItem>
18 <asp:ListItem>2013</asp:ListItem>
19 <asp:ListItem>2014</asp:ListItem>
20 <asp:ListItem>2015</asp:ListItem>
21 <asp:ListItem>2016</asp:ListItem>
22 <asp:ListItem>2017</asp:ListItem>
23 <asp:ListItem>2018</asp:ListItem>
24 <asp:ListItem>2019</asp:ListItem>
25 <asp:ListItem>2020</asp:ListItem>
26 </asp:DropDownList>
27 考勤月份：<asp:DropDownList ID="DropDownList3" runat="server">
28 <asp:ListItem>1</asp:ListItem>
29 <asp:ListItem>2</asp:ListItem>
30 <asp:ListItem>3</asp:ListItem>
31 <asp:ListItem>4</asp:ListItem>
32 <asp:ListItem>5</asp:ListItem>
33 <asp:ListItem>6</asp:ListItem>
34 <asp:ListItem>7</asp:ListItem>
35 <asp:ListItem>8</asp:ListItem>
36 <asp:ListItem>9</asp:ListItem>
37 <asp:ListItem>10</asp:ListItem>
38 <asp:ListItem>11</asp:ListItem>
39 <asp:ListItem>12</asp:ListItem>
40 </asp:DropDownList>
41 考勤部门:<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource1"
42 DataTextField="部门名称" DataValueField="部门名称" Width="80px">
43 </asp:DropDownList>
44 <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="查询" Width="80px" />
45 <asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="打印" Width="80px" />
46 </td>
47 </tr>
48 <tr>
49 <td align="center" style="font-size: 0.8em; width: 2232px; font-family: 宋体; height: 27px;
50 background-color: mediumturquoise">
51 考勤符号：出勤[/] 迟到[>] 早退[<] 产假[√] 事假[#] 病假[+] 婚假[△] 旷工[×]</td>
52 </tr>
53 <tr>
54 <td style="width: 2232px; height: 100px; background-color: gainsboro">
55 <asp:Panel ID="Panel1" runat="server" Height="220px" ScrollBars="Auto" Width="553px">
56 <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:MyPersonnelDBConnectionString %>"
57 SelectCommand="SELECT * FROM [考勤记录] WHERE (([考勤年份] = @考勤年份) AND ([考勤月份] = @考勤月份) AND (员工编号 IN (SELECT 员工编号 FROM 在职员工视图 WHERE (所属部门 LIKE @所属部门))))"
58 UpdateCommand="UPDATE [考勤记录] SET [C1] = @C1, [C2] = @C2, [C3] = @C3, [C4] = @C4, [C5] = @C5, [C6] = @C6, [C7] = @C7, [C8] = @C8, [C9] = @C9, [C10] = @C10, [C11] = @C11, [C12] = @C12, [C13] = @C13, [C14] = @C14, [C15] = @C15, [C16] = @C16, [C17] = @C17, [C18] = @C18, [C19] = @C19, [C20] = @C20, [C21] = @C21, [C22] = @C22, [C23] = @C23, [C24] = @C24, [C25] = @C25, [C26] = @C26, [C27] = @C27, [C28] = @C28, [C29] = @C29, [C30] = @C30, [C31] = @C31 WHERE [自编号] = @自编号">
59 <DeleteParameters>
60 <asp:Parameter Name="自编号" Type="Int32" />
61 </DeleteParameters>
62 <UpdateParameters>
63 <asp:Parameter Name="C1" Type="String" />
64 <asp:Parameter Name="C2" Type="String" />
65 <asp:Parameter Name="C3" Type="String" />
66 <asp:Parameter Name="C4" Type="String" />
67 <asp:Parameter Name="C5" Type="String" />
68 <asp:Parameter Name="C6" Type="String" />
69 <asp:Parameter Name="C7" Type="String" />
70 <asp:Parameter Name="C8" Type="String" />
71 <asp:Parameter Name="C9" Type="String" />
72 <asp:Parameter Name="C10" Type="String" />
73 <asp:Parameter Name="C11" Type="String" />
74 <asp:Parameter Name="C12" Type="String" />
75 <asp:Parameter Name="C13" Type="String" />
76 <asp:Parameter Name="C14" Type="String" />
77 <asp:Parameter Name="C15" Type="String" />
78 <asp:Parameter Name="C16" Type="String" />
79 <asp:Parameter Name="C17" Type="String" />
80 <asp:Parameter Name="C18" Type="String" />
81 <asp:Parameter Name="C19" Type="String" />
82 <asp:Parameter Name="C20" Type="String" />
83 <asp:Parameter Name="C21" Type="String" />
84 <asp:Parameter Name="C22" Type="String" />
85 <asp:Parameter Name="C23" Type="String" />
86 <asp:Parameter Name="C24" Type="String" />
87 <asp:Parameter Name="C25" Type="String" />
88 <asp:Parameter Name="C26" Type="String" />
89 <asp:Parameter Name="C27" Type="String" />
90 <asp:Parameter Name="C28" Type="String" />
91 <asp:Parameter Name="C29" Type="String" />
92 <asp:Parameter Name="C30" Type="String" />
93 <asp:Parameter Name="C31" Type="String" />
94 <asp:Parameter Name="自编号" Type="Int32" />
95 </UpdateParameters>
96 <SelectParameters>
97 <asp:ControlParameter ControlID="DropDownList2" Name="考勤年份" PropertyName="SelectedValue"
98 Type="Int32" />
99 <asp:ControlParameter ControlID="DropDownList3" Name="考勤月份" PropertyName="SelectedValue"
100 Type="Int32" />
101 <asp:ControlParameter ControlID="DropDownList1" Name="所属部门" PropertyName="SelectedValue"
102 Type="String" />
103 </SelectParameters>
104 </asp:SqlDataSource>
105 <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="自编号"
106 DataSourceID="SqlDataSource2" Font-Names="宋体" Font-Size="Small" Width="1600px">
107 <Columns>
108 <asp:CommandField ShowEditButton="True" ButtonType="Button" HeaderText="编辑" />
109 <asp:BoundField DataField="自编号" HeaderText="自编号" InsertVisible="False" ReadOnly="True"
110 SortExpression="自编号" Visible="False" />
111 <asp:BoundField DataField="员工编号" HeaderText="员工编号" SortExpression="员工编号" Visible="False" />
112 <asp:BoundField DataField="员工姓名" HeaderText="员工姓名" ReadOnly="True" SortExpression="员工姓名" />
113 <asp:TemplateField HeaderText="C1" SortExpression="C1">
114 <EditItemTemplate>
115 <asp:DropDownList ID="DropDownList4" runat="server" AppendDataBoundItems="True" DataSourceID="SqlDataSource2"
116 DataTextField="C1" DataValueField="C1" SelectedValue='<%# Bind("C1") %>'>
117 <asp:ListItem Selected="True">/</asp:ListItem>
118 <asp:ListItem>></asp:ListItem>
119 <asp:ListItem><</asp:ListItem>
120 <asp:ListItem>√</asp:ListItem>
121 <asp:ListItem>#</asp:ListItem>
122 <asp:ListItem>+</asp:ListItem>
123 <asp:ListItem>△</asp:ListItem>
124 <asp:ListItem>×</asp:ListItem>
125 </asp:DropDownList>
126 </EditItemTemplate>
127 <ItemTemplate>
128 <asp:Label ID="Label1" runat="server" Text='<%# Bind("C1") %>'></asp:Label>
129 </ItemTemplate>
130 </asp:TemplateField>
131 <asp:TemplateField HeaderText="C2" SortExpression="C2">
132 <EditItemTemplate>
133 <asp:DropDownList ID="DropDownList5" runat="server" AppendDataBoundItems="True" DataSourceID="SqlDataSource2"
134 DataTextField="C2" DataValueField="C2" SelectedValue='<%# Bind("C2") %>'>
135 <asp:ListItem Selected="True">/</asp:ListItem>
136 <asp:ListItem>></asp:ListItem>
137 <asp:ListItem><</asp:ListItem>
138 <asp:ListItem>√</asp:ListItem>
139 <asp:ListItem>#</asp:ListItem>
140 <asp:ListItem>+</asp:ListItem>
141 <asp:ListItem>△</asp:ListItem>
142 <asp:ListItem>×</asp:ListItem>
143 </asp:DropDownList>
144 </EditItemTemplate>
145 <ItemTemplate>
146 <asp:Label ID="Label2" runat="server" Text='<%# Bind("C2") %>'></asp:Label>
147 </ItemTemplate>
148 </asp:TemplateField>
149 <asp:TemplateField HeaderText="C3" SortExpression="C3">
150 <EditItemTemplate>
151 <asp:DropDownList ID="DropDownList6" runat="server" AppendDataBoundItems="True" DataSourceID="SqlDataSource2"
152 DataTextField="C3" DataValueField="C3" SelectedValue='<%# Bind("C3") %>'>
153 <asp:ListItem Selected="True">/</asp:ListItem>
154 <asp:ListItem>></asp:ListItem>
155 <asp:ListItem><</asp:ListItem>
156 <asp:ListItem>√</asp:ListItem>
157 <asp:ListItem>#</asp:ListItem>
158 <asp:ListItem>+</asp:ListItem>
159 <asp:ListItem>△</asp:ListItem>
160 <asp:ListItem>×</asp:ListItem>
161 </asp:DropDownList>
162 </EditItemTemplate>
163 <ItemTemplate>
164 <asp:Label ID="Label2" runat="server" Text='<%# Bind("C3") %>'></asp:Label>
165 </ItemTemplate>
166 </asp:TemplateField>
167 <asp:TemplateField HeaderText="C4" SortExpression="C4">
168 <EditItemTemplate>
169 <asp:DropDownList ID="DropDownList7" runat="server" AppendDataBoundItems="True" DataSourceID="SqlDataSource2"
170 DataTextField="C4" DataValueField="C4" SelectedValue='<%# Bind("C4") %>'>
171 <asp:ListItem Selected="True">/</asp:ListItem>
172 <asp:ListItem>></asp:ListItem>
173 <asp:ListItem><</asp:ListItem>
174 <asp:ListItem>√</asp:ListItem>
175 <asp:ListItem>#</asp:ListItem>
176 <asp:ListItem>+</asp:ListItem>
177 <asp:ListItem>△</asp:ListItem>
178 <asp:ListItem>×</asp:ListItem>
179 </asp:DropDownList>
180 </EditItemTemplate>
181 <ItemTemplate>
182 <asp:Label ID="Label2" runat="server" Text='<%# Bind("C4") %>'></asp:Label>
183 </ItemTemplate>
184 </asp:TemplateField>
185 <asp:TemplateField HeaderText="C5" SortExpression="C5">
186 <EditItemTemplate>
187 <asp:DropDownList ID="DropDownList8" runat="server" AppendDataBoundItems="True" DataSourceID="SqlDataSource2"
188 DataTextField="C5" DataValueField="C5" SelectedValue='<%# Bind("C5") %>'>
189 <asp:ListItem Selected="True">/</asp:ListItem>
190 <asp:ListItem>></asp:ListItem>
191 <asp:ListItem><</asp:ListItem>
192 <asp:ListItem>√</asp:ListItem>
193 <asp:ListItem>#</asp:ListItem>
194 <asp:ListItem>+</asp:ListItem>
195 <asp:ListItem>△</asp:ListItem>
196 <asp:ListItem>×</asp:ListItem>
197 </asp:DropDownList>
198 </EditItemTemplate>
199 <ItemTemplate>
200 <asp:Label ID="Label2" runat="server" Text='<%# Bind("C5") %>'></asp:Label>
201 </ItemTemplate>
202 </asp:TemplateField>
203 <asp:TemplateField HeaderText="C6" SortExpression="C6">
204 <EditItemTemplate>
205 <asp:DropDownList ID="DropDownList9" runat="server" AppendDataBoundItems="True" DataSourceID="SqlDataSource2"
206 DataTextField="C6" DataValueField="C6" SelectedValue='<%# Bind("C6") %>'>
207 <asp:ListItem Selected="True">/</asp:ListItem>
208 <asp:ListItem>></asp:ListItem>
209 <asp:ListItem><</asp:ListItem>
210 <asp:ListItem>√</asp:ListItem>
211 <asp:ListItem>#</asp:ListItem>
212 <asp:ListItem>+</asp:ListItem>
213 <asp:ListItem>△</asp:ListItem>
214 <asp:ListItem>×</asp:ListItem>
215 </asp:DropDownList>
216 </EditItemTemplate>
217 <ItemTemplate>
218 <asp:Label ID="Label2" runat="server" Text='<%# Bind("C6") %>'></asp:Label>
219 </ItemTemplate>
220 </asp:TemplateField>
221 <asp:TemplateField HeaderText="C7" SortExpression="C7">
222 <EditItemTemplate>
223 <asp:DropDownList ID="DropDownList10" runat="server" AppendDataBoundItems="True" DataSourceID="SqlDataSource2"
224 DataTextField="C7" DataValueField="C7" SelectedValue='<%# Bind("C7") %>'>
225 <asp:ListItem Selected="True">/</asp:ListItem>
226 <asp:ListItem>></asp:ListItem>
227 <asp:ListItem><</asp:ListItem>
228 <asp:ListItem>√</asp:ListItem>
229 <asp:ListItem>#</asp:ListItem>
230 <asp:ListItem>+</asp:ListItem>
231 <asp:ListItem>△</asp:ListItem>
232 <asp:ListItem>×</asp:ListItem>
233
