Beispiel #1
0
        public override void Execute()
        {
            #line 5 "..\..\Views\HDNguoiLaoDong\Index.cshtml"

            ViewBag.Title = "Index";
            var db0     = new HRM.Databases.Models.HRMDB0Entities();
            var db      = new HRMDB2Entities();
            var listXem = new List <string>();
            listXem.Add("HĐLĐ cuối");
            listXem.Add("Tất cả");
            var XemTatCa = "";
            try
            {
                XemTatCa = TempData["XemTatCa"].ToString();
            }
            catch { }
            var selectXem = new SelectList(listXem, XemTatCa);



            #line default
            #line hidden


            #line 21 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
            var dsHDLDDaloc = new hdChiTietHDLD();
            dsHDLDDaloc = null;



            #line default
            #line hidden
            WriteLiteral("<div style=\"margin-left: 45%\">\r\n    <a href=\"");



            #line 25 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
            Write(Url.Action("Index", "NhapDuLieu"));


            #line default
            #line hidden
            WriteLiteral("\">\r\n        <input id=\"bntNhapDuLieu\" type=\"button\" value=\"Nhập dữ liệu\" /></a> <" +
                         "a href=\"");



            #line 26 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
            Write(Url.Action("Index", "BaoCao", new { dsHDLDDaloc = dsHDLDDaloc }));


            #line default
            #line hidden
            WriteLiteral("\">\r\n            <input id=\"btnBaoCao\" type=\"button\" value=\"Báo cáo\" /></a> <a hre" +
                         "f=\"");



            #line 27 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
            Write(Url.Action("Create", "CauHinhHeThong"));


            #line default
            #line hidden
            WriteLiteral("\">\r\n                <input id=\"btnCauHinh\" type=\"button\" value=\"Cấu hình\" /></a>\r" +
                         "\n</div>\r\n<div style=\"padding: 0; width: 1000px; margin-left: -13%; font-size: in" +
                         "herit\">\r\n");



            #line 31 "..\..\Views\HDNguoiLaoDong\Index.cshtml"

            if (TempData["MessageHDHH"] != null)
            {
            #line default
            #line hidden
                WriteLiteral("        <span class=\"message-error\">Có ");



            #line 34 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                Write(TempData["MessageHDHH"]);


            #line default
            #line hidden
                WriteLiteral(" HĐLĐ sắp hết hạn.</span>");



            #line 34 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                if (TempData["MessageHDHH"] != null)
                {
            #line default
            #line hidden
                    WriteLiteral(@"<a title=""Danh sách hợp đồng lao động sắp hết hạn"" href=""~/HDLaoDong/DSHDSapHetHan/Index""><span
                                                                   class=""ui-icon ui-icon-arrowreturnthick-1-e"" style=""display: inline-block; width: 20px;
                                                                   height: 12px""></span></a>");



            #line 37 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                }

            #line default
            #line hidden
                WriteLiteral("<br />\r\n");



                WriteLiteral("        <br />\r\n");



            #line 39 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
            }
            if (TempData["MessageNLDCT"] != null)
            {
            #line default
            #line hidden
                WriteLiteral("        <span class=\"message-error\">Có ");



            #line 42 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                Write(TempData["MessageNLDCT"]);


            #line default
            #line hidden
                WriteLiteral(" Tuyển dụng đạt.</span>");



            #line 42 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                if (TempData["MessageNLDCT"] != null)
                {
            #line default
            #line hidden
                    WriteLiteral(@"<a title=""Danh sách NLĐ cần tạo hợp đồng lao động"" href=""~/HDLaoDong/DSNLDCanTaoHD/Index""><span
                                                                    class=""ui-icon ui-icon-arrowreturnthick-1-e"" style=""display: inline-block; width: 20px;
                                                                    height: 12px""></span></a>");



            #line 45 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                }


            #line default
            #line hidden
                WriteLiteral("        <br />\r\n");



            #line 47 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
            }


            #line default
            #line hidden

            #line 48 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
            Write(Html.StatusMessage(TempData["Message_NhapDuLieu"]));


            #line default
            #line hidden

            #line 48 "..\..\Views\HDNguoiLaoDong\Index.cshtml"



            #line default
            #line hidden
            WriteLiteral("</div>\r\n<div style=\"padding: 0; width: 1000px; margin-left: -13%; font-size: smal" +
                         "l\">\r\n    <table id=\"TableHDNLD\">\r\n        <thead>\r\n            <tr>\r\n           " +
                         "     <th style=\"text-align: center; width: 20px\" nowrap>\r\n                    ST" +
                         "T\r\n                </th>\r\n                <th style=\"text-align: center\" nowrap>" +
                         "\r\n                    Số HĐ\r\n                </th>\r\n                <th style=\"t" +
                         "ext-align: center\" nowrap>\r\n                    Họ và tên\r\n                </th>" +
                         "\r\n                <th style=\"text-align: center\" nowrap>\r\n                    Đơ" +
                         "n<br />\r\n                    vị\r\n                </th>\r\n                <th styl" +
                         "e=\"text-align: center\" nowrap>\r\n                    Chức danh<br />\r\n           " +
                         "         CM\r\n                </th>\r\n                <th style=\"text-align: cente" +
                         "r\" nowrap>\r\n                    Loại HĐ\r\n                </th>\r\n                " +
                         "<th style=\"text-align: center\" nowrap>\r\n                    Thời<br />\r\n        " +
                         "            hạn\r\n                </th>\r\n                <th style=\"text-align: c" +
                         "enter\" nowrap>\r\n                    Ngày có<br />\r\n                    hiệu lực\r" +
                         "\n                </th>\r\n                <th style=\"text-align: center\" nowrap>\r\n" +
                         "                    Ngày hết<br />\r\n                    hiệu lực\r\n              " +
                         "  </th>\r\n                <th style=\"text-align: center\" nowrap>\r\n               " +
                         "     PLHĐ<br />\r\n                    đi kèm\r\n                </th>\r\n            " +
                         "    <th style=\"text-align: center\" nowrap>\r\n                    Hoàn<br />\r\n    " +
                         "                thành\r\n                </th>\r\n            </tr>\r\n        </thead" +
                         ">\r\n");



            #line 97 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
            if (XemTatCa != "Tất cả")
            {
            #line default
            #line hidden
                WriteLiteral("            <tbody>\r\n");



            #line 100 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                int count = 0;


            #line default
            #line hidden


            #line 101 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                foreach (var item in Model)
                {
                    count = count + 1;


            #line default
            #line hidden
                    WriteLiteral("                    <tr>\r\n                        <td style=\"text-align: center\">" +
                                 "\r\n                            ");



            #line 106 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                    Write(count);


            #line default
            #line hidden
                    WriteLiteral("\r\n                        </td>\r\n                        <td style=\"text-align: c" +
                                 "enter\" nowrap>\r\n");



            #line 109 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                    if (item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().LoaiHD.ToLower() == "Thử việc".ToLower())
                    {
            #line default
            #line hidden

            #line 111 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                        Write(Html.ActionLink(item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().SoHD, "Details_HDThuViec", "ThemMoiHD", new { id = item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().id }, null));


            #line default
            #line hidden

            #line 111 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                    }
                    else if (item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().LoaiHD.ToLower() == "Hợp đồng cơ hữu".ToLower())
                    {
            #line default
            #line hidden

            #line 115 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                        Write(Html.ActionLink(item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().SoHD, "Details_HDCoHuu", "ThemMoiHD", new { id = item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().id }, null));


            #line default
            #line hidden

            #line 115 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                    }
                    else if (item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().LoaiHD.ToLower() == "Hợp đồng dài hạn".ToLower() || item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().LoaiHD.ToLower() == "Hợp đồng dài hạn".ToLower())
                    {
            #line default
            #line hidden

            #line 119 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                        Write(Html.ActionLink(item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().SoHD, "Details_HDDaiHan", "ThemMoiHD", new { id = item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().id }, null));


            #line default
            #line hidden

            #line 119 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                    }


            #line default
            #line hidden
                    WriteLiteral("                        </td>\r\n                        <td style=\"text-align: cen" +
                                 "ter\" nowrap>\r\n                            ");



            #line 123 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                    Write(Html.ActionLink(item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().HotenNLD, "Index", "QTKyHDTungNguoi", new { NLD_id = item.id }, null));


            #line default
            #line hidden
                    WriteLiteral("\r\n                        </td>\r\n");



            #line 125 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                    string tenDonVi = "";
                    if (item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().Donvi_id != null)
                    {
                        int?Donvi_id = item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().Donvi_id;
                        tenDonVi = db0.dmDonVi.Where(dv => dv.id == Donvi_id).First().tenDonVi;
                    }



            #line default
            #line hidden
                    WriteLiteral("                        <td style=\"text-align: center\" data-tip=\"");



            #line 132 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                    Write(tenDonVi);


            #line default
            #line hidden
                    WriteLiteral("\">\r\n");



            #line 133 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                    string maDonVi = "";
                    if (item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().Donvi_id != null)
                    {
                        int?Donvi_id = item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().Donvi_id;
                        maDonVi = db0.dmDonVi.Where(dv => dv.id == Donvi_id).FirstOrDefault().maDonVi;
                    }


            #line default
            #line hidden

            #line 139 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                    Write(Html.DisplayFor(model => maDonVi));


            #line default
            #line hidden

            #line 139 "..\..\Views\HDNguoiLaoDong\Index.cshtml"



            #line default
            #line hidden
                    WriteLiteral("                        </td>\r\n                        <td style=\"text-align: cen" +
                                 "ter\">\r\n");



            #line 143 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                    string tenChucDanh = "";
                    if (item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().Chucdanh_id != null)
                    {
                        int?ChucDanh_id = item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().Chucdanh_id;
                        tenChucDanh = db0.dmChucDanhChuyenMon.Where(dv => dv.id == ChucDanh_id).FirstOrDefault().tenChucDanhChuyenMon;
                    }


            #line default
            #line hidden

            #line 149 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                    Write(Html.Raw(tenChucDanh));


            #line default
            #line hidden

            #line 149 "..\..\Views\HDNguoiLaoDong\Index.cshtml"



            #line default
            #line hidden
                    WriteLiteral("                        </td>\r\n                        <td style=\"text-align: cen" +
                                 "ter\">\r\n                            ");



            #line 153 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                    Write(Html.DisplayFor(model => item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().dmLoaiHopDong.tenLoaiHD));


            #line default
            #line hidden
                    WriteLiteral("\r\n                        </td>\r\n                        <td style=\"text-align: c" +
                                 "enter\">\r\n                            ");



            #line 156 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                    Write(Html.DisplayFor(model => item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().dmThoiHanHD.tenThoiHanHD));


            #line default
            #line hidden
                    WriteLiteral("\r\n                        </td>\r\n                        <td style=\"text-align: c" +
                                 "enter\">\r\n                            ");



            #line 159 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                    Write(item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().NgayHL.ToShortDateString());


            #line default
            #line hidden
                    WriteLiteral("\r\n                        </td>\r\n                        <td style=\"text-align: c" +
                                 "enter\">\r\n");



            #line 162 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                    try
                    {
            #line default
            #line hidden

            #line 164 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                        Write(item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().NgayhetHL.Value.ToShortDateString());


            #line default
            #line hidden

            #line 164 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                    }
                    catch
                    {
                    }


            #line default
            #line hidden
                    WriteLiteral("                        </td>\r\n");



            #line 170 "..\..\Views\HDNguoiLaoDong\Index.cshtml"

                    int HD_id = item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().id;
                    var pl1   = db.hdPhuLucHD12LuuFile.Where(pl => pl.HD_id == HD_id && pl.LoaiPL == "PLSo1");
                    var pl2   = db.hdPhuLucHD12LuuFile.Where(pl => pl.HD_id == HD_id && pl.LoaiPL == "PLSo2");



            #line default
            #line hidden
                    WriteLiteral("                        <td style=\"text-align: center\">\r\n");



            #line 177 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                    if (pl1.Count() > 0)
                    {
            #line default
            #line hidden

            #line 179 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                        Write(Html.Raw("PL Hơp đồng số 1, "));


            #line default
            #line hidden

            #line 179 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                    }


            #line default
            #line hidden


            #line 181 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                    if (pl2.Count() > 0)
                    {
            #line default
            #line hidden

            #line 183 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                        Write(Html.Raw("PL Hơp đồng số 2"));


            #line default
            #line hidden

            #line 183 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                    }


            #line default
            #line hidden
                    WriteLiteral("                        </td>\r\n                        <td style=\"text-align: cen" +
                                 "ter\">\r\n");



            #line 187 "..\..\Views\HDNguoiLaoDong\Index.cshtml"

                    string status = "";
                    if (item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().QT_NgayNLDky != null || (item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().QT_NLDky != null && item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().QT_NLDky != ""))
                    {
                        status = "NLĐ đã ký";
                        if (item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().QT_NgayTrinhHT != null || (item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().QT_TrinhHT != null && item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().QT_TrinhHT != ""))
                        {
                            status = "Đã trình HT";
                            if (item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().QT_NgayHTky != null || (item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().QT_HTky != null && item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().QT_HTky != ""))
                            {
                                status = "HT đã ký";
                                if (item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().QT_NgayLuuHS != null || (item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().QT_LuuHS != null && item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().QT_LuuHS != ""))
                                {
                                    status = "Đã lưu HS";
                                    if (item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().QT_NgayTraNLD != null || (item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().QT_TraNLD != null && item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().QT_TraNLD != ""))
                                    {
                                        status = "Hoàn thành";
                                    }
                                }
                            }
                        }
                    }



            #line default
            #line hidden
                    WriteLiteral("                            ");



            #line 210 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                    Write(Html.Raw(status));


            #line default
            #line hidden
                    WriteLiteral("\r\n                        </td>\r\n                    </tr>\r\n");



            #line 213 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                }


            #line default
            #line hidden
                WriteLiteral("            </tbody>\r\n");



            #line 215 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
            }
            else
            {
            #line default
            #line hidden
                WriteLiteral("            <tbody>\r\n");



            #line 219 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                int count = 0;


            #line default
            #line hidden


            #line 220 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                foreach (var item in Model)
                {
                    foreach (var it in item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL))
                    {
                        count = count + 1;


            #line default
            #line hidden
                        WriteLiteral("                    <tr>\r\n                        <td style=\"text-align: center\">" +
                                     "\r\n                            ");



            #line 227 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                        Write(count);


            #line default
            #line hidden
                        WriteLiteral("\r\n                        </td>\r\n                        <td style=\"text-align: c" +
                                     "enter\" nowrap>\r\n");



            #line 230 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                        if (it.id == item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().id)
                        {
                            if (it.LoaiHD == "Thử việc")
                            {
            #line default
            #line hidden
                                WriteLiteral("                                <span data-tip=\"HĐLĐ cuối\"><b>");



            #line 234 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                                Write(Html.ActionLink(it.SoHD, "Details_HDThuViec", "ThemMoiHD", new { id = it.id }, null));


            #line default
            #line hidden
                                WriteLiteral("</b></span>\r\n");



            #line 235 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                            }
                            else if (it.LoaiHD == "Hợp đồng cơ hữu")
                            {
            #line default
            #line hidden
                                WriteLiteral("                                <span data-tip=\"HĐLĐ cuối\"><b>");



            #line 238 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                                Write(Html.ActionLink(it.SoHD, "Details_HDCoHuu", "ThemMoiHD", new { id = it.id }, null));


            #line default
            #line hidden
                                WriteLiteral("</b></span>\r\n");



            #line 239 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                            }
                            else if (it.LoaiHD == "Hợp đồng dài hạn")
                            {
            #line default
            #line hidden
                                WriteLiteral("                                <span data-tip=\"HĐLĐ cuối\"><b>");



            #line 242 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                                Write(Html.ActionLink(it.SoHD, "Details_HDDaiHan", "ThemMoiHD", new { id = it.id }, null));


            #line default
            #line hidden
                                WriteLiteral("</b></span>\r\n");



            #line 243 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                            }
                        }
                        else
                        {
                            if (it.LoaiHD == "Thử việc")
                            {
            #line default
            #line hidden

            #line 249 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                                Write(Html.ActionLink(it.SoHD, "Details_HDThuViec", "ThemMoiHD", new { id = it.id }, null));


            #line default
            #line hidden

            #line 249 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                            }
                            else if (it.LoaiHD == "Hợp đồng cơ hữu")
                            {
            #line default
            #line hidden

            #line 253 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                                Write(Html.ActionLink(it.SoHD, "Details_HDCoHuu", "ThemMoiHD", new { id = it.id }, null));


            #line default
            #line hidden

            #line 253 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                            }
                            else if (it.LoaiHD == "Hợp đồng dài hạn")
                            {
            #line default
            #line hidden

            #line 257 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                                Write(Html.ActionLink(it.SoHD, "Details_HDDaiHan", "ThemMoiHD", new { id = it.id }, null));


            #line default
            #line hidden

            #line 257 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                            }
                        }


            #line default
            #line hidden
                        WriteLiteral("                        </td>\r\n                        <td style=\"text-align: cen" +
                                     "ter\" nowrap>\r\n                            ");



            #line 262 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                        Write(Html.ActionLink(it.HotenNLD, "Index", "QTKyHDTungNguoi", new { NLD_id = item.id }, null));


            #line default
            #line hidden
                        WriteLiteral("\r\n                        </td>\r\n");



            #line 264 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                        string tenDonVi = "";
                        if (it.Donvi_id != null)
                        {
                            int?Donvi_id = it.Donvi_id;
                            tenDonVi = db0.dmDonVi.Where(dv => dv.id == Donvi_id).FirstOrDefault().tenDonVi;
                        }



            #line default
            #line hidden
                        WriteLiteral("                        <td style=\"text-align: center\" data-tip=\"");



            #line 271 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                        Write(tenDonVi);


            #line default
            #line hidden
                        WriteLiteral("\">\r\n");



            #line 272 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                        string maDonVi = "";
                        if (it.Donvi_id != null)
                        {
                            int?Donvi_id = it.Donvi_id;
                            maDonVi = db0.dmDonVi.Where(dv => dv.id == Donvi_id).FirstOrDefault().maDonVi;
                        }


            #line default
            #line hidden

            #line 278 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                        Write(Html.DisplayFor(model => maDonVi));


            #line default
            #line hidden

            #line 278 "..\..\Views\HDNguoiLaoDong\Index.cshtml"



            #line default
            #line hidden
                        WriteLiteral("                        </td>\r\n                        <td style=\"text-align: cen" +
                                     "ter\">\r\n");



            #line 282 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                        string tenChucDanh = "";
                        if (it.Chucdanh_id != null)
                        {
                            int?ChucDanh_id = it.Chucdanh_id;
                            tenChucDanh = db0.dmChucDanhChuyenMon.Where(dv => dv.id == ChucDanh_id).FirstOrDefault().tenChucDanhChuyenMon;
                        }


            #line default
            #line hidden

            #line 288 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                        Write(Html.Raw(tenChucDanh));


            #line default
            #line hidden

            #line 288 "..\..\Views\HDNguoiLaoDong\Index.cshtml"



            #line default
            #line hidden
                        WriteLiteral("                        </td>\r\n                        <td style=\"text-align: cen" +
                                     "ter\">\r\n                            ");



            #line 292 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                        Write(Html.DisplayFor(model => it.LoaiHD));


            #line default
            #line hidden
                        WriteLiteral("\r\n                        </td>\r\n                        <td style=\"text-align: c" +
                                     "enter\">\r\n                            ");



            #line 295 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                        Write(Html.DisplayFor(model => it.dmThoiHanHD.tenThoiHanHD));


            #line default
            #line hidden
                        WriteLiteral("\r\n                        </td>\r\n                        <td style=\"text-align: c" +
                                     "enter\">\r\n                            ");



            #line 298 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                        Write(it.NgayHL.ToShortDateString());


            #line default
            #line hidden
                        WriteLiteral("\r\n                        </td>\r\n                        <td style=\"text-align: c" +
                                     "enter\">\r\n");



            #line 301 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                        try
                        {
            #line default
            #line hidden

            #line 303 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                            Write(it.NgayhetHL.Value.ToShortDateString());


            #line default
            #line hidden

            #line 303 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                        }
                        catch
                        {
                        }


            #line default
            #line hidden
                        WriteLiteral("                        </td>\r\n");



            #line 309 "..\..\Views\HDNguoiLaoDong\Index.cshtml"

                        int HD_id = it.id;
                        var pl1   = db.hdPhuLucHD12LuuFile.Where(pl => pl.HD_id == HD_id && pl.LoaiPL == "PLSo1");
                        var pl2   = db.hdPhuLucHD12LuuFile.Where(pl => pl.HD_id == HD_id && pl.LoaiPL == "PLSo2");



            #line default
            #line hidden
                        WriteLiteral("                        <td style=\"text-align: center\">\r\n");



            #line 316 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                        if (pl1.Count() > 0)
                        {
            #line default
            #line hidden

            #line 318 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                            Write(Html.Raw("PL Hơp đồng số 1, "));


            #line default
            #line hidden

            #line 318 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                        }


            #line default
            #line hidden


            #line 320 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                        if (pl2.Count() > 0)
                        {
            #line default
            #line hidden

            #line 322 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                            Write(Html.Raw("PL Hơp đồng số 2"));


            #line default
            #line hidden

            #line 322 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                        }


            #line default
            #line hidden
                        WriteLiteral("                        </td>\r\n                        <td style=\"text-align: cen" +
                                     "ter\">\r\n");



            #line 326 "..\..\Views\HDNguoiLaoDong\Index.cshtml"

                        string status = "";
                        if (it.QT_NgayNLDky != null || (it.QT_NLDky != null && it.QT_NLDky != ""))
                        {
                            status = "NLĐ đã ký";
                            if (it.QT_NgayTrinhHT != null || (it.QT_TrinhHT != null && it.QT_TrinhHT != ""))
                            {
                                status = "Đã trình HT";
                                if (it.QT_NgayHTky != null || (it.QT_HTky != null && it.QT_HTky != ""))
                                {
                                    status = "HT đã ký";
                                    if (it.QT_NgayLuuHS != null || (it.QT_LuuHS != null && it.QT_LuuHS != ""))
                                    {
                                        status = "Đã lưu HS";
                                        if (it.QT_NgayTraNLD != null || (it.QT_TraNLD != null && it.QT_TraNLD != ""))
                                        {
                                            status = "Hoàn thành";
                                        }
                                    }
                                }
                            }
                        }



            #line default
            #line hidden
                        WriteLiteral("                            ");



            #line 349 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                        Write(Html.Raw(status));


            #line default
            #line hidden
                        WriteLiteral("\r\n                        </td>\r\n                    </tr>\r\n");



            #line 352 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
                    }
                }


            #line default
            #line hidden
                WriteLiteral("            </tbody> \r\n");



            #line 355 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
            }


            #line default
            #line hidden
            WriteLiteral("    </table>\r\n    <br />\r\n    <p>\r\n        Xem tất cả\r\n        ");



            #line 360 "..\..\Views\HDNguoiLaoDong\Index.cshtml"
            Write(Html.DropDownList("XemTatCa", selectXem, new { onChange = "myFunction()" }));


            #line default
            #line hidden
            WriteLiteral(@"
    </p>
</div>
<script>
    $(document).ready(function () {
        $(""#TableHDNLD"").dataTable({
            ""bAutoWidth"": false,
            ""bStateSave"": true,
            ""aLengthMenu"": [[10, 25, 50, -1], [10, 25, 50, ""All""]]
        });
    });
</script>
<script>
    function myFunction() {
        var index = document.getElementById('XemTatCa').selectedIndex;
        var m = document.getElementById('XemTatCa').options[index].text;
        $.ajax({
            url: ""XemTatCa?value="" + m,
            success: function () {
                location.reload();
            }
        });
    }

</script>
");
        }
Beispiel #2
0
        public override void Execute()
        {
            #line 4 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"

            ViewBag.Title = "Index";
            var db0 = new HRM.Databases.Models.HRMDB0Entities();
            var db  = new HRMDB2Entities();



            #line default
            #line hidden
            WriteLiteral("<div style=\"padding: 0; width: 1000px; margin-left: -13%; font-size: small\">\r\n   " +
                         " <b style=\"margin-left: 40%; font-size: large\">Các hợp đồng đã ký</b>\r\n    <p st" +
                         "yle=\"font-size: medium\">\r\n        <b>");



            #line 12 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
            Write(Model.First().HotenNLD);


            #line default
            #line hidden
            WriteLiteral("</b><a title=\"Quay lại\" href=\"~/HDLaoDong/HDNguoiLaoDong/Index\"><span\r\n          " +
                         "  class=\"ui-icon ui-icon-arrowreturnthick-1-w\" style=\"display: inline-block; wid" +
                         "th: 20px;\r\n            height: 12px\"></span></a>\r\n            ");



            #line 15 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
            Write(Html.ActionLink("Thêm hợp đồng", "Create_Exeption", "ThemMoiHD", new { NLD_id = Model.FirstOrDefault().NLD_id, onclick = "$(this).parents('form').first().submit();" }, null));


            #line default
            #line hidden
            WriteLiteral(@"
    </p>
    <table id=""TableQTKyHD"">
        <thead>
            <tr>
                <th style=""text-align: center"" nowrap>
                    STT
                </th>
                <th style=""text-align: center"" nowrap>
                    Số HĐ
                </th>
                <th style=""text-align: center"" nowrap>
                    Loại HĐ
                </th>
                <th style=""text-align: center"" nowrap>
                    Đơn vị
                </th>
                <th style=""text-align: center"" nowrap>
                    Chức danh<br />
                    CM
                </th>
                <th style=""text-align: center"" nowrap>
                    Thời hạn
                </th>
                <th style=""text-align: center"" nowrap>
                    Ngày hiệu<br />
                    lực
                </th>
                <th style=""text-align: center"" nowrap>
                    Ngày hết<br />
                    hiệu lực
                </th>
                <th style=""text-align: center"" nowrap>
                    PLHĐ<br />
                    đi kèm
                </th>
                <th style=""text-align: center"" nowrap>
                    Hoàn<br />
                    thành
                </th>
            </tr>
        </thead>
        <tbody>
");



            #line 58 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
            int count = 0;


            #line default
            #line hidden


            #line 59 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
            foreach (var item in Model)
            {
                count = count + 1;


            #line default
            #line hidden
                WriteLiteral("                <tr>\r\n                    <td style=\"text-align: center\">\r\n      " +
                             "                  ");



            #line 64 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
                Write(count);


            #line default
            #line hidden
                WriteLiteral("\r\n                    </td>\r\n                    <td style=\"text-align: center\">\r" +
                             "\n");



            #line 67 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
                if (count == 1)
                {
                    if (item.LoaiHD.ToLower() == "Thử việc".ToLower())
                    {
            #line default
            #line hidden
                        WriteLiteral("                            <span data-tip=\"HĐLĐ cuối\"><b>");



            #line 71 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
                        Write(Html.ActionLink(item.SoHD, "Details_HDThuViec", "ThemMoiHD", new { id = item.id }, null));


            #line default
            #line hidden
                        WriteLiteral("</b></span>\r\n");



            #line 72 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
                    }
                    else if (item.LoaiHD.ToLower() == "Hợp đồng cơ hữu".ToLower())
                    {
            #line default
            #line hidden
                        WriteLiteral("                            <span data-tip=\"HĐLĐ cuối\"><b>");



            #line 75 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
                        Write(Html.ActionLink(item.SoHD, "Details_HDCoHuu", "ThemMoiHD", new { id = item.id }, null));


            #line default
            #line hidden
                        WriteLiteral("</b></span>\r\n");



            #line 76 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
                    }
                    else if (item.LoaiHD.ToLower() == "Hợp đồng dài hạn".ToLower() || item.LoaiHD.ToLower() == "Hợp đồng dài hạn".ToLower())
                    {
            #line default
            #line hidden
                        WriteLiteral("                            <span data-tip=\"HĐLĐ cuối\"><b>");



            #line 79 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
                        Write(Html.ActionLink(item.SoHD, "Details_HDDaiHan", "ThemMoiHD", new { id = item.id }, null));


            #line default
            #line hidden
                        WriteLiteral("</b></span>\r\n");



            #line 80 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
                    }
                }
                else
                {
                    if (item.LoaiHD == "Thử việc")
                    {
            #line default
            #line hidden

            #line 86 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
                        Write(Html.ActionLink(item.SoHD, "Details_HDThuViec", "ThemMoiHD", new { id = item.id }, null));


            #line default
            #line hidden

            #line 86 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
                    }
                    else if (item.LoaiHD == "Hợp đồng cơ hữu")
                    {
            #line default
            #line hidden

            #line 90 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
                        Write(Html.ActionLink(item.SoHD, "Details_HDCoHuu", "ThemMoiHD", new { id = item.id }, null));


            #line default
            #line hidden

            #line 90 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
                    }
                    else if (item.LoaiHD == "Hợp đồng dài hạn")
                    {
            #line default
            #line hidden

            #line 94 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
                        Write(Html.ActionLink(item.SoHD, "Details_HDDaiHan", "ThemMoiHD", new { id = item.id }, null));


            #line default
            #line hidden

            #line 94 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
                    }
                }


            #line default
            #line hidden
                WriteLiteral("                    </td>\r\n                    <td style=\"text-align: center\">\r\n " +
                             "                       ");



            #line 99 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
                Write(Html.DisplayFor(model => item.LoaiHD));


            #line default
            #line hidden
                WriteLiteral("\r\n                    </td>\r\n");



            #line 101 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
                string tenDonVi = "";
                if (item.Donvi_id != null)
                {
                    int?Donvi_id = item.Donvi_id;
                    tenDonVi = db0.dmDonVi.Where(dv => dv.id == Donvi_id).First().tenDonVi;
                }



            #line default
            #line hidden
                WriteLiteral("                    <td style=\"text-align: center\" data-tip=\"");



            #line 108 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
                Write(tenDonVi);


            #line default
            #line hidden
                WriteLiteral("\">\r\n");



            #line 109 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
                string maDonVi = "";
                if (item.Donvi_id != null)
                {
                    int?Donvi_id = item.Donvi_id;
                    maDonVi = db0.dmDonVi.Where(dv => dv.id == Donvi_id).First().maDonVi;
                }


            #line default
            #line hidden

            #line 115 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
                Write(Html.DisplayFor(model => maDonVi));


            #line default
            #line hidden

            #line 115 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"



            #line default
            #line hidden
                WriteLiteral("                    </td>\r\n                    <td style=\"text-align: center\">\r\n");



            #line 119 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
                string tenChucDanh = "";
                if (item.Chucdanh_id != null)
                {
                    int?ChucDanh_id = item.Chucdanh_id;
                    tenChucDanh = db0.dmChucDanhChuyenMon.Where(dv => dv.id == ChucDanh_id).First().tenChucDanhChuyenMon;
                }


            #line default
            #line hidden

            #line 125 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
                Write(Html.Raw(tenChucDanh));


            #line default
            #line hidden

            #line 125 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"



            #line default
            #line hidden
                WriteLiteral("                    </td>\r\n                    <td style=\"text-align: center\">\r\n " +
                             "                       ");



            #line 129 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
                Write(Html.DisplayFor(model => item.dmThoiHanHD.tenThoiHanHD));


            #line default
            #line hidden
                WriteLiteral("\r\n                    </td>\r\n                    <td style=\"text-align: center\">\r" +
                             "\n                        ");



            #line 132 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
                Write(item.NgayHL.ToShortDateString());


            #line default
            #line hidden
                WriteLiteral("\r\n                    </td>\r\n                    <td style=\"text-align: center\">\r" +
                             "\n");



            #line 135 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
                try
                {
            #line default
            #line hidden

            #line 137 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
                    Write(item.NgayhetHL.Value.ToShortDateString());


            #line default
            #line hidden

            #line 137 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
                }
                catch
                {
                }


            #line default
            #line hidden
                WriteLiteral("                    </td>\r\n");



            #line 143 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"

                int HD_id = item.id;
                var pl1   = db.hdPhuLucHD12LuuFile.Where(pl => pl.HD_id == HD_id && pl.LoaiPL == "PLSo1");
                var pl2   = db.hdPhuLucHD12LuuFile.Where(pl => pl.HD_id == HD_id && pl.LoaiPL == "PLSo2");



            #line default
            #line hidden
                WriteLiteral("                    <td style=\"text-align: center\">\r\n");



            #line 150 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
                if (pl1.Count() > 0)
                {
            #line default
            #line hidden

            #line 152 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
                    Write(Html.Raw("PL Hơp đồng số 1, "));


            #line default
            #line hidden

            #line 152 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
                }


            #line default
            #line hidden


            #line 154 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
                if (pl2.Count() > 0)
                {
            #line default
            #line hidden

            #line 156 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
                    Write(Html.Raw("PL Hơp đồng số 2"));


            #line default
            #line hidden

            #line 156 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
                }


            #line default
            #line hidden
                WriteLiteral("                    </td>\r\n                    <td style=\"text-align: center\">\r\n");



            #line 160 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"

                string status = "";
                if (item.QT_NgayNLDky != null || (item.QT_NLDky != null && item.QT_NLDky != ""))
                {
                    status = "NLĐ đã ký";
                    if (item.QT_NgayTrinhHT != null || (item.QT_TrinhHT != null && item.QT_TrinhHT != ""))
                    {
                        status = "Đã trình HT";
                        if (item.QT_NgayHTky != null || (item.QT_HTky != null && item.QT_HTky != ""))
                        {
                            status = "HT đã ký";
                            if (item.QT_NgayLuuHS != null || (item.QT_LuuHS != null && item.QT_LuuHS != ""))
                            {
                                status = "Đã lưu HS";
                                if (item.QT_NgayTraNLD != null || (item.QT_TraNLD != null && item.QT_TraNLD != ""))
                                {
                                    status = "Hoàn thành";
                                }
                            }
                        }
                    }
                }



            #line default
            #line hidden
                WriteLiteral("                        ");



            #line 183 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
                Write(Html.Raw(status));


            #line default
            #line hidden
                WriteLiteral("\r\n                    </td>\r\n                </tr>\r\n");



            #line 186 "..\..\Views\QTKyHDTungNguoi\Index.cshtml"
            }


            #line default
            #line hidden
            WriteLiteral(@"        </tbody>
    </table>
</div>
<script>
    $(document).ready(function () {
        $(""#TableQTKyHD"").dataTable({
            ""bAutoWidth"": false,
            ""bStateSave"": true,
            ""aLengthMenu"": [[10, 25, 50, -1], [10, 25, 50, ""All""]]
        });
    });
</script>
");
        }
        public override void Execute()
        {
            #line 5 "..\..\Views\NhapDuLieu\Index.cshtml"

            ViewBag.Title = "Index";
            var db0      = new HRM.Databases.Models.HRMDB0Entities();
            var db       = new HRMDB2Entities();
            var listCTHD = (List <hdChiTietHDLD>)TempData["lisHDCTHDLD"];



            #line default
            #line hidden
            WriteLiteral("<div style=\"padding: 0; width:1000px;margin-left:-13%\">\r\n");



            #line 14 "..\..\Views\NhapDuLieu\Index.cshtml"
            using (Html.BeginForm("ImportToExcel", "NhapDuLieu", FormMethod.Post, new { enctype = "multipart/form-data" }))
            {
            #line default
            #line hidden
                WriteLiteral("    <input type=\"file\" id=\"FileUpload1\" name=\"FileUpload1\" style=\"width: auto\" />" +
                             "\r\n");



                WriteLiteral("    <input type=\"hidden\" name=\"path\" value=\"");



            #line 17 "..\..\Views\NhapDuLieu\Index.cshtml"
                Write(TempData["path"]);


            #line default
            #line hidden
                WriteLiteral("\" />\r\n");



                WriteLiteral("    <input type=\"submit\" id=\"view\" name=\"view\" value=\"Xem trước\" />\r\n");



                WriteLiteral("    <input type=\"submit\" id=\"import\" name=\"import\" value=\"Import\" />\r\n");



            #line 20 "..\..\Views\NhapDuLieu\Index.cshtml"
            }


            #line default
            #line hidden


            #line 21 "..\..\Views\NhapDuLieu\Index.cshtml"
            Write(Html.StatusMessage(TempData["Message_Error"]));


            #line default
            #line hidden
            WriteLiteral(@"
<table id =""ViewImportTable"">
<thead>
    <tr>
        <th style=""text-align:center"" >
            STT
        </th>
        <th style=""text-align:center"">
            Họ và tên
        </th>
        <th style=""text-align:center"" >
            Đơn<br />vị
        </th>
        <th style=""text-align:center"" >
            Chức danh CM
        </th>
        <th style=""text-align:center"" >
            Số HĐ
        </th>
        <th style=""text-align:center"" >
            Loại HĐ
        </th>
        <th style=""text-align:center"" >
            Ngày hiệu<br />lực
        </th>
        <th style=""text-align:center"" >
            Ngày hết<br />hiệu lực
        </th>
        <th style=""text-align:center"" >
            Ngày NLĐ ký
        </th>
        <th style=""text-align:center"" >
            Ngày lưu
        </th>
        <th style=""text-align:center"" >
            Ngày trả
        </th>
        <th style=""text-align:center"" >
            Lương cơ bản
        </th>
        <th style=""text-align:center"" >
            Hệ số lương
        </th>
        <th style=""text-align:center"" >
            Bậc 
        </th>
        <th style=""text-align:center"" >
            Ngạch
        </th>
        <th style=""text-align:center"" >
            Nhóm
        </th>
        <th style=""text-align:center"" >
            Bảng lương
        </th>
    </tr>
</thead>
<tbody>
");



            #line 79 "..\..\Views\NhapDuLieu\Index.cshtml"
            int count = 0;
            var cts   = new List <hdChiTietHDLD>();
            if (listCTHD != null)
            {
                cts = listCTHD;
            }



            #line default
            #line hidden


            #line 85 "..\..\Views\NhapDuLieu\Index.cshtml"
            foreach (var item in cts)
            {
                count = count + 1;


            #line default
            #line hidden
                WriteLiteral("    <tr>\r\n    <td style=\"text-align:center\">\r\n    ");



            #line 90 "..\..\Views\NhapDuLieu\Index.cshtml"
                Write(count);


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n    <td style=\"text-align:center\"  >\r\n    ");



            #line 93 "..\..\Views\NhapDuLieu\Index.cshtml"
                Write(Html.DisplayFor(model => item.HotenNLD));


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n");



            #line 95 "..\..\Views\NhapDuLieu\Index.cshtml"
                string tenDonVi = "";
                if (item.Donvi_id != null)
                {
                    int?Donvi_id = item.Donvi_id;
                    tenDonVi = db0.dmDonVi.Where(dv => dv.id == Donvi_id).First().tenDonVi;
                }



            #line default
            #line hidden
                WriteLiteral("    <td style=\"text-align: center\" data-tip=\"");



            #line 102 "..\..\Views\NhapDuLieu\Index.cshtml"
                Write(tenDonVi);


            #line default
            #line hidden
                WriteLiteral("\">\r\n");



            #line 103 "..\..\Views\NhapDuLieu\Index.cshtml"
                string maDonVi = "";
                if (item.Donvi_id != null)
                {
                    int?Donvi_id = item.Donvi_id;
                    maDonVi = db0.dmDonVi.Where(dv => dv.id == Donvi_id).First().maDonVi;
                }


            #line default
            #line hidden

            #line 109 "..\..\Views\NhapDuLieu\Index.cshtml"
                Write(Html.DisplayFor(model => maDonVi));


            #line default
            #line hidden

            #line 109 "..\..\Views\NhapDuLieu\Index.cshtml"



            #line default
            #line hidden
                WriteLiteral("    </td>\r\n    <td style=\"text-align:center\"  >\r\n");



            #line 113 "..\..\Views\NhapDuLieu\Index.cshtml"
                string tenChucDanh = "";
                if (item.Chucdanh_id != null)
                {
                    int?ChucDanh_id = item.Chucdanh_id;
                    tenChucDanh = db0.dmChucDanhChuyenMon.Where(dv => dv.id == ChucDanh_id).First().tenChucDanhChuyenMon;
                }


            #line default
            #line hidden

            #line 119 "..\..\Views\NhapDuLieu\Index.cshtml"
                Write(Html.Raw(tenChucDanh));


            #line default
            #line hidden

            #line 119 "..\..\Views\NhapDuLieu\Index.cshtml"



            #line default
            #line hidden
                WriteLiteral("    </td>\r\n    <td style=\"text-align:center\"  >\r\n        ");



            #line 123 "..\..\Views\NhapDuLieu\Index.cshtml"
                Write(Html.DisplayFor(model => item.SoHD));


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n    <td style=\"text-align:center\"  >\r\n        ");



            #line 126 "..\..\Views\NhapDuLieu\Index.cshtml"
                Write(Html.DisplayFor(model => item.LoaiHD));


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n    <td style=\"text-align:center\">\r\n        ");



            #line 129 "..\..\Views\NhapDuLieu\Index.cshtml"
                Write(item.NgayHL.ToShortDateString());


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n    <td style=\"text-align:center\">\r\n        ");



            #line 132 "..\..\Views\NhapDuLieu\Index.cshtml"
                Write(item.NgayhetHL);


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n    <td style=\"text-align:center\">\r\n        ");



            #line 135 "..\..\Views\NhapDuLieu\Index.cshtml"
                Write(item.QT_NgayNLDky);


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n    <td style=\"text-align:center\">\r\n        ");



            #line 138 "..\..\Views\NhapDuLieu\Index.cshtml"
                Write(item.QT_NgayLuuHS);


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n    <td style=\"text-align:center\">\r\n        ");



            #line 141 "..\..\Views\NhapDuLieu\Index.cshtml"
                Write(item.QT_NgayTraNLD);


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n    <td style=\"text-align:center\">\r\n        ");



            #line 144 "..\..\Views\NhapDuLieu\Index.cshtml"
                Write(item.Mucluongchinh);


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n");



            #line 146 "..\..\Views\NhapDuLieu\Index.cshtml"

                double?HeSo  = null;
                var    Bac   = "";
                var    Ngach = "";
                var    Nhom  = "";


                int?nHSLuong_id = item.HSLuong_id;
                int?nNgach_id   = item.Ngach_id;
                int?nNhom_id    = item.Nhom_id;
                try
                {
                    HeSo = db0.dmBangLuong.Where(bl => bl.id == nHSLuong_id).FirstOrDefault().hesoLuong;
                }
                catch
                {
                }
                try
                {
                    Bac = db0.dmBangLuong.Where(bl => bl.id == nHSLuong_id).FirstOrDefault().bacLuong;
                }
                catch
                {
                }
                try
                {
                    Ngach = db0.dmNgachVienChuc.Where(bl => bl.id == nNgach_id).FirstOrDefault().tenNgachVienChuc;
                }
                catch
                {
                }
                try
                {
                    Nhom = db0.dmNhomNgachVienChuc.Where(bl => bl.id == nNhom_id).FirstOrDefault().tenNhomNgachVienChuc;
                }
                catch
                {
                }



            #line default
            #line hidden
                WriteLiteral("    <td style=\"text-align:center\">\r\n    ");



            #line 186 "..\..\Views\NhapDuLieu\Index.cshtml"
                Write(Html.Raw(HeSo));


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n    <td style=\"text-align:center\">\r\n    ");



            #line 189 "..\..\Views\NhapDuLieu\Index.cshtml"
                Write(Html.Raw(Bac));


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n    <td style=\"text-align:center\">\r\n    ");



            #line 192 "..\..\Views\NhapDuLieu\Index.cshtml"
                Write(Html.Raw(Ngach));


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n    <td style=\"text-align:center\">\r\n    ");



            #line 195 "..\..\Views\NhapDuLieu\Index.cshtml"
                Write(Html.Raw(Ngach));


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n    <td style=\"text-align:center\">\r\n    ");



            #line 198 "..\..\Views\NhapDuLieu\Index.cshtml"
                Write(item.Bangluong_id);


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n    </tr>\r\n");



            #line 201 "..\..\Views\NhapDuLieu\Index.cshtml"
            }


            #line default
            #line hidden
            WriteLiteral(@"</tbody>
</table>
</div>
<style>
    table
    {
        overflow: auto;
        width: 100%;
        display: block;
    }
    input
    {
        margin: 0 0 0 0;
    }
    td
    {
        padding: 0;
    }
    .ui-state-hover
    {
        font-weight: normal !important;
    }
</style>
<style>
    td
    {
        padding: 0 0 0 0;
    }
    input
    {
        margin: 0 0 0 0;
        width: auto;
    }
</style>
<script>
    var message = '<%=ViewData[""mymessage""]%>';
    if (message.length > 0)
        windows.alert(message);
</script>

<script>
    $().ready(function () {
        var table$ = $(""#ViewImportTable"");
        table$.find(""th"").each(function () {
            $(this).addClass(""ui-state-default"");
        });
        table$.find(""td"").each(function () {
            $(this).addClass(""ui-widget-content"");
        });

    });
</script>
");
        }
Beispiel #4
0
        public override void Execute()
        {
            #line 4 "..\..\Views\DSNLDCanTaoHD\Index.cshtml"

            ViewBag.Title = "Index";
            var db0 = new HRM.Databases.Models.HRMDB0Entities();



            #line default
            #line hidden
            WriteLiteral("\r\n<b style=\"margin-left:30%;font-size:large\">Danh sách NLĐ cần tạo hợp đồng lao đ" +
                         "ộng</b>\r\n<p>\r\n<br /></p>\r\n<div id=\"HDLD1\" style=\"padding: 0; width:1000px;margin" +
                         "-left:-13%;font-size:small\">\r\n<p>");



            #line 13 "..\..\Views\DSNLDCanTaoHD\Index.cshtml"
            Write(Html.ActionLink("Quay lại", "Index", "HDNguoiLaoDong"));


            #line default
            #line hidden
            WriteLiteral(@"</p>
<table id =""TableDSNLDCanTaoHD"">
<thead>
    <tr>
        <th style=""text-align:center;width:30px"" nowrap>
            STT
        </th>
        <th style=""text-align:center;width:150px"" nowrap>
            Họ và tên
        </th>
        <th style=""text-align:center"" nowrap>
            Đơn vị
        </th>
        <th style=""text-align:center;width:200px"" nowrap>
            Chức danh<br />CM
        </th>
        <th style=""text-align:center"" nowrap>
            Lý do
        </th>
        <th style=""text-align:center;width:10px"" nowrap>
        </th>
    </tr>
</thead>
<tbody>
");



            #line 37 "..\..\Views\DSNLDCanTaoHD\Index.cshtml"
            int count = 0;


            #line default
            #line hidden


            #line 38 "..\..\Views\DSNLDCanTaoHD\Index.cshtml"
            foreach (var item in Model)
            {
                count = count + 1;


            #line default
            #line hidden
                WriteLiteral("    <tr>\r\n    <td>\r\n    ");



            #line 43 "..\..\Views\DSNLDCanTaoHD\Index.cshtml"
                Write(count);


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n    <td  style=\"text-align:center\" nowrap>\r\n    ");



            #line 46 "..\..\Views\DSNLDCanTaoHD\Index.cshtml"
                Write(Html.DisplayFor(model => item.Hoten));


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n    <td style=\"text-align:center\">\r\n");



            #line 49 "..\..\Views\DSNLDCanTaoHD\Index.cshtml"
                string tenDonVi = "";
                if (item.Donvi_id != null)
                {
                    int?Donvi_id = item.Donvi_id;
                    tenDonVi = db0.dmDonVi.Where(dv => dv.id == Donvi_id).First().tenDonVi;
                }


            #line default
            #line hidden

            #line 55 "..\..\Views\DSNLDCanTaoHD\Index.cshtml"
                Write(Html.DisplayFor(model => tenDonVi));


            #line default
            #line hidden

            #line 55 "..\..\Views\DSNLDCanTaoHD\Index.cshtml"



            #line default
            #line hidden
                WriteLiteral("    </td>\r\n    <td  style=\"text-align:center\">\r\n");



            #line 59 "..\..\Views\DSNLDCanTaoHD\Index.cshtml"
                string tenChucDanh = "";
                if (item.VitriCT_id != null)
                {
                    int?ChucDanh_id = item.VitriCT_id;
                    tenChucDanh = db0.dmChucDanhChuyenMon.Where(dv => dv.id == ChucDanh_id).First().tenChucDanhChuyenMon;
                }


            #line default
            #line hidden

            #line 65 "..\..\Views\DSNLDCanTaoHD\Index.cshtml"
                Write(Html.Raw(tenChucDanh));


            #line default
            #line hidden

            #line 65 "..\..\Views\DSNLDCanTaoHD\Index.cshtml"



            #line default
            #line hidden
                WriteLiteral("    </td>\r\n    <td  style=\"text-align:center\">\r\n    ");



            #line 69 "..\..\Views\DSNLDCanTaoHD\Index.cshtml"
                Write(Html.DisplayFor(model => item.Lydo));


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n    <td style=\"text-align:center\" >\r\n");



            #line 72 "..\..\Views\DSNLDCanTaoHD\Index.cshtml"
                using (Html.BeginForm("TruyenID", "ThemMoiHD", new { DSNLDCanTaoHD_id = item.id }))
                {
            #line default
            #line hidden
                    WriteLiteral("    <a title=\"Tạo mới hợp đồng\" onclick=\"$(this).parents(\'tr\').find(\'form\').submi" +
                                 "t()\"><span class=\"ui-icon ui-icon-circle-plus\"  style=\"display:inline-block\"></s" +
                                 "pan></a>\r\n");



            #line 75 "..\..\Views\DSNLDCanTaoHD\Index.cshtml"
                }


            #line default
            #line hidden
                WriteLiteral("    </td>\r\n    </tr>\r\n");



            #line 78 "..\..\Views\DSNLDCanTaoHD\Index.cshtml"
            }


            #line default
            #line hidden
            WriteLiteral(@"</tbody>
</table>
</div>
<br />

<script>
    $(document).ready(function () {
        $(""#TableDSNLDCanTaoHD"").dataTable({
            ""bAutoWidth"": false,
            ""bStateSave"": true,
            ""aLengthMenu"": [[10, 25, 50, -1], [10, 25, 50, ""All""]]
        });
    });
</script>

");
        }
        public override void Execute()
        {
            #line 4 "..\..\Views\DSHDSapHetHan\Index.cshtml"

            ViewBag.Title = "Index";
            var db0 = new HRM.Databases.Models.HRMDB0Entities();



            #line default
            #line hidden
            WriteLiteral("\r\n<b style=\"margin-left:30%;font-size:large\">Danh sách hợp đồng lao động sắp hết " +
                         "hạn</b>\r\n<p><br /></p>\r\n<div id=\"HDLD1\" style=\"padding: 0; width:1000px;margin-l" +
                         "eft:-13%;font-size:small\">\r\n<p>");



            #line 12 "..\..\Views\DSHDSapHetHan\Index.cshtml"
            Write(Html.ActionLink("Quay lại", "Index", "HDNguoiLaoDong"));


            #line default
            #line hidden
            WriteLiteral(@"</p>
<table id =""HDTV"">
<thead>
    <tr>
        <th style=""text-align:center"" nowrap>
            STT
        </th>
        <th style=""text-align:center"" nowrap>
            Số HĐ
        </th>
        <th style=""text-align:center"" nowrap>
            Họ và tên
        </th>
        <th style=""text-align:center"" nowrap>
            Đơn vị
        </th>
        <th style=""text-align:center"" nowrap>
            Vị trí<br />công tác
        </th>
        <th style=""text-align:center"" nowrap>
            Loại HĐ
        </th>
        <th style=""text-align:center"" nowrap>
            Thời hạn
        </th>
        <th style=""text-align:center"" nowrap>
            Ngày<br />hiệu lực
        </th>
        <th style=""text-align:center"" nowrap>
            Ngày hết<br />hiệu lực
        </th>
    </tr>
</thead>
<tbody>
");



            #line 46 "..\..\Views\DSHDSapHetHan\Index.cshtml"
            int count = 0;


            #line default
            #line hidden


            #line 47 "..\..\Views\DSHDSapHetHan\Index.cshtml"
            foreach (var item in Model)
            {
                count = count + 1;


            #line default
            #line hidden
                WriteLiteral("    <tr>\r\n    <td style=\"text-align: center\">\r\n    ");



            #line 52 "..\..\Views\DSHDSapHetHan\Index.cshtml"
                Write(count);


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n    <td style=\"text-align: center\" nowrap>\r\n");



            #line 55 "..\..\Views\DSHDSapHetHan\Index.cshtml"
                if (item.LoaiHD == "Thử việc")
                {
            #line default
            #line hidden

            #line 57 "..\..\Views\DSHDSapHetHan\Index.cshtml"
                    Write(Html.ActionLink(item.SoHD, "Details_HDThuViec", "ThemMoiHD", new { id = item.id }, null));


            #line default
            #line hidden

            #line 57 "..\..\Views\DSHDSapHetHan\Index.cshtml"
                }
                else if (item.LoaiHD == "Hợp đồng cơ hữu")
                {
            #line default
            #line hidden

            #line 61 "..\..\Views\DSHDSapHetHan\Index.cshtml"
                    Write(Html.ActionLink(item.SoHD, "Details_HDCoHuu", "ThemMoiHD", new { id = item.id }, null));


            #line default
            #line hidden

            #line 61 "..\..\Views\DSHDSapHetHan\Index.cshtml"
                }
                else if (item.LoaiHD == "Hợp đồng dài hạn")
                {
            #line default
            #line hidden

            #line 65 "..\..\Views\DSHDSapHetHan\Index.cshtml"
                    Write(Html.ActionLink(item.SoHD, "Details_HDDaiHan", "ThemMoiHD", new { id = item.id }, null));


            #line default
            #line hidden

            #line 65 "..\..\Views\DSHDSapHetHan\Index.cshtml"
                }


            #line default
            #line hidden
                WriteLiteral("    </td>\r\n    <td style=\"text-align: center\" nowrap>\r\n    ");



            #line 69 "..\..\Views\DSHDSapHetHan\Index.cshtml"
                Write(Html.ActionLink(item.HotenNLD, "Index", "QTKyHDTungNguoi", new { NLD_id = item.NLD_id }, null));


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n");



            #line 71 "..\..\Views\DSHDSapHetHan\Index.cshtml"
                string tenDonVi = "";
                if (item.Donvi_id != null)
                {
                    int?Donvi_id = item.Donvi_id;
                    tenDonVi = db0.dmDonVi.Where(dv => dv.id == Donvi_id).First().tenDonVi;
                }



            #line default
            #line hidden
                WriteLiteral("    <td style=\"text-align: center\" data-tip=\"");



            #line 78 "..\..\Views\DSHDSapHetHan\Index.cshtml"
                Write(tenDonVi);


            #line default
            #line hidden
                WriteLiteral("\">\r\n");



            #line 79 "..\..\Views\DSHDSapHetHan\Index.cshtml"
                string maDonVi = "";
                if (item.Donvi_id != null)
                {
                    int?Donvi_id = item.Donvi_id;
                    maDonVi = db0.dmDonVi.Where(dv => dv.id == Donvi_id).First().maDonVi;
                }


            #line default
            #line hidden

            #line 85 "..\..\Views\DSHDSapHetHan\Index.cshtml"
                Write(Html.DisplayFor(model => maDonVi));


            #line default
            #line hidden

            #line 85 "..\..\Views\DSHDSapHetHan\Index.cshtml"



            #line default
            #line hidden
                WriteLiteral("    </td>\r\n    <td style=\"text-align: center\">\r\n");



            #line 89 "..\..\Views\DSHDSapHetHan\Index.cshtml"
                string tenChucDanh = "";
                if (item.Chucdanh_id != null)
                {
                    int?ChucDanh_id = item.Chucdanh_id;
                    tenChucDanh = db0.dmChucDanhChuyenMon.Where(dv => dv.id == ChucDanh_id).First().tenChucDanhChuyenMon;
                }


            #line default
            #line hidden

            #line 95 "..\..\Views\DSHDSapHetHan\Index.cshtml"
                Write(Html.Raw(tenChucDanh));


            #line default
            #line hidden

            #line 95 "..\..\Views\DSHDSapHetHan\Index.cshtml"



            #line default
            #line hidden
                WriteLiteral("    </td>\r\n    <td style=\"text-align: center\">\r\n    ");



            #line 99 "..\..\Views\DSHDSapHetHan\Index.cshtml"
                Write(Html.DisplayFor(model => item.LoaiHD));


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n    <td style=\"text-align: center\">\r\n    ");



            #line 102 "..\..\Views\DSHDSapHetHan\Index.cshtml"
                Write(Html.DisplayFor(model => item.dmThoiHanHD.tenThoiHanHD));


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n    <td style=\"text-align: center\">\r\n    ");



            #line 105 "..\..\Views\DSHDSapHetHan\Index.cshtml"
                Write(item.NgayHL.ToShortDateString());


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n    <td style=\"text-align: center\">\r\n");



            #line 108 "..\..\Views\DSHDSapHetHan\Index.cshtml"
                try{
            #line default
            #line hidden

            #line 109 "..\..\Views\DSHDSapHetHan\Index.cshtml"
                    Write(item.NgayhetHL.Value.ToShortDateString());


            #line default
            #line hidden

            #line 109 "..\..\Views\DSHDSapHetHan\Index.cshtml"
                }catch {
                }


            #line default
            #line hidden
                WriteLiteral("    </td>\r\n    </tr>\r\n");



            #line 114 "..\..\Views\DSHDSapHetHan\Index.cshtml"
            }


            #line default
            #line hidden
            WriteLiteral(@"</tbody>
</table>
</div>
<script>
    $(document).ready(function () {
        $(""#HDTV"").dataTable({
            ""bAutoWidth"": false,
            ""bStateSave"": true,
            ""aLengthMenu"": [[10, 25, 50, -1], [10, 25, 50, ""All""]]
        });
    });
</script>
");
        }
Beispiel #6
0
        public override void Execute()
        {
            WriteLiteral("\r\n");



            #line 6 "..\..\Views\BaoCao\Index.cshtml"

            ViewBag.Title = "Index";
            var db  = new HRMDB2Entities();
            var db0 = new HRM.Databases.Models.HRMDB0Entities();

            var HoVaTen     = Convert.ToString(Request["HoVaTen"]);
            var DonVi       = Convert.ToString(Request["DonVi"]);
            var LoaiHD      = Convert.ToString(Request["LoaiHD"]);
            var ThoiHanHD   = Convert.ToString(Request["ThoiHanHD"]);
            var NLDKy       = Convert.ToString(Request["NLDKy"]);
            var TrinhHT     = Convert.ToString(Request["TrinhHT"]);
            var HTKy        = Convert.ToString(Request["HTKy"]);
            var Luu         = Convert.ToString(Request["Luu"]);
            var Tra         = Convert.ToString(Request["Tra"]);
            var HDLDCuoi    = Convert.ToString(Request["HDLDCuoi"]);
            var HDHetHan    = Convert.ToString(Request["HDHetHan"]);
            var HDSapHetHan = Convert.ToString(Request["HDSapHetHan"]);

            var      NHLTuNgay = new Nullable <DateTime>();
            DateTime date;
            if (DateTime.TryParse(Request["NHLTuNgay"], out date))
            {
                NHLTuNgay = date;
            }
            var      NHLDenNgay = new Nullable <DateTime>();
            DateTime date1;
            if (DateTime.TryParse(Request["NHLDenNgay"], out date1))
            {
                NHLDenNgay = date1;
            }
            var      NHHLTuNgay = new Nullable <DateTime>();
            DateTime date2;
            if (DateTime.TryParse(Request["NHHLTuNgay"], out date2))
            {
                NHHLTuNgay = date2;
            }
            var      NHHLDenNgay = new Nullable <DateTime>();
            DateTime date3;
            if (DateTime.TryParse(Request["NHHLDenNgay"], out date3))
            {
                NHHLDenNgay = date3;
            }

            var dsHoTen = new List <String>();
            foreach (var item in db.hdNLD.Where(ld => ld.hidden == false))
            {
                if (dsHoTen.Count() <= 0)
                {
                    dsHoTen.Add(item.hdChiTietHDLDs.LastOrDefault().HotenNLD);
                }
                else
                {
                    bool kt = false;
                    for (int i = 0; i < dsHoTen.Count(); i++)
                    {
                        if (item.hdChiTietHDLDs.LastOrDefault().HotenNLD == dsHoTen[i])
                        {
                            kt = true;
                        }
                    }
                    if (kt == false)
                    {
                        dsHoTen.Add(item.hdChiTietHDLDs.LastOrDefault().HotenNLD);
                    }
                }
            }
            var HoTen_id = new SelectList(dsHoTen, HoVaTen);

            var DonVi_id = new SelectList(db0.dmDonVi.OrderBy(tt => tt.tenDonVi), "id", "tenDonVi", DonVi);

            var dsLoaiHD = new List <String>();
            dsLoaiHD.Add("Hợp đồng cơ hữu");
            dsLoaiHD.Add("Thử việc");
            dsLoaiHD.Add("Hợp đồng dài hạn");
            var LoaiHD_id = new SelectList(dsLoaiHD, LoaiHD);

            var dsNLDKy = new List <String>();
            dsNLDKy.Add("Đã ký");
            dsNLDKy.Add("Chưa ký");
            var NLDKy_id = new SelectList(dsNLDKy, NLDKy);

            var dsTrinhHT = new List <String>();
            dsTrinhHT.Add("Đã trình");
            dsTrinhHT.Add("Chưa trình");
            var TrinhHT_id = new SelectList(dsTrinhHT, TrinhHT);

            var dsHTKy = new List <String>();
            dsHTKy.Add("Đã ký");
            dsHTKy.Add("Chưa ký");
            var HTKy_id = new SelectList(dsHTKy, HTKy);

            var dsLuu = new List <String>();
            dsLuu.Add("Đã lưu");
            dsLuu.Add("Chưa lưu");
            var Luu_id = new SelectList(dsLuu, Luu);

            var dsTra = new List <String>();
            dsTra.Add("Đã trả");
            dsTra.Add("Chưa trả");
            var Tra_id = new SelectList(dsTra, Tra);



            #line default
            #line hidden


            #line 105 "..\..\Views\BaoCao\Index.cshtml"

            var TemptHDCuoi = new List <hdChiTietHDLD>();
            foreach (var item in db.hdNLD.Where(ld => ld.hidden == false))
            {
                TemptHDCuoi.Add(item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault());
            }
            var FiltedHDCuoi = db.hdChiTietHDLD.ToList();
            if (HDLDCuoi == "on")
            {
                FiltedHDCuoi = TemptHDCuoi;
            }

            var FiltedHDQuaHanChuaXuLy = TemptHDCuoi.Where(hd => hd.hdNLD1.hidden == false);
            if (HDHetHan == "on")
            {
                FiltedHDQuaHanChuaXuLy = FiltedHDQuaHanChuaXuLy.Where(ct => ct.NgayhetHL < DateTime.Today);
            }

            var FiltedHDSapHetHan = TemptHDCuoi.Where(hd => hd.hdNLD1.hidden == false);
            if (HDSapHetHan == "on")
            {
                var hdchitiethdlds = new List <hdChiTietHDLD>();
                foreach (var item in FiltedHDSapHetHan)
                {
                    if (item.NgayhetHL != null)
                    {
                        System.TimeSpan diffDate = (DateTime)item.NgayhetHL - DateTime.Today;
                        if ((diffDate.Days <= db.hdCauHinh.FirstOrDefault().NgayHDTV&& item.LoaiHD == "Thử việc") || (diffDate.Days <= db.hdCauHinh.FirstOrDefault().NgayHDCT&& item.LoaiHD == "Hợp đồng dài hạn") || (diffDate.Days <= db.hdCauHinh.FirstOrDefault().NgayHDCT&& item.LoaiHD == "Hợp đồng cơ hữu"))
                        {
                            hdchitiethdlds.Add(item);
                        }
                    }
                }
                FiltedHDSapHetHan = hdchitiethdlds;
            }

            var tem           = db.hdChiTietHDLD.ToList();
            var FiltedHoVaTen = tem.Where(hd => hd.hdNLD1.hidden == false);
            if (HDLDCuoi == "on")
            {
                FiltedHoVaTen = FiltedHDCuoi;
            }
            if (HDHetHan == "on")
            {
                FiltedHoVaTen = FiltedHDQuaHanChuaXuLy;
            }
            if (HDSapHetHan == "on")
            {
                FiltedHoVaTen = FiltedHDSapHetHan;
            }
            if (HoVaTen != "")
            {
                FiltedHoVaTen = FiltedHoVaTen.Where(ct => ct.HotenNLD == HoVaTen);
            }
            int?intDonVi = null;
            try{
                intDonVi = int.Parse(DonVi);
            }catch {
            }
            var FiltedDonVi = FiltedHoVaTen;
            if (intDonVi != null)
            {
                FiltedDonVi = FiltedHoVaTen.Where(ct => ct.Donvi_id == intDonVi);
            }
            var FiltedLoaiHD = FiltedDonVi;
            if (LoaiHD != "")
            {
                FiltedLoaiHD = FiltedDonVi.Where(ct => ct.LoaiHD == LoaiHD);
            }
            var FiltedThoiHanHD = FiltedLoaiHD;
            var FiltedNHL       = FiltedThoiHanHD;
            if (NHLTuNgay != null)
            {
                FiltedNHL = FiltedThoiHanHD.Where(ct => ct.NgayHL >= NHLTuNgay && ct.NgayHL <= NHLDenNgay);
            }
            var FiltedNHHL = FiltedNHL;
            if (NHHLTuNgay != null)
            {
                FiltedNHHL = FiltedNHL.Where(ct => ct.NgayhetHL >= NHHLTuNgay && ct.NgayhetHL <= NHHLDenNgay);
            }
            var FiltedNLDKy = FiltedNHHL;
            if (NLDKy == "Đã ký")
            {
                FiltedNLDKy = FiltedNHHL.Where(ct => ct.QT_NgayNLDky != null || (ct.QT_NLDky != null && ct.QT_NLDky != ""));
            }
            else if (NLDKy == "Chưa ký")
            {
                FiltedNLDKy = FiltedNHHL.Where(ct => ct.QT_NgayNLDky == null && (ct.QT_NLDky == null || ct.QT_NLDky == ""));
            }
            var FiltedTrinhHT = FiltedNLDKy;
            if (TrinhHT == "Đã trình")
            {
                FiltedTrinhHT = FiltedNLDKy.Where(ct => ct.QT_NgayTrinhHT != null || (ct.QT_TrinhHT != null && ct.QT_TrinhHT != ""));
            }
            else if (NLDKy == "Chưa trình")
            {
                FiltedTrinhHT = FiltedNLDKy.Where(ct => ct.QT_NgayTrinhHT == null && (ct.QT_TrinhHT == null || ct.QT_TrinhHT == ""));
            }
            var FiltedHTKy = FiltedTrinhHT;
            if (HTKy == "Đã ký")
            {
                FiltedHTKy = FiltedTrinhHT.Where(ct => ct.QT_NgayHTky != null || (ct.QT_HTky != null && ct.QT_HTky != ""));
            }
            else if (HTKy == "Chưa ký")
            {
                FiltedHTKy = FiltedTrinhHT.Where(ct => ct.QT_NgayHTky == null && (ct.QT_HTky == null && ct.QT_HTky == ""));
            }
            var FiltedLuu = FiltedHTKy;
            if (Luu == "Đã lưu")
            {
                FiltedLuu = FiltedHTKy.Where(ct => ct.QT_NgayLuuHS != null || (ct.QT_LuuHS != null && ct.QT_LuuHS != ""));
            }
            else if (Luu == "Chưa lưu")
            {
                FiltedLuu = FiltedHTKy.Where(ct => ct.QT_NgayLuuHS == null && (ct.QT_LuuHS == null || ct.QT_LuuHS == ""));
            }
            var FiltedTra = FiltedLuu;
            if (Tra == "Đã trả")
            {
                FiltedTra = FiltedLuu.Where(ct => ct.QT_NgayTraNLD != null || (ct.QT_TraNLD != null && ct.QT_TraNLD != ""));
            }
            else if (Tra == "Chưa trả")
            {
                FiltedTra = FiltedLuu.Where(ct => ct.QT_NgayTraNLD == null && (ct.QT_TraNLD == null || ct.QT_TraNLD == ""));
            }
            var cts = FiltedTra;



            #line default
            #line hidden
            WriteLiteral("\r\n<div id=\"BaoCao\" style=\"padding: 0; width:1000px;margin-left:-13%;font-size:med" +
                         "ium\">\r\n<p><b style=\"margin-left: 45%; font-size: large\">Báo cáo</b></p>\r\n");



            #line 220 "..\..\Views\BaoCao\Index.cshtml"
            Write(Html.ActionLink("Quay lại", "Index", "HDNguoiLaoDong"));


            #line default
            #line hidden
            WriteLiteral("\r\n    <h3 style=\"margin: 0\">\r\n        <b style=\"font-size:medium\">Điều kiện lọc b" +
                         "áo cáo</b></h3>\r\n    <div style=\"padding: 0\">\r\n");



            #line 224 "..\..\Views\BaoCao\Index.cshtml"
            using (Html.BeginForm("Index", "BaoCao", new { id = "Filter", }))
            {
            #line default
            #line hidden
                WriteLiteral("        <p>\r\n        Họ và tên<span style=\"margin-left:20px\"></span>\r\n        ");



            #line 228 "..\..\Views\BaoCao\Index.cshtml"
                Write(Html.DropDownList("HoVaTen", HoTen_id, String.Empty, new { id = "HoVaTen", name = "HoVaTen" }));


            #line default
            #line hidden
                WriteLiteral("\r\n        </p>\r\n");



                WriteLiteral("        <p>\r\n        Đơn vị<span style=\"margin-left:40px\"></span>\r\n        ");



            #line 232 "..\..\Views\BaoCao\Index.cshtml"
                Write(Html.DropDownList("DonVi", DonVi_id, String.Empty, new { id = "DonVi", name = "DonVi" }));


            #line default
            #line hidden
                WriteLiteral("\r\n        </p>\r\n");



                WriteLiteral("        <p>\r\n        Loại HĐ<span style=\"margin-left:32px\"></span>\r\n        ");



            #line 236 "..\..\Views\BaoCao\Index.cshtml"
                Write(Html.DropDownList("LoaiHD", LoaiHD_id, String.Empty, new { id = "LoaiHD", name = "LoaiHD" }));


            #line default
            #line hidden
                WriteLiteral("\r\n        </p>\r\n");



                WriteLiteral("        <p>\r\n        Thời hạn HĐ\r\n        <select id=\"ThoiHanHD\">\r\n            <o" +
                             "ption></option>\r\n            <option>30 ngày</option>\r\n        </select>\r\n      " +
                             "  </p>\r\n");



                WriteLiteral("        <p>\r\n        Ngày hiệu lực\r\n        <span style=\"margin-left:36px\"></span" +
                             ">Từ ngày\r\n");



            #line 248 "..\..\Views\BaoCao\Index.cshtml"
                var NHLTu  = "";
                var NHLDen = "";
                try{
                    NHLTu = NHLTuNgay.Value.ToShortDateString();
                }catch {}
                try
                {
                    NHLDen = NHLDenNgay.Value.ToShortDateString();
                }
                catch { }



            #line default
            #line hidden
                WriteLiteral("        <input id=\"NHLTuNgay\" name = \"NHLTuNgay\" value = \"");



            #line 259 "..\..\Views\BaoCao\Index.cshtml"
                Write(NHLTu);


            #line default
            #line hidden
                WriteLiteral("\" type=\"text\" />\r\n        <span style=\"margin-left:10px\"></span>Đến ngày\r\n       " +
                             " <input id=\"NHLDenNgay\" name = \"NHLDenNgay\" value = \"");



            #line 261 "..\..\Views\BaoCao\Index.cshtml"
                Write(NHLDen);


            #line default
            #line hidden
                WriteLiteral("\" type=\"text\" />\r\n        </p>\r\n");



                WriteLiteral("        <p>\r\n        Ngày hết hiệu lực\r\n        <span style=\"margin-left:10px\"></" +
                             "span>Từ ngày\r\n");



            #line 266 "..\..\Views\BaoCao\Index.cshtml"
                var NHHLTu  = "";
                var NHHLDen = "";
                try{
                    NHHLTu = NHHLTuNgay.Value.ToShortDateString();
                }catch {}
                try
                {
                    NHHLDen = NHHLDenNgay.Value.ToShortDateString();
                }
                catch { }



            #line default
            #line hidden
                WriteLiteral("        <input id=\"NHHLTuNgay\" name = \"NHHLTuNgay\" value = \"");



            #line 277 "..\..\Views\BaoCao\Index.cshtml"
                Write(NHHLTu);


            #line default
            #line hidden
                WriteLiteral("\" type=\"text\" />\r\n        <span style=\"margin-left:10px\"></span>Đến ngày\r\n       " +
                             " <input id=\"NHHLDenNgay\" name = \"NHHLDenNgay\" value = \"");



            #line 279 "..\..\Views\BaoCao\Index.cshtml"
                Write(NHHLDen);


            #line default
            #line hidden
                WriteLiteral("\" type=\"text\" />\r\n        </p>\r\n");



                WriteLiteral("        <p>\r\n        NLĐ ký<span style=\"margin-left:35px\"></span>\r\n        ");



            #line 283 "..\..\Views\BaoCao\Index.cshtml"
                Write(Html.DropDownList("NLDKy", NLDKy_id, String.Empty, new { id = "NLDKy", name = "NLDKy" }));


            #line default
            #line hidden
                WriteLiteral("\r\n        </p>\r\n");



                WriteLiteral("        <p>\r\n        Trình HT<span style=\"margin-left:27px\"></span>\r\n        ");



            #line 287 "..\..\Views\BaoCao\Index.cshtml"
                Write(Html.DropDownList("TrinhHT", TrinhHT_id, String.Empty, new { id = "TrinhHT", name = "TrinhHT" }));


            #line default
            #line hidden
                WriteLiteral("\r\n        </p>\r\n");



                WriteLiteral("        <p>\r\n        HT ký<span style=\"margin-left:47px\"></span>\r\n        ");



            #line 291 "..\..\Views\BaoCao\Index.cshtml"
                Write(Html.DropDownList("HTKy", HTKy_id, String.Empty, new { id = "HTKy", name = "HTKy" }));


            #line default
            #line hidden
                WriteLiteral("\r\n        </p>\r\n");



                WriteLiteral("        <p>\r\n        Lưu<span style=\"margin-left:60px\"></span>\r\n        ");



            #line 295 "..\..\Views\BaoCao\Index.cshtml"
                Write(Html.DropDownList("Luu", Luu_id, String.Empty, new { id = "Luu", name = "Luu" }));


            #line default
            #line hidden
                WriteLiteral("\r\n        </p>\r\n");



                WriteLiteral("        <p>\r\n        Trả<span style=\"margin-left:64px\"></span>\r\n        ");



            #line 299 "..\..\Views\BaoCao\Index.cshtml"
                Write(Html.DropDownList("Tra", Tra_id, String.Empty, new { id = "Tra", name = "Tra" }));


            #line default
            #line hidden
                WriteLiteral("\r\n        </p>\r\n");



                WriteLiteral("        <p>\r\n");



            #line 302 "..\..\Views\BaoCao\Index.cshtml"
                if (HDLDCuoi == null)
                {
            #line default
            #line hidden
                    WriteLiteral("        <input id=\"HDLDCuoi\" name = \"HDLDCuoi\" type=\"checkbox\" />\r\n");



            #line 304 "..\..\Views\BaoCao\Index.cshtml"
                }
                else
                {
            #line default
            #line hidden
                    WriteLiteral("            <input id=\"HDLDCuoi\" name = \"HDLDCuoi\" checked = \"true\" type=\"checkbo" +
                                 "x\" />\r\n");



            #line 306 "..\..\Views\BaoCao\Index.cshtml"
                }

            #line default
            #line hidden
                WriteLiteral("HĐLĐ cuối\r\n        </p>\r\n");



                WriteLiteral("        <p>\r\n");



            #line 309 "..\..\Views\BaoCao\Index.cshtml"
                if (HDHetHan == null)
                {
            #line default
            #line hidden
                    WriteLiteral("        <input id=\"HDHetHan\" name = \"HDHetHan\" type=\"checkbox\" />\r\n");



            #line 312 "..\..\Views\BaoCao\Index.cshtml"
                }
                else
                {
            #line default
            #line hidden
                    WriteLiteral("            <input id=\"HDHetHan\" checked = \"true\" name = \"HDHetHan\" type=\"checkbo" +
                                 "x\" />\r\n");



            #line 315 "..\..\Views\BaoCao\Index.cshtml"
                }

            #line default
            #line hidden
                WriteLiteral("HĐ quá hạn chưa xử lý\r\n        </p>\r\n");



                WriteLiteral("        <p>\r\n");



            #line 318 "..\..\Views\BaoCao\Index.cshtml"
                if (HDSapHetHan == null)
                {
            #line default
            #line hidden
                    WriteLiteral("        <input id=\"HDSapHetHan\" name = \"HDSapHetHan\" type=\"checkbox\" />\r\n");



            #line 321 "..\..\Views\BaoCao\Index.cshtml"
                }
                else
                {
            #line default
            #line hidden
                    WriteLiteral("            <input id=\"HDSapHetHan\" checked = \"true\" name = \"HDSapHetHan\" type=\"c" +
                                 "heckbox\" />\r\n");



            #line 324 "..\..\Views\BaoCao\Index.cshtml"
                }

            #line default
            #line hidden
                WriteLiteral("HĐ sắp hết hạn\r\n        </p>\r\n");



                WriteLiteral("            <input id=\"Submit1\" type=\"submit\" value=\"Lọc\" style = \"width:100px\" /" +
                             ">\r\n");



            #line 327 "..\..\Views\BaoCao\Index.cshtml"
                if (cts.Count() <= 0)
                {
            #line default
            #line hidden
                    WriteLiteral("              <input id=\"btnCauHinh\" type=\"button\" disabled = \"true\" value=\"Xuất " +
                                 "excel\" />\r\n");



            #line 330 "..\..\Views\BaoCao\Index.cshtml"
                }
                else
                {
                    var listXuatExcel = new List <hdChiTietHDLD>();
                    foreach (var item in cts)
                    {
                        listXuatExcel.Add(item);
                    }
                    TempData["listXuatExcel"] = listXuatExcel;


            #line default
            #line hidden
                    WriteLiteral("                <a href=\"");



            #line 339 "..\..\Views\BaoCao\Index.cshtml"
                    Write(Url.Action("Index", "XuatExcel"));


            #line default
            #line hidden
                    WriteLiteral("\">\r\n                    <input id=\"btnCauHinh\" type=\"button\" value=\"Xuất excel\" /" +
                                 "></a>\r\n");



            #line 341 "..\..\Views\BaoCao\Index.cshtml"
                }
            }


            #line default
            #line hidden
            WriteLiteral("    </div>\r\n\r\n</div>\r\n\r\n<div style=\"padding: 0; width:1000px;margin-left:-13%\">\r\n" +
                         "<table id =\"BaoCaoView\">\r\n<thead>\r\n    <tr>\r\n        <th style=\"text-align:cente" +
                         "r\" >\r\n            STT\r\n        </th>\r\n        <th style=\"text-align:center\">\r\n  " +
                         "          Họ và tên\r\n        </th>\r\n        <th style=\"text-align:center\" >\r\n   " +
                         "         Đơn<br />vị\r\n        </th>\r\n        <th style=\"text-align:center\" >\r\n  " +
                         "          Chức danh CM\r\n        </th>\r\n        <th style=\"text-align:center\" >\r\n" +
                         "            Số HĐ\r\n        </th>\r\n        <th style=\"text-align:center\" >\r\n     " +
                         "       Loại HĐ\r\n        </th>\r\n        <th style=\"text-align:center\" >\r\n        " +
                         "    Thời hạn HĐ\r\n        </th>\r\n        <th style=\"text-align:center\" >\r\n       " +
                         "     Ngày hiệu<br />lực\r\n        </th>\r\n        <th style=\"text-align:center\" >\r" +
                         "\n            Ngày hết<br />hiệu lực\r\n        </th>\r\n        <th style=\"text-alig" +
                         "n:center\" >\r\n            Ngày NLĐ ký\r\n        </th>\r\n        <th style=\"text-ali" +
                         "gn:center\" >\r\n            Ngày trình HT\r\n        </th>\r\n        <th style=\"text-" +
                         "align:center\" >\r\n            Ngày HT ký\r\n        </th>\r\n        <th style=\"text-" +
                         "align:center\" >\r\n            Ngày lưu\r\n        </th>\r\n        <th style=\"text-al" +
                         "ign:center\" >\r\n            Ngày trả\r\n        </th>\r\n        <th style=\"text-alig" +
                         "n:center\" >\r\n            Lương cơ bản\r\n        </th>\r\n        <th style=\"text-al" +
                         "ign:center\" >\r\n            Hệ số lương\r\n        </th>\r\n        <th style=\"text-a" +
                         "lign:center\" >\r\n            Bậc \r\n        </th>\r\n        <th style=\"text-align:c" +
                         "enter\" >\r\n            Ngạch\r\n        </th>\r\n        <th style=\"text-align:center" +
                         "\" >\r\n            Nhóm\r\n        </th>\r\n        <th style=\"text-align:center\" >\r\n " +
                         "           Bảng lương\r\n        </th>\r\n    </tr>\r\n</thead>\r\n<tbody>\r\n");



            #line 414 "..\..\Views\BaoCao\Index.cshtml"
            int count = 0;


            #line default
            #line hidden


            #line 415 "..\..\Views\BaoCao\Index.cshtml"
            foreach (var item in cts)
            {
                count = count + 1;


            #line default
            #line hidden
                WriteLiteral("    <tr>\r\n    <td style=\"text-align:center\">\r\n    ");



            #line 420 "..\..\Views\BaoCao\Index.cshtml"
                Write(count);


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n    <td style=\"text-align:center\"  >\r\n    ");



            #line 423 "..\..\Views\BaoCao\Index.cshtml"
                Write(Html.DisplayFor(model => item.HotenNLD));


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n");



            #line 425 "..\..\Views\BaoCao\Index.cshtml"
                string tenDonVi = "";
                if (item.Donvi_id != null)
                {
                    int?Donvi_id = item.Donvi_id;
                    tenDonVi = db0.dmDonVi.Where(dv => dv.id == Donvi_id).First().tenDonVi;
                }



            #line default
            #line hidden
                WriteLiteral("    <td style=\"text-align: center\" data-tip=\"");



            #line 432 "..\..\Views\BaoCao\Index.cshtml"
                Write(tenDonVi);


            #line default
            #line hidden
                WriteLiteral("\">\r\n");



            #line 433 "..\..\Views\BaoCao\Index.cshtml"
                string maDonVi = "";
                if (item.Donvi_id != null)
                {
                    int?Donvi_id = item.Donvi_id;
                    maDonVi = db0.dmDonVi.Where(dv => dv.id == Donvi_id).First().maDonVi;
                }


            #line default
            #line hidden

            #line 439 "..\..\Views\BaoCao\Index.cshtml"
                Write(Html.DisplayFor(model => maDonVi));


            #line default
            #line hidden

            #line 439 "..\..\Views\BaoCao\Index.cshtml"



            #line default
            #line hidden
                WriteLiteral("    </td>\r\n    <td style=\"text-align:center\"  >\r\n");



            #line 443 "..\..\Views\BaoCao\Index.cshtml"
                string tenChucDanh = "";
                if (item.Chucdanh_id != null)
                {
                    int?ChucDanh_id = item.Chucdanh_id;
                    tenChucDanh = db0.dmChucDanhChuyenMon.Where(dv => dv.id == ChucDanh_id).First().tenChucDanhChuyenMon;
                }


            #line default
            #line hidden

            #line 449 "..\..\Views\BaoCao\Index.cshtml"
                Write(Html.Raw(tenChucDanh));


            #line default
            #line hidden

            #line 449 "..\..\Views\BaoCao\Index.cshtml"



            #line default
            #line hidden
                WriteLiteral("    </td>\r\n    <td style=\"text-align:center\"  >\r\n        ");



            #line 453 "..\..\Views\BaoCao\Index.cshtml"
                Write(Html.DisplayFor(model => item.SoHD));


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n    <td style=\"text-align:center\"  >\r\n        ");



            #line 456 "..\..\Views\BaoCao\Index.cshtml"
                Write(Html.DisplayFor(model => item.LoaiHD));


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n    <td style=\"text-align:center\"  >\r\n");



            #line 459 "..\..\Views\BaoCao\Index.cshtml"
                int THHD_id    = item.ThoihanHD_id;
                var tenThoiHan = db.dmThoiHanHD.Where(th => th.id == THHD_id).FirstOrDefault().tenThoiHanHD;


            #line default
            #line hidden
                WriteLiteral("        ");



            #line 461 "..\..\Views\BaoCao\Index.cshtml"
                Write(Html.DisplayFor(model => tenThoiHan));


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n    <td style=\"text-align:center\">\r\n        ");



            #line 464 "..\..\Views\BaoCao\Index.cshtml"
                Write(item.NgayHL.ToShortDateString());


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n    <td style=\"text-align:center\">\r\n");



            #line 467 "..\..\Views\BaoCao\Index.cshtml"
                try
                {
            #line default
            #line hidden

            #line 469 "..\..\Views\BaoCao\Index.cshtml"
                    Write(item.NgayhetHL.Value.ToShortDateString());


            #line default
            #line hidden

            #line 469 "..\..\Views\BaoCao\Index.cshtml"
                }
                catch
                {
            #line default
            #line hidden

            #line 472 "..\..\Views\BaoCao\Index.cshtml"
                    Write(item.NgayhetHL);


            #line default
            #line hidden

            #line 472 "..\..\Views\BaoCao\Index.cshtml"
                }


            #line default
            #line hidden
                WriteLiteral("    </td>\r\n    <td style=\"text-align:center\">\r\n");



            #line 475 "..\..\Views\BaoCao\Index.cshtml"
                if (item.QT_NgayNLDky == null)
                {
            #line default
            #line hidden

            #line 477 "..\..\Views\BaoCao\Index.cshtml"
                    Write(item.QT_NLDky);


            #line default
            #line hidden

            #line 477 "..\..\Views\BaoCao\Index.cshtml"
                }
                else
                {
                    try
                    {
            #line default
            #line hidden

            #line 482 "..\..\Views\BaoCao\Index.cshtml"
                        Write(item.QT_NgayNLDky.Value.ToShortDateString());


            #line default
            #line hidden

            #line 482 "..\..\Views\BaoCao\Index.cshtml"
                    }
                    catch
                    {
            #line default
            #line hidden

            #line 484 "..\..\Views\BaoCao\Index.cshtml"
                        Write(item.QT_NgayNLDky);


            #line default
            #line hidden

            #line 484 "..\..\Views\BaoCao\Index.cshtml"
                    }
                }


            #line default
            #line hidden
                WriteLiteral("    </td>\r\n    <td style=\"text-align:center\">\r\n");



            #line 489 "..\..\Views\BaoCao\Index.cshtml"
                if (item.QT_NgayTrinhHT == null)
                {
            #line default
            #line hidden

            #line 491 "..\..\Views\BaoCao\Index.cshtml"
                    Write(item.QT_TrinhHT);


            #line default
            #line hidden

            #line 491 "..\..\Views\BaoCao\Index.cshtml"
                }
                else
                {
                    try
                    {
            #line default
            #line hidden

            #line 496 "..\..\Views\BaoCao\Index.cshtml"
                        Write(item.QT_NgayTrinhHT.Value.ToShortDateString());


            #line default
            #line hidden

            #line 496 "..\..\Views\BaoCao\Index.cshtml"
                    }
                    catch
                    {
            #line default
            #line hidden

            #line 498 "..\..\Views\BaoCao\Index.cshtml"
                        Write(item.QT_NgayTrinhHT);


            #line default
            #line hidden

            #line 498 "..\..\Views\BaoCao\Index.cshtml"
                    }
                }


            #line default
            #line hidden
                WriteLiteral("    </td>\r\n    <td style=\"text-align:center\">\r\n");



            #line 503 "..\..\Views\BaoCao\Index.cshtml"
                if (item.QT_NgayHTky == null)
                {
            #line default
            #line hidden

            #line 505 "..\..\Views\BaoCao\Index.cshtml"
                    Write(item.QT_HTky);


            #line default
            #line hidden

            #line 505 "..\..\Views\BaoCao\Index.cshtml"
                }
                else
                {
                    try
                    {
            #line default
            #line hidden

            #line 510 "..\..\Views\BaoCao\Index.cshtml"
                        Write(item.QT_NgayHTky.Value.ToShortDateString());


            #line default
            #line hidden

            #line 510 "..\..\Views\BaoCao\Index.cshtml"
                    }
                    catch
                    {
            #line default
            #line hidden

            #line 512 "..\..\Views\BaoCao\Index.cshtml"
                        Write(item.QT_NgayHTky);


            #line default
            #line hidden

            #line 512 "..\..\Views\BaoCao\Index.cshtml"
                    }
                }


            #line default
            #line hidden
                WriteLiteral("        \r\n    </td>\r\n    <td style=\"text-align:center\">\r\n");



            #line 518 "..\..\Views\BaoCao\Index.cshtml"
                if (item.QT_NgayLuuHS == null)
                {
            #line default
            #line hidden

            #line 520 "..\..\Views\BaoCao\Index.cshtml"
                    Write(item.QT_LuuHS);


            #line default
            #line hidden

            #line 520 "..\..\Views\BaoCao\Index.cshtml"
                }
                else
                {
                    try
                    {
            #line default
            #line hidden

            #line 525 "..\..\Views\BaoCao\Index.cshtml"
                        Write(item.QT_NgayLuuHS.Value.ToShortDateString());


            #line default
            #line hidden

            #line 525 "..\..\Views\BaoCao\Index.cshtml"
                    }
                    catch
                    {
            #line default
            #line hidden

            #line 527 "..\..\Views\BaoCao\Index.cshtml"
                        Write(item.QT_NgayLuuHS);


            #line default
            #line hidden

            #line 527 "..\..\Views\BaoCao\Index.cshtml"
                    }
                }


            #line default
            #line hidden
                WriteLiteral("    </td>\r\n    <td style=\"text-align:center\">  \r\n");



            #line 532 "..\..\Views\BaoCao\Index.cshtml"
                if (item.QT_NgayTraNLD == null)
                {
            #line default
            #line hidden

            #line 534 "..\..\Views\BaoCao\Index.cshtml"
                    Write(item.QT_TraNLD);


            #line default
            #line hidden

            #line 534 "..\..\Views\BaoCao\Index.cshtml"
                }
                else
                {
                    try
                    {
            #line default
            #line hidden

            #line 539 "..\..\Views\BaoCao\Index.cshtml"
                        Write(item.QT_NgayTraNLD.Value.ToShortDateString());


            #line default
            #line hidden

            #line 539 "..\..\Views\BaoCao\Index.cshtml"
                    }
                    catch
                    {
            #line default
            #line hidden

            #line 541 "..\..\Views\BaoCao\Index.cshtml"
                        Write(item.QT_NgayTraNLD);


            #line default
            #line hidden

            #line 541 "..\..\Views\BaoCao\Index.cshtml"
                    }
                }


            #line default
            #line hidden
                WriteLiteral("    </td>\r\n    <td style=\"text-align:center\">\r\n        ");



            #line 546 "..\..\Views\BaoCao\Index.cshtml"
                Write(item.Mucluongchinh);


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n");



            #line 548 "..\..\Views\BaoCao\Index.cshtml"

                double?HeSo  = null;
                var    Bac   = "";
                var    Ngach = "";
                var    Nhom  = "";


                int?nHSLuong_id = item.HSLuong_id;
                int?nNgach_id   = item.Ngach_id;
                int?nNhom_id    = item.Nhom_id;
                try
                {
                    HeSo = db0.dmBangLuong.Where(bl => bl.id == nHSLuong_id).FirstOrDefault().hesoLuong;
                }
                catch
                {
                }
                try
                {
                    Bac = db0.dmBangLuong.Where(bl => bl.id == nHSLuong_id).FirstOrDefault().bacLuong;
                }
                catch
                {
                }
                try
                {
                    Ngach = db0.dmNgachVienChuc.Where(bl => bl.id == nNgach_id).FirstOrDefault().tenNgachVienChuc;
                }
                catch
                {
                }
                try
                {
                    Nhom = db0.dmNhomNgachVienChuc.Where(bl => bl.id == nNhom_id).FirstOrDefault().tenNhomNgachVienChuc;
                }
                catch
                {
                }



            #line default
            #line hidden
                WriteLiteral("    <td style=\"text-align:center\">\r\n    ");



            #line 588 "..\..\Views\BaoCao\Index.cshtml"
                Write(Html.Raw(HeSo));


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n    <td style=\"text-align:center\">\r\n    ");



            #line 591 "..\..\Views\BaoCao\Index.cshtml"
                Write(Html.Raw(Bac));


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n    <td style=\"text-align:center\">\r\n    ");



            #line 594 "..\..\Views\BaoCao\Index.cshtml"
                Write(Html.Raw(Ngach));


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n    <td style=\"text-align:center\">\r\n    ");



            #line 597 "..\..\Views\BaoCao\Index.cshtml"
                Write(Html.Raw(Ngach));


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n    <td style=\"text-align:center\">\r\n    ");



            #line 600 "..\..\Views\BaoCao\Index.cshtml"
                Write(item.Bangluong_id);


            #line default
            #line hidden
                WriteLiteral("\r\n    </td>\r\n    </tr>\r\n");



            #line 603 "..\..\Views\BaoCao\Index.cshtml"
            }


            #line default
            #line hidden


            #line 604 "..\..\Views\BaoCao\Index.cshtml"
            if (cts.Count() == 0)
            {
            #line default
            #line hidden
                WriteLiteral(@"<tr>
        <td colspan = 20 style = ""text-align:center"">Không có dữ liệu!</td>
        <td></td>
        <td></td>
        <td></td>
        <td></td>
        <td></td>
        <td></td>
        <td></td>
        <td></td>
        <td></td>
        <td></td>
        <td></td>
        <td></td>
        <td></td>
        <td></td>
        <td></td>
        <td></td>
        <td></td>
        <td></td>
        <td></td>
</tr>
");



            #line 628 "..\..\Views\BaoCao\Index.cshtml"
            }


            #line default
            #line hidden
            WriteLiteral("</tbody>\r\n</table>\r\n</div>\r\n<style>\r\n    table\r\n    {\r\n        overflow: auto;\r\n " +
                         "       width: 100%;\r\n        display: block;\r\n    }\r\n    input\r\n    {\r\n        m" +
                         "argin: 0 0 0 0;\r\n    }\r\n    td\r\n    {\r\n        padding: 0;\r\n    }\r\n    .ui-state" +
                         "-hover\r\n    {\r\n        font-weight: normal !important;\r\n    }\r\n</style>\r\n<style>" +
                         "\r\n    td\r\n    {\r\n        padding: 0 0 0 0;\r\n    }\r\n    input\r\n    {\r\n        mar" +
                         "gin: 0 0 0 0;\r\n        width: auto;\r\n    }\r\n</style>\r\n<script>\r\n    $().ready(fu" +
                         "nction () {\r\n        var table$ = $(\"#BaoCaoView\");\r\n        table$.find(\"th\").e" +
                         "ach(function () {\r\n            $(this).addClass(\"ui-state-default\");\r\n        })" +
                         ";\r\n        table$.find(\"td\").each(function () {\r\n            $(this).addClass(\"u" +
                         "i-widget-content\");\r\n        });\r\n    });\r\n</script>\r\n\r\n<style>\r\n    .ui-tabs .u" +
                         "i-tabs-nav li a\r\n    {\r\n        padding: .5em .5em;\r\n    }\r\n</style>\r\n\r\n<script>" +
                         "\r\n    $(function () {\r\n        $(\"#BaoCao\").accordion({\r\n            header: \"h3" +
                         ":not(.ignore)\",\r\n            collapsible: true,\r\n            heightStyle: \"conte" +
                         "nt\"\r\n        });\r\n    });\r\n</script>\r\n\r\n\r\n\r\n<script>\r\n    $(\"#HoVaTen\").combobox" +
                         "().parent().find(\"input.ui-autocomplete-input\").css(\"width\", \"250px\");\r\n    $(\"#" +
                         "DonVi\").combobox().parent().find(\"input.ui-autocomplete-input\").css(\"width\", \"25" +
                         "0px\");\r\n    $(\"#LoaiHD\").combobox().parent().find(\"input.ui-autocomplete-input\")" +
                         ".css(\"width\", \"250px\");\r\n    $(\"#ThoiHanHD\").combobox().parent().find(\"input.ui-" +
                         "autocomplete-input\").css(\"width\", \"250px\");\r\n    $(\"#NLDKy\").combobox().parent()" +
                         ".find(\"input.ui-autocomplete-input\").css(\"width\", \"250px\");\r\n    $(\"#TrinhHT\").c" +
                         "ombobox().parent().find(\"input.ui-autocomplete-input\").css(\"width\", \"250px\");\r\n " +
                         "   $(\"#HTKy\").combobox().parent().find(\"input.ui-autocomplete-input\").css(\"width" +
                         "\", \"250px\");\r\n    $(\"#Luu\").combobox().parent().find(\"input.ui-autocomplete-inpu" +
                         "t\").css(\"width\", \"250px\");\r\n    $(\"#Tra\").combobox().parent().find(\"input.ui-aut" +
                         "ocomplete-input\").css(\"width\", \"250px\");\r\n\r\n    $(\".custom-combobox-input\").remo" +
                         "veClass(\"ui-state-default\");\r\n    $(\".custom-combobox-input\").removeClass(\"ui-wi" +
                         "dget-content\");\r\n    $(\".custom-combobox-width\").removeClass(\"ui-width-default\")" +
                         ";\r\n    $(\".custom-combobox-input\").removeClass(\"ui-corner-left\");\r\n    $(\".custo" +
                         "m-combobox-toggle\").removeClass(\"ui-state-default\");\r\n    $(function () {\r\n     " +
                         "   $(\"[id=NHLTuNgay]\").datepicker({\r\n            changeMonth: true,\r\n           " +
                         " changeYear: true,\r\n            dateFormat: \"dd/mm/yy\",\r\n            yearRange: " +
                         "\'c-100:c+100\'\r\n        });\r\n        $(\"[id=NHLDenNgay]\").datepicker({\r\n         " +
                         "   changeMonth: true,\r\n            changeYear: true,\r\n            dateFormat: \"d" +
                         "d/mm/yy\",\r\n            yearRange: \'c-100:c+100\'\r\n        });\r\n        $(\"[id=NHH" +
                         "LTuNgay]\").datepicker({\r\n            changeMonth: true,\r\n            changeYear:" +
                         " true,\r\n            dateFormat: \"dd/mm/yy\",\r\n            yearRange: \'c-100:c+100" +
                         "\'\r\n        });\r\n        $(\"[id=NHHLDenNgay]\").datepicker({\r\n            changeMo" +
                         "nth: true,\r\n            changeYear: true,\r\n            dateFormat: \"dd/mm/yy\",\r\n" +
                         "            yearRange: \'c-100:c+100\'\r\n        });\r\n    });\r\n\r\n    $(\"#Filter\").f" +
                         "ind(\"input[type=datetime]\").css(\"width\", \"80px\")\r\n            .datepicker({ chan" +
                         "geMonth: true, changeYear: true });\r\n</script>\r\n\r\n");
        }