stringbuilder实现
1、
StringBuilder sb = new StringBuilder();
sb.Append("begin");
for (int j = 0; j<dt.Rows.Count;j++)
{
//改成动态语句
//SEQ_CQRC.netval意思是数据库中id系统自动加1,(在sequence中新建,编辑自动字段加1)
sb.Append("EXECUTE IMMEDIATE 'insert into MES_CQRC (id,task_no,boxcode,mzccode,rel_barcode1,cell_type,users,create_data) values (SEQ_CQRC.netval,'"
+ "|| ' ''" + dt.Rows[j][0].ToString() + "'','"
+ "|| ' ''" + dt.Rows[j][1].ToString() + "'','"
+ "|| ' ''" + dt.Rows[j][2].ToString() + "'','"
+ "|| ' ''" + dt.Rows[j][3].ToString() + "'','"
+ "|| ' ''" + dt.Rows[j][4].ToString() + "'','"
+ "|| ' ''" + user + "'','"
+ "|| ' sysdate)';"
);
}
sb.Append(" end;");
ocmd.CommandText = sb.ToString();
ocmd.ExecuteNonQuery();
2、
利用SQLHelper,用法见链接
[https://www.tnblog.net/77250798/article/details/2630]