private ReportInfo GetReportInfo()
{
return(new ReportInfo
{
Identifier = "WearStatement",
Parameters = new Dictionary <string, object>
{
{ "id", ComboWorks.GetActiveId(comboObject) },
}
});
}
private ReportInfo GetReportInfo()
{
int r = ComboWorks.GetActiveId(comboObject);
return(new ReportInfo {
Title = "Складская ведомость",
Identifier = "StockAllWear",
Parameters = new Dictionary <string, object>
{
{ "id", ComboWorks.GetActiveId(comboObject) },
}
});
}
protected void OnButtonOkClicked(object sender, EventArgs e)
{
string param = String.Format("status={0}&start={1}&end={2}&cost1={3}",
ComboWorks.GetActiveId(comboStatus),
String.Format("{0:u}", selectperiod1.DateBegin).Substring(0, 10),
String.Format("{0:u}", selectperiod1.DateEnd).Substring(0, 10),
1);
param += "&stock=";
foreach (KeyValuePair <string, Gtk.CheckButton> pair in checklistStock.CheckButtons)
{
if (pair.Value.Active)
{
param += String.Format("{0},", pair.Key);
}
}
logger.Debug(String.Format("Report parameters=|{0}|", param));
ViewReportExt.Run("glassorders", param.TrimEnd(','));
}
protected void OnComboObjectChanged(object sender, EventArgs e)
{
buttonRun.Sensitive = ComboWorks.GetActiveId(comboObject) > 0;
}
void UpdateJournal(bool nextPage = false)
{
DateTime startTime = DateTime.Now;
if (!nextPage)
{
takenRows = 0;
takenAll = false;
}
if (!canUpdate)
{
return;
}
logger.Info("Получаем журнал изменений{0}...", takenRows > 0 ? $"({takenRows}+)" : "");
ChangeSet changeSetAlias = null;
var query = UoW.Session.QueryOver <ChangedEntity>()
.JoinAlias(ce => ce.ChangeSet, () => changeSetAlias)
.Fetch(x => x.ChangeSet).Eager
.Fetch(x => x.ChangeSet.User).Eager;
if (!selectperiod.IsAllTime)
{
query.Where(ce => ce.ChangeTime >= selectperiod.DateBegin && ce.ChangeTime < selectperiod.DateEnd.AddDays(1));
}
var selectedClassType = (datacomboObject.SelectedItem as HistoryObjectDesc);
if (selectedClassType != null)
{
query.Where(ce => ce.EntityClassName == selectedClassType.ObjectName);
}
if (ComboWorks.GetActiveId(comboUsers) > 0)
{
query.Where(() => changeSetAlias.User.Id == ComboWorks.GetActiveId(comboUsers));
}
if (comboAction.SelectedItem is EntityChangeOperation)
{
query.Where(ce => ce.Operation == (EntityChangeOperation)comboAction.SelectedItem);
}
if (!String.IsNullOrWhiteSpace(entrySearchEntity.Text))
{
var pattern = $"%{entrySearchEntity.Text}%";
query.Where(ce => ce.EntityTitle.IsLike(pattern));
}
if (!String.IsNullOrWhiteSpace(entrySearchValue.Text) || comboProperty.SelectedItem is HistoryFieldDesc)
{
FieldChange fieldChangeAlias = null;
query.JoinAlias(ce => ce.Changes, () => fieldChangeAlias);
var selectedProperty = comboProperty.SelectedItem as HistoryFieldDesc;
if (selectedProperty != null)
{
query.Where(() => fieldChangeAlias.Path == selectedProperty.FieldName);
}
if (!String.IsNullOrWhiteSpace(entrySearchValue.Text))
{
var pattern = $"%{entrySearchValue.Text}%";
query.Where(() => fieldChangeAlias.OldValue.IsLike(pattern) ||
fieldChangeAlias.NewValue.IsLike(pattern));
}
}
var taked = query.OrderBy(x => x.ChangeTime).Desc
.Skip(takenRows)
.Take(pageSize)
.List();
if (takenRows > 0)
{
changedEntities.AddRange(taked);
datatreeChangesets.YTreeModel.EmitModelChanged();
}
else
{
changedEntities = taked.ToList();
datatreeChangesets.ItemsDataSource = changedEntities;
}
if (taked.Count < pageSize)
{
takenAll = true;
}
takenRows = changedEntities.Count;
logger.Debug("Время запроса {0}", DateTime.Now - startTime);
logger.Info(NumberToTextRus.FormatCase(changedEntities.Count, "Загружено изменение {0}{1} объекта.", "Загружено изменение {0}{1} объектов.", "Загружено изменение {0}{1} объектов.", takenAll ? "" : "+"));
}