public FileContentResult ListExcel(IDbConnection connection, ListRequest request)
{
var data = List(connection, request).Entities;
var report = new DynamicDataReport(data, request.IncludeColumns, typeof(Columns.ProductColumns));
var bytes = new ReportRepository().Render(report);
return ExcelContentResult.Create(bytes, "ProductList_" +
DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx");
}
public FileContentResult ListExcel(IDbConnection connection, ListRequest request)
{
var data = List(connection, request).Entities;
var report = new Serenity.Reporting.DynamicDataReport(data, request.IncludeColumns, typeof(Columns.IcnColumns));
var bytes = new ReportRepository().Render(report);
return(ExcelContentResult.Create(bytes, "ICNRecords_" +
System.DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx"));
}
private async Task PerformExportBodyBinary(Guid idReport, Func <Task <IOrganizationServiceExtented> > getService, string fieldName, string fieldTitle)
{
if (!this.IsControlsEnabled)
{
return;
}
ToggleControls(false, Properties.OutputStrings.ExportingBodyBinaryForFieldFormat1, fieldName);
var service = await getService();
try
{
if (service != null)
{
var repository = new ReportRepository(service);
Report reportWithBodyBinary = await repository.GetByIdAsync(idReport, ColumnSetInstances.AllColumns);
if (!string.IsNullOrEmpty(reportWithBodyBinary.BodyBinary))
{
string extension = Path.GetExtension(reportWithBodyBinary.FileName);
string fileName = EntityFileNameFormatter.GetReportFileName(service.ConnectionData.Name, reportWithBodyBinary.Name, reportWithBodyBinary.Id, fieldTitle, extension);
string filePath = Path.Combine(_commonConfig.FolderForExport, FileOperations.RemoveWrongSymbols(fileName));
var array = Convert.FromBase64String(reportWithBodyBinary.BodyBinary);
File.WriteAllBytes(filePath, array);
this._iWriteToOutput.WriteToOutput(service.ConnectionData, Properties.OutputStrings.InConnectionEntityFieldExportedToFormat5, service.ConnectionData.Name, Report.Schema.EntityLogicalName, reportWithBodyBinary.Name, fieldTitle, filePath);
if (File.Exists(filePath))
{
if (_commonConfig.DefaultFileAction != FileAction.None)
{
this._iWriteToOutput.SelectFileInFolder(service.ConnectionData, filePath);
}
}
}
else
{
this._iWriteToOutput.WriteToOutput(service.ConnectionData, Properties.OutputStrings.InConnectionEntityFieldIsEmptyFormat4, service.ConnectionData.Name, Report.Schema.EntityLogicalName, reportWithBodyBinary.Name, fieldTitle);
this._iWriteToOutput.WriteToOutput(null, Properties.OutputStrings.InConnectionEntityFieldIsEmptyFormat4, service.ConnectionData.Name, Report.Schema.EntityLogicalName, reportWithBodyBinary.Name, fieldTitle);
this._iWriteToOutput.ActivateOutputWindow(null);
}
}
ToggleControls(true, Properties.OutputStrings.ExportingBodyBinaryForFieldCompletedFormat1, fieldName);
}
catch (Exception ex)
{
_iWriteToOutput.WriteErrorToOutput(service.ConnectionData, ex);
ToggleControls(true, Properties.OutputStrings.ExportingBodyBinaryForFieldFailedFormat1, fieldName);
}
}
protected void Page_Load(object sender, EventArgs e)
{
IReportRepository repository = new ReportRepository(ConfigurationManager.ConnectionStrings["ENetCare"].ConnectionString);
_reportService = new ReportService(repository);
grd.DataSource = _reportService.GetDistributionCentreStock();
grd.DataBind();
}
public FileContentResult ListExcel(IDbConnection connection, OrderListRequest request)
{
var data = List(connection, request).Entities;
var report = new DynamicDataReport(data, request.IncludeColumns, typeof(Columns.OrderColumns));
var bytes = new ReportRepository().Render(report);
return(ExcelContentResult.Create(bytes, "OrderList_" +
DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx"));
}
public async Task Get_Report_For_Organization(bool submitted, string[] include)
{
using (var context = new TestHedwigContextProvider().Context)
{
// Set up test data
var organization = OrganizationHelper.CreateOrganization(context);
var reportingPeriod = ReportingPeriodHelper.CreateReportingPeriod(context);
var report = ReportHelper.CreateCdcReport(context, organization: organization, reportingPeriod: reportingPeriod);
var site = SiteHelper.CreateSite(context, organization: organization);
var enrollment = EnrollmentHelper.CreateEnrollment(context, site: site, ageGroup: Age.Preschool);
var funding = FundingHelper.CreateFunding(context, enrollment: enrollment, firstReportingPeriod: reportingPeriod);
if (submitted)
{
Thread.Sleep(1000);
report.SubmittedAt = DateTime.Now;
context.SaveChanges();
Thread.Sleep(1000);
}
enrollment.AgeGroup = Age.SchoolAge;
context.SaveChanges();
// When the repository is queried
var repo = new ReportRepository(context);
var result = await repo.GetReportForOrganizationAsync(report.Id, organization.Id, include) as CdcReport;
// It returns the Report
Assert.Equal(result.Id, report.Id);
// It includes the Organization
Assert.Equal(include.Contains("organizations"), result.Organization != null);
// It includes the Sites
Assert.Equal(include.Contains("sites"), result.Organization != null && result.Organization.Sites != null);
// It includes the Enrollments (and Fundings too)
Assert.Equal(
include.Contains("enrollments"),
result.Enrollments != null &&
result.Enrollments.FirstOrDefault().Fundings != null
);
// When it includes enrollments
if (include.Contains("enrollments"))
{
var enrollmentResult = result.Enrollments.FirstOrDefault();
var fundingResult = enrollmentResult.Fundings.FirstOrDefault();
// A submitted report should return the data as of when it was submitted
Assert.Equal(submitted ? Age.Preschool : Age.SchoolAge, enrollmentResult.AgeGroup);
}
}
}
private async Task PerformShowingDifferenceDescriptionAsync(LinkedEntities <Report> linked, bool showAllways)
{
if (!this.IsControlsEnabled)
{
return;
}
ToggleControls(false, Properties.WindowStatusStrings.ShowingDifferenceEntityDescription);
try
{
var service1 = await GetService1();
var service2 = await GetService2();
if (service1 != null && service2 != null)
{
var repository1 = new ReportRepository(service1);
var repository2 = new ReportRepository(service2);
var report1 = await repository1.GetByIdAsync(linked.Entity1.Id, new ColumnSet(true));
var report2 = await repository2.GetByIdAsync(linked.Entity2.Id, new ColumnSet(true));
var desc1 = await EntityDescriptionHandler.GetEntityDescriptionAsync(report1, EntityFileNameFormatter.ReportIgnoreFields);
var desc2 = await EntityDescriptionHandler.GetEntityDescriptionAsync(report2, EntityFileNameFormatter.ReportIgnoreFields);
if (showAllways || desc1 != desc2)
{
string filePath1 = await CreateDescriptionFileAsync(service1.ConnectionData, report1.Name, report1.Id, "Description", desc1);
string filePath2 = await CreateDescriptionFileAsync(service2.ConnectionData, report2.Name, report2.Id, "Description", desc2);
if (File.Exists(filePath1) && File.Exists(filePath2))
{
this._iWriteToOutput.ProcessStartProgramComparer(filePath1, filePath2, Path.GetFileName(filePath1), Path.GetFileName(filePath2));
}
else
{
this._iWriteToOutput.PerformAction(service1.ConnectionData, filePath1);
this._iWriteToOutput.PerformAction(service2.ConnectionData, filePath2);
}
}
}
ToggleControls(true, Properties.WindowStatusStrings.ShowingDifferenceEntityDescriptionCompleted);
}
catch (Exception ex)
{
_iWriteToOutput.WriteErrorToOutput(null, ex);
ToggleControls(true, Properties.WindowStatusStrings.ShowingDifferenceEntityDescriptionFailed);
}
}
private async Task PerformExportBodyBinary(string folder, Guid idReport, string name, string filename, string fieldName, string fieldTitle)
{
var service = await GetService();
if (service == null)
{
return;
}
ToggleControls(service.ConnectionData, false, Properties.OutputStrings.ExportingBodyBinaryForFieldFormat1, fieldName);
try
{
var repository = new ReportRepository(service);
Report reportWithBodyBinary = await repository.GetByIdAsync(idReport, new ColumnSet(fieldName));
string extension = Path.GetExtension(filename);
string fileName = EntityFileNameFormatter.GetReportFileName(service.ConnectionData.Name, name, idReport, fieldTitle, extension);
string filePath = Path.Combine(folder, FileOperations.RemoveWrongSymbols(fileName));
var body = reportWithBodyBinary.GetAttributeValue<string>(fieldName);
if (!string.IsNullOrEmpty(body))
{
var array = Convert.FromBase64String(body);
File.WriteAllBytes(filePath, array);
this._iWriteToOutput.WriteToOutput(service.ConnectionData, Properties.OutputStrings.InConnectionEntityFieldExportedToFormat5, service.ConnectionData.Name, Report.Schema.EntityLogicalName, name, fieldTitle, filePath);
if (File.Exists(filePath))
{
if (_commonConfig.DefaultFileAction != FileAction.None)
{
this._iWriteToOutput.SelectFileInFolder(service.ConnectionData, filePath);
}
}
}
else
{
this._iWriteToOutput.WriteToOutput(service.ConnectionData, Properties.OutputStrings.InConnectionEntityFieldIsEmptyFormat4, service.ConnectionData.Name, Report.Schema.EntityLogicalName, name, fieldTitle);
this._iWriteToOutput.ActivateOutputWindow(service.ConnectionData);
}
ToggleControls(service.ConnectionData, true, Properties.OutputStrings.ExportingBodyBinaryForFieldCompletedFormat1, fieldName);
}
catch (Exception ex)
{
_iWriteToOutput.WriteErrorToOutput(service.ConnectionData, ex);
ToggleControls(service.ConnectionData, true, Properties.OutputStrings.ExportingBodyBinaryForFieldFailedFormat1, fieldName);
}
}
public FileContentResult ListExcel(IDbConnection connection, CustomerGrossSalesListRequest request)
{
var data = List(connection, request).Entities;
var report = new DynamicDataReport(data, request.IncludeColumns,
typeof(Columns.CustomerGrossSalesColumns), HttpContext.RequestServices);
var bytes = ReportRepository.Render(report);
return(ExcelContentResult.Create(bytes, "CustomerGrossSales_" +
DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx"));
}
public ReportUI(BillReceiptUI frmBillReceipt)
{
InitializeComponent();
ds = new BizCareDataSet();
rpt = new ReportDocument();
reportRepository = new ReportRepository();
this.frmBillReceipt = frmBillReceipt;
}
public IActionResult GetReportData([FromBody] RequestModel model)
{
if (model == null)
{
model = new RequestModel();
}
Response <DashBoardModel> returnModel = new ReportRepository().GetReportData(model);
return(Ok(returnModel));
}
public ReportUI(PayablePaymentUI frmPayablePayment)
{
InitializeComponent();
ds = new BizCareDataSet();
rpt = new ReportDocument();
reportRepository = new ReportRepository();
this.frmPayablePayment = frmPayablePayment;
}
public ReportUI(PurchaseUI frmPurchase)
{
InitializeComponent();
ds = new BizCareDataSet();
rpt = new ReportDocument();
reportRepository = new ReportRepository();
this.frmPurchase = frmPurchase;
}
public ReportUI(SalesUI frmSales)
{
InitializeComponent();
ds = new BizCareDataSet();
rpt = new ReportDocument();
reportRepository = new ReportRepository();
this.frmSales = frmSales;
}
public FileContentResult ListExcel(IDbConnection connection, ListRequest request)
{
var data = List(connection, request).Entities;
var cols = request.IncludeColumns.Where(p => p != MyRow.Fields.ReusedCount.Name);
var report = new DynamicDataReport(data, cols, typeof(Columns.IdCardColumns));
var bytes = new ReportRepository().Render(report);
return(ExcelContentResult.Create(bytes, "IdCard_" +
DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx"));
}
public UnitOfWork()
{
FileTracer_DataBaseContext context = new FileTracer_DataBaseContext();
ClientRepository = new ClientRepository(context);
ManagerRepository = new ManagerRepository(context);
ProductRepository = new ProductRepository(context);
ReportRepository = new ReportRepository(context);
SaleLogRepository = new SaleLogRepository(context);
}
public IActionResult GetTransictionList([FromBody] RequestModel model)
{
if (model == null)
{
model = new RequestModel();
}
Response <List <TransactionModel> > returnModel = new ReportRepository().GetTransictionList(model);
return(Ok(returnModel));
}
public void Controller_Get_Should_Be_NoContentResult()
{
var fixture = new DbContextFixture();
var logger = new Mock <ILogger <ReportsController> >().Object;
var repository = new ReportRepository(fixture.context);
var controller = new ReportsController(logger, repository);
ActionResult <IQueryable <Report> > result = controller.Get();
result.Result.Should().BeOfType <NoContentResult>();
}
public ReportUI(StockCorrectionUI frmStockCorrection)
{
InitializeComponent();
ds = new BizCareDataSet();
rpt = new ReportDocument();
reportRepository = new ReportRepository();
this.frmStockCorrection = frmStockCorrection;
}
public ActionResult InvestmentByRegion(InvestmentByRegionViewModel model)
{
model.InvestmentByRegions = ReportRepository.GetInvestmentByRegion(model);
model.Regions = model.InvestmentByRegions.Select(s => s.Region).Distinct().OrderBy(r => r).ToList();
model.Sectors = StatusRepository.GetStatusByGroup("Sector");
//model.FromDate = DateTime.Now;
//model.ToDate = DateTime.Now;
return(View(model));
}
public ReportController(
ReportUsersMapsRepository reportsUsersRepository,
IWorkplaceContext context,
ReportRepository reportRepository
)
{
this.reportsUsersRepository = reportsUsersRepository;
this.context = context;
this.reportRepository = reportRepository;
} // constructor
private void PrintDoc(int typex, bool filter)
{
if (cmb_days.SelectedValue == null)
{
MessageBox.Show("Please select a day to continue", Messaging.MessageCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
string reporttitle = "";
ReportViwer rpt = new ReportViwer();
rpt.MdiParent = frm_main.ActiveForm;
rpt.FormHeadertext = reporttitle;
ParameterField paramField = new ParameterField();
ParameterFields paramFields = new ParameterFields();
ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
paramFields = ReportRepository.AddCrystalParamsWithLoca(reporttitle, commonFunctions.Loginuser.ToUpper(), commonFunctions.GlobalLocation, "01", commonFunctions.GlobalCompany, commonFunctions.CompanyAddress);
paramField.Name = "status";
paramDiscreteValue.Value = "Original".ToUpper();
paramField.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramField);
Rpt_SalesTypeWiseSale rptBank = new Rpt_SalesTypeWiseSale();
switch (options)
{
case 1:
reporttitle = "Daily Cash Sales".ToUpper();
rptBank.SetDataSource(ReportRepository.GetSalesTypeWiseDetails(commonFunctions.ToInt(cmb_days.SelectedValue.ToString()), 0, 1));
break;
case 2:
reporttitle = "Daily Card Sales".ToUpper();
rptBank.SetDataSource(ReportRepository.GetSalesTypeWiseDetails(commonFunctions.ToInt(cmb_days.SelectedValue.ToString()), 0, 2));
break;
case 3:
reporttitle = "Daily Voucher Sales".ToUpper();
rptBank.SetDataSource(ReportRepository.GetSalesTypeWiseDetails(commonFunctions.ToInt(cmb_days.SelectedValue.ToString()), 0, 3));
break;
}
rpt.RepViewer.ParameterFieldInfo = paramFields;
rpt.RepViewer.ReportSource = rptBank;
rpt.RepViewer.Refresh();
rpt.MdiParent = frm_main.ActiveForm;
rpt.Show();
}
public ServerResponse <Report> GetByTeacher(int idTeacher)
{
ReportRepository repo = new ReportRepository();
var reports = repo.RetriveByTeacher(idTeacher);
return(new ServerResponse <Report>()
{
Result = reports != null,
Data = reports
});
}
public async Task <JsonResult> Get(int id, int skip, int limit, string filter, string orderby)
{
await CheckPermission();
var rr = new ReportRepository(_logger);
var result = await rr.Get(id, skip, limit, filter, orderby);
rr.Dispose();
return(Json(result));
}
public void Controller_Delete_Should_Be_NotFound()
{
var fixture = new DbContextFixture();
var logger = new Mock <ILogger <ReportsController> >().Object;
var repository = new ReportRepository(fixture.context);
var controller = new ReportsController(logger, repository);
var eid = ReportEntityTypeConfiguration.ReportSeed.ElementAt(1).Id;
ActionResult <Report> result = controller.Delete(eid);
result.Result.Should().BeOfType <NotFoundResult>();
}
public async Task <JsonResult> GetList()
{
await CheckPermission();
var rr = new ReportRepository(_logger);
var result = rr.GetList();
rr.Dispose();
return(Json(result));
}
public void Add_A_Report_When_Not_Populated_Should_Be_One()
{
var repository = new ReportRepository(fixture.context);
var entity = ReportEntityTypeConfiguration.ReportSeed.ElementAt(1);
entity.Id = 3;
repository.Add(entity);
var count = repository.Get().Count();
Assert.Equal(1, count);
}
protected void Page_Load(object sender, EventArgs e)
{
IReportRepository repository = new ReportRepository(ConfigurationManager.ConnectionStrings["ENetCare"].ConnectionString);
_reportService = new ReportService(repository);
EmployeeMembershipUser user = (EmployeeMembershipUser)System.Web.Security.Membership.GetUser();
grd.DataSource = _reportService.GetStocktaking(user.DistributionCentreId);
grd.DataBind();
}
// GET: api/Report/5
public ServerResponse <Report> GetByChild(int idChild)
{
ReportRepository repo = new ReportRepository();
var reports = repo.RetrieveByChild(idChild);
return(new ServerResponse <Report>()
{
Result = reports != null,
Data = reports
});
}
public void Controller_Post_Should_Be_OkResult()
{
var fixture = new DbContextFixture();
var logger = new Mock <ILogger <ReportsController> >().Object;
var repository = new ReportRepository(fixture.context);
var controller = new ReportsController(logger, repository);
var e = ReportEntityTypeConfiguration.ReportSeed.ElementAt(0);
ActionResult <Report> result = controller.Post(e);
result.Result.Should().BeOfType <OkObjectResult>();
}
public void Controller_Get_ById_Should_Be_NoContentResult()
{
var fixture = new DbContextFixture();
var logger = new Mock <ILogger <ReportsController> >().Object;
var repository = new ReportRepository(fixture.context);
var controller = new ReportsController(logger, repository);
var e = ReportEntityTypeConfiguration.ReportSeed.First().Id;
ActionResult <Report> result = controller.Get(e);
result.Result.Should().BeOfType <NoContentResult>();
}
public List<StudentVisitSummaryReportItem> GetStudentVisitSummaryReportByStudent(string clazzName, DateTime? startTime, DateTime? endTime)
{
var ds = new ReportRepository();
if (String.IsNullOrEmpty(clazzName)) clazzName = "%";
if (!startTime.HasValue) {
startTime = new DateTime(1990, 1, 1);
}
if (!endTime.HasValue) {
endTime = DateTime.Today.AddDays(1);
}
return ds.GetStudentVisitSummaryReportByStudent(clazzName, startTime, endTime);
}
// 招生统计报表-按组按月统计各组员的量
public List<SalesTeamSummaryReport> GetSignUpSummaryReportByMonthAndSalesman(int year, int month, int teamId)
{
var ds = new ReportRepository();
var m = ds.GetSignUpSummaryReportByMonthAndSalesman(year, month, teamId);
return m;
}
public void ReportRepository()
{
Mock<IDbSetFactory> factory = new Mock<IDbSetFactory>();
Mock<DbSet<Report>> dbSet = new Mock<DbSet<Report>>();
factory.Setup(m => m.CreateDbSet<Report>()).Returns(dbSet.Object);
ReportRepository repo = new ReportRepository(factory.Object);
var Report = new Report();
var sequence = new MockSequence();
dbSet.InSequence(sequence).Setup(e => e.Add(Report));
dbSet.InSequence(sequence).Setup(e => e.Find(Report.Id));
dbSet.InSequence(sequence).Setup(e => e.Find(Report.Id));
dbSet.InSequence(sequence).Setup(e => e.Find(Report.Id));
repo.Create(Report);
repo.Get(Report.Id);
repo.Update(Report);
repo.Delete(Report.Id);
}
// 招生统计报表-按月统计各学校的量
public List<SalesTeamSummaryReport> GetSignUpSummaryReportByMonthAndSchool(int year, int month)
{
var ds = new ReportRepository();
var m = ds.GetSignUpSummaryReportByMonthAndSchool(year, month);
return m;
}
// 招生统计报表-按电话营销组、按月细化统计
public List<SalesTeamSummaryReport> GetSignUpSummaryReportBySalesTeamAndMonth(int year, int teamId)
{
var ds = new ReportRepository();
var m = ds.GetSignUpSummaryReportBySalesTeamAndMonth(year, teamId);
return m;
}
/// <summary>
/// Initializes a new instance of the ReportService class.
/// </summary>
/// <param name="unitOfWork">Unit of work</param>
public ReportService(UnitOfWork unitOfWork)
{
this.unitOfWork = unitOfWork;
this.reportRepository = new ReportRepository(this.unitOfWork);
}
// 招生统计报表-按学校统计
public List<SalesTeamSummaryReport> GetSignUpSummaryReportBySchool(int year)
{
var ds = new ReportRepository();
var m = ds.GetSignUpSummaryReportBySchool(year);
return m;
}
// 招生统计报表-招生排名
public List<SignUpRankingListItem> GetSignUpRankingList(DateTime? startTime, DateTime? endTime, string orderBy, string rankBy)
{
string o = "SignUpQty DESC, TelSignUpQty DESC, NonTelSignUpQty DESC, TelDropInQty DESC, NonTelDropInQty DESC, SignUpRate DESC, DropInRate DESC";
if (!String.IsNullOrEmpty(orderBy)) {
switch (orderBy.ToLower()) {
case "signupqty":
o = "SignUpQty DESC, TelSignUpQty DESC, NonTelSignUpQty DESC, TelDropInQty DESC, NonTelDropInQty DESC, SignUpRate DESC, DropInRate DESC";
break;
case "dropinqty":
o = "DropInQty DESC, TelSignUpQty DESC, NonTelSignUpQty DESC, TelDropInQty DESC, NonTelDropInQty DESC, SignUpRate DESC, DropInRate DESC";
break;
case "telsignupqty":
o = "TelSignUpQty DESC, NonTelSignUpQty DESC, TelDropInQty DESC, NonTelDropInQty DESC, SignUpRate DESC, DropInRate DESC";
break;
case "nontelsignupqty":
o = "NonTelSignUpQty DESC, TelSignUpQty DESC, TelDropInQty DESC, NonTelDropInQty DESC, SignUpRate DESC, DropInRate DESC";
break;
case "teldropinqty":
o = "TelDropInQty DESC, TelSignUpQty DESC, NonTelSignUpQty DESC, NonTelDropInQty DESC, SignUpRate DESC, DropInRate DESC";
break;
case "nonteldropinqty":
o = "NonTelDropInQty DESC, TelSignUpQty DESC, NonTelSignUpQty DESC, TelDropInQty DESC, SignUpRate DESC, DropInRate DESC";
break;
case "signuprate":
o = "SignUpRate DESC, TelSignUpQty DESC, NonTelSignUpQty DESC, TelDropInQty DESC, NonTelDropInQty DESC, DropInRate DESC";
break;
case "dropinrate":
o = "DropInRate DESC, TelSignUpQty DESC, NonTelSignUpQty DESC, TelDropInQty DESC, NonTelDropInQty DESC, SignUpRate DESC";
break;
case "telqty":
o = "TelQty DESC, TelSignUpQty DESC, NonTelSignUpQty DESC, TelDropInQty DESC, NonTelDropInQty DESC, SignUpRate DESC, DropInRate DESC";
break;
default:
o = "TelSignUpQty DESC, NonTelSignUpQty DESC, TelDropInQty DESC, NonTelDropInQty DESC, SignUpRate DESC, DropInRate DESC";
break;
}
}
var ds = new ReportRepository();
if (startTime == null || endTime == null) {
var n = 0;
switch (DateTime.Today.DayOfWeek) {
case DayOfWeek.Monday:
n = -1;
break;
case DayOfWeek.Tuesday:
n = -2;
break;
case DayOfWeek.Wednesday:
n = -3;
break;
case DayOfWeek.Thursday:
n = -4;
break;
case DayOfWeek.Friday:
n = -5;
break;
case DayOfWeek.Saturday:
n = -6;
break;
default:
break;
}
startTime = DateTime.Today.AddDays(n);
endTime = startTime.Value.AddDays(8);
}
if (startTime == null) {
startTime = new DateTime(2000, 1, 1);
}
if (endTime == null) {
endTime = new DateTime(2099, 12, 31);
}
var m = ds.GetSignUpRankingList(startTime.Value, endTime.Value, o, (String.IsNullOrEmpty(rankBy) ? "SignUpQty" : rankBy));
return m;
}
// 招生统计报表-按月统计
public List<SignUpSummaryReportItem> GetSignUpSummaryReportByMonth(int year)
{
var ds = new ReportRepository();
var m = ds.GetSignUpSummaryReportByMonth(year);
return m;
}
public List<StudentVisitSummaryReportItem> GetStudentVisitSummaryReportByTeacher(DateTime? startTime, DateTime? endTime)
{
var ds = new ReportRepository();
var m = ds.GetStudentVisitSummaryReportByTeacher(startTime, endTime);
return m;
}
public List<EmploymentVisitReviewReprtItem> GetEmploymentVisitReviewReprt(DateTime? startTime, DateTime? endTime)
{
var ds = new ReportRepository();
var m = ds.GetEmploymentVisitReviewReprt(startTime, endTime);
return m;
}
// 招生统计报表-总表
public List<SignUpSummaryReportItem> GetSignUpSummaryReport()
{
var ds = new ReportRepository();
return ds.GetSignUpSummaryReport();
}
public List<StudentVisitSummaryReportItem> GetStudentVisitSummaryReport(DateTime? startTime, DateTime? endTime)
{
var ds = new ReportRepository();
startTime = (startTime != null) ? startTime : new DateTime(DateTime.Today.Year, DateTime.Today.Month, 1);
endTime = (endTime != null) ? endTime : DateTime.Today;
return ds.GetStudentVisitSummaryReport(startTime.Value, endTime.Value);
}
// 招生统计报表-按组统计学校数量和资料数量
public List<SalesTeamSchoolQtyReportItem> GetSchoolQtyReportBySalesTeam(int year)
{
var ds = new ReportRepository();
var m = ds.GetSchoolQtyReportBySalesTeam(year);
return m;
}
public List<NewEmployeeCompanyReportItem> GetNewEmployeeCompanyReport(DateTime? startTime, DateTime? endTime)
{
var ds = new ReportRepository();
var m = ds.GetNewEmployeeCompanyReport(startTime, endTime);
return m;
}
