private void PublishUnpublish(long id, AvrTreeElementType type, bool isPublish)
{
switch (type)
{
case AvrTreeElementType.Query:
using (var service = new Query_DB())
{
service.PublishUnpublish(id, isPublish);
}
break;
case AvrTreeElementType.Layout:
using (var service = new WebLayoutDB())
{
service.PublishUnpublish(id, isPublish);
}
break;
case AvrTreeElementType.Folder:
using (var service = new Folder_DB())
{
service.PublishUnpublish(id, isPublish);
}
break;
default:
throw new AvrException("Unsupported AvrTreeElementType " + type);
}
}
public ActionResult QueryLayoutTreeDeletePartial(long id)
{
//все проверки в CanDelete
List <AvrTreeElement> tree = GetQueryTree();
AvrTreeElement node = tree.FirstOrDefault(c => c.ID == id);
string errStr = String.Empty;
try
{
if (node != null)
{
if (node.IsFolder)
{
//AvrQueryLayoutTreeDbHelper.DeleteFolder(node.ID);
using (var avrDbService = new Folder_DB())
{
avrDbService.Delete(node.ID);
}
}
else if (node.IsLayout)
{
using (var avrDbService = new WebLayoutDB())
{
avrDbService.Delete(node.ID);
}
}
RefreshTree();
}
}
catch (Exception exc)
{
errStr = exc.Message;
}
return(PartialView("QueryLayoutTreePartial", GetQueryTree()));
/*
* return new JsonResult
* {
* JsonRequestBehavior = JsonRequestBehavior.AllowGet,
* Data = new
* {
* result = errStr.Length == 0 ? "OK" : "ERROR",
* errorString = errStr
* }
* };
*/
}
public static AvrPivotGridModel FillData(ref long queryId, long layoutId)
{
var service = new WebLayoutDB();
var sessionDataSet = (LayoutDetailDataSet)service.GetDetail(layoutId);
if (queryId <= 0)
{
queryId = ((LayoutDetailDataSet.LayoutRow)sessionDataSet.Layout.Rows[0]).idflQuery;
}
var helper = new LayoutHelper(sessionDataSet);
var settings = new AvrPivotSettings(queryId, layoutId);
helper.InitAvrPivotSettings(settings);
bool isNewObject;
string errorMessage;
AvrDataTable data = LayoutPivotGridHelper.GetPivotData(
helper.LayoutDataSet,
queryId,
layoutId,
settings.UseArchiveData,
settings.ApplyFilter ? settings.FilterCriteriaString :string.Empty,
out isNewObject, out errorMessage);
if (!string.IsNullOrEmpty(errorMessage))
{
throw new AvrException(errorMessage);
}
settings.Fields = AvrPivotGridHelper.CreateFields <WebPivotGridField>(data);
helper.PrepareWebFields(settings);
List <IAvrPivotGridField> fields = settings.Fields.Cast <IAvrPivotGridField>().ToList();
LayoutValidateResult result = helper.LoadPivotFromDB(new AvrPivotGridData(data), fields, isNewObject);
var model = new AvrPivotGridModel(settings, data);
if (result.IsCancelOrUserDialogCancel())
{
model.HideDataForComplexLayout();
}
return(model);
}
public bool SaveData(AvrPivotSettings settings)
{
List <IAvrPivotGridField> fields = settings.Fields.Cast <IAvrPivotGridField>().ToList();
AvrPivotGridHelper.PrepareLayoutSearchFieldsBeforePost(fields,
LayoutDataSet.LayoutSearchField, settings.QueryId, settings.LayoutId);
var db = new WebLayoutDB();
db.SetQueryID(settings.QueryId);
LayoutRow.idfsDefaultGroupDate = settings.DefaultGroupInterval;
LayoutRow.blnShowColsTotals = settings.ShowColumnTotals;
LayoutRow.blnShowRowsTotals = settings.ShowRowTotals;
LayoutRow.blnShowColGrandTotals = settings.ShowColumnGrandTotals;
LayoutRow.blnShowRowGrandTotals = settings.ShowRowGrandTotals;
LayoutRow.blnShowForSingleTotals = settings.ShowTotalsForSingleValues;
LayoutRow.blnShowMissedValuesInPivotGrid = settings.ShowMissedValues;
LayoutRow.blnApplyPivotGridFilter = settings.ApplyFilter;
LayoutRow.blnCompactPivotGrid = settings.CompactLayout;
LayoutRow.blnFreezeRowHeaders = settings.FreezeRowHeaders;
LayoutRow.blnUseArchivedData = settings.UseArchiveData;
LayoutRow.strPivotGridSettings = settings.FilterCriteriaString;
LayoutRow.blnShowDataInPivotGrid = settings.ShowDataInPivot;
return(db.PostDetail(m_DataSet, (int)PostType.FinalPosting));
}