static public void Insert(SQLiteConnection connection, SQLiteData dataSet, Action <float> percent = null)
{
string defaultCommand = String.Format(Constant._COMMAND_INSERT_INTO, dataSet.SheetName, dataSet.GetColumns());
StringBuilder command = null;
int rowLength = dataSet.Datas.GetLength(0);
int columnLength = dataSet.Columns.Length;
Command(connection, Constant._BEGIN);
for (int j = Constant._ROW_START_INDEX; j <= rowLength; j++)
{
command = new StringBuilder(defaultCommand);
for (int i = 1; i <= columnLength; i++)
{
if (1 != i)
{
command.Append("\', ");
}
command.Append("\'");
dynamic data = dataSet.Datas[j, i];
if (null != data)
{
if (data.GetType() == typeof(string))
{
string stringData = data as string;
stringData = stringData.Replace("\'", "\'\'");
data = stringData;
}
command.Append(data);
}
}
command.Append("\')");
Command(connection, command.ToString());
float lowLength = 0.0f != (float)(rowLength - Constant._ROW_START_INDEX) ? (float)(rowLength - Constant._ROW_START_INDEX) : 1;
percent?.Invoke((j - Constant._ROW_START_INDEX) / lowLength);
}
Command(connection, Constant._COMMIT);
}
