internal List <DataListColumn> getTableColumns(string tableName) { List <DataListColumn> ret = new List <DataListColumn>(); TableDef tableDef = dbAdmin.getTableDef(tableName); int i = 0; foreach (FieldDef field in tableDef.FieldDefs) { i++; if (i > DataSourceConst.MaxCol) { break; } DataListColumn col = new DataListColumn(); col.field = field.Name; col.title = field.Alias; if (string.IsNullOrEmpty(col.title)) { col.title = field.Name; } col.resizable = true; col.sortable = true; ret.Add(col); } return(ret); }
internal static List <FilterRule> getTableFilters(string name) { string[] ary = name.Split(','); string conn = ""; string tbName = name; if (ary.Length > 1) { conn = ary[0]; tbName = ary[1]; } DatabaseAdmin dba = DatabaseAdmin.getInstance(conn); TableDef tbDef = dba.getTableDef(tbName); List <FilterRule> ret = new List <FilterRule>(); foreach (FieldDef fldDef in tbDef.FieldDefs) { FilterRule fr = new FilterRule(); fr.field = fldDef.Name; ret.Add(fr); } return(ret); }
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 string getPrimaryKey(string connName, string tableName) { if (string.IsNullOrEmpty(tableName)) { return(""); } DatabaseAdmin dba = DatabaseAdmin.getInstance(connName); TableDef tbDef = dba.getTableDef(tableName); return(tbDef.MainKeys[0].Name); }
public static Dictionary <string, string> getFields(string connName, string tableName) { Dictionary <string, string> ret = new Dictionary <string, string>(); if (string.IsNullOrEmpty(tableName)) { return(ret); } DatabaseAdmin dba = DatabaseAdmin.getInstance(connName); TableDef tbDef = dba.getTableDef(tableName); ret.Add("", ""); foreach (FieldDef field in tbDef.FieldDefs) { string title = string.IsNullOrEmpty(field.Title) ? field.Name : field.Title; ret.Add(field.Name, title); } return(ret); }
private static void BuildFields(DataSourceSchema schema) { string connectionName = schema.ConnectionName; string selectSql = schema.SelectCommand.CommandText; DatabaseAdmin dbAdmin = DatabaseAdmin.getInstance(connectionName); XSql xSql = new XSql(selectSql); string tableName = xSql.GetFrom(); // schema.Fields.Clear(); SchemaList <FieldSchema> tmpfs = new SchemaList <FieldSchema>(); DbConnection con = dbAdmin.Database.CreateConnection(); try { DataTable netTable = new DataTable(); DbDataAdapter da = dbAdmin.Database.GetDataAdapter(); DbCommand cmd = con.CreateCommand(); cmd.CommandText = selectSql; string[] paramNames = xSql.GetParamNames(); for (int i = 0; i < paramNames.Count(); i++) { string pName = paramNames[i]; if (!string.IsNullOrEmpty(pName)) { pName = pName.Trim(); } SqlParameter p = new SqlParameter(); p.ParameterName = "@" + pName; //p.SourceColumn = pName; p.Value = ""; cmd.Parameters.Add(p); } da.SelectCommand = cmd; da.Fill(netTable); //da.FillSchema(netTable, SchemaType.Source); foreach (DataColumn col in netTable.Columns) { FieldSchema field = new FieldSchema(); field.Id = col.ColumnName; field.DisplayName = col.Caption; // schema.Fields.Add(field); if (schema.Fields.FindItem(field.Id) == null) { schema.Fields.Add(field); } if (tmpfs.FindItem(field.Id) == null) { tmpfs.Add(field); } } //从原是表中获取,字段标题等信息; if (xSql.IsFromSourceTable(tableName)) { List <string> pks = dbAdmin.GetPrimaryKeys(tableName); schema.KeyField = JsonConvert.SerializeObject(pks); //if (pks.Count > 0) // keyfield = pks[0]; //if (!string.IsNullOrEmpty(keyfield)) // schema.KeyField = keyfield; var tbName = tableName.Trim('[', ']'); List <FieldDef> fieldDefs = dbAdmin.getTableDef(tbName).FieldDefs; for (int i = 0; i < fieldDefs.Count; i++) { FieldDef fieldDef = fieldDefs[i]; FieldSchema field = schema.Fields.FindItem(fieldDef.Name); // field.Id =; if (field != null) { field.IsKey = pks.Contains(field.Id); field.DisplayName = fieldDef.Alias;//未用 if (string.IsNullOrEmpty(field.Title)) { field.Title = fieldDef.Alias; } if (fieldDef.IsIdentity) { field.IsAutoInc = true; } } // if (field == null) // schema.Fields.Add(field); // if (tmpfs.FindItem(field.Id) == null) // tmpfs.Add(field); } } //删除不存在的字段 for (int i = schema.Fields.Count - 1; i >= 0; i--) { FieldSchema fld = schema.Fields[i]; FieldSchema newFld = tmpfs.FindItem(fld.Id); if (newFld == null) { schema.Fields.Remove(fld); } } } finally { con.Close(); } }
public static TableDef getTableDef(string connName, string tableName) { DatabaseAdmin da = DatabaseAdmin.getInstance(connName); return(da.getTableDef(tableName)); }
internal static DataSet getSourceDataSet(string dsName, string where, string orderBy, PaginationInfo pi) { if (string.IsNullOrEmpty(dsName)) { throw new XException(Lang.DataSourceNameIsNull); } string connName = ""; string tableName = dsName; string[] namePath = dsName.Split('.'); if (namePath.Length > 1) { connName = namePath[0]; tableName = namePath[1]; } DatabaseAdmin dba = DatabaseAdmin.getInstance(connName); Database db = dba.Database; List <string> pks = dba.GetPrimaryKeys(tableName); DbCommand cmd = null; if (!dba.ExistsSp(DataSourceConst.PaginationSpName)) { dba.modifyProc(DataSourceConst.PaginationSpName, DataSourceConst.PaginationSpText); } if (pks.Count() == 1) { pi.isStoreProcessPagination = true; cmd = db.GetStoredProcCommand(DataSourceConst.PaginationSpName); cmd.CommandType = CommandType.StoredProcedure; db.AddInParameter(cmd, "@TableName", DbType.String, tableName); db.AddInParameter(cmd, "@PrimaryKey", DbType.String, pks[0]); db.AddInParameter(cmd, "@PageNo", DbType.Int32, pi.page); db.AddInParameter(cmd, "@PageSize", DbType.Int32, pi.pageSize); db.AddInParameter(cmd, "@Where", DbType.String, where); db.AddOutParameter(cmd, "@PageCount", DbType.Int32, sizeof(Int32)); db.AddOutParameter(cmd, "@Total", DbType.Int32, sizeof(Int32)); } else { pi.isStoreProcessPagination = false; StringBuilder sbSql = new StringBuilder(); sbSql.Append("Select * From "); sbSql.Append(tableName); if (!string.IsNullOrEmpty(where)) { sbSql.Append(" Where "); sbSql.Append(where); } if (!string.IsNullOrEmpty(orderBy)) { sbSql.Append(" Order By "); sbSql.Append(orderBy); } cmd = db.GetSqlStringCommand(sbSql.ToString()); } DataSet ds = db.ExecuteDataSet(cmd); TableDef tableDef = dba.getTableDef(tableName); DataTable table = ds.Tables[0]; foreach (FieldDef fieldDef in tableDef.FieldDefs) { if (string.IsNullOrEmpty(fieldDef.Alias)) { continue; } table.Columns[fieldDef.Name].Caption = fieldDef.Alias; } if (pi.isStoreProcessPagination) { pi.pageCount = (int)cmd.Parameters["@PageCount"].Value; pi.total = (int)cmd.Parameters["@Total"].Value; } else { pi.total = table.Rows.Count; pi.pageCount = pi.total / pi.pageSize; if (pi.total % pi.pageSize != 0) { pi.pageCount++; } } return(ds); }