Example #1
0
            /// <summary>
            /// Copies properties from data row to typed instance.
            /// </summary>
            /// <param name="src">From: Table data row</param>
            /// <param name="dest">To: typed instance</param>
            internal void CopyFromDataRow(TRow dest, DataRow src)
            {
                object dbValue        = src[Name];
                object attributeValue = (dbValue != DBNull.Value) ? dbValue : null;

                attributeSetter.Invoke(dest, new object[] { attributeValue });
            }
Example #2
0
 public TValue this[TRow row, TColumn column]
 {
     get
     {
         if (table.Rows.Contains(row) && table.Columns.Contains(column))
         {
             return(table.GetValue(row, column));
         }
         else
         {
             throw new ArgumentException("There's no such cell.");
         }
     }
     set
     {
         if (table.Rows.Contains(row) && table.Columns.Contains(column))
         {
             table.SetValue(row, column, value);
         }
         else
         {
             throw new ArgumentException("There's no such cell.");
         }
     }
 }
Example #3
0
 private void AssertIndexExist(TRow row, TColumn column)
 {
     if (!_table.Rows.Any(r => r.Equals(row)) || !_table.Columns.Any(r => r.Equals(column)))
     {
         throw new ArgumentException();
     }
 }
Example #4
0
            public TValue this[TRow row, TColumn column]
            {
                get
                {
                    AssertIndexExist(row, column);

                    if (!_table._values.ContainsKey(row) || !_table._values[row].ContainsKey(column))
                    {
                        return(default(TValue));
                    }

                    return(_table._values[row][column]);
                }
                set
                {
                    AssertIndexExist(row, column);

                    if (!_table._values.ContainsKey(row))
                    {
                        _table._values[row] = new Dictionary <TColumn, TValue>();
                    }

                    _table._values[row][column] = value;
                }
            }
Example #5
0
        /// <summary>
        /// Récupère une ligne du tableau excel du type passé en paramètre de la méthode générique.
        /// </summary>
        /// <typeparam name="TRow">Le type de l'objet de retour.</typeparam>
        /// <returns>Une ligne du fichier excel.</returns>
        public TRow ReadRow <TRow>()
            where TRow : new()
        {
            var row = new TRow();
            var def = BeanDescriptor.GetDefinition(row);

            var initialColumn = _currentCell.ColumnName;
            var emptyCellsNb  = 0;

            /* Parcourt des propriétés du bean. */
            foreach (var propDesc in def.Properties)
            {
                var value = ReadCellCore(propDesc.PrimitiveType);

                // On suppose que la première ligne vide correspond à la fin du document.
                if (value == null)
                {
                    emptyCellsNb++;
                    if (emptyCellsNb == def.Properties.Count)
                    {
                        return(default(TRow));
                    }
                }

                propDesc.SetValue(row, value);

                /* Passe à la colonne suivante. */
                _currentCell = _currentCell.ShiftColumn(1);
            }

            /* On retourne à la cellule initiale de la ligne. */
            _currentCell = _currentCell.ChangeColumn(initialColumn);

            return(row);
        }
Example #6
0
 public virtual void FillValues(TRow row)
 {
     foreach (var setter in _setters)
     {
         setter(row);
     }
 }
Example #7
0
            /// <summary>
            /// Copies properties from typed instance to data row.
            /// </summary>
            /// <param name="dest">To: Table data row</param>
            /// <param name="src">From: typed instance</param>
            internal void CopyToDataRow(DataRow dest, TRow src)
            {
                object attributeValue = attributeGetter.Invoke(src, new object[] { });
                object dbValue        = (attributeValue ?? DBNull.Value);

                dest[Name] = dbValue;
            }
Example #8
0
 public            TRow this[int index]
 {
     get
     {
         DataRow row      = rows[index];
         TRow    typedRow = Extract(row);
         return(typedRow);
     }
 }
Example #9
0
 private static void ReadTr(List<TRow> alRow, TRowType rowType, HtmlElement elParent) {
     TRow row = new TRow();
     row.RowType = rowType;
     foreach (HtmlElement el in elParent.Children) {
         if (String.Compare(el.TagName, "td", true) == 0 || String.Compare(el.TagName, "th", true) == 0) {
             row.Cells.Add(el.InnerText);
         }
     }
     alRow.Add(row);
 }
Example #10
0
            private void CreateIndex(TRow row, TColumn column)
            {
                _table.AddRow(row);
                _table.AddColumn(column);

                if (!_table._values.ContainsKey(row))
                {
                    _table._values[row] = new Dictionary <TColumn, TValue>();
                }
            }
Example #11
0
            /// <summary>
            /// Adds the specified value.
            /// </summary>
            /// <param name="value">The value.</param>
            /// <param name="row">The row.</param>
            public void Add(TValue value, TRow row)
            {
                RowSet rows;

                if (!this.TryGetValue(value, out rows))
                {
                    this[value] = rows = new RowSet();
                }

                rows.Add(row);
            }
Example #12
0
                protected override bool MoveNextCore()
                {
                    Ch.Assert(State != CursorState.Done);
                    var result = _enumerator.MoveNext();

                    _currentRow = result ? _enumerator.Current : null;
                    if (result && _currentRow == null)
                    {
                        throw Ch.Except("Encountered null when iterating over data, this is not supported.");
                    }
                    return(result);
                }
Example #13
0
 public TValue this[TRow row, TColumn column]
 {
     get
     {
         return(table.GetValue(row, column));
     }
     set
     {
         table.AddRow(row);
         table.AddColumn(column);
         table.SetValue(row, column, value);
     }
 }
        public static Dictionary <string, Delegate> GetGetter <TRow>()
            where TRow : IClassWithGetter <TRow>, new()
        {
            var inst   = new TRow();
            var schema = SchemaDefinition.Create(typeof(TRow), SchemaDefinition.Direction.Read);
            var res    = new Dictionary <string, Delegate>();

            for (int i = 0; i < schema.Count; ++i)
            {
                var name = schema[i].ColumnName;
                res[name] = inst.GetGetter(i);
            }
            return(res);
        }
Example #15
0
        private TPage PrepareHeader()
        {
            var header = new TPage();
            var trow   = new TRow();

            header.Groups.Add(new TGroup()
            {
                Rows = new List <TRow>()
                {
                }
            });

            return(header);
        }
Example #16
0
            private static void ReadTr(List <TRow> alRow, TRowType rowType, HtmlElement elParent)
            {
                TRow row = new TRow();

                row.RowType = rowType;
                foreach (HtmlElement el in elParent.Children)
                {
                    if (String.Compare(el.TagName, "td", true) == 0 || String.Compare(el.TagName, "th", true) == 0)
                    {
                        row.Cells.Add(el.InnerText);
                    }
                }
                alRow.Add(row);
            }
Example #17
0
        public void WriteXlsxTest()
        {
            string    file  = AppDomain.CurrentDomain.BaseDirectory + "/ExcelTests/t2.xlsx";
            IExcel    excel = ExcelFactory.CreateDefault();
            DataTable dt    = excel.Read(file, 0, 2);

            DataSet ds = new DataSet();

            ds.Tables.Add(dt);

            TTemplate template = new TTemplate();
            TRow      R1       = new TRow();
            TCell     A        = new TCell("A", "A", 0, 0); A.ColSpan = 2;
            TCell     B        = new TCell("", "B", 0, 2);
            TCell     C        = new TCell("C", "C", 0, 3); C.RowSpan = 2;
            TCell     D        = new TCell("D", "D", 0, 4); D.RowSpan = 2;
            TCell     E        = new TCell("", "E", 0, 5); E.ColSpan = 2;

            R1.Cells.Add(A);
            R1.Cells.Add(B);
            R1.Cells.Add(C);
            R1.Cells.Add(D);
            R1.Cells.Add(E);

            TRow  R2 = new TRow();
            TCell A1 = new TCell("A1", "A1", 1, 0);
            TCell A2 = new TCell("A2", "A2", 1, 1);
            TCell B1 = new TCell("B1", "B1", 1, 2);
            TCell E1 = new TCell("E1", "E1", 1, 5);
            TCell E2 = new TCell("E2", "E2", 1, 6);

            R2.Cells.Add(A1);
            R2.Cells.Add(A2);
            R2.Cells.Add(B1);
            R2.Cells.Add(E1);
            R2.Cells.Add(E2);
            TSheet tsheet = new TSheet();

            tsheet.Name  = "Sheet1";
            tsheet.Title = "表格O";
            tsheet.Head.Rows.Add(R1);
            tsheet.Head.Rows.Add(R2);
            template.Sheets.Add(tsheet);

            string outputFilePath = AppDomain.CurrentDomain.BaseDirectory + "/ExcelTests/out2.xlsx";
            bool   result         = excel.WriteFile(outputFilePath, ds, template);

            Assert.IsTrue(result);
        }
Example #18
0
        public TRow AddFieldsInRow(IWidget[] fields)
        {
            var TRow = new TRow();

            foreach (var f in fields)
            {
                if (AddField(f))
                {
                    var tCol = new TCol(f.WidgetId);

                    TRow.Cols.Add(tCol);
                }
            }

            page.Groups[0].Rows.Add(TRow);

            return(TRow);
        }
Example #19
0
            public TValue this[TRow row, TColumn column]
            {
                get
                {
                    if (!_table._values.ContainsKey(row) || !_table._values[row].ContainsKey(column))
                    {
                        return(default(TValue));
                    }

                    return(_table._values[row][column]);
                }
                set
                {
                    CreateIndex(row, column);

                    _table._values[row][column] = value;
                }
            }
Example #20
0
 public override void FillValues(TRow row)
 {
     Ch.Check(_input.State == CursorState.Good, "Can't fill values: the cursor is not active.");
     base.FillValues(row);
 }
Example #21
0
 public string GetCellValue(TRow row)
 {
     return(this.Pad(this.getCellValue(row).ToString()));
 }
Example #22
0
 public Cursor(IHostEnvironment env, SingleRowLoopDataView <TRow> dataView, Func <int, bool> predicate)
     : base(env, dataView, predicate)
 {
     _currentRow = dataView._current;
 }
Example #23
0
        /// <summary>
        /// Gets a specified portion of the table of <see cref="TcpViewEntry" /> objects that represent a snapshot of the current TCP and/or UDP connections in either IPv4, IPv6 or both. If <paramref name="resolveProtocolNames" /> is set to <see langword="true" />, Protocol names are resolved according to the services file in %systemroot%\drivers\etc\services.
        /// </summary>
        /// <param name="tcp4"><see langword="true" /> to include TCPv4 entries.</param>
        /// <param name="tcp6"><see langword="true" /> to include TCPv6 entries.</param>
        /// <param name="udp4"><see langword="true" /> to include UDPv4 entries.</param>
        /// <param name="udp6"><see langword="true" /> to include UDPv6 entries.</param>
        /// <param name="resolveProtocolNames"><see langword="true" /> to resolve Protocol names according to the services file in %systemroot%\drivers\etc\services.</param>
        /// <returns>
        /// A new <see cref="TcpViewEntry" />[] object with the TCP and/or UDP table in either IPv4, IPv6 or both. If <paramref name="resolveProtocolNames" /> is set to <see langword="true" />, Protocol names are resolved according to the services file in %systemroot%\drivers\etc\services.
        /// </returns>
        public static TcpViewEntry[] GetEntries(bool tcp4, bool tcp6, bool udp4, bool udp6, bool resolveProtocolNames)
        {
            List <TcpViewEntry> entries = new List <TcpViewEntry>();

            if (tcp4)
            {
                entries.AddRange
                (
                    GetConnections <Native.TcpTable, Native.TcpRow>(false, 2)
                    .Select(row => new TcpViewEntry
                {
                    Protocol      = TcpViewEntryProtocol.Tcp4,
                    LocalAddress  = new IPAddress(BitConverter.GetBytes(row.LocalAddress)),
                    LocalPort     = BitConverter.ToUInt16(new[] { row.LocalPort[1], row.LocalPort[0] }, 0),
                    RemoteAddress = new IPAddress(BitConverter.GetBytes(row.RemoteAddress)),
                    RemotePort    = BitConverter.ToUInt16(new[] { row.RemotePort[1], row.RemotePort[0] }, 0),
                    TcpState      = (TcpState)row.State,
                    ProcessId     = (int)row.OwningProcessId
                })
                );
            }
            if (tcp6)
            {
                entries.AddRange
                (
                    GetConnections <Native.Tcp6Table, Native.Tcp6Row>(false, 23)
                    .Select(row => new TcpViewEntry
                {
                    Protocol      = TcpViewEntryProtocol.Tcp6,
                    LocalAddress  = new IPAddress(row.LocalAddress),
                    LocalPort     = BitConverter.ToUInt16(new[] { row.LocalPort[1], row.LocalPort[0] }, 0),
                    RemoteAddress = new IPAddress(row.RemoteAddress),
                    RemotePort    = BitConverter.ToUInt16(new[] { row.RemotePort[1], row.RemotePort[0] }, 0),
                    TcpState      = (TcpState)row.State,
                    ProcessId     = (int)row.OwningProcessId
                })
                );
            }
            if (udp4)
            {
                entries.AddRange
                (
                    GetConnections <Native.UdpTable, Native.UdpRow>(true, 2)
                    .Select(row => new TcpViewEntry
                {
                    Protocol     = TcpViewEntryProtocol.Udp4,
                    LocalAddress = new IPAddress(row.LocalAddress),
                    LocalPort    = BitConverter.ToUInt16(new[] { row.LocalPort[1], row.LocalPort[0] }, 0),
                    ProcessId    = (int)row.OwningProcessId
                })
                );
            }
            if (udp6)
            {
                entries.AddRange
                (
                    GetConnections <Native.Udp6Table, Native.Udp6Row>(true, 23)
                    .Select(row => new TcpViewEntry
                {
                    Protocol     = TcpViewEntryProtocol.Udp6,
                    LocalAddress = new IPAddress(row.LocalAddress),
                    LocalPort    = (int)row.LocalPort,
                    ProcessId    = (int)row.OwningProcessId
                })
                );
            }

            return(entries
                   .Select(entry =>
            {
                entry.LocalProtocolName = ResolvePort(entry.LocalPort, CSharp.EqualsAny(entry.Protocol, TcpViewEntryProtocol.Udp4, TcpViewEntryProtocol.Udp6));
                entry.RemoteProtocolName = entry.RemotePort == null ? null : ResolvePort(entry.RemotePort.Value, CSharp.EqualsAny(entry.Protocol, TcpViewEntryProtocol.Udp4, TcpViewEntryProtocol.Udp6));
                return entry;
            })
                   .ToArray());

            TRow[] GetConnections <TTable, TRow>(bool udp, int version)
            {
                int       bufferSize      = 0;
                FieldInfo numEntriesField = typeof(TTable).GetField("EntryCount");

                GetTable(IntPtr.Zero);
                IntPtr tcpTable = Marshal.AllocHGlobal(bufferSize);

                try
                {
                    if (GetTable(tcpTable) == 0)
                    {
                        TTable table      = Marshal.PtrToStructure <TTable>(tcpTable);
                        int    rowSize    = Marshal.SizeOf <TRow>();
                        uint   entryCount = numEntriesField.GetValue <uint>(table);

                        TRow[] tableRows = new TRow[entryCount];
                        IntPtr ptr       = tcpTable + 4;
                        for (int i = 0; i < entryCount; i++, ptr += rowSize)
                        {
                            tableRows[i] = Marshal.PtrToStructure <TRow>(ptr);
                        }
                        return(tableRows);
                    }
                    else
                    {
                        return(new TRow[0]);
                    }
                }
                finally
                {
                    Marshal.FreeHGlobal(tcpTable);
                }

                uint GetTable(IntPtr table) => udp?Native.GetExtendedUdpTable(table, ref bufferSize, true, version, 1) : Native.GetExtendedTcpTable(table, ref bufferSize, true, version, 5);
            }

            string ResolvePort(int port, bool udp)
            {
                if (resolveProtocolNames)
                {
                    if (ProtocolMap == null)
                    {
                        ProtocolMap = ProtocolMappingEntry.GetProtocolMappingEntries();
                    }
                    return(ProtocolMap.FirstOrDefault(entry => entry.Protocol == (udp ? ProtocolMappingProtocol.Udp : ProtocolMappingProtocol.Tcp) && entry.Port == port)?.Name);
                }
                else
                {
                    return(null);
                }
            }
        }
Example #24
0
 public Cursor(IHostEnvironment env, StreamingDataView <TRow> dataView, Func <int, bool> predicate)
     : base(env, dataView, predicate)
 {
     _enumerator = dataView._data.GetEnumerator();
     _currentRow = null;
 }
        public static TView CreateDefault(IDBEntity Entity, EntityLayoutType layoutType)
        {
            var view = new TView();

            view.Fields = new List <TField>();

            var page = new TPage();

            view.Pages.Add(page);
            var group = new TGroup();

            page.Groups.Add(group);

            var         start_new_r = true;
            List <TCol> col_r       = new List <TCol>();
            var         layoutF     = Entity.GetLayoutFields(EntityLayoutType.Edit);
            int         idx         = 0;

            foreach (var f in layoutF)
            {
                var col = new TCol(f.Name);

                view.Fields.Add(new TField()
                {
                    FieldId = f.Name, Text = f.Text
                });

                if (col_r.Count == 1)
                {
                    start_new_r = true;
                }
                else
                {
                    start_new_r = false;
                }

                if (IsWidgetOnFullRow(f.ControlType))
                {
                    start_new_r = true;

                    var row = new TRow();
                    col.Span = 24;
                    row.Cols = new List <TCol>()
                    {
                        col
                    };

                    group.Rows.Add(row);
                }
                else
                {
                    col_r.Add(col);
                }


                if (start_new_r)
                {
                    var row = new TRow();
                    row.Cols = col_r;
                    group.Rows.Add(row);

                    col_r = new List <TCol>();
                }
                else if (layoutF.Count - 1 == idx)
                {
                    var row = new TRow();
                    row.Cols = col_r;

                    group.Rows.Add(row);
                }
                idx++;
            }

            return(view);
        }
 public Cursor(IChannelProvider provider, SingleRowLoopDataView <TRow> dataView, Func <int, bool> predicate)
     : base(provider, dataView, predicate)
 {
     _currentRow = dataView._current;
 }
 public Cursor(IChannelProvider provider, StreamingDataView <TRow> dataView, Func <int, bool> predicate)
     : base(provider, dataView, predicate)
 {
     _enumerator = dataView._data.GetEnumerator();
     _currentRow = null;
 }
Example #28
0
 public override void FillValues(TRow row)
 {
     Ch.Check(Position >= 0, "Cannot fill values. The cursor is not active.");
     base.FillValues(row);
 }
Example #29
0
 /// <summary>
 /// Constructor
 /// </summary>
 public RowData(TableRowType type, TRow expected, RowDataActualValue actual)
 {
     Type     = type;
     Expected = expected;
     Actual   = actual;
 }
Example #30
0
 /// <summary>
 /// Constructor setting row value.
 /// </summary>
 public RowDataActualValue(TRow value)
 {
     Value     = value;
     Exception = null;
 }
Example #31
0
        public ActionResult Export(int payId)
        {
            PaymentManager pm      = new PaymentManager();
            Payment        payment = pm.LoadPayment(payId);

            #region 动态模板
            TTemplate template = new TTemplate();
            TRow      R1       = new TRow();
            TRow      R2       = new TRow();
            int       index1   = 3;
            int       index2   = 3;
            TCell     A        = new TCell("PersonId", "ID", 0, 0); A.RowSpan = 2; A.Width = 1;
            TCell     B        = new TCell("PersonName", "姓名", 0, 1); B.RowSpan = 2;
            TCell     C        = new TCell("PersonCode", "身份证", 0, 2); C.RowSpan = 2;
            R1.Cells.Add(A);
            R1.Cells.Add(B);
            R1.Cells.Add(C);
            foreach (PayItemDO item in payment.Items)
            {
                TCell cell = new TCell();
                cell.Name    = item.ItemName;
                cell.Caption = item.ItemCaption;
                if (item.IsLeaf == true)
                {
                    //cell.Width = 50;
                }
                if (item.ParentId == 0)
                {
                    cell.RowIndex    = 0;
                    cell.ColumnIndex = index1;
                    int colspan = 1;
                    foreach (PayItemDO pi in payment.Items)
                    {
                        if (pi.ParentId == item.ItemId)
                        {
                            colspan++;
                        }
                    }
                    if (colspan == 1)
                    {
                        cell.RowSpan = 2;
                        index1++;
                        index2++;
                    }
                    else
                    {
                        cell.ColSpan = colspan - 1;
                        index1       = index1 + cell.ColSpan;
                    }
                    R1.Cells.Add(cell);
                }
                else
                {
                    cell.RowIndex    = 1;
                    cell.ColumnIndex = index2;
                    index2           = index2 + 1;
                    R2.Cells.Add(cell);
                }
            }

            TSheet tsheet = new TSheet();
            tsheet.Name  = "Sheet1";
            tsheet.Title = "Sheet1";
            tsheet.Head.Rows.Add(R1);
            tsheet.Head.Rows.Add(R2);
            template.Sheets.Add(tsheet);
            #endregion

            IExcel  excel = ExcelFactory.CreateDefault();
            DataSet ds    = new DataSet();
            payment.DataSource.TableName = "Sheet1";
            ds.Tables.Add(payment.DataSource);
            POIStream stream = new POIStream();
            stream.AllowClose = false;
            excel.Write(stream, template, ds, ExcelExtendType.XLSX);
            stream.AllowClose = true;
            byte[] buffer = new byte[stream.Length];
            stream.Position = 0;
            stream.Read(buffer, 0, buffer.Length);
            stream.Close();

            HttpResponse context = System.Web.HttpContext.Current.Response;
            try
            {
                context.ContentType = "application/ms-excel";
                context.AddHeader("Content-Disposition", string.Format("attachment; filename={0}.xlsx", HttpUtility.UrlEncode(payment.PayTitle, System.Text.Encoding.UTF8)));
                context.BinaryWrite(buffer);
                context.Flush();
                context.End();
            }
            catch (Exception ex)
            {
                context.ContentType = "text/plain";
                context.Write(ex.Message);
            }
            return(null);
        }