public DbCommand GetInsertCommand(object[] parameters)
{
if (TYPE != TableSchamaType.TABLE)
{
return(null);
}
if (_schama.Count <= 0)
{
return(null);
}
var sb_param = new StringBuilder();
var lst_params = new List <DbParameter>();
var items = _schama.OrderBy(itm => itm.ColumnOrdinal);
foreach (var item in items)
{
if (item.ColumnOrdinal >= parameters.Length)
{
break;
}
if (sb_param.Length > 0)
{
sb_param.Append(",");
}
var parameter = DBAccessor.CreateParameter(string.Format("COL{0}", item.ColumnOrdinal), parameters[item.ColumnOrdinal]);
sb_param.Append(parameter.ParameterName);
lst_params.Add(parameter);
}
var sql = string.Format(SQL_INSERT_1, TableName, sb_param.ToString());
return(DBAccessor.CreateCommand(sql, lst_params.ToArray()));
}
