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行即提示标题内容,报错无法执行。
望各位大虾不吝赐教
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行即提示标题内容,报错无法执行。
望各位大虾不吝赐教
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货