public void FillTables(IEnumerable <IObject> tables)
{
if (tables == null)
{
return;
}
lstObject.BeginUpdate();
lstObject.Items.Clear();
foreach (var t in tables)
{
var titem = new TreeListItem();
lstObject.Items.Add(titem);
titem.Image = (t as Table).IsView ? Properties.Resources.view : Properties.Resources.table;
titem.Checked = true;
titem.Tag = t;
titem.Cells[0].Value = t.Name;
titem.Cells[1].Value = t.Description;
t.As <INotifyPropertyChanged>(s => s.PropertyChanged += (o, e) =>
{
UpdateObject(o, e.PropertyName);
});
foreach (var f in t.Fields)
{
var citem = new TreeListItem();
titem.Items.Add(citem);
var c = f as Column;
if (c != null)
{
if (c.ForeignKey != null)
{
citem.Image = Properties.Resources.fk;
}
else if (c.IsPrimaryKey)
{
citem.Image = Properties.Resources.pk;
}
else
{
citem.Image = Properties.Resources.column;
}
}
citem.Checked = true;
citem.Tag = f;
citem.Cells[0].Value = f.Name;
citem.Cells[1].Value = f.Description;
f.As <INotifyPropertyChanged>(s => s.PropertyChanged += (o, e) =>
{
UpdateObject(o, e.PropertyName);
});
}
}
lstObject.EndUpdate();
}
private void AddHandlerEvents(TreeListItem item)
{
item.Click = HandleClick;
item.Dragged = PrepareDragDrop;
item.CustomIconBuilder = CustomIconHandler;
}
private void Start()
{
SelectedItem = null;
}
private void LoadData()
{
using (new VI.FormBase.UpdateHelper(m_TreeList))
{
m_TreeList.Nodes.Clear();
// Daten holen und prüfen
ISingleDbObject dbobject = m_MainActivator.DbObject;
if (dbobject == null || !dbobject.TableDef.CanSee)
{
return;
}
IColDbObject col = Connection.CreateCol(m_DataStore.String1);
col.Prototype.WhereClause = SqlFormatter.Comparison(m_DataStore.String2, FormTool.GetValueSafe(dbobject, m_DataStore.String2, ""), ValType.String);
col.Prototype.Columns["CountLicMacDirectTarget"].IsDisplayItem = true;
col.Prototype.Columns["CountLicMacIndirectTarget"].IsDisplayItem = true;
col.Prototype.Columns["CountLicUserTarget"].IsDisplayItem = true;
col.Prototype.Columns["CountLicMacPossTarget"].IsDisplayItem = true;
col.Prototype.Columns["CountLicMacDirectActual"].IsDisplayItem = true;
col.Prototype.Columns["CountLicMacDirectActual"].IsDisplayItem = true;
col.Prototype.Columns["CountLicMacIndirectActual"].IsDisplayItem = true;
col.Prototype.Columns["CountLicUserActual"].IsDisplayItem = true;
col.Prototype.Columns["CountLicMacPossActual"].IsDisplayItem = true;
col.Prototype.Columns["CountLicMacReal"].IsDisplayItem = true;
col.Prototype.Columns["CountLimit"].IsDisplayItem = true;
col.Load();
bool canedit = col.Prototype.Columns["CountLimit"].CanEdit;
bool[] cansees = new bool[]
{
col.Prototype.Columns["UID_Licence"].CanSee,
col.Prototype.Columns["CountLimit"].CanSee,
col.Prototype.Columns["CountLicMacDirectActual"].CanSee,
col.Prototype.Columns["CountLicMacDirectTarget"].CanSee,
col.Prototype.Columns["CountLicMacIndirectActual"].CanSee,
col.Prototype.Columns["CountLicMacIndirectTarget"].CanSee,
col.Prototype.Columns["CountLicMacPossActual"].CanSee,
col.Prototype.Columns["CountLicMacPossTarget"].CanSee,
col.Prototype.Columns["CountLicMacReal"].CanSee,
col.Prototype.Columns["CountLicUserActual"].CanSee,
col.Prototype.Columns["CountLicUserTarget"].CanSee,
};
// und Grid füllen
foreach (IColElem elem in col)
{
ISingleDbObject obj = elem.Create();
ISingleDbObject identfk = obj.GetFK("UID_Licence").Create();
string ident = identfk != null ? identfk["Ident_Licence"].New.String : "";
TreeListNode node = m_TreeList.Nodes.Add(cansees[0] ? ident : "", 0);
node.ForeColor = SystemColors.ControlDark;
ITreeListItem subitem = canedit ? new TreeListItemTextBox(cansees[1] ? elem["CountLimit"].ToString() : "", 8) :
new TreeListItem(cansees[1] ? elem["CountLimit"].ToString() : "");
node.SubItems.Add(subitem);
subitem.ForeColor = canedit ? SystemColors.ControlText : SystemColors.ControlDark;
subitem = new TreeListItem(cansees[2] ? elem["CountLicMacReal"].ToString() : "");
node.SubItems.Add(subitem);
subitem.ForeColor = SystemColors.ControlDark;
subitem = new TreeListItem(cansees[3] ? elem["CountLicUserActual"].ToString() : "");
node.SubItems.Add(subitem);
subitem.ForeColor = SystemColors.ControlDark;
subitem = new TreeListItem(cansees[4] ? elem["CountLicUserTarget"].ToString() : "");
node.SubItems.Add(subitem);
subitem.ForeColor = SystemColors.ControlDark;
subitem = new TreeListItem(cansees[5] ? elem["CountLicMacDirectActual"].ToString() : "");
node.SubItems.Add(subitem);
subitem.ForeColor = SystemColors.ControlDark;
subitem = new TreeListItem(cansees[6] ? elem["CountLicMacDirectTarget"].ToString() : "");
node.SubItems.Add(subitem);
subitem.ForeColor = SystemColors.ControlDark;
subitem = new TreeListItem(cansees[7] ? elem["CountLicMacIndirectActual"].ToString() : "");
node.SubItems.Add(subitem);
subitem.ForeColor = SystemColors.ControlDark;
subitem = new TreeListItem(cansees[8] ? elem["CountLicMacIndirectTarget"].ToString() : "");
node.SubItems.Add(subitem);
subitem.ForeColor = SystemColors.ControlDark;
subitem = new TreeListItem(cansees[9] ? elem["CountLicMacPossActual"].ToString() : "");
node.SubItems.Add(subitem);
subitem.ForeColor = SystemColors.ControlDark;
subitem = new TreeListItem(cansees[10] ? elem["CountLicMacPossTarget"].ToString() : "");
node.SubItems.Add(subitem);
subitem.ForeColor = SystemColors.ControlDark;
node.Tag = obj;
}
}
}
public Exporter Export(IExport export)
{
int i = 0;
if (_title == null)
{
_title = new List <List <StoreColumn> >();
_title.Add(new List <StoreColumn>());
//PFDataHelper.EachListHeader(_data, (i, field, type) => _title[0].Add(new StoreColumn() { title = field, field = field, rowspan = 1, colspan = 1 }));
PFDataHelper.EachListHeader(_data, (a, field, type) => _title[0].Add(new StoreColumn()
{
title = field,
data = field
//, rowspan = 1, colspan = 1
}));
}
Dictionary <int, int> currentHeadRow = new Dictionary <int, int>();
Dictionary <string, List <int> > fieldIndex = new Dictionary <string, List <int> >();
int titleRowCount = 0;
if (!string.IsNullOrWhiteSpace(_sheetTitle))
{
titleRowCount++;
}
Func <int, int> GetCurrentHeadRow = cell => currentHeadRow.ContainsKey(cell) ? currentHeadRow[cell] : titleRowCount;
var currentRow = 0;
var currentCell = 0;
export.Init(_data, _printPageScheme);
//标题--wxj20181011
var temp = new StoreColumn {
Children = _columns
};
int columnCount = temp.GetAllLeafCount(a => a.visible);
var firstData = temp.FirstLeaf(a => true).data;
if (!string.IsNullOrWhiteSpace(_sheetTitle))
{
export.FillData(0, 0, firstData, _sheetTitle);
export.SetTitleStyle(0, 0, columnCount - 1, 0);
currentRow++;
}
//Stopwatch sw = new Stopwatch();
//sw.Start();
//int resultCount = 0;
#region 3秒(后来发现只有调试时特别慢,原因未明)
////生成多行题头
for (i = 0; i < _title.Count; i++)
{
currentCell = 0;
for (var j = 0; j < _title[i].Count; j++)
{
var item = _title[i][j];
if (item.visible == false)
{
continue;
} //隐藏列不导出--wxj20181009
while (currentRow < GetCurrentHeadRow(currentCell))
{
currentCell++;
}
//export.FillData(currentCell, currentRow, "title_" + item.data, item.title);
export.FillData(currentCell, currentRow, "title_" + item.data, item.title ?? item.data);//e:\svn\businesssys2018\yjquery.web\areas\bonus\views\reportquery05\treegrid.cshtml里的title是null
if (item.rowspan + item.colspan > 2)
{
export.MergeCell(currentCell, currentRow, currentCell + item.colspan - 1, currentRow + item.rowspan - 1);
}
if (!string.IsNullOrEmpty(item.data))
{
if (!fieldIndex.ContainsKey(item.data))
{
fieldIndex[item.data] = new List <int>();
}
fieldIndex[item.data].Add(currentCell);
}
for (var k = 0; k < item.colspan; k++)
{
currentHeadRow[currentCell] = GetCurrentHeadRow(currentCell++) + item.rowspan;
}
//resultCount++;
}
currentRow++;
}
#endregion
#region 一样是3秒
////生成多行题头
//foreach (var ii in _title)
//{
// currentCell = 0;
// foreach (var j in ii)
// {
// //var item = _title[i][j];
// var item = j;
// if (item.visible == false) { continue; }//隐藏列不导出--wxj20181009
// //if (item.hidden) continue;
// while (currentRow < GetCurrentHeadRow(currentCell))
// currentCell++;
// //export.FillData(currentCell, currentRow, "title_" + item.data, item.title);
// export.FillData(currentCell, currentRow, "title_" + item.data, item.title ?? item.data);//e:\svn\businesssys2018\yjquery.web\areas\bonus\views\reportquery05\treegrid.cshtml里的title是null
// if (item.rowspan + item.colspan > 2)
// export.MergeCell(currentCell, currentRow, currentCell + item.colspan - 1, currentRow + item.rowspan - 1);
// if (!string.IsNullOrEmpty(item.data))
// {
// if (!fieldIndex.ContainsKey(item.data))
// fieldIndex[item.data] = new List<int>();
// fieldIndex[item.data].Add(currentCell);
// }
// for (var k = 0; k < item.colspan; k++)
// currentHeadRow[currentCell] = GetCurrentHeadRow(currentCell++) + item.rowspan;
// }
// currentRow++;
//}
#endregion
//sw.Stop();
//var aa = string.Format("插入{0}条记录共花费{1}毫秒，{2}分钟", resultCount, sw.ElapsedMilliseconds, sw.ElapsedMilliseconds / 1000 / 60);
//设置题头样式
//export.SetHeadStyle(0, 0, currentCell - 1, currentRow - 1);
export.SetHeadStyle(0, titleRowCount, currentHeadRow.Count - 1, currentRow - 1);//上面那样,当后面的列不是多表头时,背景色只填到最后一个多表头为止
////设置数据样式
var dataCount = 0;
if (_data is PagingResult)
{
var data = _data as PagingResult;
var list = data.data as ArrayList;
if (list != null)
{
for (var rowIndex = 0; rowIndex < list.Count; rowIndex++)
{
dataCount++;
}
}
else
{
var list1 = data.data as List <TreeListItem>;
if (list1 != null)
{
(new TreeListItem {
Children = list1
}).EachChild(a => dataCount++);
}
}
}
else
{
PFDataHelper.EachListRow(_data, (a, r) => dataCount++);//原版
}
////export.SetRowsStyle(0, currentRow, currentCell - 1, currentRow + dataCount - 1);
//此句内报错，要优化--benjamin todo
if (!PFDataHelper.IsDebug)
{
export.SetRowsStyle(0, currentRow, currentHeadRow.Count - 1, currentRow + dataCount - 1);//上面那样,当后面的列不是多表头时,边框不见了
}
//填充数据
if (_data is PagingResult)
{
var data = _data as PagingResult;
if (data.data is List <TreeListItem> )
{
export.SetFont(0, currentRow, 0, currentRow + dataCount - 1, "宋体");//默认的Arial字体中,树型的┝等符号对不齐--benjamin20190711
var tree = new TreeListItem();
tree.Children = data.data as List <TreeListItem>;
int rowIndex = 0;
//int colIndex = 0;
var matrix = new TreeMatrix(tree.Children);
tree.EachChild((a, deep) =>
{
//colIndex = 0;
PFDataHelper.EachObjectProperty(a.Data, (b, name, value) =>
{
if (fieldIndex.ContainsKey(name))
{
foreach (int cellIndex in fieldIndex[name])
{
if (_fieldFormatter.ContainsKey(name))
{
value = _fieldFormatter[name].Format(value);
}
//if (colIndex == 0)
if (cellIndex == 0)
{
var line = "";
for (var j = 0; j < deep - 2; j++)
{
//line += string.Format("<div class='{0} {1}'></div>", "tree-tr-linearea ", GetClassByTreeMatrixNetLine(matrix.GetNetLine(j, rowIdx)));
line += matrix.GetNetLineString(j, rowIndex);
}
value = line + PFDataHelper.ObjectToString(value);
//var line = GetClassByTreeMatrixNetLine(matrix.GetNetLine(cellIndex, currentRow))
}
export.FillData(cellIndex, currentRow, name, value);
}
//colIndex++;
}
});
rowIndex++;
currentRow++;
});
}
else
{
var list = data.data as ArrayList;
for (var rowIndex = 0; rowIndex < list.Count; rowIndex++)
{
var rowData = list[rowIndex] as Dictionary <string, object>;
for (i = 0; i < rowData.Count; i++)
{
var name = rowData.ElementAt(i).Key;
var value = rowData.ElementAt(i).Value;
if (fieldIndex.ContainsKey(name))
{
foreach (int cellIndex in fieldIndex[name])
{
if (_fieldFormatter.ContainsKey(name))
{
value = _fieldFormatter[name].Format(value);
}
export.FillData(cellIndex, currentRow, name, value);
}
}
}
currentRow++;
}
}
}
else
{
//原版
PFDataHelper.EachListRow(_data, (rowIndex, rowData) =>
{
PFDataHelper.EachObjectProperty(rowData, (a, name, value) =>
{
if (fieldIndex.ContainsKey(name))
{
foreach (int cellIndex in fieldIndex[name])
{
if (_fieldFormatter.ContainsKey(name))
{
value = _fieldFormatter[name].Format(value);
}
export.FillData(cellIndex, currentRow, name, value);
}
}
});
currentRow++;
});
}
//汇总行
bool hasSummary = false;
i = 0;
int firstSummary = 0;//第一个有汇总的格的位置
string firstSummaryField = "";
new StoreColumn {
Children = _columns
}.EachLeaf(a =>
{
//设置列宽--wxjtodo20190417
if (!PFDataHelper.StringIsNullOrWhiteSpace(a.width))
{
//export.SetColumnWidth(i, PFDataHelper.WebWidthToExcel(a.width).Value);
export.SetColumnWidth(i, a.width);
}
//if (a.excelWidth.HasValue)
//{
// export.SetColumnWidth(i, double.Parse(a.width.Replace("px", "")));
//}
//var column = _title[_title.Count - 1][i];
if (a.visible)
{
var column = a;
if (!hasSummary)
{
firstSummary = i; firstSummaryField = column.data;
}
if (column.summary != null)
{
hasSummary = true;
export.FillData(i, currentRow, column.data, column.summary);
}
i++;
}
});
if (hasSummary)
{
export.FillData(firstSummary - 1, currentRow, firstSummaryField, "合计：");
export.SetRowsStyle(0, currentRow, columnCount - 1, currentRow);//上面那样,当后面的列不是多表头时,边框不见了
currentRow++;
}
//Foot--wxj20181011
if (!string.IsNullOrWhiteSpace(_sheetFoot))
{
export.FillData(0, currentRow, firstData, _sheetFoot);
export.SetFootStyle(0, currentRow, columnCount - 1, currentRow);
//titleRowCount++;
currentRow++;
}
_exporter = export;
//_fileStream = export.SaveAsStream();
_suffix = export.suffix;
if (string.IsNullOrEmpty(_fileName))
{
_fileName = DateTime.Now.ToString("yyyyMMddHHmmss");
}
return(this);
}
public TreeListItem(TreeListControl parentControl, TreeListItem parent)
{
ParentControl = parentControl;
Parent = parent;
}
