public static EasyUiGridData createGrid(string connName, string tableName)
{
DatabaseAdmin dba = DatabaseAdmin.getInstance(connName);
TableDef tableDef = dba.getTableDef(tableName);
string title = string.IsNullOrEmpty(tableDef.Title)?tableName:tableDef.Title;
return(EUGridUtils.getGrid(connName, title, tableDef.FieldDefs));
}
public EasyUiGridData drillTableToGrid(List <string> parentMembers)
{
DatabaseAdmin dba = DatabaseAdmin.getInstance(table.connection);
TableDef tbf = dba.getTableDef(table.name);
string title = string.IsNullOrEmpty(tbf.Title) ? table.name : tbf.Title;
EasyUiGridData ret = EUGridUtils.getGrid(table.connection, title, tbf.FieldDefs);
return(ret);
}
public static ListDataRow readRow(DataTable tb, DataSourceSchema dsSchema, DataRow dRow)
{
List <DataListColumn> fColumns = EUGridUtils.getColumns(dsSchema.Fields);
ListDataRow row = new ListDataRow();
foreach (DataListColumn dcol in fColumns)
// foreach (FieldSchema fldSchema in _schema.Fields)
//foreach (DataColumn col in tb.Columns)
{
string fName = dcol.field;
if (fName.StartsWith(XSqlBuilder.OLD_VERSION_PIX))
{
fName = fName.Remove(0, XSqlBuilder.OLD_VERSION_PIX.Length);
}
if (!dsSchema.Fields.ContainsId(fName))
{
row.Add("ck", "false");
continue;
}
FieldSchema fldSchema = dsSchema.Fields.GetItem(fName);
if (fldSchema.DataType == DbType.Binary)
{
continue;
}
DataColumn col = tb.Columns[fName];
// if (!string.IsNullOrEmpty(fldSchema.Alias))
// fName = fldSchema.Alias;
//if (col == null)
// throw new Exception(string.Format(Lang.FieldNotFind, fName));
string value = "";
if (col != null)
{
value = GetCellString(fldSchema, col, dRow);
}
row.Add(dcol.field, value);
// if (tb.PrimaryKey.Contains(col))
// {
// row.Add(dcol, value);
//row.Pk.Add(fName, value);
// }
}
return(row);
}
/// <summary>
/// 返回easy ui规范的表格
/// </summary>
/// <returns></returns>
public EasyUiGridData grid()
{
_filterRules = null;
_sorts = null;
_ds = null;
string title = _name;
if (_schema != null && !string.IsNullOrEmpty(_schema.Title))
{
title = _schema.Title;
}
return(EUGridUtils.getGrid(title, _schema.Fields));
}
public EasyUiGridData grid()
{
openFile();
List <FieldDef> fields = new List <FieldDef>();
foreach (ColumnDef field in ColumnMaps)
{
fields.Add(field);
}
EasyUiGridData ret = EUGridUtils.getGrid(_connName, fileName, fields);
ret.url = "ExcelTransfer." + name + ".data.wbo";
ret.filterInputs = null;
return(ret);
}
public List <DataListColumn> columns()
{
// if (_fieldColumns == null || _fieldColumns.Count < 1)
_fieldColumns = EUGridUtils.getColumns(_schema.Fields);
return(_fieldColumns);
}
