public ActionResult GetReportSumaryReturnMoneyEat([DataSourceRequest] DataSourceRequest request, Can_ReportSumaryReturnMoneyEatSearchModel Model) { var service = new Can_ReportServices(); var hrService = new Hre_ProfileServices(); ListQueryModel lstModel = new ListQueryModel { PageIndex = request.Page, PageSize = request.PageSize, Filters = ExtractFilterAttributes(request), Sorts = ExtractSortAttributes(request) }; DateTime From = SqlDateTime.MinValue.Value; DateTime To = SqlDateTime.MaxValue.Value; if (Model.DateFrom != null) { From = Model.DateFrom.Value; } if (Model.DateTo != null) { To = Model.DateTo.Value; } var result = service.GetReportSumaryReturnMoneyEat(Model.CateringIDs, Model.CanteenIDs, Model.LineIDs, Model.WorkPlaceID, From, To, Model.OrgStructureID, Model.CodeEmp, Model.IsIncludeQuitEmp); #region xử lý xuất báo cáo if (Model.ExportID != Guid.Empty) { var fullPath = ExportService.Export(Model.ExportID, result); return Json(fullPath); } #endregion request.Page = 1; var dataSourceResult = result.ToDataSourceResult(request); return Json(result.ToDataSourceResult(request)); }
public ActionResult GetReportDetailCard([DataSourceRequest] DataSourceRequest request, Can_ReportDetailCardSearchModel Model) { var service = new Can_ReportServices(); var hrService = new Hre_ProfileServices(); ListQueryModel lstModel = new ListQueryModel { PageIndex = request.Page, PageSize = request.PageSize, Filters = ExtractFilterAttributes(request), Sorts = ExtractSortAttributes(request) }; DateTime From = SqlDateTime.MinValue.Value; DateTime To = SqlDateTime.MaxValue.Value; if (Model.DateFrom != null) { From = Model.DateFrom.Value; } if (Model.DateTo != null) { To = Model.DateTo.Value; } if (Model.CanteenID != null) Model.CanteenIDs.Add(Model.CanteenID); if (Model.CateringID != null) Model.CateringIDs.Add(Model.CateringID); if (Model.LineID != null) Model.LineIDs.Add(Model.LineID); var result = service.ReportDetailCard(Model.CateringIDs, Model.CanteenIDs, Model.LineIDs, From, To, Model.OrgStructureID); var rs = result.Translate<Can_ReportDetailCardModel>(); #region xử lý xuất báo cáo if (Model.ExportID != Guid.Empty) { var fullPath = ExportService.Export(Model.ExportID, rs); return Json(fullPath); } #endregion request.Page = 1; var dataSourceResult = result.ToDataSourceResult(request); return Json(rs.ToDataSourceResult(request)); }
public ActionResult GetReportMultiSlideCard([DataSourceRequest] DataSourceRequest request, Can_ReportMultiSlideCardSearchModel Model) { var service = new Can_ReportServices(); var hrService = new Hre_ProfileServices(); var Actionservices = new ActionService(UserLogin); ListQueryModel lstModel = new ListQueryModel { PageIndex = request.Page, PageSize = request.PageSize, Filters = ExtractFilterAttributes(request), Sorts = ExtractSortAttributes(request) }; DateTime From = SqlDateTime.MinValue.Value; DateTime To = SqlDateTime.MaxValue.Value; if (Model.DateFrom != null) { From = Model.DateFrom.Value; } if (Model.DateTo != null) { To = Model.DateTo.Value; } List<Guid?> OrgIds = new List<Guid?>(); if (Model.OrgStructureID != null && Model.OrgStructureID.Count() > 0) { OrgIds = Model.OrgStructureID; } string strOrgIDs = Common.ListToString(OrgIds); string status = string.Empty; string profilename = null; string codeemp = null; List<object> objectsearch = new List<object>(); objectsearch.Add(strOrgIDs); objectsearch.Add(profilename); objectsearch.Add(codeemp); List<Guid> lstProfileIDs = Actionservices.GetData<Hre_ProfileIdEntity>(objectsearch, ConstantSql.hrm_hr_sp_get_ProfileIdsByOrg, ref status).Select(s => s.ID).ToList(); var result = service.ReportMultiSlideCard(Model.CateringID, Model.CanteenID, Model.LineID, Model.WorkPlaceID, From, To, lstProfileIDs, Model.IsIncludeQuitEmp); var rs = result.Translate<Can_ReportMultiSlideCardModel>(); #region xử lý xuất báo cáo if (Model.ExportID != Guid.Empty) { var fullPath = ExportService.Export(Model.ExportID, rs); return Json(fullPath); } #endregion request.Page = 1; var dataSourceResult = result.ToDataSourceResult(request); return Json(rs.ToDataSourceResult(request)); }
public ActionResult ComputeSumryMealRecord(Guid CutoffdurationID, string OrgStructureID) { BaseService baseservices = new BaseService(); var Actionservices = new ActionService(UserLogin); string status = string.Empty; List<object> listModel = new List<object>(); listModel.AddRange(new object[18]); listModel[2] = OrgStructureID; listModel[16] = 1; listModel[17] = Int32.MaxValue - 1; List<Hre_ProfileEntity> ListProfile = Actionservices.GetData<Hre_ProfileEntity>(listModel, ConstantSql.hrm_hr_sp_get_Profile, ref status); Can_ReportServices CanteenServices = new Can_ReportServices(); bool result = CanteenServices.SaveSumryMealRecord(CutoffdurationID, ListProfile.Select(m => m.ID).ToList()); return Json(result, JsonRequestBehavior.AllowGet); }
public ActionResult GetReportAdjustmentMealAllowancePayment([DataSourceRequest] DataSourceRequest request, Can_ReportAdjustmentMealAllowancePaymentModel Model) { var service = new Can_ReportServices(); var hrService = new Hre_ProfileServices(); var Actionservices = new ActionService(UserLogin); ListQueryModel lstModel = new ListQueryModel { PageIndex = request.Page, PageSize = request.PageSize, Filters = ExtractFilterAttributes(request), Sorts = ExtractSortAttributes(request) }; DateTime From = SqlDateTime.MinValue.Value; DateTime To = SqlDateTime.MaxValue.Value; if (Model.DateFrom != null) { From = Model.DateFrom.Value; } if (Model.DateTo != null) { To = Model.DateTo.Value; } List<Guid?> OrgIds = new List<Guid?>(); if (Model.OrgStructureID != null && Model.OrgStructureID.Count() > 0) { OrgIds = Model.OrgStructureID; } string strOrgIDs = Common.ListToString(OrgIds); string profileName = string.Empty; string codeEmp = string.Empty; if (Model.ProfileName != string.Empty) { profileName = Model.ProfileName; } if (Model.CodeEmp != string.Empty) { codeEmp = Model.CodeEmp; } List<Guid> lstProfileIDs = new List<Guid>(); List<Object> Lstsearch = new List<object>(); Lstsearch.Add(strOrgIDs); Lstsearch.Add(profileName); Lstsearch.Add(codeEmp); if (Model.OrgStructureID != null) { string status = string.Empty; lstProfileIDs = Actionservices.GetData<Hre_ProfileIdEntity>(Lstsearch, ConstantSql.hrm_hr_sp_get_ProfileIdsByOrg, ref status).Select(s => s.ID).ToList(); } var result = service.ReportAdjustmentMealAllowancePayment(From, To, lstProfileIDs); if (Model.ExportID != Guid.Empty) { var fullPath = ExportService.Export(Model.ExportID, result); return Json(fullPath); } return Json(result.ToDataSourceResult(request)); }
public ActionResult GetReportMealTimeSummary([DataSourceRequest] DataSourceRequest request, Can_ReportMealTimeSummaryModel Model) { var service = new Can_ReportServices(); var hrService = new Hre_ProfileServices(); ListQueryModel lstModel = new ListQueryModel { PageIndex = request.Page, PageSize = request.PageSize, Filters = ExtractFilterAttributes(request), Sorts = ExtractSortAttributes(request) }; DateTime From = DateTime.Now.AddMonths(-1); DateTime To = DateTime.Now; if (Model.DateFrom != null) { From = Model.DateFrom.Value; } if (Model.DateTo != null) { To = Model.DateTo.Value; } string status = string.Empty; var result = service.ReportMealTimeSummary(Model.CateringIDs, Model.CanteenIDs, Model.LineIDs, From, To, Model.OrgIDs); if (Model.ExportID != Guid.Empty) { var fullPath = ExportService.Export(Model.ExportID, result); return Json(fullPath); } return Json(result.ToDataSourceResult(request)); }