INSERT INTO iv_invoicehead(DJBH,SHR,DPJC,ZFJE,FPTT,CKMC,CreateTime)
Values('DD00102637','俞继红','21克天猫旗舰店','299.0000','俞继红','正品仓',NOW());
SET @v_ID = last_insert_id();
INSERT INTO iv_invoiceitems(HeadID,SPDM,SPMC,SJDJ,SJJE,BZJE,ZK,SL,BZ,ZL,HJZL)
Values(@v_ID,'c.f.03.100.01.01','[mc001s] 官方标配 白色标准版','299.0000','299.0000','498.0000','0.6004','1.0000',' 组合商品:c.f.03 mc001s(白色标准版)','450.0000','450.0000');
提示错误:
记录时间:2014-10-13 17:02:43,852
线程ID:[14]
日志级别: ERROR
出错类:_21KE.MySql.MySqlHelper property: [(null)] -
错误描述:Error
MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Parameter '@v_ID' must be defined.
在 MySql.Data.MySqlClient.Statement.SerializeParameter(MySqlParameterCollection parameters, MySqlPacket packet, String parmName, Int32 parameterIndex)
在 MySql.Data.MySqlClient.Statement.InternalBindParameters(String sql, MySqlParameterCollection parameters, MySqlPacket packet)
在 MySql.Data.MySqlClient.Statement.BindParameters()
在 MySql.Data.MySqlClient.PreparableStatement.Execute()
在 MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
在 MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
在 MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
在 _21KE.MySql.MySqlHelper.ExecuteNonQuery(MySqlTransaction trans, CommandType cmdType, String cmdText, MySqlParameter[] commandParameters) 位置 C:\Users\lenovo\documents\visual studio 2010\Projects\21KeInvoicePrint\21KE.MySql\MySqlHelper.cs:行号 71