{
int count = 0;
SqlConnection conn = new SqlConnection(SqlHelper.ConnectionString);
conn.Open();
SqlTransaction sqlt = conn.BeginTransaction();//通过SqlConnection的BeginTransaction方法创建名为st的对象Transaction
SqlCommand cmd = conn.CreateCommand();
cmd.Transaction = sqlt;//将SqlTransaction对象分配给SqlCommand对象的Transaction属性
try {
foreach (tb_DrawMaterialDetial tb_DrawMaterlaiDetail in tb_DrawMaterlaiDetailList)
{
SqlParameter[] cmdParmsDrawDetail =
{
new SqlParameter(ConstantStorag.SYMBOL_AT + ConstantStorag.TB_DRAWMATERIALDETAIL_DRAWMATERIALID,tb_DrawMaterlaiDetail.DrawMaterialID),
new SqlParameter(ConstantStorag.SYMBOL_AT + ConstantStorag.TB_DRAWMATERIALDETAIL_GOODSID,tb_DrawMaterlaiDetail.GoodsID),
new SqlParameter(ConstantStorag.SYMBOL_AT + ConstantStorag.TB_DRAWMATERIALDETAIL_PRICE,tb_DrawMaterlaiDetail.Price),
new SqlParameter(ConstantStorag.SYMBOL_AT + ConstantStorag.TB_DRAWMATERIALDETAIL_QUANTITY,tb_DrawMaterlaiDetail.Quantity)
};
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = ConstantStorag.PROC_DRAWMATERIALDETAIL_INSERT;
cmd.Parameters.Clear();
if (cmdParmsDrawDetail != null)
{
foreach (SqlParameter parm in cmdParmsDrawDetail)
cmd.Parameters.Add(parm);
}
count = cmd.ExecuteNonQuery();
if (count <= 0)
{
sqlt.Rollback();
return count;
}
}
sqlt.Commit(); //事务提交
}
catch (Exception ex)
{
count = -1;
sqlt.Rollback();//回滚事物
}
return count;
}
count最后返回来的是2,传到页面后提示操作成功,但是去数据库看了下,却是没有数据 希望各位大大能给予帮助
