public MapForm(ref byte[] bytes, Atlas atlas, string outFilename) { this.atlas = atlas; this.outFilename = outFilename; InitializeComponent(); canvasBox.DoubleBuffered(true); initColors(); EntityTable.Init(entityTable); ColumnTable.Init(columnTable); BlockTexTable.Init(blockTexTable); UnknownTable247264.Init(unknownTable247264); UnknownTable358222.Init(unknownTable358222); data = bytes; findHeightExtremes(); fillEntityTable(); fillColumnTable(); fillBlockTexTable(); fillUnknownTable247264(); fillUnknownTable358222(); draw(); }
public string SetValue(ColumnTable column) { var defaultCode = $"{VarName}.{column.PropertyName}"; var code = string.Empty; if (column.PropertyType.Equals("string")) { code = $"{defaultCode} ?? string.Empty"; } else if (column.PropertyType.Equals("decimal")) { code = column.IsNull ? $"{defaultCode}.HasValue ? (double){defaultCode} : null" : $"(double){defaultCode}"; } else if (column.PropertyType.Equals("DateTime")) { code = column.IsNull ? $"{defaultCode}.HasValue ? {defaultCode}.Value.ToString(\"yyyy-MM-dd\") : null" : $"{defaultCode}.ToString(\"yyyy-MM-dd\")"; } else { code = $"{defaultCode} ?? string.Empty"; } return(code); }
/// <summary> /// Створює коллекцію лінійних обектів таблиці. /// </summary> /// <param name="numberRows">Кількість рядків таблиці.</param> /// <param name="stepRows">Крок рядків таблиці.</param> /// <param name="settingTable">Налаштування таблиці.</param> /// <returns> /// Повертає <see cref="T:AcDb.DBObjectCollection"/>, що містить лінійні обекти таблиці. /// </returns> internal static AcDb.DBObjectCollection GetBoundTable(int numberRows, double stepRows, SettingTable settingTable) { AcDb.DBObjectCollection objects = new AcDb.DBObjectCollection(); double hTable = settingTable.GetHeightTable(numberRows, stepRows) * -1; double wTable = settingTable.GetWidthTable(); AcGe.Point2dCollection pointsBoundTable = new AcGe.Point2dCollection(new AcGe.Point2d[] { settingTable.BasePointDrawing.Convert2d(new AcGe.Plane()) .Add(new AcGe.Vector2d(0, 0)), settingTable.BasePointDrawing.Convert2d(new AcGe.Plane()) .Add(new AcGe.Vector2d(wTable, 0)), settingTable.BasePointDrawing.Convert2d(new AcGe.Plane()) .Add(new AcGe.Vector2d(wTable, hTable)), settingTable.BasePointDrawing.Convert2d(new AcGe.Plane()) .Add(new AcGe.Vector2d(0, hTable)) }); objects.Add(ServiceSimpleElements.CreatePolyline2d(pointsBoundTable, true)); AcGe.Point2dCollection pointsLine = new AcGe.Point2dCollection(new AcGe.Point2d[] { settingTable.BasePointDrawing.Convert2d(new AcGe.Plane()) .Add(new AcGe.Vector2d(wTable, settingTable.GetHeightCapTable() * -1)), settingTable.BasePointDrawing.Convert2d(new AcGe.Plane()) .Add(new AcGe.Vector2d(0, settingTable.GetHeightCapTable() * -1)) }); objects.Add(ServiceSimpleElements.CreatePolyline2d(pointsLine, false)); double widthCur = 0; for (int i = 0; i < settingTable.Columns.Count - 1; i++) { ColumnTable value = settingTable.Columns.ToArray()[i]; widthCur += value.Width; pointsLine = new AcGe.Point2dCollection(new AcGe.Point2d[] { settingTable.BasePointDrawing.Convert2d(new AcGe.Plane()) .Add(new AcGe.Vector2d(widthCur, 0)), settingTable.BasePointDrawing.Convert2d(new AcGe.Plane()) .Add(new AcGe.Vector2d(widthCur, hTable)) }); objects.Add(ServiceSimpleElements.CreatePolyline2d(pointsLine, false)); } return(objects); }
void dt_ColumnChanged(object sender, DataColumnChangeEventArgs e) { if (!ColumnTable.ContainsKey(e.Column)) { return; } if (!RowTable.ContainsKey(e.Row)) { return; } int?newValue = null; int nv = 0; if (int.TryParse(e.ProposedValue.ToString(), out nv)) { newValue = nv; } if (newValue.HasValue) { if (newValue > GameService.MaxValue(Stage, RowTable[e.Row]) || newValue < GameService.MinValue(Stage, RowTable[e.Row])) { newValue = null; } } if (!newValue.HasValue) { e.Row.SetColumnError(e.Column, "Неправильное значение"); } else { e.Row.SetColumnError(e.Column, ""); } var c = ColumnTable[e.Column]; var gameResult = GameService.DbContext.GameResultSet.First(f => f.Game.Stage.Id == Stage.Id && f.Referee.Id == c.Id && f.Game.Team.Id == CurrentTeam.Id); var value = gameResult.Values.FirstOrDefault(f => f.Type == RowTable[e.Row]); if (value == null) { GameService.DbContext.GameResultValueSet.Add(new GameResultValue() { GameResult = gameResult, Type = RowTable[e.Row], Value = newValue }); } else { value.Value = newValue; } }
object _Normalise(int columnIndex, object obj, bool normalise) { object ret = null; if (ColumnTable.TryGetValue(columnIndex, out var norm)) { double val; switch (norm.DataType) { case ColumnType.Byte: val = (sbyte)obj; break; case ColumnType.Double: val = (double)obj; break; case ColumnType.Float: val = (float)obj; break; case ColumnType.Int: val = (int)obj; break; case ColumnType.Long: val = (long)obj; break; default: throw new NotImplementedException(); } ret = normalise ? norm.Normalise(val) : norm.ReverseNormalise(val); } else if (VectorColumnTable != null && VectorColumnTable.TryGetValue(columnIndex, out var vectorNorm)) { var vector = (FloatVector)obj; var normalised = vector.Data.Zip(vectorNorm.VectorColumns, (v, n) => (float)n.Normalise(Convert.ToDouble(v))).ToArray(); ret = new FloatVector { Data = normalised }; } else { ret = obj; } return(ret); }
private void editColumnButton_Click(object sender, EventArgs e) { ColumnItem item = columnTable.SelectedItems[0].Tag as ColumnItem; EditItemForm f = new EditItemForm(item); if (f.ShowDialog(this) == System.Windows.Forms.DialogResult.None) { return; } item.UpdateCaptions(); ColumnTable.Write(columnItems, ref data); writeButton.Enabled = true; }
private void lvTables_SelectedIndexChanged(object sender, EventArgs e) { try { OpenConn(AccessConnString); object[] objArrRestrict; if (lvTables.SelectedItem != null) { string TableName = lvTables.SelectedItem.ToString(); //Object to Specify which Table to look inside of objArrRestrict = new object[] { null, null, TableName, null }; //Get the Table Schema DataTable schemaCols = Conn.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, objArrRestrict); //declare a Hashtable for the Column Data //Hashtable htCols = new Hashtable(); //List the schema info for the selected table ColumnTableList.Clear(); int i = 1; foreach (DataRow fieldrow in schemaCols.Rows) { ColumnTable info = new ColumnTable(); info.TableName = fieldrow["TABLE_NAME"].ToString(); info.ColumnName = fieldrow["COLUMN_NAME"].ToString(); info.TypeName = fieldtypename(int.Parse(fieldrow["DATA_TYPE"].ToString())); string length = fieldrow["CHARACTER_MAXIMUM_LENGTH"].ToString(); info.ColumnLength = string.IsNullOrWhiteSpace(length) ? 0 : Convert.ToInt32(length); info.IsNull = Convert.ToBoolean(fieldrow["IS_NULLABLE"].ToString()); if (i == 1) { info.Key = true; } else { info.Key = false; } ColumnTableList.Add(info); i++; } } } catch (Exception ex) { MessageBox.Show(ex.Message + "\n" + ex.StackTrace); } }
public string GetValue(ColumnTable column) { var defaultCode = $"rs.Fields.Item(\"{column.SqlColumnName}\").Value"; var defaultCodeFull = $"{column.PropertyType}.Parse({defaultCode}.ToString())"; var code = string.Empty; if (column.PropertyType.Equals("string")) { code = $"{defaultCode}.ToString() ?? string.Empty"; } else { code = column.IsNull ? $"{defaultCode} == null ? null : {defaultCodeFull}" : $"{defaultCodeFull}"; } return(code); }
public ColumnTableScript(ColumnTable columnTable, SqlPreCommandSimple updateScript) { ColumnTable = columnTable; UpdateScript = updateScript; }
private void fillColumnTable() { columnItems = ColumnTable.Fill(columnTable, ref data, ref lineColors, ref pointColors); columnTableInfo.Text = columnItems.Count + " items found"; }
private bool saveConfig() { try { if (!verifyInfo()) { return(false); } if (!varifySet(txtSet.Text)) { return(false); } pTable.TableSet = txtSet.Text; SqlBaseProvider.SaveTableSet(pTable); List <ColumnTable> cols = new List <ColumnTable>(); foreach (PdmColumn pColumn in pTable.Columns) { ColumnTable col = new ColumnTable(); col.DBID = pTable.DBID; col.TableCode = pTable.TableCode; col.ColumnCode = pColumn.ColumnCode; col.ColumnSerial = 0; col.Prefix = Prefix[0]; col.RelaTable = pTable.TableCode; col.DisplayColumn = pColumn.ColumnCode; col.RelaColumn = pColumn.ColumnCode; cols.Add(col); } string[] tablesets = PublicTools.TextReadToArr(txtSet.Text); int prefixcnt = 1; int i = 0; int j = 0; foreach (string tableset in tablesets) { string[] sets = tableset.Split('|'); if (sets[0].ToLower() == "c") { SqlBaseProvider.SavePmtSet(pTable.DBID, tableset); string[] relacols = sets[4].Split(','); for (i = relacols.Length - 1; i >= 0; i--) { ColumnTable col = new ColumnTable(); col.DBID = pTable.DBID; col.TableCode = pTable.TableCode; col.ColumnCode = sets[1]; col.ColumnSerial = 0; col.Prefix = Prefix[prefixcnt]; col.RelaTable = sets[2]; col.DisplayColumn = relacols[i]; col.RelaColumn = sets[3]; for (j = 0; j < cols.Count; j++) { if (cols[j].ColumnCode.ToLower() == col.ColumnCode.ToLower()) { cols.Insert(j + 1, col); break; } } } prefixcnt++; } } SqlBaseProvider.SaveColumnTable(pTable, cols); return(true); } catch (Exception) { throw; } }