StringBuilder strSql = new StringBuilder(" delete from tb_BOMTwo where productSpecs  =@Dep_Name ");
            List<SqlParameter> sqlParsList = new List<SqlParameter>();
            sqlParsList.Add(new SqlParameter("@Dep_Name", SqlDbType.VarChar, 255));
            sqlParsList[sqlParsList.Count - 1].Value = productSpecs;
            for (int i = 0; i < modelList.Count; i++)
            {
                strSql.Append("insert into tb_BOMTwo(");
                strSql.Append("productSpecs,goodsName,goodsSpecs,makeWhere,useNum,unit,fudu,fuduTwo,shunhaolv,chicun,realUses,re,yanSe,dianYa,reYa,dianYaXiYin,xiYin,ciXiu,beiHu,youBian,EVAcx,EVAth,qieBang,cangJian,dianJianPJ,renGePJ,baoGu,dianNaoChe,pingChe,maiXiang,daDing,baoZhuang,xh,weiTiao,wlmc,baoTX,handType,pczz,pccx,jiaGSM,notUse)");
                strSql.Append(" values (");
                strSql.Append("@productSpecs").Append(i.ToString());
                strSql.Append(",@goodsName").Append(i.ToString());
                strSql.Append(",@goodsSpecs").Append(i.ToString());
                strSql.Append(",@makeWhere").Append(i.ToString());
                strSql.Append(",@useNum").Append(i.ToString());
                strSql.Append(",@unit").Append(i.ToString());
                strSql.Append(",@fudu").Append(i.ToString());
                strSql.Append(",@fuduTwo").Append(i.ToString());
                strSql.Append(",@shunhaolv").Append(i.ToString());
                strSql.Append(",@chicun").Append(i.ToString());
                strSql.Append(",@realUses").Append(i.ToString());
                strSql.Append(",@re").Append(i.ToString());
                strSql.Append(",@yanSe").Append(i.ToString());
                strSql.Append(",@dianYa").Append(i.ToString());
                strSql.Append(",@reYa").Append(i.ToString());
                strSql.Append(",@dianYaXiYin").Append(i.ToString());
                strSql.Append(",@xiYin").Append(i.ToString());
                strSql.Append(",@ciXiu").Append(i.ToString());
                strSql.Append(",@beiHu").Append(i.ToString());
                strSql.Append(",@youBian").Append(i.ToString());
                strSql.Append(",@EVAcx").Append(i.ToString());
                strSql.Append(",@EVAth").Append(i.ToString());
                strSql.Append(",@qieBang").Append(i.ToString());
                strSql.Append(",@cangJian").Append(i.ToString());
                strSql.Append(",@dianJianPJ").Append(i.ToString());
                strSql.Append(",@renGePJ").Append(i.ToString());
                strSql.Append(",@baoGu").Append(i.ToString());
                strSql.Append(",@dianNaoChe").Append(i.ToString());
                strSql.Append(",@pingChe").Append(i.ToString());
                strSql.Append(",@maiXiang").Append(i.ToString());
                strSql.Append(",@daDing").Append(i.ToString());
                strSql.Append(",@baoZhuang").Append(i.ToString());
                strSql.Append(",@xh").Append(i.ToString());
                strSql.Append(",@weiTiao").Append(i.ToString());
                strSql.Append(",@wlmc").Append(i.ToString());
                strSql.Append(",@baoTX").Append(i.ToString());
                strSql.Append(",@handType").Append(i.ToString());
                strSql.Append(",@pczz").Append(i.ToString());
                strSql.Append(",@pccx").Append(i.ToString());
                strSql.Append(",@jiaGSM").Append(i.ToString());
                strSql.Append(",@notUse").Append(i.ToString());
                strSql.Append(")");                SqlParameter[] parameters = {
new SqlParameter("@productSpecs"+i.ToString(), SqlDbType.VarChar,255),
new SqlParameter("@goodsName"+i.ToString(), SqlDbType.VarChar,50),
new SqlParameter("@goodsSpecs"+i.ToString(), SqlDbType.VarChar,50),
new SqlParameter("@makeWhere"+i.ToString(), SqlDbType.VarChar,50),
new SqlParameter("@useNum"+i.ToString(), SqlDbType.Int,4),
new SqlParameter("@unit"+i.ToString(), SqlDbType.VarChar,50),
new SqlParameter("@fudu"+i.ToString(), SqlDbType.Decimal,9),
new SqlParameter("@fuduTwo"+i.ToString(), SqlDbType.VarChar,50),
new SqlParameter("@shunhaolv"+i.ToString(), SqlDbType.Decimal,9),
new SqlParameter("@chicun"+i.ToString(), SqlDbType.VarChar,50),
new SqlParameter("@realUses"+i.ToString(), SqlDbType.Decimal,9),
new SqlParameter("@re"+i.ToString(), SqlDbType.VarChar,255),
new SqlParameter("@yanSe"+i.ToString(), SqlDbType.VarChar,50),
new SqlParameter("@dianYa"+i.ToString(), SqlDbType.Bit,1),
new SqlParameter("@reYa"+i.ToString(), SqlDbType.Bit,1),
new SqlParameter("@dianYaXiYin"+i.ToString(), SqlDbType.Bit,1),
new SqlParameter("@xiYin"+i.ToString(), SqlDbType.Bit,1),
new SqlParameter("@ciXiu"+i.ToString(), SqlDbType.Bit,1),
new SqlParameter("@beiHu"+i.ToString(), SqlDbType.Bit,1),
new SqlParameter("@youBian"+i.ToString(), SqlDbType.Bit,1),
new SqlParameter("@EVAcx"+i.ToString(), SqlDbType.Bit,1),
new SqlParameter("@EVAth"+i.ToString(), SqlDbType.Bit,1),
new SqlParameter("@qieBang"+i.ToString(), SqlDbType.Bit,1),
new SqlParameter("@cangJian"+i.ToString(), SqlDbType.Bit,1),
new SqlParameter("@dianJianPJ"+i.ToString(), SqlDbType.Bit,1),
new SqlParameter("@renGePJ"+i.ToString(), SqlDbType.Bit,1),
new SqlParameter("@baoGu"+i.ToString(), SqlDbType.Bit,1),
new SqlParameter("@dianNaoChe"+i.ToString(), SqlDbType.Bit,1),
new SqlParameter("@pingChe"+i.ToString(), SqlDbType.Bit,1),
new SqlParameter("@maiXiang"+i.ToString(), SqlDbType.Bit,1),
new SqlParameter("@daDing"+i.ToString(), SqlDbType.Bit,1),
new SqlParameter("@baoZhuang"+i.ToString(), SqlDbType.Bit,1),
new SqlParameter("@xh"+i.ToString(), SqlDbType.VarChar,50),
new SqlParameter("@weiTiao"+i.ToString(), SqlDbType.Bit,1),
new SqlParameter("@wlmc"+i.ToString(), SqlDbType.VarChar,255),
new SqlParameter("@baoTX"+i.ToString(), SqlDbType.Bit,1),
new SqlParameter("@handType"+i.ToString(), SqlDbType.Bit,1),
new SqlParameter("@pczz"+i.ToString(), SqlDbType.Bit,1),
new SqlParameter("@pccx"+i.ToString(), SqlDbType.Bit,1),
new SqlParameter("@jiaGSM"+i.ToString(), SqlDbType.VarChar,255),
new SqlParameter("@notUse"+i.ToString(), SqlDbType.Bit,1)};
                parameters[0].Value = modelList[i].productSpecs;
                parameters[1].Value = modelList[i].goodsName;
                parameters[2].Value = modelList[i].goodsSpecs;
                parameters[3].Value = modelList[i].makeWhere;
                parameters[4].Value = modelList[i].useNum;
                parameters[5].Value = modelList[i].unit;
                parameters[6].Value = modelList[i].fudu;
                parameters[7].Value = modelList[i].fuduTwo;
                parameters[8].Value = modelList[i].shunhaolv;
                parameters[9].Value = modelList[i].chicun;
                parameters[10].Value = modelList[i].realUses;
                parameters[11].Value = modelList[i].re;
                parameters[12].Value = modelList[i].yanSe;
                parameters[13].Value = modelList[i].dianYa;
                parameters[14].Value = modelList[i].reYa;
                parameters[15].Value = modelList[i].dianYaXiYin;
                parameters[16].Value = modelList[i].xiYin;
                parameters[17].Value = modelList[i].ciXiu;
                parameters[18].Value = modelList[i].beiHu;
                parameters[19].Value = modelList[i].youBian;
                parameters[20].Value = modelList[i].EVAcx;
                parameters[21].Value = modelList[i].EVAth;
                parameters[22].Value = modelList[i].qieBang;
                parameters[23].Value = modelList[i].cangJian;
                parameters[24].Value = modelList[i].dianJianPJ;
                parameters[25].Value = modelList[i].renGePJ;
                parameters[26].Value = modelList[i].baoGu;
                parameters[27].Value = modelList[i].dianNaoChe;
                parameters[28].Value = modelList[i].pingChe;
                parameters[29].Value = modelList[i].maiXiang;
                parameters[30].Value = modelList[i].daDing;
                parameters[31].Value = modelList[i].baoZhuang;
                parameters[32].Value = modelList[i].xh;
                parameters[33].Value = modelList[i].weiTiao;
                parameters[34].Value = modelList[i].wlmc;
                parameters[35].Value = modelList[i].baoTX;
                parameters[36].Value = modelList[i].handType;
                parameters[37].Value = modelList[i].pczz;
                parameters[38].Value = modelList[i].pccx;
                parameters[39].Value = modelList[i].jiaGSM;
                parameters[40].Value = modelList[i].notUse;
                foreach (SqlParameter par in parameters)
                {
                    sqlParsList.Add(par);
                }
            }
            return DbHelperSQL.ExecuteNonQuery(true, false, strSql.ToString(), sqlParsList);异常描述,上诉代码在我系统中的插入的行数为51行以下均可顺利通过,超过51行即提示标题内容,报错无法执行。
望各位大虾不吝赐教