public ActionResult FormSubmit()
{
BaseDataBaseBll Basedatabasebll = new BaseDataBaseBll();
StringBuilder sb = new StringBuilder();
StringBuilder values = new StringBuilder("(");
DataTable dt = Basedatabasebll.GetColumnList("TestTable");
List <DbParameter> parameter = new List <DbParameter>();
sb.Append("INSERT INTO TestTable (");
foreach (DataRow dr in dt.Rows)
{
string filed = dr["column"].ToString();
parameter.Add(DbFactory.CreateDbParameter($"@{filed}", Request.Form[$"Build_{filed}"]));
sb.Append($"[{filed}],");
values.Append($"@{filed},");
}
sb.Append(") values");
values.Append(")");
base.Repositoryfactory.Repository().ExecuteBySql(sb.Append(values).Replace(",)", ")"), parameter.ToArray());
Console.WriteLine(parameter);
return(Content("xxxxxxxxxxxxxxxxxxx"));
}
