Example #1
0
        public ActionResult ExportIns_ReportInsuranceTrackingMonthly([DataSourceRequest] DataSourceRequest request, Ins_ReportInsuranceTrackingMonthlySearchModel model)
        {

            var services = new Ins_InsuranceReportServices();
            var result = services.Ins_ReportInsuranceTrackingMonthlyLoadData(model.OrgStructureID, model.MonthYearFrom, model.MonthYearTo, model.IsProfileQuit, model.CodeEmp, model.WorkPlaceIDs,UserLogin);
            var lstModel = new List<Ins_ReportInsuranceTrackingMonthlySearchModel>();
            if (result != null)
            {
                lstModel = result.Translate<Ins_ReportInsuranceTrackingMonthlySearchModel>();
                //  return Json(lstModel, JsonRequestBehavior.AllowGet);
            }
            var isDataTable = false;
            object obj = new Ins_ReportInsuranceTrackingMonthlySearchModel();

            if (model.IsCreateTemplateForDynamicGrid)
            {
                obj = result;
                isDataTable = true;
            }
            if (model.IsCreateTemplate)
            {
                var path = Common.GetPath("Templates");
                ExportService exportService = new ExportService();
                ConfigExport cfgExport = new ConfigExport()
                {
                    Object = obj,
                    FileName = "Ins_ReportInsuranceTrackingMonthly",
                    OutPutPath = path,
                    DownloadPath = "Templates",
                    IsDataTable = isDataTable

                };
                var str = exportService.CreateTemplate(cfgExport);
                return Json(str);
            }
            if (model.ExportId.HasValue && model.ExportId.Value != Guid.Empty)
            {
                var fullPath = ExportService.Export(model.ExportId.Value, result, null, ExportFileType.Excel);
                return Json(fullPath);
            }
            return Json(lstModel.ToDataSourceResult(request));
        }
Example #2
0
        /// <summary> BC Đủ Điều Kiện Tham Gia Bảo Hiểm Theo Tháng </summary>
        /// <param name="request"></param>
        /// <param name="model"></param>
        /// <returns></returns>
        public ActionResult ReportJoinInsuranceMonthly([DataSourceRequest] DataSourceRequest request, Ins_ReportJoinInsuranceMonthlyModel model)
        {
            var services = new Ins_InsuranceReportServices();
            List<HeaderInfo> listHeaderInfo = null;
            var result = services.ReportJoinInsuranceMonthly(model.OrgStructureID, model.MonthYear.Value, model.CodeEmp, model.SocialInsPlaceIDs,UserLogin);
            var lstModel = new List<Ins_ReportJoinInsuranceMonthlyModel>();
            if (result != null)
            {
                lstModel = result.Translate<Ins_ReportJoinInsuranceMonthlyModel>();
                lstModel = lstModel.OrderBy(p => p.STT).ToList();
            }
            var isDataTable = false;
            object obj = new Ins_ReportJoinInsuranceMonthlyModel();

            #region Header Info
            var codeEmp = string.Empty;
            if (model != null && model.UserID != Guid.Empty)
            {
                Hre_ProfileServices profileService = new Hre_ProfileServices();
                var profile = profileService.GetProfileInfo(model.UserID,UserLogin);
                if (profile != null && !string.IsNullOrEmpty(profile.CodeEmp))
                {
                    codeEmp = profile.CodeEmp;
                }
            }
            HeaderInfo headerInfoMonthYear = new HeaderInfo() { Name = "MonthYear", Value = model.MonthYear };
            HeaderInfo headerInfoCurrentDate = new HeaderInfo() { Name = "CurrentDate", Value = DateTime.Now };
            HeaderInfo headerInfoCodeEmp = new HeaderInfo() { Name = "CodeEmp", Value = codeEmp };
            listHeaderInfo = new List<HeaderInfo>() { headerInfoMonthYear, headerInfoCurrentDate, headerInfoCodeEmp };
            #endregion

            if (model.IsCreateTemplateForDynamicGrid)
            {
                obj = result;
                isDataTable = true;
            }
            if (model != null && model.IsCreateTemplate)
            {
                var path = Common.GetPath("Templates");
                ExportService exportService = new ExportService();
                ConfigExport cfgExport = new ConfigExport()
                {
                    Object = obj,
                    FileName = "Ins_ReportJoinInsuranceMonthlySearchModel",
                    OutPutPath = path,
                    HeaderInfo = listHeaderInfo,
                    DownloadPath = "Templates",
                    IsDataTable = isDataTable

                };
                var str = exportService.CreateTemplate(cfgExport);
                return Json(str);
            }
            if (model.ExportId != Guid.Empty)
            {
                var fullPath = ExportService.Export(model.ExportId, lstModel, listHeaderInfo, model.ExportType);
                return Json(fullPath.ToString().Replace("Success,", "").ToString());
            }
            return Json(lstModel.ToDataSourceResult(request));
        }
Example #3
0
        /// <summary> BC Dữ Liệu HDTJob Lần 2 </summary>
        /// <param name="request"></param>
        /// <param name="model"></param>
        /// <returns></returns>
        public ActionResult Ins_ReportEmpHardJob2nd([DataSourceRequest] DataSourceRequest request, Ins_ReportEmpHardJob2ndModel model)
        {
            var services = new Ins_InsuranceReportServices();
          //  var result = services.LoadDataD03(model.All, model.Increase, model.Descrease, model.MonthYear, model.OrgStructureID, model.SearchNoteType, model.SearchStatus, model.CodeEmp, model.WorkPlaceIDs);
            var result = services.ReportEmpHardJob2nd(model.OrgStructureID, model.MonthYear.Value,UserLogin).Translate<Ins_ReportEmpHardJob2ndModel>();
            result = result.OrderBy(m => m.Stt).ToList();
            var lstModel = new List<Ins_ReportEmpHardJob2ndModel>();
            if (result != null)
            {
                foreach (var item in result)
                {
                    var rptD02Model = new Ins_ReportEmpHardJob2ndModel();
                    rptD02Model = item.Copy<Ins_ReportEmpHardJob2ndModel>();
                    lstModel.Add(rptD02Model);
                }
            }
            var isDataTable = false;
            object obj = new Ins_ReportEmpHardJob2ndModel();

            if (model.IsCreateTemplateForDynamicGrid)
            {
                obj = result;
                isDataTable = true;
            }
            if (model != null && model.IsCreateTemplate)
            {
                var path = Common.GetPath("Templates");
                ExportService exportService = new ExportService();
                ConfigExport cfgExport = new ConfigExport()
                {
                    Object = obj,
                    FileName = "Ins_ReportEmpHardJob2ndSearchModel",
                    OutPutPath = path,
                    DownloadPath = "Templates",
                    IsDataTable = isDataTable
                };
                var str = exportService.CreateTemplate(cfgExport);
                return Json(str);
            }
            if (model.ExportId != Guid.Empty)
            {
                var fullPath = ExportService.Export(model.ExportId, lstModel, null, model.ExportType);
                return Json(fullPath.ToString().Replace("Success,", "").ToString());
            }
            return Json(lstModel.ToDataSourceResult(request));
        }
Example #4
0
        public JsonResult GetIns_ReportInsuranceTrackingMonthly([DataSourceRequest] DataSourceRequest request, Ins_ReportInsuranceTrackingMonthlySearchModel model)
        {
            try
            {
                if (!string.IsNullOrEmpty(model.StrSocialInsPlaceIDs))
                {
                    var socialInsPlaceIDs = model.StrSocialInsPlaceIDs.Split(',');
                    List<Guid> socailInsPlaceIDsTemp = new List<Guid>();
                    if (socialInsPlaceIDs.Length > 0)
                    {
                        foreach (var item in socialInsPlaceIDs)
                        {
                            Guid gTemp = new Guid();
                            gTemp = Guid.Empty;
                            Guid.TryParse(item, out gTemp);
                            if (gTemp != Guid.Empty)
                            {
                                socailInsPlaceIDsTemp.Add(gTemp);
                            }
                        }
                        if (socailInsPlaceIDsTemp.Any())
                        {
                            model.SocialInsPlaceIDs = socailInsPlaceIDsTemp;
                        }
                    }
                }


                var service = new Ins_InsuranceReportServices();
                var result = service.Ins_ReportInsuranceTrackingMonthlyLoadData(model.OrgStructureID, model.MonthYearFrom, model.MonthYearTo, model.IsProfileQuit, model.CodeEmp, model.SocialInsPlaceIDs,UserLogin);
                return Json(result.ToDataSourceResult(request));
            }
            catch
            {
                return Json(null);
            }
        }
Example #5
0
 /// <summary>Lấy ngày chốt BH (từ cấu hình )</summary>
 /// <returns></returns>
 public ActionResult GetPeriodInsuranceDay()
 {
     var service = new Ins_InsuranceReportServices();
     var periodInsDayCurrentMonth = service.PeriodInsuranceDayCurrentMonth;
     return Json(periodInsDayCurrentMonth, JsonRequestBehavior.AllowGet);
 }
Example #6
0
        public ActionResult GetReportEmpHardJobList([DataSourceRequest] DataSourceRequest request, Ins_ReportEmpHardJobSearchModel model)
        {
            string status = string.Empty;
            var ReportServices = new Ins_InsuranceReportServices();
            DateTime _DateFrom = DateTime.MinValue;
            DateTime _DateTo = DateTime.MaxValue;
            if (model != null && model.DateFrom != null)
            {
                _DateFrom = model.DateFrom.Value;
            }
            if (model != null && model.DateTo != null)
            {
                _DateTo = model.DateTo.Value;
            }
            var result = ReportServices.BC_EmpHardJob(_DateFrom, _DateTo, model.OrgStructureID);
            var isDataTable = false;
            object obj = new DataTable();
            if (model.IsCreateTemplateForDynamicGrid)
            {
                var col = result.Columns.Count;
                result.Columns.RemoveAt(col - 1);
                obj = result;
                isDataTable = true;
            }
            if (model != null && model.IsCreateTemplate)
            {
                var path = Common.GetPath("Templates");
                ExportService exportService = new ExportService();
                ConfigExport cfgExport = new ConfigExport()
                {
                    Object = obj,
                    FileName = "Ins_ReportEmpHardJoblEntity",
                    OutPutPath = path,
                    DownloadPath = Hrm_Main_Web + "Templates",
                    IsDataTable = isDataTable

                };
                var str = exportService.CreateTemplate(cfgExport);
                return Json(str);
            }
            if (model.ExportId != Guid.Empty)
            {
                var fullPath = ExportService.Export(model.ExportId, result, null, model.ExportType);
                return Json(fullPath);
            }
            return new JsonResult() { Data = result.ToDataSourceResult(request), MaxJsonLength = int.MaxValue };
        }
Example #7
0
        public ActionResult GetReportInsuranceList([DataSourceRequest] DataSourceRequest request, Ins_ReportInsuranceTotalSearchModel model)
        {
            string status = string.Empty;
            //var isDataTable = false;
            var service = new BaseService();
            //object obj = new Hre_ProfileModel();
            ListQueryModel lstModel = new ListQueryModel
            {
                PageSize = int.MaxValue - 1,
                PageIndex = 1,
                Filters = ExtractFilterAttributes(request),
                Sorts = ExtractSortAttributes(request),
                AdvanceFilters = ExtractAdvanceFilterAttributes(model)
            };
            //    List<Hre_ProfileEntity> listProfile = service.GetData<Hre_ProfileEntity>(lstModel, ConstantSql.hrm_sal_sp_getdata_Profile, ref status);
            var ReportServices = new Ins_InsuranceReportServices();
            DateTime _DateFrom = DateTime.MinValue;
            DateTime _DateTo = DateTime.MaxValue;
            if (model != null && model.DateFrom != null)
            {
                _DateFrom = model.DateFrom.Value;
            }
            if (model != null && model.DateTo != null)
            {
                _DateTo = model.DateTo.Value;
            }
            var result = ReportServices.BC_INSURANCETOTAL(_DateFrom, _DateTo, model.OrgStructureIDs, model.SocialInsPlaceIDs, UserLogin);
            var isDataTable = false;
            object obj = new DataTable();
            if (model.IsCreateTemplateForDynamicGrid)
            {
                var col = result.Columns.Count;
                result.Columns.RemoveAt(col - 1);
                obj = result;
                isDataTable = true;
            }
            if (model != null && model.IsCreateTemplate)
            {
                var path = Common.GetPath("Templates");
                ExportService exportService = new ExportService();
                ConfigExport cfgExport = new ConfigExport()
                {
                    Object = obj,
                    FileName = "Ins_ReportInsuranceTotalEntity",
                    OutPutPath = path,
                    DownloadPath = Hrm_Main_Web + "Templates",
                    IsDataTable = isDataTable

                };
                var str = exportService.CreateTemplate(cfgExport);
                return Json(str);
            }
            if (model.ExportId != Guid.Empty)
            {
                var fullPath = ExportService.Export(model.ExportId, result, null, model.ExportType);
                return Json(fullPath);
            }
            //return new JsonResult() { Data = result.ToDataSourceResult(request), MaxJsonLength = int.MaxValue };
            #region mapping dataTable to dataList
            List<Ins_ReportInsuranceTotalModel> dataList = new List<Ins_ReportInsuranceTotalModel>();
            Ins_ReportInsuranceTotalModel aTSource = null;

            if (result.Rows.Count > 0)
            {
                const BindingFlags flags = BindingFlags.Public | BindingFlags.Instance | BindingFlags.NonPublic;
                var objFieldNames = (from PropertyInfo aProp in typeof(Ins_ReportInsuranceTotalModel).GetProperties(flags)
                                     select new
                                     {
                                         Name = aProp.Name,
                                         Type = Nullable.GetUnderlyingType(aProp.PropertyType) ?? aProp.PropertyType
                                     }).ToList();
                var dataTblFieldNames = (from DataColumn aHeader in result.Columns
                                         select new { Name = aHeader.ColumnName, Type = aHeader.DataType }).ToList();
                var commonFields = objFieldNames.Intersect(dataTblFieldNames).ToList();
                foreach (DataRow dataRow in result.AsEnumerable().ToList())
                {
                    aTSource = new Ins_ReportInsuranceTotalModel();
                    foreach (var aField in commonFields)
                    {
                        PropertyInfo propertyInfos = aTSource.GetType().GetProperty(aField.Name);
                        if (dataRow[aField.Name] == DBNull.Value)
                            continue;
                        propertyInfos.SetValue(aTSource, dataRow[aField.Name], null);
                    }
                    dataList.Add(aTSource);
                }
            }
            #endregion
            return Json(dataList.ToDataSourceResult(request));
        }
Example #8
0
        public ActionResult GetReportC70A([DataSourceRequest] DataSourceRequest request, Ins_SearchC70AReportModel model)
        {
            var isDataTable = false;
            object obj = new Ins_C70aReportEntity();
            var service = new Ins_InsuranceReportServices();
            ListQueryModel lstModel = new ListQueryModel
            {
                PageIndex = request.Page,
                PageSize = request.PageSize,
                Filters = ExtractFilterAttributes(request),
                Sorts = ExtractSortAttributes(request)
            };

            var result = service.GetReportC70A(model.DateMonth, model.DateStart, model.DateEnd, model.OrgStructureID, model.CutOffDurationName, model.IsCreateTemplate);
            if (model.IsCreateTemplateForDynamicGrid)
            {
                obj = result;
                isDataTable = true;
            }
            if (model != null && model.IsCreateTemplate)
            {
                var path = Common.GetPath("Templates");
                ExportService exportService = new ExportService();
                ConfigExport cfgExport = new ConfigExport()
                {
                    Object = obj,
                    FileName = "Ins_C70aReportModel",
                    OutPutPath = path,
                    DownloadPath = Hrm_Main_Web + "Templates",
                    IsDataTable = isDataTable

                };
                var str = exportService.CreateTemplate(cfgExport);
                return Json(str);
            }

            if (model.ExportId != Guid.Empty)
            {
                if (result.Rows.Count > 0)
                {
                    foreach (DataRow row in result.Rows)
                    {
                        if (Enum.IsDefined(typeof(InsuranceRecordType), row[Ins_C70aReportModel.FieldNames.Status].ToString()))
                        {
                            row[Ins_C70aReportModel.FieldNames.Status] = row[Ins_C70aReportModel.FieldNames.Status].ToString().TranslateString();
                        }
                        if (Enum.IsDefined(typeof(InsuranceRecordType), row[Ins_C70aReportModel.FieldNames.CodeEmp].ToString()))
                        {
                            row[Ins_C70aReportModel.FieldNames.CodeEmp] = row[Ins_C70aReportModel.FieldNames.CodeEmp].ToString().TranslateString();
                        }
                        if (Enum.IsDefined(typeof(InsuranceRecordType), row[Ins_C70aReportModel.FieldNames.GroupName].ToString()))
                        {
                            row[Ins_C70aReportModel.FieldNames.GroupName] = row[Ins_C70aReportModel.FieldNames.GroupName].ToString().TranslateString();
                        }
                    }
                }

                var fullPath = ExportService.Export(model.ExportId, result, null, model.ExportType);
                return Json(fullPath);
            }

            #region mapping dataTable to dataList
            //List<Ins_C70aReportModel> dataList = new List<Ins_C70aReportModel>();
            //Ins_C70aReportModel aTSource = null;
            //if (result.Rows.Count > 0)
            //{
            //    const BindingFlags flags = BindingFlags.Public | BindingFlags.Instance | BindingFlags.NonPublic;
            //    var objFieldNames = (from PropertyInfo aProp in typeof(Ins_C70aReportModel).GetProperties(flags)
            //                         select new
            //                         {
            //                             Name = aProp.Name,
            //                             Type = Nullable.GetUnderlyingType(aProp.PropertyType) ?? aProp.PropertyType
            //                         }).ToList();
            //    var dataTblFieldNames = (from DataColumn aHeader in result.Columns
            //                             select new { Name = aHeader.ColumnName, Type = aHeader.DataType }).ToList();
            //    var commonFields = objFieldNames.Intersect(dataTblFieldNames).ToList();
            //    foreach (DataRow dataRow in result.AsEnumerable().ToList())
            //    {
            //        aTSource = new Ins_C70aReportModel();
            //        foreach (var aField in commonFields)
            //        {
            //            PropertyInfo propertyInfos = aTSource.GetType().GetProperty(aField.Name);
            //            if (dataRow[aField.Name] == DBNull.Value)
            //                continue;
            //            propertyInfos.SetValue(aTSource, dataRow[aField.Name], null);
            //        }
            //        dataList.Add(aTSource);
            //    }
            //}
            #endregion

            return Json(result.ToDataSourceResult(request));
        }
Example #9
0
        /// <summary>  BC Dữ Liệu BH NV Theo Tháng (Group Theo CostCenter) (form kế toán) </summary>
        /// <param name="request"></param>
        /// <param name="model"></param>
        /// <returns></returns>
        public ActionResult ReportInsCostCenterMonthly([DataSourceRequest] DataSourceRequest request, Ins_ReportInsCostCenterMonthlyModel model)
        {
            var services = new Ins_InsuranceReportServices();
            var result = services.ReportInsCostCenterMonthly(model.OrgStructureID, model.MonthYear.Value, model.CostCentreName, model.SocialInsPlaceIDs,UserLogin);
            var lstModel = new List<Ins_ReportInsCostCenterMonthlyModel>();
            if (result != null)
            {
                lstModel = result.Translate<Ins_ReportInsCostCenterMonthlyModel>();
            }
            var isDataTable = false;
            object obj = new Ins_ReportInsCostCenterMonthlyModel();

            if (model.IsCreateTemplateForDynamicGrid)
            {
                obj = result;
                isDataTable = true;
            }
            if (model != null && model.IsCreateTemplate)
            {
                var path = Common.GetPath("Templates");
                ExportService exportService = new ExportService();
                ConfigExport cfgExport = new ConfigExport()
                {
                    Object = obj,
                    FileName = "Ins_ReportInsCostCenterMonthlySearchModel",
                    OutPutPath = path,
                    DownloadPath = "Templates",
                    IsDataTable = isDataTable

                };
                var str = exportService.CreateTemplate(cfgExport);
                return Json(str);
            }
            if (model.ExportId != Guid.Empty)
            {
                var fullPath = ExportService.Export(model.ExportId, lstModel, null, model.ExportType);
                return Json(fullPath.ToString().Replace("Success,", "").ToString());
            }
            return Json(lstModel.ToDataSourceResult(request));
        }