API tools faq
paste
Advertisement
SquirrelInBox

Untitled

SquirrelInBox
May 17th, 2016
75
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 19.82 KB | None | 0 0
raw download clone embed print report
  1. <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Details.aspx.cs" Inherits="Details" %>
  2.  
  3. <!DOCTYPE html>
  4.  
  5. <html xmlns="http://www.w3.org/1999/xhtml">
  6. <head runat="server">
  7. <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
  8. <title></title>
  9. </head>
  10. <body>
  11. <form id="form1" runat="server">
  12. <div>
  13. <asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/Abit.aspx">Назад</asp:HyperLink><br />
  14. <asp:Label ID="ErrorLabel" runat="server" Text=" " Font-Bold="True" ForeColor="Red"></asp:Label>
  15.  
  16. <asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:abitConnectionString2 %>"
  17. SelectCommand="SELECT [name], [cod] FROM [exams$]">
  18. </asp:SqlDataSource>
  19. <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:abitConnectionString2 %>"
  20. SelectCommand="SELECT [name], [cod] FROM [residence$]">
  21. </asp:SqlDataSource>
  22. <asp:SqlDataSource ID="SqlDataSource2" runat="server"></asp:SqlDataSource>
  23. <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:abitConnectionString2 %>"
  24. SelectCommand="SELECT [family], a.name name, [suname], [number], [vdate], [pol],
  25. FORMAT([birthday], 'd') birthday,
  26. FLOOR(DATEDIFF(day, birthday, GETDATE())/365.25) years,
  27. [year_end], [school], [att_or_dip], [sattestat], [nattestat], [spusport], [npusport], [sv_o_puspo], r.name state, [adres],
  28. e1.name exname1, e2.name exname2, e3.name exname3, e4.name exname4, e5.name exname5, e6.name exname6, e7.name exname7,
  29. [note1], [note2], [note3], [note4], [note5], [note6], [note7],
  30. [note1] + [note2] + [note3] + [note4] + [note5] + [note6] + [note7] sum
  31. FROM [abit$] a, [exams$] e1, [exams$] e2, [exams$] e3, [exams$] e4, [exams$] e5, [exams$] e6, [exams$] e7, [residence$] r
  32. WHERE ([number] = @number and [vstup1] = e1.cod and [vstup2] = e2.cod and [vstup3] = e3.cod and [vstup4] = e4.cod and
  33. [vstup5] = e5.cod and [vstup6] = e6.cod and [vstup7] = e7.cod and [state] = r.cod)"
  34. UpdateCommand="UPDATE abit$ SET
  35. State = (SELECT Cod FROM residence$ WHERE name=@State),
  36. vstup1 = (SELECT Cod FROM exams$ WHERE name=@exname1),
  37. vstup2 = (SELECT Cod FROM exams$ WHERE name=@exname2),
  38. vstup3 = (SELECT Cod FROM exams$ WHERE name=@exname3),
  39. vstup4 = (SELECT Cod FROM exams$ WHERE name=@exname4),
  40. vstup5 = (SELECT Cod FROM exams$ WHERE name=@exname5),
  41. vstup6 = (SELECT Cod FROM exams$ WHERE name=@exname6),
  42. vstup7 = (SELECT Cod FROM exams$ WHERE name=@exname7),
  43. pol = @pol,
  44. att_or_dip = @att_or_dip,
  45. school = @school,
  46. note1 = @note1,
  47. note2 = @note2,
  48. note3 = @note3,
  49. note4 = @note4,
  50. note5 = @note5,
  51. note6 = @note6,
  52. note7 = @note7,
  53. birthday=@birthday,
  54. family = @family,
  55. name = @name,
  56. suname = @suname,
  57. year_end = @year_end,
  58. [sattestat] = @sattestat,
  59. [nattestat] = @nattestat,
  60. [spusport] = @spusport,
  61. [npusport] = @npusport,
  62. [sv_o_puspo] = @sv_o_puspo,
  63. adres = @adres
  64.  
  65. WHERE (Number = @number)"
  66. >
  67. <UpdateParameters>
  68. <asp:QueryStringParameter Name="number" QueryStringField="number" Type="Double" />
  69. <asp:formparameter name="State" formfield="DropDownList1" />
  70. <asp:formparameter name="exname1" formfield="ListExams1"/>
  71. <asp:formparameter name="exname2" formfield="ListExams2" />
  72. <asp:formparameter name="exname3" formfield="ListExams3" />
  73. <asp:formparameter name="exname4" formfield="ListExams4" />
  74. <asp:formparameter name="exname5" formfield="ListExams5" />
  75. <asp:formparameter name="exname6" formfield="ListExams6" />
  76. <asp:formparameter name="exname7" formfield="ListExams7" />
  77. <asp:formparameter name="pol" formfield="ListPol" />
  78. <asp:formparameter name="att_or_dip" formfield="ListAoD" />
  79. <asp:formparameter name="school" formfield="BoxSchool" />
  80. </UpdateParameters>
  81. <SelectParameters>
  82. <asp:QueryStringParameter Name="number" QueryStringField="number" Type="Double" />
  83. </SelectParameters>
  84. </asp:SqlDataSource>
  85.  
  86.  
  87. <asp:DetailsView ID="DetailsView2" runat="server" OnItemUpdating="DetailsView2_ItemUpdating" OnItemUpdated="DetailsView2_ItemUpdated" AutoGenerateRows="False" DefaultMode="Edit" DataSourceID="SqlDataSource1" Height="16px" Width="973px" BackColor="White" BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px" CellPadding="3" GridLines="Horizontal">
  88. <AlternatingRowStyle BackColor="#F7F7F7" />
  89. <EditRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" />
  90. <Fields>
  91. <asp:BoundField DataField="family" HeaderText="Фамилия" SortExpression="family" />
  92. <asp:BoundField DataField="name" HeaderText="Имя" SortExpression="name" />
  93. <asp:BoundField DataField="suname" HeaderText="Отчество" SortExpression="suname" />
  94. <asp:BoundField DataField="number" HeaderText="Номер" SortExpression="number" ReadOnly="True" />
  95. <asp:BoundField DataField="vdate" HeaderText="Дата заполнения" SortExpression="vdate" ReadOnly="True" />
  96. <asp:TemplateField HeaderText="Пол" SortExpression="pol">
  97. <EditItemTemplate>
  98. <asp:DropDownList ID="ListPol" runat="server" Text='<%# Bind("pol") %>'>
  99. <asp:ListItem Value="1">Мужской</asp:ListItem>
  100. <asp:ListItem Value="2">Женский</asp:ListItem>
  101. <asp:ListItem Value="0">-</asp:ListItem>
  102.  
  103. </asp:DropDownList>
  104. </EditItemTemplate>
  105. <InsertItemTemplate>
  106. <asp:TextBox ID="TextBox9" runat="server" Text='<%# Bind("pol") %>'></asp:TextBox>
  107. </InsertItemTemplate>
  108. <ItemTemplate>
  109. <asp:Label ID="Label9" runat="server" Text='<%# Bind("pol") %>'></asp:Label>
  110. </ItemTemplate>
  111. </asp:TemplateField>
  112. <asp:TemplateField HeaderText="День рождения" SortExpression="birthday">
  113. <EditItemTemplate>
  114. <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("birthday") %>' ValidateRequestMode="Enabled">
  115. </asp:TextBox>
  116. </EditItemTemplate>
  117. <InsertItemTemplate>
  118. <asp:TextBox ID="TextBox13" runat="server" Text='<%# Bind("birthday") %>'></asp:TextBox>
  119. </InsertItemTemplate>
  120. <ItemTemplate>
  121. <asp:Label ID="Label13" runat="server" Text='<%# Bind("birthday") %>'></asp:Label>
  122. </ItemTemplate>
  123. </asp:TemplateField>
  124. <asp:BoundField DataField="years" HeaderText="Возраст" SortExpression="years" ReadOnly="True" />
  125.  
  126. <asp:BoundField DataField="year_end" HeaderText="год окончания" SortExpression="year_end" />
  127. <asp:TemplateField HeaderText="учебное учреждение" SortExpression="school">
  128. <EditItemTemplate>
  129. <asp:TextBox ID="BoxSchool" runat="server" Height="16px" Text='<%# Bind("school") %>' Width="790px"></asp:TextBox>
  130. </EditItemTemplate>
  131. <InsertItemTemplate>
  132. <asp:TextBox ID="TextBox12" runat="server" Text='<%# Bind("school") %>'></asp:TextBox>
  133. </InsertItemTemplate>
  134. <ItemTemplate>
  135. <asp:Label ID="Label12" runat="server" Text='<%# Bind("school") %>'></asp:Label>
  136. </ItemTemplate>
  137. </asp:TemplateField>
  138. <asp:TemplateField HeaderText="аттестат или диплом" SortExpression="att_or_dip">
  139. <EditItemTemplate>
  140. <asp:DropDownList ID="ListAoD" runat="server" Text='<%# Bind("att_or_dip") %>'>
  141. <asp:ListItem Value="1">Аттестат</asp:ListItem>
  142. <asp:ListItem Value="2">Диплом</asp:ListItem>
  143. <asp:ListItem Value="0">-</asp:ListItem>
  144. </asp:DropDownList>
  145. </EditItemTemplate>
  146. <InsertItemTemplate>
  147. <asp:TextBox ID="TextBox10" runat="server" Text='<%# Bind("att_or_dip") %>'></asp:TextBox>
  148. </InsertItemTemplate>
  149. <ItemTemplate>
  150. <asp:Label ID="Label10" runat="server" Text='<%# Bind("att_or_dip") %>'></asp:Label>
  151. </ItemTemplate>
  152. </asp:TemplateField>
  153. <asp:BoundField DataField="sattestat" HeaderText="серия документа об образовании" SortExpression="sattestat" />
  154. <asp:BoundField DataField="nattestat" HeaderText="номер документа об образовании" SortExpression="nattestat" />
  155. <asp:BoundField DataField="spusport" HeaderText="серия паспорта" SortExpression="spusport" />
  156. <asp:BoundField DataField="npusport" HeaderText="номер паспорта" SortExpression="npusport" />
  157. <asp:BoundField DataField="sv_o_puspo" HeaderText="дата выдачи паспорта" SortExpression="sv_o_puspo" />
  158. <asp:TemplateField HeaderText="регион" SortExpression="state">
  159. <EditItemTemplate>
  160. <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="False" DataSourceID="SqlDataSource3"
  161. DataTextField="name" DataValueField="name" Text='<%# Bind("state") %>'>
  162. </asp:DropDownList>
  163. </EditItemTemplate>
  164. <InsertItemTemplate>
  165. <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("state") %>'></asp:TextBox>
  166. </InsertItemTemplate>
  167. <ItemTemplate>
  168. <asp:Label ID="Label1" runat="server" Text='<%# Bind("state") %>'></asp:Label>
  169. </ItemTemplate>
  170. </asp:TemplateField>
  171.  
  172. <asp:TemplateField HeaderText="адрес" SortExpression="adres">
  173. <EditItemTemplate>
  174. <asp:TextBox ID="TextBox1" runat="server" Height="16px" Text='<%# Bind("adres") %>' Width="790px"></asp:TextBox>
  175. </EditItemTemplate>
  176. <InsertItemTemplate>
  177. <asp:TextBox ID="TextBox11" runat="server" Text='<%# Bind("adres") %>'></asp:TextBox>
  178. </InsertItemTemplate>
  179. <ItemTemplate>
  180. <asp:Label ID="Label11" runat="server" Text='<%# Bind("adres") %>'></asp:Label>
  181. </ItemTemplate>
  182. </asp:TemplateField>
  183. <asp:TemplateField HeaderText="экзамен 1" SortExpression="exname1">
  184. <EditItemTemplate>
  185. <asp:DropDownList ID="ListExams1" runat="server" DataSourceID="SqlDataSource4" DataTextField="name"
  186. DataValueField="name" AutoPostBack="False" Text='<%# Bind("exname1") %>'>
  187. </asp:DropDownList>
  188. </EditItemTemplate>
  189. <InsertItemTemplate>
  190. <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("exname1") %>'></asp:TextBox>
  191. </InsertItemTemplate>
  192. <ItemTemplate>
  193. <asp:Label ID="Label2" runat="server" Text='<%# Bind("exname1") %>'></asp:Label>
  194. </ItemTemplate>
  195. </asp:TemplateField>
  196. <asp:BoundField DataField="note1" HeaderText="баллы 1" SortExpression="note1" />
  197. <asp:TemplateField HeaderText="экзамен 2" SortExpression="vstup2">
  198. <EditItemTemplate>
  199. <asp:DropDownList ID="ListExams2" runat="server" DataSourceID="SqlDataSource4" DataTextField="name"
  200. DataValueField="name" Text='<%# Bind("exname2") %>'>
  201. </asp:DropDownList>
  202. </EditItemTemplate>
  203. <InsertItemTemplate>
  204. <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("exname2") %>'></asp:TextBox>
  205. </InsertItemTemplate>
  206. <ItemTemplate>
  207. <asp:Label ID="Label3" runat="server" Text='<%# Bind("exname2") %>'></asp:Label>
  208. </ItemTemplate>
  209. </asp:TemplateField>
  210. <asp:BoundField DataField="note2" HeaderText="баллы 2" SortExpression="note2" />
  211.  
  212. <asp:TemplateField HeaderText="экзамен 3" SortExpression="vstup3">
  213. <EditItemTemplate>
  214. <asp:DropDownList ID="ListExams3" runat="server" DataSourceID="SqlDataSource4" DataTextField="name"
  215. DataValueField="name" Text='<%# Bind("exname3") %>'>
  216. </asp:DropDownList>
  217. </EditItemTemplate>
  218. <InsertItemTemplate>
  219. <asp:TextBox ID="TextBox4" runat="server" Text='<%# Bind("exname3") %>'></asp:TextBox>
  220. </InsertItemTemplate>
  221. <ItemTemplate>
  222. <asp:Label ID="Label4" runat="server" Text='<%# Bind("exname3") %>'></asp:Label>
  223. </ItemTemplate>
  224. </asp:TemplateField>
  225. <asp:BoundField DataField="note3" HeaderText="баллы 3" SortExpression="note3" />
  226. <asp:TemplateField HeaderText="экзамен 4" SortExpression="vstup4">
  227. <EditItemTemplate>
  228. <asp:DropDownList ID="ListExams4" runat="server" DataSourceID="SqlDataSource4" DataTextField="name"
  229. DataValueField="name" Text='<%# Bind("exname4") %>'>
  230. </asp:DropDownList>
  231. </EditItemTemplate>
  232. <InsertItemTemplate>
  233. <asp:TextBox ID="TextBox5" runat="server" Text='<%# Bind("exname4") %>'></asp:TextBox>
  234. </InsertItemTemplate>
  235. <ItemTemplate>
  236. <asp:Label ID="Label5" runat="server" Text='<%# Bind("exname4") %>'></asp:Label>
  237. </ItemTemplate>
  238. </asp:TemplateField>
  239. <asp:BoundField DataField="note4" HeaderText="баллы 4" SortExpression="note4" />
  240.  
  241. <asp:TemplateField HeaderText="экзамен 5" SortExpression="vstup5">
  242. <EditItemTemplate>
  243. <asp:DropDownList ID="ListExams5" runat="server" DataSourceID="SqlDataSource4" DataTextField="name"
  244. DataValueField="name" Text='<%# Bind("exname5") %>'>
  245. </asp:DropDownList>
  246. </EditItemTemplate>
  247. <InsertItemTemplate>
  248. <asp:TextBox ID="TextBox6" runat="server" Text='<%# Bind("exname5") %>'></asp:TextBox>
  249. </InsertItemTemplate>
  250. <ItemTemplate>
  251. <asp:Label ID="Label6" runat="server" Text='<%# Bind("exname5") %>'></asp:Label>
  252. </ItemTemplate>
  253. </asp:TemplateField>
  254. <asp:BoundField DataField="note5" HeaderText="баллы 5" SortExpression="note5" />
  255. <asp:TemplateField HeaderText="экзамен 6" SortExpression="vstup6">
  256. <EditItemTemplate>
  257. <asp:DropDownList ID="ListExams6" runat="server" DataSourceID="SqlDataSource4" DataTextField="name"
  258. DataValueField="name" Text='<%# Bind("exname6") %>'>
  259. </asp:DropDownList>
  260. </EditItemTemplate>
  261. <InsertItemTemplate>
  262. <asp:TextBox ID="TextBox7" runat="server" Text='<%# Bind("exname6") %>'></asp:TextBox>
  263. </InsertItemTemplate>
  264. <ItemTemplate>
  265. <asp:Label ID="Label7" runat="server" Text='<%# Bind("exname6") %>'></asp:Label>
  266. </ItemTemplate>
  267. </asp:TemplateField>
  268. <asp:BoundField DataField="note6" HeaderText="баллы 6" SortExpression="note6" />
  269. <asp:TemplateField HeaderText="экзамен 7" SortExpression="vstup7">
  270. <EditItemTemplate>
  271. <asp:DropDownList ID="ListExams7" runat="server" DataSourceID="SqlDataSource4" DataTextField="name"
  272. DataValueField="name" Text='<%# Bind("exname7") %>'>
  273. </asp:DropDownList>
  274. </EditItemTemplate>
  275. <InsertItemTemplate>
  276. <asp:TextBox ID="TextBox8" runat="server" Text='<%# Bind("exname7") %>'></asp:TextBox>
  277. </InsertItemTemplate>
  278. <ItemTemplate>
  279. <asp:Label ID="Label8" runat="server" Text='<%# Bind("exname7") %>'></asp:Label>
  280. </ItemTemplate>
  281. </asp:TemplateField>
  282.  
  283. <asp:BoundField DataField="note7" HeaderText="баллы 7" SortExpression="note7" />
  284.  
  285. <asp:BoundField DataField="sum" HeaderText="Сумма баллов" SortExpression="sum" ReadOnly="True" />
  286.  
  287. <asp:CommandField ShowEditButton="True" />
  288.  
  289. </Fields>
  290. <FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" />
  291. <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" />
  292. <PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Right" />
  293. <RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />
  294. </asp:DetailsView>
  295. <asp:SqlDataSource ID="SqlDataSource5" runat="server" ConnectionString="<%$ ConnectionStrings:abitConnectionString2 %>" SelectCommand="SELECT [number], [family] FROM [abit$] WHERE ([number] = @number)">
  296. <SelectParameters>
  297. <asp:QueryStringParameter DefaultValue="0" Name="number" QueryStringField="number" Type="Double" />
  298. </SelectParameters>
  299. </asp:SqlDataSource>
  300.  
  301.  
  302. <br />
  303.  
  304.  
  305. </div>
  306. </form>
  307. </body>
  308. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!