コード例 #1
0
        private void BindList()
        {
            int           StudentID        = Convert.ToInt32(Request.QueryString["StudentID"]);
            string        connectionString = ConfigurationManager.ConnectionStrings["Assginment_03"].ConnectionString;
            SqlConnection conn             = new SqlConnection(connectionString);
            SqlCommand    comm             = new SqlCommand("SELECT * FROM Students where StudentID=@StudentID", conn);

            comm.Parameters.AddWithValue("StudentID", StudentID);
            try
            {
                conn.Open();
                SqlDataReader reader = comm.ExecuteReader();
                ViewStudent.DataSource = reader;
                ViewStudent.DataBind();
                reader.Close();
            }
            finally
            {
                conn.Close();
            }
        }
コード例 #2
0
        #pragma warning disable 1998
        public async override global::System.Threading.Tasks.Task ExecuteAsync()
        {
#line 1 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"

            ViewStudent desc                 = Model.desc;
            string      Contract             = desc.Contract ? "Бютжетник" : "Договорник";
            List <List <MonthReport> > skips = Model.skips;
            List <string> headers            = new List <string> {
                "Без причины",
                "По причине",
                "Итог"
            };
            List <string> fSem = new List <string> {
                "Сентябрь", "Октябрь", "Ноябрь", "Декабрь"
            };
            List <string> sSem = new List <string> {
                "Февраль", "Март", "Апрель", "Май", "Июнь"
            };

#line default
#line hidden
            BeginContext(469, 2, true);
            WriteLiteral("\r\n");
            EndContext();
            DefineSection("CSS", async() => {
                BeginContext(485, 371, true);
                WriteLiteral(@"
    <style>
        .refer{
            font-size: small;
            margin-left: 15px;
        }
        #sideBar{
            height: 1380px;
        }
        #content {
            width: 115%;
        }
        #content #nav {
            height: 40px;
        }
        #content #secondaryNav {
            height: 15px;
        }
    </style>
");
                EndContext();
            }
                          );
            BeginContext(859, 2, true);
            WriteLiteral("\r\n");
            EndContext();
            DefineSection("reportBlock", async() => {
                BeginContext(883, 266, true);
                WriteLiteral(@"
    <div id=""navR"" style=""float: right;background-size: 80% 80%;"">
        <a class=""waves-effect waves-teal btn-flat"" data-toggle=""modal"" data-target=""#studMethodsModal"" style=""background-image: url(/Img/System/Edit_icon-icons.com_55921.svg);""></a>
    </div>
");
                EndContext();
            }
                          );
            BeginContext(1152, 133, true);
            WriteLiteral("<div style=\"display: flex;\">\r\n        <div style=\"width: 15% ;border-right:1.5px solid black;padding-left:5px\">\r\n\r\n        <h6>Имя : ");
            EndContext();
            BeginContext(1286, 9, false);
#line 45 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
            Write(desc.Name);

#line default
#line hidden
            EndContext();
            BeginContext(1295, 40, true);
            WriteLiteral("<h6>\r\n        <p>Группа : \r\n            ");
            EndContext();
            BeginContext(1335, 88, false);
            __tagHelperExecutionContext = __tagHelperScopeManager.Begin("a", global::Microsoft.AspNetCore.Razor.TagHelpers.TagMode.StartTagAndEndTag, "fc89d4cb3912bf165b10717ffdc38e46e130f1d06475", async() => {
                BeginContext(1409, 10, false);
#line 47 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
                Write(desc.Group);

#line default
#line hidden
                EndContext();
            }
                                                                        );
            __Microsoft_AspNetCore_Mvc_TagHelpers_AnchorTagHelper = CreateTagHelper <global::Microsoft.AspNetCore.Mvc.TagHelpers.AnchorTagHelper>();
            __tagHelperExecutionContext.Add(__Microsoft_AspNetCore_Mvc_TagHelpers_AnchorTagHelper);
            __Microsoft_AspNetCore_Mvc_TagHelpers_AnchorTagHelper.Controller = (string)__tagHelperAttribute_0.Value;
            __tagHelperExecutionContext.AddTagHelperAttribute(__tagHelperAttribute_0);
            __Microsoft_AspNetCore_Mvc_TagHelpers_AnchorTagHelper.Action = (string)__tagHelperAttribute_1.Value;
            __tagHelperExecutionContext.AddTagHelperAttribute(__tagHelperAttribute_1);
            if (__Microsoft_AspNetCore_Mvc_TagHelpers_AnchorTagHelper.RouteValues == null)
            {
                throw new InvalidOperationException(InvalidTagHelperIndexerAssignment("asp-route-Id", "Microsoft.AspNetCore.Mvc.TagHelpers.AnchorTagHelper", "RouteValues"));
            }
            BeginWriteTagHelperAttribute();
#line 47 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
            WriteLiteral(desc.GroupId);

#line default
#line hidden
            __tagHelperStringValueBuffer = EndWriteTagHelperAttribute();
            __Microsoft_AspNetCore_Mvc_TagHelpers_AnchorTagHelper.RouteValues["Id"] = __tagHelperStringValueBuffer;
            __tagHelperExecutionContext.AddTagHelperAttribute("asp-route-Id", __Microsoft_AspNetCore_Mvc_TagHelpers_AnchorTagHelper.RouteValues["Id"], global::Microsoft.AspNetCore.Razor.TagHelpers.HtmlAttributeValueStyle.DoubleQuotes);
            await __tagHelperRunner.RunAsync(__tagHelperExecutionContext);

            if (!__tagHelperExecutionContext.Output.IsContentModified)
            {
                await __tagHelperExecutionContext.SetOutputContentAsync();
            }
            Write(__tagHelperExecutionContext.Output);
            __tagHelperExecutionContext = __tagHelperScopeManager.End();
            EndContext();
            BeginContext(1423, 34, true);
            WriteLiteral("\r\n        </p>\r\n        <p>Курс : ");
            EndContext();
            BeginContext(1458, 11, false);
#line 49 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
            Write(desc.Course);

#line default
#line hidden
            EndContext();
            BeginContext(1469, 34, true);
            WriteLiteral("</p>\r\n        <p>Форма обучения : ");
            EndContext();
            BeginContext(1504, 14, false);
#line 50 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
            Write(desc.StudyForm);

#line default
#line hidden
            EndContext();
            BeginContext(1518, 40, true);
            WriteLiteral("</p>\r\n        <p>Студенческий билет № : ");
            EndContext();
            BeginContext(1559, 21, false);
#line 51 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
            Write(desc.RecordBookNumber);

#line default
#line hidden
            EndContext();
            BeginContext(1580, 34, true);
            WriteLiteral("</p>\r\n        <p>Номер телефона : ");
            EndContext();
            BeginContext(1615, 16, false);
#line 52 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
            Write(desc.PhoneNumber);

#line default
#line hidden
            EndContext();
            BeginContext(1631, 25, true);
            WriteLiteral("</p>\r\n        <p>Адрес : ");
            EndContext();
            BeginContext(1657, 12, false);
#line 53 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
            Write(desc.Address);

#line default
#line hidden
            EndContext();
            BeginContext(1669, 33, true);
            WriteLiteral("</p>\r\n        <p>День рождения : ");
            EndContext();
            BeginContext(1703, 13, false);
#line 54 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
            Write(desc.Birthday);

#line default
#line hidden
            EndContext();
            BeginContext(1716, 34, true);
            WriteLiteral("</p>\r\n        <p>Финансирование : ");
            EndContext();
            BeginContext(1751, 8, false);
#line 55 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
            Write(Contract);

#line default
#line hidden
            EndContext();
            BeginContext(1759, 39, true);
            WriteLiteral("</p>\r\n        <p>Уровень образования : ");
            EndContext();
            BeginContext(1799, 13, false);
#line 56 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
            Write(desc.EduLevel);

#line default
#line hidden
            EndContext();
            BeginContext(1812, 33, true);
            WriteLiteral("</p>\r\n        <p>Специальность : ");
            EndContext();
            BeginContext(1846, 15, false);
#line 57 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
            Write(desc.Speciality);

#line default
#line hidden
            EndContext();
            BeginContext(1861, 34, true);
            WriteLiteral("</p>\r\n        <p>Образование : от ");
            EndContext();
            BeginContext(1896, 12, false);
#line 58 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
            Write(desc.EduFrom);

#line default
#line hidden
            EndContext();
            BeginContext(1908, 4, true);
            WriteLiteral(" до ");
            EndContext();
            BeginContext(1913, 10, false);
#line 58 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
            Write(desc.EduTo);

#line default
#line hidden
            EndContext();
            BeginContext(1923, 93, true);
            WriteLiteral("</p>\r\n    </div>\r\n\r\n    <div style=\"float:right; width: 82%\" >\r\n        <div id=\"headers\" >\r\n");
            EndContext();
#line 63 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
            for (int i = 0; i < skips.Count(); i++)
            {
#line default
#line hidden
                BeginContext(2085, 117, true);
                WriteLiteral("                <div style=\"margin-bottom: 10vh;\">\r\n                    <div style=\"font-size: 16px;margin-left:35%\">");
                EndContext();
                BeginContext(2204, 3, false);
#line 66 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
                Write(i + 1);

#line default
#line hidden
                EndContext();
                BeginContext(2208, 202, true);
                WriteLiteral(" курс</div>\r\n                    <div style=\"width: max-content;\">\r\n                        <div style=\"border-bottom:1.5px solid black;display:flex;justify-content: center;\">1 Семестр  <a class=\"refer\"");
                EndContext();
                BeginWriteAttribute("href", " href=\"", 2410, "\"", 2487, 6);
                WriteAttributeValue("", 2417, "/Skip/getrefer?grId=", 2417, 20, true);
#line 68 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
                WriteAttributeValue("", 2437, desc.GroupId, 2437, 13, false);

#line default
#line hidden
                WriteAttributeValue("", 2450, "&course=", 2450, 8, true);
#line 68 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
                WriteAttributeValue("", 2458, i + 1, 2458, 6, false);

#line default
#line hidden
                WriteAttributeValue("", 2464, "&semester=1&id=", 2464, 15, true);
#line 68 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
                WriteAttributeValue("", 2479, desc.Id, 2479, 8, false);

#line default
#line hidden
                EndWriteAttribute();
                BeginContext(2488, 115, true);
                WriteLiteral(">(Показать справки)</a></div>\r\n                        <div style=\"display: flex;\">\r\n                            \r\n");
                EndContext();
#line 71 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
                for (int m = 0; m < fSem.Count(); m++)
                {
#line default
#line hidden
                    BeginContext(2711, 180, true);
                    WriteLiteral("                                    <div class=\"month\">\r\n                                        <div style=\"display:flex;justify-content: center; border-bottom: 1.5px solid #000\">");
                    EndContext();
                    BeginContext(2892, 7, false);
#line 74 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
                    Write(fSem[m]);

#line default
#line hidden
                    EndContext();
                    BeginContext(2899, 297, true);
                    WriteLiteral(@"</div>
                                        <div style=""display: flex; border-bottom: 1.5px solid #000"">
                                            <div class=""childhead1""  style=""padding-left: 5px;padding-left:5px;border-right:1.5px solid #000; width:110px;border-right:1.5px solid black;"">");
                    EndContext();
                    BeginContext(3197, 10, false);
#line 76 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
                    Write(headers[0]);

#line default
#line hidden
                    EndContext();
                    BeginContext(3207, 194, true);
                    WriteLiteral("</div>\r\n                                            <div class=\"childhead1\" style=\"padding-left: 5px;padding-left:5px;border-right:1.5px solid #000; width:110px;border-right:1.5px solid black;\">");
                    EndContext();
                    BeginContext(3402, 10, false);
#line 77 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
                    Write(headers[1]);

#line default
#line hidden
                    EndContext();
                    BeginContext(3412, 164, true);
                    WriteLiteral("</div>\r\n                                            <div class=\"childhead1\" style=\"padding-left: 5px;padding-left:5px;width: 60px;;border-right:1.5px solid black;\">");
                    EndContext();
                    BeginContext(3577, 10, false);
#line 78 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
                    Write(headers[2]);

#line default
#line hidden
                    EndContext();
                    BeginContext(3587, 321, true);
                    WriteLiteral(@"</div>
                                        </div>
                                        <div style=""display: flex;width:100%"">
                                            <div class=""childNum""  style=""padding-left: 5px;padding-left:5px;border-right:1.5px solid #000; width:110px;border-right:1.5px solid black;"">");
                    EndContext();
                    BeginContext(3909, 17, false);
#line 81 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
                    Write(skips[i][m].count);

#line default
#line hidden
                    EndContext();
                    BeginContext(3926, 192, true);
                    WriteLiteral("</div>\r\n                                            <div class=\"childNum\" style=\"padding-left: 5px;padding-left:5px;border-right:1.5px solid #000; width:110px;border-right:1.5px solid black;\">");
                    EndContext();
                    BeginContext(4119, 19, false);
#line 82 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
                    Write(skips[i][m].sreason);

#line default
#line hidden
                    EndContext();
                    BeginContext(4138, 163, true);
                    WriteLiteral("</div>\r\n                                            <div class=\"childNum\"  style=\"padding-left: 5px;padding-left:5px;width: 60px;;border-right:1.5px solid black;\">");
                    EndContext();
                    BeginContext(4302, 17, false);
#line 83 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
                    Write(skips[i][m].total);

#line default
#line hidden
                    EndContext();
                    BeginContext(4319, 104, true);
                    WriteLiteral("</div>\r\n                                        </div>\r\n                                    </div>    \r\n");
                    EndContext();
#line 86 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
                }

#line default
#line hidden
                BeginContext(4458, 263, true);
                WriteLiteral(@"                        </div>
                    </div>
                    <div style=""width: max-content;margin-top:25px"">
                        <div style=""border-bottom:1.5px solid black;display:flex;justify-content: center;"">2 Семестр <a class=""refer""");
                EndContext();
                BeginWriteAttribute("href", " href=\"", 4721, "\"", 4798, 6);
                WriteAttributeValue("", 4728, "/Skip/getrefer?grId=", 4728, 20, true);
#line 90 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
                WriteAttributeValue("", 4748, desc.GroupId, 4748, 13, false);

#line default
#line hidden
                WriteAttributeValue("", 4761, "&course=", 4761, 8, true);
#line 90 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
                WriteAttributeValue("", 4769, i + 1, 4769, 6, false);

#line default
#line hidden
                WriteAttributeValue("", 4775, "&semester=2&id=", 4775, 15, true);
#line 90 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
                WriteAttributeValue("", 4790, desc.Id, 4790, 8, false);

#line default
#line hidden
                EndWriteAttribute();
                BeginContext(4799, 115, true);
                WriteLiteral(">(Показать справки)</a></div>\r\n                        <div style=\"display: flex;\">\r\n                            \r\n");
                EndContext();
#line 93 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
                for (int m = 0; m < sSem.Count(); m++)
                {
#line default
#line hidden
                    BeginContext(5022, 180, true);
                    WriteLiteral("                                    <div class=\"month\">\r\n                                        <div style=\"display:flex;justify-content: center; border-bottom: 1.5px solid #000\">");
                    EndContext();
                    BeginContext(5203, 7, false);
#line 96 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
                    Write(sSem[m]);

#line default
#line hidden
                    EndContext();
                    BeginContext(5210, 297, true);
                    WriteLiteral(@"</div>
                                        <div style=""display: flex; border-bottom: 1.5px solid #000"">
                                            <div class=""childhead1""  style=""padding-left: 5px;padding-left:5px;border-right:1.5px solid #000; width:110px;border-right:1.5px solid black;"">");
                    EndContext();
                    BeginContext(5508, 10, false);
#line 98 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
                    Write(headers[0]);

#line default
#line hidden
                    EndContext();
                    BeginContext(5518, 194, true);
                    WriteLiteral("</div>\r\n                                            <div class=\"childhead2\" style=\"padding-left: 5px;padding-left:5px;border-right:1.5px solid #000; width:110px;border-right:1.5px solid black;\">");
                    EndContext();
                    BeginContext(5713, 10, false);
#line 99 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
                    Write(headers[1]);

#line default
#line hidden
                    EndContext();
                    BeginContext(5723, 165, true);
                    WriteLiteral("</div>\r\n                                            <div class=\"childhead3\"  style=\"padding-left: 5px;padding-left:5px;width: 60px;;border-right:1.5px solid black;\">");
                    EndContext();
                    BeginContext(5889, 10, false);
#line 100 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
                    Write(headers[2]);

#line default
#line hidden
                    EndContext();
                    BeginContext(5899, 321, true);
                    WriteLiteral(@"</div>
                                        </div>
                                        <div style=""display: flex;width:100%"">
                                            <div class=""childNum""  style=""padding-left: 5px;padding-left:5px;border-right:1.5px solid #000; width:110px;border-right:1.5px solid black;"">");
                    EndContext();
                    BeginContext(6221, 19, false);
#line 103 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
                    Write(skips[i][m + 4].count);

#line default
#line hidden
                    EndContext();
                    BeginContext(6240, 192, true);
                    WriteLiteral("</div>\r\n                                            <div class=\"childNum\" style=\"padding-left: 5px;padding-left:5px;border-right:1.5px solid #000; width:110px;border-right:1.5px solid black;\">");
                    EndContext();
                    BeginContext(6433, 21, false);
#line 104 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
                    Write(skips[i][m + 4].sreason);

#line default
#line hidden
                    EndContext();
                    BeginContext(6454, 163, true);
                    WriteLiteral("</div>\r\n                                            <div class=\"childNum\"  style=\"padding-left: 5px;padding-left:5px;width: 60px;;border-right:1.5px solid black;\">");
                    EndContext();
                    BeginContext(6618, 19, false);
#line 105 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
                    Write(skips[i][m + 4].total);

#line default
#line hidden
                    EndContext();
                    BeginContext(6637, 104, true);
                    WriteLiteral("</div>\r\n                                        </div>\r\n                                    </div>    \r\n");
                    EndContext();
#line 108 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
                }

#line default
#line hidden
                BeginContext(6776, 84, true);
                WriteLiteral("                        </div>\r\n                    </div>\r\n                </div>\r\n");
                EndContext();
#line 112 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
            }

#line default
#line hidden
            BeginContext(6897, 596, true);
            WriteLiteral(@"
        </div>
     
                                
        
    </div>
</div>



<div style=""background-color: rgb(80, 64, 64);position: absolute; top: 50px;height : max-content"" class=""modal fade"" id=""studMethodsModal"" tabindex=""-1"" role=""dialog"" aria-labelledby=""studMethodsModalLabel"" aria-hidden=""true"">
  <div class=""modal-dialog"" role=""document"">
    <div class=""modal-content"">
      <div class=""modal-header"">
        <h5 class=""modal-title"" id=""referModalTitle"">Методы </h5>
      </div>
      <div class=""modal-body"">
        <a class=""waves-effect waves-light btn""");
            EndContext();
            BeginWriteAttribute("href", " href=\'", 7493, "\'", 7522, 2);
            WriteAttributeValue("", 7500, "/Student/edit/", 7500, 14, true);
#line 131 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
            WriteAttributeValue("", 7514, desc.Id, 7514, 8, false);

#line default
#line hidden
            EndWriteAttribute();
            BeginContext(7523, 81, true);
            WriteLiteral(">Изменить данные о студенте</a> \r\n        <a class=\"waves-effect waves-light btn\"");
            EndContext();
            BeginWriteAttribute("href", " href=\'", 7604, "\'", 7635, 2);
            WriteAttributeValue("", 7611, "/Student/remove/", 7611, 16, true);
#line 132 "C:\Users\_qosh\Documents\C#\University\Views\Student\desc.cshtml"
            WriteAttributeValue("", 7627, desc.Id, 7627, 8, false);

#line default
#line hidden
            EndWriteAttribute();
            BeginContext(7636, 89, true);
            WriteLiteral(" >Удалить</a>\r\n      </div>\r\n      <div id=\"content\"></div>\r\n    </div>\r\n  </div>\r\n</div>");
            EndContext();
        }