protected void Page_Load(object sender, EventArgs e)
{
if ((Request.UrlReferrer == null || !Request.UrlReferrer.LocalPath.Contains("Schedule.aspx")) && Session["StartTaskTime"] != null)
{
Session.Remove("StartTaskTime");
}
if (Request["r"] == null)
{
Response.Redirect("GeneralReports.aspx");
}
_generalReport = GeneralReport.Find(Convert.ToUInt64(Request["r"]));
taskService = ScheduleHelper.GetService();
reportsFolder = ScheduleHelper.GetReportsFolder(taskService);
currentTask = ScheduleHelper.GetTaskOrCreate(taskService, reportsFolder, _generalReport.Id, _generalReport.Comment, "GR");
currentTaskDefinition = currentTask.Definition;
tempTask = ScheduleHelper.FindTaskNullable(reportsFolder, _generalReport.Id, "temp_");
TaskState tempTaskState;
string tempTaskDescription = string.Empty;
if (tempTask != null)
{
tempTaskState = tempTask.State;
tempTaskDescription = tempTask.Definition.RegistrationInfo.Description;
}
else
{
tempTaskState = TaskState.Unknown;
}
btnExecute.Enabled = currentTask.State != TaskState.Running && tempTaskState != TaskState.Running;
btnExecute.Text = (currentTask.State == TaskState.Running) ? StatusNotRunning : StatusRunning;
var userName = HttpContext.Current.User.Identity.Name.Replace(@"ANALIT\", string.Empty);
ErrorMassage.Text = string.Empty;
ErrorMassage.CssClass = "error";
var description = tempTaskState == TaskState.Running ? string.Format("(запустил: {0})", tempTaskDescription) : string.Empty;
if (tempTaskState == TaskState.Running || currentTask.State == TaskState.Running)
{
ExecAction action = null;
var currentReportNumber = "";
ulong runningNumber = 0;
if (tempTaskState == TaskState.Running)
{
if (tempTask != null)
{
action = (ExecAction)tempTask.Definition.Actions.FirstOrDefault();
}
}
else
{
action = (ExecAction)currentTask.Definition.Actions.FirstOrDefault();
}
if (action != null)
{
var arguments = (action).Arguments;
if (!String.IsNullOrEmpty(arguments))
{
if (arguments.IndexOf("/gr:") >= 0)
{
var substring = arguments.Substring(arguments.IndexOf("/gr:") + 4);
var numberLength = substring.IndexOf(@" /");
var reportNumber = substring.Substring(0, numberLength != -1 ? numberLength : substring.Length);
if (!String.IsNullOrEmpty(reportNumber))
{
currentReportNumber += " № ";
currentReportNumber += reportNumber;
ulong.TryParse(reportNumber, out runningNumber);
}
}
}
}
var startTime = GetStartTime(DbSession, runningNumber != 0 ? runningNumber : _generalReport.Id);
var prefix = tempTaskState == TaskState.Running ? String.Format("Успешно запущен разовый отчет{0}", currentReportNumber)
: String.Format("Отчет запущен ({0})", currentReportNumber);
if (tempTaskDescription == userName || currentTask.State == TaskState.Running)
{
ErrorMassage.Text = string.Format("{0}, ожидайте окончания выполнения операции. {1}", prefix, startTime);
ErrorMassage.BackColor = Color.LightGreen;
}
else
{
ErrorMassage.Text = String.Format("{1}, выполнение данного отчета отложено {0}. {2}", description, prefix, startTime);
ErrorMassage.BackColor = Color.Red;
}
btn_Mailing.Enabled = false;
RadioSelf.Enabled = false;
RadioMails.Enabled = false;
}
if (tempTaskState == TaskState.Queued || currentTask.State == TaskState.Queued)
{
var prefix = tempTaskState == TaskState.Running ? "Запускается разовый отчет" : "Отчет запускается";
if (tempTaskDescription == userName || currentTask.State == TaskState.Queued)
{
ErrorMassage.Text = string.Format("{0}, ожидайте окончания выполнения операции", prefix);
ErrorMassage.BackColor = Color.LightGreen;
}
else
{
ErrorMassage.Text = string.Format("{1} {0}, выполнение данного отчета отложено)", description, prefix);
ErrorMassage.BackColor = Color.Red;
}
btn_Mailing.Enabled = false;
RadioSelf.Enabled = false;
RadioMails.Enabled = false;
}
if ((tempTaskState == TaskState.Ready && currentTask.State != TaskState.Running && currentTask.State != TaskState.Queued) ||
(currentTask.State == TaskState.Ready && tempTaskState != TaskState.Running && tempTaskState != TaskState.Queued))
{
if (tempTaskDescription == userName || currentTask.State == TaskState.Ready)
{
// отчет выполнен
if (Session["StartTaskTime"] != null)
{
Session.Remove("StartTaskTime");
ErrorMassage.Text = "Операция выполнена";
ErrorMassage.BackColor = Color.LightGreen;
}
else
{
ErrorMassage.Text = "";
}
}
}
if ((tempTaskState == TaskState.Disabled && currentTask.State != TaskState.Running && currentTask.State != TaskState.Queued) ||
(currentTask.State == TaskState.Disabled && tempTaskState != TaskState.Running && tempTaskState != TaskState.Queued))
{
if (Session["StartTaskTime"] != null)
{
Session.Remove("StartTaskTime");
ErrorMassage.Text = "Операция отменена";
ErrorMassage.BackColor = Color.Red;
}
else
{
ErrorMassage.Text = "";
}
}
var otherTriggers = new List <Trigger>();
if (!IsPostBack)
{
var selfMail = GetSelfEmails();
if ((selfMail.Count != 0) && (selfMail[0].Length != 0))
{
RadioSelf.Text = "Выполнить и отослать на: " + selfMail[0][0];
}
dtFrom.Value = DateTime.Now.AddDays(-7).ToShortDateString();
dtTo.Value = DateTime.Now.ToShortDateString();
mail_Text.Text = GetMailingAdresses();
try {
lblClient.Text = _generalReport.Payer.Id + " - " + _generalReport.Payer.ShortName;
lblReportComment.Text = _generalReport.Comment;
var lastLogTimes = ObjectFromQuery(new[] { new MySqlParameter("?GeneralReportCode", _generalReport.Id) },
@"
SELECT
Max(LogTime) as MaxLogTime
FROM
logs.reportslogs
WHERE
reportslogs.GeneralReportCode = ?GeneralReportCode
");
if ((lastLogTimes.Count > 0) && (lastLogTimes[0].Length > 0))
{
if (lastLogTimes[0][0] is DateTime)
{
MyCn.Open();
MyCmd.CommandText = @"
SELECT
LogTime,
EMail,
SMTPID
FROM
logs.reportslogs
WHERE
reportslogs.GeneralReportCode = ?GeneralReportCode
and reportslogs.LogTime > ?LastLogTime
order by LogTime desc
";
MyCmd.Parameters.AddWithValue("?LastLogTime", ((DateTime)lastLogTimes[0][0]).AddDays(-1).Date);
var _logs = new DataTable();
MyDA.Fill(_logs);
gvLogs.DataSource = _logs;
}
}
gvLogs.DataBind();
MyCmd.Parameters.Clear();
MyCmd.CommandText = @"select
rel.StartTime,
if (not EndError, rel.EndTime, 'Ошибка при формировании отчета') as EndTime
from `logs`.reportexecutelogs rel
where rel.GeneralReportCode = ?GeneralReportCode
order by StartTime desc
limit 15;";
MyCmd.Parameters.AddWithValue("?GeneralReportCode", _generalReport.Id);
var startlogs = new DataTable();
MyDA.Fill(startlogs);
startLogs.DataSource = startlogs;
startLogs.DataBind();
}
finally {
MyCn.Close();
}
chbAllow.Checked = currentTask.Enabled;
lblWork.Text = ((ExecAction)currentTask.Definition.Actions[0]).Path + " " + ((ExecAction)currentTask.Definition.Actions[0]).Arguments;
lblFolder.Text = ((ExecAction)currentTask.Definition.Actions[0]).WorkingDirectory;
if (_generalReport.FirmCode != null)
{
var ftpId = _generalReport.FirmCode.ToString().PadLeft(3, '0');
FtpPath.Text = $"ftp://ftp.analit.net/OptBox/{ftpId}/Reports/";
}
else
{
FtpPath.Text = "";
}
var tl = currentTask.Definition.Triggers;
for (int i = 0; i < tl.Count; i++)
{
if (tl[i] is WeeklyTrigger)
{
var dr = DS.Tables[dtSchedule.TableName].NewRow();
var trigger = ((WeeklyTrigger)tl[i]);
dr[SStartHour.ColumnName] = trigger.StartBoundary.Hour;
dr[SStartMinute.ColumnName] = trigger.StartBoundary.Minute;
var days = trigger.DaysOfWeek;
SetWeekDays(dr, DaysOfTheWeek.Monday, days);
SetWeekDays(dr, DaysOfTheWeek.Tuesday, days);
SetWeekDays(dr, DaysOfTheWeek.Wednesday, days);
SetWeekDays(dr, DaysOfTheWeek.Thursday, days);
SetWeekDays(dr, DaysOfTheWeek.Friday, days);
SetWeekDays(dr, DaysOfTheWeek.Saturday, days);
SetWeekDays(dr, DaysOfTheWeek.Sunday, days);
DS.Tables[dtSchedule.TableName].Rows.Add(dr);
}
else if (tl[i] is MonthlyTrigger)
{
var dr = DS.Tables[dtScheduleMonth.TableName].NewRow();
//очищаем таблицу от значений по умолчанию
for (var k = 1; k <= 31; k++)
{
dr["d" + k] = 0;
}
for (var k = 1; k <= 12; k++)
{
dr["m" + k] = 0;
}
var trigger = ((MonthlyTrigger)tl[i]);
dr[MSStartHour.ColumnName] = trigger.StartBoundary.Hour;
dr[MSStartMinute.ColumnName] = trigger.StartBoundary.Minute;
var months = trigger.MonthsOfYear;
MonthsOfTheYear month;
for (int j = 0; j < 12; j++)
{
MonthsOfTheYear.TryParse((1 << j).ToString(), true, out month);
if (months.HasFlag(month))
{
dr["m" + (j + 1)] = 1;
}
}
foreach (int em in trigger.DaysOfMonth)
{
dr["d" + em] = 1;
}
DS.Tables[dtScheduleMonth.TableName].Rows.Add(dr);
}
else
{
otherTriggers.Add(tl[i]);
}
}
DS.Tables[dtSchedule.TableName].AcceptChanges();
dgvSchedule.DataSource = DS;
dgvSchedule.DataMember = dtSchedule.TableName;
dgvSchedule.DataBind();
dgvScheduleMonth.DataSource = DS;
dgvScheduleMonth.DataMember = dtScheduleMonth.TableName;
dgvScheduleMonth.DataBind();
gvOtherTriggers.DataSource = otherTriggers;
gvOtherTriggers.DataBind();
Session[DSSchedule] = DS;
CloseTaskService();
}
else
{
DS = ((DataSet)Session[DSSchedule]);
if (DS == null) // вероятно, сессия завершилась и все ее данные утеряны
{
Reports_GeneralReports.Redirect(this);
}
}
send_created_report.Visible = _generalReport.IsSuccessfulyProcessed;
}
private void SaveTriggers()
{
for (int i = currentTaskDefinition.Triggers.Count - 1; i >= 0; i--)
{
if (currentTaskDefinition.Triggers[i] is WeeklyTrigger)
{
currentTaskDefinition.Triggers.RemoveAt(i);
continue;
}
if (currentTaskDefinition.Triggers[i] is MonthlyTrigger)
{
currentTaskDefinition.Triggers.RemoveAt(i);
}
}
foreach (DataRow dr in DS.Tables[dtSchedule.TableName].Rows)
{
short h = Convert.ToInt16(dr[SStartHour.ColumnName]);
short m = Convert.ToInt16(dr[SStartMinute.ColumnName]);
triggerDays = 0;
AddDay(dr, DaysOfTheWeek.Monday);
AddDay(dr, DaysOfTheWeek.Tuesday);
AddDay(dr, DaysOfTheWeek.Wednesday);
AddDay(dr, DaysOfTheWeek.Thursday);
AddDay(dr, DaysOfTheWeek.Friday);
AddDay(dr, DaysOfTheWeek.Saturday);
AddDay(dr, DaysOfTheWeek.Sunday);
var trigger = (WeeklyTrigger)currentTaskDefinition.Triggers.AddNew(TaskTriggerType.Weekly);
trigger.DaysOfWeek = triggerDays;
trigger.WeeksInterval = 1;
trigger.StartBoundary = DateTime.Now.Date.AddHours(h).AddMinutes(m);
}
foreach (DataRow dr in DS.Tables[dtScheduleMonth.TableName].Rows)
{
var trigger = (MonthlyTrigger)currentTaskDefinition.Triggers.AddNew(TaskTriggerType.Monthly);
short h = Convert.ToInt16(dr[MSStartHour.ColumnName]);
short m = Convert.ToInt16(dr[MSStartMinute.ColumnName]);
MonthsOfTheYear month;
MonthsOfTheYear allmonth = 0;
for (int i = 1; i <= 12; i++)
{
if ((byte)dr["m" + i] > 0)
{
MonthsOfTheYear.TryParse((1 << (i - 1)).ToString(), true, out month);
allmonth |= month;
}
}
var dayInt = new List <int>();
for (int i = 1; i <= 31; i++)
{
if ((byte)dr["d" + i] > 0)
{
dayInt.Add(i);
//monthInt |= i;
}
}
trigger.DaysOfMonth = dayInt.ToArray();
trigger.MonthsOfYear = allmonth;
trigger.StartBoundary = DateTime.Now.Date.AddHours(h).AddMinutes(m);
}
}
