如何为下一次执行自动更新startDate和EndDate

本文关键字：执行 更新 startDate EndDate 一次 | 更新日期: 2023-09-27 18:23:47

我需要一些关于如何为下一次执行自动更新StartDate和EndDate的帮助。此时，我在sql数据库中手动添加StartDate和EndDate，如果我不更改StartDate和EndDate，我的报告将使用相同的StartDate和EndDate生成。如果你们能对此提出任何想法或建议，我们将不胜感激。谢谢

static void Main(string[] args)
{
    DateTime start = System.DateTime.Now.AddMinutes(1);
    Schedule.PeriodicSchedules schedule = 
        new Schedule.PeriodicSchedules(start,
            Schedule.PeriodicSchedules.Frequency.Minutely);
    schedule.Elapsed += new System.Timers.ElapsedEventHandler(GenerateReport);
    schedule.Enabled = true;
    Console.ReadLine();
}
static void GenerateReport(object sender, EventArgs e)
{
    if (TypeOfReport == "BillingReport")
    {
        DateOfExecution = DateTime.Parse(strDOE);
        Schedule.PeriodicSchedules s = 
            new Schedule.PeriodicSchedules(DateOfExecution,
                Schedule.PeriodicSchedules.Frequency.Weekly);
        crRpt.Load(BillingReport);
        ReportLogin(crRpt);
        while (ThisReader.Read())
        {
            //StartDate and EndDate >>next execution?
            crRpt.SetParameterValue("@CollectionStartDate", StartDate);
            crRpt.SetParameterValue("@CollectionEndDate", EndDate);
            crRpt.SetParameterValue("@SpokeCode", SpokeCode);
        }
    }
    if (TypeOfReport == "ImageReport")
    {
        DateOfExecution = DateTime.Parse(strDOE);
        Schedule.PeriodicSchedules s = 
            new Schedule.PeriodicSchedules(DateOfExecution,         
                Schedule.PeriodicSchedules.Frequency.Monthly);
        crRpt.Load(ImageReport);
        ReportLogin(crRpt);
        crRpt.SetParameterValue("@CollectionStartDate", StartDate);
        crRpt.SetParameterValue("@CollectionEndDate", EndDate);
        crRpt.SetParameterValue("@SpokeCode", SpokeCode);
    }
}

如何为下一次执行自动更新startDate和EndDate

我设法通过调用另一个方法来自动更新DateOfExecution。如果有人有其他办法，请告诉我。：）

static void GenerateReport(object sender, EventArgs e)
    {
        if (TypeOfReport == "BillingReport")
        {
           ......
           DateOfExecution = DateTime.Parse(strDOE);
           Schedule.PeriodicSchedules s = new Schedule.PeriodicSchedules(DateOfExecution, Schedule.PeriodicSchedules.Frequency.Minutely);
           //weekly
           DateTime StartDate = DateOfExecution.AddDays(-7);
           DateTime EndDate = DateOfExecution.AddDays(-1);
           ..........
           UpdateWeekly(DateOfExecution, strReportType);             
        }        
    }
static void UpdateWeekly(DateTime DateOfExecution, String strReportType)
    {
        DateOfExecution = DateOfExecution.AddMinutes(2);
        SqlConnection thisConnection = new SqlConnection(SQLConnection);
        thisConnection.Open();
        SqlCommand thisCommand = thisConnection.CreateCommand();
        //thisCommand.CommandText = "INSERT INTO dbo.Schedules (DateOfExecution)" + "Values('"+DateOfExecution+"')";
        thisCommand.CommandText = "UPDATE dbo.Schedule set DateOfExecution = '" + DateOfExecution + "' WHERE TypeOfReport = '" + strReportType + "'";
        thisCommand.ExecuteNonQuery();
    }
相关文章：