public ManagedTableForm(BizTableForm bizTableForm, BizDocumentListForm owner)
{
Owner = owner;
Id = Owner.Id;
Form = bizTableForm;
AttributeDefId = Owner.AttributeDefId;
Caption = Owner.Caption;
FormId = bizTableForm.FormId;
PageSize = bizTableForm.PageSize;
PageCount = bizTableForm.PageSize;
PageNo = bizTableForm.PageNo;
//PageCount = 1;
HeaderRowCount = 1;
if (bizTableForm.Children != null)
{
Columns = new List <Column>();
AddColumnChildren(null, Form);
}
}
public byte[] ExcelFromDocumentListForm(Guid documentId, BizDocumentListForm docListForm)
{
var form = docListForm.TableForm;
if (form == null && docListForm.FormId != null)
{
form = FormRepo.GetTableForm((Guid)docListForm.FormId);
}
if (form == null)
{
throw new ApplicationException("Табличная форма не указана!");
}
var sqb = _sqlQueryBuilderFactory.Create();
if (docListForm.AttributeDefId != null)
{
using (var query = sqb.BuildAttrList(form, documentId, (Guid)docListForm.AttributeDefId, null, null))
{
query.WithNoLock = true;
using (var reader = _sqlQueryReaderFactory.Create(query))
{
var defBuilder = new XlsGridDefBuilder(Provider, form, reader);
using (var def = defBuilder.BuildFromBizForm())
{
var builder = new XlsBuilder(def);
using (var workbook = builder.Build())
{
using (var stream = new MemoryStream())
{
workbook.Write(stream);
return(stream.ToArray());
}
}
}
}
}
}
if (docListForm.FormAttributeDefId != null)
{
using (var query = sqb.BuildRefList(form, documentId, (Guid)docListForm.FormAttributeDefId, null, null))
{
using (var reader = _sqlQueryReaderFactory.Create(query)) //new SqlQueryReader(DataContext, query))
{
var defBuilder = new XlsGridDefBuilder(Provider, form, reader);
using (var def = defBuilder.BuildFromBizForm())
{
var builder = new XlsBuilder(def);
using (var workbook = builder.Build())
{
using (var stream = new MemoryStream())
{
workbook.Write(stream);
return(stream.ToArray());
}
}
}
}
}
}
throw new ApplicationException("Не могу сформировать Excel файл! Атрибут не указан!");
}
