public static ColumnEditKeySchema GetTableForeignSchema(string SchemaName, string tableName) { MySqlParameter[] prams = new MySqlParameter[] { new MySqlParameter("?tableName", tableName) }; DataTable dataTable = SqlSchemaHelper.CodeSqlHelper.ExecuteDataTable(Resources.GetTableForeign, CommandType.Text, prams, ""); ColumnEditKeySchema result; if (dataTable.Rows.Count > 0) { foreach (DataRow dataRow in SqlSchemaHelper.GetTableColumns(SchemaName, tableName, "").Rows) { if (dataRow["FieldName"].ToString() == dataTable.Rows[0]["ForeignColumnName"].ToString() && dataTable.Rows[0]["PrimaryTableName"].ToString() != tableName) { result = new ColumnEditKeySchema { FieldName = dataRow["FieldName"].ToString(), DateType = dataRow["DataType"].ToString() }; return(result); } } result = null; } else { result = null; } return(result); }
public static ColumnEditKeySchema GetTablePrimarySchema(string SchemaName, string tableName) { ColumnEditKeySchema result; foreach (DataRow dataRow in SqlSchemaHelper.GetTableColumns(SchemaName, tableName, "").Rows) { if (dataRow["FieldName"].ToString() == dataRow["TableKey"].ToString()) { result = new ColumnEditKeySchema { FieldName = dataRow["FieldName"].ToString(), DateType = dataRow["DataType"].ToString() }; return(result); } } result = null; return(result); }