Пример #1
0
 public static bool InsertRows(List <DataRow> rows, bool addRowsToTable)
 {
     if (DataBaseConnector.InserteRecords(rows))
     {
         if (addRowsToTable)
         {
             foreach (var row in rows)
             {
                 row.Table.Rows.Add(row);
             }
         }
         return(true);
     }
     return(false);
 }
Пример #2
0
        public static string InsertTableRows(DataTable sourceTable, string destTableName)
        {
            string    message   = string.Empty;
            DataTable destTable = GetTable(destTableName);
            var       newRows   = new List <DataRow>(sourceTable.Rows.Count);
            var       rowId     = GetNewId(destTableName);

            foreach (DataRow row in sourceTable.Rows)
            {
                try {
                    var decodeRow = KeyValueSwitch.DecodeRow(row, destTable);
                    if (destTable.Columns.Contains("ID"))
                    {
                        decodeRow["ID"] = rowId++;
                    }
                    else
                    {
                        SetNewId(destTableName, decodeRow);
                    }
                    newRows.Add(decodeRow);
                    destTable.Rows.Add(decodeRow);
                } catch (Exception ex) {
                    message += "\n" + ex.Message + " Строка в файле " + sourceTable.Rows.IndexOf(row);
                }
            }
            if (string.IsNullOrEmpty(message))
            {
                try {
                    DataBaseConnector.InserteRecords(newRows);
                    foreach (var row in newRows)
                    {
                        AddRowToTable(destTable, row);
                    }
                } catch (Exception ex) {
                }
            }
            else
            {
                foreach (var row in newRows)
                {
                    destTable.Rows.Remove(row);
                }
            }
            return(message);
        }