**************************mima_b2b_Login()2022/5/21 0:56:37************************* paramter0:1026 paramter1:oDppT5J3ZeS9tTZkyrHTJm3KvvrI Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-05-21 00:56:37 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1026' or a.login_no = '1026' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1026","vip_pass":"1026","is_bind":"1","open_id":"oDppT5J3ZeS9tTZkyrHTJm3KvvrI"} ************************************************************************************** **************************mima_b2b_Login()2022/5/21 0:56:57************************* paramter0:10026 paramter1:oDppT5J3ZeS9tTZkyrHTJm3KvvrI Api.Helper.Exceptions.KatException: 用户不存在 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-05-21 00:56:57 [错误信息] => 用户不存在 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '10026' or a.login_no = '10026' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"10026","vip_pass":"10026","is_bind":"1","open_id":"oDppT5J3ZeS9tTZkyrHTJm3KvvrI"} ************************************************************************************** **************************mima_b2b_Login()2022/5/21 0:57:01************************* paramter0:10026 paramter1:oDppT5J3ZeS9tTZkyrHTJm3KvvrI Api.Helper.Exceptions.KatException: 用户不存在 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-05-21 00:57:01 [错误信息] => 用户不存在 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '10026' or a.login_no = '10026' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"10026","vip_pass":"10026","is_bind":"1","open_id":"oDppT5J3ZeS9tTZkyrHTJm3KvvrI"} ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-05-21 06:13:32 [错误信息] => 事务(进程 ID 66)与另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务。 [sql] => update tr_shopcart set price='24.60000000',unit_no='斤',amount=24.60000000 * qty where goods_id='0000000005589' and open_id='1016';update tr_shopcart set price='27.00000000',unit_no='斤',amount=27.00000000 * qty where goods_id='0000000005925' and open_id='1016';update tr_shopcart set price='60.00000000',unit_no='只',amount=60.00000000 * qty where goods_id='0000000000894' and open_id='1016';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005749' and open_id='1016';update tr_shopcart set price='18.00000000',unit_no='只',amount=18.00000000 * qty where goods_id='0000000005137' and open_id='1016';update tr_shopcart set price='13.00000000',unit_no='斤',amount=13.00000000 * qty where goods_id='0000000005017' and open_id='1016';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001270' and open_id='1016';update tr_shopcart set price='4.20000000',unit_no='斤',amount=4.20000000 * qty where goods_id='0000000005840' and open_id='1016';update tr_shopcart set price='2.40000000',unit_no='斤',amount=2.40000000 * qty where goods_id='0000000005843' and open_id='1016';update tr_shopcart set price='2.20000000',unit_no='斤',amount=2.20000000 * qty where goods_id='0000000005845' and open_id='1016';update tr_shopcart set price='6.20000000',unit_no='斤',amount=6.20000000 * qty where goods_id='0000000005847' and open_id='1016';update tr_shopcart set price='1.40000000',unit_no='斤',amount=1.40000000 * qty where goods_id='0000000005859' and open_id='1016';update tr_shopcart set price='6.30000000',unit_no='斤',amount=6.30000000 * qty where goods_id='0000000001278' and open_id='1016';update tr_shopcart set price='4.30000000',unit_no='斤',amount=4.30000000 * qty where goods_id='0000000005759' and open_id='1016';update tr_shopcart set price='3.80000000',unit_no='盒',amount=3.80000000 * qty where goods_id='0000000005726' and open_id='1016';update tr_shopcart set price='3.68000000',unit_no='盒',amount=3.68000000 * qty where goods_id='0000000005722' and open_id='1016';update tr_shopcart set price='5.64000000',unit_no='盒',amount=5.64000000 * qty where goods_id='0000000005720' and open_id='1016';update tr_shopcart set price='5.20000000',unit_no='盒',amount=5.20000000 * qty where goods_id='0000000005717' and open_id='1016';update tr_shopcart set price='6.00000000',unit_no='包',amount=6.00000000 * qty where goods_id='0000000005716' and open_id='1016';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000001746' and open_id='1016';update tr_shopcart set price='1.90000000',unit_no='斤',amount=1.90000000 * qty where goods_id='0000000001747' and open_id='1016';update tr_shopcart set price='1.90000000',unit_no='斤',amount=1.90000000 * qty where goods_id='0000000001749' and open_id='1016';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005713' and open_id='1016';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005838' and open_id='1016';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000005839' and open_id='1016';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000001247' and open_id='1016';update tr_shopcart set price='1.90000000',unit_no='斤',amount=1.90000000 * qty where goods_id='0000000001271' and open_id='1016';update tr_shopcart set price='8.80000000',unit_no='斤',amount=8.80000000 * qty where goods_id='0000000005012' and open_id='1016';update tr_shopcart set price='14.30000000',unit_no='斤',amount=14.30000000 * qty where goods_id='0000000005909' and open_id='1016';update tr_shopcart set price='18.00000000',unit_no='斤',amount=18.00000000 * qty where goods_id='0000000005905' and open_id='1016';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005870' and open_id='1016';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005774' and open_id='1016';update tr_shopcart set price='1.99000000',unit_no='斤',amount=1.99000000 * qty where goods_id='0000000005773' and open_id='1016';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000001290' and open_id='1016';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000027' and open_id='1016';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000028' and open_id='1016';update tr_shopcart set price='5.30000000',unit_no='斤',amount=5.30000000 * qty where goods_id='0000000000031' and open_id='1016';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000000032' and open_id='1016';update tr_shopcart set price='3.30000000',unit_no='斤',amount=3.30000000 * qty where goods_id='0000000000934' and open_id='1016';update tr_shopcart set price='3.90000000',unit_no='斤',amount=3.90000000 * qty where goods_id='0000000000660' and open_id='1016';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000000964' and open_id='1016';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000001246' and open_id='1016';update tr_shopcart set price='5.20000000',unit_no='斤',amount=5.20000000 * qty where goods_id='0000000004688' and open_id='1016';update tr_shopcart set price='2.90000000',unit_no='斤',amount=2.90000000 * qty where goods_id='0000000005758' and open_id='1016';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005763' and open_id='1016';update tr_shopcart set price='4.70000000',unit_no='斤',amount=4.70000000 * qty where goods_id='0000000005765' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005484' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005485' and open_id='1016';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005488' and open_id='1016';update tr_shopcart set price='2.25000000',unit_no='斤',amount=2.25000000 * qty where goods_id='0000000005489' and open_id='1016';update tr_shopcart set price='1.40000000',unit_no='斤',amount=1.40000000 * qty where goods_id='0000000004780' and open_id='1016';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005712' and open_id='1016';update tr_shopcart set price='4.30000000',unit_no='斤',amount=4.30000000 * qty where goods_id='0000000004697' and open_id='1016';update tr_shopcart set price='20.00000000',unit_no='斤',amount=20.00000000 * qty where goods_id='0000000005938' and open_id='1016';update tr_shopcart set price='12.80000000',unit_no='斤',amount=12.80000000 * qty where goods_id='0000000005015' and open_id='1016';update tr_shopcart set price='11.00000000',unit_no='斤',amount=11.00000000 * qty where goods_id='0000000005897' and open_id='1016';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005862' and open_id='1016';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005867' and open_id='1016';update tr_shopcart set price='4.40000000',unit_no='斤',amount=4.40000000 * qty where goods_id='0000000005868' and open_id='1016';update tr_shopcart set price='4.70000000',unit_no='包',amount=4.70000000 * qty where goods_id='0000000005776' and open_id='1016';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005778' and open_id='1016';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000005799' and open_id='1016';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005803' and open_id='1016';update tr_shopcart set price='5.70000000',unit_no='斤',amount=5.70000000 * qty where goods_id='0000000005808' and open_id='1016';update tr_shopcart set price='4.30000000',unit_no='盒',amount=4.30000000 * qty where goods_id='0000000005820' and open_id='1016';update tr_shopcart set price='5.80000000',unit_no='斤',amount=5.80000000 * qty where goods_id='0000000005821' and open_id='1016';update tr_shopcart set price='6.10000000',unit_no='斤',amount=6.10000000 * qty where goods_id='0000000005823' and open_id='1016';update tr_shopcart set price='6.50000000',unit_no='斤',amount=6.50000000 * qty where goods_id='0000000005822' and open_id='1016';update tr_shopcart set price='1.10000000',unit_no='斤',amount=1.10000000 * qty where goods_id='0000000005827' and open_id='1016';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000004720' and open_id='1016';update tr_shopcart set price='6.30000000',unit_no='斤',amount=6.30000000 * qty where goods_id='0000000005754' and open_id='1016';update tr_shopcart set price='4.70000000',unit_no='斤',amount=4.70000000 * qty where goods_id='0000000005755' and open_id='1016';update tr_shopcart set price='12.00000000',unit_no='斤',amount=12.00000000 * qty where goods_id='0000000005756' and open_id='1016';update tr_shopcart set price='7.40000000',unit_no='斤',amount=7.40000000 * qty where goods_id='0000000005757' and open_id='1016';update tr_shopcart set price='7.90000000',unit_no='斤',amount=7.90000000 * qty where goods_id='0000000005767' and open_id='1016';update tr_shopcart set price='5.70000000',unit_no='斤',amount=5.70000000 * qty where goods_id='0000000005768' and open_id='1016';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005769' and open_id='1016';update tr_shopcart set price='3.80000000',unit_no='斤',amount=3.80000000 * qty where goods_id='0000000005810' and open_id='1016';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000000996' and open_id='1016';update tr_shopcart set price='5.00000000',unit_no='盒',amount=5.00000000 * qty where goods_id='0000000005727' and open_id='1016';update tr_shopcart set price='3.40000000',unit_no='包',amount=3.40000000 * qty where goods_id='0000000005725' and open_id='1016';update tr_shopcart set price='2.60000000',unit_no='盒',amount=2.60000000 * qty where goods_id='0000000005723' and open_id='1016';update tr_shopcart set price='5.64000000',unit_no='盒',amount=5.64000000 * qty where goods_id='0000000005719' and open_id='1016';update tr_shopcart set price='8.50000000',unit_no='包',amount=8.50000000 * qty where goods_id='0000000005702' and open_id='1016';update tr_shopcart set price='3.24000000',unit_no='斤',amount=3.24000000 * qty where goods_id='0000000005729' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005735' and open_id='1016';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005743' and open_id='1016';update tr_shopcart set price='2.20000000',unit_no='斤',amount=2.20000000 * qty where goods_id='0000000005746' and open_id='1016';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000005747' and open_id='1016';update tr_shopcart set price='2.25000000',unit_no='斤',amount=2.25000000 * qty where goods_id='0000000005423' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005482' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005483' and open_id='1016';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000000965' and open_id='1016';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000004769' and open_id='1016'; [详细] => 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteScalar() 在 Db.DBContext.ExecuteScalar(String sql, IDbDataParameter[] pars) 在 Api.BLL.b2b.ShopCartService.GetAll(String oper_id, String supcust_no) 在 Api.SingOut.b2b.mina.shopcart.get_all() [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.shopcart , [方法] => get_all [入参] => ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-05-21 06:43:21 [错误信息] => 事务(进程 ID 66)与另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务。 [sql] => update tr_shopcart set price='24.60000000',unit_no='斤',amount=24.60000000 * qty where goods_id='0000000005589' and open_id='1016';update tr_shopcart set price='27.00000000',unit_no='斤',amount=27.00000000 * qty where goods_id='0000000005925' and open_id='1016';update tr_shopcart set price='60.00000000',unit_no='只',amount=60.00000000 * qty where goods_id='0000000000894' and open_id='1016';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005749' and open_id='1016';update tr_shopcart set price='18.00000000',unit_no='只',amount=18.00000000 * qty where goods_id='0000000005137' and open_id='1016';update tr_shopcart set price='13.00000000',unit_no='斤',amount=13.00000000 * qty where goods_id='0000000005017' and open_id='1016';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001270' and open_id='1016';update tr_shopcart set price='4.20000000',unit_no='斤',amount=4.20000000 * qty where goods_id='0000000005840' and open_id='1016';update tr_shopcart set price='2.40000000',unit_no='斤',amount=2.40000000 * qty where goods_id='0000000005843' and open_id='1016';update tr_shopcart set price='2.20000000',unit_no='斤',amount=2.20000000 * qty where goods_id='0000000005845' and open_id='1016';update tr_shopcart set price='6.20000000',unit_no='斤',amount=6.20000000 * qty where goods_id='0000000005847' and open_id='1016';update tr_shopcart set price='1.40000000',unit_no='斤',amount=1.40000000 * qty where goods_id='0000000005859' and open_id='1016';update tr_shopcart set price='6.30000000',unit_no='斤',amount=6.30000000 * qty where goods_id='0000000001278' and open_id='1016';update tr_shopcart set price='4.30000000',unit_no='斤',amount=4.30000000 * qty where goods_id='0000000005759' and open_id='1016';update tr_shopcart set price='3.80000000',unit_no='盒',amount=3.80000000 * qty where goods_id='0000000005726' and open_id='1016';update tr_shopcart set price='3.68000000',unit_no='盒',amount=3.68000000 * qty where goods_id='0000000005722' and open_id='1016';update tr_shopcart set price='5.64000000',unit_no='盒',amount=5.64000000 * qty where goods_id='0000000005720' and open_id='1016';update tr_shopcart set price='5.20000000',unit_no='盒',amount=5.20000000 * qty where goods_id='0000000005717' and open_id='1016';update tr_shopcart set price='6.00000000',unit_no='包',amount=6.00000000 * qty where goods_id='0000000005716' and open_id='1016';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000001746' and open_id='1016';update tr_shopcart set price='1.90000000',unit_no='斤',amount=1.90000000 * qty where goods_id='0000000001747' and open_id='1016';update tr_shopcart set price='1.90000000',unit_no='斤',amount=1.90000000 * qty where goods_id='0000000001749' and open_id='1016';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005713' and open_id='1016';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005838' and open_id='1016';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000005839' and open_id='1016';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000001247' and open_id='1016';update tr_shopcart set price='1.90000000',unit_no='斤',amount=1.90000000 * qty where goods_id='0000000001271' and open_id='1016';update tr_shopcart set price='8.80000000',unit_no='斤',amount=8.80000000 * qty where goods_id='0000000005012' and open_id='1016';update tr_shopcart set price='14.30000000',unit_no='斤',amount=14.30000000 * qty where goods_id='0000000005909' and open_id='1016';update tr_shopcart set price='18.00000000',unit_no='斤',amount=18.00000000 * qty where goods_id='0000000005905' and open_id='1016';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005870' and open_id='1016';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005774' and open_id='1016';update tr_shopcart set price='1.99000000',unit_no='斤',amount=1.99000000 * qty where goods_id='0000000005773' and open_id='1016';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000001290' and open_id='1016';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000027' and open_id='1016';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000028' and open_id='1016';update tr_shopcart set price='5.30000000',unit_no='斤',amount=5.30000000 * qty where goods_id='0000000000031' and open_id='1016';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000000032' and open_id='1016';update tr_shopcart set price='3.30000000',unit_no='斤',amount=3.30000000 * qty where goods_id='0000000000934' and open_id='1016';update tr_shopcart set price='3.90000000',unit_no='斤',amount=3.90000000 * qty where goods_id='0000000000660' and open_id='1016';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000000964' and open_id='1016';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000001246' and open_id='1016';update tr_shopcart set price='5.20000000',unit_no='斤',amount=5.20000000 * qty where goods_id='0000000004688' and open_id='1016';update tr_shopcart set price='2.90000000',unit_no='斤',amount=2.90000000 * qty where goods_id='0000000005758' and open_id='1016';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005763' and open_id='1016';update tr_shopcart set price='4.70000000',unit_no='斤',amount=4.70000000 * qty where goods_id='0000000005765' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005484' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005485' and open_id='1016';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005488' and open_id='1016';update tr_shopcart set price='2.25000000',unit_no='斤',amount=2.25000000 * qty where goods_id='0000000005489' and open_id='1016';update tr_shopcart set price='1.40000000',unit_no='斤',amount=1.40000000 * qty where goods_id='0000000004780' and open_id='1016';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005712' and open_id='1016';update tr_shopcart set price='4.30000000',unit_no='斤',amount=4.30000000 * qty where goods_id='0000000004697' and open_id='1016';update tr_shopcart set price='20.00000000',unit_no='斤',amount=20.00000000 * qty where goods_id='0000000005938' and open_id='1016';update tr_shopcart set price='12.80000000',unit_no='斤',amount=12.80000000 * qty where goods_id='0000000005015' and open_id='1016';update tr_shopcart set price='11.00000000',unit_no='斤',amount=11.00000000 * qty where goods_id='0000000005897' and open_id='1016';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005862' and open_id='1016';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005867' and open_id='1016';update tr_shopcart set price='4.40000000',unit_no='斤',amount=4.40000000 * qty where goods_id='0000000005868' and open_id='1016';update tr_shopcart set price='4.70000000',unit_no='包',amount=4.70000000 * qty where goods_id='0000000005776' and open_id='1016';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005778' and open_id='1016';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000005799' and open_id='1016';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005803' and open_id='1016';update tr_shopcart set price='5.70000000',unit_no='斤',amount=5.70000000 * qty where goods_id='0000000005808' and open_id='1016';update tr_shopcart set price='4.30000000',unit_no='盒',amount=4.30000000 * qty where goods_id='0000000005820' and open_id='1016';update tr_shopcart set price='5.80000000',unit_no='斤',amount=5.80000000 * qty where goods_id='0000000005821' and open_id='1016';update tr_shopcart set price='6.10000000',unit_no='斤',amount=6.10000000 * qty where goods_id='0000000005823' and open_id='1016';update tr_shopcart set price='6.50000000',unit_no='斤',amount=6.50000000 * qty where goods_id='0000000005822' and open_id='1016';update tr_shopcart set price='1.10000000',unit_no='斤',amount=1.10000000 * qty where goods_id='0000000005827' and open_id='1016';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000004720' and open_id='1016';update tr_shopcart set price='6.30000000',unit_no='斤',amount=6.30000000 * qty where goods_id='0000000005754' and open_id='1016';update tr_shopcart set price='4.70000000',unit_no='斤',amount=4.70000000 * qty where goods_id='0000000005755' and open_id='1016';update tr_shopcart set price='12.00000000',unit_no='斤',amount=12.00000000 * qty where goods_id='0000000005756' and open_id='1016';update tr_shopcart set price='7.40000000',unit_no='斤',amount=7.40000000 * qty where goods_id='0000000005757' and open_id='1016';update tr_shopcart set price='7.90000000',unit_no='斤',amount=7.90000000 * qty where goods_id='0000000005767' and open_id='1016';update tr_shopcart set price='5.70000000',unit_no='斤',amount=5.70000000 * qty where goods_id='0000000005768' and open_id='1016';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005769' and open_id='1016';update tr_shopcart set price='3.80000000',unit_no='斤',amount=3.80000000 * qty where goods_id='0000000005810' and open_id='1016';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000000996' and open_id='1016';update tr_shopcart set price='5.00000000',unit_no='盒',amount=5.00000000 * qty where goods_id='0000000005727' and open_id='1016';update tr_shopcart set price='3.40000000',unit_no='包',amount=3.40000000 * qty where goods_id='0000000005725' and open_id='1016';update tr_shopcart set price='2.60000000',unit_no='盒',amount=2.60000000 * qty where goods_id='0000000005723' and open_id='1016';update tr_shopcart set price='5.64000000',unit_no='盒',amount=5.64000000 * qty where goods_id='0000000005719' and open_id='1016';update tr_shopcart set price='8.50000000',unit_no='包',amount=8.50000000 * qty where goods_id='0000000005702' and open_id='1016';update tr_shopcart set price='3.24000000',unit_no='斤',amount=3.24000000 * qty where goods_id='0000000005729' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005735' and open_id='1016';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005743' and open_id='1016';update tr_shopcart set price='2.20000000',unit_no='斤',amount=2.20000000 * qty where goods_id='0000000005746' and open_id='1016';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000005747' and open_id='1016';update tr_shopcart set price='2.25000000',unit_no='斤',amount=2.25000000 * qty where goods_id='0000000005423' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005482' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005483' and open_id='1016';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000000965' and open_id='1016';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000004769' and open_id='1016'; [详细] => 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteScalar() 在 Db.DBContext.ExecuteScalar(String sql, IDbDataParameter[] pars) 在 Api.BLL.b2b.ShopCartService.GetAll(String oper_id, String supcust_no) 在 Api.SingOut.b2b.mina.shopcart.get_all() [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.shopcart , [方法] => get_all [入参] => ************************************************************************************** ************************************************************************************** [意料之内的错误] ----- 2022-05-21 11:24:26 [错误信息] => 请先登录 [详细] => 在 Api.Helper.TokenHelper.VerToken(String token) 在 Api.BaseService.GetMethod(MethodInfo method, Dictionary`2 pairs) 在 Api.BaseService.ProcessRequest(HttpContext context) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.order , [方法] => get_order_list [入参] => {"keyword":"","day_num":"1000"} ************************************************************************************** **************************mima_b2b_Login()2022/5/21 11:24:38************************* paramter0:1016 paramter1:oDppT5Ak72H3rMVtdblJSKDi1fcw Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-05-21 11:24:38 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1016' or a.login_no = '1016' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1016","vip_pass":"122456","is_bind":"1","open_id":"oDppT5Ak72H3rMVtdblJSKDi1fcw"} ************************************************************************************** **************************mima_b2b_Login()2022/5/21 11:24:49************************* paramter0:1016 paramter1:oDppT5Ak72H3rMVtdblJSKDi1fcw Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-05-21 11:24:49 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1016' or a.login_no = '1016' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1016","vip_pass":"122456","is_bind":"1","open_id":"oDppT5Ak72H3rMVtdblJSKDi1fcw"} ************************************************************************************** **************************mima_b2b_Login()2022/5/21 11:49:24************************* paramter0:1019 paramter1:oDppT5DCoyPh77h5UwQAg8rLvW5s Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-05-21 11:49:24 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1019' or a.login_no = '1019' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1019","vip_pass":"0935","is_bind":"1","open_id":"oDppT5DCoyPh77h5UwQAg8rLvW5s"} ************************************************************************************** **************************mima_b2b_Login()2022/5/21 11:51:25************************* paramter0:1049 paramter1:oDppT5GP2QJkyiPruaV46GM9Ez7Y Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-05-21 11:51:25 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1049' or a.login_no = '1049' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1049","vip_pass":"123546","is_bind":"1","open_id":"oDppT5GP2QJkyiPruaV46GM9Ez7Y"} ************************************************************************************** ************************************************************************************** [意料之内的错误] ----- 2022-05-21 12:09:40 [错误信息] => 登录已失效 [详细] => 在 Api.BaseService.GetMethod(MethodInfo method, Dictionary`2 pairs) 在 Api.BaseService.ProcessRequest(HttpContext context) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.order , [方法] => get_order_list [入参] => {"keyword":"","day_num":"1000"} ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-05-21 12:10:00 [错误信息] => 事务(进程 ID 63)与另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务。 [sql] => update tr_shopcart set price='24.60000000',unit_no='斤',amount=24.60000000 * qty where goods_id='0000000005589' and open_id='1016';update tr_shopcart set price='27.00000000',unit_no='斤',amount=27.00000000 * qty where goods_id='0000000005925' and open_id='1016';update tr_shopcart set price='60.00000000',unit_no='只',amount=60.00000000 * qty where goods_id='0000000000894' and open_id='1016';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005749' and open_id='1016';update tr_shopcart set price='18.00000000',unit_no='只',amount=18.00000000 * qty where goods_id='0000000005137' and open_id='1016';update tr_shopcart set price='13.00000000',unit_no='斤',amount=13.00000000 * qty where goods_id='0000000005017' and open_id='1016';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001270' and open_id='1016';update tr_shopcart set price='4.20000000',unit_no='斤',amount=4.20000000 * qty where goods_id='0000000005840' and open_id='1016';update tr_shopcart set price='2.40000000',unit_no='斤',amount=2.40000000 * qty where goods_id='0000000005843' and open_id='1016';update tr_shopcart set price='2.20000000',unit_no='斤',amount=2.20000000 * qty where goods_id='0000000005845' and open_id='1016';update tr_shopcart set price='6.20000000',unit_no='斤',amount=6.20000000 * qty where goods_id='0000000005847' and open_id='1016';update tr_shopcart set price='1.40000000',unit_no='斤',amount=1.40000000 * qty where goods_id='0000000005859' and open_id='1016';update tr_shopcart set price='6.30000000',unit_no='斤',amount=6.30000000 * qty where goods_id='0000000001278' and open_id='1016';update tr_shopcart set price='4.30000000',unit_no='斤',amount=4.30000000 * qty where goods_id='0000000005759' and open_id='1016';update tr_shopcart set price='3.80000000',unit_no='盒',amount=3.80000000 * qty where goods_id='0000000005726' and open_id='1016';update tr_shopcart set price='3.68000000',unit_no='盒',amount=3.68000000 * qty where goods_id='0000000005722' and open_id='1016';update tr_shopcart set price='5.64000000',unit_no='盒',amount=5.64000000 * qty where goods_id='0000000005720' and open_id='1016';update tr_shopcart set price='5.20000000',unit_no='盒',amount=5.20000000 * qty where goods_id='0000000005717' and open_id='1016';update tr_shopcart set price='6.00000000',unit_no='包',amount=6.00000000 * qty where goods_id='0000000005716' and open_id='1016';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000001746' and open_id='1016';update tr_shopcart set price='1.90000000',unit_no='斤',amount=1.90000000 * qty where goods_id='0000000001747' and open_id='1016';update tr_shopcart set price='1.90000000',unit_no='斤',amount=1.90000000 * qty where goods_id='0000000001749' and open_id='1016';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005713' and open_id='1016';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005838' and open_id='1016';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000005839' and open_id='1016';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000001247' and open_id='1016';update tr_shopcart set price='1.90000000',unit_no='斤',amount=1.90000000 * qty where goods_id='0000000001271' and open_id='1016';update tr_shopcart set price='8.80000000',unit_no='斤',amount=8.80000000 * qty where goods_id='0000000005012' and open_id='1016';update tr_shopcart set price='14.30000000',unit_no='斤',amount=14.30000000 * qty where goods_id='0000000005909' and open_id='1016';update tr_shopcart set price='18.00000000',unit_no='斤',amount=18.00000000 * qty where goods_id='0000000005905' and open_id='1016';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005870' and open_id='1016';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005774' and open_id='1016';update tr_shopcart set price='1.99000000',unit_no='斤',amount=1.99000000 * qty where goods_id='0000000005773' and open_id='1016';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000001290' and open_id='1016';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000027' and open_id='1016';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000028' and open_id='1016';update tr_shopcart set price='5.30000000',unit_no='斤',amount=5.30000000 * qty where goods_id='0000000000031' and open_id='1016';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000000032' and open_id='1016';update tr_shopcart set price='3.30000000',unit_no='斤',amount=3.30000000 * qty where goods_id='0000000000934' and open_id='1016';update tr_shopcart set price='3.90000000',unit_no='斤',amount=3.90000000 * qty where goods_id='0000000000660' and open_id='1016';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000000964' and open_id='1016';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000001246' and open_id='1016';update tr_shopcart set price='5.20000000',unit_no='斤',amount=5.20000000 * qty where goods_id='0000000004688' and open_id='1016';update tr_shopcart set price='2.90000000',unit_no='斤',amount=2.90000000 * qty where goods_id='0000000005758' and open_id='1016';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005763' and open_id='1016';update tr_shopcart set price='4.70000000',unit_no='斤',amount=4.70000000 * qty where goods_id='0000000005765' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005484' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005485' and open_id='1016';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005488' and open_id='1016';update tr_shopcart set price='2.25000000',unit_no='斤',amount=2.25000000 * qty where goods_id='0000000005489' and open_id='1016';update tr_shopcart set price='1.40000000',unit_no='斤',amount=1.40000000 * qty where goods_id='0000000004780' and open_id='1016';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005712' and open_id='1016';update tr_shopcart set price='4.30000000',unit_no='斤',amount=4.30000000 * qty where goods_id='0000000004697' and open_id='1016';update tr_shopcart set price='20.00000000',unit_no='斤',amount=20.00000000 * qty where goods_id='0000000005938' and open_id='1016';update tr_shopcart set price='12.80000000',unit_no='斤',amount=12.80000000 * qty where goods_id='0000000005015' and open_id='1016';update tr_shopcart set price='11.00000000',unit_no='斤',amount=11.00000000 * qty where goods_id='0000000005897' and open_id='1016';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005862' and open_id='1016';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005867' and open_id='1016';update tr_shopcart set price='4.40000000',unit_no='斤',amount=4.40000000 * qty where goods_id='0000000005868' and open_id='1016';update tr_shopcart set price='4.70000000',unit_no='包',amount=4.70000000 * qty where goods_id='0000000005776' and open_id='1016';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005778' and open_id='1016';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000005799' and open_id='1016';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005803' and open_id='1016';update tr_shopcart set price='5.70000000',unit_no='斤',amount=5.70000000 * qty where goods_id='0000000005808' and open_id='1016';update tr_shopcart set price='4.30000000',unit_no='盒',amount=4.30000000 * qty where goods_id='0000000005820' and open_id='1016';update tr_shopcart set price='5.80000000',unit_no='斤',amount=5.80000000 * qty where goods_id='0000000005821' and open_id='1016';update tr_shopcart set price='6.10000000',unit_no='斤',amount=6.10000000 * qty where goods_id='0000000005823' and open_id='1016';update tr_shopcart set price='6.50000000',unit_no='斤',amount=6.50000000 * qty where goods_id='0000000005822' and open_id='1016';update tr_shopcart set price='1.10000000',unit_no='斤',amount=1.10000000 * qty where goods_id='0000000005827' and open_id='1016';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000004720' and open_id='1016';update tr_shopcart set price='6.30000000',unit_no='斤',amount=6.30000000 * qty where goods_id='0000000005754' and open_id='1016';update tr_shopcart set price='4.70000000',unit_no='斤',amount=4.70000000 * qty where goods_id='0000000005755' and open_id='1016';update tr_shopcart set price='12.00000000',unit_no='斤',amount=12.00000000 * qty where goods_id='0000000005756' and open_id='1016';update tr_shopcart set price='7.40000000',unit_no='斤',amount=7.40000000 * qty where goods_id='0000000005757' and open_id='1016';update tr_shopcart set price='7.90000000',unit_no='斤',amount=7.90000000 * qty where goods_id='0000000005767' and open_id='1016';update tr_shopcart set price='5.70000000',unit_no='斤',amount=5.70000000 * qty where goods_id='0000000005768' and open_id='1016';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005769' and open_id='1016';update tr_shopcart set price='3.80000000',unit_no='斤',amount=3.80000000 * qty where goods_id='0000000005810' and open_id='1016';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000000996' and open_id='1016';update tr_shopcart set price='5.00000000',unit_no='盒',amount=5.00000000 * qty where goods_id='0000000005727' and open_id='1016';update tr_shopcart set price='3.40000000',unit_no='包',amount=3.40000000 * qty where goods_id='0000000005725' and open_id='1016';update tr_shopcart set price='2.60000000',unit_no='盒',amount=2.60000000 * qty where goods_id='0000000005723' and open_id='1016';update tr_shopcart set price='5.64000000',unit_no='盒',amount=5.64000000 * qty where goods_id='0000000005719' and open_id='1016';update tr_shopcart set price='8.50000000',unit_no='包',amount=8.50000000 * qty where goods_id='0000000005702' and open_id='1016';update tr_shopcart set price='3.24000000',unit_no='斤',amount=3.24000000 * qty where goods_id='0000000005729' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005735' and open_id='1016';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005743' and open_id='1016';update tr_shopcart set price='2.20000000',unit_no='斤',amount=2.20000000 * qty where goods_id='0000000005746' and open_id='1016';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000005747' and open_id='1016';update tr_shopcart set price='2.25000000',unit_no='斤',amount=2.25000000 * qty where goods_id='0000000005423' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005482' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005483' and open_id='1016';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000000965' and open_id='1016';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000004769' and open_id='1016'; [详细] => 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteScalar() 在 Db.DBContext.ExecuteScalar(String sql, IDbDataParameter[] pars) 在 Api.BLL.b2b.ShopCartService.GetAll(String oper_id, String supcust_no) 在 Api.SingOut.b2b.mina.shopcart.get_all() [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.shopcart , [方法] => get_all [入参] => ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-05-21 13:33:25 [错误信息] => 事务(进程 ID 62)与另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务。 [sql] => update tr_shopcart set price='24.60000000',unit_no='斤',amount=24.60000000 * qty where goods_id='0000000005589' and open_id='1016';update tr_shopcart set price='27.00000000',unit_no='斤',amount=27.00000000 * qty where goods_id='0000000005925' and open_id='1016';update tr_shopcart set price='60.00000000',unit_no='只',amount=60.00000000 * qty where goods_id='0000000000894' and open_id='1016';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005749' and open_id='1016';update tr_shopcart set price='18.00000000',unit_no='只',amount=18.00000000 * qty where goods_id='0000000005137' and open_id='1016';update tr_shopcart set price='13.00000000',unit_no='斤',amount=13.00000000 * qty where goods_id='0000000005017' and open_id='1016';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001270' and open_id='1016';update tr_shopcart set price='4.20000000',unit_no='斤',amount=4.20000000 * qty where goods_id='0000000005840' and open_id='1016';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005843' and open_id='1016';update tr_shopcart set price='2.20000000',unit_no='斤',amount=2.20000000 * qty where goods_id='0000000005845' and open_id='1016';update tr_shopcart set price='6.20000000',unit_no='斤',amount=6.20000000 * qty where goods_id='0000000005847' and open_id='1016';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000005859' and open_id='1016';update tr_shopcart set price='6.30000000',unit_no='斤',amount=6.30000000 * qty where goods_id='0000000001278' and open_id='1016';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005759' and open_id='1016';update tr_shopcart set price='3.80000000',unit_no='盒',amount=3.80000000 * qty where goods_id='0000000005726' and open_id='1016';update tr_shopcart set price='3.68000000',unit_no='盒',amount=3.68000000 * qty where goods_id='0000000005722' and open_id='1016';update tr_shopcart set price='5.64000000',unit_no='盒',amount=5.64000000 * qty where goods_id='0000000005720' and open_id='1016';update tr_shopcart set price='5.20000000',unit_no='盒',amount=5.20000000 * qty where goods_id='0000000005717' and open_id='1016';update tr_shopcart set price='6.00000000',unit_no='包',amount=6.00000000 * qty where goods_id='0000000005716' and open_id='1016';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000001746' and open_id='1016';update tr_shopcart set price='1.90000000',unit_no='斤',amount=1.90000000 * qty where goods_id='0000000001747' and open_id='1016';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000001749' and open_id='1016';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005713' and open_id='1016';update tr_shopcart set price='4.90000000',unit_no='斤',amount=4.90000000 * qty where goods_id='0000000005838' and open_id='1016';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000005839' and open_id='1016';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000001247' and open_id='1016';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000001271' and open_id='1016';update tr_shopcart set price='8.80000000',unit_no='斤',amount=8.80000000 * qty where goods_id='0000000005012' and open_id='1016';update tr_shopcart set price='14.30000000',unit_no='斤',amount=14.30000000 * qty where goods_id='0000000005909' and open_id='1016';update tr_shopcart set price='18.00000000',unit_no='斤',amount=18.00000000 * qty where goods_id='0000000005905' and open_id='1016';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005870' and open_id='1016';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005774' and open_id='1016';update tr_shopcart set price='1.99000000',unit_no='斤',amount=1.99000000 * qty where goods_id='0000000005773' and open_id='1016';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000001290' and open_id='1016';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000027' and open_id='1016';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000028' and open_id='1016';update tr_shopcart set price='5.30000000',unit_no='斤',amount=5.30000000 * qty where goods_id='0000000000031' and open_id='1016';update tr_shopcart set price='6.50000000',unit_no='斤',amount=6.50000000 * qty where goods_id='0000000000032' and open_id='1016';update tr_shopcart set price='3.30000000',unit_no='斤',amount=3.30000000 * qty where goods_id='0000000000934' and open_id='1016';update tr_shopcart set price='4.20000000',unit_no='斤',amount=4.20000000 * qty where goods_id='0000000000660' and open_id='1016';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000000964' and open_id='1016';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000001246' and open_id='1016';update tr_shopcart set price='5.20000000',unit_no='斤',amount=5.20000000 * qty where goods_id='0000000004688' and open_id='1016';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005758' and open_id='1016';update tr_shopcart set price='6.50000000',unit_no='斤',amount=6.50000000 * qty where goods_id='0000000005763' and open_id='1016';update tr_shopcart set price='4.40000000',unit_no='斤',amount=4.40000000 * qty where goods_id='0000000005765' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005484' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005485' and open_id='1016';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005488' and open_id='1016';update tr_shopcart set price='2.25000000',unit_no='斤',amount=2.25000000 * qty where goods_id='0000000005489' and open_id='1016';update tr_shopcart set price='1.40000000',unit_no='斤',amount=1.40000000 * qty where goods_id='0000000004780' and open_id='1016';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005712' and open_id='1016';update tr_shopcart set price='4.20000000',unit_no='斤',amount=4.20000000 * qty where goods_id='0000000004697' and open_id='1016';update tr_shopcart set price='20.00000000',unit_no='斤',amount=20.00000000 * qty where goods_id='0000000005938' and open_id='1016';update tr_shopcart set price='12.80000000',unit_no='斤',amount=12.80000000 * qty where goods_id='0000000005015' and open_id='1016';update tr_shopcart set price='11.00000000',unit_no='斤',amount=11.00000000 * qty where goods_id='0000000005897' and open_id='1016';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005862' and open_id='1016';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005867' and open_id='1016';update tr_shopcart set price='4.40000000',unit_no='斤',amount=4.40000000 * qty where goods_id='0000000005868' and open_id='1016';update tr_shopcart set price='4.70000000',unit_no='包',amount=4.70000000 * qty where goods_id='0000000005776' and open_id='1016';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005778' and open_id='1016';update tr_shopcart set price='3.30000000',unit_no='斤',amount=3.30000000 * qty where goods_id='0000000005799' and open_id='1016';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005803' and open_id='1016';update tr_shopcart set price='5.70000000',unit_no='斤',amount=5.70000000 * qty where goods_id='0000000005808' and open_id='1016';update tr_shopcart set price='4.30000000',unit_no='盒',amount=4.30000000 * qty where goods_id='0000000005820' and open_id='1016';update tr_shopcart set price='6.20000000',unit_no='斤',amount=6.20000000 * qty where goods_id='0000000005821' and open_id='1016';update tr_shopcart set price='5.50000000',unit_no='斤',amount=5.50000000 * qty where goods_id='0000000005823' and open_id='1016';update tr_shopcart set price='6.80000000',unit_no='斤',amount=6.80000000 * qty where goods_id='0000000005822' and open_id='1016';update tr_shopcart set price='1.10000000',unit_no='斤',amount=1.10000000 * qty where goods_id='0000000005827' and open_id='1016';update tr_shopcart set price='6.30000000',unit_no='斤',amount=6.30000000 * qty where goods_id='0000000004720' and open_id='1016';update tr_shopcart set price='6.30000000',unit_no='斤',amount=6.30000000 * qty where goods_id='0000000005754' and open_id='1016';update tr_shopcart set price='4.70000000',unit_no='斤',amount=4.70000000 * qty where goods_id='0000000005755' and open_id='1016';update tr_shopcart set price='12.00000000',unit_no='斤',amount=12.00000000 * qty where goods_id='0000000005756' and open_id='1016';update tr_shopcart set price='7.80000000',unit_no='斤',amount=7.80000000 * qty where goods_id='0000000005757' and open_id='1016';update tr_shopcart set price='8.20000000',unit_no='斤',amount=8.20000000 * qty where goods_id='0000000005767' and open_id='1016';update tr_shopcart set price='6.20000000',unit_no='斤',amount=6.20000000 * qty where goods_id='0000000005768' and open_id='1016';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005769' and open_id='1016';update tr_shopcart set price='4.10000000',unit_no='斤',amount=4.10000000 * qty where goods_id='0000000005810' and open_id='1016';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000000996' and open_id='1016';update tr_shopcart set price='5.00000000',unit_no='盒',amount=5.00000000 * qty where goods_id='0000000005727' and open_id='1016';update tr_shopcart set price='3.40000000',unit_no='包',amount=3.40000000 * qty where goods_id='0000000005725' and open_id='1016';update tr_shopcart set price='2.60000000',unit_no='盒',amount=2.60000000 * qty where goods_id='0000000005723' and open_id='1016';update tr_shopcart set price='5.64000000',unit_no='盒',amount=5.64000000 * qty where goods_id='0000000005719' and open_id='1016';update tr_shopcart set price='8.50000000',unit_no='包',amount=8.50000000 * qty where goods_id='0000000005702' and open_id='1016';update tr_shopcart set price='3.24000000',unit_no='斤',amount=3.24000000 * qty where goods_id='0000000005729' and open_id='1016';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005735' and open_id='1016';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005743' and open_id='1016';update tr_shopcart set price='2.20000000',unit_no='斤',amount=2.20000000 * qty where goods_id='0000000005746' and open_id='1016';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000005747' and open_id='1016';update tr_shopcart set price='2.25000000',unit_no='斤',amount=2.25000000 * qty where goods_id='0000000005423' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005482' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005483' and open_id='1016';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000000965' and open_id='1016';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000004769' and open_id='1016'; [详细] => 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteScalar() 在 Db.DBContext.ExecuteScalar(String sql, IDbDataParameter[] pars) 在 Api.BLL.b2b.ShopCartService.GetAll(String oper_id, String supcust_no) 在 Api.SingOut.b2b.mina.shopcart.get_all() [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.shopcart , [方法] => get_all [入参] => ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-05-21 13:36:00 [错误信息] => 事务(进程 ID 62)与另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务。 [sql] => update tr_shopcart set price='24.60000000',unit_no='斤',amount=24.60000000 * qty where goods_id='0000000005589' and open_id='1016';update tr_shopcart set price='27.00000000',unit_no='斤',amount=27.00000000 * qty where goods_id='0000000005925' and open_id='1016';update tr_shopcart set price='60.00000000',unit_no='只',amount=60.00000000 * qty where goods_id='0000000000894' and open_id='1016';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005749' and open_id='1016';update tr_shopcart set price='18.00000000',unit_no='只',amount=18.00000000 * qty where goods_id='0000000005137' and open_id='1016';update tr_shopcart set price='13.00000000',unit_no='斤',amount=13.00000000 * qty where goods_id='0000000005017' and open_id='1016';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001270' and open_id='1016';update tr_shopcart set price='4.20000000',unit_no='斤',amount=4.20000000 * qty where goods_id='0000000005840' and open_id='1016';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005843' and open_id='1016';update tr_shopcart set price='2.20000000',unit_no='斤',amount=2.20000000 * qty where goods_id='0000000005845' and open_id='1016';update tr_shopcart set price='6.20000000',unit_no='斤',amount=6.20000000 * qty where goods_id='0000000005847' and open_id='1016';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000005859' and open_id='1016';update tr_shopcart set price='6.30000000',unit_no='斤',amount=6.30000000 * qty where goods_id='0000000001278' and open_id='1016';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005759' and open_id='1016';update tr_shopcart set price='3.80000000',unit_no='盒',amount=3.80000000 * qty where goods_id='0000000005726' and open_id='1016';update tr_shopcart set price='3.68000000',unit_no='盒',amount=3.68000000 * qty where goods_id='0000000005722' and open_id='1016';update tr_shopcart set price='5.64000000',unit_no='盒',amount=5.64000000 * qty where goods_id='0000000005720' and open_id='1016';update tr_shopcart set price='5.20000000',unit_no='盒',amount=5.20000000 * qty where goods_id='0000000005717' and open_id='1016';update tr_shopcart set price='6.00000000',unit_no='包',amount=6.00000000 * qty where goods_id='0000000005716' and open_id='1016';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000001746' and open_id='1016';update tr_shopcart set price='1.90000000',unit_no='斤',amount=1.90000000 * qty where goods_id='0000000001747' and open_id='1016';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000001749' and open_id='1016';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005713' and open_id='1016';update tr_shopcart set price='4.90000000',unit_no='斤',amount=4.90000000 * qty where goods_id='0000000005838' and open_id='1016';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000005839' and open_id='1016';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000001247' and open_id='1016';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000001271' and open_id='1016';update tr_shopcart set price='8.80000000',unit_no='斤',amount=8.80000000 * qty where goods_id='0000000005012' and open_id='1016';update tr_shopcart set price='14.30000000',unit_no='斤',amount=14.30000000 * qty where goods_id='0000000005909' and open_id='1016';update tr_shopcart set price='18.00000000',unit_no='斤',amount=18.00000000 * qty where goods_id='0000000005905' and open_id='1016';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005870' and open_id='1016';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005774' and open_id='1016';update tr_shopcart set price='1.99000000',unit_no='斤',amount=1.99000000 * qty where goods_id='0000000005773' and open_id='1016';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000001290' and open_id='1016';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000027' and open_id='1016';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000028' and open_id='1016';update tr_shopcart set price='5.30000000',unit_no='斤',amount=5.30000000 * qty where goods_id='0000000000031' and open_id='1016';update tr_shopcart set price='6.50000000',unit_no='斤',amount=6.50000000 * qty where goods_id='0000000000032' and open_id='1016';update tr_shopcart set price='3.30000000',unit_no='斤',amount=3.30000000 * qty where goods_id='0000000000934' and open_id='1016';update tr_shopcart set price='4.20000000',unit_no='斤',amount=4.20000000 * qty where goods_id='0000000000660' and open_id='1016';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000000964' and open_id='1016';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000001246' and open_id='1016';update tr_shopcart set price='5.20000000',unit_no='斤',amount=5.20000000 * qty where goods_id='0000000004688' and open_id='1016';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005758' and open_id='1016';update tr_shopcart set price='6.50000000',unit_no='斤',amount=6.50000000 * qty where goods_id='0000000005763' and open_id='1016';update tr_shopcart set price='4.40000000',unit_no='斤',amount=4.40000000 * qty where goods_id='0000000005765' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005484' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005485' and open_id='1016';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005488' and open_id='1016';update tr_shopcart set price='2.25000000',unit_no='斤',amount=2.25000000 * qty where goods_id='0000000005489' and open_id='1016';update tr_shopcart set price='1.40000000',unit_no='斤',amount=1.40000000 * qty where goods_id='0000000004780' and open_id='1016';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005712' and open_id='1016';update tr_shopcart set price='4.20000000',unit_no='斤',amount=4.20000000 * qty where goods_id='0000000004697' and open_id='1016';update tr_shopcart set price='20.00000000',unit_no='斤',amount=20.00000000 * qty where goods_id='0000000005938' and open_id='1016';update tr_shopcart set price='12.80000000',unit_no='斤',amount=12.80000000 * qty where goods_id='0000000005015' and open_id='1016';update tr_shopcart set price='11.00000000',unit_no='斤',amount=11.00000000 * qty where goods_id='0000000005897' and open_id='1016';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005862' and open_id='1016';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005867' and open_id='1016';update tr_shopcart set price='4.40000000',unit_no='斤',amount=4.40000000 * qty where goods_id='0000000005868' and open_id='1016';update tr_shopcart set price='4.70000000',unit_no='包',amount=4.70000000 * qty where goods_id='0000000005776' and open_id='1016';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005778' and open_id='1016';update tr_shopcart set price='3.30000000',unit_no='斤',amount=3.30000000 * qty where goods_id='0000000005799' and open_id='1016';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005803' and open_id='1016';update tr_shopcart set price='5.70000000',unit_no='斤',amount=5.70000000 * qty where goods_id='0000000005808' and open_id='1016';update tr_shopcart set price='4.30000000',unit_no='盒',amount=4.30000000 * qty where goods_id='0000000005820' and open_id='1016';update tr_shopcart set price='6.20000000',unit_no='斤',amount=6.20000000 * qty where goods_id='0000000005821' and open_id='1016';update tr_shopcart set price='5.50000000',unit_no='斤',amount=5.50000000 * qty where goods_id='0000000005823' and open_id='1016';update tr_shopcart set price='6.80000000',unit_no='斤',amount=6.80000000 * qty where goods_id='0000000005822' and open_id='1016';update tr_shopcart set price='1.10000000',unit_no='斤',amount=1.10000000 * qty where goods_id='0000000005827' and open_id='1016';update tr_shopcart set price='6.30000000',unit_no='斤',amount=6.30000000 * qty where goods_id='0000000004720' and open_id='1016';update tr_shopcart set price='6.30000000',unit_no='斤',amount=6.30000000 * qty where goods_id='0000000005754' and open_id='1016';update tr_shopcart set price='4.70000000',unit_no='斤',amount=4.70000000 * qty where goods_id='0000000005755' and open_id='1016';update tr_shopcart set price='12.00000000',unit_no='斤',amount=12.00000000 * qty where goods_id='0000000005756' and open_id='1016';update tr_shopcart set price='7.80000000',unit_no='斤',amount=7.80000000 * qty where goods_id='0000000005757' and open_id='1016';update tr_shopcart set price='8.20000000',unit_no='斤',amount=8.20000000 * qty where goods_id='0000000005767' and open_id='1016';update tr_shopcart set price='6.20000000',unit_no='斤',amount=6.20000000 * qty where goods_id='0000000005768' and open_id='1016';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005769' and open_id='1016';update tr_shopcart set price='4.10000000',unit_no='斤',amount=4.10000000 * qty where goods_id='0000000005810' and open_id='1016';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000000996' and open_id='1016';update tr_shopcart set price='5.00000000',unit_no='盒',amount=5.00000000 * qty where goods_id='0000000005727' and open_id='1016';update tr_shopcart set price='3.40000000',unit_no='包',amount=3.40000000 * qty where goods_id='0000000005725' and open_id='1016';update tr_shopcart set price='2.60000000',unit_no='盒',amount=2.60000000 * qty where goods_id='0000000005723' and open_id='1016';update tr_shopcart set price='5.64000000',unit_no='盒',amount=5.64000000 * qty where goods_id='0000000005719' and open_id='1016';update tr_shopcart set price='8.50000000',unit_no='包',amount=8.50000000 * qty where goods_id='0000000005702' and open_id='1016';update tr_shopcart set price='3.24000000',unit_no='斤',amount=3.24000000 * qty where goods_id='0000000005729' and open_id='1016';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005735' and open_id='1016';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005743' and open_id='1016';update tr_shopcart set price='2.20000000',unit_no='斤',amount=2.20000000 * qty where goods_id='0000000005746' and open_id='1016';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000005747' and open_id='1016';update tr_shopcart set price='2.25000000',unit_no='斤',amount=2.25000000 * qty where goods_id='0000000005423' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005482' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005483' and open_id='1016';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000000965' and open_id='1016';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000004769' and open_id='1016'; [详细] => 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteScalar() 在 Db.DBContext.ExecuteScalar(String sql, IDbDataParameter[] pars) 在 Api.BLL.b2b.ShopCartService.GetAll(String oper_id, String supcust_no) 在 Api.SingOut.b2b.mina.shopcart.get_all() [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.shopcart , [方法] => get_all [入参] => ************************************************************************************** **************************mima_b2b_Login()2022/5/21 13:36:29************************* paramter0:1016 paramter1:oDppT5KO4cX4mPb8nBsH6OI0jZWU Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-05-21 13:36:29 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1016' or a.login_no = '1016' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1016","vip_pass":"12345","is_bind":"1","open_id":"oDppT5KO4cX4mPb8nBsH6OI0jZWU"} ************************************************************************************** **************************mima_b2b_Login()2022/5/21 13:36:30************************* paramter0:1016 paramter1:oDppT5KO4cX4mPb8nBsH6OI0jZWU Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-05-21 13:36:30 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1016' or a.login_no = '1016' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1016","vip_pass":"12345","is_bind":"1","open_id":"oDppT5KO4cX4mPb8nBsH6OI0jZWU"} ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-05-21 13:37:03 [错误信息] => 事务(进程 ID 62)与另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务。 [sql] => update tr_shopcart set price='24.60000000',unit_no='斤',amount=24.60000000 * qty where goods_id='0000000005589' and open_id='1016';update tr_shopcart set price='27.00000000',unit_no='斤',amount=27.00000000 * qty where goods_id='0000000005925' and open_id='1016';update tr_shopcart set price='60.00000000',unit_no='只',amount=60.00000000 * qty where goods_id='0000000000894' and open_id='1016';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005749' and open_id='1016';update tr_shopcart set price='18.00000000',unit_no='只',amount=18.00000000 * qty where goods_id='0000000005137' and open_id='1016';update tr_shopcart set price='13.00000000',unit_no='斤',amount=13.00000000 * qty where goods_id='0000000005017' and open_id='1016';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001270' and open_id='1016';update tr_shopcart set price='4.20000000',unit_no='斤',amount=4.20000000 * qty where goods_id='0000000005840' and open_id='1016';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005843' and open_id='1016';update tr_shopcart set price='2.20000000',unit_no='斤',amount=2.20000000 * qty where goods_id='0000000005845' and open_id='1016';update tr_shopcart set price='6.20000000',unit_no='斤',amount=6.20000000 * qty where goods_id='0000000005847' and open_id='1016';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000005859' and open_id='1016';update tr_shopcart set price='6.30000000',unit_no='斤',amount=6.30000000 * qty where goods_id='0000000001278' and open_id='1016';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005759' and open_id='1016';update tr_shopcart set price='3.80000000',unit_no='盒',amount=3.80000000 * qty where goods_id='0000000005726' and open_id='1016';update tr_shopcart set price='3.68000000',unit_no='盒',amount=3.68000000 * qty where goods_id='0000000005722' and open_id='1016';update tr_shopcart set price='5.64000000',unit_no='盒',amount=5.64000000 * qty where goods_id='0000000005720' and open_id='1016';update tr_shopcart set price='5.20000000',unit_no='盒',amount=5.20000000 * qty where goods_id='0000000005717' and open_id='1016';update tr_shopcart set price='6.00000000',unit_no='包',amount=6.00000000 * qty where goods_id='0000000005716' and open_id='1016';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000001746' and open_id='1016';update tr_shopcart set price='1.90000000',unit_no='斤',amount=1.90000000 * qty where goods_id='0000000001747' and open_id='1016';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000001749' and open_id='1016';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005713' and open_id='1016';update tr_shopcart set price='4.90000000',unit_no='斤',amount=4.90000000 * qty where goods_id='0000000005838' and open_id='1016';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000005839' and open_id='1016';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000001247' and open_id='1016';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000001271' and open_id='1016';update tr_shopcart set price='8.80000000',unit_no='斤',amount=8.80000000 * qty where goods_id='0000000005012' and open_id='1016';update tr_shopcart set price='14.30000000',unit_no='斤',amount=14.30000000 * qty where goods_id='0000000005909' and open_id='1016';update tr_shopcart set price='18.00000000',unit_no='斤',amount=18.00000000 * qty where goods_id='0000000005905' and open_id='1016';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005870' and open_id='1016';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005774' and open_id='1016';update tr_shopcart set price='1.99000000',unit_no='斤',amount=1.99000000 * qty where goods_id='0000000005773' and open_id='1016';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000001290' and open_id='1016';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000027' and open_id='1016';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000028' and open_id='1016';update tr_shopcart set price='5.30000000',unit_no='斤',amount=5.30000000 * qty where goods_id='0000000000031' and open_id='1016';update tr_shopcart set price='6.50000000',unit_no='斤',amount=6.50000000 * qty where goods_id='0000000000032' and open_id='1016';update tr_shopcart set price='3.30000000',unit_no='斤',amount=3.30000000 * qty where goods_id='0000000000934' and open_id='1016';update tr_shopcart set price='4.20000000',unit_no='斤',amount=4.20000000 * qty where goods_id='0000000000660' and open_id='1016';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000000964' and open_id='1016';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000001246' and open_id='1016';update tr_shopcart set price='5.20000000',unit_no='斤',amount=5.20000000 * qty where goods_id='0000000004688' and open_id='1016';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005758' and open_id='1016';update tr_shopcart set price='6.50000000',unit_no='斤',amount=6.50000000 * qty where goods_id='0000000005763' and open_id='1016';update tr_shopcart set price='4.40000000',unit_no='斤',amount=4.40000000 * qty where goods_id='0000000005765' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005484' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005485' and open_id='1016';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005488' and open_id='1016';update tr_shopcart set price='2.25000000',unit_no='斤',amount=2.25000000 * qty where goods_id='0000000005489' and open_id='1016';update tr_shopcart set price='1.40000000',unit_no='斤',amount=1.40000000 * qty where goods_id='0000000004780' and open_id='1016';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005712' and open_id='1016';update tr_shopcart set price='4.20000000',unit_no='斤',amount=4.20000000 * qty where goods_id='0000000004697' and open_id='1016';update tr_shopcart set price='20.00000000',unit_no='斤',amount=20.00000000 * qty where goods_id='0000000005938' and open_id='1016';update tr_shopcart set price='12.80000000',unit_no='斤',amount=12.80000000 * qty where goods_id='0000000005015' and open_id='1016';update tr_shopcart set price='11.00000000',unit_no='斤',amount=11.00000000 * qty where goods_id='0000000005897' and open_id='1016';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005862' and open_id='1016';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005867' and open_id='1016';update tr_shopcart set price='4.40000000',unit_no='斤',amount=4.40000000 * qty where goods_id='0000000005868' and open_id='1016';update tr_shopcart set price='4.70000000',unit_no='包',amount=4.70000000 * qty where goods_id='0000000005776' and open_id='1016';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005778' and open_id='1016';update tr_shopcart set price='3.30000000',unit_no='斤',amount=3.30000000 * qty where goods_id='0000000005799' and open_id='1016';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005803' and open_id='1016';update tr_shopcart set price='5.70000000',unit_no='斤',amount=5.70000000 * qty where goods_id='0000000005808' and open_id='1016';update tr_shopcart set price='4.30000000',unit_no='盒',amount=4.30000000 * qty where goods_id='0000000005820' and open_id='1016';update tr_shopcart set price='6.20000000',unit_no='斤',amount=6.20000000 * qty where goods_id='0000000005821' and open_id='1016';update tr_shopcart set price='5.50000000',unit_no='斤',amount=5.50000000 * qty where goods_id='0000000005823' and open_id='1016';update tr_shopcart set price='6.80000000',unit_no='斤',amount=6.80000000 * qty where goods_id='0000000005822' and open_id='1016';update tr_shopcart set price='1.10000000',unit_no='斤',amount=1.10000000 * qty where goods_id='0000000005827' and open_id='1016';update tr_shopcart set price='6.30000000',unit_no='斤',amount=6.30000000 * qty where goods_id='0000000004720' and open_id='1016';update tr_shopcart set price='6.30000000',unit_no='斤',amount=6.30000000 * qty where goods_id='0000000005754' and open_id='1016';update tr_shopcart set price='4.70000000',unit_no='斤',amount=4.70000000 * qty where goods_id='0000000005755' and open_id='1016';update tr_shopcart set price='12.00000000',unit_no='斤',amount=12.00000000 * qty where goods_id='0000000005756' and open_id='1016';update tr_shopcart set price='7.80000000',unit_no='斤',amount=7.80000000 * qty where goods_id='0000000005757' and open_id='1016';update tr_shopcart set price='8.20000000',unit_no='斤',amount=8.20000000 * qty where goods_id='0000000005767' and open_id='1016';update tr_shopcart set price='6.20000000',unit_no='斤',amount=6.20000000 * qty where goods_id='0000000005768' and open_id='1016';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005769' and open_id='1016';update tr_shopcart set price='4.10000000',unit_no='斤',amount=4.10000000 * qty where goods_id='0000000005810' and open_id='1016';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000000996' and open_id='1016';update tr_shopcart set price='5.00000000',unit_no='盒',amount=5.00000000 * qty where goods_id='0000000005727' and open_id='1016';update tr_shopcart set price='3.40000000',unit_no='包',amount=3.40000000 * qty where goods_id='0000000005725' and open_id='1016';update tr_shopcart set price='2.60000000',unit_no='盒',amount=2.60000000 * qty where goods_id='0000000005723' and open_id='1016';update tr_shopcart set price='5.64000000',unit_no='盒',amount=5.64000000 * qty where goods_id='0000000005719' and open_id='1016';update tr_shopcart set price='8.50000000',unit_no='包',amount=8.50000000 * qty where goods_id='0000000005702' and open_id='1016';update tr_shopcart set price='3.24000000',unit_no='斤',amount=3.24000000 * qty where goods_id='0000000005729' and open_id='1016';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005735' and open_id='1016';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005743' and open_id='1016';update tr_shopcart set price='2.20000000',unit_no='斤',amount=2.20000000 * qty where goods_id='0000000005746' and open_id='1016';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000005747' and open_id='1016';update tr_shopcart set price='2.25000000',unit_no='斤',amount=2.25000000 * qty where goods_id='0000000005423' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005482' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005483' and open_id='1016';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000000965' and open_id='1016';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000004769' and open_id='1016'; [详细] => 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteScalar() 在 Db.DBContext.ExecuteScalar(String sql, IDbDataParameter[] pars) 在 Api.BLL.b2b.ShopCartService.GetAll(String oper_id, String supcust_no) 在 Api.SingOut.b2b.mina.shopcart.get_all() [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.shopcart , [方法] => get_all [入参] => ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-05-21 13:37:08 [错误信息] => 事务(进程 ID 64)与另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务。 [sql] => update tr_shopcart set price='24.60000000',unit_no='斤',amount=24.60000000 * qty where goods_id='0000000005589' and open_id='1016';update tr_shopcart set price='27.00000000',unit_no='斤',amount=27.00000000 * qty where goods_id='0000000005925' and open_id='1016';update tr_shopcart set price='60.00000000',unit_no='只',amount=60.00000000 * qty where goods_id='0000000000894' and open_id='1016';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005749' and open_id='1016';update tr_shopcart set price='18.00000000',unit_no='只',amount=18.00000000 * qty where goods_id='0000000005137' and open_id='1016';update tr_shopcart set price='13.00000000',unit_no='斤',amount=13.00000000 * qty where goods_id='0000000005017' and open_id='1016';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001270' and open_id='1016';update tr_shopcart set price='4.20000000',unit_no='斤',amount=4.20000000 * qty where goods_id='0000000005840' and open_id='1016';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005843' and open_id='1016';update tr_shopcart set price='2.20000000',unit_no='斤',amount=2.20000000 * qty where goods_id='0000000005845' and open_id='1016';update tr_shopcart set price='6.20000000',unit_no='斤',amount=6.20000000 * qty where goods_id='0000000005847' and open_id='1016';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000005859' and open_id='1016';update tr_shopcart set price='6.30000000',unit_no='斤',amount=6.30000000 * qty where goods_id='0000000001278' and open_id='1016';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005759' and open_id='1016';update tr_shopcart set price='3.80000000',unit_no='盒',amount=3.80000000 * qty where goods_id='0000000005726' and open_id='1016';update tr_shopcart set price='3.68000000',unit_no='盒',amount=3.68000000 * qty where goods_id='0000000005722' and open_id='1016';update tr_shopcart set price='5.64000000',unit_no='盒',amount=5.64000000 * qty where goods_id='0000000005720' and open_id='1016';update tr_shopcart set price='5.20000000',unit_no='盒',amount=5.20000000 * qty where goods_id='0000000005717' and open_id='1016';update tr_shopcart set price='6.00000000',unit_no='包',amount=6.00000000 * qty where goods_id='0000000005716' and open_id='1016';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000001746' and open_id='1016';update tr_shopcart set price='1.90000000',unit_no='斤',amount=1.90000000 * qty where goods_id='0000000001747' and open_id='1016';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000001749' and open_id='1016';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005713' and open_id='1016';update tr_shopcart set price='4.90000000',unit_no='斤',amount=4.90000000 * qty where goods_id='0000000005838' and open_id='1016';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000005839' and open_id='1016';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000001247' and open_id='1016';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000001271' and open_id='1016';update tr_shopcart set price='8.80000000',unit_no='斤',amount=8.80000000 * qty where goods_id='0000000005012' and open_id='1016';update tr_shopcart set price='14.30000000',unit_no='斤',amount=14.30000000 * qty where goods_id='0000000005909' and open_id='1016';update tr_shopcart set price='18.00000000',unit_no='斤',amount=18.00000000 * qty where goods_id='0000000005905' and open_id='1016';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005870' and open_id='1016';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005774' and open_id='1016';update tr_shopcart set price='1.99000000',unit_no='斤',amount=1.99000000 * qty where goods_id='0000000005773' and open_id='1016';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000001290' and open_id='1016';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000027' and open_id='1016';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000028' and open_id='1016';update tr_shopcart set price='5.30000000',unit_no='斤',amount=5.30000000 * qty where goods_id='0000000000031' and open_id='1016';update tr_shopcart set price='6.50000000',unit_no='斤',amount=6.50000000 * qty where goods_id='0000000000032' and open_id='1016';update tr_shopcart set price='3.30000000',unit_no='斤',amount=3.30000000 * qty where goods_id='0000000000934' and open_id='1016';update tr_shopcart set price='4.20000000',unit_no='斤',amount=4.20000000 * qty where goods_id='0000000000660' and open_id='1016';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000000964' and open_id='1016';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000001246' and open_id='1016';update tr_shopcart set price='5.20000000',unit_no='斤',amount=5.20000000 * qty where goods_id='0000000004688' and open_id='1016';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005758' and open_id='1016';update tr_shopcart set price='6.50000000',unit_no='斤',amount=6.50000000 * qty where goods_id='0000000005763' and open_id='1016';update tr_shopcart set price='4.40000000',unit_no='斤',amount=4.40000000 * qty where goods_id='0000000005765' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005484' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005485' and open_id='1016';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005488' and open_id='1016';update tr_shopcart set price='2.25000000',unit_no='斤',amount=2.25000000 * qty where goods_id='0000000005489' and open_id='1016';update tr_shopcart set price='1.40000000',unit_no='斤',amount=1.40000000 * qty where goods_id='0000000004780' and open_id='1016';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005712' and open_id='1016';update tr_shopcart set price='4.20000000',unit_no='斤',amount=4.20000000 * qty where goods_id='0000000004697' and open_id='1016';update tr_shopcart set price='20.00000000',unit_no='斤',amount=20.00000000 * qty where goods_id='0000000005938' and open_id='1016';update tr_shopcart set price='12.80000000',unit_no='斤',amount=12.80000000 * qty where goods_id='0000000005015' and open_id='1016';update tr_shopcart set price='11.00000000',unit_no='斤',amount=11.00000000 * qty where goods_id='0000000005897' and open_id='1016';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005862' and open_id='1016';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005867' and open_id='1016';update tr_shopcart set price='4.40000000',unit_no='斤',amount=4.40000000 * qty where goods_id='0000000005868' and open_id='1016';update tr_shopcart set price='4.70000000',unit_no='包',amount=4.70000000 * qty where goods_id='0000000005776' and open_id='1016';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005778' and open_id='1016';update tr_shopcart set price='3.30000000',unit_no='斤',amount=3.30000000 * qty where goods_id='0000000005799' and open_id='1016';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005803' and open_id='1016';update tr_shopcart set price='5.70000000',unit_no='斤',amount=5.70000000 * qty where goods_id='0000000005808' and open_id='1016';update tr_shopcart set price='4.30000000',unit_no='盒',amount=4.30000000 * qty where goods_id='0000000005820' and open_id='1016';update tr_shopcart set price='6.20000000',unit_no='斤',amount=6.20000000 * qty where goods_id='0000000005821' and open_id='1016';update tr_shopcart set price='5.50000000',unit_no='斤',amount=5.50000000 * qty where goods_id='0000000005823' and open_id='1016';update tr_shopcart set price='6.80000000',unit_no='斤',amount=6.80000000 * qty where goods_id='0000000005822' and open_id='1016';update tr_shopcart set price='1.10000000',unit_no='斤',amount=1.10000000 * qty where goods_id='0000000005827' and open_id='1016';update tr_shopcart set price='6.30000000',unit_no='斤',amount=6.30000000 * qty where goods_id='0000000004720' and open_id='1016';update tr_shopcart set price='6.30000000',unit_no='斤',amount=6.30000000 * qty where goods_id='0000000005754' and open_id='1016';update tr_shopcart set price='4.70000000',unit_no='斤',amount=4.70000000 * qty where goods_id='0000000005755' and open_id='1016';update tr_shopcart set price='12.00000000',unit_no='斤',amount=12.00000000 * qty where goods_id='0000000005756' and open_id='1016';update tr_shopcart set price='7.80000000',unit_no='斤',amount=7.80000000 * qty where goods_id='0000000005757' and open_id='1016';update tr_shopcart set price='8.20000000',unit_no='斤',amount=8.20000000 * qty where goods_id='0000000005767' and open_id='1016';update tr_shopcart set price='6.20000000',unit_no='斤',amount=6.20000000 * qty where goods_id='0000000005768' and open_id='1016';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005769' and open_id='1016';update tr_shopcart set price='4.10000000',unit_no='斤',amount=4.10000000 * qty where goods_id='0000000005810' and open_id='1016';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000000996' and open_id='1016';update tr_shopcart set price='5.00000000',unit_no='盒',amount=5.00000000 * qty where goods_id='0000000005727' and open_id='1016';update tr_shopcart set price='3.40000000',unit_no='包',amount=3.40000000 * qty where goods_id='0000000005725' and open_id='1016';update tr_shopcart set price='2.60000000',unit_no='盒',amount=2.60000000 * qty where goods_id='0000000005723' and open_id='1016';update tr_shopcart set price='5.64000000',unit_no='盒',amount=5.64000000 * qty where goods_id='0000000005719' and open_id='1016';update tr_shopcart set price='8.50000000',unit_no='包',amount=8.50000000 * qty where goods_id='0000000005702' and open_id='1016';update tr_shopcart set price='3.24000000',unit_no='斤',amount=3.24000000 * qty where goods_id='0000000005729' and open_id='1016';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005735' and open_id='1016';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005743' and open_id='1016';update tr_shopcart set price='2.20000000',unit_no='斤',amount=2.20000000 * qty where goods_id='0000000005746' and open_id='1016';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000005747' and open_id='1016';update tr_shopcart set price='2.25000000',unit_no='斤',amount=2.25000000 * qty where goods_id='0000000005423' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005482' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005483' and open_id='1016';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000000965' and open_id='1016';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000004769' and open_id='1016'; [详细] => 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteScalar() 在 Db.DBContext.ExecuteScalar(String sql, IDbDataParameter[] pars) 在 Api.BLL.b2b.ShopCartService.GetAll(String oper_id, String supcust_no) 在 Api.SingOut.b2b.mina.shopcart.get_all() [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.shopcart , [方法] => get_all [入参] => ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-05-21 13:37:13 [错误信息] => 事务(进程 ID 63)与另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务。 [sql] => update tr_shopcart set price='24.60000000',unit_no='斤',amount=24.60000000 * qty where goods_id='0000000005589' and open_id='1016';update tr_shopcart set price='27.00000000',unit_no='斤',amount=27.00000000 * qty where goods_id='0000000005925' and open_id='1016';update tr_shopcart set price='60.00000000',unit_no='只',amount=60.00000000 * qty where goods_id='0000000000894' and open_id='1016';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005749' and open_id='1016';update tr_shopcart set price='18.00000000',unit_no='只',amount=18.00000000 * qty where goods_id='0000000005137' and open_id='1016';update tr_shopcart set price='13.00000000',unit_no='斤',amount=13.00000000 * qty where goods_id='0000000005017' and open_id='1016';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001270' and open_id='1016';update tr_shopcart set price='4.20000000',unit_no='斤',amount=4.20000000 * qty where goods_id='0000000005840' and open_id='1016';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005843' and open_id='1016';update tr_shopcart set price='2.20000000',unit_no='斤',amount=2.20000000 * qty where goods_id='0000000005845' and open_id='1016';update tr_shopcart set price='6.20000000',unit_no='斤',amount=6.20000000 * qty where goods_id='0000000005847' and open_id='1016';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000005859' and open_id='1016';update tr_shopcart set price='6.30000000',unit_no='斤',amount=6.30000000 * qty where goods_id='0000000001278' and open_id='1016';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005759' and open_id='1016';update tr_shopcart set price='3.80000000',unit_no='盒',amount=3.80000000 * qty where goods_id='0000000005726' and open_id='1016';update tr_shopcart set price='3.68000000',unit_no='盒',amount=3.68000000 * qty where goods_id='0000000005722' and open_id='1016';update tr_shopcart set price='5.64000000',unit_no='盒',amount=5.64000000 * qty where goods_id='0000000005720' and open_id='1016';update tr_shopcart set price='5.20000000',unit_no='盒',amount=5.20000000 * qty where goods_id='0000000005717' and open_id='1016';update tr_shopcart set price='6.00000000',unit_no='包',amount=6.00000000 * qty where goods_id='0000000005716' and open_id='1016';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000001746' and open_id='1016';update tr_shopcart set price='1.90000000',unit_no='斤',amount=1.90000000 * qty where goods_id='0000000001747' and open_id='1016';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000001749' and open_id='1016';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005713' and open_id='1016';update tr_shopcart set price='4.90000000',unit_no='斤',amount=4.90000000 * qty where goods_id='0000000005838' and open_id='1016';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000005839' and open_id='1016';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000001247' and open_id='1016';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000001271' and open_id='1016';update tr_shopcart set price='8.80000000',unit_no='斤',amount=8.80000000 * qty where goods_id='0000000005012' and open_id='1016';update tr_shopcart set price='14.30000000',unit_no='斤',amount=14.30000000 * qty where goods_id='0000000005909' and open_id='1016';update tr_shopcart set price='18.00000000',unit_no='斤',amount=18.00000000 * qty where goods_id='0000000005905' and open_id='1016';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005870' and open_id='1016';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005774' and open_id='1016';update tr_shopcart set price='1.99000000',unit_no='斤',amount=1.99000000 * qty where goods_id='0000000005773' and open_id='1016';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000001290' and open_id='1016';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000027' and open_id='1016';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000028' and open_id='1016';update tr_shopcart set price='5.30000000',unit_no='斤',amount=5.30000000 * qty where goods_id='0000000000031' and open_id='1016';update tr_shopcart set price='6.50000000',unit_no='斤',amount=6.50000000 * qty where goods_id='0000000000032' and open_id='1016';update tr_shopcart set price='3.30000000',unit_no='斤',amount=3.30000000 * qty where goods_id='0000000000934' and open_id='1016';update tr_shopcart set price='4.20000000',unit_no='斤',amount=4.20000000 * qty where goods_id='0000000000660' and open_id='1016';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000000964' and open_id='1016';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000001246' and open_id='1016';update tr_shopcart set price='5.20000000',unit_no='斤',amount=5.20000000 * qty where goods_id='0000000004688' and open_id='1016';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005758' and open_id='1016';update tr_shopcart set price='6.50000000',unit_no='斤',amount=6.50000000 * qty where goods_id='0000000005763' and open_id='1016';update tr_shopcart set price='4.40000000',unit_no='斤',amount=4.40000000 * qty where goods_id='0000000005765' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005484' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005485' and open_id='1016';update tr_shopcart set price='1.88000000',unit_no='斤',amount=1.88000000 * qty where goods_id='0000000005488' and open_id='1016';update tr_shopcart set price='2.25000000',unit_no='斤',amount=2.25000000 * qty where goods_id='0000000005489' and open_id='1016';update tr_shopcart set price='1.40000000',unit_no='斤',amount=1.40000000 * qty where goods_id='0000000004780' and open_id='1016';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005712' and open_id='1016';update tr_shopcart set price='4.20000000',unit_no='斤',amount=4.20000000 * qty where goods_id='0000000004697' and open_id='1016';update tr_shopcart set price='20.00000000',unit_no='斤',amount=20.00000000 * qty where goods_id='0000000005938' and open_id='1016';update tr_shopcart set price='12.80000000',unit_no='斤',amount=12.80000000 * qty where goods_id='0000000005015' and open_id='1016';update tr_shopcart set price='11.00000000',unit_no='斤',amount=11.00000000 * qty where goods_id='0000000005897' and open_id='1016';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005862' and open_id='1016';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005867' and open_id='1016';update tr_shopcart set price='4.40000000',unit_no='斤',amount=4.40000000 * qty where goods_id='0000000005868' and open_id='1016';update tr_shopcart set price='4.70000000',unit_no='包',amount=4.70000000 * qty where goods_id='0000000005776' and open_id='1016';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005778' and open_id='1016';update tr_shopcart set price='3.30000000',unit_no='斤',amount=3.30000000 * qty where goods_id='0000000005799' and open_id='1016';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005803' and open_id='1016';update tr_shopcart set price='5.70000000',unit_no='斤',amount=5.70000000 * qty where goods_id='0000000005808' and open_id='1016';update tr_shopcart set price='4.30000000',unit_no='盒',amount=4.30000000 * qty where goods_id='0000000005820' and open_id='1016';update tr_shopcart set price='6.20000000',unit_no='斤',amount=6.20000000 * qty where goods_id='0000000005821' and open_id='1016';update tr_shopcart set price='5.50000000',unit_no='斤',amount=5.50000000 * qty where goods_id='0000000005823' and open_id='1016';update tr_shopcart set price='6.80000000',unit_no='斤',amount=6.80000000 * qty where goods_id='0000000005822' and open_id='1016';update tr_shopcart set price='1.10000000',unit_no='斤',amount=1.10000000 * qty where goods_id='0000000005827' and open_id='1016';update tr_shopcart set price='6.30000000',unit_no='斤',amount=6.30000000 * qty where goods_id='0000000004720' and open_id='1016';update tr_shopcart set price='6.30000000',unit_no='斤',amount=6.30000000 * qty where goods_id='0000000005754' and open_id='1016';update tr_shopcart set price='4.70000000',unit_no='斤',amount=4.70000000 * qty where goods_id='0000000005755' and open_id='1016';update tr_shopcart set price='12.00000000',unit_no='斤',amount=12.00000000 * qty where goods_id='0000000005756' and open_id='1016';update tr_shopcart set price='7.80000000',unit_no='斤',amount=7.80000000 * qty where goods_id='0000000005757' and open_id='1016';update tr_shopcart set price='8.20000000',unit_no='斤',amount=8.20000000 * qty where goods_id='0000000005767' and open_id='1016';update tr_shopcart set price='6.20000000',unit_no='斤',amount=6.20000000 * qty where goods_id='0000000005768' and open_id='1016';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005769' and open_id='1016';update tr_shopcart set price='4.10000000',unit_no='斤',amount=4.10000000 * qty where goods_id='0000000005810' and open_id='1016';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000000996' and open_id='1016';update tr_shopcart set price='5.00000000',unit_no='盒',amount=5.00000000 * qty where goods_id='0000000005727' and open_id='1016';update tr_shopcart set price='3.40000000',unit_no='包',amount=3.40000000 * qty where goods_id='0000000005725' and open_id='1016';update tr_shopcart set price='2.60000000',unit_no='盒',amount=2.60000000 * qty where goods_id='0000000005723' and open_id='1016';update tr_shopcart set price='5.64000000',unit_no='盒',amount=5.64000000 * qty where goods_id='0000000005719' and open_id='1016';update tr_shopcart set price='8.50000000',unit_no='包',amount=8.50000000 * qty where goods_id='0000000005702' and open_id='1016';update tr_shopcart set price='3.24000000',unit_no='斤',amount=3.24000000 * qty where goods_id='0000000005729' and open_id='1016';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005735' and open_id='1016';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005743' and open_id='1016';update tr_shopcart set price='2.20000000',unit_no='斤',amount=2.20000000 * qty where goods_id='0000000005746' and open_id='1016';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000005747' and open_id='1016';update tr_shopcart set price='2.25000000',unit_no='斤',amount=2.25000000 * qty where goods_id='0000000005423' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005482' and open_id='1016';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005483' and open_id='1016';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000000965' and open_id='1016';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000004769' and open_id='1016'; [详细] => 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteScalar() 在 Db.DBContext.ExecuteScalar(String sql, IDbDataParameter[] pars) 在 Api.BLL.b2b.ShopCartService.GetAll(String oper_id, String supcust_no) 在 Api.SingOut.b2b.mina.shopcart.get_all() [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.shopcart , [方法] => get_all [入参] => ************************************************************************************** **************************mima_b2b_Login()2022/5/21 16:21:05************************* paramter0:1001 paramter1:oDppT5Kb943oOPk_mWfBHq-JK4fY Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-05-21 16:21:05 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1001' or a.login_no = '1001' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1001","vip_pass":"888888","is_bind":"1","open_id":"oDppT5Kb943oOPk_mWfBHq-JK4fY"} ************************************************************************************** **************************mima_b2b_Login()2022/5/21 16:21:08************************* paramter0:1001 paramter1:oDppT5Kb943oOPk_mWfBHq-JK4fY Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-05-21 16:21:08 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1001' or a.login_no = '1001' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1001","vip_pass":"88888888","is_bind":"1","open_id":"oDppT5Kb943oOPk_mWfBHq-JK4fY"} ************************************************************************************** **************************mima_b2b_Login()2022/5/21 16:21:09************************* paramter0:1001 paramter1:oDppT5Kb943oOPk_mWfBHq-JK4fY Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-05-21 16:21:09 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1001' or a.login_no = '1001' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1001","vip_pass":"88888888","is_bind":"1","open_id":"oDppT5Kb943oOPk_mWfBHq-JK4fY"} ************************************************************************************** **************************mima_b2b_Login()2022/5/21 16:21:18************************* paramter0:1001 paramter1:oDppT5Kb943oOPk_mWfBHq-JK4fY Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-05-21 16:21:18 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1001' or a.login_no = '1001' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1001","vip_pass":"13392471581","is_bind":"1","open_id":"oDppT5Kb943oOPk_mWfBHq-JK4fY"} ************************************************************************************** **************************mima_b2b_Login()2022/5/21 16:21:28************************* paramter0:1001 paramter1:oDppT5Kb943oOPk_mWfBHq-JK4fY Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-05-21 16:21:28 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1001' or a.login_no = '1001' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1001","vip_pass":"13392471581","is_bind":"1","open_id":"oDppT5Kb943oOPk_mWfBHq-JK4fY"} ************************************************************************************** **************************mima_b2b_Login()2022/5/21 16:21:34************************* paramter0:1001 paramter1:oDppT5Kb943oOPk_mWfBHq-JK4fY Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-05-21 16:21:34 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1001' or a.login_no = '1001' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1001","vip_pass":"12445678","is_bind":"1","open_id":"oDppT5Kb943oOPk_mWfBHq-JK4fY"} ************************************************************************************** **************************mima_b2b_Login()2022/5/21 16:21:37************************* paramter0:1001 paramter1:oDppT5Kb943oOPk_mWfBHq-JK4fY Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-05-21 16:21:37 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1001' or a.login_no = '1001' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1001","vip_pass":"124456","is_bind":"1","open_id":"oDppT5Kb943oOPk_mWfBHq-JK4fY"} ************************************************************************************** **************************mima_b2b_Login()2022/5/21 16:31:51************************* paramter0:1018 paramter1:oDppT5G5VqzsLvJBRCGP9v97gxco Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-05-21 16:31:51 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1018' or a.login_no = '1018' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1018","vip_pass":"*23456","is_bind":"1","open_id":"oDppT5G5VqzsLvJBRCGP9v97gxco"} ************************************************************************************** **************************mima_b2b_Login()2022/5/21 16:39:44************************* paramter0: paramter1:oDppT5LA2r2mZEl5I4mrSjrG79tQ Api.Helper.Exceptions.KatException: 用户不存在 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-05-21 16:39:44 [错误信息] => 用户不存在 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '' or a.login_no = '' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"","vip_pass":"","is_bind":"1","open_id":"oDppT5LA2r2mZEl5I4mrSjrG79tQ"} ************************************************************************************** **************************mima_b2b_Login()2022/5/21 16:42:15************************* paramter0:1027 paramter1:oDppT5HC1yFwmH-lQ4602MhtxMqw Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-05-21 16:42:15 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1027' or a.login_no = '1027' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1027","vip_pass":"1027","is_bind":"1","open_id":"oDppT5HC1yFwmH-lQ4602MhtxMqw"} ************************************************************************************** **************************mima_b2b_Login()2022/5/21 16:42:17************************* paramter0:1027 paramter1:oDppT5HC1yFwmH-lQ4602MhtxMqw Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-05-21 16:42:17 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1027' or a.login_no = '1027' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1027","vip_pass":"1027","is_bind":"1","open_id":"oDppT5HC1yFwmH-lQ4602MhtxMqw"} ************************************************************************************** **************************mima_b2b_Login()2022/5/21 16:46:53************************* paramter0:1024 paramter1:oDppT5KQOW41o2XEF6ROdDmQ4heU Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-05-21 16:46:53 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1024' or a.login_no = '1024' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1024","vip_pass":"1024","is_bind":"1","open_id":"oDppT5KQOW41o2XEF6ROdDmQ4heU"} ************************************************************************************** **************************mima_b2b_Login()2022/5/21 16:47:01************************* paramter0:1024 paramter1:oDppT5KQOW41o2XEF6ROdDmQ4heU Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-05-21 16:47:01 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1024' or a.login_no = '1024' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1024","vip_pass":"1024","is_bind":"1","open_id":"oDppT5KQOW41o2XEF6ROdDmQ4heU"} ************************************************************************************** ************************************************************************************** [意料之内的错误] ----- 2022-05-21 21:13:55 [错误信息] => 请先登录 [详细] => 在 Api.Helper.TokenHelper.VerToken(String token) 在 Api.BaseService.GetMethod(MethodInfo method, Dictionary`2 pairs) 在 Api.BaseService.ProcessRequest(HttpContext context) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.shopcart , [方法] => get_all [入参] => ************************************************************************************** ************************************************************************************** [意料之内的错误] ----- 2022-05-21 21:13:55 [错误信息] => 请先登录 [详细] => 在 Api.Helper.TokenHelper.VerToken(String token) 在 Api.BaseService.GetMethod(MethodInfo method, Dictionary`2 pairs) 在 Api.BaseService.ProcessRequest(HttpContext context) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.shopcart , [方法] => get_all [入参] => ************************************************************************************** **************************mima_b2b_Login()2022/5/21 22:19:40************************* paramter0:10001 paramter1:oDppT5KaKDUU1lQb87hcEZWLroAs Api.Helper.Exceptions.KatException: 用户不存在 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-05-21 22:19:40 [错误信息] => 用户不存在 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '10001' or a.login_no = '10001' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"10001","vip_pass":"123456","is_bind":"1","open_id":"oDppT5KaKDUU1lQb87hcEZWLroAs"} **************************************************************************************