public static System.Web.WebPages.HelperResult RenderListColumns(this HtmlHelper htmlHelper, ListColumns columns)
{
return new System.Web.WebPages.HelperResult(__razor_helper_writer => {
#line 4 "..\..\Views\ListManage\Helpers.cshtml"
foreach (var column in columns)
{
#line default
#line hidden
#line 7 "..\..\Views\ListManage\Helpers.cshtml"
WebViewPage.WriteTo(@__razor_helper_writer, htmlHelper.RenderListColumn(column));
#line default
#line hidden
#line 7 "..\..\Views\ListManage\Helpers.cshtml"
}
#line default
#line hidden
});
}
public ListColumns GetColumnsForType(Type type, ControllerContext controllerContext)
{
var columns = new ListColumns();
var modelMetadata = ModelMetadataProviders.Current.GetMetadataForType(null, type);
var sortingValues = GetSortingValues(controllerContext);
foreach(var metadata in modelMetadata.Properties)
{
if(metadata.IsHidden()) continue;
var column = new ListColumn
{
DisplayName = metadata.GetDisplayName(),
Name = metadata.PropertyName,
IsSearchable = metadata.IsSearchable(),
Order = metadata.Order,
SortDirection = sortingValues.SortDirection,
Type = metadata.ModelType,
};
column.CellTemplate = FindCellTemplate(controllerContext, column.Name);
column.HasCellTemplate = column.CellTemplate != null;
column.IsSorted = column.Name.Equals(sortingValues.SortBy, StringComparison.InvariantCultureIgnoreCase);
column.SortUrl = GetSortUrlForColumn(controllerContext, column, sortingValues);
column.HeaderTemplate = FindHeaderTemplate(controllerContext, column.Name);
column.HasHeaderTemplate = column.HeaderTemplate != null;
columns.Add(column);
}
return columns;
}
protected void listTables_SelectedIndexChanged(object sender, EventArgs e)
{
string tablename = listTables.SelectedValue;
if (tablename != "")
{
DataTable dt = new BLL.DataBaseHelper().GetShemaColumnName(tablename);
DataView dtv = dt.DefaultView;
dtv.Sort = "ordinal_position";
ListColumns.DataSource = dtv;
ListColumns.DataValueField = "column_name";
ListColumns.DataTextField = "column_name";
ListColumns.DataBind();
}
}
public void Test_LMGroup()
{
var listManager = new GroupListMan(fContext);
Assert.IsNotNull(listManager);
var grpRec = fContext.Tree.XRefIndex_Find("G1") as GDMGroupRecord;
listManager.Fetch(grpRec);
listManager.QuickFilter = "*";
Assert.IsTrue(listManager.CheckFilter());
listManager.QuickFilter = "*roup*";
Assert.IsTrue(listManager.CheckFilter());
listManager.QuickFilter = "*alpha*";
Assert.IsFalse(listManager.CheckFilter());
var listView = Substitute.For <IListViewEx>();
listManager.UpdateColumns(listView);
var listItem = new GKListItem("", null);
listManager.UpdateItem(0, listItem, grpRec);
//
var colVal = listManager.GetColumnInternalValue(0);
Assert.IsNotNull(colVal);
var data = listManager.GetItemData(grpRec);
Assert.IsNotNull(data);
Assert.IsTrue(data.Length > 0);
//
IListFilter filter = listManager.Filter;
IListColumns listColumns = listManager.ListColumns;
ListColumns copyColumns = GroupListMan.CreateGroupListColumns();
listColumns.CopyTo(copyColumns);
Assert.Throws(typeof(ArgumentNullException), () => { listColumns.CopyTo(null); });
listManager.QuickFilter = "*";
listManager.AddCondition((byte)GroupColumnType.ctName, ConditionKind.ck_Contains, "*roup*");
Assert.IsTrue(listManager.CheckFilter());
}
public OptionsDlg(IHost host)
{
InitializeComponent();
btnAccept.Image = UIHelper.LoadResourceImage("Resources.btn_accept.gif");
btnCancel.Image = UIHelper.LoadResourceImage("Resources.btn_cancel.gif");
btnColumnUp.Image = UIHelper.LoadResourceImage("Resources.btn_up.gif");
btnColumnDown.Image = UIHelper.LoadResourceImage("Resources.btn_down.gif");
fHost = host;
fOptions = GlobalOptions.Instance;
fTempColumns = IndividualListMan.CreateIndividualListColumns();
SetLang();
UpdateForm();
}
public OptionsDlg(IHost host)
{
InitializeComponent();
btnAccept.Image = GKResources.iBtnAccept;
btnCancel.Image = GKResources.iBtnCancel;
btnColumnUp.Image = GKResources.iUp;
btnColumnDown.Image = GKResources.iDown;
fHost = host;
fOptions = GlobalOptions.Instance;
fTempColumns = IndividualListMan.CreateIndividualListColumns();
SetLang();
UpdateForm();
}
private GlobalOptions()
{
fTreeChartOptions = new TreeChartOptions();
fEventFilters = new StringList();
fMRUFiles = new List <MRUFile>();
fNameFilters = new StringList();
fResidenceFilters = new StringList();
fPedigreeOptions = new PedigreeOptions();
fProxy = new ProxyOptions();
fRelations = new StringList();
fCircleChartOptions = new CircleChartOptions();
fGeocoder = "Google";
fRemovableMediaWarning = true;
fLoadRecentFiles = true;
fEmbeddedMediaPlayer = true;
fAllowMediaStoreReferences = false;
fAllowMediaStoreRelativeReferences = true;
fMediaStoreDefault = 0;
fAllowDeleteMediaFileFromStgArc = true;
fAllowDeleteMediaFileFromRefs = false;
fDeleteMediaFileWithoutConfirm = false;
fUseExtendedNotes = false;
fAutoCheckUpdates = true;
fAutoSortChildren = true;
fAutoSortSpouses = false;
fCheckTreeSize = true;
fIndividualListColumns = IndividualListMan.CreateIndividualListColumns();
fIndividualListColumns.ResetDefaults();
fLanguages = new List <LangRecord>();
fLastBases = new StringList();
fAutosave = false;
fAutosaveInterval = 10;
fListOptions = new ListOptionsCollection();
fReadabilityHighlightRows = true;
fShortKinshipForm = false;
fSurnameFirstInOrder = true;
fCharsetDetection = false;
fFirstCapitalLetterInNames = false;
fGeoSearchCountry = string.Empty;
}
public void InitDataSource(ListColumns cols, TreeNodeCollection nodes)
{
dataGridView1.Rows.Add(cols.Count);
DataGridViewComboBoxColumn col = dataGridView1.Columns[1] as DataGridViewComboBoxColumn;
for (int i = 0; i < nodes.Count; i++)
{
col.Items.Add(nodes[i].Name);
}
for (int i = 0; i < cols.Count; i++)
{
dataGridView1.Rows[i].Cells[0].Value = cols.get_Item(i + 1).Name;
}
dataGridView1.AllowUserToAddRows = false;
dataGridView1.AllowUserToDeleteRows = false;
dataGridView1.Columns[0].ReadOnly = true;
}
public OptionsDlg(IHost host)
{
InitializeComponent();
btnAccept.Image = UIHelper.LoadResourceImage("Resources.btn_accept.gif");
btnCancel.Image = UIHelper.LoadResourceImage("Resources.btn_cancel.gif");
btnColumnUp.Image = UIHelper.LoadResourceImage("Resources.btn_up.gif");
btnColumnDown.Image = UIHelper.LoadResourceImage("Resources.btn_down.gif");
fOptions = GlobalOptions.Instance;
fTempColumns = IndividualListMan.CreateIndividualListColumns();
cmbGeoSearchCountry.Items.Clear();
foreach (var ci in GKUtils.GetCountries())
{
cmbGeoSearchCountry.Items.Add(ci);
}
SetLocale();
UpdateForm();
}
public void Setup()
{
form = new NameValueCollection();
columns = new ListColumns();
listViewModel = new ListViewModel {Columns = columns};
httpContext = new MockHttpContext();
((MockHttpRequest)httpContext.Request).SetForm(form);
controllerContext = new ControllerContext();
controllerContext.HttpContext = httpContext;
ValueProviderFactories.Factories
.ReplaceWith<HttpFileCollectionValueProviderFactory>(ctx => ctx.HttpContext.Request.Form)
.ReplaceWith<FormValueProviderFactory>(ctx => ctx.HttpContext.Request.Form)
.ReplaceWith<QueryStringValueProviderFactory>(ctx => ctx.HttpContext.Request.QueryString);
bindingContext = new ModelBindingContext
{
ModelMetadata = ModelMetadata.FromLambdaExpression(parameter => parameter, new ViewDataDictionary<ListViewModel>(listViewModel))
};
binder = new ListViewModelBinder();
}
private GlobalOptions()
{
fTreeChartOptions = new TreeChartOptions();
fEventFilters = new StringList();
fMRUFiles = new List <MRUFile>();
fNameFilters = new StringList();
fResidenceFilters = new StringList();
fPedigreeOptions = new PedigreeOptions();
fProxy = new ProxyOptions();
fRelations = new StringList();
fCircleChartOptions = new CircleChartOptions();
fGeocoder = "Google";
fRemovableMediaWarning = true;
fLoadRecentFiles = true;
fEmbeddedMediaPlayer = true;
fAllowMediaStoreReferences = false;
fUseExtendedNotes = false;
fAutoCheckUpdates = true;
fAutoSortChildren = true;
fAutoSortSpouses = false;
fCheckTreeSize = true;
fIndividualListColumns = IndividualListMan.CreateIndividualListColumns();
fIndividualListColumns.ResetDefaults();
fLanguages = new List <LangRecord>();
fLastBases = new StringList();
fAutosave = false;
fAutosaveInterval = 10;
fListOptions = new ListOptionsCollection();
fReadabilityHighlightRows = true;
fCharsetDetection = false;
}
public CommonFilterDlg(IBaseWindow baseWin, IListManager listMan)
{
if (baseWin == null)
{
throw new ArgumentNullException("baseWin");
}
if (listMan == null)
{
throw new ArgumentNullException("listMan");
}
InitializeComponent();
btnAccept.Image = GKResources.iBtnAccept;
btnCancel.Image = GKResources.iBtnCancel;
fBase = baseWin;
fListMan = listMan;
ListColumns listColumns = (ListColumns)fListMan.ListColumns;
fFields = new string[listColumns.Count + 1]; // +empty item
fFields[0] = "";
for (int idx = 0; idx < listColumns.Count; idx++)
{
var cs = listColumns[idx];
fFields[idx + 1] = fListMan.GetColumnName(cs.Id);
}
SetLang();
InitGrid();
UpdateGrid();
}
public OptionsDlg(IHost host)
{
InitializeComponent();
btnAccept.Image = UIHelper.LoadResourceImage("Resources.btn_accept.gif");
btnCancel.Image = UIHelper.LoadResourceImage("Resources.btn_cancel.gif");
btnColumnUp.Image = UIHelper.LoadResourceImage("Resources.btn_up.gif");
btnColumnDown.Image = UIHelper.LoadResourceImage("Resources.btn_down.gif");
fHost = host;
fOptions = GlobalOptions.Instance;
fTempColumns = IndividualListMan.CreateIndividualListColumns();
lstPersonColumns.AddCheckedColumn("x", 75);
lstPersonColumns.AddColumn("Title", 100);
lvPlugins.AddColumn("Title", 75);
lvPlugins.AddColumn("Version", 100);
lvPlugins.AddColumn("Copyright", 125);
lvPlugins.AddColumn("Description", 250);
SetLang();
UpdateForm();
}
protected void AddListColumn <TProperty>(Expression <Func <TE, TProperty> > navigationPropertyPath)
{
ListColumns.Add(SymbolExtensions.GetPropertyInfo(navigationPropertyPath));
}
public void Test_Lists()
{
ListColumn colStatic = new ListColumn(0, 0, DataType.dtString, 0, true);
Assert.IsNotNull(colStatic);
Assert.AreEqual(0, colStatic.Order);
Assert.AreEqual(false, colStatic.CurActive);
Assert.AreEqual(0, colStatic.CurWidth);
//
ListFilter listFilter = new ListFilter();
Assert.IsNotNull(listFilter);
Assert.AreEqual(0, listFilter.Conditions.Count);
listFilter.Clear();
Assert.AreEqual(0, listFilter.Conditions.Count);
ListManager listManager;
ListViewMock lvMock = new ListViewMock();
GKListItem listItem;
//
listManager = new GroupListMan(fContext);
Assert.IsNotNull(listManager);
GDMGroupRecord grpRec = fContext.Tree.XRefIndex_Find("G1") as GDMGroupRecord;
listManager.Fetch(grpRec);
listManager.QuickFilter = "*";
Assert.IsTrue(listManager.CheckFilter());
listManager.QuickFilter = "*roup*";
Assert.IsTrue(listManager.CheckFilter());
listManager.QuickFilter = "*alpha*";
Assert.IsFalse(listManager.CheckFilter());
listManager.UpdateColumns(lvMock);
listItem = new GKListItem("", null);
listManager.UpdateItem(0, listItem, grpRec);
//
var colVal = listManager.GetColumnInternalValue(0);
Assert.IsNotNull(colVal);
var data = listManager.GetItemData(grpRec);
Assert.IsNotNull(data);
Assert.IsTrue(data.Length > 0);
//
IListFilter filter = listManager.Filter;
IListColumns listColumns = listManager.ListColumns;
ListColumns copyColumns = GroupListMan.CreateGroupListColumns();
listColumns.CopyTo(copyColumns);
Assert.Throws(typeof(ArgumentNullException), () => { listColumns.CopyTo(null); });
listManager.QuickFilter = "*";
listManager.AddCondition((byte)GroupColumnType.ctName, ConditionKind.ck_Contains, "*roup*");
Assert.IsTrue(listManager.CheckFilter());
}
protected override void SetListColumns()
{
ListColumns.AddRange(GetRelevantProperties());
}
/// <summary>
/// MyXls导出
/// </summary>
/// <returns></returns>
public byte[] GenerateExcel()
{
XlsDocument xls = new XlsDocument();
Worksheet sheet = xls.Workbook.Worksheets.Add("Sheet1");//状态栏标题名称
Cells cells = sheet.Cells;
MakeExcelHeader(ListColumns, cells, 1, 1);
int rowIndex = ListColumns.Max(x => x.MaxLevel);
int colIndex = 0;
//List<Color> allcolors = new List<Color>();
//allcolors.Add(Colors.Default08);
//allcolors.Add(Colors.Default09);
//allcolors.Add(Colors.Default0A);
//allcolors.Add(Colors.Default0B);
//allcolors.Add(Colors.Default0C);
//allcolors.Add(Colors.Default0D);
//allcolors.Add(Colors.Default0E);
//allcolors.Add(Colors.Default0F);
//allcolors.Add(Colors.Default10);
//allcolors.Add(Colors.Default11);
//allcolors.Add(Colors.Default12);
//allcolors.Add(Colors.Default13);
//allcolors.Add(Colors.Default14);
//allcolors.Add(Colors.Default15);
//allcolors.Add(Colors.Default16);
//allcolors.Add(Colors.Default17);
//allcolors.Add(Colors.Default18);
//allcolors.Add(Colors.Default19);
//allcolors.Add(Colors.Default20);
//allcolors.Add(Colors.Default1A);
//allcolors.Add(Colors.Default1B);
//allcolors.Add(Colors.Default1C);
//allcolors.Add(Colors.Default1D);
//allcolors.Add(Colors.Default1E);
//allcolors.Add(Colors.Default1F);
//allcolors.Add(Colors.Default20);
//allcolors.Add(Colors.Default21);
//allcolors.Add(Colors.Default22);
//allcolors.Add(Colors.Default23);
//allcolors.Add(Colors.Default24);
//allcolors.Add(Colors.Default25);
//allcolors.Add(Colors.Default26);
//allcolors.Add(Colors.Default27);
//allcolors.Add(Colors.Default28);
//allcolors.Add(Colors.Default29);
//allcolors.Add(Colors.Default2A);
//allcolors.Add(Colors.Default2B);
//allcolors.Add(Colors.Default2C);
//allcolors.Add(Colors.Default2D);
//allcolors.Add(Colors.Default2E);
//allcolors.Add(Colors.Default2F);
//allcolors.Add(Colors.Default30);
//allcolors.Add(Colors.Default31);
//allcolors.Add(Colors.Default32);
//allcolors.Add(Colors.Default33);
//allcolors.Add(Colors.Default34);
//allcolors.Add(Colors.Default35);
//allcolors.Add(Colors.Default36);
//allcolors.Add(Colors.Default37);
//allcolors.Add(Colors.Default38);
//allcolors.Add(Colors.Default39);
//allcolors.Add(Colors.Default3A);
//allcolors.Add(Colors.Default3B);
//allcolors.Add(Colors.Default3C);
//allcolors.Add(Colors.Default3D);
//allcolors.Add(Colors.Default3E);
//allcolors.Add(Colors.Default3F);
//int xx = 0;
Dictionary <IGridColumn <TModel>, int> sameCount = new Dictionary <IGridColumn <TModel>, int>();
foreach (var baseCol in ListColumns)
{
foreach (var col in baseCol.BottomChildren)
{
sameCount.Add(col, 0);
}
}
int i = 0;
foreach (var row in EntityList)
{
rowIndex++;
colIndex = 0;
foreach (var baseCol in ListColumns)
{
foreach (var col in baseCol.BottomChildren)
{
colIndex++;
//sheet.Cells.AddValueCell(rowIndex, colIndex, row[col.ColumnName].ToString());//将数据添加到xls表格里
//Cell cell= cells.AddValueCell(rowIndex, colIndex, Convert.ToDouble(row[col.ColumnName].ToString()));//转换为数字型
string cellValue = col.GetText(row).ToHtmlString();
object cv = cellValue;
int testInt;
decimal testFloat;
int floatRound = 0;
if (!cellValue.StartsWith("0"))
{
if (int.TryParse(cellValue, out testInt))
{
if (testInt <= 100000)
{
cv = testInt;
}
}
else if (decimal.TryParse(cellValue, out testFloat))
{
if (testFloat <= 100000)
{
cv = testFloat;
if (cellValue.Split('.').Count() > 1)
{
floatRound = cellValue.Split('.')[1].ToArray().Count(); //获取小数位数
}
}
}
}
else if (decimal.TryParse(cellValue, out testFloat))
{
if (testFloat == 0)//为0时
{
cv = 0;
floatRound = 0;
}
else if (testFloat < 1)//modify by yecs 2015-02-26 LSTC税收报表: 小数点的项目被显示为文本格式（小于1的小数）
{
cv = testFloat;
floatRound = cellValue.Split('.')[1].ToArray().Count();
}
}
Cell cell = cells.Add(rowIndex, colIndex, cv);
if (floatRound > 0)
{
cell.Format = "0.";
for (int x = 1; x <= floatRound; x++)
{
cell.Format += "0";
}
}
cell.TopLineStyle = 1;
cell.BottomLineStyle = 1;
cell.LeftLineStyle = 1;
cell.RightLineStyle = 1;
cell.UseBorder = true;
cell.VerticalAlignment = VerticalAlignments.Centered;
System.Drawing.Color backColor = col.GetBackGroundColor(row);
System.Drawing.Color foreColor = col.GetForeGroundColor(row);
if (backColor != System.Drawing.Color.Empty)
{
cell.Pattern = 1;
cell.PatternColor = UtilsTool.GetExcelColor(backColor);
}
if (col.NeedGroup == true && sameCount[col] == i)
{
sameCount[col] = sameCount[col] + 1;
string lastValue = col.GetText(row).ToHtmlString();
for (int j = i + 1; j < EntityList.Count; j++)
{
if (col.GetText(EntityList[j]).ToHtmlString() == lastValue)
{
sameCount[col] = sameCount[col] + 1;
}
else
{
break;
}
}
cells.Merge(rowIndex, rowIndex + sameCount[col] - i - 1, colIndex, colIndex);
}
}
}
i++;
}
return(xls.Bytes.ByteArray);
}
/// <summary>
/// 导出pdf
/// </summary>
/// <param name="IsHorizontal">是否为横向布局</param>
/// <param name="TableTitle">查询列表,表头数据</param>
/// <returns></returns>
public byte[] GeneratePDF(bool IsHorizontal = false, PdfHelper.PdfTableTitle TableTitle = null)
{
//设置pdf宽度
Rectangle pagesize = null;
if (IsHorizontal)
{
pagesize = new Rectangle(PageSize.A4.Height, PageSize.A4.Width);
}
else
{
pagesize = new Rectangle(PageSize.A4.Width, PageSize.A4.Height);
}
Document pdf = new Document(pagesize);
MemoryStream ms = new MemoryStream();
PdfWriter writer = PdfWriter.GetInstance(pdf, ms);
BaseFont bfSun = BaseFont.CreateFont(@"c:\windows\fonts\SIMSUN.TTC,0", BaseFont.IDENTITY_H, BaseFont.NOT_EMBEDDED);
iTextSharp.text.Font headerFont = new iTextSharp.text.Font(bfSun, 9);
iTextSharp.text.Font normalFont = new iTextSharp.text.Font(bfSun, 8);
pdf.Open();
//如果查询字符串不为空，则加表头
if (TableTitle != null)
{
//设置内容的左右上下margin
pdf.SetMargins(10, 10, 105, 30);
var pEvent = new PdfHelper.PDFEvent(bfSun, pagesize)
{
TableTitle = TableTitle
};
writer.PageEvent = pEvent;
//pEvent.CreateHeaderTemplate(write);
}
else
{
pdf.SetMargins(10, 10, 20, 20);
}
pdf.NewPage();
#region 导出数据表格
PdfPTable table = new PdfPTable(ListColumns.Sum(x => x.MaxChildrenCount));
table.KeepTogether = true;
table.TotalWidth = pagesize.Width;
table.WidthPercentage = 100;
table.DefaultCell.Border = 0;
table.DefaultCell.Padding = 1;
MakePdfHeader(ListColumns, table, headerFont);
Dictionary <IGridColumn <TModel>, int> sameCount = new Dictionary <IGridColumn <TModel>, int>();
foreach (var baseCol in ListColumns)
{
foreach (var col in baseCol.BottomChildren)
{
sameCount.Add(col, 0);
}
}
//int i = 0;
//foreach (var row in EntityList)
for (int i = 0; i < EntityList.Count; i++)
{
var row = EntityList[i];
foreach (var baseCol in ListColumns)
{
foreach (var col in baseCol.BottomChildren)
{
System.Drawing.Color backColor = col.GetBackGroundColor(row);
System.Drawing.Color foreColor = col.GetForeGroundColor(row);
if (foreColor != System.Drawing.Color.Empty)
{
normalFont.Color = new BaseColor(foreColor);
}
PdfPCell cell = new PdfPCell(new Phrase(col.GetText(row).ToHtmlString(), normalFont))
{
Border = 0, Padding = 1
};
if (backColor != System.Drawing.Color.Empty)
{
cell.BackgroundColor = new BaseColor(backColor);
}
if (col.NeedGroup == true && sameCount[col] == i)
{
sameCount[col] = sameCount[col] + 1;
string lastValue = col.GetText(row).ToHtmlString();
for (int j = i + 1; j < EntityList.Count; j++)
{
if (col.GetText(EntityList[j]).ToHtmlString() == lastValue)
{
sameCount[col] = sameCount[col] + 1;
}
else
{
break;
}
}
cell.Rowspan = sameCount[col] - i;
table.AddCell(cell);
}
if (col.NeedGroup == false)
{
table.AddCell(cell);
}
}
}
//如果有表头，需要每一页又要有表头
if (TableTitle != null && TableTitle.Count > 0 && (i + 1) % TableTitle.Count == 0)
{
pdf.Add(table);
pdf.NewPage();
table.Rows.Clear();
MakePdfHeader(ListColumns, table, headerFont);
}
//i++;
}
if (table.Rows.Count > 0)
{
pdf.Add(table);
}
#endregion
pdf.Close();
byte[] rv = ms.ToArray();
ms.Close();
return(rv);
}
